# ActivityTypes ## Documentation The types of activities, such as call, meeting and task. Each request costs 20 tokens of the daily budget of the company. - Catalog: `Pipedrive` - Schema: `Activities` - Primary Keys: `id` Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `ActivityTypes` 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 | |---|:---:|---|:---:|---| | `active_flag` | `char` | | ☐ | The active flag of the activity type. | | `add_time` | `datetime` | | ☐ | The creation time of the activity type. | | `color` | `varchar2` | | ☐ | A designated color for the activity type in 6-character HEX format (e.g. FFFFFF for white, 000000 for black). | | `icon_key` | `varchar2` | | ☐ | Icon graphic to use for representing this activity type. | | `id` | `int64` | | ☑ | The ID of the activity type. | | `is_custom_flag` | `char` | | ☐ | Whether the activity type is a custom one or not. | | `key_string` | `varchar2` | | ☐ | A string that is generated by the API based on the given name of the activity type upon creation. | | `name` | `varchar2` | | ☐ | The name of the activity type. | | `order_nr` | `int64` | | ☐ | An order number for the activity type. | | `update_time` | `datetime` | | ☐ | The update time of the activity type. | ## Referenced By The columns of these tables refer to a row of this table. | Table | Columns | Guarantee | |---|---|---| | [[Activities-Activities\|Activities.Activities]] | `type` | Declared by the connector, not enforced by the platform | | [[Settings-RecentChangesBySinceTimestamp\|Settings.RecentChangesBySinceTimestamp]] | `id` | In words only: The changed row of ActivityTypes, when item is 'activityType'. |