JDBC Driver for Microsoft Dynamics CRM

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462