X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FIR.pm;h=a1cbb4d87e05fda9764ff522fdc629b2a30762ab;hb=51264c4371793e3ac8990a54640f9e9b43e3f306;hp=208d2e4fb3cbb9e9800d9ce53553dcde312e19d0;hpb=6a3494478a287c2820e3f68a09bef700af1f57e0;p=kivitendo-erp.git diff --git a/SL/IR.pm b/SL/IR.pm index 208d2e4fb..a1cbb4d87 100644 --- a/SL/IR.pm +++ b/SL/IR.pm @@ -1129,11 +1129,11 @@ sub get_vendor { my $query = qq|SELECT v.id AS vendor_id, v.name AS vendor, v.discount as vendor_discount, - v.creditlimit, v.terms, v.notes AS intnotes, + v.creditlimit, v.notes AS intnotes, v.email, v.cc, v.bcc, v.language_id, v.payment_id, v.delivery_term_id, v.street, v.zipcode, v.city, v.country, v.taxzone_id, cu.name AS curr, v.direct_debit, $duedate + COALESCE(pt.terms_netto, 0) AS duedate, - b.description AS business + b.discount AS tradediscount, b.description AS business FROM vendor v LEFT JOIN business b ON (b.id = v.business_id) LEFT JOIN payment_terms pt ON (v.payment_id = pt.id)