Muokkaa

Jaa


Transformation Mapping (TransformationMapping) table/entity reference

In a data map, maps the transformation of source attributes to Microsoft Dynamics 365 attributes.

Messages

The following table lists the messages for the Transformation Mapping (TransformationMapping) 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
Create
Event: False
POST /transformationmappings
See Create
Create records
Delete
Event: False
DELETE /transformationmappings(transformationmappingid)
See Delete
Delete records
Retrieve
Event: False
GET /transformationmappings(transformationmappingid)
See Retrieve
Retrieve records
RetrieveMultiple
Event: False
GET /transformationmappings
See Query data
Query data

Properties

The following table lists selected properties for the Transformation Mapping (TransformationMapping) table.

Property Value
DisplayName Transformation Mapping
DisplayCollectionName Transformation Mappings
SchemaName TransformationMapping
CollectionSchemaName TransformationMappings
EntitySetName transformationmappings
LogicalName transformationmapping
LogicalCollectionName transformationmappings
PrimaryIdAttribute transformationmappingid
TableType Standard
OwnershipType None

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

ImportMapId

Property Value
Description Unique identifier of the associated data map.
DisplayName Data Map
IsValidForForm True
IsValidForRead True
LogicalName importmapid
RequiredLevel None
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 transformation mapping needs to be processed.
DisplayName Process Code
IsValidForForm True
IsValidForRead True
LogicalName processcode
RequiredLevel SystemRequired
Type Picklist
DefaultFormValue 1
GlobalChoiceName transformationmapping_processcode

ProcessCode Choices/Options

Value Label
1 Process
2 Ignore
3 Internal

SourceEntityName

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

StatusCode

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

StatusCode Choices/Options

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

TargetEntityName

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

TransformationMappingId

Property Value
Description Unique identifier of the transformation mapping.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName transformationmappingid
RequiredLevel SystemRequired
Type Uniqueidentifier

TransformationTypeName

Property Value
Description Type of transformation.
DisplayName Transformation Type Name
IsValidForForm True
IsValidForRead True
LogicalName transformationtypename
RequiredLevel ApplicationRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 256

Read-only columns/attributes

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

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 transformation 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 transformation mapping was created.
DisplayName Created On
IsValidForForm False
IsValidForRead True
LogicalName createdon
RequiredLevel None
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 transformationmapping.
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 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 transformation mapping was last modified.
DisplayName Modified On
IsValidForForm True
IsValidForRead True
LogicalName modifiedon
RequiredLevel None
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 transformationmapping.
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 transformation mapping.
DisplayName Status
IsValidForForm True
IsValidForRead True
LogicalName statecode
RequiredLevel SystemRequired
Type State
DefaultFormValue 0
GlobalChoiceName transformationmapping_statecode

StateCode Choices/Options

Value Details
0 Label: Active
DefaultStatus: 0
InvariantName: Active

SupportingSolutionId

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

TransformationMappingIdUnique

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

Many-to-One relationships

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

lk_transformationmapping_createdby

One-To-Many Relationship: systemuser lk_transformationmapping_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_transformationmapping_createdonbehalfby

One-To-Many Relationship: systemuser lk_transformationmapping_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_transformationmapping_modifiedby

One-To-Many Relationship: systemuser lk_transformationmapping_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_transformationmapping_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_transformationmapping_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

TransformationMapping_ImportMap

One-To-Many Relationship: importmap TransformationMapping_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

One-to-Many relationships

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

TransformationParameterMapping_TransformationMapping

Many-To-One Relationship: transformationparametermapping TransformationParameterMapping_TransformationMapping

Property Value
ReferencingEntity transformationparametermapping
ReferencingAttribute transformationmappingid
ReferencedEntityNavigationPropertyName TransformationParameterMapping_TransformationMapping
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
transformationmapping