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

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

diff --git a/sql/Germany-DATEV-SKR03EU-chart.sql b/sql/Germany-DATEV-SKR03EU-chart.sql
index 20495d8..9047001 100644 (file)
--- a/sql/Germany-DATEV-SKR03EU-chart.sql
+++ b/sql/Germany-DATEV-SKR03EU-chart.sql
@@ -444,59 +444,56 @@ 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 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'));
+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'));