-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Nov 05, 2025 at 08:50 AM
-- Server version: 8.0.42
-- PHP Version: 8.3.23

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `acbptxvs_branch_system`
--

-- --------------------------------------------------------

--
-- Table structure for table `repayments`
--

CREATE TABLE `repayments` (
  `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` decimal(12,2) NOT NULL,
  `payment_method` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mpesa_transaction_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mpesa_phone_number` varchar(17) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `receipt_number` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_date` datetime(6) NOT NULL,
  `created_at` datetime(6) NOT NULL,
  `loan` char(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `loan_id` char(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_source` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `repayments`
--

INSERT INTO `repayments` (`id`, `amount`, `payment_method`, `mpesa_transaction_id`, `mpesa_phone_number`, `receipt_number`, `payment_date`, `created_at`, `loan`, `loan_id`, `payment_source`) VALUES
('01a62d956b9841a9897e6d04419fd99d', 500.00, 'mpesa', NULL, NULL, 'RCP-20251002073609', '2025-10-01 07:35:00.000000', '2025-10-02 07:36:09.468237', NULL, 'adf9b5d364e1422b8d04e26c986dccf3', 'manual'),
('01ff6ff876d9488397b06ac2801f4385', 200.00, 'mpesa', NULL, NULL, 'RCP-20250908231310', '2025-09-08 23:13:00.000000', '2025-09-08 23:13:10.495107', NULL, '4a52bbdc1779460f86d5c4ba331622b6', 'manual'),
('055804370dce4d66ba2b4c4b21399407', 9000.00, 'mpesa', NULL, NULL, 'RCP-20250925122819', '2025-09-25 12:27:00.000000', '2025-09-25 12:28:19.184473', NULL, 'eb43beaf3bab4b5d82e636b7a0bb9c01', 'manual'),
('0582b94cdfa243849e98821ec36fa58d', 240.00, 'mpesa', NULL, NULL, 'RCP-20251026200501', '2025-10-24 20:04:00.000000', '2025-10-26 20:05:01.789809', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('0a83b4c3949243beac9d2ada0d233683', 240.00, 'mpesa', NULL, NULL, 'RCP-20251013100117', '2025-10-13 10:00:00.000000', '2025-10-13 10:01:17.143055', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('0adc673859634177a59e2c8cde1713d4', 800.00, 'mpesa', NULL, NULL, 'RCP-20250929081535', '2025-09-17 08:15:00.000000', '2025-09-29 08:15:35.994700', NULL, 'd381d856927d43be89355c5980d3e700', 'manual'),
('0f6d906635ae4924bc86e62306b7a28e', 563.00, 'mpesa', NULL, NULL, 'RCP-20250925110841', '2025-09-24 11:07:00.000000', '2025-09-25 11:08:41.323119', NULL, 'b7b2e3eb302a4410b0e0929178ac3695', 'manual'),
('0f851a26bcb14504b009d7ec3e3be119', 11300.00, 'mpesa', NULL, NULL, 'RCP-20250925111302', '2025-09-25 11:12:00.000000', '2025-09-25 11:13:02.500780', NULL, '3705d1a4b2084858bf0e104d062cb22c', 'manual'),
('0fd855a573c748e2a014ec9e1e335e29', 240.00, 'mpesa', NULL, NULL, 'RCP-20251010174514', '2025-10-10 17:44:00.000000', '2025-10-10 17:45:14.785877', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('1521317842d24410a39d63d6da0f7e1b', 2200.00, 'mpesa', NULL, NULL, 'RCP-20251026201513', '2025-10-22 20:14:00.000000', '2025-10-26 20:15:13.127316', NULL, '5982edb6f472409e9b533431496ecd49', 'manual'),
('168a7a79478c42568361ed0787d885ae', 563.00, 'mpesa', NULL, NULL, 'RCP-20251026200100', '2025-10-13 20:00:00.000000', '2025-10-26 20:01:00.606744', NULL, 'b7b2e3eb302a4410b0e0929178ac3695', 'manual'),
('19db44e3c4fb4dc1a16f1a5f27a14aca', 660.00, 'mpesa', NULL, NULL, 'RCP-20250918074126', '2025-09-17 07:41:00.000000', '2025-09-18 07:41:26.403604', NULL, 'a25bdc3db8f44a69a522bb925ba4cc74', 'manual'),
('1a5c2d3e82dd4ada9719d0eda9f3dc6f', 1600.00, 'mpesa', NULL, NULL, 'RCP-20250926094242', '2025-09-10 09:42:00.000000', '2025-09-26 09:42:42.240090', NULL, '65eeb18c641b488d8a5dc1a9a8964c71', 'manual'),
('1b6b7b7226ec48b4949686921560370b', 1000.00, 'mpesa', NULL, NULL, 'RCP-20251021081606', '2025-10-16 08:15:00.000000', '2025-10-21 08:16:06.495167', NULL, '0209a1fc348142048f9afc8d4dde5abc', 'manual'),
('1cad91246e49433ca6104704e08c64ad', 563.00, 'mpesa', NULL, NULL, 'RCP-20251005181235', '2025-10-03 18:12:00.000000', '2025-10-05 18:12:35.995273', NULL, 'b7b2e3eb302a4410b0e0929178ac3695', 'manual'),
('1ea6510e129b46bb843ddd860e97017d', 3000.00, 'mpesa', NULL, NULL, 'RCP-20250917080153', '2025-09-16 08:01:00.000000', '2025-09-17 08:01:53.686405', NULL, 'a25bdc3db8f44a69a522bb925ba4cc74', 'manual'),
('1ed6cc9d9e264fec9f4f322d0498b084', 40000.00, 'mpesa', NULL, NULL, 'RCP-20250925110522', '2025-09-20 11:05:00.000000', '2025-09-25 11:05:22.293886', NULL, 'b7b2e3eb302a4410b0e0929178ac3695', 'manual'),
('205bfac32c3040d8a77171e23f659dd4', 1000.00, 'mpesa', NULL, NULL, 'RCP-20251021081750', '2025-10-15 08:17:00.000000', '2025-10-21 08:17:50.057821', NULL, '0209a1fc348142048f9afc8d4dde5abc', 'manual'),
('2072d5a4ce7e446d81737693f7d8cf86', 200.00, 'mpesa', NULL, NULL, 'RCP-20250909072108', '2025-09-09 07:21:00.000000', '2025-09-09 07:21:08.533270', NULL, '4a52bbdc1779460f86d5c4ba331622b6', 'manual'),
('21e2f2ff03c84d8d9024fe3603b311a6', 3360.00, 'mpesa', NULL, NULL, 'RCP-20250926093914', '2025-08-16 09:38:00.000000', '2025-09-26 09:39:14.484389', NULL, '65eeb18c641b488d8a5dc1a9a8964c71', 'manual'),
('28db1c33123445fa8368cbc5a81b6e7c', 240.00, 'mpesa', NULL, NULL, 'RCP-20251026201349', '2025-09-29 20:13:00.000000', '2025-10-26 20:13:49.276822', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('29fbcc64642341b69fb4f34422fa0d2b', 1000.00, 'mpesa', NULL, NULL, 'RCP-20250925095513', '2025-09-23 09:55:00.000000', '2025-09-25 09:55:13.795390', NULL, '3705d1a4b2084858bf0e104d062cb22c', 'manual'),
('2a82fce4ee96420e81febeb28e703388', 563.00, 'mpesa', NULL, NULL, 'RCP-20251026195823', '2025-10-20 19:58:00.000000', '2025-10-26 19:58:23.582780', NULL, 'b7b2e3eb302a4410b0e0929178ac3695', 'manual'),
('2c0714c69dd5444fbc0b47115f56eed0', 240.00, 'mpesa', NULL, NULL, 'RCP-20250928132754', '2025-09-28 13:27:00.000000', '2025-09-28 13:27:54.454169', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('2d0c41b270454d46955e49eca7bb2121', 240.00, 'mpesa', NULL, NULL, 'RCP-20251005180557', '2025-10-04 18:05:00.000000', '2025-10-05 18:05:57.686341', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('31db17d7e0a64950aa29ca16d7638f56', 1200.00, 'mpesa', NULL, NULL, 'RCP-20250926094306', '2025-09-19 09:42:00.000000', '2025-09-26 09:43:06.566208', NULL, '65eeb18c641b488d8a5dc1a9a8964c71', 'manual'),
('33f9b3ecf095413fb61c6df587277991', 240.00, 'mpesa', NULL, NULL, 'RCP-20250920202622', '2025-09-20 20:26:00.000000', '2025-09-20 20:26:22.879507', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('34876fc467f74f8fa24bcfa834390ab1', 300.00, 'mpesa', NULL, NULL, 'RCP-20251007080712', '2025-10-07 08:06:00.000000', '2025-10-07 08:07:12.169036', NULL, '3a3e80165318459db8684afb0803592e', 'manual'),
('37a35df0909b438fbd5a97c7e981a6cc', 1080.00, 'mpesa', NULL, NULL, 'RCP-20251020094138', '2025-10-18 09:40:00.000000', '2025-10-20 09:41:38.125291', NULL, '089a2cefc22342f5b0363977291bcad0', 'manual'),
('3c486c2b102c4edd8936aebe5bf8e826', 240.00, 'mpesa', NULL, NULL, 'RCP-20250924105824', '2025-09-22 10:58:00.000000', '2025-09-24 10:58:24.079868', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('41c02a2190244a35861d876792c9d532', 24400.00, 'mpesa', NULL, NULL, 'RCP-20251020132220', '2025-10-18 13:21:00.000000', '2025-10-20 13:22:20.805511', NULL, '83b18374798543a0802637963d3c2ab1', 'manual'),
('44775eff7e8f488eace0795a5f5d53a8', 1000.00, 'mpesa', NULL, NULL, 'RCP-20250925095457', '2025-09-22 09:54:00.000000', '2025-09-25 09:54:57.696711', NULL, '3705d1a4b2084858bf0e104d062cb22c', 'manual'),
('486d27a33f564e25a9fae015519191c1', 400.00, 'mpesa', NULL, NULL, 'RCP-20251020100444', '2025-10-17 10:04:00.000000', '2025-10-20 10:04:44.170091', NULL, 'b7a7dc48f2ea42bca631ac0f1fff972d', 'manual'),
('490e55f7d363465aa97cb66d39a8939c', 563.00, 'mpesa', NULL, NULL, 'RCP-20251005204715', '2025-10-05 20:46:00.000000', '2025-10-05 20:47:15.288921', NULL, 'b7b2e3eb302a4410b0e0929178ac3695', 'manual'),
('49ffaa44726546aab2d1194e4211fc0f', 100.00, 'mpesa', NULL, NULL, 'RCP-20251010175238', '2025-10-10 17:52:00.000000', '2025-10-10 17:52:38.944872', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('4dc6b86e418640c0959e222646bc63e6', 4400.00, 'mpesa', NULL, NULL, 'RCP-20250925114903', '2025-09-25 11:45:00.000000', '2025-09-25 11:49:03.413229', NULL, '5bf38bb079d44992b1d69b516bd91c1c', 'manual'),
('4eb727a5a8094173a6b581cdbbc03520', 200.00, 'mpesa', NULL, NULL, 'RCP-20250908235106', '2025-09-08 23:51:00.000000', '2025-09-08 23:51:06.987254', NULL, '4a52bbdc1779460f86d5c4ba331622b6', 'manual'),
('4ee4a762f13f47c3b53dadf400e0a4de', 300.00, 'mpesa', NULL, NULL, 'RCP-20251003074723', '2025-10-02 07:47:00.000000', '2025-10-03 07:47:23.306815', NULL, '3a3e80165318459db8684afb0803592e', 'manual'),
('50eab3eadee5459891e3ec578534fe6a', 1000.00, 'mpesa', NULL, NULL, 'RCP-20251020173704', '2025-10-20 17:36:00.000000', '2025-10-20 17:37:04.142859', NULL, 'fc248ff7a9464af6afdc2f8b62460448', 'manual'),
('524108ffc58c41dfa46f652b700a50a5', 240.00, 'mpesa', NULL, NULL, 'RCP-20250924105055', '2025-09-24 10:50:00.000000', '2025-09-24 10:50:55.719109', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('54616cf7649643fd9c0e26fc73a9d2b5', 563.00, 'mpesa', NULL, NULL, 'RCP-20251026195856', '2025-10-18 19:58:00.000000', '2025-10-26 19:58:56.472545', NULL, 'b7b2e3eb302a4410b0e0929178ac3695', 'manual'),
('5467a5a27b7848ee833528b24bcdbaad', 265.00, 'mpesa', NULL, NULL, 'RCP-000002', '2025-08-05 09:51:21.916262', '2025-08-05 09:51:21.916278', NULL, '63a16a96cc8e4fd3ac560c278951bbf0', 'manual'),
('5501c8f8fd6f414283f150f826812da1', 200.00, 'mpesa', NULL, NULL, 'RCP-20250909000533', '2025-09-09 00:05:00.000000', '2025-09-09 00:05:33.645527', NULL, '4a52bbdc1779460f86d5c4ba331622b6', 'manual'),
('55b921837f144feca651c9241dcdc6b6', 240.00, 'mpesa', NULL, NULL, 'RCP-20251001075619', '2025-09-30 07:55:00.000000', '2025-10-01 07:56:19.733292', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('5fe47ca335f04529a2c295b34cbb2cbd', 810.00, 'mpesa', NULL, NULL, 'RCP-20251014081739', '2025-10-12 08:17:00.000000', '2025-10-14 08:17:39.268114', NULL, '089a2cefc22342f5b0363977291bcad0', 'manual'),
('6097f778049e4801bcdad93a1eb6289e', 563.00, 'mpesa', NULL, NULL, 'RCP-20251026195723', '2025-10-22 19:57:00.000000', '2025-10-26 19:57:23.206952', NULL, 'b7b2e3eb302a4410b0e0929178ac3695', 'manual'),
('6114968b79504afab4d11d6db7319194', 240.00, 'mpesa', NULL, NULL, 'RCP-20251026200332', '2025-10-26 20:03:00.000000', '2025-10-26 20:03:32.264232', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('61a3ab32d89745a18eb5e12191e1f369', 563.00, 'mpesa', NULL, NULL, 'RCP-20251001080721', '2025-09-30 08:06:00.000000', '2025-10-01 08:07:21.377808', NULL, 'b7b2e3eb302a4410b0e0929178ac3695', 'manual'),
('6571dc502ed94537b03c53256ae10d4b', 563.00, 'mpesa', NULL, NULL, 'RCP-20251010180025', '2025-10-09 18:00:00.000000', '2025-10-10 18:00:25.766804', NULL, 'b7b2e3eb302a4410b0e0929178ac3695', 'manual'),
('6577cc6c91f94749bd30cdc06be4aec8', 563.00, 'mpesa', NULL, NULL, 'RCP-20251002073448', '2025-10-01 07:34:00.000000', '2025-10-02 07:34:48.170572', NULL, 'b7b2e3eb302a4410b0e0929178ac3695', 'manual'),
('66214c00eae44ce085d6902505ce3b94', 240.00, 'mpesa', NULL, NULL, 'RCP-20251026201153', '2025-10-18 20:11:00.000000', '2025-10-26 20:11:53.156358', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('6751f6752fa746fbb7698a9763369a18', 563.00, 'mpesa', NULL, NULL, 'RCP-20251026195954', '2025-10-15 19:59:00.000000', '2025-10-26 19:59:54.679300', NULL, 'b7b2e3eb302a4410b0e0929178ac3695', 'manual'),
('67d92054c3724050bfa3ba6e35bbd806', 240.00, 'mpesa', NULL, NULL, 'RCP-20251008080818', '2025-10-07 08:08:00.000000', '2025-10-08 08:08:18.025736', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('6895a707c09740b3bf428f380bc59442', 270.00, 'mpesa', NULL, NULL, 'RCP-20251007080924', '2025-10-06 08:09:00.000000', '2025-10-07 08:09:24.598044', NULL, '089a2cefc22342f5b0363977291bcad0', 'manual'),
('6c2e2bc21f7a4fd18b9447c4d69ca1b5', 400.00, 'mpesa', NULL, NULL, 'RCP-20251020100315', '2025-10-14 10:02:00.000000', '2025-10-20 10:03:15.195702', NULL, 'b7a7dc48f2ea42bca631ac0f1fff972d', 'manual'),
('6fac42152e6c4cffbfbedd50d88085f1', 200.00, 'mpesa', NULL, NULL, 'RCP-000006', '2025-09-04 07:42:00.000000', '2025-09-04 07:42:48.680862', NULL, '4a52bbdc1779460f86d5c4ba331622b6', 'manual'),
('70e8b72867204fa08dab4a4c3b870cb1', 1.00, 'mpesa', 'TK5019CLK2', '99193bd8110f876a9', 'RCP-000007', '2025-11-05 08:07:48.000000', '2025-11-05 08:21:44.544543', NULL, 'fba983d353a24a728945da7df2da0f29', 'automatic'),
('736fd4c616aa4ab4bbfeb77f4e56282c', 12200.00, 'mpesa', NULL, NULL, 'RCP-20251008080225', '2025-10-07 08:02:00.000000', '2025-10-08 08:02:25.030673', NULL, '8a14096c75d44f79a1da5c9e552884b7', 'manual'),
('74a84b788c5c463387530c436b9d62c9', 500.00, 'mpesa', NULL, NULL, 'RCP-20251028080907', '2025-10-27 08:08:00.000000', '2025-10-28 08:09:07.748311', NULL, '6c658c20464c49d8bc68c240d70b8584', 'manual'),
('777398279189423daa20a28b546fd252', 240.00, 'mpesa', NULL, NULL, 'RCP-20251026201212', '2025-10-19 20:12:00.000000', '2025-10-26 20:12:12.501322', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('778cb4bad1454873a25f8edbb2170762', 1400.00, 'mpesa', NULL, NULL, 'RCP-20250929081648', '2025-09-25 08:16:00.000000', '2025-09-29 08:16:48.020176', NULL, 'd381d856927d43be89355c5980d3e700', 'manual'),
('77e49552e62841b6b194c887bda3c783', 6000.00, 'mpesa', NULL, NULL, 'RCP-20251026195755', '2025-10-21 19:57:00.000000', '2025-10-26 19:57:55.702602', NULL, 'b7b2e3eb302a4410b0e0929178ac3695', 'manual'),
('793009d9fdd249738b590946ab08cae3', 4800.00, 'mpesa', NULL, NULL, 'RCP-20250926091031', '2025-08-30 09:09:00.000000', '2025-09-26 09:10:31.694313', NULL, '20174522acf149a787a1558663516793', 'manual'),
('7c2df889c8df4f408546497019a23ccb', 240.00, 'mpesa', NULL, NULL, 'RCP-20251026201102', '2025-10-20 20:10:00.000000', '2025-10-26 20:11:02.178173', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('7e0d9f2fbd834947bbce3357e33fc52e', 240.00, 'mpesa', NULL, NULL, 'RCP-20251005175914', '2025-10-05 17:58:00.000000', '2025-10-05 17:59:14.408064', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('7f307c64201d4471b873a807b84fee86', 500.00, 'mpesa', NULL, NULL, 'RCP-20251001080116', '2025-09-30 08:01:00.000000', '2025-10-01 08:01:16.702436', NULL, 'adf9b5d364e1422b8d04e26c986dccf3', 'manual'),
('816d5e5287d04e19abd42ad5ac38fcd8', 200.00, 'mpesa', NULL, NULL, 'RCP-000005', '2025-09-02 16:13:00.000000', '2025-09-02 16:13:46.352275', NULL, '4a52bbdc1779460f86d5c4ba331622b6', 'manual'),
('81de8875d7d44cafa5514430396ab828', 20000.00, 'mpesa', NULL, NULL, 'RCP-20250925085109', '2025-09-19 08:50:00.000000', '2025-09-25 08:51:09.947973', NULL, '089a2cefc22342f5b0363977291bcad0', 'manual'),
('8207af0a7b074c759af91f8f69af5f7b', 3360.00, 'mpesa', NULL, NULL, 'RCP-20250926093946', '2025-08-23 09:39:00.000000', '2025-09-26 09:39:46.818253', NULL, '65eeb18c641b488d8a5dc1a9a8964c71', 'manual'),
('82d514d2ba4245faa6eb3100942a8991', 270.00, 'mpesa', NULL, NULL, 'RCP-20251003073831', '2025-10-02 07:38:00.000000', '2025-10-03 07:38:31.376151', NULL, '089a2cefc22342f5b0363977291bcad0', 'manual'),
('82d8fabe7f5a4c71ae3c00cf56a84850', 400.00, 'mpesa', NULL, NULL, 'RCP-20251020100501', '2025-10-18 10:04:00.000000', '2025-10-20 10:05:01.548326', NULL, 'b7a7dc48f2ea42bca631ac0f1fff972d', 'manual'),
('834fa4f8894246acb889e8318d580c85', 400.00, 'mpesa', NULL, NULL, 'RCP-20251020100339', '2025-10-15 10:03:00.000000', '2025-10-20 10:03:39.034751', NULL, 'b7a7dc48f2ea42bca631ac0f1fff972d', 'manual'),
('83c4d187b28e41ee888a8dd7a42ef9d6', 240.00, 'mpesa', NULL, NULL, 'RCP-20250928135036', '2025-09-26 13:50:00.000000', '2025-09-28 13:50:36.435845', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('84ff70de7c524e90aac19a54e308b1ec', 563.00, 'mpesa', NULL, NULL, 'RCP-20250928133433', '2025-09-27 13:34:00.000000', '2025-09-28 13:34:33.680350', NULL, 'b7b2e3eb302a4410b0e0929178ac3695', 'manual'),
('850a20884196442c953d53a1c6c69109', 240.00, 'mpesa', NULL, NULL, 'RCP-20251026200627', '2025-10-22 20:06:00.000000', '2025-10-26 20:06:27.801587', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('854e54db8914400cb81cd5342ca06250', 9600.00, 'mpesa', NULL, NULL, 'RCP-20251027074844', '2025-10-21 07:48:00.000000', '2025-10-27 07:48:44.614409', NULL, '20174522acf149a787a1558663516793', 'manual'),
('857752dc6ba44d05b0a12ab46900c1b8', 240.00, 'mpesa', NULL, NULL, 'RCP-20251026201037', '2025-10-16 20:10:00.000000', '2025-10-26 20:10:37.709523', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('85ccc358c502472d959bca66ef3f8a9f', 1000.00, 'mpesa', NULL, NULL, 'RCP-20251028081053', '2025-10-24 08:10:00.000000', '2025-10-28 08:10:53.268653', NULL, '6c658c20464c49d8bc68c240d70b8584', 'manual'),
('86ff33c3dca249a18329132e4fbdd38b', 200.00, 'mpesa', NULL, NULL, 'RCP-000004', '2025-08-31 07:48:00.000000', '2025-09-01 07:48:35.645144', NULL, '4a52bbdc1779460f86d5c4ba331622b6', 'manual'),
('8ace9bc84f4f4671a03a426e03c6173e', 500.00, 'mpesa', NULL, NULL, 'RCP-20251010180323', '2025-10-08 18:03:00.000000', '2025-10-10 18:03:23.743204', NULL, 'adf9b5d364e1422b8d04e26c986dccf3', 'manual'),
('8b2e3ce99ec44424b9d0a7d5059478b7', 240.00, 'mpesa', NULL, NULL, 'RCP-20251010180737', '2025-10-08 18:07:00.000000', '2025-10-10 18:07:37.863555', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('8cfb42ca82f441be923f6dd2420d48d2', 300.00, 'mpesa', NULL, NULL, 'RCP-20251003074631', '2025-10-03 07:46:00.000000', '2025-10-03 07:46:31.864269', NULL, '3a3e80165318459db8684afb0803592e', 'manual'),
('8ef73f32bc6b4e8a986ea5027c4b4d41', 120.00, 'cash', NULL, NULL, 'RCP-000001', '2025-08-04 06:22:17.122520', '2025-08-04 06:22:17.122541', NULL, '0f3a8c37afd7474d8e9448a44fa2220b', 'manual'),
('8f7958cb219b4f3dae53e07027685d81', 4270.00, 'mpesa', NULL, NULL, 'RCP-20251103073647', '2025-11-02 07:35:00.000000', '2025-11-03 07:36:47.203593', NULL, 'd1ccacc964554b92bfe365554dacdf9f', 'manual'),
('91ae5123aa024bfca2f7695e20743d73', 563.00, 'mpesa', NULL, NULL, 'RCP-20251010211326', '2025-10-10 21:13:00.000000', '2025-10-10 21:13:26.770589', NULL, 'b7b2e3eb302a4410b0e0929178ac3695', 'manual'),
('93139dadfa934882894873c3e392fa6a', 563.00, 'mpesa', NULL, NULL, 'RCP-20250928134645', '2025-09-26 13:46:00.000000', '2025-09-28 13:46:45.783904', NULL, 'b7b2e3eb302a4410b0e0929178ac3695', 'manual'),
('9453a6da89044e6c9ad8ce5cecc77f4f', 240.00, 'mpesa', NULL, NULL, 'RCP-20251104142537', '2025-11-04 14:24:00.000000', '2025-11-04 14:25:37.620429', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('9478538d80f8485bb2a88e2007d6f823', 1000.00, 'mpesa', NULL, NULL, 'RCP-20250925095352', '2025-09-15 09:53:00.000000', '2025-09-25 09:53:52.106088', NULL, '3705d1a4b2084858bf0e104d062cb22c', 'manual'),
('96898a9200d14e02bbe2bcbef7afd318', 1000.00, 'mpesa', NULL, NULL, 'RCP-20251028081031', '2025-10-23 08:10:00.000000', '2025-10-28 08:10:31.177264', NULL, '6c658c20464c49d8bc68c240d70b8584', 'manual'),
('96b568f501a54b3893ee2d389a7f0d3c', 563.00, 'mpesa', NULL, NULL, 'RCP-20251007081001', '2025-10-06 08:09:00.000000', '2025-10-07 08:10:01.159082', NULL, 'b7b2e3eb302a4410b0e0929178ac3695', 'manual'),
('97301e5e8c2a41c39e21e3444a8ca667', 500.00, 'mpesa', NULL, NULL, 'RCP-20251005181121', '2025-10-03 18:10:00.000000', '2025-10-05 18:11:21.789086', NULL, 'adf9b5d364e1422b8d04e26c986dccf3', 'manual'),
('97996f61dd604850ac3e7b699b31b817', 300.00, 'mpesa', NULL, NULL, 'RCP-20251002073338', '2025-10-01 07:33:00.000000', '2025-10-02 07:33:38.053863', NULL, '3a3e80165318459db8684afb0803592e', 'manual'),
('984835b83a914f02a2f933c2c81482c9', 500.00, 'mpesa', NULL, NULL, 'RCP-20251005180012', '2025-10-05 17:59:00.000000', '2025-10-05 18:00:12.532435', NULL, 'adf9b5d364e1422b8d04e26c986dccf3', 'manual'),
('99d4e36bd2b34a549cf79b42d27ea4b9', 9000.00, 'mpesa', NULL, NULL, 'RCP-20250925123121', '2025-09-25 12:31:00.000000', '2025-09-25 12:31:21.883476', NULL, 'ab262137c6bc499aa025c684b1988db6', 'manual'),
('9b264275aa3745a2acb5c994a7b56b69', 400.00, 'mpesa', NULL, NULL, 'RCP-20251021082354', '2025-10-20 08:23:00.000000', '2025-10-21 08:23:54.340774', NULL, 'b7a7dc48f2ea42bca631ac0f1fff972d', 'manual'),
('9b2e6ab3c6594bbaa597acb54d07b56e', 10785.00, 'mpesa', NULL, NULL, 'RCP-20251006075450', '2025-10-03 07:54:00.000000', '2025-10-06 07:54:50.556744', NULL, '63a16a96cc8e4fd3ac560c278951bbf0', 'manual'),
('9cbd87b1215e4f0baec19c6da2619410', 270.00, 'mpesa', NULL, NULL, 'RCP-20251002073657', '2025-10-01 07:36:00.000000', '2025-10-02 07:36:57.298604', NULL, '089a2cefc22342f5b0363977291bcad0', 'manual'),
('9cf49d9ef58e4255ac5ea42547bcfcf3', 4200.00, 'mpesa', NULL, NULL, 'RCP-20251027075128', '2025-10-21 07:51:00.000000', '2025-10-27 07:51:28.114455', NULL, '20174522acf149a787a1558663516793', 'manual'),
('9d0bbacf0d4c4629bc9b35cf09ef73a8', 1000.00, 'mpesa', NULL, NULL, 'RCP-20251028080959', '2025-10-21 08:09:00.000000', '2025-10-28 08:09:59.123646', NULL, '6c658c20464c49d8bc68c240d70b8584', 'manual'),
('a290c8bea6ce404b98d33b4c05063cdf', 563.00, 'mpesa', NULL, NULL, 'RCP-20251012170120', '2025-10-11 17:01:00.000000', '2025-10-12 17:01:20.091474', NULL, 'b7b2e3eb302a4410b0e0929178ac3695', 'manual'),
('a3fed40b7c034c0fb5b030f64fd39b8a', 540.00, 'mpesa', NULL, NULL, 'RCP-20251007082432', '2025-10-05 08:24:00.000000', '2025-10-07 08:24:32.399026', NULL, '089a2cefc22342f5b0363977291bcad0', 'manual'),
('a41d70cbbfb34d50a2ff91f83ce623db', 1000.00, 'mpesa', NULL, NULL, 'RCP-20251021081643', '2025-10-19 08:16:00.000000', '2025-10-21 08:16:43.509180', NULL, '0209a1fc348142048f9afc8d4dde5abc', 'manual'),
('a4577efd0c094c09a5df1fd9edc791b1', 4850.00, 'mpesa', NULL, NULL, 'RCP-20250909072137', '2025-09-09 07:21:00.000000', '2025-09-09 07:21:37.871156', NULL, '4a52bbdc1779460f86d5c4ba331622b6', 'manual'),
('a6abd9574c554a43a9df3eb726fc7a79', 1080.00, 'mpesa', NULL, NULL, 'RCP-20251105081358', '2025-11-04 08:13:00.000000', '2025-11-05 08:13:58.126387', NULL, '089a2cefc22342f5b0363977291bcad0', 'manual'),
('a6e59b3b8aea4ad7bf8bef4d41b998f2', 240.00, 'mpesa', NULL, NULL, 'RCP-20250924105522', '2025-09-23 10:55:00.000000', '2025-09-24 10:55:22.769272', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('a85c096af894448dbe2cc57c7a23a7c2', 240.00, 'mpesa', NULL, NULL, 'RCP-20251003074914', '2025-10-02 07:48:00.000000', '2025-10-03 07:49:14.199897', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('aedd3a2859cb4cbd97debfa92fa5cb41', 270.00, 'mpesa', NULL, NULL, 'RCP-20251010180441', '2025-10-08 18:04:00.000000', '2025-10-10 18:04:41.901410', NULL, '089a2cefc22342f5b0363977291bcad0', 'manual'),
('af27102e64f04fb09933b6e9a67c5e7a', 240.00, 'mpesa', NULL, NULL, 'RCP-20251026200411', '2025-10-25 20:04:00.000000', '2025-10-26 20:04:11.952901', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('b21cc03525b1467b8050ed6572f69d85', 500.00, 'mpesa', NULL, NULL, 'RCP-20251010222228', '2025-10-10 22:22:00.000000', '2025-10-10 22:22:28.022318', NULL, 'adf9b5d364e1422b8d04e26c986dccf3', 'manual'),
('b280aa3a39f849f6980c49aed01059b2', 240.00, 'mpesa', NULL, NULL, 'RCP-20251026201021', '2025-10-15 20:10:00.000000', '2025-10-26 20:10:21.532214', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('b4f01e87ca8f45b8805e30dea74075e7', 563.00, 'mpesa', NULL, NULL, 'RCP-20251026195927', '2025-10-16 19:59:00.000000', '2025-10-26 19:59:27.277905', NULL, 'b7b2e3eb302a4410b0e0929178ac3695', 'manual'),
('b80d2b9facb84b57a395465164759f17', 240.00, 'mpesa', NULL, NULL, 'RCP-20250925085314', '2025-09-25 08:52:00.000000', '2025-09-25 08:53:14.593012', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('b93bab857c074ca7800a847b1a1569e5', 1000.00, 'mpesa', NULL, NULL, 'RCP-20251028081016', '2025-10-22 08:10:00.000000', '2025-10-28 08:10:16.893208', NULL, '6c658c20464c49d8bc68c240d70b8584', 'manual'),
('b9e1e6bf738641d0a089c0b29deefcf5', 3500.00, 'mpesa', NULL, NULL, 'RCP-20251021081544', '2025-10-13 08:15:00.000000', '2025-10-21 08:15:44.033664', NULL, '0209a1fc348142048f9afc8d4dde5abc', 'manual'),
('ba46d8b819234753b8e0fd4c1408f73e', 240.00, 'mpesa', NULL, NULL, 'RCP-20251014105540', '2025-10-14 10:55:00.000000', '2025-10-14 10:55:40.472176', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('bad5888cd28e48f79f2bc7bcb165deef', 4800.00, 'mpesa', NULL, NULL, 'RCP-20250926091134', '2025-09-25 09:11:00.000000', '2025-09-26 09:11:34.037694', NULL, '20174522acf149a787a1558663516793', 'manual'),
('bb01998f81ba4df9b4fa9a2920b7bf9c', 1.00, 'mpesa', NULL, NULL, 'RCP-000003', '2025-09-01 05:01:00.000000', '2025-09-01 05:02:01.137435', NULL, '7af37c3490fd4a1c92dadc847a9b375d', 'manual'),
('bd317901ada24d75922af4d18199df34', 563.00, 'mpesa', NULL, NULL, 'RCP-20251026195634', '2025-10-24 19:56:00.000000', '2025-10-26 19:56:34.529782', NULL, 'b7b2e3eb302a4410b0e0929178ac3695', 'manual'),
('bd993532f4ab46809c030e46f77bafae', 2080.00, 'mpesa', NULL, NULL, 'RCP-20251024093202', '2025-10-24 09:31:00.000000', '2025-10-24 09:32:02.824113', NULL, 'b7a7dc48f2ea42bca631ac0f1fff972d', 'manual'),
('be6da5dc47ec41cba671c0698fdfb245', 2600.00, 'mpesa', NULL, NULL, 'RCP-20251010171022', '2025-10-10 17:10:00.000000', '2025-10-10 17:10:22.047244', NULL, '65eeb18c641b488d8a5dc1a9a8964c71', 'manual'),
('bf7d57de4f6543c68fdea14a7e2ceb2e', 7200.00, 'mpesa', NULL, NULL, 'RCP-20251009075521', '2025-09-29 07:55:00.000000', '2025-10-09 07:55:21.224911', NULL, '10f6495305c94f8bb1cdc8bfbbbd3a40', 'manual'),
('c337f03adfbe4751915a8f8dd2d07f75', 1000.00, 'mpesa', NULL, NULL, 'RCP-20251020174023', '2025-10-18 17:40:00.000000', '2025-10-20 17:40:23.115549', NULL, '6c658c20464c49d8bc68c240d70b8584', 'manual'),
('c4365638dd8e490995b648eb859c1c10', 1070.00, 'mpesa', NULL, NULL, 'RCP-20251021093428', '2025-10-20 09:33:00.000000', '2025-10-21 09:34:28.610312', NULL, '6b937139c2974b3ab350aa7ae1f51c88', 'manual'),
('c55b9f8d55ac488e99619d6470614c77', 24400.00, 'mpesa', NULL, NULL, 'RCP-20250925114458', '2025-09-25 11:44:00.000000', '2025-09-25 11:44:58.652138', NULL, '5bf38bb079d44992b1d69b516bd91c1c', 'manual'),
('c610b6d88bd541b1bd4676d4430fa835', 563.00, 'mpesa', NULL, NULL, 'RCP-20251008080438', '2025-10-07 08:04:00.000000', '2025-10-08 08:04:38.490453', NULL, 'b7b2e3eb302a4410b0e0929178ac3695', 'manual'),
('c691bbc8bafe4bff892478ca40f0dccd', 240.00, 'mpesa', NULL, NULL, 'RCP-20250919090223', '2025-09-19 09:02:00.000000', '2025-09-19 09:02:23.869505', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('c82f4a739a4f4e5eb818f7424f00839e', 240.00, 'mpesa', NULL, NULL, 'RCP-20251012165624', '2025-10-12 16:56:00.000000', '2025-10-12 16:56:24.267457', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('c948470fe9014747b44ebbc497aaeb0f', 1000.00, 'mpesa', NULL, NULL, 'RCP-20250925095439', '2025-09-20 09:54:00.000000', '2025-09-25 09:54:39.694526', NULL, '3705d1a4b2084858bf0e104d062cb22c', 'manual'),
('c9a484c40aa94a8da7b7aac05521840b', 563.00, 'mpesa', NULL, NULL, 'RCP-20251026194320', '2025-10-25 19:43:00.000000', '2025-10-26 19:43:20.920691', NULL, 'b7b2e3eb302a4410b0e0929178ac3695', 'manual'),
('c9f1515bb68a404b891952006a30de50', 240.00, 'mpesa', NULL, NULL, 'RCP-20251026201134', '2025-10-17 20:11:00.000000', '2025-10-26 20:11:34.655059', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('d07b4f3f548348a5bab72bac774c2257', 1000.00, 'mpesa', NULL, NULL, 'RCP-20250925095417', '2025-09-18 09:53:00.000000', '2025-09-25 09:54:17.169542', NULL, '3705d1a4b2084858bf0e104d062cb22c', 'manual'),
('d140ba7e8e0641a79ce49e8eeef610d4', 240.00, 'mpesa', NULL, NULL, 'RCP-20251021165101', '2025-10-21 16:50:00.000000', '2025-10-21 16:51:01.743312', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('d44f083153da453f9c36a596ca336356', 900.00, 'mpesa', NULL, NULL, 'RCP-20251021081111', '2025-10-21 08:10:00.000000', '2025-10-21 08:11:11.781146', NULL, '0209a1fc348142048f9afc8d4dde5abc', 'manual'),
('d5aa4684c38640d0911f11f947748c90', 240.00, 'mpesa', NULL, NULL, 'RCP-20250918074503', '2025-09-17 07:44:00.000000', '2025-09-18 07:45:03.876312', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('d6aa92386c004e898835a3096b962969', 300.00, 'mpesa', NULL, NULL, 'RCP-20251005180134', '2025-10-05 18:00:00.000000', '2025-10-05 18:01:34.552668', NULL, '3a3e80165318459db8684afb0803592e', 'manual'),
('d788a9d8779c457baa0731917e06ecc0', 563.00, 'mpesa', NULL, NULL, 'RCP-20250925110713', '2025-09-23 11:06:00.000000', '2025-09-25 11:07:13.647414', NULL, 'b7b2e3eb302a4410b0e0929178ac3695', 'manual'),
('d79aa7da1d2e42f4b62cd85c5e558e9a', 500.00, 'mpesa', NULL, NULL, 'RCP-20251001080045', '2025-09-29 08:00:00.000000', '2025-10-01 08:00:45.699309', NULL, 'adf9b5d364e1422b8d04e26c986dccf3', 'manual'),
('d7b69f8385b349a484db8354d91e7bc6', 1000.00, 'mpesa', NULL, NULL, 'RCP-20251010224724', '2025-10-10 22:47:00.000000', '2025-10-10 22:47:24.183075', NULL, '4ce45a85b954482da50039d1fe821d0f', 'manual'),
('d85324232bbd4644b7fd81ae94134fe1', 240.00, 'mpesa', NULL, NULL, 'RCP-20250918130956', '2025-09-18 13:09:00.000000', '2025-09-18 13:09:56.336946', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('d95bc28185b14ca3a0437dfd2382d541', 563.00, 'mpesa', NULL, NULL, 'RCP-20251003074500', '2025-10-02 07:44:00.000000', '2025-10-03 07:45:00.244819', NULL, 'b7b2e3eb302a4410b0e0929178ac3695', 'manual'),
('daa8142b101b4b3ca79394e714db0698', 240.00, 'mpesa', NULL, NULL, 'RCP-20250922080126', '2025-09-21 08:01:00.000000', '2025-09-22 08:01:26.429798', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('dbfaef74744844d8a4c91c79082c1ef4', 500.00, 'mpesa', NULL, NULL, 'RCP-20251007081937', '2025-10-06 08:19:00.000000', '2025-10-07 08:19:37.200620', NULL, 'adf9b5d364e1422b8d04e26c986dccf3', 'manual'),
('dc977fd3a0fb4460a50a27df4a366213', 500.00, 'mpesa', NULL, NULL, 'RCP-20251104142904', '2025-11-04 14:28:00.000000', '2025-11-04 14:29:04.444537', NULL, 'adf9b5d364e1422b8d04e26c986dccf3', 'manual'),
('ddbdf7b2928d4b68abda9110d91e08ba', 400.00, 'mpesa', NULL, NULL, 'RCP-20251020100405', '2025-10-16 10:03:00.000000', '2025-10-20 10:04:05.880892', NULL, 'b7a7dc48f2ea42bca631ac0f1fff972d', 'manual'),
('de996c7bed8e4765b6c7482ecc1ef13b', 240.00, 'mpesa', NULL, NULL, 'RCP-20250928134029', '2025-09-27 13:40:00.000000', '2025-09-28 13:40:29.769851', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('dee6da59bdec460e9b929eed0a0143cf', 4800.00, 'mpesa', NULL, NULL, 'RCP-20251027074804', '2025-10-15 07:47:00.000000', '2025-10-27 07:48:04.904659', NULL, '20174522acf149a787a1558663516793', 'manual'),
('df375e8065d3451894d81b5d4fd90b63', 1080.00, 'mpesa', NULL, NULL, 'RCP-20251026194226', '2025-10-25 19:42:00.000000', '2025-10-26 19:42:26.287662', NULL, '089a2cefc22342f5b0363977291bcad0', 'manual'),
('e05fbb9a98084d60b38332322229cc3b', 4800.00, 'mpesa', NULL, NULL, 'RCP-20250926091115', '2025-09-09 09:10:00.000000', '2025-09-26 09:11:15.722810', NULL, '20174522acf149a787a1558663516793', 'manual'),
('e17b82384c9e4d37855ce134aaa89909', 1000.00, 'mpesa', NULL, NULL, 'RCP-20251020174004', '2025-10-20 17:39:00.000000', '2025-10-20 17:40:04.545879', NULL, '6c658c20464c49d8bc68c240d70b8584', 'manual'),
('e3da0db38f22472794b8331feeaf0618', 880.00, 'mpesa', NULL, NULL, 'RCP-20250909083637', '2025-08-28 08:35:00.000000', '2025-09-09 08:36:37.882425', NULL, '0f3a8c37afd7474d8e9448a44fa2220b', 'manual'),
('e4ae5eceab2e4340aec3bdc984497dd1', 600.00, 'mpesa', NULL, NULL, 'RCP-20250929081610', '2025-09-22 08:15:00.000000', '2025-09-29 08:16:10.555861', NULL, 'd381d856927d43be89355c5980d3e700', 'manual'),
('e8a7d7ebc690406bb2179bcd7b08f4f7', 500.00, 'mpesa', NULL, NULL, 'RCP-20251003074818', '2025-10-02 07:48:00.000000', '2025-10-03 07:48:18.444313', NULL, 'adf9b5d364e1422b8d04e26c986dccf3', 'manual'),
('e8f87d4c5665483793d3415de776862b', 1000.00, 'mpesa', NULL, NULL, 'RCP-20250925095332', '2025-09-12 09:53:00.000000', '2025-09-25 09:53:32.737493', NULL, '3705d1a4b2084858bf0e104d062cb22c', 'manual'),
('e9b00a6e9fc64c328936376aa5cd814a', 1000.00, 'mpesa', NULL, NULL, 'RCP-20250925095312', '2025-09-09 09:52:00.000000', '2025-09-25 09:53:12.767700', NULL, '3705d1a4b2084858bf0e104d062cb22c', 'manual'),
('eb155df45bc847948bd3cc0c43fd5b5a', 540.00, 'mpesa', NULL, NULL, 'RCP-20251001081731', '2025-09-30 08:17:00.000000', '2025-10-01 08:17:31.053138', NULL, '089a2cefc22342f5b0363977291bcad0', 'manual'),
('efc4e44e3aa74a7c8f062472bd3d3590', 240.00, 'mpesa', NULL, NULL, 'RCP-20251010175018', '2025-10-09 17:50:00.000000', '2025-10-10 17:50:18.300443', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('efefb91e16364f52bb51d51f884b830a', 240.00, 'mpesa', NULL, NULL, 'RCP-20251002073827', '2025-10-01 07:38:00.000000', '2025-10-02 07:38:27.996080', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('f47ac57ca62c47e2a1d92847833e4644', 240.00, 'mpesa', NULL, NULL, 'RCP-20251026200537', '2025-10-23 20:05:00.000000', '2025-10-26 20:05:37.092952', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('f6a9dc83aa7f4eb0b28af6cfc89f4661', 270.00, 'mpesa', NULL, NULL, 'RCP-20251005094321', '2025-10-03 09:43:00.000000', '2025-10-05 09:43:21.837971', NULL, '089a2cefc22342f5b0363977291bcad0', 'manual'),
('fac7e6e445074d7ca032cfb865fb24ff', 1000.00, 'mpesa', NULL, NULL, 'RCP-20251020173742', '2025-10-18 17:37:00.000000', '2025-10-20 17:37:42.487333', NULL, 'fc248ff7a9464af6afdc2f8b62460448', 'manual'),
('fb49230c7838461aa5e2d4ba82bea485', 2200.00, 'mpesa', NULL, NULL, 'RCP-20250923073734', '2025-09-22 07:36:00.000000', '2025-09-23 07:37:34.076556', NULL, 'b178829b74ca43a5931da45bf0b9f062', 'manual'),
('fbeafee7531944629f0ff2aa54ae2bf5', 1000.00, 'mpesa', NULL, NULL, 'RCP-20251010193955', '2025-10-09 19:39:00.000000', '2025-10-10 19:39:55.161985', NULL, '4ce45a85b954482da50039d1fe821d0f', 'manual'),
('fcd88ceb974e4e699ecdcae7dd9be655', 240.00, 'mpesa', NULL, NULL, 'RCP-20251012170427', '2025-10-11 17:04:00.000000', '2025-10-12 17:04:27.332786', NULL, 'ec884694b36646809541ec645d11bfcb', 'manual'),
('ff46ac1e405842cba909346b42d8d595', 2000.00, 'mpesa', NULL, NULL, 'RCP-20250926094215', '2025-09-05 09:41:00.000000', '2025-09-26 09:42:15.246137', NULL, '65eeb18c641b488d8a5dc1a9a8964c71', 'manual'),
('ff62083284e34811b926781b74aac4e5', 400.00, 'mpesa', NULL, NULL, 'RCP-20251020100517', '2025-10-19 10:05:00.000000', '2025-10-20 10:05:17.308729', NULL, 'b7a7dc48f2ea42bca631ac0f1fff972d', 'manual');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `repayments`
--
ALTER TABLE `repayments`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `receipt_number` (`receipt_number`),
  ADD KEY `repayments_loan_id_58f9f13b_fk_loans_id` (`loan`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;