contact_custom_fields_v1
Contact custom fields are used to create additional fields which are not present by default on a Contact.
| Column | Data type | Description |
|---|---|---|
| id | VARCHAR(32) | The unique identifier of the contact custom field. |
| label | VARCHAR(200) | The name of the custom field. |
| value | VARCHAR(524288) | The value of the custom field. |
| is_default_value | VARCHAR(3) | Determines if the field value is set by default or input by user. |
| type | VARCHAR(50) | Type of the custom field. Possible values: 'Yes/No', 'Whole Number', 'Decimal', 'Text', 'List', 'Statement', 'Date', 'Long Text', 'Time', 'System List'. |
| is_mandatory | VARCHAR(3) | Determines if the custom field value is mandatory. |
| field_order | NUMBER(38,0) | The integer value marking order of the field in UI. |
| _contact_id | NUMBER(38,0) | The identifier of the contact. |
| _last_sync_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the custom field value was last refreshed. |