invantive documentation
Invantive Support ForumsLog In / Sign Up

mailing: Odoo itgen_odoo_mailing

read only per partition

  • Catalog: Odoo
  • Schema: mailing
  • Label: itgen_odoo_mailing

Mass Mailing

Can only retrieve data.

Summary

MassMailing models a wave of emails for a mass mailign campaign. A mass mailing is an occurence of sending emails.

Table Columns

The columns of the table mailing 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
ab_testing_completed boolean A/B Testing Campaign Finished
ab_testing_description varchar2 A/B Testing Description
ab_testing_enabled boolean Allow A/B Testing If checked, recipients will be mailed only once for the whole campaign. This lets you send different mailings to randomly selected recipients and test the effectiveness of the mailings, without causing duplicate messages.
ab_testing_mailings_count int32 A/B Test Mailings #
ab_testing_pc int32 A/B Testing percentage Percentage of the contacts that will be mailed. Recipients will be chosen randomly.
ab_testing_schedule_datetime datetime Send Final On Date that will be used to know when to determine and send the winner mailing
ab_testing_sms_winner_selection varchar2 SMS Winner Selection
ab_testing_winner_selection varchar2 Winner Selection Selection to determine the winner mailing that will be sent.
active boolean Active
activity_calendar_event_id varchar2
activity_calendar_event_id_label varchar2
activity_date_deadline datetime Next Activity Deadline
activity_exception_decoration varchar2 Activity Exception Decoration Type of the exception activity on record.
activity_exception_icon varchar2 Icon Icon to indicate an exception activity.
activity_ids varchar2
activity_state varchar2 Activity State Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities.
activity_summary varchar2 Next Activity Summary
activity_type_icon varchar2 Activity Type Icon Font awesome icon e.g. fa-tasks
activity_type_id varchar2
activity_type_id_label varchar2
activity_user_id varchar2
activity_user_id_label varchar2
attachment_ids varchar2
body_arch varchar2 Body
body_html varchar2 Body converted to be sent by mail
body_plaintext varchar2 SMS Body
bounced int32 Bounced
bounced_ratio int32 Bounced Ratio
calendar_date datetime Calendar Date Date at which the mailing was or will be sent.
campaign_id varchar2
campaign_id_label varchar2
canceled int32 Canceled
clicked int32 Clicked
clicks_ratio int32 Number of Clicks
color int32 Color Index
contact_list_ids varchar2
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
crm_lead_count int32 Leads/Opportunities Count
delivered int32 Delivered
display_name varchar2 Display Name
email_from varchar2 Send From
expected int32 Expected
failed int32 Failed
favorite boolean Favorite
favorite_date datetime Favorite Date When this mailing was added in the favorites
has_message boolean Has Message
id int32 ID
is_body_empty boolean Is Body Empty
keep_archives boolean Keep Archives
kpi_mail_required boolean KPI mail required
lang varchar2 Language Optional translation language (ISO code) to select when sending out an email. If not set, the english version will be used. This should usually be a placeholder expression that provides the appropriate language, e.g. {{ object.partner_id.lang }}.
mail_server_available boolean Mail Server Available Technical field used to know if the user has activated the outgoing mail server option in the settings
mail_server_id varchar2 Use a specific mail server in priority. Otherwise Odoo relies on the first outgoing mail server available (based on their sequencing) as it does for normal mails.
mail_server_id_label varchar2 Use a specific mail server in priority. Otherwise Odoo relies on the first outgoing mail server available (based on their sequencing) as it does for normal mails.
mailing_domain varchar2 Domain
mailing_filter_count int32 # Favorite Filters
mailing_filter_domain varchar2 Favorite filter domain
mailing_filter_id varchar2
mailing_filter_id_label varchar2
mailing_model_id varchar2
mailing_model_id_label varchar2
mailing_model_name varchar2 Recipients Model Name
mailing_model_real varchar2 Recipients Real Model
mailing_on_mailing_list boolean Based on Mailing Lists
mailing_trace_ids varchar2
mailing_type varchar2 Mailing Type
mailing_type_description varchar2 Mailing Type Description
marketing_activity_ids varchar2
medium_id varchar2 UTM Medium: delivery method (email, sms, ...)
medium_id_label varchar2 UTM Medium: delivery method (email, sms, ...)
message_attachment_count int32 Attachment Count
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
my_activity_date_deadline datetime My Activity Deadline
name varchar2 Name
next_departure datetime Scheduled date
opened int32 Opened
opened_ratio int32 Opened Ratio
preview varchar2 Preview Catchy preview sentence that encourages recipients to open this email. In most inboxes, this is displayed next to the subject. Keep it empty if you prefer the first characters of your email content to appear instead.
received_ratio int32 Received Ratio
render_model varchar2 Rendering Model
replied int32 Replied
replied_ratio int32 Replied Ratio
reply_to varchar2 Reply To Preferred Reply-To Address
reply_to_mode varchar2 Reply-To Mode Thread: replies go to target document. Email: replies are routed to a given email.
sale_invoiced_amount int32 Invoiced Amount
sale_quotation_count int32 Quotation Count
schedule_date datetime Scheduled for
schedule_type varchar2 Schedule
scheduled int32 Scheduled
sent int32 Sent
sent_date datetime Sent Date
sms_allow_unsubscribe boolean Include opt-out link
sms_force_send boolean Send Directly Immediately send the SMS Mailing instead of queuing up. Use at your own risk.
sms_has_insufficient_credit boolean Insufficient IAP credits
sms_has_unregistered_account boolean Unregistered IAP account
sms_subject varchar2 Title For an email, the subject your recipients will see in their inbox. For an SMS, the internal title of the message.
sms_template_id varchar2
sms_template_id_label varchar2
source_id varchar2
source_id_label varchar2
state varchar2 Status
subject varchar2 Subject
total int32 Total
use_in_marketing_automation boolean Specific mailing used in marketing campaign Marketing campaigns use mass mailings with some specific behavior; this field is used to indicate its statistics may be suspicious.
use_leads boolean Use Leads
user_id varchar2
user_id_label varchar2
warning_message varchar2 Warning Message Warning message displayed in the mailing form view
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: