From e7a9cbbb3df30a419d86805db74cf0efa08310d5 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Fri, 8 Dec 2006 15:28:41 +0000 Subject: [PATCH] Queries zum Anlegen der Standard-Buchungsgruppen fuer SKR03 und SKR04 (erst einmal nur auskommentiert) eingefuegt. --- sql/Germany-DATEV-SKR03EU-chart.sql | 61 ++++++++++++++++++++++++++++- sql/Germany-DATEV-SKR04EU-chart.sql | 61 ++++++++++++++++++++++++++++- 2 files changed, 120 insertions(+), 2 deletions(-) diff --git a/sql/Germany-DATEV-SKR03EU-chart.sql b/sql/Germany-DATEV-SKR03EU-chart.sql index 7367c2790..20495d8d1 100644 --- a/sql/Germany-DATEV-SKR03EU-chart.sql +++ b/sql/Germany-DATEV-SKR03EU-chart.sql @@ -1,6 +1,6 @@ -- created by Yvonne Einberger -- contributed by Andre Schubert --- +-- INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0027', 'EDV-Software', 'A', 'A', 'AP_amount', '0027', 9, NULL, NULL, NULL, NULL, FALSE); INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0090', 'Geschäftsbauten', 'A', 'A', 'AP_amount', '0090', 9, NULL, NULL, NULL, NULL, FALSE); INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0200', 'Techn.Anlagen und Maschinen', 'A', 'A', 'AP_amount', '0200', 9, NULL, NULL, NULL, NULL, FALSE); @@ -441,3 +441,62 @@ UPDATE chart SET pos_ustva=64 WHERE accno IN ('1556', '1557', '1558', '1559'); UPDATE chart SET pos_ustva=59 WHERE accno IN (''); UPDATE chart SET pos_ustva=69 WHERE accno IN ('1783'); UPDATE chart SET pos_ustva=39 WHERE accno IN ('1781'); + +-- Buchungsgruppen + +-- Erst einkommentieren, wenn in lx-office.sql das 2.4.0er Schema +-- inklusive der Tabelle 'buchungsgruppen' enthalten ist. + +-- INSERT INTO buchungsgruppen +-- (description, inventory_accno_id, +-- income_accno_id_0, expense_accno_id_0, +-- income_accno_id_1, expense_accno_id_1, +-- income_accno_id_2, expense_accno_id_2, +-- income_accno_id_3, expense_accno_id_3) +-- VALUES +-- ('Standard 16%', +-- -- 3980: Bestand Waren +-- (SELECT id FROM chart WHERE accno = '3980'), +-- -- 8400: Erlöse 16% USt. +-- -- 3400: Wareneingang 16% Vorsteuer +-- (SELECT id FROM chart WHERE accno = '8400'), +-- (SELECT id FROM chart WHERE accno = '3400'), +-- -- 8320: Erlöse aus im and.EG-Land steuerpfl.Lieferungen +-- -- 3550: Steuerfreier innergem.Erwerb +-- (SELECT id FROM chart WHERE accno = '8320'), +-- (SELECT id FROM chart WHERE accno = '3550'), +-- -- 8315: Erlös Inland stpfl.EG-Lieferung 16% +-- -- 3425: Innergem.Erwerb 16% VorSt u. Ust +-- (SELECT id FROM chart WHERE accno = '8315'), +-- (SELECT id FROM chart WHERE accno = '3425'), +-- -- 8120: Steuerfreie Umsätze §4Nr.1a UstG +-- -- 3559: Steuerfreie Einfuhren +-- (SELECT id FROM chart WHERE accno = '8120'), +-- (SELECT id FROM chart WHERE accno = '3559')); + +-- INSERT INTO buchungsgruppen +-- (description, inventory_accno_id, +-- income_accno_id_0, expense_accno_id_0, +-- income_accno_id_1, expense_accno_id_1, +-- income_accno_id_2, expense_accno_id_2, +-- income_accno_id_3, expense_accno_id_3) +-- VALUES +-- ('Standard 7%', +-- -- 3980: Bestand Waren +-- (SELECT id FROM chart WHERE accno = '3980'), +-- -- 8300: Erlöse 7% USt. +-- -- 3300: Wareneingang 7% Vorsteuer +-- (SELECT id FROM chart WHERE accno = '8300'), +-- (SELECT id FROM chart WHERE accno = '3300'), +-- -- 8125: Steuerfrei innergem. Lieferungen §41bUStG +-- -- 3550: Steuerfreier innergem.Erwerb +-- (SELECT id FROM chart WHERE accno = '8125'), +-- (SELECT id FROM chart WHERE accno = '3550'), +-- -- 8310: Erlöse Inland stpfl. EG-Lieferung7% +-- -- 3420: Innergemein.Erwerb 7% VorSt u. Ust +-- (SELECT id FROM chart WHERE accno = '8310'), +-- (SELECT id FROM chart WHERE accno = '3420'), +-- -- 8120: Steuerfreie Umsätze §4Nr.1a UstG +-- -- 3559: Steuerfreie Einfuhren +-- (SELECT id FROM chart WHERE accno = '8120'), +-- (SELECT id FROM chart WHERE accno = '3559')); diff --git a/sql/Germany-DATEV-SKR04EU-chart.sql b/sql/Germany-DATEV-SKR04EU-chart.sql index 3c31d488b..c12bf63a0 100644 --- a/sql/Germany-DATEV-SKR04EU-chart.sql +++ b/sql/Germany-DATEV-SKR04EU-chart.sql @@ -373,4 +373,63 @@ insert into tax (taxkey, taxdescription) values ('11','Steuerfreie EG-Lief. an A insert into tax (chart_id,rate,taxnumber, taxkey, taxdescription) values ((select id from chart where accno = '3802'),'0.07','3802','12','Steuerpflicht. EG-Lieferungen 7%'); insert into tax (chart_id,rate,taxnumber, taxkey, taxdescription) values ((select id from chart where accno = '3802'),'0.16','3803','13','Steuerpflicht. EG-Lieferungen 16%'); insert into tax (chart_id,rate,taxnumber, taxkey, taxdescription) values ((select id from chart where accno = '1402'),'0.07','1402','18','Steuerpflicht. EG-Erwerb 7%'); -insert into tax (chart_id,rate,taxnumber, taxkey, taxdescription) values ((select id from chart where accno = '1402'),'0.16','1403','19','Steuerpflicht. EG-Erwerb 16%'); \ No newline at end of file +insert into tax (chart_id,rate,taxnumber, taxkey, taxdescription) values ((select id from chart where accno = '1402'),'0.16','1403','19','Steuerpflicht. EG-Erwerb 16%'); + +-- Buchungsgruppen + +-- Erst einkommentieren, wenn in lx-office.sql das 2.4.0er Schema +-- inklusive der Tabelle 'buchungsgruppen' enthalten ist. + +-- INSERT INTO buchungsgruppen +-- (description, inventory_accno_id, +-- income_accno_id_0, expense_accno_id_0, +-- income_accno_id_1, expense_accno_id_1, +-- income_accno_id_2, expense_accno_id_2, +-- income_accno_id_3, expense_accno_id_3) +-- VALUES +-- ('Standard 16%', +-- -- 1140: Bestand Waren +-- (SELECT id FROM chart WHERE accno = '1140'), +-- -- 4400: Erlöse 16% USt. +-- -- 5400: Wareneingang 16% Vorsteuer +-- (SELECT id FROM chart WHERE accno = '4400'), +-- (SELECT id FROM chart WHERE accno = '5400'), +-- -- 4125: Steuerfrei innergem. Lieferungen §41bUStG +-- -- 5550: Steuerfreier innergem.Erwerb +-- (SELECT id FROM chart WHERE accno = '4125'), +-- (SELECT id FROM chart WHERE accno = '5550'), +-- -- 4315: Erlös Inland stpfl.EG-Lieferung 16% +-- -- 5425: Innergem.Erwerb 16% VorSt u. Ust +-- (SELECT id FROM chart WHERE accno = '4315'), +-- (SELECT id FROM chart WHERE accno = '5425'), +-- -- 4150: Sonstige steuerfreie Umsätze §42-7UStG +-- -- 5559: Steuerfreie Einfuhren +-- (SELECT id FROM chart WHERE accno = '4150'), +-- (SELECT id FROM chart WHERE accno = '5559')); + +-- INSERT INTO buchungsgruppen +-- (description, inventory_accno_id, +-- income_accno_id_0, expense_accno_id_0, +-- income_accno_id_1, expense_accno_id_1, +-- income_accno_id_2, expense_accno_id_2, +-- income_accno_id_3, expense_accno_id_3) +-- VALUES +-- ('Standard 7%', +-- -- 1140: Bestand Waren +-- (SELECT id FROM chart WHERE accno = '1140'), +-- -- 4300: Erlöse 7%USt +-- -- 5300: Wareneingang 7% Vorsteuer +-- (SELECT id FROM chart WHERE accno = '4300'), +-- (SELECT id FROM chart WHERE accno = '5300'), +-- -- 4125: Steuerfrei innergem. Lieferungen §41bUStG +-- -- 5550: Steuerfreier innergem.Erwerb +-- (SELECT id FROM chart WHERE accno = '4125'), +-- (SELECT id FROM chart WHERE accno = '5550'), +-- -- 4310: Erlöse Inland stpfl. EG-Lieferung7% +-- -- 5420: Innergemein.Erwerb 7% VorSt u. Ust +-- (SELECT id FROM chart WHERE accno = '4310'), +-- (SELECT id FROM chart WHERE accno = '5420'), +-- -- 4150: Sonstige steuerfreie Umsätze §42-7UStG +-- -- 5559; Steuerfreie Einfuhren +-- (SELECT id FROM chart WHERE accno = '4150'), +-- (SELECT id FROM chart WHERE accno = '5559')); -- 2.20.1