DataConnector
Orders
ColumnName DataType Description
Adjustment_negative String Negative Adjustment Value.
Adjustment_positive String Positive Adjustment Value.
Applied_rule_ids String Applied Rule IDs.
Base_adjustment_negative String Base Negative Adjustment Value.
Base_adjustment_positive String Base Positive Adjustment Value.
Base_currency_code String Base Currency Code.
Base_discount_amount String Base Discount Amount.
Base_discount_canceled String Base Discount Canceled.
Base_discount_invoiced String Base Discount Invoiced.
Base_discount_refunded String Base Discount Refunded.
Base_grand_total String Base Grand Total.
Base_discount_tax_compensation_amount String Base Discount Tax Compensation Amount.
Base_discount_tax_compensation_invoiced String Base Discount Tax Compensation Invoiced.
Base_discount_tax_compensation_refunded String Base Discount Tax Compensation Refunded.
Base_shipping_amount String Base Shipping Amount.
Base_shipping_canceled String Base Shipping Canceled.
Base_shipping_discount_amount String Base Shipping Discount Amount.
Base_shipping_discount_tax_compensation_amnt String Base Shipping Discount Tax Compensation Amount.
Base_shipping_incl_tax String Base Shipping Including Tax.
Base_shipping_invoiced String Base Shipping Invoiced.
Base_shipping_refunded String Base Shipping Refunded.
Base_shipping_tax_amount String Base Shipping Tax Amount.
Base_shipping_tax_refunded String Base Shipping Tax Refunded.
Base_subtotal String Base Subtotal.
Base_subtotal_canceled String Base Subtotal Canceled.
Base_subtotal_incl_tax String Base Subtotal Including Tax.
Base_subtotal_invoiced String Base Subtotal Invoiced.
Base_subtotal_refunded String Base Subtotal Refunded.
Base_tax_amount String Base Tax Amount.
Base_tax_canceled String Base Tax Canceled.
Base_tax_invoiced String Base Tax Invoiced.
Base_tax_refunded String Base Tax Refunded.
Base_total_canceled String Base Total Canceled.
Base_total_due String Base Total Due.
Base_total_invoiced String Base Total Invoiced.
Base_total_invoiced_cost String Base Total Invoiced Cost.
Base_total_offline_refunded String Base Total Offline Refunded.
Base_total_online_refunded String Base Total Online Refunded.
Base_total_paid String Base Total Paid.
Base_total_qty_ordered String Base Total Quantity Ordered.
Base_total_refunded String Base Total Refunded.
Base_to_global_rate String Base-To-Global Rate.
Base_to_order_rate String Base-To-Order Rate.
Billing_address_id Int Billing Address ID.
Can_ship_partially Int Can-Ship-Partially Flag Value.
Can_ship_partially_item Int Can-Ship-Partially-Item Flag Value.
Coupon_code String Coupon Code.
Created_at String Created-At Timestamp.
Customer_dob String Customer Date-Of-Birth (DOB).
Customer_email String Customer Email Address.
Customer_firstname String Customer First Name.
Customer_gender Int Customer Gender.
Customer_group_id Int Customer Group ID.
Customer_id Int Customer ID.
Customer_is_guest Int Customer-Is-Guest Flag Value.
Customer_lastname String Customer Last Name.
Customer_middlename String Customer Middle Name.
Customer_note_notify Int Customer-Note-Notify Flag Value.
Customer_note String Customer Note.
Customer_prefix String Customer Prefix.
Customer_suffix String Customer Suffix.
Customer_taxvat String Customer Value-Added Tax (VAT).
Discount_amount String Discount Amount.
Discount_canceled String Discount Canceled.
Discount_description String Discount Description.
Discount_invoiced String Discount Invoiced.
Discount_refunded String Discount Refunded Amount.
Edit_increment Int Edit Increment Value.
Email_sent Int Email-Sent Flag Value.
Entity_id Int Order ID.
Ext_customer_id String External Customer ID.
Ext_order_id String External Order ID.
Forced_shipment_with_invoice Int Forced-Shipment-With-Invoice Flag Value.
Global_currency_code String Global Currency Code.
Grand_total String Grand Total.
Discount_tax_compensation_amount String Discount Tax Compensation Amount.
Discount_tax_compensation_invoiced String Discount Tax Compensation Invoiced Amount.
Discount_tax_compensation_refunded String Discount Tax Compensation Refunded Amount.
Hold_before_state String Hold Before State.
Hold_before_status String Hold Before Status.
Increment_id String Increment ID.
Is_virtual Int Is-Virtual Flag Value.
Order_currency_code String Order Currency Code.
Original_increment_id String Original Increment ID.
Payment_authorization_amount String Payment Authorization Amount.
Payment_auth_expiration Int Payment Authorization Expiration Date.
Protect_code String Protect Code.
Quote_address_id Int Quote Address ID.
Quote_id Int Quote ID.
Relation_child_id String Relation Child ID.
Remote_ip String Remote IP Address.
Shipping_amount String Shipping Amount.
Shipping_canceled String Shipping Canceled Amount.
Shipping_discount_amount String Shipping Discount Amount.
Shipping_discount_tax_compensation_amount String Shipping Discount Tax Compensation Amount.
Shipping_incl_tax String Shipping Including Tax Amount.
Shipping_invoiced String Shipping Invoiced Amount.
Shipping_refunded String Shipping Refunded Amount.
Shipping_tax_amount String Shipping Tax Amount.
Shipping_tax_refunded String Shipping Tax Refunded Amount.
State String State.
Status String Status.
Store_currency_code String Store Currency Code.
Store_id Int Store ID.
Store_name String Store Name.
Store_to_base_rate String Store-To-Base Rate.
Store_to_order_rate String Store-To-Order Rate.
Subtotal String Subtotal.
Subtotal_canceled String Subtotal Including Tax Amount.
Subtotal_invoiced String Subtotal Invoiced Amount.
Subtotal_refunded String Subtotal Refunded Amount.
Tax_amount String Tax Amount
Tax_canceled String Tax Canceled Amount.
Tax_invoiced String Tax Invoiced Amount.
Tax_refunded String Tax Refunded Amount.
Total_canceled String Total Canceled.
Total_due String Total Due.
Total_invoiced String Total Invoiced.
Total_item_count Int Total Item Count.
Total_offline_refunded String Total Ofline Refunded Amount.
Total_online_refunded String Total Online Refunded Amount.
Total_paid String Total Paid.
Total_qty_ordered String Total Quantity Ordered.
Total_refunded String Total Refunded.
Updated_at String Updated-At Timestamp.
Weight String Weight.
X_forwarded_for String X-Forwarded-For Field Value.
Items String This Is An Auto-Generated Column.
Billing_address String This Is An Auto-Generated Column.
Payment String This Is An Auto-Generated Column.
Status_histories String This Is An Auto-Generated Column.
Extension_attributes String This Is An Auto-Generated Column.