# DealWithContacts: ActiveCampaign Deal Contacts - Catalog: `ActiveCampaign` - Schema: `V3` - Primary Keys: `id` - Label: Deal Contacts This is a read-only table. The ActiveCampaign API may not support changing the data or the Invantive UniversalSQL driver for ActiveCampaign does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the ActiveCampaign API. ## Table Columns The columns of the table `DealWithContacts` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `adate` | `datetime` | | ☐ | | | `anonymized` | `int64` | | ☑ | | | `bounced_date` | `datetime` | Bounced Date | ☐ | | | `bounced_hard` | `int64` | Bounced Hard | ☑ | | | `bounced_soft` | `int64` | Bounced Soft | ☑ | | | `cdate` | `datetime` | Created | ☐ | | | `created_by` | `varchar2` | Created by | ☐ | | | `created_timestamp` | `datetime` | Created | ☑ | | | `created_utc_timestamp` | `datetime` | | ☑ | | | `deleted_at` | `datetime` | | ☐ | | | `deleted` | `int64` | Deleted | ☑ | | | `edate` | `datetime` | | ☐ | | | `email_domain` | `varchar2` | | ☐ | | | `email_empty` | `char` | | ☐ | | | `email_local` | `varchar2` | | ☐ | | | `email` | `varchar2` | Email Address | ☐ | | | `firstName` | `varchar2` | First Name | ☐ | | | `gravatar` | `int64` | Gravatar | ☑ | | | `hash` | `varchar2` | Hash | ☐ | | | `id` | `int64` | ID | ☑ | Unique ID. | | `ip` | `int64` | IP Address | ☐ | | | `lastName` | `varchar2` | Last Name | ☐ | | | `orgid` | `int64` | Organisation ID | ☐ | | | `orgname` | `varchar2` | | ☐ | | | `phone` | `varchar2` | Phone | ☐ | | | `rating_tstamp` | `datetime` | Rating Date | ☐ | | | `segmentio_id` | `int64` | | ☐ | | | `sentcnt` | `int64` | | ☑ | | | `sentiment` | `varchar2` | | ☐ | | | `socialdata_lastcheck` | `datetime` | Social Data Last Check | ☐ | | | `ua` | `varchar2` | | ☐ | | | `udate` | `datetime` | Last Updated | ☐ | | | `updated_by` | `varchar2` | Updated by | ☐ | | | `updated_timestamp` | `datetime` | Updated | ☑ | | | `updated_utc_timestamp` | `datetime` | | ☑ | |