# eComOrders: ActiveCampaign eCommerce Orders - Catalog: `ActiveCampaign` - Schema: `V3` - Primary Keys: `id` - Label: eCommerce Orders Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `eComOrders` 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 | Documentation | |---|:---:|---|:---:|---| | `connection` | `int64` | Connection | ☑ | | | `connectionid` | `int64` | Connection ID | ☑ | | | `createdDate` | `datetime` | Created | ☑ | | | `currency` | `varchar2` | Currency | ☑ | | | `customer` | `int64` | Customer | ☑ | | | `customerid` | `int64` | Customer ID | ☑ | | | `discountAmount` | `int64` | Discount Amount | ☐ | | | `email` | `varchar2` | Email Address | ☐ | | | `externalcheckoutid` | `varchar2` | | ☐ | | | `externalCreatedDate` | `datetime` | | ☑ | | | `externalid` | `varchar2` | External ID | ☐ | | | `id` | `int64` | ID | ☑ | | | `orderDate` | `datetime` | Order Date | ☑ | | | `orderProducts` | `int64` | Order Products | ☐ | | | `orderUrl` | `varchar2` | Order URL | ☐ | | | `shippingAmount` | `int64` | Shipping Amount | ☐ | | | `shippingMethod` | `int64` | Shipping Method | ☐ | | | `source` | `int64` | Source | ☑ | | | `state` | `int64` | State | ☑ | | | `taxAmount` | `int64` | Tax Amount | ☐ | | | `totalPrice` | `int64` | Total Price | ☑ | Total sales amount including VAT in smallest unit, typically cents. | | `totalProducts` | `int64` | Total Products | ☑ | | | `tstamp` | `datetime` | | ☑ | | | `updatedDate` | `datetime` | Last Updated | ☑ | |