Referencia de tabla o entidad ColumnMapping

Nota

¿No está seguro de tabla frente a entidad? Vea Desarrolladores: comprender la terminología en Microsoft Dataverse.

Mapping for columns in a data map.

Mensajes

Mensaje	Operación de API web	Método o clase de SDK
Create	POST [org URI]/api/data/v9.0/columnmappings Vea Crear	CreateRequest o Create
Delete	DELETE [org URI]/api/data/v9.0/columnmappings(columnmappingid) Vea Eliminar	DeleteRequest o Delete
Retrieve	GET [org URI]/api/data/v9.0/columnmappings(columnmappingid) Vea Recuperar	RetrieveRequest o Retrieve
RetrieveMultiple	GET [org URI]/api/data/v9.0/columnmappings Vea Consultar datos	RetrieveMultipleRequest o RetrieveMultiple

Propiedades

Propiedad	Valor
CollectionSchemaName	ColumnMappings
DisplayCollectionName	Column Mappings
DisplayName	Column Mapping
EntitySetName	columnmappings
IsBPFEntity	False
LogicalCollectionName	columnmappings
LogicalName	columnmapping
OwnershipType	None
PrimaryIdAttribute	columnmappingid
PrimaryNameAttribute	sourceattributename
SchemaName	ColumnMapping

Columnas/atributos que se pueden escribir

Estas columnas o atributos devuelven true para IsValidForCreate o IsValidForUpdate (generalmente ambos). Listado por SchemaName.

• ColumnMappingId
• ImportMapId
• IntroducedVersion
• ProcessCode
• SourceAttributeName
• SourceEntityName
• StatusCode
• TargetAttributeName
• TargetEntityName

ColumnMappingId

Propiedad	Valor
Description	Unique identifier of the column mapping.
DisplayName
IsValidForForm	False
IsValidForRead	True
IsValidForUpdate	False
LogicalName	columnmappingid
RequiredLevel	SystemRequired
Type	Uniqueidentifier

ImportMapId

Propiedad	Valor
Description	Unique identifier of the associated data map.
DisplayName	Data Map ID
IsValidForForm	True
IsValidForRead	True
LogicalName	importmapid
RequiredLevel	ApplicationRequired
Targets	importmap
Type	Lookup

IntroducedVersion

Propiedad	Valor
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

ProcessCode

Propiedad	Valor
Description	Information about whether the column mapping needs to be processed.
DisplayName	Process Code
IsValidForForm	True
IsValidForRead	True
LogicalName	processcode
RequiredLevel	SystemRequired
Type	Picklist

Elecciones/opciones de ProcessCode

Valor	Etiqueta	Descripción
1	Process
2	Ignore
3	Internal

SourceAttributeName

Propiedad	Valor
Description	Name of the source attribute.
DisplayName	Source Attribute
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	sourceattributename
MaxLength	160
RequiredLevel	ApplicationRequired
Type	String

SourceEntityName

Propiedad	Valor
Description	Name of the source entity.
DisplayName	Source Entity Name
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	sourceentityname
MaxLength	160
RequiredLevel	ApplicationRequired
Type	String

StatusCode

Propiedad	Valor
Description	Reason for the status of the column mapping.
DisplayName	Status Reason
IsValidForForm	True
IsValidForRead	True
LogicalName	statuscode
RequiredLevel	SystemRequired
Type	Status

Elecciones/opciones de StatusCode

Valor	Etiqueta	Estado
1	Active	0

TargetAttributeName

Propiedad	Valor
Description	Name of the Microsoft Dynamics 365 attribute.
DisplayName	Target Attribute
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	targetattributename
MaxLength	160
RequiredLevel	None
Type	String

TargetEntityName

Propiedad	Valor
Description	Name of the Microsoft Dynamics 365 entity.
DisplayName	Target Entity
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	targetentityname
MaxLength	160
RequiredLevel	None
Type	String

Columnas/atributos de sólo lectura

Estas columnas o atributos devuelven false tanto para IsValidForCreate como para IsValidForUpdate. Listado por SchemaName.

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

ColumnMappingIdUnique

Propiedad	Valor
Description	Unique identifier of the Column Mapping.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	columnmappingidunique
RequiredLevel	SystemRequired
Type	Uniqueidentifier

ComponentState

Propiedad	Valor
Description	For internal use only.
DisplayName	Component State
IsValidForForm	False
IsValidForRead	True
LogicalName	componentstate
RequiredLevel	SystemRequired
Type	Picklist

Elecciones/opciones de ComponentState

Valor	Etiqueta	Descripción
0	Published
1	Unpublished
2	Deleted
3	Deleted Unpublished

CreatedBy

Propiedad	Valor
Description	Unique identifier of the user who created the column mapping.
DisplayName	Created By
IsValidForForm	False
IsValidForRead	True
LogicalName	createdby
RequiredLevel	None
Targets	systemuser
Type	Lookup

CreatedByName

Propiedad	Valor
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	createdbyname
MaxLength	100
RequiredLevel	None
Type	String

CreatedByYomiName

Propiedad	Valor
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	createdbyyominame
MaxLength	100
RequiredLevel	None
Type	String

CreatedOn

Propiedad	Valor
DateTimeBehavior	UserLocal
Description	Date and time when the column mapping was created.
DisplayName
Format	DateAndTime
IsValidForForm	False
IsValidForRead	True
LogicalName	createdon
RequiredLevel	SystemRequired
Type	DateTime

