Connection table/entity reference (Microsoft Dynamics 365 Customer Service)

2025-05-23

Relationship between two entities.

Note

The Microsoft Dynamics 365 Customer Service Connection table extends the Microsoft Dynamics 365 Connection table.

Customized columns/attributes

Microsoft Dynamics 365 Customer Service modifies the definition of columns/attributes defined in other solutions. Listed by SchemaName.

Record1Id
Record1ObjectTypeCode
Record2Id
Record2ObjectTypeCode

Record1Id

Changes from Record1Id (Microsoft Dataverse)

Property	Value
Targets	msdyn_bookingalert, msdyn_bookingalertstatus, msdyn_bookingrule, msdyn_ocoutboundmessage, msdyn_resourceterritory, msdyn_systemuserschedulersetting, msdyn_timegroup, msdyn_timegroupdetail

Record1ObjectTypeCode

Changes from Record1ObjectTypeCode (Microsoft Dataverse)

Record1ObjectTypeCode Choices/Options

Value	Label
10358	Invitation
10359	Invite Redemption
10378	Publishing State Transition Rule
10380	Shortcut
10392	Website
10434	Customer Asset
10456	IoT Alert
10457	IoT Device
10458	IoT Device Category
10459	IoT Device Command
10463	IoT Device Registration History
10662	Profile Album
10667	Customer Voice alert
10677	Customer Voice survey invite
10679	Customer Voice survey response
10760	Ongoing conversation (Deprecated)
10772	Conversation
10789	Session
10909	Sequence
10911	Sequence Target
10923	Assignment Rule
10926	Assignment Map
10933	Insight
10942	Suggestion Principal Object Access
10993	Copilot Transcript
11089	Booking Alert
11090	Booking Alert Status
11092	Booking Rule
11102	Resource Territory
11105	System User Scheduler Setting
11106	Fulfillment Preference
11107	Time Group Detail
11168	Outbound message

Record2Id

Changes from Record2Id (Microsoft Dataverse)

Property	Value
Targets	msdyn_bookingalert, msdyn_bookingalertstatus, msdyn_bookingrule, msdyn_ocoutboundmessage, msdyn_resourceterritory, msdyn_systemuserschedulersetting, msdyn_timegroup, msdyn_timegroupdetail

Record2ObjectTypeCode

Changes from Record2ObjectTypeCode (Microsoft Dataverse)

Record2ObjectTypeCode Choices/Options

Value	Label
10358	Invitation
10359	Invite Redemption
10378	Publishing State Transition Rule
10380	Shortcut
10392	Website
10434	Customer Asset
10456	IoT Alert
10457	IoT Device
10458	IoT Device Category
10459	IoT Device Command
10463	IoT Device Registration History
10662	Profile Album
10667	Customer Voice alert
10677	Customer Voice survey invite
10679	Customer Voice survey response
10760	Ongoing conversation (Deprecated)
10772	Conversation
10789	Session
10909	Sequence
10911	Sequence Target
10923	Assignment Rule
10926	Assignment Map
10933	Insight
10942	Suggestion Principal Object Access
10993	Copilot Transcript
11089	Booking Alert
11090	Booking Alert Status
11092	Booking Rule
11102	Resource Territory
11105	System User Scheduler Setting
11106	Fulfillment Preference
11107	Time Group Detail
11168	Outbound message

Many-to-One relationships

These relationships are many-to-one. Listed by SchemaName.

msdyn_bookingalert_connections1
msdyn_bookingalert_connections2
msdyn_bookingalertstatus_connections1
msdyn_bookingalertstatus_connections2
msdyn_bookingrule_connections1
msdyn_bookingrule_connections2
msdyn_ocoutboundmessage_connections1
msdyn_ocoutboundmessage_connections2
msdyn_resourceterritory_connections1
msdyn_resourceterritory_connections2
msdyn_systemuserschedulersetting_connections1
msdyn_systemuserschedulersetting_connections2
msdyn_timegroup_connections1
msdyn_timegroup_connections2
msdyn_timegroupdetail_connections1
msdyn_timegroupdetail_connections2

msdyn_bookingalert_connections1

One-To-Many Relationship: msdyn_bookingalert msdyn_bookingalert_connections1

Property	Value
ReferencedEntity	`msdyn_bookingalert`
ReferencedAttribute	`activityid`
ReferencingAttribute	`record1id`
ReferencingEntityNavigationPropertyName	`record1id_msdyn_bookingalert`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

msdyn_bookingalert_connections2

One-To-Many Relationship: msdyn_bookingalert msdyn_bookingalert_connections2

Property	Value
ReferencedEntity	`msdyn_bookingalert`
ReferencedAttribute	`activityid`
ReferencingAttribute	`record2id`
ReferencingEntityNavigationPropertyName	`record2id_msdyn_bookingalert`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

msdyn_bookingalertstatus_connections1

One-To-Many Relationship: msdyn_bookingalertstatus msdyn_bookingalertstatus_connections1

Property	Value
ReferencedEntity	`msdyn_bookingalertstatus`
ReferencedAttribute	`msdyn_bookingalertstatusid`
ReferencingAttribute	`record1id`
ReferencingEntityNavigationPropertyName	`record1id_msdyn_bookingalertstatus`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

msdyn_bookingalertstatus_connections2

