id - bigint unsigned
company_id - bigint unsigned
unit_id - bigint unsigned
product_id - bigint unsigned
client_id - bigint unsigned
client_site_id - bigint unsigned
user_id - bigint unsigned
order_number - varchar(255)
date - date
address - varchar(255)
address_name - varchar(255)
status - varchar(255)
approval_status - enum('pending','approved','rejected')
approved_quantity - decimal(10,2)
approved_by - bigint unsigned
approved_at - timestamp
rejection_reason - text
admin_notes - text
product_qty - int
product_qty_ton - int
total - decimal(10,8)
is_recurring - tinyint(1)
recurring_interval - varchar(255)
in_accounting - tinyint(1)
price - decimal(8,2)
persons - json
for_project - tinyint(1)
for_diesel - tinyint(1)
created_date - date
unit_amount - decimal(8,1)
created_at - timestamp
updated_at - timestamp
exchange_rate - decimal(15,4)
currency_code - varchar(3)
code - varchar(255)
contact_id - bigint unsigned