| id |
int(11)
|
|
|
|
| request_no |
varchar(60)
|
utf8mb4_general_ci
|
|
|
| project_id |
int(11)
|
|
|
|
| applicant_id |
int(11)
|
|
|
|
| project_no |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| project_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| supplier_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| item_summary |
text
|
utf8mb4_general_ci
|
|
|
| amount |
decimal(14,2)
|
|
|
|
| currency |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| exchange_rate |
decimal(12,4)
|
|
|
|
| negotiated_amount |
decimal(14,2)
|
|
|
|
| delivery_date |
date
|
|
|
|
| payment_terms |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| remark |
text
|
utf8mb4_general_ci
|
|
|
| quote_file |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| required_date |
date
|
|
|
|
| negotiation_notes |
text
|
utf8mb4_general_ci
|
|
|
| status |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| manager_approver_id |
int(11)
|
|
|
|
| gm_approver_id |
int(11)
|
|
|
|
| gm_approved_at |
datetime
|
|
|
|
| gm_comment |
text
|
utf8mb4_general_ci
|
|
|
| admin_handler_id |
int(11)
|
|
|
|
| admin_negotiator_id |
int(11)
|
|
|
|
| purchase_order_no |
varchar(60)
|
utf8mb4_general_ci
|
|
|
| ordered_at |
datetime
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
