INSERT INTO `account_selection` (`_id`, `selection`) VALUES (1,'Dine');
INSERT INTO `alaramdays` (`_id`, `selecteddays`, `unselecteddays`, `swap`) VALUES (1,'Monday','0','0'),(2,'Tuesday','0','0'),(3,'Wednesday','0','0'),(4,'Thursday','0','0'),(5,'Friday','0','0'),(6,'Saturday','0','0'),(7,'Sunday','0','0');
INSERT INTO `alaramon_off` (`_id`, `status`) VALUES (1,'On');
INSERT INTO `alaramtime` (`_id`, `time`) VALUES (1,'11:30 PM');
INSERT INTO `asd1` (`_id`, `pName`, `pDate`, `image`, `floor`, `position`, `max`, `present`) VALUES (1,NULL,'1',NULL,'first','0','1','1'),(2,NULL,'2',NULL,'first','0','4','0'),(3,NULL,'3',NULL,'first','0','1','0'),(4,NULL,'1',NULL,'second','0','4','2'),(5,NULL,'2',NULL,'second','0','4',NULL),(8,NULL,'4',NULL,'first','0','1','0'),(9,NULL,'5',NULL,'first','0','4',NULL),(13,NULL,'1',NULL,'thrid','0','4','2'),(14,NULL,'2',NULL,'thrid','0','4',NULL),(15,NULL,'3',NULL,'thrid','0','4',NULL),(16,NULL,'4',NULL,'thrid','0','4',NULL),(17,NULL,'5',NULL,'thrid','0','4',NULL),(18,NULL,'6',NULL,'thrid','0','4',NULL),(19,NULL,'7',NULL,'thrid','0','4',NULL),(20,NULL,'8',NULL,'thrid','0','6',NULL),(21,NULL,'9',NULL,'thrid','0','4',NULL),(22,NULL,'10',NULL,'thrid','0','4',NULL),(29,NULL,'10',NULL,'thrid','0','4',NULL),(30,NULL,'11',NULL,'thrid','0','4',NULL),(32,NULL,'6',NULL,'first','0','4',NULL),(33,NULL,'7',NULL,'first','0','4',NULL),(34,NULL,'8',NULL,'first','0','4',NULL),(35,NULL,'9',NULL,'first','0','4',NULL),(39,NULL,'10',NULL,'first','0','4',NULL),(50,NULL,'11',NULL,'first','0','4',NULL),(51,NULL,'12',NULL,'first','0','4',NULL),(52,NULL,'13',NULL,'first','0','4',NULL),(53,NULL,'14',NULL,'first','0','4',NULL);
INSERT INTO `auto_connect` (`_id`, `auto_connect_status`) VALUES (1,'No');
INSERT INTO `auto_generate_barcode` (`_id`, `generate`) VALUES (1,'Off');
INSERT INTO `billcount_tag` (`_id`, `tag_name`) VALUES (1,'4');
INSERT INTO `billingmode` (`_id`, `billingtype`) VALUES (1,'Fine dine');
INSERT INTO `billingtype` (`_id`, `billingtype_type`) VALUES (1,'Dine-in');
INSERT INTO `btconn` (`_id`, `name`, `address`, `status`, `device`) VALUES (1,'MPT-II','66:32:A1:34:0E:58','','bluetooth');
INSERT INTO `cardswiperactivation` (`_id`, `CardSwiperName`, `merchantKey`, `partnerkey`, `Config_status`) VALUES (1,'PaySwiff','','','Not Activated'),(2,'mSwipe','','','Not Activated'),(3,'PineLabs','','','Not Activated'),(4,'Firstdata','','','Not Activated'),(5,'Paytm','','','Not Activated'),(6,'ezetap','','','Not Activated'),(7,'com/intuition/ivepos/mosambee','2007931234','1234','Activated');
INSERT INTO `change_time_format` (`_id`, `status`) VALUES (1,'changed');
INSERT INTO `companydetailss` (`_id`, `companyname`, `doorno`, `substreet`, `street`, `city`, `state`, `country`, `pincode`, `phoneno`, `taxone`, `taxtwo`, `footerone`, `footertwo`, `address1`, `email`, `website`, `address2`, `address3`) VALUES (1,'Intuitiondemo',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1234567890,NULL,NULL,'hi',NULL,'fhhf','dghh.in',NULL,'abcd345','dsferwt');
INSERT INTO `country_selection` (`_id`, `country`) VALUES (1,'Rupee');
INSERT INTO `default_credit` (`_id`, `status`) VALUES (1,'off');
INSERT INTO `deletedb_time` (`_id`, `time`) VALUES (1,'06:19 AM');
INSERT INTO `deletedbon_off` (`_id`, `status`) VALUES (1,'true');
INSERT INTO `discount_details` (`_id`, `disc_code`, `disc_value`, `disc_type`) VALUES (1,'abd200','5','%'),(4,'abcd20','15','%'),(5,'xyz30','20','%'),(6,'abc','20','%'),(9,'diwali','60','%'),(10,'test','40','%');
INSERT INTO `email_recipient` (`_id`, `name`, `ph_no`, `email`) VALUES (1,'Shantala','7795382537','Shantalaangadi19@gmail.com');
INSERT INTO `estimate_print` (`_id`, `status`) VALUES (1,'Yes');
INSERT INTO `floors` (`_id`, `floorname`, `position`) VALUES (1,'first','0'),(2,'second','4'),(3,'thrid','4');
INSERT INTO `freetrail` (`_id`, `status`) VALUES (1,'Activated');
INSERT INTO `home_check` (`_id`, `login_status`) VALUES (1,'1');
INSERT INTO `homedelivery_prints` (`_id`, `companycopy`, `customercopy`) VALUES (1,'yes','yes');
INSERT INTO `ingredient_items_list` (`_id`, `ingredient_name`, `itemname`, `item_qyt_used`, `currnet_stock`, `date1`, `date`, `time1`, `time`, `modified_datetimee_new`, `qty_unit`, `required`) VALUES (1,'Rice ','dosa','0','20.00','24 Mar 2022','202203241040','10:40:42 AM','1040','202203241040','Kg','15.0'),(2,'Rice ','rice','0','20.00','24 Mar 2022','202203241040','10:40:42 AM','1040','202203241040','Kg','15.0'),(3,'sugar','idly','0','60.0','25 Mar 2022','202203251615','04:15:52 PM','1615','202204011536','Kg','40.0'),(4,'sugar','upma','0','60.0','25 Mar 2022','202203251615','04:15:52 PM','1615','202204011536','Kg','40.0'),(5,'sugar','masal dosa','0','60.0','25 Mar 2022','202203251615','04:15:52 PM','1615','202204011536','Kg','40.0'),(6,'sugar','bread omlette','0','60.0','25 Mar 2022','202203251615','04:15:52 PM','1615','202204011536','Kg','40.0'),(7,'salt','idly','0','26.00','28 Mar 2022','202203280746','07:46:42 AM','0746','202203280746','Kg','4.0'),(8,'salt','dosa','0','26.00','28 Mar 2022','202203280746','07:46:42 AM','0746','202203280746','Kg','4.0'),(9,'salt','pongal','0','26.00','28 Mar 2022','202203280746','07:46:42 AM','0746','202203280746','Kg','4.0'),(10,'salt','upma','0','26.00','28 Mar 2022','202203280746','07:46:42 AM','0746','202203280746','Kg','4.0'),(11,'salt','vada','0','26.00','28 Mar 2022','202203280746','07:46:42 AM','0746','202203280746','Kg','4.0'),(12,'salt','pav bhajji','0','26.00','28 Mar 2022','202203280746','07:46:42 AM','0746','202203280746','Kg','4.0'),(13,'spice','pongal','0','1.0','01 Apr 2022','202204011536','03:36:31 PM','1536','202204011536','Kg','9.0'),(14,'spice','masal dosa','0','1.0','01 Apr 2022','202204011536','03:36:31 PM','1536','202204011536','Kg','9.0'),(15,'spice','uthappam','0','1.0','01 Apr 2022','202204011536','03:36:31 PM','1536','202204011536','Kg','9.0'),(16,'spice','samosa','0','1.0','01 Apr 2022','202204011536','03:36:31 PM','1536','202204011536','Kg','9.0'),(17,'spice','pani puri','0','1.0','01 Apr 2022','202204011536','03:36:31 PM','1536','202204011536','Kg','9.0'),(18,'spice','pav bhajji','0','1.0','01 Apr 2022','202204011536','03:36:31 PM','1536','202204011536','Kg','9.0'),(19,'sugar','Black current ice-cream ','0','60.0','01 Apr 2022','202204011539','03:39:21 PM','1539','202204011539','Kg','15.0'),(20,'sugar','butterscotch cake','0','60.0','01 Apr 2022','202204011539','03:39:21 PM','1539','202204011539','Kg','15.0'),(21,'sugar','butterscotch icecream','0','60.0','01 Apr 2022','202204011539','03:39:21 PM','1539','202204011539','Kg','15.0'),(22,'sugar','vanilla icecream','0','60.0','01 Apr 2022','202204011539','03:39:21 PM','1539','202204011539','Kg','15.0'),(23,'sugar','grape juice','0','60.0','01 Apr 2022','202204011539','03:39:21 PM','1539','202204011539','Kg','15.0'),(24,'sugar','lassi','0','60.0','01 Apr 2022','202204011539','03:39:21 PM','1539','202204011539','Kg','15.0'),(25,'sugar','lime juice','0','60.0','01 Apr 2022','202204011539','03:39:21 PM','1539','202204011539','Kg','15.0'),(26,'sugar','soft drinks','0','60.0','01 Apr 2022','202204011539','03:39:21 PM','1539','202204011539','Kg','15.0'),(27,'salt ','idly','0','26.00','01 Apr 2022','202204011539','03:39:58 PM','1539','202204011539','Kg','14.0'),(28,'salt ','dosa','0','26.00','01 Apr 2022','202204011539','03:39:58 PM','1539','202204011539','Kg','14.0'),(29,'salt ','pongal','0','26.00','01 Apr 2022','202204011539','03:39:58 PM','1539','202204011539','Kg','14.0'),(30,'salt ','upma','0','26.00','01 Apr 2022','202204011539','03:39:58 PM','1539','202204011539','Kg','14.0'),(31,'salt ','poori','0','26.00','01 Apr 2022','202204011539','03:39:58 PM','1539','202204011539','Kg','14.0'),(32,'salt ','masal dosa','0','26.00','01 Apr 2022','202204011539','03:39:58 PM','1539','202204011539','Kg','14.0'),(33,'salt ','bread omlette','0','26.00','01 Apr 2022','202204011539','03:39:58 PM','1539','202204011539','Kg','14.0'),(34,'spice ','idly','0','1.0','01 Apr 2022','202204011540','03:40:33 PM','1540','202204011540','Kg','11.0'),(35,'spice ','dosa','0','1.0','01 Apr 2022','202204011540','03:40:33 PM','1540','202204011540','Kg','11.0'),(36,'spice ','onion dosa','0','1.0','01 Apr 2022','202204011540','03:40:33 PM','1540','202204011540','Kg','11.0'),(37,'spice ','uthappam','0','1.0','01 Apr 2022','202204011540','03:40:33 PM','1540','202204011540','Kg','11.0'),(38,'spice ','bread omlette','0','1.0','01 Apr 2022','202204011540','03:40:33 PM','1540','202204011540','Kg','11.0'),(39,'spice ','poori','0','1.0','01 Apr 2022','202204011540','03:40:33 PM','1540','202204011540','Kg','11.0'),(40,'spice ','upma','0','1.0','01 Apr 2022','202204011540','03:40:33 PM','1540','202204011540','Kg','11.0'),(41,'spice ','pongal','0','1.0','01 Apr 2022','202204011540','03:40:33 PM','1540','202204011540','Kg','11.0'),(42,'spice ','masal dosa','0','1.0','01 Apr 2022','202204011540','03:40:33 PM','1540','202204011540','Kg','11.0'),(43,'spice ','rava dosa','0','1.0','01 Apr 2022','202204011540','03:40:33 PM','1540','202204011540','Kg','11.0'),(44,'milk','butterscotch cake','0','6.0','25 Apr 2022','202204251430','02:30:53 PM','1430','202302101537','L','7.0'),(45,'milk','butterscotch icecream','0','6.0','25 Apr 2022','202204251430','02:30:53 PM','1430','202302101537','L','7.0'),(46,'milk','vanilla icecream','0','6.0','25 Apr 2022','202204251430','02:30:53 PM','1430','202302101537','L','7.0'),(47,'milk','lassi','0','6.0','25 Apr 2022','202204251430','02:30:53 PM','1430','202302101537','L','7.0'),(49,'milk','tea','0','6.0','25 Apr 2022','202204251430','02:30:53 PM','1430','202302101537','L','7.0'),(50,'milk','coffee','0','6.0','25 Apr 2022','202204251430','02:30:53 PM','1430','202302101537','L','7.0'),(51,'curd','roti','0','24.0','26 Apr 2022','202204261243','12:43:51 PM','1243','202204261243','L','3.0'),(52,'curd','rice','0','24.0','26 Apr 2022','202204261243','12:43:51 PM','1243','202204261243','L','3.0'),(53,'wheat flour','upma','0','50.00','27 Apr 2022','202204271153','11:53:07 AM','1153','202204271153','Kg','49.0'),(54,'wheat flour','veg thali','0','50.00','27 Apr 2022','202204271153','11:53:07 AM','1153','202204271153','Kg','49.0'),(55,'wheat flour','non veg thali','0','50.00','27 Apr 2022','202204271153','11:53:07 AM','1153','202204271153','Kg','49.0'),(56,'maida','poori','0','30.00','27 Apr 2022','202204271154','11:54:24 AM','1154','202204271154','Kg','25.0'),(57,'maida','samosa','0','30.00','27 Apr 2022','202204271154','11:54:24 AM','1154','202204271154','Kg','25.0'),(58,'maida','pani puri','0','30.00','27 Apr 2022','202204271154','11:54:24 AM','1154','202204271154','Kg','25.0'),(59,'jowar','non veg thali','0','15.00','16 May 2022','202205161125','11:25:31 AM','1125','202205161125','Kg','13.0'),(60,'jowar','veg thali','0','15.00','16 May 2022','202205161125','11:25:31 AM','1125','202205161125','Kg','13.0'),(61,'jowar','roti','0','15.00','16 May 2022','202205161125','11:25:31 AM','1125','202205161125','Kg','13.0'),(62,'besan flour','vada','2','7.00','25 May 2024','202405251230','12:30:46 PM','1230','202405251230','Kg ','0.0'),(63,'dal','veg thali','0','3.00','19 May 2022','202205191226','12:26:44 PM','1226','202205191226','Kg','4.0'),(64,'dal','non veg thali','0','3.00','19 May 2022','202205191226','12:26:44 PM','1226','202205191226','Kg','4.0'),(65,'dal','dhal fry','0','3.00','19 May 2022','202205191226','12:26:44 PM','1226','202205191226','Kg','4.0'),(66,'potato','samosa','0','5.00','27 May 2022','202205271243','12:43:19 PM','1243','202205271243','Kg','5.0'),(67,'potato','pani puri','0','5.00','27 May 2022','202205271243','12:43:19 PM','1243','202205271243','Kg','5.0'),(68,'potato','veg cutlet','0','5.00','27 May 2022','202205271243','12:43:19 PM','1243','202205271243','Kg','5.0'),(69,'potato','masal puri','0','5.00','27 May 2022','202205271243','12:43:19 PM','1243','202205271243','Kg','5.0');
INSERT INTO `ingredient_sold_details` (`_id`, `vendor_name`, `vendor_phoneno`, `invoice`, `billamount`, `tax_percent`, `tax_amount`, `disc_percent`, `disc_amount`, `total_bill_amount`, `from_time`, `from_date`, `due_date`, `datetimee_new_from`, `datetimee_new_due`, `pay`, `pending`, `total_pay`, `pay_date`, `pay_time`, `pay_datetimeemew`, `not_required`) VALUES (1,'Abdc','4567801234','2','1000','0','0','0','0','1000','04:37 PM','24 Mar 2022','24 Mar 2022','202203241637','20220324','0','1000.0','0','24 Mar 2022','04:37 PM','202203241637',NULL),(2,'Abdc','4567801234','2','1000','0','0','0','0','1000','04:37 PM','24 Mar 2022','24 Mar 2022','202203241637','20220324','1000','0.0','1000.0','25 Mar 2022','04:14 PM','202203251614',''),(3,'Ven4','7536952464','','0.0','0','0','0','0','0.0','07:42 AM','28 Mar 2022','28 Mar 2022','202203280742','20220328','0','0.0','0','28 Mar 2022','07:42 AM','202203280742',''),(4,'Ven4','7536952464','4','0.0','0','0','0','0','0.0','07:43 AM','28 Mar 2022','28 Mar 2022','202203280743','20220328','0','0.0','0','28 Mar 2022','07:43 AM','202203280743',''),(5,'Ven5','4567801234','5','100','0','0','0','0','100','02:26 AM','28 Mar 2022','28 Mar 2022','202203280226','20220328','100','0.0','100','28 Mar 2022','02:26 AM','202203280226',NULL),(6,'Ven1','5362910282','06','400.0','0','0','0','0','400.0','04:01 PM','01 Apr 2022','01 Apr 2022','202204011601','20220401','400','0.0','400','01 Apr 2022','04:01 PM','202204011601',''),(7,'Abdc','4567801234','05','5000.0','0','0','0','0','5000.0','04:03 PM','01 Apr 2022','01 Apr 2022','202204011603','20220401','5000','0.0','5000','01 Apr 2022','04:03 PM','202204011603',''),(8,'Ven1','5362910282','06','900.0','0','0','0','0','900.0','04:03 PM','01 Apr 2022','01 Apr 2022','202204011603','20220401','900','0.0','900','01 Apr 2022','04:03 PM','202204011603',''),(9,'Ven1','5362910282','08','1200','0','0','0','0','1200','04:29 AM','22 Apr 2022','22 Apr 2022','202204220429','20220422','1200','0.0','1200','22 Apr 2022','04:29 AM','202204220429',NULL),(10,'Ven2','5790864357','','4200.0','0','0','0','0','4200.0','05:41 PM','26 Apr 2022','26 Apr 2022','202204261741','20220426','4200','0.0','4200','26 Apr 2022','05:41 PM','202204261741',''),(11,'Ven5','4567801234','09','36.0','0','0','0','0','36.0','11:50 AM','27 Apr 2022','27 Apr 2022','202204271150','20220427','36','0.0','36','27 Apr 2022','11:50 AM','202204271150',''),(12,'Ven2','5790864357','10','500.0','0','0','0','0','500.0','11:55 AM','27 Apr 2022','27 Apr 2022','202204271155','20220427','500','0.0','500','27 Apr 2022','11:55 AM','202204271155',''),(13,'Ven1','5362910282','11','1470.0','0','0','0','0','1470.0','04:29 PM','27 Apr 2022','27 Apr 2022','202204271629','20220427','1470','0.0','1470','27 Apr 2022','04:29 PM','202204271629',''),(14,'Ven3','5790742468','03','520.0','0','0','0','0','520.0','02:47 PM','16 May 2022','16 May 2022','202205161447','20220516','520','0.0','520','16 May 2022','02:47 PM','202205161447',''),(15,'Ven5','4567801234','04','1400.0','0','0','0','0','1400.0','02:49 PM','16 May 2022','16 May 2022','202205161449','20220516','1400','0.0','1400','16 May 2022','02:49 PM','202205161449',''),(16,'Ven2','5790864357','','132.0','0','0','0','0','132.0','12:17 PM','20 May 2022','20 May 2022','202205201217','20220520','132','0.0','132','20 May 2022','12:17 PM','202205201217',''),(17,'Ven3','5790742468','09','525.0','0','0','0','0','525.0','01:53 PM','08 Jul 2022','08 Jul 2022','202207081353','20220708','525','0.0','525','08 Jul 2022','01:53 PM','202207081353',''),(18,'Ven2','5790864357','10','525.0','0','0','0','0','525.0','04:09 PM','13 Jul 2022','13 Jul 2022','202207131609','20220713','525','0.0','525','13 Jul 2022','04:09 PM','202207131609',''),(19,'Ven8','9865324570','12','525.0','0','0','0','0','525.0','04:37 PM','13 Jul 2022','13 Jul 2022','202207131637','20220713','525','0.0','525','13 Jul 2022','04:37 PM','202207131637',''),(20,'Ven1','5362910282','56','240.0','0','0','0','0','240.0','07:08 PM','09 Nov 2022','09 Nov 2022','202211091908','20221109','240','0.0','240','09 Nov 2022','07:08 PM','202211091908',''),(21,'Ven8','4680764236','46','8000.0','0','0','0','0','8000.0','07:18 PM','09 Nov 2022','09 Nov 2022','202211091918','20221109','8000','0.0','8000','09 Nov 2022','07:18 PM','202211091918',''),(22,'Ven1','5362910282','01','2000','0','0','0','0','2000','08:22 AM','29 Nov 2022','29 Nov 2022','202211290822','20221129','2000','0.0','2000','29 Nov 2022','08:22 AM','202211290822',NULL),(23,'Ven7','3570096532','07','4500','0','0','0','0','4500','08:23 AM','29 Nov 2022','29 Nov 2022','202211290823','20221129','4500','0.0','4500','29 Nov 2022','08:23 AM','202211290823',NULL),(24,'Ven2','5790864357','567','5400','0','0','0','0','5400','01:44 PM','19 Dec 2022','19 Dec 2022','202212191344','20221219','0','5400.0','0','19 Dec 2022','01:44 PM','202212191344',NULL),(25,'Ven3','5790742468','324','70.0','0','0','0','0','70.0','02:53 PM','14 Feb 2023','14 Feb 2023','202302141453','20230214','70','0.0','70','14 Feb 2023','02:53 PM','202302141453',''),(26,'Ven2','5790864357','345','105.0','0','0','0','0','105.0','02:54 PM','14 Feb 2023','14 Feb 2023','202302141454','20230214','105','0.0','105','14 Feb 2023','02:54 PM','202302141454',''),(27,'Ven1','5362910282','23','726','0','0','0','0','726','04:26 AM','22 Sep 2023','22 Sep 2023','202309220426','20230922','726','0.0','726','22 Sep 2023','04:26 AM','202309220426',NULL),(28,'Ven2','5790864357','45','75','0','0','0','0','75','08:00 AM','28 Sep 2023','28 Sep 2023','202309280800','20230928','75','0.0','75','28 Sep 2023','08:00 AM','202309280800',NULL),(29,'Ven8','4680764236','009','99','0','0','0','0','99','07:12 AM','15 Mar 2024','15 Mar 2024','202403150712','20240315','0','99.0','0','15 Mar 2024','07:12 AM','202403150712',NULL),(30,'Abd','4567801234','001','33','0','0','0','0','33','10:19 AM','15 Mar 2024','15 Mar 2024','202403151019','20240315','0','33.0','0','15 Mar 2024','10:19 AM','202403151019',NULL),(31,'Ven8','4567801234','00007','35','0','0','0','0','35','04:36 AM','16 Mar 2024','16 Mar 2024','202403160436','20240316','0','35.0','0','16 Mar 2024','04:36 AM','202403160436',NULL),(32,'Ven1','5362910282','06','900.0','0','0','0','0','900.0','04:03 PM','01 Apr 2022','01 Apr 2022','202204011603','20220401','200','-200.0','1100','03 Apr 2024','10:53 AM','202404031053',NULL);
INSERT INTO `ingredient_sold_item_details` (`_id`, `vendor_name`, `vendor_phoneno`, `itemname`, `qty_add`, `individual_price`, `total_price`, `invoice`, `billamount`, `tax_percent`, `tax_amount`, `disc_percent`, `disc_amount`, `total_bill_amount`, `from_time`, `from_date`, `due_date`, `datetimee_new_from`, `datetimee_new_due`, `pay`, `pending`, `tax1`, `tax2`, `tax3`, `tax4`, `tax5`, `tax6`, `tax7`, `tax8`, `tax9`, `tax10`, `tax11`, `tax12`, `tax13`, `tax14`, `tax15`, `tax1_value`, `tax2_value`, `tax3_value`, `tax4_value`, `tax5_value`, `tax6_value`, `tax7_value`, `tax8_value`, `tax9_value`, `tax10_value`, `tax11_value`, `tax12_value`, `tax13_value`, `tax14_value`, `tax15_value`, `wastage`, `unit`) VALUES (1,'Abdc','4567801234','Rice ','20','50','1000','2','1000','0','0','0','0','1000','04:38 PM','24 Mar 2022','24 Mar 2022','202203241638','20220324','0','1000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Kg'),(2,'Xyz','7536952464','Rice ','20','0','0.0','','0.0','0','0','0','0','0.0','07:42 AM','28 Mar 2022','28 Mar 2022','202203280742','20220328','','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(3,'Xyz','7536952464','Rice ','30','0','0.0','4','0.0','0','0','0','0','0.0','07:43 AM','28 Mar 2022','28 Mar 2022','202203280743','20220328','','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.0','Kg'),(4,'Abdc','4567801234','salt','5','20','100','5','100','0','0','0','0','100','02:26 AM','28 Mar 2022','28 Mar 2022','202203280226','20220328','100','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,NULL,'Kg'),(5,'Ven1','5362910282','salt ','20','20','400.0','06','400.0','0','0','0','0','400.0','04:01 PM','01 Apr 2022','01 Apr 2022','202204011601','20220401','400','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(6,'Abdc','4567801234','spice ','20','250','5000.0','05','5000.0','0','0','0','0','5000.0','04:03 PM','01 Apr 2022','01 Apr 2022','202204011603','20220401','5000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(7,'Ven1','5362910282','sugar','15','60','900.0','06','900.0','0','0','0','0','900.0','04:03 PM','01 Apr 2022','01 Apr 2022','202204011603','20220401','900','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(8,'Ven1','5362910282','sugar','20','60','1200','08','1200','0','0','0','0','1200','04:29 AM','22 Apr 2022','22 Apr 2022','202204220429','20220422','1200','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,NULL,'Kg'),(9,'Ven2','5790864357','sugar','50','60','3000.0','','4200.0','0','0','0','0','4200.0','05:41 PM','26 Apr 2022','26 Apr 2022','202204261741','20220426','4200','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(10,'Ven2','5790864357','milk','40','30','1200.0','','4200.0','0','0','0','0','4200.0','05:41 PM','26 Apr 2022','26 Apr 2022','202204261741','20220426','4200','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','L'),(11,'Abdc','4567801234','curd','3','12','36.0','09','36.0','0','0','0','0','36.0','11:50 AM','27 Apr 2022','27 Apr 2022','202204271150','20220427','36','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','L'),(12,'Ven2','5790864357','maida','25','20','500.0','10','500.0','0','0','0','0','500.0','11:55 AM','27 Apr 2022','27 Apr 2022','202204271155','20220427','500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(13,'Ven1','5362910282','wheat flour','49','30','1470.0','11','1470.0','0','0','0','0','1470.0','11:56 AM','27 Apr 2022','27 Apr 2022','202204271156','20220427','1470','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(14,'Ven1','5362910282','wheat flour','49','30','1470.0','11','1470.0','0','0','0','0','1470.0','04:29 PM','27 Apr 2022','27 Apr 2022','202204271629','20220427','1470','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(15,'Ven3','5790742468','jowar','13','40','520.0','03','520.0','0','0','0','0','520.0','02:47 PM','16 May 2022','16 May 2022','202205161447','20220516','520','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(16,'Abdc','4567801234','Rice ','40','35','1400.0','04','1400.0','0','0','0','0','1400.0','02:49 PM','16 May 2022','16 May 2022','202205161449','20220516','1400','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(17,'Ven2','5790864357','besan flour','4','33','132.0','','132.0','0','0','0','0','132.0','12:17 PM','20 May 2022','20 May 2022','202205201217','20220520','132','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(18,'Ven3','5790742468','Rice ','15','35','525.0','09','525.0','0','0','0','0','525.0','01:53 PM','08 Jul 2022','08 Jul 2022','202207081353','20220708','525','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(19,'Ven2','5790864357','Rice ','15','35','525.0','10','525.0','0','0','0','0','525.0','04:09 PM','13 Jul 2022','13 Jul 2022','202207131609','20220713','525','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(20,'Ven8','9865324570','Rice ','15','35','525.0','12','525.0','0','0','0','0','525.0','04:37 PM','13 Jul 2022','13 Jul 2022','202207131637','20220713','525','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(21,'Ven1','5362910282','curd','20','12','240.0','56','240.0','0','0','0','0','240.0','07:08 PM','09 Nov 2022','09 Nov 2022','202211091908','20221109','240','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','L'),(22,'Ven8','4680764236','millet','20','400','8000.0','46','8000.0','0','0','0','0','8000.0','07:18 PM','09 Nov 2022','09 Nov 2022','202211091918','20221109','8000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(23,'Ven1','5362910282','chia seeds','10','200','2000','01','2000','0','0','0','0','2000','08:22 AM','29 Nov 2022','29 Nov 2022','202211290822','20221129','2000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Kg'),(24,'Ven7','3570096532','Corn flourr','30','150','4500','07','4500','0','0','0','0','4500','08:23 AM','29 Nov 2022','29 Nov 2022','202211290823','20221129','4500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Kg'),(25,'Ven2','5790864357','millet','20','270','5400','567','5400','0','0','0','0','5400','01:45 PM','19 Dec 2022','19 Dec 2022','202212191345','20221219','0','5400.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Kg'),(26,'Ven3','5790742468','milk','2','35','70.0','324','70.0','0','0','0','0','70.0','02:53 PM','14 Feb 2023','14 Feb 2023','202302141453','20230214','70','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','L'),(27,'Ven2','5790864357','milk','3','35','105.0','345','105.0','0','0','0','0','105.0','02:54 PM','14 Feb 2023','14 Feb 2023','202302141454','20230214','105','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','L'),(28,'Ven1','5362910282','besan flour','22','33','726','23','726','0','0','0','0','726','04:26 AM','22 Sep 2023','22 Sep 2023','202309220426','20230922','726','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,NULL,'Kg'),(29,'Ven2','5790864357','milk','3','25','75','45','75','0','0','0','0','75','08:00 AM','28 Sep 2023','28 Sep 2023','202309280800','20230928','75','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,NULL,'Kg'),(30,'Ven8','4680764236','besan flour','03','33','99','009','99','0','0','0','0','99','07:12 AM','15 Mar 2024','15 Mar 2024','202403150712','20240315','0','99.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,'Abd','4567801234','besan flour','01','33','33','001','33','0','0','0','0','33','10:19 AM','15 Mar 2024','15 Mar 2024','202403151019','20240315','0','33.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,'Ven8','4567801234','Rice ','01','35','35','00007','35','0','0','0','0','35','04:36 AM','16 Mar 2024','16 Mar 2024','202403160436','20240316','0','35.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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 `ingredients` (`_id`, `ingredient_name`, `min_req`, `max_req`, `current_stock`, `unit`, `indiv_price`, `total_price`, `date`, `date1`, `time`, `time1`, `datetimee_new`, `avg_price`, `required`, `barcode`, `status_low`, `status_qty_updated`, `add_qty`, `indiv_price_copy`, `adjusted_stock`, `diff_stock`, `indiv_price_temp`, `total_price_temp`) VALUES (1,'Rice ','10','20','20.00','Kg','35',NULL,'202207030043','03 Jul 2022','0043','00:43:15 AM','202207131638','35','0.0','','','','0',NULL,'','','35',''),(2,'sugar','10','20','60.0','Kg','60',NULL,'202204011539','01 Apr 2022','1539','03:39:23 PM','202204011539','60.0','-40.0','','','','0',NULL,'','','60',''),(3,'salt ','15','20','26.00','Kg','20',NULL,'202204011540','01 Apr 2022','1540','03:40:00 PM','202204011540','20.0','-6.0','','','','0',NULL,'','','20',''),(6,'curd','2','4','24.00','L','12',NULL,'202204261243','26 Apr 2022','1243','12:43:53 PM','202204261243','12.0','-20.0','','','','0',NULL,'','','12',''),(8,'Maida flour','20','30','30.00','Kg','20',NULL,'202212261039','26 Dec 2022','1039','10:39:26 AM','202212261039','NaN','0.0','0','','','0',NULL,'','','20',''),(9,'jowar','10','15','15.00','Kg','40',NULL,'202205161125','16 May 2022','1125','11:25:33 AM','202205161125','40.0','0.0','','','','0',NULL,'','','40',''),(10,'besan flour','80','5','7.00','Kg ','33',NULL,'202405251230','25 May 2024','1230','12:30:46 PM','202405251230','33','0.0','0','Low','','0',NULL,'','','33',''),(11,'milk','5','8','6.00','L','35',NULL,'202302101537','10 Feb 2023','1537','03:37:55 PM','202302101537','30.6','2.0','','','','0',NULL,'','','35',''),(12,'sugar','20','50','60.00','Kg','0',NULL,'202309251357','25 Sep 2023','1357','01:57:51 PM','202309251357','0','50.0','','',NULL,NULL,NULL,NULL,NULL,'0',NULL),(13,'milk','2','4','19','Kg','25',NULL,'202309251459','25 Sep 2023','1459','02:59:40 PM','202309251459','25','4.0','','',NULL,NULL,NULL,NULL,NULL,'0',NULL);
INSERT INTO `ipconn` (`_id`, `ipname`, `port`, `status`, `printer_name`) VALUES (1,'192.168.1.87','9100','','TM Printer');
INSERT INTO `ipconn_counter` (`_id`, `ipname`, `port`, `status`, `printer_name`) VALUES (1,'192.168.1.92','9100','','TM Printer');
INSERT INTO `ipconn_kot1` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.88','9100','',NULL,'kot1');
INSERT INTO `ipconn_kot2` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.89','9100','',NULL,'kot2');
INSERT INTO `ipconn_kot3` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.90','9100','',NULL,'kot3');
INSERT INTO `ipconn_kot4` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.91','9100','',NULL,'kot4');
INSERT INTO `items` (`_id`, `itemname`, `price`, `stockquan`, `category`, `itemtax`, `image`, `weekdaysvalue`, `weekendsvalue`, `manualstockvalue`, `automaticstockresetvalue`, `clickcount`, `favourites`, `disc_type`, `disc_value`, `image_text`, `barcode_value`, `checked`, `print_value`, `quantity_sold`, `minimum_qty`, `minimum_qty_copy`, `add_qty`, `status_low`, `status_qty_updated`, `individual_price`, `unit_type`, `tax_value`, `itemtax2`, `tax_value2`, `itemtax3`, `tax_value3`, `itemtax4`, `tax_value4`, `itemtax5`, `tax_value5`, `status_temp`, `status_perm`, `variant1`, `variant_price1`, `variant2`, `variant_price2`, `variant3`, `variant_price3`, `variant4`, `variant_price4`, `variant5`, `variant_price5`, `dept_name`, `add_qty_st`, `status_qty_updated_st`, `out_of_stock`, `mod_set1`, `mod_set2`, `mod_set3`, `mod_set4`, `mod_set5`, `v1_oofstock`, `v2_oofstock`, `v3_oofstock`, `v4_oofstock`, `v5_oofstock`) VALUES (1,'idly',25.00,38,'Tiffin','None','',NULL,NULL,NULL,NULL,NULL,'no','%','0','id','1',NULL,NULL,0,'80','80','02','Low',NULL,'23','Unit','','None','','','','','','','','','','regular','25.00','Medium','35','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'dosa',35.00,31,'Tiffin','None','','0',NULL,NULL,NULL,NULL,'no','%','0','do','2',NULL,NULL,3,'80','80','02','Low',NULL,'21','Unit','','None','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'pongal',30.00,47,'Tiffin','None','','0',NULL,NULL,NULL,NULL,'no','%','0','po','3',NULL,NULL,3,'80','80',NULL,'Low',NULL,NULL,'Unit','','None','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'upma',30.00,42,'Tiffin','None','','0',NULL,NULL,NULL,NULL,'no','%','0','up','4',NULL,NULL,3,'80','80',NULL,'Low',NULL,NULL,'Unit','','None','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'poori',35.00,32,'Tiffin','','','0','0',NULL,NULL,NULL,'no','%','0','po','5',NULL,NULL,2,'0','0','02','',NULL,'12','Unit','0','','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'masal dosa',40.00,23,'Tiffin','None','','0',NULL,NULL,NULL,NULL,'no','%','0','ma','6',NULL,NULL,5,'80','80',NULL,'Low',NULL,NULL,'Unit','','None','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'bread omlette',30.00,12,'Tiffin','None','',NULL,NULL,NULL,NULL,NULL,'no','%','0','br','7',NULL,NULL,2,'80','80',NULL,'Low',NULL,NULL,'Unit','','None','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'onion dosa',35.00,6,'Tiffin','None','','0',NULL,NULL,NULL,NULL,'no','%','0','on','8',NULL,NULL,6,'80','80','01','Low',NULL,'23','Unit','','None','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'rava dosa',35.00,12,'Tiffin','','','0',NULL,NULL,NULL,NULL,'no','%','0','ra','9',NULL,NULL,0,'80','80',NULL,'',NULL,NULL,'Unit','0','','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'uthappam',30.00,23,'Tiffin','None','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ut','10',NULL,NULL,NULL,'80','80',NULL,'Low',NULL,NULL,'Unit','','None','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'vada',20.00,95,'Snacks','','',NULL,NULL,NULL,NULL,NULL,'no','%','0','va','11',NULL,NULL,1,'80','80',NULL,'',NULL,NULL,'Unit','0','','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'masal vada',20.00,46,'Snacks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ma','12',NULL,NULL,NULL,'80','80',NULL,'Low',NULL,NULL,'Unit','0','','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'samosa',20.00,48,'Snacks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','sa','13',NULL,NULL,NULL,'80','80',NULL,'Low',NULL,NULL,'Unit','0','','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'chicken kabab',60.00,18,'Snacks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ch','14',NULL,NULL,NULL,'80','80',NULL,'Low',NULL,NULL,'Unit','0','','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'sheekh kabab',80.00,18,'Snacks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','sh','15',NULL,NULL,NULL,'80','80',NULL,'Low',NULL,NULL,'Unit','0','','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'pani puri',35.00,29,'Snacks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','pa','16',NULL,NULL,NULL,'80','80',NULL,'Low',NULL,NULL,'Unit','0','','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'pav bhajji',60.00,29,'Snacks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','pa','17',NULL,NULL,NULL,'80','80','01','Low',NULL,'12','Unit','0','','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'veg cutlet',40.00,28,'Snacks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ve','18',NULL,NULL,NULL,'80','80',NULL,'Low',NULL,NULL,'Unit','0','','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'masal puri',35.00,29,'Snacks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ma','19',NULL,NULL,NULL,'80','80',NULL,'Low',NULL,NULL,'Unit','0','','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'chicken nuggets',65.00,-19,'Snacks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ch','20',NULL,NULL,NULL,'80','80',NULL,'Low',NULL,NULL,'Unit','0','','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'veg biriyani',70.00,48,'Main course','None','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ve','21',NULL,NULL,NULL,'80','80',NULL,'Low',NULL,NULL,'Unit','','','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'chicken biriyani',100.00,49,'Main course','None','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ch','22',NULL,NULL,NULL,'80','80',NULL,'Low',NULL,NULL,'Unit','','','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'veg thali',50.00,48,'Main course','None','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ve','23',NULL,NULL,NULL,'80','80',NULL,'Low',NULL,NULL,'Unit','','','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'non veg thali',80.00,48,'Main course','None','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','no','24',NULL,NULL,NULL,'80','80',NULL,'Low',NULL,NULL,'Unit','','','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'mutton biriyani',130.00,49,'Main course','None','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','mu','25',NULL,NULL,NULL,'80','80',NULL,'Low',NULL,NULL,'Unit','','','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'roti',15.00,99,'Main course','None','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ro','26',NULL,NULL,NULL,'80','80',NULL,NULL,NULL,NULL,'Unit','','','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'rice',30.00,49,'Main course','None','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ri','27',NULL,NULL,NULL,'80','80',NULL,'Low',NULL,NULL,'Unit','','','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'paneer butter masala',60.00,50,'Main course','None','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','pa','28',NULL,NULL,NULL,'80','80',NULL,'Low',NULL,NULL,'Unit','','','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'chicken sukka',80.00,50,'Main course','None','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ch','29',NULL,NULL,NULL,'80','80',NULL,'Low',NULL,NULL,'Unit','','','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'dhal fry',30.00,50,'Main course','None','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','dh','30',NULL,NULL,NULL,'80','80',NULL,'Low',NULL,NULL,'Unit','','','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,'coffee',20.00,99,'Drinks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','co','31',NULL,NULL,NULL,'80','80',NULL,NULL,NULL,NULL,'Unit','0','','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,'tea',20.00,49,'Drinks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','te','32',NULL,NULL,NULL,'80','80',NULL,'Low',NULL,NULL,'Unit','0','','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,'masala chai',25.00,49,'Drinks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ma','33',NULL,NULL,NULL,'80','80',NULL,'Low',NULL,NULL,'Unit','0','','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,'soft drinks',10.00,50,'Drinks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','so','34',NULL,NULL,NULL,'80','80',NULL,'Low',NULL,NULL,'Unit','0','','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,'lime juice',15.00,29,'Drinks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','li','35',NULL,NULL,NULL,'80','80',NULL,'Low',NULL,NULL,'Unit','0','','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,'lassi',25.00,24,'Drinks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','la','36',NULL,NULL,NULL,'80','80',NULL,'Low',NULL,NULL,'Unit','0','','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,'grape juice',25.00,25,'Drinks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','gr','37',NULL,NULL,NULL,'80','80',NULL,'Low',NULL,NULL,'Unit','0','','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'vanilla icecream',35.00,50,'Desserts','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','va','38',NULL,NULL,NULL,'80','80',NULL,'Low',NULL,NULL,'Unit','0','','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,'butterscotch icecream',40.00,50,'Desserts','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','bu','39',NULL,NULL,NULL,'80','80',NULL,'Low',NULL,NULL,'Unit','0','','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'butterscotch cake',35.00,50,'Desserts','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','bu','40',NULL,NULL,NULL,'80','80',NULL,'Low',NULL,NULL,'Unit','0','','','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'DEMO456',567.00,3,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','DE','',NULL,NULL,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 `items_temp_list` (`_id`, `itemname`, `avg_price`, `min_price`, `max_price`, `total_qty`, `total_price`, `barcode`, `not_required`) VALUES (1,'upma','25.0','25.0','25.0','7.0','175.0','4',''),(2,'dosa','21.0','21.0','21.0','2.0','42.0','2',''),(3,'poori','12.0','12.0','12.0','2.0','24.0','5',''),(4,'onion dosa','23.0','23.0','23.0','1.0','23.0','8',''),(5,'pav bhajji','12.0','12.0','12.0','1.0','12.0','17','');
INSERT INTO `itemsort` (`_id`, `itemsorttype`) VALUES (1,'Sort by Date added');
INSERT INTO `kot_print` (`_id`, `kot_print_status`) VALUES (1,'Yes');
INSERT INTO `loyalty_points` (`_id`, `money`, `point`, `point2`, `money2`) VALUES (1,'200','= 1 Point','1 Point =','200');
INSERT INTO `loyalty_points_status` (`_id`, `status`) VALUES (1,'Yes');
INSERT INTO `menulogin_checking` (`_id`, `status`) VALUES (1,'no');
INSERT INTO `modifiers` (`_id`, `modifiername`, `modprice`, `modstockquan`, `modcategory`, `moditemtax`, `modimage`, `mod_image_text`) VALUES (1,'potato masala',10,50,'Tiffin','None',NULL,NULL),(2,'podi',0,50,'Tiffin','None',NULL,NULL),(3,'cheese',15,35,'Tiffin','None',NULL,NULL),(4,'butter',10,40,'Tiffin','None',NULL,NULL),(5,'omlette',10,50,'Tiffin','None',NULL,NULL),(6,'cheese dip',20,50,'Snacks','None',NULL,NULL),(7,'potato fry',25,50,'Main course','None',NULL,NULL),(8,'chicken fry',40,45,'Main course','None',NULL,NULL),(9,'soda',6,50,'Main course','None',NULL,NULL),(10,'dessert',15,35,'Main course','None',NULL,NULL),(11,'medium',5,50,'Drinks','None',NULL,NULL),(12,'large',10,50,'Drinks','None',NULL,NULL),(13,'cream',20,50,'Desserts','None',NULL,NULL),(14,'chocolate',20,50,'Desserts','None',NULL,NULL);
INSERT INTO `name_dept1` (`_id`, `dept1_name`) VALUES (1,'kot1');
INSERT INTO `name_dept2` (`_id`, `dept2_name`) VALUES (1,'kot2');
INSERT INTO `name_dept3` (`_id`, `dept3_name`) VALUES (1,'kot3');
INSERT INTO `name_dept4` (`_id`, `dept4_name`) VALUES (1,'kot4');
INSERT INTO `ordertaking_server_ip` (`_id`, `ipname`, `port`, `status`) VALUES (1,'192.168.1.100','8080','');
INSERT INTO `paytmmerchantreg` (`_id`, `Account`, `MerchantName`, `guid`, `MID`, `Merchant_key`, `PosID`) VALUES (1,'Not_Registered','','','','','');
INSERT INTO `printer_text_size` (`_id`, `type`) VALUES (1,'Standard');
INSERT INTO `printer_type` (`_id`, `printer_type`) VALUES (1,'Generic');
INSERT INTO `printerreceiptsize` (`_id`, `papersize`) VALUES (1,'3 inch');
INSERT INTO `razorpaymerchantreg` (`_id`, `account`, `account_id`) VALUES (1,'Not_Registered','');
INSERT INTO `restaurant_id` (`_id`, `merchant_id`) VALUES (1,'2021');
INSERT INTO `round_off` (`_id`, `round_off_status`) VALUES (1,'Yes');
INSERT INTO `schedule_mail_on_off` (`_id`, `status`) VALUES (1,'Off');
INSERT INTO `schedule_mail_time` (`_id`, `time`) VALUES (1,'11:30 AM');
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,'Butterscotch cake','20','priyankadinein','store1','device1',NULL,NULL,'06:58 PM','15 Dec 2022','20221215185849'),(2,'veg biriyani','7','rohithdine','dev3','poss3','dev3','devs1','11:40 AM','01 Sep 2023','20230901114018'),(3,'veg biriyani','9','rohithdine','dev3','poss3','dev3','devs1','11:44 AM','01 Sep 2023','20230901114454'),(4,'veg thali','8','rohithdine','dev3','poss3','dev3','devs1','11:46 AM','01 Sep 2023','20230901114632'),(5,'idly','2','priyankadinein','store1','device1','store2','oneplus6t','04:54 PM','Oct 30, 2023','20231030165419'),(6,'idly','2','priyankadinein','store1','device1','store2','oneplus6t','04:54 PM','Oct 30, 2023','20231030165419'),(7,'idly','2','priyankadinein','store1','device1','store2','oneplus6t','04:54 PM','Oct 30, 2023','20231030165419'),(8,'idly','2','priyankadinein','store1','device1','store2','oneplus6t','04:54 PM','Oct 30, 2023','20231030165419'),(9,'idly','2','priyankadinein','store1','device1','store2','oneplus6t','04:54 PM','Oct 30, 2023','20231030165419'),(10,'idly','2','priyankadinein','store1','device1','store2','oneplus6t','04:54 PM','Oct 30, 2023','20231030165419'),(11,'idly','2','priyankadinein','store1','device1','store2','oneplus6t','04:54 PM','Oct 30, 2023','20231030165419'),(12,'idly','2','priyankadinein','store1','device1','store2','oneplus6t','04:54 PM','Oct 30, 2023','20231030165419'),(13,'idly','2','priyankadinein','store1','device1','store2','oneplus6t','04:54 PM','Oct 30, 2023','20231030165419'),(14,'idly','2','priyankadinein','store1','device1','store2','oneplus6t','04:54 PM','Oct 30, 2023','20231030165419'),(15,'idly','2','priyankadinein','store1','device1','store2','oneplus6t','04:54 PM','Oct 30, 2023','20231030165419'),(16,'idly','2','priyankadinein','store1','device1','store2','oneplus6t','04:54 PM','Oct 30, 2023','20231030165419'),(17,'idly','2','priyankadinein','store1','device1','store2','oneplus6t','04:54 PM','Oct 30, 2023','20231030165419'),(18,'idly','2','priyankadinein','store1','device1','store2','oneplus6t','04:54 PM','Oct 30, 2023','20231030165419'),(19,'idly','2','priyankadinein','store1','device1','store2','oneplus6t','04:54 PM','Oct 30, 2023','20231030165419'),(20,'idly','8','priyankadinein','store1','device1','store2','oneplus6t','01:32 PM','Dec 13, 2023','20231213133215'),(21,'idly','8','priyankadinein','store1','device1','store2','oneplus6t','01:32 PM','Dec 13, 2023','20231213133215'),(22,'idly','8','priyankadinein','store1','device1','store2','oneplus6t','01:32 PM','Dec 13, 2023','20231213133215'),(23,'idly','8','priyankadinein','store1','device1','store2','oneplus6t','01:32 PM','Dec 13, 2023','20231213133215'),(24,'idly','8','priyankadinein','store1','device1','store2','oneplus6t','01:32 PM','Dec 13, 2023','20231213133215'),(25,'idly','8','priyankadinein','store1','device1','store2','oneplus6t','01:32 PM','Dec 13, 2023','20231213133215'),(26,'idly','8','priyankadinein','store1','device1','store2','oneplus6t','01:32 PM','Dec 13, 2023','20231213133215'),(27,'idly','8','priyankadinein','store1','device1','store2','oneplus6t','01:32 PM','Dec 13, 2023','20231213133215'),(28,'idly','8','priyankadinein','store1','device1','store2','oneplus6t','01:32 PM','Dec 13, 2023','20231213133215'),(29,'idly','8','priyankadinein','store1','device1','store2','oneplus6t','01:32 PM','Dec 13, 2023','20231213133215'),(30,'idly','8','priyankadinein','store1','device1','store2','oneplus6t','01:32 PM','Dec 13, 2023','20231213133215'),(31,'idly','8','priyankadinein','store1','device1','store2','oneplus6t','01:32 PM','Dec 13, 2023','20231213133215'),(32,'idly','8','priyankadinein','store1','device1','store2','oneplus6t','01:32 PM','Dec 13, 2023','20231213133215'),(33,'idly','8','priyankadinein','store1','device1','store2','oneplus6t','01:32 PM','Dec 13, 2023','20231213133215'),(34,'idly','8','priyankadinein','store1','device1','store2','oneplus6t','01:32 PM','Dec 13, 2023','20231213133215'),(35,'idly','8','priyankadinein','store1','device1','store2','oneplus6t','01:50 PM','Dec 13, 2023','20231213135056'),(36,'idly','8','priyankadinein','store1','device1','store2','oneplus6t','01:50 PM','Dec 13, 2023','20231213135056'),(37,'idly','8','priyankadinein','store1','device1','store2','oneplus6t','01:50 PM','Dec 13, 2023','20231213135056'),(38,'idly','8','priyankadinein','store1','device1','store2','oneplus6t','01:50 PM','Dec 13, 2023','20231213135056'),(39,'idly','8','priyankadinein','store1','device1','store2','oneplus6t','01:50 PM','Dec 13, 2023','20231213135056'),(40,'idly','8','priyankadinein','store1','device1','store2','oneplus6t','01:50 PM','Dec 13, 2023','20231213135056'),(41,'idly','8','priyankadinein','store1','device1','store2','oneplus6t','01:50 PM','Dec 13, 2023','20231213135056'),(42,'idly','8','priyankadinein','store1','device1','store2','oneplus6t','01:50 PM','Dec 13, 2023','20231213135056'),(43,'idly','8','priyankadinein','store1','device1','store2','oneplus6t','01:50 PM','Dec 13, 2023','20231213135056'),(44,'idly','8','priyankadinein','store1','device1','store2','oneplus6t','01:50 PM','Dec 13, 2023','20231213135056'),(45,'idly','8','priyankadinein','store1','device1','store2','oneplus6t','01:50 PM','Dec 13, 2023','20231213135056'),(46,'idly','8','priyankadinein','store1','device1','store2','oneplus6t','01:50 PM','Dec 13, 2023','20231213135056'),(47,'idly','8','priyankadinein','store1','device1','store2','oneplus6t','01:50 PM','Dec 13, 2023','20231213135056'),(48,'idly','8','priyankadinein','store1','device1','store2','oneplus6t','01:50 PM','Dec 13, 2023','20231213135056'),(49,'idly','8','priyankadinein','store1','device1','store2','oneplus6t','01:50 PM','Dec 13, 2023','20231213135056'),(50,'pongal','10','priyankadinein','store1','device1','priyankadinein','oneplus6t','04:15 PM','Dec 13, 2023','20231213161544'),(51,'idly','12','priyankadinein','store1','device1','store2','oneplus6t','04:16 PM','Dec 13, 2023','20231213161615'),(52,'idly','12','priyankadinein','store1','device1','store2','oneplus6t','04:16 PM','Dec 13, 2023','20231213161615'),(53,'idly','12','priyankadinein','store1','device1','store2','oneplus6t','04:16 PM','Dec 13, 2023','20231213161615'),(54,'idly','12','priyankadinein','store1','device1','store2','oneplus6t','04:16 PM','Dec 13, 2023','20231213161615'),(55,'idly','12','priyankadinein','store1','device1','store2','oneplus6t','04:16 PM','Dec 13, 2023','20231213161615'),(56,'idly','12','priyankadinein','store1','device1','store2','oneplus6t','04:16 PM','Dec 13, 2023','20231213161615'),(57,'idly','12','priyankadinein','store1','device1','store2','oneplus6t','04:16 PM','Dec 13, 2023','20231213161615'),(58,'idly','12','priyankadinein','store1','device1','store2','oneplus6t','04:16 PM','Dec 13, 2023','20231213161615'),(59,'idly','12','priyankadinein','store1','device1','store2','oneplus6t','04:16 PM','Dec 13, 2023','20231213161615'),(60,'idly','12','priyankadinein','store1','device1','store2','oneplus6t','04:16 PM','Dec 13, 2023','20231213161615'),(61,'idly','12','priyankadinein','store1','device1','store2','oneplus6t','04:16 PM','Dec 13, 2023','20231213161615'),(62,'idly','12','priyankadinein','store1','device1','store2','oneplus6t','04:16 PM','Dec 13, 2023','20231213161615'),(63,'idly','12','priyankadinein','store1','device1','store2','oneplus6t','04:16 PM','Dec 13, 2023','20231213161615'),(64,'idly','12','priyankadinein','store1','device1','store2','oneplus6t','04:16 PM','Dec 13, 2023','20231213161615'),(65,'idly','12','priyankadinein','store1','device1','store2','oneplus6t','04:16 PM','Dec 13, 2023','20231213161615'),(66,'upma','20','priyankadinein','store1','device1','store2','oneplus6t','04:18 PM','Dec 13, 2023','20231213161817'),(67,'upma','20','priyankadinein','store1','device1','store2','oneplus6t','04:18 PM','Dec 13, 2023','20231213161817'),(68,'upma','20','priyankadinein','store1','device1','store2','oneplus6t','04:18 PM','Dec 13, 2023','20231213161817'),(69,'upma','20','priyankadinein','store1','device1','store2','oneplus6t','04:18 PM','Dec 13, 2023','20231213161817'),(70,'upma','20','priyankadinein','store1','device1','store2','oneplus6t','04:18 PM','Dec 13, 2023','20231213161817'),(71,'upma','20','priyankadinein','store1','device1','store2','oneplus6t','04:18 PM','Dec 13, 2023','20231213161817'),(72,'upma','20','priyankadinein','store1','device1','store2','oneplus6t','04:18 PM','Dec 13, 2023','20231213161817'),(73,'upma','20','priyankadinein','store1','device1','store2','oneplus6t','04:18 PM','Dec 13, 2023','20231213161817'),(74,'upma','20','priyankadinein','store1','device1','store2','oneplus6t','04:18 PM','Dec 13, 2023','20231213161817'),(75,'upma','20','priyankadinein','store1','device1','store2','oneplus6t','04:18 PM','Dec 13, 2023','20231213161817'),(76,'upma','20','priyankadinein','store1','device1','store2','oneplus6t','04:18 PM','Dec 13, 2023','20231213161817'),(77,'upma','20','priyankadinein','store1','device1','store2','oneplus6t','04:18 PM','Dec 13, 2023','20231213161817'),(78,'upma','20','priyankadinein','store1','device1','store2','oneplus6t','04:18 PM','Dec 13, 2023','20231213161817'),(79,'upma','20','priyankadinein','store1','device1','store2','oneplus6t','04:18 PM','Dec 13, 2023','20231213161817'),(80,'upma','20','priyankadinein','store1','device1','store2','oneplus6t','04:18 PM','Dec 13, 2023','20231213161817'),(81,'pongal','2','priyankadinein','store1','device1','store3','oneplus6t','04:20 PM','Dec 13, 2023','20231213162011'),(82,'idly','5','priyankadinein','priyankadinein','oneplus6t','store1','device1','04:22 PM','Dec 13, 2023','20231213162254'),(83,'poori','8','priyankadinein','store1','device1','store2','oneplus6t','10:36 AM','Dec 14, 2023','20231214103631'),(84,'poori','8','priyankadinein','store1','device1','store2','oneplus6t','10:36 AM','Dec 14, 2023','20231214103631'),(85,'poori','8','priyankadinein','store1','device1','store2','oneplus6t','10:36 AM','Dec 14, 2023','20231214103631'),(86,'poori','8','priyankadinein','store1','device1','store2','oneplus6t','10:36 AM','Dec 14, 2023','20231214103631'),(87,'poori','8','priyankadinein','store1','device1','store2','oneplus6t','10:36 AM','Dec 14, 2023','20231214103631'),(88,'poori','8','priyankadinein','store1','device1','store2','oneplus6t','10:36 AM','Dec 14, 2023','20231214103631'),(89,'poori','8','priyankadinein','store1','device1','store2','oneplus6t','10:36 AM','Dec 14, 2023','20231214103631'),(90,'poori','8','priyankadinein','store1','device1','store2','oneplus6t','10:36 AM','Dec 14, 2023','20231214103631'),(91,'poori','8','priyankadinein','store1','device1','store2','oneplus6t','10:36 AM','Dec 14, 2023','20231214103631'),(92,'poori','8','priyankadinein','store1','device1','store2','oneplus6t','10:36 AM','Dec 14, 2023','20231214103631'),(93,'poori','8','priyankadinein','store1','device1','store2','oneplus6t','10:36 AM','Dec 14, 2023','20231214103631'),(94,'poori','8','priyankadinein','store1','device1','store2','oneplus6t','10:36 AM','Dec 14, 2023','20231214103631'),(95,'poori','8','priyankadinein','store1','device1','store2','oneplus6t','10:36 AM','Dec 14, 2023','20231214103631'),(96,'poori','8','priyankadinein','store1','device1','store2','oneplus6t','10:36 AM','Dec 14, 2023','20231214103631'),(97,'poori','8','priyankadinein','store1','device1','store2','oneplus6t','10:36 AM','Dec 14, 2023','20231214103631'),(98,'masal dosa','5','priyankadinein','priyankadinein','oneplus6t','store1','device1','10:40 AM','Dec 14, 2023','20231214104007'),(99,'idly','12','priyankadinein','store1','device1','store2','oneplus6t','09:29 AM','Dec 22, 2023','20231222092901'),(100,'idly','12','priyankadinein','store1','device1','store2','oneplus6t','09:29 AM','Dec 22, 2023','20231222092901'),(101,'idly','12','priyankadinein','store1','device1','store2','oneplus6t','09:29 AM','Dec 22, 2023','20231222092901'),(102,'idly','12','priyankadinein','store1','device1','store2','oneplus6t','09:29 AM','Dec 22, 2023','20231222092901'),(103,'idly','12','priyankadinein','store1','device1','store2','oneplus6t','09:29 AM','Dec 22, 2023','20231222092901'),(104,'idly','12','priyankadinein','store1','device1','store2','oneplus6t','09:29 AM','Dec 22, 2023','20231222092901'),(105,'idly','12','priyankadinein','store1','device1','store2','oneplus6t','09:29 AM','Dec 22, 2023','20231222092901'),(106,'idly','12','priyankadinein','store1','device1','store2','oneplus6t','09:29 AM','Dec 22, 2023','20231222092901'),(107,'idly','12','priyankadinein','store1','device1','store2','oneplus6t','09:29 AM','Dec 22, 2023','20231222092901'),(108,'idly','12','priyankadinein','store1','device1','store2','oneplus6t','09:29 AM','Dec 22, 2023','20231222092901'),(109,'idly','12','priyankadinein','store1','device1','store2','oneplus6t','09:29 AM','Dec 22, 2023','20231222092901'),(110,'idly','12','priyankadinein','store1','device1','store2','oneplus6t','09:29 AM','Dec 22, 2023','20231222092901'),(111,'idly','12','priyankadinein','store1','device1','store2','oneplus6t','09:29 AM','Dec 22, 2023','20231222092901'),(112,'idly','12','priyankadinein','store1','device1','store2','oneplus6t','09:29 AM','Dec 22, 2023','20231222092901'),(113,'idly','12','priyankadinein','store1','device1','store2','oneplus6t','09:29 AM','Dec 22, 2023','20231222092901');
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 `totaltables` (`_id`, `nooftables`) VALUES (1,'2');
INSERT INTO `user_privilege` (`_id`, `username`, `returns_refunds`, `product_tax`, `reports`, `settings`, `backup`, `customer`, `ingredients`, `subscriptions`) VALUES (1,'user1','no','no','no','no','no','no','no','no'),(2,'user2','no','no','no','no','no','no','no','no'),(3,'user3','no','no','no','no','no','no','no','no'),(4,'user4','no','no','no','no','no','no','no','no'),(5,'user5','no','no','no','no','no','no','no','no'),(6,'user6','no','no','no','no','no','no','no','no');
INSERT INTO `vendor_details` (`_id`, `vendor_name`, `vendor_phoneno`, `vendor_email`, `vendor_address`, `vendor_gst`) VALUES (1,'Ven1','5637016252','ven1@gmail.com','Hubli','03'),(2,'Ven2','6383628200','ven2@gmail.com','Banglore','02'),(3,'Ven3','5372902765','ven3@gmail.com','Hubli','01'),(4,'Ven4','4280253074','ven4@gmail.com','Hubli','04'),(5,'Ven5','4567801234','Ven5@gmail.com','Hyderabad','05'),(6,'vendor test','7907993209','vendor2@gmail.com','address2','gst2'),(7,'Ven6','4567801234','Ven6@gmail.com','Dharwad','06'),(8,'Ven7','4680764236','Ven7@gmail.com','Hubli','07'),(9,'Ven7','5689753226','Ven7@gmail.com','Hubli','07'),(10,'Ven7','4567801234','Ven7@gmail.com','Banashankari ','05');
INSERT INTO `vendor_details_micro` (`_id`, `vendor_name`, `vendor_phoneno`, `vendor_email`, `vendor_address`, `vendor_gst`) VALUES (1,'Abd','4567801234','Abdc@gmail.com','Banglore','45'),(2,'Xyz','7536952464','xyz@gmail.com','Hubli','3'),(3,'Ven1','5362910282','ven1@gmail.com','Hubli','6'),(4,'Ven2','5790864357','ven2@gmail.com','Hubli','02'),(5,'Ven3','5790742468','ven3@gmail.com','Mysore','3'),(6,'ven6','1236547895','ven6@gmail.com','gadag','06'),(7,'Ven7','3570096532','ven7@gmail.com','Goa','07'),(8,'Ven8','9865324570','ven8@gmail.com','Bidar','08'),(9,'Vendor6','4680764236','Ven6@gmail.com','Bihar','06'),(10,'Ven8','5689753226','Ven8@gmail.com','Mumbai','08'),(11,'Ven8','4680764236','Ven8@gmail.com','Delhi','08'),(12,'Ven8','4680764236','Ven8@gmail.com','Delhi','08'),(13,'Ven8','4567801234','Ven8@gmail.com','Hubli','08'),(14,'Ven8','4567801234','Ven8@gmail.com','Dharwad','08'),(15,'vendor trail','7283468724','vendor_trail@gmail.com','trail address','ven4gst'),(16,'Ven4','7348842227','Ven4@gmail.com','Trivendrum','45'),(17,'Ven4','4567801234','Ven4@gmail.com','Dharwad','45'),(18,'demo',NULL,'','',''),(19,'test','12345','chinnarokkam456@gmail.com','',''),(20,'test2',NULL,'','','');
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,'Ven1','5637016252','6','0.0','0','0','0','0','0.0','01:06 PM','28 Mar 2022','28 Mar 2022','202203281306','20220328','400','-400.0','400','28 Mar 2022','01:06 PM','202203281306',''),(2,'Ven1','5637016252','03','0.0','0','0','0','0','0.0','03:50 PM','01 Apr 2022','01 Apr 2022','202204011550','20220401','400','-400.0','400','01 Apr 2022','03:50 PM','202204011550',''),(3,'Ven1','5637016252','03','0.0','0','0','0','0','0.0','03:50 PM','01 Apr 2022','01 Apr 2022','202204011550','20220401','400','-400.0','400','01 Apr 2022','03:50 PM','202204011550',''),(4,'Ven1','5637016252','03','0.0','0','0','0','0','0.0','11:33 AM','26 Apr 2022','26 Apr 2022','202204261133','20220426','4200','-4200.0','4200','26 Apr 2022','11:33 AM','202204261133',''),(5,'Ven1','5637016252','01','3250','0','0','0','0','3250','07:41 AM','28 Jun 2022','28 Jun 2022','202206280741','20220628','3250','0.0','3250','28 Jun 2022','07:41 AM','202206280741',NULL),(6,'Ven1','5637016252','123252','40','0','0','0','0','40','11:51 PM','02 Jul 2022','02 Jul 2022','202207022351','20220702','0','40.0','0','02 Jul 2022','11:51 PM','202207022351',NULL),(7,'vendor test','7907993209','23654','60','0','0','0','0','60','03:41 PM','03 Jul 2022','03 Jul 2022','202207031541','20220703','0','60.0','0','03 Jul 2022','03:41 PM','202207031541',NULL),(8,'Ven5','4567801234','13','1000.0','0','0','0','0','1000.0','04:40 PM','13 Jul 2022','13 Jul 2022','202207131640','20220713','1000','0.0','1000','13 Jul 2022','04:40 PM','202207131640',''),(9,'Ven3','5372902765','14','1250.0','0','0','0','0','1250.0','04:40 PM','13 Jul 2022','13 Jul 2022','202207131640','20220713','1250','0.0','1250','13 Jul 2022','04:40 PM','202207131640',''),(10,'Ven1','5637016252','13','1500.0','0','0','0','0','1500.0','03:24 PM','14 Jul 2022','14 Jul 2022','202207141524','20220714','1500','0.0','1500','14 Jul 2022','03:24 PM','202207141524',''),(11,'Ven3','5372902765','27368','1000','0','0','0','0','1000','10:02 AM','27 Jul 2022','27 Jul 2022','202207271002','20220727','1000','0.0','1000','27 Jul 2022','10:02 AM','202207271002',NULL),(12,'Ven4','4280253074','2927','2500','0','0','0','0','2500','10:08 AM','27 Jul 2022','27 Jul 2022','202207271008','20220727','2500','0.0','2500','27 Jul 2022','10:08 AM','202207271008',NULL),(13,'Ven1','5637016252','443','40.0','0','0','0','0','40.0','09:58 AM','04 Aug 2022','04 Aug 2022','202208040958','20220804','40','0.0','40','04 Aug 2022','09:58 AM','202208040958',''),(14,'Ven2','6383628200','568','750.0','0','0','0','0','750.0','09:59 AM','04 Aug 2022','04 Aug 2022','202208040959','20220804','750','0.0','750','04 Aug 2022','09:59 AM','202208040959',''),(15,'Ven1','5637016252','568','600.0','0','0','0','0','600.0','09:59 AM','04 Aug 2022','04 Aug 2022','202208040959','20220804','600','0.0','600','04 Aug 2022','09:59 AM','202208040959',''),(16,'Ven5','4567801234','573','875.0','0','0','0','0','875.0','10:00 AM','04 Aug 2022','04 Aug 2022','202208041000','20220804','875','0.0','875','04 Aug 2022','10:00 AM','202208041000',''),(17,'Ven1','5637016252','477','1200.0','0','0','0','0','1200.0','10:01 AM','04 Aug 2022','04 Aug 2022','202208041001','20220804','1200','0.0','1200','04 Aug 2022','10:01 AM','202208041001',''),(18,'Ven1','5637016252','456','600.0','0','0','0','0','600.0','10:02 AM','04 Aug 2022','04 Aug 2022','202208041002','20220804','600','0.0','600','04 Aug 2022','10:02 AM','202208041002',''),(19,'Ven1','5637016252','356','3000.0','0','0','0','0','3000.0','03:26 PM','04 Aug 2022','04 Aug 2022','202208041526','20220804','3000','0.0','3000','04 Aug 2022','03:26 PM','202208041526',''),(20,'Ven1','5637016252','34','1000.0','0','0','0','0','1000.0','03:26 PM','04 Aug 2022','04 Aug 2022','202208041526','20220804','1000','0.0','1000','04 Aug 2022','03:26 PM','202208041526',''),(21,'Ven1','5637016252','456','1250.0','0','0','0','0','1250.0','03:41 PM','04 Aug 2022','04 Aug 2022','202208041541','20220804','1250','0.0','1250','04 Aug 2022','03:41 PM','202208041541',''),(22,'Ven5','4567801234','556','4500.0','0','0','0','0','4500.0','03:41 PM','04 Aug 2022','04 Aug 2022','202208041541','20220804','4500','0.0','4500','04 Aug 2022','03:41 PM','202208041541',''),(23,'Ven4','4280253074','567','4000.0','0','0','0','0','4000.0','03:42 PM','04 Aug 2022','04 Aug 2022','202208041542','20220804','4000','0.0','4000','04 Aug 2022','03:42 PM','202208041542',''),(24,'Ven4','4280253074','435','7500.0','0','0','0','0','7500.0','03:43 PM','04 Aug 2022','04 Aug 2022','202208041543','20220804','7500','0.0','7500','04 Aug 2022','03:43 PM','202208041543',''),(25,'Ven6','4567801234','546','13000.0','0','0','0','0','13000.0','03:43 PM','04 Aug 2022','04 Aug 2022','202208041543','20220804','13000','0.0','13000','04 Aug 2022','03:43 PM','202208041543',''),(26,'Ven7','4680764236','456','10000.0','0','0','0','0','10000.0','03:43 PM','04 Aug 2022','04 Aug 2022','202208041543','20220804','10000','0.0','10000','04 Aug 2022','03:43 PM','202208041543',''),(27,'Ven7','4680764236','567','3000.0','0','0','0','0','3000.0','03:44 PM','04 Aug 2022','04 Aug 2022','202208041544','20220804','3000','0.0','3000','04 Aug 2022','03:44 PM','202208041544',''),(28,'Ven4','4280253074','356','2000.0','0','0','0','0','2000.0','03:45 PM','04 Aug 2022','04 Aug 2022','202208041545','20220804','2000','0.0','2000','04 Aug 2022','03:45 PM','202208041545',''),(29,'Ven6','4567801234','234','2000','0','0','0','0','2000','10:17 AM','04 Aug 2022','04 Aug 2022','202208041017','20220804','2000','0.0','2000','04 Aug 2022','10:17 AM','202208041017',NULL),(30,'Ven2','6383628200','4567','2500','0','0','0','0','2500','08:05 AM','12 Sep 2022','12 Sep 2022','202209120805','20220912','2500','0.0','2500','12 Sep 2022','08:05 AM','202209120805',NULL),(31,'Ven3','5372902765','019','750.0','0','0','0','0','750.0','01:01 PM','11 Oct 2022','11 Oct 2022','202210111301','20221011','750','0.0','750','11 Oct 2022','01:01 PM','202210111301',''),(32,'Ven4','4280253074','019','1500.0','0','0','0','0','1500.0','01:01 PM','11 Oct 2022','11 Oct 2022','202210111301','20221011','1500','0.0','1500','11 Oct 2022','01:01 PM','202210111301',''),(33,'Ven1','5637016252','07','10000','0','0','0','0','10000','10:56 AM','19 Dec 2022','19 Dec 2022','202212191056','20221219','10000','0.0','10000','19 Dec 2022','10:56 AM','202212191056',NULL),(34,'Ven1','5637016252','467','15000','0','0','0','0','15000','11:44 AM','19 Dec 2022','19 Dec 2022','202212191144','20221219','15000','0.0','15000','19 Dec 2022','11:44 AM','202212191144',NULL),(35,'Ven1','5637016252','4','27600.0','0','0','0','0','27600.0','02:20 PM','10 Feb 2023','10 Feb 2023','202302101420','20230210','27600','0.0','27600','10 Feb 2023','02:20 PM','202302101420',''),(36,'Ven1','5637016252','456','1300.0','0','0','0','0','1300.0','02:59 PM','14 Feb 2023','14 Feb 2023','202302141459','20230214','1300','0.0','1300','14 Feb 2023','02:59 PM','202302141459',''),(37,'Ven2','6383628200','466','600.0','0','0','0','0','600.0','12:08 PM','20 Mar 2023','20 Mar 2023','202303201208','20230320','600','0.0','600','20 Mar 2023','12:08 PM','202303201208',''),(38,'Ven1','5637016252','5775','1750','0','0','0','0','1750','11:18 AM','21 Jul 2023','21 Jul 2023','202307211118','20230721','0','1750.0','0','21 Jul 2023','11:18 AM','202307211118',NULL),(39,'Ven5','4567801234','3637','700','0','0','0','0','700','12:17 PM','21 Jul 2023','21 Jul 2023','202307211217','20230721','700','0.0','700','21 Jul 2023','12:17 PM','202307211217',NULL),(40,'Ven2','6383628200','455','2000','0','0','0','0','2000','08:54 AM','02 Aug 2023','02 Aug 2023','202308020854','20230802','2000','0.0','2000','02 Aug 2023','08:54 AM','202308020854',NULL),(41,'Ven3','5372902765','001','700','0','0','0','0','700','08:31 AM','08 Oct 2023','08 Oct 2023','202310080831','20231008','700','0.0','700','08 Oct 2023','08:31 AM','202310080831',NULL),(42,'Ven3','5372902765','004','175.0','0','0','0','0','175.0','10:00 pm','31 Jan 2024','31 Jan 2024','202401312200','20240131','175','0.0','175','31 Jan 2024','10:00 pm','202401312200',''),(43,'Ven1','5637016252','','115','0','0','0','0','115','09:30 AM','14 Mar 2024','14 Mar 2024','202403140930','20240314','0','115.0','0','14 Mar 2024','09:30 AM','202403140930',NULL),(44,'Ven1','5637016252','','46','0','0','0','0','46','09:39 AM','14 Mar 2024','14 Mar 2024','202403140939','20240314','0','46.0','0','14 Mar 2024','09:39 AM','202403140939',NULL),(45,'Ven2','6383628200','','42','0','0','0','0','42','09:57 AM','14 Mar 2024','14 Mar 2024','202403140957','20240314','0','42.0','0','14 Mar 2024','09:57 AM','202403140957',NULL),(46,'Ven1','5637016252','','46','0','0','0','0','46','09:39 AM','14 Mar 2024','14 Mar 2024','202403140939','20240314','0','46.0','0','14 Mar 2024','09:39 AM','202403140939',NULL),(47,'Ven4','4280253074','','24','0','0','0','0','24','10:08 AM','14 Mar 2024','14 Mar 2024','202403141008','20240314','0','24.0','0','14 Mar 2024','10:08 AM','202403141008',NULL),(48,'Ven6','4567801234','','23','0','0','0','0','23','10:11 AM','14 Mar 2024','14 Mar 2024','202403141011','20240314','0','23.0','0','14 Mar 2024','10:11 AM','202403141011',NULL),(49,'Ven7','4567801234','','12','0','0','0','0','12','10:17 AM','14 Mar 2024','14 Mar 2024','202403141017','20240314','0','12.0','0','14 Mar 2024','10:17 AM','202403141017',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,'Ven1','5637016252','onion dosa','50','65','3250','01','3250','0','0','0','0','3250','07:41 AM','28 Jun 2022','28 Jun 2022','202206280741','20220628','3250','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'Ven1','5637016252','dosa','2','20','40','123252','40','0','0','0','0','40','11:51 PM','02 Jul 2022','02 Jul 2022','202207022351','20220702','0','40.0',NULL,NULL,NULL,NULL,NULL,NULL,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,'vendor test','7907993209','masal dosa','3','20','60','23654','60','0','0','0','0','60','03:41 PM','03 Jul 2022','03 Jul 2022','202207031541','20220703','0','60.0',NULL,NULL,NULL,NULL,NULL,NULL,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,'Ven5','4567801234','bread omlette','20','50','1000.0','13','1000.0','0','0','0','0','1000.0','04:40 PM','13 Jul 2022','13 Jul 2022','202207131640','20220713','1000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'Ven3','5372902765','rava dosa','25','50','1250.0','14','1250.0','0','0','0','0','1250.0','04:40 PM','13 Jul 2022','13 Jul 2022','202207131640','20220713','1250','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),(6,'Ven1','5637016252','poori','50','30','1500.0','13','1500.0','0','0','0','0','1500.0','03:24 PM','14 Jul 2022','14 Jul 2022','202207141524','20220714','1500','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),(7,'Ven3','5372902765','idly','20','50','1000','27368','1000','0','0','0','0','1000','10:02 AM','27 Jul 2022','27 Jul 2022','202207271002','20220727','1000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'Ven4','4280253074','idly','50','50','2500','2927','2500','0','0','0','0','2500','10:08 AM','27 Jul 2022','27 Jul 2022','202207271008','20220727','2500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'Ven1','5637016252','dosa','2','20','40.0','443','40.0','0','0','0','0','40.0','09:58 AM','04 Aug 2022','04 Aug 2022','202208040958','20220804','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),(10,'Ven2','6383628200','dosa','25','30','750.0','568','750.0','0','0','0','0','750.0','09:59 AM','04 Aug 2022','04 Aug 2022','202208040959','20220804','750','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,'Ven1','5637016252','pongal','30','20','600.0','568','600.0','0','0','0','0','600.0','09:59 AM','04 Aug 2022','04 Aug 2022','202208040959','20220804','600','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'Ven5','4567801234','upma','35','25','875.0','573','875.0','0','0','0','0','875.0','10:00 AM','04 Aug 2022','04 Aug 2022','202208041000','20220804','875','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,'Ven1','5637016252','dosa','40','30','1200.0','477','1200.0','0','0','0','0','1200.0','10:01 AM','04 Aug 2022','04 Aug 2022','202208041001','20220804','1200','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,'Ven1','5637016252','pongal','30','20','600.0','456','600.0','0','0','0','0','600.0','10:02 AM','04 Aug 2022','04 Aug 2022','202208041002','20220804','600','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'Ven1','5637016252','dosa','100','30','3000.0','356','3000.0','0','0','0','0','3000.0','03:26 PM','04 Aug 2022','04 Aug 2022','202208041526','20220804','3000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'Ven1','5637016252','pongal','50','20','1000.0','34','1000.0','0','0','0','0','1000.0','03:26 PM','04 Aug 2022','04 Aug 2022','202208041526','20220804','1000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'Ven1','5637016252','upma','50','25','1250.0','456','1250.0','0','0','0','0','1250.0','03:41 PM','04 Aug 2022','04 Aug 2022','202208041541','20220804','1250','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,'Ven5','4567801234','poori','150','30','4500.0','556','4500.0','0','0','0','0','4500.0','03:41 PM','04 Aug 2022','04 Aug 2022','202208041541','20220804','4500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'Ven4','4280253074','masal dosa','200','20','4000.0','567','4000.0','0','0','0','0','4000.0','03:42 PM','04 Aug 2022','04 Aug 2022','202208041542','20220804','4000','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,'Ven4','4280253074','bread omlette','150','50','7500.0','435','7500.0','0','0','0','0','7500.0','03:43 PM','04 Aug 2022','04 Aug 2022','202208041543','20220804','7500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'Ven6','4567801234','onion dosa','200','65','13000.0','546','13000.0','0','0','0','0','13000.0','03:43 PM','04 Aug 2022','04 Aug 2022','202208041543','20220804','13000','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,'Ven7','4680764236','rava dosa','200','50','10000.0','456','10000.0','0','0','0','0','10000.0','03:43 PM','04 Aug 2022','04 Aug 2022','202208041543','20220804','10000','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,'Ven7','4680764236','uthappam','100','30','3000.0','567','3000.0','0','0','0','0','3000.0','03:44 PM','04 Aug 2022','04 Aug 2022','202208041544','20220804','3000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'Ven4','4280253074','vada','100','20','2000.0','356','2000.0','0','0','0','0','2000.0','03:45 PM','04 Aug 2022','04 Aug 2022','202208041545','20220804','2000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'Ven6','4567801234','masal vada','100','20','2000','234','2000','0','0','0','0','2000','10:17 AM','04 Aug 2022','04 Aug 2022','202208041017','20220804','2000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'Ven2','6383628200','vada','100','25','2500','4567','2500','0','0','0','0','2500','08:05 AM','12 Sep 2022','12 Sep 2022','202209120805','20220912','2500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'Ven3','5372902765','upma','30','25','750.0','019','750.0','0','0','0','0','750.0','01:01 PM','11 Oct 2022','11 Oct 2022','202210111301','20221011','750','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,'Ven4','4280253074','poori','50','30','1500.0','019','1500.0','0','0','0','0','1500.0','01:01 PM','11 Oct 2022','11 Oct 2022','202210111301','20221011','1500','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,'Ven1','5637016252','Butterscotch cake','20','500','10000','07','10000','0','0','0','0','10000','10:56 AM','19 Dec 2022','19 Dec 2022','202212191056','20221219','10000','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,'Ven1','5637016252','Butterscotch cake','30','500','15000','467','15000','0','0','0','0','15000','11:44 AM','19 Dec 2022','19 Dec 2022','202212191144','20221219','15000','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,'Ven1','5637016252','chicken nuggets','40','690','27600.0','4','27600.0','0','0','0','0','27600.0','02:20 PM','10 Feb 2023','10 Feb 2023','202302101420','20230210','27600','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,'Ven1','5637016252','onion dosa','20','65','1300.0','456','1300.0','0','0','0','0','1300.0','02:59 PM','14 Feb 2023','14 Feb 2023','202302141459','20230214','1300','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,'Ven1','5637016252','onion dosa','20','65','1300.0','456','1300.0','0','0','0','0','1300.0','02:59 PM','14 Feb 2023','14 Feb 2023','202302141459','20230214','1300','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,'Ven2','6383628200','dosa','20','30','600.0','466','600.0','0','0','0','0','600.0','12:08 PM','20 Mar 2023','20 Mar 2023','202303201208','20230320','600','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,'Ven1','5637016252','idly','50','35','1750','5775','1750','0','0','0','0','1750','11:18 AM','21 Jul 2023','21 Jul 2023','202307211118','20230721','0','1750.0',NULL,NULL,NULL,NULL,NULL,NULL,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,'Ven5','4567801234','idly','20','35','700','3637','700','0','0','0','0','700','12:18 PM','21 Jul 2023','21 Jul 2023','202307211218','20230721','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),(37,'Ven2','6383628200','dosa','40','50','2000','455','2000','0','0','0','0','2000','08:54 AM','02 Aug 2023','02 Aug 2023','202308020854','20230802','2000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'Ven3','5372902765','pongal','20','35','700','001','700','0','0','0','0','700','08:31 AM','08 Oct 2023','08 Oct 2023','202310080831','20231008','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),(39,'Ven3','5372902765','upma','7','25','175.0','004','175.0','0','0','0','0','175.0','10:00 pm','31 Jan 2024','31 Jan 2024','202401312200','20240131','175','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'Ven1','5637016252','idly','05','23','115','','115','0','0','0','0','115','09:30 AM','14 Mar 2024','14 Mar 2024','202403140930','20240314','0','115.0',NULL,NULL,NULL,NULL,NULL,NULL,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,'Ven1','5637016252','idly','02','23','46','','46','0','0','0','0','46','09:39 AM','14 Mar 2024','14 Mar 2024','202403140939','20240314','0','46.0',NULL,NULL,NULL,NULL,NULL,NULL,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,'Ven2','6383628200','dosa','02','21','42','','42','0','0','0','0','42','09:57 AM','14 Mar 2024','14 Mar 2024','202403140957','20240314','0','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),(43,'Ven1','5637016252','idly','02','23','46','','46','0','0','0','0','46','09:39 AM','14 Mar 2024','14 Mar 2024','202403140939','20240314','0','46.0',NULL,NULL,NULL,NULL,NULL,NULL,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,'Ven4','4280253074','poori','02','12','24','','24','0','0','0','0','24','10:08 AM','14 Mar 2024','14 Mar 2024','202403141008','20240314','0','24.0',NULL,NULL,NULL,NULL,NULL,NULL,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,'Ven6','4567801234','onion dosa','01','23','23','','23','0','0','0','0','23','10:11 AM','14 Mar 2024','14 Mar 2024','202403141011','20240314','0','23.0',NULL,NULL,NULL,NULL,NULL,NULL,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,'Ven7','4567801234','pav bhajji','01','12','12','','12','0','0','0','0','12','10:17 AM','14 Mar 2024','14 Mar 2024','202403141017','20240314','0','12.0',NULL,NULL,NULL,NULL,NULL,NULL,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,'Ven1','5637016252','ven1@gmail.com','03','Hubli','0.0','800.0','-800.0','2'),(2,'Ven1','5637016252','ven1@gmail.com','03','Hubli','0.0','800.0','-800.0','2'),(3,'Ven2','6383628200','ven2@gmail.com','02','Banglore','0.0','0.0','0.0','0'),(4,'Ven1','5637016252','ven1@gmail.com','03','Hubli','0.0','800.0','-800.0','2'),(5,'Ven2','6383628200','ven2@gmail.com','02','Banglore','0.0','0.0','0.0','0'),(6,'Ven3','5372902765','ven3@gmail.com','01','Hubli','0.0','0.0','0.0','0'),(7,'Ven1','5637016252','ven1@gmail.com','03','Hubli','0.0','800.0','-800.0','2'),(8,'Ven2','6383628200','ven2@gmail.com','02','Banglore','0.0','0.0','0.0','0'),(9,'Ven3','5372902765','ven3@gmail.com','01','Hubli','0.0','0.0','0.0','0'),(10,'Ven1','5637016252','ven1@gmail.com','03','Hubli','0.0','1200.0','-1200.0','2'),(11,'Ven2','6383628200','ven2@gmail.com','02','Banglore','0.0','0.0','0.0','0'),(12,'Ven3','5372902765','ven3@gmail.com','01','Hubli','0.0','0.0','0.0','0'),(13,'Ven1','5637016252','ven1@gmail.com','03','Hubli','0.0','1200.0','-1200.0','2'),(14,'Ven2','6383628200','ven2@gmail.com','02','Banglore','0.0','0.0','0.0','0'),(15,'Ven3','5372902765','ven3@gmail.com','01','Hubli','0.0','0.0','0.0','0'),(16,'Ven1','5637016252','ven1@gmail.com','03','Hubli','0.0','1200.0','-1200.0','2'),(17,'Ven2','6383628200','ven2@gmail.com','02','Banglore','0.0','0.0','0.0','0'),(18,'Ven3','5372902765','ven3@gmail.com','01','Hubli','0.0','0.0','0.0','0'),(22,'Ven1','5637016252','ven1@gmail.com','01','Hubli','0.0','1200.0','-1200.0','2'),(23,'Ven2','6383628200','ven2@gmail.com','02','Banglore','0.0','0.0','0.0','0'),(24,'Ven3','5372902765','ven3@gmail.com','03','Hubli','0.0','0.0','0.0','0'),(25,'Ven1','5637016252','ven1@gmail.com','03','Hubli','0.0','5400.0','-5400.0','3'),(26,'Ven2','6383628200','ven2@gmail.com','02','Banglore','0.0','0.0','0.0','0'),(27,'Ven3','5372902765','ven3@gmail.com','01','Hubli','0.0','0.0','0.0','0'),(28,'Ven1','5637016252','ven1@gmail.com','03','Hubli','0.0','5400.0','-5400.0','3'),(29,'Ven2','6383628200','ven2@gmail.com','02','Banglore','0.0','0.0','0.0','0'),(30,'Ven3','5372902765','ven3@gmail.com','01','Hubli','0.0','0.0','0.0','0'),(31,'Ven1','5637016252','ven1@gmail.com','03','Hubli','0.0','5400.0','-5400.0','3'),(32,'Ven2','6383628200','ven2@gmail.com','02','Banglore','0.0','0.0','0.0','0'),(33,'Ven3','5372902765','ven3@gmail.com','01','Hubli','0.0','0.0','0.0','0'),(37,'Ven1','5637016252','ven1@gmail.com','03','Hubli','0.0','5400.0','-5400.0','3'),(38,'Ven2','6383628200','ven2@gmail.com','02','Banglore','0.0','0.0','0.0','0'),(39,'Ven3','5372902765','ven3@gmail.com','01','Hubli','0.0','0.0','0.0','0'),(40,'Ven1','5637016252','ven1@gmail.com','03','Hubli','0.0','5400.0','-5400.0','3'),(41,'Ven2','6383628200','ven2@gmail.com','02','Banglore','0.0','0.0','0.0','0'),(42,'Ven3','5372902765','ven3@gmail.com','01','Hubli','0.0','0.0','0.0','0'),(43,'Ven1','5637016252','ven1@gmail.com','03','Hubli','0.0','5400.0','-5400.0','3'),(44,'Ven2','6383628200','ven2@gmail.com','02','Banglore','0.0','0.0','0.0','0'),(45,'Ven3','5372902765','ven3@gmail.com','01','Hubli','0.0','0.0','0.0','0'),(46,'Ven1','5637016252','ven1@gmail.com','03','Hubli','0.0','5400.0','-5400.0','3'),(47,'Ven2','6383628200','ven2@gmail.com','02','Banglore','0.0','0.0','0.0','0'),(48,'Ven3','5372902765','ven3@gmail.com','01','Hubli','0.0','0.0','0.0','0'),(49,'Ven1','5637016252','ven1@gmail.com','03','Hubli','0.0','5400.0','-5400.0','3'),(50,'Ven2','6383628200','ven2@gmail.com','02','Banglore','0.0','0.0','0.0','0'),(51,'Ven3','5372902765','ven3@gmail.com','01','Hubli','0.0','0.0','0.0','0'),(52,'Ven1','5637016252','ven1@gmail.com','03','Hubli','0.0','5400.0','-5400.0','3'),(53,'Ven2','6383628200','ven2@gmail.com','02','Banglore','0.0','0.0','0.0','0'),(54,'Ven3','5372902765','ven3@gmail.com','01','Hubli','0.0','0.0','0.0','0'),(55,'Ven1','5637016252','ven1@gmail.com','03','Hubli','0.0','5400.0','-5400.0','3'),(56,'Ven2','6383628200','ven2@gmail.com','02','Banglore','0.0','0.0','0.0','0'),(57,'Ven3','5372902765','ven3@gmail.com','01','Hubli','0.0','0.0','0.0','0'),(58,'Ven4','4280253074','ven4@gmail.com','04','Hubli','0.0','0.0','0.0','0'),(59,'Ven1','5637016252','ven1@gmail.com','03','Hubli','0.0','5400.0','-5400.0','3'),(60,'Ven2','6383628200','ven2@gmail.com','02','Banglore','0.0','0.0','0.0','0'),(61,'Ven3','5372902765','ven3@gmail.com','01','Hubli','0.0','0.0','0.0','0'),(62,'Ven4','4280253074','ven4@gmail.com','04','Hubli','0.0','0.0','0.0','0'),(63,'Ven1','5637016252','ven1@gmail.com','03','Hubli','0.0','5400.0','-5400.0','3'),(64,'Ven2','6383628200','ven2@gmail.com','02','Banglore','0.0','0.0','0.0','0'),(65,'Ven3','5372902765','ven3@gmail.com','01','Hubli','0.0','0.0','0.0','0'),(66,'Ven4','4280253074','ven4@gmail.com','04','Hubli','0.0','0.0','0.0','0'),(67,'Ven1','5637016252','ven1@gmail.com','03','Hubli','0.0','5400.0','-5400.0','3'),(68,'Ven2','6383628200','ven2@gmail.com','02','Banglore','0.0','0.0','0.0','0'),(69,'Ven3','5372902765','ven3@gmail.com','01','Hubli','0.0','0.0','0.0','0'),(70,'Ven4','4280253074','ven4@gmail.com','04','Hubli','0.0','0.0','0.0','0'),(71,'Ven1','5637016252','ven1@gmail.com','03','Hubli','4790.0','10150.0','-5360.0','6'),(72,'Ven2','6383628200','ven2@gmail.com','02','Banglore','0.0','0.0','0.0','0'),(73,'Ven3','5372902765','ven3@gmail.com','01','Hubli','1000.0','1250.0','-250.0','1'),(74,'Ven4','4280253074','ven4@gmail.com','04','Hubli','0.0','0.0','0.0','0'),(75,'Ven5','4567801234','Ven5@gmail.com','05','Hyderabad','1000.0','1000.0','0.0','1'),(76,'vendor test','7907993209','vendor2@gmail.com','gst2','address2','60.0','0.0','60.0','1'),(77,'Ven1','5637016252','ven1@gmail.com','03','Hubli','7380.0','12590.0','-5210.0','10'),(78,'Ven2','6383628200','ven2@gmail.com','02','Banglore','750.0','750.0','0.0','1'),(79,'Ven3','5372902765','ven3@gmail.com','01','Hubli','2000.0','2250.0','-250.0','2'),(80,'Ven4','4280253074','ven4@gmail.com','04','Hubli','2500.0','2500.0','0.0','1'),(81,'Ven5','4567801234','Ven5@gmail.com','05','Hyderabad','1875.0','1875.0','0.0','2'),(82,'vendor test','7907993209','vendor2@gmail.com','gst2','address2','60.0','0.0','60.0','1'),(83,'Ven6','4567801234','Ven6@gmail.com','06','Dharwad','0.0','0.0','0.0','0'),(84,'Ven7','4680764236','Ven7@gmail.com','07','Hubli','0.0','0.0','0.0','0'),(85,'Ven7','5689753226','Ven7@gmail.com','07','Hubli','0.0','0.0','0.0','0'),(86,'Ven1','5637016252','ven1@gmail.com','03','Hubli','11630.0','17840.0','-6210.0','12'),(87,'Ven2','6383628200','ven2@gmail.com','02','Banglore','3250.0','3250.0','0.0','2'),(88,'Ven3','5372902765','ven3@gmail.com','01','Hubli','2750.0','3000.0','-250.0','3'),(89,'Ven4','4280253074','ven4@gmail.com','04','Hubli','16750.0','17500.0','-750.0','5'),(90,'Ven5','4567801234','Ven5@gmail.com','05','Hyderabad','3125.0','6375.0','-3250.0','3'),(91,'vendor test','7907993209','vendor2@gmail.com','gst2','address2','60.0','0.0','60.0','1'),(92,'Ven6','4567801234','Ven6@gmail.com','06','Dharwad','9500.0','15000.0','-5500.0','2'),(93,'Ven7','4680764236','Ven7@gmail.com','07','Hubli','10500.0','13000.0','-2500.0','2'),(94,'Ven7','5689753226','Ven7@gmail.com','07','Hubli','0.0','0.0','0.0','0'),(95,'Ven7','4567801234','Ven7@gmail.com','05','Banashankari ','0.0','0.0','0.0','0'),(96,'Ven1','5637016252','ven1@gmail.com','03','Hubli','11630.0','17840.0','-6210.0','12'),(97,'Ven2','6383628200','ven2@gmail.com','02','Banglore','3250.0','3250.0','0.0','2'),(98,'Ven3','5372902765','ven3@gmail.com','01','Hubli','2750.0','3000.0','-250.0','3'),(99,'Ven4','4280253074','ven4@gmail.com','04','Hubli','16750.0','17500.0','-750.0','5'),(100,'Ven5','4567801234','Ven5@gmail.com','05','Hyderabad','3125.0','6375.0','-3250.0','3'),(101,'vendor test','7907993209','vendor2@gmail.com','gst2','address2','60.0','0.0','60.0','1'),(102,'Ven6','4567801234','Ven6@gmail.com','06','Dharwad','9500.0','15000.0','-5500.0','2'),(103,'Ven7','4680764236','Ven7@gmail.com','07','Hubli','10500.0','13000.0','-2500.0','2'),(104,'Ven7','5689753226','Ven7@gmail.com','07','Hubli','0.0','0.0','0.0','0'),(105,'Ven7','4567801234','Ven7@gmail.com','05','Banashankari ','0.0','0.0','0.0','0'),(106,'Ven1','5637016252','ven1@gmail.com','03','Hubli','11630.0','17840.0','-6210.0','12'),(107,'Ven2','6383628200','ven2@gmail.com','02','Banglore','3250.0','3250.0','0.0','2'),(108,'Ven3','5372902765','ven3@gmail.com','01','Hubli','2750.0','3000.0','-250.0','3'),(109,'Ven4','4280253074','ven4@gmail.com','04','Hubli','16750.0','17500.0','-750.0','5'),(110,'Ven5','4567801234','Ven5@gmail.com','05','Hyderabad','3125.0','6375.0','-3250.0','3'),(111,'vendor test','7907993209','vendor2@gmail.com','gst2','address2','60.0','0.0','60.0','1'),(112,'Ven6','4567801234','Ven6@gmail.com','06','Dharwad','9500.0','15000.0','-5500.0','2'),(113,'Ven7','4680764236','Ven7@gmail.com','07','Hubli','10500.0','13000.0','-2500.0','2'),(114,'Ven7','5689753226','Ven7@gmail.com','07','Hubli','0.0','0.0','0.0','0'),(115,'Ven7','4567801234','Ven7@gmail.com','05','Banashankari ','0.0','0.0','0.0','0'),(116,'Ven1','5637016252','ven1@gmail.com','03','Hubli','11630.0','17840.0','-6210.0','12'),(117,'Ven2','6383628200','ven2@gmail.com','02','Banglore','3250.0','3250.0','0.0','2'),(118,'Ven3','5372902765','ven3@gmail.com','01','Hubli','2750.0','3000.0','-250.0','3'),(119,'Ven4','4280253074','ven4@gmail.com','04','Hubli','16750.0','17500.0','-750.0','5'),(120,'Ven5','4567801234','Ven5@gmail.com','05','Hyderabad','3125.0','6375.0','-3250.0','3'),(121,'vendor test','7907993209','vendor2@gmail.com','gst2','address2','60.0','0.0','60.0','1'),(122,'Ven6','4567801234','Ven6@gmail.com','06','Dharwad','9500.0','15000.0','-5500.0','2'),(123,'Ven7','4680764236','Ven7@gmail.com','07','Hubli','10500.0','13000.0','-2500.0','2'),(124,'Ven7','5689753226','Ven7@gmail.com','07','Hubli','0.0','0.0','0.0','0'),(125,'Ven7','4567801234','Ven7@gmail.com','05','Banashankari ','0.0','0.0','0.0','0'),(126,'Ven1','5637016252','ven1@gmail.com','03','Hubli','11630.0','17840.0','-6210.0','12'),(127,'Ven2','6383628200','ven2@gmail.com','02','Banglore','3250.0','3250.0','0.0','2'),(128,'Ven3','5372902765','ven3@gmail.com','01','Hubli','2750.0','3000.0','-250.0','3'),(129,'Ven4','4280253074','ven4@gmail.com','04','Hubli','16750.0','17500.0','-750.0','5'),(130,'Ven5','4567801234','Ven5@gmail.com','05','Hyderabad','3125.0','6375.0','-3250.0','3'),(131,'vendor test','7907993209','vendor2@gmail.com','gst2','address2','60.0','0.0','60.0','1'),(132,'Ven6','4567801234','Ven6@gmail.com','06','Dharwad','9500.0','15000.0','-5500.0','2'),(133,'Ven7','4680764236','Ven7@gmail.com','07','Hubli','10500.0','13000.0','-2500.0','2'),(134,'Ven7','5689753226','Ven7@gmail.com','07','Hubli','0.0','0.0','0.0','0'),(135,'Ven7','4567801234','Ven7@gmail.com','05','Banashankari ','0.0','0.0','0.0','0'),(136,'Ven1','5637016252','ven1@gmail.com','03','Hubli','11630.0','17840.0','-6210.0','12'),(137,'Ven2','6383628200','ven2@gmail.com','02','Banglore','3250.0','3250.0','0.0','2'),(138,'Ven3','5372902765','ven3@gmail.com','01','Hubli','2750.0','3000.0','-250.0','3'),(139,'Ven4','4280253074','ven4@gmail.com','04','Hubli','16750.0','17500.0','-750.0','5'),(140,'Ven5','4567801234','Ven5@gmail.com','05','Hyderabad','3125.0','6375.0','-3250.0','3'),(141,'vendor test','7907993209','vendor2@gmail.com','gst2','address2','60.0','0.0','60.0','1'),(142,'Ven6','4567801234','Ven6@gmail.com','06','Dharwad','9500.0','15000.0','-5500.0','2'),(143,'Ven7','4680764236','Ven7@gmail.com','07','Hubli','10500.0','13000.0','-2500.0','2'),(144,'Ven7','5689753226','Ven7@gmail.com','07','Hubli','0.0','0.0','0.0','0'),(145,'Ven7','4567801234','Ven7@gmail.com','05','Banashankari ','0.0','0.0','0.0','0'),(146,'Ven1','5637016252','ven1@gmail.com','03','Hubli','11630.0','17840.0','-6210.0','12'),(147,'Ven2','6383628200','ven2@gmail.com','02','Banglore','3250.0','3250.0','0.0','2'),(148,'Ven3','5372902765','ven3@gmail.com','01','Hubli','2750.0','3000.0','-250.0','3'),(149,'Ven4','4280253074','ven4@gmail.com','04','Hubli','16750.0','17500.0','-750.0','5'),(150,'Ven5','4567801234','Ven5@gmail.com','05','Hyderabad','3125.0','6375.0','-3250.0','3'),(151,'vendor test','7907993209','vendor2@gmail.com','gst2','address2','60.0','0.0','60.0','1'),(152,'Ven6','4567801234','Ven6@gmail.com','06','Dharwad','9500.0','15000.0','-5500.0','2'),(153,'Ven7','4680764236','Ven7@gmail.com','07','Hubli','10500.0','13000.0','-2500.0','2'),(154,'Ven7','5689753226','Ven7@gmail.com','07','Hubli','0.0','0.0','0.0','0'),(155,'Ven7','4567801234','Ven7@gmail.com','05','Banashankari ','0.0','0.0','0.0','0'),(156,'Ven1','5637016252','ven1@gmail.com','03','Hubli','64230.0','70440.0','-6210.0','15'),(157,'Ven2','6383628200','ven2@gmail.com','02','Banglore','3250.0','3250.0','0.0','2'),(158,'Ven3','5372902765','ven3@gmail.com','01','Hubli','2750.0','3000.0','-250.0','3'),(159,'Ven4','4280253074','ven4@gmail.com','04','Hubli','16750.0','17500.0','-750.0','5'),(160,'Ven5','4567801234','Ven5@gmail.com','05','Hyderabad','3125.0','6375.0','-3250.0','3'),(161,'vendor test','7907993209','vendor2@gmail.com','gst2','address2','60.0','0.0','60.0','1'),(162,'Ven6','4567801234','Ven6@gmail.com','06','Dharwad','9500.0','15000.0','-5500.0','2'),(163,'Ven7','4680764236','Ven7@gmail.com','07','Hubli','10500.0','13000.0','-2500.0','2'),(164,'Ven7','5689753226','Ven7@gmail.com','07','Hubli','0.0','0.0','0.0','0'),(165,'Ven7','4567801234','Ven7@gmail.com','05','Banashankari ','0.0','0.0','0.0','0'),(166,'Ven1','5637016252','ven1@gmail.com','03','Hubli','64230.0','70440.0','-6210.0','15'),(167,'Ven2','6383628200','ven2@gmail.com','02','Banglore','3250.0','3250.0','0.0','2'),(168,'Ven3','5372902765','ven3@gmail.com','01','Hubli','2750.0','3000.0','-250.0','3'),(169,'Ven4','4280253074','ven4@gmail.com','04','Hubli','16750.0','17500.0','-750.0','5'),(170,'Ven5','4567801234','Ven5@gmail.com','05','Hyderabad','3125.0','6375.0','-3250.0','3'),(171,'vendor test','7907993209','vendor2@gmail.com','gst2','address2','60.0','0.0','60.0','1'),(172,'Ven6','4567801234','Ven6@gmail.com','06','Dharwad','9500.0','15000.0','-5500.0','2'),(173,'Ven7','4680764236','Ven7@gmail.com','07','Hubli','10500.0','13000.0','-2500.0','2'),(174,'Ven7','5689753226','Ven7@gmail.com','07','Hubli','0.0','0.0','0.0','0'),(175,'Ven7','4567801234','Ven7@gmail.com','05','Banashankari ','0.0','0.0','0.0','0'),(176,'Ven1','5637016252','ven1@gmail.com','03','Hubli','64230.0','70440.0','-6210.0','15'),(177,'Ven2','6383628200','ven2@gmail.com','02','Banglore','3250.0','3250.0','0.0','2'),(178,'Ven3','5372902765','ven3@gmail.com','01','Hubli','2750.0','3000.0','-250.0','3'),(179,'Ven4','4280253074','ven4@gmail.com','04','Hubli','16750.0','17500.0','-750.0','5'),(180,'Ven5','4567801234','Ven5@gmail.com','05','Hyderabad','3125.0','6375.0','-3250.0','3'),(181,'vendor test','7907993209','vendor2@gmail.com','gst2','address2','60.0','0.0','60.0','1'),(182,'Ven6','4567801234','Ven6@gmail.com','06','Dharwad','9500.0','15000.0','-5500.0','2'),(183,'Ven7','4680764236','Ven7@gmail.com','07','Hubli','10500.0','13000.0','-2500.0','2'),(184,'Ven7','5689753226','Ven7@gmail.com','07','Hubli','0.0','0.0','0.0','0'),(185,'Ven7','4567801234','Ven7@gmail.com','05','Banashankari ','0.0','0.0','0.0','0'),(186,'Ven1','5637016252','ven1@gmail.com','03','Hubli','64230.0','70440.0','-6210.0','15'),(187,'Ven2','6383628200','ven2@gmail.com','02','Banglore','3250.0','3250.0','0.0','2'),(188,'Ven3','5372902765','ven3@gmail.com','01','Hubli','2750.0','3000.0','-250.0','3'),(189,'Ven4','4280253074','ven4@gmail.com','04','Hubli','16750.0','17500.0','-750.0','5'),(190,'Ven5','4567801234','Ven5@gmail.com','05','Hyderabad','3125.0','6375.0','-3250.0','3'),(191,'vendor test','7907993209','vendor2@gmail.com','gst2','address2','60.0','0.0','60.0','1'),(192,'Ven6','4567801234','Ven6@gmail.com','06','Dharwad','9500.0','15000.0','-5500.0','2'),(193,'Ven7','4680764236','Ven7@gmail.com','07','Hubli','10500.0','13000.0','-2500.0','2'),(194,'Ven7','5689753226','Ven7@gmail.com','07','Hubli','0.0','0.0','0.0','0'),(195,'Ven7','4567801234','Ven7@gmail.com','05','Banashankari ','0.0','0.0','0.0','0'),(196,'Ven1','5637016252','ven1@gmail.com','03','Hubli','64230.0','70440.0','-6210.0','15'),(197,'Ven2','6383628200','ven2@gmail.com','02','Banglore','3250.0','3250.0','0.0','2'),(198,'Ven3','5372902765','ven3@gmail.com','01','Hubli','2750.0','3000.0','-250.0','3'),(199,'Ven4','4280253074','ven4@gmail.com','04','Hubli','16750.0','17500.0','-750.0','5'),(200,'Ven5','4567801234','Ven5@gmail.com','05','Hyderabad','3125.0','6375.0','-3250.0','3'),(201,'vendor test','7907993209','vendor2@gmail.com','gst2','address2','60.0','0.0','60.0','1'),(202,'Ven6','4567801234','Ven6@gmail.com','06','Dharwad','9500.0','15000.0','-5500.0','2'),(203,'Ven7','4680764236','Ven7@gmail.com','07','Hubli','10500.0','13000.0','-2500.0','2'),(204,'Ven7','5689753226','Ven7@gmail.com','07','Hubli','0.0','0.0','0.0','0'),(205,'Ven7','4567801234','Ven7@gmail.com','05','Banashankari ','0.0','0.0','0.0','0'),(206,'Ven1','5637016252','ven1@gmail.com','03','Hubli','64230.0','70440.0','-6210.0','15'),(207,'Ven2','6383628200','ven2@gmail.com','02','Banglore','3250.0','3250.0','0.0','2'),(208,'Ven3','5372902765','ven3@gmail.com','01','Hubli','2750.0','3000.0','-250.0','3'),(209,'Ven4','4280253074','ven4@gmail.com','04','Hubli','16750.0','17500.0','-750.0','5'),(210,'Ven5','4567801234','Ven5@gmail.com','05','Hyderabad','3125.0','6375.0','-3250.0','3'),(211,'vendor test','7907993209','vendor2@gmail.com','gst2','address2','60.0','0.0','60.0','1'),(212,'Ven6','4567801234','Ven6@gmail.com','06','Dharwad','9500.0','15000.0','-5500.0','2'),(213,'Ven7','4680764236','Ven7@gmail.com','07','Hubli','10500.0','13000.0','-2500.0','2'),(214,'Ven7','5689753226','Ven7@gmail.com','07','Hubli','0.0','0.0','0.0','0'),(215,'Ven7','4567801234','Ven7@gmail.com','05','Banashankari ','0.0','0.0','0.0','0'),(216,'Ven1','5637016252','ven1@gmail.com','03','Hubli','64230.0','70440.0','-6210.0','15'),(217,'Ven2','6383628200','ven2@gmail.com','02','Banglore','3250.0','3250.0','0.0','2'),(218,'Ven3','5372902765','ven3@gmail.com','01','Hubli','2750.0','3000.0','-250.0','3'),(219,'Ven4','4280253074','ven4@gmail.com','04','Hubli','16750.0','17500.0','-750.0','5'),(220,'Ven5','4567801234','Ven5@gmail.com','05','Hyderabad','3125.0','6375.0','-3250.0','3'),(221,'vendor test','7907993209','vendor2@gmail.com','gst2','address2','60.0','0.0','60.0','1'),(222,'Ven6','4567801234','Ven6@gmail.com','06','Dharwad','9500.0','15000.0','-5500.0','2'),(223,'Ven7','4680764236','Ven7@gmail.com','07','Hubli','10500.0','13000.0','-2500.0','2'),(224,'Ven7','5689753226','Ven7@gmail.com','07','Hubli','0.0','0.0','0.0','0'),(225,'Ven7','4567801234','Ven7@gmail.com','05','Banashankari ','0.0','0.0','0.0','0'),(226,'Ven1','5637016252','ven1@gmail.com','03','Hubli','65530.0','71740.0','-6210.0','16'),(227,'Ven2','6383628200','ven2@gmail.com','02','Banglore','3250.0','3250.0','0.0','2'),(228,'Ven3','5372902765','ven3@gmail.com','01','Hubli','2750.0','3000.0','-250.0','3'),(229,'Ven4','4280253074','ven4@gmail.com','04','Hubli','16750.0','17500.0','-750.0','5'),(230,'Ven5','4567801234','Ven5@gmail.com','05','Hyderabad','3125.0','6375.0','-3250.0','3'),(231,'vendor test','7907993209','vendor2@gmail.com','gst2','address2','60.0','0.0','60.0','1'),(232,'Ven6','4567801234','Ven6@gmail.com','06','Dharwad','9500.0','15000.0','-5500.0','2'),(233,'Ven7','4680764236','Ven7@gmail.com','07','Hubli','10500.0','13000.0','-2500.0','2'),(234,'Ven7','5689753226','Ven7@gmail.com','07','Hubli','0.0','0.0','0.0','0'),(235,'Ven7','4567801234','Ven7@gmail.com','05','Banashankari ','0.0','0.0','0.0','0'),(236,'Ven1','5637016252','ven1@gmail.com','03','Hubli','65530.0','71740.0','-6210.0','16'),(237,'Ven2','6383628200','ven2@gmail.com','02','Banglore','3250.0','3250.0','0.0','2'),(238,'Ven3','5372902765','ven3@gmail.com','01','Hubli','2750.0','3000.0','-250.0','3'),(239,'Ven4','4280253074','ven4@gmail.com','04','Hubli','16750.0','17500.0','-750.0','5'),(240,'Ven5','4567801234','Ven5@gmail.com','05','Hyderabad','3125.0','6375.0','-3250.0','3'),(241,'vendor test','7907993209','vendor2@gmail.com','gst2','address2','60.0','0.0','60.0','1'),(242,'Ven6','4567801234','Ven6@gmail.com','06','Dharwad','9500.0','15000.0','-5500.0','2'),(243,'Ven7','4680764236','Ven7@gmail.com','07','Hubli','10500.0','13000.0','-2500.0','2'),(244,'Ven7','5689753226','Ven7@gmail.com','07','Hubli','0.0','0.0','0.0','0'),(245,'Ven7','4567801234','Ven7@gmail.com','05','Banashankari ','0.0','0.0','0.0','0'),(246,'Ven1','5637016252','ven1@gmail.com','03','Hubli','67280.0','71740.0','-4460.0','17'),(247,'Ven2','6383628200','ven2@gmail.com','02','Banglore','5850.0','5850.0','0.0','4'),(248,'Ven3','5372902765','ven3@gmail.com','01','Hubli','2750.0','3000.0','-250.0','3'),(249,'Ven4','4280253074','ven4@gmail.com','04','Hubli','16750.0','17500.0','-750.0','5'),(250,'Ven5','4567801234','Ven5@gmail.com','05','Hyderabad','3825.0','7075.0','-3250.0','4'),(251,'vendor test','7907993209','vendor2@gmail.com','gst2','address2','60.0','0.0','60.0','1'),(252,'Ven6','4567801234','Ven6@gmail.com','06','Dharwad','9500.0','15000.0','-5500.0','2'),(253,'Ven7','4680764236','Ven7@gmail.com','07','Hubli','10500.0','13000.0','-2500.0','2'),(254,'Ven7','5689753226','Ven7@gmail.com','07','Hubli','0.0','0.0','0.0','0'),(255,'Ven7','4567801234','Ven7@gmail.com','05','Banashankari ','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,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','1000.0','0.0','1000.0','1'),(2,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','1000.0','0.0','1000.0','1'),(3,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(4,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','1000.0','0.0','1000.0','1'),(5,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(6,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','1000.0','0.0','1000.0','1'),(7,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(8,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','1000.0','0.0','1000.0','1'),(9,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(10,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','1000.0','1000.0','0.0','1'),(11,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(12,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','1000.0','1000.0','0.0','1'),(13,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(14,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','1000.0','1000.0','0.0','1'),(15,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(16,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','1100.0','1100.0','0.0','2'),(17,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(18,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','1100.0','1100.0','0.0','2'),(19,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(20,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','1100.0','1100.0','0.0','2'),(21,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(22,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','1100.0','1100.0','0.0','2'),(23,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(24,'Ven1','5362910282','ven1@gmail.com','6','Hubli','0.0','0.0','0.0','0'),(25,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','1100.0','1100.0','0.0','2'),(26,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(27,'Ven1','5362910282','ven1@gmail.com','6','Hubli','0.0','0.0','0.0','0'),(28,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6100.0','6100.0','0.0','3'),(29,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(30,'Ven1','5362910282','ven1@gmail.com','6','Hubli','5400.0','1300.0','4100.0','2'),(31,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6100.0','6100.0','0.0','3'),(32,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(33,'Ven1','5362910282','ven1@gmail.com','6','Hubli','5400.0','1300.0','4100.0','2'),(34,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6100.0','6100.0','0.0','3'),(35,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(36,'Ven1','5362910282','ven1@gmail.com','6','Hubli','6600.0','2500.0','4100.0','3'),(37,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6100.0','6100.0','0.0','3'),(38,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(39,'Ven1','5362910282','ven1@gmail.com','6','Hubli','6600.0','2500.0','4100.0','3'),(40,'Ven2','5790864357','ven2@gmail.com','02','Hubli','0.0','0.0','0.0','0'),(41,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6100.0','6100.0','0.0','3'),(42,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(43,'Ven1','5362910282','ven1@gmail.com','6','Hubli','6600.0','2500.0','4100.0','3'),(44,'Ven2','5790864357','ven2@gmail.com','02','Hubli','0.0','0.0','0.0','0'),(45,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6100.0','6100.0','0.0','3'),(46,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(47,'Ven1','5362910282','ven1@gmail.com','6','Hubli','6600.0','2500.0','4100.0','3'),(48,'Ven2','5790864357','ven2@gmail.com','02','Hubli','0.0','0.0','0.0','0'),(49,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6100.0','6100.0','0.0','3'),(50,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(51,'Ven1','5362910282','ven1@gmail.com','6','Hubli','6600.0','2500.0','4100.0','3'),(52,'Ven2','5790864357','ven2@gmail.com','02','Hubli','0.0','0.0','0.0','0'),(53,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6100.0','6100.0','0.0','3'),(54,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(55,'Ven1','5362910282','ven1@gmail.com','6','Hubli','6600.0','2500.0','4100.0','3'),(56,'Ven2','5790864357','ven2@gmail.com','02','Hubli','0.0','0.0','0.0','0'),(57,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6100.0','6100.0','0.0','3'),(58,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(59,'Ven1','5362910282','ven1@gmail.com','6','Hubli','6600.0','2500.0','4100.0','3'),(60,'Ven2','5790864357','ven2@gmail.com','02','Hubli','0.0','0.0','0.0','0'),(61,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6100.0','6100.0','0.0','3'),(62,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(63,'Ven1','5362910282','ven1@gmail.com','6','Hubli','6600.0','2500.0','4100.0','3'),(64,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4200.0','4200.0','0.0','1'),(65,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6100.0','6100.0','0.0','3'),(66,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(67,'Ven1','5362910282','ven1@gmail.com','6','Hubli','6600.0','2500.0','4100.0','3'),(68,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4200.0','4200.0','0.0','1'),(73,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6100.0','6100.0','0.0','3'),(74,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(75,'Ven1','5362910282','ven1@gmail.com','6','Hubli','6600.0','2500.0','4100.0','3'),(76,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4200.0','4200.0','0.0','1'),(81,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6136.0','6136.0','0.0','4'),(82,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(83,'Ven1','5362910282','ven1@gmail.com','6','Hubli','6600.0','2500.0','4100.0','3'),(84,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4200.0','4200.0','0.0','1'),(85,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6136.0','6136.0','0.0','4'),(86,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(87,'Ven1','5362910282','ven1@gmail.com','6','Hubli','6600.0','2500.0','4100.0','3'),(88,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4700.0','4700.0','0.0','2'),(89,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6136.0','6136.0','0.0','4'),(90,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(91,'Ven1','5362910282','ven1@gmail.com','6','Hubli','6600.0','2500.0','4100.0','3'),(92,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4700.0','4700.0','0.0','2'),(97,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6136.0','6136.0','0.0','4'),(98,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(99,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(100,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4700.0','4700.0','0.0','2'),(105,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6136.0','6136.0','0.0','4'),(106,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(107,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(108,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4700.0','4700.0','0.0','2'),(109,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6136.0','6136.0','0.0','4'),(110,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(111,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(112,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4700.0','4700.0','0.0','2'),(156,'Ven4','4567801234','ven4@gmail.com','4','Banglore','6136.0','6136.0','0.0','4'),(157,'Ven5','7536952464','ven5@gmail.com','5','Hubli','0.0','0.0','0.0','2'),(158,'Ven1','5362910282','ven1@gmail.com','1','Hubli','8070.0','3970.0','4100.0','4'),(159,'Ven2','5790864357','ven2@gmail.com','2','Hubli','4700.0','4700.0','0.0','2'),(160,'Ven3','5790742468','ven3@gmail.com','3','Mysore','0.0','0.0','0.0','0'),(161,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6136.0','6136.0','0.0','4'),(162,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(163,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(164,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4700.0','4700.0','0.0','2'),(165,'Ven3','5790742468','ven3@gmail.com','3','Mysore','0.0','0.0','0.0','0'),(166,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6136.0','6136.0','0.0','4'),(167,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(168,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(169,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4700.0','4700.0','0.0','2'),(170,'Ven3','5790742468','ven3@gmail.com','3','Mysore','0.0','0.0','0.0','0'),(171,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6136.0','6136.0','0.0','4'),(172,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(173,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(174,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4700.0','4700.0','0.0','2'),(175,'Ven3','5790742468','ven3@gmail.com','3','Mysore','0.0','0.0','0.0','0'),(176,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6136.0','6136.0','0.0','4'),(177,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(178,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(179,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4700.0','4700.0','0.0','2'),(180,'Ven3','5790742468','ven3@gmail.com','3','Mysore','0.0','0.0','0.0','0'),(181,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6136.0','6136.0','0.0','4'),(182,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(183,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(184,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4700.0','4700.0','0.0','2'),(185,'Ven3','5790742468','ven3@gmail.com','3','Mysore','0.0','0.0','0.0','0'),(186,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6136.0','6136.0','0.0','4'),(187,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(188,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(189,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4700.0','4700.0','0.0','2'),(190,'Ven3','5790742468','ven3@gmail.com','3','Mysore','0.0','0.0','0.0','0'),(196,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6136.0','6136.0','0.0','4'),(197,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(198,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(199,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4700.0','4700.0','0.0','2'),(200,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(201,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','7536.0','7536.0','0.0','5'),(202,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(203,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(204,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4700.0','4700.0','0.0','2'),(205,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(206,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','7536.0','7536.0','0.0','5'),(207,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(208,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(209,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4700.0','4700.0','0.0','2'),(210,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(211,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','7536.0','7536.0','0.0','5'),(212,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(213,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(214,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4700.0','4700.0','0.0','2'),(215,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(216,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','7536.0','7536.0','0.0','5'),(217,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(218,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(219,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4700.0','4700.0','0.0','2'),(220,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(221,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','7536.0','7536.0','0.0','5'),(222,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(223,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(224,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4700.0','4700.0','0.0','2'),(225,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(241,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','7536.0','7536.0','0.0','5'),(242,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(243,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(244,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4700.0','4700.0','0.0','2'),(245,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(246,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','7536.0','7536.0','0.0','5'),(247,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(248,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(249,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4700.0','4700.0','0.0','2'),(250,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(251,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','7536.0','7536.0','0.0','5'),(252,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(253,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(254,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4700.0','4700.0','0.0','2'),(255,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(256,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','7536.0','7536.0','0.0','5'),(257,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(258,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(259,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4700.0','4700.0','0.0','2'),(260,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(261,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','7536.0','7536.0','0.0','5'),(262,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(263,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(264,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4700.0','4700.0','0.0','2'),(265,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(266,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','7536.0','7536.0','0.0','5'),(267,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(268,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(269,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4700.0','4700.0','0.0','2'),(270,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(271,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','7536.0','7536.0','0.0','5'),(272,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(273,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(274,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4700.0','4700.0','0.0','2'),(275,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(281,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','7536.0','7536.0','0.0','5'),(282,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(283,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(284,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4700.0','4700.0','0.0','2'),(285,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(286,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','7536.0','7536.0','0.0','5'),(287,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(288,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(289,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(290,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(291,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','7536.0','7536.0','0.0','5'),(292,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(293,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(294,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(295,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(296,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','7536.0','7536.0','0.0','5'),(297,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(298,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(299,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(300,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(306,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','7536.0','7536.0','0.0','5'),(307,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(308,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(309,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(310,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(311,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','7536.0','7536.0','0.0','5'),(312,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(313,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(314,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(315,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(316,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','7536.0','7536.0','0.0','5'),(317,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(318,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(319,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(320,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(321,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','7536.0','7536.0','0.0','5'),(322,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(323,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(324,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(325,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(326,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','7536.0','7536.0','0.0','5'),(327,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(328,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(329,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(330,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(331,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','7536.0','7536.0','0.0','5'),(332,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(333,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(334,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(335,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(366,'Ven5','4567801234','ven5@gmail.com','05','Banglore','7536.0','7536.0','0.0','5'),(367,'Ven4','7536952464','ven4@gmail.com','04','Hubli','0.0','0.0','0.0','2'),(368,'Ven1','5362910282','ven1@gmail.com','01','Hubli','8070.0','3970.0','4100.0','4'),(369,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(370,'Ven3','5790742468','ven3@gmail.com','03','Mysore','520.0','520.0','0.0','1'),(376,'Ven5','4567801234','ven5@gmail.com','05','Banglore','7536.0','7536.0','0.0','5'),(377,'Ven4','7536952464','ven4@gmail.com','04','Hubli','0.0','0.0','0.0','2'),(378,'Ven1','5362910282','ven1@gmail.com','01','Hubli','8070.0','3970.0','4100.0','4'),(379,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(380,'Ven3','5790742468','ven3@gmail.com','03','Mysore','520.0','520.0','0.0','1'),(381,'Ven5','4567801234','ven5@gmail.com','05','Banglore','7536.0','7536.0','0.0','5'),(382,'Ven4','7536952464','ven4@gmail.com','04','Hubli','0.0','0.0','0.0','2'),(383,'Ven1','5362910282','ven1@gmail.com','01','Hubli','8070.0','3970.0','4100.0','4'),(384,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(385,'Ven3','5790742468','ven3@gmail.com','03','Mysore','520.0','520.0','0.0','1'),(386,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','7536.0','7536.0','0.0','5'),(387,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(388,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(389,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(390,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(391,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','7536.0','7536.0','0.0','5'),(392,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','2'),(393,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(394,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(395,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(401,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(402,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(403,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(404,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(405,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(406,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(407,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(408,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(409,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(410,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(411,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(412,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(413,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(414,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(415,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(416,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(417,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(418,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(419,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(420,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(421,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(422,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(423,'Ven1','5362910282','ven1@gmail.com','6','Hubli','3970.0','3970.0','0.0','4'),(424,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(425,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(426,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(427,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(428,'Ven1','5362910282','ven1@gmail.com','6','Hubli','3970.0','3970.0','0.0','4'),(429,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(430,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(431,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(432,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(433,'Ven1','5362910282','ven1@gmail.com','6','Hubli','3970.0','3970.0','0.0','4'),(434,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(435,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(436,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(437,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(438,'Ven1','5362910282','ven1@gmail.com','6','Hubli','3970.0','3970.0','0.0','4'),(439,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(440,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(441,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(442,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(443,'Ven1','5362910282','ven1@gmail.com','6','Hubli','3970.0','3970.0','0.0','4'),(444,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(445,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(446,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(447,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(448,'Ven1','5362910282','ven1@gmail.com','6','Hubli','3970.0','3970.0','0.0','4'),(449,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(450,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(451,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(452,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(453,'Ven1','5362910282','ven1@gmail.com','6','Hubli','3970.0','3970.0','0.0','4'),(454,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(455,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(456,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(457,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(458,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(459,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(460,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(461,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(462,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(463,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(464,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(465,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(466,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(467,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(468,'Ven1','5362910282','ven1@gmail.com','6','Hubli','3970.0','3970.0','0.0','4'),(469,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(470,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(471,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(472,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(473,'Ven1','5362910282','ven1@gmail.com','6','Hubli','3970.0','3970.0','0.0','4'),(474,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(475,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(476,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(477,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(478,'Ven1','5362910282','ven1@gmail.com','6','Hubli','3970.0','3970.0','0.0','4'),(479,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(480,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(481,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(482,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(483,'Ven1','5362910282','ven1@gmail.com','6','Hubli','3970.0','3970.0','0.0','4'),(484,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(485,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(486,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(487,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(488,'Ven1','5362910282','ven1@gmail.com','6','Hubli','3970.0','3970.0','0.0','4'),(489,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(490,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(491,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(492,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(493,'Ven1','5362910282','ven1@gmail.com','6','Hubli','3970.0','3970.0','0.0','4'),(494,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(495,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(496,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(497,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(498,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(499,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(500,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(501,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(502,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(503,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(504,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(505,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(506,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(507,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(508,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(509,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(510,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(511,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(512,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(513,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(514,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(515,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(516,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(517,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(518,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(519,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(520,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(536,'Ven5','4567801234','ven5@gmail.com','05','Banglore','7536.0','7536.0','0.0','5'),(537,'Ven4','7536952464','ven4@gmail.com','04','Hubli','0.0','0.0','0.0','2'),(538,'Ven1','5362910282','ven1@gmail.com','01','Hubli','3970.0','3970.0','0.0','4'),(539,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(540,'Ven3','5790742468','ven3@gmail.com','03','Mysore','520.0','520.0','0.0','1'),(541,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(542,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(543,'Ven1','5362910282','ven1@gmail.com','6','Hubli','3970.0','3970.0','0.0','4'),(544,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(545,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(546,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(547,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(548,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(549,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(550,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(551,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(552,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(553,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(554,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(555,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(556,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(557,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(558,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(559,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(560,'Ven1','5362910282','ven1@gmail.com','6','Hubli','3970.0','3970.0','0.0','4'),(561,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(562,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(563,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(564,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(565,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(566,'Ven1','5362910282','ven1@gmail.com','6','Hubli','3970.0','3970.0','0.0','4'),(567,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(568,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(569,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(570,'Ven7','3570096532','ven7@gmail.com','07','Goa','0.0','0.0','0.0','0'),(571,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(572,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(573,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(574,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(575,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(576,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(577,'Ven7','3570096532','ven7@gmail.com','07','Goa','0.0','0.0','0.0','0'),(578,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(579,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(580,'Ven1','5362910282','ven1@gmail.com','6','Hubli','3970.0','3970.0','0.0','4'),(581,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(582,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(583,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(584,'Ven7','3570096532','ven7@gmail.com','07','Goa','0.0','0.0','0.0','0'),(585,'Ven8','9865324570','ven8@gmail.com','08','Bidar','0.0','0.0','0.0','0'),(586,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(587,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(588,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(589,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(590,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(591,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(592,'Ven7','3570096532','ven7@gmail.com','07','Goa','0.0','0.0','0.0','0'),(593,'Ven8','9865324570','ven8@gmail.com','08','Bidar','0.0','0.0','0.0','0'),(594,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(595,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(596,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(597,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(598,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(599,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(600,'Ven7','3570096532','ven7@gmail.com','07','Goa','0.0','0.0','0.0','0'),(601,'Ven8','9865324570','ven8@gmail.com','08','Bidar','0.0','0.0','0.0','0'),(602,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(603,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(604,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(605,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(606,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(607,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(608,'Ven7','3570096532','ven7@gmail.com','07','Goa','0.0','0.0','0.0','0'),(609,'Ven8','9865324570','ven8@gmail.com','08','Bidar','0.0','0.0','0.0','0'),(610,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(611,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(612,'Ven1','5362910282','ven1@gmail.com','6','Hubli','3970.0','3970.0','0.0','4'),(613,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(614,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(615,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(616,'Ven7','3570096532','ven7@gmail.com','07','Goa','0.0','0.0','0.0','0'),(617,'Ven8','9865324570','ven8@gmail.com','08','Bidar','0.0','0.0','0.0','0'),(618,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(619,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(620,'Ven1','5362910282','ven1@gmail.com','6','Hubli','3970.0','3970.0','0.0','4'),(621,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(622,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(623,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(624,'Ven7','3570096532','ven7@gmail.com','07','Goa','0.0','0.0','0.0','0'),(625,'Ven8','9865324570','ven8@gmail.com','08','Bidar','0.0','0.0','0.0','0'),(626,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(627,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(628,'Ven1','5362910282','ven1@gmail.com','6','Hubli','8070.0','3970.0','4100.0','4'),(629,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(630,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(631,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(632,'Ven7','3570096532','ven7@gmail.com','07','Goa','0.0','0.0','0.0','0'),(633,'Ven8','9865324570','ven8@gmail.com','08','Bidar','0.0','0.0','0.0','0'),(642,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(643,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(644,'Ven1','5362910282','ven1@gmail.com','6','Hubli','3970.0','3970.0','0.0','4'),(645,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(646,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(647,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(648,'Ven7','3570096532','ven7@gmail.com','07','Goa','0.0','0.0','0.0','0'),(649,'Ven8','9865324570','ven8@gmail.com','08','Bidar','0.0','0.0','0.0','0'),(650,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(651,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(652,'Ven1','5362910282','ven1@gmail.com','6','Hubli','3970.0','3970.0','0.0','4'),(653,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(654,'Ven3','5790742468','ven3@gmail.com','3','Mysore','520.0','520.0','0.0','1'),(655,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(656,'Ven7','3570096532','ven7@gmail.com','07','Goa','0.0','0.0','0.0','0'),(657,'Ven8','9865324570','ven8@gmail.com','08','Bidar','0.0','0.0','0.0','0'),(658,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(659,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(660,'Ven1','5362910282','ven1@gmail.com','6','Hubli','3970.0','3970.0','0.0','4'),(661,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(662,'Ven3','5790742468','ven3@gmail.com','3','Mysore','1045.0','1045.0','0.0','2'),(663,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(664,'Ven7','3570096532','ven7@gmail.com','07','Goa','0.0','0.0','0.0','0'),(665,'Ven8','9865324570','ven8@gmail.com','08','Bidar','0.0','0.0','0.0','0'),(666,'Vendor6','4680764236','Ven6@gmail.com','06','Bihar','0.0','0.0','0.0','0'),(667,'Ven8','5689753226','Ven8@gmail.com','08','Mumbai','0.0','0.0','0.0','0'),(668,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','0.0','0.0','0.0','0'),(669,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','0.0','0.0','0.0','0'),(670,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(671,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(672,'Ven1','5362910282','ven1@gmail.com','6','Hubli','3970.0','3970.0','0.0','4'),(673,'Ven2','5790864357','ven2@gmail.com','02','Hubli','4832.0','4832.0','0.0','3'),(674,'Ven3','5790742468','ven3@gmail.com','3','Mysore','1045.0','1045.0','0.0','2'),(675,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(676,'Ven7','3570096532','ven7@gmail.com','07','Goa','0.0','0.0','0.0','0'),(677,'Ven8','9865324570','ven8@gmail.com','08','Bidar','0.0','0.0','0.0','0'),(678,'Vendor6','4680764236','Ven6@gmail.com','06','Bihar','0.0','0.0','0.0','0'),(679,'Ven8','5689753226','Ven8@gmail.com','08','Mumbai','0.0','0.0','0.0','0'),(680,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','0.0','0.0','0.0','0'),(681,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','0.0','0.0','0.0','0'),(682,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(683,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(684,'Ven1','5362910282','ven1@gmail.com','6','Hubli','3970.0','3970.0','0.0','4'),(685,'Ven2','5790864357','ven2@gmail.com','02','Hubli','5357.0','5357.0','0.0','4'),(686,'Ven3','5790742468','ven3@gmail.com','3','Mysore','1045.0','1045.0','0.0','2'),(687,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(688,'Ven7','3570096532','ven7@gmail.com','07','Goa','0.0','0.0','0.0','0'),(689,'Ven8','9865324570','ven8@gmail.com','08','Bidar','0.0','0.0','0.0','0'),(690,'Vendor6','4680764236','Ven6@gmail.com','06','Bihar','0.0','0.0','0.0','0'),(691,'Ven8','5689753226','Ven8@gmail.com','08','Mumbai','0.0','0.0','0.0','0'),(692,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','0.0','0.0','0.0','0'),(693,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','0.0','0.0','0.0','0'),(694,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(695,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(696,'Ven1','5362910282','ven1@gmail.com','6','Hubli','3970.0','3970.0','0.0','4'),(697,'Ven2','5790864357','ven2@gmail.com','02','Hubli','5357.0','5357.0','0.0','4'),(698,'Ven3','5790742468','ven3@gmail.com','3','Mysore','1045.0','1045.0','0.0','2'),(699,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(700,'Ven7','3570096532','ven7@gmail.com','07','Goa','0.0','0.0','0.0','0'),(701,'Ven8','9865324570','ven8@gmail.com','08','Bidar','525.0','525.0','0.0','1'),(702,'Vendor6','4680764236','Ven6@gmail.com','06','Bihar','0.0','0.0','0.0','0'),(703,'Ven8','5689753226','Ven8@gmail.com','08','Mumbai','0.0','0.0','0.0','0'),(704,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','0.0','0.0','0.0','0'),(705,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','0.0','0.0','0.0','0'),(706,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(707,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(708,'Ven1','5362910282','ven1@gmail.com','6','Hubli','3970.0','3970.0','0.0','4'),(709,'Ven2','5790864357','ven2@gmail.com','02','Hubli','5357.0','5357.0','0.0','4'),(710,'Ven3','5790742468','ven3@gmail.com','3','Mysore','1045.0','1045.0','0.0','2'),(711,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(712,'Ven7','3570096532','ven7@gmail.com','07','Goa','0.0','0.0','0.0','0'),(713,'Ven8','9865324570','ven8@gmail.com','08','Bidar','525.0','525.0','0.0','1'),(714,'Vendor6','4680764236','Ven6@gmail.com','06','Bihar','0.0','0.0','0.0','0'),(715,'Ven8','5689753226','Ven8@gmail.com','08','Mumbai','0.0','0.0','0.0','0'),(716,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','0.0','0.0','0.0','0'),(717,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','0.0','0.0','0.0','0'),(718,'Abdc','4567801234','Abdc@gmail.com','45','Banglore','6000.0','6000.0','0.0','2'),(719,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(720,'Ven1','5362910282','ven1@gmail.com','6','Hubli','3970.0','3970.0','0.0','4'),(721,'Ven2','5790864357','ven2@gmail.com','02','Hubli','5357.0','5357.0','0.0','4'),(722,'Ven3','5790742468','ven3@gmail.com','3','Mysore','1045.0','1045.0','0.0','2'),(723,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(724,'Ven7','3570096532','ven7@gmail.com','07','Goa','0.0','0.0','0.0','0'),(725,'Ven8','9865324570','ven8@gmail.com','08','Bidar','525.0','525.0','0.0','1'),(726,'Vendor6','4680764236','Ven6@gmail.com','06','Bihar','0.0','0.0','0.0','0'),(727,'Ven8','5689753226','Ven8@gmail.com','08','Mumbai','0.0','0.0','0.0','0'),(728,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','0.0','0.0','0.0','0'),(729,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','0.0','0.0','0.0','0'),(730,'Ven8','4567801234','Ven8@gmail.com','08','Hubli','0.0','0.0','0.0','0'),(731,'Abd','4567801234','Abdc@gmail.com','45','Banglore','0.0','0.0','0.0','0'),(732,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(733,'Ven1','5362910282','ven1@gmail.com','6','Hubli','3970.0','3970.0','0.0','4'),(734,'Ven2','5790864357','ven2@gmail.com','02','Hubli','5357.0','5357.0','0.0','4'),(735,'Ven3','5790742468','ven3@gmail.com','3','Mysore','1045.0','1045.0','0.0','2'),(736,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(737,'Ven7','3570096532','ven7@gmail.com','07','Goa','0.0','0.0','0.0','0'),(738,'Ven8','9865324570','ven8@gmail.com','08','Bidar','525.0','525.0','0.0','1'),(739,'Vendor6','4680764236','Ven6@gmail.com','06','Bihar','0.0','0.0','0.0','0'),(740,'Ven8','5689753226','Ven8@gmail.com','08','Mumbai','0.0','0.0','0.0','0'),(741,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','0.0','0.0','0.0','0'),(742,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','0.0','0.0','0.0','0'),(743,'Ven8','4567801234','Ven8@gmail.com','08','Hubli','0.0','0.0','0.0','0'),(744,'Ven8','4567801234','Ven8@gmail.com','08','Dharwad','0.0','0.0','0.0','0'),(745,'vendor trail','7283468724','vendor_trail@gmail.com','ven4gst','trail address','0.0','0.0','0.0','0'),(746,'Ven4','7348842227','Ven4@gmail.com','45','Trivendrum','0.0','0.0','0.0','0'),(747,'Abd','4567801234','Abdc@gmail.com','45','Banglore','0.0','0.0','0.0','0'),(748,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(749,'Ven1','5362910282','ven1@gmail.com','6','Hubli','3970.0','3970.0','0.0','4'),(750,'Ven2','5790864357','ven2@gmail.com','02','Hubli','5357.0','5357.0','0.0','4'),(751,'Ven3','5790742468','ven3@gmail.com','3','Mysore','1045.0','1045.0','0.0','2'),(752,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(753,'Ven7','3570096532','ven7@gmail.com','07','Goa','0.0','0.0','0.0','0'),(754,'Ven8','9865324570','ven8@gmail.com','08','Bidar','525.0','525.0','0.0','1'),(755,'Vendor6','4680764236','Ven6@gmail.com','06','Bihar','0.0','0.0','0.0','0'),(756,'Ven8','5689753226','Ven8@gmail.com','08','Mumbai','0.0','0.0','0.0','0'),(757,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','0.0','0.0','0.0','0'),(758,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','0.0','0.0','0.0','0'),(759,'Ven8','4567801234','Ven8@gmail.com','08','Hubli','0.0','0.0','0.0','0'),(760,'Ven8','4567801234','Ven8@gmail.com','08','Dharwad','0.0','0.0','0.0','0'),(761,'vendor trail','7283468724','vendor_trail@gmail.com','ven4gst','trail address','0.0','0.0','0.0','0'),(762,'Ven4','7348842227','Ven4@gmail.com','45','Trivendrum','0.0','0.0','0.0','0'),(763,'Abd','4567801234','Abdc@gmail.com','45','Banglore','0.0','0.0','0.0','0'),(764,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(765,'Ven1','5362910282','ven1@gmail.com','6','Hubli','6210.0','6210.0','0.0','6'),(766,'Ven2','5790864357','ven2@gmail.com','02','Hubli','5357.0','5357.0','0.0','4'),(767,'Ven3','5790742468','ven3@gmail.com','3','Mysore','1045.0','1045.0','0.0','2'),(768,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(769,'Ven7','3570096532','ven7@gmail.com','07','Goa','4500.0','4500.0','0.0','1'),(770,'Ven8','9865324570','ven8@gmail.com','08','Bidar','525.0','525.0','0.0','1'),(771,'Vendor6','4680764236','Ven6@gmail.com','06','Bihar','0.0','0.0','0.0','0'),(772,'Ven8','5689753226','Ven8@gmail.com','08','Mumbai','0.0','0.0','0.0','0'),(773,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','8000.0','8000.0','0.0','1'),(774,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','8000.0','8000.0','0.0','1'),(775,'Ven8','4567801234','Ven8@gmail.com','08','Hubli','0.0','0.0','0.0','0'),(776,'Ven8','4567801234','Ven8@gmail.com','08','Dharwad','0.0','0.0','0.0','0'),(777,'vendor trail','7283468724','vendor_trail@gmail.com','ven4gst','trail address','0.0','0.0','0.0','0'),(778,'Ven4','7348842227','Ven4@gmail.com','45','Trivendrum','0.0','0.0','0.0','0'),(779,'Ven4','4567801234','Ven4@gmail.com','45','Dharwad','0.0','0.0','0.0','0'),(780,'Abd','4567801234','Abdc@gmail.com','45','Banglore','0.0','0.0','0.0','0'),(781,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(782,'Ven1','5362910282','ven1@gmail.com','6','Hubli','6210.0','6210.0','0.0','6'),(783,'Ven2','5790864357','ven2@gmail.com','02','Hubli','5357.0','5357.0','0.0','4'),(784,'Ven3','5790742468','ven3@gmail.com','3','Mysore','1045.0','1045.0','0.0','2'),(785,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(786,'Ven7','3570096532','ven7@gmail.com','07','Goa','4500.0','4500.0','0.0','1'),(787,'Ven8','9865324570','ven8@gmail.com','08','Bidar','525.0','525.0','0.0','1'),(788,'Vendor6','4680764236','Ven6@gmail.com','06','Bihar','0.0','0.0','0.0','0'),(789,'Ven8','5689753226','Ven8@gmail.com','08','Mumbai','0.0','0.0','0.0','0'),(790,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','8000.0','8000.0','0.0','1'),(791,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','8000.0','8000.0','0.0','1'),(792,'Ven8','4567801234','Ven8@gmail.com','08','Hubli','0.0','0.0','0.0','0'),(793,'Ven8','4567801234','Ven8@gmail.com','08','Dharwad','0.0','0.0','0.0','0'),(794,'vendor trail','7283468724','vendor_trail@gmail.com','ven4gst','trail address','0.0','0.0','0.0','0'),(795,'Ven4','7348842227','Ven4@gmail.com','45','Trivendrum','0.0','0.0','0.0','0'),(796,'Ven4','4567801234','Ven4@gmail.com','45','Dharwad','0.0','0.0','0.0','0'),(797,'Abd','4567801234','Abdc@gmail.com','45','Banglore','0.0','0.0','0.0','0'),(798,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(799,'Ven1','5362910282','ven1@gmail.com','6','Hubli','6210.0','6210.0','0.0','6'),(800,'Ven2','5790864357','ven2@gmail.com','02','Hubli','5357.0','5357.0','0.0','4'),(801,'Ven3','5790742468','ven3@gmail.com','3','Mysore','1045.0','1045.0','0.0','2'),(802,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(803,'Ven7','3570096532','ven7@gmail.com','07','Goa','4500.0','4500.0','0.0','1'),(804,'Ven8','9865324570','ven8@gmail.com','08','Bidar','525.0','525.0','0.0','1'),(805,'Vendor6','4680764236','Ven6@gmail.com','06','Bihar','0.0','0.0','0.0','0'),(806,'Ven8','5689753226','Ven8@gmail.com','08','Mumbai','0.0','0.0','0.0','0'),(807,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','8000.0','8000.0','0.0','1'),(808,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','8000.0','8000.0','0.0','1'),(809,'Ven8','4567801234','Ven8@gmail.com','08','Hubli','0.0','0.0','0.0','0'),(810,'Ven8','4567801234','Ven8@gmail.com','08','Dharwad','0.0','0.0','0.0','0'),(811,'vendor trail','7283468724','vendor_trail@gmail.com','ven4gst','trail address','0.0','0.0','0.0','0'),(812,'Ven4','7348842227','Ven4@gmail.com','45','Trivendrum','0.0','0.0','0.0','0'),(813,'Ven4','4567801234','Ven4@gmail.com','45','Dharwad','0.0','0.0','0.0','0'),(814,'Abd','4567801234','Abdc@gmail.com','45','Banglore','0.0','0.0','0.0','0'),(815,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(816,'Ven1','5362910282','ven1@gmail.com','6','Hubli','6210.0','6210.0','0.0','6'),(817,'Ven2','5790864357','ven2@gmail.com','02','Hubli','5357.0','5357.0','0.0','4'),(818,'Ven3','5790742468','ven3@gmail.com','3','Mysore','1045.0','1045.0','0.0','2'),(819,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(820,'Ven7','3570096532','ven7@gmail.com','07','Goa','4500.0','4500.0','0.0','1'),(821,'Ven8','9865324570','ven8@gmail.com','08','Bidar','525.0','525.0','0.0','1'),(822,'Vendor6','4680764236','Ven6@gmail.com','06','Bihar','0.0','0.0','0.0','0'),(823,'Ven8','5689753226','Ven8@gmail.com','08','Mumbai','0.0','0.0','0.0','0'),(824,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','8000.0','8000.0','0.0','1'),(825,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','8000.0','8000.0','0.0','1'),(826,'Ven8','4567801234','Ven8@gmail.com','08','Hubli','0.0','0.0','0.0','0'),(827,'Ven8','4567801234','Ven8@gmail.com','08','Dharwad','0.0','0.0','0.0','0'),(828,'vendor trail','7283468724','vendor_trail@gmail.com','ven4gst','trail address','0.0','0.0','0.0','0'),(829,'Ven4','7348842227','Ven4@gmail.com','45','Trivendrum','0.0','0.0','0.0','0'),(830,'Ven4','4567801234','Ven4@gmail.com','45','Dharwad','0.0','0.0','0.0','0'),(831,'Abd','4567801234','Abdc@gmail.com','45','Banglore','0.0','0.0','0.0','0'),(832,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(833,'Ven1','5362910282','ven1@gmail.com','6','Hubli','6210.0','6210.0','0.0','6'),(834,'Ven2','5790864357','ven2@gmail.com','02','Hubli','10757.0','5357.0','5400.0','5'),(835,'Ven3','5790742468','ven3@gmail.com','3','Mysore','1045.0','1045.0','0.0','2'),(836,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(837,'Ven7','3570096532','ven7@gmail.com','07','Goa','4500.0','4500.0','0.0','1'),(838,'Ven8','9865324570','ven8@gmail.com','08','Bidar','525.0','525.0','0.0','1'),(839,'Vendor6','4680764236','Ven6@gmail.com','06','Bihar','0.0','0.0','0.0','0'),(840,'Ven8','5689753226','Ven8@gmail.com','08','Mumbai','0.0','0.0','0.0','0'),(841,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','8000.0','8000.0','0.0','1'),(842,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','8000.0','8000.0','0.0','1'),(843,'Ven8','4567801234','Ven8@gmail.com','08','Hubli','0.0','0.0','0.0','0'),(844,'Ven8','4567801234','Ven8@gmail.com','08','Dharwad','0.0','0.0','0.0','0'),(845,'vendor trail','7283468724','vendor_trail@gmail.com','ven4gst','trail address','0.0','0.0','0.0','0'),(846,'Ven4','7348842227','Ven4@gmail.com','45','Trivendrum','0.0','0.0','0.0','0'),(847,'Ven4','4567801234','Ven4@gmail.com','45','Dharwad','0.0','0.0','0.0','0'),(848,'Abd','4567801234','Abdc@gmail.com','45','Banglore','0.0','0.0','0.0','0'),(849,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(850,'Ven1','5362910282','ven1@gmail.com','6','Hubli','6210.0','6210.0','0.0','6'),(851,'Ven2','5790864357','ven2@gmail.com','02','Hubli','10757.0','5357.0','5400.0','5'),(852,'Ven3','5790742468','ven3@gmail.com','3','Mysore','1045.0','1045.0','0.0','2'),(853,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(854,'Ven7','3570096532','ven7@gmail.com','07','Goa','4500.0','4500.0','0.0','1'),(855,'Ven8','9865324570','ven8@gmail.com','08','Bidar','525.0','525.0','0.0','1'),(856,'Vendor6','4680764236','Ven6@gmail.com','06','Bihar','0.0','0.0','0.0','0'),(857,'Ven8','5689753226','Ven8@gmail.com','08','Mumbai','0.0','0.0','0.0','0'),(858,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','8000.0','8000.0','0.0','1'),(859,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','8000.0','8000.0','0.0','1'),(860,'Ven8','4567801234','Ven8@gmail.com','08','Hubli','0.0','0.0','0.0','0'),(861,'Ven8','4567801234','Ven8@gmail.com','08','Dharwad','0.0','0.0','0.0','0'),(862,'vendor trail','7283468724','vendor_trail@gmail.com','ven4gst','trail address','0.0','0.0','0.0','0'),(863,'Ven4','7348842227','Ven4@gmail.com','45','Trivendrum','0.0','0.0','0.0','0'),(864,'Ven4','4567801234','Ven4@gmail.com','45','Dharwad','0.0','0.0','0.0','0'),(865,'Abd','4567801234','Abdc@gmail.com','45','Banglore','0.0','0.0','0.0','0'),(866,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(867,'Ven1','5362910282','ven1@gmail.com','6','Hubli','6210.0','6210.0','0.0','6'),(868,'Ven2','5790864357','ven2@gmail.com','02','Hubli','10862.0','5462.0','5400.0','6'),(869,'Ven3','5790742468','ven3@gmail.com','3','Mysore','1115.0','1115.0','0.0','3'),(870,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(871,'Ven7','3570096532','ven7@gmail.com','07','Goa','4500.0','4500.0','0.0','1'),(872,'Ven8','9865324570','ven8@gmail.com','08','Bidar','525.0','525.0','0.0','1'),(873,'Vendor6','4680764236','Ven6@gmail.com','06','Bihar','0.0','0.0','0.0','0'),(874,'Ven8','5689753226','Ven8@gmail.com','08','Mumbai','0.0','0.0','0.0','0'),(875,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','8000.0','8000.0','0.0','1'),(876,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','8000.0','8000.0','0.0','1'),(877,'Ven8','4567801234','Ven8@gmail.com','08','Hubli','0.0','0.0','0.0','0'),(878,'Ven8','4567801234','Ven8@gmail.com','08','Dharwad','0.0','0.0','0.0','0'),(879,'vendor trail','7283468724','vendor_trail@gmail.com','ven4gst','trail address','0.0','0.0','0.0','0'),(880,'Ven4','7348842227','Ven4@gmail.com','45','Trivendrum','0.0','0.0','0.0','0'),(881,'Ven4','4567801234','Ven4@gmail.com','45','Dharwad','0.0','0.0','0.0','0'),(882,'Abd','4567801234','Abdc@gmail.com','45','Banglore','0.0','0.0','0.0','0'),(883,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(884,'Ven1','5362910282','ven1@gmail.com','6','Hubli','6210.0','6210.0','0.0','6'),(885,'Ven2','5790864357','ven2@gmail.com','02','Hubli','10862.0','5462.0','5400.0','6'),(886,'Ven3','5790742468','ven3@gmail.com','3','Mysore','1115.0','1115.0','0.0','3'),(887,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(888,'Ven7','3570096532','ven7@gmail.com','07','Goa','4500.0','4500.0','0.0','1'),(889,'Ven8','9865324570','ven8@gmail.com','08','Bidar','525.0','525.0','0.0','1'),(890,'Vendor6','4680764236','Ven6@gmail.com','06','Bihar','0.0','0.0','0.0','0'),(891,'Ven8','5689753226','Ven8@gmail.com','08','Mumbai','0.0','0.0','0.0','0'),(892,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','8000.0','8000.0','0.0','1'),(893,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','8000.0','8000.0','0.0','1'),(894,'Ven8','4567801234','Ven8@gmail.com','08','Hubli','0.0','0.0','0.0','0'),(895,'Ven8','4567801234','Ven8@gmail.com','08','Dharwad','0.0','0.0','0.0','0'),(896,'vendor trail','7283468724','vendor_trail@gmail.com','ven4gst','trail address','0.0','0.0','0.0','0'),(897,'Ven4','7348842227','Ven4@gmail.com','45','Trivendrum','0.0','0.0','0.0','0'),(898,'Ven4','4567801234','Ven4@gmail.com','45','Dharwad','0.0','0.0','0.0','0'),(899,'Abd','4567801234','Abdc@gmail.com','45','Banglore','0.0','0.0','0.0','0'),(900,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(901,'Ven1','5362910282','ven1@gmail.com','6','Hubli','6210.0','6210.0','0.0','6'),(902,'Ven2','5790864357','ven2@gmail.com','02','Hubli','10862.0','5462.0','5400.0','6'),(903,'Ven3','5790742468','ven3@gmail.com','3','Mysore','1115.0','1115.0','0.0','3'),(904,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(905,'Ven7','3570096532','ven7@gmail.com','07','Goa','4500.0','4500.0','0.0','1'),(906,'Ven8','9865324570','ven8@gmail.com','08','Bidar','525.0','525.0','0.0','1'),(907,'Vendor6','4680764236','Ven6@gmail.com','06','Bihar','0.0','0.0','0.0','0'),(908,'Ven8','5689753226','Ven8@gmail.com','08','Mumbai','0.0','0.0','0.0','0'),(909,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','8000.0','8000.0','0.0','1'),(910,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','8000.0','8000.0','0.0','1'),(911,'Ven8','4567801234','Ven8@gmail.com','08','Hubli','0.0','0.0','0.0','0'),(912,'Ven8','4567801234','Ven8@gmail.com','08','Dharwad','0.0','0.0','0.0','0'),(913,'vendor trail','7283468724','vendor_trail@gmail.com','ven4gst','trail address','0.0','0.0','0.0','0'),(914,'Ven4','7348842227','Ven4@gmail.com','45','Trivendrum','0.0','0.0','0.0','0'),(915,'Ven4','4567801234','Ven4@gmail.com','45','Dharwad','0.0','0.0','0.0','0'),(916,'Abd','4567801234','Abdc@gmail.com','45','Banglore','0.0','0.0','0.0','0'),(917,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(918,'Ven1','5362910282','ven1@gmail.com','6','Hubli','6210.0','6210.0','0.0','6'),(919,'Ven2','5790864357','ven2@gmail.com','02','Hubli','10862.0','5462.0','5400.0','6'),(920,'Ven3','5790742468','ven3@gmail.com','3','Mysore','1115.0','1115.0','0.0','3'),(921,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(922,'Ven7','3570096532','ven7@gmail.com','07','Goa','4500.0','4500.0','0.0','1'),(923,'Ven8','9865324570','ven8@gmail.com','08','Bidar','525.0','525.0','0.0','1'),(924,'Vendor6','4680764236','Ven6@gmail.com','06','Bihar','0.0','0.0','0.0','0'),(925,'Ven8','5689753226','Ven8@gmail.com','08','Mumbai','0.0','0.0','0.0','0'),(926,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','8000.0','8000.0','0.0','1'),(927,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','8000.0','8000.0','0.0','1'),(928,'Ven8','4567801234','Ven8@gmail.com','08','Hubli','0.0','0.0','0.0','0'),(929,'Ven8','4567801234','Ven8@gmail.com','08','Dharwad','0.0','0.0','0.0','0'),(930,'vendor trail','7283468724','vendor_trail@gmail.com','ven4gst','trail address','0.0','0.0','0.0','0'),(931,'Ven4','7348842227','Ven4@gmail.com','45','Trivendrum','0.0','0.0','0.0','0'),(932,'Ven4','4567801234','Ven4@gmail.com','45','Dharwad','0.0','0.0','0.0','0'),(933,'Abd','4567801234','Abdc@gmail.com','45','Banglore','0.0','0.0','0.0','0'),(934,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(935,'Ven1','5362910282','ven1@gmail.com','6','Hubli','6210.0','6210.0','0.0','6'),(936,'Ven2','5790864357','ven2@gmail.com','02','Hubli','10862.0','5462.0','5400.0','6'),(937,'Ven3','5790742468','ven3@gmail.com','3','Mysore','1115.0','1115.0','0.0','3'),(938,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(939,'Ven7','3570096532','ven7@gmail.com','07','Goa','4500.0','4500.0','0.0','1'),(940,'Ven8','9865324570','ven8@gmail.com','08','Bidar','525.0','525.0','0.0','1'),(941,'Vendor6','4680764236','Ven6@gmail.com','06','Bihar','0.0','0.0','0.0','0'),(942,'Ven8','5689753226','Ven8@gmail.com','08','Mumbai','0.0','0.0','0.0','0'),(943,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','8000.0','8000.0','0.0','1'),(944,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','8000.0','8000.0','0.0','1'),(945,'Ven8','4567801234','Ven8@gmail.com','08','Hubli','0.0','0.0','0.0','0'),(946,'Ven8','4567801234','Ven8@gmail.com','08','Dharwad','0.0','0.0','0.0','0'),(947,'vendor trail','7283468724','vendor_trail@gmail.com','ven4gst','trail address','0.0','0.0','0.0','0'),(948,'Ven4','7348842227','Ven4@gmail.com','45','Trivendrum','0.0','0.0','0.0','0'),(949,'Ven4','4567801234','Ven4@gmail.com','45','Dharwad','0.0','0.0','0.0','0'),(950,'Abd','4567801234','Abdc@gmail.com','45','Banglore','0.0','0.0','0.0','0'),(951,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(952,'Ven1','5362910282','ven1@gmail.com','6','Hubli','6210.0','6210.0','0.0','6'),(953,'Ven2','5790864357','ven2@gmail.com','02','Hubli','10862.0','5462.0','5400.0','6'),(954,'Ven3','5790742468','ven3@gmail.com','3','Mysore','1115.0','1115.0','0.0','3'),(955,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(956,'Ven7','3570096532','ven7@gmail.com','07','Goa','4500.0','4500.0','0.0','1'),(957,'Ven8','9865324570','ven8@gmail.com','08','Bidar','525.0','525.0','0.0','1'),(958,'Vendor6','4680764236','Ven6@gmail.com','06','Bihar','0.0','0.0','0.0','0'),(959,'Ven8','5689753226','Ven8@gmail.com','08','Mumbai','0.0','0.0','0.0','0'),(960,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','8000.0','8000.0','0.0','1'),(961,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','8000.0','8000.0','0.0','1'),(962,'Ven8','4567801234','Ven8@gmail.com','08','Hubli','0.0','0.0','0.0','0'),(963,'Ven8','4567801234','Ven8@gmail.com','08','Dharwad','0.0','0.0','0.0','0'),(964,'vendor trail','7283468724','vendor_trail@gmail.com','ven4gst','trail address','0.0','0.0','0.0','0'),(965,'Ven4','7348842227','Ven4@gmail.com','45','Trivendrum','0.0','0.0','0.0','0'),(966,'Ven4','4567801234','Ven4@gmail.com','45','Dharwad','0.0','0.0','0.0','0'),(967,'Abd','4567801234','Abdc@gmail.com','45','Banglore','0.0','0.0','0.0','0'),(968,'Xyz','7536952464','xyz@gmail.com','3','Hubli','0.0','0.0','0.0','0'),(969,'Ven1','5362910282','ven1@gmail.com','6','Hubli','6210.0','6210.0','0.0','6'),(970,'Ven2','5790864357','ven2@gmail.com','02','Hubli','10862.0','5462.0','5400.0','6'),(971,'Ven3','5790742468','ven3@gmail.com','3','Mysore','1115.0','1115.0','0.0','3'),(972,'ven6','1236547895','ven6@gmail.com','06','gadag','0.0','0.0','0.0','0'),(973,'Ven7','3570096532','ven7@gmail.com','07','Goa','4500.0','4500.0','0.0','1'),(974,'Ven8','9865324570','ven8@gmail.com','08','Bidar','525.0','525.0','0.0','1'),(975,'Vendor6','4680764236','Ven6@gmail.com','06','Bihar','0.0','0.0','0.0','0'),(976,'Ven8','5689753226','Ven8@gmail.com','08','Mumbai','0.0','0.0','0.0','0'),(977,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','8000.0','8000.0','0.0','1'),(978,'Ven8','4680764236','Ven8@gmail.com','08','Delhi','8000.0','8000.0','0.0','1'),(979,'Ven8','4567801234','Ven8@gmail.com','08','Hubli','0.0','0.0','0.0','0'),(980,'Ven8','4567801234','Ven8@gmail.com','08','Dharwad','0.0','0.0','0.0','0'),(981,'vendor trail','7283468724','vendor_trail@gmail.com','ven4gst','trail address','0.0','0.0','0.0','0'),(982,'Ven4','7348842227','Ven4@gmail.com','45','Trivendrum','0.0','0.0','0.0','0'),(983,'Ven4','4567801234','Ven4@gmail.com','45','Dharwad','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','06:24 AM','Today','06:24 PM','06:24','18:24');
