summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authortetragon <tetragon@4979c152-3d1c-0410-bac9-87ea11338e46>2008-02-24 19:01:18 +0000
committertetragon <tetragon@4979c152-3d1c-0410-bac9-87ea11338e46>2008-02-24 19:01:18 +0000
commita5604d526ea006b1f8cb4c0b02b55547ba5dc405 (patch)
tree1ad05ff0f25dc33bb9e56e375dc25834aaca7313 /sql
parentad853136bb1ca4841c09a70379bbafbefe098fa5 (diff)
Updating GST rate to current value
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@2084 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'sql')
-rwxr-xr-xsql/Canada-English_General-chart.sql2
-rwxr-xr-xsql/Canada-Quebec_General-chart.sql2
2 files changed, 2 insertions, 2 deletions
diff --git a/sql/Canada-English_General-chart.sql b/sql/Canada-English_General-chart.sql
index 26122124..2f10ce8f 100755
--- a/sql/Canada-English_General-chart.sql
+++ b/sql/Canada-English_General-chart.sql
@@ -64,7 +64,7 @@ insert into chart (accno,description,charttype,gifi_accno,category,link) values
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);
--
diff --git a/sql/Canada-Quebec_General-chart.sql b/sql/Canada-Quebec_General-chart.sql
index 2849c5f8..b05caa2d 100755
--- a/sql/Canada-Quebec_General-chart.sql
+++ b/sql/Canada-Quebec_General-chart.sql
@@ -76,7 +76,7 @@ INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES
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'));