Référence d’entité/de table LookUpMapping

  • Article

Notes

Vous n’êtes pas sûr de la table par rapport à l’entité ? Voir Développeurs : Comprendre la terminologie dans Microsoft Dataverse.

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

Messages

Message Opération de l'API web Classe ou méthode SDK
Create POST [org URI]/api/data/v9.0/lookupmappings
Voir Créer		 CreateRequest ou
Create
Delete DELETE [org URI]/api/data/v9.0/lookupmappings(lookupmappingid)
Voir Supprimer		 DeleteRequest ou
Delete
Retrieve GET [org URI]/api/data/v9.0/lookupmappings(lookupmappingid)
Voir Récupérer		 RetrieveRequest ou
Retrieve
RetrieveMultiple GET [org URI]/api/data/v9.0/lookupmappings
Voir Rechercher des données		 RetrieveMultipleRequest ou
RetrieveMultiple

Propriétés

Propriété Valeur
CollectionSchemaName LookUpMappings
DisplayCollectionName Lookup Mappings
DisplayName Lookup Mapping
EntitySetName lookupmappings
IsBPFEntity False
LogicalCollectionName lookupmappings
LogicalName lookupmapping
OwnershipType None
PrimaryIdAttribute lookupmappingid
PrimaryNameAttribute
SchemaName LookUpMapping

Colonnes/Attributs inscriptibles

Ces colonnes/attributs renvoient la valeur true pour IsValidForCreate ou IsValidForUpdate (généralement les deux). Répertorié par SchemaName.

ColumnMappingId

Propriété Valeur
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

Propriété Valeur
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

Propriété Valeur
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

Propriété Valeur
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

Propriété Valeur
Description Unique identifier of the lookup mapping.
DisplayName
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName lookupmappingid
RequiredLevel SystemRequired
Type Uniqueidentifier

LookUpSourceCode

Propriété Valeur
Description Lookup source code for lookup mapping.
DisplayName Lookup Source
IsValidForForm True
IsValidForRead True
LogicalName lookupsourcecode
RequiredLevel SystemRequired
Type Picklist

Choix/Options LookUpSourceCode

Valeur Étiquette Description
0 Source
1 System

ProcessCode

Propriété Valeur
Description Information about whether the lookup mapping has to be processed.
DisplayName Process Code
IsValidForForm True
IsValidForRead True
LogicalName processcode
RequiredLevel SystemRequired
Type Picklist

Choix/Options ProcessCode

Valeur Étiquette Description
1 Process
2 Ignore
3 Internal

StatusCode

Propriété Valeur
Description Reason for the status of the lookup mapping.
DisplayName Status Reason
IsValidForForm True
IsValidForRead True
LogicalName statuscode
RequiredLevel SystemRequired
Type Status

Choix/Options StatusCode

Valeur Étiquette État
0 Active 0

TransformationParameterMappingId

Propriété Valeur
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

Colonnes/Attributs en lecture seule

Ces colonnes/attributs renvoient la valeur false pour IsValidForCreate ou IsValidForUpdate. Répertorié par SchemaName.

ColumnMappingIdName

Propriété Valeur
Description Name of the column mapping.
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName columnmappingidname
MaxLength 100
RequiredLevel SystemRequired
Type String

ComponentState

Propriété Valeur
Description For internal use only.
DisplayName Component State
IsValidForForm False
IsValidForRead True
LogicalName componentstate
RequiredLevel SystemRequired
Type Picklist

Choix/Options ComponentState

Valeur Étiquette Description
0 Published
1 Unpublished
2 Deleted
3 Deleted Unpublished

CreatedBy

Propriété Valeur
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

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdbyname
MaxLength 100
RequiredLevel None
Type String

CreatedByYomiName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdbyyominame
MaxLength 100
RequiredLevel None
Type String

CreatedOn

Propriété Valeur
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

Propriété Valeur
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

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdonbehalfbyname
MaxLength 100
RequiredLevel None
Type String

CreatedOnBehalfByYomiName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdonbehalfbyyominame
MaxLength 100
RequiredLevel None
Type String

IsManaged

Propriété Valeur
Description Information that specifies whether this component is managed.
DisplayName State
IsValidForForm False
IsValidForRead True
LogicalName ismanaged
RequiredLevel SystemRequired
Type Boolean

Choix/Options IsManaged

Valeur Étiquette Description
1 Managed
0 Unmanaged

Valeur par défaut : 0

LookUpMappingIdUnique

Propriété Valeur
Description Unique identifier of the LookUp Mapping.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName lookupmappingidunique
RequiredLevel SystemRequired
Type Uniqueidentifier

ModifiedBy

Propriété Valeur
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

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedbyname
MaxLength 100
RequiredLevel None
Type String

ModifiedByYomiName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedbyyominame
MaxLength 100
RequiredLevel None
Type String

ModifiedOn

Propriété Valeur
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

Propriété Valeur
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

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfbyname
MaxLength 100
RequiredLevel None
Type String

ModifiedOnBehalfByYomiName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfbyyominame
MaxLength 100
RequiredLevel None
Type String

OverwriteTime

Propriété Valeur
DateTimeBehavior UserLocal
Description For internal use only.
DisplayName Record Overwrite Time
Format DateOnly
IsValidForForm False
IsValidForRead True
LogicalName overwritetime
RequiredLevel SystemRequired
Type DateTime

SolutionId

Propriété Valeur
Description Unique identifier of the associated solution.
DisplayName Solution
IsValidForForm False
IsValidForRead True
LogicalName solutionid
RequiredLevel SystemRequired
Type Uniqueidentifier

StateCode

Propriété Valeur
Description Status of the lookup mapping.
DisplayName Status
IsValidForForm True
IsValidForRead True
LogicalName statecode
RequiredLevel SystemRequired
Type State

Choix/Options StateCode

Valeur Étiquette Statut par défaut Nom invariant
0 Active 0 Active

SupportingSolutionId

Propriété Valeur
Description For internal use only.
DisplayName Solution
IsValidForForm False
IsValidForRead False
LogicalName supportingsolutionid
RequiredLevel None
Type Uniqueidentifier

Relations plusieurs-à-un

Chaque relation plusieurs-à-un est définie par une relation un-à-plusieurs correspondante avec la table associée. Répertorié par SchemaName.

lk_lookupmapping_createdby

Voir la relation un à plusieurs lk_lookupmapping_createdby pour la table/entité systemuser.

lk_lookupmapping_createdonbehalfby

Voir la relation un à plusieurs lk_lookupmapping_createdonbehalfby pour la table/entité systemuser.

LookUpMapping_ColumnMapping

Voir la relation un à plusieurs LookUpMapping_ColumnMapping pour la table/entité columnmapping.

lk_lookupmapping_modifiedby

Voir la relation un à plusieurs lk_lookupmapping_modifiedby pour la table/entité systemuser.

LookUpMapping_TransformationParameterMapping

Voir la relation un à plusieurs LookUpMapping_TransformationParameterMapping pour la table/entité transformationparametermapping.

lk_lookupmapping_modifiedonbehalfby

Voir la relation un à plusieurs lk_lookupmapping_modifiedonbehalfby pour la table/entité systemuser.

Voir aussi

Référence d’entité/de table Dataverse Référence d’API web lookupmapping EntityType