Email table/entity reference (Microsoft Dataverse)

Activity that is delivered using email protocols.

Messages

The following table lists the messages for the Email table. Messages represent operations that can be performed on the table. They may also be events.

Name Is Event?	Web API Operation	SDK for .NET
Assign Event: True	PATCH /emails(activityid) Update the ownerid property.	AssignRequest
Associate Event: True	Associate records	Associate records
BackgroundSendEmail Event: True	BackgroundSendEmail	BackgroundSendEmailRequest
CheckIncomingEmail Event: True	CheckIncomingEmail	CheckIncomingEmailRequest
CheckPromoteEmail Event: True	CheckPromoteEmail	CheckPromoteEmailRequest
Create Event: True	POST /emails See Create	Create records
Delete Event: True	DELETE /emails(activityid) See Delete	Delete records
DeliverImmediatePromoteEmail Event: True	DeliverImmediatePromoteEmail	DeliverImmediatePromoteEmailRequest
DeliverIncomingEmail Event: True	DeliverIncomingEmail	DeliverIncomingEmailRequest
DeliverPromoteEmail Event: True	DeliverPromoteEmail	DeliverPromoteEmailRequest
Disassociate Event: True	Disassociate records	Disassociate records
GetDecryptionKey Event: False		GetDecryptionKeyRequest
GetTrackingTokenEmail Event: False	GetTrackingTokenEmail	GetTrackingTokenEmailRequest
GrantAccess Event: True	GrantAccess	GrantAccessRequest
ModifyAccess Event: True	ModifyAccess	ModifyAccessRequest
Retrieve Event: True	GET /emails(activityid) See Retrieve	Retrieve records
RetrieveMultiple Event: True	GET /emails See Query data	Query data
RetrievePrincipalAccess Event: True	RetrievePrincipalAccess	RetrievePrincipalAccessRequest
RetrieveSharedPrincipalsAndAccess Event: True	RetrieveSharedPrincipalsAndAccess	RetrieveSharedPrincipalsAndAccessRequest
RevokeAccess Event: True	RevokeAccess	RevokeAccessRequest
SendEmail Event: True	SendEmail	SendEmailRequest
SendEmailFromTemplate Event: True	SendEmailFromTemplate	SendEmailFromTemplateRequest
SendFax Event: True	SendFax	SendFaxRequest
SendTemplate Event: True	SendTemplate	SendTemplateRequest
SetState Event: True	PATCH /emails(activityid) Update the statecode and statuscode properties.	SetStateRequest
Update Event: True	PATCH /emails(activityid) See Update	Update records
Upsert Event: False	PATCH /emails(activityid) See Upsert a table row	UpsertRequest

Properties

The following table lists selected properties for the Email table.

Property	Value
DisplayName	Email
DisplayCollectionName	Email Messages
SchemaName	Email
CollectionSchemaName	Emails
EntitySetName	emails
LogicalName	email
LogicalCollectionName	emails
PrimaryIdAttribute	activityid
PrimaryNameAttribute	subject
TableType	Standard
OwnershipType	UserOwned

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

• AcceptingEntityId
• AcceptingEntityTypeCode
• ActivityAdditionalParams
• ActivityId
• ActualDurationMinutes
• ActualEnd
• ActualStart
• AttachmentOpenCount
• BaseConversationIndexHash
• bcc
• Category
• cc
• ConversationTrackingId
• CorrelatedActivityId
• correlatedsubjectchanged
• DelayedEmailSendTime
• DeliveryAttempts
• DeliveryPriorityCode
• DeliveryReceiptRequested
• Description
• DirectionCode
• EmailReminderExpiryTime
• EmailReminderText
• EmailReminderType
• EmailTrackingId
• FollowEmailUserPreference
• from
• ImportSequenceNumber
• InternetMessageHeaders
• IsBilled
• IsDuplicateSenderUnresolved
• IsWorkflowCreated
• LastOnHoldTime
• LastOpenedTime
• LinksClickedCount
• MessageId
• MessageIdDupCheck
• MimeType
• Notifications
• OpenCount
• OverriddenCreatedOn
• OwnerId
• OwnerIdType
• ParentActivityId
• PriorityCode
• ProcessId
• ReadReceiptRequested
• ReceivingMailboxId
• RegardingObjectId
• RegardingObjectTypeCode
• related
• ReminderActionCardId
• ReservedForInternalUse
• ScheduledEnd
• ScheduledStart
• Sender
• SLAId
• SortDate
• StageId
• StateCode
• StatusCode
• Subcategory
• Subject
• SubmittedBy
• TemplateId
• TimeZoneRuleVersionNumber
• to
• ToRecipients
• TrackingToken
• TransactionCurrencyId
• TraversedPath
• UTCConversionTimeZoneCode

AcceptingEntityId

Property	Value
Description	The Entity that Accepted the Email
DisplayName	Accepting Entity
IsValidForForm	True
IsValidForRead	True
LogicalName	acceptingentityid
RequiredLevel	None
Type	Lookup
Targets	queue, systemuser

AcceptingEntityTypeCode

Property	Value
Description	Accepting Entity Object Type.
DisplayName	Accepting User Or Queue Object Type
IsValidForForm	False
IsValidForRead	True
LogicalName	acceptingentitytypecode
RequiredLevel	None
Type	EntityName

ActivityAdditionalParams

Property	Value
Description	For internal use only.
DisplayName	Additional Parameters
IsValidForForm	True
IsValidForRead	True
LogicalName	activityadditionalparams
RequiredLevel	None
Type	Memo
Format	TextArea
FormatName	TextArea
ImeMode	Auto
IsLocalizable	False
MaxLength	8192

ActivityId

Property	Value
Description	Unique identifier of the email activity.
DisplayName	Email Message
IsValidForForm	False
IsValidForRead	True
LogicalName	activityid
RequiredLevel	SystemRequired
Type	Uniqueidentifier

ActualDurationMinutes

Property	Value
Description	Type the number of minutes spent creating and sending the email. The duration is used in reporting.
DisplayName	Duration
IsValidForForm	True
IsValidForRead	True
LogicalName	actualdurationminutes
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

ActualEnd

Property	Value
Description	Enter the actual end date and time of the email. By default, it displays the date and time when the activity was completed or canceled, but can be edited to capture the actual time to create and send the email.
DisplayName	Actual End
IsValidForForm	True
IsValidForRead	True
LogicalName	actualend
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateOnly
ImeMode	Inactive
SourceTypeMask	0

ActualStart

Property	Value
Description	Enter the actual start date and time for the email. By default, it displays the date and time when the activity was created, but can be edited to capture the actual time to create and send the email.
DisplayName	Actual Start
IsValidForForm	True
IsValidForRead	True
LogicalName	actualstart
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateOnly
ImeMode	Inactive
SourceTypeMask	0

AttachmentOpenCount

Property	Value
Description	Shows the number of times an email attachment has been viewed.
DisplayName	Attachment Open Count
IsValidForForm	False
IsValidForRead	True
LogicalName	attachmentopencount
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

BaseConversationIndexHash

