Connection table/entity reference (Microsoft Dynamics 365)

Relationship between two entities.

Note

The Microsoft Dynamics 365 Connection table extends the Microsoft Dataverse Connection table.

Customized columns/attributes

Microsoft Dynamics 365 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
Description	Unique identifier of the source record.
Targets	campaign, campaignactivity, competitor, constraintbasedgroup, contract, entitlement, entitlementchannel, entitlementtemplatechannel, equipment, incident, invoice, lead, list, msdyn_assignmentmap, msdyn_assignmentrule, msdyn_copilottranscript, msdyn_customerasset, msdyn_iotalert, msdyn_iotdevice, msdyn_iotdevicecategory, msdyn_iotdevicecommand, msdyn_iotdeviceregistrationhistory, msdyn_liveconversation, msdyn_ocliveworkitem, msdyn_ocsession, msdyn_postalbum, msdyn_salessuggestion, msdyn_sequence, msdyn_sequencetarget, msdyn_suggestionprincipalobjectaccess, msfp_alert, msfp_surveyinvite, msfp_surveyresponse, opportunity, pricelevel, product, quote, resourcegroup, salesorder, serviceappointment

Record1ObjectTypeCode

Changes from Record1ObjectTypeCode (Microsoft Dataverse)

Record1ObjectTypeCode Choices/Options

Value	Label
3	Opportunity
4	Lead
112	Case
123	Competitor
1010	Contract
1022	Price List
1024	Product
1084	Quote
1088	Order
1090	Invoice
4000	Facility/Equipment
4005	Scheduling Group
4007	Resource Group
4214	Service Activity
4300	Marketing List
4400	Campaign
4402	Campaign Activity
9700	Entitlement
9701	Entitlement Channel
9703	Entitlement Template Channel
10404	Invitation
10405	Invite Redemption
10424	Publishing State Transition Rule
10426	Shortcut
10438	Website
10483	Customer Asset
10505	IoT Alert
10506	IoT Device
10507	IoT Device Category
10508	IoT Device Command
10512	IoT Device Registration History
10712	Profile Album
10717	Customer Voice alert
10732	Customer Voice survey invite
10735	Customer Voice survey response
10821	Ongoing conversation (Deprecated)
10833	Conversation
10850	Session
10975	Sequence
10977	Sequence Target
10989	Assignment Rule
10992	Assignment Map
10999	Insight
11008	Suggestion Principal Object Access
11083	Copilot Transcript

Record2Id

Changes from Record2Id (Microsoft Dataverse)

Property	Value
Description	Unique identifier of the target record.
Targets	campaign, campaignactivity, competitor, constraintbasedgroup, contract, entitlement, entitlementchannel, entitlementtemplatechannel, equipment, incident, invoice, lead, list, msdyn_assignmentmap, msdyn_assignmentrule, msdyn_copilottranscript, msdyn_customerasset, msdyn_iotalert, msdyn_iotdevice, msdyn_iotdevicecategory, msdyn_iotdevicecommand, msdyn_iotdeviceregistrationhistory, msdyn_liveconversation, msdyn_ocliveworkitem, msdyn_ocsession, msdyn_postalbum, msdyn_salessuggestion, msdyn_sequence, msdyn_sequencetarget, msdyn_suggestionprincipalobjectaccess, msfp_alert, msfp_surveyinvite, msfp_surveyresponse, opportunity, pricelevel, product, quote, resourcegroup, salesorder, serviceappointment

Record2ObjectTypeCode

Changes from Record2ObjectTypeCode (Microsoft Dataverse)

Record2ObjectTypeCode Choices/Options

Value	Label
3	Opportunity
4	Lead
112	Case
123	Competitor
1010	Contract
1022	Price List
1024	Product
1084	Quote
1088	Order
1090	Invoice
4000	Facility/Equipment
4005	Scheduling Group
4007	Resource Group
4214	Service Activity
4300	Marketing List
4400	Campaign
4402	Campaign Activity
9700	Entitlement
9701	Entitlement Channel
9703	Entitlement Template Channel
10404	Invitation
10405	Invite Redemption
10424	Publishing State Transition Rule
10426	Shortcut
10438	Website
10483	Customer Asset
10505	IoT Alert
10506	IoT Device
10507	IoT Device Category
10508	IoT Device Command
10512	IoT Device Registration History
10712	Profile Album
10717	Customer Voice alert
10732	Customer Voice survey invite
10735	Customer Voice survey response
10821	Ongoing conversation (Deprecated)
10833	Conversation
10850	Session
10975	Sequence
10977	Sequence Target
10989	Assignment Rule
10992	Assignment Map
10999	Insight
11008	Suggestion Principal Object Access
11083	Copilot Transcript

