| id |
int(11)
|
|
|
|
| pur_order_name |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| vendor |
int(11)
|
|
|
|
| estimate |
int(11)
|
|
|
|
| pur_order_number |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| order_date |
date
|
|
|
|
| status |
int(32)
|
|
|
|
| approve_status |
int(32)
|
|
|
|
| datecreated |
datetime
|
|
|
|
| days_owed |
int(11)
|
|
|
|
| delivery_date |
date
|
|
|
|
| subtotal |
decimal(15,2)
|
|
|
|
| total_tax |
decimal(15,2)
|
|
|
|
| total |
decimal(15,2)
|
|
|
|
| addedfrom |
int(11)
|
|
|
|
| vendornote |
text
|
utf8mb4_general_ci
|
|
|
| terms |
text
|
utf8mb4_general_ci
|
|
|
| discount_percent |
decimal(15,2)
|
|
|
|
| discount_total |
decimal(15,2)
|
|
|
|
| discount_type |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| buyer |
int(11)
|
|
|
|
| status_goods |
int(11)
|
|
|
|
| number |
int(11)
|
|
|
|
| expense_convert |
int(11)
|
|
|
|
| hash |
varchar(32)
|
utf8mb4_general_ci
|
|
|
| clients |
text
|
utf8mb4_general_ci
|
|
|
| delivery_status |
int(2)
|
|
|
|
| type |
text
|
utf8mb4_general_ci
|
|
|
| project |
int(11)
|
|
|
|
| pur_request |
int(11)
|
|
|
|
| department |
int(11)
|
|
|
|
| tax_order_rate |
decimal(15,2)
|
|
|
|
| tax_order_amount |
decimal(15,2)
|
|
|
|
| sale_invoice |
int(11)
|
|
|
|
| currency |
int(11)
|
|
|
|
| order_status |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| shipping_note |
text
|
utf8mb4_general_ci
|
|
|
| currency_rate |
decimal(15,6)
|
|
|
|
| from_currency |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| to_currency |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| shipping_fee |
decimal(15,2)
|
|
|
|