select skuid, sku, skuDesc from tbl_prd_skus where ownerid = and fsl_tablecode = and skuid = select distinct cdr.cdr_recordId, cdr.cdr_dstCode, cdr.cdr_dstName, cdr.cdr_dstcity, cdr.cdr_dststate from tbl_MFR_TPF_Detail#_tpfSuffix# ih with (nolock) inner join tbl_CDR_Distributors cdr with (nolock) on cdr.ownerId = and cdr.fsl_tablecode = and cdr.cdr_recordId = ih.tpartnerid --and cdr.cdr_dstCompanyType = 'B' and cdr.cdr_territoryId in ( ) where ih.mfr_id = and ih.productLevel = 'sku' and ih.forecast_status = 'a' and ih.tpartnertype = 'cdr' and ih.skuId = order by cdr.cdr_dstName startDate="#_calendarVars.tyStartDate#" endDate="#_calendarVars.tyEndDate#" planEndDate="#_calendarVars.tyPlanEndDate#" skuid="#url.skuid#" columnSuffix="_ty"> startDate="#_calendarVars.lyStartDate#" endDate="#_calendarVars.lyEndDate#" planEndDate="#_calendarVars.lyPlanEndDate#" lastMonthRate="#_calendarVars.lastMonthRate#" columnSuffix="_ly" skuid="#url.skuid#" addYearOverYearColumns=true > select * from qryDistributors where annualqty_TY <> 0
Distributor Purchasing
#qrySku.skuDesc#
#_mfrUOM.unitOfMeasurePlural#
#_deltaCases.deltaPercent##_deltaCases.indicatorCharacter#
Dollars
#_deltaDollars.deltaPercent##_deltaDollars.indicatorCharacter#
  • Invoice Data #dateformat(_calendarVars.tyPlanStartDate,"m/d/yy")# - #dateformat(_calendarVars.tyPlanEndDate,"m/d/yy")#, as of #dateformat(_calendarVars.asOfDate,"m/d/yy")#
    •

  • #cdr_dstName#

    #cdr_dstcity#, #cdr_dststate#

    0% #_qtyDelta.deltaPercent##_qtyDelta.indicatorCharacter# #ucase(_mfrUOM.unitOfMeasureAbreviated)# #numberformat(annualqty_ty,"9,999")#
    0% #_dollarsDelta.deltaPercent##_dollarsDelta.indicatorCharacter# $ #numberformat(annualdollars_ty,"9,999")#
#_lowerPagerDisplay#