| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP34A: Advanced Planning & Scheduling |
1 | F34A40 | APS Integration Group Setup Table | 22 | N0 | PRP0 | Item Pool | String | UDC | 6 | 0 |
TOP41: Inventory Management |
2 | F4101 | Item Master | 27 | IM | PRP0 | Item Pool | String | UDC | 6 | 0 |
3 | F4101C | Item Category Codes | 29 | IM | PRP0 | Item Pool | String | UDC | 6 | 0 |
4 | F4101Z1 | F4101 Item Master Unedited Transaction Table | 42 | SZ | PRP0 | Item Pool | String | UDC | 6 | 0 |
5 | F4102 | Item Branch File | 24 | IB | PRP0 | Item Pool | String | UDC | 6 | 0 |
6 | F41UI001 | Inventory Transactions Detail File | 68 | IT | PRP0 | Item Pool | String | UDC | 6 | 0 |
TOP41F: Apparel Management |
7 | FCW08 | Category Codes Work File | 27 | WK | PRP0 | Item Pool | String | UDC | 6 | 0 |
8 | FCW10 | Item Branch Work File | 52 | WB | PRP0 | Item Pool | String | UDC | 6 | 0 |
9 | FCW96 | Material Analysis | 34 | WO | PRP0 | Item Pool | String | UDC | 6 | 0 |
10 | FCW97 | Grouping Messages | 34 | GM | PRP0 | Item Pool | String | UDC | 6 | 0 |
TOP47: Electronic Commerce |
11 | F47082 | EDI Price Sales Catalog Detail - Inbound | 41 | FY | PRP0 | Item Pool | String | UDC | 6 | 0 |
TOPF30L: DFM Line Design |
12 | FF30L501 | DFM Item Definition Master | 27 | IB | PRP0 | Item Pool | String | UDC | 6 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 41 / 05 (Item Category Code 05) stock values
| Value | Description | Special Handling Code | Hard Coded |
---|
1 | AFT | Aftercare | N | N |
2 | AIR | Air conditioner | N | N |
3 | BAR | Bathroom Radiators | N | N |
4 | DIH | District heating | N | N |
5 | FLU | Flue Pipes/Chimney | N | N |
6 | GBO | Gas Boilers | N | N |
7 | HEP | Heat Pumps | N | N |
8 | KIT | Kits | N | N |
9 | MAN | Manifold | N | N |
10 | MKT | Marketing Materials | N | N |
11 | OPT | Accessories | N | N |
12 | OTH | Others | N | N |
13 | RAD | Radiators | N | N |
14 | SER | Service | N | N |
15 | SOS | Solar Systems | N | N |
16 | SPP | Spare Parts | N | N |
17 | STT | Storage Tanks | N | N |
18 | THR | Thermoregulation | N | N |
19 | TRA | Training | N | N |
20 | UFH | Under floor heating pipe | N | N |
21 | WHE | Water Heaters | N | N |
22 | WOB | Wood Boilers | N | N |