[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

SF.net SVN: ledger-smb:[6943] trunk/sql/modules/Payment.sql

Revision: 6943
Author:   einhverfr
Date:     2014-03-19 07:43:57 +0000 (Wed, 19 Mar 2014)
Log Message:
Single payment interface should work with natural person customers and vendors now

Modified Paths:

Modified: trunk/sql/modules/Payment.sql
--- trunk/sql/modules/Payment.sql	2014-03-18 14:47:30 UTC (rev 6942)
+++ trunk/sql/modules/Payment.sql	2014-03-19 07:43:57 UTC (rev 6943)
@@ -96,10 +96,9 @@
 DECLARE out_entity entity%ROWTYPE;
         FOR out_entity IN
-                SELECT ec.id, cp.legal_name as name, e.entity_class, e.created
+                SELECT ec.id, e.name as name, e.entity_class, e.created
                 FROM entity e
                 JOIN entity_credit_account ec ON (ec.entity_id = e.id)
-                JOIN company cp ON (cp.entity_id = e.id)
                         WHERE ec.entity_class = in_account_class
                         AND CASE WHEN in_account_class = 1 THEN
                                 ec.id IN

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

Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
Ledger-smb-commits mailing list