| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPConsumption-Based Planning See Also PP-MRP |
1 | MAHD | Alternative Required Time Series for the Forecast | 5 | ERTAG | First day of the period to which the values refer | nvarchar | 8 | 0 | | |
2 | MAHD_OVAL | Original Values for Alternative RPM Time Series for Forecast | 5 | ERTAG | First day of the period to which the values refer | nvarchar | 8 | 0 | | |
3 | WAHD | Alternative Required Time Series for the Forecast | 5 | ERTAG | First day of the period to which the values refer | nvarchar | 8 | 0 | | |
4 | WAHD_OVAL | Original Values for Alternative RPM Time Series for Forecast | 5 | ERTAG | First day of the period to which the values refer | nvarchar | 8 | 0 | | |
5 | WFCS_WRFT | Movement Data for Store Forecasts | 4 | ERTAG | First Day of Period | nvarchar | 8 | 0 | | |
TOPForecast |
6 | PROW | Forecast Values | 3 | ERTAG | First day of the period to which the values refer | nvarchar | 8 | 0 | | |
TOPMaterial Master |
7 | MPRW_TMP | File for Incorrect Data in Direct Input | 7 | ERTAG | First day of the period to which the values refer | nvarchar | 8 | 0 | | |
8 | MVEG_TMP | File for Incorrect Data in Direct Input | 7 | ERTAG | First day of the period to which the values refer | nvarchar | 8 | 0 | | |
9 | MVEU_TMP | File for Incorrect Data in Direct Input | 7 | ERTAG | First day of the period to which the values refer | nvarchar | 8 | 0 | | |
TOPPerishables Procurement |
10 | FIP_D_FORECAST | Buffer table for daily forecast values | 4 | ERTAG | The Date on which the forecast values is refering to | nvarchar | 8 | 0 | | |
TOPSales Plan |
11 | PROH | Basic Values (for Forecast): Consumption or Actual Number | 3 | ERTAG | First day of the period to which the values refer | nvarchar | 8 | 0 | | |