1 -- @tag: remove_taxkey_15_17_skr04
2 -- @description: Steuer mit Schlüssel 15 und 17 (16%) für SKR04 entfernen, wenn nicht verknüpft
3 -- @depends: release_3_5_5
6 WHERE (SELECT coa FROM defaults) LIKE 'Germany-DATEV-SKR04EU'
8 AND chart_id = (SELECT chart_id FROM chart WHERE accno LIKE '1403')
10 AND NOT EXISTS (SELECT id FROM taxkeys WHERE tax_id = tax.id)
11 AND NOT EXISTS (SELECT id FROM acc_trans WHERE tax_id = tax.id);
14 WHERE (SELECT coa FROM defaults) LIKE 'Germany-DATEV-SKR04EU'
16 AND chart_id = (SELECT chart_id FROM chart WHERE accno LIKE '3803')
18 AND NOT EXISTS (SELECT id FROM taxkeys WHERE tax_id = tax.id)
19 AND NOT EXISTS (SELECT id FROM acc_trans WHERE tax_id = tax.id);