projekt kivitendo

-- @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');

UPDATE chart SET category = 'E' WHERE accno = '3731' AND EXISTS (SELECT * FROM defaults WHERE coa = 'Germany-DATEV-SKR03EU');

UPDATE chart SET category = 'E' WHERE accno = '3735' AND EXISTS (SELECT * FROM defaults WHERE coa = 'Germany-DATEV-SKR03EU');

UPDATE chart SET category = 'I' WHERE accno = '4731' AND EXISTS (SELECT * FROM defaults WHERE coa = 'Germany-DATEV-SKR04EU');

UPDATE chart SET category = 'I' WHERE accno = '4735' AND EXISTS (SELECT * FROM defaults WHERE coa = 'Germany-DATEV-SKR04EU');

UPDATE chart SET category = 'I' WHERE accno = '4736' AND EXISTS (SELECT * FROM defaults WHERE coa = 'Germany-DATEV-SKR04EU');

UPDATE chart SET category = 'E' WHERE accno = '5731' AND EXISTS (SELECT * FROM defaults WHERE coa = 'Germany-DATEV-SKR04EU');

UPDATE chart SET category = 'E' WHERE accno = '5735' AND EXISTS (SELECT * FROM defaults WHERE coa = 'Germany-DATEV-SKR04EU');