Referenz zur Tabelle/Entität ColumnMapping
Hinweis
Unsicher bei Tabelle vs. Entität? Siehe Entwickler: Terminologie in Microsoft Dataverse verstehen.
Mapping for columns in a data map.
Nachrichten
| Nachricht | Web-API-Vorgang | SDK-Klasse oder -Methode |
|---|---|---|
| Create | POST [org URI]/api/data/v9.0/columnmappings Weitere Informationen finden Sie unter Erstellen |
CreateRequest oder Create |
| Delete | DELETE [org URI]/api/data/v9.0/columnmappings(columnmappingid) Weitere Informationen finden Sie unter Löschen |
DeleteRequest oder Delete |
| Retrieve | GET [org URI]/api/data/v9.0/columnmappings(columnmappingid) Weitere Informationen finden Sie unter Abrufen |
RetrieveRequest oder Retrieve |
| RetrieveMultiple | GET [org URI]/api/data/v9.0/columnmappings Weitere Informationen finden Sie unter Daten abfragen |
RetrieveMultipleRequest oder RetrieveMultiple |
Eigenschaften
| Eigenschaft | Wert |
|---|---|
| CollectionSchemaName | ColumnMappings |
| DisplayCollectionName | Column Mappings |
| DisplayName | Column Mapping |
| EntitySetName | columnmappings |
| IsBPFEntity | False |
| LogicalCollectionName | columnmappings |
| LogicalName | columnmapping |
| OwnershipType | None |
| PrimaryIdAttribute | columnmappingid |
| PrimaryNameAttribute | sourceattributename |
| SchemaName | ColumnMapping |
Schreibbare Spalten/Attribute
Diese Spalten/Attribute geben entweder für IsValidForCreate oder IsValidForUpdate (normalerweise beides) true zurück. Aufgelistet durch SchemaName.
- ColumnMappingId
- ImportMapId
- IntroducedVersion
- ProcessCode
- SourceAttributeName
- SourceEntityName
- StatusCode
- TargetAttributeName
- TargetEntityName
ColumnMappingId
| Eigenschaft | Wert |
|---|---|
| Description | Unique identifier of the column mapping. |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | columnmappingid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
ImportMapId
| Eigenschaft | Wert |
|---|---|
| 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
| Eigenschaft | Wert |
|---|---|
| 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
| Eigenschaft | Wert |
|---|---|
| Description | Information about whether the column mapping needs to be processed. |
| DisplayName | Process Code |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | processcode |
| RequiredLevel | SystemRequired |
| Type | Picklist |
ProcessCode Auswahlen/Optionen
| Wert | Etikett | Beschreibung |
|---|---|---|
| 1 | Process | |
| 2 | Ignore | |
| 3 | Internal |
SourceAttributeName
| Eigenschaft | Wert |
|---|---|
| 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
| Eigenschaft | Wert |
|---|---|
| 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
| Eigenschaft | Wert |
|---|---|
| Description | Reason for the status of the column mapping. |
| DisplayName | Status Reason |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statuscode |
| RequiredLevel | SystemRequired |
| Type | Status |
StatusCode Auswahlen/Optionen
| Wert | Etikett | Status |
|---|---|---|
| 1 | Active | 0 |
TargetAttributeName
| Eigenschaft | Wert |
|---|---|
| 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
| Eigenschaft | Wert |
|---|---|
| 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 |
Schreibgeschützt Spalten/Attribute
Diese Spalten/Attribute geben false zurück für sowohl IsValidForCreate als auch IsValidForUpdate. Aufgelistet durch SchemaName.
- ColumnMappingIdUnique
- ComponentState
- CreatedBy
- CreatedByName
- CreatedByYomiName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- ImportMapIdName
- IsManaged
- ModifiedBy
- ModifiedByName
- ModifiedByYomiName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OverwriteTime
- SolutionId
- StateCode
- SupportingSolutionId
ColumnMappingIdUnique
| Eigenschaft | Wert |
|---|---|
| Description | Unique identifier of the Column Mapping. |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | columnmappingidunique |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
ComponentState
| Eigenschaft | Wert |
|---|---|
| Description | For internal use only. |
| DisplayName | Component State |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | componentstate |
| RequiredLevel | SystemRequired |
| Type | Picklist |
ComponentState Auswahlen/Optionen
| Wert | Etikett | Beschreibung |
|---|---|---|
| 0 | Published | |
| 1 | Unpublished | |
| 2 | Deleted | |
| 3 | Deleted Unpublished |
CreatedBy
| Eigenschaft | Wert |
|---|---|
| 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
| Eigenschaft | Wert |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedByYomiName
| Eigenschaft | Wert |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOn
| Eigenschaft | Wert |
|---|---|
| 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
| Eigenschaft | Wert |
|---|---|
| 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
| Eigenschaft | Wert |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOnBehalfByYomiName
| Eigenschaft | Wert |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ImportMapIdName
| Eigenschaft | Wert |
|---|---|
| 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
| Eigenschaft | Wert |
|---|---|
| Description | Information that specifies whether this component is managed. |
| DisplayName | State |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | ismanaged |
| RequiredLevel | SystemRequired |
| Type | Boolean |
IsManaged Auswahlen/Optionen
| Wert | Etikett | Beschreibung |
|---|---|---|
| 1 | Managed | |
| 0 | Unmanaged |
Standardwert: 0
ModifiedBy
| Eigenschaft | Wert |
|---|---|
| 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
| Eigenschaft | Wert |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedByYomiName
| Eigenschaft | Wert |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOn
| Eigenschaft | Wert |
|---|---|
| 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
| Eigenschaft | Wert |
|---|---|
| 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
| Eigenschaft | Wert |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOnBehalfByYomiName
| Eigenschaft | Wert |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
OverwriteTime
| Eigenschaft | Wert |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | For internal use only. |
| DisplayName | Record Overwrite Time |
| Format | DateOnly |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | overwritetime |
| RequiredLevel | SystemRequired |
| Type | DateTime |
SolutionId
| Eigenschaft | Wert |
|---|---|
| Description | Unique identifier of the associated solution. |
| DisplayName | Solution |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | solutionid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
StateCode
| Eigenschaft | Wert |
|---|---|
| Description | Status of the column mapping. |
| DisplayName | Status |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statecode |
| RequiredLevel | SystemRequired |
| Type | State |
StateCode Auswahlen/Optionen
| Wert | Etikett | Standardstatuswert | Invariante Name |
|---|---|---|---|
| 0 | Active | 1 | Active |
SupportingSolutionId
| Eigenschaft | Wert |
|---|---|
| Description | For internal use only. |
| DisplayName | Solution |
| IsValidForForm | False |
| IsValidForRead | False |
| LogicalName | supportingsolutionid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
Eins-zu-Viele-Beziehungen
Aufgelistet durch SchemaName.
PickListMapping_ColumnMapping
Wie die PickListMapping_ColumnMapping-Viele-zu-Eins-Beziehung für die picklistmapping-Tabelle/-Entität.
| Eigenschaft | Wert |
|---|---|
| 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
Wie die LookUpMapping_ColumnMapping-Viele-zu-Eins-Beziehung für die lookupmapping-Tabelle/-Entität.
| Eigenschaft | Wert |
|---|---|
| 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 |
Viele-zu-Eins-Beziehungen
Jede Viele-zu-Eins-Beziehung wird durch eine entsprechende Viele-zu-Viele-Beziehungen mit der zugehörigen Tabelle definiert. Aufgelistet durch SchemaName.
- lk_columnmapping_createdonbehalfby
- lk_columnmapping_createdby
- ColumnMapping_ImportMap
- lk_columnmapping_modifiedonbehalfby
- lk_columnmapping_modifiedby
lk_columnmapping_createdonbehalfby
Siehe die lk_columnmapping_createdonbehalfby-Eins-zu-Viele-Beziehung für die systemuser-Tabelle/-Entität.
lk_columnmapping_createdby
Siehe die lk_columnmapping_createdby-Eins-zu-Viele-Beziehung für die systemuser-Tabelle/-Entität.
ColumnMapping_ImportMap
Siehe die ColumnMapping_ImportMap-Eins-zu-Viele-Beziehung für die importmap-Tabelle/-Entität.
lk_columnmapping_modifiedonbehalfby
Siehe die lk_columnmapping_modifiedonbehalfby-Eins-zu-Viele-Beziehung für die systemuser-Tabelle/-Entität.
lk_columnmapping_modifiedby
Siehe die lk_columnmapping_modifiedby-Eins-zu-Viele-Beziehung für die systemuser-Tabelle/-Entität.
Siehe auch
Dataverse-Tabelle/-Entitätsreferenz Web-API-Referenz columnmapping EntityType