1 -- @tag: tax_reverse_charge_key_19
2 -- @description: Reverse Charge für Kreditorenbelege Steuerschlüssel 19
3 -- @depends: release_3_6_0 clean_tax_18_19
6 UPDATE tax set rate=0.19 where taxkey=94 AND reverse_charge_chart_id is not NULL;
10 charttype, category, link,
14 '1774','Umsatzsteuer aus innergemeinschftl. Erwerb 19%',
15 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice',
17 WHERE EXISTS ( -- update only for SKR03
18 SELECT coa FROM defaults
19 WHERE defaults.coa='Germany-DATEV-SKR03EU' AND NOT EXISTS (SELECT id from chart where accno='1774')
24 reverse_charge_chart_id,
31 (SELECT id FROM chart WHERE accno = '1574'),
32 (SELECT id FROM chart WHERE accno = '1774'), 0.19,
33 '19', 'Stpf. innergemeinschaftlicher Erwerb zum vollem Vor- und Ust.-satz', 'EI'
34 WHERE EXISTS ( -- update only for SKR03
35 SELECT coa FROM defaults
36 WHERE defaults.coa='Germany-DATEV-SKR03EU'
42 reverse_charge_chart_id,
49 (SELECT id FROM chart WHERE accno = '1404'),
50 (SELECT id FROM chart WHERE accno = '3804'), 0.19,
51 '19', 'Stpf. innergemeinschaftlicher Erwerb zum vollem Vor- und Ust.-satz', 'EI'
52 WHERE EXISTS ( -- update only for SKR04
53 SELECT coa FROM defaults
54 WHERE defaults.coa='Germany-DATEV-SKR04EU'
58 insert into taxkeys(chart_id,tax_id,taxkey_id,startdate) SELECT (SELECT reverse_charge_chart_id FROM tax WHERE taxkey = '19' and rate = 0.19 and reverse_charge_chart_id is not null),0,0,'1970-01-01' WHERE NOT EXISTS
59 (SELECT chart_id from taxkeys where chart_id = ( SELECT reverse_charge_chart_id FROM tax WHERE taxkey = '19' and rate = 0.19 and reverse_charge_chart_id is not null))
60 AND (EXISTS (SELECT coa FROM defaults WHERE defaults.coa='Germany-DATEV-SKR04EU') OR EXISTS (SELECT coa FROM defaults WHERE defaults.coa='Germany-DATEV-SKR03EU'));
62 insert into taxkeys(chart_id,tax_id,taxkey_id,startdate) SELECT (SELECT chart_id FROM tax WHERE taxkey = '19' and rate = 0.19 and reverse_charge_chart_id is not null),0,0,'1970-01-01' WHERE NOT EXISTS
63 (SELECT chart_id from taxkeys where chart_id = ( SELECT chart_id FROM tax WHERE taxkey = '19' and rate = 0.19 and reverse_charge_chart_id is not null))
64 AND (EXISTS (SELECT coa FROM defaults WHERE defaults.coa='Germany-DATEV-SKR04EU') OR EXISTS (SELECT coa FROM defaults WHERE defaults.coa='Germany-DATEV-SKR03EU'));