JDBC Driver for Microsoft Dynamics CRM

Build 22.0.8462

ServiceAppointment

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

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier of the service activity.

ActivityId String False

Unique identifier of the service activity.

ActivityTypeCode String True

Type of activity.

ActualDurationMinutes Integer False

Actual duration of the service activity in minutes.

ActualEnd Datetime False

Actual end time of the service activity.

ActualStart Datetime False

Actual start time of the service activity.

Category String False

Category of the service activity.

CreatedBy_Id String True

Unique identifier of the user who created the service activity.

CreatedBy_LogicalName String True

CreatedBy_Name String True

CreatedOn Datetime True

Date and time when the service activity was created.

CreatedOnBehalfBy_Id String True

Unique identifier of the delegate user who created the serviceappointment.

CreatedOnBehalfBy_LogicalName String True

CreatedOnBehalfBy_Name String True

Customers_Ids String False

Customers for whom the service activity is performed.

Customers_LogicalNames String False

Customers_Names String False

Description String False

Description of the service activity.

ExchangeRate Double True

Exchange rate for the currency associated with the serviceappointment with respect to the base currency.

ImportSequenceNumber Integer False

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

IsAllDayEvent Boolean False

Information which specifies if the service activity is an all day event.

IsBilled Boolean False

Information which specifies whether the service activity was billed as part of resolving a case.

IsRegularActivity Boolean True

Information regarding whether the activity is a regular activity type or event type.

IsWorkflowCreated Boolean False

Information which specifies if the service activity was created from a workflow rule.

Location String False

Location where the service activity is to occur.

ModifiedBy_Id String True

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

ModifiedBy_LogicalName String True

ModifiedBy_Name String True

ModifiedOn Datetime True

Date and time when the service activity was last modified.

ModifiedOnBehalfBy_Id String True

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

ModifiedOnBehalfBy_LogicalName String True

ModifiedOnBehalfBy_Name String True

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 service activity.

OwnerId_LogicalName String False

OwnerId_Name String False

OwningBusinessUnit_Id String True

Unique identifier of the business unit that owns the service activity.

OwningBusinessUnit_LogicalName String True

OwningBusinessUnit_Name String True

OwningTeam_Id String True

Unique identifier of the team that owns the service activity.

OwningTeam_LogicalName String True

OwningTeam_Name String True

OwningUser_Id String True

Unique identifier of the user that owns the service activity.

OwningUser_LogicalName String True

OwningUser_Name String True

PriorityCode String False

Priority of the service activity.

RegardingObjectId_Id String False

Unique identifier of the object with which the service activity is associated.

RegardingObjectId_LogicalName String False

RegardingObjectId_Name String False

Resources_Ids String False

Users or facility/equipment that are required for the service activity.

Resources_LogicalNames String False

Resources_Names String False

ScheduledDurationMinutes Integer False

Scheduled duration of the service activity, specified in minutes.

ScheduledEnd Datetime False

Scheduled end time of the service activity.

ScheduledStart Datetime False

Scheduled start time of the service activity.

ServiceId_Id String False

Unique identifier for an associated service.

ServiceId_LogicalName String False

ServiceId_Name String False

SiteId_Id String False

Site where the service activity is located.

SiteId_LogicalName String False

SiteId_Name String False

StateCode String True

Status of the service activity.

StatusCode String False

Reason for the status of the service activity.

Subcategory String False

Sub-category of the activity.

Subject String False

Subject associated with the service activity.

TimeZoneRuleVersionNumber Integer False

For internal use only.

TransactionCurrencyId_Id String False

Unique identifier of the currency associated with the serviceappointment.

TransactionCurrencyId_LogicalName String False

TransactionCurrencyId_Name String False

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