15-06-23, 05:23 PM
Website - afripay.co.uk
AfriPay Money Transfer - Apps on Google Play
Format - .SQL
Size sql file - 6GB
Date - 2023
All Rows - 15kk
INSERT INTO `beneficiary` (`id`, `customer_id`, `adminUser_id`, `biller_sender`, `created`, `Title`, `firstName`, `middleName`, `lastName`, `second_cmplt_name`, `gender`, `benAccount`, `collection_id`, `Password`, `Address`, `Address1`, `City`, `State`, `Zip`, `postcode`, `occupation`, `Citizenship`, `country_id`, `Phone`, `Mobile`, `email`, `nationalTaxNo`, `isTransfered`, `beneficiaryName`, `dob`, `secMiddleName`, `accountType`, `status`, `moth_maiden_name`, `complianceStatus`, `compListID`, `compliance_note`, `Country`, `relation`, `CompanyName`, `directorName`, `ben_acn`, `ben_abn`, `postal_address`, `postal_suburb`, `postal_postcode`, `postal_state`, `company_regNumber`, `BeneficiaryType`, `refNo`, `receiver_name`, `designation`, `id_number`, `id_type`, `isActive`, `regency`, `currency_cloud_id`, `bank_id`, `mobileNetwork`, `service_type`, `pep_sanction_response`, `created_at`, `updated_at`) VALUES
AfriPay Money Transfer - Apps on Google Play
Format - .SQL
Size sql file - 6GB
Date - 2023
All Rows - 15kk
INSERT INTO `beneficiary` (`id`, `customer_id`, `adminUser_id`, `biller_sender`, `created`, `Title`, `firstName`, `middleName`, `lastName`, `second_cmplt_name`, `gender`, `benAccount`, `collection_id`, `Password`, `Address`, `Address1`, `City`, `State`, `Zip`, `postcode`, `occupation`, `Citizenship`, `country_id`, `Phone`, `Mobile`, `email`, `nationalTaxNo`, `isTransfered`, `beneficiaryName`, `dob`, `secMiddleName`, `accountType`, `status`, `moth_maiden_name`, `complianceStatus`, `compListID`, `compliance_note`, `Country`, `relation`, `CompanyName`, `directorName`, `ben_acn`, `ben_abn`, `postal_address`, `postal_suburb`, `postal_postcode`, `postal_state`, `company_regNumber`, `BeneficiaryType`, `refNo`, `receiver_name`, `designation`, `id_number`, `id_type`, `isActive`, `regency`, `currency_cloud_id`, `bank_id`, `mobileNetwork`, `service_type`, `pep_sanction_response`, `created_at`, `updated_at`) VALUES
Code:
(35643, 56177, NULL, 0, '0000-00-00', '', 'PRISCILIA', 'OKEOGHENE', 'OKPOTO', NULL, NULL, '18408402.00', NULL, '', 'NULL NULL', '', 'LAGOS ISLAND', '', '156', NULL, NULL, NULL, 156, '002348098335414', '002348098335414', '', NULL, 'N', 'PRISCILIA OKEOGHENE OKPOTO', '0000-00-00', '', 'Private User', 'Enabled', NULL, '', '', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '02', NULL, '', '', NULL, NULL, 1, 0, '0', NULL, NULL, NULL, 'PASS', '2021-07-30 09:37:33', '2021-07-30 09:37:33'),
(35644, 56450, NULL, 0, '0000-00-00', '', 'OLUFEMI', '', 'FASHOLA', NULL, NULL, '18408820.00', NULL, '', '', '', 'LAGOS', '', '156', NULL, NULL, NULL, 156, '8033069389', '8033069389', '', NULL, 'N', 'OLUFEMI FASHOLA', '0000-00-00', '', 'Private User', 'Enabled', NULL, '', '', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '02', NULL, '', '', NULL, NULL, 1, 0, '0', NULL, NULL, NULL, 'PASS', '2021-07-30 09:37:33', '2021-07-30 09:37:33'),
(35645, 77623, NULL, 0, '0000-00-00', '', 'MICHAEL', '', 'FELIX', NULL, NULL, '18408826.00', NULL, '', '', '', 'ABUJA', '', '156', NULL, NULL, NULL, 156, '92150149', '92150149', '', NULL, 'N', 'MICHAEL FELIX I. NDEFO', '0000-00-00', '', 'Private User', 'Enabled', NULL, '', '', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '02', NULL, '', '', NULL, NULL, 1, 0, '0', NULL, NULL, NULL, 'PASS', '2021-07-30 09:37:33', '2021-07-30 09:37:33'),
(35646, 56183, NULL, 0, '0000-00-00', '', 'EKALE', '', 'NNAJOFOR', NULL, NULL, '16059432.00', NULL, '', '', '', 'BENIN CITY', '', '156', NULL, NULL, NULL, 156, '8075703378', '8075703378', '', NULL, 'N', 'EKALE NNAJOFOR', '0000-00-00', '', 'Private User', 'Enabled', NULL, '', '', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '02', NULL, '', '', NULL, NULL, 1, 0, '0', NULL, NULL, 'Bank Transfer', 'PASS', '2021-07-30 09:37:33', '2021-07-30 09:37:33'),
(35647, 56188, NULL, 0, '0000-00-00', '', 'PAULKING', '', 'OKOJIE', NULL, NULL, '18408806.00', NULL, '', '', '', 'PORT HARCOURT', '', '156', NULL, NULL, NULL, 156, '8166452888', '8166452888', '', NULL, 'N', 'PAULKING OKOJIE', '0000-00-00', '', 'Private User', 'Enabled', NULL, '', '', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '02', NULL, '', '', NULL, NULL, 1, 0, '0', NULL, NULL, NULL, 'PASS', '2021-07-30 09:37:33', '2021-07-30 09:37:33'),
(35648, 56189, NULL, 0, '0000-00-00', '', 'OKECHUKWU', 'CHARLES', 'ATUA', NULL, NULL, '18409067.00', NULL, '', '', '', 'ONITSHA', '', '156', NULL, NULL, NULL, 156, '', '', '', NULL, 'N', 'OKECHUKWU CHARLES ATUA', '0000-00-00', '', 'Private User', 'Enabled', NULL, '', '', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '02', NULL, '', '', NULL, NULL, 1, 0, '0', NULL, NULL, 'Bank Transfer', 'PASS', '2021-07-30 09:37:33', '2021-07-30 09:37:33'),
(35649, 56190, NULL, 0, '0000-00-00', '', 'OSAZEE', '', 'AIMUFUA', NULL, NULL, '17834024.00', NULL, '', '', '', 'LAGOS', '', '156', NULL, NULL, NULL, 156, '8073243936', '8073243936', '', NULL, 'N', 'OSAZEE AIMUFUA', '0000-00-00', '', 'Private User', 'Enabled', NULL, '', '', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '02', NULL, '', '', NULL, NULL, 1, 0, '0', NULL, NULL, NULL, 'PASS', '2021-07-30 09:37:33', '2021-07-30 09:37:33'),
(35650, 231579, NULL, 0, '0000-00-00', '', 'FRANK', '', 'OMOKORO', NULL, NULL, '17089120.00', NULL, '', '', '', 'BENIN CITY', '', '156', NULL, NULL, NULL, 156, '8067848760', '8067848760', '', NULL, 'N', 'FRANK OMOKORO', '0000-00-00', '', 'Private User', 'Enabled', NULL, '', '', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '02', NULL, '', '', NULL, NULL, 1, 0, '0', NULL, NULL, NULL, 'PASS', '2021-07-30 09:37:33', '2021-07-30 09:37:33'),
(35651, 551095, NULL, 0, '0000-00-00', '', 'ALEXANDER', 'UDECHUKWU', 'ACHIEBO', NULL, NULL, '18409434.00', NULL, '', '', '', 'ABA', '', '156', NULL, NULL, NULL, 156, '8069459825', '8069459825', '', NULL, 'N', 'ALEXANDER UDECHUKWU ACHIEBO', '0000-00-00', '', 'Private User', 'Enabled', NULL, '', '', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '02', NULL, '', '', NULL, NULL, 1, 0, '0', NULL, NULL, 'Bank Transfer', 'PASS', '2021-07-30 09:37:33', '2021-07-30 09:37:33'),
(35652, 56196, NULL, 0, '0000-00-00', '', 'CONFIDENCE', 'NGOZI', 'OGUBUIKE', NULL, NULL, '18409210.00', NULL, '', '', '', 'OWERRI', '', '156', NULL, NULL, NULL, 156, '8065578666', '8065578666', '', NULL, 'N', 'CONFIDENCE NGOZI OGUBUIKE', '0000-00-00', '', 'Private User', 'Enabled', NULL, '', '', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '02', NULL, '', '', NULL, NULL, 1, 0, '0', NULL, NULL, 'Bank Transfer', 'PASS', '2021-07-30 09:37:33', '2021-07-30 09:37:33'),
(35653, 56197, NULL, 0, '0000-00-00', '', 'UTUBOR', '', 'BERNARD', NULL, NULL, '16746285.00', NULL, '', '', '', 'UROMI', '', '156', NULL, NULL, NULL, 156, '', '', '', NULL, 'N', 'UTUBOR BERNARD', '0000-00-00', '', 'Private User', 'Enabled', NULL, '', '', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '02', NULL, '', '', NULL, NULL, 1, 0, '0', NULL, NULL, 'Bank Transfer', 'PASS', '2021-07-30 09:37:33', '2021-07-30 09:37:33'),
(35654, 56200, NULL, 0, '0000-00-00', '', 'ENIOLA', 'OGUNWOLE', 'RHODA', NULL, NULL, '18409712.00', NULL, '', '', '', 'KWARA', '', '156', NULL, NULL, NULL, 156, '7060995775', '7060995775', '', NULL, 'N', 'ENIOLA OGUNWOLE RHODA', '0000-00-00', '', 'Private User', 'Enabled', NULL, '', '', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '02', NULL, '', '', NULL, NULL, 1, 0, '0', NULL, NULL, NULL, 'PASS', '2021-07-30 09:37:33', '2021-07-30 09:37:33'),
(35655, 238134, NULL, 0, '0000-00-00', '', 'KINGSLEY', 'OKECHUKWU', 'UZONU', NULL, NULL, '14908175.00', NULL, '', '', '', 'ENUGU', '', '156', NULL, NULL, NULL, 156, '7038433142', '7038433142', '', NULL, 'N', 'KINGSLEY OKECHUKWU UZONU', '0000-00-00', '', 'Private User', 'Enabled', NULL, '', '', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '02', NULL, '', '', NULL, NULL, 1, 0, '0', NULL, NULL, 'Bank Transfer', 'PASS', '2021-07-30 09:37:33', '2021-07-30 09:37:33'),
(35656, 22968, NULL, 0, '0000-00-00', '', 'IJEOMA CONSTANCE', NULL, 'EKPEMANDU', NULL, NULL, '', NULL, '', '', '', 'ENUGU', '', '', NULL, NULL, NULL, 156, '08033475778', '', '', NULL, 'N', 'IJEOMA CONSTANCE EKPEMANDU', '0000-00-00', '', 'Private User', 'Enabled', NULL, '', '', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', NULL, '', '', NULL, NULL, 1, 0, '0', NULL, NULL, NULL, 'PASS', '2021-07-30 09:37:33', '2021-07-30 09:37:33'),
(35657, 56207, NULL, 0, '0000-00-00', '', 'CHARLES', 'ONYEBUCHI', 'IRONDI', NULL, NULL, '15340581.00', NULL, '', '', '', 'LAGOS', '', '156', NULL, NULL, NULL, 156, '08035085219', '08035085219', '', NULL, 'N', 'CHARLES ONYEBUCHI IRONDI', '0000-00-00', '', 'Private User', 'Enabled', NULL, '', '', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '02', NULL, '', '', NULL, NULL, 1, 0, '0', NULL, NULL, NULL, 'PASS', '2021-07-30 09:37:33', '2021-07-30 09:37:33'),
(35658, 264279, NULL, 0, '0000-00-00', '', 'OKACHI', '', 'CECILIA', NULL, NULL, '16815208.00', NULL, '', '', '', 'LAGOS', '', '156', NULL, NULL, NULL, 156, '7032647004', '7032647004', '', NULL, 'N', 'OKACHI CECILIA', '0000-00-00', '', 'Private User', 'Enabled', NULL, '', '', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '02', NULL, '', '', NULL, NULL, 1, 0, '0', NULL, NULL, 'Bank Transfer', 'PASS', '2021-07-30 09:37:33', '2021-07-30 09:37:33'),
(35659, 51391, NULL, 0, '0000-00-00', 'Mr.', 'NWIGWE OSITADIMMA', '', 'ENDURANCE', NULL, NULL, 'XF-003856', NULL, '19575819', 'NIGERIA', '', '', '', '', NULL, NULL, '', 156, '', '080', '', NULL, 'N', 'NWIGWE OSITADIMMA ENDURANCE', '0000-00-00', '', 'Private User', 'Enabled', NULL, '', '', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '02', 3856, '', '', '', NULL, 1, 0, '0', NULL, NULL, 'Bank Transfer', 'PASS', '2021-07-30 09:37:33', '2021-07-30 09:37:33'),
(35660, 56210, NULL, 0, '0000-00-00', '', 'ELVIS', '', 'AGBONMHEN', NULL, NULL, '18401571.00', NULL, '', '', '', 'BENIN', '', '156', NULL, NULL, NULL, 156, '8000000000', '8000000000', '', NULL, 'N', 'ELVIS AGBONMHEN', '0000-00-00', '', 'Private User', 'Enabled', NULL, '', '', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '02', NULL, '', '', NULL, NULL, 1, 0, '0', NULL, NULL, 'Bank Transfer', 'PASS', '2021-07-30 09:37:33', '2021-07-30 09:37:33'),
(35661, 56211, NULL, 0, '0000-00-00', '', 'FABIAN', '', 'EBIKADE', NULL, NULL, '18409409.00', NULL, '', '', '', 'IKEJA', '', '156', NULL, NULL, NULL, 156, '80663325', '80663325', '', NULL, 'N', 'FABIAN EBIKADE', '0000-00-00', '', 'Private User', 'Enabled', NULL, '', '', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '02', NULL, '', '', NULL, NULL, 1, 0, '0', NULL, NULL, NULL, 'PASS', '2021-07-30 09:37:33', '2021-07-30 09:37:33'),
(35662, 156135, NULL, 0, '0000-00-00', '', 'UGOCHI', '', 'NWAIGBO', NULL, NULL, '18409701.00', NULL, '', '', '', 'UMUAHIA', '', '156', NULL, NULL, NULL, 156, '8030921094', '8030921094', '', NULL, 'N', 'UGOCHI NWAIGBO', '0000-00-00', '', 'Private User', 'Enabled', NULL, '', '', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '02', NULL, '', '', NULL, NULL, 1, 0, '0', NULL, NULL, 'Bank Transfer', 'PASS', '2021-07-30 09:37:33', '2021-07-30 09:37:33'),
(35663, 276890, NULL, 0, '0000-00-00', '', 'CHINWEIKE', '', 'UBAH', NULL, NULL, '18409686.00', NULL, '', '', '', 'LOKOJA', '', '156', NULL, NULL, NULL, 156, '8053359371', '8053359371', '', NULL, 'N', 'CHINWEIKE UBAH', '0000-00-00', '', 'Private User', 'Enabled', NULL, '', '', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '02', NULL, '', '', NULL, NULL, 1, 0, '0', NULL, NULL, 'Bank Transfer', 'PASS', '2021-07-30 09:37:33', '2021-07-30 09:37:33'),
(35664, 320710, NULL, 0, '0000-00-00', '', 'CLEMENTINA', 'UZOAMAKA', 'ASIKA', NULL, NULL, '18409936.00', NULL, '', '', '', 'BENIN CITY', '', '156', NULL, NULL, NULL, 156, '8097570228', '8097570228', '', NULL, 'N', 'CLEMENTINA UZOAMAKA ASIKA', '0000-00-00', '', 'Private User', 'Enabled', NULL, '', '', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '02', NULL, '', '', NULL, NULL, 1, 0, '0', NULL, NULL, NULL, 'PASS', '2021-07-30 09:37:33', '2021-07-30 09:37:33'),