Lookup Mapping (LookUpMapping) table/entity reference

Article
08/31/2024

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
`Create` Event: False	`POST` /lookupmappings See Create	Create records
`Delete` Event: False	`DELETE` /lookupmappings(lookupmappingid) See Delete	Delete 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
IntroducedVersion
LookUpAttributeName
LookUpEntityName
LookUpMappingId
LookUpSourceCode
ProcessCode
StatusCode
TransformationParameterMappingId

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
CreatedBy
CreatedOn
CreatedOnBehalfBy
IsManaged
LookUpMappingIdUnique
ModifiedBy
ModifiedOn
ModifiedOnBehalfBy
OverwriteTime
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 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
lk_lookupmapping_createdonbehalfby
lk_lookupmapping_modifiedby
lk_lookupmapping_modifiedonbehalfby
LookUpMapping_ColumnMapping
LookUpMapping_TransformationParameterMapping

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`

Share via