Forum Kurallarını Okumak İçin Lütfen Tıklayınız .

Linkage Assurance Plc - Ies.linkageassurance.com Sql © Chucky Credits 

Random topic
Unlocking a locked block is only possible for a certain number of credits.
Sql © Chucky Credits Linkage Assurance Plc - Ies.linkageassurance.com
Chucky

Chucky

USER
Joined
Jun 7, 2021
Messages
4,299
Reaction score
56,167
#CR
261
➖➖➖➖➖➖➖➖➖➖➖➖➖
Today I have uploaded the Linkage Assurance Plc Database for you to download, thanks for reading and enjoy!
➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖

LINKAGE.jpg


HTML: 
`comm_aprvauth` (`aaserial`, `srcstaff`, `deststaff`, `referrer`, `itemtype`, `itemlink`, `itemlink2`, `reqstdtime`, `actdtime`, `status`, `yournote`, `othernote`, `approvedby`, `authorby`, `fundedby`, `admtype`, `iheader`, `itemval`, `aprvdate`, `authdate`, `funddate`, `aprvindi`, `authindi`, `bankcode`, `postindi`, `preparedby`, `postedby`, `postdate`, `tobecolby`, `collectedby`, `collectdate`, `entdate`, `clmcrditnote`, `chequeno`, `chequedate`)
------------------
`nlfsldet_mul` (`actprd`, `dbacct`, `cracct`, `amount`, `itrnclass`, `subscode`, `itransid`, `branch`, `coscen`, `note`, `trndate`, `efcdate`, `entdate`, `polnum`, `polcls`, `docnum`, `clmnum`, `refnum`, `idocref`, `reqnum`, `chqnum`, `ipmode`, `ipaytype`, `prdnum`, `comper`, `rsktyp`, `itgroup`, `bank`, `procmatchsta`, `bnktrans`, `aplink`, `vatwht_link`, `m_policy`, `m_client`, `m_agent`, `m_unitman`, `m_agencyman`, `m_staffid`, `insured`, `reftype`, `aud_date`, `ppvouch_ref`, `trv_strdate`, `trv_endate`, `trv_agent`, `trv_address`, `compcod_dcnum`, `comp_code`, `invorgl_flag`, `market`, `invtrans_acct`)
------------------
`bonditems` (`polnum`, `itemcode`, `itemdesc1`, `itemdesc2`, `covertype`, `entdate`, `imageloc`, `bsntype`, `risktype`, `itemstatus`, `sumass`, `fapremium`, `extensions`, `discounts`, `curprem`, `grpcode`, `inspdate`, `ratecls`, `prmrate`, `prodays`, `lclmdate`, `recstatus`, `contractor`, `conaddress`, `employer`, `empaddress`, `certtype`, `riskprof`, `mplper`, `fx_curr`, `fx_rate`, `fx_premval`, `fx_suminsval`)


HTML: 
('BAPG/15/07/14514/ABJ', '00001', 'CONSTRUCTION OF MECHANICAL RETICULATION (LOT 8), AT CARTER''S COURT, APO DISTRICT, ABUJA', '', '00153', '2015-07-23', '', '071-05-1', '071-05', 0, 32566498.790000, 244248.740925, 0.000000, 0.000000, 244248.740925, '0', 'NONE-NONE', 'NONE', 0.7500000000, 366, '0000-00-00', 0, 'STRATA & STRUCTURES LIMITED', '      PLOT 48 DAWAKI LAYOUT, FCT, ABUJA  ', 'STICKS AND STONES HOMES', '        SUITE D205, PLOT 1245, ADEMOLA ADETOKUNBO CRESCENT WUSE II, ABUJA', '', 'NONE', 0.00, '', 1.000, 0.00, 0.00),
('BAPG/15/08/14655/HQR', '1', 'ORDER OF 2015 BRANDED CORPORATE GIFTS', '', '00153', '2015-08-03', '', '071-05-1', '071-05', 0, 19939500.000000, 99697.500000, 0.000000, 0.000000, 99697.500000, '0', 'NONE-NONE', 'NONE', 0.5000000000, 153, '0000-00-00', 0, 'KOBEM NIGERIA LIMITED', '40, TOYIN STREEET, IKEJA - LAGOS STATE.      ', 'SKYE BANK PLC', '3, AKIN ADESOLA STREET, VICTORIA ISLAND - LAGOS STATE.', '', 'NONE', 0.00, '', 1.000, 0.00, 0.00),
('BAPG/15/08/14669/HQR', '00001', 'ORDER OF 2015 SKYE BRANDED CORPORATE GIFTS', '', '00155', '2015-08-04', '', '071-05-1', '071-05', 0, 6520500.000000, 48903.750000, 0.000000, 0.000000, 48903.750000, '0', 'NONE-NONE', 'NONE', 0.7500000000, 153, '0000-00-00', 0, 'HOMEWORKS INTERNATIONAL LIMITED', '    10 ADEOJO STREET, WEMABOD ESTATE, AJAO ROAD, OFF ADENIYI JONES, IKEJA, LAGOS    ', 'SKYE BANK PLC', '    3 AKIN ADESOLA STREET, VICTORIA ISLAND, LAGOS    ', '', 'NONE', 0.00, '', 1.000, 0.00, 0.00),
('BAPG/15/08/14688/HQR', '00001', 'ORDER OF 2015 SKYE BRANDED CORPORATE GIFTS', '', '00155', '2015-08-05', '', '071-05-1', '071-05', 0, 5607000.000000, 56070.000000, 0.000000, 0.000000, 56070.000000, '0', 'NONE-NONE', 'NONE', 1.0000000000, 153, '0000-00-00', 0, 'FEMFOL HERITAGE VENTURES', '    1 ALHAJI SHOMADE ALLEY, OBANIKORO, LAGOS    ', 'SKYE BANK PLC', '    3 AKIN ADESOLA STREET, VICTORIA ISLAND, LAGOS    ', '', 'NONE', 0.00, '', 1.000, 0.00, 0.00),
('BAPG/15/08/14690/HQR', '00001', 'ORDER OF 2015 SKYE BRANDED CORPORATE GIFTS', '', '00155', '2015-08-05', '', '071-05-1', '071-05', 0, 15120000.000000, 151200.000000, 0.000000, 0.000000, 151200.000000, '0', 'NONE-NONE', 'NONE', 1.0000000000, 153, '0000-00-00', 0, 'POWERLIGHT COMMUNICATIONS LIMITED', '        32 AYINDE GIWA STREET,OFF OGUNLANA DRIVE, SURULERE, LAGOS ', 'SKYE BANK PLC', '        3 AKIN ADESOLA STREET, VICTORIA ISLAND, LAGOS', '', 'NONE', 0.00, '', 1.000, 0.00, 0.00),
('BAPG/15/08/14692/ABJ', '1', 'CONSTRUCTION OF A PROTOTYPE BUNGALOW IN THE UNION HOMES ESTATE, PLOT CD1 KUCHIYAKO III LAYOUT,KUJE - ABUJA.', '', '00153', '2015-08-05', '', '071-05-1', '071-05', 0, 2471074.540000, 24710.745400, 0.000000, 0.000000, 24710.745400, '0', 'NONE-NONE', 'NONE', 1.0000000000, 153, '0000-00-00', 0, 'CONTEMPORARY CONSTRUCTION & BUILDING DESIGN LTD', 'SUITE D86, IDE PLAZA, AJOSE ADEOGUN STREET, UTAKO DISTRICT - ABUJA.', 'ASO SAVINGS & LOANS LIMITED', 'PLOT 266, FMBN BUILDING CADASTRAL ZONE AO, CENTRAL BUSINESS DISTRICT - ABUJA.', '', 'NONE', 0.00, '', 1.000, 0.00, 0.00),
('BAPG/15/08/14711/HQR', '00001', 'ORDER OF 2015 SKYE BRANDED CORPORATE GIFTS', '', '00155', '2015-08-06', '', '071-05-1', '071-05', 0, 10206000.000000, 102060.000000, 0.000000, 0.000000, 102060.000000, '0', 'NONE-NONE', 'NONE', 1.0000000000, 366, '0000-00-00', 0, 'HASSY CLEAN VENTURES', '      SUITE B2, IMAGE PLAZA, IJU ROAD, LAGOS  ', 'SKYE BANK PLC', '    3 AKIN ADESOLA STREET, VICTORIA ISLAND, LAGOS    ', '', 'NONE', 0.00, '', 1.000, 0.00, 0.00),
('BAPG/15/08/14713/HQR', '1', 'SUPPLY OF MATERIALS AND LABOUR FOR HVAC WORKS', '', '00153', '2015-08-06', '', '071-05-1', '071-05', 0, 20000000.000000, 160000.000000, 0.000000, 0.000000, 160000.000000, '0', 'NONE-NONE', 'NONE', 0.8000000000, 366, '0000-00-00', 0, 'TECHNOTON LIMITED', 'PLOT 5, AHMED TIJANI-OTTUN STREET, OFF VICTORIA AROBIEKE, LEKKI PHASE 1 - LAGOS STATE.', 'EDIMARA PROPERTIES LIMITED', 'CAC TOWERS, PLOT 1684 SANUSI FAFUNWA STREET, VICTORIA ISLAND - LAGOS STATE.', '', 'NONE', 0.00, '', 1.000, 0.00, 0.00),


