Deal Income Mapping
Data is loaded from the DEAL_INCOME.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 |
---|---|---|---|
Deal Income Sales Based |
W_PDS_DEALINC_IT_LC_WK_A |
DEAL_INCOME_SALES |
W_RTL_DEALINC_IT_LC_WK_A.DEAL_SLS_COST_AMT |
Deal Income Purchases Based |
W_PDS_DEALINC_IT_LC_WK_A |
DEAL_INCOME_PURCHASES |
W_RTL_DEALINC_IT_LC_WK_A.DEAL_PRCH_COST_AMT |
Custom Measures 1 - 20 |
W_PDS_ DEALINC_IT_LC_WK_A |
FLEX1_NUM_VALUE through FLEX20_NUM_VALUE |
W_RTL_ DEALINC_IT_LC_WK_A.FLEX1_NUM_VALUE through W_RTL_ DEALINC_IT_LC_WK_A.FLEX20_NUM_VALUE |