Edit

Share via

List Value Mapping (PickListMapping) table/entity reference (Microsoft Dataverse)

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
Associate
Event: True		 Associate records Associate records
Create
Event: False		 POST /picklistmappings
See Create		 Create records
Delete
Event: False		 DELETE /picklistmappings(picklistmappingid)
See Delete		 Delete records
Disassociate
Event: True		 Disassociate records Disassociate records
Retrieve
Event: False		 GET /picklistmappings(picklistmappingid)
See Retrieve		 Retrieve records
RetrieveMultiple
Event: False		 GET /picklistmappings
See 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

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

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