Power BI Connector for Microsoft Dynamics CRM

Build 25.0.9454

Email

This is a table representing the Email entities in Dynamics CRM.

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier of the email.

ActivityId String False

Unique identifier of the email activity.

ActivityTypeCode String True

Type of activity.

ActualDurationMinutes Integer False

Duration of the email activity specified in minutes.

ActualEnd Datetime False

Time when the email activity ends.

ActualStart Datetime False

Time when the email activity begins.

bcc_Ids String False

Blind carbon copy (BCC) recipients.

bcc_LogicalNames String False

bcc_Names String False

Category String False

Category of the activity.

cc_Ids String False

Carbon copy (CC) recipients.

cc_LogicalNames String False

cc_Names String False

Compressed Boolean True

Indicates if the body is compressed.

CreatedBy_Id String True

Unique identifier of the user who created the email activity.

CreatedBy_LogicalName String True

CreatedBy_Name String True

CreatedOn Datetime True

Date and time when the email activity was created.

CreatedOnBehalfBy_Id String True

Unique identifier of the delegate user who created the email.

CreatedOnBehalfBy_LogicalName String True

CreatedOnBehalfBy_Name String True

DeliveryAttempts Integer False

Number of attempts made to deliver the email.

DeliveryReceiptRequested Boolean False

Delivery receipt requested.

Description String False

Main body text of the email.

DirectionCode Boolean False

Direction code for the email: incoming or outgoing.

ExchangeRate Double True

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

from_Ids String False

Who the email is from.

from_LogicalNames String False

from_Names String False

ImportSequenceNumber Integer False

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

IsBilled Boolean False

Information regarding whether the email activity was billed as part of resolving a case.

IsRegularActivity Boolean True

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

IsWorkflowCreated Boolean False

Indication if the email was created by a workflow rule.

MessageId String False

Unique identifier of the email message. Used only for email that is received.

MimeType String False

MIME type of the email message data.

ModifiedBy_Id String True

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

ModifiedBy_LogicalName String True

ModifiedBy_Name String True

ModifiedOn Datetime True

Date and time when the email activity was last modified.

ModifiedOnBehalfBy_Id String True

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

ModifiedOnBehalfBy_LogicalName String True

ModifiedOnBehalfBy_Name String True

Notifications String False

Notifications for detail form.

OverriddenCreatedOn Datetime False

Date and time that the record was migrated.

OwnerId_Id String False

Unique identifier of the user or team who owns the email activity.

OwnerId_LogicalName String False

OwnerId_Name String False

OwningBusinessUnit_Id String True

Unique identifier of the business unit that owns the email activity.

OwningBusinessUnit_LogicalName String True

OwningBusinessUnit_Name String True

OwningTeam_Id String True

Unique identifier of the team who owns the email activity.

OwningTeam_LogicalName String True

OwningTeam_Name String True

OwningUser_Id String True

Unique identifier of the user who owns the email activity.

OwningUser_LogicalName String True

OwningUser_Name String True

PriorityCode String False

Priority code of the email.

ReadReceiptRequested Boolean False

Indicates that a read receipt is requested.

RegardingObjectId_Id String False

Unique identifier of the object with which the email is associated.

RegardingObjectId_LogicalName String False

RegardingObjectId_Name String False

ScheduledDurationMinutes Integer True

Scheduled duration of the email activity, specified in minutes.

ScheduledEnd Datetime False

Scheduled end time of the email activity.

ScheduledStart Datetime False

Scheduled start time of the email activity.

Sender String False

Sender of the email.

ServiceId_Id String False

Unique identifier for the associated service.

ServiceId_LogicalName String False

ServiceId_Name String False

StateCode String True

Status of the email activity.

StatusCode String False

Reason for the status of the email activity.

Subcategory String False

Subcategory of the email activity.

Subject String False

Subject associated with the email activity.

SubmittedBy String False

email delivery source.

TimeZoneRuleVersionNumber Integer False

For internal use only.

to_Ids String False

Recipient party list for the email, and references recipient records such as users and queues.

to_LogicalNames String False

to_Names String False

ToRecipients String False

String that lists email addresses corresponding to the recipients.

TrackingToken String False

Tracking token number.

TransactionCurrencyId_Id String False

Unique identifier of the currency associated with the email.

TransactionCurrencyId_LogicalName String False

TransactionCurrencyId_Name String False

UTCConversionTimeZoneCode Integer False

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

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454