CREATE TABLE gen_invoice (
`id` int(11),
`invoice_no` varchar(100),
`invoice_date` varchar(100),
`cust_1` varchar(500),
`cust_2` varchar(500),
`cust_3` varchar(500),
`cust_4` varchar(500)
);

INSERT INTO gen_invoice VALUES (N'3',N'35',N'2024-04-22',N'',N'',N'',N'');
INSERT INTO gen_invoice VALUES (N'4',N'36542',N'2025-08-25',N'',N'',N'',N'');
INSERT INTO gen_invoice VALUES (N'5',N'36543',N'2025-10-04',N'LADOIYA E MITRA',N'CHAK 4 MZW WARD NO 01',N'HANUMANGARH',N'9772100000');
INSERT INTO gen_invoice VALUES (N'6',N'36544',N'2025-11-01',N'LADOIYA E MITRA',N'CHAK 4 MZW WARD NO 01',N'HANUMANGARH',N'9772100000');
INSERT INTO gen_invoice VALUES (N'7',N'36544',N'2025-11-01',N'LADOIYA E MITRA',N'CHAK 4 MZW WARD NO 01',N'HANUMANGARH',N'9772100000');
