| id |
bigint(20)
|
|
|
|
| quotation_number |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| customer_id |
bigint(20)
|
|
|
|
| status |
enum('draft', 'sent', 'approved', 'rejected', 'converted_to_sale')
|
utf8mb4_unicode_ci
|
|
|
| quotation_date |
date
|
|
|
|
| expiry_date |
date
|
|
|
|
| warehouse_id |
bigint(20)
|
|
|
|
| vat_enabled |
tinyint(1)
|
|
|
|
| vat_rate |
decimal(5,2)
|
|
|
|
| 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
|
|
|
| converted_sales_invoice_id |
bigint(20)
|
|
|
|
| created_by |
bigint(20)
|
|
|
|
| approved_by |
bigint(20)
|
|
|
|
| approved_at |
timestamp
|
|
|
|
| sent_at |
timestamp
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
