DuplicateRule
This is a table representing the DuplicateRule entities in Dynamics CRM.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
Unique identifier of the duplicate detection rule. |
| BaseEntityMatchCodeTable | String | True |
Database table that stores match codes for the record type being evaluated for potential duplicates. |
| BaseEntityName | String | False |
Record type of the record being evaluated for potential duplicates. |
| BaseEntityTypeCode | String | True |
Record type of the record being evaluated for potential duplicates. |
| CreatedBy_Id | String | True |
Unique identifier of the user who created the duplicate detection rule. |
| CreatedBy_LogicalName | String | True | |
| CreatedBy_Name | String | True | |
| CreatedOn | Datetime | True |
Date and time when the duplicate detection rule was created. |
| CreatedOnBehalfBy_Id | String | True |
Unique identifier of the delegate user who created the duplicaterule. |
| CreatedOnBehalfBy_LogicalName | String | True | |
| CreatedOnBehalfBy_Name | String | True | |
| Description | String | False |
Description of the duplicate detection rule. |
| DuplicateRuleId | String | False |
Unique identifier of the duplicate detection rule. |
| IsCaseSensitive | Boolean | False |
Indicates if the operator is case-sensitive. |
| MatchingEntityMatchCodeTable | String | True |
Database table that stores match codes for potential duplicate records. |
| MatchingEntityName | String | False |
Record type of the records being evaluated as potential duplicates. |
| MatchingEntityTypeCode | String | True |
Record type of the records being evaluated as potential duplicates. |
| ModifiedBy_Id | String | True |
Unique identifier of the user who last modified the duplicate detection rule. |
| ModifiedBy_LogicalName | String | True | |
| ModifiedBy_Name | String | True | |
| ModifiedOn | Datetime | True |
Date and time when the duplicate detection rule was last modified. |
| ModifiedOnBehalfBy_Id | String | True |
Unique identifier of the delegate user who last modified the duplicaterule. |
| ModifiedOnBehalfBy_LogicalName | String | True | |
| ModifiedOnBehalfBy_Name | String | True | |
| Name | String | False |
Name of the duplicate detection rule. |
| OwnerId_Id | String | False |
Unique identifier of the user or team who owns the duplicate detection rule. |
| OwnerId_LogicalName | String | False | |
| OwnerId_Name | String | False | |
| OwningBusinessUnit_Id | String | True |
Unique identifier of the business unit that owns duplicate detection rule. |
| OwningBusinessUnit_LogicalName | String | True | |
| OwningBusinessUnit_Name | String | True | |
| OwningTeam_Id | String | True |
Unique identifier of the team who owns the duplicate detection rule. |
| OwningTeam_LogicalName | String | True | |
| OwningTeam_Name | String | True | |
| OwningUser_Id | String | True |
Unique identifier of the user who owns the duplicate detection rule. |
| OwningUser_LogicalName | String | True | |
| OwningUser_Name | String | True | |
| StateCode | String | True |
Status of the duplicate detection rule. |
| StatusCode | String | False |
Reason for the status of the duplicate detection rule. |
| TimeZoneRuleVersionNumber | Integer | False |
For internal use only. |
| UTCConversionTimeZoneCode | Integer | False |
Time zone code that was in use when the record was created. |