Revision 8eca5e84
Von Sven Schöling vor fast 12 Jahren hinzugefügt
| SL/CA.pm | ||
|---|---|---|
| 273 | 273 |
$query = |
| 274 | 274 |
qq|SELECT a.id, a.reference, a.description, ac.transdate, ac.chart_id, | . |
| 275 | 275 |
qq| $false AS invoice, ac.amount, 'gl' as module, | . |
| 276 |
qq§(SELECT accno||'--'||rate FROM tax LEFT JOIN chart ON (tax.chart_id=chart.id) WHERE tax.id = ac.tax_id) AS taxinfo, ac.source || ' ' || ac.memo AS memo § .
|
|
| 276 |
qq§(SELECT accno||'--'||rate FROM tax LEFT JOIN chart ON (tax.chart_id=chart.id) WHERE tax.id = (SELECT tax_id FROM taxkeys WHERE taxkey_id = ac.taxkey AND taxkeys.startdate <= ac.transdate ORDER BY taxkeys.startdate DESC LIMIT 1)) AS taxinfo, ac.source || ' ' || ac.memo AS memo § .
|
|
| 277 | 277 |
qq|FROM acc_trans ac, gl a | . |
| 278 | 278 |
$dpt_join . |
| 279 | 279 |
qq|WHERE | . $where . $dpt_where . $project . |
| ... | ... | |
| 285 | 285 |
|
| 286 | 286 |
qq|SELECT a.id, a.invnumber, c.name, ac.transdate, ac.chart_id, | . |
| 287 | 287 |
qq| a.invoice, ac.amount, 'ar' as module, | . |
| 288 |
qq§(SELECT accno||'--'||rate FROM tax LEFT JOIN chart ON (tax.chart_id=chart.id) WHERE tax.id = ac.tax_id) AS taxinfo, ac.source || ' ' || ac.memo AS memo § .
|
|
| 288 |
qq§(SELECT accno||'--'||rate FROM tax LEFT JOIN chart ON (tax.chart_id=chart.id) WHERE tax.id = (SELECT tax_id FROM taxkeys WHERE taxkey_id = ac.taxkey AND taxkeys.startdate <= ac.transdate ORDER BY taxkeys.startdate DESC LIMIT 1)) AS taxinfo, ac.source || ' ' || ac.memo AS memo § .
|
|
| 289 | 289 |
qq|FROM acc_trans ac, customer c, ar a | . |
| 290 | 290 |
$dpt_join . |
| 291 | 291 |
qq|WHERE | . $where . $dpt_where . $project . |
| ... | ... | |
| 298 | 298 |
|
| 299 | 299 |
qq|SELECT a.id, a.invnumber, v.name, ac.transdate, ac.chart_id, | . |
| 300 | 300 |
qq| a.invoice, ac.amount, 'ap' as module, | . |
| 301 |
qq§(SELECT accno||'--'||rate FROM tax LEFT JOIN chart ON (tax.chart_id=chart.id) WHERE tax.id = ac.tax_id) AS taxinfo, ac.source || ' ' || ac.memo AS memo § .
|
|
| 301 |
qq§(SELECT accno||'--'||rate FROM tax LEFT JOIN chart ON (tax.chart_id=chart.id) WHERE tax.id = (SELECT tax_id FROM taxkeys WHERE taxkey_id = ac.taxkey AND taxkeys.startdate <= ac.transdate ORDER BY taxkeys.startdate DESC LIMIT 1)) AS taxinfo, ac.source || ' ' || ac.memo AS memo § .
|
|
| 302 | 302 |
qq|FROM acc_trans ac, vendor v, ap a | . |
| 303 | 303 |
$dpt_join . |
| 304 | 304 |
qq|WHERE | . $where . $dpt_where . $project . |
Auch abrufbar als: Unified diff
Revert "Probleme bei Mwst-Wechsel"
This reverts commit 072919154edb34f4afed6bf93fdbdae5b0969385.