columnmapping EntityType
Mapping for columns in a data map.
- Entity set path:
- [organization URI]/api/data/v9.2/columnmappings
- Base type:
- crmbaseentity
- Table type:
- Standard
- Display name:
- Column Mapping
- Primary key:
- columnmappingid
- Primary name column:
- 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 |