X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/5c8d3d822a7a99eb74970cc3a1eeea149a1d1778..fa7a78e6ef90dbde7f1a7f4bef3d693bfac1f007:/SL/DN.pm diff --git a/SL/DN.pm b/SL/DN.pm index 648645591..bd4b5092f 100644 --- 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)