Plan Level 1 MFP_PLAN1_EXP - Merch Plan Export

This plan export is for exporting both the OP and CP versions of approved Merch Plans. VERSION_NUM 0 is used to export the OP version and 1 is used to export the CP version. The following table only shows the mapping for OP versions. The CP versions of mapping remain the same; the Version Number used is 1.

Staging Table Column Description MFP Dimension/Measure Mapping Retail/Cost

PROD_KEY

Product Dimension

scls

  

LOC_KEY

Location Dimension

chnc

  

CLND_KEY

Calendar Dimension

week

  

PROD_DH_ATTR

Attribute Dimension for RI

-1

  

SUPPLIER_NUM

Supplier Dimension for RI

-1

  

CAL_DATE

Last Day of Week

MPOPLDOWD

  

VERSION_NUM

Version Number

0

  

SLS_QTY

Op Sales U

MPOPSlsU

  

SLSCL_QTY

Op Sales Clr U

MPOPSls2U

  

SLSRGPRO_QTY

Op Sales Reg+Promo U

MPOPSls1U

  

SLS_RTL_AMT

Op Sales R

MPOPSlsR

  

SLSCL_RTL_AMT

Op Sales Clr R

MPOPSls2R

  

SLSRGPRO_RTL_AMT

Op Sales Reg+Promo R

MPOPSls1R

  

SLS_COST_AMT

Op Sales C

MPOPSlsC

  

RET_QTY

Op Returns U

MPOPRtnU

  

RETCL_QTY

Op Returns Clr U

MPOPRtn2U

  

RETRGPRO_QTY

Op Returns Reg+Promo U

MPOPRtn1U

  

RET_RTL_AMT

Op Returns R

MPOPRtnR

  

RETCL_RTL_AMT

Op Returns Clr R

MPOPRtn2R

  

RETRGPRO_RTL_AMT

Op Returns Reg+Promo R

MPOPRtn1R

  

NET_SLSRGPRO_QTY

Op Net Sales Reg+Promo U

MPOPNSls1U

  

NET_SLSCL_QTY

Op Net Sales Clr U

MPOPNSls2U

  

NET_SLSRGPRO_RTL_AMT

Op Net Sales Reg+Promo R

MPOPNSls1R

  

NET_SLSCL_RTL_AMT

Op Net Sales Clr R

MPOPNSls2R

  

NET_MARGIN_RTL_AMT

Op Net GM R

MPOPNGMR

  

TAX_RTL_AMT

Op VAT R

MPOPVATR

  

SLSTE_RTL_AMT

Op Net Sales R

MPOPNSlsR

  

MARGIN_RTL_AMT

Op GM R

MPOPGMR

  

MKDNPM_RTL_AMT

Op Markdown Perm Reg+Promo R

MPOPInvDV1R

  

MKDNCL_RTL_AMT

Op Markdown Perm Clr R

MPOPInvDV2R

  

MKDNPR_RTL_AMT

Op Markdown POS R

MPOPMkdR

  

BOH_COST_AMT

Op BOP C

MPOPBOPC

  

BOH_RTL_AMT

Op BOP R

MPOPBOPR

  

BOHRGPRO_RTL_AMT

Op BOP Reg+Promo R

MPOPBOP1R

  

BOHCL_RTL_AMT

Op BOP Clr R

MPOPBOP2R

  

BOH_QTY

Op BOP U

MPOPBOPU

  

BOHRGPRO_QTY

Op BOP Reg+Promo U

MPOPBOP1U

  

BOHCL_QTY

Op BOP Clr U

MPOPBOP2U

  

EOH_COST_AMT

Op EOP C

MPOPEOPC

  

EOHRGPRO_COST_AMT

Op EOP Reg+Promo C

MPOPEOP1C

Cost

EOHCL_COST_AMT

Op EOP Clr C

MPOPEOP2C

Cost

EOH_RTL_AMT

Op EOP R

MPOPEOPR

Retail

EOHRGPRO_RTL_AMT

Op EOP Reg+Promo R

MPOPEOP1R

Retail

EOHCL_RTL_AMT

Op EOP Clr R

MPOPEOP2R

Retail

EOH_QTY

Op EOP U

MPOPEOPU

  

EOHRGPRO_QTY

Op EOP Reg+Promo U

MPOPEOP1U

  

EOHCL_QTY

Op EOP Clr U

MPOPEOP2U

  

INVRC_COST_AMT

Op Receipts C

MPOPRcptC

  

INVRC_RTL_AMT

Op Receipts R

MPOPRcptR

  

INVRC_QTY

Op Receipts U

MPOPRcptU

  

INVADJ_COST_AMT

Op Inv Adj C

MPOPInvAdjC

  

INVADJ_RTL_AMT

Op Inv Adj R

MPOPInvAdjR

  

INVADJ_QTY

Op Inv Adj U

MPOPInvAdjU

  

SHRINK_COST_AMT

Op Shrink C

MPOPShrkC

  

SHRINK_RTL_AMT

Op Shrink R

MPOPShrkR

Retail

SHRINK_QTY

Op Shrink U

MPOPShrkU

  

MISCI_COST_AMT

Op Misc Adj C

MPOPMiscAdjC

Cost

MISCI_RTL_AMT

Op Misc Adj R

MPOPMiscAdjR

Retail

MISCI_QTY

Op Misc Adj U

MPOPMiscAdjU

  

MOVETOCL_COST_AMT

Op Move to Clr C

MPOPMOCC

Cost

MOVETOCL_RTL_AMT

Op Move to Clr R

MPOPMOCR

Retail

MOVETOCL_QTY

Op Move to Clr U

MPOPMOCU

  

MOS_COST_AMT

Op MOS C

MPOPMOSC

  

MOS_RTL_AMT

Op MOS R

MPOPMOSR

Retail

MOS_QTY

Op MOS U

MPOPMOSU

  

MKDNWF_RTL_AMT

Op Markdown POS due to W/F R

MPOPMkdWFR

  

RYLTY_RTL_AMT

Op Royalties R

MPOPRoyalR

  

VNDFND_RTL_AMT

Op Vendor Funds R

MPOPVndFndR

  

DMND_QTY

Op Demand U

MPOPDemandU

  

DMND_CAN_QTY

Op Cancel U

MPOPCancU

  

SLS_COMP_RTL_AMT

Op Comp Sales R

MPOPSlsCmpR

  

SLS_NCOMP_RTL_AMT

Op Non-Comp Sales R

MPOPSlsNCpR

  

TRAFFIC_CNT

Op Traffic U

MPOPTrafficU

  
OTB_COST_AMT Wp OTB C MPWPOTBC  
OTB_RTL_AMT Wp OTB R MPWPOTBR Retail
OTB_QTY Wp OTB U MPWPOTBU