Revision 8f1fb2d6
Von Roman Karushka vor etwa 15 Jahren hinzugefügt
| SL/DN.pm | ||
|---|---|---|
| 618 | 618 |
qq|SELECT a.id, a.ordnumber, a.invoice, a.transdate, a.invnumber, a.amount, |
| 619 | 619 |
ct.name AS customername, ct.id AS customer_id, a.duedate, da.fee, |
| 620 | 620 |
da.interest, dn.dunning_description, da.transdate AS dunning_date, |
| 621 |
da.duedate AS dunning_duedate, da.dunning_id, da.dunning_config_id |
|
| 621 |
da.duedate AS dunning_duedate, da.dunning_id, da.dunning_config_id, |
|
| 622 |
e2.name AS salesman |
|
| 622 | 623 |
FROM ar a |
| 623 |
JOIN customer ct ON (a.customer_id = ct.id), dunning da |
|
| 624 |
JOIN customer ct ON (a.customer_id = ct.id) |
|
| 625 |
LEFT JOIN employee e2 ON (a.salesman_id = e2.id), dunning da |
|
| 624 | 626 |
LEFT JOIN dunning_config dn ON (da.dunning_config_id = dn.id) |
| 625 | 627 |
$where |
| 626 | 628 |
ORDER BY $sortorder|; |
Auch abrufbar als: Unified diff
Neue Funktion: Checkbox fuer Verkaeuferanzeige in Mahnungsberichten.