View source | View content page | Page history | Printable version   

Projects:VehicleManagement/Technical Documentation

Contents

Module Definition


Database

Tables

OBVMS_COMPONENT

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Retrieved from "http://wiki.openbravo.com/wiki/Projects:VehicleManagement/Technical_Documentation"

This page has been accessed 361 times. This page was last modified on 22 November 2018, at 18:04. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.