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

Report Field

Description

Serial Number

the report must generate a correlative/total (see mockup) number for each printed vehicle in its corresponding grouping institution

Responsible Position

Display the position linked to the employee, look for the employee assignment linked to the employee that has: the max assignment ID, and the actual end date is null or is greater than system current date at reporting generation time.

Earning Scale

the cost item scale level is related to the generic position

Position Category

display the short description linked to the generic position

January amount

Group and sum the total cost for the vehicle in the comply with the following:

• date belong to the corresponding month (fiscal period)
• the status is “Delivered by Supplier"

February amount

same as above

March amount

same as above

May amount

same as above

June amount

same as above

July amount

same as above

August amount

same as above

September amount

same as above

October amount

same as above

November amount

same as above

December amount

same as above

Total of report

In case a single ministry (top level institution level) is displayed hide this row.

Report Field

Description

Institution Type

Display the parent institution if applicable

Vehicle ID

Display the unique ID of the vehicle.

Make

Display the make code linked to the vehicle.

Model

display the model code

Sub model

display the line code

Current odometer value

Display the odometer value plus the odometer measure type abbreviation

for example: 20,000.00 (Km)

Original cost

domestic cost

Current Value

current value of vehicle

total cost (fuel types)

Sum all cost of vehicle registered fuel consumptions (group by vehicle)

Insurance cost

displays the total cost of the insurance for the vehicle (group by vehicle)

Maintenance expenses

Sum of all of the maintenance for a specific vehicle Grouped by vehicle.

Report totals

Sum all columns amounts.

Currency symbol

Display the currency symbol for the selected as domestic currency.

Fiscal year

Display the id for the current active fiscal year

User

Display the user ID of the user that is generating the report.

Report Field

Description

Fiscal Period

Display the period short name

Parent Institution

Parent institution Name

Institution

Displays the Institution

Vehicle Plates Number

Display the attribute

Vehicle Make

display the vehicle maker's code related to the attribute

Vehicle Model

display the vehicle model code related to the attribute