One-To-Many Relationship: msdyn_bookingalertstatus msdyn_bookingalertstatus_connections2

Property	Value
ReferencedEntity	`msdyn_bookingalertstatus`
ReferencedAttribute	`msdyn_bookingalertstatusid`
ReferencingAttribute	`record2id`
ReferencingEntityNavigationPropertyName	`record2id_msdyn_bookingalertstatus`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

msdyn_bookingrule_connections1

One-To-Many Relationship: msdyn_bookingrule msdyn_bookingrule_connections1

Property	Value
ReferencedEntity	`msdyn_bookingrule`
ReferencedAttribute	`msdyn_bookingruleid`
ReferencingAttribute	`record1id`
ReferencingEntityNavigationPropertyName	`record1id_msdyn_bookingrule`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

msdyn_bookingrule_connections2

One-To-Many Relationship: msdyn_bookingrule msdyn_bookingrule_connections2

Property	Value
ReferencedEntity	`msdyn_bookingrule`
ReferencedAttribute	`msdyn_bookingruleid`
ReferencingAttribute	`record2id`
ReferencingEntityNavigationPropertyName	`record2id_msdyn_bookingrule`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

msdyn_ocoutboundmessage_connections1

One-To-Many Relationship: msdyn_ocoutboundmessage msdyn_ocoutboundmessage_connections1

Property	Value
ReferencedEntity	`msdyn_ocoutboundmessage`
ReferencedAttribute	`activityid`
ReferencingAttribute	`record1id`
ReferencingEntityNavigationPropertyName	`record1id_msdyn_ocoutboundmessage`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

msdyn_ocoutboundmessage_connections2

One-To-Many Relationship: msdyn_ocoutboundmessage msdyn_ocoutboundmessage_connections2

Property	Value
ReferencedEntity	`msdyn_ocoutboundmessage`
ReferencedAttribute	`activityid`
ReferencingAttribute	`record2id`
ReferencingEntityNavigationPropertyName	`record2id_msdyn_ocoutboundmessage`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

msdyn_resourceterritory_connections1

One-To-Many Relationship: msdyn_resourceterritory msdyn_resourceterritory_connections1

Property	Value
ReferencedEntity	`msdyn_resourceterritory`
ReferencedAttribute	`msdyn_resourceterritoryid`
ReferencingAttribute	`record1id`
ReferencingEntityNavigationPropertyName	`record1id_msdyn_resourceterritory`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

msdyn_resourceterritory_connections2

One-To-Many Relationship: msdyn_resourceterritory msdyn_resourceterritory_connections2

Property	Value
ReferencedEntity	`msdyn_resourceterritory`
ReferencedAttribute	`msdyn_resourceterritoryid`
ReferencingAttribute	`record2id`
ReferencingEntityNavigationPropertyName	`record2id_msdyn_resourceterritory`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

msdyn_systemuserschedulersetting_connections1

One-To-Many Relationship: msdyn_systemuserschedulersetting msdyn_systemuserschedulersetting_connections1

Property	Value
ReferencedEntity	`msdyn_systemuserschedulersetting`
ReferencedAttribute	`msdyn_systemuserschedulersettingid`
ReferencingAttribute	`record1id`
ReferencingEntityNavigationPropertyName	`record1id_msdyn_systemuserschedulersetting`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

msdyn_systemuserschedulersetting_connections2

One-To-Many Relationship: msdyn_systemuserschedulersetting msdyn_systemuserschedulersetting_connections2

Property	Value
ReferencedEntity	`msdyn_systemuserschedulersetting`
ReferencedAttribute	`msdyn_systemuserschedulersettingid`
ReferencingAttribute	`record2id`
ReferencingEntityNavigationPropertyName	`record2id_msdyn_systemuserschedulersetting`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

msdyn_timegroup_connections1

One-To-Many Relationship: msdyn_timegroup msdyn_timegroup_connections1

Property	Value
ReferencedEntity	`msdyn_timegroup`
ReferencedAttribute	`msdyn_timegroupid`
ReferencingAttribute	`record1id`
ReferencingEntityNavigationPropertyName	`record1id_msdyn_timegroup`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

msdyn_timegroup_connections2

One-To-Many Relationship: msdyn_timegroup msdyn_timegroup_connections2

Property	Value
ReferencedEntity	`msdyn_timegroup`
ReferencedAttribute	`msdyn_timegroupid`
ReferencingAttribute	`record2id`
ReferencingEntityNavigationPropertyName	`record2id_msdyn_timegroup`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

msdyn_timegroupdetail_connections1

One-To-Many Relationship: msdyn_timegroupdetail msdyn_timegroupdetail_connections1

Property	Value
ReferencedEntity	`msdyn_timegroupdetail`
ReferencedAttribute	`msdyn_timegroupdetailid`
ReferencingAttribute	`record1id`
ReferencingEntityNavigationPropertyName	`record1id_msdyn_timegroupdetail`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

msdyn_timegroupdetail_connections2

One-To-Many Relationship: msdyn_timegroupdetail msdyn_timegroupdetail_connections2

Property	Value
ReferencedEntity	`msdyn_timegroupdetail`
ReferencedAttribute	`msdyn_timegroupdetailid`
ReferencingAttribute	`record2id`
ReferencingEntityNavigationPropertyName	`record2id_msdyn_timegroupdetail`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`