Connection entity reference
Relationship between two entities.
Messages
| Message | SDK class or method |
|---|---|
| Assign | AssignRequest |
| Create | CreateRequest or Create |
| Delete | DeleteRequest or Delete |
| GrantAccess | GrantAccessRequest |
| ModifyAccess | ModifyAccessRequest |
| Retrieve | RetrieveRequest or Retrieve |
| RetrieveMultiple | RetrieveMultipleRequest or RetrieveMultiple |
| RetrievePrincipalAccess | RetrievePrincipalAccessRequest |
| RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccessRequest |
| RevokeAccess | RevokeAccessRequest |
| SetState | SetStateRequest |
| 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 attributes
These 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 | False |
| 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 | Unique identifier of the source record. |
| DisplayName | Connected From |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | record1id |
| RequiredLevel | None |
| Targets | account,activitypointer,appointment,campaign,campaignactivity,channelaccessprofilerule,competitor,constraintbasedgroup,contact,contract,email,entitlement,entitlementchannel,entitlementtemplatechannel,equipment,fax,goal,incident,invoice,knowledgearticle,knowledgebaserecord,lead,letter,list,msdyn_postalbum,opportunity,phonecall,position,pricelevel,processsession,product,quote,recurringappointmentmaster,resourcegroup,salesorder,serviceappointment,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 | Unique identifier of the target record. |
| DisplayName | Connected To |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | record2id |
| RequiredLevel | None |
| Targets | account,activitypointer,appointment,campaign,campaignactivity,channelaccessprofilerule,competitor,constraintbasedgroup,contact,contract,email,entitlement,entitlementchannel,entitlementtemplatechannel,equipment,fax,goal,incident,invoice,knowledgearticle,knowledgebaserecord,lead,letter,list,msdyn_postalbum,opportunity,phonecall,position,pricelevel,processsession,product,quote,recurringappointmentmaster,resourcegroup,salesorder,serviceappointment,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 attributes
These 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.0000000001 |
| Precision | 10 |
| 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 | ApplicationRequired |
| 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 | 500 |
| 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. |
| 3 | Opportunity | Potential revenue-generating event, or sale to an account, which needs to be tracked through a sales process to completion. |
| 4 | Lead | Prospect or potential sales opportunity. Leads are converted into accounts, contacts, or opportunities when they are qualified. Otherwise, they are deleted or archived. |
| 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. |
| 112 | Case | Service request case associated with a contract. |
| 123 | Competitor | Business competing for the sale represented by a lead or opportunity. |
| 1010 | Contract | Agreement to provide customer service during a specified amount of time or number of cases. |
| 1022 | Price List | Entity that defines pricing levels. |
| 1024 | Product | Information about products and their pricing information. |
| 1084 | Quote | Formal offer for products and/or services, proposed at specific prices and related payment terms, which is sent to a prospective customer. |
| 1088 | Order | Quote that has been accepted. |
| 1090 | Invoice | Order that has been billed. |
| 2013 | Territory | Territory represents sales regions. |
| 4000 | Facility/Equipment | Resource that can be scheduled. |
| 4005 | Scheduling Group | Resource group or team whose members can be scheduled for a service. |
| 4007 | Resource Group | Group or collection of people, equipment, and/or facilities that can be scheduled. |
| 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. |
| 4214 | Service Activity | Activity offered by the organization to satisfy its customer's needs. Each service activity includes date, time, duration, and required resources. |
| 4216 | Social Activity | For internal use only. |
| 4251 | Recurring Appointment | The Master appointment of a recurring appointment series. |
| 4300 | Marketing List | Group of existing or potential customers created for a marketing campaign or other sales purposes. |
| 4400 | Campaign | Container for campaign activities and responses, sales literature, products, and lists to create, plan, execute, and track the results of a specific marketing campaign through its life. |
| 4402 | Campaign Activity | Task performed, or to be performed, by a user for planning or running a campaign. |
| 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. |
| 9700 | Entitlement | Defines the amount and type of support a customer should receive. |
| 9701 | Entitlement Channel | Defines the amount and type of support for a channel. |
| 9703 | Entitlement Template Channel | Contains predefined support terms for a channel to create entitlements for customers. |
| 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. |
| 10005 | Profile Album | Contains user profile images that are stored as attachments and displayed in posts. |
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 | 500 |
| 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. |
| 3 | Opportunity | Potential revenue-generating event, or sale to an account, which needs to be tracked through a sales process to completion. |
| 4 | Lead | Prospect or potential sales opportunity. Leads are converted into accounts, contacts, or opportunities when they are qualified. Otherwise, they are deleted or archived. |
| 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. |
| 112 | Case | Service request case associated with a contract. |
| 123 | Competitor | Business competing for the sale represented by a lead or opportunity. |
| 1010 | Contract | Agreement to provide customer service during a specified amount of time or number of cases. |
| 1022 | Price List | Entity that defines pricing levels. |
| 1024 | Product | Information about products and their pricing information. |
| 1084 | Quote | Formal offer for products and/or services, proposed at specific prices and related payment terms, which is sent to a prospective customer. |
| 1088 | Order | Quote that has been accepted. |
| 1090 | Invoice | Order that has been billed. |
| 2013 | Territory | Territory represents sales regions. |
| 4000 | Facility/Equipment | Resource that can be scheduled. |
| 4005 | Scheduling Group | Resource group or team whose members can be scheduled for a service. |
| 4007 | Resource Group | Group or collection of people, equipment, and/or facilities that can be scheduled. |
| 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. |
| 4214 | Service Activity | Activity offered by the organization to satisfy its customer's needs. Each service activity includes date, time, duration, and required resources. |
| 4216 | Social Activity | For internal use only. |
| 4251 | Recurring Appointment | The Master appointment of a recurring appointment series. |
| 4300 | Marketing List | Group of existing or potential customers created for a marketing campaign or other sales purposes. |
| 4400 | Campaign | Container for campaign activities and responses, sales literature, products, and lists to create, plan, execute, and track the results of a specific marketing campaign through its life. |
| 4402 | Campaign Activity | Task performed, or to be performed, by a user for planning or running a campaign. |
| 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. |
| 9700 | Entitlement | Defines the amount and type of support a customer should receive. |
| 9701 | Entitlement Channel | Defines the amount and type of support for a channel. |
| 9703 | Entitlement Template Channel | Contains predefined support terms for a channel to create entitlements for customers. |
| 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. |
| 10005 | Profile Album | Contains user profile images that are stored as attachments and displayed in posts. |
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 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 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 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 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 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 entity. Listed by SchemaName.
- knowledgearticle_connections1
- knowledgearticle_connections2
- territory_connections1
- territory_connections2
- lead_connections1
- lead_connections2
- pricelevel_connections1
- pricelevel_connections2
- product_connections1
- product_connections2
- campaign_connections1
- campaign_connections2
- campaignactivity_connections1
- campaignactivity_connections2
- list_connections1
- list_connections2
- constraintbasedgroup_connections1
- constraintbasedgroup_connections2
- contract_connections1
- contract_connections2
- entitlement_connections1
- entitlement_connections2
- entitlementchannel_connections1
- entitlementchannel_connections2
- entitlementtemplatechannel_connections1
- entitlementtemplatechannel_connections2
- equipment_connections1
- equipment_connections2
- incident_connections1
- incident_connections2
- resourcegroup_connections1
- resourcegroup_connections2
- serviceappointment_connections1
- serviceappointment_connections2
- invoice_connections1
- invoice_connections2
- opportunity_connections1
- opportunity_connections2
- quote_connections1
- quote_connections2
- salesorder_connections1
- salesorder_connections2
- competitor_connections1
- competitor_connections2
- msdyn_postalbum_connections1
- msdyn_postalbum_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
knowledgearticle_connections1
See the knowledgearticle_connections1 one-to-many relationship for the knowledgearticle entity.
knowledgearticle_connections2
See the knowledgearticle_connections2 one-to-many relationship for the knowledgearticle entity.
territory_connections1
Added by: Application Common Solution
See the territory_connections1 one-to-many relationship for the territory entity.
territory_connections2
Added by: Application Common Solution
See the territory_connections2 one-to-many relationship for the territory entity.
lead_connections1
Added by: Lead Management Solution
See the lead_connections1 one-to-many relationship for the lead entity.
lead_connections2
Added by: Lead Management Solution
See the lead_connections2 one-to-many relationship for the lead entity.
pricelevel_connections1
Added by: Product Management Solution
See the pricelevel_connections1 one-to-many relationship for the pricelevel entity.
pricelevel_connections2
Added by: Product Management Solution
See the pricelevel_connections2 one-to-many relationship for the pricelevel entity.
product_connections1
Added by: Product Management Solution
See the product_connections1 one-to-many relationship for the product entity.
product_connections2
Added by: Product Management Solution
See the product_connections2 one-to-many relationship for the product entity.
campaign_connections1
Added by: Marketing Solution
See the campaign_connections1 one-to-many relationship for the campaign entity.
campaign_connections2
Added by: Marketing Solution
See the campaign_connections2 one-to-many relationship for the campaign entity.
campaignactivity_connections1
Added by: Marketing Solution
See the campaignactivity_connections1 one-to-many relationship for the campaignactivity entity.
campaignactivity_connections2
Added by: Marketing Solution
See the campaignactivity_connections2 one-to-many relationship for the campaignactivity entity.
list_connections1
Added by: Marketing Solution
See the list_connections1 one-to-many relationship for the list entity.
list_connections2
Added by: Marketing Solution
See the list_connections2 one-to-many relationship for the list entity.
constraintbasedgroup_connections1
Added by: Service Solution
See the constraintbasedgroup_connections1 one-to-many relationship for the constraintbasedgroup entity.
constraintbasedgroup_connections2
Added by: Service Solution
See the constraintbasedgroup_connections2 one-to-many relationship for the constraintbasedgroup entity.
contract_connections1
Added by: Service Solution
See the contract_connections1 one-to-many relationship for the contract entity.
contract_connections2
Added by: Service Solution
See the contract_connections2 one-to-many relationship for the contract entity.
entitlement_connections1
Added by: Service Solution
See the entitlement_connections1 one-to-many relationship for the entitlement entity.
entitlement_connections2
Added by: Service Solution
See the entitlement_connections2 one-to-many relationship for the entitlement entity.
entitlementchannel_connections1
Added by: Service Solution
See the entitlementchannel_connections1 one-to-many relationship for the entitlementchannel entity.
entitlementchannel_connections2
Added by: Service Solution
See the entitlementchannel_connections2 one-to-many relationship for the entitlementchannel entity.
entitlementtemplatechannel_connections1
Added by: Service Solution
See the entitlementtemplatechannel_connections1 one-to-many relationship for the entitlementtemplatechannel entity.
entitlementtemplatechannel_connections2
Added by: Service Solution
See the entitlementtemplatechannel_connections2 one-to-many relationship for the entitlementtemplatechannel entity.
equipment_connections1
Added by: Service Solution
See the equipment_connections1 one-to-many relationship for the equipment entity.
equipment_connections2
Added by: Service Solution
See the equipment_connections2 one-to-many relationship for the equipment entity.
incident_connections1
Added by: Service Solution
See the incident_connections1 one-to-many relationship for the incident entity.
incident_connections2
Added by: Service Solution
See the incident_connections2 one-to-many relationship for the incident entity.
resourcegroup_connections1
Added by: Service Solution
See the resourcegroup_connections1 one-to-many relationship for the resourcegroup entity.
resourcegroup_connections2
Added by: Service Solution
See the resourcegroup_connections2 one-to-many relationship for the resourcegroup entity.
serviceappointment_connections1
Added by: Service Solution
See the serviceappointment_connections1 one-to-many relationship for the serviceappointment entity.
serviceappointment_connections2
Added by: Service Solution
See the serviceappointment_connections2 one-to-many relationship for the serviceappointment entity.
invoice_connections1
Added by: Sales Solution
See the invoice_connections1 one-to-many relationship for the invoice entity.
invoice_connections2
Added by: Sales Solution
See the invoice_connections2 one-to-many relationship for the invoice entity.
opportunity_connections1
Added by: Sales Solution
See the opportunity_connections1 one-to-many relationship for the opportunity entity.
opportunity_connections2
Added by: Sales Solution
See the opportunity_connections2 one-to-many relationship for the opportunity entity.
quote_connections1
Added by: Sales Solution
See the quote_connections1 one-to-many relationship for the quote entity.
quote_connections2
Added by: Sales Solution
See the quote_connections2 one-to-many relationship for the quote entity.
salesorder_connections1
Added by: Sales Solution
See the salesorder_connections1 one-to-many relationship for the salesorder entity.
salesorder_connections2
Added by: Sales Solution
See the salesorder_connections2 one-to-many relationship for the salesorder entity.
competitor_connections1
Added by: Sales Solution
See the competitor_connections1 one-to-many relationship for the competitor entity.
competitor_connections2
Added by: Sales Solution
See the competitor_connections2 one-to-many relationship for the competitor entity.
msdyn_postalbum_connections1
Added by: Activity Feeds Solution
See the msdyn_postalbum_connections1 one-to-many relationship for the msdyn_postalbum entity.
msdyn_postalbum_connections2
Added by: Activity Feeds Solution
See the msdyn_postalbum_connections2 one-to-many relationship for the msdyn_postalbum entity.
KnowledgeBaseRecord_connections1
See the KnowledgeBaseRecord_connections1 one-to-many relationship for the knowledgebaserecord entity.
KnowledgeBaseRecord_connections2
See the KnowledgeBaseRecord_connections2 one-to-many relationship for the knowledgebaserecord entity.
processsession_connections1
See the processsession_connections1 one-to-many relationship for the processsession entity.
contact_connections1
See the contact_connections1 one-to-many relationship for the contact entity.
recurringappointmentmaster_connections1
See the recurringappointmentmaster_connections1 one-to-many relationship for the recurringappointmentmaster entity.
processsession_connections2
See the processsession_connections2 one-to-many relationship for the processsession entity.
letter_connections1
See the letter_connections1 one-to-many relationship for the letter entity.
connection_role_connections2
See the connection_role_connections2 one-to-many relationship for the connectionrole entity.
systemuser_connections2
See the systemuser_connections2 one-to-many relationship for the systemuser entity.
letter_connections2
See the letter_connections2 one-to-many relationship for the letter entity.
appointment_connections1
See the appointment_connections1 one-to-many relationship for the appointment entity.
email_connections1
See the email_connections1 one-to-many relationship for the email entity.
account_connections1
See the account_connections1 one-to-many relationship for the account entity.
fax_connections2
See the fax_connections2 one-to-many relationship for the fax entity.
activitypointer_connections2
See the activitypointer_connections2 one-to-many relationship for the activitypointer entity.
socialprofile_connections2
See the socialprofile_connections2 one-to-many relationship for the socialprofile entity.
createdby_connection
See the createdby_connection one-to-many relationship for the systemuser entity.
account_connections2
See the account_connections2 one-to-many relationship for the account entity.
phonecall_connections1
See the phonecall_connections1 one-to-many relationship for the phonecall entity.
task_connections1
See the task_connections1 one-to-many relationship for the task entity.
modifiedby_connection
See the modifiedby_connection one-to-many relationship for the systemuser entity.
appointment_connections2
See the appointment_connections2 one-to-many relationship for the appointment entity.
phonecall_connections2
See the phonecall_connections2 one-to-many relationship for the phonecall entity.
TransactionCurrency_Connection
See the TransactionCurrency_Connection one-to-many relationship for the transactioncurrency entity.
task_connections2
See the task_connections2 one-to-many relationship for the task entity.
fax_connections1
See the fax_connections1 one-to-many relationship for the fax entity.
position_connection2
See the position_connection2 one-to-many relationship for the position entity.
goal_connections1
See the goal_connections1 one-to-many relationship for the goal entity.
connection_role_connections1
See the connection_role_connections1 one-to-many relationship for the connectionrole entity.
position_connection1
See the position_connection1 one-to-many relationship for the position entity.
email_connections2
See the email_connections2 one-to-many relationship for the email entity.
team_connections1
See the team_connections1 one-to-many relationship for the team entity.
lk_connectionbase_modifiedonbehalfby
See the lk_connectionbase_modifiedonbehalfby one-to-many relationship for the systemuser entity.
socialactivity_connections1
See the socialactivity_connections1 one-to-many relationship for the socialactivity entity.
connection_related_connection
See the connection_related_connection one-to-many relationship for the connection entity.
contact_connections2
See the contact_connections2 one-to-many relationship for the contact entity.
lk_connectionbase_createdonbehalfby
See the lk_connectionbase_createdonbehalfby one-to-many relationship for the systemuser entity.
activitypointer_connections1
See the activitypointer_connections1 one-to-many relationship for the activitypointer entity.
systemuser_connections1
See the systemuser_connections1 one-to-many relationship for the systemuser entity.
team_connections2
See the team_connections2 one-to-many relationship for the team entity.
business_unit_connections
See the business_unit_connections one-to-many relationship for the businessunit entity.
goal_connections2
See the goal_connections2 one-to-many relationship for the goal entity.
socialprofile_connections1
See the socialprofile_connections1 one-to-many relationship for the socialprofile entity.
socialactivity_connections2
See the socialactivity_connections2 one-to-many relationship for the socialactivity entity.
recurringappointmentmaster_connections2
See the recurringappointmentmaster_connections2 one-to-many relationship for the recurringappointmentmaster entity.
See also
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for