編輯

共用方式為


Connection table/entity reference

Relationship between two entities.

Messages

The following table lists the messages for the Connection table. Messages represent operations that can be performed on the table. They may also be events.

Name
Is Event?
Web API Operation SDK for .NET
Assign
Event: True
PATCH /connections(connectionid)
Update the ownerid property.
AssignRequest
Create
Event: True
POST /connections
See Create
Create records
Delete
Event: True
DELETE /connections(connectionid)
See Delete
Delete records
GrantAccess
Event: True
GrantAccess GrantAccessRequest
ModifyAccess
Event: True
ModifyAccess ModifyAccessRequest
Retrieve
Event: True
GET /connections(connectionid)
See Retrieve
Retrieve records
RetrieveMultiple
Event: True
GET /connections
See Query data
Query data
RetrievePrincipalAccess
Event: True
RetrievePrincipalAccess RetrievePrincipalAccessRequest
RetrieveSharedPrincipalsAndAccess
Event: True
RetrieveSharedPrincipalsAndAccess RetrieveSharedPrincipalsAndAccessRequest
RevokeAccess
Event: True
RevokeAccess RevokeAccessRequest
SetState
Event: True
PATCH /connections(connectionid)
Update the statecode and statuscode properties.
SetStateRequest
Update
Event: True
PATCH /connections(connectionid)
See Update
Update records
Upsert
Event: False
PATCH /connections(connectionid)
See Upsert a table row
UpsertRequest

Properties

The following table lists selected properties for the Connection table.

Property Value
DisplayName Connection
DisplayCollectionName Connections
SchemaName Connection
CollectionSchemaName Connections
EntitySetName connections
LogicalName connection
LogicalCollectionName connections
PrimaryIdAttribute connectionid
PrimaryNameAttribute name
TableType Standard
OwnershipType UserOwned

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

ConnectionId

Property Value
Description Unique identifier of the connection.
DisplayName Connection
IsValidForForm False
IsValidForRead True
LogicalName connectionid
RequiredLevel SystemRequired
Type Uniqueidentifier

Description

Property Value
Description Type additional information to describe the connection, such as the length or quality of the relationship.
DisplayName Description
IsValidForForm True
IsValidForRead True
LogicalName description
RequiredLevel None
Type Memo
Format TextArea
FormatName TextArea
ImeMode Auto
IsLocalizable False
MaxLength 2000

EffectiveEnd

Property Value
Description Enter the end date of the connection.
DisplayName Ending
IsValidForForm True
IsValidForRead True
LogicalName effectiveend
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateOnly
ImeMode Inactive
SourceTypeMask 0

EffectiveStart

Property Value
Description Enter the start date of the connection.
DisplayName Starting
IsValidForForm True
IsValidForRead True
LogicalName effectivestart
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateOnly
ImeMode Inactive
SourceTypeMask 0

EntityImage

Property Value
Description The default image for the entity.
DisplayName Entity Image
IsValidForForm False
IsValidForRead True
LogicalName entityimage
RequiredLevel None
Type Image
CanStoreFullImage False
IsPrimaryImage True
MaxHeight 144
MaxSizeInKB 10240
MaxWidth 144

ImportSequenceNumber

Property Value
Description Unique identifier of the data import or data migration that created this record.
DisplayName Import Sequence Number
IsValidForForm False
IsValidForRead True
LogicalName importsequencenumber
RequiredLevel None
Type Integer
MaxValue 2147483647
MinValue -2147483648

OverriddenCreatedOn

Property Value
Description Date and time that the record was migrated.
DisplayName Record Created On
IsValidForForm False
IsValidForRead True
LogicalName overriddencreatedon
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateOnly
ImeMode Inactive
SourceTypeMask 0

OwnerId

Property Value
Description Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user.
DisplayName Owner
IsValidForForm True
IsValidForRead True
LogicalName ownerid
RequiredLevel SystemRequired
Type Owner
Targets systemuser, team

