---
title: "Deals (ActiveCampaign)"
description: "Deals"
language: nl
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/nl/datamodels/activecampaign/ActiveCampaign.V3.Deals
original: https://documentation.invantive.eu/en/datamodels/activecampaign/ActiveCampaign.V3.Deals
updated: 2026-11-17T12:36:32Z
license: https://documentation.invantive.eu/nl/
---

# Deals: ActiveCampaign Deals

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

- Catalogus: `ActiveCampaign`
- Schema: `V3`
- Primaire sleutels: `id`
- Label: Deals

Je kunt gegevens ophalen en wijzigen met `insert`, `update` en `delete`.

## API-bron

- Eindpunt: `/deals`

## Prestatiekenmerken

| Characteristic | Value |
|---|---:|
| Gemiddelde toegangsvertraging (ms) | 228 |
| Aantal rijen per minuut bij volledige scan | 13,500 |

Het resultaat kan op de client in de Cache worden opgeslagen.

## Tabelkolommen

De kolommen van de tabel `Deals` worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `account` | `int64` | Account | [ ] | filters on the platform, writable | Reference to the account. |
| `activitycount` | `int64` | Aantal Activiteiten | [ ] | 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` | Klantaccount | [ ] | 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` | Laatst Gewijzigd | [ ] | filters on the platform, writable, computed | Last modified date. |
| `nextdate` | `datetime` | Volgende Datum | [ ] | filters on the platform, writable |  |
| `nextdealid` | `int64` | Volgende Deal ID | [ ] | filters on the platform, writable |  |
| `nexttaskid` | `int64` | Volgende Taak 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` | Winkans | [ ] | filters on the platform, writable |  |
| `winProbabilityMdate` | `datetime` | Winwaarschijnlijkheid Laatst Bijgewerkt | [ ] | filters on the platform, writable |  |

## Toetsen

| Key | Column | Verwijst naar | 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 |  |

## Geciteerd door

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


## Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver:

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

### Wijzigingen in deze tabel, 26.0 tot 27.0

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

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

[Alle wisselingen van de Driver, 26.0 tot 27.0](/nl/release-notes/drivers?driver=activecampaign&step=26.0-to-27.0#activecampaign-26.0-to-27.0)
