INSERT INTO `items_temp_list` (`_id`, `itemname`, `avg_price`, `min_price`, `max_price`, `total_qty`, `total_price`, `barcode`, `not_required`) VALUES (1,'nutella','100.0','100.0','100.0','50.0','5000.0','',''),(2,'ladies finger kg','10.0','10.0','10.0','50.0','500.0','',''),(3,'ladies finger kg','10.0','10.0','10.0','50.0','500.0','',''),(4,'crocin 500','20.0','20.0','20.0','100.0','2000.0','','');
INSERT INTO `itemsort` (`_id`, `itemsorttype`) VALUES (1,'Sort Alphabetically');
INSERT INTO `kot_print` (`_id`, `kot_print_status`) VALUES (1,'Yes');
INSERT INTO `loyalty_points` (`_id`, `money`, `point`, `point2`, `money2`) VALUES (1,'100','1','1','10');
INSERT INTO `loyalty_points_status` (`_id`, `status`) VALUES (1,'yes');
INSERT INTO `menulogin_checking` (`_id`, `status`) VALUES (1,'no');
INSERT INTO `modifiers` (`_id`, `modifiername`, `modprice`, `modstockquan`, `modcategory`, `moditemtax`, `modimage`, `mod_image_text`) VALUES (1,'potato masala',10,50,'Tiffin','None',NULL,NULL),(2,'podi',0,50,'Tiffin','None',NULL,NULL),(3,'cheese',15,35,'Tiffin','None',NULL,NULL),(4,'butter',10,40,'Tiffin','None',NULL,NULL),(5,'omlette',10,50,'Tiffin','None',NULL,NULL),(6,'cheese dip',20,50,'Snacks','None',NULL,NULL),(7,'potato fry',25,50,'Main course','None',NULL,NULL),(8,'chicken fry',40,45,'Main course','None',NULL,NULL),(9,'soda',6,50,'Main course','None',NULL,NULL),(10,'dessert',15,35,'Main course','None',NULL,NULL),(11,'medium',5,50,'Drinks','None',NULL,NULL),(12,'large',10,50,'Drinks','None',NULL,NULL),(13,'cream',20,50,'Desserts','None',NULL,NULL),(14,'chocolate',20,50,'Desserts','None',NULL,NULL);
INSERT INTO `name_dept1` (`_id`, `dept1_name`) VALUES (1,'kot1');
INSERT INTO `name_dept2` (`_id`, `dept2_name`) VALUES (1,'kot2');
INSERT INTO `name_dept3` (`_id`, `dept3_name`) VALUES (1,'kot3');
INSERT INTO `name_dept4` (`_id`, `dept4_name`) VALUES (1,'kot4');
INSERT INTO `ordertaking_server_ip` (`_id`, `ipname`, `port`, `status`) VALUES (1,'192.168.1.100','8080','');
INSERT INTO `paytmmerchantreg` (`_id`, `Account`, `MerchantName`, `guid`, `MID`, `Merchant_key`, `PosID`) VALUES (1,'Not_Registered','','','','','');
INSERT INTO `printer_text_size` (`_id`, `type`) VALUES (1,'Standard');
INSERT INTO `printer_type` (`_id`, `printer_type`) VALUES (1,'wiseposplus');
INSERT INTO `printerreceiptsize` (`_id`, `papersize`) VALUES (1,'2 inch');
INSERT INTO `razorpaymerchantreg` (`_id`, `account`, `account_id`) VALUES (1,'Not_Registered','');
INSERT INTO `round_off` (`_id`, `round_off_status`) VALUES (1,'No');
INSERT INTO `schedule_mail_on_off` (`_id`, `status`) VALUES (1,'Off');
INSERT INTO `schedule_mail_time` (`_id`, `time`) VALUES (1,'11:30 PM');
INSERT INTO `stockcontrol` (`_id`, `stockcontroltype`) VALUES (1,'Off');
INSERT INTO `stockreset` (`_id`, `stockresettype`) VALUES (1,'Off');
INSERT INTO `storedays` (`_id`, `weekdays`, `weekends`, `swap`) VALUES (1,'Monday','0','0'),(2,'Tuesday','0','0'),(3,'Wednesday','0','0'),(4,'Thursday','0','0'),(5,'0','Friday','Friday'),(6,'0','Saturday','Saturday'),(7,'0','Sunday','Sunday');
INSERT INTO `sync_time` (`_id`, `last_time`) VALUES (1,'05 Apr 18, 05:22 PM');
INSERT INTO `table_kot` (`_id`, `status`) VALUES (1,'Lite');
INSERT INTO `taxes` (`_id`, `taxname`, `value`, `taxtype`, `checked`, `tax1`, `tax2`, `tax3`, `hsn_code`) VALUES (1,'SGST(2.5%)',3,'Globaltax','','dine_in','takeaway','homedelivery','');
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'),(6,'user6','no','no','no','no','no','no','no','no');
INSERT INTO `vendor_details` (`_id`, `vendor_name`, `vendor_phoneno`, `vendor_email`, `vendor_address`, `vendor_gst`) VALUES (1,'abc','9986688896','','',''),(2,'sai shradha','9938113344','','',''),(3,'xyz','8896655563','','',''),(4,'mittal enterprises ','9968899963','','','');
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,'abc','9986688896','','5000.0','0','0','0','0','5000.0','03:39 PM','01 May 2021','01 May 2021','202105011539','20210501','0','5000.0','0','01 May 2021','03:39 PM','202105011539',''),(2,'abc','9986688896','','22000.0','0','0','0','0','22000.0','03:40 PM','01 May 2021','01 May 2021','202105011540','20210501','0','22000.0','0','01 May 2021','03:40 PM','202105011540',''),(3,'abc','9986688896','','27500.0','0','0','10','2750.0','24750.0','03:44 PM','01 May 2021','01 May 2021','202105011544','20210501','0','24750.0','0','01 May 2021','03:44 PM','202105011544',''),(4,'abc','9986688896','','2000.0','0','0','0','0','2000.0','08:46 PM','01 May 2021','01 May 2021','202105012046','20210501','0','2000.0','0','01 May 2021','08:46 PM','202105012046',''),(5,'abc','9986688896','','2000.0','0','0','0','0','2000.0','04:49 PM','03 May 2021','03 May 2021','202105031649','20210503','0','2000.0','0','03 May 2021','04:49 PM','202105031649',''),(6,'sai shradha','9938113344','','1500.0','0','0','0','0','1500.0','01:46 PM','05 May 2021','05 May 2021','202105051346','20210505','0','1500.0','0','05 May 2021','01:46 PM','202105051346',''),(7,'sai shradha','9938113344','','2500.0','0','0','0','0','2500.0','01:32 PM','06 May 2021','06 May 2021','202105061332','20210506','0','2500.0','0','06 May 2021','01:32 PM','202105061332',''),(8,'sai shradha','9938113344','','2500.0','0','0','0','0','2500.0','02:14 PM','09 May 2021','09 May 2021','202105091414','20210509','0','2500.0','0','09 May 2021','02:14 PM','202105091414',''),(9,'sai shradha','9938113344','','5000.0','0','0','0','0','5000.0','03:20 PM','10 May 2021','10 May 2021','202105101520','20210510','0','5000.0','0','10 May 2021','03:20 PM','202105101520',''),(10,'abc','9986688896','','5000.0','0','0','0','0','5000.0','02:21 PM','23 May 2021','23 May 2021','202105231421','20210523','0','5000.0','0','23 May 2021','02:21 PM','202105231421',''),(11,'abc','9986688896','','2000.0','0','0','0','0','2000.0','05:30 PM','25 May 2021','25 May 2021','202105251730','20210525','0','2000.0','0','25 May 2021','05:30 PM','202105251730',''),(12,'sai shradha','9938113344','','5000.0','0','0','0','0','5000.0','08:59 PM','31 May 2021','31 May 2021','202105312059','20210531','0','5000.0','0','31 May 2021','08:59 PM','202105312059',''),(13,'sai shradha','9938113344','','5000.0','0','0','0','0','5000.0','01:42 PM','04 Jun 2021','04 Jun 2021','202106041342','20210604','0','5000.0','0','04 Jun 2021','01:42 PM','202106041342',''),(14,'sai shradha','9938113344','','2000.0','0','0','0','0','2000.0','04:04 PM','04 Jun 2021','04 Jun 2021','202106041604','20210604','0','2000.0','0','04 Jun 2021','04:04 PM','202106041604',''),(15,'sai shradha','9938113344','','5000.0','0','0','0','0','5000.0','01:40 PM','05 Jun 2021','05 Jun 2021','202106051340','20210605','0','5000.0','0','05 Jun 2021','01:40 PM','202106051340',''),(16,'sai shradha','9938113344','','5000.0','0','0','0','0','5000.0','01:09 PM','06 Jun 2021','06 Jun 2021','202106061309','20210606','0','5000.0','0','06 Jun 2021','01:09 PM','202106061309',''),(17,'sai shradha','9938113344','','5000.0','0','0','0','0','5000.0','12:24 PM','07 Jun 2021','07 Jun 2021','202106071224','20210607','0','5000.0','0','07 Jun 2021','12:24 PM','202106071224',''),(18,'sai shradha','9938113344','','5000.0','0','0','0','0','5000.0','03:41 PM','12 Jun 2021','12 Jun 2021','202106121541','20210612','0','5000.0','0','12 Jun 2021','03:41 PM','202106121541',''),(19,'sai shradha','9938113344','','5000.0','0','0','0','0','5000.0','12:45 PM','14 Jun 2021','14 Jun 2021','202106141245','20210614','0','5000.0','0','14 Jun 2021','12:45 PM','202106141245',''),(20,'abc','9986688896','','2000.0','0','0','0','0','2000.0','03:58 PM','16 Jun 2021','16 Jun 2021','202106161558','20210616','0','2000.0','0','16 Jun 2021','03:58 PM','202106161558',''),(21,'sai shradha','9938113344','','5000.0','0','0','0','0','5000.0','12:30 PM','18 Jun 2021','18 Jun 2021','202106181230','20210618','0','5000.0','0','18 Jun 2021','12:30 PM','202106181230',''),(22,'sai shradha','9938113344','','12500.0','0','0','0','0','12500.0','12:50 PM','21 Jun 2021','21 Jun 2021','202106211250','20210621','0','12500.0','0','21 Jun 2021','12:50 PM','202106211250',''),(23,'sai shradha','9938113344','','2000.0','0','0','0','0','2000.0','04:06 PM','22 Jun 2021','22 Jun 2021','202106221606','20210622','0','2000.0','0','22 Jun 2021','04:06 PM','202106221606',''),(24,'sai shradha','9938113344','','2000.0','0','0','0','0','2000.0','04:07 PM','22 Jun 2021','22 Jun 2021','202106221607','20210622','0','2000.0','0','22 Jun 2021','04:07 PM','202106221607',''),(25,'sai shradha','9938113344','','5000.0','0','0','0','0','5000.0','12:16 PM','26 Jun 2021','26 Jun 2021','202106261216','20210626','0','5000.0','0','26 Jun 2021','12:16 PM','202106261216',''),(26,'sai shradha','9938113344','','5000.0','0','0','0','0','5000.0','02:28 PM','26 Jun 2021','26 Jun 2021','202106261428','20210626','0','5000.0','0','26 Jun 2021','02:28 PM','202106261428',''),(27,'mittal enterprises ','9968899963','','200.0','0','0','0','0','200.0','02:32 PM','26 Jun 2021','26 Jun 2021','202106261432','20210626','0','200.0','0','26 Jun 2021','02:32 PM','202106261432',''),(28,'mittal enterprises ','9968899963','','200.0','0','0','0','0','200.0','02:32 PM','26 Jun 2021','26 Jun 2021','202106261432','20210626','200','0.0','200.0','26 Jun 2021','02:33 PM','202106261433',''),(29,'sai shradha','9938113344','','2000.0','0','0','0','0','2000.0','03:44 PM','28 Jun 2021','28 Jun 2021','202106281544','20210628','0','2000.0','0','28 Jun 2021','03:44 PM','202106281544',''),(30,'mittal enterprises ','9968899963','','5000.0','0','0','0','0','5000.0','10:12 AM','01 Jul 2021','01 Jul 2021','202107011012','20210701','0','5000.0','0','01 Jul 2021','10:12 AM','202107011012',''),(31,'mittal enterprises ','9968899963','','5000.0','0','0','0','0','5000.0','02:24 PM','01 Jul 2021','01 Jul 2021','202107011424','20210701','0','5000.0','0','01 Jul 2021','02:24 PM','202107011424',''),(32,'mittal enterprises ','9968899963','','150000.0','0','0','0','0','150000.0','04:00 PM','13 Jul 2021','13 Jul 2021','202107131600','20210713','0','150000.0','0','13 Jul 2021','04:00 PM','202107131600',''),(33,'mittal enterprises ','9968899963','','150000.0','0','0','0','0','150000.0','04:00 PM','13 Jul 2021','13 Jul 2021','202107131600','20210713','100000','50000.0','100000.0','13 Jul 2021','04:01 PM','202107131601',''),(34,'sai shradha','9938113344','','5000.0','0','0','0','0','5000.0','12:09 PM','18 Jul 2021','18 Jul 2021','202107181209','20210718','0','5000.0','0','18 Jul 2021','12:09 PM','202107181209',''),(35,'sai shradha','9938113344','','5500.0','0','0','0','0','5500.0','12:10 PM','18 Jul 2021','18 Jul 2021','202107181210','20210718','0','5500.0','0','18 Jul 2021','12:10 PM','202107181210',''),(36,'xyz','8896655563','','5000.0','0','0','0','0','5000.0','03:20 PM','19 Jul 2021','19 Jul 2021','202107191520','20210719','0','5000.0','0','19 Jul 2021','03:20 PM','202107191520',''),(37,'xyz','8896655563','','2000.0','0','0','0','0','2000.0','01:45 PM','20 Jul 2021','20 Jul 2021','202107201345','20210720','0','2000.0','0','20 Jul 2021','01:45 PM','202107201345',''),(38,'mittal enterprises ','9968899963','','2000.0','0','0','0','0','2000.0','10:55 AM','05 Aug 2021','05 Aug 2021','202108051055','20210805','0','2000.0','0','05 Aug 2021','10:55 AM','202108051055',''),(39,'mittal enterprises ','9968899963','','3000.0','0','0','0','0','3000.0','01:18 PM','25 Aug 2021','25 Aug 2021','202108251318','20210825','0','3000.0','0','25 Aug 2021','01:18 PM','202108251318',''),(40,'xyz','8896655563','','3000.0','0','0','0','0','3000.0','03:15 PM','25 Aug 2021','25 Aug 2021','202108251515','20210825','0','3000.0','0','25 Aug 2021','03:15 PM','202108251515',''),(41,'xyz','8896655563','','1200.0','0','0','0','0','1200.0','01:14 PM','03 Sep 2021','03 Sep 2021','202109031314','20210903','0','1200.0','0','03 Sep 2021','01:14 PM','202109031314',''),(42,'xyz','8896655563','','3000.0','0','0','0','0','3000.0','01:32 PM','25 Sep 2021','25 Sep 2021','202109251332','20210925','0','3000.0','0','25 Sep 2021','01:32 PM','202109251332',''),(43,'xyz','8896655563','','3000.0','0','0','0','0','3000.0','10:54 AM','29 Sep 2021','29 Sep 2021','202109291054','20210929','0','3000.0','0','29 Sep 2021','10:54 AM','202109291054',''),(44,'sai shradha','9938113344','','3000.0','0','0','0','0','3000.0','11:58 AM','02 Oct 2021','02 Oct 2021','202110021158','20211002','0','3000.0','0','02 Oct 2021','11:58 AM','202110021158',''),(45,'abc','9986688896','','1039.2','0','0','0','0','1039.2','12:07 PM','02 Oct 2021','02 Oct 2021','202110021207','20211002','0','1039.2','0','02 Oct 2021','12:07 PM','202110021207',''),(46,'sai shradha','9938113344','','3600.0','0','0','0','0','3600.0','12:45 PM','02 Oct 2021','02 Oct 2021','202110021245','20211002','0','3600.0','0','02 Oct 2021','12:45 PM','202110021245',''),(47,'abc','9986688896','','3000.0','0','0','0','0','3000.0','01:09 PM','05 Oct 2021','05 Oct 2021','202110051309','20211005','0','3000.0','0','05 Oct 2021','01:09 PM','202110051309',''),(48,'sai shradha','9938113344','','3000.0','0','0','0','0','3000.0','12:46 PM','20 Oct 2021','20 Oct 2021','202110201246','20211020','0','3000.0','0','20 Oct 2021','12:46 PM','202110201246',''),(49,'abc','9986688896','','3000.0','0','0','0','0','3000.0','12:36 PM','23 Nov 2021','23 Nov 2021','202111231236','20211123','0','3000.0','0','23 Nov 2021','12:36 PM','202111231236',''),(50,'abc','9986688896','','3000.0','0','0','0','0','3000.0','01:29 PM','04 Jan 2022','04 Jan 2022','202201041329','20220104','0','3000.0','0','04 Jan 2022','01:29 PM','202201041329',''),(51,'sai shradha','9938113344','','3000.0','0','0','0','0','3000.0','12:22 PM','21 Jan 2022','21 Jan 2022','202201211222','20220121','0','3000.0','0','21 Jan 2022','12:22 PM','202201211222',''),(52,'mittal enterprises ','9968899963','','3000.0','0','0','0','0','3000.0','12:38 PM','21 Jan 2022','21 Jan 2022','202201211238','20220121','0','3000.0','0','21 Jan 2022','12:38 PM','202201211238',''),(53,'abc','9986688896','','5500.0','0','0','0','0','5500.0','10:48 am','28 Aug 2024','28 Aug 2024','202408281048','20240828','0','5500.0','0','28 Aug 2024','10:48 am','202408281048',''),(54,'abc','9986688896','','1500.0','0','0','0','0','1500.0','12:50 pm','03 Sep 2024','03 Sep 2024','202409031250','20240903','0','1500.0','0','03 Sep 2024','12:50 pm','202409031250','');
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,'abc','9986688896','nutella','50','100','5000.0','','5000.0','0','0','0','0','5000.0','03:39 PM','01 May 2021','01 May 2021','202105011539','20210501','','5000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'abc','9986688896','nutella','200','110','22000.0','','22000.0','0','0','0','0','22000.0','03:40 PM','01 May 2021','01 May 2021','202105011540','20210501','','22000.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,'abc','9986688896','nutella','50','100','5000.0','','5000.0','0','0','0','0','5000.0','03:39 PM','01 May 2021','01 May 2021','202105011539','20210501','','5000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'abc','9986688896','nutella','200','110','22000.0','','22000.0','0','0','0','0','22000.0','03:40 PM','01 May 2021','01 May 2021','202105011540','20210501','','22000.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,'abc','9986688896','nutella','250','110','27500.0','','27500.0','0','0','10','2750.0','24750.0','03:44 PM','01 May 2021','01 May 2021','202105011544','20210501','','24750.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,'abc','9986688896','sona masoori raw rice 1kg','20','100','2000.0','','2000.0','0','0','0','0','2000.0','08:46 PM','01 May 2021','01 May 2021','202105012046','20210501','','2000.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,'abc','9986688896','crocin 500','100','20','2000.0','','2000.0','0','0','0','0','2000.0','04:49 PM','03 May 2021','03 May 2021','202105031649','20210503','','2000.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,'sai shradha','9938113344','sona masoori raw rice 1kg','10','100','1000.0','','1500.0','0','0','0','0','1500.0','01:46 PM','05 May 2021','05 May 2021','202105051346','20210505','','1500.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'sai shradha','9938113344','ladies finger kg','50','10','500.0','','1500.0','0','0','0','0','1500.0','01:46 PM','05 May 2021','05 May 2021','202105051346','20210505','','1500.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'sai shradha','9938113344','nutella ','50','50','2500.0','','2500.0','0','0','0','0','2500.0','01:32 PM','06 May 2021','06 May 2021','202105061332','20210506','','2500.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'sai shradha','9938113344','nutella ','50','50','2500.0','','2500.0','0','0','0','0','2500.0','02:14 PM','09 May 2021','09 May 2021','202105091414','20210509','','2500.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'sai shradha','9938113344','nutella ','50','100','5000.0','','5000.0','0','0','0','0','5000.0','03:20 PM','10 May 2021','10 May 2021','202105101520','20210510','','5000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'abc','9986688896','nutella ','50','100','5000.0','','5000.0','0','0','0','0','5000.0','02:21 PM','23 May 2021','23 May 2021','202105231421','20210523','','5000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'abc','9986688896','nutella ','20','100','2000.0','','2000.0','0','0','0','0','2000.0','05:30 PM','25 May 2021','25 May 2021','202105251730','20210525','','2000.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,'sai shradha','9938113344','nutella ','50','100','5000.0','','5000.0','0','0','0','0','5000.0','08:59 PM','31 May 2021','31 May 2021','202105312059','20210531','','5000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'sai shradha','9938113344','nutella ','50','100','5000.0','','5000.0','0','0','0','0','5000.0','01:42 PM','04 Jun 2021','04 Jun 2021','202106041342','20210604','','5000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'sai shradha','9938113344','nutella ','20','100','2000.0','','2000.0','0','0','0','0','2000.0','04:04 PM','04 Jun 2021','04 Jun 2021','202106041604','20210604','','2000.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,'sai shradha','9938113344','nutella ','50','100','5000.0','','5000.0','0','0','0','0','5000.0','01:40 PM','05 Jun 2021','05 Jun 2021','202106051340','20210605','','5000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'sai shradha','9938113344','nutella ','50','100','5000.0','','5000.0','0','0','0','0','5000.0','01:09 PM','06 Jun 2021','06 Jun 2021','202106061309','20210606','','5000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'sai shradha','9938113344','nutella ','50','100','5000.0','','5000.0','0','0','0','0','5000.0','12:24 PM','07 Jun 2021','07 Jun 2021','202106071224','20210607','','5000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'sai shradha','9938113344','nutella ','50','100','5000.0','','5000.0','0','0','0','0','5000.0','03:41 PM','12 Jun 2021','12 Jun 2021','202106121541','20210612','','5000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'sai shradha','9938113344','nutella ','50','100','5000.0','','5000.0','0','0','0','0','5000.0','12:45 PM','14 Jun 2021','14 Jun 2021','202106141245','20210614','','5000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'abc','9986688896','nutella ','20','100','2000.0','','2000.0','0','0','0','0','2000.0','03:58 PM','16 Jun 2021','16 Jun 2021','202106161558','20210616','','2000.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,'sai shradha','9938113344','nutella ','50','100','5000.0','','5000.0','0','0','0','0','5000.0','12:30 PM','18 Jun 2021','18 Jun 2021','202106181230','20210618','','5000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'sai shradha','9938113344','acc cement','50','250','12500.0','','12500.0','0','0','0','0','12500.0','12:50 PM','21 Jun 2021','21 Jun 2021','202106211250','20210621','','12500.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'sai shradha','9938113344','nutella ','20','100','2000.0','','2000.0','0','0','0','0','2000.0','04:06 PM','22 Jun 2021','22 Jun 2021','202106221606','20210622','','2000.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,'sai shradha','9938113344','nutella ','20','100','2000.0','','2000.0','0','0','0','0','2000.0','04:07 PM','22 Jun 2021','22 Jun 2021','202106221607','20210622','','2000.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,'sai shradha','9938113344','nutella ','50','100','5000.0','','5000.0','0','0','0','0','5000.0','12:16 PM','26 Jun 2021','26 Jun 2021','202106261216','20210626','','5000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'sai shradha','9938113344','nutella ','50','100','5000.0','','5000.0','0','0','0','0','5000.0','02:28 PM','26 Jun 2021','26 Jun 2021','202106261428','20210626','','5000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'mittal enterprises ','9968899963','maggi masala','50','4','200.0','','200.0','0','0','0','0','200.0','02:32 PM','26 Jun 2021','26 Jun 2021','202106261432','20210626','','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),(31,'sai shradha','9938113344','nutella ','20','100','2000.0','','2000.0','0','0','0','0','2000.0','03:44 PM','28 Jun 2021','28 Jun 2021','202106281544','20210628','','2000.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,'mittal enterprises ','9968899963','leggings','100','50','5000.0','','5000.0','0','0','0','0','5000.0','10:12 AM','01 Jul 2021','01 Jul 2021','202107011012','20210701','','5000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,'mittal enterprises ','9968899963','chicken curry piece 1kg','50','100','5000.0','','5000.0','0','0','0','0','5000.0','02:24 PM','01 Jul 2021','01 Jul 2021','202107011424','20210701','','5000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,'mittal enterprises ','9968899963','saree silk','100','1500','150000.0','','150000.0','0','0','0','0','150000.0','04:00 PM','13 Jul 2021','13 Jul 2021','202107131600','20210713','','150000.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,'sai shradha','9938113344','nutella ','50','100','5000.0','','5000.0','0','0','0','0','5000.0','12:09 PM','18 Jul 2021','18 Jul 2021','202107181209','20210718','','5000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,'sai shradha','9938113344','nutella ','50','110','5500.0','','5500.0','0','0','0','0','5500.0','12:10 PM','18 Jul 2021','18 Jul 2021','202107181210','20210718','','5500.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,'xyz','8896655563','nutella ','50','100','5000.0','','5000.0','0','0','0','0','5000.0','03:20 PM','19 Jul 2021','19 Jul 2021','202107191520','20210719','','5000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'xyz','8896655563','nutella ','20','100','2000.0','','2000.0','0','0','0','0','2000.0','01:45 PM','20 Jul 2021','20 Jul 2021','202107201345','20210720','','2000.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,'mittal enterprises ','9968899963','nutella ','50','60','3000.0','','3000.0','0','0','0','0','3000.0','01:18 PM','25 Aug 2021','25 Aug 2021','202108251318','20210825','','3000.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,'xyz','8896655563','nutella ','50','60','3000.0','','3000.0','0','0','0','0','3000.0','03:15 PM','25 Aug 2021','25 Aug 2021','202108251515','20210825','','3000.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,'xyz','8896655563','nutella ','20','60','1200.0','','1200.0','0','0','0','0','1200.0','01:14 PM','03 Sep 2021','03 Sep 2021','202109031314','20210903','','1200.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,'xyz','8896655563','nutella ','50','60','3000.0','','3000.0','0','0','0','0','3000.0','01:32 PM','25 Sep 2021','25 Sep 2021','202109251332','20210925','','3000.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,'xyz','8896655563','nutella ','50','60','3000.0','','3000.0','0','0','0','0','3000.0','10:54 AM','29 Sep 2021','29 Sep 2021','202109291054','20210929','','3000.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,'sai shradha','9938113344','nutella ','50','60','3000.0','','3000.0','0','0','0','0','3000.0','11:58 AM','02 Oct 2021','02 Oct 2021','202110021158','20211002','','3000.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,'abc','9986688896','Britannia Good Day Cashew Coockies 100g','60','17.32','1039.2','','1039.2','0','0','0','0','1039.2','12:07 PM','02 Oct 2021','02 Oct 2021','202110021207','20211002','','1039.2',NULL,NULL,NULL,NULL,NULL,NULL,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,'sai shradha','9938113344','nutella ','60','60','3600.0','','3600.0','0','0','0','0','3600.0','12:45 PM','02 Oct 2021','02 Oct 2021','202110021245','20211002','','3600.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,'abc','9986688896','nutella ','50','60','3000.0','','3000.0','0','0','0','0','3000.0','01:09 PM','05 Oct 2021','05 Oct 2021','202110051309','20211005','','3000.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,'sai shradha','9938113344','nutella ','50','60','3000.0','','3000.0','0','0','0','0','3000.0','12:46 PM','20 Oct 2021','20 Oct 2021','202110201246','20211020','','3000.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,'abc','9986688896','nutella ','50','60','3000.0','','3000.0','0','0','0','0','3000.0','12:36 PM','23 Nov 2021','23 Nov 2021','202111231236','20211123','','3000.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,'abc','9986688896','nutella ','50','60','3000.0','','3000.0','0','0','0','0','3000.0','01:29 PM','04 Jan 2022','04 Jan 2022','202201041329','20220104','','3000.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,'sai shradha','9938113344','nutella ','50','60','3000.0','','3000.0','0','0','0','0','3000.0','12:22 PM','21 Jan 2022','21 Jan 2022','202201211222','20220121','','3000.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,'mittal enterprises ','9968899963','nutella ','50','60','3000.0','','3000.0','0','0','0','0','3000.0','12:38 PM','21 Jan 2022','21 Jan 2022','202201211238','20220121','','3000.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,'abc','9986688896','nutella ','20','60','1200.0','','1200.0','0','0','0','0','1200.0','12:57 PM','05 Mar 2022','05 Mar 2022','202203051257','20220305','','1200.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(54,'mittal enterprises ','9968899963','yakult 65ml','50','10','500.0','','500.0','0','0','0','0','500.0','11:31 AM','10 May 2022','10 May 2022','202205101131','20220510','','500.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(55,'abc','9986688896','nutella','50','110','5500.0','','5500.0','0','0','0','0','5500.0','10:48 am','28 Aug 2024','28 Aug 2024','202408281048','20240828','','5500.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(56,'abc','9986688896','nutella','30','50','1500.0','','1500.0','0','0','0','0','1500.0','12:50 pm','03 Sep 2024','03 Sep 2024','202409031250','20240903','','1500.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
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 (1,'abc','9986688896','','','','55750.0','0.0','55750.0','5'),(2,'abc','9986688896','','','','55750.0','0.0','55750.0','5'),(3,'sai shradha','9938113344','','','','0.0','0.0','0.0','0'),(4,'abc','9986688896','','','','55750.0','0.0','55750.0','5'),(5,'sai shradha','9938113344','','','','0.0','0.0','0.0','0'),(6,'abc','9986688896','','','','62750.0','0.0','62750.0','7'),(7,'sai shradha','9938113344','','','','21500.0','0.0','21500.0','6'),(8,'abc','9986688896','','','','62750.0','0.0','62750.0','7'),(9,'sai shradha','9938113344','','','','21500.0','0.0','21500.0','6'),(10,'abc','9986688896','','','','62750.0','0.0','62750.0','7'),(11,'sai shradha','9938113344','','','','21500.0','0.0','21500.0','6'),(12,'abc','9986688896','','','','62750.0','0.0','62750.0','7'),(13,'sai shradha','9938113344','','','','33500.0','0.0','33500.0','9'),(14,'abc','9986688896','','','','64750.0','0.0','64750.0','8'),(15,'sai shradha','9938113344','','','','75000.0','0.0','75000.0','17'),(16,'abc','9986688896','','','','64750.0','0.0','64750.0','8'),(17,'sai shradha','9938113344','','','','75000.0','0.0','75000.0','17'),(18,'xyz','8896655563','','','','0.0','0.0','0.0','0'),(22,'abc','9986688896','','','','64750.0','0.0','64750.0','8'),(23,'sai shradha','9938113344','','','','80000.0','0.0','80000.0','18'),(24,'xyz','8896655563','','','','0.0','0.0','0.0','0'),(25,'mittal enterprises ','9968899963','','','','0.0','0.0','0.0','0'),(26,'abc','9986688896','','','','64750.0','0.0','64750.0','8'),(27,'sai shradha','9938113344','','','','92500.0','0.0','92500.0','21'),(28,'xyz','8896655563','','','','7000.0','0.0','7000.0','2'),(29,'mittal enterprises ','9968899963','','','','162200.0','100200.0','62000.0','5'),(30,'abc','9986688896','','','','64750.0','0.0','64750.0','8'),(31,'sai shradha','9938113344','','','','92500.0','0.0','92500.0','21'),(32,'xyz','8896655563','','','','14200.0','0.0','14200.0','5'),(33,'mittal enterprises ','9968899963','','','','165200.0','100200.0','65000.0','6'),(34,'abc','9986688896','','','','68789.2','0.0','68789.2','10'),(35,'sai shradha','9938113344','','','','99100.0','0.0','99100.0','23'),(36,'xyz','8896655563','','','','17200.0','0.0','17200.0','6'),(37,'mittal enterprises ','9968899963','','','','165200.0','100200.0','65000.0','6'),(38,'abc','9986688896','','','','74789.2','0.0','74789.2','12'),(39,'sai shradha','9938113344','','','','105100.0','0.0','105100.0','25'),(40,'xyz','8896655563','','','','17200.0','0.0','17200.0','6'),(41,'mittal enterprises ','9968899963','','','','168200.0','100200.0','68000.0','7'),(42,'abc','9986688896','','','','80289.2','0.0','80289.2','13'),(43,'sai shradha','9938113344','','','','105100.0','0.0','105100.0','25'),(44,'xyz','8896655563','','','','17200.0','0.0','17200.0','6'),(45,'mittal enterprises ','9968899963','','','','168200.0','100200.0','68000.0','7');
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:00 AM','Today','11:58 PM','000','2358');
