Revision 93ab54fc
Von mh@waldpark.octosoft.eu vor fast 8 Jahren hinzugefügt
| SL/SEPA.pm | ||
|---|---|---|
| 51 | 51 |
vc.name AS vcname, vc.language_id, ${arap}.duedate as duedate, ${arap}.direct_debit,
|
| 52 | 52 |
vc.${vc_vc_id} as vc_vc_id,
|
| 53 | 53 |
|
| 54 |
COALESCE(vc.iban, '') <> '' AND COALESCE(vc.bic, '') <> '', vc.direct_debit <> ${tf} ${mandate} AS vc_bank_info_ok,
|
|
| 54 |
COALESCE(vc.iban, '') <> '' AND COALESCE(vc.bic, '') <> '' AND vc.direct_debit <> ${tf} ${mandate} AS vc_bank_info_ok,
|
|
| 55 | 55 |
|
| 56 | 56 |
${arap}.amount - ${arap}.paid - COALESCE(open_transfers.amount, 0) AS open_amount,
|
| 57 | 57 |
COALESCE(open_transfers.amount, 0) AS transfer_amount, |
Auch abrufbar als: Unified diff
Ausblenden von Lieferanten mit/Kunden ohne Lastschriften aus SEPA-Überweisungen(2)
fixup : fehlerhafte SQL Anweisung korrigiert
fix TRAC #597