# Orders: ActiveCampaign Orders ## Documentation Orders imported into ActiveCampaign - Catalog: `ActiveCampaign` - Schema: `CustomObjects` - Primary Keys: `id` - Label: Orders - Retrieve: True - Insert: True - Update: False - Delete: False ## 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. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `accepts_marketing` | `varchar2` | Accepts Marketing | ☐ | Accepts Marketing | | `cart_id` | `varchar2` | Cart ID | ☐ | Cart ID | | `connection_id` | `varchar2` | Connection ID | ☐ | Connection ID | | `createdTimestamp` | `datetime` | Created | ☐ | Moment of creation. | | `created_by_recurring_payment` | `varchar2` | Created by Recurring Payment | ☐ | Created By Recurring Payment | | `creation_source` | `varchar2` | Creation Source | ☐ | Creation Source | | `customer_locale` | `varchar2` | Customer Locale | ☐ | Customer Locale | | `customer_phone` | `varchar2` | | ☐ | Customer Phone | | `discounts_amount_currency` | `varchar2` | Discounts Amount Currency | ☐ | Currency of the amount in column discounts_amount. | | `discounts_amount` | `decimal` | Discounts Amount | ☐ | Discounts Amount | | `discounts` | `varchar2` | Discounts | ☐ | Order Discount | | `email` | `varchar2` | Email Address | ☐ | Email | | `field_billing_address_address_1` | `varchar2` | Field Billing Address Address 1 | ☐ | Billing Address Address Line 1 | | `field_billing_address_address_2` | `varchar2` | Field Billing Address Address 2 | ☐ | Billing Address Address Line 2 | | `field_billing_address_address_3` | `varchar2` | Field Billing Address Address 3 | ☐ | Billing Address Address Line 3 | | `field_billing_address_city` | `varchar2` | Field Billing Address City | ☐ | Billing Address City | | `field_billing_address_company` | `varchar2` | Field Billing Address Company | ☐ | Billing Address Company | | `field_billing_address_country` | `varchar2` | Field Billing Address Country | ☐ | Billing Address Country | | `field_billing_address_email` | `varchar2` | Field Billing Address Email | ☐ | Billing Address Email | | `field_billing_address_first_name` | `varchar2` | Field Billing Address First Name | ☐ | Billing Address First Name | | `field_billing_address_last_name` | `varchar2` | Field Billing Address Last Name | ☐ | Billing Address Last Name | | `field_billing_address_phone` | `varchar2` | Field Billing Address Phone | ☐ | Billing Address Phone Number | | `field_billing_address_postal` | `varchar2` | Field Billing Address Postal | ☐ | Billing Address Postal Code | | `field_billing_address_province` | `varchar2` | Field Billing Address Province | ☐ | Billing Address Province | | `field_shipping_address_address_1` | `varchar2` | Field Shipping Address Address 1 | ☐ | Shipping Address Address Line 1 | | `field_shipping_address_address_2` | `varchar2` | Field Shipping Address Address 2 | ☐ | Shipping Address Address Line 2 | | `field_shipping_address_address_3` | `varchar2` | Field Shipping Address Address 3 | ☐ | Shipping Address Address Line 3 | | `field_shipping_address_city` | `varchar2` | Field Shipping Address City | ☐ | Shipping Address City | | `field_shipping_address_company` | `varchar2` | Field Shipping Address Company | ☐ | Shipping Address Company | | `field_shipping_address_country` | `varchar2` | Field Shipping Address Country | ☐ | Shipping Address Country | | `field_shipping_address_email` | `varchar2` | Field Shipping Address Email | ☐ | Shipping Address Email | | `field_shipping_address_first_name` | `varchar2` | Field Shipping Address First Name | ☐ | Shipping Address First Name | | `field_shipping_address_last_name` | `varchar2` | Field Shipping Address Last Name | ☐ | Shipping Address Last Name | | `field_shipping_address_phone` | `varchar2` | Field Shipping Address Phone | ☐ | Shipping Address Phone | | `field_shipping_address_postal` | `varchar2` | Field Shipping Address Postal | ☐ | Shipping Address Postal | | `field_shipping_address_province` | `varchar2` | Field Shipping Address Province | ☐ | Shipping Address Province | | `final_amount_currency` | `varchar2` | Final Amount Currency | ☐ | Currency of the amount in column final_amount. | | `final_amount` | `decimal` | Final Amount | ☐ | Final Amount | | `id` | `varchar2` | ID | ☑ | Unique ID of the record, in the form of a GUID. | | `is_test_order` | `varchar2` | Is Test Order | ☐ | Is Test Order | | `legacy_connection_id` | `int64` | Legacy Connection ID | ☐ | Legacy Connection ID | | `location_id` | `varchar2` | Location ID | ☐ | Location ID | | `normalized_status` | `varchar2` | Normalized Status | ☐ | Order Status | | `notes` | `varchar2` | Notes | ☐ | Notes | | `order_number` | `varchar2` | Order Number | ☐ | Order Number | | `order_url` | `varchar2` | Order URL | ☐ | Order URL | | `payment_method` | `varchar2` | Payment Method | ☐ | Payment Method | | `primary_contact` | `varchar2` | Primary Contact | ☐ | Contact for Order | | `sales_channel` | `varchar2` | Sales Channel | ☐ | Channel | | `schemaId` | `varchar2` | Schema ID | ☐ | Unique ID of the custom object the record belongs to. | | `shipping_amount_currency` | `varchar2` | Shipping Amount Currency | ☐ | Currency of the amount in column shipping_amount. | | `shipping_amount` | `decimal` | Shipping Amount | ☐ | Shipping Amount | | `shipping_method` | `varchar2` | Shipping Method | ☐ | Shipping Method | | `store_created_date` | `datetime` | Store Created Date | ☐ | Store Created Date | | `store_customer_id` | `varchar2` | Store Customer ID | ☐ | Store's Customer ID | | `store_external_order_id` | `varchar2` | Store External Order ID | ☐ | Store's External Order ID | | `store_modified_date` | `datetime` | Store Modified Date | ☐ | Store Modified Date | | `store_order_id` | `varchar2` | Store Order ID | ☐ | Store's Order ID | | `store_status` | `varchar2` | Store Status | ☐ | Store's Order Status | | `updatedTimestamp` | `datetime` | Last Modified | ☐ | Moment of last change. |