--
-- Host: localhost    Database: logistics
-- ------------------------------------------------------


--
-- Table structure for table `boda_agents_details`
--

CREATE TABLE `boda_agents_details` (
  `staffID` int(11) NOT NULL,
  `nextOfKinFullName` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `nextOfKinRelationship` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `nextOfKinPhone` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `residence` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `bikePlateNumber` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `areaOfOperation` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `registrationNumberOfOperation` int(10) DEFAULT NULL,
  `regFeeMpesaRefNo` varchar(100) DEFAULT NULL,
  `regFeeMpesaAccNo` varchar(100) DEFAULT NULL,
  `regFeeMpesaAmt` decimal(12,2) DEFAULT NULL,
  `regFeeMpesaReceiptNo` varchar(100) DEFAULT NULL,
  `regFeePaymentApproach` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `regFeeDailyPaymentMethod` int(3) NOT NULL DEFAULT '0',
  `regFeeLaterPaymentDate` datetime DEFAULT NULL,
  `regFeeLaterPaymentReason` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `commissionPaymentOption` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `commissionMpesaNo` varchar(20) DEFAULT NULL,
  `commissionPaymentBankOptionBankName` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `commissionPaymentBankOptionBankBranch` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `commissionPaymentBankOptionBankAccountNo` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `ownsBike` int(3) DEFAULT NULL,
  `rentedMotorbike` int(3) NOT NULL DEFAULT '0',
  `bikeInsured` int(3) DEFAULT NULL,
  `bikeInsuranceCompany` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `bikeOnLoan` int(3) DEFAULT NULL,
  `bikeOnHirePurchase` int(3) DEFAULT NULL,
  `bikeOnLoanAmount` decimal(12,2) DEFAULT NULL,
  `flexibleToCarryHeavyGoods` int(3) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `boda_agents_details`
--

INSERT INTO `boda_agents_details` VALUES (38,'Jane Kaluhi','wife','0712233938',NULL,'KMFJ 583K','commercial accra',1,'0724036790','PBF70YREF',50.00,'','Partial Payment',0,NULL,'','M-PESA','','','','',1,0,1,'sanlam insurance',0,0,NULL,NULL),(41,'Rahab wanjiru','mother','0722818466',NULL,'KMFJ 916W','Kirinyaga rd/voi rd',5,'0727702141','PBF4P43084',50.00,'005','Partial Payment',0,NULL,'','M-PESA','0727702141','','','',1,0,0,'',0,0,NULL,NULL),(42,'Hgfvvxv','Gvccvvg','07854123658',NULL,'KDgg334X','Ggff',8542,'TTYU5677G','Gjbghch vgb',100.00,'58721','Partial Payment',1,NULL,'','M-PESA','07854236521','','','',1,0,1,'Jubilee',0,1,NULL,NULL),(50,'Esther Wanjiku','mother','0702243656',NULL,'KMEN 460c','Guru nanak',1,'PBG7Q1DJD7B','Stephen',5.00,'','Partial Payment',0,NULL,'','M-PESA','0705538928','','','',1,0,1,'Amaco',0,0,NULL,NULL),(51,'virginia njeri mwangi','wife','0725126597',NULL,'kmfk915f','marikiti',1,'PBF50XIA4V','JAMES',50.00,'','Partial Payment',0,NULL,'','M-PESA','','','','',0,0,0,'',0,1,NULL,NULL),(52,'Mofart Nhanga','son','0759001022',NULL,'KMEU 395M','Gurunanak',1,'PBG8Q2BOC8','Robert',50.00,'','Partial Payment',0,NULL,'','M-PESA','0722538969','','','',1,0,1,'Occidental',0,0,NULL,NULL),(53,'peninah waguthii njomo','wife','0792789468',NULL,'kmdj237f','country bus',1,'PBF9POT3QL','JOHN',50.00,'','Partial Payment',0,NULL,'','M-PESA','','','','',1,0,0,'',0,0,NULL,NULL),(54,'Nancy Muthoni','Wife','0717483316',NULL,'KMFJ 428E','Muthurwa',1,'PBF6P2FEVO','Samuel',50.00,'','Partial Payment',0,NULL,'','M-PESA','0746939335','','','',1,0,1,'Sanlam insurance',0,0,NULL,NULL),(55,'zulfa natalia','wife','0712909066',NULL,'kmfd660d','juja road',1,'PBG6Q5XCMI','JOHN',50.00,'','Partial Payment',0,NULL,'','M-PESA','','','','',0,0,1,'monarch',0,0,NULL,NULL),(56,'zulfa natalia','wife','0712909066',NULL,'kmfd660d','juja road',1,'PBG6Q5XCMI','JOHN',50.00,'','Partial Payment',0,NULL,'','M-PESA','','','','',0,0,1,'monarch',0,0,NULL,NULL),(57,'Jane njeri','mother','0718344517',NULL,'KMFB885P','Pangani chai rd',1,'PBG8Q5VYSE','Christom',50.00,'','Partial Payment',0,NULL,'','M-PESA','0705749803','','','',1,0,1,'Sanlam General',0,0,NULL,NULL),(58,'Victoria Gathoni','Friend ','0714768963',NULL,'kmxc 123y','juja',2580369,'pbf8h4298','sheila',50.00,'236589','Partial Payment',0,NULL,'','M-PESA','0714714319','','','',0,0,0,'',0,0,NULL,NULL),(71,'miriam juma','wife','0743639453',NULL,'kmfh557e','ramu house Eastleigh',1,'PBG9Q9RU6V','MENLICK',50.00,'','Partial Payment',0,NULL,'','M-PESA','0722783708','','','',1,0,1,'sanlam',0,0,NULL,NULL),(72,'Pamela Gathoni','wife','0705948376',NULL,'KMDU376L','Eastleigh',1,'PBG6Q8PBYC','lawrence',50.00,'','Partial Payment',0,NULL,'','M-PESA','0715989593','','','',1,0,0,'',0,0,NULL,NULL),(73,'petronila mwende','wife','0707506349',NULL,'KMFB 947Y','Gallore eastleigh',1,'PBG9QC020T','Elphas Bardot',50.00,'','Partial Payment',0,NULL,'','M-PESA','0727169637','','','',0,0,1,'Amaco',0,0,NULL,NULL),(74,'James Mwangi','brother','0725424452',NULL,'Kmfa 077t','Carissa Rd eastleigh',1,'PBG9QD1EXH','Moses',50.00,'','Partial Payment',0,NULL,'','M-PESA','0746586193','','','',1,0,1,'the monarch',0,0,NULL,NULL),(75,'Catherine Omia','wife','0701202815',NULL,'KMEL 969Z','8th street',1,'PBG5QES0E3','Francis',50.00,'','Partial Payment',0,NULL,'','M-PESA','','','','',0,0,1,'The monarch',0,0,NULL,NULL),(76,'Elizabeth Wambura','Mother','0705622538',NULL,'KMER 089N','8th Street eastleigh',1,'PBG1QF0809','John',50.00,'','Partial Payment',0,NULL,'','M-PESA','0715714399','','','',1,0,1,'The monarch',0,0,NULL,NULL),(77,'Nancy Njambi','mother','0724854346',NULL,'KMEZ914C','Kirinyaga rd',1,'PBF3P6L2R','Simon',50.00,'','Partial Payment',0,NULL,'','M-PESA','0706635579','','','',1,0,1,'The Monarch',0,0,NULL,NULL),(83,'Prudence Mukami','Daughter','0725548754',NULL,'KMEL 257X','posts githurai',1,'PBH3RBKFNH','Charles',50.00,'','Partial Payment',0,NULL,'','M-PESA','0717544678','','','',0,0,1,'Amaco',0,0,NULL,NULL),(84,'Tabitha Waweru','Mother','0716148752',NULL,'KMEM 360F','posts githurai',1,'PBH9RBYBH5','Samuel',50.00,'','Partial Payment',0,NULL,'','M-PESA','0716199076','','','',1,0,1,'The monarch',0,0,NULL,NULL),(85,'Catherine','mother','0791634989',NULL,'KMEL 325Y','posts githurai',1,'PBHRB1PS6','Ian',50.00,'','Partial Payment',0,NULL,'','M-PESA','0791634989','','','',1,0,1,'monarch',0,0,NULL,NULL),(86,'Wanjiku','mother','0716199076',NULL,'KMEZ910G','posts githurai',1,'PBH2RCQUT1','Joseph',50.00,'','Partial Payment',0,NULL,'','M-PESA','0796034944','','','',1,0,1,'monarch',0,0,NULL,NULL),(87,'Julia mwende','mother','0796250697',NULL,'KMEU 177D','posts githurai',1,'PBH3RDCRH7','',50.00,'','Partial Payment',0,NULL,'','M-PESA','0742912205','','','',1,0,1,'Monarch',0,0,NULL,NULL),(88,'Ruth Wambui','wife','0710405693',NULL,'KMER 717M','posts githurai',1,'PBH1RBCN2B','Paul',50.00,'','Partial Payment',0,NULL,'','M-PESA','0724178069','','','',1,0,0,'',0,0,NULL,NULL),(89,'Janerex Amunga','wife','0725735518',NULL,'KMEB 679G','Posts, githurai',1,'PBH9RE9BOT','Peter',50.00,'','Partial Payment',0,NULL,'','M-PESA','0720603344','','','',1,0,1,'The monarch',0,0,NULL,NULL),(90,'Mary muthoni','Auntie','0725389711',NULL,'KMFA 568B','posts, githurai',1,'PBH8REZ440','David',50.00,'','Partial Payment',0,NULL,'','M-PESA','0712667847','','','',1,0,1,'The Monarch',0,0,NULL,NULL),(91,'elijahkamau','father','0723617529',NULL,'KMEH850D','MBC 6th street',1,'PBG3R2JIWZ','KELVIN',50.00,'','Partial Payment',0,NULL,'','M-PESA','','','','',1,0,0,'',0,0,NULL,NULL),(92,'Mercy wambui waweru','wife','0700266264',NULL,'KMED 600Z','posts, githurai',1,'PBH5RG3IOR','Robert',50.00,'','Partial Payment',0,NULL,'','M-PESA','0708227395','','','',1,0,1,'The Monarch',0,0,NULL,NULL),(93,'Pauline Wairimu','Wife','0723168409',NULL,'KMEM 827C','post bank, githurai',1,'PBH3RH9FJB','Thomas',50.00,'','Partial Payment',0,NULL,'','M-PESA','0723168409','','','',1,0,0,'',0,0,NULL,NULL),(94,'charles mwangi','brother','0719610772',NULL,'KMEP 289L','githurai',2018,'PBH5REDHGN','daniel',50.00,'','Partial Payment',0,NULL,'','Bank Account','','equity','githurai','0710179956385',1,0,1,'monarch',0,0,NULL,NULL),(100,'Francisca mwendwa','wife','0706150103',NULL,'kmew629h','githurai round about',20,'PBH7RJQAB9','Robert mugambi',50.00,'1','Partial Payment',0,NULL,'','M-PESA','0706150094','','','',1,0,1,'monarch',0,0,NULL,NULL),(108,'kelvin kiarie','brother ','0768762330',NULL,'KMER 160H','githurai 45',160,'PBH4RMN32C','Felix waithera ',50.00,'2','Partial Payment',0,NULL,'','M-PESA','0713758443','','','',1,0,0,'',0,0,NULL,NULL),(109,'grace waithera','mother','0721738544',NULL,'kmfb727b','githurai 45',727,'PBH8RN4X1','kelvinwaithera',50.00,'2','Partial Payment',0,NULL,'','M-PESA','0768762330','','','',1,0,0,'',0,0,NULL,NULL),(121,'Benard Kioko','Dad','0710820142',NULL,'KMEL 578G','Githurai 45',1,'PBH6RFZ3A6','Daniel',50.00,'','Partial Payment',0,NULL,'','M-PESA','0724732994','','','',0,0,1,'The Monarch',0,0,NULL,NULL),(122,'Ian kinuthia','son','0768739691',NULL,'KMEG 361S','Githurai',1,'PBH6REZXMU','Francis',50.00,'','Partial Payment',0,NULL,'','M-PESA','0728200364','','','',1,0,1,'The Monarch',0,0,NULL,NULL),(123,'Nellius wambui','wife','0746792485',NULL,'KMEV 902Z','Githurai',1,'PBH7REJJ8Z','Gabriel',50.00,'','Partial Payment',0,NULL,'','M-PESA','0718266554','','','',1,0,1,'The Monarch',0,0,NULL,NULL),(124,'robert mutua','brother','0726302381',NULL,'KMDA481J','YOEZ',1,'PBH7RQ27GJ','FESTUS',50.00,'','Partial Payment',0,NULL,'','M-PESA','0708528134','','','',1,0,0,'',0,0,NULL,NULL),(125,'Jane Wanjira','Mother','0723381163',NULL,'KMET 247X','Githurai 44',1,'PBI3SGBV61','Peter',50.00,'','Partial Payment',0,NULL,'','M-PESA','0799172173','','','',1,0,0,'',0,0,NULL,NULL),(127,'Nancy Muthoni','mother','0704922631',NULL,'KMFJ 781L','Rware githurai',1,'PBI7SLB2W3','Shalom',50.00,'','Partial Payment',0,NULL,'','M-PESA','0758605923','','','',0,0,1,'Trident',0,0,NULL,NULL),(129,'jane Mwangi ','wife','0704223504',NULL,'KMEN 967T','GITHURAI 45',1,'PBH1RJY8PN','zachary ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0727518580','','','',0,0,1,'ALLYSON',0,0,NULL,NULL),(130,'james muiruri','brother','0724360943',NULL,'KMET 952Q','GITHURAI 45',1,'PBH7RKOFM3','ALEX',50.00,'','Partial Payment',0,NULL,'','M-PESA','0720671997','','','',1,0,1,'ALLYSON ',0,0,NULL,NULL),(131,'everlyne nyambura','sister','0715009105',NULL,'KMEZ462C','GITHURAI 45',1,'PBH6RCDOGE','MARTIN',50.00,'','Partial Payment',0,NULL,'','M-PESA','0716363985','','','',1,0,1,'SHAMAM',0,0,NULL,NULL),(132,'Alice Wambui','Wife','0703470434',NULL,'KMFG 833K','kahawa west',1,'PBI5SKIUQN','Simon Gitau',50.00,'','Partial Payment',0,NULL,'','M-PESA','0748925262','','','',0,0,1,'Sanlam General',0,1,NULL,NULL),(133,'Tabitha ruguru','wife','0705583258',NULL,'KMFJ497E','GITHURAI 45',1,'PBH7RK39X5','SAMUEL',50.00,'','Partial Payment',0,NULL,'','M-PESA','0782980880','','','',1,0,1,'SANLAM',0,0,NULL,NULL),(134,'Margaret Scola','Mother','0723928941',NULL,'KMFG 084D','Mambrose githurai',1,'PBH7RMP661','Daniel',50.00,'','Partial Payment',0,NULL,'','M-PESA','0769969247','','','',0,0,1,'Sanlam General',0,0,NULL,NULL),(135,'francis liruu','father','0706141858',NULL,'KMFF319P','JUJA B ESTATE',1,'PBG3Q80T5P','richard',50.00,'','Partial Payment',0,NULL,'','M-PESA','0757318044','','','',1,0,1,'MONARCH',0,0,NULL,NULL),(136,'Teresia Mwihaki','Wife','0791245388',NULL,'KMFK337V','Third street',1,'PBG4QA5WMO','Samuel',50.00,'','Partial Payment',0,NULL,'','M-PESA','0726042215','','','',1,0,1,'SANLAM',0,0,NULL,NULL),(137,'Pogba','friend','00000',NULL,'KMDU137Y','Eastleigh',1,'PBG3QGXTYF','John Nganga',50.00,'','Partial Payment',0,NULL,'','M-PESA','0700323779','','','',1,0,1,'N/A',0,0,NULL,NULL),(138,'Monicah Alex','Wife','0702637458',NULL,'KMDR588C','MJR Kinyanjui',1,'PBG3Q8PO3L','Alex ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0708885669','','','',1,0,1,'MONARCH ',0,0,NULL,NULL),(139,'Margaret Wamaitha','Wife','0799297158',NULL,'KMFM 575D','Thika',1,'PBJ1TRJ3MB','Antony',50.00,'','Partial Payment',0,NULL,'','M-PESA','0721117445','','','',1,0,1,'Sanlam General',0,0,NULL,NULL),(141,'Josephine Wangui','Wife','0757438024',NULL,'KMEG 686K','Siko,weteithie',1,'PBJ7TWTAYN','Simon',50.00,'','Partial Payment',0,NULL,'','M-PESA','0700508917','','','',1,0,1,'Monarch',0,0,NULL,NULL),(142,'Pauline Wanjeri','Mother','0708286396',NULL,'KMFK 822J','Weteithie stage',1,'PBJDUOD16U','Moses',50.00,'','Partial Payment',0,NULL,'','M-PESA','0111511273','','','',0,0,1,'Sanlam',0,0,NULL,NULL),(143,'Margaret Wainaina','Wife','0798589636',NULL,'KMEN 529N','Weteithie stage',1,'PBJ7TR2HUR','Stanley',50.00,'','Partial Payment',0,NULL,'','M-PESA','072470319','','','',1,0,0,'',0,0,NULL,NULL),(144,'Grace Wangari','wife','0705678274',NULL,'KMDG 842G','Weteithie stage',1,'PBJ5TQFY4H','Benard',50.00,'','Partial Payment',0,NULL,'','M-PESA','0795189037','','','',1,0,0,'',0,0,NULL,NULL),(145,'Lucy Njeri','Wife','0715117210',NULL,'KMFC 689M','kwa mti,weteithie',1,'PBJ9TPHBY3','Duncan',50.00,'','Partial Payment',0,NULL,'','M-PESA','0727053982','','','',1,0,0,'',0,0,NULL,NULL),(146,'Maureen Wambui','Wife','0741901202',NULL,'KMEC 651N','Siko, weteithie',1,'PBJ6TNNFQK','Brian',100.00,'','Partial Payment',0,NULL,'','M-PESA','0713932904','','','',0,0,0,'',0,0,NULL,NULL),(147,'Esther Mugure ','Mother','0710316805',NULL,'KMEW008X','Witeithie',1,'PBJ4TUEKXS','David ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0718885651','','','',0,0,1,'monarch ',0,0,NULL,NULL),(148,'Rachel Ngina','Wife','0722443889',NULL,'KMFG143W','Witeithie Soko',1,'PBJ3TXW8X3','Daniel',50.00,'','Partial Payment',0,NULL,'','M-PESA','0714036859','','','',1,0,1,'SANLAM',0,0,NULL,NULL),(149,'Mbuvi','Son','000000',NULL,'KMEJ 969F','Witeithie Soko',1,'PBJ9TW11OH','Peter',50.00,'','Partial Payment',0,NULL,'','M-PESA','0721764247','','','',1,0,0,'',1,0,NULL,NULL),(150,'Rose Waithera','Mother','0717726995',NULL,'KMFJ160M','Witeithie Soko',1,'PBJ6TOWKQA','Paul',50.00,'','Partial Payment',0,NULL,'','M-PESA','0708743626','','','',1,0,0,'',0,0,NULL,NULL),(151,'Photensia Njoki','Wife','0719287566',NULL,'KMDW276L','witeithie stage',1,'PBJ1TRG42N','John',50.00,'','Partial Payment',0,NULL,'','M-PESA','0794854684','','','',1,0,0,'',0,0,NULL,NULL),(152,'Margaret Wanjira','Wife','0791660820',NULL,'KMEA012S','GITHURAI STANMART',1,'PBI5SSQXE','Peter Muturi ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0711118145','','','',1,0,0,'',0,0,NULL,NULL),(153,'Beatrice Muchoki','wife','0791928338',NULL,'KMFM 413E','Mlandizi,juja',1,'PBJ7UCPPR3','Joseph',50.00,'','Partial Payment',0,NULL,'','M-PESA','0715772786','','','',0,0,1,'The monarch',0,0,NULL,NULL),(154,'Agnes Karanja','wife','0726583283',NULL,'KMEJ 583Z','JKUAT,Gate B',1,'PBJ2UEK206','Kennedy',50.00,'','Partial Payment',0,NULL,'','M-PESA','0726307823','','','',1,0,0,'',0,0,NULL,NULL),(155,'Telvin Muhia','son','0707585993',NULL,'KMCU 708D','JKUAT,gate b',1,'PBJ1UF9PY3','Christopher',50.00,'','Partial Payment',0,NULL,'','M-PESA','0718186910','','','',1,0,0,'',0,0,NULL,NULL),(156,'Ritah Mbae','Wife','0725732810',NULL,'KMFA 471B','juja,petanns',1,'PBJ1UAZ32B','Samuel',50.00,'','Partial Payment',0,NULL,'','M-PESA','0714062593','','','',1,0,1,'The Monarch',0,0,NULL,NULL),(157,'Linnet Nafula','mother','0708784852',NULL,'KMEL 275C','Petanns,Juja',1,'PBJ0UBOTH4','Isaac',50.00,'','Partial Payment',0,NULL,'','M-PESA','0728659937','','','',1,0,1,'Sanlam General',0,0,NULL,NULL),(158,'Jane Wanjiru','Wife','0797400172',NULL,'KMDX062G','Gadhima Plaza',1,'PBI4SMQX52','Fredrick Ngige',50.00,'','Partial Payment',0,NULL,'','M-PESA','0706430003','','','',1,0,0,'',0,0,NULL,NULL),(159,'Steven Waweru','brother','0720742482',NULL,'KMFC660E','GITHURAI ',1,'PBI1SOJM8F','Joseph Muchiri',50.00,'','Partial Payment',0,NULL,'','M-PESA','0721162607','','','',1,0,1,'SANLAM',1,0,NULL,NULL),(160,'Stephen Ondiek ','father','0728700918',NULL,'KMFG259F','GITHURAI ',1,'PBI750VN8N','ABED ONDIEK',50.00,'','Partial Payment',0,NULL,'','M-PESA','0702401171','','','',1,0,1,'Sanlam',1,0,NULL,NULL),(161,'Delvin Wachera','Wife','0717390875',NULL,'KMEJ801G','Rurii',1,'PBI9SIDI03','DISHON',50.00,'','Partial Payment',0,NULL,'','M-PESA','0711526364','','','',0,0,0,'',0,0,NULL,NULL),(162,'francis mwangi','friend','0746806335',NULL,'KMFE729Z','GITHURAI POST BANK',1,'PBI3SKNZFH','manasseh',50.00,'','Partial Payment',0,NULL,'','M-PESA','0705466336','','','',1,0,1,'SANLAM ',0,0,NULL,NULL),(163,'Felistas Muthoni Maina','mother','0718262642',NULL,'KMEG374P','GITHURAI 45',1,'32752837','JOSEPH ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0716527146','','','',1,0,1,'G.A INSURANCE',0,0,NULL,NULL),(164,'Teresia Muthoni','Wife ','0759307337',NULL,'KMFD641X','CANNAN',1,'PBH4RPR7P6','James',50.00,'','Partial Payment',0,NULL,'','M-PESA','0759709054','','','',1,0,1,'KINGDOM',0,0,NULL,NULL),(165,'Joseph','Friend','00000000',NULL,'KMEK362W','Thika SuperHighway',59,'PBI95ITICJ','Regan',50.00,'','Partial Payment',0,NULL,'','M-PESA','0769838254','','','',1,0,0,'',0,0,NULL,NULL),(166,'Maryann','Wife ','0712265815',NULL,'KMDN428R','D.O ROAD',20,'PBI9M605','gerishon',50.00,'','Partial Payment',0,NULL,'','M-PESA','0716293479','','','',1,0,0,'',0,0,NULL,NULL),(168,'xxx','xxx','000',NULL,'KMEQ247Z','D.O ROAD',1,'PBI3SMFSJV','SAMUEL',50.00,'','Partial Payment',0,NULL,'','M-PESA','0714875958','','','',1,0,0,'',0,0,NULL,NULL),(169,'Wanjiru Mwangi','Wife ','0723213537',NULL,'Kmdf331m','Full Gospel ',1,'PBHTRRSQWF','George ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0720722597','','','',1,0,0,'',0,0,NULL,NULL),(170,'Ester Wambui','mother','0725727861',NULL,'KMFB582M','Mambrose',10,'PBH5RMZ01','DENNIS',50.00,'','Partial Payment',0,NULL,'','M-PESA','0795938649','','','',1,0,1,'OCCIDENTAL ',0,0,NULL,NULL),(171,'Jane Wanjiru ','Mother','0727755715',NULL,'KMFE310V','GITHURAI ',1,'PBH9RAQTKH','Erick Maina',50.00,'','Partial Payment',0,NULL,'','M-PESA','0790271397','','','',1,0,1,'MOGO',1,0,NULL,NULL),(172,'Gatheria Mbugua','father','0726226784',NULL,'KMDK534A','GITHURAI 45 STAGE',1,'PBH2RJ743M','Kevin',50.00,'','Partial Payment',0,NULL,'','M-PESA','0759561280','','','',1,0,0,'',0,0,NULL,NULL),(173,'Damaris Muthoni ','sister','0715605550',NULL,'KMFK126L','GITHURAI POST BANK ',1,'PBH5RB4H1D','Robert ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0701050314','','','',1,0,1,'SANLAM',1,0,NULL,NULL),(174,'Franklin Mutuma ','brother ','0710541496',NULL,'kmer490w','kawangware ',490,'PBK1V4E6VZ','festusgideon',50.00,'1','Partial Payment',0,NULL,'','M-PESA','0702024160','','','',0,0,0,'',0,0,NULL,NULL),(175,'Daniel Njenga','Father','07',NULL,'KMDR 800M','GITHURAI 45',1,'PBH9RDu0R7','Stephen ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0792077630','','','',0,0,1,'TRIDENT',0,0,NULL,NULL),(176,'Gibugi Kelvin','Friend','00000',NULL,'KMFC266N','Strawberry Plaza',3,'PBG9Q7NAZX','DANIEL',50.00,'','Partial Payment',0,NULL,'','M-PESA','0748188245','','','',0,0,1,'MONARCH',0,0,NULL,NULL),(177,'Mbogo','Father','0728727469',NULL,'KMES430Q','FIVE STREET',1,'PBG9DEYGB','PHILIP',50.00,'','Partial Payment',0,NULL,'','M-PESA','0701630439','','','',1,0,1,'MONARCH',0,0,NULL,NULL),(178,'Monica wamaitha','wife ','0769096528',NULL,'KMEF','GITHURAI 45',1,'PBH8RCV0B2','DAVID MUGURO',50.00,'','Partial Payment',0,NULL,'','M-PESA','0718492314','','','',0,0,0,'',0,0,NULL,NULL),(179,'Grace Muthoni ','Mum','0727935042',NULL,'KMEU566M','Mlango Round About ',1,'PBG3Q57ILN','John',50.00,'','Partial Payment',0,NULL,'','M-PESA','0795434141','','','',1,0,1,'COMPREHENSIVE',0,0,NULL,NULL),(180,'Rose Muthoni','wife','0791989813',NULL,'KMEL250Y','GITHURAI 45',1,'PBH2RLDKW4','JULIUS',50.00,'','Partial Payment',0,NULL,'','M-PESA','0724174932','','','',0,0,0,'',0,0,NULL,NULL),(181,'Eunice Muhati ','wife ','0748890157',NULL,'kmdx695s','kawangware ',695,'PBK7V5B6WZ','Daniel Owiti ',50.00,'1','Partial Payment',0,NULL,'','M-PESA','0726225486','','','',1,0,1,'monarch ',0,0,NULL,NULL),(182,'Esther Wambui','wife','0727277218',NULL,'KMEW396U','GITHURAI ROUND ABOUT',1,'PBH3RKNR29','PETER WAWERU NDIRANGU',50.00,'','Partial Payment',0,NULL,'','M-PESA','0711387495','','','',1,0,1,'SANLAM',0,0,NULL,NULL),(183,'winfred mwikali','wife','0721135258',NULL,'KMDW016B','12TH Street Rafiki',1,'PBG0QJGC2K','Bernard',50.00,'','Partial Payment',0,NULL,'','M-PESA','0726266929','','','',1,0,0,'',0,0,NULL,NULL),(184,'Abdramani','Son','0000',NULL,'KMFC723T','MLANGO',1,'PBGBQ4FIV4','OMARI',50.00,'','Partial Payment',0,NULL,'','M-PESA','0726278761','','','',1,0,1,'MONARCH',0,0,NULL,NULL),(185,'Eunice Syombua','Wife','0742062038',NULL,'KMFF392T','Eastleigh ',1,'PBG8QIJWT0','Stephen mwanzia',50.00,'','Partial Payment',0,NULL,'','M-PESA','0702673962','','','',1,0,0,'',1,0,NULL,NULL),(186,'Charlie Ruguru','Son','0712269164',NULL,'KMEP227G','Kirinyaga Road',1,'PBF7P6ZTH5','George',50.00,'','Partial Payment',0,NULL,'','M-PESA','0715329604','','','',1,0,0,'',0,0,NULL,NULL),(187,'Nicholas Wambua','Brother ','0743191478',NULL,'KMFF854M','Apex',1,'PBI2SMCV9U','Joseph',50.00,'','Partial Payment',0,NULL,'','M-PESA','0710226118','','','',0,0,1,'SANLAM',0,1,NULL,NULL),(188,'Rachael Wanjiru','wife','0715808544',NULL,'KMDN762S','Nairobi CBD',1,'PBF40UVY9Q','Ignatius',50.00,'','Partial Payment',0,NULL,'','M-PESA','0708747529','','','',1,0,1,'XPLICO',0,0,NULL,NULL),(201,'Josphat Omanga','Friend','0757870542',NULL,'KMFK 906W','Friendly five,kawangware',1,'PBK7VFDXC3','James',50.00,'','Partial Payment',0,NULL,'','M-PESA','0793754972','','','',1,0,1,'GA insurance',0,0,NULL,NULL),(202,'Dolphins Kwamboka','Wife','0715039770',NULL,'KMET 240W','shalom stage, kawangware',1,'PBK2VTMY3K','Josphat Karanja',50.00,'','Partial Payment',0,NULL,'','M-PESA','0794913329','','','',1,0,0,'',0,0,NULL,NULL),(203,'Mary Nduta','wife','0790117807',NULL,'KMDW050T','sokoni kawangware',50,'PBK8VH5S12','petermwiti',50.00,'1','Partial Payment',0,NULL,'','M-PESA','0716608415','','','',1,0,1,'Trident',0,0,NULL,NULL),(204,'Ken Lumati','Brother','0704510874',NULL,'KMEW 943H','Bottom line,kawangware',1,'PBK9VBFUQB','Sablon',50.00,'','Partial Payment',0,NULL,'','M-PESA','0758790868','','','',1,0,1,'The monarch',0,0,NULL,NULL),(205,'Atnas Chege','brother','0797533891',NULL,'KMEW 256Z','Juja',1,'PBJ1TJFGT9','Joseph',50.00,'','Partial Payment',0,NULL,'','M-PESA','0729454411','','','',1,0,0,'',0,0,NULL,NULL),(206,'Jane maina','wife','0717574368',NULL,'KMFC 860V','Juja',1,'PBJ5TVT80Z','Erick',50.00,'','Partial Payment',0,NULL,'','M-PESA','0741941811','','','',1,0,1,'The monarch',0,0,NULL,NULL),(207,'Mwangi maina','friend','0721595666',NULL,'KMDN 727X','Juja stage',1,'PBJ6VRF950','Amos',50.00,'','Partial Payment',0,NULL,'','M-PESA','0700529940','','','',0,0,0,'',0,0,NULL,NULL),(208,'Juma Festus','Friend','0726735395',NULL,'KMFE 566A','Juja',1,'PBJ3TQ20T7','Elisha',50.00,'','Partial Payment',0,NULL,'','M-PESA','0726395735','','','',1,0,1,'Monarch',0,0,NULL,NULL),(209,'Margaret Waceke','wife','0728237638',NULL,'KMCZ 809B','Backyard,Juja',1,'PBJ5UI02T9','John',50.00,'','Partial Payment',0,NULL,'','M-PESA','0721569756','','','',1,0,0,'',0,0,NULL,NULL),(210,'Stella Onyango','wife','0724569797',NULL,'KMEH 059R','Backyard,juja',1,'PBJ3064URV','Kelvin',50.00,'','Partial Payment',0,NULL,'','M-PESA','0741937287','','','',0,0,1,'Sanlam',1,0,NULL,NULL),(211,'Erick Nyakundi','friend','0710149496',NULL,'KMDA 997K','Junction, Emmanuel',1,'PBKOV274VW','Kennedy',50.00,'','Partial Payment',0,NULL,'','M-PESA','0724170798','','','',1,0,0,'',0,0,NULL,NULL),(212,'Irungu','friend','0710889125',NULL,'KMEB 616F','46, Kawangware',1,'PBK6V0CLSE','Lawrence',50.00,'','Partial Payment',0,NULL,'','M-PESA','0724137894','','','',0,0,0,'',0,0,NULL,NULL),(213,'Moses Nyarasi','brother','0702483064',NULL,'KMEH 155J','Kawangware 46',1,'PBK4V4Q0JK','Elijah',50.00,'','Partial Payment',0,NULL,'','M-PESA','0795606125','','','',1,0,1,'SANLAM',0,0,NULL,NULL),(223,'Faith Okalo','Wife','0722873178',NULL,'KMEP 971R','Kenice stage,kariobangi',1,'PBM3XEUCRR','Daniel okalo',50.00,'','Partial Payment',0,NULL,'','M-PESA','0715739206','','','',1,0,1,'Trident insurance',0,0,NULL,NULL),(224,'Faith Osano','Wife','0729030056',NULL,'KMDE334D','Tajj mall',334,'PBM7XGYYDR','Adams wesonga',50.00,'1','Partial Payment',0,NULL,'','Cash','0725204597','','','',1,0,0,'',0,0,NULL,NULL),(225,'Monica mugure','mother','0716533699',NULL,'KMFE 837B','Waiyaki way',1,'PBM4X1NH94','Peter mwangi',50.00,'','Partial Payment',0,NULL,'','M-PESA','0700514821','','','',0,0,1,'the monarch',0,0,NULL,NULL),(226,'Stella Amondi','wife','0769397540',NULL,'KMET 527J','Mathare North',1,'PBM8XJ97E6','Jectone',50.00,'','Partial Payment',0,NULL,'','M-PESA','0701816564','','','',1,0,0,'',0,0,NULL,NULL),(227,'Alice Wangari','Wife','0790240759',NULL,'KMFH085W','GITHURAI 45',1,'PBH1REBTF','Kelvin Mwangi',50.00,'','Partial Payment',0,NULL,'','M-PESA','0746270003','','','',1,0,1,'GA INSURANCE',1,0,NULL,NULL),(228,'Eunice Kagwi','Friend','0720233580',NULL,'KMFC612W','Kirinyaga Road ',1,'PBH9RINGYL','Henry Njuguna',100.00,'','Partial Payment',0,NULL,'','M-PESA','0728816492','','','',1,0,0,'',0,0,NULL,NULL),(229,'Pauly Mugo','Wife','0706332369',NULL,'KMEP202G','GITHURAI ',1,'PBH1RP1XOL','Wambu',50.00,'','Partial Payment',0,NULL,'','M-PESA','0724427198','','','',1,0,1,'ELGON',0,0,NULL,NULL),(230,'Faith Kamau','Wife','0719483590',NULL,'KMER949G','GITHURAI ',1,'PBH3RFCCFR','Joseph',50.00,'','Partial Payment',0,NULL,'','M-PESA','0743762767','','','',1,0,1,'MONARCH ',0,0,NULL,NULL),(231,'Innocent Ongeri','cousin','0728678260',NULL,'KMFG861X','GITHURAI KWA NYANYA',1,'PBH5RGT3MD','Samwel',50.00,'','Partial Payment',0,NULL,'','M-PESA','0722532679','','','',1,0,1,'SANLAM GENERAL INSURANCE',0,0,NULL,NULL),(232,'Harrison Njoroge','Brother','0725582928',NULL,'KMFE089A','Nairobi Matt',1,'PBH0RMV4YC','Jotham',50.00,'','Partial Payment',0,NULL,'','M-PESA','0711384640','','','',1,0,1,'BOXER ',1,0,NULL,NULL),(233,'Peter Chege','father','0710589786',NULL,'KMFC565D','GITHURAI MARY MOUNT ',1,'PBI6SOI16','Robert',50.00,'','Partial Payment',0,NULL,'','M-PESA','0702790286','','','',1,0,1,'SANLAM GENERAL INSURANCE ',0,0,NULL,NULL),(234,'susan mercy ','mother','0721932194',NULL,'KMFG957N','GITHURAI 45',1,'PBH0RF4OHC','Eliud Mwangi',50.00,'','Partial Payment',0,NULL,'','M-PESA','0708659255','','','',0,0,1,'NISHATI',1,0,NULL,NULL),(235,'Winnie Awuor','Spouse','0711104660',NULL,'KMEP019U','NAIROBI ',1,'PBG5QZGYMP','Paul',50.00,'','Partial Payment',0,NULL,'','M-PESA','0720856493','','','',1,0,1,'MONARCH',0,0,NULL,NULL),(236,'Regina Wanjiku','Wife','0714738985',NULL,'KMEQ623Z','MUTHURWA',1,'PBF5P3LDXZ','CHARLES ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0746196415','','','',1,0,1,'MONARCH',0,0,NULL,NULL),(237,'Kenneth Gathara ','cousin','0707818011',NULL,'KMEH884R','GPO',1,'PBF4PIFPPQ','MWANGI STEVE',50.00,'','Partial Payment',0,NULL,'','M-PESA','0711896245','','','',1,0,1,'XPLICO INSURANCE',0,0,NULL,NULL),(238,'Susan Muthoni ','Mother','0723671890',NULL,'KMEY780U','GITHURAI 44',1,'PBH0RENPLY','Henry Kanyi',50.00,'','Partial Payment',0,NULL,'','M-PESA','0704118273','','','',1,0,0,'',0,0,NULL,NULL),(239,'Salome','Ngendo','0726136876',NULL,'KMEX322W','GITHURAI ',1,'PBH2RK5IUM','Antony',50.00,'','Partial Payment',0,NULL,'','M-PESA','0729872608','','','',1,0,1,'RWAMBE',0,0,NULL,NULL),(240,'Carolyne Kinyua ','Spouse ','0759273365',NULL,'KMEL523L','Equity 12th Street',1,'PBG4QHGCRG','Isaac Mutuku',50.00,'','Partial Payment',0,NULL,'','M-PESA','0796880136','','','',0,0,1,'MONARCH ',0,1,NULL,NULL),(241,'Rosered Waruguru','Mother','0797368404',NULL,'KMFL 576B','Soweto',1,'PBM2XL11K6','Harrison',5.00,'','Partial Payment',0,NULL,'','M-PESA','0797675168','','','',1,0,1,'Trident',0,0,NULL,NULL),(242,'Jennifer Kavenyi','wife','0726336195',NULL,'KMEW 063X','Buruburu',1,'PBMOXKSJ3C','Isaac',50.00,'','Partial Payment',0,NULL,'','M-PESA','0715655564','','','',1,0,1,'Trident',0,0,NULL,NULL),(243,'Judy orina','wife','0728278319',NULL,'KMEK767W','tajj mall',767,'PBM2XQM8Q2','dennis shake',50.00,'1','Partial Payment',0,NULL,'','M-PESA','0726264558','','','',1,0,1,'Occidental',0,0,NULL,NULL),(244,'aisha','wife','0748168125',NULL,'KMFF 228A','tajj mall',228,'PBM4XRENRK','Ibrahim mwangala',50.00,'1','Partial Payment',0,NULL,'','M-PESA','0723894142','','','',1,0,0,'',0,0,NULL,NULL),(245,'Jedidah morah ombati','sister','0702616573',NULL,'KMFJ555Z','tajj mall',555,'PBM1XU8K91','JEREMIAH OMBATI',50.00,'1','Partial Payment',0,NULL,'','M-PESA','0707306714','','','',1,0,1,'MUUGO',1,0,NULL,NULL),(246,'Deric mbuki','son','0724381065',NULL,'kmds 545r','Tajmall',545,'pbm5xu5cgj','mbuki mwengi',50.00,'1','Partial Payment',0,NULL,'','M-PESA','0724381065','','','',1,0,1,'monarch',0,0,NULL,NULL),(247,'Fred Okumu','Brother','0710204609',NULL,'KMEY 507V','Ngong rd',1,'PBN9YCIVYF','Erick Okumu',50.00,'','Partial Payment',0,NULL,'','M-PESA','0728666962','','','',1,0,1,'Xplico',0,0,NULL,NULL),(248,'Dennis Wesonga','Brother','0716314831',NULL,'KMFE 594E','Kawangware',1,'PBN8YCNJ82','Wesonga',50.00,'','Partial Payment',0,NULL,'','M-PESA','0703100538','','','',1,0,1,'Sanlam General',0,0,NULL,NULL),(249,'Franklin Manyuraga','Son','0716030652',NULL,'KMDS 973V','Hamsa',1,'PBN9YCNIMZ','James',50.00,'','Partial Payment',0,NULL,'','M-PESA','0721597216','','','',1,0,1,'Xplico insurance',0,0,NULL,NULL),(250,'James Manyuraga','Father','0721597216',NULL,'KMFF 018B','Kayole',1,'PBN4YCHZII','Paul Onyango',50.00,'','Partial Payment',0,NULL,'','M-PESA','0728666786','','','',1,0,1,'Xplico',0,0,NULL,NULL),(251,'Roselyn Wairimu ','wife','0727104407',NULL,'KMDF253K','Nairobi ',1,'PBM0XOJXU6','Kelvin',50.00,'','Partial Payment',0,NULL,'','M-PESA','0712675008','','','',1,0,1,'XPLICO',0,0,NULL,NULL),(252,'Dennis Ondeyo ','Brother','0715537867',NULL,'KMFB074x','NAIROBI',1,'PBM8XO0QZC','Jacksom',50.00,'','Partial Payment',0,NULL,'','M-PESA','0746649388','','','',1,0,1,'REIGN COURIER',0,0,NULL,NULL),(253,'Charles Marwa','Brother','0748043402',NULL,'KMFD684N','NAIROBI ',1,'PBM4XR7591','Samuel',50.00,'','Partial Payment',0,NULL,'','M-PESA','0790644284','','','',1,0,1,'SANLAM GENERAL',0,0,NULL,NULL),(254,'Rose Bella','friend','0702751883',NULL,'KMFL127Q','Langata',1,'PBH0RNDJ9E','MATIAS KIPROTICH ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0711549072','','','',1,0,0,'',1,0,NULL,NULL),(255,'Jane Mumbi','friend','0748191203',NULL,'KMFG954W','Langata ',1,'PBJ2TVP51G','JOHN MWANZWII',100.00,'','Partial Payment',0,NULL,'','M-PESA','0712367970','','','',1,0,0,'',0,0,NULL,NULL),(256,'Kennedy','friend','0705947519',NULL,'KMEF216W','LANGATA ',1,'PBH8RHU7GQ','SULEIMAN OSIKUKU ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0702567896','','','',1,0,1,'RWABE',0,0,NULL,NULL),(257,'gob river','friend','0798490201',NULL,'KMFF764L','Kilimani/Mbagathi',1,'PBH0RFQKBQ','Christopher Ochieng',100.00,'','Partial Payment',0,NULL,'','M-PESA','0707435585','','','',1,0,0,'',0,0,NULL,NULL),(258,'Benson simiyu','son','0794991114',NULL,'KMDS 938V','Kawangware',1,'PBN4YCRAZ6','wekesa',50.00,'','Partial Payment',0,NULL,'','M-PESA','0721275564','','','',1,0,1,'Xplico',0,0,NULL,NULL),(259,'Clare Muhenja','sister','0724445423',NULL,'KMEQ 786T','Ngong rd',1,'PBN9YCNCOJ','Joseph Kisundi',50.00,'','Partial Payment',0,NULL,'','M-PESA','0793072467','','','',1,0,1,'Monarch',0,0,NULL,NULL),(260,'Maureen Nekoye','wife','0768732564',NULL,'KMTE 912V','Lavington,ngong rd',1,'PBN6YD19XG','Mulongo',50.00,'','Partial Payment',0,NULL,'','M-PESA','0705146541','','','',1,0,1,'Xplico',0,0,NULL,NULL),(261,'Frank Asila','brother','0705474163',NULL,'KMFF 168A','Ngong Rd',1,'PBN7YCTCZZ','Michael',50.00,'','Partial Payment',0,NULL,'','M-PESA','0710980973','','','',1,0,1,'Sanlam General',0,0,NULL,NULL),(262,'Joshua kwanga','Father','0713768455',NULL,'KMDV 197H','Dagoreti corner',1,'PBN6YCTMR2','Kwanga',50.00,'','Partial Payment',0,NULL,'','M-PESA','0723265813','','','',1,0,1,'Xplico',0,0,NULL,NULL),(263,'Maryanne Kinywa','wife','0743899951',NULL,'KMED 500L','Valley Arcade',1,'PBK7VE6FCJ','Peter',100.00,'','Partial Payment',0,NULL,'','M-PESA','0718216401','','','',1,0,0,'',0,0,NULL,NULL),(264,'Margaret wafula','mother','0703868254',NULL,'KMER 289W','Lavington',1,'PBK2V3T4EG','Isaac',50.00,'','Partial Payment',0,NULL,'','M-PESA','0748988410','','','',1,0,1,'The monarch',0,0,NULL,NULL),(266,'Lonah Okiri ','mother','0723237152',NULL,'KMFC 906A','Ngong rd',1,'PBN8YCX6NK','Ojule',50.00,'','Partial Payment',0,NULL,'','M-PESA','0798718561','','','',1,0,1,'The Monarch',0,0,NULL,NULL),(267,'Franco Wesonga','Friend','0110862878',NULL,'KMEQ 645Q','Kilimani',1,'PBN4YCK91Q','Felix Milimu',50.00,'','Partial Payment',0,NULL,'','M-PESA','0794789542','','','',1,0,1,'Xplico',0,0,NULL,NULL),(268,'Chide Ameria','Daughter','0721649479',NULL,'KMFF 602E','Kasarani',1,'PBN7YDT87V','Alfred',50.00,'','Partial Payment',0,NULL,'','M-PESA','0728788313','','','',0,0,1,'Xplico',0,0,NULL,NULL),(269,'Susan Katanu','wife','0741991903',NULL,'KMEL 275Y','Kilimani,kileleshwa, Lavington',1,'PBKOV8JTSA/PBK2V8EYEQ','Peter',50.00,'','Partial Payment',0,NULL,'','M-PESA','0716010548','','','',1,0,0,'',0,0,NULL,NULL),(270,'Vinny Mutali','Brother','0712136740',NULL,'KMET 268J','Satelitte',1,'PBN7YEV9LD','Lilian',50.00,'','Partial Payment',0,NULL,'','M-PESA','0728809130','','','',1,0,1,'Xplico',0,0,NULL,NULL),(271,'Risper Onyango','Mother','0799123342',NULL,'KMEN 377E','Umojs',1,'PBN9YBT9BN','John',250.00,'','Partial Payment',0,NULL,'','M-PESA','0700359243','','','',1,0,1,'Xplico',0,0,NULL,NULL),(272,'Micheal Gabe','son','0705146660',NULL,'KMEE 051D','Lavington',1,'PBN2YDYCKE','Vinny',50.00,'','Partial Payment',0,NULL,'','M-PESA','0712136740','','','',1,0,1,'XPLICO',0,0,NULL,NULL),(280,'Dennis Mogeni','Brother','0714300776',NULL,'KMFL467R','KAWANGWARE ',1,'PBK0VAYQTK','Vincent',50.00,'','Partial Payment',0,NULL,'','M-PESA','0722485711','','','',1,0,1,'MONARCH ',0,0,NULL,NULL),(281,'Dan Dominion','Uncle','0724604428',NULL,'KMFF 413Y','Ruiru/Githurai',1,'PBP81W9TRK','Dan',50.00,'','Partial Payment',0,NULL,'','M-PESA','0701557580','','','',1,0,1,'The monarch',0,0,NULL,NULL),(297,'Lilian Anyango','Wife','0742814415',NULL,'KMDH 171K','Nairobi CBD',1,'PBQ13PODCJ','4036617',50.00,'001','Partial Payment',0,NULL,'','M-PESA','0742473018','','','',1,0,1,'Kenya alliance',0,0,NULL,NULL),(303,'Irene Wangari','wife','0724971127',NULL,'KMDM 664D','Gachororo',1,'PBD81UUWWI','Ricknel',50.00,'001','Partial Payment',0,NULL,'','M-PESA','0723246587','','','',1,0,0,'',0,0,NULL,NULL),(304,'Jane Muthoni','wife','0706703470',NULL,'KMCV 074Z','Gachororo',1,'PBQ7346HZ7','Ricknel',50.00,'001','Partial Payment',0,NULL,'','M-PESA','0702164072','','','',1,0,0,'',0,0,NULL,NULL),(305,'Gacheru','Father','0724710297',NULL,'KMEF 025R','Mukiriti,Thika',1,'PBQ03CDQ4U','Ricknel',50.00,'001','Partial Payment',0,NULL,'','M-PESA','0717911282','','','',1,0,0,'',0,0,NULL,NULL),(306,'Irene Nabwire','wife','0708715141',NULL,'KMEJ 033P','prison stage,thika',1,'PBQ53ME5AV','Ricknel',50.00,'001','Partial Payment',0,NULL,'','M-PESA','0726735306','','','',1,0,1,'Xplico',0,0,NULL,NULL),(307,'James Rufai','friend','0718603531',NULL,'KMEJ 577J','Prison stage,thika',1,'PBQ13LNNJR','Ricknel',50.00,'001','Partial Payment',0,NULL,'','M-PESA','0704518474','','','',1,0,1,'Xplico',0,0,NULL,NULL),(308,'Samuel Mwangi','Friend','0723023782',NULL,'KMDM 512U','U shop',1,'PBQ63H610M','Ricknel',50.00,'001','Partial Payment',0,NULL,'','M-PESA','0722769262','','','',1,0,0,'',0,0,NULL,NULL),(309,'David Nyamberi','Brother','0796050734',NULL,'KMFD 015P','Thika Stadium',1,'PBQ03EK3Cs','Ricknel',50.00,'001','Partial Payment',0,NULL,'','M-PESA','0711364319','','','',1,0,1,'Sanlam General',0,0,NULL,NULL),(310,'JUDY WAIRIMU','wife','0729518992',NULL,'KMFC 228E','U shop',1,'PBQ23E0HLC','Ricknel',50.00,'001','Partial Payment',0,NULL,'','M-PESA','0729076417','','','',1,0,1,'Trident',0,0,NULL,NULL),(311,'Yasin Osman','Friend','0721424578',NULL,'KMEK 978R','Thika Stadium',1,'PBQ63A605E','Ricknel',50.00,'001','Partial Payment',0,NULL,'','M-PESA','0727789538','','','',1,0,0,'',0,0,NULL,NULL),(312,'Njeri kioi ','mother','0724749736',NULL,'KMFB 872R','Thika Stadium',1,'PBQ039J01G','Ricknel',50.00,'001','Partial Payment',0,NULL,'','M-PESA','0724749736','','','',1,0,0,'',0,0,NULL,NULL),(313,'Victor Njuguna','friend','0715158507',NULL,'KMFE 611V','Thika Stadium ',1,'PBQ638VJSC','Ricknel',50.00,'001','Partial Payment',0,NULL,'','M-PESA','0796546800','','','',1,0,1,'Sanlam General',0,0,NULL,NULL),(314,'Lee karani','friend','0758178242',NULL,'KMFF 788N','Thika Stadium',1,'PBQ538JZ8H','Ricknel',50.00,'001','Partial Payment',0,NULL,'','M-PESA','0713549514','','','',1,0,1,'The monarch',0,0,NULL,NULL),(315,'Eunice Nduku','mother','0723333193',NULL,'KMCX 329G','Gachororo',1,'PBP91X5X57','Ricknel',50.00,'001','Partial Payment',0,NULL,'','M-PESA','0707593172','','','',1,0,1,'Xplico',0,0,NULL,NULL),(318,'Faith Aremba','sister','0705524023',NULL,'KMDC474S','KANGEMI',1,'PBH0RGMZZA','Jason',100.00,'','Partial Payment',0,NULL,'','M-PESA','0794160722','','','',1,0,0,'',0,0,NULL,NULL),(319,'Rachael Afatga','wife','0708089648',NULL,'KMEP069L','KANGEMI ',14,'PBH4RFP9ZI','KENNEDY KEFA',100.00,'','Partial Payment',0,NULL,'','M-PESA','0708213537','','','',1,0,1,'MONARCH ',0,0,NULL,NULL),(320,'Geoffrey Miruka','Brother','0701235529',NULL,'KMFH266G','KANGEMI ',22,'PBH2RDDJJG','Calif Miruka',50.00,'','Partial Payment',0,NULL,'','M-PESA','0714036094','','','',1,0,1,'SANLAM',0,0,NULL,NULL),(321,'Goldwin Omaiko','son','0700000',NULL,'KMEZ201B','KANGEMI ',16,'PBH5RA661VR','Kevin',50.00,'','Partial Payment',0,NULL,'','M-PESA','0746508800','','','',1,0,1,'COMPREHENSIVE ',0,0,NULL,NULL),(322,'lilian ','wife','0111151959',NULL,'KMEW469A','KANGEMI ',20,'PBH6R9HN0Q','Evans',50.00,'','Partial Payment',0,NULL,'','M-PESA','0700267197','','','',1,0,0,'',0,0,NULL,NULL),(323,'badas','brother','0722622478',NULL,'KMEM140R','KAWANGWARE',1,'PBH0RBV3NO','Hudson Kifuve',50.00,'','Partial Payment',0,NULL,'','M-PESA','0746132511','','','',1,0,0,'',0,0,NULL,NULL),(324,'Asha Chanuka','wife','0701037686',NULL,'KMEW365K','KANGEMI ',25,'PBH4RBBV758','David ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0725345699','','','',1,0,0,'',0,0,NULL,NULL),(326,'Everlyn Musyoki','wife ','0725643827',NULL,'KMET798J','Woodley',1,'PBK1VGC8ID','Moses Mutinda ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0727832679','','','',1,0,0,'',0,0,NULL,NULL),(327,'Emily Okelo','wife','0701542867',NULL,'KMEX895W','WOODLEY',1,'PBK5UHIDUY','Richard Okelo',50.00,'','Partial Payment',0,NULL,'','M-PESA','0719873694','','','',1,0,0,'',0,0,NULL,NULL),(328,'Sarah Keruro','sister','0703205775',NULL,'KMET827G','KANGEMI ',1,'PBH3RG9BVT','ROBIN ISOE',50.00,'','Partial Payment',0,NULL,'','M-PESA','0703991691','','','',0,0,0,'',0,0,NULL,NULL),(329,'Rose Chemasa','wife','0706484990',NULL,'KMET305W','KANGEMI ',1,'PBH1RHQRLN','Rose Chemasa',50.00,'','Partial Payment',0,NULL,'','M-PESA','0702333356','','','',1,0,1,'MONARCH ',0,0,NULL,NULL),(330,'Teresa Kwamboka','mum ','0720495569',NULL,'KMFK449D','KANGEMI ',1,'PBH8RGKVOE','Boniface Maina ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0746171511','','','',0,0,0,'',0,0,NULL,NULL),(331,'Gilbert korir','friend','0712086197',NULL,'kmec 058 b','kamutini',9,'pc1379q7t1','japheth',50.00,'','Partial Payment',0,NULL,'','M-PESA','0759644560','','','',1,0,0,'',0,0,NULL,NULL),(333,'Lola Getrude','daughter ','070000',NULL,'kmfg061l','GITHURAI ',1,'PBJ3U8FYBF','Asisi',50.00,'','Partial Payment',0,NULL,'','M-PESA','0796370224','','','',1,0,1,'TVS',1,0,NULL,NULL),(334,'Hildah','wife','0725086662',NULL,'KMDY765G','Kibra',1,'PBK5V7UIAT','Mike',50.00,'','Partial Payment',0,NULL,'','M-PESA','0715649334','','','',1,0,0,'',0,0,NULL,NULL),(335,'Lucy Atieno','child','0700000',NULL,'KMFM947G','Kibera',1,'PBK8V2DEBC','George',50.00,'','Partial Payment',0,NULL,'','M-PESA','0714450106','','','',1,0,1,'SANLAM',0,0,NULL,NULL),(336,'Manjanne Favour','Daughter ','070000',NULL,'KMEZ278K','Kibera ',1,'PBK1V2K4Z9','JEFF',50.00,'','Partial Payment',0,NULL,'','M-PESA','0726123985','','','',1,0,0,'',0,0,NULL,NULL),(337,'Nancy Auma','wife','0714147080',NULL,'KMEL143E','KIBERA ',1,'PBK4V319KS','Lucas',50.00,'','Partial Payment',0,NULL,'','M-PESA','0725747485','','','',1,0,0,'',0,0,NULL,NULL),(338,'agness','mother ','0797063892',NULL,'KMDC435Z','KIBERA',1,'PBK6V4FBAU','Brian',50.00,'','Partial Payment',0,NULL,'','M-PESA','0759687295','','','',0,0,1,'SANLAM',0,0,NULL,NULL),(339,'TeresiaKinyanjui','wife','0703982659',NULL,'KMET369K','Gathurai',1,'PBJ0U23OKA','Philip',50.00,'','Partial Payment',0,NULL,'','M-PESA','0746865597','','','',1,0,0,'',0,0,NULL,NULL),(340,'josphat','father ','0723030139',NULL,'KMDJ536U','Roasters',1,'PBM3XC80CD','Isaac',50.00,'','Partial Payment',0,NULL,'','M-PESA','0746622887','','','',1,0,0,'',0,0,NULL,NULL),(341,'wanjiru','wife','0798602099',NULL,'KMFK201N','MATHARE',1,'PBM1XSKE8A','Jambas',50.00,'','Partial Payment',0,NULL,'','M-PESA','0745691773','','','',1,0,1,'SANLAM',0,0,NULL,NULL),(342,'maureen','wife','0736572523',NULL,'KMEB069M','MATHARE ',31,'PBM1XE5FID','Charlse',50.00,'','Partial Payment',0,NULL,'','M-PESA','0722111410','','','',1,0,0,'',0,0,NULL,NULL),(343,'mercy mutongoi musee','wife','0759136904',NULL,'kmew 158w','westland',158,'','Obadiah maina',50.00,'','Partial Payment',0,NULL,'','M-PESA','0758594667','','','',1,0,0,'',0,0,NULL,NULL),(344,'Charles Gachoke','brother','0722111410',NULL,'KMEP501A','mathare',42,'PBM3XEBL8V','AXEGUN',50.00,'','Partial Payment',0,NULL,'','M-PESA','0713303599','','','',1,0,1,'Rwabe',0,0,NULL,NULL),(345,'jane njeri','wife ','0723702643',NULL,'KMET877T','MATHARE ',25,'PBM7XEOC2R','Ndungu',50.00,'','Partial Payment',0,NULL,'','M-PESA','0721724923','','','',1,0,1,'XPLICO ',0,0,NULL,NULL),(346,'Aidah','wife ','0713874837',NULL,'KMDP606F','SURVEY ',3,'PBM4X9ZZDO','Benard',50.00,'','Partial Payment',0,NULL,'','M-PESA','0726498587','','','',1,0,1,'MONARCH ',0,0,NULL,NULL),(347,'Divina Bochaberi','wife','0713807617',NULL,'KMFF560L','Huruma/Nairobi',1,'PBL7WPBR8J','Nyabiba Isaac',50.00,'','Partial Payment',0,NULL,'','M-PESA','0723091196','','','',0,0,1,'SANLAM',1,1,NULL,NULL),(348,'immaculatekwamboka','wife','0727882783',NULL,'KMFK211L','MATHARE ',1,'PBM5XJ31BB','PHILIP',50.00,'','Partial Payment',0,NULL,'','M-PESA','0728720886','','','',0,0,1,'MOGO LTD',1,1,NULL,NULL),(349,'Christine Bosibori','wife','0706211602',NULL,'KMFL967L','MATHARE ',1,'PBM8X1PV11','Domonic Ogure',50.00,'','Partial Payment',0,NULL,'','M-PESA','0727225191','','','',0,0,1,'MOGO LTD ',1,1,NULL,NULL),(350,'Ngithi','sister','0727302026',NULL,'KMFE282L','HURUMA ',1,'PBM0XJ92A2','Muriithi',50.00,'','Partial Payment',0,NULL,'','M-PESA','0725126352','','','',1,0,1,'MONARCH ',0,0,NULL,NULL),(351,'Nancy','wife','0790733557',NULL,'KMFD988Y','Alsopps',1,'PBM3XGDMIV','JOJI',50.00,'','Partial Payment',0,NULL,'','M-PESA','0721225405','','','',1,0,1,'SANLAM',1,0,NULL,NULL),(352,'Jonathan Mutua','Brother ','0722311337',NULL,'KMEE890V','HURUMA ',1,'PBL8WOIZQ8','KENNEDY',50.00,'','Partial Payment',0,NULL,'','M-PESA','0724677471','','','',1,0,0,'',0,0,NULL,NULL),(353,'rosemary awori','wofe','0711789155',NULL,'KMFG566W','KIBRA',1,'PBK2V3LXG','Julius Mwangla',50.00,'','Partial Payment',0,NULL,'','M-PESA','0746170955','','','',0,0,0,'',0,0,NULL,NULL),(354,'Jane Atieno ','wife','0706751920',NULL,'KMET992A','Ngara and CBD',1,'PBJ4TZJUGA','GODFREY ODHIAMBO',50.00,'','Partial Payment',0,NULL,'','M-PESA','0723869368','','','',1,0,1,'MONARCH ',0,0,NULL,NULL),(355,'Beatrice Odhiambo','wife','0702540628',NULL,'KMFM624E','KIBRA',1,'PBK5V437ZZ','MATIBA',50.00,'','Partial Payment',0,NULL,'','M-PESA','0704453758','','','',0,0,1,'MONARCH ',0,0,NULL,NULL),(356,'Belinda Atieno ','wife','0749930987',NULL,'KMEP244J','kibera',1,'PBK7VDL9PN','NICHOLAS ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0729006508','','','',1,0,1,'MONARCH ',1,0,NULL,NULL),(357,'Faith Wanza','wife','0710638139',NULL,'KMFG077G','Nairobi ',1,'PBK7VENN9H','Gilbert Orina',50.00,'','Partial Payment',0,NULL,'','M-PESA','0727703382','','','',0,0,1,'SANLAM',1,1,NULL,NULL),(358,'Emily Inmiza','wife','0758088415',NULL,'KMDW177F','KIBERA',1,'PBK8VCEGOG','DAVID BEMBE',50.00,'','Partial Payment',0,NULL,'','M-PESA','0710590354','','','',1,0,1,'OCCIDENTAL',0,0,NULL,NULL),(359,'xxxxx','xxxxxx','070000',NULL,'KMEP037H','KIBERA',1,'PBK8V7NZYI','IBRAHIM TWEB',50.00,'','Partial Payment',0,NULL,'','M-PESA','0794753236','','','',0,0,0,'',0,0,NULL,NULL),(360,'Idris Ali','Friend','0710931253',NULL,'KMEE269H','KIBERA',1,'PBK1V3REMJ','HUSSEIN ALI',50.00,'','Partial Payment',0,NULL,'','M-PESA','0729872770','','','',1,0,1,'MADISON ',0,0,NULL,NULL),(361,'Vyonner Waseka','friend','0726165670',NULL,'KMFF755L','kibera',1,'PBK5B3DH47','IDRIS ALI',50.00,'','Partial Payment',0,NULL,'','M-PESA','0710931253','','','',0,0,1,'MADISON ',1,1,NULL,NULL),(362,'xxxxx','xxxxx','070000',NULL,'KMFA399S','KIBERA',1,'PBK0V403HK','John Sese',50.00,'','Partial Payment',0,NULL,'','M-PESA','0701256844','','','',0,0,0,'',0,0,NULL,NULL),(363,'xxxxx','xxxxx','0700000',NULL,'KMDM334R','KIBERA ',1,'PBK6VCTC08','Elihah Khakau',50.00,'','Partial Payment',0,NULL,'','M-PESA','0712815494','','','',1,0,0,'',0,0,NULL,NULL),(364,'Mercy Chesoli','wife','0702863925',NULL,'KMEA 679B','Kilimani, Lavington',1,'PC1671Z1EQ','Mourice',50.00,'001','Partial Payment',0,NULL,'','M-PESA','0713481296','','','',1,0,1,'The Monarch',0,0,NULL,NULL),(365,'Acrinah Kimeu','wife','0724122883',NULL,'KMFE573L','KIRINYAGA ROAD',1,'PBJ4UNDIYS','Shilisia Muhatia',50.00,'','Partial Payment',0,NULL,'','M-PESA','0723737074','','','',1,0,0,'',0,0,NULL,NULL),(366,'Ngororo Wambui ','Friend','0701641909',NULL,'KMFF662U','KIRINYAGA ROAD ',1,'PBJ9UN36WZ','ZaberiNdegwa',50.00,'','Partial Payment',0,NULL,'','M-PESA','0742765487','','','',1,0,0,'',0,0,NULL,NULL),(367,'Margaret Njeri','wife','0740535718',NULL,'KMFF306F','GITHURAI 45',1,'PBJ5UMXMCL','JAMES IRONJO',50.00,'','Partial Payment',0,NULL,'','M-PESA','0741050436','','','',1,0,0,'',1,0,NULL,NULL),(368,'Peter Mwangi','brother ','0727767289',NULL,'KMEL398E','ROUND ABOUT',1,'PBJ2UNOYR8','simon kiragu ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0727767289','','','',1,0,0,'',0,0,NULL,NULL),(369,'Julius David','brother','0712628840',NULL,'KMEQ235V','Amboseli ',6,'PBK6VAOJZM','JACOB',50.00,'','Partial Payment',0,NULL,'','M-PESA','0740442453','','','',1,0,1,'OCCIDENTAL ',0,0,NULL,NULL),(370,'Nancy Njeri','wife','0795197420',NULL,'KMER746M','Mayas',19,'PBK5UZKHD','Martin',50.00,'','Partial Payment',0,NULL,'','M-PESA','0716746050','','','',0,0,1,'MONARCH',0,0,NULL,NULL),(371,'Sibia Moraa','wife','0707881414',NULL,'KMCZ226G','Kawangware 46',1,'PBK1V1HCBT','Eric',50.00,'','Partial Payment',0,NULL,'','M-PESA','0757832500','','','',0,0,0,'',0,0,NULL,NULL),(372,'Paul Marigi','friend','0741736844',NULL,'KMFL673R','Red Carpet',1,'PBK8V4RY48','Fidel',50.00,'','Partial Payment',0,NULL,'','M-PESA','0795868925','','','',1,0,1,'SANLAM',1,0,NULL,NULL),(373,'Peris Mandere','wife','0702415079',NULL,'KMET117Q','Peponi Stage',1,'PBK9V74YIZ','James',50.00,'','Partial Payment',0,NULL,'','M-PESA','0721168121','','','',1,0,1,'SANLAM',1,0,NULL,NULL),(374,'Topistar Baraza','wife','0703206293',NULL,'KMFG719U','56',48,'PBK2V8UORQ','Moses',50.00,'','Partial Payment',0,NULL,'','M-PESA','0713617580','','','',1,0,1,'SANLAM ',0,0,NULL,NULL),(375,'Alice Njeri','Mother ','0727941540',NULL,'KMEY058P','WITEITHIE STAGE ',9636,'PBJ2U912E6','James',50.00,'','Partial Payment',0,NULL,'','M-PESA','0708679101','','','',1,0,0,'',0,0,NULL,NULL),(376,'Mark Onchari','brother','0743036549',NULL,'KMFB793G','WITEITHIE STAGE ',4528,'PBJ0OU5PTGU','Gibson ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0705382125','','','',1,0,1,'SANLAM',1,0,NULL,NULL),(377,'Simon Mburu ','brother','0701268232',NULL,'KMFE110W','Engen Thika',4,'PBJ7ITSG1R','Thomas',50.00,'','Partial Payment',0,NULL,'','M-PESA','0748700347','','','',1,0,0,'',0,0,NULL,NULL),(378,'Leah Nyambura ','wife','0715152369',NULL,'KMFD108E','ENGEN THIKA',16,'PBJ0PUKKXI','Rueben',50.00,'','Partial Payment',0,NULL,'','M-PESA','0728517588','','','',1,0,0,'',0,0,NULL,NULL),(379,'Immaculate max ','wife','0740243684',NULL,'KMDS478F','POSTA MAKONGENI',22,'PBK3VCR2DN','HASSAN',50.00,'','Partial Payment',0,NULL,'','M-PESA','0740243684','','','',1,0,0,'',0,0,NULL,NULL),(380,'jackline kathambi','wife','0793938297',NULL,'KMFC739L ','POSTA MAKONGENI',49,'PBK4V80V50','John ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0759116582','','','',1,0,1,'SANLAM',1,0,NULL,NULL),(381,'Rachael Waithera','mum','0712127648',NULL,'KMFC982Q','POSTA MAKONGENI ',5,'PBK4V7U9WK','PHILIP',50.00,'','Partial Payment',0,NULL,'','M-PESA','0717843770','','','',1,0,1,'SANLAM ',0,0,NULL,NULL),(382,'Joyce Wanjiru ','mum','0725856744',NULL,'KMEU154C','ENGEN THIKA',11,'PBK6V3K4MG','John ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0746257870','','','',1,0,0,'',0,0,NULL,NULL),(383,'Abdala Tambwe','brother','0727760908',NULL,'KMEF582U','POLYSAK MAKONGENI',4,'PBJU6HL85','Ali',50.00,'','Partial Payment',0,NULL,'','M-PESA','0714854676','','','',1,0,1,'XPLICO ',0,0,NULL,NULL),(384,'Edwin Ochieng','Cousin','0705209847',NULL,'KMEE065N','MAKONGENI THIKA',32,'PBJ8U55MGK','STEPHEN',50.00,'','Partial Payment',0,NULL,'','M-PESA','0705383931','','','',1,0,1,'TRIDENT ',0,0,NULL,NULL),(385,'Peter Kamau ','friend ','0729004021',NULL,'KMDX907Q','UTI - TOWN SERVICE ',1,'PBJ1U869C1','SIMON',50.00,'','Partial Payment',0,NULL,'','M-PESA','0711474930','','','',0,0,1,'XPLICO ',0,0,NULL,NULL),(386,'Muthama Munyau','brother ','0700000',NULL,'KMDX 903G','ENGEN THIKA ',28,'PBJ2U5MO88','SAMMY ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0745545528','','','',1,0,1,'SANLAM',0,0,NULL,NULL),(387,'John Chege','father ','0720483106',NULL,'KMFE573E','ENGEN THIKA ',10,'PBJ2TVEE3Q','Laban',50.00,'','Partial Payment',0,NULL,'','M-PESA','0702224290','','','',1,0,0,'',0,0,NULL,NULL),(388,'Josephine Haron','wife','0704477531',NULL,'KMDQ879Y','MAKONGENI',39,'PBJ5U2D74T','HARON KASONZO ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0717896092','','','',1,0,0,'',0,0,NULL,NULL),(389,'Mary Wayua','wife','0717169102',NULL,'KMEW276B','POLYSACK MAKONGENI ',23,'PBJ5U3DYKZ','JOHN',50.00,'','Partial Payment',0,NULL,'','M-PESA','0714350543','','','',0,0,1,'TRIDENT ',0,0,NULL,NULL),(390,'Mwangi ','uncle','0721781255',NULL,'KMFH733M','Engen Gretsa University',27,'PBJ7TX1TBT','KELVIN',50.00,'','Partial Payment',0,NULL,'','M-PESA','0723906029','','','',1,0,1,'SANLAM',1,0,NULL,NULL),(391,'Irene Karimi','wife ','0790289599',NULL,'KMEZ353Q','ENGEN GRETSA UNIVERSITY ',2,'PBJ9TZ3ZPR','HARON',50.00,'','Partial Payment',0,NULL,'','M-PESA','0706330800','','','',1,0,1,'MONARCH ',0,0,NULL,NULL),(392,'Agnes Waithera','Sister','0725014278',NULL,'KMDY280G','ENGEN GRETSA UNIVERSITY ',14,'PBJ0UO5S7U','DANIEL ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0721839952','','','',1,0,1,'MONARCH ',0,0,NULL,NULL),(393,'John Kuria ','brother ','0723681618',NULL,'KMFC364B','HIGH RISE',1,'PBL0WW6IIY','David ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0705973811','','','',1,0,1,'MONARCH',0,0,NULL,NULL),(394,'Joseph','Cousin ','0702174487',NULL,'KMFG048A','KARIOBANGI MARKET ',1,'PBM8XA6LY4','John',50.00,'','Partial Payment',0,NULL,'','M-PESA','0721934056','','','',1,0,1,'SANLAM ',0,0,NULL,NULL),(395,'Faith Patient','wife','0748634448',NULL,'KMFL054R','MOLEM PHEROSE',1,'PBL9WZQTNJ','ERICK ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0724079749','','','',1,0,1,'MONARCH ',0,0,NULL,NULL),(396,'Larry Kayson','son','0700000',NULL,'KMFJ311K','kariobangi North ',1,'PBM5XCCA3P','KEVIN',50.00,'','Partial Payment',0,NULL,'','M-PESA','0704004232','','','',1,0,1,'APA INSURANCE ',1,0,NULL,NULL),(397,'Joyce mukami','Sister ','0714611426',NULL,'KMDS028D ','KAWANGWARE MAYAS',1,'PBK3UZDAV9','SIMON',50.00,'','Partial Payment',0,NULL,'','M-PESA','0758574768','','','',0,0,1,'XPLICO',0,0,NULL,NULL),(398,'Nicodemus Khavochi','father','0725671130',NULL,'KMFK506A','KAWANGWARE 46',1,'PBK5V509SV','MICHAEL',50.00,'','Partial Payment',0,NULL,'','M-PESA','0796450729','','','',1,0,0,'',0,0,NULL,NULL),(399,'Oscar Shikundi','brother','0723959343',NULL,'KMFF312T','KAWANGWARE 46',1,'PBK2V5OTHG','NICHOLAS',50.00,'','Partial Payment',0,NULL,'','M-PESA','0705573269','','','',0,0,1,'MONARCH',0,0,NULL,NULL),(400,'Godfrey Oyalo ','son','0712999690',NULL,'KMFN160H','KAWANGWARE 46',1,'PBK9V1CTC9','ADRIANO',50.00,'','Partial Payment',0,NULL,'','M-PESA','0702383754','','','',0,0,1,'SANLAM ',1,1,NULL,NULL),(401,'Dismas Boera','friend ','0790946829',NULL,'KMFJ376V','KAWANGWARE MBUFA',1,'PBK1V7R6OB','CHRISTOPHER ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0723775966','','','',1,0,0,'',0,0,NULL,NULL),(402,'Veronica Kamau','wife','0706975864',NULL,'KMEX897X','KAWANGWARE, Genesis ',1,'PBK4V964H2','NICHOLAS ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0728465561','','','',1,0,0,'',0,0,NULL,NULL),(403,'Mercy Jendeka','wife ','0701126571',NULL,'KMEY399N','junction mall',1,'PBK4VALSCA','MACMILLAN ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0768271284','','','',1,0,1,'MONARCH ',0,0,NULL,NULL),(404,'Evalyne Mugo','wife','0797197039',NULL,'KMFM427G','KOROKOCHO MARKET ',46,'PBM8XS4UKI','RICHARD ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0757643424','','','',1,0,1,'XPLICO',0,0,NULL,NULL),(405,'Jacinta Cynthia','friend','0716476966',NULL,'KMEZ284K','KISUMU NDOGO',3,'PBM7XOKXCP','GEOFREY',50.00,'','Partial Payment',0,NULL,'','M-PESA','0114596474','','','',1,0,1,'MONARCH ',0,0,NULL,NULL),(406,'Joyce Wanjiku ','wife','0799455431',NULL,'KMEY342Q','Mutindwa',5,'PBM8XQSL6E','SIMON ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0797245973','','','',1,0,0,'',1,0,NULL,NULL),(407,'Alfayo musalia','brother ','0701648748',NULL,'KMEY038Q','KOROKOCHO MARKET',92,'PBM7XK72WD','MUSALIA',50.00,'','Partial Payment',0,NULL,'','M-PESA','0701161453','','','',1,0,1,'MONARCH ',0,0,NULL,NULL),(408,'Margaret Wanjiru ','mother','0714727648',NULL,'KMFM307G','KOROKOCHO MARKET',1,'PBM5XILHWJ','Francis ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0716562654','','','',1,0,0,'',0,0,NULL,NULL),(409,'Mercyline Adhiambo','sister ','0715242189',NULL,'KMEX306H','KOROKOCHO MARKET',1,'PNM3XKY5SX','EMMANUEL',50.00,'','Partial Payment',0,NULL,'','M-PESA','0792762573','','','',1,0,0,'',0,0,NULL,NULL),(410,'Francis Karanja ','father ','0710822106',NULL,'KMFH142W','KOROKOCHO MARKET',6,'PBM2XCLD6M','ZACHARIAH',50.00,'','Partial Payment',0,NULL,'','M-PESA','0711957566','','','',1,0,1,'PENTAGON',0,0,NULL,NULL),(411,'Beatrice Nyaboke','wife ','0701256560',NULL,'KMEM270M','KISUMU NDOGO',1,'PBM6XP5Q8E','MARCUS ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0758588975','','','',1,0,1,'MONARCH ',0,0,NULL,NULL),(412,'Fridah Wanja','wife','0703207226',NULL,'KMDM373Y','SUPALOAF',1,'PBM6XB500I','David ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0724801942','','','',1,0,1,'TRIDENT ',0,0,NULL,NULL),(413,'Deborah Bosibori','wife','0743925010',NULL,'KMES936M','KOROKOCHO MARKET',203,'PBM2XJ9FD8','LYDON',50.00,'','Partial Payment',0,NULL,'','M-PESA','0792561652','','','',1,0,1,'MONARCH ',0,0,NULL,NULL),(414,'Lucy Wanjiru ','mother','0723795842',NULL,'KMEN577Q','KOROKOCHO MARKET',1,'PBM0XMP8PM','JOSEPH ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0716612239','','','',1,0,0,'',0,0,NULL,NULL),(415,'Musembi','Friend','0752775274',NULL,'KMEV374Z','KOROKOCHO MARKET',1,'PBM7EGTXA','Justin',50.00,'','Partial Payment',0,NULL,'','M-PESA','0795628763','','','',0,0,0,'',0,0,NULL,NULL),(416,'Nancy Chepkiroi','wife','0716429837',NULL,'KMEL745L','KOROKOCHO MARKET',171,'PBM0XHAF00','PETER',50.00,'','Partial Payment',0,NULL,'','M-PESA','0713406348','','','',1,0,0,'',0,0,NULL,NULL),(417,'Ken Omondi','friend','0711509000',NULL,'KMFJ048V','KOROKOCHO MARKET',1,'PBM5XJ7584','MOSES',50.00,'','Partial Payment',0,NULL,'','M-PESA','0714428240','','','',1,0,1,'GA INSURANCE',0,0,NULL,NULL),(418,'Sylvus','Father ','0722887459',NULL,'KMFC572C','KOROKOCHO MARKET',1,'PBM1XK2J07','KENNEDY',50.00,'','Partial Payment',0,NULL,'','M-PESA','0711509000','','','',1,0,1,'GA INSURANCE ',0,0,NULL,NULL),(419,'KENNEDY OCHIENG ','friend ','0711509000',NULL,'KMFG367D','KOROKOCHO MARKET  (KISUMU NDOGO)',1,'PBM4XOTPMQ','KENNEDY ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0751518429','','','',1,0,1,'SANLAM',0,0,NULL,NULL),(420,'Elizabeth Wanjiku ','Aunt','01113155961',NULL,'KMFL770H','Juja',5297,'PBN8YJ1W48','JAMES ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0717606446','','','',1,0,0,'',0,0,NULL,NULL),(421,'Alice Nata Tocho','wife','0715062096',NULL,'KMEL340S','FINE BREEZE',392,'PBN1YPWHLE','ROBERT',50.00,'','Partial Payment',0,NULL,'','M-PESA','0721205871','','','',1,0,0,'',0,0,NULL,NULL),(422,'Grace Nasimolo','wife ','0793579348',NULL,'KMEZ679L','JUJA',21,'PBN2Y0T35W','COLLINS',50.00,'','Partial Payment',0,NULL,'','M-PESA','0792299619','','','',1,0,0,'',0,0,NULL,NULL),(423,'Wilson Muchiri','brother','0718725656',NULL,'KMFH132X','BURUDANI',1,'PBN8YLD6ZE','IAN',50.00,'','Partial Payment',0,NULL,'','M-PESA','0741299023','','','',1,0,1,'SANLAM ',0,0,NULL,NULL),(424,'Pern Waithera','sister','0725714002',NULL,'KMFM461H','Corner Stage',1,'PBN7YKOECD','TIMOTHY ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0741493646','','','',0,0,1,'SANLAM',1,0,NULL,NULL),(425,'Vanessa Nkatha','Wife','0706063576',NULL,'KMFD438E','Salama',3654,'PBH0YR2066','SAMUEL',50.00,'','Partial Payment',0,NULL,'','M-PESA','0768063614','','','',1,0,1,'MONARCH ',0,0,NULL,NULL),(426,'Samuel ','friend ','0768063614',NULL,'KMFC938Q','SALAMA',4,'PBN47S4VIE','REMINGTON ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0757621971','','','',0,0,1,'MONARCH ',0,0,NULL,NULL),(427,'Margaret Njeri','wife','0790550648',NULL,'KMFF220T','JUJA',257,'PBN8YPTZIY','SIMON',50.00,'','Partial Payment',0,NULL,'','M-PESA','0705457025','','','',0,0,1,'SANLAM GENERAL ',0,0,NULL,NULL),(428,'thuo','friend','0726741141',NULL,'KMER691G','JUJA',3589,'PBN2YMIXBO','MICHAEL ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0111565204','','','',1,0,0,'',0,0,NULL,NULL),(429,'Agnes Wairimu ','wife','0794925881',NULL,'KMFC087A','JUJA ',4145,'PBN5YM1ZPX','DENNIS',50.00,'','Partial Payment',0,NULL,'','M-PESA','0791728046','','','',1,0,0,'',0,0,NULL,NULL),(430,'olypher','wife','0704456330',NULL,'KMFK813A','JUJA',9708,'PBN2YKM85S','DENNIS',50.00,'','Partial Payment',0,NULL,'','M-PESA','0725818625','','','',1,0,1,'SANLAM GENERAL ',0,0,NULL,NULL),(431,'Caroline Njambi','wife','0724919021',NULL,'KMDF322V','JUJA',3581,'PBN3YJP21F','JOSEPH ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0712523999','','','',1,0,0,'',0,0,NULL,NULL),(432,'Ruth Wanjiku','wife','07000000',NULL,'KMEY353C','JUJA',145,'PBN7YIPG13','Thomas Kilomo',50.00,'','Partial Payment',0,NULL,'','M-PESA','0700173182','','','',1,0,0,'',0,0,NULL,NULL),(434,'Rose Wanjiru ','mother','0715916645',NULL,'KMFC908V','JUJA',1150,'PBN6YI1GX4','MORRIS',50.00,'','Partial Payment',0,NULL,'','M-PESA','0700881713','','','',1,0,0,'',0,0,NULL,NULL),(435,'Teresia Wanjiru ','wife ','0745551620',NULL,'KMEW510S','JUJA ',1352,'PBN2YHIDTI','Francis',50.00,'','Partial Payment',0,NULL,'','M-PESA','0706631921','','','',1,0,0,'',0,0,NULL,NULL),(436,'ScolasticaJuma','sister','0741682158',NULL,'KMFH588M','TUMAINI',1,'PBP52BKPVB','Fredrick ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0741116641','','','',1,0,1,'GA INSURANCE ',0,0,NULL,NULL),(437,'Julius Mbiu','friend','0714934041',NULL,'KMCR092M','ELNINO',4,'PBP6281K2Q','John ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0729327902','','','',0,0,0,'',0,0,NULL,NULL),(438,'John Muthee','friend','0729327902',NULL,'KMDN597F','ELNINO',8,'PBP428FKOK','JULIUS ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0714934041','','','',1,0,0,'',0,0,NULL,NULL),(439,'Caroline Maina','wife ','0702965391',NULL,'KMEH662T','TOWNSHIP 2 TKY',91,'PBP520PSBJ','GIDEON',50.00,'','Partial Payment',0,NULL,'','M-PESA','0721121805','','','',1,0,1,'TRIDENT',0,0,NULL,NULL),(441,'Nancy Wairimu ','wife','0717387103',NULL,'KMFB032N','TOWNSHIP 2 TKY',109,'PBP320IQ9F','DANIEL',50.00,'','Partial Payment',0,NULL,'','M-PESA','0715430809','','','',1,0,0,'',0,0,NULL,NULL),(442,'Rosemary Wacera','wife','0726661905',NULL,'KMEM227U','TOWNSHIP 2 TKY',15,'PBP41Z561G','PATRICK',50.00,'','Partial Payment',0,NULL,'','M-PESA','0720216874','','','',1,0,0,'',0,0,NULL,NULL),(443,'xxxxx','xxxxx','0700000',NULL,'KMES604M','TOWNSHIP 2 TKY',76,'PBP31ZKA2P','SAMSON',50.00,'','Partial Payment',0,NULL,'','M-PESA','0708920059','','','',1,0,0,'',0,0,NULL,NULL),(444,'Teresia Muthoni','sister','0751290717',NULL,'KMES240A','TOWNSHIP 2 TKY',120,'PBP61ZJTO8','DOMISIANO',50.00,'','Partial Payment',0,NULL,'','M-PESA','0759647285','','','',1,0,0,'',0,0,NULL,NULL),(445,'Anastasia','mother ','0742131266',NULL,'KMDS094N','CORNER STAGE',21002,'PBO824NCHA','TITUS',50.00,'','Partial Payment',0,NULL,'','M-PESA','0799096725','','','',1,0,0,'',0,0,NULL,NULL),(446,'Shantel Weru','daughter','0713800515',NULL,'KMFH809B','PAWA',284,'PBP422457Q','CHARLES',50.00,'','Partial Payment',0,NULL,'','M-PESA','0713800515','','','',1,0,1,'MONARCH ',0,0,NULL,NULL),(447,'Joyce Wanjiku ','wife','0715277331',NULL,'KMDA559C','POWER/PRIME',1,'PBP7215V5X','PETER',50.00,'','Partial Payment',0,NULL,'','M-PESA','0726691405','','','',1,0,0,'',0,0,NULL,NULL),(448,'Abel','brother','0719705751',NULL,'KMEH909V','OXFORD ',1,'PBP91XRF49','JOSIAH',50.00,'','Partial Payment',0,NULL,'','M-PESA','0769231118','','','',1,0,1,'ARMACO',0,0,NULL,NULL),(449,'freshia Muthoni ','wife','0708903789',NULL,'KMES246J','OXFORD',207,'PBP6IVVVN4','JAMES',50.00,'','Partial Payment',0,NULL,'','M-PESA','0726761451','','','',1,0,1,'XPLICO',0,0,NULL,NULL),(451,'Harrison Ndirangu','friend','0723515326',NULL,'KMDA 012J','Buspark, makongeni',1,'PC319NRXSV','Kinuva',50.00,'001','Partial Payment',0,NULL,'','M-PESA','0717040545','','','',1,0,0,'',0,0,NULL,NULL),(452,'Paul kinuva','Friend','0717040545',NULL,'KMEH 858C','Buspark makongeni',1,'PC3490OJJY','Harrison',50.00,'001','Partial Payment',0,NULL,'','M-PESA','0700936771','','','',1,0,1,'Xplico',0,0,NULL,NULL),(454,'Wilson Macharia','brother','0701399818',NULL,'KMDA 386M','Kiganjo',1,'PC309XQC1E','Dennis Muthukia',50.00,'001','Partial Payment',0,NULL,'','M-PESA','0728001190','','','',1,0,1,'Xplico',0,0,NULL,NULL),(461,'John Njuguna','friend','0710907768',NULL,'KMFD 068V','Kangangu,kenol',1,'PC43B2IHJL','Fredrick',50.00,'001','Partial Payment',0,NULL,'','M-PESA','0790780955','','','',1,0,0,'',0,0,NULL,NULL),(462,'Mary Wanjiku','spouse','0754268648',NULL,'KMFH 143U','Kabati',1,'PC48B99VDU','James',50.00,'001','Partial Payment',0,NULL,'','M-PESA','0712670840','','','',1,0,1,'The Monarch',0,0,NULL,NULL),(463,'Alice Wanjiku','Mother','0715940014',NULL,'KMFL 918C','Kabati',1,'PC49BAK71P','Antony',50.00,'001','Partial Payment',0,NULL,'','M-PESA','0797094307','','','',1,0,0,'',0,0,NULL,NULL),(464,'Purity Muthoni','spouse','0111706852',NULL,'KMEE 648C','Kabati',1,'PC40BCEAP8','Henry',50.00,'001','Partial Payment',0,NULL,'','M-PESA','0792754481','','','',1,0,0,'',0,0,NULL,NULL),(465,'Joan Njeri','mother','071165772',NULL,'KMDT 749S','Juja,Thriller',1,'PC47BHA3YH','peter',50.00,'001','Partial Payment',0,NULL,'','M-PESA','0720472168','','','',1,0,0,'',0,0,NULL,NULL),(467,'Ann waithera','spouse','0719686242',NULL,'KMFD 631V','JKUAT',1,'PC58C7320E','Laban',50.00,'001','Partial Payment',0,NULL,'','M-PESA','070511906','','','',1,0,1,'The monarch',0,0,NULL,NULL),(468,'Alice Kanuthu','Mother','0710346463',NULL,'KMEV 402B','JKUAT',1,'PC56C7KLLO','James',50.00,'001','Partial Payment',0,NULL,'','M-PESA','0746636162','','','',1,0,0,'',0,0,NULL,NULL),(469,'Paul kimani','dad','0725779730',NULL,'KMFB661E','JKUAT',1,'PC56C60LV2','Peter',50.00,'001','Partial Payment',0,NULL,'','M-PESA','0729824821','','','',1,0,0,'',0,0,NULL,NULL),(470,'Naomi Nduku','Spouse','0720977457',NULL,'KMEY334G','JKUAT',1,'PC50C6VOYM','Onesmas',50.00,'001','Partial Payment',0,NULL,'','M-PESA','0720831399','','','',1,0,0,'',0,0,NULL,NULL),(471,'Edwin Kayanda','friend','074649827',NULL,'KMDD 459M','Petpa,juja',1,'PC52CNPQUQ','Kellen',50.00,'001','Partial Payment',0,NULL,'','M-PESA','0718281656','','','',1,0,0,'',0,0,NULL,NULL),(472,'Jane Achieng','spouse','0708336597',NULL,'KMDV 343H','Gate C,JKUAT',1,'PC57CPZ3LB','Robert',50.00,'001','Partial Payment',0,NULL,'','M-PESA','0705005275','','','',1,0,0,'',0,0,NULL,NULL),(473,'Divina Naika','Spouse','0708155776',NULL,'KMFM 217D','Gate C,JKUAT',1,'PC52CQ0068','Alex',50.00,'001','Partial Payment',0,NULL,'','M-PESA','0714488598','','','',1,0,0,'',0,0,NULL,NULL),(474,'Florence kageni','Spouse','0762864313',NULL,'KMFF 915N','Gate c,Jkuat',1,'PC55RCQA69','Jonathan',50.00,'001','Partial Payment',0,NULL,'','M-PESA','0707257168','','','',0,0,0,'',0,0,NULL,NULL),(475,'Carol mwoi','sister','0724797272',NULL,'KMEH 415U','Kirigiti',1,'PC68DHQFAM','George',50.00,'001','Partial Payment',0,NULL,'','M-PESA','0799385953','','','',0,0,0,'',0,0,NULL,NULL),(479,'Margaret Waithera','Wife','0723569983',NULL,'KMEY887D','RUIRU RAINBOW RESORT',102,'PC12775710','Danson',50.00,'','Partial Payment',0,NULL,'','M-PESA','0715474354','','','',1,0,1,'MONARCH',0,0,NULL,NULL),(480,'Gathirimu','Father','0724486206',NULL,'KMEW722V','Ruiru Rainbow',1,'PCI277UXEG','John',50.00,'','Partial Payment',0,NULL,'','M-PESA','0720202585','','','',1,0,0,'',0,0,NULL,NULL),(481,'Nduta','Mother','0718376964',NULL,'KMFC620M','Ruiru Posta',158,'PCI77C97VB','John',50.00,'','Partial Payment',0,NULL,'','M-PESA','0705797959','','','',1,0,0,'',0,0,NULL,NULL),(482,'Beatrice Okech','Wife','0742928022',NULL,'KMFA222A','Ruiru Posta',208,'PC117HA30J','GEOFFREY',50.00,'','Partial Payment',0,NULL,'','M-PESA','0725621535','','','',1,0,0,'',0,0,NULL,NULL),(483,'Joyce Wanjiku','Wife','0713319778',NULL,'KMCA101Y','Ruiru footbridge',87,'PC30AKU8AW','James',50.00,'','Partial Payment',0,NULL,'','M-PESA','0723721127','','','',1,0,1,'Monarch',0,0,NULL,NULL),(484,'Faith Nduta','Wife','0714748236',NULL,'KMFH845H','Ruiru Rainbow',16,'PC116YW367','Patrick',50.00,'','Partial Payment',0,NULL,'','M-PESA','0713719819','','','',0,0,1,'Monarch',0,0,NULL,NULL),(485,'Nancy Mumbi','Wife','0702324356',NULL,'KMFC490P','Ruiru Kwa Kairu',1695,'AC359PBUv','Joel',50.00,'','Partial Payment',0,NULL,'','M-PESA','0702731112','','','',1,0,0,'',0,0,NULL,NULL),(486,'Noura','Brother','0707389904',NULL,'KNEW3560','Ruiru Kwakairu',1758,'PC389LOE92','Peter',50.00,'','Partial Payment',0,NULL,'','M-PESA','0791951635','','','',1,0,0,'',0,0,NULL,NULL),(487,'Neriah Mogogo','Wife','0705122587',NULL,'KMEN177F','Kwa Kairu',1753,'PC33913041','Paul',50.00,'','Partial Payment',0,NULL,'','M-PESA','0710192452','','','',1,0,0,'',0,0,NULL,NULL),(488,'John Kamau','Brother','0720202585',NULL,'KMED860K','RUIRU rainbow',116,'PCI475W4C4','Philip',50.00,'','Partial Payment',0,NULL,'','M-PESA','0717608359','','','',1,0,0,'',0,0,NULL,NULL),(489,'Margret Njeri','Wife','0759938771',NULL,'KMFJ098A','Boggie',148,'PC35A2VEOJ','Barnabas',50.00,'','Partial Payment',0,NULL,'','M-PESA','074369457','','','',1,0,1,'Sanlok IGA',0,0,NULL,NULL),(490,'Lucy Wambui','Wife','0720337613',NULL,'KMFf1075','Ruiru Kwa kairu',1730,'PC389YO1YU','Daniel',50.00,'','Partial Payment',0,NULL,'','M-PESA','0726382408','','','',1,0,1,'Sanlam General',0,0,NULL,NULL),(491,'Waweru','Friend','0718791528',NULL,'KMEZ083E','Ruiru dell kwa kairu',1633,'PC39158CU','John',50.00,'','Partial Payment',0,NULL,'','M-PESA','0795639702','','','',1,0,0,'',0,0,NULL,NULL),(492,'Gitau','Father','0700000000',NULL,'KMFD6374','Ruiru reli kwa kwairu',4172,'PC3995M88R','JOHN',50.00,'','Partial Payment',0,NULL,'','M-PESA','0704610934','','','',1,0,1,'Sanlam General',0,0,NULL,NULL),(493,'John','friend','0704610934',NULL,'KMDL485F','RUIRU Reli Bridge',2001,'PC339RU9G7','Joel',50.00,'','Partial Payment',0,NULL,'','M-PESA','0726157040','','','',1,0,0,'',0,0,NULL,NULL),(494,'Lucy Wangui','Mother','0715298524',NULL,'KMES708R','Kabati',5,'PC42BCIGOK','Jackson',50.00,'','Partial Payment',0,NULL,'','M-PESA','0757174787','','','',1,0,0,'',0,0,NULL,NULL),(495,'Lucy Njane','Wife','0707784313',NULL,'KMCG625L','Katipanga',1,'PC40BCGOBW','Charles',50.00,'','Partial Payment',0,NULL,'','M-PESA','0719225322','','','',1,0,0,'',0,0,NULL,NULL),(496,'Wambui','Mother','0703749515',NULL,'KMEV482M','Kenol Junction',4,'PC47B3GXM1','Samuel',50.00,'','Partial Payment',0,NULL,'','M-PESA','0715462572','','','',0,0,0,'',0,0,NULL,NULL),(497,'Mburu','Friend','0724267121',NULL,'KMDZ8297','Kenol Junction',1,'PCLILB2CXUD','David',50.00,'','Partial Payment',0,NULL,'','M-PESA','0727295581','','','',1,0,0,'',0,0,NULL,NULL),(498,'Joyce Mumbi','Wife','0704667948',NULL,'KMFJ336F','Kenol Junction',8,'PC42B1IWXC','Boniface',50.00,'','Partial Payment',0,NULL,'','M-PESA','0715140115','','','',1,0,1,'GA Insuarance Limited',0,0,NULL,NULL),(499,'Rebecca Wangeci','Mother','0725255646',NULL,'KMDV303V','Kenol Junction',14,'DC490453V','Moses',50.00,'','Partial Payment',0,NULL,'','M-PESA','0721699530','','','',1,0,1,'unipora',0,0,NULL,NULL),(500,'Ester Wairimu','Wife','0719602530',NULL,'KMFM960E','Magomano B',4,'PC41AWMJNF','Samuel',50.00,'','Partial Payment',0,NULL,'','M-PESA','0757950480','','','',1,0,1,'Sanlam General',0,0,NULL,NULL),(501,'John Mwangi','Friend','0798468314',NULL,'KMEY608V','Mitiini',11,'PC43B6TAV1','David',50.00,'','Partial Payment',0,NULL,'','M-PESA','0717593872','','','',1,0,0,'',0,0,NULL,NULL),(502,'Rachel Wangari','Wife','0712963694',NULL,'KMFA438T','Kwa D.C',1,'PC46B488VO','Joel',50.00,'','Partial Payment',0,NULL,'','M-PESA','0710775412','','','',1,0,0,'',1,0,NULL,NULL),(503,'xx','xx','070000000',NULL,'KMEY7842','Kwa D.C Kenol',1,'PC44B3JNM6','Francis',50.00,'','Partial Payment',0,NULL,'','M-PESA','0794609440','','','',1,0,0,'',0,0,NULL,NULL),(504,'Mercy Mutire','Wife','0792846839',NULL,'KMFE048E','Twigamart',1,'PC600XVEPBY','Ruel',50.00,'','Partial Payment',0,NULL,'','M-PESA','0796029212','','','',1,0,1,'Sanlam',0,0,NULL,NULL),(505,'Damaris','Wife','0796181390',NULL,'KMEV775E','Rumathi',1,'PC6UBU9GGA','Lawrence',50.00,'','Partial Payment',0,NULL,'','M-PESA','0751591300','','','',0,0,0,'',0,0,NULL,NULL),(508,'xx','xx','070000000',NULL,'KMEH483C','Municipality',1,'PC69OQB5KT','Emmanuel',50.00,'','Partial Payment',0,NULL,'','M-PESA','0711481609','','','',1,0,0,'',0,0,NULL,NULL),(509,'John','Friend','0716231678',NULL,'KMEH2431','Stadium',2,'PC61DJREVV','Martin',50.00,'','Partial Payment',0,NULL,'','M-PESA','0716411509','','','',1,0,0,'',0,0,NULL,NULL),(510,'Antony','Friend','0746093247',NULL,'KMEL159E','Stadium',1,'PC65DJHJE3','John',50.00,'','Partial Payment',0,NULL,'','M-PESA','0716231678','','','',1,0,0,'',0,0,NULL,NULL),(511,'Carol Wangari','wife','0716788642',NULL,'KMEW562Y','WANGIGE ',43,'PC37A2MIJ3','JOHN',50.00,'','Partial Payment',0,NULL,'','M-PESA','0701314598','','','',1,0,1,'ARMACO',0,0,NULL,NULL),(512,'Peter Mburu','son','0726169983',NULL,'KMEL664M','KIKUYU',41,'PC379UO639','JOSEPH',50.00,'','Partial Payment',0,NULL,'','M-PESA','0726169983','','','',1,0,1,'RWABE',0,0,NULL,NULL),(513,'Elizabethw','Wife','0745305332',NULL,'KMEM3862','Kiringiti Transforma',7,'PC61D16C4X','Daniel',50.00,'','Partial Payment',0,NULL,'','M-PESA','0706087916','','','',1,0,1,'Sanlam',0,0,NULL,NULL),(514,'xxxxx','xxxx','0700000',NULL,'KMEH079X','KIKUYU ',18,'PC309TOTHQ','ERIC',50.00,'','Partial Payment',0,NULL,'','M-PESA','0723753317','','','',1,0,1,'MADISON ',0,0,NULL,NULL),(515,'Esther Mangati','wife','0790730811',NULL,'KMEQ507B','KIKUYU SHELL',44,'PC329RBET2','SULEIMAN',50.00,'','Partial Payment',0,NULL,'','M-PESA','0757242112','','','',0,0,1,'TRIDENT ',0,0,NULL,NULL),(516,'Michael Mbugua','brother ','0718840696',NULL,'KMFL782G','KIKUYU SHELL ',99,'PC309R4841','ANTHONY',50.00,'','Partial Payment',0,NULL,'','M-PESA','0719463448','','','',1,0,0,'',0,0,NULL,NULL),(517,'Esther Muthonj','Wife','0700714309',NULL,'KMEC07K','Kiambu Town',1,'PC66DQH82K','Josphat',50.00,'','Partial Payment',0,NULL,'','M-PESA','0790728726','','','',1,0,0,'',0,0,NULL,NULL),(518,'Teresiah Njeri','Wife','0799264872',NULL,'KMFF848A','Kiambu Town',1,'PC60DQ2L55S','James',50.00,'','Partial Payment',0,NULL,'','M-PESA','0746270013','','','',1,0,1,'Monarch',0,0,NULL,NULL),(519,'Joseph ','brother ','0726169983',NULL,'KMDH716U','KIKUYU ',1,'PC339UMU93','DAVID',50.00,'','Partial Payment',0,NULL,'','M-PESA','0714216545','','','',1,0,1,'RWABE',0,0,NULL,NULL),(520,'xx','xx','0700000000',NULL,'KMEQ2939','Ngegu',1,'PC60DQMPRM','Jackson',50.00,'','Partial Payment',0,NULL,'','M-PESA','0706105985','','','',0,0,1,'AKI',0,0,NULL,NULL),(521,'xx','xx','0700000000',NULL,'KMEP039D','Junction',1,'PX51D4J5CD','George',50.00,'','Partial Payment',0,NULL,'','M-PESA','0715275440','','','',1,0,1,'Madison',0,0,NULL,NULL),(522,'Hannah Wambui','wife','0797573958',NULL,'KMOY305Q','Kirigiti',1,'PC64DKRJ8M','Michael',50.00,'','Partial Payment',0,NULL,'','M-PESA','0745150230','','','',1,0,0,'',0,0,NULL,NULL),(523,'xx','xx','0700000000',NULL,'KMEK175M','Kirigiti',1,'PC61DJLHU1','James',50.00,'','Partial Payment',0,NULL,'','M-PESA','0710371979','','','',1,0,0,'',0,0,NULL,NULL),(524,'Hannah Wanjiku','Mother','0729984183',NULL,'KMEJ868F','Kirigiti',1,'PC68DJ1DKW','Oliver',50.00,'','Partial Payment',0,NULL,'','M-PESA','0790841296','','','',1,0,1,'Sanlam',0,0,NULL,NULL),(525,'Felistus Wairimu','Mother','0710739633',NULL,'KMFK914C','Kiringiti',1,'PC64DIKOH2','Denis',50.00,'','Partial Payment',0,NULL,'','M-PESA','0757568583','','','',1,0,1,'Sanlam',0,0,NULL,NULL),(526,'Sarah Chelagat','Wife','0740873829',NULL,'KMEN912N','Kirigiti',20,'PC60D110QM','Moriss',50.00,'','Partial Payment',0,NULL,'','M-PESA','0740873829','','','',1,0,1,'Xplico',0,0,NULL,NULL),(527,'Mary Wanjiru','Mother','0745086915',NULL,'KMFM398P','Kirigiti',1,'PC64DH5ZBU','Peter',5.00,'','Partial Payment',0,NULL,'','M-PESA','0743186764','','','',1,0,0,'',0,0,NULL,NULL),(528,'Hannah Wambui','Wife','0774550161',NULL,'KMFK066C','Kirigiti',1,'PC60DLO98E','Geoffrey',50.00,'','Partial Payment',0,NULL,'','M-PESA','0718061276','','','',1,0,0,'',0,0,NULL,NULL),(529,'Jennifer Wanja','wife','0706503209',NULL,'KMEG581K','KIKUYU',1,'PC379TITY5','KENNEDY',50.00,'','Partial Payment',0,NULL,'','M-PESA','0702393995','','','',1,0,0,'',0,0,NULL,NULL),(530,'xxxx','xxxx','070000',NULL,'KMFJ518U','KIKUYU ',1,'PC3295JYVG','HASSAN ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0721967267','','','',1,0,0,'',0,0,NULL,NULL),(531,'David','Brother','0706531769',NULL,'KMEK915T','KIKUYU ',82,'PC389QZ532','GEORGE',50.00,'','Partial Payment',0,NULL,'','M-PESA','0724038294','','','',1,0,0,'',0,0,NULL,NULL),(532,'George ','brother ','0724038294',NULL,'KMFG807E','KIKUYU ',1,'PC349QQRS8','DAVID',50.00,'','Partial Payment',0,NULL,'','M-PESA','0706531769','','','',1,0,1,'XPLICO ',0,0,NULL,NULL),(533,'Mary Nyakio','Daughter','0722935481',NULL,'KMDG692Q','Gospel',1109,'PC52CKF8QQ','Paul',50.00,'','Partial Payment',0,NULL,'','M-PESA','0722935481','','','',1,0,1,'Captain',0,0,NULL,NULL),(534,'David  njeraini','father','0721823472',NULL,'KMFA240R','KIKUYU ',65,'PC329Q4UBC','EDWIN',50.00,'','Partial Payment',0,NULL,'','M-PESA','0724294994','','','',1,0,0,'',0,0,NULL,NULL),(535,'James jabuya','coworker','0721871487',NULL,'KMCF019D','Masaku',633,'PC55CDB3T7','John',50.00,'','Partial Payment',0,NULL,'','M-PESA','0724447818','','','',1,0,1,'Xplico',0,0,NULL,NULL),(536,'Kallen Wangari','wife','0712601502',NULL,'KMEU322E','WANGIGE',1,'PC31AZIEE3','FRANCIS',50.00,'','Partial Payment',0,NULL,'','M-PESA','0715720634','','','',1,0,1,'MONARCH',0,0,NULL,NULL),(537,'Ruth ','wife ','0114061095',NULL,'KMFA916M','MARURUI',1,'PBM7XR6QHD','George',50.00,'','Partial Payment',0,NULL,'','M-PESA','0715377612','','','',1,0,1,'MONARCH ',0,0,NULL,NULL),(538,'Lucy Wanjiru','Wife','0710288773',NULL,'KMDK965U','Ruiru Masaku',644,'PC58CCRF22U','Joseph',50.00,'','Partial Payment',0,NULL,'','M-PESA','0712590937','','','',1,0,0,'',0,0,NULL,NULL),(539,'Elizabeth ','mother','070000',NULL,'KMFG223D','GITARU ',1,'PC208L4HDC','Alex',50.00,'','Partial Payment',0,NULL,'','M-PESA','0720326849','','','',1,0,1,'MARKHOLDING',0,0,NULL,NULL),(540,'xx','xx','0700000000',NULL,'KMFD993G','Masaku',639,'PC52CCEOPE','Peter',50.00,'','Partial Payment',0,NULL,'','M-PESA','0713353164','','','',1,0,1,'Sanlam',0,0,NULL,NULL),(541,'Kennedy Munene','brother','0725012821',NULL,'KMEM588K','GITARU',1,'PC258KATRI','PETER',50.00,'','Partial Payment',0,NULL,'','M-PESA','0728001648','','','',1,0,0,'',0,0,NULL,NULL),(542,'Rawlings Siguna','Brother','0712222515',NULL,'KMFL879H','Ruiru Wataalam Booster',3,'PC51CBHEVI','Donald',50.00,'','Partial Payment',0,NULL,'','M-PESA','0724463270','','','',1,0,1,'I PAX',0,0,NULL,NULL),(543,'Gianna Waithera','Daughter','0713531825',NULL,'KMFE268A','Mama Shop',253,'PC57CRIL5J','Francis',50.00,'','Partial Payment',0,NULL,'','M-PESA','0713531825','','','',0,0,1,'Comprehensive',0,0,NULL,NULL),(544,'Levis Muigai','Son','0705480151',NULL,'KMFM4072','Biashara',511,'PC54C710M2','JOSEPH',50.00,'','Partial Payment',0,NULL,'','M-PESA','0705480151','','','',1,0,1,'Sanlam',0,0,NULL,NULL),(545,'xx','xx','0700000000',NULL,'KMEP464F','Githunguri Bypass',1134,'PC52CTFUTM','Simon',50.00,'','Partial Payment',0,NULL,'','M-PESA','0727557452','','','',1,0,0,'',0,0,NULL,NULL),(546,'Grace Nyiha','wife','0706878086',NULL,'KMDJ983H','Githunguri',1129,'PC58CTE2QZ','Samuel',50.00,'','Partial Payment',0,NULL,'','M-PESA','0706502278','','','',1,0,0,'',0,0,NULL,NULL),(547,'Rose Njogu','Wife','0707150588',NULL,'KMEF630V','Full Gospel Stage',1114,'PC57G1N5WL','Patrick',50.00,'','Partial Payment',0,NULL,'','M-PESA','0727382167','','','',1,0,0,'',0,0,NULL,NULL),(548,'Julius Mwenda','Friend','0708370342',NULL,'KMOW777E','Ruiru Rainbow',2,'PC53C97OKB','Douglas',50.00,'','Partial Payment',0,NULL,'','M-PESA','0741140884','','','',1,0,1,'Trident Insuarance',0,0,NULL,NULL),(549,'xx','xx','0700000000',NULL,'KMEW790W','Hilton',1042,'PC54CHXH28','Henry',50.00,'','Partial Payment',0,NULL,'','M-PESA','0703652188','','','',0,0,0,'',0,0,NULL,NULL),(550,'Brigit','Wife','0712685759',NULL,'KMDC827C','Wataalamu Kiambu',883,'PC51CF5XKV','Timothy',50.00,'','Partial Payment',0,NULL,'','M-PESA','0721477007','','','',1,0,0,'',0,0,NULL,NULL),(551,'xx','xx','0700000000',NULL,'KMFE900E','Masaku',969,'PC54CD5SNVM','Francis',50.00,'','Partial Payment',0,NULL,'','M-PESA','0708647397','','','',1,0,0,'',0,0,NULL,NULL),(552,'Irungu','Friend','0724447818',NULL,'KMDQ582D','Masaku',628,'PC56CCUHIE','James',50.00,'','Partial Payment',0,NULL,'','M-PESA','0721871487','','','',1,0,1,'Monarch',0,0,NULL,NULL),(553,'Njiru','Friend','0751455851',NULL,'KMDN090B','Machako',1,'PC56ABKCEC','Kennedy',50.00,'','Partial Payment',0,NULL,'','M-PESA','0723313017','','','',1,0,0,'',0,0,NULL,NULL),(554,'Mercy','Friend','0718401363',NULL,'KMCK689T','Githurai',1,'PC58CARM5Y','Peter',50.00,'','Partial Payment',0,NULL,'','M-PESA','0741905116','','','',1,0,0,'',0,0,NULL,NULL),(555,'xx','xxx','0700000000',NULL,'KMEE817C','Mama Shop',257,'PC56CN9O1Q','Stephen',50.00,'','Partial Payment',0,NULL,'','M-PESA','0726699267','','','',1,0,0,'',0,0,NULL,NULL),(556,'Leah Wambui','Wife','0713997970',NULL,'KMDE6997','Kika Store',1,'PC87GAR9SF','Peter',50.00,'','Partial Payment',0,NULL,'','M-PESA','0710701294','','','',1,0,0,'',0,0,NULL,NULL),(557,'James Kamande','Father','0725865508',NULL,'KMGX261P','Kenol Town',34,'PC49AZZCFR','Francis',50.00,'','Partial Payment',0,NULL,'','M-PESA','0748269124','','','',1,0,0,'',0,0,NULL,NULL),(558,'Francis Mbugua','Friend','0794609440',NULL,'KMFC410N','Kwa D.C Kenol',1,'PC49B2IQAJ','John',50.00,'','Partial Payment',0,NULL,'','M-PESA','0710907768','','','',1,0,0,'',1,0,NULL,NULL),(559,'Margaret Mumbi','Wife','0723565755',NULL,'KMED756K','Kenol Town',1,'PC41AW8CEZ','James',50.00,'','Partial Payment',0,NULL,'','M-PESA','0724145933','','','',1,0,1,'Madison',0,0,NULL,NULL),(560,'Henry Karanja','Friend','0792754481',NULL,'KMFH120W','County Supermarket',14,'PC44BCMASQ','Antony',50.00,'','Partial Payment',0,NULL,'','M-PESA','0741270887','','','',1,0,0,'',1,0,NULL,NULL),(561,'Jane Nduta','Wife','0796836520',NULL,'KMFE5394','Kabati Flyover',1,'PC46BE7FYK','Suleiman',50.00,'','Partial Payment',0,NULL,'','M-PESA','0795038565','','','',1,0,0,'',0,0,NULL,NULL),(562,'Patrick gitau','brother ','0717540630',NULL,'KMFE888N','GITARU ',1,'PC298GBLZ','ALEX',50.00,'','Partial Payment',0,NULL,'','M-PESA','0743751142','','','',0,0,0,'',0,0,NULL,NULL),(563,'Ruth ','mother','0725830469',NULL,'KMEF274V','GITARU',95,'PC218ELN3R','JOHN',50.00,'','Partial Payment',0,NULL,'','M-PESA','0725013190','','','',1,0,0,'',0,0,NULL,NULL),(564,'Emmanuel Waiharo','son','0112646843',NULL,'KMFG390T','GITARU RUKUBI',37,'PC288L8126','PAUL',50.00,'','Partial Payment',0,NULL,'','M-PESA','0785728294','','','',1,0,1,'XPLICO',0,0,NULL,NULL),(565,'xxxxx','xxxxx','0700000',NULL,'KMEY886B','GITARU KANJERU',1,'PC2881MLFY','SOLOMON',50.00,'','Partial Payment',0,NULL,'','M-PESA','0759312640','','','',1,0,1,'EQUITY',0,0,NULL,NULL),(566,'Mary Wangechi','wife','0721786214',NULL,'KMFF010Z','GITARU',1,'PC248I7IBM','KENNEDY',50.00,'','Partial Payment',0,NULL,'','M-PESA','0720681015','','','',1,0,1,'SANLAM GENERAL',0,0,NULL,NULL),(567,'Beth Wambui','mother ','0716904800',NULL,'KMEW691U','GITARU ',1,'PC248HD6UK','JAMES',50.00,'','Partial Payment',0,NULL,'','M-PESA','0759017831','','','',0,0,1,'XPLICO',0,0,NULL,NULL),(568,'Eunice Njeri ','mother','0745151968',NULL,'KMDT642U','GITARU MLANGO SOKO',1,'PC218GJ5SF','MARTIN',50.00,'','Partial Payment',0,NULL,'','M-PESA','0790757798','','','',1,0,0,'',0,0,NULL,NULL),(569,'Lizer Mumbi','wife ','0719389319',NULL,'KMDR487Y','MATHARE',2,'PC80GDCUG5','Boniface',50.00,'','Partial Payment',0,NULL,'','M-PESA','0720902591','','','',1,0,1,'XPLICO',0,0,NULL,NULL),(570,'Mary','wife','0791846203',NULL,'KMDW856S','KIBERA',1,'PC87GD3N3J','DAVID',50.00,'','Partial Payment',0,NULL,'','M-PESA','0708951036','','','',1,0,0,'',0,0,NULL,NULL),(571,'daisy','child','0700000',NULL,'KMEQ316Y','KIBERA',1,'PC84GCNX9G','ISAAC',50.00,'','Partial Payment',0,NULL,'','M-PESA','0741572116','','','',0,0,1,'MONARCH',0,0,NULL,NULL),(572,'Ayuma Rumonah','mother','0727374870',NULL,'KMFF927A','Industrial Area',1,'PC82GCIAGO','KENNEDY',50.00,'','Partial Payment',0,NULL,'','M-PESA','0799037766','','','',0,0,1,'TRIDENT',0,0,NULL,NULL),(573,'Ruth Muthoni','mother','0702697024',NULL,'kmfc 065z','GITHURAI',1,'PC88GCFHUS','JOSEPH',50.00,'','Partial Payment',0,NULL,'','M-PESA','0727681116','','','',1,0,0,'',0,0,NULL,NULL),(574,'Susan  Wanjiru Kihoro','friend ','0727434169',NULL,'KMFF988K','GITHURAI',1,'PC85GCC9RJ','FRANCIS ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0790902308','','','',1,0,0,'',0,0,NULL,NULL),(575,'Valley Khavera','wife','0796613731',NULL,'KMEP448C','KIBERA',1,'PC83GC9FE7','ANTONY',50.00,'','Partial Payment',0,NULL,'','M-PESA','0721706939','','','',1,0,0,'',0,0,NULL,NULL),(576,'Rehema Wanjiru','daughter','0700000',NULL,'KMDU772R','GITHURAI ',1,'PC83GC2WOV','EFFORD',50.00,'','Partial Payment',0,NULL,'','M-PESA','0720078240','','','',1,0,0,'',0,0,NULL,NULL),(577,'Emmeccurate Kanini','wife','0723462104',NULL,'KMET208Q','GITHURAI ',1,'PC89GBYGWF','GEOFFREY',50.00,'','Partial Payment',0,NULL,'','M-PESA','0723014982','','','',0,0,0,'',0,0,NULL,NULL),(578,'xxxx','xxxxx','070000',NULL,'KMER265E','CAR AND GENERAL',71001,'PCH61B42VO','Martin',50.00,'','Partial Payment',0,NULL,'','M-PESA','0712864798','','','',1,0,1,'MONARCH',0,0,NULL,NULL),(579,'xxxx','xxxx','070000',NULL,'KMFH445Z','KANGEMI',1,'PC84FBTNRS','GODFREY ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0796634272','','','',1,0,1,'PROGRESSIVE',0,0,NULL,NULL),(580,'Geoffrey ','brother','0721790695',NULL,'KMET242W','KANGEMI ',12,'PBH541SQ2','JARED',50.00,'','Partial Payment',0,NULL,'','M-PESA','0721529511','','','',1,0,1,'XPLICO',0,0,NULL,NULL),(581,'joy mwende','wife','0113009440',NULL,'KMFD380L','KIBERA',1,'PBS168R11X','EVANS',50.00,'','Partial Payment',0,NULL,'','M-PESA','0758773782','','','',1,0,0,'',0,0,NULL,NULL),(582,'Jane Njeri','Wife','0742995627',NULL,'KMEF697X','Kenol Kenneth Matiba ',1,'PC44BORNVC','Peter',50.00,'','Partial Payment',0,NULL,'','M-PESA','0719862374','','','',1,0,0,'',0,0,NULL,NULL),(583,'nelly Wanjiru ','wife','0792686471',NULL,'KMFK445B','GITHURAI ',1,'PBH46BS291','PAUL',50.00,'','Partial Payment',0,NULL,'','M-PESA','0714599589','','','',1,0,1,'SANLAM GENERAL',1,0,NULL,NULL),(584,'xxxx','xxxx','070000',NULL,'KMLO416P','UTHIRU',1,'PBP62KVQP2','DAVID',50.00,'','Partial Payment',0,NULL,'','M-PESA','0743331028','','','',1,0,1,'MONARCH ',0,0,NULL,NULL),(585,'Joseph Wambua','son ','07000',NULL,'KMPO518P','UTHIRU ',1,'PBO223AY91K','DENNIS ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0704467793','','','',1,0,1,'MONARCH ',0,0,NULL,NULL),(586,'Martin Njogu','Brother','070000',NULL,'KMPE180L','UTHIRU',1,'PB02293DOABH','DENNIS',50.00,'','Partial Payment',0,NULL,'','M-PESA','0700753932','','','',1,0,1,'TRIDENT',0,0,NULL,NULL),(587,'Joyce Njeri','Wife','0720039859',NULL,'KMFD229F','Kayole / Nairobi',1,'PBNIXICCN6','Josphat',50.00,'','Partial Payment',0,NULL,'','M-PESA','0723279682','','','',1,0,1,'Sanlam',0,0,NULL,NULL),(588,'xxxx','xxxx','07000',NULL,'KMLP160J','UTHIRU',1,'PBP22JPVV4','Antony ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0703916446','','','',1,0,1,'TRIDENT',0,0,NULL,NULL),(589,'Stephen  Mumina','Brother ','0701526539',NULL,'KMEF','Kayole',1,'PBN3Y137ND','Athanas',50.00,'','Partial Payment',0,NULL,'','M-PESA','0728406597','','','',0,0,1,'APA Insuarance',1,1,NULL,NULL),(590,'xxx','xxxx','070000',NULL,'KMEG180 P','MUTHEGA',1,'PB40CBOOMG','CYRUS',50.00,'','Partial Payment',0,NULL,'','M-PESA','0713857987','','','',1,0,1,'TRIDENT ',0,0,NULL,NULL),(591,'Hilda Musau','Wife','0713414214',NULL,'KMDA983H','Kayole',1,'PBN1Y15UXV','Moses',50.00,'','Partial Payment',0,NULL,'','M-PESA','0712199061','','','',1,0,0,'',0,0,NULL,NULL),(592,'jane wanjohi','daughter','070000',NULL,'KMPE480P','MUTHEGA ',1,'PBH1BZXU75','SAMUEL',100.00,'','Partial Payment',0,NULL,'','M-PESA','0701466970','','','',1,0,1,'TRIDENT ',0,0,NULL,NULL),(593,'Mercy Wangui','Mother','0712756573',NULL,'KMER751H','Kayole',1,'PBNIYI8C6N','Stephen Mwangi',50.00,'','Partial Payment',0,NULL,'','M-PESA','0742232782','','','',1,0,0,'',0,0,NULL,NULL),(594,'james njoroge','son','070000',NULL,'KMPF189J','MUTHEGA ',1,'PBH9BN4GKS','CHRISTOPHER',100.00,'','Partial Payment',0,NULL,'','M-PESA','0726633169','','','',1,0,0,'',0,0,NULL,NULL),(595,'Edith Nyambura','sister','0700000',NULL,'KMLP612M','MUSHOMORO',1,'PBH4BVKCPK','David ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0727206618','','','',1,0,1,'MONARCH',0,0,NULL,NULL),(596,'ivy njeri','sister ','07000',NULL,'KMLO180P','Muthiga',1,'PB229AUWNS','CHRISTOPHER ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0711425700','','','',1,0,0,'',0,0,NULL,NULL),(597,'Ruth Ntinda','Wife','0797565754',NULL,'KMFH005U','Kayole',1,'KMFH005U','Bednego',50.00,'','Partial Payment',0,NULL,'','M-PESA','0797381842','','','',1,0,1,'Ranger',1,0,NULL,NULL),(598,'xxx','xxxx','07000',NULL,'KMHF220H','KIKUYU',1,'PBK4WOXET6','JOSEPH',50.00,'','Partial Payment',0,NULL,'','M-PESA','0710775692','','','',1,0,1,'TRIDENT ',0,0,NULL,NULL),(599,'Lydiah Ngendo','Wife','0721983905',NULL,'KMES491Q','Nairobi Eastland',1,'PMIXTQDJV','Michael',50.00,'','Partial Payment',0,NULL,'','M-PESA','0725426747','','','',1,0,1,'Invesco',0,0,NULL,NULL),(600,'Jedidah','wife','070000',NULL,'KMCK500K','LAVINGTON',1,'PCBK492VAL','JOSEPH ',100.00,'','Partial Payment',0,NULL,'','M-PESA','0791467923','','','',1,0,1,'ARMACO',0,0,NULL,NULL),(601,'xxcx','cccc','070000',NULL,'KMCY494Z','LAVINGTON ',1,'PBL3W11CIIX','Moris',100.00,'','Partial Payment',0,NULL,'','M-PESA','0794058266','','','',1,0,1,'ARMACO ',0,0,NULL,NULL),(602,'Benard Mwisheni','Cousin','0728809002',NULL,'KMET194L','Kibra',1,'PBMIXTQJHM','Adede Benjamin',50.00,'','Partial Payment',0,NULL,'','M-PESA','0704707062','','','',1,0,1,'Monarch',0,0,NULL,NULL),(603,'John Kagotho','Friend','0713107749',NULL,'KMED499X','Kenneth Matriba Kenol',1,'KMED499X','Francis',50.00,'','Partial Payment',0,NULL,'','M-PESA','0725492670','','','',1,0,0,'',0,0,NULL,NULL),(604,'Peter Ndirangu','Friend','0726212599',NULL,'KMFF892E','Kenol Kenneth Matiba',1,'PC46BOOLUO','Josphat',50.00,'','Partial Payment',0,NULL,'','M-PESA','0794268912','','','',1,0,0,'',0,0,NULL,NULL),(605,'Cecilia','Mother','0729849166',NULL,'KMDL0225','Gachoro',1,'PC40BN05IA','Antony',50.00,'','Partial Payment',0,NULL,'','M-PESA','0729849166','','','',1,0,0,'',0,0,NULL,NULL),(606,'Susan Wambui','Wife','0729629378',NULL,'KMER998D','Thika Main Stage',1,'PC49AYT7MH','Macharia',50.00,'','Partial Payment',0,NULL,'','M-PESA','0726807908','','','',1,0,0,'',0,0,NULL,NULL),(607,'Freshia Wanjiru','Wife','0717160101',NULL,'KMDD843B','Kenol Magomano',1,'PC46AVRWIK','Moses',50.00,'','Partial Payment',0,NULL,'','M-PESA','0725461651','','','',1,0,0,'',0,0,NULL,NULL),(608,'Rose Gachoki','Friend','0713527053',NULL,'KMFH344F','Kenol Magomano',1,'PC4OAWBZHK','Victor  ',50.00,'','Partial Payment',0,NULL,'','M-PESA','0713905194','','','',1,0,0,'',0,0,NULL,NULL),(609,'Robert Nderitu','Brother','0716083541',NULL,'KMDT411H','Kenol Magomano',1,'PC48AWKMP4','Charles',50.00,'','Partial Payment',0,NULL,'','M-PESA','0797581060','','','',1,0,0,'',0,0,NULL,NULL),(610,'Martha Wanja','Mother ','0712722777',NULL,'KMFE600K','Kenol Kuboo',1,'PC41AVE52T','Peterson',50.00,'','Partial Payment',0,NULL,'','M-PESA','0740311829','','','',1,0,0,'',0,0,NULL,NULL),(611,'Redemer','Wife','0797330219',NULL,'KMFG037L','South B',1,'PBH4RQZET8','Josphat',50.00,'','Partial Payment',0,NULL,'','M-PESA','0706620979','','','',1,0,1,'Sanlam',1,0,NULL,NULL),(612,'xx','xx','0700000000',NULL,'KMFH929A','South B',1,'PBH2RFDZJI','32413964',50.00,'','Partial Payment',0,NULL,'','M-PESA','0713927696','','','',1,0,0,'',0,0,NULL,NULL),(613,'Beatrice','Wife','071140018',NULL,'KMDW357T','South C',1,'PBH5RH091F','32485632',50.00,'','Partial Payment',0,NULL,'','M-PESA','0797281945','','','',1,0,1,'AKI Insurance',0,0,NULL,NULL),(614,'Mike Ngugi','Cousin','0701311645',NULL,'KMEV776M','South C',1,'PBH8R147B4','James',50.00,'','Partial Payment',0,NULL,'','M-PESA','0798763376','','','',1,0,1,'BWABE Insurance Company',0,0,NULL,NULL),(615,'Christine Nyambura','Wife','0706163564',NULL,'KMDX477Y','Nyoyo',28,'PBQ042HDB8','Joel',50.00,'','Partial Payment',0,NULL,'','M-PESA','0712593856','','','',1,0,1,'Xplico Insurance Company ',0,0,NULL,NULL),(616,'Purity Mueni','Mother','0728568990',NULL,'KMEX503Y','Nyayo',1,'PBHIRCDQOX','30532920',50.00,'','Partial Payment',0,NULL,'','M-PESA','0798138700','','','',1,0,0,'',0,0,NULL,NULL),(617,'Dorris Arusa','Wife','0769088335',NULL,'KMDX929M','Kangemi',1,'PBHIRJA2JZ','Benjamin',50.00,'','Partial Payment',0,NULL,'','M-PESA','0718940700','','','',1,0,0,'',0,0,NULL,NULL),(618,'xx','xx','0700000000',NULL,'KMFJ762T','South B',1,'PBQ64TMXJU','Erick',50.00,'','Partial Payment',0,NULL,'','M-PESA','0790519985','','','',0,0,1,'Sanlam',0,0,NULL,NULL),(619,'xx','xx','0700000000',NULL,'KMEH059S','South B',1,'PBHIRJA2JZ','28685371',50.00,'','Partial Payment',0,NULL,'','M-PESA','0712895465','','','',1,0,1,'Monarch',0,0,NULL,NULL),(620,'Nelson Baraza','Brother','0706311184',NULL,'KMDL775U','South B',5,'PH4RP889W','Lazarus',50.00,'','Partial Payment',0,NULL,'','M-PESA','0705152804','','','',1,0,1,'Equity',0,0,NULL,NULL),(621,'Nyokafi','Girlfriend ','0700000000',NULL,'KMEF212Q','South C',213,'PH6RJ4K5Q','Wilson',50.00,'','Partial Payment',0,NULL,'','M-PESA','0707218055','','','',1,0,1,'Monarch',0,0,NULL,NULL),(622,'Dominic Onchwari','Brother','0712673017',NULL,'KMEX625Q','South B',1,'PBH9RQZN6H','Kevin',50.00,'','Partial Payment',0,NULL,'','M-PESA','0758853779','','','',0,0,1,'Xplico Insurance Company ',0,1,NULL,NULL),(623,'Rachael ','Sister','0708930183',NULL,'KMFD040S','South C',1,'PBH7RJOA5V','Samson',50.00,'','Partial Payment',0,NULL,'','M-PESA','0729619289','','','',1,0,1,'Sanlam Insurance  Co.',0,0,NULL,NULL),(624,'Peter Maina','Brother','0725960285',NULL,'KMFA7237','Karen ',1,'PBG5OFKLMH','Jackson',50.00,'','Partial Payment',0,NULL,'','M-PESA','0726650652','','','',1,0,1,'Monarch Insurance Company',0,0,NULL,NULL),(625,'Esther','Wife','0796671692',NULL,'KMEM857C','Karen',12,'KMEM857C','Alvin',50.00,'','Partial Payment',0,NULL,'','M-PESA','0724903883','','','',1,0,1,'Trident Insurance Company ',0,0,NULL,NULL),(626,'Calvin','Sister','0719300005',NULL,'KMFM591H','South C',1,'KMFM591H','Brighton',50.00,'','Partial Payment',0,NULL,'','M-PESA','0715890096','','','',1,0,1,'Xplico Insurance ',0,0,NULL,NULL),(627,'Agnes','Wife','0700423167',NULL,'KMEP754G','Karen',1,'PBQ63TMXJU','Charles',50.00,'','Partial Payment',0,NULL,'','M-PESA','0721405669','','','',1,0,1,'Trident Insurance Company ',0,0,NULL,NULL),(628,'Agnes','Wife','0700423167',NULL,'KMEP754G','Karen',1,'PBQ63TMXJU','Charles',50.00,'','Partial Payment',0,NULL,'','M-PESA','0721405669','','','',1,0,1,'Trident Insurance Company ',0,0,NULL,NULL),(629,'Pauleen','Wife','0742684607',NULL,'KMER979R','South B',1,'PBH3RRTLCJ','Jones',100.00,'','Partial Payment',0,NULL,'','M-PESA','0724171629','','','',1,0,0,'',0,0,NULL,NULL),(630,'xx','xx','0700000000',NULL,'KMEV823P','South C',1,'PBQ944EC17','Erick',50.00,'','Partial Payment',0,NULL,'','M-PESA','0792186025','','','',1,0,1,'Monarch',0,0,NULL,NULL),(631,'xx','xx','0700000000',NULL,'KMEJ085X','Nyayo',1,'PBQ2463M98','Benson',50.00,'','Partial Payment',0,NULL,'','M-PESA','0707563934','','','',1,0,0,'',0,0,NULL,NULL),(632,'Sherry Joan','xx','0792892333',NULL,'KMEX759M','South C',1,'PBQ944EC17','Julius',50.00,'','Partial Payment',0,NULL,'','M-PESA','0716378117','','','',1,0,1,'Monarch',0,0,NULL,NULL),(633,'xx','xx','0700000000',NULL,'KMDC917C','Karen Roundabout',1,'PBG4Q3WFK','Wycliffe',50.00,'','Partial Payment',0,NULL,'','M-PESA','0799881092','','','',1,0,1,'Trident Insurance Company',0,0,NULL,NULL),(634,'Maureen Omosa','Wife','0713940397',NULL,'PBHIRJA202','Nairobi West',1,'PHIRJA202','Samuel',50.00,'','Partial Payment',0,NULL,'','M-PESA','0722957603','','','',1,0,1,'Xplico Insurance Company',0,0,NULL,NULL),(635,'Isaac Stephen','Brother','0716177487',NULL,'KMEM2817','South  B',1,'PBL9WPTN9D','Jackson',50.00,'','Partial Payment',0,NULL,'','M-PESA','0719745908','','','',1,0,1,'The Monarch Insurance Co',0,0,NULL,NULL),(636,'Felix','Brother','0727390363',NULL,'KMFJ657Q','South C',1,'PBH9RENDIF','James',50.00,'','Partial Payment',0,NULL,'','M-PESA','0706440736','','','',0,0,1,'GA Insurance Limited',0,0,NULL,NULL),(637,'Irene Akoth','Wife','0715485867',NULL,'KMEL436L','Nairobi West',1,'PBH6RC4RKQ','Peter',50.00,'','Partial Payment',0,NULL,'','M-PESA','0721376785','','','',1,0,1,'Xplico Insurance  Company',0,0,NULL,NULL),(638,'Tillen','Brother','0700000000 ',NULL,'KMDT780B','Pathway Congroad',1,'PBG7SJFMI','Mwangi',50.00,'','Partial Payment',0,NULL,'','M-PESA','0791928280','','','',0,0,0,'',0,0,NULL,NULL),(639,'John','Brother','0700000000',NULL,'KMEJ064Q','Langata',1,'PBH5RF8627','Wanjohi',50.00,'','Partial Payment',0,NULL,'','M-PESA','0723259917','','','',1,0,1,'Third Party',0,0,NULL,NULL),(640,'Kelvin','Brother','0100248176',NULL,'KMEV834G','Eastleigh South',1,'PBG7JSKM6V','Brian',50.00,'','Partial Payment',0,NULL,'','M-PESA','0791348569','','','',1,0,1,'AKI',0,0,NULL,NULL),(641,'Edwin Njogu','xx','0723592790',NULL,'KMEH827P','Dagoretti Corner',1,'PBG7UJ82VI','Alex',50.00,'','Partial Payment',0,NULL,'','M-PESA','0722580153','','','',1,0,1,'AKI',0,0,NULL,NULL),(642,'Martha Mghambi','Wife','0795277578',NULL,'KMDV361M','Ngong Road',1,'PBGTQFJN1B','Thomas',50.00,'','Partial Payment',0,NULL,'','M-PESA','0721615198','','','',1,0,1,'Resolution',0,0,NULL,NULL),(643,'Weldon Sawe','brother','0727944121',NULL,'KMFM','Rescourse ',1,'PBG7QEQO6V','Sawe',50.00,'','Partial Payment',0,NULL,'','M-PESA','0718848340','','','',1,0,1,'Aki',1,0,NULL,NULL),(644,'Alex Mutuku','Brother','0111074831',NULL,'KNEQ302V','Langata',1,'PBG7SR711V','Eric Muthami',50.00,'','Partial Payment',0,NULL,'','M-PESA','0735855971','','','',1,0,1,'Resolution',0,0,NULL,NULL),(645,'Mercy Kipkorir','Wife','0702333327',NULL,'KMDP128K','Kabanus',1,'PBP92A01KS','Mark',50.00,'','Partial Payment',0,NULL,'','M-PESA','0719596702','','','',1,0,0,'',0,0,NULL,NULL),(646,'Clara Wanjiru','Wife','0703589672',NULL,'KMPK814K','Fedha',1,'PBP73X5J2P','Peter',50.00,'','Partial Payment',0,NULL,'','M-PESA','0717202187','','','',1,0,0,'',0,0,NULL,NULL),(647,'Lucy Anyango','Mother','0722408916',NULL,'KMPF018K','Kobil',1,'PBP331CUN','Ombisaa',100.00,'','Partial Payment',0,NULL,'','M-PESA','0731696224','','','',0,0,0,'',0,0,NULL,NULL),(648,'martin wahome','Brother','0721000111',NULL,'KMDF248P','Mlolongo',1,'PBQ20CPD3E','Anthony',100.00,'','Partial Payment',0,NULL,'','M-PESA','0721940614','','','',1,0,1,'Trident Insurance',0,0,NULL,NULL),(649,'Moreen Otieno','Wife','0714186273',NULL,'KMDF158K','Syokimau Mlolongo',135,'PBQIQCIOY8E','Stephen',50.00,'','Partial Payment',0,NULL,'','M-PESA','0708184653','','','',1,0,1,'Trident Insurance',0,0,NULL,NULL),(650,'Alice Wambua','Mother','070000000',NULL,'KMDE128N','Mlolongo',1,'PBQ14CPA77P','Alex',50.00,'','Partial Payment',0,NULL,'','M-PESA','0714820149','','','',1,0,1,'Trident Insurance',0,0,NULL,NULL),(651,'Grace Njeri','Sister','0705333011',NULL,'KMDP120P','Mlolingo',1,'PBQ14PCQOE','Joseph',50.00,'','Partial Payment',0,NULL,'','M-PESA','0722518619','','','',1,0,1,'Trident Insurance',0,0,NULL,NULL),(652,'xx','xx','0700000000',NULL,'KMFJ140H','Fedha',1,'PBF5P11937','Moses',50.00,'','Partial Payment',0,NULL,'','M-PESA','0723167488','','','',1,0,1,'Trident',0,0,NULL,NULL),(653,'Jane Wairimu','Daughter','0700000000',NULL,'KMP0280J','Fedha',1,'PBL8X002280','Michael',50.00,'','Partial Payment',0,NULL,'','M-PESA','0720081426','','','',1,0,1,'Trident',0,0,NULL,NULL),(654,'Mueni','Daughter ','070000000',NULL,'KMFA84J','Embakasi',1,'PBP22JPVV4','Steven',50.00,'','Partial Payment',0,NULL,'','M-PESA','0728049048','','','',1,0,1,'Trident',0,0,NULL,NULL),(655,'Hayden Waturi','Daughter ','070000000',NULL,'KMFE280J','Fedha',1,'PBQ93DOABH','Moses',50.00,'','Partial Payment',0,NULL,'','M-PESA','0722051828','','','',1,0,1,'Trident',0,0,NULL,NULL),(656,'Alex Mutua','Brother ','0723189148',NULL,'KMFP280P','Pipeline',1,'PB0223AY91K','Francis',100.00,'','Partial Payment',0,NULL,'','M-PESA','0714779148','','','',1,0,1,'Trident',0,0,NULL,NULL),(657,'Jane Wanjiru','Wife','0722887514',NULL,'KMFL168P','Cabanas',1,'PBP62KV02P2','Joseph',100.00,'','Partial Payment',0,NULL,'','M-PESA','0780148280','','','',1,0,1,'Trident',0,0,NULL,NULL),(659,'Duncan ','child','0742785907',NULL,'KMEM431C','MURERA/KAREN',48,'PC45B8SFHI','Albert',50.00,'','Partial Payment',1,NULL,'','M-PESA','0714475894','','','',1,0,0,'',0,0,NULL,NULL),(660,'Mary Maina','Aunt','0710417492',NULL,'KMFA510T','KENYATTA ROAD',6311,'PC42BBNTUS','EDWIN',50.00,'','Partial Payment',1,NULL,'','M-PESA','0700535713','','','',1,0,0,'',0,0,NULL,NULL),(661,'Tabitha ','mother','0713723944',NULL,'KMEM773A','KENYATTA ROAD ',6308,'PC44BD453A','Stevo',50.00,'','Partial Payment',1,NULL,'','M-PESA','0725139209','','','',1,0,0,'',0,0,NULL,NULL),(662,'Rose Wangari ','wife','0743848349',NULL,'KMEX535T','KENYATTA ROAD ',6301,'PC41BDFY5N','ALEX',50.00,'','Partial Payment',1,NULL,'','M-PESA','0725139209','','','',1,0,0,'',0,0,NULL,NULL),(663,'Andrew','Child','070000',NULL,'KMDR226X','JUJA',2164,'PC88GCZLS6','PETER',50.00,'','Partial Payment',1,NULL,'','M-PESA','0710727393','','','',1,0,1,'MAKINDU',0,0,NULL,NULL),(664,'Abigail ','child ','070000',NULL,'KMDV205L','JUJA',1,'PC83GCW7XD','Peter',50.00,'','Partial Payment',1,NULL,'','M-PESA','0724828240','','','',1,0,0,'',0,0,NULL,NULL),(665,'Geoffrey ','brother','070000',NULL,'KMFG419E','JUJA',1,'PC88GANEKO','DUKE',50.00,'','Partial Payment',1,NULL,'','M-PESA','0723441324','','','',1,0,0,'',0,0,NULL,NULL),(666,'James Kiari','brother ','0710614846',NULL,'KMET770P','JUJA',1,'PC61D5BGKX','NJUGUNA',50.00,'','Partial Payment',1,NULL,'','M-PESA','0791396038','','','',1,0,0,'',0,0,NULL,NULL),(667,'Risper','wife','0791354371',NULL,'KMES574T','MURERA',41,'PC41B2C7YF','EVANS ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0720513900','','','',1,0,0,'',0,0,NULL,NULL),(668,'Catherine ','sister ','0721542966',NULL,'KMEH766D','MURERA',11841,'PC40B2EB7K','KELVIN',50.00,'','Partial Payment',1,NULL,'','M-PESA','0759099255','','','',1,0,0,'',0,0,NULL,NULL),(669,'Nancy ','wife','0792751005',NULL,'KMEY442U','MURERA ',11854,'PC41B2VVWL','DENNIS ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0791909173','','','',1,0,1,'SANLAM',1,0,NULL,NULL),(670,'Nyangucha','father','0728092375',NULL,'KMFG461E','MURERA ',70,'PC47B69XUN','DENNIS',50.00,'','Partial Payment',1,NULL,'','M-PESA','0792536523','','','',1,0,1,'SANLAM',1,0,NULL,NULL),(671,'Shirley Nyameso','wife','0727480515',NULL,'KMER886G','KOMAROCK',1,'PC67BUXBAF','PATRICK',50.00,'','Partial Payment',1,NULL,'','M-PESA','0701808026','','','',1,0,1,'MONARCH ',0,0,NULL,NULL),(672,'Rose Mbira','wife','0748290082',NULL,'KMFK998A','LIMURU ',1,'PC309U55IU','DOUGLAS',50.00,'','Partial Payment',1,NULL,'','M-PESA','0743567955','','','',1,0,1,'TRIDENT',0,0,NULL,NULL),(674,'Jemimah Bonariri','friend ','07450311',NULL,'KMEU484X','LIMURU',1,'PC31A2SZTH','SALIM ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0723281829','','','',1,0,0,'',0,0,NULL,NULL),(675,'Mary Wanja','daughter ','0725386017',NULL,'KMDK958N','LIMURU STAGE ',19,'PC339SY75P','ANTONY',50.00,'','Partial Payment',1,NULL,'','M-PESA','0729558696','','','',1,0,0,'',0,0,NULL,NULL),(676,'Mary Wanjiru','wife ','0710209370',NULL,'KMFD064T','LIMURU',1,'PC369S3NQW','GEORGE',50.00,'','Partial Payment',1,NULL,'','M-PESA','0745719114','','','',1,0,1,'MADISON',0,0,NULL,NULL),(677,'Anastasia Karange','wife','0794272595',NULL,'KMFJ074J','LIMURU ',1,'PC339XCCXT','KEVIN',50.00,'','Partial Payment',1,NULL,'','M-PESA','0794790342','','','',1,0,0,'',1,0,NULL,NULL),(678,'Hannah Wanjiru','wife ','0706327357',NULL,'KMEQ012R','LIMURU ',1,'PC359X6Q7J','ERIC',50.00,'','Partial Payment',1,NULL,'','M-PESA','0790808180','','','',1,0,0,'',0,0,NULL,NULL),(679,'Yvonne Wambugu','wife','0717518762',NULL,'KMET699Q','RUAI',1,'PC55CHSNZP','GEORGE',50.00,'','Partial Payment',1,NULL,'','M-PESA','0724292750','','','',1,0,0,'',0,0,NULL,NULL),(680,'Samuel Gichuhi','brother','0717741666',NULL,'KMFH538H','RUAI ',1,'PC59CHZM2I','DAVID',50.00,'','Partial Payment',1,NULL,'','M-PESA','0796357107','','','',0,0,0,'',0,0,NULL,NULL),(681,'maureen wanjiku','sister','0729441493',NULL,'KMFG494Q','RUAI',1,'PC51CJRIFP','Kelvin',50.00,'','Partial Payment',1,NULL,'','M-PESA','0112716069','','','',1,0,1,'XPLICO',0,0,NULL,NULL),(682,'Hannah Njeri','wife','0790599038',NULL,'KMEH510E','CHOKAA',1,'PC54CYO5E8','DANIEL',50.00,'','Partial Payment',1,NULL,'','M-PESA','0713107799','','','',0,0,0,'',0,0,NULL,NULL),(683,'Miriam Njoki','Daughter','0728948864',NULL,'KMDE794H','BYPASS/ RUAI',1,'PC57CUV7ZH','JOHN ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0728948864','','','',1,0,0,'',0,0,NULL,NULL),(684,'James Ndirangu','cousin','0714384398',NULL,'KMEB209B','RUAI/BYPASS ',1,'PC50CR7CN4','KHALID ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0791930965','','','',1,0,1,'TRIDENT',0,0,NULL,NULL),(685,'Paul ngugi','wife','0720539514',NULL,'KMFJ637D','RUAI BYPASS ',1,'PC54CT7XAI','Erastus',50.00,'','Partial Payment',1,NULL,'','M-PESA','0720539514','','','',1,0,1,'SANLAM',0,0,NULL,NULL),(686,'Kevin Muinde','Brother','0790392885',NULL,'KMFG778Z','RUAI',1,'PC58CL9786','CHARLES',50.00,'','Partial Payment',1,NULL,'','M-PESA','0796343345','','','',1,0,0,'',0,0,NULL,NULL),(687,'Duncan Wambugu','father ','0712348932',NULL,'KMEZ127U','UMOJA 3',1,'PC67E3J4T3','BILDAD',50.00,'','Partial Payment',1,NULL,'','M-PESA','0704244394','','','',0,0,0,'',0,0,NULL,NULL),(688,'Veronica Muthoni','wife','0780490875',NULL,'KMFF072E','Umoja 3',1,'PC66E37YZE','Bernard',50.00,'','Partial Payment',1,NULL,'','M-PESA','0726628591','','','',1,0,1,'MONARCH ',1,0,NULL,NULL),(689,'Martin Mwangi','son','0725555313',NULL,'KMDW635G','UMOJA ',1,'PC68PC5VQG','KARIUKI',50.00,'','Partial Payment',1,NULL,'','M-PESA','0708902260','','','',1,0,1,'MADISON ',0,0,NULL,NULL),(690,'Ann Mugure ','wife','0728800957',NULL,'KMDR440G','UMOJA',1,'PC66E70HIG','GILBERT',50.00,'','Partial Payment',1,NULL,'','M-PESA','0797093789','','','',1,0,0,'',0,0,NULL,NULL),(691,'Josphat Babu','brother','0795415189',NULL,'KMFD175T','KOMAROCK',1,'PC61E9ESJH','ELIKANA',50.00,'','Partial Payment',1,NULL,'','M-PESA','0707166921','','','',1,0,1,'SANLAM',0,0,NULL,NULL),(692,'Catherine Wambui','sister ','0113312912',NULL,'KMEX773D','KAYOLE JUNCTION ',1,'PC67EARWBX','JOSEPH',50.00,'','Partial Payment',1,NULL,'','M-PESA','0111333228','','','',1,0,1,'DIRECTLINE INSURANCE',0,0,NULL,NULL),(693,'Nancy Muthoni ','wife','0726130209',NULL,'KMCS218W','MAMA LUCY/UMOJA ',1,'PC60EIUNOC','Simon',50.00,'','Partial Payment',1,NULL,'','M-PESA','0701230217','','','',1,0,1,'MONARCH ',0,0,NULL,NULL),(694,'xxxx','xxxxx','0700000',NULL,'KMEW713L','PHEROZE ',1,'PC68DXOLO6','James',50.00,'','Partial Payment',1,NULL,'','M-PESA','072389017','','','',0,0,1,'MONARCH ',1,1,NULL,NULL),(695,'Stephen Maina','son','0710328661',NULL,'KMEA410E','KOMAROCK',1,'PC69DW9W58','Paul',50.00,'','Partial Payment',1,NULL,'','M-PESA','0718228996','','','',1,0,0,'',0,0,NULL,NULL),(696,'Esther Muteira','friend','0746368924',NULL,'KMFM889V','JUJA',1,'PC51CPYP5H','ERICK',50.00,'','Partial Payment',1,NULL,'','M-PESA','0710922516','','','',1,0,0,'',0,0,NULL,NULL),(697,'xxxx','xxxx','070000000',NULL,'KMDX163M','WITEITHIE ',1,'PC53CPOZQI','SAMMY',50.00,'','Partial Payment',1,NULL,'','M-PESA','0700356779','','','',1,0,0,'',0,0,NULL,NULL),(698,'xxxxx','xxxxx','0700000',NULL,'KMDV686E','KENYATTA ROAD ',1,'PC58CIQD68','Amos',50.00,'','Partial Payment',1,NULL,'','M-PESA','0717041405','','','',1,0,0,'',0,0,NULL,NULL),(699,'xxxxx','xxxxx','07000000',NULL,'KMFJ143A ','JUJA ',1,'PC59CNFTQT','Moses',50.00,'','Partial Payment',1,NULL,'','M-PESA','0715560061','','','',1,0,1,'GA INSURANCE ',0,0,NULL,NULL),(700,'xxxx','xxxx','07000000',NULL,'KMEQ552V','TOLL',1,'PC56C8H5VI','ZABERIO',50.00,'','Partial Payment',1,NULL,'','M-PESA','0798871702','','','',1,0,1,'HAKI',0,0,NULL,NULL),(701,'xxxx','xxxx','07000000',NULL,'KMFD063Z','KENYATTA ROAD ',1,'PC54CAP4DU','PETER',50.00,'','Partial Payment',1,NULL,'','M-PESA','0796721520','','','',1,0,1,'AKI',0,0,NULL,NULL),(702,'xxxxx','xxxx','07000000',NULL,'KMCV373P','KENYATTA ROAD ',1,'PC56CF9ER4','AMOS',50.00,'','Partial Payment',1,NULL,'','M-PESA','0728013863','','','',1,0,0,'',0,0,NULL,NULL),(703,'xxxxx','xxxxx','070000',NULL,'KMFC917K','KENYATTA ROAD ',1,'PC51CBT789','WILSON ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0715391339','','','',0,0,1,'XPLICO',1,1,NULL,NULL),(704,'xxxx','xxxx','070000',NULL,'KMFC343W','KENYATTA ROAD ',1,'PC53CBJE75','JULIUS',50.00,'','Partial Payment',1,NULL,'','M-PESA','0700500870','','','',0,0,1,'TRIDENT',0,0,NULL,NULL),(705,'xxxxxx','xxxxx','07000000',NULL,'KMEH001G','KENYATTA ROAD ',1,'PC55CC2YN9','BOAZ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0724549620','','','',1,0,0,'',0,0,NULL,NULL),(706,'xxxx','xxxxx','07000000',NULL,'KMFB506W','KENYATTA ROAD ',1,'PC52CDOY65','JOHN',50.00,'','Partial Payment',1,NULL,'','M-PESA','0716066287','','','',1,0,0,'',0,0,NULL,NULL),(707,'Rosemary ','friend','0714913815',NULL,'KMEW227Z','KENYATTA ROAD ',1,'PC53CEEMW9','JOSEPH ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0723066288','','','',1,0,0,'',1,0,NULL,NULL),(708,'xxxxxx','xxxxxx','0700000',NULL,'KMER571H','KENYATTA ROAD ',1,'PC51CH10BZ','PAUL',50.00,'','Partial Payment',1,NULL,'','M-PESA','0791520616','','','',1,0,0,'',1,0,NULL,NULL),(709,'Redemtah','xxxxx','0707028180',NULL,'KMFY057L','KENYATTA ROAD ',1,'PC52CH9160','Antony',50.00,'','Partial Payment',1,NULL,'','M-PESA','0727264464','','','',1,0,1,'SANLAM',0,0,NULL,NULL),(710,'Lilian Wanjiku ','xxxx','0701906625',NULL,'KMEX155M','JUJA',1,'PC59CM3BJ7','PAUL',50.00,'','Partial Payment',1,NULL,'','M-PESA','0728418745','','','',1,0,0,'',0,0,NULL,NULL),(711,'onesmus ','xxxxxxx','070000',NULL,'KMFL350G','JUJA',1,'PC53CYTDIJ','BENSON',50.00,'','Partial Payment',1,NULL,'','M-PESA','0758175867','','','',1,0,0,'',0,0,NULL,NULL),(712,'Peter Manga','xxxxx','070000',NULL,'KMEH209P','JUJA',1,'PC54CYXE4M','JAMES',50.00,'','Partial Payment',1,NULL,'','M-PESA','0717348919','','','',1,0,1,'AKI',0,0,NULL,NULL),(713,'Ellijoy Muthoni ','mother','0701193393',NULL,'KMEP936L','JUJA',1,'PC59CYP8CD','Isaac',50.00,'','Partial Payment',1,NULL,'','M-PESA','0706298433','','','',0,0,0,'',0,0,NULL,NULL),(714,'Cynthia Nafuna','xxxx','0797455247',NULL,'KMFB576E','KENYATTA ROAD ',1,'PC59D9CU4V','MOSES ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0799064154','','','',1,0,0,'',0,0,NULL,NULL),(715,'Wanjiru Margaret ','wife','0700498054',NULL,'KMDQ551R','KENYATTA ROAD ',1,'PC63DGVORW','GEOFFREY',50.00,'','Partial Payment',1,NULL,'','M-PESA','0721265082','','','',1,0,0,'',0,0,NULL,NULL),(716,'xxxxxxx','xxxxxx','07000000',NULL,'KMET606','KENYATTA ROAD ',1,'PC69DQ3PFR','DAVID',50.00,'','Partial Payment',1,NULL,'','M-PESA','0707967032','','','',0,0,0,'',0,0,NULL,NULL),(717,'xxxx','xxxxxx','070000',NULL,'KMDJ278E','JUJA ',1,'PC58CQMJWQ','TIMOTHY',50.00,'','Partial Payment',1,NULL,'','M-PESA','0717399117','','','',1,0,0,'',0,0,NULL,NULL),(718,'Ndungu','Kamau','0700000',NULL,'KMCW026H','WESTLANDS ',1,'PC177DC8K7','KAMAU ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0721877063','','','',1,0,0,'',0,0,NULL,NULL),(719,'xxxxxxx','xxxxxxx','070000000',NULL,'KMDM108V','WESTLANDS',1,'PC10710DC2','TITUS',50.00,'','Partial Payment',1,NULL,'','M-PESA','0723277808','','','',0,0,0,'',0,0,NULL,NULL),(720,'thom bosire','brother','0714005464',NULL,'KMFJ579U','SITIMA PLAZA',1,'PC1972J9AH','EDWARD ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0714173777','','','',0,0,1,'WATU',1,1,NULL,NULL);

--
-- Table structure for table `collection_center_categories`
--

CREATE TABLE `collection_center_categories` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `collectionCenterCategoryName` varchar(100) NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `collection_center_categories`
--

INSERT INTO `collection_center_categories` VALUES (1,'Normal Collection Center','Normal Collection Center'),(2,'Main Collection Center','Main Collection Center'),(3,'Major Collection Center','Major Collection Center');

--
-- Table structure for table `collection_centers`
--

CREATE TABLE `collection_centers` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `locationLat` decimal(9,6) NOT NULL,
  `locationLong` decimal(9,6) NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `dateCreated` datetime NOT NULL,
  `staff_inchargeID` int(10) NOT NULL,
  `collectionCenterCategoryID` int(5) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `collection_centers`
--

INSERT INTO `collection_centers` VALUES (1,-1.067906,37.050593,'Witeithie Collection Center.','2021-01-06 12:27:21',1,1),(2,-1.105904,37.017282,'Juja Collection Centre','2021-01-06 10:33:30',2,1),(3,-1.103384,37.019290,'Fgg cjvfAt: Kenya, Juja, , Kenya','2021-02-15 07:57:02',35,1),(4,-1.028834,37.066202,'amkaAt: Kenya, Thika','2021-02-16 20:52:18',78,1),(5,-1.036483,37.074379,'kimexAt: Commercial Street, Thika, , Kenya','2021-02-18 15:30:50',128,2),(6,-0.299476,36.087341,'WanjiaAt: Unnamed Road, Nakuru, , Kenya','2021-02-21 13:17:46',216,3),(7,-0.718806,36.430851,'Dandy At: Unnamed Road, Naivasha, , Kenya','2021-02-21 17:23:47',217,2),(8,0.962334,34.975926,'twinzAt: Unnamed Road, , , KenyaAt: Unnamed Road, , , Kenya','2021-02-21 17:37:57',218,2),(9,0.527559,35.265929,'WashaAt: Kitondo Street, Eldoret, , Kenya','2021-02-21 17:41:12',219,2),(10,-3.391141,38.573154,'WadauAt: Unnamed Road, , , Kenya','2021-02-21 17:45:56',220,2),(11,-4.005433,39.713136,'WaseliAt: Unnamed Road, Mombasa, , Kenya','2021-02-21 17:54:42',221,3),(12,-1.147764,36.960340,'thirtyAt: C65, Ruiru, , Kenya','2021-02-21 19:26:32',222,2),(13,-1.090953,37.024434,'Miketech electronics','2021-02-24 20:13:11',274,1),(14,1.018599,35.002470,'Wholesale shopAt: Kangaroo Shuttle, Kitale, , Kenya','2021-02-25 05:13:18',275,2),(15,-4.041621,39.667041,'Shakur ShopAt: Tom Mboya Road, Mombasa, , Kenya','2021-02-25 05:20:52',276,3),(16,-0.303835,36.080308,'Talam ShopAt: St Nicholas Wardens Office, Nakuru, , Kenya','2021-02-25 05:25:16',277,3),(17,-1.205882,36.917691,'Dominion Ventures','2021-02-25 09:09:56',278,1),(18,-1.326203,36.890377,'Babyshop','2021-02-25 13:34:07',279,2),(19,-1.265160,36.984949,'Hinga Stores','2021-02-26 09:01:55',284,2),(20,-1.281280,36.962671,'Eastgate carwash','2021-02-26 10:33:31',285,1),(21,-1.266687,36.922362,'Clixed Photos','2021-02-26 11:59:57',286,1),(22,-1.258086,36.921167,'Poa Pay Investments','2021-02-26 12:43:13',287,1),(23,-1.267195,36.911404,'Whitehouse enterprises','2021-02-26 14:02:34',288,2),(24,-1.278366,36.908422,'Super Five Shop','2021-02-26 14:41:33',289,2),(25,-1.283401,36.896875,'MJ Signs','2021-02-26 15:44:51',290,1),(26,-1.279767,36.897460,'Guro company','2021-02-26 16:23:47',291,1),(27,-1.273728,36.894521,'Sigma Cyber','2021-02-26 17:12:51',292,1),(28,-1.286009,36.880062,'Jirani one Kenya ltd','2021-02-26 18:30:09',293,2),(29,-1.300713,36.889234,'Port Florence Ventures','2021-02-27 10:18:54',294,2),(30,-1.273381,36.879289,'Amberjoy Cyber','2021-02-27 11:18:54',295,1),(31,-1.293385,36.862723,'Jack creatives','2021-02-27 12:33:09',296,1),(32,-1.294457,36.854434,'Steltech cyber','2021-02-27 14:00:14',298,1),(33,-1.229653,36.921018,'Jomeca shop','2021-02-27 16:18:29',299,1),(34,-1.218063,36.901805,'Wizzy Investments','2021-02-27 17:10:50',300,1),(35,-1.208239,36.926131,'Icotec','2021-02-27 18:08:07',301,1),(36,-1.196773,36.924724,'Kahawa bookshop','2021-02-27 18:50:21',302,1),(37,-1.215956,36.887729,'Syles and smiles salon','2021-03-01 10:41:28',316,1),(38,-1.210337,36.895801,'Cyber, Zimmerman','2021-03-01 11:58:48',317,1),(39,-1.185115,36.905169,'Kahawa.West station bookshop','2021-03-01 13:15:14',325,1),(40,-1.146867,36.958855,'Sort IT Enterprise','2021-03-01 14:24:43',332,1),(42,-1.084557,37.067704,'Jordan merchant hardware','2021-03-02 13:41:41',440,1),(43,-1.059459,37.116477,'BM WHOLESALERS','2021-03-03 10:15:42',450,1),(44,-1.076788,37.106591,'Harok enterprises','2021-03-03 13:41:25',453,1),(45,-1.034606,37.076389,'Neema households','2021-03-03 16:54:18',456,2),(46,-0.936780,37.122529,'Voskeytech Cyber','2021-03-04 10:11:12',460,0),(47,-1.171860,36.843175,'Zigzag Cyber','2021-03-06 11:02:35',477,0),(48,-1.168106,36.826035,'Kinyozi Maalum','2021-03-06 13:31:42',478,0),(49,-1.011149,36.903393,'shopsyAt: Gatundu - Kinare Road, Gatundu, , Kenya','2021-03-18 18:09:23',673,0);

--
-- Table structure for table `counties`
--

CREATE TABLE `counties` (
  `countyID` int(3) NOT NULL AUTO_INCREMENT,
  `countyName` varchar(35) DEFAULT NULL,
  PRIMARY KEY (`countyID`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `counties`
--

INSERT INTO `counties` VALUES (1,'Mombasa'),(2,'Kwale'),(3,'Kilifi'),(4,'Tana River'),(5,'Lamu'),(6,'Taita Taveta'),(7,'Garissa'),(8,'Wajir'),(9,'Mandera'),(10,'Marsabit'),(11,'Isiolo'),(12,'Meru'),(13,'Tharaka Nithi'),(14,'Embu'),(15,'Kitui'),(16,'Machakos'),(17,'Makueni'),(18,'Nyandarua'),(19,'Nyeri'),(20,'Kirinyaga'),(21,'Murang\'a'),(22,'Kiambu'),(23,'Turkana'),(24,'West Pokot'),(25,'Samburu'),(26,'Trans-Nzoia'),(27,'Uasin Gishu'),(28,'Elgeyo-Marakwet'),(29,'Nandi'),(30,'Baringo'),(31,'Laikipia'),(32,'Nakuru'),(33,'Narok'),(34,'Kajiado'),(35,'Kericho'),(36,'Bomet'),(37,'Kakamega'),(38,'Vihiga'),(39,'Bungoma'),(40,'Busia'),(41,'Siaya'),(42,'Kisumu'),(43,'Homa Bay'),(44,'Migori'),(45,'Kisii'),(46,'Nyamira'),(47,'Nairobi');

--
-- Table structure for table `goods_type_categories`
--

CREATE TABLE `goods_type_categories` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `goodsTypeCategoryName` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `goodsTypeCategoryDescription` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `goods_type_categories`
--

INSERT INTO `goods_type_categories` VALUES (1,'Parcel','Parcel'),(2,'General','General'),(3,'Electronics','Electronics'),(4,'Valuables','Valuables');

--
-- Table structure for table `goodssizecategory`
--

CREATE TABLE `goodssizecategory` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `goodsSizeCategoryName` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `goodsSizeCategoryDescription` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `goodssizecategory`
--

INSERT INTO `goodssizecategory` VALUES (1,'Small',' Small category(A4 Size of 8-1/4 x 11-3/4 inches)'),(2,'Medium',' Large Category(A3 Size of 11-3/4 x 16-1/2 inches)'),(3,'Large',' Large Category(A2 Size of 16-1/2 x 23-3/8 inches)'),(4,'Bulky','Bulky Category(Greater Than A2 Size of 16-1/2 x 23-3/8 inches)');

--
-- Table structure for table `order_a`
--

CREATE TABLE `order_a` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `openForNotification` int(2) DEFAULT NULL,
  `lockedByStaffID` int(10) DEFAULT NULL,
  `userId` int(15) NOT NULL,
  `locationFromLat` decimal(9,6) NOT NULL,
  `locationFromLong` decimal(9,6) NOT NULL,
  `locationFrom` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `locationTo` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `distanceCovered` double(7,2) NOT NULL,
  `recepientName` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `goodsDescription` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `recipientPhone` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `recipientLocationLat` decimal(9,6) NOT NULL,
  `recipientLocationLong` decimal(9,6) NOT NULL,
  `pickUpCentreLocationLat` decimal(9,6) NOT NULL,
  `pickUpCentreLocationLong` decimal(9,6) NOT NULL,
  `deliveryCentreLocationLat` decimal(9,6) NOT NULL,
  `deliveryCentreLocationLong` decimal(9,6) NOT NULL,
  `locationFromToPickUpCentreStaffID` int(15) NOT NULL,
  `deliveryCentreToLocationToStaffID` int(15) NOT NULL,
  `locationFromToPickUpCentreCost` decimal(15,2) NOT NULL,
  `deliveryCentreToLocationToCost` decimal(15,2) NOT NULL,
  `statusAId` int(5) NOT NULL,
  `pickUpCentreAgentStaffID` int(15) NOT NULL,
  `deliveryCentreAgentStaffID` int(15) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `payerCategoryID` int(5) NOT NULL,
  `goodsSizeCategoryID` int(5) NOT NULL,
  `goodsTypeCategoryID` int(5) NOT NULL,
  `deliveryCost` decimal(12,2) NOT NULL,
  `payerMpesaNumber` varchar(20) DEFAULT NULL,
  `recipientNotificationOption` int(3) DEFAULT NULL,
  `recipientEmail` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `trackingOption` int(2) NOT NULL,
  `serialNo` int(15) NOT NULL,
  `bagNo` int(15) NOT NULL,
  `deliveryCode` varchar(20) DEFAULT NULL,
  `orderPath` text,
  `centerIdToActOnOrder` int(10) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `order_a`
--

INSERT INTO `order_a` VALUES (12,1,0,1,-1.127228,37.012305,'Unnamed Road, Juja, , Kenya','Njoro',193.83,'Ruth Seinkuru','Bale of clothing ','0725365214',-0.372131,35.947887,-1.105904,37.017282,-0.303835,36.080308,0,0,0.00,0.00,1,2,277,'2021-02-25 05:48:51',2,3,2,969.17,NULL,NULL,'dhamini.logitech@gmail.com',0,0,0,NULL,'null',0),(13,1,0,1,-1.127228,37.012305,'Unnamed Road, Juja, , Kenya','Njoro',193.83,'Ruth Seinkuru','Bale of clothing ','0725365214',-0.372131,35.947887,-1.105904,37.017282,-0.303835,36.080308,0,0,0.00,0.00,1,2,277,'2021-02-25 05:52:05',2,3,2,969.17,NULL,NULL,'dhamini.logitech@gmail.com',0,0,0,NULL,'null',0),(14,1,0,1,-1.127287,37.010246,'Kenyatta road, Juja, , Kenya','Nakuru Teachers',171.75,'Rosemary Nasieku','Box of soaps','0725368521',-0.286980,36.068370,-1.105904,37.017282,-0.303835,36.080308,0,0,0.00,0.00,1,2,277,'2021-02-25 05:57:16',2,1,2,858.73,NULL,NULL,'dhamini.logitech@gmail.com',0,0,0,NULL,'null',0),(15,1,0,1,-1.127287,37.010246,'Kenyatta road, Juja, , Kenya','Nakuru Teachers',171.75,'Rosemary Nasieku','Box of soaps','0725368521',-0.286980,36.068370,-1.105904,37.017282,-0.303835,36.080308,0,0,0.00,0.00,1,2,277,'2021-02-25 06:01:05',2,1,2,858.73,NULL,NULL,'dhamini.logitech@gmail.com',0,0,0,NULL,'null',0),(16,1,0,1,-1.127287,37.010246,'Kenyatta road, Juja, , Kenya','Nakuru Teachers',171.75,'Rosemary Nasieku','Box of soaps','0725368521',-0.286980,36.068370,-1.105904,37.017282,-0.303835,36.080308,0,0,0.00,0.00,1,2,277,'2021-02-25 06:03:52',2,1,2,858.73,NULL,NULL,'dhamini.logitech@gmail.com',0,0,0,NULL,'null',0),(17,1,0,1,-1.127287,37.010246,'Kenyatta road, Juja, , Kenya','Nakuru Teachers',171.75,'Rosemary Nasieku','Box of soaps','0725368521',-0.286980,36.068370,-1.105904,37.017282,-0.303835,36.080308,0,0,0.00,0.00,1,2,277,'2021-02-25 06:07:20',2,1,2,858.73,NULL,NULL,'dhamini.logitech@gmail.com',0,0,0,NULL,'null',0),(18,1,0,1,-1.127287,37.010246,'Kenyatta road, Juja, , Kenya','Nakuru Teachers',171.75,'Rosemary Nasieku','Box of soaps','0725368521',-0.286980,36.068370,-1.105904,37.017282,-0.303835,36.080308,0,0,0.00,0.00,1,2,277,'2021-02-25 06:08:38',2,1,2,858.73,NULL,NULL,'dhamini.logitech@gmail.com',0,0,0,NULL,'null',0),(19,1,435,1,-1.121440,37.012898,'Unnamed Road, Juja, , Kenya','Nakuru Teachers',171.44,'Rosemary Nasieku','Box of soaps','0725368521',-0.286980,36.068370,-1.105904,37.017282,-0.303835,36.080308,0,0,0.00,0.00,1,2,277,'2021-02-25 06:10:11',2,1,2,857.18,NULL,NULL,'dhamini.logitech@gmail.com',0,0,0,NULL,'null',0),(20,1,0,1,-1.127228,37.012305,'Unnamed Road, Juja, , Kenya','Nakuru Teachers',171.82,'Humphretu Kigyutuk','Parcel','0725368980',-0.286980,36.068370,-1.105904,37.017282,-0.303835,36.080308,0,0,0.00,0.00,1,2,277,'2021-02-25 06:14:23',1,1,1,859.10,NULL,NULL,'dhamini.logitech@gmail.com',0,0,0,NULL,'null',0),(21,1,0,1,-1.127228,37.012305,'Unnamed Road, Juja, , Kenya','Nakuru Teachers',171.82,'Humphretu Kigyutuk','Parcel','0725368980',-0.286980,36.068370,-1.105904,37.017282,-0.303835,36.080308,0,0,0.00,0.00,1,2,277,'2021-02-25 06:17:17',1,1,1,859.10,NULL,NULL,'dhamini.logitech@gmail.com',0,0,0,NULL,'null',0),(26,1,0,1,-1.127228,37.012305,'Unnamed Road, Juja, , Kenya','Nakuru Teachers',171.82,'Senguon Zakhurtu','Parcel','0725368600',-0.286980,36.068370,-1.105904,37.017282,-0.303835,36.080308,0,0,0.00,0.00,1,2,277,'2021-02-25 06:59:44',1,1,1,859.10,NULL,NULL,'dhamini.logitech@gmail.com',0,0,0,NULL,'2,16',0),(27,1,303,1,-1.091514,37.025258,'Unnamed Road, Juja, , Kenya','thika',11.68,'Wambui','Books','0727567938',-1.038757,37.083375,-1.090953,37.024434,-1.067906,37.050593,0,0,0.00,0.00,1,274,1,'2021-02-27 00:00:00',1,1,1,5.00,NULL,NULL,'mercienest@gmail.com',0,0,0,NULL,'',0),(28,1,58,1,-1.090713,37.025558,'Unnamed Road, Juja, , Kenya','ruiru',11.20,'Wambui','Books','0727567938',-1.148250,36.960453,-1.090953,37.024434,-1.105904,37.017282,0,0,0.00,0.00,1,274,2,'2021-02-27 00:00:00',1,1,1,5.00,NULL,NULL,'mercienest@gmail.com',0,0,0,NULL,'',0),(29,1,472,1,-1.091317,37.025224,'Unnamed Road, Juja, , Kenya','juja',2.12,'Eric','books','0727567938',-1.101822,37.014403,-1.090953,37.024434,-1.090953,37.024434,0,0,0.00,0.00,1,274,274,'2021-02-27 00:00:00',2,3,2,5.00,NULL,NULL,'eric.mwash91@gmail.com',0,0,0,NULL,'',0),(30,1,474,1,-1.091509,37.025260,'Unnamed Road, Juja, , Kenya','thika',11.68,'caro','bk','0717748452',-1.038757,37.083375,-1.090953,37.024434,-1.034606,37.076389,0,0,0.00,0.00,1,274,456,'2021-03-04 11:57:21',1,1,1,58.38,NULL,NULL,'eric.mwash91@gmail.com',0,0,0,NULL,'13,45',0),(31,1,0,1,-0.939971,37.125411,'Dream Pearl, , , Kenya','thika',16.50,'Carol muita','parcel','0790908882',-1.038757,37.083375,-0.936780,37.122529,-1.028834,37.066202,0,0,0.00,0.00,1,460,78,'2021-03-04 00:00:00',2,1,1,5.00,NULL,NULL,'anntracy150@gmail.com',0,0,0,NULL,'',0),(32,1,0,1,-1.035913,37.075035,'Biashara, Thika, , Kenya','Ruaka',46.48,'Rachel Tanui','Goods','0725365148',-1.205604,36.779606,-1.067906,37.050593,-1.210337,36.895801,0,0,0.00,0.00,1,1,317,'2021-03-09 14:55:19',2,3,2,870.29,NULL,NULL,'dhamini.logitech@gmail.com',0,0,0,NULL,'1,45,38',0),(33,1,0,1,-1.035584,37.074169,'Thika, Thika, , Kenya','Ruiru',20.84,'Eric','Books ','0727567938',-1.148250,36.960453,-1.067906,37.050593,-1.147764,36.960340,0,0,0.00,0.00,1,1,222,'2021-03-12 10:46:14',1,3,1,20.84,NULL,NULL,'eric.mwash91@gmail.com',0,0,0,NULL,'1,45,12',0),(34,1,0,1,-1.102895,37.016181,'JKUAT Exit Road, Muchatha, , Kenya','thika',12.97,'b','bags','0790222312',-1.038757,37.083375,-1.067906,37.050593,-1.034606,37.076389,0,0,0.00,0.00,1,1,456,'2021-03-16 21:51:21',1,1,1,345.02,NULL,NULL,'jallowma7@gmail.com',0,0,0,NULL,'1,5,45',0),(35,1,0,1,-1.127188,37.012259,'Unnamed Road, Juja, , Kenya','Kibera',38.25,'Fredrik Kimanzi','Goods','0723521453',-1.311485,36.787948,-1.147764,36.960340,-1.210337,36.895801,0,0,0.00,0.00,1,222,317,'2021-03-19 05:23:57',1,1,2,315.55,NULL,NULL,'dhamini.logitech@gmail.com',0,0,0,NULL,'12,38',0),(36,1,0,1,-1.036524,37.075392,'11, Thika, , Kenya','Kayole',46.92,'Zablon Nyakundi','Cutlery goods','0714760706',-1.277394,36.915798,-1.067906,37.050593,-1.278366,36.908422,0,0,0.00,0.00,1,1,289,'2021-03-19 10:21:52',2,3,2,426.22,NULL,3,'dhamini.logitech@gmail.com',0,0,0,NULL,'1,45,24',0),(37,1,0,1,-1.036524,37.075392,'11, Thika, , Kenya','Kayole',46.92,'Zablon Nyakundi','Cutlery goods','0714760706',-1.277394,36.915798,-1.067906,37.050593,-1.278366,36.908422,0,0,0.00,0.00,1,1,289,'2021-03-19 10:28:54',2,3,2,426.22,NULL,3,'dhamini.logitech@gmail.com',0,0,0,NULL,'1,45,24',0),(38,1,0,1,-1.036524,37.075392,'11, Thika, , Kenya','Kayole',46.92,'Zablon Nyakundi','Cutlery goods','0714760706',-1.277394,36.915798,-1.067906,37.050593,-1.278366,36.908422,0,0,0.00,0.00,1,1,289,'2021-03-19 10:31:53',2,3,2,426.22,NULL,3,'dhamini.logitech@gmail.com',0,0,0,NULL,'1,45,24',0),(39,1,0,1,-1.036524,37.075392,'11, Thika, , Kenya','Kayole',46.92,'Zablon Nyakundi','Cutlery goods','0714760706',-1.277394,36.915798,-1.067906,37.050593,-1.278366,36.908422,0,0,0.00,0.00,1,1,289,'2021-03-19 10:42:48',2,3,2,426.22,NULL,3,'dhamini.logitech@gmail.com',0,0,0,NULL,'1,45,24',0),(40,1,0,1,-1.036524,37.075392,'11, Thika, , Kenya','Kayole',46.92,'Zablon Nyakundi','Cutlery goods','0714760706',-1.277394,36.915798,-1.067906,37.050593,-1.278366,36.908422,0,0,0.00,0.00,1,1,289,'2021-03-19 10:53:13',2,3,2,426.22,NULL,3,'dhamini.logitech@gmail.com',0,0,0,NULL,'1,45,24',0),(41,1,0,1,-1.036534,37.075388,'11, Thika, , Kenya','Buruburu',45.63,'Zablon Nyakundi','Cutlery goods','0714760706',-1.294903,36.884972,-1.067906,37.050593,-1.286009,36.880062,0,0,0.00,0.00,1,1,293,'2021-03-19 10:58:05',2,3,2,414.43,NULL,3,'dhamini.logitech@gmail.com',0,0,0,NULL,'1,45,28',0);

--
-- Table structure for table `order_status_a`
--

CREATE TABLE `order_status_a` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `statusName` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `order_status_a`
--

INSERT INTO `order_status_a` VALUES (1,'Submitted Request.','Customer submitted request.'),(2,'Boda Agent arrived at customer location.','Boda Agent arrived at customer location.'),(3,'Customer dispatched goods to Boda agent.','Customer dispatched goods to Boda agent.'),(4,'Boda agent accepts dispatched goods from customer','Boda agent accepts dispatched goods from customer'),(5,'Boda agent arrived at Pick Up collection center.','Boda agent arrived at Pick Up collection center.'),(6,'Boda Agent dispatched goods to Pick Up  Collection Center agent.','Senior Supa Boda agent arrives at Pick Up Collection center.'),(7,'Pick Up Collection center agent accepts dispatched goods from Boda agent.','Pick Up Collection center agent accepts dispatched goods from Boda agent.'),(8,'Senior Supa Boda agent arrives at Pick Up Collection center.','Pick Up Collection center agent dispatched goods to Supa Boda agent.'),(9,'Supa Boda agent arrives at Pick Up Collection center.','Supa Boda agent arrives at Pick Up Collection center.'),(10,'Boda agent arrived at Pick Up Collection center.','Boda agent arrived at Pick Up Collection center.'),(11,'\r\nPick Up Collection Center Agent dispatched goods to Senior Supa Boda','Pick Up Collection Center Agent dispatched goods to Senior Supa Boda'),(12,'\r\nPick Up Collection Center Agent dispatched goods to Supa Boda','\r\nPick Up Collection Center Agent dispatched goods to Supa Boda'),(13,'\r\nPick Up Collection Center Agent dispatched goods to Boda Agent','\r\nPick Up Collection Center Agent dispatched goods to Boda Agent'),(14,'Senior Supa Boda agent accepted goods from Pick Up Collection Center','Senior Supa Boda agent accepted goods from Pick Up Collection Center'),(15,'Supa Boda agent accepted goods from Pick Up Collection Center','Supa Boda agent accepted goods from Pick Up Collection Center'),(16,'Boda agent accepted goods from Pick Up Collection Center','Boda agent accepted goods from Pick Up Collection Center'),(17,'Senior Supa Boda agent arrived at Major Collection Center.','Senior Supa Boda agent arrived at Major Collection Center.'),(18,'Supa Boda agent arrived at Main Collection Center.','Supa Boda agent arrived at Main Collection Center.'),(19,'Boda agent arrived at Normal Collection Center.','Boda agent arrived at Normal Collection Center.'),(20,'Senior Supa Boda agent Dispatched goods to Major Collection Center agent.','Senior Supa Boda agent Dispatched goods to Major Collection Center agent.'),(21,'Supa Boda agent Dispatched goods to Main Collection Center agent.','Supa Boda agent Dispatched goods to Main Collection Center agent.'),(22,'Normal Boda agent Dispatched goods to Normal Collection Center agent.','Normal Boda agent Dispatched goods to Normal Collection Center agent.'),(23,'Major Collection  Center agent accepts goods from Senior,Supa or normal Boda agent','Major Collection  Center agent accepts goods from Senior,Supa or normal Boda agent'),(24,'Main Collection  Center agent accepts goods from Senior,Supa or normal Boda agent','Main Collection  Center agent accepts goods from Senior,Supa or normal Boda agent'),(25,'Normal Collection  Center agent accepts goods from Senior,Supa or normal Boda agent','Normal Collection  Center agent accepts goods from Senior,Supa or normal Boda agent'),(26,'Delivery  Center accepted Goods from Senior,Supa or normal Boda agent.','Delivery  Center accepted Goods from Senior,Supa or normal Boda agent.'),(27,'Senior,Supa or normal Boda agent arrived at Delivery Collection Center.','Senior,Supa or normal Boda agent arrived at Delivery Collection Center.'),(28,'Delivery Center Dispatched goods to Senior,Supa or normal Boda agent','Delivery Center Dispatched goods to Senior,Supa or normal Boda agent'),(29,'Senior,Supa or normal Boda agent accepted goods from Delivery Center','Senior,Supa or normal Boda agent accepted goods from Delivery Center'),(30,'Senior,Supa or normal Boda agent arrived at recipient location.','Senior,Supa or normal Boda agent arrived at recipient location.'),(31,'Senior,Supa or normal Boda agent Dispatched to recipient.','Senior,Supa or normal Boda agent Dispatched to recipient.'),(32,'recipient acepted goods from Senior,Supa or normal Boda agent','recipient acepted goods from Senior,Supa or normal Boda agent');

--
-- Table structure for table `order_status_b`
--

CREATE TABLE `order_status_b` (
  `int` int(10) NOT NULL AUTO_INCREMENT,
  `statusName` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`int`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `order_status_b`
--


--
-- Table structure for table `order_status_c`
--

CREATE TABLE `order_status_c` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `statusName` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `order_status_c`
--


--
-- Table structure for table `order_status_d`
--

CREATE TABLE `order_status_d` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `statusName` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `order_status_d`
--


--
-- Table structure for table `paidordersA`
--

CREATE TABLE `paidordersA` (
  `id` int(15) NOT NULL AUTO_INCREMENT,
  `amount` decimal(10,2) DEFAULT NULL,
  `dateTimePaid` varchar(20) DEFAULT NULL,
  `mPesaRefNo` varchar(20) DEFAULT NULL,
  `payerPhone` varchar(20) DEFAULT NULL,
  `orderId` int(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `paidordersA`
--


--
-- Table structure for table `paidsignups`
--

CREATE TABLE `paidsignups` (
  `id` int(15) NOT NULL AUTO_INCREMENT,
  `IDNumber` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `dateTimePaid` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `mPesaRefNo` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `paidsignups`
--


--
-- Table structure for table `payer_categories`
--

CREATE TABLE `payer_categories` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `payerCategoryName` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `payerCategoryDescription` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `payer_categories`
--

INSERT INTO `payer_categories` VALUES (1,'Customer Payer','Customer Payer'),(2,'Recipient Payer','Recipient Payer');

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `settingName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `settingDescription` text COLLATE utf8_unicode_ci NOT NULL,
  `settingCost` decimal(15,2) DEFAULT NULL,
  `costOfDeliveryAndPickUpAgents` decimal(10,2) NOT NULL,
  `noOfCentersConstant` decimal(10,2) NOT NULL DEFAULT '0.00',
  `noOfSnrAndSupaConstant` decimal(10,2) NOT NULL DEFAULT '0.00',
  `noOfMainAndMajorCentersConstant` decimal(10,2) NOT NULL,
  `costPerVehicle` decimal(10,2) NOT NULL,
  `averageDistanceBetweenCentersKms` decimal(5,2) NOT NULL,
  `secondLastConst` decimal(5,2) NOT NULL,
  `lastConst` decimal(5,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` VALUES (1,'constants','All Constants for use in the system',10.50,50.00,15.00,30.00,10.00,100.00,20.00,65.00,39.00);

--
-- Table structure for table `shop_agents_details`
--

CREATE TABLE `shop_agents_details` (
  `staffID` int(5) NOT NULL,
  `nextOfKinFullName` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `nextOfKinRelationship` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `nextOfKinPhone` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `alias` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `businessName` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `countyLocation` varchar(200) DEFAULT NULL,
  `subCountyLocation` varchar(200) DEFAULT NULL,
  `businessType` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `businessRegNo` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `businessOperationPeriodMonths` int(5) DEFAULT NULL,
  `bsNoOfDailyCustomers` int(5) DEFAULT NULL,
  `bsMonthlyRent` decimal(15,2) DEFAULT NULL,
  `bsNoOfEmployees` int(5) DEFAULT NULL,
  `regFeeMpesaRefNo` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `regFeeMpesaAccNo` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `regFeeMpesaAmt` decimal(12,2) DEFAULT NULL,
  `regFeeMpesaReceiptNo` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `regFeePaymentApproach` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `regFeeDailyPaymentMethod` int(3) DEFAULT NULL,
  `regFeeLaterPaymentDate` datetime DEFAULT NULL,
  `regFeeLaterPaymentReason` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `commissionPaymentOption` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `commissionPaymentBankOptionBankName` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `commissionPaymentBankOptionBankBranch` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `commissionPaymentBankOptionBankAccountNo` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `commissionMpesaNo` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `dateCreated` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `shop_agents_details`
--

INSERT INTO `shop_agents_details` VALUES (35,'Ggghvf','Ggghvc','07854213952','Gggn','Fgg cjvf',NULL,NULL,'Fgghb','Dfvcgbbv',24,24,24000.00,24,'TYURRYUI','Gfggbb',100.00,'45872','Partial Payment',NULL,NULL,'','M-PESA','','','','07854236521','2021-02-15 07:57:02'),(78,'Victoria Gathoni ','friend','0724586869','kira','amka',NULL,NULL,'Shop','w9000hyvb',24,50,5000.00,25000,'pbf34j678','sheila',50.00,'253698','Partial Payment',NULL,NULL,'','M-PESA','','','','0714714319','2021-02-16 20:52:18'),(128,'Author Wadaka','Husband','0746532243','Abi','kimex',NULL,NULL,'Shop ','0001',24,50,15000.00,1,'pbh3rcv7u4','aubrey',500.00,'888','One Off Payment- Ksh 500.',NULL,NULL,'','M-PESA','','','','0714594933','2021-02-18 15:30:50'),(216,'Anna','sister','0752356214','Alvo','Wanjia',NULL,NULL,'shop','005',21,20,10000.00,1,'pbj1hrthyu','Alvin',500.00,'333','One Off Payment- Ksh 500.',NULL,NULL,'','M-PESA','','','','0745123698','2021-02-21 13:17:46'),(217,'saga ','friend','085236412','Sandy','Dandy ',NULL,NULL,'shop ','009',36,50,20000.00,1,'phujiko3457','saga',50.00,'222','Partial Payment',NULL,NULL,'','M-PESA','','','','0745123698','2021-02-21 17:23:47'),(218,'swings','sister','0796852314','sis','twinz',NULL,NULL,'clothes','889',24,30,5000.00,1,'tuyhsn36901','sis',100.00,'663','Partial Payment',NULL,NULL,'lack of funds ','M-PESA','','','','0754236159','2021-02-21 17:37:57'),(219,'June','Wife','0769365214','Sam','Washa',NULL,NULL,'welding','222',23,40,10000.00,2,'gaub63017','Wesley',100.00,'223','Partial Payment',NULL,NULL,'','M-PESA','','','','0789562314','2021-02-21 17:41:12'),(220,'Esther ','friend ','0740404542','Moha','Wadau',NULL,NULL,'Grocery ','667',12,20,2500.00,1,'tde57733du8','Ali',500.00,'33','One Off Payment- Ksh 500.',NULL,NULL,'','M-PESA','','','','0722558863','2021-02-21 17:45:56'),(221,'Sally','Wife','0745458456','Luke','Waseli',NULL,NULL,'Shop','889',30,50,10000.00,366,'agye84971j','Luke ',500.00,'369','One Off Payment- Ksh 500.',NULL,NULL,'','M-PESA','','','','0752364125','2021-02-21 17:54:42'),(222,'Dan','husband ','0796365487','Sue','thirty',NULL,NULL,'retail','557',23,50,25000.00,2,'ry5wevutrv','Sue ',500.00,'222','One Off Payment- Ksh 500.',NULL,NULL,'','M-PESA','','','','0798653214','2021-02-21 19:26:32'),(274,'Naomi Wangari','wife','0724153100','Mike','Miketech electronics',NULL,NULL,'electronics shop','081089',5,2,10000.00,2,'PB02ZZXL94','Micheal wahome',100.00,'1','Partial Payment',NULL,NULL,'','M-PESA','','','','0714185868','2021-02-24 20:13:11'),(275,'Thomas Kinyua','Uncle','0714253698','Okumu','Wholesale shop',NULL,NULL,'Wholesale','3454477',24,50,24000.00,24,'RT456676ER','Nicholas',23000.00,'875','Partial Payment',NULL,NULL,'','Bank Account','Nicholas','Kitale','0872539874250','0725365289','2021-02-25 05:13:18'),(276,'Shamimah','Aunt','0725368521','Abu','Shakur Shop',NULL,NULL,'Car Dealer','TYU568YUIO',24,50,5200.00,35,'TYRU56775RTY','Shakur Abubakar',100.00,'5','Partial Payment',NULL,NULL,'','M-PESA','','','','0725652145','2021-02-25 05:20:52'),(277,'Talam Sigoyi','Nephew','0725365214','Talo','Talam Shop',NULL,NULL,'Retail shop','None',25,36,3200.00,20,'TYUI5668YUW','Talam',100.00,'9','Partial Payment',NULL,NULL,'','M-PESA','','','','0725365214','2021-02-25 05:25:16'),(278,'Nancy Njeri','wife','0723500292','Sam Dominion','Dominion Ventures',NULL,NULL,'wholesale/retail','742613',6,3,18000.00,3,'PBPIIV55ZH','Njau',50.00,'1','Partial Payment',NULL,NULL,'','Bank Account','Cooperative bank','Zimmerman','01109284067700','','2021-02-25 09:09:56'),(279,'Derrick Mogire','Brother','0700025390','Janet','Babyshop',NULL,NULL,'baby shop','1706322',3,1,15000.00,1,'PBP325QWCB','Janet',50.00,'1','Partial Payment',NULL,NULL,'','M-PESA','','','','0715841013','2021-02-25 13:34:07'),(284,'Joseph Mbugua','Husband','0724230280','Nancy','Hinga Stores',NULL,NULL,'shop','1447856',5,1,12000.00,1,'PBQ23404RD','Nancy',50.00,'1','Partial Payment',NULL,NULL,'','M-PESA','','','','0724866978','2021-02-26 09:01:55'),(285,'Robert Kanyi','Employer','0722811443','Kim','Eastgate carwash',NULL,NULL,'Carwash and carpets','1296235',9,10,40000.00,10,'PBQ337MDL7','Micheal Kimani',50.00,'1','Partial Payment',NULL,NULL,'','M-PESA','','','','0722811443','2021-02-26 10:33:31'),(286,'John Tochi','Brother','0713703400','Lawrence','Clixed Photos',NULL,NULL,'Photo studio','1743346',3,1,7000.00,1,'PBQ23B8YD8','Nyamumbo',50.00,'1','Partial Payment',NULL,NULL,'','M-PESA','','','','0742606307','2021-02-26 11:59:57'),(287,'John Kanyuru','Husband','072227740','Susan','Poa Pay Investments',NULL,NULL,'Sale of electronics','151634',15,1,15000.00,1,'PBQ23D7EE6','Susan',50.00,'1','Partial Payment',NULL,NULL,'','M-PESA','','','','0721478917','2021-02-26 12:43:13'),(288,'Samuel Mburu','partner','0763275530','Whitehouse','Whitehouse enterprises',NULL,NULL,'sale/repair of electronics','66243',17,2,7000.00,2,'PBQ43GMTO4','John',50.00,'1','Partial Payment',NULL,NULL,'','M-PESA','','','','0720575530','2021-02-26 14:02:34'),(289,'Dishon Maina','Dad','0781229049','Maish','Super Five Shop',NULL,NULL,'Retail shop','1574410',3,100,15000.00,1,'PBQ73IEE5N','Isaac Maina',50.00,'1','Partial Payment',NULL,NULL,'','M-PESA','','','','0704155039','2021-02-26 14:41:33'),(290,'Jeff Makori','Partner','0721549608','MJ','MJ Signs',NULL,NULL,'Electronics','1564417',3,2,15000.00,2,'PBQ43L634W','Victoy',50.00,'1','Partial Payment',NULL,NULL,'','M-PESA','','','','0726022902','2021-02-26 15:44:51'),(291,'Gicege Guto','Husband','0721546196','Guro','Guro company',NULL,NULL,'shop/mpesa','151452',12,1,10000.00,1,'PBQ63MY37C','Bosibori',50.00,'1','Partial Payment',NULL,NULL,'','M-PESA','','','','0710840281','2021-02-26 16:23:47'),(292,'Lilian Achieng','wife','0701164784','Joshua','Sigma Cyber',NULL,NULL,'cyber','150440',3,1,9000.00,1,'PBQ93PCDW9','Joshua',50.00,'1','Partial Payment',NULL,NULL,'','M-PESA','','','','072055412','2021-02-26 17:12:51'),(293,'Daniel Kacivu','partner','0759584162','JI','Jirani one Kenya ltd',NULL,NULL,'Drawings and painting','154121',2,10,7000.00,10,'PBQ93TIHIJ','David',50.00,'1','Partial Payment',NULL,NULL,'','M-PESA','','','','0710413569','2021-02-26 18:30:09'),(294,'Phoebe Otieno','Friend','0708695882','Cynthia','Port Florence Ventures',NULL,NULL,'Juice parlor','1517747',1,1,10000.00,1,'PBR34H3PEZ','Cynthia',50.00,'1','Partial Payment',NULL,NULL,'','M-PESA','','','','0112521973','2021-02-27 10:18:54'),(295,'Richard','Cousin','0701409934','Dan','Amberjoy Cyber',NULL,NULL,'Cyber ','1725445',4,1,7000.00,1,'PBR14JQAAR','Danny',50.00,'1','Partial Payment',NULL,NULL,'','M-PESA','','','','0720829626','2021-02-27 11:18:54'),(296,'John Nzuli','Brother','0101768205','Jack','Jack creatives',NULL,NULL,'Cyber','174168',3,1,3000.00,1,'PBR24N3GM4','Jackson',50.00,'1','Partial Payment',NULL,NULL,'','M-PESA','','','','0706205768','2021-02-27 12:33:09'),(298,'Winnie Nzioka','Spouse','0776615042','Mwatu','Steltech cyber',NULL,NULL,'cyber cafe','1217556',10,1,27000.00,1,'PBR94R6C1J','Urbanus',50.00,'1','Partial Payment',NULL,NULL,'','M-PESA','','','','0721606894','2021-02-27 14:00:14'),(299,'John Waweru','Spouss','0705183080','Mama caleb','Jomeca shop',NULL,NULL,'Retail shop','1396308',4,1,15000.00,1,'PBR34XXB5J','Mercy',50.00,'1','Partial Payment',NULL,NULL,'','M-PESA','','','','0713439693','2021-02-27 16:18:29'),(300,'Reuben muriithi','Brother','0711115552','Wizzy','Wizzy Investments',NULL,NULL,'Mpesa,kcb and Equity agent','1574421',4,4,10000.00,4,'PBR550PU1','Duncan',50.00,'1','Partial Payment',NULL,NULL,'','M-PESA','','','','0726080574','2021-02-27 17:10:50'),(301,'Salome Wanjiku','Spouse','0725917231','Icotec','Icotec',NULL,NULL,'cyber','096297',10,2,15000.00,2,'PBR950TRV7','Esbon Mwangi',50.00,'1','Partial Payment',NULL,NULL,'','M-PESA','','','','0725281856','2021-02-27 18:08:07'),(302,'Friday Kaaria','sister','0723820034','Roy','Kahawa bookshop',NULL,NULL,'cyber & bookshop','105905',12,200,30000.00,3,'PBR7563P53','Roy kimaita',500.00,'1','One Off Payment- Ksh 500.',NULL,NULL,'','Bank Account','Cooperative bank','Githurai','01192156469500','','2021-02-27 18:50:21'),(316,'Alfred Mwaura','Spouse','0720284116','Betty','Syles and smiles salon',NULL,NULL,'Salon','1452400',4,8,28000.00,5,'PC1771JSSJ','Beatrice',50.00,'1','Partial Payment',NULL,NULL,'','M-PESA','','','','0702442678','2021-03-01 10:41:28'),(317,'Mercy Nyawira','Sister','0706892238','Sam','Cyber, Zimmerman',NULL,NULL,'cyber','172412',3,20,10000.00,1,'PC15754N5B','Kanja',50.00,'1','Partial Payment',NULL,NULL,'No money at the moment ','M-PESA','','','','0701123259','2021-03-01 11:58:48'),(325,'Yvonne Nyakio','Girlfriend','0700304449','Paul','Kahawa.West station bookshop',NULL,NULL,'bookshop','1504093',3,50,10000.00,1,'PC18789ZG8','Mbatha',50.00,'1','Partial Payment',NULL,NULL,'','M-PESA','','','','0711318567','2021-03-01 13:15:14'),(332,'James Waigwa','spouse','0700280060','Rahab','Sort IT Enterprise',NULL,NULL,'cyber','058284',5,200,23500.00,1,'-123','Rahab',500.00,'1','To Pay Later',NULL,NULL,'Trust issues','M-PESA','','','','0720969948','2021-03-01 14:24:43'),(440,'Damaris Wairimu','spouse','0726293826','Nene','Jordan merchant hardware',NULL,NULL,'Hardware','150721',2,30,15000.00,3,'PC208HSK3Y','Nene',100.00,'1','Partial Payment',NULL,NULL,'','M-PESA','','','','0723565268','2021-03-02 13:41:41'),(450,'Jackline Kamonya','Spouse','0719322396','Shem','BM WHOLESALERS',NULL,NULL,'Wholesale','157177',6,200,8500.00,7,'PC329MOS2G','Shem',100.00,'1','Partial Payment',NULL,NULL,'','M-PESA','','','','0723651322','2021-03-03 10:15:42'),(453,'Samuel Gatimu ','son','0728001190','Faite','Harok enterprises',NULL,NULL,'General shop','152300',4,100,5000.00,1,'PC359VIPJ3','Elizabeth',50.00,'1','Partial Payment',NULL,NULL,'','M-PESA','','','','0706783575','2021-03-03 13:41:25'),(456,'Salome Wanjiku','mother','0728991634','Carol','Neema households',NULL,NULL,'General shop','150150',7,50,18000.00,3,'PC39A4GZZ9','Caroline',50.00,'1','Partial Payment',NULL,NULL,'','Bank Account','Equity','Thika ','0090193012134','0711947997','2021-03-03 16:54:18'),(460,'Susan Wanjiru','spouse','0703289272','Kariuki','Voskeytech Cyber',NULL,NULL,'Cyber','160151',2,30,7000.00,2,'PC47AXXGRN','Kelvin',50.00,'1','Partial Payment',NULL,NULL,'','M-PESA','','','','0719759646','2021-03-04 10:11:12'),(477,'Lewis Rampei','spouse','0769606054','Ivon','Zigzag Cyber',NULL,NULL,'cyber','043781',3,50,10000.00,1,'PC67DN43YP','Ivon',50.00,'1','Partial Payment',NULL,NULL,'','M-PESA','','','','0794209980','2021-03-06 11:02:35'),(478,'Diana Akuti','Spouse','0705004689','Alex','Kinyozi Maalum',NULL,NULL,'Kinyozi','160181',8,15,15000.00,1,'PC62DUANR4','Alex',50.00,'1','Partial Payment',NULL,NULL,'','M-PESA','','','','0759317485','2021-03-06 13:31:42'),(506,'Philip Sande','Brother','07000000','','Abeingo',NULL,NULL,'Retail','001',60,50,15000.00,2,'PBS465WELG','MANGALA SILAS',50.00,'1','Partial Payment',NULL,NULL,'','M-PESA','','','','0795883732','2021-03-09 10:51:17'),(507,'Philip Sande','Brother','07000000','','Abeingo',NULL,NULL,'Retail','001',60,50,15000.00,2,'PBS465WELG','MANGALA SILAS',50.00,'1','Partial Payment',NULL,NULL,'','M-PESA','','','','0795883732','2021-03-09 10:51:20'),(673,'wesly','cousin','07088888','salim','shopsy',NULL,NULL,'shop','009',30,50,12000.00,2,'pyt567hgfb','salim ',50.00,'2','Partial Payment',NULL,NULL,'','M-PESA','','','','0788888888','2021-03-18 18:09:23');

--
-- Table structure for table `staffcategories`
--

CREATE TABLE `staffcategories` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `staffCategoryName` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `dateCreated` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `staffcategories`
--

INSERT INTO `staffcategories` VALUES (1,'Collection Center Staff.','This Staff Category consists of All Staff attached to a collection center.','2021-01-06 10:38:33'),(2,'Boda boda Category.','This Staff Category consists of Collection And Delivery Agents.','2021-01-06 10:40:33'),(3,'Super Boda Agent Staff.','Super Boda Agent Staff.','2021-01-10 03:32:39'),(4,'Admin staff.','Admin staff.','2021-01-11 02:27:27'),(5,'Senior Super Boda Agent Staff.','Senior Super Boda Agent Staff.','2020-12-24 14:24:32'),(6,'Main Collection Center Staff.','Main Collection Center Staff.','2021-01-05 10:33:33');

--
-- Table structure for table `subCounties`
--

CREATE TABLE `subCounties` (
  `subCountyID` int(3) NOT NULL AUTO_INCREMENT,
  `countyID` int(3) DEFAULT NULL,
  `subCountyName` varchar(35) DEFAULT NULL,
  PRIMARY KEY (`subCountyID`)
) ENGINE=InnoDB AUTO_INCREMENT=150 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `subCounties`
--

INSERT INTO `subCounties` VALUES (1,1,'Mvita'),(2,1,'Jomvu'),(3,1,'Changamwe'),(4,1,'Kisauni'),(5,1,'Nyali'),(6,1,'Likoni'),(7,2,'Matuga'),(8,2,'Lungalunga'),(9,2,'Kinango'),(10,2,'Msambweni'),(11,3,'Kilifi'),(12,3,'Ganze'),(13,3,'Malindi'),(14,3,'Magarini'),(15,3,'Rabai'),(16,3,'Kaloleni'),(17,4,'Bura'),(18,4,'Galole'),(19,4,'Garsen'),(20,5,'Lamu West'),(21,5,'Lamu West'),(22,6,'Voi'),(23,6,'Mwatate'),(24,6,'Wundanyi'),(25,6,'Taveta'),(26,7,'Fafi'),(27,7,'Garissa'),(28,7,'Ijara'),(29,7,'Lagdera'),(30,7,'Balambala'),(31,7,'Dadaab'),(32,7,'Hulugho'),(33,8,'Wajir East'),(34,8,'Wajir West'),(35,8,'Wajir North'),(36,8,'Wajir South'),(37,8,'Eldas'),(38,8,'Tarbaj'),(39,9,'Mandera West'),(40,9,'Mandera South'),(41,9,'Banissa'),(42,9,'Mandera North'),(43,9,'Mandera East'),(44,9,'Lafey'),(45,10,'Marsabit Central'),(46,10,'Marsabit South(Laisamis)'),(47,10,'Marsabit North(Chalbi)'),(48,10,'Loiyangalani'),(49,10,'North Horr'),(50,10,'Moyale'),(51,10,'Sololo'),(52,11,'Isiolo'),(53,11,'Merti'),(54,11,'Garbatulla'),(55,12,'Igembe North'),(56,12,'Igembe Central'),(57,12,'Igembe South'),(58,12,'Tigania East'),(59,12,'Tigania West'),(60,12,'Buuri'),(61,12,'Imenti Central'),(62,12,'Imenti South'),(63,12,'Imenti North'),(64,13,'Tharaka North'),(65,13,'Tharaka South'),(66,13,'Chuka'),(67,13,'Igambangombe'),(68,13,'Muthambi'),(69,13,'Maara'),(70,14,'Kitui Central'),(71,14,'Kitui West'),(72,14,'Kitui East'),(73,14,'Kitui North'),(74,14,'Kitui Rural'),(75,14,'Mwingi North'),(76,14,'Mwingi Central'),(77,14,'Mwingi West'),(78,15,'Embu West'),(79,15,'Embu North'),(80,15,'Embu East'),(81,15,'Mbeere North'),(82,15,'Mbeere South'),(83,16,'Mwala'),(84,16,'Kathiani'),(85,16,'Machakos Town'),(86,16,'Mavoko'),(87,17,'Makueni'),(88,17,'Kaiti'),(89,17,'Kilome'),(90,17,'Kibwezi East'),(91,17,',Kibwezi West'),(92,17,'Mbooni'),(93,18,'Kinangop'),(94,18,'Kipipiri'),(95,18,'Ol Joro Orok'),(96,19,'Mathira East'),(97,19,'Mathira West'),(98,19,'Kieni East'),(99,19,'Kieni West'),(100,19,'Nyeri Town'),(101,19,'Mukurweini'),(102,19,'Othaya'),(103,19,'Tetu'),(104,20,'Kirinyaga East'),(105,20,'Kirinyaga West'),(106,20,'Mwea East'),(107,20,'Mwea West'),(108,20,'Kirinyaga Central'),(109,21,'Kiharu'),(110,21,'Mathioya'),(111,21,'Kangema'),(112,21,'Gatanga'),(113,21,'Kigumo'),(114,21,'Kandara'),(115,21,'Kahuro'),(116,21,'Muranga South'),(117,22,'Limuru'),(118,22,'Kikuyu'),(119,22,'Kabete'),(120,22,'Lari'),(121,22,'Gatundu South'),(122,22,'Gatundu North'),(123,22,'Githunguri'),(124,22,'Kiambu'),(125,22,'Kiambaa'),(126,22,'Ruiru'),(127,22,'Juja'),(128,22,'Thika Town'),(129,34,'Kajiado Central'),(130,34,'Kajiado North'),(131,34,'Loitokitok'),(132,34,'Isinya'),(133,34,'Mashuuru'),(134,47,'Dagoretti North,'),(135,47,'Dagoretti South'),(136,47,'Embakasi Central'),(137,47,'Embakasi East'),(138,47,'Embakasi South'),(139,47,'Embakasi West'),(140,47,'Kamukunji'),(141,47,'Kasarani'),(142,47,'Kibra'),(143,47,'Langata'),(144,47,'Makadara'),(145,47,'Mathare'),(146,47,'Roysambu'),(147,47,'Ruaraka'),(148,47,'Starehe'),(149,47,'Westlands');

--
-- Table structure for table `transaction_type`
--

CREATE TABLE `transaction_type` (
  `id` int(2) NOT NULL AUTO_INCREMENT,
  `txTypeName` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `transaction_type`
--

INSERT INTO `transaction_type` VALUES (1,'Send Goods/Items To Someone.','Sending Goods/Items To Someone. As the initiator of this request, you will pay for all the charges involved.'),(2,'Request For Goods/Items From Someone.','Requesting For Goods/Items From Someone.As the initiator of this request, you will pay for all the charges involved.'),(3,'Pick Up Goods/Items ','Pick Up Goods/Items'),(4,'Buy Goods/Items','Buy Goods/Items');

--
-- Table structure for table `usercategories`
--

CREATE TABLE `usercategories` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `userCategoryName` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `dateCreated` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `usercategories`
--

INSERT INTO `usercategories` VALUES (1,'Subscribed Users.','Subscribed Users.','2021-01-11 03:33:35'),(2,'Unsubscribed Users.','Unsubscribed Users.','2021-01-11 03:39:32');

--
-- Table structure for table `userlocations`
--

CREATE TABLE `userlocations` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `userId` int(20) NOT NULL,
  `locationLat` decimal(9,6) NOT NULL,
  `locationLong` decimal(9,6) NOT NULL,
  `description` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `userlocations`
--


--
-- Table structure for table `wards`
--

CREATE TABLE `wards` (
  `wardID` int(3) NOT NULL AUTO_INCREMENT,
  `subCountyID` int(3) DEFAULT NULL,
  `countyID` int(3) DEFAULT NULL,
  `wardName` varchar(35) DEFAULT NULL,
  PRIMARY KEY (`wardID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wards`
--



