# LeadFields ## Documentation The fields of a lead, the custom fields included. Each request costs 20 tokens of the daily budget of the company. - Catalog: `Pipedrive` - Schema: `Fields` - Primary Keys: `key` 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 `LeadFields` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `active_flag` | `char` | | ☐ | The active flag of the field. | | `add_time` | `datetime` | | ☐ | The creation time of the field. | | `add_visible_flag` | `char` | | ☐ | Not used. | | `bulk_edit_allowed` | `char` | | ☐ | Whether or not the field of an item can be edited in bulk. | | `created_by_user_id` | `int64` | | ☐ | The ID of the user who created the field. | | `details_visible_flag` | `char` | | ☐ | Not used. | | `edit_flag` | `char` | | ☐ | The edit flag of the field. | | `field_type` | `varchar2` | | ☐ | List of all possible field types. | | `filtering_allowed` | `char` | | ☐ | Whether or not items can be filtered by this field. | | `id` | `int64` | | ☐ | The ID of the field. | | `important_flag` | `char` | | ☐ | Not used. | | `index_visible_flag` | `char` | | ☐ | Not used. | | `is_subfield` | `char` | | ☐ | Whether or not the field is a subfield of another field. | | `key` | `varchar2` | | ☑ | The key of the field. | | `last_updated_by_user_id` | `int64` | | ☐ | The ID of the user who created or most recently updated the field, only applicable for custom fields. | | `mandatory_flag` | `char` | | ☐ | Whether or not the field is mandatory. | | `name` | `varchar2` | | ☐ | The name of the field. | | `options_deleted` | `varchar2` | | ☐ | The deleted options of the field. | | `options` | `varchar2` | | ☐ | The options of the field. | | `order_nr` | `int64` | | ☐ | The order number of the field. | | `searchable_flag` | `char` | | ☐ | Whether or not items can be searched by this field. | | `sortable_flag` | `char` | | ☐ | Whether or not items can be sorted by this field. | | `subfields` | `varchar2` | | ☐ | The subfields of the field. | | `update_time` | `datetime` | | ☐ | The update time of the field. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `created_by_user_id` | [[Users-Users\|Users.Users]] | `id` | Declared by the connector, not enforced by the platform | | `last_updated_by_user_id` | [[Users-Users\|Users.Users]] | `id` | Declared by the connector, not enforced by the platform |