| 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 |
TOP41F: Apparel Management |
11 | FCW09 | Item Revisions Work File | 31 | WR | DSGP | Dispatch Group | String | UDC | 3 | 0 |
TOP42: Sales Management |
12 | F42UI11 | SO Detail Cache File (MBF) | 139 | ZD | DSGP | Dispatch Group | String | UDC | 3 | 0 |
TOP42B: Sales Order Entry |
13 | F49299 | S.O. Detail Tag Ledger File | 8 | UD | DSGP | Dispatch Group | String | UDC | 3 | 0 |
TOP47: Electronic Commerce |
14 | F47082 | EDI Price Sales Catalog Detail - Inbound | 44 | FY | DSGP | Dispatch Group | String | UDC | 3 | 0 |
TOP49: Transportation Management |
15 | F49010 | Vehicle Master (Conversion from World File) | 19 | VM | DSGP | Dispatch Group | String | UDC | 3 | 0 |
16 | F4931 | Vehicle Type | 5 | VG | DSGP | Dispatch Group | String | UDC | 3 | 0 |
17 | F4935 | Connected Vehicle Header | 8 | VH | DSGP | Dispatch Group | String | UDC | 3 | 0 |
18 | F4942 | Shipment Detail | 16 | IS | DSGP | Dispatch Group | String | UDC | 3 | 0 |
19 | F4945 | Shipment Charges | 11 | SC | DSGP | Dispatch Group | String | UDC | 3 | 0 |
20 | F4960 | Load Header | 37 | TM | DSGP | Dispatch Group | String | UDC | 3 | 0 |
21 | F49634 | Load In-Transit Confirmed Quantities Detail | 13 | QD | DSGP | Dispatch Group | String | UDC | 3 | 0 |
22 | F4972 | Rate Detail | 8 | RX | DSGP | Dispatch Group | String | UDC | 3 | 0 |
23 | F4981 | Freight Audit History | 9 | FH | DSGP | Dispatch Group | String | UDC | 3 | 0 |
TOPF30L: DFM Line Design |
24 | 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.