Table of Contents

Table Mail_Messages

Entity

Entity: Applications.Mail.Messages

Represents email messages. Entity: Mail_Messages

Summary

Name Type Description
Body nvarchar(max) The body of the message
Cc_Email_Address_List nvarchar(2048) Semicolon-separated list of Cc email addresses
Creation_Date_Time datetime Date and time when the message was created
From_Email_Address nvarchar(512) Sending email address
Is_Encrypted bit 1 when the message is stored in encrypted format
Is_Read bit 1 when the message was read by the user
Mail_Box_Folder_Id uniqueidentifier The folder where the message belongs
Mail_Message_Id uniqueidentifier PK
Received_Date_Time datetime Date and time when the message was received
Related_To_Party_Id uniqueidentifier The party id of the external participating (sender/receiver) party (customer, supplier, etc.) in this mail. NULL means that the email is still not related to any specific party
Row_Version timestamp
Sent_Date_Time datetime Date and time when the message was sent
Server_Message_ID nvarchar(256) Message ID as it appears on the mail server
Subject nvarchar(1024) The message subject
To_Email_Address_List nvarchar(2048) Semicolon-separated list of receiving email addresses

Columns

Body

The body of the message

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 2147483647
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(max) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Cc_Email_Address_List

Semicolon-separated list of Cc email addresses

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 2048
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(2048) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Cc_Email_Address_List - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Like None no no

Creation_Date_Time

Date and time when the message was created

Property Value
Auto Complete no
Data Filter no
Default Value CurrentDateTime
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type datetime
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Creation_Date_Time - Supported Filters

Filter Type Default Include Nulls Hidden by Default
GreaterThanOrLessThan None no no

From_Email_Address

Sending email address

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 512
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(512)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

From_Email_Address - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Like None no no

Is_Encrypted

1 when the message is stored in encrypted format

Property Value
Auto Complete no
Data Filter no
Default Value False
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type bit
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Is_Encrypted - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Is_Read

1 when the message was read by the user

Property Value
Auto Complete no
Data Filter no
Default Value False
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type bit
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Is_Read - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Mail_Box_Folder_Id

The folder where the message belongs

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Mail_Box_Folders
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Mail_Box_Folder_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Mail_Message_Id

Property Value
Auto Complete no
Data Filter no
Default Value NewGuid
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key yes (order: 1)
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Mail_Message_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no yes

Received_Date_Time

Date and time when the message was received

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type datetime (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Received_Date_Time - Supported Filters

Filter Type Default Include Nulls Hidden by Default
GreaterThanOrLessThan None no no

The party id of the external participating (sender/receiver) party (customer, supplier, etc.) in this mail. NULL means that the email is still not related to any specific party

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Gen_Parties
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Related_To_Party_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes no

Row_Version

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type timestamp
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Sent_Date_Time

Date and time when the message was sent

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type datetime (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Sent_Date_Time - Supported Filters

Filter Type Default Include Nulls Hidden by Default
GreaterThanOrLessThan None no no

Server_Message_ID

Message ID as it appears on the mail server

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 256
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable yes
Summary Type None
Supports EQUALS_IN no
Type nvarchar(256) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Server_Message_ID - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes no

Subject

The message subject

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 1024
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(1024) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Subject - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Like None no no

To_Email_Address_List

Semicolon-separated list of receiving email addresses

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 2048
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(2048) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

To_Email_Address_List - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Like None no no
Suggest improvement to this page