Revision 5ede0770
Von Moritz Bunkus vor etwa 9 Jahren hinzugefügt
| SL/SEPA.pm | ||
|---|---|---|
| 49 | 49 |
|
| 50 | 50 |
FROM ${arap}
|
| 51 | 51 |
LEFT JOIN ${vc} vc ON (${arap}.${vc}_id = vc.id)
|
| 52 |
LEFT JOIN (SELECT sei.ap_id, SUM(sei.amount) AS amount
|
|
| 52 |
LEFT JOIN (SELECT sei.${arap}_id, SUM(sei.amount) AS amount
|
|
| 53 | 53 |
FROM sepa_export_items sei |
| 54 | 54 |
LEFT JOIN sepa_export se ON (sei.sepa_export_id = se.id) |
| 55 | 55 |
WHERE NOT se.closed |
| 56 | 56 |
AND (se.vc = '${vc}')
|
| 57 |
GROUP BY sei.ap_id)
|
|
| 58 |
AS open_transfers ON (${arap}.id = open_transfers.ap_id)
|
|
| 57 |
GROUP BY sei.${arap}_id)
|
|
| 58 |
AS open_transfers ON (${arap}.id = open_transfers.${arap}_id)
|
|
| 59 | 59 |
|
| 60 | 60 |
LEFT JOIN payment_terms pt ON (${payment_term_type}.payment_id = pt.id)
|
| 61 | 61 |
|
Auch abrufbar als: Unified diff
SEPA: offene Einzüge beim Neuerstellen von Einzügen richtig berücksichtigen