(1785,0,4,1,1,2,1,10,10,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1786,0,4,1,1,2,1,2,2,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1787,0,4,1,1,2,1,10819.5,10819.5,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1788,0,4,1,1,2,1,1,1,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1789,0,4,1,1,2,1,1,1,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1790,0,4,1,1,2,1,1,1,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1791,0,4,1,1,2,1,17280,17280,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1792,0,4,1,1,2,1,1,1,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1793,0,4,1,1,2,1,19385,19385,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1794,0,4,1,1,2,1,1890,1890,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1795,0,4,1,1,2,1,27812,27812,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1796,0,4,1,1,2,1,1,1,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1797,0,4,1,1,2,1,1,1,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1798,0,4,1,1,2,1,8400,8400,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1799,0,4,1,1,2,1,17100,17100,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1800,0,4,1,1,2,1,14040,14040,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1801,0,4,1,1,2,1,6530,6530,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1802,0,4,1,1,2,1,590,590,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1803,0,4,1,1,2,1,23620,23620,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1804,0,4,1,1,2,1,17100,17100,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1805,0,4,1,1,2,1,2600,2600,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1806,0,4,1,1,2,1,64205,64205,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1807,0,4,1,1,2,1,2,2,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1808,0,4,1,1,2,1,6780,6780,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1809,0,4,1,1,2,1,1,1,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1810,0,4,1,1,2,1,9,9,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1811,0,4,1,1,2,1,1,1,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1812,0,4,1,1,2,1,1,1,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1813,0,4,1,1,2,1,1,1,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1814,0,4,1,1,2,1,30,30,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1815,0,4,1,1,2,1,1560,1560,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1816,0,4,1,1,2,1,1400,1400,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1817,0,4,1,1,2,1,15986,15986,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1818,0,4,1,1,2,1,169.2,169.2,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1819,0,4,1,1,2,1,990,990,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1820,0,4,1,1,2,1,62112,62112,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1821,0,4,1,1,2,1,1046,1046,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1822,0,4,1,1,2,1,9054,9054,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1823,0,4,1,1,2,1,14880,14880,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1824,0,4,1,1,2,1,120440,120440,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1825,0,4,1,1,2,1,47600,47600,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1826,0,4,1,1,2,1,63700,63700,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1827,0,4,1,1,2,1,1,1,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1828,0,4,1,1,2,1,40,40,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1829,0,4,1,1,2,1,33,33,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1830,0,4,1,1,2,1,12,12,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1831,0,4,1,1,2,1,38200,38200,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1832,0,4,1,1,2,1,4800,4800,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1833,0,4,1,1,2,1,16500,16500,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1834,0,4,1,1,2,1,6310,6310,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"BALANCE",1623,NULL,"BALANCE",0,NULL,"2023-08-07",NULL,"2023-08-07 14:29:11",NULL,639,NULL,0),
(1835,0,5,1,147,2,1,5935,5935,1,0,0,0,0,0,0,0,5935,5935,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2023-08-17","2023-08-17",NULL,"2023-08-17 11:57:55",NULL,634,0),
(1836,0,5,1,148,2,1,200,200,1,0,0,NULL,0,0,0,0,200,200,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,639,"2023-08-21","2023-08-21",NULL,NULL,NULL,NULL,0),
(1837,0,5,1,1,2,1,200,200,1,0,0,NULL,0,0,0,0,200,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,639,"2023-08-21","2023-08-21",NULL,NULL,NULL,NULL,0),
(1838,0,3,1,1,2,1,200,200,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,951,NULL,NULL,"POS Payment",0,639,"2023-08-21",NULL,NULL,NULL,NULL,NULL,0),
(1839,0,5,1,42,2,1,12297,12297,1,0,8198,NULL,0,0,0,0,12297,-7703,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2023-08-22","2023-08-22",NULL,NULL,NULL,NULL,0),
(1840,0,3,1,42,2,1,20000,20000,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"CASH",NULL,NULL,"PAID FROM DANA ",0,NULL,"2023-08-31",NULL,"2023-08-31 16:20:00",NULL,634,NULL,0),
(1841,0,5,1,1,2,1,1100,1100,1,0,250,NULL,0,0,0,0,1100,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2023-09-07","2023-09-07",NULL,NULL,NULL,NULL,0),
(1842,0,3,1,1,2,1,1100,1100,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,953,NULL,NULL,"POS Payment",0,634,"2023-09-07",NULL,NULL,NULL,NULL,NULL,0),
(1843,0,5,1,149,2,1,550,550,1,0,550,NULL,0,0,0,0,550,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,639,"2023-09-13","2023-09-13",NULL,NULL,NULL,NULL,0),
(1844,0,3,1,149,2,1,550,550,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,954,NULL,NULL,"POS Payment",0,639,"2023-09-13",NULL,NULL,NULL,NULL,NULL,0),
(1845,0,5,1,42,2,1,1470,1470,1,0,1470,NULL,0,0,0,0,1470,70,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,639,"2023-09-13","2023-09-13",NULL,NULL,NULL,NULL,0),
(1846,0,5,1,150,2,1,260,260,1,0,0,NULL,0,0,0,0,260,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,6,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,639,"2023-09-19","2023-09-19",NULL,NULL,NULL,NULL,0),
(1847,0,5,1,1,2,1,450,450,1,0,0,NULL,0,0,0,0,450,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,642,"2023-09-22","2023-09-22",NULL,NULL,NULL,NULL,0),
(1848,0,3,1,1,2,1,450,450,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,957,NULL,NULL,"POS Payment",0,642,"2023-09-22",NULL,NULL,NULL,NULL,NULL,0),
(1849,0,5,1,149,2,1,1100,1100,1,0,1115,NULL,0,0,0,0,1100,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2023-09-25","2023-09-25",NULL,NULL,NULL,NULL,0),
(1850,0,3,1,149,2,1,1100,1100,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,958,NULL,NULL,"POS Payment",0,634,"2023-09-25",NULL,NULL,NULL,NULL,NULL,0),
(1851,0,3,1,42,2,1,1400,1400,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"CASH FROM MR.AYAS",NULL,NULL,NULL,0,NULL,"2023-09-26",NULL,"2023-09-26 18:37:23",NULL,634,NULL,0),
(1852,0,5,1,110,2,1,3090,3090,1,0,0,0,0,0,0,0,3090,-26910,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,639,"2023-09-26","2023-09-26",NULL,"2023-09-27 13:28:42",NULL,639,0),
(1853,0,3,1,110,2,1,50000,50000,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,"2023/cd/sa/004",NULL,NULL,"first payment  from Ozaer Jader",0,NULL,"2023-09-11",NULL,"2023-09-27 13:32:13",NULL,639,NULL,0),
(1854,0,3,1,150,2,1,260,260,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"from Shahroz",NULL,NULL,NULL,0,NULL,"2023-09-27",NULL,"2023-09-27 15:44:19",NULL,639,NULL,0),
(1855,0,9,1,NULL,2,1,780,780,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,2,634,"2023-09-28",NULL,NULL,NULL,634,NULL,0),
(1856,0,9,1,NULL,2,1,780,780,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,2,639,"2023-09-28",NULL,NULL,NULL,639,NULL,0),
(1857,0,7,1,1,2,1,780,780,1,0,0,0,780,780,0,0,NULL,NULL,NULL,780,780,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,"hhh",NULL,NULL,NULL,-1,639,"2023-09-28","2023-09-30",NULL,NULL,639,NULL,0),
(1858,0,5,1,1,2,1,390,390,1,0,0,NULL,0,0,0,0,390,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,642,"2023-09-28","2023-09-28",NULL,NULL,NULL,NULL,0),
(1859,0,3,1,1,2,1,390,390,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,963,NULL,NULL,"POS Payment",0,642,"2023-09-28",NULL,NULL,NULL,NULL,NULL,0),
(1860,0,5,1,70,2,1,675,675,1,0,225,NULL,0,0,0,0,675,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2023-10-03","2023-10-03",NULL,NULL,NULL,NULL,0),
(1861,0,5,1,1,2,1,242.5,242.5,1,0,0,NULL,0,0,0,0,242.5,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,642,"2023-10-09","2023-10-09",NULL,NULL,NULL,NULL,0),
(1862,0,3,1,1,2,1,242.5,242.5,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,965,NULL,NULL,"POS Payment",0,642,"2023-10-09",NULL,NULL,NULL,NULL,NULL,0),
(1863,0,7,1,1,2,1,82220,82220,1,0,0,0,82220,82220,0,0,NULL,NULL,NULL,82220,82220,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,54,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,"receiving new items ",NULL,NULL,NULL,-1,639,"2023-10-10","2023-10-31",NULL,NULL,639,NULL,0),
(1864,0,3,1,70,2,1,675,675,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,"CASH FROM",NULL,NULL,NULL,0,NULL,"2023-10-01",NULL,"2023-10-10 18:03:00",NULL,634,NULL,0),
(1865,0,5,1,78,2,1,1500,1500,1,300,300,300,0,0,0,0,1500,1500,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2023-10-11","2023-10-11",NULL,"2023-10-11 12:21:46",NULL,639,0),
(1866,0,3,1,78,2,1,1800,1800,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,967,NULL,NULL,"POS Payment",0,634,"2023-10-11",NULL,NULL,NULL,NULL,NULL,1),
(1867,0,5,1,1,2,1,1500,1500,1,0,0,NULL,0,0,0,0,1500,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2023-10-11","2023-10-11",NULL,NULL,NULL,NULL,0),
(1868,0,3,1,1,2,1,1500,1500,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,968,NULL,NULL,"POS Payment",0,634,"2023-10-11",NULL,NULL,NULL,NULL,NULL,0),
(1869,0,5,1,49,2,1,1962,1962,2,40,1308,1308,0,0,0,0,1962,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,639,"2023-10-15","2023-10-15",NULL,"2023-10-17 16:06:47",NULL,NULL,0),
(1870,0,7,1,1,2,1,2290,2290,1,0,0,0,2290,2290,0,0,NULL,NULL,NULL,2290,2290,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,"specia order for mr.gravian",NULL,NULL,NULL,-1,639,"2023-10-15","2023-10-31",NULL,NULL,639,NULL,0),
(1871,0,5,1,42,2,1,1536,1536,1,0,1024,NULL,0,0,0,0,1536,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,639,"2023-10-15","2023-10-15",NULL,NULL,NULL,NULL,0),
(1872,0,3,1,49,2,1,1962,1962,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,"#paid by dr.mahmoud",NULL,NULL,"paid by dr mahmoud and entered by tawfiq",0,NULL,"2023-10-18",NULL,"2023-10-18 11:13:41",NULL,634,NULL,0),
(1873,0,5,1,35,2,1,295,295,1,0,0,NULL,0,0,0,0,295,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2023-10-18","2023-10-18",NULL,NULL,NULL,NULL,0),
(1874,0,3,1,35,2,1,295,295,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,972,NULL,NULL,"POS Payment",0,634,"2023-10-18",NULL,NULL,NULL,NULL,NULL,0),
(1875,0,5,1,1,2,1,603.9,603.9,1,0,0,NULL,0,0,0,0,603.9,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,642,"2023-10-18","2023-10-18",NULL,NULL,NULL,NULL,0),
(1876,0,3,1,1,2,1,603.9,603.9,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,973,NULL,NULL,"POS Payment",0,642,"2023-10-18",NULL,NULL,NULL,NULL,NULL,0),
(1877,0,5,1,70,2,1,600,600,1,0,250,NULL,0,0,0,0,600,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2023-10-21","2023-10-21",NULL,NULL,NULL,NULL,0),
(1878,0,5,1,70,2,1,-250,-250,1,250,250,250,0,0,0,0,-250,-250,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2023-10-22","2023-10-22",NULL,"2023-10-22 00:00:00",NULL,634,1),
(1879,0,5,1,70,2,1,55,55,1,0,0,NULL,0,0,0,0,55,5,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2023-10-22","2023-10-22",NULL,NULL,NULL,NULL,0),
(1880,0,5,1,37,2,1,135,135,2,0,0,0,0,0,0,0,135,135,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,8,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,"gift ",NULL,0,634,"2023-10-22","2023-10-22",NULL,"2023-12-18 15:08:55",NULL,639,0),
(1881,0,3,1,70,2,1,600,600,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"CASH FROM BAHMAN",NULL,NULL,"CASH FROM BAHMAN 1,040,000iqd",0,NULL,"2023-10-26",NULL,"2023-10-26 11:30:35","2023-10-26 11:30:55",634,634,0),
(1882,0,3,1,70,2,1,50,50,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"CASH FROM BAHMAN",NULL,NULL,"CASH FROM BAHMAN 1,040,000iqd",0,NULL,"2023-10-26",NULL,"2023-10-26 11:31:34",NULL,634,NULL,0),
(1883,0,5,1,42,2,1,144,144,1,0,0,0,0,0,0,0,144,144,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2023-10-26","2023-10-26",NULL,"2023-10-26 11:33:35",NULL,634,0),
(1884,0,5,1,151,2,1,280,280,1,0,0,NULL,0,0,0,0,280,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2023-10-26","2023-10-26",NULL,NULL,NULL,NULL,0),
(1885,0,3,1,151,2,1,280,280,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,979,NULL,NULL,"POS Payment",0,634,"2023-10-26",NULL,NULL,NULL,NULL,NULL,0),
(1886,0,5,1,152,2,1,400,400,1,0,0,NULL,0,0,0,0,400,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2023-10-26","2023-10-26",NULL,NULL,NULL,NULL,0),
(1887,0,3,1,152,2,1,400,400,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,980,NULL,NULL,"POS Payment",0,634,"2023-10-26",NULL,NULL,NULL,NULL,NULL,0),
(1888,0,5,1,129,2,1,5394,5394,1,0,0,NULL,0,0,0,0,5394,-6,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,639,"2023-10-29","2023-10-29",NULL,NULL,NULL,NULL,0),
(1889,0,3,1,129,2,1,5400,5400,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"CHASH FROM MR.BAWAR",NULL,NULL,"CHASH FROM MR.BAWAR",0,NULL,"2023-10-30",NULL,"2023-10-30 13:05:12",NULL,634,NULL,0),
(1890,0,5,1,153,2,1,6000,6000,1,0,4245,NULL,0,0,0,0,6000,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2023-11-12","2023-11-12",NULL,NULL,NULL,NULL,0),
(1891,0,3,1,153,2,1,6000,6000,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,982,NULL,NULL,"POS Payment",0,634,"2023-11-12",NULL,NULL,NULL,NULL,NULL,0),
(1892,0,5,1,26,2,1,2200,2200,1,0,3075,NULL,0,0,0,0,2200,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2023-11-16","2023-11-16",NULL,NULL,NULL,NULL,0),
(1893,0,3,1,26,2,1,2200,2200,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,983,NULL,NULL,"POS Payment",0,634,"2023-11-16",NULL,NULL,NULL,NULL,NULL,0),
(1894,0,5,1,154,2,1,900,900,1,0,50,NULL,0,0,0,0,900,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2023-11-18","2023-11-18",NULL,NULL,NULL,NULL,0),
(1895,0,3,1,154,2,1,900,900,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,984,NULL,NULL,"POS Payment",0,634,"2023-11-18",NULL,NULL,NULL,NULL,NULL,0),
(1896,0,5,1,57,2,1,9856.25,9856.25,2,0,0,0,0,0,0,0,9856.25,-143.75,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,6,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2023-11-20","2023-11-20",NULL,"2023-11-28 16:43:22",NULL,639,0),
(1897,0,5,1,119,2,1,295,295,1,0,0,NULL,0,0,0,0,295,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2023-11-22","2023-11-22",NULL,NULL,NULL,NULL,0),
(1898,0,3,1,119,2,1,295,295,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,986,NULL,NULL,"POS Payment",0,634,"2023-11-22",NULL,NULL,NULL,NULL,NULL,0),
(1899,0,5,1,136,2,1,880,880,1,0,220,NULL,0,0,0,0,880,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2023-11-24","2023-11-24",NULL,NULL,NULL,NULL,0),
(1900,0,3,1,136,2,1,880,880,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,987,NULL,NULL,"POS Payment",0,634,"2023-11-24",NULL,NULL,NULL,NULL,NULL,0),
(1901,0,5,1,95,2,1,0,0,1,0,0,NULL,0,0,0,0,0,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2023-11-28","2023-11-28",NULL,NULL,NULL,NULL,0),
(1902,0,3,1,95,2,1,0,0,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,988,NULL,NULL,"POS Payment",0,634,"2023-11-28",NULL,NULL,NULL,NULL,NULL,0),
(1903,0,3,1,57,2,1,9494,9494,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"receiving 15,000,000 IQD from Mr.Bnas",NULL,NULL,"receiving 15,000,000 IQD from Mr.Bnas",0,NULL,"2023-11-29",NULL,"2023-11-29 12:17:51",NULL,639,NULL,0),
(1904,0,5,1,136,2,1,45,45,1,0,0,NULL,0,0,0,0,45,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2023-11-29","2023-11-29",NULL,NULL,NULL,NULL,0),
(1905,0,5,1,125,2,1,80,80,1,0,0,NULL,0,0,0,0,80,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2023-11-30","2023-11-30",NULL,NULL,NULL,NULL,0),
(1906,0,5,1,102,2,1,4000,4000,1,650,650,650,0,0,0,0,4000,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2023-11-30","2023-11-30",NULL,"2023-12-02 21:09:52",NULL,634,0),
(1907,0,5,1,1,2,1,150,150,1,0,0,NULL,0,0,0,0,150,150,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2023-12-02","2023-12-02",NULL,"2023-12-03 00:00:00",NULL,639,1),
(1908,0,3,1,1,2,1,150,150,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,992,NULL,NULL,"POS Payment",0,634,"2023-12-02",NULL,NULL,NULL,NULL,NULL,1),
(1909,0,5,1,155,2,1,100,100,1,0,0,NULL,0,0,0,0,100,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2023-12-02","2023-12-02",NULL,NULL,NULL,NULL,0),
(1910,0,3,1,155,2,1,100,100,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,993,NULL,NULL,"POS Payment",0,634,"2023-12-02",NULL,NULL,NULL,NULL,NULL,0),
(1911,0,3,1,102,2,1,4000,4000,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"recived from mr.hemn",NULL,NULL,"recived from mr.hemn",0,NULL,"2023-12-03",NULL,"2023-12-03 15:44:28",NULL,639,NULL,0),
(1912,0,7,1,1,2,1,106400,106400,1,0,0,0,106400,106400,0,0,NULL,NULL,NULL,106400,106400,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,35,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,"bgfbfg",NULL,NULL,NULL,-1,639,"2023-12-05","2023-12-07",NULL,NULL,639,NULL,0),
(1913,0,5,1,49,2,1,2500,2500,1,0,0,NULL,0,0,0,0,2500,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,639,"2023-12-05","2023-12-05",NULL,NULL,NULL,NULL,0),
(1914,0,3,1,49,2,1,2500,2500,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"Received from Gravian ",NULL,NULL,"Received from Gravian ",0,NULL,"2023-12-05",NULL,"2023-12-05 13:45:08",NULL,639,NULL,0),
(1915,0,5,1,29,2,1,500,500,1,0,1450,NULL,0,0,0,0,500,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2023-12-06","2023-12-06",NULL,NULL,NULL,NULL,0),
(1916,0,3,1,29,2,1,500,500,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,996,NULL,NULL,"POS Payment",0,634,"2023-12-06",NULL,NULL,NULL,NULL,NULL,0),
(1917,0,5,1,153,2,1,700,700,1,0,250,NULL,0,0,0,0,700,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2023-12-06","2023-12-06",NULL,NULL,NULL,NULL,0),
(1918,0,3,1,153,2,1,700,700,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,997,NULL,NULL,"POS Payment",0,634,"2023-12-06",NULL,NULL,NULL,NULL,NULL,0),
(1919,0,5,1,93,2,1,1000,1000,1,0,110,NULL,0,0,0,0,1000,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2023-12-13","2023-12-13",NULL,NULL,NULL,NULL,0),
(1920,0,3,1,93,2,1,1000,1000,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,998,NULL,NULL,"POS Payment",0,634,"2023-12-13",NULL,NULL,NULL,NULL,NULL,0),
(1921,0,5,1,63,2,1,1907.5,1907.5,1,0,0,NULL,0,0,0,0,1907.5,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2023-12-14","2023-12-14",NULL,NULL,NULL,NULL,0),
(1922,0,3,1,63,2,1,1907.5,1907.5,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,999,NULL,NULL,"POS Payment",0,634,"2023-12-14",NULL,NULL,NULL,NULL,NULL,0),
(1923,0,3,1,57,2,1,10000,10000,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"cash from yahya moayad muhammad",NULL,NULL,"cash from yahya moayad muhamad",0,NULL,"2023-12-16",NULL,"2023-12-16 16:31:58",NULL,634,NULL,0),
(1924,0,7,1,1,2,1,2900,2900,1,0,0,0,2900,2900,0,0,NULL,NULL,NULL,2900,2900,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,"cxcxc",NULL,NULL,NULL,-1,639,"2023-12-18","2023-12-31",NULL,"2023-12-18 00:00:00",639,639,0),
(1925,0,5,1,136,2,1,2900,2900,1,0,0,NULL,0,0,0,0,2900,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,639,"2023-12-18","2023-12-18",NULL,NULL,NULL,NULL,0),
(1926,0,3,1,136,2,1,1500,1500,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"receiving from mr.hani ",NULL,NULL,"receiving from mr.hani ",0,NULL,"2023-12-18",NULL,"2023-12-18 15:04:08",NULL,639,NULL,0),
(1927,0,3,1,125,2,1,80,80,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"receiving from mr.omar",NULL,NULL,"receiving from mr.omar ",0,NULL,"2023-12-18",NULL,"2023-12-18 15:04:56",NULL,639,NULL,0),
(1928,0,3,1,136,2,1,45,45,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"paid from hany",NULL,NULL,"paid from hany",0,NULL,"2023-12-18",NULL,"2023-12-18 15:07:09",NULL,639,NULL,0),
(1929,0,3,1,42,2,1,1536,1536,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"from ayaz",NULL,NULL,"from ayaz",0,NULL,"2023-12-18",NULL,"2023-12-18 15:10:49",NULL,639,NULL,0),
(1930,0,3,1,110,2,1,30000,30000,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"Receiving from Ozair",NULL,NULL,"Receiving from Ozair",0,NULL,"2023-12-18",NULL,"2023-12-18 15:21:10",NULL,639,NULL,0),
(1931,0,5,1,45,2,1,585,585,1,0,0,0,0,0,0,0,585,585,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,639,"2023-12-18","2023-12-18",NULL,"2024-01-28 14:44:56",NULL,634,0),
(1932,0,5,1,4,2,1,5908,5908,2,20,1477,1477,0,0,0,0,5908,5908,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,6,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2023-12-21","2023-12-21",NULL,"2023-12-21 18:37:09",NULL,634,0),
(1933,0,3,1,10,2,1,17640,17640,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"ali paid for turkish guys",NULL,NULL,"ali paid for turkish guys",0,NULL,"2022-01-12",NULL,"2023-12-26 16:09:33",NULL,639,NULL,0),
(1934,0,3,1,10,2,1,13167.5,13167.5,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"ali paid for turkish guys",NULL,NULL,"ali paid for turkish guys",0,NULL,"2022-01-12",NULL,"2023-12-26 16:09:57",NULL,639,NULL,0),
(1935,0,7,1,1,2,1,11000,11000,1,0,0,0,11000,11000,0,0,NULL,NULL,NULL,11000,11000,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,"Gravian special order",NULL,NULL,NULL,-1,639,"2023-12-28","2023-12-31",NULL,NULL,639,NULL,0),
(1936,0,5,1,49,2,1,6720,6720,1,0,4480,NULL,0,0,0,0,6720,6720,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,639,"2023-12-28","2023-12-28",NULL,NULL,NULL,NULL,0),
(1937,0,7,1,1,2,1,8500,8500,1,0,0,0,8500,8500,0,0,NULL,NULL,NULL,8500,8500,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,"cidc",NULL,NULL,NULL,-1,639,"2024-01-09","2024-01-31",NULL,NULL,639,NULL,0),
(1938,0,5,1,49,2,1,8500,8500,1,0,0,NULL,0,0,0,0,8500,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,639,"2024-01-09","2024-01-09",NULL,NULL,NULL,NULL,0),
(1939,0,3,1,49,2,1,8500,8500,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"from Gravian",NULL,NULL,"from Gravian",0,NULL,"2024-01-09",NULL,"2024-01-09 15:27:26",NULL,639,NULL,0),
(1940,0,5,1,128,2,1,92,92,1,0,58,NULL,0,0,0,0,92,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-15","2024-01-15",NULL,NULL,NULL,NULL,0),
(1941,0,3,1,128,2,1,92,92,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,1008,NULL,NULL,"POS Payment",0,634,"2024-01-15",NULL,NULL,NULL,NULL,NULL,0),
(1942,0,5,1,157,2,1,1095,1095,1,0,0,NULL,0,0,0,0,1095,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-15","2024-01-15",NULL,NULL,NULL,NULL,0),
(1943,0,3,1,157,2,1,1095,1095,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,1009,NULL,NULL,"POS Payment",0,634,"2024-01-15",NULL,NULL,NULL,NULL,NULL,0),
(1944,0,5,1,35,2,1,0,0,1,0,0,0,0,0,0,0,0,0,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-15","2024-01-15",NULL,"2024-01-21 00:00:00",NULL,634,1),
(1945,0,3,1,35,2,1,1552,1552,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,1010,NULL,NULL,"POS Payment",0,634,"2024-01-15",NULL,NULL,NULL,NULL,NULL,1),
(1946,0,5,1,93,2,1,4500,4500,1,0,164,NULL,0,0,0,0,4500,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-16","2024-01-16",NULL,NULL,NULL,NULL,0),
(1947,0,3,1,93,2,1,4500,4500,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,1011,NULL,NULL,"POS Payment",0,634,"2024-01-16",NULL,NULL,NULL,NULL,NULL,0),
(1948,0,5,1,35,2,1,571.5,571.5,1,0,0,NULL,0,0,0,0,571.5,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-18","2024-01-18",NULL,NULL,NULL,NULL,0),
(1949,0,3,1,35,2,1,571.5,571.5,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,1012,NULL,NULL,"POS Payment",0,634,"2024-01-18",NULL,NULL,NULL,NULL,NULL,0),
(1950,0,5,1,93,2,1,200,200,1,0,285,NULL,0,0,0,0,200,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-18","2024-01-18",NULL,NULL,NULL,NULL,0),
(1951,0,3,1,93,2,1,200,200,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,1013,NULL,NULL,"POS Payment",0,634,"2024-01-18",NULL,NULL,NULL,NULL,NULL,0),
(1952,0,5,1,92,2,1,200,200,1,0,285,NULL,0,0,0,0,200,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-18","2024-01-18",NULL,NULL,NULL,NULL,0),
(1953,0,3,1,92,2,1,200,200,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,1014,NULL,NULL,"POS Payment",0,634,"2024-01-18",NULL,NULL,NULL,NULL,NULL,0),
(1954,0,5,1,8,2,1,3130,3130,1,0,0,NULL,0,0,0,0,3130,1130,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-18","2024-01-18",NULL,NULL,NULL,NULL,0),
(1955,0,5,1,29,2,1,1854,1854,1,0,4326,NULL,0,0,0,0,1854,1854,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-19","2024-01-19",NULL,NULL,NULL,NULL,0),
(1956,0,5,1,157,2,1,729,729,1,0,1701,NULL,0,0,0,0,729,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-19","2024-01-19",NULL,NULL,NULL,NULL,0),
(1957,0,3,1,157,2,1,729,729,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,1017,NULL,NULL,"POS Payment",0,634,"2024-01-19",NULL,NULL,NULL,NULL,NULL,0),
(1958,0,5,1,29,2,1,435,435,1,0,1015,NULL,0,0,0,0,435,435,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-19","2024-01-19",NULL,NULL,NULL,NULL,0),
(1959,0,5,1,158,2,1,3600,3600,1,274.5,274.5,274.5,0,0,0,0,3600,3600,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,9,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-19","2024-01-19",NULL,"2024-01-21 16:55:19",NULL,634,0),
(1960,0,3,1,158,2,1,2818,2818,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,1019,NULL,NULL,"POS Payment",0,634,"2024-01-19",NULL,NULL,NULL,NULL,NULL,1),
(1961,0,5,1,158,2,1,-505,-505,1,505,505,505,0,0,0,0,-505,-505,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-19","2024-01-19",NULL,"2024-01-21 00:00:00",NULL,634,1),
(1962,0,3,1,8,2,1,1000,1000,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,"#CASH FROM TAWFIQ",NULL,NULL,"PAID 1000$ TO TAWFIQ BY MR. RAGIB",0,NULL,"2024-01-19",NULL,"2024-01-19 19:41:40",NULL,634,NULL,0),
(1963,0,7,1,1,2,1,1950,1950,1,0,0,0,1950,1950,0,0,NULL,NULL,NULL,1950,1950,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,"GR",NULL,NULL,NULL,-1,634,"2024-01-20","2024-01-31",NULL,"2024-01-20 00:00:00",634,634,0),
(1964,0,5,1,49,2,1,8059,8059,1,0,0,0,0,0,0,0,8059,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,20,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-20","2024-01-20",NULL,"2024-01-20 17:14:49",NULL,634,0),
(1965,0,5,1,63,2,1,900,900,1,0,145.5,NULL,0,0,0,0,900,900,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-20","2024-01-20",NULL,NULL,NULL,NULL,0),
(1966,0,5,1,45,2,1,285,285,1,0,0,NULL,0,0,0,0,285,285,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-20","2024-01-20",NULL,NULL,NULL,NULL,0),
(1967,0,5,1,35,2,1,1020,1020,1,0,0,NULL,0,0,0,0,1020,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-21","2024-01-21",NULL,NULL,NULL,NULL,0),
(1968,0,3,1,35,2,1,1020,1020,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,1025,NULL,NULL,"POS Payment",0,634,"2024-01-21",NULL,NULL,NULL,NULL,NULL,0),
(1970,0,5,1,1,2,1,415.5,415.5,1,0,0,NULL,0,0,0,0,415.5,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-21","2024-01-21",NULL,NULL,NULL,NULL,0),
(1971,0,3,1,1,2,1,415.5,415.5,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,1026,NULL,NULL,"POS Payment",0,634,"2024-01-21",NULL,NULL,NULL,NULL,NULL,0),
(1972,0,5,1,159,2,1,561,561,1,0,1309,NULL,0,0,0,0,561,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-21","2024-01-21",NULL,NULL,NULL,NULL,0),
(1973,0,3,1,159,2,1,561,561,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,1027,NULL,NULL,"POS Payment",0,634,"2024-01-21",NULL,NULL,NULL,NULL,NULL,0),
(1974,0,5,1,49,2,1,9485,9485,1,0,0,0,0,0,0,0,9485,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,14,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-21","2024-01-21",NULL,"2024-01-24 10:33:54",NULL,639,0),
(1975,0,5,1,1,2,1,1182,1182,1,0,2758,NULL,0,0,0,0,1182,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-21","2024-01-21",NULL,NULL,NULL,NULL,0),
(1976,0,3,1,1,2,1,1182,1182,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,1029,NULL,NULL,"POS Payment",0,634,"2024-01-21",NULL,NULL,NULL,NULL,NULL,0),
(1977,0,5,1,160,2,1,6472.5,6472.5,1,0,15102.5,NULL,0,0,0,0,6472.5,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-22","2024-01-22",NULL,NULL,NULL,NULL,0),
(1978,0,3,1,160,2,1,6472.5,6472.5,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,1030,NULL,NULL,"POS Payment",0,634,"2024-01-22",NULL,NULL,NULL,NULL,NULL,0),
(1979,0,5,1,160,2,1,560.5,560.5,1,0,0,NULL,0,0,0,0,560.5,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-22","2024-01-22",NULL,NULL,NULL,NULL,0),
(1980,0,3,1,160,2,1,560.5,560.5,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,1031,NULL,NULL,"POS Payment",0,634,"2024-01-22",NULL,NULL,NULL,NULL,NULL,0),
(1981,0,5,1,49,2,1,426,426,1,0,1704,NULL,0,0,0,0,426,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-23","2024-01-23",NULL,NULL,NULL,NULL,0),
(1982,0,5,1,160,2,1,2435,2435,1,0,0,NULL,0,0,0,0,2435,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-23","2024-01-23",NULL,NULL,NULL,NULL,0),
(1983,0,3,1,160,2,1,2435,2435,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,1033,NULL,NULL,"POS Payment",0,634,"2024-01-23",NULL,NULL,NULL,NULL,NULL,0),
(1984,0,5,1,161,2,1,2166.5,2166.5,1,0,0,NULL,0,0,0,0,2166.5,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-23","2024-01-23",NULL,NULL,NULL,NULL,0),
(1985,0,3,1,49,2,1,426,426,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,"from Gravian",NULL,NULL,"from Gravian",0,NULL,"2024-01-24",NULL,"2024-01-24 10:28:35",NULL,639,NULL,0),
(1986,0,3,1,49,2,1,8059,8059,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,"from Gravian",NULL,NULL,"from Gravian",0,NULL,"2024-01-24",NULL,"2024-01-24 10:30:46",NULL,639,NULL,0),
(1987,0,3,1,49,2,1,9485,9485,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"from gravian",NULL,NULL,NULL,0,NULL,"2024-01-24",NULL,"2024-01-24 10:34:41","2024-01-24 10:38:48",639,639,0),
(1988,0,5,1,161,2,1,1912,1912,1,0,0,0,0,0,0,0,1912,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-24","2024-01-24",NULL,"2024-01-24 18:20:07",NULL,639,0),
(1989,0,5,1,45,2,1,711,711,1,0,0,0,0,0,0,0,711,711,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-25","2024-01-25",NULL,"2024-01-28 14:43:40",NULL,634,0),
(1990,0,7,1,1,2,1,1,1,1,0,0,0,1,1,0,0,NULL,NULL,NULL,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,"ssss",NULL,NULL,NULL,-1,639,"2024-01-25","2024-01-31",NULL,NULL,639,NULL,0),
(1991,0,5,1,160,2,1,1778,1778,1,0,0,NULL,0,0,0,0,1778,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,6,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,639,"2024-01-25","2024-01-25",NULL,NULL,NULL,NULL,0),
(1992,0,3,1,160,2,1,1778,1778,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,1038,NULL,NULL,"POS Payment",0,639,"2024-01-25",NULL,NULL,NULL,NULL,NULL,0),
(1993,0,3,1,161,2,1,2166.5,2166.5,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"CASH FROM",NULL,NULL,NULL,0,NULL,"2024-01-25",NULL,"2024-01-25 19:29:08",NULL,634,NULL,0),
(1994,0,3,1,161,2,1,1912,1912,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"CASH FROM",NULL,NULL,NULL,0,NULL,"2024-01-25",NULL,"2024-01-25 19:29:29",NULL,634,NULL,0),
(1995,0,5,1,1,2,1,345.5,345.5,1,0,0,NULL,0,0,0,0,345.5,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-26","2024-01-26",NULL,NULL,NULL,NULL,0),
(1996,0,3,1,1,2,1,345.5,345.5,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,1039,NULL,NULL,"POS Payment",0,634,"2024-01-26",NULL,NULL,NULL,NULL,NULL,0),
(1997,0,5,1,162,2,1,430.5,430.5,1,0,0,NULL,0,0,0,0,430.5,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-28","2024-01-28",NULL,NULL,NULL,NULL,0),
(1998,0,3,1,162,2,1,430.5,430.5,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,1040,NULL,NULL,"POS Payment",0,634,"2024-01-28",NULL,NULL,NULL,NULL,NULL,0),
(1999,0,5,1,45,2,1,526,526,2,80,2104,2104,0,0,0,0,526,526,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-28","2024-01-28",NULL,"2024-02-01 20:30:24",NULL,639,0),
(2000,0,7,1,1,2,1,1455,1455,1,0,0,0,1455,1455,0,0,NULL,NULL,NULL,1455,1455,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,"bill",NULL,NULL,NULL,-1,634,"2024-01-28","2024-01-31",NULL,NULL,634,NULL,0),
(2001,0,5,1,163,2,1,459.1,459.1,1,0,0,NULL,0,0,0,0,459.1,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-28","2024-01-28",NULL,NULL,NULL,NULL,0),
(2002,0,3,1,163,2,1,459.1,459.1,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,1043,NULL,NULL,"POS Payment",0,634,"2024-01-28",NULL,NULL,NULL,NULL,NULL,0),
(2003,0,3,1,8,2,1,1000,1000,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,"CASH FROM. MR RAGIB",NULL,NULL,"PAID 1000$ BY SECOND PAYMENT TO TAWFIQ 1000$",0,NULL,"2024-01-29",NULL,"2024-01-29 18:37:33",NULL,634,NULL,0),
(2004,0,5,1,153,2,1,140,140,1,0,0,NULL,0,0,0,0,140,140,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-31","2024-01-31",NULL,NULL,NULL,NULL,0),
(2005,0,5,1,29,2,1,375,375,1,0,0,0,0,0,0,0,375,375,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-31","2024-01-31",NULL,"2024-02-17 13:15:53",NULL,634,0),
(2006,0,3,1,136,2,1,1400,1400,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"CASH FROM. MR hani",NULL,NULL,"paid to tawfiq full payment 1400$",0,NULL,"2024-01-31",NULL,"2024-01-31 19:15:09",NULL,634,NULL,0),
(2007,0,5,1,136,2,1,4600,4600,1,8360,8360,8360,0,0,0,0,4600,2100,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-31","2024-01-31",NULL,"2024-01-31 19:42:58",NULL,634,0),
(2008,0,5,1,162,2,1,145.5,145.5,2,70,339.5,339.5,0,0,0,0,145.5,0.5,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-31","2024-01-31",NULL,"2024-02-03 16:51:39",NULL,634,0),
(2009,0,5,1,87,2,1,3176,3176,2,80,12704,12704,0,0,0,0,3176,3176,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-31","2024-01-31",NULL,"2024-02-08 17:37:56",NULL,634,0),
(2010,0,5,1,149,2,1,220,220,1,0,0,0,0,0,0,0,220,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-31","2024-01-31",NULL,"2024-02-01 19:01:04",NULL,634,0),
(2011,0,5,1,160,2,1,456,456,1,0,0,0,0,0,0,0,456,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-31","2024-01-31",NULL,"2024-02-01 18:30:12",NULL,639,0),
(2012,0,3,1,149,2,1,220,220,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"CASH FROM. Mr saeb",NULL,NULL," paid 220$ to tawfiq",0,NULL,"2024-02-01",NULL,"2024-02-01 19:02:31",NULL,634,NULL,0),
(2013,0,5,1,161,2,1,175,175,2,80,700,700,0,0,0,0,175,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-01-31","2024-01-31",NULL,"2024-02-01 20:12:35",NULL,639,0),
(2014,0,3,1,161,2,1,175,175,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"CASH FROM. Mr omid",NULL,NULL,"recieved by tawfiq",0,NULL,"2024-02-03",NULL,"2024-02-03 16:51:00",NULL,634,NULL,0),
(2015,0,5,1,32,2,1,5028,5028,2,80,20112,20112,0,0,0,0,5028,5028,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,21,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,639,"2024-01-31","2024-01-31",NULL,"2024-02-03 16:53:32",NULL,639,0),
(2016,0,3,1,162,2,1,145,145,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"CASH FROM. Mr omid",NULL,NULL,"recieved by tawfiq",0,NULL,"2024-02-03",NULL,"2024-02-03 16:52:03",NULL,634,NULL,0),
(2017,0,5,1,32,2,1,5930,5930,1,0,0,0,0,0,0,0,5930,5930,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-02-03","2024-02-03",NULL,"2024-02-22 13:57:20",NULL,639,0),
(2018,0,5,1,57,2,1,520,520,1,0,0,NULL,0,0,0,0,520,520,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-02-03","2024-02-03",NULL,NULL,NULL,NULL,0),
(2019,0,5,1,69,2,1,50,50,1,0,180,NULL,0,0,0,0,50,50,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-02-04","2024-02-04",NULL,NULL,NULL,NULL,0),
(2020,0,5,1,29,2,1,1500,1500,1,0,3495,NULL,0,0,0,0,1500,1500,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-02-05","2024-02-05",NULL,"2024-02-22 00:00:00",NULL,639,1),
(2021,0,3,1,29,2,1,1500,1500,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,1056,NULL,NULL,"POS Payment",0,634,"2024-02-05",NULL,NULL,NULL,NULL,NULL,1),
(2022,0,3,1,136,2,1,2500,2500,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"CASH FROM. M rhani",NULL,NULL,"paid to tawfiq",0,NULL,"2024-02-05",NULL,"2024-02-05 18:15:32",NULL,634,NULL,0),
(2023,0,5,1,70,2,1,680,680,1,0,0,NULL,0,0,0,0,680,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-02-06","2024-02-06",NULL,NULL,NULL,NULL,0),
(2024,0,3,1,70,2,1,680,680,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,1057,NULL,NULL,"POS Payment",0,634,"2024-02-06",NULL,NULL,NULL,NULL,NULL,0),
(2025,0,3,1,160,2,1,456,456,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,0,NULL,"CASH FROM mr.ahmed",NULL,NULL,NULL,0,NULL,"2024-02-08",NULL,"2024-02-08 17:24:31",NULL,634,NULL,0),
(2026,0,5,1,164,2,1,1700,1700,1,0,5.5,NULL,0,0,0,0,1700,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-02-09","2024-02-09",NULL,NULL,NULL,NULL,0),
(2027,0,3,1,164,2,1,1700,1700,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,1058,NULL,NULL,"POS Payment",0,634,"2024-02-09",NULL,NULL,NULL,NULL,NULL,0),
(2028,0,5,1,160,2,1,532,532,1,0,228,NULL,0,0,0,0,532,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-02-25","2024-02-25",NULL,NULL,NULL,NULL,0),
(2029,0,3,1,160,2,1,532,532,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,1059,NULL,NULL,"POS Payment",0,634,"2024-02-25",NULL,NULL,NULL,NULL,NULL,0),
(2030,0,5,1,160,2,1,80,80,1,0,150,NULL,0,0,0,0,80,0,2,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,634,"2024-02-25","2024-02-25",NULL,NULL,NULL,NULL,0),
(2031,0,3,1,160,2,1,80,80,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,0,NULL,1060,NULL,NULL,"POS Payment",0,634,"2024-02-25",NULL,NULL,NULL,NULL,NULL,0);


DROP TABLE transactionsubtypes;

CREATE TABLE `transactionsubtypes` (
  `TransactionSubTypeId` bigint(20) NOT NULL AUTO_INCREMENT,
  `Name` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`TransactionSubTypeId`)
) ENGINE=InnoDB AUTO_INCREMENT=10006 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

INSERT INTO transactionsubtypes VALUES
(1,"MonthlySubscription"),
(2,"DailySubscription"),
(10002,"Salary"),
(10003,"PurchaseToExpenseAccount"),
(10004,"Inventory"),
(10005,"SaleToRevenueAccount");


DROP TABLE transactiontypes;

CREATE TABLE `transactiontypes` (
  `TransactionTypeId` bigint(20) NOT NULL AUTO_INCREMENT,
  `Name` varchar(500) DEFAULT NULL,
  `comment` varchar(300) DEFAULT NULL,
  `AccountingRelated` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`TransactionTypeId`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

INSERT INTO transactiontypes VALUES
(1,"Invest",NULL,0),
(2,"Withdraw",NULL,0),
(3,"Receive Payment",NULL,1),
(4,"Make Payment",NULL,1),
(5,"Sales",NULL,0),
(6,"Manual Journal Entry",NULL,1),
(7,"Purchase Receipt",NULL,0),
(8,"Expense",NULL,0),
(9,"Inventory Transfer",NULL,0),
(10,"Inventory Item Assembly",NULL,0),
(11,"Depreciation",NULL,0),
(12,"Fixed Asset Disposal",NULL,0),
(13,"Receive Advanced Payment",NULL,0),
(14,"Pay Refund Payment",NULL,0),
(15,"Production",NULL,0),
(16,"Slitting Order",NULL,0),
(17,"Starting Inventory",NULL,0),
(18,"Starting Balance",NULL,0),
(19,"Receive Payment Without Invoice","It was Contact Balance",0),
(20,"Expense Payment",NULL,0),
(21,"Sales Discount",NULL,0),
(22,"Inventory Adjustment",NULL,0),
(23,"Advanced Payment",NULL,0),
(24,"Applied Advanced Payment",NULL,0),
(25,"Sales Return",NULL,0),
(26,"Refund",NULL,0),
(27,"Opening Journal",NULL,1),
(28,"Damage",NULL,0),
(29,"Batch purchase payment","Batch purchase payment",0),
(30,"Batch sale payment","Batch sale payment",0),
(31,"Cash Transfer","cashier collection transfer between safes",0),
(32,"Progress payment","Progress payment",0),
(33,"Inventory item Consumption","Inventory item Consumption",0);


DROP TABLE unit_classes;

CREATE TABLE `unit_classes` (
  `unit_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `abbr` varchar(10) DEFAULT NULL,
  `notes` varchar(60) DEFAULT NULL,
  `created` int(11) NOT NULL,
  `modified` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`unit_id`),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY `abbr` (`abbr`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

INSERT INTO unit_classes VALUES
(1,"Quantity","QTY","quantity based unit  or piece",1564747453,1564963822,0),
(2,"Weight","WGT",NULL,1564747453,1564747453,0),
(3,"Length","LNG",NULL,1564747510,1564747510,0),
(4,"Time","TIM",NULL,1564747576,1564747576,0),
(5,"Volume","VLM",NULL,1564747634,1564747634,0),
(6,"Set","ST","set to sheet",1564887187,1564887187,1);


DROP TABLE unit_of_measures;

CREATE TABLE `unit_of_measures` (
  `uom_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `unit_id` bigint(20) NOT NULL COMMENT 'unit class id',
  `name` varchar(30) NOT NULL,
  `abbr` varchar(10) DEFAULT NULL,
  `notes` varchar(60) DEFAULT NULL,
  `created` int(11) NOT NULL,
  `modified` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`uom_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

INSERT INTO unit_of_measures VALUES
(1,1,"Piece","Pcs","Pieces",1564758562,1564877676,0),
(2,1,"Carton","Ctn","Cartons",1564758562,1564758562,1),
(3,1,"Mastercase","Mc","Master Cases",1564758664,1564758664,1),
(4,1,"Promotion","Pro","Promotion",1564758664,1564758664,1),
(5,1,"Pieces","Pcs",NULL,1606027489,1606027489,0),
(6,1,"Box","Box",NULL,1606027500,1606027500,0),
(7,1,"Cartoon","Crt",NULL,1606027515,1606027515,0);


DROP TABLE units;

CREATE TABLE `units` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(500) DEFAULT NULL,
  `notes` varchar(255) DEFAULT NULL,
  `created` int(11) NOT NULL,
  `created_by` int(20) NOT NULL,
  `modified` int(11) DEFAULT NULL,
  `modified_by` int(20) DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

INSERT INTO units VALUES
(1,"Pcs",NULL,0,0,NULL,NULL,0),
(2,"Cartoon",NULL,0,0,NULL,NULL,0),
(3,"Package",NULL,0,0,NULL,NULL,0),
(4,"Bottle",NULL,0,0,NULL,NULL,0),
(5,"Meter",NULL,0,0,NULL,NULL,0),
(6,"Kg",NULL,0,0,NULL,NULL,0),
(7,"gr",NULL,0,0,NULL,NULL,0),
(8,"man",NULL,0,0,NULL,NULL,0),
(9,"Box","Boxes that contain items",1585007761,12,1585073318,12,0),
(10,"Another PCS",NULL,1585068525,12,NULL,NULL,1),
(11,"Another PCS",NULL,1585073335,12,NULL,NULL,0),
(12,"Month","The month of service, salary, etc.",1585352438,12,NULL,NULL,0),
(13,"Visit",NULL,1605687165,614,NULL,NULL,0);


DROP TABLE userpermession;

CREATE TABLE `userpermession` (
  `userpermessionId` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) DEFAULT NULL,
  `permessionId` int(11) DEFAULT NULL,
  PRIMARY KEY (`userpermessionId`),
  KEY `permessionId_idx` (`permessionId`),
  KEY `userId_idx` (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

INSERT INTO userpermession VALUES
(30,12,9),
(46,22,23),
(48,24,22),
(49,25,25),
(50,26,9),
(51,27,26),
(52,23,21),
(53,23,27),
(54,30,28),
(58,32,28),
(59,33,28),
(60,34,28),
(61,35,28),
(62,36,28),
(63,31,28),
(64,37,21),
(65,38,21),
(66,21,30),
(67,40,30),
(68,41,26);


DROP TABLE users;

CREATE TABLE `users` (
  `userId` int(11) NOT NULL AUTO_INCREMENT,
  `userName` varchar(45) DEFAULT NULL,
  `userPassword` varchar(125) DEFAULT NULL,
  `Deleted` tinyint(1) DEFAULT 0,
  `userProfile` varchar(250) DEFAULT NULL,
  `userNickname` varchar(45) DEFAULT NULL,
  `userLocation` varchar(45) DEFAULT 'Iraq, Erbil',
  `HrEmpId` int(11) NOT NULL DEFAULT 0,
  `defualtPage` varchar(256) DEFAULT NULL,
  `user_group_id` int(11) DEFAULT NULL,
  `zone_id` int(11) DEFAULT NULL,
  `pass_renewal_date` date DEFAULT NULL,
  `expire_date` date DEFAULT NULL,
  `create_date` int(11) DEFAULT NULL,
  `created_by_user_id` int(11) DEFAULT NULL,
  `modification_date` int(11) DEFAULT NULL,
  `modified_by_user_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=648 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

INSERT INTO users VALUES
(1,"sysadmin","03ccadad98b0635188310bc09222bb90f308a90e",0,"users/blank_profile.png","Admin","Iraq, Erbil",0,"start",0,1,NULL,NULL,NULL,NULL,NULL,NULL),
(12,"admin","03ccadad98b0635188310bc09222bb90f308a90e",1,"users/1571436394.png","Admin","admin",0,"start",1,1,NULL,NULL,NULL,NULL,1630763728,634),
(100,"noman","7c4a8d09ca3762af61e59520943dc26494f8941b",1,"users/blank_profile.png","نعمان احمد نعمان",1,0,"scanner-pos",35,NULL,NULL,NULL,1583006354,12,1595322118,12),
(101,"furat","a50e1bdc929b752ef45cdae0bfef785f7f08a47a",1,"users/blank_profile.png","فرات دهام محمد",1,0,"scanner-pos",35,NULL,NULL,NULL,1583006428,12,1595322118,12),
(102,"rekar","9fa113be62edf886ffd8545d6cb9f01ca7750a1f",1,"users/blank_profile.png","ڕێکار اوغس صالح",1,0,"scanner-pos",35,NULL,NULL,NULL,1583006688,12,1595322118,12),
(103,"ghzai","4fa87eac15303eea51a46e7468beeb7a40fde788",1,"users/blank_profile.png","غازی عمر جاسم",1,0,"scanner-pos",35,NULL,NULL,NULL,1583006735,12,1595322118,12),
(104,"hoshang","7e8ffbd34d4f7587544aae66a27d8b94712d0154",1,"users/blank_profile.png","هۆشەنگ سلیمان اسماعیل",1,0,"scanner-reports",35,NULL,NULL,NULL,1583006806,12,1595322118,12),
(105,"check","af813f460e1eef0e58bf7a56f30103cdc50aadae",1,"users/blank_profile.png","Khazir check",1,0,"scanner-check",35,NULL,NULL,NULL,1583006962,12,1595322118,12),
(107,"gov","677a9194963577c5ca38c56ef50a23535f292a39",1,"users/blank_profile.png","gov",-1,0,"scanner-master-reports",36,NULL,NULL,NULL,1583937750,12,1595322114,12),
(201,"jameel","0d85d75307337d0f215c8d53ae09acbcb728de03",1,"users/blank_profile.png","جميل جلال فقى",2,0,"scanner-pos",35,NULL,NULL,NULL,1583539898,12,1595322118,12),
(202,"ayad","8edc7b121de371168ec17b0d0c67e88eb0b25f99",1,"users/blank_profile.png","ایاد جلال عثمان",2,0,"scanner-pos",35,NULL,NULL,NULL,1583539964,12,1595322118,12),
(203,"suleman","e7de6e708794eee5e5985fbe146e5c62188af627",1,"users/blank_profile.png","سلیمان سالم عبدالوهاب",2,0,"scanner-pos",35,NULL,NULL,NULL,1583540068,12,1595322118,12),
(204,"goran","3acd0be86de7dcccdbf91b20f94a68cea535922d",1,"users/blank_profile.png","گۆران عدنان حسین",2,0,"scanner-pos",35,NULL,NULL,NULL,1583540105,12,1595322118,12),
(205,"yusif","dd5fef9c1c1da1394d6d34b248c51be2ad740840",1,"users/blank_profile.png","یوسف ابوبکر پیرداود",2,0,"scanner-reports",35,NULL,NULL,NULL,1583540231,12,1595322118,12),
(206,"karwan","7c4a8d09ca3762af61e59520943dc26494f8941b",1,"users/blank_profile.png","هوشنک احمد قاسم",2,0,"scanner-pos",35,NULL,NULL,NULL,1583581187,12,1595322118,12),
(301,"karwan","7c4a8d09ca3762af61e59520943dc26494f8941b",1,"users/blank_profile.png","کاروان محمد شریف",3,0,"scanner-pos",35,NULL,NULL,NULL,1583581187,12,1595322118,12),
(302,"mevan","7c4a8d09ca3762af61e59520943dc26494f8941b",1,"users/blank_profile.png","مێڤان محمد شریف طه",3,0,"scanner-pos",35,NULL,NULL,NULL,1583581187,12,1595322118,12),
(303,"mohammed","7c4a8d09ca3762af61e59520943dc26494f8941b",1,"users/blank_profile.png","محمد وحید رحۆ",3,0,"scanner-pos",35,NULL,NULL,NULL,1583581187,12,1595322118,12),
(304,"ahmad","7c4a8d09ca3762af61e59520943dc26494f8941b",1,"users/blank_profile.png","احمد هەینی",3,0,"scanner-pos",35,NULL,NULL,NULL,1583581187,12,1595322118,12),
(305,"rkeng","7c4a8d09ca3762af61e59520943dc26494f8941b",1,"users/blank_profile.png","ڕەوەژ - کۆژین",3,0,"scanner-pos",35,NULL,NULL,NULL,1583581187,12,1595322118,12),
(602,"falah","139bca89306e7160aa083d82629913949f00dff1",1,"users/blank_profile.png","Falah",-1,0,"scanner-master-reports",36,NULL,NULL,NULL,1583362247,12,1595322114,12),
(603,"dfsdg","92429d82a41e930486c6de5ebda9602d55c39986",1,"users/blank_profile.png","sdfasdf","asdfasd",3,"NULL",37,NULL,NULL,NULL,1595063640,12,1595322107,12),
(604,"hr","8cb2237d0679ca88db6464eac60da96345513964",1,"users/blank_profile.png","HR","Erbil",0,"hr-employee-list",38,NULL,NULL,NULL,1595322219,12,1613848772,12),
(605,"rec1","618dcdfb0cd9ae4481164961c4796dd8e3930c8d",1,"users/blank_profile.png","REC1","Erbil",0,"health/reception",39,NULL,NULL,NULL,1595323002,12,1613848781,12),
(606,"rec2","8cb2237d0679ca88db6464eac60da96345513964",1,"users/blank_profile.png","REC2","Erbil",0,"health/reception",39,NULL,NULL,NULL,1595323070,12,1613848781,12),
(607,"rec3","8cb2237d0679ca88db6464eac60da96345513964",1,"users/blank_profile.png","REC3","Erbil",0,"health/reception",39,NULL,NULL,NULL,1595323118,12,1613848781,12),
(608,"lab1","204d1b68ca70c70e17417076588df954f47da0da",1,"users/blank_profile.png","LAB1","Arzheen",0,"health/visits",40,NULL,NULL,NULL,1596710550,12,1613848787,12),
(609,"lab2","7110eda4d09e062aa5e4a390b0a572ac0d2c0220",1,"users/blank_profile.png","LAB2","Arzheen",0,"health/visits",40,NULL,NULL,NULL,1596710588,12,1613848787,12),
(610,"lab3","8cb2237d0679ca88db6464eac60da96345513964",1,"users/blank_profile.png","LAB3","Arzheen",0,"health/visits",40,NULL,NULL,NULL,1596710616,12,1613848787,12),
(611,"rad1","204d1b68ca70c70e17417076588df954f47da0da",1,"users/blank_profile.png","RAD1","Arzheen",0,"health/visits",41,NULL,NULL,NULL,1596710677,12,1613848794,12),
(612,"rad2","7110eda4d09e062aa5e4a390b0a572ac0d2c0220",1,"users/blank_profile.png","RAD2","Arzheen",0,"health/visits",41,NULL,NULL,NULL,1596710704,12,1613848794,12),
(613,"rad3","8cb2237d0679ca88db6464eac60da96345513964",1,"users/blank_profile.png","RAD3","Arzheen",0,"health/visits",41,NULL,NULL,NULL,1596710743,12,1613848794,12),
(614,"acc1","8cb2237d0679ca88db6464eac60da96345513964",1,"users/blank_profile.png","ACC1","Arzheen",0,"health/visits",42,NULL,NULL,NULL,1597138594,12,1613848807,12),
(615,"acc2","21069e4d4faf535a594d13fa2b28ff17717bf47b",1,"users/blank_profile.png","ACC2","Arzheen",0,"health/visits",42,NULL,NULL,NULL,1597139237,12,1613848807,12),
(616,"acc3","8cb2237d0679ca88db6464eac60da96345513964",1,"users/blank_profile.png","ACC3","Arzheen",0,"health/visits",42,NULL,NULL,NULL,1597139322,12,1613848807,12),
(617,"saya","3a3bf0a3594d42200b46db538dd7cb8b7de1bd34",1,"users/blank_profile.png","SAYA","Arzheen",0,"health/visits",43,NULL,NULL,NULL,1597146722,12,1613848813,12),
(618,"emg1","8cb2237d0679ca88db6464eac60da96345513964",1,"users/blank_profile.png","EMG1","Arzheen",0,"health/visits",44,NULL,NULL,NULL,1597477541,12,1613848820,12),
(619,"emg2","8cb2237d0679ca88db6464eac60da96345513964",1,"users/blank_profile.png","EMG2","Arzheen",0,"health/visits",44,NULL,NULL,NULL,1597477580,12,1613848820,12),
(620,"emg3","8cb2237d0679ca88db6464eac60da96345513964",1,"users/blank_profile.png","EMG3","Arzheen",0,"health/visits",44,NULL,NULL,NULL,1597477634,12,1613848820,12),
(621,"icu1","8cb2237d0679ca88db6464eac60da96345513964",1,"users/blank_profile.png","ICU","Arzheen",0,"health/visits",45,NULL,NULL,NULL,1597491073,12,1613848826,12),
(622,"5w1","8cb2237d0679ca88db6464eac60da96345513964",1,"users/blank_profile.png","5W1","Arzheen",0,"health/visits",46,NULL,NULL,NULL,1597491816,12,1613848832,12),
(623,"5w2","8cb2237d0679ca88db6464eac60da96345513964",1,"users/blank_profile.png","5W2","Arzheen",0,"health/visits",46,NULL,NULL,NULL,1597491844,12,1613848832,12),
(624,"5w3","8cb2237d0679ca88db6464eac60da96345513964",1,"users/blank_profile.png","5W3","Arzheen",0,"health/visits",46,NULL,NULL,NULL,1597491873,12,1613848832,12),
(625,"physio","8cb2237d0679ca88db6464eac60da96345513964",1,"users/blank_profile.png","Physiotherapy","Arzheen",0,"health/visits",47,NULL,NULL,NULL,1598872947,12,1613848840,12),
(626,"4w1","8cb2237d0679ca88db6464eac60da96345513964",1,"users/blank_profile.png","4W1","Arzheen",0,"health/visits",46,NULL,NULL,NULL,1599467810,12,1613848832,12),
(627,"l1","8cb2237d0679ca88db6464eac60da96345513964",1,"users/blank_profile.png","Lab Technician 1","Arzheen",0,"lab/requests",40,NULL,NULL,NULL,1600257144,12,1613848787,12),
(628,"l2","8cb2237d0679ca88db6464eac60da96345513964",1,"users/blank_profile.png","Lab Technician 2","Arzheen",0,"lab/requests",40,NULL,NULL,NULL,1600257520,12,1613848787,12),
(629,"l3","8cb2237d0679ca88db6464eac60da96345513964",1,"users/blank_profile.png","Lab Technician 3","Arzheen",0,"lab/requests",40,NULL,NULL,NULL,1600257570,12,1613848787,12),
(630,"3w1","8cb2237d0679ca88db6464eac60da96345513964",1,"users/blank_profile.png","3W1","erbil",0,"health/patients",46,NULL,NULL,NULL,1602149698,12,1613848832,12),
(631,"3w1","8cb2237d0679ca88db6464eac60da96345513964",1,"users/blank_profile.png","3W1","Arzheen",0,"health/visits",46,NULL,NULL,NULL,1602150495,12,1613848832,12),
(632,"Bran","8cb2237d0679ca88db6464eac60da96345513964",1,"users/blank_profile.png","Bran","Arzheen",0,"lab/lab-reports",40,NULL,NULL,NULL,1603720639,12,1613848787,12),
(633,"shara","8cb2237d0679ca88db6464eac60da96345513964",1,"users/blank_profile.png","Shara Luqman","Erbil",0,"inventory/items",48,NULL,NULL,NULL,1606027102,12,1613848848,12),
(634,"TAVERZENI","219627a72cd0d235feb4dfaf31487ecc076baea1",0,"users/1617466084.jpg","Taverzeni","Erbil, Iraq",0,"accounting/account-transactions",49,1,NULL,NULL,1608643443,12,1708338778,639),
(635,"yahya","8cb2237d0679ca88db6464eac60da96345513964",1,"users/blank_profile.png","Yahya Zakarya","Erbil, Iraq",0,"health/radiology-report",43,NULL,NULL,NULL,1609253582,12,1613848813,12),
(636,"safini","7c4a8d09ca3762af61e59520943dc26494f8941b",1,"users/blank_profile.png","Muhammad Othman","Erbil, Iraq",0,"accounting/inventory-reports",43,NULL,NULL,NULL,1609420745,12,1613848813,12),
(637,"hemn","8cb2237d0679ca88db6464eac60da96345513964",1,"users/blank_profile.png","Hemn Burhan","Erbil, Iraq",0,"accounting/safes",43,NULL,NULL,NULL,1610887260,12,1613848813,12),
(638,"acc4","8cb2237d0679ca88db6464eac60da96345513964",1,"users/blank_profile.png","ACC4","Erbil, Iraq",0,"health/visits",42,NULL,NULL,NULL,1612360383,12,1613848807,12),
(639,"mahmood","97d76d2306429d0ea7b6e077ae7ff6f7f65161e3",0,"users/blank_profile.png","Mahmood","Erbil, Iraq",0,"core/dashboard",49,1,NULL,NULL,1617210067,634,1620127060,639),
(640,"MAYAR1","4cb0ea28df03a6b916c560ad39b02df11552a346",1,"users/blank_profile.png","MAYAR1","Erbil, Iraq",0,"accounting/maxpos-item-disc-unpaid",50,1,NULL,NULL,1617214750,639,1619520124,639),
(641,"Bahzad C","d56b263ff48fe550be4e4c3120b621c1354e89a9",0,"users/1627659359.png","Bahzad account","Erbil, Iraq",0,"accounting/maxpos-item-disc-unpaid",50,1,NULL,NULL,1617214849,634,1643813142,639),
(642,"Lina","5d964cd86ed32012181717139c9f5908a2b20e3f",0,"users/blank_profile.png","Lina","Erbil, Iraq",0,"accounting/maxpos-item-disc-unpaid",51,2,NULL,NULL,1617215339,634,1656484568,634),
(643,"ALLA.CB","0d1477f408c6b081a42c743a763af8b280344dc4",1,"users/blank_profile.png","ALLA","Baghdad, Iraq",0,"accounting/maxpos-item-disc-unpaid",51,2,NULL,NULL,1617215384,634,1643813542,634),
(644,"w.hedi","f121ea34d2d04d30e08f27933aa102b9ed8c1c33",0,"users/blank_profile.png","HEDI","Erbil, Iraq",95,"accounting/inventory-reports",52,1,NULL,NULL,1617216045,634,1679732656,634),
(645,"koral.nawzad","7021f212c05974169dad858121fde5ec9f22bf84",0,"users/blank_profile.png","Koral Nawzad","Erbil, Iraq",0,"accounting/sales",50,1,NULL,NULL,1617216083,634,1692628849,639),
(647,"Yusef","90214e4dbcb7e1c0ecd019ba74fef6c4d719a198",0,"users/blank_profile.png","Yusef","Baghdad, Iraq",0,"NULL",51,2,NULL,NULL,1659020592,639,1667212916,639);


DROP TABLE workflow_items;

CREATE TABLE `workflow_items` (
  `workflow_item_id` int(11) NOT NULL AUTO_INCREMENT,
  `table_name` varchar(500) DEFAULT NULL,
  `step` int(11) DEFAULT NULL,
  `next_step` int(11) DEFAULT NULL,
  `job_title_id` int(11) DEFAULT NULL,
  `flow_code` varchar(500) DEFAULT NULL,
  `flow_description` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`workflow_item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

DROP TABLE zones;

CREATE TABLE `zones` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(256) NOT NULL,
  `code` varchar(64) NOT NULL,
  `title` varchar(128) DEFAULT NULL,
  `title_ku` varchar(128) DEFAULT NULL,
  `address` varchar(128) DEFAULT NULL,
  `address_ku` varchar(128) DEFAULT NULL,
  `phones` varchar(128) DEFAULT NULL COMMENT 'Comma separated',
  `emails` varchar(256) DEFAULT NULL COMMENT 'Comma separated',
  `website` varchar(128) DEFAULT NULL,
  `logo` varchar(256) DEFAULT NULL,
  `logo_bw` varchar(256) DEFAULT NULL COMMENT 'Black and white',
  `created` int(11) DEFAULT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `modified` int(11) DEFAULT NULL,
  `modified_by` bigint(20) DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

INSERT INTO zones VALUES
(1,"Erbil Office","ERLO","Kiton-Iraq",NULL,"Gulan Park World Trade Center, Gulan St, Erbil",NULL,"+964 (0) 750 521 0007","customer@kiton-iraq.com","www.kiton.it",NULL,NULL,1617584445,12,1621830012,12,0),
(2,"Baghdad Office","BGDO","Kiton-Iraq",NULL,"Babylon Rotana, Karrada Street, Al-Jadria, Baghdad",NULL,"+964 (0) 781 111 6000","baghdad@kiton-iraq.com","www.kiton.it",NULL,NULL,1617584606,12,1621830003,12,0);


