Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 672464a1

Von Bernd Bleßmann vor fast 3 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