Sales Mapping
Data for sales is loaded from the SALES.csv file or from RMFCS (Sales Audit). The primary data warehouse
table is the week-level aggregate generated by the historical and daily load processes. All data mappings in this area are
split out by retail type. Any measure having reg/pro/clr in the name are being filtered on that retail type
code as part of the export. When you provide input data to RAP, you specify the retail type code as R, P, or C, and those values are used here to determine the output. A custom 4th option
(using type code O for Other) is also allowed, as long as you extend the W_XACT_TYPE_D dimension
in the data warehouse to have the extra type code. Other sales are only included in the Total Sales measures in the PDS export.
The data only includes non-pack item sales, as it expects pack sales to be spread to their component level when used.
| Measure | Target Table | Target Column | Data Source |
|---|---|---|---|
|
Gross Reg Sales Units |
W_PDS_SLS_IT_LC_WK_A |
SALES_REG_UNITS |
W_RTL_SLS_IT_LC_WK_A.SLS_QTY + W_RTL_SLSPK_IT_LC_WK_A.SLSPK_QTY |
|
Gross Pro Sales Units |
W_PDS_SLS_IT_LC_WK_A |
SALES_PRO_UNITS |
W_RTL_SLS_IT_LC_WK_A.SLS_QTY + W_RTL_SLSPK_IT_LC_WK_A.SLSPK_QTY |
|
Gross Clr Sales Units |
W_PDS_SLS_IT_LC_WK_A |
SALES_CLR_UNITS |
W_RTL_SLS_IT_LC_WK_A.SLS_QTY + W_RTL_SLSPK_IT_LC_WK_A.SLSPK_QTY |
|
Gross Reg Sales Cost |
W_PDS_SLS_IT_LC_WK_A |
SALES_REG_COST |
(W_RTL_SLS_IT_LC_WK_A.SLS_AMT-SLS_PROFIT_AMT) + (W_RTL_SLSPK_IT_LC_WK_A.SLSPK_AMT-SLSPK_PROF_AMT) |
|
Gross Pro Sales Cost |
W_PDS_SLS_IT_LC_WK_A |
SALES_PRO_COST |
(W_RTL_SLS_IT_LC_WK_A.SLS_AMT-SLS_PROFIT_AMT) + (W_RTL_SLSPK_IT_LC_WK_A.SLSPK_AMT-SLSPK_PROF_AMT) |
|
Gross Clr Sales Cost |
W_PDS_SLS_IT_LC_WK_A |
SALES_CLR_COST |
(W_RTL_SLS_IT_LC_WK_A.SLS_AMT-SLS_PROFIT_AMT) + (W_RTL_SLSPK_IT_LC_WK_A.SLSPK_AMT-SLSPK_PROF_AMT) |
|
Gross Reg Sales Retail |
W_PDS_SLS_IT_LC_WK_A |
SALES_REG_RETAIL |
W_RTL_SLS_IT_LC_WK_A.SLS_AMT + W_RTL_SLSPK_IT_LC_WK_A.SLSPK_AMT |
|
Gross Pro Sales Retail |
W_PDS_SLS_IT_LC_WK_A |
SALES_PRO_RETAIL |
W_RTL_SLS_IT_LC_WK_A.SLS_AMT + W_RTL_SLSPK_IT_LC_WK_A.SLSPK_AMT |
|
Gross Clr Sales Retail |
W_PDS_SLS_IT_LC_WK_A |
SALES_CLR_RETAIL |
W_RTL_SLS_IT_LC_WK_A.SLS_AMT + W_RTL_SLSPK_IT_LC_WK_A.SLSPK_AMT |
|
Gross Reg Sales Tax |
W_PDS_SLS_IT_LC_WK_A |
SALES_REG_TAX |
W_RTL_SLS_IT_LC_WK_A.SLS_TAX_AMT + W_RTL_SLSPK_IT_LC_WK_A.SLSPK_TAX_AMT |
|
Gross Pro Sales Tax |
W_PDS_SLS_IT_LC_WK_A |
SALES_PRO_TAX |
W_RTL_SLS_IT_LC_WK_A.SLS_TAX_AMT + W_RTL_SLSPK_IT_LC_WK_A.SLSPK_TAX_AMT |
|
Gross Clr Sales Tax |
W_PDS_SLS_IT_LC_WK_A |
SALES_CLR_TAX |
W_RTL_SLS_IT_LC_WK_A.SLS_TAX_AMT + W_RTL_SLSPK_IT_LC_WK_A.SLSPK_TAX_AMT |
|
Net Reg Sales Units |
W_PDS_SLS_IT_LC_WK_A |
NET_SALES_REG_UNITS |
(W_RTL_SLS_IT_LC_WK_A.SLS_QTY-RET_QTY) + (W_RTL_SLSPK_IT_LC_WK_A.SLSPK_QTY-RETPK_QTY) |
|
Net Pro Sales Units |
W_PDS_SLS_IT_LC_WK_A |
NET_SALES_PRO_UNITS |
(W_RTL_SLS_IT_LC_WK_A.SLS_QTY-RET_QTY) + (W_RTL_SLSPK_IT_LC_WK_A.SLSPK_QTY-RETPK_QTY) |
|
Net Clr Sales Units |
W_PDS_SLS_IT_LC_WK_A |
NET_SALES_CLR_UNITS |
(W_RTL_SLS_IT_LC_WK_A.SLS_QTY-RET_QTY) + (W_RTL_SLSPK_IT_LC_WK_A.SLSPK_QTY-RETPK_QTY) |
|
Net Reg Sales Cost |
W_PDS_SLS_IT_LC_WK_A |
NET_SALES_REG_COST |
(W_RTL_SLS_IT_LC_WK_A.SLS_AMT-RET_AMT) - (W_RTL_SLS_IT_LC_WK_A.SLS_PROFIT_AMT-RET_PROFIT_AMT) + (W_RTL_SLSPK_IT_LC_WK_A.SLSPK_AMT-RETPK_AMT) - (W_RTL_SLSPK_IT_LC_WK_A.SLSPK_PROF_AMT-RETPK_PROF_AMT) |
|
Net Pro Sales Cost |
W_PDS_SLS_IT_LC_WK_A |
NET_SALES_PRO_COST |
(W_RTL_SLS_IT_LC_WK_A.SLS_AMT-RET_AMT) - (W_RTL_SLS_IT_LC_WK_A.SLS_PROFIT_AMT-RET_PROFIT_AMT) + (W_RTL_SLSPK_IT_LC_WK_A.SLSPK_AMT-RETPK_AMT) - (W_RTL_SLSPK_IT_LC_WK_A.SLSPK_PROF_AMT-RETPK_PROF_AMT) |
|
Net Clr Sales Cost |
W_PDS_SLS_IT_LC_WK_A |
NET_SALES_CLR_COST |
(W_RTL_SLS_IT_LC_WK_A.SLS_AMT-RET_AMT) - (W_RTL_SLS_IT_LC_WK_A.SLS_PROFIT_AMT-RET_PROFIT_AMT) + (W_RTL_SLSPK_IT_LC_WK_A.SLSPK_AMT-RETPK_AMT) - (W_RTL_SLSPK_IT_LC_WK_A.SLSPK_PROF_AMT-RETPK_PROF_AMT) |
|
Net Reg Sales Retail |
W_PDS_SLS_IT_LC_WK_A |
NET_SALES_REG_RETAIL |
(W_RTL_SLS_IT_LC_WK_A.SLS_AMT-RET_AMT) + (W_RTL_SLSPK_IT_LC_WK_A.SLSPK_AMT-RETPK_AMT) |
|
Net Pro Sales Retail |
W_PDS_SLS_IT_LC_WK_A |
NET_SALES_PRO_RETAIL |
(W_RTL_SLS_IT_LC_WK_A.SLS_AMT-RET_AMT) + (W_RTL_SLSPK_IT_LC_WK_A.SLSPK_AMT-RETPK_AMT) |
|
Net Clr Sales Retail |
W_PDS_SLS_IT_LC_WK_A |
NET_SALES_CLR_RETAIL |
(W_RTL_SLS_IT_LC_WK_A.SLS_AMT-RET_AMT) + (W_RTL_SLSPK_IT_LC_WK_A.SLSPK_AMT-RETPK_AMT) |
|
Net Reg Sales Retail Excluding VAT |
W_PDS_SLS_IT_LC_WK_A |
NET_SALES_REG_RETAIL_VAT_EXCL |
(W_RTL_SLS_IT_LC_WK_A.SLS_AMT-RET_AMT) - (W_RTL_SLS_IT_LC_WK_A.SLS_TAX_AMT-RET_TAX_AMT) + (W_RTL_SLSPK_IT_LC_WK_A.SLSPK_AMT-RETPK_AMT) - (W_RTL_SLSPK_IT_LC_WK_A.SLSPK_TAX_AMT-RETPK_TAX_AMT) |
|
Net Pro Sales Retail Excluding VAT |
W_PDS_SLS_IT_LC_WK_A |
NET_SALES_PRO_RETAIL_VAT_EXCL |
(W_RTL_SLS_IT_LC_WK_A.SLS_AMT-RET_AMT) - (W_RTL_SLS_IT_LC_WK_A.SLS_TAX_AMT-RET_TAX_AMT) + (W_RTL_SLSPK_IT_LC_WK_A.SLSPK_AMT-RETPK_AMT) - (W_RTL_SLSPK_IT_LC_WK_A.SLSPK_TAX_AMT-RETPK_TAX_AMT) |
|
Net Clr Sales Retail Excluding VAT |
W_PDS_SLS_IT_LC_WK_A |
NET_SALES_CLR_RETAIL_VAT_EXCL |
(W_RTL_SLS_IT_LC_WK_A.SLS_AMT-RET_AMT) - (W_RTL_SLS_IT_LC_WK_A.SLS_TAX_AMT-RET_TAX_AMT) +(W_RTL_SLSPK_IT_LC_WK_A.SLSPK_AMT-RETPK_AMT) - (W_RTL_SLSPK_IT_LC_WK_A.SLSPK_TAX_AMT-RETPK_TAX_AMT) |
|
Net Reg Sales Tax |
W_PDS_SLS_IT_LC_WK_A |
NET_SALES_REG_TAX |
(W_RTL_SLS_IT_LC_WK_A.SLS_TAX_AMT-RET_TAX_AMT) + (W_RTL_SLSPK_IT_LC_WK_A.SLSPK_TAX_AMT-RETPK_TAX_AMT) |
|
Net Pro Sales Tax |
W_PDS_SLS_IT_LC_WK_A |
NET_SALES_PRO_TAX |
(W_RTL_SLS_IT_LC_WK_A.SLS_TAX_AMT-RET_TAX_AMT) + (W_RTL_SLSPK_IT_LC_WK_A.SLSPK_TAX_AMT-RETPK_TAX_AMT) |
|
Net Clr Sales Tax |
W_PDS_SLS_IT_LC_WK_A |
NET_SALES_CLR_TAX |
(W_RTL_SLS_IT_LC_WK_A.SLS_TAX_AMT-RET_TAX_AMT) + (W_RTL_SLSPK_IT_LC_WK_A.SLSPK_TAX_AMT-RETPK_TAX_AMT) |
|
Returns Reg Units |
W_PDS_SLS_IT_LC_WK_A |
RETURNS_REG_UNITS |
W_RTL_SLS_IT_LC_WK_A.RET_QTY + W_RTL_SLSPK_IT_LC_WK_A.RETPK_QTY |
|
Returns Pro Units |
W_PDS_SLS_IT_LC_WK_A |
RETURNS_PRO_UNITS |
W_RTL_SLS_IT_LC_WK_A.RET_QTY + W_RTL_SLSPK_IT_LC_WK_A.RETPK_QTY |
|
Returns Clr Units |
W_PDS_SLS_IT_LC_WK_A |
RETURNS_CLR_UNITS |
W_RTL_SLS_IT_LC_WK_A.RET_QTY + W_RTL_SLSPK_IT_LC_WK_A.RETPK_QTY |
|
Returns Reg Cost |
W_PDS_SLS_IT_LC_WK_A |
RETURNS_REG_COST |
(W_RTL_SLS_IT_LC_WK_A.RET_AMT-RET_PROFIT_AMT) + (W_RTL_SLSPK_IT_LC_WK_A.RETPK_AMT-RETPK_PROF_AMT) |
|
Returns Pro Cost |
W_PDS_SLS_IT_LC_WK_A |
RETURNS_PRO_COST |
(W_RTL_SLS_IT_LC_WK_A.RET_AMT-RET_PROFIT_AMT) + (W_RTL_SLSPK_IT_LC_WK_A.RETPK_AMT-RETPK_PROF_AMT) |
|
Returns Clr Cost |
W_PDS_SLS_IT_LC_WK_A |
RETURNS_CLR_COST |
(W_RTL_SLS_IT_LC_WK_A.RET_AMT-RET_PROFIT_AMT) + (W_RTL_SLSPK_IT_LC_WK_A.RETPK_AMT-RETPK_PROF_AMT) |
|
Returns Reg Retail |
W_PDS_SLS_IT_LC_WK_A |
RETURNS_REG_RETAIL |
W_RTL_SLS_IT_LC_WK_A.RET_AMT + W_RTL_SLSPK_IT_LC_WK_A.RETPK_AMT |
|
Returns Pro Retail |
W_PDS_SLS_IT_LC_WK_A |
RETURNS_PRO_RETAIL |
W_RTL_SLS_IT_LC_WK_A.RET_AMT + W_RTL_SLSPK_IT_LC_WK_A.RETPK_AMT |
|
Returns Clr Retail |
W_PDS_SLS_IT_LC_WK_A |
RETURNS_CLR_RETAIL |
W_RTL_SLS_IT_LC_WK_A.RET_AMT + W_RTL_SLSPK_IT_LC_WK_A.RETPK_AMT |
|
Returns Reg Tax |
W_PDS_SLS_IT_LC_WK_A |
RETURNS_REG_TAX |
W_RTL_SLS_IT_LC_WK_A.RET_TAX_AMT + W_RTL_SLSPK_IT_LC_WK_A.RETPK_TAX_AMT |
|
Returns Pro Tax |
W_PDS_SLS_IT_LC_WK_A |
RETURNS_PRO_TAX |
W_RTL_SLS_IT_LC_WK_A.RET_TAX_AMT + W_RTL_SLSPK_IT_LC_WK_A.RETPK_TAX_AMT |
|
Returns Clr Tax |
W_PDS_SLS_IT_LC_WK_A |
RETURNS_CLR_TAX |
W_RTL_SLS_IT_LC_WK_A.RET_TAX_AMT + W_RTL_SLSPK_IT_LC_WK_A.RETPK_TAX_AMT |
|
Total Gross Sales Units |
W_PDS_SLS_IT_LC_WK_A |
SALES_TOTAL_UNITS |
W_RTL_SLS_IT_LC_WK_A.SLS_QTY + W_RTL_SLSPK_IT_LC_WK_A.SLSPK_QTY |
|
Total Gross Sales Cost |
W_PDS_SLS_IT_LC_WK_A |
SALES_TOTAL_COST |
(W_RTL_SLS_IT_LC_WK_A.SLS_AMT-SLS_PROFIT_AMT) + (W_RTL_SLSPK_IT_LC_WK_A.SLSPK_AMT-SLSPK_PROF_AMT) |
|
Total Gross Sales Retail |
W_PDS_SLS_IT_LC_WK_A |
SALES_TOTAL_RETAIL |
W_RTL_SLS_IT_LC_WK_A.SLS_AMT + W_RTL_SLSPK_IT_LC_WK_A.SLSPK_AMT |
|
Total Gross Sales Tax |
W_PDS_SLS_IT_LC_WK_A |
SALES_TOTAL_TAX |
W_RTL_SLS_IT_LC_WK_A.SLS_TAX_AMT + W_RTL_SLSPK_IT_LC_WK_A.SLSPK_TAX_AMT |
|
Total Net Sales Units |
W_PDS_SLS_IT_LC_WK_A |
NET_SALES_TOTAL_UNITS |
(W_RTL_SLS_IT_LC_WK_A.SLS_QTY-RET_QTY) + (W_RTL_SLSPK_IT_LC_WK_A.SLSPK_QTY-RETPK_QTY) |
|
Total Net Sales Cost |
W_PDS_SLS_IT_LC_WK_A |
NET_SALES_TOTAL_COST |
(W_RTL_SLS_IT_LC_WK_A.SLS_AMT-RET_AMT) - (W_RTL_SLS_IT_LC_WK_A.SLS_PROFIT_AMT-RET_PROFIT_AMT) + (W_RTL_SLSPK_IT_LC_WK_A.SLSPK_AMT-RETPK_AMT) - (W_RTL_SLSPK_IT_LC_WK_A.SLSPK_PROF_AMT-RETPK_PROF_AMT) |
|
Total Net Sales Retail |
W_PDS_SLS_IT_LC_WK_A |
NET_SALES_TOTAL_RETAIL |
(W_RTL_SLS_IT_LC_WK_A.SLS_AMT-RET_AMT) + (W_RTL_SLSPK_IT_LC_WK_A.SLSPK_AMT-RETPK_AMT) |
|
Total Net Sales Tax |
W_PDS_SLS_IT_LC_WK_A |
NET_SALES_TOTAL_TAX |
(W_RTL_SLS_IT_LC_WK_A.SLS_TAX_AMT-RET_TAX_AMT) + (W_RTL_SLSPK_IT_LC_WK_A.SLSPK_TAX_AMT-RETPK_TAX_AMT) |
|
Custom Measures 1 - 20 |
W_PDS_SLS_IT_LC_WK_A |
FLEX1_NUM_VALUE through FLEX20_NUM_VALUE |
W_RTL_ SLS_IT_LC_WK_A.FLEX1_NUM_VALUE through W_RTL_SLS_IT_LC_WK_A.FLEX20_NUM_VALUE |