| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP40: Inventory/OP Base |
1 | F40330 | Preference Profile - Document Set | 19 | DG | BPFG | Bulk/Packed Flag | Character | UDC | 1 | 0 |
2 | F4215 | Shipment Header | 25 | XH | BPFG | Bulk/Packed Flag | Character | UDC | 1 | 0 |
3 | F49211 | Sales Order Detail File - Tag File | 9 | UD | BPFG | Bulk/Packed Flag | Character | UDC | 1 | 0 |
4 | F49211Z1 | Sales Order Detail Tag Unedited Transaction File | 22 | S1 | BPFG | Bulk/Packed Flag | Character | UDC | 1 | 0 |
5 | F49219 | Sales Order Detail - Tag History File | 9 | UD | BPFG | Bulk/Packed Flag | Character | UDC | 1 | 0 |
TOP41: Inventory Management |
6 | F4101 | Item Master | 61 | IM | BPFG | Bulk/Packed Flag | Character | UDC | 1 | 0 |
7 | F4101A | Item File | 40 | IM | BPFG | Bulk/Packed Flag | Character | UDC | 1 | 0 |
8 | F4101Z1 | F4101 Item Master Unedited Transaction Table | 76 | SZ | BPFG | Bulk/Packed Flag | Character | UDC | 1 | 0 |
9 | F41UI001 | Inventory Transactions Detail File | 205 | IT | BPFG | Bulk/Packed Flag | Character | UDC | 1 | 0 |
TOP41F: Apparel Management |
10 | FCW09 | Item Revisions Work File | 11 | WR | BPFG | Bulk/Packed Flag | Character | UDC | 1 | 0 |
TOP42: Sales Management |
11 | F42UI11 | SO Detail Cache File (MBF) | 140 | ZD | BPFG | Bulk/Packed Flag | Character | UDC | 1 | 0 |
TOP42B: Sales Order Entry |
12 | F49299 | S.O. Detail Tag Ledger File | 9 | UD | BPFG | Bulk/Packed Flag | Character | UDC | 1 | 0 |
TOP43: Procurement |
13 | F43121Z | Receiver workfile | 125 | PW | BPFG | Bulk/Packed Flag | Character | UDC | 1 | 0 |
TOP49: Transportation Management |
14 | F49301 | Vehicle Compartments | 8 | VO | BPFG | Bulk/Packed Flag | Character | UDC | 1 | 0 |
15 | F4931 | Vehicle Type | 35 | VG | BPFG | Bulk/Packed Flag | Character | UDC | 1 | 0 |
16 | F4962 | Load Compartments | 8 | TE | BPFG | Bulk/Packed Flag | Character | UDC | 1 | 0 |
17 | F4963 | Load In-transit | 26 | TI | BPFG | Bulk/Packed Flag | Character | UDC | 1 | 0 |
TOP75I: India |
18 | F75I380 | Excise - RG-1 - Transaction File - IND | 8 | RG | BPFG | Bulk/Packed Flag | Character | UDC | 1 | 0 |
19 | F75I701 | Bill of Entry - Header | 82 | QH | BPFG | Bulk/Packed Flag | Character | UDC | 1 | 0 |
TOP76A: Argentina |
20 | F76A0219 | Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A | 40 | DL | BPFG | Bulk/Packed Flag | Character | UDC | 1 | 0 |
21 | F76A021P | Detail Lines Inv./ShipmentNote History WF Purge - ARG - 76A | 40 | DL | BPFG | Bulk/Packed Flag | Character | UDC | 1 | 0 |
22 | F76AUI21 | Detail Lines Invoice/ShipmentNote Workfile - ARG - 03 - 76A | 40 | DL | BPFG | Bulk/Packed Flag | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.