JDBC Driver for Microsoft Dynamics CRM

Build 22.0.8462

Service

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

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier of the service.

AnchorOffset Integer False

Used in conjunction with granularity to describes when services can be performed in relation to midnight on a given day.

CalendarId String False

Unique identifier of the calendar.

CreatedBy_Id String True

Unique identifier of the user who created the service.

CreatedBy_LogicalName String True

CreatedBy_Name String True

CreatedOn Datetime True

Date and time when the service was created.

CreatedOnBehalfBy_Id String True

Unique identifier of the delegate user who created the service.

CreatedOnBehalfBy_LogicalName String True

CreatedOnBehalfBy_Name String True

Description String False

Description of activity that represents work done to satisfy a customer's need.

Duration Integer False

Duration of the service.

Granularity String False

Describes how often the service is performed.

ImportSequenceNumber Integer False

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

InitialStatusCode String False

Initial status reason for the service activity.

IsSchedulable Boolean False

Information about whether the service can be scheduled.

IsVisible Boolean False

Information about whether the service is visible to users.

ModifiedBy_Id String True

Unique identifier of the user who last modified the service.

ModifiedBy_LogicalName String True

ModifiedBy_Name String True

ModifiedOn Datetime True

Date and time when the service was last modified.

ModifiedOnBehalfBy_Id String True

Unique identifier of the delegate user who last modified the service.

ModifiedOnBehalfBy_LogicalName String True

ModifiedOnBehalfBy_Name String True

Name String False

Name of the service.

OrganizationId_Id String True

Unique identifier of the organization with which the service is associated.

OrganizationId_LogicalName String True

OrganizationId_Name String True

OverriddenCreatedOn Datetime False

Date and time that the record was migrated.

ResourceSpecId_Id String False

Unique identifier of the resource specification with which the service is associated.

ResourceSpecId_LogicalName String False

ResourceSpecId_Name String False

ServiceId String False

Unique identifier of the associated service.

ShowResources Boolean False

For internal use only.

StrategyId_Id String False

Value that is taken from PluginTypeId in the Plugin Type record for the scheduling strategy. This is the ID of the scheduling strategy plug-in associated with the service.

StrategyId_LogicalName String False

StrategyId_Name String False

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