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. |