Revision cff1389b
Von Moritz Bunkus vor mehr als 9 Jahren hinzugefügt
| SL/AR.pm | ||
|---|---|---|
| 467 | 467 |
qq| c.id as customer_id, | . |
| 468 | 468 |
qq| e.name AS employee, | . |
| 469 | 469 |
qq| e2.name AS salesman, | . |
| 470 |
qq| dc.dunning_description, | . |
|
| 470 | 471 |
qq| tz.description AS taxzone, | . |
| 471 | 472 |
qq| pt.description AS payment_terms, | . |
| 472 | 473 |
qq{ ( SELECT ch.accno || ' -- ' || ch.description
|
| ... | ... | |
| 481 | 482 |
qq|LEFT JOIN contacts cp ON (a.cp_id = cp.cp_id) | . |
| 482 | 483 |
qq|LEFT JOIN employee e ON (a.employee_id = e.id) | . |
| 483 | 484 |
qq|LEFT JOIN employee e2 ON (a.salesman_id = e2.id) | . |
| 485 |
qq|LEFT JOIN dunning_config dc ON (a.dunning_config_id = dc.id) | . |
|
| 484 | 486 |
qq|LEFT JOIN project pr ON (a.globalproject_id = pr.id)| . |
| 485 | 487 |
qq|LEFT JOIN tax_zones tz ON (tz.id = a.taxzone_id)| . |
| 486 | 488 |
qq|LEFT JOIN payment_terms pt ON (pt.id = a.payment_id)| . |
Auch abrufbar als: Unified diff
Rechnungssuche: optionale Spalte Mahnstufe implementiert