-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Nov 24, 2025 at 01:39 PM
-- Server version: 10.6.24-MariaDB
-- PHP Version: 8.4.14

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: `cidapayc_solution`
--

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

--
-- Table structure for table `borderless_transactions`
--

CREATE TABLE `borderless_transactions` (
  `id` int(11) NOT NULL,
  `user_id` varchar(50) NOT NULL,
  `transaction_id` varchar(100) NOT NULL,
  `type` enum('send','receive') NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `currency` varchar(10) NOT NULL,
  `country` varchar(10) NOT NULL,
  `network` varchar(100) NOT NULL,
  `recipient` varchar(255) NOT NULL,
  `status` enum('pending','processing','completed','failed') NOT NULL,
  `details` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `border_fee_structure`
--

CREATE TABLE `border_fee_structure` (
  `id` int(11) NOT NULL,
  `country_code` varchar(3) NOT NULL,
  `network_type` varchar(20) NOT NULL,
  `provider_fee_percentage` decimal(5,2) DEFAULT 0.00,
  `provider_fee_fixed` decimal(10,2) DEFAULT 0.00,
  `our_fee_percentage` decimal(5,2) DEFAULT 2.00,
  `min_amount` decimal(10,2) DEFAULT 10.00,
  `max_amount` decimal(10,2) DEFAULT 1000.00,
  `status` enum('active','inactive') DEFAULT 'active',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `border_fee_structure`
--

INSERT INTO `border_fee_structure` (`id`, `country_code`, `network_type`, `provider_fee_percentage`, `provider_fee_fixed`, `our_fee_percentage`, `min_amount`, `max_amount`, `status`, `created_at`, `updated_at`) VALUES
(1, 'BJ', 'mobile', 2.25, 1.00, 2.00, 10.00, 1000.00, 'active', '2025-10-23 14:35:51', '2025-10-23 14:35:51'),
(2, 'BW', 'bank', 0.50, 10.00, 2.00, 10.00, 1000.00, 'active', '2025-10-23 14:35:51', '2025-10-23 14:35:51'),
(3, 'BW', 'mobile', 2.20, 1.00, 2.00, 10.00, 1000.00, 'active', '2025-10-23 14:35:51', '2025-10-23 14:35:51'),
(4, 'BF', 'mobile', 2.25, 1.00, 2.00, 10.00, 1000.00, 'active', '2025-10-23 14:35:51', '2025-10-23 14:35:51'),
(5, 'CM', 'mobile', 1.50, 1.00, 2.00, 10.00, 1000.00, 'active', '2025-10-23 14:35:51', '2025-10-23 14:35:51'),
(6, 'CD', 'mobile', 1.50, 1.00, 2.00, 10.00, 1000.00, 'active', '2025-10-23 14:35:51', '2025-10-23 14:35:51'),
(7, 'CI', 'mobile', 2.25, 1.00, 2.00, 10.00, 1000.00, 'active', '2025-10-23 14:35:51', '2025-10-23 14:35:51'),
(8, 'KE', 'bank', 0.50, 200.00, 2.00, 10.00, 1000.00, 'active', '2025-10-23 14:35:51', '2025-10-23 14:35:51'),
(9, 'KE', 'mobile', 2.00, 1.00, 2.00, 10.00, 1000.00, 'active', '2025-10-23 14:35:51', '2025-10-23 14:35:51'),
(10, 'MW', 'bank', 0.50, 750.00, 2.00, 10.00, 1000.00, 'active', '2025-10-23 14:35:51', '2025-10-23 14:35:51'),
(11, 'MW', 'mobile', 1.00, 1.00, 2.00, 10.00, 1000.00, 'active', '2025-10-23 14:35:51', '2025-10-23 14:35:51'),
(12, 'NG', 'bank', 0.00, 100.00, 2.00, 10.00, 1000.00, 'active', '2025-10-23 14:35:51', '2025-10-23 14:35:51'),
(13, 'RW', 'bank', 0.50, 1000.00, 2.00, 10.00, 1000.00, 'active', '2025-10-23 14:35:51', '2025-10-23 14:35:51'),
(14, 'SN', 'mobile', 1.50, 1.00, 2.00, 10.00, 1000.00, 'active', '2025-10-23 14:35:51', '2025-10-23 14:35:51'),
(15, 'ZA', 'bank', 0.50, 20.00, 2.00, 10.00, 1000.00, 'active', '2025-10-23 14:35:51', '2025-10-23 14:35:51'),
(16, 'TZ', 'bank', 0.50, 12500.00, 2.00, 10.00, 1000.00, 'active', '2025-10-23 14:35:51', '2025-10-23 14:35:51'),
(17, 'TG', 'mobile', 2.25, 1.00, 2.00, 10.00, 1000.00, 'active', '2025-10-23 14:35:51', '2025-10-23 14:35:51'),
(18, 'UG', 'bank', 0.50, 5000.00, 2.00, 10.00, 1000.00, 'active', '2025-10-23 14:35:51', '2025-10-23 14:35:51'),
(19, 'UG', 'mobile', 1.50, 1.00, 2.00, 10.00, 1000.00, 'active', '2025-10-23 14:35:51', '2025-10-23 14:35:51'),
(20, 'ZM', 'bank', 0.50, 100.00, 2.00, 10.00, 1000.00, 'active', '2025-10-23 14:35:51', '2025-10-23 14:35:51'),
(21, 'ZM', 'mobile', 1.50, 1.00, 2.00, 10.00, 1000.00, 'active', '2025-10-23 14:35:51', '2025-10-23 14:35:51');

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

--
-- Table structure for table `border_payments`
--

CREATE TABLE `border_payments` (
  `id` int(11) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `reference` varchar(100) NOT NULL,
  `yellowcard_reference` varchar(255) DEFAULT NULL,
  `channel_id` varchar(255) NOT NULL,
  `network_id` varchar(255) NOT NULL,
  `destination_country` varchar(10) NOT NULL,
  `recipient_type` enum('bank','mobile') NOT NULL,
  `amount_usd` decimal(15,2) NOT NULL,
  `amount_ngn` decimal(15,2) NOT NULL,
  `fee_ngn` decimal(15,2) NOT NULL,
  `total_ngn` decimal(15,2) NOT NULL,
  `recipient_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`recipient_data`)),
  `status` enum('pending','completed','failed') DEFAULT 'pending',
  `yellowcard_status` varchar(100) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `yellowcard_channels_cache`
--

CREATE TABLE `yellowcard_channels_cache` (
  `id` varchar(255) NOT NULL,
  `country` varchar(10) NOT NULL,
  `currency` varchar(10) NOT NULL,
  `channel_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`channel_data`)),
  `last_updated` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` enum('active','inactive') DEFAULT 'active'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `yellowcard_channels_cache`
--

INSERT INTO `yellowcard_channels_cache` (`id`, `country`, `currency`, `channel_data`, `last_updated`, `status`) VALUES
('002d6bea-8709-44e0-ac1d-9b41652975e2', 'BF', 'XOF', '{\"max\":1500000,\"currency\":\"XOF\",\"countryCurrency\":\"BFXOF\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-31T13:58:52.802Z\",\"vendorId\":\"31a4c715-ed44-4a6c-8281-fc7031a0fa75\",\"country\":\"BF\",\"widgetStatus\":\"active\",\"feeUSD\":0,\"min\":500,\"channelType\":\"momo\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"002d6bea-8709-44e0-ac1d-9b41652975e2\"}', '2025-11-07 15:50:32', 'active'),
('030d5d5e-95a5-45b8-8340-d9d56bdb25f6', 'SN', 'XOF', '{\"max\":0,\"currency\":\"XOF\",\"countryCurrency\":\"SNXOF\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-11T08:53:24.801Z\",\"vendorId\":\"31a4c715-ed44-4a6c-8281-fc7031a0fa75\",\"country\":\"SN\",\"feeUSD\":0,\"min\":500,\"channelType\":\"momo\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"030d5d5e-95a5-45b8-8340-d9d56bdb25f6\"}', '2025-11-07 15:50:32', 'active'),
('05ec29bc-a6c0-4045-8ef1-8701fa991d12', 'RW', 'RWF', '{\"max\":0,\"currency\":\"RWF\",\"countryCurrency\":\"RWRWF\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-10T11:38:53.229Z\",\"vendorId\":\"93c71084-3d5b-417a-ba98-5f300c75e7fb\",\"country\":\"RW\",\"feeUSD\":0,\"min\":1500,\"channelType\":\"bank\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"05ec29bc-a6c0-4045-8ef1-8701fa991d12\"}', '2025-11-07 15:50:32', 'active'),
('08a80804-0fe7-486d-bce0-ead90ee3b409', 'UG', 'USD', '{\"max\":0,\"currency\":\"USD\",\"countryCurrency\":\"UGUSD\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-10T11:43:06.720Z\",\"vendorId\":\"93c71084-3d5b-417a-ba98-5f300c75e7fb\",\"country\":\"UG\",\"feeUSD\":0,\"min\":5,\"channelType\":\"bank\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"08a80804-0fe7-486d-bce0-ead90ee3b409\"}', '2025-11-07 15:50:32', 'active'),
('0a9df144-564e-474e-a920-2f636000c4ce', 'CI', 'XOF', '{\"max\":0,\"currency\":\"XOF\",\"countryCurrency\":\"CIXOF\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-10T10:24:06.411Z\",\"vendorId\":\"93c71084-3d5b-417a-ba98-5f300c75e7fb\",\"country\":\"CI\",\"feeUSD\":0,\"min\":500,\"channelType\":\"bank\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"0a9df144-564e-474e-a920-2f636000c4ce\"}', '2025-11-07 15:50:32', 'active'),
('1239227d-f33a-4d7a-8520-0a0cf41988fb', 'BW', 'BWP', '{\"max\":1000000,\"currency\":\"BWP\",\"countryCurrency\":\"BWBWP\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-10T11:38:20.216Z\",\"vendorId\":\"93c71084-3d5b-417a-ba98-5f300c75e7fb\",\"country\":\"BW\",\"feeUSD\":0,\"min\":150,\"channelType\":\"bank\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"1239227d-f33a-4d7a-8520-0a0cf41988fb\"}', '2025-11-07 15:50:32', 'active'),
('18ef89ef-d91d-4961-94ce-9eda333db910', 'TZ', 'TZS', '{\"max\":10000000,\"currency\":\"TZS\",\"successThreshold\":75,\"widgetMin\":14500,\"countryCurrency\":\"TZTZS\",\"status\":\"active\",\"feeLocal\":2.5,\"createdAt\":\"2024-10-23T15:31:47.163Z\",\"vendorId\":\"ca000c6a-23c6-4c5a-9c53-a612185e8728\",\"country\":\"TZ\",\"widgetStatus\":\"active\",\"feeUSD\":0,\"min\":2500,\"widgetMax\":5000000,\"channelType\":\"momo\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-10-23T15:31:47.163Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"18ef89ef-d91d-4961-94ce-9eda333db910\"}', '2025-11-07 15:50:32', 'active'),
('1997a129-32f1-4aa7-8f2a-edaf3a0bb0a5', 'BJ', 'XOF', '{\"max\":1500000,\"currency\":\"XOF\",\"countryCurrency\":\"BJXOF\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-31T09:52:15.371Z\",\"vendorId\":\"31a4c715-ed44-4a6c-8281-fc7031a0fa75\",\"country\":\"BJ\",\"feeUSD\":0,\"min\":500,\"channelType\":\"momo\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"1997a129-32f1-4aa7-8f2a-edaf3a0bb0a5\"}', '2025-11-07 15:50:32', 'active'),
('1a57c6c1-5cc4-421a-8a39-b7818467e765', 'TZ', 'TZS', '{\"max\":0,\"currency\":\"TZS\",\"widgetMin\":145000,\"countryCurrency\":\"TZTZS\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-10T11:39:49.952Z\",\"vendorId\":\"93c71084-3d5b-417a-ba98-5f300c75e7fb\",\"country\":\"TZ\",\"widgetStatus\":\"active\",\"feeUSD\":0,\"min\":2500,\"channelType\":\"bank\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"1a57c6c1-5cc4-421a-8a39-b7818467e765\"}', '2025-11-07 15:50:32', 'active'),
('2005a129-32f1-4aa7-8f2a-edaf3a0bb0a5', 'BJ', 'XOF', '{\"max\":1500000,\"currency\":\"XOF\",\"countryCurrency\":\"BJXOF\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-31T09:52:15.371Z\",\"vendorId\":\"31a4c715-ed44-4a6c-8281-fc7031a0fa75\",\"country\":\"BJ\",\"widgetStatus\":\"active\",\"feeUSD\":0,\"min\":500,\"channelType\":\"momo\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"2005a129-32f1-4aa7-8f2a-edaf3a0bb0a5\"}', '2025-11-07 15:50:32', 'active'),
('218a9dfe-5031-46c9-a0a7-1a578cfb2f2d', 'CM', 'XAF', '{\"max\":1000000,\"currency\":\"XAF\",\"countryCurrency\":\"CMXAF\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-10T11:39:07.709Z\",\"vendorId\":\"93c71084-3d5b-417a-ba98-5f300c75e7fb\",\"country\":\"CM\",\"feeUSD\":0,\"min\":1000,\"channelType\":\"bank\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"218a9dfe-5031-46c9-a0a7-1a578cfb2f2d\"}', '2025-11-07 15:50:32', 'active'),
('2cb75e87-7a02-48cb-bee8-93f38b96dbc9', 'GH', 'GHS', '{\"max\":0,\"currency\":\"GHS\",\"countryCurrency\":\"GHGHS\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-10T09:31:20.375Z\",\"vendorId\":\"ca6de2f6-0f8f-4a3b-b449-7f57304a6fed\",\"country\":\"GH\",\"feeUSD\":0,\"min\":20,\"channelType\":\"momo\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"2cb75e87-7a02-48cb-bee8-93f38b96dbc9\"}', '2025-11-07 15:50:32', 'active'),
('33a82864-6460-43d7-9fc0-911f9bd8d50a', 'CI', 'XOF', '{\"max\":1500000,\"currency\":\"XOF\",\"countryCurrency\":\"CIXOF\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-10T11:54:58.943Z\",\"vendorId\":\"31a4c715-ed44-4a6c-8281-fc7031a0fa75\",\"country\":\"CI\",\"widgetStatus\":\"active\",\"feeUSD\":0,\"min\":500,\"channelType\":\"momo\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"33a82864-6460-43d7-9fc0-911f9bd8d50a\"}', '2025-11-07 15:50:32', 'active'),
('353b1e71-f6f1-48f5-bc11-26af091c62fd', 'CM', 'XAF', '{\"max\":0,\"currency\":\"XAF\",\"successThreshold\":75,\"widgetMin\":4000,\"countryCurrency\":\"CMXAF\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2024-10-23T15:31:47.163Z\",\"vendorId\":\"c339d25c-308a-42bf-ba51-d3d37e098264\",\"country\":\"CM\",\"widgetStatus\":\"active\",\"feeUSD\":0,\"min\":1000,\"widgetMax\":200000,\"channelType\":\"momo\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-10-23T15:31:47.163Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"353b1e71-f6f1-48f5-bc11-26af091c62fd\"}', '2025-11-07 15:50:32', 'active'),
('3955a441-fa81-4bee-a3ce-f958a530be80', 'TG', 'XOF', '{\"max\":0,\"currency\":\"XOF\",\"countryCurrency\":\"TGXOF\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-31T11:59:56.562Z\",\"vendorId\":\"31a4c715-ed44-4a6c-8281-fc7031a0fa75\",\"country\":\"TG\",\"widgetStatus\":\"active\",\"feeUSD\":0,\"min\":500,\"channelType\":\"momo\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"3955a441-fa81-4bee-a3ce-f958a530be80\"}', '2025-11-07 15:50:32', 'active'),
('3afcad16-1f7c-469b-853e-57c216ef2f36', 'BW', 'USD', '{\"max\":0,\"currency\":\"USD\",\"countryCurrency\":\"BWUSD\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-10T11:41:52.455Z\",\"vendorId\":\"93c71084-3d5b-417a-ba98-5f300c75e7fb\",\"country\":\"BW\",\"feeUSD\":0,\"min\":15,\"channelType\":\"bank\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"3afcad16-1f7c-469b-853e-57c216ef2f36\"}', '2025-11-07 15:50:32', 'active'),
('3dea1c86-f4cc-4d12-8144-0bd17aa56806', 'UG', 'UDX', '{\"max\":0,\"currency\":\"UDX\",\"countryCurrency\":\"UGUDX\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-10T11:40:41.012Z\",\"vendorId\":\"93c71084-3d5b-417a-ba98-5f300c75e7fb\",\"country\":\"UG\",\"feeUSD\":0,\"min\":15000,\"channelType\":\"bank\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"3dea1c86-f4cc-4d12-8144-0bd17aa56806\"}', '2025-11-07 15:50:32', 'active'),
('402e5d5e-95a5-45b8-8340-d9d56ba861b3', 'SN', 'XOF', '{\"max\":0,\"currency\":\"XOF\",\"countryCurrency\":\"SNXOF\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-11T08:53:24.801Z\",\"vendorId\":\"31a4c715-ed44-4a6c-8281-fc7031a0fa75\",\"country\":\"SN\",\"feeUSD\":0,\"min\":500,\"channelType\":\"momo\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"402e5d5e-95a5-45b8-8340-d9d56ba861b3\"}', '2025-11-07 15:50:32', 'active'),
('44e12ee6-be82-4f74-8af1-9fb36b553700', 'ZM', 'ZMW', '{\"max\":0,\"currency\":\"ZMW\",\"countryCurrency\":\"ZMZMW\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-11T09:31:44.406Z\",\"vendorId\":\"619a3cac-cd4c-41dd-bb52-2fdd8ccc0cb8\",\"country\":\"ZM\",\"feeUSD\":0,\"min\":100,\"channelType\":\"momo\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"44e12ee6-be82-4f74-8af1-9fb36b553700\"}', '2025-11-07 15:50:32', 'active'),
('48f72484-f2a5-4bef-8bc1-f57ccd1c837d', 'UG', 'UGX', '{\"max\":0,\"currency\":\"UGX\",\"countryCurrency\":\"UGUGX\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-10T11:40:41.012Z\",\"vendorId\":\"93c71084-3d5b-417a-ba98-5f300c75e7fb\",\"country\":\"UG\",\"widgetStatus\":\"active\",\"feeUSD\":0,\"min\":15000,\"channelType\":\"bank\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"48f72484-f2a5-4bef-8bc1-f57ccd1c837d\"}', '2025-11-07 15:50:32', 'active'),
('4a5e6cec-a02e-47a3-8b2f-071a5c50be64', 'UG', 'UGX', '{\"max\":0,\"currency\":\"UGX\",\"countryCurrency\":\"UGUGX\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-10T09:30:14.274Z\",\"vendorId\":\"01697a95-f421-4d22-b3ce-bdb8551ce065\",\"country\":\"UG\",\"feeUSD\":0,\"min\":15000,\"channelType\":\"momo\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"4a5e6cec-a02e-47a3-8b2f-071a5c50be64\"}', '2025-11-07 15:50:32', 'active'),
('50cb0d66-254d-4194-93c3-643ff283f282', 'RW', 'RWF', '{\"max\":0,\"currency\":\"RWF\",\"countryCurrency\":\"RWRWF\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-10T11:51:06.569Z\",\"vendorId\":\"03ab95fc-df93-47e0-b51b-010b86ac28f1\",\"country\":\"RW\",\"feeUSD\":0,\"min\":1200,\"channelType\":\"spenn\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"50cb0d66-254d-4194-93c3-643ff283f282\"}', '2025-11-07 15:50:32', 'active'),
('5ff735fb-c0e5-4828-9c03-1bb189de5622', 'SN', 'XOF', '{\"max\":0,\"currency\":\"XOF\",\"countryCurrency\":\"SNXOF\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-10T11:40:05.257Z\",\"vendorId\":\"93c71084-3d5b-417a-ba98-5f300c75e7fb\",\"country\":\"SN\",\"feeUSD\":0,\"min\":6500,\"channelType\":\"bank\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"5ff735fb-c0e5-4828-9c03-1bb189de5622\"}', '2025-11-07 15:50:32', 'active'),
('65a69867-81e2-44c7-a97b-fcaaf5f38359', 'GA', 'XAF', '{\"max\":0,\"currency\":\"XAF\",\"countryCurrency\":\"GAXAF\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-10T11:42:05.115Z\",\"vendorId\":\"93c71084-3d5b-417a-ba98-5f300c75e7fb\",\"country\":\"GA\",\"widgetStatus\":\"active\",\"feeUSD\":0,\"min\":1000,\"channelType\":\"bank\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"65a69867-81e2-44c7-a97b-fcaaf5f38359\"}', '2025-11-07 15:50:32', 'active'),
('695c718c-aab7-4670-b81f-b1da6191f37f', 'RW', 'RWF', '{\"max\":0,\"currency\":\"RWF\",\"countryCurrency\":\"RWRWF\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-10T11:59:30.891Z\",\"vendorId\":\"c339d25c-308a-42bf-ba51-d3d37e098264\",\"country\":\"RW\",\"widgetStatus\":\"active\",\"feeUSD\":0,\"min\":1500,\"channelType\":\"momo\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"695c718c-aab7-4670-b81f-b1da6191f37f\"}', '2025-11-07 15:50:32', 'active'),
('6ccbecb8-40a3-48d9-b21c-5ed761c3fd71', 'BW', 'BWP', '{\"max\":9500,\"currency\":\"BWP\",\"successThreshold\":75,\"widgetMin\":42,\"countryCurrency\":\"BWBWP\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2024-12-12T14:09:17.655Z\",\"vendorId\":\"a7fc2226-676a-4215-a9ba-cc91c2c7971d\",\"country\":\"BW\",\"widgetStatus\":\"active\",\"feeUSD\":0,\"min\":150,\"channelType\":\"momo\",\"rampType\":\"withdraw\",\"updatedAt\":\"2025-03-19T09:53:42.628Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":1,\"id\":\"6ccbecb8-40a3-48d9-b21c-5ed761c3fd71\"}', '2025-11-07 15:50:32', 'active'),
('6fef21a2-b8f3-4515-bef5-63597ea0307f', 'CG', 'XAF', '{\"max\":50000000,\"currency\":\"XAF\",\"countryCurrency\":\"CGXAF\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-10T11:38:37.113Z\",\"vendorId\":\"93c71084-3d5b-417a-ba98-5f300c75e7fb\",\"country\":\"CG\",\"widgetStatus\":\"active\",\"feeUSD\":0,\"min\":1000,\"channelType\":\"bank\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"6fef21a2-b8f3-4515-bef5-63597ea0307f\"}', '2025-11-07 15:50:32', 'active'),
('8618a32a-4080-426f-b474-b4ca740bfd0a', 'KE', 'KES', '{\"max\":0,\"currency\":\"KES\",\"successThreshold\":75,\"countryCurrency\":\"KEKES\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2023-01-19T13:51:42.704Z\",\"vendorId\":\"5536e268-97cc-4d9d-8d17-4bfe73ea8915\",\"country\":\"KE\",\"feeUSD\":0,\"min\":0,\"channelType\":\"momo\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"8618a32a-4080-426f-b474-b4ca740bfd0a\"}', '2025-11-07 15:50:32', 'active'),
('88c80c44-23a8-4729-9e36-7be766effefb', 'MW', 'MWK', '{\"max\":40000000,\"currency\":\"MWK\",\"successThreshold\":75,\"countryCurrency\":\"MWMWK\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2023-04-19T16:43:57.356Z\",\"vendorId\":\"cde55938-1079-4d1c-aa57-3de03d85ef5d\",\"country\":\"MW\",\"widgetStatus\":\"active\",\"feeUSD\":0,\"min\":5000,\"channelType\":\"momo\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-19T14:14:28.284Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"88c80c44-23a8-4729-9e36-7be766effefb\"}', '2025-11-07 15:50:32', 'active'),
('8b302864-6460-43d7-9fc0-911f9bd8a091', 'CI', 'XOF', '{\"max\":1500000,\"currency\":\"XOF\",\"countryCurrency\":\"CIXOF\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-10T11:54:58.943Z\",\"vendorId\":\"31a4c715-ed44-4a6c-8281-fc7031a0fa75\",\"country\":\"CI\",\"widgetStatus\":\"active\",\"feeUSD\":0,\"min\":500,\"channelType\":\"momo\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"8b302864-6460-43d7-9fc0-911f9bd8a091\"}', '2025-11-07 15:50:32', 'active'),
('993f9ce7-f5ab-47f0-9ded-1169b25d8ae0', 'CD', 'CDF', '{\"max\":0,\"currency\":\"CDF\",\"countryCurrency\":\"CDCDF\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-10T11:39:37.631Z\",\"vendorId\":\"93c71084-3d5b-417a-ba98-5f300c75e7fb\",\"country\":\"CD\",\"feeUSD\":0,\"min\":10000,\"channelType\":\"bank\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"993f9ce7-f5ab-47f0-9ded-1169b25d8ae0\"}', '2025-11-07 15:50:32', 'active'),
('aa11c087-d0c8-4f8d-b566-3625a7581a1f', 'MW', 'MWK', '{\"max\":20000000,\"currency\":\"MWK\",\"countryCurrency\":\"MWMWK\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-10T11:37:55.006Z\",\"vendorId\":\"93c71084-3d5b-417a-ba98-5f300c75e7fb\",\"country\":\"MW\",\"widgetStatus\":\"active\",\"feeUSD\":0,\"min\":5000,\"channelType\":\"bank\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"aa11c087-d0c8-4f8d-b566-3625a7581a1f\"}', '2025-11-07 15:50:32', 'active'),
('ad2da441-fa81-4bee-a3ce-f958a530be80', 'TG', 'XOF', '{\"max\":0,\"currency\":\"XOF\",\"countryCurrency\":\"TGXOF\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-31T11:59:56.562Z\",\"vendorId\":\"31a4c715-ed44-4a6c-8281-fc7031a0fa75\",\"country\":\"TG\",\"widgetStatus\":\"active\",\"feeUSD\":0,\"min\":500,\"channelType\":\"momo\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"ad2da441-fa81-4bee-a3ce-f958a530be80\"}', '2025-11-07 15:50:32', 'active'),
('b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', 'ZAR', '{\"max\":1000,\"currency\":\"ZAR\",\"successThreshold\":75,\"widgetMin\":100,\"countryCurrency\":\"ZAZAR\",\"commercialStatus\":\"inactive\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2024-10-23T15:31:47.166Z\",\"vendorId\":\"17285460-8b40-4718-8399-8c871c51a6fd\",\"country\":\"ZA\",\"widgetStatus\":\"active\",\"feeUSD\":0,\"min\":0,\"widgetMax\":5000,\"channelType\":\"eft\",\"rampType\":\"withdraw\",\"updatedAt\":\"2025-04-30T17:20:19.011Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"b3c6151a-6076-47af-920f-5aff74bb906e\"}', '2025-11-07 15:50:32', 'active'),
('b7140c26-0c93-460b-85cf-bdb53af66ca0', 'KE', 'KES', '{\"max\":0,\"currency\":\"KES\",\"countryCurrency\":\"KEKES\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-10T10:25:28.158Z\",\"vendorId\":\"93c71084-3d5b-417a-ba98-5f300c75e7fb\",\"country\":\"KE\",\"feeUSD\":0,\"min\":300,\"channelType\":\"bank\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"b7140c26-0c93-460b-85cf-bdb53af66ca0\"}', '2025-11-07 15:50:32', 'active'),
('ca4367f8-c228-4fd1-a6f2-90b08b2c0db1', 'CD', 'CDF', '{\"max\":5000000,\"currency\":\"CDF\",\"countryCurrency\":\"CDCDF\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-10T11:55:39.183Z\",\"vendorId\":\"31a4c715-ed44-4a6c-8281-fc7031a0fa75\",\"country\":\"CD\",\"feeUSD\":0,\"min\":10000,\"channelType\":\"momo\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"ca4367f8-c228-4fd1-a6f2-90b08b2c0db1\"}', '2025-11-07 15:50:32', 'active'),
('ddc30e71-58e4-4bb4-a22b-ef0293f176e4', 'ZM', 'ZMW', '{\"max\":15000000,\"currency\":\"ZMW\",\"countryCurrency\":\"ZMZMW\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-10T11:43:47.371Z\",\"vendorId\":\"93c71084-3d5b-417a-ba98-5f300c75e7fb\",\"country\":\"ZM\",\"feeUSD\":0,\"min\":100,\"channelType\":\"bank\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"ddc30e71-58e4-4bb4-a22b-ef0293f176e4\"}', '2025-11-07 15:50:32', 'active'),
('de392cbe-9826-45e1-aede-69ad2be6e3a0', 'ZM', 'ZMW', '{\"max\":500000,\"currency\":\"ZMW\",\"successThreshold\":75,\"widgetMin\":200,\"countryCurrency\":\"ZMZMW\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2024-10-23T15:31:47.166Z\",\"vendorId\":\"53eefc4e-68de-4d88-b6b3-76517ed36613\",\"country\":\"ZM\",\"widgetStatus\":\"active\",\"feeUSD\":0,\"min\":100,\"widgetMax\":10000,\"channelType\":\"momo\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-10-23T15:31:47.166Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":90,\"id\":\"de392cbe-9826-45e1-aede-69ad2be6e3a0\"}', '2025-11-07 15:50:32', 'active'),
('fbd1276a-8709-44e0-ac1d-9b41656591cd', 'BF', 'XOF', '{\"max\":1500000,\"currency\":\"XOF\",\"countryCurrency\":\"BFXOF\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-31T13:58:52.802Z\",\"vendorId\":\"31a4c715-ed44-4a6c-8281-fc7031a0fa75\",\"country\":\"BF\",\"widgetStatus\":\"active\",\"feeUSD\":0,\"min\":500,\"channelType\":\"momo\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"fbd1276a-8709-44e0-ac1d-9b41656591cd\"}', '2025-11-07 15:50:32', 'active'),
('fe8f4989-3bf6-41ca-9621-ffe2bc127569', 'NG', 'NGN', '{\"max\":5000000,\"currency\":\"NGN\",\"widgetMin\":5000,\"countryCurrency\":\"NGNGN\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-10T14:16:07.387Z\",\"vendorId\":\"ec2109e2-ff57-4a07-b400-7818907ce2f9\",\"country\":\"NG\",\"widgetStatus\":\"active\",\"feeUSD\":0,\"min\":1800,\"channelType\":\"p2p\",\"rampType\":\"withdraw\",\"widgetMax\":1500000,\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"fe8f4989-3bf6-41ca-9621-ffe2bc127569\"}', '2025-11-07 15:50:32', 'active'),
('ff3fad5f-05f6-4425-9085-794d71890493', 'ZM', 'ZMW', '{\"max\":0,\"currency\":\"ZMW\",\"countryCurrency\":\"ZMZMW\",\"status\":\"active\",\"feeLocal\":0,\"createdAt\":\"2022-08-11T08:31:32.973Z\",\"vendorId\":\"03ab95fc-df93-47e0-b51b-010b86ac28f1\",\"country\":\"ZM\",\"feeUSD\":0,\"min\":500,\"channelType\":\"spenn\",\"rampType\":\"withdraw\",\"updatedAt\":\"2024-03-22T10:00:20.733Z\",\"apiStatus\":\"active\",\"settlementType\":\"instant\",\"estimatedSettlementTime\":60,\"id\":\"ff3fad5f-05f6-4425-9085-794d71890493\"}', '2025-11-07 15:50:32', 'active');

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

--
-- Table structure for table `yellowcard_networks_cache`
--

CREATE TABLE `yellowcard_networks_cache` (
  `id` varchar(255) NOT NULL,
  `channel_id` varchar(255) NOT NULL,
  `country` varchar(10) NOT NULL,
  `network_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`network_data`)),
  `last_updated` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` enum('active','inactive') DEFAULT 'active'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `yellowcard_networks_cache`
--

INSERT INTO `yellowcard_networks_cache` (`id`, `channel_id`, `country`, `network_data`, `last_updated`, `status`) VALUES
('0941a3e5-6f9a-4e93-83b0-72de9a34d82b', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"679000\",\"updatedAt\":\"2023-09-25T14:48:05.577Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:48:05.577Z\",\"accountNumberType\":\"bank\",\"id\":\"0941a3e5-6f9a-4e93-83b0-72de9a34d82b\",\"country\":\"ZA\",\"name\":\"Bidvest Bank\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('09c5d41b-e062-4b2f-b031-818732337358', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"462005\",\"updatedAt\":\"2023-09-25T14:50:51.758Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:50:51.758Z\",\"accountNumberType\":\"bank\",\"id\":\"09c5d41b-e062-4b2f-b031-818732337358\",\"country\":\"ZA\",\"name\":\"Old Mutual\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('0d19d67e-5946-4289-bac1-ad147d7c84ad', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"450905\",\"updatedAt\":\"2023-09-25T14:48:05.578Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:48:05.578Z\",\"accountNumberType\":\"bank\",\"id\":\"0d19d67e-5946-4289-bac1-ad147d7c84ad\",\"country\":\"ZA\",\"name\":\"Mercantile Bank Limited\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('0dae3b0d-4074-406b-aede-790c0be061cc', '18ef89ef-d91d-4961-94ce-9eda333db910', 'TZ', '{\"featureFlagEnabled\":[],\"code\":\"AIRTELMONEYTZ\",\"tempDisabledFor\":[],\"updatedAt\":\"2024-07-24T14:10:09.435Z\",\"status\":\"active\",\"channelIds\":[\"18ef89ef-d91d-4961-94ce-9eda333db910\",\"eba441c9-199a-4e91-94a3-e019c4f145f9\",\"656d4e72-7849-4fd6-b0a0-8631c8adf704\"],\"createdAt\":\"2024-07-24T14:10:09.435Z\",\"accountNumberType\":\"phone\",\"id\":\"0dae3b0d-4074-406b-aede-790c0be061cc\",\"country\":\"TZ\",\"name\":\"AIRTELMONEYTZ\",\"countryAccountNumberType\":\"TZPHONE\"}', '2025-11-07 15:50:44', 'active'),
('0e718e23-d176-48da-893d-610ada51fbd5', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"410506\",\"updatedAt\":\"2023-09-25T14:50:51.758Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:50:51.758Z\",\"accountNumberType\":\"bank\",\"id\":\"0e718e23-d176-48da-893d-610ada51fbd5\",\"country\":\"ZA\",\"name\":\"South African Bank of Athens Limited\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('0fa8a1ec-0919-4261-877e-0046f98767d8', '1997a129-32f1-4aa7-8f2a-edaf3a0bb0a5', 'BJ', '{\"code\":\"Mtn Mobile Money BJ\",\"updatedAt\":\"2023-06-08T15:33:10.072Z\",\"status\":\"active\",\"channelIds\":[\"13ba87e5-cfce-4380-90cd-76f41d05c419\",\"1997a129-32f1-4aa7-8f2a-edaf3a0bb0a5\"],\"createdAt\":\"2022-12-19T00:50:34.599Z\",\"accountNumberType\":\"phone\",\"id\":\"0fa8a1ec-0919-4261-877e-0046f98767d8\",\"country\":\"BJ\",\"name\":\"Mtn Mobile Money BJ\",\"countryAccountNumberType\":\"BJPHONE\"}', '2025-10-30 17:06:45', 'active'),
('125df772-0bd9-4ad2-8b10-ff377f8cfad1', 'fe8f4989-3bf6-41ca-9621-ffe2bc127569', 'NG', '{\"code\":\"082\",\"updatedAt\":\"2023-06-08T15:18:44.135Z\",\"status\":\"active\",\"channelIds\":[\"fe8f4989-3bf6-41ca-9621-ffe2bc127569\",\"af944f0c-ba70-47c7-86dc-1bad5a6ab4e4\"],\"accountNumberType\":\"bank\",\"id\":\"125df772-0bd9-4ad2-8b10-ff377f8cfad1\",\"country\":\"NG\",\"name\":\"Keystone Bank\",\"countryAccountNumberType\":\"NGBANK\"}', '2025-11-07 15:50:34', 'active'),
('12c8b67c-3f29-47a0-938c-58d804ab9a22', '88c80c44-23a8-4729-9e36-7be766effefb', 'MW', '{\"featureFlagEnabled\":[],\"code\":\"TNM\",\"tempDisabledFor\":[],\"updatedAt\":\"2024-02-27T15:34:52.041Z\",\"status\":\"active\",\"channelIds\":[\"7b317104-d142-44b6-8096-312ea0fb30a0\",\"88c80c44-23a8-4729-9e36-7be766effefb\"],\"createdAt\":\"2024-01-17T15:30:22.156Z\",\"accountNumberType\":\"phone\",\"id\":\"12c8b67c-3f29-47a0-938c-58d804ab9a22\",\"country\":\"MW\",\"name\":\"TNM\",\"countryAccountNumberType\":\"MWPHONE\"}', '2025-10-30 17:06:49', 'active'),
('135e8f0b-3c9a-404c-9b98-65c4d3af4d0f', 'fe8f4989-3bf6-41ca-9621-ffe2bc127569', 'NG', '{\"code\":\"035\",\"updatedAt\":\"2023-06-08T15:18:44.135Z\",\"status\":\"active\",\"channelIds\":[\"fe8f4989-3bf6-41ca-9621-ffe2bc127569\",\"af944f0c-ba70-47c7-86dc-1bad5a6ab4e4\"],\"accountNumberType\":\"bank\",\"id\":\"135e8f0b-3c9a-404c-9b98-65c4d3af4d0f\",\"country\":\"NG\",\"name\":\"Wema Bank\",\"countryAccountNumberType\":\"NGBANK\"}', '2025-11-07 15:50:34', 'active'),
('1d6a7158-ba12-4db4-9ffe-9b2d3de79ea0', '6ccbecb8-40a3-48d9-b21c-5ed761c3fd71', 'BW', '{\"featureFlagEnabled\":[],\"code\":\"Mobile Money\",\"tempDisabledFor\":[],\"updatedAt\":\"2025-05-14T08:54:11.776Z\",\"status\":\"active\",\"channelIds\":[\"6ccbecb8-40a3-48d9-b21c-5ed761c3fd71\",\"dff1d266-f71c-4fed-badb-5b7b79b4de40\"],\"createdAt\":\"2024-12-18T08:43:36.016Z\",\"accountNumberType\":\"phone\",\"id\":\"1d6a7158-ba12-4db4-9ffe-9b2d3de79ea0\",\"country\":\"BW\",\"name\":\"Mobile Money\",\"countryAccountNumberType\":\"BWPHONE\"}', '2025-11-07 15:50:37', 'active'),
('20ce6610-b6ce-4896-844c-cc51a6cbeca4', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"587000\",\"updatedAt\":\"2023-09-25T14:48:05.578Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:48:05.578Z\",\"accountNumberType\":\"bank\",\"id\":\"20ce6610-b6ce-4896-844c-cc51a6cbeca4\",\"country\":\"ZA\",\"name\":\"Hsbc Bank\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('23031ff8-896e-48c1-8181-97e8afd7eaf8', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"222026\",\"updatedAt\":\"2023-09-25T14:50:51.758Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:50:51.758Z\",\"accountNumberType\":\"bank\",\"id\":\"23031ff8-896e-48c1-8181-97e8afd7eaf8\",\"country\":\"ZA\",\"name\":\"RMB Private Bank\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('2688c2a6-2903-41de-b512-77ae1946850b', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"410506\",\"updatedAt\":\"2023-09-25T14:48:05.577Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:48:05.577Z\",\"accountNumberType\":\"bank\",\"id\":\"2688c2a6-2903-41de-b512-77ae1946850b\",\"country\":\"ZA\",\"name\":\"Bank of Athens\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('28281f21-4705-431f-a752-9a485628c76a', 'aa11c087-d0c8-4f8d-b566-3625a7581a1f', 'ALL', '{\"updatedAt\":\"2023-06-08T15:48:04.015Z\",\"status\":\"active\",\"channelIds\":[\"1239227d-f33a-4d7a-8520-0a0cf41988fb\",\"3afcad16-1f7c-469b-853e-57c216ef2f36\",\"1937a7bd-c9c3-4ed9-b74e-ac11c97ef104\",\"993f9ce7-f5ab-47f0-9ded-1169b25d8ae0\",\"6fef21a2-b8f3-4515-bef5-63597ea0307f\",\"0a9df144-564e-474e-a920-2f636000c4ce\",\"218a9dfe-5031-46c9-a0a7-1a578cfb2f2d\",\"65a69867-81e2-44c7-a97b-fcaaf5f38359\",\"b7140c26-0c93-460b-85cf-bdb53af66ca0\",\"aa11c087-d0c8-4f8d-b566-3625a7581a1f\",\"05ec29bc-a6c0-4045-8ef1-8701fa991d12\",\"5ff735fb-c0e5-4828-9c03-1bb189de5622\",\"12b6d583-b5ad-440f-8185-02c67259b17d\",\"48f72484-f2a5-4bef-8bc1-f57ccd1c837d\",\"08a80804-0fe7-486d-bce0-ead90ee3b409\",\"019c78ad-33bd-48ec-851e-076c4e5d64af\",\"5feda1af-f05e-413f-a472-ab587fe31480\",\"ddc30e71-58e4-4bb4-a22b-ef0293f176e4\",\"81018280-e320-4c81-9b2f-6f636c2239d8\"],\"createdAt\":\"2022-12-19T00:50:34.598Z\",\"accountNumberType\":\"bank\",\"id\":\"28281f21-4705-431f-a752-9a485628c76a\",\"country\":\"ALL\",\"name\":\"Manual Input\",\"countryAccountNumberType\":\"ALLBANK\"}', '2025-11-07 15:50:35', 'active'),
('29dfd792-d66d-4121-9235-324b2edf28ed', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"730020\",\"updatedAt\":\"2023-09-25T14:50:51.758Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:50:51.758Z\",\"accountNumberType\":\"bank\",\"id\":\"29dfd792-d66d-4121-9235-324b2edf28ed\",\"country\":\"ZA\",\"name\":\"Standard Chartered Bank\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('31cfcc77-8904-4f86-879c-a0d18b4b9365', 'fe8f4989-3bf6-41ca-9621-ffe2bc127569', 'NG', '{\"code\":\"058\",\"updatedAt\":\"2023-06-08T15:18:44.135Z\",\"status\":\"active\",\"channelIds\":[\"fe8f4989-3bf6-41ca-9621-ffe2bc127569\",\"af944f0c-ba70-47c7-86dc-1bad5a6ab4e4\"],\"accountNumberType\":\"bank\",\"id\":\"31cfcc77-8904-4f86-879c-a0d18b4b9365\",\"country\":\"NG\",\"name\":\"Guaranty Trust Bank\",\"countryAccountNumberType\":\"NGBANK\"}', '2025-11-07 15:50:34', 'active'),
('38f5699b-585f-4760-880c-cc33393516cc', '993f9ce7-f5ab-47f0-9ded-1169b25d8ae0', 'CD', '{\"code\":\"0\",\"status\":\"active\",\"channelIds\":[\"993f9ce7-f5ab-47f0-9ded-1169b25d8ae0\",\"58f33225-f76b-457c-a0f1-c8a5009e6030\"],\"accountNumberType\":\"bank\",\"id\":\"38f5699b-585f-4760-880c-cc33393516cc\",\"country\":\"CD\",\"name\":\"Standard Bank Congo\",\"countryAccountNumberType\":\"CDBANK\"}', '2025-11-07 15:50:46', 'active'),
('3921cd57-f596-4166-b326-32985cb70491', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"471001\",\"updatedAt\":\"2023-09-25T14:48:05.578Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:48:05.578Z\",\"accountNumberType\":\"bank\",\"id\":\"3921cd57-f596-4166-b326-32985cb70491\",\"country\":\"ZA\",\"name\":\"Meeg Bank\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('3a03d846-8918-4964-b09e-fc3169e77504', '88c80c44-23a8-4729-9e36-7be766effefb', 'MW', '{\"code\":\"AIRTEL\",\"updatedAt\":\"2023-06-08T15:33:10.071Z\",\"status\":\"active\",\"channelIds\":[\"88c80c44-23a8-4729-9e36-7be766effefb\"],\"createdAt\":\"2023-03-22T18:07:08.974Z\",\"accountNumberType\":\"phone\",\"id\":\"3a03d846-8918-4964-b09e-fc3169e77504\",\"country\":\"MW\",\"name\":\"Airtel\",\"countryAccountNumberType\":\"MWPHONE\"}', '2025-10-30 17:06:49', 'active'),
('3a88a3b7-d0c1-4c50-bd07-89e868b02846', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"157852\",\"updatedAt\":\"2023-09-25T14:50:51.758Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:50:51.758Z\",\"accountNumberType\":\"bank\",\"id\":\"3a88a3b7-d0c1-4c50-bd07-89e868b02846\",\"country\":\"ZA\",\"name\":\"Peach\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('3d4d08c1-4811-4fee-9349-a302328e55c1', 'fe8f4989-3bf6-41ca-9621-ffe2bc127569', 'NG', '{\"code\":\"221\",\"updatedAt\":\"2023-06-08T15:18:44.135Z\",\"status\":\"active\",\"channelIds\":[\"fe8f4989-3bf6-41ca-9621-ffe2bc127569\",\"af944f0c-ba70-47c7-86dc-1bad5a6ab4e4\"],\"accountNumberType\":\"bank\",\"id\":\"3d4d08c1-4811-4fee-9349-a302328e55c1\",\"country\":\"NG\",\"name\":\"Stanbic Ibtc Bank\",\"countryAccountNumberType\":\"NGBANK\"}', '2025-11-07 15:50:34', 'active'),
('3e5cc193-e17d-40b2-ba77-44a8ca095c34', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"801000\",\"updatedAt\":\"2023-09-25T14:50:51.758Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:50:51.758Z\",\"accountNumberType\":\"bank\",\"id\":\"3e5cc193-e17d-40b2-ba77-44a8ca095c34\",\"country\":\"ZA\",\"name\":\"State Bank Of India\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('41109c18-9604-4389-8472-44ff4378c6cb', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"589000\",\"updatedAt\":\"2023-09-25T14:48:05.578Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:48:05.578Z\",\"accountNumberType\":\"bank\",\"id\":\"41109c18-9604-4389-8472-44ff4378c6cb\",\"country\":\"ZA\",\"name\":\"Finbond Mutual Bank\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('471310ac-3604-4a36-b75f-819ebb58ae88', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"201419\",\"updatedAt\":\"2023-09-25T14:48:05.578Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:48:05.578Z\",\"accountNumberType\":\"bank\",\"id\":\"471310ac-3604-4a36-b75f-819ebb58ae88\",\"country\":\"ZA\",\"name\":\"FirstRand Bank Limited\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('572e73ba-890d-4320-abca-fa8e73cddb09', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"679000\",\"updatedAt\":\"2023-09-25T14:48:05.578Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:48:05.578Z\",\"accountNumberType\":\"bank\",\"id\":\"572e73ba-890d-4320-abca-fa8e73cddb09\",\"country\":\"ZA\",\"name\":\"Discovery Bank Limited\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('5cf565d5-cf10-473d-8586-b713383cfe99', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"460005\",\"updatedAt\":\"2023-09-25T14:50:51.758Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:50:51.758Z\",\"accountNumberType\":\"bank\",\"id\":\"5cf565d5-cf10-473d-8586-b713383cfe99\",\"country\":\"ZA\",\"name\":\"SA Post Bank (Post Office)\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('5dcfa62b-5cfa-4e59-aae4-95f7fecdeaa6', 'fe8f4989-3bf6-41ca-9621-ffe2bc127569', 'NG', '{\"code\":\"215\",\"updatedAt\":\"2023-06-08T15:18:44.135Z\",\"status\":\"active\",\"channelIds\":[\"fe8f4989-3bf6-41ca-9621-ffe2bc127569\",\"af944f0c-ba70-47c7-86dc-1bad5a6ab4e4\"],\"accountNumberType\":\"bank\",\"id\":\"5dcfa62b-5cfa-4e59-aae4-95f7fecdeaa6\",\"country\":\"NG\",\"name\":\"Unity Bank\",\"countryAccountNumberType\":\"NGBANK\"}', '2025-11-07 15:50:34', 'active'),
('5f1af11b-305f-4420-8fce-65ed2725a409', 'fe8f4989-3bf6-41ca-9621-ffe2bc127569', 'NG', '{\"code\":\"044\",\"updatedAt\":\"2023-06-08T15:18:44.135Z\",\"status\":\"active\",\"channelIds\":[\"fe8f4989-3bf6-41ca-9621-ffe2bc127569\",\"af944f0c-ba70-47c7-86dc-1bad5a6ab4e4\"],\"accountNumberType\":\"bank\",\"id\":\"5f1af11b-305f-4420-8fce-65ed2725a409\",\"country\":\"NG\",\"name\":\"Access Bank\",\"countryAccountNumberType\":\"NGBANK\"}', '2025-11-07 15:50:34', 'active'),
('600a5df5-c28c-435c-b3be-19dbed0ee402', 'fe8f4989-3bf6-41ca-9621-ffe2bc127569', 'NG', '{\"code\":\"214\",\"updatedAt\":\"2023-06-08T15:18:44.135Z\",\"status\":\"active\",\"channelIds\":[\"fe8f4989-3bf6-41ca-9621-ffe2bc127569\",\"af944f0c-ba70-47c7-86dc-1bad5a6ab4e4\"],\"accountNumberType\":\"bank\",\"id\":\"600a5df5-c28c-435c-b3be-19dbed0ee402\",\"country\":\"NG\",\"name\":\"First City Monument Bank\",\"countryAccountNumberType\":\"NGBANK\"}', '2025-11-07 15:50:34', 'active'),
('64e2e540-cad7-4a0d-8a36-866009a1fc0c', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"980172\",\"updatedAt\":\"2023-09-25T14:48:05.577Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:48:05.577Z\",\"accountNumberType\":\"bank\",\"id\":\"64e2e540-cad7-4a0d-8a36-866009a1fc0c\",\"country\":\"ZA\",\"name\":\"Bank Of Namibia\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('696ad043-827c-42cc-b41b-46270fca7899', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"586611\",\"updatedAt\":\"2023-09-25T14:48:05.578Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:48:05.578Z\",\"accountNumberType\":\"bank\",\"id\":\"696ad043-827c-42cc-b41b-46270fca7899\",\"country\":\"ZA\",\"name\":\"Central Bank Of Lesotho\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('69affaa2-fbec-4e28-abd0-7444232721be', '44e12ee6-be82-4f74-8af1-9fb36b553700', 'ZM', '{\"code\":\"MTN\",\"tempDisabledFor\":[],\"updatedAt\":\"2024-02-09T13:53:53.100Z\",\"status\":\"active\",\"channelIds\":[\"3137dba1-9856-4880-80c0-3ec43d50d3f6\",\"de392cbe-9826-45e1-aede-69ad2be6e3a0\",\"44e12ee6-be82-4f74-8af1-9fb36b553700\"],\"createdAt\":\"2023-03-22T18:07:08.974Z\",\"accountNumberType\":\"phone\",\"id\":\"69affaa2-fbec-4e28-abd0-7444232721be\",\"country\":\"ZM\",\"name\":\"MTN\",\"countryAccountNumberType\":\"ZMPHONE\"}', '2025-10-30 17:06:47', 'active'),
('6a67c771-bc70-4ca2-a1e3-de633fb44507', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"280061\",\"updatedAt\":\"2023-09-25T14:48:05.578Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:48:05.578Z\",\"accountNumberType\":\"bank\",\"id\":\"6a67c771-bc70-4ca2-a1e3-de633fb44507\",\"country\":\"ZA\",\"name\":\"First National Bank Lesotho\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('6df48502-1ebe-473f-be17-e2cae4dd67ee', 'fe8f4989-3bf6-41ca-9621-ffe2bc127569', 'NG', '{\"code\":\"057\",\"updatedAt\":\"2023-06-08T15:18:44.135Z\",\"status\":\"active\",\"channelIds\":[\"fe8f4989-3bf6-41ca-9621-ffe2bc127569\",\"af944f0c-ba70-47c7-86dc-1bad5a6ab4e4\"],\"accountNumberType\":\"bank\",\"id\":\"6df48502-1ebe-473f-be17-e2cae4dd67ee\",\"country\":\"NG\",\"name\":\"Zenith Bank\",\"countryAccountNumberType\":\"NGBANK\"}', '2025-11-07 15:50:34', 'active'),
('6e06071b-86ef-44f7-b052-e6dab3383be1', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"678910\",\"updatedAt\":\"2023-09-25T14:50:51.758Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:50:51.758Z\",\"accountNumberType\":\"bank\",\"id\":\"6e06071b-86ef-44f7-b052-e6dab3383be1\",\"country\":\"ZA\",\"name\":\"Tyme Bank\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('6ef18cb4-1c34-4129-84c4-e626a6a73d10', 'fe8f4989-3bf6-41ca-9621-ffe2bc127569', 'NG', '{\"code\":\"076\",\"updatedAt\":\"2023-06-08T15:18:44.135Z\",\"status\":\"active\",\"channelIds\":[\"fe8f4989-3bf6-41ca-9621-ffe2bc127569\",\"af944f0c-ba70-47c7-86dc-1bad5a6ab4e4\"],\"accountNumberType\":\"bank\",\"id\":\"6ef18cb4-1c34-4129-84c4-e626a6a73d10\",\"country\":\"NG\",\"name\":\"Skye Bank\",\"countryAccountNumberType\":\"NGBANK\"}', '2025-11-07 15:50:34', 'active'),
('70b4c91a-0dfd-457c-8604-10fa28fcb00d', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"790005\",\"updatedAt\":\"2023-09-25T14:50:51.758Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:50:51.758Z\",\"accountNumberType\":\"bank\",\"id\":\"70b4c91a-0dfd-457c-8604-10fa28fcb00d\",\"country\":\"ZA\",\"name\":\"Unibank\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('754202b6-da04-5f18-a86a-e5b2dd86bbb5', 'fe8f4989-3bf6-41ca-9621-ffe2bc127569', 'NG', '{\"code\":\"050\",\"updatedAt\":\"2023-06-08T15:18:44.135Z\",\"status\":\"active\",\"channelIds\":[\"fe8f4989-3bf6-41ca-9621-ffe2bc127569\",\"af944f0c-ba70-47c7-86dc-1bad5a6ab4e4\"],\"accountNumberType\":\"bank\",\"id\":\"754202b6-da04-5f18-a86a-e5b2dd86bbb5\",\"country\":\"NG\",\"name\":\"Ecobank Nigeria\",\"countryAccountNumberType\":\"NGBANK\"}', '2025-11-07 15:50:34', 'active'),
('75faa922-8a18-4c54-a357-6d6a670379a3', 'fe8f4989-3bf6-41ca-9621-ffe2bc127569', 'NG', '{\"code\":\"033\",\"updatedAt\":\"2023-06-08T15:18:44.135Z\",\"status\":\"active\",\"channelIds\":[\"fe8f4989-3bf6-41ca-9621-ffe2bc127569\",\"af944f0c-ba70-47c7-86dc-1bad5a6ab4e4\"],\"accountNumberType\":\"bank\",\"id\":\"75faa922-8a18-4c54-a357-6d6a670379a3\",\"country\":\"NG\",\"name\":\"United Bank for Africa\",\"countryAccountNumberType\":\"NGBANK\"}', '2025-11-07 15:50:34', 'active'),
('790567b6-da04-5f18-a86a-e5b2dd86bbb5', 'fe8f4989-3bf6-41ca-9621-ffe2bc127569', 'NG', '{\"code\":\"011\",\"updatedAt\":\"2023-06-08T15:18:44.135Z\",\"status\":\"active\",\"channelIds\":[\"fe8f4989-3bf6-41ca-9621-ffe2bc127569\",\"af944f0c-ba70-47c7-86dc-1bad5a6ab4e4\"],\"accountNumberType\":\"bank\",\"id\":\"790567b6-da04-5f18-a86a-e5b2dd86bbb5\",\"country\":\"NG\",\"name\":\"First Bank of Nigeria\",\"countryAccountNumberType\":\"NGBANK\"}', '2025-11-07 15:50:34', 'active'),
('7c56fe9b-e36f-4c0b-9baa-d734b8633dff', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"632005\",\"updatedAt\":\"2023-09-25T14:48:05.577Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:48:05.577Z\",\"accountNumberType\":\"bank\",\"id\":\"7c56fe9b-e36f-4c0b-9baa-d734b8633dff\",\"country\":\"ZA\",\"name\":\"Absa Bank\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('7ea6df5c-6bba-46b2-a7e6-f511959e7edb', 'a3f3a711-c50e-4e53-b867-7d1d148cd43b', 'KE', '{\"featureFlagEnabled\":[],\"code\":\"M PESA\",\"tempDisabledFor\":[],\"updatedAt\":\"2024-08-12T12:29:48.902Z\",\"status\":\"active\",\"channelIds\":[\"a3f3a711-c50e-4e53-b867-7d1d148cd43b\",\"71700f34-c42a-4b61-96a4-db79f6d5684b\"],\"createdAt\":\"2023-03-22T18:07:08.974Z\",\"accountNumberType\":\"phone\",\"id\":\"7ea6df5c-6bba-46b2-a7e6-f511959e7edb\",\"country\":\"KE\",\"name\":\"Mobile Wallet (M-PESA)\",\"countryAccountNumberType\":\"KEPHONE\"}', '2025-10-23 13:41:41', 'active'),
('8372b386-cfeb-4f14-8aab-2cd3729c4869', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"51001\",\"updatedAt\":\"2023-09-25T14:50:51.758Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:50:51.758Z\",\"accountNumberType\":\"bank\",\"id\":\"8372b386-cfeb-4f14-8aab-2cd3729c4869\",\"country\":\"ZA\",\"name\":\"Standard Bank (South Africa)\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('856ae78b-e29c-45d4-bc17-7988dc0bfbbb', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"584000\",\"updatedAt\":\"2023-09-25T14:48:05.578Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:48:05.578Z\",\"accountNumberType\":\"bank\",\"id\":\"856ae78b-e29c-45d4-bc17-7988dc0bfbbb\",\"country\":\"ZA\",\"name\":\"Grinrod Bank\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('8607a7ba-c910-410c-a6b1-f73c425dd3b7', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"261251\",\"updatedAt\":\"2023-09-25T14:50:51.758Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:50:51.758Z\",\"accountNumberType\":\"bank\",\"id\":\"8607a7ba-c910-410c-a6b1-f73c425dd3b7\",\"country\":\"ZA\",\"name\":\"Rand Merchant Bank\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('8b4514c1-c472-4a66-9390-af634d72d46b', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"460005\",\"updatedAt\":\"2023-09-25T14:50:51.758Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:50:51.758Z\",\"accountNumberType\":\"bank\",\"id\":\"8b4514c1-c472-4a66-9390-af634d72d46b\",\"country\":\"ZA\",\"name\":\"Postbank\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('8d18204e-b51f-4554-815d-71586d0dac13', '33a82864-6460-43d7-9fc0-911f9bd8d50a', 'CI', '{\"code\":\"Wave\",\"updatedAt\":\"2023-06-08T15:33:10.072Z\",\"status\":\"active\",\"channelIds\":[\"33a82864-6460-43d7-9fc0-911f9bd8d50a\",\"2452c27c-7c49-442c-b6f8-cde03f03f9ba\",\"8b302864-6460-43d7-9fc0-911f9bd8a091\"],\"createdAt\":\"2022-12-19T00:50:34.599Z\",\"accountNumberType\":\"phone\",\"id\":\"8d18204e-b51f-4554-815d-71586d0dac13\",\"country\":\"CI\",\"name\":\"Wave\",\"countryAccountNumberType\":\"CIPHONE\"}', '2025-11-07 15:50:39', 'active'),
('8d198bdb-e007-4646-b945-48192a91dc79', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"683000\",\"updatedAt\":\"2023-09-25T14:50:51.758Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:50:51.758Z\",\"accountNumberType\":\"bank\",\"id\":\"8d198bdb-e007-4646-b945-48192a91dc79\",\"country\":\"ZA\",\"name\":\"Sasfin Bank Limited\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('8e1bd085-5ed0-4adf-a16d-be819e599940', 'fe8f4989-3bf6-41ca-9621-ffe2bc127569', 'NG', '{\"code\":\"232\",\"updatedAt\":\"2023-06-08T15:18:44.135Z\",\"status\":\"active\",\"channelIds\":[\"fe8f4989-3bf6-41ca-9621-ffe2bc127569\",\"af944f0c-ba70-47c7-86dc-1bad5a6ab4e4\"],\"accountNumberType\":\"bank\",\"id\":\"8e1bd085-5ed0-4adf-a16d-be819e599940\",\"country\":\"NG\",\"name\":\"Sterling Bank\",\"countryAccountNumberType\":\"NGBANK\"}', '2025-11-07 15:50:34', 'active'),
('8ff2ece4-3a97-4f86-9c21-db6db8c477b4', 'fe8f4989-3bf6-41ca-9621-ffe2bc127569', 'NG', '{\"code\":\"030\",\"updatedAt\":\"2023-06-08T15:18:44.135Z\",\"status\":\"active\",\"channelIds\":[\"fe8f4989-3bf6-41ca-9621-ffe2bc127569\",\"af944f0c-ba70-47c7-86dc-1bad5a6ab4e4\"],\"accountNumberType\":\"bank\",\"id\":\"8ff2ece4-3a97-4f86-9c21-db6db8c477b4\",\"country\":\"NG\",\"name\":\"Heritage Bank\",\"countryAccountNumberType\":\"NGBANK\"}', '2025-11-07 15:50:34', 'active'),
('91ae75e6-a492-4a47-a25e-ebd1727b8b8c', '1239227d-f33a-4d7a-8520-0a0cf41988fb', 'BW', '{\"code\":{\"Fair grounds\":\"00649\",\"Airport Junction Branch\":\"603\",\"Mogoditshane Branch\":\"653\"},\"status\":\"active\",\"channelIds\":[\"1239227d-f33a-4d7a-8520-0a0cf41988fb\",\"602060c6-b4af-49a4-b8fd-2fdd0dbf13ce\"],\"accountNumberType\":\"bank\",\"id\":\"91ae75e6-a492-4a47-a25e-ebd1727b8b8c\",\"country\":\"BW\",\"name\":\"STANBIC BANK\",\"countryAccountNumberType\":\"BWBANK\"}', '2025-10-30 17:06:44', 'active'),
('9388a1f2-8a29-4bf6-83a0-e4280de53baa', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"198765\",\"updatedAt\":\"2023-09-25T14:48:05.578Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:48:05.578Z\",\"accountNumberType\":\"bank\",\"id\":\"9388a1f2-8a29-4bf6-83a0-e4280de53baa\",\"country\":\"ZA\",\"name\":\"Nedbank (South Africa)\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('945e170a-2c42-4b58-a5c2-cd6962c1af7f', 'fbd1276a-8709-44e0-ac1d-9b41656591cd', 'BF', '{\"code\":\"Orange Money\",\"updatedAt\":\"2023-06-08T15:33:10.072Z\",\"status\":\"active\",\"channelIds\":[\"fbd1276a-8709-44e0-ac1d-9b41656591cd\",\"9c94cad1-ffc4-4211-ae69-e62c72827d01\"],\"createdAt\":\"2022-12-19T00:50:34.599Z\",\"accountNumberType\":\"phone\",\"id\":\"945e170a-2c42-4b58-a5c2-cd6962c1af7f\",\"country\":\"BF\",\"name\":\"Orange Money\",\"countryAccountNumberType\":\"BFPHONE\"}', '2025-11-07 15:50:44', 'active'),
('97641d84-6b7c-405c-8aa2-5795758af247', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"431010\",\"updatedAt\":\"2023-09-25T14:50:51.758Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:50:51.758Z\",\"accountNumberType\":\"bank\",\"id\":\"97641d84-6b7c-405c-8aa2-5795758af247\",\"country\":\"ZA\",\"name\":\"Ubank\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('98b219a0-2f80-4f2a-9d7d-487d348f9ea4', 'fe8f4989-3bf6-41ca-9621-ffe2bc127569', 'NG', '{\"code\":\"068\",\"updatedAt\":\"2023-06-08T15:18:44.135Z\",\"status\":\"active\",\"channelIds\":[\"fe8f4989-3bf6-41ca-9621-ffe2bc127569\",\"af944f0c-ba70-47c7-86dc-1bad5a6ab4e4\"],\"accountNumberType\":\"bank\",\"id\":\"98b219a0-2f80-4f2a-9d7d-487d348f9ea4\",\"country\":\"NG\",\"name\":\"Standard Chartered Bank\",\"countryAccountNumberType\":\"NGBANK\"}', '2025-11-07 15:50:34', 'active'),
('9ecd5f0e-13ea-4cea-b3d0-1e964d55afbb', 'fbd1276a-8709-44e0-ac1d-9b41656591cd', 'BF', '{\"code\":\"Moov money\",\"updatedAt\":\"2023-06-08T15:33:10.072Z\",\"status\":\"active\",\"channelIds\":[\"fbd1276a-8709-44e0-ac1d-9b41656591cd\",\"9c94cad1-ffc4-4211-ae69-e62c72827d01\"],\"createdAt\":\"2022-12-19T00:50:34.599Z\",\"accountNumberType\":\"phone\",\"id\":\"9ecd5f0e-13ea-4cea-b3d0-1e964d55afbb\",\"country\":\"BF\",\"name\":\"Moov Money\",\"countryAccountNumberType\":\"BFPHONE\"}', '2025-11-07 15:50:44', 'active'),
('a0db3097-e94c-4bd9-b67e-f3557976c6f2', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"87373\",\"updatedAt\":\"2023-09-25T14:50:51.758Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:50:51.758Z\",\"accountNumberType\":\"bank\",\"id\":\"a0db3097-e94c-4bd9-b67e-f3557976c6f2\",\"country\":\"ZA\",\"name\":\"Standard Bank Namibia\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('a67435ea-450e-46b7-9138-4eb4f7c12c1b', '695c718c-aab7-4670-b81f-b1da6191f37f', 'RW', '{\"code\":\"Mobile Wallet\",\"updatedAt\":\"2023-06-08T15:18:44.135Z\",\"status\":\"active\",\"channelIds\":[\"695c718c-aab7-4670-b81f-b1da6191f37f\",\"4f740b63-f327-481e-afe4-79ae4d4d9f9c\"],\"accountNumberType\":\"phone\",\"createdAt\":\"2023-03-22T16:59:32.789Z\",\"id\":\"a67435ea-450e-46b7-9138-4eb4f7c12c1b\",\"country\":\"RW\",\"name\":\"Mobile Wallet\",\"countryAccountNumberType\":\"RWPHONE\"}', '2025-11-07 15:50:43', 'active'),
('a84f929b-7b0a-475f-b735-db8feba4fe8e', '2cb75e87-7a02-48cb-bee8-93f38b96dbc9', 'GH', '{\"code\":\"VOD\",\"updatedAt\":\"2023-06-08T15:18:44.135Z\",\"status\":\"active\",\"channelIds\":[\"415ae56f-24f9-476a-9f18-6a656b952db2\",\"2cb75e87-7a02-48cb-bee8-93f38b96dbc9\"],\"accountNumberType\":\"phone\",\"id\":\"a84f929b-7b0a-475f-b735-db8feba4fe8e\",\"country\":\"GH\",\"name\":\"Vodafone\",\"countryAccountNumberType\":\"GHPHONE\"}', '2025-11-07 15:50:48', 'active'),
('ac522946-3d5d-488e-bf73-583b8d8de908', '88c80c44-23a8-4729-9e36-7be766effefb', 'MW', '{\"code\":\"TNM_MWI\",\"tempDisabledFor\":[],\"updatedAt\":\"2024-01-23T20:18:51.158Z\",\"status\":\"active\",\"channelIds\":[\"7b317104-d142-44b6-8096-312ea0fb30a0\",\"88c80c44-23a8-4729-9e36-7be766effefb\"],\"createdAt\":\"2024-01-23T20:18:51.158Z\",\"accountNumberType\":\"phone\",\"id\":\"ac522946-3d5d-488e-bf73-583b8d8de908\",\"country\":\"MW\",\"name\":\"TNM\",\"countryAccountNumberType\":\"MWPHONE\"}', '2025-10-30 17:06:49', 'active'),
('ad54749f-be0c-45ec-9a77-edfa3848099e', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"430000\",\"updatedAt\":\"2023-09-25T14:48:05.577Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:48:05.577Z\",\"accountNumberType\":\"bank\",\"id\":\"ad54749f-be0c-45ec-9a77-edfa3848099e\",\"country\":\"ZA\",\"name\":\"African Bank\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('b1a1bf8a-15fa-4454-a0fa-38a813a56c5a', 'fe8f4989-3bf6-41ca-9621-ffe2bc127569', 'NG', '{\"code\":\"063\",\"updatedAt\":\"2023-06-08T15:18:44.135Z\",\"status\":\"active\",\"channelIds\":[\"fe8f4989-3bf6-41ca-9621-ffe2bc127569\",\"af944f0c-ba70-47c7-86dc-1bad5a6ab4e4\"],\"accountNumberType\":\"bank\",\"id\":\"b1a1bf8a-15fa-4454-a0fa-38a813a56c5a\",\"country\":\"NG\",\"name\":\"Diamond Bank\",\"countryAccountNumberType\":\"NGBANK\"}', '2025-11-07 15:50:34', 'active'),
('b54a0fae-b9c5-43bd-aedd-db897945c18d', '18ef89ef-d91d-4961-94ce-9eda333db910', 'TZ', '{\"featureFlagEnabled\":[],\"code\":\"VODACOM\",\"tempDisabledFor\":[],\"updatedAt\":\"2024-07-24T14:09:44.280Z\",\"status\":\"active\",\"channelIds\":[\"eba441c9-199a-4e91-94a3-e019c4f145f9\",\"18ef89ef-d91d-4961-94ce-9eda333db910\"],\"createdAt\":\"2024-07-24T14:09:44.280Z\",\"accountNumberType\":\"phone\",\"id\":\"b54a0fae-b9c5-43bd-aedd-db897945c18d\",\"country\":\"TZ\",\"name\":\"VODACOM\",\"countryAccountNumberType\":\"TZPHONE\"}', '2025-11-07 15:50:44', 'active'),
('b747826c-1384-42a1-9eaf-c1b47e0d675d', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"590000\",\"updatedAt\":\"2023-09-25T14:48:05.577Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:48:05.577Z\",\"accountNumberType\":\"bank\",\"id\":\"b747826c-1384-42a1-9eaf-c1b47e0d675d\",\"country\":\"ZA\",\"name\":\"Barclays Bank\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('bc54ef2a-d7d1-45d9-a888-260522a7162b', '1239227d-f33a-4d7a-8520-0a0cf41988fb', 'BW', '{\"featureFlagEnabled\":[],\"code\":{\"All Branches\":\"1101\",\"Francistown Branch\":\"1102\",\"Gaborone West Branch\":\"1103\",\"Palapye Branch\":\"1104\"},\"tempDisabledFor\":[],\"updatedAt\":\"2024-07-29T15:41:24.684Z\",\"status\":\"active\",\"channelIds\":[\"1239227d-f33a-4d7a-8520-0a0cf41988fb\",\"602060c6-b4af-49a4-b8fd-2fdd0dbf13ce\"],\"createdAt\":\"2024-07-29T15:41:24.684Z\",\"accountNumberType\":\"bank\",\"id\":\"bc54ef2a-d7d1-45d9-a888-260522a7162b\",\"country\":\"BW\",\"name\":\"Bank Of Baroda Botswana\",\"countryAccountNumberType\":\"BWBANK\"}', '2025-10-30 17:06:44', 'active'),
('beb8b374-5f59-4afd-8133-10c08294fa0c', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"580105\",\"updatedAt\":\"2023-09-25T14:48:05.578Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:48:05.578Z\",\"accountNumberType\":\"bank\",\"id\":\"beb8b374-5f59-4afd-8133-10c08294fa0c\",\"country\":\"ZA\",\"name\":\"Investec Bank\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('d12062c8-6ed7-479a-80cd-ebbff16ef1b4', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"800000\",\"updatedAt\":\"2023-09-25T14:48:05.577Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:48:05.577Z\",\"accountNumberType\":\"bank\",\"id\":\"d12062c8-6ed7-479a-80cd-ebbff16ef1b4\",\"country\":\"ZA\",\"name\":\"Albaraka Bank\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('d1843b02-d571-4959-82ab-071ff0db237e', 'fe8f4989-3bf6-41ca-9621-ffe2bc127569', 'NG', '{\"code\":\"084\",\"updatedAt\":\"2023-06-08T15:18:44.135Z\",\"status\":\"active\",\"channelIds\":[\"fe8f4989-3bf6-41ca-9621-ffe2bc127569\",\"af944f0c-ba70-47c7-86dc-1bad5a6ab4e4\"],\"accountNumberType\":\"bank\",\"id\":\"d1843b02-d571-4959-82ab-071ff0db237e\",\"country\":\"NG\",\"name\":\"Enterprise Bank\",\"countryAccountNumberType\":\"NGBANK\"}', '2025-11-07 15:50:34', 'active'),
('d2bbb2b8-0db8-4b33-bd7e-3fe792839fb7', 'fe8f4989-3bf6-41ca-9621-ffe2bc127569', 'NG', '{\"code\":\"070\",\"updatedAt\":\"2023-06-08T15:18:44.135Z\",\"status\":\"active\",\"channelIds\":[\"fe8f4989-3bf6-41ca-9621-ffe2bc127569\",\"af944f0c-ba70-47c7-86dc-1bad5a6ab4e4\"],\"accountNumberType\":\"bank\",\"id\":\"d2bbb2b8-0db8-4b33-bd7e-3fe792839fb7\",\"country\":\"NG\",\"name\":\"Fidelity Bank\",\"countryAccountNumberType\":\"NGBANK\"}', '2025-11-07 15:50:34', 'active'),
('d5212d1c-e9bb-4db6-8dc0-aefe3a925a65', 'fe8f4989-3bf6-41ca-9621-ffe2bc127569', 'NG', '{\"code\":\"023\",\"updatedAt\":\"2023-06-08T15:18:44.135Z\",\"status\":\"active\",\"channelIds\":[\"fe8f4989-3bf6-41ca-9621-ffe2bc127569\",\"af944f0c-ba70-47c7-86dc-1bad5a6ab4e4\"],\"accountNumberType\":\"bank\",\"id\":\"d5212d1c-e9bb-4db6-8dc0-aefe3a925a65\",\"country\":\"NG\",\"name\":\"Citibank Nigeria\",\"countryAccountNumberType\":\"NGBANK\"}', '2025-11-07 15:50:34', 'active'),
('d6489301-247f-4c7e-930f-440549aaf250', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"588000\",\"updatedAt\":\"2023-09-25T14:50:51.758Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:50:51.758Z\",\"accountNumberType\":\"bank\",\"id\":\"d6489301-247f-4c7e-930f-440549aaf250\",\"country\":\"ZA\",\"name\":\"Vbs Mutual Bank\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('d659aee4-674a-40dc-b5b3-31387d4b5d1c', 'fe8f4989-3bf6-41ca-9621-ffe2bc127569', 'NG', '{\"code\":\"014\",\"updatedAt\":\"2023-06-08T15:18:44.135Z\",\"status\":\"active\",\"channelIds\":[\"fe8f4989-3bf6-41ca-9621-ffe2bc127569\",\"af944f0c-ba70-47c7-86dc-1bad5a6ab4e4\"],\"accountNumberType\":\"bank\",\"id\":\"d659aee4-674a-40dc-b5b3-31387d4b5d1c\",\"country\":\"NG\",\"name\":\"Mainstreet Bank\",\"countryAccountNumberType\":\"NGBANK\"}', '2025-11-07 15:50:34', 'active'),
('d79e89b6-ca84-4bf2-aed7-c48e297c2f22', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"490991\",\"updatedAt\":\"2023-09-25T14:48:05.578Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:48:05.578Z\",\"accountNumberType\":\"bank\",\"id\":\"d79e89b6-ca84-4bf2-aed7-c48e297c2f22\",\"country\":\"ZA\",\"name\":\"Mtn Banking\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('d80b8a29-c084-4624-8f89-3339be2161eb', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"470010\",\"updatedAt\":\"2023-09-25T14:48:05.578Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:48:05.578Z\",\"accountNumberType\":\"bank\",\"id\":\"d80b8a29-c084-4624-8f89-3339be2161eb\",\"country\":\"ZA\",\"name\":\"Capitec Bank\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('dc9beb81-3398-4dc1-bc84-70cc7c61b5fc', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"250655\",\"updatedAt\":\"2023-09-25T14:48:05.578Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:48:05.578Z\",\"accountNumberType\":\"bank\",\"id\":\"dc9beb81-3398-4dc1-bc84-70cc7c61b5fc\",\"country\":\"ZA\",\"name\":\"First National Bank (South Africa)\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('dd16186e-9fc4-4537-a59f-91686c6413fa', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"432000\",\"updatedAt\":\"2023-09-25T14:48:05.578Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:48:05.578Z\",\"accountNumberType\":\"bank\",\"id\":\"dd16186e-9fc4-4537-a59f-91686c6413fa\",\"country\":\"ZA\",\"name\":\"Jp Morgan Chase Bank\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('e981768b-19b3-4ef5-ad03-a2195f0d87df', '2cb75e87-7a02-48cb-bee8-93f38b96dbc9', 'GH', '{\"code\":\"GLO\",\"updatedAt\":\"2023-06-08T15:18:44.135Z\",\"status\":\"active\",\"channelIds\":[\"415ae56f-24f9-476a-9f18-6a656b952db2\",\"2cb75e87-7a02-48cb-bee8-93f38b96dbc9\"],\"accountNumberType\":\"phone\",\"id\":\"e981768b-19b3-4ef5-ad03-a2195f0d87df\",\"country\":\"GH\",\"name\":\"Glo\",\"countryAccountNumberType\":\"GHPHONE\"}', '2025-11-07 15:50:48', 'active'),
('ec2fe23d-8c72-4a40-aaa2-76921703dddd', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"282672\",\"updatedAt\":\"2023-09-25T14:48:05.578Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:48:05.578Z\",\"accountNumberType\":\"bank\",\"id\":\"ec2fe23d-8c72-4a40-aaa2-76921703dddd\",\"country\":\"ZA\",\"name\":\"First National Bank Namibia\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('eff2baef-8676-4ef6-915c-10c9f001d9d3', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"350005\",\"updatedAt\":\"2023-09-25T14:48:05.578Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:48:05.578Z\",\"accountNumberType\":\"bank\",\"id\":\"eff2baef-8676-4ef6-915c-10c9f001d9d3\",\"country\":\"ZA\",\"name\":\"Citi Bank\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('f88442aa-acda-4bbf-863a-ce4f14bee064', 'b3c6151a-6076-47af-920f-5aff74bb906e', 'ZA', '{\"code\":\"280164\",\"updatedAt\":\"2023-09-25T14:48:05.578Z\",\"status\":\"active\",\"channelIds\":[\"81018280-e320-4c81-9b2f-6f636c2239d8\",\"b3c6151a-6076-47af-920f-5aff74bb906e\"],\"createdAt\":\"2023-09-25T14:48:05.578Z\",\"accountNumberType\":\"bank\",\"id\":\"f88442aa-acda-4bbf-863a-ce4f14bee064\",\"country\":\"ZA\",\"name\":\"First National Bank Swaziland\",\"countryAccountNumberType\":\"ZABANK\"}', '2025-11-07 15:50:45', 'active'),
('fa316206-dacc-4e87-a80a-5f539a719c56', 'fe8f4989-3bf6-41ca-9621-ffe2bc127569', 'NG', '{\"code\":\"032\",\"updatedAt\":\"2023-06-08T15:18:44.135Z\",\"status\":\"active\",\"channelIds\":[\"fe8f4989-3bf6-41ca-9621-ffe2bc127569\",\"af944f0c-ba70-47c7-86dc-1bad5a6ab4e4\"],\"accountNumberType\":\"bank\",\"id\":\"fa316206-dacc-4e87-a80a-5f539a719c56\",\"country\":\"NG\",\"name\":\"Union Bank of Nigeria\",\"countryAccountNumberType\":\"NGBANK\"}', '2025-11-07 15:50:34', 'active'),
('fff0ac9b-b870-4270-ac96-0f57602f9b2f', '2cb75e87-7a02-48cb-bee8-93f38b96dbc9', 'GH', '{\"code\":\"AIR\",\"updatedAt\":\"2023-06-08T15:18:44.135Z\",\"status\":\"active\",\"channelIds\":[\"415ae56f-24f9-476a-9f18-6a656b952db2\",\"2cb75e87-7a02-48cb-bee8-93f38b96dbc9\"],\"accountNumberType\":\"phone\",\"id\":\"fff0ac9b-b870-4270-ac96-0f57602f9b2f\",\"country\":\"GH\",\"name\":\"AirtelTigo\",\"countryAccountNumberType\":\"GHPHONE\"}', '2025-11-07 15:50:48', 'active');

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

--
-- Table structure for table `yellowcard_rates_cache`
--

CREATE TABLE `yellowcard_rates_cache` (
  `currency_code` varchar(10) NOT NULL,
  `rate_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`rate_data`)),
  `last_updated` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `yellowcard_rates_cache`
