# Products ## Documentation The products and services the company sells. Each request costs 10 tokens of the daily budget of the company. - Catalog: `Pipedrive` - Schema: `Products` - Primary Keys: `id` Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `Products` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `acme_article_code` | `varchar2` | ACME Article Code | ☐ | The custom field 'ACME Article Code' of the company. | | `add_time` | `datetime` | | ☐ | The date and time when the product was added. | | `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. | | `category` | `varchar2` | | ☐ | The category of the product. | | `code` | `varchar2` | | ☐ | The product code. | | `description` | `varchar2` | | ☐ | The description of the product. | | `id` | `int64` | | ☑ | The ID of the product. | | `is_deleted` | `char` | | ☐ | Whether this product will be marked as deleted or not. | | `is_linkable` | `char` | | ☐ | Whether this product can be added to a deal or not. | | `name` | `varchar2` | | ☐ | The name of the product. | | `owner_id` | `int64` | | ☐ | The ID of the Pipedrive user who owns the product. | | `prices` | `varchar2` | | ☐ | The prices of the product in different currencies. | | `tax` | `decimal` | | ☐ | The tax percentage. | | `unit` | `varchar2` | | ☐ | The unit in which this product is sold. | | `update_time` | `datetime` | | ☐ | The date and time when the product was last updated. | | `visible_to` | `varchar2` | | ☐ | The visible to. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `owner_id` | [[Users-Users\|Users.Users]] | `id` | Declared by the connector, not enforced by the platform | ## Referenced By The columns of these tables refer to a row of this table. | Table | Columns | Guarantee | |---|---|---| | [[Deals-DealProducts\|Deals.DealProducts]] | `product_id` | Declared by the connector, not enforced by the platform | | [[Notes-Files\|Notes.Files]] | `product_id` | Declared by the connector, not enforced by the platform | | [[Settings-RecentChangesBySinceTimestamp\|Settings.RecentChangesBySinceTimestamp]] | `id` | In words only: The changed row of Products, when item is 'product'. |