Revision 93ab54fc
Von mh@waldpark.octosoft.eu vor etwa 8 Jahren hinzugefügt
| SL/SEPA.pm | ||
|---|---|---|
|
vc.name AS vcname, vc.language_id, ${arap}.duedate as duedate, ${arap}.direct_debit,
|
||
|
vc.${vc_vc_id} as vc_vc_id,
|
||
|
|
||
|
COALESCE(vc.iban, '') <> '' AND COALESCE(vc.bic, '') <> '', vc.direct_debit <> ${tf} ${mandate} AS vc_bank_info_ok,
|
||
|
COALESCE(vc.iban, '') <> '' AND COALESCE(vc.bic, '') <> '' AND vc.direct_debit <> ${tf} ${mandate} AS vc_bank_info_ok,
|
||
|
|
||
|
${arap}.amount - ${arap}.paid - COALESCE(open_transfers.amount, 0) AS open_amount,
|
||
|
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