| id |
int(11)
|
|
|
|
| quote_no |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| customer_id |
int(11)
|
|
|
|
| quote_date |
date
|
|
|
|
| valid_until |
date
|
|
|
|
| currency |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| tax_rate |
decimal(10,2)
|
|
|
|
| discount_amount |
decimal(15,2)
|
|
|
|
| subtotal |
decimal(15,2)
|
|
|
|
| tax_amount |
decimal(15,2)
|
|
|
|
| total_amount |
decimal(15,2)
|
|
|
|
| status |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| note |
text
|
utf8mb4_general_ci
|
|
|
| terms |
text
|
utf8mb4_general_ci
|
|
|
| created_by |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
| project_id |
int(11)
|
|
|
|
| parent_quotation_id |
int(11)
|
|
|
|
| version_no |
int(11)
|
|
|
|
| is_latest |
tinyint(1)
|
|
|
|
| revision_reason |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| replaced_by_id |
int(11)
|
|
|
|
