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 `customerdetails` (`_id`, `name`, `phoneno`, `emailid`, `address`, `rupees`, `billnumber`, `date1`, `time1`, `date`, `total`, `deposit`, `cashout`, `credit`, `charges`, `authentication_pin`, `otp`, `dob`, `refunds`, `total_amount`, `cashout_type`, `credit_default`, `commission_charges`, `commission_charges_type`, `commission_charges_status`, `authentication_pin_status`, `dob_alaram`, `default_discount_status`, `default_discount_amount`, `default_discount_value`, `default_discount_type`, `notes`, `cust_account_no`, `cust_ifsc_code`, `cust_account_holder_name`, `cust_bank_name`, `datetimee_new`, `user_id`, `tax1`, `tax2`, `tax3`, `tax4`, `tax5`, `tax6`, `tax7`, `tax8`, `tax9`, `tax10`, `tax11`, `tax12`, `tax13`, `tax14`, `tax15`, `tax_selection`, `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`, `proceedings`, `SaleType`, `Cheque_num`, `CreditAmount`, `SaleTime`, `SaleDate`, `Transaction_ID`, `Card_Type`, `Card_Num`, `RRN`, `pincode`, `limit_status`, `limit_value`, `limit_present_value`, `write_off`, `loyal_points`) VALUES (1,'rohith','9581497872','trdt','geg','1.00','20250915-0000112','15 Sep 2025','02:27:53 PM','2025 09 15','1.00',NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,'1.00',NULL,'off',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'202509151427','rohith',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'All',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'off','  Card','0','0','02:27:53 PM','15 Sep 2025','off','off','off','off','517425','no limit','','',NULL,'0'),(2,'rohith','9581497872','trdt','geg','6.00','20251008-000013','08 Oct 2025','02:20:48 PM','2025 10 08',NULL,NULL,NULL,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'off',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'202510081420','rohith',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'All',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'off','  Pay Later','0','off','off','08 Oct 2025','off','off','off','off','517425','no limit','','',NULL,'0');
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 `generalorderlistascdesc1` (`_id`, `date`, `time`, `user`, `billno`, `billdetails`, `sales`, `discountamount`, `paymentmethod`, `billtype`, `itemname`, `quan`, `tableid`, `individualprice`, `date1`, `datetimee`, `cardnumber`, `individualtotal`, `billcount`, `hsn_code`, `itemtax_name`, `itemtax_per`, `itemtax_rs`, `globaltax_rs`, `itemtax_name2`, `itemtax_rs2`, `itemtax_name3`, `itemtax_rs3`, `itemtax_name4`, `itemtax_rs4`, `itemtax_name5`, `itemtax_rs5`, `person`) VALUES (1,'08 Oct 2025','01:09:02 PM','madmin','20251008-000011',NULL,6,'0','  Pay Later','  General','VPM 2 Agal Middle','1.0','1','6.00','2025 10 08','20251008130902','','6.00','26',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'08 Oct 2025','01:11:14 PM','madmin','20251008-000012',NULL,6,'0','  Cash','  General','VPM 2 Agal Middle','1.0','1','6.00','2025 10 08','20251008131114','','6.00','27',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'08 Oct 2025','02:20:45 PM','madmin','20251008-000013',NULL,6,'0','  Pay Later','  General','VPM 2 Agal Middle','1.0','1','6.00','2025 10 08','20251008142045','','6.00','28',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'08 Oct 2025','02:45:08 PM','madmin','20251008-000014',NULL,6,'0','  Card','  General','VPM 2 Agal Middle','1.0','1','6.00','2025 10 08','20251008144508','','6.00','29',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'08 Oct 2025','03:26:00 PM','madmin','20251008-000015',NULL,6,'0','  Card','  General','VPM 2 Agal Middle','1.0','1','6.00','2025 10 08','20251008152600','','6.00','30',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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\":\"FldK28pAt5dCGqGewNa2PDgSHxPmhEViPG1UvGa1XqoQ1/Q+4RUYgvpniY3DtWoek9TpF/olZRaejGFgqhBKgMLDeyzeNWBQ3rT9ShfBSKL2gctrY/NwFO50YkkQy8uDzz0KbR3HlrGjtGVdnA1CFB0n2tPgB+WY6ED0OzTT/yZkYpWs6M4nbWBGGGLX+RALX2VwVQApG+6HdWfAFVCzVR61CYRJPkyCv+WmrjggWkv8qucmldQOtzbwqYVrXWTmVr2MYP6y43JkzgSD5piDUWj4eXo34ceThMHE/otM8W5nYXmN1HesA6v/RDdNuNd/YVx6A4AcY0NB+mZzYz+c8CxVRGd2pcHM5Hz01hIPxnp5N5Fg9Xk9IFDfWiQLBBVHzr8xB7NxmtmVs8PzlLnFSclEr8G+xMOwwKxwEEb6t+Dtpix4R26Al9p61QBjE18cGmqmAcMpbGU+N1vliNaXKd8YbHh4uw6NY7tbrkbNJUOz+sRMWuEW3+F1m7kQmSLxB57A7CBvxpuGPomJrUU7kt/5OqfkeDYm3zw+6TOpA8mqjtEOOXZUoF7RQARWEBLox3iQNV387JQ8aYDau8aBHXrTgAPTAGdbHoHC+9uXSfvsfqIVknlxZeawc4HR39WKvDjAkzqtpZU+QlaQAOsKwWsZeHMPEemdMAFvsQ2HZLyjqMp7qGAhidgWcMYgv8NTs/r+/pQ9Id1e7ijgSxXxH6Szb9xUJR/JA1LP2Fp6wXMTvUW/nWhh8tJQ/EnxVnYqNFyJYkFp7YzCT/RWOkb0edj8mZKQ1PU4QVyCG92CcoeFopGDIEYh8zqNdOzNGXsc2QRd58olnwdtkqOKoGUct4OFX6eiKElVlukG47vLeGSawES7xoG5JqnTqQFHH+/roFJ8aaE0Irxj7qGvpnC4pGcEw0ZoRZ4T0qs39eVP2zWqU1s96+f8K1KR9mC0XS4MeKHXTnJGbqGHu3f3+tl3jJlWtqlA8RpRXHqP5nJgZzf/wzaxj43Xw+VGiEt0cGHLHn6sYB0M+qtV5dIpPXlRbNssr0AswdMyb+hFyTAKiHZ3J2E7qGoYnB5Vg30XUvWEPO+gGPeCDBumN46ji3xnliLz2tjeKfHilV4ouYeQZbE2TKjDlEGwKzPxkFmTjDIwMjUtMDktMTZUMTM6NTc=\",\"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\":\"m4+K3sh1Tp0xDqizEi0eXuQB+Xgfq5lqmwLXhAzcz9LF87lQ4ErYV9ejk04VOXbLQ8JhA24ig+wCF909UAqQV/qC7csxF+07LLfirmqMq9nI9T8hUBZlwUqDTtPTStG7Xzcorfz3NqjEVLgkvpN+bV09TQ1JhrBiGYjOXHAuPfmx0X3McHGbk4j3HeWjIOwmC0gAnPDtwbOcVTgOIH/ToP5qX1UCBNzkjBT9AXKYv/hPVWjXwAs3rLyOJWAmPFJHrchbTtmqArVcVBhZogNZUzI1Gld33q2NmjvQTQcTBD07GVpt4ujmZyaxSiRBUnWkBaDzM/tEP6HAsu/AL7dJTP7fxF1wgnZN7/v66ryKhwh7I9pWXUswpS99Kg1qysictcnmumK6kJI10MSf6eUl6kkg5+4U+nFv4c+7+bQ3sSXeA5dSIzd6b60zfA8ru2sZphaZ3DvPj6Fr7OBUitv1K9BbDSLIXCp5ZngnNk4qReg3aLXuvxn+wL+3vfN42ALyAYo8ltC3qFAu94INLdGvjOJOVr4xPf2SwDITonEYScaoxFrpdcDjS4efkqyxZYUHcPOJed7bCiKhWnFjfM3eJech8s3i0TGkBG7NYSb+9PpaQe3hfC6qFRDHbmQlzxKKfic2MK85k7p87E049OdiCPMjgMqIujO81V8Owal8VJqYD+Tcjg8L5a3rp9I43vX5G4goCoG9MioAM/Bs/zQa31s1ghzMhXf1LPBhZkcOroC/+M/Kowlp8W7gwm1Um7a3YyMhhgL14DEu96CtjfGC09XCF2EW4T61SW2O7XZJ4YsvW7wI2o4PQ/5OdHC6R6O7HKTjQ32aB0DiIz7RDwZ3TlAKbioZYW7ZY4do/pFHpLjwHsEHDjoRR8066C3z9uSzULbpc1gHww+tNfXUC0q78//ddwkkzHfFu84DZXIQB2Tf6xDlL3KELNkrbMW8bo3kress3TZ5i4T4ddcRQMAYB2uRk/dWPAx3++V/NokjD8A9GI4RqqfkGzDSe0rBdNjbvXgr6qr+fAMTWGVvsDaxZHvQnxQeSBGE7rR6WSxn6ZTGWyBwHqCQ5tTj2uYVBKJjCBEctSvqfEnBS6QQfcV4QXrBiJO2/d8qB91NqraU1gveccUr92GH+5Jv4nI6fzIwMjUtMDktMTZUMTU6NTA=\",\"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\":\"2egCxLI51alM8tqSym0I/icZl0vmef+ab/2GVnXun/qE4CKfIAkCFPO2+/5UBW6R8GgZihkw+d3rbT6ZA9qHRWYm7Ix1MPr/QTfh7rbNnrTR0zUbYtEcxcgNysuc/zotcJyZA3/ED0fssfthAZmUiaDkaK8ZGvjRnLTR6pEi7trDl+igQ082PllohkSeLNvZFl4KHJbTke9uTtalEMBmwt4Z8Zgt6hDPGr8l2rgV53489K3eH4/k+VR+n1lqRpbF9sgMQueKupaOmvYZj0HpVhzxD7YMyChzY9W0JyPk41vHBnC+n9ss5VZcsHqIcuVkyLoIFMgmMMYPZQmlweldnoLcsIga4D8ZOCGZqXcrhavfH5pgkHh78VSFU+SRD7vJoDwSesPnU7ag9u1JP+kFBhGr7YtYeWInN9dXeChe4i09Rccpw4Yi0mWOnxfBvb8mgfrgKqu3aEGTjGGN+L93RZajjxgLyEJp5DsHqweGWdXR8Aj36qXe9meUM8U79BRHvRHuvY9wubmk4IcrA2GhMs8/yBtEOuoLD9JpvMxiBpGxzbtnoNJzKNjgyOL+ut7eHwuGd56uPHE8BKiuaC9VTZAizwsipbAMoVDo7z9ZXUuCaZ/IopMcxAicX8jEMz49v700bsQnPBrA6EqpJ5PmFO7Mk/zdeuO+JYyK351Eia/+XNIELNH5NTFQl19VirxxdeSWsS8wb3xbyQcAGi8Q+m4Js+2FarqFyH4DJ9wNvesVhuq9ii4Dqe3LY0f4EbGrrTThlDnMh5SoS4j/WvGt+BBIEGthCHE58R6Qx914/84rzWQhCutfExkE4umRymySF8K8Rvk36ptOnSdzD1eLe5iYjx7tdpkfK/XXpXp+m0VX2tVg7EWWdxWJ1Ul2RRUzjsTgRKeHgq8G+o6eCQtk2h3FoAElesJ8gMjrlStbPSWy4nwMNrK5JZitw8KqtpjsCEa9R80aj5UaMMo66X7eUHN5plsOUbls/y6+jh6hhApn8eRBKfmr7UKCIA4rnNCk6aLPuErc6gYdoDMJ3rPRxrsZVfzRq4W4L8pyvvQfrf4SipyMlHhEU+vU4O6pZb33qdbhTO63DyL4L234gt+QuPML0m/wJmas5IXGo5C/BFkrneXr94RPWeimb5xlEDIwMjUtMDktMTZUMTc6MzM=\",\"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\":\"jhQkOLYFmnHRU+zywrX1MCnNA68F7yYBLVUInoUgUcRi3Is1BC5JCt4GfFG46EFaGF4Oav+fQCyX7JKhoXFfhStC5xNAgKSuB3z77efGH6F+VYxPb4aeyjHWEC6+a8otJ38mx1yv6S0X+d7+DjkHMjvfgdSUQEMLM7RVzwPXhYgB8cDFbkimkHaPFTPhWFizgEaraLSGeGBKwsdk0GMzr2Eko4oohAAtSBKRM8WcX3gV/BtZ658A1stwdC3G3JrJnylA51uKanVm2oZ1NBIPas071jkEsyL2+ftenx3MlqaSMm7GO+psAqHXwffuBkEM/WyOQqce6I2G3PAoYyMJ8yLHbLY8v/1RWg6XwCGUl4wbteG50V04IgQrq6JdSeSZdCKdjB6wVAsrNgDAbXBHdsADhV+93vSfVoKVy+SBqZGBS0DBGDiQU+iW5CPJcNsSRYqV2lJydRAd5VUc27HpysyZ/qpHXSHx7lvLFXWbmq0q37p6zDqblx0HXfNDO484Q/7qSohKOHb0MjtHT8xIDD8yjRyPj2Q3AjaWcC3aX3eYhzcJy1Jsupv90z/cX4gLgE4Ryo2XWbR3u/ZyZyWbjzWjH0r7U6WG0+JLNSjaWIEZ6+12P6PJRwzizX8MVmWcV6OmAdCHgEc5cTcVO8S4AgaU4SiTQlNsRwFGVzI7yk3Y+Idsu+n+uuugIKINPlWLJEslf1GFohSFa8L4Rwwce/IrNYEcCYvjrfMlSF/OLiHKpEsXtr5jvl1B0E3SlHBaDfeRsmfqoEA1GlE4GwjdYmx89H3vn+R1pYE5lg2gbdd+zEJCsFG9N7WjduOnMX+QC2ENlFAasSVpnA2Jwjt531KBkSVP4LJI+gf3/mSu+zZsH8l0NrR3pBJdZ2FQpziViyljzipYTr9ADT0DPvGswqklDk+15B92T645hpIXbFgIegFituCcPyU7tL+PqQxW6zEz0pPfuzAFO2XsbNuwKeOdOyIQCorrrQsYVPSSXcaX1+VPeEkfxHXz/hQxvTjJJXJu3Alg6XES+e1pH7tpyJhaNJ+CBJNspsvtDBkdUBKjD/j7n3y3bfW8MRr7FHmR6fKloqvwlpuKBJ99XeeLKpi0Bbv9dpKpNXD4jJTbx6EkCn2kGsnCpWt3/30h/yqPH0o0Zd5zTjT+28Uvn+A9LGRYeUDXMjAyNS0wOS0yMlQxMjoyMQ==\",\"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\":\"FldK28pAt5dCGqGewNa2PDgSHxPmhEViPG1UvGa1XqoQ1/Q+4RUYgvpniY3DtWoek9TpF/olZRaejGFgqhBKgMLDeyzeNWBQ3rT9ShfBSKL2gctrY/NwFO50YkkQy8uDzz0KbR3HlrGjtGVdnA1CFB0n2tPgB+WY6ED0OzTT/yZkYpWs6M4nbWBGGGLX+RALX2VwVQApG+6HdWfAFVCzVR61CYRJPkyCv+WmrjggWkv8qucmldQOtzbwqYVrXWTmVr2MYP6y43JkzgSD5piDUWj4eXo34ceThMHE/otM8W5nYXmN1HesA6v/RDdNuNd/YVx6A4AcY0NB+mZzYz+c8CxVRGd2pcHM5Hz01hIPxnp5N5Fg9Xk9IFDfWiQLBBVHzr8xB7NxmtmVs8PzlLnFSclEr8G+xMOwwKxwEEb6t+Dtpix4R26Al9p61QBjE18cGmqmAcMpbGU+N1vliNaXKd8YbHh4uw6NY7tbrkbNJUOz+sRMWuEW3+F1m7kQmSLxB57A7CBvxpuGPomJrUU7kt/5OqfkeDYm3zw+6TOpA8mqjtEOOXZUoF7RQARWEBLox3iQNV387JQ8aYDau8aBHXrTgAPTAGdbHoHC+9uXSfvsfqIVknlxZeawc4HR39WKvDjAkzqtpZU+QlaQAOsKwWsZeHMPEemdMAFvsQ2HZLyjqMp7qGAhidgWcMYgv8NTs/r+/pQ9Id1e7ijgSxXxH6Szb9xUJR/JA1LP2Fp6wXMTvUW/nWhh8tJQ/EnxVnYqNFyJYkFp7YzCT/RWOkb0edj8mZKQ1PU4QVyCG92CcoeFopGDIEYh8zqNdOzNGXsc2QRd58olnwdtkqOKoGUct4OFX6eiKElVlukG47vLeGSawES7xoG5JqnTqQFHH+/roFJ8aaE0Irxj7qGvpnC4pGcEw0ZoRZ4T0qs39eVP2zWqU1s96+f8K1KR9mC0XS4MeKHXTnJGbqGHu3f3+tl3jJlWtqlA8RpRXHqP5nJgZzf/wzaxj43Xw+VGiEt0cGHLHn6sYB0M+qtV5dIpPXlRbNssr0AswdMyb+hFyTAKiHZ3J2E7qGoYnB5Vg30XUvWEPO+gGPeCDBumN46ji3xnliLz2tjeKfHilV4ouYeQZbE2TKjDlEGwKzPxkFmTjDIwMjUtMDktMTZUMTM6NTc=\",\"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\":\"m4+K3sh1Tp0xDqizEi0eXuQB+Xgfq5lqmwLXhAzcz9LF87lQ4ErYV9ejk04VOXbLQ8JhA24ig+wCF909UAqQV/qC7csxF+07LLfirmqMq9nI9T8hUBZlwUqDTtPTStG7Xzcorfz3NqjEVLgkvpN+bV09TQ1JhrBiGYjOXHAuPfmx0X3McHGbk4j3HeWjIOwmC0gAnPDtwbOcVTgOIH/ToP5qX1UCBNzkjBT9AXKYv/hPVWjXwAs3rLyOJWAmPFJHrchbTtmqArVcVBhZogNZUzI1Gld33q2NmjvQTQcTBD07GVpt4ujmZyaxSiRBUnWkBaDzM/tEP6HAsu/AL7dJTP7fxF1wgnZN7/v66ryKhwh7I9pWXUswpS99Kg1qysictcnmumK6kJI10MSf6eUl6kkg5+4U+nFv4c+7+bQ3sSXeA5dSIzd6b60zfA8ru2sZphaZ3DvPj6Fr7OBUitv1K9BbDSLIXCp5ZngnNk4qReg3aLXuvxn+wL+3vfN42ALyAYo8ltC3qFAu94INLdGvjOJOVr4xPf2SwDITonEYScaoxFrpdcDjS4efkqyxZYUHcPOJed7bCiKhWnFjfM3eJech8s3i0TGkBG7NYSb+9PpaQe3hfC6qFRDHbmQlzxKKfic2MK85k7p87E049OdiCPMjgMqIujO81V8Owal8VJqYD+Tcjg8L5a3rp9I43vX5G4goCoG9MioAM/Bs/zQa31s1ghzMhXf1LPBhZkcOroC/+M/Kowlp8W7gwm1Um7a3YyMhhgL14DEu96CtjfGC09XCF2EW4T61SW2O7XZJ4YsvW7wI2o4PQ/5OdHC6R6O7HKTjQ32aB0DiIz7RDwZ3TlAKbioZYW7ZY4do/pFHpLjwHsEHDjoRR8066C3z9uSzULbpc1gHww+tNfXUC0q78//ddwkkzHfFu84DZXIQB2Tf6xDlL3KELNkrbMW8bo3kress3TZ5i4T4ddcRQMAYB2uRk/dWPAx3++V/NokjD8A9GI4RqqfkGzDSe0rBdNjbvXgr6qr+fAMTWGVvsDaxZHvQnxQeSBGE7rR6WSxn6ZTGWyBwHqCQ5tTj2uYVBKJjCBEctSvqfEnBS6QQfcV4QXrBiJO2/d8qB91NqraU1gveccUr92GH+5Jv4nI6fzIwMjUtMDktMTZUMTU6NTA=\",\"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\":\"2egCxLI51alM8tqSym0I/icZl0vmef+ab/2GVnXun/qE4CKfIAkCFPO2+/5UBW6R8GgZihkw+d3rbT6ZA9qHRWYm7Ix1MPr/QTfh7rbNnrTR0zUbYtEcxcgNysuc/zotcJyZA3/ED0fssfthAZmUiaDkaK8ZGvjRnLTR6pEi7trDl+igQ082PllohkSeLNvZFl4KHJbTke9uTtalEMBmwt4Z8Zgt6hDPGr8l2rgV53489K3eH4/k+VR+n1lqRpbF9sgMQueKupaOmvYZj0HpVhzxD7YMyChzY9W0JyPk41vHBnC+n9ss5VZcsHqIcuVkyLoIFMgmMMYPZQmlweldnoLcsIga4D8ZOCGZqXcrhavfH5pgkHh78VSFU+SRD7vJoDwSesPnU7ag9u1JP+kFBhGr7YtYeWInN9dXeChe4i09Rccpw4Yi0mWOnxfBvb8mgfrgKqu3aEGTjGGN+L93RZajjxgLyEJp5DsHqweGWdXR8Aj36qXe9meUM8U79BRHvRHuvY9wubmk4IcrA2GhMs8/yBtEOuoLD9JpvMxiBpGxzbtnoNJzKNjgyOL+ut7eHwuGd56uPHE8BKiuaC9VTZAizwsipbAMoVDo7z9ZXUuCaZ/IopMcxAicX8jEMz49v700bsQnPBrA6EqpJ5PmFO7Mk/zdeuO+JYyK351Eia/+XNIELNH5NTFQl19VirxxdeSWsS8wb3xbyQcAGi8Q+m4Js+2FarqFyH4DJ9wNvesVhuq9ii4Dqe3LY0f4EbGrrTThlDnMh5SoS4j/WvGt+BBIEGthCHE58R6Qx914/84rzWQhCutfExkE4umRymySF8K8Rvk36ptOnSdzD1eLe5iYjx7tdpkfK/XXpXp+m0VX2tVg7EWWdxWJ1Ul2RRUzjsTgRKeHgq8G+o6eCQtk2h3FoAElesJ8gMjrlStbPSWy4nwMNrK5JZitw8KqtpjsCEa9R80aj5UaMMo66X7eUHN5plsOUbls/y6+jh6hhApn8eRBKfmr7UKCIA4rnNCk6aLPuErc6gYdoDMJ3rPRxrsZVfzRq4W4L8pyvvQfrf4SipyMlHhEU+vU4O6pZb33qdbhTO63DyL4L234gt+QuPML0m/wJmas5IXGo5C/BFkrneXr94RPWeimb5xlEDIwMjUtMDktMTZUMTc6MzM=\",\"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\":\"jhQkOLYFmnHRU+zywrX1MCnNA68F7yYBLVUInoUgUcRi3Is1BC5JCt4GfFG46EFaGF4Oav+fQCyX7JKhoXFfhStC5xNAgKSuB3z77efGH6F+VYxPb4aeyjHWEC6+a8otJ38mx1yv6S0X+d7+DjkHMjvfgdSUQEMLM7RVzwPXhYgB8cDFbkimkHaPFTPhWFizgEaraLSGeGBKwsdk0GMzr2Eko4oohAAtSBKRM8WcX3gV/BtZ658A1stwdC3G3JrJnylA51uKanVm2oZ1NBIPas071jkEsyL2+ftenx3MlqaSMm7GO+psAqHXwffuBkEM/WyOQqce6I2G3PAoYyMJ8yLHbLY8v/1RWg6XwCGUl4wbteG50V04IgQrq6JdSeSZdCKdjB6wVAsrNgDAbXBHdsADhV+93vSfVoKVy+SBqZGBS0DBGDiQU+iW5CPJcNsSRYqV2lJydRAd5VUc27HpysyZ/qpHXSHx7lvLFXWbmq0q37p6zDqblx0HXfNDO484Q/7qSohKOHb0MjtHT8xIDD8yjRyPj2Q3AjaWcC3aX3eYhzcJy1Jsupv90z/cX4gLgE4Ryo2XWbR3u/ZyZyWbjzWjH0r7U6WG0+JLNSjaWIEZ6+12P6PJRwzizX8MVmWcV6OmAdCHgEc5cTcVO8S4AgaU4SiTQlNsRwFGVzI7yk3Y+Idsu+n+uuugIKINPlWLJEslf1GFohSFa8L4Rwwce/IrNYEcCYvjrfMlSF/OLiHKpEsXtr5jvl1B0E3SlHBaDfeRsmfqoEA1GlE4GwjdYmx89H3vn+R1pYE5lg2gbdd+zEJCsFG9N7WjduOnMX+QC2ENlFAasSVpnA2Jwjt531KBkSVP4LJI+gf3/mSu+zZsH8l0NrR3pBJdZ2FQpziViyljzipYTr9ADT0DPvGswqklDk+15B92T645hpIXbFgIegFituCcPyU7tL+PqQxW6zEz0pPfuzAFO2XsbNuwKeOdOyIQCorrrQsYVPSSXcaX1+VPeEkfxHXz/hQxvTjJJXJu3Alg6XES+e1pH7tpyJhaNJ+CBJNspsvtDBkdUBKjD/j7n3y3bfW8MRr7FHmR6fKloqvwlpuKBJ99XeeLKpi0Bbv9dpKpNXD4jJTbx6EkCn2kGsnCpWt3/30h/yqPH0o0Zd5zTjT+28Uvn+A9LGRYeUDXMjAyNS0wOS0yMlQxMjoyMQ==\",\"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);
