| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP31B: Blend Management |
1 | F31B96 | Bill Of Lading Details | 8 | BD | VEHI | Vehicle ID | String | Generic Edit | 12 | 0 |
TOP37: Quality Management |
2 | F3711 | Test Results | 68 | TR | VEHI | Vehicle ID | String | Generic Edit | 12 | 0 |
3 | F3711Z1 | Test Results Unedited Transaction Table | 81 | SZ | VEHI | Vehicle ID | String | Generic Edit | 12 | 0 |
4 | F37900 | Certificate of Analysis (COA) Extract | 68 | TR | VEHI | Vehicle ID | String | Generic Edit | 12 | 0 |
TOP38: Agreement Management |
5 | F38111 | Agreements Transaction Ledger | 22 | DZ | VEHI | Vehicle ID | String | Generic Edit | 12 | 0 |
TOP41B: Bulk Stock Management |
6 | F41509 | Four-Point Analysis Maintenance File | 11 | PG | VEHI | Vehicle ID | String | Generic Edit | 12 | 0 |
7 | F41511 | Bulk Product Transaction File | 71 | PA | VEHI | Vehicle ID | String | Generic Edit | 12 | 0 |
TOP49: Transportation Management |
8 | F49010 | Vehicle Master (Conversion from World File) | 2 | VM | VEHI | Vehicle ID | String | Generic Edit | 12 | 0 |
9 | F49012 | Vehicle Compartments (Conversion from World File) | 1 | VO | VEHI | Vehicle ID | String | Generic Edit | 12 | 0 |
10 | F49015 | Vehicle Status | 1 | ST | VEHI | Vehicle ID | String | Generic Edit | 12 | 0 |
11 | F4902 | Vehicle Current Load | 1 | TV | VEHI | Vehicle ID | String | Generic Edit | 12 | 0 |
12 | F49020 | Vehicle/Staff License Information | 1 | VL | VEHI | Vehicle ID | String | Generic Edit | 12 | 0 |
13 | F49025 | Connected Vehicles (Conversion from World File) | 9 | CV | VEHI | Vehicle ID | String | Generic Edit | 12 | 0 |
14 | F49030 | Vehicle Equipment (Conversion from World File) | 1 | VE | VEHI | Vehicle ID | String | Generic Edit | 12 | 0 |
15 | F49040 | Vehicle Staff (Conversion from World File) | 1 | VS | VEHI | Vehicle ID | String | Generic Edit | 12 | 0 |
16 | F49041 | Depot/Vehicle Staff | 5 | VS | VEHI | Vehicle ID | String | Generic Edit | 12 | 0 |
17 | F4930 | Vehicle Master | 1 | VM | VEHI | Vehicle ID | String | Generic Edit | 12 | 0 |
18 | F49301 | Vehicle Compartments | 1 | VO | VEHI | Vehicle ID | String | Generic Edit | 12 | 0 |
19 | F49302 | Vehicle Equipment | 1 | VE | VEHI | Vehicle ID | String | Generic Edit | 12 | 0 |
20 | F4936 | Connected Vehicle Detail | 4 | CW | VEHI | Vehicle ID | String | Generic Edit | 12 | 0 |
21 | F49612 | Load Vehicles | 4 | TD | VEHI | Vehicle ID | String | Generic Edit | 12 | 0 |
22 | F49631 | Load In-transit Ledger | 10 | TO | VEHI | Vehicle ID | String | Generic Edit | 12 | 0 |
23 | F49632 | Load In-transit Left on Board | 7 | LB | VEHI | Vehicle ID | String | Generic Edit | 12 | 0 |