---
title: "Orders (ActiveCampaign)"
description: "Orders"
language: nl
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/nl/datamodels/activecampaign/ActiveCampaign.CustomObjects.Orders
original: https://documentation.invantive.eu/en/datamodels/activecampaign/ActiveCampaign.CustomObjects.Orders
updated: 2026-11-16T13:02:01Z
license: https://documentation.invantive.eu/nl/
---

# Orders: ActiveCampaign Orders

`insert` `REST`

- Catalogus: `ActiveCampaign`
- Schema: `CustomObjects`
- Primaire sleutels: `id`
- Label: Orders

Met `insert` kun je gegevens ophalen en wijzigen.

## Samenvatting

Orders imported into ActiveCampaign

## API-bron

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

## Prestatiekenmerken

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

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

## Tabelkolommen

De kolommen van de tabel `Orders` 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 |
|---|---|---|:---:|---|---|
| `accepts_marketing` | `varchar2` | Accepteert Marketing | [ ] | filters on the platform, writable, `fields[?(@.id=='accepts-marketing')].value` | Accepteert Marketing |
| `cart_id` | `varchar2` | Winkelwagen-ID | [ ] | filters on the platform, writable, `fields[?(@.id=='cart-id')].value` | Winkelwagen-ID |
| `connection_id` | `varchar2` | Verbinding ID | [ ] | filters on the platform, writable, `fields[?(@.id=='connection-id')].value` | Verbinding ID |
| `createdTimestamp` | `datetime` | Created | [ ] | filters on the platform, writable, computed | Moment of creation. |
| `created_by_recurring_payment` | `varchar2` | Gemaakt door Terugkerende Betaling | [ ] | filters on the platform, writable, `fields[?(@.id=='created-by-recurring-payment')].value` | Created By Recurring Payment |
| `creation_source` | `varchar2` | Scheppingsbron | [ ] | filters on the platform, writable, `fields[?(@.id=='creation-source')].value` | Scheppingsbron |
| `customer_locale` | `varchar2` | Klantlocale | [ ] | filters on the platform, writable, `fields[?(@.id=='customer-locale')].value` | Klantlocale |
| `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` | Kortingen Bedrag | [ ] | filters on the platform, writable, `fields[?(@.id=='discounts-amount')].value` | Kortingen Bedrag |
| `discounts_amount_currency` | `varchar2` | Kortingen Bedrag Valuta | [ ] | filters on the platform, writable, `fields[?(@.id=='discounts-amount')].currency` | Currency of the amount in column discounts_amount. |
| `email` | `varchar2` | E-mailadres | [ ] | filters on the platform, writable, `fields[?(@.id=='email')].value` | Email |
| `field_billing_address_address_1` | `varchar2` | Veld Factuuradres Adres 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` | Veld Factuuradres Adres 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` | Veld Factuuradres Adres 3 | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-address-3')].value` | Billing Address Address Line 3 |
| `field_billing_address_city` | `varchar2` | Veld Factuuradres Stad | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-city')].value` | Factuuradres Stad |
| `field_billing_address_company` | `varchar2` | Veld Factuuradres Bedrijf | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-company')].value` | Factuuradres Bedrijf |
| `field_billing_address_country` | `varchar2` | Veld Factuuradres Land | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-country')].value` | Factuuradres Land |
| `field_billing_address_email` | `varchar2` | Veld Factuuradres E-mail | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-email')].value` | Factuuradres E-mail |
| `field_billing_address_first_name` | `varchar2` | Veld Factuuradres Voornaam | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-first-name')].value` | Factuuradres Voornaam |
| `field_billing_address_last_name` | `varchar2` | Veld Factuuradres Achternaam | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-last-name')].value` | Factuuradres Achternaam |
| `field_billing_address_phone` | `varchar2` | Veld Factuuradres Telefoon | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-phone')].value` | Billing Address Phone Number |
| `field_billing_address_postal` | `varchar2` | Veld Factuuradres Postcode | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-postal')].value` | Factuuradres Postcode |
| `field_billing_address_province` | `varchar2` | Veld Factuuradres Provincie | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-province')].value` | Factuuradres Provincie |
| `field_shipping_address_address_1` | `varchar2` | Verzendadres Adres 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` | Verzendadres Adres 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` | Verzendadres Adres 3 | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-address-3')].value` | Shipping Address Address Line 3 |
| `field_shipping_address_city` | `varchar2` | Verzendadres Stad | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-city')].value` | Verzendadres Stad |
| `field_shipping_address_company` | `varchar2` | Verzendadres Bedrijf | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-company')].value` | Verzendadres Bedrijf |
| `field_shipping_address_country` | `varchar2` | Veld Verzendadres Land | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-country')].value` | Verzendadres Land |
| `field_shipping_address_email` | `varchar2` | Veld Verzendadres E-mail | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-email')].value` | Verzendadres E-mail |
| `field_shipping_address_first_name` | `varchar2` | Veld Verzendadres Voornaam | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-first-name')].value` | Verzendadres Voornaam |
| `field_shipping_address_last_name` | `varchar2` | Veld Verzendadres Achternaam | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-last-name')].value` | Verzendadres Achternaam |
| `field_shipping_address_phone` | `varchar2` | Veld Verzendadres Telefoonnummer | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-phone')].value` | Verzendadres Telefoon |
| `field_shipping_address_postal` | `varchar2` | Veld Verzendadres Postcode | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-postal')].value` | Verzendadres Postcode |
| `field_shipping_address_province` | `varchar2` | Veld Verzendadres Provincie | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-province')].value` | Verzendadres Provincie |
| `final_amount` | `decimal` | Eindbedrag | [ ] | filters on the platform, writable, `fields[?(@.id=='final-amount')].value` | Eindbedrag |
| `final_amount_currency` | `varchar2` | Eindbedrag Valuta | [ ] | 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 Testorder | [ ] | filters on the platform, writable, `fields[?(@.id=='is-test-order')].value` | Is Testorder |
| `legacy_connection_id` | `int64` | Oude Verbindings-ID | [ ] | filters on the platform, writable, `fields[?(@.id=='legacy-connection-id')].value` | Oude Verbindings-ID |
| `location_id` | `varchar2` | Locatie ID | [ ] | filters on the platform, writable, `fields[?(@.id=='location-id')].value` | Locatie ID |
| `normalized_status` | `varchar2` | Genormaliseerde Status | [ ] | filters on the platform, writable, `fields[?(@.id=='normalized-status')].value` | Orderstatus |
| `notes` | `varchar2` | Notes | [ ] | filters on the platform, writable, `fields[?(@.id=='notes')].value` | Notes |
| `order_number` | `varchar2` | Ordernummer | [ ] | filters on the platform, writable, `fields[?(@.id=='order-number')].value` | Ordernummer |
| `order_url` | `varchar2` | Bestelling URL | [ ] | filters on the platform, writable, `fields[?(@.id=='order-url')].value` | Bestelling URL |
| `payment_method` | `varchar2` | Betalingsmethode | [ ] | filters on the platform, writable, `fields[?(@.id=='payment-method')].value` | Betalingsmethode |
| `primary_contact` | `varchar2` | Primaire Contactpersoon | [ ] | filters on the platform, writable, `relationships.primary-contact` | Contact for Order |
| `sales_channel` | `varchar2` | Verkoopkanaal | [ ] | 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` | Verzendbedrag | [ ] | filters on the platform, writable, `fields[?(@.id=='shipping-amount')].value` | Verzendbedrag |
| `shipping_amount_currency` | `varchar2` | Verzendkosten Valuta | [ ] | filters on the platform, writable, `fields[?(@.id=='shipping-amount')].currency` | Currency of the amount in column shipping_amount. |
| `shipping_method` | `varchar2` | Verzendwijze | [ ] | filters on the platform, writable, `fields[?(@.id=='shipping-method')].value` | Verzendwijze |
| `store_created_date` | `datetime` | Winkel Aanmaakdatum | [ ] | filters on the platform, writable, `fields[?(@.id=='store-created-date')].value` | Winkel Aanmaakdatum |
| `store_customer_id` | `varchar2` | Winkel Klant-ID | [ ] | filters on the platform, writable, `fields[?(@.id=='store-customer-id')].value` | Store's Customer ID |
| `store_external_order_id` | `varchar2` | Winkel Externe Order-ID | [ ] | filters on the platform, writable, `fields[?(@.id=='store-external-order-id')].value` | Store's External Order ID |
| `store_modified_date` | `datetime` | Winkel Wijzigingsdatum | [ ] | filters on the platform, writable, `fields[?(@.id=='store-modified-date')].value` | Winkel Wijzigingsdatum |
| `store_order_id` | `varchar2` | Winkel Order-ID | [ ] | filters on the platform, writable, `fields[?(@.id=='store-order-id')].value` | Store's Order ID |
| `store_status` | `varchar2` | Winkelstatus | [ ] | filters on the platform, writable, `fields[?(@.id=='store-status')].value` | Store's Order Status |
| `updatedTimestamp` | `datetime` | Laatst Gewijzigd | [ ] | filters on the platform, writable, computed | Moment of last change. |


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

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

##### Tabel ActiveCampaign.CustomObjects.Orders is toegevoegd

De tabel heeft 60 kolommen en ondersteunt de bewerkingen `select` en `insert`.

<div class="rn-chips">

- belang 3

</div>

</div>

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