Connection table/entity reference
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
Relationship between two entities.
Messages
Message | Web API Operation | SDK class or method |
---|---|---|
Assign | PATCH /connections(connectionid) Update ownerid property. |
AssignRequest |
Create | POST /connections See Create |
CreateRequest or Create |
Delete | DELETE /connections(connectionid) See Delete |
DeleteRequest or Delete |
GrantAccess | GrantAccess | GrantAccessRequest |
ModifyAccess | ModifyAccess | ModifyAccessRequest |
Retrieve | GET /connections(connectionid) See Retrieve |
RetrieveRequest or Retrieve |
RetrieveMultiple | GET /connections See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
RetrievePrincipalAccess | RetrievePrincipalAccess | RetrievePrincipalAccessRequest |
RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccessRequest |
RevokeAccess | RevokeAccess | RevokeAccessRequest |
SetState | PATCH /connections(connectionid) Update statecode and statuscode properties. |
SetStateRequest |
Update | PATCH /connections(connectionid) See Update |
UpdateRequest or Update |
Properties
Property | Value |
---|---|
CollectionSchemaName | Connections |
DisplayCollectionName | Connections |
DisplayName | Connection |
EntitySetName | connections |
IsBPFEntity | False |
LogicalCollectionName | connections |
LogicalName | connection |
OwnershipType | UserOwned |
PrimaryIdAttribute | connectionid |
PrimaryNameAttribute | name |
SchemaName | Connection |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- ConnectionId
- Description
- EffectiveEnd
- EffectiveStart
- EntityImage
- ImportSequenceNumber
- OverriddenCreatedOn
- OwnerId
- OwnerIdType
- Record1Id
- Record1IdObjectTypeCode
- Record1RoleId
- Record2Id
- Record2IdObjectTypeCode
- Record2RoleId
- StateCode
- StatusCode
- TransactionCurrencyId
ConnectionId
Property | Value |
---|---|
Description | Unique identifier of the connection. |
DisplayName | Connection |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
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 |
Format | TextArea |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | description |
MaxLength | 2000 |
RequiredLevel | None |
Type | Memo |
EffectiveEnd
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Enter the end date of the connection. |
DisplayName | Ending |
Format | DateOnly |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | effectiveend |
RequiredLevel | None |
Type | DateTime |
EffectiveStart
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Enter the start date of the connection. |
DisplayName | Starting |
Format | DateOnly |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | effectivestart |
RequiredLevel | None |
Type | DateTime |
EntityImage
Property | Value |
---|---|
Description | The default image for the entity. |
DisplayName | Entity Image |
IsPrimaryImage | True |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | entityimage |
MaxHeight | 144 |
MaxWidth | 144 |
RequiredLevel | None |
Type | Image |
ImportSequenceNumber
Property | Value |
---|---|
Description | Unique identifier of the data import or data migration that created this record. |
DisplayName | Import Sequence Number |
Format | None |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | importsequencenumber |
MaxValue | 2147483647 |
MinValue | -2147483648 |
RequiredLevel | None |
Type | Integer |
OverriddenCreatedOn
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Date and time that the record was migrated. |
DisplayName | Record Created On |
Format | DateOnly |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | overriddencreatedon |
RequiredLevel | None |
Type | DateTime |
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 |
Targets | systemuser,team |
Type | Owner |
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 |
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 |
Type | Lookup |
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 |
Targets | connectionrole |
Type | Lookup |
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 |
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 |
Type | Lookup |
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 |
Targets | connectionrole |
Type | Lookup |
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 |
IsValidForCreate | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statecode |
RequiredLevel | SystemRequired |
Type | State |
StateCode Choices/Options
Value | Label | DefaultStatus | InvariantName |
---|---|---|---|
0 | Active | 1 | Active |
1 | Inactive | 2 | 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 |
StatusCode Choices/Options
Value | Label | State |
---|---|---|
1 | Active | 0 |
2 | Inactive | 1 |
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 |
Targets | transactioncurrency |
Type | Lookup |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.
- CreatedBy
- CreatedByName
- CreatedByYomiName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- EntityImage_Timestamp
- EntityImage_URL
- EntityImageId
- ExchangeRate
- IsMaster
- ModifiedBy
- ModifiedByName
- ModifiedByYomiName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- Name
- OwnerIdName
- OwnerIdYomiName
- OwningBusinessUnit
- OwningBusinessUnitName
- OwningTeam
- OwningUser
- Record1IdName
- Record1ObjectTypeCode
- Record1RoleIdName
- Record2IdName
- Record2ObjectTypeCode
- Record2RoleIdName
- RelatedConnectionId
- TransactionCurrencyIdName
- VersionNumber
CreatedBy
Property | Value |
---|---|
Description | Shows who created the record. |
DisplayName | Created By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
CreatedByName
Property | Value |
---|---|
Description | Name of the user who created the connection. |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
CreatedByYomiName
Property | Value |
---|---|
Description | YomiName of the user who created the connection. |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
CreatedOn
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
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 |
Format | DateAndTime |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdon |
RequiredLevel | None |
Type | DateTime |
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 |
Targets | systemuser |
Type | Lookup |
CreatedOnBehalfByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
CreatedOnBehalfByYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
EntityImage_Timestamp
Property | Value |
---|---|
Description | |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | entityimage_timestamp |
MaxValue | 9223372036854775807 |
MinValue | -9223372036854775808 |
RequiredLevel | None |
Type | BigInt |
EntityImage_URL
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Url |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | entityimage_url |
MaxLength | 200 |
RequiredLevel | None |
Type | String |
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 |
MaxValue | 100000000000 |
MinValue | 0.000000000001 |
Precision | 12 |
RequiredLevel | None |
Type | Decimal |
IsMaster
Property | Value |
---|---|
Description | Indicates that this is the master record. |
DisplayName | Is Master |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | ismaster |
RequiredLevel | SystemRequired |
Type | Boolean |
IsMaster Choices/Options
Value | Label | Description |
---|---|---|
1 | Yes | |
0 | No |
DefaultValue: 0
ModifiedBy
Property | Value |
---|---|
Description | Shows who last updated the record. |
DisplayName | Modified By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
ModifiedByName
Property | Value |
---|---|
Description | Name of the user who last modified the connection. |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ModifiedByYomiName
Property | Value |
---|---|
Description | YomiName of the user who last modified the connection. |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ModifiedOn
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
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 |
Format | DateAndTime |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedon |
RequiredLevel | None |
Type | DateTime |
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 |
Targets | systemuser |
Type | Lookup |
ModifiedOnBehalfByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ModifiedOnBehalfByYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Name
Property | Value |
---|---|
Description | Name of the connection. |
DisplayName | Connection Name |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | name |
MaxLength | 500 |
RequiredLevel | None |
Type | String |
OwnerIdName
Property | Value |
---|---|
Description | Name of the owner of the connection. |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridname |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
OwnerIdYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridyominame |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
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 |
Targets | businessunit |
Type | Lookup |
OwningBusinessUnitName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owningbusinessunitname |
MaxLength | 160 |
RequiredLevel | None |
Type | String |
OwningTeam
Property | Value |
---|---|
Description | Unique identifier of the team who owns the connection. |
DisplayName | Owning Team |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owningteam |
RequiredLevel | None |
Targets | team |
Type | Lookup |
OwningUser
Property | Value |
---|---|
Description | Unique identifier of the user who owns the connection. |
DisplayName | Owning User |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owninguser |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
Record1IdName
Property | Value |
---|---|
Description | Display name for the source record. |
DisplayName | Name (From) |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | record1idname |
MaxLength | 800 |
RequiredLevel | None |
Type | String |
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 |
Record1ObjectTypeCode Choices/Options
Value | Label | Description |
---|---|---|
1 | Account | Business that represents a customer or potential customer. The company that is billed in business transactions. |
2 | Contact | Person with whom a business unit has a relationship, such as customer, supplier, and colleague. |
8 | User | Person with access to the Microsoft CRM system and who owns objects in the Microsoft CRM database. |
9 | Team | Collection of system users that routinely collaborate. Teams can be used to simplify record sharing and provide team members with common access to organization data when team members belong to different Business Units. |
50 | Position | Position of a user in the hierarchy |
99 | Social Profile | This entity is used to store social profile information of its associated account and contacts on different social channels. |
2013 | Territory | Territory represents sales regions. |
4200 | Activity | Task performed, or to be performed, by a user. An activity is any action for which an entry can be made on a calendar. |
4201 | Appointment | Commitment representing a time interval with start/end times and duration. |
4202 | Activity that is delivered using email protocols. | |
4204 | Fax | Activity that tracks call outcome and number of pages for a fax and optionally stores an electronic copy of the document. |
4207 | Letter | Activity that tracks the delivery of a letter. The activity can contain the electronic copy of the letter. |
4210 | Phone Call | Activity to track a telephone call. |
4212 | Task | Generic activity representing work needed to be done. |
4216 | Social Activity | For internal use only. |
4251 | Recurring Appointment | The Master appointment of a recurring appointment series. |
4710 | Process Session | Information that is generated when a dialog is run. Every time that you run a dialog, a dialog session is created. |
9400 | Channel Access Profile Rule | Defines the rules for automatically associating channel access profiles to external party records.For internal use only |
9600 | Goal | Target objective for a user or a team for a specified time period. |
9930 | Knowledge Base Record | Metadata of knowledge base (KB) articles associated with Microsoft Dynamics 365 entities. |
9953 | Knowledge Article | Organizational knowledge for internal and external use. |
10288 | Invitation | Send invitations to existing contacts or email addresses and assign them to web roles upon redemption. |
10289 | Invite Redemption | Holds information about the redemption of an invite. |
10308 | Publishing State Transition Rule | |
10310 | Shortcut | |
10322 | Website | Web Portal |
Record1RoleIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | record1roleidname |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
Record2IdName
Property | Value |
---|---|
Description | Display name for the target record. |
DisplayName | Name (To) |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | record2idname |
MaxLength | 800 |
RequiredLevel | None |
Type | String |
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 |
Record2ObjectTypeCode Choices/Options
Value | Label | Description |
---|---|---|
1 | Account | Business that represents a customer or potential customer. The company that is billed in business transactions. |
2 | Contact | Person with whom a business unit has a relationship, such as customer, supplier, and colleague. |
8 | User | Person with access to the Microsoft CRM system and who owns objects in the Microsoft CRM database. |
9 | Team | Collection of system users that routinely collaborate. Teams can be used to simplify record sharing and provide team members with common access to organization data when team members belong to different Business Units. |
50 | Position | Position of a user in the hierarchy |
99 | Social Profile | This entity is used to store social profile information of its associated account and contacts on different social channels. |
2013 | Territory | Territory represents sales regions. |
4200 | Activity | Task performed, or to be performed, by a user. An activity is any action for which an entry can be made on a calendar. |
4201 | Appointment | Commitment representing a time interval with start/end times and duration. |
4202 | Activity that is delivered using email protocols. | |
4204 | Fax | Activity that tracks call outcome and number of pages for a fax and optionally stores an electronic copy of the document. |
4207 | Letter | Activity that tracks the delivery of a letter. The activity can contain the electronic copy of the letter. |
4210 | Phone Call | Activity to track a telephone call. |
4212 | Task | Generic activity representing work needed to be done. |
4216 | Social Activity | For internal use only. |
4251 | Recurring Appointment | The Master appointment of a recurring appointment series. |
4710 | Process Session | Information that is generated when a dialog is run. Every time that you run a dialog, a dialog session is created. |
9400 | Channel Access Profile Rule | Defines the rules for automatically associating channel access profiles to external party records.For internal use only |
9600 | Goal | Target objective for a user or a team for a specified time period. |
9930 | Knowledge Base Record | Metadata of knowledge base (KB) articles associated with Microsoft Dynamics 365 entities. |
9953 | Knowledge Article | Organizational knowledge for internal and external use. |
10288 | Invitation | Send invitations to existing contacts or email addresses and assign them to web roles upon redemption. |
10289 | Invite Redemption | Holds information about the redemption of an invite. |
10308 | Publishing State Transition Rule | |
10310 | Shortcut | |
10322 | Website | Web Portal |
Record2RoleIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | record2roleidname |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
RelatedConnectionId
Property | Value |
---|---|
Description | Unique identifier for the reciprocal connection record. |
DisplayName | Reciprocal Connection |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | relatedconnectionid |
RequiredLevel | ApplicationRequired |
Targets | connection |
Type | Lookup |
TransactionCurrencyIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | transactioncurrencyidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
VersionNumber
Property | Value |
---|---|
Description | Version number of the connection. |
DisplayName | Version Number |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | versionnumber |
MaxValue | 9223372036854775807 |
MinValue | -9223372036854775808 |
RequiredLevel | None |
Type | BigInt |
One-To-Many Relationships
Listed by SchemaName.
- Connection_AsyncOperations
- connection_related_connection
- connection_principalobjectattributeaccess
- Connection_SyncErrors
- Connection_ProcessSessions
Connection_AsyncOperations
Same as the Connection_AsyncOperations many-to-one relationship for the asyncoperation table/entity.
Property | Value |
---|---|
ReferencingEntity | asyncoperation |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | Connection_AsyncOperations |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
connection_related_connection
Same as the connection_related_connection many-to-one relationship for the connection table/entity.
Property | Value |
---|---|
ReferencingEntity | connection |
ReferencingAttribute | relatedconnectionid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | connection_related_connection |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
connection_principalobjectattributeaccess
Same as the connection_principalobjectattributeaccess many-to-one relationship for the principalobjectattributeaccess table/entity.
Property | Value |
---|---|
ReferencingEntity | principalobjectattributeaccess |
ReferencingAttribute | objectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | connection_principalobjectattributeaccess |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Connection_SyncErrors
Same as the Connection_SyncErrors many-to-one relationship for the syncerror table/entity.
Property | Value |
---|---|
ReferencingEntity | syncerror |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | Connection_SyncErrors |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
Connection_ProcessSessions
Same as the Connection_ProcessSessions many-to-one relationship for the processsession table/entity.
Property | Value |
---|---|
ReferencingEntity | processsession |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | Connection_ProcessSessions |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 110 |
CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Many-To-One Relationships
Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.
- knowledgearticle_connections1
- knowledgearticle_connections2
- KnowledgeBaseRecord_connections1
- KnowledgeBaseRecord_connections2
- processsession_connections1
- contact_connections1
- recurringappointmentmaster_connections1
- processsession_connections2
- letter_connections1
- connection_role_connections2
- systemuser_connections2
- letter_connections2
- appointment_connections1
- email_connections1
- account_connections1
- fax_connections2
- activitypointer_connections2
- socialprofile_connections2
- createdby_connection
- account_connections2
- phonecall_connections1
- task_connections1
- modifiedby_connection
- appointment_connections2
- phonecall_connections2
- TransactionCurrency_Connection
- task_connections2
- fax_connections1
- position_connection2
- goal_connections1
- connection_role_connections1
- position_connection1
- email_connections2
- team_connections1
- lk_connectionbase_modifiedonbehalfby
- socialactivity_connections1
- connection_related_connection
- contact_connections2
- lk_connectionbase_createdonbehalfby
- activitypointer_connections1
- systemuser_connections1
- team_connections2
- business_unit_connections
- goal_connections2
- socialprofile_connections1
- socialactivity_connections2
- recurringappointmentmaster_connections2
- territory_connections1
- territory_connections2
- adx_invitation_connections1
- adx_invitation_connections2
- adx_inviteredemption_connections1
- adx_inviteredemption_connections2
- mspp_publishingstatetransitionrule_connections1
- mspp_publishingstatetransitionrule_connections2
- mspp_shortcut_connections1
- mspp_shortcut_connections2
- mspp_website_connections1
- mspp_website_connections2
knowledgearticle_connections1
See the knowledgearticle_connections1 one-to-many relationship for the knowledgearticle table/entity.
knowledgearticle_connections2
See the knowledgearticle_connections2 one-to-many relationship for the knowledgearticle table/entity.
KnowledgeBaseRecord_connections1
See the KnowledgeBaseRecord_connections1 one-to-many relationship for the knowledgebaserecord table/entity.
KnowledgeBaseRecord_connections2
See the KnowledgeBaseRecord_connections2 one-to-many relationship for the knowledgebaserecord table/entity.
processsession_connections1
See the processsession_connections1 one-to-many relationship for the processsession table/entity.
contact_connections1
See the contact_connections1 one-to-many relationship for the contact table/entity.
recurringappointmentmaster_connections1
See the recurringappointmentmaster_connections1 one-to-many relationship for the recurringappointmentmaster table/entity.
processsession_connections2
See the processsession_connections2 one-to-many relationship for the processsession table/entity.
letter_connections1
See the letter_connections1 one-to-many relationship for the letter table/entity.
connection_role_connections2
See the connection_role_connections2 one-to-many relationship for the connectionrole table/entity.
systemuser_connections2
See the systemuser_connections2 one-to-many relationship for the systemuser table/entity.
letter_connections2
See the letter_connections2 one-to-many relationship for the letter table/entity.
appointment_connections1
See the appointment_connections1 one-to-many relationship for the appointment table/entity.
email_connections1
See the email_connections1 one-to-many relationship for the email table/entity.
account_connections1
See the account_connections1 one-to-many relationship for the account table/entity.
fax_connections2
See the fax_connections2 one-to-many relationship for the fax table/entity.
activitypointer_connections2
See the activitypointer_connections2 one-to-many relationship for the activitypointer table/entity.
socialprofile_connections2
See the socialprofile_connections2 one-to-many relationship for the socialprofile table/entity.
createdby_connection
See the createdby_connection one-to-many relationship for the systemuser table/entity.
account_connections2
See the account_connections2 one-to-many relationship for the account table/entity.
phonecall_connections1
See the phonecall_connections1 one-to-many relationship for the phonecall table/entity.
task_connections1
See the task_connections1 one-to-many relationship for the task table/entity.
modifiedby_connection
See the modifiedby_connection one-to-many relationship for the systemuser table/entity.
appointment_connections2
See the appointment_connections2 one-to-many relationship for the appointment table/entity.
phonecall_connections2
See the phonecall_connections2 one-to-many relationship for the phonecall table/entity.
TransactionCurrency_Connection
See the TransactionCurrency_Connection one-to-many relationship for the transactioncurrency table/entity.
task_connections2
See the task_connections2 one-to-many relationship for the task table/entity.
fax_connections1
See the fax_connections1 one-to-many relationship for the fax table/entity.
position_connection2
See the position_connection2 one-to-many relationship for the position table/entity.
goal_connections1
See the goal_connections1 one-to-many relationship for the goal table/entity.
connection_role_connections1
See the connection_role_connections1 one-to-many relationship for the connectionrole table/entity.
position_connection1
See the position_connection1 one-to-many relationship for the position table/entity.
email_connections2
See the email_connections2 one-to-many relationship for the email table/entity.
team_connections1
See the team_connections1 one-to-many relationship for the team table/entity.
lk_connectionbase_modifiedonbehalfby
See the lk_connectionbase_modifiedonbehalfby one-to-many relationship for the systemuser table/entity.
socialactivity_connections1
See the socialactivity_connections1 one-to-many relationship for the socialactivity table/entity.
connection_related_connection
See the connection_related_connection one-to-many relationship for the connection table/entity.
contact_connections2
See the contact_connections2 one-to-many relationship for the contact table/entity.
lk_connectionbase_createdonbehalfby
See the lk_connectionbase_createdonbehalfby one-to-many relationship for the systemuser table/entity.
activitypointer_connections1
See the activitypointer_connections1 one-to-many relationship for the activitypointer table/entity.
systemuser_connections1
See the systemuser_connections1 one-to-many relationship for the systemuser table/entity.
team_connections2
See the team_connections2 one-to-many relationship for the team table/entity.
business_unit_connections
See the business_unit_connections one-to-many relationship for the businessunit table/entity.
goal_connections2
See the goal_connections2 one-to-many relationship for the goal table/entity.
socialprofile_connections1
See the socialprofile_connections1 one-to-many relationship for the socialprofile table/entity.
socialactivity_connections2
See the socialactivity_connections2 one-to-many relationship for the socialactivity table/entity.
recurringappointmentmaster_connections2
See the recurringappointmentmaster_connections2 one-to-many relationship for the recurringappointmentmaster table/entity.
territory_connections1
Added by: Application Common Solution
See the territory_connections1 one-to-many relationship for the territory table/entity.
territory_connections2
Added by: Application Common Solution
See the territory_connections2 one-to-many relationship for the territory table/entity.
adx_invitation_connections1
Added by: Power Pages Runtime Core Solution
See the adx_invitation_connections1 one-to-many relationship for the adx_invitation table/entity.
adx_invitation_connections2
Added by: Power Pages Runtime Core Solution
See the adx_invitation_connections2 one-to-many relationship for the adx_invitation table/entity.
adx_inviteredemption_connections1
Added by: Active Solution Solution
See the adx_inviteredemption_connections1 one-to-many relationship for the adx_inviteredemption table/entity.
adx_inviteredemption_connections2
Added by: Active Solution Solution
See the adx_inviteredemption_connections2 one-to-many relationship for the adx_inviteredemption table/entity.
mspp_publishingstatetransitionrule_connections1
Added by: Power Pages Apps Solution
See the mspp_publishingstatetransitionrule_connections1 one-to-many relationship for the mspp_publishingstatetransitionrule table/entity.
mspp_publishingstatetransitionrule_connections2
Added by: Power Pages Apps Solution
See the mspp_publishingstatetransitionrule_connections2 one-to-many relationship for the mspp_publishingstatetransitionrule table/entity.
mspp_shortcut_connections1
Added by: Power Pages Apps Solution
See the mspp_shortcut_connections1 one-to-many relationship for the mspp_shortcut table/entity.
mspp_shortcut_connections2
Added by: Power Pages Apps Solution
See the mspp_shortcut_connections2 one-to-many relationship for the mspp_shortcut table/entity.
mspp_website_connections1
Added by: Power Pages Apps Solution
See the mspp_website_connections1 one-to-many relationship for the mspp_website table/entity.
mspp_website_connections2
Added by: Power Pages Apps Solution
See the mspp_website_connections2 one-to-many relationship for the mspp_website table/entity.
See also
Dataverse table/entity reference
Web API Reference
connection EntityType