Many-to-One relationships

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

• campaign_connections1
• campaign_connections2
• campaignactivity_connections1
• campaignactivity_connections2
• competitor_connections1
• competitor_connections2
• constraintbasedgroup_connections1
• constraintbasedgroup_connections2
• contract_connections1
• contract_connections2
• entitlement_connections1
• entitlement_connections2
• entitlementchannel_connections1
• entitlementchannel_connections2
• entitlementtemplatechannel_connections1
• entitlementtemplatechannel_connections2
• equipment_connections1
• equipment_connections2
• incident_connections1
• incident_connections2
• invoice_connections1
• invoice_connections2
• lead_connections1
• lead_connections2
• list_connections1
• list_connections2
• msdyn_assignmentmap_connections1
• msdyn_assignmentmap_connections2
• msdyn_assignmentrule_connections1
• msdyn_assignmentrule_connections2
• msdyn_copilottranscript_connections1
• msdyn_copilottranscript_connections2
• msdyn_customerasset_connections1
• msdyn_customerasset_connections2
• msdyn_iotalert_connections1
• msdyn_iotalert_connections2
• msdyn_iotdevice_connections1
• msdyn_iotdevice_connections2
• msdyn_iotdevicecategory_connections1
• msdyn_iotdevicecategory_connections2
• msdyn_iotdevicecommand_connections1
• msdyn_iotdevicecommand_connections2
• msdyn_iotdeviceregistrationhistory_connections1
• msdyn_iotdeviceregistrationhistory_connections2
• msdyn_ocliveworkitem_connections1
• msdyn_ocliveworkitem_connections2
• msdyn_ocsession_connections1
• msdyn_ocsession_connections2
• msdyn_postalbum_connections1
• msdyn_postalbum_connections2
• msdyn_salessuggestion_connections1
• msdyn_salessuggestion_connections2
• msdyn_sequence_connections1
• msdyn_sequence_connections2
• msdyn_sequencetarget_connections1
• msdyn_sequencetarget_connections2
• msdyn_suggestionprincipalobjectaccess_connections1
• msdyn_suggestionprincipalobjectaccess_connections2
• msfp_alert_connections1
• msfp_alert_connections2
• msfp_surveyinvite_connections1
• msfp_surveyinvite_connections2
• msfp_surveyresponse_connections1
• msfp_surveyresponse_connections2
• opportunity_connections1
• opportunity_connections2
• pricelevel_connections1
• pricelevel_connections2
• product_connections1
• product_connections2
• quote_connections1
• quote_connections2
• resourcegroup_connections1
• resourcegroup_connections2
• salesorder_connections1
• salesorder_connections2
• serviceappointment_connections1
• serviceappointment_connections2

campaign_connections1

One-To-Many Relationship: campaign campaign_connections1

Property	Value
ReferencedEntity	campaign
ReferencedAttribute	campaignid
ReferencingAttribute	record1id
ReferencingEntityNavigationPropertyName	record1id_campaign
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

campaign_connections2

One-To-Many Relationship: campaign campaign_connections2

Property	Value
ReferencedEntity	campaign
ReferencedAttribute	campaignid
ReferencingAttribute	record2id
ReferencingEntityNavigationPropertyName	record2id_campaign
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

campaignactivity_connections1

One-To-Many Relationship: campaignactivity campaignactivity_connections1

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

campaignactivity_connections2

One-To-Many Relationship: campaignactivity campaignactivity_connections2

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

competitor_connections1

One-To-Many Relationship: competitor competitor_connections1

Property	Value
ReferencedEntity	competitor
ReferencedAttribute	competitorid
ReferencingAttribute	record1id
ReferencingEntityNavigationPropertyName	record1id_competitor
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

competitor_connections2

One-To-Many Relationship: competitor competitor_connections2

Property	Value
ReferencedEntity	competitor
ReferencedAttribute	competitorid
ReferencingAttribute	record2id
ReferencingEntityNavigationPropertyName	record2id_competitor
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

