INSERT INTO `all_sales` (`_id`, `itemname`, `quantity`, `price`, `total`, `type`, `parent`, `parentid`, `mod_assigned`, `tax`, `taxname`, `bill_no`, `time`, `date`, `user`, `table_id`, `billtype`, `paymentmethod`, `billamount_disapply`, `billamount_disnotapply`, `_idd`, `deleted_not`, `modifiedquantity`, `quantitycopy`, `modifiedtotal`, `date1`, `datetimee`, `disc_type`, `disc_value`, `newtotal`, `disc_thereornot`, `disc_indiv_total`, `new_modified_total`, `datetimee_new`, `hsn_code`, `taxname2`, `tax2`, `taxname3`, `tax3`, `taxname4`, `tax4`, `taxname5`, `tax5`, `category`, `counterperson_username`, `counterperson_name`, `credit`, `Phone_num`, `barcode_get`, `order_id`, `old_total`, `hsn_code2`, `hsn_code3`, `hsn_code4`, `hsn_code5`, `item_online`, `old_total_indiv`) VALUES (1,'nutella','2','170.00','340.00','Item','null','null','no','null','None','20240810-000011','11:18:12 AM','2024 08 10','madmin','1','  General','  cash','0','0','3','null','null','null','null','10Aug24','2024081011:18:12','%','0','','','','test','2024081011:18:12','','null','null','null','null','null','null','null','null','branded foods','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(2,'ladies finger kg','1','28.00','28.00','Item','null','null','no','null','None','20240810-000011','11:18:12 AM','2024 08 10','madmin','1','  General','  cash','0','0','5','null','null','null','null','10Aug24','2024081011:18:12','%','0','','','','test','2024081011:18:12','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(3,'fig fruit kg','2','250.00','500.00','Item','null','null','no','null','None','20240810-000011','11:18:12 AM','2024 08 10','madmin','1','  General','  cash','0','0','4','null','null','null','null','10Aug24','2024081011:18:12','%','0','','','','test','2024081011:18:12','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(4,'bread crumbs 300g','1','30.00','30.00','Item','null','null','no','null','None','20240810-000011','11:18:12 AM','2024 08 10','madmin','1','  General','  cash','0','0','436','null','null','null','null','10Aug24','2024081011:18:12','%','0','','','','test','2024081011:18:12','','null','null','null','null','null','null','null','null','bread bakery and eggs','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(5,'eggs 6pcs','1','38.00','38.00','Item','null','null','no','null','None','20240810-000012','11:23:54 AM','2024 08 10','madmin','1','  General','  cash','0','0','306','null','null','null','null','10Aug24','2024081011:23:54','%','0','','','','test','2024081011:23:54','','null','null','null','null','null','null','null','null','bread bakery and eggs','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(6,'sona masoori raw rice 1kg','1','56.00','56.00','Item','null','null','no','null','None','20240810-000012','11:23:54 AM','2024 08 10','madmin','1','  General','  cash','0','0','1','null','null','null','null','10Aug24','2024081011:23:54','%','0','','','','test','2024081011:23:54','','null','null','null','null','null','null','null','null','rice whole grains','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(7,'fig fruit kg','1','250.00','250.00','Item','null','null','no','null','None','20240810-000012','11:23:54 AM','2024 08 10','madmin','1','  General','  cash','0','0','4','null','null','null','null','10Aug24','2024081011:23:54','%','0','','','','test','2024081011:23:54','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(8,'eggs 6pcs','1','38.00','38.00','Item','null','null','no','null','None','20240810-000013','11:26:42 AM','2024 08 10','madmin','1','  General','  cash','0','0','306','null','null','null','null','10Aug24','2024081011:26:42','%','0','','','','test','2024081011:26:42','','null','null','null','null','null','null','null','null','bread bakery and eggs','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(9,'sona masoori raw rice 1kg','1','56.00','56.00','Item','null','null','no','null','None','20240810-000013','11:26:42 AM','2024 08 10','madmin','1','  General','  cash','0','0','1','null','null','null','null','10Aug24','2024081011:26:42','%','0','','','','test','2024081011:26:42','','null','null','null','null','null','null','null','null','rice whole grains','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(10,'fig fruit kg','1','250.00','250.00','Item','null','null','no','null','None','20240810-000013','11:26:42 AM','2024 08 10','madmin','1','  General','  cash','0','0','4','null','null','null','null','10Aug24','2024081011:26:42','%','0','','','','test','2024081011:26:42','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(11,'cauliflower kg','3','45.00','135.00','Item','null','null','no','null','None','20240810-000014','11:28:10 AM','2024 08 10','madmin','1','  General','  cash','0','0','8','null','null','null','null','10Aug24','2024081011:28:10','%','0','','','','test','2024081011:28:10','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(12,'capsicum green kg','1','80.00','80.00','Item','null','null','no','null','None','20240810-000014','11:28:10 AM','2024 08 10','madmin','1','  General','  cash','0','0','6','null','null','null','null','10Aug24','2024081011:28:10','%','0','','','','test','2024081011:28:10','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(13,'muskmelon kg','1','45.00','45.00','Item','null','null','no','null','None','20240810-000014','11:28:10 AM','2024 08 10','madmin','1','  General','  cash','0','0','33','null','null','null','null','10Aug24','2024081011:28:10','%','0','','','','test','2024081011:28:10','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(14,'capsicum green kg','1','80.00','80.00','Item','null','null','no','null','None','20240810-000015','11:33:41 AM','2024 08 10','madmin','1','  General','  cash','0','0','6','null','null','null','null','10Aug24','2024081011:33:41','%','0','','','','test','2024081011:33:41','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(15,'cauliflower kg','1','45.00','45.00','Item','null','null','no','null','None','20240810-000015','11:33:41 AM','2024 08 10','madmin','1','  General','  cash','0','0','8','null','null','null','null','10Aug24','2024081011:33:41','%','0','','','','test','2024081011:33:41','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(16,'nutella','1','170.00','170.00','Item','null','null','no','null','None','20240810-000015','11:33:41 AM','2024 08 10','madmin','1','  General','  cash','0','0','3','null','null','null','null','10Aug24','2024081011:33:41','%','0','','','','test','2024081011:33:41','','null','null','null','null','null','null','null','null','branded foods','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(17,'tata salt iodized 1kg','1','18.00','18.00','Item','null','null','no','null','None','20240812-000011','11:06:37 AM','2024 08 12','madmin','1','  General','  cash','0','0','43','null','null','null','null','12Aug24','2024081211:006:37','%','0','','','','test','2024081211:006:37','','null','null','null','null','null','null','null','null','salt and sugar','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(18,'nutella','2','170.00','340.00','Item','null','null','no','null','None','20240812-000011','11:06:37 AM','2024 08 12','madmin','1','  General','  cash','0','0','3','null','null','null','null','12Aug24','2024081211:006:37','%','0','','','','test','2024081211:006:37','','null','null','null','null','null','null','null','null','branded foods','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(19,'capsicum green kg','1','80.00','80.00','Item','null','null','no','null','None','20240812-000011','11:06:37 AM','2024 08 12','madmin','1','  General','  cash','0','0','6','null','null','null','null','12Aug24','2024081211:006:37','%','0','','','','test','2024081211:006:37','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(20,'surf excel 2kg','1','432.00','432.00','Item','null','null','no','null','None','20240812-000012','11:43:37 AM','2024 08 12','madmin','1','  General','  cash','0','0','70','null','null','null','null','12Aug24','2024081211:43:37','%','0','','','','test','2024081211:43:37','','null','null','null','null','null','null','null','null','household','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(21,'nutella','1','170.00','170.00','Item','null','null','no','null','None','20240812-000012','11:43:37 AM','2024 08 12','madmin','1','  General','  cash','0','0','3','null','null','null','null','12Aug24','2024081211:43:37','%','0','','','','test','2024081211:43:37','','null','null','null','null','null','null','null','null','branded foods','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(22,'fena powder 500gm','1','24.00','24.00','Item','null','null','no','null','None','20240812-000012','11:43:37 AM','2024 08 12','madmin','1','  General','  cash','0','0','87','null','null','null','null','12Aug24','2024081211:43:37','%','0','','','','test','2024081211:43:37','','null','null','null','null','null','null','null','null','household','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(23,'sona masoori raw rice 1kg','1','56.00','56.00','Item','null','null','no','null','None','20240812-000012','11:43:37 AM','2024 08 12','madmin','1','  General','  cash','0','0','1','null','null','null','null','12Aug24','2024081211:43:37','%','0','','','','test','2024081211:43:37','','null','null','null','null','null','null','null','null','rice whole grains','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(24,'sweet corn piece','1','15.00','15.00','Item','null','null','no','null','None','20240812-000012','11:43:37 AM','2024 08 12','madmin','1','  General','  cash','0','0','10','null','null','null','null','12Aug24','2024081211:43:37','%','0','','','','test','2024081211:43:37','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(25,'guava kg','1','90.00','90.00','Item','null','null','no','null','None','20240812-000012','11:43:37 AM','2024 08 12','madmin','1','  General','  cash','0','0','28','null','null','null','null','12Aug24','2024081211:43:37','%','0','','','','test','2024081211:43:37','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(26,'tata tea premium 250g','1','80.00','80.00','Item','null','null','no','null','None','20240812-000012','11:43:37 AM','2024 08 12','madmin','1','  General','  cash','0','0','45','null','null','null','null','12Aug24','2024081211:43:37','%','0','','','','test','2024081211:43:37','','null','null','null','null','null','null','null','null','beverages','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(27,'toor dal 500g','1','90.00','90.00','Item','null','null','no','null','None','20240812-000012','11:43:37 AM','2024 08 12','madmin','1','  General','  cash','0','0','53','null','null','null','null','12Aug24','2024081211:43:37','%','0','','','','test','2024081211:43:37','','null','null','null','null','null','null','null','null','dals and pulses','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(28,'kala namak 100gm','1','5.00','5.00','Item','null','null','no','null','None','20240812-000012','11:43:37 AM','2024 08 12','madmin','1','  General','  cash','0','0','966','null','null','null','null','12Aug24','2024081211:43:37','%','0','','','','test','2024081211:43:37','','null','null','null','null','null','null','null','null','None','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(29,'tata urad dal whole white 1kg','1','250.00','250.00','Item','null','null','no','null','None','20240814-000011','11:50:10 AM','2024 08 14','madmin','1','  General','  cash','0','0','2','null','null','null','null','14Aug24','2024081411:50:10','%','0','','','','test','2024081411:50:10','','null','null','null','null','null','null','null','null','dals pulses','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(30,'english muffins 100g','1','69.00','69.00','Item','null','null','no','null','None','20240814-000011','11:50:10 AM','2024 08 14','madmin','1','  General','  cash','0','0','305','null','null','null','null','14Aug24','2024081411:50:10','%','0','','','','test','2024081411:50:10','','null','null','null','null','null','null','null','null','bread bakery and eggs','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(31,'nutella','1','170.00','170.00','Item','null','null','no','null','None','20240814-000011','11:50:10 AM','2024 08 14','madmin','1','  General','  cash','0','0','3','null','null','null','null','14Aug24','2024081411:50:10','%','0','','','','test','2024081411:50:10','','null','null','null','null','null','null','null','null','branded foods','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(32,'T-Shirt Size M','1','660.00','660.00','Item','null','null','no','5.00','Gst(5%)','20240814-000011','11:50:10 AM','2024 08 14','madmin','1','  General','  cash','0','0','1602','null','null','null','null','14Aug24','2024081411:50:10','%','2','','','','test','2024081411:50:10','','','','','','','','','','Cloths','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(33,'Shirt Size S','1','550.00','550.00','Item','null','null','no','5','Gst(5%)','20240814-000011','11:50:10 AM','2024 08 14','madmin','1','  General','  cash','0','0','1601','null','null','null','null','14Aug24','2024081411:50:10','%','2','','','','test','2024081411:50:10','','','','','','','','','','Cloths','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(34,'T-Shirt Size M','1','660.00','660.00','Item','null','null','no','5','Gst(5%)','20240814-000012','1:06:45 PM','2024 08 14','madmin','1','  General','  cash','0','0','1602','null','null','null','null','14Aug24','2024081401:006:45','%','2','','','','test','2024081401:006:45','','','','','','','','','','Cloths','madmin','madmin','null','','WBK75T001736','test','test','test','test','test','test',NULL,NULL),(35,'capsicum green kg','1','80.00','80.00','Item','null','null','no','null','None','20240814-000012','1:06:45 PM','2024 08 14','madmin','1','  General','  cash','0','0','6','null','null','null','null','14Aug24','2024081401:006:45','%','0','','','','test','2024081401:006:45','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(36,'tata urad dal whole white 1kg','1','250.00','250.00','Item','null','null','no','null','None','20240814-000012','1:06:45 PM','2024 08 14','madmin','1','  General','  cash','0','0','2','null','null','null','null','14Aug24','2024081401:006:45','%','0','','','','test','2024081401:006:45','','null','null','null','null','null','null','null','null','dals pulses','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(37,'nutella','1','170.00','170.00','Item','null','null','no','null','None','20240814-000012','1:06:45 PM','2024 08 14','madmin','1','  General','  cash','0','0','3','null','null','null','null','14Aug24','2024081401:006:45','%','0','','','','test','2024081401:006:45','','null','null','null','null','null','null','null','null','branded foods','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(38,'fig fruit kg','1','250.00','250.00','Item','null','null','no','null','None','20240814-000012','1:06:45 PM','2024 08 14','madmin','1','  General','  cash','0','0','4','null','null','null','null','14Aug24','2024081401:006:45','%','0','','','','test','2024081401:006:45','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(39,'almond/badam 100gm','1','125.00','125.00','Item','null','null','no','null','None','20240820-000011','3:37:27 PM','2024 08 20','madmin','1','  General','  cash','0','0','971','null','null','null','null','20Aug24','2024082003:37:27','%','0','','','','test','2024082003:37:27','','null','null','null','null','null','null','null','null','dry fruits','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(40,'Shirt Size S','1','550.00','550.00','Item','null','null','no','5','Gst(5%)','20240820-000011','3:37:27 PM','2024 08 20','madmin','1','  General','  cash','0','0','1601','null','null','null','null','20Aug24','2024082003:37:27','%','2','','','','test','2024082003:37:27','','','','','','','','','','Cloths','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(41,'tata salt iodized 1kg','1','18.00','18.00','Item','null','null','no','null','None','20240820-000011','3:37:27 PM','2024 08 20','madmin','1','  General','  cash','0','0','43','null','null','null','null','20Aug24','2024082003:37:27','%','0','','','','test','2024082003:37:27','','null','null','null','null','null','null','null','null','salt and sugar','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(42,'sugar 1kg','1','45.00','45.00','Item','null','null','no','null','None','20240820-000011','3:37:27 PM','2024 08 20','madmin','1','  General','  cash','0','0','442','null','null','null','null','20Aug24','2024082003:37:27','%','0','','','','test','2024082003:37:27','','null','null','null','null','null','null','null','null','salt and sugar','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(43,'sugar 2kg','1','90.00','90.00','Item','null','null','no','null','None','20240820-000011','3:37:27 PM','2024 08 20','madmin','1','  General','  cash','0','0','443','null','null','null','null','20Aug24','2024082003:37:27','%','0','','','','test','2024082003:37:27','','null','null','null','null','null','null','null','null','salt and sugar','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(44,'parrys sugar 1kg','1','65.00','65.00','Item','null','null','no','null','None','20240820-000011','3:37:27 PM','2024 08 20','madmin','1','  General','  cash','0','0','965','null','null','null','null','20Aug24','2024082003:37:27','%','0','','','','test','2024082003:37:27','','null','null','null','null','null','null','null','null','salt and sugar','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(45,'catch table salt 100g','1','15.00','15.00','Item','null','null','no','null','None','20240820-000011','3:37:27 PM','2024 08 20','madmin','1','  General','  cash','0','0','968','null','null','null','null','20Aug24','2024082003:37:27','%','0','','','','test','2024082003:37:27','','null','null','null','null','null','null','null','null','salt and sugar','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(46,'catch table salt 200g','1','25.00','25.00','Item','null','null','no','null','None','20240820-000011','3:37:27 PM','2024 08 20','madmin','1','  General','  cash','0','0','1010','null','null','null','null','20Aug24','2024082003:37:27','%','0','','','','test','2024082003:37:27','','null','null','null','null','null','null','null','null','salt and sugar','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(47,'Oppo f1s Smart phone','1','20000.00','20000.00','Item','null','null','no','5.00','Gst(5%)','20240820-000012','3:54:55 PM','2024 08 20','madmin','1','  General','  cash','0','0','1604','null','null','null','null','20Aug24','2024082003:54:55','%','1','','','','test','2024082003:54:55','','','','','','','','','','Mobile','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(48,'Shirt Size S','1','550.00','550.00','Item','null','null','no','5','Gst(5%)','20240820-000012','3:54:55 PM','2024 08 20','madmin','1','  General','  cash','0','0','1601','null','null','null','null','20Aug24','2024082003:54:55','%','2','','','','test','2024082003:54:55','','','','','','','','','','Cloths','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(49,'nandini goodlife toned milk 500ml','1','22.00','22.00','Item','null','null','no','null','None','20240820-000012','3:54:55 PM','2024 08 20','madmin','1','  General','  cash','0','0','315','null','null','null','null','20Aug24','2024082003:54:55','%','0','','','','test','2024082003:54:55','','null','null','null','null','null','null','null','null','dairy products','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(50,'tofu 200g','1','69.00','69.00','Item','null','null','no','null','None','20240820-000012','3:54:55 PM','2024 08 20','madmin','1','  General','  cash','0','0','1577','null','null','null','null','20Aug24','2024082003:54:55','%','0','','','','test','2024082003:54:55','','null','null','null','null','null','null','null','null','dairy products','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(51,'carrots kg','1','70.00','70.00','Item','null','null','no','null','None','20240820-000013','5:03:31 PM','2024 08 20','madmin','1','  General','  cash','0','0','7','null','null','null','null','20Aug24','2024082005:003:31','%','0','','','','test','2024082005:003:31','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(52,'nutella','1','170.00','170.00','Item','null','null','no','null','None','20240820-000013','5:03:31 PM','2024 08 20','madmin','1','  General','  cash','0','0','3','null','null','null','null','20Aug24','2024082005:003:31','%','0','','','','test','2024082005:003:31','','null','null','null','null','null','null','null','null','branded foods','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(53,'surf excel 2kg','1','432.00','432.00','Item','null','null','no','null','None','20240820-000013','5:03:31 PM','2024 08 20','madmin','1','  General','  cash','0','0','70','null','null','null','null','20Aug24','2024082005:003:31','%','0','','','','test','2024082005:003:31','','null','null','null','null','null','null','null','null','household','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(54,'ghari detergent powder 1kg','1','47.00','47.00','Item','null','null','no','null','None','20240820-000013','5:03:31 PM','2024 08 20','madmin','1','  General','  cash','0','0','72','null','null','null','null','20Aug24','2024082005:003:31','%','0','','','','test','2024082005:003:31','','null','null','null','null','null','null','null','null','household','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(55,'almond/badam 200gm','1','245.00','245.00','Item','null','null','no','null','None','20240820-000013','5:03:31 PM','2024 08 20','madmin','1','  General','  cash','0','0','972','null','null','null','null','20Aug24','2024082005:003:31','%','0','','','','test','2024082005:003:31','','null','null','null','null','null','null','null','null','dry fruits','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(56,'dry apricots 200gm','1','177.00','177.00','Item','null','null','no','null','None','20240820-000013','5:03:31 PM','2024 08 20','madmin','1','  General','  cash','0','0','1377','null','null','null','null','20Aug24','2024082005:003:31','%','0','','','','test','2024082005:003:31','','null','null','null','null','null','null','null','null','dry fruits','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(57,'Shirt Size S','1','550.00','550.00','Item','null','null','no','5','Gst(5%)','20240820-000013','5:03:31 PM','2024 08 20','madmin','1','  General','  cash','0','0','1601','null','null','null','null','20Aug24','2024082005:003:31','%','2','','','','test','2024082005:003:31','','','','','','','','','','Cloths','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(58,'Keyborad','1','1000.00','1000.00','Item','null','null','no','5.00','Gst(5%)','20240820-000014','5:10:13 PM','2024 08 20','madmin','1','  General','  cash','0','0','1606','null','null','null','null','20Aug24','2024082005:10:13','%','2','','','','test','2024082005:10:13','','','','','','','','','','Computer','madmin','madmin','null','','1606','test','test','test','test','test','test',NULL,NULL),(59,'Dell Mouse USB 2.0','1','400.00','400.00','Item','null','null','no','','','20240820-000014','5:10:13 PM','2024 08 20','madmin','1','  General','  cash','0','0','1605','null','null','null','null','20Aug24','2024082005:10:13','%','0','','','','test','2024082005:10:13','','','','','','','','','','Computer','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(60,'T-Shirt Size M','1','660.00','660.00','Item','null','null','no','5','Gst(5%)','20240820-000014','5:10:13 PM','2024 08 20','madmin','1','  General','  cash','0','0','1602','null','null','null','null','20Aug24','2024082005:10:13','%','2','','','','test','2024082005:10:13','','','','','','','','','','Cloths','madmin','madmin','null','','WBK75T001736','test','test','test','test','test','test',NULL,NULL),(61,'amul whipping cream 200ml','1','39.00','39.00','Item','null','null','no','null','None','20240820-000014','5:10:13 PM','2024 08 20','madmin','1','  General','  cash','0','0','1130','null','null','null','null','20Aug24','2024082005:10:13','%','0','','','','test','2024082005:10:13','','null','null','null','null','null','null','null','null','dairy products','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(62,'ice cream butterscotch 100ml','1','20.00','20.00','Item','null','null','no','null','None','20240820-000014','5:10:13 PM','2024 08 20','madmin','1','  General','  cash','0','0','1568','null','null','null','null','20Aug24','2024082005:10:13','%','0','','','','test','2024082005:10:13','','null','null','null','null','null','null','null','null','dairy products','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(63,'sofit soya milk chocolate 200ml','1','25.00','25.00','Item','null','null','no','null','None','20240820-000014','5:10:13 PM','2024 08 20','madmin','1','  General','  cash','0','0','1580','null','null','null','null','20Aug24','2024082005:10:13','%','0','','','','test','2024082005:10:13','','null','null','null','null','null','null','null','null','dairy products','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(64,'sona masoori raw rice 1kg','1','56.00','56.00','Item','null','null','no','null','None','20240829-000011','11:51:35 AM','2024 08 29','madmin','1','  General','  cash','0','0','1','null','null','null','null','29Aug24','2024082911:51:35','%','0','','','','test','2024082911:51:35','','null','null','null','null','null','null','null','null','rice whole grains','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(65,'nutella','1','170.00','170.00','Item','null','null','no','null','None','20240829-000011','11:51:35 AM','2024 08 29','madmin','1','  General','  cash','0','0','3','null','null','null','null','29Aug24','2024082911:51:35','%','0','','','','test','2024082911:51:35','','null','null','null','null','null','null','null','null','branded foods','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(66,'parle rusk real elaichi 200g','1','25.00','25.00','Item','null','null','no','null','None','20240829-000011','11:51:35 AM','2024 08 29','madmin','1','  General','  cash','0','0','309','null','null','null','null','29Aug24','2024082911:51:35','%','0','','','','test','2024082911:51:35','','null','null','null','null','null','null','null','null','bread bakery and eggs','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(67,'rin powder500gm','1','36.00','36.00','Item','null','null','no','null','None','20240829-000011','11:51:35 AM','2024 08 29','madmin','1','  General','  cash','0','0','69','null','null','null','null','29Aug24','2024082911:51:35','%','0','','','','test','2024082911:51:35','','null','null','null','null','null','null','null','null','household','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(68,'aashirvad whole wheat atta 5kg','1','209.00','209.00','Item','null','null','no','null','None','20240829-000011','11:51:35 AM','2024 08 29','madmin','1','  General','  cash','0','0','664','null','null','null','null','29Aug24','2024082911:51:35','%','0','','','','test','2024082911:51:35','','null','null','null','null','null','null','null','null','flours and sooji','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(69,'goldwinner refined sunflower oil 1l','1','88.00','88.00','Item','null','null','no','null','None','20240829-000011','11:51:35 AM','2024 08 29','madmin','1','  General','  cash','0','0','344','null','null','null','null','29Aug24','2024082911:51:35','%','0','','','','test','2024082911:51:35','','null','null','null','null','null','null','null','null','edible oils and ghee','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(70,'Oppo f1s Smart phone','1','20000.00','20000.00','Item','null','null','no','5.00','Gst(5%)','20240829-000011','11:51:35 AM','2024 08 29','madmin','1','  General','  cash','0','0','1604','null','null','null','null','29Aug24','2024082911:51:35','%','1','','','','test','2024082911:51:35','','','','','','','','','','Mobile','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(71,'Keyborad','1','1000.00','1000.00','Item','null','null','no','5.00','Gst(5%)','20240829-000011','11:51:35 AM','2024 08 29','madmin','1','  General','  cash','0','0','1606','null','null','null','null','29Aug24','2024082911:51:35','%','2','','','','test','2024082911:51:35','','','','','','','','','','Computer','madmin','madmin','null','','1606','test','test','test','test','test','test',NULL,NULL),(72,'paracitamol 500mg','2','25.00','50.00','Item','null','null','no','','','20240829-000011','11:51:35 AM','2024 08 29','madmin','1','  General','  cash','0','0','1610','null','null','null','null','29Aug24','2024082911:51:35','%','0','','','','test','2024082911:51:35','','','','','','','','','','medicine','madmin','madmin','null','','1610','test','test','test','test','test','test',NULL,NULL),(73,'TEST ITEM','3','100.00','300.00','Item','null','null','no','','','20240829-000011','11:51:35 AM','2024 08 29','madmin','1','  General','  cash','0','0','1612','null','null','null','null','29Aug24','2024082911:51:35','%','0','','','','test','2024082911:51:35','','','','','','','','','','NEW CATEGORY','madmin','madmin','null','','1612','test','test','test','test','test','test',NULL,NULL),(74,'Dell Monitor 18.5 inch','1','8000.00','8000.00','Item','null','null','no','5','Gst(5%)','20240829-000012','12:04:50 PM','2024 08 29','madmin','1','  General','  cash','0','0','1618','null','null','null','null','29Aug24','2024082912:004:50','%','2','','','','test','2024082912:004:50','','','','','','','','','','Computer','madmin','madmin','null','','1618','test','test','test','test','test','test',NULL,NULL),(75,'goldwinner refined sunflower oil 1l','1','88.00','88.00','Item','null','null','no','null','None','20240829-000012','12:04:50 PM','2024 08 29','madmin','1','  General','  cash','0','0','344','null','null','null','null','29Aug24','2024082912:004:50','%','0','','','','test','2024082912:004:50','','null','null','null','null','null','null','null','null','edible oils and ghee','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(76,'Dell Mouse USB 2.0','1','400.00','400.00','Item','null','null','no','','','20240829-000012','12:04:50 PM','2024 08 29','madmin','1','  General','  cash','0','0','1605','null','null','null','null','29Aug24','2024082912:004:50','%','0','','','','test','2024082912:004:50','','','','','','','','','','Computer','madmin','madmin','null','','1605','test','test','test','test','test','test',NULL,NULL),(77,'Oppo f1s Smart phone','1','20000.00','20000.00','Item','null','null','no','5.00','Gst(5%)','20240829-000012','12:04:50 PM','2024 08 29','madmin','1','  General','  cash','0','0','1604','null','null','null','null','29Aug24','2024082912:004:50','%','1','','','','test','2024082912:004:50','','','','','','','','','','Mobile','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(78,'parle rusk real elaichi 200g','1','25.00','25.00','Item','null','null','no','null','None','20240829-000013','12:39:11 PM','2024 08 29','madmin','1','  General','  cash','0','0','309','null','null','null','null','29Aug24','2024082912:39:11','%','0','','','','test','2024082912:39:11','','null','null','null','null','null','null','null','null','bread bakery and eggs','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(79,'jeera/jeeraga samba raw rice 1kg','1','80.00','80.00','Item','null','null','no','null','None','20240829-000013','12:39:11 PM','2024 08 29','madmin','1','  General','  cash','0','0','1268','null','null','null','null','29Aug24','2024082912:39:11','%','0','','','','test','2024082912:39:11','','null','null','null','null','null','null','null','null','rice and whole grains','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(80,'amul butter salted 100g','1','40.00','40.00','Item','null','null','no','null','None','20240829-000013','12:39:11 PM','2024 08 29','madmin','1','  General','  cash','0','0','389','null','null','null','null','29Aug24','2024082912:39:11','%','0','','','','test','2024082912:39:11','','null','null','null','null','null','null','null','null','dairy products','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(81,'nestle slim dahi curd 400g','1','65.00','65.00','Item','null','null','no','null','None','20240829-000013','12:39:11 PM','2024 08 29','madmin','1','  General','  cash','0','0','386','null','null','null','null','29Aug24','2024082912:39:11','%','0','','','','test','2024082912:39:11','','null','null','null','null','null','null','null','null','dairy products','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(82,'Dell Mouse USB 2.0','1','400.00','400.00','Item','null','null','no','','','20240829-000013','12:39:11 PM','2024 08 29','madmin','1','  General','  cash','0','0','1605','null','null','null','null','29Aug24','2024082912:39:11','%','0','','','','test','2024082912:39:11','','','','','','','','','','Computer','madmin','madmin','null','','1605','test','test','test','test','test','test',NULL,NULL),(83,'Dell CPU 1 Set','1','5000.00','5000.00','Item','null','null','no','','','20240829-000013','12:39:11 PM','2024 08 29','madmin','1','  General','  cash','0','0','1617','null','null','null','null','29Aug24','2024082912:39:11','%','2','','','','test','2024082912:39:11','','','','','','','','','','Computer','madmin','madmin','null','','1617','test','test','test','test','test','test',NULL,NULL),(84,'Dell Monitor 18.5 inch','1','8000.00','8000.00','Item','null','null','no','5','Gst(5%)','20240829-000013','12:39:11 PM','2024 08 29','madmin','1','  General','  cash','0','0','1618','null','null','null','null','29Aug24','2024082912:39:11','%','2','','','','test','2024082912:39:11','','','','','','','','','','Computer','madmin','madmin','null','','1618','test','test','test','test','test','test',NULL,NULL),(85,'Oppo f1s Smart phone','1','20000.00','20000.00','Item','null','null','no','5.00','Gst(5%)','20240829-000013','12:39:11 PM','2024 08 29','madmin','1','  General','  cash','0','0','1604','null','null','null','null','29Aug24','2024082912:39:11','%','1','','','','test','2024082912:39:11','','','','','','','','','','Mobile','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(86,'carrots kg','1','70.00','70.00','Item','null','null','no','null','None','20240829-000014','3:14:49 PM','2024 08 29','madmin','1','  General','  cash','0','0','7','null','null','null','null','29Aug24','2024082903:14:49','%','0','','','','test','2024082903:14:49','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(87,'fig fruit kg','1','250.00','250.00','Item','null','null','no','null','None','20240829-000014','3:14:49 PM','2024 08 29','madmin','1','  General','  cash','0','0','4','null','null','null','null','29Aug24','2024082903:14:49','%','0','','','','test','2024082903:14:49','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(88,'cauliflower kg','1','45.00','45.00','Item','null','null','no','null','None','20240829-000014','3:14:49 PM','2024 08 29','madmin','1','  General','  cash','0','0','8','null','null','null','null','29Aug24','2024082903:14:49','%','0','','','','test','2024082903:14:49','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(89,'surfexcel blue 70gm','1','76.00','76.00','Item','null','null','no','null','None','20240829-000014','3:14:49 PM','2024 08 29','madmin','1','  General','  cash','0','0','67','null','null','null','null','29Aug24','2024082903:14:49','%','0','','','','test','2024082903:14:49','','null','null','null','null','null','null','null','null','household','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(90,'rin powder 6kg','1','420.00','420.00','Item','null','null','no','null','None','20240829-000014','3:14:49 PM','2024 08 29','madmin','1','  General','  cash','0','0','71','null','null','null','null','29Aug24','2024082903:14:49','%','0','','','','test','2024082903:14:49','','null','null','null','null','null','null','null','null','household','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(91,'active wheel 500gms','1','22.00','22.00','Item','null','null','no','null','None','20240829-000014','3:14:49 PM','2024 08 29','madmin','1','  General','  cash','0','0','75','null','null','null','null','29Aug24','2024082903:14:49','%','0','','','','test','2024082903:14:49','','null','null','null','null','null','null','null','null','household','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(92,'Dell Mouse USB 2.0','1','400.00','400.00','Item','null','null','no','','','20240829-000015','3:20:42 PM','2024 08 29','madmin','1','  General','  cash','0','0','1605','null','null','null','null','29Aug24','2024082903:20:42','%','0','','','','test','2024082903:20:42','','','','','','','','','','Computer','madmin','madmin','null','','1605','test','test','test','test','test','test',NULL,NULL),(93,'Keyborad','1','1000.00','1000.00','Item','null','null','no','5.00','Gst(5%)','20240829-000015','3:20:42 PM','2024 08 29','madmin','1','  General','  cash','0','0','1606','null','null','null','null','29Aug24','2024082903:20:42','%','2','','','','test','2024082903:20:42','','','','','','','','','','Computer','madmin','madmin','null','','1606','test','test','test','test','test','test',NULL,NULL),(94,'Dell CPU 1 Set','1','5000.00','5000.00','Item','null','null','no','','','20240829-000015','3:20:42 PM','2024 08 29','madmin','1','  General','  cash','0','0','1617','null','null','null','null','29Aug24','2024082903:20:42','%','2','','','','test','2024082903:20:42','','','','','','','','','','Computer','madmin','madmin','null','','1617','test','test','test','test','test','test',NULL,NULL),(95,'Dell Monitor 18.5 inch','1','8000.00','8000.00','Item','null','null','no','5','Gst(5%)','20240829-000015','3:20:42 PM','2024 08 29','madmin','1','  General','  cash','0','0','1618','null','null','null','null','29Aug24','2024082903:20:42','%','2','','','','test','2024082903:20:42','','','','','','','','','','Computer','madmin','madmin','null','','1618','test','test','test','test','test','test',NULL,NULL),(96,'paracitamol 500mg','1','25.00','25.00','Item','null','null','no','','','20240829-000016','3:22:11 PM','2024 08 29','madmin','1','  General','  cash','0','0','1610','null','null','null','null','29Aug24','2024082903:22:11','%','0','','','','test','2024082903:22:11','','','','','','','','','','medicine','madmin','madmin','null','','1610','test','test','test','test','test','test',NULL,NULL),(97,'Oppo f1s Smart phone','1','20000.00','20000.00','Item','null','null','no','5.00','Gst(5%)','20240829-000016','3:22:11 PM','2024 08 29','madmin','1','  General','  cash','0','0','1604','null','null','null','null','29Aug24','2024082903:22:11','%','1','','','','test','2024082903:22:11','','','','','','','','','','Mobile','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(98,'Dell Mouse USB 2.0','1','400.00','400.00','Item','null','null','no','','','20240829-000016','3:22:11 PM','2024 08 29','madmin','1','  General','  cash','0','0','1605','null','null','null','null','29Aug24','2024082903:22:11','%','0','','','','test','2024082903:22:11','','','','','','','','','','Computer','madmin','madmin','null','','1605','test','test','test','test','test','test',NULL,NULL),(99,'Keyborad','1','1000.00','1000.00','Item','null','null','no','5.00','Gst(5%)','20240829-000016','3:22:11 PM','2024 08 29','madmin','1','  General','  cash','0','0','1606','null','null','null','null','29Aug24','2024082903:22:11','%','2','','','','test','2024082903:22:11','','','','','','','','','','Computer','madmin','madmin','null','','1606','test','test','test','test','test','test',NULL,NULL),(100,'TEST ITEM','1','100.00','100.00','Item','null','null','no','','','20240829-000016','3:22:11 PM','2024 08 29','madmin','1','  General','  cash','0','0','1612','null','null','null','null','29Aug24','2024082903:22:11','%','0','','','','test','2024082903:22:11','','','','','','','','','','NEW CATEGORY','madmin','madmin','null','','1612','test','test','test','test','test','test',NULL,NULL),(101,'tata urad dal whole white 1kg','1','250.00','250.00','Item','null','null','no','null','None','20240829-000017','3:24:30 PM','2024 08 29','madmin','1','  General','  Pay Later','0','0','2','null','null','null','null','29Aug24','2024082903:24:30','%','0','','','','test','2024082903:24:30','','null','null','null','null','null','null','null','null','dals pulses','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(102,'nutella','1','170.00','170.00','Item','null','null','no','null','None','20240829-000017','3:24:30 PM','2024 08 29','madmin','1','  General','  Pay Later','0','0','3','null','null','null','null','29Aug24','2024082903:24:30','%','0','','','','test','2024082903:24:30','','null','null','null','null','null','null','null','null','branded foods','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(103,'fig fruit kg','1','250.00','250.00','Item','null','null','no','null','None','20240829-000017','3:24:30 PM','2024 08 29','madmin','1','  General','  Pay Later','0','0','4','null','null','null','null','29Aug24','2024082903:24:30','%','0','','','','test','2024082903:24:30','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(104,'cauliflower kg','1','45.00','45.00','Item','null','null','no','null','None','20240829-000017','3:24:30 PM','2024 08 29','madmin','1','  General','  Pay Later','0','0','8','null','null','null','null','29Aug24','2024082903:24:30','%','0','','','','test','2024082903:24:30','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(105,'carrots kg','1','70.00','70.00','Item','null','null','no','null','None','20240829-000017','3:24:30 PM','2024 08 29','madmin','1','  General','  Pay Later','0','0','7','null','null','null','null','29Aug24','2024082903:24:30','%','0','','','','test','2024082903:24:30','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(106,'capsicum green kg','1','80.00','80.00','Item','null','null','no','null','None','20240829-000017','3:24:30 PM','2024 08 29','madmin','1','  General','  Pay Later','0','0','6','null','null','null','null','29Aug24','2024082903:24:30','%','0','','','','test','2024082903:24:30','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(107,'ladies finger kg','1','28.00','28.00','Item','null','null','no','null','None','20240829-000017','3:24:30 PM','2024 08 29','madmin','1','  General','  Pay Later','0','0','5','null','null','null','null','29Aug24','2024082903:24:30','%','0','','','','test','2024082903:24:30','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(108,'beans kg','1','40.00','40.00','Item','null','null','no','null','None','20240829-000017','3:24:30 PM','2024 08 29','madmin','1','  General','  Pay Later','0','0','9','null','null','null','null','29Aug24','2024082903:24:30','%','0','','','','test','2024082903:24:30','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(109,'sweet corn piece','1','15.00','15.00','Item','null','null','no','null','None','20240829-000017','3:24:30 PM','2024 08 29','madmin','1','  General','  Pay Later','0','0','10','null','null','null','null','29Aug24','2024082903:24:30','%','0','','','','test','2024082903:24:30','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(110,'beans kg','1','40.00','40.00','Item','null','null','no','null','None','20240903-000011','8:28:20 AM','2024 09 03','madmin','1','  General','  cash','0','0','9','null','null','null','null','03Sep24','2024090308:28:20','%','0','','','','test','2024090308:28:20','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(111,'fig fruit kg','1','250.00','250.00','Item','null','null','no','null','None','20240904-000011','4:48:41 PM','2024 09 04','madmin','1','  General','  cash','0','0','4','null','null','null','null','04Sep24','2024090404:48:41','%','0','','','','test','2024090404:48:41','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(112,'nandini goodlife toned milk 500ml','1','22.00','22.00','Item','null','null','no','null','None','20240904-000011','4:48:41 PM','2024 09 04','madmin','1','  General','  cash','0','0','315','null','null','null','null','04Sep24','2024090404:48:41','%','0','','','','test','2024090404:48:41','','null','null','null','null','null','null','null','null','dairy products','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(113,'Shirt Size S','1','550.00','550.00','Item','null','null','no','5','Gst(5%)','20240904-000011','4:48:41 PM','2024 09 04','madmin','1','  General','  cash','0','0','1601','null','null','null','null','04Sep24','2024090404:48:41','%','2','','','','test','2024090404:48:41','','','','','','','','','','Cloths','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(114,'paracitamol 500mg','1','25.00','25.00','Item','null','null','no','','','20240904-000011','4:48:41 PM','2024 09 04','madmin','1','  General','  cash','0','0','1610','null','null','null','null','04Sep24','2024090404:48:41','%','0','','','','test','2024090404:48:41','','','','','','','','','','medicine','madmin','madmin','null','','1610','test','test','test','test','test','test',NULL,NULL),(115,'nutella','1','170.00','170.00','Item','null','null','no','null','None','20240904-000012','4:51:07 PM','2024 09 04','madmin','1','  General','  Pay Later','0','0','3','null','null','null','null','04Sep24','2024090404:51:007','%','0','','','','test','2024090404:51:007','','null','null','null','null','null','null','null','null','branded foods','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(116,'cauliflower kg','1','45.00','45.00','Item','null','null','no','null','None','20240904-000012','4:51:07 PM','2024 09 04','madmin','1','  General','  Pay Later','0','0','8','null','null','null','null','04Sep24','2024090404:51:007','%','0','','','','test','2024090404:51:007','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(117,'parle rusk real elaichi 200g','1','25.00','25.00','Item','null','null','no','null','None','20240904-000012','4:51:07 PM','2024 09 04','madmin','1','  General','  Pay Later','0','0','309','null','null','null','null','04Sep24','2024090404:51:007','%','0','','','','test','2024090404:51:007','','null','null','null','null','null','null','null','null','bread bakery and eggs','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(118,'surfexcel blue 70gm','1','76.00','76.00','Item','null','null','no','null','None','20240904-000012','4:51:07 PM','2024 09 04','madmin','1','  General','  Pay Later','0','0','67','null','null','null','null','04Sep24','2024090404:51:007','%','0','','','','test','2024090404:51:007','','null','null','null','null','null','null','null','null','household','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(119,'clinic all clr oil 150ml','1','82.00','82.00','Item','null','null','no','null','None','20240904-000012','4:51:07 PM','2024 09 04','madmin','1','  General','  Pay Later','0','0','196','null','null','null','null','04Sep24','2024090404:51:007','%','0','','','','test','2024090404:51:007','','null','null','null','null','null','null','null','null','personal care','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(120,'sweet corn piece','1','15.00','15.00','Item','null','null','no','null','None','20240904-000012','4:51:07 PM','2024 09 04','madmin','1','  General','  Pay Later','0','0','10','null','null','null','null','04Sep24','2024090404:51:007','%','0','','','','test','2024090404:51:007','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(121,'aashirvad whole wheat atta 10kg','1','329.00','329.00','Item','null','null','no','null','None','20240904-000012','4:51:07 PM','2024 09 04','madmin','1','  General','  Pay Later','0','0','923','null','null','null','null','04Sep24','2024090404:51:007','%','0','','','','test','2024090404:51:007','','null','null','null','null','null','null','null','null','flours and sooji','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(122,'Vivo V6 Ultra Mobile Smart Phone','1','32000.00','32000.00','Item','null','null','no','5.00','Gst(5%)','20241122-000011','3:55:36 PM','2024 11 22','madmin','1','  General','  cash','0','0','1619','null','null','null','null','22Nov24','2024112203:55:36','%','1','','','','test','2024112203:55:36','','','','','','','','','','Mobile Store','madmin','madmin','null','','1619','test','test','test','test','test','test',NULL,NULL),(123,'Dell Mouse USB 2.0','1','400.00','400.00','Item','null','null','no','','','20241122-000011','3:55:36 PM','2024 11 22','madmin','1','  General','  cash','0','0','1605','null','null','null','null','22Nov24','2024112203:55:36','%','0','','','','test','2024112203:55:36','','','','','','','','','','Computer','madmin','madmin','null','','1605','test','test','test','test','test','test',NULL,NULL),(124,'Keyborad','1','1000.00','1000.00','Item','null','null','no','5.00','Gst(5%)','20241122-000011','3:55:36 PM','2024 11 22','madmin','1','  General','  cash','0','0','1606','null','null','null','null','22Nov24','2024112203:55:36','%','2','','','','test','2024112203:55:36','','','','','','','','','','Computer','madmin','madmin','null','','1606','test','test','test','test','test','test',NULL,NULL),(125,'Parle Biscuit 100g','2','10.00','20','Item','null','null','no','','','20241125-000031','1:10:13 PM','2024 11 25','madmin','3','  General','  cash','0','0','1620','null','null','null','null','25Nov24','2024112501:10:13','%','1','','','','test','2024112501:10:13','','','','','','','','','','Janral Store','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(126,'Keyborad','1','1000.00','1000.00','Item','null','null','no','5.00','Gst(5%)','20241125-000031','1:10:13 PM','2024 11 25','madmin','3','  General','  cash','0','0','1606','null','null','null','null','25Nov24','2024112501:10:13','%','2','','','','test','2024112501:10:13','','','','','','','','','','Computer','madmin','madmin','null','','1606','test','test','test','test','test','test',NULL,NULL),(127,'Dell Mouse USB 2.0','1','400.00','400.00','Item','null','null','no','','','20241125-000031','1:10:13 PM','2024 11 25','madmin','3','  General','  cash','0','0','1605','null','null','null','null','25Nov24','2024112501:10:13','%','0','','','','test','2024112501:10:13','','','','','','','','','','Computer','madmin','madmin','null','','1605','test','test','test','test','test','test',NULL,NULL),(128,'Shirt Size S','1','550.00','550.00','Item','null','null','no','5','Gst(5%)','20241125-000031','1:10:13 PM','2024 11 25','madmin','3','  General','  cash','0','0','1601','null','null','null','null','25Nov24','2024112501:10:13','%','2','','','','test','2024112501:10:13','','','','','','','','','','Cloths','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(129,'T-Shirt Size M','1','660.00','660.00','Item','null','null','no','5','Gst(5%)','20241125-000031','1:10:13 PM','2024 11 25','madmin','3','  General','  cash','0','0','1602','null','null','null','null','25Nov24','2024112501:10:13','%','2','','','','test','2024112501:10:13','','','','','','','','','','Cloths','madmin','madmin','null','','WBK75T001736','test','test','test','test','test','test',NULL,NULL),(130,'Parle Biscuit 100g','2','10.00','20','Item','null','null','no','','','20241126-000011','12:54:34 PM','2024 11 26','madmin','1','  General','  Pay Later','0','0','1620','null','null','null','null','26Nov24','2024112612:54:34','%','0','','','','test','2024112612:54:34','','','','','','','','','','Janral Store','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(131,'Parle Namkin 100g','1','20.00','20.00','Item','null','null','no','','','20241126-000011','12:54:34 PM','2024 11 26','madmin','1','  General','  Pay Later','0','0','1621','null','null','null','null','26Nov24','2024112612:54:34','%','0','','','','test','2024112612:54:34','','','','','','','','','','Janral Store','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(132,'Butter Bag Biscuit 50g','2','5.00','10','Item','null','null','no','','','20241126-000011','12:54:34 PM','2024 11 26','madmin','1','  General','  Pay Later','0','0','1622','null','null','null','null','26Nov24','2024112612:54:34','%','0','','','','test','2024112612:54:34','','','','','','','','','','Janral Store','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(133,'Rorito Fyro Ballpoint Pen','2','5.00','10','Item','null','null','no','','','20241126-000011','12:54:34 PM','2024 11 26','madmin','1','  General','  Pay Later','0','0','1623','null','null','null','null','26Nov24','2024112612:54:34','%','0','','','','test','2024112612:54:34','','','','','','','','','','Janral Store','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(134,'Demi Rough Note Book 180p','1','30.00','30.00','Item','null','null','no','','','20241126-000011','12:54:34 PM','2024 11 26','madmin','1','  General','  Pay Later','0','0','1624','null','null','null','null','26Nov24','2024112612:54:34','%','0','','','','test','2024112612:54:34','','','','','','','','','','Janral Store','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(135,'Parle Biscuit 100g','2','10.00','20','Item','null','null','no','','','20241204-000011','3:46:52 PM','2024 12 04','madmin','1','  General','  cash','0','0','1620','null','null','null','null','04Dec24','2024120403:46:52','%','0','','','','test','2024120403:46:52','','','','','','','','','','Janral Store','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(136,'Parle Namkin 100g','1','20.00','20.00','Item','null','null','no','','','20241204-000011','3:46:52 PM','2024 12 04','madmin','1','  General','  cash','0','0','1621','null','null','null','null','04Dec24','2024120403:46:52','%','0','','','','test','2024120403:46:52','','','','','','','','','','Janral Store','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(137,'Butter Bag Biscuit 50g','1','5.00','5.00','Item','null','null','no','','','20241204-000011','3:46:52 PM','2024 12 04','madmin','1','  General','  cash','0','0','1622','null','null','null','null','04Dec24','2024120403:46:52','%','0','','','','test','2024120403:46:52','','','','','','','','','','Janral Store','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(138,'Vivo V6 Ultra Mobile Smart Phone','1','32000.00','32000.00','Item','null','null','no','5.00','Gst(5%)','20241204-000011','3:46:52 PM','2024 12 04','madmin','1','  General','  cash','0','0','1619','null','null','null','null','04Dec24','2024120403:46:52','%','1','','','','test','2024120403:46:52','','','','','','','','','','Mobile Store','madmin','madmin','null','','1619','test','test','test','test','test','test',NULL,NULL),(139,'Roban the rat killer','1','10.00','10.00','Item','null','null','no','','','20241205-000011','3:58:26 PM','2024 12 05','madmin','1','  General','  cash','0','0','1628','null','null','null','null','05Dec24','2024120503:58:26','%','0','','','','test','2024120503:58:26','','','','','','','','','','Janral Store','madmin','madmin','null','','8906021271301','test','test','test','test','test','test',NULL,NULL),(140,'BLACK ROSE KALI MEHANDI','1','12.00','12.00','Item','null','null','no','','','20241205-000011','3:58:26 PM','2024 12 05','madmin','1','  General','  cash','0','0','1631','null','null','null','null','05Dec24','2024120503:58:26','%','0','','','','test','2024120503:58:26','','','','','','','','','','Janral Store','madmin','madmin','null','','815865000115','test','test','test','test','test','test',NULL,NULL),(141,'Knorr Cup-a-Soup','1','10.00','10','Item','null','null','no','','','20241205-000011','3:58:26 PM','2024 12 05','madmin','1','  General','  cash','0','0','1627','null','null','null','null','05Dec24','2024120503:58:26','%','0','','','','test','2024120503:58:26','','','','','','','','','','Janral Store','madmin','madmin','null','','8901030516320','test','test','test','test','test','test',NULL,NULL),(142,'Bambino Vermicelli Sevai','1','10.00','10.00','Item','null','null','no','','','20241205-000011','3:58:26 PM','2024 12 05','madmin','1','  General','  cash','0','0','1629','null','null','null','null','05Dec24','2024120503:58:26','%','0','','','','test','2024120503:58:26','','','','','','','','','','Janral Store','madmin','madmin','null','','8901242176107','test','test','test','test','test','test',NULL,NULL),(143,'Scotch-Brite Scrub','1','10.00','10.00','Item','null','null','no','','','20241205-000011','3:58:26 PM','2024 12 05','madmin','1','  General','  cash','0','0','1626','null','null','null','null','05Dec24','2024120503:58:26','%','0','','','','test','2024120503:58:26','','','','','','','','','','Janral Store','madmin','madmin','null','','8901361300872','test','test','test','test','test','test',NULL,NULL),(144,'TATA TEA AGNI','1','10.00','10.00','Item','null','null','no','','','20241205-000011','3:58:26 PM','2024 12 05','madmin','1','  General','  cash','0','0','1630','null','null','null','null','05Dec24','2024120503:58:26','%','0','','','','test','2024120503:58:26','','','','','','','','','','Janral Store','madmin','madmin','null','','8901052034420','test','test','test','test','test','test',NULL,NULL),(145,'sweet corn piece','1','15.00','15.00','Item','null','null','no','null','None','20241209-000011','12:47:02 PM','2024 12 09','madmin','1','  General','  cash','0','0','10','null','null','null','null','09Dec24','2024120912:47:002','%','0','','','','test','2024120912:47:002','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(146,'potatoes kg','1','32.00','32.00','Item','null','null','no','null','None','20241209-000011','12:47:02 PM','2024 12 09','madmin','1','  General','  cash','0','0','16','null','null','null','null','09Dec24','2024120912:47:002','%','0','','','','test','2024120912:47:002','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(147,'cucumbers kg','1','20.00','20.00','Item','null','null','no','null','None','20241209-000011','12:47:02 PM','2024 12 09','madmin','1','  General','  cash','0','0','11','null','null','null','null','09Dec24','2024120912:47:002','%','0','','','','test','2024120912:47:002','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(148,'cabbage kg','1','32.00','32.00','Item','null','null','no','null','None','20241209-000011','12:47:02 PM','2024 12 09','madmin','1','  General','  cash','0','0','19','null','null','null','null','09Dec24','2024120912:47:002','%','0','','','','test','2024120912:47:002','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(149,'tomatoes kg','1','25.00','25.00','Item','null','null','no','null','None','20241209-000011','12:47:02 PM','2024 12 09','madmin','1','  General','  cash','0','0','20','null','null','null','null','09Dec24','2024120912:47:002','%','0','','','','test','2024120912:47:002','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(150,'apples kg','1','202.00','202.00','Item','null','null','no','null','None','20241209-000011','12:47:02 PM','2024 12 09','madmin','1','  General','  cash','0','0','21','null','null','null','null','09Dec24','2024120912:47:002','%','0','','','','test','2024120912:47:002','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(151,'Parle Biscuit 100g','1','10.00','10.00','Item','null','null','no','','','20241209-000012','1:03:08 PM','2024 12 09','madmin','1','  General','  cash','0','0','1620','null','null','null','null','09Dec24','2024120901:003:008','%','0','','','','test','2024120901:003:008','','','','','','','','','','Janral Store','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(152,'Parle Namkin 100g','1','20.00','20.00','Item','null','null','no','','','20241209-000012','1:03:08 PM','2024 12 09','madmin','1','  General','  cash','0','0','1621','null','null','null','null','09Dec24','2024120901:003:008','%','0','','','','test','2024120901:003:008','','','','','','','','','','Janral Store','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(153,'Butter Bag Biscuit 50g','1','5.00','5.00','Item','null','null','no','','','20241209-000012','1:03:08 PM','2024 12 09','madmin','1','  General','  cash','0','0','1622','null','null','null','null','09Dec24','2024120901:003:008','%','0','','','','test','2024120901:003:008','','','','','','','','','','Janral Store','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(154,'Rorito Fyro Ballpoint Pen','1','5.00','5.00','Item','null','null','no','','','20241209-000012','1:03:08 PM','2024 12 09','madmin','1','  General','  cash','0','0','1623','null','null','null','null','09Dec24','2024120901:003:008','%','0','','','','test','2024120901:003:008','','','','','','','','','','Janral Store','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(155,'Demi Rough Note Book 180p','1','30.00','30.00','Item','null','null','no','','','20241209-000012','1:03:08 PM','2024 12 09','madmin','1','  General','  cash','0','0','1624','null','null','null','null','09Dec24','2024120901:003:008','%','0','','','','test','2024120901:003:008','','','','','','','','','','Janral Store','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(156,'Wild Stone Powder 20g','1','10.00','10.00','Item','null','null','no','','','20241209-000012','1:03:08 PM','2024 12 09','madmin','1','  General','  cash','0','0','1625','null','null','null','null','09Dec24','2024120901:003:008','%','0','','','','test','2024120901:003:008','','','','','','','','','','Janral Store','madmin','madmin','null','','8904006304099','test','test','test','test','test','test',NULL,NULL),(157,'Scotch-Brite Scrub','1','10.00','10.00','Item','null','null','no','','','20241209-000012','1:03:08 PM','2024 12 09','madmin','1','  General','  cash','0','0','1626','null','null','null','null','09Dec24','2024120901:003:008','%','0','','','','test','2024120901:003:008','','','','','','','','','','Janral Store','madmin','madmin','null','','8901361300872','test','test','test','test','test','test',NULL,NULL),(158,'Knorr Cup-a-Soup','1','10.00','10.00','Item','null','null','no','','','20241209-000012','1:03:08 PM','2024 12 09','madmin','1','  General','  cash','0','0','1627','null','null','null','null','09Dec24','2024120901:003:008','%','0','','','','test','2024120901:003:008','','','','','','','','','','Janral Store','madmin','madmin','null','','8901030516320','test','test','test','test','test','test',NULL,NULL),(159,'Roban the rat killer','1','10.00','10.00','Item','null','null','no','','','20241209-000012','1:03:08 PM','2024 12 09','madmin','1','  General','  cash','0','0','1628','null','null','null','null','09Dec24','2024120901:003:008','%','0','','','','test','2024120901:003:008','','','','','','','','','','Janral Store','madmin','madmin','null','','8906021271301','test','test','test','test','test','test',NULL,NULL),(160,'Bambino Vermicelli Sevai','1','10.00','10.00','Item','null','null','no','','','20241209-000012','1:03:08 PM','2024 12 09','madmin','1','  General','  cash','0','0','1629','null','null','null','null','09Dec24','2024120901:003:008','%','0','','','','test','2024120901:003:008','','','','','','','','','','Janral Store','madmin','madmin','null','','8901242176107','test','test','test','test','test','test',NULL,NULL),(161,'milk bread 300g','1','35.00','35.00','Item','null','null','no','null','None','20241209-000013','2:39:30 PM','2024 12 09','madmin','1','  General','  cash','0','0','431','null','null','null','null','09Dec24','2024120902:39:30','%','0','','','','test','2024120902:39:30','','null','null','null','null','null','null','null','null','bread bakery and eggs','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(162,'burger bun 150g','1','25.00','25.00','Item','null','null','no','null','None','20241209-000013','2:39:30 PM','2024 12 09','madmin','1','  General','  cash','0','0','1539','null','null','null','null','09Dec24','2024120902:39:30','%','0','','','','test','2024120902:39:30','','null','null','null','null','null','null','null','null','bread bakery and eggs','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(163,'cauliflower kg','1','45.00','45.00','Item','null','null','no','null','None','20241209-000013','2:39:30 PM','2024 12 09','madmin','1','  General','  cash','0','0','8','null','null','null','null','09Dec24','2024120902:39:30','%','0','','','','test','2024120902:39:30','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(164,'potatoes kg','1','32.00','32.00','Item','null','null','no','null','None','20241209-000013','2:39:30 PM','2024 12 09','madmin','1','  General','  cash','0','0','16','null','null','null','null','09Dec24','2024120902:39:30','%','0','','','','test','2024120902:39:30','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(165,'tomatoes kg','1','25.00','25.00','Item','null','null','no','null','None','20241209-000013','2:39:30 PM','2024 12 09','madmin','1','  General','  cash','0','0','20','null','null','null','null','09Dec24','2024120902:39:30','%','0','','','','test','2024120902:39:30','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(166,'bananas robusta kg','1','40.00','40.00','Item','null','null','no','null','None','20241209-000013','2:39:30 PM','2024 12 09','madmin','1','  General','  cash','0','0','23','null','null','null','null','09Dec24','2024120902:39:30','%','0','','','','test','2024120902:39:30','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(167,'cashew 500gm','1','525.00','525.00','Item','null','null','no','null','None','20241209-000013','2:39:30 PM','2024 12 09','madmin','1','  General','  cash','0','0','1357','null','null','null','null','09Dec24','2024120902:39:30','%','0','','','','test','2024120902:39:30','','null','null','null','null','null','null','null','null','dry fruits','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(168,'Parle Biscuit 100g','1','10.00','10.00','Item','null','null','no','','','20241209-000013','2:39:30 PM','2024 12 09','madmin','1','  General','  cash','0','0','1620','null','null','null','null','09Dec24','2024120902:39:30','%','0','','','','test','2024120902:39:30','','','','','','','','','','Janral Store','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(169,'Butter Bag Biscuit 50g','1','5.00','5.00','Item','null','null','no','','','20241209-000013','2:39:30 PM','2024 12 09','madmin','1','  General','  cash','0','0','1622','null','null','null','null','09Dec24','2024120902:39:30','%','0','','','','test','2024120902:39:30','','','','','','','','','','Janral Store','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(170,'TATA TEA AGNI','1','10.00','10.00','Item','null','null','no','','','20241209-000013','2:39:30 PM','2024 12 09','madmin','1','  General','  cash','0','0','1630','null','null','null','null','09Dec24','2024120902:39:30','%','0','','','','test','2024120902:39:30','','','','','','','','','','Janral Store','madmin','madmin','null','','8901052034420','test','test','test','test','test','test',NULL,NULL),(171,'nutella','1','170.00','170.00','Item','null','null','no','null','None','20241209-000014','3:33:55 PM','2024 12 09','madmin','1','  General','  cash','0','0','3','null','null','null','null','09Dec24','2024120903:33:55','%','0','','','','test','2024120903:33:55','','null','null','null','null','null','null','null','null','branded foods','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(172,'milk bread 300g','1','35.00','35.00','Item','null','null','no','null','None','20241209-000014','3:33:55 PM','2024 12 09','madmin','1','  General','  cash','0','0','431','null','null','null','null','09Dec24','2024120903:33:55','%','0','','','','test','2024120903:33:55','','null','null','null','null','null','null','null','null','bread bakery and eggs','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(173,'burger bun 150g','1','25.00','25.00','Item','null','null','no','null','None','20241209-000014','3:33:55 PM','2024 12 09','madmin','1','  General','  cash','0','0','1539','null','null','null','null','09Dec24','2024120903:33:55','%','0','','','','test','2024120903:33:55','','null','null','null','null','null','null','null','null','bread bakery and eggs','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(174,'surf excel 2kg','1','432.00','432.00','Item','null','null','no','null','None','20241209-000014','3:33:55 PM','2024 12 09','madmin','1','  General','  cash','0','0','70','null','null','null','null','09Dec24','2024120903:33:55','%','0','','','','test','2024120903:33:55','','null','null','null','null','null','null','null','null','household','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(175,'cauliflower kg','1','45.00','45.00','Item','null','null','no','null','None','20241209-000014','3:33:55 PM','2024 12 09','madmin','1','  General','  cash','0','0','8','null','null','null','null','09Dec24','2024120903:33:55','%','0','','','','test','2024120903:33:55','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(176,'potatoes kg','1','32.00','32.00','Item','null','null','no','null','None','20241209-000014','3:33:55 PM','2024 12 09','madmin','1','  General','  cash','0','0','16','null','null','null','null','09Dec24','2024120903:33:55','%','0','','','','test','2024120903:33:55','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(177,'tomatoes kg','2','25.00','50','Item','null','null','no','null','None','20241209-000014','3:33:55 PM','2024 12 09','madmin','1','  General','  cash','0','0','20','null','null','null','null','09Dec24','2024120903:33:55','%','0','','','','test','2024120903:33:55','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(178,'guava kg','1','90.00','90.00','Item','null','null','no','null','None','20241209-000014','3:33:55 PM','2024 12 09','madmin','1','  General','  cash','0','0','28','null','null','null','null','09Dec24','2024120903:33:55','%','0','','','','test','2024120903:33:55','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(179,'carrots kg','1','70.00','70.00','Item','null','null','no','null','None','20241209-000014','3:33:55 PM','2024 12 09','madmin','1','  General','  cash','0','0','7','null','null','null','null','09Dec24','2024120903:33:55','%','0','','','','test','2024120903:33:55','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(180,'cashew 200gm','1','219.00','219.00','Item','null','null','no','null','None','20241209-000014','3:33:55 PM','2024 12 09','madmin','1','  General','  cash','0','0','1356','null','null','null','null','09Dec24','2024120903:33:55','%','0','','','','test','2024120903:33:55','','null','null','null','null','null','null','null','null','dry fruits','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(181,'sugar 1kg','2','45.00','90','Item','null','null','no','null','None','20241209-000014','3:33:55 PM','2024 12 09','madmin','1','  General','  cash','0','0','442','null','null','null','null','09Dec24','2024120903:33:55','%','0','','','','test','2024120903:33:55','','null','null','null','null','null','null','null','null','salt and sugar','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(182,'TATA TEA AGNI','1','10.00','10.00','Item','null','null','no','','','20241209-000014','3:33:55 PM','2024 12 09','madmin','1','  General','  cash','0','0','1630','null','null','null','null','09Dec24','2024120903:33:55','%','0','','','','test','2024120903:33:55','','','','','','','','','','Janral Store','madmin','madmin','null','','8901052034420','test','test','test','test','test','test',NULL,NULL),(183,'Knorr Cup-a-Soup','1','10.00','10.00','Item','null','null','no','','','20241209-000014','3:33:55 PM','2024 12 09','madmin','1','  General','  cash','0','0','1627','null','null','null','null','09Dec24','2024120903:33:55','%','0','','','','test','2024120903:33:55','','','','','','','','','','Janral Store','madmin','madmin','null','','8901030516320','test','test','test','test','test','test',NULL,NULL),(184,'Butter Bag Biscuit 50g','1','5.00','5.00','Item','null','null','no','','','20241209-000014','3:33:55 PM','2024 12 09','madmin','1','  General','  cash','0','0','1622','null','null','null','null','09Dec24','2024120903:33:55','%','0','','','','test','2024120903:33:55','','','','','','','','','','Janral Store','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(185,'sona masoori raw rice 1kg','1','56.00','56.00','Item','null','null','no','null','None','20241209-000015','3:48:04 PM','2024 12 09','madmin','1','  General','  cash','0','0','1','null','null','null','null','09Dec24','2024120903:48:004','%','0','','','','test','2024120903:48:004','','null','null','null','null','null','null','null','null','rice whole grains','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(186,'ladies finger kg','1','28.00','28.00','Item','null','null','no','null','None','20241209-000015','3:48:04 PM','2024 12 09','madmin','1','  General','  cash','0','0','5','null','null','null','null','09Dec24','2024120903:48:004','%','0','','','','test','2024120903:48:004','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(187,'cucumbers kg','1','20.00','20.00','Item','null','null','no','null','None','20241209-000015','3:48:04 PM','2024 12 09','madmin','1','  General','  cash','0','0','11','null','null','null','null','09Dec24','2024120903:48:004','%','0','','','','test','2024120903:48:004','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(188,'beet root kg','1','32.00','32.00','Item','null','null','no','null','None','20241209-000015','3:48:04 PM','2024 12 09','madmin','1','  General','  cash','0','0','13','null','null','null','null','09Dec24','2024120903:48:004','%','0','','','','test','2024120903:48:004','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(189,'avocados kg','1','82.00','82.00','Item','null','null','no','null','None','20241209-000015','3:48:04 PM','2024 12 09','madmin','1','  General','  cash','0','0','22','null','null','null','null','09Dec24','2024120903:48:004','%','0','','','','test','2024120903:48:004','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(190,'pineapple kg','1','80.00','80.00','Item','null','null','no','null','None','20241209-000015','3:48:04 PM','2024 12 09','madmin','1','  General','  cash','0','0','25','null','null','null','null','09Dec24','2024120903:48:004','%','0','','','','test','2024120903:48:004','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(191,'watermelon kg','1','18.00','18.00','Item','null','null','no','null','None','20241209-000015','3:48:04 PM','2024 12 09','madmin','1','  General','  cash','0','0','30','null','null','null','null','09Dec24','2024120903:48:004','%','0','','','','test','2024120903:48:004','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(192,'Parle Biscuit 100g','1','10.00','10.00','Item','null','null','no','','','20241209-000016','3:50:27 PM','2024 12 09','madmin','1','  General','  cash','0','0','1620','null','null','null','null','09Dec24','2024120903:50:27','%','0','','','','test','2024120903:50:27','','','','','','','','','','Janral Store','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(193,'Parle Namkin 100g','1','20.00','20.00','Item','null','null','no','','','20241209-000016','3:50:27 PM','2024 12 09','madmin','1','  General','  cash','0','0','1621','null','null','null','null','09Dec24','2024120903:50:27','%','0','','','','test','2024120903:50:27','','','','','','','','','','Janral Store','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(194,'Butter Bag Biscuit 50g','1','5.00','5.00','Item','null','null','no','','','20241209-000016','3:50:27 PM','2024 12 09','madmin','1','  General','  cash','0','0','1622','null','null','null','null','09Dec24','2024120903:50:27','%','0','','','','test','2024120903:50:27','','','','','','','','','','Janral Store','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(195,'Rorito Fyro Ballpoint Pen','1','5.00','5.00','Item','null','null','no','','','20241209-000016','3:50:27 PM','2024 12 09','madmin','1','  General','  cash','0','0','1623','null','null','null','null','09Dec24','2024120903:50:27','%','0','','','','test','2024120903:50:27','','','','','','','','','','Janral Store','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(196,'Demi Rough Note Book 180p','1','30.00','30.00','Item','null','null','no','','','20241209-000016','3:50:27 PM','2024 12 09','madmin','1','  General','  cash','0','0','1624','null','null','null','null','09Dec24','2024120903:50:27','%','0','','','','test','2024120903:50:27','','','','','','','','','','Janral Store','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(197,'Wild Stone Powder 20g','1','10.00','10.00','Item','null','null','no','','','20241209-000016','3:50:27 PM','2024 12 09','madmin','1','  General','  cash','0','0','1625','null','null','null','null','09Dec24','2024120903:50:27','%','0','','','','test','2024120903:50:27','','','','','','','','','','Janral Store','madmin','madmin','null','','8904006304099','test','test','test','test','test','test',NULL,NULL),(198,'Scotch-Brite Scrub','1','10.00','10.00','Item','null','null','no','','','20241209-000016','3:50:27 PM','2024 12 09','madmin','1','  General','  cash','0','0','1626','null','null','null','null','09Dec24','2024120903:50:27','%','0','','','','test','2024120903:50:27','','','','','','','','','','Janral Store','madmin','madmin','null','','8901361300872','test','test','test','test','test','test',NULL,NULL),(199,'FEVICOL GENRAL PURPOSE','2','25.00','50','Item','null','null','no','','','20241210-000011','11:00:28 AM','2024 12 10','madmin','1','  General','  cash','0','0','1642','null','null','null','null','10Dec24','2024121011:000:28','%','0','','','','test','2024121011:000:28','','','','','','','','','','Janral Store','madmin','madmin','null','','8901860630432','test','test','test','test','test','test',NULL,NULL),(200,'ZEBRONICS CPU FAN','1','499.00','499.00','Item','null','null','no','','','20241210-000011','11:00:28 AM','2024 12 10','madmin','1','  General','  cash','0','0','1638','null','null','null','null','10Dec24','2024121011:000:28','%','0','','','','test','2024121011:000:28','','','','','','','','','','None','madmin','madmin','null','','8906108613208','test','test','test','test','test','test',NULL,NULL),(201,'INTEX WIRED MOUSE','1','400.00','400.00','Item','null','null','no','','','20241210-000011','11:00:28 AM','2024 12 10','madmin','1','  General','  cash','0','0','1633','null','null','null','null','10Dec24','2024121011:000:28','%','0','','','','test','2024121011:000:28','','','','','','','','','','Computer','madmin','madmin','null','','8902956135824','test','test','test','test','test','test',NULL,NULL),(202,'TERABYTE WIRELESS USB ADAPTER','1','500.00','500.00','Item','null','null','no','','','20241210-000011','11:00:28 AM','2024 12 10','madmin','1','  General','  cash','0','0','1632','null','null','null','null','10Dec24','2024121011:000:28','%','0','','','','test','2024121011:000:28','','','','','','','','','','Computer','madmin','madmin','null','','0616859364608','test','test','test','test','test','test',NULL,NULL),(203,'ECO RISE A4 PAPER','1','250.00','250.00','Item','null','null','no','','','20241210-000012','11:23:26 AM','2024 12 10','madmin','1','  General','  cash','0','0','1643','null','null','null','null','10Dec24','2024121011:23:26','%','0','','','','test','2024121011:23:26','','','','','','','','','','Computer','madmin','madmin','null','','8902310000386','test','test','test','test','test','test',NULL,NULL),(204,'TERABYTE WIRELESS USB ADAPTER','1','500.00','500.00','Item','null','null','no','','','20241210-000012','11:23:26 AM','2024 12 10','madmin','1','  General','  cash','0','0','1632','null','null','null','null','10Dec24','2024121011:23:26','%','0','','','','test','2024121011:23:26','','','','','','','','','','Computer','madmin','madmin','null','','0616859364608','test','test','test','test','test','test',NULL,NULL),(205,'ZEBRONICS CPU FAN','1','499.00','499.00','Item','null','null','no','','','20241210-000012','11:23:26 AM','2024 12 10','madmin','1','  General','  cash','0','0','1638','null','null','null','null','10Dec24','2024121011:23:26','%','0','','','','test','2024121011:23:26','','','','','','','','','','None','madmin','madmin','null','','8906108613208','test','test','test','test','test','test',NULL,NULL),(206,'COPY ','1','110.00','110.00','Item','null','null','no','','','20241210-000012','11:23:26 AM','2024 12 10','madmin','1','  General','  cash','0','0','1644','null','null','null','null','10Dec24','2024121011:23:26','%','0','','','','test','2024121011:23:26','','','','','','','','','','Janral Store','madmin','madmin','null','','9993882041401','test','test','test','test','test','test',NULL,NULL),(207,'UNOMAX','1','30.00','30.00','Item','null','null','no','','','20241210-000012','11:23:26 AM','2024 12 10','madmin','1','  General','  cash','0','0','1640','null','null','null','null','10Dec24','2024121011:23:26','%','0','','','','test','2024121011:23:26','','','','','','','','','','None','madmin','madmin','null','','8904348003360','test','test','test','test','test','test',NULL,NULL),(208,'PARAS PEN','1','5.00','5.00','Item','null','null','no','','','20241210-000012','11:23:26 AM','2024 12 10','madmin','1','  General','  cash','0','0','1645','null','null','null','null','10Dec24','2024121011:23:26','%','0','','','','test','2024121011:23:26','','','','','','','','','','Janral Store','madmin','madmin','null','','9853265471525','test','test','test','test','test','test',NULL,NULL),(209,'COSTMER CARE MANUFACTUR','1','349.00','349.00','Item','null','null','no','','','20241210-000012','11:23:26 AM','2024 12 10','madmin','1','  General','  cash','0','0','1646','null','null','null','null','10Dec24','2024121011:23:26','%','0','','','','test','2024121011:23:26','','','','','','','','','','Janral Store','madmin','madmin','null','','8904300404938','test','test','test','test','test','test',NULL,NULL),(210,'COLIN','1','93.00','93.00','Item','null','null','no','','','20241210-000012','11:23:26 AM','2024 12 10','madmin','1','  General','  cash','0','0','1647','null','null','null','null','10Dec24','2024121011:23:26','%','0','','','','test','2024121011:23:26','','','','','','','','','','Janral Store','madmin','madmin','null','','8901396476009','test','test','test','test','test','test',NULL,NULL),(211,'sona masoori raw rice 1kg','1','56.00','56.00','Item','null','null','no','null','None','20241210-000013','11:30:10 AM','2024 12 10','madmin','1','  General','  cash','0','0','1','null','null','null','null','10Dec24','2024121011:30:10','%','0','','','','test','2024121011:30:10','','null','null','null','null','null','null','null','null','rice whole grains','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(212,'UNOMAX','1','30.00','30.00','Item','null','null','no','','','20241210-000013','11:30:10 AM','2024 12 10','madmin','1','  General','  cash','0','0','1640','null','null','null','null','10Dec24','2024121011:30:10','%','0','','','','test','2024121011:30:10','','','','','','','','','','None','madmin','madmin','null','','8904348003360','test','test','test','test','test','test',NULL,NULL),(213,'COLIN','1','93.00','93.00','Item','null','null','no','','','20241210-000013','11:30:10 AM','2024 12 10','madmin','1','  General','  cash','0','0','1647','null','null','null','null','10Dec24','2024121011:30:10','%','0','','','','test','2024121011:30:10','','','','','','','','','','Janral Store','madmin','madmin','null','','8901396476009','test','test','test','test','test','test',NULL,NULL),(214,'TERABYTE WIRELESS USB ADAPTER','1','500.00','500.00','Item','null','null','no','','','20241210-000013','11:30:10 AM','2024 12 10','madmin','1','  General','  cash','0','0','1632','null','null','null','null','10Dec24','2024121011:30:10','%','0','','','','test','2024121011:30:10','','','','','','','','','','Computer','madmin','madmin','null','','0616859364608','test','test','test','test','test','test',NULL,NULL),(215,'INTEX WIRED MOUSE','1','400.00','400.00','Item','null','null','no','','','20241210-000013','11:30:10 AM','2024 12 10','madmin','1','  General','  cash','0','0','1633','null','null','null','null','10Dec24','2024121011:30:10','%','0','','','','test','2024121011:30:10','','','','','','','','','','Computer','madmin','madmin','null','','8902956135824','test','test','test','test','test','test',NULL,NULL),(216,'ZEBRONICS CPU FAN','1','499.00','499.00','Item','null','null','no','','','20241210-000013','11:30:10 AM','2024 12 10','madmin','1','  General','  cash','0','0','1638','null','null','null','null','10Dec24','2024121011:30:10','%','0','','','','test','2024121011:30:10','','','','','','','','','','None','madmin','madmin','null','','8906108613208','test','test','test','test','test','test',NULL,NULL),(217,'FEVICOL GENRAL PURPOSE','1','25.00','25.00','Item','null','null','no','','','20241210-000013','11:30:10 AM','2024 12 10','madmin','1','  General','  cash','0','0','1642','null','null','null','null','10Dec24','2024121011:30:10','%','0','','','','test','2024121011:30:10','','','','','','','','','','Janral Store','madmin','madmin','null','','8901860630432','test','test','test','test','test','test',NULL,NULL),(218,'PARAS PEN','1','5.00','5.00','Item','null','null','no','','','20241210-000013','11:30:10 AM','2024 12 10','madmin','1','  General','  cash','0','0','1645','null','null','null','null','10Dec24','2024121011:30:10','%','0','','','','test','2024121011:30:10','','','','','','','','','','Janral Store','madmin','madmin','null','','9853265471525','test','test','test','test','test','test',NULL,NULL),(219,'ECO RISE A4 PAPER','1','250.00','250.00','Item','null','null','no','','','20241210-000013','11:30:10 AM','2024 12 10','madmin','1','  General','  cash','0','0','1643','null','null','null','null','10Dec24','2024121011:30:10','%','0','','','','test','2024121011:30:10','','','','','','','','','','Computer','madmin','madmin','null','','8902310000386','test','test','test','test','test','test',NULL,NULL),(220,'sona masoori raw rice 1kg','1','56.00','56.00','Item','null','null','no','null','None','20241210-000013','11:30:11 AM','2024 12 10','madmin','1','  General','  cash','0','0','1','null','null','null','null','10Dec24','2024121011:30:11','%','0','','','','test','2024121011:30:11','','null','null','null','null','null','null','null','null','rice whole grains','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(221,'UNOMAX','1','30.00','30.00','Item','null','null','no','','','20241210-000013','11:30:11 AM','2024 12 10','madmin','1','  General','  cash','0','0','1640','null','null','null','null','10Dec24','2024121011:30:11','%','0','','','','test','2024121011:30:11','','','','','','','','','','None','madmin','madmin','null','','8904348003360','test','test','test','test','test','test',NULL,NULL),(222,'COLIN','1','93.00','93.00','Item','null','null','no','','','20241210-000013','11:30:11 AM','2024 12 10','madmin','1','  General','  cash','0','0','1647','null','null','null','null','10Dec24','2024121011:30:11','%','0','','','','test','2024121011:30:11','','','','','','','','','','Janral Store','madmin','madmin','null','','8901396476009','test','test','test','test','test','test',NULL,NULL),(223,'TERABYTE WIRELESS USB ADAPTER','1','500.00','500.00','Item','null','null','no','','','20241210-000013','11:30:11 AM','2024 12 10','madmin','1','  General','  cash','0','0','1632','null','null','null','null','10Dec24','2024121011:30:11','%','0','','','','test','2024121011:30:11','','','','','','','','','','Computer','madmin','madmin','null','','0616859364608','test','test','test','test','test','test',NULL,NULL),(224,'INTEX WIRED MOUSE','1','400.00','400.00','Item','null','null','no','','','20241210-000013','11:30:11 AM','2024 12 10','madmin','1','  General','  cash','0','0','1633','null','null','null','null','10Dec24','2024121011:30:11','%','0','','','','test','2024121011:30:11','','','','','','','','','','Computer','madmin','madmin','null','','8902956135824','test','test','test','test','test','test',NULL,NULL),(225,'ZEBRONICS CPU FAN','1','499.00','499.00','Item','null','null','no','','','20241210-000013','11:30:11 AM','2024 12 10','madmin','1','  General','  cash','0','0','1638','null','null','null','null','10Dec24','2024121011:30:11','%','0','','','','test','2024121011:30:11','','','','','','','','','','None','madmin','madmin','null','','8906108613208','test','test','test','test','test','test',NULL,NULL),(226,'FEVICOL GENRAL PURPOSE','1','25.00','25.00','Item','null','null','no','','','20241210-000013','11:30:11 AM','2024 12 10','madmin','1','  General','  cash','0','0','1642','null','null','null','null','10Dec24','2024121011:30:11','%','0','','','','test','2024121011:30:11','','','','','','','','','','Janral Store','madmin','madmin','null','','8901860630432','test','test','test','test','test','test',NULL,NULL),(227,'PARAS PEN','1','5.00','5.00','Item','null','null','no','','','20241210-000013','11:30:11 AM','2024 12 10','madmin','1','  General','  cash','0','0','1645','null','null','null','null','10Dec24','2024121011:30:11','%','0','','','','test','2024121011:30:11','','','','','','','','','','Janral Store','madmin','madmin','null','','9853265471525','test','test','test','test','test','test',NULL,NULL),(228,'ECO RISE A4 PAPER','1','250.00','250.00','Item','null','null','no','','','20241210-000013','11:30:11 AM','2024 12 10','madmin','1','  General','  cash','0','0','1643','null','null','null','null','10Dec24','2024121011:30:11','%','0','','','','test','2024121011:30:11','','','','','','','','','','Computer','madmin','madmin','null','','8902310000386','test','test','test','test','test','test',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`, `order_id`) VALUES (1,'20240810-000011','898.00','madmin','2024 08 10','  cash','  General','898.000000','0.000000','0.000000','0','','202408101118','','','','0','0',NULL),(2,'20240810-000012','344.00','madmin','2024 08 10','  cash','  General','344.000000','0.000000','0.000000','0','1','202408101123','','','','0','0',NULL),(3,'20240810-000013','344.00','madmin','2024 08 10','  cash','  General','344.000000','0.000000','0.000000','0','2','202408101126','','','','0','0',NULL),(4,'20240810-000014','260.00','madmin','2024 08 10','  cash','  General','260.000000','0.000000','0.000000','0','3','202408101128','','','','0','0',NULL),(5,'20240810-000015','295.00','madmin','2024 08 10','  cash','  General','295.000000','0.000000','0.000000','0','4','202408101133','','','','0','0',NULL),(6,'20240812-000011','438.00','madmin','2024 08 12','  cash','  General','438.000000','0.000000','0.000000','0','5','20240812110006','','','','0','0',NULL),(7,'20240812-000012','962.00','madmin','2024 08 12','  cash','  General','962.000000','0.000000','0.000000','0','6','202408121143','','','','0','0',NULL),(8,'20240814-000011','1735.30','madmin','2024 08 14','  cash','  General','1674.800000','60.500000','0.000000','0','7','202408141150','','','','0','0',NULL),(9,'20240814-000012','1430.00','madmin','2024 08 14','  cash','  General','1396.800000','33.000000','0.200000','0','8','20240814130006','','','','0','0',NULL),(10,'20240820-000011','950.00','madmin','2024 08 20','  cash','  General','922.000000','27.500000','0.500000','0','9','202408201537','','','','0','0',NULL),(11,'20240820-000012','21458.00','madmin','2024 08 20','  cash','  General','20430.000000','1027.500000','0.500000','0','10','202408201554','','','','0','0',NULL),(12,'20240820-000013','1708.00','madmin','2024 08 20','  cash','  General','1680.000000','27.500000','0.500000','0','11','20240820170003','','','','0','0',NULL),(13,'20240820-000014','2194.00','madmin','2024 08 20','  cash','  General','2110.800000','83.000000','0.200000','0','12','202408201710','','','','0','0',NULL),(14,'20240829-000011','22764.00','madmin','2024 08 29','  cash','  General','21714.000000','1050.000000','0.000000','0','13','202408291151','','','','0','0',NULL),(15,'20240829-000012','29528.00','madmin','2024 08 29','  cash','  General','28128.000000','1400.000000','0.000000','0','14','20240829120004','','','','0','0',NULL),(16,'20240829-000013','34550.00','madmin','2024 08 29','  cash','  General','33150.000000','1400.000000','0.000000','0','15','202408291239','','','','0','0',NULL),(17,'20240829-000014','883.00','madmin','2024 08 29','  cash','  General','883.000000','0.000000','0.000000','0','16','202408291514','','','','0','0',NULL),(18,'20240829-000015','14570.00','madmin','2024 08 29','  cash','  General','14120.000000','450.000000','0.000000','0','17','202408291520','','','','0','0',NULL),(19,'20240829-000016','22355.00','madmin','2024 08 29','  cash','  General','21305.000000','1050.000000','0.000000','0','18','202408291522','','','','0','0',NULL),(20,'20240829-000017','948.00','madmin','2024 08 29','  Pay Later','  General','948.000000','0.000000','0.000000','0','19','202408291524','','','','0','0',NULL),(21,'20240903-000011','40.00','madmin','2024 09 03','  cash','  General','40.000000','0.000000','0.000000','0','20','202409030828','','','','0','0',NULL),(22,'20240904-000011','864.00','madmin','2024 09 04','  cash','  General','836.000000','27.500000','0.500000','0','21','202409041648','','','','0','0',NULL),(23,'20240904-000012','742.00','madmin','2024 09 04','  Pay Later','  General','742.000000','0.000000','0.000000','0','22','202409041651','','','','0','0',NULL),(24,'20241122-000011','34710.00','madmin','2024 11 22','  cash','  General','33060.000000','1650.000000','0.000000','0','23','202411221555','','','','0','0',NULL),(25,'20241125-000031','2696.00','madmin','2024 11 25','  cash','  General','2585.600000','110.500000','-0.100000','0','24','202411251310','','','','0','0',NULL),(26,'20241126-000011','90.00','madmin','2024 11 26','  Pay Later','  General','90.000000','0.000000','0.000000','0','25','202411261254','','','','0','0',NULL),(27,'20241204-000011','33325.00','madmin','2024 12 04','  cash','  General','31725.000000','1600.000000','0.000000','0','26','202412041546','','','','0','0',NULL),(28,'20241205-000011','62.00','madmin','2024 12 05','  cash','  General','62.000000','0.000000','0.000000','0','27','202412051558','','','','0','0',NULL),(29,'20241209-000011','326.00','madmin','2024 12 09','  cash','  General','326.000000','0.000000','0.000000','0','28','202412091247','','','','0','0',NULL),(30,'20241209-000012','120.00','madmin','2024 12 09','  cash','  General','120.000000','0.000000','0.000000','0','29','20241209130003','','','','0','0',NULL),(31,'20241209-000013','752.00','madmin','2024 12 09','  cash','  General','752.000000','0.000000','0.000000','0','30','202412091439','','','','0','0',NULL),(32,'20241209-000014','1283.00','madmin','2024 12 09','  cash','  General','1283.000000','0.000000','0.000000','0','31','202412091533','','','','0','0',NULL),(33,'20241209-000015','316.00','madmin','2024 12 09','  cash','  General','316.000000','0.000000','0.000000','0','32','202412091548','','','','0','0',NULL),(34,'20241209-000016','90.00','madmin','2024 12 09','  cash','  General','90.000000','0.000000','0.000000','0','33','202412091550','','','','0','0',NULL),(35,'20241210-000011','1449.00','madmin','2024 12 10','  cash','  General','1449.000000','0.000000','0.000000','0','34','20241210110000','','','','0','0',NULL),(36,'20241210-000012','1836.00','madmin','2024 12 10','  cash','  General','1836.000000','0.000000','0.000000','0','35','202412101123','','','','0','0',NULL),(37,'20241210-000013','1858.00','madmin','2024 12 10','  cash','  General','1858.000000','0.000000','0.000000','0','36','202412101130','','','','0','0',NULL),(38,'20241210-000013','1858.00','madmin','2024 12 10','  cash','  General','1858.000000','0.000000','0.000000','0','36','202412101130','','','','0','0',NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `customer_loyalty_points` (`_id`, `phoneno`, `points`) VALUES (1,'9977339312','2147483647');
INSERT INTO `discountdetails` (`_id`, `date`, `time`, `billno`, `Discountcodeno`, `Discount_percent`, `Billamount_rupess`, `Discount_rupees`, `date1`, `original_amount`, `billcount`, `datetimee_new`, `paymentmethod`) VALUES (1,NULL,NULL,'20240904-000011',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(2,NULL,NULL,'20240904-000012',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(3,NULL,NULL,'20241122-000011',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(4,NULL,NULL,'20241125-000031',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(5,NULL,NULL,'20241126-000011',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(6,NULL,NULL,'20241204-000011',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(7,NULL,NULL,'20241205-000011',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(8,NULL,NULL,'20241209-000011',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(9,NULL,NULL,'20241209-000012',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(10,NULL,NULL,'20241209-000013',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(11,NULL,NULL,'20241209-000014',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(12,NULL,NULL,'20241209-000015',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(13,NULL,NULL,'20241209-000016',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(14,NULL,NULL,'20241210-000011',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(15,NULL,NULL,'20241210-000012',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(16,NULL,NULL,'20241210-000013',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(17,NULL,NULL,'20241210-000013',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'bread crumbs 300g',30),(2,'capsicum green kg',160),(3,'cauliflower kg',180),(4,'eggs 6pcs',76),(5,'fig fruit kg',1000),(6,'ladies finger kg',28),(7,'muskmelon kg',45),(8,'nutella',510),(9,'sona masoori raw rice 1kg',112);
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,'436','bread crumbs 300g',30,1,'1','bread bakery and eggs',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'6','capsicum green kg',160,8,'2','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'8','cauliflower kg',180,8,'4','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'306','eggs 6pcs',76,4,'2','bread bakery and eggs',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'4','fig fruit kg',1000,47,'4','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'5','ladies finger kg',28,1,'1','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'33','muskmelon kg',45,2,'1','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'3','nutella',510,24,'3','branded foods',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'1','sona masoori raw rice 1kg',112,5,'2','rice whole grains',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (17,'branded foods',510),(18,'bread bakery and eggs',106),(19,'fruits and vegetables',1413),(20,'rice whole grains',112);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'madmin',2141);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,NULL,2141,100);
