X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Fustva_setup_2007_update_chart_taxkeys_tax.sql;h=56737e80e57d08e9b3f5c610751067fb7421ac0d;hb=d18df453f55190d4807af324725ea82a8835d7fc;hp=b2d11b5d6b0839226ffe3fffe17715fef010c5ba;hpb=e8d3bc67310c9326192088ad3ef50c7959caa004;p=kivitendo-erp.git

diff --git a/sql/Pg-upgrade2/ustva_setup_2007_update_chart_taxkeys_tax.sql b/sql/Pg-upgrade2/ustva_setup_2007_update_chart_taxkeys_tax.sql
index b2d11b5d6..56737e80e 100644
--- a/sql/Pg-upgrade2/ustva_setup_2007_update_chart_taxkeys_tax.sql
+++ b/sql/Pg-upgrade2/ustva_setup_2007_update_chart_taxkeys_tax.sql
@@ -13,11 +13,13 @@
 
 INSERT INTO chart (
   accno, description,
-  charttype,   category,  link
+  charttype,   category,  link,
+  taxkey_id
   )
 SELECT
   '1570','Anrechenbare Vorsteuer',
-  'A',         'E',       'AP_tax:IC_taxpart:IC_taxservice:CT_tax'
+  'A',         'E',       'AP_tax:IC_taxpart:IC_taxservice:CT_tax',
+  0
 WHERE EXISTS ( -- update only for SKR03
     SELECT coa FROM defaults
     WHERE defaults.coa='Germany-DATEV-SKR03EU'
@@ -26,11 +28,13 @@ WHERE EXISTS ( -- update only for SKR03
 
 INSERT INTO chart (
   accno, description,
-  charttype,   category,  link
+  charttype,   category,  link,
+  taxkey_id
   )
 SELECT
   '1574','Abziehbare Vorsteuer aus innergem. Erwerb 19 %',
-  'A',         'E',       'AP_tax:IC_taxpart:IC_taxservice:CT_tax'
+  'A',         'E',       'AP_tax:IC_taxpart:IC_taxservice:CT_tax',
+  0
 WHERE EXISTS ( -- update only for SKR03
     SELECT coa FROM defaults
     WHERE defaults.coa='Germany-DATEV-SKR03EU'
@@ -39,11 +43,13 @@ WHERE EXISTS ( -- update only for SKR03
 
 INSERT INTO chart (
   accno, description,
-  charttype,   category,  link
+  charttype,   category,  link,
+  taxkey_id
   )
 SELECT
   '1774','Umsatzsteuer aus innergem. Erwerb 19 %',
-  'A',         'I',       'AR_tax:IC_taxpart:IC_taxservice:CT_tax'
+  'A',         'I',       'AR_tax:IC_taxpart:IC_taxservice:CT_tax',
+  0
 WHERE EXISTS ( -- update only for SKR03
     SELECT coa FROM defaults
     WHERE defaults.coa='Germany-DATEV-SKR03EU'