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`) VALUES (1,'DC NODE','1.0','1150.00','1150.00','Item',NULL,NULL,'no',NULL,NULL,'20230603-000011','01:53:11 PM','2023 06 03','admin','1','  General','  Cash','1150.00','1150.00','1',NULL,NULL,NULL,NULL,'03 Jun 2023','2023060313:53:11','%','0','1150.00','no','0.00',NULL,'202306031353','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(2,'DC NODE','1.0','1150.00','1150.00','Item',NULL,NULL,'no',NULL,NULL,'20230603-000012','02:21:13 PM','2023 06 03','admin','1','  General','  Pay Later','2900.00','2900.00','2',NULL,NULL,NULL,NULL,'03 Jun 2023','2023060314:21:13','%','0','4600.00','no','0.00',NULL,'202306031421','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin','2900.00',NULL,'',NULL,NULL,'','','',''),(3,'ONT','1.0','1750.00','1750.00','Item',NULL,NULL,'no',NULL,NULL,'20230603-000012','02:21:13 PM','2023 06 03','admin','1','  General','  Pay Later','2900.00','2900.00','3',NULL,NULL,NULL,NULL,'03 Jun 2023','2023060314:21:13','%','0','1750.00','no','0.00',NULL,'202306031421','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'netlink','admin','madmin','2900.00',NULL,'',NULL,NULL,'','','',''),(4,'DC NODE','5.0','1150.00','5750.00','Item',NULL,NULL,'no',NULL,NULL,'20230603-000013','02:23:53 PM','2023 06 03','admin','1','  General','  Cash','5750.00','5750.00','4',NULL,NULL,NULL,NULL,'03 Jun 2023','2023060314:23:53','%','0','6900.00','no','0.00',NULL,'202306031423','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(5,'2 WAY SPLITTER 2S1','2.0','65.00','130.00','Item',NULL,NULL,'no',NULL,NULL,'20230605-000011','11:16:29 AM','2023 06 05','admin','1','  General','  Cash','1030.00','1030.00','16',NULL,NULL,NULL,NULL,'05 Jun 2023','2023060511:16:29','%','0','130.00','no','0.00',NULL,'202306051116','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(6,'3WAY SPLITTER 3S1','2.0','70.00','140.00','Item',NULL,NULL,'no',NULL,NULL,'20230605-000011','11:16:29 AM','2023 06 05','admin','1','  General','  Cash','1030.00','1030.00','17',NULL,NULL,NULL,NULL,'05 Jun 2023','2023060511:16:29','%','0','140.00','no','0.00',NULL,'202306051116','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(7,'4WAY SPLITTER 4S1','2.0','75.00','150.00','Item',NULL,NULL,'no',NULL,NULL,'20230605-000011','11:16:29 AM','2023 06 05','admin','1','  General','  Cash','1030.00','1030.00','18',NULL,NULL,NULL,NULL,'05 Jun 2023','2023060511:16:29','%','0','150.00','no','0.00',NULL,'202306051116','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(8,'SHARP COUPLER 90:10 ','2.0','140.00','280.00','Item',NULL,NULL,'no',NULL,NULL,'20230605-000011','11:16:29 AM','2023 06 05','admin','1','  General','  Cash','1030.00','1030.00','19',NULL,NULL,NULL,NULL,'05 Jun 2023','2023060511:16:29','%','0','280.00','no','0.00',NULL,'202306051116','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(9,'VX F5 CONNECTOR','25.0','6.00','150.00','Item',NULL,NULL,'no',NULL,NULL,'20230605-000011','11:16:29 AM','2023 06 05','admin','1','  General','  Cash','1030.00','1030.00','20',NULL,NULL,NULL,NULL,'05 Jun 2023','2023060511:16:29','%','0','150.00','no','0.00',NULL,'202306051116','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(10,'US OPTICAL PATCH CORD BLUE','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20230605-000011','11:16:29 AM','2023 06 05','admin','1','  General','  Cash','1030.00','1030.00','21',NULL,NULL,NULL,NULL,'05 Jun 2023','2023060511:16:29','₹','5','60.00','yes','5.00',NULL,'202306051116','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UNITED SYSTEM','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(11,'US OPTICAL PATCH CORD GREEN','2.0','65.00','130.00','Item',NULL,NULL,'no',NULL,NULL,'20230605-000011','11:16:29 AM','2023 06 05','admin','1','  General','  Cash','1030.00','1030.00','22',NULL,NULL,NULL,NULL,'05 Jun 2023','2023060511:16:29','₹','5','120.00','yes','10.00',NULL,'202306051116','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UNITED SYSTEM','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(12,'SHARP PSP 12V','10.0','80.00','800.00','Item',NULL,NULL,'no',NULL,NULL,'20230605-000012','01:22:13 PM','2023 06 05','admin','1','  General','  Upiqr','1150.00','1150.00','23',NULL,NULL,NULL,NULL,'05 Jun 2023','2023060513:22:13','%','0','800.00','no','0.00',NULL,'202306051322','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin','0',NULL,'',NULL,NULL,'','','',''),(13,'SHARP 4WAY SPLITTER 4S','4.0','75.00','300.00','Item',NULL,NULL,'no',NULL,NULL,'20230605-000012','01:22:13 PM','2023 06 05','admin','1','  General','  Upiqr','1150.00','1150.00','24',NULL,NULL,NULL,NULL,'05 Jun 2023','2023060513:22:13','%','0','300.00','no','0.00',NULL,'202306051322','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin','0',NULL,'',NULL,NULL,'','','',''),(14,'COURIER CHARGE','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20230605-000012','01:22:13 PM','2023 06 05','admin','1','  General','  Upiqr','1150.00','1150.00','25',NULL,NULL,NULL,NULL,'05 Jun 2023','2023060513:22:13','%','0','50.00','no','0.00',NULL,'202306051322','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'COURIER ','admin','madmin','0',NULL,'',NULL,NULL,'','','',''),(15,'SERVICE CHARGE','1.0','350.00','350.00','Item',NULL,NULL,'no',NULL,NULL,'20230605-000013','01:46:31 PM','2023 06 05','admin','1','  General','  Cash','350.00','350.00','26',NULL,NULL,NULL,NULL,'05 Jun 2023','2023060513:46:31','%','0','350.00','no','0.00',NULL,'202306051346','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SERVICE CHARGE','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(16,'UNITED SYSTEM DC NODE 4 OUT ','2.0','1000.00','2000.00','Item',NULL,NULL,'no',NULL,NULL,'20230605-000014','03:53:04 PM','2023 06 05','admin','1','  General','  Cash','1700.00','1700.00','27',NULL,NULL,NULL,NULL,'05 Jun 2023','2023060515:53:04','₹','150','1700.00','yes','300.00',NULL,'202306051553','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UNITED SYSTEM','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(17,'RG6 CCS','2.0','600.00','1200.00','Item',NULL,NULL,'no',NULL,NULL,'20230607-000011','10:45:36 AM','2023 06 07','admin','1','  General','  Cash','1200.00','1200.00','32',NULL,NULL,NULL,NULL,'07 Jun 2023','2023060710:45:36','%','0','1200.00','no','0.00',NULL,'202306071045','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Everfocus','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(18,'SINGLE FACEPLATE ','4.0','55.00','220.00','Item',NULL,NULL,'no',NULL,NULL,'20230607-000012','12:07:29 PM','2023 06 07','admin','1','  General','  Cash','1195.00','1195.00','34',NULL,NULL,NULL,NULL,'07 Jun 2023','2023060712:07:29','%','0','220.00','no','0.00',NULL,'202306071207','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NETWORK ITEMS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(19,'FACE PLATE DUAL','15.0','65.00','975.00','Item',NULL,NULL,'no',NULL,NULL,'20230607-000012','12:07:29 PM','2023 06 07','admin','1','  General','  Cash','1195.00','1195.00','35',NULL,NULL,NULL,NULL,'07 Jun 2023','2023060712:07:29','%','0','975.00','no','0.00',NULL,'202306071207','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NETWORK ITEMS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(20,'FACE PLATE FOUR','1.0','85.00','85.00','Item',NULL,NULL,'no',NULL,NULL,'20230607-000013','12:12:37 PM','2023 06 07','admin','1','  General','  Cash','85.00','85.00','36',NULL,NULL,NULL,NULL,'07 Jun 2023','2023060712:12:37','%','0','85.00','no','0.00',NULL,'202306071212','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NETWORK ITEMS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(21,'SPARSH 4:1 VDA','1.0','1450.00','1450.00','Item',NULL,NULL,'no',NULL,NULL,'20230607-000014','12:18:26 PM','2023 06 07','admin','1','  General','  Cash','1450.00','1450.00','37',NULL,NULL,NULL,NULL,'07 Jun 2023','2023060712:18:26','%','0','1450.00','no','0.00',NULL,'202306071218','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(22,'SERVICE CHARGES','1.0','400.00','400.00','Item',NULL,NULL,'no',NULL,NULL,'20230607-000015','12:18:54 PM','2023 06 07','admin','1','  General','  Cash','400.00','400.00','38',NULL,NULL,NULL,NULL,'07 Jun 2023','2023060712:18:54','%','0','400.00','no','0.00',NULL,'202306071218','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SERVICE CHARGE','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(23,'EVERFOCUS 1+3 90 MTR','1.0','950.00','950.00','Item',NULL,NULL,'no',NULL,NULL,'20230607-000016','12:21:45 PM','2023 06 07','admin','1','  General','  Cash','950.00','950.00','39',NULL,NULL,NULL,NULL,'07 Jun 2023','2023060712:21:45','%','0','1900.00','no','0.00',NULL,'202306071221','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Everfocus','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(24,'EVERFOCUS 1+3 90 MTR','1.0','950.00','950.00','Item',NULL,NULL,'no',NULL,NULL,'20230607-000017','12:28:08 PM','2023 06 07','admin','1','  General','  Cash','1030.00','1030.00','40',NULL,NULL,NULL,NULL,'07 Jun 2023','2023060712:28:08','₹','50','900.00','yes','50.00',NULL,'202306071228','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Everfocus','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(25,'BNC WIRED','10.0','10.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20230607-000017','12:28:08 PM','2023 06 07','admin','1','  General','  Cash','1030.00','1030.00','41',NULL,NULL,NULL,NULL,'07 Jun 2023','2023060712:28:08','%','0','100.00','no','0.00',NULL,'202306071228','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(26,'DC CONNCETOR','6.0','5.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20230607-000017','12:28:08 PM','2023 06 07','admin','1','  General','  Cash','1030.00','1030.00','42',NULL,NULL,NULL,NULL,'07 Jun 2023','2023060712:28:08','%','0','30.00','no','0.00',NULL,'202306071228','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(27,'SHARP  7WAY TAPOFF','1.0','200.00','200.00','Item',NULL,NULL,'no',NULL,NULL,'20230607-000018','12:57:27 PM','2023 06 07','admin','1','  General','  Cash','200.00','200.00','44',NULL,NULL,NULL,NULL,'07 Jun 2023','2023060712:57:27','%','0','200.00','no','0.00',NULL,'202306071257','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(28,'RG6 RING 1 PACKET','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20230607-000019','01:01:57 PM','2023 06 07','admin','1','  General','  Cash','40.00','40.00','46',NULL,NULL,NULL,NULL,'07 Jun 2023','2023060713:01:57','%','0','40.00','no','0.00',NULL,'202306071301','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(29,'IO. BACK BOX','3.0','30.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20230607-0000110','01:24:51 PM','2023 06 07','admin','1','  General','  Cash','1350.00','1350.00','47',NULL,NULL,NULL,NULL,'07 Jun 2023','2023060713:24:51','%','0','90.00','no','0.00',NULL,'202306071324','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NETWORK ITEMS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(30,'CAT6 I/O ','9.0','90.00','810.00','Item',NULL,NULL,'no',NULL,NULL,'20230607-0000110','01:24:51 PM','2023 06 07','admin','1','  General','  Cash','1350.00','1350.00','48',NULL,NULL,NULL,NULL,'07 Jun 2023','2023060713:24:51','%','0','810.00','no','0.00',NULL,'202306071324','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NETWORK ITEMS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(31,'SINGLE FACEPLATE ','9.0','55.00','495.00','Item',NULL,NULL,'no',NULL,NULL,'20230607-0000110','01:24:51 PM','2023 06 07','admin','1','  General','  Cash','1350.00','1350.00','49',NULL,NULL,NULL,NULL,'07 Jun 2023','2023060713:24:51','₹','5','450.00','yes','45.00',NULL,'202306071324','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NETWORK ITEMS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(32,'US 16 AC NODE','1.0','1300.00','1300.00','Item',NULL,NULL,'no',NULL,NULL,'20230607-0000111','01:27:31 PM','2023 06 07','admin','1','  General','  Cash','1300.00','1300.00','51',NULL,NULL,NULL,NULL,'07 Jun 2023','2023060713:27:31','%','0','1300.00','no','0.00',NULL,'202306071327','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UNITED SYSTEM','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(33,'IP SPRAY 500 ML','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20230607-0000112','01:29:44 PM','2023 06 07','admin','1','  General','  Cash','100.00','100.00','52',NULL,NULL,NULL,NULL,'07 Jun 2023','2023060713:29:44','%','0','100.00','no','0.00',NULL,'202306071329','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(34,'SHARP I/D  4WAY SPLITTER 4S','2.0','55','110.00','Item',NULL,NULL,'no',NULL,NULL,'20230607-0000113','01:50:06 PM','2023 06 07','admin','1','  General','  Cash','110.00','110.00','54',NULL,NULL,NULL,NULL,'07 Jun 2023','2023060713:50:06','%','0','75.00','no','0.00',NULL,'202306071350','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(35,'RG6 CCS','1.0','600.00','600.00','Item',NULL,NULL,'no',NULL,NULL,'20230607-0000114','03:46:12 PM','2023 06 07','admin','1','  General','  Cash','600.00','600.00','55',NULL,NULL,NULL,NULL,'07 Jun 2023','2023060715:46:12','%','0','600.00','no','0.00',NULL,'202306071546','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Everfocus','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(36,'EVERFOCUS 1+3 90 MTR','1.0','1000','1000.00','Item',NULL,NULL,'no',NULL,NULL,'20230607-0000115','03:47:07 PM','2023 06 07','admin','1','  General','  Cash','1000.00','1000.00','56',NULL,NULL,NULL,NULL,'07 Jun 2023','2023060715:47:07','%','0','950.00','no','0.00',NULL,'202306071547','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Everfocus','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(37,'US 4OUT FTTH','2.0','200.00','400.00','Item',NULL,NULL,'no',NULL,NULL,'20230607-0000116','03:51:42 PM','2023 06 07','admin','1','  General','  Cash','1300.00','1300.00','57',NULL,NULL,NULL,NULL,'07 Jun 2023','2023060715:51:42','%','0','400.00','no','0.00',NULL,'202306071551','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UNITED SYSTEM','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(38,'TELVASS 8OUT DC NODE','1.0','900.00','900.00','Item',NULL,NULL,'no',NULL,NULL,'20230607-0000116','03:51:42 PM','2023 06 07','admin','1','  General','  Cash','1300.00','1300.00','58',NULL,NULL,NULL,NULL,'07 Jun 2023','2023060715:51:42','%','0','900.00','no','0.00',NULL,'202306071551','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TELVASS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(39,'2 WAY SPLITTER 2S1','2.0','65.00','130.00','Item',NULL,NULL,'no',NULL,NULL,'20230607-000031','05:19:14 PM','2023 06 07','admin','3','  General','  Cash','270.00','270.00','2',NULL,NULL,NULL,NULL,'07 Jun 2023','2023060717:19:14','%','0','130.00','no','0.00',NULL,'202306071719','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(40,'3WAY SPLITTER 3S1','2.0','70.00','140.00','Item',NULL,NULL,'no',NULL,NULL,'20230607-000031','05:19:14 PM','2023 06 07','admin','3','  General','  Cash','270.00','270.00','3',NULL,NULL,NULL,NULL,'07 Jun 2023','2023060717:19:14','%','0','140.00','no','0.00',NULL,'202306071719','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(41,'4WAY SPLITTER 4S1','1.0','75.00','75.00','Item',NULL,NULL,'no',NULL,NULL,'20230607-000032','05:20:08 PM','2023 06 07','admin','3','  General','  Cash','75.00','75.00','4',NULL,NULL,NULL,NULL,'07 Jun 2023','2023060717:20:08','%','0','75.00','no','0.00',NULL,'202306071720','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(42,'SERVICE CHARGE','1.0','350.00','350.00','Item',NULL,NULL,'no',NULL,NULL,'20230607-000033','05:45:50 PM','2023 06 07','admin','3','  General','  Cash','350.00','350.00','5',NULL,NULL,NULL,NULL,'07 Jun 2023','2023060717:45:50','%','0','350.00','no','0.00',NULL,'202306071745','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SERVICE CHARGE','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(43,'SERVICE CHARGE','1.0','450','450.00','Item',NULL,NULL,'no',NULL,NULL,'20230608-000011','10:42:02 AM','2023 06 08','admin','1','  General','  Cash','450.00','450.00','60',NULL,NULL,NULL,NULL,'08 Jun 2023','2023060810:42:02','%','0','350.00','no','0.00',NULL,'202306081042','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SERVICE CHARGE','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(44,'THICK CARD','20.0','12.00','240.00','Item',NULL,NULL,'no',NULL,NULL,'20230608-000012','10:43:13 AM','2023 06 08','admin','1','  General','  Cash','240.00','240.00','61',NULL,NULL,NULL,NULL,'08 Jun 2023','2023060810:43:13','%','0','240.00','no','0.00',NULL,'202306081043','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BIOMETRIC ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(45,'2 WAY SPLITTER 2S1','2.0','65.00','130.00','Item',NULL,NULL,'no',NULL,NULL,'20230609-000011','01:22:40 PM','2023 06 09','admin','1','  General','  Cash','420.00','420.00','70',NULL,NULL,NULL,NULL,'09 Jun 2023','2023060913:22:40','%','0','130.00','no','0.00',NULL,'202306091322','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(46,'3WAY SPLITTER 3S1','2.0','70.00','140.00','Item',NULL,NULL,'no',NULL,NULL,'20230609-000011','01:22:40 PM','2023 06 09','admin','1','  General','  Cash','420.00','420.00','71',NULL,NULL,NULL,NULL,'09 Jun 2023','2023060913:22:40','%','0','140.00','no','0.00',NULL,'202306091322','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(47,'SHARP I/D  4WAY SPLITTER 4S','2.0','75.00','150.00','Item',NULL,NULL,'no',NULL,NULL,'20230609-000011','01:22:40 PM','2023 06 09','admin','1','  General','  Cash','420.00','420.00','72',NULL,NULL,NULL,NULL,'09 Jun 2023','2023060913:22:40','%','0','150.00','no','0.00',NULL,'202306091322','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(48,'4CH SMPS TELVASS','1.0','350.00','350.00','Item',NULL,NULL,'no',NULL,NULL,'20230609-000012','01:25:36 PM','2023 06 09','admin','1','  General','  Cash','1150.00','1150.00','73',NULL,NULL,NULL,NULL,'09 Jun 2023','2023060913:25:36','%','0','350.00','no','0.00',NULL,'202306091325','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(49,'8CH SMPS TELVASS','2.0','400.00','800.00','Item',NULL,NULL,'no',NULL,NULL,'20230609-000012','01:25:36 PM','2023 06 09','admin','1','  General','  Cash','1150.00','1150.00','74',NULL,NULL,NULL,NULL,'09 Jun 2023','2023060913:25:36','%','0','800.00','no','0.00',NULL,'202306091325','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(50,'RG 6 CCU 96','3.0','1150.00','3450.00','Item',NULL,NULL,'no',NULL,NULL,'20230609-000013','04:09:25 PM','2023 06 09','admin','1','  General','  Cash','5200.00','5200.00','80',NULL,NULL,NULL,NULL,'09 Jun 2023','2023060916:09:25','%','0','3450.00','no','0.00',NULL,'202306091609','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Everfocus','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(51,'V K REMOTE','50','35.00','1750.00','Item',NULL,NULL,'no',NULL,NULL,'20230609-000013','04:09:25 PM','2023 06 09','admin','1','  General','  Cash','5200.00','5200.00','81',NULL,NULL,NULL,NULL,'09 Jun 2023','2023060916:09:25','%','0','35.00','no','0.00',NULL,'202306091609','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CATV ACCESORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(52,'THICK CARD','5','12.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20230609-000014','04:37:55 PM','2023 06 09','admin','1','  General','  Cash','60.00','60.00','84',NULL,NULL,NULL,NULL,'09 Jun 2023','2023060916:37:55','%','0','12.00','no','0.00',NULL,'202306091637','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BIOMETRIC ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(53,'BNC WIRED','50','10.00','500.00','Item',NULL,NULL,'no',NULL,NULL,'20230609-000015','04:39:58 PM','2023 06 09','admin','1','  General','  Cash','600.00','600.00','85',NULL,NULL,NULL,NULL,'09 Jun 2023','2023060916:39:58','%','0','10.00','no','0.00',NULL,'202306091639','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(54,'DC CONNCETOR','20','5.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20230609-000015','04:39:58 PM','2023 06 09','admin','1','  General','  Cash','600.00','600.00','86',NULL,NULL,NULL,NULL,'09 Jun 2023','2023060916:39:58','%','0','5.00','no','0.00',NULL,'202306091639','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(55,'CAT6 /MTR','62','22.00','1364.00','Item',NULL,NULL,'no',NULL,NULL,'20230609-000016','04:46:54 PM','2023 06 09','admin','1','  General','  Cash','1464.00','1464.00','87',NULL,NULL,NULL,NULL,'09 Jun 2023','2023060916:46:54','%','0','22.00','no','0.00',NULL,'202306091646','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NETWORK ITEMS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(56,'SERVICE CHARGE','1.0','100','100.00','Item',NULL,NULL,'no',NULL,NULL,'20230609-000016','04:46:54 PM','2023 06 09','admin','1','  General','  Cash','1464.00','1464.00','89',NULL,NULL,NULL,NULL,'09 Jun 2023','2023060916:46:54','%','0','350.00','no','0.00',NULL,'202306091646','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SERVICE CHARGE','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(57,'SHARP POWER INSERTER','3.0','90.00','270.00','Item',NULL,NULL,'no',NULL,NULL,'20230609-000017','05:29:36 PM','2023 06 09','admin','1','  General','  Cash','1120.00','1120.00','92',NULL,NULL,NULL,NULL,'09 Jun 2023','2023060917:29:36','%','0','270.00','no','0.00',NULL,'202306091729','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(58,'TELVASS 8 OUT DC NODE','1.0','850.00','850.00','Item',NULL,NULL,'no',NULL,NULL,'20230609-000017','05:29:36 PM','2023 06 09','admin','1','  General','  Cash','1120.00','1120.00','93',NULL,NULL,NULL,NULL,'09 Jun 2023','2023060917:29:36','%','0','850.00','no','0.00',NULL,'202306091729','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TELVASS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(59,'VIDEO BALLOON','2.0','65.00','130.00','Item',NULL,NULL,'no',NULL,NULL,'20230609-000018','05:30:23 PM','2023 06 09','admin','1','  General','  Cash','162.00','162.00','95',NULL,NULL,NULL,NULL,'09 Jun 2023','2023060917:30:23','%','0','195.00','no','0.00',NULL,'202306091730','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(60,'4*4 PVC BOX','2.0','16.00','32.00','Item',NULL,NULL,'no',NULL,NULL,'20230609-000018','05:30:23 PM','2023 06 09','admin','1','  General','  Cash','162.00','162.00','96',NULL,NULL,NULL,NULL,'09 Jun 2023','2023060917:30:23','%','0','16.00','no','0.00',NULL,'202306091730','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(61,'RG6 CCU 128','1.0','1250.00','1250.00','Item',NULL,NULL,'no',NULL,NULL,'20230609-000019','06:19:32 PM','2023 06 09','admin','1','  General','  Cash','1250.00','1250.00','98',NULL,NULL,NULL,NULL,'09 Jun 2023','2023060918:19:32','%','0','1250.00','no','0.00',NULL,'202306091819','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Everfocus','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(62,'EVERFOCUS CAT5E O/D 305MTRS','1.0','4500.00','4500.00','Item',NULL,NULL,'no',NULL,NULL,'20230609-0000110','07:32:35 PM','2023 06 09','admin','1','  General','  Upiqr','4500.00','4500.00','101',NULL,NULL,NULL,NULL,'09 Jun 2023','2023060919:32:35','%','0','4500.00','no','0.00',NULL,'202306091932','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Everfocus','admin','madmin','0',NULL,'',NULL,NULL,'','','',''),(63,'EXIT SWITCH PLASTIC','1.0','150.00','150.00','Item',NULL,NULL,'no',NULL,NULL,'20230609-0000111','07:44:03 PM','2023 06 09','admin','1','  General','  Cash','150.00','150.00','102',NULL,NULL,NULL,NULL,'09 Jun 2023','2023060919:44:03','%','0','150.00','no','0.00',NULL,'202306091944','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BIOMETRIC ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(64,'EVERFOCUS 1+3 90 MTR','2.0','1000','2000.00','Item',NULL,NULL,'no',NULL,NULL,'20230610-000011','11:46:22 AM','2023 06 10','admin','1','  General','  Cash','2000.00','2000.00','104',NULL,NULL,NULL,NULL,'10 Jun 2023','2023061011:46:22','%','0','1900.00','no','0.00',NULL,'202306101146','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Everfocus','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(65,'CAT6 /MTR','30','25','750.00','Item',NULL,NULL,'no',NULL,NULL,'20230610-000012','12:12:06 PM','2023 06 10','admin','1','  General','  Cash','750.00','750.00','105',NULL,NULL,NULL,NULL,'10 Jun 2023','2023061012:12:06','%','0','22.00','no','0.00',NULL,'202306101212','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NETWORK ITEMS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(66,'RAJCAB RG59+3CORE','4.0','950.00','3800.00','Item',NULL,NULL,'no',NULL,NULL,'20230610-000013','12:12:57 PM','2023 06 10','admin','1','  General','  Cash','3800.00','3800.00','106',NULL,NULL,NULL,NULL,'10 Jun 2023','2023061012:12:57','%','0','3800.00','no','0.00',NULL,'202306101212','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(67,'THICK CARD','25','12.00','300.00','Item',NULL,NULL,'no',NULL,NULL,'20230610-000014','12:14:43 PM','2023 06 10','admin','1','  General','  Cash','300.00','300.00','107',NULL,NULL,NULL,NULL,'10 Jun 2023','2023061012:14:43','%','0','108.00','no','0.00',NULL,'202306101214','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BIOMETRIC ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(68,'DR.COM 4FIBER','2136.0','6','12816.00','Item',NULL,NULL,'no',NULL,NULL,'20230610-000015','12:29:41 PM','2023 06 10','admin','1','  General','  Cash','12816.00','12816.00','108',NULL,NULL,NULL,NULL,'10 Jun 2023','2023061012:29:41','%','0','7.00','no','0.00',NULL,'202306101229','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'DR COM FIBER','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(69,'US 16 AC NODE','1.0','1300.00','1300.00','Item',NULL,NULL,'no',NULL,NULL,'20230610-000016','02:41:28 PM','2023 06 10','admin','1','  General','  Cash','4750.00','4750.00','109',NULL,NULL,NULL,NULL,'10 Jun 2023','2023061014:41:28','%','0','1300.00','no','0.00',NULL,'202306101441','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UNITED SYSTEM','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(70,'RG 6 CCU 96','3.0','1150.00','3450.00','Item',NULL,NULL,'no',NULL,NULL,'20230610-000016','02:41:28 PM','2023 06 10','admin','1','  General','  Cash','4750.00','4750.00','112',NULL,NULL,NULL,NULL,'10 Jun 2023','2023061014:41:28','%','0','1150.00','no','0.00',NULL,'202306101441','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Everfocus','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(71,'HDMI EXTENDDER 30 MTRS','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20230612-000011','11:14:57 AM','2023 06 12','admin','1','  General','  Upiqr','1700.00','1700.00','116',NULL,NULL,NULL,NULL,'12 Jun 2023','2023061211:14:57','%','0','250.00','no','0.00',NULL,'202306121114','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin','0',NULL,'',NULL,NULL,'','','',''),(72,'USB EXTENDER 50 MTRS','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20230612-000011','11:14:57 AM','2023 06 12','admin','1','  General','  Upiqr','1700.00','1700.00','117',NULL,NULL,NULL,NULL,'12 Jun 2023','2023061211:14:57','%','0','250.00','no','0.00',NULL,'202306121114','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin','0',NULL,'',NULL,NULL,'','','',''),(73,'CAT6 /MTR','60','20','1200.00','Item',NULL,NULL,'no',NULL,NULL,'20230612-000011','11:14:57 AM','2023 06 12','admin','1','  General','  Upiqr','1700.00','1700.00','118',NULL,NULL,NULL,NULL,'12 Jun 2023','2023061211:14:57','%','0','22.00','no','0.00',NULL,'202306121114','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NETWORK ITEMS','admin','madmin','0',NULL,'',NULL,NULL,'','','',''),(74,'12 V 3 AMPS ADOPTER','3.0','300.00','900.00','Item',NULL,NULL,'no',NULL,NULL,'20230612-000012','11:31:53 AM','2023 06 12','admin','1','  General','  Cash','2770.00','2770.00','119',NULL,NULL,NULL,NULL,'12 Jun 2023','2023061211:31:53','%','0','900.00','no','0.00',NULL,'202306121131','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(75,'SHARP X PON ONU','2.0','800.00','1600.00','Item',NULL,NULL,'no',NULL,NULL,'20230612-000012','11:31:53 AM','2023 06 12','admin','1','  General','  Cash','2770.00','2770.00','120',NULL,NULL,NULL,NULL,'12 Jun 2023','2023061211:31:53','%','0','1600.00','no','0.00',NULL,'202306121131','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(76,'CAT 6 PATCH CORD 1 MTR','6.0','45.00','270.00','Item',NULL,NULL,'no',NULL,NULL,'20230612-000012','11:31:53 AM','2023 06 12','admin','1','  General','  Cash','2770.00','2770.00','121',NULL,NULL,NULL,NULL,'12 Jun 2023','2023061211:31:53','%','0','270.00','no','0.00',NULL,'202306121131','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NETWORK ITEMS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(77,'2 U RACK ','1.0','650.00','650.00','Item',NULL,NULL,'no',NULL,NULL,'20230612-000013','01:26:10 PM','2023 06 12','admin','1','  General','  Cash','650.00','650.00','122',NULL,NULL,NULL,NULL,'12 Jun 2023','2023061213:26:10','%','0','650.00','no','0.00',NULL,'202306121326','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(78,'SHARP OX724','1.0','1150.00','1150.00','Item',NULL,NULL,'no',NULL,NULL,'20230612-000014','03:53:43 PM','2023 06 12','admin','1','  General','  Cash','1150.00','1150.00','124',NULL,NULL,NULL,NULL,'12 Jun 2023','2023061215:53:43','%','0','1150.00','no','0.00',NULL,'202306121553','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'78452190592',NULL,NULL,'','','',''),(79,'4CH SMPS TELVASS','1.0','450','450.00','Item',NULL,NULL,'no',NULL,NULL,'20230612-000015','04:09:36 PM','2023 06 12','admin','1','  General','  Cash','450.00','450.00','128',NULL,NULL,NULL,NULL,'12 Jun 2023','2023061216:09:36','%','0','350.00','no','0.00',NULL,'202306121609','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(80,'EVERFOCUS RG6/100 COPPER 1 DRUM','1.0','3500.00','3500.00','Item',NULL,NULL,'no',NULL,NULL,'20230612-000016','07:01:37 PM','2023 06 12','admin','1','  General','  Cash','3500.00','3500.00','133',NULL,NULL,NULL,NULL,'12 Jun 2023','2023061219:01:37','%','0','3500.00','no','0.00',NULL,'202306121901','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Everfocus','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(81,'EVERFOCUS 1+3 90 MTR','1.0','1000','1000.00','Item',NULL,NULL,'no',NULL,NULL,'20230612-000017','07:02:54 PM','2023 06 12','admin','1','  General','  Cash','1000.00','1000.00','134',NULL,NULL,NULL,NULL,'12 Jun 2023','2023061219:02:54','%','0','950.00','no','0.00',NULL,'202306121902','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Everfocus','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(82,'2 WAY SPLITTER 2S1-I/D','5.0','45.00','225.00','Item',NULL,NULL,'no',NULL,NULL,'20230612-000018','07:10:00 PM','2023 06 12','admin','1','  General','  Cash','975.00','975.00','135',NULL,NULL,NULL,NULL,'12 Jun 2023','2023061219:10:00','%','0','2070.00','no','0.00',NULL,'202306121910','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(83,'3 WAY SPLITTER 3S1-I/D','5.0','50.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20230612-000018','07:10:00 PM','2023 06 12','admin','1','  General','  Cash','975.00','975.00','136',NULL,NULL,NULL,NULL,'12 Jun 2023','2023061219:10:00','%','0','250.00','no','0.00',NULL,'202306121910','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(84,'4 WAY SPLITTER 4S1-I/D','5.0','55.00','275.00','Item',NULL,NULL,'no',NULL,NULL,'20230612-000018','07:10:00 PM','2023 06 12','admin','1','  General','  Cash','975.00','975.00','137',NULL,NULL,NULL,NULL,'12 Jun 2023','2023061219:10:00','%','0','275.00','no','0.00',NULL,'202306121910','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(85,'VX F5 CONNECTOR','50.0','5','250.00','Item',NULL,NULL,'no',NULL,NULL,'20230612-000018','07:10:00 PM','2023 06 12','admin','1','  General','  Cash','975.00','975.00','138',NULL,NULL,NULL,NULL,'12 Jun 2023','2023061219:10:00','₹','0.50','225.00','yes','25.00',NULL,'202306121910','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(86,'EVERFOCUS RG6/100 COPPER 1 DRUM','1.0','3500.00','3500.00','Item',NULL,NULL,'no',NULL,NULL,'20230612-000019','07:19:09 PM','2023 06 12','admin','1','  General','  Cash','6580.00','6580.00','140',NULL,NULL,NULL,NULL,'12 Jun 2023','2023061219:19:09','%','0','3500.00','no','0.00',NULL,'202306121919','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Everfocus','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(87,'SHARP PSP 12V','4.0','80.00','320.00','Item',NULL,NULL,'no',NULL,NULL,'20230612-000019','07:19:09 PM','2023 06 12','admin','1','  General','  Cash','6580.00','6580.00','141',NULL,NULL,NULL,NULL,'12 Jun 2023','2023061219:19:09','%','0','320.00','no','0.00',NULL,'202306121919','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(88,'2 WAY SPLITTER 2S1','3.0','65.00','195.00','Item',NULL,NULL,'no',NULL,NULL,'20230612-000019','07:19:09 PM','2023 06 12','admin','1','  General','  Cash','6580.00','6580.00','142',NULL,NULL,NULL,NULL,'12 Jun 2023','2023061219:19:09','%','0','195.00','no','0.00',NULL,'202306121919','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(89,'3WAY SPLITTER 3S1','3.0','70.00','210.00','Item',NULL,NULL,'no',NULL,NULL,'20230612-000019','07:19:09 PM','2023 06 12','admin','1','  General','  Cash','6580.00','6580.00','143',NULL,NULL,NULL,NULL,'12 Jun 2023','2023061219:19:09','%','0','280.00','no','0.00',NULL,'202306121919','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(90,'4WAY SPLITTER 4S1','3.0','75.00','225.00','Item',NULL,NULL,'no',NULL,NULL,'20230612-000019','07:19:09 PM','2023 06 12','admin','1','  General','  Cash','6580.00','6580.00','144',NULL,NULL,NULL,NULL,'12 Jun 2023','2023061219:19:09','%','0','675.00','no','0.00',NULL,'202306121919','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(91,'SHARP  1WAY TAPOFF','3.0','65.00','195.00','Item',NULL,NULL,'no',NULL,NULL,'20230612-000019','07:19:09 PM','2023 06 12','admin','1','  General','  Cash','6580.00','6580.00','146',NULL,NULL,NULL,NULL,'12 Jun 2023','2023061219:19:09','%','0','195.00','no','0.00',NULL,'202306121919','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(92,'SHARP  2WAY TAPOFF','3.0','70.00','210.00','Item',NULL,NULL,'no',NULL,NULL,'20230612-000019','07:19:09 PM','2023 06 12','admin','1','  General','  Cash','6580.00','6580.00','147',NULL,NULL,NULL,NULL,'12 Jun 2023','2023061219:19:09','%','0','210.00','no','0.00',NULL,'202306121919','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(93,'SHARP  3WAY TAPOFF','3.0','75.00','225.00','Item',NULL,NULL,'no',NULL,NULL,'20230612-000019','07:19:09 PM','2023 06 12','admin','1','  General','  Cash','6580.00','6580.00','148',NULL,NULL,NULL,NULL,'12 Jun 2023','2023061219:19:09','%','0','225.00','no','0.00',NULL,'202306121919','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(94,'SHARP I/D  4WAY SPLITTER 4S','20.0','70','1400.00','Item',NULL,NULL,'no',NULL,NULL,'20230612-000019','07:19:09 PM','2023 06 12','admin','1','  General','  Cash','6580.00','6580.00','149',NULL,NULL,NULL,NULL,'12 Jun 2023','2023061219:19:09','%','0','1500.00','no','0.00',NULL,'202306121919','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(95,'INSTALLATION TAPE','10.0','10.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20230612-000019','07:19:09 PM','2023 06 12','admin','1','  General','  Cash','6580.00','6580.00','150',NULL,NULL,NULL,NULL,'12 Jun 2023','2023061219:19:09','%','0','100.00','no','0.00',NULL,'202306121919','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(96,'2 U RACK ','1.0','650.00','650.00','Item',NULL,NULL,'no',NULL,NULL,'20230612-0000110','07:30:41 PM','2023 06 12','admin','1','  General','  Cash','650.00','650.00','151',NULL,NULL,NULL,NULL,'12 Jun 2023','2023061219:30:41','%','0','650.00','no','0.00',NULL,'202306121930','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(98,'2 U MINI RACK','1.0','650.00','650.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-000012','12:59:33 PM','2023 06 13','admin','1','  General','  Upiqr','650.00','650.00','153',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061312:59:33','%','0','650.00','no','0.00',NULL,'202306131259','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin','0',NULL,'',NULL,NULL,'','','',''),(99,'FTTH BOX','2.0','30.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-000013','04:01:50 PM','2023 06 13','admin','1','  General','  Cash','660.00','660.00','154',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061316:01:50','%','0','60.00','no','0.00',NULL,'202306131601','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CATV ACCESORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(100,'CCTV MIC','2.0','200.00','400.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-000013','04:01:50 PM','2023 06 13','admin','1','  General','  Cash','660.00','660.00','155',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061316:01:50','%','0','400.00','no','0.00',NULL,'202306131601','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(101,'R C A PIN','4.0','20.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-000013','04:01:50 PM','2023 06 13','admin','1','  General','  Cash','660.00','660.00','156',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061316:01:50','%','0','80.00','no','0.00',NULL,'202306131601','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(102,'SC TO SC PATCH CORD','2.0','60.00','120.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-000013','04:01:50 PM','2023 06 13','admin','1','  General','  Cash','660.00','660.00','157',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061316:01:50','%','0','120.00','no','0.00',NULL,'202306131601','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NETWORK ITEMS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(103,'E / F RG6 DRUM CCU 100 PER','1.0','3500.00','3500.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-000014','04:15:25 PM','2023 06 13','admin','1','  General','  Cash','17220.00','17220.00','162',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061316:15:25','%','0','3500.00','no','0.00',NULL,'202306131615','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Everfocus','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(104,'E / F RG6 DRUM CCU 98 PER','2.0','3250.00','6500.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-000014','04:15:25 PM','2023 06 13','admin','1','  General','  Cash','17220.00','17220.00','163',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061316:15:25','%','0','6500.00','no','0.00',NULL,'202306131615','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Everfocus','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(105,'SHARP OX724','4.0','1150.00','4600.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-000014','04:15:25 PM','2023 06 13','admin','1','  General','  Cash','17220.00','17220.00','164',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061316:15:25','%','0','4600.00','no','0.00',NULL,'202306131615','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'78452190592',NULL,NULL,'','','',''),(106,'SHARP 40 V DC P.SUPPLY','2.0','380','760.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-000014','04:15:25 PM','2023 06 13','admin','1','  General','  Cash','17220.00','17220.00','165',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061316:15:25','%','0','780.00','no','0.00',NULL,'202306131615','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(107,'2 WAY SPLITTER 2S1','7.0','65.00','455.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-000014','04:15:25 PM','2023 06 13','admin','1','  General','  Cash','17220.00','17220.00','166',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061316:15:25','%','0','455.00','no','0.00',NULL,'202306131615','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(108,'3WAY SPLITTER 3S1','5.0','70.00','350.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-000014','04:15:25 PM','2023 06 13','admin','1','  General','  Cash','17220.00','17220.00','167',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061316:15:25','%','0','350.00','no','0.00',NULL,'202306131615','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(109,'4WAY SPLITTER 4S1','5.0','75.00','375.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-000014','04:15:25 PM','2023 06 13','admin','1','  General','  Cash','17220.00','17220.00','168',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061316:15:25','%','0','375.00','no','0.00',NULL,'202306131615','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(110,'VX I JOINTER','10.0','10.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-000014','04:15:25 PM','2023 06 13','admin','1','  General','  Cash','17220.00','17220.00','169',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061316:15:25','%','0','100.00','no','0.00',NULL,'202306131615','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CATV ACCESORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(111,'S R F5 CONNECTOR PACK','1.0','450.00','450.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-000014','04:15:25 PM','2023 06 13','admin','1','  General','  Cash','17220.00','17220.00','170',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061316:15:25','%','0','450.00','no','0.00',NULL,'202306131615','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CATV ACCESORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(112,'F RING PACK','2.0','40.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-000014','04:15:25 PM','2023 06 13','admin','1','  General','  Cash','17220.00','17220.00','171',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061316:15:25','%','0','80.00','no','0.00',NULL,'202306131615','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CATV ACCESORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(113,'INSTALLATION TAPE','5.0','10.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-000014','04:15:25 PM','2023 06 13','admin','1','  General','  Cash','17220.00','17220.00','172',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061316:15:25','%','0','50.00','no','0.00',NULL,'202306131615','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(114,'KING COM HD.MI 35 MTR','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-000015','04:17:05 PM','2023 06 13','admin','1','  General','  Cash','250.00','250.00','173',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061316:17:05','%','0','250.00','no','0.00',NULL,'202306131617','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(115,'RG6 CCS 90 mtrs','1.0','600.00','600.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-000016','04:18:54 PM','2023 06 13','admin','1','  General','  Cash','870.00','870.00','174',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061316:18:54','%','0','600.00','no','0.00',NULL,'202306131618','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(116,'2 WAY SPLITTER 2S1','2.0','65.00','130.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-000016','04:18:54 PM','2023 06 13','admin','1','  General','  Cash','870.00','870.00','175',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061316:18:54','%','0','130.00','no','0.00',NULL,'202306131618','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(117,'3WAY SPLITTER 3S1','2.0','70.00','140.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-000016','04:18:54 PM','2023 06 13','admin','1','  General','  Cash','870.00','870.00','176',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061316:18:54','%','0','140.00','no','0.00',NULL,'202306131618','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(118,'SHARP OX724','1.0','1150.00','1150.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-000017','04:21:27 PM','2023 06 13','admin','1','  General','  Cash','2200.00','2200.00','177',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061316:21:27','%','0','1150.00','no','0.00',NULL,'202306131621','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'78452190592',NULL,NULL,'','','',''),(119,'SHARP 12  V POC','15.0','70.00','1050.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-000017','04:21:27 PM','2023 06 13','admin','1','  General','  Cash','2200.00','2200.00','178',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061316:21:27','%','0','1050.00','no','0.00',NULL,'202306131621','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(120,'UNITED SYSTEM DC NODE 4 OUT ','3.0','850.00','2550.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-000018','04:25:41 PM','2023 06 13','admin','1','  General','  Cash','3750.00','3750.00','179',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061316:25:41','%','0','2550.00','no','0.00',NULL,'202306131625','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UNITED SYSTEM','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(121,'2 WAY SPLITTER 2S1','20.0','60','1200.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-000018','04:25:41 PM','2023 06 13','admin','1','  General','  Cash','3750.00','3750.00','180',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061316:25:41','%','0','65.00','no','0.00',NULL,'202306131625','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(122,'4.U RACK 350 DEPTH','1.0','1000.00','1000.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-000019','04:47:03 PM','2023 06 13','admin','1','  General','  Cash','1000.00','1000.00','182',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061316:47:03','%','0','1000.00','no','0.00',NULL,'202306131647','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(123,'SERVICE CHARGE','1.0','200','200.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-0000110','06:11:25 PM','2023 06 13','admin','1','  General','  Cash','200.00','200.00','185',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061318:11:25','%','0','350.00','no','0.00',NULL,'202306131811','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SERVICE CHARGE','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(124,'TELEPHONE LINE CORD 1 MTR','5.0','15.00','75.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-0000111','06:15:43 PM','2023 06 13','admin','1','  General','  Cash','135.00','135.00','186',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061318:15:43','%','0','75.00','no','0.00',NULL,'202306131815','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TELEPHONE ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(125,'TELEPHONE LINE CORD 5 MTR','1.0','60.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-0000111','06:15:43 PM','2023 06 13','admin','1','  General','  Cash','135.00','135.00','187',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061318:15:43','%','0','60.00','no','0.00',NULL,'202306131815','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TELEPHONE ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(126,'RG6 CCS 90 mtrs','1.0','600.00','600.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-0000112','06:18:34 PM','2023 06 13','admin','1','  General','  Cash','980.00','980.00','188',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061318:18:34','%','0','600.00','no','0.00',NULL,'202306131818','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(127,'2 WAY SPLITTER 2S1-I/D','2.0','45.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-0000112','06:18:34 PM','2023 06 13','admin','1','  General','  Cash','980.00','980.00','189',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061318:18:34','%','0','90.00','no','0.00',NULL,'202306131818','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(128,'3 WAY SPLITTER 3S1-I/D','2.0','50.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-0000112','06:18:34 PM','2023 06 13','admin','1','  General','  Cash','980.00','980.00','190',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061318:18:34','%','0','100.00','no','0.00',NULL,'202306131818','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(129,'4 WAY SPLITTER 4S1-I/D','2.0','55.00','110.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-0000112','06:18:34 PM','2023 06 13','admin','1','  General','  Cash','980.00','980.00','191',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061318:18:34','%','0','110.00','no','0.00',NULL,'202306131818','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(130,'RG6 RING 1 PACKET','2.0','40.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-0000112','06:18:34 PM','2023 06 13','admin','1','  General','  Cash','980.00','980.00','192',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061318:18:34','%','0','80.00','no','0.00',NULL,'202306131818','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(131,'LMB 200 CABLE','3.0','350.00','1050.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-0000113','06:29:34 PM','2023 06 13','admin','1','  General','  Cash','1050.00','1050.00','194',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061318:29:34','%','0','1050.00','no','0.00',NULL,'202306131829','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NETWORK ITEMS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(132,'NET LINK DIFFERENCE AMOUNT','1.0','200.00','200.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-0000114','06:32:16 PM','2023 06 13','admin','1','  General','  Cash','200.00','200.00','195',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061318:32:16','%','0','200.00','no','0.00',NULL,'202306131832','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(133,'4 WAY BAMBOO BIG','1.0','1200.00','1200.00','Item',NULL,NULL,'no',NULL,NULL,'20230613-0000115','07:18:18 PM','2023 06 13','admin','1','  General','  Cash','1200.00','1200.00','196',NULL,NULL,NULL,NULL,'13 Jun 2023','2023061319:18:18','%','0','1200.00','no','0.00',NULL,'202306131918','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CATV ACCESORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(134,'KINGCOM HDMI 3 MTRS','2.0','240.00','480.00','Item',NULL,NULL,'no',NULL,NULL,'20230614-000011','10:14:52 AM','2023 06 14','admin','1','  General','  Cash','480.00','480.00','203',NULL,NULL,NULL,NULL,'14 Jun 2023','2023061410:14:52','%','0','480.00','no','0.00',NULL,'202306141014','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(135,'RG 6 CCU 96','2.0','1150.00','2300.00','Item',NULL,NULL,'no',NULL,NULL,'20230614-000012','10:19:12 AM','2023 06 14','admin','1','  General','  Cash','2250.00','2250.00','205',NULL,NULL,NULL,NULL,'14 Jun 2023','2023061410:19:12','₹','25','2250.00','yes','50.00',NULL,'202306141019','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Everfocus','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(136,'TIP SPRAY 200 ML','1.0','60.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20230614-000013','02:36:39 PM','2023 06 14','admin','1','  General','  Cash','60.00','60.00','208',NULL,NULL,NULL,NULL,'14 Jun 2023','2023061414:36:39','%','0','60.00','no','0.00',NULL,'202306141436','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(137,'SERVICE CHARGE','1.0','300','300.00','Item',NULL,NULL,'no',NULL,NULL,'20230614-000014','05:10:47 PM','2023 06 14','admin','1','  General','  Cash','300.00','300.00','209',NULL,NULL,NULL,NULL,'14 Jun 2023','2023061417:10:47','%','0','350.00','no','0.00',NULL,'202306141710','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SERVICE CHARGE','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(138,'4WAY SPLITTER 4S1','3.0','75.00','225.00','Item',NULL,NULL,'no',NULL,NULL,'20230614-000015','07:09:21 PM','2023 06 14','admin','1','  General','  Cash','1030.00','1030.00','210',NULL,NULL,NULL,NULL,'14 Jun 2023','2023061419:09:21','%','0','225.00','no','0.00',NULL,'202306141909','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(139,'3WAY SPLITTER 3S1','3.0','70.00','210.00','Item',NULL,NULL,'no',NULL,NULL,'20230614-000015','07:09:21 PM','2023 06 14','admin','1','  General','  Cash','1030.00','1030.00','211',NULL,NULL,NULL,NULL,'14 Jun 2023','2023061419:09:21','%','0','210.00','no','0.00',NULL,'202306141909','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(140,'2 WAY SPLITTER 2S1','3.0','65.00','195.00','Item',NULL,NULL,'no',NULL,NULL,'20230614-000015','07:09:21 PM','2023 06 14','admin','1','  General','  Cash','1030.00','1030.00','212',NULL,NULL,NULL,NULL,'14 Jun 2023','2023061419:09:21','%','0','195.00','no','0.00',NULL,'202306141909','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(141,'SHARP  2WAY TAPOFF','2.0','70.00','140.00','Item',NULL,NULL,'no',NULL,NULL,'20230614-000015','07:09:21 PM','2023 06 14','admin','1','  General','  Cash','1030.00','1030.00','213',NULL,NULL,NULL,NULL,'14 Jun 2023','2023061419:09:21','%','0','140.00','no','0.00',NULL,'202306141909','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(142,'VX I JOINTER','10.00','10.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20230614-000015','07:09:21 PM','2023 06 14','admin','1','  General','  Cash','1030.00','1030.00','215',NULL,NULL,NULL,NULL,'14 Jun 2023','2023061419:09:21','%','0','110.00','no','0.00',NULL,'202306141909','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CATV ACCESORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(143,'SHARP  4WAY TAPOFF','2.0','80.00','160.00','Item',NULL,NULL,'no',NULL,NULL,'20230614-000015','07:09:21 PM','2023 06 14','admin','1','  General','  Cash','1030.00','1030.00','219',NULL,NULL,NULL,NULL,'14 Jun 2023','2023061419:09:21','%','0','160.00','no','0.00',NULL,'202306141909','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(144,'CAT6  10 MTR','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20230614-000016','07:14:01 PM','2023 06 14','admin','1','  General','  Cash','250.00','250.00','223',NULL,NULL,NULL,NULL,'14 Jun 2023','2023061419:14:01','%','0','250.00','no','0.00',NULL,'202306141914','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NETWORK ITEMS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(145,'4*4 PVC BOX','4.0','16.00','64.00','Item',NULL,NULL,'no',NULL,NULL,'20230614-000017','07:16:23 PM','2023 06 14','admin','1','  General','  Cash','419.00','419.00','224',NULL,NULL,NULL,NULL,'14 Jun 2023','2023061419:16:23','%','0','64.00','no','0.00',NULL,'202306141916','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(146,'DC CONNCETOR','5.0','6','30.00','Item',NULL,NULL,'no',NULL,NULL,'20230614-000017','07:16:23 PM','2023 06 14','admin','1','  General','  Cash','419.00','419.00','226',NULL,NULL,NULL,NULL,'14 Jun 2023','2023061419:16:23','%','0','5.00','no','0.00',NULL,'202306141916','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(147,'VIDEO BALLOON','5.0','65.00','325.00','Item',NULL,NULL,'no',NULL,NULL,'20230614-000017','07:16:23 PM','2023 06 14','admin','1','  General','  Cash','419.00','419.00','227',NULL,NULL,NULL,NULL,'14 Jun 2023','2023061419:16:23','%','0','325.00','no','0.00',NULL,'202306141916','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(148,'SHARP 12  V POC','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20230615-000011','02:47:58 PM','2023 06 15','admin','1','  Home delivery','  Cash','145.00','145.00','228',NULL,NULL,NULL,NULL,'15 Jun 2023','2023061514:47:58','%','0','70.00','no','0.00',NULL,'202306151447','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(149,'3 WAY SPLITTER 3S1-I/D','1.0','75','75.00','Item',NULL,NULL,'no',NULL,NULL,'20230615-000011','02:47:58 PM','2023 06 15','admin','1','  Home delivery','  Cash','145.00','145.00','229',NULL,NULL,NULL,NULL,'15 Jun 2023','2023061514:47:58','%','0','50.00','no','0.00',NULL,'202306151447','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(150,'2 WAY SPLITTER 2S1','20','50','1000.00','Item',NULL,NULL,'no',NULL,NULL,'20230615-000012','02:49:42 PM','2023 06 15','admin','1','  General','  Cash','1000.00','1000.00','230',NULL,NULL,NULL,NULL,'15 Jun 2023','2023061514:49:42','%','0','65.00','no','0.00',NULL,'202306151449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(151,'BNC WIRED','6.0','15','90.00','Item',NULL,NULL,'no',NULL,NULL,'20230615-000013','02:53:19 PM','2023 06 15','admin','1','  General','  Cash','838.00','838.00','231',NULL,NULL,NULL,NULL,'15 Jun 2023','2023061514:53:19','%','0','10.00','no','0.00',NULL,'202306151453','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(152,'DC CONNCETOR','6.0','8','48.00','Item',NULL,NULL,'no',NULL,NULL,'20230615-000013','02:53:19 PM','2023 06 15','admin','1','  General','  Cash','838.00','838.00','232',NULL,NULL,NULL,NULL,'15 Jun 2023','2023061514:53:19','%','0','5.00','no','0.00',NULL,'202306151453','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(153,'SERVICE CHARGES','1.0','700','700.00','Item',NULL,NULL,'no',NULL,NULL,'20230615-000013','02:53:19 PM','2023 06 15','admin','1','  General','  Cash','838.00','838.00','233',NULL,NULL,NULL,NULL,'15 Jun 2023','2023061514:53:19','%','0','400.00','no','0.00',NULL,'202306151453','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SERVICE CHARGE','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(154,'JC BOX 2 WAY BIG','2.0','45.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20230615-000014','02:54:07 PM','2023 06 15','admin','1','  General','  Cash','90.00','90.00','234',NULL,NULL,NULL,NULL,'15 Jun 2023','2023061514:54:07','%','0','90.00','no','0.00',NULL,'202306151454','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CATV ACCESORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(155,'SERVICE CHARGE','1.0','750','750.00','Item',NULL,NULL,'no',NULL,NULL,'20230615-000015','06:44:41 PM','2023 06 15','admin','1','  General','  Cash','750.00','750.00','235',NULL,NULL,NULL,NULL,'15 Jun 2023','2023061518:44:41','%','0','350.00','no','0.00',NULL,'202306151844','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SERVICE CHARGE','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(156,'RG6 CCS 90 Mtrs','1.0','600.00','600.00','Item',NULL,NULL,'no',NULL,NULL,'20230615-000016','06:46:56 PM','2023 06 15','admin','1','  General','  Cash','600.00','600.00','237',NULL,NULL,NULL,NULL,'15 Jun 2023','2023061518:46:56','%','0','600.00','no','0.00',NULL,'202306151846','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Everfocus','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(157,'CAT6 /MTR','26.0','22.00','572.00','Item',NULL,NULL,'no',NULL,NULL,'20230616-000011','11:03:59 AM','2023 06 16','admin','1','  General','  Cash','520.00','520.00','240',NULL,NULL,NULL,NULL,'16 Jun 2023','2023061611:03:59','₹','2','520.00','yes','52.00',NULL,'202306161103','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NETWORK ITEMS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(158,'IFOCUSS BNC','16.0','18','288.00','Item',NULL,NULL,'no',NULL,NULL,'20230616-000012','01:37:15 PM','2023 06 16','admin','1','  General','  Cash','350.00','350.00','241',NULL,NULL,NULL,NULL,'16 Jun 2023','2023061613:37:15','%','0','320.00','no','0.00',NULL,'202306161337','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(159,'DC CONNCETOR','8.0','8','64.00','Item',NULL,NULL,'no',NULL,NULL,'20230616-000012','01:37:15 PM','2023 06 16','admin','1','  General','  Cash','350.00','350.00','242',NULL,NULL,NULL,NULL,'16 Jun 2023','2023061613:37:15','₹','.25','62.00','yes','2.00',NULL,'202306161337','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(160,'IFOCUSS BNC','10.0','18','180.00','Item',NULL,NULL,'no',NULL,NULL,'20230616-000013','04:16:46 PM','2023 06 16','admin','1','  General','  Cash','220.00','220.00','243',NULL,NULL,NULL,NULL,'16 Jun 2023','2023061616:16:46','%','0','200.00','no','0.00',NULL,'202306161616','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(161,'DC CONNCETOR','5.0','8','40.00','Item',NULL,NULL,'no',NULL,NULL,'20230616-000013','04:16:46 PM','2023 06 16','admin','1','  General','  Cash','220.00','220.00','244',NULL,NULL,NULL,NULL,'16 Jun 2023','2023061616:16:46','%','0','30.00','no','0.00',NULL,'202306161616','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(162,'NETLINK 323RGW','1.0','1700','1700.00','Item',NULL,NULL,'no',NULL,NULL,'20230616-000014','06:42:58 PM','2023 06 16','admin','1','  General','  Cash','1760.00','1760.00','247',NULL,NULL,NULL,NULL,'16 Jun 2023','2023061618:42:58','%','0','1750.00','no','0.00',NULL,'202306161842','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NETLINK','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(163,'US OPTICAL PATCH CORD BLUE','1.0','60','60.00','Item',NULL,NULL,'no',NULL,NULL,'20230616-000014','06:42:58 PM','2023 06 16','admin','1','  General','  Cash','1760.00','1760.00','248',NULL,NULL,NULL,NULL,'16 Jun 2023','2023061618:42:58','%','0','65.00','no','0.00',NULL,'202306161842','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UNITED SYSTEM','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(164,'F TO F CONNECTOR','100','9','900.00','Item',NULL,NULL,'no',NULL,NULL,'20230616-000015','06:51:07 PM','2023 06 16','admin','1','  General','  Cash','2300.00','2300.00','250',NULL,NULL,NULL,NULL,'16 Jun 2023','2023061618:51:07','%','0','240.00','no','0.00',NULL,'202306161851','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CATV ACCESORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(165,'S R F5 CONNECTOR PACK','1.0','450.00','450.00','Item',NULL,NULL,'no',NULL,NULL,'20230616-000015','06:51:07 PM','2023 06 16','admin','1','  General','  Cash','2300.00','2300.00','251',NULL,NULL,NULL,NULL,'16 Jun 2023','2023061618:51:07','%','0','450.00','no','0.00',NULL,'202306161851','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CATV ACCESORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(166,'F RING PACK','4.0','40.00','160.00','Item',NULL,NULL,'no',NULL,NULL,'20230616-000015','06:51:07 PM','2023 06 16','admin','1','  General','  Cash','2300.00','2300.00','252',NULL,NULL,NULL,NULL,'16 Jun 2023','2023061618:51:07','%','0','160.00','no','0.00',NULL,'202306161851','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CATV ACCESORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(167,'JC BOX 2 WAY SMALL','20.0','30.00','600.00','Item',NULL,NULL,'no',NULL,NULL,'20230616-000015','06:51:07 PM','2023 06 16','admin','1','  General','  Cash','2300.00','2300.00','253',NULL,NULL,NULL,NULL,'16 Jun 2023','2023061618:51:07','%','0','600.00','no','0.00',NULL,'202306161851','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CATV ACCESORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(168,'SC TO LC PATCH CORD','1.0','190','190.00','Item',NULL,NULL,'no',NULL,NULL,'20230616-000015','06:51:07 PM','2023 06 16','admin','1','  General','  Cash','2300.00','2300.00','254',NULL,NULL,NULL,NULL,'16 Jun 2023','2023061618:51:07','%','0','180.00','no','0.00',NULL,'202306161851','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CATV ACCESORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(169,'8CH ERD POWER SUPPLY','1.0','780.00','780.00','Item',NULL,NULL,'no',NULL,NULL,'20230616-000016','06:53:26 PM','2023 06 16','admin','1','  General','  Cash','780.00','780.00','256',NULL,NULL,NULL,NULL,'16 Jun 2023','2023061618:53:26','%','0','780.00','no','0.00',NULL,'202306161853','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(170,'VIDEO BALLOON 5MP','8.0','110.00','880.00','Item',NULL,NULL,'no',NULL,NULL,'20230616-000017','06:59:20 PM','2023 06 16','admin','1','  General','  Cash','720.00','720.00','258',NULL,NULL,NULL,NULL,'16 Jun 2023','2023061618:59:20','₹','23','696.00','yes','184.00',NULL,'202306161859','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(171,'DC CONNCETOR','3.0','8','24.00','Item',NULL,NULL,'no',NULL,NULL,'20230616-000017','06:59:20 PM','2023 06 16','admin','1','  General','  Cash','720.00','720.00','259',NULL,NULL,NULL,NULL,'16 Jun 2023','2023061618:59:20','%','0','15.00','no','0.00',NULL,'202306161859','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(172,'SERVICE CHARGES','1.0','400.00','400.00','Item',NULL,NULL,'no',NULL,NULL,'20230616-000018','06:59:59 PM','2023 06 16','admin','1','  General','  Cash','400.00','400.00','260',NULL,NULL,NULL,NULL,'16 Jun 2023','2023061618:59:59','%','0','400.00','no','0.00',NULL,'202306161859','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SERVICE CHARGE','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(173,'EVERFOCUS RG6/100 COPPER 1 DRUM','1.0','3500.00','3500.00','Item',NULL,NULL,'no',NULL,NULL,'20230616-000019','07:00:34 PM','2023 06 16','admin','1','  General','  Cash','3500.00','3500.00','261',NULL,NULL,NULL,NULL,'16 Jun 2023','2023061619:00:34','%','0','3500.00','no','0.00',NULL,'202306161900','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Everfocus','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(175,'SERVICE CHARGE','1.0','300','300.00','Item',NULL,NULL,'no',NULL,NULL,'20230616-0000111','07:11:33 PM','2023 06 16','admin','1','  General','  Cash','300.00','300.00','263',NULL,NULL,NULL,NULL,'16 Jun 2023','2023061619:11:33','%','0','350.00','no','0.00',NULL,'202306161911','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SERVICE CHARGE','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(177,'NETLINK 323 DAC','1.0','2800','2800.00','Item',NULL,NULL,'no',NULL,NULL,'20230617-000012','04:02:08 PM','2023 06 17','admin','1','  General','  Upiqr','2800.00','2800.00','273',NULL,NULL,NULL,NULL,'17 Jun 2023','2023061716:02:08','%','0','2500.00','no','0.00',NULL,'202306171602','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NETLINK','admin','madmin','0',NULL,'',NULL,NULL,'','','',''),(178,'POE BOX LARGE','2.0','500.00','1000.00','Item',NULL,NULL,'no',NULL,NULL,'20230619-000011','08:26:46 PM','2023 06 19','admin','1','  General','  Cash','1000.00','1000.00','275',NULL,NULL,NULL,NULL,'19 Jun 2023','2023061920:26:46','%','0','500.00','no','0.00',NULL,'202306192026','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(179,'IFOCUSS BNC','5.0','50','250.00','Item',NULL,NULL,'no',NULL,NULL,'20230619-000012','08:27:39 PM','2023 06 19','admin','1','  General','  Cash','250.00','250.00','276',NULL,NULL,NULL,NULL,'19 Jun 2023','2023061920:27:39','%','0','20.00','no','0.00',NULL,'202306192027','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(180,'RG 6 CCU 90 ','1.0','1000.00','1000.00','Item',NULL,NULL,'no',NULL,NULL,'20230619-000013','08:28:50 PM','2023 06 19','admin','1','  General','  Cash','1000.00','1000.00','277',NULL,NULL,NULL,NULL,'19 Jun 2023','2023061920:28:50','%','0','1000.00','no','0.00',NULL,'202306192028','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Everfocus','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(181,'4*4 PVC BOX','10.0','20','200.00','Item',NULL,NULL,'no',NULL,NULL,'20230619-000014','08:29:45 PM','2023 06 19','admin','1','  General','  Cash','200.00','200.00','278',NULL,NULL,NULL,NULL,'19 Jun 2023','2023061920:29:45','%','0','160.00','no','0.00',NULL,'202306192029','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(182,'DC CONNCETOR','100.0','6','600.00','Item',NULL,NULL,'no',NULL,NULL,'20230619-000015','08:31:12 PM','2023 06 19','admin','1','  General','  Cash','590.00','590.00','279',NULL,NULL,NULL,NULL,'19 Jun 2023','2023061920:31:12','₹','.10','590.00','yes','10.00',NULL,'202306192031','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(183,'SHARP  4WAY TAPOFF','1.0','60','60.00','Item',NULL,NULL,'no',NULL,NULL,'20230619-000016','08:32:26 PM','2023 06 19','admin','1','  General','  Cash','110.00','110.00','282',NULL,NULL,NULL,NULL,'19 Jun 2023','2023061920:32:26','%','0','160.00','no','0.00',NULL,'202306192032','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(184,'SHARP  2WAY TAPOFF','1.0','50','50.00','Item',NULL,NULL,'no',NULL,NULL,'20230619-000016','08:32:26 PM','2023 06 19','admin','1','  General','  Cash','110.00','110.00','283',NULL,NULL,NULL,NULL,'19 Jun 2023','2023061920:32:26','%','0','70.00','no','0.00',NULL,'202306192032','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(185,'C CLIP','2.0','120.00','240.00','Item',NULL,NULL,'no',NULL,NULL,'20230619-000017','08:35:54 PM','2023 06 19','admin','1','  General','  Cash','240.00','240.00','284',NULL,NULL,NULL,NULL,'19 Jun 2023','2023061920:35:54','%','0','120.00','no','0.00',NULL,'202306192035','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(186,'HDMI 1 MTRS','16.0','25.00','400.00','Item',NULL,NULL,'no',NULL,NULL,'20230619-000018','08:36:22 PM','2023 06 19','admin','1','  General','  Cash','400.00','400.00','285',NULL,NULL,NULL,NULL,'19 Jun 2023','2023061920:36:22','%','0','25.00','no','0.00',NULL,'202306192036','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(187,'2 WAY SPLITTER 2S1-I/D','3.0','45.00','135.00','Item',NULL,NULL,'no',NULL,NULL,'20230620-000011','12:41:37 PM','2023 06 20','admin','1','  General','  Cash','395.00','395.00','286',NULL,NULL,NULL,NULL,'20 Jun 2023','2023062012:41:37','%','0','45.00','no','0.00',NULL,'202306201241','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(188,'2 WAY SPLITTER 2S1','4.0','65.00','260.00','Item',NULL,NULL,'no',NULL,NULL,'20230620-000011','12:41:37 PM','2023 06 20','admin','1','  General','  Cash','395.00','395.00','287',NULL,NULL,NULL,NULL,'20 Jun 2023','2023062012:41:37','%','0','65.00','no','0.00',NULL,'202306201241','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(189,'2 WAY SPLITTER 2S1','5.0','65.00','325.00','Item',NULL,NULL,'no',NULL,NULL,'20230620-000012','12:46:02 PM','2023 06 20','admin','1','  General','  Cash','370.00','370.00','288',NULL,NULL,NULL,NULL,'20 Jun 2023','2023062012:46:02','%','0','65.00','no','0.00',NULL,'202306201246','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(190,'2 WAY SPLITTER 2S1-I/D','1.0','45.00','45.00','Item',NULL,NULL,'no',NULL,NULL,'20230620-000012','12:46:02 PM','2023 06 20','admin','1','  General','  Cash','370.00','370.00','289',NULL,NULL,NULL,NULL,'20 Jun 2023','2023062012:46:02','%','0','45.00','no','0.00',NULL,'202306201246','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(191,'1*:4 HDMI SPLITTER','1.0','700','700.00','Item',NULL,NULL,'no',NULL,NULL,'20230620-000013','01:13:01 PM','2023 06 20','admin','1','  General','  Cash','700.00','700.00','299',NULL,NULL,NULL,NULL,'20 Jun 2023','2023062013:13:01','%','0','450.00','no','0.00',NULL,'202306201313','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(192,'INSTALLATION TAPE','10.0','10.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20230620-000014','02:34:42 PM','2023 06 20','admin','1','  General','  Cash','100.00','100.00','300',NULL,NULL,NULL,NULL,'20 Jun 2023','2023062014:34:42','%','0','100.00','no','0.00',NULL,'202306201434','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(193,'DC CONNCETOR','10.0','10','100.00','Item',NULL,NULL,'no',NULL,NULL,'20230620-000015','02:35:35 PM','2023 06 20','admin','1','  General','  Cash','100.00','100.00','301',NULL,NULL,NULL,NULL,'20 Jun 2023','2023062014:35:35','%','0','50.00','no','0.00',NULL,'202306201435','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(194,'4WAY SPLITTER 4S1','2.0','75.00','150.00','Item',NULL,NULL,'no',NULL,NULL,'20230620-000016','02:36:23 PM','2023 06 20','admin','3','  General','  Cash','70.00','70.00','6',NULL,NULL,NULL,NULL,'20 Jun 2023','2023062014:36:23','%','0','150.00','no','0.00',NULL,'202306201436','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(195,'TELVASS 8OUT DC NODE','1.0','800','800.00','Item',NULL,NULL,'no',NULL,NULL,'20230620-000031','02:38:30 PM','2023 06 20','admin','3','  General','  Cash','800.00','800.00','7',NULL,NULL,NULL,NULL,'20 Jun 2023','2023062014:38:30','%','0','900.00','no','0.00',NULL,'202306201438','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TELVASS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(196,'SHARP OX705','1.0','250','250.00','Item',NULL,NULL,'no',NULL,NULL,'20230620-000032','03:15:48 PM','2023 06 20','admin','3','  General','  Cash','450.00','450.00','8',NULL,NULL,NULL,NULL,'20 Jun 2023','2023062015:15:48','%','0','275.00','no','0.00',NULL,'202306201515','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(197,'SHARP OX706','1.0','200','200.00','Item',NULL,NULL,'no',NULL,NULL,'20230620-000032','03:15:48 PM','2023 06 20','admin','3','  General','  Cash','450.00','450.00','9',NULL,NULL,NULL,NULL,'20 Jun 2023','2023062015:15:48','%','0','240.00','no','0.00',NULL,'202306201515','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(198,'HDMI 10MTR','1.0','350.00','350.00','Item',NULL,NULL,'no',NULL,NULL,'20230620-000017','07:56:13 PM','2023 06 20','admin','1','  General','  Upiqr','600.00','600.00','306',NULL,NULL,NULL,NULL,'20 Jun 2023','2023062019:56:13','%','0','350.00','no','0.00',NULL,'202306201956','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,NULL,'','','',''),(199,'CAT6  10 MTR','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20230620-000017','07:56:13 PM','2023 06 20','admin','1','  General','  Upiqr','600.00','600.00','307',NULL,NULL,NULL,NULL,'20 Jun 2023','2023062019:56:13','%','0','250.00','no','0.00',NULL,'202306201956','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NETWORK ITEMS','admin','madmin','0',NULL,'',NULL,NULL,'','','',''),(200,'EVERFOCUS 1+3 90 MTR','1.0','900','900.00','Item',NULL,NULL,'no',NULL,NULL,'20230620-000018','08:19:53 PM','2023 06 20','admin','1','  General','  Cash','2750.00','2750.00','308',NULL,NULL,NULL,NULL,'20 Jun 2023','2023062020:19:53','%','0','950.00','no','0.00',NULL,'202306202019','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Everfocus','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(201,'ROVA 8port Poe 10/100','1.0','1850.00','1850.00','Item',NULL,NULL,'no',NULL,NULL,'20230620-000018','08:19:53 PM','2023 06 20','admin','1','  General','  Cash','2750.00','2750.00','309',NULL,NULL,NULL,NULL,'20 Jun 2023','2023062020:19:53','%','0','1850.00','no','0.00',NULL,'202306202019','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ROVA NETWORK SWITCHES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(202,'RG6 CCU 128','1.0','1250.00','1250.00','Item',NULL,NULL,'no',NULL,NULL,'20230621-000011','04:57:41 PM','2023 06 21','admin','1','  General','  Cash','1250.00','1250.00','311',NULL,NULL,NULL,NULL,'21 Jun 2023','2023062116:57:41','%','0','1250.00','no','0.00',NULL,'202306211657','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Everfocus','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(203,'STAND 1 FEET','1.0','200.00','200.00','Item',NULL,NULL,'no',NULL,NULL,'20230621-000012','06:01:52 PM','2023 06 21','admin','1','  General','  Cash','200.00','200.00','312',NULL,NULL,NULL,NULL,'21 Jun 2023','2023062118:01:52','%','0','200.00','no','0.00',NULL,'202306211801','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(204,'FACE PLATE DUAL','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20230621-000013','06:03:45 PM','2023 06 21','admin','1','  General','  Cash','245.00','245.00','313',NULL,NULL,NULL,NULL,'21 Jun 2023','2023062118:03:45','%','0','65.00','no','0.00',NULL,'202306211803','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NETWORK ITEMS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(205,'CAT6 I/O ','2.0','90.00','180.00','Item',NULL,NULL,'no',NULL,NULL,'20230621-000013','06:03:45 PM','2023 06 21','admin','1','  General','  Cash','245.00','245.00','314',NULL,NULL,NULL,NULL,'21 Jun 2023','2023062118:03:45','%','0','180.00','no','0.00',NULL,'202306211803','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NETWORK ITEMS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(206,'RG6 CCS 90 Mtrs','2.0','600.00','1200.00','Item',NULL,NULL,'no',NULL,NULL,'20230621-000014','06:52:36 PM','2023 06 21','admin','1','  General','  Cash','1200.00','1200.00','315',NULL,NULL,NULL,NULL,'21 Jun 2023','2023062118:52:36','%','0','1200.00','no','0.00',NULL,'202306211852','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Everfocus','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(207,'DR.COM RJ45 1BOX','1.0','320.00','320.00','Item',NULL,NULL,'no',NULL,NULL,'20230621-000015','06:55:39 PM','2023 06 21','admin','1','  General','  Cash','320.00','320.00','316',NULL,NULL,NULL,NULL,'21 Jun 2023','2023062118:55:39','%','0','320.00','no','0.00',NULL,'202306211855','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NETWORK ITEMS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(208,'RJ11 CONNETCOR','20.0','2.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20230621-000016','07:02:09 PM','2023 06 21','admin','1','  General','  Cash','140.00','140.00','317',NULL,NULL,NULL,NULL,'21 Jun 2023','2023062119:02:09','%','0','2.00','no','0.00',NULL,'202306211902','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NETWORK ITEMS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(209,'RJ45 CONNECTOR','20.0','5.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20230621-000016','07:02:09 PM','2023 06 21','admin','1','  General','  Cash','140.00','140.00','318',NULL,NULL,NULL,NULL,'21 Jun 2023','2023062119:02:09','%','0','5.00','no','0.00',NULL,'202306211902','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NETWORK ITEMS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(210,'SERVICE CHARGE','1.0','300','300.00','Item',NULL,NULL,'no',NULL,NULL,'20230621-000017','07:04:11 PM','2023 06 21','admin','1','  General','  Upiqr','300.00','300.00','319',NULL,NULL,NULL,NULL,'21 Jun 2023','2023062119:04:11','%','0','350.00','no','0.00',NULL,'202306211904','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SERVICE CHARGE','admin','madmin','0',NULL,'',NULL,NULL,'','','',''),(211,'HDMI 5 MTRS','1.0','150.00','150.00','Item',NULL,NULL,'no',NULL,NULL,'20230622-000011','11:50:21 AM','2023 06 22','admin','1','  General','  Cash','150.00','150.00','329',NULL,NULL,NULL,NULL,'22 Jun 2023','2023062211:50:21','%','0','150.00','no','0.00',NULL,'202306221150','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(212,'HDMI 5 MTRS','1.0','150.00','150.00','Item',NULL,NULL,'no',NULL,NULL,'20230622-000012','11:53:43 AM','2023 06 22','admin','1','  General','  Cash','150.00','150.00','330',NULL,NULL,NULL,NULL,'22 Jun 2023','2023062211:53:43','%','0','150.00','no','0.00',NULL,'202306221153','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(213,'BNC WIRED','8.0','18','144.00','Item',NULL,NULL,'no',NULL,NULL,'20230622-000013','12:28:57 PM','2023 06 22','admin','1','  General','  Cash','240.00','240.00','332',NULL,NULL,NULL,NULL,'22 Jun 2023','2023062212:28:57','%','0','10.00','no','0.00',NULL,'202306221228','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(214,'DC CONNCETOR','8.0','10','80.00','Item',NULL,NULL,'no',NULL,NULL,'20230622-000013','12:28:57 PM','2023 06 22','admin','1','  General','  Cash','240.00','240.00','333',NULL,NULL,NULL,NULL,'22 Jun 2023','2023062212:28:57','%','0','5.00','no','0.00',NULL,'202306221228','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(215,'4*4 PVC BOX','1.0','16.00','16.00','Item',NULL,NULL,'no',NULL,NULL,'20230622-000013','12:28:57 PM','2023 06 22','admin','1','  General','  Cash','240.00','240.00','334',NULL,NULL,NULL,NULL,'22 Jun 2023','2023062212:28:57','%','0','16.00','no','0.00',NULL,'202306221228','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(216,'pvc 5x5 box','24.0','50.00','1200.00','Item',NULL,NULL,'no',NULL,NULL,'20230622-000014','01:08:00 PM','2023 06 22','admin','1','  General','  Cash','1200.00','1200.00','335',NULL,NULL,NULL,NULL,'22 Jun 2023','2023062213:08:00','%','0','1250.00','no','0.00',NULL,'202306221308','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(217,'ROVA 5 PORT SWITCH','1.0','450','450.00','Item',NULL,NULL,'no',NULL,NULL,'20230622-000015','01:32:25 PM','2023 06 22','admin','1','  General','  Cash','450.00','450.00','338',NULL,NULL,NULL,NULL,'22 Jun 2023','2023062213:32:25','%','0','500.00','no','0.00',NULL,'202306221332','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ROVA NETWORK SWITCHES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(218,'spicing tube','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20230622-000016','06:39:10 PM','2023 06 22','admin','1','  General','  Cash','100.00','100.00','352',NULL,NULL,NULL,NULL,'22 Jun 2023','2023062218:39:10','%','0','100.00','no','0.00',NULL,'202306221839','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(219,'NETLINK 323 DAC','1.0','2700','2700.00','Item',NULL,NULL,'no',NULL,NULL,'20230622-000017','07:08:37 PM','2023 06 22','admin','1','  General','  Cash','2700.00','2700.00','353',NULL,NULL,NULL,NULL,'22 Jun 2023','2023062219:08:37','%','0','2500.00','no','0.00',NULL,'202306221908','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NETLINK','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(220,'KING COM HD.MI 15MTR','1.0','1500.00','1500.00','Item',NULL,NULL,'no',NULL,NULL,'20230622-000018','07:53:10 PM','2023 06 22','admin','1','  General','  Cash','1500.00','1500.00','355',NULL,NULL,NULL,NULL,'22 Jun 2023','2023062219:53:10','%','0','1500.00','no','0.00',NULL,'202306221953','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(221,'SHARP OX742','1.0','1350','1350.00','Item',NULL,NULL,'no',NULL,NULL,'20230623-000011','11:00:10 AM','2023 06 23','admin','1','  General','  Cash','1900.00','1900.00','356',NULL,NULL,NULL,NULL,'23 Jun 2023','2023062311:00:10','%','0','1400.00','no','0.00',NULL,'202306231100','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(222,'2 WAY SPLITTER 2S1','4.0','65.00','260.00','Item',NULL,NULL,'no',NULL,NULL,'20230623-000011','11:00:10 AM','2023 06 23','admin','1','  General','  Cash','1900.00','1900.00','357',NULL,NULL,NULL,NULL,'23 Jun 2023','2023062311:00:10','%','0','260.00','no','0.00',NULL,'202306231100','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(223,'3WAY SPLITTER 3S1','2.0','70.00','140.00','Item',NULL,NULL,'no',NULL,NULL,'20230623-000011','11:00:10 AM','2023 06 23','admin','1','  General','  Cash','1900.00','1900.00','358',NULL,NULL,NULL,NULL,'23 Jun 2023','2023062311:00:10','%','0','140.00','no','0.00',NULL,'202306231100','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(224,'4WAY SPLITTER 4S1','2.0','75.00','150.00','Item',NULL,NULL,'no',NULL,NULL,'20230623-000011','11:00:10 AM','2023 06 23','admin','1','  General','  Cash','1900.00','1900.00','359',NULL,NULL,NULL,NULL,'23 Jun 2023','2023062311:00:10','%','0','150.00','no','0.00',NULL,'202306231100','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(225,'2 WAY SPLITTER 2S1','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20230623-000012','12:53:22 PM','2023 06 23','admin','1','  General','  Cash','185.00','185.00','360',NULL,NULL,NULL,NULL,'23 Jun 2023','2023062312:53:22','%','0','65.00','no','0.00',NULL,'202306231253','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(226,'3WAY SPLITTER 3S1','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20230623-000012','12:53:22 PM','2023 06 23','admin','1','  General','  Cash','185.00','185.00','361',NULL,NULL,NULL,NULL,'23 Jun 2023','2023062312:53:22','%','0','70.00','no','0.00',NULL,'202306231253','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(227,'VX F5 CONNECTOR','10','5','50.00','Item',NULL,NULL,'no',NULL,NULL,'20230623-000012','12:53:22 PM','2023 06 23','admin','1','  General','  Cash','185.00','185.00','363',NULL,NULL,NULL,NULL,'23 Jun 2023','2023062312:53:22','%','0','6.00','no','0.00',NULL,'202306231253','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(228,'syrotech  Ont','1.0','1750','1750.00','Item',NULL,NULL,'no',NULL,NULL,'20230623-000013','01:01:59 PM','2023 06 23','admin','1','  General','  Cash','1750.00','1750.00','367',NULL,NULL,NULL,NULL,'23 Jun 2023','2023062313:01:59','%','0','1850.00','no','0.00',NULL,'202306231301','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CATV ACCESORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(229,'DR.COM 6FIBER','200','9','1800.00','Item',NULL,NULL,'no',NULL,NULL,'20230623-000014','04:46:04 PM','2023 06 23','admin','1','  General','  Cash','2350.00','2350.00','368',NULL,NULL,NULL,NULL,'23 Jun 2023','2023062316:46:04','%','0','8.00','no','0.00',NULL,'202306231646','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'DR COM FIBER','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(230,'VX F5 CONNECTOR','100.0','6','600.00','Item',NULL,NULL,'no',NULL,NULL,'20230623-000014','04:46:04 PM','2023 06 23','admin','1','  General','  Cash','2350.00','2350.00','369',NULL,NULL,NULL,NULL,'23 Jun 2023','2023062316:46:04','₹','.50','550.00','yes','50.00',NULL,'202306231646','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(231,'LMB 200 CABLE','1.0','350.00','350.00','Item',NULL,NULL,'no',NULL,NULL,'20230623-000015','07:08:46 PM','2023 06 23','admin','1','  General','  Cash','350.00','350.00','370',NULL,NULL,NULL,NULL,'23 Jun 2023','2023062319:08:46','%','0','350.00','no','0.00',NULL,'202306231908','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NETWORK ITEMS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(232,'RG6 CCU 128','1.0','1250.00','1250.00','Item',NULL,NULL,'no',NULL,NULL,'20230624-000011','01:45:45 PM','2023 06 24','admin','1','  General','  Cash','1325.00','1325.00','371',NULL,NULL,NULL,NULL,'24 Jun 2023','2023062413:45:45','%','0','1250.00','no','0.00',NULL,'202306241345','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Everfocus','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(233,'SHARP I/D  4WAY SPLITTER 4S','1.0','75.00','75.00','Item',NULL,NULL,'no',NULL,NULL,'20230624-000011','01:45:45 PM','2023 06 24','admin','1','  General','  Cash','1325.00','1325.00','372',NULL,NULL,NULL,NULL,'24 Jun 2023','2023062413:45:45','%','0','75.00','no','0.00',NULL,'202306241345','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(234,'RG6 CCS 90 Mtrs','2.0','600.00','1200.00','Item',NULL,NULL,'no',NULL,NULL,'20230626-000011','02:48:23 PM','2023 06 26','admin','1','  General','  Upiqr','1480.00','1480.00','373',NULL,NULL,NULL,NULL,'26 Jun 2023','2023062614:48:23','%','0','1200.00','no','0.00',NULL,'202306261448','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Everfocus','admin','madmin','0',NULL,'',NULL,NULL,'','','',''),(235,'3WAY SPLITTER 3S1','4.0','70.00','280.00','Item',NULL,NULL,'no',NULL,NULL,'20230626-000011','02:48:23 PM','2023 06 26','admin','1','  General','  Upiqr','1480.00','1480.00','374',NULL,NULL,NULL,NULL,'26 Jun 2023','2023062614:48:23','%','0','280.00','no','0.00',NULL,'202306261448','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin','0',NULL,'',NULL,NULL,'','','',''),(236,'HDMI EXTENDDER 30 MTRS','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20230627-000011','12:33:50 PM','2023 06 27','admin','1','  General','  Cash','250.00','250.00','375',NULL,NULL,NULL,NULL,'27 Jun 2023','2023062712:33:50','%','0','250.00','no','0.00',NULL,'202306271233','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(237,'SHARP OX724','1.0','1100','1100.00','Item',NULL,NULL,'no',NULL,NULL,'20230628-000011','02:24:46 PM','2023 06 28','admin','1','  General','  Cash','1100.00','1100.00','379',NULL,NULL,NULL,NULL,'28 Jun 2023','2023062814:24:46','%','0','1150.00','no','0.00',NULL,'202306281424','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'78452190592',NULL,NULL,'','','',''),(238,'2 WAY SPLITTER 2S1-I/D','2.0','45.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20230628-000012','07:04:09 PM','2023 06 28','admin','1','  General','  Cash','650.00','650.00','380',NULL,NULL,NULL,NULL,'28 Jun 2023','2023062819:04:09','%','0','90.00','no','0.00',NULL,'202306281904','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(239,'4 WAY SPLITTER 4S1-I/D','2.0','55.00','110.00','Item',NULL,NULL,'no',NULL,NULL,'20230628-000012','07:04:09 PM','2023 06 28','admin','1','  General','  Cash','650.00','650.00','381',NULL,NULL,NULL,NULL,'28 Jun 2023','2023062819:04:09','%','0','110.00','no','0.00',NULL,'202306281904','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(240,'S R F5 CONNECTOR PACK','1.0','450.00','450.00','Item',NULL,NULL,'no',NULL,NULL,'20230628-000012','07:04:09 PM','2023 06 28','admin','1','  General','  Cash','650.00','650.00','382',NULL,NULL,NULL,NULL,'28 Jun 2023','2023062819:04:09','%','0','450.00','no','0.00',NULL,'202306281904','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CATV ACCESORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(241,'4*4 PVC BOX','4.0','16.00','64.00','Item',NULL,NULL,'no',NULL,NULL,'20230629-000011','12:46:12 PM','2023 06 29','admin','1','  General','  Cash','254.00','254.00','383',NULL,NULL,NULL,NULL,'29 Jun 2023','2023062912:46:12','%','0','64.00','no','0.00',NULL,'202306291246','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(242,'DC CONNCETOR','5.0','6','30.00','Item',NULL,NULL,'no',NULL,NULL,'20230629-000011','12:46:12 PM','2023 06 29','admin','1','  General','  Cash','254.00','254.00','384',NULL,NULL,NULL,NULL,'29 Jun 2023','2023062912:46:12','%','0','25.00','no','0.00',NULL,'202306291246','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(243,'IFOCUSS BNC','10.0','16','160.00','Item',NULL,NULL,'no',NULL,NULL,'20230629-000011','12:46:12 PM','2023 06 29','admin','1','  General','  Cash','254.00','254.00','385',NULL,NULL,NULL,NULL,'29 Jun 2023','2023062912:46:12','%','0','200.00','no','0.00',NULL,'202306291246','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(248,'BNC WIRED','100.0','10.00','1000.00','Item',NULL,NULL,'no',NULL,NULL,'20230630-000011','09:02:21 PM','2023 06 30','admin','1','  General','  Upiqr','1000.00','1000.00','399',NULL,NULL,NULL,NULL,'30 Jun 2023','2023063021:02:21','%','0','70.00','no','0.00',NULL,'202306302102','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCTV ACCESSORIES','admin','madmin','0',NULL,'',NULL,NULL,'','','',''),(249,'KRONE TELEPHONE TOOL','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20230630-000012','09:04:35 PM','2023 06 30','admin','1','  General','  Upiqr','250.00','250.00','400',NULL,NULL,NULL,NULL,'30 Jun 2023','2023063021:04:35','%','0','250.00','no','0.00',NULL,'202306302104','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TELEPHONE ACCESSORIES','admin','madmin','0',NULL,'',NULL,NULL,'','','',''),(250,'SERVICE CHARGES','1.0','400.00','400.00','Item',NULL,NULL,'no',NULL,NULL,'20230704-000011','04:51:48 PM','2023 07 04','admin','1','  General','  Cash','400.00','400.00','405',NULL,NULL,NULL,NULL,'04 Jul 2023','2023070416:51:48','%','0','400.00','no','0.00',NULL,'202307041651','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SERVICE CHARGE','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(251,'RG6 CCS 90 Mtrs','2.0','700','1400.00','Item',NULL,NULL,'no',NULL,NULL,'20230704-000012','05:33:03 PM','2023 07 04','admin','1','  General','  Cash','1450.00','1450.00','406',NULL,NULL,NULL,NULL,'04 Jul 2023','2023070417:33:03','%','0','600.00','no','0.00',NULL,'202307041733','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Everfocus','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(252,'VX I JOINTER','5.0','10.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20230704-000012','05:33:03 PM','2023 07 04','admin','1','  General','  Cash','1450.00','1450.00','407',NULL,NULL,NULL,NULL,'04 Jul 2023','2023070417:33:03','%','0','10.00','no','0.00',NULL,'202307041733','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CATV ACCESORIES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(253,'EVERFOCUS RG6/198 CCS 1 DRUM','1.0','2300.00','2300.00','Item',NULL,NULL,'no',NULL,NULL,'20230704-000013','08:20:12 PM','2023 07 04','admin','1','  General','  Upiqr','2760.00','2760.00','408',NULL,NULL,NULL,NULL,'04 Jul 2023','2023070420:20:12','%','0','2300.00','no','0.00',NULL,'202307042020','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Everfocus','admin','madmin','0',NULL,'',NULL,NULL,'','','',''),(254,'2 WAY SPLITTER 2S1','2.0','65.00','130.00','Item',NULL,NULL,'no',NULL,NULL,'20230704-000013','08:20:12 PM','2023 07 04','admin','1','  General','  Upiqr','2760.00','2760.00','409',NULL,NULL,NULL,NULL,'04 Jul 2023','2023070420:20:12','%','0','130.00','no','0.00',NULL,'202307042020','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin','0',NULL,'',NULL,NULL,'','','',''),(255,'3WAY SPLITTER 3S1','2.0','70.00','140.00','Item',NULL,NULL,'no',NULL,NULL,'20230704-000013','08:20:12 PM','2023 07 04','admin','1','  General','  Upiqr','2760.00','2760.00','410',NULL,NULL,NULL,NULL,'04 Jul 2023','2023070420:20:12','%','0','140.00','no','0.00',NULL,'202307042020','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin','0',NULL,'',NULL,NULL,'','','',''),(256,'4WAY SPLITTER 4S1','2.0','75.00','150.00','Item',NULL,NULL,'no',NULL,NULL,'20230704-000013','08:20:12 PM','2023 07 04','admin','1','  General','  Upiqr','2760.00','2760.00','411',NULL,NULL,NULL,NULL,'04 Jul 2023','2023070420:20:12','%','0','150.00','no','0.00',NULL,'202307042020','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin','0',NULL,'',NULL,NULL,'','','',''),(257,'RG6 RING 1 PACKET','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20230704-000013','08:20:12 PM','2023 07 04','admin','1','  General','  Upiqr','2760.00','2760.00','412',NULL,NULL,NULL,NULL,'04 Jul 2023','2023070420:20:12','%','0','40.00','no','0.00',NULL,'202307042020','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin','0',NULL,'',NULL,NULL,'','','',''),(258,'RG6 CCU 128','1.0','1250.00','1250.00','Item',NULL,NULL,'no',NULL,NULL,'20230706-000011','01:43:03 PM','2023 07 06','admin','1','  General','  Cash','1250.00','1250.00','413',NULL,NULL,NULL,NULL,'06 Jul 2023','2023070613:43:03','%','0','1250.00','no','0.00',NULL,'202307061343','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Everfocus','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(259,'SHARP OX724','1.0','1150.00','1150.00','Item',NULL,NULL,'no',NULL,NULL,'20230708-000011','01:30:29 PM','2023 07 08','admin','1','  General','  Cash','1150.00','1150.00','417',NULL,NULL,NULL,NULL,'08 Jul 2023','2023070813:30:29','%','0','1150.00','no','0.00',NULL,'202307081330','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'78452190592',NULL,NULL,'','','',''),(261,'SERVICE CHARGE','1.0','600','600.00','Item',NULL,NULL,'no',NULL,NULL,'20230711-000011','11:35:42 AM','2023 07 11','admin','1','  General','  Cash','600.00','600.00','420',NULL,NULL,NULL,NULL,'11 Jul 2023','2023071111:35:42','%','0','350.00','no','0.00',NULL,'202307111135','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SERVICE CHARGE','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(262,'roster box 1way','1.0','15.00','15.00','Item',NULL,NULL,'no',NULL,NULL,'20230923-000011','12:15:59 PM','2023 09 23','admin','1','  General','  Cash','15.00','15.00','447',NULL,NULL,NULL,NULL,'23 Sep 2023','2023092312:15:59','%','0','15.00','no','0.00',NULL,'202309231215','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(263,'roster box 1way','1.0','15.00','15.00','Item',NULL,NULL,'no',NULL,NULL,'20230923-000012','12:29:57 PM','2023 09 23','admin','1','  General','  Cash','15.00','15.00','448',NULL,NULL,NULL,NULL,'23 Sep 2023','2023092312:29:57','%','0','15.00','no','0.00',NULL,'202309231229','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(264,'syrotech  Ont','1.0','1850.00','1850.00','Item',NULL,NULL,'no',NULL,NULL,'20240125-000011','12:23:49 PM','2024 01 25','admin','1','  General','  Upiqr','8150.00','8150.00','452',NULL,NULL,NULL,NULL,'25 Jan 2024','2024012512:23:49','₹','200','1650.00','yes','200.00',NULL,'202401251223','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CATV ACCESORIES','admin','madmin','0',NULL,'',NULL,NULL,'','','',''),(265,'NIG 4 FIBER','1000','6.50','6500.00','Item',NULL,NULL,'no',NULL,NULL,'20240125-000011','12:23:49 PM','2024 01 25','admin','1','  General','  Upiqr','8150.00','8150.00','453',NULL,NULL,NULL,NULL,'25 Jan 2024','2024012512:23:49','%','0','6.50','no','0.00',NULL,'202401251223','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,NULL,'','','',''),(266,'RG6 CCS 90 Mtrs','2.0','600.00','1200.00','Item',NULL,NULL,'no',NULL,NULL,'20240221-000011','02:09:38 PM','2024 02 21','ladmin','1','  General','  Cash','1080.00','1080.00','456',NULL,NULL,NULL,NULL,'21 Feb 2024','2024022114:09:38','%','10','1080.00','yes','120.00',NULL,'202402211409','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Everfocus','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','',''),(267,'RG6 CCS 90 Mtrs','1.0','600.00','600.00','Item',NULL,NULL,'no',NULL,NULL,'20240221-000012','02:10:54 PM','2024 02 21','ladmin','1','  General','  Cash','600.00','600.00','457',NULL,NULL,NULL,NULL,'21 Feb 2024','2024022114:10:54','%','0','600.00','no','0.00',NULL,'202402211410','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Everfocus','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','',''),(268,'SHARP OX724','1.0','1150.00','1150.00','Item',NULL,NULL,'no',NULL,NULL,'20240221-000013','05:34:01 PM','2024 02 21','admin','1','  General','  Cash','1150.00','1150.00','463',NULL,NULL,NULL,NULL,'21 Feb 2024','2024022117:34:01','%','0','1150.00','no','0.00',NULL,'202402211734','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'78452190592',NULL,NULL,'','','',''),(269,'SHARP OX742','1.0','1400.00','1400.00','Item',NULL,NULL,'no',NULL,NULL,'20240221-000014','06:34:32 PM','2024 02 21','admin','1','  General','  Cash','2550.00','2550.00','464',NULL,NULL,NULL,NULL,'21 Feb 2024','2024022118:34:32','%','0','1400.00','no','0.00',NULL,'202402211834','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(270,'SHARP OX722','1.0','1150.00','1150.00','Item',NULL,NULL,'no',NULL,NULL,'20240221-000014','06:34:32 PM','2024 02 21','admin','1','  General','  Cash','2550.00','2550.00','465',NULL,NULL,NULL,NULL,'21 Feb 2024','2024022118:34:32','%','0','1150.00','no','0.00',NULL,'202402211834','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(271,'SHARP COUPLER 90:10 ','4.0','140.00','560.00','Item',NULL,NULL,'no',NULL,NULL,'20240221-000031','06:36:11 PM','2024 02 21','admin','3','  General','  Cash','916.00','916.00','10',NULL,NULL,NULL,NULL,'21 Feb 2024','2024022118:36:11','%','0','560.00','no','0.00',NULL,'202402211836','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(272,'VX F5 CONNECTOR','1.0','6.00','6.00','Item',NULL,NULL,'no',NULL,NULL,'20240221-000031','06:36:11 PM','2024 02 21','admin','3','  General','  Cash','916.00','916.00','11',NULL,NULL,NULL,NULL,'21 Feb 2024','2024022118:36:11','%','0','6.00','no','0.00',NULL,'202402211836','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(273,'SERVICE CHARGE','1.0','350.00','350.00','Item',NULL,NULL,'no',NULL,NULL,'20240221-000031','06:36:11 PM','2024 02 21','admin','3','  General','  Cash','916.00','916.00','12',NULL,NULL,NULL,NULL,'21 Feb 2024','2024022118:36:11','%','0','350.00','no','0.00',NULL,'202402211836','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SERVICE CHARGE','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(274,'SHARP OX724','1.0','1150.00','1150.00','Item',NULL,NULL,'no',NULL,NULL,'20240221-000015','06:54:10 PM','2024 02 21','admin','1','  General','  Cash','1150.00','1150.00','470',NULL,NULL,NULL,NULL,'21 Feb 2024','2024022118:54:10','%','0','1150.00','no','0.00',NULL,'202402211854','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'78452190592',NULL,NULL,'','','',''),(275,'SHARP OX724','1.0','1150.00','1150.00','Item',NULL,NULL,'no',NULL,NULL,'20240222-000021','11:40:49 AM','2024 02 22','user4','2','  General','  Cash','2550.00','2550.00','2',NULL,NULL,NULL,NULL,'22 Feb 2024','2024022211:40:49','%','0','1150.00','no','0.00',NULL,'202402221140','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','user4','User4',NULL,NULL,'',NULL,NULL,'','','',''),(276,'SHARP OX742','1.0','1400.00','1400.00','Item',NULL,NULL,'no',NULL,NULL,'20240222-000021','11:40:49 AM','2024 02 22','user4','2','  General','  Cash','2550.00','2550.00','3',NULL,NULL,NULL,NULL,'22 Feb 2024','2024022211:40:49','%','0','1400.00','no','0.00',NULL,'202402221140','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','user4','User4',NULL,NULL,'',NULL,NULL,'','','',''),(277,'SHARP OX724','1.0','1150.00','1150.00','Item',NULL,NULL,'no',NULL,NULL,'20240426-000021','04:42:19 PM','2024 04 26','admin','2','  General','  Cash','2300.00','2300.00','7',NULL,NULL,NULL,NULL,'26 Apr 2024','2024042616:42:19','%','0','1150.00','no','0.00',NULL,'202404261642','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(278,'SHARP OX722','1.0','1150.00','1150.00','Item',NULL,NULL,'no',NULL,NULL,'20240426-000021','04:42:19 PM','2024 04 26','admin','2','  General','  Cash','2300.00','2300.00','8',NULL,NULL,NULL,NULL,'26 Apr 2024','2024042616:42:19','%','0','1150.00','no','0.00',NULL,'202404261642','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(279,'SHARP OX724','1.0','1150.00','1150.00','Item',NULL,NULL,'no',NULL,NULL,'20240426-000022','04:53:08 PM','2024 04 26','admin','2','  General','  Cash','1150.00','1150.00','9',NULL,NULL,NULL,NULL,'26 Apr 2024','2024042616:53:08','%','0','1150.00','no','0.00',NULL,'202404261653','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(280,'SHARP OX706','1.0','240.00','240.00','Item',NULL,NULL,'no',NULL,NULL,'20240426-000023','04:54:02 PM','2024 04 26','admin','2','  General','  Cash','240.00','240.00','10',NULL,NULL,NULL,NULL,'26 Apr 2024','2024042616:54:02','%','0','240.00','no','0.00',NULL,'202404261654','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(281,'SHARP OX706','1.0','240.00','240.00','Item',NULL,NULL,'no',NULL,NULL,'20240514-000021','06:42:23 PM','2024 05 14','user4','2','  General','  Cash','240.00','240.00','10',NULL,NULL,NULL,NULL,'14 May 2024','2024051418:42:23','%','0','240.00','no','0.00',NULL,'202405141842','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','user4','User4',NULL,NULL,'',NULL,NULL,'','','',''),(282,'SHARP OX722','1.0','1150.00','1150.00','Item',NULL,NULL,'no',NULL,NULL,'20240514-000022','06:43:21 PM','2024 05 14','user4','2','  General','  Cash','1150.00','1150.00','11',NULL,NULL,NULL,NULL,'14 May 2024','2024051418:43:21','%','0','1150.00','no','0.00',NULL,'202405141843','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','user4','User4',NULL,NULL,'',NULL,NULL,'','','',''),(283,'SHARP OX724','1.0','1150.00','1150.00','Item',NULL,NULL,'no',NULL,NULL,'20240514-000023','06:47:36 PM','2024 05 14','user4','2','  General','  Cash','1150.00','1150.00','12',NULL,NULL,NULL,NULL,'14 May 2024','2024051418:47:36','%','0','1150.00','no','0.00',NULL,'202405141847','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','user4','User4',NULL,NULL,'',NULL,NULL,'','','',''),(284,'tcshirts','1.0','500.00','500.00','Item',NULL,NULL,'no','18','gst(18%)','20240514-000024','06:51:43 PM','2024 05 14','user4','2','  General','  Cash','590.00','590.00','13',NULL,NULL,NULL,NULL,'14 May 2024','2024051418:51:43','%','0','500.00','no','0.00',NULL,'202405141851','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'shirts','user4','User4',NULL,NULL,'',NULL,NULL,'','','',''),(285,'T SHIRTS ','1.0','500.00','500.00','Item',NULL,NULL,'no','18','gst(18%)','20240514-000025','07:42:31 PM','2024 05 14','user4','2','  General','  Cash','755.00','755.00','14',NULL,NULL,NULL,NULL,'14 May 2024','2024051419:42:31','%','0','500.00','no','0.00',NULL,'202405141942','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'shirts','user4','User4',NULL,NULL,'',NULL,NULL,'','','',''),(286,'T SHIRTS ','1.0','500.00','500.00','Item',NULL,NULL,'no','18','gst(18%)','20240514-000026','07:43:13 PM','2024 05 14','user4','2','  General','  Cash','755.00','755.00','15',NULL,NULL,NULL,NULL,'14 May 2024','2024051419:43:13','%','0','500.00','no','0.00',NULL,'202405141943','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'shirts','user4','User4',NULL,NULL,'',NULL,NULL,'','','',''),(287,'T SHIRTS ','1.0','500.00','500.00','Item',NULL,NULL,'no','18','gst(18%)','20240514-000027','07:45:02 PM','2024 05 14','user4','2','  General','  Cash','755.00','755.00','16',NULL,NULL,NULL,NULL,'14 May 2024','2024051419:45:02','%','0','500.00','no','0.00',NULL,'202405141945','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'shirts','user4','User4',NULL,NULL,'',NULL,NULL,'','','',''),(288,'SHARP OX724','1.0','1150.00','1150.00','Item',NULL,NULL,'no',NULL,NULL,'20240611-000021','12:58:28 PM','2024 06 11','admin','2','  General','  Cash','1529.50','1529.50','24',NULL,NULL,NULL,NULL,'11 Jun 2024','2024061112:58:28','%','0','1150.00','no','0.00',NULL,'202406111258','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'1602',NULL,NULL,'','','',''),(289,'SHARP OX724','1.0','1150.00','1150.00','Item',NULL,NULL,'no',NULL,NULL,'20240611-000022','12:59:47 PM','2024 06 11','admin','2','  General','  Cash','1529.50','1529.50','25',NULL,NULL,NULL,NULL,'11 Jun 2024','2024061112:59:47','%','0','1150.00','no','0.00',NULL,'202406111259','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'1602',NULL,NULL,'','','',''),(290,'US OPTICAL PATCH CORD BLUE','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20240611-000023','01:03:50 PM','2024 06 11','admin','2','  General','  Cash','86.45','86.45','26',NULL,NULL,NULL,NULL,'11 Jun 2024','2024061113:03:50','%','0','65.00','no','0.00',NULL,'202406111303','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UNITED SYSTEM','admin','madmin',NULL,NULL,'1617',NULL,NULL,'','','',''),(291,'US OPTICAL PATCH CORD BLUE','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20240611-000024','01:04:31 PM','2024 06 11','admin','2','  General','  Cash','86.45','86.45','27',NULL,NULL,NULL,NULL,'11 Jun 2024','2024061113:04:31','%','0','65.00','no','0.00',NULL,'202406111304','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UNITED SYSTEM','admin','madmin',NULL,NULL,'1617',NULL,NULL,'','','',''),(292,'SHARP OX724','1.0','1150.00','1150.00','Item',NULL,NULL,'no',NULL,NULL,'20240611-000025','01:05:42 PM','2024 06 11','admin','2','  General','  Cash','1529.50','1529.50','28',NULL,NULL,NULL,NULL,'11 Jun 2024','2024061113:05:42','%','0','1150.00','no','0.00',NULL,'202406111305','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'1602',NULL,NULL,'','','',''),(293,'SHARP OX724','3.0','1150.00','3450.00','Item',NULL,NULL,'no',NULL,NULL,'20240611-000026','01:06:42 PM','2024 06 11','admin','2','  General','  Upiqr','4867.80','4867.80','29',NULL,NULL,NULL,NULL,'11 Jun 2024','2024061113:06:42','%','0','3450.00','no','0.00',NULL,'202406111306','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin','0',NULL,'1602',NULL,NULL,'','','',''),(294,'US OPTICAL PATCH CORD BLUE','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20240611-000026','01:06:42 PM','2024 06 11','admin','2','  General','  Upiqr','4867.80','4867.80','30',NULL,NULL,NULL,NULL,'11 Jun 2024','2024061113:06:42','%','0','65.00','no','0.00',NULL,'202406111306','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UNITED SYSTEM','admin','madmin','0',NULL,'1617',NULL,NULL,'','','',''),(295,'US OPTICAL PATCH CORD GREEN','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20240611-000026','01:06:42 PM','2024 06 11','admin','2','  General','  Upiqr','4867.80','4867.80','31',NULL,NULL,NULL,NULL,'11 Jun 2024','2024061113:06:42','%','0','65.00','no','0.00',NULL,'202406111306','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UNITED SYSTEM','admin','madmin','0',NULL,'1618',NULL,NULL,'','','',''),(296,'SHARP PSP 12V','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240611-000026','01:06:42 PM','2024 06 11','admin','2','  General','  Upiqr','4867.80','4867.80','32',NULL,NULL,NULL,NULL,'11 Jun 2024','2024061113:06:42','%','0','80.00','no','0.00',NULL,'202406111306','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin','0',NULL,'1619',NULL,NULL,'','','',''),(297,'SHARP OX724','2.0','1150.00','2300.00','Item',NULL,NULL,'no',NULL,NULL,'20240727-000021','02:53:01 PM','2024 07 27','admin','2','  General','  Cash','3318.35','3318.35','33',NULL,NULL,NULL,NULL,'27 Jul 2024','2024072714:53:01','%','0','2300.00','no','0.00',NULL,'202407271453','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHARP','admin','madmin',NULL,NULL,'1602',NULL,NULL,'','','',''),(298,'US OPTICAL PATCH CORD BLUE','2.0','65.00','130.00','Item',NULL,NULL,'no',NULL,NULL,'20240727-000021','02:53:01 PM','2024 07 27','admin','2','  General','  Cash','3318.35','3318.35','34',NULL,NULL,NULL,NULL,'27 Jul 2024','2024072714:53:01','%','0','130.00','no','0.00',NULL,'202407271453','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UNITED SYSTEM','admin','madmin',NULL,NULL,'1617',NULL,NULL,'','','',''),(299,'US OPTICAL PATCH CORD GREEN','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20240727-000021','02:53:01 PM','2024 07 27','admin','2','  General','  Cash','3318.35','3318.35','35',NULL,NULL,NULL,NULL,'27 Jul 2024','2024072714:53:01','%','0','65.00','no','0.00',NULL,'202407271453','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UNITED SYSTEM','admin','madmin',NULL,NULL,'1618',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`) VALUES (2,'SERVICE CHARGE','1.0','3000','3000.00','Item',NULL,NULL,'no',NULL,NULL,'20230616-0000110','07:13:43 PM','2023 06 16','admin','  General','  Cash','3000.00','3000.0','262','amount value changed','3000.00','16 Jun 2023','3000.00','%','0','350.00','no','','202306161913',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,''),(3,'NETLINK 323 DAC','1.0','3000','3000.00','Item',NULL,NULL,'no',NULL,NULL,'20230617-000011','04:01:18 PM','2023 06 17','admin','  General','  Cash','3000.00','3000.0','271','amount changed','3000.00','17 Jun 2023','3000.00','%','0','2500.00','no','','202306171601',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,''),(4,'SHARP OX724','2.0','1150.00','2300.00','Item',NULL,NULL,'no',NULL,NULL,'20230629-000012','03:33:36 PM','2023 06 30','admin','  General','  Cash','5000.00','5000.0','393','wrong billed','5000.00','30 Jun 2023','5000.00','%','0','2300.00','no','','202306301533',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,''),(5,'SHARP OX722','1.0','1150.00','1150.00','Item',NULL,NULL,'no',NULL,NULL,'20230629-000012','03:33:36 PM','2023 06 30','admin','  General','  Cash','5000.00','5000.0','394','wrong billed','5000.00','30 Jun 2023','5000.00','%','0','1150.00','no','','202306301533',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,''),(6,'SHARP OX742','1.0','1400.00','1400.00','Item',NULL,NULL,'no',NULL,NULL,'20230629-000012','03:33:36 PM','2023 06 30','admin','  General','  Cash','5000.00','5000.0','395','wrong billed','5000.00','30 Jun 2023','5000.00','%','0','1400.00','no','','202306301533',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,''),(7,'COURIER CHARGE','3.0','50.00','150.00','Item',NULL,NULL,'no',NULL,NULL,'20230629-000012','03:33:36 PM','2023 06 30','admin','  General','  Cash','5000.00','5000.0','396','wrong billed','5000.00','30 Jun 2023','5000.00','%','0','150.00','no','','202306301533',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,''),(8,'SHARP OX724','1.0','1150.00','1150.00','Item',NULL,NULL,'no',NULL,NULL,'20230708-000012','10:27:56 AM','2023 07 10','admin','  General','  Cash','1150.00','1150.0','418','demo bill','1150.00','10 Jul 2023','1150.00','%','0','1150.00','no','','202307101027',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'');
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`) VALUES (1,'20230603-000011','1150.00','admin','2023 06 03','  Cash','  General','1150.00','0.00','0.00','0.0','1','202306031353',NULL,NULL,NULL,NULL,NULL),(2,'20230603-000012','2900.00','admin','2023 06 03','  Pay Later','  General','2900.00','0.00','0.00','0.0','2','202306031421',NULL,NULL,NULL,NULL,NULL),(3,'20230603-000013','5750.00','admin','2023 06 03','  Cash','  General','5750.00','0.00','0.00','0.0','3','202306031423',NULL,NULL,NULL,NULL,NULL),(4,'20230605-000011','1030.00','admin','2023 06 05','  Cash','  General','1030.00','0.00','0.00','0.0','4','202306051116',NULL,NULL,NULL,NULL,NULL),(5,'20230605-000012','1150.00','admin','2023 06 05','  Upiqr','  General','1150.00','0.00','0.00','0.0','5','202306051322',NULL,NULL,NULL,NULL,NULL),(6,'20230605-000013','350.00','admin','2023 06 05','  Cash','  General','350.00','0.00','0.00','0.0','6','202306051346',NULL,NULL,NULL,NULL,NULL),(7,'20230605-000014','1700.00','admin','2023 06 05','  Cash','  General','1700.00','0.00','0.00','0.0','7','202306051553',NULL,NULL,NULL,NULL,NULL),(8,'20230607-000011','1200.00','admin','2023 06 07','  Cash','  General','1200.00','0.00','0.00','0.0','8','202306071045',NULL,NULL,NULL,NULL,NULL),(9,'20230607-000012','1195.00','admin','2023 06 07','  Cash','  General','1195.00','0.00','0.00','0.0','9','202306071207',NULL,NULL,NULL,NULL,NULL),(10,'20230607-000013','85.00','admin','2023 06 07','  Cash','  General','85.00','0.00','0.00','0.0','10','202306071212',NULL,NULL,NULL,NULL,NULL),(11,'20230607-000014','1450.00','admin','2023 06 07','  Cash','  General','1450.00','0.00','0.00','0.0','11','202306071218',NULL,NULL,NULL,NULL,NULL),(12,'20230607-000015','400.00','admin','2023 06 07','  Cash','  General','400.00','0.00','0.00','0.0','12','202306071218',NULL,NULL,NULL,NULL,NULL),(13,'20230607-000016','950.00','admin','2023 06 07','  Cash','  General','950.00','0.00','0.00','0.0','13','202306071221',NULL,NULL,NULL,NULL,NULL),(14,'20230607-000017','1030.00','admin','2023 06 07','  Cash','  General','1030.00','0.00','0.00','0.0','14','202306071228',NULL,NULL,NULL,NULL,NULL),(15,'20230607-000018','200.00','admin','2023 06 07','  Cash','  General','200.00','0.00','0.00','0.0','15','202306071257',NULL,NULL,NULL,NULL,NULL),(16,'20230607-000019','40.00','admin','2023 06 07','  Cash','  General','40.00','0.00','0.00','0.0','16','202306071301',NULL,NULL,NULL,NULL,NULL),(17,'20230607-0000110','1350.00','admin','2023 06 07','  Cash','  General','1350.00','0.00','0.00','0.0','17','202306071324',NULL,NULL,NULL,NULL,NULL),(18,'20230607-0000111','1300.00','admin','2023 06 07','  Cash','  General','1300.00','0.00','0.00','0.0','18','202306071327',NULL,NULL,NULL,NULL,NULL),(19,'20230607-0000112','100.00','admin','2023 06 07','  Cash','  General','100.00','0.00','0.00','0.0','19','202306071329',NULL,NULL,NULL,NULL,NULL),(20,'20230607-0000113','110.00','admin','2023 06 07','  Cash','  General','110.00','0.00','0.00','0.0','20','202306071350',NULL,NULL,NULL,NULL,NULL),(21,'20230607-0000114','600.00','admin','2023 06 07','  Cash','  General','600.00','0.00','0.00','0.0','21','202306071546',NULL,NULL,NULL,NULL,NULL),(22,'20230607-0000115','1000.00','admin','2023 06 07','  Cash','  General','1000.00','0.00','0.00','0.0','22','202306071547',NULL,NULL,NULL,NULL,NULL),(23,'20230607-0000116','1300.00','admin','2023 06 07','  Cash','  General','1300.00','0.00','0.00','0.0','23','202306071551',NULL,NULL,NULL,NULL,NULL),(24,'20230607-000031','270.00','admin','2023 06 07','  Cash','  General','270.00','0.00','0.00','0.0','24','202306071719',NULL,NULL,NULL,NULL,NULL),(25,'20230607-000032','75.00','admin','2023 06 07','  Cash','  General','75.00','0.00','0.00','0.0','25','202306071720',NULL,NULL,NULL,NULL,NULL),(26,'20230607-000033','350.00','admin','2023 06 07','  Cash','  General','350.00','0.00','0.00','0.0','26','202306071745',NULL,NULL,NULL,NULL,NULL),(27,'20230608-000011','450.00','admin','2023 06 08','  Cash','  General','450.00','0.00','0.00','0.0','27','202306081042',NULL,NULL,NULL,NULL,NULL),(28,'20230608-000012','240.00','admin','2023 06 08','  Cash','  General','240.00','0.00','0.00','0.0','28','202306081043',NULL,NULL,NULL,NULL,NULL),(29,'20230609-000011','420.00','admin','2023 06 09','  Cash','  General','420.00','0.00','0.00','0.0','29','202306091322',NULL,NULL,NULL,NULL,NULL),(30,'20230609-000012','1150.00','admin','2023 06 09','  Cash','  General','1150.00','0.00','0.00','0.0','30','202306091325',NULL,NULL,NULL,NULL,NULL),(31,'20230609-000013','5200.00','admin','2023 06 09','  Cash','  General','5200.00','0.00','0.00','0.0','31','202306091609',NULL,NULL,NULL,NULL,NULL),(32,'20230609-000014','60.00','admin','2023 06 09','  Cash','  General','60.00','0.00','0.00','0.0','32','202306091637',NULL,NULL,NULL,NULL,NULL),(33,'20230609-000015','600.00','admin','2023 06 09','  Cash','  General','600.00','0.00','0.00','0.0','33','202306091639',NULL,NULL,NULL,NULL,NULL),(34,'20230609-000016','1464.00','admin','2023 06 09','  Cash','  General','1464.00','0.00','0.00','0.0','34','202306091646',NULL,NULL,NULL,NULL,NULL),(35,'20230609-000017','1120.00','admin','2023 06 09','  Cash','  General','1120.00','0.00','0.00','0.0','35','202306091729',NULL,NULL,NULL,NULL,NULL),(36,'20230609-000018','162.00','admin','2023 06 09','  Cash','  General','162.00','0.00','0.00','0.0','36','202306091730',NULL,NULL,NULL,NULL,NULL),(37,'20230609-000019','1250.00','admin','2023 06 09','  Cash','  General','1250.00','0.00','0.00','0.0','37','202306091819',NULL,NULL,NULL,NULL,NULL),(38,'20230609-0000110','4500.00','admin','2023 06 09','  Upiqr','  General','4500.00','0.00','0.00','0.0','38','202306091932',NULL,NULL,NULL,NULL,NULL),(39,'20230609-0000111','150.00','admin','2023 06 09','  Cash','  General','150.00','0.00','0.00','0.0','39','202306091944',NULL,NULL,NULL,NULL,NULL),(40,'20230610-000011','2000.00','admin','2023 06 10','  Cash','  General','2000.00','0.00','0.00','0.0','40','202306101146',NULL,NULL,NULL,NULL,NULL),(41,'20230610-000012','750.00','admin','2023 06 10','  Cash','  General','750.00','0.00','0.00','0.0','41','202306101212',NULL,NULL,NULL,NULL,NULL),(42,'20230610-000013','3800.00','admin','2023 06 10','  Cash','  General','3800.00','0.00','0.00','0.0','42','202306101212',NULL,NULL,NULL,NULL,NULL),(43,'20230610-000014','300.00','admin','2023 06 10','  Cash','  General','300.00','0.00','0.00','0.0','43','202306101214',NULL,NULL,NULL,NULL,NULL),(44,'20230610-000015','12816.00','admin','2023 06 10','  Cash','  General','12816.00','0.00','0.00','0.0','44','202306101229',NULL,NULL,NULL,NULL,NULL),(45,'20230610-000016','4750.00','admin','2023 06 10','  Cash','  General','4750.00','0.00','0.00','0.0','45','202306101441','9865252882',NULL,NULL,NULL,NULL),(46,'20230612-000011','1700.00','admin','2023 06 12','  Upiqr','  General','1700.00','0.00','0.00','0.0','46','202306121114',NULL,NULL,NULL,NULL,NULL),(47,'20230612-000012','2770.00','admin','2023 06 12','  Cash','  General','2770.00','0.00','0.00','0.0','47','202306121131',NULL,NULL,NULL,NULL,NULL),(48,'20230612-000013','650.00','admin','2023 06 12','  Cash','  General','650.00','0.00','0.00','0.0','48','202306121326',NULL,NULL,NULL,NULL,NULL),(49,'20230612-000014','1150.00','admin','2023 06 12','  Cash','  General','1150.00','0.00','0.00','0.0','49','202306121553',NULL,NULL,NULL,NULL,NULL),(50,'20230612-000015','450.00','admin','2023 06 12','  Cash','  General','450.00','0.00','0.00','0.0','50','202306121609',NULL,NULL,NULL,NULL,NULL),(51,'20230612-000016','3500.00','admin','2023 06 12','  Cash','  General','3500.00','0.00','0.00','0.0','51','202306121901',NULL,NULL,NULL,NULL,NULL),(52,'20230612-000017','1000.00','admin','2023 06 12','  Cash','  General','1000.00','0.00','0.00','0.0','52','202306121902',NULL,NULL,NULL,NULL,NULL),(53,'20230612-000018','975.00','admin','2023 06 12','  Cash','  General','975.00','0.00','0.00','0.0','53','202306121910',NULL,NULL,NULL,NULL,NULL),(54,'20230612-000019','6580.00','admin','2023 06 12','  Cash','  General','6580.00','0.00','0.00','0.0','54','202306121919',NULL,NULL,NULL,NULL,NULL),(55,'20230612-0000110','650.00','admin','2023 06 12','  Cash','  General','650.00','0.00','0.00','0.0','55','202306121930',NULL,NULL,NULL,NULL,NULL),(56,'20230613-000011','0','admin','2023 06 13','  Cash','  General','0.0','0.0','0.0','0.0','56','202306131249',NULL,NULL,NULL,NULL,NULL),(57,'20230613-000012','650.00','admin','2023 06 13','  Upiqr','  General','650.00','0.00','0.00','0.0','57','202306131259',NULL,NULL,NULL,NULL,NULL),(58,'20230613-000013','660.00','admin','2023 06 13','  Cash','  General','660.00','0.00','0.00','0.0','58','202306131601',NULL,NULL,NULL,NULL,NULL),(59,'20230613-000014','17220.00','admin','2023 06 13','  Cash','  General','17220.00','0.00','0.00','0.0','59','202306131615',NULL,NULL,NULL,NULL,NULL),(60,'20230613-000015','250.00','admin','2023 06 13','  Cash','  General','250.00','0.00','0.00','0.0','60','202306131617',NULL,NULL,NULL,NULL,NULL),(61,'20230613-000016','870.00','admin','2023 06 13','  Cash','  General','870.00','0.00','0.00','0.0','61','202306131618',NULL,NULL,NULL,NULL,NULL),(62,'20230613-000017','2200.00','admin','2023 06 13','  Cash','  General','2200.00','0.00','0.00','0.0','62','202306131621',NULL,NULL,NULL,NULL,NULL),(63,'20230613-000018','3750.00','admin','2023 06 13','  Cash','  General','3750.00','0.00','0.00','0.0','63','202306131625',NULL,NULL,NULL,NULL,NULL),(64,'20230613-000019','1000.00','admin','2023 06 13','  Cash','  General','1000.00','0.00','0.00','0.0','64','202306131647',NULL,NULL,NULL,NULL,NULL),(65,'20230613-0000110','200.00','admin','2023 06 13','  Cash','  General','200.00','0.00','0.00','0.0','65','202306131811',NULL,NULL,NULL,NULL,NULL),(66,'20230613-0000111','135.00','admin','2023 06 13','  Cash','  General','135.00','0.00','0.00','0.0','66','202306131815',NULL,NULL,NULL,NULL,NULL),(67,'20230613-0000112','980.00','admin','2023 06 13','  Cash','  General','980.00','0.00','0.00','0.0','67','202306131818',NULL,NULL,NULL,NULL,NULL),(68,'20230613-0000113','1050.00','admin','2023 06 13','  Cash','  General','1050.00','0.00','0.00','0.0','68','202306131829',NULL,NULL,NULL,NULL,NULL),(69,'20230613-0000114','200.00','admin','2023 06 13','  Cash','  General','200.00','0.00','0.00','0.0','69','202306131832',NULL,NULL,NULL,NULL,NULL),(70,'20230613-0000115','1200.00','admin','2023 06 13','  Cash','  General','1200.00','0.00','0.00','0.0','70','202306131918',NULL,NULL,NULL,NULL,NULL),(71,'20230614-000011','480.00','admin','2023 06 14','  Cash','  General','480.00','0.00','0.00','0.0','71','202306141014',NULL,NULL,NULL,NULL,NULL),(72,'20230614-000012','2250.00','admin','2023 06 14','  Cash','  General','2250.00','0.00','0.00','0.0','72','202306141019',NULL,NULL,NULL,NULL,NULL),(73,'20230614-000013','60.00','admin','2023 06 14','  Cash','  General','60.00','0.00','0.00','0.0','73','202306141436',NULL,NULL,NULL,NULL,NULL),(74,'20230614-000014','300.00','admin','2023 06 14','  Cash','  General','300.00','0.00','0.00','0.0','74','202306141710',NULL,NULL,NULL,NULL,NULL),(75,'20230614-000015','1030.00','admin','2023 06 14','  Cash','  General','1030.00','0.00','0.00','0.0','75','202306141909',NULL,NULL,NULL,NULL,NULL),(76,'20230614-000016','250.00','admin','2023 06 14','  Cash','  General','250.00','0.00','0.00','0.0','76','202306141914',NULL,NULL,NULL,NULL,NULL),(77,'20230614-000017','419.00','admin','2023 06 14','  Cash','  General','419.00','0.00','0.00','0.0','77','202306141916',NULL,NULL,NULL,NULL,NULL),(78,'20230615-000011','145.00','admin','2023 06 15','  Cash','  Home delivery','145.00','0.00','0.00','0.0','78','202306151447',NULL,NULL,NULL,NULL,NULL),(79,'20230615-000012','1000.00','admin','2023 06 15','  Cash','  General','1000.00','0.00','0.00','0.0','79','202306151449',NULL,NULL,NULL,NULL,NULL),(80,'20230615-000013','838.00','admin','2023 06 15','  Cash','  General','838.00','0.00','0.00','0.0','80','202306151453',NULL,NULL,NULL,NULL,NULL),(81,'20230615-000014','90.00','admin','2023 06 15','  Cash','  General','90.00','0.00','0.00','0.0','81','202306151454',NULL,NULL,NULL,NULL,NULL),(82,'20230615-000015','750.00','admin','2023 06 15','  Cash','  General','750.00','0.00','0.00','0.0','82','202306151844',NULL,NULL,NULL,NULL,NULL),(83,'20230615-000016','600.00','admin','2023 06 15','  Cash','  General','600.00','0.00','0.00','0.0','83','202306151846',NULL,NULL,NULL,NULL,NULL),(84,'20230616-000011','520.00','admin','2023 06 16','  Cash','  General','520.00','0.00','0.00','0.0','84','202306161103',NULL,NULL,NULL,NULL,NULL),(85,'20230616-000012','350.00','admin','2023 06 16','  Cash','  General','350.00','0.00','0.00','0.0','85','202306161337',NULL,NULL,NULL,NULL,NULL),(86,'20230616-000013','220.00','admin','2023 06 16','  Cash','  General','220.00','0.00','0.00','0.0','86','202306161616',NULL,NULL,NULL,NULL,NULL),(87,'20230616-000014','1760.00','admin','2023 06 16','  Cash','  General','1760.00','0.00','0.00','0.0','87','202306161842',NULL,NULL,NULL,NULL,NULL),(88,'20230616-000015','2300.00','admin','2023 06 16','  Cash','  General','2300.00','0.00','0.00','0.0','88','202306161851',NULL,NULL,NULL,NULL,NULL),(89,'20230616-000016','780.00','admin','2023 06 16','  Cash','  General','780.00','0.00','0.00','0.0','89','202306161853',NULL,NULL,NULL,NULL,NULL),(90,'20230616-000017','720.00','admin','2023 06 16','  Cash','  General','720.00','0.00','0.00','0.0','90','202306161859',NULL,NULL,NULL,NULL,NULL),(91,'20230616-000018','400.00','admin','2023 06 16','  Cash','  General','400.00','0.00','0.00','0.0','91','202306161859',NULL,NULL,NULL,NULL,NULL),(92,'20230616-000019','3500.00','admin','2023 06 16','  Cash','  General','3500.00','0.00','0.00','0.0','92','202306161900',NULL,NULL,NULL,NULL,NULL),(93,'20230616-0000110','0','admin','2023 06 16','  Cash','  General','0.0','0.0','0.0','0.0','93','202306161910',NULL,NULL,NULL,NULL,NULL),(94,'20230616-0000111','300.00','admin','2023 06 16','  Cash','  General','300.00','0.00','0.00','0.0','94','202306161911',NULL,NULL,NULL,NULL,NULL),(95,'20230617-000011','0','admin','2023 06 17','  Cash','  General','0.0','0.0','0.0','0.0','95','202306171549',NULL,NULL,NULL,NULL,NULL),(96,'20230617-000012','2800.00','admin','2023 06 17','  Upiqr','  General','2800.00','0.00','0.00','0.0','96','202306171602',NULL,NULL,NULL,NULL,NULL),(97,'20230619-000011','1000.00','admin','2023 06 19','  Cash','  General','1000.00','0.00','0.00','0.0','97','202306192026',NULL,NULL,NULL,NULL,NULL),(98,'20230619-000012','250.00','admin','2023 06 19','  Cash','  General','250.00','0.00','0.00','0.0','98','202306192027',NULL,NULL,NULL,NULL,NULL),(99,'20230619-000013','1000.00','admin','2023 06 19','  Cash','  General','1000.00','0.00','0.00','0.0','99','202306192028',NULL,NULL,NULL,NULL,NULL),(100,'20230619-000014','200.00','admin','2023 06 19','  Cash','  General','200.00','0.00','0.00','0.0','100','202306192029',NULL,NULL,NULL,NULL,NULL),(101,'20230619-000015','590.00','admin','2023 06 19','  Cash','  General','590.00','0.00','0.00','0.0','101','202306192031',NULL,NULL,NULL,NULL,NULL),(102,'20230619-000016','110.00','admin','2023 06 19','  Cash','  General','110.00','0.00','0.00','0.0','102','202306192032',NULL,NULL,NULL,NULL,NULL),(103,'20230619-000017','240.00','admin','2023 06 19','  Cash','  General','240.00','0.00','0.00','0.0','103','202306192035',NULL,NULL,NULL,NULL,NULL),(104,'20230619-000018','400.00','admin','2023 06 19','  Cash','  General','400.00','0.00','0.00','0.0','104','202306192036',NULL,NULL,NULL,NULL,NULL),(105,'20230620-000011','395.00','admin','2023 06 20','  Cash','  General','395.00','0.00','0.00','0.0','105','202306201241',NULL,NULL,NULL,NULL,NULL),(106,'20230620-000012','370.00','admin','2023 06 20','  Cash','  General','370.00','0.00','0.00','0.0','106','202306201246',NULL,NULL,NULL,NULL,NULL),(107,'20230620-000013','700.00','admin','2023 06 20','  Cash','  General','700.00','0.00','0.00','0.0','107','202306201313',NULL,NULL,NULL,NULL,NULL),(108,'20230620-000014','100.00','admin','2023 06 20','  Cash','  General','100.00','0.00','0.00','0.0','108','202306201434',NULL,NULL,NULL,NULL,NULL),(109,'20230620-000015','100.00','admin','2023 06 20','  Cash','  General','100.00','0.00','0.00','0.0','109','202306201435',NULL,NULL,NULL,NULL,NULL),(110,'20230620-000016','70.00','admin','2023 06 20','  Cash','  General','70.00','0.00','0.00','0.0','110','202306201436',NULL,NULL,NULL,NULL,NULL),(111,'20230620-000031','800.00','admin','2023 06 20','  Cash','  General','800.00','0.00','0.00','0.0','111','202306201438',NULL,NULL,NULL,NULL,NULL),(112,'20230620-000032','450.00','admin','2023 06 20','  Cash','  General','450.00','0.00','0.00','0.0','112','202306201515',NULL,NULL,NULL,NULL,NULL),(113,'20230620-000017','600.00','admin','2023 06 20','  Upiqr','  General','600.00','0.00','0.00','0.0','113','202306201956',NULL,NULL,NULL,NULL,NULL),(114,'20230620-000018','2750.00','admin','2023 06 20','  Cash','  General','2750.00','0.00','0.00','0.0','114','202306202019',NULL,NULL,NULL,NULL,NULL),(115,'20230621-000011','1250.00','admin','2023 06 21','  Cash','  General','1250.00','0.00','0.00','0.0','115','202306211657',NULL,NULL,NULL,NULL,NULL),(116,'20230621-000012','200.00','admin','2023 06 21','  Cash','  General','200.00','0.00','0.00','0.0','116','202306211801',NULL,NULL,NULL,NULL,NULL),(117,'20230621-000013','245.00','admin','2023 06 21','  Cash','  General','245.00','0.00','0.00','0.0','117','202306211803',NULL,NULL,NULL,NULL,NULL),(118,'20230621-000014','1200.00','admin','2023 06 21','  Cash','  General','1200.00','0.00','0.00','0.0','118','202306211852',NULL,NULL,NULL,NULL,NULL),(119,'20230621-000015','320.00','admin','2023 06 21','  Cash','  General','320.00','0.00','0.00','0.0','119','202306211855',NULL,NULL,NULL,NULL,NULL),(120,'20230621-000016','140.00','admin','2023 06 21','  Cash','  General','140.00','0.00','0.00','0.0','120','202306211902',NULL,NULL,NULL,NULL,NULL),(121,'20230621-000017','300.00','admin','2023 06 21','  Upiqr','  General','300.00','0.00','0.00','0.0','121','202306211904',NULL,NULL,NULL,NULL,NULL),(122,'20230622-000011','150.00','admin','2023 06 22','  Cash','  General','150.00','0.00','0.00','0.0','122','202306221150',NULL,NULL,NULL,NULL,NULL),(123,'20230622-000012','150.00','admin','2023 06 22','  Cash','  General','150.00','0.00','0.00','0.0','123','202306221153',NULL,NULL,NULL,NULL,NULL),(124,'20230622-000013','240.00','admin','2023 06 22','  Cash','  General','240.00','0.00','0.00','0.0','124','202306221228',NULL,NULL,NULL,NULL,NULL),(125,'20230622-000014','1200.00','admin','2023 06 22','  Cash','  General','1200.00','0.00','0.00','0.0','125','202306221308',NULL,NULL,NULL,NULL,NULL),(126,'20230622-000015','450.00','admin','2023 06 22','  Cash','  General','450.00','0.00','0.00','0.0','126','202306221332',NULL,NULL,NULL,NULL,NULL),(127,'20230622-000016','100.00','admin','2023 06 22','  Cash','  General','100.00','0.00','0.00','0.0','127','202306221839',NULL,NULL,NULL,NULL,NULL),(128,'20230622-000017','2700.00','admin','2023 06 22','  Cash','  General','2700.00','0.00','0.00','0.0','128','202306221908',NULL,NULL,NULL,NULL,NULL),(129,'20230622-000018','1500.00','admin','2023 06 22','  Cash','  General','1500.00','0.00','0.00','0.0','129','202306221953',NULL,NULL,NULL,NULL,NULL),(130,'20230623-000011','1900.00','admin','2023 06 23','  Cash','  General','1900.00','0.00','0.00','0.0','130','202306231100',NULL,NULL,NULL,NULL,NULL),(131,'20230623-000012','185.00','admin','2023 06 23','  Cash','  General','185.00','0.00','0.00','0.0','131','202306231253',NULL,NULL,NULL,NULL,NULL),(132,'20230623-000013','1750.00','admin','2023 06 23','  Cash','  General','1750.00','0.00','0.00','0.0','132','202306231301',NULL,NULL,NULL,NULL,NULL),(133,'20230623-000014','2350.00','admin','2023 06 23','  Cash','  General','2350.00','0.00','0.00','0.0','133','202306231646',NULL,NULL,NULL,NULL,NULL),(134,'20230623-000015','350.00','admin','2023 06 23','  Cash','  General','350.00','0.00','0.00','0.0','134','202306231908',NULL,NULL,NULL,NULL,NULL),(135,'20230624-000011','1325.00','admin','2023 06 24','  Cash','  General','1325.00','0.00','0.00','0.0','135','202306241345',NULL,NULL,NULL,NULL,NULL),(136,'20230626-000011','1480.00','admin','2023 06 26','  Upiqr','  General','1480.00','0.00','0.00','0.0','136','202306261448',NULL,NULL,NULL,NULL,NULL),(137,'20230627-000011','250.00','admin','2023 06 27','  Cash','  General','250.00','0.00','0.00','0.0','137','202306271233',NULL,NULL,NULL,NULL,NULL),(138,'20230628-000011','1100.00','admin','2023 06 28','  Cash','  General','1100.00','0.00','0.00','0.0','138','202306281424',NULL,NULL,NULL,NULL,NULL),(139,'20230628-000012','650.00','admin','2023 06 28','  Cash','  General','650.00','0.00','0.00','0.0','139','202306281904',NULL,NULL,NULL,NULL,NULL),(140,'20230629-000011','254.00','admin','2023 06 29','  Cash','  General','254.00','0.00','0.00','0.0','140','202306291246',NULL,NULL,NULL,NULL,NULL),(141,'20230629-000012','0','admin','2023 06 29','  Cash','  General','0.0','0.0','0.0','0.0','141','202306291446',NULL,NULL,NULL,NULL,NULL),(142,'20230630-000011','1000.00','admin','2023 06 30','  Upiqr','  General','1000.00','0.00','0.00','0.0','142','202306302102',NULL,NULL,NULL,NULL,NULL),(143,'20230630-000012','250.00','admin','2023 06 30','  Upiqr','  General','250.00','0.00','0.00','0.0','143','202306302104',NULL,NULL,NULL,NULL,NULL),(144,'20230704-000011','400.00','admin','2023 07 04','  Cash','  General','400.00','0.00','0.00','0.0','144','202307041651',NULL,NULL,NULL,NULL,NULL),(145,'20230704-000012','1450.00','admin','2023 07 04','  Cash','  General','1450.00','0.00','0.00','0.0','145','202307041733',NULL,NULL,NULL,NULL,NULL),(146,'20230704-000013','2760.00','admin','2023 07 04','  Upiqr','  General','2760.00','0.00','0.00','0.0','146','202307042020',NULL,NULL,NULL,NULL,NULL),(147,'20230706-000011','1250.00','admin','2023 07 06','  Cash','  General','1250.00','0.00','0.00','0.0','147','202307061343',NULL,NULL,NULL,NULL,NULL),(148,'20230708-000011','1150.00','admin','2023 07 08','  Cash','  General','1150.00','0.00','0.00','0.0','148','202307081330',NULL,NULL,NULL,NULL,NULL),(149,'20230708-000012','0','admin','2023 07 08','  Cash','  General','0.0','0.0','0.0','0.0','149','202307081331',NULL,NULL,NULL,NULL,NULL),(150,'20230711-000011','600.00','admin','2023 07 11','  Cash','  General','600.00','0.00','0.00','0.0','150','202307111135',NULL,NULL,NULL,NULL,NULL),(151,'20230923-000011','15.00','admin','2023 09 23','  Cash','  General','15.00','0.00','0.00','0.0','1','202309231215',NULL,NULL,NULL,NULL,NULL),(152,'20230923-000012','15.00','admin','2023 09 23','  Cash','  General','15.00','0.00','0.00','0.0','2','202309231229',NULL,NULL,NULL,NULL,NULL),(153,'20240125-000011','8150.00','admin','2024 01 25','  Upiqr','  General','8150.00','0.00','0.00','0.0','1','202401251223',NULL,NULL,NULL,NULL,NULL),(154,'20240221-000011','1080.00','ladmin','2024 02 21','  Cash','  General','1080.00','0.00','0.00','0.0','2','202402211409',NULL,NULL,NULL,NULL,NULL),(155,'20240221-000012','600.00','ladmin','2024 02 21','  Cash','  General','600.00','0.00','0.00','0.0','3','202402211410',NULL,NULL,NULL,NULL,NULL),(156,'20240221-000013','1150.00','admin','2024 02 21','  Cash','  General','1150.00','0.00','0.00','0.0','4','202402211734',NULL,NULL,NULL,NULL,NULL),(157,'20240221-000014','2550.00','admin','2024 02 21','  Cash','  General','2550.00','0.00','0.00','0.0','5','202402211834',NULL,NULL,NULL,NULL,NULL),(158,'20240221-000031','916.00','admin','2024 02 21','  Cash','  General','916.00','0.00','0.00','0.0','6','202402211836',NULL,NULL,NULL,NULL,NULL),(159,'20240221-000015','1150.00','admin','2024 02 21','  Cash','  General','1150.00','0.00','0.00','0.0','7','202402211854',NULL,NULL,NULL,NULL,NULL),(160,'20240222-000021','2550.00','user4','2024 02 22','  Cash','  General','2550.00','0.00','0.00','0.0','8','202402221140',NULL,NULL,NULL,NULL,NULL),(161,'20240426-000021','2300.00','admin','2024 04 26','  Cash','  General','2300.00','0.00','0.00','0.0','1','202404261642',NULL,NULL,NULL,NULL,NULL),(162,'20240426-000022','1150.00','admin','2024 04 26','  Cash','  General','1150.00','0.00','0.00','0.0','2','202404261653',NULL,NULL,NULL,NULL,NULL),(163,'20240426-000023','240.00','admin','2024 04 26','  Cash','  General','240.00','0.00','0.00','0.0','3','202404261654',NULL,NULL,NULL,NULL,NULL),(164,'20240514-000021','240.00','user4','2024 05 14','  Cash','  General','240.00','0.00','0.00','0.0','4','202405141842',NULL,NULL,NULL,NULL,NULL),(165,'20240514-000022','1150.00','user4','2024 05 14','  Cash','  General','1150.00','0.00','0.00','0.0','5','202405141843',NULL,NULL,NULL,NULL,NULL),(166,'20240514-000023','1150.00','user4','2024 05 14','  Cash','  General','1150.00','0.00','0.00','0.0','6','202405141847',NULL,NULL,NULL,NULL,NULL),(167,'20240514-000024','590.00','user4','2024 05 14','  Cash','  General','500.00','90.00','0.00','0.0','7','202405141851',NULL,NULL,NULL,NULL,NULL),(168,'20240514-000025','755.00','user4','2024 05 14','  Cash','  General','500.00','255.00','0.00','33.0','8','202405141942',NULL,NULL,NULL,NULL,NULL),(169,'20240514-000026','755.00','user4','2024 05 14','  Cash','  General','500.00','255.00','0.00','33.0','9','202405141943',NULL,NULL,NULL,NULL,NULL),(170,'20240514-000027','755.00','user4','2024 05 14','  Cash','  General','500.00','255.00','0.00','33.0','10','202405141945',NULL,NULL,NULL,NULL,NULL),(171,'20240611-000021','1529.50','admin','2024 06 11','  Cash','  General','1150.00','379.50','0.00','33.0','11','202406111258',NULL,NULL,NULL,NULL,NULL),(172,'20240611-000022','1529.50','admin','2024 06 11','  Cash','  General','1150.00','379.50','0.00','33.0','12','202406111259',NULL,NULL,NULL,NULL,NULL),(173,'20240611-000023','86.45','admin','2024 06 11','  Cash','  General','65.00','21.45','0.00','33.0','13','202406111303',NULL,NULL,NULL,NULL,NULL),(174,'20240611-000024','86.45','admin','2024 06 11','  Cash','  General','65.00','21.45','0.00','33.0','14','202406111304',NULL,NULL,NULL,NULL,NULL),(175,'20240611-000025','1529.50','admin','2024 06 11','  Cash','  General','1150.00','379.50','0.00','33.0','15','202406111305',NULL,NULL,NULL,NULL,NULL),(176,'20240611-000026','4867.80','admin','2024 06 11','  Upiqr','  General','3660.00','1207.80','0.00','33.0','16','202406111306',NULL,NULL,NULL,NULL,NULL),(177,'20240727-000021','3318.35','admin','2024 07 27','  Cash','  General','2495.00','823.35','0.00','33.0','17','202407271453',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `cancelwiseorderlistitems` (`_id`, `date`, `time`, `user`, `billno`, `sale`, `refund`, `reason`, `billcount`) VALUES (2,'16 Jun 2023','07:13:43 PM','admin','20230616-0000110','3000.00','3000.00','amount value changed','93'),(3,'16 Jun 2023','07:13:43 PM','admin','20230616-0000110','3000.00','3000.00','amount value changed',NULL),(4,'10 Jul 2023','10:27:56 AM','admin','20230708-000012','1150.00','1150.00','demo bill',NULL);
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,'Raj','9843038965','','',1150,'0.0',NULL,NULL,NULL),(3,'ATLANTIC VITIO','9443726237','','',1030,'0.0',NULL,NULL,NULL),(5,'KISHORE','9003831171','','CBE',350,'0.0',NULL,NULL,NULL),(6,'MOHAN','9842222217','','',1700,'0.0',NULL,NULL,NULL),(7,'Mani Bharathi','6380768827','','',1200,'0.0',NULL,NULL,NULL),(8,'shan','0000000000','','1a',145,'0.0',NULL,NULL,NULL);
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'DC NODE',1150),(2,'ONT',1750),(3,'4WAY SPLITTER 4S1',150),(4,'SHARP COUPLER 90:10 ',280),(5,'US OPTICAL PATCH CORD BLUE',65),(6,'US OPTICAL PATCH CORD GREEN',130),(7,'VX F5 CONNECTOR',150),(8,'US OPTICAL PATCH CORD BLUE',65),(9,'US OPTICAL PATCH CORD GREEN',130),(10,'VX F5 CONNECTOR',150),(11,'VX F5 CONNECTOR',150),(12,'VX F5 CONNECTOR',150),(13,'SPARSH 4:1 VDA',1450),(14,'SPARSH 4:1 VDA',1450),(15,'US 16 AC NODE',1300),(16,'TELVASS 8OUT DC NODE',900),(17,'US 16 AC NODE',1300),(18,'US 4OUT FTTH',400),(19,'SPARSH 4:1 VDA',1450),(20,'TELVASS 8OUT DC NODE',900),(21,'US 16 AC NODE',1300),(22,'US 4OUT FTTH',400),(23,'USB EXTENDER 50 MTRS',250),(24,'VX F5 CONNECTOR',250);
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,'1599','DC NODE',1150,100,'1','SHARP',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'1600','ONT',1750,18,'1','netlink',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'1614','4WAY SPLITTER 4S1',150,15,'2','SHARP',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'1616','SHARP COUPLER 90:10 ',280,27,'2','SHARP',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'1617','US OPTICAL PATCH CORD BLUE',65,6,'1','UNITED SYSTEM',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'1618','US OPTICAL PATCH CORD GREEN',130,13,'2','UNITED SYSTEM',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'1615','VX F5 CONNECTOR',150,15,'25','SHARP',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'1617','US OPTICAL PATCH CORD BLUE',65,3,'1','UNITED SYSTEM',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'1618','US OPTICAL PATCH CORD GREEN',130,6,'2','UNITED SYSTEM',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'1615','VX F5 CONNECTOR',150,7,'25','SHARP',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'1615','VX F5 CONNECTOR',150,6,'25','SHARP',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'1615','VX F5 CONNECTOR',150,4,'25','SHARP',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'1633','SPARSH 4:1 VDA',1450,18,'1','CCTV ACCESSORIES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'1633','SPARSH 4:1 VDA',1450,16,'1','CCTV ACCESSORIES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'1645','US 16 AC NODE',1300,14,'1','UNITED SYSTEM',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'1647','TELVASS 8OUT DC NODE',900,7,'1','TELVASS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'1645','US 16 AC NODE',1300,11,'1','UNITED SYSTEM',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'1648','US 4OUT FTTH',400,3,'2','UNITED SYSTEM',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'1633','SPARSH 4:1 VDA',1450,11,'1','CCTV ACCESSORIES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'1647','TELVASS 8OUT DC NODE',900,7,'1','TELVASS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'1645','US 16 AC NODE',1300,10,'1','UNITED SYSTEM',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'1648','US 4OUT FTTH',400,3,'2','UNITED SYSTEM',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'1671','USB EXTENDER 50 MTRS',250,1,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'1615','VX F5 CONNECTOR',250,1,'50',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'1697','SHARP 12  V POC',1050,4,'15','SHARP',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'1691','SHARP 40 V DC P.SUPPLY',760,3,'2','SHARP',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'1602','SHARP OX724',5750,19,'5','SHARP',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'1701','TELEPHONE LINE CORD 1 MTR',75,0,'5','TELEPHONE ACCESSORIES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'1702','TELEPHONE LINE CORD 5 MTR',60,0,'1','TELEPHONE ACCESSORIES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'1623','UNITED SYSTEM DC NODE 4 OUT ',2550,8,'3','UNITED SYSTEM',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,'1692','VX I JOINTER',100,0,'10','CATV ACCESORIES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,'1631','FACE PLATE DUAL',975,1,'15','NETWORK ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,'1632','FACE PLATE FOUR',85,0,'1','NETWORK ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,'1687','FTTH BOX',60,0,'2','CATV ACCESORIES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,'1670','HDMI EXTENDDER 30 MTRS',250,0,'1','CCTV ACCESSORIES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,'1637','IFOCUSS BNC',288,0,'16','CCTV ACCESSORIES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,'1683','INSTALLATION TAPE',150,0,'15','CCTV ACCESSORIES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'1643','IO. BACK BOX',90,0,'3','NETWORK ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,'1646','IP SPRAY 500 ML',100,0,'1','CCTV ACCESSORIES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'1710','JC BOX 2 WAY BIG',90,0,'2','CATV ACCESORIES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'1696','KING COM HD.MI 35 MTR',250,0,'1','CCTV ACCESSORIES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(42,'1706','KINGCOM HDMI 3 MTRS',480,0,'2','CCTV ACCESSORIES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,'1703','LMB 200 CABLE',1050,1,'3','NETWORK ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,'1704','NET LINK DIFFERENCE AMOUNT',200,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(45,'1704','ONT',1750,1,'1','netlink',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(46,'1689','R C A PIN',80,0,'4','CCTV ACCESSORIES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(47,'1662','RAJCAB RG59+3CORE',3800,3,'4','CCTV ACCESSORIES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(48,'1627','RG 6 CCU 96',9200,7,'8','Everfocus',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(49,'1627','RG6 CCS',1800,1,'3','Everfocus',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(50,'1625','RG6 CCS 90 Mtrs',600,1,'1','Everfocus',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(51,'1624','RG6 CCS 90 mtrs',1200,1,'2','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52,'1628','RG6 CCU 128',1250,1,'1','Everfocus',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(53,'1641','RG6 RING 1 PACKET',120,0,'3','SHARP',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(54,'1693','S R F5 CONNECTOR PACK',450,0,'1','CATV ACCESORIES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(55,'1690','SC TO SC PATCH CORD',120,0,'2','NETWORK ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(56,'1622','SERVICE CHARGE',2500,2,'7','SERVICE CHARGE',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(57,'1629','SERVICE CHARGES',1100,1,'2','SERVICE CHARGE',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(58,'1680','SHARP  1WAY TAPOFF',195,0,'3','SHARP',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(59,'1681','SHARP  2WAY TAPOFF',350,0,'5','SHARP',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(60,'1682','SHARP  3WAY TAPOFF',225,0,'3','SHARP',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(61,'1708','SHARP  4WAY TAPOFF',160,0,'2','SHARP',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(62,'1640','SHARP  7WAY TAPOFF',200,0,'1','SHARP',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(63,'1697','SHARP 12  V POC',1120,1,'16','SHARP',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(64,'1691','SHARP 40 V DC P.SUPPLY',760,1,'2','SHARP',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(65,'1691','SHARP 4WAY SPLITTER 4S',300,0,'4','SHARP',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(66,'1616','SHARP COUPLER 90:10 ',280,0,'2','SHARP',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(67,'1620','SHARP I/D  4WAY SPLITTER 4S',1660,1,'24','SHARP',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(68,'1602','SHARP OX724',6900,5,'6','SHARP',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(69,'1658','SHARP POWER INSERTER',270,0,'3','SHARP',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(70,'1619','SHARP PSP 12V',1120,1,'14','SHARP',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(71,'1673','SHARP X PON ONU',1600,1,'2','SHARP',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(72,'1630','SINGLE FACEPLATE ',715,1,'13','NETWORK ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(73,'1633','SPARSH 4:1 VDA',1450,1,'1','CCTV ACCESSORIES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(74,'1701','TELEPHONE LINE CORD 1 MTR',75,0,'5','TELEPHONE ACCESSORIES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(75,'1702','TELEPHONE LINE CORD 5 MTR',60,0,'1','TELEPHONE ACCESSORIES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(76,'1659','TELVASS 8 OUT DC NODE',850,1,'1','TELVASS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(77,'1647','TELVASS 8OUT DC NODE',900,1,'1','TELVASS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(78,'1649','THICK CARD',600,1,'50','BIOMETRIC ACCESSORIES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(79,'1707','TIP SPRAY 200 ML',60,0,'1','CCTV ACCESSORIES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(80,'1623','UNITED SYSTEM DC NODE 4 OUT ',4550,4,'5','UNITED SYSTEM',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(81,'1645','US 16 AC NODE',2600,2,'2','UNITED SYSTEM',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(82,'1648','US 4OUT FTTH',400,0,'2','UNITED SYSTEM',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(83,'1617','US OPTICAL PATCH CORD BLUE',65,0,'1','UNITED SYSTEM',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(84,'1618','US OPTICAL PATCH CORD GREEN',130,0,'2','UNITED SYSTEM',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(85,'1671','USB EXTENDER 50 MTRS',250,0,'1','CCTV ACCESSORIES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(86,'1653','V K REMOTE',1750,1,'50','CATV ACCESORIES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(87,'1656','VIDEO BALLOON',455,0,'7','CCTV ACCESSORIES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(88,'1615','VX F5 CONNECTOR',400,0,'75','SHARP',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(89,'1692','VX I JOINTER',200,0,'20','CATV ACCESORIES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(90,'1671','USB EXTENDER 50 MTRS',250,0,'1','CCTV ACCESSORIES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(91,'1653','V K REMOTE',1750,1,'50','CATV ACCESORIES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(92,'1653','VIDEO BALLOON',455,0,'7','CCTV ACCESSORIES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(93,'1715','VIDEO BALLOON 5MP',880,1,'8','CCTV ACCESSORIES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(94,'1615','VX F5 CONNECTOR',400,0,'75','SHARP',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(95,'1692','VX I JOINTER',200,0,'20','CATV ACCESORIES',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (1,'SHARP',1150),(2,'SHARP',8050),(3,'netlink',1750),(4,'SHARP',8050),(5,'netlink',1750),(6,'SHARP',850),(7,'UNITED SYSTEM',195),(8,'SHARP',850),(9,'UNITED SYSTEM',195),(13,'COURIER ',50),(14,'SHARP',1950),(15,'UNITED SYSTEM',195),(16,'COURIER ',50),(17,'SHARP',1950),(18,'UNITED SYSTEM',195),(19,'COURIER ',50),(20,'SERVICE CHARGE',350),(21,'SHARP',1950),(22,'UNITED SYSTEM',195),(23,'COURIER ',50),(24,'SERVICE CHARGE',350),(25,'SHARP',1950),(26,'UNITED SYSTEM',2195),(27,'Everfocus',1200),(28,'NETWORK ITEMS',1195),(29,'Everfocus',1200),(30,'NETWORK ITEMS',1280),(31,'Everfocus',1200),(32,'NETWORK ITEMS',1280),(33,'CCTV ACCESSORIES',1450),(34,'Everfocus',1200),(35,'NETWORK ITEMS',1280),(36,'SERVICE CHARGE',400),(42,'CCTV ACCESSORIES',1580),(43,'Everfocus',3100),(44,'NETWORK ITEMS',1280),(45,'SERVICE CHARGE',400),(46,'SHARP',240),(47,'CCTV ACCESSORIES',1580),(48,'Everfocus',3100),(49,'NETWORK ITEMS',2675),(50,'SERVICE CHARGE',400),(51,'SHARP',240),(52,'CCTV ACCESSORIES',1680),(53,'Everfocus',3100),(54,'NETWORK ITEMS',2675),(55,'SERVICE CHARGE',400),(56,'SHARP',240),(57,'UNITED SYSTEM',1300),(58,'CCTV ACCESSORIES',1680),(59,'Everfocus',4700),(60,'NETWORK ITEMS',2675),(61,'SERVICE CHARGE',400),(62,'SHARP',350),(63,'TELVASS',900),(64,'UNITED SYSTEM',1700),(79,'CCTV ACCESSORIES',1680),(80,'Everfocus',4700),(81,'NETWORK ITEMS',2675),(82,'SERVICE CHARGE',400),(83,'SHARP',350),(84,'TELVASS',900),(85,'UNITED SYSTEM',1700),(86,'CCTV ACCESSORIES',1680),(87,'Everfocus',4700),(88,'NETWORK ITEMS',2675),(89,'SERVICE CHARGE',400),(90,'SHARP',350),(91,'TELVASS',900),(92,'UNITED SYSTEM',1700),(121,'CCTV ACCESSORIES',1680),(122,'Everfocus',4700),(123,'NETWORK ITEMS',2675),(124,'SERVICE CHARGE',750),(125,'SHARP',695),(126,'TELVASS',900),(127,'UNITED SYSTEM',1700),(128,'CCTV ACCESSORIES',1680),(129,'Everfocus',4700),(130,'NETWORK ITEMS',2675),(131,'SERVICE CHARGE',750),(132,'SHARP',695),(133,'TELVASS',900),(134,'UNITED SYSTEM',1700),(135,'SERVICE CHARGE',450),(144,'BIOMETRIC ACCESSORIES',240),(145,'SERVICE CHARGE',450),(146,'BIOMETRIC ACCESSORIES',240),(147,'SERVICE CHARGE',450),(159,'CCTV ACCESSORIES',1680),(160,'Everfocus',4700),(161,'NETWORK ITEMS',2675),(162,'SERVICE CHARGE',750),(163,'SHARP',695),(164,'TELVASS',900),(165,'UNITED SYSTEM',1700),(166,'CCTV ACCESSORIES',1150),(167,'SHARP',420),(170,'CCTV ACCESSORIES',1150),(171,'SHARP',420),(172,'CCTV ACCESSORIES',1150),(173,'SHARP',420),(174,'BIOMETRIC ACCESSORIES',60),(175,'CATV ACCESORIES',1750),(176,'CCTV ACCESSORIES',1150),(177,'Everfocus',3450),(178,'SHARP',420),(179,'BIOMETRIC ACCESSORIES',60),(180,'CATV ACCESORIES',1750),(181,'CCTV ACCESSORIES',1750),(182,'Everfocus',3450),(183,'SHARP',420),(184,'BIOMETRIC ACCESSORIES',60),(185,'CATV ACCESORIES',1750),(186,'CCTV ACCESSORIES',1750),(187,'Everfocus',3450),(188,'NETWORK ITEMS',1364),(189,'SERVICE CHARGE',100),(190,'SHARP',420),(191,'BIOMETRIC ACCESSORIES',60),(192,'CATV ACCESORIES',1750),(193,'CCTV ACCESSORIES',1912),(194,'Everfocus',4700),(195,'NETWORK ITEMS',1364),(196,'SERVICE CHARGE',100),(197,'SHARP',690),(198,'TELVASS',850),(199,'BIOMETRIC ACCESSORIES',60),(200,'CATV ACCESORIES',1750),(201,'CCTV ACCESSORIES',1912),(202,'Everfocus',9200),(203,'NETWORK ITEMS',1364),(204,'SERVICE CHARGE',100),(205,'SHARP',690),(206,'TELVASS',850),(207,'BIOMETRIC ACCESSORIES',60),(208,'CATV ACCESORIES',1750),(209,'CCTV ACCESSORIES',1912),(210,'Everfocus',9200),(211,'NETWORK ITEMS',1364),(212,'SERVICE CHARGE',100),(213,'SHARP',690),(214,'TELVASS',850),(215,'BIOMETRIC ACCESSORIES',210),(216,'CATV ACCESORIES',1750),(217,'CCTV ACCESSORIES',1912),(218,'Everfocus',9200),(219,'NETWORK ITEMS',1364),(220,'SERVICE CHARGE',100),(221,'SHARP',690),(222,'TELVASS',850),(233,'BIOMETRIC ACCESSORIES',210),(234,'CATV ACCESORIES',1750),(235,'CCTV ACCESSORIES',1912),(236,'Everfocus',9200),(237,'NETWORK ITEMS',1364),(238,'SERVICE CHARGE',100),(239,'SHARP',690),(240,'TELVASS',850),(244,'Everfocus',2000),(245,'BIOMETRIC ACCESSORIES',300),(246,'CCTV ACCESSORIES',3800),(247,'DR COM FIBER',12816),(248,'Everfocus',2000),(249,'NETWORK ITEMS',750),(250,'BIOMETRIC ACCESSORIES',300),(251,'CCTV ACCESSORIES',3800),(252,'DR COM FIBER',12816),(253,'Everfocus',2000),(254,'NETWORK ITEMS',750),(261,'BIOMETRIC ACCESSORIES',300),(262,'CCTV ACCESSORIES',3800),(263,'DR COM FIBER',12816),(264,'Everfocus',5450),(265,'NETWORK ITEMS',750),(266,'UNITED SYSTEM',1300),(273,'BIOMETRIC ACCESSORIES',300),(274,'CCTV ACCESSORIES',3800),(275,'DR COM FIBER',12816),(276,'Everfocus',5450),(277,'NETWORK ITEMS',750),(278,'UNITED SYSTEM',1300),(279,'CCTV ACCESSORIES',2050),(280,'NETWORK ITEMS',1470),(281,'SHARP',1600),(282,'CCTV ACCESSORIES',2500),(283,'NETWORK ITEMS',1470),(284,'SHARP',2750),(288,'CCTV ACCESSORIES',2500),(289,'NETWORK ITEMS',1470),(290,'SHARP',2750),(300,'CCTV ACCESSORIES',2500),(301,'NETWORK ITEMS',1470),(302,'SHARP',2750),(303,'CCTV ACCESSORIES',2500),(304,'Everfocus',3500),(305,'NETWORK ITEMS',1470),(306,'SHARP',2750),(307,'CCTV ACCESSORIES',2600),(308,'Everfocus',8000),(309,'NETWORK ITEMS',1470),(310,'SHARP',6730),(311,'CCTV ACCESSORIES',3250),(312,'Everfocus',8000),(313,'NETWORK ITEMS',1470),(314,'SHARP',6730),(315,'CCTV ACCESSORIES',650),(323,'CATV ACCESORIES',690),(324,'CCTV ACCESSORIES',2080),(325,'Everfocus',10000),(326,'NETWORK ITEMS',120),(327,'None',600),(328,'SHARP',10210),(329,'UNITED SYSTEM',2550),(330,'CATV ACCESORIES',690),(331,'CCTV ACCESSORIES',2080),(332,'Everfocus',10000),(333,'NETWORK ITEMS',120),(334,'None',600),(335,'SHARP',10210),(336,'UNITED SYSTEM',2550),(337,'CATV ACCESORIES',690),(338,'CCTV ACCESSORIES',1430),(339,'Everfocus',10000),(340,'NETWORK ITEMS',120),(341,'None',600),(342,'SHARP',10210),(343,'UNITED SYSTEM',2550),(351,'CATV ACCESORIES',690),(352,'CCTV ACCESSORIES',2430),(353,'Everfocus',10000),(354,'NETWORK ITEMS',120),(355,'None',600),(356,'SHARP',10210),(357,'UNITED SYSTEM',2550),(358,'CATV ACCESORIES',690),(359,'CCTV ACCESSORIES',2430),(360,'Everfocus',10000),(361,'NETWORK ITEMS',120),(362,'None',600),(363,'SHARP',10210),(364,'UNITED SYSTEM',2550),(365,'CATV ACCESORIES',1890),(366,'CCTV ACCESSORIES',2430),(367,'Everfocus',10000),(368,'NETWORK ITEMS',1170),(369,'None',1400),(370,'SERVICE CHARGE',200),(371,'SHARP',10590),(372,'TELEPHONE ACCESSORIES',135),(373,'UNITED SYSTEM',2550),(374,'CCTV ACCESSORIES',480),(375,'Everfocus',2300),(376,'CCTV ACCESSORIES',540),(377,'Everfocus',2300),(378,'CCTV ACCESSORIES',540),(379,'Everfocus',2300),(383,'CCTV ACCESSORIES',540),(384,'Everfocus',2300),(385,'SERVICE CHARGE',300),(386,'CCTV ACCESSORIES',540),(387,'Everfocus',2300),(388,'SERVICE CHARGE',300),(389,'CATV ACCESORIES',100),(390,'CCTV ACCESSORIES',959),(391,'Everfocus',2300),(392,'NETWORK ITEMS',250),(393,'SERVICE CHARGE',300),(394,'SHARP',930),(395,'CATV ACCESORIES',100),(396,'CCTV ACCESSORIES',959),(397,'Everfocus',2300),(398,'NETWORK ITEMS',250),(399,'SERVICE CHARGE',300),(400,'SHARP',930),(401,'CATV ACCESORIES',90),(402,'CCTV ACCESSORIES',138),(403,'SERVICE CHARGE',700),(404,'SHARP',1145),(405,'CATV ACCESORIES',90),(406,'CCTV ACCESSORIES',138),(407,'SERVICE CHARGE',1450),(408,'SHARP',1145),(409,'CATV ACCESORIES',90),(410,'CCTV ACCESSORIES',138),(411,'Everfocus',600),(412,'SERVICE CHARGE',1450),(413,'SHARP',1145),(414,'NETWORK ITEMS',572),(419,'BIOMETRIC ACCESSORIES',750),(420,'CATV ACCESORIES',3830),(421,'CCTV ACCESSORIES',14521),(422,'COURIER ',50),(423,'DR COM FIBER',12816),(424,'Everfocus',40250),(425,'NETWORK ITEMS',8251),(426,'None',1400),(427,'SERVICE CHARGE',3600),(428,'SHARP',30780),(429,'TELEPHONE ACCESSORIES',135),(430,'TELVASS',1750),(431,'UNITED SYSTEM',7745),(432,'netlink',1750),(435,'CCTV ACCESSORIES',352),(436,'NETWORK ITEMS',572),(437,'CCTV ACCESSORIES',572),(438,'NETWORK ITEMS',572),(439,'CATV ACCESORIES',2300),(440,'CCTV ACCESSORIES',1352),(441,'NETLINK',1700),(442,'NETWORK ITEMS',572),(443,'UNITED SYSTEM',60),(444,'CATV ACCESORIES',2300),(445,'CCTV ACCESSORIES',2256),(446,'Everfocus',3500),(447,'NETLINK',1700),(448,'NETWORK ITEMS',572),(449,'SERVICE CHARGE',3700),(450,'UNITED SYSTEM',60),(451,'CATV ACCESORIES',2300),(452,'CCTV ACCESSORIES',2256),(453,'Everfocus',3500),(454,'NETLINK',1700),(455,'NETWORK ITEMS',572),(456,'SERVICE CHARGE',700),(457,'UNITED SYSTEM',60),(465,'BIOMETRIC ACCESSORIES',750),(466,'CATV ACCESORIES',6130),(467,'CCTV ACCESSORIES',16425),(468,'COURIER ',50),(469,'DR COM FIBER',12816),(470,'Everfocus',43750),(471,'NETLINK',1700),(472,'NETWORK ITEMS',8251),(473,'None',1400),(474,'SERVICE CHARGE',4300),(475,'SHARP',30780),(476,'TELEPHONE ACCESSORIES',135),(477,'TELVASS',1750),(478,'UNITED SYSTEM',7805),(479,'netlink',1750),(480,'NETLINK',3000),(481,'SHARP',395),(482,'CCTV ACCESSORIES',700),(483,'SHARP',765),(484,'CCTV ACCESSORIES',700),(485,'SHARP',765),(486,'CCTV ACCESSORIES',900),(487,'SHARP',1365),(488,'TELVASS',800),(489,'CCTV ACCESSORIES',900),(490,'NETWORK ITEMS',250),(491,'None',350),(492,'SHARP',1365),(493,'TELVASS',800),(494,'CCTV ACCESSORIES',900),(495,'Everfocus',900),(496,'NETWORK ITEMS',250),(497,'None',350),(498,'ROVA NETWORK SWITCHES',1850),(499,'SHARP',1365),(500,'TELVASS',800),(501,'Everfocus',1250),(502,'CCTV ACCESSORIES',200),(503,'Everfocus',1250),(504,'CCTV ACCESSORIES',200),(505,'Everfocus',1250),(506,'NETWORK ITEMS',245),(511,'CCTV ACCESSORIES',200),(512,'Everfocus',2450),(513,'NETWORK ITEMS',705),(514,'SERVICE CHARGE',300),(517,'CCTV ACCESSORIES',150),(518,'CCTV ACCESSORIES',300),(519,'CCTV ACCESSORIES',540),(520,'CCTV ACCESSORIES',540),(521,'CCTV ACCESSORIES',540),(522,'None',1200),(523,'CCTV ACCESSORIES',540),(524,'None',1200),(525,'ROVA NETWORK SWITCHES',450),(526,'CCTV ACCESSORIES',540),(527,'NETLINK',2700),(528,'None',1300),(529,'ROVA NETWORK SWITCHES',450),(530,'CCTV ACCESSORIES',2040),(531,'NETLINK',2700),(532,'None',1300),(533,'ROVA NETWORK SWITCHES',450),(535,'SHARP',1900),(536,'SHARP',2085),(537,'CATV ACCESORIES',1750),(538,'DR COM FIBER',1800),(539,'SHARP',2685),(540,'Everfocus',1250),(541,'SHARP',75),(542,'Everfocus',1200),(543,'SHARP',280),(544,'Everfocus',1200),(545,'SHARP',280),(548,'SHARP',1100),(549,'CATV ACCESORIES',450),(550,'SHARP',1300),(551,'CCTV ACCESSORIES',254),(552,'CCTV ACCESSORIES',254),(553,'CCTV ACCESSORIES',254),(554,'COURIER ',150),(555,'SHARP',4850),(561,'CCTV ACCESSORIES',254),(562,'COURIER ',150),(563,'SHARP',4850),(564,'CCTV ACCESSORIES',254),(565,'COURIER ',150),(566,'SHARP',4850),(567,'SERVICE CHARGE',400),(568,'CATV ACCESORIES',50),(569,'Everfocus',1400),(570,'SERVICE CHARGE',400),(571,'CATV ACCESORIES',50),(572,'Everfocus',3700),(573,'SERVICE CHARGE',400),(574,'SHARP',460),(575,'Everfocus',1250),(580,'CATV ACCESORIES',1850),(581,'None',6500),(592,'CATV ACCESORIES',1850),(593,'None',6500),(596,'CATV ACCESORIES',1850),(597,'None',6500),(634,'Everfocus',1800),(637,'Everfocus',1800),(642,'Everfocus',1800),(645,'Everfocus',1800),(646,'SHARP',1150),(649,'Everfocus',1800),(650,'SHARP',1150),(651,'Everfocus',1800),(652,'SERVICE CHARGE',350),(653,'SHARP',5416),(657,'Everfocus',1800),(658,'SERVICE CHARGE',350),(659,'SHARP',5416),(669,'CATV ACCESORIES',1850),(670,'Everfocus',1800),(671,'None',6500),(672,'SERVICE CHARGE',350),(673,'SHARP',7966),(674,'SHARP',3690),(680,'SHARP',3690),(681,'SHARP',2540),(684,'SHARP',6230),(685,'shirts',2000),(688,'SHARP',6980),(689,'UNITED SYSTEM',260);
INSERT INTO `top_reason` (`_id`, `reason`, `value`) VALUES (1,'amount value changed',1),(2,'amount changed',1),(3,'amount value changed',1),(4,'demo bill',1),(5,'wrong billed',1),(6,'amount changed',1),(7,'amount value changed',1),(8,'demo bill',1),(9,'wrong billed',1);
INSERT INTO `usercancelleddata` (`_id`, `username`, `total`) VALUES (1,'admin',650);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',1150),(2,'ladmin',1680),(3,'user4',2550);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',1150,100),(2,'ladmin',1680,59),(3,'User4',2550,14);
