| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP40: Inventory/OP Base |
| 1 | F41011 | Bulk Item Master | 2 | PK | PDGR | Product Group | String | UDC | 3 | 0 |
| TOP41: Inventory Management |
| 2 | F4101 | Item Master | 29 | IM | PDGR | Product Group | String | UDC | 3 | 0 |
| 3 | F4101A | Item File | 17 | IM | PDGR | Product Group | String | UDC | 3 | 0 |
| 4 | F4101B | Item Master Bulk Data | 9 | IM | PDGR | Product Group | String | UDC | 3 | 0 |
| 5 | F4101Z1 | F4101 Item Master Unedited Transaction Table | 44 | SZ | PDGR | Product Group | String | UDC | 3 | 0 |
| 6 | F4101Z1A | F4101 Detail Item Master Unedited Transaction | 40 | SZ | PDGR | Product Group | String | UDC | 3 | 0 |
| 7 | F4102 | Item Branch File | 26 | IB | PDGR | Product Group | String | UDC | 3 | 0 |
| TOP41B: Bulk Stock Management |
| 8 | F41505 | Allowed Products Matrix File | 7 | PO | PDGR | Product Group | String | UDC | 3 | 0 |
| TOP41F: Apparel Management |
| 9 | FCW59 | Bulk Item Master (F41011) Work File | 3 | WF | PDGR | Product Group | String | UDC | 3 | 0 |
| TOP47: Electronic Commerce |
| 10 | F47082 | EDI Price Sales Catalog Detail - Inbound | 43 | FY | PDGR | Product Group | String | UDC | 3 | 0 |
| TOPF30L: DFM Line Design |
| 11 | FF30L501 | DFM Item Definition Master | 29 | IB | PDGR | Product Group | String | UDC | 3 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 41B / PG (Product Group) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | Default | | N |
| 2 | AEF | Automotive Engine Fuel | | N |
| 3 | AVG | Aviation Gasolines | | N |
| 4 | AVT | Aviation Turbine Fuels (Jet) | | N |
| 5 | BLU | Bulk Lubricants | | N |
| 6 | DFO | Diesel Fuel Oil | | N |
| 7 | FO | Fuel Oil | | N |
| 8 | GFO | Gas Turbine Fuel Oil | | N |
| 9 | LIG | Liquified Gas (Inert) | | N |
| 10 | LPG | Liquified Petroleum Gases | | N |
| 11 | MAF | Marine Fuels | | N |
| 12 | MLO | Mineral Lubricating Oil | | N |
| 13 | PKL | Packaged Lubricants | | N |
