| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP43: Procurement |
1 | F4311 | Purchase Order Detail File | 208 | PD | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
2 | F4311Z1 | Purchase Order Detail Unedited Transaction Table | 211 | SZ | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
3 | F43121 | Purchase Order Receiver File | 137 | PR | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
4 | F43121Z1 | Receipts Unedited Transaction Table | 186 | SZ | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
5 | F43199 | P.O. Detail Ledger File - Flexible Version | 210 | OL | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
TOP46: Warehouse Management |
6 | F4600 | Warehouse Requests | 91 | R1 | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
7 | F4600PU | Warehouse Requests - Purged | 90 | R1 | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
8 | F4600T | Warehouse Requests Tag File | 6 | R1 | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
9 | F4600TPU | Warehouse Requests Tag File - Purged | 6 | R1 | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
10 | F4611 | Warehouse Suggestions | 152 | R2 | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
11 | F4611PU | Warehouse Suggestions - Purged | 153 | R2 | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
12 | F4611T | Warehouse Suggestions Tag File | 6 | R2 | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
13 | F4611TPU | Warehouse Suggestions Tag File - Purged | 6 | R2 | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
14 | F46200 | Bulk Pick Requests | 29 | BR | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
15 | F46200PU | Bulk Pick Requests - Purged | 29 | BR | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
TOP47: Electronic Commerce |
16 | F47017 | EDI Purchase Order Detail - Outbound | 220 | SZ | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
17 | F47022 | EDI P.O. Acknowledgment Detail - Inbound | 220 | SZ | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
18 | F47032 | EDI Shipping Notice Detail - Inbound | 157 | SZ | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
19 | F470371 | EDI Shipping Notice Detail - Outbound | 154 | SZ | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
20 | F47072 | EDI Receiving Advice Detail - Inbound | 250 | SZ | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
21 | F47077 | EDI Receiving Advice Detail - Outbound | 206 | SZ | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
22 | F47097 | EDI Request for Quote Detail - Outbound | 220 | SZ | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
23 | F47102 | EDI Response to RFQ Detail - Inbound | 220 | SZ | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
24 | F47142 | EDI P.O. Change Acknowledgment Detail - Inbound | 222 | SZ | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
25 | F47157 | EDI Shipping Schedule Detail - Outbound | 127 | SZ | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
TOP49: Transportation Management |
26 | F49130 | Shipment Document Workfile | 7 | BW | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
27 | F4918 | Load Tender History | 2 | LT | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
28 | F49380 | Seal Numbers | 4 | SU | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
29 | F4941 | Shipment Routing Steps | 13 | RS | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
30 | F4944 | Shipment/Load Options and Equipment | 4 | OE | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
31 | F4945 | Shipment Charges | 4 | SC | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
32 | F49490 | Document Selection | 7 | TQ | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
33 | F4957 | Transportation Confirmed Batch Shipment | 3 | BC | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
34 | F49591 | Document Print - Batch Selection | 7 | DB | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
35 | F49594 | Document Print - Document Detail | 25 | DI | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
36 | F4960 | Load Header | 2 | TM | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
37 | F4961 | Load Legs | 2 | LL | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
38 | F49611 | Load Stop Sequence | 2 | LD | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
39 | F49612 | Load Vehicles | 2 | TD | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
40 | F49614 | Load Staff | 2 | TS | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
41 | F4962 | Load Compartments | 2 | TE | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
42 | F49621 | Load Compartment Detail | 2 | TD | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
43 | F4963 | Load In-transit | 2 | TI | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
44 | F49631 | Load In-transit Ledger | 6 | TO | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
45 | F49632 | Load In-transit Left on Board | 2 | LB | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
46 | F49633 | Load In-Transit Confirmed Quantities | 1 | IQ | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
47 | F49696 | Document Register Detail | 10 | DJ | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
48 | F49697 | Document Register Summary | 11 | DN | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
49 | F49721 | Spot Quote Detail | 5 | QS | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
50 | F4981 | Freight Audit History | 5 | FH | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
TOP76A: Argentina |
51 | F76A0209 | Header and Footer Invoice/ShipmentNote History WF - ARG - 76A | 64 | HF | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
52 | F76A020P | Header/Footer Inv./ShipmentNote History WF Purge - AR - 76A | 64 | HF | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
53 | F76AUI20 | Header and Footer Invoice/ShipmentNote Workfile - ARG - - 00 | 64 | HF | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
TOPD3N: dcLINK (data collection) - DSI |
54 | FD3N0001 | dcLINK Xpress Check Out | 9 | ZZ | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |
55 | FD3N4950 | dcLINK Delivery Confirmation Work File | 1 | DC | LDNM | Load Number | Numeric | Generic Edit | 8 | 0 |