JDBC Driver for Mailchimp

Build 22.0.8462

EcommerceOrders

A list of an account's ecommerce orders.

Columns

Name Type ReadOnly Description
StoreId [KEY] String True

The StoreId for the table.

Id [KEY] String True

A unique identifier for the order.

Customer String False

Information about a specific customer. Orders for existing customers should include only the id parameter in the customer object body.

CampaignId [KEY] String False

A string that uniquely identifies the campaign associated with an order.

FinancialStatus String False

The order status. For example: `refunded`, `processing`, `cancelled`, etc.

FulfillmentStatus String False

The fulfillment status for the order. For example: `partial`, `fulfilled`, etc.

CurrencyCode String False

The three-letter ISO 4217 code for the currency that the store accepts.

OrderTotal Decimal False

The order total for the order.

TaxTotal Decimal False

The tax total for the order.

ShippingTotal Decimal False

The shipping total for the order.

TrackingCode String False

The MailChimp tracking code for the order. Uses the 'mc_tc' parameter in eCommerce360-enabled tracking urls.

ProcessedAtForeign Datetime False

The date and time the order was processed.

CancelledAtForeign Datetime False

The date and time the order was cancelled.

UpdatedAtForeign Datetime False

The date and time the order was updated.

ShippingAddress_Name String False

The name associated with an order's shipping address.

ShippingAddress_Address1 String False

The shipping address for the order.

ShippingAddress_Address2 String False

An additional field for the shipping address.

ShippingAddress_City String False

The city in the order's shipping address.

ShippingAddress_Province String False

The state or normalized province in the order's shipping address.

ShippingAddress_ProvinceCode String False

The two-letter code for the province or state the order's shipping address is located in.

ShippingAddress_PostalCode String False

The postal or zip code in the order's shipping address.

ShippingAddress_Country String False

The country in the order's shipping address.

ShippingAddress_CountryCode String False

The two-letter code for the country in the shipping address.

ShippingAddress_Longitude Double False

The longitude for the shipping address location.

ShippingAddress_Latitude Double False

The latitude for the shipping address location.

ShippingAddress_Phone String False

The phone number for the order's shipping address

ShippingAddress_Company String False

The company associated with an order's shipping address.

BillingAddress_Name String False

The name associated with an order's billing address.

BillingAddress_Address1 String False

The billing address for the order.

BillingAddress_Address2 String False

An additional field for the billing address.

BillingAddress_City String False

The city in the billing address.

BillingAddress_Province String False

The state or normalized province in the billing address.

BillingAddress_ProvinceCode String False

The two-letter code for the province or state in the billing address.

BillingAddress_PostalCode String False

The postal or zip code in the billing address.

BillingAddress_Country String False

The country in the billing address.

BillingAddress_CountryCode String False

The two-letter code for the country in the billing address.

BillingAddress_Longitude Double False

The longitude for the billing address location.

BillingAddress_Latitude Double False

The latitude for the billing address location.

BillingAddress_Phone String False

The phone number for the billing address.

BillingAddress_Company String False

The company associated with the billing address.

Lines String False

An array of the order's line items.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462