# Deals: ActiveCampaign Deals - Catalog: `ActiveCampaign` - Schema: `V3` - Primary Keys: `id` - Label: Deals Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `Deals` 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 | |---|:---:|---|:---:|---| | `account` | `int64` | Account | ☐ | Reference to the account. | | `activitycount` | `int64` | Activity Count | ☐ | | | `cdate` | `datetime` | Created | ☐ | Creation date. | | `contact` | `int64` | Contact | ☐ | ID of the primary contact. | | `currency` | `varchar2` | Currency | ☐ | Currency code for the money value. | | `customerAccount` | `int64` | Customer Account | ☐ | | | `description` | `varchar2(4000)` | Description | ☐ | Description of the deal. | | `edate` | `datetime` | | ☐ | | | `group` | `int64` | Group | ☐ | ID of the pipeline. | | `id` | `int64` | ID | ☑ | | | `isDisabled` | `char` | Disabled | ☑ | | | `mdate` | `datetime` | Last Modified | ☐ | Last modified date. | | `nextdate` | `datetime` | Next Date | ☐ | | | `nextdealid` | `int64` | Next Deal ID | ☐ | | | `nexttaskid` | `int64` | Next Task ID | ☐ | | | `organization` | `int64` | Account | ☐ | Deprecated. Do not use. | | `owner` | `int64` | Owner | ☐ | ID of the user owning the deal. | | `percent` | `decimal` | Percentage | ☐ | Percentage of the deal. | | `stage` | `int64` | Stage | ☐ | ID of the stage. | | `status` | `int64` | Status | ☑ | 0 is Open, 1 is Won and 2 is Lost. | | `title` | `varchar2` | Title | ☐ | Title of the deal. | | `value` | `int64` | Value | ☐ | Values for the field. For currency fields in cents. | | `winProbability` | `int64` | Win Probability | ☐ | | | `winProbabilityMdate` | `datetime` | Win Probability Last Updated | ☐ | |