| order_id |
Order unique identifier
|
bigint
|
|
|
| order_no |
Order number
|
string
|
|
|
| status |
Order status (By event order)
-- STATUS LIST
ORDER = On order
PICKING = In progress... Picking has started
SHIPPING = Shipping in progress.
COMPLETED = Completed
CANCELLED = Order cancelled or deleted
|
string
|
|
|
| order_date |
Order date
|
date
|
|
|
| po_no |
PO number
|
string
|
|
|
| sub_total |
Total before taxes
|
decimal number
|
|
|
| taxcode_1 |
Tax #1 code
|
string
|
|
|
| tax_amount_1 |
Tax #1 amount
|
decimal number
|
|
|
| taxcode_2 |
Tax #2 code
|
string
|
|
|
| tax_amount_2 |
Tax #2 amount
|
decimal number
|
|
|
| taxcode_3 |
Tax #3 code
|
string
|
|
|
| tax_amount_3 |
Tax #3 amount
|
decimal number
|
|
|
| total |
Order total
|
decimal number
|
|
|
| status_fr |
Order status (French)
|
string
|
|
|
| status_en |
Order status (English)
|
string
|
|
|
| status_code |
Order status
|
integer
|
|
|
| tracking_no |
Tracking number
|
string
|
|
|
| entr_code |
Warehouse number
|
string
|
|
|
| weborderid |
Your order unique identifier
|
string
|
|
|
| crmobjet_id |
Link CRM object unique identifier
|
bigint
|
|
8.01.0004
|
| codedoc |
Document code
|
string
|
|
8.01.0004
|
| delivery_no |
Packing slip number
|
string
|
|
8.02.0003
|
| invoice_no |
Invoice number
|
string
|
|
8.02.0003
|
| invoice_id |
Invoice unique identifier
|
bigint
|
|
8.02.0003
|
| project_title |
Project title
|
string
|
|
|
| cust_id |
Customer unique identifier
|
bigint
|
|
|
| prospect_id |
Prospect unique identifier
|
bigint
|
|
|
| bill_cust_id |
Invoiced customer unique identifier
|
bigint
|
|
|
| magentoStatus |
Magento status
|
string
|
|
8.02.0016
|
| divisionId |
Division identifier
|
bigint
|
|
8.03.0000
|
| invoiceDownloadURL |
Invoice downloading URL
|
string
|
|
|