From 95196671f448d1f0b4f5adf52c260f59f1e32683 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Jan=20B=C3=BCren?= Date: Thu, 3 Mar 2022 13:50:24 +0100 Subject: [PATCH] =?utf8?q?reverse=20Charge=20Upgrade=20Skript.=20Syntax=20?= =?utf8?q?und=20Vorg=C3=A4ngerversion?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- sql/Pg-upgrade2/tax_reverse_charge.sql | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) diff --git a/sql/Pg-upgrade2/tax_reverse_charge.sql b/sql/Pg-upgrade2/tax_reverse_charge.sql index cf075a954..fd1e7551d 100644 --- a/sql/Pg-upgrade2/tax_reverse_charge.sql +++ b/sql/Pg-upgrade2/tax_reverse_charge.sql @@ -1,6 +1,6 @@ -- @tag: tax_reverse_charge -- @description: Reverse Charge für Kreditorenbelege --- @depends: release_3_5_0 +-- @depends: release_3_6_0 -- @ignore: 0 ALTER TABLE tax add column reverse_charge_chart_id integer; @@ -99,7 +99,6 @@ WHERE EXISTS ( -- update only for SKR03 WHERE defaults.coa='Germany-DATEV-SKR04EU' ); -; -- if not defined insert into taxkeys(chart_id,tax_id,taxkey_id,startdate) SELECT (SELECT chart_id FROM tax WHERE taxkey = '94'),0,0,'1970-01-01' WHERE NOT EXISTS (SELECT chart_id from taxkeys where chart_id = ( SELECT chart_id FROM tax WHERE taxkey = '94')); -- 2.20.1