CreatedOnBehalfBy

Propiedad	Valor
Description	Unique identifier of the delegate user who created the columnmapping.
DisplayName	Created By (Delegate)
IsValidForForm	False
IsValidForRead	True
LogicalName	createdonbehalfby
RequiredLevel	None
Targets	systemuser
Type	Lookup

CreatedOnBehalfByName

Propiedad	Valor
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	createdonbehalfbyname
MaxLength	100
RequiredLevel	None
Type	String

CreatedOnBehalfByYomiName

Propiedad	Valor
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	createdonbehalfbyyominame
MaxLength	100
RequiredLevel	None
Type	String

ImportMapIdName

Propiedad	Valor
Description	Name of the associated data map.
DisplayName	Data Map
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	importmapidname
MaxLength	100
RequiredLevel	SystemRequired
Type	String

IsManaged

Propiedad	Valor
Description	Information that specifies whether this component is managed.
DisplayName	State
IsValidForForm	False
IsValidForRead	True
LogicalName	ismanaged
RequiredLevel	SystemRequired
Type	Boolean

Elecciones/opciones de IsManaged

Valor	Etiqueta	Descripción
1	Managed
0	Unmanaged

Valor predeterminado: 0

ModifiedBy

Propiedad	Valor
Description	Unique identifier of the user who last modified the column mapping.
DisplayName	Modified By
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedby
RequiredLevel	None
Targets	systemuser
Type	Lookup

ModifiedByName

Propiedad	Valor
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedbyname
MaxLength	100
RequiredLevel	None
Type	String

ModifiedByYomiName

Propiedad	Valor
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedbyyominame
MaxLength	100
RequiredLevel	None
Type	String

ModifiedOn

Propiedad	Valor
DateTimeBehavior	UserLocal
Description	Date and time when the column mapping was last modified.
DisplayName	Modified On
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedon
RequiredLevel	SystemRequired
Type	DateTime

ModifiedOnBehalfBy

Propiedad	Valor
Description	Unique identifier of the delegate user who last modified the columnmapping.
DisplayName	Modified By (Delegate)
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedonbehalfby
RequiredLevel	None
Targets	systemuser
Type	Lookup

ModifiedOnBehalfByName

Propiedad	Valor
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedonbehalfbyname
MaxLength	100
RequiredLevel	None
Type	String

ModifiedOnBehalfByYomiName

Propiedad	Valor
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedonbehalfbyyominame
MaxLength	100
RequiredLevel	None
Type	String

OverwriteTime

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

SolutionId

Propiedad	Valor
Description	Unique identifier of the associated solution.
DisplayName	Solution
IsValidForForm	False
IsValidForRead	True
LogicalName	solutionid
RequiredLevel	SystemRequired
Type	Uniqueidentifier

StateCode

Propiedad	Valor
Description	Status of the column mapping.
DisplayName	Status
IsValidForForm	True
IsValidForRead	True
LogicalName	statecode
RequiredLevel	SystemRequired
Type	State

Elecciones/opciones de StateCode

Valor	Etiqueta	Estado predeterminado	Nombre invariable
0	Active	1	Active

SupportingSolutionId

Propiedad	Valor
Description	For internal use only.
DisplayName	Solution
IsValidForForm	False
IsValidForRead	False
LogicalName	supportingsolutionid
RequiredLevel	None
Type	Uniqueidentifier

Relaciones de uno a varios

Listado por SchemaName.

• PickListMapping_ColumnMapping
• LookUpMapping_ColumnMapping

PickListMapping_ColumnMapping

Igual que la relación de varios a uno PickListMapping_ColumnMapping de la tabla picklistmapping.

Propiedad	Valor
ReferencingEntity	picklistmapping
ReferencingAttribute	columnmappingid
IsHierarchical	False
IsCustomizable	False
ReferencedEntityNavigationPropertyName	PickListMapping_ColumnMapping
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration	Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade

LookUpMapping_ColumnMapping

Igual que la relación de varios a uno LookUpMapping_ColumnMapping de la tabla lookupmapping.

Propiedad	Valor
ReferencingEntity	lookupmapping
ReferencingAttribute	columnmappingid
IsHierarchical	False
IsCustomizable	False
ReferencedEntityNavigationPropertyName	LookUpMapping_ColumnMapping
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration	Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade

Relaciones de varios a uno

Cada relación de varios a uno se define mediante una relación de uno a varios correspondiente con la tabla relacionada. Listado por SchemaName.

• lk_columnmapping_createdonbehalfby
• lk_columnmapping_createdby
• ColumnMapping_ImportMap
• lk_columnmapping_modifiedonbehalfby
• lk_columnmapping_modifiedby

lk_columnmapping_createdonbehalfby

Consulte la relación de uno a varios lk_columnmapping_createdonbehalfby de la tabla systemuser.

lk_columnmapping_createdby

Consulte la relación de uno a varios lk_columnmapping_createdby de la tabla systemuser.

ColumnMapping_ImportMap

Consulte la relación de uno a varios ColumnMapping_ImportMap de la tabla importmap.

lk_columnmapping_modifiedonbehalfby

Consulte la relación de uno a varios lk_columnmapping_modifiedonbehalfby de la tabla systemuser.

lk_columnmapping_modifiedby

Consulte la relación de uno a varios lk_columnmapping_modifiedby de la tabla systemuser.

Consultar también

Referencia de tabla o entidad de Dataverse Referencia de la API web columnmapping EntityType