From 0faee73dd1ca40f8dbf9f12ec7b67bbeb6575fc1 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Wed, 10 Jan 2007 13:56:40 +0000 Subject: [PATCH] Vorhandene Buchungsgruppen und Konten umbenennen, sodass dort immer "16%/19%" steht, um die Verwirrung etwas zu lindern. --- ...ename_buchungsgruppen_accounts_16_19_percent.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 sql/Pg-upgrade2/rename_buchungsgruppen_accounts_16_19_percent.sql diff --git a/sql/Pg-upgrade2/rename_buchungsgruppen_accounts_16_19_percent.sql b/sql/Pg-upgrade2/rename_buchungsgruppen_accounts_16_19_percent.sql new file mode 100644 index 000000000..f09b4c753 --- /dev/null +++ b/sql/Pg-upgrade2/rename_buchungsgruppen_accounts_16_19_percent.sql @@ -0,0 +1,13 @@ +-- @tag: rename_buchungsgruppen_accounts_16_19_percent +-- @description: Benennt einige Buchungsgruppen und Konten von "... 16%" in "... 16%/19%" um. Wird nur beim SKR03 und SKR04 gemacht. +-- @depends: +UPDATE buchungsgruppen + SET description = 'Standard 16%/19%' + WHERE + ((SELECT coa FROM defaults) IN ('Germany-DATEV-SKR03EU', 'Germany-DATEV-SKR04EU')) AND + (description = 'Standard 16%'); +UPDATE chart SET description = replace(description, '16%', '16%/19%') + WHERE + ((SELECT coa FROM defaults) IN ('Germany-DATEV-SKR03EU', 'Germany-DATEV-SKR04EU')) AND + (link NOT ILIKE '%tax%') AND + (description ~ '16%') AND (description !~ '19%'); -- 2.20.1