# DealCustomFields: ActiveCampaign Deal Custom Fields
- Catalog: `ActiveCampaign`
- Schema: `V3`
- Primary Keys: `id`
- Label: Deal Custom Fields
Can retrieve data and change data using insert, update and delete.
## Table Columns
The columns of the table `DealCustomFields` 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 | ☑ | |
| `fieldDefault` | `varchar2` | Field Default Value | ☐ | |
| `fieldDefaultCurrency` | `varchar2` | Field Default Currency | ☐ | |
| `fieldLabel` | `varchar2` | Field Label | ☑ | |
| `fieldOptions` | `varchar2` | Field Options | ☐ | |
| `fieldType` | `varchar2` | Field Type | ☑ | |
| `hideFieldFlag` | `int64` | Hide Field | ☑ | |
| `id` | `int64` | ID | ☑ | |
| `isFormVisible` | `int64` | Form Visible | ☑ | |
| `isRequired` | `int64` | Required | ☑ | |
| `knownFieldId` | `int64` | Known Field ID | ☐ | |
| `personalization` | `varchar2` | Personalization | ☐ | |
| `updatedTimestamp` | `datetime` | Last Modified | ☑ | |