v7 FreeBalance Help

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