JDBC Driver for Oracle Service Cloud

Build 22.0.8462

OpportunitiesQuotes

The sales quote associated with an opportunity.

Table-Specific Information

SELECT

The driver will use the Oracle Service Cloud API to process WHERE clause conditions built with =,!=,<,>,<=,>=,IN,NOT_IN,IS,IS_NOT,LIKE operators. The rest of the filters are executed client side within the driver.

SELECT * FROM OpportunitiesQuotes WHERE id = 12
SELECT * FROM OpportunitiesQuotes WHERE id > 15
SELECT * FROM OpportunitiesQuotes WHERE comment LIKE '%test'
SELECT * FROM OpportunitiesQuotes WHERE id IN (12,23,123)
SELECT * FROM OpportunitiesQuotes WHERE comment IS NOT NULL

Columns

Name Type Description
OpportunitiesId Long The unique identifier of the opportunity.
Comment String The comment text for the quote.
CreatedTime Datetime The date and time when the quote was created.
DiscountPercent Int The discount percentage for the quote.
Forecasted Bool Indicates whether the quote has been forecasted. The default value is false.
Id [KEY] Long The unique identifier of the quote. This is the key for the list entry.
Name String The descriptive name of the quote.
OfferEndTime Datetime The date and time when the quoted offer ends.
OfferStartTime Datetime The date and time when the quoted offer starts.
PriceScheduleId Long Id of priceSchedule. The effective price schedule.
PriceSchedulelookUpName String LookUpName of priceSchedule. The effective price schedule.
SentTime Datetime The date and time when the quote was sent.
SentTo String The email addresses of the contact to whom the quote was sent. This attribute is read-only.
StatusId Long Id of status. The current status.
StatuslookUpName String LookUpName of status. The current status.
TemplateId Long Id of template. The template used to generate the quote.
TemplatelookUpName String LookUpName of template. The template used to generate the quote.
UpdatedTime Datetime The date and time when the quote was last updated. This attribute is read-only.
AdjustedTotalcurrencyId Long Id of currency. The ID of the currency.
AdjustedTotalcurrencylookUpName String LookUpName of currency. The ID of the currency.
AdjustedTotalexchangeRateId Long Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
AdjustedTotalexchangeRatelookUpName String LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
AdjustedTotalvalue String The value of the currency.
TotalcurrencyId Long Id of currency. The ID of the currency.
TotalcurrencylookUpName String LookUpName of currency. The ID of the currency.
TotalexchangeRateId Long Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
TotalexchangeRatelookUpName String LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
Totalvalue String The value of the currency.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
fileAttachments String The list of file attachments for the quote.
lineItems String The list of individual product line items that make up the quote.

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