# ArchivedDeals ## Documentation The archived deals. Each request costs 20 tokens of the daily budget of the company. - Catalog: `Pipedrive` - Schema: `Deals` - Primary Keys: `id` - Retrieve: True - Insert: False - Update: True - Delete: True ## Table Columns The columns of the table `ArchivedDeals` 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 update. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `acme_contract_period_until` | `datetime` | ACME Contract Period | ☐ | Part 'acme_contract_period_until' of the custom field 'ACME Contract Period' of the company. | | `acme_contract_period` | `datetime` | ACME Contract Period | ☐ | The custom field 'ACME Contract Period' of the company. | | `acme_contract_value_currency` | `varchar2` | ACME Contract Value | ☐ | Part 'acme_contract_value_currency' of the custom field 'ACME Contract Value' of the company. | | `acme_contract_value` | `decimal` | ACME Contract Value | ☐ | The custom field 'ACME Contract Value' of the company. | | `acme_delivery_address_admin_area_level_1` | `varchar2` | ACME Delivery Address | ☐ | Part 'acme_delivery_address_admin_area_level_1' of the custom field 'ACME Delivery Address' of the company. | | `acme_delivery_address_admin_area_level_2` | `varchar2` | ACME Delivery Address | ☐ | Part 'acme_delivery_address_admin_area_level_2' of the custom field 'ACME Delivery Address' of the company. | | `acme_delivery_address_country` | `varchar2` | ACME Delivery Address | ☐ | Part 'acme_delivery_address_country' of the custom field 'ACME Delivery Address' of the company. | | `acme_delivery_address_formatted_address` | `varchar2` | ACME Delivery Address | ☐ | Part 'acme_delivery_address_formatted_address' of the custom field 'ACME Delivery Address' of the company. | | `acme_delivery_address_locality` | `varchar2` | ACME Delivery Address | ☐ | Part 'acme_delivery_address_locality' of the custom field 'ACME Delivery Address' of the company. | | `acme_delivery_address_postal_code` | `varchar2` | ACME Delivery Address | ☐ | Part 'acme_delivery_address_postal_code' of the custom field 'ACME Delivery Address' of the company. | | `acme_delivery_address_route` | `varchar2` | ACME Delivery Address | ☐ | Part 'acme_delivery_address_route' of the custom field 'ACME Delivery Address' of the company. | | `acme_delivery_address_street_number` | `varchar2` | ACME Delivery Address | ☐ | Part 'acme_delivery_address_street_number' of the custom field 'ACME Delivery Address' of the company. | | `acme_delivery_address_sublocality` | `varchar2` | ACME Delivery Address | ☐ | Part 'acme_delivery_address_sublocality' of the custom field 'ACME Delivery Address' of the company. | | `acme_delivery_address_subpremise` | `varchar2` | ACME Delivery Address | ☐ | Part 'acme_delivery_address_subpremise' of the custom field 'ACME Delivery Address' of the company. | | `acme_delivery_address` | `varchar2` | ACME Delivery Address | ☐ | The custom field 'ACME Delivery Address' of the company. | | `acme_external_reference` | `varchar2` | ACME External Reference | ☐ | The custom field 'ACME External Reference' of the company. | | `acme_product_lines_labels` | `varchar2` | ACME Product Lines Labels | ☐ | The labels of the chosen options of the custom field 'ACME Product Lines'. | | `acme_product_lines` | `varchar2` | ACME Product Lines | ☐ | The custom field 'ACME Product Lines' of the company. | | `acme_region_label` | `varchar2` | ACME Region Label | ☐ | The labels of the chosen options of the custom field 'ACME Region'. | | `acme_region` | `int64` | ACME Region | ☐ | The custom field 'ACME Region' of the company. | | `acme_renewal_date` | `datetime` | ACME Renewal Date | ☐ | The custom field 'ACME Renewal Date' of the company. | | `acme_seats` | `decimal` | ACME Seats | ☐ | The custom field 'ACME Seats' of the company. | | `acv` | `decimal` | | ☐ | The Annual Contract Value of the deal. Only on the Growth plan and above. | | `add_time` | `datetime` | | ☐ | The creation date and time of the deal. | | `archive_time` | `datetime` | | ☐ | The optional date and time of archiving the deal in UTC. Only taken when writing; empty when read. | | `arr` | `decimal` | | ☐ | The Annual Recurring Revenue of the deal. Only on the Growth plan and above. | | `channel_id` | `varchar2` | | ☐ | The optional ID to further distinguish the Marketing channel. | | `channel` | `int64` | | ☐ | The ID of your Marketing channel this Deal was created from. | | `close_time` | `datetime` | | ☐ | The date and time of closing the deal. | | `currency` | `varchar2` | | ☐ | The currency associated with the deal. | | `expected_close_date` | `datetime` | | ☐ | The expected close date of the deal. | | `id` | `int64` | | ☑ | The ID of the deal. | | `is_archived` | `char` | | ☐ | Whether the deal is archived or not. | | `is_deleted` | `char` | | ☐ | Whether the deal is deleted or not. | | `label_ids` | `varchar2` | | ☐ | The IDs of labels assigned to the deal. | | `lost_reason` | `varchar2` | | ☐ | The reason for losing the deal. | | `lost_time` | `datetime` | | ☐ | The date and time of changing the deal status as lost. | | `mrr` | `decimal` | | ☐ | The Monthly Recurring Revenue of the deal. Only on the Growth plan and above. | | `org_id` | `int64` | | ☐ | The ID of the organization linked to the deal. | | `origin_id` | `varchar2` | | ☐ | The optional ID to further distinguish the origin of the deal - e.g. Which API integration created this Deal. | | `origin` | `varchar2` | | ☐ | The way this Deal was created. | | `owner_id` | `int64` | | ☐ | The ID of the user who owns the deal. | | `person_id` | `int64` | | ☐ | The ID of the person linked to the deal. | | `pipeline_id` | `int64` | | ☐ | The ID of the pipeline associated with the deal. | | `probability` | `decimal` | | ☐ | The success probability percentage of the deal. | | `source_lead_id` | `varchar2` | | ☐ | The ID of the lead if the deal was converted from a lead. | | `stage_change_time` | `datetime` | | ☐ | The last updated date and time of the deal stage. | | `stage_id` | `int64` | | ☐ | The ID of the deal stage. | | `status` | `varchar2` | | ☐ | The status of the deal. | | `title` | `varchar2` | | ☐ | The title of the deal. | | `update_time` | `datetime` | | ☐ | The last updated date and time of the deal. | | `value` | `decimal` | | ☐ | The value of the deal. | | `visible_to` | `int64` | | ☐ | The visibility of the deal. | | `won_time` | `datetime` | | ☐ | The date and time of changing the deal status as won. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `currency` | [[Settings-Currencies\|Settings.Currencies]] | `code` | Declared by the connector, not enforced by the platform | | `org_id` | [[Contacts-Organizations\|Contacts.Organizations]] | `id` | Declared by the connector, not enforced by the platform | | `origin` | [[Leads-LeadSources\|Leads.LeadSources]] | `name` | Candidate: Follows from the name of the column and held in every row of the sandbox on 2026-10-31; not stated by Pipedrive. | | `owner_id` | [[Users-Users\|Users.Users]] | `id` | Declared by the connector, not enforced by the platform | | `person_id` | [[Contacts-Persons\|Contacts.Persons]] | `id` | Declared by the connector, not enforced by the platform | | `pipeline_id` | [[Pipelines-Pipelines\|Pipelines.Pipelines]] | `id` | Declared by the connector, not enforced by the platform | | `source_lead_id` | [[Leads-Leads\|Leads.Leads]] | `id` | In words only: The lead the deal was converted from, in Leads or, once archived, in ArchivedLeads. | | `source_lead_id` | [[Leads-ArchivedLeads\|Leads.ArchivedLeads]] | `id` | In words only: The lead the deal was converted from, in Leads or, once archived, in ArchivedLeads. | | `stage_id` | [[Pipelines-Stages\|Pipelines.Stages]] | `id` | Declared by the connector, not enforced by the platform | ## Referenced By The columns of these tables refer to a row of this table. | Table | Columns | Guarantee | |---|---|---| | [[Activities-Activities\|Activities.Activities]] | `deal_id` | In words only: The deal, in Deals or, once archived, in ArchivedDeals; a deleted deal stays readable for 30 days with status 'deleted'. | | [[Activities-CallLogs\|Activities.CallLogs]] | `deal_id` | In words only: The deal, in Deals or, once archived, in ArchivedDeals; a deleted deal stays readable for 30 days with status 'deleted'. | | [[Leads-ArchivedLeads\|Leads.ArchivedLeads]] | `source_deal_id` | In words only: The deal the lead was converted from, in Deals or, once archived, in ArchivedDeals. | | [[Leads-Leads\|Leads.Leads]] | `source_deal_id` | In words only: The deal the lead was converted from, in Deals or, once archived, in ArchivedDeals. | | [[Notes-Files\|Notes.Files]] | `deal_id` | In words only: The deal, in Deals or, once archived, in ArchivedDeals; a deleted deal stays readable for 30 days with status 'deleted'. | | [[Notes-Notes\|Notes.Notes]] | `deal_id` | In words only: The deal, in Deals or, once archived, in ArchivedDeals; a deleted deal stays readable for 30 days with status 'deleted'. |