OpportunitiesQuotesLineItems
The product line item in a quote.
Table-Specific Information
SELECT
The add-in 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 add-in.
SELECT * FROM OpportunitiesQuotesLineItems WHERE id = 12 SELECT * FROM OpportunitiesQuotesLineItems WHERE id > 15 SELECT * FROM OpportunitiesQuotesLineItems WHERE originalDescription LIKE '%test' SELECT * FROM OpportunitiesQuotesLineItems WHERE id IN (12, 23, 123) SELECT * FROM OpportunitiesQuotesLineItems WHERE originalDescription IS NOT NULL
Columns
| Name | Type | Description |
| OpportunitiesId | Long | The unique identifier of the opportunity. |
| QuotesId | Long | The unique identifier of the quote. |
| AdjustedDescription | String | The edited product description in the product line item. |
| AdjustedName | String | The edited product name in the product line item. |
| AdjustedPartNumber | String | The edited product part number in the product line item. |
| Comment | String | The comments associated with a product line item in the quote. |
| DiscountPercent | Int | The discount applied to the adjusted price of the product line item. |
| DisplayOrder | Int | The position of the line item in the quote. |
| Id [KEY] | Long | The unique identifier of the product line item in the quote. This is the key for the list entry. |
| OriginalDescription | String | The original product description. This attribute is read-only. |
| OriginalName | String | The original product name. This attribute is read-only. |
| OriginalPartNumber | String | The original product part number. This attribute is read-only. |
| ProductId | Long | Id of product. The ID of the sales product. |
| ProductlookUpName | String | LookUpName of product. The ID of the sales product. |
| Quantity | Int | The product quantity in the line item. |
| AdjustedPricecurrencyId | Long | Id of currency. The ID of the currency. |
| AdjustedPricecurrencylookUpName | String | LookUpName of currency. The ID of the currency. |
| AdjustedPriceexchangeRateId | Long | Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies. |
| AdjustedPriceexchangeRatelookUpName | String | LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies. |
| AdjustedPricevalue | String | The value of the currency. |
| 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. |
| OriginalPricecurrencyId | Long | Id of currency. The ID of the currency. |
| OriginalPricecurrencylookUpName | String | LookUpName of currency. The ID of the currency. |
| OriginalPriceexchangeRateId | Long | Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies. |
| OriginalPriceexchangeRatelookUpName | String | LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies. |
| OriginalPricevalue | String | The value of the currency. |