invantive documentation
Invantive Support ForumsLog In / Sign Up

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_mailing_ids varchar2
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
display_name varchar2 Display Name
from_filter varchar2 FROM Filtering Define for which email address or domain this server can be used. e.g.: "notification@odoo.com" or "odoo.com"
google_gmail_access_token varchar2 Access Token
google_gmail_access_token_expiration int32 Access Token Expiration Timestamp
google_gmail_authorization_code varchar2 Authorization Code
google_gmail_refresh_token varchar2 Refresh Token
google_gmail_uri varchar2 URI The URL to generate the authorization code from Google
id int32 ID
mail_template_ids 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_authentication varchar2 Authenticate with
smtp_authentication_info varchar2 Authentication Info
smtp_debug 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_encryption 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_host varchar2 SMTP Server Hostname or IP of SMTP server
smtp_pass varchar2 Password Optional password for SMTP authentication
smtp_port int32 SMTP Port SMTP Port. Usually 465 for SSL, and 25 or 587 for other cases.
smtp_ssl_certificate varbinary SSL Certificate SSL certificate used for authentication
smtp_ssl_private_key varbinary SSL Private Key SSL private key used for authentication
smtp_user varchar2 Username Optional username for SMTP authentication
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: