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

[..hidden..]

Revision: 6943
          http://sourceforge.net/p/ledger-smb/code/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:
--------------
    trunk/sql/modules/Payment.sql

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;
 BEGIN
         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!
http://p.sf.net/sfu/13534_NeoTech
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits