JDBC Driver for Oracle Service Cloud

Build 22.0.8462

SalesProductsSchedules

The price schedule for a sales product.

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 SalesProductsSchedules WHERE scheduleId = 12
SELECT * FROM SalesProductsSchedules WHERE scheduleId > 15
SELECT * FROM SalesProductsSchedules WHERE comment LIKE '%test'
SELECT * FROM SalesProductsSchedules WHERE scheduleId IN (12,23,123)
SELECT * FROM SalesProductsSchedules WHERE comment IS NOT NULL

Columns

Name Type Description
SalesProductsId Long The unique identifier of the sales product.
Comment String The comments or notes associated with the sales product schedule.
ScheduleId Long Id of schedule. The ID of the schedule. This is part of the key for the list entry.
SchedulelookUpName String LookUpName of schedule. The ID of the schedule. This is part of the key for the list entry.
ScheduleEndDate Date The date when the schedule ends.
ScheduleStartDate Date The date when the schedule starts. This is part of the key for the list entry.
PricecurrencyId Long Id of currency. The ID of the currency.
PricecurrencylookUpName String LookUpName of currency. The ID of the currency.
PriceexchangeRateId Long Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
PriceexchangeRatelookUpName String LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
Pricevalue String The value of the currency.

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