PurchasedProducts

The information about a purchased product.

Table-Specific Information

SELECT

The adapter will use the 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 adapter.

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.