From 783025d9124f670692ca81331b7b55de707c369c Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Tue, 30 Jul 2013 09:19:12 +0200 Subject: [PATCH] =?utf8?q?Neue=20Kontoverbindung=20f=C3=BCr=20FA=20Bad=20H?= =?utf8?q?omburg?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Fixt #2315. --- sql/Pg-upgrade2/accounts_tax_office_bad_homburg.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 sql/Pg-upgrade2/accounts_tax_office_bad_homburg.sql diff --git a/sql/Pg-upgrade2/accounts_tax_office_bad_homburg.sql b/sql/Pg-upgrade2/accounts_tax_office_bad_homburg.sql new file mode 100644 index 000000000..0f09f7eda --- /dev/null +++ b/sql/Pg-upgrade2/accounts_tax_office_bad_homburg.sql @@ -0,0 +1,9 @@ +-- @tag: accounts_tax_office_bad_homburg +-- @description: Neue Kontoverbindung für Finanzamt Bad Homburg +-- @depends: release_3_0_0 +UPDATE finanzamt +SET fa_bankbezeichnung_1 = 'Landesbank Hessen-Thüringen', fa_blz_1 = '50050000', fa_kontonummer_1 = '1000124', + fa_bankbezeichnung_2 = 'DT BBK Filiale Frankfurt am Main', fa_blz_2 = '50000000', fa_kontonummer_2 = '50001501' +WHERE (fa_land_nr = '6') + AND (fa_bufa_nr = '2603') + AND (fa_name LIKE 'Bad Homburg%'); -- 2.20.1