| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP38: Agreement Management |
1 | F38111 | Agreements Transaction Ledger | 40 | DZ | DTPU | Temperature Type | Character | UDC | 1 | 0 |
TOP40: Inventory/OP Base |
2 | F41011 | Bulk Item Master | 13 | PK | DTPU | Temperature Type | Character | UDC | 1 | 0 |
3 | F41508 | Default Tank Information | 11 | PC | DTPU | Temperature Type | Character | UDC | 1 | 0 |
4 | F49211 | Sales Order Detail File - Tag File | 30 | UD | DTPU | Temperature Type | Character | UDC | 1 | 0 |
5 | F49211Z1 | Sales Order Detail Tag Unedited Transaction File | 43 | S1 | DTPU | Temperature Type | Character | UDC | 1 | 0 |
6 | F49219 | Sales Order Detail - Tag History File | 30 | UD | DTPU | Temperature Type | Character | UDC | 1 | 0 |
TOP41: Inventory Management |
7 | F4101B | Item Master Bulk Data | 20 | IM | DTPU | Temperature Type | Character | UDC | 1 | 0 |
8 | F4101Z1A | F4101 Detail Item Master Unedited Transaction | 51 | SZ | DTPU | Temperature Type | Character | UDC | 1 | 0 |
TOP41B: Bulk Stock Management |
9 | F415091 | Four-Point Temperature Maintenance | 11 | PG | DTPU | Temperature Type | Character | UDC | 1 | 0 |
10 | F41511 | Bulk Product Transaction File | 23 | PA | DTPU | Temperature Type | Character | UDC | 1 | 0 |
11 | F41515 | Multi-Meter Readings | 38 | PQ | DTPU | Temperature Type | Character | UDC | 1 | 0 |
TOP42: Sales Management |
12 | F42565 | Invoice Print File | 94 | IW | DTPU | Temperature Type | Character | UDC | 1 | 0 |
TOP42B: Sales Order Entry |
13 | F49299 | S.O. Detail Tag Ledger File | 30 | UD | DTPU | Temperature Type | Character | UDC | 1 | 0 |
TOP43: Procurement |
14 | F43121Z | Receiver workfile | 115 | PW | DTPU | Temperature Type | Character | UDC | 1 | 0 |
15 | F43121Z1 | Receipts Unedited Transaction Table | 135 | SZ | DTPU | Temperature Type | Character | UDC | 1 | 0 |
TOP49: Transportation Management |
16 | F49110 | Transportation Bill of Lading Workfile | 50 | BW | DTPU | Temperature Type | Character | UDC | 1 | 0 |
17 | F4963 | Load In-transit | 22 | TI | DTPU | Temperature Type | Character | UDC | 1 | 0 |
18 | F49631 | Load In-transit Ledger | 48 | TO | DTPU | Temperature Type | Character | UDC | 1 | 0 |
19 | F49632 | Load In-transit Left on Board | 30 | LB | DTPU | Temperature Type | Character | UDC | 1 | 0 |
TOP76A: Argentina |
20 | F76A0219 | Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A | 36 | DL | DTPU | Temperature Type | Character | UDC | 1 | 0 |
21 | F76A021P | Detail Lines Inv./ShipmentNote History WF Purge - ARG - 76A | 36 | DL | DTPU | Temperature Type | Character | UDC | 1 | 0 |
22 | F76AUI21 | Detail Lines Invoice/ShipmentNote Workfile - ARG - 00 - 00 | 36 | DL | DTPU | Temperature Type | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.