Revision 9978980b
Von Jan Büren vor fast 14 Jahren hinzugefügt
| SL/SEPA.pm | ||
|---|---|---|
| 20 | 20 |
my $query = |
| 21 | 21 |
qq| |
| 22 | 22 |
SELECT ap.id, ap.invnumber, ap.vendor_id, ap.amount AS invoice_amount, ap.invoice, |
| 23 |
v.name AS vendorname, |
|
| 23 |
v.name AS vendorname, ap.duedate as duedate,
|
|
| 24 | 24 |
|
| 25 | 25 |
COALESCE(v.iban, '') <> '' AND COALESCE(v.bic, '') <> '' AS vendor_bank_info_ok, |
| 26 | 26 |
|
Auch abrufbar als: Unified diff
SEPA Hinzufügen von Überweisungen um das Infofeld Fälligkeitsdatum erweitert