constraintbasedgroup_connections1

One-To-Many Relationship: constraintbasedgroup constraintbasedgroup_connections1

Property	Value
ReferencedEntity	constraintbasedgroup
ReferencedAttribute	constraintbasedgroupid
ReferencingAttribute	record1id
ReferencingEntityNavigationPropertyName	record1id_constraintbasedgroup
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

constraintbasedgroup_connections2

One-To-Many Relationship: constraintbasedgroup constraintbasedgroup_connections2

Property	Value
ReferencedEntity	constraintbasedgroup
ReferencedAttribute	constraintbasedgroupid
ReferencingAttribute	record2id
ReferencingEntityNavigationPropertyName	record2id_constraintbasedgroup
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

contract_connections1

One-To-Many Relationship: contract contract_connections1

Property	Value
ReferencedEntity	contract
ReferencedAttribute	contractid
ReferencingAttribute	record1id
ReferencingEntityNavigationPropertyName	record1id_contract
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

contract_connections2

One-To-Many Relationship: contract contract_connections2

Property	Value
ReferencedEntity	contract
ReferencedAttribute	contractid
ReferencingAttribute	record2id
ReferencingEntityNavigationPropertyName	record2id_contract
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

entitlement_connections1

One-To-Many Relationship: entitlement entitlement_connections1

Property	Value
ReferencedEntity	entitlement
ReferencedAttribute	entitlementid
ReferencingAttribute	record1id
ReferencingEntityNavigationPropertyName	record1id_entitlement
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

entitlement_connections2

One-To-Many Relationship: entitlement entitlement_connections2

Property	Value
ReferencedEntity	entitlement
ReferencedAttribute	entitlementid
ReferencingAttribute	record2id
ReferencingEntityNavigationPropertyName	record2id_entitlement
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

entitlementchannel_connections1

One-To-Many Relationship: entitlementchannel entitlementchannel_connections1

Property	Value
ReferencedEntity	entitlementchannel
ReferencedAttribute	entitlementchannelid
ReferencingAttribute	record1id
ReferencingEntityNavigationPropertyName	record1id_entitlementchannel
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

entitlementchannel_connections2

One-To-Many Relationship: entitlementchannel entitlementchannel_connections2

Property	Value
ReferencedEntity	entitlementchannel
ReferencedAttribute	entitlementchannelid
ReferencingAttribute	record2id
ReferencingEntityNavigationPropertyName	record2id_entitlementchannel
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

entitlementtemplatechannel_connections1

One-To-Many Relationship: entitlementtemplatechannel entitlementtemplatechannel_connections1

Property	Value
ReferencedEntity	entitlementtemplatechannel
ReferencedAttribute	entitlementtemplatechannelid
ReferencingAttribute	record1id
ReferencingEntityNavigationPropertyName	record1id_entitlementtemplatechannel
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

entitlementtemplatechannel_connections2

One-To-Many Relationship: entitlementtemplatechannel entitlementtemplatechannel_connections2

Property	Value
ReferencedEntity	entitlementtemplatechannel
ReferencedAttribute	entitlementtemplatechannelid
ReferencingAttribute	record2id
ReferencingEntityNavigationPropertyName	record2id_entitlementtemplatechannel
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

equipment_connections1

One-To-Many Relationship: equipment equipment_connections1

Property	Value
ReferencedEntity	equipment
ReferencedAttribute	equipmentid
ReferencingAttribute	record1id
ReferencingEntityNavigationPropertyName	record1id_equipment
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

equipment_connections2

One-To-Many Relationship: equipment equipment_connections2

Property	Value
ReferencedEntity	equipment
ReferencedAttribute	equipmentid
ReferencingAttribute	record2id
ReferencingEntityNavigationPropertyName	record2id_equipment
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

incident_connections1

One-To-Many Relationship: incident incident_connections1

Property	Value
ReferencedEntity	incident
ReferencedAttribute	incidentid
ReferencingAttribute	record1id
ReferencingEntityNavigationPropertyName	record1id_incident
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

incident_connections2

One-To-Many Relationship: incident incident_connections2

Property	Value
ReferencedEntity	incident
ReferencedAttribute	incidentid
ReferencingAttribute	record2id
ReferencingEntityNavigationPropertyName	record2id_incident
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

