('f0471f1a-2149-4b3a-814c-5d24246af5ce',71,NULL,450,'KES',NULL,NULL,NULL,'succeeded','2025-04-29 12:42:09','2025-04-29 12:42:16','MPESA','b2b','buy_goods','','{\"type\": \"business_buy_goods\", \"amount\": 450, \"msisdn\": \"544510\", \"reference\": \"food\", \"merchant_id\": \"5141482\"}','{\"amount\": \"450\", \"msisdn\": \"544510\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"food\", \"created_at\": \"2025-04-29 12:42:10\", \"finalised_at\": \"2025-04-29T12:42:13.000000Z\", \"transaction_type\": \"business_buy_goods\", \"vendor_reference\": \"TDT2OSXHJG\", \"silkpesa_reference\": \"SIL-1745930530-551\", \"receiver_description\": null}',NULL,'TDT2OSXHJG',NULL,NULL),('f04edc2d-cd8e-43d3-8b8b-e91fa1c81584',9,NULL,100,'KES',NULL,NULL,NULL,'succeeded','2025-10-04 11:09:16','2025-10-04 11:09:22','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 100, \"msisdn\": \"254705909823\", \"reference\": \"afripesa\", \"merchant_id\": \"5141482\"}','{\"amount\": \"100\", \"msisdn\": \"254705909823\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"currency\": \"KES\", \"reference\": \"afripesa\", \"created_at\": \"2025-10-04 08:09:16\", \"finalised_at\": \"2025-10-04T08:09:19.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TJ4RP6GQI5\", \"silkpesa_reference\": \"SIL-1759565356-679\", \"receiver_description\": \"0705909823 - issa sheik Aden\"}',NULL,'TJ4RP6GQI5','0705909823 - issa sheik Aden',NULL),('f0590f0d-d556-4ec7-8d55-a5863c6fc2da',9,'4E50A90A-F5B7-4EF3-9499-ACF88AB68EE7',500,'KES','{\"Result\": \"000\", \"TransRef\": \"R63316533\", \"TransToken\": \"4E50A90A-F5B7-4EF3-9499-ACF88AB68EE7\", \"ResultExplanation\": \"Transaction created\"}','{\"pnrID\": \"XZEMAU\", \"transID\": \"4E50A90A-F5B7-4EF3-9499-ACF88AB68EE7\", \"companyRef\": \"XZEMAU\", \"ccdApproval\": \"769425\", \"transactionToken\": \"4E50A90A-F5B7-4EF3-9499-ACF88AB68EE7\"}','{\"AccRef\": {}, \"Result\": \"000\", \"FraudAlert\": \"001\", \"CustomerZip\": \"254\", \"CustomerCity\": \"nairobi\", \"CustomerName\": \"Mohamed Adan\", \"CustomerPhone\": \"721812719\", \"CustomerCredit\": \"1195\", \"CustomerAddress\": \"Emabakasi\", \"CustomerCountry\": \"Kenya\", \"FraudExplnation\": \"Low Risk (Not checked)\", \"ResultExplanation\": \"Transaction Paid\", \"TransactionAmount\": \"500.00\", \"CustomerCreditType\": \"MASC\", \"TransactionApproval\": \"769425\", \"TransactionCurrency\": \"KES\", \"MobilePaymentRequest\": \"Not sent\", \"TransactionNetAmount\": \"0.00\", \"TransactionFinalAmount\": \"500.00\", \"TransactionFinalCurrency\": \"KES\", \"TransactionSettlementDate\": \"2024/12/10\", \"TransactionRollingReserveDate\": {}, \"TransactionRollingReserveAmount\": \"0.00\"}','succeeded','2024-12-10 12:00:01','2024-12-10 12:01:50','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('f0a70a51-bb71-432e-8c5f-ffebc83b4137',9,NULL,45,'KES',NULL,NULL,NULL,'succeeded','2025-01-14 14:47:04','2025-01-14 14:47:06','MPESA','b2c',NULL,'','{\"Amount\": \"45\", \"PartyA\": \"5141482\", \"PartyB\": \"254722903442\", \"Remarks\": \"test\", \"CommandID\": \"BusinessPayment\", \"Occassion\": \"test\", \"ResultURL\": \"https://app.safaribucks.com/api/mpesa/business_to_customer/result\", \"InitiatorName\": \"gloclienapiuser\", \"QueueTimeOutURL\": \"https://app.safaribucks.com/api/mpesa/business_to_customer/result\", \"SecurityCredential\": \"h9ruIJPoXZGgN198sojAIaXXvGvA52vuC0tugf1Ub452mxlrVYCrYuVJC10PgSE7uDpejzIavdGQar5MjS5nNekIra6Cbc7HLbEcx4bZOPdQXEzz7NRCdQK2Ty2y677O2O3ejY9WSQ0Q4mPhe3R7yX45CkS/5GCiMolxkmtEZ9wTioD/IZ4H6cfADo+p4MQHnCwOHCv37ldD3LW4/K+OSp3Vr/SWfia7Mj3UJFFIb1TfYsnv9PZ2oydjbRYXHarVh4OcpehJ50U1Td1ZaNsQ57c0I+HQ4AgtisnFoTBHE5yTYBcjZAglB2dYJAJgs/9NtLP0iUXz+4AMIDJHLHR9bA==\", \"OriginatorConversationID\": \"f0a70a51-bb71-432e-8c5f-ffebc83b4137\"}','{\"Result\": {\"ResultCode\": 0, \"ResultDesc\": \"The service request is processed successfully.\", \"ResultType\": 0, \"ReferenceData\": {\"ReferenceItem\": {\"Key\": \"QueueTimeoutURL\", \"Value\": \"http://internalapi.safaricom.co.ke/mpesa/b2cresults/v1/submit\"}}, \"TransactionID\": \"TAE47O3YII\", \"ConversationID\": \"AG_20250114_20205eedffe76798baf1\", \"ResultParameters\": {\"ResultParameter\": [{\"Key\": \"TransactionAmount\", \"Value\": 45}, {\"Key\": \"TransactionReceipt\", \"Value\": \"TAE47O3YII\"}, {\"Key\": \"ReceiverPartyPublicName\", \"Value\": \"254722903442 - OFWONA EDITH\"}, {\"Key\": \"TransactionCompletedDateTime\", \"Value\": \"14.01.2025 20:47:06\"}, {\"Key\": \"B2CUtilityAccountAvailableFunds\", \"Value\": 2477}, {\"Key\": \"B2CWorkingAccountAvailableFunds\", \"Value\": 571}, {\"Key\": \"B2CRecipientIsRegisteredCustomer\", \"Value\": \"Y\"}, {\"Key\": \"B2CChargesPaidAccountAvailableFunds\", \"Value\": 0}]}, \"OriginatorConversationID\": \"f0a70a51-bb71-432e-8c5f-ffebc83b4137\"}}',NULL,NULL,NULL,NULL),('f0b4bc5b-1fc8-465c-b0e9-2f4d84724de7',24,NULL,10,'KES',NULL,NULL,NULL,'accepted','2025-10-31 11:53:29','2025-10-31 11:53:30','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 10, \"msisdn\": \"254722712101\", \"reference\": \"ali\", \"merchant_id\": \"5141482\"}',NULL,NULL,NULL,NULL,NULL),('f0b7b84d-3e29-4f69-90a6-eea439e70718',71,NULL,8000,'KES',NULL,NULL,NULL,'failed','2025-04-29 17:50:40','2025-04-29 17:50:45','MPESA','b2b','buy_goods','','{\"type\": \"business_buy_goods\", \"amount\": 8000, \"msisdn\": \"544510\", \"reference\": \"Lodge\", \"merchant_id\": \"5141482\"}','{\"amount\": \"8000\", \"msisdn\": \"544510\", \"status\": \"FAILED\", \"channel\": \"KE.MPESA\", \"reference\": \"Lodge\", \"created_at\": \"2025-04-29 17:50:40\", \"finalised_at\": \"2025-04-29T17:50:42.000000Z\", \"transaction_type\": \"business_buy_goods\", \"vendor_reference\": null, \"silkpesa_reference\": \"SIL-1745949040-420\", \"receiver_description\": null}',NULL,NULL,NULL,NULL),('f0ebe47f-3931-4253-b290-bc04865b024f',9,NULL,1000,'KES',NULL,NULL,NULL,'accepted','2025-09-20 16:37:14','2025-09-20 16:37:14','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 1000, \"msisdn\": \"254742702160\", \"reference\": \"team\", \"merchant_id\": \"5141482\"}',NULL,NULL,NULL,NULL,NULL),('f0f50103-3437-486f-8c40-eb4cac8112a5',9,NULL,25,'KES',NULL,NULL,NULL,'succeeded','2025-05-17 18:27:59','2025-05-17 18:28:05','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 25, \"msisdn\": \"254722757783\", \"reference\": \"testing\", \"merchant_id\": \"5141482\"}','{\"amount\": \"25\", \"msisdn\": \"254722757783\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"testing\", \"created_at\": \"2025-05-17 15:27:59\", \"finalised_at\": \"2025-05-17T15:28:03.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TEH853STUS\", \"silkpesa_reference\": \"SIL-1747495679-273\", \"receiver_description\": \"254722757783 - SALAH OSMAN ADAN\"}',NULL,'TEH853STUS','254722757783 - SALAH OSMAN ADAN',NULL),('f0f8c2e5-1293-43e6-864c-196a64fabbcb',9,'00257EF0-9933-42E9-9D92-DA4E0742A30B',130,'KES','{\"Result\": \"000\", \"TransRef\": \"R64578885\", \"TransToken\": \"00257EF0-9933-42E9-9D92-DA4E0742A30B\", \"ResultExplanation\": \"Transaction created\"}','{\"pnrID\": \"XZEMAU\", \"transID\": \"00257EF0-9933-42E9-9D92-DA4E0742A30B\", \"companyRef\": \"XZEMAU\", \"ccdApproval\": \"769438\", \"transactionToken\": \"00257EF0-9933-42E9-9D92-DA4E0742A30B\"}','{\"AccRef\": {}, \"Result\": \"000\", \"FraudAlert\": \"001\", \"CustomerZip\": \"254\", \"CustomerCity\": \"nairobi\", \"CustomerName\": \"Mohamed Adan\", \"CustomerPhone\": \"721812719\", \"CustomerCredit\": \"1195\", \"CustomerAddress\": \"Emabakasi\", \"CustomerCountry\": \"Kenya\", \"FraudExplnation\": \"Low Risk (Not checked)\", \"ResultExplanation\": \"Transaction Paid\", \"TransactionAmount\": \"130.00\", \"CustomerCreditType\": \"MASC\", \"TransactionApproval\": \"769438\", \"TransactionCurrency\": \"KES\", \"MobilePaymentRequest\": \"Not sent\", \"TransactionNetAmount\": \"0.00\", \"TransactionFinalAmount\": \"130.00\", \"TransactionFinalCurrency\": \"KES\", \"TransactionSettlementDate\": \"2025/01/23\", \"TransactionRollingReserveDate\": {}, \"TransactionRollingReserveAmount\": \"0.00\"}','succeeded','2025-01-23 07:40:39','2025-01-23 07:45:04','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('f106ce1c-da73-483f-917c-299a50bde594',24,'7CFB2F9B-7672-4EB4-8275-4DFC24020055',10,'USD','{\"Result\":\"000\",\"ResultExplanation\":\"Transaction created\",\"TransToken\":\"7CFB2F9B-7672-4EB4-8275-4DFC24020055\",\"TransRef\":\"R68707813\"}',NULL,NULL,'accepted','2025-06-04 15:28:48','2025-06-04 15:28:48','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('f107462c-1385-4ac9-af85-390313e39065',48,NULL,2000,'KES',NULL,NULL,NULL,'succeeded','2025-04-28 15:29:27','2025-04-28 15:29:32','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 2000, \"msisdn\": \"254799931221\", \"reference\": \"Ahmed A Jama\", \"merchant_id\": \"5141482\"}','{\"amount\": \"2000\", \"msisdn\": \"254799931221\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"Ahmed A Jama\", \"created_at\": \"2025-04-28 15:29:27\", \"finalised_at\": \"2025-04-28T15:29:29.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TDS5KWHBEV\", \"silkpesa_reference\": \"SIL-1745854167-432\", \"receiver_description\": \"0799931221 - AHMED ABDI JAMA\"}',NULL,'TDS5KWHBEV','0799931221 - AHMED ABDI JAMA',NULL),('f10f17f4-5f0b-4049-b744-2903042abdf0',3,'96B23915-ABAB-4776-8CCE-5CFC5EFAF2C0',1,'KES','{\"Result\": \"000\", \"TransRef\": \"R61928240\", \"TransToken\": \"96B23915-ABAB-4776-8CCE-5CFC5EFAF2C0\", \"ResultExplanation\": \"Transaction created\"}','{\"pnrID\": \"XZEMAU\", \"transID\": \"96B23915-ABAB-4776-8CCE-5CFC5EFAF2C0\", \"companyRef\": \"XZEMAU\", \"ccdApproval\": \"SJR1K7JS57\", \"transactionToken\": \"96B23915-ABAB-4776-8CCE-5CFC5EFAF2C0\"}','{\"AccRef\": {}, \"Result\": \"000\", \"FraudAlert\": \"001\", \"CustomerZip\": {}, \"CustomerCity\": {}, \"CustomerName\": {}, \"CustomerPhone\": \"0791811781\", \"CustomerCredit\": {}, \"CustomerAddress\": {}, \"CustomerCountry\": {}, \"FraudExplnation\": \"Low Risk (Not checked)\", \"ResultExplanation\": \"Transaction Paid\", \"TransactionAmount\": \"1.00\", \"CustomerCreditType\": \"Mobile\", \"TransactionApproval\": \"SJR1K7JS57\", \"TransactionCurrency\": \"KES\", \"MobilePaymentRequest\": \"Paid\", \"TransactionNetAmount\": \"0.00\", \"TransactionFinalAmount\": \"1.00\", \"TransactionFinalCurrency\": \"KES\", \"TransactionSettlementDate\": \"2024/10/27\", \"TransactionRollingReserveDate\": {}, \"TransactionRollingReserveAmount\": \"0.00\"}','succeeded','2024-10-27 05:25:27','2024-10-27 05:29:30','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('f145f633-f670-4cd9-bf97-cadcd4e0fcf9',9,NULL,25363,'KES',NULL,NULL,NULL,'succeeded','2025-09-06 14:06:42','2025-09-06 14:06:49','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 25363, \"msisdn\": \"254727497778\", \"reference\": \"afripesa\", \"merchant_id\": \"5141482\"}','{\"amount\": \"25363\", \"msisdn\": \"254727497778\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"afripesa\", \"created_at\": \"2025-09-06 11:06:42\", \"finalised_at\": \"2025-09-06T11:06:47.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TI62NQSRBM\", \"silkpesa_reference\": \"SIL-1757156802-112\", \"receiver_description\": \"254727497778 - FRANCIS AMBIA MWAMBI\"}',NULL,'TI62NQSRBM','254727497778 - FRANCIS AMBIA MWAMBI',NULL),('f18a9323-f0af-40cc-b98c-7f4d46667d66',22,'AE3A6AA5-5896-4CD4-89EC-A1F3EB95565A',5,'USD','{\"Result\": \"000\", \"TransRef\": \"R66258441\", \"TransToken\": \"AE3A6AA5-5896-4CD4-89EC-A1F3EB95565A\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'new','2025-03-18 17:59:35','2025-03-18 17:59:35','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('f1b808e2-df6b-44f4-a842-a59c5105d469',1,NULL,10,'KES',NULL,NULL,NULL,'succeeded','2025-02-16 12:38:08','2025-02-16 12:38:16','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 10, \"msisdn\": \"254791811781\", \"reference\": \"test\", \"merchant_id\": \"5141482\"}','{\"amount\": \"10\", \"msisdn\": \"254791811781\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"test\", \"created_at\": \"2025-02-16 15:38:08\", \"finalised_at\": \"2025-02-16T15:38:13.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TBG4B42IYU\", \"silkpesa_reference\": \"SIL-1739720288-291\"}',NULL,NULL,NULL,NULL),('f1da992f-2653-437f-a0ed-4792882e29f3',9,'A781B371-D591-4895-8AAA-16BE12469761',50,'USD','{\"Result\": \"000\", \"TransRef\": \"R63595745\", \"TransToken\": \"A781B371-D591-4895-8AAA-16BE12469761\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'new','2024-12-20 06:15:14','2024-12-20 06:15:14','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('f1fef2a4-13cf-4f52-9d59-6ff4f301a2a5',94,NULL,50000,'KES',NULL,NULL,NULL,'failed','2025-08-28 17:02:37','2025-08-28 17:02:43','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 50000, \"msisdn\": \"254758300740\", \"reference\": \"visa\", \"merchant_id\": \"5141482\"}','{\"amount\": \"50000\", \"msisdn\": \"254758300740\", \"status\": \"FAILED\", \"channel\": \"KE.MPESA\", \"reference\": \"visa\", \"created_at\": \"2025-08-28 14:02:37\", \"finalised_at\": \"2025-08-28T14:02:41.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": null, \"silkpesa_reference\": \"SIL-1756389757-428\", \"receiver_description\": null}',NULL,NULL,NULL,NULL),('f211777b-35ff-4126-b711-d4fa7bf11f1e',9,NULL,790,'KES',NULL,NULL,NULL,'succeeded','2025-02-07 17:32:30','2025-02-07 17:32:31','MPESA','b2b','buy_goods','','{\"Amount\": \"790\", \"PartyA\": \"5141482\", \"PartyB\": \"356891\", \"Remarks\": \"food\", \"CommandID\": \"BusinessBuyGoods\", \"Initiator\": \"gloclienapiuser\", \"Requester\": \"\", \"ResultURL\": \"https://app.safaribucks.com/api/mpesa/business_buy_goods/result\", \"QueueTimeOutURL\": \"https://app.safaribucks.com/api/mpesa/business_buy_goods/result\", \"AccountReference\": \"food\", \"SecurityCredential\": \"LUAsaHZU9fTfQCZwbsCxynfo7Ee0GJ6unxS/Zvx1qLLyUHdRAuEKZJuVGcDDY4LF76vs3Ka07JdW2C4e0QEU3mJE1jlR9lRbbEkFyf5x1w03h9N8kC4AX2fYn/knBF8znFa4mHEI2uEMRklCvfLicMAhIehPICbF//Gp9uO/ujK7XZ8YlrpNEbbmI1zxr9Gw/mFkjpyFwQZNgvh6mzigYDG2WiFmqEAldzvE65nehdYh9JJqobpVcORb14vcxuREyoMqPNSZ+neKjkCjYgL3pSK9seF+J8Hfs9d1g4vDVqBDxSjdltf7iTWjwBHTOkUFaJ9KFUXMWVmO8bkaeDnk2Q==\", \"SenderIdentifierType\": \"4\", \"RecieverIdentifierType\": \"2\", \"OriginatorConversationID\": \"f211777b-35ff-4126-b711-d4fa7bf11f1e\"}','{\"Result\": {\"ResultCode\": 0, \"ResultDesc\": \"The service request is processed successfully.\", \"ResultType\": 0, \"ReferenceData\": {\"ReferenceItem\": [{\"Key\": \"QueueTimeoutURL\", \"Value\": \"https://internalapi.safaricom.net/mpesa/b2bresults/v1/submit\"}, {\"Key\": \"Occassion\"}]}, \"TransactionID\": \"TB736UV3KD\", \"ConversationID\": \"AG_20250207_20603e69c2131b1b91b9\", \"ResultParameters\": {\"ResultParameter\": [{\"Key\": \"Currency\", \"Value\": \"KES\"}, {\"Key\": \"DebitAccountCurrentBalance\", \"Value\": \"{Amount={CurrencyCode=KES, MinimumAmount=1650400, BasicAmount=16504.00}}\"}, {\"Key\": \"InitiatorAccountCurrentBalance\", \"Value\": \"{Amount={CurrencyCode=KES, MinimumAmount=1650400, BasicAmount=16504.00}}\"}]}, \"OriginatorConversationID\": \"9021-4f51-8691-8604c07e13de20694443\"}}',NULL,NULL,NULL,NULL),('f221f25b-8afc-43b8-8b35-e320333c7b09',94,NULL,10000,'KES',NULL,NULL,NULL,'succeeded','2025-08-28 18:07:03','2025-08-28 18:07:08','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 10000, \"msisdn\": \"254758300740\", \"reference\": \"Client Medical\", \"merchant_id\": \"5141482\"}','{\"amount\": \"10000\", \"msisdn\": \"254758300740\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"Client Medical\", \"created_at\": \"2025-08-28 15:07:03\", \"finalised_at\": \"2025-08-28T15:07:05.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"THS3CQJ25T\", \"silkpesa_reference\": \"SIL-1756393623-999\", \"receiver_description\": \"0758300740 - salha anyango ratib\"}',NULL,'THS3CQJ25T','0758300740 - salha anyango ratib',NULL),('f230c635-970e-4658-ae87-ceb7cfc297f6',22,NULL,100,'KES',NULL,NULL,NULL,'succeeded','2025-05-03 19:08:39','2025-05-03 19:08:44','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 100, \"msisdn\": \"254717485628\", \"reference\": \"taxi\", \"merchant_id\": \"5141482\"}','{\"amount\": \"100\", \"msisdn\": \"254717485628\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"taxi\", \"created_at\": \"2025-05-03 16:08:39\", \"finalised_at\": \"2025-05-03T16:08:41.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TE39A6Y09P\", \"silkpesa_reference\": \"SIL-1746288519-736\", \"receiver_description\": \"0717485628 - collins    ouma\"}',NULL,'TE39A6Y09P','0717485628 - collins    ouma',NULL),('f23b03cb-f703-4dcf-a33c-6a06a28e06ba',1,NULL,10,'KES',NULL,NULL,NULL,'succeeded','2024-12-18 06:45:46','2024-12-18 06:45:49','MPESA','b2c',NULL,'','{\"Amount\": \"10\", \"PartyA\": \"5141482\", \"PartyB\": \"254768442517\", \"Remarks\": \"test\", \"CommandID\": \"BusinessPayment\", \"Occassion\": \"test\", \"ResultURL\": \"https://app.safaribucks.com/api/mpesa/business_to_customer/result\", \"InitiatorName\": \"gloclienapiuser\", \"QueueTimeOutURL\": \"https://app.safaribucks.com/api/mpesa/business_to_customer/result\", \"SecurityCredential\": \"W64D84DdAZM9TXtzFEm1uBV3RTY4GvByoo8NZSQ876XvTQOm6igWAUUkSY9pPuUrmwVzcsUbY5o/XWRpAjH0aWXFu5NijxoYhMHZ27+KIibS9Cw5WEr4KOJKDwG6bDVdPwPjBwyNRZortiRABPhUVGVHyEluVqDXnRBwdJANYipzCF5MVQy4qVP6NOA6n4WDWTaLwh3Up43OiW9pbPU/GQ6i7DKIBoa7YxXA+gu68f7jzxVYxAw1IPS3ySundzjrvtIPNiAIulxpVtUp9y2AfRTk7BLQk+zDwDrBdCoebttPCLzleW9kwWkJVPK4Y9A56r/C19WXD4YynpUXO9nT1g==\", \"OriginatorConversationID\": \"f23b03cb-f703-4dcf-a33c-6a06a28e06ba\"}','{\"Result\": {\"ResultCode\": 0, \"ResultDesc\": \"The service request is processed successfully.\", \"ResultType\": 0, \"ReferenceData\": {\"ReferenceItem\": {\"Key\": \"QueueTimeoutURL\", \"Value\": \"http://internalapi.safaricom.co.ke/mpesa/b2cresults/v1/submit\"}}, \"TransactionID\": \"SLI8WHUS2Y\", \"ConversationID\": \"AG_20241218_203046da96febb750741\", \"ResultParameters\": {\"ResultParameter\": [{\"Key\": \"TransactionAmount\", \"Value\": 10}, {\"Key\": \"TransactionReceipt\", \"Value\": \"SLI8WHUS2Y\"}, {\"Key\": \"ReceiverPartyPublicName\", \"Value\": \"0768442517 - faridah zinia achieng\"}, {\"Key\": \"TransactionCompletedDateTime\", \"Value\": \"18.12.2024 12:45:47\"}, {\"Key\": \"B2CUtilityAccountAvailableFunds\", \"Value\": 444}, {\"Key\": \"B2CWorkingAccountAvailableFunds\", \"Value\": 651}, {\"Key\": \"B2CRecipientIsRegisteredCustomer\", \"Value\": \"Y\"}, {\"Key\": \"B2CChargesPaidAccountAvailableFunds\", \"Value\": 0}]}, \"OriginatorConversationID\": \"f23b03cb-f703-4dcf-a33c-6a06a28e06ba\"}}',NULL,NULL,NULL,NULL),('f2917c42-2c68-4603-a681-4b00ec9bd014',87,'70317988-929D-4C80-A5B3-8DBDFD724AD7',1,'USD','{\"Result\":\"000\",\"ResultExplanation\":\"Transaction created\",\"TransToken\":\"70317988-929D-4C80-A5B3-8DBDFD724AD7\",\"TransRef\":\"R69130729\"}',NULL,NULL,'accepted','2025-06-18 14:46:50','2025-06-18 14:46:50','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('f298d8e2-91ac-426b-be12-cf3adc4c2f2f',7,NULL,10,'KES',NULL,NULL,NULL,'succeeded','2024-09-12 07:15:57','2024-09-12 07:15:58','MPESA','b2b','buy_goods','','{\"Amount\": \"10\", \"PartyA\": \"5141482\", \"PartyB\": \"9084617\", \"Remarks\": \"breead\", \"CommandID\": \"BusinessBuyGoods\", \"Initiator\": \"gloclienapiuser\", \"Requester\": \"\", \"ResultURL\": \"https://app.safaribucks.com/api/mpesa/business_buy_goods/result\", \"QueueTimeOutURL\": \"https://app.safaribucks.com/api/mpesa/business_buy_goods/result\", \"AccountReference\": \"breead\", \"SecurityCredential\": \"LH5UzYSuSAmI0v2KaUWlHxW+2q1fOl18R2rDr6WCZE2gFKyGak7gdxan7r7zMLwmfLDPksFoW2bbiCwgh6REURytcMJIym0UTCwoG9DnbFVpFdkVsFj72W4/1r2lAURKuMP7vmoFTu4VUTD8gs1zCIq8DsNgQpGeMAVxOhzXmI+cdODVRjBz/Yr+DRkl6f5CU7FmcpSi1pqRIzGYIoikAOGFeBxUMuxtqQfkbWbU7XxtfTJ91BBaKh4AjZnBGpda82+NKptdebW6bT6snfCaYyCxHnD68ht/klFzTVrhDMv8W1yd6lQ5VVFjBJxxIUSUMD2Vm4gdAjHiifYySy1WWA==\", \"SenderIdentifierType\": \"4\", \"RecieverIdentifierType\": \"2\", \"OriginatorConversationID\": \"f298d8e2-91ac-426b-be12-cf3adc4c2f2f\"}','{\"Result\": {\"ResultCode\": 0, \"ResultDesc\": \"The service request is processed successfully.\", \"ResultType\": 0, \"ReferenceData\": {\"ReferenceItem\": [{\"Key\": \"QueueTimeoutURL\", \"Value\": \"https://internalapi.safaricom.net/mpesa/b2bresults/v1/submit\"}, {\"Key\": \"Occassion\"}]}, \"TransactionID\": \"SIC9BTWBS3\", \"ConversationID\": \"AG_20240912_2010262d6278d9a0bd67\", \"ResultParameters\": {\"ResultParameter\": [{\"Key\": \"Currency\", \"Value\": \"KES\"}, {\"Key\": \"DebitAccountCurrentBalance\", \"Value\": \"{Amount={CurrencyCode=KES, MinimumAmount=21400, BasicAmount=214.00}}\"}, {\"Key\": \"InitiatorAccountCurrentBalance\", \"Value\": \"{Amount={CurrencyCode=KES, MinimumAmount=21400, BasicAmount=214.00}}\"}]}, \"OriginatorConversationID\": \"4fe9-4cd8-ab70-95b3e86ac48911077548\"}}',NULL,NULL,NULL,NULL),('f29f17da-3355-446b-8c67-a793ae653a2d',9,NULL,32972,'KES',NULL,NULL,NULL,'succeeded','2025-09-02 12:27:25','2025-09-02 12:27:31','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 32972, \"msisdn\": \"254708793830\", \"reference\": \"afripesa\", \"merchant_id\": \"5141482\"}','{\"amount\": \"32972\", \"msisdn\": \"254708793830\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"afripesa\", \"created_at\": \"2025-09-02 09:27:25\", \"finalised_at\": \"2025-09-02T09:27:28.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TI241YO550\", \"silkpesa_reference\": \"SIL-1756805245-221\", \"receiver_description\": \"0708793830 - VANE MORAA NYAGAKA\"}',NULL,'TI241YO550','0708793830 - VANE MORAA NYAGAKA',NULL),('f2ba19ec-00fb-4a66-8c10-567fe7152f5a',1,'485E85E9-F6FA-4684-A5C6-F1B1EA802D5D',10,'KES','{\"Result\":\"000\",\"ResultExplanation\":\"Transaction created\",\"TransToken\":\"485E85E9-F6FA-4684-A5C6-F1B1EA802D5D\",\"TransRef\":\"R68347298\"}',NULL,NULL,'accepted','2025-05-24 19:46:27','2025-05-24 19:46:27','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('f2bf6243-3000-4d41-b25d-c799f628a98e',9,NULL,10,'KES',NULL,NULL,NULL,'succeeded','2025-08-22 10:34:23','2025-08-22 10:34:30','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 10, \"msisdn\": \"254796401710\", \"reference\": \"test\", \"merchant_id\": \"5141482\"}','{\"amount\": \"10\", \"msisdn\": \"254796401710\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"test\", \"created_at\": \"2025-08-22 07:34:23\", \"finalised_at\": \"2025-08-22T07:34:28.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"THM9EYZMTP\", \"silkpesa_reference\": \"SIL-1755848063-511\", \"receiver_description\": \"254796401710 - abuje onyango\"}',NULL,'THM9EYZMTP','254796401710 - abuje onyango',NULL),('f2c5ca53-0cfd-4025-b25b-beb1f3919172',9,NULL,250,'KES',NULL,NULL,NULL,'failed','2025-06-18 19:14:58','2025-06-18 19:15:03','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 250, \"msisdn\": \"254721812719\", \"reference\": \"testing\", \"merchant_id\": \"5141482\"}','{\"amount\": \"250\", \"msisdn\": \"254721812719\", \"status\": \"FAILED\", \"channel\": \"KE.MPESA\", \"reference\": \"testing\", \"created_at\": \"2025-06-18 16:14:58\", \"finalised_at\": \"2025-06-18T16:15:01.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": null, \"silkpesa_reference\": \"SIL-1750263298-335\", \"receiver_description\": null}',NULL,NULL,NULL,NULL),('f2e5195a-ed27-4a37-bec6-cbda561cbfe7',9,NULL,1500,'KES',NULL,NULL,NULL,'succeeded','2025-04-22 17:57:43','2025-04-22 17:57:48','MPESA','b2b','buy_goods','','{\"type\": \"business_buy_goods\", \"amount\": 1500, \"msisdn\": \"827804\", \"reference\": \"fuel\", \"merchant_id\": \"5141482\"}','{\"amount\": \"1500\", \"msisdn\": \"827804\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"fuel\", \"created_at\": \"2025-04-22 17:57:43\", \"finalised_at\": \"2025-04-22T17:57:46.000000Z\", \"transaction_type\": \"business_buy_goods\", \"vendor_reference\": \"TDM3T3BCPX\", \"silkpesa_reference\": \"SIL-1745344663-859\", \"receiver_description\": null}',NULL,'TDM3T3BCPX',NULL,NULL),('f2f451b7-3ac7-4e8e-8889-2947dc973237',9,NULL,1000,'KES',NULL,NULL,NULL,'succeeded','2025-02-11 17:34:39','2025-02-11 17:34:40','MPESA','b2b','buy_goods','','{\"Amount\": \"1000\", \"PartyA\": \"5141482\", \"PartyB\": \"900699\", \"Remarks\": \"petrol\", \"CommandID\": \"BusinessBuyGoods\", \"Initiator\": \"gloclienapiuser\", \"Requester\": \"\", \"ResultURL\": \"https://app.safaribucks.com/api/mpesa/business_buy_goods/result\", \"QueueTimeOutURL\": \"https://app.safaribucks.com/api/mpesa/business_buy_goods/result\", \"AccountReference\": \"petrol\", \"SecurityCredential\": \"T7pZ/BtEWpJkLfYKXI5fGnRUOQ8c1VOITlNDzjk5MvxRGzbYmZXJYPj+ddPUcWzt+8jHwpjY74QlYMemRIq9RhJ2wUA2xoE00BhvudflVq60VgupRq02luiZCEWk0T/lggNjUrF1tyhp+7fYkHszYi03Bq4iuFSJ/DNOWufLh8PB0ZLOSima2izgonrwZC4wyt8Q5xF5RaELCJywl2IBP6pdR/y8k4vrdRAZyTAic+qO0xwNTR0vhi7w6UCA006K8F2fUXi8ai7KeBo9N1XURiK99/VhEsp81xzSfkVVwA4P3VbCmPGWY21GEL6x/57QxsffpeHXnzP1qUjXxpx+LA==\", \"SenderIdentifierType\": \"4\", \"RecieverIdentifierType\": \"2\", \"OriginatorConversationID\": \"f2f451b7-3ac7-4e8e-8889-2947dc973237\"}','{\"Result\": {\"ResultCode\": 0, \"ResultDesc\": \"The service request is processed successfully.\", \"ResultType\": 0, \"ReferenceData\": {\"ReferenceItem\": [{\"Key\": \"QueueTimeoutURL\", \"Value\": \"https://internalapi.safaricom.net/mpesa/b2bresults/v1/submit\"}, {\"Key\": \"Occassion\"}]}, \"TransactionID\": \"TBB7OSBBJJ\", \"ConversationID\": \"AG_20250211_20506c4276d9a674b3d4\", \"ResultParameters\": {\"ResultParameter\": [{\"Key\": \"Currency\", \"Value\": \"KES\"}, {\"Key\": \"DebitAccountCurrentBalance\", \"Value\": \"{Amount={CurrencyCode=KES, MinimumAmount=1637300, BasicAmount=16373.00}}\"}, {\"Key\": \"InitiatorAccountCurrentBalance\", \"Value\": \"{Amount={CurrencyCode=KES, MinimumAmount=1637300, BasicAmount=16373.00}}\"}]}, \"OriginatorConversationID\": \"21dc-4436-8408-ee2f032ee36b23716942\"}}',NULL,NULL,NULL,NULL),('f301d4ea-affc-4445-b185-37f4031b0f88',24,NULL,10,'KES',NULL,NULL,NULL,'failed','2025-02-26 06:35:25','2025-02-26 06:35:26','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 10, \"msisdn\": \"254720100400\", \"reference\": \"test\", \"merchant_id\": \"5141482\"}',NULL,NULL,NULL,NULL,NULL),('f303b911-61ba-4a6d-940e-60901dd0e381',99,'D543613F-1D8D-4F4D-B909-99876368256D',5000,'KES','{\"Result\":\"000\",\"ResultExplanation\":\"Transaction created\",\"TransToken\":\"D543613F-1D8D-4F4D-B909-99876368256D\",\"TransRef\":\"R72805336\"}',NULL,NULL,'accepted','2025-10-03 16:29:57','2025-10-03 16:29:57','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('f31b3a3a-d1a3-44ac-8448-3ca563bfde91',9,NULL,10,'KES',NULL,NULL,NULL,'succeeded','2025-10-02 09:51:47','2025-10-02 09:51:53','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 10, \"msisdn\": \"254740820709\", \"reference\": \"testing\", \"merchant_id\": \"5141482\"}','{\"amount\": \"10\", \"msisdn\": \"254740820709\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"currency\": \"KES\", \"reference\": \"testing\", \"created_at\": \"2025-10-02 06:51:47\", \"finalised_at\": \"2025-10-02T06:51:50.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TJ2AW68LWY\", \"silkpesa_reference\": \"SIL-1759387907-421\", \"receiver_description\": \"254740820709 - MOHAMED ABDIKHER ELMI\"}',NULL,'TJ2AW68LWY','254740820709 - MOHAMED ABDIKHER ELMI',NULL),('f339b0bc-f012-46d4-be8e-13759fb9d83c',9,NULL,1000,'KES',NULL,NULL,NULL,'failed','2025-04-15 19:12:06','2025-04-15 19:12:12','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 1000, \"msisdn\": \"254721812719\", \"reference\": \"testing\", \"merchant_id\": \"5141482\"}','{\"amount\": \"1000\", \"msisdn\": \"254721812719\", \"status\": \"FAILED\", \"channel\": \"KE.MPESA\", \"reference\": \"testing\", \"created_at\": \"2025-04-15 19:12:06\", \"finalised_at\": \"2025-04-15T19:12:09.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": null, \"silkpesa_reference\": \"SIL-1744744326-212\", \"receiver_description\": null}',NULL,NULL,NULL,NULL),('f345db3b-2db2-4b50-a16f-c24bf602b6f5',22,'82CE8D43-4DB4-4E96-B994-8127F778458C',560,'USD','{\"Result\": \"000\", \"TransRef\": \"R65752996\", \"TransToken\": \"82CE8D43-4DB4-4E96-B994-8127F778458C\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'new','2025-03-02 18:34:13','2025-03-02 18:34:13','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('f34a6860-9a68-49bb-9f2f-8b0a199c1b42',9,NULL,1200,'KES',NULL,NULL,NULL,'succeeded','2025-05-16 19:44:51','2025-05-16 19:44:57','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 1200, \"msisdn\": \"254792390409\", \"reference\": \"hair\", \"merchant_id\": \"5141482\"}','{\"amount\": \"1200\", \"msisdn\": \"254792390409\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"hair\", \"created_at\": \"2025-05-16 16:44:51\", \"finalised_at\": \"2025-05-16T16:44:54.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TEG5ZX0RH3\", \"silkpesa_reference\": \"SIL-1747413891-927\", \"receiver_description\": \"0792390409 - nasra osman adan\"}',NULL,'TEG5ZX0RH3','0792390409 - nasra osman adan',NULL),('f3603f29-0b2f-48ad-89cd-2b68fca39bf1',9,NULL,2400,'KES',NULL,NULL,NULL,'succeeded','2025-04-06 15:19:49','2025-04-06 15:19:58','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 2400, \"msisdn\": \"254792390409\", \"reference\": \"medical\", \"merchant_id\": \"5141482\"}','{\"amount\": \"2400\", \"msisdn\": \"254792390409\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"medical\", \"created_at\": \"2025-04-06 15:19:49\", \"finalised_at\": \"2025-04-06T15:19:55.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TD69OC05TJ\", \"silkpesa_reference\": \"SIL-1743952789-783\", \"receiver_description\": \"0792390409 - nasra osman adan\"}',NULL,'TD69OC05TJ','0792390409 - nasra osman adan',NULL),('f36e95ea-5bd6-48e7-8a48-e402a0f37364',9,NULL,150,'KES',NULL,NULL,NULL,'failed','2025-06-30 19:27:54','2025-06-30 19:28:00','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 150, \"msisdn\": \"254721812719\", \"reference\": \"sharif\", \"merchant_id\": \"5141482\"}','{\"amount\": \"150\", \"msisdn\": \"254721812719\", \"status\": \"FAILED\", \"channel\": \"KE.MPESA\", \"reference\": \"sharif\", \"created_at\": \"2025-06-30 16:27:54\", \"finalised_at\": \"2025-06-30T16:27:57.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": null, \"silkpesa_reference\": \"SIL-1751300874-850\", \"receiver_description\": null}',NULL,NULL,NULL,NULL),('f38b59d4-8724-474d-96e7-bb922d1cd26e',9,NULL,10,'KES',NULL,NULL,NULL,'succeeded','2025-05-05 17:51:26','2025-05-05 17:51:33','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 10, \"msisdn\": \"254722222404\", \"reference\": \"testing\", \"merchant_id\": \"5141482\"}','{\"amount\": \"10\", \"msisdn\": \"254722222404\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"testing\", \"created_at\": \"2025-05-05 14:51:26\", \"finalised_at\": \"2025-05-05T14:51:30.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TE54IWGEQ8\", \"silkpesa_reference\": \"SIL-1746456686-366\", \"receiver_description\": \"0722222404 - IBRAHIM AHMED ADAM\"}',NULL,'TE54IWGEQ8','0722222404 - IBRAHIM AHMED ADAM',NULL),('f38eb1c3-ec92-4929-9c4a-1351619d4cd0',9,NULL,10,'KES',NULL,NULL,NULL,'succeeded','2024-11-18 14:31:29','2024-11-18 14:31:30','MPESA','b2c',NULL,'','{\"Amount\": \"10\", \"PartyA\": \"5141482\", \"PartyB\": \"254721812719\", \"Remarks\": \"Test\", \"CommandID\": \"BusinessPayment\", \"Occassion\": \"Test\", \"ResultURL\": \"https://app.safaribucks.com/api/mpesa/business_to_customer/result\", \"InitiatorName\": \"gloclienapiuser\", \"QueueTimeOutURL\": \"https://app.safaribucks.com/api/mpesa/business_to_customer/result\", \"SecurityCredential\": \"bYhHsfRuJbrZCdx1DH8g9FvdhepBz1w9dILV65z4ZuxsUTPjxtgORdqFjK/uswOKeKJatMjD9ynJv8dURu509/E0zJ04HBGqiUcwt3GQIxd/q4aNoI+qsMj4ksr4P7ijx4oQiXrOZFi2JxnNh4ib+N5K1UFukTthM+RQTEFJA4L8N2MDtOaN71i5eRLzWot2A9IjuSPeGLNk1bS15jcD1H2l+XyqOiyJsaIJepTkjm9FKlSOVEAKEDc4mY7djG/XCfUQOUbhfA7U2f0foOB8fYOBre6+LVOhpLfqMRDLLbQ8JCZeyAkgC4OawSDSZij3gVmdlo3fVP1xkEjjTM5ttA==\", \"OriginatorConversationID\": \"f38eb1c3-ec92-4929-9c4a-1351619d4cd0\"}','{\"Result\": {\"ResultCode\": 0, \"ResultDesc\": \"The service request is processed successfully.\", \"ResultType\": 0, \"ReferenceData\": {\"ReferenceItem\": {\"Key\": \"QueueTimeoutURL\", \"Value\": \"http://internalapi.safaricom.co.ke/mpesa/b2cresults/v1/submit\"}}, \"TransactionID\": \"SKI6AOWP6E\", \"ConversationID\": \"AG_20241118_20101fcf2f2ea9022ded\", \"ResultParameters\": {\"ResultParameter\": [{\"Key\": \"TransactionAmount\", \"Value\": 10}, {\"Key\": \"TransactionReceipt\", \"Value\": \"SKI6AOWP6E\"}, {\"Key\": \"ReceiverPartyPublicName\", \"Value\": \"254721812719 - MOHAMED ADAN\"}, {\"Key\": \"TransactionCompletedDateTime\", \"Value\": \"18.11.2024 20:31:29\"}, {\"Key\": \"B2CUtilityAccountAvailableFunds\", \"Value\": 1867}, {\"Key\": \"B2CWorkingAccountAvailableFunds\", \"Value\": 454}, {\"Key\": \"B2CRecipientIsRegisteredCustomer\", \"Value\": \"Y\"}, {\"Key\": \"B2CChargesPaidAccountAvailableFunds\", \"Value\": 0}]}, \"OriginatorConversationID\": \"f38eb1c3-ec92-4929-9c4a-1351619d4cd0\"}}',NULL,NULL,NULL,NULL),('f39d43c8-18bc-468e-8527-d489105df0f3',9,NULL,500,'KES',NULL,NULL,NULL,'succeeded','2025-10-11 17:40:50','2025-10-11 17:40:56','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 500, \"msisdn\": \"254792390409\", \"reference\": \"food\", \"merchant_id\": \"5141482\"}','{\"amount\": \"500\", \"msisdn\": \"254792390409\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"currency\": \"KES\", \"reference\": \"food\", \"created_at\": \"2025-10-11 14:40:50\", \"finalised_at\": \"2025-10-11T14:40:54.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TJBPJ72DOV\", \"silkpesa_reference\": \"SIL-1760193650-297\", \"receiver_description\": \"0792390409 - nasra osman adan\"}',NULL,'TJBPJ72DOV','0792390409 - nasra osman adan',NULL),('f3af6ebf-1ad0-485d-a14f-dbda7b4de977',6,NULL,10,'KES',NULL,NULL,NULL,'succeeded','2024-09-11 17:50:55','2024-09-11 17:50:56','MPESA','b2c',NULL,'','{\"Amount\": \"10\", \"PartyA\": \"5141482\", \"PartyB\": \"254719388300\", \"Remarks\": \"test\", \"CommandID\": \"BusinessPayment\", \"Occassion\": \"test\", \"ResultURL\": \"https://app.safaribucks.com/api/mpesa/business_to_customer/result\", \"InitiatorName\": \"gloclienapiuser\", \"QueueTimeOutURL\": \"https://app.safaribucks.com/api/mpesa/business_to_customer/result\", \"SecurityCredential\": \"DraBOTUkUJyjRSpkcGUs7ZVnFzIAM6Y4XJQPw7RgoxFHwSUDTSZNgIXtJoebgV+WHqkH2d7pmNOYK7U7NOf7IR7lnE7DCdyUhWy7QBsg8K7BYtsckdAx6+zDqbLmv2hKyREvJ+bnxk7BV2PSEFA8VPAhns0Z4pPVrh5vCgWEzSkj04c0/xpQ72ezxj7XIJL22mzWJntTZd4c3tSBQPeav4C0WSvocq8tCAQ8Inl1G32gSFLwfsh1IwUoxtYi0rVeX8odCeg9qDgogwQYjC14VLaZb6p/9PBw6s+SI1ayPSTzrepgN6Xl72ZrtyRjeaL1TIjXE22uYSqF0SYFP7ID8Q==\", \"OriginatorConversationID\": \"f3af6ebf-1ad0-485d-a14f-dbda7b4de977\"}','{\"Result\": {\"ResultCode\": 0, \"ResultDesc\": \"The service request is processed successfully.\", \"ResultType\": 0, \"ReferenceData\": {\"ReferenceItem\": {\"Key\": \"QueueTimeoutURL\", \"Value\": \"http://internalapi.safaricom.co.ke/mpesa/b2cresults/v1/submit\"}}, \"TransactionID\": \"SIB7ACVWS9\", \"ConversationID\": \"AG_20240911_20305b130c01512c12a0\", \"ResultParameters\": {\"ResultParameter\": [{\"Key\": \"TransactionAmount\", \"Value\": 10}, {\"Key\": \"TransactionReceipt\", \"Value\": \"SIB7ACVWS9\"}, {\"Key\": \"ReceiverPartyPublicName\", \"Value\": \"0719388300 - Eunice Wanjiru Mwangi\"}, {\"Key\": \"TransactionCompletedDateTime\", \"Value\": \"11.09.2024 23:50:56\"}, {\"Key\": \"B2CUtilityAccountAvailableFunds\", \"Value\": 115}, {\"Key\": \"B2CWorkingAccountAvailableFunds\", \"Value\": 278}, {\"Key\": \"B2CRecipientIsRegisteredCustomer\", \"Value\": \"Y\"}, {\"Key\": \"B2CChargesPaidAccountAvailableFunds\", \"Value\": 0}]}, \"OriginatorConversationID\": \"f3af6ebf-1ad0-485d-a14f-dbda7b4de977\"}}',NULL,NULL,NULL,NULL),('f3cc7608-617a-4ff6-b34a-cbf5498ec16a',6,NULL,50,'KES',NULL,NULL,NULL,'failed','2024-09-26 05:04:39','2024-09-26 05:04:40','MPESA','b2c',NULL,'','{\"Amount\": \"50\", \"PartyA\": \"5141482\", \"PartyB\": \"254714725468\", \"Remarks\": \"test\", \"CommandID\": \"BusinessPayment\", \"Occassion\": \"test\", \"ResultURL\": \"https://app.safaribucks.com/api/mpesa/business_to_customer/result\", \"InitiatorName\": \"gloclienapiuser\", \"QueueTimeOutURL\": \"https://app.safaribucks.com/api/mpesa/business_to_customer/result\", \"SecurityCredential\": \"g3zNoZL4uVCZiG2I4MAmBnIChevb72G7+gzjb3Q1O+qBan6j00BzKD3eQCXCegkcMqSuJyq1UwLiVEL+XcoFic8pW4u4eMRKLqVjWXpVirjFEpjtxNwjL+CyNxpzJ4QEi7F0j/nezzVOM2CojKAsmgYPEmZO0W+zFC44x8QZ3RE8ug3Lp3dWG+/7PWBkvztIvbXW+Y3QkkbxdL2mIwzwl454IVW5mk0DQLyAzCJmsuqwNxOyG8yEllVHY/t+dOXZPLG+bLHY8fxRvDMLJb/4b/jhupLgw3joEu/3dSCOq8xDfAZgd91tpbwZZRKLXx8PAFXWLK2LrtUVvnX6rHNlFw==\", \"OriginatorConversationID\": \"f3cc7608-617a-4ff6-b34a-cbf5498ec16a\"}','{\"Result\": {\"ResultCode\": 1, \"ResultDesc\": \"The balance is insufficient for the transaction.\", \"ResultType\": 0, \"ReferenceData\": {\"ReferenceItem\": {\"Key\": \"QueueTimeoutURL\", \"Value\": \"http://internalapi.safaricom.co.ke/mpesa/b2cresults/v1/submit\"}}, \"TransactionID\": \"SIQ2W3SXME\", \"ConversationID\": \"AG_20240926_2070744cdde86c78127c\", \"OriginatorConversationID\": \"f3cc7608-617a-4ff6-b34a-cbf5498ec16a\"}}',NULL,NULL,NULL,NULL),('f3dea0c2-ff93-4c8d-9c8b-028f11cee031',9,NULL,38550,'KES',NULL,NULL,NULL,'succeeded','2025-02-28 11:51:41','2025-02-28 11:51:47','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 38550, \"msisdn\": \"254725254669\", \"reference\": \"carrel\", \"merchant_id\": \"5141482\"}','{\"amount\": \"38550\", \"msisdn\": \"254725254669\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"carrel\", \"created_at\": \"2025-02-28 14:51:42\", \"finalised_at\": \"2025-02-28T14:51:44.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TBS3TI4K4X\", \"silkpesa_reference\": \"SIL-1740754302-988\", \"receiver_description\": \"254725254669 - MARY NDUNGU\"}',NULL,'TBS3TI4K4X','254725254669 - MARY NDUNGU',NULL),('f3fbc6f7-b2a5-4753-868a-8188821f8727',22,NULL,35,'KES',NULL,NULL,NULL,'succeeded','2025-08-15 02:37:28','2025-08-17 13:42:18','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 35, \"msisdn\": \"254722757783\", \"reference\": \"friend\", \"merchant_id\": \"5141482\"}','{\"amount\": \"35\", \"msisdn\": \"254722757783\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"friend\", \"created_at\": \"2025-08-14 23:37:28\", \"finalised_at\": \"2025-08-17T10:42:15.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"THH6QCSA82\", \"silkpesa_reference\": \"SIL-1755214648-766\", \"receiver_description\": \"254722757783 - SALAH OSMAN ADAN\"}',NULL,'THH6QCSA82','254722757783 - SALAH OSMAN ADAN',NULL),('f45bf0d1-890e-4cea-9c45-e96ad999773b',71,NULL,16000,'KES',NULL,NULL,NULL,'failed','2025-04-28 07:30:28','2025-04-28 07:30:35','MPESA','b2b','buy_goods','','{\"type\": \"business_buy_goods\", \"amount\": 16000, \"msisdn\": \"544510\", \"reference\": \"lodge\", \"merchant_id\": \"5141482\"}','{\"amount\": \"16000\", \"msisdn\": \"544510\", \"status\": \"FAILED\", \"channel\": \"KE.MPESA\", \"reference\": \"lodge\", \"created_at\": \"2025-04-28 07:30:28\", \"finalised_at\": \"2025-04-28T07:30:32.000000Z\", \"transaction_type\": \"business_buy_goods\", \"vendor_reference\": null, \"silkpesa_reference\": \"SIL-1745825428-309\", \"receiver_description\": null}',NULL,NULL,NULL,NULL),('f45fc647-b556-4b93-beb6-60269b837c25',24,NULL,10,'KES',NULL,NULL,NULL,'succeeded','2025-10-22 17:08:11','2025-10-22 17:08:17','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 10, \"msisdn\": \"254746640402\", \"reference\": \"test\", \"merchant_id\": \"5141482\"}','{\"amount\": \"10\", \"msisdn\": \"254746640402\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"currency\": \"KES\", \"reference\": \"test\", \"created_at\": \"2025-10-22 14:08:11\", \"finalised_at\": \"2025-10-22T14:08:15.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TJM9W81SDG\", \"silkpesa_reference\": \"SIL-1761142091-575\", \"receiver_description\": \"0746640402 - Lucie Anne Cherono\"}',NULL,'TJM9W81SDG','0746640402 - Lucie Anne Cherono',NULL),('f474bc94-ced1-4fc4-9541-3d4f7ebe812d',9,NULL,150,'KES',NULL,NULL,NULL,'succeeded','2025-05-16 20:07:31','2025-05-16 20:07:38','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 150, \"msisdn\": \"254111944754\", \"reference\": \"fare\", \"merchant_id\": \"5141482\"}','{\"amount\": \"150\", \"msisdn\": \"254111944754\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"fare\", \"created_at\": \"2025-05-16 17:07:31\", \"finalised_at\": \"2025-05-16T17:07:35.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TEG012L8GC\", \"silkpesa_reference\": \"SIL-1747415251-860\", \"receiver_description\": \"0111944754 - ABDIWALI   ADAN\"}',NULL,'TEG012L8GC','0111944754 - ABDIWALI   ADAN',NULL),('f485eaca-e0b9-4ba5-affa-6692d93217a2',9,NULL,550,'KES',NULL,NULL,NULL,'succeeded','2025-02-11 18:10:20','2025-02-11 18:10:20','MPESA','b2b','paybill','','{\"Amount\": \"550\", \"PartyA\": \"5141482\", \"PartyB\": \"4029369\", \"Remarks\": \"drugs\", \"CommandID\": \"BusinessPayBill\", \"Initiator\": \"gloclienapiuser\", \"Requester\": \"\", \"ResultURL\": \"https://app.safaribucks.com/api/mpesa/business_pay_bill/result\", \"QueueTimeOutURL\": \"https://app.safaribucks.com/api/mpesa/business_pay_bill/result\", \"AccountReference\": \"drugs\", \"SecurityCredential\": \"jM56lCboARIw3ryVC+7sqk9EV34bbyW1ZCpBbIGh/um9qd24ZMi9yQccLD7ydyWGn4bosVL3NtPAWLuJq27OowA3MT4/EK2ldKwoJlwCD5I0c3Jkx/s/zSdenS7SpCqJIq6wKkrydWPHhymT62LDDCfqZsR3HXFAEsqI0UIYQVQRNI/kbC51lgs2o4V5bb8Ie9edB5BvCotdwvc1EXF7DkrNpPTnAwlDR2FEtDfeUOrdH8Uh9fdBn1NkUdXiDPTG2XP1x25DOXnOl69GpXktVefMXIZHNMyGCuAUQ9scRtdIK/y22rzbbWh8OsuVwgfXu52z+O2ddgpdSwaTEbKFIQ==\", \"SenderIdentifierType\": \"4\", \"RecieverIdentifierType\": \"4\", \"OriginatorConversationID\": \"f485eaca-e0b9-4ba5-affa-6692d93217a2\"}','{\"Result\": {\"ResultCode\": 0, \"ResultDesc\": \"The service request is processed successfully.\", \"ResultType\": 0, \"ReferenceData\": {\"ReferenceItem\": [{\"Key\": \"BillReferenceNumber\", \"Value\": \"drugs\"}, {\"Key\": \"QueueTimeoutURL\", \"Value\": \"https://internalapi.safaricom.net/mpesa/b2bresults/v1/submit\"}, {\"Key\": \"Occassion\"}]}, \"TransactionID\": \"TBC6OTP5L2\", \"ConversationID\": \"AG_20250212_20205231b0fd99588526\", \"ResultParameters\": {\"ResultParameter\": [{\"Key\": \"Currency\", \"Value\": \"KES\"}, {\"Key\": \"ReceiverPartyPublicName\", \"Value\": \"4029369 - PHARMAPLUS PHARMACEUTICALS LTD 3.\"}, {\"Key\": \"DebitPartyCharges\", \"Value\": \"Business Pay Bill Charge|KES|13.00\"}, {\"Key\": \"TransCompletedTime\", \"Value\": 20250212001020}, {\"Key\": \"DebitPartyAffectedAccountBalance\", \"Value\": \"Working Account|KES|15104.00|15104.00|0.00|0.00\"}, {\"Key\": \"Amount\", \"Value\": 550}, {\"Key\": \"DebitAccountCurrentBalance\", \"Value\": \"{Amount={CurrencyCode=KES, MinimumAmount=1510400, BasicAmount=15104.00}}\"}, {\"Key\": \"InitiatorAccountCurrentBalance\", \"Value\": \"{Amount={CurrencyCode=KES, MinimumAmount=1510400, BasicAmount=15104.00}}\"}]}, \"OriginatorConversationID\": \"cbc1-4d1f-8bf4-4add4123b23a29004383\"}}',NULL,NULL,NULL,NULL),('f49cf9eb-66bd-47d9-8de5-36a65c257187',3,NULL,10,'KES',NULL,NULL,NULL,'new','2024-09-09 17:45:06','2024-09-09 17:45:06','MPESA','b2c',NULL,'','{\"Amount\": \"10\", \"PartyA\": \"5141482\", \"PartyB\": \"5537531\", \"Remarks\": \"ref\", \"CommandID\": \"BusinessBuyGoods\", \"Initiator\": \"gloclienapiuser\", \"Requester\": \"\", \"ResultURL\": \"https://safaribucks.com/api/mpesa/business_buy_goods/result\", \"QueueTimeOutURL\": \"https://safaribucks.com/api/mpesa/business_buy_goods/result\", \"AccountReference\": \"reference\", \"SecurityCredential\": \"e2qYSo2COUIPOZlhulV2gq9goqc5VhSO4D6ASDS4i9ATeB+AWxDiev2xyZRgfn8A/4Co0plAz0/tPWHYROzXPpdfdecvGs3oCLwngLe0uT27utt1BNJg0Hi9fBd1G0ecnAVXyQrX5EG/sahbchmAUar5x8ERs7/eckOVUgIscxFVeR2zWChfdOThRojZfz4kpCyRhkoWfcfFLd1/QY30oMLmCqQXcd11drl6TJcCGZwBlH66GxRVUEw43vjn+ZuXFtw4WneVxVd1Z4+gmFN9H8a9lQRCjkCGiihPYuTRQjiNTtAOTiyPJvG+Cu8hKoYIpuVfOex5xWerKD72Huokxg==\", \"SenderIdentifierType\": \"4\", \"RecieverIdentifierType\": \"4\", \"OriginatorConversationID\": \"f49cf9eb-66bd-47d9-8de5-36a65c257187\"}',NULL,NULL,NULL,NULL,NULL),('f4a90cea-b9c4-4e05-a75e-883473ece328',9,NULL,10,'KES',NULL,NULL,NULL,'succeeded','2025-07-15 16:11:22','2025-07-15 16:11:30','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 10, \"msisdn\": \"254732787785\", \"reference\": \"test\", \"merchant_id\": \"5141482\"}','{\"amount\": \"10\", \"msisdn\": \"254732787785\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"test\", \"created_at\": \"2025-07-15 13:11:22\", \"finalised_at\": \"2025-07-15T13:11:27.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TGF63UPAO4\", \"silkpesa_reference\": \"SIL-1752585082-185\", \"receiver_description\": \"254732787785 - SMITI JITESH CHAVDA\"}',NULL,'TGF63UPAO4','254732787785 - SMITI JITESH CHAVDA',NULL),('f4b87278-26c7-4ede-83c9-94aaa1f553f8',1,'AB7B7691-CD9C-45BD-85FF-F0D29EA3721F',1,'KES','{\"Result\": \"000\", \"TransRef\": \"R63196473\", \"TransToken\": \"AB7B7691-CD9C-45BD-85FF-F0D29EA3721F\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'new','2024-12-06 08:10:30','2024-12-06 08:10:30','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('f4d112b5-a7d8-442e-916d-ad5820c03573',9,NULL,6355,'KES',NULL,NULL,NULL,'succeeded','2025-07-01 20:26:44','2025-07-01 20:26:49','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 6355, \"msisdn\": \"254726808527\", \"reference\": \"afripesa\", \"merchant_id\": \"5141482\"}','{\"amount\": \"6355\", \"msisdn\": \"254726808527\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"afripesa\", \"created_at\": \"2025-07-01 17:26:44\", \"finalised_at\": \"2025-07-01T17:26:46.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TG187G6KW2\", \"silkpesa_reference\": \"SIL-1751390804-803\", \"receiver_description\": \"254726808527 - RICHARD MENGE\"}',NULL,'TG187G6KW2','254726808527 - RICHARD MENGE',NULL),('f4e62486-857d-45f0-882d-66c48d625dc3',1,'AF92FF35-E168-4C1C-AD0A-147D8476AE60',10,'KES','{\"Result\": \"000\", \"TransRef\": \"R61988062\", \"TransToken\": \"AF92FF35-E168-4C1C-AD0A-147D8476AE60\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'new','2024-10-29 06:40:19','2024-10-29 06:40:19','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('f4edc7ab-3fdd-4ee5-9142-e41f21f0c431',22,'C4F012F6-E45C-4258-B7AB-6F20BC844AA6',5,'USD','{\"Result\": \"000\", \"TransRef\": \"R67794882\", \"TransToken\": \"C4F012F6-E45C-4258-B7AB-6F20BC844AA6\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'accepted','2025-05-06 18:33:52','2025-05-06 18:33:52','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('f52bbdf8-f90b-4e01-85f0-185a4c4c5220',19,NULL,70,'KES',NULL,NULL,NULL,'failed','2024-11-25 11:29:42','2024-11-25 11:29:45','MPESA','b2b','paybill','','{\"Amount\": \"70\", \"PartyA\": \"5141482\", \"PartyB\": \"303030\", \"Remarks\": \"depo\", \"CommandID\": \"BusinessPayBill\", \"Initiator\": \"gloclienapiuser\", \"Requester\": \"\", \"ResultURL\": \"https://app.safaribucks.com/api/mpesa/business_pay_bill/result\", \"QueueTimeOutURL\": \"https://app.safaribucks.com/api/mpesa/business_pay_bill/result\", \"AccountReference\": \"depo\", \"SecurityCredential\": \"cI/NYdoYbT542brIoYGeL2FxfdgDug5OwT/DPgUSjWysStiKsK6GJt78fg+AQTsya4sWelBpqiwlRhS/MP0zRwD/qurM+806V8x3JVm4VBHN1HwD3/EJ/lgfneDI9SISV45qLbaRf04IjEvti0RgBQY9dmvQuNBSxYeT0qe81PacdgLy+G0/Z96Ds9MMdIUsIXh4l+YOe8mdM2NsQrX6hTaK/zqzJPRA9TW1F1KqOGFzoQoZ8CgA1ySXjrDniZADFCXglOwrcenuxLpezzmZ57SXCTVjZranLRcwXYFOLTrqkttUOa1BkPy3a0FNCsGNV0r12E/GsGUgMDIRnqqf7w==\", \"SenderIdentifierType\": \"4\", \"RecieverIdentifierType\": \"4\", \"OriginatorConversationID\": \"f52bbdf8-f90b-4e01-85f0-185a4c4c5220\"}','{\"Result\": {\"ResultCode\": 17, \"ResultDesc\": \"System internal error.\", \"ResultType\": 0, \"ReferenceData\": {\"ReferenceItem\": [{\"Key\": \"BillReferenceNumber\", \"Value\": \"depo\"}, {\"Key\": \"QueueTimeoutURL\", \"Value\": \"https://internalapi.safaricom.net/mpesa/b2bresults/v1/submit\"}, {\"Key\": \"Occassion\"}]}, \"TransactionID\": \"SKP13L0AZR\", \"ConversationID\": \"AG_20241125_205046e78a30acbcab9e\", \"OriginatorConversationID\": \"76cd-4d18-92cb-6c84c87af5931203056\"}}',NULL,NULL,NULL,NULL),('f5493818-0e91-43e2-a2ca-488728b859db',9,NULL,2542,'KES',NULL,NULL,NULL,'succeeded','2025-08-10 18:58:27','2025-08-10 18:58:33','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 2542, \"msisdn\": \"254757588947\", \"reference\": \"afripesa\", \"merchant_id\": \"5141482\"}','{\"amount\": \"2542\", \"msisdn\": \"254757588947\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"afripesa\", \"created_at\": \"2025-08-10 15:58:27\", \"finalised_at\": \"2025-08-10T15:58:31.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"THA8S33B4E\", \"silkpesa_reference\": \"SIL-1754841507-135\", \"receiver_description\": \"0757588947 - BONFACE MUSASTA MADANGI\"}',NULL,'THA8S33B4E','0757588947 - BONFACE MUSASTA MADANGI',NULL),('f574c618-65f9-4b98-8962-6b54e5d857af',71,NULL,80,'KES',NULL,NULL,NULL,'succeeded','2025-05-13 21:41:05','2025-05-13 21:41:12','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 80, \"msisdn\": \"254708485918\", \"reference\": \"gum\", \"merchant_id\": \"5141482\"}','{\"amount\": \"80\", \"msisdn\": \"254708485918\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"gum\", \"created_at\": \"2025-05-13 18:41:05\", \"finalised_at\": \"2025-05-13T18:41:10.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TED1MN1LD1\", \"silkpesa_reference\": \"SIL-1747161665-595\", \"receiver_description\": \"254708485918 - DORCAS WANJIKU MAINA\"}',NULL,'TED1MN1LD1','254708485918 - DORCAS WANJIKU MAINA',NULL),('f5820987-9bfc-4c38-bea2-5443be6e4aa2',9,NULL,4058,'KES',NULL,NULL,NULL,'succeeded','2025-03-31 18:24:29','2025-03-31 18:24:36','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 4058, \"msisdn\": \"254792338099\", \"reference\": \"afripesa\", \"merchant_id\": \"5141482\"}','{\"amount\": \"4058\", \"msisdn\": \"254792338099\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"afripesa\", \"created_at\": \"2025-03-31 18:24:29\", \"finalised_at\": \"2025-03-31T18:24:33.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TCV1VN8CRZ\", \"silkpesa_reference\": \"SIL-1743445469-586\", \"receiver_description\": \"254792338099 - cynthia mwikali ngina\"}',NULL,'TCV1VN8CRZ','254792338099 - cynthia mwikali ngina',NULL),('f59e91fc-17db-400e-89b2-b586068918b5',1,'C119DF1E-B034-4CD1-BC53-B2BDDB359BBB',5,'KES','{\"Result\": \"000\", \"TransRef\": \"R61988123\", \"TransToken\": \"C119DF1E-B034-4CD1-BC53-B2BDDB359BBB\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'new','2024-10-29 06:42:42','2024-10-29 06:42:42','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('f5b11c97-ddd5-4fc3-a38a-2e147e48b4ae',9,NULL,31779,'KES',NULL,NULL,NULL,'succeeded','2025-07-04 14:25:19','2025-07-04 14:25:27','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 31779, \"msisdn\": \"254727497778\", \"reference\": \"afripesa\", \"merchant_id\": \"5141482\"}','{\"amount\": \"31779\", \"msisdn\": \"254727497778\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"afripesa\", \"created_at\": \"2025-07-04 11:25:19\", \"finalised_at\": \"2025-07-04T11:25:24.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TG43KI1BOJ\", \"silkpesa_reference\": \"SIL-1751628319-646\", \"receiver_description\": \"254727497778 - FRANCIS AMBIA MWAMBI\"}',NULL,'TG43KI1BOJ','254727497778 - FRANCIS AMBIA MWAMBI',NULL),('f5f4f3b4-5986-4c21-ab17-051ab38df5cc',1,'47CA177E-8B3E-4112-B9DA-EFE53BCCA718',1,'USD','{\"Result\": \"000\", \"TransRef\": \"R62850044\", \"TransToken\": \"47CA177E-8B3E-4112-B9DA-EFE53BCCA718\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'new','2024-11-25 17:49:19','2024-11-25 17:49:19','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('f60ab709-ee76-4501-ac50-07337aeead8a',99,NULL,2350,'KES',NULL,NULL,NULL,'succeeded','2025-10-16 09:37:10','2025-10-16 09:37:16','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 2350, \"msisdn\": \"254723408668\", \"reference\": \"vazy vintage\", \"merchant_id\": \"5141482\"}','{\"amount\": \"2350\", \"msisdn\": \"254723408668\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"currency\": \"KES\", \"reference\": \"vazy vintage\", \"created_at\": \"2025-10-16 06:37:10\", \"finalised_at\": \"2025-10-16T06:37:13.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TJGRD7JEW0\", \"silkpesa_reference\": \"SIL-1760596630-620\", \"receiver_description\": \"254723408668 - JUDITH AKOTH\"}',NULL,'TJGRD7JEW0','254723408668 - JUDITH AKOTH',NULL),('f60c4be1-cf44-4df0-807d-a3881c7b40ac',22,'074CCF68-270E-473C-BE84-814B3249621F',5,'USD','{\"Result\": \"000\", \"TransRef\": \"R62766396\", \"TransToken\": \"074CCF68-270E-473C-BE84-814B3249621F\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'new','2024-11-23 03:47:11','2024-11-23 03:47:11','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('f62b8c94-9fcf-4ed0-ba70-2bcc46e8fbd7',22,'3F5E6C29-C9CB-46B2-9300-B73DB27F1334',1,'USD','{\"Result\": \"000\", \"TransRef\": \"R63086885\", \"TransToken\": \"3F5E6C29-C9CB-46B2-9300-B73DB27F1334\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'new','2024-12-02 23:49:48','2024-12-02 23:49:48','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('f63984fe-e0be-4ff3-a232-d0a08f43f853',1,'6BF5F74A-5291-497D-9697-C7DA71FFA97D',5,'KES','{\"Result\": \"000\", \"TransRef\": \"R61994792\", \"TransToken\": \"6BF5F74A-5291-497D-9697-C7DA71FFA97D\", \"ResultExplanation\": \"Transaction created\"}','{\"pnrID\": \"XZEMAU\", \"transID\": \"6BF5F74A-5291-497D-9697-C7DA71FFA97D\", \"companyRef\": \"XZEMAU\", \"ccdApproval\": \"SJT9TOAAXD\", \"transactionToken\": \"6BF5F74A-5291-497D-9697-C7DA71FFA97D\"}','{\"AccRef\": {}, \"Result\": \"000\", \"FraudAlert\": \"001\", \"CustomerZip\": {}, \"CustomerCity\": {}, \"CustomerName\": {}, \"CustomerPhone\": \"0791811781\", \"CustomerCredit\": {}, \"CustomerAddress\": {}, \"CustomerCountry\": {}, \"FraudExplnation\": \"Low Risk (Not checked)\", \"ResultExplanation\": \"Transaction Paid\", \"TransactionAmount\": \"5.00\", \"CustomerCreditType\": \"Mobile\", \"TransactionApproval\": \"SJT9TOAAXD\", \"TransactionCurrency\": \"KES\", \"MobilePaymentRequest\": \"Paid\", \"TransactionNetAmount\": \"0.00\", \"TransactionFinalAmount\": \"5.00\", \"TransactionFinalCurrency\": \"KES\", \"TransactionSettlementDate\": \"2024/10/29\", \"TransactionRollingReserveDate\": {}, \"TransactionRollingReserveAmount\": \"0.00\"}','succeeded','2024-10-29 10:46:01','2024-10-29 10:47:09','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('f651f593-c8c2-4820-96c5-451072804b52',1,NULL,10,'KES',NULL,NULL,NULL,'failed','2025-02-16 11:06:05','2025-02-16 11:06:06','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 10, \"msisdn\": \"254791811781\", \"reference\": \"test\", \"merchant_id\": \"5141482\"}',NULL,NULL,NULL,NULL,NULL),('f6709a97-9b2f-4063-80b2-a7c775d18a27',9,'6514964A-8E34-4C41-A415-7F679C893B00',15,'KES','{\"Result\":\"000\",\"ResultExplanation\":\"Transaction created\",\"TransToken\":\"6514964A-8E34-4C41-A415-7F679C893B00\",\"TransRef\":\"R70129899\"}',NULL,NULL,'accepted','2025-07-18 21:03:59','2025-07-18 21:03:59','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('f671035a-2c9e-48f6-bb2b-8f29b3fffaff',24,NULL,10,'KES',NULL,NULL,NULL,'succeeded','2025-10-14 10:49:49','2025-10-14 10:49:57','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 10, \"msisdn\": \"254715539644\", \"reference\": \"Ali\", \"merchant_id\": \"5141482\"}','{\"amount\": \"10\", \"msisdn\": \"254715539644\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"currency\": \"KES\", \"reference\": \"Ali\", \"created_at\": \"2025-10-14 07:49:50\", \"finalised_at\": \"2025-10-14T07:49:55.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TJE357FJOP\", \"silkpesa_reference\": \"SIL-1760428190-592\", \"receiver_description\": \"254715539644 - KAGWE KIBUGU\"}',NULL,'TJE357FJOP','254715539644 - KAGWE KIBUGU',NULL),('f68f0e39-ea5c-43e9-bdbe-77338bf80fe2',9,NULL,15,'KES',NULL,NULL,NULL,'succeeded','2025-04-06 16:50:18','2025-04-06 16:50:24','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 15, \"msisdn\": \"254721429631\", \"reference\": \"test\", \"merchant_id\": \"5141482\"}','{\"amount\": \"15\", \"msisdn\": \"254721429631\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"test\", \"created_at\": \"2025-04-06 16:50:18\", \"finalised_at\": \"2025-04-06T16:50:21.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TD67OWUUHT\", \"silkpesa_reference\": \"SIL-1743958218-758\", \"receiver_description\": \"254721429631 - KENNEDY JUNIOR\"}',NULL,'TD67OWUUHT','254721429631 - KENNEDY JUNIOR',NULL),('f6951138-eb14-4abd-978f-d1b0873d64ac',9,NULL,45000,'KES',NULL,NULL,NULL,'succeeded','2025-04-03 08:11:43','2025-04-03 08:11:43','VOUCHER','c2b','voucher','',NULL,NULL,NULL,NULL,NULL,NULL),('f6abce3f-5c54-4a67-abb8-7d2225a634c2',60,'21658A45-E4A5-44DC-968D-08D04E67FE40',2,'KES','{\"Result\": \"000\", \"TransRef\": \"R66265700\", \"TransToken\": \"21658A45-E4A5-44DC-968D-08D04E67FE40\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'new','2025-03-19 04:35:31','2025-03-19 04:35:31','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('f6c16636-b9f0-4d70-bf1e-74530150bd29',9,NULL,53347,'KES',NULL,NULL,NULL,'succeeded','2025-02-02 12:33:43','2025-02-02 12:33:44','MPESA','b2c',NULL,'','{\"Amount\": \"53347\", \"PartyA\": \"5141482\", \"PartyB\": \"254721139305\", \"Remarks\": \"afripesa\", \"CommandID\": \"BusinessPayment\", \"Occassion\": \"afripesa\", \"ResultURL\": \"https://app.safaribucks.com/api/mpesa/business_to_customer/result\", \"InitiatorName\": \"gloclienapiuser\", \"QueueTimeOutURL\": \"https://app.safaribucks.com/api/mpesa/business_to_customer/result\", \"SecurityCredential\": \"SFWRbnNag6WDXB092t43vuXZ0t697AJGuiBenvygawPZzidOhzJAYZT8PzGRP7OO3bJVqKNXrkGQb9GWNvYYnbISf7z09otCDoOIFvdzmxQbFQ/3X14+b75QVmAd3qeQebqmBC1aMleNYXFQgNchomKfTXICrdZLDV0/HsYYB8M5nMtPbc2W4iC8ie2h+UKmq6+zmEhpZd2+3RIJpyh827eTxrICBFMMSX1bBKPfzhOoamRdVSNk8m0rMrRYHG/b+KakmG8QIYm4ffKiNKAa/sU9O5ISx71HfhbRPu+Jq5kLYWJ0nyuqTBpqAJzk3JHK5xl504t9IDKeonqa0aJ5eA==\", \"OriginatorConversationID\": \"f6c16636-b9f0-4d70-bf1e-74530150bd29\"}','{\"Result\": {\"ResultCode\": 0, \"ResultDesc\": \"The service request is processed successfully.\", \"ResultType\": 0, \"ReferenceData\": {\"ReferenceItem\": {\"Key\": \"QueueTimeoutURL\", \"Value\": \"http://internalapi.safaricom.co.ke/mpesa/b2cresults/v1/submit\"}}, \"TransactionID\": \"TB26HI17C6\", \"ConversationID\": \"AG_20250202_203063373709f7238d46\", \"ResultParameters\": {\"ResultParameter\": [{\"Key\": \"TransactionAmount\", \"Value\": 53347}, {\"Key\": \"TransactionReceipt\", \"Value\": \"TB26HI17C6\"}, {\"Key\": \"ReceiverPartyPublicName\", \"Value\": \"254721139305 - MANASSES MARTIN NJIRU\"}, {\"Key\": \"TransactionCompletedDateTime\", \"Value\": \"02.02.2025 18:33:44\"}, {\"Key\": \"B2CUtilityAccountAvailableFunds\", \"Value\": 51378}, {\"Key\": \"B2CWorkingAccountAvailableFunds\", \"Value\": 2724}, {\"Key\": \"B2CRecipientIsRegisteredCustomer\", \"Value\": \"Y\"}, {\"Key\": \"B2CChargesPaidAccountAvailableFunds\", \"Value\": 0}]}, \"OriginatorConversationID\": \"f6c16636-b9f0-4d70-bf1e-74530150bd29\"}}',NULL,NULL,NULL,NULL),('f6cdeea6-f0ea-40a7-8223-e2dfa2d2df03',9,NULL,70000,'KES',NULL,NULL,NULL,'succeeded','2025-03-25 18:43:08','2025-03-25 18:43:08','VOUCHER','c2b','voucher','',NULL,NULL,NULL,NULL,NULL,NULL),('f6d9754b-a592-4e5d-b442-d92b231b3cd3',9,NULL,1480,'KES',NULL,NULL,NULL,'succeeded','2025-03-20 14:07:35','2025-03-20 14:07:44','MPESA','b2b','buy_goods','','{\"type\": \"business_buy_goods\", \"amount\": 1480, \"msisdn\": \"5010661\", \"reference\": \"food\", \"merchant_id\": \"5141482\"}','{\"amount\": \"1480\", \"msisdn\": \"5010661\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"food\", \"created_at\": \"2025-03-20 17:07:36\", \"finalised_at\": \"2025-03-20T17:07:41.000000Z\", \"transaction_type\": \"business_buy_goods\", \"vendor_reference\": \"TCK2GXD5NM\", \"silkpesa_reference\": \"SIL-1742490456-880\", \"receiver_description\": null}',NULL,'TCK2GXD5NM',NULL,NULL),('f6d9ead5-4429-456a-b8da-1fd60f89b9c4',9,NULL,3000,'KES',NULL,NULL,NULL,'succeeded','2025-04-25 10:27:16','2025-04-25 10:27:23','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 3000, \"msisdn\": \"254725254669\", \"reference\": \"elec\", \"merchant_id\": \"5141482\"}','{\"amount\": \"3000\", \"msisdn\": \"254725254669\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"elec\", \"created_at\": \"2025-04-25 10:27:16\", \"finalised_at\": \"2025-04-25T10:27:21.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TDP95BB6RT\", \"silkpesa_reference\": \"SIL-1745576836-446\", \"receiver_description\": \"254725254669 - MARY NDUNGU\"}',NULL,'TDP95BB6RT','254725254669 - MARY NDUNGU',NULL),('f6ddfd23-4643-4bd2-839c-0772081fa0dc',9,'D8FCFFEB-2520-4CBE-869F-C365821B8E66',100,'KES','{\"Result\": \"000\", \"TransRef\": \"R62687283\", \"TransToken\": \"D8FCFFEB-2520-4CBE-869F-C365821B8E66\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'new','2024-11-20 12:25:28','2024-11-20 12:25:28','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('f6e8356f-d023-4501-ab27-52a198e1bfb5',95,NULL,100,'KES',NULL,NULL,NULL,'succeeded','2025-09-13 17:00:05','2025-09-13 17:00:05','VOUCHER','c2b','voucher','',NULL,NULL,NULL,NULL,NULL,NULL),('f7543fb0-b135-449d-8db7-580cd858f4d0',47,'64C89268-C465-429C-84B6-201EFE778DF6',100,'USD','{\"Result\": \"000\", \"TransRef\": \"R66367812\", \"TransToken\": \"64C89268-C465-429C-84B6-201EFE778DF6\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'new','2025-03-22 13:31:51','2025-03-22 13:31:51','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('f7a23f9e-63b3-4282-b707-1b815d7e8b5d',9,NULL,50,'KES',NULL,NULL,NULL,'succeeded','2024-11-19 08:09:50','2024-11-19 08:09:50','MPESA','b2b','paybill','','{\"Amount\": \"50\", \"PartyA\": \"5141482\", \"PartyB\": \"4081329\", \"Remarks\": \"test\", \"CommandID\": \"BusinessPayBill\", \"Initiator\": \"gloclienapiuser\", \"Requester\": \"\", \"ResultURL\": \"https://app.safaribucks.com/api/mpesa/business_pay_bill/result\", \"QueueTimeOutURL\": \"https://app.safaribucks.com/api/mpesa/business_pay_bill/result\", \"AccountReference\": \"test\", \"SecurityCredential\": \"UwYPxO8Lytr8nvVstTzdWltYmSl11q4fhFHu4Vz8k00mOcDKcwrY4WNRsq2+t1cmoSl9X1wA3vblH/9Vg2MFx+UZtknbOVUwBxmG7wNaa/0Fl5M6G5M/5EGLe9CMpDg5h/1Yh5flwmRxEa7T+KmEyZOPxGbuL+SSBxhcylqayNb0jYs2iGDN0b2KVAdFRYn1Y04Unm7eueUq5na2arNg891qXpoDwUPnziJIDdOg0zNp7jUbEy5daYCKsSOyecJFdWxTFLufdELctm3o8U+lYz7pXtA7HfoU2fdrTe2BUD+RNFXuNofhtVXNZjGY6kZhT7Ls7IRqY9Bldx+mFoTcgw==\", \"SenderIdentifierType\": \"4\", \"RecieverIdentifierType\": \"4\", \"OriginatorConversationID\": \"f7a23f9e-63b3-4282-b707-1b815d7e8b5d\"}','{\"Result\": {\"ResultCode\": 0, \"ResultDesc\": \"The service request is processed successfully.\", \"ResultType\": 0, \"ReferenceData\": {\"ReferenceItem\": [{\"Key\": \"BillReferenceNumber\", \"Value\": \"test\"}, {\"Key\": \"QueueTimeoutURL\", \"Value\": \"https://internalapi.safaricom.net/mpesa/b2bresults/v1/submit\"}, {\"Key\": \"Occassion\"}]}, \"TransactionID\": \"SKJ7CYW7JD\", \"ConversationID\": \"AG_20241119_207048c5b28e778de25b\", \"ResultParameters\": {\"ResultParameter\": [{\"Key\": \"Currency\", \"Value\": \"KES\"}, {\"Key\": \"ReceiverPartyPublicName\", \"Value\": \"4081329 - HAYAAN SACCO\"}, {\"Key\": \"DebitPartyCharges\"}, {\"Key\": \"TransCompletedTime\", \"Value\": 20241119140950}, {\"Key\": \"DebitPartyAffectedAccountBalance\", \"Value\": \"Working Account|KES|394.00|394.00|0.00|0.00\"}, {\"Key\": \"Amount\", \"Value\": 50}, {\"Key\": \"DebitAccountCurrentBalance\", \"Value\": \"{Amount={CurrencyCode=KES, MinimumAmount=39400, BasicAmount=394.00}}\"}, {\"Key\": \"InitiatorAccountCurrentBalance\", \"Value\": \"{Amount={CurrencyCode=KES, MinimumAmount=39400, BasicAmount=394.00}}\"}]}, \"OriginatorConversationID\": \"6f75-43a9-b964-2f272ddd9b5d39863787\"}}',NULL,NULL,NULL,NULL),('f7a64fe2-8768-4cdd-86b1-5ac04ad2b02d',9,NULL,400,'KES',NULL,NULL,NULL,'succeeded','2025-05-17 17:05:00','2025-05-17 17:05:06','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 400, \"msisdn\": \"254721812719\", \"reference\": \"food\", \"merchant_id\": \"5141482\"}','{\"amount\": \"400\", \"msisdn\": \"254721812719\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"food\", \"created_at\": \"2025-05-17 14:05:01\", \"finalised_at\": \"2025-05-17T14:05:04.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TEH24MTW5U\", \"silkpesa_reference\": \"SIL-1747490701-873\", \"receiver_description\": \"254721812719 - MOHAMED ADAN\"}',NULL,'TEH24MTW5U','254721812719 - MOHAMED ADAN',NULL),('f7aff30f-c2d6-4fa9-b22b-9dbea9f53cb8',24,NULL,5000,'KES',NULL,NULL,NULL,'succeeded','2025-05-23 12:13:04','2025-05-23 12:13:09','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 5000, \"msisdn\": \"254721812719\", \"reference\": \"Ali\", \"merchant_id\": \"5141482\"}','{\"amount\": \"5000\", \"msisdn\": \"254721812719\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"Ali\", \"created_at\": \"2025-05-23 09:13:04\", \"finalised_at\": \"2025-05-23T09:13:06.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TEN8UTEUO6\", \"silkpesa_reference\": \"SIL-1747991584-672\", \"receiver_description\": \"254721812719 - MOHAMED ADAN\"}',NULL,'TEN8UTEUO6','254721812719 - MOHAMED ADAN',NULL);
INSERT INTO `transactions` VALUES ('f7c2fb85-2b66-466d-b130-aac75c839c46',59,'360FDD6D-B1E5-41F9-8241-3D984D2EC924',40,'USD','{\"Result\": \"000\", \"TransRef\": \"R66170109\", \"TransToken\": \"360FDD6D-B1E5-41F9-8241-3D984D2EC924\", \"ResultExplanation\": \"Transaction created\"}','{\"pnrID\": \"XZEMAU\", \"transID\": \"360FDD6D-B1E5-41F9-8241-3D984D2EC924\", \"companyRef\": \"XZEMAU\", \"ccdApproval\": \"01669Z\", \"transactionToken\": \"360FDD6D-B1E5-41F9-8241-3D984D2EC924\"}','{\"AccRef\": {}, \"Result\": \"000\", \"FraudAlert\": \"001\", \"CustomerZip\": \"L6T0a4\", \"CustomerCity\": \"Brampton \", \"CustomerName\": \"Gurnek  Gahunia \", \"CustomerPhone\": \"4163339600\", \"CustomerCredit\": \"1985\", \"CustomerAddress\": \"10 Manswood cres \", \"CustomerCountry\": \"Canada\", \"FraudExplnation\": \"Low Risk (Not checked)\", \"ResultExplanation\": \"Transaction Paid\", \"TransactionAmount\": \"40.00\", \"CustomerCreditType\": \"MASC\", \"TransactionApproval\": \"01669Z\", \"TransactionCurrency\": \"USD\", \"MobilePaymentRequest\": \"Not sent\", \"TransactionNetAmount\": \"0.00\", \"TransactionFinalAmount\": \"40.00\", \"TransactionFinalCurrency\": \"USD\", \"TransactionSettlementDate\": \"2025/03/16\", \"TransactionRollingReserveDate\": {}, \"TransactionRollingReserveAmount\": \"0.00\"}','succeeded','2025-03-16 00:24:14','2025-03-16 00:27:30','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('f7c64a4b-0041-49b3-9897-afc6dd425a62',1,'58DC0264-313F-4C22-BEF4-4597549F408A',3,'USD','{\"Result\": \"000\", \"TransRef\": \"R63192127\", \"TransToken\": \"58DC0264-313F-4C22-BEF4-4597549F408A\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'new','2024-12-06 05:55:27','2024-12-06 05:55:27','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('f7cf0570-68c3-4ff9-a782-178794a3a75f',22,'D65D557F-95FC-4FD6-800B-9D8EAD395040',1000,'USD','{\"Result\":\"000\",\"ResultExplanation\":\"Transaction created\",\"TransToken\":\"D65D557F-95FC-4FD6-800B-9D8EAD395040\",\"TransRef\":\"R71184343\"}',NULL,NULL,'accepted','2025-08-17 03:39:06','2025-08-17 03:39:06','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('f7d75dbc-7dd0-4b84-a1ae-b78a63d3039b',25,NULL,1000,'KES',NULL,NULL,NULL,'failed','2025-04-09 10:28:54','2025-04-09 10:29:01','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 1000, \"msisdn\": \"254716368161\", \"reference\": \"Sibling support\", \"merchant_id\": \"5141482\"}','{\"amount\": \"1000\", \"msisdn\": \"254716368161\", \"status\": \"FAILED\", \"channel\": \"KE.MPESA\", \"reference\": \"Sibling support\", \"created_at\": \"2025-04-09 10:28:54\", \"finalised_at\": \"2025-04-09T10:28:58.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": null, \"silkpesa_reference\": \"SIL-1744194534-825\", \"receiver_description\": null}',NULL,NULL,NULL,NULL),('f8063856-c408-44c7-820f-1e061c470bd9',24,NULL,2000,'KES',NULL,NULL,NULL,'succeeded','2025-05-03 20:18:19','2025-05-03 20:18:24','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 2000, \"msisdn\": \"254797422247\", \"reference\": \"Ali\", \"merchant_id\": \"5141482\"}','{\"amount\": \"2000\", \"msisdn\": \"254797422247\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"Ali\", \"created_at\": \"2025-05-03 17:18:19\", \"finalised_at\": \"2025-05-03T17:18:22.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TE31AOR9IX\", \"silkpesa_reference\": \"SIL-1746292699-407\", \"receiver_description\": \"0797422247 - Winfred Rose Makokha\"}',NULL,'TE31AOR9IX','0797422247 - Winfred Rose Makokha',NULL),('f8295cba-ecab-42e4-a170-71a402f334e7',9,NULL,135000,'KES',NULL,NULL,NULL,'succeeded','2025-10-05 19:52:46','2025-10-05 19:52:46','VOUCHER','c2b','voucher','',NULL,NULL,NULL,NULL,NULL,NULL),('f82b56ce-3730-4894-be2a-29899207cb6a',59,'82216934-BE8B-4CFD-9835-A934FED1385E',5,'USD','{\"Result\": \"000\", \"TransRef\": \"R66013039\", \"TransToken\": \"82216934-BE8B-4CFD-9835-A934FED1385E\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'new','2025-03-10 17:45:22','2025-03-10 17:45:22','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('f8349609-5799-4857-ab19-d9507d69e1a5',24,NULL,5000,'KES',NULL,NULL,NULL,'succeeded','2024-12-17 07:20:40','2024-12-17 07:20:40','MPESA','b2c',NULL,'','{\"Amount\": \"5000\", \"PartyA\": \"5141482\", \"PartyB\": \"254759937432\", \"Remarks\": \"Ali\", \"CommandID\": \"BusinessPayment\", \"Occassion\": \"Ali\", \"ResultURL\": \"https://app.safaribucks.com/api/mpesa/business_to_customer/result\", \"InitiatorName\": \"gloclienapiuser\", \"QueueTimeOutURL\": \"https://app.safaribucks.com/api/mpesa/business_to_customer/result\", \"SecurityCredential\": \"Dd0Q1hLEKN+inTXuvPUWdnAtlrzAHyGWcjbcyDDdAaZz80Ja8HU/7clIaPItvS5EM27T14GqvR7C7ZDqEFd1g1rH2bGUvM/46/AN1TgZMUHTSbJNRsseOtwe21CYxQgXJ3BUoLz04+63iO+6cv3PcBiwIbXdiconT9O0FCh3gwlsMMebFkZlDWbWJW3MbbICPjqdp/IKbLDPOzFlYhOskVfPbg6lMzWDN5JCtkBQRfkjmPdcutDSlMcK6PWneEBZ9CSONi8QAma4kqa7J6UhiHGuHm2tbB7QUtfRXEfvRfJ/mMmUa3AOUZdOxBd52UZ6vxvtLGIeYDGNzw+aG30+dw==\", \"OriginatorConversationID\": \"f8349609-5799-4857-ab19-d9507d69e1a5\"}','{\"Result\": {\"ResultCode\": 0, \"ResultDesc\": \"The service request is processed successfully.\", \"ResultType\": 0, \"ReferenceData\": {\"ReferenceItem\": {\"Key\": \"QueueTimeoutURL\", \"Value\": \"http://internalapi.safaricom.co.ke/mpesa/b2cresults/v1/submit\"}}, \"TransactionID\": \"SLH3S9NIG9\", \"ConversationID\": \"AG_20241217_20601b20effa4ae548e1\", \"ResultParameters\": {\"ResultParameter\": [{\"Key\": \"TransactionAmount\", \"Value\": 5000}, {\"Key\": \"TransactionReceipt\", \"Value\": \"SLH3S9NIG9\"}, {\"Key\": \"ReceiverPartyPublicName\", \"Value\": \"254759937432 - ALI HUSSEIN HASSAN\"}, {\"Key\": \"TransactionCompletedDateTime\", \"Value\": \"17.12.2024 13:20:40\"}, {\"Key\": \"B2CUtilityAccountAvailableFunds\", \"Value\": 524}, {\"Key\": \"B2CWorkingAccountAvailableFunds\", \"Value\": 706}, {\"Key\": \"B2CRecipientIsRegisteredCustomer\", \"Value\": \"Y\"}, {\"Key\": \"B2CChargesPaidAccountAvailableFunds\", \"Value\": 0}]}, \"OriginatorConversationID\": \"f8349609-5799-4857-ab19-d9507d69e1a5\"}}',NULL,NULL,NULL,NULL),('f88c7287-fae8-4573-9ba3-a84e1aac3f01',25,NULL,1000,'KES',NULL,NULL,NULL,'failed','2025-04-09 09:26:37','2025-04-09 09:26:43','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 1000, \"msisdn\": \"254716368162\", \"reference\": \"family member support\", \"merchant_id\": \"5141482\"}','{\"amount\": \"1000\", \"msisdn\": \"254716368162\", \"status\": \"FAILED\", \"channel\": \"KE.MPESA\", \"reference\": \"family member support\", \"created_at\": \"2025-04-09 09:26:37\", \"finalised_at\": \"2025-04-09T09:26:40.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": null, \"silkpesa_reference\": \"SIL-1744190797-111\", \"receiver_description\": null}',NULL,NULL,NULL,NULL),('f88ceb2c-44a7-415b-8367-d9bb700f6353',22,NULL,3250,'KES',NULL,NULL,NULL,'failed','2025-05-08 23:06:37','2025-05-08 23:06:42','MPESA','b2b','buy_goods','','{\"type\": \"business_buy_goods\", \"amount\": 3250, \"msisdn\": \"4113891\", \"reference\": \"food\", \"merchant_id\": \"5141482\"}','{\"amount\": \"3250\", \"msisdn\": \"4113891\", \"status\": \"FAILED\", \"channel\": \"KE.MPESA\", \"reference\": \"food\", \"created_at\": \"2025-05-08 20:06:37\", \"finalised_at\": \"2025-05-08T20:06:39.000000Z\", \"transaction_type\": \"business_buy_goods\", \"vendor_reference\": null, \"silkpesa_reference\": \"SIL-1746734797-674\", \"receiver_description\": null}',NULL,NULL,NULL,NULL),('f8c4512b-91cb-4810-b9e6-82f0e9f67a45',9,NULL,24152,'KES',NULL,NULL,NULL,'failed','2025-07-04 14:29:20','2025-07-04 14:29:25','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 24152, \"msisdn\": \"254726077499\", \"reference\": \"afripesa\", \"merchant_id\": \"5141482\"}','{\"amount\": \"24152\", \"msisdn\": \"254726077499\", \"status\": \"FAILED\", \"channel\": \"KE.MPESA\", \"reference\": \"afripesa\", \"created_at\": \"2025-07-04 11:29:20\", \"finalised_at\": \"2025-07-04T11:29:22.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": null, \"silkpesa_reference\": \"SIL-1751628560-857\", \"receiver_description\": null}',NULL,NULL,NULL,NULL),('f8ce7682-2784-4297-b370-9e9193cc4edc',24,'5792371F-791C-4D2D-9FB2-FF82B70D2F74',5000,'KES','{\"Result\": \"000\", \"TransRef\": \"R64294184\", \"TransToken\": \"5792371F-791C-4D2D-9FB2-FF82B70D2F74\", \"ResultExplanation\": \"Transaction created\"}','{\"pnrID\": \"XZEMAU\", \"transID\": \"5792371F-791C-4D2D-9FB2-FF82B70D2F74\", \"companyRef\": \"XZEMAU\", \"ccdApproval\": \"A6NTD1\", \"transactionToken\": \"5792371F-791C-4D2D-9FB2-FF82B70D2F74\"}','{\"AccRef\": {}, \"Result\": \"000\", \"FraudAlert\": \"001\", \"CustomerZip\": \"W5 4RF\", \"CustomerCity\": \"London\", \"CustomerName\": \"Ali Hassan\", \"CustomerPhone\": \"0759937432\", \"CustomerCredit\": \"1\", \"CustomerAddress\": \"79 Claypond Gardens\", \"CustomerCountry\": \"United Kingdom\", \"FraudExplnation\": \"Low Risk (Not checked)\", \"ResultExplanation\": \"Transaction Paid\", \"TransactionAmount\": \"5000.00\", \"CustomerCreditType\": \"MASC\", \"TransactionApproval\": \"A6NTD1\", \"TransactionCurrency\": \"KES\", \"MobilePaymentRequest\": \"Not sent\", \"TransactionNetAmount\": \"0.00\", \"TransactionFinalAmount\": \"5000.00\", \"TransactionFinalCurrency\": \"KES\", \"TransactionSettlementDate\": \"2025/01/13\", \"TransactionRollingReserveDate\": {}, \"TransactionRollingReserveAmount\": \"0.00\"}','succeeded','2025-01-13 09:36:46','2025-01-13 09:38:54','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('f8db8bea-f10d-4e51-9b1e-aad80b8967cc',9,'273FECAA-61ED-4100-859F-A46ACECA7EFD',100,'KES','{\"Result\": \"000\", \"TransRef\": \"R63519568\", \"TransToken\": \"273FECAA-61ED-4100-859F-A46ACECA7EFD\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'new','2024-12-17 12:55:49','2024-12-17 12:55:49','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('f8dcdea2-84c4-442b-b9c1-de53ae66edd8',9,NULL,500,'KES',NULL,NULL,NULL,'succeeded','2025-05-04 20:42:52','2025-05-04 20:42:57','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 500, \"msisdn\": \"254714545971\", \"reference\": \"irine\", \"merchant_id\": \"5141482\"}','{\"amount\": \"500\", \"msisdn\": \"254714545971\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"irine\", \"created_at\": \"2025-05-04 17:42:52\", \"finalised_at\": \"2025-05-04T17:42:54.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TE47FC817J\", \"silkpesa_reference\": \"SIL-1746380572-178\", \"receiver_description\": \"254714545971 - EVERLINE MONGARE\"}',NULL,'TE47FC817J','254714545971 - EVERLINE MONGARE',NULL),('f90b5fb3-1cd6-4bd7-9ab1-da022ecca281',24,'1F7BFDE5-AF2A-49A1-9DDE-D3F38A8BCC5D',10,'USD','{\"Result\":\"000\",\"ResultExplanation\":\"Transaction created\",\"TransToken\":\"1F7BFDE5-AF2A-49A1-9DDE-D3F38A8BCC5D\",\"TransRef\":\"R70467382\"}',NULL,NULL,'accepted','2025-07-29 11:19:30','2025-07-29 11:19:30','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('f930124c-562b-4b82-ae12-3ff0a2d6920b',24,NULL,1500,'KES',NULL,NULL,NULL,'failed','2025-04-23 13:26:07','2025-04-23 13:26:13','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 1500, \"msisdn\": \"254759937432\", \"reference\": \"Ali\", \"merchant_id\": \"5141482\"}','{\"amount\": \"1500\", \"msisdn\": \"254759937432\", \"status\": \"FAILED\", \"channel\": \"KE.MPESA\", \"reference\": \"Ali\", \"created_at\": \"2025-04-23 13:26:07\", \"finalised_at\": \"2025-04-23T13:26:11.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": null, \"silkpesa_reference\": \"SIL-1745414767-976\", \"receiver_description\": null}',NULL,NULL,NULL,NULL),('f94b0b07-fad7-4752-b87e-0726235fbdd9',99,NULL,1300,'KES',NULL,NULL,NULL,'succeeded','2025-10-12 15:42:31','2025-10-12 15:42:37','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 1300, \"msisdn\": \"254706262753\", \"reference\": \"bracelet\", \"merchant_id\": \"5141482\"}','{\"amount\": \"1300\", \"msisdn\": \"254706262753\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"currency\": \"KES\", \"reference\": \"bracelet\", \"created_at\": \"2025-10-12 12:42:31\", \"finalised_at\": \"2025-10-12T12:42:35.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TJC9B74QA9\", \"silkpesa_reference\": \"SIL-1760272951-748\", \"receiver_description\": \"254706262753 - JACKSON KITUM CHESEREK\"}',NULL,'TJC9B74QA9','254706262753 - JACKSON KITUM CHESEREK',NULL),('f973914c-47f6-451a-b9ae-cbfcec4fdd5a',9,NULL,15,'KES',NULL,NULL,NULL,'succeeded','2025-04-13 16:59:07','2025-04-13 16:59:18','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 15, \"msisdn\": \"254721812719\", \"reference\": \"food\", \"merchant_id\": \"5141482\"}','{\"amount\": \"15\", \"msisdn\": \"254721812719\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"food\", \"created_at\": \"2025-04-13 16:59:07\", \"finalised_at\": \"2025-04-13T16:59:16.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TDD1MSSHQ5\", \"silkpesa_reference\": \"SIL-1744563547-509\", \"receiver_description\": \"254721812719 - MOHAMED ADAN\"}',NULL,'TDD1MSSHQ5','254721812719 - MOHAMED ADAN',NULL),('f9aa683b-eac5-4d10-b8c6-140792fc9cb2',9,NULL,95000,'KES',NULL,NULL,NULL,'succeeded','2025-05-02 12:18:56','2025-05-02 12:18:56','VOUCHER','c2b','voucher','',NULL,NULL,NULL,NULL,NULL,NULL),('f9ee439c-1632-4e1e-8d19-576405b14162',30,'64BF0118-7485-479C-931E-C89334E524F7',15000,'KES','{\"Result\": \"000\", \"TransRef\": \"R63798401\", \"TransToken\": \"64BF0118-7485-479C-931E-C89334E524F7\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'new','2024-12-27 08:00:04','2024-12-27 08:00:04','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('fa11d86d-9f25-4392-bd70-dd7dcc332940',9,NULL,300,'KES',NULL,NULL,NULL,'succeeded','2025-07-04 00:17:31','2025-07-04 00:17:37','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 300, \"msisdn\": \"254721812719\", \"reference\": \"food\", \"merchant_id\": \"5141482\"}','{\"amount\": \"300\", \"msisdn\": \"254721812719\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"food\", \"created_at\": \"2025-07-03 21:17:31\", \"finalised_at\": \"2025-07-03T21:17:34.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TG48IBTD0W\", \"silkpesa_reference\": \"SIL-1751577451-925\", \"receiver_description\": \"254721812719 - MOHAMED ADAN\"}',NULL,'TG48IBTD0W','254721812719 - MOHAMED ADAN',NULL),('fa2d75f2-0499-4f25-9672-018df842ffc1',9,NULL,10,'KES',NULL,NULL,NULL,'succeeded','2025-04-09 15:31:14','2025-04-09 15:31:19','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 10, \"msisdn\": \"254722842608\", \"reference\": \"testing\", \"merchant_id\": \"5141482\"}','{\"amount\": \"10\", \"msisdn\": \"254722842608\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"testing\", \"created_at\": \"2025-04-09 15:31:14\", \"finalised_at\": \"2025-04-09T15:31:17.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TD933I6UE7\", \"silkpesa_reference\": \"SIL-1744212674-607\", \"receiver_description\": \"254722842608 - Mohamed Warsame\"}',NULL,'TD933I6UE7','254722842608 - Mohamed Warsame',NULL),('fa2d7b6c-93a9-46e8-9e61-bb1aa6953b3c',1,'0BDC6E06-46C5-4CCA-B35A-5B588637408C',2,'USD','{\"Result\": \"000\", \"TransRef\": \"R62849975\", \"TransToken\": \"0BDC6E06-46C5-4CCA-B35A-5B588637408C\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'new','2024-11-25 17:45:59','2024-11-25 17:45:59','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('fa45f38a-4e3c-468a-9d5c-0a6754fd1fb5',9,NULL,15,'KES',NULL,NULL,NULL,'succeeded','2024-12-10 11:48:35','2024-12-10 11:48:36','MPESA','b2c',NULL,'','{\"Amount\": \"15\", \"PartyA\": \"5141482\", \"PartyB\": \"254714781075\", \"Remarks\": \"Test\", \"CommandID\": \"BusinessPayment\", \"Occassion\": \"Test\", \"ResultURL\": \"https://app.safaribucks.com/api/mpesa/business_to_customer/result\", \"InitiatorName\": \"gloclienapiuser\", \"QueueTimeOutURL\": \"https://app.safaribucks.com/api/mpesa/business_to_customer/result\", \"SecurityCredential\": \"Wag21OvB70ENja9b4H4WYY/gUJNwOAydAcJebIl1uQXvZxNlzlXh8Rb6/g6aY7pn4JhtkoDltWhJbwzm4t7XlHD1+j2Zta8Sd+JHtfwRlf/RmwTgyJy56SJFHNWJ5l262rkU1vjl1hBlQ4nKItn70oYNSfGGdo3FxrECS+ckYXatbqI97wI2ScLWdbCfjfq/mdOgN0LQhOZWOIye55Irt+x3XKHge/i4zUri9uUr4BM1ATXWkBxwOHR2dIYLJ7klMqHFCM2QqnoIw6cDpGzJcgAhyGTErmzgSIBKNpFmm6bliQeDsSs4TKroNg8v6i9o6Jd68fyaQZfAxQ3o1ANPNQ==\", \"OriginatorConversationID\": \"fa45f38a-4e3c-468a-9d5c-0a6754fd1fb5\"}','{\"Result\": {\"ResultCode\": 0, \"ResultDesc\": \"The service request is processed successfully.\", \"ResultType\": 0, \"ReferenceData\": {\"ReferenceItem\": {\"Key\": \"QueueTimeoutURL\", \"Value\": \"http://internalapi.safaricom.co.ke/mpesa/b2cresults/v1/submit\"}}, \"TransactionID\": \"SLA3YDFWHH\", \"ConversationID\": \"AG_20241210_20603462d9e3cad92517\", \"ResultParameters\": {\"ResultParameter\": [{\"Key\": \"TransactionAmount\", \"Value\": 15}, {\"Key\": \"TransactionReceipt\", \"Value\": \"SLA3YDFWHH\"}, {\"Key\": \"ReceiverPartyPublicName\", \"Value\": \"254714781075 - ELVIN LUNANI\"}, {\"Key\": \"TransactionCompletedDateTime\", \"Value\": \"10.12.2024 17:48:36\"}, {\"Key\": \"B2CUtilityAccountAvailableFunds\", \"Value\": 24414}, {\"Key\": \"B2CWorkingAccountAvailableFunds\", \"Value\": 908}, {\"Key\": \"B2CRecipientIsRegisteredCustomer\", \"Value\": \"Y\"}, {\"Key\": \"B2CChargesPaidAccountAvailableFunds\", \"Value\": 0}]}, \"OriginatorConversationID\": \"fa45f38a-4e3c-468a-9d5c-0a6754fd1fb5\"}}',NULL,NULL,NULL,NULL),('fa4a72f3-12d4-43c2-ae95-613cc2bf5505',37,'43C977AA-165A-4B7A-9061-D2AAF2F6E487',10,'KES','{\"Result\": \"000\", \"TransRef\": \"R64872656\", \"TransToken\": \"43C977AA-165A-4B7A-9061-D2AAF2F6E487\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'new','2025-02-01 10:35:22','2025-02-01 10:35:22','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('fa6915b1-0caf-40fc-8faa-2beea565c1a3',22,'5D589BA9-926E-4C3A-9172-DDEE0AFF6EE6',33,'USD','{\"Result\": \"000\", \"TransRef\": \"R67868258\", \"TransToken\": \"5D589BA9-926E-4C3A-9172-DDEE0AFF6EE6\", \"ResultExplanation\": \"Transaction created\"}','{\"pnrID\": \"XZEMAU\", \"transID\": \"5D589BA9-926E-4C3A-9172-DDEE0AFF6EE6\", \"companyRef\": \"XZEMAU\", \"ccdApproval\": \"2C56V3\", \"transactionToken\": \"5D589BA9-926E-4C3A-9172-DDEE0AFF6EE6\"}','{\"AccRef\": {}, \"Result\": \"000\", \"FraudAlert\": \"001\", \"CustomerZip\": \"40214\", \"CustomerCity\": \"Louisville \", \"CustomerName\": \"Salah Osman Adan\", \"CustomerPhone\": \"13083786566\", \"CustomerCredit\": \"172\", \"CustomerAddress\": \"1113 Royal Gardens Ct Apt 7\", \"CustomerCountry\": \"United States of America\", \"FraudExplnation\": \"Low Risk (Not checked)\", \"ResultExplanation\": \"Transaction Paid\", \"TransactionAmount\": \"33.00\", \"CustomerCreditType\": \"MASC\", \"TransactionApproval\": \"2C56V3\", \"TransactionCurrency\": \"USD\", \"MobilePaymentRequest\": \"Not sent\", \"TransactionNetAmount\": \"0.00\", \"TransactionFinalAmount\": \"33.00\", \"TransactionFinalCurrency\": \"USD\", \"TransactionSettlementDate\": \"2025/05/08\", \"TransactionRollingReserveDate\": {}, \"TransactionRollingReserveAmount\": \"0.00\"}','succeeded','2025-05-08 23:04:29','2025-05-08 23:05:57','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('fa8c6c9e-f77f-451d-beef-8d51aecb73aa',9,NULL,10,'KES',NULL,NULL,NULL,'succeeded','2025-05-06 10:32:15','2025-05-06 10:41:49','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 10, \"msisdn\": \"254721812719\", \"reference\": \"testing\", \"merchant_id\": \"5141482\"}','{\"amount\": \"10\", \"msisdn\": \"254721812719\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"testing\", \"created_at\": \"2025-05-06 07:32:15\", \"finalised_at\": \"2025-05-06T07:41:41.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TE62LO70QY\", \"silkpesa_reference\": \"SIL-1746516735-173\", \"receiver_description\": \"254721812719 - MOHAMED ADAN\"}',NULL,'TE62LO70QY','254721812719 - MOHAMED ADAN',NULL),('fa971089-bef2-4f22-a30e-a99f1f03357d',81,'1D0C3C91-F1A1-403C-BCEE-DD1C10093AA1',2000,'KES','{\"Result\":\"000\",\"ResultExplanation\":\"Transaction created\",\"TransToken\":\"1D0C3C91-F1A1-403C-BCEE-DD1C10093AA1\",\"TransRef\":\"R68408642\"}',NULL,NULL,'accepted','2025-05-26 18:05:09','2025-05-26 18:05:09','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('facd4342-876b-4a9b-9171-d7aac8423bb6',71,NULL,820,'KES',NULL,NULL,NULL,'succeeded','2025-05-02 07:25:24','2025-05-02 07:25:29','MPESA','b2b','buy_goods','','{\"type\": \"business_buy_goods\", \"amount\": 820, \"msisdn\": \"4549464\", \"reference\": \"breakfast\", \"merchant_id\": \"5141482\"}','{\"amount\": \"820\", \"msisdn\": \"4549464\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"breakfast\", \"created_at\": \"2025-05-02 07:25:24\", \"finalised_at\": \"2025-05-02T07:25:27.000000Z\", \"transaction_type\": \"business_buy_goods\", \"vendor_reference\": \"TE262QJ2V6\", \"silkpesa_reference\": \"SIL-1746170724-160\", \"receiver_description\": null}',NULL,'TE262QJ2V6',NULL,NULL),('faf31110-0c37-4784-ac26-dc65001684d0',9,NULL,5000,'KES',NULL,NULL,NULL,'succeeded','2025-02-02 04:44:49','2025-02-02 04:44:49','VOUCHER','c2b','voucher','',NULL,NULL,NULL,NULL,NULL,NULL),('fb021417-af70-4fdd-ae0d-3f82b2716c1a',9,NULL,1500,'KES',NULL,NULL,NULL,'succeeded','2025-03-03 04:21:35','2025-03-03 04:21:42','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 1500, \"msisdn\": \"254721812719\", \"reference\": \"personal\", \"merchant_id\": \"5141482\"}','{\"amount\": \"1500\", \"msisdn\": \"254721812719\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"personal\", \"created_at\": \"2025-03-03 07:21:37\", \"finalised_at\": \"2025-03-03T07:21:39.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TC326LVS56\", \"silkpesa_reference\": \"SIL-1740986497-479\", \"receiver_description\": \"254721812719 - MOHAMED ADAN\"}',NULL,'TC326LVS56','254721812719 - MOHAMED ADAN',NULL),('fb1f3fab-4ada-4d89-aca8-4ab37e24497a',9,NULL,2000,'KES',NULL,NULL,NULL,'succeeded','2025-03-26 07:18:13','2025-03-26 07:18:19','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 2000, \"msisdn\": \"254721812719\", \"reference\": \"water\", \"merchant_id\": \"5141482\"}','{\"amount\": \"2000\", \"msisdn\": \"254721812719\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"water\", \"created_at\": \"2025-03-26 07:18:13\", \"finalised_at\": \"2025-03-26T07:18:17.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TCQ95IAFAV\", \"silkpesa_reference\": \"SIL-1742973493-474\", \"receiver_description\": \"254721812719 - MOHAMED ADAN\"}',NULL,'TCQ95IAFAV','254721812719 - MOHAMED ADAN',NULL),('fb2df0f7-05c6-4ad9-a1d9-477602bcdcfe',9,NULL,610,'KES',NULL,NULL,NULL,'succeeded','2025-06-02 21:13:15','2025-06-02 21:13:22','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 610, \"msisdn\": \"254729526377\", \"reference\": \"fare\", \"merchant_id\": \"5141482\"}','{\"amount\": \"610\", \"msisdn\": \"254729526377\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"fare\", \"created_at\": \"2025-06-02 18:13:15\", \"finalised_at\": \"2025-06-02T18:13:19.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TF23A5DYDN\", \"silkpesa_reference\": \"SIL-1748887995-603\", \"receiver_description\": \"254729526377 - PATRICK MAKUNO\"}',NULL,'TF23A5DYDN','254729526377 - PATRICK MAKUNO',NULL),('fb321e52-211a-4ffc-9bf8-bf6945ef136f',28,'6877ADB9-FFF6-43AC-8889-38EC50302D28',1,'KES','{\"Result\": \"000\", \"TransRef\": \"R63198363\", \"TransToken\": \"6877ADB9-FFF6-43AC-8889-38EC50302D28\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'new','2024-12-06 09:12:05','2024-12-06 09:12:05','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('fb375845-c776-46ca-981e-a4e3de17666f',24,NULL,2000,'KES',NULL,NULL,NULL,'succeeded','2025-05-07 00:44:49','2025-05-07 00:44:56','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 2000, \"msisdn\": \"254759937432\", \"reference\": \"Ali\", \"merchant_id\": \"5141482\"}','{\"amount\": \"2000\", \"msisdn\": \"254759937432\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"Ali\", \"created_at\": \"2025-05-06 21:44:49\", \"finalised_at\": \"2025-05-06T21:44:53.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TE74PBXBDQ\", \"silkpesa_reference\": \"SIL-1746567889-247\", \"receiver_description\": \"254759937432 - ALI HUSSEIN HASSAN\"}',NULL,'TE74PBXBDQ','254759937432 - ALI HUSSEIN HASSAN',NULL),('fb4a2269-83b4-4f86-9f71-b85412f5a260',9,NULL,25,'KES',NULL,NULL,NULL,'succeeded','2024-12-26 11:05:13','2024-12-26 11:05:13','MPESA','b2c',NULL,'','{\"Amount\": \"25\", \"PartyA\": \"5141482\", \"PartyB\": \"254706047540\", \"Remarks\": \"test\", \"CommandID\": \"BusinessPayment\", \"Occassion\": \"test\", \"ResultURL\": \"https://app.safaribucks.com/api/mpesa/business_to_customer/result\", \"InitiatorName\": \"gloclienapiuser\", \"QueueTimeOutURL\": \"https://app.safaribucks.com/api/mpesa/business_to_customer/result\", \"SecurityCredential\": \"Az7s67buCa2qUIBDi5PDNJgs152YtZKzqghs/7AYw+EJJaloHedS8Q/VGpVnKCkobk0fInccdzfTrIv+Oxpyab+pRL13Z0GwyW61v67/ywUFq55CtHl1Wl332oYL70B1Pusbke5rdHaYwl8oQR/C6OPNiPexU2RgYL5B37Ew5PPILwj6VNIf9OfMrbNLrsDj+bCLn10UOFiG2Go3zgYzxuQAFCWIY412S2upGYOD+/PgBu2I0GrQMAJf5IRQH/3Mg3DUevi7vKtTSXG7qLvKKEpIHa2ngNJ50/72xf5GXU2jzehVdNGe+qXeiuBVUkZr6SUWnU3FPpYw67/SAI1yoQ==\", \"OriginatorConversationID\": \"fb4a2269-83b4-4f86-9f71-b85412f5a260\"}','{\"Result\": {\"ResultCode\": 0, \"ResultDesc\": \"The service request is processed successfully.\", \"ResultType\": 0, \"ReferenceData\": {\"ReferenceItem\": {\"Key\": \"QueueTimeoutURL\", \"Value\": \"http://internalapi.safaricom.co.ke/mpesa/b2cresults/v1/submit\"}}, \"TransactionID\": \"SLQ8X4GTII\", \"ConversationID\": \"AG_20241226_2070556804ae8fc9febd\", \"ResultParameters\": {\"ResultParameter\": [{\"Key\": \"TransactionAmount\", \"Value\": 25}, {\"Key\": \"TransactionReceipt\", \"Value\": \"SLQ8X4GTII\"}, {\"Key\": \"ReceiverPartyPublicName\", \"Value\": \"254706047540 - ABDI KORANE\"}, {\"Key\": \"TransactionCompletedDateTime\", \"Value\": \"26.12.2024 17:05:13\"}, {\"Key\": \"B2CUtilityAccountAvailableFunds\", \"Value\": 4896}, {\"Key\": \"B2CWorkingAccountAvailableFunds\", \"Value\": 651}, {\"Key\": \"B2CRecipientIsRegisteredCustomer\", \"Value\": \"Y\"}, {\"Key\": \"B2CChargesPaidAccountAvailableFunds\", \"Value\": 0}]}, \"OriginatorConversationID\": \"fb4a2269-83b4-4f86-9f71-b85412f5a260\"}}',NULL,NULL,NULL,NULL),('fb565c43-e27b-403b-b722-b53b85454211',9,NULL,450,'KES',NULL,NULL,NULL,'accepted','2025-10-01 20:37:41','2025-10-01 20:37:41','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 450, \"msisdn\": \"254721812719\", \"reference\": \"test\", \"merchant_id\": \"5141482\"}',NULL,NULL,NULL,NULL,NULL),('fb66f2ea-ebbb-4cb0-a360-096fcee35218',22,NULL,400,'KES',NULL,NULL,NULL,'succeeded','2025-05-16 18:32:55','2025-05-16 18:33:00','MPESA','b2b','buy_goods','','{\"type\": \"business_buy_goods\", \"amount\": 400, \"msisdn\": \"8614762\", \"reference\": \"food\", \"merchant_id\": \"5141482\"}','{\"amount\": \"400\", \"msisdn\": \"8614762\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"food\", \"created_at\": \"2025-05-16 15:32:55\", \"finalised_at\": \"2025-05-16T15:32:57.000000Z\", \"transaction_type\": \"business_buy_goods\", \"vendor_reference\": \"TEG3ZDNW0P\", \"silkpesa_reference\": \"SIL-1747409575-512\", \"receiver_description\": null}',NULL,'TEG3ZDNW0P',NULL,NULL),('fb70bf03-440e-4763-8cae-7c74ea9a5586',9,'185445B9-EC68-459A-B397-6FB125B46989',3,'USD','{\"Result\": \"000\", \"TransRef\": \"R62851031\", \"TransToken\": \"185445B9-EC68-459A-B397-6FB125B46989\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'new','2024-11-25 18:42:53','2024-11-25 18:42:53','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('fb75833f-0aa5-4ad4-888b-caa8511a02fa',9,'D5BF1E0F-7887-467A-A805-833FBEB2571C',12,'USD','{\"Result\": \"000\", \"TransRef\": \"R66411625\", \"TransToken\": \"D5BF1E0F-7887-467A-A805-833FBEB2571C\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'new','2025-03-24 08:02:00','2025-03-24 08:02:00','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('fb9c399b-028f-44ff-a9be-6cb3ce133453',9,NULL,25,'KES',NULL,NULL,NULL,'succeeded','2025-09-19 21:10:54','2025-09-19 21:11:01','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 25, \"msisdn\": \"254790221260\", \"reference\": \"food\", \"merchant_id\": \"5141482\"}','{\"amount\": \"25\", \"msisdn\": \"254790221260\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"food\", \"created_at\": \"2025-09-19 18:10:54\", \"finalised_at\": \"2025-09-19T18:10:58.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TIJ8O7QACY\", \"silkpesa_reference\": \"SIL-1758305454-840\", \"receiver_description\": \"0790221260 - MERCY WANGARI NJERI\"}',NULL,'TIJ8O7QACY','0790221260 - MERCY WANGARI NJERI',NULL),('fbe4349a-1749-497d-90bc-27b5e3e6590d',71,NULL,4300,'KES',NULL,NULL,NULL,'failed','2025-04-23 10:24:31','2025-04-23 10:24:37','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 4300, \"msisdn\": \"254727330366\", \"reference\": \"lodge\", \"merchant_id\": \"5141482\"}','{\"amount\": \"4300\", \"msisdn\": \"254727330366\", \"status\": \"FAILED\", \"channel\": \"KE.MPESA\", \"reference\": \"lodge\", \"created_at\": \"2025-04-23 10:24:31\", \"finalised_at\": \"2025-04-23T10:24:34.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": null, \"silkpesa_reference\": \"SIL-1745403871-750\", \"receiver_description\": null}',NULL,NULL,NULL,NULL),('fbee775c-47f6-4a44-8f53-70151265e2d3',9,NULL,650,'KES',NULL,NULL,NULL,'succeeded','2025-10-11 13:40:53','2025-10-11 13:41:00','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 650, \"msisdn\": \"254721812719\", \"reference\": \"tests\", \"merchant_id\": \"5141482\"}','{\"amount\": \"650\", \"msisdn\": \"254721812719\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"currency\": \"KES\", \"reference\": \"tests\", \"created_at\": \"2025-10-11 10:40:53\", \"finalised_at\": \"2025-10-11T10:40:57.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TJB6475QJ2\", \"silkpesa_reference\": \"SIL-1760179253-643\", \"receiver_description\": \"254721812719 - MOHAMED ADAN\"}',NULL,'TJB6475QJ2','254721812719 - MOHAMED ADAN',NULL),('fbf0832e-20b5-453f-84f3-afaf15e96e44',53,'90FA0D2A-0B97-4A6D-B45A-37396815E5BB',100,'KES','{\"Result\": \"000\", \"TransRef\": \"R65614102\", \"TransToken\": \"90FA0D2A-0B97-4A6D-B45A-37396815E5BB\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'new','2025-02-26 12:52:07','2025-02-26 12:52:07','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('fc116da9-b8a8-43f6-bb3b-7af0a77826c0',9,NULL,2000,'KES',NULL,NULL,NULL,'succeeded','2025-05-15 16:57:41','2025-05-15 16:57:48','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 2000, \"msisdn\": \"254792390409\", \"reference\": \"food\", \"merchant_id\": \"5141482\"}','{\"amount\": \"2000\", \"msisdn\": \"254792390409\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"food\", \"created_at\": \"2025-05-15 13:57:41\", \"finalised_at\": \"2025-05-15T13:57:46.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TEF8U40FWM\", \"silkpesa_reference\": \"SIL-1747317461-214\", \"receiver_description\": \"0792390409 - nasra osman adan\"}',NULL,'TEF8U40FWM','0792390409 - nasra osman adan',NULL),('fc1a8d6e-02d6-4f75-8ae7-cda1aa667145',9,'7AF46546-0760-413B-BE47-E6A981C007A6',100,'KES','{\"Result\": \"000\", \"TransRef\": \"R65565490\", \"TransToken\": \"7AF46546-0760-413B-BE47-E6A981C007A6\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'new','2025-02-25 05:14:41','2025-02-25 05:14:41','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('fc2bab08-7b01-4da7-bc82-aa7606fc818b',9,NULL,24152,'KES',NULL,NULL,NULL,'succeeded','2025-07-04 14:34:03','2025-07-04 14:34:08','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 24152, \"msisdn\": \"254726077499\", \"reference\": \"afripesa\", \"merchant_id\": \"5141482\"}','{\"amount\": \"24152\", \"msisdn\": \"254726077499\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"afripesa\", \"created_at\": \"2025-07-04 11:34:03\", \"finalised_at\": \"2025-07-04T11:34:06.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TG40KJHTNC\", \"silkpesa_reference\": \"SIL-1751628843-210\", \"receiver_description\": \"254726077499 - Alfred Habib Haggar\"}',NULL,'TG40KJHTNC','254726077499 - Alfred Habib Haggar',NULL),('fc2ec0a8-8dd7-45ed-b976-466d2dc4fc10',94,NULL,10000,'KES',NULL,NULL,NULL,'failed','2025-08-28 17:52:06','2025-08-28 17:52:12','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 10000, \"msisdn\": \"254758300740\", \"reference\": \"Medical for client\", \"merchant_id\": \"5141482\"}','{\"amount\": \"10000\", \"msisdn\": \"254758300740\", \"status\": \"FAILED\", \"channel\": \"KE.MPESA\", \"reference\": \"Medical for client\", \"created_at\": \"2025-08-28 14:52:06\", \"finalised_at\": \"2025-08-28T14:52:09.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": null, \"silkpesa_reference\": \"SIL-1756392726-454\", \"receiver_description\": null}',NULL,NULL,NULL,NULL),('fc69a30c-2895-436f-8587-99392ef7d10d',23,'5218F93F-2A21-460C-B28C-3CE5A5F9A531',10,'USD','{\"Result\": \"000\", \"TransRef\": \"R66743663\", \"TransToken\": \"5218F93F-2A21-460C-B28C-3CE5A5F9A531\", \"ResultExplanation\": \"Transaction created\"}','{\"pnrID\": \"XZEMAU\", \"transID\": \"5218F93F-2A21-460C-B28C-3CE5A5F9A531\", \"companyRef\": \"XZEMAU\", \"ccdApproval\": \"046172\", \"transactionToken\": \"5218F93F-2A21-460C-B28C-3CE5A5F9A531\"}','{\"AccRef\": {}, \"Result\": \"000\", \"FraudAlert\": \"001\", \"CustomerZip\": \"00101\", \"CustomerCity\": \"Nairobi\", \"CustomerName\": \"Athman Mwatondo\", \"CustomerPhone\": \"721579276\", \"CustomerCredit\": \"1296\", \"CustomerAddress\": \"Madaraka\", \"CustomerCountry\": \"Kenya\", \"FraudExplnation\": \"Low Risk (Not checked)\", \"ResultExplanation\": \"Transaction Paid\", \"TransactionAmount\": \"10.00\", \"CustomerCreditType\": \"VISA\", \"TransactionApproval\": \"046172\", \"TransactionCurrency\": \"USD\", \"MobilePaymentRequest\": \"Not sent\", \"TransactionNetAmount\": \"0.00\", \"TransactionFinalAmount\": \"10.00\", \"TransactionFinalCurrency\": \"USD\", \"TransactionSettlementDate\": \"2025/04/02\", \"TransactionRollingReserveDate\": {}, \"TransactionRollingReserveAmount\": \"0.00\"}','succeeded','2025-04-02 19:41:50','2025-04-02 19:45:27','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('fcea7fdb-d4be-4077-aa88-821e43821881',9,NULL,1000,'KES',NULL,NULL,NULL,'succeeded','2025-04-18 16:29:56','2025-04-18 16:30:03','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 1000, \"msisdn\": \"254721812719\", \"reference\": \"fuel\", \"merchant_id\": \"5141482\"}','{\"amount\": \"1000\", \"msisdn\": \"254721812719\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"fuel\", \"created_at\": \"2025-04-18 16:29:56\", \"finalised_at\": \"2025-04-18T16:30:01.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TDI1B4NMUB\", \"silkpesa_reference\": \"SIL-1744993796-125\", \"receiver_description\": \"254721812719 - MOHAMED ADAN\"}',NULL,'TDI1B4NMUB','254721812719 - MOHAMED ADAN',NULL),('fceaa664-9daf-4c81-bb7d-27d4178021e8',71,NULL,500,'KES',NULL,NULL,NULL,'succeeded','2025-05-03 12:54:41','2025-05-03 12:54:49','MPESA','b2b','buy_goods','','{\"type\": \"business_buy_goods\", \"amount\": 500, \"msisdn\": \"4549464\", \"reference\": \"lunch\", \"merchant_id\": \"5141482\"}','{\"amount\": \"500\", \"msisdn\": \"4549464\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"lunch\", \"created_at\": \"2025-05-03 09:54:41\", \"finalised_at\": \"2025-05-03T09:54:46.000000Z\", \"transaction_type\": \"business_buy_goods\", \"vendor_reference\": \"TE3189AMGL\", \"silkpesa_reference\": \"SIL-1746266081-314\", \"receiver_description\": null}',NULL,'TE3189AMGL',NULL,NULL),('fceded32-316d-4443-b425-21d30c571122',9,NULL,1500,'KES',NULL,NULL,NULL,'succeeded','2025-05-03 17:05:01','2025-05-03 17:05:07','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 1500, \"msisdn\": \"254792390409\", \"reference\": \"home\", \"merchant_id\": \"5141482\"}','{\"amount\": \"1500\", \"msisdn\": \"254792390409\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"home\", \"created_at\": \"2025-05-03 14:05:02\", \"finalised_at\": \"2025-05-03T14:05:04.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TE359F90XT\", \"silkpesa_reference\": \"SIL-1746281102-189\", \"receiver_description\": \"0792390409 - nasra osman adan\"}',NULL,'TE359F90XT','0792390409 - nasra osman adan',NULL),('fcf7b53e-3f35-4f98-b268-49119b656e41',60,'EA2D9A88-9E48-4613-A1A6-41955F84D0AE',1,'KES','{\"Result\": \"000\", \"TransRef\": \"R66480555\", \"TransToken\": \"EA2D9A88-9E48-4613-A1A6-41955F84D0AE\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'new','2025-03-26 07:04:12','2025-03-26 07:04:12','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('fcfe3f92-7092-4c21-b0f5-3e221c41a464',9,NULL,210,'KES',NULL,NULL,NULL,'succeeded','2025-03-25 21:37:53','2025-03-25 21:38:00','MPESA','b2b','paybill','','{\"type\": \"b2b\", \"amount\": 210, \"msisdn\": \"4029369\", \"reference\": \"medicine\", \"merchant_id\": \"5141482\"}','{\"amount\": \"210\", \"msisdn\": \"4029369\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"medicine\", \"created_at\": \"2025-03-25 21:37:53\", \"finalised_at\": \"2025-03-25T21:37:58.000000Z\", \"transaction_type\": \"b2b\", \"vendor_reference\": \"TCQ04N9BT4\", \"silkpesa_reference\": \"SIL-1742938673-695\", \"receiver_description\": \"4029369 - PHARMAPLUS PHARMACEUTICALS LTD 3.\"}',NULL,'TCQ04N9BT4','4029369 - PHARMAPLUS PHARMACEUTICALS LTD 3.',NULL),('fd04a737-0b24-4870-ba20-18d0a70f1da0',59,'F9A92BD5-5A76-4B3B-90AD-ADB27514C1E7',10,'KES','{\"Result\": \"000\", \"TransRef\": \"R66013063\", \"TransToken\": \"F9A92BD5-5A76-4B3B-90AD-ADB27514C1E7\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'new','2025-03-10 17:46:23','2025-03-10 17:46:23','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('fd06c067-e50a-4b7c-b4db-e7a1b927dd52',9,NULL,10,'KES',NULL,NULL,NULL,'succeeded','2025-05-06 09:56:07','2025-05-06 10:41:43','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 10, \"msisdn\": \"254721812719\", \"reference\": \"term\", \"merchant_id\": \"5141482\"}','{\"amount\": \"10\", \"msisdn\": \"254721812719\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"term\", \"created_at\": \"2025-05-06 06:56:07\", \"finalised_at\": \"2025-05-06T07:41:37.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TE69LO6ZIF\", \"silkpesa_reference\": \"SIL-1746514567-941\", \"receiver_description\": \"254721812719 - MOHAMED ADAN\"}',NULL,'TE69LO6ZIF','254721812719 - MOHAMED ADAN',NULL),('fd08b421-486e-48ec-bf9a-d82c80ddd976',60,'F4FF569C-46D6-4CEC-925B-C0B6098BA603',1,'KES','{\"Result\": \"000\", \"TransRef\": \"R66625697\", \"TransToken\": \"F4FF569C-46D6-4CEC-925B-C0B6098BA603\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'new','2025-03-30 12:05:32','2025-03-30 12:05:32','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('fd0e1bb8-b4bf-4a13-b7e0-53a0d693d989',99,NULL,800,'KES',NULL,NULL,NULL,'succeeded','2025-10-10 16:00:25','2025-10-10 16:00:32','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 800, \"msisdn\": \"254792097572\", \"reference\": \"Pizza\", \"merchant_id\": \"5141482\"}','{\"amount\": \"800\", \"msisdn\": \"254792097572\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"currency\": \"KES\", \"reference\": \"Pizza\", \"created_at\": \"2025-10-10 13:00:25\", \"finalised_at\": \"2025-10-10T13:00:30.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TJAHQ73702\", \"silkpesa_reference\": \"SIL-1760101225-603\", \"receiver_description\": \"254792097572 - FRANCIS MURIUKI\"}',NULL,'TJAHQ73702','254792097572 - FRANCIS MURIUKI',NULL),('fd6fc0ba-61cd-4eaf-a10f-4e91bb0937a4',37,NULL,19600,'KES',NULL,NULL,NULL,'failed','2025-02-06 14:18:33','2025-02-06 14:18:33','MPESA','b2b','paybill','','{\"Amount\": \"19600\", \"PartyA\": \"5141482\", \"PartyB\": \"737700\", \"Remarks\": \"Payment for Booking Reference / PNR S3M6FV\", \"CommandID\": \"BusinessPayBill\", \"Initiator\": \"gloclienapiuser\", \"Requester\": \"\", \"ResultURL\": \"https://app.safaribucks.com/api/mpesa/business_pay_bill/result\", \"QueueTimeOutURL\": \"https://app.safaribucks.com/api/mpesa/business_pay_bill/result\", \"AccountReference\": \"Payment for Booking Reference / PNR S3M6FV\", \"SecurityCredential\": \"gKtqGaWZpTxWo2Pq7Uw5rSOGHGCibnRv7xzZg+ab60DQyCtflLrc1bvLRnpLpx+8FUxvEHgXAxh8Tr8QiNCc8mhn4nDuIK2qtcsk+3xZ91IlAErn9mQWDsLcCf7Z980wUBDNXG38m71lSoM+IebFkfcYOgt3h8JBHCZ1TIPQJRq0dRt52R2HPnosr8TO6k1GNClbRpjSTIpc/0SWSxA/VUOKruyBfYnVyuEbnGMGaGPDcsdeVYpHQj3Z8ygPFMagQMhVPlND54o//skLMx+p9v6oa43ZG4bbFBbEVQ80xcIrb/bPxe1dunzCSko0a8FL/cmR3pNNe2GWscp3Nzqw1w==\", \"SenderIdentifierType\": \"4\", \"RecieverIdentifierType\": \"4\", \"OriginatorConversationID\": \"fd6fc0ba-61cd-4eaf-a10f-4e91bb0937a4\"}',NULL,NULL,NULL,NULL,NULL),('fd79d102-214c-4e08-bc94-26a65e9f3fc7',9,'3D9186D8-2A12-4EEE-AE44-93A139BDABF1',10,'USD','{\"Result\": \"000\", \"TransRef\": \"R62195200\", \"TransToken\": \"3D9186D8-2A12-4EEE-AE44-93A139BDABF1\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'new','2024-11-04 13:35:54','2024-11-04 13:35:54','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('fd7ef63e-c22d-4627-bb0a-3f6317d4dad6',24,'F5E33B50-8266-4ADE-B09A-F487D211E1F2',100,'KES','{\"Result\": \"000\", \"TransRef\": \"R67332294\", \"TransToken\": \"F5E33B50-8266-4ADE-B09A-F487D211E1F2\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'accepted','2025-04-22 11:46:14','2025-04-22 11:46:14','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('fd81fc23-a06b-4c3a-a97b-708350a1d807',9,NULL,77100,'KES',NULL,NULL,NULL,'succeeded','2025-03-03 10:53:01','2025-03-03 10:53:13','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 77100, \"msisdn\": \"254711722210\", \"reference\": \"afripesa\", \"merchant_id\": \"5141482\"}','{\"amount\": \"77100\", \"msisdn\": \"254711722210\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"afripesa\", \"created_at\": \"2025-03-03 13:53:07\", \"finalised_at\": \"2025-03-03T13:53:10.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TC328CRRXA\", \"silkpesa_reference\": \"SIL-1741009987-537\", \"receiver_description\": \"254711722210 - ABDIRAUF SHARIF OSMAN\"}',NULL,'TC328CRRXA','254711722210 - ABDIRAUF SHARIF OSMAN',NULL),('fd8caee6-d8eb-4236-bcc1-75981a70eba0',104,NULL,6500,'KES',NULL,NULL,NULL,'accepted','2025-11-05 21:58:09','2025-11-05 21:58:09','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 6500, \"msisdn\": \"254726901668\", \"reference\": \"pay\", \"merchant_id\": \"5141482\"}',NULL,NULL,NULL,NULL,NULL),('fd9835fb-2d55-44b6-b3ca-f8ba56c65f8b',9,NULL,10001,'KES',NULL,NULL,NULL,'failed','2025-04-08 14:19:59','2025-04-08 14:20:05','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 10001, \"msisdn\": \"254792390409\", \"reference\": \"food\", \"merchant_id\": \"5141482\"}','{\"amount\": \"10001\", \"msisdn\": \"254792390409\", \"status\": \"FAILED\", \"channel\": \"KE.MPESA\", \"reference\": \"food\", \"created_at\": \"2025-04-08 14:20:00\", \"finalised_at\": \"2025-04-08T14:20:02.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": null, \"silkpesa_reference\": \"SIL-1744122000-449\", \"receiver_description\": null}',NULL,NULL,NULL,NULL),('fdd9e982-e0b4-43a7-8492-5ed994f415dc',71,NULL,530,'KES',NULL,NULL,NULL,'succeeded','2025-05-04 19:10:26','2025-05-04 19:10:31','MPESA','b2b','buy_goods','','{\"type\": \"business_buy_goods\", \"amount\": 530, \"msisdn\": \"4549464\", \"reference\": \"fruits\", \"merchant_id\": \"5141482\"}','{\"amount\": \"530\", \"msisdn\": \"4549464\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"fruits\", \"created_at\": \"2025-05-04 16:10:26\", \"finalised_at\": \"2025-05-04T16:10:29.000000Z\", \"transaction_type\": \"business_buy_goods\", \"vendor_reference\": \"TE40ES90K4\", \"silkpesa_reference\": \"SIL-1746375026-891\", \"receiver_description\": null}',NULL,'TE40ES90K4',NULL,NULL),('fe2c3a5b-0d4b-4d66-9bea-3e9fc44663c5',9,'D70CB899-DAEA-4828-848C-8AD80F53B5AE',2,'USD','{\"Result\": \"000\", \"TransRef\": \"R67748881\", \"TransToken\": \"D70CB899-DAEA-4828-848C-8AD80F53B5AE\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'accepted','2025-05-05 13:13:26','2025-05-05 13:13:26','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('fe4204e4-2d6a-491e-b366-bfc4f0d5597b',9,NULL,93500,'KES',NULL,NULL,NULL,'succeeded','2025-05-08 17:10:26','2025-05-08 17:10:26','VOUCHER','c2b','voucher','',NULL,NULL,NULL,NULL,NULL,NULL),('fe448de5-7476-471a-b807-2e7313755752',22,'40E2A6B7-0FEA-4B4B-BC42-FDA053814905',20,'USD','{\"Result\": \"000\", \"TransRef\": \"R68100767\", \"TransToken\": \"40E2A6B7-0FEA-4B4B-BC42-FDA053814905\", \"ResultExplanation\": \"Transaction created\"}','{\"pnrID\": \"XZEMAU\", \"transID\": \"40E2A6B7-0FEA-4B4B-BC42-FDA053814905\", \"companyRef\": \"XZEMAU\", \"ccdApproval\": \"25LNI9\", \"transactionToken\": \"40E2A6B7-0FEA-4B4B-BC42-FDA053814905\"}','{\"AccRef\": {}, \"Result\": \"000\", \"FraudAlert\": \"001\", \"CustomerZip\": \"40214\", \"CustomerCity\": \"Louisville\", \"CustomerName\": \"Salah Osman Adan\", \"CustomerPhone\": \"13083786566\", \"CustomerCredit\": \"172\", \"CustomerAddress\": \"1113 Royal Gardens Ct Apt 7\", \"CustomerCountry\": \"United States of America\", \"FraudExplnation\": \"Low Risk (Not checked)\", \"ResultExplanation\": \"Transaction Paid\", \"TransactionAmount\": \"20.00\", \"CustomerCreditType\": \"MASC\", \"TransactionApproval\": \"25LNI9\", \"TransactionCurrency\": \"USD\", \"MobilePaymentRequest\": \"Not sent\", \"TransactionNetAmount\": \"0.00\", \"TransactionFinalAmount\": \"20.00\", \"TransactionFinalCurrency\": \"USD\", \"TransactionSettlementDate\": \"2025/05/16\", \"TransactionRollingReserveDate\": {}, \"TransactionRollingReserveAmount\": \"0.00\"}','succeeded','2025-05-16 18:30:49','2025-05-16 18:32:26','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('fe4ff654-f7d1-4134-b930-45bc57379d7c',9,NULL,1902,'KES',NULL,NULL,NULL,'succeeded','2025-03-30 18:37:07','2025-03-30 18:37:13','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 1902, \"msisdn\": \"254712514454\", \"reference\": \"afripesa\", \"merchant_id\": \"5141482\"}','{\"amount\": \"1902\", \"msisdn\": \"254712514454\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"afripesa\", \"created_at\": \"2025-03-30 18:37:07\", \"finalised_at\": \"2025-03-30T18:37:11.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TCU7R6EM49\", \"silkpesa_reference\": \"SIL-1743359827-375\", \"receiver_description\": \"0712514454 - clement   ombima\"}',NULL,'TCU7R6EM49','0712514454 - clement   ombima',NULL),('fe584961-a8e3-4419-81f3-2d53cd33a4e7',9,NULL,432,'KES',NULL,NULL,NULL,'succeeded','2025-06-22 15:41:24','2025-06-22 15:41:31','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 432, \"msisdn\": \"254111756596\", \"reference\": \"afripesa\", \"merchant_id\": \"5141482\"}','{\"amount\": \"432\", \"msisdn\": \"254111756596\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"afripesa\", \"created_at\": \"2025-06-22 12:41:24\", \"finalised_at\": \"2025-06-22T12:41:28.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TFM3WMAQHB\", \"silkpesa_reference\": \"SIL-1750596084-272\", \"receiver_description\": \"254111756596 - MAXON KOMBE WASHE\"}',NULL,'TFM3WMAQHB','254111756596 - MAXON KOMBE WASHE',NULL),('fe6b07e7-fb2f-497d-ac8d-829a9f2324ca',71,NULL,120,'KES',NULL,NULL,NULL,'succeeded','2025-05-03 13:32:37','2025-05-03 13:32:43','MPESA','b2b','buy_goods','','{\"type\": \"business_buy_goods\", \"amount\": 120, \"msisdn\": \"4549464\", \"reference\": \"boyo\", \"merchant_id\": \"5141482\"}','{\"amount\": \"120\", \"msisdn\": \"4549464\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"boyo\", \"created_at\": \"2025-05-03 10:32:37\", \"finalised_at\": \"2025-05-03T10:32:40.000000Z\", \"transaction_type\": \"business_buy_goods\", \"vendor_reference\": \"TE398FHKIL\", \"silkpesa_reference\": \"SIL-1746268357-785\", \"receiver_description\": null}',NULL,'TE398FHKIL',NULL,NULL),('fe95f3f9-c365-42ca-96aa-142823a9c8a6',60,'929C9ECE-5BF8-4BC0-AE9D-978EFADEEA05',1,'KES','{\"Result\": \"000\", \"TransRef\": \"R66419630\", \"TransToken\": \"929C9ECE-5BF8-4BC0-AE9D-978EFADEEA05\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'new','2025-03-24 12:13:53','2025-03-24 12:13:53','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('fe9fe482-7342-490a-ad8d-32810da64fa3',1,NULL,10,'KES',NULL,NULL,NULL,'succeeded','2025-02-16 13:09:20','2025-10-03 13:58:57','MPESA','b2b','paybill','','{\"type\": \"b2b\", \"amount\": 10, \"msisdn\": \"4148053\", \"reference\": \"test\", \"merchant_id\": \"5141482\"}','{\"amount\": \"10.00\", \"msisdn\": \"eccfb5366d3f0301288fdc1592e2538bc9d13652bf9679d0e7a6717ae5bd4fc4\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"currency\": \"KES\", \"reference\": \"test\", \"created_at\": \"2025-02-16 16:09:20\", \"finalised_at\": \"2025-10-03T10:58:55.000000Z\", \"transaction_type\": \"b2b\", \"vendor_reference\": \"TJ3D06DDSJ\", \"silkpesa_reference\": \"SIL-1739722160-547\", \"receiver_description\": null}',NULL,'TJ3D06DDSJ',NULL,NULL),('feb219dd-6887-4130-b383-4468593fef58',24,NULL,3350,'KES',NULL,NULL,NULL,'succeeded','2025-01-21 09:48:57','2025-01-21 09:48:58','MPESA','b2c',NULL,'','{\"Amount\": \"3350\", \"PartyA\": \"5141482\", \"PartyB\": \"254759937432\", \"Remarks\": \"Ali\", \"CommandID\": \"BusinessPayment\", \"Occassion\": \"Ali\", \"ResultURL\": \"https://app.safaribucks.com/api/mpesa/business_to_customer/result\", \"InitiatorName\": \"gloclienapiuser\", \"QueueTimeOutURL\": \"https://app.safaribucks.com/api/mpesa/business_to_customer/result\", \"SecurityCredential\": \"B8GlV4Tz3m9DSG04+d7jj/pYgJGdiiaY1X484MZ9k5YwwQvrdzAvypGJhA7qs0qYb/JtUc9JqI2Kk9uoZMyWSqGsr/d0Wg1Vnwh3m5Gqznd3c0w7TgpGYgO4xLBZiMrB3/jSWN8oy+oK40vcAGQSAOhrQ65p9fABkWTlmmKMdwDPhczTedNCLk6zIymweDyKU8MW7sRoWz29iGlOoukog5LaBvfbUjnsoccak1DTkN34SHikVSBESXrWb+2STDbxgC4KTsyz9UR8CxMJsaSdBXcF6bX7G8b6MVrtyhs381sgzh8gNO64X8Cr7P3zKgT+EIiFwgV+gIsVjn9ax2W+/A==\", \"OriginatorConversationID\": \"feb219dd-6887-4130-b383-4468593fef58\"}','{\"Result\": {\"ResultCode\": 0, \"ResultDesc\": \"The service request is processed successfully.\", \"ResultType\": 0, \"ReferenceData\": {\"ReferenceItem\": {\"Key\": \"QueueTimeoutURL\", \"Value\": \"http://internalapi.safaricom.co.ke/mpesa/b2cresults/v1/submit\"}}, \"TransactionID\": \"TAL4ZDL19U\", \"ConversationID\": \"AG_20250121_205077e700c32ae4038a\", \"ResultParameters\": {\"ResultParameter\": [{\"Key\": \"TransactionAmount\", \"Value\": 3350}, {\"Key\": \"TransactionReceipt\", \"Value\": \"TAL4ZDL19U\"}, {\"Key\": \"ReceiverPartyPublicName\", \"Value\": \"254759937432 - ALI HUSSEIN HASSAN\"}, {\"Key\": \"TransactionCompletedDateTime\", \"Value\": \"21.01.2025 15:48:58\"}, {\"Key\": \"B2CUtilityAccountAvailableFunds\", \"Value\": 9156}, {\"Key\": \"B2CWorkingAccountAvailableFunds\", \"Value\": 496}, {\"Key\": \"B2CRecipientIsRegisteredCustomer\", \"Value\": \"Y\"}, {\"Key\": \"B2CChargesPaidAccountAvailableFunds\", \"Value\": 0}]}, \"OriginatorConversationID\": \"feb219dd-6887-4130-b383-4468593fef58\"}}',NULL,NULL,NULL,NULL),('fec8ac01-e8d3-4d77-beab-b4d89e8028c4',22,'3D65770C-0E87-4F40-BA48-5255186A07BE',3,'USD','{\"Result\": \"000\", \"TransRef\": \"R63050989\", \"TransToken\": \"3D65770C-0E87-4F40-BA48-5255186A07BE\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'new','2024-12-01 17:34:31','2024-12-01 17:34:31','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('fee6fce7-595e-4867-bd47-d0252d51f50c',25,NULL,15000,'KES',NULL,NULL,NULL,'succeeded','2025-02-27 15:29:22','2025-02-27 15:29:28','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 15000, \"msisdn\": \"254712230653\", \"reference\": \"Family support\", \"merchant_id\": \"5141482\"}','{\"amount\": \"15000\", \"msisdn\": \"254712230653\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"Family support\", \"created_at\": \"2025-02-27 18:29:22\", \"finalised_at\": \"2025-02-27T18:29:25.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TBR8Q2Z0UK\", \"silkpesa_reference\": \"SIL-1740680962-915\", \"receiver_description\": \"254712230653 - EDWARD KITATI\"}',NULL,'TBR8Q2Z0UK','254712230653 - EDWARD KITATI',NULL),('ff4e5ef8-3f7f-46c9-8a94-0d70b3a1ba26',9,NULL,10,'KES',NULL,NULL,NULL,'succeeded','2025-08-26 18:17:10','2025-08-26 18:17:17','MPESA','b2b','paybill','','{\"type\": \"b2b\", \"amount\": 10, \"msisdn\": \"4081329\", \"reference\": \"testing\", \"merchant_id\": \"5141482\"}','{\"amount\": \"10\", \"msisdn\": \"4081329\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"testing\", \"created_at\": \"2025-08-26 15:17:10\", \"finalised_at\": \"2025-08-26T15:17:15.000000Z\", \"transaction_type\": \"b2b\", \"vendor_reference\": \"THQ22K3N5O\", \"silkpesa_reference\": \"SIL-1756221430-115\", \"receiver_description\": \"4081329 - HAYAAN SACCO\"}',NULL,'THQ22K3N5O','4081329 - HAYAAN SACCO',NULL),('ff62a678-500b-4ee8-9f2e-429f7b7d847b',24,NULL,900,'KES',NULL,NULL,NULL,'succeeded','2024-12-19 08:54:27','2024-12-19 08:54:27','MPESA','b2c',NULL,'','{\"Amount\": \"900\", \"PartyA\": \"5141482\", \"PartyB\": \"254759937432\", \"Remarks\": \"Ali\", \"CommandID\": \"BusinessPayment\", \"Occassion\": \"Ali\", \"ResultURL\": \"https://app.safaribucks.com/api/mpesa/business_to_customer/result\", \"InitiatorName\": \"gloclienapiuser\", \"QueueTimeOutURL\": \"https://app.safaribucks.com/api/mpesa/business_to_customer/result\", \"SecurityCredential\": \"nSQN6MzA+pgzfd8VWpKSS8PzXFv8uVgS2GCJmwscwGlqP3hXwYAijDAeMz1wYA3vSvC5i3W++0gfLyPeS7MOccMvxpixhBBt2msS3TV0U468fDcQ0T03CHXwUEBx6Gqheew65NpIWvjFoDv/4QNgl1QG5zjfxFPeq9q6/DQBWjBWYJ4mEYqBUfwSBPrfvQFj2Cvk8WZcV86d1w0rkiDh2giTD/0EAkR5Xcbow1mDaw/EFpJ+cKlbULYsU2+lPWNu+0noLxNkMQY+loaOicn+hVKBoZ5C5K3bHXTbBpv1y8gwrEreSwWsuOrDRLYb4BnaPxkqzAdVFyrIRB4gN0w8tQ==\", \"OriginatorConversationID\": \"ff62a678-500b-4ee8-9f2e-429f7b7d847b\"}','{\"Result\": {\"ResultCode\": 0, \"ResultDesc\": \"The service request is processed successfully.\", \"ResultType\": 0, \"ReferenceData\": {\"ReferenceItem\": {\"Key\": \"QueueTimeoutURL\", \"Value\": \"http://internalapi.safaricom.co.ke/mpesa/b2cresults/v1/submit\"}}, \"TransactionID\": \"SLJ42H7QCU\", \"ConversationID\": \"AG_20241219_203058a84d791509d387\", \"ResultParameters\": {\"ResultParameter\": [{\"Key\": \"TransactionAmount\", \"Value\": 900}, {\"Key\": \"TransactionReceipt\", \"Value\": \"SLJ42H7QCU\"}, {\"Key\": \"ReceiverPartyPublicName\", \"Value\": \"254759937432 - ALI HUSSEIN HASSAN\"}, {\"Key\": \"TransactionCompletedDateTime\", \"Value\": \"19.12.2024 14:54:27\"}, {\"Key\": \"B2CUtilityAccountAvailableFunds\", \"Value\": 1499}, {\"Key\": \"B2CWorkingAccountAvailableFunds\", \"Value\": 651}, {\"Key\": \"B2CRecipientIsRegisteredCustomer\", \"Value\": \"Y\"}, {\"Key\": \"B2CChargesPaidAccountAvailableFunds\", \"Value\": 0}]}, \"OriginatorConversationID\": \"ff62a678-500b-4ee8-9f2e-429f7b7d847b\"}}',NULL,NULL,NULL,NULL),('ff6508b6-85c3-4244-a765-92ac1ddd0392',22,NULL,1020,'KES',NULL,NULL,NULL,'succeeded','2025-02-20 22:57:49','2025-02-20 22:57:56','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 1020, \"msisdn\": \"254740135037\", \"reference\": \"friend\", \"merchant_id\": \"5141482\"}','{\"amount\": \"1020\", \"msisdn\": \"254740135037\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"friend\", \"created_at\": \"2025-02-21 01:57:49\", \"finalised_at\": \"2025-02-21T01:57:53.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TBL4U8EGYW\", \"silkpesa_reference\": \"SIL-1740103069-322\", \"receiver_description\": \"254740135037 - MOHAMED ABDI HASSAN\"}',NULL,'TBL4U8EGYW','254740135037 - MOHAMED ABDI HASSAN',NULL),('ff693917-ac19-436f-b61e-4f4e0324fe7e',9,NULL,15,'KES',NULL,NULL,NULL,'succeeded','2024-12-09 12:11:21','2024-12-09 12:11:21','MPESA','b2b','paybill','','{\"Amount\": \"15\", \"PartyA\": \"5141482\", \"PartyB\": \"4081329\", \"Remarks\": \"test\", \"CommandID\": \"BusinessPayBill\", \"Initiator\": \"gloclienapiuser\", \"Requester\": \"\", \"ResultURL\": \"https://app.safaribucks.com/api/mpesa/business_pay_bill/result\", \"QueueTimeOutURL\": \"https://app.safaribucks.com/api/mpesa/business_pay_bill/result\", \"AccountReference\": \"test\", \"SecurityCredential\": \"NQLPnO1qYCaiu2xpbSgeaN7FWmpaTMOn/dlKU27wL6QWOREEFeG0Ps4SAKnTT556xgL/6Kq8d60Fi01VL2M2QUg2oCF4JcqRTwQc36ztJ/YpDTWTXfQMAUFYFgGS5T2N4q0YFS9oVaJO4MN5fTkC7FldKzKaaIuqAs7XpxFHxdTpmXPWuOlhPeunk+F6K30S9iuxTZJIyqVo486MOgNf+zVYHP8hf+xAdlhCK6unYyMKPzaS9PHGAryUXUvyBNUEjr/Mf1JiEVgtkXM1ozUX+eZzDUo4+mWPzZBUO9tHtptofpl6w21X1NVpq9bCDE9ZK/TpGRU1C9tutFYyb8w0KA==\", \"SenderIdentifierType\": \"4\", \"RecieverIdentifierType\": \"4\", \"OriginatorConversationID\": \"ff693917-ac19-436f-b61e-4f4e0324fe7e\"}','{\"Result\": {\"ResultCode\": 0, \"ResultDesc\": \"The service request is processed successfully.\", \"ResultType\": 0, \"ReferenceData\": {\"ReferenceItem\": [{\"Key\": \"BillReferenceNumber\", \"Value\": \"test\"}, {\"Key\": \"QueueTimeoutURL\", \"Value\": \"https://internalapi.safaricom.net/mpesa/b2bresults/v1/submit\"}, {\"Key\": \"Occassion\"}]}, \"TransactionID\": \"SL97U5QJJN\", \"ConversationID\": \"AG_20241209_2020726b70b3106636c1\", \"ResultParameters\": {\"ResultParameter\": [{\"Key\": \"Currency\", \"Value\": \"KES\"}, {\"Key\": \"ReceiverPartyPublicName\", \"Value\": \"4081329 - HAYAAN SACCO\"}, {\"Key\": \"DebitPartyCharges\"}, {\"Key\": \"TransCompletedTime\", \"Value\": 20241209181121}, {\"Key\": \"DebitPartyAffectedAccountBalance\", \"Value\": \"Working Account|KES|908.00|908.00|0.00|0.00\"}, {\"Key\": \"Amount\", \"Value\": 15}, {\"Key\": \"DebitAccountCurrentBalance\", \"Value\": \"{Amount={CurrencyCode=KES, MinimumAmount=90800, BasicAmount=908.00}}\"}, {\"Key\": \"InitiatorAccountCurrentBalance\", \"Value\": \"{Amount={CurrencyCode=KES, MinimumAmount=90800, BasicAmount=908.00}}\"}]}, \"OriginatorConversationID\": \"950d-425c-bfa4-38751a0c3e7c7944027\"}}',NULL,NULL,NULL,NULL),('ffb5b4ca-53f6-4387-9a78-0984b6d1a670',22,NULL,300,'KES',NULL,NULL,NULL,'succeeded','2025-10-04 22:13:02','2025-10-04 22:13:08','MPESA','b2c',NULL,'','{\"type\": \"b2c\", \"amount\": 300, \"msisdn\": \"254722757783\", \"reference\": \"friend\", \"merchant_id\": \"5141482\"}','{\"amount\": \"300\", \"msisdn\": \"254722757783\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"currency\": \"KES\", \"reference\": \"friend\", \"created_at\": \"2025-10-04 19:13:02\", \"finalised_at\": \"2025-10-04T19:13:05.000000Z\", \"transaction_type\": \"b2c\", \"vendor_reference\": \"TJ4P76GP3E\", \"silkpesa_reference\": \"SIL-1759605182-367\", \"receiver_description\": \"254722757783 - SALAH OSMAN ADAN\"}',NULL,'TJ4P76GP3E','254722757783 - SALAH OSMAN ADAN',NULL),('ffbdd443-c006-47ce-aa37-33792d518ef6',71,'814823E9-327D-4FE6-9DC2-B1B49D7235AA',210,'USD','{\"Result\": \"000\", \"TransRef\": \"R66545562\", \"TransToken\": \"814823E9-327D-4FE6-9DC2-B1B49D7235AA\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'new','2025-03-27 21:33:16','2025-03-27 21:33:16','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL),('ffe86c8e-7129-475e-8f1b-7cc3fe9d2e5c',22,NULL,80,'KES',NULL,NULL,NULL,'succeeded','2025-04-19 14:20:16','2025-04-19 14:20:22','MPESA','b2b','buy_goods','','{\"type\": \"business_buy_goods\", \"amount\": 80, \"msisdn\": \"8816034\", \"reference\": \"tea\", \"merchant_id\": \"5141482\"}','{\"amount\": \"80\", \"msisdn\": \"8816034\", \"status\": \"SUCCEEDED\", \"channel\": \"KE.MPESA\", \"reference\": \"tea\", \"created_at\": \"2025-04-19 14:20:16\", \"finalised_at\": \"2025-04-19T14:20:19.000000Z\", \"transaction_type\": \"business_buy_goods\", \"vendor_reference\": \"TDJ6EWROMM\", \"silkpesa_reference\": \"SIL-1745072416-719\", \"receiver_description\": null}',NULL,'TDJ6EWROMM',NULL,NULL),('fffbbdef-234c-45f3-8ccf-affc625fdaad',47,'F5ACE8E1-BA48-48D4-9D2A-7AA2DB743233',100,'USD','{\"Result\": \"000\", \"TransRef\": \"R66367809\", \"TransToken\": \"F5ACE8E1-BA48-48D4-9D2A-7AA2DB743233\", \"ResultExplanation\": \"Transaction created\"}',NULL,NULL,'new','2025-03-22 13:31:44','2025-03-22 13:31:44','DPO','c2b','card','',NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `user_details`
--

CREATE TABLE `user_details` (
  `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int NOT NULL,
  `customer_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_zip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_details`
--

INSERT INTO `user_details` VALUES ('4d59cfef-a321-4e4f-be60-a9de5bbfd7a4',1,'791811781','lower kabete','nairobi','00100','KE','2025-03-21 16:03:08','2025-11-07 00:44:09'),('bd364050-9f8f-403b-9b95-f15b4ec375f9',64,'722842608','kileleshwa','Nairobi','00100','KE','2025-03-21 19:20:49','2025-03-21 19:20:49'),('9ec54e65-3f2e-44e7-a416-c0edf03a9cf9',60,'724053594','Nairobi','Nairobi','00100','KE','2025-03-22 06:14:45','2025-03-22 06:14:45'),('65898ce8-9dcc-4627-a89c-1106563e4d33',9,'721812719','Embakasi','Nairobi','254','KE','2025-03-22 13:16:41','2025-03-22 13:16:41'),('e442c211-c46a-402c-abc6-cb43f95ac831',47,'0113468848','108 Oregon trail Apt 2','Lexington NE','68850','KE','2025-03-22 13:30:52','2025-03-22 13:30:52'),('a24880b4-b23e-400c-b443-6bdd84ee21ed',66,'0708075713','Kingstone Residences','Nairobi','20645','KE','2025-03-23 15:19:53','2025-03-23 15:19:53'),('bddf7282-2a23-4c4c-916c-55c025698313',67,'0791811781','kerugoya','nairobi','00100','KE','2025-03-24 13:46:47','2025-03-24 13:46:47'),('cb34ff18-fbf8-4da0-a3b7-baf6b63dbff0',68,'724053594','Nairobi','Nairobi','00100','KE','2025-03-24 13:53:56','2025-03-24 13:53:56'),('d637f589-5644-4f8e-8865-bb498f3ee3e2',25,'224774314','3 May Road, Mangere East','Auckland','2024','KE','2025-03-24 17:15:22','2025-03-24 17:15:22'),('5b9d2d67-8e83-484d-98e5-458973ebab06',71,'6127357546','405 N Washington','Lexington','68850','KE','2025-03-27 21:25:32','2025-03-27 21:25:32'),('5ca0584f-b1bf-40e6-948b-e3a0c67928a7',22,'3083786566','2104 N Adams St Apt 7','Lexington','68850','KE','2025-03-27 21:36:43','2025-03-27 21:36:43'),('d193e4d7-a09d-490c-8751-4e298f1f32ce',24,'759937432','79 Claypond Gardens','London','w5 4rf','KE','2025-03-30 14:40:34','2025-03-30 14:40:34'),('9aa66278-2088-46ee-a2c1-156e2b59cde8',45,'717260075','79 Claypond Gardens','London','w5 4rf','KE','2025-04-01 19:05:44','2025-04-01 19:05:44'),('dd8f0433-792b-48a0-8b5b-ddf868dfa0ae',23,'721579276','Madaraka','Nairobi','00101','KE','2025-04-02 19:08:32','2025-04-02 19:08:32'),('48cc3e1c-fd3f-44a1-b974-59f6cde7b932',72,'7926593763','128 velocity tower','sheffield','S14LS','KE','2025-04-18 12:37:42','2025-04-18 12:37:42'),('d454b562-f63f-4515-b54a-0809b791223d',73,'6474051825','18 Grenville Street','Toronto','M4Y3B3','KE','2025-04-23 13:45:24','2025-04-23 13:45:24'),('8e04a2e4-8892-41e3-93eb-3ae5acc3cfab',74,'716320409','1958','nairobi','94308','KE','2025-04-25 09:42:18','2025-04-25 09:42:18'),('747e1739-8a6c-447a-9dd0-88cecff8f636',48,'3143138792','1100 buffalo bend','Lexington','68850','KE','2025-04-25 18:10:38','2025-04-25 18:10:38'),('51c77a1a-7cf5-43b0-aebf-3d93ee26f6d9',75,'07907485199','corner house crwys road','cardiff','CF24 4NB','KE','2025-04-26 07:45:06','2025-04-26 07:45:06'),('ca2d37bb-b3f9-4cde-ad16-0dc44e8743c0',77,'791811781','Lower Kabete','Nairobi','00100','KE','2025-05-01 18:20:22','2025-05-01 18:20:22'),('243306bf-27ad-4957-b85b-02868e2f9358',79,'072922583','Migori road kileleshwa','nairobi','00100','KE','2025-05-06 10:24:35','2025-05-06 10:24:35'),('38bfd187-b1aa-4b21-840f-6cefe4e398c0',80,'0707317199','117 normen cresent','london','tw5 9jn','GB','2025-05-17 14:45:46','2025-05-17 14:45:46'),('b9f1fa7e-a2d1-4132-8219-25850408c5ec',37,'711617140','B2-1 Lalucia Court','Nairobi','00000','KE','2025-05-21 22:12:32','2025-05-21 22:12:32'),('bddb94b7-d48b-4e38-8de8-628798840e0f',81,'102085406','Menelik road','Nairobi','00506','KE','2025-05-26 18:04:30','2025-05-26 18:04:30'),('ce5426a2-9392-4cce-a215-9778c61c8bfe',85,'758560289','Uganda','Kampala','256','UG','2025-06-11 15:08:48','2025-06-11 15:08:48'),('2f5a5070-9465-44d0-b1fc-151eb5ef1938',36,'0225819298','43 Kindergaten drive','Auckland','2112','NZ','2025-06-14 14:12:57','2025-06-14 14:12:57'),('6a7fe5b9-4479-4ebc-90de-abe0ab5a3336',86,'0713601113','14556-00100','Nairobi','00100','KE','2025-06-18 12:26:31','2025-06-18 12:26:31'),('f7a2ce93-ae72-423e-afb4-85393ffcebf7',87,'729631002','Donholm','Nairobi','00100','KE','2025-06-18 14:46:20','2025-06-18 14:46:20'),('4baeb323-b4b4-4674-845a-99a7fd308c1e',88,'0757813605','vihiga rd','nairobi','00606','KE','2025-07-01 20:50:31','2025-07-01 20:50:31'),('d8d0ea80-d339-4b92-8da7-e7331f41975d',89,'710172397','13 Rothwell Street','London','NW1 8YH','GB','2025-07-06 14:59:24','2025-07-06 14:59:24'),('cf213c2c-b9c3-440f-926d-bd93c56f9b26',90,'729667602','4400 nw 7th street','Fort Lauderdale','33317','US','2025-07-11 18:02:02','2025-07-11 18:02:02'),('09c72fc2-2af2-4903-b453-0df5bc70b9e0',91,'792068962','Church st,Zimmerman','Nairobi','00100','KE','2025-07-13 01:23:13','2025-07-13 01:23:13'),('a5fc81ba-d5f8-4524-a27f-e30e963feff3',92,'0794683880','Donholm Nairobi','Nairobi','54','KE','2025-07-16 17:30:26','2025-07-16 17:30:26'),('56d88172-6ffa-451d-aefd-704d982576d4',59,'4163339600','Rexdale Financial Services 19 Woodbine Down Blvd, Unit 201, Etobicoke ON, M9W 6N5','Etobicoke','m9w6n5','CA','2025-07-19 09:15:51','2025-07-19 09:15:51'),('89cd5ba7-2ec8-4522-855c-01313be7b245',94,'758300740','Standard Building','Nairobi','254','KE','2025-08-27 22:43:08','2025-08-27 22:43:08'),('d8ce37d3-5a57-4e90-8f7c-db700525d11b',95,'796999222','nairobi','nairobi','11111','KE','2025-09-13 16:54:48','2025-09-13 16:54:48'),('d8e55df0-14d7-4fce-aabb-a97106ffd5c5',96,'723400415','16312-00610','Nairobi','+254','KE','2025-09-23 22:05:45','2025-09-23 22:05:45'),('7684a979-67c1-4a2f-8864-52c346a1ffbb',97,'308-746-9512','1110 wagon wheel ln apt 1','Lexington','68850','US','2025-09-25 07:51:56','2025-09-25 07:51:56'),('2dfaf7d6-fde4-45bf-9244-86b08a782d7c',98,'6123229719','10650 Brunswick rd s','Bloomington','55438','US','2025-09-25 10:49:21','2025-09-25 10:49:21'),('2456ec97-fab6-439c-ad6e-eac3fa259a27',99,'788381012','KG 480','Kigali','01234','RW','2025-09-25 15:50:38','2025-09-25 15:50:38'),('3f604989-9fe9-45e7-a244-3c9bf2b68dae',100,'726901668','Langata','Nairobi','20100','KE','2025-09-25 21:12:37','2025-09-25 21:12:37'),('6f3b7963-b841-4f44-a3bd-c343f7505190',101,'703846011','Nairobi','Nairobi','24767','KE','2025-09-26 16:25:33','2025-09-26 16:25:33'),('67cda6a5-54b7-4e31-873b-bc514986dfd3',102,'708088268','Nairobi','Nairobi','00202','KE','2025-10-05 06:45:10','2025-10-05 06:45:10'),('277c63fc-c89f-4469-a787-be65001e6491',103,'726639379','Donholm','Nairobi','00100','KE','2025-10-24 00:24:51','2025-10-24 00:24:51'),('8228158a-89dd-453e-a189-208dead57482',104,'116984994','mahmed1401@gmail.com','Nairobi','2100','KE','2025-11-04 19:23:09','2025-11-04 19:23:09');

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `first_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `validated_user` int NOT NULL DEFAULT '0',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_admin` tinyint(1) NOT NULL DEFAULT '0',
  `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'cyrus','muchiri','cmuchiri8429@gmail.com',NULL,1,'$2y$10$ZnmcPSuMAnAaiOPXFDZD8OymIU.2adTpGPf0Z57cxKkysIjAO2jiq',0,NULL,'2024-08-30 06:53:16','2025-03-28 13:19:08'),(6,'Steven','Maina','maichstivo254@gmail.com',NULL,1,'$2y$10$WRyLORBvFXd8OE/QAPHLsuwztLbyd2Gc28Ld5Bp5qeCNWUR1pwgKq',0,NULL,'2024-09-06 16:52:49','2024-09-06 16:52:49'),(9,'Mohamed','Sharif','sharifadan@gmail.com',NULL,1,'$2y$10$EYt1OnJRpzpMTEsHsJTHHe76S/q8iEumOcjv4pbNy3o414.BYlyB.',0,NULL,'2024-09-11 18:04:55','2025-05-01 15:31:38'),(10,'Mohamed','Wiilsharaban','sharifadan@dawati.co.ke',NULL,1,'$2y$10$hlLuW14eJjK0gQDdWvhZ6.F0L/i3YMOozdd4rZHMJn6.FxafDnBWy',0,NULL,'2024-09-11 18:27:59','2024-09-11 18:27:59'),(13,'Dorothy','Wambui','dorothy@silktech.co.ke',NULL,1,'$2y$10$J.1I6DJfSeg8E2oQuYvjaepirmgqDJmmkHFIviCUnmf1NDkIav9dy',0,NULL,'2024-09-16 11:10:52','2024-09-16 11:10:52'),(15,'SafariBucks','Admin','admin@safaribucks.com',NULL,1,'$2y$10$j5nKzLVrWN7vXBLG5fCkzu1tceIGMcI01aU5A7lRndI4tvmzW8RnC',1,NULL,'2024-10-29 18:04:32','2024-10-29 18:04:32'),(16,'Victor','Ndungi','Victor.ndungi@silktech.co.ke',NULL,1,'$2y$10$e93.0t093TsgDQ59HDLHdOhS0SW9Z7upkH992lSRcvnxIwY1SI14C',0,NULL,'2024-11-04 11:09:43','2024-11-04 11:09:43'),(17,'Charity','Wanjiru','charitwangeci53@gmail.com',NULL,1,'$2y$10$TLsbzGiHqAEl7JmaQO1d9ubHjmWFbZ8ZEN0wCQ2OMkKyPB0X5BkXK',0,NULL,'2024-11-21 04:51:10','2024-11-21 04:51:10'),(18,'Mary','Wariara','wariara.mary@gmail.com',NULL,1,'$2y$10$XPpbPqst7OhHfqm2nxzScegMcv2gDVYiUBCjmbiFLZI9wtHTyhoSq',0,NULL,'2024-11-21 06:19:13','2024-11-21 06:19:13'),(19,'benard','mutisya','mnmutisya@uonbi.ac.ke',NULL,1,'$2y$10$bLWN/knzIryNn7Ww8RMpceiOW2xdlsOsbfLbHEciWNFwS.f0uiiii',0,NULL,'2024-11-21 07:39:11','2024-11-21 07:39:11'),(20,'Charity','Wanjiru','charitywangeci53@gmail.com',NULL,1,'$2y$10$OTo73yWZx3zS0L5/0JxBsuXxQlbbdIEIz7abcrEVtIUp7UOs440xW',0,NULL,'2024-11-21 14:53:38','2024-11-21 14:53:38'),(21,'Naheed','Manjothi','nmanjothi@yahoo.com',NULL,1,'$2y$10$4b7HNv7lnsbVzlmOK8Rd6emKaj3gtHvzMRd5m.QlVLM/et7I8uJoO',0,NULL,'2024-11-21 16:10:04','2024-11-21 16:10:04'),(22,'Salah','Osman','swalahdinosman389@gmail.com',NULL,1,'$2y$10$NyiFuFs7zG5XYhCFgiM0wOuulaLLLsxYa8hWp.iUYE5TQ2/UJP3hO',0,NULL,'2024-11-23 03:46:50','2024-11-23 03:46:50'),(23,'Athman','Mwatondo','amwatondo@gmail.com',NULL,1,'$2y$10$iRCM0LA6i3HtXAOIpytUa./lEl.XlsAT5gkt3ZNqlan5SNAiCZwWm',0,NULL,'2024-11-24 04:32:11','2025-04-02 19:07:10'),(24,'Ali Hussein','Hassan','ali.hassan@afripesa.com',NULL,1,'$2y$10$lK9ozd2SvViJcHXVbtfPi.Qd7dLGen4r8skY6x6uWxaicmzNdDFE2',0,NULL,'2024-11-28 12:59:46','2025-04-11 12:55:49'),(25,'Richard','Kitati','kitatimumo@gmail.com',NULL,1,'$2y$10$L5iKpRGBz9KzEEg2F1J6gutuEELRbOVPpj35Q6YnhJ3iclSr5oFBS',0,NULL,'2024-12-01 17:31:24','2024-12-01 17:31:24'),(26,'abdale','jama','abdalejama@hotmail.com',NULL,1,'$2y$10$7uRAybyrS3t175zl.QfPiOWQqwQrD31CgTN6fhDv9LXmG1cm1IuQ.',0,NULL,'2024-12-02 19:02:00','2024-12-02 19:02:00'),(27,'Adan','sheikh','araaninstitute@gmail.com',NULL,1,'$2y$10$S5xL.4O.LfjONVxMiiIdg.AIA2VZ8SvsCRzeqLCDBOnigamRRvvHC',0,NULL,'2024-12-03 11:53:21','2024-12-03 11:53:21'),(28,'james','bonding','iankamau155@gmail.com',NULL,1,'$2y$10$CvYLPtamd2ttAId8pZip6eUVD.nGOp9kLgFRBkTHBEGXmlTTrdMc6',0,NULL,'2024-12-06 06:59:14','2024-12-06 06:59:14'),(29,'steven','maina','djcurtsy@gmail.com',NULL,1,'$2y$10$ISCTcMTWhGaV9UHUImpa8OVRMUbXz3CMJdIXFkGAwaWybLPRw1VYG',0,NULL,'2024-12-06 07:19:37','2024-12-06 07:19:37'),(30,'mulki','Mohamed Muse','Mulki.muse@hotmail.com',NULL,1,'$2y$10$MNolWOixIlw2uSEv.ryJROW7AF0cYWlwqCqF/wPaCplYH2JhJRp.O',0,NULL,'2024-12-12 11:32:24','2024-12-12 11:32:24'),(31,'Hussein','Mohammed','husmo8699@gmail.com',NULL,1,'$2y$10$JQrFPLRMX5/NNVfwMLrii.MAdgR2yxd6h.KA.M2KrzLrkzDuIdHTO',0,NULL,'2025-01-09 15:59:19','2025-01-09 15:59:19'),(32,'Adelaide','Muthangi','adeliade32@gmail.com',NULL,1,'$2y$10$Kuqov5uNepht218my.kS0eh6ZTKI2rCt.Wf9KsMM7ju5Pap1QtTGi',0,NULL,'2025-01-10 06:42:39','2025-01-10 06:42:39'),(33,'Dennis','Lyttle','lyttlebackup@gmail.com',NULL,1,'$2y$10$pj6Nbdz1vpGWK5SR7Jrk5eYRLyvNMJxHmd0GyDt4B6OsncS8ejxn.',0,NULL,'2025-01-15 12:05:49','2025-01-15 12:05:49'),(34,'Mercy','Kiremu','kangaikiremu@gmail.com',NULL,1,'$2y$10$vUeu.3CyGNzEFbsJjdCem.HraSfNBPrAXq5Qk07TRohJxPDJhHx8y',0,NULL,'2025-01-27 04:41:43','2025-01-27 04:41:43'),(35,'Pauline','Warui','pwarui69@gmail.com',NULL,1,'$2y$10$9fvu5KJJch10Q3HFI1gTsuBfmbZLhfk6L.GanVEosy/yAv5HTW3GG',0,NULL,'2025-01-28 07:00:34','2025-01-28 07:00:34'),(36,'Collins','Chirchir','Ckipchumbaa@gmail.com',NULL,1,'$2y$10$eD4MDewyCiV/CPVhCWC5mO/b2jHdLOc/0bwEp7XbTDwEwIXHWlSQ6',0,NULL,'2025-01-31 06:47:06','2025-01-31 06:47:06'),(37,'Eric','Osiakwan','ericosiakwan@me.com',NULL,1,'$2y$10$Explx7Q7/QURvk37X8uQcu5A2Ru5iyHRC8WuhTdKjNJmBkp5QF4by',0,NULL,'2025-02-01 10:08:15','2025-02-01 10:08:15'),(38,'Edith Ofwona','Adera','edith.adera@gmail.com',NULL,1,'$2y$10$zSgRm6.19.fuY8zggWD1XumXtzTvacnTH44t1acSSQdh2t2ze6Rhq',0,NULL,'2025-02-01 10:51:05','2025-02-01 10:51:05'),(39,'Reuben','Ronoh','reubzronohjr@gmail.com',NULL,1,'$2y$10$hz9EmEN.z4fnoDcRGHBNIet3eAGbBNyYqxdfP4nlogaqPF6MCSRnC',0,NULL,'2025-02-03 02:58:07','2025-02-03 02:58:07'),(40,'Theresa','Fehle','thersa.fehle@gmail.com',NULL,1,'$2y$10$zU8mI6iUVXGgYQm2Zs5Cde7AU6JjOqBirSjwhfW0jG3VKCbR6k28y',0,NULL,'2025-02-04 11:18:03','2025-02-04 11:18:03'),(41,'Christine','Nzilani','mumonzilani@yahoo.com',NULL,1,'$2y$10$h1cEvQusLjonxCdvx4gXA.W531YA8u3ZA4astiqFMtwP53dCdnseO',0,NULL,'2025-02-04 21:01:44','2025-02-04 21:01:44'),(42,'Steve','Ronoh','Steve.krnz@gmail.com',NULL,1,'$2y$10$Dsr.QtHoUN63xfAW1Mj.qup.F1n9fcBTKohl3cCkmcaYOB/N3h4ge',0,NULL,'2025-02-05 05:02:17','2025-02-05 05:02:17'),(43,'Elsie','Rotich','rotichelsie408@gmail.com',NULL,1,'$2y$10$Yc/rLp6fiEc6KLrc9igoLu4xs2QJxEoF3FIRkLZwHi9JbNWA21zLG',0,NULL,'2025-02-07 02:49:15','2025-02-07 02:49:15'),(45,'Hussein','Hassan Salah','husseinkimani@live.co.uk',NULL,1,'$2y$10$lg2LIngELqnOBY.ptvvEj.Tx/Wg4pIuk8GL5aR36QHZLtgV4ZSga2',0,NULL,'2025-02-12 19:33:08','2025-04-01 19:02:42'),(46,'Abdulazeez','Ogunjobi','az@billboxx.com',NULL,1,'$2y$10$NPq1B/avBmHnLp6UIOLhdeYF1o5ghm2.2jxryRGwY9U13Xr9jEGpS',0,NULL,'2025-02-14 16:26:40','2025-02-14 16:26:40'),(47,'Feisal','Nunow','Feisalnunow1987@gmail.com',NULL,1,'$2y$10$glSi11nPp1c8CBbdYniv7e4xIhVVF33yhfsmMeOotRZs8Bzi42UZ.',0,NULL,'2025-02-17 17:09:16','2025-02-17 17:09:16'),(48,'Ahmed','Abdi Jama','hiritikm20@hotmail.com',NULL,1,'$2y$10$ywNCTKpZB61NPL9E.LPHbO2IsSVm/HbVS1kLNodE3B9zEH9POFGiy',0,NULL,'2025-02-17 17:18:36','2025-02-17 17:18:36'),(49,'Abdullahi','m Ali','xundubeyabdull@gmail.com',NULL,1,'$2y$10$JRvZi4NAT4nasyOCcwxbcubMjBoWmy69I13CI/14cB1m3OxgAj2Hy',0,NULL,'2025-02-17 17:20:18','2025-02-17 17:20:18'),(50,'Victor','Ndungi','victorvick399@gmail.com',NULL,1,'$2y$10$0EHc13L.EBgwPORWOdfNHeF5GMSorSf8xWX2qMcGXucyyRZohuifC',0,NULL,'2025-02-24 03:36:32','2025-02-24 03:36:32'),(51,'Yusuf','Hakim','yusufabdihakim@gmail.com',NULL,1,'$2y$10$pS7JJmcjQNh0J4BoU5FeJOIXci1vRvUrGlVY7uvqTGjY/18XnA7Fu',0,NULL,'2025-02-24 12:33:46','2025-02-24 12:33:46'),(52,'Alice','Tester','alicetest@mail.com',NULL,1,'$2y$10$z1BnUbEwRA43gmW7kgBtpueN1SX1aS.g68kXa2PzaPL552jRe4Ydu',0,NULL,'2025-02-26 08:34:48','2025-02-26 08:34:48'),(53,'Collins','Nyaga','collinsmuchiri75@gmail.com',NULL,1,'$2y$10$LA3Jksgw5Oo1bPc3Klna5ukkeSzh/MbE0hzqXJ3lFV/PtuT9A9Lcy',0,NULL,'2025-02-26 12:51:32','2025-02-26 12:51:32'),(54,'Mokeira','Gisairo','mokeiragisairo@gmail.com',NULL,1,'$2y$10$RG993eXESgYiK0nmRkiHcu/9xHwMGRL/eygNI/afQg7WH8vGN/SEu',0,NULL,'2025-02-28 14:35:04','2025-02-28 14:35:04'),(55,'akwo','Ashangndowah','akwoashang@outlook.com',NULL,1,'$2y$10$zXKy7VR1Bkf9lYo3KL0PLuHb0SU4WIvgrb7lsoU7qO2SOl6i.qmxm',0,NULL,'2025-02-28 14:53:19','2025-02-28 14:53:19'),(56,'Userer','Tester','testuser@mail.com',NULL,1,'$2y$10$mYJ.RhhSlUwHd28kVIyyF.f67hADj8BMW7MTcuwXf/qvlvZugQr12',0,NULL,'2025-03-04 09:12:33','2025-03-04 09:12:33'),(57,'Hussein','Mohamed','hussan8699@gmail.com',NULL,1,'$2y$10$wE.K1OC9zye.LBcjWvtEKOiTKJvdOUurNtEleQNC7xg48//4GWiEq',0,NULL,'2025-03-08 13:47:31','2025-03-08 13:47:31'),(58,'johnjj','mukisa','jjmukisa@mail.com',NULL,1,'$2y$10$ghiEG1aCaDMeHNlViXbwUO0f8jI1xvIEhsZpsnPYiDMWoAENKwyve',0,NULL,'2025-03-10 10:41:59','2025-03-10 10:41:59'),(59,'nick','gahunia','nsg1@outlook.com',NULL,1,'$2y$10$n2W2uQx78xmIyO1WJpaRnuyWxhMT/y2K1O6mFT.F6lIjet4BN/5AO',0,NULL,'2025-03-10 17:42:33','2025-03-10 17:42:33'),(60,'Alice','Githui','alice.githui@silktech.co.ke',NULL,1,'$2y$10$AlX5Zwmw5l/K7HMQvdb4Fuojk.sTBz4rxI.LDAVLp.HagScArgIf6',0,NULL,'2025-03-11 08:53:06','2025-03-11 08:53:06'),(63,'Osman','Osman','osmanosmam85@gmail.com',NULL,0,'$2y$10$uAXsO6Tucsx3QrJ51UL5.OHEh8iCvpKrhKVNM3zdmIXf7wJiokG7i',0,NULL,'2025-03-21 18:13:22','2025-03-21 18:13:22'),(64,'Warsame','Mohamed','omarwhmohamed@gmail.com',NULL,0,'$2y$10$UjsdMrwC5H2aLadapjnKx.3ZYsOZOyOtC3g0fUrbX2BSagVeUwQEa',0,NULL,'2025-03-21 19:19:12','2025-03-21 19:19:12'),(65,'Alice','Githui','gnyokabi.alice@gmail.com',NULL,0,'$2y$10$/mZdwQzn9PyqQPQSEFoLG.lvNKe5S1jcTolhG.X9vcrS.cZOwROwe',0,NULL,'2025-03-22 05:55:38','2025-03-22 05:55:38'),(66,'Amos Joe','Waneno','amosjoe250@gmail.com','2025-03-23 15:18:36',1,'$2y$10$e9cpANu8bb6MK38wHAl2ue4R5w9BZ/0xrTYjWpekuGwnWUjVcaPUC',0,NULL,'2025-03-23 15:17:13','2025-03-23 15:18:36'),(67,'Cyrus','muchiri','cyrusmuchirichomba@gmail.com',NULL,0,'$2y$10$O7g7O5ct.0iXtjxwgADXpeWiqHm25umE4J/THUhJRIIFm3Uke5LUW',0,NULL,'2025-03-24 13:27:30','2025-03-24 13:27:30'),(68,'Alice','Githui','alicegithui23@gmail.com',NULL,0,'$2y$10$nMW7tp9y6ZaRfFNao49wEu7FlDQW0TaPaB.hHPcl8vGp41dmnuhii',0,NULL,'2025-03-24 13:48:03','2025-03-24 13:48:03'),(69,'Alice','Githui','alicegithuilearn@gmail.com',NULL,0,'$2y$10$K7cAapobVqY4J8B2wGzd7OOK.hA6d3KZiK7.m6I8y3IvdBlqK60/.',0,NULL,'2025-03-24 13:54:53','2025-03-24 13:54:53'),(70,'alice','nyokabi','nyokabi@mail.com',NULL,0,'$2y$10$dgTe0AcdckgLHNG2ihhopOVlUqDUEKDtUqXn.wJ1pvp3TO57y3LEK',0,NULL,'2025-03-24 14:09:39','2025-03-24 14:09:39'),(71,'Naji','ahmed abdi','Maandeeqglobal@gmail.com','2025-03-27 21:23:44',1,'$2y$10$DwE/j59DZoTS5YkTeDdcqe0YlL9oYbK2zVxoG9AiRuSEFcH/tMnMu',0,NULL,'2025-03-27 21:22:59','2025-03-27 21:23:44'),(72,'Flora','Kokwaro','loraprk30@yahoo.com','2025-04-18 12:36:10',1,'$2y$10$4t7aKj6AjESZdFcw1DsdpuOjb4u5NedEgAPTA56jcJVuUP/.LCKFy',0,NULL,'2025-04-18 12:35:18','2025-04-18 12:36:10'),(73,'Mohamed','Hirsi','hirsimo@icloud.com','2025-04-23 13:44:10',1,'$2y$10$QT0Vvv0mqvoauyqJw5iU7uLjhYh.2hoYpZsfnHp3VUuYtOcaE5USO',0,NULL,'2025-04-23 13:43:38','2025-04-23 13:44:10'),(74,'Irungu','Nyakera','wnyakera@gmail.com','2025-04-25 09:41:14',1,'$2y$10$6ZVsgRdomxhWKQKcQrPYwueqc2QJVgCWmkEvvQLa2jRRhYRGVehi.',0,NULL,'2025-04-25 09:40:20','2025-04-25 09:47:26'),(75,'Cynthia','Irungu','iirungucynthia@gmail.com','2025-04-26 07:42:35',1,'$2y$10$U7rcM0S0CK4MqfIBEPAyQug7TwJRUek2.vqBouE57N.q.PMfna.Sy',0,NULL,'2025-04-26 07:42:09','2025-04-26 07:42:35'),(76,'james','Wales','irungu.nyakera@gmail.com','2025-04-30 11:51:59',1,'$2y$10$XStdD5H0pFqkVRLZQ2kJd.scdJJ3oJAQDXZZFLU8OnRhdLY0zRWjK',0,NULL,'2025-04-30 11:50:44','2025-04-30 11:51:59'),(77,'Cyrus','Chomba','cyrus.muchiri@safaribucks.com','2025-05-01 18:13:59',1,'$2y$10$XiwKUzrTwlwhfYKnrKMOXeVEH.K3ZXVLcCB.TZ72t8Q9j.SMJvPzi',0,NULL,'2025-05-01 18:13:03','2025-05-01 18:13:59'),(78,'Prem','Doe','prem.do@test.com',NULL,0,'$2y$10$Yhxar2OiSJQ0MtHs8KGiWO.XoUG8D8OcGiSNbGC3Nph/4SCpXWRZS',0,NULL,'2025-05-02 10:10:09','2025-05-02 10:10:09'),(79,'olivier','gasangwa','ogasangwa@gmail.com','2025-05-06 10:22:36',1,'$2y$10$q9rP4jq15Pyf6xIxE73bmuSKOWvIC/phJeVE2BwcqA717RMSTOiAC',0,NULL,'2025-05-06 10:22:06','2025-05-06 10:22:36'),(80,'abdirahman','abdulahe','abdirahmanabdulahe@gmail.com','2025-05-17 14:41:01',1,'$2y$10$hUSRO8sxsBdeUQxVG69UnuwoFVYSkYc/XlyP0C4CCIptZKdgSh11G',0,NULL,'2025-05-17 14:40:28','2025-05-17 14:41:01'),(81,'Musa','Abdi','musaamir98@gmail.com','2025-05-26 18:02:32',1,'$2y$10$LbV42HXB9XDJj/SNoIOcR.px4g5x5QCZ3peIdzaafiLataFnXmObO',0,NULL,'2025-05-26 18:02:09','2025-05-26 18:02:32'),(82,'mark','kimari','mdkimari78@gmail.com',NULL,0,'$2y$10$wYgCbK.ZDRzXWzRTFizoGuPp3xbrHbuNqd1xzQ5hI83suKD8R0Us6',0,NULL,'2025-05-27 19:52:22','2025-05-27 19:52:22'),(83,'Mark','Kimari','mdkimari78@icloud.com',NULL,0,'$2y$10$gsbUv4qpvjLO5fzvoyj4Fu8tR1VODsL4G3ZyYMTq5JeigxAi8nz0m',0,NULL,'2025-05-27 19:58:28','2025-05-27 19:58:28'),(84,'Shariffa','Bint Ali','nakasherry13@gmail.com','2025-06-11 11:32:25',1,'$2y$10$XzCLQmQgD/FizoVln1K9BuLNJAAkFqRvUAUREVO2keR7BDytn2Bge',0,NULL,'2025-06-11 11:31:19','2025-06-11 11:32:25'),(85,'Asiimwe','Maria','mariaasiimwe59@gmail.com','2025-06-11 15:07:51',1,'$2y$10$YVbun46mYzZlNW85hhG8cO1gJjz3uBgfhTtbRNc1Zy3zxI5cXTQXu',0,NULL,'2025-06-11 15:04:09','2025-06-11 15:07:51'),(86,'Ali Hussein','Kassim','ali@hussein.me.ke','2025-06-18 12:25:07',1,'$2y$10$5qgIcMDkdNkffczW/ngW4OvicSl0w1tWsAkgK7NMJdhc4UigbJRlO',0,NULL,'2025-06-18 12:23:48','2025-06-18 12:25:07'),(87,'Rewel','Mumbo','rensonmumbo@gmail.com','2025-06-18 14:45:22',1,'$2y$10$2JIs25Di5fR.neZrgx0QXunNs.vrDcdcfxtSBvvEJ3hW54ni6IiJi',0,NULL,'2025-06-18 14:44:02','2025-06-18 14:45:22'),(88,'aden','hassan','adenhassan528@gmail.com','2025-07-01 20:46:56',1,'$2y$10$nKK8upPP0IPDmmJfyHiwCOnEoXTGtZNptD.p08GHhnxUnufU///ce',0,NULL,'2025-07-01 20:46:05','2025-07-01 20:46:56'),(89,'Ben','Hyman','ben.hyman7@gmail.com','2025-07-06 14:58:48',1,'$2y$10$QD5cvOjZ8GF9Cur3xrB/OO6OO88CHW8/EHfI4e3A/1NVw46CnwWam',0,NULL,'2025-07-06 14:57:07','2025-07-06 14:58:48'),(90,'Lorenzo','Rolle','loyaltyreferralprogram@gmail.com','2025-07-11 17:59:19',1,'$2y$10$TkuXPOjBKpGyn6vKdqYiNuUvSFiDUifr8dlryQeu2ns3f.BWKWb.q',0,NULL,'2025-07-11 17:58:14','2025-07-11 17:59:19'),(91,'Maxwell','Muchiri','muchirimaxwel@gmail.com','2025-07-13 01:21:59',1,'$2y$10$kQEaYTkbrUxZnUKiHmJ7luRYKzE2FU0.Yi23gr0SYN7LzzigYbrm2',0,NULL,'2025-07-13 01:20:08','2025-07-13 01:21:59'),(92,'Abdurahman','jele','abdurahmanjelle5@gmail.com','2025-07-16 17:25:04',1,'$2y$10$kjLoLDjf.SBySpgdDt6oHumxyYpemB2m0TSqUz9Y8EMWgA3.l0HZC',0,NULL,'2025-07-16 17:21:10','2025-07-16 17:25:04'),(93,'Ibrahim','Abdikadir','ibrahimmarnin@gmail.com',NULL,0,'$2y$10$qnSaNLpZNdthFUz0WMYZfumB2tqO82raAhHn684PYycCeBq7v9NXy',0,NULL,'2025-07-25 20:10:55','2025-07-25 20:10:55'),(94,'Salha','Ratib','ratib.salha@gmail.com','2025-08-27 22:41:42',1,'$2y$10$4r/K49vCDNRwZGQxecwWhurUnBEvy7xTo63gKWijNGXjST5ZYlOfq',0,NULL,'2025-08-27 22:41:01','2025-08-27 22:41:42'),(95,'jamal','abdinasir tarabi','jemalxx8@gmail.com','2025-09-13 16:53:24',1,'$2y$10$9GEiG4op6oF6uu0KplU.PufRvV4lGXXB/ud2hW7dqlxzKt.8QuFIO',0,NULL,'2025-09-13 16:52:35','2025-09-13 16:53:24'),(96,'Abdiaziz','Osman','Abdiazizbn@gmail.com','2025-09-23 22:04:39',1,'$2y$10$8x0ndhWhuCg2QOTf99Z7oeCFhCyqOE4Hm/t//D.g82IbE7STn0zBu',0,NULL,'2025-09-23 22:03:53','2025-09-23 22:04:39'),(97,'Abdihamid','Mohamed','Abdihamidhusein69@gmail.com','2025-09-25 07:50:45',1,'$2y$10$EsAHxyEPG61jgkTZj7xiSOqYkbqBgg.IcttgQxZgbz1XpuWRiehDi',0,NULL,'2025-09-25 07:50:05','2025-09-25 07:50:45'),(98,'yassir','aden','manowcade842@gmail.com','2025-09-25 10:48:13',1,'$2y$10$eK1s3LtoilbsbS/3U8kdL.jchApxuJjcgaPSGVS8gMogGz2BdBEWu',0,NULL,'2025-09-25 10:47:23','2025-09-25 10:48:13'),(99,'Nafisa','Sharfi','nafisasharfi@gmail.com','2025-09-25 15:49:48',1,'$2y$10$WFG6G1Vjv76AfN.hzpRh6OHV.6Z9X3GKVz9h/crji.Y9.Td1TuMyu',0,NULL,'2025-09-25 15:49:16','2025-10-18 13:39:12'),(100,'Joshua','Mankone','jmankone1@gmail.com','2025-09-25 21:11:41',1,'$2y$10$FmT/6aiRPoCeecaQCV8WAOQFoq.YgJeaavNCofF7g23iB3SEP8Amy',0,NULL,'2025-09-25 21:10:57','2025-09-25 21:11:41'),(101,'Jocelyn','Muoki','jwmuoki@gmail.com','2025-09-26 16:24:42',1,'$2y$10$WBz9ESuucpKVdYBijAQSE.Wok.YXR/OziW76PejDssAdjZ.g7p7Vu',0,NULL,'2025-09-26 15:54:32','2025-09-26 16:24:42'),(102,'Mundi','Collins','mundicollins@gmail.com','2025-10-05 06:43:34',1,'$2y$10$7U3sIeVm2ofiNL5ibK.c7u.rLyTh7xpF87s63U4C/ci.F.0BCS.D.',0,NULL,'2025-10-05 06:42:55','2025-10-05 06:43:34'),(103,'John','Kinyua','johnkinyuake@gmail.com','2025-10-24 00:24:26',1,'$2y$10$aPcmJQ1s2V8hAjb0aKZ9Ge3OOxO/om.TR6zI1CZwZbZtsQGF20osG',0,NULL,'2025-10-24 00:23:12','2025-10-24 00:24:26'),(104,'Mohammed','Ahmed','mahmed1401@gmail.com','2025-11-04 19:22:28',1,'$2y$10$n/PYFpvDhbvLUctkZ9mlu.W06AZ0N8Oiqs9hYblvt.XaDewTemj0O',0,NULL,'2025-11-04 19:21:26','2025-11-04 19:22:28');

--
-- Table structure for table `validation_otps`
--

CREATE TABLE `validation_otps` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `otp` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `validation_otps`
--

INSERT INTO `validation_otps` VALUES (1,63,6831,'2025-03-21 18:13:22','2025-03-21 18:13:22'),(2,64,7934,'2025-03-21 19:19:12','2025-03-21 19:19:12'),(3,65,6099,'2025-03-22 05:55:38','2025-03-22 05:55:38'),(4,66,2058,'2025-03-23 15:17:13','2025-03-23 15:17:13'),(5,67,4924,'2025-03-24 13:27:30','2025-03-24 13:27:30'),(6,68,1170,'2025-03-24 13:48:03','2025-03-24 13:48:03'),(7,69,6585,'2025-03-24 13:54:53','2025-03-24 13:54:53'),(8,70,6895,'2025-03-24 14:09:39','2025-03-24 14:09:39'),(9,71,6798,'2025-03-27 21:22:59','2025-03-27 21:22:59'),(10,72,9106,'2025-04-18 12:35:18','2025-04-18 12:35:18'),(11,73,8036,'2025-04-23 13:43:38','2025-04-23 13:43:38'),(12,74,4355,'2025-04-25 09:40:20','2025-04-25 09:40:20'),(13,75,8432,'2025-04-26 07:42:09','2025-04-26 07:42:09'),(14,76,3627,'2025-04-30 11:50:44','2025-04-30 11:50:44'),(15,77,1090,'2025-05-01 18:13:03','2025-05-01 18:13:03'),(16,78,6134,'2025-05-02 10:10:09','2025-05-02 10:10:09'),(17,79,8649,'2025-05-06 10:22:06','2025-05-06 10:22:06'),(18,80,3085,'2025-05-17 14:40:28','2025-05-17 14:40:28'),(19,81,7934,'2025-05-26 18:02:09','2025-05-26 18:02:09'),(20,82,5640,'2025-05-27 19:52:22','2025-05-27 19:52:22'),(21,83,9828,'2025-05-27 19:58:28','2025-05-27 20:00:05'),(22,84,3878,'2025-06-11 11:31:19','2025-06-11 11:31:19'),(23,85,2862,'2025-06-11 15:04:09','2025-06-11 15:06:31'),(24,86,8845,'2025-06-18 12:23:48','2025-06-18 12:23:48'),(25,87,4306,'2025-06-18 14:44:02','2025-06-18 14:44:02'),(26,88,5921,'2025-07-01 20:46:05','2025-07-01 20:46:05'),(27,89,5281,'2025-07-06 14:57:07','2025-07-06 14:57:07'),(28,90,5076,'2025-07-11 17:58:14','2025-07-11 17:58:14'),(29,91,9335,'2025-07-13 01:20:08','2025-07-13 01:21:07'),(30,92,5097,'2025-07-16 17:21:10','2025-07-16 17:24:26'),(31,93,1605,'2025-07-25 20:10:55','2025-07-25 20:10:55'),(32,94,2259,'2025-08-27 22:41:01','2025-08-27 22:41:01'),(33,95,4834,'2025-09-13 16:52:35','2025-09-13 16:52:35'),(34,96,3079,'2025-09-23 22:03:54','2025-09-23 22:03:54'),(35,97,8559,'2025-09-25 07:50:05','2025-09-25 07:50:05'),(36,98,4034,'2025-09-25 10:47:23','2025-09-25 10:47:23'),(37,99,5097,'2025-09-25 15:49:16','2025-09-25 15:49:16'),(38,100,9148,'2025-09-25 21:10:57','2025-09-25 21:10:57'),(39,101,1954,'2025-09-26 15:54:32','2025-09-26 15:54:32'),(40,102,3514,'2025-10-05 06:42:56','2025-10-05 06:42:56'),(41,103,6936,'2025-10-24 00:23:12','2025-10-24 00:23:12'),(42,104,3528,'2025-11-04 19:21:26','2025-11-04 19:21:26');

--
-- Table structure for table `wallets`
--

CREATE TABLE `wallets` (
  `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int NOT NULL,
  `actual_balance` double NOT NULL COMMENT 'Total amount including amount held',
  `available_balance` double NOT NULL COMMENT 'Actual balance - amount in pending transactions',
  `last_transaction` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_transaction_amount` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_transaction_type` enum('credit','debit') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `alias` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency_code` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL,
  `wallet_no` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wallets`
--

INSERT INTO `wallets` VALUES ('01bf1757-181d-4627-825e-02e673605100',20,0,0,NULL,NULL,'credit','2024-11-21 14:53:38','2024-11-21 14:53:38',NULL,'KES','000087'),('08c43e81-ede4-42ca-b2d2-f35075659162',38,0,0,NULL,NULL,'credit','2025-02-01 10:51:05','2025-02-01 10:51:05',NULL,'KES','000074'),('095e14f4-4170-4040-985e-9ce90bf4bae6',59,0,0,'1dccb340-2d0e-40e1-8434-2c42d3a2093b','17900','debit','2025-03-10 17:42:33','2025-11-06 21:44:58',NULL,'KES','000073'),('0da1576a-1ae0-4951-827e-76a39d9564ba',75,0,0,NULL,NULL,'credit','2025-04-26 07:42:09','2025-04-26 07:42:09',NULL,'KES','000072'),('0e116183-9c3f-4e02-a7c2-311889ff929c',88,80,80,'7a427e07-1d99-4936-8101-e6199708d372','20','debit','2025-07-01 20:46:05','2025-07-01 20:53:52',NULL,'KES','000071'),('1585e420-8dc9-4af5-a064-2f541303a553',23,1020,990,'df274c5f-a500-4c5d-badf-cef0d632e2f3','60','debit','2024-11-24 04:32:11','2025-10-23 20:04:00',NULL,'KES','000070'),('1892f325-002b-43dd-82e3-6701593ee18d',3,156,56,'e533d8ce-7a67-4f89-9e19-daf72d8feae2','4','credit','2024-09-04 08:55:09','2024-11-11 16:04:19',NULL,'KES','000069'),('1b3667f2-5fb1-4002-8960-8067ea1431f3',26,0,0,NULL,NULL,'credit','2024-12-02 19:02:00','2024-12-02 19:02:00',NULL,'KES','000068'),('1f727365-c9b4-4928-a80f-aaab668aca87',102,0,0,NULL,NULL,'credit','2025-10-05 06:42:56','2025-10-05 06:42:56',NULL,'KES','000067'),('1ffcc335-8054-4687-935d-8cabcff66997',6,80,80,'f3af6ebf-1ad0-485d-a14f-dbda7b4de977','10','debit','2024-09-06 16:52:49','2024-10-15 07:34:35',NULL,'KES','000066'),('22fca304-1ef6-42bf-9555-5aad6d48872a',21,0,0,NULL,NULL,'credit','2024-11-21 16:10:04','2024-11-21 16:10:04',NULL,'KES','000065'),('27fc7cc1-2f92-4fcc-a0cd-fc88ad94b9b8',48,3,3,'8f446d4f-b074-4d84-a342-cc93041a1b70','50','debit','2025-02-17 17:18:36','2025-05-19 13:42:55',NULL,'KES','000064'),('2d640b00-35db-494d-b1e0-b65fe0bd2642',96,90,90,'b1a4e492-0f38-47ba-acea-100eb6171bb5','10','debit','2025-09-23 22:03:53','2025-09-23 22:07:15',NULL,'KES','000050'),('2e468c57-c3e8-4e0e-96bd-82d270f495b3',71,0,0,'52ad4efe-6975-44b5-912d-c68fad0caf97','41','debit','2025-03-27 21:22:59','2025-05-26 20:29:03',NULL,'KES','000062'),('2f3b8320-4334-4648-a4d2-1c5b85e73717',45,197,197,'8462cb38-4265-484d-a4c0-ae8e9dcc02b7','400','debit','2025-02-12 19:33:08','2025-03-03 08:53:35',NULL,'KES','000061'),('31fabcec-1648-4417-8a97-98ee7e216feb',92,150,150,'8b2d60b0-f42c-4540-929a-03b70c092773','150','credit','2025-07-16 17:21:10','2025-07-17 15:50:46',NULL,'KES','000060'),('338f29fb-be10-4742-998f-eb9457e65651',2,0,0,NULL,NULL,'debit','2024-08-30 11:12:49','2024-08-30 11:12:49',NULL,'KES','000059'),('33d83925-8957-4ca3-a658-89c29149fb48',39,0,0,NULL,NULL,'credit','2025-02-03 02:58:07','2025-02-03 02:58:07',NULL,'KES','000058'),('370327ea-809f-422a-b11e-d01dcbc537ff',53,0,0,'03938297-8212-470d-b09a-65da3bb9c01e','200','debit','2025-02-26 12:51:32','2025-02-26 12:57:58',NULL,'KES','000057'),('3a21053a-d876-4608-b516-5234419c0787',40,1300,1300,'a0cdbc87-7790-4f45-ba57-0e8f1dd25c0f','1300','debit','2025-02-04 11:18:03','2025-02-11 05:16:20',NULL,'KES','000056'),('3c2549d2-202a-4d0e-b5b1-5fb063528f4e',84,0,0,NULL,NULL,'credit','2025-06-11 11:31:19','2025-06-11 11:31:19',NULL,'KES','000055'),('3eb4ef81-1791-4f0a-97a8-96505a991ac5',30,0,0,'b3ca40d6-9a8c-4b89-80bc-1fd474d77114','16000','debit','2024-12-12 11:32:24','2025-01-15 16:49:20',NULL,'KES','000054'),('4047c630-e401-440d-ab95-dfc6bcc5b064',72,0,0,NULL,NULL,'credit','2025-04-18 12:35:18','2025-04-18 12:35:18',NULL,'KES','000053'),('42c4e95a-7a51-4c98-843c-437d0f842478',56,0,0,NULL,NULL,'credit','2025-03-04 09:12:33','2025-03-04 09:12:33',NULL,'KES','000052'),('43bf3d4a-cb21-4e5b-b4a7-a21d2335de8d',90,0,0,NULL,NULL,'credit','2025-07-11 17:58:14','2025-07-11 17:58:14',NULL,'KES','000051'),('479b1132-a3ed-4332-8f87-1668d9c7d1d1',80,0,0,'9ca76bb6-a8d1-4b3a-8600-9d85b68b505a','19950','debit','2025-05-17 14:40:28','2025-05-17 17:46:57',NULL,'KES','000063'),('4dd9be7e-cb23-4db1-8c0c-3a6c8850667b',76,0,0,NULL,NULL,'credit','2025-04-30 11:50:44','2025-04-30 11:50:44',NULL,'KES','000098'),('500a67c9-1a9c-4cf2-a524-941a31971a7c',60,10,10,'700fee89-63f2-418e-9319-2b3b2f6830c9','10','credit','2025-03-11 08:53:06','2025-03-26 01:04:47',NULL,'KES','000097'),('518ec621-c753-4937-9950-9885453df5ee',18,51,51,'a7a0a33b-a07d-4b86-95c9-096e187b7a17','100','debit','2024-11-21 06:19:14','2024-11-26 03:41:06',NULL,'KES','000096'),('51e5fa69-b6bf-4f20-8763-2a1624b591e0',93,0,0,NULL,NULL,'credit','2025-07-25 20:10:55','2025-07-25 20:10:55',NULL,'KES','000095'),('52571891-3983-4d4d-a13c-5503d4996efc',12,0,0,NULL,NULL,'debit','2024-09-12 07:13:58','2024-09-12 07:13:58',NULL,'KES','000094'),('533160e0-4b2d-46bd-979b-66ecd7031682',31,0,0,NULL,NULL,'credit','2025-01-09 15:59:19','2025-01-09 15:59:19',NULL,'KES','000093'),('539d72e2-9d24-4d66-8820-b5e9ffd62249',104,25412,1589,'b2faaf38-ade3-41b3-a379-96112f7700de','12706','credit','2025-11-04 19:21:26','2025-11-05 21:58:09',NULL,'KES','000092'),('53df2cb0-b27b-4fa9-b62a-357039c3402a',25,0,0,'ac803ae3-3132-4a0f-b469-3a933bcaef07','2800','debit','2024-12-01 17:31:24','2025-09-22 12:08:16',NULL,'KES','000091'),('5569edee-11e9-41e4-aea1-feeff83fb745',42,0,0,NULL,NULL,'credit','2025-02-05 05:02:17','2025-02-05 05:02:17',NULL,'KES','000090'),('583d4618-0e40-4070-b860-f64b954e51fe',89,0,0,NULL,NULL,'credit','2025-07-06 14:57:07','2025-07-06 14:57:07',NULL,'KES','000089'),('58a680b7-5a4c-4691-b7c9-f409a5d94015',22,100,0,'e289846e-406d-4d5b-886f-159f9731725d','4000','debit','2024-11-23 03:46:50','2025-10-11 23:18:49',NULL,'KES','000088'),('5c6e3e08-995a-4cd3-ac0e-8ca184dac0cd',70,0,0,NULL,NULL,'credit','2025-03-24 14:09:39','2025-03-24 14:09:39',NULL,'KES','000075'),('6050483c-a296-469a-b25c-dc1b430f5115',1,272,93,'fe9fe482-7342-490a-ad8d-32810da64fa3','10','debit','2024-08-30 06:53:16','2025-10-03 13:58:57',NULL,'KES','000086'),('60999427-47af-47ab-8cc0-1008c9fe8dee',97,77,77,'43c917a4-e3f4-4613-9793-4012e98bf1e4','50','debit','2025-09-25 07:50:05','2025-09-25 07:56:06',NULL,'KES','000085'),('65be33b3-54b5-4e13-a522-8018a4e256e6',29,0,0,NULL,NULL,'credit','2024-12-06 07:19:37','2024-12-06 07:19:37',NULL,'KES','000084'),('6829241c-50de-4a74-807a-767e345e5abb',5,0,0,NULL,NULL,'debit','2024-09-06 13:34:19','2024-09-06 13:34:19',NULL,'KES','000083'),('6c41b37d-8f6c-476b-b5c6-dfdd7ecd010f',74,70,70,'bf5d76ee-b345-4d57-8e79-2da484df59ee','20','debit','2025-04-25 09:40:20','2025-04-28 06:53:30',NULL,'KES','000082'),('7422d087-c48d-41a1-acac-0548e77c9601',91,0,0,NULL,NULL,'credit','2025-07-13 01:20:08','2025-07-13 01:20:08',NULL,'KES','000081'),('7704a2f3-6ba4-4ff7-9649-61fe864c6670',36,250,250,'a3b5e69c-f118-4ed8-a801-45e2fb19efd3','500','debit','2025-01-31 06:47:06','2025-03-01 12:15:35',NULL,'KES','000080'),('77a1bda5-61b8-4a66-a788-47492835ee53',52,0,0,NULL,NULL,'credit','2025-02-26 08:34:48','2025-02-26 08:34:48',NULL,'KES','000079'),('7814de8a-6d49-453a-b6b8-2f5ff987f5c7',28,0,0,NULL,NULL,'credit','2024-12-06 06:59:14','2024-12-06 06:59:14',NULL,'KES','000078'),('7892e0c0-82e1-4470-95a4-832bd32aadb5',19,27,27,'262d2161-8386-4f43-a979-f56d49e758d6','50','debit','2024-11-21 07:39:11','2024-12-16 02:58:02',NULL,'KES','000077'),('790cfd43-e252-4a79-9a73-3cee1e11c310',103,0,0,NULL,NULL,'credit','2025-10-24 00:23:12','2025-10-24 00:23:12',NULL,'KES','000076'),('79790043-3afd-4cba-b243-8c13e2040748',77,30,30,'ab9e603c-df00-4fd7-ac15-9b5158b0cff9','20','debit','2025-05-01 18:13:03','2025-05-02 10:09:26',NULL,'KES','000038'),('7b189393-1cb2-4dd7-957f-d71a23242001',57,0,0,NULL,NULL,'credit','2025-03-08 13:47:31','2025-03-08 13:47:31',NULL,'KES','000025'),('7d247bf1-1fd9-4303-aebc-787c2cfff434',101,0,0,NULL,NULL,'credit','2025-09-26 15:54:32','2025-09-26 15:54:32',NULL,'KES','000024'),('7f4e3288-bf27-413b-be4b-2cb2fd0fce3c',65,0,0,NULL,NULL,'credit','2025-03-22 05:55:38','2025-03-22 05:55:38',NULL,'KES','000023'),('860cb308-e9ea-4495-afc0-4d79239a62a2',79,100,100,'e388ceeb-a19a-4273-80dc-482691187f86','100','credit','2025-05-06 10:22:06','2025-05-06 10:31:16',NULL,'KES','000022'),('8882fc8c-7c9a-4e26-b8a3-3778c980e3c8',49,0,0,NULL,NULL,'credit','2025-02-17 17:20:18','2025-02-17 17:20:18',NULL,'KES','000021'),('89a1efda-7433-46d9-89d3-1d775eea738b',9,171815,160220,'8032b6b9-2076-4d1b-a766-c910d39df5cf','250','debit','2024-09-11 18:04:55','2025-11-06 12:41:36',NULL,'KES','000020'),('8bde5482-6b2a-4d18-a8f0-00a4a1abf4af',50,0,0,NULL,NULL,'credit','2025-02-24 03:36:32','2025-02-24 03:36:32',NULL,'KES','000019'),('8c728ee7-7c9f-42f5-a830-9bc9fddb966b',8,30,30,'66ed31ec-6c72-44b9-9155-66db6cf2ccbe','10','debit','2024-09-11 17:35:05','2024-09-23 04:00:29',NULL,'KES','000018'),('92c9c1fe-253e-4c47-849e-24af61cc9d62',13,90,90,'d7f8b489-deea-4814-8701-07b32ca00ff0','10','debit','2024-09-16 11:10:52','2024-09-16 11:26:36',NULL,'KES','000017'),('92eb0478-49ae-471b-ae10-9a614db591e7',55,0,0,NULL,NULL,'credit','2025-02-28 14:53:19','2025-02-28 14:53:19',NULL,'KES','000016'),('9896e300-9512-485e-8398-d6f15d4570d2',7,90,90,NULL,NULL,'debit','2024-09-08 17:08:54','2024-09-12 07:15:58',NULL,'KES','000015'),('9c691c79-c850-4133-ab1f-9cdb02b62567',83,0,0,NULL,NULL,'credit','2025-05-27 19:58:28','2025-05-27 19:58:28',NULL,'KES','000001'),('9cc18e4d-3fba-4990-9d2b-250903eaf13c',100,154,154,'59df7798-b2f7-4386-8d93-dd96a237a0f7','200','debit','2025-09-25 21:10:57','2025-10-21 07:29:04',NULL,'KES','000013'),('9d622f9d-18b2-43ca-af78-e3d7c590c8ef',58,0,0,NULL,NULL,'credit','2025-03-10 10:41:59','2025-03-10 10:41:59',NULL,'KES','000012'),('9eadf01d-be1e-4737-bf3d-8509043f39dd',43,5,5,'6366447d-5905-49f7-bf5b-424426ceab8a','1000','debit','2025-02-07 02:49:15','2025-02-07 09:07:40',NULL,'KES','000011'),('a0ec17f9-2429-4ef1-bec1-16ea4f7661e2',64,0,0,NULL,NULL,'credit','2025-03-21 19:19:12','2025-03-21 19:19:12',NULL,'KES','000010'),('a36193b5-611d-4f20-9d37-8094f1e655d8',33,0,0,NULL,NULL,'credit','2025-01-15 12:05:49','2025-01-15 12:05:49',NULL,'KES','000009'),('a534e714-ef69-4598-802f-6fad5bffa947',78,0,0,NULL,NULL,'credit','2025-05-02 10:10:09','2025-05-02 10:10:09',NULL,'KES','000008'),('aa5eb42e-7687-455e-bf48-466a6b064c04',82,0,0,NULL,NULL,'credit','2025-05-27 19:52:22','2025-05-27 19:52:22',NULL,'KES','000007'),('ae6c8953-e4e5-4592-9ae0-93998d0901bb',16,0,0,NULL,NULL,'credit','2024-11-04 11:09:43','2024-11-04 11:09:43',NULL,'KES','000006'),('af860a80-f742-491e-b390-4551308aff13',51,0,0,NULL,NULL,'credit','2025-02-24 12:33:46','2025-02-24 12:33:46',NULL,'KES','000005'),('b11efa11-0210-4a86-88af-6395eac44f9e',85,0,0,NULL,NULL,'credit','2025-06-11 15:04:09','2025-06-11 15:04:09',NULL,'KES','000004'),('b303ba2d-d139-4495-88a5-72b5d0470848',95,0,0,'1ff0ea1c-abc6-442b-ae24-d4a611839aad','50','debit','2025-09-13 16:52:35','2025-09-18 20:04:50',NULL,'KES','000003'),('b38c2c6e-ef8f-4c4f-89be-d0a0f7b17be3',68,0,0,NULL,NULL,'credit','2025-03-24 13:48:03','2025-03-24 13:48:03',NULL,'KES','000002'),('b4fa62e4-84a5-4d66-9f95-bfec2913ca54',99,2750,2750,'f60ab709-ee76-4501-ac50-07337aeead8a','2350','debit','2025-09-25 15:49:16','2025-10-18 15:47:09',NULL,'KES','000014'),('b6012e01-c5d2-4588-98b3-0bb7689b87bf',32,0,0,NULL,NULL,'credit','2025-01-10 06:42:39','2025-01-10 06:42:39',NULL,'KES','000049'),('bbcb5b4c-5edc-4c1f-8890-340cb52188ea',67,100,100,'2756a524-6b62-4b86-a26b-10a0f6b1c29f','10','debit','2025-03-24 13:27:30','2025-03-24 18:01:02',NULL,'KES','000048'),('c06d9e34-fa96-4a71-ab6f-c6f026c62f23',63,0,0,NULL,NULL,'credit','2025-03-21 18:13:22','2025-03-21 18:13:22',NULL,'KES','000047'),('c0f7c66d-a2f9-448d-916b-dce17bf1f7c0',86,0,0,NULL,NULL,'credit','2025-06-18 12:23:48','2025-06-18 12:23:48',NULL,'KES','000046'),('c9db65d5-aeab-41a5-aa05-33e2cfbc9f24',94,90,0,'673e83df-3ec9-45db-acb6-c607f0347291','800','debit','2025-08-27 22:41:01','2025-10-24 08:30:53',NULL,'KES','000045'),('c9e30883-63ae-494d-80c6-775fc5c78284',47,0,0,'0a193a35-5a07-43f1-a9f6-2aa793c0d187','390','debit','2025-02-17 17:09:16','2025-03-22 13:35:06',NULL,'KES','000044'),('cff62400-ecff-4aaa-9798-625f993e725e',98,0,0,NULL,NULL,'credit','2025-09-25 10:47:23','2025-09-25 10:47:23',NULL,'KES','000043'),('d0801d86-a096-4219-8a3c-dad0cf306605',17,0,0,NULL,NULL,'credit','2024-11-21 04:51:10','2024-11-21 04:51:10',NULL,'KES','000042'),('d1610e89-6f2e-4f70-9177-88b34419afa2',27,0,0,NULL,NULL,'credit','2024-12-03 11:53:21','2024-12-03 11:53:21',NULL,'KES','000041'),('d1b24d2a-f328-427c-9316-de38e7caa57b',54,0,0,NULL,NULL,'credit','2025-02-28 14:35:04','2025-02-28 14:35:04',NULL,'KES','000040'),('d8df185f-c5c6-4bb1-a7a7-9719a3da1cab',37,560,560,'4623ff17-ca1a-4345-b389-c09dbe1336b8','4000','debit','2025-02-01 10:08:15','2025-08-03 12:15:11',NULL,'KES','000039'),('d9fc1b5e-aa7a-4436-844f-d81ef0fe30db',10,110,100,'e0e94ac5-60f7-440f-932e-4b7882c2e279','11','debit','2024-09-11 18:27:59','2024-09-12 18:55:42',NULL,'KES','000026'),('daa4b8b7-52ee-4061-a92a-558d1e9a5881',15,0,0,NULL,NULL,'credit','2024-10-29 18:04:32','2024-10-29 18:04:32',NULL,'KES','000037'),('dbd974d1-6729-404b-96fe-e1a0019648bc',35,77,77,'a39ecbe9-cd4f-44be-b323-4096b134af7c','50','debit','2025-01-28 07:00:34','2025-01-28 11:24:51',NULL,'KES','000036'),('e2963132-8c46-4d72-a3e2-b5c16da1412f',41,0,0,NULL,NULL,'credit','2025-02-04 21:01:44','2025-02-04 21:01:44',NULL,'KES','000035'),('e4757489-a4d7-46c0-9d55-37a863f4684a',81,0,0,'1d544cb3-426b-4415-9673-cf8f2da5d79a','90','debit','2025-05-26 18:02:09','2025-05-31 18:39:49',NULL,'KES','000034'),('e77e8d6c-6b00-4152-b7b6-42eedaea0f34',73,0,0,NULL,NULL,'credit','2025-04-23 13:43:38','2025-04-23 13:43:38',NULL,'KES','000033'),('e8a14c11-4363-4478-a6bc-c5c7584d5330',46,0,0,NULL,NULL,'credit','2025-02-14 16:26:41','2025-02-14 16:26:41',NULL,'KES','000032'),('ea22dfa6-b81f-4274-9954-bb6fc8c16cdc',24,172,172,'f45fc647-b556-4b93-beb6-60269b837c25','10','debit','2024-11-28 12:59:46','2025-11-06 10:52:21',NULL,'KES','000031'),('edbe2784-26ef-40a0-8cb9-6d972d105a2c',69,0,0,NULL,NULL,'credit','2025-03-24 13:54:53','2025-03-24 13:54:53',NULL,'KES','000030'),('f0df85cf-1a62-47af-b27a-3f2e8c7696d1',66,0,0,NULL,NULL,'credit','2025-03-23 15:17:13','2025-03-23 15:17:13',NULL,'KES','000029'),('f838235d-be1c-4eca-ab07-a0050c2ec3c3',87,0,0,NULL,NULL,'credit','2025-06-18 14:44:02','2025-06-18 14:44:02',NULL,'KES','000028'),('fd82abb3-ec34-45b6-81b7-0d90fa39c1b1',34,80,80,'c709fad1-00e0-4092-9c31-ccf187227936','2000','debit','2025-01-27 04:41:43','2025-01-29 07:43:58',NULL,'KES','000027');


