Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision bb84bc55

Von Jan Büren vor fast 3 Jahren hinzugefügt

  • ID bb84bc55a14e2124d1dfd899d8e7afaad152a35d
  • Vorgänger 57342517
  • Nachfolger d042bebb

DB-Upgrade tax_reverse_charge, syntaktischen Fehler behoben

Unterschiede anzeigen:

sql/Pg-upgrade2/tax_reverse_charge.sql
1 1 
-- @tag: tax_reverse_charge
2 2 
-- @description: Reverse Charge für Kreditorenbelege
3 
-- @depends: release_3_6_0
4 
-- @ignore: 1
3 
-- @depends: release_3_5_0
4 
-- @ignore: 0
5 5 

  		




  6
  6
  
    
ALTER TABLE tax add column reverse_charge_chart_id integer;


  		




  7
  7
  
    

  		




  ......




  102
  102
  
    
;


  		




  103
  103
  
    
-- if not defined


  		




  104
  104
  
    
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


  		




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


  		




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


  		




  
  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
  
    
  (SELECT chart_id from taxkeys where chart_id = ( SELECT reverse_charge_chart_id FROM tax WHERE taxkey = '94'));


  		




  108
  109
  
    

  		












Auch abrufbar als:  Unified diff