Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Item with a name and value in a property option set type.
Messages
The following table lists the messages for the Property Option Set Item (DynamicPropertyOptionSetItem) 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 |
|---|---|---|
AssociateEvent: True |
Associate records | Associate records |
CreateEvent: False |
POST /dynamicpropertyoptionsetitemsSee Create |
Create records |
CreateMultipleEvent: True |
CreateMultiple | CreateMultipleRequest |
DeleteEvent: False |
DELETE /dynamicpropertyoptionsetitems(dynamicpropertyoptionsetvalueid)See Delete |
Delete records |
DisassociateEvent: True |
Disassociate records | Disassociate records |
RetrieveEvent: False |
GET /dynamicpropertyoptionsetitems(dynamicpropertyoptionsetvalueid)See Retrieve |
Retrieve records |
RetrieveMultipleEvent: True |
GET /dynamicpropertyoptionsetitemsSee Query data |
Query data |
UpdateEvent: False |
PATCH /dynamicpropertyoptionsetitems(dynamicpropertyoptionsetvalueid)See Update |
Update records |
UpdateMultipleEvent: True |
UpdateMultiple | UpdateMultipleRequest |
UpsertEvent: False |
PATCH /dynamicpropertyoptionsetitems(dynamicpropertyoptionsetvalueid)See Upsert a table row |
UpsertRequest |
UpsertMultipleEvent: False |
UpsertMultiple | UpsertMultipleRequest |
Properties
The following table lists selected properties for the Property Option Set Item (DynamicPropertyOptionSetItem) table.
| Property | Value |
|---|---|
| DisplayName | Property Option Set Item |
| DisplayCollectionName | Property Option Set Items |
| SchemaName | DynamicPropertyOptionSetItem |
| CollectionSchemaName | DynamicPropertyOptionSetItems |
| EntitySetName | dynamicpropertyoptionsetitems |
| LogicalName | dynamicpropertyoptionsetitem |
| LogicalCollectionName | dynamicpropertyoptionsetitems |
| PrimaryIdAttribute | dynamicpropertyoptionsetvalueid |
| PrimaryNameAttribute | dynamicpropertyoptionname |
| TableType | Standard |
| OwnershipType | OrganizationOwned |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- DMTImportState
- DynamicPropertyId
- DynamicPropertyOptionDescription
- DynamicPropertyOptionName
- DynamicPropertyOptionSetValueId
- DynamicPropertyOptionSetValueSequenceNumber
- DynamicPropertyOptionValue
- ImportSequenceNumber
- OverriddenCreatedOn
- TimeZoneRuleVersionNumber
- TransactionCurrencyId
- UTCConversionTimeZoneCode
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 |
DynamicPropertyId
| Property | Value |
|---|---|
| Description | Shows the property that uses this option set item. |
| DisplayName | Property ID |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | dynamicpropertyid |
| RequiredLevel | ApplicationRequired |
| Type | Lookup |
| Targets | dynamicproperty |
DynamicPropertyOptionDescription
| Property | Value |
|---|---|
| Description | Type additional information about the property option set item. |
| DisplayName | Description |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | dynamicpropertyoptiondescription |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | True |
| MaxLength | 100 |
DynamicPropertyOptionName
| Property | Value |
|---|---|
| Description | Type the name of the property option set item. |
| DisplayName | Name |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | dynamicpropertyoptionname |
| RequiredLevel | SystemRequired |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | True |
| MaxLength | 100 |
DynamicPropertyOptionSetValueId
| Property | Value |
|---|---|
| Description | Shows the unique identifier of the property option set item. |
| DisplayName | Property Option Set ID |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | dynamicpropertyoptionsetvalueid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
DynamicPropertyOptionSetValueSequenceNumber
| Property | Value |
|---|---|
| Description | Internal Use Only |
| DisplayName | Internal Use Only |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | dynamicpropertyoptionsetvaluesequencenumber |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
DynamicPropertyOptionValue
| Property | Value |
|---|---|
| Description | Shows the value of the property option set item. |
| DisplayName | Value |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | dynamicpropertyoptionvalue |
| RequiredLevel | SystemRequired |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | 0 |
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 |
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 |
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_DynamicPropertyOptionSetItem
- DynamicPropertyOptionSetItem_organization
- DynamicPropertyOptionSetItem_TransactionCurrency
- lk_DynamicPropertyOptionSetItem_createdby
- lk_DynamicPropertyOptionSetItem_createdonbehalfby
- lk_DynamicPropertyOptionSetItem_modifiedby
- lk_DynamicPropertyOptionSetItem_modifiedonbehalfby
DynamicProperty_DynamicPropertyOptionSetItem
One-To-Many Relationship: dynamicproperty DynamicProperty_DynamicPropertyOptionSetItem
| Property | Value |
|---|---|
| ReferencedEntity | dynamicproperty |
| ReferencedAttribute | dynamicpropertyid |
| ReferencingAttribute | dynamicpropertyid |
| ReferencingEntityNavigationPropertyName | dynamicpropertyid |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: CascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
DynamicPropertyOptionSetItem_organization
One-To-Many Relationship: organization DynamicPropertyOptionSetItem_organization
| Property | Value |
|---|---|
| ReferencedEntity | organization |
| ReferencedAttribute | organizationid |
| ReferencingAttribute | organizationid |
| ReferencingEntityNavigationPropertyName | organizationid |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
DynamicPropertyOptionSetItem_TransactionCurrency
One-To-Many Relationship: transactioncurrency DynamicPropertyOptionSetItem_TransactionCurrency
| Property | Value |
|---|---|
| ReferencedEntity | transactioncurrency |
| ReferencedAttribute | transactioncurrencyid |
| ReferencingAttribute | transactioncurrencyid |
| ReferencingEntityNavigationPropertyName | transactioncurrencyid |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RestrictMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
lk_DynamicPropertyOptionSetItem_createdby
One-To-Many Relationship: systemuser lk_DynamicPropertyOptionSetItem_createdby
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | createdby |
| ReferencingEntityNavigationPropertyName | createdby |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
lk_DynamicPropertyOptionSetItem_createdonbehalfby
One-To-Many Relationship: systemuser lk_DynamicPropertyOptionSetItem_createdonbehalfby
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | createdonbehalfby |
| ReferencingEntityNavigationPropertyName | createdonbehalfby |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
lk_DynamicPropertyOptionSetItem_modifiedby
One-To-Many Relationship: systemuser lk_DynamicPropertyOptionSetItem_modifiedby
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | modifiedby |
| ReferencingEntityNavigationPropertyName | modifiedby |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
lk_DynamicPropertyOptionSetItem_modifiedonbehalfby
One-To-Many Relationship: systemuser lk_DynamicPropertyOptionSetItem_modifiedonbehalfby
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | modifiedonbehalfby |
| ReferencingEntityNavigationPropertyName | modifiedonbehalfby |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
One-to-Many relationships
These relationships are one-to-many. Listed by SchemaName.
- DefaultValueOptionSet_DynamicProperty
- dynamicpropertyoptionsetitem_AsyncOperations
- dynamicpropertyoptionsetitem_BulkDeleteFailures
- dynamicpropertyoptionsetitem_MailboxTrackingFolders
- dynamicpropertyoptionsetitem_PrincipalObjectAttributeAccesses
- dynamicpropertyoptionsetitem_SyncErrors
DefaultValueOptionSet_DynamicProperty
Many-To-One Relationship: dynamicproperty DefaultValueOptionSet_DynamicProperty
| Property | Value |
|---|---|
| ReferencingEntity | dynamicproperty |
| ReferencingAttribute | defaultvalueoptionset |
| ReferencedEntityNavigationPropertyName | DefaultValueOptionSet_DynamicProperty |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
dynamicpropertyoptionsetitem_AsyncOperations
Many-To-One Relationship: asyncoperation dynamicpropertyoptionsetitem_AsyncOperations
| Property | Value |
|---|---|
| ReferencingEntity | asyncoperation |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | dynamicpropertyoptionsetitem_AsyncOperations |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
dynamicpropertyoptionsetitem_BulkDeleteFailures
Many-To-One Relationship: bulkdeletefailure dynamicpropertyoptionsetitem_BulkDeleteFailures
| Property | Value |
|---|---|
| ReferencingEntity | bulkdeletefailure |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | dynamicpropertyoptionsetitem_BulkDeleteFailures |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
dynamicpropertyoptionsetitem_MailboxTrackingFolders
Many-To-One Relationship: mailboxtrackingfolder dynamicpropertyoptionsetitem_MailboxTrackingFolders
| Property | Value |
|---|---|
| ReferencingEntity | mailboxtrackingfolder |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | dynamicpropertyoptionsetitem_MailboxTrackingFolders |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
dynamicpropertyoptionsetitem_PrincipalObjectAttributeAccesses
Many-To-One Relationship: principalobjectattributeaccess dynamicpropertyoptionsetitem_PrincipalObjectAttributeAccesses
| Property | Value |
|---|---|
| ReferencingEntity | principalobjectattributeaccess |
| ReferencingAttribute | objectid |
| ReferencedEntityNavigationPropertyName | dynamicpropertyoptionsetitem_PrincipalObjectAttributeAccesses |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
dynamicpropertyoptionsetitem_SyncErrors
Many-To-One Relationship: syncerror dynamicpropertyoptionsetitem_SyncErrors
| Property | Value |
|---|---|
| ReferencingEntity | syncerror |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | dynamicpropertyoptionsetitem_SyncErrors |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
See also
Dataverse table/entity reference
Dataverse Web API Reference