---
title: "vehicle (Odoo)"
description: "itgen_odoo_vehicle"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.fleet.vehicle
original: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.fleet.vehicle
updated: 2023-03-01T15:29:04Z
license: https://documentation.invantive.eu/en/
---

# 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 | [x] |  |  |
| `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:

- [Odoo](/en/release-notes/drivers?driver=odoo)

