1 -- @tag: ustva_setup_2007_update_chart_taxkeys_tax
2 -- @description: Aktualisierung des SKR03 für 2006/2007. Es werden bisher nur Inland Buchungen 16%/19% in 2006/2007 unterstützt.
3 -- @depends: ustva_setup_2007
7 --#############################################################
9 --# Neue Konten einfügen
11 --#############################################################
16 charttype, category, link,
20 '1570','Anrechenbare Vorsteuer',
21 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice',
23 WHERE EXISTS ( -- update only for SKR03
24 SELECT coa FROM defaults
25 WHERE defaults.coa='Germany-DATEV-SKR03EU'
31 charttype, category, link,
35 '1574','Abziehbare Vorsteuer aus innergem. Erwerb 19 %',
36 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice',
38 WHERE EXISTS ( -- update only for SKR03
39 SELECT coa FROM defaults
40 WHERE defaults.coa='Germany-DATEV-SKR03EU'
46 charttype, category, link,
50 '1774','Umsatzsteuer aus innergem. Erwerb 19 %',
51 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice',
53 WHERE EXISTS ( -- update only for SKR03
54 SELECT coa FROM defaults
55 WHERE defaults.coa='Germany-DATEV-SKR03EU'
58 UPDATE chart SET description = 'Umsatzsteuer 7% innergem.Erwerb'
60 AND EXISTS ( -- update only for SKR03
61 SELECT coa FROM defaults
62 WHERE defaults.coa='Germany-DATEV-SKR03EU'
65 UPDATE chart SET description = 'Umsatzsteuer 16% innergem.Erwerb'
67 AND EXISTS ( -- update only for SKR03
68 SELECT coa FROM defaults
69 WHERE defaults.coa='Germany-DATEV-SKR03EU'
72 UPDATE chart SET description = 'Abziehbare Vorsteuer 7% innergem. Erwerb'
74 AND EXISTS ( -- update only for SKR03
75 SELECT coa FROM defaults
76 WHERE defaults.coa='Germany-DATEV-SKR03EU'
79 UPDATE chart SET description = 'Abziehbare Vorsteuer 16% innergem. Erwerb'
81 AND EXISTS ( -- update only for SKR03
82 SELECT coa FROM defaults
83 WHERE defaults.coa='Germany-DATEV-SKR03EU'
86 UPDATE chart SET description = 'Innergem. Erwerb 16%/19% VSt u. USt.'
88 AND EXISTS ( -- update only for SKR03
89 SELECT coa FROM defaults
90 WHERE defaults.coa='Germany-DATEV-SKR03EU'
93 UPDATE chart SET description = 'Innergem. Erwerb 7% VSt u. USt.'
95 AND EXISTS ( -- update only for SKR03
96 SELECT coa FROM defaults
97 WHERE defaults.coa='Germany-DATEV-SKR03EU'
100 --INSERT INTO chart (
101 -- accno, description,
102 -- charttype, category, link
105 -- '3550','Steuerfreier innergem. Erwerb',
106 -- 'A', 'E', 'AP_amount:IC_cogs'
107 --WHERE EXISTS ( -- update only for SKR03
108 -- SELECT coa FROM defaults
109 -- WHERE defaults.coa='Germany-DATEV-SKR03EU'
114 --#############################################################
116 --# Anpassungen Tabelle tax
118 --#############################################################
120 -- Steuerkontenbenennung nach DATEV
122 taxdescription = 'USt-frei'
125 EXISTS ( -- update only for SKR03
126 SELECT coa FROM defaults
127 WHERE defaults.coa='Germany-DATEV-SKR03EU'
132 taxdescription = 'Umsatzsteuer'
135 EXISTS ( -- update only for SKR03
136 SELECT coa FROM defaults
137 WHERE defaults.coa='Germany-DATEV-SKR03EU'
142 taxdescription = 'Umsatzsteuer'
145 EXISTS ( -- update only for SKR03
146 SELECT coa FROM defaults
147 WHERE defaults.coa='Germany-DATEV-SKR03EU'
151 taxdescription = 'Vorsteuer'
154 EXISTS ( -- update only for SKR03
155 SELECT coa FROM defaults
156 WHERE defaults.coa='Germany-DATEV-SKR03EU'
161 taxdescription = 'Vorsteuer'
164 EXISTS ( -- update only for SKR03
165 SELECT coa FROM defaults
166 WHERE defaults.coa='Germany-DATEV-SKR03EU'
171 taxdescription = 'Im anderen EU-Staat steuerpflichtige Lieferung'
174 EXISTS ( -- update only for SKR03
175 SELECT coa FROM defaults
176 WHERE defaults.coa='Germany-DATEV-SKR03EU'
181 taxdescription = 'Steuerfreie innergem. Lieferung an Abnehmer mit Id.-Nr.'
184 EXISTS ( -- update only for SKR03
185 SELECT coa FROM defaults
186 WHERE defaults.coa='Germany-DATEV-SKR03EU'
191 taxdescription = 'Steuerpflichtige EG-Lieferung zum ermäßigten Steuersatz'
194 EXISTS ( -- update only for SKR03
195 SELECT coa FROM defaults
196 WHERE defaults.coa='Germany-DATEV-SKR03EU'
201 taxdescription = 'Steuerpflichtige EG-Lieferung zum vollen Steuersatz'
204 EXISTS ( -- update only for SKR03
205 SELECT coa FROM defaults
206 WHERE defaults.coa='Germany-DATEV-SKR03EU'
212 taxdescription = 'Steuerpflichtiger innergem. Erwerb zum ermäßigten Steuersatz'
215 EXISTS ( -- update only for SKR03
216 SELECT coa FROM defaults
217 WHERE defaults.coa='Germany-DATEV-SKR03EU'
222 taxdescription = 'Steuerpflichtiger innergem. Erwerb zum vollen Steuersatz'
225 EXISTS ( -- update only for SKR03
226 SELECT coa FROM defaults
227 WHERE defaults.coa='Germany-DATEV-SKR03EU'
231 -- Weitere Steuerschlüssel hinzufügen
240 SELECT (SELECT id FROM chart WHERE accno = '1774'), '1774', '0.19000', taxkey, taxdescription
244 EXISTS ( -- update only for SKR03
245 SELECT coa FROM defaults
246 WHERE defaults.coa='Germany-DATEV-SKR03EU'
258 SELECT (SELECT id FROM chart WHERE accno = '1574'), '0.19000', '1574', taxkey, taxdescription
262 EXISTS ( -- update only for SKR03
263 SELECT coa FROM defaults
264 WHERE defaults.coa='Germany-DATEV-SKR03EU'
271 --#############################################################
273 --# Anpassungen Tabelle taxkeys
275 --#############################################################
278 INSERT INTO taxkeys (
279 chart_id, tax_id, taxkey_id, pos_ustva, startdate)
280 SELECT chart.id, (SELECT id FROM tax WHERE taxnumber = '1576'), '9', '66', '1970-01-01'
282 LEFT JOIN tax ON (chart.id = tax.chart_id)
283 WHERE chart.accno = '1576'
285 EXISTS ( -- update only for SKR03
286 SELECT coa FROM defaults
287 WHERE defaults.coa='Germany-DATEV-SKR03EU'
291 INSERT INTO taxkeys (
292 chart_id, tax_id, taxkey_id, pos_ustva, startdate)
293 SELECT chart.id, (SELECT id FROM tax WHERE taxnumber = '1574'), '19', '61', '1970-01-01'
295 LEFT JOIN tax ON (chart.id = tax.chart_id)
296 WHERE chart.accno = '1574'
298 EXISTS ( -- update only for SKR03
299 SELECT coa FROM defaults
300 WHERE defaults.coa='Germany-DATEV-SKR03EU'
305 INSERT INTO taxkeys (
306 chart_id, tax_id, taxkey_id, pos_ustva, startdate)
307 SELECT chart.id, '0', '0', '891', '2007-01-01'
309 LEFT JOIN tax ON (chart.id = tax.chart_id)
310 WHERE chart.accno = '1774'
312 EXISTS ( -- update only for SKR03
313 SELECT coa FROM defaults
314 WHERE defaults.coa='Germany-DATEV-SKR03EU'
318 UPDATE taxkeys SET pos_ustva = '63'
319 WHERE chart_id in (SELECT id FROM chart WHERE accno in ('1577')
320 AND startdate = '1970-01-01')
321 AND EXISTS ( -- update only for SKR03
322 SELECT coa FROM defaults
323 WHERE defaults.coa='Germany-DATEV-SKR03EU'
326 UPDATE taxkeys SET pos_ustva = '67'
327 WHERE chart_id in (SELECT id FROM chart WHERE accno in ('1578', '1579')
328 AND startdate = '1970-01-01')
329 AND EXISTS ( -- update only for SKR03
330 SELECT coa FROM defaults
331 WHERE defaults.coa='Germany-DATEV-SKR03EU'
335 INSERT INTO taxkeys (
336 chart_id, tax_id, taxkey_id, pos_ustva, startdate)
337 SELECT chart.id, '0', '0', '66', '1970-01-01'
339 LEFT JOIN tax ON (chart.id = tax.chart_id)
340 WHERE chart.accno in ('1570', '1576')
342 EXISTS ( -- update only for SKR03
343 SELECT coa FROM defaults
344 WHERE defaults.coa='Germany-DATEV-SKR03EU'
349 UPDATE taxkeys SET pos_ustva = '51'
350 WHERE chart_id in (SELECT id FROM chart WHERE accno in ('8520')
351 AND startdate = '1970-01-01')
353 EXISTS ( -- update only for SKR03
354 SELECT coa FROM defaults
355 WHERE defaults.coa='Germany-DATEV-SKR03EU'
358 INSERT INTO taxkeys (
359 chart_id, tax_id, taxkey_id, pos_ustva, startdate)
360 SELECT chart.id, (SELECT id FROM tax WHERE taxnumber = '1776'), '0', '36', '1970-01-01'
362 LEFT JOIN tax ON (chart.id = tax.chart_id)
363 WHERE chart.accno = '1776'
365 EXISTS ( -- update only for SKR03
366 SELECT coa FROM defaults
367 WHERE defaults.coa='Germany-DATEV-SKR03EU'
371 INSERT INTO taxkeys (
372 chart_id, tax_id, taxkey_id, pos_ustva, startdate)
373 SELECT chart.id, (SELECT id FROM tax WHERE taxnumber = '1775'), '0', '36', '2007-01-01'
375 LEFT JOIN tax ON (chart.id = tax.chart_id)
376 WHERE chart.accno = '1775'
378 EXISTS ( -- update only for SKR03
379 SELECT coa FROM defaults
380 WHERE defaults.coa='Germany-DATEV-SKR03EU'