select ps.confirmedPurchasingStatus, ps.confirmedVolumeQty, ps.confirmedvolumetime, ps.productStatusId, ps.confirmedVolumeDate, ps.volumeQty, ps.volumeTime, ps.purchasingStatus, case when ps.confirmedPurchasingStatus in ('b','n') then ps.confirmedPurchasingStatus when ps.purchasingStatus in ('b','n') then ps.purchasingStatus else '?' end as statusIndicator from tbl_opr_productStatus ps with(nolock) where ps.ownerid = and ps.ownertype = and ps.skuid = and ps.operatorid =


YTD #_mfrUOM.unitOfMeasurePlural#	#numberformat(qcf_skuInfo.annualqty_TY,"9,999")# #_deltaQty.deltaPercent##_deltaQty.indicatorCharacter#

YTD #ucase(_mfrUOM.altUnitOfMeasureAbreviated)#	#numberformat(qcf_skuInfo.annualalt_TY,"9,999")# #_deltaAlt.deltaPercent##_deltaAlt.indicatorCharacter#

YTD Dollars	$#numberformat(qcf_skuInfo.annualdollars_TY,"9,999")# #_deltaDollars.deltaPercent##_deltaDollars.indicatorCharacter#

F	Focus Product

D	Discontinued Item

	DOT Code: #qcf_skuInfo.dotcode# Status: #_dotStockingStatus#

	Foodservice Rewards

	Foodservice ProPoints

	Value Plus

	Cool School Cafe

	Brand Points Plus

	Real Rewards Cafe

P	Distributor Brand Operator Brand Private Label Product
	#_privateLabelCustName# Dist Item Code: #_privateLabelCustSKU# Cust Item Code: #_privateLabelCustSKU#

#_statusIndicator#	select unitOfMeasure from tblManufacturers where mfr_id = Buying (#ltrim(numberformat(val(_confirmedVolumeQty),"9,999"))# #_clientUom#s/yr) Last Purch: #dateformat(qryPurchasingStatus.confirmedVolumeDate,"mmm yyyy")# Confirmed Status Not Buying (#ltrim(numberformat(val(_confirmedVolumeQty),"9,999"))# #_clientUom#s/yr) Last Purch: #dateformat(qryPurchasingStatus.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) Purchasing Status Unkonwn