Plan Level 4 MFP_PLAN4_EXP - Location Target Plan Export
This plan export is for exporting the Tgt version of approved Location 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 |
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 |
LTTGLDOWD |
|
|
VERSION_NUM |
Version Number |
0 |
|
|
SLS_QTY |
Tgt Sales U |
LTTGSlsU |
|
|
SLS_RTL_AMT |
Tgt Sales R |
LTTGSlsR |
|
|
RET_QTY |
Tgt Returns U |
LTTGRtnU |
|
|
RET_RTL_AMT |
Tgt Returns R |
LTTGRtnR |
|
|
MKDNPR_RTL_AMT |
Tgt Markdown POS R |
LTTGMkdR |
Retail |