Property	Value
Description	Hash of base of conversation index.
DisplayName	Conversation Index (Hash)
IsValidForForm	False
IsValidForRead	True
LogicalName	baseconversationindexhash
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

bcc

Property	Value
Description	Enter the recipients that are included on the email distribution, but are not displayed to other recipients.
DisplayName	Bcc
IsValidForForm	True
IsValidForRead	True
LogicalName	bcc
RequiredLevel	None
Type	PartyList
Targets	account, contact, knowledgearticle, queue, systemuser, unresolvedaddress

Category

Property	Value
Description	Type a category to identify the email type, such as lead outreach, customer follow-up, or service alert, to tie the email to a business group or function.
DisplayName	Category
IsValidForForm	True
IsValidForRead	True
LogicalName	category
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	250

cc

Property	Value
Description	Enter the recipients that should be copied on the email.
DisplayName	Cc
IsValidForForm	True
IsValidForRead	True
LogicalName	cc
RequiredLevel	None
Type	PartyList
Targets	account, contact, knowledgearticle, queue, systemuser, unresolvedaddress

ConversationTrackingId

Property	Value
Description	Conversation Tracking Id.
DisplayName	Conversation Tracking Id
IsValidForForm	False
IsValidForRead	True
LogicalName	conversationtrackingid
RequiredLevel	None
Type	Uniqueidentifier

CorrelatedActivityId

Property	Value
Description	Correlated Activity Id
DisplayName	Correlated Activity Id
IsValidForForm	True
IsValidForRead	True
LogicalName	correlatedactivityid
RequiredLevel	None
Type	Lookup
Targets	email

correlatedsubjectchanged

Property	Value
Description	Indicates if the subject changed compared to the subject of the correlated email
DisplayName	Correlated subject changed
IsValidForForm	True
IsValidForRead	True
LogicalName	correlatedsubjectchanged
RequiredLevel	None
Type	Boolean
GlobalChoiceName	email_correlatedsubjectchanged
DefaultValue	False
True Label	Yes
False Label	No

DelayedEmailSendTime

Property	Value
Description	Enter the expected date and time when email will be sent.
DisplayName	Send Later
IsValidForForm	False
IsValidForRead	True
LogicalName	delayedemailsendtime
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

DeliveryAttempts

Property	Value
Description	Shows the count of the number of attempts made to send the email. The count is used as an indicator of email routing issues.
DisplayName	No. of Delivery Attempts
IsValidForForm	True
IsValidForRead	True
LogicalName	deliveryattempts
RequiredLevel	None
Type	Integer
MaxValue	1000000000
MinValue	0

DeliveryPriorityCode

Property	Value
Description	Select the priority of delivery of the email to the email server.
DisplayName	Delivery Priority
IsValidForForm	True
IsValidForRead	True
LogicalName	deliveryprioritycode
RequiredLevel	None
Type	Picklist
DefaultFormValue	1
GlobalChoiceName	activitypointer_deliveryprioritycode

DeliveryPriorityCode Choices/Options

Value	Label
0	Low
1	Normal
2	High

DeliveryReceiptRequested

Property	Value
Description	Select whether the sender should receive confirmation that the email was delivered.
DisplayName	Delivery Receipt Requested
IsValidForForm	False
IsValidForRead	True
LogicalName	deliveryreceiptrequested
RequiredLevel	None
Type	Boolean
GlobalChoiceName	email_deliveryreceiptrequested
DefaultValue	False
True Label	Yes
False Label	No

Description

Property	Value
Description	Type the greeting and message text of the email.
DisplayName	Description
IsValidForForm	True
IsValidForRead	True
LogicalName	description
RequiredLevel	None
Type	Memo
Format	Email
FormatName	Email
ImeMode	Auto
IsLocalizable	False
MaxLength	1073741823

DirectionCode

Property	Value
Description	Select the direction of the email as incoming or outbound.
DisplayName	Direction
IsValidForForm	True
IsValidForRead	True
LogicalName	directioncode
RequiredLevel	None
Type	Boolean
GlobalChoiceName	email_directioncode
DefaultValue	True
True Label	Outgoing
False Label	Incoming

EmailReminderExpiryTime

Property	Value
Description	Shows the date and time when an email reminder expires.
DisplayName	Email Reminder Expiry Time
IsValidForForm	False
IsValidForRead	True
LogicalName	emailreminderexpirytime
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

EmailReminderText

Property	Value
Description	For internal use only.
DisplayName	Email Reminder Text
IsValidForForm	False
IsValidForRead	True
LogicalName	emailremindertext
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	1250

EmailReminderType

Property	Value
Description	Shows the type of the email reminder.
DisplayName	Email Reminder Type
IsValidForForm	False
IsValidForRead	True
LogicalName	emailremindertype
RequiredLevel	None
Type	Picklist
DefaultFormValue	0
GlobalChoiceName	email_remindertype

EmailReminderType Choices/Options

Value	Label
0	If I do not receive a reply by
1	If the email is not opened by
2	Remind me anyways at

EmailTrackingId

Property	Value
Description	Email Tracking Id.
DisplayName	Email Tracking Id
IsValidForForm	False
IsValidForRead	True
LogicalName	emailtrackingid
RequiredLevel	None
Type	Uniqueidentifier

FollowEmailUserPreference

Property	Value
Description	Select whether the email allows following recipient activities sent from Microsoft Dynamics 365.This is user preference state which can be overridden by system evaluated state.
DisplayName	Following
IsValidForForm	True
IsValidForRead	True
LogicalName	followemailuserpreference
RequiredLevel	None
Type	Boolean
GlobalChoiceName	email_followuserpreference
DefaultValue	False
True Label	True
False Label	False

from

Property	Value
Description	Enter the sender of the email.
DisplayName	From
IsValidForForm	True
IsValidForRead	True
LogicalName	from
RequiredLevel	None
Type	PartyList
Targets	queue, systemuser

ImportSequenceNumber

Property	Value
Description	Unique identifier of the data import or data migration that created this record.
DisplayName	Import Sequence Number
IsValidForForm	False
IsValidForRead	True
LogicalName	importsequencenumber
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

InternetMessageHeaders

Property	Value
Description	Contains a set of internet headers associated to the email message in json format
DisplayName	Internet message headers
IsValidForForm	True
IsValidForRead	True
LogicalName	internetmessageheaders
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	500

IsBilled

Property	Value
Description	Information regarding whether the email activity was billed as part of resolving a case.
DisplayName	Is Billed
IsValidForForm	False
IsValidForRead	True
LogicalName	isbilled
RequiredLevel	None
Type	Boolean
GlobalChoiceName	email_isbilled
DefaultValue	False
True Label	Yes
False Label	No

IsDuplicateSenderUnresolved

Property	Value
Description	Indicates if the sender of the email is unresolved in case of multiple match
DisplayName	Is Duplicate Sender Unresolved
IsValidForForm	True
IsValidForRead	True
LogicalName	isduplicatesenderunresolved
RequiredLevel	None
Type	Boolean
GlobalChoiceName	email_isduplicatesenderunresolved
DefaultValue	False
True Label	Yes
False Label	No

