From 80d94bafcfb3304ab0adadb8df8bd4d9d37badeb Mon Sep 17 00:00:00 2001
From: Moritz Bunkus <m.bunkus@linet-services.de>
Date: Wed, 21 Mar 2007 09:13:24 +0000
Subject: [PATCH] =?utf8?q?Beim=20Kontenrahmen=20SKR04=20den=20Steuersatz?=
 =?utf8?q?=20aus=20der=20Steuerschl=C3=BCsselbeschreibung=20herausnehmen,?=
 =?utf8?q?=20weil=20der=20vom=20Programm=20inzwischen=20zus=C3=A4tzlich=20?=
 =?utf8?q?angezeigt=20wird.?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 ...x_description_without_percentage_skr04.sql | 122 ++++++++++++++++++
 1 file changed, 122 insertions(+)
 create mode 100644 sql/Pg-upgrade2/tax_description_without_percentage_skr04.sql

diff --git a/sql/Pg-upgrade2/tax_description_without_percentage_skr04.sql b/sql/Pg-upgrade2/tax_description_without_percentage_skr04.sql
new file mode 100644
index 000000000..5b76ae927
--- /dev/null
+++ b/sql/Pg-upgrade2/tax_description_without_percentage_skr04.sql
@@ -0,0 +1,122 @@
+-- @tag: tax_description_without_percentage_skr04
+-- @description: SKR04: Die Prozentangaben aus der tax.taxdescription entfernen. (Unter Ber&uuml;cksichtigung der Druckausgabe.)
+-- @depends: ustva_setup_2007
+
+--#############################################################
+--#
+--# Taxdescription setzen
+--#
+--#############################################################
+
+UPDATE tax SET
+  taxdescription = 'USt-frei'
+WHERE taxkey = '1'
+  AND
+  EXISTS ( -- update only for SKR04
+    SELECT coa FROM defaults
+    WHERE defaults.coa='Germany-DATEV-SKR04EU'
+  )
+;
+
+UPDATE tax SET
+  taxdescription = 'Umsatzsteuer'
+WHERE taxkey = '2'
+  AND
+  EXISTS ( -- update only for SKR04
+    SELECT coa FROM defaults
+    WHERE defaults.coa='Germany-DATEV-SKR04EU'
+  )
+;
+
+UPDATE tax SET
+  taxdescription = 'Umsatzsteuer'
+WHERE taxkey = '3'
+  AND
+  EXISTS ( -- update only for SKR04
+    SELECT coa FROM defaults
+    WHERE defaults.coa='Germany-DATEV-SKR04EU'
+  )
+;
+
+
+UPDATE tax SET
+  taxdescription = 'Vorsteuer'
+WHERE taxkey = '8'
+  AND
+  EXISTS ( -- update only for SKR04
+    SELECT coa FROM defaults
+    WHERE defaults.coa='Germany-DATEV-SKR04EU'
+  )
+;
+
+UPDATE tax SET
+  taxdescription = 'Vorsteuer'
+WHERE taxkey = '9'
+  AND
+  EXISTS ( -- update only for SKR04
+    SELECT coa FROM defaults
+    WHERE defaults.coa='Germany-DATEV-SKR04EU'
+  )
+;
+
+UPDATE tax SET
+  taxdescription = 'Im anderen EU-Staat steuerpflichtige Lieferung'
+WHERE taxkey = '10'
+  AND
+  EXISTS ( -- update only for SKR04
+    SELECT coa FROM defaults
+    WHERE defaults.coa='Germany-DATEV-SKR04EU'
+  )
+;
+
+UPDATE tax SET
+  taxdescription = 'Steuerfreie innergem. Lieferung an Abnehmer mit Id.-Nr.'
+WHERE taxkey = '11'
+  AND
+  EXISTS ( -- update only for SKR04
+    SELECT coa FROM defaults
+    WHERE defaults.coa='Germany-DATEV-SKR04EU'
+  )
+;
+
+UPDATE tax SET
+  taxdescription = 'Steuerpflichtige EG-Lieferung zum ermäßigten Steuersatz'
+WHERE taxkey = '12'
+  AND
+  EXISTS ( -- update only for SKR04
+    SELECT coa FROM defaults
+    WHERE defaults.coa='Germany-DATEV-SKR04EU'
+  )
+;
+
+
+UPDATE tax SET
+  taxdescription = 'Steuerpflichtige EG-Lieferung zum vollen Steuersatz'
+WHERE taxkey = '13'
+  AND
+  EXISTS ( -- update only for SKR04
+    SELECT coa FROM defaults
+    WHERE defaults.coa='Germany-DATEV-SKR04EU'
+  )
+;
+
+
+UPDATE tax SET
+  taxdescription = 'Steuerpflichtiger innergem. Erwerb zum ermäßigten Steuersatz'
+WHERE taxkey = '18'
+  AND
+  EXISTS ( -- update only for SKR04
+    SELECT coa FROM defaults
+    WHERE defaults.coa='Germany-DATEV-SKR04EU'
+  )
+;
+
+UPDATE tax SET
+  taxdescription = 'Steuerpflichtiger innergem. Erwerb zum vollen Steuersatz'
+WHERE taxkey = '19'
+  AND
+  EXISTS ( -- update only for SKR04
+    SELECT coa FROM defaults
+    WHERE defaults.coa='Germany-DATEV-SKR04EU'
+  )
+;
-- 
2.39.5