invoice_connections1

One-To-Many Relationship: invoice invoice_connections1

Property	Value
ReferencedEntity	invoice
ReferencedAttribute	invoiceid
ReferencingAttribute	record1id
ReferencingEntityNavigationPropertyName	record1id_invoice
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

invoice_connections2

One-To-Many Relationship: invoice invoice_connections2

Property	Value
ReferencedEntity	invoice
ReferencedAttribute	invoiceid
ReferencingAttribute	record2id
ReferencingEntityNavigationPropertyName	record2id_invoice
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

lead_connections1

One-To-Many Relationship: lead lead_connections1

Property	Value
ReferencedEntity	lead
ReferencedAttribute	leadid
ReferencingAttribute	record1id
ReferencingEntityNavigationPropertyName	record1id_lead
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: Cascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

lead_connections2

One-To-Many Relationship: lead lead_connections2

Property	Value
ReferencedEntity	lead
ReferencedAttribute	leadid
ReferencingAttribute	record2id
ReferencingEntityNavigationPropertyName	record2id_lead
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: Cascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

list_connections1

One-To-Many Relationship: list list_connections1

Property	Value
ReferencedEntity	list
ReferencedAttribute	listid
ReferencingAttribute	record1id
ReferencingEntityNavigationPropertyName	record1id_list
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

list_connections2

One-To-Many Relationship: list list_connections2

Property	Value
ReferencedEntity	list
ReferencedAttribute	listid
ReferencingAttribute	record2id
ReferencingEntityNavigationPropertyName	record2id_list
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

msdyn_assignmentmap_connections1

One-To-Many Relationship: msdyn_assignmentmap msdyn_assignmentmap_connections1

Property	Value
ReferencedEntity	msdyn_assignmentmap
ReferencedAttribute	msdyn_assignmentmapid
ReferencingAttribute	record1id
ReferencingEntityNavigationPropertyName	record1id_msdyn_assignmentmap
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

msdyn_assignmentmap_connections2

One-To-Many Relationship: msdyn_assignmentmap msdyn_assignmentmap_connections2

Property	Value
ReferencedEntity	msdyn_assignmentmap
ReferencedAttribute	msdyn_assignmentmapid
ReferencingAttribute	record2id
ReferencingEntityNavigationPropertyName	record2id_msdyn_assignmentmap
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

msdyn_assignmentrule_connections1

One-To-Many Relationship: msdyn_assignmentrule msdyn_assignmentrule_connections1

Property	Value
ReferencedEntity	msdyn_assignmentrule
ReferencedAttribute	msdyn_assignmentruleid
ReferencingAttribute	record1id
ReferencingEntityNavigationPropertyName	record1id_msdyn_assignmentrule
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

msdyn_assignmentrule_connections2

One-To-Many Relationship: msdyn_assignmentrule msdyn_assignmentrule_connections2

Property	Value
ReferencedEntity	msdyn_assignmentrule
ReferencedAttribute	msdyn_assignmentruleid
ReferencingAttribute	record2id
ReferencingEntityNavigationPropertyName	record2id_msdyn_assignmentrule
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

msdyn_copilottranscript_connections1

One-To-Many Relationship: msdyn_copilottranscript msdyn_copilottranscript_connections1

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

msdyn_copilottranscript_connections2

One-To-Many Relationship: msdyn_copilottranscript msdyn_copilottranscript_connections2

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

msdyn_customerasset_connections1

One-To-Many Relationship: msdyn_customerasset msdyn_customerasset_connections1

Property	Value
ReferencedEntity	msdyn_customerasset
ReferencedAttribute	msdyn_customerassetid
ReferencingAttribute	record1id
ReferencingEntityNavigationPropertyName	record1id_msdyn_customerasset
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

msdyn_customerasset_connections2

One-To-Many Relationship: msdyn_customerasset msdyn_customerasset_connections2

Property	Value
ReferencedEntity	msdyn_customerasset
ReferencedAttribute	msdyn_customerassetid
ReferencingAttribute	record2id
ReferencingEntityNavigationPropertyName	record2id_msdyn_customerasset
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

msdyn_iotalert_connections1

One-To-Many Relationship: msdyn_iotalert msdyn_iotalert_connections1