IsWorkflowCreated

Property	Value
Description	Indication if the email was created by a workflow rule.
DisplayName	Is Workflow Created
IsValidForForm	False
IsValidForRead	True
LogicalName	isworkflowcreated
RequiredLevel	None
Type	Boolean
GlobalChoiceName	email_isworkflowcreated
DefaultValue	False
True Label	Yes
False Label	No

LastOnHoldTime

Property	Value
Description	Contains the date and time stamp of the last on hold time.
DisplayName	Last On Hold Time
IsValidForForm	True
IsValidForRead	True
LogicalName	lastonholdtime
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

LastOpenedTime

Property	Value
Description	Shows the latest date and time when email was opened.
DisplayName	Last Opened Time
IsValidForForm	False
IsValidForRead	True
LogicalName	lastopenedtime
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

LinksClickedCount

Property	Value
Description	Shows the number of times a link in an email has been clicked.
DisplayName	Links Clicked Count
IsValidForForm	False
IsValidForRead	True
LogicalName	linksclickedcount
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

MessageId

Property	Value
Description	Unique identifier of the email message. Used only for email that is received.
DisplayName	Message ID
IsValidForForm	False
IsValidForRead	True
LogicalName	messageid
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	320

MessageIdDupCheck

Property	Value
Description	For internal use only.
DisplayName	Message ID Dup Check
IsValidForForm	False
IsValidForRead	False
LogicalName	messageiddupcheck
RequiredLevel	SystemRequired
Type	Uniqueidentifier

MimeType

Property	Value
Description	MIME type of the email message data.
DisplayName	Mime Type
IsValidForForm	False
IsValidForRead	True
LogicalName	mimetype
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	256

Notifications

Property	Value
Description	Select the notification code to identify issues with the email recipients or attachments, such as blocked attachments.
DisplayName	Notifications
IsValidForForm	True
IsValidForRead	True
LogicalName	notifications
RequiredLevel	None
Type	Picklist
DefaultFormValue	0
GlobalChoiceName	email_notifications

Notifications Choices/Options

Value	Label
0	None
1	The message was saved as a Microsoft Dynamics 365 email record, but not all the attachments could be saved with it. An attachment cannot be saved if it is blocked or if its file type is invalid.
2	Truncated body.

OpenCount

Property	Value
Description	Shows the number of times an email has been opened.
DisplayName	Open Count
IsValidForForm	False
IsValidForRead	True
LogicalName	opencount
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

OverriddenCreatedOn

Property	Value
Description	Date and time that the record was migrated.
DisplayName	Record Created On
IsValidForForm	False
IsValidForRead	True
LogicalName	overriddencreatedon
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateOnly
ImeMode	Inactive
SourceTypeMask	0

OwnerId

Property	Value
Description	Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user.
DisplayName	Owner
IsValidForForm	True
IsValidForRead	True
LogicalName	ownerid
RequiredLevel	SystemRequired
Type	Owner
Targets	systemuser, team

OwnerIdType

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	owneridtype
RequiredLevel	SystemRequired
Type	EntityName

ParentActivityId

Property	Value
Description	Select the activity that the email is associated with.
DisplayName	Parent Activity Id
IsValidForForm	True
IsValidForRead	True
LogicalName	parentactivityid
RequiredLevel	None
Type	Lookup
Targets	email

PriorityCode

Property	Value
Description	Select the priority so that preferred customers or critical issues are handled quickly.
DisplayName	Priority
IsValidForForm	True
IsValidForRead	True
LogicalName	prioritycode
RequiredLevel	None
Type	Picklist
DefaultFormValue	1
GlobalChoiceName	email_prioritycode

PriorityCode Choices/Options

Value	Label
0	Low
1	Normal
2	High

ProcessId

Property	Value
Description	Shows the ID of the process.
DisplayName	Process
IsValidForForm	False
IsValidForRead	True
LogicalName	processid
RequiredLevel	None
Type	Uniqueidentifier

ReadReceiptRequested

Property	Value
Description	Indicates that a read receipt is requested.
DisplayName	Read Receipt Requested
IsValidForForm	False
IsValidForRead	True
LogicalName	readreceiptrequested
RequiredLevel	None
Type	Boolean
GlobalChoiceName	email_readreceiptrequested
DefaultValue	False
True Label	Yes
False Label	No

ReceivingMailboxId

Property	Value
Description	The Mailbox that Received the Email.
DisplayName	Receiving Mailbox
IsValidForForm	True
IsValidForRead	True
LogicalName	receivingmailboxid
RequiredLevel	None
Type	Lookup
Targets	mailbox

RegardingObjectId

Property	Value
Description	Choose the record that the email relates to.
DisplayName	Regarding
IsValidForForm	True
IsValidForRead	True
LogicalName	regardingobjectid
RequiredLevel	None
Type	Lookup
Targets	account, adx_invitation, asyncoperation, contact, knowledgearticle, knowledgebaserecord, mspp_adplacement, mspp_pollplacement, mspp_publishingstatetransitionrule, mspp_redirect, mspp_shortcut, mspp_website

RegardingObjectTypeCode

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	regardingobjecttypecode
RequiredLevel	None
Type	EntityName

related

Property	Value
Description	Enter the related records for the email.
DisplayName	Related
IsValidForForm	True
IsValidForRead	True
LogicalName	related
RequiredLevel	None
Type	PartyList
Targets	account, contact, knowledgearticle, queue, systemuser, unresolvedaddress

ReminderActionCardId

Property	Value
Description	Reminder Action Card Id.
DisplayName	Reminder Action Card Id.
IsValidForForm	False
IsValidForRead	True
LogicalName	reminderactioncardid
RequiredLevel	None
Type	Uniqueidentifier

ReservedForInternalUse

Property	Value
Description	For internal use only
DisplayName	Reserved for internal use
IsValidForForm	False
IsValidForRead	True
LogicalName	reservedforinternaluse
RequiredLevel	None
Type	Memo
Format	TextArea
FormatName	TextArea
ImeMode	Auto
IsLocalizable	False
MaxLength	40000

ScheduledEnd

Property	Value
Description	Enter the expected due date and time for the activity to be completed to provide details about when the email will be sent.
DisplayName	Due Date
IsValidForForm	True
IsValidForRead	True
LogicalName	scheduledend
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

ScheduledStart

Property	Value
Description	Enter the expected start date and time for the activity to provide details about the tentative time when the email activity must be initiated.
DisplayName	Start Date
IsValidForForm	True
IsValidForRead	True
LogicalName	scheduledstart
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

Sender

Property	Value
Description	Sender of the email.
DisplayName	From
IsValidForForm	False
IsValidForRead	True
LogicalName	sender
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	250

SLAId

Property	Value
Description	Choose the service level agreement (SLA) that you want to apply to the email record.
DisplayName	SLA
IsValidForForm	True
IsValidForRead	True
LogicalName	slaid
RequiredLevel	None
Type	Lookup
Targets	sla

SortDate

