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

# Orders: ActiveCampaign Orders

`insert` `REST`

- Catalog: `ActiveCampaign`
- Schema: `CustomObjects`
- Primary Keys: `id`
- Label: Orders

Can retrieve data and change data using `insert`.

## Summary

Orders imported into ActiveCampaign

## API Source

- Endpoint: `/customObjects/records/42376388-ff77-49e2-a175-fd92566d749c`

## Performance Characteristics

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

The result can be cached on the client.

## Table Columns

The columns of the table `Orders` 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 |
|---|---|---|:---:|---|---|
| `accepts_marketing` | `varchar2` | Accepts Marketing | [ ] | filters on the platform, writable, `fields[?(@.id=='accepts-marketing')].value` | Accepts Marketing |
| `cart_id` | `varchar2` | Cart ID | [ ] | filters on the platform, writable, `fields[?(@.id=='cart-id')].value` | Cart ID |
| `connection_id` | `varchar2` | Connection ID | [ ] | filters on the platform, writable, `fields[?(@.id=='connection-id')].value` | Connection ID |
| `createdTimestamp` | `datetime` | Created | [ ] | filters on the platform, writable, computed | Moment of creation. |
| `created_by_recurring_payment` | `varchar2` | Created by Recurring Payment | [ ] | filters on the platform, writable, `fields[?(@.id=='created-by-recurring-payment')].value` | Created By Recurring Payment |
| `creation_source` | `varchar2` | Creation Source | [ ] | filters on the platform, writable, `fields[?(@.id=='creation-source')].value` | Creation Source |
| `customer_locale` | `varchar2` | Customer Locale | [ ] | filters on the platform, writable, `fields[?(@.id=='customer-locale')].value` | Customer Locale |
| `customer_phone` | `varchar2` | itgen_acn_customer_phone | [ ] | filters on the platform, writable, `fields[?(@.id=='customer-phone')].value` | Customer Phone |
| `discounts` | `varchar2` | Discounts | [ ] | filters on the platform, writable, `fields[?(@.id=='discounts')].value` | Order Discount |
| `discounts_amount` | `decimal` | Discounts Amount | [ ] | filters on the platform, writable, `fields[?(@.id=='discounts-amount')].value` | Discounts Amount |
| `discounts_amount_currency` | `varchar2` | Discounts Amount Currency | [ ] | filters on the platform, writable, `fields[?(@.id=='discounts-amount')].currency` | Currency of the amount in column discounts_amount. |
| `email` | `varchar2` | Email Address | [ ] | filters on the platform, writable, `fields[?(@.id=='email')].value` | Email |
| `field_billing_address_address_1` | `varchar2` | Field Billing Address Address 1 | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-address-1')].value` | Billing Address Address Line 1 |
| `field_billing_address_address_2` | `varchar2` | Field Billing Address Address 2 | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-address-2')].value` | Billing Address Address Line 2 |
| `field_billing_address_address_3` | `varchar2` | Field Billing Address Address 3 | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-address-3')].value` | Billing Address Address Line 3 |
| `field_billing_address_city` | `varchar2` | Field Billing Address City | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-city')].value` | Billing Address City |
| `field_billing_address_company` | `varchar2` | Field Billing Address Company | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-company')].value` | Billing Address Company |
| `field_billing_address_country` | `varchar2` | Field Billing Address Country | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-country')].value` | Billing Address Country |
| `field_billing_address_email` | `varchar2` | Field Billing Address Email | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-email')].value` | Billing Address Email |
| `field_billing_address_first_name` | `varchar2` | Field Billing Address First Name | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-first-name')].value` | Billing Address First Name |
| `field_billing_address_last_name` | `varchar2` | Field Billing Address Last Name | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-last-name')].value` | Billing Address Last Name |
| `field_billing_address_phone` | `varchar2` | Field Billing Address Phone | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-phone')].value` | Billing Address Phone Number |
| `field_billing_address_postal` | `varchar2` | Field Billing Address Postal | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-postal')].value` | Billing Address Postal Code |
| `field_billing_address_province` | `varchar2` | Field Billing Address Province | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-province')].value` | Billing Address Province |
| `field_shipping_address_address_1` | `varchar2` | Field Shipping Address Address 1 | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-address-1')].value` | Shipping Address Address Line 1 |
| `field_shipping_address_address_2` | `varchar2` | Field Shipping Address Address 2 | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-address-2')].value` | Shipping Address Address Line 2 |
| `field_shipping_address_address_3` | `varchar2` | Field Shipping Address Address 3 | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-address-3')].value` | Shipping Address Address Line 3 |
| `field_shipping_address_city` | `varchar2` | Field Shipping Address City | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-city')].value` | Shipping Address City |
| `field_shipping_address_company` | `varchar2` | Field Shipping Address Company | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-company')].value` | Shipping Address Company |
| `field_shipping_address_country` | `varchar2` | Field Shipping Address Country | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-country')].value` | Shipping Address Country |
| `field_shipping_address_email` | `varchar2` | Field Shipping Address Email | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-email')].value` | Shipping Address Email |
| `field_shipping_address_first_name` | `varchar2` | Field Shipping Address First Name | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-first-name')].value` | Shipping Address First Name |
| `field_shipping_address_last_name` | `varchar2` | Field Shipping Address Last Name | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-last-name')].value` | Shipping Address Last Name |
| `field_shipping_address_phone` | `varchar2` | Field Shipping Address Phone | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-phone')].value` | Shipping Address Phone |
| `field_shipping_address_postal` | `varchar2` | Field Shipping Address Postal | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-postal')].value` | Shipping Address Postal |
| `field_shipping_address_province` | `varchar2` | Field Shipping Address Province | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-province')].value` | Shipping Address Province |
| `final_amount` | `decimal` | Final Amount | [ ] | filters on the platform, writable, `fields[?(@.id=='final-amount')].value` | Final Amount |
| `final_amount_currency` | `varchar2` | Final Amount Currency | [ ] | filters on the platform, writable, `fields[?(@.id=='final-amount')].currency` | Currency of the amount in column final_amount. |
| `id` | `varchar2` | ID | [x] | filters on the platform, writable, computed | Unique ID of the record, in the form of a GUID. |
| `is_test_order` | `varchar2` | Is Test Order | [ ] | filters on the platform, writable, `fields[?(@.id=='is-test-order')].value` | Is Test Order |
| `legacy_connection_id` | `int64` | Legacy Connection ID | [ ] | filters on the platform, writable, `fields[?(@.id=='legacy-connection-id')].value` | Legacy Connection ID |
| `location_id` | `varchar2` | Location ID | [ ] | filters on the platform, writable, `fields[?(@.id=='location-id')].value` | Location ID |
| `normalized_status` | `varchar2` | Normalized Status | [ ] | filters on the platform, writable, `fields[?(@.id=='normalized-status')].value` | Order Status |
| `notes` | `varchar2` | Notes | [ ] | filters on the platform, writable, `fields[?(@.id=='notes')].value` | Notes |
| `order_number` | `varchar2` | Order Number | [ ] | filters on the platform, writable, `fields[?(@.id=='order-number')].value` | Order Number |
| `order_url` | `varchar2` | Order URL | [ ] | filters on the platform, writable, `fields[?(@.id=='order-url')].value` | Order URL |
| `payment_method` | `varchar2` | Payment Method | [ ] | filters on the platform, writable, `fields[?(@.id=='payment-method')].value` | Payment Method |
| `primary_contact` | `varchar2` | Primary Contact | [ ] | filters on the platform, writable, `relationships.primary-contact` | Contact for Order |
| `sales_channel` | `varchar2` | Sales Channel | [ ] | filters on the platform, writable, `fields[?(@.id=='sales-channel')].value` | Channel |
| `schemaId` | `varchar2` | Schema ID | [ ] | filters on the platform, writable, computed | Unique ID of the custom object the record belongs to. |
| `shipping_amount` | `decimal` | Shipping Amount | [ ] | filters on the platform, writable, `fields[?(@.id=='shipping-amount')].value` | Shipping Amount |
| `shipping_amount_currency` | `varchar2` | Shipping Amount Currency | [ ] | filters on the platform, writable, `fields[?(@.id=='shipping-amount')].currency` | Currency of the amount in column shipping_amount. |
| `shipping_method` | `varchar2` | Shipping Method | [ ] | filters on the platform, writable, `fields[?(@.id=='shipping-method')].value` | Shipping Method |
| `store_created_date` | `datetime` | Store Created Date | [ ] | filters on the platform, writable, `fields[?(@.id=='store-created-date')].value` | Store Created Date |
| `store_customer_id` | `varchar2` | Store Customer ID | [ ] | filters on the platform, writable, `fields[?(@.id=='store-customer-id')].value` | Store's Customer ID |
| `store_external_order_id` | `varchar2` | Store External Order ID | [ ] | filters on the platform, writable, `fields[?(@.id=='store-external-order-id')].value` | Store's External Order ID |
| `store_modified_date` | `datetime` | Store Modified Date | [ ] | filters on the platform, writable, `fields[?(@.id=='store-modified-date')].value` | Store Modified Date |
| `store_order_id` | `varchar2` | Store Order ID | [ ] | filters on the platform, writable, `fields[?(@.id=='store-order-id')].value` | Store's Order ID |
| `store_status` | `varchar2` | Store Status | [ ] | filters on the platform, writable, `fields[?(@.id=='store-status')].value` | Store's Order Status |
| `updatedTimestamp` | `datetime` | Last Modified | [ ] | filters on the platform, writable, computed | Moment of last change. |



## 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

<div class="rn-item" id="ACN-27.0-D007">

##### Se ha añadido la tabla ActiveCampaign.CustomObjects.Orders

La tabla tiene 60 columnas y admite las operaciones «select» e «insert».

<div class="rn-chips">

- importancia 3

</div>

</div>

[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)
