Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 672464a1

Von Bernd Bleßmann vor mehr als 2 Jahren hinzugefügt

  • ID 672464a162d6b33533dafa96aa8e405964f92e85
  • Vorgänger 72e90469
  • Nachfolger 23b40897

reverse Charge Upgrade Skript: taxkeys nur bei Germany-DATEV-SKR03EU/04EU

Unterschiede anzeigen:

sql/Pg-upgrade2/tax_reverse_charge.sql
101 101 

  		




  102
  102
  
    
-- if not defined


  		




  103
  103
  
    
insert into taxkeys(chart_id,tax_id,taxkey_id,startdate) SELECT (SELECT chart_id FROM tax WHERE taxkey = '94'),0,0,'1970-01-01' WHERE NOT EXISTS


  		




  104
  
  
    
  (SELECT chart_id from taxkeys where chart_id = ( SELECT chart_id FROM tax WHERE taxkey = '94'));


  		




  
  104
  
    
  (SELECT chart_id from taxkeys where chart_id = ( SELECT chart_id FROM tax WHERE taxkey = '94'))


  		




  
  105
  
    
  AND (EXISTS (SELECT coa FROM defaults WHERE defaults.coa='Germany-DATEV-SKR04EU') OR EXISTS (SELECT coa FROM defaults WHERE defaults.coa='Germany-DATEV-SKR03EU'));


  		




  105
  106
  
    

  		




  106
  107
  
    
insert into taxkeys(chart_id,tax_id,taxkey_id,startdate) SELECT (SELECT reverse_charge_chart_id FROM tax WHERE taxkey = '94'),0,0,'1970-01-01' WHERE NOT EXISTS


  		




  107
  
  
    
  (SELECT chart_id from taxkeys where chart_id = ( SELECT reverse_charge_chart_id FROM tax WHERE taxkey = '94'));


  		




  108
  
  
    

  		




  
  108
  
    
  (SELECT chart_id from taxkeys where chart_id = ( SELECT reverse_charge_chart_id FROM tax WHERE taxkey = '94'))


  		




  
  109
  
    
    AND (EXISTS (SELECT coa FROM defaults WHERE defaults.coa='Germany-DATEV-SKR04EU') OR EXISTS (SELECT coa FROM defaults WHERE defaults.coa='Germany-DATEV-SKR03EU'));


  		












Auch abrufbar als:  Unified diff