Edit

Share via

Lookup Mapping (LookUpMapping) table/entity reference (Microsoft Dataverse)

In a data map, maps a lookup attribute in a source file to Microsoft Dynamics 365.

Messages

The following table lists the messages for the Lookup Mapping (LookUpMapping) 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 /lookupmappings
See Create		 Create records
Delete
Event: False		 DELETE /lookupmappings(lookupmappingid)
See Delete		 Delete records
Disassociate
Event: True		 Disassociate records Disassociate records
Retrieve
Event: False		 GET /lookupmappings(lookupmappingid)
See Retrieve		 Retrieve records
RetrieveMultiple
Event: False		 GET /lookupmappings
See Query data		 Query data

Properties

The following table lists selected properties for the Lookup Mapping (LookUpMapping) table.

Property Value
DisplayName Lookup Mapping
DisplayCollectionName Lookup Mappings
SchemaName LookUpMapping
CollectionSchemaName LookUpMappings
EntitySetName lookupmappings
LogicalName lookupmapping
LogicalCollectionName lookupmappings
PrimaryIdAttribute lookupmappingid
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 lookup mapping is associated.
DisplayName Column Mapping Id
IsValidForForm True
IsValidForRead True
LogicalName columnmappingid
RequiredLevel None
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

LookUpAttributeName

Property Value
Description Name of the field with which the lookup is associated.
DisplayName Lookup Field Name
IsValidForForm True
IsValidForRead True
LogicalName lookupattributename
RequiredLevel ApplicationRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 160

LookUpEntityName

Property Value
Description Name of the entity with which the lookup is associated.
DisplayName Lookup Entity Name
IsValidForForm True
IsValidForRead True
LogicalName lookupentityname
RequiredLevel ApplicationRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 160

LookUpMappingId

Property Value
Description Unique identifier of the lookup mapping.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName lookupmappingid
RequiredLevel SystemRequired
Type Uniqueidentifier

LookUpSourceCode

Property Value
Description Lookup source code for lookup mapping.
DisplayName Lookup Source
IsValidForForm True
IsValidForRead True
LogicalName lookupsourcecode
RequiredLevel SystemRequired
Type Picklist
DefaultFormValue -1
GlobalChoiceName lookupmapping_lookupsourcecode

LookUpSourceCode Choices/Options

Value Label
0 Source
1 System

ProcessCode

Property Value
Description Information about whether the lookup mapping has to be processed.
DisplayName Process Code
IsValidForForm True
IsValidForRead True
LogicalName processcode
RequiredLevel SystemRequired
Type Picklist
DefaultFormValue -1
GlobalChoiceName lookupmapping_processcode

ProcessCode Choices/Options

Value Label
1 Process
2 Ignore
3 Internal

StatusCode

Property Value
Description Reason for the status of the lookup mapping.
DisplayName Status Reason
IsValidForForm True
IsValidForRead True
LogicalName statuscode
RequiredLevel SystemRequired
Type Status
DefaultFormValue -1
GlobalChoiceName lookupmapping_statuscode

StatusCode Choices/Options

Value Details
0 Label: Active
State:0
TransitionData: None

TransformationParameterMappingId

Property Value
Description Unique identifier of the transformation parameter mapping with which this lookup mapping is associated.
DisplayName Transformation Parameter Mapping Id
IsValidForForm True
IsValidForRead True
LogicalName transformationparametermappingid
RequiredLevel None
Type Lookup
Targets transformationparametermapping

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 lookup 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 lookup 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 lookupmapping.
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

LookUpMappingIdUnique

Property Value
Description Unique identifier of the LookUp Mapping.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName lookupmappingidunique
RequiredLevel SystemRequired
Type Uniqueidentifier

ModifiedBy

Property Value
Description Unique identifier of the user who last modified the lookup 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 lookup 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 lookupmapping.
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

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 lookup mapping.
DisplayName Status
IsValidForForm True
IsValidForRead True
LogicalName statecode
RequiredLevel SystemRequired
Type State
DefaultFormValue 0
GlobalChoiceName lookupmapping_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_lookupmapping_createdby

One-To-Many Relationship: systemuser lk_lookupmapping_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_lookupmapping_createdonbehalfby

One-To-Many Relationship: systemuser lk_lookupmapping_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_lookupmapping_modifiedby

One-To-Many Relationship: systemuser lk_lookupmapping_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_lookupmapping_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_lookupmapping_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

LookUpMapping_ColumnMapping

One-To-Many Relationship: columnmapping LookUpMapping_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

LookUpMapping_TransformationParameterMapping

One-To-Many Relationship: transformationparametermapping LookUpMapping_TransformationParameterMapping

Property Value
ReferencedEntity transformationparametermapping
ReferencedAttribute transformationparametermappingid
ReferencingAttribute transformationparametermappingid
ReferencingEntityNavigationPropertyName transformationparametermappingid
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
lookupmapping