LookUpMapping entity reference
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 attributes
These 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 attributes
These 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: 0
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 entity. Listed by SchemaName.
lk_lookupmapping_createdby
See the lk_lookupmapping_createdby one-to-many relationship for the systemuser entity.
lk_lookupmapping_createdonbehalfby
See the lk_lookupmapping_createdonbehalfby one-to-many relationship for the systemuser entity.
LookUpMapping_ColumnMapping
See the LookUpMapping_ColumnMapping one-to-many relationship for the columnmapping entity.
lk_lookupmapping_modifiedby
See the lk_lookupmapping_modifiedby one-to-many relationship for the systemuser entity.
See the LookUpMapping_TransformationParameterMapping one-to-many relationship for the transformationparametermapping entity.
lk_lookupmapping_modifiedonbehalfby
See the lk_lookupmapping_modifiedonbehalfby one-to-many relationship for the systemuser entity.
See also
About the Entity Reference
Web API EntityType Reference