Gross Sales Mapping

A separate sales aggregate is also provided for Inventory Planning Optimization Cloud Service-Demand Forecasting (IPOCS-Demand Forecasting), which filters and aggregates the sales differently from the base extract for the other Planning applications. This export includes only gross sales and has a single set of measure columns with a separate field for the retail type (reg/pro/clr). The data is filtered to include only sales for non-warehouse locations. 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 Sales Units	W_PDS_GRS_SLS_IT_LC_WK_A	SALES_UNITS	W_RTL_SLS_IT_LC_WK_A.SLS_QTY + W_RTL_SLSPK_IT_LC_WK_A.SLSPK_QTY
Gross Sales Cost	W_PDS_GRS_SLS_IT_LC_WK_A	SALES_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 Sales Retail	W_PDS_GRS_SLS_IT_LC_WK_A	SALES_RETAIL	W_RTL_SLS_IT_LC_WK_A.SLS_AMT + W_RTL_SLSPK_IT_LC_WK_A.SLSPK_AMT
Gross Sales Tax	W_PDS_GRS_SLS_IT_LC_WK_A	SALES_TAX	W_RTL_SLS_IT_LC_WK_A.SLS_TAX_AMT + W_RTL_SLSPK_IT_LC_WK_A.SLSPK_TAX_AMT