Revision 9f546605
Von Cem Aydin vor 2 Monaten hinzugefügt
- ID 9f5466054a8f4393b82f6afe6c4a6aa36cbb3909
- Vorgänger b4baa620
| 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
Fix: dbupgrade Skript steuerfilterung.pl
Neue Schweizer Mehrwertsteuersätze eintragen.
Behebt: Fehler #671