SF.net SVN: ledger-smb:[2242] trunk/sql/modules/Company.sql

[..hidden..]

Revision: 2242
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2242&view=rev
Author:   einhverfr
Date:     2008-08-08 05:11:41 +0000 (Fri, 08 Aug 2008)

Log Message:
-----------
Adding meta_number to company_billing_info return set

Modified Paths:
--------------
    trunk/sql/modules/Company.sql

Modified: trunk/sql/modules/Company.sql
===================================================================
--- trunk/sql/modules/Company.sql	2008-08-07 23:06:25 UTC (rev 2241)
+++ trunk/sql/modules/Company.sql	2008-08-08 05:11:41 UTC (rev 2242)
@@ -247,6 +247,7 @@
 
 CREATE TYPE company_billing_info AS (
 legal_name text,
+meta_number text,
 tax_id text,
 street1 text,
 street2 text,
@@ -263,7 +264,7 @@
 DECLARE out_var company_billing_info;
 	t_id INT;
 BEGIN
-	select c.legal_name, c.tax_id, a.line_one, a.line_two, a.line_three, 
+	select c.legal_name, eca.meta_number, c.tax_id, a.line_one, a.line_two, a.line_three, 
 		a.city, a.state, a.mail_code, cc.name
 	into out_var
 	FROM company c


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.