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

[..hidden..]

Revision: 2756
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2756&view=rev
Author:   einhverfr
Date:     2009-08-21 16:04:31 +0000 (Fri, 21 Aug 2009)

Log Message:
-----------
Minor fixes on pay_to_name

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

Modified: trunk/sql/modules/Company.sql
===================================================================
--- trunk/sql/modules/Company.sql	2009-08-18 17:20:01 UTC (rev 2755)
+++ trunk/sql/modules/Company.sql	2009-08-21 16:04:31 UTC (rev 2756)
@@ -194,7 +194,8 @@
         cash_account_id int,
         threshold numeric,
 	control_code text,
-	credit_id int
+	credit_id int,
+	pay_to_name text
 );
 
 COMMENT ON TYPE entity_credit_search_return IS
@@ -228,7 +229,7 @@
 			ec.language_code, 
 			ec.pricegroup_id, ec.curr, ec.startdate, 
 			ec.enddate, ec.ar_ap_account_id, ec.cash_account_id, 
-			ec.threshold, e.control_code, ec.id
+			ec.threshold, e.control_code, ec.id, ec.pay_to_name
 		FROM company c
 		JOIN entity e ON (c.entity_id = e.id)
 		JOIN entity_credit_account ec ON (c.entity_id = ec.entity_id)


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