# AccountCustomFields: ActiveCampaign Account Custom Fields - Catalog: `ActiveCampaign` - Schema: `V3` - Primary Keys: `id` - Label: Account Custom Fields Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `AccountCustomFields` 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 | |---|:---:|---|:---:|---| | `createdTimestamp` | `datetime` | Created | ☑ | | | `displayOrder` | `int64` | Display Order | ☑ | Order for displaying the field on Manage Fields page and deal profiles. | | `fieldDefault` | `varchar2` | Field Default Value | ☐ | Default value of the field. | | `fieldDefaultCurrency` | `varchar2` | Field Default Currency | ☐ | The 3-letter currency code of the default currency for the field. | | `fieldLabel` | `varchar2` | Field Label | ☑ | Name of the field. | | `fieldOptions` | `varchar2` | Field Options | ☐ | | | `fieldType` | `varchar2` | Field Type | ☑ | Type of field. Possible values are: text, textarea, date, dropdown, multiselect, radio, checkbox, hidden, currency or number. | | `hideFieldFlag` | `int64` | Hide Field | ☑ | | | `id` | `int64` | ID | ☑ | ID of the custom field. | | `isFormVisible` | `int64` | Form Visible | ☑ | Whether or not the field is visible on forms. | | `isRequired` | `int64` | Required | ☑ | Whether or not the field is required on forms. | | `knownFieldId` | `int64` | Known Field ID | ☐ | | | `personalization` | `varchar2` | Personalization | ☐ | | | `updatedTimestamp` | `datetime` | Last Modified | ☑ | |