X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/5b47ed3efe5f4ef0810096b0f4849047cee54690..0eeecc3c6833a618a9f1b9c94e0331335f8a7987:/SL/IR.pm diff --git a/SL/IR.pm b/SL/IR.pm index 2077e6b0e..8fb9b7775 100644 --- a/SL/IR.pm +++ b/SL/IR.pm @@ -1002,8 +1002,10 @@ sub get_vendor { my $query = qq|SELECT v.name AS vendor, v.creditlimit, v.terms, v.email, v.cc, v.bcc, v.language_id, v.payment_id, v.street, v.zipcode, v.city, v.country, v.taxzone_id, - $duedate + v.terms AS duedate + $duedate + v.terms AS duedate, + b.description AS business FROM vendor v + LEFT JOIN business b ON b.id = v.business_id WHERE v.id = $form->{vendor_id}|; my $sth = $dbh->prepare($query); $sth->execute || $form->dberror($query);