Property	Value
Description	Shows the date and time by which the activities are sorted.
DisplayName	Sort Date
IsValidForForm	True
IsValidForRead	True
LogicalName	sortdate
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

StageId

Property	Value
Description	Shows the ID of the stage.
DisplayName	(Deprecated) Process Stage
IsValidForForm	False
IsValidForRead	True
LogicalName	stageid
RequiredLevel	None
Type	Uniqueidentifier

StateCode

Property	Value
Description	Shows whether the email is open, completed, or canceled. Completed and canceled email is read-only and can't be edited.
DisplayName	Activity Status
IsValidForForm	True
IsValidForRead	True
LogicalName	statecode
RequiredLevel	SystemRequired
Type	State
DefaultFormValue	0
GlobalChoiceName	email_statecode

StateCode Choices/Options

Value	Details
0	Label: Open DefaultStatus: 1 InvariantName: Open
1	Label: Completed DefaultStatus: 2 InvariantName: Completed
2	Label: Canceled DefaultStatus: 5 InvariantName: Canceled

StatusCode

Property	Value
Description	Select the email's status.
DisplayName	Status Reason
IsValidForForm	True
IsValidForRead	True
LogicalName	statuscode
RequiredLevel	None
Type	Status
DefaultFormValue	-1
GlobalChoiceName	email_statuscode

StatusCode Choices/Options

Value	Details
1	Label: Draft State:0 TransitionData: None
2	Label: Completed State:1 TransitionData: None
3	Label: Sent State:1 TransitionData: None
4	Label: Received State:1 TransitionData: None
5	Label: Canceled State:2 TransitionData: None
6	Label: Pending Send State:1 TransitionData: None
7	Label: Sending State:1 TransitionData: None
8	Label: Failed State:0 TransitionData: None

Subcategory

Property	Value
Description	Type a subcategory to identify the email type and relate the activity to a specific product, sales region, business group, or other function.
DisplayName	Sub-Category
IsValidForForm	True
IsValidForRead	True
LogicalName	subcategory
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	250

Subject

Property	Value
Description	Type a short description about the objective or primary topic of the email.
DisplayName	Subject
IsValidForForm	True
IsValidForRead	True
LogicalName	subject
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	800

SubmittedBy

Property	Value
Description	Shows the Microsoft Office Outlook account for the user who submitted the email to Microsoft Dynamics 365.
DisplayName	Submitted By
IsValidForForm	True
IsValidForRead	True
LogicalName	submittedby
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	250

TemplateId

Property	Value
Description	For internal use only. ID for template used in email.
DisplayName	ID for template used.
IsValidForForm	False
IsValidForRead	True
LogicalName	templateid
RequiredLevel	None
Type	Lookup
Targets	template

TimeZoneRuleVersionNumber

Property	Value
Description	For internal use only.
DisplayName	Time Zone Rule Version Number
IsValidForForm	False
IsValidForRead	True
LogicalName	timezoneruleversionnumber
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-1

to

Property	Value
Description	Enter the account, contact, lead, queue, or user recipients for the email.
DisplayName	To
IsValidForForm	True
IsValidForRead	True
LogicalName	to
RequiredLevel	None
Type	PartyList
Targets	account, contact, knowledgearticle, queue, systemuser, unresolvedaddress

ToRecipients

Property	Value
Description	Shows the email addresses corresponding to the recipients.
DisplayName	To Recipients
IsValidForForm	False
IsValidForRead	True
LogicalName	torecipients
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	500

TrackingToken

Property	Value
Description	Shows the tracking token assigned to the email to make sure responses are automatically tracked in Microsoft Dynamics 365.
DisplayName	Tracking Token
IsValidForForm	True
IsValidForRead	True
LogicalName	trackingtoken
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	50

TransactionCurrencyId

Property	Value
Description	Choose the local currency for the record to make sure budgets are reported in the correct currency.
DisplayName	Currency
IsValidForForm	True
IsValidForRead	True
LogicalName	transactioncurrencyid
RequiredLevel	None
Type	Lookup
Targets	transactioncurrency

TraversedPath

Property	Value
Description	For internal use only.
DisplayName	(Deprecated) Traversed Path
IsValidForForm	False
IsValidForRead	True
LogicalName	traversedpath
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	1250

UTCConversionTimeZoneCode

Property	Value
Description	Time zone code that was in use when the record was created.
DisplayName	UTC Conversion Time Zone Code
IsValidForForm	False
IsValidForRead	True
LogicalName	utcconversiontimezonecode
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-1

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.

• ActivityTypeCode
• AttachmentCount
• Compressed
• ConversationIndex
• CorrelationMethod
• CreatedBy
• CreatedOn
• CreatedOnBehalfBy
• DescriptionBlobId
• DescriptionBlobId_Name
• EmailReminderStatus
• EmailSender
• EmailSenderObjectTypeCode
• ExchangeRate
• InReplyTo
• IsEmailFollowed
• IsEmailReminderSet
• IsRegularActivity
• IsSafeDescriptionTruncated
• IsUnsafe
• ModifiedBy
• ModifiedOn
• ModifiedOnBehalfBy
• OnHoldTime
• OwnerIdName
• OwnerIdYomiName
• OwningBusinessUnit
• OwningTeam
• OwningUser
• PostponeEmailProcessingUntil
• ReplyCount
• SafeDescription
• ScheduledDurationMinutes
• SenderMailboxId
• SendersAccount
• SendersAccountObjectTypeCode
• SentOn
• SLAInvokedId
• VersionNumber

ActivityTypeCode

Property	Value
Description	Shows the type of activity.
DisplayName	Activity Type
IsValidForForm	False
IsValidForRead	True
LogicalName	activitytypecode
RequiredLevel	SystemRequired
Type	EntityName

AttachmentCount

Property	Value
Description	Shows the umber of attachments of the email message.
DisplayName	Attachment Count
IsValidForForm	False
IsValidForRead	True
LogicalName	attachmentcount
RequiredLevel	SystemRequired
Type	Integer
MaxValue	2147483647
MinValue	0

Compressed

Property	Value
Description	Indicates if the body is compressed.
DisplayName	Compression
IsValidForForm	False
IsValidForRead	True
LogicalName	compressed
RequiredLevel	SystemRequired
Type	Boolean
GlobalChoiceName	email_compressed
DefaultValue	False
True Label	Compressed
False Label	Not compressed

ConversationIndex

Property	Value
Description	Identifier for all the email responses for this conversation.
DisplayName	Conversation Index
IsValidForForm	True
IsValidForRead	True
LogicalName	conversationindex
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	2048

CorrelationMethod

Property	Value
Description	Shows how an email is correlated to an existing email in Microsoft Dynamics 365. XHeader and CustomCorrelation are not used. For system use only.
DisplayName	Correlation Method
IsValidForForm	True
IsValidForRead	True
LogicalName	correlationmethod
RequiredLevel	None
Type	Picklist
DefaultFormValue	0
GlobalChoiceName	email_correlationmethod

CorrelationMethod Choices/Options

Value	Label
0	None
1	Skipped
2	XHeader
3	InReplyTo
4	TrackingToken
5	ConversationIndex
6	SmartMatching
7	CustomCorrelation

