Field Name | Attribute | Picture | Start Position | Size | Description |
Trip Id | Numeric | 9 | 1 | 9 | EnergyTrack Trip ID |
Seq Number | Numeric | 2 | 11 | 2 | Import sequence number per trip |
Transaction Date | Date | MM/DD/YY | 14 | 8 | Date of load or unload |
Transaction Time | Time | HH:MM | 23 | 5 | Time of load or unload |
Driver Id | Numeric | 4 | 32 | 4 | Driver Number |
Truck Division Number | Numeric | 4 | 40 | 4 | Truck Division Number |
Truck Id | Numeric | 6 | 50 | 6 | Truck Number |
Transfer Type | Alpha | 1 | 58 | 1 | L – Load, U – Unload |
Storage Division Number | Numeric | 4 | 61 | 4 | Division number (defaulted to 0) |
Storage Location | Numeric | 4 | 70 | 4 | Storage Location Number |
Storage Id | Numeric | 3 | 81 | 6 | Storage Tank ID |
Gallons | Numeric | 6.1 | 92 | 8 | Gallons loaded/unloaded |
Department Number | Numeric | 4 | 103 | 6 | Department number associated with storage tank |
BOL | Alpha | 10 | 110 | 10 | Bill of Lading number (not used at this time) |
Created Date | Date | MM/DD/YYYY | 120 | 10 | Date imported into Energy Force |
Created Time | Time | HH:MM | 131 | 5 | Time imported into Energy Force |
Export Date | Date | MM/DD/YYYY | 142 | 10 | Date exported to accounting system (Interface folder) |
Export Time | Time | HH:MM | 154 | 5 | Time exported to accounting system (Interface folder) |