SELECT id FROM collection_details WHERE collection_id = '8' AND au_id = '241' 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, '2025-05-01', '2025-06-01', 241, 3210.19, '1', '2')<pre>[1] Bait Al Maqdes Pharmacy ( Store )  => 3210.19</pre>SELECT id FROM collection_details WHERE collection_id = '405' AND au_id = '241' 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 (405, '2025-05-01', '2025-06-01', 241, 32361.37, '1', '2')<pre>[2] WESTERN DRUG & MEDICAL EQUIPMENT STORE LLC  => 32361.37</pre>SELECT id FROM collection_details WHERE collection_id = '18' AND au_id = '241' 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 (18, '2025-05-01', '2025-06-01', 241, 57314.67, '1', '2')<pre>[3] SUPER CARE PHARMACY LLC  => 57314.67</pre>SELECT id FROM collection_details WHERE collection_id = '267' AND au_id = '241' 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, '2025-05-01', '2025-06-01', 241, 124318.23, '1', '2')<pre>[4] Burjeel Pharmacy L.L.C.  => 124318.23</pre>SELECT id FROM collection_details WHERE collection_id = '422' 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 (422, '2025-05-01', '2025-06-01', 190, 342.02, '1', '2')<pre>[5] Zaith Pharmacy - Sole Proprietorship LLC  => 342.02</pre>SELECT id FROM collection_details WHERE collection_id = '131' 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 (131, '2025-05-01', '2025-06-01', 190, 5325.86, '1', '2')<pre>[6] Royal Care Pharmacy  => 5325.86</pre>SELECT id FROM collection_details WHERE collection_id = '46' 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 (46, '2025-05-01', '2025-06-01', 190, 5670, '1', '2')<pre>[7] HEALTH SHIELD MEDICAL CENTRE LLC  => 5670</pre>SELECT id FROM collection_details WHERE collection_id = '257' 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 (257, '2025-05-01', '2025-06-01', 190, 7500, '1', '2')<pre>[8] Everlast Wellness Medical Center LLC (PDC)  => 7500</pre>SELECT id FROM collection_details WHERE collection_id = '145' 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 (145, '2025-05-01', '2025-06-01', 190, 767.72, '1', '2')<pre>[9] Abu Sharia Pharmacy  => 767.72</pre>SELECT id FROM collection_details WHERE collection_id = '445' 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 (445, '2025-05-01', '2025-06-01', 190, 3255, '1', '2')<pre>[10] ACACIA MEDICAL CENTER(PDC)  => 3255</pre>SELECT id FROM collection_details WHERE collection_id = '32' AND au_id = '340' 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, '2025-05-01', '2025-06-01', 340, 91476.4, '1', '2')<pre>[11] Docib Medical Store LLC  => 91476.4</pre>SELECT id FROM collection_details WHERE collection_id = '434' AND au_id = '340' 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 (434, '2025-05-01', '2025-06-01', 340, 36004, '1', '2')<pre>[12] ACORUS PHARMA LLC  => 36004</pre>SELECT id FROM collection_details WHERE collection_id = '362' AND au_id = '340' 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, '2025-05-01', '2025-06-01', 340, 160143.01, '1', '2')<pre>[13] MPC DRUG STORE COMPANY LLC (SOLE PROPRIETORSHIP)  => 160143.01</pre>SELECT id FROM collection_details WHERE collection_id = '418' AND au_id = '327' 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 (418, '2025-05-01', '2025-06-01', 327, 466.2, '1', '2')<pre>[14] GUL GLAM MEDICAL CLINICS LLC  => 466.2</pre>SELECT id FROM collection_details WHERE collection_id = '393' AND au_id = '327' 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, '2025-05-01', '2025-06-01', 327, 635, '1', '2')<pre>[15] FMC Medical Centre LLC  => 635</pre>SELECT id FROM collection_details WHERE collection_id = '380' AND au_id = '327' 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, '2025-05-01', '2025-06-01', 327, 2058.49, '1', '2')<pre>[16] Mawi Day Surgical Center LLC (PDC)  => 2058.49</pre>SELECT id FROM collection_details WHERE collection_id = '334' AND au_id = '327' 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, '2025-05-01', '2025-06-01', 327, 2293.2, '1', '2')<pre>[17] VALIANT HEALTHCARE LLC (PDC)  => 2293.2</pre>SELECT id FROM collection_details WHERE collection_id = '315' AND au_id = '327' 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 (315, '2025-05-01', '2025-06-01', 327, 2296, '1', '2')<pre>[18] LOS ANGELES AESTHETIC MEDICAL CENTER LLC  => 2296</pre>SELECT id FROM collection_details WHERE collection_id = '420' AND au_id = '327' 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 (420, '2025-05-01', '2025-06-01', 327, 2365, '1', '2')<pre>[19] BEAUTIFY ME MEDICAL CENTER LLC  => 2365</pre>SELECT id FROM collection_details WHERE collection_id = '414' AND au_id = '327' 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 (414, '2025-05-01', '2025-06-01', 327, 2565.26, '1', '2')<pre>[20] DOME AESTHETIC MEDICAL CENTER (PDC)  => 2565.26</pre>SELECT id FROM collection_details WHERE collection_id = '345' AND au_id = '327' 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 (345, '2025-05-01', '2025-06-01', 327, 4211.6, '1', '2')<pre>[21] Bella Rose Medical Center LLC (PDC)  => 4211.6</pre>SELECT id FROM collection_details WHERE collection_id = '370' AND au_id = '327' 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, '2025-05-01', '2025-06-01', 327, 6680.87, '1', '2')<pre>[22] 515 MEDICAL TRAINING CLINIC LLC  => 6680.87</pre>SELECT id FROM collection_details WHERE collection_id = '408' AND au_id = '327' 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 (408, '2025-05-01', '2025-06-01', 327, 24750, '1', '2')<pre>[23] NOOR ALMAMZAR MEDICAL CENTRE  => 24750</pre>SELECT id FROM collection_details WHERE collection_id = '364' AND au_id = '327' 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, '2025-05-01', '2025-06-01', 327, 31270, '1', '2')<pre>[24] BELLA ROMA SPECIALTY HOSPITAL LLC  => 31270</pre>SELECT id FROM collection_details WHERE collection_id = '19' AND au_id = '291' 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, '2025-05-01', '2025-06-01', 291, 6799.76, '1', '2')<pre>[25] MEDCARE HOSPITAL (LLC)  => 6799.76</pre>SELECT id FROM collection_details WHERE collection_id = '398' AND au_id = '291' 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 (398, '2025-05-01', '2025-06-01', 291, 20329.46, '1', '2')<pre>[26] Ozone Pharmacy (CASH)  => 20329.46</pre>SELECT id FROM collection_details WHERE collection_id = '290' AND au_id = '291' 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, '2025-05-01', '2025-06-01', 291, 47999.15, '1', '2')<pre>[27] Glamour Care Clinics LLC(PDC)  => 47999.15</pre>SELECT id FROM collection_details WHERE collection_id = '284' AND au_id = '291' 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, '2025-05-01', '2025-06-01', 291, 50021.54, '1', '2')<pre>[28] SAMA SURGE MEDICAL CENTER-SOLE PROPRIETORSHIP LLC  => 50021.54</pre>SELECT id FROM collection_details WHERE collection_id = '242' AND au_id = '291' 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, '2025-05-01', '2025-06-01', 291, 61564.71, '1', '2')<pre>[29] Al Meead Dermatology Clinic LLC (PDC)  => 61564.71</pre>SELECT id FROM collection_details WHERE collection_id = '406' AND au_id = '291' 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 (406, '2025-05-01', '2025-06-01', 291, 118781.57, '1', '2')<pre>[30] NMC WHOLESALE DRUG STORE AND SUPPLIES LLC  => 118781.57</pre>SELECT id FROM collection_details WHERE collection_id = '16' AND au_id = '291' 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 (16, '2025-05-01', '2025-06-01', 291, 262224.27, '1', '2')<pre>[31] Saddmaareb Pharmacy(cash)  => 262224.27</pre>SELECT id FROM collection_details WHERE collection_id = '161' AND au_id = '232' 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 (161, '2025-05-01', '2025-06-01', 232, 408.1, '1', '2')<pre>[32] Al Yahar Pharmacy  => 408.1</pre>SELECT id FROM collection_details WHERE collection_id = '96' AND au_id = '232' 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 (96, '2025-05-01', '2025-06-01', 232, 1561.88, '1', '2')<pre>[33] Advance Cure Pharmacy LLC  => 1561.88</pre>SELECT id FROM collection_details WHERE collection_id = '287' AND au_id = '232' 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, '2025-05-01', '2025-06-01', 232, 2125, '1', '2')<pre>[34] German Advance Medical Centre Pharmacy L.L.C  => 2125</pre>SELECT id FROM collection_details WHERE collection_id = '61' AND au_id = '232' 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, '2025-05-01', '2025-06-01', 232, 2146.4, '1', '2')<pre>[35] Babil Pharmacy  => 2146.4</pre>SELECT id FROM collection_details WHERE collection_id = '327' AND au_id = '232' 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 (327, '2025-05-01', '2025-06-01', 232, 3600, '1', '2')<pre>[36] GRACE PHARMACY (PDC)  => 3600</pre>SELECT id FROM collection_details WHERE collection_id = '361' AND au_id = '232' 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, '2025-05-01', '2025-06-01', 232, 8878.12, '1', '2')<pre>[37] KNIGHTS PHARMACY LLC  => 8878.12</pre>SELECT id FROM collection_details WHERE collection_id = '332' AND au_id = '232' 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 (332, '2025-05-01', '2025-06-01', 232, 23881.8, '1', '2')<pre>[38] ORGANIC AND NATURAL PHARMACY - L.L.C - S.P.C  => 23881.8</pre>SELECT id FROM collection_details WHERE collection_id = '30' AND au_id = '232' 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, '2025-05-01', '2025-06-01', 232, 30307.38, '1', '2')<pre>[39] AL BUSTAN PHARMACY - SOLE PROPRIETORSHIP L.L.C  => 30307.38</pre>SELECT id FROM collection_details WHERE collection_id = '320' AND au_id = '313' 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, '2025-05-01', '2025-06-01', 313, 498.96, '1', '2')<pre>[40] Novomed Specialized Surgical Hospital LLC  => 498.96</pre>SELECT id FROM collection_details WHERE collection_id = '103' AND au_id = '313' 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, '2025-05-01', '2025-06-01', 313, 4018.91, '1', '2')<pre>[41] Land Mark Pharmacy  => 4018.91</pre>SELECT id FROM collection_details WHERE collection_id = '80' AND au_id = '313' 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, '2025-05-01', '2025-06-01', 313, 4798.21, '1', '2')<pre>[42] Al Bayan Pharmacy  => 4798.21</pre>SELECT id FROM collection_details WHERE collection_id = '74' AND au_id = '313' 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 (74, '2025-05-01', '2025-06-01', 313, 7974.37, '1', '2')<pre>[43] Tabarak Pharmacy  => 7974.37</pre>SELECT id FROM collection_details WHERE collection_id = '258' AND au_id = '313' 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 (258, '2025-05-01', '2025-06-01', 313, 16570.5, '1', '2')<pre>[44] Ultra Medical Center Pharmacy LLC  => 16570.5</pre>SELECT id FROM collection_details WHERE collection_id = '435' AND au_id = '313' 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 (435, '2025-05-01', '2025-06-01', 313, 26162.66, '1', '2')<pre>[45] MAX PHARMACY  => 26162.66</pre>SELECT id FROM collection_details WHERE collection_id = '6' AND au_id = '313' 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, '2025-05-01', '2025-06-01', 313, 87912.35, '1', '2')<pre>[46] Medicina Drug Store  => 87912.35</pre>SELECT id FROM collection_details WHERE collection_id = '444' AND au_id = '326' 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 (444, '2025-05-01', '2025-06-01', 326, 944, '1', '2')<pre>[47] KCH HEALTHCARE LLC  => 944</pre>SELECT id FROM collection_details WHERE collection_id = '42' AND au_id = '326' 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, '2025-05-01', '2025-06-01', 326, 330654.96, '1', '2')<pre>[48] MED SHOP DRUGS STORE (LLC)  => 330654.96</pre>SELECT id FROM collection_details WHERE collection_id = '33' AND au_id = '342' 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, '2025-05-01', '2025-06-01', 342, 15315.55, '1', '2')<pre>[49] EMIRATES HOSPITALS GROUP MEDICAL SUPPLIES LLC  => 15315.55</pre>SELECT id FROM collection_details WHERE collection_id = '77' AND au_id = '342' 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, '2025-05-01', '2025-06-01', 342, 72080, '1', '2')<pre>[50] PRIME MEDICAL STORE L.L.C  => 72080</pre>SELECT id FROM collection_details WHERE collection_id = '432' AND au_id = '342' 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 (432, '2025-05-01', '2025-06-01', 342, 6800, '1', '2')<pre>[51] AL TADAWI SPECIALTY HOSPITAL LLC  => 6800</pre>SELECT id FROM collection_details WHERE collection_id = '316' 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 (316, '2025-05-01', '2025-06-01', 9, 1732.5, '1', '2')<pre>[52] NAZEK PHARMACY - SOLE PROPRIETORSHIP LLC  => 1732.5</pre>SELECT id FROM collection_details WHERE collection_id = '436' 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 (436, '2025-05-01', '2025-06-01', 9, 2466.45, '1', '2')<pre>[53] RAFED HEALTHCARE SUPPLIES LLC  => 2466.45</pre>SELECT id FROM collection_details WHERE collection_id = '73' 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 (73, '2025-05-01', '2025-06-01', 9, 5406.75, '1', '2')<pre>[54] AL KHAJA STORE  => 5406.75</pre>SELECT id FROM collection_details WHERE collection_id = '381' 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 (381, '2025-05-01', '2025-06-01', 9, 6929.5, '1', '2')<pre>[55] Global Medical Supply Chain LLC O.P.C.  => 6929.5</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, '2025-05-01', '2025-06-01', 9, 22462.2, '1', '2')<pre>[56] Al Dewan Pharmacy - SOLE PROPRIETORSHIP LLC  => 22462.2</pre>SELECT id FROM collection_details WHERE collection_id = '88' 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 (88, '2025-05-01', '2025-06-01', 9, 49338.37, '1', '2')<pre>[57] Falaj Hazzaa Pharmacy (PDC)  => 49338.37</pre>SELECT id FROM collection_details WHERE collection_id = '22' 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 (22, '2025-05-01', '2025-06-01', 9, 106691.22, '1', '2')<pre>[58] AL AIN MEDICAL STORE - L.L.C.  => 106691.22</pre>SELECT id FROM collection_details WHERE collection_id = '402' 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 (402, '2025-05-01', '2025-06-01', 9, 74800, '1', '2')<pre>[59] BURJEEL DRUG STORE LLC  => 74800</pre>SELECT id FROM collection_details WHERE collection_id = '127' AND au_id = '335' 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 (127, '2025-05-01', '2025-06-01', 335, 20036.02, '1', '2')<pre>[60] BAIT AL BATTERJEE MEDICAL CO DUBAI BRANCH LLC  => 20036.02</pre>SELECT id FROM collection_details WHERE collection_id = '416' AND au_id = '335' 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 (416, '2025-05-01', '2025-06-01', 335, 463.5, '1', '2')<pre>[61] GAELAN PHARMACY SINGLE OWNER LLC  => 463.5</pre>SELECT id FROM collection_details WHERE collection_id = '357' AND au_id = '335' 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 (357, '2025-05-01', '2025-06-01', 335, 803.25, '1', '2')<pre>[62] CLINICA MEDICAL CENTER LLC  => 803.25</pre>SELECT id FROM collection_details WHERE collection_id = '340' AND au_id = '335' 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 (340, '2025-05-01', '2025-06-01', 335, 1543.65, '1', '2')<pre>[63] Dr Victoria Medical Center  => 1543.65</pre>SELECT id FROM collection_details WHERE collection_id = '189' AND au_id = '335' 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 (189, '2025-05-01', '2025-06-01', 335, 2296.89, '1', '2')<pre>[64] ORIANA PHARMACY LLC - SOLE PROPRIETORSHIP  => 2296.89</pre>SELECT id FROM collection_details WHERE collection_id = '421' AND au_id = '335' 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 (421, '2025-05-01', '2025-06-01', 335, 2420, '1', '2')<pre>[65] BRITISH MEDICAL COMPLEX LLC  => 2420</pre>SELECT id FROM collection_details WHERE collection_id = '396' AND au_id = '335' 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, '2025-05-01', '2025-06-01', 335, 4474, '1', '2')<pre>[66] COSMO HEALTH MEDICAL CENTER LLC (SOLO PROPRIETORSHIP)  => 4474</pre>SELECT id FROM collection_details WHERE collection_id = '385' AND au_id = '335' 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 (385, '2025-05-01', '2025-06-01', 335, 5884.75, '1', '2')<pre>[67] AL DALIL MEDICAL CENTER  => 5884.75</pre>SELECT id FROM collection_details WHERE collection_id = '387' AND au_id = '335' 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, '2025-05-01', '2025-06-01', 335, 6050, '1', '2')<pre>[68] DR. FARAH ALANSARI DERMATOLOGY CLINIC  => 6050</pre>SELECT id FROM collection_details WHERE collection_id = '83' AND au_id = '335' 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 (83, '2025-05-01', '2025-06-01', 335, 6221.87, '1', '2')<pre>[69] Dr. Samiha Abdulla Lutfi  => 6221.87</pre>SELECT id FROM collection_details WHERE collection_id = '250' AND au_id = '335' 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, '2025-05-01', '2025-06-01', 335, 6853, '1', '2')<pre>[70] COSMO HEALTH MEDICAL CENTER LLC  => 6853</pre>SELECT id FROM collection_details WHERE collection_id = '426' AND au_id = '335' 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 (426, '2025-05-01', '2025-06-01', 335, 9216.34, '1', '2')<pre>[71] ZAHRAT AL RAYHAN MEDICAL CENTER  => 9216.34</pre>SELECT id FROM collection_details WHERE collection_id = '289' AND au_id = '335' 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, '2025-05-01', '2025-06-01', 335, 9900, '1', '2')<pre>[72] The Garden Medical Centre LLC  => 9900</pre>SELECT id FROM collection_details WHERE collection_id = '376' AND au_id = '335' 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, '2025-05-01', '2025-06-01', 335, 10062.76, '1', '2')<pre>[73] SMILE CARE MEDICAL CENTER LLC  => 10062.76</pre>SELECT id FROM collection_details WHERE collection_id = '431' AND au_id = '335' 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 (431, '2025-05-01', '2025-06-01', 335, 17920.4, '1', '2')<pre>[74] SKINOVA MEDICAL CENTER LLC  => 17920.4</pre>SELECT id FROM collection_details WHERE collection_id = '133' AND au_id = '335' 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 (133, '2025-05-01', '2025-06-01', 335, 25321.2, '1', '2')<pre>[75] Medical Center Pharmacy  => 25321.2</pre>SELECT id FROM collection_details WHERE collection_id = '379' AND au_id = '335' 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 (379, '2025-05-01', '2025-06-01', 335, 72539.9, '1', '2')<pre>[76] HERMOSA MEDICAL CENTER  => 72539.9</pre>SELECT id FROM collection_details WHERE collection_id = '20' AND au_id = '335' 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 (20, '2025-05-01', '2025-06-01', 335, 117075.19, '1', '2')<pre>[77] Elite Pharmacy LLC  => 117075.19</pre>SELECT id FROM collection_details WHERE collection_id = '23' AND au_id = '335' 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, '2025-05-01', '2025-06-01', 335, 5064.88, '1', '2')<pre>[78] University Hospital Sharjah  => 5064.88</pre>SELECT id FROM collection_details WHERE collection_id = '441' AND au_id = '328' 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 (441, '2025-05-01', '2025-06-01', 328, 599.44, '1', '2')<pre>[79] ALSHARQ HOSPITAL  => 599.44</pre>SELECT id FROM collection_details WHERE collection_id = '210' AND au_id = '328' 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, '2025-05-01', '2025-06-01', 328, 612, '1', '2')<pre>[80] KHALID PHARMACY  => 612</pre>SELECT id FROM collection_details WHERE collection_id = '349' AND au_id = '328' 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, '2025-05-01', '2025-06-01', 328, 2595.54, '1', '2')<pre>[81] AL SHARQ FAMILY PHARMACY  => 2595.54</pre>SELECT id FROM collection_details WHERE collection_id = '439' AND au_id = '341' 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 (439, '2025-05-01', '2025-06-01', 341, 308.7, '1', '2')<pre>[82] HEALTHY FAMILY PHARMACY LLC. SP (PDC)  => 308.7</pre>SELECT id FROM collection_details WHERE collection_id = '347' AND au_id = '341' 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, '2025-05-01', '2025-06-01', 341, 1705.9, '1', '2')<pre>[83] GRAND ALEMAN PHARMACY LLC  => 1705.9</pre>SELECT id FROM collection_details WHERE collection_id = '365' AND au_id = '341' 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, '2025-05-01', '2025-06-01', 341, 2268, '1', '2')<pre>[84] AMEER PHARMACY LLC  => 2268</pre>SELECT id FROM collection_details WHERE collection_id = '228' AND au_id = '341' 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, '2025-05-01', '2025-06-01', 341, 3427.22, '1', '2')<pre>[85] Madinah Almadam Drug Store LLC  => 3427.22</pre>SELECT id FROM collection_details WHERE collection_id = '389' AND au_id = '341' 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, '2025-05-01', '2025-06-01', 341, 4259.74, '1', '2')<pre>[86] PHARMA CITY PHARMACY LLC  => 4259.74</pre>SELECT id FROM collection_details WHERE collection_id = '443' AND au_id = '341' 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 (443, '2025-05-01', '2025-06-01', 341, 7301.09, '1', '2')<pre>[87] ABU THANI PHARMACY  => 7301.09</pre>SELECT id FROM collection_details WHERE collection_id = '52' AND au_id = '341' 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, '2025-05-01', '2025-06-01', 341, 9414.89, '1', '2')<pre>[88] Balsam Pharmacy ( Dibba ) (PDC)  => 9414.89</pre>SELECT id FROM collection_details WHERE collection_id = '266' AND au_id = '341' 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, '2025-05-01', '2025-06-01', 341, 12407.65, '1', '2')<pre>[89] Al Eman Pharmacy / S.P.S - LLC)  => 12407.65</pre>SELECT id FROM collection_details WHERE collection_id = '407' AND au_id = '341' 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 (407, '2025-05-01', '2025-06-01', 341, 174849.76, '1', '2')<pre>[90] HEALTH LINK MEDICAL STORE LLC  => 174849.76</pre>SELECT id FROM collection_details WHERE collection_id = '154' AND au_id = '341' 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, '2025-05-01', '2025-06-01', 341, 6735.75, '1', '2')<pre>[91] DAR AL HARAM PHARMACY LLC  => 6735.75</pre>SELECT id FROM collection_details WHERE collection_id = '354' 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 (354, '2025-05-01', '2025-06-01', 172, 618.66, '1', '2')<pre>[92] HEALTH CURE PHARMACY  => 618.66</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, '2025-05-01', '2025-06-01', 172, 761.57, '1', '2')<pre>[93] Al Iman Pharmacy  => 761.57</pre>SELECT id FROM collection_details WHERE collection_id = '429' 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 (429, '2025-05-01', '2025-06-01', 172, 2167.2, '1', '2')<pre>[94] AL SHAMAL PHARMACY LLC  => 2167.2</pre>SELECT id FROM collection_details WHERE collection_id = '312' 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 (312, '2025-05-01', '2025-06-01', 172, 2814.54, '1', '2')<pre>[95] Capital Pharmacy LLC  => 2814.54</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, '2025-05-01', '2025-06-01', 172, 4187.67, '1', '2')<pre>[96] Medicom Pharmacy 15 (BR of D.M Pharmacies (L.L.C))  => 4187.67</pre>SELECT id FROM collection_details WHERE collection_id = '428' 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 (428, '2025-05-01', '2025-06-01', 172, 4020.9, '1', '2')<pre>[97] AL FAHLAIN PHARMACY  => 4020.9</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, '2025-05-01', '2025-06-01', 172, 5766.76, '1', '2')<pre>[98] Al Khawaneej Pharmacy  => 5766.76</pre>SELECT id FROM collection_details WHERE collection_id = '21' 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 (21, '2025-05-01', '2025-06-01', 172, 10000, '1', '2')<pre>[99] Al Neem Pharmacy (PDC)  => 10000</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, '2025-05-01', '2025-06-01', 172, 13935.87, '1', '2')<pre>[100] Al Manal Pharmacy  => 13935.87</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, '2025-05-01', '2025-06-01', 172, 19851.26, '1', '2')<pre>[101] Al Aqsa Pharmacy  => 19851.26</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, '2025-05-01', '2025-06-01', 172, 65542.65, '1', '2')<pre>[102] Al Shalal Pharmacy  => 65542.65</pre>