invantive documentation
Forum di supporto InvantiveAccedi / Registrati

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_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 Emissioni di CO2 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 Codice della nazione 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 Creato il
create_uid varchar2
create_uid_label varchar2
currency_id varchar2
currency_id_label varchar2
description varchar2 Vehicle Description
display_name varchar2 Nome visualizzato
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 Nome del dipendente
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 Tipo di carburante
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 Targa 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 Numero di allegati
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 Numero di azioni 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 Data dell'ordine
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 Valore residuo
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 Tipo di veicolo
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 Data di annullamento Date when the vehicle's license plate has been cancelled/removed.
write_uid varchar2
write_uid_label varchar2

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: