---
title: "Deals (ActiveCampaign)"
description: "Deals"
language: en
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/de/datamodels/activecampaign/ActiveCampaign.V3.Deals
original: https://documentation.invantive.eu/en/datamodels/activecampaign/ActiveCampaign.V3.Deals
updated: 2026-11-01T17:44:09Z
license: https://documentation.invantive.eu/de/
---

# Deals: ActiveCampaign Deals

`popular` `insert` `update` `delete` `REST`

- Catalog: `ActiveCampaign`
- Schema: `V3`
- Primary Keys: `id`
- Label: Deals

Can retrieve data and change data using `insert`, `update` and `delete`.

## API Source

- Endpoint: `/deals`

## Performance Characteristics

| Characteristic | Value |
|---|---:|
| Average access latency (ms) | 228 |
| Full scan rows per minute | 13,500 |

The result can be cached on the client.

## 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 | Marks | Documentation |
|---|---|---|:---:|---|---|
| `account` | `int64` | Account | [ ] | filters on the platform, writable | Reference to the account. |
| `activitycount` | `int64` | Activity Count | [ ] | filters on the platform, writable |  |
| `cdate` | `datetime` | Created | [ ] | filters on the platform, writable, computed | Creation date. |
| `contact` | `int64` | Contact | [ ] | filters on the platform, writable | ID of the primary contact. |
| `currency` | `varchar2` | Currency | [ ] | filters on the platform, writable | Currency code for the money value. |
| `customerAccount` | `int64` | Customer Account | [ ] | filters on the platform, writable |  |
| `description` | `varchar2(4000)` | Description | [ ] | filters on the platform, writable | Description of the deal. |
| `edate` | `datetime` | itgen_acn_edate | [ ] | filters on the platform, writable |  |
| `group` | `int64` | Group | [ ] | filters on the platform, writable | ID of the pipeline. |
| `hash` | `varchar2` | Hash | [ ] | filters on the platform, writable, computed | Hash identifying the deal in the user interface. |
| `id` | `int64` | ID | [x] | filters on the platform, writable, computed |  |
| `isDisabled` | `char` | Disabled | [x] | filters on the platform, writable |  |
| `mdate` | `datetime` | Last Modified | [ ] | filters on the platform, writable, computed | Last modified date. |
| `nextdate` | `datetime` | Next Date | [ ] | filters on the platform, writable |  |
| `nextdealid` | `int64` | Next Deal ID | [ ] | filters on the platform, writable |  |
| `nexttaskid` | `int64` | Next Task ID | [ ] | filters on the platform, writable |  |
| `organization` | `int64` | Account | [ ] | filters on the platform, writable | Deprecated. Do not use. |
| `owner` | `int64` | Owner | [ ] | filters on the platform, writable | ID of the user owning the deal. |
| `percent` | `decimal` | Percentage | [ ] | filters on the platform, writable | Percentage of the deal. |
| `stage` | `int64` | Stage | [ ] | filters on the platform, writable | ID of the stage. |
| `status` | `int64` | Status | [x] | filters on the platform, writable | 0 is Open, 1 is Won and 2 is Lost. |
| `title` | `varchar2` | Title | [ ] | filters on the platform, writable | Title of the deal. |
| `value` | `int64` | Value | [ ] | filters on the platform, writable | Values for the field. For currency fields in cents. |
| `winProbability` | `int64` | Win Probability | [ ] | filters on the platform, writable |  |
| `winProbabilityMdate` | `datetime` | Win Probability Last Updated | [ ] | filters on the platform, writable |  |

## Keys

| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
| `Deals_account_fk` | `account` | [Accounts](ActiveCampaign.V3.Accounts)`.id` | Key |  |
| `Deals_customerAccount_cnd` | `customerAccount` | [Accounts](ActiveCampaign.V3.Accounts)`.id` | Candidate | Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read. |
| `Deals_group_fk` | `group` | [Pipelines](ActiveCampaign.V3.Pipelines)`.id` | Key |  |
| `Deals_owner_fk` | `owner` | [Users](ActiveCampaign.V3.Users)`.id` | Key |  |
| `Deals_stage_fk` | `stage` | [Stages](ActiveCampaign.V3.Stages)`.id` | Key |  |

## Referenced By

- [DealCustomFieldValues](ActiveCampaign.V3.DealCustomFieldValues) `dealId` (Candidate)
- [DealWithActivities](ActiveCampaign.V3.DealWithActivities) `deal` (Candidate)
- [SecondaryContacts](ActiveCampaign.V3.SecondaryContacts) `deal` (Candidate)



## Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert:

- [ActiveCampaign](/de/release-notes/drivers?driver=activecampaign)

### Änderungen an dieser Tabelle, 26.0 bis 27.0

<a id="ACN-27.0-D061"></a>

- `+` `hash` (`varchar2`)

[Alle Treiberwechsel, 26.0 bis 27.0](/de/release-notes/drivers?driver=activecampaign&step=26.0-to-27.0#activecampaign-26.0-to-27.0)
