Projects:VehicleManagement/Technical Documentation

Contents 1 Module Definition 2 Database 2.1 Tables 2.1.1 OBVMS_COMPONENT 2.1.2 OBVMS_FUEL_ENTRY 2.1.3 OBVMS_LICENSE 2.1.4 OBVMS_MAINTPLAN_DRIVER 2.1.5 OBVMS_MAINTPLAN_TRANSUNIT 2.1.6 OBVMS_MAINTPLAN_VEHICLE 2.1.7 OBVMS_RENEWAL_TYPE 2.1.8 OBVMS_TRANS_UNITTYPE 2.1.9 OBVMS_TRANSP_REQUISITION 2.1.10 OBVMS_TRANSPORT_UNIT 2.1.11 OBVMS_TRUNIT_AVAIL 2.1.12 OBVMS_TUNIT_DOC 2.1.13 OBVMS_VEHICLE 2.1.14 OBVMS_VEHICLE_AVAIL 2.1.15 OBVMS_VEHICLE_AVAILABILITY 2.1.16 OBVMS_VEHICLE_COMP 2.1.17 OBVMS_VEHICLE_COSTING 2.1.18 OBVMS_VEHICLE_DOC 2.1.19 OBVMS_VEHICLE_MAKE 2.1.20 OBVMS_VEHICLE_MODEL 2.1.21 OBVMS_VEHICLE_TRANSUNIT 2.1.22 OBVMS_VEHICLE_TYPE 2.2 Views 2.2.1 OBVMS_TRANSPORTWOSTATUS_V 2.2.2 OBVMS_VEHICLECARD_V

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

• It stores Vehicle Costs

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

• It stores Vehicle Models

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