| id |
bigint(20)
|
|
|
|
| order_number |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| po_number |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| supplier_id |
bigint(20)
|
|
|
 استعرض القيم الغريبة
|
| status |
enum('draft', 'sent', 'partially_received', 'received', 'cancelled')
|
utf8mb4_unicode_ci
|
|
|
| warehouse_id |
bigint(20)
|
|
|
|
| order_date |
date
|
|
|
|
| expected_date |
date
|
|
|
|
| subtotal |
decimal(15,2)
|
|
|
|
| discount_amount |
decimal(15,2)
|
|
|
|
| tax_amount |
decimal(15,2)
|
|
|
|
| total_amount |
decimal(15,2)
|
|
|
|
| currency |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| template_code |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| created_by |
bigint(20)
|
|
|
|
| approved_by |
bigint(20)
|
|
|
|
| approved_at |
timestamp
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
