Edit

Share via

Column Mapping (ColumnMapping) table/entity reference (Microsoft Dataverse)

Mapping for columns in a data map.

Messages

The following table lists the messages for the Column Mapping (ColumnMapping) table. Messages represent operations that can be performed on the table. They may also be events.

Name
Is Event?		 Web API Operation SDK for .NET
Associate
Event: True		 Associate records Associate records
Create
Event: False		 POST /columnmappings
See Create		 Create records
Delete
Event: False		 DELETE /columnmappings(columnmappingid)
See Delete		 Delete records
Disassociate
Event: True		 Disassociate records Disassociate records
Retrieve
Event: False		 GET /columnmappings(columnmappingid)
See Retrieve		 Retrieve records
RetrieveMultiple
Event: False		 GET /columnmappings
See Query data		 Query data

Properties

The following table lists selected properties for the Column Mapping (ColumnMapping) table.

Property Value
DisplayName Column Mapping
DisplayCollectionName Column Mappings
SchemaName ColumnMapping
CollectionSchemaName ColumnMappings
EntitySetName columnmappings
LogicalName columnmapping
LogicalCollectionName columnmappings
PrimaryIdAttribute columnmappingid
PrimaryNameAttribute sourceattributename
TableType Standard
OwnershipType None

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.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName columnmappingid
RequiredLevel SystemRequired
Type Uniqueidentifier

ImportMapId

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

IntroducedVersion

Property Value
Description Version in which the component is introduced.
DisplayName Introduced Version
IsValidForForm False
IsValidForRead True
LogicalName introducedversion
RequiredLevel None
Type String
Format VersionNumber
FormatName VersionNumber
ImeMode Auto
IsLocalizable False
MaxLength 48

ProcessCode

Property Value
Description Information about whether the column mapping needs to be processed.
DisplayName Process Code
IsValidForForm True
IsValidForRead True
LogicalName processcode
RequiredLevel SystemRequired
Type Picklist
DefaultFormValue -1
GlobalChoiceName columnmapping_processcode

ProcessCode Choices/Options

Value Label
1 Process
2 Ignore
3 Internal

SourceAttributeName

Property Value
Description Name of the source attribute.
DisplayName Source Attribute
IsValidForForm True
IsValidForRead True
LogicalName sourceattributename
RequiredLevel ApplicationRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 160

SourceEntityName

Property Value
Description Name of the source entity.
DisplayName Source Entity Name
IsValidForForm True
IsValidForRead True
LogicalName sourceentityname
RequiredLevel ApplicationRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 160

StatusCode

Property Value
Description Reason for the status of the column mapping.
DisplayName Status Reason
IsValidForForm True
IsValidForRead True
LogicalName statuscode
RequiredLevel SystemRequired
Type Status
DefaultFormValue -1
GlobalChoiceName columnmapping_statuscode

StatusCode Choices/Options

Value Details
1 Label: Active
State:0
TransitionData: None

TargetAttributeName

Property Value
Description Name of the Microsoft Dynamics 365 attribute.
DisplayName Target Attribute
IsValidForForm True
IsValidForRead True
LogicalName targetattributename
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 160

TargetEntityName

Property Value
Description Name of the Microsoft Dynamics 365 entity.
DisplayName Target Entity
IsValidForForm True
IsValidForRead True
LogicalName targetentityname
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 160

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.

ColumnMappingIdUnique

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

ComponentState

Property Value
Description For internal use only.
DisplayName Component State
IsValidForForm False
IsValidForRead True
LogicalName componentstate
RequiredLevel SystemRequired
Type Picklist
DefaultFormValue -1
GlobalChoiceName componentstate

ComponentState Choices/Options

Value Label
0 Published
1 Unpublished
2 Deleted
3 Deleted Unpublished

CreatedBy

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

CreatedOn

Property Value
Description Date and time when the column mapping was created.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName createdon
RequiredLevel SystemRequired
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

CreatedOnBehalfBy

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

IsManaged

Property Value
Description Information that specifies whether this component is managed.
DisplayName State
IsValidForForm False
IsValidForRead True
LogicalName ismanaged
RequiredLevel SystemRequired
Type Boolean
GlobalChoiceName ismanaged
DefaultValue False
True Label Managed
False Label Unmanaged

ModifiedBy

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

ModifiedOn

Property Value
Description Date and time when the column mapping was last modified.
DisplayName Modified On
IsValidForForm True
IsValidForRead True
LogicalName modifiedon
RequiredLevel SystemRequired
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

ModifiedOnBehalfBy

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

OverwriteTime

Property Value
Description For internal use only.
DisplayName Record Overwrite Time
IsValidForForm False
IsValidForRead True
LogicalName overwritetime
RequiredLevel SystemRequired
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateOnly
ImeMode Inactive
SourceTypeMask 0

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 column mapping.
DisplayName Status
IsValidForForm True
IsValidForRead True
LogicalName statecode
RequiredLevel SystemRequired
Type State
DefaultFormValue 0
GlobalChoiceName columnmapping_statecode

StateCode Choices/Options

Value Details
0 Label: Active
DefaultStatus: 1
InvariantName: 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

These relationships are many-to-one. Listed by SchemaName.

ColumnMapping_ImportMap

One-To-Many Relationship: importmap ColumnMapping_ImportMap

Property Value
ReferencedEntity importmap
ReferencedAttribute importmapid
ReferencingAttribute importmapid
ReferencingEntityNavigationPropertyName importmapid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_columnmapping_createdby

One-To-Many Relationship: systemuser lk_columnmapping_createdby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute createdby
ReferencingEntityNavigationPropertyName createdby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_columnmapping_createdonbehalfby

One-To-Many Relationship: systemuser lk_columnmapping_createdonbehalfby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute createdonbehalfby
ReferencingEntityNavigationPropertyName createdonbehalfby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_columnmapping_modifiedby

One-To-Many Relationship: systemuser lk_columnmapping_modifiedby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute modifiedby
ReferencingEntityNavigationPropertyName modifiedby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_columnmapping_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_columnmapping_modifiedonbehalfby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute modifiedonbehalfby
ReferencingEntityNavigationPropertyName modifiedonbehalfby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

One-to-Many relationships

These relationships are one-to-many. Listed by SchemaName.

LookUpMapping_ColumnMapping

Many-To-One Relationship: lookupmapping LookUpMapping_ColumnMapping

Property Value
ReferencingEntity lookupmapping
ReferencingAttribute columnmappingid
ReferencedEntityNavigationPropertyName LookUpMapping_ColumnMapping
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

PickListMapping_ColumnMapping

Many-To-One Relationship: picklistmapping PickListMapping_ColumnMapping

Property Value
ReferencingEntity picklistmapping
ReferencingAttribute columnmappingid
ReferencedEntityNavigationPropertyName PickListMapping_ColumnMapping
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

See also

Dataverse table/entity reference
Dataverse Web API Reference
columnmapping