X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;ds=sidebyside;f=sql%2FGermany-DATEV-SKR03EU-chart.sql;h=20495d8d1b6be4da3f447ddea0036256b4100407;hb=13da953d823f80ef614debc6fcf024c4c5410c06;hp=1f5b79b62f3705ed7084daefb673a32da824b71c;hpb=2e1e2d4c36e8580c979339aff4a934fd52b96a8a;p=kivitendo-erp.git diff --git a/sql/Germany-DATEV-SKR03EU-chart.sql b/sql/Germany-DATEV-SKR03EU-chart.sql index 1f5b79b62..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); @@ -216,7 +216,7 @@ INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, ta INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2746', 'Steuerfr.Erträge a.d.Auflös.v.SoPo m.Rücklageanteil', 'A', 'I', '', '2746', 0, NULL, NULL, NULL, 2, FALSE); INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2747', 'Sonst.steuerfreie Betriebseinnahmen', 'A', 'I', '', '2747', 0, NULL, NULL, NULL, 2, FALSE); INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2797', 'Entnahmen a.satzungsmäßigen Rücklagen', 'A', 'E', '', '2797', 0, 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 ('3559', 'Steuerfreie Einfuhren', 'A', 'E', '', '3559', 0, NULL, NULL, NULL, 8, FALSE); +INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3559', 'Steuerfreie Einfuhren', 'A', 'E', 'AP_amount:IC_cogs', '3559', 0, 91, NULL, NULL, 8, FALSE); INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3580', 'Wareneinkauf z.allg.Umsatzsteuersatz (EÜR)', 'A', 'E', '', '3580', 0, 0, 4, NULL, 8, FALSE); INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3581', 'Wareneinkauf z.erm.Umsatzsteuersatz(EÜR)', 'A', 'E', '', '3581', 0, 0, 4, NULL, 8, FALSE); INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3582', 'Wareneinkauf ohne Vorsteuerabzug(EÜR)', 'A', 'E', '', '3582', 0, 0, 4, NULL, 8, FALSE); @@ -377,18 +377,19 @@ INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, ta INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2215', 'Zinsabschlagsteuer', 'A', 'E', '', '2215', 0, NULL, 35, 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 ('2218', 'Anrechb.Solidari.zuschlag a.Zinsabschlagst.', 'A', 'E', '', '2218', 0, NULL, 35, NULL, NULL, FALSE); -INSERT INTO tax (rate, taxkey, taxdescription) values ('0','0','Keine Steuer'); -INSERT INTO tax (rate, taxkey, taxdescription) values ('0','1','Umsatzsteuerfrei'); -insert into tax VALUES ((select id from chart where accno = '1771'),'0.07','1771','2','Umsatzsteuer 7%'); -INSERT INTO tax VALUES ((select id from chart where accno = '1775'),'0.16','1775','3','Umsatzsteuer 16%'); -INSERT INTO tax VALUES ((select id from chart where accno = '1571'),'0.07','1571','8','Vorsteuer 7%'); -insert into tax VALUES ((select id from chart where accno = '1575'),'0.16','1575','9','Vorsteuer 16%'); -insert into tax (taxkey, taxdescription) values ('10','Im anderen EG-Staat steuerpfl. Lieferung'); -insert into tax (taxkey, taxdescription) values ('11','Steuerfreie EG-Lief. an Abn. mit UStIdNr'); -insert into tax (chart_id,rate,taxnumber, taxkey, taxdescription) values ((select id from chart where accno = '1772'),'0.07','1772','12','Steuerpflicht. EG-Lieferungen 7%'); -insert into tax (chart_id,rate,taxnumber, taxkey, taxdescription) values ((select id from chart where accno = '1772'),'0.16','1773','13','Steuerpflicht. EG-Lieferungen 16%'); -insert into tax (chart_id,rate,taxnumber, taxkey, taxdescription) values ((select id from chart where accno = '1572'),'0.07','1572','18','Steuerpflicht. EG-Erwerb 7%'); -insert into tax (chart_id,rate,taxnumber, taxkey, taxdescription) values ((select id from chart where accno = '1572'),'0.16','1573','19','Steuerpflicht. EG-Erwerb 16%'); +-- insert actual tax values for SKR03 +INSERT INTO tax (rate, taxkey, taxdescription) VALUES ('0','0','Keine Steuer'); +INSERT INTO tax (rate, taxkey, taxdescription) VALUES ('0','1','Umsatzsteuerfrei (mit Vorsteuerabzug)'); +INSERT INTO tax (chart_id, rate, taxnumber, taxkey, taxdescription) VALUES ((SELECT id FROM chart WHERE accno = '1771'),'0.07','1771','2','Umsatzsteuer 7%'); +INSERT INTO tax (chart_id, rate, taxnumber, taxkey, taxdescription) VALUES ((SELECT id FROM chart WHERE accno = '1775'),'0.16','1775','3','Umsatzsteuer 16%'); +INSERT INTO tax (chart_id, rate, taxnumber, taxkey, taxdescription) VALUES ((SELECT id FROM chart WHERE accno = '1571'),'0.07','1571','8','Vorsteuer 7%'); +INSERT INTO tax (chart_id, rate, taxnumber, taxkey, taxdescription) VALUES ((SELECT id FROM chart WHERE accno = '1575'),'0.16','1575','9','Vorsteuer 16%'); +INSERT INTO tax (chart_id, rate, taxnumber, taxkey, taxdescription) VALUES ((SELECT id FROM chart WHERE accno = '1767'),'0.00','1767','10','Im anderen EG-Staat steuerpfl. Lieferung'); +INSERT INTO tax (taxkey, taxdescription) VALUES ('11','Steuerfreie EG-Lief. an Abn. mit UStIdNr'); +INSERT INTO tax (chart_id, rate, taxnumber, taxkey, taxdescription) VALUES ((SELECT id FROM chart WHERE accno = '1772'),'0.07','1772','12','Umsatzsteuer 7% innergem. Erwerb'); +INSERT INTO tax (chart_id, rate, taxnumber, taxkey, taxdescription) VALUES ((SELECT id FROM chart WHERE accno = '1773'),'0.16','1773','13','Umsatzsteuer 16% innergem. Erwerb'); +INSERT INTO tax (chart_id, rate, taxnumber, taxkey, taxdescription) VALUES ((SELECT id FROM chart WHERE accno = '1572'),'0.07','1572','18','Steuerpfl. EG-Erwerb 7%'); +INSERT INTO tax (chart_id, rate, taxnumber, taxkey, taxdescription) VALUES ((SELECT id FROM chart WHERE accno = '1572'),'0.16','1573','19','Steuerpfl. EG-Erwerb 16%'); -- UStVA Link to SKR03/2006 -- Let this structure like it is, please. @@ -440,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'));