Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 9f546605

Von Cem Aydin vor 17 Tagen hinzugefügt

  • ID 9f5466054a8f4393b82f6afe6c4a6aa36cbb3909
  • Vorgänger b4baa620

Fix: dbupgrade Skript steuerfilterung.pl

Neue Schweizer Mehrwertsteuersätze eintragen.

Behebt: Fehler #671

Unterschiede anzeigen:

sql/Pg-upgrade2/steuerfilterung.pl
60 60 

  		




  61
  61
  
    
      # Swiss


  		




  62
  62
  
    
      { taxkey => 2,  rate => 0.08,  taxdescription => qr{mwst}i,                                categories => 'I' },


  		




  
  63
  
    
      { taxkey => 2,  rate => 0.081, taxdescription => qr{mwst}i,                                categories => 'I' },


  		




  63
  64
  
    
      { taxkey => 3,  rate => 0.025, taxdescription => qr{mwst}i,                                categories => 'I' },


  		




  
  65
  
    
      { taxkey => 3,  rate => 0.026, taxdescription => qr{mwst}i,                                categories => 'I' },


  		




  64
  66
  
    
      { taxkey => 4,  rate => 0.08,  taxdescription => qr{mwst}i,                                categories => 'E' },


  		




  
  67
  
    
      { taxkey => 4,  rate => 0.081, taxdescription => qr{mwst}i,                                categories => 'E' },


  		




  65
  68
  
    
      { taxkey => 5,  rate => 0.025, taxdescription => qr{mwst}i,                                categories => 'E' },


  		




  
  69
  
    
      { taxkey => 5,  rate => 0.026, taxdescription => qr{mwst}i,                                categories => 'E' },


  		




  66
  70
  
    
      { taxkey => 6,  rate => 0.08,  taxdescription => qr{mwst}i,                                categories => 'E' },


  		




  
  71
  
    
      { taxkey => 6,  rate => 0.081, taxdescription => qr{mwst}i,                                categories => 'E' },


  		




  67
  72
  
    
      { taxkey => 7,  rate => 0.025, taxdescription => qr{mwst}i,                                categories => 'E' },


  		




  
  73
  
    
      { taxkey => 7,  rate => 0.026, taxdescription => qr{mwst}i,                                categories => 'E' },


  		




  68
  74
  
    
  );


  		




  69
  75
  
    

  		




  70
  76
  
    
  $query = qq|SELECT taxkey, taxdescription, rate, id AS tax_id FROM tax order by taxkey, rate;|;


  		












Auch abrufbar als:  Unified diff