LookUpMapping table/entity reference
-
Article
-
- 2 minutes to read
-
In a data map, maps a lookup attribute in a source file to Microsoft Dynamics 365.
Messages
Properties
| Property |
Value |
| CollectionSchemaName |
LookUpMappings |
| DisplayCollectionName |
Lookup Mappings |
| DisplayName |
Lookup Mapping |
| EntitySetName |
lookupmappings |
| IsBPFEntity |
False |
| LogicalCollectionName |
lookupmappings |
| LogicalName |
lookupmapping |
| OwnershipType |
None |
| PrimaryIdAttribute |
lookupmappingid |
| PrimaryNameAttribute |
|
| SchemaName |
LookUpMapping |
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 |
| Targets |
columnmapping |
| Type |
Lookup |
IntroducedVersion
| Property |
Value |
| Description |
Version in which the component is introduced. |
| DisplayName |
Introduced Version |
| FormatName |
VersionNumber |
| IsLocalizable |
False |
| IsValidForForm |
False |
| IsValidForRead |
True |
| IsValidForUpdate |
False |
| LogicalName |
introducedversion |
| MaxLength |
48 |
| RequiredLevel |
None |
| Type |
String |
LookUpAttributeName
| Property |
Value |
| Description |
Name of the field with which the lookup is associated. |
| DisplayName |
Lookup Field Name |
| FormatName |
Text |
| IsLocalizable |
False |
| IsValidForForm |
True |
| IsValidForRead |
True |
| LogicalName |
lookupattributename |
| MaxLength |
160 |
| RequiredLevel |
ApplicationRequired |
| Type |
String |
LookUpEntityName
| Property |
Value |
| Description |
Name of the entity with which the lookup is associated. |
| DisplayName |
Lookup Entity Name |
| FormatName |
Text |
| IsLocalizable |
False |
| IsValidForForm |
True |
| IsValidForRead |
True |
| LogicalName |
lookupentityname |
| MaxLength |
160 |
| RequiredLevel |
ApplicationRequired |
| Type |
String |
LookUpMappingId
| Property |
Value |
| Description |
Unique identifier of the lookup mapping. |
| DisplayName |
|
| IsValidForForm |
False |
| IsValidForRead |
True |
| IsValidForUpdate |
False |
| 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 |
LookUpSourceCode Choices/Options
| Value |
Label |
Description |
| 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 |
ProcessCode Choices/Options
| Value |
Label |
Description |
| 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 |
StatusCode Choices/Options
| Value |
Label |
State |
| 0 |
Active |
0 |
| 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 |
| Targets |
transformationparametermapping |
| Type |
Lookup |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.
ColumnMappingIdName
| Property |
Value |
| Description |
Name of the column mapping. |
| DisplayName |
|
| FormatName |
Text |
| IsLocalizable |
False |
| IsValidForForm |
False |
| IsValidForRead |
True |
| LogicalName |
columnmappingidname |
| MaxLength |
100 |
| RequiredLevel |
SystemRequired |
| Type |
String |
ComponentState
| Property |
Value |
| Description |
For internal use only. |
| DisplayName |
Component State |
| IsValidForForm |
False |
| IsValidForRead |
True |
| LogicalName |
componentstate |
| RequiredLevel |
SystemRequired |
| Type |
Picklist |
ComponentState Choices/Options
| Value |
Label |
Description |
| 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 |
| Targets |
systemuser |
| Type |
Lookup |
CreatedByName
| Property |
Value |
| Description |
|
| DisplayName |
|
| FormatName |
Text |
| IsLocalizable |
False |
| IsValidForForm |
False |
| IsValidForRead |
True |
| LogicalName |
createdbyname |
| MaxLength |
100 |
| RequiredLevel |
None |
| Type |
String |
CreatedByYomiName
| Property |
Value |
| Description |
|
| DisplayName |
|
| FormatName |
Text |
| IsLocalizable |
False |
| IsValidForForm |
False |
| IsValidForRead |
True |
| LogicalName |
createdbyyominame |
| MaxLength |
100 |
| RequiredLevel |
None |
| Type |
String |
CreatedOn
| Property |
Value |
| DateTimeBehavior |
UserLocal |
| Description |
Date and time when the lookup mapping was created. |
| DisplayName |
|
| Format |
DateAndTime |
| IsValidForForm |
False |
| IsValidForRead |
True |
| LogicalName |
createdon |
| RequiredLevel |
SystemRequired |
| Type |
DateTime |
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 |
| Targets |
systemuser |
| Type |
Lookup |
CreatedOnBehalfByName
| Property |
Value |
| Description |
|
| DisplayName |
|
| FormatName |
Text |
| IsLocalizable |
False |
| IsValidForForm |
False |
| IsValidForRead |
True |
| LogicalName |
createdonbehalfbyname |
| MaxLength |
100 |
| RequiredLevel |
None |
| Type |
String |
CreatedOnBehalfByYomiName
| Property |
Value |
| Description |
|
| DisplayName |
|
| FormatName |
Text |
| IsLocalizable |
False |
| IsValidForForm |
False |
| IsValidForRead |
True |
| LogicalName |
createdonbehalfbyyominame |
| MaxLength |
100 |
| RequiredLevel |
None |
| Type |
String |
IsManaged
| Property |
Value |
| Description |
Information that specifies whether this component is managed. |
| DisplayName |
State |
| IsValidForForm |
False |
| IsValidForRead |
True |
| LogicalName |
ismanaged |
| RequiredLevel |
SystemRequired |
| Type |
Boolean |
IsManaged Choices/Options
| Value |
Label |
Description |
| 1 |
Managed |
|
| 0 |
Unmanaged |
|
DefaultValue: False
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 |
| Targets |
systemuser |
| Type |
Lookup |
ModifiedByName
| Property |
Value |
| Description |
|
| DisplayName |
|
| FormatName |
Text |
| IsLocalizable |
False |
| IsValidForForm |
False |
| IsValidForRead |
True |
| LogicalName |
modifiedbyname |
| MaxLength |
100 |
| RequiredLevel |
None |
| Type |
String |
ModifiedByYomiName
| Property |
Value |
| Description |
|
| DisplayName |
|
| FormatName |
Text |
| IsLocalizable |
False |
| IsValidForForm |
False |
| IsValidForRead |
True |
| LogicalName |
modifiedbyyominame |
| MaxLength |
100 |
| RequiredLevel |
None |
| Type |
String |
ModifiedOn
| Property |
Value |
| DateTimeBehavior |
UserLocal |
| Description |
Date and time when the lookup mapping was last modified. |
| DisplayName |
Modified On |
| Format |
DateAndTime |
| IsValidForForm |
True |
| IsValidForRead |
True |
| LogicalName |
modifiedon |
| RequiredLevel |
SystemRequired |
| Type |
DateTime |
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 |
| Targets |
systemuser |
| Type |
Lookup |
ModifiedOnBehalfByName
| Property |
Value |
| Description |
|
| DisplayName |
|
| FormatName |
Text |
| IsLocalizable |
False |
| IsValidForForm |
False |
| IsValidForRead |
True |
| LogicalName |
modifiedonbehalfbyname |
| MaxLength |
100 |
| RequiredLevel |
None |
| Type |
String |
ModifiedOnBehalfByYomiName
| Property |
Value |
| Description |
|
| DisplayName |
|
| FormatName |
Text |
| IsLocalizable |
False |
| IsValidForForm |
False |
| IsValidForRead |
True |
| LogicalName |
modifiedonbehalfbyyominame |
| MaxLength |
100 |
| RequiredLevel |
None |
| Type |
String |
OverwriteTime
| Property |
Value |
| DateTimeBehavior |
UserLocal |
| Description |
For internal use only. |
| DisplayName |
Record Overwrite Time |
| Format |
DateOnly |
| IsValidForForm |
False |
| IsValidForRead |
True |
| LogicalName |
overwritetime |
| RequiredLevel |
SystemRequired |
| Type |
DateTime |
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 |
StateCode Choices/Options
| Value |
Label |
DefaultStatus |
InvariantName |
| 0 |
Active |
0 |
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
Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.
lk_lookupmapping_createdby
See systemuser Table lk_lookupmapping_createdby One-To-Many relationship.
lk_lookupmapping_createdonbehalfby
See systemuser Table lk_lookupmapping_createdonbehalfby One-To-Many relationship.
LookUpMapping_ColumnMapping
See columnmapping Table LookUpMapping_ColumnMapping One-To-Many relationship.
lk_lookupmapping_modifiedby
See systemuser Table lk_lookupmapping_modifiedby One-To-Many relationship.
See transformationparametermapping Table LookUpMapping_TransformationParameterMapping One-To-Many relationship.
lk_lookupmapping_modifiedonbehalfby
See systemuser Table lk_lookupmapping_modifiedonbehalfby One-To-Many relationship.
See also
About the table reference
Web API Reference
lookupmapping EntityType