CR
CRSMEmail
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AllDay | bit | All Day | - | |
Description:Specifies whether this event is an all-day event. | ||||
Application | int | Originated By | - | |
Description:The EPActivityType.application of original Activity Type Corresponds to the value of the EPActivityType.Application field. | ||||
BAccountID | int | Related Account | BAccount | |
Description:The identifier of the related business account. Along with ContactID, this field is used as an additional reference, but unlike RefNoteID and DocumentNoteID it is used for specific entities. Corresponds to the value of the BAccount.BAccountID field. | ||||
BatchId | nvarchar(255) | Batch ID | - | |
Description:No description available | ||||
Body | nvarchar | Activity Details | - | |
Description:The HTML body of the activity. | ||||
BypassSuppressionChecks | bit | Bypass Suppression Checks | - | |
Description:No description available | ||||
Categories | nvarchar(2568) | Categories | - | |
Description:No description available | ||||
CategoryID | int | Category | EPEventCategory | |
Description:The identifier of the task or event category. Corresponds to the value of the EPEventCategory.CategoryID field. | ||||
ClassID | int | Class | - | |
Description:The class of the activity. The field can have one of the values listed in the CRActivityClass class. The default values are CRActivityClass.Activity for the CRActivityMaint graph, CRActivityClass.Task for the CRTaskMaint graph, CRActivityClass.Event for the EPEventMaint graph, and CRActivityClass.Email for the CREmailActivityMaint graph. This field must be specified at the initialization of an email and not be changed afterwards. | ||||
ClassIconNonexistent in DB | string | Class Icon | - | |
Description:The URL of the icon that corresponds to the ClassID of the activity. The icon is displayed in a grid to indicate the activity type. The available values are listed in the classIcon class. | ||||
ClassInfoNonexistent in DB | string | Type | - | |
Description:No description available | ||||
ClearedBodyNonexistent in DB | string | Cleared Body | - | |
Description:No description available | ||||
CommentBodyNonexistent in DB | string | Activity Details | - | |
Description:No description available | ||||
CommentStartDateNonexistent in DB | DateTime? | Start Date | - | |
Description:No description available | ||||
CommentSubjectNonexistent in DB | string | Summary | - | |
Description:No description available | ||||
CommentTypeNonexistent in DB | string | Type | EPActivityType | |
Description:No description available | ||||
CompletedDate | datetime | Completed On | - | |
Description:The date and time when activity was completed (UIStatus was set to ActivityStatusListAttribute.Completed). | ||||
ContactID | int | Related Contact | Contact | |
Description:The identifier of the related contact. Along with BAccountID, this field is used as an additional reference, but unlike RefNoteID and DocumentNoteID it is used for specific entities. Corresponds to the value of the Contact.ContactID field. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created At | - | |
Description:No description available | ||||
DayOfWeekNonexistent in DB | int? | Day Of Week | - | |
Description:The day of week of StartDate. The field is calculated automatically on the basis of StartDate. The following values are possible: null (when StartDate is null), and the values defined by the System.DayOfWeek enumeration and converted to int. | ||||
DeletedDatabaseRecord | bit | - | ||
Description:No description available | ||||
DocumentNoteID | uniqueidentifier | Related Document | - | |
Description:The INotable.NoteID value of the related document. It is similar to RefNoteID, but contains an additional reference to the source of the activity (usually the source of the activity is a document). For example, the (CRMassMailMaint) graph fills this value with a link to the source CRCampaign or CRMarketingList object. | ||||
DocumentSourceNonexistent in DB | string | Related Document | - | |
Description:No description available | ||||
EmailCreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
EmailCreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
EmailCreatedDateTime | datetime | Created At | - | |
Description:No description available | ||||
EmailLastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
EmailLastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
EmailLastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
EmailNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
EmailRefNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
EmailSubject | nvarchar(256) | Summary | - | |
Description:No description available | ||||
EndDate | datetime | End Date | - | |
Description:The end date and time of the event. | ||||
EntityDescriptionNonexistent in DB | string | Entity | - | |
Description:Returns either additional information about the related entity or the last error message. The property is used by the CREmailActivityMaint graph to show additional infomation about the SMEmail status. | ||||
Exception | nvarchar | Error Message | - | |
Description:No description available | ||||
ExchangeTaskListName | nvarchar(50) | Exchange Task List Name | - | |
Description:No description available | ||||
Format | nvarchar(255) | Format | - | |
Description:No description available | ||||
ID | int | - | ||
Description:No description available | ||||
ImapUID | int | - | ||
Description:No description available | ||||
ImcUID | uniqueidentifier | - | ||
Description:No description available | ||||
Incoming | bit | Incoming | - | |
Description:Specifies whether this activity is incoming. The value is equal to EPActivityType.Incoming of the current Type. | ||||
IsArchived | bit | Archived | - | |
Description:No description available | ||||
IsCompleteIconNonexistent in DB | string | Complete Icon | - | |
Description:The URL of the icon for a completed activity (UIStatus is ActivityStatusListAttribute.Completed). | ||||
IsExternal | bit | - | ||
Description:Specifies whether this activity was created by an external user on the portal. | ||||
IsFinalAnswer | bit | Final Answer | - | |
Description:No description available | ||||
IsIncome | bit | Is Income | - | |
Description:No description available | ||||
IsLocked | bit | Is Locked | - | |
Description:No description available | ||||
IsOverdueNonexistent in DB | bool? | - | ||
Description:Indicates whether the activity is overdue (the UIStatus is neither ActivityStatusListAttribute.Completed nor ActivityStatusListAttribute.Canceled and EndDate is passed). | ||||
IsPinned | nvarchar | Is Pinned | - | |
Description:No description available | ||||
IsPrivate | bit | Internal | - | |
Description:Specifies whether this activity is hidden from external users and not visible on the portal site. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
Location | nvarchar(255) | Location | - | |
Description:The location of the event. | ||||
MPStatus | char(2) | Email Status | - | |
Description:No description available | ||||
MailAccountID | int | From | EMailAccount | |
Description:No description available | ||||
MailBcc | nvarchar | BCC | - | |
Description:No description available | ||||
MailCc | nvarchar | CC | - | |
Description:No description available | ||||
MailDate | datetime | - | ||
Description:No description available | ||||
MailFrom | nvarchar | From | - | |
Description:No description available | ||||
MailReply | nvarchar | Reply | - | |
Description:No description available | ||||
MailTo | nvarchar | To | - | |
Description:No description available | ||||
MessageId | nvarchar(255) | - | ||
Description:No description available | ||||
MessageReference | nvarchar | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | ID | - | |
Description:No description available | ||||
Outgoing | bit | Outgoing | - | |
Description:Specifies whether this activity is outgoing. The value is equal to EPActivityType.Outgoing of the current Type. | ||||
OwnerID | int | Owner | Contact | |
Description:No description available | ||||
ParentNoteID | uniqueidentifier | Task | Contact | |
Description:The identifier of the parent task or event of the current activity. Corresponds to the value of the NoteID field. | ||||
PercentCompletion | int | Completion (%) | - | |
Description:The estimation of the task completion expressed as a percentage. | ||||
Pop3UID | nvarchar(150) | - | ||
Description:No description available | ||||
Priority | int | Priority | - | |
Description:The priority of the activity. | ||||
PriorityIconNonexistent in DB | string | Priority Icon | - | |
Description:The URL of the icon to indicate the Priority of the activity. The field can have one of the values listed in the priorityIcon class. If the value is null, no icon is used. | ||||
ProvidesCaseSolution | bit | Case Solution Provided | - | |
Description:Specifies whether this activity is provides case solution or not. | ||||
RecipientNotes | nvarchar | Recipient Notes | - | |
Description:No description available | ||||
RefNoteID | uniqueidentifier | Related Entity | CRActivityStatistics | |
Description:Contains the INotable.NoteID value of the related entity. This activity is displayed on the Activities tab of the entity's form. The related document may or may not implement the INotable interface, but it must have a field marked with the PXNoteAttribute attribute with the PXNoteAttribute.ShowInReferenceSelector property set to true. | ||||
RefNoteIDTypeNonexistent in DB | string | Related Entity Type | - | |
Description:Contains the type of the related entity, that is specified in CRActivity.RefNoteID. | ||||
ReportFormat | nvarchar(10) | Format | - | |
Description:No description available | ||||
ResponseActivityNoteID | uniqueidentifier | Response Provided In | Contact | |
Description:The identifier of the activity that is a response to the current activity. | ||||
ResponseDueDateTime | datetime | Response Due | - | |
Description:The due date and time for the response to the current activity. | ||||
ResponseToNoteID | uniqueidentifier | In Response To | SMEmail | |
Description:Email SMEmail.NoteID in response to which a new incoming (or outgoing) email was created | ||||
RetryCount | int | - | ||
Description:No description available | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
SelectorDescriptionNonexistent in DB | string | Description | - | |
Description:No description available | ||||
SendAt | datetime | Send At | - | |
Description:No description available | ||||
ShowAsID | int | Show As | - | |
Description:The event status to be displayed on your schedule if it is public. | ||||
SourceNonexistent in DB | string | Related Entity | - | |
Description:The description of the entity whose NoteID value is specified as RefNoteID. The description is retrieved by the GetEntityDescription(Guid?, System.Type) method. | ||||
StartDate | datetime | Start Date | - | |
Description:The start date and time of the event. | ||||
Subject | nvarchar(256) | Summary | - | |
Description:The summary description of the activity. | ||||
Synchronize | bit | Synchronize | - | |
Description:Specifies whether the activity should be included in the exchange synchronization. The value is used in the exchange integration (see FeaturesSet.ExchangeIntegration). The default value is true. | ||||
Ticket | int | - | ||
Description:No description available | ||||
TimeZone | nvarchar(32) | Time Zone | - | |
Description:The custom time zone of the activity. The field can have one of the values described in PXTimeZoneAttribute. If it does not set to null then adjusts StartDate and EndDate field values to the specified time zone. It is currently used only by EPEventMaint. | ||||
TrackClicksInEmail | bit | Track Clicks in Email | - | |
Description:No description available | ||||
TrackEmailOpens | bit | Track Email Opens | - | |
Description:No description available | ||||
Type | char(5) | Type | EPActivityType | |
Description:The type of the activity. Corresponds to the value of the EPActivityType.Type field. | ||||
UIStatus | char(2) | Status | - | |
Description:The status of the activity. The field can have one of the values listed in the ActivityStatusListAttribute class. The default value is ActivityStatusListAttribute.Open. | ||||
WorkgroupID | int | Workgroup | EPCompanyTree | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||