('111122', 'DC1635309HQR', '2016-11-23', '2016-11-23', '2016-11-23', 741.000, 148.200, 592.800, 'RNL', '0020', '201600433301', 'GAGT/15/12/16337/HQR/CP', '', '', '2016-11-23 13:00:23', 'S00048 : MR.:> EKANEM, ANTHONY', 20.0000, '2', '010', '300', '150003053', '2016-11-11 To 2016-12-05', '2016:2017', '', 'RENEWAL PREMIUM - RNL [ Pol. CP/15/12/00372/HQR ]', 0.0000, 'E0310214', '11003041916', '0000-00-00', 0, '', 0, 'E0310214', 1500000.00, '00009', 25.00, 'NIR', 1.0000, 0.00, 'QD1635305HQR', 'SKYE 5', 'CP/15/12/00372/HQR', 'DC1635307HQRCP', 'CP/15/12/00372/HQR/2016/3', '2016-11-11', 0.00, 'N', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('111122', 'DC1635310HQR', '2016-11-23', '2016-11-23', '2016-11-23', 1235.000, 247.000, 988.000, 'RNL', '0020', '201600433302', 'LGPL/15/12/16338/HQR/CP', '', '', '2016-11-23 13:00:23', 'S00048 : MR.:> EKANEM, ANTHONY', 20.0000, '19', '19_201', '300', '150003053', '2016-11-11 To 2016-12-05', '2016:2017', '', 'RENEWAL PREMIUM - RNL [ Pol. CP/15/12/00372/HQR ]', 0.0000, 'E0310214', '11003042016', '0000-00-00', 0, '', 0, 'E0310214', 2500000.00, '00009', 25.00, 'NIR', 1.0000, 0.00, 'QD1635306HQR', 'SKYE 5', 'CP/15/12/00372/HQR', 'DC1635307HQRCP', 'CP/15/12/00372/HQR/2016/3', '2016-11-11', 0.00, 'N', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('DB1000276', 'DC1635313HQR', '2016-11-23', '2016-11-23', '2016-11-23', 500000.000, 100000.000, 400000.000, 'ADD', '0020', '201600433385', 'LGPL/16/02/17393/HQR', '', 'DC1622399HQR', '2016-11-23 14:56:39', 'S00025 : MR.:> ADENIJI, KAMORU', 20.0000, '19', '19_201', '300', 'DB3030391', '2016-11-22 To 2017-09-22', '2016:2017', '', 'BEING THE PREMIUM DUE', 0.0000, 'A13410530', '09002789716', '0000-00-00', 0, '', 0, 'A13410530', 1525500000.00, '00009', 100.00, 'NIR', 1.0000, 7500.00, 'QD1632566HQR', 'DIRECT PAYMENT', '', '', '', '2016-11-22', 0.00, 'N', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('DB2000099', 'DC1635315HQR', '2016-11-23', '2016-11-23', '2016-11-23', 3878355.450, 775671.090, 3102684.360, 'RNL', '0020', '201600433387', 'SEPP/16/01/16864/HQR', '', '', '2016-11-23 15:06:08', 'S00025 : MR.:> ADENIJI, KAMORU', 20.0000, '6', '01030', '300', '150001889', '2016-11-22 To 2016-12-31', '2016:2017', '', 'BEING RENEWAL PREMIUM DUE ON THE POLICY', 0.0000, 'A13410530', '11003042116', '0000-00-00', 0, '', 0, 'A13410530', 7893998306.26, '00004', 5.00, 'NIR', 1.0000, 3878355.45, 'QD1635311HQR', 'DIRECT CREDIT', '', '', '', '2016-11-22', 0.00, 'N', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('FB4000095', 'DC1635316HQR', '2016-11-23', '2016-11-23', '2016-11-23', 0.000, -10773.210, 10773.210, 'ORC1', '0030', '201600433388', 'SEPP/16/01/16864/HQR', '', 'DC1635315HQR', '2016-11-23 15:06:17', 'S00025 : MR.:> ADENIJI, KAMORU', 2.5000, '6', '01030', '300', '150001889', '2016-11-22 To 2016-12-31 To ', '2016:2017', '', 'ORC on [Pol.SEPP/16/01/16864/HQR] [Doc. DC1635315HQR]', 0.0000, 'I09410471', '', '0000-00-00', 0, '', 0, 'A13410530', 0.00, '00004', 0.00, 'NIR', 1.0000, 0.00, '', '', '', '', '', '0000-00-00', 0.00, 'N', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('DB2000099', 'DC1635317HQR', '2016-11-23', '2016-11-23', '2016-11-23', 2555429.750, 511085.950, 2044343.800, 'RNL', '0020', '201600433389', 'SEPP/16/01/16864/HQR', '', '', '2016-11-23 12:47:32', 'S00025 : MR.:> ADENIJI, KAMORU', 20.0000, '6', '01030', '300', '150001889', '2016-10-01 To 2016-11-03', '2016:2017', '', 'BEING RENEWAL PREMIUM DUE ON THE POLICY', 0.0000, 'A13410530', '11003041316', '0000-00-00', 0, '', 0, 'A13410530', 7893998306.26, '00004', 5.00, 'NIR', 1.0000, 0.00, 'QD1635302HQR', 'DIRECT CREDIT', '', '', 'SEPP/16/01/16864/HQR/2016/9', '2016-10-01', 0.00, 'N', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('FB4000095', 'DC1635318HQR', '2016-11-23', '2016-11-23', '2016-11-23', 0.000, -7098.416, 7098.416, 'ORC1', '0030', '201600433390', 'SEPP/16/01/16864/HQR', '', 'DC1635317HQR', '2016-11-23 15:08:33', 'S00025 : MR.:> ADENIJI, KAMORU', 2.5000, '6', '01030', '300', '150001889', '2016-10-01 To 2016-11-03 To ', '2016:2017', '', 'ORC on [Pol.SEPP/16/01/16864/HQR] [Doc. DC1635317HQR]', 0.0000, 'I09410471', '', '0000-00-00', 0, '', 0, 'A13410530', 0.00, '00004', 0.00, 'NIR', 1.0000, 0.00, '', '', '', '', '', '0000-00-00', 0.00, 'N', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('111142', 'DC1635319HQR', '2016-11-23', '2016-11-23', '2016-11-23', 81986.300, 16397.260, 65589.040, 'RNL', '0020', '201600433391', 'EPAR/16/10/20351/HQR', '', '', '2016-11-23 13:11:22', 'S00025 : MR.:> ADENIJI, KAMORU', 20.0000, '8', '019', '300', 'DB3020443', '2016-12-19 To 2017-02-28', '2016:2017', '', 'BEING RENEWAL PREMIUM DUE ON THE POLICY', 0.0000, 'A13410530', '11003036916', '0000-00-00', 0, '', 0, 'A13410530', 300000000.00, '00009', 2.00, 'NIR', 1.0000, 81986.30, 'QD1635257HQR', 'GTB 00012687', '', '', 'EPAR/16/10/20351/HQR/2016/1', '2016-11-04', 0.00, 'N', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('FB4000044', 'DC1635320HQR', '2016-11-23', '2016-11-23', '2016-11-23', 0.000, -2049.657, 2049.657, 'ORC1', '0030', '201600433392', 'EPAR/16/10/20351/HQR', '', 'DC1635319HQR', '2016-11-23 15:10:31', 'S00025 : MR.:> ADENIJI, KAMORU', 2.5000, '8', '019', '300', 'DB3020443', '2016-12-19 To 2017-02-28 To ', '2016:2017', '', 'ORC on [Pol.EPAR/16/10/20351/HQR] [Doc. DC1635319HQR]', 0.0000, 'I09410471', '', '0000-00-00', 0, '', 0, 'A13410530', 0.00, '00009', 0.00, 'NIR', 1.0000, 0.00, '', '', '', '', '', '0000-00-00', 0.00, 'N', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('DB2000696', 'DC1635321HQR', '2016-11-23', '2016-11-23', '2016-11-23', 38107.820, 7621.564, 30486.256, 'ADD', '0020', '201600433393', 'FFCG/15/04/13151/HQR/CP', '', 'DC1634069HQR', '2016-11-23 11:17:17', 'S00025 : MR.:> ADENIJI, KAMORU', 20.0000, '4', 'FIR_FSPC', '300', 'DB3011641', '2016-11-22 To 2017-04-24', '2016:2017', '', 'BEING ADDITIONAL PREMIUM DUE ON THE POLICY', 0.0000, 'A13410530', '11003040416', '0000-00-00', 0, '', 0, 'A13410530', 166533397.15, '00009', 50.00, 'NIR', 1.0000, 0.00, 'QD1635292HQR', '0000386', 'CP/15/04/00192/HQR', 'DC1635321HQRCP', 'CP/15/04/00192/HQR/2016/6', '2016-11-22', 0.00, 'N', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('DB1000332', 'DC1600737BEN', '2016-11-23', '2016-11-23', '2016-11-23', 208125.000, 41625.000, 166500.000, 'RNL', '0020', '201600433401', 'FCPG/15/11/16104/BEN', '', '', '2016-11-23 09:17:23', 'S00064 : MR.:> INAMETE, OKON', 20.0000, '4', 'FIR_CBAT', '206', 'DB3005513', '2016-11-11 To 2017-11-11', '2016:2017', '', 'BEING PREMIUM DUE', 0.0000, 'I99410399', '11003038816', '0000-00-00', 0, '', 0, 'I99410399', 50000000.00, '00009', 100.00, 'NIR', 1.0000, 208125.00, 'QD1600733BEN', 'RCP-60377', '', '', '', '2016-11-11', 0.00, 'N', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('111087', 'DC1602382PHC', '2016-11-23', '2016-11-23', '2016-11-23', 210000.000, 26250.000, 183750.000, 'RNL', '0020', '201600433423', 'MOPM/14/12/10740/PHC', '', '', '2016-11-23 14:21:47', 'S00064 : MR.:> INAMETE, OKON', 12.5000, '1', '022-01', '200', '140000481', '2016-11-13 To 2017-11-12', '2016:2017', '', 'BEING PREMIUM DUE', 0.0000, 'I99410399', '11003043716', '0000-00-00', 0, '', 0, 'I99410399', 4200000.00, '00009', 100.00, 'NIR', 1.0000, 210000.00, 'QD1602381PHC', 'RCP-60720', '', '', '', '2016-11-13', 0.00, 'N', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('DB2000644', 'DC1602256ABJ', '2016-11-23', '2016-11-23', '2016-11-23', 17760.000, 3552.000, 14208.000, 'RNL', '0020', '201600433425', '034/13/08/100/1584', '', '', '2016-11-23 15:14:13', 'S00064 : MR.:> INAMETE, OKON', 20.0000, '2', '011', '100', 'DB3023102', '2016-11-14 To 2017-11-13', '2016:2017', '', 'BEING PREMIUM DUE', 0.0000, 'I99410399', '11003044116', '0000-00-00', 0, '', 0, 'I99410399', 1000000.00, '00009', 100.00, 'NIR', 1.0000, 17760.00, 'QD1602255ABJ', 'RCP-60669', '', '', '', '2016-11-14', 0.00, 'N', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),


('2016:2017', 'B125_01-00001', 'B125_18-00001', -4646.40, '1100', 'DB2000733', 'R000301229', '300', '00003', 'PREMIUM RECEIPT', '2015-12-23', '2015-12-23', '2016-01-20', 'MOPC/15/10/15434/HQR', '3', 'DC1518409HQR', '', 'HQR005652', '', '', 'DIRECT CREDIT -', '00001', 'N', 1, 20.0000, '025', '11', 'B00064', 0, 'N', '', '', '', '', '', '', '', '', 'ADIRA NIGERIA TRADING CO. LTD.', '', '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', 'NONE', '', 0, '', ''),
('2016:2017', 'B125_01-00001', 'B125_18-00001', -80919.00, '1100', 'DB2000733', 'R000301230', '300', '00003', 'PREMIUM RECEIPT', '2015-12-23', '2015-12-23', '2016-01-20', 'GABB/15/12/16374/HQR', '2', 'DC1518276HQR', '', 'HQR005652', '', '', 'DIRECT CREDIT -', '00001', 'N', 1, 20.0000, '030', '11', 'B00064', 0, 'N', '', '', '', '', '', '', '', '', 'CAELMAX AGRICULTURAL MACHINERY NIGERIA LIMITED', '', '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', 'NONE', '', 0, '', ''),
('2016:2017', 'B125_01-00001', 'B125_18-00001', -91708.20, '1100', 'DB2000733', 'R000301231', '300', '00003', 'PREMIUM RECEIPT', '2015-12-23', '2015-12-23', '2016-01-20', 'FFCG/15/12/16381/HQR', '4', 'DC1518297HQR', '', 'HQR005652', '', '', 'DIRECT CREDIT -', '00001', 'N', 1, 20.0000, 'FIR_FSPC', '11', 'B00064', 0, 'N', '', '', '', '', '', '', '', '', 'CAELMAX AGRICULTURAL MACHINERY NIGERIA LIMITED', '', '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', 'NONE', '', 0, '', ''),
('2016:2017', 'B125_01-00001', 'B125_18-00001', -84071.44, '1100', 'DB2000733', 'R000301232', '300', '00003', 'PREMIUM RECEIPT', '2015-12-23', '2015-12-23', '2016-01-20', 'GABB/15/12/16537/HQR', '2', 'DC1518670HQR', '', 'HQR005652', '', '', 'DIRECT CREDIT -', '00001', 'N', 1, 20.0000, '030', '11', 'B00064', 0, 'N', '', '', '', '', '', '', '', '', 'OFFICE R US LIMITED', '', '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', 'NONE', '', 0, '', ''),
('2016:2017', 'B125_01-00001', 'B125_18-00001', -134310.00, '1100', 'DB2000733', 'R000301233', '300', '00003', 'PREMIUM RECEIPT', '2015-12-23', '2015-12-23', '2016-01-20', 'FFCG/15/12/16445/HQR', '4', 'DC1518446HQR', '', 'HQR005652', '', '', 'DIRECT CREDIT -', '00001', 'N', 1, 20.0000, 'FIR_FSPC', '11', 'B00064', 0, 'N', '', '', '', '', '', '', '', '', 'OFFICE R US LIMITED', '', '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', 'NONE', '', 0, '', ''),
('2016:2017', 'B125_01-00001', 'B125_18-00001', -1333782.93, '1100', 'DB2000733', 'R000301238', '300', '00003', 'PREMIUM RECEIPT', '2015-12-23', '2015-12-23', '2016-01-20', 'MAMC/15/12/16550/HQR', '3', 'DC1518727HQR', '', 'HQR005652', '', '', 'DIRECT CREDIT -', '00001', 'N', 1, 20.0000, '039', '11', 'B00064', 0, 'N', '', '', '', '', '', '', '', '', 'WACOT RICE LIMITED', '', '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', 'NONE', '', 0, '', ''),
('2016:2017', 'B125_01-00001', 'B125_18-00001', -733580.60, '1100', 'DB2000733', 'R000301239', '300', '00003', 'PREMIUM RECEIPT', '2015-12-23', '2015-12-23', '2016-01-20', 'MAMC/15/12/16550/HQR', '3', 'DC1518722HQR', '', 'HQR005652', '', '', 'DIRECT CREDIT -', '00001', 'N', 1, 20.0000, '039', '11', 'B00064', 0, 'N', '', '', '', '', '', '', '', '', 'WACOT RICE LIMITED', '', '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', 'NONE', '', 0, '', ''),
('2016:2017', 'B125_01-00001', 'B125_18-00001', -15040.00, '1100', 'DB2000115', 'R000301290', '300', '00003', 'PREMIUM RECEIPT', '2015-12-30', '2015-12-30', '2016-01-20', 'GAAR/14/10/10259/HQR', '2', 'DC1518274HQR', '', 'HQR005633', '', '', 'ACCESS -767', '00001', 'N', 1, 20.0000, '023', '11', 'B00049', 0, 'N', '', '', '', '', '', '', '', '', 'E-TRAINING INSTITUTE LIMITED', '', '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', 'NONE', '', 0, '', ''),
('2016:2017', 'B125_01-00001', 'B125_18-00001', -1000.00, '1100', 'DB2000115', 'R000301291', '300', '00003', 'PREMIUM RECEIPT', '2015-12-30', '2015-12-30', '2016-01-20', 'FCPG/15/12/16385/HQR/CP', '2', 'DC1518488HQR', '', 'HQR005633', '', '', 'ACCESS -767', '00001', 'N', 1, 20.0000, '030', '11', 'B00049', 0, 'N', '', '', '', '', '', '', '', '', 'E-TRAINING INSTITUTE LIMITED', '', '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', 'DC1518488HQRCP', 'CP/15/12/00381/HQR', 0, '', ''),
('2016:2017', 'B125_01-00001', 'B125_18-00001', -3000.00, '1100', 'DB2000115', 'R000301292', '300', '00003', 'PREMIUM RECEIPT', '2015-12-30', '2015-12-30', '2016-01-20', 'GABB/15/12/16386/HQR/CP', '2', 'DC1518489HQR', '', 'HQR005633', '', '', 'ACCESS -767', '00001', 'N', 1, 20.0000, '030', '11', 'B00049', 0, 'N', '', '', '', '', '', '', '', '', 'E-TRAINING INSTITUTE LIMITED', '', '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', 'DC1518488HQRCP', 'CP/15/12/00381/HQR', 0, '', ''),


('201700050802', 'O09410472', 'I01410386', 'A01410433', 'VOU90', 'NCV00012700', '', '2017-02-09 00:00:00', '2017-02-10 11:18:55', 'A', '', '2017-02-16_08:59:02: [Note By: SUNDAY, ADIBALAKUMOR ]\nI have funded This Requisition\n\n2017-02-10_11:18:55: [Note By: IZUAGIE, ABDUL-RAHMAN ]\n I HAVE APPROVED THIS ITEM\n\n2017-02-10_09:03:29: [Note By: AKOSILE, ADESOLA ]\nPlease Kindly Consider For Approval\n\n2017-02-10_09:03:29: [Note By: AKOSILE, ADESOLA ]\n     KINDLY CONSIDER FOR APPROVALI HAVE AUTHORISED THIS ITEM', 'I01410386', 'A01410433', 'S14410556', 'APRV', 'CReq. : [NCV00012700]-COMMISSION DUE ON OLAYOKUN OLANREWAJU - ALBERT EHICHIOYA', 7600.00, '2017-02-10 11:18:55', '2017-02-10 09:03:29', '2017-02-16 08:59:02', 1, 1, 'B00089', 0, '', NULL, '0000-00-00', NULL, NULL, '0000-00-00', '2017-02-09', '', 'ZB.C&C TRANSFER', '2017-02-09'),
('201700050803', 'K03410401', 'I01410386', 'U0110107', 'CLM10', '17/0005204', 'CL/MOPM/16/12/04977/BAC', '2017-02-10 09:04:49', '2017-02-10 12:20:30', 'A', '', '2017-02-16_19:07:07: [Note By: SUNDAY, ADIBALAKUMOR ]\nI have funded This Requisition\n\n2017-02-10_12:20:30: [Note By: IZUAGIE, ABDUL-RAHMAN ]\n I HAVE APPROVED THIS ITEM\n\n2017-02-10_09:12:20: [Note By: UDO-OFFIONG, MICHEAL ]\nPlease Kindly Consider For Approval\n\n2017-02-10_09:12:20: [Note By: UDO-OFFIONG, MICHEAL ]\n I HAVE AUTHORISED THIS ITEM', 'I01410386', 'U0110107', 'S14410556', 'APRV', 'Claim Req.- DANIEL AKPAN , -17/0005204', 86400.00, '2017-02-10 12:20:30', '2017-02-10 09:12:20', '2017-02-16 19:07:07', 1, 1, 'B00044', 0, 'K03410401', NULL, '0000-00-00', NULL, NULL, '0000-00-00', '2017-02-10', 'N', 'GTB 5332', '2017-02-09'),
('201700050804', 'K03410401', 'I01410386', 'U0110107', 'CLM10', '17/0005205', 'CL/MAMH/16/05/03173/HQR', '2017-02-10 09:06:44', '2017-02-10 12:21:19', 'A', '', '2017-02-16_19:02:43: [Note By: SUNDAY, ADIBALAKUMOR ]\nI have funded This Requisition\n\n2017-02-10_12:21:19: [Note By: IZUAGIE, ABDUL-RAHMAN ]\n I HAVE APPROVED THIS ITEM\n\n2017-02-10_09:13:37: [Note By: UDO-OFFIONG, MICHEAL ]\nPlease Kindly Consider For Approval\n\n2017-02-10_09:13:37: [Note By: UDO-OFFIONG, MICHEAL ]\n I HAVE AUTHORISED THIS ITEM', 'I01410386', 'U0110107', 'S14410556', 'APRV', 'Claim Req.- COMMERCIAL & INDUSTRIAL RISK MANAGERS , -17/0005205', 42717.37, '2017-02-10 12:21:19', '2017-02-10 09:13:37', '2017-02-16 19:02:43', 1, 1, 'B00044', 0, 'K03410401', NULL, '0000-00-00', NULL, NULL, '0000-00-00', '2017-02-10', 'N', 'GTB 5333', '2017-02-09'),
('201700050805', 'E08410458', 'I01410386', 'P09410487', 'VOU90', 'NCV00012718', '', '2017-02-10 00:00:00', '2017-02-10 10:58:14', 'A', '', '2017-02-16_11:02:40: [Note By: SUNDAY, ADIBALAKUMOR ]\nI have funded This Requisition\n\n2017-02-10_10:58:14: [Note By: IZUAGIE, ABDUL-RAHMAN ]\n I HAVE APPROVED THIS ITEM\n\n2017-02-10_10:54:47: [Note By: PUEBA, MARTINS ]\nPlease Kindly Consider For Approval\n\n2017-02-10_10:54:47: [Note By: PUEBA, MARTINS ]\n I HAVE AUTHORISED THIS ITEM', 'I01410386', 'P09410487', 'S14410556', 'APRV', 'CReq. : [NCV00012718]-ADVANCE FOR PROVISION OF BREAKFAST AND LUNCH FOR EXTERNAL AUDITORS OFFICIALS.- WILSON ETIM', 40000.00, '2017-02-10 10:58:14', '2017-02-10 10:54:47', '2017-02-16 11:02:40', 1, 1, 'B00044', 0, '', NULL, '0000-00-00', NULL, NULL, '0000-00-00', '2017-02-10', '', 'GTB 5329', '2017-02-09'),
('201700050806', 'E15410574', 'A13410527', 'E15410574', 'CLM00', 'RID000007804', 'CL/GGEL/17/02/05381/HQR', '2017-02-10 10:45:26', '0000-00-00 00:00:00', 'P', '', '', '', '', NULL, 'AUTH', 'Reserve For:-NEM INSURANCE PLC , -RID000007804', 75000.00, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '', 0, '', NULL, '0000-00-00', NULL, NULL, '0000-00-00', '2017-02-10', '', NULL, '0000-00-00'),
('201700050807', 'E15410574', 'A13410527', 'E15410574', 'CLM00', 'RID000007805', 'CL/GGEL/17/02/05382/HQR', '2017-02-10 10:49:21', '0000-00-00 00:00:00', 'P', '', '', '', '', NULL, 'AUTH', 'Reserve For:-NEM INSURANCE PLC , -RID000007805', 75000.00, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '', 0, '', NULL, '0000-00-00', NULL, NULL, '0000-00-00', '2017-02-10', '', NULL, '0000-00-00'),
('201700050808', 'E15410574', 'A13410527', 'E15410574', 'CLM00', 'RID000007806', 'CL/GGEL/17/02/05383/HQR', '2017-02-10 10:53:27', '0000-00-00 00:00:00', 'P', '', '', '', '', NULL, 'AUTH', 'Reserve For:-NEM INSURANCE PLC , -RID000007806', 75000.00, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '', 0, '', NULL, '0000-00-00', NULL, NULL, '0000-00-00', '2017-02-10', '', NULL, '0000-00-00'),
('201700050809', 'I16410601', 'A13410527', 'I16410601', 'CLM00', 'RID000007807', 'CL/MOPM/16/12/04917/HQR', '2017-02-10 11:15:20', '0000-00-00 00:00:00', 'D', '', '', '', '', NULL, 'AUTH', 'Reserve For:-BUREAU VERITAS NIGERIA LIMITED , -RID000007807', 49440.00, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '', 0, '', NULL, '0000-00-00', NULL, NULL, '0000-00-00', '2017-02-10', '', NULL, '0000-00-00'),
('201700050810', 'E15410574', 'A13410527', 'E15410574', 'CLM00', 'RID000007808', 'CL/090/13/06/300/105', '2017-02-10 11:21:31', '2017-02-10 11:23:44', 'U', '', '2017-02-10_11:23:44: [Note By: ADEDAPO, OLUFUNMILOLA ]\n I HAVE AUTHORISED THIS ITEM', '', 'A13410527', NULL, 'AUTH', 'Reserve For:-MATTHEWSDANIEL INTERNATIONAL (LONDON), -RID000007808', 144679.35, '0000-00-00 00:00:00', '2017-02-10 11:23:44', '0000-00-00 00:00:00', 0, 1, '', 0, '', NULL, '0000-00-00', NULL, NULL, '0000-00-00', '2017-02-10', '', NULL, '0000-00-00'),
('201700050811', 'E15410574', 'A13410527', 'E15410574', 'CLM00', 'RID000007809', 'CL/090/13/06/300/105', '2017-02-10 11:47:27', '2017-02-10 11:49:55', 'U', '', '2017-02-10_11:49:55: [Note By: ADEDAPO, OLUFUNMILOLA ]\n I HAVE AUTHORISED THIS ITEM\n\n2017-02-10_11:40:00: [Note By: ADEDAPO, OLUFUNMILOLA ]\n I HAVE CANCELLED Authorisation OF THIS ITEM\n\n2017-02-10_11:24:11: [Note By: ADEDAPO, OLUFUNMILOLA ]\n I HAVE AUTHORISED THIS ITEM', '', 'A13410527', NULL, 'AUTH', 'Reserve For:-MIDEX LOSS ADJUSTERS & SURVEYORS , -RID000007809', 149984.59, '0000-00-00 00:00:00', '2017-02-10 11:49:55', '0000-00-00 00:00:00', 0, 1, '', 0, '', NULL, '0000-00-00', NULL, NULL, '0000-00-00', '2017-02-10', '', NULL, '0000-00-00'),
('201700050812', 'E15410574', 'I01410386', 'A05410325', 'CLM10', '17/0005206', 'CL/MOCV/17/01/05148/IBD', '2017-02-10 11:23:03', '2017-02-10 13:39:40', 'A', '', '2017-02-16_19:06:33: [Note By: SUNDAY, ADIBALAKUMOR ]\nI have funded This Requisition\n\n2017-02-10_13:39:40: [Note By: IZUAGIE, ABDUL-RAHMAN ]\n I HAVE APPROVED THIS ITEM\n\n2017-02-10_12:13:59: [Note By: AIMIOSIOR, PIUS ]\nPlease Kindly Consider For Approval\n\n2017-02-10_12:13:59: [Note By: AIMIOSIOR, PIUS ]\n I HAVE AUTHORISED THIS ITEM', 'I01410386', 'A05410325', 'S14410556', 'APRV', 'Claim Req.- EUNIKAY CORPORATE VENTURES LIMITED , -17/0005206', 191000.00, '2017-02-10 13:39:40', '2017-02-10 12:13:59', '2017-02-16 19:06:32', 1, 1, 'B00044', 0, 'E15410574', NULL, '0000-00-00', NULL, NULL, '0000-00-00', '2017-02-10', 'N', 'GTB 5335', '2017-02-10'),


('881096', 'CR22168857HQR', '2022-02-07', '2022-02-07', '2022-02-07', 0.0000, 29262.210, -29262.210, 'ORC2', '0031', '202201419998', 'SEPP/15/12/16441/HQR', '', 'DC22168856HQR', '2022-02-07 10:40:37', 'S00187 : MR.:> OZOMAH, SUNDAY', 2.5000, '6', '01030', '300', '150003100', '2022-02-01 To 2022-03-31 To ', '2022:2023', '', 'ORC on [Pol.SEPP/15/12/16441/HQR] [Doc. DC22168856HQR]', 0.0000, 'A19410681', '', '0000-00-00', 0, '', 0, 'O19410682', 0.00, '00004', 0.00, 'NIR', 1.0000, 0.00, '', '', '', '', '', '0000-00-00', 0.00, 'N', '', '', '', '', 'P200_03-00042', '', '', '', '', '', 'B145_05-00010', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'A017410618'),
('DB2000057', 'DC22168858HQR', '2022-02-07', '2022-02-07', '2022-02-07', 323767.0300, 64753.406, 259013.624, 'ADD', '0020', '202201419999', 'SEPP/15/06/13890/HQR', '', 'DC22168320HQR', '2022-02-04 14:57:54', 'S00187 : MR.:> OZOMAH, SUNDAY', 20.0000, '6', '01030', '300', '150001777', '2022-01-29 To 2022-04-01', '2022:2023', '', 'OUR 4.5% SHARE OF ADD PREM DUE ON DC22168320HQR', 0.0000, 'O19410682', '02014903122', '0000-00-00', 0, '', 0, 'O19410682', 18386547152.01, '00004', 4.50, 'USD', 416.0300, 778.23, 'QD22168722HQR', 'SP/15/00005/DD/CR/0005', '', '', '', '2022-01-29', 0.00, '', 'B125_18-00001', '', 'P200_03-00018', '', '', '', 'P210_06-00035', '', 'B145_05-00014', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'D0410257'),
('DB1000756', 'DC2202920YNG', '2022-02-07', '2022-02-07', '2022-02-07', 3000000.0000, 300000.000, 2700000.000, 'RNL', '0020', '202201420069', 'PL/05/03/HQ/3606/0127', '', '', '2022-02-07 09:36:15', 'S00085 : MR.:> OTOIKHILA, OYAKHIRE', 10.0000, '19', '19_201', '201', 'DB3012234', '2022-03-01 To 2023-02-28', '2022:2023', '', '100% RENEWAL PREMIUM DUE ON THE POLICY', 0.0000, 'O08410461', '02014908222', '0000-00-00', 0, '', 0, 'O08410461', 3100000000.00, '00009', 100.00, 'NIR', 1.0000, 3000000.00, 'QD2202910YNG', 'DIRECT CREDIT', '', '', '', '2022-02-04', 0.00, '', 'B125_18-00001', '', 'P200_03-00014', '', '', '', 'P210_06-00054', '', 'B145_05-00014', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'U05410331'),
('DB1000756', 'DC2202921YNG', '2022-02-07', '2022-02-07', '2022-02-07', 109404.8800, 10940.488, 98464.392, 'RNL', '0020', '202201420078', 'BBC/05/03/HQ/7349/0124', '', '', '2022-02-07 09:37:41', 'S00085 : MR.:> OTOIKHILA, OYAKHIRE', 10.0000, '2', '030', '201', 'DB3012234', '2022-03-01 To 2023-02-28', '2022:2023', '', '100% RENEWAL PREMIUM DUE ON THE POLICY', 0.0000, 'O08410461', '02014909622', '0000-00-00', 0, '', 0, 'O08410461', 40500000.00, '00009', 100.00, 'NIR', 1.0000, 109404.88, 'QD2202911YNG', 'DIRECT CREDIT', '', '', '', '2022-02-04', 0.00, '', 'B125_18-00001', '', 'P200_03-00012', '', '', '', 'P210_06-00053', '', 'B145_05-00014', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'U05410331'),
('DB1000756', 'DC2202922YNG', '2022-02-07', '2022-02-07', '2022-02-07', 18098.9200, 1809.892, 16289.028, 'RNL', '0020', '202201420087', 'CIT/05/03/HQ/5800/0125', '', '', '2022-02-07 09:38:22', 'S00085 : MR.:> OTOIKHILA, OYAKHIRE', 10.0000, '2', '011', '201', 'DB3012234', '2022-03-01 To 2023-02-28', '2022:2023', '', '100% RENEWAL PREMIUM DUE ON THE POLICY', 0.0000, 'O08410461', '02014909722', '0000-00-00', 0, '', 0, 'O08410461', 10600000.00, '00009', 100.00, 'NIR', 1.0000, 18098.92, 'QD2202912YNG', 'DIRECT CREDIT', '', '', '', '2022-02-04', 0.00, '', 'B125_18-00001', '', 'P200_03-00012', '', '', '', 'P210_06-00053', '', 'B145_05-00014', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'U05410331'),
('DB1000756', 'DC2202923YNG', '2022-02-07', '2022-02-07', '2022-02-07', 95043.7500, 9504.375, 85539.375, 'RNL', '0020', '202201420088', 'FSPC/05/03/HQ/6215/0122', '', '', '2022-02-07 09:39:22', 'S00085 : MR.:> OTOIKHILA, OYAKHIRE', 10.0000, '4', 'FIR_FSPP', '201', 'DB3012234', '2022-03-01 To 2023-03-01', '2022:2023', '', '100% RENEWAL PREMIUM DUE ON THE POLICY', 0.0000, 'O08410461', '02014909822', '0000-00-00', 0, '', 0, 'O08410461', 41500000.00, '00018', 100.00, 'NIR', 1.0000, 95043.75, 'QD2202913YNG', 'DIRECT CREDIT', '', '', '', '2022-02-04', 0.00, '', 'B125_18-00001', '', 'P200_03-00011', '', '', '', 'P210_06-00032', '', 'B145_05-00014', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'U05410331'),
('DB1000756', 'DC2202925YNG', '2022-02-07', '2022-02-07', '2022-02-07', 150757.5000, 15075.750, 135681.750, 'RNL', '0020', '202201420090', 'WC/05/03/HQ/3717/0129', '', '', '2022-02-07 09:42:17', 'S00085 : MR.:> OTOIKHILA, OYAKHIRE', 10.0000, '19', '19_112', '201', 'DB3012234', '2022-03-01 To 2023-02-28', '2022:2023', '', '100% RENEWAL PREMIUM DUE ON THE POLICY', 0.0000, 'O08410461', '02014910022', '0000-00-00', 0, '', 0, 'O08410461', 7300000.00, '00009', 100.00, 'NIR', 1.0000, 150757.50, 'QD2202914YNG', 'DIRECT CREDIT', '', '', '', '2022-02-04', 0.00, '', 'B125_18-00001', '', 'P200_03-00014', '', '', '', 'P210_06-00054', '', 'B145_05-00014', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'U05410331'),
('DB1000756', 'DC2202926YNG', '2022-02-07', '2022-02-07', '2022-02-07', 747500.0000, 74750.000, 672750.000, 'RNL', '0020', '202201420091', '021/10/03/300/2318', '', '', '2022-02-07 09:43:26', 'S00085 : MR.:> OTOIKHILA, OYAKHIRE', 10.0000, '19', '01088', '201', 'DB3012234', '2022-03-03 To 2023-03-02', '2022:2023', '', '100% RENEWAL PREMIUM DUE ON THE POLICY', 0.0000, 'O08410461', '02014909322', '0000-00-00', 0, '', 0, 'O08410461', 300000000.00, '00004', 100.00, 'NIR', 1.0000, 747500.00, 'QD2202915YNG', 'DIRECT CREDIT', '', '', '', '2022-02-04', 0.00, '', 'B125_18-00001', '', 'P200_03-00014', '', '', '', 'P210_06-00054', '', 'B145_05-00014', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'U05410331'),
('DB1000756', 'DC2202927YNG', '2022-02-07', '2022-02-07', '2022-02-07', 70010.0000, 7001.000, 63009.000, 'RNL', '0020', '202201420092', '031/06/07/300/11', '', '', '2022-02-07 09:44:53', 'S00085 : MR.:> OTOIKHILA, OYAKHIRE', 10.0000, '2', 'GPA_GAC', '201', 'DB3012234', '2022-03-01 To 2023-02-28', '2022:2023', '', '100% RENEWAL PREMIUM DUE ON THE POLICY', 0.0000, 'O08410461', '02014909522', '0000-00-00', 0, '', 0, 'O08410461', 7450000.00, '00009', 100.00, 'NIR', 1.0000, 70010.00, 'QD2202916YNG', 'DIRECT CREDIT', '', '', '', '2022-02-04', 0.00, '', 'B125_18-00001', '', 'P200_03-00012', '', '', '', 'P210_06-00053', '', 'B145_05-00014', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'U05410331'),
('DB1000756', 'DC2202929YNG', '2022-02-07', '2022-02-07', '2022-02-07', 405000.0000, 25312.500, 379687.500, 'RNL', '0020', '202201420094', '021/12/02/300/3213', '', '', '2022-02-07 09:44:22', 'S00085 : MR.:> OTOIKHILA, OYAKHIRE', 6.2500, '1', '021-01', '201', 'DB3012234', '2022-02-04 To 2023-01-30', '2022:2023', '', '100% RENEWAL PREMIUM DUE ON THE POLICY', 0.0000, 'O08410461', '02014872022', '0000-00-00', 0, '', 0, 'O08410461', 6750000.00, '00009', 100.00, 'NIR', 1.0000, 405000.00, 'QD22165837HQR', 'DIRECT CREDIT', '', '', '', '2022-02-04', 0.00, '', 'B125_18-00001', '', 'P200_03-00017', '', '', '', 'P210_06-00031', '', 'B145_05-00014', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'U05410331'),
('DB1000756', 'DC2202930YNG', '2022-02-07', '2022-02-07', '2022-02-07', 504000.0000, 31500.000, 472500.000, 'RNL', '0020', '202201420095', '022/10/12/300/8670', '', '', '2022-02-07 09:37:09', 'S00085 : MR.:> OTOIKHILA, OYAKHIRE', 6.2500, '1', '022-01', '201', 'DB3012234', '2022-02-04 To 2023-01-21', '2022:2023', '', '100% RENEWAL PREMIUM DUE ON THE POLICY', 0.0000, 'O08410461', '02014909422', '0000-00-00', 0, '', 0, 'O08410461', 8400000.00, '00009', 100.00, 'NIR', 1.0000, 504000.00, 'QD22165850HQR', 'DIRECT CREDIT', '', '', '', '2022-02-04', 0.00, '', 'B125_18-00001', '', 'P200_03-00017', '', '', '', 'P210_06-00031', '', 'B145_05-00014', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'U05410331'),
('DB2000124', 'DC22168859HQR', '2022-02-07', '2022-02-07', '2022-02-07', 388729.9700, 77745.994, 310983.976, 'RNL', '0020', '202201420133', '012/14/03/300/4099/CI', '', '', '2022-02-03 15:01:43', 'S00094 : MR.:> YABOH, BINAPADEI', 20.0000, '4', 'FIR_FSPC', '300', 'DB3029163', '2022-01-01 To 2022-03-31', '2022:2023', '', '5% RNL PREMIUM DUE ON THE POLICY ', 0.0000, 'Y0410284', '02014888922', '0000-00-00', 0, '', 0, 'Y0410284', 804245000.00, '00009', 5.00, 'NIR', 1.0000, 388729.97, 'QD22168579HQR', 'EN/14/FRI4000685LA', '', '', '012/14/03/300/4099/CI/2022/11', '2022-01-01', 0.00, '', 'B125_18-00001', '', 'P200_03-00011', '', '', '', 'P210_06-00032', '', 'B145_05-00014', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'D0410257'),
('DB2000433', 'DC22168860HQR', '2022-02-07', '2022-02-07', '2022-02-07', 66369.3200, 8296.165, 58073.155, 'RNL', '0020', '202201420134', 'MOMC/20/01/42466/HQR', '', '', '2022-02-06 17:41:35', 'S00048 : MR.:> EKANEM, ANTHONY', 12.5000, '1', '023-01', '300', '160003554', '2022-01-27 To 2022-07-28', '2022:2023', '', 'OUR 10% SHARE OF PREMIUM DUE ON POLICY', 0.0000, 'E0310214', '02014906522', '0000-00-00', 0, '', 0, 'E0310214', 3309400.00, '00009', 10.00, 'NIR', 1.0000, 66369.32, 'QD22168837HQR', 'L A 1 2 5 1 8', '', '', 'MOMC/20/01/42466/HQR/2022/6', '2022-01-27', 0.00, '', 'B125_18-00001', '', 'P200_03-00017', '', '', '', 'P210_06-00031', '', 'B145_05-00014', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'A11410508'),
('111093', 'CR22168861HQR', '2022-02-07', '2022-02-07', '2022-02-07', 0.0000, 1659.230, -1659.230, 'ORC2', '0031', '202201420135', 'MOMC/20/01/42466/HQR', '', 'DC22168860HQR', '2022-02-07 11:09:24', 'S00048 : MR.:> EKANEM, ANTHONY', 2.5000, '1', '023-01', '300', '160003554', '2022-01-27 To 2022-07-28 To ', '2022:2023', '', 'ORC on [Pol.MOMC/20/01/42466/HQR] [Doc. DC22168860HQR]', 0.0000, 'A19410681', '', '0000-00-00', 0, '', 0, 'E0310214', 0.00, '00009', 0.00, 'NIR', 1.0000, 0.00, '', '', '', '', '', '0000-00-00', 0.00, 'N', '', '', '', '', 'P200_03-00041', '', '', '', '', '', 'B145_05-00010', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'A11410508'),
('DB2000026', 'DC22168862HQR', '2022-02-07', '2022-02-07', '2022-02-07', 61355.1500, 7669.394, 53685.756, 'RNL', '0020', '202201420136', 'MOMC/21/11/60319/HQR', '', '', '2022-02-04 18:14:43', 'S00048 : MR.:> EKANEM, ANTHONY', 12.5000, '1', '023-01', '300', '200022456', '2022-02-06 To 2022-05-05', '2022:2023', '', '100% RENEWAL PREMIUM DUE ON POLICY', 0.0000, 'E0310214', '02014906722', '0000-00-00', 0, '', 0, 'E0310214', 5032500.00, '00009', 100.00, 'NIR', 1.0000, 0.00, 'QD22168736HQR', 'CN-ARK-LIAP-78591', '', '', 'MOMC/21/11/60319/HQR/2022/1', '2022-02-04', 0.00, '', 'B125_18-00001', '', 'P200_03-00017', '', '', '', 'P210_06-00031', '', 'B145_05-00014', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'E0310199'),

HTML: 
➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖
█  Format - .SQL
█  Size file - 2gb
█  All rows - 3.7m lines
█  Website - ies.linkageassurance.com
█  Date - 01.03.2023
➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖

View hidden content is available for registered users!
 
Last edited:
Hi @Chucky , would you please fix this download link as well? I would like to get something valuable for credits.
 

UPDATED LINKS TO DOWNLOAD THIS DATABASE.
SEE THE NEW URLS IN THE FIRST POST OF THIS TOPIC.
 
You must log in or register to reply here.

Users who are viewing this thread

Copyright © 2022 LeakBase All rights reserved.
Home Register
Top Bottom