| id |
int(11)
|
|
|
|
| agent_id |
int(11)
|
|
|
|
| rel_type |
int(11)
|
|
|
|
| rel_document |
int(11)
|
|
|
|
| customer_code |
text
|
utf8mb4_general_ci
|
|
|
| customer_name |
text
|
utf8mb4_general_ci
|
|
|
| to_ |
text
|
utf8mb4_general_ci
|
|
|
| address |
text
|
utf8mb4_general_ci
|
|
|
| description |
text
|
utf8mb4_general_ci
|
|
|
| staff_id |
int(11)
|
|
|
|
| date_c |
date
|
|
|
|
| date_add |
date
|
|
|
|
| goods_delivery_code |
text
|
utf8mb4_general_ci
|
|
|
| warehouse_id |
int(11)
|
|
|
|
| total_money |
text
|
utf8mb4_general_ci
|
|
|
| approval |
int(11)
|
|
|
|
| addedfrom |
int(11)
|
|
|
|
| total_discount |
text
|
utf8mb4_general_ci
|
|
|
| after_discount |
text
|
utf8mb4_general_ci
|
|
|
| invoice_id |
text
|
utf8mb4_general_ci
|
|
|
| type |
text
|
utf8mb4_general_ci
|
|
|
| invoice_no |
text
|
utf8mb4_general_ci
|
|
|
| pr_order_id |
int(11)
|
|
|
|
| type_of_delivery |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| additional_discount |
decimal(15,2)
|
|
|
|
| sub_total |
decimal(15,2)
|
|
|
|
| delivery_status |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| shipping_fee |
decimal(15,2)
|
|
|
|
