kivitendo/sql/Pg-upgrade2/chart_names2.sql @ bf5e6c6a
| fbddd776 | Moritz Bunkus | -- @tag: chart_names2
|
||
-- @description: Behebt ein paar Schreibfehler in Kontennamen in den Kontenramen SKR03 und SKR04.
|
||||
-- @depends:
|
||||
UPDATE chart
|
||||
SET description = 'Fahrzeugkosten'
|
||||
WHERE
|
||||
((SELECT coa FROM defaults) IN ('Germany-DATEV-SKR03EU', 'Germany-DATEV-SKR04EU')) AND
|
||||
(description = 'Fahrzugkosten');
|
||||
UPDATE chart
|
||||
SET description = replace(description, 'Unentgeld', 'Unentgelt')
|
||||
WHERE
|
||||
((SELECT coa FROM defaults) IN ('Germany-DATEV-SKR03EU', 'Germany-DATEV-SKR04EU')) AND
|
||||
| 784cf1e9 | Moritz Bunkus | (description LIKE '%Unentgeld%');
|