LookUpMapping Entity Reference

Article
02/16/2022
5 minutes de lecture

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

Messages

Message	Web API Operation	SDK Assembly
Create	POST [org URI]/api/data/v9.0/lookupmappings See Create	CreateRequest or Create
Delete	DELETE [org URI]/api/data/v9.0/lookupmappings(lookupmappingid) See Delete	DeleteRequest or Delete
Retrieve	GET [org URI]/api/data/v9.0/lookupmappings(lookupmappingid) See Retrieve	RetrieveRequest or Retrieve
RetrieveMultiple	GET [org URI]/api/data/v9.0/lookupmappings See Query Data	RetrieveMultipleRequest or RetrieveMultiple

Entity 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
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
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 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

ProcessCode 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

StatusCode Options

Value	Label	State
0	Active	0

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
Targets	transformationparametermapping
Type	Lookup

Read-only attributes

These attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.

ColumnMappingIdName
ComponentState
CreatedBy
CreatedByName
CreatedByYomiName
CreatedOn
CreatedOnBehalfBy
CreatedOnBehalfByName
CreatedOnBehalfByYomiName
IsManaged
LookUpMappingIdUnique
ModifiedBy
ModifiedByName
ModifiedByYomiName
ModifiedOn
ModifiedOnBehalfBy
ModifiedOnBehalfByName
ModifiedOnBehalfByYomiName
OverwriteTime
SolutionId
StateCode
SupportingSolutionId

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 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
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 Options

Value	Label
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 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
lk_lookupmapping_createdonbehalfby
LookUpMapping_ColumnMapping
lk_lookupmapping_modifiedby
LookUpMapping_TransformationParameterMapping
lk_lookupmapping_modifiedonbehalfby

lk_lookupmapping_createdby

See systemuser Entity lk_lookupmapping_createdby One-To-Many relationship.

lk_lookupmapping_createdonbehalfby

See systemuser Entity lk_lookupmapping_createdonbehalfby One-To-Many relationship.

LookUpMapping_ColumnMapping

See columnmapping Entity LookUpMapping_ColumnMapping One-To-Many relationship.

lk_lookupmapping_modifiedby

See systemuser Entity lk_lookupmapping_modifiedby One-To-Many relationship.

LookUpMapping_TransformationParameterMapping

See transformationparametermapping Entity LookUpMapping_TransformationParameterMapping One-To-Many relationship.

lk_lookupmapping_modifiedonbehalfby

See systemuser Entity lk_lookupmapping_modifiedonbehalfby One-To-Many relationship.