Vehicle

Name

Description

Vehicle ID

Auto assigned by the system or manually entered by the user depending on parameter Generate Vehicle ID.

Value must be unique in entire table and can be padded if parameter is configure.

Institution

Indicates the Institution where the Vehicle Belongs, an institution at any hierarchy level can be chosen by the user.

Allow the user select by doing a look up.

Vehicle Type

Type of the vehicle.

Maker's code

Make of the vehicle

Model

Model of the vehicle

Sub Model (line)

Line or sub model of the vehicle

Vehicle Manufactured year

Indicates the year when the vehicle was built by the manufacturer.

Allow only integer values.

Exterior Main Color

Exterior main color.

Other Exterior Colors

Zero or more exterior colors in case the vehicle has other colors.

Interior Main Color

Interior Main color

Plates Number

String that represent a unique value to identify a vehicle. The string can be formed by letters, numbers, symbols and blanks depending on Plates Parameters values

The maximum size of the field is controlled by the parameter Plates max size.

Note: For all letters always change to UPPER letters.

VIN (vehicle identification number)

Vehicle Identification Number, it only allows 17 chars that can be letters and numbers only WITHOUT blanks.

See VIN Parameters.

This value must be unique for entire table.

Engine Number

Vehicle Engine Number

Seat capacity

Indicates the seat capacity given by the manufacturer of the vehicle.

Allow only numeric integer values.

Related Asset Item

Indicates if the Vehicle is linked to a specific Asset item. The Asset item must belong to the Institution given in this table or any child institution of that institution.

This value could be mandatory depending of parameter configuration “Mandatory Asset Item in Vehicle”

Vehicle Original Cost (Domestic Currency)

Indicates the original cost when the vehicle was acquired.

Vehicle Current Value (Domestic currency)

Indicates the current value of the vehicle at registration moment in the system.

Vehicle System Registration Date

Auto assigned by the system, date and time when the vehicle was registered in the system.

Odometer Measure type

Indicates the distance type of measure used for the vehicle in Odometer.

Odometer Value at Registration Time

Indicate the value that marks the vehicle odometer when the vehicle it is being registered into the system.

Latest Registered Odometer Value

Auto assigned by the system always, do not allow manual update on this attribute.

Vehicle Description

Indicates longer description of the vehicle, including special and unique features of the vehicle and other important comments.

Observations

Other important comment about the vehicle.

Pictures

Allow the user to enter file attachments only of image type See Parameter Picture Types.

Also the user should be allowed to enter only the title and the file to be uploaded for the Attachment entity, use sequential numbering for Order, copy title into description and always default language for attachment language.

Attachments

Allow the user to enter any type of attachment using regular attachment attributes.

Latest Maintenance Date

Auto assigned by the system and not allowed to update by the user.

This will be updated when the latest maintenance for the vehicle is registered.

Workflow  Status

These are the possible status for the vehicle. This can change for different workflow configurations.

“created”

“On review”

“Approved”

 “Out of use”

Vehicle Status

Status that represent the state of the vehicle in terms of the usage which the vehicle is available for.

“Being registered”

“Ready for Assignment”

“In Maintenance”

“Assigned”

“Out of Use”

Responsible Employee

Employee that is responsible for the vehicle.  The employee that is responsible for the vehicle.

This field is not allowed to be updated by the Vehicle UI, it can be updated only directly when vehicle is created or when Vehicle is Assigned

Created by

User that registered the vehicle in the system, automatically assigned by the system.

Do not allow update on this field.

Approved Date

Auto assigned by the user when Vehicle is approved

Do not allow update on this field.

Approved by User

User that Approved the vehicle registry in the system, automatically assigned by workflow system.

Do not allow update on this field.

Fuel Types

One or more fuel types that are used by the Vehicle.

If the vehicle has a “Sub model” (line) from this table then all of the “Fabric” indicated Fuel types from Line must be imported from Line Fuel Type

Vehicle Insurance Information

Link to the registered Insurance for the vehicle

The user can’t create new insurance information from here it is only displayed from Vehicle Insurance when the Vehicle is included in one of the Insurance Information Details

Last update on Vehicle

Automatically assigned by the system on latest vehicle data update.

Last update on vehicle by user

Last user that updated the vehicle information.

Main Engine Size in CC

Allow the user to indicate the size of the main vehicle engine in Cu

Main Engine Cylinders

Allow the user indicate the main engine number of cylinders.

Chassis Number

Indicate the Vehicle Chassis number

Other Vehicle Features

Allow the user create a custom domain type where other needed features can be added for all of the vehicles.

GPS Devices

Zero or more installed GPS devices on a single vehicle.

Used in case more than one device is installed per vehicle and/or to keep tracked in history the entire installed device in the vehicle.

Legacy ID

Other unique id user by the clients to identify a vehicle in case a previous registry exits or in case end user wanted to create a custom ID.

Value must be unique in entire table.