columnmapping EntityType
Mapping for columns in a data map.
- Entity set path:
- [organization URI]/api/data/v9.2/columnmappings
- Base type:
- crmbaseentity
- Display name:
- Column Mapping
- Primary key:
- columnmappingid
- Primary key attribute:
- sourceattributename
- Operations supported:
- POST GET DELETE
Properties
Properties represent fields of data stored in the entity. Some properties are read-only.
Name | Type | Details | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
columnmappingid | Edm.Guid |
Unique identifier of the column mapping. |
||||||||||
columnmappingidunique | Edm.Guid |
Unique identifier of the Column Mapping. Read only
|
||||||||||
componentstate | Edm.Int32 |
For internal use only. Display name: Component State Read only
Default options
|
||||||||||
createdon | Edm.DateTimeOffset |
Date and time when the column mapping was created. Read only
|
||||||||||
introducedversion | Edm.String |
Version in which the component is introduced. Display name: Introduced Version |
||||||||||
ismanaged | Edm.Boolean |
Information that specifies whether this component is managed. Display name: State Read only
Default options
|
||||||||||
modifiedon | Edm.DateTimeOffset |
Date and time when the column mapping was last modified. Display name: Modified On Read only
|
||||||||||
overwritetime | Edm.DateTimeOffset |
For internal use only. Display name: Record Overwrite Time Read only
|
||||||||||
processcode | Edm.Int32 |
Information about whether the column mapping needs to be processed. Display name: Process Code
Default options
|
||||||||||
solutionid | Edm.Guid |
Unique identifier of the associated solution. Display name: Solution Read only
|
||||||||||
sourceattributename | Edm.String |
Name of the source attribute. Display name: Source Attribute |
||||||||||
sourceentityname | Edm.String |
Name of the source entity. Display name: Source Entity Name |
||||||||||
statecode | Edm.Int32 |
Status of the column mapping. Display name: Status Read only
Default options
|
||||||||||
statuscode | Edm.Int32 |
Reason for the status of the column mapping. Display name: Status Reason
Default options
|
||||||||||
targetattributename | Edm.String |
Name of the Microsoft Dynamics 365 attribute. Display name: Target Attribute |
||||||||||
targetentityname | Edm.String |
Name of the Microsoft Dynamics 365 entity. Display name: Target Entity |
Lookup properties
Lookup properties are read-only, computed properties which contain entity primary key Edm.Guid data for one or more corresponding single-valued navigation properties. More information: Lookup properties and Lookup property data.
Name | Single-valued navigation property | Description |
---|---|---|
_createdby_value | createdby |
Unique identifier of the user who created the column mapping. |
_createdonbehalfby_value | createdonbehalfby |
Unique identifier of the delegate user who created the columnmapping. |
_importmapid_value | importmapid |
Unique identifier of the associated data map. |
_modifiedby_value | modifiedby |
Unique identifier of the user who last modified the column mapping. |
_modifiedonbehalfby_value | modifiedonbehalfby |
Unique identifier of the delegate user who last modified the columnmapping. |
Single-valued navigation properties
Single-valued navigation properties represent lookup fields where a single entity can be referenced. Each single-valued navigation property has a corresponding partner collection-valued navigation property on the related entity.
Name | Type | Partner |
---|---|---|
createdby | systemuser | lk_columnmapping_createdby |
createdonbehalfby | systemuser | lk_columnmapping_createdonbehalfby |
importmapid | importmap | ColumnMapping_ImportMap |
modifiedby | systemuser | lk_columnmapping_modifiedby |
modifiedonbehalfby | systemuser | lk_columnmapping_modifiedonbehalfby |
Collection-valued navigation properties
Collection-valued navigation properties represent collections of entities which may represent either a one-to-many (1:N) or many-to-many (N:N) relationship between the entities.
Name | Type | Partner |
---|---|---|
LookUpMapping_ColumnMapping | lookupmapping | columnmappingid |
PickListMapping_ColumnMapping | picklistmapping | columnmappingid |