CreatedBy

Property	Value
Description	Shows who created the record.
DisplayName	Created By
IsValidForForm	True
IsValidForRead	True
LogicalName	createdby
RequiredLevel	None
Type	Lookup
Targets	systemuser

CreatedOn

Property	Value
Description	Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options.
DisplayName	Created On
IsValidForForm	True
IsValidForRead	True
LogicalName	createdon
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

CreatedOnBehalfBy

Property	Value
Description	Shows who created the record on behalf of another user.
DisplayName	Created By (Delegate)
IsValidForForm	True
IsValidForRead	True
LogicalName	createdonbehalfby
RequiredLevel	None
Type	Lookup
Targets	systemuser

DescriptionBlobId

Property	Value
Description	File that contains description content.
DisplayName	Description File Id
IsValidForForm	False
IsValidForRead	True
LogicalName	descriptionblobid
RequiredLevel	None
Type	File
MaxSizeInKB	128000

DescriptionBlobId_Name

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	descriptionblobid_name
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Disabled
IsLocalizable	False
MaxLength	200

EmailReminderStatus

Property	Value
Description	Shows the status of the email reminder.
DisplayName	Email Reminder Status
IsValidForForm	False
IsValidForRead	True
LogicalName	emailreminderstatus
RequiredLevel	SystemRequired
Type	Picklist
DefaultFormValue	0
GlobalChoiceName	email_reminderstatus

EmailReminderStatus Choices/Options

Value	Label
0	NotSet
1	ReminderSet
2	ReminderExpired
3	ReminderInvalid

EmailSender

Property	Value
Description	Shows the sender of the email.
DisplayName	Sender
IsValidForForm	False
IsValidForRead	True
LogicalName	emailsender
RequiredLevel	None
Type	Lookup
Targets	account, contact, queue, systemuser

EmailSenderObjectTypeCode

Property	Value
Description	Shows the object type of sender of the email.
DisplayName	Email Sender Type
IsValidForForm	False
IsValidForRead	True
LogicalName	emailsenderobjecttypecode
RequiredLevel	None
Type	EntityName

ExchangeRate

Property	Value
Description	Shows the conversion rate of the record's currency. The exchange rate is used to convert all money fields in the record from the local currency to the system's default currency.
DisplayName	Exchange Rate
IsValidForForm	True
IsValidForRead	True
LogicalName	exchangerate
RequiredLevel	None
Type	Decimal
ImeMode	Disabled
MaxValue	100000000000
MinValue	1E-12
Precision	12
SourceTypeMask	0

InReplyTo

Property	Value
Description	Type the ID of the email message that this email activity is a response to.
DisplayName	In Reply To Message
IsValidForForm	False
IsValidForRead	True
LogicalName	inreplyto
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	320

IsEmailFollowed

Property	Value
Description	For internal use only. Shows whether this email is followed. This is evaluated state which overrides user selection of follow email.
DisplayName	Followed
IsValidForForm	False
IsValidForRead	True
LogicalName	isemailfollowed
RequiredLevel	None
Type	Boolean
GlobalChoiceName	activitypointer_isemailfollowed
DefaultValue	False
True Label	Yes
False Label	No

IsEmailReminderSet

Property	Value
Description	For internal use only. Shows whether this email Reminder is Set.
DisplayName	Reminder Set
IsValidForForm	False
IsValidForRead	True
LogicalName	isemailreminderset
RequiredLevel	None
Type	Boolean
GlobalChoiceName	email_isemailreminderset
DefaultValue	False
True Label	Yes
False Label	No

IsRegularActivity

Property	Value
Description	Information regarding whether the activity is a regular activity type or event type.
DisplayName	Is Regular Activity
IsValidForForm	False
IsValidForRead	True
LogicalName	isregularactivity
RequiredLevel	SystemRequired
Type	Boolean
GlobalChoiceName	activitypointer_isregularactivity
DefaultValue	False
True Label	Yes
False Label	No

IsSafeDescriptionTruncated

Property	Value
Description	For internal use only.
DisplayName	IsSafeDescriptionTruncated
IsValidForForm	False
IsValidForRead	False
LogicalName	issafedescriptiontruncated
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

IsUnsafe

Property	Value
Description	For internal use only.
DisplayName	IsUnsafe
IsValidForForm	False
IsValidForRead	True
LogicalName	isunsafe
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

ModifiedBy

Property	Value
Description	Shows who last updated the record.
DisplayName	Modified By
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedby
RequiredLevel	None
Type	Lookup
Targets	systemuser

ModifiedOn

Property	Value
Description	Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options.
DisplayName	Modified On
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedon
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

ModifiedOnBehalfBy

Property	Value
Description	Shows who last updated the record on behalf of another user.
DisplayName	Modified By (Delegate)
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedonbehalfby
RequiredLevel	None
Type	Lookup
Targets	systemuser

OnHoldTime

Property	Value
Description	Shows how long, in minutes, that the record was on hold.
DisplayName	On Hold Time (Minutes)
IsValidForForm	True
IsValidForRead	True
LogicalName	onholdtime
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

OwnerIdName

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	owneridname
RequiredLevel	SystemRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

OwnerIdYomiName

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	owneridyominame
RequiredLevel	SystemRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

OwningBusinessUnit

Property	Value
Description	Unique identifier of the business unit that owns the email activity.
DisplayName	Owning Business Unit
IsValidForForm	True
IsValidForRead	True
LogicalName	owningbusinessunit
RequiredLevel	None
Type	Lookup
Targets	businessunit

OwningTeam

Property	Value
Description	Unique identifier of the team who owns the email activity.
DisplayName	Owning Team
IsValidForForm	False
IsValidForRead	True
LogicalName	owningteam
RequiredLevel	None
Type	Lookup
Targets	team

OwningUser

Property	Value
Description	Unique identifier of the user who owns the email activity.
DisplayName	Owning User
IsValidForForm	False
IsValidForRead	True
LogicalName	owninguser
RequiredLevel	None
Type	Lookup
Targets	systemuser

PostponeEmailProcessingUntil

Property	Value
Description	For internal use only.
DisplayName	Delay email processing until
IsValidForForm	False
IsValidForRead	True
LogicalName	postponeemailprocessinguntil
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

ReplyCount

Property	Value
Description	Shows the number of replies received for an email.
DisplayName	Reply Count
IsValidForForm	False
IsValidForRead	True
LogicalName	replycount
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

SafeDescription

Property	Value
Description	Safe body text of the e-mail.
DisplayName	Safe Description
IsValidForForm	False
IsValidForRead	True
LogicalName	safedescription
RequiredLevel	None
Type	Memo
Format	Email
FormatName	Email
ImeMode	Auto
IsLocalizable	False
MaxLength	1073741823

ScheduledDurationMinutes

Property	Value
Description	Scheduled duration of the email activity, specified in minutes.
DisplayName	Scheduled Duration
IsValidForForm	False
IsValidForRead	True
LogicalName	scheduleddurationminutes
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

SenderMailboxId

