Share via


Email (E-mail) Entity Metadata

[Applies to: Microsoft Dynamics CRM 2011]

The following information is for the email entity in a default, uncustomized installation of Microsoft Dynamics CRM. The schema name and early bound class for this entity is Email.

To view the entity metadata for your organization, install the Metadata Browser solution described in Browse the Metadata for Your Organization.

In This Topic

Entity Metadata

Privilege Metadata

Attribute Metadata

One-to-Many Relationships

Many-to-Many Relationships

Many-to-One Relationships

Entity Metadata

The following table shows the metadata for the email entity.

Entity metadata property Value

OTC

4202

EntityLogicalName

email

DisplayName

E-mail

DisplayCollectionName

E-mail Messages

IsCustomizable

True

OwnershipType

UserOwned

AutoRouteToOwnerQueue

False

CanBeInManyToMany

True

CanBePrimaryEntityInRelationship

True

CanBeRelatedEntityInRelationship

True

CanCreateAttributes

True

CanCreateCharts

True

CanCreateForms

True

CanCreateViews

True

CanModifyAdditionalSettings

True

CanTriggerWorkflow

True

IsActivity

True

IsActivityParty

False

IsAuditEnabled

False

IsAvailableOffline

True

IsChildEntity

False

IsConnectionsEnabled

canmodifyconnectionsettings

IsCustomEntity

False

IsDocumentManagementEnabled

False

IsDuplicateDetectionEnabled

False

IsEnabledForCharts

True

IsImportable

True

IsIntersect

False

IsMailMergeEnabled

False

IsManaged

True

IsMappable

True

IsReadingPaneEnabled

True

IsRenameable

True

IsValidForAdvancedFind

True

IsValidForQueue

True

IsVisibleInMobile

False

PrimaryIdAttribute

activityid

PrimaryNameAttribute

subject

ReportViewName

FilteredEmail

Description

Activity that is delivered using e-mail protocols.

Privilege Metadata

The following table shows the privilege metadata for the email entity.

PrivilegeName Id Type CanBeBasic CanBeDeep CanBeGlobal CanBeLocal

prvAppendActivity

78777c10-09ab-4326-b4c8-cf5729702937

Append

True

True

True

True

prvAppendToActivity

6ec8e901-d770-44c0-8f12-d07425f638bd

AppendTo

True

True

True

True

prvAssignActivity

8b99344e-ebbf-4f84-8438-e1e34d194de9

Assign

True

True

True

True

prvCreateActivity

091df793-fe5e-44d4-b4ca-7e3f580c4664

Create

True

True

True

True

prvDeleteActivity

bb4457f2-9b45-4482-a95a-7adef25f388a

Delete

True

True

True

True

prvReadActivity

650c14fe-3521-45fe-a000-84138688e45d

Read

True

True

True

True

prvShareActivity

b5f2ee06-d359-4495-bbda-312aae1c6b1e

Share

True

True

True

True

prvWriteActivity

0dc8f72c-57d5-4b4d-8892-fe6aac0e4b81

Write

True

True

True

True

Attribute Metadata

The following table shows the attribute metadata for the email entity.

LogicalName SchemaName Type RequiredLevel IsValidForCreate IsValidForRead IsValidForUpdate CanBeSecuredForCreate CanBeSecuredForRead CanBeSecuredForUpdate IsCustomizable IsAuditEnabled IsManaged IsPrimaryId IsPrimaryName IsRenameable IsSecured IsValidForAdvancedFind DisplayName DeprecatedVersion Description

activityid

ActivityId

Uniqueidentifier

SystemRequired

True

True

False

False

False

False

True

False

True

True

False

True

False

True

E-mail Message

Unique identifier of the e-mail activity.

activitytypecode

ActivityTypeCode

EntityName

SystemRequired

False

True

False

False

False

False

True

True

True

False

False

True

False

True

Activity Type

Type of activity.

actualdurationminutes

ActualDurationMinutes

Integer

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Duration

Duration of the e-mail activity specified in minutes.

actualend

ActualEnd

DateTime

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Actual End

Time when the e-mail activity ends.

actualstart

ActualStart

DateTime

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Actual Start

Time when the e-mail activity begins.

bcc

bcc

PartyList

None

True

True

True

False

False

False

True

True

True

False

False

True

False

False

Bcc

Blind carbon copy (BCC) recipients.

category

Category

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Category

Category of the activity.

cc

cc

PartyList

None

True

True

True

False

False

False

True

True

True

False

False

True

False

False

Cc

Carbon copy (CC) recipients.

compressed

Compressed

Boolean

SystemRequired

False

True

False

False

False

False

True

True

True

False

False

True

False

