Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 7807c2fe

Von Udo Spallek vor mehr als 18 Jahren hinzugefügt

  • ID 7807c2fe3f53b870f217366608a21164b6a69111
  • Vorgänger c2ed42c3
  • Nachfolger a4330713

Update table tax

Unterschiede anzeigen:

sql/Germany-DATEV-SKR03EU-chart.sql
377 377 
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2215', 'Zinsabschlagsteuer', 'A', 'E', '', '2215', 0, NULL, 35, NULL, NULL, FALSE);
378 378 
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2218', 'Anrechb.Solidari.zuschlag a.Zinsabschlagst.', 'A', 'E', '', '2218', 0, NULL, 35, NULL, NULL, FALSE);
379 379 

  		




  380
  
  
    
INSERT INTO tax (rate, taxkey, taxdescription) values ('0','0','Keine Steuer');


  		




  381
  
  
    
INSERT INTO tax (rate, taxkey, taxdescription) values ('0','1','Umsatzsteuerfrei');


  		




  382
  
  
    
insert into tax VALUES ((select id from chart where accno = '1771'),'0.07','1771','2','Umsatzsteuer 7%');


  		




  383
  
  
    
INSERT INTO tax VALUES ((select id from chart where accno = '1775'),'0.16','1775','3','Umsatzsteuer 16%');


  		




  384
  
  
    
INSERT INTO tax VALUES ((select id from chart where accno = '1571'),'0.07','1571','8','Vorsteuer 7%');


  		




  385
  
  
    
insert into tax VALUES ((select id from chart where accno = '1575'),'0.16','1575','9','Vorsteuer 16%');


  		




  386
  
  
    
insert into tax (taxkey, taxdescription) values ('10','Im anderen EG-Staat steuerpfl. Lieferung');


  		




  387
  
  
    
insert into tax (taxkey, taxdescription) values ('11','Steuerfreie EG-Lief. an Abn. mit UStIdNr');


  		




  388
  
  
    
insert into tax (chart_id,rate,taxnumber, taxkey, taxdescription) values ((select id from chart where accno = '1772'),'0.07','1772','12','Steuerpflicht. EG-Lieferungen 7%');


  		




  389
  
  
    
insert into tax (chart_id,rate,taxnumber, taxkey, taxdescription) values ((select id from chart where accno = '1772'),'0.16','1773','13','Steuerpflicht. EG-Lieferungen 16%');


  		




  390
  
  
    
insert into tax (chart_id,rate,taxnumber, taxkey, taxdescription) values ((select id from chart where accno = '1572'),'0.07','1572','18','Steuerpflicht. EG-Erwerb 7%');


  		




  391
  
  
    
insert into tax (chart_id,rate,taxnumber, taxkey, taxdescription) values ((select id from chart where accno = '1572'),'0.16','1573','19','Steuerpflicht. EG-Erwerb 16%');


  		




  
  380
  
    
INSERT INTO tax (rate, taxkey, taxdescription) VALUES ('0','0','Keine Steuer');


  		




  
  381
  
    
INSERT INTO tax (rate, taxkey, taxdescription) VALUES ('0','1','Umsatzsteuerfrei (mit Vorsteuerabzug)');


  		




  
  382
  
    
INSERT INTO tax VALUES ((SELECT id FROM chart WHERE accno = '1771'),'0.07','1771','2','Umsatzsteuer 7%');


  		




  
  383
  
    
INSERT INTO tax VALUES ((SELECT id FROM chart WHERE accno = '1775'),'0.16','1775','3','Umsatzsteuer 16%');


  		




  
  384
  
    
INSERT INTO tax VALUES ((SELECT id FROM chart WHERE accno = '1571'),'0.07','1571','8','Vorsteuer 7%');


  		




  
  385
  
    
INSERT INTO tax VALUES ((SELECT id FROM chart WHERE accno = '1575'),'0.16','1575','9','Vorsteuer 16%');


  		




  
  386
  
    
INSERT INTO tax VALUES ((SELECT id FROM chart WHERE accno = '1767'),'0.00','1767','10','Im anderen EG-Staat steuerpfl. Lieferung');


  		




  
  387
  
    
INSERT INTO tax (taxkey, taxdescription) VALUES ('11','Steuerfreie EG-Lief. an Abn. mit UStIdNr');


  		




  
  388
  
    
INSERT INTO tax VALUES ((SELECT id FROM chart WHERE accno = '1772'),'0.07','1772','12','Umsatzsteuer 7% innergem. Erwerb');


  		




  
  389
  
    
INSERT INTO tax VALUES ((SELECT id FROM chart WHERE accno = '1773'),'0.16','1773','13','Umsatzsteuer 16% innergem. Erwerb');


  		




  
  390
  
    
INSERT INTO tax VALUES ((SELECT id FROM chart WHERE accno = '1572'),'0.07','1572','18','Steuerpfl. EG-Erwerb 7%');


  		




  
  391
  
    
INSERT INTO tax VALUES ((SELECT id FROM chart WHERE accno = '1572'),'0.16','1573','19','Steuerpfl. EG-Erwerb 16%');


  		




  392
  392
  
    

  		




  393
  393
  
    
-- UStVA Link to SKR03/2006


  		




  394
  394
  
    
-- Let this structure like it is, please.


  		












Auch abrufbar als:  Unified diff