Plan Level 2 MFP_PLAN2_EXP - Merch Target Plan Export
This plan export is for exporting the Tgt version of approved Merch Target Plans. VERSION_NUM 0 is used to export the Target version.
| Staging Table Column | Description | MFP Dimension/Measure Mapping | Retail/Cost |
|---|---|---|---|
|
PROD_KEY |
Product Dimension |
dept |
|
|
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 |
MTTGLDOWD |
|
|
VERSION_NUM |
Version Number |
0 |
|
|
SLS_QTY |
Tgt Sales U |
MTTGSlsU |
|
|
SLSCL_QTY |
Tgt Sales Clr U |
MTTGSls2U |
Retail |
|
SLSRGPRO_QTY |
Tgt Sales Reg+Promo U |
MTTGSls1U |
Retail |
|
SLS_RTL_AMT |
Tgt Sales R |
MTTGSlsR |
|
|
SLSCL_RTL_AMT |
Tgt Sales Clr R |
MTTGSls2R |
Retail |
|
SLSRGPRO_RTL_AMT |
Tgt Sales Reg+Promo R |
MTTGSls1R |
Retail |
|
SLS_COST_AMT |
Tgt Sales C |
MTTGSlsC |
|
|
RET_QTY |
Tgt Returns U |
MTTGRtnU |
|
|
RETCL_QTY |
Tgt Returns Clr U |
MTTGRtn2U |
|
|
RETRGPRO_QTY |
Tgt Returns Reg+Promo U |
MTTGRtn1U |
|
|
RET_RTL_AMT |
Tgt Returns R |
MTTGRtnR |
|
|
RETCL_RTL_AMT |
Tgt Returns Clr R |
MTTGRtn2R |
|
|
RETRGPRO_RTL_AMT |
Tgt Returns Reg+Promo R |
MTTGRtn1R |
|
|
NET_SLSRGPRO_QTY |
Tgt Net Sales Reg+Promo U |
MTTGNSls1U |
|
|
NET_SLSCL_QTY |
Tgt Net Sales Clr U |
MTTGNSls2U |
|
|
NET_SLSRGPRO_RTL_AMT |
Tgt Net Sales Reg+Promo R |
MTTGNSls1R |
|
|
NET_SLSCL_RTL_AMT |
Tgt Net Sales Clr R |
MTTGNSls2R |
|
|
NET_MARGIN_RTL_AMT |
Tgt Net GM R |
MTTGNGMR |
|
|
TAX_RTL_AMT |
Tgt VAT R |
MTTGVATR |
|
|
SLSTE_RTL_AMT |
Tgt Net Sales R |
MTTGNSlsR |
|
|
MARGIN_RTL_AMT |
Tgt GM R |
MTTGGMR |
|
|
MKDNPM_RTL_AMT |
Tgt Markdown Perm Reg+Promo R |
MTTGInvDV1R |
|
|
MKDNCL_RTL_AMT |
Tgt Markdown Perm Clr R |
MTTGInvDV2R |
|
|
MKDNPR_RTL_AMT |
Tgt Markdown POS R |
MTTGMkdR |
|
|
BOH_COST_AMT |
Tgt BOP C |
MTTGBOPC |
|
|
BOH_RTL_AMT |
Tgt BOP R |
MTTGBOPR |
|
|
BOHRGPRO_RTL_AMT |
Tgt BOP Reg+Promo R |
MTTGBOP1R |
|
|
BOHCL_RTL_AMT |
Tgt BOP Clr R |
MTTGBOP2R |
|
|
BOH_QTY |
Tgt BOP U |
MTTGBOPU |
|
|
BOHRGPRO_QTY |
Tgt BOP Reg+Promo U |
MTTGBOP1U |
|
|
BOHCL_QTY |
Tgt BOP Clr U |
MTTGBOP2U |
|
|
EOH_COST_AMT |
Tgt EOP C |
MTTGEOPC |
|
|
EOHRGPRO_COST_AMT |
Tgt EOP Reg+Promo C |
MTTGEOP1C |
|
|
EOHCL_COST_AMT |
Tgt EOP Clr C |
MTTGEOP2C |
|
|
EOH_RTL_AMT |
Tgt EOP R |
MTTGEOPR |
|
|
EOHRGPRO_RTL_AMT |
Tgt EOP Reg+Promo R |
MTTGEOP1R |
|
|
EOHCL_RTL_AMT |
Tgt EOP Clr R |
MTTGEOP2R |
|
|
EOH_QTY |
Tgt EOP U |
MTTGEOPU |
|
|
EOHRGPRO_QTY |
Tgt EOP Reg+Promo U |
MTTGEOP1U |
|
|
EOHCL_QTY |
Tgt EOP Clr U |
MTTGEOP2U |
|
|
INVRC_COST_AMT |
Tgt Receipts C |
MTTGRcptC |
|
|
INVRC_RTL_AMT |
Tgt Receipts R |
MTTGRcptR |
|
|
INVRC_QTY |
Tgt Receipts U |
MTTGRcptU |
|
|
INVADJ_COST_AMT |
Tgt Inv Adj C |
MTTGInvAdjC |
|
|
INVADJ_RTL_AMT |
Tgt Inv Adj R |
MTTGInvAdjR |
Retail |
|
INVADJ_QTY |
Tgt Inv Adj U |
MTTGInvAdjU |
|
|
SHRINK_COST_AMT |
Tgt Shrink C |
MTTGShrkC |
|
|
SHRINK_RTL_AMT |
Tgt Shrink R |
MTTGShrkR |
Retail |
|
SHRINK_QTY |
Tgt Shrink U |
MTTGShrkU |
|
|
MISCI_COST_AMT |
Tgt Misc Adj C |
MTTGMiscAdjC |
|
|
MISCI_RTL_AMT |
Tgt Misc Adj R |
MTTGMiscAdjR |
Retail |
|
MISCI_QTY |
Tgt Misc Adj U |
MTTGMiscAdjU |
|
|
MOVETOCL_COST_AMT |
Tgt Move to Clr C |
MTTGMOCC |
|
|
MOVETOCL_RTL_AMT |
Tgt Move to Clr R |
MTTGMOCR |
Retail |
|
MOVETOCL_QTY |
Tgt Move to Clr U |
MTTGMOCU |
|
|
MOS_COST_AMT |
Tgt MOS C |
MTTGMOSC |
|
|
MOS_RTL_AMT |
Tgt MOS R |
MTTGMOSR |
Retail |
|
MOS_QTY |
Tgt MOS U |
MTTGMOSU |
|
|
MKDNWF_RTL_AMT |
Tgt Markdown POS due to W/F R |
MTTGMkdWFR |
|
|
RYLTY_RTL_AMT |
Tgt Royalties R |
MTTGRoyalR |
|
|
VNDFND_RTL_AMT |
Tgt Vendor Funds R |
MTTGVndFndR |
|
|
DMND_QTY |
Tgt Demand U |
MTTGDemandU |
|
|
DMND_CAN_QTY |
Tgt Cancel U |
MTTGCancU |
|
|
SLS_COMP_RTL_AMT |
Tgt Comp Sales R |
MTTGSlsCmpR |
|
|
SLS_NCOMP_RTL_AMT |
Tgt Non-Comp Sales R |
MTTGSlsNCpR |
|
|
TRAFFIC_CNT |
Tgt Traffic U |
MTTGTrafficU |
|
| OTB_COST_AMT | Wp OTB C | MTWPOTBC | |
| OTB_RTL_AMT | Wp OTB R | MTWPOTBR | Retail |
| OTB_QTY | Wp OTB U | MTWPOTBU |