contact: Odoo itgen_odoo_contact
read only per partition
- Catalogo:
Odoo - Schema:
mailing - Etichetta: itgen_odoo_contact
Mailing Contact
È possibile solo recuperare i dati.
Riepilogo
Model of a contact. This model is different from the partner model because it holds only some basic information: name, email. The purpose is to be able to deal with large contact list to email without bloating the partner base.
Colonne della tabella
Di seguito sono riportate le colonne della tabella contact. 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 |
|---|---|---|---|---|---|
company_ |
varchar2 |
Nome dell'impresa | |||
country_ |
varchar2 |
||||
country_ |
varchar2 |
||||
create_ |
datetime |
Creato il | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
display_ |
varchar2 |
Nome visualizzato | |||
email |
varchar2 |
||||
email_ |
varchar2 |
Normalized Email | This field is used to search on email address as the primary email field can contain more than strictly an email address. | ||
has_ |
boolean |
Has Message | |||
id |
int32 |
ID | |||
is_ |
boolean |
Blacklist | If the email address is on the blacklist, the contact won't receive mass mailing anymore, from any list | ||
list_ |
varchar2 |
||||
message_ |
int32 |
Numero di allegati | |||
message_ |
int32 |
Bounce | Counter of the number of bounced emails for this contact | ||
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 |
||||
mobile |
varchar2 |
Mobile | |||
mobile_ |
boolean |
Blacklisted Phone Is Mobile | Indicates if a blacklisted sanitized phone number is a mobile number.Helps distinguish which number is blacklisted when there is both a mobile and phone field in a model. | ||
name |
varchar2 |
Name | |||
opt_ |
boolean |
Opt Out | Opt out flag for a specific mailing list.This field should not be used in a view without a unique and active mailing list context. | ||
phone_ |
boolean |
Blacklisted Phone is Phone | Indicates if a blacklisted sanitized phone number is a phone number.Helps distinguish which number is blacklisted when there is both a mobile and phone field in a model. | ||
phone_ |
varchar2 |
Phone/Mobile | |||
phone_ |
varchar2 |
Sanitized Number | Field used to store sanitized phone number.Helps speeding up searches and comparisons. | ||
phone_ |
boolean |
Phone Blacklisted | If the sanitized phone number is on the blacklist, the contact won't receive mass mailing sms anymore, from any list | ||
subscription_ |
varchar2 |
||||
tag_ |
varchar2 |
||||
title_ |
varchar2 |
||||
title_ |
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: