Duplicate Detection Rule (DuplicateRule) table/entity reference

Note

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

Rule used to identify potential duplicates.

Messages

Message Web API Operation SDK Assembly
Assign PATCH [org URI]/api/data/v9.0/duplicaterules(duplicateruleid)
Update ownerid property.
AssignRequest
CompoundUpdateDuplicateDetectionRule CompoundUpdateDuplicateDetectionRule Action CompoundUpdateDuplicateDetectionRuleRequest
Create POST [org URI]/api/data/v9.0/duplicaterules
See Create
CreateRequest or
Create
Delete DELETE [org URI]/api/data/v9.0/duplicaterules(duplicateruleid)
See Delete
DeleteRequest or
Delete
GrantAccess GrantAccess Action GrantAccessRequest
ModifyAccess ModifyAccess Action ModifyAccessRequest
PublishDuplicateRule PublishDuplicateRule Action PublishDuplicateRuleRequest
PublishXml PublishXml Action PublishXmlRequest
Retrieve GET [org URI]/api/data/v9.0/duplicaterules(duplicateruleid)
See Retrieve
RetrieveRequest or
Retrieve
RetrieveMultiple GET [org URI]/api/data/v9.0/duplicaterules
See Query Data
RetrieveMultipleRequest or
RetrieveMultiple
RetrievePrincipalAccess RetrievePrincipalAccess Function RetrievePrincipalAccessRequest
RetrieveSharedPrincipalsAndAccess RetrieveSharedPrincipalsAndAccess Function RetrieveSharedPrincipalsAndAccessRequest
RevokeAccess RevokeAccess Action RevokeAccessRequest
UnpublishDuplicateRule UnpublishDuplicateRule Action UnpublishDuplicateRuleRequest
Update PATCH [org URI]/api/data/v9.0/duplicaterules(duplicateruleid)
See Update
UpdateRequest or
Update

Properties

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

Writable columns/attributes

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

BaseEntityName

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

Description

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

DuplicateRuleId

Property Value
Description Unique identifier of the duplicate detection rule.
DisplayName Duplicate Detection Rule
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
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

ExcludeInactiveRecords Choices/Options

Value Label Description
1 True
0 False

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

IsCaseSensitive Choices/Options

Value Label Description
1 True
0 False

DefaultValue: False

MatchingEntityName

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

Name

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

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

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
IsValidForUpdate False
LogicalName statuscode
RequiredLevel SystemRequired
Type Status

StatusCode Choices/Options

Value Label State
0 Unpublished 0
1 Publishing 0
2 Published 1

TimeZoneRuleVersionNumber

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

UTCConversionTimeZoneCode

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

Read-only columns/attributes

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

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
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName baseentitymatchcodetable
MaxLength 50
RequiredLevel None
Type String

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

BaseEntityTypeCode Choices/Options

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

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

CreatedByName

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

CreatedByYomiName

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

CreatedOn

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

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

CreatedOnBehalfByName

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

CreatedOnBehalfByYomiName

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

MatchingEntityMatchCodeTable

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

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

MatchingEntityTypeCode Choices/Options

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

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

ModifiedByName

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

ModifiedByYomiName

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

ModifiedOn

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

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

ModifiedOnBehalfByName

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

ModifiedOnBehalfByYomiName

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

OwnerIdName

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

OwnerIdYomiName

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

OwningBusinessUnit

Property Value
Description Unique identifier of the business unit that owns duplicate detection rule.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName owningbusinessunit
RequiredLevel None
Targets businessunit
Type Lookup

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

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

StateCode

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

StateCode Choices/Options

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

One-To-Many Relationships

Listed by SchemaName.

DuplicateRule_Annotation

Same as annotation table DuplicateRule_Annotation Many-To-One relationship.

Property Value
ReferencingEntity annotation
ReferencingAttribute objectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName DuplicateRule_Annotation
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: Cascade
Delete: Cascade
Merge: NoCascade
Reparent: Cascade
Share: Cascade
Unshare: Cascade

DuplicateRule_SyncErrors

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

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

DuplicateRule_DuplicateRuleConditions

Same as duplicaterulecondition table DuplicateRule_DuplicateRuleConditions Many-To-One relationship.

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

DuplicateRule_DuplicateBaseRecord

Same as duplicaterecord table DuplicateRule_DuplicateBaseRecord Many-To-One relationship.

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

Many-To-One Relationships

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

lk_duplicaterulebase_createdby

See systemuser Table lk_duplicaterulebase_createdby One-To-Many relationship.

lk_duplicaterule_createdonbehalfby

See systemuser Table lk_duplicaterule_createdonbehalfby One-To-Many relationship.

SystemUser_DuplicateRules

See systemuser Table SystemUser_DuplicateRules One-To-Many relationship.

team_DuplicateRules

See team Table team_DuplicateRules One-To-Many relationship.

lk_duplicaterule_modifiedonbehalfby

See systemuser Table lk_duplicaterule_modifiedonbehalfby One-To-Many relationship.

lk_duplicaterulebase_modifiedby

See systemuser Table lk_duplicaterulebase_modifiedby One-To-Many relationship.

BusinessUnit_DuplicateRules

See businessunit Table BusinessUnit_DuplicateRules One-To-Many relationship.

See also

About the table reference
Web API Reference
duplicaterule EntityType