True

Compression

Indicates if the body is compressed.

createdby

CreatedBy

Lookup

None

False

True

False

False

False

False

True

False

True

False

False

True

False

True

Created By

Unique identifier of the user who created the e-mail activity.

createdon

CreatedOn

DateTime

None

False

True

False

False

False

False

True

False

True

False

False

True

False

True

Created On

Date and time when the e-mail activity was created.

createdonbehalfby

CreatedOnBehalfBy

Lookup

None

False

True

False

False

False

False

True

False

True

False

False

True

False

True

Created By (Delegate)

Unique identifier of the delegate user who created the email.

deliveryattempts

DeliveryAttempts

Integer

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

No. of Delivery Attempts

Number of attempts made to deliver the e-mail.

deliveryreceiptrequested

DeliveryReceiptRequested

Boolean

None

True

True

True

False

False

False

True

True

True

False

False

False

False

False

Delivery Receipt Requested

Delivery receipt requested.

description

Description

Memo

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Description

Main body text of the e-mail.

directioncode

DirectionCode

Boolean

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Direction

Direction code for the e-mail: incoming or outgoing.

exchangerate

ExchangeRate

Decimal

None

False

True

False

False

False

False

True

True

True

False

False

True

False

True

Exchange Rate

Exchange rate for the currency associated with the email with respect to the base currency.

from

from

PartyList

None

True

True

True

False

False

False

True

True

True

False

False

True

False

False

From

Who the e-mail is from.

importsequencenumber

ImportSequenceNumber

Integer

None

True

True

False

False

False

False

True

True

True

False

False

True

False

True

Import Sequence Number

Unique identifier of the data import or data migration that created this record.

isbilled

IsBilled

Boolean

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Is Billed

Information regarding whether the e-mail activity was billed as part of resolving a case.

isregularactivity

IsRegularActivity

Boolean

SystemRequired

False

True

False

False

False

False

True

True

True

False

False

True

False

True

Is Regular Activity

Information regarding whether the activity is a regular activity type or event type.

isworkflowcreated

IsWorkflowCreated

Boolean

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Is Workflow Created

Indication if the e-mail was created by a workflow rule.

messageid

MessageId

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Message ID

Unique identifier of the e-mail message. Used only for e-mail that is received.

messageiddupcheck

MessageIdDupCheck

Uniqueidentifier

SystemRequired

True

False

True

False

False

False

False

False

True

False

False

False

False

False

Message ID Dup Check

For internal use only.

mimetype

MimeType

String

None

True

True

True

False

False

False

True

True

True

False

False

False

False

False

Mime Type

MIME type of the e-mail message data.

modifiedby

ModifiedBy

Lookup

None

False

True

False

False

False

False

True

False

True

False

False

True

False

True

Modified By

Unique identifier of the user who last modified the e-mail activity.

modifiedon

ModifiedOn

DateTime

None

False

True

False

False

False

False

True

False

True

False

False

True

False

True

Modified On

Date and time when the e-mail activity was last modified.

modifiedonbehalfby

ModifiedOnBehalfBy

Lookup

None

False

True

False

False

False

False

True

False

True

False

False

True

False

True

Modified By (Delegate)

Unique identifier of the delegate user who last modified the email.

notifications

Notifications

Picklist

None

True

True

True

False

False

False

True

True

True

False

False

True

False

False

Notifications

Notifications for detail form.

overriddencreatedon

OverriddenCreatedOn

DateTime

None

True

True

False

False

False

False

True

True

True

False

False

True

False

True

Record Created On

Date and time that the record was migrated.

ownerid

OwnerId

Owner

SystemRequired

True

True

False

False

False

False

True

True

True

False

False

True

False

True

Owner

Unique identifier of the user or team who owns the e-mail activity.

owningbusinessunit

OwningBusinessUnit

Lookup

None

False

True

False

False

False

False

True

False

True

False

False

False

False

False

Owning Business Unit

Unique identifier of the business unit that owns the e-mail activity.

owningteam

OwningTeam

Lookup

None

False

True

False

False

False

False

True

False

True

False

False

True

False

True

Owning Team

Unique identifier of the team who owns the e-mail activity.

owninguser

OwningUser

Lookup

None

False

True

False

False

False

False

True

False

True

False

False

True

False

True

Owning User

Unique identifier of the user who owns the e-mail activity.

prioritycode

PriorityCode

Picklist

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Priority

Priority code of the e-mail.

readreceiptrequested

ReadReceiptRequested

Boolean

None

True

True

True

False

False

False

True

True

True

False

False

False

False

False

Read Receipt Requested

Indicates that a read receipt is requested.

regardingobjectid

RegardingObjectId

