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