Revision 8eca5e84
Von Sven Schöling vor fast 12 Jahren hinzugefügt
| SL/GL.pm | ||
|---|---|---|
| 664 | 664 |
(SELECT c1.accno |
| 665 | 665 |
FROM chart c1, tax t1 |
| 666 | 666 |
WHERE (t1.id = t.id) AND (c1.id = t.chart_id)) AS taxaccno, |
| 667 |
a.tax_id AS tax_id |
|
| 667 |
(SELECT tk.tax_id |
|
| 668 |
FROM taxkeys tk |
|
| 669 |
WHERE (tk.chart_id = a.chart_id) AND (tk.startdate <= a.transdate) |
|
| 670 |
ORDER BY tk.startdate desc LIMIT 1) AS tax_id |
|
| 668 | 671 |
FROM acc_trans a |
| 669 | 672 |
JOIN chart c ON (c.id = a.chart_id) |
| 670 | 673 |
LEFT JOIN project p ON (p.id = a.project_id) |
| 671 | 674 |
LEFT JOIN tax t ON |
| 672 |
(t.id = a.tax_id) |
|
| 675 |
(t.id = |
|
| 676 |
(SELECT tk.tax_id |
|
| 677 |
FROM taxkeys tk |
|
| 678 |
WHERE (tk.taxkey_id = a.taxkey) AND |
|
| 679 |
((CASE WHEN a.chart_id IN |
|
| 680 |
(SELECT chart_id FROM taxkeys WHERE taxkey_id = a.taxkey) |
|
| 681 |
THEN tk.chart_id = a.chart_id |
|
| 682 |
ELSE 1 = 1 |
|
| 683 |
END) |
|
| 684 |
OR (c.link LIKE '%tax%')) |
|
| 685 |
AND (startdate <= a.transdate) |
|
| 686 |
ORDER BY startdate DESC LIMIT 1)) |
|
| 673 | 687 |
WHERE (a.trans_id = ?) |
| 674 | 688 |
AND (a.fx_transaction = '0') |
| 675 | 689 |
ORDER BY a.acc_trans_id, a.transdate|; |
Auch abrufbar als: Unified diff
Revert "Probleme bei Mwst-Wechsel"
This reverts commit 072919154edb34f4afed6bf93fdbdae5b0969385.