Property	Value
ReferencedEntity	msdyn_iotalert
ReferencedAttribute	msdyn_iotalertid
ReferencingAttribute	record1id
ReferencingEntityNavigationPropertyName	record1id_msdyn_iotalert
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

msdyn_iotalert_connections2

One-To-Many Relationship: msdyn_iotalert msdyn_iotalert_connections2

Property	Value
ReferencedEntity	msdyn_iotalert
ReferencedAttribute	msdyn_iotalertid
ReferencingAttribute	record2id
ReferencingEntityNavigationPropertyName	record2id_msdyn_iotalert
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

msdyn_iotdevice_connections1

One-To-Many Relationship: msdyn_iotdevice msdyn_iotdevice_connections1

Property	Value
ReferencedEntity	msdyn_iotdevice
ReferencedAttribute	msdyn_iotdeviceid
ReferencingAttribute	record1id
ReferencingEntityNavigationPropertyName	record1id_msdyn_iotdevice
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

msdyn_iotdevice_connections2

One-To-Many Relationship: msdyn_iotdevice msdyn_iotdevice_connections2

Property	Value
ReferencedEntity	msdyn_iotdevice
ReferencedAttribute	msdyn_iotdeviceid
ReferencingAttribute	record2id
ReferencingEntityNavigationPropertyName	record2id_msdyn_iotdevice
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

msdyn_iotdevicecategory_connections1

One-To-Many Relationship: msdyn_iotdevicecategory msdyn_iotdevicecategory_connections1

Property	Value
ReferencedEntity	msdyn_iotdevicecategory
ReferencedAttribute	msdyn_iotdevicecategoryid
ReferencingAttribute	record1id
ReferencingEntityNavigationPropertyName	record1id_msdyn_iotdevicecategory
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

msdyn_iotdevicecategory_connections2

One-To-Many Relationship: msdyn_iotdevicecategory msdyn_iotdevicecategory_connections2

Property	Value
ReferencedEntity	msdyn_iotdevicecategory
ReferencedAttribute	msdyn_iotdevicecategoryid
ReferencingAttribute	record2id
ReferencingEntityNavigationPropertyName	record2id_msdyn_iotdevicecategory
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

msdyn_iotdevicecommand_connections1

One-To-Many Relationship: msdyn_iotdevicecommand msdyn_iotdevicecommand_connections1

Property	Value
ReferencedEntity	msdyn_iotdevicecommand
ReferencedAttribute	msdyn_iotdevicecommandid
ReferencingAttribute	record1id
ReferencingEntityNavigationPropertyName	record1id_msdyn_iotdevicecommand
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

msdyn_iotdevicecommand_connections2

One-To-Many Relationship: msdyn_iotdevicecommand msdyn_iotdevicecommand_connections2

Property	Value
ReferencedEntity	msdyn_iotdevicecommand
ReferencedAttribute	msdyn_iotdevicecommandid
ReferencingAttribute	record2id
ReferencingEntityNavigationPropertyName	record2id_msdyn_iotdevicecommand
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

msdyn_iotdeviceregistrationhistory_connections1

One-To-Many Relationship: msdyn_iotdeviceregistrationhistory msdyn_iotdeviceregistrationhistory_connections1

Property	Value
ReferencedEntity	msdyn_iotdeviceregistrationhistory
ReferencedAttribute	msdyn_iotdeviceregistrationhistoryid
ReferencingAttribute	record1id
ReferencingEntityNavigationPropertyName	record1id_msdyn_iotdeviceregistrationhistory
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

msdyn_iotdeviceregistrationhistory_connections2

One-To-Many Relationship: msdyn_iotdeviceregistrationhistory msdyn_iotdeviceregistrationhistory_connections2

Property	Value
ReferencedEntity	msdyn_iotdeviceregistrationhistory
ReferencedAttribute	msdyn_iotdeviceregistrationhistoryid
ReferencingAttribute	record2id
ReferencingEntityNavigationPropertyName	record2id_msdyn_iotdeviceregistrationhistory
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

msdyn_ocliveworkitem_connections1

One-To-Many Relationship: msdyn_ocliveworkitem msdyn_ocliveworkitem_connections1

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

msdyn_ocliveworkitem_connections2

One-To-Many Relationship: msdyn_ocliveworkitem msdyn_ocliveworkitem_connections2

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

msdyn_ocsession_connections1

