vehicle_log_contract |
Vehicle Contract
Catalog: Odoo
Schema: fleet
The data in this table is partitioned per value of the column.
This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API.
Table Columns
The columns of the table vehicle_log_contract are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
active |
boolean |
Active |
☐ |
|
activity_calendar_event_id_label |
string |
|
☐ |
|
activity_calendar_event_id |
string |
|
☐ |
|
activity_date_deadline |
datetime |
Next Activity Deadline |
☐ |
|
activity_exception_decoration |
string |
Activity Exception Decoration |
☐ |
Type of the exception activity on record. |
activity_exception_icon |
string |
Icon |
☐ |
Icon to indicate an exception activity. |
activity_ids |
string |
|
☐ |
|
activity_state |
string |
Activity State |
☐ |
Status based on activitiesOverdue: Due date is already passedToday: Activity date is todayPlanned: Future activities. |
activity_summary |
string |
Next Activity Summary |
☐ |
|
activity_type_icon |
string |
Activity Type Icon |
☐ |
Font awesome icon e.g. fa-tasks |
activity_type_id_label |
string |
|
☐ |
|
activity_type_id |
string |
|
☐ |
|
activity_user_id_label |
string |
|
☐ |
|
activity_user_id |
string |
|
☐ |
|
amount |
decimal |
Cost |
☐ |
|
company_id_label |
string |
|
☐ |
|
company_id |
string |
|
☐ |
|
cost_frequency |
string |
Recurring Cost Frequency |
☑ |
|
cost_generated |
decimal |
Recurring Cost |
☐ |
|
cost_subtype_id_label |
string |
|
☐ |
Cost type purchased with this cost |
cost_subtype_id |
string |
|
☐ |
Cost type purchased with this cost |
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
currency_id_label |
string |
|
☐ |
|
currency_id |
string |
|
☐ |
|
date |
datetime |
Date |
☐ |
Date when the cost has been executed |
days_left |
int32 |
Warning Date |
☐ |
|
display_name |
string |
Display Name |
☐ |
|
expiration_date |
datetime |
Contract Expiration Date |
☐ |
Date when the coverage of the contract expirates (by default, one year after begin date) |
expires_today |
boolean |
Expires Today |
☐ |
|
has_message |
boolean |
Has Message |
☐ |
|
id |
int32 |
ID |
☐ |
|
ins_ref |
string |
Reference |
☐ |
|
insurer_id_label |
string |
|
☐ |
|
insurer_id |
string |
|
☐ |
|
message_attachment_count |
int32 |
Attachment Count |
☐ |
|
message_follower_ids |
string |
|
☐ |
|
message_has_error_counter |
int32 |
Number of errors |
☐ |
Number of messages with delivery error |
message_has_error |
boolean |
Message Delivery error |
☐ |
If checked, some messages have a delivery error. |
message_has_sms_error |
boolean |
SMS Delivery error |
☐ |
If checked, some messages have a delivery error. |
message_ids |
string |
|
☐ |
|
message_is_follower |
boolean |
Is Follower |
☐ |
|
message_main_attachment_id_label |
string |
|
☐ |
|
message_main_attachment_id |
string |
|
☐ |
|
message_needaction_counter |
int32 |
Number of Actions |
☐ |
Number of messages which requires an action |
message_needaction |
boolean |
Action Needed |
☐ |
If checked, new messages require your attention. |
message_partner_ids |
string |
|
☐ |
|
my_activity_date_deadline |
datetime |
My Activity Deadline |
☐ |
|
name |
string |
Name |
☐ |
|
notes |
string |
Terms and Conditions |
☐ |
Write here all supplementary information relative to this contract |
purchaser_employee_id_label |
string |
|
☐ |
|
purchaser_employee_id |
string |
|
☐ |
|
purchaser_id_label |
string |
|
☐ |
Driver address of the vehicle |
purchaser_id |
string |
|
☐ |
Driver address of the vehicle |
service_ids |
string |
|
☐ |
|
start_date |
datetime |
Contract Start Date |
☐ |
Date when the coverage of the contract begins |
state |
string |
Status |
☐ |
Choose whether the contract is still valid or not |
user_id_label |
string |
|
☐ |
|
user_id |
string |
|
☐ |
|
vehicle_id_label |
string |
|
☐ |
|
vehicle_id |
string |
|
☐ |
|
website_message_ids |
string |
|
☐ |
Website communication history |
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826