X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/72df4319989c030a3beb476528114ea8784e16aa..3b5dc7b68b53ea153b9716f9b85c3b6dc3a71574:/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