➕ Add New Record

id (int(11) , not null , Primary Key , Auto-Increment)

invoice_no * (varchar(100) , not null )

invoice_date * (date , not null )

supplier_company * (varchar(150) , not null )

supplier_address (text , nullable )

supplier_contact (varchar(150) , nullable )

supplier_gst (varchar(50) , nullable )

supplier_pan (varchar(50) , nullable )

dc_no (varchar(50) , nullable )

dc_date (date , nullable )

work_order_no (varchar(50) , nullable )

work_order_date (date , nullable )

transport_mode (varchar(50) , nullable )

vehicle_no (varchar(50) , nullable )

buyer_company * (varchar(150) , not null )

buyer_address (text , nullable )

delivery_at (varchar(255) , nullable )

buyer_gst (varchar(50) , nullable )

buyer_pan (varchar(50) , nullable )

total_basic_amount * (decimal(12,2) , not null )

packing_charges (varchar(50) , nullable )

freight_charges (varchar(50) , nullable )

total_taxable_value * (decimal(12,2) , not null )

cgst_amount * (decimal(12,2) , not null )

igst_amount * (decimal(12,2) , not null )

total_tax_value * (decimal(12,2) , not null )

round_off * (decimal(8,2) , not null )

total_invoice_value * (decimal(12,2) , not null )

invoice_data_json (longtext , nullable )

created_at * (timestamp , not null )

updated_at * (timestamp , not null )