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,'Business ','3.0','800.00','2400.00','Item',NULL,NULL,'no',NULL,NULL,'20240614-000011','12:16:55 pm','2024 06 14','admin','1','  General','  Cash','2400.00','2400.00','1',NULL,NULL,NULL,NULL,'14 Jun 2024','2024061412:16:55','%','0','800.00','no','0.00',NULL,'202406141216','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Printing','admin','madmin',NULL,NULL,'',NULL,'2400.00','','','','',NULL,'800.00'),(2,'capsicum green kg','2.0','80.00','160.00','Item',NULL,NULL,'no',NULL,NULL,'20240614-000012','12:46:51 pm','2024 06 14','admin','1','  General','  Cash','1180.00','1180.00','2',NULL,NULL,NULL,NULL,'14 Jun 2024','2024061412:46:51','%','0','160.00','no','0.00',NULL,'202406141246','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'160.00','','','','',NULL,'80.00'),(3,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240614-000012','12:46:51 pm','2024 06 14','admin','1','  General','  Cash','1180.00','1180.00','3',NULL,NULL,NULL,NULL,'14 Jun 2024','2024061412:46:51','%','0','56.00','no','0.00',NULL,'202406141246','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(4,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240614-000012','12:46:51 pm','2024 06 14','admin','1','  General','  Cash','1180.00','1180.00','4',NULL,NULL,NULL,NULL,'14 Jun 2024','2024061412:46:51','%','0','250.00','no','0.00',NULL,'202406141246','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(5,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20240614-000012','12:46:51 pm','2024 06 14','admin','1','  General','  Cash','1180.00','1180.00','5',NULL,NULL,NULL,NULL,'14 Jun 2024','2024061412:46:51','%','0','170.00','no','0.00',NULL,'202406141246','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin',NULL,NULL,'',NULL,'170.00','','','','',NULL,'170.00'),(6,'ladies finger kg','1.0','28.00','28.00','Item',NULL,NULL,'no',NULL,NULL,'20240614-000012','12:46:51 pm','2024 06 14','admin','1','  General','  Cash','1180.00','1180.00','6',NULL,NULL,NULL,NULL,'14 Jun 2024','2024061412:46:51','%','0','28.00','no','0.00',NULL,'202406141246','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'28.00','','','','',NULL,'28.00'),(7,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240614-000012','12:46:51 pm','2024 06 14','admin','1','  General','  Cash','1180.00','1180.00','7',NULL,NULL,NULL,NULL,'14 Jun 2024','2024061412:46:51','%','0','250.00','no','0.00',NULL,'202406141246','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(8,'carrots kg','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240614-000012','12:46:51 pm','2024 06 14','admin','1','  General','  Cash','1180.00','1180.00','8',NULL,NULL,NULL,NULL,'14 Jun 2024','2024061412:46:51','%','0','70.00','no','0.00',NULL,'202406141246','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'70.00','','','','',NULL,'70.00'),(9,'cauliflower kg','1.0','45.00','45.00','Item',NULL,NULL,'no',NULL,NULL,'20240614-000012','12:46:51 pm','2024 06 14','admin','1','  General','  Cash','1180.00','1180.00','9',NULL,NULL,NULL,NULL,'14 Jun 2024','2024061412:46:51','%','0','45.00','no','0.00',NULL,'202406141246','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'45.00','','','','',NULL,'45.00'),(10,'beans kg','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240614-000012','12:46:51 pm','2024 06 14','admin','1','  General','  Cash','1180.00','1180.00','10',NULL,NULL,NULL,NULL,'14 Jun 2024','2024061412:46:51','%','0','40.00','no','0.00',NULL,'202406141246','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(11,'loreal color 90gms','1.0','76.00','76.00','Item',NULL,NULL,'no',NULL,NULL,'20240614-000012','12:46:51 pm','2024 06 14','admin','1','  General','  Cash','1180.00','1180.00','11',NULL,NULL,NULL,NULL,'14 Jun 2024','2024061412:46:51','%','0','76.00','no','0.00',NULL,'202406141246','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','admin','madmin',NULL,NULL,'',NULL,'76.00','','','','',NULL,'76.00'),(12,'cucumbers kg','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240614-000012','12:46:51 pm','2024 06 14','admin','1','  General','  Cash','1180.00','1180.00','12',NULL,NULL,NULL,NULL,'14 Jun 2024','2024061412:46:51','%','0','20.00','no','0.00',NULL,'202406141246','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(13,'sweet corn piece','1.0','15.00','15.00','Item',NULL,NULL,'no',NULL,NULL,'20240614-000012','12:46:51 pm','2024 06 14','admin','1','  General','  Cash','1180.00','1180.00','13',NULL,NULL,NULL,NULL,'14 Jun 2024','2024061412:46:51','%','0','15.00','no','0.00',NULL,'202406141246','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'15.00','','','','',NULL,'15.00'),(14,'beans kg','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240614-000013','12:47:14 pm','2024 06 14','admin','1','  General','  Cash','783.00','783.00','14',NULL,NULL,NULL,NULL,'14 Jun 2024','2024061412:47:14','%','0','40.00','no','0.00',NULL,'202406141247','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(15,'cauliflower kg','1.0','45.00','45.00','Item',NULL,NULL,'no',NULL,NULL,'20240614-000013','12:47:14 pm','2024 06 14','admin','1','  General','  Cash','783.00','783.00','15',NULL,NULL,NULL,NULL,'14 Jun 2024','2024061412:47:14','%','0','45.00','no','0.00',NULL,'202406141247','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'45.00','','','','',NULL,'45.00'),(16,'ladies finger kg','1.0','28.00','28.00','Item',NULL,NULL,'no',NULL,NULL,'20240614-000013','12:47:14 pm','2024 06 14','admin','1','  General','  Cash','783.00','783.00','16',NULL,NULL,NULL,NULL,'14 Jun 2024','2024061412:47:14','%','0','28.00','no','0.00',NULL,'202406141247','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'28.00','','','','',NULL,'28.00'),(17,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240614-000013','12:47:14 pm','2024 06 14','admin','1','  General','  Cash','783.00','783.00','17',NULL,NULL,NULL,NULL,'14 Jun 2024','2024061412:47:14','%','0','250.00','no','0.00',NULL,'202406141247','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(18,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240614-000013','12:47:14 pm','2024 06 14','admin','1','  General','  Cash','783.00','783.00','18',NULL,NULL,NULL,NULL,'14 Jun 2024','2024061412:47:14','%','0','250.00','no','0.00',NULL,'202406141247','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(19,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20240614-000013','12:47:14 pm','2024 06 14','admin','1','  General','  Cash','783.00','783.00','19',NULL,NULL,NULL,NULL,'14 Jun 2024','2024061412:47:14','%','0','170.00','no','0.00',NULL,'202406141247','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin',NULL,NULL,'',NULL,'170.00','','','','',NULL,'170.00'),(20,'bananas robusta kg','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240621-000011','04:34:19 PM','2024 06 21','admin','1','  General','  Cash','416.00','416.00','1',NULL,NULL,NULL,NULL,'21 Jun 2024','2024062116:34:19','%','0','40.00','no','0.00',NULL,'202406211634','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(21,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240621-000011','04:34:19 PM','2024 06 21','admin','1','  General','  Cash','416.00','416.00','2',NULL,NULL,NULL,NULL,'21 Jun 2024','2024062116:34:19','%','0','56.00','no','0.00',NULL,'202406211634','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(22,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240621-000011','04:34:19 PM','2024 06 21','admin','1','  General','  Cash','416.00','416.00','3',NULL,NULL,NULL,NULL,'21 Jun 2024','2024062116:34:19','%','0','250.00','no','0.00',NULL,'202406211634','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(23,'carrots kg','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240621-000011','04:34:19 PM','2024 06 21','admin','1','  General','  Cash','416.00','416.00','4',NULL,NULL,NULL,NULL,'21 Jun 2024','2024062116:34:19','%','0','70.00','no','0.00',NULL,'202406211634','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'70.00','','','','',NULL,'70.00'),(24,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240715-000011','03:07:38 PM','2024 07 15','admin','1','  General','  Cash','351.00','351.00','6',NULL,NULL,NULL,NULL,'15 Jul 2024','2024071515:07:38','%','0','56.00','no','0.00',NULL,'202407151507','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(25,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240715-000011','03:07:38 PM','2024 07 15','admin','1','  General','  Cash','351.00','351.00','7',NULL,NULL,NULL,NULL,'15 Jul 2024','2024071515:07:38','%','0','250.00','no','0.00',NULL,'202407151507','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(26,'cauliflower kg','1.0','45.00','45.00','Item',NULL,NULL,'no',NULL,NULL,'20240715-000011','03:07:38 PM','2024 07 15','admin','1','  General','  Cash','351.00','351.00','8',NULL,NULL,NULL,NULL,'15 Jul 2024','2024071515:07:38','%','0','45.00','no','0.00',NULL,'202407151507','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'45.00','','','','',NULL,'45.00'),(27,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240716-000011','12:17:16 pm','2024 07 16','admin','1','  General','  Cash','590.00','590.00','1',NULL,NULL,NULL,NULL,'16 Jul 2024','2024071612:17:16','%','0','250.00','no','0.00',NULL,'202407161217','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(28,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20240716-000011','12:17:16 pm','2024 07 16','admin','1','  General','  Cash','590.00','590.00','2',NULL,NULL,NULL,NULL,'16 Jul 2024','2024071612:17:16','%','0','170.00','no','0.00',NULL,'202407161217','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin',NULL,NULL,'',NULL,'170.00','','','','',NULL,'170.00'),(29,'capsicum green kg','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240716-000011','12:17:16 pm','2024 07 16','admin','1','  General','  Cash','590.00','590.00','3',NULL,NULL,NULL,NULL,'16 Jul 2024','2024071612:17:16','%','0','80.00','no','0.00',NULL,'202407161217','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(30,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240716-000012','12:17:45 pm','2024 07 16','admin','1','  General','  Cash','984.12','984.12','4',NULL,NULL,NULL,NULL,'16 Jul 2024','2024071612:17:45','%','0','56.00','no','0.00',NULL,'202407161217','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(31,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240716-000012','12:17:45 pm','2024 07 16','admin','1','  General','  Cash','984.12','984.12','5',NULL,NULL,NULL,NULL,'16 Jul 2024','2024071612:17:45','%','0','250.00','no','0.00',NULL,'202407161217','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(32,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20240716-000012','12:17:45 pm','2024 07 16','admin','1','  General','  Cash','984.12','984.12','6',NULL,NULL,NULL,NULL,'16 Jul 2024','2024071612:17:45','%','0','170.00','no','0.00',NULL,'202407161217','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin',NULL,NULL,'',NULL,'170.00','','','','',NULL,'170.00'),(33,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240716-000012','12:17:45 pm','2024 07 16','admin','1','  General','  Cash','984.12','984.12','7',NULL,NULL,NULL,NULL,'16 Jul 2024','2024071612:17:45','%','0','250.00','no','0.00',NULL,'202407161217','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(34,'ladies finger kg','1.0','28.00','28.00','Item',NULL,NULL,'no',NULL,NULL,'20240716-000012','12:17:45 pm','2024 07 16','admin','1','  General','  Cash','984.12','984.12','8',NULL,NULL,NULL,NULL,'16 Jul 2024','2024071612:17:45','%','0','28.00','no','0.00',NULL,'202407161217','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'28.00','','','','',NULL,'28.00'),(35,'capsicum green kg','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240716-000012','12:17:45 pm','2024 07 16','admin','1','  General','  Cash','984.12','984.12','9',NULL,NULL,NULL,NULL,'16 Jul 2024','2024071612:17:45','%','0','80.00','no','0.00',NULL,'202407161217','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(36,'tata urad dal whole white 1kg','2.0','250.00','500.00','Item',NULL,NULL,'no',NULL,NULL,'20240716-000013','12:29:56 pm','2024 07 16','admin','1','  General','  Cash','1902.16','1902.16','10',NULL,NULL,NULL,NULL,'16 Jul 2024','2024071612:29:56','%','0','500.00','no','0.00',NULL,'202407161229','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin',NULL,NULL,'',NULL,'500.00','','','','',NULL,'250.00'),(37,'nutella','2.0','170.00','340.00','Item',NULL,NULL,'no',NULL,NULL,'20240716-000013','12:29:56 pm','2024 07 16','admin','1','  General','  Cash','1902.16','1902.16','11',NULL,NULL,NULL,NULL,'16 Jul 2024','2024071612:29:56','%','0','340.00','no','0.00',NULL,'202407161229','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin',NULL,NULL,'',NULL,'340.00','','','','',NULL,'170.00'),(38,'capsicum green kg','2.0','80.00','160.00','Item',NULL,NULL,'no',NULL,NULL,'20240716-000013','12:29:56 pm','2024 07 16','admin','1','  General','  Cash','1902.16','1902.16','12',NULL,NULL,NULL,NULL,'16 Jul 2024','2024071612:29:56','%','0','160.00','no','0.00',NULL,'202407161229','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'160.00','','','','',NULL,'80.00'),(39,'ladies finger kg','2.0','28.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240716-000013','12:29:56 pm','2024 07 16','admin','1','  General','  Cash','1902.16','1902.16','13',NULL,NULL,NULL,NULL,'16 Jul 2024','2024071612:29:56','%','0','56.00','no','0.00',NULL,'202407161229','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'56.00','','','','',NULL,'28.00'),(40,'fig fruit kg','2.0','250.00','500.00','Item',NULL,NULL,'no',NULL,NULL,'20240716-000013','12:29:56 pm','2024 07 16','admin','1','  General','  Cash','1902.16','1902.16','14',NULL,NULL,NULL,NULL,'16 Jul 2024','2024071612:29:56','%','0','500.00','no','0.00',NULL,'202407161229','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'500.00','','','','',NULL,'250.00'),(41,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240716-000013','12:29:56 pm','2024 07 16','admin','1','  General','  Cash','1902.16','1902.16','15',NULL,NULL,NULL,NULL,'16 Jul 2024','2024071612:29:56','%','0','56.00','no','0.00',NULL,'202407161229','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(42,'sweet corn piece','1.0','15.00','15.00','Item',NULL,NULL,'no',NULL,NULL,'20240716-000014','03:54:36 pm','2024 07 16','admin','1','  General','  Cash','220.66','220.66','1',NULL,NULL,NULL,NULL,'16 Jul 2024','2024071615:54:36','%','0','15.00','no','0.00',NULL,'202407161554','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'15.00','','','','',NULL,'15.00'),(43,'cucumbers kg','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240716-000014','03:54:36 pm','2024 07 16','admin','1','  General','  Cash','220.66','220.66','2',NULL,NULL,NULL,NULL,'16 Jul 2024','2024071615:54:36','%','0','20.00','no','0.00',NULL,'202407161554','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(44,'loreal color 90gms','1.0','76.00','76.00','Item',NULL,NULL,'no',NULL,NULL,'20240716-000014','03:54:36 pm','2024 07 16','admin','1','  General','  Cash','220.66','220.66','3',NULL,NULL,NULL,NULL,'16 Jul 2024','2024071615:54:36','%','0','76.00','no','0.00',NULL,'202407161554','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','admin','madmin',NULL,NULL,'',NULL,'76.00','','','','',NULL,'76.00'),(45,'beet root kg','1.0','32.00','32.00','Item',NULL,NULL,'no',NULL,NULL,'20240716-000014','03:54:36 pm','2024 07 16','admin','1','  General','  Cash','220.66','220.66','4',NULL,NULL,NULL,NULL,'16 Jul 2024','2024071615:54:36','%','0','32.00','no','0.00',NULL,'202407161554','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'32.00','','','','',NULL,'32.00'),(46,'onions big kg','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240716-000014','03:54:36 pm','2024 07 16','admin','1','  General','  Cash','220.66','220.66','5',NULL,NULL,NULL,NULL,'16 Jul 2024','2024071615:54:36','%','0','20.00','no','0.00',NULL,'202407161554','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(47,'radish white kg','1.0','24.00','24.00','Item',NULL,NULL,'no',NULL,NULL,'20240716-000014','03:54:36 pm','2024 07 16','admin','1','  General','  Cash','220.66','220.66','6',NULL,NULL,NULL,NULL,'16 Jul 2024','2024071615:54:36','%','0','24.00','no','0.00',NULL,'202407161554','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'24.00','','','','',NULL,'24.00'),(48,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240716-000015','03:55:15 pm','2024 07 16','admin','1','  General','  Cash','889.72','889.72','7',NULL,NULL,NULL,NULL,'16 Jul 2024','2024071615:55:15','%','0','56.00','no','0.00',NULL,'202407161555','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(49,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240716-000015','03:55:15 pm','2024 07 16','admin','1','  General','  Cash','889.72','889.72','8',NULL,NULL,NULL,NULL,'16 Jul 2024','2024071615:55:15','%','0','250.00','no','0.00',NULL,'202407161555','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(50,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20240716-000015','03:55:15 pm','2024 07 16','admin','1','  General','  Cash','889.72','889.72','9',NULL,NULL,NULL,NULL,'16 Jul 2024','2024071615:55:15','%','0','170.00','no','0.00',NULL,'202407161555','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin',NULL,NULL,'',NULL,'170.00','','','','',NULL,'170.00'),(51,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240716-000015','03:55:15 pm','2024 07 16','admin','1','  General','  Cash','889.72','889.72','10',NULL,NULL,NULL,NULL,'16 Jul 2024','2024071615:55:15','%','0','250.00','no','0.00',NULL,'202407161555','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(52,'ladies finger kg','1.0','28.00','28.00','Item',NULL,NULL,'no',NULL,NULL,'20240716-000015','03:55:15 pm','2024 07 16','admin','1','  General','  Cash','889.72','889.72','11',NULL,NULL,NULL,NULL,'16 Jul 2024','2024071615:55:15','%','0','28.00','no','0.00',NULL,'202407161555','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'28.00','','','','',NULL,'28.00'),(53,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240716-000016','03:58:16 pm','2024 07 16','admin','1','  General','  Cash','623.04','623.04','12',NULL,NULL,NULL,NULL,'16 Jul 2024','2024071615:58:16','%','0','250.00','no','0.00',NULL,'202407161558','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(54,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20240716-000016','03:58:16 pm','2024 07 16','admin','1','  General','  Cash','623.04','623.04','13',NULL,NULL,NULL,NULL,'16 Jul 2024','2024071615:58:16','%','0','170.00','no','0.00',NULL,'202407161558','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin',NULL,NULL,'',NULL,'170.00','','','','',NULL,'170.00'),(55,'capsicum green kg','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240716-000016','03:58:16 pm','2024 07 16','admin','1','  General','  Cash','623.04','623.04','14',NULL,NULL,NULL,NULL,'16 Jul 2024','2024071615:58:16','%','0','80.00','no','0.00',NULL,'202407161558','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(56,'ladies finger kg','1.0','28.00','28.00','Item',NULL,NULL,'no',NULL,NULL,'20240716-000016','03:58:16 pm','2024 07 16','admin','1','  General','  Cash','623.04','623.04','15',NULL,NULL,NULL,NULL,'16 Jul 2024','2024071615:58:16','%','0','28.00','no','0.00',NULL,'202407161558','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'28.00','','','','',NULL,'28.00'),(57,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240717-000011','03:25:24 pm','2024 07 17','admin','1','  General','  Cash','306.00','306.00','7',NULL,NULL,NULL,NULL,'17 Jul 2024','2024071715:25:24','%','0','56.00','no','0.00',NULL,'202407171525','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(58,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240717-000011','03:25:24 pm','2024 07 17','admin','1','  General','  Cash','306.00','306.00','8',NULL,NULL,NULL,NULL,'17 Jul 2024','2024071715:25:24','%','0','250.00','no','0.00',NULL,'202407171525','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(59,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240717-000012','03:30:04 pm','2024 07 17','admin','1','  General','  Cash','306.00','306.00','9',NULL,NULL,NULL,NULL,'17 Jul 2024','2024071715:30:04','%','0','56.00','no','0.00',NULL,'202407171530','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(60,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240717-000012','03:30:04 pm','2024 07 17','admin','1','  General','  Cash','306.00','306.00','10',NULL,NULL,NULL,NULL,'17 Jul 2024','2024071715:30:04','%','0','250.00','no','0.00',NULL,'202407171530','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(61,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240718-000011','10:50:08 am','2024 07 18','admin','1','  General','  Cash','358.00','358.00','11',NULL,NULL,NULL,NULL,'18 Jul 2024','2024071810:50:08','%','0','250.00','no','0.00',NULL,'202407181050','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(62,'ladies finger kg','1.0','28.00','28.00','Item',NULL,NULL,'no',NULL,NULL,'20240718-000011','10:50:08 am','2024 07 18','admin','1','  General','  Cash','358.00','358.00','12',NULL,NULL,NULL,NULL,'18 Jul 2024','2024071810:50:08','%','0','28.00','no','0.00',NULL,'202407181050','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'28.00','','','','',NULL,'28.00'),(63,'capsicum green kg','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240718-000011','10:50:08 am','2024 07 18','admin','1','  General','  Cash','358.00','358.00','13',NULL,NULL,NULL,NULL,'18 Jul 2024','2024071810:50:08','%','0','80.00','no','0.00',NULL,'202407181050','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(64,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240718-000012','10:51:07 am','2024 07 18','admin','1','  General','  Cash','513.00','513.00','14',NULL,NULL,NULL,NULL,'18 Jul 2024','2024071810:51:07','%','0','250.00','no','0.00',NULL,'202407181051','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(65,'ladies finger kg','1.0','28.00','28.00','Item',NULL,NULL,'no',NULL,NULL,'20240718-000012','10:51:07 am','2024 07 18','admin','1','  General','  Cash','513.00','513.00','15',NULL,NULL,NULL,NULL,'18 Jul 2024','2024071810:51:07','%','0','28.00','no','0.00',NULL,'202407181051','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'28.00','','','','',NULL,'28.00'),(66,'capsicum green kg','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240718-000012','10:51:07 am','2024 07 18','admin','1','  General','  Cash','513.00','513.00','16',NULL,NULL,NULL,NULL,'18 Jul 2024','2024071810:51:07','%','0','80.00','no','0.00',NULL,'202407181051','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(67,'beans kg','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240718-000012','10:51:07 am','2024 07 18','admin','1','  General','  Cash','513.00','513.00','17',NULL,NULL,NULL,NULL,'18 Jul 2024','2024071810:51:07','%','0','40.00','no','0.00',NULL,'202407181051','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(68,'cauliflower kg','1.0','45.00','45.00','Item',NULL,NULL,'no',NULL,NULL,'20240718-000012','10:51:07 am','2024 07 18','admin','1','  General','  Cash','513.00','513.00','18',NULL,NULL,NULL,NULL,'18 Jul 2024','2024071810:51:07','%','0','45.00','no','0.00',NULL,'202407181051','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'45.00','','','','',NULL,'45.00'),(69,'carrots kg','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240718-000012','10:51:07 am','2024 07 18','admin','1','  General','  Cash','513.00','513.00','19',NULL,NULL,NULL,NULL,'18 Jul 2024','2024071810:51:07','%','0','70.00','no','0.00',NULL,'202407181051','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'70.00','','','','',NULL,'70.00'),(70,'sona masoori raw rice 1kg','1','56.00','56','Item','null','null','no','null','None','20240808-000011','3:08:02 PM','2024 08 08','madmin','1','  General','  cash','0','0','1','null','null','null','null','08Aug24','2024080803:008:002','%','0','','','','test','2024080803:008:002','','null','null','null','null','null','null','null','null','rice whole grains','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(71,'urad dal split 2kg','1','394.00','394.00','Item','null','null','no','null','None','20240808-000012','3:37:52 PM','2024 08 08','madmin','1','  General','  Pay Later','0','0','40','null','null','null','null','08Aug24','2024080803:37:52','%','0','','','','test','2024080803:37:52','','null','null','null','null','null','null','null','null','dals and pulses','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(72,'urad black split 500g','1','110.00','110.00','Item','null','null','no','null','None','20240808-000012','3:37:52 PM','2024 08 08','madmin','1','  General','  Pay Later','0','0','41','null','null','null','null','08Aug24','2024080803:37:52','%','0','','','','test','2024080803:37:52','','null','null','null','null','null','null','null','null','dals and pulses','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(73,'urad dal black split loose kg','1','200.00','200.00','Item','null','null','no','null','None','20240808-000012','3:37:52 PM','2024 08 08','madmin','1','  General','  Pay Later','0','0','42','null','null','null','null','08Aug24','2024080803:37:52','%','0','','','','test','2024080803:37:52','','null','null','null','null','null','null','null','null','dals and pulses','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(74,'tata tea premium 250g','2','80.00','160.00','Item','null','null','no','null','None','20240808-000012','3:37:52 PM','2024 08 08','madmin','1','  General','  Pay Later','0','0','45','null','null','null','null','08Aug24','2024080803:37:52','%','0','','','','test','2024080803:37:52','','null','null','null','null','null','null','null','null','beverages','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(75,'rin 500gm','1','37.00','37.00','Item','null','null','no','null','None','20240808-000013','3:38:43 PM','2024 08 08','madmin','1','  General','  card','0','0','66','null','null','null','null','08Aug24','2024080803:38:43','%','0','','','','test','2024080803:38:43','','null','null','null','null','null','null','null','null','household','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(76,'surfexcel blue 70gm','1','76.00','76.00','Item','null','null','no','null','None','20240808-000013','3:38:43 PM','2024 08 08','madmin','1','  General','  card','0','0','67','null','null','null','null','08Aug24','2024080803:38:43','%','0','','','','test','2024080803:38:43','','null','null','null','null','null','null','null','null','household','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(77,'surfexcel bar 100gm','1','10.00','10.00','Item','null','null','no','null','None','20240808-000013','3:38:43 PM','2024 08 08','madmin','1','  General','  card','0','0','68','null','null','null','null','08Aug24','2024080803:38:43','%','0','','','','test','2024080803:38:43','','null','null','null','null','null','null','null','null','household','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(78,'english muffins 100g','2','69.00','138','Item','null','null','no','null','None','20240809-000011','1:11:42 PM','2024 08 09','madmin','1','  General','  cash','0','0','305','null','null','null','null','09Aug24','2024080901:11:42','currency','18','','','','test','2024080901:11:42','','null','null','null','null','null','null','null','null','bread bakery and eggs','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(79,'tata urad dal whole white 1kg','2','250.00','500','Item','null','null','no','null','None','20240809-000011','1:11:42 PM','2024 08 09','madmin','1','  General','  cash','0','0','2','null','null','null','null','09Aug24','2024080901:11:42','currency','20','','','','test','2024080901:11:42','','null','null','null','null','null','null','null','null','dals pulses','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(80,'fig fruit kg','1','250.00','250','Item','null','null','no','null','None','20240809-000011','1:11:42 PM','2024 08 09','madmin','1','  General','  cash','0','0','4','null','null','null','null','09Aug24','2024080901:11:42','%','10','','','','test','2024080901:11:42','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(81,'sona masoori raw rice 1kg','1','56.00','56.00','Item','null','null','no','null','None','20240810-000011','11:25:35 AM','2024 08 10','madmin','1','  General','  cash','0','0','1','null','null','null','null','10Aug24','2024081011:25:35','%','0','','','','test','2024081011:25:35','','null','null','null','null','null','null','null','null','rice whole grains','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(82,'tata urad dal whole white 1kg','1','250.00','250.00','Item','null','null','no','null','None','20240810-000011','11:25:35 AM','2024 08 10','madmin','1','  General','  cash','0','0','2','null','null','null','null','10Aug24','2024081011:25:35','%','0','','','','test','2024081011:25:35','','null','null','null','null','null','null','null','null','dals pulses','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(83,'nutella','1','170.00','170.00','Item','null','null','no','null','None','20240810-000012','11:28:02 AM','2024 08 10','madmin','1','  General','  cash','0','0','3','null','null','null','null','10Aug24','2024081011:28:002','%','0','','','','test','2024081011:28:002','','null','null','null','null','null','null','null','null','branded foods','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(84,'tata urad dal whole white 1kg','1','250.00','250.00','Item','null','null','no','null','None','20240810-000012','11:28:02 AM','2024 08 10','madmin','1','  General','  cash','0','0','2','null','null','null','null','10Aug24','2024081011:28:002','%','0','','','','test','2024081011:28:002','','null','null','null','null','null','null','null','null','dals pulses','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(85,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240812-000011','01:03:13 pm','2024 08 12','admin','1','  General','  Cash','450.00','500.00','1',NULL,NULL,NULL,NULL,'12 Aug 2024','2024081213:03:13','%','0','250.00','no','0.00',NULL,'202408121303','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(86,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20240812-000011','01:03:13 pm','2024 08 12','admin','1','  General','  Cash','450.00','500.00','2',NULL,NULL,NULL,NULL,'12 Aug 2024','2024081213:03:13','%','0','170.00','no','0.00',NULL,'202408121303','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin',NULL,NULL,'',NULL,'170.00','','','','',NULL,'170.00'),(87,'capsicum green kg','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240812-000011','01:03:13 pm','2024 08 12','admin','1','  General','  Cash','450.00','500.00','3',NULL,NULL,NULL,NULL,'12 Aug 2024','2024081213:03:13','%','0','80.00','no','0.00',NULL,'202408121303','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(88,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240813-000011','03:08:30 pm','2024 08 13','admin','1','  General','  Cash','750.60','834.00','4',NULL,NULL,NULL,NULL,'13 Aug 2024','2024081315:08:30','%','0','56.00','no','0.00',NULL,'202408131508','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(89,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240813-000011','03:08:30 pm','2024 08 13','admin','1','  General','  Cash','750.60','834.00','5',NULL,NULL,NULL,NULL,'13 Aug 2024','2024081315:08:30','%','0','250.00','no','0.00',NULL,'202408131508','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(90,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20240813-000011','03:08:30 pm','2024 08 13','admin','1','  General','  Cash','750.60','834.00','6',NULL,NULL,NULL,NULL,'13 Aug 2024','2024081315:08:30','%','0','170.00','no','0.00',NULL,'202408131508','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin',NULL,NULL,'',NULL,'170.00','','','','',NULL,'170.00'),(91,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240813-000011','03:08:30 pm','2024 08 13','admin','1','  General','  Cash','750.60','834.00','7',NULL,NULL,NULL,NULL,'13 Aug 2024','2024081315:08:30','%','0','250.00','no','0.00',NULL,'202408131508','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(92,'ladies finger kg','1.0','28.00','28.00','Item',NULL,NULL,'no',NULL,NULL,'20240813-000011','03:08:30 pm','2024 08 13','admin','1','  General','  Cash','750.60','834.00','8',NULL,NULL,NULL,NULL,'13 Aug 2024','2024081315:08:30','%','0','28.00','no','0.00',NULL,'202408131508','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'28.00','','','','',NULL,'28.00'),(93,'capsicum green kg','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240813-000011','03:08:30 pm','2024 08 13','admin','1','  General','  Cash','750.60','834.00','9',NULL,NULL,NULL,NULL,'13 Aug 2024','2024081315:08:30','%','0','80.00','no','0.00',NULL,'202408131508','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(94,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240813-000012','03:09:47 pm','2024 08 13','admin','1','  General','  Cash','667.20','834.00','10',NULL,NULL,NULL,NULL,'13 Aug 2024','2024081315:09:47','%','0','56.00','no','0.00',NULL,'202408131509','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(95,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240813-000012','03:09:47 pm','2024 08 13','admin','1','  General','  Cash','667.20','834.00','11',NULL,NULL,NULL,NULL,'13 Aug 2024','2024081315:09:47','%','0','250.00','no','0.00',NULL,'202408131509','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(96,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20240813-000012','03:09:47 pm','2024 08 13','admin','1','  General','  Cash','667.20','834.00','12',NULL,NULL,NULL,NULL,'13 Aug 2024','2024081315:09:47','%','0','170.00','no','0.00',NULL,'202408131509','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin',NULL,NULL,'',NULL,'170.00','','','','',NULL,'170.00'),(97,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240813-000012','03:09:47 pm','2024 08 13','admin','1','  General','  Cash','667.20','834.00','13',NULL,NULL,NULL,NULL,'13 Aug 2024','2024081315:09:47','%','0','250.00','no','0.00',NULL,'202408131509','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(98,'ladies finger kg','1.0','28.00','28.00','Item',NULL,NULL,'no',NULL,NULL,'20240813-000012','03:09:47 pm','2024 08 13','admin','1','  General','  Cash','667.20','834.00','14',NULL,NULL,NULL,NULL,'13 Aug 2024','2024081315:09:47','%','0','28.00','no','0.00',NULL,'202408131509','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'28.00','','','','',NULL,'28.00'),(99,'capsicum green kg','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240813-000012','03:09:47 pm','2024 08 13','admin','1','  General','  Cash','667.20','834.00','15',NULL,NULL,NULL,NULL,'13 Aug 2024','2024081315:09:47','%','0','80.00','no','0.00',NULL,'202408131509','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(100,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240813-000013','03:11:14 pm','2024 08 13','admin','1','  General','  Cash','403.20','504.00','16',NULL,NULL,NULL,NULL,'13 Aug 2024','2024081315:11:14','%','0','250.00','no','0.00',NULL,'202408131511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(101,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20240813-000013','03:11:14 pm','2024 08 13','admin','1','  General','  Cash','403.20','504.00','17',NULL,NULL,NULL,NULL,'13 Aug 2024','2024081315:11:14','%','0','170.00','no','0.00',NULL,'202408131511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin',NULL,NULL,'',NULL,'170.00','','','','',NULL,'170.00'),(102,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240813-000013','03:11:14 pm','2024 08 13','admin','1','  General','  Cash','403.20','504.00','18',NULL,NULL,NULL,NULL,'13 Aug 2024','2024081315:11:14','%','0','56.00','no','0.00',NULL,'202408131511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(103,'ladies finger kg','1.0','28.00','28.00','Item',NULL,NULL,'no',NULL,NULL,'20240813-000013','03:11:14 pm','2024 08 13','admin','1','  General','  Cash','403.20','504.00','19',NULL,NULL,NULL,NULL,'13 Aug 2024','2024081315:11:14','%','0','28.00','no','0.00',NULL,'202408131511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'28.00','','','','',NULL,'28.00'),(104,'capsicum green kg','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240813-000014','03:11:45 pm','2024 08 13','admin','1','  General','  Cash','614.70','683.00','20',NULL,NULL,NULL,NULL,'13 Aug 2024','2024081315:11:45','%','0','80.00','no','0.00',NULL,'202408131511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(105,'ladies finger kg','1.0','28.00','28.00','Item',NULL,NULL,'no',NULL,NULL,'20240813-000014','03:11:45 pm','2024 08 13','admin','1','  General','  Cash','614.70','683.00','21',NULL,NULL,NULL,NULL,'13 Aug 2024','2024081315:11:45','%','0','28.00','no','0.00',NULL,'202408131511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'28.00','','','','',NULL,'28.00'),(106,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240813-000014','03:11:45 pm','2024 08 13','admin','1','  General','  Cash','614.70','683.00','22',NULL,NULL,NULL,NULL,'13 Aug 2024','2024081315:11:45','%','0','250.00','no','0.00',NULL,'202408131511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(107,'beans kg','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240813-000014','03:11:45 pm','2024 08 13','admin','1','  General','  Cash','614.70','683.00','23',NULL,NULL,NULL,NULL,'13 Aug 2024','2024081315:11:45','%','0','40.00','no','0.00',NULL,'202408131511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(108,'cauliflower kg','1.0','45.00','45.00','Item',NULL,NULL,'no',NULL,NULL,'20240813-000014','03:11:45 pm','2024 08 13','admin','1','  General','  Cash','614.70','683.00','24',NULL,NULL,NULL,NULL,'13 Aug 2024','2024081315:11:45','%','0','45.00','no','0.00',NULL,'202408131511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'45.00','','','','',NULL,'45.00'),(109,'carrots kg','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240813-000014','03:11:45 pm','2024 08 13','admin','1','  General','  Cash','614.70','683.00','25',NULL,NULL,NULL,NULL,'13 Aug 2024','2024081315:11:45','%','0','70.00','no','0.00',NULL,'202408131511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'HERBALIFE','admin','madmin',NULL,NULL,'',NULL,'70.00','','','','',NULL,'70.00'),(110,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20240813-000014','03:11:45 pm','2024 08 13','admin','1','  General','  Cash','614.70','683.00','26',NULL,NULL,NULL,NULL,'13 Aug 2024','2024081315:11:45','%','0','170.00','no','0.00',NULL,'202408131511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin',NULL,NULL,'',NULL,'170.00','','','','',NULL,'170.00'),(111,'urad gota whole 500g','1.0','99.00','99.00','Item',NULL,NULL,'no',NULL,NULL,'20240813-000015','03:12:15 pm','2024 08 13','admin','1','  General','  Cash','494.90','707.00','27',NULL,NULL,NULL,NULL,'13 Aug 2024','2024081315:12:15','%','0','99.00','no','0.00',NULL,'202408131512','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'99.00','','','','',NULL,'99.00'),(112,'urad dal split 2kg','1.0','394.00','394.00','Item',NULL,NULL,'no',NULL,NULL,'20240813-000015','03:12:15 pm','2024 08 13','admin','1','  General','  Cash','494.90','707.00','28',NULL,NULL,NULL,NULL,'13 Aug 2024','2024081315:12:15','%','0','394.00','no','0.00',NULL,'202408131512','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'394.00','','','','',NULL,'394.00'),(113,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20240813-000015','03:12:15 pm','2024 08 13','admin','1','  General','  Cash','494.90','707.00','29',NULL,NULL,NULL,NULL,'13 Aug 2024','2024081315:12:15','%','0','170.00','no','0.00',NULL,'202408131512','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin',NULL,NULL,'',NULL,'170.00','','','','',NULL,'170.00'),(114,'parle rusk real elaichi 200g','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240813-000015','03:12:15 pm','2024 08 13','admin','1','  General','  Cash','494.90','707.00','30',NULL,NULL,NULL,NULL,'13 Aug 2024','2024081315:12:15','%','0','25.00','no','0.00',NULL,'202408131512','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'bread bakery and eggs','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(115,'ragi bread 200g','1.0','19.00','19.00','Item',NULL,NULL,'no',NULL,NULL,'20240813-000015','03:12:15 pm','2024 08 13','admin','1','  General','  Cash','494.90','707.00','31',NULL,NULL,NULL,NULL,'13 Aug 2024','2024081315:12:15','%','0','19.00','no','0.00',NULL,'202408131512','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'bread bakery and eggs','admin','madmin',NULL,NULL,'',NULL,'19.00','','','','',NULL,'19.00'),(116,'carrots kg','1','70.00','70.00','Item','null','null','no','','','20240814-000011','2:03:35 PM','2024 08 14','madmin','1','  General','  cash','0','0','7','null','null','null','null','14Aug24','2024081402:003:35','%','0','','','','test','2024081402:003:35','','','','','','','','','','HERBALIFE','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(117,'Test scan item','3','50.00','150','Item','null','null','no','null','Tenpercent(10%)','20240814-000012','2:42:53 PM','2024 08 14','madmin','1','  General','  cash','0','0','1602','null','null','null','null','14Aug24','2024081402:42:53','%','0','','','','test','2024081402:42:53','','null','null','null','null','null','null','null','null','household','madmin','madmin','null','','338706237247','test','test','test','test','test','test',NULL,NULL),(118,'sona masoori raw rice 10kg','1','520.00','520.00','Item','null','null','no','null','None','20240814-000012','2:42:53 PM','2024 08 14','madmin','1','  General','  cash','0','0','924','null','null','null','null','14Aug24','2024081402:42:53','%','0','','','','test','2024081402:42:53','','null','null','null','null','null','null','null','null','rice and whole grains','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(119,'Test scan item','3','50.00','150.00','Item','null','null','no','null','Tenpercent(10%)','20240814-000013','2:46:43 PM','2024 08 14','madmin','1','  General','  cash','0','0','1602','null','null','null','null','14Aug24','2024081402:46:43','%','0','','','','test','2024081402:46:43','','null','null','null','null','null','null','null','null','household','madmin','madmin','null','','338706237247','test','test','test','test','test','test',NULL,NULL),(120,'sona masoori raw rice 1kg','9','56.00','504.00','Item','null','null','no','','','20240814-000014','3:25:17 PM','2024 08 14','madmin','1','  General','  cash','0','0','1','null','null','null','null','14Aug24','2024081403:25:17','%','0','','','','test','2024081403:25:17','','','','','','','','','','TEST CATEGORY','madmin','madmin','null','','338706237247','test','test','test','test','test','test',NULL,NULL),(121,'tata urad dal whole white 1kg','12','250.00','3000','Item','null','null','no','','','20240814-000015','3:29:05 PM','2024 08 14','madmin','1','  General','  cash','0','0','2','null','null','null','null','14Aug24','2024081403:29:005','%','0','','','','test','2024081403:29:005','','','','','','','','','','dals pulses','madmin','madmin','null','','338706237247','test','test','test','test','test','test',NULL,NULL),(122,'carrots kg','3','70.00','210.00','Item','null','null','no','','','20240814-000015','3:29:05 PM','2024 08 14','madmin','1','  General','  cash','0','0','7','null','null','null','null','14Aug24','2024081403:29:005','%','0','','','','test','2024081403:29:005','','','','','','','','','','HERBALIFE','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(123,'tata urad dal whole white 1kg','4','250.00','1000.00','Item','null','null','no','','','20240816-000011','11:00:21 AM','2024 08 16','madmin','1','  General','  cash','0','0','2','null','null','null','null','16Aug24','2024081611:000:21','%','0','','','','test','2024081611:000:21','','','','','','','','','','dals pulses','madmin','madmin','null','','338706237247','test','test','test','test','test','test',NULL,NULL),(124,'sona masoori raw rice 1kg','1','56.00','56.00','Item','null','null','no','null','None','20240816-000012','12:32:33 PM','2024 08 16','madmin','1','  General','  Pay Later','0','0','1','null','null','null','null','16Aug24','2024081612:32:33','%','0','','','','test','2024081612:32:33','','null','null','null','null','null','null','null','null','rice whole grains','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(125,'tata urad dal whole white 1kg','1','250.00','250.00','Item','null','null','no','null','None','20240816-000012','12:32:33 PM','2024 08 16','madmin','1','  General','  Pay Later','0','0','2','null','null','null','null','16Aug24','2024081612:32:33','%','0','','','','test','2024081612:32:33','','null','null','null','null','null','null','null','null','dals pulses','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(126,'nutella','1','170.00','170.00','Item','null','null','no','null','None','20240816-000012','12:32:33 PM','2024 08 16','madmin','1','  General','  Pay Later','0','0','3','null','null','null','null','16Aug24','2024081612:32:33','%','0','','','','test','2024081612:32:33','','null','null','null','null','null','null','null','null','branded foods','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(127,'fig fruit kg','1','250.00','250.00','Item','null','null','no','null','None','20240816-000012','12:32:33 PM','2024 08 16','madmin','1','  General','  Pay Later','0','0','4','null','null','null','null','16Aug24','2024081612:32:33','%','0','','','','test','2024081612:32:33','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(128,'tata urad dal whole white 1kg','1','250.00','250.00','Item','null','null','no','','','20240816-000013','2:50:20 PM','2024 08 16','madmin','1','  General','  Pay Later','0','0','2','null','null','null','null','16Aug24','2024081602:50:20','%','0','','','','test','2024081602:50:20','','','','','','','','','','dals pulses','madmin','madmin','null','','11675112499445','test','test','test','test','test','test',NULL,NULL),(129,'sona masoori raw rice 1kg','7','56.00','392.00','Item','null','null','no','','','20240816-000013','2:50:20 PM','2024 08 16','madmin','1','  General','  Pay Later','0','0','1','null','null','null','null','16Aug24','2024081602:50:20','%','0','','','','test','2024081602:50:20','','','','','','','','','','rice whole grains','madmin','madmin','null','','338706237247','test','test','test','test','test','test',NULL,NULL),(130,'sona masoori raw rice 1kg','1','56.00','56.00','Item','null','null','no','','','20240816-000014','2:56:20 PM','2024 08 16','madmin','1','  General','  Pay Later','0','0','1','null','null','null','null','16Aug24','2024081602:56:20','%','0','','','','test','2024081602:56:20','','','','','','','','','','rice whole grains','madmin','madmin','null','','338706237247','test','test','test','test','test','test',NULL,NULL),(131,'nutella','1','170.00','170.00','Item','null','null','no','null','None','20240816-000015','2:57:02 PM','2024 08 16','madmin','1','  General','  Pay Later','0','0','3','null','null','null','null','16Aug24','2024081602:57:002','%','0','','','','test','2024081602:57:002','','null','null','null','null','null','null','null','null','branded foods','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(132,'tata urad dal whole white 1kg','1','250.00','250.00','Item','null','null','no','','','20240816-000015','2:57:02 PM','2024 08 16','madmin','1','  General','  Pay Later','0','0','2','null','null','null','null','16Aug24','2024081602:57:002','%','0','','','','test','2024081602:57:002','','','','','','','','','','dals pulses','madmin','madmin','null','','11675112499445','test','test','test','test','test','test',NULL,NULL),(133,'fig fruit kg','1','250.00','250.00','Item','null','null','no','null','None','20240816-000015','2:57:02 PM','2024 08 16','madmin','1','  General','  Pay Later','0','0','4','null','null','null','null','16Aug24','2024081602:57:002','%','0','','','','test','2024081602:57:002','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(134,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240816-000016','03:01:37 pm','2024 08 16','admin','1','  General','  Pay Later','726.00','726.00','1',NULL,NULL,NULL,NULL,'16 Aug 2024','2024081615:01:37','%','0','56.00','no','0.00',NULL,'202408161501','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin','700',NULL,'338706237247',NULL,'56.00','','','','',NULL,'56.00'),(135,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240816-000016','03:01:37 pm','2024 08 16','admin','1','  General','  Pay Later','726.00','726.00','2',NULL,NULL,NULL,NULL,'16 Aug 2024','2024081615:01:37','%','0','250.00','no','0.00',NULL,'202408161501','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin','700',NULL,'11675112499445',NULL,'250.00','','','','',NULL,'250.00'),(136,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20240816-000016','03:01:37 pm','2024 08 16','admin','1','  General','  Pay Later','726.00','726.00','3',NULL,NULL,NULL,NULL,'16 Aug 2024','2024081615:01:37','%','0','170.00','no','0.00',NULL,'202408161501','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin','700',NULL,'',NULL,'170.00','','','','',NULL,'170.00'),(137,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240816-000016','03:01:37 pm','2024 08 16','admin','1','  General','  Pay Later','726.00','726.00','4',NULL,NULL,NULL,NULL,'16 Aug 2024','2024081615:01:37','%','0','250.00','no','0.00',NULL,'202408161501','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin','700',NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(138,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240816-000017','03:02:03 pm','2024 08 16','admin','1','  General','  Pay Later','726.00','726.00','1',NULL,NULL,NULL,NULL,'16 Aug 2024','2024081615:02:03','%','0','56.00','no','0.00',NULL,'202408161502','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin','700',NULL,'338706237247',NULL,'56.00','','','','',NULL,'56.00'),(139,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240816-000017','03:02:03 pm','2024 08 16','admin','1','  General','  Pay Later','726.00','726.00','2',NULL,NULL,NULL,NULL,'16 Aug 2024','2024081615:02:03','%','0','250.00','no','0.00',NULL,'202408161502','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin','700',NULL,'11675112499445',NULL,'250.00','','','','',NULL,'250.00'),(140,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20240816-000017','03:02:03 pm','2024 08 16','admin','1','  General','  Pay Later','726.00','726.00','3',NULL,NULL,NULL,NULL,'16 Aug 2024','2024081615:02:03','%','0','170.00','no','0.00',NULL,'202408161502','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin','700',NULL,'',NULL,'170.00','','','','',NULL,'170.00'),(141,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240816-000017','03:02:03 pm','2024 08 16','admin','1','  General','  Pay Later','726.00','726.00','4',NULL,NULL,NULL,NULL,'16 Aug 2024','2024081615:02:03','%','0','250.00','no','0.00',NULL,'202408161502','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin','700',NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(142,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240816-000017','03:03:22 pm','2024 08 16','admin','1','  General','  Pay Later','726.00','726.00','1',NULL,NULL,NULL,NULL,'16 Aug 2024','2024081615:03:22','%','0','56.00','no','0.00',NULL,'202408161503','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin','700',NULL,'338706237247',NULL,'56.00','','','','',NULL,'56.00'),(143,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240816-000017','03:03:22 pm','2024 08 16','admin','1','  General','  Pay Later','726.00','726.00','2',NULL,NULL,NULL,NULL,'16 Aug 2024','2024081615:03:22','%','0','250.00','no','0.00',NULL,'202408161503','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin','700',NULL,'11675112499445',NULL,'250.00','','','','',NULL,'250.00'),(144,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20240816-000017','03:03:22 pm','2024 08 16','admin','1','  General','  Pay Later','726.00','726.00','3',NULL,NULL,NULL,NULL,'16 Aug 2024','2024081615:03:22','%','0','170.00','no','0.00',NULL,'202408161503','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin','700',NULL,'',NULL,'170.00','','','','',NULL,'170.00'),(145,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240816-000017','03:03:22 pm','2024 08 16','admin','1','  General','  Pay Later','726.00','726.00','4',NULL,NULL,NULL,NULL,'16 Aug 2024','2024081615:03:22','%','0','250.00','no','0.00',NULL,'202408161503','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin','700',NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(146,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240816-000017','03:03:33 pm','2024 08 16','admin','1','  General','  Cash','726.00','726.00','1',NULL,NULL,NULL,NULL,'16 Aug 2024','2024081615:03:33','%','0','56.00','no','0.00',NULL,'202408161503','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'338706237247',NULL,'56.00','','','','',NULL,'56.00'),(147,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240816-000017','03:03:33 pm','2024 08 16','admin','1','  General','  Cash','726.00','726.00','2',NULL,NULL,NULL,NULL,'16 Aug 2024','2024081615:03:33','%','0','250.00','no','0.00',NULL,'202408161503','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin',NULL,NULL,'11675112499445',NULL,'250.00','','','','',NULL,'250.00'),(148,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20240816-000017','03:03:33 pm','2024 08 16','admin','1','  General','  Cash','726.00','726.00','3',NULL,NULL,NULL,NULL,'16 Aug 2024','2024081615:03:33','%','0','170.00','no','0.00',NULL,'202408161503','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin',NULL,NULL,'',NULL,'170.00','','','','',NULL,'170.00'),(149,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240816-000017','03:03:33 pm','2024 08 16','admin','1','  General','  Cash','726.00','726.00','4',NULL,NULL,NULL,NULL,'16 Aug 2024','2024081615:03:33','%','0','250.00','no','0.00',NULL,'202408161503','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(150,'ladies finger kg','1.0','28.00','28.00','Item',NULL,NULL,'no',NULL,NULL,'20240816-000018','03:04:18 pm','2024 08 16','admin','1','  General','  Pay Later','403.00','403.00','5',NULL,NULL,NULL,NULL,'16 Aug 2024','2024081615:04:18','%','0','28.00','no','0.00',NULL,'202408161504','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin','400',NULL,'',NULL,'28.00','','','','',NULL,'28.00'),(151,'capsicum green kg','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240816-000018','03:04:18 pm','2024 08 16','admin','1','  General','  Pay Later','403.00','403.00','6',NULL,NULL,NULL,NULL,'16 Aug 2024','2024081615:04:18','%','0','80.00','no','0.00',NULL,'202408161504','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin','400',NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(152,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240816-000018','03:04:18 pm','2024 08 16','admin','1','  General','  Pay Later','403.00','403.00','7',NULL,NULL,NULL,NULL,'16 Aug 2024','2024081615:04:18','%','0','250.00','no','0.00',NULL,'202408161504','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin','400',NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(153,'cauliflower kg','1.0','45.00','45.00','Item',NULL,NULL,'no',NULL,NULL,'20240816-000018','03:04:18 pm','2024 08 16','admin','1','  General','  Pay Later','403.00','403.00','8',NULL,NULL,NULL,NULL,'16 Aug 2024','2024081615:04:18','%','0','45.00','no','0.00',NULL,'202408161504','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin','400',NULL,'',NULL,'45.00','','','','',NULL,'45.00'),(154,'ladies finger kg','1.0','28.00','28.00','Item',NULL,NULL,'no',NULL,NULL,'20240816-000018','03:05:41 pm','2024 08 16','admin','1','  General','  Cheque','403.00','403.00','5',NULL,NULL,NULL,NULL,'16 Aug 2024','2024081615:05:41','%','0','28.00','no','0.00',NULL,'202408161505','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin','0',NULL,'',NULL,'28.00','','','','',NULL,'28.00'),(155,'capsicum green kg','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240816-000018','03:05:41 pm','2024 08 16','admin','1','  General','  Cheque','403.00','403.00','6',NULL,NULL,NULL,NULL,'16 Aug 2024','2024081615:05:41','%','0','80.00','no','0.00',NULL,'202408161505','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin','0',NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(156,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240816-000018','03:05:41 pm','2024 08 16','admin','1','  General','  Cheque','403.00','403.00','7',NULL,NULL,NULL,NULL,'16 Aug 2024','2024081615:05:41','%','0','250.00','no','0.00',NULL,'202408161505','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin','0',NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(157,'cauliflower kg','1.0','45.00','45.00','Item',NULL,NULL,'no',NULL,NULL,'20240816-000018','03:05:41 pm','2024 08 16','admin','1','  General','  Cheque','403.00','403.00','8',NULL,NULL,NULL,NULL,'16 Aug 2024','2024081615:05:41','%','0','45.00','no','0.00',NULL,'202408161505','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin','0',NULL,'',NULL,'45.00','','','','',NULL,'45.00'),(158,'sona masoori raw rice 1kg','1','56.00','56.00','Item','null','null','no','','','20240820-000011','12:41:40 PM','2024 08 20','madmin','1','  General','  Pay Later','0','0','1','null','null','null','null','20Aug24','2024082012:41:40','%','0','','','','test','2024082012:41:40','','','','','','','','','','rice whole grains','madmin','madmin','null','','338706237247','test','test','test','test','test','test',NULL,NULL),(159,'tata urad dal whole white 1kg','1','250.00','250.00','Item','null','null','no','','','20240820-000011','12:41:40 PM','2024 08 20','madmin','1','  General','  Pay Later','0','0','2','null','null','null','null','20Aug24','2024082012:41:40','%','0','','','','test','2024082012:41:40','','','','','','','','','','dals pulses','madmin','madmin','null','','11675112499445','test','test','test','test','test','test',NULL,NULL),(160,'dhara refined sunflower oil 1l','1','83.00','83.00','Item','null','null','no','null','None','20240820-000011','12:41:40 PM','2024 08 20','madmin','1','  General','  Pay Later','0','0','829','null','null','null','null','20Aug24','2024082012:41:40','%','0','','','','test','2024082012:41:40','','null','null','null','null','null','null','null','null','edible oils and ghee','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(161,'dhara refined sunflower oil 5l','1','420.00','420.00','Item','null','null','no','null','None','20240820-000011','12:41:40 PM','2024 08 20','madmin','1','  General','  Pay Later','0','0','956','null','null','null','null','20Aug24','2024082012:41:40','%','0','','','','test','2024082012:41:40','','null','null','null','null','null','null','null','null','edible oils and ghee','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(162,'sundrop refined sunflower oil 1l','1','135.00','135.00','Item','null','null','no','null','None','20240820-000011','12:41:40 PM','2024 08 20','madmin','1','  General','  Pay Later','0','0','957','null','null','null','null','20Aug24','2024082012:41:40','%','0','','','','test','2024082012:41:40','','null','null','null','null','null','null','null','null','edible oils and ghee','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(163,'nutella','1','170.00','170.00','Item','null','null','no','null','None','20240820-000012','12:44:12 PM','2024 08 20','madmin','1','  General','  Pay Later','0','0','3','null','null','null','null','20Aug24','2024082012:44:12','%','0','','','','test','2024082012:44:12','','null','null','null','null','null','null','null','null','branded foods','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(164,'fig fruit kg','1','250.00','250.00','Item','null','null','no','null','None','20240820-000012','12:44:12 PM','2024 08 20','madmin','1','  General','  Pay Later','0','0','4','null','null','null','null','20Aug24','2024082012:44:12','%','0','','','','test','2024082012:44:12','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(165,'cauliflower kg','1','45.00','45.00','Item','null','null','no','null','None','20240820-000012','12:44:12 PM','2024 08 20','madmin','1','  General','  Pay Later','0','0','8','null','null','null','null','20Aug24','2024082012:44:12','%','0','','','','test','2024082012:44:12','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(166,'carrots kg','1','70.00','70.00','Item','null','null','no','null','None','20240820-000012','12:44:12 PM','2024 08 20','madmin','1','  General','  Pay Later','0','0','7','null','null','null','null','20Aug24','2024082012:44:12','%','0','','','','test','2024082012:44:12','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(167,'capsicum green kg','1','80.00','80.00','Item','null','null','no','null','None','20240820-000012','12:44:12 PM','2024 08 20','madmin','1','  General','  Pay Later','0','0','6','null','null','null','null','20Aug24','2024082012:44:12','%','0','','','','test','2024082012:44:12','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(168,'ladies finger kg','1','28.00','28.00','Item','null','null','no','null','None','20240820-000012','12:44:12 PM','2024 08 20','madmin','1','  General','  Pay Later','0','0','5','null','null','null','null','20Aug24','2024082012:44:12','%','0','','','','test','2024082012:44:12','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(169,'sona masoori raw rice 1kg','1','56.00','56.00','Item','null','null','no','','','20240820-000013','12:45:15 PM','2024 08 20','madmin','1','  General','  cash','0','0','1','null','null','null','null','20Aug24','2024082012:45:15','%','0','','','','test','2024082012:45:15','','','','','','','','','','rice whole grains','madmin','madmin','null','','338706237247','test','test','test','test','test','test',NULL,NULL),(170,'tata urad dal whole white 1kg','1','250.00','250.00','Item','null','null','no','','','20240820-000013','12:45:15 PM','2024 08 20','madmin','1','  General','  cash','0','0','2','null','null','null','null','20Aug24','2024082012:45:15','%','0','','','','test','2024082012:45:15','','','','','','','','','','dals pulses','madmin','madmin','null','','11675112499445','test','test','test','test','test','test',NULL,NULL),(171,'nutella','1','170.00','170.00','Item','null','null','no','null','None','20240820-000013','12:45:15 PM','2024 08 20','madmin','1','  General','  cash','0','0','3','null','null','null','null','20Aug24','2024082012:45:15','%','0','','','','test','2024082012:45:15','','null','null','null','null','null','null','null','null','branded foods','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(172,'capsicum green kg','1','80.00','80.00','Item','null','null','no','null','None','20240820-000013','12:45:15 PM','2024 08 20','madmin','1','  General','  cash','0','0','6','null','null','null','null','20Aug24','2024082012:45:15','%','0','','','','test','2024082012:45:15','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(173,'capsicum green kg','2','80.00','160.00','Item','null','null','no','null','None','20240820-000014','12:45:57 PM','2024 08 20','madmin','1','  General','  Pay Later','0','0','6','null','null','null','null','20Aug24','2024082012:45:57','%','0','','','','test','2024082012:45:57','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(174,'carrots kg','1','70.00','70.00','Item','null','null','no','null','None','20240820-000014','12:45:57 PM','2024 08 20','madmin','1','  General','  Pay Later','0','0','7','null','null','null','null','20Aug24','2024082012:45:57','%','0','','','','test','2024082012:45:57','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(175,'ladies finger kg','1','28.00','28.00','Item','null','null','no','null','None','20240820-000014','12:45:57 PM','2024 08 20','madmin','1','  General','  Pay Later','0','0','5','null','null','null','null','20Aug24','2024082012:45:57','%','0','','','','test','2024082012:45:57','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(176,'tata urad dal whole white 1kg','1','250.00','250.00','Item','null','null','no','','','20240821-000011','10:28:15 AM','2024 08 21','madmin','1','  General','  Pay Later','0','0','2','null','null','null','null','21Aug24','2024082110:28:15','%','0','','','','test','2024082110:28:15','','','','','','','','','','dals pulses','madmin','madmin','null','','11675112499445','test','test','test','test','test','test',NULL,NULL),(177,'nutella','1','170.00','170.00','Item','null','null','no','null','None','20240821-000011','10:28:15 AM','2024 08 21','madmin','1','  General','  Pay Later','0','0','3','null','null','null','null','21Aug24','2024082110:28:15','%','0','','','','test','2024082110:28:15','','null','null','null','null','null','null','null','null','branded foods','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(178,'tortillas','1','70.00','70.00','Item','null','null','no','null','None','20240821-000011','10:28:15 AM','2024 08 21','madmin','1','  General','  Pay Later','0','0','311','null','null','null','null','21Aug24','2024082110:28:15','%','0','','','','test','2024082110:28:15','','null','null','null','null','null','null','null','null','None','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(179,'fish sticks','1','40.00','40.00','Item','null','null','no','null','None','20240821-000011','10:28:15 AM','2024 08 21','madmin','1','  General','  Pay Later','0','0','314','null','null','null','null','21Aug24','2024082110:28:15','%','0','','','','test','2024082110:28:15','','null','null','null','null','null','null','null','null','None','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(180,'sona masoori raw rice 1kg','1','56.00','56.00','Item','null','null','no','','','20240821-000013','5:19:13 PM','2024 08 21','madmin','1','  General','  cash','0','0','1','null','null','null','null','21Aug24','2024082105:19:13','%','0','','','','test','2024082105:19:13','','','','','','','','','','rice whole grains','madmin','madmin','null','','338706237247','test','test','test','test','test','test',NULL,NULL),(181,'tata urad dal whole white 1kg','1','250.00','250.00','Item','null','null','no','','','20240821-000013','5:19:13 PM','2024 08 21','madmin','1','  General','  cash','0','0','2','null','null','null','null','21Aug24','2024082105:19:13','%','0','','','','test','2024082105:19:13','','','','','','','','','','dals pulses','madmin','madmin','null','','11675112499445','test','test','test','test','test','test',NULL,NULL),(182,'Gold Facial','1','1000.00','1000.00','Item','null','null','no','null','None','20240821-000013','5:19:13 PM','2024 08 21','madmin','1','  General','  cash','0','0','1600','null','null','null','null','21Aug24','2024082105:19:13','%','0','','','','test','2024082105:19:13','','null','null','null','null','null','null','null','null','Facial','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(183,'nutella','1','170.00','170.00','Item','null','null','no','null','None','20240821-000013','5:19:13 PM','2024 08 21','madmin','1','  General','  cash','0','0','3','null','null','null','null','21Aug24','2024082105:19:13','%','0','','','','test','2024082105:19:13','','FIVE(5.00%)','5.00','null','null','null','null','null','null','branded foods','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(184,'Milk 250ml','1','20.00','20.00','Item','null','null','no','','','20240903-000011','1:01:16 PM','2024 09 03','madmin','1','  General','  cash','0','0','1','null','null','null','null','03Sep24','2024090301:001:16','%','0','','','','test','2024090301:001:16','','','','','','','','','','Dairy products','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(185,'Milk 500ml','1','40.00','40.00','Item','null','null','no','','','20240903-000011','1:01:16 PM','2024 09 03','madmin','1','  General','  cash','0','0','2','null','null','null','null','03Sep24','2024090301:001:16','%','0','','','','test','2024090301:001:16','','','','','','','','','','Dairy products','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(186,'Milk 1000ml','1','80.00','80.00','Item','null','null','no','','','20240903-000011','1:01:16 PM','2024 09 03','madmin','1','  General','  cash','0','0','3','null','null','null','null','03Sep24','2024090301:001:16','%','0','','','','test','2024090301:001:16','','','','','','','','','','Dairy products','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(187,'Milk 250ml','1','20.00','20.00','Item','null','null','no','','','20240903-000012','1:07:59 PM','2024 09 03','madmin','1','  General','  Pay Later','0','0','1','null','null','null','null','03Sep24','2024090301:007:59','%','0','','','','test','2024090301:007:59','','','','','','','','','','Dairy products','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(188,'Milk 500ml','1','40.00','40.00','Item','null','null','no','','','20240903-000012','1:07:59 PM','2024 09 03','madmin','1','  General','  Pay Later','0','0','2','null','null','null','null','03Sep24','2024090301:007:59','%','0','','','','test','2024090301:007:59','','','','','','','','','','Dairy products','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(189,'Milk 1000ml','1','80.00','80.00','Item','null','null','no','','','20240903-000012','1:07:59 PM','2024 09 03','madmin','1','  General','  Pay Later','0','0','3','null','null','null','null','03Sep24','2024090301:007:59','%','0','','','','test','2024090301:007:59','','','','','','','','','','Dairy products','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(190,'Curd 500gms','1','45.00','45.00','Item','null','null','no','','','20240903-000012','1:07:59 PM','2024 09 03','madmin','1','  General','  Pay Later','0','0','7','null','null','null','null','03Sep24','2024090301:007:59','%','0','','','','test','2024090301:007:59','','','','','','','','','','Dairy products','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(191,'Milk 500ml','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20241023-000011','02:27:07 pm','2024 10 23','admin','1','  General','  Pay Later','178.00','178.00','6',NULL,NULL,NULL,NULL,'23 Oct 2024','2024102314:27:07','%','0','40.00','no','0.00',NULL,'202410231427','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin','78',NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(192,'Milk 1000ml','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20241023-000011','02:27:07 pm','2024 10 23','admin','1','  General','  Pay Later','178.00','178.00','7',NULL,NULL,NULL,NULL,'23 Oct 2024','2024102314:27:07','%','0','80.00','no','0.00',NULL,'202410231427','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin','78',NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(193,'Curd 250gms','1.0','23.00','23.00','Item',NULL,NULL,'no',NULL,NULL,'20241023-000011','02:27:07 pm','2024 10 23','admin','1','  General','  Pay Later','178.00','178.00','8',NULL,NULL,NULL,NULL,'23 Oct 2024','2024102314:27:07','%','0','23.00','no','0.00',NULL,'202410231427','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin','78',NULL,'',NULL,'23.00','','','','',NULL,'23.00'),(194,'Cow milk 500 ml','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241023-000011','02:27:07 pm','2024 10 23','admin','1','  General','  Pay Later','178.00','178.00','9',NULL,NULL,NULL,NULL,'23 Oct 2024','2024102314:27:07','%','0','35.00','no','0.00',NULL,'202410231427','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin','78',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(195,'Nuts milk bar 250gm','0.25','200.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20241023-000012','03:09:56 pm','2024 10 23','admin','1','  General','  Cash','190.00','190.00','13',NULL,NULL,NULL,NULL,'23 Oct 2024','2024102315:09:56','%','0','50.00','no','0.00',NULL,'202410231509','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chocolate','admin','madmin',NULL,NULL,'',NULL,'50.00','','','','',NULL,'200.00'),(196,'Milk 250ml','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241023-000012','03:09:56 pm','2024 10 23','admin','1','  General','  Cash','190.00','190.00','14',NULL,NULL,NULL,NULL,'23 Oct 2024','2024102315:09:56','%','0','20.00','no','0.00',NULL,'202410231509','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(197,'Milk 500ml','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20241023-000012','03:09:56 pm','2024 10 23','admin','1','  General','  Cash','190.00','190.00','15',NULL,NULL,NULL,NULL,'23 Oct 2024','2024102315:09:56','%','0','40.00','no','0.00',NULL,'202410231509','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(198,'Milk 1000ml','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20241023-000012','03:09:56 pm','2024 10 23','admin','1','  General','  Cash','190.00','190.00','16',NULL,NULL,NULL,NULL,'23 Oct 2024','2024102315:09:56','%','0','80.00','no','0.00',NULL,'202410231509','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(199,'Milk 500ml','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20241023-000013','04:09:09 PM','2024 10 23','admin','1','  General','  Cash','178.00','178.00','17',NULL,NULL,NULL,NULL,'23 Oct 2024','2024102316:09:09','%','0','40.00','no','0.00',NULL,'202410231609','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(200,'Milk 1000ml','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20241023-000013','04:09:09 PM','2024 10 23','admin','1','  General','  Cash','178.00','178.00','18',NULL,NULL,NULL,NULL,'23 Oct 2024','2024102316:09:09','%','0','80.00','no','0.00',NULL,'202410231609','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(201,'Curd 250gms','1.0','23.00','23.00','Item',NULL,NULL,'no',NULL,NULL,'20241023-000013','04:09:09 PM','2024 10 23','admin','1','  General','  Cash','178.00','178.00','19',NULL,NULL,NULL,NULL,'23 Oct 2024','2024102316:09:09','%','0','23.00','no','0.00',NULL,'202410231609','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin',NULL,NULL,'',NULL,'23.00','','','','',NULL,'23.00'),(202,'Cow milk 500 ml','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241023-000013','04:09:09 PM','2024 10 23','admin','1','  General','  Cash','178.00','178.00','20',NULL,NULL,NULL,NULL,'23 Oct 2024','2024102316:09:09','%','0','35.00','no','0.00',NULL,'202410231609','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(203,'Curd 500gms','2.0','45.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20241023-000014','04:22:36 pm','2024 10 23','admin','1','  General','  Cash','400.00','400.00','21',NULL,NULL,NULL,NULL,'23 Oct 2024','2024102316:22:36','%','0','90.00','no','0.00',NULL,'202410231622','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin',NULL,NULL,'',NULL,'90.00','','','','',NULL,'45.00'),(204,'Curd 1000kg','2.0','90.00','180.00','Item',NULL,NULL,'no',NULL,NULL,'20241023-000014','04:22:36 pm','2024 10 23','admin','1','  General','  Cash','400.00','400.00','22',NULL,NULL,NULL,NULL,'23 Oct 2024','2024102316:22:36','%','0','180.00','no','0.00',NULL,'202410231622','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin',NULL,NULL,'',NULL,'180.00','','','','',NULL,'90.00'),(205,'Paneer 125gms','2.0','65.00','130.00','Item',NULL,NULL,'no',NULL,NULL,'20241023-000014','04:22:36 pm','2024 10 23','admin','1','  General','  Cash','400.00','400.00','23',NULL,NULL,NULL,NULL,'23 Oct 2024','2024102316:22:36','%','0','130.00','no','0.00',NULL,'202410231622','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin',NULL,NULL,'',NULL,'130.00','','','','',NULL,'65.00'),(206,'Milk 250ml','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241024-000011','06:00:40 pm','2024 10 24','admin','1','  General','  Cash','198.00','198.00','24',NULL,NULL,NULL,NULL,'24 Oct 2024','2024102418:00:40','%','0','20.00','no','0.00',NULL,'202410241800','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(207,'Milk 500ml','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20241024-000011','06:00:40 pm','2024 10 24','admin','1','  General','  Cash','198.00','198.00','25',NULL,NULL,NULL,NULL,'24 Oct 2024','2024102418:00:40','%','0','40.00','no','0.00',NULL,'202410241800','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(208,'Milk 1000ml','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20241024-000011','06:00:40 pm','2024 10 24','admin','1','  General','  Cash','198.00','198.00','26',NULL,NULL,NULL,NULL,'24 Oct 2024','2024102418:00:40','%','0','80.00','no','0.00',NULL,'202410241800','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(209,'Cow milk 500 ml','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241024-000011','06:00:40 pm','2024 10 24','admin','1','  General','  Cash','198.00','198.00','27',NULL,NULL,NULL,NULL,'24 Oct 2024','2024102418:00:40','%','0','35.00','no','0.00',NULL,'202410241800','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(210,'Curd 250gms','1.0','23.00','23.00','Item',NULL,NULL,'no',NULL,NULL,'20241024-000011','06:00:40 pm','2024 10 24','admin','1','  General','  Cash','198.00','198.00','28',NULL,NULL,NULL,NULL,'24 Oct 2024','2024102418:00:40','%','0','23.00','no','0.00',NULL,'202410241800','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin',NULL,NULL,'',NULL,'23.00','','','','',NULL,'23.00'),(211,'Cow Milk 250ml','1.0','18.00','18.00','Item',NULL,NULL,'no',NULL,NULL,'20241026-000011','03:22:33 pm','2024 10 26','admin','1','  General','  Cash','196.00','196.00','12',NULL,NULL,NULL,NULL,'26 Oct 2024','2024102615:22:33','%','0','18.00','no','0.00',NULL,'202410261522','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin',NULL,NULL,'',NULL,'18.00','','','','',NULL,'18.00'),(212,'Cow milk 500 ml','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241026-000011','03:22:33 pm','2024 10 26','admin','1','  General','  Cash','196.00','196.00','13',NULL,NULL,NULL,NULL,'26 Oct 2024','2024102615:22:33','%','0','35.00','no','0.00',NULL,'202410261522','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(213,'Curd 250gms','1.0','23.00','23.00','Item',NULL,NULL,'no',NULL,NULL,'20241026-000011','03:22:33 pm','2024 10 26','admin','1','  General','  Cash','196.00','196.00','14',NULL,NULL,NULL,NULL,'26 Oct 2024','2024102615:22:33','%','0','23.00','no','0.00',NULL,'202410261522','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin',NULL,NULL,'',NULL,'23.00','','','','',NULL,'23.00'),(214,'Milk 1000ml','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20241026-000011','03:22:33 pm','2024 10 26','admin','1','  General','  Cash','196.00','196.00','15',NULL,NULL,NULL,NULL,'26 Oct 2024','2024102615:22:33','%','0','80.00','no','0.00',NULL,'202410261522','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(215,'Milk 500ml','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20241026-000011','03:22:33 pm','2024 10 26','admin','1','  General','  Cash','196.00','196.00','16',NULL,NULL,NULL,NULL,'26 Oct 2024','2024102615:22:33','%','0','40.00','no','0.00',NULL,'202410261522','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(216,'Cow Milk 250ml','1.0','18.00','18.00','Item',NULL,NULL,'no',NULL,NULL,'20241026-000012','03:22:46 pm','2024 10 26','admin','1','  General','  Cash','196.00','196.00','12',NULL,NULL,NULL,NULL,'26 Oct 2024','2024102615:22:46','%','0','18.00','no','0.00',NULL,'202410261522','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin',NULL,NULL,'',NULL,'18.00','','','','',NULL,'18.00'),(217,'Cow milk 500 ml','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241026-000012','03:22:46 pm','2024 10 26','admin','1','  General','  Cash','196.00','196.00','13',NULL,NULL,NULL,NULL,'26 Oct 2024','2024102615:22:46','%','0','35.00','no','0.00',NULL,'202410261522','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(218,'Curd 250gms','1.0','23.00','23.00','Item',NULL,NULL,'no',NULL,NULL,'20241026-000012','03:22:46 pm','2024 10 26','admin','1','  General','  Cash','196.00','196.00','14',NULL,NULL,NULL,NULL,'26 Oct 2024','2024102615:22:46','%','0','23.00','no','0.00',NULL,'202410261522','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin',NULL,NULL,'',NULL,'23.00','','','','',NULL,'23.00'),(219,'Milk 1000ml','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20241026-000012','03:22:46 pm','2024 10 26','admin','1','  General','  Cash','196.00','196.00','15',NULL,NULL,NULL,NULL,'26 Oct 2024','2024102615:22:46','%','0','80.00','no','0.00',NULL,'202410261522','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(220,'Milk 500ml','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20241026-000012','03:22:46 pm','2024 10 26','admin','1','  General','  Cash','196.00','196.00','16',NULL,NULL,NULL,NULL,'26 Oct 2024','2024102615:22:46','%','0','40.00','no','0.00',NULL,'202410261522','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(221,'Milk 250ml','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241026-000012','03:25:18 pm','2024 10 26','admin','1','  General','  Pay Later','216.00','216.00','18',NULL,NULL,NULL,NULL,'26 Oct 2024','2024102615:25:18','%','0','20.00','no','0.00',NULL,'202410261525','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin','100',NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(222,'Milk 500ml','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20241026-000012','03:25:18 pm','2024 10 26','admin','1','  General','  Pay Later','216.00','216.00','19',NULL,NULL,NULL,NULL,'26 Oct 2024','2024102615:25:18','%','0','40.00','no','0.00',NULL,'202410261525','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin','100',NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(223,'Milk 1000ml','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20241026-000012','03:25:18 pm','2024 10 26','admin','1','  General','  Pay Later','216.00','216.00','20',NULL,NULL,NULL,NULL,'26 Oct 2024','2024102615:25:18','%','0','80.00','no','0.00',NULL,'202410261525','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin','100',NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(224,'Cow milk 500 ml','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241026-000012','03:25:18 pm','2024 10 26','admin','1','  General','  Pay Later','216.00','216.00','21',NULL,NULL,NULL,NULL,'26 Oct 2024','2024102615:25:18','%','0','35.00','no','0.00',NULL,'202410261525','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin','100',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(225,'Curd 250gms','1.0','23.00','23.00','Item',NULL,NULL,'no',NULL,NULL,'20241026-000012','03:25:18 pm','2024 10 26','admin','1','  General','  Pay Later','216.00','216.00','22',NULL,NULL,NULL,NULL,'26 Oct 2024','2024102615:25:18','%','0','23.00','no','0.00',NULL,'202410261525','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin','100',NULL,'',NULL,'23.00','','','','',NULL,'23.00'),(226,'Cow Milk 250ml','1.0','18.00','18.00','Item',NULL,NULL,'no',NULL,NULL,'20241026-000012','03:25:18 pm','2024 10 26','admin','1','  General','  Pay Later','216.00','216.00','23',NULL,NULL,NULL,NULL,'26 Oct 2024','2024102615:25:18','%','0','18.00','no','0.00',NULL,'202410261525','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin','100',NULL,'',NULL,'18.00','','','','',NULL,'18.00'),(227,'Milk 250ml','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241026-000013','03:25:31 pm','2024 10 26','admin','1','  General','  Cash','216.00','216.00','18',NULL,NULL,NULL,NULL,'26 Oct 2024','2024102615:25:31','%','0','20.00','no','0.00',NULL,'202410261525','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(228,'Milk 500ml','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20241026-000013','03:25:31 pm','2024 10 26','admin','1','  General','  Cash','216.00','216.00','19',NULL,NULL,NULL,NULL,'26 Oct 2024','2024102615:25:31','%','0','40.00','no','0.00',NULL,'202410261525','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(229,'Milk 1000ml','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20241026-000013','03:25:31 pm','2024 10 26','admin','1','  General','  Cash','216.00','216.00','20',NULL,NULL,NULL,NULL,'26 Oct 2024','2024102615:25:31','%','0','80.00','no','0.00',NULL,'202410261525','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(230,'Cow milk 500 ml','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241026-000013','03:25:31 pm','2024 10 26','admin','1','  General','  Cash','216.00','216.00','21',NULL,NULL,NULL,NULL,'26 Oct 2024','2024102615:25:31','%','0','35.00','no','0.00',NULL,'202410261525','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(231,'Curd 250gms','1.0','23.00','23.00','Item',NULL,NULL,'no',NULL,NULL,'20241026-000013','03:25:31 pm','2024 10 26','admin','1','  General','  Cash','216.00','216.00','22',NULL,NULL,NULL,NULL,'26 Oct 2024','2024102615:25:31','%','0','23.00','no','0.00',NULL,'202410261525','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin',NULL,NULL,'',NULL,'23.00','','','','',NULL,'23.00'),(232,'Cow Milk 250ml','1.0','18.00','18.00','Item',NULL,NULL,'no',NULL,NULL,'20241026-000013','03:25:31 pm','2024 10 26','admin','1','  General','  Cash','216.00','216.00','23',NULL,NULL,NULL,NULL,'26 Oct 2024','2024102615:25:31','%','0','18.00','no','0.00',NULL,'202410261525','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dairy products','admin','madmin',NULL,NULL,'',NULL,'18.00','','','','',NULL,'18.00');
INSERT INTO `billcount` (`_id`, `value`) VALUES (1,'0');
INSERT INTO `billnumber` (`_id`, `billnumber`, `total`, `user`, `date`, `paymentmethod`, `billtype`, `subtotal`, `taxtotal`, `roundoff`, `globaltaxtotal`, `billcount`, `datetimee_new`, `comments_sales`, `delivery_fee`, `packing_charges`, `loyalty_points`, `loyalty_amount`, `order_id`) VALUES (1,'20240614-000011','2400.00','admin','2024 06 14','  Cash','  General','2400.00','0.00','0.00','0.0','1','202406141216',NULL,NULL,NULL,NULL,NULL,NULL),(2,'20240614-000012','1180.00','admin','2024 06 14','  Cash','  General','1180.00','0.00','0.00','0.0','2','202406141246',NULL,NULL,NULL,NULL,NULL,NULL),(3,'20240614-000013','783.00','admin','2024 06 14','  Cash','  General','783.00','0.00','0.00','0.0','3','202406141247',NULL,NULL,NULL,NULL,NULL,NULL),(4,'20240621-000011','416.00','admin','2024 06 21','  Cash','  General','416.00','0.00','0.00','0.0','4','202406211634',NULL,NULL,NULL,NULL,NULL,NULL),(5,'20240715-000011','351.00','admin','2024 07 15','  Cash','  General','351.00','0.00','0.00','0.0','5','202407151507',NULL,NULL,NULL,NULL,NULL,NULL),(6,'20240716-000011','590.00','admin','2024 07 16','  Cash','  General','500.00','90.00','0.00','18.0','6','202407161217',NULL,NULL,NULL,NULL,NULL,NULL),(7,'20240716-000012','984.12','admin','2024 07 16','  Cash','  General','834.00','150.12','0.00','18.0','7','202407161217',NULL,NULL,NULL,NULL,NULL,NULL),(8,'20240716-000013','1902.16','admin','2024 07 16','  Cash','  General','1612.00','290.16','0.00','18.0','8','202407161229',NULL,NULL,NULL,NULL,NULL,NULL),(9,'20240716-000014','220.66','admin','2024 07 16','  Cash','  General','187.00','33.66','0.00','18.0','9','202407161554',NULL,NULL,NULL,NULL,NULL,NULL),(10,'20240716-000015','889.72','admin','2024 07 16','  Cash','  General','754.00','135.72','0.00','18.0','10','202407161555',NULL,NULL,NULL,NULL,NULL,NULL),(11,'20240716-000016','623.04','admin','2024 07 16','  Cash','  General','528.00','95.04','0.00','18.0','11','202407161558',NULL,NULL,NULL,NULL,NULL,NULL),(12,'20240717-000011','306.00','admin','2024 07 17','  Cash','  General','306.00','0.00','0.00','0.0','12','202407171525',NULL,NULL,NULL,NULL,NULL,NULL),(13,'20240717-000012','306.00','admin','2024 07 17','  Cash','  General','306.00','0.00','0.00','0.0','13','202407171530',NULL,NULL,NULL,NULL,NULL,NULL),(14,'20240718-000011','358.00','admin','2024 07 18','  Cash','  General','358.00','0.00','0.00','0.0','14','202407181050',NULL,NULL,NULL,NULL,NULL,NULL),(15,'20240718-000012','513.00','admin','2024 07 18','  Cash','  General','513.00','0.00','0.00','0.0','15','202407181051',NULL,NULL,NULL,NULL,NULL,NULL),(16,'20240808-000011','56.00','madmin','2024 08 08','  cash','  General','56.000000','0.000000','0.000000','0','16','20240808150008','','','','0','0',NULL),(17,'20240808-000012','864.00','madmin','2024 08 08','  Pay Later','  General','864.000000','0.000000','0.000000','0','17','202408081537','','','','0','0',NULL),(18,'20240808-000013','123.00','madmin','2024 08 08','  card','  General','123.000000','0.000000','0.000000','0','18','202408081538','','','','0','0',NULL),(19,'20240809-000011','800.00','madmin','2024 08 09','  cash','  General','825.000000','0.000000','0.000000','0','19','202408091311','','','','0','0',NULL),(20,'20240810-000011','306.00','madmin','2024 08 10','  cash','  General','306.000000','0.000000','0.000000','0','20','202408101125','','','','0','0',NULL),(21,'20240810-000012','420.00','madmin','2024 08 10','  cash','  General','420.000000','0.000000','0.000000','0','21','202408101128','','','','0','0',NULL),(22,'20240812-000011','450.00','admin','2024 08 12','  Cash','  General','500.00','0.00','+ 0.00','0.0','22','202408121303',NULL,NULL,NULL,NULL,NULL,NULL),(23,'20240813-000011','750.60','admin','2024 08 13','  Cash','  General','834.00','0.00','+ 0.00','0.0','23','202408131508',NULL,NULL,NULL,NULL,NULL,NULL),(24,'20240813-000012','667.20','admin','2024 08 13','  Cash','  General','834.00','0.00','+ 0.00','0.0','24','202408131509',NULL,NULL,NULL,NULL,NULL,NULL),(25,'20240813-000013','403.20','admin','2024 08 13','  Cash','  General','504.00','0.00','+ 0.00','0.0','25','202408131511',NULL,NULL,NULL,NULL,NULL,NULL),(26,'20240813-000014','614.70','admin','2024 08 13','  Cash','  General','683.00','0.00','+ 0.00','0.0','26','202408131511',NULL,NULL,NULL,NULL,NULL,NULL),(27,'20240813-000015','494.90','admin','2024 08 13','  Cash','  General','707.00','0.00','+ 0.00','0.0','27','202408131512',NULL,NULL,NULL,NULL,NULL,NULL),(28,'20240814-000011','70.00','madmin','2024 08 14','  cash','  General','70.000000','0.000000','0.000000','0','28','20240814140003','','','','0','0',NULL),(29,'20240814-000012','670.00','madmin','2024 08 14','  cash','  General','670.000000','0.000000','0.000000','0','29','202408141442','','','','0','0',NULL),(30,'20240814-000013','150.00','madmin','2024 08 14','  cash','  General','150.000000','0.000000','0.000000','0','30','202408141446','','','','0','0',NULL),(31,'20240814-000014','504.00','madmin','2024 08 14','  cash','  General','504.000000','0.000000','0.000000','0','31','202408141525','','','','0','0',NULL),(32,'20240814-000015','3210.00','madmin','2024 08 14','  cash','  General','3210.000000','0.000000','0.000000','0','32','202408141529','','','','0','0',NULL),(33,'20240816-000011','1000.00','madmin','2024 08 16','  cash','  General','1000.000000','0.000000','0.000000','0','33','20240816110000','','','','0','0',NULL),(34,'20240816-000012','726.00','madmin','2024 08 16','  Pay Later','  General','726.000000','0.000000','0.000000','0','34','202408161232','','','','0','0',NULL),(35,'20240816-000013','642.00','madmin','2024 08 16','  Pay Later','  General','642.000000','0.000000','0.000000','0','35','202408161450','','','','0','0',NULL),(36,'20240816-000014','56.00','madmin','2024 08 16','  Pay Later','  General','56.000000','0.000000','0.000000','0','36','202408161456','','','','0','0',NULL),(37,'20240816-000015','670.00','madmin','2024 08 16','  Pay Later','  General','670.000000','0.000000','0.000000','0','37','202408161457','','','','0','0',NULL),(38,'20240816-000016','726.00','admin','2024 08 16','  Pay Later','  General','726.00','0.00','0.00','0.0','38','202408161501',NULL,NULL,NULL,NULL,NULL,NULL),(39,'20240816-000017','726.00','admin','2024 08 16','  Cash','  General','726.00','0.00','0.00','0.0','39','202408161503',NULL,NULL,NULL,NULL,NULL,NULL),(40,'20240820-000011','944.00','madmin','2024 08 20','  Pay Later','  General','944.000000','0.000000','0.000000','0','40','202408201241','','','','0','0',NULL),(41,'20240820-000012','643.00','madmin','2024 08 20','  Pay Later','  General','643.000000','0.000000','0.000000','0','41','202408201244','','','','0','0',NULL),(42,'20240820-000013','556.00','madmin','2024 08 20','  cash','  General','556.000000','0.000000','0.000000','0','42','202408201245','','','','0','0',NULL),(43,'20240820-000014','258.00','madmin','2024 08 20','  Pay Later','  General','258.000000','0.000000','0.000000','0','43','202408201245','','','','0','0',NULL),(44,'20240821-000011','530.00','madmin','2024 08 21','  Pay Later','  General','530.000000','0.000000','0.000000','0','44','202408211028','','','','0','0',NULL),(45,'20240821-000012','2400.00','admin','2024 08 21','  Cash','  General','2400.00','0.00','0.00','0.0','45','202408211518',NULL,NULL,NULL,NULL,NULL,NULL),(46,'20240821-000013','1750.18','madmin','2024 08 21','  cash','  General','1476.000000','274.180000','0.000000','265.68','46','202408211719','','','','0','0',NULL),(47,'20240903-000011','165.20','madmin','2024 09 03','  cash','  General','140.000000','25.200000','0.000000','25.2','47','20240903130001','','','','0','0',NULL),(48,'20240903-000012','218.30','madmin','2024 09 03','  Pay Later','  General','185.000000','33.300000','0.000000','33.3','48','20240903130007','','','','0','0',NULL),(49,'20241023-000011','178.00','admin','2024 10 23','  Pay Later','  General','178.00','0.00','0.00','0.0','49','202410231427',NULL,NULL,NULL,NULL,NULL,NULL),(50,'20241023-000012','190.00','admin','2024 10 23','  Cash','  General','190.00','0.00','0.00','0.0','50','202410231509',NULL,NULL,NULL,NULL,NULL,NULL),(51,'20241023-000013','178.00','admin','2024 10 23','  Cash','  General','178.00','0.00','0.00','0.0','51','202410231609',NULL,NULL,NULL,NULL,NULL,NULL),(52,'20241023-000014','400.00','admin','2024 10 23','  Cash','  General','400.00','0.00','0.00','0.0','52','202410231622',NULL,NULL,NULL,NULL,NULL,NULL),(53,'20241024-000011','198.00','admin','2024 10 24','  Cash','  General','198.00','0.00','0.00','0.0','53','202410241800',NULL,NULL,NULL,NULL,NULL,NULL),(54,'20241026-000011','196.00','admin','2024 10 26','  Cash','  General','196.00','0.00','0.00','0.0','54','202410261522',NULL,NULL,NULL,NULL,NULL,NULL),(55,'20241026-000012','216.00','admin','2024 10 26','  Pay Later','  General','216.00','0.00','0.00','0.0','55','202410261525',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `cusotmer_activity_temp_top3` (`_id`, `name`, `phone_no`, `email`, `addr`, `total_amount`, `balance`, `discount_value`, `discount_type`, `approval_rate`) VALUES (3,'Bbbbbb','8536921470','','',358,'0.0',NULL,NULL,NULL),(4,'Aaaaa','9632587410','','',513,'0.0',NULL,NULL,NULL);
INSERT INTO `customer_loyalty_points` (`_id`, `phoneno`, `points`) VALUES (1,'9632587410','2147483670');
INSERT INTO `discountdetails` (`_id`, `date`, `time`, `billno`, `Discountcodeno`, `Discount_percent`, `Billamount_rupess`, `Discount_rupees`, `date1`, `original_amount`, `billcount`, `datetimee_new`, `paymentmethod`) VALUES (1,'2024 07 22','04:41:08 PM','20240722-000011','ten percent','10','108.00','12.00','22 Jul 2024','120.00',NULL,'202407221641',NULL),(2,'2024 07 22','04:42:53 PM','20240722-000012','ten percent','10','231.30','25.70','22 Jul 2024','257.00',NULL,'202407221642',NULL),(3,'2024 08 12','01:03:13 pm','20240812-000011','Discount10','10','450.00','50.00','12 Aug 2024','500.00',NULL,'202408121303',NULL),(4,'2024 08 13','03:08:30 pm','20240813-000011','Discount10','10','750.60','83.40','13 Aug 2024','834.00',NULL,'202408131508',NULL),(5,'2024 08 13','03:09:47 pm','20240813-000012','Discount20','20','667.20','166.80','13 Aug 2024','834.00',NULL,'202408131509',NULL),(6,'2024 08 13','03:11:14 pm','20240813-000013','Discount20','20','403.20','100.80','13 Aug 2024','504.00',NULL,'202408131511',NULL),(7,'2024 08 13','03:11:45 pm','20240813-000014','Discount10','10','614.70','68.30','13 Aug 2024','683.00',NULL,'202408131511',NULL),(8,'2024 08 13','03:12:15 pm','20240813-000015','Duscount30','30','494.90','212.10','13 Aug 2024','707.00',NULL,'202408131512',NULL),(9,'2024 10 23','02:42:45 pm','20241023-000012','Discount10','10','216.00','24.00','23 Oct 2024','240.00',NULL,'202410231442',NULL);
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'Business ',2400),(2,'bananas robusta kg',40),(3,'beans kg',80),(4,'capsicum green kg',160),(5,'carrots kg',140),(6,'cauliflower kg',90),(7,'cucumbers kg',20),(8,'fig fruit kg',500),(9,'ladies finger kg',56),(10,'loreal color 90gms',76),(11,'nutella',340),(12,'sona masoori raw rice 1kg',112),(13,'sweet corn piece',15),(14,'tata urad dal whole white 1kg',750);
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,'1600','Business ',2400,100,'3','Printing',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'23','bananas robusta kg',40,1,'1','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'9','beans kg',80,2,'2','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'6','capsicum green kg',160,3,'2','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'7','carrots kg',140,3,'2','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'8','cauliflower kg',90,2,'2','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'11','cucumbers kg',20,0,'1','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'4','fig fruit kg',500,11,'2','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'5','ladies finger kg',56,1,'2','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'12','loreal color 90gms',76,2,'1','personal care',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'3','nutella',340,7,'2','branded foods',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'1','sona masoori raw rice 1kg',112,2,'2','rice whole grains',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'10','sweet corn piece',15,0,'1','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'2','tata urad dal whole white 1kg',750,16,'3','dals pulses',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (5,'Printing',2400),(6,'Printing',2400),(7,'branded foods',340),(8,'dals pulses',750),(9,'fruits and vegetables',1101),(10,'personal care',76),(11,'rice whole grains',112),(12,'dals pulses',250),(13,'fruits and vegetables',45),(14,'rice whole grains',56),(19,'dals pulses',500),(20,'rice whole grains',112),(21,'dals pulses',500),(22,'rice whole grains',112),(23,'fruits and vegetables',871),(25,'Facial',5400),(26,'Dairy products',325),(27,'Dairy products',178),(28,'Dairy products',178),(30,'Dairy products',503),(35,'Dairy products',318),(36,'chocolate',50),(37,'Dairy products',896),(38,'chocolate',50),(40,'Dairy products',1419),(41,'chocolate',50);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',2400),(2,'madmin',3094);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',2400,100),(2,'madmin',3094,68);
