| id |
int(11)
|
|
|
|
| bill_no |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| quotation_reference_no |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| company_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| customer_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| customer_address |
text
|
utf8mb4_general_ci
|
|
|
| customer_phone |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| delivery_date |
date
|
|
|
|
| delivery_type |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| date_time |
int(11)
|
|
|
|
| gross_amount |
decimal(12,2)
|
|
|
|
| service_charge_rate |
decimal(5,2)
|
|
|
|
| service_charge |
decimal(12,2)
|
|
|
|
| vat_charge_rate |
decimal(5,2)
|
|
|
|
| vat_charge |
decimal(12,2)
|
|
|
|
| tax_inclusive |
decimal(12,2)
|
|
|
|
| tax_exclusive |
decimal(12,2)
|
|
|
|
| net_amount |
decimal(12,2)
|
|
|
|
| deliveryfee |
decimal(12,2)
|
|
|
|
| discount |
decimal(12,2)
|
|
|
|
| paid_status |
int(11)
|
|
|
|
| return_note |
text
|
utf8mb4_general_ci
|
|
|
| payment_proof |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| modeofpayment |
int(11)
|
|
|
|
| record_type |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| approval_status |
tinyint(1)
|
|
|
|
| approved_at |
int(11)
|
|
|
|
| approved_by |
int(11)
|
|
|
|
| source_quotation_id |
int(11)
|
|
|
|
| sales_status |
varchar(60)
|
utf8mb4_general_ci
|
|
|
| quotation_pdf_path |
varchar(500)
|
utf8mb4_general_ci
|
|
|
| quotation_pdf_filename |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| quotation_pdf_generated_at |
datetime
|
|
|
|
| approval_document_id |
int(10)
|
|
|
|
| approval_control_no |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| approval_submitted_at |
datetime
|
|
|
|
| signed_pdf_path |
varchar(500)
|
utf8mb4_general_ci
|
|
|
| last_approval_remarks |
text
|
utf8mb4_general_ci
|
|
|
| sent_to_client_at |
datetime
|
|
|
|
| client_confirmed_at |
datetime
|
|
|
|
| converted_order_id |
int(11)
|
|
|
|
| converted_at |
datetime
|
|
|
|
| quotation_valid_until |
date
|
|
|
|
| port_of_entry |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| origin_country |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| shipment_type |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| customs_entry_type |
varchar(60)
|
utf8mb4_general_ci
|
|
|
| container_quantity |
int(11)
|
|
|
|
| container_size |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| commodity_description |
text
|
utf8mb4_general_ci
|
|
|
| cargo_unit_count |
decimal(12,2)
|
|
|
|
| gross_weight |
decimal(14,3)
|
|
|
|
| weight_unit |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| delivery_scope |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| currency_code |
char(3)
|
utf8mb4_general_ci
|
|
|
| internal_cost_total |
decimal(14,2)
|
|
|
|
| markup_amount |
decimal(14,2)
|
|
|
|
| quotation_inclusions |
text
|
utf8mb4_general_ci
|
|
|
| quotation_exclusions |
text
|
utf8mb4_general_ci
|
|
|
| quotation_assumptions |
text
|
utf8mb4_general_ci
|
|
|
| price_advisory |
text
|
utf8mb4_general_ci
|
|
|
| client_terms |
text
|
utf8mb4_general_ci
|
|
|
| cargo_attachment_path |
varchar(500)
|
utf8mb4_general_ci
|
|
|
| cargo_attachment_filename |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| transaction_value |
decimal(14,2)
|
|
|
|
| freight_value |
decimal(14,2)
|
|
|
|
| insurance_value |
decimal(14,2)
|
|
|
|
| customs_exchange_rate |
decimal(14,6)
|
|
|
|
| dutiable_value |
decimal(14,2)
|
|
|
|
| customs_duty_rate |
decimal(8,4)
|
|
|
|
| customs_duty_amount |
decimal(14,2)
|
|
|
|
| customs_vat_rate |
decimal(8,4)
|
|
|
|
| customs_vat_amount |
decimal(14,2)
|
|
|
|
| excise_tax_amount |
decimal(14,2)
|
|
|
|
| other_customs_charges |
decimal(14,2)
|
|
|
|
| customs_tax_total |
decimal(14,2)
|
|
|
|
| user_id |
int(11)
|
|
|
|
| created_at |
datetime
|
|
|
|
