X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Fchart_type_skonto.sql;h=71eb42bcb42c931364cd920f2080d12eda1eb708;hb=2144dd8e1a7ed9da5f164d87165d3dce01b8f53b;hp=2a090e1b81b5aba0da26c3212513de4381232c89;hpb=781c16772f3c80cc827f11815bfb07b8318621f0;p=kivitendo-erp.git diff --git a/sql/Pg-upgrade2/chart_type_skonto.sql b/sql/Pg-upgrade2/chart_type_skonto.sql index 2a090e1b8..71eb42bcb 100644 --- a/sql/Pg-upgrade2/chart_type_skonto.sql +++ b/sql/Pg-upgrade2/chart_type_skonto.sql @@ -1,7 +1,6 @@ -- @tag: chart_type_skonto -- @description: SKR: Gewährte Skonti sind Erlöskonten, erhaltene Skonti sind Aufwandskonten -- @depends: release_2_7_0 --- @encoding: utf-8 UPDATE chart SET category = 'I' WHERE accno = '8731' AND EXISTS (SELECT * FROM defaults WHERE coa = 'Germany-DATEV-SKR03EU'); UPDATE chart SET category = 'I' WHERE accno = '8735' AND EXISTS (SELECT * FROM defaults WHERE coa = 'Germany-DATEV-SKR03EU');