diff options
| author | ivan <ivan> | 2004-11-15 10:35:56 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2004-11-15 10:35:56 +0000 |
| commit | 5fc8c5edf574ab024d4646914b6432d458e2ffbd (patch) | |
| tree | c8031ae966b35c47f6aea9929e10911412ff6c59 /sql-ledger/sql/Germany-SKR03-chart.sql | |
| parent | a4fc489e860b7bc51b5282a87ea21750b30b905e (diff) | |
| parent | 32306b5f8ffe4ce594409aa6e89626740b225a39 (diff) | |
This commit was generated by cvs2svn to compensate for changes in r3883,
which included commits to RCS files with non-trunk default branches.
Diffstat (limited to 'sql-ledger/sql/Germany-SKR03-chart.sql')
| -rw-r--r-- | sql-ledger/sql/Germany-SKR03-chart.sql | 7 |
1 files changed, 2 insertions, 5 deletions
diff --git a/sql-ledger/sql/Germany-SKR03-chart.sql b/sql-ledger/sql/Germany-SKR03-chart.sql index a7f87e2ee..2d3261a79 100644 --- a/sql-ledger/sql/Germany-SKR03-chart.sql +++ b/sql-ledger/sql/Germany-SKR03-chart.sql @@ -1,6 +1,4 @@ -- General COA --- provided by Yvonne --- June 13, 2002 -- INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('420','Büroeinrichtung','A','A','','420'); INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('430','Ladeneinrichtung','A','A','','430'); @@ -252,7 +250,7 @@ INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1600','Verb. aus Lief. und Leist. Lieferantengruppe 0','A','L','AP:CT_tax','1600'); INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3400','Wareneingang, 16% Vorsteuer','A','E','AP_amount:CT_tax','3400'); INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8400','Umsatzerlöse 16%','A','I','AR_amount:IC_sale:CT_tax','8400'); -INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8840','Ertrge aus Kursdifferenzen','A','I','AR_amount:IC_sale:IC_income','8840'); +INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8840','Erträge aus Kursdifferenzen','A','I','AR_amount:IC_sale:IC_income','8840'); -- insert into tax (chart_id,rate) values ((select id from chart where accno = '1571'),0.07); insert into tax (chart_id,rate) values ((select id from chart where accno = '1575'),0.16); @@ -262,6 +260,5 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '177 insert into tax (chart_id,rate) values ((select id from chart where accno = '3400'),0.16); insert into tax (chart_id,rate) values ((select id from chart where accno = '8400'),0.16); -- -update defaults set inventory_accno_id = (select id from chart where accno = '7140'), income_accno_id = (select id from chart where accno = '8400'), expense_accno_id = (select id from chart where accno = '4700'), fxgain_accno_id = (select id from chart where accno = '8840'), fxloss_accno_id = (select id from chart where accno = '8840'), invnumber = '1000', sonumber = '1000', ponumber = '1000', curr = 'EUR:USD', weightunit = 'kg'; +update defaults set inventory_accno_id = (select id from chart where accno = '7140'), income_accno_id = (select id from chart where accno = '8400'), expense_accno_id = (select id from chart where accno = '4700'), fxgain_accno_id = (select id from chart where accno = '8840'), fxloss_accno_id = (select id from chart where accno = '8840'), curr = 'EUR:USD', weightunit = 'kg'; -- - |