mail_server: Odoo itgen_odoo_mail_server
read only per partition
- Catalog:
Odoo - Schema:
ir - Label: itgen_odoo_mail_server
Mail Server
Can only retrieve data.
Summary
Represents an SMTP server, able to send outgoing emails, with SSL and TLS capabilities.
Table Columns
The columns of the table mail_server 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 |
|---|---|---|---|---|---|
active |
boolean |
Active | |||
active_ |
varchar2 |
||||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
display_ |
varchar2 |
Display Name | |||
from_ |
varchar2 |
FROM Filtering | Define for which email address or domain this server can be used. e.g.: "notification@odoo.com" or "odoo.com" | ||
google_ |
varchar2 |
Access Token | |||
google_ |
int32 |
Access Token Expiration Timestamp | |||
google_ |
varchar2 |
Authorization Code | |||
google_ |
varchar2 |
Refresh Token | |||
google_ |
varchar2 |
URI | The URL to generate the authorization code from Google | ||
id |
int32 |
ID | |||
mail_ |
varchar2 |
||||
name |
varchar2 |
Name | |||
sequence |
int32 |
Priority | When no specific mail server is requested for a mail, the highest priority one is used. Default priority is 10 (smaller number = higher priority) | ||
smtp_ |
varchar2 |
Authenticate with | |||
smtp_ |
varchar2 |
Authentication Info | |||
smtp_ |
boolean |
Debugging | If enabled, the full output of SMTP sessions will be written to the server log at DEBUG level (this is very verbose and may include confidential info!) | ||
smtp_ |
varchar2 |
Connection Encryption | Choose the connection encryption scheme: - None: SMTP sessions are done in cleartext. - TLS (STARTTLS): TLS encryption is requested at start of SMTP session (Recommended) - SSL/TLS: SMTP sessions are encrypted with SSL/TLS through a dedicated port (default: 465) | ||
smtp_ |
varchar2 |
SMTP Server | Hostname or IP of SMTP server | ||
smtp_ |
varchar2 |
Password | Optional password for SMTP authentication | ||
smtp_ |
int32 |
SMTP Port | SMTP Port. Usually 465 for SSL, and 25 or 587 for other cases. | ||
smtp_ |
varbinary |
SSL Certificate | SSL certificate used for authentication | ||
smtp_ |
varbinary |
SSL Private Key | SSL private key used for authentication | ||
smtp_ |
varchar2 |
Username | Optional username for SMTP authentication | ||
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: