summaryrefslogtreecommitdiff
path: root/sql/coa/ca/chart
diff options
context:
space:
mode:
authortetragon <tetragon@4979c152-3d1c-0410-bac9-87ea11338e46>2008-02-24 18:54:17 +0000
committertetragon <tetragon@4979c152-3d1c-0410-bac9-87ea11338e46>2008-02-24 18:54:17 +0000
commit32ee2de4dbd5509e7093fa11a905dd764e796c1b (patch)
treed566c1ae06a7982a620ab190fd4a7aa70c85a965 /sql/coa/ca/chart
parent55c970993842bbd97c28443558452cf896a29e86 (diff)
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
Diffstat (limited to 'sql/coa/ca/chart')
-rwxr-xr-xsql/coa/ca/chart/English_General.sql2
-rwxr-xr-xsql/coa/ca/chart/French-Quebec_General.sql8
2 files changed, 5 insertions, 5 deletions
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'));