Exchange Sync Id Mapping (ExchangeSyncIdMapping) table/entity reference (Microsoft Dataverse)

2025-08-28

The mapping used to keep track of the IDs for items synced between CRM and Exchange.

Messages

The following table lists the messages for the Exchange Sync Id Mapping (ExchangeSyncIdMapping) 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
`Associate` Event: True	Associate records	Associate records
`Create` Event: True	`POST` /exchangesyncidmappings See Create	Create records
`Delete` Event: True	`DELETE` /exchangesyncidmappings(exchangesyncidmappingid) See Delete	Delete records
`Disassociate` Event: True	Disassociate records	Disassociate records
`Retrieve` Event: True	`GET` /exchangesyncidmappings(exchangesyncidmappingid) See Retrieve	Retrieve records
`RetrieveMultiple` Event: True	`GET` /exchangesyncidmappings See Query data	Query data
`Update` Event: True	`PATCH` /exchangesyncidmappings(exchangesyncidmappingid) See Update	Update records
`Upsert` Event: False	`PATCH` /exchangesyncidmappings(exchangesyncidmappingid) See Upsert a table row	UpsertRequest

Properties

The following table lists selected properties for the Exchange Sync Id Mapping (ExchangeSyncIdMapping) table.

Property	Value
DisplayName	Exchange Sync Id Mapping
DisplayCollectionName	Exchange Sync Id Mappings
SchemaName	`ExchangeSyncIdMapping`
CollectionSchemaName	`ExchangeSyncIdMappings`
EntitySetName	`exchangesyncidmappings`
LogicalName	`exchangesyncidmapping`
LogicalCollectionName	`exchangesyncidmappings`
PrimaryIdAttribute	`exchangesyncidmappingid`
TableType	`Standard`
OwnershipType	`UserOwned`

Writable columns/attributes

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

ExchangeEntryId
ExchangeSyncIdmappingId
FromCrmChangeType
IsDeletedInExchange
IsUnlinkedInCRM
ItemSubject
LastSyncError
LastSyncErrorCode
LastSyncErrorOccurredOn
ObjectId
ObjectTypeCode
OwnerId
OwnerIdType
Retries
ToCrmChangeType
UserDecision

ExchangeEntryId

Property	Value
Description
DisplayName	Exchange Id
IsValidForForm	False
IsValidForRead	True
LogicalName	`exchangeentryid`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	1024

ExchangeSyncIdmappingId

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`exchangesyncidmappingid`
RequiredLevel	SystemRequired
Type	Uniqueidentifier

FromCrmChangeType

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`fromcrmchangetype`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

IsDeletedInExchange

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`isdeletedinexchange`
RequiredLevel	None
Type	Boolean
GlobalChoiceName	`exchangesyncidmapping_isdeletedinexchange`
DefaultValue	False
True Label	Yes
False Label	No

IsUnlinkedInCRM

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`isunlinkedincrm`
RequiredLevel	None
Type	Boolean
GlobalChoiceName	`exchangesyncidmapping_isunlinkedincrm`
DefaultValue	False
True Label	Yes
False Label	No

ItemSubject

Property	Value
Description
DisplayName	Item Subject
IsValidForForm	False
IsValidForRead	True
LogicalName	`itemsubject`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	2048

LastSyncError

Property	Value
Description
DisplayName	Sync Error
IsValidForForm	False
IsValidForRead	True
LogicalName	`lastsyncerror`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	2048

LastSyncErrorCode

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`lastsyncerrorcode`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

LastSyncErrorOccurredOn

Property	Value
Description	Last Sync Error Time
DisplayName	Last Sync Error Time
IsValidForForm	False
IsValidForRead	True
LogicalName	`lastsyncerroroccurredon`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Auto
SourceTypeMask	0

ObjectId

Property	Value
Description
DisplayName	Crm Id
IsValidForForm	False
IsValidForRead	True
LogicalName	`objectid`
RequiredLevel	None
Type	Uniqueidentifier

ObjectTypeCode

Property	Value
Description
DisplayName	Object Type Code
IsValidForForm	False
IsValidForRead	True
LogicalName	`objecttypecode`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

OwnerId

Property	Value
Description
DisplayName	Owner
IsValidForForm	False
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

Retries

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`retries`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

ToCrmChangeType

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`tocrmchangetype`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

UserDecision

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`userdecision`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

Read-only columns/attributes

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

CreatedOn
ModifiedOn
OwnerIdName
OwnerIdYomiName
OwningBusinessUnit
OwningTeam
OwningUser
VersionNumber

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

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

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
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	`owningbusinessunit`
RequiredLevel	None
Type	Lookup
Targets	businessunit

OwningTeam

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`owningteam`
RequiredLevel	None
Type	Lookup
Targets	team

OwningUser

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`owninguser`
RequiredLevel	None
Type	Lookup
Targets	systemuser

VersionNumber

Property	Value
Description
DisplayName
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.

business_unit_exchangesyncidmapping
owner_exchangesyncidmapping
team_exchangesyncidmapping
user_exchangesyncidmapping

business_unit_exchangesyncidmapping

One-To-Many Relationship: businessunit business_unit_exchangesyncidmapping

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

owner_exchangesyncidmapping

One-To-Many Relationship: owner owner_exchangesyncidmapping

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

team_exchangesyncidmapping

One-To-Many Relationship: team team_exchangesyncidmapping

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

user_exchangesyncidmapping

One-To-Many Relationship: systemuser user_exchangesyncidmapping

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

Feedback

Was this page helpful?