Markdown Mapping
Data is loaded from the MARKDOWN.csv file or from RMFCS. The primary data warehouse table is the week-level
aggregate generated by the historical load process.
| Measure | Target Table | Target Column | Data Source |
|---|---|---|---|
|
Regular Markdown |
W_PDS_MKDN_IT_LC_WK_A |
REG_MARKDOWN_RETAIL |
W_RTL_MKDN_IT_LC_WK_A.MKDN_AMT where retail type = R |
|
Promotion Markdown (Regular) |
W_PDS_MKDN_IT_LC_WK_A |
PROMO_MARKDOWN_RETAIL_REG |
W_RTL_MKDN_IT_LC_WK_A.MKDN_AMT where retail type = P and CLEARANCE_FLG = N |
|
Promotion Markdown (Clearance) |
W_PDS_MKDN_IT_LC_WK_A |
PROMO_MARKDOWN_RETAIL_CLEAR |
W_RTL_MKDN_IT_LC_WK_A.MKDN_AMT where retail type = P and CLEARANCE_FLG = Y |
|
Clearance Markdown |
W_PDS_MKDN_IT_LC_WK_A |
CLEAR_MARKDOWN_RETAIL |
W_RTL_MKDN_IT_LC_WK_A.MKDN_AMT where retail type = C |
|
Markup |
W_PDS_MKDN_IT_LC_WK_A |
MARKUP |
W_RTL_MKDN_IT_LC_WK_A.MKUP_AMT where retail type = R |
|
Markup Cancel |
W_PDS_MKDN_IT_LC_WK_A |
MARKUP_CANCEL |
W_RTL_MKDN_IT_LC_WK_A.MKUP_CAN_AMT |
|
Markdown Cancel |
W_PDS_MKDN_IT_LC_WK_A |
MARKDOWN_CANCEL |
W_RTL_MKDN_IT_LC_WK_A.MKDN_CAN_AMT |
|
Intercompany Markup |
W_PDS_MKDN_IT_LC_WK_A |
INTERCOMPANY_MARKUP |
W_RTL_MKDN_IT_LC_WK_A.MKUP_AMT where retail type = I |
|
Intercompany Markdown |
W_PDS_MKDN_IT_LC_WK_A |
INTERCOMPANY_MARKDOWN |
W_RTL_MKDN_IT_LC_WK_A.MKDN_AMT where retail type = I |
|
Custom Measures 1 - 20 |
W_PDS_ MKDN_IT_LC_WK_A |
FLEX1_NUM_VALUE through FLEX20_NUM_VALUE |
W_RTL_ MKDN_IT_LC_WK_A.FLEX1_NUM_VALUE through W_RTL_ MKDN_IT_LC_WK_A.FLEX20_NUM_VALUE |