OwnerIdType

Property Value
Description Type of the owner of the connection, such as user, team, or business unit.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName owneridtype
RequiredLevel SystemRequired
Type EntityName

Record1Id

Property Value
Description Choose the primary account, contact, or other record involved in the connection.
DisplayName Connected From
IsValidForForm True
IsValidForRead True
LogicalName record1id
RequiredLevel None
Type Lookup
Targets account, activitypointer, adx_invitation, adx_inviteredemption, appointment, channelaccessprofilerule, contact, email, fax, goal, knowledgearticle, knowledgebaserecord, letter, mspp_publishingstatetransitionrule, mspp_shortcut, mspp_website, phonecall, position, processsession, recurringappointmentmaster, socialactivity, socialprofile, systemuser, task, team, territory

Record1IdObjectTypeCode

Property Value
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName record1idobjecttypecode
RequiredLevel None
Type EntityName

Record1RoleId

Property Value
Description Choose the primary party's role or relationship with the second party.
DisplayName Role (From)
IsValidForForm True
IsValidForRead True
LogicalName record1roleid
RequiredLevel None
Type Lookup
Targets connectionrole

Record2Id

Property Value
Description Select the secondary account, contact, or other record involved in the connection.
DisplayName Connected To
IsValidForForm True
IsValidForRead True
LogicalName record2id
RequiredLevel None
Type Lookup
Targets account, activitypointer, adx_invitation, adx_inviteredemption, appointment, channelaccessprofilerule, contact, email, fax, goal, knowledgearticle, knowledgebaserecord, letter, mspp_publishingstatetransitionrule, mspp_shortcut, mspp_website, phonecall, position, processsession, recurringappointmentmaster, socialactivity, socialprofile, systemuser, task, team, territory

Record2IdObjectTypeCode

Property Value
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName record2idobjecttypecode
RequiredLevel None
Type EntityName

Record2RoleId

Property Value
Description Choose the secondary party's role or relationship with the primary party.
DisplayName Role (To)
IsValidForForm True
IsValidForRead True
LogicalName record2roleid
RequiredLevel None
Type Lookup
Targets connectionrole

StateCode

Property Value
Description Shows whether the connection is active or inactive. Inactive connections are read-only and can't be edited unless they are reactivated.
DisplayName Status
IsValidForForm True
IsValidForRead True
LogicalName statecode
RequiredLevel SystemRequired
Type State
DefaultFormValue 0
GlobalChoiceName connection_statecode

StateCode Choices/Options

Value Details
0 Label: Active
DefaultStatus: 1
InvariantName: Active
1 Label: Inactive
DefaultStatus: 2
InvariantName: Inactive

StatusCode

Property Value
Description Reason for the status of the connection.
DisplayName Status Reason
IsValidForForm False
IsValidForRead True
LogicalName statuscode
RequiredLevel None
Type Status
DefaultFormValue -1
GlobalChoiceName connection_statuscode

StatusCode Choices/Options

Value Details
1 Label: Active
State:0
TransitionData: None
2 Label: Inactive
State:1
TransitionData: None

TransactionCurrencyId

Property Value
Description Choose the local currency for the record to make sure budgets are reported in the correct currency.
DisplayName Currency
IsValidForForm True
IsValidForRead True
LogicalName transactioncurrencyid
RequiredLevel None
Type Lookup
Targets transactioncurrency

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.

CreatedBy

Property Value
Description Shows who created the record.
DisplayName Created By
IsValidForForm True
IsValidForRead True
LogicalName createdby
RequiredLevel None
Type Lookup
Targets systemuser

CreatedOn

Property Value
Description Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options.
DisplayName Created On
IsValidForForm True
IsValidForRead True
LogicalName createdon
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

CreatedOnBehalfBy

Property Value
Description Shows who created the record on behalf of another user.
DisplayName Created By (Delegate)
IsValidForForm True
IsValidForRead True
LogicalName createdonbehalfby
RequiredLevel None
Type Lookup
Targets systemuser

