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 |
string |
Currency |
☑ |
|
customer |
int64 |
Customer |
☑ |
|
customerid |
int64 |
Customer ID |
☑ |
|
discountAmount |
int64 |
Discount Amount |
☐ |
|
string |
Email Address |
☐ |
|
|
externalcheckoutid |
string |
|
☐ |
|
externalCreatedDate |
datetime |
|
☑ |
|
externalid |
string |
External ID |
☐ |
|
id |
int64 |
ID |
☑ |
|
orderDate |
datetime |
Order Date |
☑ |
|
orderProducts |
int64 |
Order Products |
☐ |
|
orderUrl |
string |
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 |
☑ |
|
22-12-2022 20:43 Version 22.1.101-BETA+3681