summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rwxr-xr-xsql/Australia_General_0000-chart.sql4
-rwxr-xr-xsql/Australia_General_00000-chart.sql2
-rwxr-xr-xsql/Bahasa-Indonesia_Default-chart.sql2
-rwxr-xr-xsql/Belgium-chart.sql5
-rwxr-xr-xsql/Brazil_General-chart.sql2
-rwxr-xr-xsql/Canada-Quebec_General-UTF8-chart.sql2
-rwxr-xr-xsql/Colombia-PUC-chart.sql5
-rwxr-xr-xsql/Colombia-utf8-PUC-chart.sql5
-rwxr-xr-xsql/Czech-Republic-chart.sql2
-rwxr-xr-xsql/Danish_Default-chart.sql2
-rwxr-xr-xsql/Dutch_Default-chart.sql2
-rwxr-xr-xsql/Dutch_Standard-chart.sql2
-rwxr-xr-xsql/Egypt-UTF8-chart.sql4
-rwxr-xr-xsql/France-chart.sql2
-rwxr-xr-xsql/German-Sample-chart.sql2
-rwxr-xr-xsql/Germany-DATEV-SKR03-chart.sql2
-rwxr-xr-xsql/Germany-SKR03-chart.sql2
-rwxr-xr-xsql/Hungary-chart.sql5
-rwxr-xr-xsql/Italy_General-chart.sql2
-rwxr-xr-xsql/Latvia-chart.sql2
-rwxr-xr-xsql/Norwegian_Default-chart.sql2
-rwxr-xr-xsql/Paraguay-chart.sql5
-rwxr-xr-xsql/Poland-chart.sql2
-rwxr-xr-xsql/Simplified-Chinese_Default-UTF8-chart.sql2
-rwxr-xr-xsql/Simplified-Chinese_Default-chart.sql2
-rwxr-xr-xsql/Spain-ISO-chart.sql2
-rwxr-xr-xsql/Spain-UTF8-chart.sql2
-rwxr-xr-xsql/Sweden-chart.sql2
-rwxr-xr-xsql/Sweden_Agriculture-chart.sql2
-rwxr-xr-xsql/Sweden_Church_Society-chart.sql2
-rwxr-xr-xsql/Swiss-German-chart.sql2
-rwxr-xr-xsql/Traditional-Chinese_Default-UTF8-chart.sql2
-rwxr-xr-xsql/Traditional-Chinese_Default-chart.sql2
-rwxr-xr-xsql/UCOA-Form990-chart.sql2
-rwxr-xr-xsql/UCOA-Form990EZ-chart.sql2
-rwxr-xr-xsql/UK_General-chart.sql4
-rwxr-xr-xsql/US_Manufacturing-chart.sql2
-rwxr-xr-xsql/US_Service_Company-chart.sql2
-rwxr-xr-xsql/Venezuela_Default-chart.sql2
39 files changed, 52 insertions, 47 deletions
diff --git a/sql/Australia_General_0000-chart.sql b/sql/Australia_General_0000-chart.sql
index f9a25262..9c2a70b9 100755
--- a/sql/Australia_General_0000-chart.sql
+++ b/sql/Australia_General_0000-chart.sql
@@ -109,9 +109,9 @@ INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VA
INSERT INTO tax (chart_id, rate, taxnumber) VALUES ((SELECT id FROM chart WHERE accno = '1230'), 0.1, '');
INSERT INTO tax (chart_id, rate, taxnumber) VALUES ((SELECT id FROM chart WHERE accno = '2290'), 0.1, '');
--
- SET inventory_accno_id = (SELECT id FROM chart WHERE accno = '1520'));
+INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE accno = '1520'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE accno = '4020'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (SELECT id FROM chart WHERE accno = '4020'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE accno = '5020'));
diff --git a/sql/Australia_General_00000-chart.sql b/sql/Australia_General_00000-chart.sql
index 0c0a2c2b..4d15e812 100755
--- a/sql/Australia_General_00000-chart.sql
+++ b/sql/Australia_General_00000-chart.sql
@@ -76,7 +76,7 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '210
--
INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '15001'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '40001'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '40001'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '50001'));
diff --git a/sql/Bahasa-Indonesia_Default-chart.sql b/sql/Bahasa-Indonesia_Default-chart.sql
index e4e0f431..087ebd70 100755
--- a/sql/Bahasa-Indonesia_Default-chart.sql
+++ b/sql/Bahasa-Indonesia_Default-chart.sql
@@ -71,7 +71,7 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '231
--
INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '4020'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4020'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5010'));
diff --git a/sql/Belgium-chart.sql b/sql/Belgium-chart.sql
index af472c7b..0637749b 100755
--- a/sql/Belgium-chart.sql
+++ b/sql/Belgium-chart.sql
@@ -430,9 +430,10 @@ INSERT INTO tax (chart_id, rate, taxnumber) VALUES ((SELECT id FROM chart WHERE
INSERT INTO tax (chart_id, rate, taxnumber) VALUES ((SELECT id FROM chart WHERE accno = '451541'), 0.21);
INSERT INTO tax (chart_id, rate, taxnumber) VALUES ((SELECT id FROM chart WHERE accno = '640700'), 0.21);
--
- SET inventory_accno_id = (SELECT id FROM chart WHERE accno = '340'));
+INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (SELECT
+id FROM chart WHERE accno = '340'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE accno = '743200'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (SELECT id FROM chart WHERE accno = '743200'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE accno = '604'));
diff --git a/sql/Brazil_General-chart.sql b/sql/Brazil_General-chart.sql
index 93a0a9f4..787a6ced 100755
--- a/sql/Brazil_General-chart.sql
+++ b/sql/Brazil_General-chart.sql
@@ -68,7 +68,7 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '232
--
INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '4020'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4020'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5010'));
diff --git a/sql/Canada-Quebec_General-UTF8-chart.sql b/sql/Canada-Quebec_General-UTF8-chart.sql
index 274f5b8d..725f0ae8 100755
--- a/sql/Canada-Quebec_General-UTF8-chart.sql
+++ b/sql/Canada-Quebec_General-UTF8-chart.sql
@@ -77,7 +77,7 @@ insert into tax (chart_id,rate,pass) values ((select id from chart where accno =
--
INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '4020'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4020'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5010'));
diff --git a/sql/Colombia-PUC-chart.sql b/sql/Colombia-PUC-chart.sql
index 035e249a..271de336 100755
--- a/sql/Colombia-PUC-chart.sql
+++ b/sql/Colombia-PUC-chart.sql
@@ -769,9 +769,10 @@ INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '24
INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2408100001'), 0.16);
INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2408100002'), 0.07);
- SET inventory_accno_id = (SELECT id FROM chart WHERE accno = '141005001'));
+ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id',
+SELECT id FROM chart WHERE accno = '141005001'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE accno = '412027001'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (SELECT id FROM chart WHERE accno = '412027001'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE accno = '5250150001'));
diff --git a/sql/Colombia-utf8-PUC-chart.sql b/sql/Colombia-utf8-PUC-chart.sql
index 072207b4..469b2333 100755
--- a/sql/Colombia-utf8-PUC-chart.sql
+++ b/sql/Colombia-utf8-PUC-chart.sql
@@ -769,9 +769,10 @@ INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '24
INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2408100001'), 0.16);
INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2408100002'), 0.07);
- SET inventory_accno_id = (SELECT id FROM chart WHERE accno = '141005001'));
+INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id',
+(SELECT id FROM chart WHERE accno = '141005001'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE accno = '412027001'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (SELECT id FROM chart WHERE accno = '412027001'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE accno = '5250150001'));
diff --git a/sql/Czech-Republic-chart.sql b/sql/Czech-Republic-chart.sql
index 30d63265..dcdfffbb 100755
--- a/sql/Czech-Republic-chart.sql
+++ b/sql/Czech-Republic-chart.sql
@@ -315,7 +315,7 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '343
--
INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '13200'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '60000'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '60000'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '50000'));
diff --git a/sql/Danish_Default-chart.sql b/sql/Danish_Default-chart.sql
index 090f40ed..61bb4791 100755
--- a/sql/Danish_Default-chart.sql
+++ b/sql/Danish_Default-chart.sql
@@ -73,7 +73,7 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '231
--
INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '4020'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4020'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5010'));
diff --git a/sql/Dutch_Default-chart.sql b/sql/Dutch_Default-chart.sql
index 3862f4c6..30f22aaa 100755
--- a/sql/Dutch_Default-chart.sql
+++ b/sql/Dutch_Default-chart.sql
@@ -78,7 +78,7 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '231
--
INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '4020'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4020'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5010'));
diff --git a/sql/Dutch_Standard-chart.sql b/sql/Dutch_Standard-chart.sql
index 79e1cac6..9ba7f7d1 100755
--- a/sql/Dutch_Standard-chart.sql
+++ b/sql/Dutch_Standard-chart.sql
@@ -231,7 +231,7 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '181
--
INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '7001'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '8520'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '8520'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '8010'));
diff --git a/sql/Egypt-UTF8-chart.sql b/sql/Egypt-UTF8-chart.sql
index 43c20c9f..19627f40 100755
--- a/sql/Egypt-UTF8-chart.sql
+++ b/sql/Egypt-UTF8-chart.sql
@@ -72,9 +72,9 @@ INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES
INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5790','مرافق','A','E','AP_amount','');
INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2280','ضرائب مرتبات مستحقة','A','L','','');
- SET inventory_accno_id = (SELECT id FROM chart WHERE accno = '1520'));
+INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE accno = '1520'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE accno = '4020'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (SELECT id FROM chart WHERE accno = '4020'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE accno = '5010'));
diff --git a/sql/France-chart.sql b/sql/France-chart.sql
index 47dd8f80..56d32921 100755
--- a/sql/France-chart.sql
+++ b/sql/France-chart.sql
@@ -949,7 +949,7 @@ INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '44
--
INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '681730'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '707000'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '707000'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '601000'));
diff --git a/sql/German-Sample-chart.sql b/sql/German-Sample-chart.sql
index 1a157aac..97f9008f 100755
--- a/sql/German-Sample-chart.sql
+++ b/sql/German-Sample-chart.sql
@@ -214,7 +214,7 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '380
--
INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1140'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '8120'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '8120'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5800'));
diff --git a/sql/Germany-DATEV-SKR03-chart.sql b/sql/Germany-DATEV-SKR03-chart.sql
index 0964a30b..08021da0 100755
--- a/sql/Germany-DATEV-SKR03-chart.sql
+++ b/sql/Germany-DATEV-SKR03-chart.sql
@@ -220,7 +220,7 @@ INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES
--
INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '0398000'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '0840000'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '0840000'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '0399000'));
diff --git a/sql/Germany-SKR03-chart.sql b/sql/Germany-SKR03-chart.sql
index ee5c4694..233ba4b4 100755
--- a/sql/Germany-SKR03-chart.sql
+++ b/sql/Germany-SKR03-chart.sql
@@ -262,7 +262,7 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '840
--
INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '7140'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '8400'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '8400'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '4700'));
diff --git a/sql/Hungary-chart.sql b/sql/Hungary-chart.sql
index 9120937c..e4ac4a73 100755
--- a/sql/Hungary-chart.sql
+++ b/sql/Hungary-chart.sql
@@ -45,9 +45,10 @@ INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE ac
INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4672'),'0.05','');
INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4673'),'0','');
--
- SET inventory_accno_id = (SELECT id FROM chart WHERE accno = '2110'));
+INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id',
+(SELECT id FROM chart WHERE accno = '2110'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE accno = '9110'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (SELECT id FROM chart WHERE accno = '9110'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE accno = '8140'));
diff --git a/sql/Italy_General-chart.sql b/sql/Italy_General-chart.sql
index 3a10c52c..2238427f 100755
--- a/sql/Italy_General-chart.sql
+++ b/sql/Italy_General-chart.sql
@@ -177,7 +177,7 @@ INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '64
--
INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '3020005'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '8005005'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '8005005'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '7005005'));
diff --git a/sql/Latvia-chart.sql b/sql/Latvia-chart.sql
index 50e8a71c..ee92a688 100755
--- a/sql/Latvia-chart.sql
+++ b/sql/Latvia-chart.sql
@@ -251,7 +251,7 @@ INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart where ac
--
INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1230'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '6010'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '6010'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '7110'));
diff --git a/sql/Norwegian_Default-chart.sql b/sql/Norwegian_Default-chart.sql
index 9da1cb0d..b4850303 100755
--- a/sql/Norwegian_Default-chart.sql
+++ b/sql/Norwegian_Default-chart.sql
@@ -295,7 +295,7 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '272
--
INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1250'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '3010'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '3010'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '4010'));
diff --git a/sql/Paraguay-chart.sql b/sql/Paraguay-chart.sql
index db6ad0f1..67010e82 100755
--- a/sql/Paraguay-chart.sql
+++ b/sql/Paraguay-chart.sql
@@ -249,9 +249,10 @@ INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VA
--
INSERT INTO tax (chart_id,rate) VALUES ((select id from chart where accno = '2.151'),'0.1');
--
- SET inventory_accno_id = (select id from chart where accno = '1.141'));
+INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id',
+(select id from chart where accno = '1.141'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '4.110'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4.110'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5.110.01'));
diff --git a/sql/Poland-chart.sql b/sql/Poland-chart.sql
index b7793bc5..8994b0c6 100755
--- a/sql/Poland-chart.sql
+++ b/sql/Poland-chart.sql
@@ -333,7 +333,7 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '223
--
INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '333000000'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '773010000'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '773010000'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '773110000'));
diff --git a/sql/Simplified-Chinese_Default-UTF8-chart.sql b/sql/Simplified-Chinese_Default-UTF8-chart.sql
index afeabb97..c5a094bd 100755
--- a/sql/Simplified-Chinese_Default-UTF8-chart.sql
+++ b/sql/Simplified-Chinese_Default-UTF8-chart.sql
@@ -76,7 +76,7 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '231
--
INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '4020'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4020'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5010'));
diff --git a/sql/Simplified-Chinese_Default-chart.sql b/sql/Simplified-Chinese_Default-chart.sql
index 20d41c81..4ecd9561 100755
--- a/sql/Simplified-Chinese_Default-chart.sql
+++ b/sql/Simplified-Chinese_Default-chart.sql
@@ -76,7 +76,7 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '231
--
INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '4020'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4020'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5010'));
diff --git a/sql/Spain-ISO-chart.sql b/sql/Spain-ISO-chart.sql
index ac8a20a7..47875904 100755
--- a/sql/Spain-ISO-chart.sql
+++ b/sql/Spain-ISO-chart.sql
@@ -130,7 +130,7 @@ INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno
--
INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '300000000'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '700000000'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '700000000'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '600000000'));
diff --git a/sql/Spain-UTF8-chart.sql b/sql/Spain-UTF8-chart.sql
index 9bcad317..942357a8 100755
--- a/sql/Spain-UTF8-chart.sql
+++ b/sql/Spain-UTF8-chart.sql
@@ -130,7 +130,7 @@ INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno
--
INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '300000000'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '700000000'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '700000000'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '600000000'));
diff --git a/sql/Sweden-chart.sql b/sql/Sweden-chart.sql
index d721a76d..507b15fd 100755
--- a/sql/Sweden-chart.sql
+++ b/sql/Sweden-chart.sql
@@ -1136,7 +1136,7 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '264
--
INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno ='1400'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '3010'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '3010'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '4010'));
diff --git a/sql/Sweden_Agriculture-chart.sql b/sql/Sweden_Agriculture-chart.sql
index 2d37732d..f160ada6 100755
--- a/sql/Sweden_Agriculture-chart.sql
+++ b/sql/Sweden_Agriculture-chart.sql
@@ -1299,7 +1299,7 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '264
INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno ='1400'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '3011'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '3011'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '4010'));
diff --git a/sql/Sweden_Church_Society-chart.sql b/sql/Sweden_Church_Society-chart.sql
index a0869104..bbef2845 100755
--- a/sql/Sweden_Church_Society-chart.sql
+++ b/sql/Sweden_Church_Society-chart.sql
@@ -229,7 +229,7 @@ insert into chart (accno,description,charttype,gifi_accno,category,link) values
--
INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno ='1130'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '3400'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '3400'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '4400'));
diff --git a/sql/Swiss-German-chart.sql b/sql/Swiss-German-chart.sql
index 49761139..e46198dc 100755
--- a/sql/Swiss-German-chart.sql
+++ b/sql/Swiss-German-chart.sql
@@ -158,7 +158,7 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '212
--
INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '11121'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '34002'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '34002'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '42005'));
diff --git a/sql/Traditional-Chinese_Default-UTF8-chart.sql b/sql/Traditional-Chinese_Default-UTF8-chart.sql
index 2ffc48d7..5e46dc79 100755
--- a/sql/Traditional-Chinese_Default-UTF8-chart.sql
+++ b/sql/Traditional-Chinese_Default-UTF8-chart.sql
@@ -76,7 +76,7 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '231
--
INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '4020'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4020'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5010'));
diff --git a/sql/Traditional-Chinese_Default-chart.sql b/sql/Traditional-Chinese_Default-chart.sql
index dc92e49d..a12aad2d 100755
--- a/sql/Traditional-Chinese_Default-chart.sql
+++ b/sql/Traditional-Chinese_Default-chart.sql
@@ -76,7 +76,7 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '231
--
INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '4020'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4020'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5010'));
diff --git a/sql/UCOA-Form990-chart.sql b/sql/UCOA-Form990-chart.sql
index 169086d9..d9b73e8f 100755
--- a/sql/UCOA-Form990-chart.sql
+++ b/sql/UCOA-Form990-chart.sql
@@ -227,7 +227,7 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '865
--
INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1410'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '4010'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4010'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '7510'));
diff --git a/sql/UCOA-Form990EZ-chart.sql b/sql/UCOA-Form990EZ-chart.sql
index 6726ee7e..db29307d 100755
--- a/sql/UCOA-Form990EZ-chart.sql
+++ b/sql/UCOA-Form990EZ-chart.sql
@@ -227,7 +227,7 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '865
--
INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1410'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '4010'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4010'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '7510'));
diff --git a/sql/UK_General-chart.sql b/sql/UK_General-chart.sql
index 131facc6..3aca9ec3 100755
--- a/sql/UK_General-chart.sql
+++ b/sql/UK_General-chart.sql
@@ -105,9 +105,9 @@ INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES
INSERT INTO tax (chart_id,rate) VALUES ((SELECT id FROM chart WHERE accno = '2200'),0.175);
INSERT INTO tax (chart_id,rate) VALUES ((SELECT id FROM chart WHERE accno = '2205'),0.05);
--
- SET inventory_accno_id = (SELECT id FROM chart WHERE accno = '1001'));
+INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE accno = '1001'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE accno = '4000'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (SELECT id FROM chart WHERE accno = '4000'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE accno = '5000'));
diff --git a/sql/US_Manufacturing-chart.sql b/sql/US_Manufacturing-chart.sql
index 5ad4240f..f7225843 100755
--- a/sql/US_Manufacturing-chart.sql
+++ b/sql/US_Manufacturing-chart.sql
@@ -80,7 +80,7 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '215
--
INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '4020'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4020'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5020'));
diff --git a/sql/US_Service_Company-chart.sql b/sql/US_Service_Company-chart.sql
index 96b8ca70..1318d8b5 100755
--- a/sql/US_Service_Company-chart.sql
+++ b/sql/US_Service_Company-chart.sql
@@ -66,7 +66,7 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '215
--
INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '4410'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4410'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5020'));
diff --git a/sql/Venezuela_Default-chart.sql b/sql/Venezuela_Default-chart.sql
index 7232085e..1852f5ce 100755
--- a/sql/Venezuela_Default-chart.sql
+++ b/sql/Venezuela_Default-chart.sql
@@ -86,7 +86,7 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '215
--
INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520'));
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '4020'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4020'));
INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5020'));