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

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

Record1ObjectTypeCode

Changes from Record1ObjectTypeCode (Microsoft Dataverse)

Record1ObjectTypeCode Choices/Options

Value	Label
11209	Booking Alert
11210	Booking Alert Status
11212	Booking Rule
11221	Resource Territory
11224	System User Scheduler Setting
11225	Fulfillment Preference
11226	Time Group Detail
11293	Voicemail
11304	Outbound message

Record2Id

Changes from Record2Id (Microsoft Dataverse)

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

Record2ObjectTypeCode

Changes from Record2ObjectTypeCode (Microsoft Dataverse)

Record2ObjectTypeCode Choices/Options

Value	Label
11209	Booking Alert
11210	Booking Alert Status
11212	Booking Rule
11221	Resource Territory
11224	System User Scheduler Setting
11225	Fulfillment Preference
11226	Time Group Detail
11293	Voicemail
11304	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_ocvoicemail_connections1
msdyn_ocvoicemail_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_ocvoicemail_connections1

One-To-Many Relationship: msdyn_ocvoicemail msdyn_ocvoicemail_connections1

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

msdyn_ocvoicemail_connections2

One-To-Many Relationship: msdyn_ocvoicemail msdyn_ocvoicemail_connections2

Property	Value
ReferencedEntity	`msdyn_ocvoicemail`
ReferencedAttribute	`activityid`
ReferencingAttribute	`record2id`
ReferencingEntityNavigationPropertyName	`record2id_msdyn_ocvoicemail`
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`

Feedback

Was this page helpful?

Last updated on 2025-08-30