Revision 5f8a4fc5
Von Jan Büren vor mehr als 8 Jahren hinzugefügt
| SL/DN.pm | ||
|---|---|---|
| 799 | 799 |
ar.transdate, ar.duedate, ar.customer_id, |
| 800 | 800 |
ar.invnumber, ar.ordnumber, ar.cp_id, |
| 801 | 801 |
ar.amount, ar.netamount, ar.paid, |
| 802 |
(SELECT cu.name FROM currencies cu WHERE cu.id=ar.currency_id) AS curr, |
|
| 802 |
(SELECT cu.name FROM currencies cu WHERE cu.id = ar.currency_id) AS curr, |
|
| 803 |
(SELECT description from department WHERE id = ar.department_id) AS department, |
|
| 803 | 804 |
ar.amount - ar.paid AS open_amount, |
| 804 | 805 |
ar.amount - ar.paid + da.fee + da.interest AS linetotal |
| 805 | 806 |
|
Auch abrufbar als: Unified diff
Abteilung an Druckvorlage in Mahnungen übergeben