SF.net SVN: ledger-smb:[4380] trunk/sql

[..hidden..]

Revision: 4380
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4380&view=rev
Author:   einhverfr
Date:     2012-03-05 07:21:29 +0000 (Mon, 05 Mar 2012)
Log Message:
-----------
Correcting load error on reconciliation module

Modified Paths:
--------------
    trunk/sql/Pg-database.sql
    trunk/sql/modules/Reconciliation.sql

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2012-03-05 03:25:57 UTC (rev 4379)
+++ trunk/sql/Pg-database.sql	2012-03-05 07:21:29 UTC (rev 4380)
@@ -1067,7 +1067,7 @@
     insert_time TIMESTAMPTZ NOT NULL DEFAULT now(),
     trans_type text, 
     post_date date,
-    ledger_id int,
+    ledger_id int references acc_trans(entry_id),
     overlook boolean not null default 'f',
     cleared boolean not null default 'f'
 );

Modified: trunk/sql/modules/Reconciliation.sql
===================================================================
--- trunk/sql/modules/Reconciliation.sql	2012-03-05 03:25:57 UTC (rev 4379)
+++ trunk/sql/modules/Reconciliation.sql	2012-03-05 07:21:29 UTC (rev 4380)
@@ -556,7 +556,7 @@
 this is the credit balance.$$;
 
 CREATE OR REPLACE VIEW recon_payee AS
- SELECT n.name AS payee, rr.id, rr.report_id, rr.scn, rr.their_balance, rr.our_balance, rr.errorcode, rr."user", rr.clear_time, rr.insert_time, rr.trans_type, rr.post_date, rr.ledger_id, rr.voucher_id, rr.overlook, rr.cleared
+ SELECT n.name AS payee, rr.id, rr.report_id, rr.scn, rr.their_balance, rr.our_balance, rr.errorcode, rr."user", rr.clear_time, rr.insert_time, rr.trans_type, rr.post_date, rr.ledger_id, ac.voucher_id, rr.overlook, rr.cleared
    FROM cr_report_line rr
    LEFT JOIN acc_trans ac ON rr.ledger_id = ac.entry_id
    LEFT JOIN gl ON ac.trans_id = gl.id

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