Revision 7807c2fe
Von Udo Spallek vor mehr als 18 Jahren hinzugefügt
sql/Pg-upgrade-2.1.1-2.1.2.sql | ||
---|---|---|
302 | 302 |
UPDATE chart SET pos_ustva=69 WHERE accno IN ('1783'); |
303 | 303 |
UPDATE chart SET pos_ustva=39 WHERE accno IN ('1781'); |
304 | 304 |
-- |
305 |
-- clear table tax |
|
306 |
DELETE from tax; |
|
307 |
-- insert actual values for SKR03 |
|
308 |
INSERT INTO tax (rate, taxkey, taxdescription) VALUES ('0','0','Keine Steuer'); |
|
309 |
INSERT INTO tax (rate, taxkey, taxdescription) VALUES ('0','1','Umsatzsteuerfrei (mit Vorsteuerabzug)'); |
|
310 |
INSERT INTO tax VALUES ((SELECT id FROM chart WHERE accno = '1771'),'0.07','1771','2','Umsatzsteuer 7%'); |
|
311 |
INSERT INTO tax VALUES ((SELECT id FROM chart WHERE accno = '1775'),'0.16','1775','3','Umsatzsteuer 16%'); |
|
312 |
INSERT INTO tax VALUES ((SELECT id FROM chart WHERE accno = '1571'),'0.07','1571','8','Vorsteuer 7%'); |
|
313 |
INSERT INTO tax VALUES ((SELECT id FROM chart WHERE accno = '1575'),'0.16','1575','9','Vorsteuer 16%'); |
|
314 |
INSERT INTO tax VALUES ((SELECT id FROM chart WHERE accno = '1767'),'0.00','1767','10','Im anderen EG-Staat steuerpfl. Lieferung'); |
|
315 |
INSERT INTO tax (taxkey, taxdescription) VALUES ('11','Steuerfreie EG-Lief. an Abn. mit UStIdNr'); |
|
316 |
INSERT INTO tax VALUES ((SELECT id FROM chart WHERE accno = '1772'),'0.07','1772','12','Umsatzsteuer 7% innergem. Erwerb'); |
|
317 |
INSERT INTO tax VALUES ((SELECT id FROM chart WHERE accno = '1773'),'0.16','1773','13','Umsatzsteuer 16% innergem. Erwerb'); |
|
318 |
INSERT INTO tax VALUES ((SELECT id FROM chart WHERE accno = '1572'),'0.07','1572','18','Steuerpfl. EG-Erwerb 7%'); |
|
319 |
INSERT INTO tax VALUES ((SELECT id FROM chart WHERE accno = '1572'),'0.16','1573','19','Steuerpfl. EG-Erwerb 16%'); |
|
305 | 320 |
|
306 | 321 |
update defaults set version = '2.1.2'; |
307 | 322 |
|
Auch abrufbar als: Unified diff
Update table tax