6-1. 宝洁报表逻辑说明

XXXX报表逻辑说明本次报表逻辑的更新如下（2021年3月31日）：计算CFR的时候，不统计CFRReasonCode为‘Dl.l','D2.1'D7'JT3.1"/T8’的数据.计算DOT的时候，要包括DOTReasoncodeR3,R4的数据.（以前我们改过一次，过滤了R3,R4的数据）计算inventoryDay的时候,Cost数据要过滤L-BO类型的仓库.计算Prod.Store和VisitStore,要加过滤条件hub_status=l计算Topsheet报表中Town#时,Town的名称要以〃镇〃，〃乡〃丁屯〃和〃兵团〃结尾.Onlysumhub_status=1(Active)只统计状态有效的HubImpactby受影响因素WhetherRDhasinstalledDMS/PDA是否有使用DMS/PDARDdatauploadingrateRD数据上传率DMSStoretypemaintenance(allstoresshouldbeinstandard&correctstoretype)DMS商店类型的维护(所有商店应该有正确的商店类型)RDDSRtypemaintenance(allDSRshouldbestandard&correctDSRtype)DMS销售代表类型的维护(所行销售代表应该有正确的标准销售代表类型)DMSARDPmaintenance(allstoreshouldbemaintainedARDP)DMS商店ARDP的维护(所有商店应该维护ARDP)PDAadoptionratePDA使用率PDAdatatimelysynchronizationPDA每天同步数据Ship-to-codemaintenance(haveship-to-code:timely&accuratelymaintainandupdateship-to-codeinSFA;noship-tocode:applydummyship-to-code)Ship-to-code的维护(Hub有ship-to・code：应及时和准确的维护，并在SFA上更新；Hub没有ship-to-code：应申请dummyship-to-code)StatusActive/Inactive(Hub/Store)Hub的有效状态和商店的有效状态No.ofProductiveStoreDatasource:DMS数据源：DMSCalculationLogic：=Numberofdistinctstorethathavenormalofftakeinpast3months,forbanner/chainstore,outletsarecompliedwithupper-levelbanner'stransactionexceptoutletshaverespectivetransaction.计算逻辑：过往3个月，有正常销售数据的商店的数目.对于连锁客户，如果其总部有正常销售数据，其下属没有销售数据的门店也被认为有正常销售数据；其下属有销售数据的门店不受总部销售数据的影响.CalculationRules:计算规则：OnlysumStoreswhichhavetrans_type=1offtakeinP3M只统计过往3个月有正常销售数据的商店OnlysumStoresofstore_status=1(Active),ARDP=1(dohaveARDP)只统计商店状态有效和ARDP有效的商店Onlysumstandardstorejype,includingHM/SM/MM/CVS/DS/CS/PW/MW/OTHERS/BS/HPG/NHPG/Banner/Super/Multiple_S/PCS/Hyper/Multiple_H/Dept/eRetail/Drug/Hspt只统计标准商店类型的商店，标准商店类型包括：HM/SM/MM/CVS/DS/CS/PW/MW/OTHERS/BS/HPG/NHPG/Banner/Super/Multiple_S/PCS/Hyper/Multiple_H/Dept/eRetail/Drug/HsptOnlysumOfftakeofstandardproduct:ProductinSourceOne5005ProductHierarchy只计算标准的XX产品的销售数据：产品代码在SourceOne5005产品信息中OnlysumstandardDSRJype,includingDAM/MSR/WSR/SSR/PGSR/VGSR/TGSR/HSRA/HSRB/BSR/TSR/NNSR只计算标准的销售代表类型的销售数据，标准销售代表类型包括：DAM/MSR/WSR/SSR/PGSR/VGSR/TGSR/HSRA/HSRB/BSR/TSR/NNSRExcludeStoresthathubship-to-codeisnull不统计没有ship-to-code的Hub的商店ExcludeOfftakethatWarehousetype=L-BO,F-BO,POSM,OTH,GIFT不计算以下仓库类型的销售数据：L-BO,F-BO,POSM,OTH,GIFTSumHQ/BOCoveredstores只统计HQ和BO的商店Onlysumhub_status=1(Active)只统计状态有效的HubImpactby受影响因素WhetherRDhasinstalledDMS是否有使用DMSRDdatauploadingrateRD数据上传率DMSStoretypemaintenance(allstoresshouldbeinstandard&correctstoretype)DMS商店类型的维护(所有商店应该有正确的标准商店类型)DMSWarehousetypemaintenance(allwarehousesshouldbeinstandard&correctwarehousetype)DMS仓库类型的维护(所有仓库应该有正确的标准仓库类型)DMSProductmasterdatamaintenance(allproductsshouldbecompanystandardproducts)DMS产品信息的维护(所有产品应该有标准的XXXX产品代码)RDDSRtypemaintenance(allDSRshouldbestandard&correctDSRtype)DMS销售代表类型的维护(所有销售代表应该有正确的标准销售代表类型)DMSARDPmaintenance(allstoreshouldbemaintainedARDP)DMS商店ARDP的维护(所有商店应该维护ARDP)Ship-to-codemaintenance(haveship-to-code:timely&accuratelymaintainandupdateship-to-codeinSFA;noship-tocode:applydummyship-to-code)Ship-to-code的维护(Hub有ship-to-code：应及时和准确的维护，并在SFA上更新；Hub没有ship-to-code：应申请dummyship-to-code)StatusActive/Inactive(Store)商店的有效状态DailyCallperDSRDatasource:02数据源：02CalculationLogic：=Totalcalls/TotalnumberofDSRwithvisit/Totalworkingdaysinselectedmonth计算逻辑：DSR总拜访数除以总拜访的人数，再除以当月的工作天数CalculationRules:计算规则：OnlysumstandardDSRJype,includingDAM/MSR/WSR/SSR/PGSR/VGSR/TGSR/HSRA/HSRB/BSR/TSR只计算标准的销售代表类型的拜访数据，标准销售代表类型包括：DAM/MSR/WSR/SSR/PGSR/VGSR/TGSR/HSRA/HSRB/BSR/TSRExcludeStoresthathubship-to-codeisnull不统计没有ship-to-code的Hub的商店Impactby受影响因素WhetherRDhasinstalledDMS/PDA是否有使用DMS/PDARDdatauploadingrateRD数据上传率RDDSRtypemaintenance(allDSRshouldbestandard&correctDSRtype)DMS销售代表类型的维护(所有销售代表应该有正确的标准销售代表类型)PDAadoptionratePDA使用率PDAdatatimelysynchronizationPDA每天同步数据Ship-to-codemaintenance(haveship-to-code:timely&accuratelymaintainandupdateship-to-codeinSFA;noship-tocode:applydummyship-to-code)Ship-to-code的维护(Hub有ship-to-code：应及时和准确的维护，并在SFA上更新；Hub没有ship-to-code：应申请dummyship-to-code)DailyProductiveCallperDSRDatasource:02数据源：DMSCalculationLogic：=Totalproductivecalls/TotalnumberofDSRwithvisit/Totalworkingdaysinselectedmonth计算逻辑：DSR总有效拜访数除以总拜访的人数，再除以当月的工作天数CalculationRules:计算规则：OnlysumstandardDSRJype,includingDAM/MSR/WSR/SSR/PGSR/VGSR/TGSR/HSRA/HSRB/BSR/TSR只计算标准的销售代表类型的拜访数据，标准销售代表类型包括：DAM/MSR/WSR/SSR/PGSR/VGSR/TGSR/HSRA/HSRB/BSR/TSRExcludeStoresthathubship-to-codeisnull不统计没有ship-to-code的Hub的商店Impactby受影响因素WhetherRDhasinstalledDMS/PDA是否有使用DMS/PDARDdatauploadingrateRD数据上传率RDDSRtypemaintenance(allDSRshouldbestandard&correctDSRtype)DMS销售代表类型的维护(所有销售代表应该有正确的标准销售代表类型)PDAadoptionratePDA使用率PDAdatatimelysynchronizationPDA每天同步数据Ship-to-codemaintenance(haveship-to-code:timely&accuratelymaintainandupdateship-to-codeinSFA;noship-tocode:applydummyship-to-code)Ship-to-code的维护(Hub有ship-to-code：应及时和准确的维护，并在SFA上更新；Hub没有ship-to・code：应申请dummyship-to-code)OHD(On-HandDistribution)Datasource:02数据源：02CalculatorLogic：=TotaldistinctdistributedSKU/TotalvisitedStoresinpast1month计算逻辑：过往1个月，不重复的货架分销数总和除以拜访的商店总数CalculationRules:计算规则：TotaldistinctdistributedSKU=totalnumberofdistinctSKUinvisitedstores不重复的货架分销数总和等于每个拜访商店的不重复货架分销数之和OnlysumStoresofstore_status=1(Active),ARDP=1(dohaveARDP)只统计商店状态有效和ARDP有效的商店Onlysumstandardstorejype,includingHM/SM/MM/CVS/DS/CS/PW/MW/OTHERS/BS/HPG/NHPG/Super/Multiple_S/PCS/Hyper/Multiple_H/Dept/eRetail/Drug/Hspt只统计标准商店类型的商店，标准商店类型包括：HM/SM/MM/CVS/DS/CS/PW/MW/OTHERS/BS/HPG/NHPG/Super/Multiple_S/PCS/Hyper/Multiple_H/Dept/eRetail/Drug/HsptOnlysumOfftakeofstandardproduct:ProductinSourceOne5005ProductHierarchy只计算标准的XX产品的销售数据：产品代码在SourceOne5005产品信息中ExcludeStoresthathubship-to-codeisnull不统计没有ship-to-code的Hub的商店SumHQ/BOandSub-DCoveredstores只统计HQ和BO,以及其下属Sub-D的商店Impactby受影响因素WhetherRDhasinstalledDMS/PDA是否有使用DMS/PDARDdatauploadingrateRD数据上传率DMSStoretypemaintenance(allstoresshouldbeinstandard&correctstoretype)DMS商店类型的维护(所有商店应该有正确的标准商店类型)DMSProductmasterdatamaintenance(allproductsshouldbecompanystandardproducts)DMS产品信息的维护(所有产品应该有标准的XXXX产品代码)DMSARDPmaintenance(allstoreshouldbemaintainedARDP)DMS商店ARDP的维护(所有商店应该维护ARDP)PDAadoptionratePDA使用率PDAdatatimelysynchronizationPDA每天同步数据Ship-to-codemaintenance(haveship-to-code:timely&accuratelymaintainandupdateship-to-codeinSFA;noship-tocode:applydummyship-to-code)Ship-to-code的维护(Hub有ship-to-code：应及时和准确的维护，并在SFA上更新；Hub没有ship-to-code：应申请dummyship-to-code)StatusActive/Inactive(Store)商店的有效状态LD(LiveDistribution)Datasource:DMS数据源：DMSCalculationLogic：=TotalnumbersofdistinctSKUboughtinP3M/ProductiveStore#inP3M,ifbanner'soutlethasnotransactionaldata,keepthesameLDwithbanner;ifbanner'soutlethastransactionaldata,calculatebannerandoutletsLDseparately.计算逻辑：过往3个月，各个卖进商店的不重复的卖进分销数总和除以卖进商店总数.对于连锁客户，如果其下属门店没有卖进分销数，则其门店的卖进分销数默认与总部保持一致；如果其下属门店有卖进分销数，则计算其自己的分销数.CalculationRules:计算规则：TotalnumbersofdistinctSKUinP3MshouldbecalculatedfromProductiveStoreinP3M不重复的卖进分销数根据过往3个月的卖进商店来统计OnlysumStoreswhichhavetrans_type=1OfftakeinP3M只统计过往3个月有正常销售数据的商店OnlysumStoresofstore_status=1(Active),ARDP=1(dohaveARDP)只统计商店状态有效和ARDP有效的商店Onlysumstandardstorejype,includingHM/SM/MM/CVS/DS/CS/PW/MW/OTHERS/BS/HPG/NHPG/Super/Multiple_S/PCS/Hyper/Multiple_H/Dept/eRetail/Drug/Hspt只统计标准商店类型的商店，标准商店类型包括：HM/SM/MM/CVS/DS/CS/PW/MW/OTHERS/BS/HPG/NHPG/Super/Multiple_S/PCS/Hyper/Multiple_H/Dept/eRetail/Drug/HsptOnlysumOfftakeofstandardproduct:ProductinSourceOne5005ProductHierarchy只计算标准的XX产品的销售数据：产品代码在SourceOne5005产品信息中OnlysumHQ/BOcoveredstores只统计HQ和BO的商店OnlysumstandardDSRJype,includingDAM/MSR/WSR/SSR/PGSR/VGSR/TGSR/HSRA/HSRB/BSR/TSR/NNSR只计算标准的销售代表类型的销售数据，标准销售代表类型包括：DAM/MSR/WSR/SSR/PGSR/VGSR/TGSR/HSRA/HSRB/BSR/TSR/NNSRExcludeStoresthathubship-to-codeisnull不统计没有ship-to-code的Hub的商店ExcludeStoresthatWarehousetype=L-BO,F-BO,POSM,OTH,GIFT不计算以下仓库类型的销售数据：L-BO,F-BO,POSM,OTH,GIFTOnlysumhub_status=1(Active)只统计状态有效的HubImpactby受影响因素WhetherRDhasinstalledDMS是否有使用DMSRDdatauploadingrateRD数据上传率DMSStoretypemaintenance(allstoresshouldbeinstandard&correctstoretype)DMS商店类型的维护(所有商店应该有正确的标准商店类型)DMSWarehousetypemaintenance(allwarehousesshouldbeinstandard&correctwarehousetype)DMS仓库类型的维护(所有仓库应该有正确的标准仓库类型)DMSProductmasterdatamaintenance(allproductsshouldbecompanystandardproducts)DMS产品信息的维护(所有产品应该有标准的XXXX产品代码)RDDSRtypemaintenance(allDSRshouldbestandard&correctDSRtype)DMS销售代表类型的维护(所有销售代表应该有正确的标准销售代表类型)DMSARDPmaintenance(allstoreshouldbemaintainedARDP)DMS商店ARDP的维护(所有商店应该维护ARDP)Ship-to-codemaintenance(haveship-to-code:timely&accuratelymaintainandupdateship-to-codeinSFA;noship-tocode:applydummyship-to-code)Ship-to-code的维护(Hub有ship-to-code：应及时和准确的维护，并在SFA上更新；Hub没有ship-to・code：应申请dummyship-to-code)StatusActive/Inactive(Store)商店的有效状态TotalLiveDistributionDatasource:DMS数据源：DMSCalculationLogic：=TotalnumbersofdistinctSKUboughtinP3M计算逻辑：过往3个月，各个卖进商店的不重复的卖进分销数总和CalculationRules:计算规则：TotalnumbersofdistinctSKUinP3MshouldbecalculatedfromProductiveStoreinP3M不重复的卖进分销数根据过往3个月的卖进商店来统计OnlysumStoreswhichhavetrans_type=1OfftakeinP3M只统计过往3个月有正常销售数据的商店OnlysumStoresofstore_status=1(Active),ARDP=1(dohaveARDP)只统计商店状态有效和ARDP有效的商店Onlysumstandardstorejype,includingHM/SM/MM/CVS/DS/CS/PW/MW/OTHERS/BS/HPG/NHPG/Super/Multiple_S/PCS/Hyper/Multiple_H/Dept/eRetail/Drug/Hspt只统计标准商店类型的商店，标准商店类型包括：HM/SM/MM/CVS/DS/CS/PW/MW/OTHERS/BS/HPG/NHPG/Super/Multiple_S/PCS/Hyper/Multiple_H/Dept/eRetail/Drug/HsptOnlysumOfftakeofstandardproduct:ProductinSourceOne5005ProductHierarchy只计算标准的XX产品的销售数据：产品代码在SourceOne5005产品信息中OnlysumHQ/BOcoveredstores只统计HQ和BO的商店OnlysumstandardDSRJype,includingDAM/MSR/WSR/SSR/PGSR/VGSR/TGSR/HSRA/HSRB/BSR/TSR/NNSR只计算标准的销售代表类型的销售数据，标准销售代表类型包括：DAM/MSR/WSR/SSR/PGSR/VGSR/TGSR/HSRA/HSRB/BSR/TSR/NNSRExcludeStoresthathubship-to-codeisnull不统计没有ship-to-code的Hub的商店ExcludeStoresthatWarehousetype=L-BO,F-BO,POSM,OTH,GIFT不计算以下仓库类型的销售数据：L-BO,F-BO,POSM,OTH,GIFTOnlysumhub_status=1(Active)只统计状态有效的HubPlatinum/GoldenCall%Datasource:02数据源：02CalculationLogic:=TotalcallsofPlatinumorGolden/Totalvisits计算逻辑：白金或黄金总拜访次数除以全部的总拜访次数CalculationRules:计算规则：Platinum/Goldentotalcalls:白金/黄金总拜访次数OnlysumStoresofstore_status=1(Active),ARDP=1(dohaveARDP)只统计商店状态有效和ARDP有效的商店Onlysumstandardstorejype,includingHM/SM/MM/CVS/DS/CS/PW/MW/OTHERS/BS/HPG/NHPG/Super/Multiple_S/PCS/Hyper/Multiple_H/Dept/eRetail/Drug/Hspt只统计标准商店类型的商店，标准商店类型包括：HM/SM/MM/CVS/DS/CS/PW/MW/OTHERS/BS/HPG/NHPG/Super/Multiple_S/PCS/Hyper/Multiple_H/Dept/eRetail/Drug/HsptSumHQ/BOandSub-DCoveredstores统计HQ和BO,以及其下属Sub-D的商店Onlysumhub_status=1(Active)只统计状态有效的HubImpactby受影响因素WhetherRDhasinstalledDMS/PDA是否有使用DMS/PDARDdatauploadingrateRD数据上传率DMSStoretypemaintenance(allstoresshouldbeinstandard&correctstoretype)DMS商店类型的维护(所有商店应该有正确的标准商店类型)DMSProductmasterdatamaintenance(allproductsshouldbecompanystandardproducts)DMS产品信息的维护(所有产品应该有标准的XXXX产品代码)DMSARDPmaintenance(allstoreshouldbemaintainedARDP)DMS商店ARDP的维护(所有商店应该维护ARDP)PDAadoptionratePDA使用率PDAdatatimelysynchronizationPDA每天同步数据Ship-to-codemaintenance(haveship-to-code:timely&accuratelymaintainandupdateship-to-codeinSFA;noship-tocode:applydummyship-to-code)Ship-to-code的维护(Hub有ship-to-code：应及时和准确的维护，并在SFA上更新；Hub没有ship-to-code：应申请dummyship-to-code)No.ofPlatinum/GoldenStoresDatasourceDMS/O2数据源：DMS/O2CalculationLogic：=TotalCoveredstore*PlatinumorGoldenCall%计算逻辑：覆盖商店总数乘以白金或者黄金拜访率CalculationRules:计算规则：TotalCoveredStorelogicissameasTotalCoveredStores覆盖商店总数计算逻辑与上面所述"TotalCoveredStores”一致.No.ofPlatinum&GoldenStoresDatasource:DMS/O2数据源：DMS/O2CalculationLogic：=NoofPlatinumstore+NoofGoldenStore计算逻辑：白金商店数加黄金商店数CalculationRules:NA计算规则：无(PerfectStores)%ofCoveredStoresDatasource:O2/DMS数据源：O2/DMSCalculationLogic：=No.ofPlatinum&GoldenStores/TotalCoveredStores计算逻辑：达标商店数除以覆盖商店总数CalculationRules:NA计算规则：无TopInitiativesDistribution(LDCoverage%)Datasource:DMS数据源：DMSCalculationLoaic：=StoreshaveNlsales/TotalcoveredStores计算逻辑：新品卖进商店数除以覆盖商店总数CalculationRules:计算规则：OnlysumStoreswhichhavetrans_type=1Offtakeinselectedmonth只统计当月有正常销售数据的商店OnlysumStoresofstore_status=1(Active),ARDP=1(dohaveARDP)只统计商店状态有效和ARDP有效的商店Onlysumstandardstorejype,includingHM/SM/MM/CVS/DS/CS/PW/MW/OTHERS/BS/HPG/NHPG/Super/Multiple_S/PCS/Hyper/Multiple_H/Dept/eRetail/Drug/Hspt只统计标准商店类型的商店，标准商店类型包括：HM/SM/MM/CVS/DS/CS/PW/MW/OTHERS/BS/HPG/NHPG/Super/Multiple_S/PCS/Hyper/Multiple_H/Dept/eRetail/Drug/HsptOnlysumHQ/BOcoveredstores只统计HQ和BO的商店OnlysumstandardDSRJype,includingDAM/MSR/WSR/SSR/PGSR/VGSR/TGSR/HSRA/HSRB/BSR/TSR/NNSR只计算标准的销售代表类型的销售数据，标准销售代表类型包括：DAM/MSR/WSR/SSR/PGSR/VGSR/TGSR/HSRA/HSRB/BSR/TSR/NNSRExcludeStoresthathubship-to-codeisnull不统计没有ship-to-code的Hub的商店ExcludeStoresthatWarehousetype=L-BO,F-BO,POSM,OTH,GIFT不计算以下仓库类型的销售数据：L-BO,F-BO,POSM,OTH,GIFTImpactby受影响因素WhetherRDhasinstalledDMS是否有使用DMSRDdatauploadingrateRD数据上传率DMSStoretypemaintenance(allstoresshouldbeinstandard&correctstoretype)DMS商店类型的维护(所有商店应该有正确的标准商店类型)DMSWarehousetypemaintenance(allwarehousesshouldbeinstandard&correctwarehousetype)DMS仓库类型的维护(所有仓库应该有正确的标准仓库类型)DMSProductmasterdatamaintenance(allproductsshouldbecompanystandardproducts)DMS产品信息的维护(所有产品应该有标准的XXXX产品代码)RDDSRtypemaintenance(allDSRshouldbestandard&correctDSRtype)DMS销售代表类型的维护(所有销售代表应该有正确的标准销售代表类型)DMSARDPmaintenance(allstoreshouldbemaintainedARDP)DMS商店ARDP的维护(所有商店应该维护ARDP)Ship-to-codemaintenance(haveship-to-code:timely&accuratelymaintainandupdateship-to-codeinSFA;noship-tocode:applydummyship-to-code)Ship-to-code的维护(Hub有ship-to・code：应及时和准确的维护，并在SFA上更新；Hub没有ship-to・code：应申请dummyship-to-code)StatusActive/Inactive(Store)商店的有效状态InventoryDaysDatasource:DMS数据源：DMSCalculationLogic：=Month-endInventoryamount/P2Mofftake_cost*61计算逻辑：月末库存金额除以过往2个月销售成本额,再乘以61CalculationRules:计算规则：Onlysumlastcalendar_dayuploadedinventorydataofselectedmonth只统计当月最后一次上传的库存数据Onlysuminventoryamountofstandardwarehousetype=CENT,DAM,REM,VAN,COUN,R-BO,OSDO只统计标准仓库类型的库存数据，标准仓库类型包括:CENT,DAM,REM,VAN,COUN,R・BO,OSDOP2MOfftake_costonlysumstoresthatstore_type=HM/SM/MM/CVS/DS/CS/LUH/PW/MW/SUBD/OTHERS/BS/Banner/HPG/NHPG/Super/Multiple_S/PCS/Hyper/Multiple_H/Dept/eRetail/Drug/Hspt过往2个月销售成本额，只统计标准商店类型的商店,标准商店类型包括：HM/SM/MM/CVS/DS/CS/LUH/PW/MW/SUBD/OTHERS/BS/Banner/HPG/NHPG/Super/Multiple_S/PCS/Hyper/Multiple_H/Dept/eRetail/Drug/HsptOnlysumofftakeofstandardwarehousetype=CENT,DAM,REM,VAN,COUN,R-BO,OSDO只统计标准仓库类型的销售数据，标准仓库类型包括CENT,DAM,REM,VAN,COUN,R-BO-OSDOOnlysumstandardproduct:ProductinSourceOne5005ProductHierarchy只计算标准的XX产品：产品代码在SourceOne5005产品信息中Excludehubsthatofftake_costislessthan2months不统计销售数据不足2个月的hubImpactby受影响因素WhetherRDhasinstalledDMS是否有使用DMSRDdatauploadingrateRD数据上传率DMSStoretypemaintenance(allstoresshouldbeinstandard&correctstoretype)DMS商店类型的维护(所有商店应该有正确的标准商店类型)DMSWarehousetypemaintenance(allwarehousesshouldbeinstandard&correctwarehousetype)DMS仓库类型的维护(所有仓库应该有正确的标准仓库类型)DMSProductmasterdatamaintenance(allproductsshouldbecompanystandardproducts)DMS产品信息的维护(所有产品应该有标准的XXXX产品代码)RDDSRtypemaintenance(allDSRshouldbestandard&correctDSRtype)DMS销售代表类型的维护(所有销售代表应该有正确的标准销售代表类型)DMSARDPmaintenance(allstoreshouldbemaintainedARDP)DMS商店ARDP的维护(所有商店应该维护ARDP)Ship-to-codemaintenance(haveship-to-code:timely&accuratelymaintainandupdateship-to-codeinSFA;noship-tocode:applydummyship-to-code)Ship-to-code的维护(Hub有ship-to-code：应及时和准确的维护，并在SFA上更新；Hub没有ship-to-code：应申请dummyship-to-code)CFR(CaseFillRate)Datasource:DMS数据源：DMSCalculationLogic：=StoreReceivedcases/StoreOrderedcases*100计算逻辑：商店实际收货数量除以商店原始订货数量，再乘以100CalculationRules:计算规则：StoreReceivedcases=confirmeditems(salesquantity)-rejecteditems(returnedquantity)商店实际收货数量等于确认销售的数量减去退货数量StoreOrderedcases=confirmeditems+unfilleditems商店原始订货数量等于确认销售数量加上缺货数量OnlysumquantityinCENTwarehouse只统计CENT仓库类型的数据Onlysumstandardproduct:ProductinSourceOne5005ProductHierarchy只计算标准的XX产品：产品代码在SourceOne5005产品信息中Confirmedsalesquantityonlysumtrans_type=1Offtakeinselectedmonth确认销售数量是指当月的正常销售数据ReturnedquantityonlysumCFRReasoncode=T退货数量是统计原因代码为“T”开头的CFR数据OOSquantityonlysumCFRReasoncode=D缺货数量是统计原因代码为“D”开头的CFR数据ExcludeStoresthathubship-to-codeisnull不统计没有ship-to-code的Hub的商店ExcludeStoreType='BO'不统计“BO”类型的商店ExcludedCFRReasonCode'Dl.l','D2.1','D7','T3.1','T8'不统计原因代码为'D2.1','D7','T3.1','T8'的CFR数据RD,Market,Division,NationalnumberisaggregatedbyweightedaverageRD,Market,Division,Nationaid的数据汇总采用从明细数据加和平均Impactby受影响因素WhetherRDhasinstalledDMS是否有使用DMSRDdatauploadingrateRD数据上传率DMSStoretypemaintenance(allstoresshouldbeinstandard&correctstoretype)DMS商店类型的维护(所有商店应该有正确的标准商店类型)DMSWarehousetypemaintenance(allwarehousesshouldbeinstandard&correctwarehousetype)DMS仓库类型的维护(所有仓库应该有正确的标准仓库类型)DMSProductmasterdatamaintenance(allproductsshouldbecompanystandardproducts)DMS产品信息的维护(所有产品应该有标准的XXXX产品代码)RDDSRtypemaintenance(allDSRshouldbestandard&correctDSRtype)DMS销售代表类型的维护(所有销售代表应该有正确的标准销售代表类型)DMSARDPmaintenance(allstoreshouldbemaintainedARDP)DMS商店ARDP的维护(所有商店应该维护ARDP)Ship-to-codemaintenance(haveship-to-code:timely&accuratelymaintainandupdateship-to-codeinSFA;noship-tocode:applydummyship-to-code)Ship-to-code的维护(Hub有ship-to-code：应及时和准确的维护，并在SFA上更新；Hub没有ship-to-code：应申请dummyship-to-code)DOT(DeliveronTime)Datasource:DMS数据源：DMSCalculationLogic：=(QuantityofOrderdeliveredwithin24hours+QuantityofreasoncodeR3,R4)/totalorderQuantityinselectedmonth*100计算逻辑：(24小时内准时到货的订单数+未准时送达原因为不计算的订单)除以总订单数，再乘以100CalculationRules:计算规则：OnlysumquantityinCENTwarehouse只统计CENT仓库类型的数据OnlysumHQ/BOcoveredstores只统计HQ和BO的商店Onlysumstoresthatstorejype=HM/SM/MM/CVS/DS/CS/LUH/PW/MW/SUBD/OTHERS/BS/Banner/HPG/NHPG/Super/Multiple_S/PCS/Hyper/Multiple_H/Dept/eRetail/Drug/Hspt只统计标准商店类型的商店，标准商店类型包括：HM/SM/MM/CVS/DS/CS/LUH/PW/MW/SUBD/OTHERS/BS/Banner/HPG/NHPG/Super/Multiple_S/PCS/Hyper/Multiple_H/Dept/eRetail/Drug/HsptRD,Market,Division,NationalnumberisaggregatedbyweightedaverageRD,Market,Division,Nationaid的数据汇总采用从明细数据加和平均Impactby受影响因素WhetherRDhasinstalledDMSCONTENT目录Indirectshipment(Offtake)RMB销售额3TotalCoveredStores覆盖商店数错误!未定义签。No.ofCities覆盖城市数错误味定义书签。No.ofTowns覆盖乡镇数错误!未定义书签。No.ofHQ总部数错误味定义书签。No.ofB0分公司数错误味定义书签。No.ofSub-D二级分销商数错误味定义书签。No.ofInactiveStores非活动商店数错误!未定义书签。No.ofVisitedStore拜访商店数错误味定义书签。No.ofProductiveStore有效商店数错误!未定义书签。DailyCallperDSR销售代表每日拜访数错误味定义书签。DailyProductiveCallperDSR销售代表每日有效拜访数错误味定义书签。OHD(On-HandDistribution)店内可见分销数错误味定义书签。LD(LiveDistribution)有效分销数错误味定义书签。TotalLiveDistribution总有效分车肖数错误！未定义书签。Platinum/GoldenCall%白金/黄金拜访比率错误味定义书签。No.ofPlatinum/GoldenStores白金/黄金商店数错误味定义书签。No.ofPlatinum&GoldenStores完美商店数错误保定义书签。(PerfectStores)%ofCoveredStores完美商店比率错误!未定义书签。InventoryDays库存天数错误!未定义书签。CFR(CaseFillRate)订单满足率错误味定义书签。DOT(DeliveronTime)准时送货率错误味定义书签。GrossMargin(%)(Beforetax)税前毛利错误!未定义书签。ROI(%)ReturnofInvestment投资回报率错误!未定义书签。TotalSellerNumber销售代表数量错误床定义书签。DSRTurnoverRate销售代表离职率错误保定义书签。是否有使用DMSRDdatauploadingrateRD数据上传率DMSStoretypemaintenance(allstoresshouldbeinstandard&correctstoretype)DMS商店类型的维护(所有商店应该有正确的标准商店类型)DMSWarehousetypemaintenance(allwarehousesshouldbeinstandard&correctwarehousetype)DMS仓库类型的维护(所有仓库应该有正确的标准仓库类型)Ship-to-codemaintenance(haveship-to-code:timely&accuratelymaintainandupdateship-to-codeinSFA;noship-tocode:applydummyship-to-code)Ship-to-code的维护(Hub有ship-to-code：应及时和准确的维护，并在SFA上更新；Hub没有ship-to-code：应申请dummyship-to-code)GrossMargin(%)(Beforetax)Datasource:DMS数据源：DMSCalculationLogic：=(IndirectShipmentGIVLocalCurrency-Cost)/Cost*100%**AllinLocalCurrency计算逻辑：(销售额一成本)/成本*100%CalculationRules:计算规则：CostcalculationrulesisthesameasOfftake(Indirectshipment)RMB成本的计算规则与销售额的一致Costcalculationlogic=cost/(1-QED%1.9%)*(1-QED%1.9%-Cashdiscount2%-damagediscount0.25%)成本的计算逻辑=cost/(1-1.9%)*(1-1.9%-2%-0.25%)Impactby受影响因素WhetherRDhasinstalledDMS是否有使用DMSRDdatauploadingrateRD数据上传率DMSStoretypemaintenance(allstoresshouldbeinstandard&correctstoretype)DMS商店类型的维护(所有商店应该有正确的标准商店类型)DMSWarehousetypemaintenance(allwarehousesshouldbeinstandard&correctwarehousetype)DMS仓库类型的维护(所有仓库应该有正确的标准仓库类型)DMSProductmasterdatamaintenance(allproductsshouldbecompanystandardproducts)DMS产品信息的维护(所有产品应该有标准的XXXX产品代码)RDDSRtypemaintenance(allDSRshouldbestandard&correctDSRtype)DMS销售代表类型的维护(所有销售代表应该有正确的标准销售代表类型)Ship-to-codemaintenance(haveship-to-code:timely&accuratelymaintainandupdateship-to-codeinSFA;noship-tocode:applydummyship-to-code)Ship-to-code的维护(Hub有ship-to-code：应及时和准确的维护，并在SFA上更新；Hub没有ship-to-code：应申请dummyship-to-code)ROI(%)ReturnofInvestmentDatasource：CBCScorecard数据源：CBCScorecardCalculationLogic：NA计算逻辑：无CalculationRules:NA计算规则：无TotalSellerNumberDatasource:DMS数据源：DMSCalculationLogic：=NumberoftotalDSR计算逻辑：分销商下属销售代表的人数CalculationRules:计算规则：OnlysumactiveDSR(DSR_status=1)只统计状态有效的销售代表ExcludevirtualDSR=NNSR不统计类型为NNSR的销售代表ExcludeDSRthath