1 -- @tag: ustva_setup_2007
2 -- @description: Aktualisierung des SKR03 für 2006
3 -- @depends: customer_vendor_taxzone_id
5 update taxkeys set pos_ustva='81' where startdate='2007-01-01'
8 EXISTS ( -- update only for SKR03
9 SELECT coa FROM defaults
10 WHERE defaults.coa='Germany-DATEV-SKR03EU'
14 UPDATE taxkeys SET pos_ustva='511'
15 WHERE startdate='1970-01-01'
16 AND chart_id = (select id from chart where accno ='1775')
18 EXISTS ( -- update only for SKR03
19 SELECT coa FROM defaults
20 WHERE defaults.coa='Germany-DATEV-SKR03EU'
25 chart_id, tax_id, taxkey_id, pos_ustva, startdate)
26 SELECT chart.id, tax.id, taxkey_id, '811', '2007-01-01'
28 LEFT JOIN tax ON (chart.id = tax.chart_id)
29 WHERE chart.accno = '1776'
31 EXISTS ( -- update only for SKR03
32 SELECT coa FROM defaults
33 WHERE defaults.coa='Germany-DATEV-SKR03EU'