編輯

共用方式為


Email table/entity reference

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
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
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
SendTemplate
Event: True
SendTemplate SendTemplateRequest
SendEmail
Event: True
SendEmail SendEmailRequest
SendFax
Event: True
SendFax SendFaxRequest
SendEmailFromTemplate
Event: True
SendEmailFromTemplate SendEmailFromTemplateRequest
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

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
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

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

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

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