Lookup

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Regarding

Unique identifier of the object with which the e-mail is associated.

scheduleddurationminutes

ScheduledDurationMinutes

Integer

None

False

True

False

False

False

False

True

True

True

False

False

True

False

True

Scheduled Duration

Scheduled duration of the e-mail activity, specified in minutes.

scheduledend

ScheduledEnd

DateTime

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Due Date

Scheduled end time of the e-mail activity.

scheduledstart

ScheduledStart

DateTime

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Start Date

Scheduled start time of the e-mail activity.

sender

Sender

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Sender

Sender of the e-mail.

serviceid

ServiceId

Lookup

None

True

True

True

False

False

False

True

True

True

False

False

False

False

False

Service

Unique identifier for the associated service.

statecode

StateCode

State

SystemRequired

False

True

False

False

False

False

True

True

True

False

False

True

False

True

Activity Status

Status of the e-mail activity.

statuscode

StatusCode

Status

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Status Reason

Reason for the status of the e-mail activity.

subcategory

Subcategory

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Sub-Category

Subcategory of the e-mail activity.

subject

Subject

String

None

True

True

True

False

False

False

True

True

True

False

True

True

False

True

Subject

Subject associated with the e-mail activity.

submittedby

SubmittedBy

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Submitted By

E-mail delivery source.

timezoneruleversionnumber

TimeZoneRuleVersionNumber

Integer

None

True

True

True

False

False

False

True

False

True

False

False

False

False

False

Time Zone Rule Version Number

For internal use only.

to

to

PartyList

None

True

True

True

False

False

False

True

True

True

False

False

True

False

False

To

Recipient party list for the e-mail, and references recipient records such as users and queues.

torecipients

ToRecipients

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

To Recipients

String that lists e-mail addresses corresponding to the recipients.

trackingtoken

TrackingToken

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Tracking Token

Tracking token number.

transactioncurrencyid

TransactionCurrencyId

Lookup

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Currency

Unique identifier of the currency associated with the email.

utcconversiontimezonecode

UTCConversionTimeZoneCode

Integer

None

True

True

True

False

False

False

True

False

True

False

False

False

False

False

UTC Conversion Time Zone Code

Time zone code that was in use when the record was created.

versionnumber

VersionNumber

BigInt

None

False

True

False

False

False

False

False

False

True

False

False

False

False

False

Version Number

Version number of the e-mail message.

One-to-Many Relationships

The following table shows the entities that are the referencing entity in a one-to-many relationship with the email entity.

Relationship schema name Referencing entity

email_activity_mime_attachment

activitymimeattachment

email_activity_parties

activityparty

Email_Annotation

annotation

Email_AsyncOperations

asyncoperation

Email_BulkDeleteFailures

bulkdeletefailure

email_campaignresponse

campaignresponse

email_connections1

connection

email_connections2

connection

Email_DuplicateMatchingRecord

duplicaterecord

Email_DuplicateBaseRecord

duplicaterecord

email_email_hash

emailhash

email_principalobjectattributeaccess

principalobjectattributeaccess

Email_ProcessSessions

processsession

Email_QueueItem

queueitem

userentityinstancedata_email

userentityinstancedata

Many-to-Many Relationships

There are no many-to-many relationships for the email entity.

Many-to-One Relationships

The following table shows the entities that are the referenced entity in a many-to-one relationship with the email entity.

Relationship schema name Referenced entity

Account_Emails

account

activity_pointer_email

activitypointer

AsyncOperation_Emails

asyncoperation

BulkOperation_Email

bulkoperation

business_unit_email_activities

businessunit

Campaign_Emails

campaign

CampaignActivity_Emails

campaignactivity

Contact_Emails

contact

Contract_Emails

contract

Incident_Emails

incident

Invoice_Emails

invoice

Lead_Emails

lead

msdyn_postalbum_Emails

msdyn_postalbum

Opportunity_Emails

opportunity

Quote_Emails

quote

SalesOrder_Emails

salesorder

service_emails

service

lk_email_modifiedby

systemuser

user_email

systemuser

lk_email_createdonbehalfby

systemuser

lk_email_modifiedonbehalfby

systemuser

lk_email_createdby

systemuser

team_email

team

TransactionCurrency_Email

transactioncurrency

See Also

Reference

EntityMetadata
AttributeMetadata
OneToManyRelationshipMetadata
ManyToManyRelationshipMetadata

Concepts

Email (E-mail) Activity Entities
Email (E-mail) Entity Messages and Methods
Email Entity Privileges

Microsoft Dynamics CRM 2011
Send comments about this topic to Microsoft.
© 2013 Microsoft Corporation. All rights reserved.