EntityImage_Timestamp

Property Value
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName entityimage_timestamp
RequiredLevel None
Type BigInt
MaxValue 9223372036854775807
MinValue -9223372036854775808

EntityImage_URL

Property Value
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName entityimage_url
RequiredLevel None
Type String
Format Url
FormatName Url
ImeMode Auto
IsLocalizable False
MaxLength 200

EntityImageId

Property Value
Description For internal use only.
DisplayName Entity Image Id
IsValidForForm False
IsValidForRead True
LogicalName entityimageid
RequiredLevel None
Type Uniqueidentifier

ExchangeRate

Property Value
Description Shows the conversion rate of the record's currency. The exchange rate is used to convert all money fields in the record from the local currency to the system's default currency.
DisplayName Exchange Rate
IsValidForForm True
IsValidForRead True
LogicalName exchangerate
RequiredLevel None
Type Decimal
ImeMode Disabled
MaxValue 100000000000
MinValue 1E-12
Precision 12
SourceTypeMask 0

IsMaster

Property Value
Description Indicates that this is the master record.
DisplayName Is Master
IsValidForForm False
IsValidForRead True
LogicalName ismaster
RequiredLevel SystemRequired
Type Boolean
GlobalChoiceName connection_ismaster
DefaultValue False
True Label Yes
False Label No

ModifiedBy

Property Value
Description Shows who last updated the record.
DisplayName Modified By
IsValidForForm True
IsValidForRead True
LogicalName modifiedby
RequiredLevel None
Type Lookup
Targets systemuser

ModifiedOn

Property Value
Description Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options.
DisplayName Modified On
IsValidForForm True
IsValidForRead True
LogicalName modifiedon
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

ModifiedOnBehalfBy

Property Value
Description Shows who last updated the record on behalf of another user.
DisplayName Modified By (Delegate)
IsValidForForm True
IsValidForRead True
LogicalName modifiedonbehalfby
RequiredLevel None
Type Lookup
Targets systemuser

Name

Property Value
Description Name of the connection.
DisplayName Connection Name
IsValidForForm False
IsValidForRead True
LogicalName name
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 500

OwnerIdName

Property Value
Description Name of the owner of the connection.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName owneridname
RequiredLevel SystemRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 100

OwnerIdYomiName

Property Value
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName owneridyominame
RequiredLevel SystemRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 100

OwningBusinessUnit

Property Value
Description Shows the business unit that the record owner belongs to.
DisplayName Owning Business Unit
IsValidForForm True
IsValidForRead True
LogicalName owningbusinessunit
RequiredLevel None
Type Lookup
Targets businessunit

OwningTeam

Property Value
Description Unique identifier of the team who owns the connection.
DisplayName Owning Team
IsValidForForm False
IsValidForRead True
LogicalName owningteam
RequiredLevel None
Type Lookup
Targets team

OwningUser

Property Value
Description Unique identifier of the user who owns the connection.
DisplayName Owning User
IsValidForForm False
IsValidForRead True
LogicalName owninguser
RequiredLevel None
Type Lookup
Targets systemuser

Record1ObjectTypeCode

Property Value
Description Shows the record type of the source record.
DisplayName Type (From)
IsValidForForm True
IsValidForRead True
LogicalName record1objecttypecode
RequiredLevel None
Type Picklist
DefaultFormValue -1
GlobalChoiceName connection_record1objecttypecode

Record1ObjectTypeCode Choices/Options

Value Label
1 Account
2 Contact
8 User
9 Team
50 Position
99 Social Profile
2013 Territory
4200 Activity
4201 Appointment
4202 Email
4204 Fax
4207 Letter
4210 Phone Call
4212 Task
4216 Social Activity
4251 Recurring Appointment
4710 Process Session
9400 Channel Access Profile Rule
9600 Goal
9930 Knowledge Base Record
9953 Knowledge Article
10330 Invitation
10331 Invite Redemption
10350 Publishing State Transition Rule
10352 Shortcut
10364 Website

