From bb84bc55a14e2124d1dfd899d8e7afaad152a35d Mon Sep 17 00:00:00 2001 From: =?utf8?q?Jan=20B=C3=BCren?= Date: Tue, 1 Mar 2022 13:51:22 +0100 Subject: [PATCH] DB-Upgrade tax_reverse_charge, syntaktischen Fehler behoben --- sql/Pg-upgrade2/tax_reverse_charge.sql | 9 +++++---- 1 file changed, 5 insertions(+), 4 deletions(-) diff --git a/sql/Pg-upgrade2/tax_reverse_charge.sql b/sql/Pg-upgrade2/tax_reverse_charge.sql index bf1a07d80..cf075a954 100644 --- a/sql/Pg-upgrade2/tax_reverse_charge.sql +++ b/sql/Pg-upgrade2/tax_reverse_charge.sql @@ -1,7 +1,7 @@ -- @tag: tax_reverse_charge -- @description: Reverse Charge für Kreditorenbelege --- @depends: release_3_6_0 --- @ignore: 1 +-- @depends: release_3_5_0 +-- @ignore: 0 ALTER TABLE tax add column reverse_charge_chart_id integer; @@ -102,7 +102,8 @@ WHERE EXISTS ( -- update only for SKR03 ; -- 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') ; + (SELECT chart_id from taxkeys where chart_id = ( SELECT chart_id FROM tax WHERE taxkey = '94')); + insert into taxkeys(chart_id,tax_id,taxkey_id,startdate) SELECT (SELECT reverse_charge_chart_id FROM tax WHERE taxkey = '94'),0,0,'1970-01-01' WHERE NOT EXISTS - (SELECT chart_id from taxkeys where chart_id = ( SELECT reverse_charge_chart_id FROM tax WHERE taxkey = '94'); + (SELECT chart_id from taxkeys where chart_id = ( SELECT reverse_charge_chart_id FROM tax WHERE taxkey = '94')); -- 2.20.1