Revision e09e6329
Von Jan Büren vor mehr als 2 Jahren hinzugefügt
| sql/Pg-upgrade2/clean_tax_18_19.pl | ||
|---|---|---|
| 1 | 1 |
# @tag: clean_tax_18_19 |
| 2 | 2 |
# @description: Vorbereitung für neue Steuerschlüssel 18,19 |
| 3 |
# @depends: release_3_6_0 |
|
| 3 |
# @depends: release_3_6_0 tax_reverse_charge
|
|
| 4 | 4 |
# @ignore: 0 |
| 5 | 5 |
package SL::DBUpgrade2::clean_tax_18_19; |
| 6 | 6 |
|
| ... | ... | |
| 14 | 14 |
|
| 15 | 15 |
my $query = <<SQL; |
| 16 | 16 |
SELECT id from tax |
| 17 |
where chart_id is not null |
|
| 18 |
and taxkey = ? |
|
| 17 |
where taxkey = ? |
|
| 19 | 18 |
and reverse_charge_chart_id is null |
| 20 | 19 |
SQL |
| 21 | 20 |
my $q_fetch = <<SQL; |
Auch abrufbar als: Unified diff
clean_tax abhängigkeit explizit setzen