1 -- @tag: tax_reverse_charge
2 -- @description: Reverse Charge für Kreditorenbelege
3 -- @depends: release_3_6_0
6 ALTER TABLE tax add column reverse_charge_chart_id integer;
10 charttype, category, link,
14 '1577','Abziehbare Vorst. nach §13b UstG 19%',
15 'A', 'E', 'AP_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='1577')
24 charttype, category, link,
28 '1787','Umsatzsteuer nach §13b UStG 19%',
29 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice',
31 WHERE EXISTS ( -- update only for SKR03
32 SELECT coa FROM defaults
33 WHERE defaults.coa='Germany-DATEV-SKR03EU' AND NOT EXISTS (SELECT id from chart where accno='1787')
39 charttype, category, link,
43 '1407','Abziehbare Vorst. nach §13b UstG 19%',
44 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice',
46 WHERE EXISTS ( -- update only for SKR04
47 SELECT coa FROM defaults
48 WHERE defaults.coa='Germany-DATEV-SKR04EU' AND NOT EXISTS (SELECT id from chart where accno='1407')
53 charttype, category, link,
57 '3837','Umsatzsteuer nach §13b UStG 19%',
58 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice',
60 WHERE EXISTS ( -- update only for SKR04
61 SELECT coa FROM defaults
62 WHERE defaults.coa='Germany-DATEV-SKR04EU' AND NOT EXISTS (SELECT id from chart where accno='3837')
69 reverse_charge_chart_id,
76 (SELECT id FROM chart WHERE accno = '1577'),
77 (SELECT id FROM chart WHERE accno = '1787'), 0,
78 '94', '19% Vorsteuer und 19% Umsatzsteuer', 'EI'
79 WHERE EXISTS ( -- update only for SKR03
80 SELECT coa FROM defaults
81 WHERE defaults.coa='Germany-DATEV-SKR03EU'
87 reverse_charge_chart_id,
94 (SELECT id FROM chart WHERE accno = '1407'),
95 (SELECT id FROM chart WHERE accno = '3837'), 0,
96 '94', '19% Vorsteuer und 19% Umsatzsteuer', 'EI'
97 WHERE EXISTS ( -- update only for SKR03
98 SELECT coa FROM defaults
99 WHERE defaults.coa='Germany-DATEV-SKR04EU'
103 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
104 (SELECT chart_id from taxkeys where chart_id = ( SELECT chart_id FROM tax WHERE taxkey = '94'))
105 AND (EXISTS (SELECT coa FROM defaults WHERE defaults.coa='Germany-DATEV-SKR04EU') OR EXISTS (SELECT coa FROM defaults WHERE defaults.coa='Germany-DATEV-SKR03EU'));
107 insert into taxkeys(chart_id,tax_id,taxkey_id,startdate) SELECT (SELECT reverse_charge_chart_id FROM tax WHERE taxkey = '94'),0,0,'1970-01-01' WHERE NOT EXISTS
108 (SELECT chart_id from taxkeys where chart_id = ( SELECT reverse_charge_chart_id FROM tax WHERE taxkey = '94'))
109 AND (EXISTS (SELECT coa FROM defaults WHERE defaults.coa='Germany-DATEV-SKR04EU') OR EXISTS (SELECT coa FROM defaults WHERE defaults.coa='Germany-DATEV-SKR03EU'));