# DealProducts ## Documentation The products of every deal. Reads the deals first and then their products, one request per 100 deals. Each request costs 10 tokens of the daily budget of the company. - Catalog: `Pipedrive` - Schema: `Deals` - Primary Keys: `id` This is a read-only table. The Pipedrive API may not support changing the data or the Invantive UniversalSQL driver for Pipedrive does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Pipedrive API. ## Table Columns The columns of the table `DealProducts` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `add_time` | `datetime` | | ☐ | The date and time when the product was added to the deal. | | `billing_frequency_cycles` | `int64` | | ☐ | The number of times the billing frequency repeats for a product in a deal. Only on the Growth plan and above. | | `billing_frequency` | `varchar2` | | ☐ | How often a customer is billed for access to a service or product. Only on the Growth plan and above. | | `billing_start_date` | `datetime` | | ☐ | The billing start date. Only on the Growth plan and above. | | `comments` | `varchar2` | | ☐ | The comments of the product. | | `currency` | `varchar2` | | ☐ | The currency associated with the deal product. | | `deal_id` | `int64` | | ☐ | The ID of the deal. | | `discount_type` | `varchar2` | | ☐ | The type of the discount's value. | | `discount` | `decimal` | | ☐ | The value of the discount. | | `id` | `int64` | | ☑ | The ID of the deal-product (the ID of the product attached to the deal). | | `is_enabled` | `char` | | ☐ | Whether this product is enabled for the deal. | | `item_price` | `decimal` | | ☐ | The price value of the product. | | `name` | `varchar2` | | ☐ | The product name. | | `order_nr` | `int64` | | ☐ | The order number of the product within the deal. | | `product_id` | `int64` | | ☐ | The ID of the product. | | `product_variation_id` | `int64` | | ☐ | The ID of the product variation. | | `quantity` | `decimal` | | ☐ | The quantity of the product. | | `sum` | `decimal` | | ☐ | The sum of all the products attached to the deal. | | `tax_method` | `varchar2` | | ☐ | The tax option to be applied to the products. | | `tax` | `decimal` | | ☐ | The product tax. | | `update_time` | `datetime` | | ☐ | The date and time when the deal product was last updated. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `currency` | [[Settings-Currencies\|Settings.Currencies]] | `code` | Declared by the connector, not enforced by the platform | | `deal_id` | [[Deals-Deals\|Deals.Deals]] | `id` | Declared by the connector, not enforced by the platform | | `product_id` | [[Products-Products\|Products.Products]] | `id` | Declared by the connector, not enforced by the platform |