INSERT INTO `account_selection` (`_id`, `selection`) VALUES (1,'Retail');
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,'','1',NULL,'first','0','4',NULL),(2,'','2',NULL,'first','0','4',NULL),(3,'','3',NULL,'first','0','4',NULL);
INSERT INTO `auto_connect` (`_id`, `auto_connect_status`) VALUES (1,'No');
INSERT INTO `auto_generate_barcode` (`_id`, `generate`) VALUES (1,'off');
INSERT INTO `billingmode` (`_id`, `billingtype`) VALUES (1,'Retail');
INSERT INTO `billingtype` (`_id`, `billingtype_type`) VALUES (1,'General');
INSERT INTO `btconn` (`_id`, `name`, `address`, `status`, `device`) VALUES (1,'','','',NULL);
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,'Paytm','','','Not Activated'),(7,'ezetap','','','Not 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 (2,'Intuition','9535897598',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,'',NULL,'','','www.intuitionsoftwares.com','',''),(31,'Intuition','9535897598',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,'',NULL,'','','www.intuitionsoftwares.com','','');
INSERT INTO `country_selection` (`_id`, `country`) VALUES (1,'Rupee');
INSERT INTO `default_credit` (`_id`, `status`) VALUES (1,'off');
INSERT INTO `deletedb_time` (`_id`, `time`) VALUES (1,'11:30 PM');
INSERT INTO `deletedbon_off` (`_id`, `status`) VALUES (1,'off');
INSERT INTO `discount_details` (`_id`, `disc_code`, `disc_value`, `disc_type`) VALUES (1,'New year ','10','%'),(2,'christmas offer','15','%'),(3,'Discount 1','25','%');
INSERT INTO `estimate_print` (`_id`, `status`) VALUES (1,'Yes');
INSERT INTO `freetrail` (`_id`, `status`) VALUES (1,'Activated');
INSERT INTO `home_check` (`_id`, `login_status`) VALUES (1,'1');
INSERT INTO `homedelivery_prints` (`_id`, `companycopy`, `customercopy`) VALUES (1,'yes','yes');
INSERT INTO `hotel` (`_id`, `name`, `direccion`, `telefono`, `email`, `value`) VALUES (1,'All',NULL,NULL,NULL,NULL),(2,'Favourites',NULL,NULL,NULL,NULL),(3,'Baby Products',NULL,NULL,NULL,NULL),(4,'Chain',NULL,NULL,NULL,NULL),(5,'branded foods',NULL,NULL,NULL,NULL),(6,'personal care',NULL,NULL,NULL,NULL),(7,'rice whole grains',NULL,NULL,NULL,NULL),(8,'Test',NULL,NULL,NULL,NULL),(9,'fruits and vegetables',NULL,NULL,NULL,NULL),(10,'Dairy',NULL,NULL,NULL,NULL),(12,'dals pulses',NULL,NULL,NULL,NULL),(13,'Sports',NULL,NULL,NULL,NULL),(14,'Surgicals ',NULL,NULL,NULL,NULL),(15,'Food ',NULL,NULL,NULL,NULL),(16,'Dry fruits',NULL,NULL,NULL,NULL);
INSERT INTO `ingredient_items_list` (`_id`, `ingredient_name`, `itemname`, `item_qyt_used`, `currnet_stock`, `date1`, `date`, `time1`, `time`, `modified_datetimee_new`, `qty_unit`, `required`) VALUES (1,'sand ','Brick 1 unit. ','0','0','07 Jul 2025','202507071740','05:40:35 pm','1740','202507071740','gallon','0.0'),(2,'Sand 2','Brick 1 unit. ','10000','0','07 Jul 2025','202507071742','05:42:17 pm','1742','202507071742','Kg','0.0'),(3,'water','Brick 1 unit','0','5','07 Jul 2025','202507071749','05:49:35 pm','1749','202507071749','gallon','-5.0'),(4,'Paneer','Paneer Tikka','100','1000','06 Jan 2026','202601061229','12:29:34 pm','1229','202601061229','gm','-1000.0');
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,'sand ','100','0','0','gallon','10000',NULL,'202507071740','07 Jul 2025','1740','05:40:39 pm','202507071740','10000','0.0','',NULL,NULL,NULL,NULL,NULL,NULL,'10000',NULL),(2,'Sand 2','10000','0','10000','Kg','100',NULL,'202507071742','07 Jul 2025','1742','05:42:22 pm','202507071745','100','-10000.0','',NULL,NULL,NULL,NULL,NULL,NULL,'100',NULL),(3,'water','5','0','5','gallon','1000',NULL,'202507071749','07 Jul 2025','1749','05:49:38 pm','202507071749','1000','-5.0','',NULL,NULL,NULL,NULL,NULL,NULL,'1000',NULL),(4,'Paneer','0','0','800.00','gm','500',NULL,'202601061229','06 Jan 2026','1229','12:29:37 pm','202601061232','500','-800.0','',NULL,NULL,NULL,NULL,NULL,NULL,'500',NULL);
INSERT INTO `ingredients_item_selection_temp` (`_id`, `itemname`, `qty_temp`, `qty_temp_unit`, `qty`) VALUES (1,'sand ','0','gallon','yes'),(2,'Sand 2','10000','Kg','yes');
INSERT INTO `ipconn` (`_id`, `ipname`, `port`, `status`, `printer_name`) VALUES (1,'192.168.1.87','9100','',NULL);
INSERT INTO `ipconn_counter` (`_id`, `ipname`, `port`, `status`, `printer_name`) VALUES (1,'192.168.1.92','9100','',NULL);
INSERT INTO `ipconn_kot1` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.88','9100','',NULL,'kot1');
INSERT INTO `ipconn_kot2` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.89','9100','',NULL,'kot2');
INSERT INTO `ipconn_kot3` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.90','9100','',NULL,'kot3');
INSERT INTO `ipconn_kot4` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.91','9100','',NULL,'kot4');
INSERT INTO `items` (`_id`, `itemname`, `price`, `stockquan`, `category`, `itemtax`, `image`, `weekdaysvalue`, `weekendsvalue`, `manualstockvalue`, `automaticstockresetvalue`, `clickcount`, `favourites`, `disc_type`, `disc_value`, `image_text`, `barcode_value`, `checked`, `print_value`, `quantity_sold`, `minimum_qty`, `minimum_qty_copy`, `add_qty`, `status_low`, `status_qty_updated`, `individual_price`, `unit_type`, `tax_value`, `itemtax2`, `tax_value2`, `itemtax3`, `tax_value3`, `itemtax4`, `tax_value4`, `itemtax5`, `tax_value5`, `status_temp`, `status_perm`, `variant1`, `variant_price1`, `variant2`, `variant_price2`, `variant3`, `variant_price3`, `variant4`, `variant_price4`, `variant5`, `variant_price5`, `dept_name`, `add_qty_st`, `status_qty_updated_st`, `out_of_stock`, `mod_set1`, `mod_set2`, `mod_set3`, `mod_set4`, `mod_set5`, `is_veg`, `packing_charges`, `v1_oofstock`, `v2_oofstock`, `v3_oofstock`, `v4_oofstock`, `v5_oofstock`) VALUES (1,'sona masoori raw rice 1kg',56.00,49,'rice whole grains','sgst(2.5%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','so','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.5','IGST(18%)','18.0','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1001','',NULL,NULL,NULL,NULL,NULL),(2,'tata urad dal whole white 1kg',250.00,47,'dals pulses','sgst(2.5%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ta','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.5','','','','','','','','','0','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1002','',NULL,NULL,NULL,NULL,NULL),(3,'nutella',100.00,47,'branded foods','sgst(2.5%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','nu','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.5','IGST(18%)','18.0','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1003','',NULL,NULL,NULL,NULL,NULL),(4,'fig fruit kg',250.00,50,'fruits and vegetables','sgst(2.5%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','fi','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.5','','','','','','','','','0','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1004','',NULL,NULL,NULL,NULL,NULL),(5,'ladies finger kg',28.00,50,'fruits and vegetables','sgst(2.5%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','la','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.5','','','','','','','','','0','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1005','',NULL,NULL,NULL,NULL,NULL),(6,'capsicum green kg',80.00,55,'fruits and vegetables','sgst(2.5%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ca','',NULL,NULL,NULL,NULL,NULL,'05',NULL,NULL,'30','Unit','2.5','','','','','','','','','0','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1006','',NULL,NULL,NULL,NULL,NULL),(7,'carrots kg',70.00,50,'fruits and vegetables','sgst(2.5%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ca','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.5','','','','','','','','','0','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1007','',NULL,NULL,NULL,NULL,NULL),(8,'cauliflower kg',45.00,50,'fruits and vegetables','sgst(2.5%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ca','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.5','','','','','','','','','0','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1008','',NULL,NULL,NULL,NULL,NULL),(9,'beans kg',40.00,60,'fruits and vegetables','sgst(2.5%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','be','',NULL,NULL,NULL,NULL,NULL,'10',NULL,NULL,'30','Unit','2.5','','','','','','','','','0','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1009','',NULL,NULL,NULL,NULL,NULL),(10,'sweet corn piece',15.00,70,'fruits and vegetables','sgst(2.5%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','sw','',NULL,NULL,NULL,NULL,NULL,'20',NULL,NULL,'10','Unit','2.5','','','','','','','','','0','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1010','',NULL,NULL,NULL,NULL,NULL),(11,'cucumbers kg',20.00,50,'fruits and vegetables','sgst(2.5%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','cu','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.5','','','','','','','','','0','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1011','',NULL,NULL,NULL,NULL,NULL),(12,'loreal color 90gms',76.00,50,'personal care','sgst(2.5%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','lo','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.5','','','','','','','','','0','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1012','',NULL,NULL,NULL,NULL,NULL),(13,'beet root kg',32.00,50,'fruits and vegetables','sgst(2.5%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','be','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.5','','','','','','','','','0','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1013','',NULL,NULL,NULL,NULL,NULL),(14,'onions big kg',20.00,50,'fruits and vegetables','sgst(2.5%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','on','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.5','','','','','','','','','0','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1014','',NULL,NULL,NULL,NULL,NULL),(15,'radish white kg',24.00,50,'fruits and vegetables','sgst(2.5%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ra','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.5','','','','','','','','','0','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1015','',NULL,NULL,NULL,NULL,NULL),(16,'Cricket bat',500.00,10,'Sports','sgst(2.5%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Cr','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.5','','','','','','','','','0','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1016','',NULL,NULL,NULL,NULL,NULL),(17,'Badminton racket',500.00,9,'Sports','sgst(2.5%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ba','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.5','','','','','','','','','0','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1017','',NULL,NULL,NULL,NULL,NULL),(18,'Yoghurt',50.00,10,'Dairy','sgst(2.5%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Yo','18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.5','','','','','','','','','0','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1018','',NULL,NULL,NULL,NULL,NULL),(19,'Bowl Set BW.',280.00,5,'Baby Products','sgst(2.5%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Bo','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.5','','','','','','','','','0','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1019','',NULL,NULL,NULL,NULL,NULL),(20,'Baby Wrap BW',450.00,6,'Baby Products','sgst(2.5%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ba','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.5','','','','','','','','','0','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1020','',NULL,NULL,NULL,NULL,NULL),(27,'Coffee',25.00,10,'Test','cgst(2.5%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Co','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','0','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1027','',NULL,NULL,NULL,NULL,NULL),(28,'U Vadai',15.00,10,'Test','cgst(2.5%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','U ','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','0','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1028','',NULL,NULL,NULL,NULL,NULL),(29,'Sambar Vadai',30.00,10,'Test','cgst(2.5%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Sa','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','0','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1029','',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,'Archana ','20.0','20.0','20.0','10.0','200.0','',''),(2,'Aarthi','25.0','25.0','25.0','10.0','250.0','',''),(3,'Ganapathi pooja','50.0','50.0','50.0','10.0','500.0','',''),(4,'Satyanarayana pooja','100.0','100.0','100.0','20.0','2000.0','',''),(5,'Navagraha pooja','200.0','200.0','200.0','10.0','2000.0','',''),(6,'special occasion pooja','1000.0','1000.0','1000.0','10.0','10000.0','',''),(7,'pooja prasada','200.0','200.0','200.0','10.0','2000.0','',''),(8,'pooja prasada','200.0','200.0','200.0','10.0','2000.0','',''),(9,'pooja prasada','200.0','200.0','200.0','10.0','2000.0','',''),(10,'Sales 2','90.0','90.0','90.0','10.0','900.0','',''),(11,'toor dal 500g','180.0','180.0','180.0','7.0','1260.0','',''),(12,'urad dal split 2kg','120.0','120.0','120.0','10.0','1200.0','',''),(13,'toor dal 500g','180.0','180.0','180.0','7.0','1260.0','','');
INSERT INTO `itemsort` (`_id`, `itemsorttype`) VALUES (1,'Sort by Date added');
INSERT INTO `kot_print` (`_id`, `kot_print_status`) VALUES (1,'Yes');
INSERT INTO `loyalty_points` (`_id`, `money`, `point`, `point2`, `money2`) VALUES (1,'10','1','1','10');
INSERT INTO `loyalty_points_status` (`_id`, `status`) VALUES (1,'yes');
INSERT INTO `menulogin_checking` (`_id`, `status`) VALUES (1,'no');
INSERT INTO `modifiers` (`_id`, `modifiername`, `modprice`, `modstockquan`, `modcategory`, `moditemtax`, `modimage`, `mod_image_text`) VALUES (1,'potato masala',10,50,'Tiffin','None',NULL,NULL),(2,'podi',0,50,'Tiffin','None',NULL,NULL),(3,'cheese',15,35,'Tiffin','None',NULL,NULL),(4,'butter',10,40,'Tiffin','None',NULL,NULL),(5,'omlette',10,50,'Tiffin','None',NULL,NULL),(6,'cheese dip',20,50,'Snacks','None',NULL,NULL),(7,'potato fry',25,50,'Main course','None',NULL,NULL),(8,'chicken fry',40,45,'Main course','None',NULL,NULL),(9,'soda',6,50,'Main course','None',NULL,NULL),(10,'dessert',15,35,'Main course','None',NULL,NULL),(11,'medium',5,50,'Drinks','None',NULL,NULL),(12,'large',10,50,'Drinks','None',NULL,NULL),(13,'cream',20,50,'Desserts','None',NULL,NULL),(14,'chocolate',20,50,'Desserts','None',NULL,NULL);
INSERT INTO `name_dept1` (`_id`, `dept1_name`) VALUES (1,'kot1');
INSERT INTO `name_dept2` (`_id`, `dept2_name`) VALUES (1,'kot2');
INSERT INTO `name_dept3` (`_id`, `dept3_name`) VALUES (1,'kot3');
INSERT INTO `name_dept4` (`_id`, `dept4_name`) VALUES (1,'kot4');
INSERT INTO `ordertaking_server_ip` (`_id`, `ipname`, `port`, `status`) VALUES (1,'192.168.1.100','8080','');
INSERT INTO `paytmmerchantreg` (`_id`, `Account`, `MerchantName`, `guid`, `MID`, `Merchant_key`, `PosID`) VALUES (1,'Not_Registered','','','','','');
INSERT INTO `printer_text_size` (`_id`, `type`) VALUES (1,'Standard');
INSERT INTO `printer_type` (`_id`, `printer_type`) VALUES (1,'Generic');
INSERT INTO `printerreceiptsize` (`_id`, `papersize`) VALUES (30,'3 inch');
INSERT INTO `razorpaymerchantreg` (`_id`, `account`, `account_id`) VALUES (1,'Not_Registered','');
INSERT INTO `round_off` (`_id`, `round_off_status`) VALUES (1,'No');
INSERT INTO `schedule_mail_on_off` (`_id`, `status`) VALUES (1,'Off');
INSERT INTO `schedule_mail_time` (`_id`, `time`) VALUES (1,'11:30 PM');
INSERT INTO `stockcontrol` (`_id`, `stockcontroltype`) VALUES (1,'On');
INSERT INTO `stockreset` (`_id`, `stockresettype`) VALUES (1,'Off');
INSERT INTO `storedays` (`_id`, `weekdays`, `weekends`, `swap`) VALUES (1,'Monday','0','0'),(2,'Tuesday','0','0'),(3,'Wednesday','0','0'),(4,'Thursday','0','0'),(5,'0','Friday','Friday'),(6,'0','Saturday','Saturday'),(7,'0','Sunday','Sunday');
INSERT INTO `sync_time` (`_id`, `last_time`) VALUES (1,'05 Apr 18, 05:22 PM');
INSERT INTO `table_kot` (`_id`, `status`) VALUES (1,'Lite');
INSERT INTO `taxes` (`_id`, `taxname`, `value`, `taxtype`, `checked`, `tax1`, `tax2`, `tax3`, `hsn_code`) VALUES (1,'sgst(2.5%)',2.50,'Itemtax','',NULL,NULL,NULL,NULL),(2,'cgst(2.5%)',2.50,'Itemtax','',NULL,NULL,NULL,NULL),(3,'IGST(18%)',18.00,'Itemtax','','dine_in','takeaway','homedelivery',''),(4,'IGST(18%)',18.00,'Itemtax',NULL,'dine_in','takeaway','homedelivery','');
INSERT INTO `totaltables` (`_id`, `nooftables`) VALUES (1,'4');
INSERT INTO `user_privilege` (`_id`, `username`, `returns_refunds`, `product_tax`, `reports`, `settings`, `backup`, `customer`, `ingredients`, `subscriptions`) VALUES (1,'user1','no','no','no','no','no','no','no','no'),(2,'user2','no','no','no','no','no','no','no','no'),(3,'user3','no','no','no','no','no','no','no','no'),(4,'user4','no','no','no','no','no','no','no','no'),(5,'user5','no','no','no','no','no','no','no','no'),(6,'user6','no','no','no','no','no','no','no','no');
INSERT INTO `variants_temp` (`_id`, `vari1`, `varprice1`, `vari2`, `varprice2`, `vari3`, `varprice3`, `vari4`, `varprice4`, `vari5`, `varprice5`) VALUES (3,'Regular','50',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'choclate cake','80',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'Regular','10000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'blue','10000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'Regular','10000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'blue','10000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'Regular','56',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'variant 1','35',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'Regular','56',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'Regular','56',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'variant 1','35',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'Regular','150',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'Large','200',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'Regular','150',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'Large','200',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,'Regular','150',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,'Large','200',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `vendor_details` (`_id`, `vendor_name`, `vendor_phoneno`, `vendor_email`, `vendor_address`, `vendor_gst`) VALUES (1,'Abc Enterprises ','1234567890','','Bangalore ',''),(2,'XYZ Trader','9164000275','','Bangalore ',''),(3,'Abcd Traders','9535897598','ivepos','',''),(4,'Abcd Traders','9535897598','','Bangalore',''),(5,'Abcd Traders','9535897598','','Bangalore',''),(6,' Abc Enterprises','1234567890','','Bangalore',''),(7,'IVEPOS vendor 1','9164000272','','Chennai ',''),(8,'Test vendor ','9740157140','','City Market Bangalore ',''),(9,'Reshma ','9535897598','ivepos','#603, 6th floor, Gamma block, Sigma Tech Park,white Field, Bangalore - 560066',''),(10,'Reshma Syed','9535897598','ivepos','#603, 6th floor, Gamma block, Sigma Tech Park,white Field, Bangalore - 560066',''),(11,'IVEPOSVENDOR','9740157140','ivepos','Bangalore','');
INSERT INTO `vendor_sold_details` (`_id`, `vendor_name`, `vendor_phoneno`, `invoice`, `billamount`, `tax_percent`, `tax_amount`, `disc_percent`, `disc_amount`, `total_bill_amount`, `from_time`, `from_date`, `due_date`, `datetimee_new_from`, `datetimee_new_due`, `pay`, `pending`, `total_pay`, `pay_date`, `pay_time`, `pay_datetimeemew`, `not_required`) VALUES (1,'Abc Enterprises ','1234567890','','50.0','0','0','0','0','50.0','11:49 AM','23 Oct 2024','23 Oct 2024','202410231149','20241023','50','0.0','50','23 Oct 2024','11:49 AM','202410231149',''),(2,'Abc Enterprises ','1234567890','','4950.0','0','0','0','0','4950.0','12:25 pm','30 Dec 2024','30 Dec 2024','202412301225','20241230','49500','-44550.0','49500','30 Dec 2024','12:25 pm','202412301225',''),(3,'Abc Enterprises ','1234567890','','12000.0','0','0','0','0','12000.0','12:30 pm','30 Dec 2024','30 Dec 2024','202412301230','20241230','12000','0.0','12000','30 Dec 2024','12:30 pm','202412301230',''),(4,'Abc Enterprises ','1234567890','','50.0','0','0','0','0','50.0','12:08 pm','20 Jan 2025','20 Jan 2025','202501201208','20250120','50','0.0','50','20 Jan 2025','12:08 pm','202501201208',''),(5,'Abc Enterprises ','1234567890','','400','0','0','0','0','400','10:05 AM','15 Feb 2025','15 Feb 2025','202502151005','20250215','300','100.0','300','15 Feb 2025','10:05 AM','202502151005',NULL),(6,'Abc Enterprises ','1234567890','','950.0','0','0','0','0','950.0','04:50 pm','20 Mar 2025','20 Mar 2025','202503201650','20250320','900','50.0','900','20 Mar 2025','04:50 pm','202503201650',''),(7,'Abc Enterprises ','1234567890','','1300.0','0','0','0','0','1300.0','05:36 pm','20 Mar 2025','20 Mar 2025','202503201736','20250320','1000','300.0','1000','20 Mar 2025','05:36 pm','202503201736',''),(8,'Abc Enterprises ','1234567890','','300','0','0','0','0','300','06:20 AM','21 Mar 2025','21 Mar 2025','202503210620','20250321','300','0.0','300','21 Mar 2025','06:20 AM','202503210620',NULL),(9,'Abc Enterprises ','1234567890','','1500','0','0','0','0','1500','06:21 AM','21 Mar 2025','21 Mar 2025','202503210621','20250321','0','1500.0','0','21 Mar 2025','06:21 AM','202503210621',NULL),(10,'XYZ Trader','9164000275','','1475.0','0','0','0','0','1475.0','04:42 pm','25 Mar 2025','25 Mar 2025','202503251642','20250325','1000','475.0','1000','25 Mar 2025','04:42 pm','202503251642',''),(11,'XYZ Trader','9164000275','','1475.0','0','0','0','0','1475.0','04:42 pm','25 Mar 2025','25 Mar 2025','202503251642','20250325','475','0.0','1475.0','25 Mar 2025','04:44 pm','202503251644',''),(12,'XYZ Trader','9164000275','','250.0','0','0','0','0','250.0','05:18 pm','21 Jun 2025','21 Jun 2025','202506211718','20250621','250','0.0','250','21 Jun 2025','05:18 pm','202506211718',''),(13,'Abc Enterprises ','1234567890','','100.0','0','0','0','0','100.0','06:01 pm','21 Jun 2025','21 Jun 2025','202506211801','20250621','50','50.0','50','21 Jun 2025','06:01 pm','202506211801',''),(14,'XYZ Trader','9164000275','','200000.0','0','0','0','0','200000.0','03:25 pm','30 Jun 2025','30 Jun 2025','202506301525','20250630','100000','100000.0','100000','30 Jun 2025','03:25 pm','202506301525',''),(15,'Abc Enterprises ','1234567890','','600.0','0','0','0','0','600.0','03:30 pm','30 Jun 2025','30 Jun 2025','202506301530','20250630','600','0.0','600','30 Jun 2025','03:30 pm','202506301530',''),(16,'XYZ Trader','9164000275','','200000.0','0','0','0','0','200000.0','03:25 pm','30 Jun 2025','30 Jun 2025','202506301525','20250630','100000','0.0','200000.0','30 Jun 2025','03:32 pm','202506301532',''),(17,'Abc Enterprises ','1234567890','','3000.0','0','0','0','0','3000.0','03:34 pm','30 Jun 2025','30 Jun 2025','202506301534','20250630','2000','1000.0','2000','30 Jun 2025','03:34 pm','202506301534',''),(18,'Abc Enterprises ','1234567890','','3000.0','0','0','0','0','3000.0','03:34 pm','30 Jun 2025','30 Jun 2025','202506301534','20250630','1000','0.0','3000.0','30 Jun 2025','03:35 pm','202506301535',''),(19,'Abc Enterprises ','1234567890','','1000','0','0','0','0','1000','11:11 AM','22 Jul 2025','22 Jul 2025','202507221111','20250722','500','500.0','500','22 Jul 2025','11:11 AM','202507221111',NULL),(20,'Abc Enterprises ','1234567890','','1000','0','0','0','0','1000','11:11 AM','22 Jul 2025','22 Jul 2025','202507221111','20250722','500','0.0','1000','22 Jul 2025','4:42 PM','202507221642',NULL),(21,'Abc Enterprises ','1234567890','','2960.0','0','0','0','0','2960.0','09:38 am','25 Jul 2025','25 Jul 2025','202507250938','20250725','2960','0.0','2960','25 Jul 2025','09:38 am','202507250938',''),(22,'Abc Enterprises ','1234567890','','400','0','0','0','0','400','10:05 AM','15 Feb 2025','15 Feb 2025','202502151005','20250215','100','0.0','400.0','25 Jul 2025','09:40 am','202507250940',''),(23,'Abc Enterprises ','1234567890','','950.0','0','0','0','0','950.0','04:50 pm','20 Mar 2025','20 Mar 2025','202503201650','20250320','50','0.0','950.0','25 Jul 2025','09:41 am','202507250941',''),(24,'Abc Enterprises ','1234567890','','500','0','0','0','0','500','11:40 AM','30 Jul 2025','30 Jul 2025','202507301140','20250730','500','0.0','500','30 Jul 2025','11:40 AM','202507301140',NULL),(25,'Abc Enterprises ','1234567890','','300.0','0','0','0','0','300.0','01:36 pm','08 Aug 2025','08 Aug 2025','202508081336','20250808','100.0','200.0','100.0','08 Aug 2025','01:36 pm','202508081336',''),(26,'Abc Enterprises ','1234567890','','300.0','0','0','0','0','300.0','01:36 pm','08 Aug 2025','08 Aug 2025','202508081336','20250808','200','0.0','300.0','08 Aug 2025','01:37 pm','202508081337',''),(27,'XYZ Trader','9164000275','','500.0','0','0','0','0','500.0','03:35 pm','12 Aug 2025','12 Aug 2025','202508121535','20250812','500','0.0','500','12 Aug 2025','03:35 pm','202508121535',''),(28,'XYZ Trader','9164000275','','500.0','0','0','0','0','500.0','03:29 pm','26 Aug 2025','26 Aug 2025','202508261529','20250826','300','200.0','300','26 Aug 2025','03:29 pm','202508261529',''),(29,'XYZ Trader','9164000275','','500.0','0','0','0','0','500.0','03:29 pm','26 Aug 2025','26 Aug 2025','202508261529','20250826','200','0.0','500.0','26 Aug 2025','03:33 pm','202508261533',''),(30,'Abc Enterprises ','1234567890','','250.0','0','0','0','0','250.0','03:35 pm','26 Aug 2025','26 Aug 2025','202508261535','20250826','2500','-2250.0','2500','26 Aug 2025','03:35 pm','202508261535',''),(31,'Abc Enterprises ','1234567890','','100.0','0','0','0','0','100.0','06:01 pm','21 Jun 2025','21 Jun 2025','202506211801','20250621','50','0.0','100.0','11 Oct 2025','01:11 pm','202510111311',''),(32,'Abc Enterprises ','1234567890','','1300.0','0','0','0','0','1300.0','05:36 pm','20 Mar 2025','20 Mar 2025','202503201736','20250320','300','0.0','1300.0','11 Oct 2025','01:11 pm','202510111311',''),(33,'Abc Enterprises ','1234567890','','1500','0','0','0','0','1500','06:21 AM','21 Mar 2025','21 Mar 2025','202503210621','20250321','1500','0.0','1500.0','11 Oct 2025','01:12 pm','202510111312',''),(34,'XYZ Trader','9164000275','','50.0','0','0','0','0','50.0','04:40 pm','11 Oct 2025','11 Oct 2025','202510111640','20251011','500','-450.0','500','11 Oct 2025','04:40 pm','202510111640',''),(35,'Abc Enterprises ','1234567890','','42500.0','0','0','0','0','42500.0','11:23 am','14 Oct 2025','14 Oct 2025','202510141123','20251014','0','42500.0','0','14 Oct 2025','11:23 am','202510141123',''),(36,'Abc Enterprises ','1234567890','','42500.0','0','0','0','0','42500.0','11:23 am','14 Oct 2025','14 Oct 2025','202510141123','20251014','4000','38500.0','4000.0','14 Oct 2025','11:28 am','202510141128',''),(37,'Abc Enterprises ','1234567890','','44550.0','0','0','0','0','44550.0','12:04 pm','15 Oct 2025','15 Oct 2025','202510151204','20251015','0','44550.0','0','15 Oct 2025','12:04 pm','202510151204',''),(38,'Abc Enterprises ','1234567890','','44550.0','0','0','0','0','44550.0','12:04 pm','15 Oct 2025','15 Oct 2025','202510151204','20251015','44550','0.0','44550.0','15 Oct 2025','12:06 pm','202510151206',''),(39,'IVEPOS vendor 1','9164000272','','500.0','10.0','50','0','0','550.0','12:11 pm','15 Oct 2025','15 Oct 2025','202510151211','20251015','550','0.0','550','15 Oct 2025','12:11 pm','202510151211',''),(40,'IVEPOS vendor 1','9164000272','','400.0','0','0','0','0','400.0','12:51 pm','15 Oct 2025','15 Oct 2025','202510151251','20251015','400','0.0','400','15 Oct 2025','12:51 pm','202510151251',''),(41,'Abcd Traders','9535897598','','500.0','0','0','0','0','500.0','12:14 pm','31 Oct 2025','31 Oct 2025','202510311214','20251031','500','0.0','500','31 Oct 2025','12:14 pm','202510311214',''),(42,'XYZ Trader','9164000275','','600.0','0','0','0','0','600.0','12:20 pm','31 Oct 2025','31 Oct 2025','202510311220','20251031','300','300.0','300','31 Oct 2025','12:20 pm','202510311220',''),(43,'XYZ Trader','9164000275','','600.0','0','0','0','0','600.0','12:20 pm','31 Oct 2025','31 Oct 2025','202510311220','20251031','200','100.0','500.0','31 Oct 2025','12:23 pm','202510311223',''),(44,'Abc Enterprises ','1234567890','','1000.0','0','0','0','0','1000.0','02:48 pm','11 Nov 2025','11 Nov 2025','202511111448','20251111','1000','0.0','1000','11 Nov 2025','02:48 pm','202511111448',''),(45,'XYZ Trader','9164000275','','750.0','0','0','0','0','750.0','10:34 am','19 Dec 2025','19 Dec 2025','202512191034','20251219','750','0.0','750','19 Dec 2025','10:34 am','202512191034',''),(46,'ABC','','','150','0','0','0','0','150','05:07 AM','19 Dec 2025','19 Dec 2025','202512190507','20251219','150','0.0','150','19 Dec 2025','05:07 AM','202512190507',NULL),(47,'Abc Enterprises ','1234567890','','8000.0','0','0','0','0','8000.0','11:39 am','02 Jan 2026','02 Jan 2026','202601021139','20260102','5000','3000.0','5000','02 Jan 2026','11:39 am','202601021139',''),(48,'Abc Enterprises ','1234567890','','8000.0','0','0','0','0','8000.0','11:39 am','02 Jan 2026','02 Jan 2026','202601021139','20260102','3000','0.0','8000.0','02 Jan 2026','11:44 am','202601021144',''),(49,'IVEPOS vendor 1','9164000272','','1250.0','0','0','0','0','1250.0','04:40 pm','05 Jan 2026','05 Jan 2026','202601051640','20260105','1000','250.0','1000','05 Jan 2026','04:40 pm','202601051640',''),(50,'IVEPOS vendor 1','9164000272','','1250.0','0','0','0','0','1250.0','04:40 pm','05 Jan 2026','05 Jan 2026','202601051640','20260105','250','0.0','1250.0','05 Jan 2026','04:42 pm','202601051642',''),(51,'xyz','','','300','0','0','0','0','300','06:44 AM','06 Jan 2026','06 Jan 2026','202601060644','20260106','300','0.0','300','06 Jan 2026','06:44 AM','202601060644',NULL),(52,'IVEPOSVENDOR','','','200','0','0','0','0','200','06:47 AM','06 Jan 2026','06 Jan 2026','202601060647','20260106','100','100.0','100','06 Jan 2026','06:47 AM','202601060647',NULL),(53,'Abcd Traders','9535897598','','500.0','0','0','0','0','500.0','05:03 pm','09 Jan 2026','09 Jan 2026','202601091703','20260109','500','0.0','500','09 Jan 2026','05:03 pm','202601091703',''),(54,'XYZ Trader','9164000275','','775.0','0','0','0','0','775.0','05:05 pm','09 Jan 2026','09 Jan 2026','202601091705','20260109','700','75.0','700','09 Jan 2026','05:05 pm','202601091705','');
INSERT INTO `vendor_sold_item_details` (`_id`, `vendor_name`, `vendor_phoneno`, `itemname`, `qty_add`, `individual_price`, `total_price`, `invoice`, `billamount`, `tax_percent`, `tax_amount`, `disc_percent`, `disc_amount`, `total_bill_amount`, `from_time`, `from_date`, `due_date`, `datetimee_new_from`, `datetimee_new_due`, `pay`, `pending`, `tax1`, `tax2`, `tax3`, `tax4`, `tax5`, `tax6`, `tax7`, `tax8`, `tax9`, `tax10`, `tax11`, `tax12`, `tax13`, `tax14`, `tax15`, `tax1_value`, `tax2_value`, `tax3_value`, `tax4_value`, `tax5_value`, `tax6_value`, `tax7_value`, `tax8_value`, `tax9_value`, `tax10_value`, `tax11_value`, `tax12_value`, `tax13_value`, `tax14_value`, `tax15_value`) VALUES (1,'Abc Enterprises ','1234567890','sona masoori raw rice 1kg','1','50','50.0','','50.0','0','0','0','0','50.0','11:49 AM','23 Oct 2024','23 Oct 2024','202410231149','20241023','50','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,'Abc Enterprises ','1234567890','Archana ','10','20','200.0','','4950.0','0','0','0','0','4950.0','12:25 pm','30 Dec 2024','30 Dec 2024','202412301225','20241230','49500','-44550.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'Abc Enterprises ','1234567890','Aarthi','10','25','250.0','','4950.0','0','0','0','0','4950.0','12:25 pm','30 Dec 2024','30 Dec 2024','202412301225','20241230','49500','-44550.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'Abc Enterprises ','1234567890','Ganapathi pooja','10','50','500.0','','4950.0','0','0','0','0','4950.0','12:25 pm','30 Dec 2024','30 Dec 2024','202412301225','20241230','49500','-44550.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'Abc Enterprises ','1234567890','Satyanarayana pooja','20','100','2000.0','','4950.0','0','0','0','0','4950.0','12:25 pm','30 Dec 2024','30 Dec 2024','202412301225','20241230','49500','-44550.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'Abc Enterprises ','1234567890','Navagraha pooja','10','200','2000.0','','4950.0','0','0','0','0','4950.0','12:25 pm','30 Dec 2024','30 Dec 2024','202412301225','20241230','49500','-44550.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'Abc Enterprises ','1234567890','special occasion pooja','10','1000','10000.0','','12000.0','0','0','0','0','12000.0','12:30 pm','30 Dec 2024','30 Dec 2024','202412301230','20241230','12000','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,'Abc Enterprises ','1234567890','pooja prasada','10','200','2000.0','','12000.0','0','0','0','0','12000.0','12:30 pm','30 Dec 2024','30 Dec 2024','202412301230','20241230','12000','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,'Abc Enterprises ','1234567890','cucumbers kg','10','5','50.0','','50.0','0','0','0','0','50.0','12:08 pm','20 Jan 2025','20 Jan 2025','202501201208','20250120','50','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,'Abc Enterprises ','1234567890','sona masoori raw rice 1kg','010','40','400','','400','0','0','0','0','400','10:05 AM','15 Feb 2025','15 Feb 2025','202502151005','20250215','300','100.0',NULL,NULL,NULL,NULL,NULL,NULL,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,'Abc Enterprises ','1234567890','Sales summary ','10','100','1000.0','','1900.0','0','0','0','0','1900.0','04:01 pm','18 Feb 2025','18 Feb 2025','202502181601','20250218','1900','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,'Abc Enterprises ','1234567890','Sales 2','10','90','900.0','','1900.0','0','0','0','0','1900.0','04:01 pm','18 Feb 2025','18 Feb 2025','202502181601','20250218','1900','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,'Abc Enterprises ','1234567890','sona masoori raw rice 1kg','5','40','200.0','','950.0','0','0','0','0','950.0','04:50 pm','20 Mar 2025','20 Mar 2025','202503201650','20250320','900','50.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'Abc Enterprises ','1234567890','tata urad dal whole white 1kg','5','150','750.0','','950.0','0','0','0','0','950.0','04:50 pm','20 Mar 2025','20 Mar 2025','202503201650','20250320','900','50.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'Abc Enterprises ','1234567890','fig fruit kg','30','30','900.0','','1300.0','0','0','0','0','1300.0','05:36 pm','20 Mar 2025','20 Mar 2025','202503201736','20250320','1000','300.0',NULL,NULL,NULL,NULL,NULL,NULL,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,'Abc Enterprises ','1234567890','ladies finger kg','20','20','400.0','','1300.0','0','0','0','0','1300.0','05:36 pm','20 Mar 2025','20 Mar 2025','202503201736','20250320','1000','300.0',NULL,NULL,NULL,NULL,NULL,NULL,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,'Abc Enterprises ','1234567890','fig fruit kg','10','30','300','','300','0','0','0','0','300','06:20 AM','21 Mar 2025','21 Mar 2025','202503210620','20250321','300','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,'Abc Enterprises ','1234567890','sona masoori raw rice 1kg','25','60','1500','','1500','0','0','0','0','1500','06:21 AM','21 Mar 2025','21 Mar 2025','202503210621','20250321','0','1500.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'XYZ Trader','9164000275','sona masoori raw rice 1kg','5','60','300.0','','1475.0','0','0','0','0','1475.0','04:42 pm','25 Mar 2025','25 Mar 2025','202503251642','20250325','1000','475.0',NULL,NULL,NULL,NULL,NULL,NULL,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,'XYZ Trader','9164000275','tata urad dal whole white 1kg','5','150','750.0','','1475.0','0','0','0','0','1475.0','04:42 pm','25 Mar 2025','25 Mar 2025','202503251642','20250325','1000','475.0',NULL,NULL,NULL,NULL,NULL,NULL,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,'XYZ Trader','9164000275','fig fruit kg','5','30','150.0','','1475.0','0','0','0','0','1475.0','04:42 pm','25 Mar 2025','25 Mar 2025','202503251642','20250325','1000','475.0',NULL,NULL,NULL,NULL,NULL,NULL,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,'XYZ Trader','9164000275','capsicum green kg','5','30','150.0','','1475.0','0','0','0','0','1475.0','04:42 pm','25 Mar 2025','25 Mar 2025','202503251642','20250325','1000','475.0',NULL,NULL,NULL,NULL,NULL,NULL,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,'XYZ Trader','9164000275','beet root kg','5','25','125.0','','1475.0','0','0','0','0','1475.0','04:42 pm','25 Mar 2025','25 Mar 2025','202503251642','20250325','1000','475.0',NULL,NULL,NULL,NULL,NULL,NULL,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,'XYZ Trader','9164000275','carrots kg','5','50','250.0','','250.0','0','0','0','0','250.0','05:18 pm','21 Jun 2025','21 Jun 2025','202506211718','20250621','250','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'Abc Enterprises ','1234567890','ladies finger kg','5','20','100.0','','100.0','0','0','0','0','100.0','06:01 pm','21 Jun 2025','21 Jun 2025','202506211801','20250621','50','50.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'XYZ Trader','9164000275','One plus nord 5g','20000','10','200000.0','','200000.0','0','0','0','0','200000.0','03:25 pm','30 Jun 2025','30 Jun 2025','202506301525','20250630','100000','100000.0',NULL,NULL,NULL,NULL,NULL,NULL,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,'Abc Enterprises ','1234567890','sona masoori raw rice 1kg','10','60','600.0','','600.0','0','0','0','0','600.0','03:30 pm','30 Jun 2025','30 Jun 2025','202506301530','20250630','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),(28,'Abc Enterprises ','1234567890','tata urad dal whole white 1kg','20','150','3000.0','','3000.0','0','0','0','0','3000.0','03:34 pm','30 Jun 2025','30 Jun 2025','202506301534','20250630','2000','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),(29,'Abc Enterprises ','1234567890','Fevicol 1 kg','10','100','1000','','1000','0','0','0','0','1000','11:11 AM','22 Jul 2025','22 Jul 2025','202507221111','20250722','500','500.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'Abc Enterprises ','1234567890','urad gota whole 500g','5','100','500.0','','2960.0','0','0','0','0','2960.0','09:38 am','25 Jul 2025','25 Jul 2025','202507250938','20250725','2960','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,'Abc Enterprises ','1234567890','urad dal split 2kg','10','120','1200.0','','2960.0','0','0','0','0','2960.0','09:38 am','25 Jul 2025','25 Jul 2025','202507250938','20250725','2960','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,'Abc Enterprises ','1234567890','toor dal 500g','7','180','1260.0','','2960.0','0','0','0','0','2960.0','09:38 am','25 Jul 2025','25 Jul 2025','202507250938','20250725','2960','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,'Abc Enterprises ','1234567890','sona masoori raw rice 1kg','10','50','500','','500','0','0','0','0','500','11:40 AM','30 Jul 2025','30 Jul 2025','202507301140','20250730','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),(34,'Abc Enterprises ','1234567890','fig fruit kg','10','30','300.0','','300.0','0','0','0','0','300.0','01:36 pm','08 Aug 2025','08 Aug 2025','202508081336','20250808','100.0','200.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,'XYZ Trader','9164000275','carrots kg','10','50','500.0','','500.0','0','0','0','0','500.0','03:35 pm','12 Aug 2025','12 Aug 2025','202508121535','20250812','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),(36,'XYZ Trader','9164000275','sona masoori raw rice 1kg','10','50','500.0','','500.0','0','0','0','0','500.0','03:29 pm','26 Aug 2025','26 Aug 2025','202508261529','20250826','300','200.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,'Abc Enterprises ','1234567890','cauliflower kg','20','10','200.0','','250.0','0','0','0','0','250.0','03:35 pm','26 Aug 2025','26 Aug 2025','202508261535','20250826','2500','-2250.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'Abc Enterprises ','1234567890','sweet corn piece','5','10','50.0','','250.0','0','0','0','0','250.0','03:35 pm','26 Aug 2025','26 Aug 2025','202508261535','20250826','2500','-2250.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,'XYZ Trader','9164000275','sona masoori raw rice 1kg','1','50','50.0','','50.0','0','0','0','0','50.0','04:40 pm','11 Oct 2025','11 Oct 2025','202510111640','20251011','500','-450.0',NULL,NULL,NULL,NULL,NULL,NULL,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,'Abc Enterprises ','1234567890','Cricket bat','50','400','20000.0','','42500.0','0','0','0','0','42500.0','11:23 am','14 Oct 2025','14 Oct 2025','202510141123','20251014','0','42500.0',NULL,NULL,NULL,NULL,NULL,NULL,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,'Abc Enterprises ','1234567890','Badminton racket ','50','450','22500.0','','42500.0','0','0','0','0','42500.0','11:23 am','14 Oct 2025','14 Oct 2025','202510141123','20251014','0','42500.0',NULL,NULL,NULL,NULL,NULL,NULL,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,'Abc Enterprises ','1234567890','tata urad dal whole white 1kg','297','150','44550.0','','44550.0','0','0','0','0','44550.0','12:04 pm','15 Oct 2025','15 Oct 2025','202510151204','20251015','0','44550.0',NULL,NULL,NULL,NULL,NULL,NULL,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,'IVEPOS vendor 1','9164000272','sona masoori raw rice 1kg','10','50','500.0','','500.0','10.0','50','0','0','550.0','12:11 pm','15 Oct 2025','15 Oct 2025','202510151211','20251015','550','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,'IVEPOS vendor 1','9164000272','Yoghurt ','10','40','400.0','','400.0','0','0','0','0','400.0','12:51 pm','15 Oct 2025','15 Oct 2025','202510151251','20251015','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),(45,'Abcd Traders','9535897598','sona masoori raw rice 1kg','10','50','500.0','','500.0','0','0','0','0','500.0','12:14 pm','31 Oct 2025','31 Oct 2025','202510311214','20251031','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),(46,'XYZ Trader','9164000275','nutella','20','30','600.0','','600.0','0','0','0','0','600.0','12:20 pm','31 Oct 2025','31 Oct 2025','202510311220','20251031','300','300.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(47,'Abc Enterprises ','1234567890','Chain 1gm ','10','100','1000.0','','1000.0','0','0','0','0','1000.0','02:48 pm','11 Nov 2025','11 Nov 2025','202511111448','20251111','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),(48,'XYZ Trader','9164000275','fig fruit kg','15','30','450.0','','750.0','0','0','0','0','750.0','10:34 am','19 Dec 2025','19 Dec 2025','202512191034','20251219','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),(49,'XYZ Trader','9164000275','ladies finger kg','15','20','300.0','','750.0','0','0','0','0','750.0','10:34 am','19 Dec 2025','19 Dec 2025','202512191034','20251219','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),(50,'ABC','','capsicum green kg','05','30','150','','150','0','0','0','0','150','05:07 AM','19 Dec 2025','19 Dec 2025','202512190507','20251219','150','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(51,'Abc Enterprises ','1234567890','Scissors ','10','800','8000.0','','8000.0','0','0','0','0','8000.0','11:39 am','02 Jan 2026','02 Jan 2026','202601021139','20260102','5000','3000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52,'IVEPOS vendor 1','9164000272','sona masoori raw rice 1kg','10','50','500.0','','1250.0','0','0','0','0','1250.0','04:40 pm','05 Jan 2026','05 Jan 2026','202601051640','20260105','1000','250.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(53,'IVEPOS vendor 1','9164000272','tata urad dal whole white 1kg','5','150','750.0','','1250.0','0','0','0','0','1250.0','04:40 pm','05 Jan 2026','05 Jan 2026','202601051640','20260105','1000','250.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(54,'xyz','','beans kg','10','30','300','','300','0','0','0','0','300','06:44 AM','06 Jan 2026','06 Jan 2026','202601060644','20260106','300','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(55,'IVEPOSVENDOR','','sweet corn piece','20','10','200','','200','0','0','0','0','200','06:47 AM','06 Jan 2026','06 Jan 2026','202601060647','20260106','100','100.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(56,'Abcd Traders','9535897598','sona masoori raw rice 1kg','10','50','500.0','','500.0','0','0','0','0','500.0','05:03 pm','09 Jan 2026','09 Jan 2026','202601091703','20260109','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),(57,'XYZ Trader','9164000275','tata urad dal whole white 1kg','5','150','750.0','','775.0','0','0','0','0','775.0','05:05 pm','09 Jan 2026','09 Jan 2026','202601091705','20260109','700','75.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(58,'XYZ Trader','9164000275','cucumbers kg','5','5','25.0','','775.0','0','0','0','0','775.0','05:05 pm','09 Jan 2026','09 Jan 2026','202601091705','20260109','700','75.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `vendor_temp_list` (`_id`, `vendor_name`, `vend_phon`, `vend_email`, `vend_gst`, `vend_address`, `vend_total_bill_amount`, `paid`, `pending`, `bill_no`) VALUES (1,'Abc Enterprises ','1234567890','','','Bangalore ','0.0','0.0','0.0','0'),(2,'Abc Enterprises ','1234567890','','','Bangalore ','17000.0','61550.0','-44550.0','3'),(3,'Abc Enterprises ','1234567890','','','Bangalore ','17000.0','61550.0','-44550.0','3'),(4,'Abc Enterprises ','1234567890','','','Bangalore ','17050.0','61600.0','-44550.0','4'),(5,'Abc Enterprises ','1234567890','','','Bangalore ','17050.0','61600.0','-44550.0','4'),(6,'Abc Enterprises ','1234567890','','','Bangalore ','17050.0','61600.0','-44550.0','4'),(7,'Abc Enterprises ','1234567890','','','Bangalore ','17050.0','61600.0','-44550.0','4'),(8,'Abc Enterprises ','1234567890','','','Bangalore ','18400.0','62800.0','-44400.0','6'),(9,'Abc Enterprises ','1234567890','','','Bangalore ','19700.0','63800.0','-44100.0','7'),(10,'Abc Enterprises ','1234567890','','','Bangalore ','21500.0','64100.0','-42600.0','9'),(11,'XYZ Trader','9164000275','','','Bangalore ','1475.0','1000.0','475.0','1'),(12,'Abc Enterprises ','1234567890','','','Bangalore ','21500.0','64100.0','-42600.0','9'),(13,'XYZ Trader','9164000275','','','Bangalore ','1475.0','1475.0','0.0','1'),(14,'Abc Enterprises ','1234567890','','','Bangalore ','21600.0','64150.0','-42550.0','10'),(15,'XYZ Trader','9164000275','','','Bangalore ','201725.0','101725.0','100000.0','3'),(16,'Abc Enterprises ','1234567890','','','Bangalore ','25200.0','66750.0','-41550.0','12'),(17,'XYZ Trader','9164000275','','','Bangalore ','201725.0','201725.0','0.0','3'),(18,'Abc Enterprises ','1234567890','','','Bangalore ','26200.0','68750.0','-42550.0','13'),(19,'XYZ Trader','9164000275','','','Bangalore ','201725.0','201725.0','0.0','3'),(20,'Abc Enterprises ','1234567890','','','Bangalore ','29160.0','71710.0','-42550.0','14'),(21,'XYZ Trader','9164000275','','','Bangalore ','201725.0','201725.0','0.0','3'),(22,'Abc Enterprises ','1234567890','','','Bangalore ','29960.0','72460.0','-42500.0','16'),(23,'XYZ Trader','9164000275','','','Bangalore ','201725.0','201725.0','0.0','3'),(24,'Abc Enterprises ','1234567890','','','Bangalore ','29960.0','72660.0','-42700.0','16'),(25,'XYZ Trader','9164000275','','','Bangalore ','202725.0','202525.0','200.0','5'),(26,'Abc Enterprises ','1234567890','','','Bangalore ','30210.0','75160.0','-44950.0','17'),(27,'XYZ Trader','9164000275','','','Bangalore ','202725.0','202725.0','0.0','5'),(28,'Abc Enterprises ','1234567890','','','Bangalore ','30210.0','75160.0','-44950.0','17'),(29,'XYZ Trader','9164000275','','','Bangalore ','202725.0','202725.0','0.0','5'),(30,'Abc Enterprises ','1234567890','','','Bangalore ','30210.0','75160.0','-44950.0','17'),(31,'XYZ Trader','9164000275','','','Bangalore ','202725.0','202725.0','0.0','5'),(32,'Abc Enterprises ','1234567890','','','Bangalore ','30210.0','75160.0','-44950.0','17'),(33,'XYZ Trader','9164000275','','','Bangalore ','202725.0','202725.0','0.0','5'),(34,'vendor 3- rushali ','9876543210','sales@ivepos.com','','Bangalore ','0.0','0.0','0.0','0'),(35,'Abc Enterprises ','1234567890','','','Bangalore ','30210.0','77010.0','-46800.0','17'),(36,'XYZ Trader','9164000275','','','Bangalore ','202725.0','202725.0','0.0','5'),(37,'vendor 3- rushali ','9876543210','sales@ivepos.com','','Bangalore ','0.0','0.0','0.0','0'),(38,'Abc Enterprises ','1234567890','','','Bangalore ','30210.0','77010.0','-46800.0','17'),(39,'XYZ Trader','9164000275','','','Bangalore ','202775.0','203225.0','-450.0','6'),(40,'Abcd Traders','9535897598','ivepos','','','0.0','0.0','0.0','0'),(41,'Abcd Traders','9535897598','','','Bangalore','0.0','0.0','0.0','0'),(42,'Abcd Traders','9535897598','','','Bangalore','0.0','0.0','0.0','0'),(43,' Abc Enterprises','1234567890','','','Bangalore','0.0','0.0','0.0','0'),(44,'Abc Enterprises ','1234567890','','','Bangalore ','72710.0','81010.0','-8300.0','18'),(45,'XYZ Trader','9164000275','','','Bangalore ','202775.0','203225.0','-450.0','6'),(46,'Abcd Traders','9535897598','ivepos','','','0.0','0.0','0.0','0'),(47,'Abcd Traders','9535897598','','','Bangalore','0.0','0.0','0.0','0'),(48,'Abcd Traders','9535897598','','','Bangalore','0.0','0.0','0.0','0'),(49,' Abc Enterprises','1234567890','','','Bangalore','0.0','0.0','0.0','0'),(56,'Abc Enterprises ','1234567890','','','Bangalore ','72710.0','81010.0','-8300.0','18'),(57,'XYZ Trader','9164000275','','','Bangalore ','202775.0','203225.0','-450.0','6'),(58,'Rice  Traders','9535518252','','','Bangalore ','0.0','0.0','0.0','0'),(59,'Rice  Traders','9535518252','','','Bangalore ','0.0','0.0','0.0','0'),(60,'Rice  Traders','9535518252','','','Bangalore ','0.0','0.0','0.0','0'),(61,' Abc Enterprises','1234567890','','','Bangalore','0.0','0.0','0.0','0'),(62,'Abc Enterprises ','1234567890','','','Bangalore ','117260.0','81010.0','36250.0','19'),(63,'XYZ Trader','9164000275','','','Bangalore ','202775.0','203225.0','-450.0','6'),(64,'Rice  Traders','9535518252','','','Bangalore ','0.0','0.0','0.0','0'),(65,'Rice  Traders','9535518252','','','Bangalore ','0.0','0.0','0.0','0'),(66,'Rice  Traders','9535518252','','','Bangalore ','0.0','0.0','0.0','0'),(67,' Abc Enterprises','1234567890','','','Bangalore','0.0','0.0','0.0','0'),(68,'Abc Enterprises ','1234567890','','','Bangalore ','117260.0','125560.0','-8300.0','19'),(69,'XYZ Trader','9164000275','','','Bangalore ','202775.0','203225.0','-450.0','6'),(70,'Rice  Traders','9535518252','','','Bangalore ','0.0','0.0','0.0','0'),(71,'Rice  Traders','9535518252','','','Bangalore ','0.0','0.0','0.0','0'),(72,'Rice  Traders','9535518252','','','Bangalore ','0.0','0.0','0.0','0'),(73,' Abc Enterprises','1234567890','','','Bangalore','0.0','0.0','0.0','0'),(74,'Abc Enterprises ','1234567890','','','Bangalore ','117260.0','125560.0','-8300.0','19'),(75,'XYZ Trader','9164000275','','','Bangalore ','202775.0','203225.0','-450.0','6'),(76,'Rice  Traders','9535518252','','','Bangalore ','0.0','0.0','0.0','0'),(77,'Rice  Traders','9535518252','','','Bangalore ','0.0','0.0','0.0','0'),(78,'Rice  Traders','9535518252','','','Bangalore ','0.0','0.0','0.0','0'),(79,' Abc Enterprises','1234567890','','','Bangalore','0.0','0.0','0.0','0'),(86,'Abc Enterprises ','1234567890','','','Bangalore ','117260.0','125560.0','-8300.0','19'),(87,'XYZ Trader','9164000275','','','Bangalore ','202775.0','203225.0','-450.0','6'),(88,'Rice  Traders','9535518252','','','Bangalore ','0.0','0.0','0.0','0'),(89,'Rice  Traders','9535518252','','','Bangalore ','0.0','0.0','0.0','0'),(90,'Rice  Traders','9535518252','','','Bangalore ','0.0','0.0','0.0','0'),(91,' Abc Enterprises','1234567890','','','Bangalore','0.0','0.0','0.0','0'),(92,'IVEPOS vendor 1','9164000272','','','Chennai ','0.0','0.0','0.0','0'),(93,'Abc Enterprises ','1234567890','','','Bangalore ','117260.0','125560.0','-8300.0','19'),(94,'XYZ Trader','9164000275','','','Bangalore ','202775.0','203225.0','-450.0','6'),(95,'Rice  Traders','9535518252','','','Bangalore ','0.0','0.0','0.0','0'),(96,'Rice  Traders','9535518252','','','Bangalore ','0.0','0.0','0.0','0'),(97,'Rice  Traders','9535518252','','','Bangalore ','0.0','0.0','0.0','0'),(98,' Abc Enterprises','1234567890','','','Bangalore','0.0','0.0','0.0','0'),(99,'IVEPOS vendor 1','9164000272','','','Chennai ','550.0','550.0','0.0','1'),(100,'Abc Enterprises ','1234567890','','','Bangalore ','117260.0','125560.0','-8300.0','19'),(101,'XYZ Trader','9164000275','','','Bangalore ','202775.0','203225.0','-450.0','6'),(102,'Rice  Traders','9535518252','','','Bangalore ','0.0','0.0','0.0','0'),(103,'Rice  Traders','9535518252','','','Bangalore ','0.0','0.0','0.0','0'),(104,'Rice  Traders','9535518252','','','Bangalore ','0.0','0.0','0.0','0'),(105,' Abc Enterprises','1234567890','','','Bangalore','0.0','0.0','0.0','0'),(106,'IVEPOS vendor 1','9164000272','','','Chennai ','950.0','950.0','0.0','2'),(107,'Abc Enterprises ','1234567890','','','Bangalore ','117260.0','125560.0','-8300.0','19'),(108,'XYZ Trader','9164000275','','','Bangalore ','202775.0','203225.0','-450.0','6'),(109,'Abcd Traders','9535897598','ivepos','','','500.0','500.0','0.0','1'),(110,'Abcd Traders','9535897598','','','Bangalore','500.0','500.0','0.0','1'),(111,'Abcd Traders','9535897598','','','Bangalore','500.0','500.0','0.0','1'),(112,' Abc Enterprises','1234567890','','','Bangalore','0.0','0.0','0.0','0'),(113,'IVEPOS vendor 1','9164000272','','','Chennai ','950.0','950.0','0.0','2'),(114,'Abc Enterprises ','1234567890','','','Bangalore ','117260.0','125560.0','-8300.0','19'),(115,'XYZ Trader','9164000275','','','Bangalore ','203375.0','203525.0','-150.0','7'),(116,'Abcd Traders','9535897598','ivepos','','','500.0','500.0','0.0','1'),(117,'Abcd Traders','9535897598','','','Bangalore','500.0','500.0','0.0','1'),(118,'Abcd Traders','9535897598','','','Bangalore','500.0','500.0','0.0','1'),(119,' Abc Enterprises','1234567890','','','Bangalore','0.0','0.0','0.0','0'),(120,'IVEPOS vendor 1','9164000272','','','Chennai ','950.0','950.0','0.0','2'),(135,'Abc Enterprises ','1234567890','','','Bangalore ','117260.0','125560.0','-8300.0','19'),(136,'XYZ Trader','9164000275','','','Bangalore ','203375.0','203725.0','-350.0','7'),(137,'Abcd Traders','9535897598','ivepos','','','500.0','500.0','0.0','1'),(138,'Abcd Traders','9535897598','','','Bangalore','500.0','500.0','0.0','1'),(139,'Abcd Traders','9535897598','','','Bangalore','500.0','500.0','0.0','1'),(140,' Abc Enterprises','1234567890','','','Bangalore','0.0','0.0','0.0','0'),(141,'IVEPOS vendor 1','9164000272','','','Chennai ','950.0','950.0','0.0','2'),(149,'Abc Enterprises ','1234567890','','','Bangalore ','118260.0','126560.0','-8300.0','20'),(150,'XYZ Trader','9164000275','','','Bangalore ','203375.0','203725.0','-350.0','7'),(151,'Abcd Traders','9535897598','ivepos','','','500.0','500.0','0.0','1'),(152,'Abcd Traders','9535897598','','','Bangalore','500.0','500.0','0.0','1'),(153,'Abcd Traders','9535897598','','','Bangalore','500.0','500.0','0.0','1'),(154,' Abc Enterprises','1234567890','','','Bangalore','0.0','0.0','0.0','0'),(155,'IVEPOS vendor 1','9164000272','','','Chennai ','950.0','950.0','0.0','2'),(156,'Abc Enterprises ','1234567890','','','Bangalore ','126260.0','134560.0','-8300.0','21'),(157,'XYZ Trader','9164000275','','','Bangalore ','204125.0','204475.0','-350.0','8'),(158,'Abcd Traders','9535897598','ivepos','','','500.0','500.0','0.0','1'),(159,'Abcd Traders','9535897598','','','Bangalore','500.0','500.0','0.0','1'),(160,'Abcd Traders','9535897598','','','Bangalore','500.0','500.0','0.0','1'),(161,' Abc Enterprises','1234567890','','','Bangalore','0.0','0.0','0.0','0'),(162,'IVEPOS vendor 1','9164000272','','','Chennai ','950.0','950.0','0.0','2'),(163,'Abc Enterprises ','1234567890','','','Bangalore ','126260.0','134560.0','-8300.0','21'),(164,'XYZ Trader','9164000275','','','Bangalore ','204125.0','204475.0','-350.0','8'),(165,'Abcd Traders','9535897598','ivepos','','','500.0','500.0','0.0','1'),(166,'Abcd Traders','9535897598','','','Bangalore','500.0','500.0','0.0','1'),(167,'Abcd Traders','9535897598','','','Bangalore','500.0','500.0','0.0','1'),(168,' Abc Enterprises','1234567890','','','Bangalore','0.0','0.0','0.0','0'),(169,'IVEPOS vendor 1','9164000272','','','Chennai ','2200.0','1950.0','250.0','3'),(170,'Abc Enterprises ','1234567890','','','Bangalore ','126260.0','134560.0','-8300.0','21'),(171,'XYZ Trader','9164000275','','','Bangalore ','204125.0','204475.0','-350.0','8'),(172,'Abcd Traders','9535897598','ivepos','','','500.0','500.0','0.0','1'),(173,'Abcd Traders','9535897598','','','Bangalore','500.0','500.0','0.0','1'),(174,'Abcd Traders','9535897598','','','Bangalore','500.0','500.0','0.0','1'),(175,' Abc Enterprises','1234567890','','','Bangalore','0.0','0.0','0.0','0'),(176,'IVEPOS vendor 1','9164000272','','','Chennai ','2200.0','2200.0','0.0','3'),(177,'Test vendor ','9740157140','','','City Market Bangalore ','0.0','0.0','0.0','0'),(178,'Abc Enterprises ','1234567890','','','Bangalore ','126260.0','134560.0','-8300.0','21'),(179,'XYZ Trader','9164000275','','','Bangalore ','204125.0','204475.0','-350.0','8'),(180,'Abcd Traders','9535897598','ivepos','','','1000.0','1000.0','0.0','2'),(181,'Abcd Traders','9535897598','','','Bangalore','1000.0','1000.0','0.0','2'),(182,'Abcd Traders','9535897598','','','Bangalore','1000.0','1000.0','0.0','2'),(183,' Abc Enterprises','1234567890','','','Bangalore','0.0','0.0','0.0','0'),(184,'IVEPOS vendor 1','9164000272','','','Chennai ','2200.0','2200.0','0.0','3'),(185,'Test vendor ','9740157140','','','City Market Bangalore ','0.0','0.0','0.0','0'),(186,'Reshma ','9535897598','ivepos','','#603, 6th floor, Gamma block, Sigma Tech Park,white Field, Bangalore - 560066','0.0','0.0','0.0','0'),(187,'Reshma Syed','9535897598','ivepos','','#603, 6th floor, Gamma block, Sigma Tech Park,white Field, Bangalore - 560066','0.0','0.0','0.0','0'),(188,'IVEPOSVENDOR','9740157140','ivepos','','Bangalore','0.0','0.0','0.0','0');
INSERT INTO `version_control` (`_id`, `version`) VALUES (1,'12');
INSERT INTO `weighing_scale_name` (`_id`, `scale_name`) VALUES (1,'');
INSERT INTO `weighing_scale_status` (`_id`, `Weighing_Scale_onoff`) VALUES (1,'Not Connected');
INSERT INTO `working_hours` (`_id`, `opening`, `opening_time`, `closing`, `closing_time`, `opening_time_system`, `closing_time_system`) VALUES (1,'Today','12:01 AM','Today','11:59 PM','00:01','23:59');
