Data Map (ImportMap) table/entity reference

Note

Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.

Data map used in import.

Messages

Message Web API Operation SDK Assembly
Assign PATCH [org URI]/api/data/v9.0/importmaps(importmapid)
Update ownerid property.
AssignRequest
Create POST [org URI]/api/data/v9.0/importmaps
See Create
CreateRequest or
Create
Delete DELETE [org URI]/api/data/v9.0/importmaps(importmapid)
See Delete
DeleteRequest or
Delete
ExportMappingsImportMap ExportMappingsImportMap Action ExportMappingsImportMapRequest
GrantAccess GrantAccess Action GrantAccessRequest
ImportMappingsImportMap ImportMappingsImportMap Action ImportMappingsImportMapRequest
ModifyAccess ModifyAccess Action ModifyAccessRequest
Retrieve GET [org URI]/api/data/v9.0/importmaps(importmapid)
See Retrieve
RetrieveRequest or
Retrieve
RetrieveMultiple GET [org URI]/api/data/v9.0/importmaps
See Query Data
RetrieveMultipleRequest or
RetrieveMultiple
RetrievePrincipalAccess RetrievePrincipalAccess Function RetrievePrincipalAccessRequest
RetrieveSharedPrincipalsAndAccess RetrieveSharedPrincipalsAndAccess Function RetrieveSharedPrincipalsAndAccessRequest
RevokeAccess RevokeAccess Action RevokeAccessRequest
SetState PATCH [org URI]/api/data/v9.0/importmaps(importmapid)
Update statecode and statuscode properties.
SetStateRequest
Update PATCH [org URI]/api/data/v9.0/importmaps(importmapid)
See Update
UpdateRequest or
Update

Properties

Property Value
CollectionSchemaName ImportMaps
DisplayCollectionName Data Maps
DisplayName Data Map
EntitySetName importmaps
IsBPFEntity False
LogicalCollectionName importmaps
LogicalName importmap
OwnershipType UserOwned
PrimaryIdAttribute importmapid
PrimaryNameAttribute name
SchemaName ImportMap

Writable columns/attributes

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

Description

Property Value
Description Type additional information to describe the data map, such as the intended use or data source.
DisplayName Description
FormatName TextArea
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName description
MaxLength 2000
RequiredLevel None
Type String

EntitiesPerFile

Property Value
Description Choose whether a data file can contain data for one or more record types.
DisplayName Entities Per File
IsValidForForm True
IsValidForRead True
LogicalName entitiesperfile
RequiredLevel SystemRequired
Type Picklist

EntitiesPerFile Choices/Options

Value Label Description
1 Single Entity Per File
2 Multiple Entities Per File

ImportMapId

Property Value
Description Unique identifier of the data map.
DisplayName Data Map
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName importmapid
RequiredLevel SystemRequired
Type Uniqueidentifier

ImportMapType

Property Value
Description Select the type of data map to distinguish out-of-the-box data maps from custom maps.
DisplayName Map Type
IsValidForForm True
IsValidForRead True
LogicalName importmaptype
RequiredLevel None
Type Picklist

ImportMapType Choices/Options

Value Label Description
1 Standard
2 Out of Box
3 In Process

IntroducedVersion

Property Value
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

IsWizardCreated

Property Value
Description Information about whether this data map was created by the Data Migration Manager.
DisplayName Is Wizard-Created
IsValidForForm False
IsValidForRead True
LogicalName iswizardcreated
RequiredLevel None
Type Boolean

IsWizardCreated Choices/Options

Value Label Description
1 True
0 False

DefaultValue: False

MapCustomizations

Property Value
Description Customizations XML
DisplayName Map Customizations
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName mapcustomizations
MaxLength 1073741823
RequiredLevel None
Type String

Name

Property Value
Description Type a descriptive name for the data map.
DisplayName Map Name
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName name
MaxLength 320
RequiredLevel None
Type String

OwnerId

Property Value
Description Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user.
DisplayName Owner
IsValidForForm True
IsValidForRead True
LogicalName ownerid
RequiredLevel SystemRequired
Targets systemuser,team
Type Owner

OwnerIdType

Property Value
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName owneridtype
RequiredLevel SystemRequired
Type EntityName

Source

Property Value
Description Type the name of the migration source that this data map is used for.
DisplayName Source
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName source
MaxLength 160
RequiredLevel None
Type String

SourceType

Property Value
Description Select the migration source type that this data map is used for.
DisplayName Source System Type
IsValidForForm True
IsValidForRead True
IsValidForUpdate False
LogicalName sourcetype
RequiredLevel None
Type Picklist

SourceType Choices/Options

Value Label Description
1 Map For SalesForce.com Full Data Export
2 Map For SalesForce.com Report Export
3 Map For SalesForce.com Contact and Account Report Export
4 Microsoft Office Outlook 2010 with Business Contact Manager
5 Generic Map for Contact and Account
Property Value
Description Source user value for source Microsoft Dynamics 365 user link.
DisplayName Source User Value
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName sourceuseridentifierforsourcecrmuserlink
MaxLength 160
RequiredLevel None
Type String
Property Value
Description Column in the source file that uniquely identifies a user.
DisplayName Source User Identifier
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName sourceuseridentifierforsourcedatasourceuserlink
MaxLength 160
RequiredLevel None
Type String

