ID

Auto assigned by the system.

Single Vehicle Consumption

Indicates if the consumption to be entered is only for a single vehicle.

Default value = True.

When True allow to select by doing look up a vehicle.

Vehicle ID

Allow the user to select a vehicle by making a look up to vehicles.

Comment

Description of the consumption.

Include Fuel Coupons

Indicates if the consumption will assign Coupons Numbers.

When true values

Coupon Type

Indicates the coupon type used for assign/consumption of the fuel to be registered in this record.

Coupon From

Allow the user to enter any number.

Coupon To

Allow the user to enter any number.

Fully used Coupons

Indicates the total of Details that were alrady consumed or marked as (used/consummed).

Fully used Coupons = Total of used coupons / Total of Coupons

Total of used Coupons = (total of  that have the Used/consumed attribute set to True).

For instance from: 1 to 10

Total of coupons = (10-1) +1 = 10

Fully used Coupons =  7 (having used value set to true)

Fully used Coupons = 7/10 = 0.7

Store in entity 0.7 , but presen it as a percentage (70.00%)

Consumption Detail

Indicate the vehicle consumption detail it can be indicated more than one detail

When coupons are included, system must inforce the user to register details as many coupons base on the next formula

Total Cost (Domestic currency)

Indicate the total of the grouped sum of item details.

Automatically calculated by the system.

Status

Status that are valid for a single consumption.

“created” (by default when created)

“In Review”

“Approved”

"Void"

Created by

User that create the consumption registry.

Automatically assigned by the system.

Do not allow update on this field.

Date and time of creation

Automatically assigned by the system when the record was created.

Do not allow update on this field.

Approved by

User that approved the consumption.

Automatically assigned by the system.

Date and time of approval

Automatically assigned by the system.

Do not allow update on this field.

ID

Auto assigned by the system.

External Transaction Reference

Device ID

Device that is reporting the position

Decimal Latitude

Decimal value for Latitude

Decimal Longitude

Decimal Value for Longitude

Degree Latitude

Decimal value for Degree

Minutes Latitude

Decimal value for minutes

Second Latitude

Decimal value for Seconds

Degree Longitude

Decimal value for degree (longitude)

Minutes Longitude

Decimal value for Minute (longitude)

Second Longitude

Decimal value for Seconds (longitude)

Date and time

Date and time when transaction was received

Automatically assigned by the system.

External received message

String that represents a message received in a predefined or agreed exchange format as XML or any other.

If Possible allows to save more than 3000 chars depending on database limitations.

Vehicle ID

Indicates the vehicle that is being assigned.

Allow the user to make look up.

Assigned requested by (employee)

Employee that orders the assignment in case order comes from a superior Position.

Assigned to Employee

The employee that is responsible for the vehicle, this is different than a driver as the driver can be assigned only for a period of time and it is not responsible for the car.

Assigned Date

Auto assigned by the system when the registry is created

Usage of the vehicle Start Date

Assigned by the user that registers the assignment.

The system should allow previous and future dates as the usage of the vehicle could start previous the assignment registry or can start after registry.

Description

Description of the assignment

Release description

Important notes about the vehicle status or other relevant comment when assignment it's being closed.

Odometer value at assignment time

Odometer value that marks the vehicle at the creation of the assignment

Assignment Status

Indicates if the assignment is active or is released from any responsibility.

Automatically “Assigned” for all created rows.

Values:

“Assigned”

“Released”

This field is read only and is updated only for other processes.

Workflow Assignment Status

Status of the Assignment, it is assigned depending of the workflow configuration.

Values:

“created”

“request for approval”

“Approved”

“Closed”

Assignment registered by

User that registered the assignment.

Do not allow update on this field.

Approved by user

User that approved the assignment.

Do not allow update on this field.

Date of approval

Auto assigned by the system

Do not allow update on this field.

Official Documents

One or more attached official documents that support the responsible assignment.

Vehicle ID

Auto assigned by the system.

GPS Device

Indicates the GPS

Active

Indicates if the Device is ACTIVE and is being used in the vehicle (True) or  “False” when it is turned off or is out of service.

Installed on

Indicates the exact date and time when the device was installed on the vehicle and the moment when was turned on  (Date and time when the device is operational on vehicle)

Un mount date

Date and time when the device was removed or fully un installed in the vehicle.

Observations

Any comment with relevant information about the GPS installed on the vehicle.

Vehicle ID

Reference to the Vehicle that is receiving the inspection

Inspection type

One or more inspection types that are related to the Inspection Entry.

Responsible for the inspection

Employee that did the inspection and is responsible for the comment and other related notes.

Description

Description of the vehicle maintenance.

Observations

Other observation made on the inspection.

Date of Inspection

Date when the inspection was realized, the system should allow entering any valid date.

Odometer value at the end of Inspection

Odometer value at the moment of inspection.

Responsible of the vehicle at Inspection Registry Time

Responsible of the vehicle when inspection was done.

Consider that this can be a list of responsible having “active” Assignments for the vehicle if the Parameter Allow Multiple Assignment is True

This list must be filled by the system automatically taking all employees that have an “Active” Assignment for the vehicle.

Estimated next Inspection

Estimated next date when next Inspection should be done.

Attachments

Any related document that supports the inspection as images or other valid system attachment.

Status

Status of the inspection registry.

Created (when the row is created)

Assigned (while is being done)

Ready for Review (when the inspection ended)

Approved (final review of information)

Void

Registered by

Auto assigned by the system.

User that register the Inspection.

Do not allow update on this field.

Registered on

Auto assigned by the system when row created.

Do not allow update on this field.

Approved by

Auto assigned by the system when inspection is approved.

Do not allow update on this field.

Date of approval

Auto assigned by the system when row is approved.

Do not allow update on this field.

Usage Type

Indicate the usage type and purpose for which will be the vehicle use.

Description

A brief description about the purpose of the usage.

Status

Indicates the status of the Usage Registry, by default at creation moment will be “In Use”

Values:

“In use”

“Use ended”

Registered date and time

Auto Assigned by the System.

Usage Started on

Date when the usage started or will start.

Usage Estimated end Date

Date when the usage is intended to be finished.

Automatically assigned by the system

Authorized by

Employee that authorizes the usage of the vehicle.

Assigned to Driver

Driver that is assigned to use the car.

Vehicle ID

Vehicle that is assigned to user for the Driver.

Attachments

Reference to 0 or more attachments needed by the user. For example can be attached official letter that support the usage permission etc.

Workflow Status

Indicate the status of the usage registry.

“Created” (automatically assigned at creation time”

“Activation Requested”

“Active”

“Finished”

Odometer value when usage is registered

Odometer value indicated by the vehicle when the Usage is registered.

Odometer value when usage finished

Odometer value indicated by the vehicle when the usage is changed to status “Finished”

Created by

User that authorized the usage of the vehicle.

Approved by

User that authorized the usage of the vehicle.

Approved on

Auto assigned by the system when workflow is approved