One-To-Many Relationship: msdyn_ocsession msdyn_ocsession_connections1

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

msdyn_ocsession_connections2

One-To-Many Relationship: msdyn_ocsession msdyn_ocsession_connections2

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

msdyn_postalbum_connections1

One-To-Many Relationship: msdyn_postalbum msdyn_postalbum_connections1

Property	Value
ReferencedEntity	msdyn_postalbum
ReferencedAttribute	msdyn_postalbumid
ReferencingAttribute	record1id
ReferencingEntityNavigationPropertyName	record1id_msdyn_postalbum
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

msdyn_postalbum_connections2

One-To-Many Relationship: msdyn_postalbum msdyn_postalbum_connections2

Property	Value
ReferencedEntity	msdyn_postalbum
ReferencedAttribute	msdyn_postalbumid
ReferencingAttribute	record2id
ReferencingEntityNavigationPropertyName	record2id_msdyn_postalbum
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

msdyn_salessuggestion_connections1

One-To-Many Relationship: msdyn_salessuggestion msdyn_salessuggestion_connections1

Property	Value
ReferencedEntity	msdyn_salessuggestion
ReferencedAttribute	msdyn_salessuggestionid
ReferencingAttribute	record1id
ReferencingEntityNavigationPropertyName	record1id_msdyn_salessuggestion
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

msdyn_salessuggestion_connections2

One-To-Many Relationship: msdyn_salessuggestion msdyn_salessuggestion_connections2

Property	Value
ReferencedEntity	msdyn_salessuggestion
ReferencedAttribute	msdyn_salessuggestionid
ReferencingAttribute	record2id
ReferencingEntityNavigationPropertyName	record2id_msdyn_salessuggestion
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

msdyn_sequence_connections1

One-To-Many Relationship: msdyn_sequence msdyn_sequence_connections1

Property	Value
ReferencedEntity	msdyn_sequence
ReferencedAttribute	msdyn_sequenceid
ReferencingAttribute	record1id
ReferencingEntityNavigationPropertyName	record1id_msdyn_sequence
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

msdyn_sequence_connections2

One-To-Many Relationship: msdyn_sequence msdyn_sequence_connections2

Property	Value
ReferencedEntity	msdyn_sequence
ReferencedAttribute	msdyn_sequenceid
ReferencingAttribute	record2id
ReferencingEntityNavigationPropertyName	record2id_msdyn_sequence
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

msdyn_sequencetarget_connections1

One-To-Many Relationship: msdyn_sequencetarget msdyn_sequencetarget_connections1

Property	Value
ReferencedEntity	msdyn_sequencetarget
ReferencedAttribute	msdyn_sequencetargetid
ReferencingAttribute	record1id
ReferencingEntityNavigationPropertyName	record1id_msdyn_sequencetarget
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

msdyn_sequencetarget_connections2

One-To-Many Relationship: msdyn_sequencetarget msdyn_sequencetarget_connections2

Property	Value
ReferencedEntity	msdyn_sequencetarget
ReferencedAttribute	msdyn_sequencetargetid
ReferencingAttribute	record2id
ReferencingEntityNavigationPropertyName	record2id_msdyn_sequencetarget
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

msdyn_suggestionprincipalobjectaccess_connections1

One-To-Many Relationship: msdyn_suggestionprincipalobjectaccess msdyn_suggestionprincipalobjectaccess_connections1

Property	Value
ReferencedEntity	msdyn_suggestionprincipalobjectaccess
ReferencedAttribute	msdyn_suggestionprincipalobjectaccessid
ReferencingAttribute	record1id
ReferencingEntityNavigationPropertyName	record1id_msdyn_suggestionprincipalobjectaccess
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

msdyn_suggestionprincipalobjectaccess_connections2

One-To-Many Relationship: msdyn_suggestionprincipalobjectaccess msdyn_suggestionprincipalobjectaccess_connections2

Property	Value
ReferencedEntity	msdyn_suggestionprincipalobjectaccess
ReferencedAttribute	msdyn_suggestionprincipalobjectaccessid
ReferencingAttribute	record2id
ReferencingEntityNavigationPropertyName	record2id_msdyn_suggestionprincipalobjectaccess
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

msfp_alert_connections1

One-To-Many Relationship: msfp_alert msfp_alert_connections1

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

msfp_alert_connections2

