✏️ Edit Record

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

invoice_no (varchar(100), not null)

invoice_date (date, not null)

supplier_company (varchar(150), not null)

supplier_address (text, nullable) SF.No: 188/B1A2, 188/B2A2, Devarayapuram Village, Mullupadi, NH83 Pollachi Road, Kinathukadavu Taluk, Coimbatore - 642110

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) {"invoice_no":"HM\/INV\/26-27\/46","invoice_date":"2026-09-14","supplier_company":"Hexon Manufactory","supplier_address":"SF.No: 188\/B1A2, 188\/B2A2, Devarayapuram Village, Mullupadi, NH83 Pollachi Road, Kinathukadavu Taluk, Coimbatore - 642110","supplier_contact":"+91-9895999312; hexonmanufactory@gmail.com","supplier_gst":"33AAQFH0748E1ZH","supplier_pan":"AAQFH0748E","dc_no":"","dc_date":"","work_order_no":"","work_order_date":"","transport_mode":"By Road","vehicle_no":"","buyer_company":"","buyer_address":"","delivery_at":"","buyer_gst":"","buyer_pan":"","packing_charges":"Nil","freight_charges":"Nil","total_basic_amount":71800,"total_taxable_value":71800,"cgst_amount":6462,"igst_amount":6462,"total_tax_value":12924,"round_off":0,"total_invoice_value":84724,"moulding_items":[{"series_type":"Recessed Chamber Series","sub_type":null,"hsn_code":"998920\/84219900","plate_size":"1200 x 1200","plate_code":"H1","weight_kg":38,"qty_nos":20,"total_weight_kg":760,"moulding_rate":30,"moulding_amount":22800,"row_total":22800},{"series_type":"Recessed Chamber Series","sub_type":null,"hsn_code":"998920\/84219900","plate_size":"1500 x 1500","plate_code":"M1","weight_kg":90,"qty_nos":10,"total_weight_kg":900,"moulding_rate":40,"moulding_amount":36000,"row_total":36000}],"machining_items":[{"series_type":"Recessed Chamber Series","sub_type":null,"hsn_code":"998920\/84219900","plate_size":"1200 x 1200","plate_code":"H1","qty_nos":20,"machining_rate":300,"machining_amount":6000,"row_total":6000},{"series_type":"CGR Plate Series","sub_type":null,"hsn_code":"998920\/84219900","plate_size":"1500 x 1500","plate_code":"N1-CGR","qty_nos":10,"machining_rate":700,"machining_amount":7000,"row_total":7000}]}

created_at (timestamp, not null)

updated_at (timestamp, not null)