JDBC Driver for Microsoft Dynamics CRM

Build 22.0.8462

Incident

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

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier of the case.

AccountId_Id String True

Unique identifier of the account with which the case is associated.

AccountId_LogicalName String True

AccountId_Name String True

ActualServiceUnits Integer False

Actual number of service units provided for the case.

BilledServiceUnits Integer False

Number of service units billed for the case.

CaseOriginCode String False

Information that specifies the source of the case information, such as Web, telephone, or email.

CaseTypeCode String False

Information that specifies the type of case.

ContactId_Id String True

Unique identifier of the contact associated with the case.

ContactId_LogicalName String True

ContactId_Name String True

ContractDetailId_Id String False

Unique identifier of the specific contract line item that is referenced in the case.

ContractDetailId_LogicalName String False

ContractDetailId_Name String False

ContractId_Id String False

Unique identifier of the contract referenced in the case.

ContractId_LogicalName String False

ContractId_Name String False

ContractServiceLevelCode String False

Response level for the case. The response level corresponds to the level of service specified in the contract.

CreatedBy_Id String True

Unique identifier of the user who created the case.

CreatedBy_LogicalName String True

CreatedBy_Name String True

CreatedOn Datetime True

Date and time when the case was created.

CreatedOnBehalfBy_Id String True

Unique identifier of the delegate user who created the incident.

CreatedOnBehalfBy_LogicalName String True

CreatedOnBehalfBy_Name String True

CustomerId_Id String False

Unique identifier of the account or contact associated with the case.

CustomerId_LogicalName String False

CustomerId_Name String False

CustomerSatisfactionCode String False

Customer's level of satisfaction with the resolution of the case.

Description String False

Description of the case.

ExchangeRate Double True

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

FollowupBy Datetime False

Date by which the customer support representative needs to follow up the case.

ImportSequenceNumber Integer False

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

IncidentId String False

Unique identifier of the case.

IncidentStageCode String False

Stage of the resolution process for the case.

IsDecrementing Boolean False

Information that specifies whether the case is decrementing.

KbArticleId_Id String False

Unique identifier of the knowledge base article associated with the case.

KbArticleId_LogicalName String False

KbArticleId_Name String False

ModifiedBy_Id String True

Unique identifier of the user who last modified the case.

ModifiedBy_LogicalName String True

ModifiedBy_Name String True

ModifiedOn Datetime True

Date and time when the case was last modified.

ModifiedOnBehalfBy_Id String True

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

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 case.

OwnerId_LogicalName String False

OwnerId_Name String False

OwningBusinessUnit_Id String True

Unique identifier of the business unit that owns the case.

OwningBusinessUnit_LogicalName String True

OwningBusinessUnit_Name String True

OwningTeam_Id String True

Unique identifier of the team who owns the case.

OwningTeam_LogicalName String True

OwningTeam_Name String True

OwningUser_Id String True

Unique identifier of the user who owns the case.

OwningUser_LogicalName String True

OwningUser_Name String True

PriorityCode String False

Priority of the case.

ProductId_Id String False

Unique identifier of the product associated with the case.

ProductId_LogicalName String False

ProductId_Name String False

ProductSerialNumber String False

Serial number of the product that is referenced in the case.

ResponsibleContactId_Id String False

Unique identifier of the contact responsible for resolving the case.

ResponsibleContactId_LogicalName String False

ResponsibleContactId_Name String False

SeverityCode String False

Severity of the case.

StateCode String True

Status of the case.

StatusCode String False

Reason for the status of the case.

SubjectId_Id String False

Unique identifier of the subject associated with the case.

SubjectId_LogicalName String False

SubjectId_Name String False

TicketNumber String False

Auto-generated case number.

TimeZoneRuleVersionNumber Integer False

For internal use only.

Title String False

Title of the case.

TransactionCurrencyId_Id String False

Unique identifier of the currency associated with the incident.

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