Revision 003d4959
Von Moritz Bunkus vor fast 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.${arap}_id, SUM(sei.amount) AS amount
|
|
| 52 |
LEFT JOIN (SELECT sei.${arap}_id, SUM(sei.amount) + SUM(COALESCE(sei.skonto_amount,0)) 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 |
Auch abrufbar als: Unified diff
SEPA: bei Liste noch zu erledigender Rechnungen Skonto berücksichtigen