Custom Sales Type

The SALES.csv file has transaction data differentiated with a Retail Type (RTL_TYPE_CODE) field. By default, this accepts only R, P, or C as the types. You may extend this with a 4^th custom type called Other (using type code O). To do this, you must first load a custom file into the W_XACT_TYPE_D interface to add the additional sales type code (standalone POM jobs are available for this table load). Once that is done, you may include the 4^th type code on records in SALES.csv. The additional sales type will be exported to PDS in two different ways:

1. The MFP sales interface (W_PDS_SLS_IT_LC_WK_A) has a set of fields for Total Sales, which will be inclusive of Other sales. This allows you to have the default measures for Reg, Pro, and Clr sales and custom non-GA measures for Total Sales (which will not be equal to R+P+C sales). You could use total sales measures minus the other types to arrive at values specifically for Other sales or any other combination of retail types.

2. The IPOCS-Demand Forecasting sales interface (W_PDS_GRS_SLS_IT_LC_WK_A) will maintain the separate rows for other sales on the output since that interface has the retail type code on it directly. You may define custom measures to load the Other sales into IPOCS-Demand Forecasting.