Data Map (ImportMap) table/entity reference

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
Create Event: False	POST /importmaps See Create	Create records
Delete Event: False	DELETE /importmaps(importmapid) See Delete	Delete 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
61	PrincipalEntityBusinessUnitMap
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
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
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 Entity
10020	Staged Entity Attribute
10021	Staged Metadata Async Operation
10022	Key Vault Reference
10023	Managed Identity
10024	Catalog
10025	Catalog Assignment
10026	Internal Catalog Assignment
10027	Custom API
10028	Custom API Request Parameter
10029	Custom API Response Property
10030	Plugin Package
10031	NonRelational Data Source
10032	ProvisionLanguageForUser
10033	Shared Object
10034	Shared Workspace
10035	Shared Workspace Access Token
10036	Shared Workspace Pool
10037	Data Lake Folder
10038	Data Lake Folder Permission
10039	Data Lake Workspace
10040	Data Lake Workspace Permission
10041	Data Processing configuration
10042	Exported Excel
10043	RetainedData Excel
10044	Synapse Database
10045	Synapse Link External Table State
10046	Synapse Link Profile
10047	Synapse Link Profile Entity
10048	Synapse Link Profile Entity State
10049	Synapse Link Schedule
10050	Component Version
10051	Component Version Data Source
10052	Component Version (Internal)
10053	Git Branch
10054	Git Configuration Retrieval Data Source
10055	Git Organization
10056	Git Project
10057	Git Repository
10058	Source Control Branch Configuration
10059	Source Control Component
10060	Source Control Component Payload
10061	Source Control Configuration
10062	DataflowRefreshHistory
10063	EntityRefreshHistory
10064	Shared Link Setting
10065	DelegatedAuthorization
10067	CascadeGrantRevokeAccessRecordsTracker
10068	CascadeGrantRevokeAccessVersionTracker
10069	RevokeInheritedAccessRecordsTracker
10070	TdsMetadata
10071	Model-Driven App Element
10072	Model-Driven App Component Node's Edge
10073	Model-Driven App Component Node
10074	Model-Driven App Setting
10075	Model-Driven App User Setting
10076	Organization Setting
10077	Setting Definition
10078	CanvasApp Extended Metadata
10079	Service Plan Mapping
10080	Service Plan Custom Control
10082	ApplicationUser
10085	OData v4 Data Source
10086	Workflow Binary
10087	Credential
10088	Desktop Flow Module
10089	Flow Capacity Assignment
10090	Flow Credential Application
10091	Flow Event
10092	Flow Machine
10093	Flow Machine Group
10094	Flow Machine Image
10095	Flow Machine Image Version
10096	Flow Machine Network
10097	ProcessStageParameter
10098	Work Queue
10099	Work Queue Item
10100	Desktop Flow Binary
10101	Flow Log
10102	Flow Run
10103	Action Approval Model
10104	Approval
10105	Approval Request
10106	Approval Response
10107	Approval Step
10108	Await All Action Approval Model
10109	Await All Approval Model
10110	Basic Approval Model Data
10111	Flow Approval
10120	Connection Reference
10121	DVFileSearch
10122	DVFileSearchAttribute
10123	DVFileSearchEntity
10124	DVTableSearch
10125	DVTableSearchAttribute
10126	DVTableSearchEntity
10127	AICopilot
10128	AIPluginAuth
10129	AI Plugin Conversation Starter
10130	AI Plugin Conversation Starter Mapping
10131	AI Plugin Governance
10132	AI Plugin Governance Extended
10133	AIPluginOperationResponseTemplate
10134	AIPluginTitle
10135	SideloadedAIPlugin
10136	AIPlugin
10137	AIPluginExternalSchema
10138	AIPluginExternalSchemaProperty
10139	AIPluginInstance
10140	AIPluginOperation
10141	AIPluginOperationParameter
10142	AIPluginUserSetting
10144	AI Event
10145	AI Builder Feedback Loop
10146	AI Form Processing Document
10147	AI Object Detection Image
10148	AI Object Detection Label
10149	AI Object Detection Bounding Box
10150	AI Object Detection Image Mapping
10152	AI Builder Dataset
10153	AI Builder Dataset File
10154	AI Builder Dataset Record
10155	AI Builder Datasets Container
10156	AI Builder File
10157	AI Builder File Attached Data
10158	Help Page
10159	Tour
10160	BotContent
10161	ConversationTranscript
10162	Copilot
10163	Copilot component
10164	Copilot component collection
10175	Comment
10176	Governance Configuration
10177	Fabric AISkill
10178	App Insights Metadata
10179	Dataflow Connection Reference
10180	Schedule
10181	Dataflow Template
10182	Dataflow DatalakeFolder
10183	Data Movement Service Request
10184	Data Movement Service Request Status
10185	DMS Sync Request
10186	DMS Sync Status
10187	Knowledge Asset Configuration
10188	Module Run Detail
10189	Salesforce Structured Object
10190	Salesforce Structured QnA Config
10191	Workflow Action Status
10192	FederatedKnowledgeConfiguration
10193	FederatedKnowledgeEntityConfiguration
10194	Form Mapping
10195	PDF Setting
10196	Activity File Attachment
10197	Teams chat
10198	Service Configuration
10199	SLA KPI
10200	Integrated search provider
10201	Knowledge Management Setting
10202	Knowledge Federated Article
10203	Knowledge Federated Article Incident
10204	Search provider
10205	Knowledge Article Image
10206	Knowledge Configuration
10207	Knowledge Interaction Insight
10208	Knowledge Search Insight
10209	Favorite knowledge article
10210	Knowledge article language setting
10211	Knowledge Article Attachment
10212	Knowledge personalization
10213	Knowledge Article Template
10214	Knowledge search personal filter config
10215	Knowledge search filter
10217	msdyn_historicalcaseharvestbatch
10218	msdyn_historicalcaseharvestrun
10219	Knowledge Harvest Job Record
10220	SupportUserTable
10221	FxExpression
10222	Plug-in
10223	PowerfxRule
10224	Planner Business Scenario
10225	Planner Sync Action
10226	Ms Graph Resource To Subscription
10227	Virtual Entity Metadata
10228	Background Operation
10229	Report Parameter
10230	MobileOfflineProfileExtension
10231	MobileOfflineProfileItemFilter
10232	TeamMobileOfflineProfileMembership
10233	UserMobileOfflineProfileMembership
10234	OrganizationDataSyncSubscription
10235	OrganizationDataSyncSubscriptionEntity
10236	OrganizationDataSyncSubscriptionFnoTable
10237	OrganizationDataSyncFnoState
10238	OrganizationDataSyncState
10239	ArchiveCleanupInfo
10240	ArchiveCleanupOperation
10241	BulkArchiveConfig
10242	BulkArchiveFailureDetail
10243	BulkArchiveOperation
10244	BulkArchiveOperationDetail
10245	EnableArchivalRequest
10246	MetadataForArchival
10247	ReconciliationEntityInfo
10248	ReconciliationEntityStepInfo
10249	ReconciliationInfo
10250	RetentionCleanupInfo
10251	RetentionCleanupOperation
10252	RetentionConfig
10253	RetentionFailureDetail
10254	RetentionOperation
10255	RetentionOperationDetail
10256	RetentionSuccessDetail
10257	CertificateCredential
10258	Notification
10259	User Rating
10260	Mobile App
10261	Insights Store Data Source
10262	Insights Store Virtual Entity
10263	RoleEditorLayout
10264	Deleted Record Reference
10265	Restore Deleted Records Configuration
10266	App Action
10267	App Action Migration
10268	App Action Rule
10271	Card
10272	Card State Item
10275	Entity link chat configuration
10276	AI Skill Config
10277	Rich Text Attachment
10278	Custom Control Extended Setting
10279	Timeline Pin
10280	Virtual Connector Data Source
10281	Virtual Table Column Candidate
10283	PM Analysis History
10284	PM Business Rule Automation Config
10285	PM Calendar
10286	PM Calendar Version
10287	PM Inferred Task
10288	PM Process Extended Metadata Version
10289	PM Process Template
10290	PM Process User Settings
10291	PM Process Version
10292	PM Recording
10293	PM Simulation
10294	PM Template
10295	PM View
10296	Analysis Component
10297	Analysis Job
10298	Analysis Override
10299	Analysis Result
10300	Analysis Result Detail
10301	Solution Health Rule
10302	Solution Health Rule Argument
10303	Solution Health Rule Set
10304	Power BI Dataset
10305	powerbidatasetapdx
10306	Power BI Mashup Parameter
10307	Power BI Report
10308	powerbireportapdx
10309	File Upload
10310	MainFewShot
10311	MakerFewShot
10312	SearchAttributeSettings
10313	SearchCustomAnalyzer
10314	SearchRelationshipSettings
10315	SearchResultsCache
10316	Search Telemetry
10317	ViewAsExampleQuestion
10318	CopilotExampleQuestion
10319	CopilotGlossaryTerm
10320	CopilotSynonyms
10321	API Request Cache
10322	API Request Folder
10323	Site Component
10324	Site
10325	Site Language
10326	Power Pages Site Published
10329	External Identity
10330	Invitation
10331	Invite Redemption
10332	Portal Comment
10333	Setting
10334	Multistep Form Session
10338	Ad Placement
10339	Column Permission
10340	Column Permission Profile
10341	Content Snippet
10342	Basic Form
10343	Basic Form Metadata
10344	List
10345	Table Permission
10346	Page Template
10347	Poll Placement
10348	Power Pages Core Entity DS
10349	Publishing State
10350	Publishing State Transition Rule
10351	Redirect
10352	Shortcut
10353	Site Marker
10354	Site Setting
10355	Web File
10356	Multistep Form
10357	Multistep Form Metadata
10358	Form Step
10359	Web Link
10360	Web Link Set
10361	Web Page
10362	Web Page Access Control Rule
10363	Web Role
10364	Website
10365	Website Access
10366	Website Language
10367	Web Template
10374	Power Pages Scan Report
10375	Power Pages Log
10376	PowerPagesManagedIdentity
10377	Power Pages Site AI Feedback
10382	Catalog Submission Files
10383	Package Submission Store
18085	Event Expander Breadcrumb

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