SF.net SVN: ledger-smb:[2832] trunk/sql/modules/test/data/Reconciliation. sql

[..hidden..]

Revision: 2832
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2832&view=rev
Author:   aurynn_cmd
Date:     2009-12-22 01:19:55 +0000 (Tue, 22 Dec 2009)

Log Message:
-----------
Updates to the test cases to add a currency value to the AR inserts.

Modified Paths:
--------------
    trunk/sql/modules/test/data/Reconciliation.sql

Modified: trunk/sql/modules/test/data/Reconciliation.sql
===================================================================
--- trunk/sql/modules/test/data/Reconciliation.sql	2009-12-22 01:10:49 UTC (rev 2831)
+++ trunk/sql/modules/test/data/Reconciliation.sql	2009-12-22 01:19:55 UTC (rev 2832)
@@ -9,15 +9,15 @@
 INSERT INTO entity_credit_account (entity_id, id, meta_number, entity_class, ar_ap_account_id) values (-200, -201, 'T-11112', 1, -1000);
 
 
-INSERT INTO ar (id, invnumber, amount, netamount, paid, entity_credit_account, transdate) values (-200, '-2000', '10', '10', '0', -200, '1000-01-01');
-INSERT INTO ar (id, invnumber, amount, netamount, paid, entity_credit_account, transdate) values (-201, '-2001', '10', '10', '0', -200, '1000-01-03');
-INSERT INTO ar (id, invnumber, amount, netamount, paid, entity_credit_account, transdate) values (-204, '-2002', '10', '10', '0', -200, '1000-01-01');
-INSERT INTO ar (id, invnumber, amount, netamount, paid, entity_credit_account, transdate) values (-205, '-2003', '10', '10', '0', -200, '1000-01-03');
+INSERT INTO ar (id, invnumber, amount, netamount, paid, entity_credit_account, transdate, curr) values (-200, '-2000', '10', '10', '0', -200, '1000-01-01', 'USD');
+INSERT INTO ar (id, invnumber, amount, netamount, paid, entity_credit_account, transdate, curr) values (-201, '-2001', '10', '10', '0', -200, '1000-01-03', 'USD');
+INSERT INTO ar (id, invnumber, amount, netamount, paid, entity_credit_account, transdate, curr) values (-204, '-2002', '10', '10', '0', -200, '1000-01-01', 'USD');
+INSERT INTO ar (id, invnumber, amount, netamount, paid, entity_credit_account, transdate, curr) values (-205, '-2003', '10', '10', '0', -200, '1000-01-03', 'USD');
 
-INSERT INTO ar (id, invnumber, amount, netamount, paid, entity_credit_account, transdate) values (-206, '-2004', '10', '10', '0', -201, '1000-01-01');
-INSERT INTO ar (id, invnumber, amount, netamount, paid, entity_credit_account, transdate) values (-207, '-2005', '10', '10', '0', -201, '1000-01-03');
-INSERT INTO ar (id, invnumber, amount, netamount, paid, entity_credit_account, transdate) values (-208, '-2006', '10', '10', '0', -201, '1000-01-01');
-INSERT INTO ar (id, invnumber, amount, netamount, paid, entity_credit_account, transdate) values (-209, '-2007', '10', '10', '0', -201, '1000-01-03');
+INSERT INTO ar (id, invnumber, amount, netamount, paid, entity_credit_account, transdate, curr) values (-206, '-2004', '10', '10', '0', -201, '1000-01-01', 'USD');
+INSERT INTO ar (id, invnumber, amount, netamount, paid, entity_credit_account, transdate, curr) values (-207, '-2005', '10', '10', '0', -201, '1000-01-03', 'USD');
+INSERT INTO ar (id, invnumber, amount, netamount, paid, entity_credit_account, transdate, curr) values (-208, '-2006', '10', '10', '0', -201, '1000-01-01', 'USD');
+INSERT INTO ar (id, invnumber, amount, netamount, paid, entity_credit_account, transdate, curr) values (-209, '-2007', '10', '10', '0', -201, '1000-01-03', 'USD');
 
 INSERT INTO gl (id, reference, transdate) values (-202, 'Recon gl test 1', '1000-01-01');
 INSERT INTO gl (id, reference, transdate) values (-203, 'Recon gl test 2', '1000-01-01');


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