# ticket_custom_fields: Freshdesk Ticket Custom Fields ## Documentation Custom fields for tickets - Catalog: `Freshdesk` - Schema: `Freshdesk` - Primary Keys: `id` - Label: Ticket Custom Fields Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `ticket_custom_fields` 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 | |---|:---:|---|:---:|---| | `choices` | `varchar2` | Choices | ☐ | Choices available (JSON). | | `created_at` | `datetime` | Created at | ☐ | Date/time at which the record was created. | | `customers_can_edit` | `char` | Customers Can Edit | ☐ | Whether the field can be updated by customers. | | `default` | `char` | Default | ☐ | Whether the field is not a custom field. | | `description` | `varchar2` | Description | ☐ | Description. | | `displayed_to_customers` | `char` | Displayed to Customers | ☐ | Whether the field is displayed in the customer portal. | | `editable_in_signup` | `char` | Editable in Sign-up | ☐ | Whether the field can be updated by customers during signup. | | `id` | `int64` | ID | ☑ | Unique ID. | | `label_for_customers` | `varchar2` | Label for Customers | ☐ | User-interface label for customers. | | `label` | `varchar2` | Label | ☐ | User-interface label. | | `name` | `varchar2` | Name | ☐ | Name. | | `portal_cc_to` | `varchar2` | Portal CC, To | ☐ | 'all' when a customer can add any requester to the CC list and 'company' when a customer can add only company contacts to the CC list. | | `portal_cc` | `char` | Portal CC | ☐ | Whether customer can add additional requesters to a ticket. | | `position` | `int32` | Position | ☐ | Position. | | `required_for_agents` | `char` | Required for Agents | ☐ | Whether the field is required for agents. | | `required_for_closure` | `char` | Required for Closure | ☐ | Whether the field is required for closing the ticket. | | `required_for_customers` | `char` | Required for Customers | ☐ | Whether the field is required for customers. | | `type` | `varchar2` | Type | ☐ | Type of custom field such as date, text, etc. | | `updated_at` | `datetime` | Updated at | ☐ | Date/time at which the record was last updated. |