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
10410	Invitation
10411	Invite Redemption
10430	Publishing State Transition Rule
10432	Shortcut
10444	Website
10489	Customer Asset
10511	IoT Alert
10512	IoT Device
10513	IoT Device Category
10514	IoT Device Command
10518	IoT Device Registration History
10719	Profile Album
10724	Customer Voice alert
10739	Customer Voice survey invite
10742	Customer Voice survey response
10828	Ongoing conversation (Deprecated)
10840	Conversation
10857	Session
11011	Sequence
11013	Sequence Target
11025	Assignment Rule
11028	Assignment Map
11035	Insight
11044	Suggestion Principal Object Access
11125	Copilot Transcript
11365	Booking Alert
11366	Booking Alert Status
11368	Booking Rule
11379	Resource Territory
11382	System User Scheduler Setting
11383	Fulfillment Preference
11384	Time Group Detail
11452	Voicemail
11466	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
10410	Invitation
10411	Invite Redemption
10430	Publishing State Transition Rule
10432	Shortcut
10444	Website
10489	Customer Asset
10511	IoT Alert
10512	IoT Device
10513	IoT Device Category
10514	IoT Device Command
10518	IoT Device Registration History
10719	Profile Album
10724	Customer Voice alert
10739	Customer Voice survey invite
10742	Customer Voice survey response
10828	Ongoing conversation (Deprecated)
10840	Conversation
10857	Session
11011	Sequence
11013	Sequence Target
11025	Assignment Rule
11028	Assignment Map
11035	Insight
11044	Suggestion Principal Object Access
11125	Copilot Transcript
11365	Booking Alert
11366	Booking Alert Status
11368	Booking Rule
11379	Resource Territory
11382	System User Scheduler Setting
11383	Fulfillment Preference
11384	Time Group Detail
11452	Voicemail
11466	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

See also

Dataverse table/entity reference
Dataverse Web API Reference
connection