Email (E-mail) Entity Metadata

Article
10/04/2013

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

Email (E-mail) Entity Metadata

In This Topic

Entity Metadata

Privilege Metadata

Attribute Metadata

One-to-Many Relationships

Many-to-Many Relationships

Many-to-One Relationships

See Also

Reference

Concepts

Additional resources