Revision fa7a78e6
Von Sven Schöling vor mehr als 15 Jahren hinzugefügt
| SL/DN.pm | ||
|---|---|---|
| 726 | 726 |
|
| 727 | 727 |
$query = |
| 728 | 728 |
qq|SELECT |
| 729 |
c.id AS customer_id, c.name, c.street, c.zipcode, c.city, |
|
| 730 |
c.country, c.department_1, c.department_2, c.email, c.customernumber, |
|
| 731 |
-- contact information |
|
| 729 |
c.id AS customer_id, c.name, c.street, c.zipcode, c.city, |
|
| 730 |
c.country, c.department_1, c.department_2, c.email, c.customernumber, |
|
| 731 |
c.greeting, c.contact, c.phone, c.fax, c.homepage, |
|
| 732 |
c.email, c.taxincluded, c.business_id, c.taxnumber, c.iban, |
|
| 732 | 733 |
co.* |
| 733 | 734 |
FROM dunning d |
| 734 | 735 |
LEFT JOIN ar ON (d.trans_id = ar.id) |
Auch abrufbar als: Unified diff
Mehr Felder in Mahnungen zur Verfügung stellen.