From 196ddeefd71a42cb7ce5c35f120e3e9c91d63f61 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Tue, 7 Jan 2014 12:41:04 +0100 Subject: [PATCH 1/1] =?utf8?q?SKR04:=20beim=20Anlegen=20Steuersatz=20f?= =?utf8?q?=C3=BCr=20Steuerschl=C3=BCssel=2010=20und=2011=20hinterlegen?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Siehe #2130. --- sql/Germany-DATEV-SKR04EU-chart.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/sql/Germany-DATEV-SKR04EU-chart.sql b/sql/Germany-DATEV-SKR04EU-chart.sql index 9af9e2c5a..80833c1f0 100644 --- a/sql/Germany-DATEV-SKR04EU-chart.sql +++ b/sql/Germany-DATEV-SKR04EU-chart.sql @@ -386,8 +386,8 @@ INSERT INTO tax VALUES ((SEL INSERT INTO tax VALUES ((SELECT id FROM chart WHERE accno = '1401'),'0.07','1401','8','Vorsteuer'); INSERT INTO tax VALUES ((SELECT id FROM chart WHERE accno = '1405'),'0.16','1405','7','Vorsteuer'); INSERT INTO tax (chart_id, rate, taxnumber, taxkey, taxdescription) VALUES ((SELECT id FROM CHART WHERE accno='1406'), 0.19, '1406', 9, 'Vorsteuer'); -INSERT INTO tax (taxkey, taxdescription) VALUES ('10','Im anderen EG-Staat steuerpfl. Lieferung'); -INSERT INTO tax (taxkey, taxdescription) VALUES ('11','Steuerfreie EG-Lief. an Abn. mit UStIdNr'); +INSERT INTO tax (rate, taxkey, taxdescription) VALUES (0, '10','Im anderen EG-Staat steuerpfl. Lieferung'); +INSERT INTO tax (rate, taxkey, taxdescription) VALUES (0, '11','Steuerfreie EG-Lief. an Abn. mit UStIdNr'); INSERT INTO tax (chart_id, rate,taxnumber, taxkey, taxdescription) VALUES ((SELECT id FROM chart WHERE accno = '3802'),'0.07','3802','12','Steuerpflicht. EG-Lieferungen'); INSERT INTO tax (chart_id,rate,taxnumber, taxkey, taxdescription) VALUES ((SELECT id FROM chart WHERE accno = '3804'),'0.19','3804','13','Steuerpflicht. EG-Lieferungen%'); INSERT INTO tax (chart_id,rate,taxnumber, taxkey, taxdescription) VALUES ((SELECT id FROM chart WHERE accno = '3803'),'0.16','3803','15','Steuerpflicht. EG-Lieferungen%'); -- 2.20.1