List Value Mapping (PickListMapping) table/entity reference
In a data map, maps list values from the source file to Microsoft Dynamics 365.
Messages
The following table lists the messages for the List Value Mapping (PickListMapping) 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 |
---|---|---|
Create Event: False |
POST /picklistmappingsSee Create |
Create records |
Delete Event: False |
DELETE /picklistmappings(picklistmappingid)See Delete |
Delete records |
Retrieve Event: False |
GET /picklistmappings(picklistmappingid)See Retrieve |
Retrieve records |
RetrieveMultiple Event: False |
GET /picklistmappingsSee Query data |
Query data |
Properties
The following table lists selected properties for the List Value Mapping (PickListMapping) table.
Property | Value |
---|---|
DisplayName | List Value Mapping |
DisplayCollectionName | List Value Mappings |
SchemaName | PickListMapping |
CollectionSchemaName | PickListMappings |
EntitySetName | picklistmappings |
LogicalName | picklistmapping |
LogicalCollectionName | picklistmappings |
PrimaryIdAttribute | picklistmappingid |
TableType | Standard |
OwnershipType | None |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
ColumnMappingId
Property | Value |
---|---|
Description | Unique identifier of the column mapping with which this list value mapping is associated. |
DisplayName | Column Mapping Id |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | columnmappingid |
RequiredLevel | ApplicationRequired |
Type | Lookup |
Targets | columnmapping |
IntroducedVersion
Property | Value |
---|---|
Description | Version in which the component is introduced. |
DisplayName | Introduced Version |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | introducedversion |
RequiredLevel | None |
Type | String |
Format | VersionNumber |
FormatName | VersionNumber |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 48 |
PickListMappingId
Property | Value |
---|---|
Description | Unique identifier of the picklist mapping. |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | picklistmappingid |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
ProcessCode
Property | Value |
---|---|
Description | Information about whether the list value mapping needs to be processed. |
DisplayName | Process Code |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | processcode |
RequiredLevel | SystemRequired |
Type | Picklist |
DefaultFormValue | -1 |
GlobalChoiceName | picklistmapping_processcode |
ProcessCode Choices/Options
Value | Label |
---|---|
1 | Process |
2 | Ignore |
3 | Internal |
4 | Unmapped |
SourceValue
Property | Value |
---|---|
Description | Source value to be replaced. |
DisplayName | Source Value |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | sourcevalue |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 2097152 |
StatusCode
Property | Value |
---|---|
Description | Reason for the status of the picklist mapping. |
DisplayName | Status Reason |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statuscode |
RequiredLevel | SystemRequired |
Type | Status |
DefaultFormValue | -1 |
GlobalChoiceName | picklistmapping_statuscode |
StatusCode Choices/Options
Value | Details |
---|---|
0 | Label: Active State:0 TransitionData: None |
TargetValue
Property | Value |
---|---|
Description | Microsoft Dynamics 365 list value with which to replace the source value. |
DisplayName | Target Value |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | targetvalue |
RequiredLevel | None |
Type | Integer |
MaxValue | 2147483647 |
MinValue | -2147483648 |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.
- ComponentState
- CreatedBy
- CreatedOn
- CreatedOnBehalfBy
- IsManaged
- ModifiedBy
- ModifiedOn
- ModifiedOnBehalfBy
- OverwriteTime
- PickListMappingIdUnique
- SolutionId
- StateCode
- SupportingSolutionId
ComponentState
Property | Value |
---|---|
Description | For internal use only. |
DisplayName | Component State |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | componentstate |
RequiredLevel | SystemRequired |
Type | Picklist |
DefaultFormValue | -1 |
GlobalChoiceName | componentstate |
ComponentState Choices/Options
Value | Label |
---|---|
0 | Published |
1 | Unpublished |
2 | Deleted |
3 | Deleted Unpublished |
CreatedBy
Property | Value |
---|---|
Description | Unique identifier of the user who created the list value mapping. |
DisplayName | Created By |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdby |
RequiredLevel | None |
Type | Lookup |
Targets | systemuser |
CreatedOn
Property | Value |
---|---|
Description | Date and time when the list value mapping was created. |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdon |
RequiredLevel | SystemRequired |
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 picklistmapping. |
DisplayName | Created By (Delegate) |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfby |
RequiredLevel | None |
Type | Lookup |
Targets | systemuser |
IsManaged
Property | Value |
---|---|
Description | Information that specifies whether this component is managed. |
DisplayName | State |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | ismanaged |
RequiredLevel | SystemRequired |
Type | Boolean |
GlobalChoiceName | ismanaged |
DefaultValue | False |
True Label | Managed |
False Label | Unmanaged |
ModifiedBy
Property | Value |
---|---|
Description | Unique identifier of the user who last modified the list value mapping. |
DisplayName | Modified By |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedby |
RequiredLevel | None |
Type | Lookup |
Targets | systemuser |
ModifiedOn
Property | Value |
---|---|
Description | Date and time when the list value mapping was last modified. |
DisplayName | Modified On |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedon |
RequiredLevel | SystemRequired |
Type | DateTime |
CanChangeDateTimeBehavior | False |
DateTimeBehavior | UserLocal |
Format | DateAndTime |
ImeMode | Inactive |
SourceTypeMask | 0 |
ModifiedOnBehalfBy
Property | Value |
---|---|
Description | Unique identifier of the delegate user who last modified the picklistmapping. |
DisplayName | Modified By (Delegate) |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfby |
RequiredLevel | None |
Type | Lookup |
Targets | systemuser |
OverwriteTime
Property | Value |
---|---|
Description | For internal use only. |
DisplayName | Record Overwrite Time |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | overwritetime |
RequiredLevel | SystemRequired |
Type | DateTime |
CanChangeDateTimeBehavior | False |
DateTimeBehavior | UserLocal |
Format | DateOnly |
ImeMode | Inactive |
SourceTypeMask | 0 |
PickListMappingIdUnique
Property | Value |
---|---|
Description | Unique identifier of the Pick List Mapping. |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | picklistmappingidunique |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
SolutionId
Property | Value |
---|---|
Description | Unique identifier of the associated solution. |
DisplayName | Solution |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | solutionid |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
StateCode
Property | Value |
---|---|
Description | Status of the picklist mapping. |
DisplayName | Status |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statecode |
RequiredLevel | SystemRequired |
Type | State |
DefaultFormValue | 0 |
GlobalChoiceName | picklistmapping_statecode |
StateCode Choices/Options
Value | Details |
---|---|
0 | Label: Active DefaultStatus: 0 InvariantName: Active |
SupportingSolutionId
Property | Value |
---|---|
Description | For internal use only. |
DisplayName | Solution |
IsValidForForm | False |
IsValidForRead | False |
LogicalName | supportingsolutionid |
RequiredLevel | None |
Type | Uniqueidentifier |
Many-to-One relationships
These relationships are many-to-one. Listed by SchemaName.
- lk_picklistmapping_createdby
- lk_picklistmapping_createdonbehalfby
- lk_picklistmapping_modifiedby
- lk_picklistmapping_modifiedonbehalfby
- PickListMapping_ColumnMapping
lk_picklistmapping_createdby
One-To-Many Relationship: systemuser lk_picklistmapping_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_picklistmapping_createdonbehalfby
One-To-Many Relationship: systemuser lk_picklistmapping_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_picklistmapping_modifiedby
One-To-Many Relationship: systemuser lk_picklistmapping_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_picklistmapping_modifiedonbehalfby
One-To-Many Relationship: systemuser lk_picklistmapping_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 |
PickListMapping_ColumnMapping
One-To-Many Relationship: columnmapping PickListMapping_ColumnMapping
Property | Value |
---|---|
ReferencedEntity | columnmapping |
ReferencedAttribute | columnmappingid |
ReferencingAttribute | columnmappingid |
ReferencingEntityNavigationPropertyName | columnmappingid |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
See also
Dataverse table/entity reference
Dataverse Web API Reference
picklistmapping