select partnerid, partnertype from tbl_crm_interactions where ownerid = and ownertype = and interactionid = select salesubjectid, salesubjecttype from tbl_crm_interactionsaledetails where ownerid = and ownertype = and interactionid = select salesubjectid from qryCurCallItems where salesubjecttype = 'SKU' select salesubjectid from qryCurCallItems where salesubjecttype = 'MFR' select salesubjectid from qryCurCallItems where salesubjecttype = 'BRO' select salesubjectid from qryCurCallItems where salesubjecttype = 'PRD' select unitOfMeasure from tblManufacturers where mfr_id = select * from qcf_products where sku is not null and ( upper(sku) like or upper(skuDesc) like or upper(packSizeDesc) like ) and mfr_id = and upper(discontinued) = 'N' select 'SKU' as subjecttype, fc.skuid as subjectid, fc.skuid, fc.sku, fc.skuDesc, fc.packSizeDesc, fc.mfr_id, fc.mfr_name, fc.discontinued from tbl_DW_ProductHierarchy#_tableSuffix# fc with (nolock) where fc.focusproduct = 'Y' and mfr_id = order by fc.mfr_name, fc.sku select 'SKU' as subjecttype, sku.skuid as subjectid, sku.skuid, sku.sku, sku.skuDesc, sku.packSizeDesc, mfr.mfr_id, mfr.mfr_name, sku.discontinued from tbl_BCRM_UserItemFavorites fv with (nolock) inner join tbl_prd_skus sku on sku.ownerid = fv.ownerid and sku.fsl_tablecode = fv.ownertype and sku.skuid = fv.skuid and sku.mfrid = inner join tblManufacturers mfr with (nolock) on mfr.mfr_id = sku.mfrid where fv.fspro_userid = and fv.ownerId = and fv.ownerType = and ( sku.skuDesc like or sku.packSizeDesc like or mfr.mfr_name like ) and fv.category like and sku.discontinued = 'N' union select 'PRD' as subjecttype, prd.prodid as subjectid, prd.prodid as skuid, 'CATEGORY' as sku, prd.shortdesc as skuDesc, '' as packSizeDesc, mfr.mfr_id, mfr.mfr_name, 'N' as discontinued from tbl_org_attributelinks oal with (nolock) inner join tbl_prd_products prd with (nolock) on prd.prodid = oal.child_attrID and oal.child_attrTypeID = 59 and prd.mfrid = inner join tblManufacturers mfr with (nolock) on mfr.mfr_id = prd.mfrid where oal.mstr_attrID = and oal.mstr_attrTypeID = 34 and ( prd.shortdesc like or mfr.mfr_name like ) and 1 = 2 order by mfr.mfr_name, sku.sku select * from qcf_catalogSearchResults where 1 = 1 and upper(mfr_name) like and skuid = select 'SKU' as subjecttype, fc.skuid as subjectid, fc.skuid, fc.sku, fc.skuDesc, fc.packSizeDesc, fc.mfr_id, fc.mfr_name, fc.discontinued from tbl_DW_ProductHierarchy#_tableSuffix# fc with (nolock) where fc.focusproduct = 'Y' and mfr_Id = order by fc.mfr_name, fc.sku 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 distinct mfrid as mfr_id, mfr_name, skuid, sku, description as skuDesc, packSize as packSizeDesc, discontinued, stockingStatus, affiliationStatus, lastInvoiceDate, lastInvoiceCases, lastInvoiceLbs , confirmedvolumetime, confirmedVolumeQty, volumetime, volumeQty, confirmedPurchasingStatus, purchasingStatus, confirmedVolumeDate from qcf_catalogSearchResults order by mfr_name, sku

#companyname#
Call Date: #dateformat(interactiondate,"m/d/yy")# #daysAgoDisplay#

checked /> #sku# #encodeforhtml(skuDesc)# #encodeforhtml(packSizeDesc)#
discontinued

Misc

checked /> #mfr_name#Miscellaneous Entry

checked /> #category# [#product#]

checked /> #sku# #encodeforhtml(skuDesc)#isdefined("packSizeDesc") and packSizeDesc neq ""> #encodeforhtml(packSizeDesc)#
discontinued

#_1FSSettings.searchResultsMessage#

#mfr_name#

checked /> #sku# #encodeforhtml(skuDesc)# #encodeforhtml(packSizeDesc)#

#encodeforhtml(affiliationStatus)#

discontinued

#encodeforhtml(qryDistInfo.cdr_dstname)#
Last Inv: #dateformat(lastInvoiceDate,"m/d/yy")#, #numberformat(val(lastInvoiceCases),"9,999")# Cases Last Inv: #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)

checked /> #sku# #skuDesc#isdefined("packSizeDesc") and packSizeDesc neq ""> #packSizeDesc#
discontinued

select mfr_name from tblmanufacturers with (nolock) where mfr_id = select mfr_name from tblmanufacturers with (nolock) where mfr_id =

#_searchMessage#

#_lowerPagerDisplay#