vehicle_log_contract: Odoo itgen_odoo_vehicle_log_contract
read only per partition
- Catalogo:
Odoo - Schema:
fleet - Etichetta: itgen_odoo_vehicle_log_contract
Vehicle Contract
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella vehicle_log_contract. 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 |
|---|---|---|---|---|---|
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 |
||||
amount |
numeric |
Cost | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
cost_ |
varchar2 |
Recurring Cost Frequency | |||
cost_ |
numeric |
Recurring Cost | |||
cost_ |
varchar2 |
Cost type purchased with this cost | |||
cost_ |
varchar2 |
Cost type purchased with this cost | |||
create_ |
datetime |
Creato il | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
date |
datetime |
Date | Date when the cost has been executed | ||
days_ |
int32 |
Warning Date | |||
display_ |
varchar2 |
Nome visualizzato | |||
expiration_ |
datetime |
Contract Expiration Date | Date when the coverage of the contract expirates (by default, one year after begin date) | ||
expires_ |
boolean |
Expires Today | |||
has_ |
boolean |
Has Message | |||
id |
int32 |
ID | |||
ins_ |
varchar2 |
Reference | |||
insurer_ |
varchar2 |
||||
insurer_ |
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 |
||||
my_ |
datetime |
My Activity Deadline | |||
name |
varchar2 |
Name | |||
notes |
varchar2 |
Terms and Conditions | Write here all supplementary information relative to this contract | ||
purchaser_ |
varchar2 |
||||
purchaser_ |
varchar2 |
||||
purchaser_ |
varchar2 |
Driver address of the vehicle | |||
purchaser_ |
varchar2 |
Driver address of the vehicle | |||
service_ |
varchar2 |
||||
start_ |
datetime |
Data di inizio del contratto | Date when the coverage of the contract begins | ||
state |
varchar2 |
Status | Choose whether the contract is still valid or not | ||
user_ |
varchar2 |
||||
user_ |
varchar2 |
||||
vehicle_ |
varchar2 |
||||
vehicle_ |
varchar2 |
||||
website_ |
varchar2 |
Website communication history | |||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: