Plan Level 3 MFP_PLAN3_EXP - Location Plan Export

This plan export is for exporting both the OP and CP versions of approved Location 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	DEPT
LOC_KEY	Location Dimension	STOR
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	LPOPLDOWD
VERSION_NUM	Version Number	0
SLS_QTY	Op Sales U	LPOPSlsU
SLSCL_QTY	Op Sales Clr U	LPOPSls2U
SLS_RTL_AMT	Op Sales R	LPOPSlsR
SLSCL_RTL_AMT	Op Sales Clr R	LPOPSls2R
SLS_COST_AMT	Op Sales C	LPOPSlsC
RET_QTY	Op Returns U	LPOPRtnU
RETCL_QTY	Op Returns Clr U	LPOPRtn2U
RET_RTL_AMT	Op Returns R	LPOPRtnR
TAX_RTL_AMT	Op VAT R	LPOPVATR
SLSTE_RTL_AMT	Op Net Sales R	LPOPNSlsR
MARGIN_RTL_AMT	Op GM R	LPOPGMR
MKDNPM_RTL_AMT	Op Markdown Perm Reg+Promo R	LPOPInvDVR
MKDNPR_RTL_AMT	Op Markdown POS R	LPOPMkdR
BOH_COST_AMT	Op BOP C	LPOPBOPC
BOH_RTL_AMT	Op BOP R	LPOPBOPR	Retail
BOH_QTY	Op BOP U	LPOPBOPU
EOH_COST_AMT	Op EOP C	LPOPEOPC
EOH_RTL_AMT	Op EOP R	LPOPEOPR	Retail
EOH_QTY	Op EOP U	LPOPEOPU
INVRC_COST_AMT	Op Receipts C	LPOPRcptC
INVRC_RTL_AMT	Op Receipts R	LPOPRcptR	Retail
INVRC_QTY	Op Receipts U	LPOPRcptU
INVADJ_QTY	Op Inv Adj U	LPOPInvAdjU
SHRINK_COST_AMT	Op Shrink C	LPOPShrkC
SHRINK_RTL_AMT	Op Shrink R	LPOPShrkR	Retail
SHRINK_QTY	Op Shrink U	LPOPShrkU
MKDNWF_RTL_AMT	Op Markdown POS due to W/F R	LPOPMkdWFR
OTB_COST_AMT	Wp OTB C	LPWPOTBC
OTB_RTL_AMT	Wp OTB R	LPWPOTBR	Retail
OTB_QTY	Wp OTB U	LPWPOTBU