Property Association (DynamicPropertyAssociation) table/entity reference (Microsoft Dynamics 365)
Association of a property definition with another entity in the system.
Messages
The following table lists the messages for the Property Association (DynamicPropertyAssociation) table. Messages represent operations that can be performed on the table. They may also be events.
Name Is Event? |
Web API Operation | SDK for .NET |
---|---|---|
Associate Event: True |
Associate records | Associate records |
Create Event: False |
POST /dynamicpropertyassociationsSee Create |
Create records |
CreateMultiple Event: True |
CreateMultiple | CreateMultipleRequest |
Delete Event: False |
DELETE /dynamicpropertyassociations(dynamicpropertyassociationid)See Delete |
Delete records |
Disassociate Event: True |
Disassociate records | Disassociate records |
Retrieve Event: False |
GET /dynamicpropertyassociations(dynamicpropertyassociationid)See Retrieve |
Retrieve records |
RetrieveMultiple Event: True |
GET /dynamicpropertyassociationsSee Query data |
Query data |
Update Event: False |
PATCH /dynamicpropertyassociations(dynamicpropertyassociationid)See Update |
Update records |
UpdateMultiple Event: True |
UpdateMultiple | UpdateMultipleRequest |
Upsert Event: False |
PATCH /dynamicpropertyassociations(dynamicpropertyassociationid)See Upsert a table row |
UpsertRequest |
UpsertMultiple Event: False |
UpsertMultiple | UpsertMultipleRequest |
Properties
The following table lists selected properties for the Property Association (DynamicPropertyAssociation) table.
Property | Value |
---|---|
DisplayName | Property Association |
DisplayCollectionName | Property Associations |
SchemaName | DynamicPropertyAssociation |
CollectionSchemaName | DynamicPropertyAssociations |
EntitySetName | dynamicpropertyassociations |
LogicalName | dynamicpropertyassociation |
LogicalCollectionName | dynamicpropertyassociations |
PrimaryIdAttribute | dynamicpropertyassociationid |
PrimaryNameAttribute | name |
TableType | Standard |
OwnershipType | OrganizationOwned |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- AssociationStatus
- DMTImportState
- DynamicPropertyAssociationId
- DynamicPropertyId
- ImportSequenceNumber
- InheritanceState
- Name
- OverriddenCreatedOn
- RegardingObjectid
- RegardingObjectTypeCode
- TimeZoneRuleVersionNumber
- TransactionCurrencyId
- UTCConversionTimeZoneCode
AssociationStatus
Property | Value |
---|---|
Description | Shows the status of the property association. |
DisplayName | Association Status. |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | associationstatus |
RequiredLevel | None |
Type | Picklist |
DefaultFormValue | 1 |
GlobalChoiceName | dynamicpropertyassociation_associationstatus |
AssociationStatus Choices/Options
Value | Label |
---|---|
0 | Active |
1 | Deleted |
2 | Draft |
3 | Draft Added |
4 | Draft Deleted |
DMTImportState
Property | Value |
---|---|
Description | Internal Use Only |
DisplayName | Internal Use Only |
IsValidForForm | False |
IsValidForRead | False |
LogicalName | dmtimportstate |
RequiredLevel | None |
Type | Integer |
MaxValue | 2147483647 |
MinValue | -2147483648 |
DynamicPropertyAssociationId
Property | Value |
---|---|
Description | Shows the unique identifier of the property association. |
DisplayName | Property Association ID |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | dynamicpropertyassociationid |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
DynamicPropertyId
Property | Value |
---|---|
Description | Shows the property that uses this option set item. |
DisplayName | Property ID |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | dynamicpropertyid |
RequiredLevel | SystemRequired |
Type | Lookup |
Targets | dynamicproperty |
ImportSequenceNumber
Property | Value |
---|---|
Description | Sequence number of the import that created this record. |
DisplayName | Import Sequence Number |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | importsequencenumber |
RequiredLevel | None |
Type | Integer |
MaxValue | 2147483647 |
MinValue | -2147483648 |
InheritanceState
Property | Value |
---|---|
Description | Shows the inheritance state in relationship to the parent property. |
DisplayName | Inheritance State. |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | inheritancestate |
RequiredLevel | None |
Type | Picklist |
DefaultFormValue | 1 |
GlobalChoiceName | dynamicpropertyassociation_inheritancestate |
InheritanceState Choices/Options
Value | Label |
---|---|
0 | Inherited |
1 | Overridden |
2 | Owned |
Name
Property | Value |
---|---|
Description | name |
DisplayName | name |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | name |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 100 |
OverriddenCreatedOn
Property | Value |
---|---|
Description | Date and time that the record was migrated. |
DisplayName | Record Created On |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | overriddencreatedon |
RequiredLevel | None |
Type | DateTime |
CanChangeDateTimeBehavior | False |
DateTimeBehavior | UserLocal |
Format | DateOnly |
ImeMode | Inactive |
SourceTypeMask | 0 |
RegardingObjectid
Property | Value |
---|---|
Description | Shows the object that the property is associated with. |
DisplayName | Regarding |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | regardingobjectid |
RequiredLevel | SystemRequired |
Type | Lookup |
Targets | product, productassociation |
RegardingObjectTypeCode
Property | Value |
---|---|
Description | |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | regardingobjecttypecode |
RequiredLevel | None |
Type | EntityName |
TimeZoneRuleVersionNumber
Property | Value |
---|---|
Description | For internal use only. |
DisplayName | Time Zone Rule Version Number |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | timezoneruleversionnumber |
RequiredLevel | None |
Type | Integer |
MaxValue | 2147483647 |
MinValue | -1 |
TransactionCurrencyId
Property | Value |
---|---|
Description | Shows the currency associated with the record. |
DisplayName | Currency |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | transactioncurrencyid |
RequiredLevel | None |
Type | Lookup |
Targets | transactioncurrency |
UTCConversionTimeZoneCode
Property | Value |
---|---|
Description | Time zone code that was in use when the record was created. |
DisplayName | UTC Conversion Time Zone Code |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | utcconversiontimezonecode |
RequiredLevel | None |
Type | Integer |
MaxValue | 2147483647 |
MinValue | -1 |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.
- CreatedBy
- CreatedOn
- CreatedOnBehalfBy
- ExchangeRate
- ModifiedBy
- ModifiedOn
- ModifiedOnBehalfBy
- OrganizationId
- VersionNumber
CreatedBy
Property | Value |
---|---|
Description | Unique identifier of the user who created the record. |
DisplayName | Created By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdby |
RequiredLevel | None |
Type | Lookup |
Targets | systemuser |
CreatedOn
Property | Value |
---|---|
Description | Date and time when the record was created. |
DisplayName | Created On |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdon |
RequiredLevel | None |
Type | DateTime |
CanChangeDateTimeBehavior | False |
DateTimeBehavior | UserLocal |
Format | DateAndTime |
ImeMode | Inactive |
SourceTypeMask | 0 |
CreatedOnBehalfBy
Property | Value |
---|---|
Description | Unique identifier of the delegate user who created the record. |
DisplayName | Created By (Delegate) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdonbehalfby |
RequiredLevel | None |
Type | Lookup |
Targets | systemuser |
ExchangeRate
Property | Value |
---|---|
Description | Shows the conversion rate of the record's currency. The exchange rate is used to convert all money fields in the record from the local currency to the system's default currency. |
DisplayName | Exchange Rate |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | exchangerate |
RequiredLevel | None |
Type | Decimal |
ImeMode | Disabled |
MaxValue | 100000000000 |
MinValue | 1E-12 |
Precision | 12 |
SourceTypeMask | 0 |
ModifiedBy
Property | Value |
---|---|
Description | Unique identifier of the user who modified the record. |
DisplayName | Modified By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedby |
RequiredLevel | None |
Type | Lookup |
Targets | systemuser |
ModifiedOn
Property | Value |
---|---|
Description | Date and time when the record was modified. |
DisplayName | Modified On |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedon |
RequiredLevel | None |
Type | DateTime |
CanChangeDateTimeBehavior | False |
DateTimeBehavior | UserLocal |
Format | DateAndTime |
ImeMode | Inactive |
SourceTypeMask | 0 |
ModifiedOnBehalfBy
Property | Value |
---|---|
Description | Unique identifier of the delegate user who modified the record. |
DisplayName | Modified By (Delegate) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedonbehalfby |
RequiredLevel | None |
Type | Lookup |
Targets | systemuser |
OrganizationId
Property | Value |
---|---|
Description | Unique identifier for the organization |
DisplayName | Organization Id |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | organizationid |
RequiredLevel | SystemRequired |
Type | Lookup |
Targets | organization |
VersionNumber
Property | Value |
---|---|
Description | Version Number |
DisplayName | Version Number |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | versionnumber |
RequiredLevel | None |
Type | BigInt |
MaxValue | 9223372036854775807 |
MinValue | -9223372036854775808 |
Many-to-One relationships
These relationships are many-to-one. Listed by SchemaName.
- Dynamicproperty_DynamicPropertyAssociation
- DynamicPropertyAssociation_organization
- DynamicPropertyAssociation_TransactionCurrency
- lk_DynamicPropertyAssociationattribute_createdby
- lk_DynamicPropertyAssociationattribute_CreatedOnBehalfBy
- lk_DynamicPropertyAssociationattribute_ModifiedBy
- lk_DynamicPropertyAssociationattribute_ModifiedOnBehalfBy
- Product_DynamicPropertyAssociation
- ProductAssociation_DynamicPropertyAssociation
Dynamicproperty_DynamicPropertyAssociation
One-To-Many Relationship: dynamicproperty Dynamicproperty_DynamicPropertyAssociation
Property | Value |
---|---|
ReferencedEntity | dynamicproperty |
ReferencedAttribute | dynamicpropertyid |
ReferencingAttribute | dynamicpropertyid |
ReferencingEntityNavigationPropertyName | dynamicpropertyid |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
DynamicPropertyAssociation_organization
One-To-Many Relationship: organization DynamicPropertyAssociation_organization
Property | Value |
---|---|
ReferencedEntity | organization |
ReferencedAttribute | organizationid |
ReferencingAttribute | organizationid |
ReferencingEntityNavigationPropertyName | organizationid |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
DynamicPropertyAssociation_TransactionCurrency
One-To-Many Relationship: transactioncurrency DynamicPropertyAssociation_TransactionCurrency
Property | Value |
---|---|
ReferencedEntity | transactioncurrency |
ReferencedAttribute | transactioncurrencyid |
ReferencingAttribute | transactioncurrencyid |
ReferencingEntityNavigationPropertyName | transactioncurrencyid |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
lk_DynamicPropertyAssociationattribute_createdby
One-To-Many Relationship: systemuser lk_DynamicPropertyAssociationattribute_createdby
Property | Value |
---|---|
ReferencedEntity | systemuser |
ReferencedAttribute | systemuserid |
ReferencingAttribute | createdby |
ReferencingEntityNavigationPropertyName | createdby |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
lk_DynamicPropertyAssociationattribute_CreatedOnBehalfBy
One-To-Many Relationship: systemuser lk_DynamicPropertyAssociationattribute_CreatedOnBehalfBy
Property | Value |
---|---|
ReferencedEntity | systemuser |
ReferencedAttribute | systemuserid |
ReferencingAttribute | createdonbehalfby |
ReferencingEntityNavigationPropertyName | createdonbehalfby |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
lk_DynamicPropertyAssociationattribute_ModifiedBy
One-To-Many Relationship: systemuser lk_DynamicPropertyAssociationattribute_ModifiedBy
Property | Value |
---|---|
ReferencedEntity | systemuser |
ReferencedAttribute | systemuserid |
ReferencingAttribute | modifiedby |
ReferencingEntityNavigationPropertyName | modifiedby |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
lk_DynamicPropertyAssociationattribute_ModifiedOnBehalfBy
One-To-Many Relationship: systemuser lk_DynamicPropertyAssociationattribute_ModifiedOnBehalfBy
Property | Value |
---|---|
ReferencedEntity | systemuser |
ReferencedAttribute | systemuserid |
ReferencingAttribute | modifiedonbehalfby |
ReferencingEntityNavigationPropertyName | modifiedonbehalfby |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
Product_DynamicPropertyAssociation
One-To-Many Relationship: product Product_DynamicPropertyAssociation
Property | Value |
---|---|
ReferencedEntity | product |
ReferencedAttribute | productid |
ReferencingAttribute | regardingobjectid |
ReferencingEntityNavigationPropertyName | regardingobjectid_product |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
ProductAssociation_DynamicPropertyAssociation
One-To-Many Relationship: productassociation ProductAssociation_DynamicPropertyAssociation
Property | Value |
---|---|
ReferencedEntity | productassociation |
ReferencedAttribute | productassociationid |
ReferencingAttribute | regardingobjectid |
ReferencingEntityNavigationPropertyName | regardingobjectid_productassociation |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
One-to-Many relationships
These relationships are one-to-many. Listed by SchemaName.
- dynamicpropertyassociation_AsyncOperations
- dynamicpropertyassociation_BulkDeleteFailures
- dynamicpropertyassociation_MailboxTrackingFolders
- dynamicpropertyassociation_PrincipalObjectAttributeAccesses
- dynamicpropertyassociation_SyncErrors
dynamicpropertyassociation_AsyncOperations
Many-To-One Relationship: asyncoperation dynamicpropertyassociation_AsyncOperations
Property | Value |
---|---|
ReferencingEntity | asyncoperation |
ReferencingAttribute | regardingobjectid |
ReferencedEntityNavigationPropertyName | dynamicpropertyassociation_AsyncOperations |
IsCustomizable | True |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
dynamicpropertyassociation_BulkDeleteFailures
Many-To-One Relationship: bulkdeletefailure dynamicpropertyassociation_BulkDeleteFailures
Property | Value |
---|---|
ReferencingEntity | bulkdeletefailure |
ReferencingAttribute | regardingobjectid |
ReferencedEntityNavigationPropertyName | dynamicpropertyassociation_BulkDeleteFailures |
IsCustomizable | True |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
dynamicpropertyassociation_MailboxTrackingFolders
Many-To-One Relationship: mailboxtrackingfolder dynamicpropertyassociation_MailboxTrackingFolders
Property | Value |
---|---|
ReferencingEntity | mailboxtrackingfolder |
ReferencingAttribute | regardingobjectid |
ReferencedEntityNavigationPropertyName | dynamicpropertyassociation_MailboxTrackingFolders |
IsCustomizable | True |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
dynamicpropertyassociation_PrincipalObjectAttributeAccesses
Many-To-One Relationship: principalobjectattributeaccess dynamicpropertyassociation_PrincipalObjectAttributeAccesses
Property | Value |
---|---|
ReferencingEntity | principalobjectattributeaccess |
ReferencingAttribute | objectid |
ReferencedEntityNavigationPropertyName | dynamicpropertyassociation_PrincipalObjectAttributeAccesses |
IsCustomizable | True |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
dynamicpropertyassociation_SyncErrors
Many-To-One Relationship: syncerror dynamicpropertyassociation_SyncErrors
Property | Value |
---|---|
ReferencingEntity | syncerror |
ReferencingAttribute | regardingobjectid |
ReferencedEntityNavigationPropertyName | dynamicpropertyassociation_SyncErrors |
IsCustomizable | True |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
See also
Dataverse table/entity reference
Dataverse Web API Reference