Record2ObjectTypeCode

Property Value
Description Shows the record type of the target record.
DisplayName Type (To)
IsValidForForm True
IsValidForRead True
LogicalName record2objecttypecode
RequiredLevel None
Type Picklist
DefaultFormValue -1
GlobalChoiceName connection_record2objecttypecode

Record2ObjectTypeCode Choices/Options

Value Label
1 Account
2 Contact
8 User
9 Team
50 Position
99 Social Profile
2013 Territory
4200 Activity
4201 Appointment
4202 Email
4204 Fax
4207 Letter
4210 Phone Call
4212 Task
4216 Social Activity
4251 Recurring Appointment
4710 Process Session
9400 Channel Access Profile Rule
9600 Goal
9930 Knowledge Base Record
9953 Knowledge Article
10330 Invitation
10331 Invite Redemption
10350 Publishing State Transition Rule
10352 Shortcut
10364 Website

RelatedConnectionId

Property Value
Description Unique identifier for the reciprocal connection record.
DisplayName Reciprocal Connection
IsValidForForm False
IsValidForRead True
LogicalName relatedconnectionid
RequiredLevel ApplicationRequired
Type Lookup
Targets connection

VersionNumber

Property Value
Description Version number of the connection.
DisplayName Version Number
IsValidForForm False
IsValidForRead True
LogicalName versionnumber
RequiredLevel None
Type BigInt
MaxValue 9223372036854775807
MinValue -9223372036854775808

Many-to-One relationships

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

account_connections1

One-To-Many Relationship: account account_connections1

Property Value
ReferencedEntity account
ReferencedAttribute accountid
ReferencingAttribute record1id
ReferencingEntityNavigationPropertyName record1id_account
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: Cascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

account_connections2

One-To-Many Relationship: account account_connections2

Property Value
ReferencedEntity account
ReferencedAttribute accountid
ReferencingAttribute record2id
ReferencingEntityNavigationPropertyName record2id_account
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: Cascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

activitypointer_connections1

One-To-Many Relationship: activitypointer activitypointer_connections1

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

activitypointer_connections2

One-To-Many Relationship: activitypointer activitypointer_connections2

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

adx_invitation_connections1

One-To-Many Relationship: adx_invitation adx_invitation_connections1

Property Value
ReferencedEntity adx_invitation
ReferencedAttribute adx_invitationid
ReferencingAttribute record1id
ReferencingEntityNavigationPropertyName record1id_adx_invitation
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

adx_invitation_connections2

One-To-Many Relationship: adx_invitation adx_invitation_connections2

Property Value
ReferencedEntity adx_invitation
ReferencedAttribute adx_invitationid
ReferencingAttribute record2id
ReferencingEntityNavigationPropertyName record2id_adx_invitation
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

adx_inviteredemption_connections1

One-To-Many Relationship: adx_inviteredemption adx_inviteredemption_connections1

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

adx_inviteredemption_connections2

One-To-Many Relationship: adx_inviteredemption adx_inviteredemption_connections2

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

appointment_connections1

One-To-Many Relationship: appointment appointment_connections1

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

appointment_connections2

One-To-Many Relationship: appointment appointment_connections2

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

business_unit_connections

One-To-Many Relationship: businessunit business_unit_connections

Property Value
ReferencedEntity businessunit
ReferencedAttribute businessunitid
ReferencingAttribute owningbusinessunit
ReferencingEntityNavigationPropertyName owningbusinessunit
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

One-To-Many Relationship: connection connection_related_connection

Property Value
ReferencedEntity connection
ReferencedAttribute connectionid
ReferencingAttribute relatedconnectionid
ReferencingEntityNavigationPropertyName relatedconnectionid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

connection_role_connections1

One-To-Many Relationship: connectionrole connection_role_connections1

