Sql © Chucky Credits Linkage Assurance Plc - Ies.linkageassurance.com
Today I have uploaded the Linkage Assurance Plc Database for you to download, thanks for reading and enjoy!
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: