From 32ee2de4dbd5509e7093fa11a905dd764e796c1b Mon Sep 17 00:00:00 2001 From: tetragon Date: Sun, 24 Feb 2008 18:54:17 +0000 Subject: Updating the Candian GST rate Switching away from the use of backslashes to quote quotes git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2083 4979c152-3d1c-0410-bac9-87ea11338e46 --- sql/coa/ca/chart/English_General.sql | 2 +- sql/coa/ca/chart/French-Quebec_General.sql | 8 ++++---- 2 files changed, 5 insertions(+), 5 deletions(-) (limited to 'sql/coa/ca/chart') diff --git a/sql/coa/ca/chart/English_General.sql b/sql/coa/ca/chart/English_General.sql index 26122124..2f10ce8f 100755 --- a/sql/coa/ca/chart/English_General.sql +++ b/sql/coa/ca/chart/English_General.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/coa/ca/chart/French-Quebec_General.sql b/sql/coa/ca/chart/French-Quebec_General.sql index 2849c5f8..40a80959 100755 --- a/sql/coa/ca/chart/French-Quebec_General.sql +++ b/sql/coa/ca/chart/French-Quebec_General.sql @@ -53,7 +53,7 @@ INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5100', 'Frais de transport', 'A', 'E', 'AP_amount:IC_expense', '8457'); INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5400', 'FRAIS DE PERSONNEL', 'H', 'E', '', ''); INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5410', 'Salaires', 'A', 'E', '', '9060'); -INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5420', 'Dépenses d\'assurance-emploi', 'A', 'E', '', '8622'); +INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5420', 'Dépenses d''assurance-emploi', 'A', 'E', '', '8622'); INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5430', 'Dépenses RRQ', 'A', 'E', '', '8622'); INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5440', 'Dépenses CSST', 'A', 'E', '', '8622'); INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5450', 'Dépenses FSS', 'A', 'E', '', '8622'); @@ -63,7 +63,7 @@ INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5610', 'Frais comptables et juridiques', 'A', 'E', 'AP_amount', '8862'); INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5615', 'Publicité et promotion', 'A', 'E', 'AP_amount', '8520'); INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5620', 'Créances irrévocables', 'A', 'E', '', '8590'); -INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5660', 'Amortissement de l\'exercice', 'A', 'E', '', '8670'); +INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5660', 'Amortissement de l''exercice', 'A', 'E', '', '8670'); INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5680', 'Impôt sur le revenu', 'A', 'E', '', '9990'); INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5685', 'Assurances', 'A', 'E', 'AP_amount', '9804'); INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5690', 'Intérêts et frais bancaires', 'A', 'E', '', '9805'); @@ -73,10 +73,10 @@ INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5785', 'Voyages et loisirs', 'A', 'E', '', '8523'); INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5790', 'Services publics', 'A', 'E', 'AP_amount', '8812'); INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5765', 'Réparation 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ésion et permis', 'A', 'E', 'AP_amount', '8760'); +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')); -- cgit v1.2.3