Return to 1352

[kivitendo-erp.git] / sql / Germany-DATEV-SKR04EU-chart.sql

diff --git a/sql/Germany-DATEV-SKR04EU-chart.sql b/sql/Germany-DATEV-SKR04EU-chart.sql
index b267268..c12bf63 100644 (file)
--- a/sql/Germany-DATEV-SKR04EU-chart.sql
+++ b/sql/Germany-DATEV-SKR04EU-chart.sql
@@ -156,7 +156,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 ('5425', 'Innergem.Erwerb 16% VorSt u. Ust', 'A', 'E', 'AP_amount:IC_cogs', '5425', 0, 97, 4, NULL, 8, TRUE);\r
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5440', 'Innergem.Erwerb v.Neufahrz.v.Lief.o.USt.Identnr.16%VSt.u.16%USt.', 'A', 'E', 'AP_amount:IC_cogs', '5440', 19, 94, NULL, NULL, 8, TRUE);\r
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5550', 'Steuerfreier innergem.Erwerb', 'A', 'E', 'AP_amount:IC_cogs', '5550', 0, 91, NULL, NULL, 8, FALSE);\r
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5559', 'Steuerfreie Einfuhren', 'A', 'E', '', '5559', 0, NULL, NULL, NULL, 8, FALSE);\r
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5559', 'Steuerfreie Einfuhren', 'A', 'E', 'AP_amount:IC_cogs', '5559', 0, 91, NULL, NULL, 8, FALSE);\r
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5580', 'Wareneinkauf z.allg.Umsatzsteuersatz (EÜR)', 'A', 'E', '', '5580', 0, 0, 4, NULL, 8, FALSE);\r
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5581', 'Wareneinkauf z.erm.Umsatzsteuersatz(EÜR)', 'A', 'E', '', '5581', 0, 0, 4, NULL, 8, FALSE);\r
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5582', 'Wareneinkauf ohne Vorsteuerabzug(EÜR)', 'A', 'E', '', '5582', 0, 0, 4, NULL, 8, FALSE);\r
@@ -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%');\r
 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%');\r
 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%');\r
-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%');\r
+\r
+-- Buchungsgruppen\r
+\r
+-- Erst einkommentieren, wenn in lx-office.sql das 2.4.0er Schema\r
+-- inklusive der Tabelle 'buchungsgruppen' enthalten ist.\r
+\r
+-- INSERT INTO buchungsgruppen\r
+--   (description, inventory_accno_id,\r
+--    income_accno_id_0, expense_accno_id_0,\r
+--    income_accno_id_1, expense_accno_id_1,\r
+--    income_accno_id_2, expense_accno_id_2,\r
+--    income_accno_id_3, expense_accno_id_3)\r
+--  VALUES\r
+--   ('Standard 16%',\r
+--    -- 1140: Bestand Waren\r
+--    (SELECT id FROM chart WHERE accno = '1140'),\r
+--    -- 4400: Erlöse 16% USt.\r
+--    -- 5400: Wareneingang 16% Vorsteuer\r
+--    (SELECT id FROM chart WHERE accno = '4400'),\r
+--    (SELECT id FROM chart WHERE accno = '5400'),\r
+--    -- 4125: Steuerfrei innergem. Lieferungen §41bUStG\r
+--    -- 5550: Steuerfreier innergem.Erwerb\r
+--    (SELECT id FROM chart WHERE accno = '4125'),\r
+--    (SELECT id FROM chart WHERE accno = '5550'),\r
+--    -- 4315: Erlös Inland stpfl.EG-Lieferung 16%\r
+--    -- 5425: Innergem.Erwerb 16% VorSt u. Ust\r
+--    (SELECT id FROM chart WHERE accno = '4315'),\r
+--    (SELECT id FROM chart WHERE accno = '5425'),\r
+--    -- 4150: Sonstige steuerfreie Umsätze §42-7UStG\r
+--    -- 5559: Steuerfreie Einfuhren\r
+--    (SELECT id FROM chart WHERE accno = '4150'),\r
+--    (SELECT id FROM chart WHERE accno = '5559'));\r
+\r
+-- INSERT INTO buchungsgruppen\r
+--   (description, inventory_accno_id,\r
+--    income_accno_id_0, expense_accno_id_0,\r
+--    income_accno_id_1, expense_accno_id_1,\r
+--    income_accno_id_2, expense_accno_id_2,\r
+--    income_accno_id_3, expense_accno_id_3)\r
+--  VALUES\r
+--   ('Standard 7%',\r
+--    -- 1140: Bestand Waren\r
+--    (SELECT id FROM chart WHERE accno = '1140'),\r
+--    -- 4300: Erlöse 7%USt\r
+--    -- 5300: Wareneingang 7% Vorsteuer\r
+--    (SELECT id FROM chart WHERE accno = '4300'),\r
+--    (SELECT id FROM chart WHERE accno = '5300'),\r
+--    -- 4125: Steuerfrei innergem. Lieferungen §41bUStG\r
+--    -- 5550: Steuerfreier innergem.Erwerb\r
+--    (SELECT id FROM chart WHERE accno = '4125'),\r
+--    (SELECT id FROM chart WHERE accno = '5550'),\r
+--    -- 4310: Erlöse Inland stpfl. EG-Lieferung7%\r
+--    -- 5420: Innergemein.Erwerb 7% VorSt u. Ust\r
+--    (SELECT id FROM chart WHERE accno = '4310'),\r
+--    (SELECT id FROM chart WHERE accno = '5420'),\r
+--    -- 4150: Sonstige steuerfreie Umsätze §42-7UStG\r
+--    -- 5559; Steuerfreie Einfuhren\r
+--    (SELECT id FROM chart WHERE accno = '4150'),\r
+--    (SELECT id FROM chart WHERE accno = '5559'));\r