| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP13: Plant/Equipment Management |
1 | F13411 | PM Projections | 3 | RX | TYPF | Forecast Type | String | UDC | 2 | 0 |
TOP34: Requirements Planning |
2 | F34006 | Forecast Summary Work File | 3 | SJ | TYPF | Forecast Type | String | UDC | 2 | 0 |
3 | F3460 | Forecast File | 11 | MF | TYPF | Forecast Type | String | UDC | 2 | 0 |
TOP36: Forecasting |
4 | F3400 | Forecast Summary File | 2 | SG | TYPF | Forecast Type | String | UDC | 2 | 0 |
5 | F34007 | Forecast Prices | 4 | FH | TYPF | Forecast Type | String | UDC | 2 | 0 |
6 | F3460Z1 | Forecast Unedited Transactions | 24 | FT | TYPF | Forecast Type | String | UDC | 2 | 0 |
TOP47: Electronic Commerce |
7 | F47062 | EDI Planning Schedule Detail - Inbound | 27 | MY | TYPF | Forecast Type | String | UDC | 2 | 0 |
8 | F47067 | EDI Planning Schedule Detail - Outbound | 27 | MY | TYPF | Forecast Type | String | UDC | 2 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 34 / DF (Forecast Type) stock values
| Value | Description | Special Handling Code | Hard Coded |
---|
1 | 01 | Simple Percent Over Last Year | | N |
2 | 02 | Calculated % Over Last Year | | N |
3 | 03 | Last Year to This Year | | N |
4 | 04 | Moving Average | | N |
5 | 05 | Linear Approximation | | N |
6 | 06 | Least Squares Regression | | N |
7 | 07 | 2nd Order Approximation | | N |
8 | 08 | Flexible Method | | N |
9 | 09 | Weighted Moving Average | | N |
10 | 10 | Linear Smoothing | | N |
11 | 11 | Exponential Smoothing | | N |
12 | 12 | Exponential Smoothing w/Trend | | N |
13 | AA | Actual Sales | | N |
14 | BF | Best Simulated Forecast | | N |
15 | DD | Demand Spreading | | Y |
16 | FC | Forecast Consumption Forecast | | N |
17 | MF | Maintenance Forecast | | N |
18 | MM | Maintenance Management | | |
19 | MP | Multi-Plant Forecast | | N |
20 | NX | Numetrix | | N |
21 | PP | Production Plan | | |
22 | SA | Annual Sales Plan | | N |