| id |
int(11)
|
|
|
|
| id_contact |
int(11)
|
|
|
|
| name |
varchar(120)
|
utf8mb4_general_ci
|
|
|
| address |
varchar(250)
|
utf8mb4_general_ci
|
|
|
| phone_number |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| voucher |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| status |
int(11)
|
|
|
|
| complete |
int(11)
|
|
|
|
| datecreator |
datetime
|
|
|
|
| order_number |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| channel_id |
int(11)
|
|
|
|
| channel |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| first_name |
varchar(60)
|
utf8mb4_general_ci
|
|
|
| last_name |
varchar(60)
|
utf8mb4_general_ci
|
|
|
| email |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| company |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| phonenumber |
varchar(15)
|
utf8mb4_general_ci
|
|
|
| city |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| state |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| country |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| zip |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| billing_street |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| billing_city |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| billing_state |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| billing_country |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| billing_zip |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| shipping_street |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| shipping_city |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| shipping_state |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| shipping_country |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| shipping_zip |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| userid |
int(11)
|
|
|
|
| notes |
text
|
utf8mb4_general_ci
|
|
|
| reason |
varchar(250)
|
utf8mb4_general_ci
|
|
|
| admin_action |
int(11)
|
|
|
|
| discount |
varchar(250)
|
utf8mb4_general_ci
|
|
|
| discount_type |
int(11)
|
|
|
|
| total |
varchar(250)
|
utf8mb4_general_ci
|
|
|
| sub_total |
varchar(250)
|
utf8mb4_general_ci
|
|
|
| discount_total |
varchar(250)
|
utf8mb4_general_ci
|
|
|
| invoice |
varchar(250)
|
utf8mb4_general_ci
|
|
|
| number_invoice |
varchar(250)
|
utf8mb4_general_ci
|
|
|
| stock_export_number |
varchar(250)
|
utf8mb4_general_ci
|
|
|
| create_invoice |
varchar(5)
|
utf8mb4_general_ci
|
|
|
| stock_export |
varchar(5)
|
utf8mb4_general_ci
|
|
|
| customers_pay |
decimal(15,2)
|
|
|
|
| amount_returned |
decimal(15,2)
|
|
|
|
| tax |
decimal(15,2)
|
|
|
|
| seller |
int(11)
|
|
|
|
| staff_note |
text
|
utf8mb4_general_ci
|
|
|
| payment_note |
text
|
utf8mb4_general_ci
|
|
|
| allowed_payment_modes |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| warehouse_id |
int(11)
|
|
|
|
| shipping |
decimal(15,2)
|
|
|
|
| payment_method_title |
varchar(250)
|
utf8mb4_general_ci
|
|
|
| discount_type_str |
text
|
utf8mb4_general_ci
|
|
|
| discount_percent |
decimal(15,2)
|
|
|
|
| adjustment |
decimal(15,2)
|
|
|
|
| currency |
int(11)
|
|
|
|
| terms |
text
|
utf8mb4_general_ci
|
|
|
| shipping_tax |
decimal(15,2)
|
|
|
|
| enable |
int(11)
|
|
|
|
| duedate |
date
|
|
|
|
| shipping_tax_json |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| discount_voucher |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| original_order_id |
int(11)
|
|
|
|
| return_reason |
longtext
|
utf8mb4_general_ci
|
|
|
| approve_status |
int(11)
|
|
|
|
| process_invoice |
varchar(5)
|
utf8mb4_general_ci
|
|
|
| stock_import_number |
int(11)
|
|
|
|
| fee_for_return_order |
decimal(15,2)
|
|
|
|
| hash |
varchar(32)
|
utf8mb4_general_ci
|
|
|
| estimate_id |
int(11)
|
|
|
|
| add_discount |
decimal(15,2)
|
|
|
|
