Food Service Rewards Load Results

FSR IDs Found FSR IDs Not Found Added Updated
#qmd_setActive.activeRows##qmd_setInactive.inactiveRows##qmd_insertNewRecords.newRecords##qmd_existingActive.extActive#
FSR Operator ID without a Foodservice Rewards ID
#qmd_noFSRID.fsr_operator_name# - #qmd_noFSRID.fsr_operator_id#
select mvo.*, fsr.*, ter.name TerritoryName from tbl_FSR_MVOStatus mvo inner join tbl_FSR_OperatorCompanies fsr on fsr.foodServiceRewardsId = mvo.foodServiceRewardsId and fsr.ownerId = mvo.ownerId and fsr.ownerType = mvo.ownerType inner join tbl_OPR_ClientOperators opr on opr.ownerId = fsr.ownerId and opr.fsltablecode = fsr.ownerType and opr.operatorId = fsr.operatorId left outer join tbl_TER_Territories ter on opr.territoryId = ter.territoryId and opr.ownerId = ter.ownerId and opr.fsltablecode = ter.fsl_tablecode where mvo.ownerId = and mvo.ownerType = and mvo.mvoState = 'A' and fsr.operatorId = opr.operatorId order by mvo.mvoStatus
FSR Operator Name FSR ID MVO Status Territory
#fsrOperatorName##foodservicerewardsId##mvoStatus##territoryName#
Quarterly MVO SummaryQ#qmd_liveList.mvoQuarter# #qmd_liveList.mvoYear#
StatusCount
Increasing#lsnumberformat( qmd_green.recordCount )#
Steady#lsnumberformat( qmd_neither.recordCount )#
Decreasing#lsnumberformat( qmd_red.recordCount )#
No Redemptions#lsnumberformat( qmd_yellow.recordCount )#
Total MVOs#lsnumberformat( _totalRecords )#