Revision 9f546605
Von Cem Aydin vor 8 Monaten hinzugefügt
- ID 9f5466054a8f4393b82f6afe6c4a6aa36cbb3909
- Vorgänger b4baa620
| sql/Pg-upgrade2/steuerfilterung.pl | ||
|---|---|---|
|
|
||
|
# Swiss
|
||
|
{ taxkey => 2, rate => 0.08, taxdescription => qr{mwst}i, categories => 'I' },
|
||
|
{ taxkey => 2, rate => 0.081, taxdescription => qr{mwst}i, categories => 'I' },
|
||
|
{ taxkey => 3, rate => 0.025, taxdescription => qr{mwst}i, categories => 'I' },
|
||
|
{ taxkey => 3, rate => 0.026, taxdescription => qr{mwst}i, categories => 'I' },
|
||
|
{ taxkey => 4, rate => 0.08, taxdescription => qr{mwst}i, categories => 'E' },
|
||
|
{ taxkey => 4, rate => 0.081, taxdescription => qr{mwst}i, categories => 'E' },
|
||
|
{ taxkey => 5, rate => 0.025, taxdescription => qr{mwst}i, categories => 'E' },
|
||
|
{ taxkey => 5, rate => 0.026, taxdescription => qr{mwst}i, categories => 'E' },
|
||
|
{ taxkey => 6, rate => 0.08, taxdescription => qr{mwst}i, categories => 'E' },
|
||
|
{ taxkey => 6, rate => 0.081, taxdescription => qr{mwst}i, categories => 'E' },
|
||
|
{ taxkey => 7, rate => 0.025, taxdescription => qr{mwst}i, categories => 'E' },
|
||
|
{ taxkey => 7, rate => 0.026, taxdescription => qr{mwst}i, categories => 'E' },
|
||
|
);
|
||
|
|
||
|
$query = qq|SELECT taxkey, taxdescription, rate, id AS tax_id FROM tax order by taxkey, rate;|;
|
||
Auch abrufbar als: Unified diff
Fix: dbupgrade Skript steuerfilterung.pl
Neue Schweizer Mehrwertsteuersätze eintragen.
Behebt: Fehler #671