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

2025-10-31

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	Key Vault Reference
10032	Managed Identity
10033	Catalog
10034	Catalog Assignment
10035	Internal Catalog Assignment
10036	Custom API
10037	Custom API Request Parameter
10038	Custom API Response Property
10039	Plugin Package
10040	Sensitivity Label
10041	NonRelational Data Source
10042	ProvisionLanguageForUser
10043	Purview Label Info
10044	Purview Label Sync Cache
10045	Sensitivity Label Attribute Mapping
10046	Shared Object
10047	Shared Workspace
10048	Shared Workspace Access Token
10049	Shared Workspace Pool
10050	Data Lake Folder
10051	Data Lake Folder Permission
10052	Data Lake Workspace
10053	Data Lake Workspace Permission
10054	Data Processing configuration
10055	Exported Excel
10056	RetainedData Excel
10057	Synapse Database
10058	Synapse Link External Table State
10059	Synapse Link Profile
10060	Synapse Link Profile Entity
10061	Synapse Link Profile Entity State
10062	Synapse Link Schedule
10063	Component Changeset Payload
10064	Component Changeset Version
10065	Component Version
10066	Component Version Data Source
10067	Component Version (Internal)
10068	Git Branch
10069	Git Configuration Retrieval Data Source
10070	Git Organization
10071	Git Project
10072	Git Repository
10073	Git Solution
10074	Source Control Branch Configuration
10075	Source Control Component
10076	Source Control Component Payload
10077	Source Control Configuration
10078	Staged Source Control Component
10079	DataflowRefreshHistory
10080	EntityRefreshHistory
10081	Shared Link Setting
10082	DelegatedAuthorization
10084	CascadeGrantRevokeAccessRecordsTracker
10085	CascadeGrantRevokeAccessVersionTracker
10086	RevokeInheritedAccessRecordsTracker
10087	TdsMetadata
10088	Model-Driven App Element
10089	Model-Driven App Component Node's Edge
10090	Model-Driven App Component Node
10091	Model-Driven App Setting
10092	Model-Driven App User Setting
10093	Organization Setting
10094	Setting Definition
10095	CanvasApp Extended Metadata
10096	Service Plan Mapping
10097	Service Plan Custom Control
10099	ApplicationUser
10102	OData v4 Data Source
10103	Workflow Binary
10104	Business Process
10105	Credential
10106	Desktop Flow Module
10107	Flow Capacity Assignment
10108	Flow Credential Application
10109	Flow Event
10110	Flow Machine
10111	Flow Machine Group
10112	Flow Machine Image
10113	Flow Machine Image Version
10114	Flow Machine Network
10115	Flow Session Binary
10116	ProcessStageParameter
10117	Saving Rule
10118	Tag
10119	Tagged Flow Session
10120	Tagged Process
10121	Workflow Metadata
10122	Work Queue
10123	Work Queue Item
10124	Desktop Flow Binary
10125	Flow Aggregation
10126	Flow Log
10127	Flow Run
10128	Approval Process
10129	Approval Stage Approval
10130	Approval Stage Condition
10131	Approval Stage Intelligent
10132	Approval Stage Order
10133	Action Approval Model
10134	Approval
10135	Approval Request
10136	Approval Response
10137	Approval Step
10138	Await All Action Approval Model
10139	Await All Approval Model
10140	Basic Approval Model Data
10141	Flow Approval
10150	Connection Reference
10151	Knowledge Source Consumer
10152	Knowledge Source Profile
10153	UnstructuredFileSearchEntity
10154	UnstructuredFileSearchRecord
10155	DVFileSearch
10156	DVFileSearchAttribute
10157	DVFileSearchEntity
10158	DVTableSearch
10159	DVTableSearchAttribute
10160	DVTableSearchEntity
10161	AICopilot
10162	AIPluginAuth
10163	AI Plugin Conversation Starter
10164	AI Plugin Conversation Starter Mapping
10165	AI Plugin Governance
10166	AI Plugin Governance Extended
10167	AIPluginOperationResponseTemplate
10168	AIPluginTitle
10169	SideloadedAIPlugin
10170	AIPlugin
10171	AIPluginExternalSchema
10172	AIPluginExternalSchemaProperty
10173	AIPluginInstance
10174	AIPluginOperation
10175	AIPluginOperationParameter
10176	AIPluginUserSetting
10178	AI Configuration Search
10179	Data Processing Event
10180	AI Document Template
10181	AI Event
10182	AI Model Catalog
10184	AI Builder Feedback Loop
10185	AI Form Processing Document
10186	AI Object Detection Image
10187	AI Object Detection Label
10188	AI Object Detection Bounding Box
10189	AI Object Detection Image Mapping
10191	AI Builder Dataset
10192	AI Builder Dataset File
10193	AI Builder Dataset Record
10194	AI Builder Datasets Container
10195	AI Builder File
10196	AI Builder File Attached Data
10197	AI Evaluation Configuration
10198	AI Evaluation Metric
10199	AI Evaluation Run
10200	AI Optimization
10201	AI Optimization Private Data
10202	AI Test Case
10203	AI Test Case Document
10204	AI Test Case Input
10205	AI Test Run
10206	AI Test Run Batch
10207	Help Page
10208	Tour
10209	BotContent
10210	ConversationTranscript
10211	Copilot
10212	Copilot component
10213	Copilot component collection
10224	Comment
10225	Governance Configuration
10226	Fabric AISkill
10227	App Insights Metadata
10228	Dataflow Connection Reference
10229	Schedule
10230	Dataflow Template
10231	Dataflow DatalakeFolder
10232	Data Movement Service Request
10233	Data Movement Service Request Status
10234	DMS Sync Request
10235	DMS Sync Status
10236	Knowledge Asset Configuration
10237	Module Run Detail
10238	QnA
10239	Salesforce Structured Object
10240	Salesforce Structured QnA Config
10241	Workflow Action Status
10242	Allowed MCP Client
10243	FederatedKnowledgeCitation
10244	FederatedKnowledgeConfiguration
10245	FederatedKnowledgeEntityConfiguration
10246	FederatedKnowledgeMetadataRefresh
10247	IntelligentMemory
10248	Knowledge FAQ
10249	Form Mapping
10250	Copilot Interactions
10251	PDF Setting
10252	Activity File Attachment
10253	Teams chat
10254	Service Configuration
10255	SLA KPI
10256	Integrated search provider
10257	Knowledge Management Setting
10258	Knowledge Federated Article
10259	Knowledge Federated Article Incident
10260	Search provider
10261	Knowledge Article Image
10262	Knowledge Configuration
10263	Knowledge Interaction Insight
10264	Knowledge Search Insight
10265	Favorite knowledge article
10266	Knowledge article language setting
10267	Knowledge Article Attachment
10268	Knowledge personalization
10269	Knowledge Article Template
10270	Knowledge search personal filter config
10271	Knowledge search filter
10273	msdyn_historicalcaseharvestbatch
10274	msdyn_historicalcaseharvestrun
10275	Interim Update Knowledge Article
10276	Knowledge Article Custom Entity
10277	Knowledge Harvest Job Record
10278	Attribute Cluster Config
10279	Entity Cluster Configuration
10280	SupportUserTable
10281	FxExpression
10282	Function
10283	Plug-in
10284	PowerfxRule
10285	Planner Business Scenario
10286	Planner Sync Action
10287	Email Address Configuration
10288	Ms Graph Resource To Subscription
10289	Virtual Entity Metadata
10290	Background Operation
10291	Report Parameter
10292	MobileOfflineProfileExtension
10293	MobileOfflineProfileItemFilter
10294	TeamMobileOfflineProfileMembership
10295	UserMobileOfflineProfileMembership
10296	OrganizationDataSyncSubscription
10297	OrganizationDataSyncSubscriptionEntity
10298	OrganizationDataSyncSubscriptionFnoTable
10299	OrganizationDataSyncFnoState
10300	OrganizationDataSyncState
10301	ArchiveCleanupInfo
10302	ArchiveCleanupOperation
10303	BulkArchiveConfig
10304	BulkArchiveFailureDetail
10305	BulkArchiveOperation
10306	BulkArchiveOperationDetail
10307	EnableArchivalRequest
10308	MetadataForArchival
10309	ReconciliationEntityInfo
10310	ReconciliationEntityStepInfo
10311	ReconciliationInfo
10312	RetentionCleanupInfo
10313	RetentionCleanupOperation
10314	RetentionConfig
10315	RetentionFailureDetail
10316	RetentionOperation
10317	RetentionOperationDetail
10318	RetentionSuccessDetail
10319	CertificateCredential
10320	Notification
10321	User Rating
10322	Mobile App
10323	Insights Store Data Source
10324	Insights Store Virtual Entity
10325	RoleEditorLayout
10326	Deleted Record Reference
10327	Restore Deleted Records Configuration
10328	App Action
10329	App Action Migration
10330	App Action Rule
10333	Card
10334	Card State Item
10337	Entity link chat configuration
10338	SharePoint Managed Identity
10339	AI Insight Card
10340	AI Skill Config
10341	Suggested Action
10342	Suggested Action Criteria
10343	Data Workspace
10344	Plan
10345	Plan Artifact
10346	Plan Attachment
10347	UX Agent Component
10348	UX Agent Component Revision
10349	UX Agent Project
10350	UX Agent Project File
10351	Agent Conversation Message
10352	Agent Conversation Message File
10353	Rich Text Attachment
10354	Custom Control Extended Setting
10355	Timeline Pin
10356	Virtual Connector Data Source
10357	Virtual Table Column Candidate
10359	PM Analysis History
10360	PM Business Rule Automation Config
10361	PM Calendar
10362	PM Calendar Version
10363	PM Inferred Task
10364	PM Process Extended Metadata Version
10365	PM Process Template
10366	PM Process User Settings
10367	PM Process Version
10368	PM Recording
10369	PM Simulation
10370	PM Tab
10371	PM Template
10372	PM View
10373	Analysis Component
10374	Analysis Job
10375	Analysis Override
10376	Analysis Result
10377	Analysis Result Detail
10378	Solution Health Rule
10379	Solution Health Rule Argument
10380	Solution Health Rule Set
10381	Power BI Dataset
10382	powerbidatasetapdx
10383	Power BI Mashup Parameter
10384	Power BI Report
10385	powerbireportapdx
10386	File Upload
10387	AppEntitySearchView
10388	MainFewShot
10389	MakerFewShot
10390	SearchAttributeSettings
10391	SearchCustomAnalyzer
10392	SearchRelationshipSettings
10393	SearchResultsCache
10394	Search Telemetry
10395	TextDataRecordsIndexingStatus
10396	ViewAsExampleQuestion
10397	CopilotExampleQuestion
10398	CopilotGlossaryTerm
10399	CopilotSynonyms
10400	Site Component
10401	Site
10402	Site Language
10403	Power Pages Site Published
10404	Site Source File
10407	External Identity
10408	Invitation
10409	Invite Redemption
10410	Portal Comment
10411	Setting
10412	Multistep Form Session
10416	Ad Placement
10417	Column Permission
10418	Column Permission Profile
10419	Content Snippet
10420	Basic Form
10421	Basic Form Metadata
10422	List
10423	Table Permission
10424	Page Template
10425	Poll Placement
10426	Power Pages Core Entity DS
10427	Publishing State
10428	Publishing State Transition Rule
10429	Redirect
10430	Shortcut
10431	Site Marker
10432	Site Setting
10433	Web File
10434	Multistep Form
10435	Multistep Form Metadata
10436	Form Step
10437	Web Link
10438	Web Link Set
10439	Web Page
10440	Web Page Access Control Rule
10441	Web Role
10442	Website
10443	Website Access
10444	Website Language
10445	Web Template
10452	Power Pages Scan Report
10453	PowerPagesDDOSAlert
10454	Power Pages Log
10455	PowerPagesManagedIdentity
10456	Power Pages Site AI Feedback
10462	Catalog Submission Files
10463	Package Submission Store
10464	indexedtrait
10465	processor registration
10466	signal
10467	signal registration
10468	trait
10469	trait registration

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`

Feedback

Was this page helpful?