Property Value
ReferencedEntity connectionrole
ReferencedAttribute connectionroleid
ReferencingAttribute record1roleid
ReferencingEntityNavigationPropertyName record1roleid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

connection_role_connections2

One-To-Many Relationship: connectionrole connection_role_connections2

Property Value
ReferencedEntity connectionrole
ReferencedAttribute connectionroleid
ReferencingAttribute record2roleid
ReferencingEntityNavigationPropertyName record2roleid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

contact_connections1

One-To-Many Relationship: contact contact_connections1

Property Value
ReferencedEntity contact
ReferencedAttribute contactid
ReferencingAttribute record1id
ReferencingEntityNavigationPropertyName record1id_contact
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: Cascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

contact_connections2

One-To-Many Relationship: contact contact_connections2

Property Value
ReferencedEntity contact
ReferencedAttribute contactid
ReferencingAttribute record2id
ReferencingEntityNavigationPropertyName record2id_contact
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: Cascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

createdby_connection

One-To-Many Relationship: systemuser createdby_connection

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute createdby
ReferencingEntityNavigationPropertyName createdby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

email_connections1

One-To-Many Relationship: email email_connections1

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

email_connections2

One-To-Many Relationship: email email_connections2

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

fax_connections1

One-To-Many Relationship: fax fax_connections1

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

fax_connections2

One-To-Many Relationship: fax fax_connections2

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

goal_connections1

One-To-Many Relationship: goal goal_connections1

Property Value
ReferencedEntity goal
ReferencedAttribute goalid
ReferencingAttribute record1id
ReferencingEntityNavigationPropertyName record1id_goal
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

goal_connections2

One-To-Many Relationship: goal goal_connections2

Property Value
ReferencedEntity goal
ReferencedAttribute goalid
ReferencingAttribute record2id
ReferencingEntityNavigationPropertyName record2id_goal
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

knowledgearticle_connections1

One-To-Many Relationship: knowledgearticle knowledgearticle_connections1

Property Value
ReferencedEntity knowledgearticle
ReferencedAttribute knowledgearticleid
ReferencingAttribute record1id
ReferencingEntityNavigationPropertyName record1id_knowledgearticle
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

knowledgearticle_connections2

One-To-Many Relationship: knowledgearticle knowledgearticle_connections2

Property Value
ReferencedEntity knowledgearticle
ReferencedAttribute knowledgearticleid
ReferencingAttribute record2id
ReferencingEntityNavigationPropertyName record2id_knowledgearticle
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

KnowledgeBaseRecord_connections1

One-To-Many Relationship: knowledgebaserecord KnowledgeBaseRecord_connections1

Property Value
ReferencedEntity knowledgebaserecord
ReferencedAttribute knowledgebaserecordid
ReferencingAttribute record1id
ReferencingEntityNavigationPropertyName record1id_knowledgebaserecord
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

KnowledgeBaseRecord_connections2

One-To-Many Relationship: knowledgebaserecord KnowledgeBaseRecord_connections2

Property Value
ReferencedEntity knowledgebaserecord
ReferencedAttribute knowledgebaserecordid
ReferencingAttribute record2id
ReferencingEntityNavigationPropertyName record2id_knowledgebaserecord
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

letter_connections1

One-To-Many Relationship: letter letter_connections1

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

letter_connections2

One-To-Many Relationship: letter letter_connections2

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

lk_connectionbase_createdonbehalfby

One-To-Many Relationship: systemuser lk_connectionbase_createdonbehalfby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute createdonbehalfby
ReferencingEntityNavigationPropertyName createdonbehalfby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_connectionbase_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_connectionbase_modifiedonbehalfby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute modifiedonbehalfby
ReferencingEntityNavigationPropertyName modifiedonbehalfby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

modifiedby_connection

One-To-Many Relationship: systemuser modifiedby_connection

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute modifiedby
ReferencingEntityNavigationPropertyName modifiedby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

