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_ |
varchar2 |
||||
acquisition_ |
datetime |
Immatriculation Date | Date when the vehicle has been immatriculated | ||
active |
boolean |
Active | |||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
datetime |
Next Activity Deadline | |||
activity_ |
varchar2 |
Activity Exception Decoration | Type of the exception activity on record. | ||
activity_ |
varchar2 |
Icon | Icon to indicate an exception activity. | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
Activity State | Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities. | ||
activity_ |
varchar2 |
Next Activity Summary | |||
activity_ |
varchar2 |
Activity Type Icon | Font awesome icon e.g. fa-tasks | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
bill_ |
int32 |
Bills Count | |||
brand_ |
varchar2 |
||||
brand_ |
varchar2 |
||||
car_ |
numeric |
Catalog Value (VAT Incl.) | |||
category_ |
varchar2 |
||||
category_ |
varchar2 |
||||
co2 |
numeric |
CO2 Emissions | CO2 emissions of the vehicle | ||
co2_ |
varchar2 |
Co2 Standard | |||
color |
varchar2 |
Color | Color of the vehicle | ||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
contract_ |
int32 |
Contract Count | |||
contract_ |
boolean |
Has Contracts to renew | |||
contract_ |
varchar2 |
Name of contract to renew soon | |||
contract_ |
boolean |
Has Contracts Overdue | |||
contract_ |
varchar2 |
Total of contracts due or overdue minus one | |||
contract_ |
varchar2 |
Last Contract State | |||
country_ |
varchar2 |
Country Code | The ISO country code in two chars. You can use this field for quick search. | ||
country_ |
varchar2 |
||||
country_ |
varchar2 |
||||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
description |
varchar2 |
Vehicle Description | |||
display_ |
varchar2 |
Display Name | |||
document_ |
int32 |
Documents | |||
documents_ |
boolean |
Centralize Fleet Documents | |||
doors |
int32 |
Doors Number | Number of doors of the vehicle | ||
driver_ |
varchar2 |
||||
driver_ |
varchar2 |
||||
driver_ |
varchar2 |
Employee Name | |||
driver_ |
varchar2 |
Driver address of the vehicle | |||
driver_ |
varchar2 |
Driver address of the vehicle | |||
electric_ |
boolean |
Electric Assistance | |||
first_ |
datetime |
First Contract Date | |||
frame_ |
numeric |
Frame Size | |||
frame_ |
varchar2 |
Bike Frame Type | |||
fuel_ |
varchar2 |
Fuel Type | |||
future_ |
varchar2 |
||||
future_ |
varchar2 |
||||
future_ |
varchar2 |
Next Driver Address of the vehicle | |||
future_ |
varchar2 |
Next Driver Address of the vehicle | |||
has_ |
boolean |
Has Message | |||
history_ |
int32 |
Drivers History Count | |||
horsepower |
int32 |
Horsepower | |||
horsepower_ |
numeric |
Horsepower Taxation | |||
id |
int32 |
ID | |||
image_ |
varbinary |
Logo | |||
license_ |
varchar2 |
License Plate | License plate number of the vehicle (i = plate number for a car) | ||
location |
varchar2 |
Location | Location of the vehicle (garage, ...) | ||
log_ |
varchar2 |
||||
log_ |
varchar2 |
||||
log_ |
varchar2 |
||||
manager_ |
varchar2 |
||||
manager_ |
varchar2 |
||||
message_ |
int32 |
Attachment Count | |||
message_ |
varchar2 |
||||
message_ |
boolean |
Message Delivery error | If checked, some messages have a delivery error. | ||
message_ |
int32 |
Number of errors | Number of messages with delivery error | ||
message_ |
boolean |
SMS Delivery error | If checked, some messages have a delivery error. | ||
message_ |
varchar2 |
||||
message_ |
boolean |
Is Follower | |||
message_ |
varchar2 |
||||
message_ |
varchar2 |
||||
message_ |
boolean |
Action Needed | If checked, new messages require your attention. | ||
message_ |
int32 |
Number of Actions | Number of messages which requires an action | ||
message_ |
varchar2 |
||||
mobility_ |
varchar2 |
Mobility Card | |||
model_ |
varchar2 |
||||
model_ |
varchar2 |
||||
model_ |
varchar2 |
Model Year | Year of the model | ||
my_ |
datetime |
My Activity Deadline | |||
name |
varchar2 |
Name | |||
net_ |
numeric |
Purchase Value | |||
next_ |
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_ |
int32 |
Odometer | |||
odometer_ |
varchar2 |
Odometer Unit | |||
order_ |
datetime |
Order Date | |||
plan_ |
boolean |
Plan To Change Bike | |||
plan_ |
boolean |
Plan To Change Car | |||
power |
int32 |
Power | Power in kW of the vehicle | ||
residual_ |
numeric |
Residual Value | |||
seats |
int32 |
Seats Number | Number of seats of the vehicle | ||
service_ |
varchar2 |
Service Activity | |||
service_ |
int32 |
Services | |||
state_ |
varchar2 |
Current state of the vehicle | |||
state_ |
varchar2 |
Current state of the vehicle | |||
tag_ |
varchar2 |
||||
trailer_ |
boolean |
Trailer Hitch | |||
transmission |
varchar2 |
Transmission | |||
vehicle_ |
varchar2 |
Vehicle Type | |||
vin_sn |
varchar2 |
Chassis Number | Unique number written on the vehicle motor (VIN/SN number) | ||
website_ |
varchar2 |
Website communication history | |||
write_ |
datetime |
Last Updated on | |||
write_ |
datetime |
Cancellation Date | Date when the vehicle's license plate has been cancelled/removed. | ||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: