Duplicate Detection Rule (DuplicateRule) table/entity reference

Rule used to identify potential duplicates.

Messages

The following table lists the messages for the Duplicate Detection Rule (DuplicateRule) 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 /duplicaterules(duplicateruleid) Update the ownerid property.	AssignRequest
CompoundCreate Event: False		CompoundCreateRequest
CompoundUpdateDuplicateDetectionRule Event: False	CompoundUpdateDuplicateDetectionRule	CompoundUpdateDuplicateDetectionRuleRequest
Create Event: False	POST /duplicaterules See Create	Create records
Delete Event: False	DELETE /duplicaterules(duplicateruleid) See Delete	Delete records
GrantAccess Event: False	GrantAccess	GrantAccessRequest
ModifyAccess Event: False	ModifyAccess	ModifyAccessRequest
PublishDuplicateRule Event: False	PublishDuplicateRule	PublishDuplicateRuleRequest
PublishXml Event: False	PublishXml	PublishXmlRequest
Retrieve Event: False	GET /duplicaterules(duplicateruleid) See Retrieve	Retrieve records
RetrieveMultiple Event: False	GET /duplicaterules See Query data	Query data
RetrievePrincipalAccess Event: False	RetrievePrincipalAccess	RetrievePrincipalAccessRequest
RetrieveSharedPrincipalsAndAccess Event: False	RetrieveSharedPrincipalsAndAccess	RetrieveSharedPrincipalsAndAccessRequest
RevokeAccess Event: False	RevokeAccess	RevokeAccessRequest
UnpublishDuplicateRule Event: False	UnpublishDuplicateRule	UnpublishDuplicateRuleRequest
Update Event: False	PATCH /duplicaterules(duplicateruleid) See Update	Update records
Upsert Event: False	PATCH /duplicaterules(duplicateruleid) See Upsert a table row	UpsertRequest

Properties

The following table lists selected properties for the Duplicate Detection Rule (DuplicateRule) table.

Property	Value
DisplayName	Duplicate Detection Rule
DisplayCollectionName	Duplicate Detection Rules
SchemaName	DuplicateRule
CollectionSchemaName	DuplicateRules
EntitySetName	duplicaterules
LogicalName	duplicaterule
LogicalCollectionName	duplicaterules
PrimaryIdAttribute	duplicateruleid
PrimaryNameAttribute	name
TableType	Standard
OwnershipType	UserOwned

Writable columns/attributes

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

• BaseEntityName
• Description
• DuplicateRuleId
• ExcludeInactiveRecords
• IsCaseSensitive
• IsCustomizable
• MatchingEntityName
• Name
• OwnerId
• OwnerIdType
• StatusCode
• TimeZoneRuleVersionNumber
• UniqueName
• UTCConversionTimeZoneCode

BaseEntityName

Property	Value
Description	Record type of the record being evaluated for potential duplicates.
DisplayName	Base Record Type
IsValidForForm	False
IsValidForRead	True
LogicalName	baseentityname
RequiredLevel	ApplicationRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	160

Description

Property	Value
Description	Description of the duplicate detection rule.
DisplayName	Description
IsValidForForm	True
IsValidForRead	True
LogicalName	description
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	2000

DuplicateRuleId

Property	Value
Description	Unique identifier of the duplicate detection rule.
DisplayName	Duplicate Detection Rule
IsValidForForm	False
IsValidForRead	True
LogicalName	duplicateruleid
RequiredLevel	SystemRequired
Type	Uniqueidentifier

ExcludeInactiveRecords

Property	Value
Description	Determines whether to flag inactive records as duplicates
DisplayName	Exclude Inactive Records
IsValidForForm	True
IsValidForRead	True
LogicalName	excludeinactiverecords
RequiredLevel	None
Type	Boolean
GlobalChoiceName	duplicaterule_excludeinactiverecords
DefaultValue	False
True Label	True
False Label	False

IsCaseSensitive

Property	Value
Description	Indicates if the operator is case-sensitive.
DisplayName	Case Sensitive
IsValidForForm	True
IsValidForRead	True
LogicalName	iscasesensitive
RequiredLevel	None
Type	Boolean
GlobalChoiceName	duplicaterule_iscasesensitive
DefaultValue	False
True Label	True
False Label	False

IsCustomizable

Property	Value
Description	For internal use only.
DisplayName	Is Customizable
IsValidForForm	False
IsValidForRead	True
LogicalName	iscustomizable
RequiredLevel	SystemRequired
Type	ManagedProperty

MatchingEntityName

Property	Value
Description	Record type of the records being evaluated as potential duplicates.
DisplayName	Matching Record Type
IsValidForForm	False
IsValidForRead	True
LogicalName	matchingentityname
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	160

Name

Property	Value
Description	Name of the duplicate detection rule.
DisplayName	Rule Name
IsValidForForm	True
IsValidForRead	True
LogicalName	name
RequiredLevel	SystemRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	160

OwnerId

Property	Value
Description	Unique identifier of the user or team who owns the duplicate detection rule.
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

StatusCode

Property	Value
Description	Reason for the status of the duplicate detection rule.
DisplayName	Status Reason
IsValidForForm	True
IsValidForRead	True
LogicalName	statuscode
RequiredLevel	SystemRequired
Type	Status
DefaultFormValue	-1
GlobalChoiceName	duplicaterule_statuscode

StatusCode Choices/Options

Value	Details
0	Label: Unpublished State:0 TransitionData: None
1	Label: Publishing State:0 TransitionData: None
2	Label: Published State:1 TransitionData: None

TimeZoneRuleVersionNumber

Property	Value
Description	For internal use only.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	timezoneruleversionnumber
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-1

UniqueName

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

UTCConversionTimeZoneCode

Property	Value
Description	Time zone code that was in use when the record was created.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	utcconversiontimezonecode
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-1

Read-only columns/attributes

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

• BaseEntityMatchCodeTable
• BaseEntityTypeCode
• ComponentIdUnique
• ComponentState
• CreatedBy
• CreatedOn
• CreatedOnBehalfBy
• IsManaged
• MatchingEntityMatchCodeTable
• MatchingEntityTypeCode
• ModifiedBy
• ModifiedOn
• ModifiedOnBehalfBy
• OverwriteTime
• OwnerIdName
• OwnerIdYomiName
• OwningBusinessUnit
• OwningTeam
• OwningUser
• SolutionId
• StateCode
• SupportingSolutionId

BaseEntityMatchCodeTable

Property	Value
Description	Database table that stores match codes for the record type being evaluated for potential duplicates.
DisplayName	Base Record Type Match Code Table
IsValidForForm	False
IsValidForRead	True
LogicalName	baseentitymatchcodetable
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	50

BaseEntityTypeCode

Property	Value
Description	Record type of the record being evaluated for potential duplicates.
DisplayName	Base Record Type
IsValidForForm	True
IsValidForRead	True
LogicalName	baseentitytypecode
RequiredLevel	SystemRequired
Type	Picklist
DefaultFormValue	0
GlobalChoiceName	duplicaterule_baseentitytypecode

BaseEntityTypeCode 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 Pool
10036	Data Lake Folder
10037	Data Lake Folder Permission
10038	Data Lake Workspace
10039	Data Lake Workspace Permission
10040	Data Processing configuration
10041	Exported Excel
10042	RetainedData Excel
10043	Synapse Database
10044	Synapse Link External Table State
10045	Synapse Link Profile
10046	Synapse Link Profile Entity
10047	Synapse Link Profile Entity State
10048	Synapse Link Schedule
10049	Component Version
10050	Component Version Data Source
10051	Component Version (Internal)
10052	DataflowRefreshHistory
10053	EntityRefreshHistory
10054	Shared Link Setting
10055	DelegatedAuthorization
10057	CascadeGrantRevokeAccessRecordsTracker
10058	CascadeGrantRevokeAccessVersionTracker
10059	RevokeInheritedAccessRecordsTracker
10060	TdsMetadata
10061	Model-Driven App Element
10062	Model-Driven App Component Node's Edge
10063	Model-Driven App Component Node
10064	Model-Driven App Setting
10065	Model-Driven App User Setting
10066	Organization Setting
10067	Setting Definition
10068	CanvasApp Extended Metadata
10069	Service Plan Mapping
10070	Service Plan Custom Control
10072	ApplicationUser
10075	OData v4 Data Source
10076	Workflow Binary
10077	Credential
10078	Desktop Flow Module
10079	Flow Capacity Assignment
10080	Flow Credential Application
10081	Flow Event
10082	Flow Machine
10083	Flow Machine Group
10084	Flow Machine Image
10085	Flow Machine Image Version
10086	Flow Machine Network
10087	ProcessStageParameter
10088	Work Queue
10089	Work Queue Item
10090	Desktop Flow Binary
10091	Flow Log
10092	Flow Run
10093	Action Approval Model
10094	Approval
10095	Approval Request
10096	Approval Response
10097	Approval Step
10098	Await All Action Approval Model
10099	Await All Approval Model
10100	Basic Approval Model Data
10101	Flow Approval
10110	Connection Reference
10111	DVFileSearch
10112	DVFileSearchAttribute
10113	DVFileSearchEntity
10114	DVTableSearch
10115	DVTableSearchAttribute
10116	DVTableSearchEntity
10117	AICopilot
10118	AIPluginAuth
10119	AI Plugin Conversation Starter
10120	AI Plugin Conversation Starter Mapping
10121	AI Plugin Governance
10122	AI Plugin Governance Extended
10123	AIPluginOperationResponseTemplate
10124	AIPluginTitle
10125	SideloadedAIPlugin
10126	AIPlugin
10127	AIPluginExternalSchema
10128	AIPluginExternalSchemaProperty
10129	AIPluginInstance
10130	AIPluginOperation
10131	AIPluginOperationParameter
10132	AIPluginUserSetting
10134	AI Event
10135	AI Builder Feedback Loop
10136	AI Form Processing Document
10137	AI Object Detection Image
10138	AI Object Detection Label
10139	AI Object Detection Bounding Box
10140	AI Object Detection Image Mapping
10142	AI Builder Dataset
10143	AI Builder Dataset File
10144	AI Builder Dataset Record
10145	AI Builder Datasets Container
10146	AI Builder File
10147	AI Builder File Attached Data
10148	Help Page
10149	Tour
10150	BotContent
10151	ConversationTranscript
10152	Copilot
10153	Copilot component
10154	Copilot component collection
10165	Comment
10166	Fabric AISkill
10167	App Insights Metadata
10168	Dataflow Connection Reference
10169	Schedule
10170	Dataflow Template
10171	Dataflow DatalakeFolder
10172	Data Movement Service Request
10173	Data Movement Service Request Status
10174	DMS Sync Request
10175	DMS Sync Status
10176	Knowledge Asset Configuration
10177	Module Run Detail
10178	Salesforce Structured Object
10179	Salesforce Structured QnA Config
10180	Workflow Action Status
10181	FederatedKnowledgeConfiguration
10182	FederatedKnowledgeEntityConfiguration
10183	PDF Setting
10184	Activity File Attachment
10185	Teams chat
10186	Service Configuration
10187	SLA KPI
10188	Integrated search provider
10189	Knowledge Management Setting
10190	Knowledge Federated Article
10191	Knowledge Federated Article Incident
10192	Search provider
10193	Knowledge Article Image
10194	Knowledge Configuration
10195	Knowledge Interaction Insight
10196	Knowledge Search Insight
10197	Favorite knowledge article
10198	Knowledge article language setting
10199	Knowledge Article Attachment
10200	Knowledge personalization
10201	Knowledge Article Template
10202	Knowledge search personal filter config
10203	Knowledge search filter
10205	SupportUserTable
10206	FxExpression
10207	PowerfxRule
10208	Planner Business Scenario
10209	Planner Sync Action
10210	Ms Graph Resource To Subscription
10211	Virtual Entity Metadata
10212	Background Operation
10213	Report Parameter
10214	MobileOfflineProfileExtension
10215	MobileOfflineProfileItemFilter
10216	TeamMobileOfflineProfileMembership
10217	UserMobileOfflineProfileMembership
10218	OrganizationDataSyncSubscription
10219	OrganizationDataSyncSubscriptionEntity
10220	OrganizationDataSyncSubscriptionFnoTable
10221	OrganizationDataSyncFnoState
10222	OrganizationDataSyncState
10223	ArchiveCleanupInfo
10224	ArchiveCleanupOperation
10225	BulkArchiveConfig
10226	BulkArchiveFailureDetail
10227	BulkArchiveOperation
10228	BulkArchiveOperationDetail
10229	EnableArchivalRequest
10230	MetadataForArchival
10231	ReconciliationEntityInfo
10232	ReconciliationEntityStepInfo
10233	ReconciliationInfo
10234	RetentionCleanupInfo
10235	RetentionCleanupOperation
10236	RetentionConfig
10237	RetentionFailureDetail
10238	RetentionOperation
10239	RetentionOperationDetail
10240	Notification
10241	User Rating
10242	Mobile App
10243	Insights Store Data Source
10244	Insights Store Virtual Entity
10245	RoleEditorLayout
10246	Deleted Record Reference
10247	Restore Deleted Records Configuration
10248	App Action
10249	App Action Migration
10250	App Action Rule
10253	Card
10254	Card State Item
10257	Entity link chat configuration
10258	Rich Text Attachment
10259	Custom Control Extended Setting
10260	Timeline Pin
10261	Virtual Connector Data Source
10262	Virtual Table Column Candidate
10264	PM Analysis History
10265	PM Business Rule Automation Config
10266	PM Calendar
10267	PM Calendar Version
10268	PM Inferred Task
10269	PM Process Extended Metadata Version
10270	PM Process Template
10271	PM Process User Settings
10272	PM Process Version
10273	PM Recording
10274	PM Simulation
10275	PM Template
10276	PM View
10277	Analysis Component
10278	Analysis Job
10279	Analysis Override
10280	Analysis Result
10281	Analysis Result Detail
10282	Solution Health Rule
10283	Solution Health Rule Argument
10284	Solution Health Rule Set
10285	Power BI Dataset
10286	powerbidatasetapdx
10287	Power BI Mashup Parameter
10288	Power BI Report
10289	powerbireportapdx
10290	File Upload
10291	MainFewShot
10292	MakerFewShot
10293	SearchAttributeSettings
10294	SearchCustomAnalyzer
10295	SearchRelationshipSettings
10296	SearchResultsCache
10297	Search Telemetry
10298	ViewAsExampleQuestion
10299	CopilotExampleQuestion
10300	CopilotGlossaryTerm
10301	CopilotSynonyms
10302	Site Component
10303	Site
10304	Site Language
10305	Power Pages Site Published
10308	External Identity
10309	Invitation
10310	Invite Redemption
10311	Portal Comment
10312	Setting
10313	Multistep Form Session
10317	Ad Placement
10318	Column Permission
10319	Column Permission Profile
10320	Content Snippet
10321	Basic Form
10322	Basic Form Metadata
10323	List
10324	Table Permission
10325	Page Template
10326	Poll Placement
10327	Power Pages Core Entity DS
10328	Publishing State
10329	Publishing State Transition Rule
10330	Redirect
10331	Shortcut
10332	Site Marker
10333	Site Setting
10334	Web File
10335	Multistep Form
10336	Multistep Form Metadata
10337	Form Step
10338	Web Link
10339	Web Link Set
10340	Web Page
10341	Web Page Access Control Rule
10342	Web Role
10343	Website
10344	Website Access
10345	Website Language
10346	Web Template
10353	Power Pages Scan Report
10354	Power Pages Log
10359	Catalog Submission Files
10360	Package Submission Store
10531	Form Mapping
18085	Event Expander Breadcrumb

ComponentIdUnique

Property	Value
Description	For internal use only.
DisplayName	Row id unique
IsValidForForm	False
IsValidForRead	True
LogicalName	componentidunique
RequiredLevel	SystemRequired
Type	Uniqueidentifier

ComponentState

Property	Value
Description	For internal use only.
DisplayName	Component State
IsValidForForm	False
IsValidForRead	True
LogicalName	componentstate
RequiredLevel	SystemRequired
Type	Picklist
DefaultFormValue
GlobalChoiceName	componentstate

ComponentState Choices/Options

Value	Label
0	Published
1	Unpublished
2	Deleted
3	Deleted Unpublished

CreatedBy

Property	Value
Description	Unique identifier of the user who created the duplicate detection rule.
DisplayName	Created By
IsValidForForm	False
IsValidForRead	True
LogicalName	createdby
RequiredLevel	None
Type	Lookup
Targets	systemuser

CreatedOn

Property	Value
Description	Date and time when the duplicate detection rule was created.
DisplayName	Created On
IsValidForForm	False
IsValidForRead	True
LogicalName	createdon
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

CreatedOnBehalfBy

Property	Value
Description	Unique identifier of the delegate user who created the duplicaterule.
DisplayName	Created By (Delegate)
IsValidForForm	False
IsValidForRead	True
LogicalName	createdonbehalfby
RequiredLevel	None
Type	Lookup
Targets	systemuser

IsManaged

Property	Value
Description	Indicates whether the solution component is part of a managed solution.
DisplayName	Is Managed
IsValidForForm	False
IsValidForRead	True
LogicalName	ismanaged
RequiredLevel	SystemRequired
Type	Boolean
GlobalChoiceName	ismanaged
DefaultValue	False
True Label	Managed
False Label	Unmanaged

MatchingEntityMatchCodeTable

Property	Value
Description	Database table that stores match codes for potential duplicate records.
DisplayName	Matching Record Type Match Code Table
IsValidForForm	False
IsValidForRead	True
LogicalName	matchingentitymatchcodetable
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	50

MatchingEntityTypeCode

Property	Value
Description	Record type of the records being evaluated as potential duplicates.
DisplayName	Matching Record Type
IsValidForForm	True
IsValidForRead	True
LogicalName	matchingentitytypecode
RequiredLevel	SystemRequired
Type	Picklist
DefaultFormValue	0
GlobalChoiceName	duplicaterule_matchingentitytypecode

MatchingEntityTypeCode 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 Pool
10036	Data Lake Folder
10037	Data Lake Folder Permission
10038	Data Lake Workspace
10039	Data Lake Workspace Permission
10040	Data Processing configuration
10041	Exported Excel
10042	RetainedData Excel
10043	Synapse Database
10044	Synapse Link External Table State
10045	Synapse Link Profile
10046	Synapse Link Profile Entity
10047	Synapse Link Profile Entity State
10048	Synapse Link Schedule
10049	Component Version
10050	Component Version Data Source
10051	Component Version (Internal)
10052	DataflowRefreshHistory
10053	EntityRefreshHistory
10054	Shared Link Setting
10055	DelegatedAuthorization
10057	CascadeGrantRevokeAccessRecordsTracker
10058	CascadeGrantRevokeAccessVersionTracker
10059	RevokeInheritedAccessRecordsTracker
10060	TdsMetadata
10061	Model-Driven App Element
10062	Model-Driven App Component Node's Edge
10063	Model-Driven App Component Node
10064	Model-Driven App Setting
10065	Model-Driven App User Setting
10066	Organization Setting
10067	Setting Definition
10068	CanvasApp Extended Metadata
10069	Service Plan Mapping
10070	Service Plan Custom Control
10072	ApplicationUser
10075	OData v4 Data Source
10076	Workflow Binary
10077	Credential
10078	Desktop Flow Module
10079	Flow Capacity Assignment
10080	Flow Credential Application
10081	Flow Event
10082	Flow Machine
10083	Flow Machine Group
10084	Flow Machine Image
10085	Flow Machine Image Version
10086	Flow Machine Network
10087	ProcessStageParameter
10088	Work Queue
10089	Work Queue Item
10090	Desktop Flow Binary
10091	Flow Log
10092	Flow Run
10093	Action Approval Model
10094	Approval
10095	Approval Request
10096	Approval Response
10097	Approval Step
10098	Await All Action Approval Model
10099	Await All Approval Model
10100	Basic Approval Model Data
10101	Flow Approval
10110	Connection Reference
10111	DVFileSearch
10112	DVFileSearchAttribute
10113	DVFileSearchEntity
10114	DVTableSearch
10115	DVTableSearchAttribute
10116	DVTableSearchEntity
10117	AICopilot
10118	AIPluginAuth
10119	AI Plugin Conversation Starter
10120	AI Plugin Conversation Starter Mapping
10121	AI Plugin Governance
10122	AI Plugin Governance Extended
10123	AIPluginOperationResponseTemplate
10124	AIPluginTitle
10125	SideloadedAIPlugin
10126	AIPlugin
10127	AIPluginExternalSchema
10128	AIPluginExternalSchemaProperty
10129	AIPluginInstance
10130	AIPluginOperation
10131	AIPluginOperationParameter
10132	AIPluginUserSetting
10134	AI Event
10135	AI Builder Feedback Loop
10136	AI Form Processing Document
10137	AI Object Detection Image
10138	AI Object Detection Label
10139	AI Object Detection Bounding Box
10140	AI Object Detection Image Mapping
10142	AI Builder Dataset
10143	AI Builder Dataset File
10144	AI Builder Dataset Record
10145	AI Builder Datasets Container
10146	AI Builder File
10147	AI Builder File Attached Data
10148	Help Page
10149	Tour
10150	BotContent
10151	ConversationTranscript
10152	Copilot
10153	Copilot component
10154	Copilot component collection
10165	Comment
10166	Fabric AISkill
10167	App Insights Metadata
10168	Dataflow Connection Reference
10169	Schedule
10170	Dataflow Template
10171	Dataflow DatalakeFolder
10172	Data Movement Service Request
10173	Data Movement Service Request Status
10174	DMS Sync Request
10175	DMS Sync Status
10176	Knowledge Asset Configuration
10177	Module Run Detail
10178	Salesforce Structured Object
10179	Salesforce Structured QnA Config
10180	Workflow Action Status
10181	FederatedKnowledgeConfiguration
10182	FederatedKnowledgeEntityConfiguration
10183	PDF Setting
10184	Activity File Attachment
10185	Teams chat
10186	Service Configuration
10187	SLA KPI
10188	Integrated search provider
10189	Knowledge Management Setting
10190	Knowledge Federated Article
10191	Knowledge Federated Article Incident
10192	Search provider
10193	Knowledge Article Image
10194	Knowledge Configuration
10195	Knowledge Interaction Insight
10196	Knowledge Search Insight
10197	Favorite knowledge article
10198	Knowledge article language setting
10199	Knowledge Article Attachment
10200	Knowledge personalization
10201	Knowledge Article Template
10202	Knowledge search personal filter config
10203	Knowledge search filter
10205	SupportUserTable
10206	FxExpression
10207	PowerfxRule
10208	Planner Business Scenario
10209	Planner Sync Action
10210	Ms Graph Resource To Subscription
10211	Virtual Entity Metadata
10212	Background Operation
10213	Report Parameter
10214	MobileOfflineProfileExtension
10215	MobileOfflineProfileItemFilter
10216	TeamMobileOfflineProfileMembership
10217	UserMobileOfflineProfileMembership
10218	OrganizationDataSyncSubscription
10219	OrganizationDataSyncSubscriptionEntity
10220	OrganizationDataSyncSubscriptionFnoTable
10221	OrganizationDataSyncFnoState
10222	OrganizationDataSyncState
10223	ArchiveCleanupInfo
10224	ArchiveCleanupOperation
10225	BulkArchiveConfig
10226	BulkArchiveFailureDetail
10227	BulkArchiveOperation
10228	BulkArchiveOperationDetail
10229	EnableArchivalRequest
10230	MetadataForArchival
10231	ReconciliationEntityInfo
10232	ReconciliationEntityStepInfo
10233	ReconciliationInfo
10234	RetentionCleanupInfo
10235	RetentionCleanupOperation
10236	RetentionConfig
10237	RetentionFailureDetail
10238	RetentionOperation
10239	RetentionOperationDetail
10240	Notification
10241	User Rating
10242	Mobile App
10243	Insights Store Data Source
10244	Insights Store Virtual Entity
10245	RoleEditorLayout
10246	Deleted Record Reference
10247	Restore Deleted Records Configuration
10248	App Action
10249	App Action Migration
10250	App Action Rule
10253	Card
10254	Card State Item
10257	Entity link chat configuration
10258	Rich Text Attachment
10259	Custom Control Extended Setting
10260	Timeline Pin
10261	Virtual Connector Data Source
10262	Virtual Table Column Candidate
10264	PM Analysis History
10265	PM Business Rule Automation Config
10266	PM Calendar
10267	PM Calendar Version
10268	PM Inferred Task
10269	PM Process Extended Metadata Version
10270	PM Process Template
10271	PM Process User Settings
10272	PM Process Version
10273	PM Recording
10274	PM Simulation
10275	PM Template
10276	PM View
10277	Analysis Component
10278	Analysis Job
10279	Analysis Override
10280	Analysis Result
10281	Analysis Result Detail
10282	Solution Health Rule
10283	Solution Health Rule Argument
10284	Solution Health Rule Set
10285	Power BI Dataset
10286	powerbidatasetapdx
10287	Power BI Mashup Parameter
10288	Power BI Report
10289	powerbireportapdx
10290	File Upload
10291	MainFewShot
10292	MakerFewShot
10293	SearchAttributeSettings
10294	SearchCustomAnalyzer
10295	SearchRelationshipSettings
10296	SearchResultsCache
10297	Search Telemetry
10298	ViewAsExampleQuestion
10299	CopilotExampleQuestion
10300	CopilotGlossaryTerm
10301	CopilotSynonyms
10302	Site Component
10303	Site
10304	Site Language
10305	Power Pages Site Published
10308	External Identity
10309	Invitation
10310	Invite Redemption
10311	Portal Comment
10312	Setting
10313	Multistep Form Session
10317	Ad Placement
10318	Column Permission
10319	Column Permission Profile
10320	Content Snippet
10321	Basic Form
10322	Basic Form Metadata
10323	List
10324	Table Permission
10325	Page Template
10326	Poll Placement
10327	Power Pages Core Entity DS
10328	Publishing State
10329	Publishing State Transition Rule
10330	Redirect
10331	Shortcut
10332	Site Marker
10333	Site Setting
10334	Web File
10335	Multistep Form
10336	Multistep Form Metadata
10337	Form Step
10338	Web Link
10339	Web Link Set
10340	Web Page
10341	Web Page Access Control Rule
10342	Web Role
10343	Website
10344	Website Access
10345	Website Language
10346	Web Template
10353	Power Pages Scan Report
10354	Power Pages Log
10359	Catalog Submission Files
10360	Package Submission Store
10531	Form Mapping
18085	Event Expander Breadcrumb

ModifiedBy

Property	Value
Description	Unique identifier of the user who last modified the duplicate detection rule.
DisplayName	Modified By
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedby
RequiredLevel	None
Type	Lookup
Targets	systemuser

ModifiedOn

Property	Value
Description	Date and time when the duplicate detection rule was last modified.
DisplayName	Modified On
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedon
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

ModifiedOnBehalfBy

Property	Value
Description	Unique identifier of the delegate user who last modified the duplicaterule.
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	DateAndTime
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	Unique identifier of the business unit that owns duplicate detection rule.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	owningbusinessunit
RequiredLevel	None
Type	Lookup
Targets	businessunit

OwningTeam

Property	Value
Description	Unique identifier of the team who owns the duplicate detection rule.
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 duplicate detection rule.
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

StateCode

Property	Value
Description	Status of the duplicate detection rule.
DisplayName	Status
IsValidForForm	True
IsValidForRead	True
LogicalName	statecode
RequiredLevel	SystemRequired
Type	State
DefaultFormValue	0
GlobalChoiceName	duplicaterule_statecode

StateCode Choices/Options

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

SupportingSolutionId

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

Many-to-One relationships

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

• BusinessUnit_DuplicateRules
• lk_duplicaterule_createdonbehalfby
• lk_duplicaterule_modifiedonbehalfby
• lk_duplicaterulebase_createdby
• lk_duplicaterulebase_modifiedby
• owner_duplicaterules
• SystemUser_DuplicateRules
• team_DuplicateRules

BusinessUnit_DuplicateRules

One-To-Many Relationship: businessunit BusinessUnit_DuplicateRules

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_duplicaterule_createdonbehalfby

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

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

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

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

One-To-Many Relationship: owner owner_duplicaterules

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_DuplicateRules

One-To-Many Relationship: systemuser SystemUser_DuplicateRules

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_DuplicateRules

One-To-Many Relationship: team team_DuplicateRules

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.

• DuplicateRule_Annotation
• DuplicateRule_DuplicateBaseRecord
• DuplicateRule_DuplicateRuleConditions
• DuplicateRule_SyncErrors

DuplicateRule_Annotation

Many-To-One Relationship: annotation DuplicateRule_Annotation

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

DuplicateRule_DuplicateBaseRecord

Many-To-One Relationship: duplicaterecord DuplicateRule_DuplicateBaseRecord

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

DuplicateRule_DuplicateRuleConditions

Many-To-One Relationship: duplicaterulecondition DuplicateRule_DuplicateRuleConditions

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

DuplicateRule_SyncErrors

Many-To-One Relationship: syncerror DuplicateRule_SyncErrors

Property	Value
ReferencingEntity	syncerror
ReferencingAttribute	regardingobjectid
ReferencedEntityNavigationPropertyName	DuplicateRule_SyncErrors
IsCustomizable	True
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
duplicaterule