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 Assembly |
|---|---|---|
| Assign | PATCH [org URI]/api/data/v9.0/connections(connectionid) Update ownerid property. |
AssignRequest |
| Create | POST [org URI]/api/data/v9.0/connections See Create |
CreateRequest or Create |
| Delete | DELETE [org URI]/api/data/v9.0/connections(connectionid) See Delete |
DeleteRequest or Delete |
| GrantAccess | GrantAccess Action | GrantAccessRequest |
| ModifyAccess | ModifyAccess Action | ModifyAccessRequest |
| Retrieve | GET [org URI]/api/data/v9.0/connections(connectionid) See Retrieve |
RetrieveRequest or Retrieve |
| RetrieveMultiple | GET [org URI]/api/data/v9.0/connections See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
| RetrievePrincipalAccess | RetrievePrincipalAccess Function | RetrievePrincipalAccessRequest |
| RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccess Function | RetrieveSharedPrincipalsAndAccessRequest |
| RevokeAccess | RevokeAccess Action | RevokeAccessRequest |
| SetState | PATCH [org URI]/api/data/v9.0/connections(connectionid) Update statecode and statuscode properties. |
SetStateRequest |
| Update | PATCH [org URI]/api/data/v9.0/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,appointment,channelaccessprofilerule,contact,email,fax,goal,knowledgearticle,knowledgebaserecord,letter,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,appointment,channelaccessprofilerule,contact,email,fax,goal,knowledgearticle,knowledgebaserecord,letter,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
- 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: False
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 | False |
| IsValidForRead | True |
| LogicalName | owningbusinessunit |
| RequiredLevel | None |
| Targets | businessunit |
| Type | Lookup |
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. |
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. |
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 asyncoperation table Connection_AsyncOperations Many-To-One relationship.
| 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 connection table connection_related_connection Many-To-One relationship.
| 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 principalobjectattributeaccess table connection_principalobjectattributeaccess Many-To-One relationship.
| 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 syncerror table Connection_SyncErrors Many-To-One relationship.
| 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 processsession table Connection_ProcessSessions Many-To-One relationship.
| 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
knowledgearticle_connections1
See knowledgearticle Table knowledgearticle_connections1 One-To-Many relationship.
knowledgearticle_connections2
See knowledgearticle Table knowledgearticle_connections2 One-To-Many relationship.
KnowledgeBaseRecord_connections1
See knowledgebaserecord Table KnowledgeBaseRecord_connections1 One-To-Many relationship.
KnowledgeBaseRecord_connections2
See knowledgebaserecord Table KnowledgeBaseRecord_connections2 One-To-Many relationship.
processsession_connections1
See processsession Table processsession_connections1 One-To-Many relationship.
contact_connections1
See contact Table contact_connections1 One-To-Many relationship.
recurringappointmentmaster_connections1
See recurringappointmentmaster Table recurringappointmentmaster_connections1 One-To-Many relationship.
processsession_connections2
See processsession Table processsession_connections2 One-To-Many relationship.
letter_connections1
See letter Table letter_connections1 One-To-Many relationship.
connection_role_connections2
See connectionrole Table connection_role_connections2 One-To-Many relationship.
systemuser_connections2
See systemuser Table systemuser_connections2 One-To-Many relationship.
letter_connections2
See letter Table letter_connections2 One-To-Many relationship.
appointment_connections1
See appointment Table appointment_connections1 One-To-Many relationship.
email_connections1
See email Table email_connections1 One-To-Many relationship.
account_connections1
See account Table account_connections1 One-To-Many relationship.
fax_connections2
See fax Table fax_connections2 One-To-Many relationship.
activitypointer_connections2
See activitypointer Table activitypointer_connections2 One-To-Many relationship.
socialprofile_connections2
See socialprofile Table socialprofile_connections2 One-To-Many relationship.
createdby_connection
See systemuser Table createdby_connection One-To-Many relationship.
account_connections2
See account Table account_connections2 One-To-Many relationship.
phonecall_connections1
See phonecall Table phonecall_connections1 One-To-Many relationship.
task_connections1
See task Table task_connections1 One-To-Many relationship.
modifiedby_connection
See systemuser Table modifiedby_connection One-To-Many relationship.
appointment_connections2
See appointment Table appointment_connections2 One-To-Many relationship.
phonecall_connections2
See phonecall Table phonecall_connections2 One-To-Many relationship.
TransactionCurrency_Connection
See transactioncurrency Table TransactionCurrency_Connection One-To-Many relationship.
task_connections2
See task Table task_connections2 One-To-Many relationship.
fax_connections1
See fax Table fax_connections1 One-To-Many relationship.
position_connection2
See position Table position_connection2 One-To-Many relationship.
goal_connections1
See goal Table goal_connections1 One-To-Many relationship.
connection_role_connections1
See connectionrole Table connection_role_connections1 One-To-Many relationship.
position_connection1
See position Table position_connection1 One-To-Many relationship.
email_connections2
See email Table email_connections2 One-To-Many relationship.
team_connections1
See team Table team_connections1 One-To-Many relationship.
lk_connectionbase_modifiedonbehalfby
See systemuser Table lk_connectionbase_modifiedonbehalfby One-To-Many relationship.
socialactivity_connections1
See socialactivity Table socialactivity_connections1 One-To-Many relationship.
connection_related_connection
See connection Table connection_related_connection One-To-Many relationship.
contact_connections2
See contact Table contact_connections2 One-To-Many relationship.
lk_connectionbase_createdonbehalfby
See systemuser Table lk_connectionbase_createdonbehalfby One-To-Many relationship.
activitypointer_connections1
See activitypointer Table activitypointer_connections1 One-To-Many relationship.
systemuser_connections1
See systemuser Table systemuser_connections1 One-To-Many relationship.
team_connections2
See team Table team_connections2 One-To-Many relationship.
business_unit_connections
See businessunit Table business_unit_connections One-To-Many relationship.
goal_connections2
See goal Table goal_connections2 One-To-Many relationship.
socialprofile_connections1
See socialprofile Table socialprofile_connections1 One-To-Many relationship.
socialactivity_connections2
See socialactivity Table socialactivity_connections2 One-To-Many relationship.
recurringappointmentmaster_connections2
See recurringappointmentmaster Table recurringappointmentmaster_connections2 One-To-Many relationship.
territory_connections1
Added by: Application Common Solution
See territory Table territory_connections1 One-To-Many relationship.
territory_connections2
Added by: Application Common Solution
See territory Table territory_connections2 One-To-Many relationship.
See also
About the table reference
Web API Reference
connection EntityType