From 3cd8c81091fbe4c149e3932bd9b7b465fea69053 Mon Sep 17 00:00:00 2001 From: Robert Scheck Date: Mon, 2 Apr 2018 03:04:37 +0200 Subject: [PATCH] Reflect changed data of tax office Leonberg (since 2018) See also: - http://www.fa-leonberg.de/pb/,Lde/Startseite - http://www.fa-leonberg.de/pb/,Lde/Startseite/Ihr+Finanzamt/Bankverbindungen --- sql/Pg-upgrade2/accounts_tax_office_leonberg.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 sql/Pg-upgrade2/accounts_tax_office_leonberg.sql diff --git a/sql/Pg-upgrade2/accounts_tax_office_leonberg.sql b/sql/Pg-upgrade2/accounts_tax_office_leonberg.sql new file mode 100644 index 000000000..11e67be98 --- /dev/null +++ b/sql/Pg-upgrade2/accounts_tax_office_leonberg.sql @@ -0,0 +1,12 @@ +-- @tag: accounts_tax_office_leonberg +-- @description: Geänderte Kontoverbindung, Öffnungszeiten und Kontaktdaten für Finanzamt Leonberg +-- @depends: release_3_5_2 +UPDATE finanzamt +SET fa_bankbezeichnung_1 = 'DT BBK Filiale Stuttgart', fa_blz_1 = '60000000', fa_kontonummer_1 = '60301501', + fa_bankbezeichnung_2 = '', fa_blz_2 = '', fa_kontonummer_2 = '', + fa_oeffnungszeiten = 'MO-MI 7.30-12.00,DO 7.30-17.30,FR 7.30-12.30', + fa_email = 'poststelle-70@finanzamt.bwl.de', + fa_internet = 'http://www.fa-leonberg.de/' +WHERE (fa_land_nr = '8') + AND (fa_bufa_nr = '2870') + AND (fa_name LIKE 'Leonberg%'); -- 2.20.1