| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP40: Inventory/OP Base |
| 1 | F41011 | Bulk Item Master | 3 | PK | DSGP | Dispatch Group | String | UDC | 3 | 0 |
| 2 | F49211 | Sales Order Detail File - Tag File | 8 | UD | DSGP | Dispatch Group | String | UDC | 3 | 0 |
| 3 | F49211Z1 | Sales Order Detail Tag Unedited Transaction File | 21 | S1 | DSGP | Dispatch Group | String | UDC | 3 | 0 |
| 4 | F49219 | Sales Order Detail - Tag History File | 8 | UD | DSGP | Dispatch Group | String | UDC | 3 | 0 |
| TOP41: Inventory Management |
| 5 | F4101 | Item Master | 30 | IM | DSGP | Dispatch Group | String | UDC | 3 | 0 |
| 6 | F4101A | Item File | 18 | IM | DSGP | Dispatch Group | String | UDC | 3 | 0 |
| 7 | F4101B | Item Master Bulk Data | 10 | IM | DSGP | Dispatch Group | String | UDC | 3 | 0 |
| 8 | F4101Z1 | F4101 Item Master Unedited Transaction Table | 45 | SZ | DSGP | Dispatch Group | String | UDC | 3 | 0 |
| 9 | F4101Z1A | F4101 Detail Item Master Unedited Transaction | 41 | SZ | DSGP | Dispatch Group | String | UDC | 3 | 0 |
| 10 | F4102 | Item Branch File | 27 | IB | DSGP | Dispatch Group | String | UDC | 3 | 0 |
| TOP42: Sales Management |
| 11 | F42UI11 | SO Detail Cache File (MBF) | 139 | ZD | DSGP | Dispatch Group | String | UDC | 3 | 0 |
| TOP42B: Sales Order Entry |
| 12 | F49299 | S.O. Detail Tag Ledger File | 8 | UD | DSGP | Dispatch Group | String | UDC | 3 | 0 |
| TOP47: Electronic Commerce |
| 13 | F47082 | EDI Price Sales Catalog Detail - Inbound | 44 | FY | DSGP | Dispatch Group | String | UDC | 3 | 0 |
| TOP49: Transportation Management |
| 14 | F49010 | Vehicle Master (Conversion from World File) | 19 | VM | DSGP | Dispatch Group | String | UDC | 3 | 0 |
| 15 | F4931 | Vehicle Type | 5 | VG | DSGP | Dispatch Group | String | UDC | 3 | 0 |
| 16 | F4935 | Connected Vehicle Header | 8 | VH | DSGP | Dispatch Group | String | UDC | 3 | 0 |
| 17 | F4942 | Shipment Detail | 16 | IS | DSGP | Dispatch Group | String | UDC | 3 | 0 |
| 18 | F4945 | Shipment Charges | 11 | SC | DSGP | Dispatch Group | String | UDC | 3 | 0 |
| 19 | F4960 | Load Header | 37 | TM | DSGP | Dispatch Group | String | UDC | 3 | 0 |
| 20 | F49634 | Load In-Transit Confirmed Quantities Detail | 13 | QD | DSGP | Dispatch Group | String | UDC | 3 | 0 |
| 21 | F4972 | Rate Detail | 8 | RX | DSGP | Dispatch Group | String | UDC | 3 | 0 |
| 22 | F4981 | Freight Audit History | 9 | FH | DSGP | Dispatch Group | String | UDC | 3 | 0 |
| TOPF30L: DFM Line Design |
| 23 | FF30L501 | DFM Item Definition Master | 30 | IB | DSGP | Dispatch 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.
