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,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240315-000011','08:08:06 PM','2024 03 15','admin','1','  General','  Cash','656.00','656.00','1',NULL,NULL,NULL,NULL,'15 Mar 2024','2024031520:08:06','%','0','56.00','no','0.00',NULL,'202403152008','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(2,'capsicum green kg','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240315-000011','08:08:06 PM','2024 03 15','admin','1','  General','  Cash','656.00','656.00','2',NULL,NULL,NULL,NULL,'15 Mar 2024','2024031520:08:06','%','0','80.00','no','0.00',NULL,'202403152008','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(3,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240315-000011','08:08:06 PM','2024 03 15','admin','1','  General','  Cash','656.00','656.00','3',NULL,NULL,NULL,NULL,'15 Mar 2024','2024031520:08:06','%','0','250.00','no','0.00',NULL,'202403152008','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(4,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240315-000011','08:08:06 PM','2024 03 15','admin','1','  General','  Cash','656.00','656.00','4',NULL,NULL,NULL,NULL,'15 Mar 2024','2024031520:08:06','%','0','250.00','no','0.00',NULL,'202403152008','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(5,'onions big kg','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240315-000011','08:08:06 PM','2024 03 15','admin','1','  General','  Cash','656.00','656.00','5',NULL,NULL,NULL,NULL,'15 Mar 2024','2024031520:08:06','%','0','20.00','no','0.00',NULL,'202403152008','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(6,'capsicum green kg','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240315-000012','08:08:37 PM','2024 03 15','admin','1','  General','  Cash','512.00','512.00','6',NULL,NULL,NULL,NULL,'15 Mar 2024','2024031520:08:37','%','0','80.00','no','0.00',NULL,'202403152008','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(7,'sona masoori raw rice 1kg','2.0','56.00','112.00','Item',NULL,NULL,'no',NULL,NULL,'20240315-000012','08:08:37 PM','2024 03 15','admin','1','  General','  Cash','512.00','512.00','7',NULL,NULL,NULL,NULL,'15 Mar 2024','2024031520:08:37','%','0','112.00','no','0.00',NULL,'202403152008','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(8,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240315-000012','08:08:37 PM','2024 03 15','admin','1','  General','  Cash','512.00','512.00','8',NULL,NULL,NULL,NULL,'15 Mar 2024','2024031520:08:37','%','0','250.00','no','0.00',NULL,'202403152008','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(9,'carrots kg','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240315-000012','08:08:37 PM','2024 03 15','admin','1','  General','  Cash','512.00','512.00','9',NULL,NULL,NULL,NULL,'15 Mar 2024','2024031520:08:37','%','0','70.00','no','0.00',NULL,'202403152008','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(10,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240315-000013','08:09:10 PM','2024 03 15','admin','1','  General','  Cash','467.00','467.00','10',NULL,NULL,NULL,NULL,'15 Mar 2024','2024031520:09:10','%','0','56.00','no','0.00',NULL,'202403152009','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(11,'capsicum green kg','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240315-000013','08:09:10 PM','2024 03 15','admin','1','  General','  Cash','467.00','467.00','11',NULL,NULL,NULL,NULL,'15 Mar 2024','2024031520:09:10','%','0','80.00','no','0.00',NULL,'202403152009','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(12,'loreal color 90gms','1.0','76.00','76.00','Item',NULL,NULL,'no',NULL,NULL,'20240315-000013','08:09:10 PM','2024 03 15','admin','1','  General','  Cash','467.00','467.00','12',NULL,NULL,NULL,NULL,'15 Mar 2024','2024031520:09:10','%','0','76.00','no','0.00',NULL,'202403152009','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(13,'cauliflower kg','1.0','45.00','45.00','Item',NULL,NULL,'no',NULL,NULL,'20240315-000013','08:09:10 PM','2024 03 15','admin','1','  General','  Cash','467.00','467.00','13',NULL,NULL,NULL,NULL,'15 Mar 2024','2024031520:09:10','%','0','45.00','no','0.00',NULL,'202403152009','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(14,'beans kg','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240315-000013','08:09:10 PM','2024 03 15','admin','1','  General','  Cash','467.00','467.00','14',NULL,NULL,NULL,NULL,'15 Mar 2024','2024031520:09:10','%','0','40.00','no','0.00',NULL,'202403152009','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(15,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20240315-000013','08:09:10 PM','2024 03 15','admin','1','  General','  Cash','467.00','467.00','15',NULL,NULL,NULL,NULL,'15 Mar 2024','2024031520:09:10','%','0','170.00','no','0.00',NULL,'202403152009','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(16,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240328-000011','01:53:11 PM','2024 03 28','ladmin','1','  General','  Cash','690.00','690.00','16',NULL,NULL,NULL,NULL,'28 Mar 2024','2024032813:53:11','%','0','56.00','no','0.00',NULL,'202403281353','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(17,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240328-000011','01:53:11 PM','2024 03 28','ladmin','1','  General','  Cash','690.00','690.00','17',NULL,NULL,NULL,NULL,'28 Mar 2024','2024032813:53:11','%','0','250.00','no','0.00',NULL,'202403281353','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(18,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240328-000011','01:53:11 PM','2024 03 28','ladmin','1','  General','  Cash','690.00','690.00','18',NULL,NULL,NULL,NULL,'28 Mar 2024','2024032813:53:11','%','0','250.00','no','0.00',NULL,'202403281353','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(19,'beet root kg','2.0','32.00','64.00','Item',NULL,NULL,'no',NULL,NULL,'20240328-000011','01:53:11 PM','2024 03 28','ladmin','1','  General','  Cash','690.00','690.00','19',NULL,NULL,NULL,NULL,'28 Mar 2024','2024032813:53:11','%','0','64.00','no','0.00',NULL,'202403281353','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(20,'carrots kg','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240328-000011','01:53:11 PM','2024 03 28','ladmin','1','  General','  Cash','690.00','690.00','20',NULL,NULL,NULL,NULL,'28 Mar 2024','2024032813:53:11','%','0','70.00','no','0.00',NULL,'202403281353','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(21,'onions big kg','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240328-000012','01:53:43 PM','2024 03 28','ladmin','1','  General','  Cash','387.00','387.00','21',NULL,NULL,NULL,NULL,'28 Mar 2024','2024032813:53:43','%','0','40.00','no','0.00',NULL,'202403281353','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(22,'cauliflower kg','1.0','45.00','45.00','Item',NULL,NULL,'no',NULL,NULL,'20240328-000012','01:53:43 PM','2024 03 28','ladmin','1','  General','  Cash','387.00','387.00','22',NULL,NULL,NULL,NULL,'28 Mar 2024','2024032813:53:43','%','0','45.00','no','0.00',NULL,'202403281353','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(23,'cucumbers kg','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240328-000012','01:53:43 PM','2024 03 28','ladmin','1','  General','  Cash','387.00','387.00','23',NULL,NULL,NULL,NULL,'28 Mar 2024','2024032813:53:43','%','0','20.00','no','0.00',NULL,'202403281353','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(24,'beet root kg','1.0','32.00','32.00','Item',NULL,NULL,'no',NULL,NULL,'20240328-000012','01:53:43 PM','2024 03 28','ladmin','1','  General','  Cash','387.00','387.00','24',NULL,NULL,NULL,NULL,'28 Mar 2024','2024032813:53:43','%','0','32.00','no','0.00',NULL,'202403281353','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(25,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240328-000012','01:53:43 PM','2024 03 28','ladmin','1','  General','  Cash','387.00','387.00','25',NULL,NULL,NULL,NULL,'28 Mar 2024','2024032813:53:43','%','0','250.00','no','0.00',NULL,'202403281353','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(26,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240328-000013','01:55:33 PM','2024 03 28','ladmin','1','  General','  Cash','670.00','670.00','26',NULL,NULL,NULL,NULL,'28 Mar 2024','2024032813:55:33','%','0','250.00','no','0.00',NULL,'202403281355','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(27,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20240328-000013','01:55:33 PM','2024 03 28','ladmin','1','  General','  Cash','670.00','670.00','27',NULL,NULL,NULL,NULL,'28 Mar 2024','2024032813:55:33','%','0','170.00','no','0.00',NULL,'202403281355','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(28,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240328-000013','01:55:33 PM','2024 03 28','ladmin','1','  General','  Cash','670.00','670.00','28',NULL,NULL,NULL,NULL,'28 Mar 2024','2024032813:55:33','%','0','250.00','no','0.00',NULL,'202403281355','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(29,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240328-000014','01:55:53 PM','2024 03 28','ladmin','1','  General','  Cash','670.00','670.00','29',NULL,NULL,NULL,NULL,'28 Mar 2024','2024032813:55:53','%','0','250.00','no','0.00',NULL,'202403281355','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(30,'carrots kg','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240328-000014','01:55:53 PM','2024 03 28','ladmin','1','  General','  Cash','670.00','670.00','30',NULL,NULL,NULL,NULL,'28 Mar 2024','2024032813:55:53','%','0','70.00','no','0.00',NULL,'202403281355','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(31,'beet root kg','2.0','32.00','64.00','Item',NULL,NULL,'no',NULL,NULL,'20240328-000014','01:55:53 PM','2024 03 28','ladmin','1','  General','  Cash','670.00','670.00','31',NULL,NULL,NULL,NULL,'28 Mar 2024','2024032813:55:53','%','0','64.00','no','0.00',NULL,'202403281355','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(32,'beans kg','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240328-000014','01:55:53 PM','2024 03 28','ladmin','1','  General','  Cash','670.00','670.00','32',NULL,NULL,NULL,NULL,'28 Mar 2024','2024032813:55:53','%','0','40.00','no','0.00',NULL,'202403281355','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(33,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20240328-000014','01:55:53 PM','2024 03 28','ladmin','1','  General','  Cash','670.00','670.00','33',NULL,NULL,NULL,NULL,'28 Mar 2024','2024032813:55:53','%','0','170.00','no','0.00',NULL,'202403281355','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(34,'loreal color 90gms','1.0','76.00','76.00','Item',NULL,NULL,'no',NULL,NULL,'20240328-000014','01:55:53 PM','2024 03 28','ladmin','1','  General','  Cash','670.00','670.00','34',NULL,NULL,NULL,NULL,'28 Mar 2024','2024032813:55:53','%','0','76.00','no','0.00',NULL,'202403281355','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(35,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240328-000015','01:59:11 PM','2024 03 28','ladmin','1','  General','  Cash','505.00','505.00','35',NULL,NULL,NULL,NULL,'28 Mar 2024','2024032813:59:11','%','0','56.00','no','0.00',NULL,'202403281359','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(36,'carrots kg','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240328-000015','01:59:11 PM','2024 03 28','ladmin','1','  General','  Cash','505.00','505.00','36',NULL,NULL,NULL,NULL,'28 Mar 2024','2024032813:59:11','%','0','70.00','no','0.00',NULL,'202403281359','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(37,'cauliflower kg','1.0','45.00','45.00','Item',NULL,NULL,'no',NULL,NULL,'20240328-000015','01:59:11 PM','2024 03 28','ladmin','1','  General','  Cash','505.00','505.00','37',NULL,NULL,NULL,NULL,'28 Mar 2024','2024032813:59:11','%','0','45.00','no','0.00',NULL,'202403281359','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(38,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240328-000015','01:59:11 PM','2024 03 28','ladmin','1','  General','  Cash','505.00','505.00','38',NULL,NULL,NULL,NULL,'28 Mar 2024','2024032813:59:11','%','0','250.00','no','0.00',NULL,'202403281359','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(39,'beet root kg','2.0','32.00','64.00','Item',NULL,NULL,'no',NULL,NULL,'20240328-000015','01:59:11 PM','2024 03 28','ladmin','1','  General','  Cash','505.00','505.00','39',NULL,NULL,NULL,NULL,'28 Mar 2024','2024032813:59:11','%','0','64.00','no','0.00',NULL,'202403281359','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(40,'onions big kg','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240328-000015','01:59:11 PM','2024 03 28','ladmin','1','  General','  Cash','505.00','505.00','40',NULL,NULL,NULL,NULL,'28 Mar 2024','2024032813:59:11','%','0','20.00','no','0.00',NULL,'202403281359','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(41,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240328-000016','01:59:29 PM','2024 03 28','ladmin','1','  General','  Cash','510.00','510.00','41',NULL,NULL,NULL,NULL,'28 Mar 2024','2024032813:59:29','%','0','56.00','no','0.00',NULL,'202403281359','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(42,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240328-000016','01:59:29 PM','2024 03 28','ladmin','1','  General','  Cash','510.00','510.00','42',NULL,NULL,NULL,NULL,'28 Mar 2024','2024032813:59:29','%','0','250.00','no','0.00',NULL,'202403281359','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(43,'onions big kg','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240328-000016','01:59:29 PM','2024 03 28','ladmin','1','  General','  Cash','510.00','510.00','43',NULL,NULL,NULL,NULL,'28 Mar 2024','2024032813:59:29','%','0','20.00','no','0.00',NULL,'202403281359','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(44,'loreal color 90gms','2.0','76.00','152.00','Item',NULL,NULL,'no',NULL,NULL,'20240328-000016','01:59:29 PM','2024 03 28','ladmin','1','  General','  Cash','510.00','510.00','44',NULL,NULL,NULL,NULL,'28 Mar 2024','2024032813:59:29','%','0','152.00','no','0.00',NULL,'202403281359','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(45,'beet root kg','1.0','32.00','32.00','Item',NULL,NULL,'no',NULL,NULL,'20240328-000016','01:59:29 PM','2024 03 28','ladmin','1','  General','  Cash','510.00','510.00','45',NULL,NULL,NULL,NULL,'28 Mar 2024','2024032813:59:29','%','0','32.00','no','0.00',NULL,'202403281359','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(46,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240403-000011','03:09:29 PM','2024 04 03','ladmin','1','  General','  Cash','624.00','624.00','46',NULL,NULL,NULL,NULL,'03 Apr 2024','2024040315:09:29','%','0','56.00','no','0.00',NULL,'202404031509','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(47,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240403-000011','03:09:29 PM','2024 04 03','ladmin','1','  General','  Cash','624.00','624.00','47',NULL,NULL,NULL,NULL,'03 Apr 2024','2024040315:09:29','%','0','250.00','no','0.00',NULL,'202404031509','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(48,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20240403-000011','03:09:29 PM','2024 04 03','ladmin','1','  General','  Cash','624.00','624.00','48',NULL,NULL,NULL,NULL,'03 Apr 2024','2024040315:09:29','%','0','170.00','no','0.00',NULL,'202404031509','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(49,'beans kg','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240403-000011','03:09:29 PM','2024 04 03','ladmin','1','  General','  Cash','624.00','624.00','49',NULL,NULL,NULL,NULL,'03 Apr 2024','2024040315:09:29','%','0','40.00','no','0.00',NULL,'202404031509','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(50,'beet root kg','1.0','32.00','32.00','Item',NULL,NULL,'no',NULL,NULL,'20240403-000011','03:09:29 PM','2024 04 03','ladmin','1','  General','  Cash','624.00','624.00','50',NULL,NULL,NULL,NULL,'03 Apr 2024','2024040315:09:29','%','0','32.00','no','0.00',NULL,'202404031509','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(51,'loreal color 90gms','1.0','76.00','76.00','Item',NULL,NULL,'no',NULL,NULL,'20240403-000011','03:09:29 PM','2024 04 03','ladmin','1','  General','  Cash','624.00','624.00','51',NULL,NULL,NULL,NULL,'03 Apr 2024','2024040315:09:29','%','0','76.00','no','0.00',NULL,'202404031509','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(52,'capsicum green kg','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240403-000012','03:09:53 PM','2024 04 03','ladmin','1','  General','  Cash','928.00','928.00','52',NULL,NULL,NULL,NULL,'03 Apr 2024','2024040315:09:53','%','0','80.00','no','0.00',NULL,'202404031509','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(53,'carrots kg','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240403-000012','03:09:53 PM','2024 04 03','ladmin','1','  General','  Cash','928.00','928.00','53',NULL,NULL,NULL,NULL,'03 Apr 2024','2024040315:09:53','%','0','70.00','no','0.00',NULL,'202404031509','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(54,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240403-000012','03:09:53 PM','2024 04 03','ladmin','1','  General','  Cash','928.00','928.00','54',NULL,NULL,NULL,NULL,'03 Apr 2024','2024040315:09:53','%','0','250.00','no','0.00',NULL,'202404031509','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(55,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20240403-000012','03:09:53 PM','2024 04 03','ladmin','1','  General','  Cash','928.00','928.00','55',NULL,NULL,NULL,NULL,'03 Apr 2024','2024040315:09:53','%','0','170.00','no','0.00',NULL,'202404031509','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(56,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240403-000012','03:09:53 PM','2024 04 03','ladmin','1','  General','  Cash','928.00','928.00','56',NULL,NULL,NULL,NULL,'03 Apr 2024','2024040315:09:53','%','0','250.00','no','0.00',NULL,'202404031509','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(57,'loreal color 90gms','1.0','76.00','76.00','Item',NULL,NULL,'no',NULL,NULL,'20240403-000012','03:09:53 PM','2024 04 03','ladmin','1','  General','  Cash','928.00','928.00','57',NULL,NULL,NULL,NULL,'03 Apr 2024','2024040315:09:53','%','0','76.00','no','0.00',NULL,'202404031509','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(58,'beet root kg','1.0','32.00','32.00','Item',NULL,NULL,'no',NULL,NULL,'20240403-000012','03:09:53 PM','2024 04 03','ladmin','1','  General','  Cash','928.00','928.00','58',NULL,NULL,NULL,NULL,'03 Apr 2024','2024040315:09:53','%','0','32.00','no','0.00',NULL,'202404031509','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(59,'Flax seed','1.0','200.00','200.00','Item',NULL,NULL,'no',NULL,NULL,'20240403-000013','03:19:22 PM','2024 04 03','ladmin','1','  General','  Cash','280.00','280.00','59',NULL,NULL,NULL,NULL,'03 Apr 2024','2024040315:19:22','%','5','190.00','yes','10.00',NULL,'202404031519','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'8956995209140',NULL,NULL,'','','','',NULL,NULL),(60,'cucumbers kg','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240403-000013','03:19:22 PM','2024 04 03','ladmin','1','  General','  Cash','280.00','280.00','60',NULL,NULL,NULL,NULL,'03 Apr 2024','2024040315:19:22','%','0','20.00','no','0.00',NULL,'202404031519','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(61,'carrots kg','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240403-000013','03:19:22 PM','2024 04 03','ladmin','1','  General','  Cash','280.00','280.00','61',NULL,NULL,NULL,NULL,'03 Apr 2024','2024040315:19:22','%','0','70.00','no','0.00',NULL,'202404031519','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(62,'capsicum green kg','2.0','80.00','160.00','Item',NULL,NULL,'no',NULL,NULL,'20240403-000014','03:21:56 PM','2024 04 03','ladmin','1','  General','  Cash','358.00','358.00','62',NULL,NULL,NULL,NULL,'03 Apr 2024','2024040315:21:56','%','0','160.00','no','0.00',NULL,'202404031521','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(63,'carrots kg','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240403-000014','03:21:56 PM','2024 04 03','ladmin','1','  General','  Cash','358.00','358.00','63',NULL,NULL,NULL,NULL,'03 Apr 2024','2024040315:21:56','%','0','70.00','no','0.00',NULL,'202404031521','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(64,'cucumbers kg','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240403-000014','03:21:56 PM','2024 04 03','ladmin','1','  General','  Cash','358.00','358.00','64',NULL,NULL,NULL,NULL,'03 Apr 2024','2024040315:21:56','%','0','20.00','no','0.00',NULL,'202404031521','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(65,'potatoes kg','1.0','32.00','32.00','Item',NULL,NULL,'no',NULL,NULL,'20240403-000014','03:21:56 PM','2024 04 03','ladmin','1','  General','  Cash','358.00','358.00','65',NULL,NULL,NULL,NULL,'03 Apr 2024','2024040315:21:56','%','0','32.00','no','0.00',NULL,'202404031521','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(66,'loreal color 90gms','1.0','76.00','76.00','Item',NULL,NULL,'no',NULL,NULL,'20240403-000014','03:21:56 PM','2024 04 03','ladmin','1','  General','  Cash','358.00','358.00','66',NULL,NULL,NULL,NULL,'03 Apr 2024','2024040315:21:56','%','0','76.00','no','0.00',NULL,'202404031521','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(67,'onions big kg','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240403-000015','03:23:08 PM','2024 04 03','ladmin','1','  General','  Upiqr','245.00','245.00','67',NULL,NULL,NULL,NULL,'03 Apr 2024','2024040315:23:08','%','0','20.00','no','0.00',NULL,'202404031523','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(68,'beans kg','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240403-000015','03:23:08 PM','2024 04 03','ladmin','1','  General','  Upiqr','245.00','245.00','68',NULL,NULL,NULL,NULL,'03 Apr 2024','2024040315:23:08','%','0','40.00','no','0.00',NULL,'202404031523','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(69,'cauliflower kg','1.0','45.00','45.00','Item',NULL,NULL,'no',NULL,NULL,'20240403-000015','03:23:08 PM','2024 04 03','ladmin','1','  General','  Upiqr','245.00','245.00','69',NULL,NULL,NULL,NULL,'03 Apr 2024','2024040315:23:08','%','0','45.00','no','0.00',NULL,'202404031523','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(70,'beet root kg','1.0','32.00','32.00','Item',NULL,NULL,'no',NULL,NULL,'20240403-000015','03:23:08 PM','2024 04 03','ladmin','1','  General','  Upiqr','245.00','245.00','70',NULL,NULL,NULL,NULL,'03 Apr 2024','2024040315:23:08','%','0','32.00','no','0.00',NULL,'202404031523','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(71,'cabbage kg','1.0','32.00','32.00','Item',NULL,NULL,'no',NULL,NULL,'20240403-000015','03:23:08 PM','2024 04 03','ladmin','1','  General','  Upiqr','245.00','245.00','71',NULL,NULL,NULL,NULL,'03 Apr 2024','2024040315:23:08','%','0','32.00','no','0.00',NULL,'202404031523','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(72,'loreal color 90gms','1.0','76.00','76.00','Item',NULL,NULL,'no',NULL,NULL,'20240403-000015','03:23:08 PM','2024 04 03','ladmin','1','  General','  Upiqr','245.00','245.00','72',NULL,NULL,NULL,NULL,'03 Apr 2024','2024040315:23:08','%','0','76.00','no','0.00',NULL,'202404031523','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','ladmin','ladmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(73,'loreal color 90gms','2.0','76.00','152.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000011','11:48:12 AM','2024 04 14','ladmin','1','  General','  Cash','1024.00','1024.00','73',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041411:48:12','%','0','152.00','no','0.00',NULL,'202404141148','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(74,'beet root kg','1.0','32.00','32.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000011','11:48:12 AM','2024 04 14','ladmin','1','  General','  Cash','1024.00','1024.00','74',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041411:48:12','%','0','32.00','no','0.00',NULL,'202404141148','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(75,'carrots kg','3.0','70.00','210.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000011','11:48:12 AM','2024 04 14','ladmin','1','  General','  Cash','1024.00','1024.00','75',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041411:48:12','%','0','210.00','no','0.00',NULL,'202404141148','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(76,'cauliflower kg','2.0','45.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000011','11:48:12 AM','2024 04 14','ladmin','1','  General','  Cash','1024.00','1024.00','76',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041411:48:12','%','0','90.00','no','0.00',NULL,'202404141148','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(77,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000011','11:48:12 AM','2024 04 14','ladmin','1','  General','  Cash','1024.00','1024.00','77',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041411:48:12','%','0','250.00','no','0.00',NULL,'202404141148','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(78,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000011','11:48:12 AM','2024 04 14','ladmin','1','  General','  Cash','1024.00','1024.00','78',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041411:48:12','%','0','250.00','no','0.00',NULL,'202404141148','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(79,'onions big kg','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000011','11:48:12 AM','2024 04 14','ladmin','1','  General','  Cash','1024.00','1024.00','79',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041411:48:12','%','0','40.00','no','0.00',NULL,'202404141148','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(80,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000012','11:48:51 AM','2024 04 14','ladmin','1','  General','  Cash','682.00','682.00','80',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041411:48:51','%','0','56.00','no','0.00',NULL,'202404141148','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(81,'carrots kg','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000012','11:48:51 AM','2024 04 14','ladmin','1','  General','  Cash','682.00','682.00','81',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041411:48:51','%','0','70.00','no','0.00',NULL,'202404141148','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(82,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000012','11:48:51 AM','2024 04 14','ladmin','1','  General','  Cash','682.00','682.00','82',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041411:48:51','%','0','170.00','no','0.00',NULL,'202404141148','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(83,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000012','11:48:51 AM','2024 04 14','ladmin','1','  General','  Cash','682.00','682.00','83',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041411:48:51','%','0','250.00','no','0.00',NULL,'202404141148','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(84,'beans kg','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000012','11:48:51 AM','2024 04 14','ladmin','1','  General','  Cash','682.00','682.00','84',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041411:48:51','%','0','40.00','no','0.00',NULL,'202404141148','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(85,'onions big kg','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000012','11:48:51 AM','2024 04 14','ladmin','1','  General','  Cash','682.00','682.00','85',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041411:48:51','%','0','20.00','no','0.00',NULL,'202404141148','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(86,'loreal color 90gms','1.0','76.00','76.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000012','11:48:51 AM','2024 04 14','ladmin','1','  General','  Cash','682.00','682.00','86',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041411:48:51','%','0','76.00','no','0.00',NULL,'202404141148','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(87,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000013','11:54:00 AM','2024 04 14','ladmin','1','  General','  Cash','767.00','767.00','87',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041411:54:00','%','0','56.00','no','0.00',NULL,'202404141154','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(88,'capsicum green kg','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000013','11:54:00 AM','2024 04 14','ladmin','1','  General','  Cash','767.00','767.00','88',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041411:54:00','%','0','80.00','no','0.00',NULL,'202404141154','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(89,'cucumbers kg','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000013','11:54:00 AM','2024 04 14','ladmin','1','  General','  Cash','767.00','767.00','89',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041411:54:00','%','0','20.00','no','0.00',NULL,'202404141154','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(90,'loreal color 90gms','1.0','76.00','76.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000013','11:54:00 AM','2024 04 14','ladmin','1','  General','  Cash','767.00','767.00','90',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041411:54:00','%','0','76.00','no','0.00',NULL,'202404141154','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(91,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000013','11:54:00 AM','2024 04 14','ladmin','1','  General','  Cash','767.00','767.00','91',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041411:54:00','%','0','250.00','no','0.00',NULL,'202404141154','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(92,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000013','11:54:00 AM','2024 04 14','ladmin','1','  General','  Cash','767.00','767.00','92',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041411:54:00','%','0','250.00','no','0.00',NULL,'202404141154','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(93,'sweet corn piece','1.0','15.00','15.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000013','11:54:00 AM','2024 04 14','ladmin','1','  General','  Cash','767.00','767.00','93',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041411:54:00','%','0','15.00','no','0.00',NULL,'202404141154','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(94,'onions big kg','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000013','11:54:00 AM','2024 04 14','ladmin','1','  General','  Cash','767.00','767.00','94',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041411:54:00','%','0','20.00','no','0.00',NULL,'202404141154','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(95,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000014','12:12:15 PM','2024 04 14','ladmin','1','  General','  Upiqr','1093.00','1093.00','100',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:12:15','%','0','56.00','no','0.00',NULL,'202404141212','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','ladmin','ladmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(96,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000014','12:12:15 PM','2024 04 14','ladmin','1','  General','  Upiqr','1093.00','1093.00','101',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:12:15','%','0','250.00','no','0.00',NULL,'202404141212','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','ladmin','ladmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(97,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000014','12:12:15 PM','2024 04 14','ladmin','1','  General','  Upiqr','1093.00','1093.00','102',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:12:15','%','0','170.00','no','0.00',NULL,'202404141212','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','ladmin','ladmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(98,'dabur lemon juice 250ml','1.0','66.00','66.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000014','12:12:15 PM','2024 04 14','ladmin','1','  General','  Upiqr','1093.00','1093.00','103',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:12:15','%','0','66.00','no','0.00',NULL,'202404141212','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'beverages','ladmin','ladmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(99,'Gold ','2.0','250.00','500.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000014','12:12:15 PM','2024 04 14','ladmin','1','  General','  Upiqr','1093.00','1093.00','104',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:12:15','%','5','475.00','yes','25.00',NULL,'202404141212','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','ladmin','ladmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(100,'loreal color 90gms','1.0','76.00','76.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000014','12:12:15 PM','2024 04 14','ladmin','1','  General','  Upiqr','1093.00','1093.00','105',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:12:15','%','0','76.00','no','0.00',NULL,'202404141212','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','ladmin','ladmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(101,'capsicum green kg','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000015','12:13:09 PM','2024 04 14','ladmin','1','  General','  Upiqr','599.00','599.00','106',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:13:09','%','0','80.00','no','0.00',NULL,'202404141213','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(102,'loreal color 90gms','2.0','76.00','152.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000015','12:13:09 PM','2024 04 14','ladmin','1','  General','  Upiqr','599.00','599.00','107',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:13:09','%','0','152.00','no','0.00',NULL,'202404141213','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','ladmin','ladmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(103,'cauliflower kg','1.0','45.00','45.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000015','12:13:09 PM','2024 04 14','ladmin','1','  General','  Upiqr','599.00','599.00','108',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:13:09','%','0','45.00','no','0.00',NULL,'202404141213','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(104,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000015','12:13:09 PM','2024 04 14','ladmin','1','  General','  Upiqr','599.00','599.00','109',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:13:09','%','0','250.00','no','0.00',NULL,'202404141213','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','ladmin','ladmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(105,'cucumbers kg','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000015','12:13:09 PM','2024 04 14','ladmin','1','  General','  Upiqr','599.00','599.00','110',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:13:09','%','0','20.00','no','0.00',NULL,'202404141213','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(106,'onions big kg','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000015','12:13:09 PM','2024 04 14','ladmin','1','  General','  Upiqr','599.00','599.00','111',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:13:09','%','0','20.00','no','0.00',NULL,'202404141213','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(107,'cabbage kg','1.0','32.00','32.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000015','12:13:09 PM','2024 04 14','ladmin','1','  General','  Upiqr','599.00','599.00','112',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:13:09','%','0','32.00','no','0.00',NULL,'202404141213','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(108,'Gold ','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000021','12:20:20 PM','2024 04 14','ladmin','2','  General','  Cash','761.50','761.50','1',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:20:20','%','5','237.50','yes','12.50',NULL,'202404141220','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(109,'loreal color 90gms','2.0','76.00','152.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000021','12:20:20 PM','2024 04 14','ladmin','2','  General','  Cash','761.50','761.50','2',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:20:20','%','0','152.00','no','0.00',NULL,'202404141220','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(110,'beet root kg','1.0','32.00','32.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000021','12:20:20 PM','2024 04 14','ladmin','2','  General','  Cash','761.50','761.50','3',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:20:20','%','0','32.00','no','0.00',NULL,'202404141220','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(111,'onions big kg','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000021','12:20:20 PM','2024 04 14','ladmin','2','  General','  Cash','761.50','761.50','4',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:20:20','%','0','20.00','no','0.00',NULL,'202404141220','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(112,'carrots kg','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000021','12:20:20 PM','2024 04 14','ladmin','2','  General','  Cash','761.50','761.50','5',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:20:20','%','0','70.00','no','0.00',NULL,'202404141220','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(113,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000021','12:20:20 PM','2024 04 14','ladmin','2','  General','  Cash','761.50','761.50','6',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:20:20','%','0','250.00','no','0.00',NULL,'202404141220','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(114,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000016','12:20:44 PM','2024 04 14','ladmin','1','  General','  Cash','568.00','568.00','113',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:20:44','%','0','56.00','no','0.00',NULL,'202404141220','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(115,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000016','12:20:44 PM','2024 04 14','ladmin','1','  General','  Cash','568.00','568.00','114',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:20:44','%','0','250.00','no','0.00',NULL,'202404141220','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(116,'onions big kg','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000016','12:20:44 PM','2024 04 14','ladmin','1','  General','  Cash','568.00','568.00','115',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:20:44','%','0','40.00','no','0.00',NULL,'202404141220','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(117,'loreal color 90gms','2.0','76.00','152.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000016','12:20:44 PM','2024 04 14','ladmin','1','  General','  Cash','568.00','568.00','116',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:20:44','%','0','152.00','no','0.00',NULL,'202404141220','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(118,'carrots kg','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000016','12:20:44 PM','2024 04 14','ladmin','1','  General','  Cash','568.00','568.00','117',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:20:44','%','0','70.00','no','0.00',NULL,'202404141220','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(119,'cauliflower kg','2.0','45.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000017','12:42:30 PM','2024 04 14','ladmin','1','  General','  Upiqr','887.00','887.00','120',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:42:30','%','0','90.00','no','0.00',NULL,'202404141242','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(120,'beet root kg','1.0','32.00','32.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000017','12:42:30 PM','2024 04 14','ladmin','1','  General','  Upiqr','887.00','887.00','121',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:42:30','%','0','32.00','no','0.00',NULL,'202404141242','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(121,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000017','12:42:30 PM','2024 04 14','ladmin','1','  General','  Upiqr','887.00','887.00','122',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:42:30','%','0','170.00','no','0.00',NULL,'202404141242','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','ladmin','ladmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(122,'fig fruit kg','2.0','250.00','500.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000017','12:42:30 PM','2024 04 14','ladmin','1','  General','  Upiqr','887.00','887.00','123',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:42:30','%','0','500.00','no','0.00',NULL,'202404141242','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(123,'beans kg','2.0','40.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000017','12:42:30 PM','2024 04 14','ladmin','1','  General','  Upiqr','887.00','887.00','124',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:42:30','%','0','80.00','no','0.00',NULL,'202404141242','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(124,'sweet corn piece','1.0','15.00','15.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000017','12:42:30 PM','2024 04 14','ladmin','1','  General','  Upiqr','887.00','887.00','125',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:42:30','%','0','15.00','no','0.00',NULL,'202404141242','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(125,'cucumbers kg','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000018','12:43:18 PM','2024 04 14','ladmin','1','  General','  Upiqr','424.00','424.00','126',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:43:18','%','0','20.00','no','0.00',NULL,'202404141243','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(126,'sona masoori raw rice 1kg','2.0','56.00','112.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000018','12:43:18 PM','2024 04 14','ladmin','1','  General','  Upiqr','424.00','424.00','127',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:43:18','%','0','112.00','no','0.00',NULL,'202404141243','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','ladmin','ladmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(127,'onions big kg','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000018','12:43:18 PM','2024 04 14','ladmin','1','  General','  Upiqr','424.00','424.00','128',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:43:18','%','0','20.00','no','0.00',NULL,'202404141243','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(128,'beet root kg','1.0','32.00','32.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000018','12:43:18 PM','2024 04 14','ladmin','1','  General','  Upiqr','424.00','424.00','129',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:43:18','%','0','32.00','no','0.00',NULL,'202404141243','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(129,'carrots kg','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000018','12:43:18 PM','2024 04 14','ladmin','1','  General','  Upiqr','424.00','424.00','130',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:43:18','%','0','70.00','no','0.00',NULL,'202404141243','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(130,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20240414-000018','12:43:18 PM','2024 04 14','ladmin','1','  General','  Upiqr','424.00','424.00','131',NULL,NULL,NULL,NULL,'14 Apr 2024','2024041412:43:18','%','0','170.00','no','0.00',NULL,'202404141243','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','ladmin','ladmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(131,'loreal color 90gms','2.0','76.00','152.00','Item',NULL,NULL,'no',NULL,NULL,'20240506-000011','01:48:46 PM','2024 05 06','ladmin','1','  General','  Cash','651.00','651.00','132',NULL,NULL,NULL,NULL,'06 May 2024','2024050613:48:46','%','0','152.00','no','0.00',NULL,'202405061348','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(132,'sona masoori raw rice 1kg','2.0','56.00','112.00','Item',NULL,NULL,'no',NULL,NULL,'20240506-000011','01:48:46 PM','2024 05 06','ladmin','1','  General','  Cash','651.00','651.00','133',NULL,NULL,NULL,NULL,'06 May 2024','2024050613:48:46','%','0','112.00','no','0.00',NULL,'202405061348','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(133,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240506-000011','01:48:46 PM','2024 05 06','ladmin','1','  General','  Cash','651.00','651.00','134',NULL,NULL,NULL,NULL,'06 May 2024','2024050613:48:46','%','0','250.00','no','0.00',NULL,'202405061348','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(134,'cucumbers kg','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240506-000011','01:48:46 PM','2024 05 06','ladmin','1','  General','  Cash','651.00','651.00','135',NULL,NULL,NULL,NULL,'06 May 2024','2024050613:48:46','%','0','40.00','no','0.00',NULL,'202405061348','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(135,'onions big kg','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240506-000011','01:48:46 PM','2024 05 06','ladmin','1','  General','  Cash','651.00','651.00','136',NULL,NULL,NULL,NULL,'06 May 2024','2024050613:48:46','%','0','20.00','no','0.00',NULL,'202405061348','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(136,'beet root kg','1.0','32.00','32.00','Item',NULL,NULL,'no',NULL,NULL,'20240506-000011','01:48:46 PM','2024 05 06','ladmin','1','  General','  Cash','651.00','651.00','137',NULL,NULL,NULL,NULL,'06 May 2024','2024050613:48:46','%','0','32.00','no','0.00',NULL,'202405061348','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(137,'cauliflower kg','1.0','45.00','45.00','Item',NULL,NULL,'no',NULL,NULL,'20240506-000011','01:48:46 PM','2024 05 06','ladmin','1','  General','  Cash','651.00','651.00','138',NULL,NULL,NULL,NULL,'06 May 2024','2024050613:48:46','%','0','45.00','no','0.00',NULL,'202405061348','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(138,'cucumbers kg','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240506-000012','01:49:07 PM','2024 05 06','ladmin','1','  General','  Cash','523.00','523.00','139',NULL,NULL,NULL,NULL,'06 May 2024','2024050613:49:07','%','0','20.00','no','0.00',NULL,'202405061349','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(139,'capsicum green kg','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240506-000012','01:49:07 PM','2024 05 06','ladmin','1','  General','  Cash','523.00','523.00','140',NULL,NULL,NULL,NULL,'06 May 2024','2024050613:49:07','%','0','80.00','no','0.00',NULL,'202405061349','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(140,'cauliflower kg','1.0','45.00','45.00','Item',NULL,NULL,'no',NULL,NULL,'20240506-000012','01:49:07 PM','2024 05 06','ladmin','1','  General','  Cash','523.00','523.00','141',NULL,NULL,NULL,NULL,'06 May 2024','2024050613:49:07','%','0','45.00','no','0.00',NULL,'202405061349','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(141,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240506-000012','01:49:07 PM','2024 05 06','ladmin','1','  General','  Cash','523.00','523.00','142',NULL,NULL,NULL,NULL,'06 May 2024','2024050613:49:07','%','0','250.00','no','0.00',NULL,'202405061349','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(142,'loreal color 90gms','1.0','76.00','76.00','Item',NULL,NULL,'no',NULL,NULL,'20240506-000012','01:49:07 PM','2024 05 06','ladmin','1','  General','  Cash','523.00','523.00','143',NULL,NULL,NULL,NULL,'06 May 2024','2024050613:49:07','%','0','76.00','no','0.00',NULL,'202405061349','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(143,'beet root kg','1.0','32.00','32.00','Item',NULL,NULL,'no',NULL,NULL,'20240506-000012','01:49:07 PM','2024 05 06','ladmin','1','  General','  Cash','523.00','523.00','144',NULL,NULL,NULL,NULL,'06 May 2024','2024050613:49:07','%','0','32.00','no','0.00',NULL,'202405061349','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(144,'onions big kg','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240506-000012','01:49:07 PM','2024 05 06','ladmin','1','  General','  Cash','523.00','523.00','145',NULL,NULL,NULL,NULL,'06 May 2024','2024050613:49:07','%','0','20.00','no','0.00',NULL,'202405061349','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(145,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240506-000013','07:16:36 PM','2024 05 06','ladmin','1','  General','  Cash','277.00','277.00','1',NULL,NULL,NULL,NULL,'06 May 2024','2024050619:16:36','%','0','56.00','no','0.00',NULL,'202405061916','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(146,'cauliflower kg','1.0','45.00','45.00','Item',NULL,NULL,'no',NULL,NULL,'20240506-000013','07:16:36 PM','2024 05 06','ladmin','1','  General','  Cash','277.00','277.00','2',NULL,NULL,NULL,NULL,'06 May 2024','2024050619:16:36','%','0','45.00','no','0.00',NULL,'202405061916','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(147,'capsicum green kg','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240506-000013','07:16:36 PM','2024 05 06','ladmin','1','  General','  Cash','277.00','277.00','3',NULL,NULL,NULL,NULL,'06 May 2024','2024050619:16:36','%','0','80.00','no','0.00',NULL,'202405061916','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(148,'loreal color 90gms','1.0','76.00','76.00','Item',NULL,NULL,'no',NULL,NULL,'20240506-000013','07:16:36 PM','2024 05 06','ladmin','1','  General','  Cash','277.00','277.00','4',NULL,NULL,NULL,NULL,'06 May 2024','2024050619:16:36','%','0','76.00','no','0.00',NULL,'202405061916','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(149,'cucumbers kg','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240506-000013','07:16:36 PM','2024 05 06','ladmin','1','  General','  Cash','277.00','277.00','5',NULL,NULL,NULL,NULL,'06 May 2024','2024050619:16:36','%','0','20.00','no','0.00',NULL,'202405061916','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(150,'spinach bunch','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240508-000011','12:04:11 PM','2024 05 08','ladmin','1','  General','  Cash','496.00','496.00','6',NULL,NULL,NULL,NULL,'08 May 2024','2024050812:04:11','%','0','20.00','no','0.00',NULL,'202405081204','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(151,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240508-000011','12:04:11 PM','2024 05 08','ladmin','1','  General','  Cash','496.00','496.00','7',NULL,NULL,NULL,NULL,'08 May 2024','2024050812:04:11','%','0','56.00','no','0.00',NULL,'202405081204','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(152,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240508-000011','12:04:11 PM','2024 05 08','ladmin','1','  General','  Cash','496.00','496.00','8',NULL,NULL,NULL,NULL,'08 May 2024','2024050812:04:11','%','0','250.00','no','0.00',NULL,'202405081204','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(153,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20240508-000011','12:04:11 PM','2024 05 08','ladmin','1','  General','  Cash','496.00','496.00','9',NULL,NULL,NULL,NULL,'08 May 2024','2024050812:04:11','%','0','170.00','no','0.00',NULL,'202405081204','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL);
INSERT INTO `billcount` (`_id`, `value`) VALUES (1,'0');
INSERT INTO `billnumber` (`_id`, `billnumber`, `total`, `user`, `date`, `paymentmethod`, `billtype`, `subtotal`, `taxtotal`, `roundoff`, `globaltaxtotal`, `billcount`, `datetimee_new`, `comments_sales`, `delivery_fee`, `packing_charges`, `loyalty_points`, `loyalty_amount`, `order_id`) VALUES (1,'20240315-000011','656.00','admin','2024 03 15','  Cash','  General','656.00','0.00','0.00','0.0','1','202403152008',NULL,NULL,NULL,NULL,NULL,NULL),(2,'20240315-000012','512.00','admin','2024 03 15','  Cash','  General','512.00','0.00','0.00','0.0','2','202403152008',NULL,NULL,NULL,NULL,NULL,NULL),(3,'20240315-000013','467.00','admin','2024 03 15','  Cash','  General','467.00','0.00','0.00','0.0','3','202403152009',NULL,NULL,NULL,NULL,NULL,NULL),(4,'20240328-000011','690.00','ladmin','2024 03 28','  Cash','  General','690.00','0.00','0.00','0.0','4','202403281353',NULL,NULL,NULL,NULL,NULL,NULL),(5,'20240328-000012','387.00','ladmin','2024 03 28','  Cash','  General','387.00','0.00','0.00','0.0','5','202403281353',NULL,NULL,NULL,NULL,NULL,NULL),(6,'20240328-000013','670.00','ladmin','2024 03 28','  Cash','  General','670.00','0.00','0.00','0.0','6','202403281355',NULL,NULL,NULL,NULL,NULL,NULL),(7,'20240328-000014','670.00','ladmin','2024 03 28','  Cash','  General','670.00','0.00','0.00','0.0','7','202403281355',NULL,NULL,NULL,NULL,NULL,NULL),(8,'20240328-000015','505.00','ladmin','2024 03 28','  Cash','  General','505.00','0.00','0.00','0.0','8','202403281359',NULL,NULL,NULL,NULL,NULL,NULL),(9,'20240328-000016','510.00','ladmin','2024 03 28','  Cash','  General','510.00','0.00','0.00','0.0','9','202403281359',NULL,NULL,NULL,NULL,NULL,NULL),(10,'20240403-000011','624.00','ladmin','2024 04 03','  Cash','  General','624.00','0.00','0.00','0.0','10','202404031509',NULL,NULL,NULL,NULL,NULL,NULL),(11,'20240403-000012','928.00','ladmin','2024 04 03','  Cash','  General','928.00','0.00','0.00','0.0','11','202404031509',NULL,NULL,NULL,NULL,NULL,NULL),(12,'20240403-000013','280.00','ladmin','2024 04 03','  Cash','  General','280.00','0.00','0.00','0.0','12','202404031519',NULL,NULL,NULL,NULL,NULL,NULL),(13,'20240403-000014','358.00','ladmin','2024 04 03','  Cash','  General','358.00','0.00','0.00','0.0','13','202404031521',NULL,NULL,NULL,NULL,NULL,NULL),(14,'20240403-000015','245.00','ladmin','2024 04 03','  Upiqr','  General','245.00','0.00','0.00','0.0','14','202404031523',NULL,NULL,NULL,NULL,NULL,NULL),(15,'20240414-000011','1024.00','ladmin','2024 04 14','  Cash','  General','1024.00','0.00','0.00','0.0','15','202404141148',NULL,NULL,NULL,NULL,NULL,NULL),(16,'20240414-000012','682.00','ladmin','2024 04 14','  Cash','  General','682.00','0.00','0.00','0.0','16','202404141148',NULL,NULL,NULL,NULL,NULL,NULL),(17,'20240414-000013','767.00','ladmin','2024 04 14','  Cash','  General','767.00','0.00','0.00','0.0','17','202404141154',NULL,NULL,NULL,NULL,NULL,NULL),(18,'20240414-000014','1093.00','ladmin','2024 04 14','  Upiqr','  General','1093.00','0.00','0.00','0.0','18','202404141212',NULL,NULL,NULL,NULL,NULL,NULL),(19,'20240414-000015','599.00','ladmin','2024 04 14','  Upiqr','  General','599.00','0.00','0.00','0.0','19','202404141213',NULL,NULL,NULL,NULL,NULL,NULL),(20,'20240414-000021','761.50','ladmin','2024 04 14','  Cash','  General','761.50','0.00','0.00','0.0','20','202404141220',NULL,NULL,NULL,NULL,NULL,NULL),(21,'20240414-000016','568.00','ladmin','2024 04 14','  Cash','  General','568.00','0.00','0.00','0.0','21','202404141220',NULL,NULL,NULL,NULL,NULL,NULL),(22,'20240414-000017','887.00','ladmin','2024 04 14','  Upiqr','  General','887.00','0.00','0.00','0.0','22','202404141242',NULL,NULL,NULL,NULL,NULL,NULL),(23,'20240414-000018','424.00','ladmin','2024 04 14','  Upiqr','  General','424.00','0.00','0.00','0.0','23','202404141243',NULL,NULL,NULL,NULL,NULL,NULL),(24,'20240506-000011','651.00','ladmin','2024 05 06','  Cash','  General','651.00','0.00','0.00','0.0','24','202405061348',NULL,NULL,NULL,NULL,NULL,NULL),(25,'20240506-000012','523.00','ladmin','2024 05 06','  Cash','  General','523.00','0.00','0.00','0.0','25','202405061349',NULL,NULL,NULL,NULL,NULL,NULL),(26,'20240506-000013','277.00','ladmin','2024 05 06','  Cash','  General','277.00','0.00','0.00','0.0','26','202405061916',NULL,NULL,NULL,NULL,NULL,NULL),(27,'20240508-000011','496.00','ladmin','2024 05 08','  Cash','  General','496.00','0.00','0.00','0.0','27','202405081204',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'beans kg',40),(2,'beet root kg',160),(3,'carrots kg',140),(4,'cauliflower kg',45),(5,'cucumbers kg',20),(6,'fig fruit kg',750),(7,'loreal color 90gms',76),(8,'nutella',340),(9,'onions big kg',40),(10,'sona masoori raw rice 1kg',56),(11,'tata urad dal whole white 1kg',750),(12,'onions big kg',20),(13,'potatoes kg',32),(14,'sona masoori raw rice 1kg',56),(15,'tata urad dal whole white 1kg',500),(16,'tata urad dal whole white 1kg',1500);
INSERT INTO `itemwiseorderlistitems` (`_id`, `itemno`, `itemname`, `sales`, `salespercentage`, `itemtotalquan`, `category`, `i_buying_price`, `mi_buying_price`, `i_cost_value`, `i_cost_percent`, `mi_cost_value`, `mi_cost_percent`, `barcode_value`) VALUES (1,'9','beans kg',40,2,'1','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'13','beet root kg',160,7,'5','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'7','carrots kg',140,6,'2','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'8','cauliflower kg',45,2,'1','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'11','cucumbers kg',20,1,'1','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'4','fig fruit kg',750,31,'3','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'12','loreal color 90gms',76,3,'1','personal care',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'3','nutella',340,14,'2','branded foods',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'14','onions big kg',40,2,'2','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'1','sona masoori raw rice 1kg',56,2,'1','rice whole grains',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'2','tata urad dal whole white 1kg',750,31,'3','dals pulses',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'14','onions big kg',20,1,'1','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'16','potatoes kg',32,1,'1','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'1','sona masoori raw rice 1kg',56,2,'1','rice whole grains',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'2','tata urad dal whole white 1kg',500,21,'2','dals pulses',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'2','tata urad dal whole white 1kg',1500,27,'6','dals pulses',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (1,'branded foods',340),(2,'dals pulses',750),(3,'fruits and vegetables',1195),(4,'personal care',76),(5,'rice whole grains',56),(6,'branded foods',340),(7,'dals pulses',500),(8,'fruits and vegetables',504),(9,'personal care',152),(10,'rice whole grains',56),(23,'None',200),(24,'branded foods',340),(25,'dals pulses',500),(26,'fruits and vegetables',1045),(27,'personal care',304),(28,'rice whole grains',56),(34,'branded foods',170),(35,'dals pulses',500),(36,'fruits and vegetables',1387),(37,'personal care',304),(38,'rice whole grains',112),(39,'beverages',66),(40,'branded foods',340),(41,'dals pulses',1500),(42,'fruits and vegetables',1816),(43,'personal care',1586),(44,'rice whole grains',224);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'ladmin',2417);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'ladmin',2417,100);
