kivitendo/sql/Pg-upgrade2/chart_names.sql @ 4cb374f9
| 72df4319 | Moritz Bunkus | -- @tag: chart_names
|
||
-- @description: Behebt ein paar Schreibfehler in Kontennamen in den Kontenramen SKR03 und SKR04.
|
||||
-- @depends:
|
||||
UPDATE chart
|
||||
| 3774d83b | Moritz Bunkus | SET description = replace(description, 'Saldenverträge', 'Saldenvorträge')
|
||
| 72df4319 | Moritz Bunkus | WHERE
|
||
((SELECT coa FROM defaults) IN ('Germany-DATEV-SKR03EU', 'Germany-DATEV-SKR04EU')) AND
|
||||
| 3774d83b | Moritz Bunkus | (description LIKE 'Saldenverträge%');
|
||
| 72df4319 | Moritz Bunkus | UPDATE chart
|
||
SET description = replace(description, 'Abziebare', 'Abziehbare')
|
||||
WHERE
|
||||
((SELECT coa FROM defaults) IN ('Germany-DATEV-SKR03EU', 'Germany-DATEV-SKR04EU')) AND
|
||||
(description LIKE 'Abziehbare%');
|