One-To-Many Relationship: msfp_alert msfp_alert_connections2

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

msfp_surveyinvite_connections1

One-To-Many Relationship: msfp_surveyinvite msfp_surveyinvite_connections1

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

msfp_surveyinvite_connections2

One-To-Many Relationship: msfp_surveyinvite msfp_surveyinvite_connections2

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

msfp_surveyresponse_connections1

One-To-Many Relationship: msfp_surveyresponse msfp_surveyresponse_connections1

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

msfp_surveyresponse_connections2

One-To-Many Relationship: msfp_surveyresponse msfp_surveyresponse_connections2

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

opportunity_connections1

One-To-Many Relationship: opportunity opportunity_connections1

Property	Value
ReferencedEntity	opportunity
ReferencedAttribute	opportunityid
ReferencingAttribute	record1id
ReferencingEntityNavigationPropertyName	record1id_opportunity
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

opportunity_connections2

One-To-Many Relationship: opportunity opportunity_connections2

Property	Value
ReferencedEntity	opportunity
ReferencedAttribute	opportunityid
ReferencingAttribute	record2id
ReferencingEntityNavigationPropertyName	record2id_opportunity
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

pricelevel_connections1

One-To-Many Relationship: pricelevel pricelevel_connections1

Property	Value
ReferencedEntity	pricelevel
ReferencedAttribute	pricelevelid
ReferencingAttribute	record1id
ReferencingEntityNavigationPropertyName	record1id_pricelevel
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

pricelevel_connections2

One-To-Many Relationship: pricelevel pricelevel_connections2

Property	Value
ReferencedEntity	pricelevel
ReferencedAttribute	pricelevelid
ReferencingAttribute	record2id
ReferencingEntityNavigationPropertyName	record2id_pricelevel
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

product_connections1

One-To-Many Relationship: product product_connections1

Property	Value
ReferencedEntity	product
ReferencedAttribute	productid
ReferencingAttribute	record1id
ReferencingEntityNavigationPropertyName	record1id_product
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

product_connections2

One-To-Many Relationship: product product_connections2

Property	Value
ReferencedEntity	product
ReferencedAttribute	productid
ReferencingAttribute	record2id
ReferencingEntityNavigationPropertyName	record2id_product
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

quote_connections1

One-To-Many Relationship: quote quote_connections1

Property	Value
ReferencedEntity	quote
ReferencedAttribute	quoteid
ReferencingAttribute	record1id
ReferencingEntityNavigationPropertyName	record1id_quote
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

quote_connections2

One-To-Many Relationship: quote quote_connections2

Property	Value
ReferencedEntity	quote
ReferencedAttribute	quoteid
ReferencingAttribute	record2id
ReferencingEntityNavigationPropertyName	record2id_quote
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

resourcegroup_connections1

One-To-Many Relationship: resourcegroup resourcegroup_connections1

Property	Value
ReferencedEntity	resourcegroup
ReferencedAttribute	resourcegroupid
ReferencingAttribute	record1id
ReferencingEntityNavigationPropertyName	record1id_resourcegroup
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

resourcegroup_connections2

One-To-Many Relationship: resourcegroup resourcegroup_connections2

Property	Value
ReferencedEntity	resourcegroup
ReferencedAttribute	resourcegroupid
ReferencingAttribute	record2id
ReferencingEntityNavigationPropertyName	record2id_resourcegroup
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

salesorder_connections1

One-To-Many Relationship: salesorder salesorder_connections1

Property	Value
ReferencedEntity	salesorder
ReferencedAttribute	salesorderid
ReferencingAttribute	record1id
ReferencingEntityNavigationPropertyName	record1id_salesorder
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

salesorder_connections2

One-To-Many Relationship: salesorder salesorder_connections2

Property	Value
ReferencedEntity	salesorder
ReferencedAttribute	salesorderid
ReferencingAttribute	record2id
ReferencingEntityNavigationPropertyName	record2id_salesorder
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

serviceappointment_connections1

One-To-Many Relationship: serviceappointment serviceappointment_connections1

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

serviceappointment_connections2

One-To-Many Relationship: serviceappointment serviceappointment_connections2

Property	Value
ReferencedEntity	serviceappointment
ReferencedAttribute	activityid
ReferencingAttribute	record2id
ReferencingEntityNavigationPropertyName	record2id_serviceappointment
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