SF.net SVN: ledger-smb: [2084] branches/1.2/sql

[..hidden..]

Revision: 2084
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2084&view=rev
Author:   tetragon
Date:     2008-02-24 11:01:18 -0800 (Sun, 24 Feb 2008)

Log Message:
-----------
Updating GST rate to current value

Modified Paths:
--------------
    branches/1.2/sql/Canada-English_General-chart.sql
    branches/1.2/sql/Canada-Quebec_General-chart.sql

Modified: branches/1.2/sql/Canada-English_General-chart.sql
===================================================================
--- branches/1.2/sql/Canada-English_General-chart.sql	2008-02-24 18:54:17 UTC (rev 2083)
+++ branches/1.2/sql/Canada-English_General-chart.sql	2008-02-24 19:01:18 UTC (rev 2084)
@@ -64,7 +64,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.06);
+insert into tax (chart_id,rate) values ((select id from chart where accno = '2310'),0.05);
 insert into tax (chart_id,rate) values ((select id from chart where accno = '2320'),0.08);
 --
 

Modified: branches/1.2/sql/Canada-Quebec_General-chart.sql
===================================================================
--- branches/1.2/sql/Canada-Quebec_General-chart.sql	2008-02-24 18:54:17 UTC (rev 2083)
+++ branches/1.2/sql/Canada-Quebec_General-chart.sql	2008-02-24 19:01:18 UTC (rev 2084)
@@ -76,7 +76,7 @@
 INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5800', 'Taxes d\'affaires, droits d\'adhÃsion et permis', 'A', 'E', 'AP_amount', '8760');
 INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5810', 'Perte sur change', 'A', 'E', '', '8231');
 --
-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 = '2310'),0.05);
 insert into tax (chart_id,rate,pass) values ((select id from chart where accno = '2320'),0.075,1);
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520'));


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