Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 2e1e2d4c

Von Udo Spallek vor mehr als 18 Jahren hinzugefügt

  • ID 2e1e2d4c36e8580c979339aff4a934fd52b96a8a
  • Vorgänger d0bca87d
  • Nachfolger b85472b0

Bug 262 fixed!
USTVA UPDATE der Positionen und Verknuepfungen.
Die UPDATEs sind relativ vollstaendig und sortiert,
so dass eine weitere Pflege einfach ist. taxkey's sind noch nicht
integriert, deshalb sind einige updates in liste.aql doppelt gemoppelt,
was m.E. unproblematisch ist, gleiches gilt für
den Germany-DATEV-SKR03EU-chart.sql

Unterschiede anzeigen:

sql/Germany-DATEV-SKR03EU-chart.sql
388 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 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 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%');
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%');
392 

  		




  
  393
  
    
-- UStVA Link to SKR03/2006


  		




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


  		




  
  395
  
    
-- This structure is based on the sequence of the USTVA 2006


  		




  
  396
  
    
-- Created by Udo Spallek


  		




  
  397
  
    
--


  		




  
  398
  
    
-- 1. Page UStVA


  		




  
  399
  
    

  		




  
  400
  
    
UPDATE chart SET pos_ustva=41  WHERE accno IN ('8125', '8130', '8140', '8724', '8808', '8828');


  		




  
  401
  
    
UPDATE chart SET pos_ustva=44  WHERE accno IN ('8135');


  		




  
  402
  
    
UPDATE chart SET pos_ustva=49  WHERE accno IN ('');


  		




  
  403
  
    
UPDATE chart SET pos_ustva=43  WHERE accno IN ('2402', '8120', '8150', '8505', '8625', '8705', '8807', '8827');


  		




  
  404
  
    
UPDATE chart SET pos_ustva=48  WHERE accno IN ('8100', '8110', '8504', '8609');


  		




  
  405
  
    
UPDATE chart SET pos_ustva=51  WHERE accno IN ('1717', '2404', '2405', '2700', '2705', '2707', '2709', '8196', '8315', '8400', '8595', '8600', '8611', '8640', '8720', '8726', '8735', '8760', '8790', '8801', '8809', '8820', '8910', '8920', '8921', '8922', '8925', '8935', '8940');


  		




  
  406
  
    
UPDATE chart SET pos_ustva=511 WHERE accno IN ('1775');


  		




  
  407
  
    
UPDATE chart SET pos_ustva=86  WHERE accno IN ('1711', '2401', '2403', '8300', '8310', '8506', '8591', '8630', '8710', '8725', '8731', '8750', '8780', '8915', '8930', '8932', '8945');


  		




  
  408
  
    
UPDATE chart SET pos_ustva=861 WHERE accno IN ('1771');


  		




  
  409
  
    
UPDATE chart SET pos_ustva=35  WHERE accno IN ('2407', '2409', '8723', '8729', '8736', '8764', '8794');


  		




  
  410
  
    
UPDATE chart SET pos_ustva=36  WHERE accno IN ('');


  		




  
  411
  
    
UPDATE chart SET pos_ustva=77  WHERE accno IN ('');


  		




  
  412
  
    
UPDATE chart SET pos_ustva=76  WHERE accno IN ('8190');


  		




  
  413
  
    
UPDATE chart SET pos_ustva=80  WHERE accno IN ('');


  		




  
  414
  
    
UPDATE chart SET pos_ustva=91  WHERE accno IN ('');


  		




  
  415
  
    
UPDATE chart SET pos_ustva=97  WHERE accno IN ('3425', '3725');


  		




  
  416
  
    
UPDATE chart SET pos_ustva=971 WHERE accno IN ('1773');


  		




  
  417
  
    
UPDATE chart SET pos_ustva=93  WHERE accno IN ('3420', '3724');


  		




  
  418
  
    
UPDATE chart SET pos_ustva=931 WHERE accno IN ('1772');


  		




  
  419
  
    
UPDATE chart SET pos_ustva=95  WHERE accno IN ('3727');


  		




  
  420
  
    
UPDATE chart SET pos_ustva=98  WHERE accno IN ('');


  		




  
  421
  
    
UPDATE chart SET pos_ustva=94  WHERE accno IN ('');


  		




  
  422
  
    
UPDATE chart SET pos_ustva=96  WHERE accno IN ('1784');


  		




  
  423
  
    
UPDATE chart SET pos_ustva=42  WHERE accno IN ('');


  		




  
  424
  
    
UPDATE chart SET pos_ustva=60  WHERE accno IN ('8337');


  		




  
  425
  
    
UPDATE chart SET pos_ustva=45  WHERE accno IN ('8338', '8339', '8950');


  		




  
  426
  
    
-- 2. Seite UStVA


  		




  
  427
  
    
UPDATE chart SET pos_ustva=52  WHERE accno IN ('');


  		




  
  428
  
    
UPDATE chart SET pos_ustva=53  WHERE accno IN ('');


  		




  
  429
  
    
UPDATE chart SET pos_ustva=73  WHERE accno IN ('');


  		




  
  430
  
    
UPDATE chart SET pos_ustva=74  WHERE accno IN ('');


  		




  
  431
  
    
UPDATE chart SET pos_ustva=84  WHERE accno IN ('3110', '3115', '3120', '3125');


  		




  
  432
  
    
UPDATE chart SET pos_ustva=85  WHERE accno IN ('1785', '1786');


  		




  
  433
  
    
UPDATE chart SET pos_ustva=65  WHERE accno IN ('1782');


  		




  
  434
  
    
UPDATE chart SET pos_ustva=66  WHERE accno IN ('1570', '1571', '1575', '1576');


  		




  
  435
  
    
UPDATE chart SET pos_ustva=61  WHERE accno IN ('1572', '1573');


  		




  
  436
  
    
UPDATE chart SET pos_ustva=62  WHERE accno IN ('1588');


  		




  
  437
  
    
UPDATE chart SET pos_ustva=67  WHERE accno IN ('1578', '1579');


  		




  
  438
  
    
UPDATE chart SET pos_ustva=63  WHERE accno IN ('1577');


  		




  
  439
  
    
UPDATE chart SET pos_ustva=64  WHERE accno IN ('1556', '1557', '1558', '1559');


  		




  
  440
  
    
UPDATE chart SET pos_ustva=59  WHERE accno IN ('');


  		




  
  441
  
    
UPDATE chart SET pos_ustva=69  WHERE accno IN ('1783');


  		




  
  442
  
    
UPDATE chart SET pos_ustva=39  WHERE accno IN ('1781');


  		












Auch abrufbar als:  Unified diff