projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
| inline |
side by side
[0005245] Added debtors_master.debtor_ref to get_customer_trans() results
[fa-stable.git]
/
sales
/
includes
/
db
/
cust_trans_db.inc
diff --git
a/sales/includes/db/cust_trans_db.inc
b/sales/includes/db/cust_trans_db.inc
index 888181ebae9b811a4b04c863364e5a488d8879ad..401c7a54580388285b35672c13e16e077e166ed7 100644
(file)
--- a/
sales/includes/db/cust_trans_db.inc
+++ b/
sales/includes/db/cust_trans_db.inc
@@
-125,6
+125,7
@@
function get_customer_trans($trans_id, $trans_type, $customer_id=null)
$sql = "SELECT trans.*,"
."ov_amount+ov_gst+ov_freight+ov_freight_tax+ov_discount AS Total,"
."cust.name AS DebtorName, cust.address, "
+ ."cust.debtor_ref, "
."cust.curr_code, "
."cust.tax_id,
trans.prep_amount>0 as prepaid,"