]> wagnertech.de Git - mfinanz.git/blobdiff - SL/DN.pm
Mehr Felder in Mahnungen zur Verfügung stellen.
[mfinanz.git] / SL / DN.pm
index 6486455910186427fca79d71dd24032731d43ef2..bd4b5092fd2068b42cb0453410a2ccf353f8efac 100644 (file)
--- a/SL/DN.pm
+++ b/SL/DN.pm
@@ -726,9 +726,10 @@ sub print_dunning {
 
   $query =
     qq|SELECT
-         c.id AS customer_id, c.name,         c.street,       c.zipcode, c.city,
-         c.country,           c.department_1, c.department_2, c.email, c.customernumber,
-         -- contact information
+         c.id AS customer_id, c.name,         c.street,       c.zipcode,   c.city,
+         c.country,           c.department_1, c.department_2, c.email,     c.customernumber,
+         c.greeting,          c.contact,      c.phone,        c.fax,       c.homepage,
+         c.email,             c.taxincluded,  c.business_id,  c.taxnumber, c.iban,
          co.*
        FROM dunning d
        LEFT JOIN ar          ON (d.trans_id = ar.id)