Property	Value
Description	Select the mailbox associated with the sender of the email message.
DisplayName	Sender's Mailbox
IsValidForForm	False
IsValidForRead	True
LogicalName	sendermailboxid
RequiredLevel	None
Type	Lookup
Targets	mailbox

SendersAccount

Property	Value
Description	Shows the parent account of the sender of the email.
DisplayName	Senders Account
IsValidForForm	False
IsValidForRead	True
LogicalName	sendersaccount
RequiredLevel	None
Type	Lookup
Targets	account

SendersAccountObjectTypeCode

Property	Value
Description	Shows the parent account type code of the sender of the email.
DisplayName	SendersAccount Type
IsValidForForm	False
IsValidForRead	True
LogicalName	sendersaccountobjecttypecode
RequiredLevel	None
Type	EntityName

SentOn

Property	Value
Description	Shows the date and time that the email was sent.
DisplayName	Date Sent
IsValidForForm	True
IsValidForRead	True
LogicalName	senton
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

SLAInvokedId

Property	Value
Description	Last SLA that was applied to this email. This field is for internal use only.
DisplayName	Last SLA applied
IsValidForForm	False
IsValidForRead	True
LogicalName	slainvokedid
RequiredLevel	None
Type	Lookup
Targets	sla

VersionNumber

Property	Value
Description	Version number of the email message.
DisplayName	Version Number
IsValidForForm	False
IsValidForRead	True
LogicalName	versionnumber
RequiredLevel	None
Type	BigInt
MaxValue	9223372036854775807
MinValue	-9223372036854775808

Many-to-One relationships

These relationships are many-to-one. Listed by SchemaName.

• Account_Email_EmailSender
• Account_Email_SendersAccount
• Account_Emails
• activity_pointer_email
• adx_invitation_Emails
• AsyncOperation_Emails
• business_unit_email_activities
• Contact_Email_EmailSender
• Contact_Emails
• email_acceptingentity_queue
• email_acceptingentity_systemuser
• email_email_CorrelatedActivityId
• email_email_parentactivityid
• Email_EmailTemplate
• email_sendermailboxid_mailbox
• FileAttachment_Email_DescriptionBlobId
• KnowledgeArticle_Emails
• KnowledgeBaseRecord_Emails
• lk_email_createdby
• lk_email_createdonbehalfby
• lk_email_modifiedby
• lk_email_modifiedonbehalfby
• mailbox_email_ReceivingMailboxId
• manualsla_email
• mspp_adplacement_Emails
• mspp_pollplacement_Emails
• mspp_publishingstatetransitionrule_Emails
• mspp_redirect_Emails
• mspp_shortcut_Emails
• mspp_website_Emails
• owner_emails
• processstage_emails
• Queue_Email_EmailSender
• sla_email
• SystemUser_Email_EmailSender
• team_email
• TransactionCurrency_Email
• user_email

Account_Email_EmailSender

One-To-Many Relationship: account Account_Email_EmailSender

Property	Value
ReferencedEntity	account
ReferencedAttribute	accountid
ReferencingAttribute	emailsender
ReferencingEntityNavigationPropertyName	emailsender_account
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

Account_Email_SendersAccount

One-To-Many Relationship: account Account_Email_SendersAccount

Property	Value
ReferencedEntity	account
ReferencedAttribute	accountid
ReferencingAttribute	sendersaccount
ReferencingEntityNavigationPropertyName	sendersaccount
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

Account_Emails

One-To-Many Relationship: account Account_Emails

Property	Value
ReferencedEntity	account
ReferencedAttribute	accountid
ReferencingAttribute	regardingobjectid
ReferencingEntityNavigationPropertyName	regardingobjectid_account_email
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade RollupView: NoCascade Share: Cascade Unshare: Cascade

activity_pointer_email

One-To-Many Relationship: activitypointer activity_pointer_email

Property	Value
ReferencedEntity	activitypointer
ReferencedAttribute	activityid
ReferencingAttribute	activityid
ReferencingEntityNavigationPropertyName	activityid_activitypointer
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

adx_invitation_Emails

One-To-Many Relationship: adx_invitation adx_invitation_Emails

Property	Value
ReferencedEntity	adx_invitation
ReferencedAttribute	adx_invitationid
ReferencingAttribute	regardingobjectid
ReferencingEntityNavigationPropertyName	regardingobjectid_adx_invitation_email
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade RollupView: NoCascade Share: Cascade Unshare: Cascade

AsyncOperation_Emails

One-To-Many Relationship: asyncoperation AsyncOperation_Emails

Property	Value
ReferencedEntity	asyncoperation
ReferencedAttribute	asyncoperationid
ReferencingAttribute	regardingobjectid
ReferencingEntityNavigationPropertyName	regardingobjectid_asyncoperation
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade RollupView: NoCascade Share: Cascade Unshare: Cascade

business_unit_email_activities

One-To-Many Relationship: businessunit business_unit_email_activities

Property	Value
ReferencedEntity	businessunit
ReferencedAttribute	businessunitid
ReferencingAttribute	owningbusinessunit
ReferencingEntityNavigationPropertyName	owningbusinessunit_email
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

Contact_Email_EmailSender

One-To-Many Relationship: contact Contact_Email_EmailSender

Property	Value
ReferencedEntity	contact
ReferencedAttribute	contactid
ReferencingAttribute	emailsender
ReferencingEntityNavigationPropertyName	emailsender_contact
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

Contact_Emails

One-To-Many Relationship: contact Contact_Emails

Property	Value
ReferencedEntity	contact
ReferencedAttribute	contactid
ReferencingAttribute	regardingobjectid
ReferencingEntityNavigationPropertyName	regardingobjectid_contact_email
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade RollupView: NoCascade Share: Cascade Unshare: Cascade

email_acceptingentity_queue

One-To-Many Relationship: queue email_acceptingentity_queue

Property	Value
ReferencedEntity	queue
ReferencedAttribute	queueid
ReferencingAttribute	acceptingentityid
ReferencingEntityNavigationPropertyName	acceptingentityid
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

email_acceptingentity_systemuser

One-To-Many Relationship: systemuser email_acceptingentity_systemuser

Property	Value
ReferencedEntity	systemuser
ReferencedAttribute	systemuserid
ReferencingAttribute	acceptingentityid
ReferencingEntityNavigationPropertyName	acceptingentityid
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

email_email_CorrelatedActivityId

One-To-Many Relationship: email email_email_CorrelatedActivityId

Property	Value
ReferencedEntity	email
ReferencedAttribute	activityid
ReferencingAttribute	correlatedactivityid
ReferencingEntityNavigationPropertyName	CorrelatedActivityId_Email
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

email_email_parentactivityid

One-To-Many Relationship: email email_email_parentactivityid

Property	Value
ReferencedEntity	email
ReferencedAttribute	activityid
ReferencingAttribute	parentactivityid
ReferencingEntityNavigationPropertyName	parentactivityid
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

Email_EmailTemplate

One-To-Many Relationship: template Email_EmailTemplate

