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

[..hidden..]

Revision: 184
          http://svn.sourceforge.net/ledger-smb/?rev=184&view=rev
Author:   tetragon
Date:     2006-10-02 19:05:40 -0700 (Mon, 02 Oct 2006)

Log Message:
-----------
Update Canadian GST rates.

Modified Paths:
--------------
    trunk/sql/Canada-English_General-chart.sql
    trunk/sql/Canada-French_General-chart.sql

Modified: trunk/sql/Canada-English_General-chart.sql
===================================================================
--- trunk/sql/Canada-English_General-chart.sql	2006-10-02 23:40:18 UTC (rev 183)
+++ trunk/sql/Canada-English_General-chart.sql	2006-10-03 02:05:40 UTC (rev 184)
@@ -63,7 +63,7 @@
 insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5790','Utilities','A','8812','E','AP_amount');
 insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5800','Licenses','A','8760','E','AP_amount');
 --
-insert into tax (chart_id,rate) values ((select id from chart where accno = '2310'),0.07);
+insert into tax (chart_id,rate) values ((select id from chart where accno = '2310'),0.06);
 insert into tax (chart_id,rate) values ((select id from chart where accno = '2320'),0.08);
 --
 update defaults set inventory_accno_id = (select id from chart where accno = '1520'), income_accno_id = (select id from chart where accno = '4020'), expense_accno_id = (select id from chart where accno = '5010'), fxgain_accno_id = (select id from chart where accno = '4450'), fxloss_accno_id = (select id from chart where accno = '4450'), curr = 'CAD:USD:EUR', weightunit = 'kg';

Modified: trunk/sql/Canada-French_General-chart.sql
===================================================================
--- trunk/sql/Canada-French_General-chart.sql	2006-10-02 23:40:18 UTC (rev 183)
+++ trunk/sql/Canada-French_General-chart.sql	2006-10-03 02:05:40 UTC (rev 184)
@@ -72,7 +72,7 @@
 INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5765', 'R\xE9paration et entretien', 'A', 'E', 'AP_amount', '8964');
 INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5800', 'Taxes d''affaires, droits d''adh\xE9sion et permis', 'A', 'E', 'AP_amount', '8760');
 --
-insert into tax (chart_id,rate) values ((select id from chart where accno = '2310'),0.07);
+insert into tax (chart_id,rate) values ((select id from chart where accno = '2310'),0.06);
 insert into tax (chart_id,rate) values ((select id from chart where accno = '2320'),0.08025);
 --
 update defaults set inventory_accno_id = (select id from chart where accno = '1520'), income_accno_id = (select id from chart where accno = '4020'), expense_accno_id = (select id from chart where accno = '5010'), fxgain_accno_id = (select id from chart where accno = '4450'), fxloss_accno_id = (select id from chart where accno = '4450'), curr = 'CAD:USD:EUR', weightunit = 'kg';


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