SELECT id FROM collection_details WHERE collection_id = '370' AND au_id = '190' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (370, '2023-12-01', '2024-01-01', 190, 11493.5, '1', '2')<pre>[1] 515 Medspa Center  => 11493.5</pre>SELECT id FROM collection_details WHERE collection_id = '277' AND au_id = '190' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (277, '2023-12-01', '2024-01-01', 190, 30844.85, '1', '2')<pre>[2] DR. KHALED AL NUAIMI PHARMACY  => 30844.85</pre>SELECT id FROM collection_details WHERE collection_id = '320' AND au_id = '190' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (320, '2023-12-01', '2024-01-01', 190, 2953.2, '1', '2')<pre>[3] Novomed Specialized Surgical Hospital LLC  => 2953.2</pre>SELECT id FROM collection_details WHERE collection_id = '384' AND au_id = '190' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (384, '2023-12-01', '2024-01-01', 190, 8505.2, '1', '2')<pre>[4] VALERA CLINICS  => 8505.2</pre>SELECT id FROM collection_details WHERE collection_id = '364' AND au_id = '190' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (364, '2023-12-01', '2024-01-01', 190, 17128.5, '1', '2')<pre>[5] BELLA ROMA SPECIALTY HOSPITAL LLC  => 17128.5</pre>SELECT id FROM collection_details WHERE collection_id = '317' AND au_id = '190' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (317, '2023-12-01', '2024-01-01', 190, 1086.25, '1', '2')<pre>[6] DE NOVA LASER COSMETIC CENTER DMCC (PDC)  => 1086.25</pre>SELECT id FROM collection_details WHERE collection_id = '358' AND au_id = '190' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (358, '2023-12-01', '2024-01-01', 190, 5524.6, '1', '2')<pre>[7] Cosmo Secrets Medical Center LLC  => 5524.6</pre>SELECT id FROM collection_details WHERE collection_id = '337' AND au_id = '190' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (337, '2023-12-01', '2024-01-01', 190, 3454.88, '1', '2')<pre>[8] RXNOW PHARMACY LLC  => 3454.88</pre>SELECT id FROM collection_details WHERE collection_id = '380' AND au_id = '190' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (380, '2023-12-01', '2024-01-01', 190, 8793.8, '1', '2')<pre>[9] Mawi Day Surgical Center LLC  => 8793.8</pre>SELECT id FROM collection_details WHERE collection_id = '393' AND au_id = '190' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (393, '2023-12-01', '2024-01-01', 190, 1720, '1', '2')<pre>[10] FMC Medical Centre LLC  => 1720</pre>SELECT id FROM collection_details WHERE collection_id = '397' AND au_id = '215' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (397, '2023-12-01', '2024-01-01', 215, 36327.21, '1', '2')<pre>[11] THE CHEMIST SHOP PHARMACY - SOLE PROPRIETORSHIP LLC  => 36327.21</pre>SELECT id FROM collection_details WHERE collection_id = '361' AND au_id = '215' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (361, '2023-12-01', '2024-01-01', 215, 14233.25, '1', '2')<pre>[12] KNIGHTS PHARMACY LLC  => 14233.25</pre>SELECT id FROM collection_details WHERE collection_id = '145' AND au_id = '215' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (145, '2023-12-01', '2024-01-01', 215, 43273.8, '1', '2')<pre>[13] Abu Sharia Pharmacy  => 43273.8</pre>SELECT id FROM collection_details WHERE collection_id = '61' AND au_id = '215' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (61, '2023-12-01', '2024-01-01', 215, 3604.5, '1', '2')<pre>[14] Babil Pharmacy  => 3604.5</pre>SELECT id FROM collection_details WHERE collection_id = '26' AND au_id = '215' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (26, '2023-12-01', '2024-01-01', 215, 2646, '1', '2')<pre>[15] Doctor Sherif Mattar Pharmacy L.L.C  => 2646</pre>SELECT id FROM collection_details WHERE collection_id = '103' AND au_id = '215' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (103, '2023-12-01', '2024-01-01', 215, 3890.72, '1', '2')<pre>[16] Land Mark Pharmacy  => 3890.72</pre>SELECT id FROM collection_details WHERE collection_id = '205' AND au_id = '215' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (205, '2023-12-01', '2024-01-01', 215, 3400, '1', '2')<pre>[17] HEALTH PLUS PHARMACY LLC  => 3400</pre>SELECT id FROM collection_details WHERE collection_id = '366' AND au_id = '215' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (366, '2023-12-01', '2024-01-01', 215, 81677.33, '1', '2')<pre>[18] True Life Pharmacy LLC  => 81677.33</pre>SELECT id FROM collection_details WHERE collection_id = '306' AND au_id = '215' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (306, '2023-12-01', '2024-01-01', 215, 5725.46, '1', '2')<pre>[19] BASEEM PHARMACY LLC (PDC)  => 5725.46</pre>SELECT id FROM collection_details WHERE collection_id = '305' AND au_id = '215' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (305, '2023-12-01', '2024-01-01', 215, 15300, '1', '2')<pre>[20] HEALTH LINE PHARMACY LLC  => 15300</pre>SELECT id FROM collection_details WHERE collection_id = '238' AND au_id = '3' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (238, '2023-12-01', '2024-01-01', 3, 9367.55, '1', '2')<pre>[21] Dr. Salah Al Kharraz (Cash)  => 9367.55</pre>SELECT id FROM collection_details WHERE collection_id = '365' AND au_id = '158' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (365, '2023-12-01', '2024-01-01', 158, 16642.43, '1', '2')<pre>[22] ABU THANI PHARMACY  => 16642.43</pre>SELECT id FROM collection_details WHERE collection_id = '347' AND au_id = '158' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (347, '2023-12-01', '2024-01-01', 158, 979.5, '1', '2')<pre>[23] GRAND ALEMAN PHARMACY LLC  => 979.5</pre>SELECT id FROM collection_details WHERE collection_id = '389' AND au_id = '158' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (389, '2023-12-01', '2024-01-01', 158, 6100.53, '1', '2')<pre>[24] PHARMA CITY PHARMACY LLC  => 6100.53</pre>SELECT id FROM collection_details WHERE collection_id = '72' AND au_id = '158' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (72, '2023-12-01', '2024-01-01', 158, 6237.15, '1', '2')<pre>[25] Heba Pharmacy  => 6237.15</pre>SELECT id FROM collection_details WHERE collection_id = '52' AND au_id = '158' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (52, '2023-12-01', '2024-01-01', 158, 30121.1, '1', '2')<pre>[26] Balsam Pharmacy ( Dibba )  => 30121.1</pre>SELECT id FROM collection_details WHERE collection_id = '110' AND au_id = '158' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (110, '2023-12-01', '2024-01-01', 158, 15088.91, '1', '2')<pre>[27] Bin Moosa Pharmacy  => 15088.91</pre>SELECT id FROM collection_details WHERE collection_id = '91' AND au_id = '158' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (91, '2023-12-01', '2024-01-01', 158, 24361.89, '1', '2')<pre>[28] Makkah Pharmacy  => 24361.89</pre>SELECT id FROM collection_details WHERE collection_id = '264' AND au_id = '158' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (264, '2023-12-01', '2024-01-01', 158, 19655.98, '1', '2')<pre>[29] Janah Pharmacy LLC  => 19655.98</pre>SELECT id FROM collection_details WHERE collection_id = '8' AND au_id = '158' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (8, '2023-12-01', '2024-01-01', 158, 7329.45, '1', '2')<pre>[30] Bait Al Maqdes Pharmacy ( Store )  => 7329.45</pre>SELECT id FROM collection_details WHERE collection_id = '266' AND au_id = '158' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (266, '2023-12-01', '2024-01-01', 158, 5313.43, '1', '2')<pre>[31] Al Eman Pharmacy  => 5313.43</pre>SELECT id FROM collection_details WHERE collection_id = '376' AND au_id = '175' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (376, '2023-12-01', '2024-01-01', 175, 4605, '1', '2')<pre>[32] SMILE CARE MEDICAL CENTER LLC  => 4605</pre>SELECT id FROM collection_details WHERE collection_id = '278' AND au_id = '175' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (278, '2023-12-01', '2024-01-01', 175, 37708.51, '1', '2')<pre>[33] SKINOVA LASER CLINIC LLC  => 37708.51</pre>SELECT id FROM collection_details WHERE collection_id = '387' AND au_id = '175' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (387, '2023-12-01', '2024-01-01', 175, 40350, '1', '2')<pre>[34] DR. FARAH ALANSARI DERMATOLOGY CLINIC  => 40350</pre>SELECT id FROM collection_details WHERE collection_id = '378' AND au_id = '175' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (378, '2023-12-01', '2024-01-01', 175, 5819.25, '1', '2')<pre>[35] GAELAN PHARMACY LLC  => 5819.25</pre>SELECT id FROM collection_details WHERE collection_id = '383' AND au_id = '175' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (383, '2023-12-01', '2024-01-01', 175, 2835, '1', '2')<pre>[36] LUXURY TOUCH MEDICAL CENTRE LLC  => 2835</pre>SELECT id FROM collection_details WHERE collection_id = '250' AND au_id = '175' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (250, '2023-12-01', '2024-01-01', 175, 16590.2, '1', '2')<pre>[37] COSMO HEALTH MEDICAL CENTER LLC  => 16590.2</pre>SELECT id FROM collection_details WHERE collection_id = '242' AND au_id = '175' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (242, '2023-12-01', '2024-01-01', 175, 2208.71, '1', '2')<pre>[38] Al Meead Dermatology Clinic LLC (PDC)  => 2208.71</pre>SELECT id FROM collection_details WHERE collection_id = '372' AND au_id = '175' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (372, '2023-12-01', '2024-01-01', 175, 8577.14, '1', '2')<pre>[39] Basmat Al Hayat Medical Centre (PDC)  => 8577.14</pre>SELECT id FROM collection_details WHERE collection_id = '289' AND au_id = '175' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (289, '2023-12-01', '2024-01-01', 175, 3213, '1', '2')<pre>[40] The Garden Medical Centre LLC  => 3213</pre>SELECT id FROM collection_details WHERE collection_id = '396' AND au_id = '175' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (396, '2023-12-01', '2024-01-01', 175, 4384.25, '1', '2')<pre>[41] COSMO HEALTH MEDICAL CENTER LLC (SOLO PROPRIETORSHIP)  => 4384.25</pre>SELECT id FROM collection_details WHERE collection_id = '253' AND au_id = '175' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (253, '2023-12-01', '2024-01-01', 175, 1656.11, '1', '2')<pre>[42] Ajman Speciality Hospital  => 1656.11</pre>SELECT id FROM collection_details WHERE collection_id = '349' AND au_id = '175' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (349, '2023-12-01', '2024-01-01', 175, 19858.33, '1', '2')<pre>[43] AL SHARQ FAMILY PHARMACY  => 19858.33</pre>SELECT id FROM collection_details WHERE collection_id = '354' AND au_id = '9' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (354, '2023-12-01', '2024-01-01', 9, 2164.05, '1', '2')<pre>[44] HEALTH CURE PHARMACY  => 2164.05</pre>SELECT id FROM collection_details WHERE collection_id = '229' AND au_id = '9' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (229, '2023-12-01', '2024-01-01', 9, 11995.8, '1', '2')<pre>[45] Cosmi Derm Medical Center  => 11995.8</pre>SELECT id FROM collection_details WHERE collection_id = '29' AND au_id = '9' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (29, '2023-12-01', '2024-01-01', 9, 46131.21, '1', '2')<pre>[46] Al Dewan Pharmacy - SOLE PROPRIETORSHIP LLC  => 46131.21</pre>SELECT id FROM collection_details WHERE collection_id = '80' AND au_id = '9' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (80, '2023-12-01', '2024-01-01', 9, 23730.9, '1', '2')<pre>[47] Al Bayan Pharmacy  => 23730.9</pre>SELECT id FROM collection_details WHERE collection_id = '399' AND au_id = '9' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (399, '2023-12-01', '2024-01-01', 9, 66400, '1', '2')<pre>[48] AH CARE PHARMACY LLC  => 66400</pre>SELECT id FROM collection_details WHERE collection_id = '31' AND au_id = '9' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (31, '2023-12-01', '2024-01-01', 9, 8998.4, '1', '2')<pre>[49] Harley Street Pharmacy  => 8998.4</pre>SELECT id FROM collection_details WHERE collection_id = '371' AND au_id = '9' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (371, '2023-12-01', '2024-01-01', 9, 6600, '1', '2')<pre>[50] SADD MAAREB MEDICAL CENTER PHARMACY LLC  => 6600</pre>SELECT id FROM collection_details WHERE collection_id = '341' AND au_id = '9' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (341, '2023-12-01', '2024-01-01', 9, 18846.6, '1', '2')<pre>[51] ALBASMA PHARMACY  => 18846.6</pre>SELECT id FROM collection_details WHERE collection_id = '30' AND au_id = '9' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (30, '2023-12-01', '2024-01-01', 9, 17392.26, '1', '2')<pre>[52] AL BUSTAN PHARMACY - SOLE PROPRIETORSHIP L.L.C  => 17392.26</pre>SELECT id FROM collection_details WHERE collection_id = '286' AND au_id = '9' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (286, '2023-12-01', '2024-01-01', 9, 20231.46, '1', '2')<pre>[53] Alhikma Pharmacy  => 20231.46</pre>SELECT id FROM collection_details WHERE collection_id = '287' AND au_id = '9' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (287, '2023-12-01', '2024-01-01', 9, 3820.8, '1', '2')<pre>[54] German Advance Medical Centre Pharmacy L.L.C  => 3820.8</pre>SELECT id FROM collection_details WHERE collection_id = '23' AND au_id = '194' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (23, '2023-12-01', '2024-01-01', 194, 4882.5, '1', '2')<pre>[55] University Hospital Sharjah  => 4882.5</pre>SELECT id FROM collection_details WHERE collection_id = '32' AND au_id = '194' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (32, '2023-12-01', '2024-01-01', 194, 32373.69, '1', '2')<pre>[56] Docib Medical Store LLC  => 32373.69</pre>SELECT id FROM collection_details WHERE collection_id = '267' AND au_id = '194' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (267, '2023-12-01', '2024-01-01', 194, 17786.08, '1', '2')<pre>[57] Burjeel Pharmacy L.L.C.  => 17786.08</pre>SELECT id FROM collection_details WHERE collection_id = '402' AND au_id = '194' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (402, '2023-12-01', '2024-01-01', 194, 1034030.44, '1', '2')<pre>[58] BURJEEL DRUG STORE LLC  => 1034030.44</pre>SELECT id FROM collection_details WHERE collection_id = '22' AND au_id = '194' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (22, '2023-12-01', '2024-01-01', 194, 209718.38, '1', '2')<pre>[59] AL AIN MEDICAL STORE - L.L.C.  => 209718.38</pre>SELECT id FROM collection_details WHERE collection_id = '10' AND au_id = '194' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (10, '2023-12-01', '2024-01-01', 194, 73941, '1', '2')<pre>[60] Awafi Drug Store  => 73941</pre>SELECT id FROM collection_details WHERE collection_id = '392' AND au_id = '194' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (392, '2023-12-01', '2024-01-01', 194, 18412.5, '1', '2')<pre>[61] ONE EIGHTY MEDICAL CENTER (PDC)  => 18412.5</pre>SELECT id FROM collection_details WHERE collection_id = '381' AND au_id = '194' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (381, '2023-12-01', '2024-01-01', 194, 1071, '1', '2')<pre>[62] GLOBAL MEDICAL SUPPLYCHAIN LLC (PDC)  => 1071</pre>SELECT id FROM collection_details WHERE collection_id = '362' AND au_id = '194' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (362, '2023-12-01', '2024-01-01', 194, 10136.69, '1', '2')<pre>[63] MPC DRUG STORE COMPANY LLC (SOLE PROPRIETORSHIP)  => 10136.69</pre>SELECT id FROM collection_details WHERE collection_id = '42' AND au_id = '194' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (42, '2023-12-01', '2024-01-01', 194, 21195.4, '1', '2')<pre>[64] Aster Pharmacy-Med Shop Drug store L.L.C  => 21195.4</pre>SELECT id FROM collection_details WHERE collection_id = '33' AND au_id = '194' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (33, '2023-12-01', '2024-01-01', 194, 54400, '1', '2')<pre>[65] EMIRATES HOSPITALS GROUP MEDICAL SUPPLIES LLC  => 54400</pre>SELECT id FROM collection_details WHERE collection_id = '19' AND au_id = '194' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (19, '2023-12-01', '2024-01-01', 194, 6800, '1', '2')<pre>[66] Med Care Pharmacy  => 6800</pre>SELECT id FROM collection_details WHERE collection_id = '6' AND au_id = '194' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (6, '2023-12-01', '2024-01-01', 194, 156915.66, '1', '2')<pre>[67] Medicina Drug Store  => 156915.66</pre>SELECT id FROM collection_details WHERE collection_id = '123' AND au_id = '216' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (123, '2023-12-01', '2024-01-01', 216, 3584.58, '1', '2')<pre>[68] Zulekha Medicine and Medical Equipment Store LLC (PDC)  => 3584.58</pre>SELECT id FROM collection_details WHERE collection_id = '77' AND au_id = '216' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (77, '2023-12-01', '2024-01-01', 216, 3400, '1', '2')<pre>[69] PRIME MEDICAL STORE L.L.C  => 3400</pre>SELECT id FROM collection_details WHERE collection_id = '353' AND au_id = '216' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (353, '2023-12-01', '2024-01-01', 216, 1300.5, '1', '2')<pre>[70] GARGASH HOSPITAL LLC  => 1300.5</pre>SELECT id FROM collection_details WHERE collection_id = '212' AND au_id = '216' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (212, '2023-12-01', '2024-01-01', 216, 1378.13, '1', '2')<pre>[71] Canadian Specialist Hospital  => 1378.13</pre>SELECT id FROM collection_details WHERE collection_id = '355' AND au_id = '128' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (355, '2023-12-01', '2024-01-01', 128, 11593.8, '1', '2')<pre>[72] GENOVA MEDICAL CENTER  => 11593.8</pre>SELECT id FROM collection_details WHERE collection_id = '259' AND au_id = '128' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (259, '2023-12-01', '2024-01-01', 128, 43819.11, '1', '2')<pre>[73] AL KAYAN PHARMACY LLC  => 43819.11</pre>SELECT id FROM collection_details WHERE collection_id = '290' AND au_id = '128' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (290, '2023-12-01', '2024-01-01', 128, 47999.15, '1', '2')<pre>[74] Glamour Care Clinics L.L.C  => 47999.15</pre>SELECT id FROM collection_details WHERE collection_id = '257' AND au_id = '128' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (257, '2023-12-01', '2024-01-01', 128, 12318.15, '1', '2')<pre>[75] Everlast Wellness Medical Center LLC (PDC)  => 12318.15</pre>SELECT id FROM collection_details WHERE collection_id = '15' AND au_id = '128' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (15, '2023-12-01', '2024-01-01', 128, 43398.47, '1', '2')<pre>[76] Gulf Diagnostic Center Hospital (PDC)  => 43398.47</pre>SELECT id FROM collection_details WHERE collection_id = '374' AND au_id = '128' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (374, '2023-12-01', '2024-01-01', 128, 8043, '1', '2')<pre>[77] STYLE AGE FZ- LLC (PDC)  => 8043</pre>SELECT id FROM collection_details WHERE collection_id = '334' AND au_id = '128' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (334, '2023-12-01', '2024-01-01', 128, 2311.4, '1', '2')<pre>[78] VALIANT HEALTHCARE LLC (PDC)  => 2311.4</pre>SELECT id FROM collection_details WHERE collection_id = '153' AND au_id = '128' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (153, '2023-12-01', '2024-01-01', 128, 20605.91, '1', '2')<pre>[79] AL ANAMEL PHARMACY  => 20605.91</pre>SELECT id FROM collection_details WHERE collection_id = '300' AND au_id = '128' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (300, '2023-12-01', '2024-01-01', 128, 1058.4, '1', '2')<pre>[80] ISAPS Clinic (PDC)  => 1058.4</pre>SELECT id FROM collection_details WHERE collection_id = '284' AND au_id = '128' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (284, '2023-12-01', '2024-01-01', 128, 50021.54, '1', '2')<pre>[81] SAMA SURGE MEDICAL CENTER-SOLE PROPRIETORSHIP LLC  => 50021.54</pre>SELECT id FROM collection_details WHERE collection_id = '25' AND au_id = '128' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (25, '2023-12-01', '2024-01-01', 128, 118781.58, '1', '2')<pre>[82] New Medical Center Trading LTD  => 118781.58</pre>SELECT id FROM collection_details WHERE collection_id = '197' AND au_id = '128' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (197, '2023-12-01', '2024-01-01', 128, 992.25, '1', '2')<pre>[83] Belhoul Speciality Pharmacy (PDC)  => 992.25</pre>SELECT id FROM collection_details WHERE collection_id = '377' AND au_id = '172' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (377, '2023-12-01', '2024-01-01', 172, 4468.56, '1', '2')<pre>[84] SAMARA PHARMACY LLC  => 4468.56</pre>SELECT id FROM collection_details WHERE collection_id = '351' AND au_id = '172' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (351, '2023-12-01', '2024-01-01', 172, 1168.64, '1', '2')<pre>[85] Najma Al Shifa Pharmacy LLC  => 1168.64</pre>SELECT id FROM collection_details WHERE collection_id = '228' AND au_id = '172' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (228, '2023-12-01', '2024-01-01', 172, 2575.55, '1', '2')<pre>[86] Madinah Almadam Drug Store LLC  => 2575.55</pre>SELECT id FROM collection_details WHERE collection_id = '403' AND au_id = '172' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (403, '2023-12-01', '2024-01-01', 172, 1280, '1', '2')<pre>[87] Al Roomy Pharmacy(PDC On Delivery)  => 1280</pre>SELECT id FROM collection_details WHERE collection_id = '210' AND au_id = '172' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (210, '2023-12-01', '2024-01-01', 172, 1991.64, '1', '2')<pre>[88] KHALID PHARMACY  => 1991.64</pre>SELECT id FROM collection_details WHERE collection_id = '203' AND au_id = '172' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (203, '2023-12-01', '2024-01-01', 172, 3473.64, '1', '2')<pre>[89] Medicom Pharmacy 15 (BR of D.M Pharmacies (L.L.C))  => 3473.64</pre>SELECT id FROM collection_details WHERE collection_id = '121' AND au_id = '172' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (121, '2023-12-01', '2024-01-01', 172, 51088.43, '1', '2')<pre>[90] Al Shalal Pharmacy  => 51088.43</pre>SELECT id FROM collection_details WHERE collection_id = '54' AND au_id = '172' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (54, '2023-12-01', '2024-01-01', 172, 16081.27, '1', '2')<pre>[91] Sinan Pharmacy L.L.C  => 16081.27</pre>SELECT id FROM collection_details WHERE collection_id = '81' AND au_id = '172' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (81, '2023-12-01', '2024-01-01', 172, 30621.85, '1', '2')<pre>[92] Al Iman Pharmacy  => 30621.85</pre>SELECT id FROM collection_details WHERE collection_id = '69' AND au_id = '172' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (69, '2023-12-01', '2024-01-01', 172, 4407.15, '1', '2')<pre>[93] Al Manal Pharmacy  => 4407.15</pre>SELECT id FROM collection_details WHERE collection_id = '38' AND au_id = '172' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (38, '2023-12-01', '2024-01-01', 172, 63224.07, '1', '2')<pre>[94] Al Aqsa Pharmacy  => 63224.07</pre>SELECT id FROM collection_details WHERE collection_id = '188' AND au_id = '172' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (188, '2023-12-01', '2024-01-01', 172, 3126.44, '1', '2')<pre>[95] Noor Al Haram Pharmacy  => 3126.44</pre>SELECT id FROM collection_details WHERE collection_id = '154' AND au_id = '172' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (154, '2023-12-01', '2024-01-01', 172, 3279.33, '1', '2')<pre>[96] DAR AL HARAM PHARMACY LLC  => 3279.33</pre>SELECT id FROM collection_details WHERE collection_id = '175' AND au_id = '172' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (175, '2023-12-01', '2024-01-01', 172, 1414.8, '1', '2')<pre>[97] Al Afdhal Pharmacy  => 1414.8</pre>SELECT id FROM collection_details WHERE collection_id = '158' AND au_id = '172' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (158, '2023-12-01', '2024-01-01', 172, 4169.49, '1', '2')<pre>[98] Al Afdhal Pharmacy-1  => 4169.49</pre>SELECT id FROM collection_details WHERE collection_id = '84' AND au_id = '172' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (84, '2023-12-01', '2024-01-01', 172, 10281.57, '1', '2')<pre>[99] Al Khawaneej Pharmacy  => 10281.57</pre>SELECT id FROM collection_details WHERE collection_id = '217' AND au_id = '172' ORDER BY id DESC LIMIT 1INSERT INTO collection_details (collection_id, cd_date, cd_closing_date, au_id, cd_outstanding, cd_currently_active, cd_modified_by) VALUES (217, '2023-12-01', '2024-01-01', 172, 6308.58, '1', '2')<pre>[100] Al Qarain Pharmacy  => 6308.58</pre>