Property	Value
ReferencedEntity	template
ReferencedAttribute	templateid
ReferencingAttribute	templateid
ReferencingEntityNavigationPropertyName	templateid
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

email_sendermailboxid_mailbox

One-To-Many Relationship: mailbox email_sendermailboxid_mailbox

Property	Value
ReferencedEntity	mailbox
ReferencedAttribute	mailboxid
ReferencingAttribute	sendermailboxid
ReferencingEntityNavigationPropertyName	sendermailboxid_email
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

FileAttachment_Email_DescriptionBlobId

One-To-Many Relationship: fileattachment FileAttachment_Email_DescriptionBlobId

Property	Value
ReferencedEntity	fileattachment
ReferencedAttribute	fileattachmentid
ReferencingAttribute	descriptionblobid
ReferencingEntityNavigationPropertyName	descriptionblobid_email
IsHierarchical
CascadeConfiguration	Archive: RemoveLink Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

KnowledgeArticle_Emails

One-To-Many Relationship: knowledgearticle KnowledgeArticle_Emails

Property	Value
ReferencedEntity	knowledgearticle
ReferencedAttribute	knowledgearticleid
ReferencingAttribute	regardingobjectid
ReferencingEntityNavigationPropertyName	regardingobjectid_knowledgearticle_email
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade RollupView: NoCascade Share: Cascade Unshare: Cascade

KnowledgeBaseRecord_Emails

One-To-Many Relationship: knowledgebaserecord KnowledgeBaseRecord_Emails

Property	Value
ReferencedEntity	knowledgebaserecord
ReferencedAttribute	knowledgebaserecordid
ReferencingAttribute	regardingobjectid
ReferencingEntityNavigationPropertyName	regardingobjectid_knowledgebaserecord_email
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

lk_email_createdby

One-To-Many Relationship: systemuser lk_email_createdby

Property	Value
ReferencedEntity	systemuser
ReferencedAttribute	systemuserid
ReferencingAttribute	createdby
ReferencingEntityNavigationPropertyName	createdby_email
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

lk_email_createdonbehalfby

One-To-Many Relationship: systemuser lk_email_createdonbehalfby

Property	Value
ReferencedEntity	systemuser
ReferencedAttribute	systemuserid
ReferencingAttribute	createdonbehalfby
ReferencingEntityNavigationPropertyName	createdonbehalfby_email
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

lk_email_modifiedby

One-To-Many Relationship: systemuser lk_email_modifiedby

Property	Value
ReferencedEntity	systemuser
ReferencedAttribute	systemuserid
ReferencingAttribute	modifiedby
ReferencingEntityNavigationPropertyName	modifiedby_email
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

lk_email_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_email_modifiedonbehalfby

Property	Value
ReferencedEntity	systemuser
ReferencedAttribute	systemuserid
ReferencingAttribute	modifiedonbehalfby
ReferencingEntityNavigationPropertyName	modifiedonbehalfby_email
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

mailbox_email_ReceivingMailboxId

One-To-Many Relationship: mailbox mailbox_email_ReceivingMailboxId

Property	Value
ReferencedEntity	mailbox
ReferencedAttribute	mailboxid
ReferencingAttribute	receivingmailboxid
ReferencingEntityNavigationPropertyName	ReceivingMailboxId_Email
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

manualsla_email

One-To-Many Relationship: sla manualsla_email

Property	Value
ReferencedEntity	sla
ReferencedAttribute	slaid
ReferencingAttribute	slaid
ReferencingEntityNavigationPropertyName	sla_email_sla
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

mspp_adplacement_Emails

One-To-Many Relationship: mspp_adplacement mspp_adplacement_Emails

Property	Value
ReferencedEntity	mspp_adplacement
ReferencedAttribute	mspp_adplacementid
ReferencingAttribute	regardingobjectid
ReferencingEntityNavigationPropertyName	regardingobjectid_mspp_adplacement_email
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

mspp_pollplacement_Emails

One-To-Many Relationship: mspp_pollplacement mspp_pollplacement_Emails

Property	Value
ReferencedEntity	mspp_pollplacement
ReferencedAttribute	mspp_pollplacementid
ReferencingAttribute	regardingobjectid
ReferencingEntityNavigationPropertyName	regardingobjectid_mspp_pollplacement_email
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

mspp_publishingstatetransitionrule_Emails

One-To-Many Relationship: mspp_publishingstatetransitionrule mspp_publishingstatetransitionrule_Emails

Property	Value
ReferencedEntity	mspp_publishingstatetransitionrule
ReferencedAttribute	mspp_publishingstatetransitionruleid
ReferencingAttribute	regardingobjectid
ReferencingEntityNavigationPropertyName	regardingobjectid_mspp_publishingstatetransitionrule_email
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

mspp_redirect_Emails

One-To-Many Relationship: mspp_redirect mspp_redirect_Emails

Property	Value
ReferencedEntity	mspp_redirect
ReferencedAttribute	mspp_redirectid
ReferencingAttribute	regardingobjectid
ReferencingEntityNavigationPropertyName	regardingobjectid_mspp_redirect_email
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

mspp_shortcut_Emails

One-To-Many Relationship: mspp_shortcut mspp_shortcut_Emails

Property	Value
ReferencedEntity	mspp_shortcut
ReferencedAttribute	mspp_shortcutid
ReferencingAttribute	regardingobjectid
ReferencingEntityNavigationPropertyName	regardingobjectid_mspp_shortcut_email
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

mspp_website_Emails

One-To-Many Relationship: mspp_website mspp_website_Emails

Property	Value
ReferencedEntity	mspp_website
ReferencedAttribute	mspp_websiteid
ReferencingAttribute	regardingobjectid
ReferencingEntityNavigationPropertyName	regardingobjectid_mspp_website_email
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

owner_emails

One-To-Many Relationship: owner owner_emails

Property	Value
ReferencedEntity	owner
ReferencedAttribute	ownerid
ReferencingAttribute	ownerid
ReferencingEntityNavigationPropertyName	ownerid_email
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

processstage_emails

One-To-Many Relationship: processstage processstage_emails

Property	Value
ReferencedEntity	processstage
ReferencedAttribute	processstageid
ReferencingAttribute	stageid
ReferencingEntityNavigationPropertyName	stageid_processstage
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

Queue_Email_EmailSender

One-To-Many Relationship: queue Queue_Email_EmailSender

Property	Value
ReferencedEntity	queue
ReferencedAttribute	queueid
ReferencingAttribute	emailsender
ReferencingEntityNavigationPropertyName	emailsender_queue
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

sla_email

One-To-Many Relationship: sla sla_email

Property	Value
ReferencedEntity	sla
ReferencedAttribute	slaid
ReferencingAttribute	slainvokedid
ReferencingEntityNavigationPropertyName	slainvokedid_email_sla
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

SystemUser_Email_EmailSender

One-To-Many Relationship: systemuser SystemUser_Email_EmailSender

Property	Value
ReferencedEntity	systemuser
ReferencedAttribute	systemuserid
ReferencingAttribute	emailsender
ReferencingEntityNavigationPropertyName	emailsender_systemuser
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