StateCode

Property Value
Description Shows whether the data map is active or inactive. Inactive data maps are read-only and can't be edited.
DisplayName Status
IsValidForCreate False
IsValidForForm True
IsValidForRead True
LogicalName statecode
RequiredLevel SystemRequired
Type State

StateCode Choices/Options

Value Label DefaultStatus InvariantName
0 Active 1 Active
1 Inactive 2 Inactive

StatusCode

Property Value
Description Select the data map's status.
DisplayName Status Reason
IsValidForForm True
IsValidForRead True
LogicalName statuscode
RequiredLevel SystemRequired
Type Status

StatusCode Choices/Options

Value Label State
1 Active 0
2 Inactive 1
Property Value
Description Microsoft Dynamics 365 user.
DisplayName Target User Value
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName targetuseridentifierforsourcecrmuserlink
MaxLength 160
RequiredLevel None
Type String

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate or 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

ComponentState Choices/Options

Value Label Description
0 Published
1 Unpublished
2 Deleted
3 Deleted Unpublished

CreatedBy

Property Value
Description Shows who created the record.
DisplayName Created By
IsValidForForm False
IsValidForRead True
LogicalName createdby
RequiredLevel None
Targets systemuser
Type Lookup

CreatedByName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdbyname
MaxLength 100
RequiredLevel None
Type String

CreatedByYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdbyyominame
MaxLength 100
RequiredLevel None
Type String

CreatedOn

Property Value
DateTimeBehavior UserLocal
Description Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options.
DisplayName Created On
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName createdon
RequiredLevel SystemRequired
Type DateTime

CreatedOnBehalfBy

Property Value
Description Shows who created the record on behalf of another user.
DisplayName Created By (Delegate)
IsValidForForm False
IsValidForRead True
LogicalName createdonbehalfby
RequiredLevel None
Targets systemuser
Type Lookup

CreatedOnBehalfByName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdonbehalfbyname
MaxLength 100
RequiredLevel None
Type String

CreatedOnBehalfByYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdonbehalfbyyominame
MaxLength 100
RequiredLevel None
Type String

ImportMapIdUnique

Property Value
Description Unique identifier of the ImortMap.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName importmapidunique
RequiredLevel SystemRequired
Type Uniqueidentifier

IsManaged

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

IsManaged Choices/Options

Value Label Description
1 Managed
0 Unmanaged

DefaultValue: False

IsValidForImport

Property Value
Description Information about whether the data map is valid for use with data import.
DisplayName Is Valid For Import
IsValidForForm False
IsValidForRead True
LogicalName isvalidforimport
RequiredLevel None
Type Boolean

IsValidForImport Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: False

ModifiedBy

Property Value
Description Shows who last updated the record.
DisplayName Modified By
IsValidForForm False
IsValidForRead True
LogicalName modifiedby
RequiredLevel None
Targets systemuser
Type Lookup

ModifiedByName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedbyname
MaxLength 100
RequiredLevel None
Type String

ModifiedByYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedbyyominame
MaxLength 100
RequiredLevel None
Type String

ModifiedOn

Property Value
DateTimeBehavior UserLocal
Description Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options.
DisplayName Modified On
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName modifiedon
RequiredLevel SystemRequired
Type DateTime

ModifiedOnBehalfBy

Property Value
Description Shows who last updated the record on behalf of another user.
DisplayName Modified By (Delegate)
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfby
RequiredLevel None
Targets systemuser
Type Lookup

ModifiedOnBehalfByName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfbyname
MaxLength 100
RequiredLevel None
Type String

ModifiedOnBehalfByYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfbyyominame
MaxLength 100
RequiredLevel None
Type String

OverwriteTime

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

OwnerIdName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName owneridname
MaxLength 100
RequiredLevel SystemRequired
Type String

OwnerIdYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName owneridyominame
MaxLength 100
RequiredLevel SystemRequired
Type String

OwningBusinessUnit

Property Value
Description Business unit that owns the data map.
DisplayName Owning Business Unit
IsValidForForm False
IsValidForRead True
LogicalName owningbusinessunit
RequiredLevel None
Targets businessunit
Type Lookup

OwningTeam

Property Value
Description Unique identifier of the team who owns the data map.
DisplayName Owning Team
IsValidForForm False
IsValidForRead True
LogicalName owningteam
RequiredLevel None
Targets team
Type Lookup

OwningUser

Property Value
Description Unique identifier of the user who owns the data map.
DisplayName Owning User
IsValidForForm False
IsValidForRead True
LogicalName owninguser
RequiredLevel None
Targets systemuser
Type Lookup

SolutionId

Property Value
Description Unique identifier of the associated solution.
DisplayName Solution
IsValidForForm False
IsValidForRead True
LogicalName solutionid
RequiredLevel SystemRequired
Type Uniqueidentifier

SupportingSolutionId

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

TargetEntity

Property Value
Description Select the name of the Microsoft Dynamics 365 record type that this data map is defined for.
DisplayName Record Type
IsValidForForm True
IsValidForRead True
LogicalName targetentity
RequiredLevel ApplicationRequired
Type Picklist

TargetEntity Choices/Options

Value Label Description
1 Account Business that represents a customer or potential customer. The company that is billed in business transactions.
2 Contact Person with whom a business unit has a relationship, such as customer, supplier, and colleague.
5 Note Note that is attached to one or more objects, including other notes.
6 Business Unit Map Stores mapping attributes for business units.
7 Owner Group of undeleted system users and undeleted teams. Owners can be used to control access to specific objects.
8 User Person with access to the Microsoft CRM system and who owns objects in the Microsoft CRM database.
9 Team Collection of system users that routinely collaborate. Teams can be used to simplify record sharing and provide team members with common access to organization data when team members belong to different Business Units.
10 Business Unit Business, division, or department in the Microsoft Dynamics 365 database.
14 System User Principal For internal use only.
29 Subscription For internal use only.
30 Filter Template Template for a filter.
31 Privilege Object Type Code For internal use only.
33 Subscription Synchronization Information For internal use only.
35 Tracking information for deleted entities For internal use only.
36 Client update Microsoft Dynamics 365 client for Outlook offline database update.
37 Subscription Manually Tracked Object For internal use only.
42 SystemUser BusinessUnit Entity Map Stores mapping attributes for business units.
44 Field Sharing Defines CRM security principals (users and teams) access rights to secured field for an entity instance.
45 Subscription Statistic Offline Subscription Statistic Offline
46 Subscription Statistic Outlook Subscription Statistic Outlook
47 Subscription Sync Entry Offline Used for offline sync, internal use only.
48 Subscription Sync Entry Outlook Used for outlook sync, internal use only.
50 Position Position of a user in the hierarchy
51 System User Manager Map For internal use only.
52 User Search Facet
54 Global Search Configuration
55 FileAttachment File Attachment
60 SystemUserAuthorizationChangeTracker Internal authorization table to track user authorization changes
61 PrincipalEntityBusinessUnitMap Internal authorization table to track user authorization changes
78 Virtual Entity Data Provider Developers can register plug-ins on a data provider to enable data access for virtual entities in the system.
85 Virtual Entity Data Source Internal entity that stores data source information for all installed providers.
92 Team template Team template for an entity enabled for automatically created access teams.
99 Social Profile This entity is used to store social profile information of its associated account and contacts on different social channels.
101 Service Plan Service Plan
126 Indexed Article Article indexed for search purposes.
127 Article Structured content that is part of the knowledge base.
129 Subject Information regarding subjects available in the system.
132 Announcement Announcement associated with an organization.
135 Activity Party Person or group associated with an activity. An activity can have multiple activity parties.
150 User Settings User's preferred settings.
300 Canvas App An application built through a canvas-based editing experience.
301 Callback Registration Callback Registration that stores configuration.
372 Connector Connector Entity to support Solutioning Integration
380 Environment Variable Definition Contains information about the settable variable: its type, default value, and etc.
381 Environment Variable Value Holds the value for the associated EnvironmentVariableDefinition entity.
400 AI Template
401 AI Model
402 AI Configuration
418 Dataflow
430 Entity Analytics Config This entity contains information about which entities are enabled for Azure Data Lake Services integration
431 Image Attribute Configuration Store configuration for each image attribute
432 Entity Image Configuration Store image configuration for each entity
950 New Process New Process Business Process Flow
951 Translation Process Translation Process Business Process Flow
955 Expired Process Expired Process Business Process Flow
1001 Attachment MIME attachment for an activity.
1002 Attachment Attachment for an email activity.
1003 Internal Address Storage of addresses for a user, business unit, or site.
1007 Image Descriptor For internal use only.
1016 Article Template Template for a knowledge base article that contains the standard attributes of an article.
1019 Organization Top level of the Microsoft Dynamics 365 business hierarchy. The organization can be a specific business, holding company, or corporation.
1021 Organization UI Entity customizations including form layout and icons. Includes current and past versions.
1023 Privilege Permission to perform an action in Microsoft CRM. The platform checks for the privilege and rejects the attempt if the user does not hold the privilege.
1030 System Form Organization-owned entity customizations including form layout and dashboards.
1031 User Dashboard User-owned dashboards.
1036 Security Role Grouping of security privileges. Users are assigned roles that authorize their access to the Microsoft CRM system.
1037 Role Template Template for a role. Defines initial attributes that will be used when creating a new role.
1039 View Saved query against the database.
1043 String Map Mapping between strings.
1071 Address Address and shipping information. Used to store additional addresses for an account or contact.
1072 Subscription Clients For internal use only.
1075 Status Map Mapping between statuses.
1082 Article Comment Comment on a knowledge base article.
1086 User Fiscal Calendar Custom fiscal calendar used for tracking sales quotas.
1094 Authorization Server Authorization servers that trust this organization
1095 Partner Application Partner applications registered for this organization
1111 System Chart System chart attached to an entity.
1112 User Chart Chart attached to an entity.
1113 Ribbon Tab To Command Mapping A mapping between Tab Ids, and the Commands within those tabs.
1115 Ribbon Context Group Groupings of contextual tabs.
1116 Ribbon Command Ribbon Commands - the command definition, rules, etc.
1117 Ribbon Rule Ribbon rule definitions, used to enable and disable, show and hide ribbon elements.
1120 Application Ribbons Ribbon customizations for the application ribbon and entity ribbon templates.
1130 Ribbon Difference All layout customizations to be applied to the ribbons, which contain only the differences from the base ribbon.
1140 Replication Backlog Entity to hold replication backlog tasks. For internal use only.
1189 Document Suggestions Document Suggestions
1190 SuggestionCardTemplate Templates for Suggestion Card in Grid
1200 Field Security Profile Profile which defines access level for secured attributes
1201 Field Permission Group of privileges used to categorize users to provide appropriate access to secured columns.
1203 Team Profiles Team Profiles
1234 Channel Property Group Group or collection of channel properties provided by the external channel for a Microsoft Dynamics 365 activity.
1236 Channel Property Instance of a channel property containing its name and corresponding data type.
1300 SocialInsightsConfiguration Configuration for the social insights.
1309 Saved Organization Insights Configuration Saved configuration for the organization insights
1400 Sync Attribute Mapping Profile Profile which defines sync attribute mapping
1401 Sync Attribute Mapping Group of Sync-Attribute Mappings used to provide Attribute mappings during sync for a particular user
1403 Team Sync-Attribute Mapping Profiles Team Sync-Attribute Mapping Profiles
1404 Principal Sync Attribute Map Maps security principals (users and teams) to sync attribute mappings.
2000 Annual Fiscal Calendar Year long fiscal calendar of an organization. A span of time during which the financial activities of an organization are calculated.
2001 Semiannual Fiscal Calendar Calendar representing the semi-annual span of time during which the financial activities of an organization are calculated.
2002 Quarterly Fiscal Calendar Quarterly fiscal calendar of an organization. A span of time during which the financial activities of an organization are calculated.
2003 Monthly Fiscal Calendar Monthly fiscal calendar of an organization. A span of time during which the financial activities of an organization are calculated.
2004 Fixed Monthly Fiscal Calendar Fixed monthly fiscal calendar of an organization. A span of time during which the financial activities of an organization are calculated.
2010 Email Template Template for an email message that contains the standard attributes of an email message.
2012 Unresolved Address For internal use only.
2013 Territory Territory represents sales regions.
2015 Theme Information that's used to set custom visual theme options for client applications.
2016 User Mapping User Mapping
2020 Queue A list of records that require action, such as accounts, activities, and cases.
2023 QueueItemCount For internal use only.
2024 QueueMemberCount For internal use only.
2027 License Stores information about a Microsoft CRM license.
2029 Queue Item A specific item in a queue, such as a case record or an activity record.
2500 User Entity UI Settings Stores user settings for entity views.
2501 User Entity Instance Data Per User item instance data
3000 Integration Status Contains integration status information.
3005 Channel Access Profile Information about permissions needed to access Dynamics 365 through external channels.For internal use only
3008 External Party Information about external parties that need to access Dynamics 365 from external channels.For internal use only
3231 Connection Role Role describing a relationship between a two records.
3233 Connection Role Object Type Code Specifies the entity type that can play specific role in a connection.
3234 Connection Relationship between two entities.
4003 Calendar Calendar used by the scheduling system to define when an appointment or activity is to occur.
4004 Calendar Rule Defines free/busy times for a service and for resources or resource groups, such as working, non-working, vacation, and blocked.
4011 Inter Process Lock Inter Process Locks.
4023 Email Hash Email activity hashes used for correlation purposes.
4101 Display String Map Maps customized display strings to entities.
4102 Display String Customized messages for an entity that has been renamed.
4110 Notification For internal use only.
4120 Exchange Sync Id Mapping The mapping used to keep track of the IDs for items synced between CRM and Exchange.
4200 Activity Task performed, or to be performed, by a user. An activity is any action for which an entry can be made on a calendar.
4201 Appointment Commitment representing a time interval with start/end times and duration.
4202 Email Activity that is delivered using email protocols.
4204 Fax Activity that tracks call outcome and number of pages for a fax and optionally stores an electronic copy of the document.
4207 Letter Activity that tracks the delivery of a letter. The activity can contain the electronic copy of the letter.
4210 Phone Call Activity to track a telephone call.
4212 Task Generic activity representing work needed to be done.
4216 Social Activity For internal use only.
4220 UntrackedEmail Activity that is delivered using UntrackedEmail protocols.
4230 Saved View Saved database query that is owned by a user.
4231 Metadata Difference Metadata Difference
4232 Business Data Localized Label Business Data Localized Label
4250 Recurrence Rule Recurrence Rule represents the pattern of incidence of recurring entities.
4251 Recurring Appointment The Master appointment of a recurring appointment series.
4299 Email Search Email Address Search Table.
4410 Data Import Status and ownership information for an import job.
4411 Data Map Data map used in import.
4412 Import Source File File name of file used for import.
4413 Import Data Unprocessed data from imported files.
4414 Duplicate Detection Rule Rule used to identify potential duplicates.
4415 Duplicate Record Potential duplicate record.
4416 Duplicate Rule Condition Condition of a duplicate detection rule.
4417 Column Mapping Mapping for columns in a data map.
4418 List Value Mapping In a data map, maps list values from the source file to Microsoft Dynamics 365.
4419 Lookup Mapping In a data map, maps a lookup attribute in a source file to Microsoft Dynamics 365.
4420 Owner Mapping In a data map, maps ownership data from the source file to Microsoft Dynamics 365.
4423 Import Log Failure reason and other detailed information for a record that failed to import.
4424 Bulk Delete Operation User-submitted bulk deletion job.
4425 Bulk Delete Failure Record that was not deleted during a bulk deletion job.
4426 Transformation Mapping In a data map, maps the transformation of source attributes to Microsoft Dynamics 365 attributes.
4427 Transformation Parameter Mapping In a data map, defines parameters for a transformation.
4428 Import Entity Mapping Mapping for entities in a data map.
4450 Data Performance Dashboard Data Performance Dashboard.
4490 Office Document Used to store Office Documents in database in binary format.
4500 Relationship Role Relationship between an account or contact and an opportunity.
4501 Relationship Role Map Mapping of the primary associated objects between which the relationship role is valid.
4502 Customer Relationship Relationship between a customer and a partner in which either can be an account or contact.
4567 Auditing Track changes to records for analysis, record keeping, and compliance.
4579 Ribbon Client Metadata. A ribbon client metadata.
4600 Entity Map Represents a mapping between two related entities so that data from one record can be copied into the form of a new related record.
4601 Attribute Map Represents a mapping between attributes where the attribute values should be copied from a record into the form of a new related record.
4602 Plug-in Type Type that inherits from the IPlugin interface and is contained within a plug-in assembly.
4603 Plug-in Type Statistic Plug-in type statistic.
4605 Plug-in Assembly Assembly that contains one or more plug-in types.
4606 Sdk Message Message that is supported by the SDK.
4607 Sdk Message Filter Filter that defines which SDK messages are valid for each type of entity.
4608 Sdk Message Processing Step Stage in the execution pipeline that a plug-in is to execute.
4609 Sdk Message Request For internal use only.
4610 Sdk Message Response For internal use only.
4611 Sdk Message Response Field For internal use only.
4613 Sdk Message Pair For internal use only.
4614 Sdk Message Request Field For internal use only.
4615 Sdk Message Processing Step Image Copy of an entity's attributes before or after the core system operation.
4616 Sdk Message Processing Step Secure Configuration Non-public custom configuration that is passed to a plug-in's constructor.
4618 Service Endpoint Service endpoint that can be contacted.
4619 Plug-in Trace Log Trace and exception information generated by plug-ins and custom workflow activities.
4700 System Job Process whose execution can proceed independently or in the background.
4702 Workflow Wait Subscription For internal use only.
4703 Process Set of logical rules that define the steps necessary to automate a specific business process, task, or set of actions to be performed.
4704 Process Dependency Dependencies for a process.
4705 ISV Config An XML document used to configure client extension controls.
4706 Process Log Log used to track process execution.
4707 Application File Files used by the application
4708 Organization Statistic Statistics measuring the organization's usage of the Microsoft Dynamics 365 system over the past 24 hours.
4709 Site Map XML data used to control the application navigation pane.
4710 Process Session Information that is generated when a dialog is run. Every time that you run a dialog, a dialog session is created.
4711 Expander Event For internal use only. An event that will be expanded into jobs whose executions can proceed in the background.
4712 Process Trigger Trigger that invoke a rule.
4720 Flow Session Entity to store the information that is generated when a modern flow or UI flow runs.
4724 Process Stage Stage associated with a process.
4725 Business Process Flow Instance Active path associated with every Business Process Flow instance
4800 Web Wizard Definition for a Web-based wizard.
4802 Wizard Page Page in a Web-based wizard.
4803 Web Wizard Access Privilege Privilege needed to access a Web-based wizard.
4810 Time Zone Definition Time zone definition, including name and time zone code.
4811 Time Zone Rule Definition for time conversion between local time and Coordinated Universal Time (UTC) for a particular time zone at a particular time period.
4812 Time Zone Localized Name Localized name of the time zone.
7000 System Application Metadata For internal use only.
7001 User Application Metadata For internal use only.
7100 Solution A solution which contains CRM customizations.
7101 Publisher A publisher of a CRM solution.
7102 Publisher Address Address and shipping information. Used to store additional addresses for a publisher.
7103 Solution Component A component of a CRM solution.
7104 Solution Component Definition Contains all the information required to process a solution aware entity
7105 Dependency A component dependency in CRM.
7106 Dependency Node The representation of a component dependency node in CRM.
7107 Invalid Dependency An invalid dependency in the CRM system.
7108 Dependency Feature A dependency feature.
7200 RuntimeDependency Form Level dependencies in CRM.
8000 Post An activity feed post.
8001 Post Role Represents the objects with which an activity feed post is associated. For internal use only.
8002 Post Regarding Represents which object an activity feed post is regarding. For internal use only.
8003 Follow Represents a user following the activity feed of an object.
8005 Comment A comment on an activity feed post.
8006 Like A like on an activity feed post.
8040 ACIViewMapper Customized messages for an entity that has been renamed.
8050 Trace A trace log.
8051 Trace Association Represents the objects with which a trace record is associated. For internal use only.
8052 Trace Regarding Represents which object a trace record is regarding. For internal use only.
8181 Routing Rule Set Define Routing Rule to route cases to right people at the right time
8199 Rule Item Please provide the description for entity
8700 AppModule Metadata For internal use only.
8701 AppModule Metadata Dependency For internal use only.
8702 AppModule Metadata Async Operation For internal use only.
8840 Hierarchy Rule Organization-owned entity customizations including mapping Quick view form with Relationship Id
9006 Model-driven App A role-based, modular business app that provides task-based functionality for a particular area of work.
9007 App Module Component A component available in a business app such as entity, dashboard, form, view, chart, and business process.
9009 App Module Roles Security roles that have access to a business app.
9011 App Config Master Contains the master list of all properties that can be customized for apps in Dynamics 365. For internal use only.
9012 App Configuration Contains a mapping between an app configuration instance and an app, which defines the properties that can be customized for the app. Optionally, also contains navigation setting for an app. For internal use only.
9013 App Configuration Instance Contains a property or a list of properties from the app configuration master list that can be customized for any app in Dynamics 365. For internal use only.
9100 Report Data summary in an easy-to-read layout.
9101 Report Related Entity Entities related to a report. A report can be related to multiple entities.
9102 Report Related Category Categories related to a report. A report can be related to multiple categories.
9103 Report Visibility Area in which to show a report. A report can be shown in multiple areas.
9104 Report Link Links and dependencies between reports. A report may drill through to another report, or it may have another report as a sub-report.
9105 Currency Currency in which a financial transaction is carried out.
9106 Mail Merge Template Template for a mail merge document that contains the standard attributes of that document.
9107 Import Job For internal use only.
9201 LocalConfigStore
9300 Record Creation and Update Rule Defines the settings for automatic record creation.
9301 Record Creation and Update Rule Item Defines the individual conditions required for creating records automatically.
9333 Web Resource Data equivalent to files used in Web development. Web resources provide client-side components that are used to provide custom user interface elements.
9400 Channel Access Profile Rule Defines the rules for automatically associating channel access profiles to external party records.For internal use only
9401 Channel Access Profile Rule Item Defines the rule items of a profile rule set for the automated profile association.For internal use only
9502 SharePoint Site SharePoint site from where documents can be managed in Microsoft Dynamics 365.
9507 Sharepoint Document Document libraries or folders on a SharePoint server from where documents can be managed in Microsoft Dynamics 365.
9508 Document Location Document libraries or folders on a SharePoint server from where documents can be managed in Microsoft Dynamics 365.
9509 SharePoint Data SharePoint's Data Corresponding to a user , Record , Location and Page
9510 Rollup Properties Stores properties related to rollup fields.
9511 Rollup Job Stores rollup jobs.
9600 Goal Target objective for a user or a team for a specified time period.
9602 Rollup Query Query that is used to filter the results of the goal rollup.
9603 Goal Metric Type of measurement for a goal, such as money amount or count.
9604 Rollup Field Field to be rolled up to calculate the actual and in-progress values against the goal.
9605 Email Server Profile Holds the Email Server Profiles of an organization
9606 Mailbox
9607 Mailbox Statistics Stores data regarding Mailbox processing cycles
9608 Mailbox Auto Tracking Folder Stores data about what folders for a mailbox are auto tracked
9609 Mailbox Tracking Category Stores data about what categories for a mailbox are tracked
9650 Process Configuration For internal use only.
9690 Organization Insights Notification Stores data regarding organization insights notification
9699 Organization Insights Metric Stores data regarding organization insights metric
9750 SLA Contains information about the tracked service-level KPIs for cases that belong to different customers.
9751 SLA Item Contains information about a tracked support KPI for a specific customer.
9752 SLA KPI Instance Service level agreement (SLA) key performance indicator (KPI) instance that is tracked for an individual case
9753 Custom Control For internal use only.
9754 Custom Control Resource Custom Control Resource Id
9755 Custom Control Default Config For internal use only.
9800 Entity
9808 Attribute
9809 OptionSet
9810 Entity Key
9811 Entity Relationship
9812 Managed Property
9813 Relationship Entity
9814 Relationship Attribute Stores relationship attributes mapping for Multi-predicate relationship
9815 Entity Index Metadata describing index of an entity
9816 Index Attribute Stores index attributes
9866 Mobile Offline Profile Information to administer and manage the data available to mobile devices in offline mode.
9867 Mobile Offline Profile Item Information on entity availability to mobile devices in offline mode for a mobile offline profile item.
9868 Mobile Offline Profile Item Association Information on relationships to be used to follow related entity's records for mobile offline profile item.
9869 Sync Error Failure reason and other detailed information for a record that failed to sync.
9870 Offline Command Definition For internal use only.
9875 Language Provisioning State Container for language provisioning checkpoint states
9880 Ribbon Metadata To Process Container for Ribbon Metadata To Process
9890 SolutionHistoryData solution history data
9900 Navigation Setting Navigation Setting: A setting page or group of pages available for configuration within an app. A record representing a group of pages is regarded as the parent navigation setting of one or more other records. For internal use only.
9910 MultiEntitySearch Multi Entity Search.
9912 Multi Select Option Value Multi Select Option Value
9919 Hierarchy Security Configuration
9930 Knowledge Base Record Metadata of knowledge base (KB) articles associated with Microsoft Dynamics 365 entities.
9932 Time Stamp Date Mapping For internal use only.`
9936 Azure Service Connection Stores connection information for an Azure service
9940 Document Template Used to store Document Templates in database in binary format.
9941 Personal Document Template Used to store Personal Document Templates in database in binary format.
9945 Text Analytics Entity Mapping
9947 Knowledge Search Model Configuration for automatic suggestion of knowledge articles using text analytics and search
9949 Advanced Similarity Rule A text match rule identifies similar records using keywords and key phrases determined with text analytics
9950 Office Graph Document Office Graph Documents Description
9951 Similarity Rule
9953 Knowledge Article Organizational knowledge for internal and external use.
9955 Knowledge Article Views No of times an article is viewed per day
9957 Language Language
9958 Feedback Container for feedback and ratings for knowledge articles.
9959 Category Entity for categorizing records to make it easier for your customers to find them on portals and through search.
9960 Knowledge Article Category Category for a Knowledge Article.
9961 DelveActionHub Delve Action Hubs Description
9962 Action Card Action card entity to show action cards.
9968 ActionCardUserState
9973 Action Card User Settings Stores user settings for action cards
9983 Action Card Type To provide master data for the card types list. For internal use only
9986 Interaction for Email
9987 External Party Item Information about external party items that need to access Dynamics 365 from external channels.For internal use only
9996 HolidayWrapper
9997 Email Signature Signature for email message
10000 Solution Component Attribute Configuration
10001 Solution Component Batch Configuration
10002 Solution Component Configuration
10003 Solution Component Relationship Configuration
10004 Solution History
10005 Solution History Data Source
10006 Component Layer
10007 Component Layer Data Source
10008 Package
10010 StageSolutionUpload
10011 ExportSolutionUpload
10012 FeatureControlSetting featurecontrolsetting
10013 Solution Component Summary
10014 Solution Component Count Summary
10015 Solution Component Data Source
10016 Solution Component Count Data Source
10017 Catalog Entity for cataloging records to make it easier for your customers to find them on portals and through search.
10018 Catalog Assignment Entity for assigning records to a specific catalog
10019 Internal Catalog Assignment
10020 Custom API Entity that defines a custom API
10021 Custom API Request Parameter Entity that defines a request parameter for a custom API
10022 Custom API Response Property Entity that defines a response property for a custom API
10023 ProvisionLanguageForUser
10024 Data Lake Folder A folder is a place to store data in Azure Data Lake.
10025 Data Lake Folder Permission
10026 Data Lake Workspace A workspace is a place to store data in Azure Data Lake.
10027 Data Lake Workspace Permission
10028 CascadeGrantRevokeAccessRecordsTracker
10029 CascadeGrantRevokeAccessVersionTracker
10030 RevokeInheritedAccessRecordsTracker
10031 Model-Driven App Element Associates a model-driven app with its components.
10032 Model-Driven App Component Node's Edge Contains Model-Driven App Component Node's Edge Information.
10033 Model-Driven App Component Node Contains Model-Driven App Component Node Information
10034 Model-Driven App Setting Holds the value for the associated App Setting Definition.
10035 Model-Driven App User Setting Holds the value for the associated App User Setting Definition.
10036 Organization Setting Holds the value for the associated Organization Setting Definition.
10037 Setting Definition Contains Setting Definitions
10038 CanvasApp Extended Metadata Holds extended metadata values for canvas apps that are not solution aware
10039 Service Plan Mapping Service Plan Mapping
10041 ApplicationUser Application User that has non-interactive access to the CDS system
10044 OData v4 Data Source Data sources used by the OData v4 data provider to access data from an external web service.
10045 Flow Machine
10046 Flow Machine Group
10047 ProcessStageParameter
10048 Workflow Binary
10049 Connection Reference
10050 AI Form Processing Document
10051 AI Object Detection Image
10052 AI Object Detection Label
10053 AI Object Detection Bounding Box
10054 AI Object Detection Image Mapping
10056 AI Builder Dataset
10057 AI Builder Dataset File
10058 AI Builder Dataset Record
10059 AI Builder Datasets Container
10060 AI Builder File
10061 AI Builder File Attached Data
10062 Help Page
10063 Tour
10064 BotContent
10065 ConversationTranscript Contains the transcripts of conversations between participants such as customers, Virtual Agents or Human agents.
10066 Chatbot Represents a Power Virtual Agents Chatbot. https://powerva.microsoft.com/|
10067 Chatbot subcomponent Holds key authoring components of a Chatbot such a topics, entities, variables, etc.
10073 PDF Setting PDF Settings to save enabled pdf entities
10074 Activity File Attachment Attachment entity with data stored in file type attribute
10075 Service Configuration
10076 SLA KPI
10077 Knowledge Federated Article
10078 Knowledge Federated Article Incident
10079 Search provider
10080 Knowledge Article Image
10081 Knowledge Interaction Insight Knowledge Interaction Insight
10082 Knowledge Search Insight Knowledge Search Insight
10083 Knowledge article language setting Allows you to select default language for knowledge authoring.
10084 Knowledge Article Attachment
10085 Knowledge personalization Allows users to personalize their knowledge search filters and knowledge authoring language.
10086 Knowledge Article Template Organizational Knowledge Article Template for Internal and external creation of Knowledge Articles.
10087 Knowledge search personal filter config Allows you to configure and manage personal filter settings.
10088 Knowledge search filter Allows you to configure and manage filter settings.
10090 Plugin Package
10091 Key Vault Reference Contains data that refers to an Azure Key Vault containing credentials used to connect to secure web-hosted resources.
10092 Managed Identity Contains data to represent an Azure Active Directory Application used to connect to secure web-hosted resources.
10093 Virtual Entity Metadata Holds metadata values for virtual entities
10094 TeamMobileOfflineProfileMembership
10095 UserMobileOfflineProfileMembership
10096 OrganizationDataSyncSubscription
10097 OrganizationDataSyncSubscriptionEntity
10098 NonRelational Data Source
10099 Notification Notification to be provided to a user.
10100 App Action
10101 Rich Text Attachment Image or file attached to a rich text field
10102 Search Telemetry Entity to log telemetry that used to improve search quality
10103 PM Inferred Task
10104 PM Recording
10105 Analysis Component
10106 Analysis Job
10107 Analysis Result
10108 Analysis Result Detail
10109 Solution Health Rule
10110 Solution Health Rule Argument
10111 Solution Health Rule Set Represents a set that owns a number of solution health rules.
10112 Comment A collaborative comment on a maker artifact

One-To-Many Relationships

Listed by SchemaName.

TransformationMapping_ImportMap

Same as transformationmapping table TransformationMapping_ImportMap Many-To-One relationship.

Property Value
ReferencingEntity transformationmapping
ReferencingAttribute importmapid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName TransformationMapping_ImportMap
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

OwnerMapping_ImportMap

Same as ownermapping table OwnerMapping_ImportMap Many-To-One relationship.

Property Value
ReferencingEntity ownermapping
ReferencingAttribute importmapid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName OwnerMapping_ImportMap
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

ImportMap_AsyncOperations

Same as asyncoperation table ImportMap_AsyncOperations Many-To-One relationship.

Property Value
ReferencingEntity asyncoperation
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName ImportMap_AsyncOperations
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

ImportMap_ImportFile

Same as importfile table ImportMap_ImportFile Many-To-One relationship.

Property Value
ReferencingEntity importfile
ReferencingAttribute importmapid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName ImportMap_ImportFile
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

ImportMap_BulkDeleteFailures

Same as bulkdeletefailure table ImportMap_BulkDeleteFailures Many-To-One relationship.

Property Value
ReferencingEntity bulkdeletefailure
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName ImportMap_BulkDeleteFailures
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

ImportEntityMapping_ImportMap

Same as importentitymapping table ImportEntityMapping_ImportMap Many-To-One relationship.

Property Value
ReferencingEntity importentitymapping
ReferencingAttribute importmapid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName ImportEntityMapping_ImportMap
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

ImportMap_SyncErrors

Same as syncerror table ImportMap_SyncErrors Many-To-One relationship.

Property Value
ReferencingEntity syncerror
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName ImportMap_SyncErrors
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
Share: Cascade
Unshare: Cascade

ColumnMapping_ImportMap

Same as columnmapping table ColumnMapping_ImportMap Many-To-One relationship.

Property Value
ReferencingEntity columnmapping
ReferencingAttribute importmapid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName ColumnMapping_ImportMap
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Many-To-One Relationships

Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.

lk_importmapbase_createdby

See systemuser Table lk_importmapbase_createdby One-To-Many relationship.

lk_importmap_createdonbehalfby

See systemuser Table lk_importmap_createdonbehalfby One-To-Many relationship.

BusinessUnit_ImportMaps

See businessunit Table BusinessUnit_ImportMaps One-To-Many relationship.

team_ImportMaps

See team Table team_ImportMaps One-To-Many relationship.

lk_importmap_modifiedonbehalfby

See systemuser Table lk_importmap_modifiedonbehalfby One-To-Many relationship.

SystemUser_ImportMaps

See systemuser Table SystemUser_ImportMaps One-To-Many relationship.

lk_importmapbase_modifiedby

See systemuser Table lk_importmapbase_modifiedby One-To-Many relationship.

See also

About the table reference
Web API Reference
importmap EntityType