select restrictid as segmentid, description as segment from tbl_bcrm_objrestrictions obr left outer join tbl_OPR_ClientSegments seg on seg.clientsegid = obr.restrictid where obr.ownerid = and obr.ownertype = and obr.objectiveid = and obr.restricttype = 'seg' order by description select restrictid as segmentid, description as segment from tbl_bcrm_objrestrictions obr left outer join tbl_OPR_ClientSegments seg on seg.clientsegid = obr.restrictid where obr.ownerid = and obr.ownertype = and obr.objectiveid = and obr.restricttype = 'seg' order by description
#qcf_objDetail.objname#

#qcf_objDetail.objdescription#
#qcf_objDetail.ownername#
#dateformat(qcf_objDetail.publishdate,"mm/dd/yy")# - #dateformat(qcf_objDetail.unpublishdate,"mm/dd/yy")#  (#datediff("d",now(),qcf_objDetail.unpublishdate)# days left) (Expired)
#qcf_objdetail.oprdistributordesc#
 #_oprsegmentdesc#
 #qcf_objDetail.oprprioritydesc# Accounts
 Mfr #replace(qcf_objDetail.MfrOprTypeRestrict,"*","A+")# Priority Accounts
 "#replace(qcf_objDetail.oprtyperestrict,"*","A+")#" Priority Accounts
 #qcf_objDetail.opraffiliationdesc# Accounts - None -
#numberformat(qcf_objDetail.TotalQuota,"999,999")# #qcf_objDetail.quotatypedesc# #qcf_objDetail.quotaDurationDesc#
#numberformat(qcf_objDetail.QuotaAchieved,"999,999")# (#numberformat((qcf_objDetail.QuotaAchieved/qcf_objDetail.TotalQuota)*100,"99")#%)
SKU Description
#mfr_name#
Category #linkdesc# #sku# #linkdesc# #packsize#