Revision f12fcb59
Von Philip Reetz vor fast 18 Jahren hinzugefügt
| SL/USTVA.pm | ||
|---|---|---|
| 739 | 739 |
SELECT id FROM taxkeys |
| 740 | 740 |
WHERE chart_id = ac.chart_id |
| 741 | 741 |
-- AND taxkey_id = ac.taxkey |
| 742 |
AND startdate <= COALESCE(ar.transdate) |
|
| 742 |
AND startdate <= COALESCE(ar.deliverydate,ar.transdate)
|
|
| 743 | 743 |
ORDER BY startdate DESC LIMIT 1 |
| 744 | 744 |
) |
| 745 | 745 |
) |
| ... | ... | |
| 777 | 777 |
tk.id = ( |
| 778 | 778 |
SELECT id FROM taxkeys |
| 779 | 779 |
WHERE chart_id = ac.chart_id |
| 780 |
AND startdate <= COALESCE(ar.transdate) |
|
| 780 |
AND startdate <= COALESCE(ar.deliverydate,ar.transdate)
|
|
| 781 | 781 |
ORDER BY startdate DESC LIMIT 1 |
| 782 | 782 |
) |
| 783 | 783 |
) |
Auch abrufbar als: Unified diff
Eine Aenderung zuviel in den Abfragen: Lieferdatum wurde nicht mehr berucksichtigt