DealsProducts
Get details of deals products.
Select
The 本製品 will use the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.
- Id and DealId support the '=' operator.
For example, the following query is processed server side:
SELECT * FROM DealsProductsV2 WHERE Id = 9 AND DealId = 10;
Columns
Name | Type | References | Description |
Id [KEY] | Integer | Id. | |
IsEnabled | Boolean | Is enabled. | |
AddTime | Datetime | AddTime. | |
UpdateTime | Datetime | UpdateTime. | |
Comments | String | Any textual comment associated with this product-deal attachment. | |
Currency | String | Currency. | |
Discount | Double | Discount. | |
DealId | Integer | Deal id. | |
ItemPrice | Double | Price at which this product will be added to the deal. | |
Name | String | Name. | |
BillingFrequency | String | Billing frequency. | |
BillingFrequencyCycles | Integer | Billing frequency cycles. | |
BillingStartDate | Datetime | Billing start date. | |
TaxMethod | String | Tax method. | |
DiscountType | String | Discount Type. | |
ProductId | Integer | ID of the product that will be attached. | |
ProductVariationId | Integer | ID of the product variation. | |
Quantity | Double | How many items of this product will be added to the deal. | |
Sum | Double | Sum. | |
Tax | Double | Tax percentage.
デフォルト値は0です。 |