Plan Level 6 MFP_PLAN6_EXP - LPO Export

This plan export is for LPO Integration of Markdown Budgets. This is an optional export only available if LPO Integration is enabled. This process exports the Permanent Markdown data for the current week after aggregating it for the number of weeks set up in the LPO Aggregate Weeks at the Sub-Class/Store level.

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

PROD_KEY

Product Dimension

SLCS

 

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

MLCPLDOWD

 

VERSION_NUM

Version Number

1

 
PROD_LEVEL Product Level SBC  

LOC_LEVEL

Location Level

LOCATION

 

MKDNPM_RTL_AMT

Cp Markdown Perm R

MLCPInvDVR

 
FLEX1_NUM_VALUE LPO Aggregate Weeks ADHDLPOSprl