select d.cdr_recordid, d.cdr_dstname from tbl_cdr_distributors d with (nolock) where d.cdr_recordid = and d.ownerid = and d.fsl_tablecode = select unitOfMeasure from tblManufacturers where mfr_id =

no records found

#_1FSSettings.searchResultsMessage#

#sku# - #description#

#mfr_name#

#affiliationStatus#

#qryDistInfo.cdr_dstname#
Last Invoice: #dateformat(lastInvoiceDate,"m/d/yy")#
#numberformat(val(lastInvoiceCases),"9,999")# Cases Last Invoice: #dateformat(lastInvoiceDate,"m/d/yy")#
#numberformat(val(lastInvoiceLbs),"9,999")# Lbs

Buying (#ltrim(numberformat(val(_confirmedVolumeQty),"9,999"))# #_clientUom#s/yr)
Last Purch: #dateformat(confirmedVolumeDate,"mmm yyyy")#
Confirmed Status Not Buying (#ltrim(numberformat(val(_confirmedVolumeQty),"9,999"))# #_clientUom#s/yr)
Last Purch: #dateformat(confirmedVolumeDate,"mmm yyyy")#
Confirmed Status Buying (#ltrim(numberformat(val(_volumeQty),"9,999"))# #_clientUom#s/yr)
Not Buying (#ltrim(numberformat(val(_volumeQty),"9,999"))# #_clientUom#s/yr)