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,'toor dal 1kg','1.0','179.00','179.00','Item',NULL,NULL,'no',NULL,NULL,'20230919-000011','09:34:12 PM','2023 09 19','ladmin','1','  General','  Cash','2409.00','2409.00','1',NULL,NULL,NULL,NULL,'19 Sep 2023','2023091921:34:12','%','0','179.00','no','0.00',NULL,'202309192134','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(2,'toor dal 2kg','1.0','355.00','355.00','Item',NULL,NULL,'no',NULL,NULL,'20230919-000011','09:34:12 PM','2023 09 19','ladmin','1','  General','  Cash','2409.00','2409.00','2',NULL,NULL,NULL,NULL,'19 Sep 2023','2023091921:34:12','%','0','355.00','no','0.00',NULL,'202309192134','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(3,'urad dal split 1kg','2.0','199.00','398.00','Item',NULL,NULL,'no',NULL,NULL,'20230919-000011','09:34:12 PM','2023 09 19','ladmin','1','  General','  Cash','2409.00','2409.00','3',NULL,NULL,NULL,NULL,'19 Sep 2023','2023091921:34:12','%','0','398.00','no','0.00',NULL,'202309192134','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(4,'urad gota whole 2kg','2.0','398.00','796.00','Item',NULL,NULL,'no',NULL,NULL,'20230919-000011','09:34:12 PM','2023 09 19','ladmin','1','  General','  Cash','2409.00','2409.00','4',NULL,NULL,NULL,NULL,'19 Sep 2023','2023091921:34:12','%','0','796.00','no','0.00',NULL,'202309192134','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(5,'urad dal whole 24mantra organic 1kg','1.0','272.00','272.00','Item',NULL,NULL,'no',NULL,NULL,'20230919-000011','09:34:12 PM','2023 09 19','ladmin','1','  General','  Cash','2409.00','2409.00','5',NULL,NULL,NULL,NULL,'19 Sep 2023','2023091921:34:12','%','0','272.00','no','0.00',NULL,'202309192134','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(6,'urad dal black split loose kg','1.0','200.00','200.00','Item',NULL,NULL,'no',NULL,NULL,'20230919-000011','09:34:12 PM','2023 09 19','ladmin','1','  General','  Cash','2409.00','2409.00','6',NULL,NULL,NULL,NULL,'19 Sep 2023','2023091921:34:12','%','0','200.00','no','0.00',NULL,'202309192134','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(7,'urad black split 500g','1.0','110.00','110.00','Item',NULL,NULL,'no',NULL,NULL,'20230919-000011','09:34:12 PM','2023 09 19','ladmin','1','  General','  Cash','2409.00','2409.00','7',NULL,NULL,NULL,NULL,'19 Sep 2023','2023091921:34:12','%','0','110.00','no','0.00',NULL,'202309192134','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(8,'urad gota whole 500g','1.0','99.00','99.00','Item',NULL,NULL,'no',NULL,NULL,'20230919-000011','09:34:12 PM','2023 09 19','ladmin','1','  General','  Cash','2409.00','2409.00','8',NULL,NULL,NULL,NULL,'19 Sep 2023','2023091921:34:12','%','0','99.00','no','0.00',NULL,'202309192134','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(9,'urad gota whole 500g','1.0','99.00','99.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','1',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','99.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(10,'urad dal split 2kg','1.0','394.00','394.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','2',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','394.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(11,'urad dal split 500g','1.0','99.00','99.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','3',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','99.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(12,'urad dal black split loose kg','1.0','200.00','200.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','4',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','200.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(13,'urad black split 500g','1.0','110.00','110.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','5',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','110.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(14,'urad gota whole 1kg','1.0','199.00','199.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','6',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','199.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(15,'toor dal 1kg','1.0','179.00','179.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','7',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','179.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(16,'toor dal 500g','1.0','90.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','8',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','90.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(17,'urad dal whole 24mantra organic 1kg','1.0','272.00','272.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','9',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','272.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(18,'toor dal 2kg','1.0','355.00','355.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','10',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','355.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(19,'urad dal split 1kg','1.0','199.00','199.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','11',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','199.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(20,'urad dal split loose kg','1.0','199.00','199.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','12',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','199.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(21,'rin powder 6kg','1.0','420.00','420.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','13',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','420.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(22,'tide plus 1kg','1.0','91.00','91.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','14',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','91.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(23,'tide 190gms','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','15',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','10.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(24,'ariel matic 1kg','1.0','218.00','218.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','16',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','218.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(25,'active wheel 500gms','1.0','22.00','22.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','17',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','22.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(26,'wheel powder','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','18',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','50.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(27,'tide plus 2kg','1.0','182.00','182.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','19',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','182.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(28,'rin powder 1kg','1.0','74.00','74.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','20',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','74.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(29,'ezee liqud 200gm','1.0','44.00','44.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','21',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','44.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(30,'ujala fabric 75ml','1.0','17.00','17.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','22',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','17.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(31,'tata tea bags 100dips','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','23',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','100.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'beverages','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(32,'tata tea agni250gm','1.0','58.00','58.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','24',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','58.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'beverages','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(33,'tata tea premium 100gm','1.0','34.00','34.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','25',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','34.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'beverages','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(34,'clinic all clr oil 150ml','1.0','82.00','82.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','26',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','82.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(35,'parachute oil 300ml','1.0','134.00','134.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','27',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','134.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(36,'parachute oil 170ml','1.0','78.00','78.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','28',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','78.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(37,'bajaj oil 200ml','1.0','113.00','113.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','29',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','113.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(38,'sunsilk 200ml','1.0','125.00','125.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','30',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','125.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(39,'coriander/dhania seeds 100g','1.0','39.00','39.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','31',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','39.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'masalas and spices','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(40,'coriander/dhania seeds 200g','1.0','78.00','78.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','32',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','78.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'masalas and spices','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(41,'red chilli 200g','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','33',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','65.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'masalas and spices','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(42,'jaggery powder 500g','1.0','59.00','59.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','34',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','59.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'salt and sugar','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(43,'jaggery cubes 500g','1.0','55.00','55.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','35',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','55.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'salt and sugar','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(44,'jaggery round 500g','1.0','29.00','29.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','36',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','29.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'salt and sugar','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(45,'jaggery round 1kg','1.0','58.00','58.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','37',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','58.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'salt and sugar','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(46,'sampradaayam palm crystals/thati kalakanda 150g','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','38',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','70.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'salt and sugar','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(47,'nandini paneer 1kg','1.0','290.00','290.00','Item',NULL,NULL,'no',NULL,NULL,'20230920-000011','02:49:27 PM','2023 09 20','ladmin','1','  General','  Cash','4990.00','4990.00','39',NULL,NULL,NULL,NULL,'20 Sep 2023','2023092014:49:27','%','0','290.00','no','0.00',NULL,'202309201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dairy products','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(48,'urad gota whole 1kg','3','199.00','597.00','Item',NULL,NULL,'no',NULL,NULL,'20240627-000011','11:39:31 PM','2024 06 27','admin','1','  General','  Zeta','4692.50','4692.50','1',NULL,NULL,NULL,NULL,'27 Jun 2024','2024062723:39:31','%','0','199.00','no','0.00',NULL,'202406272339','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin','0',NULL,'',NULL,'1194.00','','','','',NULL,'199.00'),(49,'urad gota whole 2kg','0.25','398.00','99.50','Item',NULL,NULL,'no',NULL,NULL,'20240627-000011','11:39:31 PM','2024 06 27','admin','1','  General','  Zeta','4692.50','4692.50','2',NULL,NULL,NULL,NULL,'27 Jun 2024','2024062723:39:31','%','0','398.00','no','0.00',NULL,'202406272339','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin','0',NULL,'',NULL,'99.50','','','','',NULL,'398.00'),(50,'parle rusk real elaichi 200g','5','25.00','125.00','Item',NULL,NULL,'no',NULL,NULL,'20240627-000011','11:39:31 PM','2024 06 27','admin','1','  General','  Zeta','4692.50','4692.50','3',NULL,NULL,NULL,NULL,'27 Jun 2024','2024062723:39:31','%','0','25.00','no','0.00',NULL,'202406272339','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'bread bakery and eggs','admin','madmin','0',NULL,'',NULL,'1990.00','','','','',NULL,'25.00'),(51,'surfexcel blue 70gm','1.0','76.00','76.00','Item',NULL,NULL,'no',NULL,NULL,'20240627-000011','11:39:31 PM','2024 06 27','admin','1','  General','  Zeta','4692.50','4692.50','4',NULL,NULL,NULL,NULL,'27 Jun 2024','2024062723:39:31','%','0','76.00','no','0.00',NULL,'202406272339','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','madmin','0',NULL,'',NULL,'398.00','','','','',NULL,'76.00'),(52,'surf excel 2kg','1.0','432.00','432.00','Item',NULL,NULL,'no',NULL,NULL,'20240627-000011','11:39:31 PM','2024 06 27','admin','1','  General','  Zeta','4692.50','4692.50','5',NULL,NULL,NULL,NULL,'27 Jun 2024','2024062723:39:31','%','0','432.00','no','0.00',NULL,'202406272339','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','madmin','0',NULL,'',NULL,'398.00','','','','',NULL,'432.00'),(53,'tata tea premium 50gm','1.0','178.00','178.00','Item',NULL,NULL,'no',NULL,NULL,'20240627-000011','11:39:31 PM','2024 06 27','admin','1','  General','  Zeta','4692.50','4692.50','6',NULL,NULL,NULL,NULL,'27 Jun 2024','2024062723:39:31','%','0','178.00','no','0.00',NULL,'202406272339','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'beverages','admin','madmin','0',NULL,'',NULL,'398.00','','','','',NULL,'178.00'),(54,'tata tea agni250gm','2.0','58.00','116.00','Item',NULL,NULL,'no',NULL,NULL,'20240627-000011','11:39:31 PM','2024 06 27','admin','1','  General','  Zeta','4692.50','4692.50','7',NULL,NULL,NULL,NULL,'27 Jun 2024','2024062723:39:31','%','0','116.00','no','0.00',NULL,'202406272339','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'beverages','admin','madmin','0',NULL,'',NULL,'796.00','','','','',NULL,'58.00'),(55,'tata tea gold 500gm','1.0','212.00','212.00','Item',NULL,NULL,'no',NULL,NULL,'20240627-000011','11:39:31 PM','2024 06 27','admin','1','  General','  Zeta','4692.50','4692.50','8',NULL,NULL,NULL,NULL,'27 Jun 2024','2024062723:39:31','%','0','212.00','no','0.00',NULL,'202406272339','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'beverages','admin','madmin','0',NULL,'',NULL,'398.00','','','','',NULL,'212.00'),(56,'gillete razor','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240627-000011','11:39:31 PM','2024 06 27','admin','1','  General','  Zeta','4692.50','4692.50','9',NULL,NULL,NULL,NULL,'27 Jun 2024','2024062723:39:31','%','0','20.00','no','0.00',NULL,'202406272339','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','admin','madmin','0',NULL,'',NULL,'398.00','','','','',NULL,'20.00'),(57,'pepsodent 300gm','1.0','104.00','104.00','Item',NULL,NULL,'no',NULL,NULL,'20240627-000011','11:39:31 PM','2024 06 27','admin','1','  General','  Zeta','4692.50','4692.50','10',NULL,NULL,NULL,NULL,'27 Jun 2024','2024062723:39:31','%','0','104.00','no','0.00',NULL,'202406272339','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','admin','madmin','0',NULL,'',NULL,'398.00','','','','',NULL,'104.00'),(58,'capsicum green kg','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240627-000011','11:39:31 PM','2024 06 27','admin','1','  General','  Zeta','4692.50','4692.50','11',NULL,NULL,NULL,NULL,'27 Jun 2024','2024062723:39:31','%','0','80.00','no','0.00',NULL,'202406272339','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin','0',NULL,'',NULL,'398.00','','','','',NULL,'80.00'),(59,'ladies finger kg','1.0','28.00','28.00','Item',NULL,NULL,'no',NULL,NULL,'20240627-000011','11:39:31 PM','2024 06 27','admin','1','  General','  Zeta','4692.50','4692.50','12',NULL,NULL,NULL,NULL,'27 Jun 2024','2024062723:39:31','%','0','28.00','no','0.00',NULL,'202406272339','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin','0',NULL,'',NULL,'398.00','','','','',NULL,'28.00'),(60,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240627-000011','11:39:31 PM','2024 06 27','admin','1','  General','  Zeta','4692.50','4692.50','13',NULL,NULL,NULL,NULL,'27 Jun 2024','2024062723:39:31','%','0','250.00','no','0.00',NULL,'202406272339','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin','0',NULL,'',NULL,'398.00','','','','',NULL,'250.00'),(61,'bullet kolam raw rice 1kg','1.0','67.00','67.00','Item',NULL,NULL,'no',NULL,NULL,'20240627-000011','11:39:31 PM','2024 06 27','admin','1','  General','  Zeta','4692.50','4692.50','14',NULL,NULL,NULL,NULL,'27 Jun 2024','2024062723:39:31','%','0','67.00','no','0.00',NULL,'202406272339','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice and whole grains','admin','madmin','0',NULL,'',NULL,'398.00','','','','',NULL,'67.00'),(62,'sona masoori raw rice 10kg','1.0','520.00','520.00','Item',NULL,NULL,'no',NULL,NULL,'20240627-000011','11:39:31 PM','2024 06 27','admin','1','  General','  Zeta','4692.50','4692.50','15',NULL,NULL,NULL,NULL,'27 Jun 2024','2024062723:39:31','%','0','520.00','no','0.00',NULL,'202406272339','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice and whole grains','admin','madmin','0',NULL,'',NULL,'398.00','','','','',NULL,'520.00'),(63,'mdh chicken powder 100g','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20240627-000011','11:39:31 PM','2024 06 27','admin','1','  General','  Zeta','4692.50','4692.50','16',NULL,NULL,NULL,NULL,'27 Jun 2024','2024062723:39:31','%','0','65.00','no','0.00',NULL,'202406272339','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'masalas and spices','admin','madmin','0',NULL,'',NULL,'398.00','','','','',NULL,'65.00'),(64,'coriander/dhania seeds 100g','1.0','39.00','39.00','Item',NULL,NULL,'no',NULL,NULL,'20240627-000011','11:39:31 PM','2024 06 27','admin','1','  General','  Zeta','4692.50','4692.50','17',NULL,NULL,NULL,NULL,'27 Jun 2024','2024062723:39:31','%','0','39.00','no','0.00',NULL,'202406272339','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'masalas and spices','admin','madmin','0',NULL,'',NULL,'398.00','','','','',NULL,'39.00'),(65,'red chilli 200g','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20240627-000011','11:39:31 PM','2024 06 27','admin','1','  General','  Zeta','4692.50','4692.50','18',NULL,NULL,NULL,NULL,'27 Jun 2024','2024062723:39:31','%','0','65.00','no','0.00',NULL,'202406272339','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'masalas and spices','admin','madmin','0',NULL,'',NULL,'398.00','','','','',NULL,'65.00'),(66,'aashirvad whole wheat atta 5kg','1.0','209.00','209.00','Item',NULL,NULL,'no',NULL,NULL,'20240627-000011','11:39:31 PM','2024 06 27','admin','1','  General','  Zeta','4692.50','4692.50','19',NULL,NULL,NULL,NULL,'27 Jun 2024','2024062723:39:31','%','0','209.00','no','0.00',NULL,'202406272339','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'flours and sooji','admin','madmin','0',NULL,'',NULL,'398.00','','','','',NULL,'209.00'),(67,'annapurna whole wheat atta 5kg','1.0','351.00','351.00','Item',NULL,NULL,'no',NULL,NULL,'20240627-000011','11:39:31 PM','2024 06 27','admin','1','  General','  Zeta','4692.50','4692.50','20',NULL,NULL,NULL,NULL,'27 Jun 2024','2024062723:39:31','%','0','351.00','no','0.00',NULL,'202406272339','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'flours and sooji','admin','madmin','0',NULL,'',NULL,'398.00','','','','',NULL,'351.00'),(68,'cashew 200gm','1.0','219.00','219.00','Item',NULL,NULL,'no',NULL,NULL,'20240627-000011','11:39:31 PM','2024 06 27','admin','1','  General','  Zeta','4692.50','4692.50','21',NULL,NULL,NULL,NULL,'27 Jun 2024','2024062723:39:31','%','0','219.00','no','0.00',NULL,'202406272339','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dry fruits','admin','madmin','0',NULL,'',NULL,'398.00','','','','',NULL,'219.00'),(69,'almond/badam 200gm','1.0','245.00','245.00','Item',NULL,NULL,'no',NULL,NULL,'20240627-000011','11:39:31 PM','2024 06 27','admin','1','  General','  Zeta','4692.50','4692.50','22',NULL,NULL,NULL,NULL,'27 Jun 2024','2024062723:39:31','%','0','245.00','no','0.00',NULL,'202406272339','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dry fruits','admin','madmin','0',NULL,'',NULL,'398.00','','','','',NULL,'245.00'),(70,'sugar 1kg','1.0','45.00','45.00','Item',NULL,NULL,'no',NULL,NULL,'20240627-000011','11:39:31 PM','2024 06 27','admin','1','  General','  Zeta','4692.50','4692.50','23',NULL,NULL,NULL,NULL,'27 Jun 2024','2024062723:39:31','%','0','45.00','no','0.00',NULL,'202406272339','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'salt and sugar','admin','madmin','0',NULL,'',NULL,'398.00','','','','',NULL,'45.00'),(71,'arogya dhan rock salt 1kg','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240627-000011','11:39:31 PM','2024 06 27','admin','1','  General','  Zeta','4692.50','4692.50','24',NULL,NULL,NULL,NULL,'27 Jun 2024','2024062723:39:31','%','0','35.00','no','0.00',NULL,'202406272339','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'salt and sugar','admin','madmin','0',NULL,'',NULL,'398.00','','','','',NULL,'35.00'),(72,'amul butter salted 500g','1.0','195.00','195.00','Item',NULL,NULL,'no',NULL,NULL,'20240627-000011','11:39:31 PM','2024 06 27','admin','1','  General','  Zeta','4692.50','4692.50','25',NULL,NULL,NULL,NULL,'27 Jun 2024','2024062723:39:31','%','0','195.00','no','0.00',NULL,'202406272339','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dairy products','admin','madmin','0',NULL,'',NULL,'398.00','','','','',NULL,'195.00'),(73,'nestle slim dahi curd 400g','4','65.00','260.00','Item',NULL,NULL,'no',NULL,NULL,'20240627-000011','11:39:31 PM','2024 06 27','admin','1','  General','  Zeta','4692.50','4692.50','26',NULL,NULL,NULL,NULL,'27 Jun 2024','2024062723:39:31','%','0','65.00','no','0.00',NULL,'202406272339','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dairy products','admin','madmin','0',NULL,'',NULL,'1592.00','','','','',NULL,'65.00'),(74,'amul taaza toned milk 1l','1.0','60.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20240627-000011','11:39:31 PM','2024 06 27','admin','1','  General','  Zeta','4692.50','4692.50','27',NULL,NULL,NULL,NULL,'27 Jun 2024','2024062723:39:31','%','0','60.00','no','0.00',NULL,'202406272339','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dairy products','admin','madmin','0',NULL,'',NULL,'398.00','','','','',NULL,'60.00'),(75,'moong dal 1kg','0.25','149.00','37.25','Item',NULL,NULL,'no',NULL,NULL,'20240627-000012','11:40:26 PM','2024 06 27','admin','1','  General','  Cash','37.25','37.25','28',NULL,NULL,NULL,NULL,'27 Jun 2024','2024062723:40:26','%','0','149.00','no','0.00',NULL,'202406272340','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'37.25','','','','',NULL,'149.00'),(76,'Akola Toor Dal','6.00','175.00','1050.00','Item',NULL,NULL,'no',NULL,NULL,'20240628-000011','01:36:40 PM','2024 06 28','admin','1','  Home delivery','  Upiqr','1050.00','1050.00','10',NULL,NULL,NULL,NULL,'28 Jun 2024','2024062813:36:40','%','0','1050.00','no','0.00',NULL,'202406281336','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'12346',NULL,'1050.00','','','','',NULL,'175.00'),(77,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240628-000012','01:44:31 PM','2024 06 28','admin','1','  General','  Cash','726.00','726.00','11',NULL,NULL,NULL,NULL,'28 Jun 2024','2024062813:44:31','%','0','56.00','no','0.00',NULL,'202406281344','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'1',NULL,'56.00','','','','',NULL,'56.00'),(78,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240628-000012','01:44:31 PM','2024 06 28','admin','1','  General','  Cash','726.00','726.00','12',NULL,NULL,NULL,NULL,'28 Jun 2024','2024062813:44:31','%','0','250.00','no','0.00',NULL,'202406281344','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin',NULL,NULL,'2',NULL,'250.00','','','','',NULL,'250.00'),(79,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20240628-000012','01:44:31 PM','2024 06 28','admin','1','  General','  Cash','726.00','726.00','13',NULL,NULL,NULL,NULL,'28 Jun 2024','2024062813:44:31','%','0','170.00','no','0.00',NULL,'202406281344','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin',NULL,NULL,'3',NULL,'170.00','','','','',NULL,'170.00'),(80,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240628-000012','01:44:31 PM','2024 06 28','admin','1','  General','  Cash','726.00','726.00','14',NULL,NULL,NULL,NULL,'28 Jun 2024','2024062813:44:31','%','0','250.00','no','0.00',NULL,'202406281344','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'4',NULL,'250.00','','','','',NULL,'250.00'),(81,'urad gota whole 500g','1.0','99.00','99.00','Item',NULL,NULL,'no',NULL,NULL,'20240628-000012','04:33:24 PM','2024 06 28','admin','1','  General','  Cash','792.00','792.00','34',NULL,NULL,NULL,NULL,'28 Jun 2024','2024062816:33:24','%','0','99.00','no','0.00',NULL,'202406281633','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'99.00','','','','',NULL,'99.00'),(82,'urad dal split 2kg','1.0','394.00','394.00','Item',NULL,NULL,'no',NULL,NULL,'20240628-000012','04:33:24 PM','2024 06 28','admin','1','  General','  Cash','792.00','792.00','35',NULL,NULL,NULL,NULL,'28 Jun 2024','2024062816:33:24','%','0','394.00','no','0.00',NULL,'202406281633','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'394.00','','','','',NULL,'394.00'),(83,'rin powder 1kg','1.0','116','116.00','Item',NULL,NULL,'no',NULL,NULL,'20240704-000011','06:24:33 PM','2024 07 04','admin','1','  General','  Cash','110','110','8',NULL,NULL,NULL,NULL,'04 Jul 2024','2024070418:24:33','₹','6','110.00','yes','6.00',NULL,'202407041824','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','madmin',NULL,NULL,'95',NULL,'110.00','','','','',NULL,'110.00'),(84,'Mysore Sandal Trio Pack','1.0','243.00','243.00','Item',NULL,NULL,'no',NULL,NULL,'20240704-000012','09:25:19 PM','2024 07 04','admin','1','  General','  Cash','231','231','16',NULL,NULL,NULL,NULL,'04 Jul 2024','2024070421:25:19','%','5','230.85','yes','12.15',NULL,'202407042125','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','admin','madmin',NULL,NULL,'8901287100518',NULL,'243.00','','','','',NULL,'243.00'),(85,'3roses Natural care 100g','1.0','97.00','97.00','Item',NULL,NULL,'no',NULL,NULL,'20240705-000011','02:23:52 PM','2024 07 05','admin','1','  General','  Cash','362.00','362.00','1',NULL,NULL,NULL,NULL,'05 Jul 2024','2024070514:23:52','%','0','97.00','no','0.00',NULL,'202407051423','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'8901030000000',NULL,'97.00','','','','',NULL,'97.00'),(86,'Brooke Bond Red Label Natural Care 250 Gm','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20240705-000011','02:23:52 PM','2024 07 05','admin','1','  General','  Cash','362.00','362.00','2',NULL,NULL,NULL,NULL,'05 Jul 2024','2024070514:23:52','%','0','170.00','no','0.00',NULL,'202407051423','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'8901030000000',NULL,'170.00','','','','',NULL,'170.00'),(87,'Modi [D] [Mainpk] 250Gm Pph Premium Strong Dust 100% Natural Assam Tea','1.0','95.00','95.00','Item',NULL,NULL,'no',NULL,NULL,'20240705-000011','02:23:52 PM','2024 07 05','admin','1','  General','  Cash','362.00','362.00','3',NULL,NULL,NULL,NULL,'05 Jul 2024','2024070514:23:52','%','0','95.00','no','0.00',NULL,'202407051423','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'8906050000000',NULL,'95.00','','','','',NULL,'95.00'),(88,'Cycle bathi','1.0','18.00','18.00','Item',NULL,NULL,'no',NULL,NULL,'20240705-000012','02:43:24 PM','2024 07 05','admin','1','  General','  Cash','121.00','121.00','1',NULL,NULL,NULL,NULL,'05 Jul 2024','2024070514:43:24','%','0','18.00','no','0.00',NULL,'202407051443','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Agarbathi And Other Pooja Items','admin','madmin',NULL,NULL,'8901750000000',NULL,NULL,'','','','',NULL,NULL),(89,'Dantkanti Red Paste','1.0','9.00','9.00','Item',NULL,NULL,'no',NULL,NULL,'20240705-000012','02:43:24 PM','2024 07 05','admin','1','  General','  Cash','121.00','121.00','2',NULL,NULL,NULL,NULL,'05 Jul 2024','2024070514:43:24','%','0','9.00','no','0.00',NULL,'202407051443','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tooth Paste & Gels','admin','madmin',NULL,NULL,'8904110000000',NULL,NULL,'','','','',NULL,NULL),(90,'Dettol hand wash','1.0','94.00','94.00','Item',NULL,NULL,'no',NULL,NULL,'20240705-000012','02:43:24 PM','2024 07 05','admin','1','  General','  Cash','121.00','121.00','3',NULL,NULL,NULL,NULL,'05 Jul 2024','2024070514:43:24','%','0','94.00','no','0.00',NULL,'202407051443','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand wash & Sanitizers','admin','madmin',NULL,NULL,'8901400000000',NULL,NULL,'','','','',NULL,NULL),(91,'chikki bar box 24pk','1.0','110.00','110.00','Item',NULL,NULL,'no',NULL,NULL,'20240705-000013','08:26:42 PM','2024 07 05','admin','1','  General','  Cash','2278.50','2278.50','1',NULL,NULL,NULL,NULL,'05 Jul 2024','2024070520:26:42','%','0','110.00','no','0.00',NULL,'202407052026','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Mouth freshners','admin','madmin',NULL,NULL,'8904000000000',NULL,'110.00','','','','',NULL,'110.00'),(92,'crane','1.0','57.00','57.00','Item',NULL,NULL,'no',NULL,NULL,'20240705-000013','08:26:42 PM','2024 07 05','admin','1','  General','  Cash','2278.50','2278.50','2',NULL,NULL,NULL,NULL,'05 Jul 2024','2024070520:26:42','%','0','57.00','no','0.00',NULL,'202407052026','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Mouth freshners','admin','madmin',NULL,NULL,'8908000000000',NULL,'57.00','','','','',NULL,'57.00'),(93,'crane pkt rs1','1.0','55.00','55.00','Item',NULL,NULL,'no',NULL,NULL,'20240705-000013','08:26:42 PM','2024 07 05','admin','1','  General','  Cash','2278.50','2278.50','3',NULL,NULL,NULL,NULL,'05 Jul 2024','2024070520:26:42','%','0','55.00','no','0.00',NULL,'202407052026','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Mouth freshners','admin','madmin',NULL,NULL,'8908000000000',NULL,'55.00','','','','',NULL,'55.00'),(94,'Himalaya Baby Lotion 100 Ml','1.0','105.00','105.00','Item',NULL,NULL,'no',NULL,NULL,'20240705-000013','08:26:42 PM','2024 07 05','admin','1','  General','  Cash','2278.50','2278.50','4',NULL,NULL,NULL,NULL,'05 Jul 2024','2024070520:26:42','%','0','105.00','no','0.00',NULL,'202407052026','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Baby Products Others','admin','madmin',NULL,NULL,'8901140000000',NULL,'105.00','','','','',NULL,'105.00'),(95,'Himalaya Baby Powder 100 Gms','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240705-000013','08:26:42 PM','2024 07 05','admin','1','  General','  Cash','2278.50','2278.50','5',NULL,NULL,NULL,NULL,'05 Jul 2024','2024070520:26:42','%','0','100.00','no','0.00',NULL,'202407052026','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Baby Products Others','admin','madmin',NULL,NULL,'8901140000000',NULL,'100.00','','','','',NULL,'100.00'),(96,'Himalaya Baby Lotion 200 Ml','1.0','150.00','150.00','Item',NULL,NULL,'no',NULL,NULL,'20240705-000013','08:26:42 PM','2024 07 05','admin','1','  General','  Cash','2278.50','2278.50','6',NULL,NULL,NULL,NULL,'05 Jul 2024','2024070520:26:42','%','0','150.00','no','0.00',NULL,'202407052026','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Baby Products Others','admin','madmin',NULL,NULL,'8901140000000',NULL,'150.00','','','','',NULL,'150.00'),(97,'Himalaya Baby Powder 50Gms','1.0','48.00','48.00','Item',NULL,NULL,'no',NULL,NULL,'20240705-000013','08:26:42 PM','2024 07 05','admin','1','  General','  Cash','2278.50','2278.50','7',NULL,NULL,NULL,NULL,'05 Jul 2024','2024070520:26:42','%','0','48.00','no','0.00',NULL,'202407052026','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Baby Products Others','admin','madmin',NULL,NULL,'8901140000000',NULL,'48.00','','','','',NULL,'48.00'),(98,'shashi powder','1.0','14.00','14.00','Item',NULL,NULL,'no',NULL,NULL,'20240705-000013','08:26:42 PM','2024 07 05','admin','1','  General','  Cash','2278.50','2278.50','8',NULL,NULL,NULL,NULL,'05 Jul 2024','2024070520:26:42','%','0','14.00','no','0.00',NULL,'202407052026','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Utensil And Kitchen Cleaners','admin','madmin',NULL,NULL,'8906030000000',NULL,'14.00','','','','',NULL,'14.00'),(99,'vim bar antismell','1.0','9.50','9.50','Item',NULL,NULL,'no',NULL,NULL,'20240705-000013','08:26:42 PM','2024 07 05','admin','1','  General','  Cash','2278.50','2278.50','9',NULL,NULL,NULL,NULL,'05 Jul 2024','2024070520:26:42','%','0','9.50','no','0.00',NULL,'202407052026','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Utensil And Kitchen Cleaners','admin','madmin',NULL,NULL,'8901030000000',NULL,'9.50','','','','',NULL,'9.50'),(100,'Ariel Matic FL 3.2L','1.0','690.00','690.00','Item',NULL,NULL,'no',NULL,NULL,'20240705-000013','08:26:42 PM','2024 07 05','admin','1','  General','  Cash','2278.50','2278.50','10',NULL,NULL,NULL,NULL,'05 Jul 2024','2024070520:26:42','%','0','690.00','no','0.00',NULL,'202407052026','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Detergent Liquids','admin','madmin',NULL,NULL,'4987180000000',NULL,'690.00','','','','',NULL,'690.00'),(101,'Ariel Liquid FL 2L','1.0','460.00','460.00','Item',NULL,NULL,'no',NULL,NULL,'20240705-000013','08:26:42 PM','2024 07 05','admin','1','  General','  Cash','2278.50','2278.50','11',NULL,NULL,NULL,NULL,'05 Jul 2024','2024070520:26:42','%','0','460.00','no','0.00',NULL,'202407052026','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Detergent Liquids','admin','madmin',NULL,NULL,'4987180000000',NULL,'460.00','','','','',NULL,'460.00'),(102,'Ariel Liquid TL 2.5L','1.0','480.00','480.00','Item',NULL,NULL,'no',NULL,NULL,'20240705-000013','08:26:42 PM','2024 07 05','admin','1','  General','  Cash','2278.50','2278.50','12',NULL,NULL,NULL,NULL,'05 Jul 2024','2024070520:26:42','%','0','480.00','no','0.00',NULL,'202407052026','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Detergent Liquids','admin','madmin',NULL,NULL,'4987180000000',NULL,'480.00','','','','',NULL,'480.00'),(103,'AKola toor dal phatka','1.0','175.00','175.00','Item',NULL,NULL,'no',NULL,NULL,'20240705-000014','08:44:48 PM','2024 07 05','admin','1','  General','  Cash','1599.00','1599','13',NULL,NULL,NULL,NULL,'05 Jul 2024','2024070520:44:48','₹','05','170.00','yes','5.00',NULL,'202407052044','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dals & Pulses','admin','madmin',NULL,NULL,'1',NULL,'18.00','','','','',NULL,'175.00'),(104,'Akola 2kg','1.0','150.00','150.00','Item',NULL,NULL,'no',NULL,NULL,'20240705-000014','08:44:48 PM','2024 07 05','admin','1','  General','  Cash','1599.00','1599','14',NULL,NULL,NULL,NULL,'05 Jul 2024','2024070520:44:48','%','0','150.00','no','0.00',NULL,'202407052044','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dals & Pulses','admin','madmin',NULL,NULL,'5048',NULL,'18.00','','','','',NULL,'150.00'),(105,'Akola 3kg','2.0','225.00','450.00','Item',NULL,NULL,'no',NULL,NULL,'20240705-000014','08:44:48 PM','2024 07 05','admin','1','  General','  Cash','1599.00','1599','15',NULL,NULL,NULL,NULL,'05 Jul 2024','2024070520:44:48','%','0','450.00','no','0.00',NULL,'202407052044','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dals & Pulses','admin','madmin',NULL,NULL,'5050',NULL,'36.00','','','','',NULL,'225.00'),(106,'Akola 4kg','1.0','300.00','300.00','Item',NULL,NULL,'no',NULL,NULL,'20240705-000014','08:44:48 PM','2024 07 05','admin','1','  General','  Cash','1599.00','1599','16',NULL,NULL,NULL,NULL,'05 Jul 2024','2024070520:44:48','%','0','300.00','no','0.00',NULL,'202407052044','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dals & Pulses','admin','madmin',NULL,NULL,'5051',NULL,'18.00','','','','',NULL,'300.00'),(107,'Akola 500g','1.0','33.00','33.00','Item',NULL,NULL,'no',NULL,NULL,'20240705-000014','08:44:48 PM','2024 07 05','admin','1','  General','  Cash','1599.00','1599','17',NULL,NULL,NULL,NULL,'05 Jul 2024','2024070520:44:48','%','0','33.00','no','0.00',NULL,'202407052044','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dals & Pulses','admin','madmin',NULL,NULL,'5059',NULL,'18.00','','','','',NULL,'33.00'),(108,'Akola 5kg','1.0','375.00','375.00','Item',NULL,NULL,'no',NULL,NULL,'20240705-000014','08:44:48 PM','2024 07 05','admin','1','  General','  Cash','1599.00','1599','18',NULL,NULL,NULL,NULL,'05 Jul 2024','2024070520:44:48','%','0','375.00','no','0.00',NULL,'202407052044','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dals & Pulses','admin','madmin',NULL,NULL,'5049',NULL,'18.00','','','','',NULL,'375.00'),(109,'Cycle bathi','1.0','20','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240705-000014','08:44:48 PM','2024 07 05','admin','1','  General','  Cash','1599.00','1599','19',NULL,NULL,NULL,NULL,'05 Jul 2024','2024070520:44:48','%','10','18.00','yes','2.00',NULL,'202407052044','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Agarbathi And Other Pooja Items','admin','madmin',NULL,NULL,'8901750000000',NULL,'18.00','','','','',NULL,'18.00'),(110,'Dantkanti Red Paste','1.0','9.00','9.00','Item',NULL,NULL,'no',NULL,NULL,'20240705-000014','08:44:48 PM','2024 07 05','admin','1','  General','  Cash','1599.00','1599','20',NULL,NULL,NULL,NULL,'05 Jul 2024','2024070520:44:48','%','0','9.00','no','0.00',NULL,'202407052044','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tooth Paste & Gels','admin','madmin',NULL,NULL,'8904110000000',NULL,'18.00','','','','',NULL,'9.00'),(111,'Dettol hand wash','1.0','94.00','94.00','Item',NULL,NULL,'no',NULL,NULL,'20240705-000014','08:44:48 PM','2024 07 05','admin','1','  General','  Cash','1599.00','1599','21',NULL,NULL,NULL,NULL,'05 Jul 2024','2024070520:44:48','%','0','94.00','no','0.00',NULL,'202407052044','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand wash & Sanitizers','admin','madmin',NULL,NULL,'8901400000000',NULL,'18.00','','','','',NULL,'94.00'),(112,'Dettol hand wash','1.0','94.00','94.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000012','01:30:20 PM','2024 07 08','admin','1','  General','  Cash','2756','2756','18',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070813:30:20','%','0','94.00','no','0.00',NULL,'202407081330','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand wash & Sanitizers','admin','madmin',NULL,NULL,'8901400000000',NULL,NULL,'','','','',NULL,NULL),(113,'Makhana','1.0','210.00','210.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000012','01:30:20 PM','2024 07 08','admin','1','  General','  Cash','2756','2756','19',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070813:30:20','%','0','210.00','no','0.00',NULL,'202407081330','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Miscellaneous','admin','madmin',NULL,NULL,'8906120000000',NULL,NULL,'','','','',NULL,NULL),(114,'Pastiano pasta 500g','1.0','36.00','36.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000012','01:30:20 PM','2024 07 08','admin','1','  General','  Cash','2756','2756','20',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070813:30:20','%','0','36.00','no','0.00',NULL,'202407081330','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Miscellaneous','admin','madmin',NULL,NULL,'8908010000000',NULL,NULL,'','','','',NULL,NULL),(115,'oral b','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000012','01:30:20 PM','2024 07 08','admin','1','  General','  Cash','2756','2756','21',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070813:30:20','%','0','40.00','no','0.00',NULL,'202407081330','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tooth Brush','admin','madmin',NULL,NULL,'4902430000000',NULL,NULL,'','','','',NULL,NULL),(116,'essence','1.0','48.00','48.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000012','01:30:20 PM','2024 07 08','admin','1','  General','  Cash','2756','2756','22',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070813:30:20','%','0','48.00','no','0.00',NULL,'202407081330','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'8906050000000',NULL,NULL,'','','','',NULL,NULL),(117,'Sriphal dhoop sticks','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000012','01:30:20 PM','2024 07 08','admin','1','  General','  Cash','2756','2756','23',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070813:30:20','%','0','20.00','no','0.00',NULL,'202407081330','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Agarbathi And Other Pooja Items','admin','madmin',NULL,NULL,'8906090000000',NULL,NULL,'','','','',NULL,NULL),(118,'Sarguna Salt Refined Free Flow Iodised salt 1kg','1.0','15.00','15.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000012','01:30:20 PM','2024 07 08','admin','1','  General','  Cash','2756','2756','24',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070813:30:20','%','0','15.00','no','0.00',NULL,'202407081330','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Salt Sugar & Jaggery','admin','madmin',NULL,NULL,'8908000000000',NULL,NULL,'','','','',NULL,NULL),(119,'Power Papaya Aura soap','1.0','43.00','43.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000012','01:30:20 PM','2024 07 08','admin','1','  General','  Cash','2756','2756','25',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070813:30:20','%','0','43.00','no','0.00',NULL,'202407081330','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bathing soaps & Gels','admin','madmin',NULL,NULL,'8906000000000',NULL,NULL,'','','','',NULL,NULL),(120,'star papad','1.0','16.00','16.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000012','01:30:20 PM','2024 07 08','admin','1','  General','  Cash','2756','2756','26',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070813:30:20','%','0','16.00','no','0.00',NULL,'202407081330','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Miscellaneous','admin','madmin',NULL,NULL,'9677810000000000',NULL,NULL,'','','','',NULL,NULL),(121,'vim bar','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000012','01:30:20 PM','2024 07 08','admin','1','  General','  Cash','2756','2756','27',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070813:30:20','%','0','10.00','no','0.00',NULL,'202407081330','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Utensil And Kitchen Cleaners','admin','madmin',NULL,NULL,'8901030000000',NULL,NULL,'','','','',NULL,NULL),(122,'2 X Spinz Talc Exotic Refreshing Bouquet Of Mild Floral Fragrances Talcum Powder 50G X 2 = 100Gm','1.0','33.00','33.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000012','01:30:20 PM','2024 07 08','admin','1','  General','  Cash','2756','2756','28',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070813:30:20','%','0','33.00','no','0.00',NULL,'202407081330','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Talcum Powder','admin','madmin',NULL,NULL,'8902980000000',NULL,NULL,'','','','',NULL,NULL),(123,'20-20 Butter Cookies','1.0','5.00','5.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000012','01:30:20 PM','2024 07 08','admin','1','  General','  Cash','2756','2756','29',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070813:30:20','%','0','5.00','no','0.00',NULL,'202407081330','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Biscuits','admin','madmin',NULL,NULL,'8901720000000',NULL,NULL,'','','','',NULL,NULL),(124,'20-20 Butter Cookies84G+12G=96Gm','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000012','01:30:20 PM','2024 07 08','admin','1','  General','  Cash','2756','2756','30',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070813:30:20','%','0','10.00','no','0.00',NULL,'202407081330','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Biscuits','admin','madmin',NULL,NULL,'8901720000000',NULL,NULL,'','','','',NULL,NULL),(125,'31Gold Rice Bag 26kg','1.0','1650.00','1650.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000012','01:30:20 PM','2024 07 08','admin','1','  General','  Cash','2756','2756','31',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070813:30:20','%','0','1650.00','no','0.00',NULL,'202407081330','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Rice Puffed Rice & Poha','admin','madmin',NULL,NULL,'16454',NULL,NULL,'','','','',NULL,NULL),(126,'3 Roses Tea 250G','1.0','215.00','215.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000012','01:30:20 PM','2024 07 08','admin','1','  General','  Cash','2756','2756','32',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070813:30:20','%','0','215.00','no','0.00',NULL,'202407081330','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'8901030000000',NULL,NULL,'','','','',NULL,NULL),(127,'3 Roses Tea 250 Gm Carton','1.0','214.00','214.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000012','01:30:20 PM','2024 07 08','admin','1','  General','  Cash','2756','2756','33',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070813:30:20','%','0','214.00','no','0.00',NULL,'202407081330','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'8901030000000',NULL,NULL,'','','','',NULL,NULL),(128,'24 Carat Agarbathi','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000012','01:30:20 PM','2024 07 08','admin','1','  General','  Cash','2756','2756','34',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070813:30:20','%','0','50.00','no','0.00',NULL,'202407081330','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Agarbathi And Other Pooja Items','admin','madmin',NULL,NULL,'8923010000000',NULL,NULL,'','','','',NULL,NULL),(129,'20-20 gold','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000012','01:30:20 PM','2024 07 08','admin','1','  General','  Cash','2756','2756','35',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070813:30:20','%','0','20.00','no','0.00',NULL,'202407081330','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bread & Baked Foods','admin','madmin',NULL,NULL,'8901720000000',NULL,NULL,'','','','',NULL,NULL),(130,'vim bar','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000013','01:31:22 PM','2024 07 08','admin','1','  General','  Cash','84','84','36',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070813:31:22','%','0','10.00','no','0.00',NULL,'202407081331','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Utensil And Kitchen Cleaners','admin','madmin',NULL,NULL,'8901030000000',NULL,NULL,'','','','',NULL,NULL),(131,'star papad','1.0','16.00','16.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000013','01:31:22 PM','2024 07 08','admin','1','  General','  Cash','84','84','37',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070813:31:22','%','0','16.00','no','0.00',NULL,'202407081331','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Miscellaneous','admin','madmin',NULL,NULL,'9677810000000000',NULL,NULL,'','','','',NULL,NULL),(132,'Power Papaya Aura soap','1.0','43.00','43.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000013','01:31:22 PM','2024 07 08','admin','1','  General','  Cash','84','84','38',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070813:31:22','%','0','43.00','no','0.00',NULL,'202407081331','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bathing soaps & Gels','admin','madmin',NULL,NULL,'8906000000000',NULL,NULL,'','','','',NULL,NULL),(133,'Sarguna Salt Refined Free Flow Iodised salt 1kg','1.0','15.00','15.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000013','01:31:22 PM','2024 07 08','admin','1','  General','  Cash','84','84','39',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070813:31:22','%','0','15.00','no','0.00',NULL,'202407081331','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Salt Sugar & Jaggery','admin','madmin',NULL,NULL,'8908000000000',NULL,NULL,'','','','',NULL,NULL),(134,'Makhana','1.0','210.00','210.00','Item',NULL,NULL,'no',NULL,NULL,'20240729-000011','11:57:51 AM','2024 07 29','admin','1','  General','  Cash','210','210','41',NULL,NULL,NULL,NULL,'29 Jul 2024','2024072911:57:51','%','0','210.00','no','0.00',NULL,'202407291157','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Miscellaneous','admin','madmin',NULL,NULL,'8906120000000',NULL,'210.00','','','','',NULL,'210.00'),(135,'Xxx 250 Gm Plwrp Ruf-N-Tuf Anti Bactrl Wt Lime Power Dish Wash Shine','5','22.00','110.00','Item',NULL,NULL,'no',NULL,NULL,'20240811-000011','09:02:03 PM','2024 08 11','admin','1','  General','  Cash','562','562','43',NULL,NULL,NULL,NULL,'11 Aug 2024','2024081121:02:03','%','0','22.00','no','0.00',NULL,'202408112102','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Utensil And Kitchen Cleaners','admin','madmin',NULL,NULL,'8906060000000',NULL,'750.00','','','','',NULL,'22.00'),(136,'citrus plus','6','10.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20240811-000011','09:02:03 PM','2024 08 11','admin','1','  General','  Cash','562','562','44',NULL,NULL,NULL,NULL,'11 Aug 2024','2024081121:02:03','%','0','10.00','no','0.00',NULL,'202408112102','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Utensil And Kitchen Cleaners','admin','madmin',NULL,NULL,'8901130000000',NULL,'900.00','','','','',NULL,'10.00'),(137,'Aachi Chicken Masala 100 Gms','1.0','48.00','48.00','Item',NULL,NULL,'no',NULL,NULL,'20240811-000011','09:02:03 PM','2024 08 11','admin','1','  General','  Cash','562','562','45',NULL,NULL,NULL,NULL,'11 Aug 2024','2024081121:02:03','%','0','48.00','no','0.00',NULL,'202408112102','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Masala & Spices','admin','madmin',NULL,NULL,'8906020000000',NULL,'150.00','','','','',NULL,'48.00'),(138,'AKola toor dal phatka','0.25','175.00','43.75','Item',NULL,NULL,'no',NULL,NULL,'20240811-000011','09:02:03 PM','2024 08 11','admin','1','  General','  Cash','562','562','46',NULL,NULL,NULL,NULL,'11 Aug 2024','2024081121:02:03','%','0','175.00','no','0.00',NULL,'202408112102','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dals & Pulses','admin','madmin',NULL,NULL,'1',NULL,'37.50','','','','',NULL,'175.00'),(139,'Akola 2kg','2.0','150.00','300.00','Item',NULL,NULL,'no',NULL,NULL,'20240811-000011','09:02:03 PM','2024 08 11','admin','1','  General','  Cash','562','562','47',NULL,NULL,NULL,NULL,'11 Aug 2024','2024081121:02:03','%','0','150.00','no','0.00',NULL,'202408112102','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dals & Pulses','admin','madmin',NULL,NULL,'5048',NULL,'300.00','','','','',NULL,'150.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,'20230919-000011','2409.00','ladmin','2023 09 19','  Cash','  General','2409.00','0.00','0.00','0.0','1','202309192134',NULL,NULL,NULL,NULL,NULL,NULL),(2,'20230920-000011','4990.00','ladmin','2023 09 20','  Cash','  General','4990.00','0.00','0.00','0.0','2','202309201449',NULL,NULL,NULL,NULL,NULL,NULL),(3,'20240627-000011','4692.50','admin','2024 06 27','  Zeta','  General','4692.50','0.00','0.00','0.0','1','202406272339',NULL,NULL,NULL,NULL,NULL,NULL),(4,'20240627-000012','37.25','admin','2024 06 27','  Cash','  General','37.25','0.00','0.00','0.0','2','202406272340',NULL,NULL,NULL,NULL,NULL,NULL),(5,'20240628-000011','1050.00','admin','2024 06 28','  Upiqr','  Home delivery','1050.00','0.00','0.00','0.0','3','202406281336',NULL,NULL,NULL,NULL,NULL,NULL),(6,'20240628-000012','726.00','admin','2024 06 28','  Cash','  General','726.00','0.00','0.00','0.0','_4','202406281344',NULL,NULL,NULL,NULL,NULL,NULL),(7,'20240628-000013','10.00','admin','2024 06 28','  Upiqr','  General','10.00','0.00','0.00','0.0','_5','202406281839',NULL,NULL,NULL,NULL,NULL,NULL),(8,'20240704-000011','110','admin','2024 07 04','  Cash','  General','110.00','0.00','+ 0.00','0.0','_6','202407041824',NULL,NULL,NULL,NULL,NULL,NULL),(9,'20240704-000012','231','admin','2024 07 04','  Cash','  General','230.85','0.00','+ 0.15','0.0','_7','202407042125',NULL,NULL,NULL,NULL,NULL,NULL),(10,'20240705-000011','362.00','admin','2024 07 05','  Cash','  General','362.00','0.00','0.00','0.0','_8','202407051423',NULL,NULL,NULL,NULL,NULL,NULL),(11,'20240705-000012','121.00','admin','2024 07 05','  Cash','  General','121.00','0.00','0.00','0.0','_9','202407051443',NULL,NULL,NULL,NULL,NULL,NULL),(12,'20240705-000013','2278.50','admin','2024 07 05','  Cash','  General','2278.50','0.00','0.00','0.0','_10','202407052026',NULL,NULL,NULL,NULL,NULL,NULL),(13,'20240705-000014','1599.00','admin','2024 07 05','  Cash','  General','1599.00','0.00','+ 0.00','0.0','_11','202407052044',NULL,NULL,NULL,NULL,NULL,NULL),(14,'20240708-000011','190.00','admin','2024 07 08','  Cash','  General','190.00','0.00','+ 0.00','0.0','_12','202407081329',NULL,NULL,NULL,NULL,NULL,NULL),(15,'20240708-000012','2756.00','admin','2024 07 08','  Cash','  General','2756.00','0.00','+ 0.00','0.0','_13','202407081330',NULL,NULL,NULL,NULL,NULL,NULL),(16,'20240708-000013','84.00','admin','2024 07 08','  Cash','  General','84.00','0.00','+ 0.00','0.0','_14','202407081331',NULL,NULL,NULL,NULL,NULL,NULL),(17,'20240729-000011','210','admin','2024 07 29','  Cash','  General','210.00','0.00','+ 0.00','0.0','_15','202407291157',NULL,NULL,NULL,NULL,NULL,NULL),(18,'20240811-000011','562','admin','2024 08 11','  Cash','  General','561.75','0.00','+ 0.25','0.0','_16','202408112102',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,'uday ','8465840542','uday4652@gmail.com','',726,'0.0',NULL,NULL,NULL);
INSERT INTO `customer_loyalty_points` (`_id`, `phoneno`, `points`) VALUES (1,'9989063828','15.99');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'Akola Toor Dal',1050),(2,'fig fruit kg',250),(3,'nutella',170),(4,'sona masoori raw rice 1kg',56),(5,'tata urad dal whole white 1kg',250);
INSERT INTO `itemwiseorderlistitems` (`_id`, `itemno`, `itemname`, `sales`, `salespercentage`, `itemtotalquan`, `category`, `i_buying_price`, `mi_buying_price`, `i_cost_value`, `i_cost_percent`, `mi_cost_value`, `mi_cost_percent`, `barcode_value`) VALUES (1,'1599','Akola Toor Dal',1050,100,'6','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'4','fig fruit kg',250,14,'1','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'3','nutella',170,10,'1','branded foods',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'1','sona masoori raw rice 1kg',56,3,'1','rice whole grains',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'2','tata urad dal whole white 1kg',250,14,'1','dals pulses',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (1,'None',1050),(2,'None',1050),(3,'branded foods',170),(4,'dals pulses',250),(5,'fruits and vegetables',250),(6,'rice whole grains',56),(9,'household',116),(10,'personal care',243);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',1050);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',1050,100);
