...
Column | Column | Name | Description | Data Type | Length | Required | Validated |
1 | A | Plant Code | Plant Code | Text | 20 | -1 | Yes |
2 | B | Make | Make | Text | 50 | 0 |
|
3 | C | Model | Model | Text | 50 | 0 |
|
4 | D | Registration | Registration | Text | 20 | 0 |
|
5 | E | Road User Type | Road User Type | Text | 20 | 0 |
|
6 | F | Road User Class | Road user Class | Text | 20 | 0 |
|
7 | G | Speedo | Speedo | Integer | Null | 0 |
|
8 | H | Hubo Meter Reg | Hubo Meter Reg | Text | 20 | 0 |
|
9 | I | Hour Meter Reg | Hour Meter Reg | Text | 20 | 0 |
|
10 | J | Hubo KM | Hubo KM | Integer | Null | 0 |
|
11 | K | Total Hours | Total Hours | Integer | Null | 0 |
|
12 | L | Radio Make | Radio Make | Text | 20 | 0 |
|
13 | M | Radio Model | Radio Model | Text | 20 | 0 |
|
14 | N | Radio Security Code | Radio Security Code | Text | 20 | 0 |
|
15 | O | Towbar Cert | Towbar Cert | Text | 20 | 0 |
|
16 | P | Alarmed | Alarmed -1 = Yes, 0 = No | Integer | Integer 05 | 0 |
|
17 | Q | VIN | VIN | Text | 20 | 0 |
|
18 | R | Chassis No | Chassis No | Text | 20 | 0 |
|
19 | S | Engine | Engine | Text | 20 | 0 |
|
20 | T | Weight | Weight | Text | 20 | 0 |
|
21 | U | Transmission | Transmission | Text | 20 | 0 |
|
22 | V | Tyre Size | Tyre Size | Text | 10 | 0 |
|
23 | W | Warranty | Warranty | Text | 10 | 0 |
|
24 | X | Key No | Key No | Text | 10 | 0 |
|
25 | Y | Air Con | Air Con -1 = Yes, 0 = No | Integer | Integer 06 | 0 |
|
26 | Z | Fuel | Fuel | Text | 10 | 0 |
|
27 | AA | Cab | Cab | Text | 10 | 0 |
|
28 | AB | Chassis Type | Chassis Type | Text | 20 | 0 |
|
29 | AC | Colour | Colour | Text | 20 | 0 |
|
30 | AD | Fuel Card No | Fuel Card Number | Text | 20 | 0 |
|
31 | AE | Purchase Value | Purchase Value | Number | Null | 0 |
|
32 | AF | Supplier | Supplier ID Number | Integer | Null | 0 | Yes |
33 | AG | Sale Date | Sale Date | Date | Null | 0 |
|
34 | AH | Sale Value | Sale Value | Number | Null | 0 |
|
35 | AI | Group Code | Plant Group Code | Text | 20 | 0 | Yes |
36 | AJ | Location | Plant Location | Text | 20 | 0 | Yes |
37 | AK | Drive Type | Drive Type | Text | 20 | 0 |
|
38 | AL | Driver | Driver Full Name | Text | 50 | 0 | Yes |
39 | AM | Team | Team | Text | 20 | 0 |
|
40 | AN | Date Pur | Date Pur | Date | Null | 0 |
|
41 | AO | Fleet No | Fleet No | Text | 20 | 0 |
|
42 | AP | Serial No | Serial No | Text | 80 | 0 |
|
43 | AQ | Manufacture Date | Manufacture Date | Date | Null | 0 |
|
44 | AR | Plant Class Code | Plant Class Code | Text | 10 | 0 |
|
45 | AS | Hourly Rate | Hourly Rate | Number | Null | -1 | Yes |
Notes:
Plant Group Code; Plant Location; Driver; Plant Class were initially imported in the Plant Import. They can be null in this import but where populated they will overwrite the initial import
...