team_email

One-To-Many Relationship: team team_email

Property	Value
ReferencedEntity	team
ReferencedAttribute	teamid
ReferencingAttribute	owningteam
ReferencingEntityNavigationPropertyName	owningteam_email
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

TransactionCurrency_Email

One-To-Many Relationship: transactioncurrency TransactionCurrency_Email

Property	Value
ReferencedEntity	transactioncurrency
ReferencedAttribute	transactioncurrencyid
ReferencingAttribute	transactioncurrencyid
ReferencingEntityNavigationPropertyName	transactioncurrencyid_email
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

user_email

One-To-Many Relationship: systemuser user_email

Property	Value
ReferencedEntity	systemuser
ReferencedAttribute	systemuserid
ReferencingAttribute	owninguser
ReferencingEntityNavigationPropertyName	owninguser_email
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

One-to-Many relationships

These relationships are one-to-many. Listed by SchemaName.

• email_actioncard
• email_activity_mime_attachment
• email_activity_parties
• Email_Annotation
• Email_AsyncOperations
• Email_BulkDeleteFailures
• email_connections1
• email_connections2
• Email_DuplicateBaseRecord
• Email_DuplicateMatchingRecord
• email_email_CorrelatedActivityId
• email_email_parentactivityid
• email_FileAttachments
• email_principalobjectattributeaccess
• Email_ProcessSessions
• Email_QueueItem
• Email_SyncErrors
• slakpiinstance_email

email_actioncard

Many-To-One Relationship: actioncard email_actioncard

Property	Value
ReferencingEntity	actioncard
ReferencingAttribute	regardingobjectid
ReferencedEntityNavigationPropertyName	email_actioncard
IsCustomizable	True
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

email_activity_mime_attachment

Many-To-One Relationship: activitymimeattachment email_activity_mime_attachment

Property	Value
ReferencingEntity	activitymimeattachment
ReferencingAttribute	objectid
ReferencedEntityNavigationPropertyName	email_activity_mime_attachment
IsCustomizable	False
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

email_activity_parties

Many-To-One Relationship: activityparty email_activity_parties

Property	Value
ReferencingEntity	activityparty
ReferencingAttribute	activityid
ReferencedEntityNavigationPropertyName	email_activity_parties
IsCustomizable	False
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

Email_Annotation

Many-To-One Relationship: annotation Email_Annotation

Property	Value
ReferencingEntity	annotation
ReferencingAttribute	objectid
ReferencedEntityNavigationPropertyName	Email_Annotation
IsCustomizable	True
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

Email_AsyncOperations

Many-To-One Relationship: asyncoperation Email_AsyncOperations

Property	Value
ReferencingEntity	asyncoperation
ReferencingAttribute	regardingobjectid
ReferencedEntityNavigationPropertyName	Email_AsyncOperations
IsCustomizable	False
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

Email_BulkDeleteFailures

Many-To-One Relationship: bulkdeletefailure Email_BulkDeleteFailures

Property	Value
ReferencingEntity	bulkdeletefailure
ReferencingAttribute	regardingobjectid
ReferencedEntityNavigationPropertyName	Email_BulkDeleteFailures
IsCustomizable	False
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

email_connections1

Many-To-One Relationship: connection email_connections1

Property	Value
ReferencingEntity	connection
ReferencingAttribute	record1id
ReferencedEntityNavigationPropertyName	email_connections1
IsCustomizable	True
AssociatedMenuConfiguration	AvailableOffline: True Behavior: UseCollectionName Group: Details Label: MenuId: null Order: 100 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

email_connections2

Many-To-One Relationship: connection email_connections2

Property	Value
ReferencingEntity	connection
ReferencingAttribute	record2id
ReferencedEntityNavigationPropertyName	email_connections2
IsCustomizable	True
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: 100 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

Email_DuplicateBaseRecord

Many-To-One Relationship: duplicaterecord Email_DuplicateBaseRecord

Property	Value
ReferencingEntity	duplicaterecord
ReferencingAttribute	baserecordid
ReferencedEntityNavigationPropertyName	Email_DuplicateBaseRecord
IsCustomizable	False
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

Email_DuplicateMatchingRecord

Many-To-One Relationship: duplicaterecord Email_DuplicateMatchingRecord

Property	Value
ReferencingEntity	duplicaterecord
ReferencingAttribute	duplicaterecordid
ReferencedEntityNavigationPropertyName	Email_DuplicateMatchingRecord
IsCustomizable	False
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

email_email_CorrelatedActivityId

Many-To-One Relationship: email email_email_CorrelatedActivityId

Property	Value
ReferencingEntity	email
ReferencingAttribute	correlatedactivityid
ReferencedEntityNavigationPropertyName	email_email_CorrelatedActivityId
IsCustomizable	False
AssociatedMenuConfiguration	AvailableOffline: True Behavior: UseCollectionName Group: Details Label: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

email_email_parentactivityid

Many-To-One Relationship: email email_email_parentactivityid

Property	Value
ReferencingEntity	email
ReferencingAttribute	parentactivityid
ReferencedEntityNavigationPropertyName	email_email_parentactivityid
IsCustomizable	True
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

email_FileAttachments

Many-To-One Relationship: fileattachment email_FileAttachments

Property	Value
ReferencingEntity	fileattachment
ReferencingAttribute	objectid
ReferencedEntityNavigationPropertyName	email_FileAttachments
IsCustomizable	True
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

email_principalobjectattributeaccess

Many-To-One Relationship: principalobjectattributeaccess email_principalobjectattributeaccess

Property	Value
ReferencingEntity	principalobjectattributeaccess
ReferencingAttribute	objectid
ReferencedEntityNavigationPropertyName	email_principalobjectattributeaccess
IsCustomizable	False
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

Email_ProcessSessions

Many-To-One Relationship: processsession Email_ProcessSessions

Property	Value
ReferencingEntity	processsession
ReferencingAttribute	regardingobjectid
ReferencedEntityNavigationPropertyName	Email_ProcessSessions
IsCustomizable	False
AssociatedMenuConfiguration	AvailableOffline: True Behavior: UseCollectionName Group: Details Label: MenuId: null Order: 110 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

Email_QueueItem

Many-To-One Relationship: queueitem Email_QueueItem

Property	Value
ReferencingEntity	queueitem
ReferencingAttribute	objectid
ReferencedEntityNavigationPropertyName	Email_QueueItem
IsCustomizable	True
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

Email_SyncErrors

Many-To-One Relationship: syncerror Email_SyncErrors

Property	Value
ReferencingEntity	syncerror
ReferencingAttribute	regardingobjectid
ReferencedEntityNavigationPropertyName	Email_SyncErrors
IsCustomizable	True
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

slakpiinstance_email

Many-To-One Relationship: slakpiinstance slakpiinstance_email

Property	Value
ReferencingEntity	slakpiinstance
ReferencingAttribute	regarding
ReferencedEntityNavigationPropertyName	slakpiinstance_email
IsCustomizable	True
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

See also

Dataverse table/entity reference
Dataverse Web API Reference
email