projekt kivitendo

-- @tag: tax_reverse_charge

-- @description: Reverse Charge für Kreditorenbelege

-- @ignore: 0

ALTER TABLE tax add column reverse_charge_chart_id integer;

    WHERE defaults.coa='Germany-DATEV-SKR04EU'

);

-- if not defined

insert into taxkeys(chart_id,tax_id,taxkey_id,startdate) SELECT (SELECT chart_id FROM tax WHERE taxkey = '94'),0,0,'1970-01-01' WHERE NOT EXISTS

  (SELECT chart_id from taxkeys where chart_id = ( SELECT chart_id FROM tax WHERE taxkey = '94'));