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

Статья
02/08/2025

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_resourceterritory, msdyn_systemuserschedulersetting, msdyn_timegroup, msdyn_timegroupdetail

Record1ObjectTypeCode

Changes from Record1ObjectTypeCode (Microsoft Dataverse)

Record1ObjectTypeCode Choices/Options

Value	Label
10627	Profile Album
10632	Customer Voice alert
10642	Customer Voice survey invite
10644	Customer Voice survey response
10718	Ongoing conversation (Deprecated)
10730	Conversation
10747	Session
10863	Sequence
10865	Sequence Target
10877	Assignment Rule
10880	Assignment Map
10887	Insight
10896	Suggestion Principal Object Access
10942	Copilot Transcript
11058	Booking Alert
11059	Booking Alert Status
11061	Booking Rule
11070	Resource Territory
11073	System User Scheduler Setting
11074	Fulfillment Preference
11075	Time Group Detail

Record2Id

Changes from Record2Id (Microsoft Dataverse)

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

Record2ObjectTypeCode

Changes from Record2ObjectTypeCode (Microsoft Dataverse)

Record2ObjectTypeCode Choices/Options

Value	Label
10627	Profile Album
10632	Customer Voice alert
10642	Customer Voice survey invite
10644	Customer Voice survey response
10718	Ongoing conversation (Deprecated)
10730	Conversation
10747	Session
10863	Sequence
10865	Sequence Target
10877	Assignment Rule
10880	Assignment Map
10887	Insight
10896	Suggestion Principal Object Access
10942	Copilot Transcript
11058	Booking Alert
11059	Booking Alert Status
11061	Booking Rule
11070	Resource Territory
11073	System User Scheduler Setting
11074	Fulfillment Preference
11075	Time Group Detail

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_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_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`

Поделиться через