Orders | DataConnector | ComponentOne

Orders

In This Topic

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