# Orders

## Content



| 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 |