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

# Deals: ActiveCampaign Deals

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

- Catálogo: `ActiveCampaign`
- Esquema: `V3`
- Llaves Primarias: `id`
- Label: Deals

Permite recuperar y modificar datos utilizando `insert`, `update` y `delete`.

## Fuente de la API

- Punto final: `/deals`

## Características de rendimiento

| Characteristic | Value |
|---|---:|
| Latencia media de acceso (ms) | 228 |
| Número de filas escaneadas por minuto | 13,500 |

El resultado se puede almacenar en la Caché del cliente.

## Columnas de la Tabla

A continuación se muestran las columnas de la tabla `Deals`. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `account` | `int64` | Account | [ ] | filters on the platform, writable | Reference to the account. |
| `activitycount` | `int64` | Contador de Actividades | [ ] | 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` | Cuenta del Cliente | [ ] | 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` | Última Modificación | [ ] | filters on the platform, writable, computed | Last modified date. |
| `nextdate` | `datetime` | Próxima Fecha | [ ] | filters on the platform, writable |  |
| `nextdealid` | `int64` | ID de la Próxima Oferta | [ ] | filters on the platform, writable |  |
| `nexttaskid` | `int64` | ID de la Siguiente Tarea | [ ] | 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` | Probabilidad de Ganar | [ ] | filters on the platform, writable |  |
| `winProbabilityMdate` | `datetime` | Última Actualización de Probabilidad de Ganar | [ ] | filters on the platform, writable |  |

## Teclas

| Key | Column | Se refiere a | 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 |  |

## Referenciado por

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


## Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador:

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

### Modificaciones de esta tabla, De 26.0 a 27.0

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

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

[Todos los cambios del conductor, De 26.0 a 27.0](/es/release-notes/drivers?driver=activecampaign&step=26.0-to-27.0#activecampaign-26.0-to-27.0)
