invantive documentation
Invantive Support ForumsLog In / Sign Up

vehicle: Odoo itgen_odoo_vehicle

read only per partition

  • Catalog: Odoo
  • Schema: fleet
  • Label: itgen_odoo_vehicle

Vehicle

Can only retrieve data.

Table Columns

The columns of the table vehicle are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
account_move_ids varchar2
acquisition_date datetime Immatriculation Date Date when the vehicle has been immatriculated
active boolean Active
activity_calendar_event_id varchar2
activity_calendar_event_id_label varchar2
activity_date_deadline datetime Next Activity Deadline
activity_exception_decoration varchar2 Activity Exception Decoration Type of the exception activity on record.
activity_exception_icon varchar2 Icon Icon to indicate an exception activity.
activity_ids varchar2
activity_state varchar2 Activity State Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities.
activity_summary varchar2 Next Activity Summary
activity_type_icon varchar2 Activity Type Icon Font awesome icon e.g. fa-tasks
activity_type_id varchar2
activity_type_id_label varchar2
activity_user_id varchar2
activity_user_id_label varchar2
bill_count int32 Bills Count
brand_id varchar2
brand_id_label varchar2
car_value numeric Catalog Value (VAT Incl.)
category_id varchar2
category_id_label varchar2
co2 numeric CO2 Emissions CO2 emissions of the vehicle
co2_standard varchar2 Co2 Standard
color varchar2 Color Color of the vehicle
company_id varchar2
company_id_label varchar2
contract_count int32 Contract Count
contract_renewal_due_soon boolean Has Contracts to renew
contract_renewal_name varchar2 Name of contract to renew soon
contract_renewal_overdue boolean Has Contracts Overdue
contract_renewal_total varchar2 Total of contracts due or overdue minus one
contract_state varchar2 Last Contract State
country_code varchar2 Country Code The ISO country code in two chars. You can use this field for quick search.
country_id varchar2
country_id_label varchar2
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
currency_id varchar2
currency_id_label varchar2
description varchar2 Vehicle Description
display_name varchar2 Display Name
document_count int32 Documents
documents_fleet_settings boolean Centralize Fleet Documents
doors int32 Doors Number Number of doors of the vehicle
driver_employee_id varchar2
driver_employee_id_label varchar2
driver_employee_name varchar2 Employee Name
driver_id varchar2 Driver address of the vehicle
driver_id_label varchar2 Driver address of the vehicle
electric_assistance boolean Electric Assistance
first_contract_date datetime First Contract Date
frame_size numeric Frame Size
frame_type varchar2 Bike Frame Type
fuel_type varchar2 Fuel Type
future_driver_employee_id varchar2
future_driver_employee_id_label varchar2
future_driver_id varchar2 Next Driver Address of the vehicle
future_driver_id_label varchar2 Next Driver Address of the vehicle
has_message boolean Has Message
history_count int32 Drivers History Count
horsepower int32 Horsepower
horsepower_tax numeric Horsepower Taxation
id int32 ID
image_128 varbinary Logo
license_plate varchar2 License Plate License plate number of the vehicle (i = plate number for a car)
location varchar2 Location Location of the vehicle (garage, ...)
log_contracts varchar2
log_drivers varchar2
log_services varchar2
manager_id varchar2
manager_id_label varchar2
message_attachment_count int32 Attachment Count
message_follower_ids varchar2
message_has_error boolean Message Delivery error If checked, some messages have a delivery error.
message_has_error_counter int32 Number of errors Number of messages with delivery error
message_has_sms_error boolean SMS Delivery error If checked, some messages have a delivery error.
message_ids varchar2
message_is_follower boolean Is Follower
message_main_attachment_id varchar2
message_main_attachment_id_label varchar2
message_needaction boolean Action Needed If checked, new messages require your attention.
message_needaction_counter int32 Number of Actions Number of messages which requires an action
message_partner_ids varchar2
mobility_card varchar2 Mobility Card
model_id varchar2
model_id_label varchar2
model_year varchar2 Model Year Year of the model
my_activity_date_deadline datetime My Activity Deadline
name varchar2 Name
net_car_value numeric Purchase Value
next_assignation_date datetime Assignment Date This is the date at which the car will be available, if not set it means available instantly
odometer numeric Last Odometer Odometer measure of the vehicle at the moment of this log
odometer_count int32 Odometer
odometer_unit varchar2 Odometer Unit
order_date datetime Order Date
plan_to_change_bike boolean Plan To Change Bike
plan_to_change_car boolean Plan To Change Car
power int32 Power Power in kW of the vehicle
residual_value numeric Residual Value
seats int32 Seats Number Number of seats of the vehicle
service_activity varchar2 Service Activity
service_count int32 Services
state_id varchar2 Current state of the vehicle
state_id_label varchar2 Current state of the vehicle
tag_ids varchar2
trailer_hook boolean Trailer Hitch
transmission varchar2 Transmission
vehicle_type varchar2 Vehicle Type
vin_sn varchar2 Chassis Number Unique number written on the vehicle motor (VIN/SN number)
website_message_ids varchar2 Website communication history
write_date datetime Last Updated on
write_off_date datetime Cancellation Date Date when the vehicle's license plate has been cancelled/removed.
write_uid varchar2
write_uid_label varchar2

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: