INSERT INTO `all_sales_cancelled` (`_id`, `itemname`, `quantity`, `price`, `total`, `type`, `parent`, `parentid`, `mod_assigned`, `tax`, `taxname`, `bill_no`, `time`, `date`, `user`, `billtype`, `paymentmethod`, `billamount_disapply`, `billamount_disnotapply`, `_idd`, `reason`, `billamount_cancelled`, `date1`, `billamount_cancelled_user`, `disc_type`, `disc_value`, `newtotal`, `disc_thereornot`, `disc_indiv_total`, `datetimee_new`, `taxname2`, `tax2`, `taxname3`, `tax3`, `taxname4`, `tax4`, `taxname5`, `tax5`, `hsn_code`, `old_total`, `old_total_indiv`) VALUES (87,' Mutton Biryani Regular','1.0','142.86','142.86','Item',NULL,NULL,'no','2.5','CGST(2.5%)','20181122-0000130','07:42:08 PM','2018 11 22','admin','  Dine-in','  Cash','279.99','279.99','257','Accidental charge','153.09','22 Nov 2018','153.09','%','0','142.86','no','','201811221942','SGST(2.5%)','2.5','None','','None','','None','','',NULL,NULL),(133,'Shawarma Roll','1.0','57.142','57.14','Item',NULL,NULL,'no','2.5','CGST(2.5%)','20181122-0000154','09:22:19 PM','2018 11 22','admin','  Dine-in','  Cash','60.00','60.0','309','Accidental charge','60.0','22 Nov 2018','60.0','%','0','57.14','no','','201811222122','SGST(2.5%)','2.5','None','','None','','None','','',NULL,NULL),(551,'Special Shawarma','1.0','95.24','95.24','Item',NULL,NULL,'no','2.5','CGST(2.5%)','20181124-0000136','10:34:23 PM','2018 11 24','admin','  Dine-in','  Cash','635.00','635.0','502','Changed mind','635.0','24 Nov 2018','635.0','%','0','95.24','no','','201811242234','SGST(2.5%)','2.5','None','','None','','None','','',NULL,NULL),(552,'Barbeque Chicken Full','1.0','276.19','276.19','Item',NULL,NULL,'no','2.5','CGST(2.5%)','20181124-0000136','10:34:23 PM','2018 11 24','admin','  Dine-in','  Cash','635.00','635.0','503','Changed mind','635.0','24 Nov 2018','635.0','%','0','276.19','no','','201811242234','SGST(2.5%)','2.5','None','','None','','None','','',NULL,NULL),(553,' Mutton Biryani Regular','1.0','142.86','142.86','Item',NULL,NULL,'no','2.5','CGST(2.5%)','20181124-0000136','10:34:23 PM','2018 11 24','admin','  Dine-in','  Cash','635.00','635.0','504','Changed mind','635.0','24 Nov 2018','635.0','%','0','142.86','no','','201811242234','SGST(2.5%)','2.5','None','','None','','None','','',NULL,NULL),(554,'Butter Fruit Milk Shake','1.0','70.0','70.00','Item',NULL,NULL,'no',NULL,'None','20181124-0000136','10:34:23 PM','2018 11 24','admin','  Dine-in','  Cash','635.00','635.0','505','Changed mind','635.0','24 Nov 2018','635.0','%','0','70.00','no','','201811242234',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL),(555,'Mineral Water 1Ltr','1.0','25.0','25.00','Item',NULL,NULL,'no',NULL,'None','20181124-0000136','10:34:23 PM','2018 11 24','admin','  Dine-in','  Cash','635.00','635.0','506','Changed mind','635.0','24 Nov 2018','635.0','%','0','25.00','no','','201811242234',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL),(702,'Party Hall Booking','1.0','21000.0','21000.00','Item',NULL,NULL,'no',NULL,'None','20181125-0000114','04:23:26 PM','2018 11 25','admin','  Dine-in','  Cash','21000.00','21000.0','592','Changed mind','21000.0','25 Nov 2018','21000.0','%','0','21000.00','no','','201811251623',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL),(1008,'Chicken Biryani Regular','1.0','114.29','114.29','Item',NULL,NULL,'no','2.5','CGST(2.5%)','20181125-000107','09:49:14 PM','2018 11 25','admin','  Dine-in','  Cash','210.00','210.0','29','Changed mind','210.0','25 Nov 2018','210.0','%','0','114.29','no','','201811252149','SGST(2.5%)','2.5','None','','None','','None','','',NULL,NULL),(1009,'Plate Shawarma','1.0','85.71','85.71','Item',NULL,NULL,'no','2.5','CGST(2.5%)','20181125-000107','09:49:14 PM','2018 11 25','admin','  Dine-in','  Cash','210.00','210.0','30','Changed mind','210.0','25 Nov 2018','210.0','%','0','85.71','no','','201811252149','SGST(2.5%)','2.5','None','','None','','None','','',NULL,NULL),(1032,'Chicken Biryani Regular','1.0','114.29','114.29','Item',NULL,NULL,'no','2.5','CGST(2.5%)','20181125-000055','10:08:40 PM','2018 11 25','admin','  Dine-in','  Cash','120.00','120.0','57','Changed mind','120.0','25 Nov 2018','120.0','%','0','114.29','no','','201811252208','SGST(2.5%)','2.5','None','','None','','None','','',NULL,NULL),(1033,'Chicken Biryani Full','1.0','180.95','180.95','Item',NULL,NULL,'no','2.5','CGST(2.5%)','20181125-000056','10:08:01 PM','2018 11 25','admin','  Dine-in','  Cash','190.00','190.0','58','Changed mind','190.0','25 Nov 2018','190.0','%','0','180.95','no','','201811252208','SGST(2.5%)','2.5','None','','None','','None','','',NULL,NULL),(1067,'Mineral Water 1Ltr','1.0','25.0','25.00','Item',NULL,NULL,'no',NULL,'None','20181125-0000194','10:48:12 PM','2018 11 25','admin','  Dine-in','  Cash','25.00','25.0','755','Changed mind','25.0','25 Nov 2018','25.0','%','0','25.00','no','','201811252248',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL),(1257,' Mutton Biryani Regular','2.0','142.86','285.72','Item',NULL,NULL,'no','2.5','CGST(2.5%)','20181127-000082','01:52:16 PM','2018 11 27','admin','  Dine-in','  Cash','340.01','340.01','72','miss billing','340.01','27 Nov 2018','340.01','%','0','285.72','no','','201811271352','SGST(2.5%)','2.5','None','','None','','None','','',NULL,NULL),(1258,'Fresh Lime Sode','1.0','40.0','40.00','Item',NULL,NULL,'no',NULL,'None','20181127-000082','01:52:16 PM','2018 11 27','admin','  Dine-in','  Cash','340.01','340.01','74','miss billing','340.01','27 Nov 2018','340.01','%','0','40.00','no','','201811271352',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL),(1268,'Chicken Noodles','1.0','104.76','104.76','Item',NULL,NULL,'no','2.5','CGST(2.5%)','20181127-000013','02:30:54 PM','2018 11 27','admin','  Dine-in','  Cash','369.89','369.89','859','','369.89','27 Nov 2018','369.89','%','0','104.76','no','','201811271430','SGST(2.5%)','2.5','None','','None','','None','','',NULL,NULL),(1269,'Butter Chicken','1.0','152.28','152.28','Item',NULL,NULL,'no','2.5','CGST(2.5%)','20181127-000013','02:30:54 PM','2018 11 27','admin','  Dine-in','  Cash','369.89','369.89','863','','369.89','27 Nov 2018','369.89','%','0','152.28','no','','201811271430','SGST(2.5%)','2.5','None','','None','','None','','',NULL,NULL),(1270,'Butter Kulcha','4.0','23.81','95.24','Item',NULL,NULL,'no','2.5','CGST(2.5%)','20181127-000013','02:30:54 PM','2018 11 27','admin','  Dine-in','  Cash','369.89','369.89','864','','369.89','27 Nov 2018','369.89','%','0','95.24','no','','201811271430','SGST(2.5%)','2.5','None','','None','','None','','',NULL,NULL),(1471,'Water Melon','1.0','40.0','40.00','Item',NULL,NULL,'no',NULL,'None','20181128-0000111','07:31:05 PM','2018 11 28','admin','  Dine-in','  Cash','40.00','40.0','963','miss billing','40.0','28 Nov 2018','40.0','%','0','40.00','no','','201811281931',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL),(1486,'Mint Lime','1.0','35.0','35.00','Item',NULL,NULL,'no',NULL,'None','20181128-0000119','07:32:52 PM','2018 11 28','admin','  Dine-in','  Cash','35.00','35.0','978','miss billing','35.0','28 Nov 2018','35.0','%','0','35.00','no','','201811281932',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL),(1497,'Sprite','1.0','25.0','25.00','Item',NULL,NULL,'no',NULL,'None','20181128-000153','08:20:42 PM','2018 11 28','admin','  Dine-in','  Cash','25.00','25.0','46','Damaged/Spoiled','25.0','28 Nov 2018','25.0','%','0','25.00','no','','201811282020',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL),(1498,'Shawarma Roll','1.0','57.142','57.142','Item',NULL,NULL,'no','2.5','CGST(2.5%)','20181128-000154','08:17:19 PM','2018 11 28','admin','  Dine-in','  Cash','260.00','260.00198','48','Damaged/Spoiled','260.0','28 Nov 2018','260.0','%','0','57.14','no','','201811282017','SGST(2.5%)','2.5','None','','None','','None','','',NULL,NULL),(1499,'Kalmi Kabab Full','1.0','190.48','190.48','Item',NULL,NULL,'no','2.5','CGST(2.5%)','20181128-000154','08:17:19 PM','2018 11 28','admin','  Dine-in','  Cash','260.00','260.00198','49','Damaged/Spoiled','260.0','28 Nov 2018','260.0','%','0','190.48','no','','201811282017','SGST(2.5%)','2.5','None','','None','','None','','',NULL,NULL),(1513,'Butter Chicken','1.0','152.28','152.28','Item',NULL,NULL,'no','2.5','CGST(2.5%)','20181128-0000125','09:31:02 PM','2018 11 28','admin','  Dine-in','  Cash','359.90','359.90002','988','Damaged/Spoiled','359.9','28 Nov 2018','359.9','%','0','152.28','no','','201811282131','SGST(2.5%)','2.5','None','','None','','None','','',NULL,NULL),(1514,'Kalmi Kabab Full','1.0','190.48','190.48','Item',NULL,NULL,'no','2.5','CGST(2.5%)','20181128-0000125','09:31:02 PM','2018 11 28','admin','  Dine-in','  Cash','359.90','359.90002','989','Damaged/Spoiled','359.9','28 Nov 2018','359.9','%','0','190.48','no','','201811282131','SGST(2.5%)','2.5','None','','None','','None','','',NULL,NULL),(1547,'Chicken Biryani Spacial','1.0','238.1','238.10','Item',NULL,NULL,'no','2.5','CGST(2.5%)','20181128-000064','09:31:59 PM','2018 11 28','admin','  Dine-in','  Cash','250.01','250.0','73','Damaged/Spoiled','250.01','28 Nov 2018','250.01','%','0','238.10','no','','201811282131','SGST(2.5%)','2.5','None','','None','','None','','',NULL,NULL),(1747,'Chicken Biryani Regular','1.0','114.29','114.29','Item',NULL,NULL,'no','2.5','CGST(2.5%)','20181130-000012','01:15:56 PM','2018 11 30','admin','  Dine-in','  Cash','120.00','120.0','1085','Damaged/Spoiled','120.0','30 Nov 2018','120.0','%','0','114.29','no','','201811301315','SGST(2.5%)','2.5','None','','None','','None','','',NULL,NULL),(1816,'Tandoori Chicken Full','1.0','285.71','285.71','Item',NULL,NULL,'no','2.5','CGST(2.5%)','20181130-000053','06:32:14 PM','2018 11 30','admin','  Dine-in','  Cash','459.99','459.99','118','Damaged/Spoiled','459.99','30 Nov 2018','459.99','%','0','285.71','no','','201811301832','SGST(2.5%)','2.5','None','','None','','None','','',NULL,NULL),(1817,'Tandoori Chicken Half','1.0','152.38','152.38','Item',NULL,NULL,'no','2.5','CGST(2.5%)','20181130-000053','06:32:14 PM','2018 11 30','admin','  Dine-in','  Cash','459.99','459.99','119','Damaged/Spoiled','459.99','30 Nov 2018','459.99','%','0','152.38','no','','201811301832','SGST(2.5%)','2.5','None','','None','','None','','',NULL,NULL),(2050,'Mutton Biryani Family','1.0','571.43','571.43','Item',NULL,NULL,'no','2.5','CGST(2.5%)','20181201-000093','02:48:07 PM','2018 12 01','admin','  Dine-in','  Cash','750.00','750.0','184','Damaged/Spoiled','750.0','01 Dec 2018','750.0','%','0','571.43','no','','201812011448','SGST(2.5%)','2.5','None','','None','','None','','',NULL,NULL),(2051,'Chicken Lollipop','1.0','142.86','142.86','Item',NULL,NULL,'no','2.5','CGST(2.5%)','20181201-000093','02:48:07 PM','2018 12 01','admin','  Dine-in','  Cash','750.00','750.0','185','Damaged/Spoiled','750.0','01 Dec 2018','750.0','%','0','142.86','no','','201812011448','SGST(2.5%)','2.5','None','','None','','None','','',NULL,NULL),(2064,'Chicken Fired Rice','1.0','104.76','104.76','Item',NULL,NULL,'no','2.5','CGST(2.5%)','20181201-000112','02:54:29 PM','2018 12 01','admin','  Dine-in','  Cash','199.99','199.99','99','Damaged/Spoiled','199.99','01 Dec 2018','199.99','%','0','104.76','no','','201812011454','SGST(2.5%)','2.5','None','','None','','None','','',NULL,NULL),(2065,'Egg Fried Rice','1.0','85.71','85.71','Item',NULL,NULL,'no','2.5','CGST(2.5%)','20181201-000112','02:54:29 PM','2018 12 01','admin','  Dine-in','  Cash','199.99','199.99','100','Damaged/Spoiled','199.99','01 Dec 2018','199.99','%','0','85.71','no','','201812011454','SGST(2.5%)','2.5','None','','None','','None','','',NULL,NULL),(2082,'Kapital  Kitchen Chicken','1.0','171.428','171.43','Item',NULL,NULL,'no','2.5','CGST(2.5%)','20181201-000062','03:22:56 PM','2018 12 01','admin','  Dine-in','  Cash','265.00','265.0','97','Damaged/Spoiled','265.0','01 Dec 2018','265.0','%','0','171.43','no','','201812011522','SGST(2.5%)','2.5','None','','None','','None','','',NULL,NULL),(2083,'Chocolate Fantasy','1.0','85.0','85.00','Item',NULL,NULL,'no',NULL,'None','20181201-000062','03:22:56 PM','2018 12 01','admin','  Dine-in','  Cash','265.00','265.0','98','Damaged/Spoiled','265.0','01 Dec 2018','265.0','%','0','85.00','no','','201812011522',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL),(3301,'Agrawals dhokla mix 500gm','1.0','59.0','59.0','Item',NULL,NULL,'no',NULL,'None','20200731-000018','12:42:52 PM','2020 07 31','admin','  General','  Cash','255.00','255.0','7','Changed mind','134.0','31 Jul 2020','134.0','₹','0','59.0','no','','202007311215',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL),(3302,'Chocolate pastry','1.0','75.0','75.0','Item',NULL,NULL,'no',NULL,'None','20200731-000018','12:42:52 PM','2020 07 31','admin','  General','  Cash','255.00','255.0','8','Changed mind','134.0','31 Jul 2020','134.0','₹','0','75.0','no','','202007311215',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL),(3305,'Chocolate pastry','1.0','75.0','75.00','Item',NULL,NULL,'no',NULL,'None','20200731-000019','12:44:59 PM','2020 07 31','admin','  General','  Card','159.00','159.0','11','Accidental charge','159.0','31 Jul 2020','159.0','₹','0','75.0','no','','202007311244',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL),(3306,'aachi chilli powder 200gm','1.0','84.0','84.00','Item',NULL,NULL,'no',NULL,'None','20200731-000019','12:44:59 PM','2020 07 31','admin','  General','  Card','159.00','159.0','12','Accidental charge','159.0','31 Jul 2020','159.0','%','0','84.00','no','','202007311244',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL),(3385,'Chocolate pastry','1.0','75.0','75.0','Item',NULL,NULL,'no',NULL,'None','20200821-000011','12:34:45 PM','2020 08 21','admin','  General','  Cash','84.00','84.0','39','Changed mind','84.0','21 Aug 2020','84.0','₹','0','75.0','no','','202008211234',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL),(3386,'Dabur ToothPaste','1.0','20.0','20.0','Item',NULL,NULL,'no',NULL,'None','20200821-000011','12:26:34 PM','2020 08 21','admin','  General','  Cash','106.40','106.4','40','Changed mind','84.0','21 Aug 2020','22.400002','₹','0','20.0','no','','202008211226',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL),(3387,'Chocolate pastry','1.0','75.0','75.0','Item',NULL,NULL,'no',NULL,'None','20200821-000012','12:32:46 PM','2020 08 21','admin','  General','  Cash','106.40','106.4','44','Changed mind','106.4','21 Aug 2020','84.0','₹','0','75.0','no','','202008211232',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL),(3388,'Dabur ToothPaste','1.0','20.0','20.00','Item',NULL,NULL,'no',NULL,'None','20200821-000012','12:35:32 PM','2020 08 21','admin','  General','  Cash','22.40','22.4','45','Changed mind','106.4','21 Aug 2020','22.4','₹','0','20.0','no','','202008211235',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL),(3487,'aachi chilli powder 100gm','4.0','37.0','148.0','Item',NULL,NULL,'no',NULL,'None','20201002-000011','12:16:17 PM','2020 10 02','admin','  General','  Cash','587.10','587.10004','10','Changed mind','389.97998','02 Oct 2020','389.97998','%','10','133.20','yes','14.80','202010021216',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL),(3489,'barilla pasta 500gm','1.0','215.0','215.0','Item',NULL,NULL,'no',NULL,'None','20201002-000011','12:16:17 PM','2020 10 02','admin','  General','  Cash','587.10','587.10004','12','Changed mind','389.97998','02 Oct 2020','389.97998','₹','0','215.0','no','','202010021216',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL),(3624,'aachi chilli powder 100gm','1.0','37.0','37.0','Item',NULL,NULL,'no',NULL,'None','20210105-000014','11:56:19 AM','2021 01 05','admin','  General','  Cash','73.14','73.14','82','Changed mind','73.14','05 Jan 2021','73.14','%','10','33.30','yes','3.70','202101051156',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL),(3625,'aachi turmeric powder 100gm','1.0','32.0','32.0','Item',NULL,NULL,'no',NULL,'None','20210105-000014','11:56:19 AM','2021 01 05','admin','  General','  Cash','73.14','73.14','83','Changed mind','73.14','05 Jan 2021','73.14','%','0','32.00','no','','202101051156',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL),(3626,'aachi coriander powder 100gm','1.0','38.0','38.0','Item',NULL,NULL,'no',NULL,NULL,'20210403-000013','12:02:34 PM','2021 04 03','admin','  General','  Card','42.56','42.56','141','Changed mind','42.56','03 Apr 2021','42.56','₹','0','38.0','no','','202104031202',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL);
INSERT INTO `billcount` (`_id`, `value`) VALUES (1,'0');
INSERT INTO `billnumber` (`_id`, `billnumber`, `total`, `user`, `date`, `paymentmethod`, `billtype`, `subtotal`, `taxtotal`, `roundoff`, `globaltaxtotal`, `billcount`, `datetimee_new`, `comments_sales`, `delivery_fee`, `packing_charges`, `loyalty_points`, `loyalty_amount`, `order_id`) VALUES (1465,'20200707-000011','95.00','admin','2020 07 07','  Cash','  General','95.00','0.00','0','0.0','1465','202007071220',NULL,NULL,NULL,NULL,NULL,NULL),(1466,'20200709-000011','58.00','admin','2020 07 09','  Cash','  General','58.00','0.00','0','0.0','1466','202007091416',NULL,NULL,NULL,NULL,NULL,NULL),(1467,'20200709-000012','178.00','admin','2020 07 09','  Cash','  General','178.00','0.00','0','0.0','1467','202007091422',NULL,NULL,NULL,NULL,NULL,NULL),(1468,'20200710-000011','142.00','admin','2020 07 10','  Cash','  General','142.00','0.00','0','0.0','1468','202007101017',NULL,NULL,NULL,NULL,NULL,NULL),(1469,'20200711-000011','122.00','admin','2020 07 11','  Cash','  General','122.00','0.00','0','0.0','1469','202007111019',NULL,NULL,NULL,NULL,NULL,NULL),(1470,'20200711-000012','610.00','admin','2020 07 11','  Cash','  General','610.00','0.00','0','0.0','1470','202007111021',NULL,NULL,NULL,NULL,NULL,NULL),(1471,'20200711-000013','200.00','admin','2020 07 11','  Cash','  General','200.00','0.00','0','0.0','1471','202007111218',NULL,NULL,NULL,NULL,NULL,NULL),(1472,'20200711-000014','200.00','admin','2020 07 11','  Cash','  General','200.00','0.00','0','0.0','1472','202007111228',NULL,NULL,NULL,NULL,NULL,NULL),(1473,'20200712-000011','254.00','admin','2020 07 12','  Cash','  General','254.00','0.00','0','0.0','1473','202007121606',NULL,NULL,NULL,NULL,NULL,NULL),(1474,'20200712-000012','253.00','admin','2020 07 12','  Cash','  General','253.00','0.00','0','0.0','1474','202007121615',NULL,NULL,NULL,NULL,NULL,NULL),(1475,'20200714-000011','32.00','admin','2020 07 14','  Cash','  General','32.00','0.00','0','0.0','1475','202007141253',NULL,NULL,NULL,NULL,NULL,NULL),(1476,'20200715-000011','394.00','admin','2020 07 15','  Cash','  General','394.00','0.00','0','0.0','1476','202007151129',NULL,NULL,NULL,NULL,NULL,NULL),(1477,'20200716-000011','121.00','admin','2020 07 16','  Cash','  General','121.00','0.00','0','0.0','1477','202007161338',NULL,NULL,NULL,NULL,NULL,NULL),(1478,'20200716-000012','243.00','admin','2020 07 16','  Cash','  General','243.00','0.00','0','0.0','1478','202007161340',NULL,NULL,NULL,NULL,NULL,NULL),(1479,'20200716-000021','574.00','admin','2020 07 16','  Card','  General','574.00','0.00','0','0.0','1479','202007161344',NULL,NULL,NULL,NULL,NULL,NULL),(1480,'20200717-000011','84.00','admin','2020 07 17','  Cash','  General','84.00','0.00','0','0.0','1480','202007170757',NULL,NULL,NULL,NULL,NULL,NULL),(1481,'20200717-000012','602.00','admin','2020 07 17','  Cash','  General','602.00','0.00','0','0.0','1481','202007171443',NULL,NULL,NULL,NULL,NULL,NULL),(1482,'20200718-000011','396.00','admin','2020 07 18','  Cash','  General','396.00','0.00','0','0.0','1482','202007181208',NULL,NULL,NULL,NULL,NULL,NULL),(1483,'20200718-000012','330.00','admin','2020 07 18','  Cash','  General','330.00','0.00','0','0.0','1483','202007181641',NULL,NULL,NULL,NULL,NULL,NULL),(1484,'20200718-000013','163.00','admin','2020 07 18','  Cash','  General','163.00','0.00','0','0.0','1484','202007181711',NULL,NULL,NULL,NULL,NULL,NULL),(1485,'20200724-000011','75.00','admin','2020 07 24','  Cash','  General','75.00','0.00','0','0.0','1485','202007241329',NULL,NULL,NULL,NULL,NULL,NULL),(1486,'20200724-000012','122.00','admin','2020 07 24','  Cash','  General','122.00','0.00','0','0.0','1486','202007241329',NULL,NULL,NULL,NULL,NULL,NULL),(1487,'20200725-000011','186.00','admin','2020 07 25','  Cash','  General','186.00','0.00','0','0.0','1487','202007250900',NULL,NULL,NULL,NULL,NULL,NULL),(1488,'20200725-000012','385.00','admin','2020 07 25','  Cash','  General','385.00','0.00','0','0.0','1488','202007250901',NULL,NULL,NULL,NULL,NULL,NULL),(1489,'20200725-000013','38.00','admin','2020 07 25','  Cash','  General','38.00','0.00','0','0.0','1489','202007251107',NULL,NULL,NULL,NULL,NULL,NULL),(1490,'20200725-000014','158.00','admin','2020 07 25','  Cash','  General','158.00','0.00','0','0.0','1490','202007251108',NULL,NULL,NULL,NULL,NULL,NULL),(1491,'20200725-000015','376.00','admin','2020 07 25','  Cash','  General','376.00','0.00','0','0.0','1491','202007251132',NULL,NULL,NULL,NULL,NULL,NULL),(1492,'20200728-000011','400.00','admin','2020 07 28','  Cash','  General','400.00','0.00','0','0.0','1492','202007281328',NULL,NULL,NULL,NULL,NULL,NULL),(1493,'20200728-000012','1599.00','admin','2020 07 28','  Cash','  General','1599.00','0.00','0','0.0','1493','202007281335',NULL,NULL,NULL,NULL,NULL,NULL),(1494,'20200728-000013','1400.00','admin','2020 07 28','  Cash','  General','1400.00','0.00','0','0.0','1494','202007281556',NULL,NULL,NULL,NULL,NULL,NULL),(1495,'20200728-000014','1199.00','admin','2020 07 28','  Cash','  General','1199.00','0.00','0','0.0','1495','202007281600',NULL,NULL,NULL,NULL,NULL,NULL),(1496,'20200730-000011','333.00','admin','2020 07 30','  Cash','  General','333.00','0.00','0','0.0','1496','202007301649',NULL,NULL,NULL,NULL,NULL,NULL),(1497,'20200731-000011','196.00','admin','2020 07 31','  Cash','  General','196.00','0.00','0','0.0','1497','202007311003',NULL,NULL,NULL,NULL,NULL,NULL),(1498,'20200731-000012','115.00','admin','2020 07 31','  Cash','  General','115.00','0.00','0','0.0','1498','202007311003',NULL,NULL,NULL,NULL,NULL,NULL),(1499,'20200731-000013','147.00','admin','2020 07 31','  Cash','  General','147.00','0.00','0','0.0','1499','202007311016',NULL,NULL,NULL,NULL,NULL,NULL),(1500,'20200731-000014','37.00','admin','2020 07 31','  Cash','  General','37.00','0.00','0','0.0','1500','202007311040',NULL,NULL,NULL,NULL,NULL,NULL),(1501,'20200731-000015','37.00','admin','2020 07 31','  Cash','  General','37.00','0.00','0','0.0','1501','202007311041',NULL,NULL,NULL,NULL,NULL,NULL),(1502,'20200731-000016','59.00','admin','2020 07 31','  Cash','  General','59.00','0.00','0','0.0','1502','202007311154',NULL,NULL,NULL,NULL,NULL,NULL),(1503,'20200731-000017','130.50','admin','2020 07 31','  Cash','  General','130.50','0.00','0','0.0','1503','202007311211',NULL,NULL,NULL,NULL,NULL,NULL),(1504,'20200731-000018','255.00','admin','2020 07 31','  Cash','  General','255.00','0.00','0','0.0','1504','202007311215',NULL,NULL,NULL,NULL,NULL,NULL),(1505,'20200731-000019','159.00','admin','2020 07 31','  Card','  General','159.00','0.00','0','0.0','1505','202007311244',NULL,NULL,NULL,NULL,NULL,NULL),(1506,'20200731-0000110','150.08','admin','2020 07 31','  Cash','  General','134.00','16.08','0','12.0','1506','202007311250',NULL,NULL,NULL,NULL,NULL,NULL),(1507,'20200801-000011','42.56','admin','2020 08 01','  Cash','  General','38.00','4.56','0','12.0','1507','202008012108',NULL,NULL,NULL,NULL,NULL,NULL),(1508,'20200805-000011','159.04','admin','2020 08 05','  Cash','  General','142.00','17.04','0','12.0','1508','202008051413',NULL,NULL,NULL,NULL,NULL,NULL),(1509,'20200805-000012','1729.75','admin','2020 08 05','  Cash','  General','1545.00','184.75','0','0.0','1509','202008051426',NULL,NULL,NULL,NULL,NULL,NULL),(1510,'20200805-000013','134.00','admin','2020 08 05','  Cash','  General','134.00','0.00','0','0.0','1510','202008051428',NULL,NULL,NULL,NULL,NULL,NULL),(1511,'20200805-000014','95.00','admin','2020 08 05','  Cash','  General','95.00','0.00','0','0.0','1511','202008051438',NULL,NULL,NULL,NULL,NULL,NULL),(1512,'20200806-000011','195.00','admin','2020 08 06','  Cash','  General','195.00','0.00','0','0.0','1512','202008061144',NULL,NULL,NULL,NULL,NULL,NULL),(1513,'20200808-000011','159.00','admin','2020 08 08','  Cash','  General','159.00','0.00','0','0.0','1513','202008081155',NULL,NULL,NULL,NULL,NULL,NULL),(1514,'20200808-000012','5000.00','admin','2020 08 08','  Cash','  General','5000.00','0.00','0','0.0','1514','202008081156',NULL,NULL,NULL,NULL,NULL,NULL),(1515,'20200808-000013','113.00','admin','2020 08 08','  Cash','  General','113.00','0.00','0','0.0','1515','202008081508',NULL,NULL,NULL,NULL,NULL,NULL),(1516,'20200808-000014','121.00','admin','2020 08 08','  Cash','  General','121.00','0.00','0','0.0','1516','202008081516',NULL,NULL,NULL,NULL,NULL,NULL),(1517,'20200809-000011','59.00','admin','2020 08 09','  Pay Later','  General','59.00','0.00','0','0.0','1517','202008091450',NULL,NULL,NULL,NULL,NULL,NULL),(1518,'20200809-000012','59.00','admin','2020 08 09','  Pay Later','  General','59.00','0.00','0','0.0','1518','202008091450',NULL,NULL,NULL,NULL,NULL,NULL),(1519,'20200809-000013','159.00','admin','2020 08 09','  Pay Later','  General','159.00','0.00','0','0.0','1519','202008091453',NULL,NULL,NULL,NULL,NULL,NULL),(1520,'20200810-000011','235.00','admin','2020 08 10','  Cash','  General','235.00','0.00','0','0.0','1520','202008101106',NULL,NULL,NULL,NULL,NULL,NULL),(1521,'20200810-000012','197.00','admin','2020 08 10','  Cash','  General','197.00','0.00','0','0.0','1521','202008101114',NULL,NULL,NULL,NULL,NULL,NULL),(1522,'20200810-000013','121.00','admin','2020 08 10','  Cash','  General','121.00','0.00','0','0.0','1522','202008101114',NULL,NULL,NULL,NULL,NULL,NULL),(1523,'20200810-000014','158.00','admin','2020 08 10','  Cash','  General','158.00','0.00','0','0.0','1523','202008101115',NULL,NULL,NULL,NULL,NULL,NULL),(1524,'20200810-000015','170.00','admin','2020 08 10','  Cash','  General','170.00','0.00','0','0.0','1524','202008101432',NULL,NULL,NULL,NULL,NULL,NULL),(1525,'20200810-000016','59.00','admin','2020 08 10','  Cash','  General','59.00','0.00','0','0.0','1525','202008101441',NULL,NULL,NULL,NULL,NULL,NULL),(1526,'20200814-000011','272.00','admin','2020 08 14','  Cash','  General','272.00','0.00','0','0.0','1526','202008141128',NULL,NULL,NULL,NULL,NULL,NULL),(1527,'20200814-000012','132.00','admin','2020 08 14','  Card','  General','132.00','0.00','0','0.0','1527','202008141131',NULL,NULL,NULL,NULL,NULL,NULL),(1528,'20200814-000013','153.00','admin','2020 08 14','  Pay Later','  General','153.00','0.00','0','0.0','1528','202008141154',NULL,NULL,NULL,NULL,NULL,NULL),(1529,'20200816-000011','32.25','admin','2020 08 16','  Cash','  General','32.25','0.00','0','0.0','1529','202008162228',NULL,NULL,NULL,NULL,NULL,NULL),(1530,'20200817-000011','115.00','admin','2020 08 17','  Cash','  General','115.00','0.00','0','0.0','1530','202008171132',NULL,NULL,NULL,NULL,NULL,NULL),(1531,'20200817-000031','174.00','admin','2020 08 17','  Cash','  General','174.00','0.00','0','0.0','1531','202008171138',NULL,NULL,NULL,NULL,NULL,NULL),(1532,'20200819-000011','37.00','admin','2020 08 19','  Cash','  General','37.00','0.00','0','0.0','1532','202008191256',NULL,NULL,NULL,NULL,NULL,NULL),(1533,'20200819-000012','600.00','admin','2020 08 19','  Cash','  General','600.00','0.00','0','0.0','1533','202008192059',NULL,NULL,NULL,NULL,NULL,NULL),(1534,'20200819-000013','1000.00','admin','2020 08 19','  Cash','  General','1000.00','0.00','0','0.0','1534','202008192100',NULL,NULL,NULL,NULL,NULL,NULL),(1535,'20200820-000011','59.00','admin','2020 08 20','  Cash','  General','59.00','0.00','0','0.0','1535','202008201435',NULL,NULL,NULL,NULL,NULL,NULL),(1536,'20200820-000012','40.00','admin','2020 08 20','  Cash','  General','40.00','0.00','0','0.0','1536','202008201436',NULL,NULL,NULL,NULL,NULL,NULL),(1537,'20200820-000013','184.00','admin','2020 08 20','  Cash','  General','184.00','0.00','0','0.0','1537','202008201616',NULL,NULL,NULL,NULL,NULL,NULL),(1538,'20200820-000014','705.00','admin','2020 08 20','  Cash','  General','705.00','0.00','0','0.0','1538','202008201617',NULL,NULL,NULL,NULL,NULL,NULL),(1539,'20200820-000015','159.00','admin','2020 08 20','  Cash','  General','159.00','0.00','0','0.0','1539','202008201620',NULL,NULL,NULL,NULL,NULL,NULL),(1540,'20200820-000016','215.04','admin','2020 08 20','  Cash','  General','192.00','23.04','0','12.0','1540','202008201632',NULL,NULL,NULL,NULL,NULL,NULL),(1541,'20200821-000011','0','admin','2020 08 21','  Cash','  General','0.0','0.0','0.0','12.0','1541','202008211222',NULL,NULL,NULL,NULL,NULL,NULL),(1542,'20200821-000012','0','admin','2020 08 21','  Cash','  General','0.0','0.0','0.0','12.0','1542','202008211231',NULL,NULL,NULL,NULL,NULL,NULL),(1543,'20200821-000031','571.20','admin','2020 08 21','  Cash','  General','510.00','61.20','0','12.0','1543','202008211236',NULL,NULL,NULL,NULL,NULL,NULL),(1544,'20200821-000013','144.48','admin','2020 08 21','  Cash','  General','129.00','15.48','0','12.0','1544','202008211246',NULL,NULL,NULL,NULL,NULL,NULL),(1545,'20200821-000014','60.48','admin','2020 08 21','  Cash','  General','54.00','6.48','0','12.0','1545','202008211247',NULL,NULL,NULL,NULL,NULL,NULL),(1546,'20200821-000015','39.37','admin','2020 08 21','  Cash','  General','35.15','4.22','0','12.0','1546','202008211248',NULL,NULL,NULL,NULL,NULL,NULL),(1547,'20200821-000016','10.08','admin','2020 08 21','  Cash','  General','9.00','1.08','0','12.0','1547','202008211250',NULL,NULL,NULL,NULL,NULL,NULL),(1548,'20200821-000017','193.76','admin','2020 08 21','  Cash','  General','173.00','20.76','0','12.0','1548','202008211409',NULL,NULL,NULL,NULL,NULL,NULL),(1549,'20200824-000011','190.40','admin','2020 08 24','  Cash','  General','170.00','20.40','0','12.0','1549','202008241205',NULL,NULL,NULL,NULL,NULL,NULL),(1550,'20200824-000012','236.32','admin','2020 08 24','  Cash','  General','211.00','25.32','0','12.0','1550','202008242212',NULL,NULL,NULL,NULL,NULL,NULL),(1551,'20200824-000013','215.04','admin','2020 08 24','  Cash','  General','192.00','23.04','0','12.0','1551','202008242231',NULL,NULL,NULL,NULL,NULL,NULL),(1552,'20200825-000011','112.00','admin','2020 08 25','  Cash','  General','100.00','12.00','0','12.0','1552','202008252257',NULL,NULL,NULL,NULL,NULL,NULL),(1553,'20200826-000011','136.64','admin','2020 08 26','  Cash','  General','122.00','14.64','0','12.0','1553','202008261208',NULL,NULL,NULL,NULL,NULL,NULL),(1554,'20200826-000012','41.44','admin','2020 08 26','  Cash','  General','37.00','4.44','0','12.0','1554','202008261219',NULL,NULL,NULL,NULL,NULL,NULL),(1555,'20200826-000013','64.96','admin','2020 08 26','  Cash','  General','58.00','6.96','0','12.0','1555','202008261452',NULL,NULL,NULL,NULL,NULL,NULL),(1556,'20200827-000011','135.52','admin','2020 08 27','  Cash','  General','121.00','14.52','0','12.0','1556','202008271344',NULL,NULL,NULL,NULL,NULL,NULL),(1557,'20200827-000012','41.44','admin','2020 08 27','  Cash','  General','37.00','4.44','0','12.0','1557','202008271344',NULL,NULL,NULL,NULL,NULL,NULL),(1558,'20200827-000013','41.44','admin','2020 08 27','  Cash','  General','37.00','4.44','0','12.0','1558','202008271345',NULL,NULL,NULL,NULL,NULL,NULL),(1559,'20200827-000014','35.84','admin','2020 08 27','  Cash','  General','32.00','3.84','0','12.0','1559','202008271345',NULL,NULL,NULL,NULL,NULL,NULL),(1560,'20200827-000015','94.08','admin','2020 08 27','  Cash','  General','84.00','10.08','0','12.0','1560','202008271346',NULL,NULL,NULL,NULL,NULL,NULL),(1561,'20200901-000011','147.84','admin','2020 09 01','  Cash','  General','132.00','15.84','0','12.0','1561','202009011309',NULL,NULL,NULL,NULL,NULL,NULL),(1562,'20200901-000012','135.52','admin','2020 09 01','  Cash','  General','121.00','14.52','0','12.0','1562','202009011310',NULL,NULL,NULL,NULL,NULL,NULL),(1563,'20200901-000013','379.68','admin','2020 09 01','  Cash','  General','339.00','40.68','0','12.0','1563','202009011328',NULL,NULL,NULL,NULL,NULL,NULL),(1564,'20200902-000011','479.36','admin','2020 09 02','  Cash','  General','428.00','51.36','0','12.0','1564','202009021235',NULL,NULL,NULL,NULL,NULL,NULL),(1565,'20200902-000012','107.52','admin','2020 09 02','  Cash','  General','96.00','11.52','0','12.0','1565','202009021238',NULL,NULL,NULL,NULL,NULL,NULL),(1566,'20200903-000011','388.64','admin','2020 09 03','  Cash','  General','347.00','41.64','0','12.0','1566','202009031012',NULL,NULL,NULL,NULL,NULL,NULL),(1567,'20200903-000012','286.72','admin','2020 09 03','  Cash','  General','256.00','30.72','0','12.0','1567','202009031108',NULL,NULL,NULL,NULL,NULL,NULL),(1568,'20200910-000011','66.08','admin','2020 09 10','  Cash','  General','59.00','7.08','0','12.0','1568','202009101256',NULL,NULL,NULL,NULL,NULL,NULL),(1569,'20200913-000011','200.48','admin','2020 09 13','  Cash','  General','179.00','21.48','0','12.0','1569','202009131357',NULL,NULL,NULL,NULL,NULL,NULL),(1570,'20200914-000011','222.88','admin','2020 09 14','  Cash','  General','199.00','23.88','0','12.0','1570','202009141203',NULL,NULL,NULL,NULL,NULL,NULL),(1571,'20200916-000011','368.48','admin','2020 09 16','  Cash','  General','329.00','39.48','0','12.0','1571','202009161207',NULL,NULL,NULL,NULL,NULL,NULL),(1572,'20200916-000012','1116.64','admin','2020 09 16','  Cash','  General','997.00','119.64','0','12.0','1572','202009161255',NULL,NULL,NULL,NULL,NULL,NULL),(1573,'20200916-000013','405.44','admin','2020 09 16','  Cash','  General','362.00','43.44','0','12.0','1573','202009161859',NULL,NULL,NULL,NULL,NULL,NULL),(1574,'20200917-000011','212.80','admin','2020 09 17','  Cash','  General','190.00','22.80','0','12.0','1574','202009171541',NULL,NULL,NULL,NULL,NULL,NULL),(1575,'20200917-000012','94.08','admin','2020 09 17','  Cash','  General','84.00','10.08','0','12.0','1575','202009171601',NULL,NULL,NULL,NULL,NULL,NULL),(1576,'20200919-000011','42.56','admin','2020 09 19','  Cash','  General','38.00','4.56','0','12.0','1576','202009191220',NULL,NULL,NULL,NULL,NULL,NULL),(1577,'20200919-000012','492.80','admin','2020 09 19','  Cash','  General','440.00','52.80','0','12.0','1577','202009191648',NULL,NULL,NULL,NULL,NULL,NULL),(1578,'20200919-000013','152.32','admin','2020 09 19','  Cash','  General','136.00','16.32','0','12.0','1578','202009191653',NULL,NULL,NULL,NULL,NULL,NULL),(1579,'20200923-000011','55.44','admin','2020 09 23','  Cash','  General','49.50','5.94','0','12.0','1579','202009230959',NULL,NULL,NULL,NULL,NULL,NULL),(1580,'20200923-000012','147.84','admin','2020 09 23','  Cash','  General','132.00','15.84','0','12.0','1580','202009230959',NULL,NULL,NULL,NULL,NULL,NULL),(1581,'20200930-000011','196.00','admin','2020 09 30','  Cash','  General','175.00','21.00','0','12.0','1581','202009301122',NULL,NULL,NULL,NULL,NULL,NULL),(1582,'20201002-000011','587.10','admin','2020 10 02','  Cash','  General','524.20','62.90','0','12.0','1582','202010021212',NULL,NULL,NULL,NULL,NULL,NULL),(1583,'20201002-000012','443.52','admin','2020 10 02','  Cash','  General','396.00','47.52','0','17.5','1583','202010021220',NULL,NULL,NULL,NULL,NULL,NULL),(1584,'20201005-000011','199.36','admin','2020 10 05','  Cash','  General','178.00','21.36','0','12.0','1584','202010052155',NULL,NULL,NULL,NULL,NULL,NULL),(1585,'20201005-000012','100.80','admin','2020 10 05','  Card','  General','90.00','10.80','0','12.0','1585','202010052209',NULL,NULL,NULL,NULL,NULL,NULL),(1586,'20201015-000011','141.12','admin','2020 10 15','  Cash','  General','126.00','15.12','0','12.0','1586','202010151243',NULL,NULL,NULL,NULL,NULL,NULL),(1587,'20201015-000012','694.40','admin','2020 10 15','  Cash','  General','620.00','74.40','0','12.0','1587','202010151244',NULL,NULL,NULL,NULL,NULL,NULL),(1588,'20201015-000013','560.00','admin','2020 10 15','  Cash','  General','500.00','60.00','0','12.0','1588','202010151244',NULL,NULL,NULL,NULL,NULL,NULL),(1589,'20201015-000014','152.32','admin','2020 10 15','  Cash','  General','136.00','16.32','0','12.0','1589','202010151302',NULL,NULL,NULL,NULL,NULL,NULL),(1590,'20201015-000015','498.40','admin','2020 10 15','  Cash','  General','445.00','53.40','0','12.0','1590','202010151421',NULL,NULL,NULL,NULL,NULL,NULL),(1591,'20201021-000011','1525.44','admin','2020 10 21','  Cash','  General','1362.00','163.44','0','12.0','1591','202010211229',NULL,NULL,NULL,NULL,NULL,NULL),(1592,'20201022-000011','386.40','admin','2020 10 22','  Cash','  General','345.00','41.40','0','12.0','1592','202010221238',NULL,NULL,NULL,NULL,NULL,NULL),(1593,'20201103-000011','598.08','admin','2020 11 03','  Cash','  General','534.00','64.08','0','12.0','1593','202011031315',NULL,NULL,NULL,NULL,NULL,NULL),(1594,'20201103-000012','1833.44','admin','2020 11 03','  Cash','  General','1637.00','196.44','0','12.0','1594','202011031320',NULL,NULL,NULL,NULL,NULL,NULL),(1595,'20201103-000013','1456.00','admin','2020 11 03','  Cash','  General','1300.00','156.00','0','12.0','1595','202011031323',NULL,NULL,NULL,NULL,NULL,NULL),(1596,'20201108-000011','490.56','admin','2020 11 08','  Cash','  General','438.00','52.56','0','12.0','1596','202011081344',NULL,NULL,NULL,NULL,NULL,NULL),(1597,'20201110-000011','2350.88','admin','2020 11 10','  Cash','  General','2099.00','251.88','0','12.0','1597','202011101248',NULL,NULL,NULL,NULL,NULL,NULL),(1598,'20201125-000011','1770.72','admin','2020 11 25','  Cash','  General','1581.00','189.72','0','12.0','1598','202011251131',NULL,NULL,NULL,NULL,NULL,NULL),(1599,'20201127-000011','1013.60','admin','2020 11 27','  Cash','  General','905.00','108.60','0','12.0','1599','202011271408',NULL,NULL,NULL,NULL,NULL,NULL),(1600,'20201203-000011','2796.64','admin','2020 12 03','  Cash','  General','2497.00','299.64','0','12.0','1600','202012031939',NULL,NULL,NULL,NULL,NULL,NULL),(1601,'20201203-000012','96.32','admin','2020 12 03','  Cash','  General','86.00','10.32','0','12.0','1601','202012031946',NULL,NULL,NULL,NULL,NULL,NULL),(1602,'20201207-000011','784.00','admin','2020 12 07','  Cash','  General','700.00','84.00','0','12.0','1602','202012072026',NULL,NULL,NULL,NULL,NULL,NULL),(1603,'20201207-000012','37.00','admin','2020 12 07','  Cash','  General','37.00','0.00','0','0.0','1603','202012072027',NULL,NULL,NULL,NULL,NULL,NULL),(1604,'20201207-000013','113.00','admin','2020 12 07','  Cash','  General','113.00','0.00','0','0.0','1604','202012072027',NULL,NULL,NULL,NULL,NULL,NULL),(1605,'20201207-000014','75.00','admin','2020 12 07','  Cash','  General','75.00','0.00','0','0.0','1605','202012072027',NULL,NULL,NULL,NULL,NULL,NULL),(1606,'20201207-000015','20.00','admin','2020 12 07','  Cash','  General','20.00','0.00','0','0.0','1606','202012072028',NULL,NULL,NULL,NULL,NULL,NULL),(1607,'20201207-000016','38.00','admin','2020 12 07','  Cash','  General','38.00','0.00','0','0.0','1607','202012072028',NULL,NULL,NULL,NULL,NULL,NULL),(1608,'20201207-000017','178.08','admin','2020 12 07','  Cash','  General','159.00','19.08','0','12.0','1608','202012072037',NULL,NULL,NULL,NULL,NULL,NULL),(1609,'20201208-000011','122.08','admin','2020 12 08','  Cash','  General','109.00','13.08','0','12.0','1609','202012081107',NULL,NULL,NULL,NULL,NULL,NULL),(1610,'20201208-000012','36.96','admin','2020 12 08','  Cash','  General','33.00','3.96','0','12.0','1610','202012081111',NULL,NULL,NULL,NULL,NULL,NULL),(1611,'20201208-000013','66.08','admin','2020 12 08','  Card','  General','59.00','7.08','0','12.0','1611','202012081120',NULL,NULL,NULL,NULL,NULL,NULL),(1612,'20201208-000014','94.08','admin','2020 12 08','  Card','  General','84.00','10.08','0','12.0','1612','202012081122',NULL,NULL,NULL,NULL,NULL,NULL),(1613,'20201208-000015','157.92','admin','2020 12 08','  Cash','  General','141.00','16.92','0','12.0','1613','202012081253',NULL,NULL,NULL,NULL,NULL,NULL),(1614,'20201208-000016','244.16','admin','2020 12 08','  Cash','  General','218.00','26.16','0','12.0','1614','202012081256',NULL,NULL,NULL,NULL,NULL,NULL),(1615,'20201208-000017','256.08','admin','2020 12 08','  Cash','  General','211.00','45.08','0','0.0','1615','202012081321',NULL,NULL,NULL,NULL,NULL,NULL),(1616,'20201208-000018','256.08','admin','2020 12 08','  Cash','  General','211.00','45.08','0','0.0','1616','202012081322',NULL,NULL,NULL,NULL,NULL,NULL),(1617,'20201210-000011','346.00','admin','2020 12 10','  Cash','  General','346.00','0.00','0','0.0','1617','202012101234',NULL,NULL,NULL,NULL,NULL,NULL),(1618,'20201210-000012','569.00','admin','2020 12 10','  Cash','  General','569.00','0.00','0','0.0','1618','202012101238',NULL,NULL,NULL,NULL,NULL,NULL),(1619,'20201210-000013','56.00','admin','2020 12 10','  Cash','  General','56.00','0.00','0','0.0','1619','202012101247',NULL,NULL,NULL,NULL,NULL,NULL),(1620,'20201210-000014','37.00','admin','2020 12 10','  Cash','  General','37.00','0.00','0','0.0','1620','202012101247',NULL,NULL,NULL,NULL,NULL,NULL),(1621,'20201211-000011','84.00','admin','2020 12 11','  Cash','  General','84.00','0.00','0','0.0','1621','202012111249',NULL,NULL,NULL,NULL,NULL,NULL),(1622,'20201211-000012','37.00','admin','2020 12 11','  Cash','  General','37.00','0.00','0','0.0','1622','202012111925',NULL,NULL,NULL,NULL,NULL,NULL),(1623,'20201211-000013','191.60','admin','2020 12 11','  Cash','  General','179.00','12.60','0','0.0','1623','202012111925',NULL,NULL,NULL,NULL,NULL,NULL),(1624,'20201212-000011','96.56','admin','2020 12 12','  Cash','  General','77.00','19.56','0','0.0','1624','202012121224',NULL,NULL,NULL,NULL,NULL,NULL),(1625,'20201214-000011','112.00','admin','2020 12 14','  Cash','  General','112.00','0.00','0','0.0','1625','202012141221',NULL,NULL,NULL,NULL,NULL,NULL),(1626,'20201215-000011','121.00','admin','2020 12 15','  Cash','  General','121.00','0.00','0','0.0','1626','202012151146',NULL,NULL,NULL,NULL,NULL,NULL),(1627,'20201215-000012','188.00','admin','2020 12 15','  Cash','  General','188.00','0.00','0','0.0','1627','202012151150',NULL,NULL,NULL,NULL,NULL,NULL),(1628,'20201215-000013','132.00','admin','2020 12 15','  Cash','  General','132.00','0.00','0','0.0','1628','202012151151',NULL,NULL,NULL,NULL,NULL,NULL),(1629,'20210105-000011','403.00','admin','2021 01 05','  Cash','  General','403.00','0.00','0','0.0','1629','202101051110',NULL,NULL,NULL,NULL,NULL,NULL),(1630,'20210105-000012','388.00','admin','2021 01 05','  Cash','  General','388.00','0.00','0','0.0','1630','202101051127',NULL,NULL,NULL,NULL,NULL,NULL),(1631,'20210105-000013','560.00','admin','2021 01 05','  Cash','  General','500.00','60.00','0','12.0','1631','202101051131',NULL,NULL,NULL,NULL,NULL,NULL),(1632,'20210105-000014','0','admin','2021 01 05','  Cash','  General','0.0','0.0','0.0','12.0','1632','202101051133',NULL,NULL,NULL,NULL,NULL,NULL),(1633,'20210105-000015','285.60','admin','2021 01 05','  Cash','  General','255.00','30.60','0','12.0','1633','202101051250',NULL,NULL,NULL,NULL,NULL,NULL),(1634,'20210106-000011','84.00','admin','2021 01 06','  Cash','  General','75.00','9.00','0','12.0','1634','202101061239',NULL,NULL,NULL,NULL,NULL,NULL),(1635,'20210106-000012','222.88','admin','2021 01 06','  Cash','  General','199.00','23.88','0','12.0','1635','202101061240',NULL,NULL,NULL,NULL,NULL,NULL),(1636,'20210106-000013','2690.24','admin','2021 01 06','  Cash','  General','2402.00','288.24','0','12.0','1636','202101061242',NULL,NULL,NULL,NULL,NULL,NULL),(1637,'20210118-000011','222.88','admin','2021 01 18','  Cash','  General','199.00','23.88','0','12.0','1637','202101181242',NULL,NULL,NULL,NULL,NULL,NULL),(1638,'20210125-000011','478.24','admin','2021 01 25','  Cash','  General','427.00','51.24','0','12.0','1638','202101251230',NULL,NULL,NULL,NULL,NULL,NULL),(1639,'20210125-000012','101.92','admin','2021 01 25','  Cash','  General','91.00','10.92','0','12.0','1639','202101251234',NULL,NULL,NULL,NULL,NULL,NULL),(1640,'20210217-000011','152.32','admin','2021 02 17','  Cash','  General','136.00','16.32','0','12.0','1640','202102172008',NULL,NULL,NULL,NULL,NULL,NULL),(1641,'20210217-000012','94.08','admin','2021 02 17','  Cash','  General','84.00','10.08','0','12.0','1641','202102172008',NULL,NULL,NULL,NULL,NULL,NULL),(1642,'20210312-000011','194.88','admin','2021 03 12','  Cash','  General','174.00','20.88','0','12.0','1642','202103121118',NULL,NULL,NULL,NULL,NULL,NULL),(1643,'20210312-000012','126.56','admin','2021 03 12','  Cash','  General','113.00','13.56','0','12.0','1643','202103121121',NULL,NULL,NULL,NULL,NULL,NULL),(1644,'20210312-000013','328.16','admin','2021 03 12','  Cash','  General','293.00','35.16','0','12.0','1644','202103121122',NULL,NULL,NULL,NULL,NULL,NULL),(1645,'20210330-000011','412.16','admin','2021 03 30','  Cash','  General','368.00','44.16','0','12.0','1645','202103301526',NULL,NULL,NULL,NULL,NULL,NULL),(1646,'20210403-000011','136.64','admin','2021 04 03','  Cash','  General','122.00','14.64','0','12.0','1646','202104031128',NULL,NULL,NULL,NULL,NULL,NULL),(1647,'20210403-000012','150.08','admin','2021 04 03','  Cash','  General','134.00','16.08','0','12.0','1647','202104031128',NULL,NULL,NULL,NULL,NULL,NULL),(1648,'20210403-000013','0','admin','2021 04 03','  Card','  General','0.0','0.0','0.0','12.0','1648','202104031147',NULL,NULL,NULL,NULL,NULL,NULL),(1649,'20210405-000011','337.12','admin','2021 04 05','  Cash','  General','301.00','36.12','0','12.0','1649','202104051522',NULL,NULL,NULL,NULL,NULL,NULL),(1650,'20210407-000011','194.88','admin','2021 04 07','  Cash','  General','174.00','20.88','0','12.0','1650','202104072041',NULL,NULL,NULL,NULL,NULL,NULL),(1651,'20210407-000012','152.32','admin','2021 04 07','  Cash','  General','136.00','16.32','0','12.0','1651','202104072042',NULL,NULL,NULL,NULL,NULL,NULL),(1652,'20210416-000011','125.44','admin','2021 04 16','  Cash','  General','112.00','13.44','0','12.0','1652','202104161501',NULL,NULL,NULL,NULL,NULL,NULL),(1653,'20210417-000011','125.44','admin','2021 04 17','  Cash','  General','112.00','13.44','0','12.0','1653','202104171457',NULL,NULL,NULL,NULL,NULL,NULL),(1654,'20210421-000011','63.84','admin','2021 04 21','  Cash','  General','57.00','6.84','0','12.0','1654','202104211240',NULL,NULL,NULL,NULL,NULL,NULL),(1655,'20210421-000012','809.76','admin','2021 04 21','  Cash','  General','723.00','86.76','0','12.0','1655','202104211303',NULL,NULL,NULL,NULL,NULL,NULL),(1656,'20210421-000013','66.08','admin','2021 04 21','  Cash','  General','59.00','7.08','0','12.0','1656','202104211306',NULL,NULL,NULL,NULL,NULL,NULL),(1657,'20210421-000014','56.00','admin','2021 04 21','  Cash','  General','50.00','6.00','0','12.0','1657','202104211308',NULL,NULL,NULL,NULL,NULL,NULL),(1658,'20210422-000011','63.84','admin','2021 04 22','  Cash','  General','57.00','6.84','0','12.0','1658','202104221207',NULL,NULL,NULL,NULL,NULL,NULL),(1659,'20210422-000012','109.76','admin','2021 04 22','  Cash','  General','98.00','11.76','0','12.0','1659','202104221207',NULL,NULL,NULL,NULL,NULL,NULL),(1660,'20210422-000013','206.08','admin','2021 04 22','  Cash','  General','184.00','22.08','0','12.0','1660','202104221215',NULL,NULL,NULL,NULL,NULL,NULL),(1661,'20210424-000011','178.08','admin','2021 04 24','  Cash','  General','159.00','19.08','0','12.0','1661','202104241255',NULL,NULL,NULL,NULL,NULL,NULL),(1662,'20210424-000012','175.84','admin','2021 04 24','  Cash','  General','157.00','18.84','0','12.0','1662','202104241256',NULL,NULL,NULL,NULL,NULL,NULL),(1663,'20210424-000013','112.00','admin','2021 04 24','  Cash','  General','100.00','12.00','0','12.0','1663','202104241256',NULL,NULL,NULL,NULL,NULL,NULL),(1664,'20210426-000011','42.56','admin','2021 04 26','  Cash','  General','38.00','4.56','0','12.0','1664','202104261110',NULL,NULL,NULL,NULL,NULL,NULL),(1665,'20210426-000012','136.64','admin','2021 04 26','  Cash','  General','122.00','14.64','0','12.0','1665','202104261424',NULL,NULL,NULL,NULL,NULL,NULL),(1666,'20210426-000013','94.08','admin','2021 04 26','  Cash','  General','84.00','10.08','0','12.0','1666','202104261424',NULL,NULL,NULL,NULL,NULL,NULL),(1667,'20210427-000011','25.76','admin','2021 04 27','  Cash','  General','23.00','2.76','0','12.0','1667','202104271339',NULL,NULL,NULL,NULL,NULL,NULL),(1668,'20210427-000012','116.48','admin','2021 04 27','  Cash','  General','104.00','12.48','0','12.0','1668','202104271340',NULL,NULL,NULL,NULL,NULL,NULL),(1669,'20210427-000013','147.84','admin','2021 04 27','  Cash','  General','132.00','15.84','0','12.0','1669','202104271410',NULL,NULL,NULL,NULL,NULL,NULL),(1670,'20210428-000011','42.56','admin','2021 04 28','  Cash','  General','38.00','4.56','0','12.0','1670','202104282031',NULL,NULL,NULL,NULL,NULL,NULL),(1671,'20210428-000012','383.04','admin','2021 04 28','  Cash','  General','342.00','41.04','0','12.0','1671','202104282044',NULL,NULL,NULL,NULL,NULL,NULL),(1672,'20210428-000013','278.88','admin','2021 04 28','  Cash','  General','249.00','29.88','0','12.0','1672','202104282056',NULL,NULL,NULL,NULL,NULL,NULL),(1673,'20210429-000011','90.72','admin','2021 04 29','  Cash','  General','81.00','9.72','0','12.0','1673','202104291305',NULL,NULL,NULL,NULL,NULL,NULL),(1674,'20210430-000011','168.00','admin','2021 04 30','  Cash','  General','168.00','0.00','0','0.0','1674','202104302203',NULL,NULL,NULL,NULL,NULL,NULL),(1675,'20210430-000012','57.00','admin','2021 04 30','  Cash','  General','57.00','0.00','0','0.0','1675','202104302203',NULL,NULL,NULL,NULL,NULL,NULL),(1676,'20210501-000011','32.00','admin','2021 05 01','  Cash','  Home delivery','32.00','0.00','0','0.0','1676','202105011550',NULL,NULL,NULL,NULL,NULL,NULL),(1677,'20210501-000012','356.00','admin','2021 05 01','  Cash','  General','356.00','0.00','0','0.0','1677','202105011722',NULL,NULL,NULL,NULL,NULL,NULL),(1678,'20210501-000013','435.00','admin','2021 05 01','  Cash','  General','435.00','0.00','0','0.0','1678','202105011729',NULL,NULL,NULL,NULL,NULL,NULL),(1679,'20210501-000014','129.00','admin','2021 05 01','  Cash','  General','129.00','0.00','0','0.0','1679','202105012037',NULL,NULL,NULL,NULL,NULL,NULL),(1680,'20210502-000011','450.45','admin','2021 05 02','  Cash','  General','429.00','21.45','0','5.0','1680','202105021912',NULL,NULL,NULL,NULL,NULL,NULL),(1681,'20210503-000011','23.10','admin','2021 05 03','  Cash','  General','22.00','1.10','0','5.0','1681','202105031641',NULL,NULL,NULL,NULL,NULL,NULL),(1682,'20210505-000011','410.55','admin','2021 05 05','  Cash','  General','391.00','19.55','0','5.0','1682','202105051346',NULL,NULL,NULL,NULL,NULL,NULL),(1683,'20210505-000012','31.50','admin','2021 05 05','  Cash','  General','30.00','1.50','0','10.5','1683','202105051349',NULL,NULL,NULL,NULL,NULL,NULL),(1684,'20210505-000013','31.50','admin','2021 05 05','  Cash','  General','30.00','1.50','0','10.5','1684','202105051355',NULL,NULL,NULL,NULL,NULL,NULL),(1685,'20210505-000014','15750.00','admin','2021 05 05','  Cash','  General','15000.00','750.00','0','5.0','1685','202105051355',NULL,NULL,NULL,NULL,NULL,NULL),(1686,'20210505-000015','31.50','admin','2021 05 05','  Cash','  General','30.00','1.50','0','5.0','1686','202105051355',NULL,NULL,NULL,NULL,NULL,NULL),(1687,'20210505-000016','15750.00','admin','2021 05 05','  Cash','  General','15000.00','750.00','0','5.0','1687','202105051356',NULL,NULL,NULL,NULL,NULL,NULL),(1688,'20210506-000011','233.10','admin','2021 05 06','  Cash','  General','222.00','11.10','0','5.0','1688','202105061328',NULL,NULL,NULL,NULL,NULL,NULL),(1689,'20210506-000012','625.80','admin','2021 05 06','  Cash','  General','596.00','29.80','0','5.0','1689','202105061329',NULL,NULL,NULL,NULL,NULL,NULL),(1690,'20210506-000013','112.51','admin','2021 05 06','  Cash','  General','107.15','5.36','0','5.0','1690','202105061348',NULL,NULL,NULL,NULL,NULL,NULL),(1691,'20210509-000011','154.35','admin','2021 05 09','  Cash','  General','147.00','7.35','0','5.0','1691','202105091410',NULL,NULL,NULL,NULL,NULL,NULL),(1692,'20210509-000012','106.05','admin','2021 05 09','  Cash','  General','101.00','5.05','0','5.0','1692','202105091413',NULL,NULL,NULL,NULL,NULL,NULL),(1693,'20210510-000011','234.15','admin','2021 05 10','  Cash','  General','223.00','11.15','0','5.0','1693','202105101502',NULL,NULL,NULL,NULL,NULL,NULL),(1694,'20210510-000012','54.60','admin','2021 05 10','  Cash','  General','52.00','2.60','0','5.0','1694','202105101502',NULL,NULL,NULL,NULL,NULL,NULL),(1695,'20210510-000013','128.10','admin','2021 05 10','  Cash','  General','122.00','6.10','0','5.0','1695','202105101503',NULL,NULL,NULL,NULL,NULL,NULL),(1696,'20210510-000014','156.45','admin','2021 05 10','  Cash','  General','149.00','7.45','0','5.0','1696','202105101511',NULL,NULL,NULL,NULL,NULL,NULL),(1697,'20210510-000015','115.50','admin','2021 05 10','  Cash','  General','110.00','5.50','0','5.0','1697','202105101511',NULL,NULL,NULL,NULL,NULL,NULL),(1698,'20210514-000011','228.90','admin','2021 05 14','  Cash','  General','218.00','10.90','0','5.0','1698','202105141423',NULL,NULL,NULL,NULL,NULL,NULL),(1699,'20210514-000012','100.80','admin','2021 05 14','  Cash','  General','96.00','4.80','0','5.0','1699','202105141933',NULL,NULL,NULL,NULL,NULL,NULL),(1700,'20210519-000011','99.75','admin','2021 05 19','  Cash','  General','95.00','4.75','0','5.0','1700','202105191727',NULL,NULL,NULL,NULL,NULL,NULL),(1701,'20210519-000012','166.95','admin','2021 05 19','  Cash','  General','159.00','7.95','0','5.0','1701','202105191731',NULL,NULL,NULL,NULL,NULL,NULL),(1702,'20210519-000013','199.50','admin','2021 05 19','  Cash','  General','190.00','9.50','0','5.0','1702','202105192011',NULL,NULL,NULL,NULL,NULL,NULL),(1703,'20210519-000014','38.85','admin','2021 05 19','  Cash','  General','37.00','1.85','0','5.0','1703','202105192011',NULL,NULL,NULL,NULL,NULL,NULL),(1704,'20210523-000011','408.45','admin','2021 05 23','  Cash','  General','389.00','19.45','0','5.0','1704','202105231301',NULL,NULL,NULL,NULL,NULL,NULL),(1705,'20210523-000012','322.35','admin','2021 05 23','  Cash','  General','307.00','15.35','0','5.0','1705','202105231418',NULL,NULL,NULL,NULL,NULL,NULL),(1706,'20210523-000013','99.75','admin','2021 05 23','  Cash','  General','95.00','4.75','0','5.0','1706','202105231419',NULL,NULL,NULL,NULL,NULL,NULL),(1707,'20210524-000011','94.50','admin','2021 05 24','  Cash','  General','90.00','4.50','0','5.0','1707','202105241523',NULL,NULL,NULL,NULL,NULL,NULL),(1708,'20210525-000011','296.10','admin','2021 05 25','  Cash','  General','282.00','14.10','0','5.0','1708','202105251723',NULL,NULL,NULL,NULL,NULL,NULL),(1709,'20210528-000011','1210.65','admin','2021 05 28','  Cash','  General','1153.00','57.65','0','5.0','1709','202105281132',NULL,NULL,NULL,NULL,NULL,NULL),(1710,'20210528-000012','111.30','admin','2021 05 28','  Cash','  General','106.00','5.30','0','5.0','1710','202105281141',NULL,NULL,NULL,NULL,NULL,NULL),(1711,'20210529-000011','353.85','admin','2021 05 29','  Cash','  General','337.00','16.85','0','5.0','1711','202105291848',NULL,NULL,NULL,NULL,NULL,NULL),(1712,'20210531-000011','94.50','admin','2021 05 31','  Cash','  General','90.00','4.50','0','5.0','1712','202105312047',NULL,NULL,NULL,NULL,NULL,NULL),(1713,'20210531-000012','908.25','admin','2021 05 31','  Cash','  General','865.00','43.25','0','5.0','1713','202105312050',NULL,NULL,NULL,NULL,NULL,NULL),(1714,'20210531-000013','127.05','admin','2021 05 31','  Cash','  General','121.00','6.05','0','5.0','1714','202105312053',NULL,NULL,NULL,NULL,NULL,NULL),(1715,'20210601-000011','118.65','admin','2021 06 01','  Cash','  General','113.00','5.65','0','5.0','1715','202106011614',NULL,NULL,NULL,NULL,NULL,NULL),(1716,'20210602-000011','782.25','admin','2021 06 02','  Cash','  General','745.00','37.25','0','5.0','1716','202106021546',NULL,NULL,NULL,NULL,NULL,NULL),(1717,'20210602-000012','38.85','admin','2021 06 02','  Cash','  General','37.00','1.85','0','5.0','1717','202106021546',NULL,NULL,NULL,NULL,NULL,NULL),(1718,'20210604-000011','182.70','admin','2021 06 04','  Cash','  General','174.00','8.70','0','5.0','1718','202106041337',NULL,NULL,NULL,NULL,NULL,NULL),(1719,'20210604-000012','326.55','admin','2021 06 04','  Cash','  General','311.00','15.55','0','5.0','1719','202106041550',NULL,NULL,NULL,NULL,NULL,NULL),(1720,'20210605-000011','205.80','admin','2021 06 05','  Cash','  General','196.00','9.80','0','5.0','1720','202106051332',NULL,NULL,NULL,NULL,NULL,NULL),(1721,'20210605-000012','118.65','admin','2021 06 05','  Cash','  General','113.00','5.65','0','5.0','1721','202106051333',NULL,NULL,NULL,NULL,NULL,NULL),(1722,'20210605-000013','52.92','admin','2021 06 05','  Cash','  General','50.40','2.52','0','5.0','1722','202106051343',NULL,NULL,NULL,NULL,NULL,NULL),(1723,'20210605-000014','525.00','admin','2021 06 05','  Cash','  General','500.00','25.00','0','5.0','1723','202106051347',NULL,NULL,NULL,NULL,NULL,NULL),(1724,'20210605-000015','105.00','admin','2021 06 05','  Cash','  General','100.00','5.00','0','5.0','1724','202106051348',NULL,NULL,NULL,NULL,NULL,NULL),(1725,'20210606-000011','173.25','admin','2021 06 06','  Cash','  General','165.00','8.25','0','5.0','1725','202106061308',NULL,NULL,NULL,NULL,NULL,NULL),(1726,'20210606-000012','176.40','admin','2021 06 06','  Cash','  General','168.00','8.40','0','5.0','1726','202106061314',NULL,NULL,NULL,NULL,NULL,NULL),(1727,'20210607-000011','160.65','admin','2021 06 07','  Cash','  General','153.00','7.65','0','5.0','1727','202106071220',NULL,NULL,NULL,NULL,NULL,NULL),(1728,'20210612-000011','159.60','admin','2021 06 12','  Cash','  General','152.00','7.60','0','5.0','1728','202106121537',NULL,NULL,NULL,NULL,NULL,NULL),(1729,'20210613-000011','220.50','admin','2021 06 13','  Cash','  General','210.00','10.50','0','5.0','1729','202106131140',NULL,NULL,NULL,NULL,NULL,NULL),(1730,'20210613-000012','803.25','admin','2021 06 13','  Cash','  General','765.00','38.25','0','5.0','1730','202106131145',NULL,NULL,NULL,NULL,NULL,NULL),(1731,'20210614-000011','78.75','admin','2021 06 14','  Cash','  General','75.00','3.75','0','5.0','1731','202106141239',NULL,NULL,NULL,NULL,NULL,NULL),(1732,'20210616-000011','182.70','admin','2021 06 16','  Cash','  General','174.00','8.70','0','5.0','1732','202106161543',NULL,NULL,NULL,NULL,NULL,NULL),(1733,'20210617-000011','217.35','admin','2021 06 17','  Cash','  General','207.00','10.35','0','5.0','1733','202106171240',NULL,NULL,NULL,NULL,NULL,NULL),(1734,'20210618-000011','636.30','admin','2021 06 18','  Cash','  General','606.00','30.30','0','5.0','1734','202106181219',NULL,NULL,NULL,NULL,NULL,NULL),(1735,'20210618-000012','82.95','admin','2021 06 18','  Cash','  General','79.00','3.95','0','5.0','1735','202106181222',NULL,NULL,NULL,NULL,NULL,NULL),(1736,'20210618-000013','2210.25','admin','2021 06 18','  Cash','  General','2105.00','105.25','0','5.0','1736','202106181237',NULL,NULL,NULL,NULL,NULL,NULL),(1737,'20210621-000011','367.50','admin','2021 06 21','  Cash','  General','350.00','17.50','0','5.0','1737','202106211245',NULL,NULL,NULL,NULL,NULL,NULL),(1738,'20210621-000012','325.50','admin','2021 06 21','  Cash','  General','310.00','15.50','0','5.0','1738','202106211246',NULL,NULL,NULL,NULL,NULL,NULL),(1739,'20210622-000011','127.05','admin','2021 06 22','  Pay Later','  General','121.00','6.05','0','5.0','1739','202106221400',NULL,NULL,NULL,NULL,NULL,NULL),(1740,'20210622-000012','262.50','admin','2021 06 22','  Cash','  General','250.00','12.50','0','5.0','1740','202106221602',NULL,NULL,NULL,NULL,NULL,NULL),(1741,'20210626-000011','726.60','admin','2021 06 26','  Cash','  General','692.00','34.60','0','5.0','1741','202106261212',NULL,NULL,NULL,NULL,NULL,NULL),(1742,'20210626-000012','178.50','admin','2021 06 26','  Cash','  General','170.00','8.50','0','5.0','1742','202106261218',NULL,NULL,NULL,NULL,NULL,NULL),(1743,'20210626-000013','154.35','admin','2021 06 26','  Upiqr','  General','147.00','7.35','0','5.0','1743','202106261221',NULL,NULL,NULL,NULL,NULL,NULL),(1744,'20210626-000014','63.00','admin','2021 06 26','  Card','  General','60.00','3.00','0','5.0','1744','202106261245',NULL,NULL,NULL,NULL,NULL,NULL),(1745,'20210626-000015','144.90','admin','2021 06 26','  Cash','  General','138.00','6.90','0','5.0','1745','202106261310',NULL,NULL,NULL,NULL,NULL,NULL),(1746,'20210626-000016','59.85','admin','2021 06 26','  Cash','  General','57.00','2.85','0','5.0','1746','202106261311',NULL,NULL,NULL,NULL,NULL,NULL),(1747,'20210626-000017','196.35','admin','2021 06 26','  Cash','  General','187.00','9.35','0','5.0','1747','202106261423',NULL,NULL,NULL,NULL,NULL,NULL),(1748,'20210626-000018','5.25','admin','2021 06 26','  Cash','  General','5.00','0.25','0','5.0','1748','202106261434',NULL,NULL,NULL,NULL,NULL,NULL),(1749,'20210628-000011','149.10','admin','2021 06 28','  Cash','  General','142.00','7.10','0','5.0','1749','202106281536',NULL,NULL,NULL,NULL,NULL,NULL),(1750,'20210628-000012','141.75','admin','2021 06 28','  Cash','  General','135.00','6.75','0','5.0','1750','202106281537',NULL,NULL,NULL,NULL,NULL,NULL),(1751,'20210629-000011','216.30','admin','2021 06 29','  Cash','  General','206.00','10.30','0','5.0','1751','202106291147',NULL,NULL,NULL,NULL,NULL,NULL),(1752,'20210629-000012','194.77','admin','2021 06 29','  Cash','  General','185.50','9.27','0','5.0','1752','202106291148',NULL,NULL,NULL,NULL,NULL,NULL),(1753,'20210701-000011','498.75','admin','2021 07 01','  Cash','  General','475.00','23.75','0','5.0','1753','202107011007',NULL,NULL,NULL,NULL,NULL,NULL),(1754,'20210701-000012','236.25','admin','2021 07 01','  Cash','  General','225.00','11.25','0','5.0','1754','202107011008',NULL,NULL,NULL,NULL,NULL,NULL),(1755,'20210701-000013','1386.00','admin','2021 07 01','  Cash','  General','1320.00','66.00','0','5.0','1755','202107011418',NULL,NULL,NULL,NULL,NULL,NULL),(1756,'20210701-000014','231.00','admin','2021 07 01','  Card','  General','220.00','11.00','0','5.0','1756','202107011419',NULL,NULL,NULL,NULL,NULL,NULL),(1757,'20210703-000011','647.33','admin','2021 07 03','  Cash','  General','616.50','30.83','0','5.0','1757','202107031314',NULL,NULL,NULL,NULL,NULL,NULL),(1758,'20210713-000011','261.45','admin','2021 07 13','  Cash','  General','249.00','12.45','0','5.0','1758','202107131557',NULL,NULL,NULL,NULL,NULL,NULL),(1759,'20210713-000012','3150.00','admin','2021 07 13','  Cash','  General','3000.00','150.00','0','5.0','1759','202107131559',NULL,NULL,NULL,NULL,NULL,NULL),(1760,'20210718-000011','127.05','admin','2021 07 18','  Cash','  General','121.00','6.05','0','5.0','1760','202107181205',NULL,NULL,NULL,NULL,NULL,NULL),(1761,'20210719-000011','266.70','admin','2021 07 19','  Pay Later','  General','254.00','12.70','0','5.0','1761','202107190832',NULL,NULL,NULL,NULL,NULL,NULL),(1762,'20210719-000012','134.40','admin','2021 07 19','  Cash','  General','128.00','6.40','0','5.0','1762','202107191517',NULL,NULL,NULL,NULL,NULL,NULL),(1763,'20210726-000011','54.60','admin','2021 07 26','  Cash','  General','52.00','2.60','0','5.0','1763','202107260822',NULL,NULL,NULL,NULL,NULL,NULL),(1764,'20210803-000011','261.45','admin','2021 08 03','  Cash','  General','249.00','12.45','0','5.0','1764','202108031248',NULL,NULL,NULL,NULL,NULL,NULL),(1765,'20210805-000011','38.85','admin','2021 08 05','  Cash','  General','37.00','1.85','0','5.0','1765','202108051023',NULL,NULL,NULL,NULL,NULL,NULL),(1766,'20210805-000012','450.98','admin','2021 08 05','  Cash','  General','429.50','21.48','0','5.0','1766','202108051053',NULL,NULL,NULL,NULL,NULL,NULL),(1767,'20210809-000011','63.00','admin','2021 08 09','  Cash','  General','60.00','3.00','0','5.0','1767','202108091535',NULL,NULL,NULL,NULL,NULL,NULL),(1768,'20210813-000011','181.65','admin','2021 08 13','  Cash','  General','173.00','8.65','0','5.0','1768','202108132029',NULL,NULL,NULL,NULL,NULL,NULL),(1769,'20210819-000011','208.95','admin','2021 08 19','  Cash','  General','199.00','9.95','0','5.0','1769','202108191033',NULL,NULL,NULL,NULL,NULL,NULL),(1770,'20210825-000011','154.35','admin','2021 08 25','  Cash','  General','147.00','7.35','0','5.0','1770','202108251311',NULL,NULL,NULL,NULL,NULL,NULL),(1771,'20210825-000012','78.75','admin','2021 08 25','  Cash','  General','75.00','3.75','0','5.0','1771','202108251312',NULL,NULL,NULL,NULL,NULL,NULL),(1772,'20210825-000013','151.20','admin','2021 08 25','  Cash','  General','144.00','7.20','0','5.0','1772','202108251512',NULL,NULL,NULL,NULL,NULL,NULL),(1773,'20210903-000011','193.20','admin','2021 09 03','  Cash','  General','184.00','9.20','0','5.0','1773','202109031313',NULL,NULL,NULL,NULL,NULL,NULL),(1774,'20210907-000011','307.65','admin','2021 09 07','  Cash','  General','293.00','14.65','0','5.0','1774','202109071044',NULL,NULL,NULL,NULL,NULL,NULL),(1775,'20210907-000012','193.20','admin','2021 09 07','  Cash','  General','184.00','9.20','0','5.0','1775','202109071045',NULL,NULL,NULL,NULL,NULL,NULL),(1776,'20210908-000011','138.60','admin','2021 09 08','  Cash','  General','132.00','6.60','0','5.0','1776','202109080950',NULL,NULL,NULL,NULL,NULL,NULL),(1777,'20210915-000011','683.70','admin','2021 09 15','  Cash','  General','636.00','47.70','0','7.5','1777','202109151349',NULL,NULL,NULL,NULL,NULL,NULL),(1778,'20210923-000011','80.63','admin','2021 09 23','  Cash','  General','75.00','5.63','0','7.5','1778','202109231105',NULL,NULL,NULL,NULL,NULL,NULL),(1779,'20210923-000012','52.67','admin','2021 09 23','  Cash','  General','49.00','3.68','0','7.5','1779','202109231129',NULL,NULL,NULL,NULL,NULL,NULL),(1780,'20210923-000013','130.07','admin','2021 09 23','  Cash','  General','121.00','9.08','0','7.5','1780','202109231135',NULL,NULL,NULL,NULL,NULL,NULL),(1781,'20210923-000014','403.13','admin','2021 09 23','  Cash','  General','375.00','28.13','0','7.5','1781','202109231138',NULL,NULL,NULL,NULL,NULL,NULL),(1782,'20210925-000011','301.00','admin','2021 09 25','  Cash','  General','280.00','21.00','0','7.5','1782','202109251325',NULL,NULL,NULL,NULL,NULL,NULL),(1783,'20210926-000011','5375.00','admin','2021 09 26','  Cash','  General','5000.00','375.00','0','7.5','1783','202109261222',NULL,NULL,NULL,NULL,NULL,NULL),(1784,'20210926-000012','294.55','admin','2021 09 26','  Cash','  General','274.00','20.55','0','7.5','1784','202109261222',NULL,NULL,NULL,NULL,NULL,NULL),(1785,'20210926-000013','15738.00','admin','2021 09 26','  Cash','  General','14640.00','1098.00','0','7.5','1785','202109261231',NULL,NULL,NULL,NULL,NULL,NULL),(1786,'20210926-000014','193.50','admin','2021 09 26','  Cash','  General','180.00','13.50','0','7.5','1786','202109261241',NULL,NULL,NULL,NULL,NULL,NULL),(1787,'20210929-000011','271.98','admin','2021 09 29','  Cash','  General','253.00','18.97','0','7.5','1787','202109291046',NULL,NULL,NULL,NULL,NULL,NULL),(1788,'20210929-000012','64.50','admin','2021 09 29','  Cash','  General','60.00','4.50','0','7.5','1788','202109291052',NULL,NULL,NULL,NULL,NULL,NULL),(1789,'20210929-000013','324.65','admin','2021 09 29','  Cash','  General','302.00','22.65','0','7.5','1789','202109291100',NULL,NULL,NULL,NULL,NULL,NULL),(1790,'20210930-000011','146.20','admin','2021 09 30','  Cash','  General','136.00','10.20','0','7.5','1790','202109301438',NULL,NULL,NULL,NULL,NULL,NULL),(1791,'20211002-000011','187.05','admin','2021 10 02','  Cash','  General','174.00','13.05','0','7.5','1791','202110021155',NULL,NULL,NULL,NULL,NULL,NULL),(1792,'20211002-000012','205.32','admin','2021 10 02','  Cash','  General','191.00','14.33','0','7.5','1792','202110021242',NULL,NULL,NULL,NULL,NULL,NULL),(1793,'20211002-000013','237.57','admin','2021 10 02','  Cash','  General','221.00','16.58','0','7.5','1793','202110021249',NULL,NULL,NULL,NULL,NULL,NULL),(1794,'20211005-000011','188.13','admin','2021 10 05','  Cash','  General','175.00','13.13','0','7.5','1794','202110051254',NULL,NULL,NULL,NULL,NULL,NULL),(1795,'20211009-000011','387.00','admin','2021 10 09','  Cash','  General','360.00','27.00','0','7.5','1795','202110091237',NULL,NULL,NULL,NULL,NULL,NULL),(1796,'20211009-000012','387.00','admin','2021 10 09','  Cash','  General','360.00','27.00','0','7.5','1796','202110091259',NULL,NULL,NULL,NULL,NULL,NULL),(1797,'20211013-000011','154.80','admin','2021 10 13','  Cash','  General','144.00','10.80','0','7.5','1797','202110132051',NULL,NULL,NULL,NULL,NULL,NULL),(1798,'20211013-000012','86.00','admin','2021 10 13','  Cash','  General','80.00','6.00','0','7.5','1798','202110132059',NULL,NULL,NULL,NULL,NULL,NULL),(1799,'20211013-000013','154.80','admin','2021 10 13','  Cash','  General','144.00','10.80','0','7.5','1799','202110132100',NULL,NULL,NULL,NULL,NULL,NULL),(1800,'20211020-000011','130.07','admin','2021 10 20','  Cash','  General','121.00','9.08','0','7.5','1800','202110201243',NULL,NULL,NULL,NULL,NULL,NULL),(1801,'20211020-000012','130.07','admin','2021 10 20','  Cash','  General','121.00','9.08','0','7.5','1801','202110201243',NULL,NULL,NULL,NULL,NULL,NULL),(1802,'20211023-000011','395.60','admin','2021 10 23','  Cash','  General','368.00','27.60','0','7.5','1802','202110231458',NULL,NULL,NULL,NULL,NULL,NULL),(1803,'20211112-000011','139.75','admin','2021 11 12','  Cash','  General','130.00','9.75','0','7.5','1803','202111121335',NULL,NULL,NULL,NULL,NULL,NULL),(1804,'20211123-000011','24.73','admin','2021 11 23','  Cash','  General','23.00','1.72','0','7.5','1804','202111231200',NULL,NULL,NULL,NULL,NULL,NULL),(1805,'20211123-000012','154.80','admin','2021 11 23','  Cash','  General','144.00','10.80','0','7.5','1805','202111231221',NULL,NULL,NULL,NULL,NULL,NULL),(1806,'20211123-000013','153.19','admin','2021 11 23','  Cash','  General','142.50','10.69','0','7.5','1806','202111231230',NULL,NULL,NULL,NULL,NULL,NULL),(1807,'20211129-000011','154.35','admin','2021 11 29','  Cash','  General','147.00','7.35','0','5.0','1807','202111291542',NULL,NULL,NULL,NULL,NULL,NULL),(1808,'20211129-000012','208.95','admin','2021 11 29','  Cash','  General','199.00','9.95','0','5.0','1808','202111291542',NULL,NULL,NULL,NULL,NULL,NULL),(1809,'20211207-000011','232.05','admin','2021 12 07','  Cash','  General','221.00','11.05','0','5.0','1809','202112071239',NULL,NULL,NULL,NULL,NULL,NULL),(1810,'20211208-000011','151.20','admin','2021 12 08','  Cash','  General','144.00','7.20','0','5.0','1810','202112081110',NULL,NULL,NULL,NULL,NULL,NULL),(1811,'20211208-000012','124.95','admin','2021 12 08','  Cash','  General','119.00','5.95','0','5.0','1811','202112081110',NULL,NULL,NULL,NULL,NULL,NULL),(1812,'20211221-000011','24.15','admin','2021 12 21','  Cash','  General','23.00','1.15','0','5.0','1812','202112211157',NULL,NULL,NULL,NULL,NULL,NULL),(1813,'20220104-000011','63.00','admin','2022 01 04','  Cash','  General','60.00','3.00','0','5.0','1813','202201041325',NULL,NULL,NULL,NULL,NULL,NULL),(1814,'20220104-000012','38.85','admin','2022 01 04','  Cash','  General','37.00','1.85','0','5.0','1814','202201041332',NULL,NULL,NULL,NULL,NULL,NULL),(1815,'20220108-000011','24.15','admin','2022 01 08','  Cash','  General','23.00','1.15','0','5.0','1815','202201081221',NULL,NULL,NULL,NULL,NULL,NULL),(1816,'20220116-000011','3937.50','admin','2022 01 16','  Cash','  General','3750.00','187.50','0','5.0','1816','202201161358',NULL,NULL,NULL,NULL,NULL,NULL),(1817,'20220121-000011','153.30','admin','2022 01 21','  Cash','  General','146.00','7.30','0','5.0','1817','202201211219',NULL,NULL,NULL,NULL,NULL,NULL),(1818,'20220121-000012','79.80','admin','2022 01 21','  Card','  General','76.00','3.80','0','5.0','1818','202201211219',NULL,NULL,NULL,NULL,NULL,NULL),(1819,'20220121-000013','80.85','admin','2022 01 21','  Cash','  General','77.00','3.85','0','5.0','1819','202201211239',NULL,NULL,NULL,NULL,NULL,NULL),(1820,'20220123-000011','121.80','admin','2022 01 23','  Cash','  General','116.00','5.80','0','7.5','1820','202201231324',NULL,NULL,NULL,NULL,NULL,NULL),(1821,'20220125-000011','142.80','admin','2022 01 25','  Cash','  General','136.00','6.80','0','5.0','1821','202201251331',NULL,NULL,NULL,NULL,NULL,NULL),(1822,'20220125-000012','82.95','admin','2022 01 25','  Cash','  General','79.00','3.95','0','7.5','1822','202201251350',NULL,NULL,NULL,NULL,NULL,NULL),(1823,'20220126-000011','52.50','admin','2022 01 26','  Cash','  General','50.00','2.50','0','5.0','1823','202201261134',NULL,NULL,NULL,NULL,NULL,NULL),(1824,'20220128-000011','63.00','admin','2022 01 28','  Cash','  General','60.00','3.00','0','5.0','1824','202201281104',NULL,NULL,NULL,NULL,NULL,NULL),(1825,'20220128-000012','84.94','admin','2022 01 28','  Cash','  General','80.90','4.05','0','5.0','1825','202201281106',NULL,NULL,NULL,NULL,NULL,NULL),(1826,'20220210-000011','453.60','admin','2022 02 10','  Cash','  General','432.00','21.60','0.00','5.0','1826','202202101317',NULL,NULL,NULL,NULL,NULL,NULL),(1827,'20220210-000012','21.00','admin','2022 02 10','  Cash','  General','20.00','1.00','0.00','5.0','1827','202202101318',NULL,NULL,NULL,NULL,NULL,NULL),(1828,'20220706-000011','23.69','admin','2022 07 06','  Cash','  General','23.00','0.69','0.00','3.0','1','202207062156',NULL,NULL,NULL,NULL,NULL,NULL),(1829,'20220706-000012','77.25','admin','2022 07 06','  Cash','  General','75.00','2.25','0.00','3.0','2','202207062314',NULL,NULL,NULL,NULL,NULL,NULL),(1830,'20220708-000011','1.03','admin','2022 07 08','  Card','  General','1.00','0.03','0.00','3.0','3','202207081101',NULL,NULL,NULL,NULL,NULL,NULL),(1831,'20220708-000012','1.03','admin','2022 07 08','  Card','  General','1.00','0.03','0.00','3.0','4','202207081108',NULL,NULL,NULL,NULL,NULL,NULL),(1832,'20220708-000013','24.72','admin','2022 07 08','  Cash','  General','24.00','0.72','0.00','3.0','5','202207081113',NULL,NULL,NULL,NULL,NULL,NULL),(1833,'20220708-000014','24.72','admin','2022 07 08','  Cash','  General','24.00','0.72','0.00','3.0','6','202207081114',NULL,NULL,NULL,NULL,NULL,NULL),(1834,'20221017-000011','216.30','admin','2022 10 17','  Cash','  General','210.00','6.30','0.00','3.0','1','202210172131',NULL,NULL,NULL,NULL,NULL,NULL),(1835,'20221110-000011','124.63','admin','2022 11 10','  Cash','  General','121.00','3.63','0.00','3.0','2','202211101223',NULL,NULL,NULL,NULL,NULL,NULL),(1836,'20221110-000012','32.96','admin','2022 11 10','  Cash','  General','32.00','0.96','0.00','3.0','3','202211101223',NULL,NULL,NULL,NULL,NULL,NULL),(1837,'20230223-000011','82.40','admin','2023 02 23','  Cash','  General','80.00','2.40','0.00','3.0','2','202302231216',NULL,NULL,NULL,NULL,NULL,NULL),(1838,'20230223-000012','61.80','admin','2023 02 23','  Cash','  General','60.00','1.80','0.00','3.0','3','202302231521',NULL,NULL,NULL,NULL,NULL,NULL),(1839,'20230314-000011','60.77','admin','2023 03 14','  Cash','  General','59.00','1.77','0.00','3.0','4','202303141202',NULL,NULL,NULL,NULL,NULL,NULL),(1858,'20230317-000011','32.96','admin','2023 03 17','  Cash','  General','32.00','0.96','0.00','3.0','25','202303171420',NULL,NULL,NULL,NULL,NULL,NULL),(1859,'20230323-000011','124.63','admin','2023 03 23','  Cash','  General','121.00','3.63','0.00','3.0','26','202303231211',NULL,NULL,NULL,NULL,NULL,NULL),(1860,'20230404-000011','124.63','admin','2023 04 04','  Cash','  General','121.00','3.63','0.00','3.0','27','202304041417',NULL,NULL,NULL,NULL,NULL,NULL),(1861,'20230412-000011','119.48','admin','2023 04 12','  Cash','  General','116.00','3.48','0.00','3.0','28','202304121428',NULL,NULL,NULL,NULL,NULL,NULL),(1862,'20230421-000011','282.22','admin','2023 04 21','  Cash','  General','274.00','9.18','0.00','3.0','29','202304211233',NULL,NULL,NULL,NULL,NULL,NULL),(1863,'20230425-000011','118.45','admin','2023 04 25','  Cash','  General','115.00','3.45','0.00','3.0','30','202304251559',NULL,NULL,NULL,NULL,NULL,NULL),(1864,'20230511-000011','125.66','admin','2023 05 11','  Cash','  General','122.00','3.66','0.00','3.0','31','202305111631',NULL,NULL,NULL,NULL,NULL,NULL),(1865,'20230516-000011','125.66','admin','2023 05 16','  Cash','  General','122.00','3.66','0.00','3.0','32','202305161700',NULL,NULL,NULL,NULL,NULL,NULL),(1866,'20230518-000011','125.66','admin','2023 05 18','  Cash','  General','122.00','3.66','0.00','3.0','33','202305182031',NULL,NULL,NULL,NULL,NULL,NULL),(1867,'20230526-000011','125.66','admin','2023 05 26','  Cash','  General','122.00','3.66','0.00','3.0','34','202305261541',NULL,NULL,NULL,NULL,NULL,NULL),(1868,'20230526-000012','77.25','admin','2023 05 26','  Cash','  General','75.00','2.25','0.00','3.0','35','202305261541',NULL,NULL,NULL,NULL,NULL,NULL),(1869,'20230529-000011','125.66','admin','2023 05 29','  Cash','  General','122.00','3.66','0.00','3.0','36','202305291448',NULL,NULL,NULL,NULL,NULL,NULL),(1870,'20230609-000011','125.66','admin','2023 06 09','  Cash','  General','122.00','3.66','0.00','3.0','37','202306091530',NULL,NULL,NULL,NULL,NULL,NULL),(1871,'20230609-000012','163.77','admin','2023 06 09','  Cash','  General','159.00','0','0.00','3.0','38','202306091530',NULL,NULL,NULL,NULL,NULL,NULL),(1872,'20230630-000011','125.66','admin','2023 06 30','  Cash','  General','122.00','3.66','0.00','3.0','39','202306301359',NULL,NULL,NULL,NULL,NULL,NULL),(1873,'20230630-000012','39.14','admin','2023 06 30','  Cash','  General','38.00','1.14','0.00','3.0','40','202306301359',NULL,NULL,NULL,NULL,NULL,NULL),(1874,'20230630-000013','262.65','admin','2023 06 30','  Cash','  General','255.00','7.65','0.00','3.0','41','202306301359',NULL,NULL,NULL,NULL,NULL,NULL),(1875,'20230803-000011','298.70','admin','2023 08 03','  Cash','  General','290.00','8.70','0.00','3.0','42','202308031541',NULL,NULL,NULL,NULL,NULL,NULL),(1876,'20230803-000012','447.02','admin','2023 08 03','  Cash','  General','434.00','13.02','0.00','3.0','43','202308031541',NULL,NULL,NULL,NULL,NULL,NULL),(1877,'20230803-000013','202.91','admin','2023 08 03','  Cash','  General','197.00','5.91','0.00','3.0','44','202308031541',NULL,NULL,NULL,NULL,NULL,NULL),(1878,'20230817-000011','125.66','admin','2023 08 17','  Cash','  General','122.00','3.66','0.00','3.0','45','202308171130',NULL,NULL,NULL,NULL,NULL,NULL),(1879,'20231008-000011','82.40','admin','2023 10 08','  Cash','  General','80.00','2.40','0.00','3.0','46','202310081921',NULL,NULL,NULL,NULL,NULL,NULL),(1880,'20231022-000011','202.91','admin','2023 10 22','  Cash','  General','197.00','5.91','0.00','3.0','47','202310221256',NULL,NULL,NULL,NULL,NULL,NULL),(1881,'20231102-000011','125.66','admin','2023 11 02','  Cash','  General','122.00','3.66','0.00','3.0','48','202311021157',NULL,NULL,NULL,NULL,NULL,NULL),(1882,'20231125-000011','125.66','admin','2023 11 25','  Cash','  General','122.00','3.66','0.00','3.0','49','202311251146',NULL,NULL,NULL,NULL,NULL,NULL),(1883,'20231130-000011','136.99','admin','2023 11 30','  Cash','  General','133.00','3.99','0.00','3.0','50','202311301448',NULL,NULL,NULL,NULL,NULL,NULL),(1884,'20231228-000011','86.52','admin','2023 12 28','  Cash','  General','84.00','2.52','0.00','3.0','51','202312282352',NULL,NULL,NULL,NULL,NULL,NULL),(1885,'20231228-000012','39.14','admin','2023 12 28','  Cash','  General','38.00','1.14','0.00','3.0','52','202312282353',NULL,NULL,NULL,NULL,NULL,NULL),(1886,'20240112-000011','125.66','admin','2024 01 12','  Cash','  General','122.00','3.66','0.00','3.0','53','202401122351',NULL,NULL,NULL,NULL,NULL,NULL),(1887,'20240112-000012','78.28','admin','2024 01 12','  Cash','  General','76.00','2.28','0.00','3.0','54','202401122351',NULL,NULL,NULL,NULL,NULL,NULL),(1888,'20240112-000013','78.28','admin','2024 01 12','  Cash','  General','76.00','2.28','0.00','3.0','55','202401122352',NULL,NULL,NULL,NULL,NULL,NULL),(1889,'20240112-000014','78.28','admin','2024 01 12','  Cash','  General','76.00','2.28','0.00','3.0','56','202401122352',NULL,NULL,NULL,NULL,NULL,NULL),(1890,'20240212-000011','125.66','admin','2024 02 12','  Cash','  General','122.00','3.66','0.00','3.0','57','202402122107',NULL,NULL,NULL,NULL,NULL,NULL),(1891,'20240212-000012','146.26','admin','2024 02 12','  Cash','  General','142.00','4.26','0.00','3.0','58','202402122107',NULL,NULL,NULL,NULL,NULL,NULL),(1892,'20240220-000011','124.63','admin','2024 02 20','  Cash','  General','121.00','3.63','0.00','3.0','59','202402201349',NULL,NULL,NULL,NULL,NULL,NULL),(1893,'20240220-000012','39.14','admin','2024 02 20','  Cash','  General','38.00','1.14','0.00','3.0','60','202402201349',NULL,NULL,NULL,NULL,NULL,NULL),(1894,'20240725-000011','125.66','admin','2024 07 25','  Cash','  General','122.00','3.66','0.00','3.0','1','202407251408',NULL,NULL,NULL,NULL,NULL,NULL),(1895,'20240725-000012','58.71','admin','2024 07 25','  Cash','  General','57.00','1.71','0.00','3.0','2','202407251408',NULL,NULL,NULL,NULL,NULL,NULL),(1896,'20240725-000013','77.25','admin','2024 07 25','  Cash','  General','75.00','2.25','0.00','3.0','3','202407251408',NULL,NULL,NULL,NULL,NULL,NULL),(1897,'20240826-000011','60.77','admin','2024 08 26','  Cash','  General','59.00','1.77','0.00','3.0','4','202408261325',NULL,NULL,NULL,NULL,NULL,NULL),(1898,'20240826-000012','121.54','admin','2024 08 26','  Cash','  General','118.00','3.54','0.00','3.0','5','202408261326',NULL,NULL,NULL,NULL,NULL,NULL),(1899,'20240826-000013','181.28','admin','2024 08 26','  Cash','  General','176.00','5.28','0.00','3.0','6','202408261327',NULL,NULL,NULL,NULL,NULL,NULL),(1900,'20240826-000014','243.08','admin','2024 08 26','  Cash','  General','236.00','7.08','0.00','3.0','7','202408261328',NULL,NULL,NULL,NULL,NULL,NULL),(1901,'20240826-000015','1.03','admin','2024 08 26','  Cash','  General','1.00','0.03','0.00','3.0','8','202408261328',NULL,NULL,NULL,NULL,NULL,NULL),(1902,'20240828-000011','1.03','admin','2024 08 28','  Cash','  General','1.00','0.03','0.00','3.0','9','202408281046',NULL,NULL,NULL,NULL,NULL,NULL),(1903,'20240828-000012','77.25','admin','2024 08 28','  Cash','  General','75.00','2.25','0.00','3.0','10','202408281046',NULL,NULL,NULL,NULL,NULL,NULL),(1904,'20240828-000013','244.11','admin','2024 08 28','  Cash','  General','237.00','7.11','0.00','3.0','11','202408281140',NULL,NULL,NULL,NULL,NULL,NULL),(1905,'20240831-000011','132.87','admin','2024 08 31','  Cash','  General','129.00','3.87','0.00','3.0','12','202408312005',NULL,NULL,NULL,NULL,NULL,NULL),(1906,'20240903-000011','61.80','admin','2024 09 03','  Cash','  General','60.00','1.80','0.00','3.0','13','202409031244',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `cancelwiseorderlistitems` (`_id`, `date`, `time`, `user`, `billno`, `sale`, `refund`, `reason`, `billcount`) VALUES (1,'02 Oct 2020','12:16:17 PM','admin','20201002-000011','587.10','389.97998','Changed mind','1582'),(2,'03 Apr 2021','12:02:34 PM','admin','20210403-000013','42.56','42.56','Changed mind',NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `cusotmer_activity_temp` (`_id`, `name`, `phone_no`, `email`, `addr`, `total_amount`, `balance`, `discount_value`, `discount_type`, `approval_rate`) VALUES (11,'viraf','9701160863','','fgh','673.1','0.0',NULL,NULL,'50.0'),(12,'kannan','9886289283','','hsr','1558.0','-300.0',NULL,NULL,'100.0'),(21,'Bharat Kumar','9036291285','bharat@gmail.com','Bangalore','354.0','59.0',NULL,NULL,'100.0'),(25,'ismail','9591298763','','hsr','159.0','0.0',NULL,NULL,NULL),(26,'vinayak ','9986688896','','hsr','957.5','-3882.0',NULL,NULL,NULL),(29,'RUSHIKESH CHIMBALKAR','8087596033','dgnxmens@gmail.com','saswad','2115.9','0.0',NULL,NULL,'87.2'),(30,'bhushan','9986655589','','mumbai','32.0','0.0',NULL,NULL,NULL),(32,'','9986688896','','','1020.5','-3882.0',NULL,NULL,NULL),(33,'','8087596033','','','2147.4','0.0',NULL,NULL,'87.2'),(34,'','9036291285','','','16104.0','59.0',NULL,NULL,'100.0'),(35,'pravin panchal','9227430444','kavicom@hotmail.com','Ramjipura, sidhpur','0.0','0.0',NULL,NULL,NULL),(37,'','8087596033','','','2314.4','-5000.0',NULL,NULL,'87.2'),(40,'vinayak ','9986688896','','hsr','1147.6','-3754.9',NULL,NULL,NULL),(42,'','8464006000','','','178.5','0.0',NULL,NULL,NULL),(43,'vin','9986688896','','','1414.3','-3488.3',NULL,NULL,NULL),(44,'employees ','123456789','','','0.0','0.0',NULL,NULL,NULL),(45,'employers ','9986688852','','','0.0','0.0',NULL,NULL,NULL),(47,'','9986688896','','','1619.0','-3488.3',NULL,NULL,NULL);
INSERT INTO `cusotmer_activity_temp_top3` (`_id`, `name`, `phone_no`, `email`, `addr`, `total_amount`, `balance`, `discount_value`, `discount_type`, `approval_rate`) VALUES (26,'vinayak ','9986688896','','hsr',444,'-3882.0',NULL,NULL,NULL),(30,'bhushan','9986655589','','mumbai',32,'0.0',NULL,NULL,NULL),(31,'','9986688896','','',32,'-3882.0',NULL,NULL,NULL),(32,'','9986688896','','',63,'-3882.0',NULL,NULL,NULL),(33,'','8087596033','','',32,'0.0',NULL,NULL,'87.2'),(34,'','9036291285','','',15750,'59.0',NULL,NULL,'100.0'),(37,'','8087596033','','',167,'-5000.0',NULL,NULL,'87.2'),(38,'','9028618880','','',908,'0.0',NULL,NULL,NULL),(39,'','9028618880','','',1035,'0.0',NULL,NULL,NULL),(40,'vinayak ','9986688896','','hsr',127,'-3754.9',NULL,NULL,NULL),(42,'','8464006000','','',179,'0.0',NULL,NULL,NULL),(43,'vin','9986688896','','',267,'-3488.3',NULL,NULL,NULL),(46,'','9986688896','','',122,'-3488.3',NULL,NULL,NULL),(47,'','9986688896','','',83,'-3488.3',NULL,NULL,NULL),(49,'vinayak ','9986688896','','hsr',250,'-3240.3',NULL,NULL,NULL);
INSERT INTO `cust_feedback` (`_id`, `cust_name`, `date`, `time`, `ambience_rating`, `pro_qual_rating`, `service_rating`, `overall_exp_rating`, `comments`, `percentage`, `cust_phoneno`) VALUES (1,'viraf','2020 01 18','01:09:35 PM','5.0','5.0','0.0','0.0','','50.0','9701160863'),(2,'RUSHIKESH CHIMBALKAR','2020 02 04','03:43:48 PM','5.0','5.0','5.0','5.0','','100.0','8087596033'),(3,'RUSHIKESH CHIMBALKAR','2020 02 08','02:06:36 PM','5.0','5.0','5.0','5.0','','100.0','8087596033'),(4,'RUSHIKESH CHIMBALKAR','2020 03 17','11:51:56 AM','5.0','5.0','5.0','5.0','','100.0','8087596033'),(5,'kannan','2020 04 03','11:28:25 AM','5.0','5.0','5.0','5.0','','100.0','9886289283'),(6,'RUSHIKESH CHIMBALKAR','2020 04 25','04:40:34 PM','5.0','5.0','5.0','5.0','','100.0','8087596033'),(7,'RUSHIKESH CHIMBALKAR','2020 04 25','06:38:59 PM','5.0','5.0','5.0','5.0','','100.0','8087596033'),(8,'kannan','2020 04 25','06:39:06 PM','5.0','5.0','5.0','5.0','','100.0','9886289283'),(9,'RUSHIKESH CHIMBALKAR','2020 05 05','04:29:57 PM','5.0','5.0','5.0','5.0','','100.0','8087596033'),(10,'RUSHIKESH CHIMBALKAR','2020 05 05','04:46:54 PM','5.0','5.0','5.0','5.0','','100.0','8087596033'),(11,'RUSHIKESH CHIMBALKAR','2020 05 20','12:23:26 PM','5.0','5.0','5.0','5.0','','100.0','8087596033'),(12,'RUSHIKESH CHIMBALKAR','2020 05 24','11:18:44 AM','5.0','5.0','5.0','5.0','','100.0','8087596033'),(13,'RUSHIKESH CHIMBALKAR','2020 05 29','12:06:21 PM','5.0','5.0','5.0','5.0','','100.0','8087596033'),(14,'RUSHIKESH CHIMBALKAR','2020 06 03','11:24:17 AM','5.0','5.0','0.0','0.0','','50.0','8087596033'),(15,'RUSHIKESH CHIMBALKAR','2020 06 05','11:43:23 AM','5.0','5.0','5.0','5.0','','100.0','8087596033'),(16,'RUSHIKESH CHIMBALKAR','2020 06 09','04:04:41 PM','5.0','5.0','5.0','5.0','','100.0','8087596033'),(17,'RUSHIKESH CHIMBALKAR','2020 06 14','08:14:15 PM','5.0','5.0','5.0','5.0','','100.0','8087596033'),(18,'RUSHIKESH CHIMBALKAR','2020 06 19','02:33:37 PM','5.0','5.0','5.0','5.0','','100.0','8087596033'),(19,'RUSHIKESH CHIMBALKAR','2020 06 23','07:15:01 AM','5.0','5.0','5.0','5.0','','100.0','8087596033'),(20,'RUSHIKESH CHIMBALKAR','2020 06 24','03:30:30 PM','5.0','5.0','5.0','5.0','','100.0','8087596033'),(21,'RUSHIKESH CHIMBALKAR','2020 06 24','09:04:11 PM','5.0','5.0','5.0','5.0','','100.0','8087596033'),(22,'RUSHIKESH CHIMBALKAR','2020 06 30','03:26:30 PM','5.0','5.0','5.0','5.0','','100.0','8087596033'),(23,'RUSHIKESH CHIMBALKAR','2020 07 07','12:23:11 PM','5.0','5.0','5.0','5.0','','100.0','8087596033'),(24,'RUSHIKESH CHIMBALKAR','2020 07 10','10:22:06 AM','5.0','5.0','5.0','5.0','','100.0','8087596033'),(25,'RUSHIKESH CHIMBALKAR','2020 07 11','12:21:28 PM','5.0','5.0','5.0','5.0','','100.0','8087596033'),(26,'Bharat Kumar','2020 07 11','12:21:35 PM','5.0','5.0','5.0','5.0','','100.0','9036291285'),(27,'RUSHIKESH CHIMBALKAR','2020 07 12','04:12:40 PM','5.0','5.0','5.0','5.0','','100.0','8087596033'),(28,'RUSHIKESH CHIMBALKAR','2020 07 17','02:49:56 PM','5.0','5.0','5.0','5.0','','100.0','8087596033'),(29,'RUSHIKESH CHIMBALKAR','2020 07 18','05:14:27 PM','5.0','5.0','5.0','5.0','','100.0','8087596033'),(30,'RUSHIKESH CHIMBALKAR','2020 07 25','11:13:55 AM','5.0','5.0','5.0','5.0','','100.0','8087596033'),(31,'RUSHIKESH CHIMBALKAR','2020 07 28','01:43:13 PM','5.0','0.0','0.0','0.0','','25.0','8087596033'),(32,'RUSHIKESH CHIMBALKAR','2020 07 30','04:51:52 PM','5.0','5.0','5.0','5.0','','100.0','8087596033'),(33,'RUSHIKESH CHIMBALKAR','2020 07 31','12:32:10 PM','5.0','5.0','5.0','5.0','','100.0','8087596033'),(34,'RUSHIKESH CHIMBALKAR','2020 08 08','03:20:57 PM','5.0','5.0','5.0','5.0','','100.0','8087596033'),(35,'RUSHIKESH CHIMBALKAR','2020 08 14','11:52:19 AM','5.0','5.0','5.0','5.0','','100.0','8087596033'),(36,'RUSHIKESH CHIMBALKAR','2020 08 20','04:35:47 PM','5.0','0.0','0.0','0.0','','25.0','8087596033'),(37,'RUSHIKESH CHIMBALKAR','2020 08 21','02:18:56 PM','5.0','5.0','0.0','0.0','','50.0','8087596033'),(38,'RUSHIKESH CHIMBALKAR','2020 08 24','12:18:22 PM','5.0','5.0','0.0','0.0','','50.0','8087596033'),(39,'RUSHIKESH CHIMBALKAR','2020 09 19','04:52:45 PM','5.0','5.0','0.0','0.0','','50.0','8087596033'),(40,'RUSHIKESH CHIMBALKAR','2020 12 08','11:10:48 AM','5.0','5.0','0.0','0.0','','50.0','8087596033'),(41,'RUSHIKESH CHIMBALKAR','2020 12 11','07:30:42 PM','5.0','0.0','0.0','0.0','','25.0','8087596033'),(42,'','2022 01 04','01:31:18 PM','5.0','5.0','0.0','0.0','','50.0','8087596033'),(43,'employees ','2022 01 25','01:48:54 PM','5.0','5.0','0.0','0.0','','50.0','123456789');
INSERT INTO `customer_loyalty_points` (`_id`, `phoneno`, `points`) VALUES (2,'9701160863','356.60'),(5,'9701160863','356.60'),(8,'9701160863','356.60'),(14,'9701160863','6.73'),(15,'9886289283','15.57'),(19,'9701160863','1.34'),(20,'9886289283','3.12'),(22,'9986655598','0.12'),(26,'9591298763','1.59'),(27,'9701160863','6.73'),(28,'9886289283','15.57'),(29,'9986688896','2.51');
INSERT INTO `discountdetails` (`_id`, `date`, `time`, `billno`, `Discountcodeno`, `Discount_percent`, `Billamount_rupess`, `Discount_rupees`, `date1`, `original_amount`, `billcount`, `datetimee_new`, `paymentmethod`) VALUES (1,'2018 11 22','03:11:37 PM','20181122-000018','Inagural','11.25','250','30','22 Nov 2018','280.00','21','201811221511',NULL),(2,'2018 11 22','06:03:35 PM','20181122-0000117','dd','10','271.43','28.57','22 Nov 2018','300.00','30','201811221803',NULL),(3,'2018 11 22','10:00:09 PM','20181122-0000164','gg','19.09','180','40','22 Nov 2018','220.00','77','201811222200',NULL),(4,'2018 11 23','12:49:28 PM','20181123-000012','gg','3.39','300','10','23 Nov 2018','310.00','94','201811231249',NULL),(5,'2018 11 24','07:35:10 PM','20181124-0000130','gg','10','144.76','15.24','24 Nov 2018','160.00','255','201811241935',NULL),(6,'2018 11 24','08:39:12 PM','20181124-0000137','hhj','10','334.77','35.24','24 Nov 2018','370.01','268','201811242039',NULL),(7,'2018 11 24','08:56:19 PM','20181124-000023','hhh','10','1800.48','189.52','24 Nov 2018','1990.00','276','201811242056',NULL),(8,'2018 11 24','10:35:42 PM','20181124-000053','kashu','10','438.36','46.64','24 Nov 2018','485.00','303','201811242235',NULL),(9,'2018 11 25','03:04:32 PM','20181125-000092','hhh','5','752.38','37.62','25 Nov 2018','790.00','347','201811251504',NULL),(10,'2018 11 26','03:43:57 PM','20181126-0000113','ggh','10','108.57','11.43','26 Nov 2018','120.00','516','201811261543',NULL),(11,'2018 11 26','10:45:32 PM','20181126-0000150','ggg','10','117.62','12.38','26 Nov 2018','130.00','576','201811262245',NULL),(12,'2018 11 29','10:12:27 PM','20181129-000086','12345','20','97.14','22.86','29 Nov 2018','120.00','827','201811292212',NULL),(13,'2018 11 30','02:25:25 PM','20181130-000041','12345','10','800.00','85.03','30 Nov 2018','885.03','850','201811301425',NULL),(14,'2018 11 30','04:27:20 PM','20181130-000061','q','5','352.31','17.69','30 Nov 2018','370.00','857','201811301627',NULL),(15,'2018 11 30','06:22:28 PM','20181130-000052','q','10','867.02','93.00','30 Nov 2018','960.02','866','201811301822',NULL),(16,'2018 11 30','09:26:14 PM','20181130-000132','q','10','217.15','22.86','30 Nov 2018','240.01','920','201811302126',NULL),(17,'2018 12 01','11:05:58 PM','20181201-0000310','q','20','218.58','51.43','01 Dec 2018','270.01','1080','201812012305',NULL),(18,'2018 12 02','02:14:04 PM','20181202-0000111','q','5','304.76','15.24','02 Dec 2018','320.00','1108','201812021414',NULL),(19,'2018 12 02','03:52:44 PM','20181202-0000124','q','10','36.00','4.00','02 Dec 2018','40.00','1148','201812021552',NULL),(20,'2018 12 02','07:25:47 PM','20181202-000063','a','5','2457.20','122.86','02 Dec 2018','2580.06','1179','201812021925',NULL),(21,'2018 12 02','09:47:40 PM','20181202-000154','q','10','2198.06','231.90','02 Dec 2018','2429.96','1234','201812022147',NULL),(22,'2018 12 03','10:00:12 PM','20181203-0000130','q','25','121.90','38.10','03 Dec 2018','160.00','1321','201812032200',NULL),(23,'2019 12 06','12:20:05 PM','20191206-000014','abc','10.00','180','20','06 Dec 2019','200.00',NULL,'201912061220',NULL);
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'Agrawals dhokla mix 500gm',59),(2,'Chocolate pastry',150),(3,'aachi chilli powder 200gm',252),(4,'aachi coriander powder 100gm',38),(5,'aashirvad atta multigrains 1kg',104),(6,'aachi coriander powder 200gm',75),(7,'aachi turmeric powder 100gm',32),(8,'aachi turmeric powder 200gm',63),(9,'aashirvad atta multigrains 1kg',260),(10,'aashirvad atta multigrains 5kg',510),(11,'aashirvad whole wheat atta 1kg',46),(12,'coca cola 2ltr',76),(13,'dabur lemon juice 250ml',66),(14,'nutella',170),(15,'daily bread milk bread 400g',30),(16,'eggs 6pcs',38),(17,'nutella',170),(18,'akar salt crystal 1kg',17),(19,'almond/badam 500gm',605),(20,'aluminium foil',57),(21,'amla',40),(22,'annkoot hing 10gm',21),(23,'appy fizz 1ltr',52),(24,'banana yelakki kg',88),(25,'beans kg',40),(26,'beet root kg',32),(27,'best basmati rice 5kg',375),(28,'bnatural mixed 200ml',19),(29,'britannia cake fruity fun 65g',15),(30,'carrots kg',70),(31,'coca cola 2ltr',76),(32,'coca cola 750ml',33),(33,'coca cola zero 500ml',35),(34,'crocin 500',22),(35,'dabur keora water 250ml',41),(36,'daily bread milk bread 400g',30),(37,'dove soap 3pack',175),(38,'eggs 12pcs',76),(39,'eggs 6pcs',38),(40,'eggs country duck 6pcs',70),(41,'elite bar cake chocolate 150g',27),(42,'english muffins 100g',69),(43,'hot dog bun 150g',30),(44,'liril soap 75gm',28),(45,'menthya greens',87),(46,'tin foil',50),(47,'water can',30090),(48,'eggs 6pcs',38),(49,'eggs country duck 6pcs',70),(50,'elite bar cake chocolate 150g',27),(51,'english muffins 100g',69),(52,'figs 100gm',88),(53,'flax seeds 200gm',34),(54,'hot dog bun 150g',90),(55,'liril soap 75gm',28),(56,'menthya greens',87),(57,'milk bread 300g',35),(58,'ragi 500g',19),(59,'tin foil',50),(60,'water can',30090);
INSERT INTO `itemwiseorderlistcategory` (`_id`, `itemno`, `categoryname`, `sales`, `salespercentage`, `itemtotalquan`) VALUES (1,NULL,'None',2558,17,'42'),(2,NULL,'Renamed',8145,55,'11'),(3,NULL,'dals & pulses',76,1,'1'),(4,NULL,'flours & sooji',479,3,'4'),(5,NULL,'fruits & vegetables',202,1,'3'),(6,NULL,'masalas & spices',2985,20,'55'),(7,NULL,'rice & whole grains',100,1,'1'),(8,NULL,'salt & sugar',17,0,'1');
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,'1014','Agrawals dhokla mix 500gm',59,9,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'460','Chocolate pastry',150,22,'2','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'1438','aachi chilli powder 200gm',252,37,'3','masalas & spices',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'990','aachi coriander powder 100gm',38,6,'1','masalas & spices',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'1416','aashirvad atta multigrains 1kg',104,15,'2','flours & sooji',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'1426','aachi coriander powder 200gm',75,3,'1','masalas & spices',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'1450','aachi turmeric powder 100gm',32,2,'1','masalas & spices',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'1451','aachi turmeric powder 200gm',63,3,'1','masalas & spices',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'1416','aashirvad atta multigrains 1kg',260,12,'5','flours & sooji',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'1417','aashirvad atta multigrains 5kg',510,23,'2','flours & sooji',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'1385','aashirvad whole wheat atta 1kg',46,2,'1','flours & sooji',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'145','coca cola 2ltr',76,7,'1','beverages',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'155','dabur lemon juice 250ml',66,6,'1','beverages',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'3','nutella',170,15,'1','branded foods',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'434','daily bread milk bread 400g',30,2,'1','bread bakery & eggs',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'306','eggs 6pcs',38,2,'1','bread bakery & eggs',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'3','nutella',170,10,'1','branded foods',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'62','akar salt crystal 1kg',17,0,'1','salt and sugar',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'975','almond/badam 500gm',605,1,'1','dry fruits',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'495','aluminium foil',57,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'538','amla',40,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'993','annkoot hing 10gm',21,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'120','appy fizz 1ltr',52,0,'1','beverages',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'24','banana yelakki kg',88,0,'1','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'9','beans kg',40,0,'1','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'13','beet root kg',32,0,'1','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'1300','best basmati rice 5kg',375,1,'1','rice and whole grains',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'173','bnatural mixed 200ml',19,0,'1','beverages',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'1544','britannia cake fruity fun 65g',15,0,'1','bread bakery and eggs',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'7','carrots kg',70,0,'1','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,'145','coca cola 2ltr',76,0,'1','beverages',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,'147','coca cola 750ml',33,0,'1','beverages',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,'109','coca cola zero 500ml',35,0,'1','beverages',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,'1599','crocin 500',22,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,'144','dabur keora water 250ml',41,0,'1','beverages',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,'434','daily bread milk bread 400g',30,0,'1','bread bakery and eggs',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,'247','dove soap 3pack',175,0,'1','personal care',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'573','eggs 12pcs',76,0,'1','bread bakery and eggs',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,'306','eggs 6pcs',38,0,'1','bread bakery and eggs',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'1123','eggs country duck 6pcs',70,0,'1','bread bakery and eggs',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'1546','elite bar cake chocolate 150g',27,0,'1','bread bakery and eggs',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(42,'305','english muffins 100g',69,0,'1','bread bakery and eggs',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,'1542','hot dog bun 150g',30,0,'1','bread bakery and eggs',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,'256','liril soap 75gm',28,0,'1','personal care',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(45,'585','menthya greens',87,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(46,'585','tin foil',50,0,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(47,'1600','water can',30090,65,'1003','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(48,'306','eggs 6pcs',38,0,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(49,'1123','eggs country duck 6pcs',70,0,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(50,'1546','elite bar cake chocolate 150g',27,0,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(51,'305','english muffins 100g',69,0,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52,'1365','figs 100gm',88,0,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(53,'1373','flax seeds 200gm',34,0,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(54,'1542','hot dog bun 150g',90,0,'3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(55,'256','liril soap 75gm',28,0,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(56,'585','menthya greens',87,0,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(57,'431','milk bread 300g',35,0,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(58,'1288','ragi 500g',19,0,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(59,'1288','tin foil',50,0,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(60,'1600','water can',30090,62,'1003',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (5533,'None',209),(5534,'flours & sooji',104),(5535,'masalas & spices',290),(5538,'flours & sooji',104),(5539,'masalas & spices',75),(5540,'None',327),(5541,'flours & sooji',816),(5542,'masalas & spices',814),(5553,NULL,0),(5554,'flours & sooji',1204),(5555,'household',22),(5556,'masalas & spices',247),(5557,NULL,0),(5558,'flours & sooji',52),(5559,'masalas & spices',63),(5560,'None',89),(5561,'dals & pulses',99),(5562,'flours & sooji',85),(5563,'household',104),(5564,'masalas & spices',101),(5565,'masalas & spices',175),(5569,'None',331),(5570,'masalas & spices',148),(5571,'personal care',60),(5572,'None',116),(5573,'personal care',60),(5574,'None',411),(5575,'masalas & spices',101),(5576,'personal care',60),(5579,'None',77),(5580,'fruits & vegetables',101),(5581,'rice & whole grains',100),(5582,'personal care',156),(5583,'Adults',600),(5584,'Kids',500),(5585,'None',264),(5586,'salt & sugar',18),(5587,'Adults',600),(5588,'Kids',500),(5589,'None',264),(5590,'dairy products',445),(5591,'salt & sugar',18),(5592,'Adults',799),(5593,'Kids',500),(5594,'masalas & spices',63),(5595,'Adults',799),(5596,'Kids',500),(5597,'masalas & spices',63),(5598,'Kids',250),(5599,'None',95),(5600,'Adults',400),(5601,'beverages',19),(5602,'flours & sooji',52),(5603,'masalas & spices',63),(5604,'Adults',1000),(5605,'Kids',1000),(5606,'beverages',19),(5607,'flours & sooji',52),(5608,'masalas & spices',100),(5609,'None',59),(5610,'flours & sooji',329),(5611,'masalas & spices',32),(5612,'salt & sugar',18),(5613,'Adults',300),(5614,'Kids',1197),(5615,'flours & sooji',52),(5616,'masalas & spices',32),(5617,'Adults',400),(5618,'Kids',400),(5619,'masalas & spices',23),(5620,'personal care',82),(5622,'Adults',2497),(5623,NULL,0),(5624,'None',95),(5625,'masalas & spices',347),(5626,'None',20),(5627,'flours & sooji',52),(5628,'masalas & spices',37),(5631,'dry fruits',915),(5632,'dry fruits',915),(5633,'masalas & spices',37),(5634,'rice & whole grains',56),(5635,'None',95),(5636,'fruits & vegetables',7),(5637,'masalas & spices',242),(5641,'None',95),(5642,'fruits & vegetables',7),(5643,'masalas & spices',242),(5673,'None',138),(5674,'branded foods',170),(5675,'bread bakery & eggs',68),(5676,'flours & sooji',409),(5677,'fruits & vegetables',32),(5678,'masalas & spices',474),(5686,'None',138),(5687,'branded foods',170),(5688,'bread bakery & eggs',68),(5689,'dairy products',180),(5690,'flours & sooji',409),(5691,'fruits & vegetables',32),(5692,'masalas & spices',549),(5693,'None',77),(5694,'masalas & spices',122),(5697,'flours & sooji',305),(5698,'masalas & spices',122),(5699,'flours & sooji',52),(5700,'masalas & spices',168),(5701,'flours & sooji',52),(5702,'masalas & spices',235),(5703,'flours & sooji',307),(5704,'masalas & spices',273),(5711,'None',134),(5712,'masalas & spices',122),(5713,'None',134),(5714,'masalas & spices',160),(5715,'None',134),(5716,'masalas & spices',122),(5717,'None',59),(5718,'masalas & spices',242),(5719,'None',75),(5720,'masalas & spices',37),(5721,'None',75),(5722,'masalas & spices',37),(5723,'None',175),(5724,'dry fruits',605),(5725,'None',57),(5726,'flours & sooji',98),(5727,'masalas & spices',244),(5728,'masalas & spices',23),(5729,'None',20),(5730,'masalas & spices',107),(5731,'beverages',139),(5732,'masalas & spices',38),(5733,'personal care',203),(5735,'masalas and spices',32),(5736,'flours and sooji',255),(5737,'masalas and spices',133),(5738,'None',331),(5739,'flours and sooji',255),(5740,'masalas and spices',237),(5741,'None',408),(5742,'flours and sooji',307),(5743,'masalas and spices',237),(5744,'None',22),(5745,'None',22),(5746,'flours and sooji',307),(5747,'masalas and spices',84),(5748,'None',30),(5749,'flours and sooji',307),(5750,'masalas and spices',84),(5751,'None',30090),(5752,'flours and sooji',307),(5753,'masalas and spices',84),(5754,'flours and sooji',312),(5755,'masalas and spices',506),(5756,'flours and sooji',312),(5757,'masalas and spices',506),(5758,'None',20),(5759,'flours and sooji',52),(5760,'masalas and spices',75),(5770,'None',30875),(5771,'flours and sooji',1030),(5772,'masalas and spices',1161),(5773,'None',20),(5774,'flours and sooji',52),(5775,'masalas and spices',176),(5781,'None',132),(5782,'flours and sooji',52),(5783,'fruits and vegetables',110),(5784,'masalas and spices',345),(5785,'salt and sugar',17),(5786,'None',20),(5787,'masalas and spices',75),(5788,'None',20),(5789,'masalas and spices',234),(5790,'None',20),(5791,'masalas and spices',234),(5792,'None',20),(5793,'masalas and spices',461),(5794,'None',59),(5795,'flours and sooji',255),(5796,'masalas and spices',75),(5797,'None',146),(5798,'flours and sooji',307),(5799,'masalas and spices',338),(5802,'flours and sooji',52),(5803,'masalas and spices',38),(5804,'beverages',117),(5805,'flours and sooji',52),(5806,'masalas and spices',113),(5807,'beverages',117),(5808,'flours and sooji',52),(5809,'masalas and spices',113),(5810,'beverages',117),(5811,'flours and sooji',52),(5812,'masalas and spices',113),(5816,'None',245),(5817,'masalas and spices',533),(5818,'rice and whole grains',375),(5819,'None',245),(5820,'masalas and spices',533),(5821,'rice and whole grains',375),(5822,'flours and sooji',52),(5823,'fruits and vegetables',88),(5824,'masalas and spices',197),(5825,'None',20),(5826,'fruits and vegetables',32),(5827,'masalas and spices',903),(5828,'None',20),(5829,'fruits and vegetables',32),(5830,'masalas and spices',1024),(5831,'masalas and spices',113),(5832,'flours and sooji',52),(5833,'masalas and spices',122),(5836,'flours and sooji',52),(5837,'masalas and spices',122),(5838,'flours and sooji',104),(5839,'masalas and spices',381),(5840,'flours and sooji',104),(5841,'masalas and spices',381),(5842,'flours and sooji',104),(5843,'masalas and spices',381),(5855,NULL,0),(5856,'None',32496),(5857,'beverages',256),(5858,'bread bakery and eggs',355),(5859,'dry fruits',605),(5860,'flours and sooji',1851),(5861,'fruits and vegetables',230),(5862,'masalas and spices',6811),(5863,'personal care',203),(5864,'rice and whole grains',375),(5865,'salt and sugar',17),(5866,'None',150),(5867,'masalas and spices',159),(5868,'None',150),(5869,'masalas and spices',222),(5870,'None',650),(5871,'masalas and spices',222),(5872,'None',750),(5873,'masalas and spices',222),(5874,'None',75),(5875,'flours and sooji',52),(5876,'masalas and spices',38),(5877,'flours and sooji',52),(5878,'masalas and spices',101),(5879,'flours and sooji',52),(5880,'masalas and spices',100),(5883,'flours and sooji',52),(5884,'masalas and spices',100),(5885,'dry fruits',210),(5886,'None',10),(5887,'dairy products',755),(5888,'dry fruits',210),(5890,'bread bakery and eggs',75),(5891,'bread bakery and eggs',65),(5892,'personal care',90),(5893,'rice and whole grains',19),(5894,'bread bakery and eggs',65),(5895,'personal care',90),(5896,'rice and whole grains',19),(5897,'bread bakery and eggs',65),(5898,'personal care',90),(5899,'rice and whole grains',19),(5900,'None',100),(5901,'masalas and spices',107),(5904,NULL,0),(5905,'None',33222),(5906,'beverages',256),(5907,'bread bakery and eggs',495),(5908,'dairy products',755),(5909,'dry fruits',815),(5910,'flours and sooji',1903),(5911,'fruits and vegetables',230),(5912,'masalas and spices',7025),(5913,'personal care',293),(5914,'rice and whole grains',394),(5915,'salt and sugar',17),(5916,'None',79),(5917,'dairy products',65),(5918,'fruits and vegetables',160),(5919,'masalas and spices',302),(5920,'personal care',79),(5922,'cement',700),(5923,'masalas and spices',121),(5924,'fruits and vegetables',250),(5925,'masalas and spices',121),(5926,'fruits and vegetables',250),(5927,'masalas and spices',121),(5928,'None',20),(5929,'branded foods',170),(5930,'flours and sooji',381),(5931,'masalas and spices',291),(5932,'None',20),(5933,'branded foods',170),(5934,'flours and sooji',381),(5935,'masalas and spices',438),(5940,'None',40),(5941,'branded foods',170),(5942,'flours and sooji',381),(5943,'masalas and spices',673),(5944,'None',40),(5945,'branded foods',170),(5946,'flours and sooji',381),(5947,'masalas and spices',673),(5952,'None',120),(5953,'branded foods',170),(5954,'flours and sooji',381),(5955,'masalas and spices',785),(5960,'None',1249),(5961,'branded foods',170),(5962,'bread bakery and eggs',140),(5963,'cement',700),(5964,'dairy products',820),(5965,'dry fruits',210),(5966,'flours and sooji',641),(5967,'fruits and vegetables',410),(5968,'masalas and spices',5210),(5969,'personal care',169),(5970,'rice and whole grains',19),(5971,'None',95),(5972,'masalas and spices',182),(5975,'None',95),(5976,'masalas and spices',182),(5977,'bread bakery and eggs',146),(5978,'masalas and spices',60),(5979,'bread bakery and eggs',30),(5980,'dairy products',670),(5981,'bread bakery and eggs',30),(5982,'chicken',1540),(5983,'dairy products',670),(5984,'bread bakery and eggs',30),(5985,'chicken',1540),(5986,'dairy products',670),(5990,'None',105),(5991,'branded foods',170),(5992,'cement',350),(5993,'dals and pulses',149),(5994,'garments',100),(5995,'masalas and spices',121),(5996,'None',134),(5997,'flours and sooji',52),(5998,'masalas and spices',196),(5999,'masalas and spices',52),(6000,'None',75),(6001,'flours and sooji',52),(6002,'masalas and spices',122),(6013,'branded foods',170),(6014,'flours and sooji',52),(6015,'household',33),(6016,'masalas and spices',153),(6017,'rice and whole grains',67),(6018,'masalas and spices',60),(6019,'flours and sooji',52),(6020,'masalas and spices',121),(6021,'flours and sooji',52),(6022,'masalas and spices',147),(6023,'None',75),(6024,'masalas and spices',147),(6025,'None',150),(6026,'masalas and spices',216),(6027,'masalas and spices',184),(6029,'None',57),(6030,'flours and sooji',52),(6031,'masalas and spices',368),(6032,'masalas and spices',132),(6064,'flours and sooji',52),(6065,'masalas and spices',84),(6066,'flours and sooji',52),(6067,'masalas and spices',122),(6068,'None',59),(6069,'flours and sooji',52),(6070,'masalas and spices',254),(6071,'None',116),(6072,'flours and sooji',52),(6073,'masalas and spices',418),(6074,'None',116),(6075,'flours and sooji',52),(6076,'masalas and spices',418),(6077,'None',75),(6078,'masalas and spices',100),(6092,'None',75),(6093,'flours and sooji',209),(6094,'masalas and spices',84),(6095,'None',75),(6096,'masalas and spices',55),(6097,'None',225),(6098,'masalas and spices',92),(6099,'None',225),(6100,'masalas and spices',92),(6103,'None',100),(6104,'masalas and spices',121),(6106,'masalas and spices',60),(6109,'None',534),(6110,'flours and sooji',52),(6111,'masalas and spices',774),(6112,'None',3750),(6113,'bread bakery and eggs',222),(6114,'None',116),(6115,'None',154),(6116,'masalas and spices',61),(6117,'beverages',60),(6118,'dals and pulses',80),(6119,'None',377),(6120,'masalas and spices',75),(6121,'None',3),(6122,'masalas and spices',23),(6125,'None',59),(6126,'masalas and spices',206),(6127,'None',57),(6128,'masalas and spices',23),(6129,'masalas and spices',23),(6130,'None',767),(6131,'None',1),(6132,'masalas and spices',75),(6133,'None',238),(6134,'masalas and spices',75),(6135,'None',1),(6136,'beverages',128),(6137,'None',60);
INSERT INTO `top_reason` (`_id`, `reason`, `value`) VALUES (1,'Changed mind',1),(2,'Changed mind',1),(3,'Changed mind',1),(5,'Changed mind',1),(6,'Changed mind',1),(7,'Changed mind',2);
INSERT INTO `usercancelleddata` (`_id`, `username`, `total`) VALUES (1,'admin',389);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',675);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',675,100);
