JDBC Driver for Oracle Service Cloud

Build 22.0.8462

PurchasedProducts

The information about a purchased 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 PurchasedProducts WHERE id = 12
SELECT * FROM PurchasedProducts WHERE id > 15
SELECT * FROM PurchasedProducts WHERE lookUpName LIKE '%test'
SELECT * FROM PurchasedProducts WHERE id IN (12,23,123)
SELECT * FROM PurchasedProducts WHERE lookUpName IS NOT NULL

INSERT

Insert can be executed by specifying the comment column. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO PurchasedProducts (comment) VALUES ('Incident extract limit')

UPDATE

Update can be executed. The columns that are not read-only can be Updated. For example:

UPDATE PurchasedProducts SET comment = 'Test Replacement' WHERE contactId = '2'

DELETE

Following is an example of how to Delete a record in this table.

DELETE FROM PurchasedProducts WHERE summary id = '10'

Columns

Name Type ReadOnly Description
CampaignId Long False

Id of campaign. The campaign associated with the purchased product.

CampaignlookUpName String False

LookUpName of campaign. The campaign associated with the purchased product.

Comment String False

The comments or notes associated with the line item.

ContactId Long False

Id of contact. The contact associated with the purchased product.

ContactlookUpName String False

LookUpName of contact. The contact associated with the purchased product.

CreatedTime Datetime True

The date and time when the purchased product was created. This attribute is read-only.

FinalizedByAccountId Long False

Id of finalizedByAccount. The account associated with the purchased product.

FinalizedByAccountlookUpName String False

LookUpName of finalizedByAccount. The account associated with the purchased product.

Id [KEY] Long True

The unique identifier of the purchased product.

LicenseEndTime Datetime False

The end date of the license.

LicenseStartTime Datetime False

The start date of the license.

LookupName String True

The name used to look up the purchased product.

MailingId Long False

Id of mailing. The associated mailing.

MailinglookUpName String False

LookUpName of mailing. The associated mailing.

OpportunityId Long False

Id of opportunity. The opportunity associated with the purchased product.

OpportunitylookUpName String False

LookUpName of opportunity. The opportunity associated with the purchased product.

OrganizationId Long False

Id of organization. The organization associated with the purchased product.

OrganizationlookUpName String False

LookUpName of organization. The organization associated with the purchased product.

PurchaseTime Datetime False

The date and time of the purchase.

SalesProductId Long False

Id of salesProduct. The sales product associated with the purchased product.

SalesProductlookUpName String False

LookUpName of salesProduct. The sales product associated with the purchased product.

SerialNumber String False

The serial number of the purchased product.

UpdatedTime Datetime True

The date and time when the purchased product was last updated. This attribute is read-only.

PricecurrencyId Long False

Id of currency. The ID of the currency.

PricecurrencylookUpName String False

LookUpName of currency. The ID of the currency.

PriceexchangeRateId Long False

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 False

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 False

The value of the currency.

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