mspp_publishingstatetransitionrule_connections1

One-To-Many Relationship: mspp_publishingstatetransitionrule mspp_publishingstatetransitionrule_connections1

Property Value
ReferencedEntity mspp_publishingstatetransitionrule
ReferencedAttribute mspp_publishingstatetransitionruleid
ReferencingAttribute record1id
ReferencingEntityNavigationPropertyName record1id_mspp_publishingstatetransitionrule
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

mspp_publishingstatetransitionrule_connections2

One-To-Many Relationship: mspp_publishingstatetransitionrule mspp_publishingstatetransitionrule_connections2

Property Value
ReferencedEntity mspp_publishingstatetransitionrule
ReferencedAttribute mspp_publishingstatetransitionruleid
ReferencingAttribute record2id
ReferencingEntityNavigationPropertyName record2id_mspp_publishingstatetransitionrule
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

mspp_shortcut_connections1

One-To-Many Relationship: mspp_shortcut mspp_shortcut_connections1

Property Value
ReferencedEntity mspp_shortcut
ReferencedAttribute mspp_shortcutid
ReferencingAttribute record1id
ReferencingEntityNavigationPropertyName record1id_mspp_shortcut
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

mspp_shortcut_connections2

One-To-Many Relationship: mspp_shortcut mspp_shortcut_connections2

Property Value
ReferencedEntity mspp_shortcut
ReferencedAttribute mspp_shortcutid
ReferencingAttribute record2id
ReferencingEntityNavigationPropertyName record2id_mspp_shortcut
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

mspp_website_connections1

One-To-Many Relationship: mspp_website mspp_website_connections1

Property Value
ReferencedEntity mspp_website
ReferencedAttribute mspp_websiteid
ReferencingAttribute record1id
ReferencingEntityNavigationPropertyName record1id_mspp_website
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

mspp_website_connections2

One-To-Many Relationship: mspp_website mspp_website_connections2

Property Value
ReferencedEntity mspp_website
ReferencedAttribute mspp_websiteid
ReferencingAttribute record2id
ReferencingEntityNavigationPropertyName record2id_mspp_website
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

owner_connections

One-To-Many Relationship: owner owner_connections

Property Value
ReferencedEntity owner
ReferencedAttribute ownerid
ReferencingAttribute ownerid
ReferencingEntityNavigationPropertyName ownerid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

phonecall_connections1

One-To-Many Relationship: phonecall phonecall_connections1

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

phonecall_connections2

One-To-Many Relationship: phonecall phonecall_connections2

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

position_connection1

One-To-Many Relationship: position position_connection1

Property Value
ReferencedEntity position
ReferencedAttribute positionid
ReferencingAttribute record1id
ReferencingEntityNavigationPropertyName record1id_position
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

position_connection2

One-To-Many Relationship: position position_connection2

Property Value
ReferencedEntity position
ReferencedAttribute positionid
ReferencingAttribute record2id
ReferencingEntityNavigationPropertyName record2id_position
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

processsession_connections1

One-To-Many Relationship: processsession processsession_connections1

Property Value
ReferencedEntity processsession
ReferencedAttribute processsessionid
ReferencingAttribute record1id
ReferencingEntityNavigationPropertyName record1id_processsession
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

processsession_connections2

One-To-Many Relationship: processsession processsession_connections2

Property Value
ReferencedEntity processsession
ReferencedAttribute processsessionid
ReferencingAttribute record2id
ReferencingEntityNavigationPropertyName record2id_processsession
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

recurringappointmentmaster_connections1

One-To-Many Relationship: recurringappointmentmaster recurringappointmentmaster_connections1

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

recurringappointmentmaster_connections2

One-To-Many Relationship: recurringappointmentmaster recurringappointmentmaster_connections2

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

socialactivity_connections1

One-To-Many Relationship: socialactivity socialactivity_connections1

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

socialactivity_connections2

