OpportunitiesQuotes
The sales quote associated with an opportunity.
Table-Specific Information
SELECT
The component 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 component.
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. |