AddOpportunityProduct
Creates a new Opportunity Product
Stored Procedures Specific Information
Process of adding opportunity product
Act! CRM allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can typically be used with only = comparision. The available columns for AddOpportunityProduct are OpportunityId, ProductName, ProductCost, ProductDiscount, ProductDiscountPrice, ProductItemNumber, ProductPrice, ProductQuantity and ProductTotal. For example:
EXECUTE AddOpportunityProduct OpportunityId = '123456', ProductName = 'Sample Opportunity Product'
Input
Name | Type | Description |
OpportunityId | String | The unique identifier (id) for a given opportunity. |
ProductName | String | The name of the product |
ProductCost | String | The cost of the product |
ProductDiscount | String | The discount value |
ProductDiscountPrice | String | The discount price value |
ProductItemNumber | String | The item number of the product |
ProductPrice | String | The price of the product |
ProductQuantity | String | The product quantity |
ProductTotal | String | The product total |
Result Set Columns
Name | Type | Description |
Status | String | Stored Procedure Execution Status |