X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;ds=sidebyside;f=sql%2FPg-upgrade2%2Fchart_type_skonto.sql;h=71eb42bcb42c931364cd920f2080d12eda1eb708;hb=a6e0a7f493d24aec0eebede85eeaa5e724bd2e11;hp=2a090e1b81b5aba0da26c3212513de4381232c89;hpb=9e48b29b3c99d6e7675fbb17a3612c6899405595;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');