vehicle: Odoo itgen_odoo_vehicle
read only per partition
- Catalogo:
Odoo - Schema:
fleet - Etichetta: itgen_odoo_vehicle
Vehicle
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella vehicle. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | 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 |
Emissioni di CO2 | 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 |
Codice della nazione | The ISO country code in two chars.You can use this field for quick search. | ||
country_ |
varchar2 |
||||
country_ |
varchar2 |
||||
create_ |
datetime |
Creato il | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
description |
varchar2 |
Vehicle Description | |||
display_ |
varchar2 |
Nome visualizzato | |||
document_ |
int32 |
Documents | |||
documents_ |
boolean |
Centralize Fleet Documents | |||
doors |
int32 |
Doors Number | Number of doors of the vehicle | ||
driver_ |
varchar2 |
||||
driver_ |
varchar2 |
||||
driver_ |
varchar2 |
Nome del dipendente | |||
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 |
Tipo di carburante | |||
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 |
Targa | 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 |
Numero di allegati | |||
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 |
Numero di azioni | 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 |
Data dell'ordine | |||
plan_ |
boolean |
Plan To Change Bike | |||
plan_ |
boolean |
Plan To Change Car | |||
power |
int32 |
Power | Power in kW of the vehicle | ||
residual_ |
numeric |
Valore residuo | |||
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 |
Tipo di veicolo | |||
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 |
Data di annullamento | Date when the vehicle's license plate has been cancelled/removed. | ||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: