SM
SMEmail
PX.SM.AU32 of 32 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
Body | nvarchar(MAX) | Activity Details | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created At | - | |
Description:No description available | ||||
Exception | nvarchar(MAX) | Error Message | - | |
Description:No description available | ||||
Format | char(1) | Format | - | |
Description:No description available | ||||
ID | int | ID | - | |
Description:No description available | ||||
ImapUID | int | ImapUID | - | |
Description:No description available | ||||
ImcUID | uniqueidentifier | ImcUID | - | |
Description:No description available | ||||
IsArchived | bit | - | ||
Description:No description available | ||||
IsIncome | bit | Is Income | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
MailAccountID | int | From | EMailAccount | |
Description:No description available | ||||
MailBcc | nvarchar(3000) | BCC | - | |
Description:No description available | ||||
MailCc | nvarchar(3000) | CC | - | |
Description:No description available | ||||
MailDate | datetime | - | ||
Description:No description available | ||||
MailFrom | nvarchar(500) | From | - | |
Description:No description available | ||||
MailReply | nvarchar(500) | Reply | - | |
Description:No description available | ||||
MailTo | nvarchar(3000) | To | - | |
Description:No description available | ||||
MessageId | nvarchar(255) | MessageId | - | |
Description:No description available | ||||
MessageReference | varchar(MAX) | MessageReference | - | |
Description:No description available | ||||
MPStatus | char(2) | Email Status | - | |
Description:No description available | ||||
Pop3UID | nvarchar(150) | Pop3UID | - | |
Description:No description available | ||||
RefNoteID | uniqueidentifier | CRActivity | ||
Description:No description available | ||||
ReportFormat | varchar(10) | Format | - | |
Description:No description available | ||||
RetryCount | int | RetryCount | - | |
Description:No description available | ||||
Subject | nvarchar(998) | Summary | - | |
Description:No description available | ||||
Ticket | int | Ticket | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||