OpportunityProducts
Update, delete and query the Products associated with an Opportunity.
Table Specific Information
Select
- Id supports the '=' operator.
- OpportunityId supports the '=' operator.
- CreateDate supports the '<=,<,=,!=,>,>=' operator.
- Name supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- Cost supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- EditDate supports the '<=,<,=,!=,>,>=' operator.
- ItemNumber supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- Price supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- Created supports the '<=,<,=,!=,>,>=' operator.
SELECT * FROM OpportunityProducts WHERE OpportunityId = '12345' SELECT * FROM OpportunityProducts WHERE Name = 'Product name'
Update
Any column where ReadOnly=False can be updated.
UPDATE OpportunityProducts SET ItemNumber = 'Product Item Number', Price = 40 WHERE OpportunityId = '12345' AND Id = '34567'
Delete
OpportunityProducts can be deleted by providing an OpportunityId and Id (Product Id) and issuing a DELETE statement.
DELETE FROM OpportunityProducts WHERE OpportunityId = '12345' AND Id = '34567'
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | String | True |
A unique identifier (id) for a given product. |
OpportunityId [KEY] | String | True |
A unique identifier (id) of the opportunity containing the products. |
Created | Datetime | True |
A timestamp when this group was created |
CreateDate | Datetime | True |
The date that the product was created. |
Cost | Decimal | False |
The cost of the product. |
EditDate | Datetime | True |
The date that the opportunity product was lasted modified. |
ItemNumber | String | False |
A item number assigned to this opportunity product. |
Name | String | False |
The name of the product. |
Price | Decimal | False |
The price of the opportunity product. |
Discount | Decimal | False |
The opportunity product's discounted percentage (ignore on updates). |
DiscountPrice | Decimal | False |
The discounted price of the opportunity product. |
ProductID | String | True |
A unique identifier (id) for a given product. |
Quantity | Decimal | False |
The quantity of opportunity products. |
Type | String | False |
The quantity of opportunity products. |
IsQuickBooksproduct | Boolean | False |
Define is product linked with Quickbooks Product. |
RecordOwner | String | False |
Record Owner. |
RecordManager | String | False |
Record Manager. |
Total | Decimal | False |
The total pricie of the opportunity product (adjusted price * quantity). |
CustomFields | String | False |
Custom fields. |
Edited | Datetime | False |
Edited. |
EditedBy | String | False |
Edited by. |