From e1bf8f8f3366b79d63cc5e2ee39ccb60cd893e1f Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Fri, 21 Jan 2011 12:05:56 +0100 Subject: [PATCH] =?utf8?q?Bei=20SKR04=20Steuer-Eintr=C3=A4ge=20f=C3=BCr=20?= =?utf8?q?19%=20ab=202007=20anlegen?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Diese sind in Revision a921e75a fälschlicherweise entfernt worden. Fix für Bug 1551. --- sql/Germany-DATEV-SKR04EU-chart.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/sql/Germany-DATEV-SKR04EU-chart.sql b/sql/Germany-DATEV-SKR04EU-chart.sql index 4c0a4643f..1da01245f 100644 --- a/sql/Germany-DATEV-SKR04EU-chart.sql +++ b/sql/Germany-DATEV-SKR04EU-chart.sql @@ -398,6 +398,8 @@ INSERT INTO tax (chart_id,rate,taxnumber, taxkey, taxdescription) VALUES ((SEL -- Ergaenzungen fuer 19% UmSt. ab 1.01.2007 +INSERT INTO tax (chart_id, rate, taxnumber, taxkey, taxdescription) VALUES ((SELECT id from CHART WHERE accno='3806'), 0.19, '3806', 3, 'Umsatzsteuer 19%'); +INSERT INTO tax (chart_id, rate, taxnumber, taxkey, taxdescription) VALUES ((SELECT id from CHART WHERE accno='1406'), 0.19, '1406', 9, 'Vorsteuer 19%'); insert into taxkeys (chart_id, tax_id, taxkey_id, pos_ustva, startdate) select chart.id, tax.id, taxkey_id, pos_ustva, '1970-01-01' from chart LEFT JOIN tax on (tax.taxkey=chart.taxkey_id) WHERE taxkey_id is not null; insert into taxkeys (chart_id, tax_id, taxkey_id,startdate) SELECT 0, id, taxkey, '1970-01-01' FROM tax; insert into taxkeys (chart_id, tax_id, taxkey_id, pos_ustva, startdate) select chart.id, (SELECT id from tax where taxdescription='Umsatzsteuer 19%'), 3, pos_ustva, '2007-01-01' from chart WHERE taxkey_id=3; -- 2.20.1