X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/478489bfa2608ea78baadd6f9dcbcff0ee31043c..4be9b9dc16a69c791e47e53790307458bcf7ad7b:/SL/IR.pm diff --git a/SL/IR.pm b/SL/IR.pm index 44a2db568..6950739b0 100644 --- a/SL/IR.pm +++ b/SL/IR.pm @@ -841,7 +841,7 @@ sub get_vendor { } my $query = qq|SELECT - v.id, v.name AS vendor, v.creditlimit, v.terms, v.notes AS intnotes, + v.name AS vendor, v.creditlimit, v.terms, v.notes AS intnotes, v.email, v.cc, v.bcc, v.language_id, v.payment_id, v.street, v.zipcode, v.city, v.country, v.taxzone_id, $duedate + COALESCE(pt.terms_netto, 0) AS duedate,