From 8b3f1910b40a6e282302e32c635ca8b2e880e4c8 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Jan=20B=C3=BCren?= Date: Fri, 11 Feb 2022 13:11:08 +0100 Subject: [PATCH] =?utf8?q?advance=5Fpayment=5Ftransfer=5Fcharts:=20Erg?= =?utf8?q?=C3=A4nzung=20Abh=C3=A4ngigkeit=20und=20chart.link=20setzen?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- sql/Pg-upgrade2/defaults_advance_payment_transfer_charts.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/sql/Pg-upgrade2/defaults_advance_payment_transfer_charts.sql b/sql/Pg-upgrade2/defaults_advance_payment_transfer_charts.sql index 9205e2eba..864e7a483 100644 --- a/sql/Pg-upgrade2/defaults_advance_payment_transfer_charts.sql +++ b/sql/Pg-upgrade2/defaults_advance_payment_transfer_charts.sql @@ -1,10 +1,12 @@ -- @tag: defaults_advance_payment_transfer_charts -- @description: Standardkonten für erhaltene versteuerte Anzahlungen 7% und 19% setzen --- @depends:new_chart_3260_1711 new_chart_3272_1718 +-- @depends:new_chart_3260_1711 new_chart_3272_1718 defaults_advance_payment_clearing_chart_id ALTER TABLE defaults ADD COLUMN advance_payment_taxable_19_id INTEGER; ALTER TABLE defaults ADD COLUMN advance_payment_taxable_7_id INTEGER; +UPDATE charts set link ='AR' where id = (select advance_payment_clearing_chart_id from defaults); + DO $$ BEGIN -- 2.20.1