INSERT INTO `account_selection` (`_id`, `selection`) VALUES (1,'Dine');
INSERT INTO `alaramdays` (`_id`, `selecteddays`, `unselecteddays`, `swap`) VALUES (1,'Monday','0','0'),(2,'Tuesday','0','0'),(3,'Wednesday','0','0'),(4,'Thursday','0','0'),(5,'Friday','0','0'),(6,'Saturday','0','0'),(7,'Sunday','0','0');
INSERT INTO `alaramon_off` (`_id`, `status`) VALUES (1,'On');
INSERT INTO `alaramtime` (`_id`, `time`) VALUES (1,'11:30 PM');
INSERT INTO `asd1` (`_id`, `pName`, `pDate`, `image`, `floor`, `position`, `max`, `present`) VALUES (1,'tab 1','1',NULL,'first','0','4',NULL),(2,'tab 2','2',NULL,'first','0','4',NULL),(3,'','3',NULL,'first','0','4',NULL);
INSERT INTO `auto_connect` (`_id`, `auto_connect_status`) VALUES (1,'No');
INSERT INTO `auto_generate_barcode` (`_id`, `generate`) VALUES (1,'On');
INSERT INTO `billingmode` (`_id`, `billingtype`) VALUES (1,'Fine dine');
INSERT INTO `billingtype` (`_id`, `billingtype_type`) VALUES (1,'Dine-in');
INSERT INTO `btconn` (`_id`, `name`, `address`, `status`, `device`) VALUES (1,'','','',NULL);
INSERT INTO `change_time_format` (`_id`, `status`) VALUES (1,'changed');
INSERT INTO `companydetailss` (`_id`, `companyname`, `doorno`, `substreet`, `street`, `city`, `state`, `country`, `pincode`, `phoneno`, `taxone`, `taxtwo`, `footerone`, `footertwo`, `address1`, `email`, `website`, `address2`, `address3`) VALUES (5,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,'',NULL,'','','','','');
INSERT INTO `country_selection` (`_id`, `country`) VALUES (1,'Rupee');
INSERT INTO `default_credit` (`_id`, `status`) VALUES (1,'off');
INSERT INTO `deletedb_time` (`_id`, `time`) VALUES (1,'11:30 PM');
INSERT INTO `deletedbon_off` (`_id`, `status`) VALUES (1,'off');
INSERT INTO `discount_details` (`_id`, `disc_code`, `disc_value`, `disc_type`) VALUES (1,'Dis50','50','%');
INSERT INTO `estimate_print` (`_id`, `status`) VALUES (1,'Yes');
INSERT INTO `freetrail` (`_id`, `status`) VALUES (1,'Activated');
INSERT INTO `home_check` (`_id`, `login_status`) VALUES (1,'1');
INSERT INTO `hotel` (`_id`, `name`, `direccion`, `telefono`, `email`, `value`) VALUES (1,'All',NULL,NULL,NULL,NULL),(2,'Favourites',NULL,NULL,NULL,NULL),(3,'Tiffin',NULL,NULL,NULL,NULL),(4,'Snacks',NULL,NULL,NULL,NULL),(5,'Main course',NULL,NULL,NULL,NULL),(6,'Drinks',NULL,NULL,NULL,NULL),(7,'Desserts',NULL,NULL,NULL,NULL);
INSERT INTO `ingredient_items_list` (`_id`, `ingredient_name`, `itemname`, `item_qyt_used`, `currnet_stock`, `date1`, `date`, `time1`, `time`, `modified_datetimee_new`, `qty_unit`, `required`) VALUES (1,'Motor','idly','3','-403.00','30 Nov 2022','202211301946','07:46:55 p.m.','1946','202211301946','no.','5.0'),(2,'Motor','dosa','2','65.0','30 Nov 2022','202211301946','07:46:55 p.m.','1946','202211301946','no.','5.0'),(7,'Sugar ','tea','0.500','50.0','18 Jul 2023','202307181355','01:55:43 pm','1355','202307181355','Kg','20.0'),(8,'Sugar ','masala chai','0.500','50.0','18 Jul 2023','202307181355','01:55:43 pm','1355','202307181355','Kg','20.0'),(11,'Sugar ','tea','0.15','50.0','02 Aug 2023','202308021600','04:00:22 pm','1600','202310031806','Kg','40.0'),(16,'Sugar ','coffee','0.50','40.0','29 Sep 2023','202309292139','09:39:56 pm','2139','202309292139','Kg','40.0'),(17,'Sugar ','tea','0.70','40.0','29 Sep 2023','202309292139','09:39:56 pm','2139','202309292139','Kg','40.0'),(18,'Sugar ','coffee','0.10','50.0','03 Oct 2023','202310031806','06:06:17 pm','1806','202310031806','Kg','40.0'),(19,'Sugar ','masala chai','0.20','50.0','03 Oct 2023','202310031806','06:06:17 pm','1806','202310031806','Kg','40.0'),(20,'Sugar ','tea','0.10','50.0','08 Oct 2023','202310081702','05:02:34 pm','1702','202310081702','Kg','4.0'),(21,'Sugar ','coffee','0.20','50.0','08 Oct 2023','202310081702','05:02:34 pm','1702','202310081702','Kg','4.0');
INSERT INTO `ingredient_sold_details` (`_id`, `vendor_name`, `vendor_phoneno`, `invoice`, `billamount`, `tax_percent`, `tax_amount`, `disc_percent`, `disc_amount`, `total_bill_amount`, `from_time`, `from_date`, `due_date`, `datetimee_new_from`, `datetimee_new_due`, `pay`, `pending`, `total_pay`, `pay_date`, `pay_time`, `pay_datetimeemew`, `not_required`) VALUES (1,'Ajmal','1234567890','','1000.0','0','0','0','0','1000.0','07:49 p.m.','30 Nov 2022','30 Nov 2022','202211301949','20221130','1000','0.0','1000','30 Nov 2022','07:49 p.m.','202211301949',''),(2,'Ajmal','1234567890','','800.0','0','0','0','0','800.0','05:37 pm','28 Jun 2023','28 Jun 2023','202306281737','20230628','800','0.0','800','28 Jun 2023','05:37 pm','202306281737',''),(3,'Ajmal','1234567890','','1600.0','0','0','0','0','1600.0','12:41 pm','07 Jul 2023','07 Jul 2023','202307071241','20230707','1600','0.0','1600','07 Jul 2023','12:41 pm','202307071241',''),(4,'Ajmal','1234567890','','1050.0','0','0','0','0','1050.0','04:01 pm','02 Aug 2023','02 Aug 2023','202308021601','20230802','0','1050.0','0','02 Aug 2023','04:01 pm','202308021601',''),(5,'Ajmal','1234567890','','1050.0','0','0','0','0','1050.0','04:01 pm','02 Aug 2023','02 Aug 2023','202308021601','20230802','1050','0.0','1050.0','02 Aug 2023','04:02 pm','202308021602',''),(6,'Ajmal','1234567890','','700.0','0','0','0','0','700.0','07:05 pm','10 Aug 2023','10 Aug 2023','202308101905','20230810','700','0.0','700','10 Aug 2023','07:05 pm','202308101905',''),(7,'Ajmal','1234567890','','2250.0','0','0','0','0','2250.0','01:11 pm','16 Sep 2023','16 Sep 2023','202309161311','20230916','2250','0.0','2250','16 Sep 2023','01:11 pm','202309161311',''),(8,'Ajmal','1234567890','','2000.0','0','0','0','0','2000.0','09:40 pm','29 Sep 2023','29 Sep 2023','202309292140','20230929','2000','0.0','2000','29 Sep 2023','09:40 pm','202309292140',''),(9,'Ajmal','1234567890','','2500.0','0','0','0','0','2500.0','06:06 pm','03 Oct 2023','03 Oct 2023','202310031806','20231003','2500','0.0','2500','03 Oct 2023','06:06 pm','202310031806',''),(10,'Ajmal','1234567890','','2500.0','0','0','0','0','2500.0','05:03 pm','08 Oct 2023','08 Oct 2023','202310081703','20231008','2500','0.0','2500','08 Oct 2023','05:03 pm','202310081703','');
INSERT INTO `ingredient_sold_item_details` (`_id`, `vendor_name`, `vendor_phoneno`, `itemname`, `qty_add`, `individual_price`, `total_price`, `invoice`, `billamount`, `tax_percent`, `tax_amount`, `disc_percent`, `disc_amount`, `total_bill_amount`, `from_time`, `from_date`, `due_date`, `datetimee_new_from`, `datetimee_new_due`, `pay`, `pending`, `tax1`, `tax2`, `tax3`, `tax4`, `tax5`, `tax6`, `tax7`, `tax8`, `tax9`, `tax10`, `tax11`, `tax12`, `tax13`, `tax14`, `tax15`, `tax1_value`, `tax2_value`, `tax3_value`, `tax4_value`, `tax5_value`, `tax6_value`, `tax7_value`, `tax8_value`, `tax9_value`, `tax10_value`, `tax11_value`, `tax12_value`, `tax13_value`, `tax14_value`, `tax15_value`, `wastage`, `unit`) VALUES (1,'Ajmal','1234567890','Motor','20','50','1000.0','','1000.0','0','0','0','0','1000.0','07:49 p.m.','30 Nov 2022','30 Nov 2022','202211301949','20221130','1000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','no.'),(2,'Ajmal','1234567890','Sugar ','20','40','800.0','','800.0','0','0','0','0','800.0','05:37 pm','28 Jun 2023','28 Jun 2023','202306281737','20230628','800','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(3,'Ajmal','1234567890','Sugar ','40','40','1600.0','','1600.0','0','0','0','0','1600.0','12:41 pm','07 Jul 2023','07 Jul 2023','202307071241','20230707','1600','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(4,'Ajmal','1234567890','Sugar ','30','35','1050.0','','1050.0','0','0','0','0','1050.0','04:01 pm','02 Aug 2023','02 Aug 2023','202308021601','20230802','','1050.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(5,'Ajmal','1234567890','Sugar ','20','35','700.0','','700.0','0','0','0','0','700.0','07:05 pm','10 Aug 2023','10 Aug 2023','202308101905','20230810','700','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(6,'Ajmal','1234567890','Sugar ','50','45','2250.0','','2250.0','0','0','0','0','2250.0','01:11 pm','16 Sep 2023','16 Sep 2023','202309161311','20230916','2250','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(7,'Ajmal','1234567890','Sugar ','40','50','2000.0','','2000.0','0','0','0','0','2000.0','09:40 pm','29 Sep 2023','29 Sep 2023','202309292140','20230929','2000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(8,'Ajmal','1234567890','Sugar ','50','50','2500.0','','2500.0','0','0','0','0','2500.0','06:06 pm','03 Oct 2023','03 Oct 2023','202310031806','20231003','2500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(9,'Ajmal','1234567890','Sugar ','50','50','2500.0','','2500.0','0','0','0','0','2500.0','05:03 pm','08 Oct 2023','08 Oct 2023','202310081703','20231008','2500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg');
INSERT INTO `ingredients` (`_id`, `ingredient_name`, `min_req`, `max_req`, `current_stock`, `unit`, `indiv_price`, `total_price`, `date`, `date1`, `time`, `time1`, `datetimee_new`, `avg_price`, `required`, `barcode`, `status_low`, `status_qty_updated`, `add_qty`, `indiv_price_copy`, `adjusted_stock`, `diff_stock`, `indiv_price_temp`, `total_price_temp`) VALUES (1,'Sugar ','25','50','0','Kg','40',NULL,'202311051609','05 Nov 2023','1609','04:09:28 pm','202312261342','40','50.0','',NULL,NULL,NULL,NULL,NULL,NULL,'40',NULL),(2,'Sugar ','25','50','0','Kg','50',NULL,'202311282019','28 Nov 2023','2019','08:19:38 pm','202312261342','50','50.0','',NULL,NULL,NULL,NULL,NULL,NULL,'50',NULL),(3,'Sugar ','25','50','0','Kg','50',NULL,'202312141538','14 Dec 2023','1538','03:38:33 pm','202312261342','50','50.0','',NULL,NULL,NULL,NULL,NULL,NULL,'50',NULL),(4,'Sugar ','25','50','0','Kg','50',NULL,'202312261340','26 Dec 2023','1340','01:40:50 pm','202312261342','50','50.0','',NULL,NULL,NULL,NULL,NULL,NULL,'50',NULL),(5,'Sugar','25','30','0','Kg','35',NULL,'202401031652','03 Jan 2024','1652','04:52:04 pm','202401031652','35','30.0','',NULL,NULL,NULL,NULL,NULL,NULL,'35',NULL),(6,'sugar','20','40','0','Kg','50',NULL,'202401171528','17 Jan 2024','1528','03:28:14 pm','202401171528','50','40.0','',NULL,NULL,NULL,NULL,NULL,NULL,'50',NULL),(7,'Sugar ','25','30','0','Kg','50',NULL,'202405161556','16 May 2024','1556','03:56:52 pm','202405161556','50','30.0','',NULL,NULL,NULL,NULL,NULL,NULL,'50',NULL),(8,'Sugar','25','30','0','Kg','50',NULL,'202406131642','13 Jun 2024','1642','04:42:35 pm','202406131642','50','30.0','',NULL,NULL,NULL,NULL,NULL,NULL,'50',NULL),(9,'sugar','25','30','0','Kg','50',NULL,'202407141349','14 Jul 2024','1349','01:49:20 pm','202407141349','50','30.0','',NULL,NULL,NULL,NULL,NULL,NULL,'50',NULL),(10,'sugar','25','30','0','Kg','0',NULL,'202407191846','19 Jul 2024','1846','06:46:01 pm','202407191846','0','30.0','',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(11,'Sugar','25','30','0','Kg','40',NULL,'202407241046','24 Jul 2024','1046','10:46:16 am','202407241046','40','30.0','',NULL,NULL,NULL,NULL,NULL,NULL,'40',NULL);
INSERT INTO `ingredients_temp_list` (`_id`, `itemname`, `avg_price`, `min_price`, `max_price`, `total_qty`, `total_price`, `barcode`, `unit`, `wastage_qty`, `wastage_cost`, `not_required`) VALUES (2,'Sugar','35.0','35.0','35.0','30.0','1050.0','','Kg','0.0','0','');
INSERT INTO `ipconn` (`_id`, `ipname`, `port`, `status`, `printer_name`) VALUES (1,'192.168.1.87','9100','','TM Printer');
INSERT INTO `ipconn_counter` (`_id`, `ipname`, `port`, `status`, `printer_name`) VALUES (1,'192.168.1.92','9100','',NULL);
INSERT INTO `ipconn_kot1` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.88','9100','',NULL,'kot1');
INSERT INTO `ipconn_kot2` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.89','9100','',NULL,'kot2');
INSERT INTO `ipconn_kot3` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.90','9100','',NULL,'kot3');
INSERT INTO `ipconn_kot4` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.91','9100','',NULL,'kot4');
INSERT INTO `items` (`_id`, `itemname`, `price`, `stockquan`, `category`, `itemtax`, `image`, `weekdaysvalue`, `weekendsvalue`, `manualstockvalue`, `automaticstockresetvalue`, `clickcount`, `favourites`, `disc_type`, `disc_value`, `image_text`, `barcode_value`, `checked`, `print_value`, `quantity_sold`, `minimum_qty`, `minimum_qty_copy`, `add_qty`, `status_low`, `status_qty_updated`, `individual_price`, `unit_type`, `tax_value`, `itemtax2`, `tax_value2`, `itemtax3`, `tax_value3`, `itemtax4`, `tax_value4`, `itemtax5`, `tax_value5`, `status_temp`, `status_perm`, `variant1`, `variant_price1`, `variant2`, `variant_price2`, `variant3`, `variant_price3`, `variant4`, `variant_price4`, `variant5`, `variant_price5`, `dept_name`, `add_qty_st`, `status_qty_updated_st`, `out_of_stock`, `mod_set1`, `mod_set2`, `mod_set3`, `mod_set4`, `mod_set5`, `v1_oofstock`, `v2_oofstock`, `v3_oofstock`, `v4_oofstock`, `v5_oofstock`) VALUES (1,'idly',25.00,50,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','ID','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'dosa',35.00,50,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','DO','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'pongal',30.00,50,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','PO','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'upma',30.00,50,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','UP','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'poori',35.00,50,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','PO','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'masal dosa',40.00,50,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','MA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'bread omlette',30.00,20,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','BR','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'onion dosa',35.00,30,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','ON','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'rava dosa',35.00,30,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','RA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'uthappam',30.00,30,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','UT','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'vada',20.00,100,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','VA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'masal vada',20.00,50,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','MA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'samosa',20.00,50,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','SA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'chicken kabab',60.00,20,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','CH','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'sheekh kabab',80.00,20,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','SH','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'pani puri',35.00,30,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','PA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'pav bhajji',60.00,30,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','PA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'veg cutlet',40.00,30,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','VE','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'masal puri',35.00,30,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','MA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'chicken nuggets',65.00,10,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','CH','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'veg biriyani',70.00,50,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','VE','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'chicken biriyani',100.00,50,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','CH','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'veg thali',50.00,50,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','VE','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'non veg thali',80.00,50,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','NO','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'mutton biriyani',120.00,50,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','MU','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'roti',15.00,100,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','RO','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'rice',30.00,50,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','RI','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'paneer butter masala',60.00,50,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','PA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'chicken sukka',80.00,50,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','CH','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'dhal fry',30.00,50,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','DH','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,'coffee',20.00,100,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','CO','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,'tea',20.00,50,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','TE','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,'masala chai',25.00,50,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','MA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,'soft drinks',10.00,50,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','SO','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,'lime juice',15.00,30,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','LI','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,'lassi',25.00,25,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','LA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,'grape juice',25.00,25,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','GR','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'vanilla icecream',35.00,50,'Desserts','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','VA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,'butterscotch icecream',40.00,50,'Desserts','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','BU','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'butterscotch cake',35.00,50,'Desserts','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','BU','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `items_temp_list` (`_id`, `itemname`, `avg_price`, `min_price`, `max_price`, `total_qty`, `total_price`, `barcode`, `not_required`) VALUES (1,'Egg rice','20.0','20.0','20.0','20.0','400.0','','');
INSERT INTO `itemsort` (`_id`, `itemsorttype`) VALUES (1,'Sort by Date added');
INSERT INTO `kot_print` (`_id`, `kot_print_status`) VALUES (1,'Yes');
INSERT INTO `loyalty_points` (`_id`, `money`, `point`, `point2`, `money2`) VALUES (1,'100','1','1','10');
INSERT INTO `loyalty_points_status` (`_id`, `status`) VALUES (1,'yes');
INSERT INTO `menulogin_checking` (`_id`, `status`) VALUES (1,'no');
INSERT INTO `modifiers` (`_id`, `modifiername`, `modprice`, `modstockquan`, `modcategory`, `moditemtax`, `modimage`, `mod_image_text`) VALUES (1,'potato masala',10,50,'Tiffin','None',NULL,NULL),(2,'podi',0,50,'Tiffin','None',NULL,NULL),(3,'cheese',15,35,'Tiffin','None',NULL,NULL),(4,'butter',10,40,'Tiffin','None',NULL,NULL),(5,'omlette',10,50,'Tiffin','None',NULL,NULL),(6,'cheese dip',20,50,'Snacks','None',NULL,NULL),(7,'potato fry',25,50,'Main course','None',NULL,NULL),(8,'chicken fry',40,45,'Main course','None',NULL,NULL),(9,'soda',6,50,'Main course','None',NULL,NULL),(10,'dessert',15,35,'Main course','None',NULL,NULL),(11,'medium',5,50,'Drinks','None',NULL,NULL),(12,'large',10,50,'Drinks','None',NULL,NULL),(13,'cream',20,50,'Desserts','None',NULL,NULL),(14,'chocolate',20,50,'Desserts','None',NULL,NULL);
INSERT INTO `name_dept1` (`_id`, `dept1_name`) VALUES (1,'kot1');
INSERT INTO `name_dept2` (`_id`, `dept2_name`) VALUES (1,'kot2');
INSERT INTO `name_dept3` (`_id`, `dept3_name`) VALUES (1,'kot3');
INSERT INTO `name_dept4` (`_id`, `dept4_name`) VALUES (1,'kot4');
INSERT INTO `ordertaking_server_ip` (`_id`, `ipname`, `port`, `status`) VALUES (1,'192.168.1.100','8080','');
INSERT INTO `paytmmerchantreg` (`_id`, `Account`, `MerchantName`, `guid`, `MID`, `Merchant_key`, `PosID`) VALUES (1,'Not_Registered','','','','','');
INSERT INTO `printer_text_size` (`_id`, `type`) VALUES (1,'Standard');
INSERT INTO `printer_type` (`_id`, `printer_type`) VALUES (1,'Generic');
INSERT INTO `printerreceiptsize` (`_id`, `papersize`) VALUES (3,'2 inch');
INSERT INTO `restaurant_id` (`_id`, `merchant_id`) VALUES (1,'0');
INSERT INTO `round_off` (`_id`, `round_off_status`) VALUES (1,'No');
INSERT INTO `schedule_mail_on_off` (`_id`, `status`) VALUES (1,'Off');
INSERT INTO `schedule_mail_time` (`_id`, `time`) VALUES (1,'11:30 PM');
INSERT INTO `stockcontrol` (`_id`, `stockcontroltype`) VALUES (1,'Off');
INSERT INTO `stockreset` (`_id`, `stockresettype`) VALUES (1,'Off');
INSERT INTO `storedays` (`_id`, `weekdays`, `weekends`, `swap`) VALUES (1,'Monday','0','0'),(2,'Tuesday','0','0'),(3,'Wednesday','0','0'),(4,'Thursday','0','0'),(5,'0','Friday','Friday'),(6,'0','Saturday','Saturday'),(7,'0','Sunday','Sunday');
INSERT INTO `sync_time` (`_id`, `last_time`) VALUES (1,'05 Apr 18, 05:22 PM');
INSERT INTO `totaltables` (`_id`, `nooftables`) VALUES (1,'4');
INSERT INTO `user_privilege` (`_id`, `username`, `returns_refunds`, `product_tax`, `reports`, `settings`, `backup`, `customer`, `ingredients`, `subscriptions`) VALUES (1,'user1','no','no','no','no','no','no','no','no'),(2,'user2','no','no','no','no','no','no','no','no'),(3,'user3','no','no','no','no','no','no','no','no'),(4,'user4','no','no','no','no','no','no','no','no'),(5,'user5','no','no','no','no','no','no','no','no'),(6,'user6','no','no','no','no','no','no','no','no');
INSERT INTO `vendor_details` (`_id`, `vendor_name`, `vendor_phoneno`, `vendor_email`, `vendor_address`, `vendor_gst`) VALUES (1,'Ajmal','9876543210','','',''),(2,'Janasya','4523987996','','','');
INSERT INTO `vendor_details_micro` (`_id`, `vendor_name`, `vendor_phoneno`, `vendor_email`, `vendor_address`, `vendor_gst`) VALUES (1,'Ajmal','1234567890','','','');
INSERT INTO `vendor_sold_details` (`_id`, `vendor_name`, `vendor_phoneno`, `invoice`, `billamount`, `tax_percent`, `tax_amount`, `disc_percent`, `disc_amount`, `total_bill_amount`, `from_time`, `from_date`, `due_date`, `datetimee_new_from`, `datetimee_new_due`, `pay`, `pending`, `total_pay`, `pay_date`, `pay_time`, `pay_datetimeemew`, `not_required`) VALUES (1,'Ajmal','1231567893','','100.0','0','0','0','0','100.0','02:41 p.m.','15 Sep 2022','15 Sep 2022','202209151441','20220915','0','100.0','0','15 Sep 2022','02:41 p.m.','202209151441',''),(2,'Ajmal','1231567893','','2500.0','0','0','0','0','2500.0','06:02 p.m.','06 Oct 2022','06 Oct 2022','202210061802','20221006','0','2500.0','0','06 Oct 2022','06:02 p.m.','202210061802',''),(3,'Warehouse','9879653421','','1250.0','0','0','0','0','1250.0','02:19 p.m.','08 Oct 2022','08 Oct 2022','202210081419','20221008','0','1250.0','0','08 Oct 2022','02:19 p.m.','202210081419',''),(4,'Ajmal','1231567893','','500.0','0','0','0','0','500.0','11:50 a.m.','13 Oct 2022','13 Oct 2022','202210131150','20221013','0','500.0','0','13 Oct 2022','11:50 a.m.','202210131150',''),(5,'Ajmal','1231567893','','500.0','0','0','0','0','500.0','02:40 p.m.','19 Oct 2022','19 Oct 2022','202210191440','20221019','0','500.0','0','19 Oct 2022','02:40 p.m.','202210191440',''),(6,'Warehouse','9879653421','','625.0','0','0','0','0','625.0','01:25 p.m.','20 Oct 2022','20 Oct 2022','202210201325','20221020','0','625.0','0','20 Oct 2022','01:25 p.m.','202210201325',''),(7,'Ajmal','1231567893','','2600.0','0','0','0','0','2600.0','05:18 p.m.','05 Nov 2022','05 Nov 2022','202211051718','20221105','2600','0.0','2600','05 Nov 2022','05:18 p.m.','202211051718',''),(8,'Ajmal','1231567893','','90.0','0','0','0','0','90.0','02:15 p.m.','10 Nov 2022','10 Nov 2022','202211101415','20221110','0','90.0','0','10 Nov 2022','02:15 p.m.','202211101415',''),(9,'Ajmal','1231567893','','1000.0','0','0','0','0','1000.0','04:58 p.m.','12 Nov 2022','12 Nov 2022','202211121658','20221112','1000','0.0','1000','12 Nov 2022','04:58 p.m.','202211121658',''),(10,'Ajmal','1231567893','','600.0','0','0','0','0','600.0','12:09 p.m.','17 Nov 2022','17 Nov 2022','202211171209','20221117','0','600.0','0','17 Nov 2022','12:09 p.m.','202211171209',''),(11,'Ajmal','1231567893','','400.0','0','0','0','0','400.0','11:15 a.m.','19 Nov 2022','19 Nov 2022','202211191115','20221119','400','0.0','400','19 Nov 2022','11:15 a.m.','202211191115',''),(12,'Ajmal','1231567893','','600.0','0','0','0','0','600.0','12:09 p.m.','17 Nov 2022','17 Nov 2022','202211171209','20221117','600','0.0','600.0','19 Nov 2022','11:18 a.m.','202211191118',''),(13,'Ajmal','9876543210','','500.0','0','0','0','0','500.0','06:09 p.m.','22 Nov 2022','22 Nov 2022','202211221809','20221122','500','0.0','500','22 Nov 2022','06:09 p.m.','202211221809',''),(14,'Janasya','4523987996','','17980.0','0','0','0','0','17980.0','03:10 pm','18 Dec 2022','18 Dec 2022','202212181510','20221218','17980','0.0','17980','18 Dec 2022','03:10 pm','202212181510',''),(15,'Ajmal','9876543210','','27000','0','0','0','0','27000','12:17 PM','26 Apr 2023','26 Apr 2023','202304261217','20230426','27000','0.0','27000','26 Apr 2023','12:17 PM','202304261217',NULL),(16,'Ajmal','9876543210','','500.0','0','0','0','0','500.0','05:34 pm','28 Jun 2023','28 Jun 2023','202306281734','20230628','500','0.0','500','28 Jun 2023','05:34 pm','202306281734',''),(17,'Ajmal','9876543210','','760.0','0','0','0','0','760.0','04:39 pm','04 Jul 2023','04 Jul 2023','202307041639','20230704','760','0.0','760','04 Jul 2023','04:39 pm','202307041639',''),(18,'Ajmal','9876543210','','760.0','0','0','0','0','760.0','08:28 pm','04 Jul 2023','04 Jul 2023','202307042028','20230704','760','0.0','760','04 Jul 2023','08:28 pm','202307042028',''),(19,'Ajmal','9876543210','','360.0','0','0','0','0','360.0','01:46 pm','18 Jul 2023','18 Jul 2023','202307181346','20230718','360','0.0','360','18 Jul 2023','01:46 pm','202307181346',''),(20,'Ajmal','9876543210','','340.0','0','0','0','0','340.0','04:37 pm','21 Jul 2023','21 Jul 2023','202307211637','20230721','340','0.0','340','21 Jul 2023','04:37 pm','202307211637',''),(21,'Ajmal','9876543210','','480.0','0','0','0','0','480.0','08:10 pm','26 Jul 2023','26 Jul 2023','202307262010','20230726','480','0.0','480','26 Jul 2023','08:10 pm','202307262010',''),(22,'Ajmal','9876543210','','6400.0','0','0','0','0','6400.0','03:04 pm','01 Aug 2023','01 Aug 2023','202308011504','20230801','6000','400.0','6000','01 Aug 2023','03:04 pm','202308011504',''),(23,'Ajmal','9876543210','','6400.0','0','0','0','0','6400.0','03:04 pm','01 Aug 2023','01 Aug 2023','202308011504','20230801','400','0.0','6400.0','01 Aug 2023','03:07 pm','202308011507',''),(24,'Ajmal','9876543210','','20000.0','0','0','0','0','20000.0','04:05 pm','04 Aug 2023','04 Aug 2023','202308041605','20230804','19000','1000.0','19000','04 Aug 2023','04:05 pm','202308041605',''),(25,'Ajmal','9876543210','','20000.0','0','0','0','0','20000.0','04:05 pm','04 Aug 2023','04 Aug 2023','202308041605','20230804','1000','0.0','20000.0','04 Aug 2023','04:06 pm','202308041606',''),(26,'Ajmal','9876543210','','250.0','0','0','0','0','250.0','09:28 pm','10 Aug 2023','10 Aug 2023','202308102128','20230810','250','0.0','250','10 Aug 2023','09:28 pm','202308102128',''),(27,'Ajmal','9876543210','','200.0','0','0','0','0','200.0','12:14 pm','19 Aug 2023','19 Aug 2023','202308191214','20230819','0','200.0','0','19 Aug 2023','12:14 pm','202308191214',''),(28,'Ajmal','9876543210','','200.0','0','0','0','0','200.0','12:14 pm','19 Aug 2023','19 Aug 2023','202308191214','20230819','200','0.0','200.0','19 Aug 2023','12:16 pm','202308191216',''),(29,'Ajmal','9876543210','','340.0','0','0','0','0','340.0','11:33 am','24 Aug 2023','24 Aug 2023','202308241133','20230824','0','340.0','0','24 Aug 2023','11:33 am','202308241133',''),(30,'Ajmal','9876543210','','340.0','0','0','0','0','340.0','11:33 am','24 Aug 2023','24 Aug 2023','202308241133','20230824','340','0.0','340.0','24 Aug 2023','11:34 am','202308241134',''),(31,'Ajmal','9876543210','','180.0','0','0','0','0','180.0','04:59 pm','24 Aug 2023','24 Aug 2023','202308241659','20230824','180','0.0','180','24 Aug 2023','04:59 pm','202308241659',''),(32,'Ajmal','9876543210','','480.0','0','0','0','0','480.0','07:28 pm','01 Sep 2023','01 Sep 2023','202309011928','20230901','480','0.0','480','01 Sep 2023','07:28 pm','202309011928',''),(33,'Ajmal','9876543210','','6000.0','0','0','0','0','6000.0','10:36 am','09 Sep 2023','09 Sep 2023','202309091036','20230909','5500','500.0','5500','09 Sep 2023','10:36 am','202309091036',''),(34,'Ajmal','9876543210','','6000.0','0','0','0','0','6000.0','10:36 am','09 Sep 2023','09 Sep 2023','202309091036','20230909','500','0.0','6000.0','09 Sep 2023','10:38 am','202309091038',''),(35,'Ajmal','9876543210','','500.0','0','0','0','0','500.0','05:37 pm','21 Sep 2023','21 Sep 2023','202309211737','20230921','500','0.0','500','21 Sep 2023','05:37 pm','202309211737',''),(36,'Ajmal','9876543210','','100000.0','0','0','0','0','100000.0','01:34 pm','28 Sep 2023','28 Sep 2023','202309281334','20230928','100000','0.0','100000','28 Sep 2023','01:34 pm','202309281334',''),(37,'Ajmal','9876543210','','780.0','0','0','0','0','780.0','06:03 pm','03 Oct 2023','03 Oct 2023','202310031803','20231003','780','0.0','780','03 Oct 2023','06:03 pm','202310031803',''),(38,'Ajmal','9876543210','','1000.0','0','0','0','0','1000.0','04:56 pm','12 Oct 2023','12 Oct 2023','202310121656','20231012','1000','0.0','1000','12 Oct 2023','04:56 pm','202310121656',''),(39,'Ajmal','9876543210','','1000.0','0','0','0','0','1000.0','04:55 pm','22 Oct 2023','22 Oct 2023','202310221655','20231022','1000','0.0','1000','22 Oct 2023','04:55 pm','202310221655',''),(40,'Janasya','4523987996','','500.0','0','0','0','0','500.0','05:09 pm','25 Oct 2023','25 Oct 2023','202310251709','20231025','500','0.0','500','25 Oct 2023','05:09 pm','202310251709','');
INSERT INTO `vendor_sold_item_details` (`_id`, `vendor_name`, `vendor_phoneno`, `itemname`, `qty_add`, `individual_price`, `total_price`, `invoice`, `billamount`, `tax_percent`, `tax_amount`, `disc_percent`, `disc_amount`, `total_bill_amount`, `from_time`, `from_date`, `due_date`, `datetimee_new_from`, `datetimee_new_due`, `pay`, `pending`, `tax1`, `tax2`, `tax3`, `tax4`, `tax5`, `tax6`, `tax7`, `tax8`, `tax9`, `tax10`, `tax11`, `tax12`, `tax13`, `tax14`, `tax15`, `tax1_value`, `tax2_value`, `tax3_value`, `tax4_value`, `tax5_value`, `tax6_value`, `tax7_value`, `tax8_value`, `tax9_value`, `tax10_value`, `tax11_value`, `tax12_value`, `tax13_value`, `tax14_value`, `tax15_value`) VALUES (12,'Ajmal','1231567893','Egg rice','20','20','400.0','','400.0','0','0','0','0','400.0','11:15 a.m.','19 Nov 2022','19 Nov 2022','202211191115','20221119','400','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'Ajmal','9876543210','idly','50','10','500.0','','500.0','0','0','0','0','500.0','06:09 p.m.','22 Nov 2022','22 Nov 2022','202211221809','20221122','500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'Ajmal','9876543210','Sugar 1kg','20','45','900.0','','900.0','0','0','0','0','900.0','02:24 pm','07 Dec 2022','07 Dec 2022','202212071424','20221207','900','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'Ajmal','9876543210','idly','20','10','200.0','','200.0','0','0','0','0','200.0','04:52 pm','07 Dec 2022','07 Dec 2022','202212071652','20221207','200','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'Ajmal','9876543210','Fish ','10','45','450.0','','450.0','0','0','0','0','450.0','06:57 pm','07 Dec 2022','07 Dec 2022','202212071857','20221207','450','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'warehouse','2528643588','lassi','200','15','3000.0','','3000.0','0','0','0','0','3000.0','04:01 pm','08 Dec 2022','08 Dec 2022','202212081601','20221208','3000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'Ajmal','9876543210','Sugar','10','45','450.0','','450.0','0','0','0','0','450.0','11:11 am','09 Dec 2022','09 Dec 2022','202212091111','20221209','450','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'Rahul','1234568790','salwar dc ','1','200','200.0','','400.0','0','0','0','0','400.0','05:30 pm','09 Dec 2022','09 Dec 2022','202212091730','20221209','','400.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'Rahul','1234568790','frog dc ','1','200','200.0','','400.0','0','0','0','0','400.0','05:30 pm','09 Dec 2022','09 Dec 2022','202212091730','20221209','','400.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'Ajmal','9876543210','grape juice','10','24','240.0','','240.0','0','0','0','0','240.0','02:38 pm','10 Dec 2022','10 Dec 2022','202212101438','20221210','240','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'Ajmal','9876543210','TV Samsung','10','19000','190000.0','','190000.0','0','0','0','0','190000.0','04:23 pm','10 Dec 2022','10 Dec 2022','202212101623','20221210','1900000','-1710000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'Rahul','1234568790','soft drinks','20','25','500.0','','980.0','0','0','0','0','980.0','12:00 pm','13 Dec 2022','13 Dec 2022','202212131200','20221213','980','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'Rahul','1234568790','grape juice','20','24','480.0','','980.0','0','0','0','0','980.0','12:00 pm','13 Dec 2022','13 Dec 2022','202212131200','20221213','980','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'warehouse','2528643588','soft drinks','20','24','480.0','','480.0','0','0','0','0','480.0','12:58 pm','13 Dec 2022','13 Dec 2022','202212131258','20221213','480','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'Ajmal','9876543210','samosa','10','50','500.0','2022-2-21','500.0','0','0','0','0','500.0','12:59 pm','13 Dec 2022','13 Dec 2022','202212131259','20221213','500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'Ajmal','9876543210','soft drinks','20','24','480.0','','480.0','0','0','0','0','480.0','03:14 pm','13 Dec 2022','13 Dec 2022','202212131514','20221213','480','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'Ajmal','9876543210','Garment upper','20','23','460.0','','460.0','0','0','0','0','460.0','05:54 pm','14 Dec 2022','14 Dec 2022','202212141754','20221214','460','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'Janasya','4523987996','Kurta ','20','899','17980.0','','17980.0','0','0','0','0','17980.0','03:10 pm','18 Dec 2022','18 Dec 2022','202212181510','20221218','17980','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'Ajmal','9876543210','Thumbs up ','20','38','760.0','','760.0','0','0','0','0','760.0','03:40 pm','19 Dec 2022','19 Dec 2022','202212191540','20221219','760','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,'Ajmal','9876543210','Thumbs up ','10','38','380.0','','380.0','0','0','0','0','380.0','01:37 pm','20 Dec 2022','20 Dec 2022','202212201337','20221220','380','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,'Ajmal','9876543210','Sprite 250ml','20','38','760.0','','760.0','0','0','0','0','760.0','05:10 pm','23 Dec 2022','23 Dec 2022','202212231710','20221223','760','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,'Ajmal','9876543210','Tempered glass ','20','40','800.0','','800.0','0','0','0','0','800.0','02:59 pm','24 Dec 2022','24 Dec 2022','202212241459','20221224','800','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,'Ajmal','9876543210','Sprite 250ml','20','38','760.0','','760.0','0','0','0','0','760.0','03:04 pm','26 Dec 2022','26 Dec 2022','202212261504','20221226','760','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,'Ajmal','9876543210','Bread ','20','18','360.0','','360.0','0','0','0','0','360.0','05:06 pm','29 Dec 2022','29 Dec 2022','202212291706','20221229','360','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,'Ajmal','9876543210','Dhaniya 1kg','10','95','950.0','','950.0','0','0','0','0','950.0','07:03 pm','02 Jan 2023','02 Jan 2023','202301021903','20230102','950','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,'Ajmal','9876543210','Shoes 8 inch ','20','350','7000.0','','7000.0','0','0','0','0','7000.0','07:14 pm','05 Jan 2023','05 Jan 2023','202301051914','20230105','','7000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'Ajmal','9876543210','Pepsi 500ml','20','38','760.0','','760.0','0','0','0','0','760.0','05:49 pm','08 Jan 2023','08 Jan 2023','202301081749','20230108','760','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,'Ajmal','9876543210','Masala packet','20','58','1160.0','','1160.0','0','0','0','0','1160.0','01:24 pm','10 Jan 2023','10 Jan 2023','202301101324','20230110','1160','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'Ajmal','9876543210','Bisleri','20','18','360.0','','360.0','0','0','0','0','360.0','03:08 pm','17 Jan 2023','17 Jan 2023','202301171508','20230117','120','240.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'Ajmal','9876543210','Mountain dew drink ','20','43','860.0','','860.0','0','0','0','0','860.0','11:43 am','21 Jan 2023','21 Jan 2023','202301211143','20230121','860','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(42,'Ajmal','9876543210','samosaa','15','10','150.0','','150.0','0','0','0','0','150.0','01:51 pm','24 Jan 2023','24 Jan 2023','202301241351','20230124','150','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,'Ajmal','9876543210','Ashirwad','10','325','3250.0','','3250.0','0','0','0','0','3250.0','02:55 pm','24 Jan 2023','24 Jan 2023','202301241455','20230124','3250','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,'Ajmal','9876543210','Ashirwad 10kg','10','325','3250.0','','3250.0','0','0','0','0','3250.0','03:09 pm','24 Jan 2023','24 Jan 2023','202301241509','20230124','3250','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(45,'Ajmal','9876543210','Raw chicken 1 kg','10','250','2500.0','','2500.0','0','0','0','0','2500.0','12:58 pm','27 Jan 2023','27 Jan 2023','202301271258','20230127','1500','1000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(46,'Ajmal','9876543210','Local atta 1kg','10','50','500.0','','500.0','0','0','0','0','500.0','06:15 pm','03 Feb 2023','03 Feb 2023','202302031815','20230203','500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(47,'Ajmal','9876543210','Loreal colour black 1 box','10','250','2500.0','','2500.0','0','0','0','0','2500.0','03:12 pm','07 Feb 2023','07 Feb 2023','202302071512','20230207','0','2500.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(48,'Ajmal','9876543210','Pepsi 500ml','20','35','700.0','','700.0','0','0','0','0','700.0','02:25 pm','08 Feb 2023','08 Feb 2023','202302081425','20230208','0','700.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(49,'Ajmal','9876543210','one plus Nord ','10','20000','200000.0','','200000.0','0','0','0','0','200000.0','08:39 pm','08 Feb 2023','08 Feb 2023','202302082039','20230208','150000','50000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(50,'Ajmal','9876543210','rice','10','50','500','','27000','0','0','0','0','27000','12:17 PM','26 Apr 2023','26 Apr 2023','202304261217','20230426','27000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(51,'Ajmal','9876543210','paneer butter masala','10','50','500','','27000','0','0','0','0','27000','12:17 PM','26 Apr 2023','26 Apr 2023','202304261217','20230426','27000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52,'Ajmal','9876543210','chicken sukka','10','100','1000','','27000','0','0','0','0','27000','12:17 PM','26 Apr 2023','26 Apr 2023','202304261217','20230426','27000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(53,'Ajmal','9876543210','dhal fry','50','500','25000','','27000','0','0','0','0','27000','12:17 PM','26 Apr 2023','26 Apr 2023','202304261217','20230426','27000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(54,'Ajmal','9876543210','butterscotch icecream','25','20','500.0','','500.0','0','0','0','0','500.0','05:34 pm','28 Jun 2023','28 Jun 2023','202306281734','20230628','500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(55,'Ajmal','9876543210','thumbsup','20','38','760.0','','760.0','0','0','0','0','760.0','04:39 pm','04 Jul 2023','04 Jul 2023','202307041639','20230704','760','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(56,'Ajmal','9876543210','thumbsup','20','38','760.0','','760.0','0','0','0','0','760.0','08:28 pm','04 Jul 2023','04 Jul 2023','202307042028','20230704','760','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(57,'Ajmal','9876543210','Bisleri 500ml','20','18','360.0','','360.0','0','0','0','0','360.0','01:46 pm','18 Jul 2023','18 Jul 2023','202307181346','20230718','360','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(58,'Ajmal','9876543210','Bisleri 500ml','20','17','340.0','','340.0','0','0','0','0','340.0','04:37 pm','21 Jul 2023','21 Jul 2023','202307211637','20230721','340','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(59,'Ajmal','9876543210','grape juice','20','24','480.0','','480.0','0','0','0','0','480.0','08:10 pm','26 Jul 2023','26 Jul 2023','202307262010','20230726','480','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(60,'Ajmal','9876543210','Almond 100gm','20','320','6400.0','','6400.0','0','0','0','0','6400.0','03:04 pm','01 Aug 2023','01 Aug 2023','202308011504','20230801','6000','400.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(61,'Ajmal','9876543210','society tea 500 gm ','200','100','20000.0','','20000.0','0','0','0','0','20000.0','04:05 pm','04 Aug 2023','04 Aug 2023','202308041605','20230804','19000','1000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(62,'Ajmal','9876543210','capachino','10','25','250.0','','250.0','0','0','0','0','250.0','09:28 pm','10 Aug 2023','10 Aug 2023','202308102128','20230810','250','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(63,'Ajmal','9876543210','idli 1 plate ','20','10','200.0','','200.0','0','0','0','0','200.0','12:14 pm','19 Aug 2023','19 Aug 2023','202308191214','20230819','0','200.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(64,'Ajmal','9876543210','Bisleri 500ml','20','17','340.0','','340.0','0','0','0','0','340.0','11:33 am','24 Aug 2023','24 Aug 2023','202308241133','20230824','0','340.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(65,'Ajmal','9876543210','idly','20','9','180.0','','180.0','0','0','0','0','180.0','04:59 pm','24 Aug 2023','24 Aug 2023','202308241659','20230824','180','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(66,'Ajmal','9876543210','Shoes ','50','120','6000.0','','6000.0','0','0','0','0','6000.0','10:36 am','09 Sep 2023','09 Sep 2023','202309091036','20230909','5500','500.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(67,'Ajmal','9876543210','vanilla icecream','25','20','500.0','','500.0','0','0','0','0','500.0','05:37 pm','21 Sep 2023','21 Sep 2023','202309211737','20230921','500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(68,'Ajmal','9876543210','ABC Jeans 32 ','100','1000','100000.0','','100000.0','0','0','0','0','100000.0','01:34 pm','28 Sep 2023','28 Sep 2023','202309281334','20230928','100000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(69,'Ajmal','9876543210','soft drinks','20','24','480.0','','780.0','0','0','0','0','780.0','06:03 pm','03 Oct 2023','03 Oct 2023','202310031803','20231003','780','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(70,'Ajmal','9876543210','lime juice','20','15','300.0','','780.0','0','0','0','0','780.0','06:03 pm','03 Oct 2023','03 Oct 2023','202310031803','20231003','780','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(71,'Ajmal','9876543210','Rice 1kg','20','50','1000.0','','1000.0','0','0','0','0','1000.0','04:56 pm','12 Oct 2023','12 Oct 2023','202310121656','20231012','1000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(72,'Ajmal','9876543210','Rice 1kg','20','50','1000.0','','1000.0','0','0','0','0','1000.0','04:55 pm','22 Oct 2023','22 Oct 2023','202310221655','20231022','1000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(73,'Janasya','4523987996','Rice 1kg','10','50','500.0','','500.0','0','0','0','0','500.0','05:09 pm','25 Oct 2023','25 Oct 2023','202310251709','20231025','500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(74,'Ajmal','9876543210','Rice 1kg','10','50','500.0','','500.0','0','0','0','0','500.0','04:02 pm','05 Nov 2023','05 Nov 2023','202311051602','20231105','250','250.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(75,'Ajmal','9876543210','Rice 1kg','10','50','500.0','','500.0','0','0','0','0','500.0','03:20 pm','07 Nov 2023','07 Nov 2023','202311071520','20231107','500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(76,'Ajmal','9876543210','Rice 1kg','10','50','500.0','','500.0','0','0','0','0','500.0','06:06 pm','07 Nov 2023','07 Nov 2023','202311071806','20231107','500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(77,'Ajmal','9876543210','Paracetamol 650 ','100','20','2000.0','','2000.0','0','0','0','0','2000.0','04:13 pm','09 Nov 2023','09 Nov 2023','202311091613','20231109','2000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(78,'Ajmal','9876543210','Jeans ','20','400','8000.0','','8000.0','0','0','0','0','8000.0','02:02 pm','14 Nov 2023','14 Nov 2023','202311141402','20231114','8000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(79,'Ajmal','9876543210','idly','10','9','90.0','','2890.0','0','0','0','0','2890.0','06:50 pm','28 Nov 2023','28 Nov 2023','202311281850','20231128','2890','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(80,'Ajmal','9876543210','dosa','10','10','100.0','','2890.0','0','0','0','0','2890.0','06:50 pm','28 Nov 2023','28 Nov 2023','202311281850','20231128','2890','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(81,'Ajmal','9876543210','pongal','10','10','100.0','','2890.0','0','0','0','0','2890.0','06:50 pm','28 Nov 2023','28 Nov 2023','202311281850','20231128','2890','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(82,'Ajmal','9876543210','upma','10','10','100.0','','2890.0','0','0','0','0','2890.0','06:50 pm','28 Nov 2023','28 Nov 2023','202311281850','20231128','2890','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(83,'Ajmal','9876543210','poori','10','10','100.0','','2890.0','0','0','0','0','2890.0','06:50 pm','28 Nov 2023','28 Nov 2023','202311281850','20231128','2890','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(84,'Ajmal','9876543210','masal dosa','10','10','100.0','','2890.0','0','0','0','0','2890.0','06:50 pm','28 Nov 2023','28 Nov 2023','202311281850','20231128','2890','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(85,'Ajmal','9876543210','bread omlette','10','10','100.0','','2890.0','0','0','0','0','2890.0','06:50 pm','28 Nov 2023','28 Nov 2023','202311281850','20231128','2890','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(86,'Ajmal','9876543210','onion dosa','10','10','100.0','','2890.0','0','0','0','0','2890.0','06:50 pm','28 Nov 2023','28 Nov 2023','202311281850','20231128','2890','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(87,'Ajmal','9876543210','rava dosa','10','10','100.0','','2890.0','0','0','0','0','2890.0','06:50 pm','28 Nov 2023','28 Nov 2023','202311281850','20231128','2890','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(88,'Ajmal','9876543210','uthappam','10','10','100.0','','2890.0','0','0','0','0','2890.0','06:50 pm','28 Nov 2023','28 Nov 2023','202311281850','20231128','2890','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(89,'Ajmal','9876543210','vada','10','10','100.0','','2890.0','0','0','0','0','2890.0','06:50 pm','28 Nov 2023','28 Nov 2023','202311281850','20231128','2890','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(90,'Ajmal','9876543210','masal vada','10','10','100.0','','2890.0','0','0','0','0','2890.0','06:50 pm','28 Nov 2023','28 Nov 2023','202311281850','20231128','2890','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(91,'Ajmal','9876543210','samosa','10','50','500.0','','2890.0','0','0','0','0','2890.0','06:50 pm','28 Nov 2023','28 Nov 2023','202311281850','20231128','2890','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(92,'Ajmal','9876543210','chicken kabab','10','10','100.0','','2890.0','0','0','0','0','2890.0','06:50 pm','28 Nov 2023','28 Nov 2023','202311281850','20231128','2890','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(93,'Ajmal','9876543210','sheekh kabab','10','10','100.0','','2890.0','0','0','0','0','2890.0','06:50 pm','28 Nov 2023','28 Nov 2023','202311281850','20231128','2890','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(94,'Ajmal','9876543210','pani puri','10','10','100.0','','2890.0','0','0','0','0','2890.0','06:50 pm','28 Nov 2023','28 Nov 2023','202311281850','20231128','2890','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(95,'Ajmal','9876543210','pav bhajji','10','10','100.0','','2890.0','0','0','0','0','2890.0','06:50 pm','28 Nov 2023','28 Nov 2023','202311281850','20231128','2890','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(96,'Ajmal','9876543210','veg cutlet','10','10','100.0','','2890.0','0','0','0','0','2890.0','06:50 pm','28 Nov 2023','28 Nov 2023','202311281850','20231128','2890','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(97,'Ajmal','9876543210','masal puri','10','10','100.0','','2890.0','0','0','0','0','2890.0','06:50 pm','28 Nov 2023','28 Nov 2023','202311281850','20231128','2890','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(98,'Ajmal','9876543210','chicken nuggets','10','10','100.0','','2890.0','0','0','0','0','2890.0','06:50 pm','28 Nov 2023','28 Nov 2023','202311281850','20231128','2890','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(99,'Ajmal','9876543210','veg biriyani','10','10','100.0','','2890.0','0','0','0','0','2890.0','06:50 pm','28 Nov 2023','28 Nov 2023','202311281850','20231128','2890','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(100,'Ajmal','9876543210','chicken biriyani','10','10','100.0','','2890.0','0','0','0','0','2890.0','06:50 pm','28 Nov 2023','28 Nov 2023','202311281850','20231128','2890','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(101,'Ajmal','9876543210','veg thali','10','10','100.0','','2890.0','0','0','0','0','2890.0','06:50 pm','28 Nov 2023','28 Nov 2023','202311281850','20231128','2890','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(102,'Ajmal','9876543210','non veg thali','10','10','100.0','','2890.0','0','0','0','0','2890.0','06:50 pm','28 Nov 2023','28 Nov 2023','202311281850','20231128','2890','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(103,'Ajmal','9876543210','mutton biriyani','10','10','100.0','','2890.0','0','0','0','0','2890.0','06:50 pm','28 Nov 2023','28 Nov 2023','202311281850','20231128','2890','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(104,'Ajmal','9876543210','idly','10','9','90.0','','90.0','0','0','0','0','90.0','12:03 pm','03 Dec 2023','03 Dec 2023','202312031203','20231203','90','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(105,'Ajmal','9876543210','sugar 1kg','50','45','2250.0','','2250.0','0','0','0','0','2250.0','05:44 pm','20 Dec 2023','20 Dec 2023','202312201744','20231220','0','2250.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(106,'Ajmal','9876543210','sugar 1kg','50','45','2250.0','','2250.0','0','0','0','0','2250.0','12:11 pm','24 Dec 2023','24 Dec 2023','202312241211','20231224','2000','250.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(107,'Ajmal','9876543210','idly','20','9','180.0','','180.0','0','0','0','0','180.0','01:36 pm','24 Dec 2023','24 Dec 2023','202312241336','20231224','180','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(108,'Ajmal','9876543210','butterscotch cake','20','50','1000.0','','1000.0','0','0','0','0','1000.0','01:41 pm','29 Dec 2023','29 Dec 2023','202312291341','20231229','500','500.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(109,'Ajmal','9876543210','sare','100','450','45000.0','','45000.0','0','0','0','0','45000.0','03:27 pm','30 Dec 2023','30 Dec 2023','202312301527','20231230','45000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(110,'Ajmal','9876543210','1kg Aloo','50','35','1750.0','','1750.0','0','0','0','0','1750.0','04:30 pm','30 Dec 2023','30 Dec 2023','202312301630','20231230','1750','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(111,'Ajmal','9876543210','idly','25','9','225.0','','225.0','0','0','0','0','225.0','11:20 am','08 Jan 2024','08 Jan 2024','202401081120','20240108','225','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(112,'Ajmal','9876543210','idly','13','9','117.0','','117.0','0','0','0','0','117.0','12:32 pm','17 Jan 2024','17 Jan 2024','202401171232','20240117','117','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(113,'Ajmal','9876543210','Burgers ','50','30','1500.0','','1500.0','0','0','0','0','1500.0','04:32 pm','18 Jan 2024','18 Jan 2024','202401181632','20240118','0','1500.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(114,'Ajmal','9876543210','idly','20','10','200.0','','200.0','0','0','0','0','200.0','07:18 pm','19 Jan 2024','19 Jan 2024','202401191918','20240119','200','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(115,'Ajmal','9876543210','dosa','50','10','500.0','','500.0','0','0','0','0','500.0','07:41 pm','19 Jan 2024','19 Jan 2024','202401191941','20240119','500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(116,'Ajmal','9876543210','idly','50','10','500.0','','500.0','0','0','0','0','500.0','09:34 pm','28 Jan 2024','28 Jan 2024','202401282134','20240128','500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(117,'Ajmal','9876543210','butterscotch cake','20','40','800.0','','800.0','0','0','0','0','800.0','01:05 pm','07 Feb 2024','07 Feb 2024','202402071305','20240207','800','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(118,'Ajmal','9876543210','idly','13','10','130.0','','130.0','0','0','0','0','130.0','10:30 am','09 Feb 2024','09 Feb 2024','202402091030','20240209','130','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(119,'Ajmal','9876543210','idly','22','10','220.0','','220.0','0','0','0','0','220.0','04:15 pm','10 Feb 2024','10 Feb 2024','202402101615','20240210','220','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(120,'Ajmal','9876543210','xyz','50','110','5500.0','','5500.0','0','0','0','0','5500.0','09:01 pm','13 Feb 2024','13 Feb 2024','202402132101','20240213','5500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(121,'Ajmal','9876543210','grape juice','25','24','600.0','','600.0','0','0','0','0','600.0','04:53 pm','23 Feb 2024','23 Feb 2024','202402231653','20240223','600','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(122,'Ajmal','9876543210','vanilla icecream','28','40','1120.0','','1120.0','0','0','0','0','1120.0','04:49 pm','24 Feb 2024','24 Feb 2024','202402241649','20240224','0','1120.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(123,'Ajmal','9876543210','idly','20','10','200.0','','200.0','0','0','0','0','200.0','05:10 pm','24 Feb 2024','24 Feb 2024','202402241710','20240224','200','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(124,'Ajmal','9876543210','idly','50','10','500.0','','500.0','0','0','0','0','500.0','05:26 pm','25 Feb 2024','25 Feb 2024','202402251726','20240225','500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(125,'Ajmal','9876543210','idly','12','10','120.0','','120.0','0','0','0','0','120.0','04:36 pm','03 Mar 2024','03 Mar 2024','202403031636','20240303','0','120.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(126,'Ajmal','9876543210','idly','20','10','200.0','','200.0','0','0','0','0','200.0','02:59 pm','13 Mar 2024','13 Mar 2024','202403131459','20240313','200','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(127,'Ajmal','9876543210','idly','14','10','140.0','','140.0','0','0','0','0','140.0','11:21 am','30 Mar 2024','30 Mar 2024','202403301121','20240330','140','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(128,'Ajmal','9876543210','idly','20','10','200.0','','200.0','0','0','0','0','200.0','02:01 pm','12 Apr 2024','12 Apr 2024','202404121401','20240412','','200.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(129,'Ajmal','9876543210','Boys uniform H','50','250','12500.0','','12500.0','0','0','0','0','12500.0','12:53 pm','13 Apr 2024','13 Apr 2024','202404131253','20240413','0','12500.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(130,'Ajmal','9876543210','Boys uniform H','20','250','5000.0','','5000.0','0','0','0','0','5000.0','12:55 pm','13 Apr 2024','13 Apr 2024','202404131255','20240413','2500','2500.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(131,'Ajmal','9876543210','Boys uniform H','31','250','7750.0','','7750.0','0','0','0','0','7750.0','12:56 pm','13 Apr 2024','13 Apr 2024','202404131256','20240413','0','7750.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(132,'Ajmal','9876543210','idly','50','10','500.0','','500.0','0','0','0','0','500.0','01:32 pm','14 Apr 2024','14 Apr 2024','202404141332','20240414','500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(133,'Ajmal','9876543210','Sugar 1kg','50','45','2250.0','','2250.0','0','0','0','0','2250.0','08:09 pm','14 Apr 2024','14 Apr 2024','202404142009','20240414','2000','250.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(134,'Ajmal','9876543210','dosa','50','10','500.0','','500.0','0','0','0','0','500.0','03:58 pm','15 Apr 2024','15 Apr 2024','202404151558','20240415','500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(135,'Ajmal','9876543210','idly','20','10','200.0','','200.0','0','0','0','0','200.0','11:26 am','26 Apr 2024','26 Apr 2024','202404261126','20240426','150','50.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(136,'Ajmal','9876543210','idly','50','10','500.0','','500.0','0','0','0','0','500.0','09:15 pm','30 Apr 2024','30 Apr 2024','202404302115','20240430','500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(137,'Ajmal','9876543210','Xyz ','50','40','2000.0','','2000.0','0','0','0','0','2000.0','09:25 pm','30 Apr 2024','30 Apr 2024','202404302125','20240430','2000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(138,'Ajmal','9876543210','idly','50','10','500.0','','500.0','0','0','0','0','500.0','01:33 pm','13 May 2024','13 May 2024','202405131333','20240513','500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(139,'Ajmal','9876543210','xyz ','100','30','3000.0','','3000.0','0','0','0','0','3000.0','01:53 pm','13 May 2024','13 May 2024','202405131353','20240513','2500','500.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(140,'Ajmal','9876543210','Sugar 1kg','100','45','4500.0','','4500.0','0','0','0','0','4500.0','05:31 pm','28 May 2024','28 May 2024','202405281731','20240528','4500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(141,'Ajmal','9876543210','Quick bill','100','50','5000.0','','5000.0','0','0','0','0','5000.0','11:10 am','04 Jun 2024','04 Jun 2024','202406041110','20240604','5000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(142,'Ajmal','9876543210','idly','20','10','200.0','','700.0','0','0','0','0','700.0','12:40 pm','04 Jun 2024','04 Jun 2024','202406041240','20240604','0','700.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(143,'Ajmal','9876543210','dosa','50','10','500.0','','700.0','0','0','0','0','700.0','12:40 pm','04 Jun 2024','04 Jun 2024','202406041240','20240604','0','700.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(144,'Ajmal','9876543210','Luminus ','100','4000','400000.0','','400000.0','0','0','0','0','400000.0','03:22 pm','09 Jun 2024','09 Jun 2024','202406091522','20240609','200000','200000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(145,'Ajmal','9876543210','idly','30','250','7500.0','','7500.0','0','0','0','0','7500.0','10:55 am','11 Jun 2024','11 Jun 2024','202406111055','20240611','4800','2700.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(146,'Ajmal','9876543210','idly','20','250','5000.0','','5200.0','0','0','0','0','5200.0','05:01 pm','03 Jul 2024','03 Jul 2024','202407031701','20240703','5200','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(147,'Ajmal','9876543210','dosa','20','10','200.0','','5200.0','0','0','0','0','5200.0','05:01 pm','03 Jul 2024','03 Jul 2024','202407031701','20240703','5200','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(148,'Ajmal','9876543210','Xyz','50','150','7500.0','','7500.0','0','0','0','0','7500.0','06:29 pm','19 Jul 2024','19 Jul 2024','202407191829','20240719','7500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(149,'Ajmal','9876543210','idly','50','250','12500.0','','12500.0','0','0','0','0','12500.0','12:59 pm','31 Jul 2024','31 Jul 2024','202407311259','20240731','10000','2500.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(150,'Ajmal','9876543210','butterscotch cake','50','40','2000.0','','2000.0','0','0','0','0','2000.0','05:38 pm','02 Aug 2024','02 Aug 2024','202408021738','20240802','2000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(151,'Ajmal','9876543210','idly','20','250','5000.0','','5000.0','0','0','0','0','5000.0','05:52 pm','02 Aug 2024','02 Aug 2024','202408021752','20240802','','5000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(152,'Ajmal','9876543210','butterscotch icecream','50','20','1000.0','','1000.0','0','0','0','0','1000.0','11:15 am','03 Aug 2024','03 Aug 2024','202408031115','20240803','1000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(153,'Ajmal','9876543210','idly','50','250','12500.0','','12500.0','0','0','0','0','12500.0','02:20 pm','08 Aug 2024','08 Aug 2024','202408081420','20240808','12500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(154,'Ajmal','9876543210','pongal','20','10','200.0','','200.0','0','0','0','0','200.0','11:51 am','19 Aug 2024','19 Aug 2024','202408191151','20240819','200','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(155,'Ajmal','9876543210','Sugar 1kg','50','45','2250.0','','2250.0','0','0','0','0','2250.0','02:40 pm','18 Sep 2024','18 Sep 2024','202409181440','20240918','2250','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(156,'Ajmal','9876543210','idly','50','250','12500.0','','12500.0','0','0','0','0','12500.0','09:21 pm','01 Oct 2024','01 Oct 2024','202410012121','20241001','12500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `vendor_temp_list` (`_id`, `vendor_name`, `vend_phon`, `vend_email`, `vend_gst`, `vend_address`, `vend_total_bill_amount`, `paid`, `pending`, `bill_no`) VALUES (27,'Ajmal','1231567893','','','','8290.0','4000.0','4290.0','9'),(28,'Warehouse','9879653421','','','','1875.0','0.0','1875.0','2'),(29,'Ajmal','1231567893','','','','8290.0','4600.0','3690.0','9'),(30,'Warehouse','9879653421','','','','1875.0','0.0','1875.0','2'),(31,'Ajmal','9876543210','','','','0.0','0.0','0.0','0'),(32,'Ajmal','9876543210','','','','500.0','500.0','0.0','1'),(33,'Ajmal','9876543210','','','','500.0','500.0','0.0','1'),(34,'Janasya','4523987996','','','','0.0','0.0','0.0','0'),(35,'Ajmal','9876543210','','','','29520.0','29520.0','0.0','5'),(36,'Janasya','4523987996','','','','17980.0','17980.0','0.0','1'),(37,'Ajmal','9876543210','','','','29520.0','29520.0','0.0','5'),(38,'Janasya','4523987996','','','','17980.0','17980.0','0.0','1');
INSERT INTO `vendor_temp_list_ingredient` (`_id`, `vendor_name`, `vend_phon`, `vend_email`, `vend_gst`, `vend_address`, `vend_total_bill_amount`, `paid`, `pending`, `bill_no`) VALUES (1,'Ajmal','1234567890','','','','0.0','0.0','0.0','0');
INSERT INTO `version_control` (`_id`, `version`) VALUES (1,'12');
INSERT INTO `weighing_scale_status` (`_id`, `Weighing_Scale_onoff`) VALUES (1,'Not Connected');
INSERT INTO `working_hours` (`_id`, `opening`, `opening_time`, `closing`, `closing_time`, `opening_time_system`, `closing_time_system`) VALUES (1,'Today','12:01 AM','Today','11:59 PM','00:01','23:59');
