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');
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 `auto_sync_inventory` (`_id`, `control_auto_sync_type`) 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,'ezetap','','','Not Activated'),(7,'mosambee','',NULL,'Not Activated'),(8,'mosambeep10','',NULL,'Not Activated'),(9,'bijlipay','beq08545',NULL,'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 (30,'Intuition',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'www.intuitionsoftwares.com',NULL,NULL);
INSERT INTO `country_selection` (`_id`, `country`) VALUES (1,'Rupee');
INSERT INTO `default_credit` (`_id`, `status`) VALUES (1,'off');
INSERT INTO `deletedb_time` (`_id`, `time`) VALUES (1,'11:30 PM');
INSERT INTO `deletedbon_off` (`_id`, `status`) VALUES (1,'off');
INSERT INTO `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);
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`, `batch_no`, `expiry`, `sch`, `online_avail_temp`, `online_avail`, `online_price`, `vendor_name`, `vendor_id`, `purchase_price`) VALUES (1,'test cost price',2.00,0,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','te','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'Jutebag',2.00,0,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ju','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'coir bag',2.00,0,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','co','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'honey 2',2.00,0,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ho','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'Mat',2.00,0,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ma','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'Shoe',2.00,0,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Sh','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'Test new product addition',12.00,0,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Te','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'Test 2',15.00,0,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Te','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'Idly',10.00,8,'None','None','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ID','',NULL,NULL,2,NULL,NULL,NULL,'',NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'Vada',20.00,10,'None','None','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','VA','',NULL,NULL,0,NULL,NULL,NULL,'',NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VEN001',NULL),(11,'Dosa',20.00,10,'None','None','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','DO','',NULL,NULL,0,NULL,NULL,NULL,'',NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VEN001',NULL),(12,'Pongal',30.00,1,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Po','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'star vendor','VEN001','20');
INSERT INTO `items_temp_list` (`_id`, `itemname`, `avg_price`, `min_price`, `max_price`, `total_qty`, `total_price`, `barcode`, `not_required`) VALUES (1,'Mat','1.0','1.0','1.0','10.0','10.0','',''),(2,'Shoe','1.0','1.0','1.0','10.0','10.0','',''),(3,'coir bag','1.0','1.0','1.0','10.0','10.0','',''),(4,'honey','1.0','1.0','1.0','2.0','2.0','',''),(5,'bag1','0.5','0.5','0.5','5.0','2.5','',''),(6,'Mat','1.0','1.0','1.0','10.0','10.0','',''),(7,'Shoe','1.0','1.0','1.0','10.0','10.0','','');
INSERT INTO `itemsort` (`_id`, `itemsorttype`) VALUES (1,'Sort by Qty.(H -> L)');
INSERT INTO `kot_print` (`_id`, `kot_print_status`) VALUES (1,'Yes');
INSERT INTO `loyalty_points` (`_id`, `money`, `point`, `point2`, `money2`) VALUES (1,'0','0','0','0');
INSERT INTO `loyalty_points_status` (`_id`, `status`) VALUES (1,'no');
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 `payment_details` (`my_row_id`, `id`, `account_no`, `account_ifsc`) VALUES (3,'1','8111803277','IDIB000N033');
INSERT INTO `payment_requests` (`id`, `request_id`, `vendor_id`, `vendor_name`, `amount`, `payment_type`, `description`, `status`, `created_by`, `approved_by`, `rejection_reason`, `created_at`, `approved_at`, `db_name`) VALUES (1,'REQ-1764594887088',1,'star vendor',415.00,'vendor','test payout','REJECTED','vishalkp@bijlipay.co.in','eniyan@bijlipay.co.in','duplicate payout testing','2025-12-01 13:14:47','2025-12-01 13:23:45','8971536460retail_chennai_tnagar'),(2,'REQ-1764594911293',1,'star vendor',415.00,'vendor','test payout 2','APPROVED','vishalkp@bijlipay.co.in','eniyan@bijlipay.co.in',NULL,'2025-12-01 13:15:11','2025-12-01 13:23:57','8971536460retail_chennai_tnagar'),(3,'REQ-1764665533382',2,'diamond vendor',10.00,'vendor','','APPROVED','vishalkp@bijlipay.co.in','eniyan@bijlipay.co.in',NULL,'2025-12-02 08:52:13','2025-12-03 11:32:35','8971536460retail_chennai_tnagar'),(4,'REQ-1764665609728',5,'Test Vendor2',7.00,'vendor','','PENDING','vishalkp@bijlipay.co.in',NULL,NULL,'2025-12-02 08:53:29',NULL,'8971536460retail_chennai_tnagar'),(5,'REQ-1764665685021',3,'Mathi vendor',11.00,'vendor','','PENDING','vishalkp@bijlipay.co.in',NULL,NULL,'2025-12-02 08:54:45',NULL,'8971536460retail_chennai_tnagar'),(6,'REQ-1764665745451',4,'Test Vendor1',2.00,'vendor','','PENDING','vishalkp@bijlipay.co.in',NULL,NULL,'2025-12-02 08:55:45',NULL,'8971536460retail_chennai_tnagar'),(7,'REQ-1764749553672',4,'Test Vendor1',1.00,'vendor','','PENDING','vishalkp@bijlipay.co.in',NULL,NULL,'2025-12-03 08:12:33',NULL,'8971536460retail_chennai_tnagar'),(8,'REQ-1764761140718',4,'Test Vendor1',2.00,'vendor','','PENDING','vishalkp@bijlipay.co.in',NULL,NULL,'2025-12-03 11:25:40',NULL,'8971536460retail_chennai_tnagar'),(9,'REQ-1775727612271',4,'Test Vendor1',4.00,'vendor','','PENDING','+918971536460',NULL,NULL,'2026-04-09 09:40:12',NULL,'8971536460retail_chennai_tnagar'),(10,'REQ-1775727624985',4,'Test Vendor1',9.00,'profit','','PENDING','+918971536460',NULL,NULL,'2026-04-09 09:40:25',NULL,'8971536460retail_chennai_tnagar');
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,'bijlipay');
INSERT INTO `printerreceiptsize` (`_id`, `papersize`) VALUES (1,'2 inch');
INSERT INTO `razorpaymerchantreg` (`_id`, `account`, `account_id`) VALUES (1,'Not_Registered','');
INSERT INTO `round_off` (`_id`, `round_off_status`) VALUES (1,'No');
INSERT INTO `schedule_mail_on_off` (`_id`, `status`) VALUES (1,'Off');
INSERT INTO `schedule_mail_time` (`_id`, `time`) VALUES (1,'11:30 PM');
INSERT INTO `stockcontrol` (`_id`, `stockcontroltype`) VALUES (1,'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 `totaltables` (`_id`, `nooftables`) VALUES (1,'4');
INSERT INTO `user_privilege` (`_id`, `username`, `returns_refunds`, `product_tax`, `reports`, `settings`, `backup`, `customer`, `ingredients`, `subscriptions`) VALUES (1,'user1','no','no','no','no','no','no','no','no'),(2,'user2','no','no','no','no','no','no','no','no'),(3,'user3','no','no','no','no','no','no','no','no'),(4,'user4','no','no','no','no','no','no','no','no'),(5,'user5','no','no','no','no','no','no','no','no'),(6,'user6','no','no','no','no','no','no','no','no');
INSERT INTO `vendor_details` (`_id`, `vendor_name`, `vendor_phoneno`, `vendor_email`, `vendor_address`, `vendor_gst`, `vendor_id`, `vendor_account_no`, `vendor_account_ifsc`) VALUES (1,'star vendor','8965321470','','','','VEN001','',''),(2,'diamond vendor','9876543212','','','','VEN002','',''),(3,'Mathi vendor','9876543210','','','','VEN003','',''),(4,'Test Vendor1','9876543210','','','','VEN004','7277731819','IDIB000N033'),(5,'Test Vendor2','8564632598','','','','VEN005','123456042','SBIN0000001');
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,'star vendor','8965321470','','10.0','0','0','0','0','10.0','06:32 PM','21 Aug 2025','21 Aug 2025','202508211832','20250821','0','10.0','0','21 Aug 2025','06:32 PM','202508211832',''),(2,'diamond vendor','9876543212','','10.0','0','0','0','0','10.0','01:44 PM','25 Aug 2025','25 Aug 2025','202508251344','20250825','0','10.0','0','25 Aug 2025','01:44 PM','202508251344',''),(3,'Mathi vendor','9876543210','','10.0','0','0','0','0','10.0','05:30 PM','25 Aug 2025','25 Aug 2025','202508251730','20250825','0','10.0','0','25 Aug 2025','05:30 PM','202508251730',''),(4,'Mathi vendor','9876543210','','2.0','0','0','0','0','2.0','05:31 PM','25 Aug 2025','25 Aug 2025','202508251731','20250825','0','2.0','0','25 Aug 2025','05:31 PM','202508251731',''),(5,'Mathi vendor','9876543210','','2.5','0','0','0','0','2.5','05:33 PM','25 Aug 2025','25 Aug 2025','202508251733','20250825','0','2.5','0','25 Aug 2025','05:33 PM','202508251733',''),(6,'Test Vendor1','9876543210','','10.0','0','0','0','0','10.0','01:43 PM','28 Aug 2025','28 Aug 2025','202508281343','20250828','0','10.0','0','28 Aug 2025','01:43 PM','202508281343',''),(7,'Test Vendor2','8564632598','','10.0','0','0','0','0','10.0','01:49 PM','28 Aug 2025','28 Aug 2025','202508281349','20250828','0','10.0','0','28 Aug 2025','01:49 PM','202508281349',''),(8,'star vendor','8965321470','','10.0','0','0','0','0','10.0','04:31 PM','08 Sep 2025','08 Sep 2025','202509081631','20250908','0','10.0','0','08 Sep 2025','04:31 PM','202509081631',''),(9,'star vendor','8965321470','','1.0','0','0','0','0','1.0','06:29 PM','17 Oct 2025','17 Oct 2025','202510171829','20251017','0','1.0','0','17 Oct 2025','06:29 PM','202510171829',''),(10,'star vendor','8965321470','','5.0','0','0','0','0','5.0','03:55 PM','10 Nov 2025','10 Nov 2025','202511101555','20251110','0','5.0','0','10 Nov 2025','03:55 PM','202511101555',''),(11,'star vendor','8965321470','','10.0','0','0','0','0','10.0','11:34 AM','26 Nov 2025','26 Nov 2025','202511261134','20251126','0','10.0','0','26 Nov 2025','11:34 AM','202511261134',''),(12,'star vendor','8965321470','','7.5','0','0','0','0','7.5','02:56 PM','03 Dec 2025','03 Dec 2025','202512031456','20251203','0','7.5','0','03 Dec 2025','02:56 PM','202512031456','');
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,'star vendor','8965321470','Red Rice','10','1','10.0','','10.0','0','0','0','0','10.0','06:32 PM','21 Aug 2025','21 Aug 2025','202508211832','20250821','','10.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'diamond vendor','9876543212','Jutebag','10','1','10.0','','10.0','0','0','0','0','10.0','01:44 PM','25 Aug 2025','25 Aug 2025','202508251344','20250825','','10.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'Mathi vendor','9876543210','coir bag','10','1','10.0','','10.0','0','0','0','0','10.0','05:30 PM','25 Aug 2025','25 Aug 2025','202508251730','20250825','','10.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'Mathi vendor','9876543210','honey','2','1','2.0','','2.0','0','0','0','0','2.0','05:31 PM','25 Aug 2025','25 Aug 2025','202508251731','20250825','','2.0',NULL,NULL,NULL,NULL,NULL,NULL,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,'Mathi vendor','9876543210','bag1','5','0.5','2.5','','2.5','0','0','0','0','2.5','05:33 PM','25 Aug 2025','25 Aug 2025','202508251733','20250825','','2.5',NULL,NULL,NULL,NULL,NULL,NULL,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,'Test Vendor1','9876543210','Mat','10','1','10.0','','10.0','0','0','0','0','10.0','01:43 PM','28 Aug 2025','28 Aug 2025','202508281343','20250828','','10.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'Test Vendor2','8564632598','Shoe','10','1','10.0','','10.0','0','0','0','0','10.0','01:49 PM','28 Aug 2025','28 Aug 2025','202508281349','20250828','','10.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'star vendor','8965321470','Red Rice','10','1','10.0','','10.0','0','0','0','0','10.0','04:31 PM','08 Sep 2025','08 Sep 2025','202509081631','20250908','','10.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'star vendor','8965321470','RICE','1','1','1.0','','1.0','0','0','0','0','1.0','06:29 PM','17 Oct 2025','17 Oct 2025','202510171829','20251017','','1.0',NULL,NULL,NULL,NULL,NULL,NULL,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,'star vendor','8965321470','test','5','1','5.0','','5.0','0','0','0','0','5.0','03:55 PM','10 Nov 2025','10 Nov 2025','202511101555','20251110','','5.0',NULL,NULL,NULL,NULL,NULL,NULL,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,'star vendor','8965321470','test','10','1','10.0','','10.0','0','0','0','0','10.0','11:34 AM','26 Nov 2025','26 Nov 2025','202511261134','20251126','','10.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'star vendor','8965321470','test cost price','5','1.5','7.5','','7.5','0','0','0','0','7.5','02:56 PM','03 Dec 2025','03 Dec 2025','202512031456','20251203','','7.5',NULL,NULL,NULL,NULL,NULL,NULL,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 `version_control` (`_id`, `version`) VALUES (1,'12');
INSERT INTO `weighing_scale_status` (`_id`, `Weighing_Scale_onoff`) VALUES (1,'Not Connected');
INSERT INTO `working_hours` (`_id`, `opening`, `opening_time`, `closing`, `closing_time`, `opening_time_system`, `closing_time_system`) VALUES (1,'Today','12:01 AM','Today','11:59 PM','00:01','23:59');