--

INSERT INTO `yellowcard_rates_cache` (`currency_code`, `rate_data`, `last_updated`) VALUES
('ADA', '{\"buy\":0.5408,\"sell\":0.5408,\"locale\":\"crypto\",\"rateId\":\"cardano\",\"code\":\"ADA\",\"updatedAt\":\"2025-11-07T15:47:37.949Z\"}', '2025-11-07 15:50:31'),
('BTC', '{\"buy\":100564.93,\"sell\":100564.93,\"locale\":\"crypto\",\"rateId\":\"bitcoin\",\"code\":\"BTC\",\"updatedAt\":\"2025-11-07T15:47:59.909Z\"}', '2025-11-07 15:50:31'),
('BWP', '{\"buy\":13.67,\"sell\":13.29,\"locale\":\"Bw\",\"rateId\":\"pula\",\"code\":\"BWP\",\"updatedAt\":\"2025-11-07T15:35:42.933Z\"}', '2025-11-07 15:50:31'),
('CDF', '{\"buy\":2164.18,\"sell\":2164.18,\"locale\":\"CD\",\"rateId\":\"congolese-franc\",\"code\":\"CDF\",\"updatedAt\":\"2025-11-07T15:48:45.624Z\"}', '2025-11-07 15:50:31'),
('CUSD', '{\"buy\":1,\"sell\":1,\"locale\":\"crypto\",\"rateId\":\"celo-dollar\",\"code\":\"CUSD\",\"updatedAt\":\"2025-11-07T15:48:08.366Z\"}', '2025-11-07 15:50:31'),
('ETH', '{\"buy\":3842.9932,\"sell\":3842.9932,\"locale\":\"crypto\",\"rateId\":\"ethereum\",\"code\":\"ETH\",\"updatedAt\":\"2025-10-31T10:34:56.853Z\"}', '2025-11-07 15:50:31'),
('GHS', '{\"buy\":16.2,\"sell\":15.7,\"locale\":\"GH\",\"rateId\":\"cedi\",\"code\":\"GHS\",\"updatedAt\":\"2025-08-20T18:20:25.325Z\"}', '2025-11-07 15:50:31'),
('KES', '{\"buy\":131.53,\"sell\":127.94,\"locale\":\"KE\",\"rateId\":\"kenyan-shilling\",\"code\":\"KES\",\"updatedAt\":\"2025-11-07T15:48:32.926Z\"}', '2025-11-07 15:50:31'),
('LSL', '{\"buy\":17.32,\"sell\":17.32,\"locale\":\"LS\",\"rateId\":\"lesotho-loti\",\"code\":\"LSL\",\"updatedAt\":\"2025-11-07T15:47:04.934Z\"}', '2025-11-07 15:50:31'),
('MWK', '{\"buy\":1735.35,\"sell\":1735.35,\"locale\":\"MW\",\"rateId\":\"malawian-kwacha\",\"code\":\"MWK\",\"updatedAt\":\"2025-08-20T11:35:06.224Z\"}', '2025-11-07 15:50:31'),
('NGN', '{\"buy\":1615,\"sell\":1580,\"locale\":\"NG\",\"rateId\":\"naira\",\"code\":\"NGN\",\"updatedAt\":\"2025-11-07T15:49:59.488Z\"}', '2025-11-07 15:50:31'),
('POL', '{\"buy\":0.1717,\"sell\":0.1717,\"locale\":\"crypto\",\"rateId\":\"polygon-pol\",\"code\":\"POL\",\"updatedAt\":\"2025-11-07T15:48:55.985Z\"}', '2025-11-07 15:50:31'),
('RWF', '{\"buy\":1420,\"sell\":1364,\"locale\":\"RW\",\"rateId\":\"rwandan-franc\",\"code\":\"RWF\",\"updatedAt\":\"2025-11-07T15:47:55.906Z\"}', '2025-11-07 15:50:31'),
('SOL', '{\"buy\":181.1212,\"sell\":181.1212,\"locale\":\"crypto\",\"rateId\":\"solana\",\"code\":\"SOL\",\"updatedAt\":\"2025-08-18T11:50:12.475Z\"}', '2025-11-07 15:50:31'),
('TRX', '{\"buy\":0.2859,\"sell\":0.2859,\"locale\":\"crypto\",\"rateId\":\"tron\",\"code\":\"TRX\",\"updatedAt\":\"2025-11-07T15:49:58.744Z\"}', '2025-11-07 15:50:31'),
('TZS', '{\"buy\":2455,\"sell\":2455,\"locale\":\"TZ\",\"rateId\":\"tanzanian-shilling\",\"code\":\"TZS\",\"updatedAt\":\"2025-11-07T15:46:47.644Z\"}', '2025-11-07 15:50:31'),
('UGX', '{\"buy\":3592.26,\"sell\":3521.12,\"locale\":\"UG\",\"rateId\":\"ugandan-shilling\",\"code\":\"UGX\",\"updatedAt\":\"2025-08-19T08:20:02.040Z\"}', '2025-11-07 15:50:31'),
('USDC', '{\"buy\":1,\"sell\":1,\"locale\":\"crypto\",\"rateId\":\"usd-coin\",\"code\":\"USDC\",\"updatedAt\":\"2025-10-21T10:05:11.138Z\"}', '2025-11-07 15:50:31'),
('USDT', '{\"buy\":1,\"sell\":1,\"locale\":\"crypto\",\"rateId\":\"usdt\",\"code\":\"USDT\",\"updatedAt\":\"2025-11-07T15:46:50.968Z\"}', '2025-11-07 15:50:31'),
('XAF', '{\"buy\":565.1,\"sell\":565.1,\"locale\":\"CM\",\"rateId\":\"franc\",\"code\":\"XAF\",\"updatedAt\":\"2025-08-21T15:35:04.334Z\"}', '2025-11-07 15:50:31'),
('XAUT', '{\"buy\":3882.3603,\"sell\":3882.3603,\"locale\":\"crypto\",\"rateId\":\"gold-tether\",\"code\":\"XAUT\",\"updatedAt\":\"2025-10-02T13:04:49.204Z\"}', '2025-11-07 15:50:31'),
('XOF', '{\"buy\":566.45,\"sell\":566.45,\"locale\":\"CI\",\"rateId\":\"west-african-franc\",\"code\":\"XOF\",\"updatedAt\":\"2025-11-07T15:49:15.108Z\"}', '2025-11-07 15:50:31'),
('XRP', '{\"buy\":2.2062,\"sell\":2.2062,\"locale\":\"crypto\",\"rateId\":\"ripple-xrp\",\"code\":\"XRP\",\"updatedAt\":\"2025-11-07T15:47:12.190Z\"}', '2025-11-07 15:50:31'),
('ZAR', '{\"buy\":17.83,\"sell\":17.59,\"locale\":\"ZA\",\"rateId\":\"south-african-rand\",\"code\":\"ZAR\",\"updatedAt\":\"2025-11-07T15:47:02.267Z\"}', '2025-11-07 15:50:31'),
('ZMW', '{\"buy\":23.27,\"sell\":23.27,\"locale\":\"ZM\",\"rateId\":\"kwacha\",\"code\":\"ZMW\",\"updatedAt\":\"2025-08-21T11:05:00.373Z\"}', '2025-11-07 15:50:31');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `borderless_transactions`
--
ALTER TABLE `borderless_transactions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `transaction_id` (`transaction_id`),
  ADD KEY `idx_user_id` (`user_id`),
  ADD KEY `idx_created_at` (`created_at`),
  ADD KEY `idx_status` (`status`);

--
-- Indexes for table `border_fee_structure`
--
ALTER TABLE `border_fee_structure`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_country_network` (`country_code`,`network_type`);

--
-- Indexes for table `border_payments`
--
ALTER TABLE `border_payments`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `reference` (`reference`),
  ADD KEY `idx_user_id` (`user_id`),
  ADD KEY `idx_reference` (`reference`),
  ADD KEY `idx_status` (`status`),
  ADD KEY `idx_created_at` (`created_at`);

--
-- Indexes for table `yellowcard_channels_cache`
--
ALTER TABLE `yellowcard_channels_cache`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_country` (`country`),
  ADD KEY `idx_currency` (`currency`),
  ADD KEY `idx_status` (`status`);

--
-- Indexes for table `yellowcard_networks_cache`
--
ALTER TABLE `yellowcard_networks_cache`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_channel_id` (`channel_id`),
  ADD KEY `idx_country` (`country`),
  ADD KEY `idx_status` (`status`);

--
-- Indexes for table `yellowcard_rates_cache`
--
ALTER TABLE `yellowcard_rates_cache`
  ADD PRIMARY KEY (`currency_code`),
  ADD KEY `idx_currency` (`currency_code`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `borderless_transactions`
--
ALTER TABLE `borderless_transactions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `border_fee_structure`
--
ALTER TABLE `border_fee_structure`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `border_payments`
--
ALTER TABLE `border_payments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
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 */;
