Vehicle Fuel Consumption Report
Overview
This report has the main purpose of display all of the fuel consumptions registered for a vehicle.
Navigation
The Vehicle Fuel Consumption Report screen include the following fields:
Report Field | Description |
Fiscal year | Displays the current fiscal year |
Institution | Displays the institution’s name given by the attribute from institution table for the vehicle in the vehicle detail |
Vehicle Make | Display the related code to the Vehicle Maker entity |
Vehicle Model | Display the related code to the Vehicle Model entity |
Vehicle Line | Display the related code to the Vehicle Line entity next to the model code Example : Rav4 LXE (where rav4 is the model and LXE is the line) |
Responsible employee name | Display names for the referenced Employee |
Consumption status |
|
Fuel Type | Display the Fuel type short description. |
Vendor | Display the attribute name for the referenced vendor |
Vehicle usage description | Display only a short version of the found usage’s description and truncate always to 200 chars and add “…” The system must select the MIN Vehicle usage internal ID that matches the fuel consumption date with the following criteria: D1 = consumption date D2 = Usage started on date Vehicle Usage Registry for the vehicle id in this table Min internal usage registry ID where D1 > = D2 In case more than one is found, the system must select the MIN internal ID. |
Driver ID | The driver related to the USAGE GIVEN IN THIS TABLE |
Vehicle total consumption | Sum all of the details for the same vehicle that are included in all found Fuel consumption registry |
Institution Total consumption | Group by institution vehicle fuel consumptions and sum all of the Totals given |
Report Total Consumption | Sum all of the totals |