Projects:VehicleManagement/Technical Documentation
Module Definition
- Name: Vehicle Management System
- Java Package: org.openbravo.module.vehiclemanagement
- Description: Vehicle Management System that allow to manage fleet of vehicles in Openbravo with it's corresponding drivers and maintenance/repair tasks
- Help: Vehicle Management System that allow to manage fleet of vehicles in Openbravo with it's corresponding drivers and maintenance/repair tasks.
- Translation Required: Yes
- Module Language: English (USA)
- License: Openbravo Public License
- IsCommercial: No
- Has reference data: Yes
- DB Prefix: OBVMS
- Module Dependencies:
- Openbravo 3.0 Framework
- Maintenance Management Infrastructure
Database
Tables
OBVMS_COMPONENT
- It stores Vehicles Parts (Components)
Column
| Datatype
| Nullable
|
obvms_component_id
| varchar(32)
| NO
|
ad_client_id
| varchar(32)
| NO
|
ad_org_id
| varchar(32)
| NO
|
isactive
| character(1)
| NO
|
created
| timestamp
| NO
|
createdby
| varchar(32)
| NO
|
updated
| timestamp
| NO
|
updatedby
| varchar(32)
| NO
|
name
| varchar(60)
| NO
|
description
| varchar(255)
| YES
|
OBVMS_FUEL_ENTRY
- It stores Fuel information for Vehicles
Column
| Datatype
| Nullable
|
obvms_fuel_entry_id
| varchar(32)
| NO
|
ad_client_id
| varchar(32)
| NO
|
ad_org_id
| varchar(32)
| NO
|
isactive
| character(1)
| NO
|
created
| timestamp
| NO
|
createdby
| varchar(32)
| NO
|
updated
| timestamp
| NO
|
updatedby
| varchar(32)
| NO
|
obvms_vehicle_id
| varchar(32)
| NO
|
date
| timestamp
| NO
|
c_location_id
| varchar(32)
| YES
|
liters
| numeric
| NO
|
unit_price
| numeric
| YES
|
c_currency_id
| varchar(32)
| YES
|
fuel_type
| varchar(60)
| YES
|
c_invoice_id
| varchar(32)
| YES
|
c_bpartner_id
| varchar(32)
| YES
|
partial
| character(1)
| NO
|
odometer
| numeric
| YES
|
service_station
| varchar(60)
| YES
|
OBVMS_LICENSE
- It stores Driver Licenses information for Drivers
Column
| Datatype
| Nullable
|
obvms_license_id
| varchar(32)
| NO
|
ad_client_id
| varchar(32)
| NO
|
ad_org_id
| varchar(32)
| NO
|
isactive
| character(1)
| NO
|
created
| timestamp
| NO
|
createdby
| varchar(32)
| NO
|
updated
| timestamp
| NO
|
updatedby
| varchar(32)
| NO
|
c_bpartner_id
| varchar(32)
| NO
|
description
| varchar(2000)
| YES
|
license_number
| varchar(60)
| NO
|
license_class
| varchar(100)
| NO
|
region
| varchar(100)
| YES
|
expiration_date
| timestamp
| NO
|
obvms_renewal_type_id
| varchar(32)
| YES
|
renewed
| character(1)
| NO
|
OBVMS_MAINTPLAN_DRIVER
- It stores Maintenance Tasks for Drivers
Column
| Datatype
| Nullable
|
obvms_maintplan_driver_id
| varchar(32)
| NO
|
ad_client_id
| varchar(32)
| NO
|
ad_org_id
| varchar(32)
| NO
|
isactive
| character(1)
| NO
|
created
| timestamp
| NO
|
createdby
| varchar(32)
| NO
|
updated
| timestamp
| NO
|
updatedby
| varchar(32)
| NO
|
obmmi_maintplan_id
| varchar(32)
| NO
|
c_bpartner_id
| varchar(32)
| NO
|
OBVMS_MAINTPLAN_TRANSUNIT
- It stores Maintenance Tasks for Transportation Units
Column
| Datatype
| Nullable
|
obvms_maintplan_transunit_id
| varchar(32)
| NO
|
ad_client_id
| varchar(32)
| NO
|
ad_org_id
| varchar(32)
| NO
|
isactive
| character(1)
| NO
|
created
| timestamp
| NO
|
createdby
| varchar(32)
| NO
|
updated
| timestamp
| NO
|
updatedby
| varchar(32)
| NO
|
obmmi_maintplan_id
| varchar(32)
| NO
|
obvms_transport_unit_id
| varchar(32)
| NO
|
OBVMS_MAINTPLAN_VEHICLE
- It stores Maintenance Tasks for Vehicles
Column
| Datatype
| Nullable
|
obvms_maintplan_vehicle_id
| varchar(32)
| NO
|
ad_client_id
| varchar(32)
| NO
|
ad_org_id
| varchar(32)
| NO
|
isactive
| character(1)
| NO
|
created
| timestamp
| NO
|
createdby
| varchar(32)
| NO
|
updated
| timestamp
| NO
|
updatedby
| varchar(32)
| NO
|
obmmi_maintplan_id
| varchar(32)
| NO
|
obvms_vehicle_id
| varchar(32)
| NO
|
OBVMS_RENEWAL_TYPE
- It stores Types of Renewals used in Maintenance actions
Column
| Datatype
| Nullable
|
obvms_renewal_type_id
| varchar(32)
| NO
|
ad_client_id
| varchar(32)
| NO
|
ad_org_id
| varchar(32)
| NO
|
isactive
| character(1)
| NO
|
created
| timestamp
| NO
|
createdby
| varchar(32)
| NO
|
updated
| timestamp
| NO
|
updatedby
| varchar(32)
| NO
|
name
| varchar(60)
| NO
|
description
| varchar(255)
| YES
|
isdriver
| character(1)
| NO
|
isvehicle
| character(1)
| NO
|
istransportunit
| character(1)
| NO
|
OBVMS_TRANS_UNITTYPE
- It stores Types to define Transportation Units
Column
| Datatype
| Nullable
|
obvms_trans_unittype_id
| varchar(32)
| NO
|
ad_client_id
| varchar(32)
| NO
|
ad_org_id
| varchar(32)
| NO
|
isactive
| character(1)
| NO
|
created
| timestamp
| NO
|
createdby
| varchar(32)
| NO
|
updated
| timestamp
| NO
|
updatedby
| varchar(32)
| NO
|
name
| varchar(60)
| NO
|
description
| varchar(255)
| YES
|
revision_periodicity
| character(1)
| NO
|
revision_periodicity_value
| numeric(12,2)
| YES
|
c_uom_id
| varchar(32)
| YES
|
obmmi_maintain_tasktype_id
| varchar(32)
| YES
|
OBVMS_TRANSP_REQUISITION
- It stores Transport Requisitions
Column
| Datatype
| Nullable
|
obvms_transp_requisition_id
| varchar(32)
| NO
|
ad_client_id
| varchar(32)
| NO
|
ad_org_id
| varchar(32)
| NO
|
isactive
| character(1)
| NO
|
created
| timestamp
| NO
|
createdby
| varchar(32)
| NO
|
updated
| timestamp
| NO
|
updatedby
| varchar(32)
| NO
|
documentno
| varchar(60)
| NO
|
latestdate
| timestamp
| NO
|
earliestdate
| timestamp
| NO
|
locationfrom
| varchar(32)
| NO
|
locationto
| varchar(32)
| NO
|
shortdescription
| varchar(255)
| NO
|
description
| varchar(2000)
| NO
|
status
| varchar(60)
| NO
|
c_doctype_id
| varchar(32)
| YES
|
requestedby
| varchar(32)
| YES
|
action
| varchar(60)
| YES
|
bpartner_location_from
| varchar(32)
| YES
|
warehousefrom
| varchar(32)
| YES
|
organizationfrom
| varchar(32)
| YES
|
warehouseto
| varchar(32)
| YES
|
organizationto
| varchar(32)
| YES
|
weight
| numeric
| YES
|
weight_uom
| varchar(32)
| YES
|
volume
| numeric
| YES
|
volume_uom
| varchar(32)
| YES
|
outsourced
| character(1)
| NO
|
OBVMS_TRANSPORT_UNIT
- It stores Transportation Units information
Column
| Datatype
| Nullable
|
obvms_transport_unit_id
| varchar(32)
| NO
|
ad_client_id
| varchar(32)
| NO
|
ad_org_id
| varchar(32)
| NO
|
isactive
| character(1)
| NO
|
created
| timestamp
| NO
|
createdby
| varchar(32)
| NO
|
updated
| timestamp
| NO
|
updatedby
| varchar(32)
| NO
|
value
| varchar(30)
| NO
|
name
| varchar(60)
| NO
|
description
| varchar(255)
| YES
|
width
| numeric
| YES
|
height
| numeric
| YES
|
lenght
| numeric
| YES
|
maximum_weight
| numeric
| YES
|
unladen_weight
| numeric
| YES
|
availability
| varchar(32)
| YES
|
axles
| numeric
| YES
|
a_asset_id
| varchar(32)
| YES
|
obvms_trans_unittype_id
| varchar(32)
| NO
|
taillift
| character(1)
| NO
|
width_uom
| varchar(32)
| YES
|
height_uom
| varchar(32)
| YES
|
lenght_uom
| varchar(32)
| YES
|
maximum_weight_uom
| varchar(32)
| YES
|
unladen_weight_uom
| varchar(32)
| YES
|
volume
| numeric
| YES
|
volume_uom
| varchar(32)
| YES
|
updateavailability
| character(1)
| NO
|
totaltime
| numeric
| NO
|
lastrevision
| numeric
| NO
|
OBVMS_TRUNIT_AVAIL
- It stores the Availability of Transportation Units
Column
| Datatype
| Nullable
|
obvms_trunit_avail_id
| varchar(32)
| NO
|
ad_client_id
| varchar(32)
| NO
|
ad_org_id
| varchar(32)
| NO
|
isactive
| character(1)
| NO
|
created
| timestamp
| NO
|
createdby
| varchar(32)
| NO
|
updated
| timestamp
| NO
|
updatedby
| varchar(32)
| NO
|
date
| timestamp
| NO
|
obvms_transport_unit_id
| varchar(32)
| NO
|
obvms_trunit_availability_id
| varchar(32)
| NO
|
OBVMS_TUNIT_DOC
- It stores the Transportation Units Documentation
Column
| Datatype
| Nullable
|
obvms_tunit_doc_id
| varchar(32)
| NO
|
ad_client_id
| varchar(32)
| NO
|
ad_org_id
| varchar(32)
| NO
|
isactive
| character(1)
| NO
|
created
| timestamp
| NO
|
createdby
| varchar(32)
| NO
|
updated
| timestamp
| NO
|
updatedby
| varchar(32)
| NO
|
expiration_date
| timestamp
| NO
|
description
| varchar(2000)
| NO
|
obvms_transport_unit_id
| varchar(32)
| NO
|
obvms_renewal_type_id
| varchar(32)
| YES
|
renewed
| character(1)
| NO
|
OBVMS_VEHICLE
- It stores Vehicles information
Column
| Datatype
| Nullable
|
obvms_vehicle_id
| varchar(32)
| NO
|
ad_client_id
| varchar(32)
| NO
|
ad_org_id
| varchar(32)
| NO
|
isactive
| character(1)
| NO
|
created
| timestamp
| NO
|
createdby
| varchar(32)
| NO
|
updated
| timestamp
| NO
|
updatedby
| varchar(32)
| NO
|
vin_sn
| varchar(17)
| NO
|
batch_no
| varchar(60)
| YES
|
license_plate
| varchar(60)
| NO
|
vehicle_type
| varchar(32)
| NO
|
obvms_vehicle_model_id
| varchar(32)
| NO
|
trim
| varchar(60)
| YES
|
c_bpartner_id
| varchar(32)
| YES
|
ownership
| varchar(60)
| NO
|
a_asset_id
| varchar(32)
| YES
|
kms
| numeric
| NO
|
fuel_type
| varchar(60)
| YES
|
obvms_vehicle_availability_id
| varchar(32)
| YES
|
internal_vehicle_no
| varchar(60)
| NO
|
external_vehicle_no
| varchar(60)
| YES
|
ad_image_id
| varchar(32)
| YES
|
assigntranspunit
| character(1)
| YES
|
description
| varchar(2000)
| YES
|
engine_number
| varchar(60)
| YES
|
year
| varchar(60)
| YES
|
updateavailability
| character(1)
| NO
|
totaldistance
| numeric
| NO
|
lastrevision
| numeric
| NO
|
OBVMS_VEHICLE_AVAIL
- It stores the Availability of Vehicles
Column
| Datatype
| Nullable
|
obvms_vehicle_avail_id
| varchar(32)
| NO
|
ad_client_id
| varchar(32)
| NO
|
ad_org_id
| varchar(32)
| NO
|
isactive
| character(1)
| NO
|
created
| timestamp
| NO
|
createdby
| varchar(32)
| NO
|
updated
| timestamp
| NO
|
updatedby
| varchar(32)
| NO
|
date
| timestamp
| NO
|
obvms_vehicle_id
| varchar(32)
| NO
|
obvms_vehicle_availability_id
| varchar(32)
| NO
|
OBVMS_VEHICLE_AVAILABILITY
- It stores the diferent types of Availability
Column
| Datatype
| Nullable
|
obvms_vehicle_availability_id
| varchar(32)
| NO
|
ad_client_id
| varchar(32)
| NO
|
ad_org_id
| varchar(32)
| NO
|
isactive
| character(1)
| NO
|
created
| timestamp
| NO
|
createdby
| varchar(32)
| NO
|
updated
| timestamp
| NO
|
updatedby
| varchar(32)
| NO
|
name
| varchar(60)
| NO
|
description
| varchar(255)
| YES
|
isavailable
| character(1)
| NO
|
OBVMS_VEHICLE_COMP
- It stores Associations between Vehicles and Components
Column
| Datatype
| Nullable
|
obvms_vehicle_comp_id
| varchar(32)
| NO
|
ad_client_id
| varchar(32)
| NO
|
ad_org_id
| varchar(32)
| NO
|
isactive
| character(1)
| NO
|
created
| timestamp
| NO
|
createdby
| varchar(32)
| NO
|
updated
| timestamp
| NO
|
updatedby
| varchar(32)
| NO
|
obvms_component_id
| varchar(32)
| NO
|
details
| varchar(255)
| YES
|
obvms_vehicle_id
| varchar(32)
| YES
|
OBVMS_VEHICLE_COSTING
Column
| Datatype
| Nullable
|
obvms_vehicle_costing_id
| varchar(32)
| NO
|
ad_client_id
| varchar(32)
| NO
|
ad_org_id
| varchar(32)
| NO
|
isactive
| character(1)
| NO
|
created
| timestamp
| NO
|
createdby
| varchar(32)
| NO
|
updated
| timestamp
| NO
|
updatedby
| varchar(32)
| NO
|
datefrom
| timestamp
| NO
|
dateto
| timestamp
| NO
|
cost
| numeric
| NO
|
obvms_vehicle_id
| varchar(32)
| NO
|
description
| varchar(2000)
| YES
|
OBVMS_VEHICLE_DOC
- It stores Vehicle Documentation
Column
| Datatype
| Nullable
|
obvms_vehicle_doc_id
| varchar(32)
| NO
|
ad_client_id
| varchar(32)
| NO
|
ad_org_id
| varchar(32)
| NO
|
isactive
| character(1)
| NO
|
created
| timestamp
| NO
|
createdby
| varchar(32)
| NO
|
updated
| timestamp
| NO
|
updatedby
| varchar(32)
| NO
|
expiration_date
| timestamp
| NO
|
description
| varchar(2000)
| NO
|
obvms_vehicle_id
| varchar(32)
| NO
|
obvms_renewal_type_id
| varchar(32)
| YES
|
renewed
| character(1)
| NO
|
OBVMS_VEHICLE_MAKE
- It stores Vehicle Manufacturers
Column
| Datatype
| Nullable
|
obvms_vehicle_make_id
| varchar(32)
| NO
|
ad_client_id
| varchar(32)
| NO
|
ad_org_id
| varchar(32)
| NO
|
isactive
| character(1)
| NO
|
created
| timestamp
| NO
|
createdby
| varchar(32)
| NO
|
updated
| timestamp
| NO
|
updatedby
| varchar(32)
| NO
|
name
| varchar(60)
| NO
|
description
| varchar(255)
| YES
|
OBVMS_VEHICLE_MODEL
Column
| Datatype
| Nullable
|
obvms_vehicle_model_id
| varchar(32)
| NO
|
ad_client_id
| varchar(32)
| NO
|
ad_org_id
| varchar(32)
| NO
|
isactive
| character(1)
| NO
|
created
| timestamp
| NO
|
createdby
| varchar(32)
| NO
|
updated
| timestamp
| NO
|
updatedby
| varchar(32)
| NO
|
name
| varchar(60)
| NO
|
description
| varchar(255)
| YES
|
obvms_vehicle_make_id
| varchar(32)
| YES
|
revision_periodicity
| character(1)
| NO
|
revision_periodicity_value
| numeric(12,2)
| YES
|
c_uom_id
| varchar(32)
| YES
|
obmmi_maintain_tasktype_id
| varchar(32)
| YES
|
OBVMS_VEHICLE_TRANSUNIT
- It stores associations between Vehicles and Transportation Units
Column
| Datatype
| Nullable
|
obvms_vehicle_transunit_id
| varchar(32)
| NO
|
ad_client_id
| varchar(32)
| NO
|
ad_org_id
| varchar(32)
| NO
|
isactive
| character(1)
| NO
|
created
| timestamp
| NO
|
createdby
| varchar(32)
| NO
|
updated
| timestamp
| NO
|
updatedby
| varchar(32)
| NO
|
obvms_vehicle_id
| varchar(32)
| NO
|
obvms_transport_unit_id
| varchar(32)
| NO
|
datefrom
| timestamp
| NO
|
dateto
| timestamp
| YES
|
unassign
| character(1)
| YES
|
OBVMS_VEHICLE_TYPE
- It stores Types to define Vehicles
Column
| Datatype
| Nullable
|
obvms_vehicle_type_id
| varchar(32)
| NO
|
ad_client_id
| varchar(32)
| NO
|
ad_org_id
| varchar(32)
| NO
|
isactive
| character(1)
| NO
|
created
| timestamp
| NO
|
createdby
| varchar(32)
| NO
|
updated
| timestamp
| NO
|
updatedby
| varchar(32)
| NO
|
name
| varchar(60)
| NO
|
description
| varchar(255)
| YES
|
Views
OBVMS_TRANSPORTWOSTATUS_V
View to list the status of all Work Orders related to Vehicles
OBVMS_VEHICLECARD_V
View to easily list all the Veicles' details