| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP37: Quality Management |
1 | F37900 | Certificate of Analysis (COA) Extract | 69 | TR | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
TOP38: Agreement Management |
2 | F38111 | Agreements Transaction Ledger | 23 | DZ | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
TOP40: Inventory/OP Base |
3 | F49211 | Sales Order Detail File - Tag File | 5 | UD | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
4 | F49211Z1 | Sales Order Detail Tag Unedited Transaction File | 18 | S1 | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
5 | F49219 | Sales Order Detail - Tag History File | 5 | UD | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
TOP41B: Bulk Stock Management |
6 | F41511 | Bulk Product Transaction File | 72 | PA | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
TOP42: Sales Management |
7 | F42565 | Invoice Print File | 109 | IW | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
TOP42B: Sales Order Entry |
8 | F49299 | S.O. Detail Tag Ledger File | 5 | UD | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
TOP46: Warehouse Management |
9 | F4600 | Warehouse Requests | 92 | R1 | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
10 | F4600PU | Warehouse Requests - Purged | 92 | R1 | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
11 | F4600T | Warehouse Requests Tag File | 7 | R1 | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
12 | F4600TPU | Warehouse Requests Tag File - Purged | 7 | R1 | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
13 | F4611 | Warehouse Suggestions | 153 | R2 | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
14 | F4611PU | Warehouse Suggestions - Purged | 155 | R2 | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
15 | F4611T | Warehouse Suggestions Tag File | 7 | R2 | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
16 | F4611TPU | Warehouse Suggestions Tag File - Purged | 7 | R2 | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
17 | F46200 | Bulk Pick Requests | 28 | BR | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
18 | F46200PU | Bulk Pick Requests - Purged | 28 | BR | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
TOP49: Transportation Management |
19 | F490052 | Generate Tracking Segment Next Number | 2 | YG | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
20 | F4902 | Vehicle Current Load | 4 | TV | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
21 | F49130 | Shipment Document Workfile | 6 | BW | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
22 | F49170 | Load Next Numbers | 1 | NN | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
23 | F4918 | Load Tender History | 1 | LT | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
24 | F49197 | Depot Document Print Set Up (Conversion from World File) | 1 | OQ | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
25 | F49198 | Depot Document Print Setup | 1 | OQ | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
26 | F49380 | Seal Numbers | 3 | SU | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
27 | F4941 | Shipment Routing Steps | 12 | RS | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
28 | F4944 | Shipment/Load Options and Equipment | 3 | OE | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
29 | F4945 | Shipment Charges | 3 | SC | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
30 | F49490 | Document Selection | 6 | TQ | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
31 | F4957 | Transportation Confirmed Batch Shipment | 2 | BC | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
32 | F49591 | Document Print - Batch Selection | 5 | DB | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
33 | F49594 | Document Print - Document Detail | 24 | DI | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
34 | F4960 | Load Header | 1 | TM | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
35 | F4961 | Load Legs | 1 | LL | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
36 | F49611 | Load Stop Sequence | 1 | LD | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
37 | F49612 | Load Vehicles | 1 | TD | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
38 | F49614 | Load Staff | 1 | TS | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
39 | F4962 | Load Compartments | 1 | TE | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
40 | F49621 | Load Compartment Detail | 1 | TD | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
41 | F4963 | Load In-transit | 1 | TI | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
42 | F49631 | Load In-transit Ledger | 5 | TO | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
43 | F49632 | Load In-transit Left on Board | 1 | LB | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
44 | F49633 | Load In-Transit Confirmed Quantities | 2 | IQ | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
45 | F49696 | Document Register Detail | 9 | DJ | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
46 | F49697 | Document Register Summary | 9 | DN | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
47 | F49721 | Spot Quote Detail | 4 | QS | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
48 | F4981 | Freight Audit History | 4 | FH | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |
TOPD3N: dcLINK (data collection) - DSI |
49 | FD3N4950 | dcLINK Delivery Confirmation Work File | 2 | DC | VMCU | Depot - Trip | String | Generic Edit | 12 | 0 |