X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/dbda14c263efd93aca3b7114015a47d86b8581e3..3774d83b865ab246d13077d24699b987a7a7aa05:/sql/Pg-upgrade2/chart_names.sql diff --git a/sql/Pg-upgrade2/chart_names.sql b/sql/Pg-upgrade2/chart_names.sql index 55a2e3144..4f3780e51 100644 --- a/sql/Pg-upgrade2/chart_names.sql +++ b/sql/Pg-upgrade2/chart_names.sql @@ -2,10 +2,10 @@ -- @description: Behebt ein paar Schreibfehler in Kontennamen in den Kontenramen SKR03 und SKR04. -- @depends: UPDATE chart - SET description = replace(description, 'Saldenverträge', 'Saldenvorträge') + 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%'); + (description LIKE 'Saldenverträge%'); UPDATE chart SET description = replace(description, 'Abziebare', 'Abziehbare') WHERE