VehicleFuelDetails
Name: Vehicle Fuel Details
Type: Application
Modules: OPS-Yard
Description: Contains data regarding vehicles' fuelling details.
| Field | Documentation |
|---|---|
| VehicleId | Vehicle identifier from Vehicles.VehicleId. References the associated vehicle. |
| LDate | Date when the record is valid. |
| Sequence | Number used when ordering records during a data query. |
| AccountNo | Account number. |
| UserString1 | Client supplementary data. |
| UserString2 | Client supplementary data. |
| GasCard | Gas card account number that was used during the purchase. |
| InvoiceDate | Date of the invoice. |
| Odometer | Vehicle's odometer reading in meters at the time of purchase. |
| FuelDescription | Description of the fuel that was purchased. |
| FuelType | Type of fuel that was purchased (e.g., 'DIESEL'). |
| Litres | Amount of fuel purchased, in litres. |
| FuelRate | Cost of the fuel at the time of purchase ($/Litre). |
| Gallons | Amount of fuel purchased, in gallons. |
| NetCost | Cost of the fuel itself, without taxes. |
| Taxes | Amount of taxes paid. |
| TotalCost | Total cost of the fuel (NetCost + Taxes). |
| ReferenceText | References a record or document associated with this record. |
| UserString3 | Client supplementary data. |
| UserString4 | Client supplementary data. |
| UserString5 | Client supplementary data. |
| InvoiceNumber | Invoice number. |
| TransactionSource | Source from which the record was pulled from. |
| ModBy | User who last modified the record. |
| ModDate | Date the record was last modified. |
| ModTime | Time the record was last modified. Value is in seconds from midnight. |
| ModAction | Last action performed on the record. |