JDBC Driver for Microsoft Dynamics CRM

Build 22.0.8462

Connection

This is a table representing the Connection entities in Dynamics CRM.

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier of the connection.

ConnectionId String False

Unique identifier of the connection.

CreatedBy_Id String True

Unique identifier of the user who created the connection.

CreatedBy_LogicalName String True

CreatedBy_Name String True

CreatedOn Datetime True

Date and time when the connection was created.

CreatedOnBehalfBy_Id String True

Unique identifier of the delegate user who created the connection.

CreatedOnBehalfBy_LogicalName String True

CreatedOnBehalfBy_Name String True

Description String False

Description of the connection.

EffectiveEnd Datetime False

Effective end date for this connection.

EffectiveStart Datetime False

Effective start date for this connection.

ExchangeRate Double True

Exchange rate between the currency associated with the connection and the base currency.

ImportSequenceNumber Integer False

Unique identifier of the data import or data migration that created this record.

IsMaster Boolean True

Indicates that this is the master record.

ModifiedBy_Id String True

Unique identifier of the user who last modified the connection.

ModifiedBy_LogicalName String True

ModifiedBy_Name String True

ModifiedOn Datetime True

Date and time when the connection was last modified.

ModifiedOnBehalfBy_Id String True

Unique identifier of the delegate user who modified the connection.

ModifiedOnBehalfBy_LogicalName String True

ModifiedOnBehalfBy_Name String True

Name String True

Name of the connection.

OverriddenCreatedOn Datetime False

Date and time that the record was migrated.

OwnerId_Id String False

Unique identifier of the user or team who owns the connection.

OwnerId_LogicalName String False

OwnerId_Name String False

OwningBusinessUnit_Id String True

Unique identifier of the business unit that owns the connection.

OwningBusinessUnit_LogicalName String True

OwningBusinessUnit_Name String True

OwningTeam_Id String True

Unique identifier of the team who owns the connection.

OwningTeam_LogicalName String True

OwningTeam_Name String True

OwningUser_Id String True

Unique identifier of the user who owns the connection.

OwningUser_LogicalName String True

OwningUser_Name String True

Record1Id_Id String False

Unique identifier of the source record.

Record1Id_LogicalName String False

Record1Id_Name String False

Record1ObjectTypeCode String True

Record type of the source record.

Record1RoleId_Id String False

Unique identifier of the role for the source record.

Record1RoleId_LogicalName String False

Record1RoleId_Name String False

Record2Id_Id String False

Unique identifier of the target record.

Record2Id_LogicalName String False

Record2Id_Name String False

Record2ObjectTypeCode String True

Record type of the target record.

Record2RoleId_Id String False

Unique identifier of the role for the target record.

Record2RoleId_LogicalName String False

Record2RoleId_Name String False

RelatedConnectionId_Id String True

Unique identifier for the reciprocal connection record.

RelatedConnectionId_LogicalName String True

RelatedConnectionId_Name String True

StateCode String True

Status of the connection.

StatusCode String False

Reason for the status of the connection.

TransactionCurrencyId_Id String False

Unique identifier of the currency associated with the connection.

TransactionCurrencyId_LogicalName String False

TransactionCurrencyId_Name String False

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