invantive documentation
Invantive Support ForumsLog In / Sign Up

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_name varchar2 Company Name
country_id varchar2
country_id_label varchar2
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
display_name varchar2 Display Name
email varchar2 Email
email_normalized 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_message boolean Has Message
id int32 ID
is_blacklisted boolean Blacklist If the email address is on the blacklist, the contact won't receive mass mailing anymore, from any list
list_ids varchar2
message_attachment_count int32 Attachment Count
message_bounce int32 Bounce Counter of the number of bounced emails for this contact
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 Number of Actions Number of messages which requires an action
message_partner_ids varchar2
mobile varchar2 Mobile
mobile_blacklisted 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_out 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_blacklisted 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_mobile_search varchar2 Phone/Mobile
phone_sanitized varchar2 Sanitized Number Field used to store sanitized phone number. Helps speeding up searches and comparisons.
phone_sanitized_blacklisted 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_list_ids varchar2
tag_ids varchar2
title_id varchar2
title_id_label varchar2
website_message_ids varchar2 Website communication history
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: