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