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

[..hidden..]

Revision: 6944
          http://sourceforge.net/p/ledger-smb/code/6944
Author:   einhverfr
Date:     2014-03-19 08:01:59 +0000 (Wed, 19 Mar 2014)
Log Message:
-----------
More natural person fixes for payments/receipts

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

Modified: trunk/sql/modules/Payment.sql
===================================================================
--- trunk/sql/modules/Payment.sql	2014-03-19 07:43:57 UTC (rev 6943)
+++ trunk/sql/modules/Payment.sql	2014-03-19 08:01:59 UTC (rev 6944)
@@ -48,14 +48,13 @@
 
  BEGIN
  	FOR out_entity IN
-              SELECT ec.id, cp.legal_name || 
+              SELECT ec.id, e.name || 
                      coalesce(':' || ec.description,'') as name, 
                      e.entity_class, ec.discount_account_id, ec.meta_number
  		FROM entity_credit_account ec
  		JOIN entity e ON (ec.entity_id = e.id)
- 		JOIN company cp ON (cp.entity_id = e.id)
 		WHERE ec.entity_class = in_account_class
-		AND (cp.legal_name ilike coalesce('%'||in_vc_name||'%','%%') OR cp.tax_id = in_vc_idn)
+		AND (e.name ilike coalesce('%'||in_vc_name||'%','%%') OR cp.tax_id = in_vc_idn)
 	LOOP
 		RETURN NEXT out_entity;
 	END LOOP;

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