Wholesale/Franchise Mapping
Data is loaded from the SALES_WF.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 |
|---|---|---|---|
|
Franchise Sales Units |
W_PDS_SLSWF_IT_LC_WK_A |
FRANCHISE_SALES_UNITS |
W_RTL_SLSWF_IT_LC_WK_A.SLSWF_QTY |
|
Franchise Sales Cost |
W_PDS_SLSWF_IT_LC_WK_A |
FRANCHISE_SALES_COST |
W_RTL_SLSWF_IT_LC_WK_A.SLSWF_ACQ_COST_AMT |
|
Franchise Sales Retail |
W_PDS_SLSWF_IT_LC_WK_A |
FRANCHISE_SALES_RETAIL |
W_RTL_SLSWF_IT_LC_WK_A.SLSWF_AMT |
|
Franchise Sales Tax |
W_PDS_SLSWF_IT_LC_WK_A |
FRANCHISE_SALES_TAX |
W_RTL_SLSWF_IT_LC_WK_A.SLSWF_TAX_AMT |
|
Franchise Returns Units |
W_PDS_SLSWF_IT_LC_WK_A |
FRANCHISE_RETURNS_UNITS |
W_RTL_SLSWF_IT_LC_WK_A.RETWF_QTY |
|
Franchise Returns Cost |
W_PDS_SLSWF_IT_LC_WK_A |
FRANCHISE_RETURNS_COST |
W_RTL_SLSWF_IT_LC_WK_A.RETWF_ACQ_COST_AMT |
|
Franchise Returns Retail |
W_PDS_SLSWF_IT_LC_WK_A |
FRANCHISE_RETURNS_RETAIL |
W_RTL_SLSWF_IT_LC_WK_A.RETWF_AMT |
|
Franchise Returns Tax |
W_PDS_SLSWF_IT_LC_WK_A |
FRANCHISE_RETURNS_TAX |
W_RTL_SLSWF_IT_LC_WK_A.RETWF_TAX_AMT |
|
Franchise Restocking Fee |
W_PDS_SLSWF_IT_LC_WK_A |
FRANCHISE_RESTOCK_FEE |
W_RTL_SLSWF_IT_LC_WK_A.RETWF_RSTK_FEE_AMT |
|
Franchise Markdown |
W_PDS_SLSWF_IT_LC_WK_A |
WF_MARKDOWN_RETAIL |
W_RTL_SLSWF_IT_LC_WK_A.SLSWF_MKDN_AMT - RETWF_MKDN_AMT |
|
Franchise Markup |
W_PDS_SLSWF_IT_LC_WK_A |
WF_MARKUP_RETAIL |
W_RTL_SLSWF_IT_LC_WK_A.SLSWF_MKUP_AMT - RETWF_MKUP_AMT |