PurchasedProducts
The information about a purchased product.
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 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. |