contact: Odoo itgen_odoo_contact
read only per partition
- Catalog:
Odoo - Schema:
mailing - Label: itgen_odoo_contact
Mailing Contact
Can only retrieve data.
Summary
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.
Table Columns
The columns of the table contact are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
company_ |
varchar2 |
Company Name | |||
country_ |
varchar2 |
||||
country_ |
varchar2 |
||||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
display_ |
varchar2 |
Display Name | |||
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 |
Attachment Count | |||
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 |
Number of Actions | 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 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: