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_ |
varchar2 |
||||
author_ |
varbinary |
Author's avatar | |||
author_ |
varchar2 |
||||
author_ |
varchar2 |
||||
author_ |
varchar2 |
Author of the message. If not set, email_from may hold an email address that did not match any partner. | |||
author_ |
varchar2 |
Author of the message. If not set, email_from may hold an email address that did not match any partner. | |||
auto_ |
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_ |
varchar2 |
Rich-text Contents | Rich-text/HTML message | ||
canned_ |
varchar2 |
||||
child_ |
varchar2 |
||||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
date |
datetime |
Date | |||
description |
varchar2 |
Short description | Message description: either the subject, or the beginning of the body | ||
display_ |
varchar2 |
Display Name | |||
email_ |
boolean |
Email Add Signature | |||
email_ |
varchar2 |
Cc | Carbon copy message recipients | ||
email_ |
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_ |
varchar2 |
Layout | |||
email_ |
varchar2 |
To | Message recipients (emails) | ||
failure_ |
varchar2 |
Failure Reason | Failure reason. This is usually the exception thrown by the email server, stored to ease the debugging of mailing issues. | ||
failure_ |
varchar2 |
Failure type | |||
fetchmail_ |
varchar2 |
||||
fetchmail_ |
varchar2 |
||||
has_ |
boolean |
Has error | |||
has_ |
boolean |
Has SMS error | |||
headers |
varchar2 |
Headers | |||
id |
int32 |
ID | |||
is_ |
boolean |
Is Current User Or Guest Author | |||
is_ |
boolean |
Employee Only | Hide to public / portal users, independently from subtype configuration. | ||
is_ |
boolean |
Notification Email | Mail has been created to notify people of an existing mail.message | ||
letter_ |
varchar2 |
||||
link_ |
varchar2 |
||||
mail_ |
varchar2 |
||||
mail_ |
varchar2 |
||||
mail_ |
varchar2 |
||||
mail_ |
varchar2 |
||||
mail_ |
int32 |
Mail Message Id Int | |||
mail_ |
varchar2 |
||||
mail_ |
varchar2 |
||||
mail_ |
varchar2 |
||||
mailing_ |
varchar2 |
||||
mailing_ |
varchar2 |
||||
mailing_ |
varchar2 |
||||
message_ |
varchar2 |
Message-Id | Message unique identifier | ||
message_ |
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_ |
varchar2 |
||||
notified_ |
varchar2 |
||||
parent_ |
varchar2 |
||||
parent_ |
varchar2 |
||||
partner_ |
varchar2 |
||||
preview |
varchar2 |
Preview | The text-only beginning of the body used as email preview. | ||
rating_ |
varchar2 |
||||
rating_ |
numeric |
Rating Value | |||
reaction_ |
varchar2 |
||||
recipient_ |
varchar2 |
||||
record_ |
varchar2 |
Message Record Name | |||
references |
varchar2 |
References | Message references, such as identifiers of previous messages | ||
reply_ |
varchar2 |
Reply-To | Reply email address. Setting the reply_to bypasses the automatic thread creation. | ||
reply_ |
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_ |
int32 |
Restricted attachments | |||
scheduled_ |
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_ |
boolean |
Snailmail message in error | |||
starred |
boolean |
Starred | Current user has a starred notification linked to this message | ||
starred_ |
varchar2 |
||||
state |
varchar2 |
Status | |||
subject |
varchar2 |
Subject | |||
subtype_ |
varchar2 |
||||
subtype_ |
varchar2 |
||||
to_ |
boolean |
To Delete | If set, the mail will be deleted during the next Email Queue CRON run. | ||
tracking_ |
varchar2 |
Tracked values are stored in a separate model. This field allow to reconstruct the tracking and to generate statistics on the model. | |||
unrestricted_ |
varchar2 |
||||
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: