Data Map (ImportMap) table/entity reference (Microsoft Dataverse)

Data map used in import.

Messages

The following table lists the messages for the Data Map (ImportMap) 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
Assign Event: False	PATCH /importmaps(importmapid) Update the ownerid property.	AssignRequest
Associate Event: True	Associate records	Associate records
Create Event: False	POST /importmaps See Create	Create records
Delete Event: False	DELETE /importmaps(importmapid) See Delete	Delete records
Disassociate Event: True	Disassociate records	Disassociate records
ExportMappingsImportMap Event: False	ExportMappingsImportMap	ExportMappingsImportMapRequest
GrantAccess Event: False	GrantAccess	GrantAccessRequest
ImportMappingsImportMap Event: False	ImportMappingsImportMap	ImportMappingsImportMapRequest
ModifyAccess Event: False	ModifyAccess	ModifyAccessRequest
Retrieve Event: False	GET /importmaps(importmapid) See Retrieve	Retrieve records
RetrieveMultiple Event: False	GET /importmaps See Query data	Query data
RetrievePrincipalAccess Event: False	RetrievePrincipalAccess	RetrievePrincipalAccessRequest
RetrieveSharedPrincipalsAndAccess Event: False	RetrieveSharedPrincipalsAndAccess	RetrieveSharedPrincipalsAndAccessRequest
RevokeAccess Event: False	RevokeAccess	RevokeAccessRequest
SetState Event: False	PATCH /importmaps(importmapid) Update the statecode and statuscode properties.	SetStateRequest
Update Event: False	PATCH /importmaps(importmapid) See Update	Update records
Upsert Event: False	PATCH /importmaps(importmapid) See Upsert a table row	UpsertRequest

Properties

The following table lists selected properties for the Data Map (ImportMap) table.

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

Writable columns/attributes

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

• Description
• EntitiesPerFile
• ImportMapId
• ImportMapType
• IntroducedVersion
• IsWizardCreated
• MapCustomizations
• Name
• OwnerId
• OwnerIdType
• Source
• SourceType
• SourceUserIdentifierForSourceCRMUserLink
• SourceUserIdentifierForSourceDataSourceUserLink
• StateCode
• StatusCode
• TargetUserIdentifierForSourceCRMUserLink

Description

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

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
DefaultFormValue	-1
GlobalChoiceName	importmap_entitiesperfile

EntitiesPerFile Choices/Options

Value	Label
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
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
DefaultFormValue	-1
GlobalChoiceName	importmap_importmaptype

ImportMapType Choices/Options

Value	Label
1	Standard
2	Out of Box
3	In Process

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

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
GlobalChoiceName	importmap_iswizardcreated
DefaultValue	False
True Label	True
False Label	False

MapCustomizations

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

Name

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

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
Type	Owner
Targets	systemuser, team

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
IsValidForForm	True
IsValidForRead	True
LogicalName	source
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	160

SourceType

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

SourceType Choices/Options

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

SourceUserIdentifierForSourceCRMUserLink

Property	Value
Description	Source user value for source Microsoft Dynamics 365 user link.
DisplayName	Source User Value
IsValidForForm	False
IsValidForRead	True
LogicalName	sourceuseridentifierforsourcecrmuserlink
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	160

SourceUserIdentifierForSourceDataSourceUserLink

Property	Value
Description	Column in the source file that uniquely identifies a user.
DisplayName	Source User Identifier
IsValidForForm	False
IsValidForRead	True
LogicalName	sourceuseridentifierforsourcedatasourceuserlink
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	160

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
IsValidForForm	True
IsValidForRead	True
LogicalName	statecode
RequiredLevel	SystemRequired
Type	State
DefaultFormValue	0
GlobalChoiceName	importmap_statecode

StateCode Choices/Options

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

StatusCode

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

StatusCode Choices/Options

Value	Details
1	Label: Active State:0 TransitionData: None
2	Label: Inactive State:1 TransitionData: None

TargetUserIdentifierForSourceCRMUserLink

Property	Value
Description	Microsoft Dynamics 365 user.
DisplayName	Target User Value
IsValidForForm	False
IsValidForRead	True
LogicalName	targetuseridentifierforsourcecrmuserlink
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	160

Read-only columns/attributes

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

• ComponentState
• CreatedBy
• CreatedOn
• CreatedOnBehalfBy
• ImportMapIdUnique
• IsManaged
• IsValidForImport
• ModifiedBy
• ModifiedOn
• ModifiedOnBehalfBy
• OverwriteTime
• OwnerIdName
• OwnerIdYomiName
• OwningBusinessUnit
• OwningTeam
• OwningUser
• SolutionId
• SupportingSolutionId
• TargetEntity

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	Shows who created the record.
DisplayName	Created By
IsValidForForm	False
IsValidForRead	True
LogicalName	createdby
RequiredLevel	None
Type	Lookup
Targets	systemuser

CreatedOn

Property	Value
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
IsValidForForm	True
IsValidForRead	True
LogicalName	createdon
RequiredLevel	SystemRequired
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

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
Type	Lookup
Targets	systemuser

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
GlobalChoiceName	ismanaged
DefaultValue	False
True Label	Managed
False Label	Unmanaged

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
GlobalChoiceName	importmap_isvalidforimport
DefaultValue	False
True Label	Yes
False Label	No

ModifiedBy

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

ModifiedOn

Property	Value
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
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedon
RequiredLevel	SystemRequired
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

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

OwnerIdName

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

OwnerIdYomiName

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

OwningBusinessUnit

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

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
Type	Lookup
Targets	team

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
Type	Lookup
Targets	systemuser

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
DefaultFormValue	0
GlobalChoiceName	importmap_targetentity

TargetEntity Choices/Options

Value	Label
1	Account
2	Contact
5	Note
6	Business Unit Map
7	Owner
8	User
9	Team
10	Business Unit
14	System User Principal
29	Subscription
30	Filter Template
31	Privilege Object Type Code
33	Subscription Synchronization Information
35	Tracking information for deleted entities
36	Client update
37	Subscription Manually Tracked Object
42	SystemUser BusinessUnit Entity Map
44	Field Sharing
45	Subscription Statistic Offline
46	Subscription Statistic Outlook
47	Subscription Sync Entry Offline
48	Subscription Sync Entry Outlook
50	Position
51	System User Manager Map
52	User Search Facet
54	Global Search Configuration
55	FileAttachment
60	SystemUserAuthorizationChangeTracker
72	Record Filter
73	EntityRecordFilter
74	Secured Masking Rule
75	Privilege Checker Run
76	Privilege Checker Log
78	Virtual Entity Data Provider
85	Virtual Entity Data Source
92	Team template
99	Social Profile
101	Service Plan
103	Privileges Removal Setting
126	Indexed Article
127	Article
129	Subject
132	Announcement
135	Activity Party
150	User Settings
300	Canvas App
301	Callback Registration
372	Connector
373	Connection Instance
380	Environment Variable Definition
381	Environment Variable Value
400	AI Template
401	AI Model
402	AI Configuration
418	Dataflow
430	Entity Analytics Config
431	Image Attribute Configuration
432	Entity Image Configuration
950	New Process
951	Translation Process
955	Expired Process
1001	Attachment
1002	Attachment
1003	Internal Address
1007	Image Descriptor
1016	Article Template
1019	Organization
1021	Organization UI
1023	Privilege
1030	System Form
1031	User Dashboard
1036	Security Role
1037	Role Template
1039	View
1043	String Map
1071	Address
1072	Subscription Clients
1075	Status Map
1082	Article Comment
1086	User Fiscal Calendar
1094	Authorization Server
1095	Partner Application
1111	System Chart
1112	User Chart
1113	Ribbon Tab To Command Mapping
1115	Ribbon Context Group
1116	Ribbon Command
1117	Ribbon Rule
1120	Application Ribbons
1130	Ribbon Difference
1140	Replication Backlog
1189	Document Suggestions
1190	SuggestionCardTemplate
1200	Field Security Profile
1201	Field Permission
1203	Team Profiles
1204	Application
1234	Channel Property Group
1236	Channel Property
1300	SocialInsightsConfiguration
1309	Saved Organization Insights Configuration
1400	Sync Attribute Mapping Profile
1401	Sync Attribute Mapping
1403	Team Sync-Attribute Mapping Profiles
1404	Principal Sync Attribute Map
2000	Annual Fiscal Calendar
2001	Semiannual Fiscal Calendar
2002	Quarterly Fiscal Calendar
2003	Monthly Fiscal Calendar
2004	Fixed Monthly Fiscal Calendar
2010	Email Template
2012	Unresolved Address
2013	Territory
2015	Theme
2016	User Mapping
2020	Queue
2023	QueueItemCount
2024	QueueMemberCount
2027	License
2029	Queue Item
2500	User Entity UI Settings
2501	User Entity Instance Data
3000	Integration Status
3005	Channel Access Profile
3008	External Party
3231	Connection Role
3233	Connection Role Object Type Code
3234	Connection
4003	Calendar
4004	Calendar Rule
4011	Inter Process Lock
4023	Email Hash
4101	Display String Map
4102	Display String
4110	Notification
4120	Exchange Sync Id Mapping
4200	Activity
4201	Appointment
4202	Email
4204	Fax
4207	Letter
4210	Phone Call
4212	Task
4216	Social Activity
4220	UntrackedEmail
4230	Saved View
4231	Metadata Difference
4232	Business Data Localized Label
4250	Recurrence Rule
4251	Recurring Appointment
4299	Email Search
4410	Data Import
4411	Data Map
4412	Import Source File
4413	Import Data
4414	Duplicate Detection Rule
4415	Duplicate Record
4416	Duplicate Rule Condition
4417	Column Mapping
4418	List Value Mapping
4419	Lookup Mapping
4420	Owner Mapping
4423	Import Log
4424	Bulk Delete Operation
4425	Bulk Delete Failure
4426	Transformation Mapping
4427	Transformation Parameter Mapping
4428	Import Entity Mapping
4450	Data Performance Dashboard
4490	Office Document
4500	Relationship Role
4501	Relationship Role Map
4502	Customer Relationship
4567	Auditing
4579	Ribbon Client Metadata.
4600	Entity Map
4601	Attribute Map
4602	Plug-in Type
4603	Plug-in Type Statistic
4605	Plug-in Assembly
4606	Sdk Message
4607	Sdk Message Filter
4608	Sdk Message Processing Step
4609	Sdk Message Request
4610	Sdk Message Response
4611	Sdk Message Response Field
4613	Sdk Message Pair
4614	Sdk Message Request Field
4615	Sdk Message Processing Step Image
4616	Sdk Message Processing Step Secure Configuration
4618	Service Endpoint
4619	Plug-in Trace Log
4700	System Job
4702	Workflow Wait Subscription
4703	Process
4704	Process Dependency
4705	ISV Config
4706	Process Log
4707	Application File
4708	Organization Statistic
4709	Site Map
4710	Process Session
4711	Expander Event
4712	Process Trigger
4720	Flow Session
4724	Process Stage
4725	Business Process Flow Instance
4800	Web Wizard
4802	Wizard Page
4803	Web Wizard Access Privilege
4810	Time Zone Definition
4811	Time Zone Rule
4812	Time Zone Localized Name
5000	Recently Used
5004	NL2SQ Registration Information
5006	Event Expander Breadcrumb
7000	System Application Metadata
7001	User Application Metadata
7100	Solution
7101	Publisher
7102	Publisher Address
7103	Solution Component
7104	Solution Component Definition
7105	Dependency
7106	Dependency Node
7107	Invalid Dependency
7108	Dependency Feature
7200	RuntimeDependency
7755	ElasticFileAttachment
8000	Post
8001	Post Role
8002	Post Regarding
8003	Follow
8005	Comment
8006	Like
8040	ACIViewMapper
8050	Trace
8051	Trace Association
8052	Trace Regarding
8181	Routing Rule Set
8199	Rule Item
8700	AppModule Metadata
8701	AppModule Metadata Dependency
8702	AppModule Metadata Async Operation
8840	Hierarchy Rule
9006	Model-driven App
9007	App Module Component
9009	App Module Roles
9011	App Config Master
9012	App Configuration
9013	App Configuration Instance
9100	Report
9101	Report Related Entity
9102	Report Related Category
9103	Report Visibility
9104	Report Link
9105	Currency
9106	Mail Merge Template
9107	Import Job
9201	LocalConfigStore
9300	Record Creation and Update Rule
9301	Record Creation and Update Rule Item
9333	Web Resource
9400	Channel Access Profile Rule
9401	Channel Access Profile Rule Item
9502	SharePoint Site
9507	Sharepoint Document
9508	Document Location
9509	SharePoint Data
9510	Rollup Properties
9511	Rollup Job
9600	Goal
9602	Rollup Query
9603	Goal Metric
9604	Rollup Field
9605	Email Server Profile
9606	Mailbox
9607	Mailbox Statistics
9608	Mailbox Auto Tracking Folder
9609	Mailbox Tracking Category
9650	Process Configuration
9690	Organization Insights Notification
9699	Organization Insights Metric
9750	SLA
9751	SLA Item
9752	SLA KPI Instance
9753	Custom Control
9754	Custom Control Resource
9755	Custom Control Default Config
9800	Entity
9808	Attribute
9809	OptionSet
9810	Entity Key
9811	Entity Relationship
9812	Managed Property
9813	Relationship Entity
9814	Relationship Attribute
9815	Entity Index
9816	Index Attribute
9817	Option Set Value
9820	Secured Masking Column
9866	Mobile Offline Profile
9867	Mobile Offline Profile Item
9868	Mobile Offline Profile Item Association
9869	Sync Error
9870	Offline Command Definition
9875	Language Provisioning State
9880	Ribbon Metadata To Process
9890	SolutionHistoryData
9900	Navigation Setting
9910	MultiEntitySearch
9912	Multi Select Option Value
9919	Hierarchy Security Configuration
9930	Knowledge Base Record
9932	Time Stamp Date Mapping
9936	Azure Service Connection
9940	Document Template
9941	Personal Document Template
9945	Text Analytics Entity Mapping
9947	Knowledge Search Model
9949	Advanced Similarity Rule
9950	Office Graph Document
9951	Similarity Rule
9953	Knowledge Article
9955	Knowledge Article Views
9957	Language
9958	Feedback
9959	Category
9960	Knowledge Article Category
9961	DelveActionHub
9962	Action Card
9968	ActionCardUserState
9973	Action Card User Settings
9983	Action Card Type
9986	Interaction for Email
9987	External Party Item
9996	HolidayWrapper
9997	Email Signature
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
10009	Package History
10011	StageSolutionUpload
10012	ExportSolutionUpload
10013	FeatureControlSetting
10014	Solution Component Summary
10015	Solution Component Count Summary
10016	Solution Component Data Source
10017	Solution Component Count Data Source
10018	Microsoft Entra ID
10019	Staged attribute lookup value
10020	Staged attribute picklist value
10021	Staged Entity
10022	Staged Entity Attribute
10023	Staged entity relationship
10024	Staged entity relationship relationships
10025	Staged entity relationship role
10026	Staged Metadata Async Operation
10027	Staged optionset
10028	Staged relationship
10029	Staged relationship
10030	Staged relationship
10031	Attribute Cluster Config
10032	Entity Cluster Configuration
10033	Key Vault Reference
10034	Managed Identity
10035	Catalog
10036	Catalog Assignment
10037	Internal Catalog Assignment
10038	Custom API
10039	Custom API Request Parameter
10040	Custom API Response Property
10041	Plugin Package
10042	Sensitivity Label
10043	NonRelational Data Source
10044	ProvisionLanguageForUser
10045	Purview Label Info
10046	Purview Label Sync Cache
10047	Sensitivity Label Attribute Mapping
10048	App Notification Signal
10049	Shared Object
10050	Shared Workspace
10051	Shared Workspace Access Token
10052	Shared Workspace Pool
10053	Data Lake Folder
10054	Data Lake Folder Permission
10055	Data Lake Workspace
10056	Data Lake Workspace Permission
10057	Data Processing configuration
10058	Exported Excel
10059	RetainedData Excel
10060	Synapse Database
10061	Synapse Link External Table State
10062	Synapse Link Profile
10063	Synapse Link Profile Entity
10064	Synapse Link Profile Entity State
10065	Synapse Link Schedule
10066	Component Changeset Payload
10067	Component Changeset Version
10068	Component Version
10069	Component Version Data Source
10070	Component Version (Internal)
10071	DataflowRefreshHistory
10072	EntityRefreshHistory
10073	Shared Link Setting
10074	Any Privilege Entity
10075	DelegatedAuthorization
10077	CascadeGrantRevokeAccessRecordsTracker
10078	CascadeGrantRevokeAccessVersionTracker
10079	RevokeInheritedAccessRecordsTracker
10080	TdsMetadata
10081	Model-Driven App Element
10082	Model-Driven App Component Node's Edge
10083	Model-Driven App Component Node
10084	Model-Driven App Setting
10085	Model-Driven App User Setting
10086	Organization Setting
10087	Setting Definition
10088	CanvasApp Extended Metadata
10089	Service Plan Mapping
10090	Service Plan Custom Control
10092	ApplicationUser
10095	Git Branch
10096	Git Configuration Retrieval Data Source
10097	GitHubAppConfig
10098	Git Organization
10099	Git Project
10100	Git Repository
10101	Git Solution
10102	Source Control Branch Configuration
10103	Source Control Component
10104	Source Control Component Payload
10105	Source Control Configuration
10106	Source Control Operation Status
10107	Staged Source Control Component
10108	OData v4 Data Source
10109	Workflow Binary
10110	Business Process
10111	Credential
10112	Desktop Flow Module
10113	Flow Capacity Assignment
10114	Flow Credential Application
10115	Flow Event
10116	Flow Machine
10117	Flow Machine Group
10118	Flow Machine Image
10119	Flow Machine Image Version
10120	Flow Machine Network
10121	Flow Session Binary
10122	ProcessStageParameter
10123	Saving Rule
10124	Tag
10125	Tagged Flow Session
10126	Tagged Process
10127	Workflow Metadata
10128	Work Queue
10129	Work Queue Item
10130	Desktop Flow Binary
10131	Flow Aggregation
10132	Flow Log
10133	Flow Run
10134	Approval Process
10135	Approval Stage Approval
10136	Approval Stage Condition
10137	Approval Stage Intelligent
10138	Approval Stage Order
10139	Action Approval Model
10140	Approval
10141	Approval Request
10142	Approval Response
10143	Approval Step
10144	Await All Action Approval Model
10145	Await All Approval Model
10146	Basic Approval Model Data
10147	Flow Approval
10156	Connection Reference
10157	Knowledge Source Consumer
10158	Knowledge Source Profile
10159	UnstructuredFileSearchEntity
10160	UnstructuredFileSearchRecord
10161	UnstructuredFileSearchRecordStatus
10162	DVFileSearch
10163	DVFileSearchAttribute
10164	DVFileSearchEntity
10165	DVTableSearch
10166	DVTableSearchAttribute
10167	DVTableSearchEntity
10168	AICopilot
10169	AIPluginAuth
10170	AI Plugin Conversation Starter
10171	AI Plugin Conversation Starter Mapping
10172	AI Plugin Governance
10173	AI Plugin Governance Extended
10174	AIPluginOperationResponseTemplate
10175	AIPluginTitle
10176	SideloadedAIPlugin
10177	AIPlugin
10178	AIPluginExternalSchema
10179	AIPluginExternalSchemaProperty
10180	AIPluginInstance
10181	AIPluginOperation
10182	AIPluginOperationParameter
10183	AIPluginUserSetting
10185	AI Configuration Search
10186	Data Processing Event
10187	AI Document Template
10188	AI Event
10189	AI Model Catalog
10191	AI Builder Feedback Loop
10192	AI Form Processing Document
10193	AI Object Detection Image
10194	AI Object Detection Label
10195	AI Object Detection Bounding Box
10196	AI Object Detection Image Mapping
10198	AI Builder Dataset
10199	AI Builder Dataset File
10200	AI Builder Dataset Record
10201	AI Builder Datasets Container
10202	AI Builder File
10203	AI Builder File Attached Data
10204	AI Evaluation Configuration
10205	AI Evaluation Metric
10206	AI Evaluation Run
10207	AI Optimization
10208	AI Optimization Private Data
10209	AI Test Case
10210	AI Test Case Document
10211	AI Test Case Input
10212	AI Test Run
10213	AI Test Run Batch
10214	Help Page
10215	Tour
10216	BotContent
10217	ConversationTranscript
10218	Agent
10219	Agent component
10220	Agent component collection
10231	Comment
10232	Governance Configuration
10233	Fabric AISkill
10234	App Insights Metadata
10235	Dataflow Connection Reference
10236	Schedule
10237	Dataflow Template
10238	Dataflow DatalakeFolder
10239	Data Movement Service Request
10240	Data Movement Service Request Status
10241	DMS Sync Request
10242	DMS Sync Status
10243	Knowledge Asset Configuration
10244	Module Run Detail
10245	QnA
10246	Salesforce Structured Object
10247	Salesforce Structured QnA Config
10248	Workflow Action Status
10249	Allowed MCP Client
10250	FederatedKnowledgeCitation
10251	FederatedKnowledgeConfiguration
10252	FederatedKnowledgeEntityConfiguration
10253	FederatedKnowledgeMetadataRefresh
10254	IntelligentMemory
10255	Knowledge FAQ
10256	Form Mapping
10257	Copilot Interactions
10258	PDF Setting
10259	Activity File Attachment
10260	Teams chat
10261	Service Configuration
10262	SLA KPI
10263	Integrated search provider
10264	Knowledge Management Setting
10265	Knowledge Federated Article
10266	Knowledge Federated Article Incident
10267	Search provider
10268	Knowledge Article Image
10269	Knowledge Configuration
10270	Knowledge Interaction Insight
10271	Knowledge Search Insight
10272	Favorite knowledge article
10273	Knowledge article language setting
10274	Knowledge Article Attachment
10275	Knowledge personalization
10276	Knowledge Article Template
10277	Knowledge search personal filter config
10278	Knowledge search filter
10280	Bulk Harvest Run Log
10281	Harvest Work Item
10282	msdyn_historicalcaseharvestbatch
10283	msdyn_historicalcaseharvestrun
10284	Interim Update Knowledge Article
10285	Knowledge Article Custom Entity
10286	Knowledge Harvest Job Record
10287	SupportUserTable
10288	FxExpression
10289	Function
10290	Plug-in
10291	PowerfxRule
10292	Planner Business Scenario
10293	Planner Sync Action
10294	Agent Rule
10295	MCPPrompt
10296	MCPResource
10297	MCPResourceContent
10298	MCPServer
10299	MCPTool
10300	ToolingGateway
10301	ToolingGatewayMCPServer
10302	Email Address Configuration
10303	Ms Graph Resource To Subscription
10304	Virtual Entity Metadata
10305	Background Operation
10306	Report Parameter
10307	MobileOfflineProfileExtension
10308	MobileOfflineProfileItemFilter
10309	TeamMobileOfflineProfileMembership
10310	UserMobileOfflineProfileMembership
10311	OrganizationDataSyncSubscription
10312	OrganizationDataSyncSubscriptionEntity
10313	OrganizationDataSyncSubscriptionFnoTable
10314	OrganizationDataSyncFnoState
10315	OrganizationDataSyncState
10316	ArchiveCleanupInfo
10317	ArchiveCleanupOperation
10318	BulkArchiveConfig
10319	BulkArchiveFailureDetail
10320	BulkArchiveOperation
10321	BulkArchiveOperationDetail
10322	EnableArchivalRequest
10323	MetadataForArchival
10324	ReconciliationEntityInfo
10325	ReconciliationEntityStepInfo
10326	ReconciliationInfo
10327	RetentionCleanupInfo
10328	RetentionCleanupOperation
10329	Data Life Cycle Config
10330	RetentionFailureDetail
10331	RetentionOperation
10332	RetentionOperationDetail
10333	RetentionSuccessDetail
10334	CertificateCredential
10335	Notification
10336	User Rating
10337	Mobile App
10338	Power Apps Wrap Build
10339	Insights Store Data Source
10340	Insights Store Virtual Entity
10341	RoleEditorLayout
10342	Deleted Record Reference
10343	Restore Deleted Records Configuration
10344	App Action
10345	App Action Migration
10346	App Action Rule
10349	Card
10350	Card State Item
10353	Entity link chat configuration
10354	Agent Feed Item
10355	Agent Hub Goal
10356	Agent Hub Insight
10357	Agent Hub Metric
10358	Agentic Scenario
10359	Agent Memory
10360	Agent Task
10361	SharePoint Managed Identity
10362	AI Insight Card
10363	AI Skill Config
10364	Suggested Action
10365	Suggested Action Criteria
10366	Data Workspace
10367	Plan
10368	Plan Artifact
10369	Plan Attachment
10370	UX Agent Component
10371	UX Agent Component Revision
10372	UX Agent Project
10373	UX Agent Project File
10374	Agent Conversation Message
10375	Agent Conversation Message File
10376	Rich Text Attachment
10377	Structured Template
10378	RTE Template Mapping
10379	Custom Control Extended Setting
10380	Timeline Pin
10381	Virtual Connector Data Source
10382	Virtual Table Column Candidate
10384	PM Analysis History
10385	PM Business Rule Automation Config
10386	PM Calendar
10387	PM Calendar Version
10388	PM Inferred Task
10389	PM Process Extended Metadata Version
10390	PM Process Template
10391	PM Process User Settings
10392	PM Process Version
10393	PM Recording
10394	PM Simulation
10395	PM Tab
10396	PM Template
10397	PM View
10398	Analysis Component
10399	Analysis Job
10400	Analysis Override
10401	Analysis Result
10402	Analysis Result Detail
10403	Solution Health Rule
10404	Solution Health Rule Argument
10405	Solution Health Rule Set
10406	File Upload
10407	AppEntitySearchView
10408	MainFewShot
10409	MakerFewShot
10410	SearchAttributeSettings
10411	SearchCustomAnalyzer
10412	SearchRelationshipSettings
10413	SearchResultsCache
10414	Search Telemetry
10415	TextDataRecordsIndexingStatus
10416	ViewAsExampleQuestion
10417	CopilotExampleQuestion
10418	CopilotGlossaryTerm
10419	CopilotSynonyms
10420	Business Skill
10421	Site Component
10422	Site
10423	Site Language
10424	Power Pages Site Published
10425	Site Source File
10428	External Identity
10429	Invitation
10430	Invite Redemption
10431	Portal Comment
10432	Setting
10433	Multistep Form Session
10437	Ad Placement
10438	Column Permission
10439	Column Permission Profile
10440	Content Snippet
10441	Basic Form
10442	Basic Form Metadata
10443	List
10444	Table Permission
10445	Page Template
10446	Poll Placement
10447	Power Pages Core Entity DS
10448	Publishing State
10449	Publishing State Transition Rule
10450	Redirect
10451	Shortcut
10452	Site Marker
10453	Site Setting
10454	Web File
10455	Multistep Form
10456	Multistep Form Metadata
10457	Form Step
10458	Web Link
10459	Web Link Set
10460	Web Page
10461	Web Page Access Control Rule
10462	Web Role
10463	Website
10464	Website Access
10465	Website Language
10466	Web Template
10473	Power Pages Scan Report
10474	PowerPagesDDOSAlert
10475	Power Pages Log
10476	PowerPagesManagedIdentity
10477	Power Pages Site AI Feedback
10483	Catalog Submission Files
10484	Package Submission Store
10485	indexedtrait
10486	processor registration
10487	signal
10488	signal registration
10489	trait
10490	trait registration
10778	Historical Case Harvest Run Log
10786	Business Skill Resource
10803	Harvest Eligibility Condition
10828	ComputerUseAgent
10829	Flow Test Session
10830	Flow Trigger
10831	Flow Trigger Instance
10832	Business Process Linked Artifact
10833	Flow Group
10834	RTE Structured Template Config
10835	Knowledge Harvest Plan
10836	Agent Prompt
10837	AthenaReconciliationInfo
10839	Eval Result
10840	Source Control Operation Tracking
10841	ControlConfiguration
10842	Location Record
10843	Native Extension
10844	MOS3 Management
10845	Business Skill Metadata
10846	Business Skill Role Mapping
10847	PowerPagesUserMapping
10848	Eval Assertion
10849	Eval Dataset
10850	Eval Prompt
10851	Eval Run

Many-to-One relationships

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

• BusinessUnit_ImportMaps
• lk_importmap_createdonbehalfby
• lk_importmap_modifiedonbehalfby
• lk_importmapbase_createdby
• lk_importmapbase_modifiedby
• owner_importmaps
• SystemUser_ImportMaps
• team_ImportMaps

BusinessUnit_ImportMaps

One-To-Many Relationship: businessunit BusinessUnit_ImportMaps

Property	Value
ReferencedEntity	businessunit
ReferencedAttribute	businessunitid
ReferencingAttribute	owningbusinessunit
ReferencingEntityNavigationPropertyName	owningbusinessunit
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

lk_importmap_createdonbehalfby

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

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

lk_importmapbase_createdby

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

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

owner_importmaps

One-To-Many Relationship: owner owner_importmaps

Property	Value
ReferencedEntity	owner
ReferencedAttribute	ownerid
ReferencingAttribute	ownerid
ReferencingEntityNavigationPropertyName	ownerid
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

SystemUser_ImportMaps

One-To-Many Relationship: systemuser SystemUser_ImportMaps

Property	Value
ReferencedEntity	systemuser
ReferencedAttribute	systemuserid
ReferencingAttribute	owninguser
ReferencingEntityNavigationPropertyName	owninguser
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

team_ImportMaps

One-To-Many Relationship: team team_ImportMaps

Property	Value
ReferencedEntity	team
ReferencedAttribute	teamid
ReferencingAttribute	owningteam
ReferencingEntityNavigationPropertyName	owningteam
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

One-to-Many relationships

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

• ColumnMapping_ImportMap
• ImportEntityMapping_ImportMap
• ImportMap_AsyncOperations
• ImportMap_BulkDeleteFailures
• ImportMap_ImportFile
• ImportMap_SyncErrors
• OwnerMapping_ImportMap
• TransformationMapping_ImportMap

ColumnMapping_ImportMap

Many-To-One Relationship: columnmapping ColumnMapping_ImportMap

Property	Value
ReferencingEntity	columnmapping
ReferencingAttribute	importmapid
ReferencedEntityNavigationPropertyName	ColumnMapping_ImportMap
IsCustomizable	False
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

ImportEntityMapping_ImportMap

Many-To-One Relationship: importentitymapping ImportEntityMapping_ImportMap

Property	Value
ReferencingEntity	importentitymapping
ReferencingAttribute	importmapid
ReferencedEntityNavigationPropertyName	ImportEntityMapping_ImportMap
IsCustomizable	False
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

ImportMap_AsyncOperations

Many-To-One Relationship: asyncoperation ImportMap_AsyncOperations

Property	Value
ReferencingEntity	asyncoperation
ReferencingAttribute	regardingobjectid
ReferencedEntityNavigationPropertyName	ImportMap_AsyncOperations
IsCustomizable	False
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

ImportMap_BulkDeleteFailures

Many-To-One Relationship: bulkdeletefailure ImportMap_BulkDeleteFailures

Property	Value
ReferencingEntity	bulkdeletefailure
ReferencingAttribute	regardingobjectid
ReferencedEntityNavigationPropertyName	ImportMap_BulkDeleteFailures
IsCustomizable	False
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

ImportMap_ImportFile

Many-To-One Relationship: importfile ImportMap_ImportFile

Property	Value
ReferencingEntity	importfile
ReferencingAttribute	importmapid
ReferencedEntityNavigationPropertyName	ImportMap_ImportFile
IsCustomizable	False
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

ImportMap_SyncErrors

Many-To-One Relationship: syncerror ImportMap_SyncErrors

Property	Value
ReferencingEntity	syncerror
ReferencingAttribute	regardingobjectid
ReferencedEntityNavigationPropertyName	ImportMap_SyncErrors
IsCustomizable	True
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

OwnerMapping_ImportMap

Many-To-One Relationship: ownermapping OwnerMapping_ImportMap

Property	Value
ReferencingEntity	ownermapping
ReferencingAttribute	importmapid
ReferencedEntityNavigationPropertyName	OwnerMapping_ImportMap
IsCustomizable	False
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

TransformationMapping_ImportMap

Many-To-One Relationship: transformationmapping TransformationMapping_ImportMap

Property	Value
ReferencingEntity	transformationmapping
ReferencingAttribute	importmapid
ReferencedEntityNavigationPropertyName	TransformationMapping_ImportMap
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
importmap