ODBC Driver for Salesforce

Build 25.0.9434

Entitlement

Schema file for Entitlement.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier for the record.

IsDeleted Bool True

Indicates whether the record has been moved to the Recycle Bin.

Name String False

Name of the record.

CurrencyIsoCode String False

ISO code for the currency in which the revenue amount is expressed.

CreatedDate Datetime True

Date and time when the record was created.

CreatedById String True

User.Id

ID of the user who created the record.

LastModifiedById String True

User.Id

ID of the user who last modified the record.

LastViewedDate Datetime True

Date and time when the record was last viewed in the user interface.

LastReferencedDate Datetime True

Date and time when the record was last referenced.

AccountId String False

Account.Id

ID of the Account associated with this record.

Type String False

Type of account or classification.

ServiceContractId String False

ServiceContract.Id

ID of the ServiceContract associated with this record.

ContractLineItemId String False

ContractLineItem.Id

ID of the ContractLineItem associated with this record.

AssetId String False

Asset.Id

ID of the Asset associated with this record.

StartDate Date False

Start date for the record or activity.

EndDate Date False

End date for the record or activity.

SlaProcessId String False

SlaProcess.Id

ID of the SlaProcess associated with this record.

BusinessHoursId String False

BusinessHours.Id

ID of the business hours associated with this record.

IsPerIncident Bool False

Indicates whether the record has the PerIncident characteristic.

CasesPerEntitlement Int False

Field containing CasesPerEntitlement information.

RemainingCases Int False

Field containing RemainingCases information.

Status String True

Status of the record.

LocationId String False

Location.Id

ID of the Location associated with this record.

WorkOrdersPerEntitlement Int False

Field containing WorkOrdersPerEntitlement information.

RemainingWorkOrders Int False

Field containing RemainingWorkOrders information.

SOQL String False

Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query.

ExternalIdColumn String False

Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called.

FilterScope String False

Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team.

SystemModstamp Datetime True

Date and time when the record was last modified by a user or by an automated process.

LastModifiedDate Datetime True

Date and time when the record was last modified.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434