One-To-Many Relationship: socialactivity socialactivity_connections2

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

socialprofile_connections1

One-To-Many Relationship: socialprofile socialprofile_connections1

Property Value
ReferencedEntity socialprofile
ReferencedAttribute socialprofileid
ReferencingAttribute record1id
ReferencingEntityNavigationPropertyName record1id_socialprofile
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: Cascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

socialprofile_connections2

One-To-Many Relationship: socialprofile socialprofile_connections2

Property Value
ReferencedEntity socialprofile
ReferencedAttribute socialprofileid
ReferencingAttribute record2id
ReferencingEntityNavigationPropertyName record2id_socialprofile
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: Cascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

systemuser_connections1

One-To-Many Relationship: systemuser systemuser_connections1

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute record1id
ReferencingEntityNavigationPropertyName record1id_systemuser
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

systemuser_connections2

One-To-Many Relationship: systemuser systemuser_connections2

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute record2id
ReferencingEntityNavigationPropertyName record2id_systemuser
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

task_connections1

One-To-Many Relationship: task task_connections1

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

task_connections2

One-To-Many Relationship: task task_connections2

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

team_connections1

One-To-Many Relationship: team team_connections1

Property Value
ReferencedEntity team
ReferencedAttribute teamid
ReferencingAttribute record1id
ReferencingEntityNavigationPropertyName record1id_team
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

team_connections2

One-To-Many Relationship: team team_connections2

Property Value
ReferencedEntity team
ReferencedAttribute teamid
ReferencingAttribute record2id
ReferencingEntityNavigationPropertyName record2id_team
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

territory_connections1

One-To-Many Relationship: territory territory_connections1

Property Value
ReferencedEntity territory
ReferencedAttribute territoryid
ReferencingAttribute record1id
ReferencingEntityNavigationPropertyName record1id_territory
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

territory_connections2

One-To-Many Relationship: territory territory_connections2

Property Value
ReferencedEntity territory
ReferencedAttribute territoryid
ReferencingAttribute record2id
ReferencingEntityNavigationPropertyName record2id_territory
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

TransactionCurrency_Connection

One-To-Many Relationship: transactioncurrency TransactionCurrency_Connection

Property Value
ReferencedEntity transactioncurrency
ReferencedAttribute transactioncurrencyid
ReferencingAttribute transactioncurrencyid
ReferencingEntityNavigationPropertyName transactioncurrencyid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Restrict
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

One-to-Many relationships

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

Connection_AsyncOperations

Many-To-One Relationship: asyncoperation Connection_AsyncOperations

Property Value
ReferencingEntity asyncoperation
ReferencingAttribute regardingobjectid
ReferencedEntityNavigationPropertyName Connection_AsyncOperations
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

connection_principalobjectattributeaccess

Many-To-One Relationship: principalobjectattributeaccess connection_principalobjectattributeaccess

Property Value
ReferencingEntity principalobjectattributeaccess
ReferencingAttribute objectid
ReferencedEntityNavigationPropertyName connection_principalobjectattributeaccess
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

Connection_ProcessSessions

Many-To-One Relationship: processsession Connection_ProcessSessions

Property Value
ReferencingEntity processsession
ReferencingAttribute regardingobjectid
ReferencedEntityNavigationPropertyName Connection_ProcessSessions
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: UseCollectionName
Group: Details
Label:
MenuId: null
Order: 110
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

Many-To-One Relationship: connection connection_related_connection

Property Value
ReferencingEntity connection
ReferencingAttribute relatedconnectionid
ReferencedEntityNavigationPropertyName connection_related_connection
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

Connection_SyncErrors

Many-To-One Relationship: syncerror Connection_SyncErrors

Property Value
ReferencingEntity syncerror
ReferencingAttribute regardingobjectid
ReferencedEntityNavigationPropertyName Connection_SyncErrors
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

See also

Dataverse table/entity reference
Dataverse Web API Reference
connection