Letztes Datenkbankupgradescript für Datenbankversionen 2.2.0.x sowie neues Schema...

[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 c12bf63..457d336 100644 (file)
--- a/sql/Germany-DATEV-SKR04EU-chart.sql
+++ b/sql/Germany-DATEV-SKR04EU-chart.sql
@@ -377,59 +377,56 @@ insert into tax (chart_id,rate,taxnumber, taxkey, taxdescription) values ((selec
 \r
 -- Buchungsgruppen\r
 \r
--- Erst einkommentieren, wenn in lx-office.sql das 2.4.0er Schema\r
--- inklusive der Tabelle 'buchungsgruppen' enthalten ist.\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 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
+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