invantive documentation
Invantive Support ForumsLog In / Sign Up

mail: Odoo itgen_odoo_mail

read only per partition

  • Catalog: Odoo
  • Schema: mail
  • Label: itgen_odoo_mail

Outgoing Mails

Can only retrieve data.

Summary

Add the mass mailing campaign data to mail

Table Columns

The columns of the table mail 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
attachment_ids varchar2
author_avatar varbinary Author's avatar
author_guest_id varchar2
author_guest_id_label varchar2
author_id varchar2 Author of the message. If not set, email_from may hold an email address that did not match any partner.
author_id_label varchar2 Author of the message. If not set, email_from may hold an email address that did not match any partner.
auto_delete boolean Auto Delete This option permanently removes any track of email after it's been sent, including from the Technical menu in the Settings, in order to preserve storage space of your Odoo database.
body varchar2 Contents
body_html varchar2 Rich-text Contents Rich-text/HTML message
canned_response_ids varchar2
child_ids varchar2
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
date datetime Date
description varchar2 Short description Message description: either the subject, or the beginning of the body
display_name varchar2 Display Name
email_add_signature boolean Email Add Signature
email_cc varchar2 Cc Carbon copy message recipients
email_from varchar2 From Email address of the sender. This field is set when no matching partner is found and replaces the author_id field in the chatter.
email_layout_xmlid varchar2 Layout
email_to varchar2 To Message recipients (emails)
failure_reason varchar2 Failure Reason Failure reason. This is usually the exception thrown by the email server, stored to ease the debugging of mailing issues.
failure_type varchar2 Failure type
fetchmail_server_id varchar2
fetchmail_server_id_label varchar2
has_error boolean Has error
has_sms_error boolean Has SMS error
headers varchar2 Headers
id int32 ID
is_current_user_or_guest_author boolean Is Current User Or Guest Author
is_internal boolean Employee Only Hide to public / portal users, independently from subtype configuration.
is_notification boolean Notification Email Mail has been created to notify people of an existing mail.message
letter_ids varchar2
link_preview_ids varchar2
mail_activity_type_id varchar2
mail_activity_type_id_label varchar2
mail_ids varchar2
mail_message_id varchar2
mail_message_id_int int32 Mail Message Id Int
mail_message_id_label varchar2
mail_server_id varchar2
mail_server_id_label varchar2
mailing_id varchar2
mailing_id_label varchar2
mailing_trace_ids varchar2
message_id varchar2 Message-Id Message unique identifier
message_type varchar2 Type Message type: email for email message, notification for system message, comment for other messages such as user replies
model varchar2 Related Document Model
needaction boolean Need Action
notification_ids varchar2
notified_partner_ids varchar2
parent_id varchar2
parent_id_label varchar2
partner_ids varchar2
preview varchar2 Preview The text-only beginning of the body used as email preview.
rating_ids varchar2
rating_value numeric Rating Value
reaction_ids varchar2
recipient_ids varchar2
record_name varchar2 Message Record Name
references varchar2 References Message references, such as identifiers of previous messages
reply_to varchar2 Reply-To Reply email address. Setting the reply_to bypasses the automatic thread creation.
reply_to_force_new boolean No threading for answers If true, answers do not go in the original document discussion thread. Instead, it will check for the reply_to in tracking message-id and redirected accordingly. This has an impact on the generated message-id.
res_id int32 Related Document ID
restricted_attachment_count int32 Restricted attachments
scheduled_date datetime Scheduled Send Date If set, the queue manager will send the email after the date. If not set, the email will be send as soon as possible. Unless a timezone is specified, it is considered as being in UTC timezone.
snailmail_error boolean Snailmail message in error
starred boolean Starred Current user has a starred notification linked to this message
starred_partner_ids varchar2
state varchar2 Status
subject varchar2 Subject
subtype_id varchar2
subtype_id_label varchar2
to_delete boolean To Delete If set, the mail will be deleted during the next Email Queue CRON run.
tracking_value_ids varchar2 Tracked values are stored in a separate model. This field allow to reconstruct the tracking and to generate statistics on the model.
unrestricted_attachment_ids varchar2
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: