| id |
int(11)
|
|
|
|
| po_number |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| supplier_id |
int(11)
|
|
|
 浏览不相关的值
|
| warehouse_id |
int(11)
|
|
|
浏览不相关的值
|
| department_id |
int(11)
|
|
|
|
| order_date |
date
|
|
|
|
| expected_delivery |
date
|
|
|
|
| actual_delivery |
date
|
|
|
|
| total_amount |
decimal(14,2)
|
|
|
|
| status |
enum('draft', 'pending', 'approved', 'partially_received', 'received', 'cancelled')
|
utf8mb4_unicode_ci
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| tender_id |
int(11)
|
|
|
|
| invoice_id |
int(11)
|
|
|
|
| created_by |
int(11)
|
|
|
|
| approved_by |
int(11)
|
|
|
|
| approved_at |
timestamp
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
| budget_id |
int(11)
|
|
|
|
| journal_entry_id |
int(11)
|
|
|
|
| payment_entry_id |
int(11)
|
|
|
|
| item_type |
enum('asset', 'consumable', 'service', 'other')
|
utf8mb4_unicode_ci
|
|
|
| received_amount |
decimal(14,2)
|
|
|
|
| paid_amount |
decimal(14,2)
|
|
|
|
