| id |
int(11)
|
|
|
|
| order_name |
varchar(255)
|
latin1_swedish_ci
|
|
|
| agent_id |
int(11)
|
|
|
|
| order_number |
varchar(100)
|
latin1_swedish_ci
|
|
|
| order_date |
date
|
|
|
|
| status |
int(11)
|
|
|
|
| approve_status |
int(11)
|
|
|
|
| datecreated |
datetime
|
|
|
|
| delivery_date |
date
|
|
|
|
| subtotal |
decimal(15,2)
|
|
|
|
| total_tax |
decimal(15,2)
|
|
|
|
| total |
decimal(15,2)
|
|
|
|
| addedfrom |
int(11)
|
|
|
|
| vendornote |
text
|
latin1_swedish_ci
|
|
|
| terms |
text
|
latin1_swedish_ci
|
|
|
| discount_percent |
decimal(15,2)
|
|
|
|
| discount_total |
decimal(15,2)
|
|
|
|
| discount_type |
decimal(15,2)
|
|
|
|
| buyer |
int(11)
|
|
|
|
| number |
int(11)
|
|
|
|
| hash |
varchar(32)
|
latin1_swedish_ci
|
|
|
| delivery_status |
int(2)
|
|
|
|
| type |
varchar(30)
|
latin1_swedish_ci
|
|
|
| currency |
int(11)
|
|
|
|
| order_status |
varchar(30)
|
latin1_swedish_ci
|
|
|
| shipping_note |
text
|
latin1_swedish_ci
|
|
|
| currency_rate |
decimal(15,6)
|
|
|
|
| from_currency |
varchar(20)
|
latin1_swedish_ci
|
|
|
| to_currency |
varchar(20)
|
latin1_swedish_ci
|
|
|
| shipping_fee |
decimal(15,2)
|
|
|
|
| invoice_id |
int(11)
|
|
|
|
| stock_export_id |
int(11)
|
|
|
|
| status_goods |
int(11)
|
|
|
|
