(26,'roti',15.00,137,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','RO','',NULL,NULL,422,'0','0','472','',NULL,'30','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'rice',30.00,135,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','RI','',NULL,NULL,429,'0','0','528','',NULL,'24','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'paneer butter masala',60.00,40,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','PA','',NULL,NULL,0,'0','0','2','',NULL,'10','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'chicken sukka',80.00,34,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','CH','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'dhal fry',30.00,29,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','DH','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'vanilla icecream',35.00,239,'Desserts','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','VA','',NULL,NULL,0,'0','0','199','',NULL,'27','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,'butterscotch icecream',40.00,41,'Desserts','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','BU','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'butterscotch cake',18.00,750,'Desserts','','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','10','bu','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'channa',25.00,2,'Snacks','None','','0','0',NULL,NULL,NULL,'no','%','0','CH','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',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,'Peking Duck',3.84,21,'Snacks','Demo(12%)','','0','0',NULL,NULL,NULL,'no','%','5','PE','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','12.00','null','null','null','null','null','null','null','null','','','Regular','3.84','Pesto Veggie','62',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(46,'samsa',20.00,20,'None','None','','0','0',NULL,NULL,NULL,'no','%','0','SA','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',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,'Biryani Item',20.00,144,'Snacks','','','0',NULL,NULL,NULL,NULL,'no','%','9','BI','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(48,'Paneer Tikka Item',19.00,189,'Chinese','','','0',NULL,NULL,NULL,NULL,'no','%','0','PA','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(50,'General Tso s Chicken',53.30,30,'Snacks','','','0','0',NULL,NULL,NULL,'no','%','10','GE','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',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,'Palak Paneer',40.22,30,'Snacks','','','0','0',NULL,NULL,NULL,'no','%','10','PA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','Regular','40.22','Four Cheese','53',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(56,'Puttu',58.17,30,'Snacks','','','0','0',NULL,NULL,NULL,'no','%','5','PU','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','Regular','58.17','BBQ Chicken','57',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(57,'Vada',15.60,30,'Snacks','','','0','0',NULL,NULL,NULL,'no','%','7','VA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','Regular','15.6','Supreme','42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(58,'Mushroom Curry',9.43,30,'Snacks','','','0','0',NULL,NULL,NULL,'no','%','9','MU','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','Regular','9.43','Seafood Special','69',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(61,'Mushroom Curryu',47.90,28,'Desserts','','','0','0',NULL,NULL,NULL,'no','%','10','MU','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','Regular','47.9','Peri Peri','44',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(62,'Szechuan Shrimpy',94.27,28,'Snacks','Demo(12%)','','0','0',NULL,NULL,NULL,'no','%','7','SZ','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','12',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','Regular','94.27','Cheese Burst','60',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(65,'Uttapam',63.34,27,'Snacks','','','0','0',NULL,NULL,NULL,'no','%','9','UT','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','Regular','63.34','Sicilian','31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(66,'Dosa',55.09,29,'Snacks','','','0','0',NULL,NULL,NULL,'no','%','8','DO','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','null','null','null','null','null','null','null','null','','','Regular','55.09','Eggplant Delight','57',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(67,'Idli',23.00,827,'Snacks','Demo(12%)','','0','0',NULL,NULL,NULL,'yes','%','1','Id','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','12','','','','','','','','','','','Regular','42.71','Chicken Tikka','79','','','','','','',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,'idly','10.0','10.0','10.0','22.0','220.0','',''),(2,'dosa','26.1','26.0','35.0','2294.0','59824.0','',''),(3,'pongal','26.8','20.0','27.0','1190.0','31920.0','',''),(4,'upma','25.0','25.0','25.0','2312.0','57800.0','',''),(5,'poori','25.0','25.0','25.0','1188.0','29700.0','',''),(6,'masal dosa','27.0','27.0','27.0','1180.0','31860.0','',''),(7,'bread omlette','21.0','21.0','21.0','1199.0','25179.0','',''),(8,'onion dosa','24.0','20.0','24.0','735.0','17632.0','',''),(9,'rava dosa','20.0','20.0','20.0','718.0','14360.0','',''),(10,'uthappam','27.0','27.0','27.0','742.0','20034.0','',''),(11,'vada','22.9','20.0','24.0','1053.0','24072.0','',''),(12,'masal vada','30.0','30.0','30.0','1089.0','32670.0','',''),(13,'samosa','25.0','25.0','25.0','454.0','11350.0','',''),(14,'chicken kabab','29.0','29.0','29.0','464.0','13456.0','',''),(15,'sheekh kabab','25.0','25.0','25.0','502.0','12550.0','',''),(16,'pani puri','23.0','23.0','23.0','523.0','12029.0','',''),(17,'pav bhajji','26.0','26.0','26.0','489.0','12714.0','',''),(18,'veg cutlet','30.0','30.0','30.0','506.0','15180.0','',''),(19,'chicken nuggets','30.0','30.0','30.0','154.0','4620.0','',''),(20,'veg biriyani','21.0','21.0','21.0','525.0','11025.0','',''),(21,'chicken biriyani','30.0','30.0','30.0','532.0','15960.0','',''),(22,'veg thali','28.0','28.0','28.0','538.0','15064.0','',''),(23,'non veg thali','25.0','25.0','25.0','528.0','13200.0','',''),(24,'mutton biriyani','28.5','26.0','30.0','811.0','23138.0','',''),(25,'roti','30.0','30.0','30.0','472.0','14160.0','',''),(26,'rice','24.0','24.0','24.0','528.0','12672.0','',''),(27,'paneer butter masala','10.0','10.0','10.0','2.0','20.0','',''),(28,'lime juice','24.0','24.0','24.0','179.0','4296.0','',''),(29,'vanilla icecream','27.0','27.0','27.0','199.0','5373.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 `logo` (`_id`, `companylogo`) VALUES (1,'[BLOB]');
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 `online_order_form` (`_id`, `date_of_order`, `rest_name`, `rest_addre`, `rest_num`, `rest_emailid`, `gst_no`, `owners_name`, `owners_num`, `owners_email_id`, `zomato_rela_manag_email_id`, `zomato_regi_email_id`, `zomato_order_url`, `menu_timings`, `deli_charg`, `pack_charg`, `gst_any`, `contact_num`, `swiggy_relat_manag_email_id`, `swiggy_order_url`) VALUES (1,'','','','','','','','','','','','','','','','','','','');
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 (1,'2 inch');
INSERT INTO `razorpaymerchantreg` (`_id`, `account`, `account_id`) VALUES (1,'Not_Registered','');
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 `stock_transfer_item_details` (`_id`, `itemname`, `qty_add`, `company`, `from_store`, `from_device`, `to_store`, `to_device`, `from_time`, `from_date`, `datetimee_new_from`) VALUES (1,'idly','2','9677755667dine','chennai','devicechennai',NULL,NULL,'09:49 am','22 Mar 2024','20240322094942'),(2,'idly','1','9677755667dine','chennai','devicechennai',NULL,NULL,'03:06 pm','25 Mar 2024','20240325150642'),(3,'idly','1','9677755667dine','chennai','devicechennai',NULL,NULL,'03:12 pm','25 Mar 2024','20240325151229'),(4,'poori','2','9677755667dine','chennai','devicechennai',NULL,NULL,'03:23 pm','25 Mar 2024','20240325152351'),(5,'pongal','3','9677755667dine','chennai','devicechennai',NULL,NULL,'03:23 pm','25 Mar 2024','20240325152351'),(6,'idly','1','9677755667dine','chennai','devicechennai','store1','device1','10:59 AM','Mar 26, 2024','20240326105948'),(7,'poori','2','9677755667dine','chennai','devicechennai',NULL,NULL,'01:50 pm','29 Mar 2024','20240329135034'),(8,'masal dosa','5','9677755667dine','chennai','devicechennai',NULL,NULL,'01:50 pm','29 Mar 2024','20240329135034'),(9,'poori','4','9677755667dine','chennai','devicechennai',NULL,NULL,'01:52 pm','29 Mar 2024','20240329135239'),(10,'onion dosa','1','9677755667dine','chennai','devicechennai',NULL,NULL,'01:52 pm','29 Mar 2024','20240329135239'),(11,'poori','1','9677755667dine','chennai','devicechennai',NULL,NULL,'03:08 pm','02 Apr 2024','20240402150818'),(12,'pongal','2','9677755667dine','chennai','devicechennai',NULL,NULL,'03:08 pm','02 Apr 2024','20240402150819'),(13,'pongal','2','9677755667dine','chennai','devicechennai',NULL,NULL,'04:57 pm','16 Apr 2024','20240416165755'),(14,'rava dosa','3','9677755667dine','chennai','devicechennai',NULL,NULL,'04:57 pm','16 Apr 2024','20240416165755'),(15,'poori','2','9677755667dine','chennai','devicechennai','store1','device1','01:20 pm','26 Jun 2024','20240626132030'),(16,'veg biriyani','4','9677755667dine','chennai','devicechennai','store1','device2','01:56 pm','26 Jun 2024','20240626135637'),(17,'pav bhajji','2','9677755667dine','chennai','devicechennai','store3','device3','04:19 pm','26 Jun 2024','20240626161956'),(18,'poori','2','9677755667dine','chennai','devicechennai',NULL,NULL,'01:10 pm','11 Jul 2024','20240711131007'),(19,'dosa','2','9677755667dine','chennai','devicechennai','chennai','devicenew2','01:18 pm','11 Jul 2024','20240711131828'),(20,'upma','30','9677755667dine','store1','device1','chennai','devicechennai','01:44 pm','11 Jul 2024','20240711134408'),(21,'pongal','5','9677755667dine','chennai','devicechennai',NULL,NULL,'10:48 am','23 Jul 2024','20240723104814'),(22,'pongal','2','9677755667dine','chennai','devicechennai',NULL,NULL,'11:23 am','25 Jul 2024','20240725112346'),(23,'pongal','2','9677755667dine','chennai','devicechennai','store1','device1','11:23 am','25 Jul 2024','20240725112345'),(24,'bread omlette','3','9677755667dine','chennai','devicechennai','store2','device2','05:49 pm','26 Jul 2024','20240726174929'),(25,'pongal','2','9677755667dine','chennai','devicechennai',NULL,NULL,'02:54 PM','09 Aug 2024','20240809145410'),(26,'masal dosa','3','9677755667dine','chennai','devicechennai',NULL,NULL,'02:54 PM','09 Aug 2024','20240809145410'),(27,'dosa','1','9677755667dine','chennai','devicechennai',NULL,NULL,'02:54 PM','09 Aug 2024','20240809145448'),(28,'bread omlette','5','9677755667dine','chennai','devicechennai',NULL,NULL,'02:54 PM','09 Aug 2024','20240809145448'),(29,'uthappam','2','9677755667dine','chennai','devicechennai',NULL,NULL,'02:56 PM','09 Aug 2024','20240809145603'),(30,'rava dosa','5','9677755667dine','chennai','devicechennai',NULL,NULL,'02:56 PM','09 Aug 2024','20240809145603'),(31,'pongal','4','9677755667dine','chennai','devicechennai',NULL,NULL,'03:00 PM','09 Aug 2024','20240809150047'),(32,'masal dosa','4','9677755667dine','chennai','devicechennai',NULL,NULL,'03:00 PM','09 Aug 2024','20240809150047'),(33,'pongal','3','9677755667dine','chennai','devicechennai',NULL,NULL,'03:05 PM','09 Aug 2024','20240809150512'),(34,'upma','3','9677755667dine','chennai','devicechennai',NULL,NULL,'03:05 PM','09 Aug 2024','20240809150512'),(35,'dosa','2','9677755667dine','chennai','devicechennai','chennai','devicenew2','02:42 pm','13 Aug 2024','20240813144203'),(36,'bread omlette','3','9677755667dine','chennai','devicechennai',NULL,NULL,'03:39 pm','24 Sept 2024','20240924153903'),(37,'masal dosa','2','9677755667dine','chennai','devicechennai',NULL,NULL,'03:39 pm','24 Sept 2024','20240924153904'),(38,'poori','4','9677755667dine','chennai','devicechennai',NULL,NULL,'02:10 pm','11 Nov 2024','20241111141011'),(39,'bread omlette','5','9677755667dine','chennai','devicechennai',NULL,NULL,'02:10 pm','11 Nov 2024','20241111141011'),(40,'masal dosa','2','9677755667dine','chennai','devicechennai',NULL,NULL,'02:26 pm','11 Nov 2024','20241111142613'),(41,'rava dosa','2','9677755667dine','chennai','devicechennai',NULL,NULL,'02:26 pm','11 Nov 2024','20241111142613'),(42,'pongal','1','9677755667dine','chennai','devicechennai',NULL,NULL,'02:39 pm','11 Nov 2024','20241111143923'),(43,'masal dosa','1','9677755667dine','chennai','devicechennai',NULL,NULL,'02:39 pm','11 Nov 2024','20241111143923'),(44,'idly','3','9677755667dine','chennai','devicechennai',NULL,NULL,'02:59 pm','11 Nov 2024','20241111145923'),(45,'masal dosa','3','9677755667dine','chennai','devicechennai',NULL,NULL,'02:59 pm','11 Nov 2024','20241111145924'),(46,'upma','5','9677755667dine','chennai','devicechennai',NULL,NULL,'02:41 pm','12 Nov 2024','20241112144104'),(47,'pongal','5','9677755667dine','chennai','devicechennai',NULL,NULL,'02:41 pm','12 Nov 2024','20241112144105'),(48,'upma','1','9677755667dine','chennai','devicechennai','store2','device2','11:54 AM','Nov 14, 2024','20241114115456'),(49,'vanilla icecream','4','9677755667dine','chennai','devicechennai','chennai','devicenew2','12:46 pm','14 Nov 2024','20241114124653'),(50,'masal dosa','4','9677755667dine','chennai','devicechennai','chennai','devicenew2','10:32 am','18 Dec 2024','20241218103225');
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 `table_kot` (`_id`, `status`) VALUES (1,'Pro');
INSERT INTO `taxes` (`_id`, `taxname`, `value`, `taxtype`, `checked`, `tax1`, `tax2`, `tax3`, `hsn_code`) VALUES (1,'global(8%)',8.00,'Globaltax','checked','Dine-in','Takeaway','Home Delivery',''),(2,'Demo(12%)',12.00,'Itemtax','','Dine-in','Takeaway','Home Delivery','');
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 `variants_temp` (`_id`, `vari1`, `varprice1`, `vari2`, `varprice2`, `vari3`, `varprice3`, `vari4`, `varprice4`, `vari5`, `varprice5`) VALUES (1,'Regular','61.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'Regular Varient ','50',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'ProPack','50',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'Regular','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'ghg','66',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'Regular','87.36',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'Veg Delight','68',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'Regular','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'rrj','55',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'Regular','15.18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(42,'Classic Cheese','40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(51,'Regular','99.51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52,'Garden Fresh','72',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `vendor_details` (`_id`, `vendor_name`, `vendor_phoneno`, `vendor_email`, `vendor_address`, `vendor_gst`) VALUES (1,'KalKI Catering ','9899432362','kalkifood@gmail.com','Coimbatore','GSTIN00037894'),(2,'Madhampatty Coimbatore ','8635321412','madhampattycbe@gmail.com','Coimbatore ','GSTIN008997472'),(3,'Aravindhan D','8300041555','aravindt36@gmail.com','Chennai','GSTIN039838883'),(4,'Karthick','9434006724','bala1189@example.com','Karaikudi','11ABCDE2795F90'),(5,'David','9873624540','babu2487@example.com','Trichy','10ABCDE4645F46'),(6,'Muruganidli','8871725289','muruganidlishopcorner@example.com','Bangalore','60ABCDE1279F03'),(7,'Murugan Idli Shop','9706821482','muruganidlishopcorner@example.com','Bangalore','60ABCDE1279F03'),(8,'Hotel Amma','9454546138','hotelammacafe@example.com','Trichy','58ABCDE7585F96'),(9,'Umar','8355373693','Sriramt3624@gmail.com','Karaikudi','GSTINBNRp299757'),(10,'Murugan Idli Shop','9789491653','muruganidlishopkitchen@mail.com','Coimbatore','44ABCDE1240F84'),(11,'Hotel Akshaya','8387259510','hotelakshayahouse@food.com','Coimbatore','87ABCDE8655F35'),(12,'Madurai Meenakshi Bhavan','9854779884','maduraimeenakshibhavandining@dining.com','Coimbatore','11ABCDE1658F94'),(13,'Hotel Junior Kuppanna','9811117979','hoteljuniorkuppannakitchen@food.com','Trichy','99ABCDE8510F79'),(14,'Murugan Idli Shop','9706821482','muruganidlishopcorner@example.com','Bangalore','60ABCDE1279F03'),(15,'Mohan','9981487277','vijay1970@example.com','Kumbakonam','48ABCDE2639F05'),(16,'Mani','9713089059','john7649@example.com','Tanjore','47ABCDE6294F30'),(17,'Dinesh','8490927021','vasanth9190@example.com','Tanjore','62ABCDE4514F34'),(18,'Kavin','9489244225','bala4266@example.com','Tanjore','70ABCDE8538F09'),(19,'Hotel Tamil Nadu','9931211063','hoteltamilnaducafe@restaurant.com','Salem','76ABCDE4589F88'),(20,'Hotel Supreme','8891198601','hotelsupremecafe@dining.com','Karaikudi','45ABCDE5405F24'),(21,'Ratna Cafe','9955351246','ratnacafecorner@restaurant.com','Tanjore','93ABCDE6409F76');
INSERT INTO `vendor_details_micro` (`_id`, `vendor_name`, `vendor_phoneno`, `vendor_email`, `vendor_address`, `vendor_gst`) VALUES (1,'Vasanth','9826599124','vasanth7698@example.com','Trichy','78ABCDE7613F08'),(2,'Vasanth','9912346158','vijay1998@example.com','Salem','01ABCDE5976F86'),(3,'Mangals','9598974789','mangal098@gmail.com','Chennai','GSTINBNRp299838'),(4,'David','9959205452','bala9166@example.com','Trichy','41ABCDE2406F71'),(5,'Karthick','9896264268','babu1850@example.com','Kumbakonam','90ABCDE5597F75'),(6,'Suriya','9410208044','john9366@example.com','Kodaikanal','01ABCDE0091F19'),(7,'Vignesh','9921871162','dinesh7885@example.com','Chennai','90ABCDE4820F20');
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,'KalKI Catering ','9899432362','Inv001','20.0','0','0','0','0','20.0','10:29 am','27 Mar 2024','27 Mar 2024','202403271029','20240327','500','-480.0','500','27 Mar 2024','10:29 am','202403271029',''),(2,'KalKI Catering ','9899432362','iv001','200.0','0','0','0','0','200.0','10:32 am','27 Mar 2024','27 Mar 2024','202403271032','20240327','0','200.0','0','27 Mar 2024','10:32 am','202403271032',''),(3,'KalKI Catering ','9899432362','00','40.0','0','0','0','0','40.0','10:45 am','17 Apr 2024','17 Apr 2024','202404171045','20240417','200','-160.0','200','17 Apr 2024','10:45 am','202404171045',''),(4,'Madhampatty Coimbatore ','8635321412','','1260.0','0','0','0','0','1260.0','02:58 pm','18 Apr 2024','18 Apr 2024','202404181458','20240418','1260','0.0','1260','18 Apr 2024','02:58 pm','202404181458',''),(5,'KalKI Catering ','9899432362','','58.0','0','0','0','0','58.0','03:22 pm','18 Apr 2024','18 Apr 2024','202404181522','20240418','100','-42.0','100','18 Apr 2024','03:22 pm','202404181522',''),(6,'Madhampatty Coimbatore ','8635321412','INV-01845','363.0','0','0','0','0','363.0','03:39 pm','18 Apr 2024','18 Apr 2024','202404181539','20240418','363.0','0.0','363.0','18 Apr 2024','03:39 pm','202404181539',''),(7,'KalKI Catering ','9899432362','INV-76774','2580.0','0','0','0','0','2580.0','05:20 pm','18 Apr 2024','18 Apr 2024','202404181720','20240418','2580.0','0.0','2580.0','18 Apr 2024','05:20 pm','202404181720',''),(8,'KalKI Catering ','9899432362','','20','0','0','0','0','20','07:16 AM','27 Jun 2024','27 Jun 2024','202406270716','20240627','10','10.0','10','27 Jun 2024','07:16 AM','202406270716',NULL),(9,'Madhampatty Coimbatore ','8635321412','','40','0','0','0','0','40','07:39 AM','27 Jun 2024','27 Jun 2024','202406270739','20240627','40','0.0','40','27 Jun 2024','07:39 AM','202406270739',NULL),(10,'KalKI Catering ','9899432362','','600','0','0','0','0','600','08:25 AM','28 Jun 2024','28 Jun 2024','202406280825','20240628','0','600.0','0','28 Jun 2024','08:25 AM','202406280825',NULL),(11,'Madhampatty Coimbatore ','8635321412','INV20240628152311783','18072','0','0','0','0','18072','09:53 AM','28 Jun 2024','28 Jun 2024','202406280953','20240628','18072','0.0','18072','28 Jun 2024','09:53 AM','202406280953',NULL),(12,'KalKI Catering ','9899432362','INV20240628152817225','31860','0','0','0','0','31860','09:58 AM','28 Jun 2024','28 Jun 2024','202406280958','20240628','31860','0.0','31860','28 Jun 2024','09:58 AM','202406280958',NULL),(13,'KalKI Catering ','9899432362','','600','0','0','0','0','600','08:25 AM','28 Jun 2024','28 Jun 2024','202406280825','20240628','0','600.0','0','02 Jul 2024','4:18 PM','202407021618',NULL),(14,'KalKI Catering ','9899432362','','600','0','0','0','0','600','08:25 AM','28 Jun 2024','28 Jun 2024','202406280825','20240628','0','600.0','0','02 Jul 2024','4:23 PM','202407021623',NULL),(15,'KalKI Catering ','9899432362','iv001','200.0','0','0','0','0','200.0','10:32 am','27 Mar 2024','27 Mar 2024','202403271032','20240327','10','190.0','10.0','03 Jul 2024','10:22 am','202407031022',''),(16,'KalKI Catering ','9899432362','iv001','200.0','0','0','0','0','200.0','10:32 am','27 Mar 2024','27 Mar 2024','202403271032','20240327','10','180.0','20.0','03 Jul 2024','10:22 am','202407031022',''),(17,'Aravindhan D','8300041555','INV_00020240507','700','0','0','0','0','700','04:53 AM','05 Jul 2024','05 Jul 2024','202407050453','20240705','700','0.0','700','05 Jul 2024','04:53 AM','202407050453',NULL),(18,'KalKI Catering ','9899432362','INV20240705103145803','13456','0','0','0','0','13456','05:01 AM','05 Jul 2024','05 Jul 2024','202407050501','20240705','13456','0.0','13456','05 Jul 2024','05:01 AM','202407050501',NULL),(19,'KalKI Catering ','9899432362','INV20240705103543303','6000','0','0','0','0','6000','05:05 AM','05 Jul 2024','05 Jul 2024','202407050505','20240705','6000','0.0','6000','05 Jul 2024','05:05 AM','202407050505',NULL),(20,'Madhampatty Coimbatore ','8635321412','INV20240705103610501','12672','0','0','0','0','12672','05:06 AM','05 Jul 2024','05 Jul 2024','202407050506','20240705','12672','0.0','12672','05 Jul 2024','05:06 AM','202407050506',NULL),(21,'Madhampatty Coimbatore ','8635321412','INV20240705103638914','11025','0','0','0','0','11025','05:06 AM','05 Jul 2024','05 Jul 2024','202407050506','20240705','11025','0.0','11025','05 Jul 2024','05:06 AM','202407050506',NULL),(22,'Karthick','9434006724','INV20240705103705988','32670','0','0','0','0','32670','05:07 AM','05 Jul 2024','05 Jul 2024','202407050507','20240705','32670','0.0','32670','05 Jul 2024','05:07 AM','202407050507',NULL),(23,'Murugan Idli Shop','9706821482','INV20240705103732183','14160','0','0','0','0','14160','05:07 AM','05 Jul 2024','05 Jul 2024','202407050507','20240705','14160','0.0','14160','05 Jul 2024','05:07 AM','202407050507',NULL),(24,'Aravindhan D','8300041555','INV2024070510375951','15064','0','0','0','0','15064','05:08 AM','05 Jul 2024','05 Jul 2024','202407050508','20240705','15064','0.0','15064','05 Jul 2024','05:08 AM','202407050508',NULL),(25,'Hotel Amma','9454546138','INV202407051038257','12714','0','0','0','0','12714','05:08 AM','05 Jul 2024','05 Jul 2024','202407050508','20240705','12714','0.0','12714','05 Jul 2024','05:08 AM','202407050508',NULL),(26,'Aravindhan D','8300041555','INV2024070510385244','30780','0','0','0','0','30780','05:08 AM','05 Jul 2024','05 Jul 2024','202407050508','20240705','30780','0.0','30780','05 Jul 2024','05:08 AM','202407050508',NULL),(27,'David','9873624540','INV20240705103918522','12029','0','0','0','0','12029','05:09 AM','05 Jul 2024','05 Jul 2024','202407050509','20240705','12029','0.0','12029','05 Jul 2024','05:09 AM','202407050509',NULL),(28,'Madhampatty Coimbatore ','8635321412','INV20240705103944621','14360','0','0','0','0','14360','05:09 AM','05 Jul 2024','05 Jul 2024','202407050509','20240705','14360','0.0','14360','05 Jul 2024','05:09 AM','202407050509',NULL),(29,'David','9873624540','INV20240705104316635','29562','0','0','0','0','29562','05:13 AM','05 Jul 2024','05 Jul 2024','202407050513','20240705','29562','0.0','29562','05 Jul 2024','05:13 AM','202407050513',NULL),(30,'Hotel Amma','9454546138','INV20240705104343853','15960','0','0','0','0','15960','05:13 AM','05 Jul 2024','05 Jul 2024','202407050513','20240705','15960','0.0','15960','05 Jul 2024','05:13 AM','202407050513',NULL),(31,'Karthick','9434006724','INV20240705104410762','17592','0','0','0','0','17592','05:14 AM','05 Jul 2024','05 Jul 2024','202407050514','20240705','17592','0.0','17592','05 Jul 2024','05:14 AM','202407050514',NULL),(32,'KalKI Catering ','9899432362','INV2024070510443763','13200','0','0','0','0','13200','05:14 AM','05 Jul 2024','05 Jul 2024','202407050514','20240705','13200','0.0','13200','05 Jul 2024','05:14 AM','202407050514',NULL),(33,'Murugan Idli Shop','9706821482','INV20240705104504162','15180','0','0','0','0','15180','05:15 AM','05 Jul 2024','05 Jul 2024','202407050515','20240705','15180','0.0','15180','05 Jul 2024','05:15 AM','202407050515',NULL),(34,'KalKI Catering ','9899432362','INV20240705104531357','28775','0','0','0','0','28775','05:15 AM','05 Jul 2024','05 Jul 2024','202407050515','20240705','28775','0.0','28775','05 Jul 2024','05:15 AM','202407050515',NULL),(35,'Muruganidli','8871725289','INV20240705104558217','15390','0','0','0','0','15390','05:16 AM','05 Jul 2024','05 Jul 2024','202407050516','20240705','15390','0.0','15390','05 Jul 2024','05:16 AM','202407050516',NULL),(36,'Muruganidli','8871725289','INV20240705104624459','12550','0','0','0','0','12550','05:16 AM','05 Jul 2024','05 Jul 2024','202407050516','20240705','12550','0.0','12550','05 Jul 2024','05:16 AM','202407050516',NULL),(37,'Aravindhan D','8300041555','INV20240705104651793','25179','0','0','0','0','25179','05:16 AM','05 Jul 2024','05 Jul 2024','202407050516','20240705','25179','0.0','25179','05 Jul 2024','05:16 AM','202407050516',NULL),(38,'Madhampatty Coimbatore ','8635321412','INV20240705104717996','29700','0','0','0','0','29700','05:17 AM','05 Jul 2024','05 Jul 2024','202407050517','20240705','29700','0.0','29700','05 Jul 2024','05:17 AM','202407050517',NULL),(39,'Hotel Amma','9454546138','INV20240705105013825','11350','0','0','0','0','11350','05:20 AM','05 Jul 2024','05 Jul 2024','202407050520','20240705','11350','0.0','11350','05 Jul 2024','05:20 AM','202407050520',NULL),(40,'Madhampatty Coimbatore ','8635321412','INV20240705105040763','20034','0','0','0','0','20034','05:20 AM','05 Jul 2024','05 Jul 2024','202407050520','20240705','20034','0.0','20034','05 Jul 2024','05:20 AM','202407050520',NULL),(41,'David','9873624540','inv05322677','29562.0','0','0','0','0','29562.0','05:34 pm','10 Jul 2024','10 Jul 2024','202407101734','20240710','28000','1562.0','28000','10 Jul 2024','05:34 pm','202407101734',''),(42,'KalKI Catering ','9899432362','iv001','200.0','0','0','0','0','200.0','10:32 am','27 Mar 2024','27 Mar 2024','202403271032','20240327','100','80.0','120.0','13 Jul 2024','2:57 PM','202407131457',NULL),(43,'KalKI Catering ','9899432362','iv001','200.0','0','0','0','0','200.0','10:32 am','27 Mar 2024','27 Mar 2024','202403271032','20240327','10','70.0','130.0','13 Jul 2024','3:00 PM','202407131500',NULL),(44,'KalKI Catering ','9899432362','iv001','200.0','0','0','0','0','200.0','10:32 am','27 Mar 2024','27 Mar 2024','202403271032','20240327','50','20.0','180.0','13 Jul 2024','3:00 PM','202407131500',NULL),(45,'KalKI Catering ','9899432362','iv001','200.0','0','0','0','0','200.0','10:32 am','27 Mar 2024','27 Mar 2024','202403271032','20240327','0','20.0','180.0','13 Jul 2024','3:02 PM','202407131502',NULL),(46,'KalKI Catering ','9899432362','iv001','200.0','0','0','0','0','200.0','10:32 am','27 Mar 2024','27 Mar 2024','202403271032','20240327','5','15.0','185.0','16 Jul 2024','1:30 PM','202407161330',NULL),(47,'KalKI Catering ','9899432362','INVO38038538503','20','0','0','0','0','20','12:07 PM','16 Jul 2024','16 Jul 2024','202407161207','20240716','10','10.0','10','16 Jul 2024','12:07 PM','202407161207',NULL),(48,'Hotel Amma','9454546138','INV20240716174737304','5373','0','0','0','0','5373','12:17 PM','16 Jul 2024','16 Jul 2024','202407161217','20240716','5373','0.0','5373','16 Jul 2024','12:17 PM','202407161217',NULL),(49,'David','9873624540','INV20240719163113147','4296','0','0','0','0','4296','11:01 AM','19 Jul 2024','19 Jul 2024','202407191101','20240719','4296','0.0','4296','19 Jul 2024','11:01 AM','202407191101',NULL),(50,'Murugan Idli Shop','9706821482','INV20240719165146722','7748','0','0','0','0','7748','11:21 AM','19 Jul 2024','19 Jul 2024','202407191121','20240719','7748','0.0','7748','19 Jul 2024','11:21 AM','202407191121',NULL),(51,'KalKI Catering ','9899432362','iv001','200.0','0','0','0','0','200.0','10:32 am','27 Mar 2024','27 Mar 2024','202403271032','20240327','5','10.0','190.0','24 Jul 2024','01:01 pm','202407241301',''),(52,'Madhampatty Coimbatore ','8635321412','inv09965678','28775.0','0','0','0','0','28775.0','08:55 am','24 Jul 2024','24 Jul 2024','202407240855','20240724','100','28675.0','100','24 Jul 2024','08:55 am','202407240855',''),(53,'Madhampatty Coimbatore ','8635321412','inv09965678','28775.0','0','0','0','0','28775.0','08:55 am','24 Jul 2024','24 Jul 2024','202407240855','20240724','100','28575.0','200.0','24 Jul 2024','08:56 am','202407240856',''),(54,'Madhampatty Coimbatore ','8635321412','inv09965678','28775.0','0','0','0','0','28775.0','08:55 am','24 Jul 2024','24 Jul 2024','202407240855','20240724','100','28475.0','300.0','24 Jul 2024','08:58 am','202407240858',''),(55,'Madhampatty Coimbatore ','8635321412','inv09965678','28775.0','0','0','0','0','28775.0','08:55 am','24 Jul 2024','24 Jul 2024','202407240855','20240724','0','28475.0','300.0','24 Jul 2024','08:58 am','202407240858',''),(56,'Madhampatty Coimbatore ','8635321412','inv09965678','28775.0','0','0','0','0','28775.0','08:55 am','24 Jul 2024','24 Jul 2024','202407240855','20240724','150','28325.0','450.0','24 Jul 2024','08:59 am','202407240859',''),(57,'KalKI Catering ','9899432362','INVO38038538503','20','0','0','0','0','20','12:07 PM','16 Jul 2024','16 Jul 2024','202407161207','20240716','10','0.0','20.0','24 Jul 2024','09:00 am','202407240900',''),(58,'Madhampatty Coimbatore ','8635321412','','200.0','0','0','0','0','200.0','08:55 am','24 Jul 2024','24 Jul 2024','202407240855','20240724','100','28225.0','550.0','24 Jul 2024','09:02 am','202407240902',''),(59,'Madhampatty Coimbatore ','8635321412','inv123528','200.0','13.0','26.0','5','10.0','216.0','06:56 am','25 Jul 2024','25 Jul 2024','202407250656','20240725','100','116.0','100','25 Jul 2024','06:56 am','202407250656',''),(60,'Hotel Amma','9454546138','INV20240726173759559','4620','0','0','0','0','4620','12:08 PM','26 Jul 2024','26 Jul 2024','202407261208','20240726','4620','0.0','4620','26 Jul 2024','12:08 PM','202407261208',NULL),(61,'KalKI Catering ','9899432362','INV-76774','2580.0','0','0','0','0','2580.0','05:20 pm','18 Apr 2024','18 Apr 2024','202404181720','20240418','0','0.0','2580.0','28 Jul 2024','4:19 PM','202407281619',NULL),(62,'Hotel Amma','9454546138','INV202407051038257','12714','0','0','0','0','12714','05:08 AM','05 Jul 2024','05 Jul 2024','202407050508','20240705','0','0.0','12714','28 Jul 2024','4:21 PM','202407281621',NULL),(63,'Murugan Idli Shop','9789491653','INV-08509','2300.0','0','0','0','0','2300.0','03:41 PM','03 Aug 2024','03 Aug 2024','202408031541','20240803','2300.0','0.0','2300.0','03 Aug 2024','03:41 PM','202408031541',''),(64,'Hotel Akshaya','9678342821','INV-06121','1728.0','0','0','0','0','1728.0','07:54 PM','08 Aug 2024','08 Aug 2024','202408081954','20240808','1728.0','0.0','1728.0','08 Aug 2024','07:54 PM','202408081954',''),(65,'Madurai Meenakshi Bhavan','9854779884','INV-22989','30195.0','0','0','0','0','30195.0','02:36 pm','25 Sept 2024','25 Sept 2024','202409251436','20240925','30195.0','0.0','30195.0','25 Sept 2024','02:36 pm','202409251436',''),(66,'Madhampatty Coimbatore ','8635321412','INV-41092','1596.0','0','0','0','0','1596.0','01:03 PM','10 Oct 2024','10 Oct 2024','202410101303','20241010','1596.0','0.0','1596.0','10 Oct 2024','01:03 PM','202410101303',''),(67,'Murugan Idli Shop','9706821482','INV-62460','9282.0','0','0','0','0','9282.0','03:34 PM','10 Oct 2024','10 Oct 2024','202410101534','20241010','9282.0','0.0','9282.0','10 Oct 2024','03:34 PM','202410101534',''),(68,'Madhampatty Coimbatore ','8635321412','INV-41092','1596.0','0','0','0','0','1596.0','01:03 PM','10 Oct 2024','10 Oct 2024','202410101303','20241010','0','0.0','1596.0','14 Nov 2024','11:50 AM','202411141150',NULL),(69,'David','9873624540','inv05322677','29562.0','0','0','0','0','29562.0','05:34 pm','10 Jul 2024','10 Jul 2024','202407101734','20240710','1562','0.0','29562','14 Nov 2024','12:51 PM','202411141251',NULL);
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 (1,'KalKI Catering ','9899432362','idly','1','20','20.0','Inv001','20.0','0','0','0','0','20.0','10:29 am','27 Mar 2024','27 Mar 2024','202403271029','20240327','500','-480.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),(2,'KalKI Catering ','9899432362','idly','10','20','200.0','iv001','200.0','0','0','0','0','200.0','10:32 am','27 Mar 2024','27 Mar 2024','202403271032','20240327','','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),(3,'KalKI Catering ','9899432362','idly','2','20','40.0','00','40.0','0','0','0','0','40.0','10:45 am','17 Apr 2024','17 Apr 2024','202404171045','20240417','200','-160.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),(4,'Madhampatty Coimbatore ','8635321412','onion dosa','21','60','1260.0','','1260.0','0','0','0','0','1260.0','02:58 pm','18 Apr 2024','18 Apr 2024','202404181458','20240418','1260','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),(5,'KalKI Catering ','9899432362','samosa','1','28','28.0','','58.0','0','0','0','0','58.0','03:22 pm','18 Apr 2024','18 Apr 2024','202404181522','20240418','100','-42.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),(6,'KalKI Catering ','9899432362','pani puri','1','30','30.0','','58.0','0','0','0','0','58.0','03:22 pm','18 Apr 2024','18 Apr 2024','202404181522','20240418','100','-42.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),(7,'Madhampatty Coimbatore ','8635321412','upma','11','33','363.0','INV-01845','363.0','0','0','0','0','363.0','03:39 pm','18 Apr 2024','18 Apr 2024','202404181539','20240418','363.0','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),(8,'KalKI Catering ','9899432362','rava dosa','43','60','2580.0','INV-76774','2580.0','0','0','0','0','2580.0','05:20 pm','18 Apr 2024','18 Apr 2024','202404181720','20240418','2580.0','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),(9,'KalKI Catering ','9899432362','idly','2','10','20','','20','0','0','0','0','20','07:16 AM','27 Jun 2024','27 Jun 2024','202406270716','20240627','10','10.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),(10,'Madhampatty Coimbatore ','8635321412','onion dosa','2','20','40','','40','0','0','0','0','40','07:39 AM','27 Jun 2024','27 Jun 2024','202406270739','20240627','40','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),(11,'KalKI Catering ','9899432362','pongal','30','20','600','','600','0','0','0','0','600','08:25 AM','28 Jun 2024','28 Jun 2024','202406280825','20240628','0','600.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),(12,'Madhampatty Coimbatore ','8635321412','vada','753','24','18072','INV20240628152311783','18072','0','0','0','0','18072','09:53 AM','28 Jun 2024','28 Jun 2024','202406280953','20240628','18072','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,'KalKI Catering ','9899432362','masal dosa','1180','27','31860','INV20240628152817225','31860','0','0','0','0','31860','09:58 AM','28 Jun 2024','28 Jun 2024','202406280958','20240628','31860','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,'Aravindhan D','8300041555','dosa','20','35','700','INV_00020240507','700','0','0','0','0','700','04:53 AM','05 Jul 2024','05 Jul 2024','202407050453','20240705','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),(15,'KalKI Catering ','9899432362','chicken kabab','464','29','13456','INV20240705103145803','13456','0','0','0','0','13456','05:01 AM','05 Jul 2024','05 Jul 2024','202407050501','20240705','13456','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,'KalKI Catering ','9899432362','vada','300','20','6000','INV20240705103543303','6000','0','0','0','0','6000','05:05 AM','05 Jul 2024','05 Jul 2024','202407050505','20240705','6000','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,'Madhampatty Coimbatore ','8635321412','rice','528','24','12672','INV20240705103610501','12672','0','0','0','0','12672','05:06 AM','05 Jul 2024','05 Jul 2024','202407050506','20240705','12672','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,'Madhampatty Coimbatore ','8635321412','veg biriyani','525','21','11025','INV20240705103638914','11025','0','0','0','0','11025','05:06 AM','05 Jul 2024','05 Jul 2024','202407050506','20240705','11025','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,'Karthick','9434006724','masal vada','1089','30','32670','INV20240705103705988','32670','0','0','0','0','32670','05:07 AM','05 Jul 2024','05 Jul 2024','202407050507','20240705','32670','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),(20,'Murugan Idli Shop','9706821482','roti','472','30','14160','INV20240705103732183','14160','0','0','0','0','14160','05:07 AM','05 Jul 2024','05 Jul 2024','202407050507','20240705','14160','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),(21,'Aravindhan D','8300041555','veg thali','538','28','15064','INV2024070510375951','15064','0','0','0','0','15064','05:08 AM','05 Jul 2024','05 Jul 2024','202407050508','20240705','15064','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,'Hotel Amma','9454546138','pav bhajji','489','26','12714','INV202407051038257','12714','0','0','0','0','12714','05:08 AM','05 Jul 2024','05 Jul 2024','202407050508','20240705','12714','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),(23,'Aravindhan D','8300041555','pongal','1140','27','30780','INV2024070510385244','30780','0','0','0','0','30780','05:09 AM','05 Jul 2024','05 Jul 2024','202407050509','20240705','30780','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,'David','9873624540','pani puri','523','23','12029','INV20240705103918522','12029','0','0','0','0','12029','05:09 AM','05 Jul 2024','05 Jul 2024','202407050509','20240705','12029','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,'Madhampatty Coimbatore ','8635321412','rava dosa','718','20','14360','INV20240705103944621','14360','0','0','0','0','14360','05:09 AM','05 Jul 2024','05 Jul 2024','202407050509','20240705','14360','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,'David','9873624540','dosa','1137','26','29562','INV20240705104316635','29562','0','0','0','0','29562','05:13 AM','05 Jul 2024','05 Jul 2024','202407050513','20240705','29562','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,'Hotel Amma','9454546138','chicken biriyani','532','30','15960','INV20240705104343853','15960','0','0','0','0','15960','05:13 AM','05 Jul 2024','05 Jul 2024','202407050513','20240705','15960','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,'Karthick','9434006724','onion dosa','733','24','17592','INV20240705104410762','17592','0','0','0','0','17592','05:14 AM','05 Jul 2024','05 Jul 2024','202407050514','20240705','17592','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,'KalKI Catering ','9899432362','non veg thali','528','25','13200','INV2024070510443763','13200','0','0','0','0','13200','05:14 AM','05 Jul 2024','05 Jul 2024','202407050514','20240705','13200','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,'Murugan Idli Shop','9706821482','veg cutlet','506','30','15180','INV20240705104504162','15180','0','0','0','0','15180','05:15 AM','05 Jul 2024','05 Jul 2024','202407050515','20240705','15180','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,'KalKI Catering ','9899432362','upma','1151','25','28775','INV20240705104531357','28775','0','0','0','0','28775','05:15 AM','05 Jul 2024','05 Jul 2024','202407050515','20240705','28775','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,'Muruganidli','8871725289','mutton biriyani','513','30','15390','INV20240705104558217','15390','0','0','0','0','15390','05:16 AM','05 Jul 2024','05 Jul 2024','202407050516','20240705','15390','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,'Muruganidli','8871725289','sheekh kabab','502','25','12550','INV20240705104624459','12550','0','0','0','0','12550','05:16 AM','05 Jul 2024','05 Jul 2024','202407050516','20240705','12550','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,'Aravindhan D','8300041555','bread omlette','1199','21','25179','INV20240705104651793','25179','0','0','0','0','25179','05:16 AM','05 Jul 2024','05 Jul 2024','202407050516','20240705','25179','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,'Madhampatty Coimbatore ','8635321412','poori','1188','25','29700','INV20240705104717996','29700','0','0','0','0','29700','05:17 AM','05 Jul 2024','05 Jul 2024','202407050517','20240705','29700','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,'Hotel Amma','9454546138','samosa','454','25','11350','INV20240705105013825','11350','0','0','0','0','11350','05:20 AM','05 Jul 2024','05 Jul 2024','202407050520','20240705','11350','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,'Madhampatty Coimbatore ','8635321412','uthappam','742','27','20034','INV20240705105040763','20034','0','0','0','0','20034','05:20 AM','05 Jul 2024','05 Jul 2024','202407050520','20240705','20034','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),(38,'David','9873624540','dosa','1137','26','29562.0','inv05322677','29562.0','0','0','0','0','29562.0','05:34 pm','10 Jul 2024','10 Jul 2024','202407101734','20240710','28000','1562.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,'KalKI Catering ','9899432362','paneer butter masala','2','10','20','INVO38038538503','20','0','0','0','0','20','12:07 PM','16 Jul 2024','16 Jul 2024','202407161207','20240716','10','10.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,'Hotel Amma','9454546138','vanilla icecream','199','27','5373','INV20240716174737304','5373','0','0','0','0','5373','12:17 PM','16 Jul 2024','16 Jul 2024','202407161217','20240716','5373','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),(41,'Madhampatty Coimbatore ','8635321412','upma','10','25','250.0','tt','250.0','0','0','0','0','250.0','05:40 pm','17 Jul 2024','17 Jul 2024','202407171740','20240717','3','247.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,'David','9873624540','lime juice','179','24','4296','INV20240719163113147','4296','0','0','0','0','4296','11:01 AM','19 Jul 2024','19 Jul 2024','202407191101','20240719','4296','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,'Murugan Idli Shop','9706821482','mutton biriyani','298','26','7748','INV20240719165146722','7748','0','0','0','0','7748','11:21 AM','19 Jul 2024','19 Jul 2024','202407191121','20240719','7748','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,'Madhampatty Coimbatore ','8635321412','upma','1151','25','28775.0','inv09965678','28775.0','0','0','0','0','28775.0','08:55 am','24 Jul 2024','24 Jul 2024','202407240855','20240724','100','28675.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,'Madhampatty Coimbatore ','8635321412','idly','20','10','200.0','inv123528','200.0','13.0','26.0','5','10.0','216.0','06:56 am','25 Jul 2024','25 Jul 2024','202407250656','20240725','100','116.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,'Aravindhan D','8300041555','pongal','20','27','540.0','inv99393','540.0','0','0','0','0','540.0','11:32 am','25 Jul 2024','25 Jul 2024','202407251132','20240725','100','440.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,'Hotel Amma','9454546138','chicken nuggets','154','30','4620','INV20240726173759559','4620','0','0','0','0','4620','12:08 PM','26 Jul 2024','26 Jul 2024','202407261208','20240726','4620','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),(48,'Murugan Idli Shop','9789491653','masal dosa','92','25','2300.0','INV-08509','2300.0','0','0','0','0','2300.0','03:41 PM','03 Aug 2024','03 Aug 2024','202408031541','20240803','2300.0','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),(49,'Hotel Akshaya','9678342821','rava dosa','32','54','1728.0','INV-06121','1728.0','0','0','0','0','1728.0','07:54 PM','08 Aug 2024','08 Aug 2024','202408081954','20240808','1728.0','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),(50,'Madurai Meenakshi Bhavan','9854779884','dosa','549','55','30195.0','INV-22989','30195.0','0','0','0','0','30195.0','02:36 pm','25 Sept 2024','25 Sept 2024','202409251436','20240925','30195.0','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,'Madhampatty Coimbatore ','8635321412','masal dosa','42','38','1596.0','INV-41092','1596.0','0','0','0','0','1596.0','01:03 PM','10 Oct 2024','10 Oct 2024','202410101303','20241010','1596.0','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,'Murugan Idli Shop','9706821482','dosa','357','26','9282.0','INV-62460','9282.0','0','0','0','0','9282.0','03:34 PM','10 Oct 2024','10 Oct 2024','202410101534','20241010','9282.0','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,'KalKI Catering ','9899432362','upma','53','49','2597.0','INV-65352','2597.0','0','0','0','0','2597.0','02:19 pm','11 Nov 2024','11 Nov 2024','202411111419','20241111','2597.0','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 (160,'KalKI Catering ','9899432362','kalkifood@gmail.com','GSTIN00037894','Coimbatore','87626.0','96891.0','-9265.0','13'),(161,'Madhampatty Coimbatore ','8635321412','madhampattycbe@gmail.com','GSTIN008997472','Coimbatore ','114477.0','108176.0','6301.0','10'),(162,'Aravindhan D','8300041555','aravindt36@gmail.com','GSTIN039838883','Chennai','31154.0','71723.0','-40569.0','3'),(163,'Karthick','9434006724','bala1189@example.com','11ABCDE2795F90','Karaikudi','50262.0','50262.0','0.0','2'),(164,'David','9873624540','babu2487@example.com','10ABCDE4645F46','Trichy','75449.0','73887.0','1562.0','4'),(165,'Muruganidli','8871725289','muruganidlishopcorner@example.com','60ABCDE1279F03','Bangalore','15390.0','27940.0','-12550.0','1'),(166,'Murugan Idli Shop','9706821482','muruganidlishopcorner@example.com','60ABCDE1279F03','Bangalore','55598.0','37088.0','18510.0','3'),(167,'Hotel Amma','9454546138','hotelammacafe@example.com','58ABCDE7585F96','Trichy','65969.0','50017.0','15952.0','5'),(168,'Umar','8364449252','Sriramt3624@gmail.com','GSTINBNRp299757','Salem','0.0','0.0','0.0','0'),(169,'Murugan Idli Shop','9789491653','muruganidlishopkitchen@mail.com','44ABCDE1240F84','Coimbatore','0.0','0.0','0.0','0'),(170,'Hotel Akshaya','9678342821','hotelakshayahouse@food.com','87ABCDE8655F35','Kumbakonam','0.0','0.0','0.0','0'),(171,'Madurai Meenakshi Bhavan','9854779884','maduraimeenakshibhavandining@dining.com','11ABCDE1658F94','Coimbatore','0.0','0.0','0.0','0'),(172,'Hotel Junior Kuppanna','9811117979','hoteljuniorkuppannakitchen@food.com','99ABCDE8510F79','Trichy','0.0','0.0','0.0','0'),(173,'Murugan Idli Shop','9706821482','muruganidlishopcorner@example.com','60ABCDE1279F03','Bangalore','55598.0','37088.0','18510.0','3'),(188,'KalKI Catering ','9899432362','kalkifood@gmail.com','GSTIN00037894','Coimbatore','87626.0','96891.0','-9265.0','13'),(189,'Madhampatty Coimbatore ','8635321412','madhampattycbe@gmail.com','GSTIN008997472','Coimbatore ','114477.0','108176.0','6301.0','10'),(190,'Aravindhan D','8300041555','aravindt36@gmail.com','GSTIN039838883','Chennai','31154.0','71723.0','-40569.0','3'),(191,'Karthick','9434006724','bala1189@example.com','11ABCDE2795F90','Karaikudi','50262.0','50262.0','0.0','2'),(192,'David','9873624540','babu2487@example.com','10ABCDE4645F46','Trichy','75449.0','73887.0','1562.0','4'),(193,'Muruganidli','8871725289','muruganidlishopcorner@example.com','60ABCDE1279F03','Bangalore','15390.0','27940.0','-12550.0','1'),(194,'Murugan Idli Shop','9706821482','muruganidlishopcorner@example.com','60ABCDE1279F03','Bangalore','55598.0','37088.0','18510.0','3'),(195,'Hotel Amma','9454546138','hotelammacafe@example.com','58ABCDE7585F96','Trichy','65969.0','50017.0','15952.0','5'),(196,'Umar','8364449252','Sriramt3624@gmail.com','GSTINBNRp299757','Salem','0.0','0.0','0.0','0'),(197,'Murugan Idli Shop','9789491653','muruganidlishopkitchen@mail.com','44ABCDE1240F84','Coimbatore','2300.0','2300.0','0.0','1'),(198,'Hotel Akshaya','9678342821','hotelakshayahouse@food.com','87ABCDE8655F35','Kumbakonam','1728.0','1728.0','0.0','1'),(199,'Madurai Meenakshi Bhavan','9854779884','maduraimeenakshibhavandining@dining.com','11ABCDE1658F94','Coimbatore','0.0','0.0','0.0','0'),(200,'Hotel Junior Kuppanna','9811117979','hoteljuniorkuppannakitchen@food.com','99ABCDE8510F79','Trichy','0.0','0.0','0.0','0'),(201,'Murugan Idli Shop','9706821482','muruganidlishopcorner@example.com','60ABCDE1279F03','Bangalore','55598.0','37088.0','18510.0','3'),(202,'Mohan','9981487277','vijay1970@example.com','48ABCDE2639F05','Kumbakonam','0.0','0.0','0.0','0'),(203,'KalKI Catering ','9899432362','kalkifood@gmail.com','GSTIN00037894','Coimbatore','87626.0','96891.0','-9265.0','13'),(204,'Madhampatty Coimbatore ','8635321412','madhampattycbe@gmail.com','GSTIN008997472','Coimbatore ','114477.0','108176.0','6301.0','10'),(205,'Aravindhan D','8300041555','aravindt36@gmail.com','GSTIN039838883','Chennai','31154.0','71723.0','-40569.0','3'),(206,'Karthick','9434006724','bala1189@example.com','11ABCDE2795F90','Karaikudi','50262.0','50262.0','0.0','2'),(207,'David','9873624540','babu2487@example.com','10ABCDE4645F46','Trichy','75449.0','73887.0','1562.0','4'),(208,'Muruganidli','8871725289','muruganidlishopcorner@example.com','60ABCDE1279F03','Bangalore','15390.0','27940.0','-12550.0','1'),(209,'Murugan Idli Shop','9706821482','muruganidlishopcorner@example.com','60ABCDE1279F03','Bangalore','55598.0','37088.0','18510.0','3'),(210,'Hotel Amma','9454546138','hotelammacafe@example.com','58ABCDE7585F96','Trichy','65969.0','50017.0','15952.0','5'),(211,'Umar','8364449252','Sriramt3624@gmail.com','GSTINBNRp299757','Salem','0.0','0.0','0.0','0'),(212,'Murugan Idli Shop','9789491653','muruganidlishopkitchen@mail.com','44ABCDE1240F84','Coimbatore','2300.0','2300.0','0.0','1'),(213,'Hotel Akshaya','9678342821','hotelakshayahouse@food.com','87ABCDE8655F35','Kumbakonam','1728.0','1728.0','0.0','1'),(214,'Madurai Meenakshi Bhavan','9854779884','maduraimeenakshibhavandining@dining.com','11ABCDE1658F94','Coimbatore','30195.0','30195.0','0.0','1'),(215,'Hotel Junior Kuppanna','9811117979','hoteljuniorkuppannakitchen@food.com','99ABCDE8510F79','Trichy','0.0','0.0','0.0','0'),(216,'Murugan Idli Shop','9706821482','muruganidlishopcorner@example.com','60ABCDE1279F03','Bangalore','55598.0','37088.0','18510.0','3'),(217,'Mohan','9981487277','vijay1970@example.com','48ABCDE2639F05','Kumbakonam','0.0','0.0','0.0','0'),(218,'KalKI Catering ','9899432362','kalkifood@gmail.com','GSTIN00037894','Coimbatore','87626.0','96891.0','-9265.0','13'),(219,'Madhampatty Coimbatore ','8635321412','madhampattycbe@gmail.com','GSTIN008997472','Coimbatore ','116073.0','109772.0','6301.0','11'),(220,'Aravindhan D','8300041555','aravindt36@gmail.com','GSTIN039838883','Chennai','31154.0','71723.0','-40569.0','3'),(221,'Karthick','9434006724','bala1189@example.com','11ABCDE2795F90','Karaikudi','50262.0','50262.0','0.0','2'),(222,'David','9873624540','babu2487@example.com','10ABCDE4645F46','Trichy','75449.0','73887.0','1562.0','4'),(223,'Muruganidli','8871725289','muruganidlishopcorner@example.com','60ABCDE1279F03','Bangalore','15390.0','27940.0','-12550.0','1'),(224,'Murugan Idli Shop','9706821482','muruganidlishopcorner@example.com','60ABCDE1279F03','Bangalore','55598.0','37088.0','18510.0','3'),(225,'Hotel Amma','9454546138','hotelammacafe@example.com','58ABCDE7585F96','Trichy','65969.0','50017.0','15952.0','5'),(226,'Umar','8364449252','Sriramt3624@gmail.com','GSTINBNRp299757','Salem','0.0','0.0','0.0','0'),(227,'Murugan Idli Shop','9789491653','muruganidlishopkitchen@mail.com','44ABCDE1240F84','Coimbatore','2300.0','2300.0','0.0','1'),(228,'Hotel Akshaya','9678342821','hotelakshayahouse@food.com','87ABCDE8655F35','Kumbakonam','1728.0','1728.0','0.0','1'),(229,'Madurai Meenakshi Bhavan','9854779884','maduraimeenakshibhavandining@dining.com','11ABCDE1658F94','Coimbatore','30195.0','30195.0','0.0','1'),(230,'Hotel Junior Kuppanna','9811117979','hoteljuniorkuppannakitchen@food.com','99ABCDE8510F79','Trichy','0.0','0.0','0.0','0'),(231,'Murugan Idli Shop','9706821482','muruganidlishopcorner@example.com','60ABCDE1279F03','Bangalore','55598.0','37088.0','18510.0','3'),(232,'Mohan','9981487277','vijay1970@example.com','48ABCDE2639F05','Kumbakonam','0.0','0.0','0.0','0'),(233,'Mani','9713089059','john7649@example.com','47ABCDE6294F30','Tanjore','0.0','0.0','0.0','0'),(234,'KalKI Catering ','9899432362','kalkifood@gmail.com','GSTIN00037894','Coimbatore','87626.0','96891.0','-9265.0','13'),(235,'Madhampatty Coimbatore ','8635321412','madhampattycbe@gmail.com','GSTIN008997472','Coimbatore ','116073.0','109772.0','6301.0','11'),(236,'Aravindhan D','8300041555','aravindt36@gmail.com','GSTIN039838883','Chennai','31154.0','71723.0','-40569.0','3'),(237,'Karthick','9434006724','bala1189@example.com','11ABCDE2795F90','Karaikudi','50262.0','50262.0','0.0','2'),(238,'David','9873624540','babu2487@example.com','10ABCDE4645F46','Trichy','75449.0','73887.0','1562.0','4'),(239,'Muruganidli','8871725289','muruganidlishopcorner@example.com','60ABCDE1279F03','Bangalore','15390.0','27940.0','-12550.0','1'),(240,'Murugan Idli Shop','9706821482','muruganidlishopcorner@example.com','60ABCDE1279F03','Bangalore','64880.0','46370.0','18510.0','4'),(241,'Hotel Amma','9454546138','hotelammacafe@example.com','58ABCDE7585F96','Trichy','65969.0','50017.0','15952.0','5'),(242,'Umar','8364449252','Sriramt3624@gmail.com','GSTINBNRp299757','Salem','0.0','0.0','0.0','0'),(243,'Murugan Idli Shop','9789491653','muruganidlishopkitchen@mail.com','44ABCDE1240F84','Coimbatore','2300.0','2300.0','0.0','1'),(244,'Hotel Akshaya','9678342821','hotelakshayahouse@food.com','87ABCDE8655F35','Kumbakonam','1728.0','1728.0','0.0','1'),(245,'Madurai Meenakshi Bhavan','9854779884','maduraimeenakshibhavandining@dining.com','11ABCDE1658F94','Coimbatore','30195.0','30195.0','0.0','1'),(246,'Hotel Junior Kuppanna','9811117979','hoteljuniorkuppannakitchen@food.com','99ABCDE8510F79','Trichy','0.0','0.0','0.0','0'),(247,'Murugan Idli Shop','9706821482','muruganidlishopcorner@example.com','60ABCDE1279F03','Bangalore','64880.0','46370.0','18510.0','4'),(248,'Mohan','9981487277','vijay1970@example.com','48ABCDE2639F05','Kumbakonam','0.0','0.0','0.0','0'),(249,'Mani','9713089059','john7649@example.com','47ABCDE6294F30','Tanjore','0.0','0.0','0.0','0'),(250,'KalKI Catering ','9899432362','kalkifood@gmail.com','GSTIN00037894','Coimbatore','87626.0','96891.0','-9265.0','13'),(251,'Madhampatty Coimbatore ','8635321412','madhampattycbe@gmail.com','GSTIN008997472','Coimbatore ','116073.0','109772.0','6301.0','11'),(252,'Aravindhan D','8300041555','aravindt36@gmail.com','GSTIN039838883','Chennai','31154.0','71723.0','-40569.0','3'),(253,'Karthick','9434006724','bala1189@example.com','11ABCDE2795F90','Karaikudi','50262.0','50262.0','0.0','2'),(254,'David','9873624540','babu2487@example.com','10ABCDE4645F46','Trichy','75449.0','73887.0','1562.0','4'),(255,'Muruganidli','8871725289','muruganidlishopcorner@example.com','60ABCDE1279F03','Bangalore','15390.0','27940.0','-12550.0','1'),(256,'Murugan Idli Shop','9706821482','muruganidlishopcorner@example.com','60ABCDE1279F03','Bangalore','64880.0','46370.0','18510.0','4'),(257,'Hotel Amma','9454546138','hotelammacafe@example.com','58ABCDE7585F96','Trichy','65969.0','50017.0','15952.0','5'),(258,'Umar','8364449252','Sriramt3624@gmail.com','GSTINBNRp299757','Salem','0.0','0.0','0.0','0'),(259,'Murugan Idli Shop','9789491653','muruganidlishopkitchen@mail.com','44ABCDE1240F84','Coimbatore','2300.0','2300.0','0.0','1'),(260,'Hotel Akshaya','9678342821','hotelakshayahouse@food.com','87ABCDE8655F35','Kumbakonam','1728.0','1728.0','0.0','1'),(261,'Madurai Meenakshi Bhavan','9854779884','maduraimeenakshibhavandining@dining.com','11ABCDE1658F94','Coimbatore','30195.0','30195.0','0.0','1'),(262,'Hotel Junior Kuppanna','9811117979','hoteljuniorkuppannakitchen@food.com','99ABCDE8510F79','Trichy','0.0','0.0','0.0','0'),(263,'Murugan Idli Shop','9706821482','muruganidlishopcorner@example.com','60ABCDE1279F03','Bangalore','64880.0','46370.0','18510.0','4'),(264,'Mohan','9981487277','vijay1970@example.com','48ABCDE2639F05','Kumbakonam','0.0','0.0','0.0','0'),(265,'Mani','9713089059','john7649@example.com','47ABCDE6294F30','Tanjore','0.0','0.0','0.0','0'),(266,'Dinesh','8490927021','vasanth9190@example.com','62ABCDE4514F34','Tanjore','0.0','0.0','0.0','0'),(267,'Aravindhan D','8300041555','aravindt36@gmail.com','GSTIN039838883','Chennai','31154.0','71723.0','-40569.0','3'),(268,'Karthick','9434006724','bala1189@example.com','11ABCDE2795F90','Karaikudi','50262.0','50262.0','0.0','2'),(269,'David','9873624540','babu2487@example.com','10ABCDE4645F46','Trichy','75449.0','73887.0','1562.0','4'),(270,'Muruganidli','8871725289','muruganidlishopcorner@example.com','60ABCDE1279F03','Bangalore','15390.0','27940.0','-12550.0','1'),(271,'Murugan Idli Shop','9706821482','muruganidlishopcorner@example.com','60ABCDE1279F03','Bangalore','55598.0','37088.0','18510.0','3'),(272,'Hotel Amma','9454546138','hotelammacafe@example.com','58ABCDE7585F96','Trichy','65969.0','50017.0','15952.0','5'),(273,'Umar','8364449252','Sriramt3624@gmail.com','GSTINBNRp299757','Salem','0.0','0.0','0.0','0'),(274,'Murugan Idli Shop','9789491653','muruganidlishopkitchen@mail.com','44ABCDE1240F84','Coimbatore','2300.0','2300.0','0.0','1'),(275,'Hotel Akshaya','9678342821','hotelakshayahouse@food.com','87ABCDE8655F35','Kumbakonam','1728.0','1728.0','0.0','1'),(276,'Madurai Meenakshi Bhavan','9854779884','maduraimeenakshibhavandining@dining.com','11ABCDE1658F94','Coimbatore','30195.0','30195.0','0.0','1'),(277,'Hotel Junior Kuppanna','9811117979','hoteljuniorkuppannakitchen@food.com','99ABCDE8510F79','Trichy','0.0','0.0','0.0','0'),(278,'Murugan Idli Shop','9706821482','muruganidlishopcorner@example.com','60ABCDE1279F03','Bangalore','55598.0','37088.0','18510.0','3'),(279,'Mohan','9981487277','vijay1970@example.com','48ABCDE2639F05','Kumbakonam','0.0','0.0','0.0','0'),(280,'John','9911499805','dinesh2444@example.com','73ABCDE1550F05','Trichy','0.0','0.0','0.0','0'),(281,'Gopal','9708553183','john5054@example.com','67ABCDE9247F09','Bangalore','0.0','0.0','0.0','0'),(299,'KalKI Catering ','9899432362','kalkifood@gmail.com','GSTIN00037894','Coimbatore','90223.0','99488.0','-9265.0','14'),(300,'Madhampatty Coimbatore ','8635321412','madhampattycbe@gmail.com','GSTIN008997472','Coimbatore ','114477.0','108176.0','6301.0','10'),(301,'Aravindhan D','8300041555','aravindt36@gmail.com','GSTIN039838883','Chennai','31154.0','71723.0','-40569.0','3'),(302,'Karthick','9434006724','bala1189@example.com','11ABCDE2795F90','Karaikudi','50262.0','50262.0','0.0','2'),(303,'David','9873624540','babu2487@example.com','10ABCDE4645F46','Trichy','75449.0','73887.0','1562.0','4'),(304,'Muruganidli','8871725289','muruganidlishopcorner@example.com','60ABCDE1279F03','Bangalore','15390.0','27940.0','-12550.0','1'),(305,'Murugan Idli Shop','9706821482','muruganidlishopcorner@example.com','60ABCDE1279F03','Bangalore','55598.0','37088.0','18510.0','3'),(306,'Hotel Amma','9454546138','hotelammacafe@example.com','58ABCDE7585F96','Trichy','65969.0','50017.0','15952.0','5'),(307,'Umar','8364449252','Sriramt3624@gmail.com','GSTINBNRp299757','Salem','0.0','0.0','0.0','0'),(308,'Murugan Idli Shop','9789491653','muruganidlishopkitchen@mail.com','44ABCDE1240F84','Coimbatore','2300.0','2300.0','0.0','1'),(309,'Hotel Akshaya','9678342821','hotelakshayahouse@food.com','87ABCDE8655F35','Kumbakonam','1728.0','1728.0','0.0','1'),(310,'Madurai Meenakshi Bhavan','9854779884','maduraimeenakshibhavandining@dining.com','11ABCDE1658F94','Coimbatore','30195.0','30195.0','0.0','1'),(311,'Hotel Junior Kuppanna','9811117979','hoteljuniorkuppannakitchen@food.com','99ABCDE8510F79','Trichy','0.0','0.0','0.0','0'),(312,'Murugan Idli Shop','9706821482','muruganidlishopcorner@example.com','60ABCDE1279F03','Bangalore','55598.0','37088.0','18510.0','3'),(313,'Mohan','9981487277','vijay1970@example.com','48ABCDE2639F05','Kumbakonam','0.0','0.0','0.0','0'),(314,'John','9911499805','dinesh2444@example.com','73ABCDE1550F05','Trichy','0.0','0.0','0.0','0'),(315,'Gopal','9708553183','john5054@example.com','67ABCDE9247F09','Bangalore','0.0','0.0','0.0','0'),(316,'Kavin','9489244225','bala4266@example.com','70ABCDE8538F09','Tanjore','0.0','0.0','0.0','0');
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,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','0.0','0.0','0.0','0'),(2,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','0.0','0.0','0.0','0'),(3,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','0.0','100000.0','1'),(4,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','330.0','99670.0','1'),(5,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','330.0','99670.0','1'),(6,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','330.0','99670.0','1'),(7,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','330.0','99670.0','1'),(8,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','330.0','99670.0','1'),(9,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','330.0','99670.0','1'),(10,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','330.0','99670.0','1'),(11,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','330.0','99670.0','1'),(12,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','0'),(13,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','330.0','99670.0','1'),(14,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','0'),(15,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','330.0','99670.0','1'),(16,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','0'),(17,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','330.0','99670.0','1'),(18,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','0'),(19,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','330.0','99670.0','1'),(20,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','0'),(21,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','330.0','99670.0','1'),(22,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','0'),(23,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','330.0','99670.0','1'),(24,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','0'),(25,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','330.0','99670.0','1'),(26,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','0'),(27,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','330.0','99670.0','1'),(28,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','0'),(29,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','330.0','99670.0','1'),(30,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','0'),(31,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','330.0','99670.0','1'),(32,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','0'),(33,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','330.0','99670.0','1'),(34,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','0'),(35,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','330.0','99670.0','1'),(36,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','0'),(37,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','330.0','99670.0','1'),(38,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','0'),(39,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','330.0','99670.0','1'),(40,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','0'),(41,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','330.0','99670.0','1'),(42,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','0'),(43,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','330.0','99670.0','1'),(44,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','0'),(45,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','330.0','99670.0','1'),(46,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','0'),(47,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','330.0','99670.0','1'),(48,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','0'),(49,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','330.0','99670.0','1'),(50,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','0'),(51,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','330.0','99670.0','1'),(52,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','1'),(53,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','330.0','99670.0','1'),(54,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','1'),(55,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','330.0','99670.0','1'),(56,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','1'),(57,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','330.0','99670.0','1'),(58,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','1'),(59,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','550.0','99450.0','1'),(60,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','1'),(61,'Vasanth','8832597744','vijay4653@example.com','88ABCDE7453F85','Salem','0.0','0.0','0.0','0'),(62,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','1'),(63,'Vasanth','8832597744','vijay4653@example.com','88ABCDE7453F85','Salem','0.0','0.0','0.0','0'),(64,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','1'),(65,'Vasanth','8832597744','vijay4653@example.com','88ABCDE7453F85','Salem','43000.0','800.0','42200.0','2'),(66,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','1'),(67,'Vasanth','8832597744','vijay4653@example.com','88ABCDE7453F85','Salem','43000.0','800.0','42200.0','2'),(68,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','1'),(71,'Vasanth','8832597744','vijay4653@example.com','88ABCDE7453F85','Salem','43000.0','800.0','42200.0','2'),(72,'karthi','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','0'),(73,'Vasanth','8832597744','vijay4653@example.com','88ABCDE7453F85','Salem','43000.0','800.0','42200.0','2'),(74,'karthi','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','20000.0','100.0','19900.0','1'),(75,'Vasanth','8832597744','vijay4653@example.com','88ABCDE7453F85','Salem','43000.0','800.0','42200.0','2'),(76,'karthi','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','20000.0','100.0','19900.0','1'),(77,'Vasanth','8832597744','vijay4653@example.com','88ABCDE7453F85','Salem','43000.0','800.0','42200.0','2'),(78,'karthi','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','20000.0','100.0','19900.0','1'),(79,'Vasanth','8832597744','vijay4653@example.com','88ABCDE7453F85','Salem','43000.0','800.0','42200.0','2'),(80,'karthi','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','20000.0','20000.0','0.0','1'),(81,'Vasanth','8832597744','vijay4653@example.com','88ABCDE7453F85','Salem','43000.0','800.0','42200.0','2'),(82,'karthi','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','20000.0','20000.0','0.0','1'),(83,'Vasanth','8832597744','vijay4653@example.com','88ABCDE7453F85','Salem','43400.0','1000.0','42400.0','3'),(84,'karthi','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','20000.0','20000.0','0.0','1'),(85,'Vasanth','8832597744','vijay4653@example.com','88ABCDE7453F85','Salem','43400.0','1000.0','42400.0','3'),(86,'karthi','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','20000.0','20000.0','0.0','1'),(87,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','550.0','99450.0','1'),(88,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','1'),(89,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','550.0','99450.0','1'),(90,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','1'),(91,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','550.0','99450.0','2'),(92,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','1'),(93,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','0.0','0.0','0.0','0'),(94,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','100000.0','550.0','99450.0','2'),(95,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','0.0','0.0','0.0','1'),(96,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','0.0','0.0','0.0','0'),(100,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','105120.0','960.0','104160.0','3'),(101,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','200.0','2700.0','3'),(102,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','0.0','0.0','0.0','0'),(103,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','105120.0','970.0','104150.0','3'),(104,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','200.0','2700.0','3'),(105,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','0.0','0.0','0.0','0'),(106,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','105120.0','970.0','104150.0','3'),(107,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','200.0','2700.0','3'),(108,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','0.0','0.0','0.0','0'),(109,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','105120.0','970.0','104150.0','3'),(110,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','200.0','2700.0','3'),(111,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','0.0','0.0','0.0','0'),(112,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','105120.0','970.0','104150.0','3'),(113,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','200.0','2700.0','3'),(114,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','0.0','0.0','0.0','0'),(115,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','105120.0','970.0','104150.0','3'),(116,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','200.0','2700.0','3'),(117,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','0.0','0.0','0.0','0'),(121,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','105120.0','970.0','104150.0','3'),(122,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','200.0','2700.0','3'),(123,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','0.0','0.0','0.0','0'),(124,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','105120.0','970.0','104150.0','3'),(125,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','200.0','2700.0','3'),(126,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','0.0','0.0','0.0','0'),(127,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','105220.0','980.0','104240.0','4'),(128,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','200.0','2700.0','3'),(129,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','459.0','459.0','0.0','1'),(130,'David','9959205452','bala9166@example.com','41ABCDE2406F71','Trichy','580.0','580.0','0.0','1'),(135,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','105220.0','1070.0','104150.0','4'),(136,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','200.0','2700.0','3'),(137,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','459.0','459.0','0.0','1'),(138,'David','9959205452','bala9166@example.com','41ABCDE2406F71','Trichy','580.0','580.0','0.0','1'),(139,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','105220.0','1090.0','104130.0','4'),(140,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','398.0','2502.0','4'),(141,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','459.0','459.0','0.0','1'),(142,'David','9959205452','bala9166@example.com','41ABCDE2406F71','Trichy','5046.0','752.0','4294.0','2'),(143,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','105220.0','1090.0','104130.0','4'),(144,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','398.0','2502.0','4'),(145,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','459.0','459.0','0.0','1'),(146,'David','9959205452','bala9166@example.com','41ABCDE2406F71','Trichy','5046.0','752.0','4294.0','2'),(147,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','105220.0','1090.0','104130.0','4'),(148,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','398.0','2502.0','4'),(149,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','459.0','459.0','0.0','1'),(150,'David','9959205452','bala9166@example.com','41ABCDE2406F71','Trichy','5046.0','752.0','4294.0','2'),(151,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','105220.0','1090.0','104130.0','4'),(152,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','398.0','2502.0','4'),(153,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','459.0','459.0','0.0','1'),(154,'David','9959205452','bala9166@example.com','41ABCDE2406F71','Trichy','9446.0','912.0','8534.0','3'),(155,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','105220.0','1090.0','104130.0','4'),(156,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','398.0','2502.0','4'),(157,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','459.0','459.0','0.0','1'),(158,'David','9959205452','bala9166@example.com','41ABCDE2406F71','Trichy','9446.0','912.0','8534.0','3'),(159,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','105220.0','1090.0','104130.0','4'),(160,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','398.0','2502.0','4'),(161,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','459.0','459.0','0.0','1'),(162,'David','9959205452','bala9166@example.com','41ABCDE2406F71','Trichy','9446.0','5152.0','4294.0','3'),(163,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','108265.0','1346.0','106919.0','5'),(164,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','1198.0','1702.0','4'),(165,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','459.0','459.0','0.0','1'),(166,'David','9959205452','bala9166@example.com','41ABCDE2406F71','Trichy','9446.0','5152.0','4294.0','3'),(167,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','108265.0','1346.0','106919.0','5'),(168,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','1198.0','1702.0','4'),(169,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','459.0','459.0','0.0','1'),(170,'David','9959205452','bala9166@example.com','41ABCDE2406F71','Trichy','9446.0','5152.0','4294.0','3'),(171,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','108265.0','1346.0','106919.0','5'),(172,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','1198.0','1702.0','4'),(173,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','459.0','459.0','0.0','1'),(174,'David','9959205452','bala9166@example.com','41ABCDE2406F71','Trichy','9446.0','5152.0','4294.0','3'),(175,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','108265.0','1346.0','106919.0','5'),(176,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','1198.0','1702.0','4'),(177,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','459.0','459.0','0.0','1'),(178,'David','9959205452','bala9166@example.com','41ABCDE2406F71','Trichy','9446.0','5152.0','4294.0','3'),(179,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','105220.0','1100.0','104120.0','4'),(180,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','398.0','2502.0','4'),(181,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','459.0','459.0','0.0','1'),(182,'David','9959205452','bala9166@example.com','41ABCDE2406F71','Trichy','9446.0','5152.0','4294.0','3'),(183,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','105220.0','1100.0','104120.0','4'),(184,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','398.0','2502.0','4'),(185,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','459.0','459.0','0.0','1'),(186,'David','9959205452','bala9166@example.com','41ABCDE2406F71','Trichy','9446.0','5152.0','4294.0','3'),(187,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','105220.0','1100.0','104120.0','4'),(188,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','398.0','2502.0','4'),(189,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','459.0','459.0','0.0','1'),(190,'David','9959205452','bala9166@example.com','41ABCDE2406F71','Trichy','9446.0','5152.0','4294.0','3'),(191,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','105220.0','100080.0','5140.0','4'),(192,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','398.0','2502.0','4'),(193,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','459.0','459.0','0.0','1'),(194,'David','9959205452','bala9166@example.com','41ABCDE2406F71','Trichy','9446.0','5152.0','4294.0','3'),(195,'Vasanth','9826599124','vasanth7698@example.com','78ABCDE7613F08','Trichy','105220.0','100080.0','5140.0','4'),(196,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','398.0','2502.0','4'),(197,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','459.0','459.0','0.0','1'),(198,'David','9959205452','bala9166@example.com','41ABCDE2406F71','Trichy','9446.0','5152.0','4294.0','3'),(199,'Vasanth','9823480010','vasanth7698@example.com','78ABCDE7613F08','Trichy','0.0','0.0','0.0','0'),(200,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','398.0','2502.0','4'),(201,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','459.0','459.0','0.0','1'),(202,'David','9959205452','bala9166@example.com','41ABCDE2406F71','Trichy','9446.0','5152.0','4294.0','3'),(203,'Vasanth','9823480010','vasanth7698@example.com','78ABCDE7613F08','Trichy','0.0','0.0','0.0','0'),(204,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','398.0','2502.0','4'),(205,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','459.0','459.0','0.0','1'),(206,'David','9959205452','bala9166@example.com','41ABCDE2406F71','Trichy','9446.0','5152.0','4294.0','3'),(207,'Vasanth','9823480010','vasanth7698@example.com','78ABCDE7613F08','Trichy','0.0','0.0','0.0','0'),(208,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','398.0','2502.0','4'),(209,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','459.0','459.0','0.0','1'),(210,'David','9959205452','bala9166@example.com','41ABCDE2406F71','Trichy','9446.0','5152.0','4294.0','3'),(211,'Vasanth','9823480010','vasanth7698@example.com','78ABCDE7613F08','Trichy','0.0','0.0','0.0','0'),(212,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','398.0','2502.0','4'),(213,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','459.0','459.0','0.0','1'),(214,'David','9959205452','bala9166@example.com','41ABCDE2406F71','Trichy','9446.0','5152.0','4294.0','3'),(215,'Vasanth','9823480010','vasanth7698@example.com','78ABCDE7613F08','Trichy','0.0','0.0','0.0','0'),(216,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','398.0','2502.0','4'),(217,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','459.0','459.0','0.0','1'),(218,'David','9959205452','bala9166@example.com','41ABCDE2406F71','Trichy','9446.0','5152.0','4294.0','3'),(219,'Vasanth','9823480010','vasanth7698@example.com','78ABCDE7613F08','Trichy','0.0','0.0','0.0','0'),(220,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','398.0','2502.0','4'),(221,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','459.0','459.0','0.0','1'),(222,'David','9959205452','bala9166@example.com','41ABCDE2406F71','Trichy','9446.0','5152.0','4294.0','3'),(223,'Vasanth','9823480010','vasanth7698@example.com','78ABCDE7613F08','Trichy','0.0','0.0','0.0','0'),(224,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','398.0','2502.0','4'),(225,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','459.0','459.0','0.0','1'),(226,'David','9959205452','bala9166@example.com','41ABCDE2406F71','Trichy','9446.0','5152.0','4294.0','3'),(227,'Vasanth','9823480010','vasanth7698@example.com','78ABCDE7613F08','Trichy','0.0','0.0','0.0','0'),(228,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','398.0','2502.0','4'),(229,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','459.0','459.0','0.0','1'),(230,'David','9959205452','bala9166@example.com','41ABCDE2406F71','Trichy','9446.0','5152.0','4294.0','3'),(235,'Vasanth','9823480010','vasanth7698@example.com','78ABCDE7613F08','Trichy','0.0','0.0','0.0','0'),(236,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','398.0','2502.0','4'),(237,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','459.0','459.0','0.0','1'),(238,'David','9959205452','bala9166@example.com','41ABCDE2406F71','Trichy','9446.0','5152.0','4294.0','3'),(239,'Karthick','9896264268','babu1850@example.com','90ABCDE5597F75','Kumbakonam','0.0','0.0','0.0','0'),(245,'Vasanth','9823480010','vasanth7698@example.com','78ABCDE7613F08','Trichy','0.0','0.0','0.0','0'),(246,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','398.0','2502.0','4'),(247,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','459.0','459.0','0.0','1'),(248,'David','9959205452','bala9166@example.com','41ABCDE2406F71','Trichy','9446.0','5152.0','4294.0','3'),(249,'Karthick','9976364831','babu1850@example.com','90ABCDE5597F75','Kumbakonam','0.0','0.0','0.0','0'),(255,'Vasanth','8497692614','vasanth7698@example.com','78ABCDE7613F08','Trichy','0.0','0.0','0.0','0'),(256,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','398.0','2502.0','4'),(257,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','459.0','459.0','0.0','1'),(258,'David','9959205452','bala9166@example.com','41ABCDE2406F71','Trichy','9446.0','5152.0','4294.0','3'),(259,'Karthick','9976364831','babu1850@example.com','90ABCDE5597F75','Kumbakonam','0.0','0.0','0.0','0'),(260,'Vasanth','8497692614','vasanth7698@example.com','78ABCDE7613F08','Trichy','0.0','0.0','0.0','0'),(261,'Vasanth','9912346158','vijay1998@example.com','01ABCDE5976F86','Salem','2900.0','398.0','2502.0','4'),(262,'Mangals','9598974789','mangal098@gmail.com','GSTINBNRp299838','Chennai','459.0','459.0','0.0','1'),(263,'David','9959205452','bala9166@example.com','41ABCDE2406F71','Trichy','9446.0','5152.0','4294.0','3'),(264,'Karthick','9976364831','babu1850@example.com','90ABCDE5597F75','Kumbakonam','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');
