1 -- @tag: rename_buchungsgruppen_accounts_16_19_percent
2 -- @description: Benennt einige Buchungsgruppen und Konten von "... 16%" in "... 16%/19%" um. Wird nur beim SKR03 und SKR04 gemacht.
5 SET description = 'Standard 16%/19%'
7 ((SELECT coa FROM defaults) IN ('Germany-DATEV-SKR03EU', 'Germany-DATEV-SKR04EU')) AND
8 (description = 'Standard 16%');
9 UPDATE chart SET description = replace(description, '16%', '16%/19%')
11 ((SELECT coa FROM defaults) IN ('Germany-DATEV-SKR03EU', 'Germany-DATEV-SKR04EU')) AND
12 (link NOT ILIKE '%tax%') AND
13 (description ~ '16%') AND (description !~ '19%');