INSERT INTO `all_sales` (`_id`, `itemname`, `quantity`, `price`, `total`, `type`, `parent`, `parentid`, `mod_assigned`, `tax`, `taxname`, `bill_no`, `time`, `date`, `user`, `table_id`, `billtype`, `paymentmethod`, `billamount_disapply`, `billamount_disnotapply`, `_idd`, `deleted_not`, `modifiedquantity`, `quantitycopy`, `modifiedtotal`, `date1`, `datetimee`, `disc_type`, `disc_value`, `newtotal`, `disc_thereornot`, `disc_indiv_total`, `new_modified_total`, `datetimee_new`, `hsn_code`, `taxname2`, `tax2`, `taxname3`, `tax3`, `taxname4`, `tax4`, `taxname5`, `tax5`, `category`, `counterperson_username`, `counterperson_name`, `credit`, `Phone_num`, `barcode_get`, `order_id`, `old_total`, `hsn_code2`, `hsn_code3`, `hsn_code4`, `hsn_code5`, `item_online`, `old_total_indiv`, `mfrs`, `batch_no`, `expiry`, `sch`, `purchase_price`, `purchase_price_total`, `profit`, `vendor_name`, `vendor_id`, `status`, `transation_id`, `vendor_payment_status`, `profit_payment_status`) VALUES (1,'sona masoori raw rice 1kg','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20250915-000011','12:25:08 PM','2025 09 15','admin','1','  General','  Cash','1.00','1.00','1',NULL,NULL,NULL,NULL,'15 Sep 2025','2025091512:25:08','%','0','1.00','no','0.00',NULL,'202509151225','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin','0',NULL,'8906045371223',NULL,'1.00','','','','',NULL,'1.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(2,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20250915-000012','12:31:52 PM','2025 09 15','admin','1','  General','  Cash','240.00','240.00','2',NULL,NULL,NULL,NULL,'15 Sep 2025','2025091512:31:52','₹','10','240.0','yes','10.0',NULL,'202509151231','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin','0',NULL,'',NULL,'250.00','','','','',NULL,'250.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(3,'capsicum green kg','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20250915-000013','12:32:17 PM','2025 09 15','admin','1','  General','  Cash','70.00','80.00','3',NULL,NULL,NULL,NULL,'15 Sep 2025','2025091512:32:17','%','0','80.00','no','0.00',NULL,'202509151232','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin','0',NULL,'',NULL,'80.00','','','','',NULL,'80.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(4,'ladies finger kg','1.0','11.00','11.00','Item',NULL,NULL,'no',NULL,NULL,'20250915-000014','01:33:44 PM','2025 09 15','admin','1','  General','  Cash','1.00','11.00','4',NULL,NULL,NULL,NULL,'15 Sep 2025','2025091513:33:44','%','0','11.00','no','0.00',NULL,'202509151333','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin','0',NULL,'',NULL,'11.00','','','','',NULL,'11.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(5,'sona masoori raw rice 1kg','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20250915-000015','02:15:46 PM','2025 09 15','admin','1','  General','  Cash','1.00','1.00','5',NULL,NULL,NULL,NULL,'15 Sep 2025','2025091514:15:46','%','0','1.00','no','0.00',NULL,'202509151415','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin','0',NULL,'8906045371223',NULL,'1.00','','','','',NULL,'1.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(6,'beans kg','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20250915-000016','02:18:20 PM','2025 09 15','admin','1','  General','  Cash','40.00','40.00','6',NULL,NULL,NULL,NULL,'15 Sep 2025','2025091514:18:20','%','0','40.00','no','0.00',NULL,'202509151418','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin','0',NULL,'',NULL,'40.00','','','','',NULL,'40.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(7,'capsicum green kg','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20250915-000017','02:18:43 PM','2025 09 15','admin','1','  General','  Cash','80.00','80.00','7',NULL,NULL,NULL,NULL,'15 Sep 2025','2025091514:18:43','%','0','80.00','no','0.00',NULL,'202509151418','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin','0',NULL,'',NULL,'80.00','','','','',NULL,'80.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(8,'ladies finger kg','1.0','11.00','11.00','Item',NULL,NULL,'no',NULL,NULL,'20250915-000018','02:22:30 PM','2025 09 15','admin','1','  General','  Upiqr','1.00','11.00','10',NULL,NULL,NULL,NULL,'15 Sep 2025','2025091514:22:30','%','0','11.00','no','0.00',NULL,'202509151422','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin','0',NULL,'',NULL,'11.00','','','','',NULL,'11.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(9,'sona masoori raw rice 1kg','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20250915-000019','02:25:00 PM','2025 09 15','admin','1','  General','  Cash','1.00','1.00','11',NULL,NULL,NULL,NULL,'15 Sep 2025','2025091514:25:00','%','0','1.00','no','0.00',NULL,'202509151425','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin','0',NULL,'8906045371223',NULL,'1.00','','','','',NULL,'1.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(10,'sona masoori raw rice 1kg','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20250915-0000110','02:25:45 PM','2025 09 15','admin','1','  General','  Cash','1.00','1.00','12',NULL,NULL,NULL,NULL,'15 Sep 2025','2025091514:25:45','%','0','1.00','no','0.00',NULL,'202509151425','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin','0',NULL,'8906045371223',NULL,'1.00','','','','',NULL,'1.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(11,'sona masoori raw rice 1kg','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20250915-0000111','02:26:00 PM','2025 09 15','admin','1','  General','  Cash','1.00','1.00','13',NULL,NULL,NULL,NULL,'15 Sep 2025','2025091514:26:00','%','0','1.00','no','0.00',NULL,'202509151426','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin','0',NULL,'8906045371223',NULL,'1.00','','','','',NULL,'1.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(12,'sona masoori raw rice 1kg','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20250915-0000112','02:27:53 PM','2025 09 15','admin','1','  Home delivery','  Cash','1.00','1.00','14',NULL,NULL,NULL,NULL,'15 Sep 2025','2025091514:27:53','%','0','1.00','no','0.00',NULL,'202509151427','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin','0',NULL,'8906045371223',NULL,'1.00','','','','',NULL,'1.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(13,'Kuppameni Soup','1.0','90.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20250915-0000113','03:57:47 PM','2025 09 15','admin','1','  General','  Cash','80.00','90.00','15',NULL,NULL,NULL,NULL,'15 Sep 2025','2025091515:57:47','%','0','90.00','no','0.00',NULL,'202509151557','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'90.00','','','','',NULL,'90.00',NULL,NULL,NULL,NULL,'90','90.00','0.00','Pasumai','VEN040',NULL,NULL,NULL,NULL),(14,'Kuppameni Soup','1.0','90.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20250915-0000114','04:01:45 PM','2025 09 15','admin','1','  General','  Upiqr','1.00','90.00','16',NULL,NULL,NULL,NULL,'15 Sep 2025','2025091516:01:45','%','0','90.00','no','0.00',NULL,'202509151601','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'90.00','','','','',NULL,'90.00',NULL,NULL,NULL,NULL,'90','90.00','0.00','Pasumai','VEN040',NULL,NULL,NULL,NULL),(15,'VPM 2 Agal Middle','1.0','6.00','6.00','Item',NULL,NULL,'no',NULL,NULL,'20250915-0000115','04:02:25 PM','2025 09 15','admin','1','  General','  Cash','6.00','6.00','17',NULL,NULL,NULL,NULL,'15 Sep 2025','2025091516:02:25','%','0','6.00','no','0.00',NULL,'202509151602','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'6.00','','','','',NULL,'6.00',NULL,NULL,NULL,NULL,'5','5.00','1.00','VPM Manpanda Thozhil Kulu Ongur','VEN052',NULL,NULL,NULL,NULL),(16,'VPM 2 Agal Middle','1.0','6.00','6.00','Item',NULL,NULL,'no',NULL,NULL,'20250915-0000118','06:31:07 PM','2025 09 15','admin','1','  General','  Cash','56.00','56.00','1',NULL,NULL,NULL,NULL,'15 Sep 2025','2025091518:31:07','%','0','6.00','no','0.00',NULL,'202509151831','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'6.00','','','','',NULL,'6.00',NULL,NULL,NULL,NULL,'5','5.00','1.00','VPM Manpanda Thozhil Kulu Ongur','VEN052',NULL,NULL,NULL,NULL),(17,'VPM22 Kuruvi','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20250915-0000118','06:31:07 PM','2025 09 15','admin','1','  General','  Cash','56.00','56.00','2',NULL,NULL,NULL,NULL,'15 Sep 2025','2025091518:31:07','%','0','50.00','no','0.00',NULL,'202509151831','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'50.00','','','','',NULL,'50.00',NULL,NULL,NULL,NULL,'49','49.00','1.00','VPM Manpanda Thozhil Kulu Ongur','VEN052',NULL,NULL,NULL,NULL),(18,'VPM 2 Agal Middle','1.0','6.00','6.00','Item',NULL,NULL,'no',NULL,NULL,'20250916-000011','11:02:01 AM','2025 09 16','admin','1','  General','  Cash','6.00','6.00','1',NULL,NULL,NULL,NULL,'16 Sep 2025','2025091611:02:01','%','0','6.00','no','0.00',NULL,'202509161102','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'6.00','','','','',NULL,'6.00',NULL,NULL,NULL,NULL,'5','5.00','1.00','VPM Manpanda Thozhil Kulu Ongur','VEN052',NULL,NULL,NULL,NULL),(19,'VPM 2 Agal Middle','1.0','6.00','6.00','Item',NULL,NULL,'no',NULL,NULL,'20250916-000012','01:25:35 PM','2025 09 16','admin','1','  General','  Cash','6.00','6.00','1',NULL,NULL,NULL,NULL,'16 Sep 2025','2025091613:25:35','%','0','6.00','no','0.00',NULL,'202509161325','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'6.00','','','','',NULL,'6.00',NULL,NULL,NULL,NULL,'5','5.00','1.00','VPM Manpanda Thozhil Kulu Ongur','VEN052',NULL,NULL,NULL,NULL),(20,'VPM 2 Agal Middle','1.0','6.00','6.00','Item',NULL,NULL,'no',NULL,NULL,'20250919-000011','06:00:22 PM','2025 09 19','admin','1','  General','  Cash','6.00','6.00','1',NULL,NULL,NULL,NULL,'19 Sep 2025','2025091918:00:22','%','0','6.00','no','0.00',NULL,'202509191800','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'6.00','','','','',NULL,'6.00',NULL,NULL,NULL,NULL,'5','5.00','1.00','VPM Manpanda Thozhil Kulu Ongur','VEN052',NULL,NULL,NULL,NULL),(21,'VPM 2 Agal Middle','1.0','6.00','6.00','Item',NULL,NULL,'no',NULL,NULL,'20250919-000012','06:01:30 PM','2025 09 19','admin','1','  General','  Cash','56.00','56.00','2',NULL,NULL,NULL,NULL,'19 Sep 2025','2025091918:01:30','%','0','6.00','no','0.00',NULL,'202509191801','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'6.00','','','','',NULL,'6.00',NULL,NULL,NULL,NULL,'5','5.00','1.00','VPM Manpanda Thozhil Kulu Ongur','VEN052',NULL,NULL,NULL,NULL),(22,'VPM22 Kuruvi','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20250919-000012','06:01:30 PM','2025 09 19','admin','1','  General','  Cash','56.00','56.00','3',NULL,NULL,NULL,NULL,'19 Sep 2025','2025091918:01:30','%','0','50.00','no','0.00',NULL,'202509191801','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'50.00','','','','',NULL,'50.00',NULL,NULL,NULL,NULL,'49','49.00','1.00','VPM Manpanda Thozhil Kulu Ongur','VEN052',NULL,NULL,NULL,NULL),(23,'VPM22 Kuruvi','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20251006-000011','02:34:53 PM','2025 10 06','admin','1','  General','  Cash','50.00','50.00','2',NULL,NULL,NULL,NULL,'06 Oct 2025','2025100614:34:53','%','0','50.00','no','0.00',NULL,'202510061434','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'50.00','','','','',NULL,'50.00',NULL,NULL,NULL,NULL,'49','49.00','1.00','VPM Manpanda Thozhil Kulu Ongur','VEN052',NULL,NULL,NULL,NULL),(24,'VPM 2 Agal Middle','1.0','6.00','6.00','Item',NULL,NULL,'no',NULL,NULL,'20251008-000011','01:09:02 PM','2025 10 08','admin','1','  General','  Pay Later','6.00','6.00','3',NULL,NULL,NULL,NULL,'08 Oct 2025','2025100813:09:02','%','0','6.00','no','0.00',NULL,'202510081309','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','2',NULL,'',NULL,'6.00','','','','',NULL,'6.00',NULL,NULL,NULL,NULL,'5','5.00','1.00','VPM Manpanda Thozhil Kulu Ongur','VEN052',NULL,NULL,NULL,NULL),(25,'VPM 2 Agal Middle','1.0','6.00','6.00','Item',NULL,NULL,'no',NULL,NULL,'20251008-000012','01:11:14 PM','2025 10 08','admin','1','  General','  Cash','6.00','6.00','3',NULL,NULL,NULL,NULL,'08 Oct 2025','2025100813:11:14','%','0','6.00','no','0.00',NULL,'202510081311','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'6.00','','','','',NULL,'6.00',NULL,NULL,NULL,NULL,'5','5.00','1.00','VPM Manpanda Thozhil Kulu Ongur','VEN052',NULL,NULL,NULL,NULL),(26,'VPM 2 Agal Middle','1.0','6.00','6.00','Item',NULL,NULL,'no',NULL,NULL,'20251008-000013','02:20:45 PM','2025 10 08','admin','1','  General','  Pay Later','6.00','6.00','4',NULL,NULL,NULL,NULL,'08 Oct 2025','2025100814:20:45','%','0','6.00','no','0.00',NULL,'202510081420','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','2',NULL,'',NULL,'6.00','','','','',NULL,'6.00',NULL,NULL,NULL,NULL,'5','5.00','1.00','VPM Manpanda Thozhil Kulu Ongur','VEN052',NULL,NULL,NULL,NULL),(27,'VPM 2 Agal Middle','1.0','6.00','6.00','Item',NULL,NULL,'no',NULL,NULL,'20251008-000014','02:45:08 PM','2025 10 08','admin','1','  General','  Card','6.00','6.00','9',NULL,NULL,NULL,NULL,'08 Oct 2025','2025100814:45:08','%','0','6.00','no','0.00',NULL,'202510081445','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'6.00','','','','',NULL,'6.00',NULL,NULL,NULL,NULL,'5','5.00','1.00','VPM Manpanda Thozhil Kulu Ongur','VEN052',NULL,NULL,NULL,NULL),(28,'VPM 2 Agal Middle','1.0','6.00','6.00','Item',NULL,NULL,'no',NULL,NULL,'20251008-000015','03:26:00 PM','2025 10 08','admin','1','  General','  Card','6.00','6.00','9',NULL,NULL,NULL,NULL,'08 Oct 2025','2025100815:26:00','%','0','6.00','no','0.00',NULL,'202510081526','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'6.00','','','','',NULL,'6.00',NULL,NULL,NULL,NULL,'5','5.00','1.00','VPM Manpanda Thozhil Kulu Ongur','VEN052',NULL,NULL,NULL,NULL);
INSERT INTO `all_sales_cancelled` (`_id`, `itemname`, `quantity`, `price`, `total`, `type`, `parent`, `parentid`, `mod_assigned`, `tax`, `taxname`, `bill_no`, `time`, `date`, `user`, `billtype`, `paymentmethod`, `billamount_disapply`, `billamount_disnotapply`, `_idd`, `reason`, `billamount_cancelled`, `date1`, `billamount_cancelled_user`, `disc_type`, `disc_value`, `newtotal`, `disc_thereornot`, `disc_indiv_total`, `datetimee_new`, `taxname2`, `tax2`, `taxname3`, `tax3`, `taxname4`, `tax4`, `taxname5`, `tax5`, `hsn_code`, `old_total`, `old_total_indiv`) VALUES (1,'VPM 2 Agal Middle','2.0','6.00','12.00','Item',NULL,NULL,'no',NULL,NULL,'20250916-000013','05:38:34 PM','2025 09 16','admin','  General','  Cash','367.00','367.0','2','Changed mind','367.00','16 Sep 2025','367.00','%','0','12.00','no','','202509161738',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','12.00','6.00'),(2,'VPM22 Kuruvi','2.0','50.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20250916-000013','05:38:34 PM','2025 09 16','admin','  General','  Cash','367.00','367.0','3','Changed mind','367.00','16 Sep 2025','367.00','%','0','100.00','no','','202509161738',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','100.00','50.00'),(3,'VPM27 Juke Small','1.0','255.00','255.00','Item',NULL,NULL,'no',NULL,NULL,'20250916-000013','05:38:34 PM','2025 09 16','admin','  General','  Cash','367.00','367.0','4','Changed mind','367.00','16 Sep 2025','367.00','%','0','255.00','no','','202509161738',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','255.00','255.00'),(4,'VPM24 Water Bottle','3.0','390.00','1170.00','Item',NULL,NULL,'no',NULL,NULL,'20250916-000014','05:42:54 PM','2025 09 16','admin','  General','  Cash','1680.00','1680.0','5','Accidental charge','1680.00','16 Sep 2025','1680.00','%','0','1170.00','no','','202509161742',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','1170.00','390.00'),(5,'VPM27 Juke Small','2.0','255.00','510.00','Item',NULL,NULL,'no',NULL,NULL,'20250916-000014','05:42:54 PM','2025 09 16','admin','  General','  Cash','1680.00','1680.0','6','Accidental charge','1680.00','16 Sep 2025','1680.00','%','0','510.00','no','','202509161742',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','510.00','255.00');
INSERT INTO `billcount` (`_id`, `value`) VALUES (1,'0');
INSERT INTO `billnumber` (`_id`, `billnumber`, `total`, `user`, `date`, `paymentmethod`, `billtype`, `subtotal`, `taxtotal`, `roundoff`, `globaltaxtotal`, `billcount`, `datetimee_new`, `comments_sales`, `delivery_fee`, `packing_charges`, `loyalty_points`, `loyalty_amount`, `order_id`, `transaction_id`, `transaction_id_org`, `source`, `source1`, `cash_sett_staus`) VALUES (1,'20250915-000011','1.00','admin','2025 09 15','  Cash','  General','1.00','0.00','0.00','0.0','1','202509151225',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'20250915-000012','240.00','admin','2025 09 15','  Cash','  General','240.00','0.00','0.00','0.0','2','202509151231',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'20250915-000013','70.00','admin','2025 09 15','  Cash','  General','80.00','0.00','0.00','0.0','3','202509151232',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'20250915-000014','1.00','admin','2025 09 15','  Cash','  General','11.00','0.00','0.00','0.0','4','202509151333',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'20250915-000015','1.00','admin','2025 09 15','  Cash','  General','1.00','0.00','0.00','0.0','5','202509151415',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'20250915-000016','40.00','admin','2025 09 15','  Cash','  General','40.00','0.00','0.00','0.0','6','202509151418',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'20250915-000017','80.00','admin','2025 09 15','  Cash','  General','80.00','0.00','0.00','0.0','7','202509151418',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'20250915-000018','1.00','admin','2025 09 15','  Upiqr','  General','11.00','0.00','0.00','0.0','8','202509151422',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'20250915-000019','1.00','admin','2025 09 15','  Cash','  General','1.00','0.00','0.00','0.0','9','202509151425',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'20250915-0000110','1.00','admin','2025 09 15','  Cash','  General','1.00','0.00','0.00','0.0','10','202509151425',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'20250915-0000111','1.00','admin','2025 09 15','  Cash','  General','1.00','0.00','0.00','0.0','11','202509151426',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'20250915-0000112','1.00','admin','2025 09 15','  Cash','  Home delivery','1.00','0.00','0.00','0.0','12','202509151427',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'20250915-0000113','80.00','admin','2025 09 15','  Cash','  General','90.00','0.00','0.00','0.0','13','202509151557',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'20250915-0000114','1.00','admin','2025 09 15','  Upiqr','  General','90.00','0.00','0.00','0.0','14','202509151601',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'20250915-0000115','6.00','admin','2025 09 15','  Cash','  General','6.00','0.00','0.00','0.0','15','202509151602',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'20250915-0000116','6.00','admin','2025 09 15','  Cash','  General','6.00','0.00','0.00','0.0','16','202509151732',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'20250915-0000117','50.00','admin','2025 09 15','  Cash','  General','50.00','0.00','0.00','0.0','17','202509151744',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'20250915-0000118','56.00','admin','2025 09 15','  Cash','  General','56.00','0.00','0.00','0.0','18','202509151831',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'20250916-000011','6.00','admin','2025 09 16','  Cash','  General','6.00','0.00','0.00','0.0','19','202509161102',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'20250916-000012','6.00','admin','2025 09 16','  Cash','  General','6.00','0.00','0.00','0.0','20','202509161325',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'20250916-000013','0','admin','2025 09 16','  Cash','  General','0.0','0.0','0.0','0.0','21','202509161738',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'20250916-000014','0','admin','2025 09 16','  Cash','  General','0.0','0.0','0.0','0.0','22','202509161742',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'20250919-000011','6.00','admin','2025 09 19','  Cash','  General','6.00','0.00','0.00','0.0','23','202509191800',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'20250919-000012','56.00','admin','2025 09 19','  Cash','  General','56.00','0.00','0.00','0.0','24','202509191801',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'20251006-000011','50.00','admin','2025 10 06','  Cash','  General','50.00','0.00','0.00','0.0','25','202510061434',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'20251008-000011','6.00','admin','2025 10 08','  Pay Later','  General','6.00','0.00','0.00','0.0','26','202510081309',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'20251008-000012','6.00','admin','2025 10 08','  Cash','  General','6.00','0.00','0.00','0.0','27','202510081311',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'20251008-000013','6.00','admin','2025 10 08','  Pay Later','  General','6.00','0.00','0.00','0.0','28','202510081420',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'20251008-000014','6.00','admin','2025 10 08','  Card','  General','6.00','0.00','0.00','0.0','29','202510081445',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'20251008-000015','6.00','admin','2025 10 08','  Card','  General','6.00','0.00','0.00','0.0','30','202510081526',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `cancelwiseorderlistitems` (`_id`, `date`, `time`, `user`, `billno`, `sale`, `refund`, `reason`, `billcount`) VALUES (1,'16 Sep 2025','05:38:34 PM','admin','20250916-000013','367.00','367.00','Changed mind','21'),(2,'16 Sep 2025','05:42:54 PM','admin','20250916-000014','1680.00','1680.00','Accidental charge','22');
INSERT INTO `cash_settlement` (`_id`, `amount`, `transaction_no`, `date`, `time`, `date1`, `datetimee_new`, `status`) VALUES (14,'2918.0','20250904-124203','2025 09 04','12:42:03 PM','04 Sep 2025','202509152359','Transaction cancelled'),(15,'2918.0','20250904-124303','2025 09 04','12:43:03 PM','04 Sep 2025','202509152359','success');
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `cusotmer_activity_temp_top3` (`_id`, `name`, `phone_no`, `email`, `addr`, `total_amount`, `balance`, `discount_value`, `discount_type`, `approval_rate`) VALUES (1,'rohith','9581497872','trdt','geg',1,'0.0',NULL,NULL,NULL),(2,'rohith','9581497872','trdt','geg',6,'2.0',NULL,NULL,NULL);
INSERT INTO `discountdetails` (`_id`, `date`, `time`, `billno`, `Discountcodeno`, `Discount_percent`, `Billamount_rupess`, `Discount_rupees`, `date1`, `original_amount`, `billcount`, `datetimee_new`, `paymentmethod`) VALUES (1,'2025 09 15','12:32:17 PM','20250915-000013','gg','12.50','70.00','10','15 Sep 2025','80.00',NULL,'202509151232',NULL),(2,'2025 09 15','01:33:44 PM','20250915-000014','test','90.91','1.00','10','15 Sep 2025','11.00',NULL,'202509151333',NULL),(3,'2025 09 15','02:22:30 PM','20250915-000018','year','90.91','1.00','10','15 Sep 2025','11.00',NULL,'202509151422',NULL),(4,'2025 09 15','03:57:47 PM','20250915-0000113','gg','11.11','80.00','10','15 Sep 2025','90.00',NULL,'202509151557',NULL),(5,'2025 09 15','04:01:45 PM','20250915-0000114','trst','98.89','1.00','89','15 Sep 2025','90.00',NULL,'202509151601',NULL);
INSERT INTO `indian_bank_payment_logs` (`id`, `request_id`, `transaction_id`, `log_type`, `log_level`, `message`, `request_data`, `response_data`, `error_details`, `api_endpoint`, `http_method`, `http_status_code`, `processing_time_ms`, `created_at`, `db_name`) VALUES (146,'PAYMENT17580112660071701',NULL,'REQUEST','INFO','Payment request initiated for vendor 180 - Amount: 123456042 - Account: SB****01','{\"request_info\":{\"Body\":{\"Payload\":{\"data\":\"[BLOB]\",\"sessionkey\":\"dPKpcNgtu+0pEfahQ66IcFTw8c3/J2H1t80m7nUW2mLd1XVGJG7gU7u5M9V8uQv405s984u+wEyQAVKkXW14rORAVbvOJhX13LqktDnv6odhrsM2nHsA105VdLpBaz/XrxNDmpSfGbeFbOnmWCQo3zIJFjcJSbi/BfR3AWjFRopLV9p9B6MOqAbaPrvxp01XOwpq0eCQpDZRD8X5VBxUu2jmTOOiw1bqbHxBmoi+/E2+XJCao4/X81clo+sLfNaE9Kmo+vZNLbaxEaJmsveWvfEM3u65uWbq+OQYgr7Gs5bS+u26QOMdya9vePFMTWP/LWRrZyN3ZWNABra3x5J87A==\"}}}}',NULL,NULL,'POST','submit',NULL,NULL,'2025-09-16 13:57:49','krrohithretail_newhorizon_newhoripos1'),(147,'PAYMENT17580112660071701',NULL,'ERROR','ERROR','Payment failed - ERR-135: NO ROUTING FOR INSTITUTION/NETWORK',NULL,NULL,'{\"ErrorResponse\":{\"metadata\":{\"status\":{\"code\":\"200\",\"desc\":\"Bad Request\"}},\"additionalinfo\":{\"InstructionIdentification\":\"TNSM1758011267682266841514\",\"excepCode\":\"ERR-135\",\"excepText\":\"NO ROUTING FOR INSTITUTION/NETWORK\",\"status\":\"FAILED\",\"Err_Timestamp\":\"2025-09-16 13:57:48.227845\"}}}','submit','POST',400,NULL,'2025-09-16 13:57:52','krrohithretail_newhorizon_newhoripos1'),(148,'PAYMENT1758017999879588',NULL,'REQUEST','INFO','Payment request initiated for vendor 180 - Amount: 123456042 - Account: SB****01','{\"request_info\":{\"Body\":{\"Payload\":{\"data\":\"[BLOB]\",\"sessionkey\":\"gw6uw7WE8AmIEvV3u8aYIdLNEmdisw1N6WGuRZrSQ973CKF4DYXjDQ6rMNo4LGdHPdLEM2p/Nla+HhB3wmZYDyprKIWTswrpUJ1Zm4Zmqjpniu35JgtAMqtIiD0QIY3d45zM2S8etpyAjoqP6hrK5orGgPUjXV8f0lxOnXipvKJXeN0NY0LgI4Jsk9TQGQgDEPrjcT6sKJl//q/f24QuOwr+N2L4JwVMjDKOAb0cxh4XMU14+olGsTGsxGJNtzr6U3MH4rMtugdv5NK0ovqoBTy6W6vFbXZTwE+G3kKTyqopZeLiMT6bMffgBr1GDCuk1pdZD1EgS30JUMh8CEU/tg==\"}}}}',NULL,NULL,'POST','submit',NULL,NULL,'2025-09-16 15:50:01','krrohithretail_newhorizon_newhoripos1'),(149,'PAYMENT1758017999879588','525915378266','RESPONSE','INFO','Payment response received - Status: SUCCESS - Message: Payment submitted successfully - Status: CREDITED',NULL,'{\"Data\":{\"DomesticPaymentID\":\"525915378266\",\"Status\":\"CREDITED\",\"Description\":\"TRANSACTION APPROVED\",\"CreationDateTime\":\"2025-09-16 15:50:02.556897\",\"Initiation\":{\"InstructionIdentification\":\"TNSM1758018000832320247294\",\"InstructedAmount\":{\"Amount\":\"180.000\",\"Currency\":\"INR\"},\"DebtorAccount\":{\"Identification\":\"8111803277\",\"SecondaryIdentification\":\"IDIB000N033\",\"Name\":\"IVEPOS CORPORATION\"},\"CreditorAccount\":{\"Identification\":\"123456042\",\"SecondaryIdentification\":\"SBIN0000001\",\"Name\":\"Kiran Kumar\"},\"RemittanceInformation\":{\"BeneficiaryAccountType\":\"10\",\"ClearingSystemIdentification\":\"IMPS\",\"Unstructured\":{\"CreditorReferenceInformation\":\"Vendor Payment for goods provided\"}}}},\"Risk\":{\"PaymentContextCode\":[\"IMPS Payment Line1\"],\"MerchantCategoryCode\":\"TNSMU01\",\"MerchantCustomerIdentification\":\"TNSMC01\",\"DeliveryAddress\":{\"AddressLine\":[\"Bangalore\"],\"PostCode\":\"560001\",\"Contact\":\"9876543210\",\"Country\":\"IND\"}}}',NULL,'submit',NULL,200,4079,'2025-09-16 15:50:06','krrohithretail_newhorizon_newhoripos1'),(150,'PAYMENT1758024233416905',NULL,'REQUEST','INFO','Payment request initiated for vendor 180 - Amount: 123456042 - Account: SB****01','{\"request_info\":{\"Body\":{\"Payload\":{\"data\":\"[BLOB]\",\"sessionkey\":\"EDXF9RPPkB82oHzfjThD+cRU6FOoYHaLvN0SzQ2K4eleqx7K/C1yUJA0+LWUOMMLheV7fArZV7XEakoY8E9MQlzdsDfZGi0KrENvvyeEzNOKq2PZukfxNuG/pLXinWSk0H6dwVChKG1aDQyfpRKL+EtfY6FZdxg0sQYTkJrbZTl6NIcM7i/DmcwnqKkcX09ualT3h1/gVI4iLv46XEgQgECop444wsshtImeS3I4QEf3XAvx7k8TBKS/c/W9FisdA2xoRxipTiwImTjR7UNaLdExkdNLs8VkWZey18itOOOkoLTFk7v3jKXjWmaCIb7jW/QrFCS8+R6juE/Ger4mMw==\"}}}}',NULL,NULL,'POST','submit',NULL,NULL,'2025-09-16 17:33:53','krrohithretail_newhorizon_newhoripos1'),(151,'PAYMENT1758024233416905',NULL,'ERROR','ERROR','Payment failed - ERR-CBS: NO SUCH ACCOUNT',NULL,NULL,'{\"ErrorResponse\":{\"metadata\":{\"status\":{\"code\":\"200\",\"desc\":\"Bad Request\"}},\"additionalinfo\":{\"InstructionIdentification\":\"TNSM1758024233417335353710\",\"excepCode\":\"ERR-CBS\",\"excepText\":\"NO SUCH ACCOUNT\",\"status\":\"FAILED\",\"Err_Timestamp\":\"2025-09-16 17:33:53.232097\"}}}','submit','POST',400,NULL,'2025-09-16 17:33:56','krrohithretail_newhorizon_newhoripos1'),(152,'PAYMENT17585239172939042',NULL,'REQUEST','INFO','Payment request initiated for vendor 128 - Amount: 7389696661 - Account: ID****07','{\"request_info\":{\"Body\":{\"Payload\":{\"data\":\"[BLOB]\",\"sessionkey\":\"MRPgT7EouunrEC7F8Je4dB0QqP/zRTs6PrDT84WtD3Tu6FzYEDs1HnpzkHRNC33dhPxWfXesML4QrZwu58M9B0AJTAaC8xsI+dT52CaEn7QIuJgThhcx7fGlfrLYy4SS2kzEL7exohWQlMHJRkJ422wNuXROOK22JUXwZu4PuXZVcnyOEdj+znIjovY979fPsNKUzfJ7l4O9K4+EKB0/btNDDqLOFDNNaenXp7Tj/DMccvNpF+BbiolivT8Db0RaKWCQGmNrL2yP4dAYH19Rmtx+BabhvINVrFl2f+K6rzcAIGx+pzxQtPhjaSgkhDfwxteOQpD+9BO3yD3ZQGPYcg==\"}}}}',NULL,NULL,'POST','submit',NULL,NULL,'2025-09-22 12:21:59','krrohithretail_newhorizon_newhoripos1'),(153,'PAYMENT17585239172939042','500878987','RESPONSE','INFO','Payment response received - Status: SUCCESS - Message: Payment submitted successfully - Status: CREDITED',NULL,'{\"Data\":{\"DomesticPaymentID\":\"500878987\",\"Status\":\"CREDITED\",\"Description\":\"Payment submitted successfully\",\"CreationDateTime\":\"2025-09-22 12:22:01.048239\",\"Initiation\":{\"InstructionIdentification\":\"TNSM1758523918969554539139\",\"InstructedAmount\":{\"Amount\":\"128.000\",\"Currency\":\"INR\"},\"DebtorAccount\":{\"Identification\":\"8111803277\",\"SecondaryIdentification\":\"IDIB000N033\",\"Name\":\"IVEPOS CORPORATION\"},\"CreditorAccount\":{\"Identification\":\"7389696661\",\"SecondaryIdentification\":\"IDIB000D007\",\"Name\":\"VPM Manpanda Thozhil Kulu Ongur\"},\"RemittanceInformation\":{\"BeneficiaryAccountType\":\"10\",\"ClearingSystemIdentification\":\"IFT\",\"Unstructured\":{\"CreditorReferenceInformation\":\"Vendor Payment for goods provided\"}}}},\"Risk\":{\"PaymentContextCode\":[\"IFT Payment Line1\"],\"MerchantCategoryCode\":\"TNSMU01\",\"MerchantCustomerIdentification\":\"TNSMC01\",\"DeliveryAddress\":{\"AddressLine\":[\"Bangalore\"],\"PostCode\":\"560001\",\"Contact\":\"9876543210\",\"Country\":\"IND\"}}}',NULL,'submit',NULL,200,1683,'2025-09-22 12:22:01','krrohithretail_newhorizon_newhoripos1');
INSERT INTO `indian_bank_payment_transactions` (`id`, `request_id`, `transaction_id`, `vendor_id`, `vendor_name`, `vendor_email`, `vendor_phone`, `amount`, `currency`, `beneficiary_account`, `beneficiary_ifsc`, `beneficiary_name`, `remarks`, `payment_type`, `status`, `message`, `error_code`, `error_description`, `utr_number`, `bank_reference`, `settlement_reference`, `payment_method`, `payment_notes`, `request_timestamp`, `response_timestamp`, `created_at`, `updated_at`, `db_name`, `request_payload_encrypted`, `request_payload_decrypted`, `response_payload_encrypted`, `response_payload_decrypted`, `interaction_id`, `jws_signature`, `request_headers`, `response_headers`, `external_api_request_data`, `external_api_response_data`, `external_api_status`, `external_api_timestamp`, `external_api_retry_count`, `external_api_error_message`) VALUES (42,'PAYMENT17580112660071701','TNSM1758011267682266841514','40','Pasumai','','9698209818',180.00,'INR','123456042','SBIN0000001','Pasumai','Vendor Payment for goods provided','IMPS','FAILED','Payment failed due to banking restrictions. Please contact your bank or try again later.','ERR-135','NO ROUTING FOR INSTITUTION/NETWORK',NULL,NULL,NULL,'IMPS',NULL,'2025-09-16 13:57:52','2025-09-16 13:57:51','2025-09-16 13:57:52','2025-09-16 13:57:52','krrohithretail_newhorizon_newhoripos1','{\"request_info\":{\"Body\":{\"Payload\":{\"data\":\"[BLOB]\",\"sessionkey\":\"dPKpcNgtu+0pEfahQ66IcFTw8c3/J2H1t80m7nUW2mLd1XVGJG7gU7u5M9V8uQv405s984u+wEyQAVKkXW14rORAVbvOJhX13LqktDnv6odhrsM2nHsA105VdLpBaz/XrxNDmpSfGbeFbOnmWCQo3zIJFjcJSbi/BfR3AWjFRopLV9p9B6MOqAbaPrvxp01XOwpq0eCQpDZRD8X5VBxUu2jmTOOiw1bqbHxBmoi+/E2+XJCao4/X81clo+sLfNaE9Kmo+vZNLbaxEaJmsveWvfEM3u65uWbq+OQYgr7Gs5bS+u26QOMdya9vePFMTWP/LWRrZyN3ZWNABra3x5J87A==\"}}}}',NULL,'{\"ErrorResponse\":{\"metadata\":{\"status\":{\"code\":\"200\",\"desc\":\"Bad Request\"}},\"additionalinfo\":{\"InstructionIdentification\":\"TNSM1758011267682266841514\",\"excepCode\":\"ERR-135\",\"excepText\":\"NO ROUTING FOR INSTITUTION/NETWORK\",\"status\":\"FAILED\",\"Err_Timestamp\":\"2025-09-16 13:57:48.227845\"}}}',NULL,'TNSM1758011267682266841514',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(43,'PAYMENT1758017999879588','TNSM1758018000832320247294','40','Pasumai','','9698209818',180.00,'INR','123456042','SBIN0000001','Pasumai','Vendor Payment for goods provided','IMPS','UNKNOWN','Payment submitted successfully - Status: CREDITED',NULL,NULL,NULL,'525915378266',NULL,'IMPS',NULL,'2025-09-16 15:50:06','2025-09-16 15:50:05','2025-09-16 15:50:06','2025-09-16 18:03:31','krrohithretail_newhorizon_newhoripos1','{\"request_info\":{\"Body\":{\"Payload\":{\"data\":\"[BLOB]\",\"sessionkey\":\"gw6uw7WE8AmIEvV3u8aYIdLNEmdisw1N6WGuRZrSQ973CKF4DYXjDQ6rMNo4LGdHPdLEM2p/Nla+HhB3wmZYDyprKIWTswrpUJ1Zm4Zmqjpniu35JgtAMqtIiD0QIY3d45zM2S8etpyAjoqP6hrK5orGgPUjXV8f0lxOnXipvKJXeN0NY0LgI4Jsk9TQGQgDEPrjcT6sKJl//q/f24QuOwr+N2L4JwVMjDKOAb0cxh4XMU14+olGsTGsxGJNtzr6U3MH4rMtugdv5NK0ovqoBTy6W6vFbXZTwE+G3kKTyqopZeLiMT6bMffgBr1GDCuk1pdZD1EgS30JUMh8CEU/tg==\"}}}}',NULL,NULL,NULL,'TNSM1758018000832320247294',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(44,'PAYMENT1758024233416905','TNSM1758024233417335353710','40','Pasumai','','9698209818',180.00,'INR','123456042','SBIN0000001','Pasumai','Vendor Payment for goods provided','IMPS','FAILED','Payment failed due to banking restrictions. Please contact your bank or try again later.','ERR-CBS','NO SUCH ACCOUNT',NULL,NULL,NULL,'IMPS',NULL,'2025-09-16 17:33:56','2025-09-16 17:33:56','2025-09-16 17:33:57','2025-09-16 17:33:57','krrohithretail_newhorizon_newhoripos1','{\"request_info\":{\"Body\":{\"Payload\":{\"data\":\"[BLOB]\",\"sessionkey\":\"EDXF9RPPkB82oHzfjThD+cRU6FOoYHaLvN0SzQ2K4eleqx7K/C1yUJA0+LWUOMMLheV7fArZV7XEakoY8E9MQlzdsDfZGi0KrENvvyeEzNOKq2PZukfxNuG/pLXinWSk0H6dwVChKG1aDQyfpRKL+EtfY6FZdxg0sQYTkJrbZTl6NIcM7i/DmcwnqKkcX09ualT3h1/gVI4iLv46XEgQgECop444wsshtImeS3I4QEf3XAvx7k8TBKS/c/W9FisdA2xoRxipTiwImTjR7UNaLdExkdNLs8VkWZey18itOOOkoLTFk7v3jKXjWmaCIb7jW/QrFCS8+R6juE/Ger4mMw==\"}}}}',NULL,'{\"ErrorResponse\":{\"metadata\":{\"status\":{\"code\":\"200\",\"desc\":\"Bad Request\"}},\"additionalinfo\":{\"InstructionIdentification\":\"TNSM1758024233417335353710\",\"excepCode\":\"ERR-CBS\",\"excepText\":\"NO SUCH ACCOUNT\",\"status\":\"FAILED\",\"Err_Timestamp\":\"2025-09-16 17:33:53.232097\"}}}',NULL,'TNSM1758024233417335353710',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(45,'PAYMENT17585239172939042','TNSM1758523918969554539139','53','VPM Manpanda Thozhil Kulu Ongur','','9994246967',128.00,'INR','7389696661','IDIB000D007','VPM Manpanda Thozhil Kulu Ongur','Vendor Payment for goods provided','IFT','SUCCESS','Payment submitted successfully - Status: CREDITED',NULL,NULL,NULL,'TNSM1758523918969554539139',NULL,'IFT',NULL,'2025-09-22 12:22:01','2025-09-22 12:22:01','2025-09-22 12:22:02','2025-09-22 12:22:02','krrohithretail_newhorizon_newhoripos1','{\"request_info\":{\"Body\":{\"Payload\":{\"data\":\"[BLOB]\",\"sessionkey\":\"MRPgT7EouunrEC7F8Je4dB0QqP/zRTs6PrDT84WtD3Tu6FzYEDs1HnpzkHRNC33dhPxWfXesML4QrZwu58M9B0AJTAaC8xsI+dT52CaEn7QIuJgThhcx7fGlfrLYy4SS2kzEL7exohWQlMHJRkJ422wNuXROOK22JUXwZu4PuXZVcnyOEdj+znIjovY979fPsNKUzfJ7l4O9K4+EKB0/btNDDqLOFDNNaenXp7Tj/DMccvNpF+BbiolivT8Db0RaKWCQGmNrL2yP4dAYH19Rmtx+BabhvINVrFl2f+K6rzcAIGx+pzxQtPhjaSgkhDfwxteOQpD+9BO3yD3ZQGPYcg==\"}}}}',NULL,'{\"Data\":{\"DomesticPaymentID\":\"500878987\",\"Status\":\"CREDITED\",\"Description\":\"Payment submitted successfully\",\"CreationDateTime\":\"2025-09-22 12:22:01.048239\",\"Initiation\":{\"InstructionIdentification\":\"TNSM1758523918969554539139\",\"InstructedAmount\":{\"Amount\":\"128.000\",\"Currency\":\"INR\"},\"DebtorAccount\":{\"Identification\":\"8111803277\",\"SecondaryIdentification\":\"IDIB000N033\",\"Name\":\"IVEPOS CORPORATION\"},\"CreditorAccount\":{\"Identification\":\"7389696661\",\"SecondaryIdentification\":\"IDIB000D007\",\"Name\":\"VPM Manpanda Thozhil Kulu Ongur\"},\"RemittanceInformation\":{\"BeneficiaryAccountType\":\"10\",\"ClearingSystemIdentification\":\"IFT\",\"Unstructured\":{\"CreditorReferenceInformation\":\"Vendor Payment for goods provided\"}}}},\"Risk\":{\"PaymentContextCode\":[\"IFT Payment Line1\"],\"MerchantCategoryCode\":\"TNSMU01\",\"MerchantCustomerIdentification\":\"TNSMC01\",\"DeliveryAddress\":{\"AddressLine\":[\"Bangalore\"],\"PostCode\":\"560001\",\"Contact\":\"9876543210\",\"Country\":\"IND\"}}}',NULL,'TNSM1758523918969554539139',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL);
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'beans kg',40),(2,'capsicum green kg',160),(3,'fig fruit kg',250),(4,'ladies finger kg',22),(5,'sona masoori raw rice 1kg',6),(6,'fig fruit kg',250),(7,'ladies finger kg',22),(8,'sona masoori raw rice 1kg',6);
INSERT INTO `itemwiseorderlistitems` (`_id`, `itemno`, `itemname`, `sales`, `salespercentage`, `itemtotalquan`, `category`, `i_buying_price`, `mi_buying_price`, `i_cost_value`, `i_cost_percent`, `mi_cost_value`, `mi_cost_percent`, `barcode_value`) VALUES (1,'9','beans kg',40,9,'1','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'6','capsicum green kg',160,34,'2','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'4','fig fruit kg',250,53,'1','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'5','ladies finger kg',22,5,'2','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'1','sona masoori raw rice 1kg',6,1,'6','rice whole grains',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'1243','fig fruit kg',250,30,'1','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'1243','ladies finger kg',22,3,'2','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'1243','sona masoori raw rice 1kg',6,1,'6','rice whole grains',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (1,'fruits and vegetables',472),(2,'rice whole grains',6),(3,'None',12),(4,'None',12),(5,'None',316),(6,'fruits and vegetables',472),(7,'rice whole grains',6),(8,'None',30);
INSERT INTO `top_reason` (`_id`, `reason`, `value`) VALUES (3,'Accidental charge',1),(4,'Changed mind',1),(7,'Accidental charge',1),(8,'Changed mind',1),(9,'Accidental charge',1),(10,'Changed mind',1);
INSERT INTO `usercancelleddata` (`_id`, `username`, `total`) VALUES (1,'admin',2047);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',438);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',438,100);
