--
-- Host: localhost    Database: logistics_test
-- ------------------------------------------------------


--
-- Table structure for table `batchedOrders`
--

CREATE TABLE `batchedOrders` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `batchID` varchar(20) DEFAULT NULL,
  `orderId` int(20) DEFAULT NULL,
  `orderStatusAId` int(3) DEFAULT NULL,
  `sendToCenterId` int(15) DEFAULT NULL,
  `sendToCenterName` varchar(100) DEFAULT NULL,
  `shopAgentID` int(20) DEFAULT NULL,
  `openForNotification` int(20) DEFAULT NULL,
  `lockedByStaffID` int(20) DEFAULT NULL,
  `collectionCenterID` int(20) DEFAULT NULL,
  `dateCreated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `batchedOrders`
--


--
-- Table structure for table `bodaCancelledOrders`
--

CREATE TABLE `bodaCancelledOrders` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `orderId` int(20) NOT NULL,
  `userId` int(20) NOT NULL,
  `cancelReason` text NOT NULL,
  `dateCreated` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bodaCancelledOrders`
--


--
-- 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,
  `regPayments` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `boda_agents_details` VALUES (38,'Jane Kaluhi','wife','0712233938','Nairobi CBD','KMFJ 583K','commercial accra',1,'0724036790','PBF70YREF',50.00,'','Partial Payment',1,NULL,'','M-PESA','','','','',0,1,1,'sanlam insurance',1,0,20000.00,1,NULL),(41,'Rahab wanjiru','mother','0722818466','Kirinyaga road','KMFJ 916W','Kirinyaga rd/voi rd',5,'PBF4P43084','EDWIN KINUTHIA',50.00,'005','Partial Payment',1,NULL,'','M-PESA','0727702141','','','',1,0,0,'',0,0,0.00,1,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,NULL),(50,'Esther Wanjiku','mother','0702243656','Zimmerman','KMEN 460c','Guru nanak',1,'PBG7Q1DJD7B','Stephen',50.00,'','Partial Payment',1,NULL,'','M-PESA','0705538928','','','',1,0,1,'Amaco',0,0,0.00,1,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,NULL),(52,'Mofart Nganga','son','0759001022','Guru Nanak ','KMEU 395M','Gurunanak',1,'PBG8Q2BOC8','Robert',50.00,'','Partial Payment',1,NULL,'','M-PESA','0722538969','','','',1,0,1,'Occidental',0,0,0.00,1,NULL),(53,'peninah waguthii njomo','wife','0792789468','.....','kmdj237f','country bus',1,'PBF9POT3QL','JOHN',50.00,'','Partial Payment',1,NULL,'','M-PESA','','','','',1,0,0,'',0,0,0.00,0,NULL),(54,'Nancy Muthoni','Wife','0717483316','Ngong','KMFJ 428E','Muthurwa',1,'PBF6P2FEVO','Samuel',50.00,'','Partial Payment',1,NULL,'','M-PESA','0746939335','','','',1,0,1,'Sanlam insurance',1,0,127800.00,1,NULL),(55,'zulfa natalia','wife','0712909066','Pangani','kmfd660d','Juja road',1,'PBG6Q5XCMI','JOHN',50.00,'','Partial Payment',1,NULL,'','M-PESA','','','','',0,0,1,'monarch',0,0,0.00,1,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,NULL),(57,'Jane njeri','mother','0718344517','Dandora','KMFB885P','Pangani chai rd',1,'PBG8Q5VYSE','Christom',50.00,'','Partial Payment',1,NULL,'','M-PESA','0705749803','','','',1,0,1,'Sanlam General',0,0,0.00,1,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,NULL),(71,'miriam juma','wife','0743639453','Umoja','kmfh557e','ramu house Eastleigh',1,'PBG9Q9RU6V','MENLICK',50.00,'','Partial Payment',1,NULL,'','M-PESA','0722783708','','','',1,0,1,'sanlam',0,0,0.00,1,NULL),(72,'Pamela Gathoni','wife','0705948376','Mlango Kubwa ','KMDU376L','Eastleigh',1,'PBG6Q8PBYC','lawrence',50.00,'','Partial Payment',1,NULL,'','M-PESA','0715989593','','','',1,0,0,'',0,0,0.00,1,NULL),(73,'petronila mwende','wife','0707506349','Huruma','KMFB 947Y','Eastleigh, Gallore ',1,'PBG9QC020T','Elphas Bardot',50.00,'','Partial Payment',1,NULL,'','M-PESA','0727169637','','','',0,0,1,'Amaco',0,0,0.00,1,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,NULL),(75,'Catherine Omia','wife','0701202815','Kayole','KMEL 969Z','8th street',1,'PBG5QES0E3','Francis',50.00,'','Partial Payment',1,NULL,'','M-PESA','','','','',0,0,1,'The monarch',0,0,0.00,1,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,NULL),(77,'Nancy Njambi','mother','0724854346','Kangemi','KMEZ914C','Kirinyaga rd',1,'PBF3P6L2R','Simon',50.00,'','Partial Payment',1,NULL,'','M-PESA','0706635579','','','',1,0,1,'The Monarch',0,0,0.00,1,NULL),(83,'Prudence Mukami','Daughter','0725548754','Githurai','KMEL 257X','posts githurai',1,'PBH3RBKFNH','Charles',50.00,'','Partial Payment',1,NULL,'','M-PESA','0717544678','','','',0,1,1,'Amaco',0,0,0.00,1,NULL),(84,'Tabitha Waweru','Mother','0716148752','Githurai ','KMEM 360F','POSTA Githurai ',1,'PBH9RBYBH5','Samuel',50.00,'','Partial Payment',1,NULL,'','M-PESA','0716199076','','','',1,0,1,'The monarch',0,0,0.00,1,NULL),(85,'Catherine','mother','0791634989','Githurai','KMEL 325Y','posts githurai',1,'PBHRB1PS6','Ian',50.00,'','Partial Payment',1,NULL,'','M-PESA','0791634989','','','',1,0,1,'monarch',0,0,0.00,1,NULL),(86,'Wanjiku','mother','0716199076','Githurai ','KMEZ910G','POSTA Githurai',1,'PBH2RCQUT1','Joseph',50.00,'','Partial Payment',1,NULL,'','M-PESA','0796034944','','','',1,0,1,'monarch',0,0,0.00,0,NULL),(87,'Julia mwende','mother','0796250697','Githurai','KMEU 177D','POSTA Githurai',1,'PBH3RDCRH7','Stephen ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0742912205','','','',1,0,1,'Monarch',0,0,0.00,1,NULL),(88,'Ruth Wambui','wife','0710405693','Githurai','KMER 717M','POSTA githurai',1,'PBH1RBCN2B','Paul',50.00,'','Partial Payment',1,NULL,'','M-PESA','0724178069','','','',1,0,0,'',0,0,0.00,0,NULL),(89,'Janerex Amunga','wife','0725735518','Githurai ','KMEB 679G','POSTA, Githurai',1,'PBH9RE9BOT','Peter',50.00,'','Partial Payment',1,NULL,'','M-PESA','0720603344','','','',1,0,1,'The monarch',0,0,0.00,1,NULL),(90,'Mary muthoni','Auntie','0725389711','Githurai','KMFA 568B','Posta, Githurai',1,'PBH8REZ440','David',50.00,'','Partial Payment',1,NULL,'','M-PESA','0712667847','','','',1,0,1,'The Monarch',0,0,0.00,1,NULL),(91,'elijahkamau','father','0723617529','Umoja 3','KMEH850D','MBC 6th street',1,'PBG3R2JIWZ','KELVIN',50.00,'','Partial Payment',1,NULL,'','M-PESA','','','','',1,0,0,'',0,0,0.00,1,NULL),(92,'Mercy wambui waweru','wife','0700266264','Githurai','KMED 600Z','Posta, Githurai',1,'PBH5RG3IOR','Robert',50.00,'','Partial Payment',1,NULL,'','M-PESA','0708227395','','','',1,0,1,'The Monarch',0,0,0.00,1,NULL),(93,'Pauline Wairimu','Wife','0723168409','Githurai ','KMEM 827C','Posta, Githurai',1,'PBH3RH9FJB','Thomas',50.00,'','Partial Payment',1,NULL,'','M-PESA','0723168409','','','',1,0,0,'',0,0,0.00,1,NULL),(94,'charles mwangi','brother','0719610772','Githurai 45','KMEP 289L','Githurai',1,'PBH5REDHGN','daniel',50.00,'','Partial Payment',1,NULL,'','Bank Account','','equity','githurai','0710179956385',1,0,1,'monarch',0,0,0.00,1,NULL),(100,'Francisca mwendwa','wife','0706150103','Githurai','kmew629h','githurai round about',20,'PBH7RJQAB9','Robert mugambi',50.00,'1','Partial Payment',1,NULL,'','M-PESA','0706150094','','','',1,0,1,'monarch',0,0,0.00,1,NULL),(108,'kelvin kiarie','brother ','0768762330','Zimmerman ','KMER 160H','githurai 45',160,'PBH4RMN32C','Felix waithera ',50.00,'2','Partial Payment',1,NULL,'','M-PESA','0713758443','','','',1,0,0,'',0,0,0.00,1,NULL),(109,'grace waithera','mother','0721738544','Githurai ','kmfb727b','Githurai 45',1,'PBH8RN4X1','kelvinwaithera',50.00,'2','Partial Payment',1,NULL,'','M-PESA','0768762330','','','',1,0,0,'',0,0,0.00,1,NULL),(121,'Benard Kioko','Dad','0710820142','Githurai 45','KMEL 578G','Githurai 45',1,'PBH6RFZ3A6','Daniel',50.00,'','Partial Payment',1,NULL,'','M-PESA','0724732994','','','',0,0,1,'The Monarch',0,0,0.00,1,NULL),(122,'Ian kinuthia','son','0768739691','Githurai 45','KMEG 361S','Githurai',1,'PBH6REZXMU','Francis',50.00,'','Partial Payment',1,NULL,'','M-PESA','0728200364','','','',1,0,1,'The Monarch',0,0,0.00,1,NULL),(123,'Nellius wambui','wife','0746792485','Githurai 45','KMEV 902Z','Githurai 45',1,'PBH7REJJ8Z','Gabriel',50.00,'','Partial Payment',1,NULL,'','M-PESA','0718266554','','','',1,0,1,'The Monarch',0,0,0.00,1,NULL),(124,'robert mutua','brother','0726302381','Toez','KMDA481J','TOEZ',1,'PBH7RQ27GJ','FESTUS',50.00,'','Partial Payment',1,NULL,'','M-PESA','0708528134','','','',1,0,0,'',0,0,0.00,1,NULL),(125,'Jane Wanjira','Mother','0723381163','Githurai','KMET 247X','Githurai 44',1,'PBI3SGBV61','Peter',50.00,'','Partial Payment',1,NULL,'','M-PESA','0799172173','','','',1,0,0,'',0,0,0.00,1,NULL),(127,'Nancy Muthoni','mother','0704922631','Githurai ','KMFJ 781L','Rware githurai',1,'PBI7SLB2W3','Shalom',50.00,'','Partial Payment',1,NULL,'','M-PESA','0758605923','','','',0,1,1,'Trident Insurance',0,0,0.00,0,NULL),(129,'jane Mwangi ','wife','0704223504','Githurai 45','KMEN 967T','GITHURAI 45',1,'PBH1RJY8PN','zachary ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0727518580','','','',1,0,1,'ALLYSON',0,0,0.00,1,NULL),(130,'james muiruri','brother','0724360943','Githurai 45','KMET 952Q','GITHURAI 45',1,'PBH7RKOFM3','ALEX',50.00,'','Partial Payment',1,NULL,'','M-PESA','0720671997','','','',1,0,1,'ALLYSON ',0,0,0.00,1,NULL),(131,'everlyne nyambura','sister','0715009105','Mumbi 45','KMEZ462C','GITHURAI 45',1,'PBH6RCDOGE','MARTIN',50.00,'','Partial Payment',1,NULL,'','M-PESA','0716363985','','','',1,0,1,'SHAMAM',0,0,0.00,1,NULL),(132,'Alice Wambui','Wife','0703470434','Githurai ','KMFG 833K','Kahawa',1,'PBI5SKIUQN','Simon Gitau',50.00,'','Partial Payment',1,NULL,'','M-PESA','0748925262','','','',0,0,1,'Sanlam General',1,1,4000.00,0,NULL),(133,'Tabitha ruguru','wife','0705583258','GitGithurai 45','KMFJ497E','GITHURAI 45',1,'PBH7RK39X5','SAMUEL',50.00,'','Partial Payment',1,NULL,'','M-PESA','0782980880','','','',1,0,1,'SANLAM',1,0,470.00,1,NULL),(134,'Margaret Scola','Mother','0723928941','Githurai ','KMFG 084D','Mambrose githurai',1,'PBH7RMP661','Daniel',50.00,'','Partial Payment',1,NULL,'','M-PESA','0769969247','','','',0,1,1,'Sanlam General',0,0,0.00,1,NULL),(135,'francis liruu','father','0706141858','Pangani','KMFF319P','JUJA B ESTATE',1,'PBG3Q80T5P','richard',50.00,'','Partial Payment',1,NULL,'','M-PESA','0757318044','','','',1,0,1,'MONARCH',0,0,0.00,1,NULL),(136,'Teresia Mwihaki','Wife','0791245388','Lunga Lunga ','KMFK337V','Third street',1,'PBG4QA5WMO','Samuel',50.00,'','Partial Payment',1,NULL,'','M-PESA','0726042215','','','',1,0,1,'SANLAM',0,0,0.00,1,NULL),(137,'Pogba','friend','00000','Eastleigh ','KMDU137Y','Eastleigh',1,'PBG3QGXTYF','John Nganga',50.00,'','Partial Payment',1,NULL,'','M-PESA','0700323779','','','',1,0,1,'N/A',0,0,0.00,1,NULL),(138,'Monicah Alex','Wife','0702637458','Eastleigh','KMDR588C','MJR Kinyanjui',1,'PBG3Q8PO3L','Alex ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0708885669','','','',1,0,1,'MONARCH ',0,0,0.00,1,NULL),(139,'Margaret Wamaitha','Wife','0799297158','Githurai','KMFM 575D','Thika',1,'PBJ1TRJ3MB','Antony',50.00,'','Partial Payment',1,NULL,'','M-PESA','0721117445','','','',1,0,1,'Sanlam General',0,0,0.00,1,NULL),(141,'Josephine Wangui','Wife','0757438024','Kibute','KMEG 686K','Soko,witeithie',11028,'PBJ7TWTAYN','Simon',100.00,'','Partial Payment',2,NULL,'','M-PESA','0700508917','','','',1,0,1,'Monarch',0,0,0.00,1,NULL),(142,'Pauline Wanjeri','Mother','0708286396','Maraba','KMFK 822J','Witeithie stage',2315,'PBJDUOD16U','Moses',50.00,'','Partial Payment',1,NULL,'','M-PESA','0111511273','','','',0,1,1,'Sanlam',0,0,0.00,1,NULL),(143,'Margaret Wainaina','Wife','0798589636','Maraba','KMEN 529N','Witeithie stage',5414,'PBJ7TR2HUR','Stanley',50.00,'','Partial Payment',1,NULL,'','M-PESA','072470319','','','',1,0,0,'',0,0,0.00,1,NULL),(144,'Grace Wangari','wife','0705678274','Maraba ','KMDG 842G','Witeithie stage',4629,'PBJ5TQFY4H','Bernard',50.00,'','Partial Payment',1,NULL,'','M-PESA','0795189037','','','',1,0,0,'',0,0,0.00,1,NULL),(145,'Lucy Njeri','Wife','0715117210','Maraba ','KMFC 689M','Kwa Mti, Witeithie',20056,'PBJ9TPHBY3','Duncan',100.00,'','Partial Payment',2,NULL,'','M-PESA','0727053982','','','',1,0,0,'',0,0,0.00,1,NULL),(146,'Maureen Wambui','Wife','0741901202','Maraba','KMEC 651N','Soko, weteithie',11035,'PBJ6TNNFQK','Brian',100.00,'','Partial Payment',2,NULL,'','M-PESA','0713932904','','','',0,1,0,'',0,0,0.00,1,NULL),(147,'Esther Mugure ','Mother','0710316805','Witeithie ','KMEW008X','Witeithie',1,'PBJ4TUEKXS','David ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0718885651','','','',0,1,1,'monarch ',0,0,0.00,1,NULL),(148,'Rachel Ngina','Wife','0722443889','Witeithie','KMFG143W','Witeithie Soko',1,'PBJ3TXW8X3','Daniel',50.00,'','Partial Payment',1,NULL,'','M-PESA','0714036859','','','',1,0,1,'SANLAM',0,0,0.00,1,NULL),(149,'Mbuvi','Son','000000','Witeithie ','KMEJ 969F','Witeithie Soko',1,'PBJ9TW11OH','Peter',50.00,'','Partial Payment',1,NULL,'','M-PESA','0721764247','','','',1,0,0,'',1,0,70000.00,1,NULL),(150,'Rose Waithera','Mother','0717726995','Witeithie ','KMFJ160M','Witeithie Soko',4767,'PBJ6TOWKQA','Paul',50.00,'','Partial Payment',1,NULL,'','M-PESA','0708743626','','','',1,0,0,'',0,0,0.00,1,NULL),(151,'Photensia Njoki','Wife','0719287566','Maraba','KMDW276L','Witeithie stage',1,'PBJ1TRG42N','John',50.00,'','Partial Payment',1,NULL,'','M-PESA','0794854684','','','',1,0,0,'',0,0,0.00,1,NULL),(152,'Margaret Wanjira','Wife','0791660820','Githurai','KMEA012S','GITHURAI STANMART',1,'PBI5SSQXE','Peter Muturi ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0711118145','','','',1,0,0,'',0,0,0.00,1,NULL),(153,'Beatrice Muchoki','wife','0791928338','Juja','KMFM 413E','Mlandizi,juja',1,'PBJ7UCPPR3','Joseph',50.00,'','Partial Payment',1,NULL,'','M-PESA','0715772786','','','',0,1,1,'The monarch',0,0,0.00,1,NULL),(154,'Agnes Karanja','wife','0726583283','juja','KMEJ 583Z','JKUAT,Gate B',1,'PBJ2UEK206','Kennedy',50.00,'','Partial Payment',1,NULL,'','M-PESA','0726307823','','','',1,0,0,'',0,0,0.00,1,NULL),(155,'Telvin Muhia','son','0707585993','Juja','KMCU 708D','JKUAT,gate b',1,'PBJ1UF9PY3','Christopher',50.00,'','Partial Payment',1,NULL,'','M-PESA','0718186910','','','',1,0,0,'',0,0,0.00,0,NULL),(156,'Ritah Mbae','Wife','0725732810','Juja','KMFA 471B','juja,petanns',1,'PBJ1UAZ32B','Samuel',50.00,'','Partial Payment',1,NULL,'','M-PESA','0714062593','','','',1,0,1,'The Monarch',0,0,0.00,1,NULL),(157,'Linnet Nafula','mother','0708784852','Juja','KMEL 275C','Petanns,Juja',1,'PBJ0UBOTH4','Isaac',50.00,'','Partial Payment',1,NULL,'','M-PESA','0728659937','','','',1,0,1,'Sanlam General',0,0,0.00,1,NULL),(158,'Jane Wanjiru','Wife','0797400172','githurai 44','KMDX062G','Gadhima Plaza',1,'PBI4SMQX52','Fredrick Ngige',50.00,'','Partial Payment',1,NULL,'','M-PESA','0706430003','','','',1,0,0,'',0,0,0.00,1,NULL),(159,'Steven Waweru','brother','0720742482','Githurai ','KMFC660E','GITHURAI ',1,'PBI1SOJM8F','Joseph Muchiri',50.00,'','Partial Payment',1,NULL,'','M-PESA','0721162607','','','',1,0,1,'SANLAM',1,0,30000.00,1,NULL),(160,'Stephen Ondiek ','father','0728700918','Githurai','KMFG259F','GITHURAI ',1,'PBI750VN8N','ABED ONDIEK',50.00,'','Partial Payment',1,NULL,'','M-PESA','0702401171','','','',1,0,1,'Sanlam',1,0,150000.00,1,NULL),(161,'Delvin Wachera','Wife','0717390875','Githurai 44','KMEJ801G','Rurii',1,'PBI9SIDI03','DISHON',50.00,'','Partial Payment',1,NULL,'','M-PESA','0711526364','','','',0,1,0,'',0,0,0.00,1,NULL),(162,'francis mwangi','friend','0746806335','Githurai','KMFE729Z','GITHURAI POST BANK',1,'PBI3SKNZFH','manasseh',50.00,'','Partial Payment',1,NULL,'','M-PESA','0705466336','','','',1,0,1,'SANLAM ',0,0,0.00,1,NULL),(163,'Felistas Muthoni Maina','mother','0718262642','Githurai 45','KMEG374P','GITHURAI 45',1,'32752837','JOSEPH ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0716527146','','','',1,0,1,'G.A INSURANCE',0,0,0.00,1,NULL),(164,'Teresia Muthoni','Wife ','0759307337','Githurai ','KMFD641X','CANNAN',1,'PBH4RPR7P6','James',50.00,'','Partial Payment',1,NULL,'','M-PESA','0759709054','','','',1,0,1,'KINGDOM',0,0,0.00,0,NULL),(165,'Joseph','Friend','00000000','Githurai ','KMEK362W','Thika SuperHighway',59,'PBI95ITICJ','Regan',50.00,'','Partial Payment',1,NULL,'','M-PESA','0769838254','','','',1,0,0,'',0,0,0.00,1,NULL),(166,'Maryann','Wife ','0712265815','Githurai ','KMDN428R','D.O ROAD',20,'PBI9M605','Gerishon',50.00,'','Partial Payment',1,NULL,'','M-PESA','0716293479','','','',1,0,0,'',0,0,0.00,1,NULL),(168,'xxx','xxx','000','Githurai ','KMEQ247Z','D.O ROAD',1,'PBI3SMFSJV','SAMUEL',50.00,'','Partial Payment',1,NULL,'','M-PESA','0714875958','','','',1,0,0,'',0,0,0.00,1,NULL),(169,'Wanjiru Mwangi','Wife ','0723213537','Mwihoko','Kmdf331m','Full Gospel ',1,'PBHTRRSQWF','George ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0720722597','','','',1,0,0,'',0,0,0.00,0,NULL),(170,'Ester Wambui','mother','0725727861','Githurai','KMFB582M','Mambrose',10,'PBH5RMZ01','DENNIS',50.00,'','Partial Payment',1,NULL,'','M-PESA','0795938649','','','',1,0,1,'OCCIDENTAL ',0,0,0.00,1,NULL),(171,'Jane Wanjiru ','Mother','0727755715','Juma Mbili','KMFE310V','GITHURAI ',1,'PBH9RAQTKH','Erick Maina',50.00,'','Partial Payment',1,NULL,'','M-PESA','0790271397','','','',1,0,1,'MOGO',1,0,20000.00,1,NULL),(172,'Gatheria Mbugua','father','0726226784','Githurai ','KMDK534A','GITHURAI 45 STAGE',1,'PBH2RJ743M','Kevin',50.00,'','Partial Payment',1,NULL,'','M-PESA','0759561280','','','',1,0,0,'',0,0,0.00,1,NULL),(173,'Damaris Muthoni ','sister','0715605550','Githurai 44 Sonic','KMFK126L','GITHURAI POST BANK ',1,'PBH5RB4H1D','Robert ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0701050314','','','',1,0,1,'SANLAM',0,0,0.00,1,NULL),(174,'Franklin Mutuma ','brother ','0710541496','Kawangware','kmer490w','kawangware ',490,'PBK1V4E6VZ','festusgideon',50.00,'1','Partial Payment',1,NULL,'','M-PESA','0702024160','','','',0,1,0,'',0,0,0.00,1,NULL),(175,'Daniel Njenga','Father','07','Githurai','KMDR 800M','GITHURAI 45',1,'PBH9RDu0R7','Stephen ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0792077630','','','',0,0,1,'TRIDENT',0,0,0.00,1,NULL),(176,'Gibugi Kelvin','Friend','00000','Mlango','KMFC266N','Strawberry Plaza',3,'PBG9Q7NAZX','DANIEL',50.00,'','Partial Payment',1,NULL,'','M-PESA','0748188245','','','',0,1,1,'MONARCH',0,0,0.00,1,NULL),(177,'Mbogo','Father','0728727469','Mbotela','KMES430Q','FIVE STREET',1,'PBG9DEYGB','PHILIP',50.00,'','Partial Payment',1,NULL,'','M-PESA','0701630439','','','',1,0,1,'MONARCH',0,0,0.00,1,NULL),(178,'Monica wamaitha','wife ','0769096528','githurai 44','KMEF','GITHURAI 45',1,'PBH8RCV0B2','DAVID MUGURO',50.00,'','Partial Payment',1,NULL,'','M-PESA','0718492314','','','',0,1,0,'',0,0,0.00,1,NULL),(179,'Grace Muthoni ','Mum','0727935042','Mlango Kubwa','KMEU566M','Mlango Round About ',1,'PBG3Q57ILN','John',50.00,'','Partial Payment',1,NULL,'','M-PESA','0795434141','','','',1,0,1,'COMPREHENSIVE',0,0,0.00,1,NULL),(180,'Rose Muthoni','wife','0791989813','githurai 44','KMEL250Y','GITHURAI 45',1,'PBH2RLDKW4','JULIUS',50.00,'','Partial Payment',1,NULL,'','M-PESA','0724174932','','','',0,1,0,'',0,0,0.00,1,NULL),(181,'Eunice Muhati ','wife ','0748890157','Kawangware','kmdx695s','kawangware ',695,'PBK7V5B6WZ','Daniel Owiti ',50.00,'1','Partial Payment',1,NULL,'','M-PESA','0726225486','','','',1,0,1,'monarch ',0,0,0.00,1,NULL),(182,'Esther Wambui','wife','0727277218','Githurai 45','KMEW396U','GITHURAI ROUND ABOUT',1,'PBH3RKNR29','PETER WAWERU NDIRANGU',50.00,'','Partial Payment',1,NULL,'','M-PESA','0711387495','','','',1,0,1,'SANLAM',0,0,0.00,1,NULL),(183,'winfred mwikali','wife','0721135258','Eastleigh ','KMDW016B','12TH Street Rafiki',1,'PBG0QJGC2K','Bernard',50.00,'','Partial Payment',1,NULL,'','M-PESA','0726266929','','','',1,0,0,'',0,0,0.00,1,NULL),(184,'Abdramani','Son','0000','Eastleigh ','KMFC723T','MLANGO',1,'PBGBQ4FIV4','OMARI',50.00,'','Partial Payment',1,NULL,'','M-PESA','0726278761','','','',1,0,1,'MONARCH',0,0,0.00,1,NULL),(185,'Eunice Syombua','Wife','0742062038','Umoja','KMFF392T','Eastleigh ',1,'PBG8QIJWT0','Stephen mwanzia',50.00,'','Partial Payment',1,NULL,'','M-PESA','0702673962','','','',1,0,0,'',1,0,50000.00,1,NULL),(186,'Charlie Ruguru','Son','0712269164','Dandora','KMEP227G','Kirinyaga Road',1,'PBF7P6ZTH5','George',50.00,'','Partial Payment',1,NULL,'','M-PESA','0715329604','','','',1,0,0,'',0,0,0.00,1,NULL),(187,'Nicholas Wambua','Brother ','0743191478','Mt Kenya','KMFF854M','Apex',1,'PBI2SMCV9U','Joseph',50.00,'','Partial Payment',1,NULL,'','M-PESA','0710226118','','','',0,0,1,'SANLAM',0,1,0.00,1,NULL),(188,'Rachael Wanjiru','wife','0715808544','githurai ','KMDN762S','Nairobi CBD',1,'PBF40UVY9Q','Ignatius',50.00,'','Partial Payment',1,NULL,'','M-PESA','0708747529','','','',1,0,1,'XPLICO',0,0,0.00,1,NULL),(201,'Josphat Omanga','Friend','0757870542','Congo 48','KMFK 906W','Friendly five,kawangware',1,'PBK7VFDXC3','James',50.00,'','Partial Payment',1,NULL,'','M-PESA','0793754972','','','',1,0,1,'GA insurance',0,0,0.00,1,NULL),(202,'Dolphins Kwamboka','Wife','0715039770','Kawangware','KMET 240W','shalom stage, kawangware',1,'PBK2VTMY3K','Josphat Karanja',50.00,'','Partial Payment',1,NULL,'','M-PESA','0794913329','','','',1,0,0,'',0,0,0.00,1,NULL),(203,'Mary Nduta','wife','0790117807','Kawangware ','KMDW050T','sokoni kawangware',50,'PBK8VH5S12','petermwiti',50.00,'1','Partial Payment',1,NULL,'','M-PESA','0716608415','','','',1,0,1,'Trident',0,0,0.00,1,NULL),(204,'Ken Lumati','Brother','0704510874','Kangemi','KMEW 943H','Bottom line,kawangware',1,'PBK9VBFUQB','Sablon',50.00,'','Partial Payment',1,NULL,'','M-PESA','0758790868','','','',0,1,1,'Monarch',0,0,0.00,1,NULL),(205,'Atnas Chege','brother','0797533891','Juja','KMEW 256Z','Juja',1,'PBJ1TJFGT9','Joseph',50.00,'','Partial Payment',1,NULL,'','M-PESA','0729454411','','','',1,0,0,'',0,0,0.00,1,NULL),(206,'Jane maina','wife','0717574368','Ndaraca','KMFC 860V','Juja',1,'PBJ5TVT80Z','Erick',50.00,'','Partial Payment',1,NULL,'','M-PESA','0741941811','','','',1,0,1,'The monarch',0,0,0.00,1,NULL),(207,'Mwangi maina','friend','0721595666','Juja','KMDN 727X','Juja stage',968,'PBJ6VRF950','Amos',50.00,'','Partial Payment',1,NULL,'','M-PESA','0700529940','','','',0,1,0,'',0,0,0.00,1,NULL),(208,'Juma Festus','Friend','0726735395','Juja','KMFE 566A','Juja',1,'PBJ3TQ20T7','Elisha',50.00,'','Partial Payment',1,NULL,'','M-PESA','0726395735','','','',1,0,1,'Monarch',0,0,0.00,1,NULL),(209,'Margaret Waceke','wife','0728237638','Murera','KMCZ 809B','Backyard,Juja',1,'PBJ5UI02T9','John',50.00,'','Partial Payment',1,NULL,'','M-PESA','0721569756','','','',1,0,0,'',0,0,0.00,1,NULL),(210,'Stella Onyango','wife','0724569797','Juja','KMEH 059R','Backyard,juja',1,'PBJ3064URV','Kelvin',50.00,'','Partial Payment',1,NULL,'','M-PESA','0741937287','','','',1,0,1,'Sanlam',1,0,65000.00,1,NULL),(211,'Erick Nyakundi','friend','0710149496','Kawangware','KMDA 997K','Junction, Emmanuel',1,'PBKOV274VW','Kennedy',50.00,'','Partial Payment',1,NULL,'','M-PESA','0724170798','','','',1,0,0,'',0,0,0.00,1,NULL),(212,'Irungu','friend','0710889125','Kawangware','KMEB 616F','46, Kawangware',1,'PBK6V0CLSE','Lawrence',50.00,'','Partial Payment',1,NULL,'','M-PESA','0724137894','','','',1,0,0,'',0,0,0.00,1,NULL),(213,'Moses Nyarasi','brother','0702483064','Kawangware','KMEH 155J','Kawangware 46',1,'PBK4V4Q0JK','Elijah',50.00,'','Partial Payment',1,NULL,'','M-PESA','0795606125','','','',1,0,1,'SANLAM',0,0,0.00,0,NULL),(223,'Faith Okalo','Wife','0722873178','Ruai','KMEP 971R','Kenice stage,kariobangi',1,'PBM3XEUCRR','Daniel okalo',50.00,'','Partial Payment',1,NULL,'','M-PESA','0715739206','','','',1,0,1,'Trident insurance',0,0,0.00,0,NULL),(224,'Faith Osano','Wife','0729030056','Taj Mall','KMDE334D','Tajj mall',334,'PBM7XGYYDR','Adams wesonga',50.00,'1','Partial Payment',1,NULL,'','Cash','0725204597','','','',1,0,0,'',0,0,0.00,1,NULL),(225,'Monica mugure','mother','0716533699','Dandora','KMFE 837B','Waiyaki way',1,'PBM4X1NH94','Peter mwangi',50.00,'','Partial Payment',1,NULL,'','M-PESA','0700514821','','','',1,0,1,'the monarch',0,0,0.00,0,NULL),(226,'Stella Amondi','wife','0769397540','Obama','KMET 527J','Mathare North',1,'PBM8XJ97E6','Jectone',50.00,'','Partial Payment',1,NULL,'','M-PESA','0701816564','','','',1,0,0,'',0,0,0.00,1,NULL),(227,'Alice Wangari','Wife','0790240759','githurai ','KMFH085W','GITHURAI 45',1,'PBH1REBTF','Kelvin Mwangi',50.00,'','Partial Payment',1,NULL,'','M-PESA','0746270003','','','',1,0,1,'GA INSURANCE',1,0,50000.00,1,NULL),(228,'Eunice Kagwi','Friend','0720233580','Kirinyaga ','KMFC612W','Kirinyaga Road ',1,'PBH9RINGYL','Henry Njuguna',100.00,'','Partial Payment',2,NULL,'','M-PESA','0728816492','','','',1,0,0,'',0,0,0.00,1,NULL),(229,'Pauly Mugo','Wife','0706332369','mwiki ','KMEP202G','GITHURAI ',1,'PBH1RP1XOL','Wambu',50.00,'','Partial Payment',1,NULL,'','M-PESA','0724427198','','','',1,0,1,'ELGON',0,0,0.00,1,NULL),(230,'Faith Kamau','Wife','0719483590','githurai ','KMER949G','GITHURAI ',1,'PBH3RFCCFR','Joseph',50.00,'','Partial Payment',1,NULL,'','M-PESA','0743762767','','','',1,0,1,'MONARCH ',0,0,0.00,0,NULL),(231,'Innocent Ongeri','cousin','0728678260','Githurai ','KMFG861X','GITHURAI KWA NYANYA',1,'PBH5RGT3MD','Samwel',50.00,'','Partial Payment',1,NULL,'','M-PESA','0722532679','','','',1,0,1,'SANLAM GENERAL INSURANCE',0,0,0.00,1,NULL),(232,'Harrison Njoroge','Brother','0725582928','githurai ','KMFE089A','Nairobi Matt',1,'PBH0RMV4YC','Jotham',50.00,'','Partial Payment',1,NULL,'','M-PESA','0711384640','','','',1,0,1,'BOXER ',1,0,200000.00,1,NULL),(233,'Peter Chege','father','0710589786','GITHURAI ','KMFC565D','GITHURAI MARY MOUNT ',1,'PBI6SOI16','Robert',50.00,'','Partial Payment',1,NULL,'','M-PESA','0702790286','','','',1,0,1,'SANLAM GENERAL INSURANCE ',0,0,0.00,1,NULL),(234,'susan mercy ','mother','0721932194','Githurai 45','KMFG957N','GITHURAI 45',1,'PBH0RF4OHC','Eliud Mwangi',50.00,'','Partial Payment',1,NULL,'','M-PESA','0708659255','','','',0,0,1,'NISHATI',1,0,400.00,1,NULL),(235,'Winnie Awuor','Spouse','0711104660','Guru Nanak','KMEP019U','NAIROBI ',1,'PBG5QZGYMP','Paul',50.00,'','Partial Payment',1,NULL,'','M-PESA','0720856493','','','',1,0,1,'MONARCH',0,0,0.00,1,NULL),(236,'Regina Wanjiku','Wife','0714738985','Githurai ','KMEQ623Z','MUTHURWA',1,'PBF5P3LDXZ','CHARLES ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0746196415','','','',1,0,1,'MONARCH',0,0,0.00,1,NULL),(237,'Kenneth Gathara ','cousin','0707818011','Gachie','KMEH884R','GPO',1,'PBF4PIFPPQ','MWANGI STEVE',50.00,'','Partial Payment',1,NULL,'','M-PESA','0711896245','','','',1,0,1,'XPLICO INSURANCE',0,0,0.00,1,NULL),(238,'Susan Muthoni ','Mother','0723671890','Githurai 44','KMEY780U','GITHURAI 44',1,'PBH0RENPLY','Henry Kanyi',50.00,'','Partial Payment',1,NULL,'','M-PESA','0704118273','','','',1,0,0,'',0,0,0.00,1,NULL),(239,'Salome','Ngendo','0726136876','Githurai 45','KMEX322W','GITHURAI ',1,'PBH2RK5IUM','Antony',50.00,'','Partial Payment',1,NULL,'','M-PESA','0729872608','','','',1,0,1,'RWAMBE',0,0,0.00,1,NULL),(240,'Carolyne Kinyua ','Spouse ','0759273365','Eastleigh','KMEL523L','Equity 12th Street',1,'PBG4QHGCRG','Isaac Mutuku',50.00,'','Partial Payment',1,NULL,'','M-PESA','0796880136','','','',0,0,1,'MONARCH ',0,1,0.00,0,NULL),(241,'Rosered Waruguru','Mother','0797368404','Soweto','KMFL 576B','Soweto',1,'PBM2XL11K6','Harrison',50.00,'','Partial Payment',1,NULL,'','M-PESA','0797675168','','','',1,0,1,'Trident',0,0,0.00,1,NULL),(242,'Jennifer Kavenyi','wife','0726336195','Umoja 3','KMEW 063X','Buruburu',1,'PBMOXKSJ3C','Isaac',50.00,'','Partial Payment',1,NULL,'','M-PESA','0715655564','','','',1,0,1,'Trident',0,0,0.00,1,NULL),(243,'Judy orina','wife','0728278319','Taj Mall','KMEK767W','tajj mall',767,'PBM2XQM8Q2','dennis shake',50.00,'1','Partial Payment',1,NULL,'','M-PESA','0726264558','','','',1,0,1,'Occidental',0,0,0.00,1,NULL),(244,'aisha','wife','0748168125','Taj Mall','KMFF 228A','tajj mall',228,'PBM4XRENRK','Ibrahim mwangala',50.00,'1','Partial Payment',1,NULL,'','M-PESA','0723894142','','','',1,0,0,'',0,0,0.00,1,NULL),(245,'Jedidah morah ombati','sister','0702616573','Taj Mall','KMFJ555Z','Taj mall',555,'PBM1XU8K91','JEREMIAH OMBATI',50.00,'1','Partial Payment',1,NULL,'','M-PESA','0707306714','','','',1,0,1,'MUUGO',1,0,88888.00,1,NULL),(246,'Deric mbuki','son','0724381065','Taj Mall','kmds 545r','Tajmall',545,'pbm5xu5cgj','mbuki mwengi',50.00,'1','Partial Payment',1,NULL,'','M-PESA','0724381065','','','',1,0,1,'monarch',0,0,0.00,1,NULL),(247,'Fred Okumu','Brother','0710204609','Kabiria','KMEY 507V','Ngong rd',1,'PBN9YCIVYF','Erick Okumu',50.00,'','Partial Payment',1,NULL,'','M-PESA','0728666962','','','',1,0,1,'Xplico',0,0,0.00,1,NULL),(248,'Dennis Wesonga','Brother','0716314831','Kawangware','KMFE 594E','Kawangware',1,'PBN8YCNJ82','Wesonga',50.00,'','Partial Payment',1,NULL,'','M-PESA','0703100538','','','',1,0,1,'Sanlam General',0,0,0.00,1,NULL),(249,'Franklin Manyuraga','Son','0716030652','Makadara, Hamsa','KMDS 973V','Hamsa',1,'PBN9YCNIMZ','James',50.00,'','Partial Payment',1,NULL,'','M-PESA','0721597216','','','',1,0,1,'Xplico insurance',0,0,0.00,1,NULL),(250,'James Manyiraga','Father','0721597216','Kayole','KMFF 018B','Kayole',1,'PBN4YCHZII','Paul Onyango',50.00,'','Partial Payment',1,NULL,'','M-PESA','0728666786','','','',1,0,1,'Xplico',0,0,0.00,0,NULL),(251,'Roselyn Wairimu ','wife','0727104407','Nairobi ','KMDF253K','Nairobi ',1,'PBM0XOJXU6','Kelvin',50.00,'','Partial Payment',1,NULL,'','M-PESA','0712675008','','','',1,0,1,'XPLICO',0,0,0.00,0,NULL),(252,'Dennis Ondeyo ','Brother','0715537867','Nairobi CBD','KMFB074x','NAIROBI',1,'PBM8XO0QZC','Jackson',50.00,'','Partial Payment',1,NULL,'','M-PESA','0746649388','','','',1,0,1,'REIGN COURIER',0,0,0.00,1,NULL),(253,'Charles Marwa','Brother','0748043402','Nairobi','KMFD684N','NAIROBI ',1,'PBM4XR7591','Samuel',50.00,'','Partial Payment',1,NULL,'','M-PESA','0790644284','','','',1,0,1,'SANLAM GENERAL',0,0,0.00,0,NULL),(254,'Rose Bella','friend','0702751883','Langata','KMFL127Q','Langata',1,'PBH0RNDJ9E','MATIAS KIPROTICH ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0711549072','','','',1,0,0,'',1,0,30000.00,1,NULL),(255,'Jane Mumbi','friend','0748191203','Langata','KMFG954W','Langata ',1,'PBJ2TVP51G','JOHN MWANZWII',100.00,'','Partial Payment',2,NULL,'','M-PESA','0712367970','','','',1,0,0,'',0,0,0.00,1,NULL),(256,'Kennedy','friend','0705947519','Langata','KMEF216W','LANGATA ',1,'PBH8RHU7GQ','SULEIMAN OSIKUKU ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0702567896','','','',1,0,1,'RWABE',0,0,0.00,1,NULL),(257,'gob river','friend','0798490201','Baba Ndogo','KMFF764L','Kilimani/Mbagathi',1,'PBH0RFQKBQ','Christopher Ochieng',100.00,'','Partial Payment',2,NULL,'','M-PESA','0707435585','','','',1,0,0,'',0,0,0.00,1,NULL),(258,'Benson simiyu','son','0794991114','Kawangware','KMDS 938V','Kawangware',1,'PBN4YCRAZ6','wekesa',50.00,'','Partial Payment',1,NULL,'','M-PESA','0721275564','','','',1,0,1,'Xplico',0,0,0.00,1,NULL),(259,'Clare Muhenja','sister','0724445423','Dagoretti Corner','KMEQ 786T','Ngong rd',1,'PBN9YCNCOJ','Joseph Kisundi',50.00,'','Partial Payment',1,NULL,'','M-PESA','0793072467','','','',1,0,1,'Monarch',0,0,0.00,0,NULL),(260,'Maureen Nekoye','wife','0768732564','Racecourse','KMTE 912V','Lavington,ngong rd',1,'PBN6YD19XG','Mulongo',50.00,'','Partial Payment',1,NULL,'','M-PESA','0705146541','','','',1,0,1,'Xplico',0,0,0.00,0,NULL),(261,'Frank Asila','brother','0705474163','Kawangware','KMFF 168A','Ngong Rd',1,'PBN7YCTCZZ','Michael',50.00,'','Partial Payment',1,NULL,'','M-PESA','0710980973','','','',1,0,1,'Sanlam General',0,0,0.00,1,NULL),(262,'Joshua kwanga','Father','0713768455','Dagoretti Corner','KMDV 197H','Dagoreti corner',1,'PBN6YCTMR2','Kwanga',50.00,'','Partial Payment',1,NULL,'','M-PESA','0723265813','','','',1,0,1,'Xplico',0,0,0.00,1,NULL),(263,'Maryanne Kinywa','wife','0743899951','Kangemi','KMED 500L','Valley Arcade',1,'PBK7VE6FCJ','Peter',100.00,'','Partial Payment',2,NULL,'','M-PESA','0718216401','','','',1,0,0,'',0,0,0.00,1,NULL),(264,'Margaret wafula','mother','0703868254','Kawangware','KMER 289W','Lavington',1,'PBK2V3T4EG','Isaac',50.00,'','Partial Payment',1,NULL,'','M-PESA','0748988410','','','',1,0,1,'The monarch',0,0,0.00,0,NULL),(266,'Lonah Okiri ','mother','0723237152','Kabiria','KMFC 906A','Ngong rd',1,'PBN8YCX6NK','Ojule',50.00,'','Partial Payment',1,NULL,'','M-PESA','0798718561','','','',1,0,1,'The Monarch',0,0,0.00,1,NULL),(267,'Franco Wesonga','Friend','0110862878','Kilimani','KMEQ 645Q','Kilimani',1,'PBN4YCK91Q','Felix Milimu',50.00,'','Partial Payment',1,NULL,'','M-PESA','0794789542','','','',1,0,1,'Xplico',0,0,0.00,1,NULL),(268,'Chide Ameria','Daughter','0721649479','Kasarani','KMFF 602E','Kasarani',1,'PBN7YDT87V','Alfred',50.00,'','Partial Payment',1,NULL,'','M-PESA','0728788313','','','',1,0,1,'Xplico',0,0,0.00,1,NULL),(269,'Susan Katanu','wife','0741991903','Embakasi','KMEL 275Y','Kilimani,kileleshwa, Lavington',1,'PBKOV8JTSA/PBK2V8EYEQ','Peter',100.00,'','Partial Payment',2,NULL,'','M-PESA','0716010548','','','',1,0,0,'',0,0,0.00,1,NULL),(270,'Vinny Mutali','Brother','0712136740','Satelitte','KMET 268J','Satelitte',1,'PBN7YEV9LD','Lilian',50.00,'','Partial Payment',1,NULL,'','M-PESA','0728809130','','','',1,0,1,'Xplico',0,0,0.00,0,NULL),(271,'Risper Onyango','Mother','0799123342','Umoja','KMEN 377E','Umoja',1,'PBN9YBT9BN','John',50.00,'','Partial Payment',1,NULL,'','M-PESA','0700359243','','','',1,0,1,'Xplico',0,0,0.00,1,NULL),(272,'Micheal Gabe','son','0705146660','Waithaka','KMEE 051D','Lavington',1,'PBN2YDYCKE','Vinny',50.00,'','Partial Payment',1,NULL,'','M-PESA','0712136740','','','',1,0,1,'XPLICO',0,0,0.00,1,NULL),(280,'Dennis Mogeni','Brother','0714300776','Kawangware','KMFL467R','KAWANGWARE ',1,'PBK0VAYQTK','Vincent',50.00,'','Partial Payment',1,NULL,'','M-PESA','0722485711','','','',1,0,1,'MONARCH ',0,0,0.00,0,NULL),(281,'Dan Dominion','Uncle','0724604428','Ruiru','KMFF 413Y','Ruiru/Githurai',1,'PBP81W9TRK','Dan',50.00,'','Partial Payment',1,NULL,'','M-PESA','0701557580','','','',1,0,1,'The monarch',0,0,0.00,0,NULL),(297,'Lilian Anyango','Wife','0742814415','Kawangware','KMDH 171K','Nairobi CBD',1,'PBQ13PODCJ','4036617',50.00,'001','Partial Payment',1,NULL,'','M-PESA','0742473018','','','',1,0,1,'Kenya alliance',0,0,0.00,1,NULL),(303,'Irene Wangari','wife','0724971127','Juja','KMDM 664D','Gachororo',1,'PBD81UUWWI','Joseph ',50.00,'001','Partial Payment',1,NULL,'','M-PESA','0723246587','','','',1,0,0,'',0,0,0.00,1,NULL),(304,'Jane Muthoni','wife','0706703470','Gachororo','KMCV 074Z','Gachororo',1,'PBQ7346HZ7','Ricknel',50.00,'001','Partial Payment',1,NULL,'','M-PESA','0702164072','','','',1,0,0,'',0,0,0.00,1,NULL),(305,'Gacheru','Father','0724710297','Gatundu','KMEF 025R','Mukiriti,Thika',1,'PBQ03CDQ4U','Ricknel',50.00,'001','Partial Payment',1,NULL,'','M-PESA','0717911282','','','',1,0,0,'',0,0,0.00,1,NULL),(306,'Irene Nabwire','wife','0708715141','Athena','KMEJ 033P','prison stage,thika',1,'PBQ53ME5AV','Ricknel',50.00,'001','Partial Payment',1,NULL,'','M-PESA','0726735306','','','',1,0,1,'Xplico',0,0,0.00,1,NULL),(307,'James Rufai','friend','0718603531','Athena','KMEJ 577J','Prison stage,thika',1,'PBQ13LNNJR','Ricknel',50.00,'001','Partial Payment',1,NULL,'','M-PESA','0704518474','','','',1,0,1,'Xplico',0,0,0.00,1,NULL),(308,'Samuel Mwangi','Friend','0723023782','Kiganjo','KMDM 512U','U shop',1,'PBQ63H610M','Ricknel',50.00,'001','Partial Payment',1,NULL,'','M-PESA','0722769262','','','',1,0,0,'',0,0,0.00,0,NULL),(309,'David Nyamberi','Brother','0796050734','Witeithie','KMFD 015P','Thika Stadium',1,'PBQ03EK3Cs','Ricknel',50.00,'001','Partial Payment',1,NULL,'','M-PESA','0711364319','','','',1,0,1,'Sanlam General',0,0,0.00,1,NULL),(310,'JUDY WAIRIMU','wife','0729518992','Witeithie','KMFC 228E','U shop',1,'PBQ23E0HLC','Martin ',50.00,'001','Partial Payment',1,NULL,'','M-PESA','0729076417','','','',1,0,1,'Trident',0,0,0.00,1,NULL),(311,'Yasin Osman','Friend','0721424578','Kiganjo','KMEK 978R','Thika Stadium',1,'PBQ63A605E','james',50.00,'001','Partial Payment',1,NULL,'','M-PESA','0727789538','','','',1,0,0,'',0,0,0.00,1,NULL),(312,'Njeri kioi ','mother','0724749736','Witeithie','KMFB 872R','Thika Stadium',1,'PBQ039J01G','Ricknel',50.00,'001','Partial Payment',1,NULL,'','M-PESA','0724749736','','','',1,0,0,'',0,0,0.00,1,NULL),(313,'Victor Njuguna','friend','0715158507','Thika','KMFE 611V','Thika Stadium ',1,'PBQ638VJSC','Ricknel',50.00,'001','Partial Payment',1,NULL,'','M-PESA','0796546800','','','',1,0,1,'Sanlam General',0,0,0.00,1,NULL),(314,'Lee karani','friend','0758178242','Thika','KMFF 788N','Thika Stadium',1,'PBQ538JZ8H','Ricknel',50.00,'001','Partial Payment',1,NULL,'','M-PESA','0713549514','','','',1,0,1,'The monarch',0,0,0.00,1,NULL),(315,'Eunice Nduku','mother','0723333193','Juja','KMCX 329G','Gachororo',1,'PBP91X5X57','Ricknel',50.00,'001','Partial Payment',1,NULL,'','M-PESA','0707593172','','','',1,0,1,'Xplico',0,0,0.00,1,NULL),(318,'Faith Aremba','sister','0705524023','Kangemi','KMDC474S','KANGEMI',1,'PBH0RGMZZA','Jason',100.00,'','Partial Payment',2,NULL,'','M-PESA','0794160722','','','',1,0,0,'',0,0,0.00,1,NULL),(319,'Rachael Afatga','wife','0708089648','Kangemi','KMEP069L','KANGEMI ',14,'PBH4RFP9ZI','KENNEDY KEFA',100.00,'','Partial Payment',2,NULL,'','M-PESA','0708213537','','','',1,0,1,'MONARCH ',0,0,0.00,1,NULL),(320,'Geoffrey Miruka','Brother','0701235529','Kangemi','KMFH266G','KANGEMI ',22,'PBH2RDDJJG','Calif Miruka',50.00,'','Partial Payment',1,NULL,'','M-PESA','0714036094','','','',1,0,1,'SANLAM',0,0,0.00,1,NULL),(321,'Goldwin Omaiko','son','0700000','kangemi ','KMEZ201B','KANGEMI ',16,'PBH5RA661VR','Kevin',50.00,'','Partial Payment',1,NULL,'','M-PESA','0746508800','','','',1,0,1,'COMPREHENSIVE ',0,0,0.00,1,NULL),(322,'lilian ','wife','0111151959','kangemi ','KMEW469A','KANGEMI ',20,'PBH6R9HN0Q','Evans',50.00,'','Partial Payment',1,NULL,'','M-PESA','0700267197','','','',1,0,0,'',0,0,0.00,1,NULL),(323,'badas','brother','0722622478','Kangemi','KMEM140R','KAWANGWARE',1,'PBH0RBV3NO','Hudson Kifuve',50.00,'','Partial Payment',1,NULL,'','M-PESA','0746132511','','','',1,0,0,'',0,0,0.00,1,NULL),(324,'Asha Chanuka','wife','0701037686','Kangemi','KMEW365K','KANGEMI ',25,'PBH4RBBV758','David ',100.00,'','Partial Payment',2,NULL,'','M-PESA','0725345699','','','',1,0,0,'',0,0,0.00,1,NULL),(326,'Everlyn Musyoki','wife ','0725643827','Waithaka ','KMET798J','Woodley',1,'PBK1VGC8ID','Moses Mutinda ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0727832679','','','',1,0,0,'',0,0,0.00,1,NULL),(327,'Emily Okelo','wife','0701542867','Waithaka','KMEX895W','WOODLEY',1,'PBK5UHIDUY','Richard Okelo',50.00,'','Partial Payment',1,NULL,'','M-PESA','0719873694','','','',1,0,0,'',0,0,0.00,1,NULL),(328,'Sarah Keruro','sister','0703205775','Kangemi','KMET827G','KANGEMI ',1,'PBH3RG9BVT','ROBIN ISOE',50.00,'','Partial Payment',1,NULL,'','M-PESA','0703991691','','','',0,1,0,'',0,0,0.00,1,NULL),(329,'Rose Chemasa','wife','0706484990','Kangemi','KMET305W','KANGEMI ',1,'PBH1RHQRLN','Rose Chemasa',50.00,'','Partial Payment',1,NULL,'','M-PESA','0702333356','','','',1,0,1,'MONARCH ',0,0,0.00,1,NULL),(330,'Teresa Kwamboka','mum ','0720495569','Kangemi ','KMFK449D','KANGEMI ',1,'PBH8RGKVOE','Boniface Maina ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0746171511','','','',0,1,0,'',0,0,0.00,1,NULL),(331,'Gilbert korir','friend','0712086197','Kamutini','kmec 058 b','kamutini',9,'pc1379q7t1','japheth',50.00,'','Partial Payment',1,NULL,'','M-PESA','0759644560','','','',1,0,0,'',0,0,0.00,1,NULL),(333,'Lola Getrude','daughter ','070000','Githurai','kmfg061l','GITHURAI ',1,'PBJ3U8FYBF','Asisi',50.00,'','Partial Payment',1,NULL,'','M-PESA','0796370224','','','',1,0,1,'TVS',1,0,108000.00,1,NULL),(334,'Hildah','wife','0725086662','Kibra','KMDY765G','Kibra',1,'PBK5V7UIAT','Mike',50.00,'','Partial Payment',1,NULL,'','M-PESA','0715649334','','','',1,0,0,'',0,0,0.00,1,NULL),(335,'Lucy Atieno','child','0700000','Kibera','KMFM947G','Kibera',1,'PBK8V2DEBC','George',50.00,'','Partial Payment',1,NULL,'','M-PESA','0714450106','','','',1,0,1,'SANLAM',0,0,0.00,0,NULL),(336,'Manjanne Favour','Daughter ','070000','Kibera','KMEZ278K','Kibera ',1,'PBK1V2K4Z9','JEFF',0.00,'','To Pay Later',0,'2022-01-01 00:00:00','Later','M-PESA','0726123985','','','',1,0,0,'',0,0,0.00,0,NULL),(337,'Nancy Auma','wife','0714147080','Kibera','KMEL143E','KIBERA ',1,'PBK4V319KS','Lucas',50.00,'','Partial Payment',1,NULL,'','M-PESA','0725747485','','','',1,0,0,'',0,0,0.00,1,NULL),(338,'agness','mother ','0797063892','Kibera','KMDC435Z','KIBERA',1,'PBK6V4FBAU','Brian',50.00,'','Partial Payment',1,NULL,'','M-PESA','0759687295','','','',0,1,1,'SANLAM',0,0,0.00,1,NULL),(339,'TeresiaKinyanjui','wife','0703982659','Gathurai','KMET369K','Gathurai',1,'PBJ0U23OKA','Philip',50.00,'','Partial Payment',1,NULL,'','M-PESA','0746865597','','','',1,0,0,'',0,0,0.00,1,NULL),(340,'josphat','father ','0723030139','Roasters','KMDJ536U','Roasters',1,'PBM3XC80CD','Isaac',50.00,'','Partial Payment',1,NULL,'','M-PESA','0746622887','','','',1,0,0,'',0,0,0.00,1,NULL),(341,'wanjiru','wife','0798602099','MATHARE ','KMFK201N','MATHARE',1,'PBM1XSKE8A','Jambas',50.00,'','Partial Payment',1,NULL,'','M-PESA','0745691773','','','',1,0,1,'SANLAM',0,0,0.00,1,NULL),(342,'maureen','wife','0736572523','Mathare ','KMEB069M','MATHARE ',31,'PBM1XE5FID','Charlse',50.00,'','Partial Payment',1,NULL,'','M-PESA','0722111410','','','',1,0,0,'',0,0,0.00,1,NULL),(343,'mercy mutongoi musee','wife','0759136904','Westlands','kmew 158w','Westlands ',158,'PC177CM49N','Obadiah maina',50.00,'','Partial Payment',1,NULL,'','M-PESA','0758594667','','','',1,0,0,'',0,0,0.00,1,NULL),(344,'Charles Gachoke','brother','0722111410','Mathare','KMEP501A','mathare',42,'PBM3XEBL8V','AXEGUN',50.00,'','Partial Payment',1,NULL,'','M-PESA','0713303599','','','',1,0,1,'Rwabe',0,0,0.00,1,NULL),(345,'jane njeri','wife ','0723702643','Mathare','KMET877T','MATHARE ',25,'PBM7XEOC2R','Ndungu',50.00,'','Partial Payment',1,NULL,'','M-PESA','0721724923','','','',1,0,1,'XPLICO ',0,0,0.00,1,NULL),(346,'Aidah','wife ','0713874837','Survey KCA','KMDP606F','SURVEY ',3,'PBM4X9ZZDO','Benard',50.00,'','Partial Payment',1,NULL,'','M-PESA','0726498587','','','',1,0,1,'MONARCH ',0,0,0.00,1,NULL),(347,'Divina Bochaberi','wife','0713807617','Huruma','KMFF560L','Huruma/Nairobi',1,'PBL7WPBR8J','Nyabiba Isaac',50.00,'','Partial Payment',1,NULL,'','M-PESA','0723091196','','','',0,0,1,'SANLAM',1,1,132000.00,1,NULL),(348,'immaculatekwamboka','wife','0727882783','Mathare ','KMFK211L','MATHARE ',1,'PBM5XJ31BB','PHILIP',50.00,'','Partial Payment',1,NULL,'','M-PESA','0728720886','','','',0,0,1,'MOGO LTD',1,1,180000.00,1,NULL),(349,'Christine Bosibori','wife','0706211602','Mathare North','KMFL967L','MATHARE ',1,'PBM8X1PV11','Dominic Ogure',50.00,'','Partial Payment',1,NULL,'','M-PESA','0727225191','','','',0,0,1,'MOGO LTD ',1,1,190000.00,0,NULL),(350,'Ngithi','sister','0727302026','Huruma','KMFE282L','HURUMA ',1,'PBM0XJ92A2','Muriithi',50.00,'','Partial Payment',1,NULL,'','M-PESA','0725126352','','','',1,0,1,'MONARCH ',0,0,0.00,1,NULL),(351,'Nancy','wife','0790733557','Allsopps','KMFD988Y','Alsopps',1,'PBM3XGDMIV','JOJI',50.00,'','Partial Payment',1,NULL,'','M-PESA','0721225405','','','',1,0,1,'SANLAM',1,0,50000.00,1,NULL),(352,'Jonathan Mutua','Brother ','0722311337','Mathare ','KMEE890V','HURUMA ',1,'PBL8WOIZQ8','KENNEDY',50.00,'','Partial Payment',1,NULL,'','M-PESA','0724677471','','','',1,0,0,'',0,0,0.00,1,NULL),(353,'rosemary awori','wife','0711789155','Kibra','KMFG566W','KIBRA',1,'PBK2V3LXG','Julius Mwangla',50.00,'','Partial Payment',1,NULL,'','M-PESA','0746170955','','','',0,1,0,'',0,0,0.00,1,NULL),(354,'Jane Atieno ','wife','0706751920','Nairobi CBD','KMET992A','Ngara and CBD',1,'PBJ4TZJUGA','GODFREY ODHIAMBO',50.00,'','Partial Payment',1,NULL,'','M-PESA','0723869368','','','',1,0,1,'MONARCH ',0,0,0.00,1,NULL),(355,'Beatrice Odhiambo','wife','0702540628','Kibra','KMFM624E','KIBRA',1,'PBK5V437ZZ','MATIBA',50.00,'','Partial Payment',1,NULL,'','M-PESA','0704453758','','','',0,0,1,'MONARCH ',0,0,0.00,1,NULL),(356,'Belinda Atieno ','wife','0749930987','Racecourse','KMEP244J','kibera',1,'PBK7VDL9PN','NICHOLAS ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0729006508','','','',1,0,1,'MONARCH ',1,0,90000.00,1,NULL),(357,'Faith Wanza','wife','0710638139','Kabiria','KMFG077G','Nairobi ',1,'PBK7VENN9H','Gilbert Orina',50.00,'','Partial Payment',1,NULL,'','M-PESA','0727703382','','','',0,0,1,'SANLAM',1,1,126000.00,1,NULL),(358,'Emily Inmiza','wife','0758088415','Kibera','KMDW177F','KIBERA',1,'PBK8VCEGOG','DAVID BEMBE',50.00,'','Partial Payment',1,NULL,'','M-PESA','0710590354','','','',1,0,1,'OCCIDENTAL',0,0,0.00,1,NULL),(359,'xxxxx','xxxxxx','070000','Kibera','KMEP037H','KIBERA',1,'PBK8V7NZYI','IBRAHIM TWEB',50.00,'','Partial Payment',1,NULL,'','M-PESA','0794753236','','','',0,1,0,'',0,0,0.00,1,NULL),(360,'Idris Ali','Friend','0710931253','Kibera','KMEE269H','KIBERA',1,'PBK1V3REMJ','HUSSEIN ALI',50.00,'','Partial Payment',1,NULL,'','M-PESA','0729872770','','','',1,0,1,'MADISON ',0,0,0.00,1,NULL),(361,'Vyonner Waseka','friend','0726165670','Kibera Kianda','KMFF755L','kibera',1,'PBK5B3DH47','IDRIS ALI',50.00,'','Partial Payment',1,NULL,'','M-PESA','0710931253','','','',0,0,1,'MADISON ',1,1,70000.00,1,NULL),(362,'xxxxx','xxxxx','070000','Kibera','KMFA399S','KIBERA',1,'PBK0V403HK','John Sese',50.00,'','Partial Payment',1,NULL,'','M-PESA','0701256844','','','',0,1,0,'',0,0,0.00,0,NULL),(363,'xxxxx','xxxxx','0700000','Kibera ','KMDM334R','KIBERA ',1,'PBK6VCTC08','Elihah Khakau',50.00,'','Partial Payment',1,NULL,'','M-PESA','0712815494','','','',1,0,0,'',0,0,0.00,1,NULL),(364,'Mercy Chesoli','wife','0702863925','Satellite','KMEA 679B','Kilimani, Lavington',1,'PC1671Z1EQ','Mourice',50.00,'001','Partial Payment',1,NULL,'','M-PESA','0713481296','','','',1,0,1,'The Monarch',0,0,0.00,1,NULL),(365,'Acrinah Kimeu','wife','0724122883','Kirinyaga Road','KMFE573L','KIRINYAGA ROAD',1,'PBJ4UNDIYS','Shilisia Muhatia',50.00,'','Partial Payment',1,NULL,'','M-PESA','0723737074','','','',1,0,0,'',0,0,0.00,1,NULL),(366,'Ngororo Wambui ','Friend','0701641909','Mwihoko','KMFF662U','KIRINYAGA ROAD ',1,'PBJ9UN36WZ','ZaberiNdegwa',50.00,'','Partial Payment',1,NULL,'','M-PESA','0742765487','','','',1,0,0,'',0,0,0.00,0,NULL),(367,'Margaret Njeri','wife','0740535718','Githurai','KMFF306F','GITHURAI 45',1,'PBJ5UMXMCL','JAMES IRONJO',50.00,'','Partial Payment',1,NULL,'','M-PESA','0741050436','','','',1,0,0,'',1,0,60000.00,1,NULL),(368,'Peter Mwangi','brother ','0727767289','Githurai 44','KMEL398E','ROUND ABOUT',1,'PBJ2UNOYR8','simon kiragu ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0727767289','','','',1,0,0,'',0,0,0.00,1,NULL),(369,'Julius David','brother','0712628840','Amboseli','KMEQ235V','Amboseli ',6,'PBK6VAOJZM','JACOB',50.00,'','Partial Payment',1,NULL,'','M-PESA','0740442453','','','',1,0,1,'OCCIDENTAL ',0,0,0.00,1,NULL),(370,'Nancy Njeri','wife','0795197420','Kawangware Ngina Road','KMER746M','Mayas',19,'PBK5UZKHD','Martin',50.00,'','Partial Payment',1,NULL,'','M-PESA','0716746050','','','',0,1,1,'MONARCH',0,0,0.00,1,NULL),(371,'Sibia Moraa','wife','0707881414','Kawangware','KMCZ226G','Kawangware 46',1,'PBK1V1HCBT','Eric',50.00,'','Partial Payment',1,NULL,'','M-PESA','0757832500','','','',0,1,0,'',0,0,0.00,1,NULL),(372,'Paul Marigi','friend','0741736844','Red Carpet','KMFL673R','Red Carpet',1,'PBK8V4RY48','Fidel',50.00,'','Partial Payment',1,NULL,'','M-PESA','0795868925','','','',1,0,1,'SANLAM',1,0,90000.00,1,NULL),(373,'Peris Mandere','wife','0702415079','Waithaka','KMET117Q','Peponi Stage',1,'PBK9V74YIZ','James',50.00,'','Partial Payment',1,NULL,'','M-PESA','0721168121','','','',1,0,1,'SANLAM',1,0,50000.00,1,NULL),(374,'Topistar Baraza','wife','0703206293','Kangemi','KMFG719U','56',48,'PBK2V8UORQ','Moses',50.00,'','Partial Payment',1,NULL,'','M-PESA','0713617580','','','',1,0,1,'SANLAM ',0,0,0.00,1,NULL),(375,'Alice Njeri','Mother ','0727941540','Maraba','KMEY058P','WITEITHIE STAGE ',9636,'PBJ2U912E6','James',50.00,'','Partial Payment',1,NULL,'','M-PESA','0708679101','','','',1,0,0,'',0,0,0.00,1,NULL),(376,'Mark Onchari','brother','0743036549','Witeithie','KMFB793G','WITEITHIE STAGE ',4528,'PBJ0OU5PTGU','Gibson ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0705382125','','','',1,0,1,'SANLAM',1,0,50000.00,1,NULL),(377,'Simon Mburu ','brother','0701268232','Kiganjo','KMFE110W','Engen Thika',4,'PBJ7ITSG1R','Thomas',50.00,'','Partial Payment',1,NULL,'','M-PESA','0748700347','','','',1,0,0,'',0,0,0.00,1,NULL),(378,'Leah Nyambura ','wife','0715152369','Witeithie','KMFD108E','ENGEN THIKA',16,'PBJ0PUKKXI','Rueben',50.00,'','Partial Payment',1,NULL,'','M-PESA','0728517588','','','',1,0,0,'',0,0,0.00,0,NULL),(379,'Immaculate max ','wife','0740243684','Kisii Estate','KMDS478F','POSTA MAKONGENI',22,'PBK3VCR2DN','HASSAN',50.00,'','Partial Payment',1,NULL,'','M-PESA','0740243684','','','',1,0,0,'',0,0,0.00,1,NULL),(380,'jackline kathambi','wife','0793938297','Kiganjo','KMFC739L ','POSTA MAKONGENI',49,'PBK4V80V50','John ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0759116582','','','',1,0,1,'SANLAM',1,0,80000.00,1,NULL),(381,'Rachael Waithera','mum','0712127648','Kiganjo','KMFC982Q','POSTA MAKONGENI ',5,'PBK4V7U9WK','PHILIP',50.00,'','Partial Payment',1,NULL,'','M-PESA','0717843770','','','',1,0,1,'SANLAM ',0,0,0.00,1,NULL),(382,'Joyce Wanjiru ','mum','0725856744','Kiganjo','KMEU154C','ENGEN THIKA',11,'PBK6V3K4MG','John ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0746257870','','','',1,0,0,'',0,0,0.00,1,NULL),(383,'Abdala Tambwe','brother','0727760908','Kisii','KMEF582U','MAKONGENI POLYSAK',4,'PBJU6HL85','Ali',50.00,'','Partial Payment',1,NULL,'','M-PESA','0714854676','','','',1,0,1,'XPLICO ',0,0,0.00,1,NULL),(384,'Edwin Ochieng','Cousin','0705209847','Makongeni','KMEE065N','MAKONGENI THIKA',32,'PBJ8U55MGK','STEPHEN',50.00,'','Partial Payment',1,NULL,'','M-PESA','0705383931','','','',1,0,1,'TRIDENT ',0,0,0.00,1,NULL),(385,'Peter Kamau ','friend ','0729004021','Makongeni','KMDX907Q','UTI - TOWN SERVICE ',1,'PBJ1U869C1','SIMON',50.00,'','Partial Payment',1,NULL,'','M-PESA','0711474930','','','',0,1,1,'XPLICO ',0,0,0.00,1,NULL),(386,'Muthama Munyau','brother ','0700000','Phase 6 Thika','KMDX 903G','ENGEN THIKA ',28,'PBJ2U5MO88','SAMMY ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0745545528','','','',1,0,1,'SANLAM',0,0,0.00,1,NULL),(387,'John Chege','father ','0720483106','Thika','KMFE573E','ENGEN THIKA ',10,'PBJ2TVEE3Q','Laban',50.00,'','Partial Payment',1,NULL,'','M-PESA','0702224290','','','',1,0,0,'',0,0,0.00,1,NULL),(388,'Josephine Haron','wife','0704477531','Thika Phase 6','KMDQ879Y','MAKONGENI',39,'PBJ5U2D74T','HARON KASONZO ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0717896092','','','',1,0,0,'',0,0,0.00,1,NULL),(389,'Mary Wayua','wife','0717169102','Thika Phase 5','KMEW276B','POLYSACK MAKONGENI ',23,'PBJ5U3DYKZ','JOHN',50.00,'','Partial Payment',1,NULL,'','M-PESA','0714350543','','','',0,0,1,'TRIDENT ',0,0,0.00,1,NULL),(390,'Mwangi ','uncle','0721781255','Kiganjo ','KMFH733M','Engen Gretsa University',27,'PBJ7TX1TBT','KELVIN',50.00,'','Partial Payment',1,NULL,'','M-PESA','0723906029','','','',1,0,1,'SANLAM',1,0,50000.00,1,NULL),(391,'Irene Karimi','wife ','0790289599','Kiganjo','KMEZ353Q','ENGEN GRETSA UNIVERSITY ',2,'PBJ9TZ3ZPR','HARON',50.00,'','Partial Payment',1,NULL,'','M-PESA','0706330800','','','',1,0,1,'MONARCH ',0,0,0.00,0,NULL),(392,'Agnes Waithera','Sister','0725014278','Kiganjo','KMDY280G','ENGEN GRETSA UNIVERSITY ',14,'PBJ0UO5S7U','DANIEL ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0721839952','','','',1,0,1,'MONARCH ',0,0,0.00,1,NULL),(393,'John Kuria ','brother ','0723681618','Embakasi','KMFC364B','HIGH RISE',1,'PBL0WW6IIY','David ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0705973811','','','',1,0,1,'MONARCH',0,0,0.00,1,NULL),(394,'Joseph','Cousin ','0702174487','Kariobangi South','KMFG048A','KARIOBANGI MARKET ',1,'PBM8XA6LY4','John',50.00,'','Partial Payment',1,NULL,'','M-PESA','0721934056','','','',1,0,1,'SANLAM ',0,0,0.00,1,NULL),(395,'Faith Patient','wife','0748634448','Dandora ','KMFL054R','MOLEM PHEROSE',1,'PBL9WZQTNJ','ERICK ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0724079749','','','',1,0,1,'MONARCH ',0,0,0.00,0,NULL),(396,'Larry Kayson','son','0700000','Luck Summer ','KMFJ311K','kariobangi North ',1,'PBM5XCCA3P','KEVIN',50.00,'','Partial Payment',1,NULL,'','M-PESA','0704004232','','','',1,0,1,'APA INSURANCE ',1,0,200000.00,1,NULL),(397,'Joyce mukami','Sister ','0714611426','Satellite ','KMDS028D ','KAWANGWARE MAYAS',1,'PBK3UZDAV9','SIMON',50.00,'','Partial Payment',1,NULL,'','M-PESA','0758574768','','','',0,1,1,'XPLICO',0,0,0.00,1,NULL),(398,'Nicodemus Khavochi','father','0725671130','Kawangware','KMFK506A','KAWANGWARE 46',1,'PBK5V509SV','MICHAEL',50.00,'','Partial Payment',1,NULL,'','M-PESA','0796450729','','','',1,0,0,'',0,0,0.00,0,NULL),(399,'Oscar Shikundi','brother','0723959343','Kawangware','KMFF312T','KAWANGWARE 46',1,'PBK2V5OTHG','NICHOLAS',50.00,'','Partial Payment',1,NULL,'','M-PESA','0705573269','','','',0,0,1,'MONARCH',0,0,0.00,1,NULL),(400,'Godfrey Oyalo ','son','0712999690','Kawangware','KMFN160H','KAWANGWARE 46',1,'PBK9V1CTC9','ADRIANO',50.00,'','Partial Payment',1,NULL,'','M-PESA','0702383754','','','',0,0,1,'SANLAM ',1,1,198700.00,1,NULL),(401,'Dismas Boera','friend ','0790946829','Kawangware ','KMFJ376V','KAWANGWARE MBUFA',1,'PBK1V7R6OB','CHRISTOPHER ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0723775966','','','',1,0,0,'',0,0,0.00,1,NULL),(402,'Veronica Kamau','wife','0706975864','Kawangware','KMEX897X','KAWANGWARE, Genesis ',1,'PBK4V964H2','NICHOLAS ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0728465561','','','',1,0,0,'',0,0,0.00,1,NULL),(403,'Mercy Jendeka','wife ','0701126571','Kawangware','KMEY399N','junction mall',1,'PBK4VALSCA','MACMILLAN ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0768271284','','','',1,0,1,'MONARCH ',0,0,0.00,1,NULL),(404,'Evalyne Mugo','wife','0797197039','Dandora','KMFM427G','KOROKOCHO MARKET ',46,'PBM8XS4UKI','RICHARD ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0757643424','','','',1,0,1,'XPLICO',0,0,0.00,1,NULL),(405,'Jacinta Cynthia','friend','0716476966','Kisumu Ndogo ','KMEZ284K','KISUMU NDOGO',3,'PBM7XOKXCP','GEOFREY',50.00,'','Partial Payment',1,NULL,'','M-PESA','0114596474','','','',1,0,1,'MONARCH ',0,0,0.00,1,NULL),(406,'Joyce Wanjiku ','wife','0799455431','Kisumu Ndogo','KMEY342Q','Mutindwa',5,'PBM8XQSL6E','SIMON ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0797245973','','','',1,0,0,'',1,0,30000.00,1,NULL),(407,'Alfayo musalia','brother ','0701648748','Saika','KMEY038Q','KOROKOCHO MARKET',92,'PBM7XK72WD','MUSALIA',50.00,'','Partial Payment',1,NULL,'','M-PESA','0701161453','','','',1,0,1,'MONARCH ',0,0,0.00,1,NULL),(408,'Margaret Wanjiru ','mother','0714727648','Korokocho ','KMFM307G','KOROKOCHO MARKET',1,'PBM5XILHWJ','Francis ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0716562654','','','',1,0,0,'',0,0,0.00,1,NULL),(409,'Mercyline Adhiambo','sister ','0715242189','High Ridge ','KMEX306H','KOROKOCHO MARKET',1,'PNM3XKY5SX','EMMANUEL',50.00,'','Partial Payment',1,NULL,'','M-PESA','0792762573','','','',1,0,0,'',0,0,0.00,1,NULL),(410,'Francis Karanja ','father ','0710822106','Korokocho ','KMFH142W','KOROKOCHO MARKET',6,'PBM2XCLD6M','ZACHARIAH',50.00,'','Partial Payment',1,NULL,'','M-PESA','0711957566','','','',1,0,1,'PENTAGON',0,0,0.00,1,NULL),(411,'Beatrice Nyaboke','wife ','0701256560','Mathare','KMEM270M','KISUMU NDOGO',1,'PBM6XP5Q8E','MARCUS ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0758588975','','','',1,0,1,'MONARCH ',0,0,0.00,1,NULL),(412,'Fridah Wanja','wife','0703207226','Kariobangi','KMDM373Y','SUPALOAF',1,'PBM6XB500I','David ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0724801942','','','',1,0,1,'TRIDENT ',0,0,0.00,1,NULL),(413,'Deborah Bosibori','wife','0743925010','Korokocho ','KMES936M','KOROKOCHO MARKET',203,'PBM2XJ9FD8','LYDON',50.00,'','Partial Payment',1,NULL,'','M-PESA','0792561652','','','',1,0,1,'MONARCH ',0,0,0.00,1,NULL),(414,'Lucy Wanjiru ','mother','0723795842','Dandora','KMEN577Q','KOROKOCHO MARKET',1,'PBM0XMP8PM','JOSEPH ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0716612239','','','',1,0,0,'',0,0,0.00,1,NULL),(415,'Musembi','Friend','0752775274','Korokocho ','KMEV374Z','KOROKOCHO MARKET',1,'PBM7EGTXA','Justin',50.00,'','Partial Payment',1,NULL,'','M-PESA','0795628763','','','',0,1,0,'',0,0,0.00,1,NULL),(416,'Nancy Chepkiroi','wife','0716429837','Dandora','KMEL745L','KOROKOCHO MARKET',177,'PBM0XHAF00','PETER',50.00,'','Partial Payment',1,NULL,'','M-PESA','0713406348','','','',1,0,0,'',0,0,0.00,1,NULL),(417,'Ken Omondi','friend','0711509000','Kariobangi South ','KMFJ048V','KOROKOCHO MARKET',1,'PBM5XJ7584','MOSES',50.00,'','Partial Payment',1,NULL,'','M-PESA','0714428240','','','',1,0,1,'GA INSURANCE',0,0,0.00,1,NULL),(418,'Sylvus','Father ','0722887459','Dandora','KMFC572C','KOROKOCHO MARKET',1,'PBM1XK2J07','KENNEDY',50.00,'','Partial Payment',1,NULL,'','M-PESA','0711509000','','','',1,0,1,'GA INSURANCE ',0,0,0.00,1,NULL),(419,'KENNEDY OCHIENG ','friend ','0711509000','Korokocho','KMFG367D','KOROKOCHO MARKET  (KISUMU NDOGO)',1,'PBM4XOTPMQ','KENNEDY ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0751518429','','','',1,0,1,'SANLAM',0,0,0.00,0,NULL),(420,'Elizabeth Wanjiku ','Aunt','01113155961','Mastore','KMFL770H','Juja',5297,'PBN8YJ1W48','JAMES ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0717606446','','','',1,0,0,'',0,0,0.00,1,NULL),(421,'Alice Nata Tocho','wife','0715062096','Sewage','KMEL340S','FINE BREEZE',392,'PBN1YPWHLE','ROBERT',50.00,'','Partial Payment',1,NULL,'','M-PESA','0721205871','','','',1,0,0,'',0,0,0.00,1,NULL),(422,'Grace Nasimolo','wife ','0793579348','El-Mark','KMEZ679L','JUJA',21,'PBN2Y0T35W','COLLINS',50.00,'','Partial Payment',1,NULL,'','M-PESA','0792299619','','','',1,0,0,'',0,0,0.00,1,NULL),(423,'Wilson Muchiri','brother','0718725656','Greenfields','KMFH132X','BURUDANI',1,'PBN8YLD6ZE','IAN',50.00,'','Partial Payment',1,NULL,'','M-PESA','0741299023','','','',1,0,1,'SANLAM ',0,0,0.00,1,NULL),(424,'Pern Waithera','sister','0725714002','Gachororo','KMFM461H','Corner Stage',1,'PBN7YKOECD','TIMOTHY ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0741493646','','','',0,0,1,'SANLAM',1,0,100000.00,1,NULL),(425,'Vanessa Nkatha','Wife','0706063576','Salama','KMFD438E','Salama',3654,'PBH0YR2066','SAMUEL',50.00,'','Partial Payment',1,NULL,'','M-PESA','0768063614','','','',1,0,1,'MONARCH ',0,0,0.00,1,NULL),(426,'Samuel ','friend ','0768063614','Juja','KMFC938Q','SALAMA',4,'PBN47S4VIE','REMINGTON ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0757621971','','','',0,1,1,'MONARCH ',0,0,0.00,1,NULL),(427,'Margaret Njeri','wife','0790550648','Mungetho','KMFF220T','JUJA',257,'PBN8YPTZIY','SIMON',50.00,'','Partial Payment',1,NULL,'','M-PESA','0705457025','','','',1,0,1,'SANLAM GENERAL ',0,0,0.00,1,NULL),(428,'thuo','friend','0726741141','Murera','KMER691G','JUJA',3589,'PBN2YMIXBO','MICHAEL ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0111565204','','','',1,0,0,'',0,0,0.00,0,NULL),(429,'Agnes Wairimu ','wife','0794925881','Juja Murera','KMFC087A','JUJA ',4145,'PBN5YM1ZPX','DENNIS',50.00,'','Partial Payment',1,NULL,'','M-PESA','0791728046','','','',1,0,0,'',0,0,0.00,1,NULL),(430,'olypher','wife','0704456330','Juja Free Water','KMFK813A','JUJA',9708,'PBN2YKM85S','DENNIS',50.00,'','Partial Payment',1,NULL,'','M-PESA','0725818625','','','',1,0,1,'SANLAM GENERAL ',0,0,0.00,1,NULL),(431,'Caroline Njambi','wife','0724919021','Juja Murera ','KMDF322V','JUJA',3581,'PBN3YJP21F','JOSEPH ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0712523999','','','',1,0,0,'',0,0,0.00,1,NULL),(432,'Ruth Wanjiku','wife','07000000','Ndaraca','KMEY353C','JUJA',145,'PBN7YIPG13','Thomas Kilomo',50.00,'','Partial Payment',1,NULL,'','M-PESA','0700173182','','','',1,0,0,'',0,0,0.00,1,NULL),(434,'Rose Wanjiru ','mother','0715916645','Murera','KMFC908V','JUJA',1150,'PBN6YI1GX4','MORRIS',50.00,'','Partial Payment',1,NULL,'','M-PESA','0700881713','','','',1,0,0,'',0,0,0.00,1,NULL),(435,'Teresia Wanjiru ','wife ','0745551620','Murera','KMEW510S','JUJA ',1352,'PBN2YHIDTI','Francis',50.00,'','Partial Payment',1,NULL,'','M-PESA','0706631921','','','',1,0,0,'',0,0,0.00,1,NULL),(436,'ScolasticaJuma','sister','0741682158','Witeithie','KMFH588M','TUMAINI',1,'PBP52BKPVB','Fredrick ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0741116641','','','',1,0,1,'GA INSURANCE ',0,0,0.00,1,NULL),(437,'Julius Mbiu','friend','0714934041','Kianjau','KMCR092M','ELNINO',4,'PBP6281K2Q','John ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0729327902','','','',0,1,0,'',0,0,0.00,1,NULL),(438,'John Muthee','friend','0729327902','Kiandutu','KMDN597F','ELNINO',8,'PBP428FKOK','JULIUS ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0714934041','','','',1,0,0,'',0,0,0.00,1,NULL),(439,'Caroline Maina','wife ','0702965391','Kiganjo','KMEH662T','TOWNSHIP 2 TKY',91,'PBP520PSBJ','GIDEON',50.00,'','Partial Payment',1,NULL,'','M-PESA','0721121805','','','',1,0,1,'TRIDENT',0,0,0.00,1,NULL),(441,'Nancy Wairimu ','wife','0717387103','Athena','KMFB032N','TOWNSHIP 2 TKY',109,'PBP320IQ9F','DANIEL',50.00,'','Partial Payment',1,NULL,'','M-PESA','0715430809','','','',1,0,0,'',0,0,0.00,1,NULL),(442,'Rosemary Wacera','wife','0726661905','Township','KMEM227U','TOWNSHIP 2 TKY',15,'PBP41Z561G','PATRICK',50.00,'','Partial Payment',1,NULL,'','M-PESA','0720216874','','','',1,0,0,'',0,0,0.00,1,NULL),(443,'xxxxx','xxxxx','0700000','Athena','KMES604M','TOWNSHIP 2 TKY',76,'PBP31ZKA2P','SAMSON',50.00,'','Partial Payment',1,NULL,'','M-PESA','0708920059','','','',1,0,0,'',0,0,0.00,1,NULL),(444,'Teresia Muthoni','sister','0751290717','Kiandutu','KMES240A','TOWNSHIP 2 TKY',120,'PBP61ZJTO8','DOMISIANO',50.00,'','Partial Payment',1,NULL,'','M-PESA','0759647285','','','',1,0,0,'',0,0,0.00,1,NULL),(445,'Anastasia','mother ','0742131266','Gachororo','KMDS094N','CORNER STAGE',21002,'PBO824NCHA','TITUS',50.00,'','Partial Payment',1,NULL,'','M-PESA','0799096725','','','',1,0,0,'',0,0,0.00,1,NULL),(446,'Shantel Weru','daughter','0713800515','Gachororo','KMFH809B','PAWA',284,'PBP422457Q','CHARLES',50.00,'','Partial Payment',1,NULL,'','M-PESA','0713800515','','','',1,0,1,'MONARCH ',0,0,0.00,1,NULL),(447,'Joyce Wanjiku ','wife','0715277331','Gachororo','KMDA559C','POWER/PRIME',1,'PBP7215V5X','PETER',50.00,'','Partial Payment',1,NULL,'','M-PESA','0726691405','','','',1,0,0,'',0,0,0.00,1,NULL),(448,'Abel','brother','0719705751','Gachororo','KMEH909V','OXFORD ',1,'PBP91XRF49','JOSIAH',50.00,'','Partial Payment',1,NULL,'','M-PESA','0769231118','','','',1,0,1,'ARMACO',0,0,0.00,1,NULL),(449,'freshia Muthoni ','wife','0708903789','Witeithie','KMES246J','OXFORD',207,'PBP6IVVVN4','JAMES',50.00,'','Partial Payment',1,NULL,'','M-PESA','0726761451','','','',1,0,1,'XPLICO',0,0,0.00,1,NULL),(451,'Harrison Ndirangu','friend','0723515326','Kisii Estate','KMDA 012J','Buspark, makongeni',1,'PC319NRXSV','Kinuva',50.00,'001','Partial Payment',1,NULL,'','M-PESA','0717040545','','','',1,0,0,'',0,0,0.00,1,NULL),(452,'Paul kinuva','Friend','0717040545','Kiganjo','KMEH 858C','Buspark makongeni',1,'PC3490OJJY','Harrison',50.00,'001','Partial Payment',1,NULL,'','M-PESA','0700936771','','','',1,0,1,'Xplico',0,0,0.00,1,NULL),(454,'Wilson Macharia','brother','0701399818','Kiganjo','KMDA 386M','Kiganjo',1,'PC309XQC1E','Dennis Muthukia',50.00,'001','Partial Payment',1,NULL,'','M-PESA','0728001190','','','',1,0,1,'Xplico',0,0,0.00,1,NULL),(461,'John Njuguna','friend','0710907768','Kanyangu','KMFD 068V','Kangangu,kenol',1,'PC43B2IHJL','Fredrick',50.00,'001','Partial Payment',1,NULL,'','M-PESA','0790780955','','','',1,0,0,'',0,0,0.00,0,NULL),(462,'Mary Wanjiku','spouse','0754268648','Kabati ','KMFH 143U','Kabati',1,'PC48B99VDU','James',50.00,'001','Partial Payment',1,NULL,'','M-PESA','0712670840','','','',1,0,1,'The Monarch',0,0,0.00,0,NULL),(463,'Alice Wanjiku','Mother','0715940014','Kenyatta Farm','KMFL 918C','Kabati',1,'PC49BAK71P','Antony',50.00,'001','Partial Payment',1,NULL,'','M-PESA','0797094307','','','',1,0,0,'',0,0,0.00,1,NULL),(464,'Purity Muthoni','spouse','0111706852','Kabati','KMEE 648C','Kabati',1,'PC40BCEAP8','Henry',50.00,'001','Partial Payment',1,NULL,'','M-PESA','0792754481','','','',1,0,0,'',0,0,0.00,1,NULL),(465,'Joan Njeri','mother','071165772','Juja ','KMDT 749S','Juja,Thriller',1,'PC47BHA3YH','peter',50.00,'001','Partial Payment',1,NULL,'','M-PESA','0720472168','','','',1,0,0,'',0,0,0.00,1,NULL),(467,'Ann waithera','spouse','0719686242','Juja','KMFD 631V','JKUAT',1,'PC58C7320E','Laban',50.00,'001','Partial Payment',1,NULL,'','M-PESA','070511906','','','',1,0,1,'The monarch',0,0,0.00,0,NULL),(468,'Alice Kanuthu','Mother','0710346463','Gachororo','KMEV 402B','JKUAT',1,'PC56C7KLLO','James',50.00,'001','Partial Payment',1,NULL,'','M-PESA','0746636162','','','',1,0,0,'',0,0,0.00,1,NULL),(469,'Paul kimani','dad','0725779730','Juja','KMFB661E','JKUAT',1,'PC56C60LV2','Peter',50.00,'001','Partial Payment',1,NULL,'','M-PESA','0729824821','','','',1,0,0,'',0,0,0.00,1,NULL),(470,'Naomi Nduku','Spouse','0720977457','Mungetho','KMEY334G','JKUAT',1,'PC50C6VOYM','Onesmus',50.00,'001','Partial Payment',1,NULL,'','M-PESA','0720831399','','','',1,0,0,'',0,0,0.00,1,NULL),(471,'Edwin Kayanda','friend','074649827','Greenfields','KMDD 459M','Petpa,juja',1,'PC52CNPQUQ','Kellen',50.00,'001','Partial Payment',1,NULL,'','M-PESA','0718281656','','','',1,0,0,'',0,0,0.00,1,NULL),(472,'Jane Achieng','spouse','0708336597','Greenfields','KMDV 343H','Gate C,JKUAT',1,'PC57CPZ3LB','Robert',50.00,'001','Partial Payment',1,NULL,'','M-PESA','0705005275','','','',1,0,0,'',0,0,0.00,1,NULL),(473,'Divina Naika','Spouse','0708155776','Greenfields','KMFM 217D','Gate C,JKUAT',1,'PC52CQ0068','Alex',50.00,'001','Partial Payment',1,NULL,'','M-PESA','0714488598','','','',1,0,0,'',0,0,0.00,1,NULL),(474,'Florence kageni','Spouse','0762864313','St Paul','KMFF 915N','Gate c,Jkuat',1,'PC55RCQA69','Jonathan',50.00,'001','Partial Payment',1,NULL,'','M-PESA','0707257168','','','',0,1,0,'',0,0,0.00,1,NULL),(475,'Carol mwoi','sister','0724797272','Riabai','KMEH 415U','Kirigiti',1,'PC68DHQFAM','George',50.00,'001','Partial Payment',1,NULL,'','M-PESA','0799385953','','','',0,1,0,'',0,0,0.00,1,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,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,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,NULL),(482,'Beatrice Okech','Wife','0742928022','Ruiru ','KMFA222A','Ruiru Posta',208,'PC117HA30J','GEOFFREY',50.00,'','Partial Payment',1,NULL,'','M-PESA','0725621535','','','',1,0,0,'',0,0,0.00,1,NULL),(483,'Joyce Wanjiku','Wife','0713319778','Gwa Kairu','KMCA101Y','Ruiru footbridge',87,'PC30AKU8AW','James',50.00,'','Partial Payment',1,NULL,'','M-PESA','0723721127','','','',1,0,1,'Monarch',0,0,0.00,1,NULL),(484,'Faith Nduta','Wife','0714748236','Kwihota','KMFH845H','Ruiru Rainbow',16,'PC116YW367','Patrick',50.00,'','Partial Payment',1,NULL,'','M-PESA','0713719819','','','',0,1,1,'Monarch',0,0,0.00,1,NULL),(485,'Nancy Mumbi','Wife','0702324356','St Christopher ','KMFC490P','Ruiru Kwa Kairu',1695,'AC359PBUv','Joel',50.00,'','Partial Payment',1,NULL,'','M-PESA','0702731112','','','',1,0,0,'',0,0,0.00,1,NULL),(486,'Noura','Brother','0707389904','Exodus','KNEW3560','Ruiru Kwakairu',1758,'PC389LOE92','Peter',50.00,'','Partial Payment',1,NULL,'','M-PESA','0791951635','','','',1,0,0,'',0,0,0.00,1,NULL),(487,'Neriah Mogogo','Wife','0705122587','Wataalam','KMEN177F','Kwa Kairu',1753,'PC33913041','Paul',50.00,'','Partial Payment',1,NULL,'','M-PESA','0710192452','','','',1,0,0,'',0,0,0.00,1,NULL),(488,'John Kamau','Brother','0720202585','Ruiru Rainbow','KMED860K','RUIRU rainbow',116,'PCI475W4C4','Philip',50.00,'','Partial Payment',1,NULL,'','M-PESA','0717608359','','','',1,0,0,'',0,0,0.00,1,NULL),(489,'Margret Njeri','Wife','0759938771','Murera','KMFJ098A','Boggie',148,'PC35A2VEOJ','Barnabas',50.00,'','Partial Payment',1,NULL,'','M-PESA','074369457','','','',1,0,1,'Sanlam GA',0,0,0.00,1,NULL),(490,'Lucy Wambui','Wife','0720337613','Riuriru','KMFf1075','Ruiru Kwa kairu',1730,'PC389YO1YU','Daniel',50.00,'','Partial Payment',1,NULL,'','M-PESA','0726382408','','','',1,0,1,'Sanlam General',0,0,0.00,1,NULL),(491,'Waweru','Friend','0718791528','Murera','KMEZ083E','Ruiru dell kwa kairu',1633,'PC39158CU','John',50.00,'','Partial Payment',1,NULL,'','M-PESA','0795639702','','','',1,0,0,'',0,0,0.00,0,NULL),(492,'Gitau','Father','0700000000','Murera','KMFD6374','Ruiru reli kwa kwairu',4172,'PC3995M88R','JOHN',50.00,'','Partial Payment',1,NULL,'','M-PESA','0704610934','','','',1,0,1,'Sanlam General',0,0,0.00,1,NULL),(493,'John','friend','0704610934','Mugutha','KMDL485F','RUIRU Reli Bridge',2001,'PC339RU9G7','Joel',50.00,'','Partial Payment',1,NULL,'','M-PESA','0726157040','','','',1,0,0,'',0,0,0.00,1,NULL),(494,'Lucy Wangui','Mother','0715298524','Kabuti','KMES708R','Kabati',5,'PC42BCIGOK','Jackson',50.00,'','Partial Payment',1,NULL,'','M-PESA','0757174787','','','',1,0,0,'',0,0,0.00,1,NULL),(495,'Lucy Njane','Wife','0707784313','Kenol','KMCG625L','Katipanga',1,'PC40BCGOBW','Charles',50.00,'','Partial Payment',1,NULL,'','M-PESA','0719225322','','','',1,0,0,'',0,0,0.00,1,NULL),(496,'Wambui','Mother','0703749515','Kenol ','KMEV482M','Kenol Junction',4,'PC47B3GXM1','Samuel',50.00,'','Partial Payment',1,NULL,'','M-PESA','0715462572','','','',0,0,0,'',0,0,0.00,1,NULL),(497,'Mburu','Friend','0724267121','kenol ','KMDZ8297','Kenol Junction',1,'PCLILB2CXUD','David',50.00,'','Partial Payment',1,NULL,'','M-PESA','0727295581','','','',1,0,0,'',0,0,0.00,1,NULL),(498,'Joyce Mumbi','Wife','0704667948','Kenol','KMFJ336F','Kenol Junction',8,'PC42B1IWXC','Boniface',50.00,'','Partial Payment',1,NULL,'','M-PESA','0715140115','','','',1,0,1,'GA Insuarance Limited',0,0,0.00,1,NULL),(499,'Rebecca Wangeci','Mother','0725255646','Kenol ','KMDV303V','Kenol Junction',14,'DC490453V','Moses',50.00,'','Partial Payment',1,NULL,'','M-PESA','0721699530','','','',1,0,1,'unipora',0,0,0.00,1,NULL),(500,'Ester Wairimu','Wife','0719602530','Kagaa','KMFM960E','Magomano B',4,'PC41AWMJNF','Samuel',50.00,'','Partial Payment',1,NULL,'','M-PESA','0757950480','','','',1,0,1,'Sanlam General',0,0,0.00,1,NULL),(501,'John Mwangi','Friend','0798468314','Thangira','KMEY608V','Mitiini',11,'PC43B6TAV1','David',50.00,'','Partial Payment',1,NULL,'','M-PESA','0717593872','','','',1,0,0,'',0,0,0.00,1,NULL),(502,'Rachel Wangari','Wife','0712963694','Kenol','KMFA438T','Kwa D.C',1,'PC46B488VO','Joel',50.00,'','Partial Payment',1,NULL,'','M-PESA','0710775412','','','',1,0,0,'',1,0,16000.00,1,NULL),(503,'xx','xx','070000000','Kenol','KMEY7842','Kwa D.C Kenol',1,'PC44B3JNM6','Francis',50.00,'','Partial Payment',1,NULL,'','M-PESA','0794609440','','','',1,0,0,'',0,0,0.00,1,NULL),(504,'Mercy Mutire','Wife','0792846839','Kiambu','KMFE048E','Twigamart',1,'PC600XVEPBY','Ruel',50.00,'','Partial Payment',1,NULL,'','M-PESA','0796029212','','','',1,0,1,'Sanlam',0,0,0.00,1,NULL),(505,'Damaris','Wife','0796181390','Kiambu ','KMEV775E','Rumathi',1,'PC6UBU9GGA','Lawrence',50.00,'','Partial Payment',1,NULL,'','M-PESA','0751591300','','','',0,1,0,'',0,0,0.00,1,NULL),(508,'xx','xx','070000000','Municipality','KMEH483C','Municipality',1,'PC69OQB5KT','Emmanuel',50.00,'','Partial Payment',1,NULL,'','M-PESA','0711481609','','','',1,0,0,'',0,0,0.00,1,NULL),(509,'John','Friend','0716231678','Kirigiti','KMEH2431','Stadium',2,'PC61DJREVV','Martin',50.00,'','Partial Payment',1,NULL,'','M-PESA','0716411509','','','',1,0,0,'',0,0,0.00,1,NULL),(510,'Antony','Friend','0746093247','Kirigiti','KMEL159E','Stadium',1,'PC65DJHJE3','John',50.00,'','Partial Payment',1,NULL,'','M-PESA','0716231678','','','',1,0,0,'',0,0,0.00,1,NULL),(511,'Carol Wangari','wife','0716788642','Wangige','KMEW562Y','WANGIGE ',43,'PC37A2MIJ3','JOHN',50.00,'','Partial Payment',1,NULL,'','M-PESA','0701314598','','','',1,0,1,'ARMACO',0,0,0.00,0,NULL),(512,'Peter Mburu','son','0726169983','Kikuyu','KMEL664M','KIKUYU',41,'PC379UO639','JOSEPH',50.00,'','Partial Payment',1,NULL,'','M-PESA','0726169983','','','',1,0,1,'RWABE',0,0,0.00,1,NULL),(513,'Elizabethw','Wife','0745305332','Kiambu High','KMEM3862','Kiringiti Transformer',7,'PC61D16C4X','Daniel',50.00,'','Partial Payment',1,NULL,'','M-PESA','0706087916','','','',1,0,1,'Sanlam',0,0,0.00,1,NULL),(514,'xxxxx','xxxx','0700000','Kikuyu','KMEH079X','KIKUYU ',18,'PC309TOTHQ','ERIC',50.00,'','Partial Payment',1,NULL,'','M-PESA','0723753317','','','',1,0,1,'MADISON ',0,0,0.00,1,NULL),(515,'Esther Mangati','wife','0790730811','Kikuyu','KMEQ507B','KIKUYU SHELL',44,'PC329RBET2','SULEIMAN',50.00,'','Partial Payment',1,NULL,'','M-PESA','0757242112','','','',0,0,1,'TRIDENT ',0,0,0.00,1,NULL),(516,'Michael Mbugua','brother ','0718840696','Kikuyu','KMFL782G','KIKUYU SHELL ',99,'PC309R4841','ANTHONY',50.00,'','Partial Payment',1,NULL,'','M-PESA','0719463448','','','',1,0,0,'',0,0,0.00,1,NULL),(517,'Esther Muthonj','Wife','0700714309','Kiambu','KMEC07K','Kiambu Town',1,'PC66DQH82K','Josphat',50.00,'','Partial Payment',1,NULL,'','M-PESA','0790728726','','','',1,0,0,'',0,0,0.00,1,NULL),(518,'Teresiah Njeri','Wife','0799264872','Kiambu','KMFF848A','Kiambu Town',1,'PC60DQ2L55S','James',50.00,'','Partial Payment',1,NULL,'','M-PESA','0746270013','','','',1,0,1,'Monarch',0,0,0.00,1,NULL),(519,'Joseph ','brother ','0726169983','Kikuyu','KMDH716U','KIKUYU ',1,'PC339UMU93','DAVID',50.00,'','Partial Payment',1,NULL,'','M-PESA','0714216545','','','',1,0,1,'RWABE',0,0,0.00,1,NULL),(520,'xx','xx','0700000000','Kiambu, Ngegu','KMEQ2939','Kiambu, Ngegu',1,'PC60DQMPRM','Jackson',50.00,'','Partial Payment',1,NULL,'','M-PESA','0706105985','','','',0,1,1,'AKI',0,0,0.00,1,NULL),(521,'xx','xx','0700000000','Kirigiti Junction ','KMEP039D','Junction',1,'PX51D4J5CD','George',50.00,'','Partial Payment',1,NULL,'','M-PESA','0715275440','','','',1,0,1,'Madison',0,0,0.00,1,NULL),(522,'Hannah Wambui','wife','0797573958','Kirigiti','KMOY305Q','Kirigiti',1,'PC64DKRJ8M','Michael',50.00,'','Partial Payment',1,NULL,'','M-PESA','0745150230','','','',1,0,0,'',0,0,0.00,1,NULL),(523,'xx','xx','0700000000','Kirigiti ','KMEK175M','Kirigiti',1,'PC61DJLHU1','James',50.00,'','Partial Payment',1,NULL,'','M-PESA','0710371979','','','',1,0,0,'',0,0,0.00,1,NULL),(524,'Hannah Wanjiku','Mother','0729984183','Kirigiti','KMEJ868F','Kirigiti',1,'PC68DJ1DKW','Oliver',50.00,'','Partial Payment',1,NULL,'','M-PESA','0790841296','','','',1,0,1,'Sanlam',0,0,0.00,1,NULL),(525,'Felistus Wairimu','Mother','0710739633','Kirigiti ','KMFK914C','Kiringiti',1,'PC64DIKOH2','Denis',50.00,'','Partial Payment',1,NULL,'','M-PESA','0757568583','','','',1,0,1,'Sanlam',0,0,0.00,1,NULL),(526,'Sarah Chelagat','Wife','0740873829','Kirigiti','KMEN912N','Kirigiti',20,'PC64DHSZBU','Peter',50.00,'','Partial Payment',1,NULL,'','M-PESA','0743186764','','','',1,0,1,'Xplico',0,0,0.00,1,NULL),(527,'Mary Wanjiru','Mother','0745086915','Kirigiti','KMFM398P','Kirigiti',1,'PC60DIIOQM','Morris',50.00,'','Partial Payment',1,NULL,'','M-PESA','0740873829','','','',1,0,0,'',0,0,0.00,1,NULL),(528,'Hannah Wambui','Wife','0774550161','Riabai','KMFK066C','Kirigiti',1,'PC60DLO98E','Geoffrey',50.00,'','Partial Payment',1,NULL,'','M-PESA','0718061276','','','',1,0,0,'',0,0,0.00,1,NULL),(529,'Jennifer Wanja','wife','0706503209','Kikuyu','KMEG581K','KIKUYU',1,'PC379TITY5','KENNEDY',50.00,'','Partial Payment',1,NULL,'','M-PESA','0702393995','','','',1,0,0,'',0,0,0.00,1,NULL),(530,'xxxx','xxxx','070000','Kikuyu','KMFJ518U','KIKUYU ',1,'PC3295JYVG','HASSAN ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0721967267','','','',1,0,0,'',0,0,0.00,1,NULL),(531,'David','Brother','0706531769','Kikuyu','KMEK915T','KIKUYU ',82,'PC389QZ532','GEORGE',50.00,'','Partial Payment',1,NULL,'','M-PESA','0724038294','','','',1,0,0,'',0,0,0.00,1,NULL),(532,'George ','brother ','0724038294','kikuyu ','KMFG807E','KIKUYU ',1,'PC349QQRS8','DAVID',50.00,'','Partial Payment',1,NULL,'','M-PESA','0706531769','','','',1,0,1,'XPLICO ',0,0,0.00,1,NULL),(533,'Mary Nyakio','Daughter','0722935481','Ruiru','KMDG692Q','Ruiru Gospel',1109,'PC52CKF8QQ','Paul',50.00,'','Partial Payment',1,NULL,'','M-PESA','0722935481','','','',1,0,1,'Captain',0,0,0.00,1,NULL),(534,'David  njeraini','father','0721823472','Kikuyu','KMFA240R','KIKUYU ',65,'PC329Q4UBC','EDWIN',50.00,'','Partial Payment',1,NULL,'','M-PESA','0724294994','','','',1,0,0,'',0,0,0.00,1,NULL),(535,'James jabuya','coworker','0721871487','Ruiru','KMCF019D','Ruiru Masaku',633,'PC55CDB3T7','John',50.00,'','Partial Payment',1,NULL,'','M-PESA','0724447818','','','',1,0,1,'Xplico',0,0,0.00,1,NULL),(536,'Kallen Wangari','wife','0712601502','Wangige','KMEU322E','WANGIGE',1,'PC31AZIEE3','FRANCIS',50.00,'','Partial Payment',1,NULL,'','M-PESA','0715720634','','','',1,0,1,'MONARCH',0,0,0.00,1,NULL),(537,'Ruth ','wife ','0114061095','Marurui','KMFA916M','MARURUI',1,'PBM7XR6QHD','George',50.00,'','Partial Payment',1,NULL,'','M-PESA','0715377612','','','',1,0,1,'MONARCH ',0,0,0.00,0,NULL),(538,'Lucy Wanjiru','Wife','0710288773','Ruiru, Masaku','KMDK965U','Ruiru, Masaku',644,'PC58CCRF22U','Joseph',50.00,'','Partial Payment',1,NULL,'','M-PESA','0712590937','','','',1,0,0,'',0,0,0.00,1,NULL),(539,'Elizabeth ','mother','070000','Gitaru','KMFG223D','GITARU ',1,'PC208L4HDC','Alex',50.00,'','Partial Payment',1,NULL,'','M-PESA','0720326849','','','',1,0,1,'MARKHOLDING',0,0,0.00,1,NULL),(540,'xx','xx','0700000000','Ruiru, Masaku','KMFD993G','Ruiru, Masaku',639,'PC52CCEOPE','Peter',50.00,'','Partial Payment',1,NULL,'','M-PESA','0713353164','','','',1,0,1,'Sanlam',0,0,0.00,1,NULL),(541,'Kennedy Munene','brother','0725012821','Gitaru','KMEM588K','GITARU',1,'PC258KATRI','PETER',50.00,'','Partial Payment',1,NULL,'','M-PESA','0728001648','','','',1,0,0,'',0,0,0.00,1,NULL),(542,'Rawlings Siguna','Brother','0712222515','Ruiru, Wataalam','KMFL879H','Ruiru Wataalam Booster',3,'PC51CBHEVI','Donald',50.00,'','Partial Payment',1,NULL,'','M-PESA','0724463270','','','',1,0,1,'I PAX',0,0,0.00,1,NULL),(543,'Gianna Waithera','Daughter','0713531825','Ruiru, Githothua','KMFE268A','Mama Shop',253,'PC57CRIL5J','Francis',50.00,'','Partial Payment',1,NULL,'','M-PESA','0713531825','','','',0,1,1,'Comprehensive',0,0,0.00,1,NULL),(544,'Levis Muigai','Son','0705480151','Ruiru, Biashara ','KMFM4072','Biashara',511,'PC54C710M2','JOSEPH',50.00,'','Partial Payment',1,NULL,'','M-PESA','0705480151','','','',1,0,1,'Sanlam',0,0,0.00,1,NULL),(545,'xx','xx','0700000000','Ruiru, Githunguri Bypass','KMEP464F','Ruiru, Githunguri Bypass',1134,'PC52CTFUTM','Simon',50.00,'','Partial Payment',1,NULL,'','M-PESA','0727557452','','','',1,0,0,'',0,0,0.00,1,NULL),(546,'Grace Nyiha','wife','0706878086','Githunguri','KMDJ983H','Ruiru, Githunguri',1129,'PC58CTE2QZ','Samuel',50.00,'','Partial Payment',1,NULL,'','M-PESA','0706502278','','','',1,0,0,'',0,0,0.00,1,NULL),(547,'Rose Njogu','Wife','0707150588','Ruiru, Biashara','KMEF630V','Full Gospel Stage',1114,'PC57G1N5WL','Patrick',50.00,'','Partial Payment',1,NULL,'','M-PESA','0727382167','','','',1,0,0,'',0,0,0.00,1,NULL),(548,'Julius Mwenda','Friend','0708370342','Ruiru, Rainbow ','KMOW777E','Ruiru Rainbow',2,'PC53C97OKB','Douglas',50.00,'','Partial Payment',1,NULL,'','M-PESA','0741140884','','','',1,0,1,'Trident Insurance',0,0,0.00,1,NULL),(549,'xx','xx','0700000000','Hilton ','KMEW790W','Hilton',1042,'PC54CHXH28','Henry',50.00,'','Partial Payment',1,NULL,'','M-PESA','0703652188','','','',0,1,0,'',0,0,0.00,1,NULL),(550,'Brigit','Wife','0712685759','Gitambaya','KMDC827C','Wataalamu Kiambu',883,'PC51CF5XKV','Timothy',50.00,'','Partial Payment',1,NULL,'','M-PESA','0721477007','','','',1,0,0,'',0,0,0.00,1,NULL),(551,'xx','xx','0700000000','Gitambaya ','KMFE900E','Ruiru, Masaku',969,'PC54CD5SNVM','Francis',50.00,'','Partial Payment',1,NULL,'','M-PESA','0708647397','','','',1,0,0,'',0,0,0.00,1,NULL),(552,'Irungu','Friend','0724447818','Gitambaya ','KMDQ582D','Ruiru, Masaku',628,'PC56CCUHIE','James',50.00,'','Partial Payment',1,NULL,'','M-PESA','0721871487','','','',1,0,1,'Monarch',0,0,0.00,1,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,NULL),(554,'Mercy','Friend','0718401363','githurai ','KMCK689T','Githurai',1,'PC58CARM5Y','Peter',50.00,'','Partial Payment',1,NULL,'','M-PESA','0741905116','','','',1,0,0,'',0,0,0.00,1,NULL),(555,'xx','xxx','0700000000','Gitothua','KMEE817C','Mama Shop',257,'PC56CN9O1Q','Stephen',50.00,'','Partial Payment',1,NULL,'','M-PESA','0726699267','','','',1,0,0,'',0,0,0.00,1,NULL),(556,'Leah Wambui','Wife','0713997970','Briria ','KMDE6997','Kika Stores',1,'PC87GAR9SF','Peter',50.00,'','Partial Payment',1,NULL,'','M-PESA','0710701294','','','',1,0,0,'',0,0,0.00,1,NULL),(557,'James Kamande','Father','0725865508','Gitura','KMGX261P','Kenol Town',34,'PC49AZZCFR','Francis',50.00,'','Partial Payment',1,NULL,'','M-PESA','0748269124','','','',1,0,0,'',0,0,0.00,1,NULL),(558,'Francis Mbugua','Friend','0794609440','Kangangu','KMFC410N','Kwa D.C Kenol',1,'PC49B2IQAJ','John',50.00,'','Partial Payment',1,NULL,'','M-PESA','0710907768','','','',1,0,0,'',1,0,40000.00,1,NULL),(559,'Margaret Mumbi','Wife','0723565755','Kagaa','KMED756K','Kenol Town',1,'PC41AW8CEZ','James',50.00,'','Partial Payment',1,NULL,'','M-PESA','0724145933','','','',1,0,1,'Madison',0,0,0.00,1,NULL),(560,'Henry Karanja','Friend','0792754481','Kabati','KMFH120W','County Supermarket',14,'PC44BCMASQ','Antony',50.00,'','Partial Payment',1,NULL,'','M-PESA','0741270887','','','',1,0,0,'',1,0,50000.00,1,NULL),(561,'Jane Nduta','Wife','0796836520','Jerusalem ','KMFE5394','Kabati Flyover',1,'PC46BE7FYK','Suleiman',50.00,'','Partial Payment',1,NULL,'','M-PESA','0795038565','','','',1,0,0,'',0,0,0.00,1,NULL),(562,'Patrick gitau','brother ','0717540630','Gitaru','KMFE888N','GITARU ',1,'PC298GBLZ','ALEX',50.00,'','Partial Payment',1,NULL,'','M-PESA','0743751142','','','',0,0,0,'',0,0,0.00,1,NULL),(563,'Ruth ','mother','0725830469','Gitaru','KMEF274V','GITARU',95,'PC218ELN3R','JOHN',50.00,'','Partial Payment',1,NULL,'','M-PESA','0725013190','','','',1,0,0,'',0,0,0.00,1,NULL),(564,'Emmanuel Waiharo','son','0112646843','Gitaru','KMFG390T','GITARU RUKUBI',37,'PC288L8126','PAUL',50.00,'','Partial Payment',1,NULL,'','M-PESA','0785728294','','','',1,0,1,'XPLICO',0,0,0.00,1,NULL),(565,'xxxxx','xxxxx','0700000','Gitaru','KMEY886B','GITARU KANJERU',1,'PC2881MLFY','SOLOMON',50.00,'','Partial Payment',1,NULL,'','M-PESA','0759312640','','','',1,0,1,'EQUITY',0,0,0.00,1,NULL),(566,'Mary Wangechi','wife','0721786214','Gitaru','KMFF010Z','GITARU',1,'PC248I7IBM','KENNEDY',50.00,'','Partial Payment',1,NULL,'','M-PESA','0720681015','','','',1,0,1,'SANLAM GENERAL',0,0,0.00,1,NULL),(567,'Beth Wambui','mother ','0716904800','Gitaru','KMEW691U','GITARU ',1,'PC248HD6UK','JAMES',50.00,'','Partial Payment',1,NULL,'','M-PESA','0759017831','','','',0,0,1,'XPLICO',0,0,0.00,0,NULL),(568,'Eunice Njeri ','mother','0745151968','Gitaru','KMDT642U','GITARU MLANGO SOKO',1,'PC218GJ5SF','MARTIN',50.00,'','Partial Payment',1,NULL,'','M-PESA','0790757798','','','',1,0,0,'',0,0,0.00,1,NULL),(569,'Lizer Mumbi','wife ','0719389319','Mathare','KMDR487Y','MATHARE',2,'PC80GDCUG5','Boniface',50.00,'','Partial Payment',1,NULL,'','M-PESA','0720902591','','','',1,0,1,'XPLICO',0,0,0.00,1,NULL),(570,'Mary','wife','0791846203','Kibera','KMDW856S','KIBERA',1,'PC87GD3N3J','DAVID',50.00,'','Partial Payment',1,NULL,'','M-PESA','0708951036','','','',1,0,0,'',0,0,0.00,1,NULL),(571,'daisy','child','0700000','Kibera','KMEQ316Y','KIBERA',1,'PC84GCNX9G','ISAAC',50.00,'','Partial Payment',1,NULL,'','M-PESA','0741572116','','','',0,0,1,'MONARCH',0,0,0.00,1,NULL),(572,'Ayuma Rumonah','mother','0727374870','Pipeline ','KMFF927A','Industrial Area',1,'PC82GCIAGO','KENNEDY',50.00,'','Partial Payment',1,NULL,'','M-PESA','0799037766','','','',0,0,1,'TRIDENT',0,0,0.00,1,NULL),(573,'Ruth Muthoni','mother','0702697024','Githurai','kmfc 065z','GITHURAI',1,'PC88GCFHUS','JOSEPH',50.00,'','Partial Payment',1,NULL,'','M-PESA','0727681116','','','',1,0,0,'',0,0,0.00,1,NULL),(574,'Susan  Wanjiru Kihoro','friend ','0727434169','GITHURAI ','KMFF988K','GITHURAI',1,'PC85GCC9RJ','FRANCIS ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0790902308','','','',1,0,0,'',0,0,0.00,0,NULL),(575,'Valley Khavera','wife','0796613731','Kibera','KMEP448C','KIBERA',1,'PC83GC9FE7','ANTONY',50.00,'','Partial Payment',1,NULL,'','M-PESA','0721706939','','','',1,0,0,'',0,0,0.00,1,NULL),(576,'Rehema Wanjiru','daughter','0700000','Githurai','KMDU772R','GITHURAI ',1,'PC83GC2WOV','EFFORD',50.00,'','Partial Payment',1,NULL,'','M-PESA','0720078240','','','',1,0,0,'',0,0,0.00,1,NULL),(577,'Emmeccurate Kanini','wife','0723462104','Githurai','KMET208Q','GITHURAI ',1,'PC89GBYGWF','GEOFFREY',50.00,'','Partial Payment',1,NULL,'','M-PESA','0723014982','','','',0,0,0,'',0,0,0.00,1,NULL),(578,'xxxx','xxxxx','070000','Car','KMER265E','CAR AND GENERAL',71001,'PCH61B42VO','Martin',0.00,'','To Pay Later',0,'2022-01-01 00:00:00','Later ','M-PESA','0712864798','','','',1,0,1,'MONARCH',0,0,0.00,0,NULL),(579,'xxxx','xxxx','070000','Kangemi ','KMFH445Z','KANGEMI',1,'PC84FBTNRS','GODFREY ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0796634272','','','',1,0,1,'PROGRESSIVE',0,0,0.00,1,NULL),(580,'Geoffrey ','brother','0721790695','Kangemi','KMET242W','KANGEMI ',12,'PBH541SQ2','JARED',0.00,'','To Pay Later',0,'2021-04-09 00:00:00','Later ','M-PESA','0721529511','','','',1,0,1,'XPLICO',0,0,0.00,0,NULL),(581,'joy mwende','wife','0113009440','Kangemi','KMFD380L','KIBERA',1,'xxxx','EVANS',0.00,'','To Pay Later',0,'2021-04-09 00:00:00','Later','M-PESA','0758773782','','','',1,0,0,'',0,0,0.00,0,NULL),(582,'Jane Njeri','Wife','0742995627','Kangangu','KMEF697X','Kenol, Kenneth Matiba ',1,'PC44BORNVC','Peter',50.00,'','Partial Payment',1,NULL,'','M-PESA','0719862374','','','',1,0,0,'',0,0,0.00,1,NULL),(583,'nelly Wanjiru ','wife','0792686471','Githurai ','KMFK445B','GITHURAI ',1,'xxxx','PAUL',0.00,'','To Pay Later',0,'2021-04-09 00:00:00','Later ','M-PESA','0714599589','','','',1,0,1,'SANLAM GENERAL',0,0,0.00,0,NULL),(584,'xxxx','xxxx','070000','Uthiru','KMLO416P','UTHIRU',1,'xxxx','DAVID',0.00,'','To Pay Later',0,'2021-04-09 00:00:00','Later ','M-PESA','0743331028','','','',1,0,1,'MONARCH ',0,0,0.00,0,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,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,NULL),(587,'Joyce Njeri','Wife','0720039859','Kayole','KMFD229F','Kayole / Nairobi',1,'PBNIXICCN6','Josphat',50.00,'','Partial Payment',1,NULL,'','M-PESA','0723279682','','','',1,0,1,'Sanlam',0,0,0.00,1,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,NULL),(589,'Stephen  Mumina','Brother ','0701526539','Kayole ','KMEF','Kayole',1,'PBN3Y137ND','Athanas',50.00,'','Partial Payment',1,NULL,'','M-PESA','0728406597','','','',0,0,1,'APA Insuarance',1,1,45000.00,1,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,NULL),(591,'Hilda Musau','Wife','0713414214','Kayole','KMDA983H','Kayole',1,'PBN1Y15UXV','Moses',50.00,'','Partial Payment',1,NULL,'','M-PESA','0712199061','','','',1,0,0,'',0,0,0.00,1,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,NULL),(593,'Mercy Wangui','Mother','0712756573','Kayole ','KMER751H','Kayole',1,'PBNIYI8C6N','Stephen Mwangi',50.00,'','Partial Payment',1,NULL,'','M-PESA','0742232782','','','',1,0,0,'',0,0,0.00,1,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,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,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,NULL),(597,'Ruth Ntinda','Wife','0797565754','Kayole','KMFH005U','Kayole',1,'KMFH005U','Bednego',50.00,'','Partial Payment',1,NULL,'','M-PESA','0797381842','','','',1,0,1,'Ranger',1,0,50000.00,1,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,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,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,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,NULL),(602,'Benard Mwisheni','Cousin','0728809002','Kibra','KMET194L','Kibra',1,'PBMIXTQJHM','Adede Benjamin',50.00,'','To Pay Later',0,'2021-04-09 00:00:00','Later ','M-PESA','0704707062','','','',1,0,1,'Monarch',0,0,0.00,0,NULL),(603,'John Kagotho','Friend','0713107749','Kangangu','KMED499X','Kenneth Matriba Kenol',1,'KMED499X','Francis',50.00,'','Partial Payment',1,NULL,'','M-PESA','0725492670','','','',1,0,0,'',0,0,0.00,1,NULL),(604,'Peter Ndirangu','Friend','0726212599','Kenol','KMFF892E','Kenol Kenneth Matiba',1,'PC46BOOLUO','Josphat',50.00,'','Partial Payment',1,NULL,'','M-PESA','0794268912','','','',1,0,0,'',0,0,0.00,0,NULL),(605,'Cecilia','Mother','0729849166','Juja','KMDL0225','Gachoro',1,'PC40BN05IA','Antony',50.00,'','Partial Payment',1,NULL,'','M-PESA','0729849166','','','',1,0,0,'',0,0,0.00,1,NULL),(606,'Susan Wambui','Wife','0729629378','Kiganjo ','KMER998D','Thika Main Stage',1,'PC49AYT7MH','Macharia',50.00,'','Partial Payment',1,NULL,'','M-PESA','0726807908','','','',1,0,0,'',0,0,0.00,1,NULL),(607,'Freshia Wanjiru','Wife','0717160101','Santamore','KMDD843B','Kenol Magomano',1,'PC46AVRWIK','Moses',50.00,'','Partial Payment',1,NULL,'','M-PESA','0725461651','','','',1,0,0,'',0,0,0.00,1,NULL),(608,'Rose Gachoki','Friend','0713527053','Kenol','KMFH344F','Kenol Magomano',1,'PC4OAWBZHK','Victor  ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0713905194','','','',1,0,0,'',0,0,0.00,0,NULL),(609,'Robert Nderitu','Brother','0716083541','Kenol ','KMDT411H','Kenol Magomano',1,'PC48AWKMP4','Charles',50.00,'','Partial Payment',1,NULL,'','M-PESA','0797581060','','','',1,0,0,'',0,0,0.00,1,NULL),(610,'Martha Wanja','Mother ','0712722777','Kagaa','KMFE600K','Kenol Kuboo',1,'PC41AVE52T','Peterson',50.00,'','Partial Payment',1,NULL,'','M-PESA','0740311829','','','',1,0,0,'',0,0,0.00,1,NULL),(611,'Redemer','Wife','0797330219','South B','KMFG037L','South B',1,'PBH4RQZET8','Josphat',50.00,'','Partial Payment',1,NULL,'','M-PESA','0706620979','','','',1,0,1,'Sanlam',1,0,30000.00,1,NULL),(612,'xx','xx','0700000000','South B','KMFH929A','South B',1,'PBH2RFDZJI','32413964',50.00,'','Partial Payment',1,NULL,'','M-PESA','0713927696','','','',1,0,0,'',0,0,0.00,1,NULL),(613,'Beatrice','Wife','071140018','Wilson','KMDW357T','South C',1,'PBH5RH091F','32485632',50.00,'','Partial Payment',1,NULL,'','M-PESA','0797281945','','','',1,0,1,'AKI Insurance',0,0,0.00,1,NULL),(614,'Mike Ngugi','Cousin','0701311645','Pipeline','KMEV776M','South C',1,'PBH8R147B4','James',50.00,'','Partial Payment',1,NULL,'','M-PESA','0798763376','','','',1,0,1,'RWABE Insurance Company',0,0,0.00,1,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,NULL),(616,'Purity Mueni','Mother','0728568990','Embakasi ','KMEX503Y','Nyayo',1,'PBHIRCDQOX','30532920',50.00,'','Partial Payment',1,NULL,'','M-PESA','0798138700','','','',1,0,0,'',0,0,0.00,1,NULL),(617,'Dorris Arusa','Wife','0769088335','Nairobi West','KMDX929M','Kangemi',1,'PBHIRJA2JZ','Benjamin',50.00,'','Partial Payment',1,NULL,'','M-PESA','0718940700','','','',1,0,0,'',0,0,0.00,1,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,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,NULL),(620,'Nelson Baraza','Brother','0706311184','Pipeline','KMDL775U','South B',5,'PH4RP889W','Lazarus',50.00,'','Partial Payment',1,NULL,'','M-PESA','0705152804','','','',1,0,1,'Equity',0,0,0.00,1,NULL),(621,'Nyokafi','Girlfriend ','0700000000','Mukuru','KMEF212Q','South C',213,'PH6RJ4K5Q','Wilson',50.00,'','Partial Payment',1,NULL,'','M-PESA','0707218055','','','',1,0,1,'Monarch',0,0,0.00,0,NULL),(622,'Dominic Onchwari','Brother','0712673017','South B','KMEX625Q','South B',1,'PBH9RQZN6H','Kevin',50.00,'','Partial Payment',1,NULL,'','M-PESA','0758853779','','','',0,0,1,'Xplico Insurance Company ',0,1,0.00,1,NULL),(623,'Rachael ','Sister','0708930183','Rongai ','KMFD040S','South C',1,'PBH7RJOA5V','Samson',50.00,'','Partial Payment',1,NULL,'','M-PESA','0729619289','','','',1,0,1,'Sanlam Insurance  Co.',0,0,0.00,1,NULL),(624,'Peter Maina','Brother','0725960285','Karen','KMFA7237','Karen ',1,'PBG5OFKLMH','Jackson',50.00,'','Partial Payment',1,NULL,'','M-PESA','0726650652','','','',1,0,1,'Monarch Insurance Company',0,0,0.00,1,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,NULL),(626,'Calvin','Sister','0719300005','South C','KMFM591H','South C',1,'KMFM591H','Brighton',50.00,'','Partial Payment',1,NULL,'','M-PESA','0715890096','','','',1,0,1,'Xplico Insurance ',0,0,0.00,1,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,NULL),(628,'Agnes','Wife','0700423167','Karen ','KMEP754G','Karen',1,'PBQ63TMXJU','Charles',50.00,'','Partial Payment',1,NULL,'','M-PESA','0721405669','','','',1,0,1,'Trident Insurance Company ',0,0,0.00,1,NULL),(629,'Pauleen','Wife','0742684607','South B','KMER979R','South B',1,'PBH3RRTLCJ','Jones',100.00,'','Partial Payment',2,NULL,'','M-PESA','0724171629','','','',1,0,0,'',0,0,0.00,1,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,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,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,NULL),(633,'xx','xx','0700000000','Karen','KMDC917C','Karen Roundabout',1,'PBG4Q3WFK','Wycliffe',50.00,'','Partial Payment',1,NULL,'','M-PESA','0799881092','','','',1,0,1,'Trident Insurance Company',0,0,0.00,0,NULL),(634,'Maureen Omosa','Wife','0713940397','Umoja','PBHIRJA202','Nairobi West',1,'PHIRJA202','Samuel',50.00,'','Partial Payment',1,NULL,'','M-PESA','0722957603','','','',1,0,1,'Xplico Insurance Company',0,0,0.00,1,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,NULL),(636,'Felix','Brother','0727390363','Tassia','KMFJ657Q','South C',1,'PBH9RENDIF','James',50.00,'','Partial Payment',1,NULL,'','M-PESA','0706440736','','','',0,0,1,'GA Insurance Limited',0,0,0.00,1,NULL),(637,'Irene Akoth','Wife','0715485867','Jogoo Road','KMEL436L','Nairobi West',1,'PBH6RC4RKQ','Peter',50.00,'','Partial Payment',1,NULL,'','M-PESA','0721376785','','','',1,0,1,'Xplico Insurance  Company',0,0,0.00,1,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,NULL),(639,'John','Brother','0700000000','Kayole','KMEJ064Q','Langata',1,'PBH5RF8627','Wanjohi',50.00,'','Partial Payment',1,NULL,'','M-PESA','0723259917','','','',1,0,1,'Third Party',0,0,0.00,1,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,NULL),(641,'Edwin Njogu','xx','0723592790','Kahawa West','KMEH827P','Dagoretti Corner',1,'PBG7UJ82VI','Alex',50.00,'','Partial Payment',1,NULL,'','M-PESA','0722580153','','','',1,0,1,'AKI',0,0,0.00,1,NULL),(642,'Martha Mghambi','Wife','0795277578','Ngando','KMDV361M','Ngong Road',1,'PBGTQFJN1B','Thomas',50.00,'','Partial Payment',1,NULL,'','M-PESA','0721615198','','','',1,0,1,'Resolution',0,0,0.00,1,NULL),(643,'Weldon Sawe','brother','0727944121','Racecourse ','KMFM','Rescourse ',1,'PBG7QEQO6V','Sawe',50.00,'','Partial Payment',1,NULL,'','M-PESA','0718848340','','','',1,0,1,'Aki',1,0,132000.00,1,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,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,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,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,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,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,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,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,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,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,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,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,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,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,NULL),(659,'Duncan ','child','0742785907','Murera','KMEM431C','MURERA/KAREN',48,'PC45B8SFHI','Albert',50.00,'','Partial Payment',1,NULL,'','M-PESA','0714475894','','','',1,0,0,'',0,0,0.00,1,NULL),(660,'Mary Maina','Aunt','0710417492','Kenyatta Road ','KMFA510T','KENYATTA ROAD',6311,'PC42BBNTUS','EDWIN',50.00,'','Partial Payment',1,NULL,'','M-PESA','0700535713','','','',1,0,0,'',0,0,0.00,1,NULL),(661,'Tabitha ','mother','0713723944','Kenyatta Road ','KMEM773A','KENYATTA ROAD ',6308,'PC44BD453A','Stevo',50.00,'','Partial Payment',1,NULL,'','M-PESA','0725139209','','','',1,0,0,'',0,0,0.00,1,NULL),(662,'Rose Wangari ','wife','0743848349','Kenyatta Road ','KMEX535T','KENYATTA ROAD ',6301,'PC41BDFY5N','ALEX',50.00,'','Partial Payment',1,NULL,'','M-PESA','0725139209','','','',1,0,0,'',0,0,0.00,1,NULL),(663,'Andrew','Child','070000','Juja','KMDR226X','JUJA',2164,'PC88GCZLS6','PETER',50.00,'','Partial Payment',1,NULL,'','M-PESA','0710727393','','','',1,0,1,'MAKINDU',0,0,0.00,0,NULL),(664,'Abigail ','child ','070000','Juja','KMDV205L','JUJA',1,'PC83GCW7XD','Peter',50.00,'','Partial Payment',1,NULL,'','M-PESA','0724828240','','','',1,0,0,'',0,0,0.00,1,NULL),(665,'Geoffrey ','brother','070000','Juja','KMFG419E','JUJA',1,'PC88GANEKO','DUKE',50.00,'','Partial Payment',1,NULL,'','M-PESA','0723441324','','','',1,0,0,'',0,0,0.00,1,NULL),(666,'James Kiari','brother ','0710614846','Juja','KMET770P','JUJA',1,'PC61D5BGKX','NJUGUNA',50.00,'','Partial Payment',1,NULL,'','M-PESA','0791396038','','','',1,0,0,'',0,0,0.00,1,NULL),(667,'Risper','wife','0791354371','Murera','KMES574T','MURERA',41,'PC41B2C7YF','EVANS ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0720513900','','','',1,0,0,'',0,0,0.00,1,NULL),(668,'Catherine ','sister ','0721542966','Murera','KMEH766D','MURERA',11841,'PC40B2EB7K','KELVIN',50.00,'','Partial Payment',1,NULL,'','M-PESA','0759099255','','','',1,0,0,'',0,0,0.00,1,NULL),(669,'Nancy ','wife','0792751005','Murera','KMEY442U','MURERA ',11854,'PC41B2VVWL','DENNIS ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0791909173','','','',1,0,1,'SANLAM',1,0,4000.00,1,NULL),(670,'Nyangucha','father','0728092375','Murera','KMFG461E','MURERA ',70,'PC47B69XUN','DENNIS',50.00,'','Partial Payment',1,NULL,'','M-PESA','0792536523','','','',1,0,1,'SANLAM',1,0,30000.00,1,NULL),(671,'Shirley Nyameso','wife','0727480515','Mowlem','KMER886G','KOMAROCK',1,'PC67BUXBAF','PATRICK',50.00,'','Partial Payment',1,NULL,'','M-PESA','0701808026','','','',1,0,1,'MONARCH ',0,0,0.00,1,NULL),(672,'Rose Mbira','wife','0748290082','Limuru','KMFK998A','LIMURU ',1,'PC309U55IU','DOUGLAS',50.00,'','Partial Payment',1,NULL,'','M-PESA','0743567955','','','',1,0,1,'TRIDENT',0,0,0.00,1,NULL),(674,'Jemimah Bonariri','friend ','07450311','Limuru','KMEU484X','LIMURU',1,'PC31A2SZTH','SALIM ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0723281829','','','',1,0,0,'',0,0,0.00,1,NULL),(675,'Mary Wanja','daughter ','0725386017','Limuru','KMDK958N','LIMURU STAGE ',19,'PC339SY75P','ANTONY',50.00,'','Partial Payment',1,NULL,'','M-PESA','0729558696','','','',1,0,0,'',0,0,0.00,1,NULL),(676,'Mary Wanjiru','wife ','0710209370','Limuru','KMFD064T','LIMURU',1,'PC369S3NQW','GEORGE',50.00,'','Partial Payment',1,NULL,'','M-PESA','0745719114','','','',1,0,1,'MADISON',0,0,0.00,1,NULL),(677,'Anastasia Karange','wife','0794272595','Limuru','KMFJ074J','LIMURU ',1,'PC339XCCXT','KEVIN',50.00,'','Partial Payment',1,NULL,'','M-PESA','0794790342','','','',1,0,0,'',1,0,50000.00,1,NULL),(678,'Hannah Wanjiru','wife ','0706327357','Limuru','KMEQ012R','LIMURU ',1,'PC359X6Q7J','ERIC',50.00,'','Partial Payment',1,NULL,'','M-PESA','0790808180','','','',1,0,0,'',0,0,0.00,1,NULL),(679,'Yvonne Wambugu','wife','0717518762','Ruai','KMET699Q','RUAI',1,'PC55CHSNZP','GEORGE',50.00,'','Partial Payment',1,NULL,'','M-PESA','0724292750','','','',1,0,0,'',0,0,0.00,1,NULL),(680,'Samuel Gichuhi','brother','0717741666','Ruai','KMFH538H','RUAI ',1,'PC59CHZM2I','DAVID',50.00,'','Partial Payment',1,NULL,'','M-PESA','0796357107','','','',0,0,0,'',0,0,0.00,1,NULL),(681,'maureen wanjiku','sister','0729441493','Ruai','KMFG494Q','RUAI',1,'PC51CJRIFP','Kelvin',50.00,'','Partial Payment',1,NULL,'','M-PESA','0112716069','','','',1,0,1,'XPLICO',0,0,0.00,1,NULL),(682,'Hannah Njeri','wife','0790599038','Chokaa','KMEH510E','CHOKAA',1,'PC54CYO5E8','DANIEL',50.00,'','Partial Payment',1,NULL,'','M-PESA','0713107799','','','',0,0,0,'',0,0,0.00,1,NULL),(683,'Miriam Njoki','Daughter','0728948864','Ruai','KMDE794H','BYPASS/ RUAI',1,'PC57CUV7ZH','JOHN ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0728948864','','','',1,0,0,'',0,0,0.00,1,NULL),(684,'James Ndirangu','cousin','0714384398','Ruai Bypass','KMEB209B','RUAI/BYPASS ',1,'PC50CR7CN4','KHALID ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0791930965','','','',1,0,1,'TRIDENT',0,0,0.00,1,NULL),(685,'Paul ngugi','wife','0720539514','Ruai','KMFJ637D','RUAI BYPASS ',1,'PC54CT7XAI','Erastus',50.00,'','Partial Payment',1,NULL,'','M-PESA','0720539514','','','',1,0,1,'SANLAM',0,0,0.00,1,NULL),(686,'Kevin Muinde','Brother','0790392885','Ruai','KMFG778Z','RUAI',1,'PC58CL9786','CHARLES',50.00,'','Partial Payment',1,NULL,'','M-PESA','0796343345','','','',1,0,0,'',0,0,0.00,1,NULL),(687,'Duncan Wambugu','father ','0712348932','Umoja 3','KMEZ127U','UMOJA 3',1,'PC67E3J4T3','BILDAD',50.00,'','Partial Payment',1,NULL,'','M-PESA','0704244394','','','',0,0,0,'',0,0,0.00,1,NULL),(688,'Veronica Muthoni','wife','0780490875','UMOJA ','KMFF072E','Umoja 3',1,'PC66E37YZE','Bernard',50.00,'','Partial Payment',1,NULL,'','M-PESA','0726628591','','','',1,0,1,'MONARCH ',1,0,70000.00,1,NULL),(689,'Martin Mwangi','son','0725555313','umoja ','KMDW635G','UMOJA ',1,'PC68PC5VQG','KARIUKI',50.00,'','Partial Payment',1,NULL,'','M-PESA','0708902260','','','',1,0,1,'MADISON ',0,0,0.00,1,NULL),(690,'Ann Mugure ','wife','0728800957','Umoja','KMDR440G','UMOJA',1,'PC66E70HIG','GILBERT',50.00,'','Partial Payment',1,NULL,'','M-PESA','0797093789','','','',1,0,0,'',0,0,0.00,1,NULL),(691,'Josphat Babu','brother','0795415189','Komarock ','KMFD175T','KOMAROCK',1,'PC61E9ESJH','ELIKANA',50.00,'','Partial Payment',1,NULL,'','M-PESA','0707166921','','','',1,0,1,'SANLAM',0,0,0.00,1,NULL),(692,'Catherine Wambui','sister ','0113312912','Kayole Junction ','KMEX773D','KAYOLE JUNCTION ',1,'PC67EARWBX','JOSEPH',50.00,'','Partial Payment',1,NULL,'','M-PESA','0111333228','','','',1,0,1,'DIRECTLINE INSURANCE',0,0,0.00,1,NULL),(693,'Nancy Muthoni ','wife','0726130209','Komarock ','KMCS218W','MAMA LUCY/UMOJA ',1,'PC60EIUNOC','Simon',50.00,'','Partial Payment',1,NULL,'','M-PESA','0701230217','','','',1,0,1,'MONARCH ',0,0,0.00,1,NULL),(694,'xxxx','xxxxx','0700000','Pheroze','KMEW713L','PHEROZE ',1,'PC68DXOLO6','James',50.00,'','Partial Payment',1,NULL,'','M-PESA','072389017','','','',0,0,1,'MONARCH ',1,1,65000.00,1,NULL),(695,'Stephen Maina','son','0710328661','Ferooz','KMEA410E','KOMAROCK',1,'PC69DW9W58','Paul',50.00,'','Partial Payment',1,NULL,'','M-PESA','0718228996','','','',1,0,0,'',0,0,0.00,1,NULL),(696,'Esther Muteira','friend','0746368924','Juja','KMFM889V','JUJA',1,'PC51CPYP5H','ERICK',50.00,'','Partial Payment',1,NULL,'','M-PESA','0710922516','','','',1,0,0,'',0,0,0.00,1,NULL),(697,'xxxx','xxxx','070000000','Witeithie ','KMDX163M','WITEITHIE ',1,'PC53CPOZQI','SAMMY',50.00,'','Partial Payment',1,NULL,'','M-PESA','0700356779','','','',1,0,0,'',0,0,0.00,1,NULL),(698,'xxxxx','xxxxx','0700000','Kenyatta Road ','KMDV686E','KENYATTA ROAD ',1,'PC58CIQD68','Amos',50.00,'','Partial Payment',1,NULL,'','M-PESA','0717041405','','','',1,0,0,'',0,0,0.00,1,NULL),(699,'xxxxx','xxxxx','07000000','Juja ','KMFJ143A ','JUJA ',1,'PC59CNFTQT','Moses',50.00,'','Partial Payment',1,NULL,'','M-PESA','0715560061','','','',1,0,1,'GA INSURANCE ',0,0,0.00,1,NULL),(700,'xxxx','xxxx','07000000','Toll Kimbo','KMEQ552V','TOLL',1,'PC56C8H5VI','ZABERIO',50.00,'','Partial Payment',1,NULL,'','M-PESA','0798871702','','','',1,0,1,'HAKI',0,0,0.00,0,NULL),(701,'xxxx','xxxx','07000000','Kenyatta Road ','KMFD063Z','KENYATTA ROAD ',1,'PC54CAP4DU','PETER',50.00,'','Partial Payment',1,NULL,'','M-PESA','0796721520','','','',1,0,1,'AKI',0,0,0.00,1,NULL),(702,'xxxxx','xxxx','07000000','Kenyatta Road ','KMCV373P','KENYATTA ROAD ',1,'PC56CF9ER4','AMOS',50.00,'','Partial Payment',1,NULL,'','M-PESA','0728013863','','','',1,0,0,'',0,0,0.00,1,NULL),(703,'xxxxx','xxxxx','070000','Kenyatta Road ','KMFC917K','KENYATTA ROAD ',1,'PC51CBT789','WILSON ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0715391339','','','',0,0,1,'XPLICO',1,1,40000.00,1,NULL),(704,'xxxx','xxxx','070000','Kenyatta Road ','KMFC343W','KENYATTA ROAD ',1,'PC53CBJE75','JULIUS',50.00,'','Partial Payment',1,NULL,'','M-PESA','0700500870','','','',0,0,1,'TRIDENT',0,0,0.00,1,NULL),(705,'xxxxxx','xxxxx','07000000','Kenyatta Road ','KMEH001G','KENYATTA ROAD ',1,'PC55CC2YN9','BOAZ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0724549620','','','',1,0,0,'',0,0,0.00,1,NULL),(706,'xxxx','xxxxx','07000000','Kenyatta Road ','KMFB506W','KENYATTA ROAD ',1,'PC52CDOY65','JOHN',50.00,'','Partial Payment',1,NULL,'','M-PESA','0716066287','','','',1,0,0,'',0,0,0.00,1,NULL),(707,'Rosemary ','friend','0714913815','Kenyatta Road ','KMEW227Z','KENYATTA ROAD ',1,'PC53CEEMW9','JOSEPH ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0723066288','','','',1,0,0,'',1,0,30000.00,1,NULL),(708,'xxxxxx','xxxxxx','0700000','Kenyatta Road ','KMER571H','KENYATTA ROAD ',1,'PC51CH10BZ','PAUL',50.00,'','Partial Payment',1,NULL,'','M-PESA','0791520616','','','',1,0,0,'',1,0,30000.00,1,NULL),(709,'Redemtah','xxxxx','0707028180','Kenyatta Road ','KMFY057L','KENYATTA ROAD ',1,'PC52CH9160','Antony',50.00,'','Partial Payment',1,NULL,'','M-PESA','0727264464','','','',1,0,1,'SANLAM',0,0,0.00,1,NULL),(710,'Lilian Wanjiku ','xxxx','0701906625','Juja ','KMEX155M','JUJA',1,'PC59CM3BJ7','PAUL',50.00,'','Partial Payment',1,NULL,'','M-PESA','0728418745','','','',1,0,0,'',0,0,0.00,1,NULL),(711,'onesmus ','xxxxxxx','070000','Juja ','KMFL350G','JUJA',1,'PC53CYTDIJ','BENSON',50.00,'','Partial Payment',1,NULL,'','M-PESA','0758175867','','','',1,0,0,'',0,0,0.00,1,NULL),(712,'Peter Manga','xxxxx','070000','Juja ','KMEH209P','JUJA',1,'PC54CYXE4M','JAMES',50.00,'','Partial Payment',1,NULL,'','M-PESA','0717348919','','','',1,0,1,'AKI',0,0,0.00,1,NULL),(713,'Ellijoy Muthoni ','mother','0701193393','Juja','KMEP936L','JUJA',1,'PC59CYP8CD','Isaac',50.00,'','Partial Payment',1,NULL,'','M-PESA','0706298433','','','',0,0,0,'',0,0,0.00,1,NULL),(714,'Cynthia Nafuna','xxxx','0797455247','Kenyatta Road ','KMFB576E','KENYATTA ROAD ',1,'PC59D9CU4V','MOSES ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0799064154','','','',1,0,0,'',0,0,0.00,1,NULL),(715,'Wanjiru Margaret ','wife','0700498054','Kenyatta Road ','KMDQ551R','KENYATTA ROAD ',1,'PC63DGVORW','GEOFFREY',50.00,'','Partial Payment',1,NULL,'','M-PESA','0721265082','','','',1,0,0,'',0,0,0.00,1,NULL),(716,'xxxxxxx','xxxxxx','07000000','Kenyatta Road ','KMET606','KENYATTA ROAD ',1,'PC69DQ3PFR','DAVID',50.00,'','Partial Payment',1,NULL,'','M-PESA','0707967032','','','',0,0,0,'',0,0,0.00,1,NULL),(717,'xxxx','xxxxxx','070000','Juja','KMDJ278E','JUJA ',1,'PC58CQMJWQ','TIMOTHY',50.00,'','Partial Payment',1,NULL,'','M-PESA','0717399117','','','',1,0,0,'',0,0,0.00,1,NULL),(718,'Ndungu','Kamau','0700000','Westlands','KMCW026H','WESTLANDS ',1,'PC177DC8K7','KAMAU ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0721877063','','','',1,0,0,'',0,0,0.00,1,NULL),(719,'xxxxxxx','xxxxxxx','070000000','Westlands ','KMDM108V','WESTLANDS',1,'PC10710DC2','TITUS',50.00,'','Partial Payment',1,NULL,'','M-PESA','0723277808','','','',0,0,0,'',0,0,0.00,1,NULL),(720,'thom bosire','brother','0714005464','Kasarani ','KMFJ579U','SITIMA PLAZA',1,'PC1972J9AH','EDWARD ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0714173777','','','',0,0,1,'WATU',1,1,120000.00,1,NULL),(721,'xxxxxx','xxxxxx','070000000','Westlands','KMFF041T','WESTLANDS ',1,'PC1274KO20','SEBASTIAN',50.00,'','Partial Payment',1,NULL,'','M-PESA','0759012764','','','',1,0,0,'',1,0,50000.00,1,NULL),(722,'Winfred ','friend','072514972','Westlands','KMEL528U','WESTLANDS ',1,'PC1475VDLM','NICHOLAS ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0714974670','','','',0,1,0,'',0,0,0.00,1,NULL),(723,'Susan Wambui','wife ','0745150843','Westlands','KMET419Z','WESTLANDS ',1,'PC127B3UVK','JAMES',50.00,'','Partial Payment',1,NULL,'','M-PESA','0742352018','','','',1,0,0,'',0,0,0.00,1,NULL),(724,'George Oginga','brother ','0701969599','Westlands','KMDP371E','WESTLANDS ',1,'PC187EGPRE','JOHN',50.00,'','Partial Payment',1,NULL,'','M-PESA','0714464481','','','',1,0,1,'AKI',0,0,0.00,1,NULL),(725,'Mary Wambui','wife','0726153262','Westlands','KMDP292X','WESTLANDS ',1,'PC107AGO9Y','FRANCIS ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0722556480','','','',1,0,1,'MONARCH ',0,0,0.00,1,NULL),(726,'xxxxx','zxxxxx','0700000','Uthiru','KMDN907Q','UTHIRU',1,'PC58PA8L4C','KENNEDY',50.00,'','Partial Payment',1,NULL,'','M-PESA','0717597147','','','',1,0,0,'',0,0,0.00,1,NULL),(727,'Mary Njoki ','x','0717720017','Uthiru','KMFB486R','UTHIRU',1,'PC49BAJUI3','DUNCAN',50.00,'','Partial Payment',1,NULL,'','M-PESA','0742524748','','','',0,0,1,'AKI',0,0,0.00,1,NULL),(728,'Elizabeth Wanjiru ','xxxx','0700000','Uthiru','KMED211H','UTHIRU',1,'PC46B5034E','FRANCIS',50.00,'','Partial Payment',1,NULL,'','M-PESA','0721782616','','','',1,0,1,'MONARCH',0,0,0.00,1,NULL),(729,'Valentine Kerubo','x','0722529251','Uthiru','KMDR148B','UTHIRU ',1,'PC42B6M726','MANANI',50.00,'','Partial Payment',1,NULL,'','M-PESA','0724451622','','','',1,0,1,'XPLICO',0,0,0.00,1,NULL),(730,'Doreen Nyanchoka','wife','070000','Uthiru','KMEG212D','UTHIRU',1,'PC45B4R60H','ALEX',50.00,'','Partial Payment',1,NULL,'','M-PESA','0727143106','','','',1,0,1,'XPLICO',0,0,0.00,1,NULL),(731,'cxxxx','xxxxxxxx','0700000','Uthiru','KMDZ454V','UTHIRU ',1,'PC42B3M7JU','ISAAC',50.00,'','Partial Payment',1,NULL,'','M-PESA','0707310463','','','',1,0,1,'XPLICO ',0,0,0.00,1,NULL),(732,'Joseph Gachogo','x','0700000','Uthiru','KMEB634L','UTHIRU ',1,'PC47BBAFEL','GEOFFREY ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0720937592','','','',0,0,0,'',0,0,0.00,0,NULL),(733,'veronica mutua','wife','0796353991','Uthiru','KMCY189Y','UTHIRU',1,'PC54DA5N8U','ANTONY',50.00,'','Partial Payment',1,NULL,'','M-PESA','0717111852','','','',1,0,1,'AKI',0,0,0.00,1,NULL),(734,'xxxxxxx','xxxxxx','07000000','Limuru','LMEL653K','LIMURU ',1,'PC30AAVDE2','DAVID',50.00,'','Partial Payment',1,NULL,'','M-PESA','0704150094','','','',1,0,0,'',0,0,0.00,1,NULL),(735,'Jane Murekia','xxxxxx','0700000','Limuru','KMED126N','LIMURU',1,'PC38A65MBO','STANLEY',50.00,'','Partial Payment',1,NULL,'','M-PESA','0715397044','','','',0,1,0,'',0,0,0.00,1,NULL),(737,'mwihaki','mother','0722443972','Limuru','KMFL819J','LIMURU',1,'PC39A8NNPF','EUGENE ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0748708438','','','',1,0,1,'ELIDA',0,0,0.00,1,NULL),(738,'xxxxx','xxxxxx','070000','Limuru','KMEA944U','LIMURU',1,'PC36907CG8','ERICK ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0705894276','','','',1,0,0,'',0,0,0.00,1,NULL),(739,'rose nafuna','xxx','07000','Limuru','KMFA541S','LIMURU',1,'PC329W4JTY','ZAKAYO',50.00,'','Partial Payment',1,NULL,'','M-PESA','0742118085','','','',1,0,0,'',0,0,0.00,1,NULL),(740,'xxxx','xxxx','070000','Limuru','KMCW991J','LIMURU ',1,'PC339WQXVR','ENOCK',50.00,'','Partial Payment',1,NULL,'','M-PESA','0793813461','','','',0,0,0,'',0,0,0.00,1,NULL),(741,'xxxxx','xxxxxx','0700000','Limuru','KMDR972B','LIMURU ',1,'PC31920EAN','DANIEL',50.00,'','Partial Payment',1,NULL,'','M-PESA','0704415667','','','',1,0,0,'',0,0,0.00,1,NULL),(742,'rahab Nyambura ','x','0790651078','Limuru','KMDT801B','LIMURU ',1,'PC359ZAAZJ','PETER',50.00,'','Partial Payment',1,NULL,'','M-PESA','0703916173','','','',1,0,0,'',0,0,0.00,1,NULL),(743,'xxxxxx','xxxxxx','07000000','Limuru','KMDB965V','LIMURU ',1,'PC37A09YUJ','FRANCIS',50.00,'','Partial Payment',1,NULL,'','M-PESA','0718380901','','','',1,0,0,'',0,0,0.00,1,NULL),(744,'Christine Ikata','x','0790818909','Westlands','KMDV260Y','WESTLANDS ',1,'PC2781BDSJ','NICKSON',50.00,'','Partial Payment',1,NULL,'','M-PESA','0723536956','','','',1,0,1,'MONARCH',0,0,0.00,1,NULL),(745,'Gian','x','070000','Kabete','KMEV149P','KABETE',1,'PC268LAIPO','VICTOR ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0700539110','','','',1,0,0,'',0,0,0.00,1,NULL),(746,'Zipora Kimunto','x','0722301485','Kabete','KMES917Y','KABETE',1,'PC248H2G60','SILAH',50.00,'','Partial Payment',1,NULL,'','M-PESA','0799765008','','','',0,0,0,'',0,0,0.00,1,NULL),(747,'Catherine ','x','070000','Kabete','KMEV751S','KABETE',1,'PC288GOLSG','EVANS',50.00,'','Partial Payment',1,NULL,'','M-PESA','0769876241','','','',0,0,1,'TRIDENT',0,0,0.00,1,NULL),(748,'Josphene Mogoi','x','0718193345','Kabete','KMFE578X','KABETE',1,'PC258PFMGT','DENNIS',50.00,'','Partial Payment',1,NULL,'','M-PESA','0721892996','','','',1,0,1,'SANLAM',0,0,0.00,1,NULL),(749,'xxxxx','xxxxx','070000','Kabete','KMFH.......','KABETE',1,'PC218LWGMH','ERICK',50.00,'','Partial Payment',1,NULL,'','M-PESA','0707379762','','','',1,0,0,'',0,0,0.00,1,NULL),(750,'Sharon ','wife','0790738217','Marurui','KMED089M','MARURUI ',1,'PBM0XMB31K','HEZEKIA',50.00,'','Partial Payment',1,NULL,'','M-PESA','0796375707','','','',0,0,1,'MONARCH',0,0,0.00,1,NULL),(751,'Kariuki ','father ','0701900554','Marurui','KMEY706K','Marurui',1,'PBM8XMOHXE','ALEXANDER',50.00,'','Partial Payment',1,NULL,'','M-PESA','0713545532','','','',1,0,1,'MONARCH',0,0,0.00,1,NULL),(752,'Evanson ','brother','0713097972','Marurui','KMEW730R','MARURUI ',1,'PBM6XNAHE4','MARTIN ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0729961761','','','',0,0,0,'',0,0,0.00,1,NULL),(753,'ngugi ','brother','0707023585','Marurui','KMDC715C','MARURUI ',1,'PBM1XNOF3N','NJOROGE ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0795501223','','','',1,0,0,'',0,0,0.00,1,NULL),(754,'Emmanuel ','child','0706508382','Marurui','KMFE637H','MARURUI ',1,'PBM3XOI76R','JOSEPH ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0797499632','','','',0,0,1,'SANLAM GENERAL ',0,0,0.00,1,NULL),(755,'Alex ','child ','070000','Marurui ','KMFL750H','MARURUI ',1,'PBM3XOR4DH','baraza',50.00,'','Partial Payment',1,NULL,'','M-PESA','0707988269','','','',1,0,0,'',0,0,0.00,1,NULL),(756,'Mary Wangui','wife','0705734501','MARURUI ','KMCX564S','MARURUI ',1,'PBM8XQ59TG','MATTHEW ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0711910026','','','',1,0,0,'',0,0,0.00,1,NULL),(757,'John Nganga ','father','0720509411','Gitaru','KMFG116G','GITARU',1,'PC40AYM2NY','SAMUEL',100.00,'','Partial Payment',2,NULL,'','M-PESA','0795177659','','','',1,0,1,'SANLAM GENERAL ',0,0,0.00,1,NULL),(758,'Ceira','child','07000','Allsopps','KMEG385P','ALLSOPS',1,'PC84GDKICW','George ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0727570135','','','',1,0,1,'MONARCH ',0,0,0.00,1,NULL),(759,'xxxx','xxxxx','07000','Limuru','KMED093R','LIMURU',1,'PC309TWF6E','Isaiah',50.00,'','Partial Payment',1,NULL,'','M-PESA','0702930745','','','',1,0,0,'',0,0,0.00,1,NULL),(760,'milicent Nafuna ','sister','0737335596','Racecourse','KMFR 010W','KIBERA ',1,'PBK1VCLREI','Emmanuel ',50.00,'','Partial Payment',1,NULL,'','M-PESA','0111703827','','','',1,0,1,'GA INSURANCE ',1,0,175000.00,1,NULL),(765,'Miriam Juma','Wife','0743639453','Umoja','KMFH557E','Umoja',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0722783708','','','',1,0,0,'',0,0,0.00,1,NULL),(766,'Virginia Njeri Mwangi','Wife','0725126597','Githurai','KMFK915F','Marikiti',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0703777800','','','',0,0,1,'Sanlam General Insurance',1,1,90000.00,1,NULL),(767,'Peninah Njomo','Wife','0792789468','Zimmerman','KMDJ237F','Country Bus',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0729521256','','','',1,0,0,'',0,0,0.00,1,NULL),(768,'Brian Ngoci ','Brother','0782683706','Kiambu','KMDM829C','TWIGA MART, KIAMBU',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0746659145','','','',1,0,1,'MONARCH',0,0,0.00,1,NULL),(769,'Virginia Ndinda ','spouse','0746265818','Lunga Lunga ','KMDU799Y','EASTLEIGH ',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0727451250','','','',1,0,1,'XPLICO INSURANCE',0,0,0.00,1,NULL),(770,'Teresia Njeri','Spouse','0711245361','Githurai 44','KMCR702I','GITHURAI 44',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0719383307','','','',1,0,0,'',0,0,0.00,0,NULL),(771,'James Kuria ','son','0797726911','Kayole','KMEZ610E','EASTLEIGH ',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0728482583','','','',1,0,1,'MONARCH',0,0,0.00,1,NULL),(772,'Joseph Muriuki ','Brother ','0720427994','umoja ','KMDZ620E','EASTLEIGH ',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0728435313','','','',1,0,1,'MONARCH',0,0,0.00,1,NULL),(773,'xxxxx','xxxxx','0700000','Limuru','KMES','LIMURU ',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0723236015','','','',0,1,0,'',0,0,0.00,1,NULL),(774,'Virginia ','wife','0713071383','Murera ','KMFA551U','MURERA',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0723777299','','','',1,0,0,'',0,0,0.00,1,NULL),(775,'bilha kinyanga','wife ','0716060274','Kenyatta Road ','KMFJ925A','Kenyatta Road ',915,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0727575935','','','',1,0,1,'SANLAM INSURANCE ',1,0,60000.00,1,NULL),(776,'Daniel Karimi ','x ','0707382395','Kabete ','KMEQ739S','KABETE',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0791035400','','','',1,0,1,'KAPTAIN',0,0,0.00,1,NULL),(777,'Abigael Wangui','Spouse','0725491279','GITHURAI ','KMFM493B','KAHAWA',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0702835327','','','',1,0,1,'SANLAM GENERAL INSURANCE ',0,0,0.00,1,NULL),(778,'Lydia Njeri ','x','0734766393','LIMURU ','KMEF596R','LIMURU',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0724158676','','','',1,0,0,'',0,0,0.00,1,NULL),(779,'Benjamin','father ','0125775631','Lenana','KMFH440A','MUTEGO',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0743325144','','','',0,1,1,'AKI ',0,0,0.00,0,NULL),(780,'Lilian Nabifo','X ','0723877379','Rongai ','KMES887X','KAREN',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0723377379','','','',1,0,0,'',0,0,0.00,1,NULL),(781,'Kegan Male','Son','07000','Kibera','KMED251Y','KIBERA',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0712528012','','','',1,0,1,'AKI INSURANCE ',0,0,0.00,1,NULL),(782,'xxxx','xxxxx','070000','Westlands','KMEZ021N','WESTLANDS ',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0723775788','','','',1,0,0,'',0,0,0.00,1,NULL),(783,'Mercy Mutongoi','x','0759136904','Westlands ','KMEW158W','Westlands',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0758594667','','','',1,0,0,'',0,0,0.00,1,NULL),(784,'xxxxx','xxxxx','0700','Kangemi ','KMEL034Y','KANGEMI',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0741695566','','','',0,1,0,'',0,0,0.00,1,NULL),(785,'xxxxx','xxxxx','07000','UTHIRU ','KMDD515F','UTHIRU',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0726794790','','','',1,0,0,'',0,0,0.00,1,NULL),(786,'xxxx','zxxx','070000','Kabete','KMDX978H','KABETE',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0742811261','','','',0,1,1,'XPLICO INSURANCE ',0,0,0.00,1,NULL),(787,'Joice Wambui','x','0799054312','Kimbo','KMEH884E','KIMBO ',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0714427638','','','',1,0,0,'',0,0,0.00,1,NULL),(788,'Caroline Wanja','Wife','0791562954','87 Junction','KMFC195C','Kangemi ',4,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0797388733','','','',1,0,1,'SANLAM INSURANCE',1,0,20000.00,1,NULL),(789,'Duncan Kinge','Brother','0718728566','Kangemi ','KMFM982G','KANGEMI ',7,'','',100.00,'','Partial Payment',2,NULL,'','M-PESA','0111775569','','','',0,1,1,'SANLAM',1,0,171000.00,1,NULL),(790,'stephen thuo','brother','0724880589','Kiganjo ','KMEE896E','POSTA MAKONGENI',17,'','',100.00,'','Partial Payment',2,NULL,'','M-PESA','0708397686','','','',1,0,0,'',0,0,0.00,1,NULL),(791,'Mary Wanjiru ','mum','0708668480','Muguga','KMED567S','MAKONGENI POSTA',5,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0712892808','','','',1,0,0,'',0,0,0.00,1,NULL),(801,'Hellen Mwangi','mother','0713444614','Gachororo','KMDS685Z','Juja, HighPoint',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0706516684','','','',0,1,0,'',0,0,0.00,1,NULL),(802,'Timothy Mwangi','son','0724862532','Murera','KMES793A','Boggie',122,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0721331611','','','',1,0,1,'Xplico',0,0,0.00,1,NULL),(803,'Naomi Mogeni','Wife','0798826415','Kawangware','KMEQ028H','Kawangware',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0745271364','','','',1,0,0,'',0,0,0.00,1,NULL),(804,'Leah Njambi','Spouse','0717839507','Riabai','KMDL460A','Kirigiti',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0712086883','','','',1,0,0,'',0,0,0.00,1,NULL),(805,'Stephen Mumina','Brother','0701526539','Kayole','KMEF','Kayole',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0728406597','','','',0,0,1,'APA Insurance',1,1,45000.00,1,NULL),(806,'xxxxx','xxxxxx','0700000','Wangige','KMDQ480V','Wangige',3,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0723434186','','','',1,0,1,'Monarch',0,0,0.00,1,NULL),(807,'Julius','x','0721419918','Langata','KMEP518C','Langata',1,'','',100.00,'','Partial Payment',2,NULL,'','M-PESA','0721419918','','','',1,0,0,'',0,0,0.00,1,NULL),(808,'xxxxx','xxxx','070000000','Industrial Area','KMEG028M','Industrial Area',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0713864174','','','',1,0,0,'',0,0,0.00,0,NULL),(809,'Mary Wanjiku','Sister','0720494809','Wataalam','KMDM635U','Posta Makongeni',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0736968227','','','',1,0,0,'',0,0,0.00,1,NULL),(810,'Christiano','son','070000','Baba Dogo','KMFM494V','Githurai',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0729492906','','','',1,0,1,'Equity',0,0,0.00,1,NULL),(811,'Steve','Friend','0700364743','Transformal','KMFF170F','Transformal',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0769970302','','','',1,0,1,'monarch',0,0,0.00,1,NULL),(812,'Esther Njeri','wife','0710536935','Kahawa','KMFF262J','Kahawa Wendani',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0707818011','','','',1,0,0,'',0,0,0.00,1,NULL),(813,'Edwin Amakuyi','brother','0748207536','Phase 4','KMDY598D','Makongeni, Posta',3,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0703141048','','','',1,0,0,'',0,0,0.00,1,NULL),(814,'James Wangaru','dad','0719437829','Kiganjo','KMFK517N','Makongeni, Posta',29,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0740417648','','','',1,0,1,'Sanlam',1,0,100000.00,1,NULL),(815,'Veronica Khavai','wife','0791821685','Gitambaya','KMCW551T','Ruiru, Masaku',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0720105125','','','',1,0,1,'Monarch',0,0,0.00,1,NULL),(816,'Victor Langata','brother','0724970688','....','KMEC044P','......',1,'','',500.00,'','One Off Payment- Ksh 500.',1,NULL,'','M-PESA','0729986890','','','',1,0,1,'Xplico',0,0,0.00,1,NULL),(817,'Gloria Thab','Wife','0728067120','Langata','KMEY391A','Langata',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0711387864','','','',1,0,1,'Sanlam',0,0,0.00,1,NULL),(818,'Gladys Langat','mother','0718801065','Rongai','KMEV489U','Langata Road',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0701991279','','','',0,1,0,'',0,0,0.00,1,NULL),(819,'Esther Kathambi','wife','0759790572','Ngeno','KMEA345H','Langata',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0716200075','','','',1,0,1,'Britam',0,0,0.00,1,NULL),(820,'Salome','Mother','0727576477','Waithaka','KMEI515V','Lenana',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0706108135','','','',1,0,1,'Sanlam General',1,0,125000.00,1,NULL),(821,'Samuel Njenga','father','0791172003','Kikuyu','KMEV194D','Kikuyu',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0791897525','','','',1,0,0,'',0,0,0.00,1,NULL),(822,'xxxxx','zxxxxx','0700000','Kenyatta Road','KMER963S','Kenyatta Road',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0799561117','','','',0,1,0,'',0,0,0.00,1,NULL),(823,'Patrick','Friend','0727382167','Biashara, Ruiru','KMCC569L','Full Gospel Stage',1106,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0723240189','','','',1,0,0,'',0,0,0.00,1,NULL),(824,'Elizabeth Nyambura','mother','0705622538','Umoja 3','KMER089N','Eastleigh 8th Street',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0715714399','','','',1,0,1,'Monarch',0,0,0.00,1,NULL),(825,'Jane Kaluhi','wife','0712233938','Mlolongo','KMFJ583K','Commercial Accra',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0724036790','','','',1,0,1,'Sanlam',0,0,0.00,1,NULL),(826,'Margaret','wife','0723569983','Ruiru','KMEY887D','Ruiru, Rainbow',102,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0715474354','','','',1,0,1,'Monarch',0,0,0.00,1,NULL),(827,'Gathirimu','father','0724486206','Ruiru, Rainbow','KMEW722V','Ruiru, Rainbow',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0720202585','','','',1,0,0,'',0,0,0.00,1,NULL),(828,'nduta','mom','0718376964','Ruiru','KMFC620M','Makongeni, Posta',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0705797959','','','',1,0,0,'',0,0,0.00,1,NULL),(829,'James Mwangi','Brother','0725424452','Umoja','KMFA077T','Eastleigh/ Garissa Road',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0746586193','','','',1,0,1,'Monarch',0,0,0.00,1,NULL),(830,'Lucy Muli','Wife','0746517853',NULL,'KMEK081A','.....',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0720201868','','','',1,0,1,'Xplico',0,0,NULL,NULL,NULL),(856,'Francis Kuria','Brother','0711126249','Juja','KMEL522T','Juja KCB',15008,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0725036356','','','',1,0,0,'',0,0,0.00,1,NULL),(857,'xxxxx','xxxxx','070000','Juja','KMFW833F','Kenyatta Road',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0729865740','','','',1,0,0,'',0,0,0.00,1,NULL),(858,'MaryAnnne Wavinye','wife ','0704877012','Kiganjo ','KMDV383G','Makongeni, Posta',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0707180932','','','',1,0,0,'',0,0,0.00,1,NULL),(859,'Jane Waithera','wife','070000','Kariobangi','KMEJ953H','Rounda',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0725313984','','','',1,0,1,'BAK',0,0,0.00,1,NULL),(860,'Ivy Wambui ','friend','0706813201','Mwiki','KMEX081Y','GITHURAI 44',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0700885005','','','',1,0,0,'',0,0,0.00,1,NULL),(861,'Eunice Njambi','wife','0722904841','Wangige','KMFH835H','WANGIGE',173,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0727120433','','','',0,1,1,'TRIDENT INSURANCE',0,0,0.00,1,NULL),(862,'Mary Wambui','Wife','0711729604','Murera','KMFN555A','Gwa Kairu, Reli',2999,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0741034137','','','',1,0,0,'',0,0,0.00,1,NULL),(863,'Wangechi Kamau','Mother','0721226328','Githurai','KMFE416W','Githurai',1,'','',50.00,'','Partial Payment',1,NULL,'','M-PESA','0714267468','','','',1,0,1,'PSV',0,0,0.00,1,NULL);

--
-- Table structure for table `bodapayments`
--

CREATE TABLE `bodapayments` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `orderId` int(20) DEFAULT NULL,
  `customerToPccCost` decimal(15,2) NOT NULL DEFAULT '0.00',
  `DccToRecipientCost` decimal(15,2) NOT NULL DEFAULT '0.00',
  `alongRouteBodaAgentsCosts` decimal(15,2) DEFAULT '0.00',
  `dateCreated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=119 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bodapayments`
--

INSERT INTO `bodapayments` VALUES (1,0,71.49,47.66,35.07,'2021-04-17 07:50:30'),(2,0,71.49,47.66,35.07,'2021-04-17 07:50:48'),(3,1,74.30,49.54,35.07,'2021-04-17 10:16:50'),(4,2,75.46,50.30,35.07,'2021-04-17 10:23:39'),(5,3,69.86,46.57,35.07,'2021-04-17 10:26:17'),(6,4,69.94,46.62,35.07,'2021-04-17 13:03:21'),(7,5,63.64,42.43,35.07,'2021-04-17 13:57:17'),(8,6,58.32,38.88,35.07,'2021-04-17 13:57:50'),(9,8,63.42,42.28,35.07,'2021-04-17 13:58:46'),(10,0,183.75,122.50,35.14,'2021-04-17 16:06:01'),(11,9,183.75,122.50,35.14,'2021-04-17 16:06:03'),(12,10,133.50,89.00,35.14,'2021-04-17 16:08:47'),(13,11,149.85,99.90,35.14,'2021-04-17 16:10:02'),(14,12,149.85,99.90,35.14,'2021-04-17 16:12:06'),(15,0,224.89,149.93,35.14,'2021-04-17 16:12:11'),(16,0,74.92,49.95,35.07,'2021-04-17 16:33:52'),(17,0,58.56,39.04,35.07,'2021-04-17 16:35:01'),(18,0,66.04,44.02,35.07,'2021-04-17 16:35:05'),(19,0,58.56,39.04,35.07,'2021-04-17 16:35:36'),(20,0,68.55,45.70,35.07,'2021-04-17 16:35:59'),(21,0,65.61,43.74,35.07,'2021-04-17 18:14:53'),(22,0,71.88,47.92,35.08,'2021-04-17 18:43:03'),(23,0,80.95,53.97,35.08,'2021-04-17 18:43:36'),(24,20,73.14,48.76,35.08,'2021-04-17 18:44:51'),(25,0,73.14,48.76,35.08,'2021-04-17 19:17:00'),(26,0,136.38,90.92,35.15,'2021-04-18 06:53:17'),(27,0,136.38,90.92,35.15,'2021-04-18 06:58:33'),(28,0,136.38,90.92,35.15,'2021-04-18 06:59:24'),(29,0,136.38,90.92,35.15,'2021-04-19 18:50:08'),(30,0,136.38,90.92,35.15,'2021-04-19 18:51:37'),(31,0,136.38,90.92,35.15,'2021-04-19 19:07:49'),(32,0,136.38,90.92,35.15,'2021-04-19 19:10:22'),(33,0,92.91,61.94,35.08,'2021-04-20 08:23:23'),(34,0,78.39,52.26,35.08,'2021-04-20 08:24:58'),(35,0,122.44,81.63,35.08,'2021-04-20 09:31:07'),(36,0,69.00,46.00,35.08,'2021-04-20 09:34:08'),(37,21,71.23,47.49,35.08,'2021-04-20 09:36:32'),(38,22,105.41,70.27,35.08,'2021-04-20 09:39:37'),(39,0,107.31,71.54,35.08,'2021-04-20 09:45:35'),(40,0,168.18,112.12,35.08,'2021-04-20 09:45:42'),(41,0,214.61,143.07,35.15,'2021-04-20 09:46:50'),(42,0,304.14,202.76,35.31,'2021-04-20 09:47:23'),(43,0,547.64,365.09,35.31,'2021-04-20 09:47:31'),(44,0,429.22,286.15,35.31,'2021-04-20 09:49:16'),(45,0,82.31,54.87,35.08,'2021-04-20 10:09:43'),(46,0,88.37,58.91,35.08,'2021-04-20 10:10:49'),(47,23,68.70,45.80,35.08,'2021-04-20 10:12:33'),(48,24,69.52,46.35,35.08,'2021-04-20 10:22:25'),(49,0,107.69,71.79,35.08,'2021-04-20 10:26:45'),(50,0,107.69,71.79,35.08,'2021-04-20 10:26:53'),(51,0,75.88,50.59,35.08,'2021-04-20 15:07:27'),(52,0,125.78,83.85,35.08,'2021-04-20 15:40:45'),(53,0,125.72,83.82,35.08,'2021-04-20 15:41:24'),(54,0,76.54,51.03,35.08,'2021-04-20 15:44:15'),(55,0,82.65,55.10,35.08,'2021-04-20 15:48:22'),(56,0,82.65,55.10,35.08,'2021-04-20 15:53:55'),(57,0,247.87,165.25,35.23,'2021-04-20 15:55:19'),(58,0,247.87,165.25,35.23,'2021-04-20 15:55:29'),(59,0,82.65,55.10,35.08,'2021-04-20 15:55:35'),(60,0,247.87,165.25,35.23,'2021-04-20 15:56:11'),(61,0,71.85,47.90,35.08,'2021-04-20 17:24:17'),(62,0,73.09,48.72,35.08,'2021-04-20 17:25:14'),(63,0,73.09,48.72,35.08,'2021-04-20 17:46:50'),(64,0,73.09,48.72,35.08,'2021-04-20 17:49:20'),(65,0,73.09,48.72,35.08,'2021-04-20 17:50:10'),(66,0,73.09,48.72,35.08,'2021-04-20 17:50:20'),(67,0,73.09,48.72,35.08,'2021-04-20 17:53:05'),(68,0,73.09,48.72,35.08,'2021-04-20 17:56:20'),(69,0,73.09,48.72,35.08,'2021-04-20 17:56:36'),(70,0,94.52,63.01,35.08,'2021-04-20 18:00:20'),(71,0,94.52,63.01,35.08,'2021-04-20 18:00:56'),(72,0,94.52,63.01,35.08,'2021-04-20 18:02:50'),(73,0,94.52,63.01,35.08,'2021-04-20 18:03:29'),(74,0,94.52,63.01,35.08,'2021-04-20 18:11:02'),(75,0,67.29,44.86,35.08,'2021-04-20 18:12:09'),(76,0,67.29,44.86,35.08,'2021-04-20 18:14:34'),(77,0,67.29,44.86,35.08,'2021-04-20 18:14:45'),(78,0,67.29,44.86,35.08,'2021-04-20 18:15:14'),(79,0,94.52,63.01,35.08,'2021-04-20 18:22:08'),(80,0,94.52,63.01,35.08,'2021-04-20 18:23:09'),(81,0,94.52,63.01,35.08,'2021-04-20 18:23:23'),(82,0,94.52,63.01,35.08,'2021-04-20 18:26:08'),(83,0,96.32,64.21,35.08,'2021-04-20 18:31:08'),(84,0,94.52,63.01,35.08,'2021-04-20 18:32:29'),(85,0,94.52,63.01,35.08,'2021-04-20 18:35:51'),(86,0,94.52,63.01,35.08,'2021-04-20 18:39:14'),(87,0,94.52,63.01,35.08,'2021-04-20 18:39:53'),(88,0,94.52,63.01,35.08,'2021-04-20 18:40:30'),(89,0,94.52,63.01,35.08,'2021-04-20 18:41:51'),(90,0,94.52,63.01,35.08,'2021-04-20 18:42:56'),(91,0,94.52,63.01,35.08,'2021-04-20 18:45:49'),(92,0,94.52,63.01,35.08,'2021-04-20 18:47:21'),(93,0,94.52,63.01,35.08,'2021-04-20 18:48:04'),(94,0,94.52,63.01,35.08,'2021-04-20 18:48:40'),(95,0,148.97,99.31,35.08,'2021-04-20 18:51:57'),(96,0,148.97,99.31,35.08,'2021-04-20 18:51:57'),(97,0,94.52,63.01,35.08,'2021-04-20 18:53:54'),(98,0,94.52,63.01,35.08,'2021-04-20 18:55:33'),(99,0,94.52,63.01,35.08,'2021-04-20 18:57:55'),(100,0,94.52,63.01,35.08,'2021-04-20 18:59:50'),(101,0,94.52,63.01,35.08,'2021-04-20 19:00:54'),(102,0,75.07,50.05,35.08,'2021-04-21 06:26:39'),(103,0,75.07,50.05,35.08,'2021-04-21 06:33:12'),(104,0,105.74,70.49,35.08,'2021-04-21 06:36:36'),(105,0,105.74,70.49,35.08,'2021-04-21 06:36:36'),(106,0,75.07,50.05,35.08,'2021-04-21 06:38:41'),(107,0,75.07,50.05,35.08,'2021-04-21 06:41:55'),(108,0,75.07,50.05,35.08,'2021-04-21 06:47:43'),(109,0,75.07,50.05,35.08,'2021-04-21 06:49:35'),(110,0,77.35,51.57,35.01,'2021-04-21 06:58:02'),(111,0,77.35,51.57,35.01,'2021-04-21 07:09:48'),(112,0,77.35,51.57,35.01,'2021-04-21 07:11:30'),(113,25,77.35,51.57,35.02,'2021-04-21 07:15:51'),(114,0,72.69,48.46,35.02,'2021-04-21 09:21:24'),(115,0,77.35,51.57,35.02,'2021-04-21 09:22:14'),(116,26,77.35,51.57,35.02,'2021-04-21 09:22:34'),(117,0,70.80,47.20,35.04,'2021-04-21 09:43:21'),(118,0,141.60,94.40,35.08,'2021-04-21 09:44:43');

--
-- Table structure for table `bodapaymentsAllocations`
--

CREATE TABLE `bodapaymentsAllocations` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `orderId` int(20) DEFAULT NULL,
  `customerToPccCostStaffID` int(20) NOT NULL DEFAULT '0',
  `customerToPccCostConfirmed` int(2) NOT NULL DEFAULT '0',
  `DccToRecipientCostStaffID` int(20) NOT NULL DEFAULT '0',
  `DccToRecipientCostConfirmed` int(2) NOT NULL DEFAULT '0',
  `alongRouteBodaAgentsCostsStaffID` text,
  `alongRouteBodaAgentsCostConfirmed` text,
  `dateCreated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bodapaymentsAllocations`
--

INSERT INTO `bodapaymentsAllocations` VALUES (7,5,58,0,0,0,NULL,NULL,'2021-04-21 17:05:24');

--
-- 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=98 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `collection_centers` VALUES (13,-1.090953,37.024434,'Miketech electronics','2021-02-24 20:13:11',274,1),(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,1),(19,-1.265160,36.984949,'Hinga Stores','2021-02-26 09:01:55',284,1),(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,1),(24,-1.278366,36.908422,'Super Five Shop','2021-02-26 14:41:33',289,1),(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,1),(29,-1.300713,36.889234,'Port Florence Ventures','2021-02-27 10:18:54',294,1),(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,2),(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,1),(48,-1.168106,36.826035,'Kinyozi Maalum','2021-03-06 13:31:42',478,2),(50,-1.124259,37.002455,'MKY MoviesAt: Kenyatta Road Stage, Juja, , Kenya','2021-04-07 14:09:42',799,2),(51,-1.358651,36.747071,'Veez Fast Food At: Langata South Road, Nairobi, , Kenya','2021-04-07 14:14:32',800,1),(52,-1.358863,36.746768,'Zacafric Computer SystemsAt: Langata South Road, Nairobi, , Kenya','2021-04-08 09:04:09',831,1),(53,-1.310400,36.833802,'Airfiber Internet CafeAt: Mass, Nairobi, , Kenya','2021-04-08 09:18:09',832,1),(54,-1.358220,36.747138,'Uchad TechnologiesAt: Nairobi, Nairobi, , KenyaAt: St Lukes Methodist, Nairobi, , KenyaAt: Langata South Road, Nairobi, , Kenya','2021-04-08 09:23:37',833,1),(55,-1.319591,36.822945,'Loretto Dry CleanersAt: 10, Nairobi, , Kenya','2021-04-08 09:27:39',834,1),(56,-1.308099,36.781697,'AbeingoAt: Kwa DC, Nairobi, , KenyaAt: Kibera Drive, Nairobi, , Kenya','2021-04-08 09:37:50',835,1),(57,-1.271343,36.743412,'Elim BarbersAt: Unnamed Road, Nairobi, , KenyaAt: Manga Road, Nairobi, , KenyaAt: Unnamed Road, Nairobi, , KenyaAt: Manga Road, Nairobi, , Kenya','2021-04-08 09:43:45',836,1),(58,-1.140475,36.660490,'Out PostAt: Kenya, , , KenyaAt: The Limtea Place, , , KenyaAt: The Limtea Place, , , KenyaAt: Limuru Road, , , Kenya','2021-04-08 09:50:29',837,1),(59,-1.243897,36.880732,'Zabvine ShopAt: Riverside, Nairobi, , Kenya','2021-04-08 09:56:37',838,1),(60,-1.279144,36.816254,'Sunshine General ShopAt: Education Building, Nairobi, , KenyaAt: Uon Tower, Nairobi, , Kenya','2021-04-08 10:09:59',839,1),(62,-1.229857,36.685771,'Dawama Leather ShopAt: Matta, , , KenyaAt: Matta, , , KenyaAt: Muthure Center, , , Kenya','2021-04-09 08:35:59',841,1),(63,-1.306679,36.694574,'Fourmart SupermarketAt: Kenya Defense, Nairobi, , KenyaAt: Kenya Defense, Nairobi, , KenyaAt: Dagoretti Road, Nairobi, , Kenya','2021-04-09 08:58:08',844,1),(64,-1.284129,36.742245,'Diamond Matt Enterprises At: Wangu Street, Nairobi, , KenyaAt: 5, Nairobi, , KenyaAt: Rusinga School, Nairobi, , KenyaAt: Soko, Nairobi, , KenyaAt: Co-Op Bank, Nairobi, , KenyaAt: 5, Nairobi, , KenyaAt: Muhu Holdings House, Nairobi, , KenyaAt: Naivasha Road, Nairobi, , KenyaAt: Gitanga Road, Nairobi, , KenyaAt: Kawangware Mwisho, Nairobi, , Kenya','2021-04-09 09:05:14',845,1),(65,-1.200893,36.911738,'NyacheriAt: Kenya, Nairobi, , KenyaAt: Kenya, Nairobi, , KenyaAt: Ngumba Road, Nairobi, , KenyaAt: Ngumba Road, Nairobi, , KenyaAt: Kenya, Nairobi, , KenyaAt: Nairobi, Nairobi, , KenyaAt: Kenya, Nairobi, , KenyaAt: Ngumba Road, Nairobi, , Kenya','2021-04-09 09:12:51',846,1),(66,-1.088659,37.022741,'Wifi MattAt: Unnamed Road, Juja, , KenyaAt: Gachororo Road, Juja, , Kenya','2021-04-09 09:17:46',847,1),(67,-1.323521,36.885378,'skyzcyber','2021-04-09 12:22:33',848,1),(68,-0.951334,37.106454,'Voskey Tech CyberAt: Kabati, Kabati, , Kenya','2021-04-09 13:08:27',855,1),(69,-1.233036,36.670463,'NabsAt: Gitaru/Vantage School, Gitaru, , Kenya','2021-04-11 17:40:12',864,1),(70,-1.265362,36.738300,'Swiftmode LTD At: Hinga Road, Nairobi, , Kenya','2021-04-12 09:02:13',865,1),(71,-1.299781,36.784838,'Beatrice ShopAt: 14, Nairobi, , KenyaAt: Prestige Plaza, Nairobi, , KenyaAt: Prestige, Nairobi, , KenyaAt: Ngong Road, Nairobi, , Kenya','2021-04-12 09:15:48',866,1),(72,-1.109038,36.642040,'Wangari CosmeticsAt: Kimbushu Road, Limuru Town., , Kenya','2021-04-12 09:21:11',867,1),(73,-1.243908,36.665401,'FastCom CyberAt: Kikuyu Road, Kikuyu, , Kenya','2021-04-12 09:27:07',868,1),(74,-1.277037,36.834194,'Digital Intek','2021-04-12 09:48:29',870,1),(75,-1.277037,36.834194,'Lobentec Comps ','2021-04-12 09:55:55',871,1),(76,-1.277037,36.834194,'Diverse Logistics','2021-04-12 10:01:56',872,1),(77,-1.256205,36.873671,'Olins ChemistAt: Unnamed Road, Nairobi, , KenyaAt: Huruma Rd, Nairobi, , Kenya','2021-04-12 10:20:45',873,1),(78,-1.253786,36.873801,'JayBright Tech At: Huruma Rd, Nairobi, , Kenya','2021-04-12 10:49:10',874,1),(79,-1.260371,36.878731,'Magical Salon and CosmeticsAt: Outer Ring Road, Nairobi, , Kenya','2021-04-12 10:53:24',875,1),(80,-1.261988,36.858552,'Smart Pharm CyberAt: Unnamed Road, Nairobi, , Kenya','2021-04-12 10:59:46',876,0),(81,-1.266314,36.669389,'Amosa AgenciesAt: PCEA Kikuyu Church, Kikuyu, , Kenya','2021-04-12 11:06:34',877,1),(82,-1.392935,36.744001,'Gates InvestmentsAt: Unnamed Road, Ongata Rongai, , Kenya','2021-04-12 11:13:23',878,1),(83,-1.247197,36.678674,'Matant CommAt: Magana Road, Kikuyu, , Kenya','2021-04-12 11:18:57',879,1),(84,-1.274550,36.702819,'Vast Scientific KenyaAt: Unnamed Road, Nairobi, , KenyaAt: Nairobi County, Nairobi, , KenyaAt: Unnamed Road, Nairobi, , KenyaAt: Unnamed Road, Nairobi, , KenyaAt: Unnamed Road, Nairobi, , Kenya','2021-04-12 11:28:35',880,1),(85,-1.194529,36.945472,'Maita EnterprisesAt: Kahawa Sukari Avenue, , , Kenya','2021-04-12 11:39:43',881,1),(86,-1.158959,36.967813,'Grizzly GamersAt: Elgon Street, Ruiru, , Kenya','2021-04-12 11:45:56',882,1),(87,-1.133761,36.973666,'Hudz EntertainmentAt: Unnamed Road, Ruiru, , KenyaAt: Ruiru, Ruiru, , Kenya','2021-04-12 11:52:21',883,1),(88,-1.328674,36.880909,'Skyz cyberAt: 631, Nairobi, , KenyaAt: Imara, Nairobi, , Kenya','2021-04-12 11:59:39',884,1),(89,-1.207081,36.784895,'Total Comp Solutions','2021-04-13 13:09:13',889,1),(90,-1.216036,36.834900,'maxdynamic enterprise At: Bypass Stage Kiambu, Nairobi, , Kenya','2021-04-14 17:38:04',890,2),(91,-1.216028,36.834896,'maxdynamic enterprise At: Bypass Stage Kiambu, Nairobi, , Kenya','2021-04-14 18:02:08',891,1),(92,-1.286169,36.700219,'S-CUBE CYBERAt: Unnamed Road, Nairobi, , KenyaAt: Unnamed Road, Nairobi, , KenyaAt: Unnamed Road, Nairobi, , KenyaAt: Unnamed Road, Nairobi, , KenyaAt: Unnamed Road, Nairobi, , KenyaAt: Unnamed Road, Nairobi, , Kenya','2021-04-15 19:23:12',892,0),(93,-1.165823,36.955975,'waison investment','2021-04-16 10:58:06',893,2),(94,-1.125680,37.003422,'Dynamic graphics','2021-04-17 13:11:51',894,1),(95,-1.037267,37.073216,'Ngendo ShopAt: Thika, Thika, , KenyaAt: 33, Thika, , Kenya','2021-04-21 12:16:58',895,0),(96,-1.310951,36.784639,'Blessed CyberAt: Unnamed Road, Nairobi, , KenyaAt: Karanja Road, Nairobi, , Kenya','2021-04-21 12:28:15',896,0),(97,-1.458153,36.978499,'Main Switch Electrical Repairs At: Sulami/Nyambura, Athi River, , Kenya','2021-04-21 12:33:54',897,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,'Muranga'),(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 `customerCancelledOrders`
--

CREATE TABLE `customerCancelledOrders` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `orderId` int(20) NOT NULL,
  `userId` int(20) NOT NULL,
  `cancelReason` text NOT NULL,
  `dateCreated` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `customerCancelledOrders`
--


--
-- 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 `marketersDetails`
--

CREATE TABLE `marketersDetails` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `firstname` varchar(50) NOT NULL,
  `lasttname` varchar(50) NOT NULL,
  `surname` varchar(50) NOT NULL,
  `nationalID` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `residence` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `dob` date NOT NULL,
  `phone1` varchar(20) NOT NULL,
  `phone2` varchar(20) NOT NULL,
  `email` varchar(100) NOT NULL,
  `active` int(11) NOT NULL,
  `deleted` int(11) NOT NULL,
  `specialCode` varchar(20) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `commissionRate` decimal(10,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `marketersDetails`
--


--
-- 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,
  `preferredDateOfDelivery` date DEFAULT NULL,
  `preferredTimeOfDelivery` varchar(20) DEFAULT 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=30 DEFAULT CHARSET=latin1;

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

INSERT INTO `order_a` VALUES (1,0,58,1,-1.035973,37.074975,'Biashara, Thika, , Kenya','langata',60.43,'Nelson ','Books','0714760706',-1.364094,36.747626,-1.034606,37.076389,-1.358863,36.746768,0,0,0.00,0.00,32,456,'2021-04-17','12:00',831,'2021-04-17 10:16:57',2,1,2,254.28,'',2,'nelsonnjino@gmail.com',0,1234,4321,'466734','45,52',1),(2,0,58,1,-1.035903,37.074968,'Biashara, Thika, , Kenya','muthure ',63.86,'Manasseh','Books ','0723647389',-1.229296,36.686453,-1.034606,37.076389,-1.229857,36.685771,0,0,0.00,0.00,32,456,'2021-04-17','12:00',841,'2021-04-17 10:23:49',2,2,2,256.44,'',2,'nelsonnjino@gmail.com',0,4567,7654,'885157','45,62',2),(3,0,58,1,-1.035967,37.075219,'11, Thika, , Kenya','kayole',47.20,'Nelson','Shoes','0714760706',-1.277394,36.915798,-1.034606,37.076389,-1.278366,36.908422,0,0,0.00,0.00,19,456,'2021-04-17','12:00',289,'2021-04-17 10:26:40',2,2,2,238.34,'',2,'nelsonnjino@gmail.com',0,1234,4321,'589133','45,24',24),(4,0,58,4,-1.035978,37.074977,'Biashara, Thika, , Kenya','buruburu',47.43,'Nelson','Slippers','0714760706',-1.292248,36.881548,-1.034606,37.076389,-1.286009,36.880062,0,0,0.00,0.00,19,456,'2021-04-17','14:00',293,'2021-04-17 13:03:27',2,2,2,238.60,'',2,'nelsonnjino@gmail.com',0,4567,7654,'599117','45,28',28),(5,0,58,1,-1.091610,37.025167,'Unnamed Road, Juja, , Kenya','Kariobangi',28.70,'caro','books','0717748452',-1.240591,36.880440,-1.090953,37.024434,-1.243897,36.880732,0,0,0.00,0.00,19,274,'2021-04-18','14:48',838,'2021-04-17 13:57:22',1,2,2,216.50,'0727567938',1,'cwacera26@gmail.com',0,1234,4321,'522373','13,59',59),(6,1,0,1,-1.091610,37.025167,'Unnamed Road, Juja, , Kenya','Thika',12.86,'caro','books','0717748452',-1.038757,37.083375,-1.090953,37.024434,-1.034606,37.076389,0,0,0.00,0.00,1,274,'2021-04-18','14:48',456,'2021-04-17 13:58:00',1,2,2,191.00,'',0,'',0,0,0,'506300','13,45',0),(7,1,0,1,-1.091610,37.025167,'Unnamed Road, Juja, , Kenya','Ruai',28.04,'caro','books','0717748452',-1.255896,36.986028,-1.090953,37.024434,-1.265160,36.984949,0,0,0.00,0.00,1,274,'2021-04-18','14:48',284,'2021-04-17 13:58:48',1,2,2,215.76,'',0,'',0,0,0,'864451','13,19',0),(8,1,0,1,-1.091610,37.025167,'Unnamed Road, Juja, , Kenya','Ruai',28.04,'caro','books','0717748452',-1.255896,36.986028,-1.090953,37.024434,-1.265160,36.984949,0,0,0.00,0.00,1,274,'2021-04-18','14:48',284,'2021-04-17 14:02:04',1,2,2,215.76,'',0,'',0,0,0,'699798','13,19',0),(9,1,0,1,-1.091550,37.025256,'Unnamed Road, Juja, , Kenya','ruaka',112.72,'Naimute','drugs','0713705984',-1.205604,36.779606,-1.090953,37.024434,-1.207081,36.784895,0,0,0.00,0.00,1,274,'2021-04-17','16:03',889,'2021-04-17 16:06:07',2,1,2,311.29,'',1,'',0,0,0,'827977','13,89',0),(10,1,0,1,-1.091550,37.025256,'Unnamed Road, Juja, , Kenya','kayole',37.94,'Naimute','drugs','0713705984',-1.277394,36.915798,-1.090953,37.024434,-1.278366,36.908422,0,0,0.00,0.00,1,274,'2021-04-17','16:03',289,'2021-04-17 16:08:51',2,1,2,228.09,'',0,'',0,0,0,'863951','13,24',0),(11,1,0,1,-1.091550,37.025256,'Unnamed Road, Juja, , Kenya','ngong',62.27,'Naimute','drugs','0713705984',-1.356212,36.668755,-1.090953,37.024434,-1.306679,36.694574,0,0,0.00,0.00,1,274,'2021-04-17','16:03',844,'2021-04-17 16:10:06',2,1,2,255.34,'',0,'',0,0,0,'347980','13,63',0),(12,1,0,1,-1.091562,37.025244,'Unnamed Road, Juja, , Kenya','ngong',173.95,'jb','books','0727567938',-1.356212,36.668755,-1.090953,37.024434,-1.306679,36.694574,0,0,0.00,0.00,1,274,'2021-04-17','16:03',844,'2021-04-17 16:12:09',2,1,2,255.34,'',3,'eric.mwash91@gmail.com',0,0,0,'261337','13,63',0),(13,1,0,1,-1.091526,37.025275,'Unnamed Road, Juja, , Kenya','ngong',62.27,'Naimute','books','0713705984',-1.356212,36.668755,-1.090953,37.024434,-1.306679,36.694574,0,0,0.00,0.00,1,274,'2021-04-17','18:30',844,'2021-04-17 16:33:57',2,4,2,254.66,'',1,'',0,0,0,'526546','13,63',0),(14,1,0,1,-1.091526,37.025275,'Unnamed Road, Juja, , Kenya','ruaka',62.27,'Naimute','books','0713705984',-1.356212,36.668755,-1.090953,37.024434,-1.306679,36.694574,0,0,0.00,0.00,1,274,'2021-04-17','18:30',844,'2021-04-17 16:34:12',2,4,2,254.66,'',0,'',0,0,0,'712235','13,63',0),(15,1,0,1,-1.091526,37.025275,'Unnamed Road, Juja, , Kenya','thika',62.27,'Naimute','books','0713705984',-1.356212,36.668755,-1.090953,37.024434,-1.306679,36.694574,0,0,0.00,0.00,1,274,'2021-04-17','18:30',844,'2021-04-17 16:34:38',2,4,2,254.66,'',0,'',0,0,0,'849482','13,63',0),(16,1,0,1,-1.091526,37.025275,'Unnamed Road, Juja, , Kenya','kabati',13.57,'Naimute','books','0713705984',-0.949559,37.101731,-1.090953,37.024434,-1.034606,37.076389,0,0,0.00,0.00,1,274,'2021-04-17','18:30',456,'2021-04-17 16:35:46',2,4,2,191.40,'',0,'',0,0,0,'621268','13,45',0),(17,1,0,1,-1.091526,37.025275,'Unnamed Road, Juja, , Kenya','kabati',43.31,'Naimute','books','0713705984',-0.949559,37.101731,-1.090953,37.024434,-0.951334,37.106454,0,0,0.00,0.00,1,274,'2021-04-17','18:30',855,'2021-04-17 18:14:27',2,4,2,232.87,'',0,'',0,0,0,'685318','13,68',0),(18,1,0,1,-1.091526,37.025275,'Unnamed Road, Juja, , Kenya','makuyu',34.56,'Naimute','books','0713705984',-0.902584,37.187484,-1.090953,37.024434,-0.936780,37.122529,0,0,0.00,0.00,1,274,'2021-04-17','18:30',460,'2021-04-17 18:15:00',2,4,2,222.51,'',0,'',0,0,0,'140207','13,46',0),(19,1,0,1,-1.035905,37.074913,'Kwame Nkrumah Road, Thika, , Kenya','ruaka',50.80,'jb','books','0727567938',-1.205604,36.779606,-1.034606,37.076389,-1.207081,36.784895,0,0,0.00,0.00,1,456,'2021-04-17','18:30',889,'2021-04-17 18:45:10',2,1,1,256.60,'',3,'eric.mwash91@gmail.com',0,0,0,'138949','45,89',0),(20,1,0,1,-1.035905,37.074913,'Kwame Nkrumah Road, Thika, , Kenya','ruaka',50.80,'jb','books','0727567938',-1.205604,36.779606,-1.034606,37.076389,-1.207081,36.784895,0,0,0.00,0.00,1,456,'2021-04-17','18:30',889,'2021-04-17 18:47:15',2,1,1,256.60,'',0,'',0,0,0,'488709','45,89',0),(21,1,0,1,-1.152635,36.961327,'Thika Road, Ruiru, , Kenya','utawala',45.67,'Fei','clothes','0743276212',-1.280397,36.963968,-1.146867,36.958855,-1.281280,36.962671,0,0,0.00,0.00,1,332,'2021-04-20','11:25',285,'2021-04-20 09:37:00',2,4,2,250.24,'',1,'',0,0,0,'573865','40,20',0),(22,1,0,1,-1.152635,36.961327,'Thika Road, Ruiru, , Kenya','langata',137.56,'jb','pens','0763267938',-1.364094,36.747626,-1.146867,36.958855,-1.358863,36.746768,0,0,0.00,0.00,1,332,'2021-04-20','11:25',831,'2021-04-20 09:39:57',2,4,1,366.66,'',2,'',0,0,0,'562378','40,52',0),(23,1,0,1,-1.152755,36.961185,'Thika Road, Ruiru, , Kenya','njiru',38.88,'erique','clothes','0727567938',-1.250455,36.927086,-1.146867,36.958855,-1.258086,36.921167,0,0,0.00,0.00,1,332,'2021-04-21','02:08',287,'2021-04-20 10:13:00',1,1,2,241.82,'0727567938',2,'',0,0,0,'343497','40,22',0),(24,1,0,1,-1.152755,36.961185,'Thika Road, Ruiru, , Kenya','makadara',41.08,'jb','files','0727567938',-1.295298,36.872114,-1.146867,36.958855,-1.293385,36.862723,0,0,0.00,0.00,1,332,'2021-04-21','10:19',296,'2021-04-20 10:23:07',2,3,2,245.17,'',2,'',0,0,0,'270227','40,31',0),(25,0,58,1,-1.121359,37.012905,'Unnamed Road, Juja, , Kenya','Ruaka',62.12,'Sally Kim','Goods','0714760706',-1.205604,36.779606,-1.125680,37.003422,-1.207081,36.784895,0,0,0.00,0.00,1,894,'2021-04-21','9:30 AM',889,'2021-04-21 07:16:20',2,2,2,376.26,'',2,'eric.meash91@gmail.com',0,0,0,'441847','94,40,50,93,89',19),(26,0,58,1,-1.121312,37.012985,'Unnamed Road, Kalimoni, , Kenya','Ruaka',62.13,'Zabby Kim','Goods','0714760706',-1.205604,36.779606,-1.125680,37.003422,-1.207081,36.784895,0,0,0.00,0.00,2,894,'2021-04-21','9:30 AM',889,'2021-04-21 09:51:04',2,2,2,376.27,'',2,'eric.mwash91@gmail.com',0,0,0,'658173','94,40,50,93,89',0),(27,0,58,1,-1.091418,37.025311,'Unnamed Road, Juja, , Kenya','kiambu',179.97,'Erick','books','0727567938',-1.031370,36.868079,-1.090953,37.024434,-1.171860,36.843175,0,0,0.00,0.00,1,274,'2021-04-22','09:40',477,'2021-04-21 10:59:58',2,1,1,417.39,'',3,'eric.mwash91@gmail.com',0,0,0,'682216','13,47',0),(28,0,58,1,-1.091418,37.025311,'Unnamed Road, Juja, , Kenya','kiambu',179.97,'Erick','books','0727567938',-1.031370,36.868079,-1.090953,37.024434,-1.171860,36.843175,0,0,0.00,0.00,1,274,'2021-04-22','09:40',477,'2021-04-21 11:00:01',2,1,1,417.39,'',3,'eric.mwash91@gmail.com',0,0,0,'848144','13,47',47),(29,0,58,1,-1.091465,37.025229,'Unnamed Road, Juja, , Kenya','ruai',127.67,'jb','files','0727567938',-1.255896,36.986028,-1.090953,37.024434,-1.265160,36.984949,0,0,0.00,0.00,1,274,'2021-04-22','09:40',284,'2021-04-21 11:06:53',2,1,1,352.54,'',3,'eric.mwash91@gmail.com',0,0,0,'517645','13,19',47);

--
-- 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 `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,
  `payerPhone` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `paidSignUps`
--

INSERT INTO `paidSignUps` VALUES (1,'110336-17104425-1',1.00,'20210322095554','PCM5Y48ED7','254714760706'),(2,'',1.00,'20210322101022','PCM0Y4U91M','254723647389'),(3,'',1.00,'20210322101640','PCM8Y53T3E','254723647389'),(4,'36949302',1.00,'20210322102651','PCM9Y5JJ8T','254723647389'),(5,'24072292',50.00,'254720316885','PDD2RR6RUA',''),(6,'34422995',50.00,'20210414175828','PDE1TGAF1Z','254723843382'),(7,'23652289',1.00,'20210416054218','PDG9V7I1EN','254714760706'),(8,'12992290',50.00,'20210417131103','PDH0WZFHJM','254722217056');

--
-- 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 AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

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

INSERT INTO `paidordersA` VALUES (1,1.00,'20210324093858','PCO41KB70A','254727567938',52),(2,1.00,'20210325115855','PCP2303HTA','254714760706',56),(3,1.00,'20210417140318','PDH5X24GC3','254714760706',1),(4,1.00,'20210417140318','PDH5X24GC3','254714760706',1),(5,1.00,'20210417151835','PDH9X5WMRZ','254723647389',2),(6,1.00,'20210417154216','PDH1X73GGB','254723647389',2);

--
-- 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 `reserveAmount`
--

CREATE TABLE `reserveAmount` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `orderId` int(20) DEFAULT NULL,
  `reserveAmount` decimal(15,2) DEFAULT NULL,
  `dateCreated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=119 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `reserveAmount`
--

INSERT INTO `reserveAmount` VALUES (1,0,73.45,'2021-04-16 19:05:37'),(2,0,73.45,'2021-04-16 19:49:13'),(3,0,73.31,'2021-04-17 10:16:50'),(4,0,73.55,'2021-04-17 10:23:39'),(5,0,64.78,'2021-04-17 10:26:17'),(6,0,64.91,'2021-04-17 13:03:21'),(7,0,53.30,'2021-04-17 13:57:17'),(8,0,36.67,'2021-04-17 13:57:50'),(9,0,52.93,'2021-04-17 13:58:46'),(10,0,-52.22,'2021-04-17 16:06:01'),(11,0,-52.22,'2021-04-17 16:06:03'),(12,0,-51.67,'2021-04-17 16:08:47'),(13,0,-51.67,'2021-04-17 16:10:02'),(14,0,-51.67,'2021-04-17 16:12:06'),(15,0,-51.66,'2021-04-17 16:12:11'),(16,0,241.78,'2021-04-16 18:33:25'),(17,0,256.25,'2021-04-16 18:45:49'),(18,0,256.25,'2021-04-16 18:48:20'),(19,0,0.00,'2021-04-16 18:49:26'),(20,0,182.80,'2021-04-16 18:51:28'),(21,0,73.45,'2021-04-16 18:52:32'),(22,0,73.45,'2021-04-16 18:54:29'),(23,0,83.20,'2021-04-17 18:43:36'),(24,0,69.56,'2021-04-17 18:44:51'),(25,0,69.56,'2021-04-17 19:17:00'),(26,0,-52.36,'2021-04-18 06:53:17'),(27,0,-52.36,'2021-04-18 06:58:33'),(28,0,-52.36,'2021-04-18 06:59:24'),(29,0,-52.36,'2021-04-19 18:50:08'),(30,0,-52.36,'2021-04-19 18:51:37'),(31,0,-52.36,'2021-04-19 19:07:49'),(32,0,-52.36,'2021-04-19 19:10:22'),(33,0,103.12,'2021-04-20 08:23:23'),(34,0,79.56,'2021-04-20 08:24:58'),(35,0,152.98,'2021-04-20 09:31:07'),(36,0,63.90,'2021-04-20 09:34:08'),(37,0,66.38,'2021-04-20 09:36:32'),(38,0,125.84,'2021-04-20 09:39:37'),(39,0,126.50,'2021-04-20 09:45:35'),(40,0,227.97,'2021-04-20 09:45:42'),(41,0,-51.73,'2021-04-20 09:46:50'),(42,0,-304.03,'2021-04-20 09:47:23'),(43,0,-506.95,'2021-04-20 09:47:31'),(44,0,-408.27,'2021-04-20 09:49:16'),(45,0,84.85,'2021-04-20 10:09:43'),(46,0,37.45,'2021-04-20 10:10:49'),(47,0,62.18,'2021-04-20 10:12:33'),(48,0,64.16,'2021-04-20 10:22:25'),(49,0,128.38,'2021-04-20 10:26:45'),(50,0,128.38,'2021-04-20 10:26:53'),(51,0,74.14,'2021-04-20 15:07:27'),(52,0,158.53,'2021-04-20 15:40:45'),(53,0,158.45,'2021-04-20 15:41:24'),(54,0,75.22,'2021-04-20 15:44:15'),(55,0,86.02,'2021-04-20 15:48:22'),(56,0,86.02,'2021-04-20 15:53:55'),(57,0,-188.24,'2021-04-20 15:55:19'),(58,0,-188.24,'2021-04-20 15:55:29'),(59,0,86.02,'2021-04-20 15:55:35'),(60,0,-188.24,'2021-04-20 15:56:11'),(61,0,66.17,'2021-04-20 17:24:17'),(62,0,68.24,'2021-04-20 17:25:14'),(63,0,68.24,'2021-04-20 17:46:50'),(64,0,68.24,'2021-04-20 17:49:20'),(65,0,68.24,'2021-04-20 17:50:10'),(66,0,68.24,'2021-04-20 17:50:20'),(67,0,68.24,'2021-04-20 17:53:05'),(68,0,68.24,'2021-04-20 17:56:20'),(69,0,68.24,'2021-04-20 17:56:36'),(70,0,106.43,'2021-04-20 18:00:20'),(71,0,106.43,'2021-04-20 18:00:56'),(72,0,106.43,'2021-04-20 18:02:50'),(73,0,106.43,'2021-04-20 18:03:29'),(74,0,106.43,'2021-04-20 18:11:02'),(75,0,60.42,'2021-04-20 18:12:09'),(76,0,60.42,'2021-04-20 18:14:34'),(77,0,60.42,'2021-04-20 18:14:45'),(78,0,60.42,'2021-04-20 18:15:14'),(79,0,106.43,'2021-04-20 18:22:08'),(80,0,106.43,'2021-04-20 18:23:09'),(81,0,106.43,'2021-04-20 18:23:23'),(82,0,106.43,'2021-04-20 18:26:08'),(83,0,110.05,'2021-04-20 18:31:08'),(84,0,106.43,'2021-04-20 18:32:29'),(85,0,106.43,'2021-04-20 18:35:51'),(86,0,106.43,'2021-04-20 18:39:14'),(87,0,106.43,'2021-04-20 18:39:53'),(88,0,106.43,'2021-04-20 18:40:30'),(89,0,106.43,'2021-04-20 18:41:51'),(90,0,106.43,'2021-04-20 18:42:56'),(91,0,106.43,'2021-04-20 18:45:49'),(92,0,106.43,'2021-04-20 18:47:21'),(93,0,106.43,'2021-04-20 18:48:04'),(94,0,106.43,'2021-04-20 18:48:40'),(95,0,197.18,'2021-04-20 18:51:57'),(96,0,197.18,'2021-04-20 18:51:57'),(97,0,106.43,'2021-04-20 18:53:54'),(98,0,106.43,'2021-04-20 18:55:33'),(99,0,106.43,'2021-04-20 18:57:55'),(100,0,106.43,'2021-04-20 18:59:50'),(101,0,106.43,'2021-04-20 19:00:54'),(102,0,73.39,'2021-04-21 06:26:39'),(103,0,73.39,'2021-04-21 06:33:12'),(104,0,124.51,'2021-04-21 06:36:36'),(105,0,124.51,'2021-04-21 06:36:36'),(106,0,73.39,'2021-04-21 06:38:41'),(107,0,73.39,'2021-04-21 06:41:55'),(108,0,73.39,'2021-04-21 06:47:43'),(109,0,73.39,'2021-04-21 06:49:35'),(110,0,2.17,'2021-04-21 06:58:02'),(111,0,2.17,'2021-04-21 07:09:48'),(112,0,2.17,'2021-04-21 07:11:30'),(113,0,32.14,'2021-04-21 07:15:51'),(114,0,24.37,'2021-04-21 09:21:24'),(115,0,32.15,'2021-04-21 09:22:14'),(116,0,32.15,'2021-04-21 09:22:34'),(117,0,50.62,'2021-04-21 09:43:21'),(118,0,-66.83,'2021-04-21 09:44:43');

--
-- Table structure for table `shopAgentspayments`
--

CREATE TABLE `shopAgentspayments` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `orderId` int(20) DEFAULT NULL,
  `PccAgentCost` decimal(15,2) NOT NULL DEFAULT '0.00',
  `DccAgentCost` decimal(15,2) NOT NULL DEFAULT '0.00',
  `alongRouteShopAgentsCosts` decimal(15,2) DEFAULT '0.00',
  `dateCreated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=119 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `shopAgentspayments`
--

INSERT INTO `shopAgentspayments` VALUES (1,0,11.03,11.03,71.49,'2021-04-17 07:50:30'),(2,0,11.03,11.03,71.49,'2021-04-17 07:50:48'),(3,1,11.03,11.03,74.30,'2021-04-17 10:16:50'),(4,2,11.03,11.03,75.46,'2021-04-17 10:23:39'),(5,3,11.03,11.03,69.86,'2021-04-17 10:26:17'),(6,4,11.03,11.03,69.94,'2021-04-17 13:03:21'),(7,5,11.03,11.03,63.64,'2021-04-17 13:57:17'),(8,6,11.03,11.03,58.32,'2021-04-17 13:57:50'),(9,8,11.03,11.03,63.42,'2021-04-17 13:58:46'),(10,0,11.06,11.06,183.75,'2021-04-17 16:06:01'),(11,9,11.06,11.06,183.75,'2021-04-17 16:06:03'),(12,10,11.06,11.06,133.50,'2021-04-17 16:08:47'),(13,11,11.06,11.06,149.85,'2021-04-17 16:10:02'),(14,12,11.06,11.06,149.85,'2021-04-17 16:12:06'),(15,0,11.06,11.06,224.89,'2021-04-17 16:12:11'),(16,0,11.03,11.03,74.92,'2021-04-17 16:33:52'),(17,0,11.03,11.03,58.56,'2021-04-17 16:35:01'),(18,0,11.03,11.03,66.04,'2021-04-17 16:35:05'),(19,0,11.03,11.03,58.56,'2021-04-17 16:35:36'),(20,0,11.03,11.03,68.55,'2021-04-17 16:35:59'),(21,0,11.03,11.03,65.61,'2021-04-17 18:14:53'),(22,0,15.03,15.03,71.88,'2021-04-17 18:43:03'),(23,0,15.03,15.03,80.95,'2021-04-17 18:43:36'),(24,20,15.03,15.03,73.14,'2021-04-17 18:44:51'),(25,0,15.03,15.03,73.14,'2021-04-17 19:17:00'),(26,0,15.06,15.06,136.38,'2021-04-18 06:53:17'),(27,0,15.06,15.06,136.38,'2021-04-18 06:58:33'),(28,0,15.06,15.06,136.38,'2021-04-18 06:59:24'),(29,0,15.06,15.06,136.38,'2021-04-19 18:50:08'),(30,0,15.06,15.06,136.38,'2021-04-19 18:51:37'),(31,0,15.06,15.06,136.38,'2021-04-19 19:07:49'),(32,0,15.06,15.06,136.38,'2021-04-19 19:10:22'),(33,0,15.03,15.03,92.91,'2021-04-20 08:23:23'),(34,0,15.03,15.03,78.39,'2021-04-20 08:24:58'),(35,0,15.03,15.03,122.44,'2021-04-20 09:31:07'),(36,0,15.03,15.03,69.00,'2021-04-20 09:34:08'),(37,21,15.03,15.03,71.23,'2021-04-20 09:36:32'),(38,22,15.03,15.03,105.41,'2021-04-20 09:39:37'),(39,0,15.03,15.03,107.31,'2021-04-20 09:45:35'),(40,0,15.03,15.03,168.18,'2021-04-20 09:45:42'),(41,0,15.06,15.06,214.61,'2021-04-20 09:46:50'),(42,0,15.13,15.13,304.14,'2021-04-20 09:47:23'),(43,0,15.13,15.13,547.64,'2021-04-20 09:47:31'),(44,0,15.13,15.13,429.22,'2021-04-20 09:49:16'),(45,0,15.03,15.03,82.31,'2021-04-20 10:09:43'),(46,0,15.03,15.03,88.37,'2021-04-20 10:10:49'),(47,23,15.03,15.03,68.70,'2021-04-20 10:12:33'),(48,24,15.03,15.03,69.52,'2021-04-20 10:22:25'),(49,0,15.03,15.03,107.69,'2021-04-20 10:26:45'),(50,0,15.03,15.03,107.69,'2021-04-20 10:26:53'),(51,0,15.03,15.03,75.88,'2021-04-20 15:07:27'),(52,0,15.03,15.03,125.78,'2021-04-20 15:40:45'),(53,0,15.03,15.03,125.72,'2021-04-20 15:41:24'),(54,0,15.03,15.03,76.54,'2021-04-20 15:44:15'),(55,0,15.03,15.03,82.65,'2021-04-20 15:48:22'),(56,0,15.03,15.03,82.65,'2021-04-20 15:53:55'),(57,0,15.09,15.09,247.87,'2021-04-20 15:55:19'),(58,0,15.09,15.09,247.87,'2021-04-20 15:55:29'),(59,0,15.03,15.03,82.65,'2021-04-20 15:55:35'),(60,0,15.09,15.09,247.87,'2021-04-20 15:56:11'),(61,0,15.03,15.03,71.85,'2021-04-20 17:24:17'),(62,0,15.03,15.03,73.09,'2021-04-20 17:25:14'),(63,0,15.03,15.03,73.09,'2021-04-20 17:46:50'),(64,0,15.03,15.03,73.09,'2021-04-20 17:49:20'),(65,0,15.03,15.03,73.09,'2021-04-20 17:50:10'),(66,0,15.03,15.03,73.09,'2021-04-20 17:50:20'),(67,0,15.03,15.03,73.09,'2021-04-20 17:53:05'),(68,0,15.03,15.03,73.09,'2021-04-20 17:56:20'),(69,0,15.03,15.03,73.09,'2021-04-20 17:56:36'),(70,0,15.03,15.03,94.52,'2021-04-20 18:00:20'),(71,0,15.03,15.03,94.52,'2021-04-20 18:00:56'),(72,0,15.03,15.03,94.52,'2021-04-20 18:02:50'),(73,0,15.03,15.03,94.52,'2021-04-20 18:03:29'),(74,0,15.03,15.03,94.52,'2021-04-20 18:11:02'),(75,0,15.03,15.03,67.29,'2021-04-20 18:12:09'),(76,0,15.03,15.03,67.29,'2021-04-20 18:14:34'),(77,0,15.03,15.03,67.29,'2021-04-20 18:14:45'),(78,0,15.03,15.03,67.29,'2021-04-20 18:15:14'),(79,0,15.03,15.03,94.52,'2021-04-20 18:22:08'),(80,0,15.03,15.03,94.52,'2021-04-20 18:23:09'),(81,0,15.03,15.03,94.52,'2021-04-20 18:23:23'),(82,0,15.03,15.03,94.52,'2021-04-20 18:26:08'),(83,0,15.03,15.03,96.32,'2021-04-20 18:31:08'),(84,0,15.03,15.03,94.52,'2021-04-20 18:32:29'),(85,0,15.03,15.03,94.52,'2021-04-20 18:35:51'),(86,0,15.03,15.03,94.52,'2021-04-20 18:39:14'),(87,0,15.03,15.03,94.52,'2021-04-20 18:39:53'),(88,0,15.03,15.03,94.52,'2021-04-20 18:40:30'),(89,0,15.03,15.03,94.52,'2021-04-20 18:41:51'),(90,0,15.03,15.03,94.52,'2021-04-20 18:42:56'),(91,0,15.03,15.03,94.52,'2021-04-20 18:45:49'),(92,0,15.03,15.03,94.52,'2021-04-20 18:47:21'),(93,0,15.03,15.03,94.52,'2021-04-20 18:48:04'),(94,0,15.03,15.03,94.52,'2021-04-20 18:48:40'),(95,0,15.03,15.03,148.97,'2021-04-20 18:51:57'),(96,0,15.03,15.03,148.97,'2021-04-20 18:51:57'),(97,0,15.03,15.03,94.52,'2021-04-20 18:53:54'),(98,0,15.03,15.03,94.52,'2021-04-20 18:55:33'),(99,0,15.03,15.03,94.52,'2021-04-20 18:57:55'),(100,0,15.03,15.03,94.52,'2021-04-20 18:59:50'),(101,0,15.03,15.03,94.52,'2021-04-20 19:00:54'),(102,0,15.03,15.03,75.07,'2021-04-21 06:26:39'),(103,0,15.03,15.03,75.07,'2021-04-21 06:33:12'),(104,0,15.03,15.03,105.74,'2021-04-21 06:36:36'),(105,0,15.03,15.03,105.74,'2021-04-21 06:36:36'),(106,0,15.03,15.03,75.07,'2021-04-21 06:38:41'),(107,0,15.03,15.03,75.07,'2021-04-21 06:41:55'),(108,0,15.03,15.03,75.07,'2021-04-21 06:47:43'),(109,0,15.03,15.03,75.07,'2021-04-21 06:49:35'),(110,0,15.03,15.03,77.35,'2021-04-21 06:58:02'),(111,0,15.03,15.03,77.35,'2021-04-21 07:09:48'),(112,0,15.03,15.03,77.35,'2021-04-21 07:11:30'),(113,25,15.03,15.03,77.35,'2021-04-21 07:15:51'),(114,0,15.03,15.03,72.69,'2021-04-21 09:21:24'),(115,0,15.03,15.03,77.35,'2021-04-21 09:22:14'),(116,26,15.03,15.03,77.35,'2021-04-21 09:22:34'),(117,0,15.03,15.03,70.80,'2021-04-21 09:43:21'),(118,0,15.06,15.06,141.60,'2021-04-21 09:44:43');

--
-- Table structure for table `shopAgentspaymentsAllocations`
--

CREATE TABLE `shopAgentspaymentsAllocations` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `orderId` int(20) DEFAULT NULL,
  `PccAgentCostStaffID` decimal(15,2) NOT NULL DEFAULT '0.00',
  `PccAgentCostConfirmed` int(2) NOT NULL DEFAULT '0',
  `DccAgentCostStaffID` decimal(15,2) NOT NULL DEFAULT '0.00',
  `DccAgentCostConfirmed` int(2) NOT NULL DEFAULT '0',
  `alongRouteShopAgentsCostsStaffID` decimal(15,2) NOT NULL DEFAULT '0.00',
  `alongRouteShopAgentsCostConfirmed` text,
  `dateCreated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `shopAgentspaymentsAllocations`
--


--
-- 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,
  `businessOwnershipType` int(3) 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 (274,'Naomi Wangari','wife','0724115310','Mike','Miketech Electronics ','Kiambu','Juja','Electronics ',1,'81089',60,50,10000.00,2,'3','',100.00,'1','Partial Payment',2,NULL,'','M-PESA','','','','0714185868','2021-02-24 20:13:11'),(278,'Nancy Njeri','wife','0723500292','Sam Dominion','Dominion Ventures','Nairobi','Dagoretti South','wholesale/retail',1,'742613',6,30,18000.00,3,'PBPIIV55ZH','Njau',50.00,'1','Partial Payment',1,NULL,'','Bank Account','Cooperative bank','Zimmerman','01109284067700','','2021-02-25 09:09:56'),(279,'Derrick Mogere','Brother','0700025390','Janet','Baby Shop','Nairobi','Embakasi Central','Shop',1,'1706322',36,20,15000.00,1,'3','',50.00,'1','Partial Payment',1,NULL,'','M-PESA','','','','0715841013','2021-02-25 13:34:07'),(284,'Joseph Mbugua','Husband','0724230280','Nancy','Hingas Stores','Nairobi','Kasarani','Retail ',1,'1447856',60,150,12000.00,0,'3','',50.00,'1','Partial Payment',1,NULL,'','M-PESA','','','','0724866978','2021-02-26 09:01:55'),(285,'Robert Kanyi','Employer','0722811443','Kim','Eastgate Carwash','Nairobi','Embakasi East','Carwash ',1,'1296235',108,60,40000.00,10,'3','',50.00,'1','Partial Payment',1,NULL,'','M-PESA','','','','0727466670','2021-02-26 10:33:31'),(286,'John Tochi','Brother','0713703400','Lawrence','Clixed Photos','Nairobi','Embakasi East','Photo Studio',1,'1743346',36,35,7000.00,0,'3','',50.00,'1','Partial Payment',1,NULL,'','M-PESA','','','','0742606307','2021-02-26 11:59:57'),(287,'John Kanyuru','Husband','0722257740','Susan','Poa Pay Investments','Nairobi','Embakasi Central','Electronics',1,'151634',180,50,15000.00,0,'3','',50.00,'1','Partial Payment',1,NULL,'','M-PESA','','','','0721478917','2021-02-26 12:43:13'),(288,'Samuel Mburu','Partner','0763275530','Whitehouse','Whitehouse Enterprises','Nairobi','Embakasi Central','Electronics',1,'66243',204,100,7000.00,2,'3','',50.00,'1','Partial Payment',1,NULL,'','M-PESA','','','','0720575530','2021-02-26 14:02:34'),(289,'Dishon Maina','Dad','0781229049','Maish','Super Five Shop','Nairobi','Embakasi Central','Retail ',1,'1574410',3,100,15000.00,0,'3','',50.00,'1','Partial Payment',1,NULL,'','M-PESA','','','','0704155039','2021-02-26 14:41:33'),(290,'Jeff Makori','Partner','0721549608','MJ','MJ Signs','Nairobi','Embakasi West','Electronics ',2,'1564417',6,50,15000.00,2,'3','',50.00,'1','Partial Payment',1,NULL,'','M-PESA','','','','0726022902','2021-02-26 15:44:51'),(291,'Gicoge Guto','Husband','0721546196','Guro','Guro Company ','Nairobi','Embakasi West','Shop',1,'151452',144,50,10000.00,1,'3','',50.00,'1','Partial Payment',1,NULL,'','M-PESA','','','','0710840281','2021-02-26 16:23:47'),(292,'Lilian Ochieng','wife','0701164784','Joshua','Sigma','Nairobi','Embakasi West','Cyber',1,'150440',36,20,9000.00,1,'3','',50.00,'1','Partial Payment',1,NULL,'','M-PESA','','','','0720565412','2021-02-26 17:12:51'),(293,'Daniel Racivu','Partner','0759584162','JI','Jirani One Kenya','Nairobi','Makadara','Art Stusio',2,'154121',24,50,7000.00,10,'3','',50.00,'1','Partial Payment',1,NULL,'','M-PESA','','','','0710413569','2021-02-26 18:30:09'),(294,'Phoebe','Friend','0708695882','Cynthia','Port Florence Ventures ','Nairobi','Embakasi Central','Retail ',1,'1517747',12,20,0.00,0,'3','',50.00,'1','Partial Payment',1,NULL,'','M-PESA','','','','0112521973','2021-02-27 10:18:54'),(295,'Richard','cousin','0701409934','Dan','Amber Joy Cyber','Nairobi','Makadara','Cyber',1,'1725445',48,50,7000.00,1,'3','',50.00,'1','Partial Payment',1,NULL,'','M-PESA','','','','0720829626','2021-02-27 11:18:54'),(296,'John Nzuli ','Brother','0101768205','Jack','Jack Creatives','Nairobi','Makadara','Cyber',1,'174168',36,100,3000.00,1,'3','',50.00,'1','Partial Payment',1,NULL,'','M-PESA','','','','0706205768','2021-02-27 12:33:09'),(298,'Winnie Nzioka','spouse','0776615042','Mwatu','Steltech Cyber','Nairobi','Kamukunji','Cyber ',1,'1217556',120,100,27000.00,0,'3','',50.00,'1','Partial Payment',1,NULL,'','M-PESA','','','','0721606894','2021-02-27 14:00:14'),(299,'John Waweru','Spouse','0705183080','Mama caleb','Jomeca Shop','Nairobi','Roysambu','Retail',1,'1396308',48,50,15000.00,1,'3','',50.00,'1','Partial Payment',1,NULL,'','M-PESA','','','','0713439693','2021-02-27 16:18:29'),(300,'Reuben Muriithi','Brother','0711115552','Wizzy','Wizzay Investments','Nairobi','Roysambu','Money Transactions ',1,'1574421',60,50,10000.00,4,'3','Duncan',50.00,'1','Partial Payment',1,NULL,'','M-PESA','','','','0726080574','2021-02-27 17:10:50'),(301,'Salome Wanjiku','Spouse','0725917231','Icotec','Icotec','Kiambu','Ruiru','Cyber',1,'96297',120,100,15000.00,2,'3','',50.00,'1','Partial Payment',1,NULL,'','M-PESA','','','','0725281856','2021-02-27 18:08:07'),(302,'Fridah Kaaria','sister','0723820034','Roy','Kahawa Bookshop ','Kiambu','Ruiru','Bookshop',3,'105905',144,200,30000.00,3,'3','',50.00,'1','One Off Payment- Ksh 500.',0,NULL,'','Bank Account','Cooperative Bank ','Githurai','01192156469500','','2021-02-27 18:50:21'),(316,'Alfred Mwaura','Spouse','0720284116','Betty','Styles and smiles salon',NULL,NULL,'Salon',NULL,'1452400',4,8,28000.00,5,'PC1771JSSJ','Beatrice',50.00,'1','Partial Payment',1,NULL,'','M-PESA','','','','0702442678','2021-03-01 10:41:28'),(317,'Mercy Nyawira','Sister','0706892238','Sam','Cyber, Zimmerman',NULL,NULL,'cyber',NULL,'172412',3,20,10000.00,1,'PC15754N5B','Kanja',50.00,'1','Partial Payment',1,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',NULL,'1504093',3,50,10000.00,1,'PC18789ZG8','Mbatha',50.00,'1','Partial Payment',1,NULL,'','M-PESA','','','','0711318567','2021-03-01 13:15:14'),(332,'James Waigwa','spouse','0700280060','Rahab','Sort IT Enterprise','Kiambu','Ruiru','cyber',1,'58284',5,200,23500.00,1,'-123','Rahab',500.00,'1','To Pay Later',0,'2021-04-18 00:00:00','Trust issues','M-PESA','','','','0720969948','2021-03-01 14:24:43'),(440,'Damaris Wairimu','Spouse','0726293826','Nene','Jordan Hardware','Kiambu','Juja','Hardware Shop',1,'150721',24,30,15000.00,3,'3','',100.00,'1','Partial Payment',2,NULL,'','M-PESA','','','','0723565268','2021-03-02 13:41:41'),(450,'Jackline Kamonya','spouse','0719322396','Shem','BM Wholesalers','Kiambu','Thika Town','Wholesale and Retail',1,'157177',6,200,8500.00,7,'3','Shem',100.00,'1','Partial Payment',2,NULL,'','M-PESA','','','','0723651322','2021-03-03 10:15:42'),(453,'Samuel Gatimu','son','0728001190','Faite','Harok Enterprises ','Kiambu','Thika Town','shop',1,'152300',48,100,5000.00,1,'3','',50.00,'1','Partial Payment',1,NULL,'','M-PESA','','','','0706783575','2021-03-03 13:41:25'),(456,'Salome Wanjiku','mother','0728991634','Carol','Neema Households ','Kiambu','Thika Town','General shop',1,'150150',7,20,18000.00,3,'PC39A4GZZ9','Caroline',50.00,'1','Partial Payment',1,NULL,'','Bank Account','Equity','Thika ','0090193012134','0711947997','2021-03-03 16:54:18'),(477,'Lewis Rampei ','husband ','0769606054','Ivon','Zigzag ','Kiambu','Ruiru','Cyber',1,'43781',36,50,10000.00,0,'3','',50.00,'1','Partial Payment',1,NULL,'','M-PESA','','','','0794209980','2021-03-06 11:02:35'),(478,'Diana Akuti','spouse','0705004689','Alex','Kinyozi Maalum','Kiambu','Kiambu','Kinyozi',1,'160181',96,15,15000.00,1,'3','',50.00,'1','Partial Payment',1,NULL,'','M-PESA','','','','0759317485','2021-03-06 13:31:42'),(506,'Philip Sande','Brother','07000000','','Abeingo',NULL,NULL,'Retail',NULL,'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',NULL,'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'),(799,'Shaban Hassan','x','0748108072','','MKY Movies','Kiambu','Juja','Movie Shop',1,'1',36,20,10000.00,0,'3','',50.00,'0','Partial Payment',1,NULL,'','M-PESA','','','','0742208060','2021-04-07 14:09:42'),(800,'Jane Akinyi Robert','mother','0720473005','Vee','Veez Fast Food ','Nairobi','Langata','Restaurant',1,'1',36,20,0.00,13,'3','',50.00,'0','Partial Payment',1,NULL,'','M-PESA','','','','0720880033','2021-04-07 14:14:32'),(831,'xxxxx','xxxx','07000','','Zacafric Computer Systems','Nairobi','Langata','Cyber',3,'1',120,20,0.00,0,'3','',50.00,'0','Partial Payment',1,NULL,'','M-PESA','','','','0723995811','2021-04-08 09:04:09'),(832,'Peter Kasumba','Husband','0729909957','','Airfiber Internet Cafe','Nairobi','Makadara','Cyber',1,'BN-EZCA2YY',120,20,0.00,2,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0714928814','2021-04-08 09:18:09'),(833,'xxxxx','xxxxx','07000','','Uchad Technologies','Nairobi','Langata','Cyber',1,'1729871',12,20,0.00,2,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0716956752','2021-04-08 09:23:37'),(834,'Samwel Ochieng','x','0722917077','','Loretto Dry Cleaners','Nairobi','Langata','Dry Cleaners',1,'MS19700569',2,20,0.00,7,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0790343375','2021-04-08 09:27:39'),(835,'Philip Sande','Brother ','07000','','Abeingo','Nairobi','Kibra','Retail',2,'001',60,20,15000.00,2,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0795883732','2021-04-08 09:37:50'),(836,'Jacklina Asinta','x','0721789421','','Elim Barbers','Nairobi','Westlands','Barber Shop',1,'1322259',60,20,20000.00,1,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0737243948','2021-04-08 09:43:45'),(837,'Tyson Cohen','x','0720541050','','Out Post','Kiambu','Limuru','Shop',1,'1301838',48,20,10000.00,0,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0720698670','2021-04-08 09:50:29'),(838,'Mildovine Otsieno','x','0704447515','','Zabvine Shop','Nairobi','Ruaraka','Retail ',1,'001',12,20,15000.00,3,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0707507777','2021-04-08 09:56:37'),(839,'Erastus Kimathi','Partner','0799394787','Kevo','Sunshine General Shop','Nairobi','Westlands','Retail',1,'1',120,20,25000.00,1,'3','',50.00,'0','Partial Payment',1,NULL,'','M-PESA','','','','0710601264','2021-04-08 10:09:59'),(841,'Damaris Wanjiru ','mother','0720374518','','Dawama Leather Shop','Kiambu','Kabete','Bookshop, Uniforms ',1,'1470066',48,50,11000.00,3,'3','',100.00,'0','Partial Payment',2,NULL,'','M-PESA','','','','0702063143','2021-04-09 08:35:59'),(844,'Philomena Wangui','mother','0724622662','','Fourmart Supermarket','Nairobi','Dagoretti South','Supermarket',1,'1474741',60,90,50000.00,5,'3','',50.00,'0','Partial Payment',1,NULL,'','M-PESA','','','','0722447747','2021-04-09 08:58:08'),(845,'Stephen Karanja','brother','0799451585','Ndungu','Diamond Matt Enterprises ','Nairobi','Dagoretti North,','Mattress Sales',1,'1424682',98,7,15000.00,1,'3','',500.00,'0','One Off Payment- Ksh 500.',0,NULL,'','M-PESA','','','','0722916522','2021-04-09 09:05:14'),(846,'Jackline Era','Daughter','0790504734','Nyacheri','Nyacheri','Nairobi','Roysambu','General Shop',1,'170140',48,50,10000.00,0,'3','',50.00,'0','Partial Payment',1,NULL,'','M-PESA','','','','0719375222','2021-04-09 09:12:51'),(847,'Ida Nkatha','wife','0716283229','','Wifi Matt','Kiambu','Juja','Supermarket',2,'BN-AZCD28K',12,50,41000.00,4,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0700677100','2021-04-09 09:17:46'),(848,'zacharian nyoike','husband','0723341366','','skyzcyber','Nairobi','Embakasi South','cyber cafe',1,'1173489',10,20,19000.00,1,'','',500.00,'0','One Off Payment- Ksh 500.',NULL,NULL,'','M-PESA','','','','0714084644','2021-04-09 12:22:33'),(855,'Susan Wanjiru','Spouse','0703289272','Kariuki','Voskey Tech Cyber','Muranga','Muranga South','Cyber',1,'160151',24,30,7000.00,2,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0719759646','2021-04-09 13:08:27'),(864,'Evelyn Nthambi','Daughter','0729164458','Benna','Nabs','Kiambu','Kikuyu','Bookshop',1,'001',240,200,14000.00,2,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0721654660','2021-04-11 17:40:12'),(865,'xxxx','xxxx','07000','','Swiftmode LTD ','Kiambu','Kabete','Shop/Restaurant',3,'c-95816',240,25,20000.00,3,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0712498274','2021-04-12 09:02:13'),(866,'Simon','Spouse','0712171800','','Beatrice Shop','Nairobi','Kibra','Mpesa Shop',1,'1721721',60,70,10000.00,1,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0702403117','2021-04-12 09:15:48'),(867,'Beth Wangari','Spouse','0713149995','Titus','Wangari Cosmetics','Kiambu','Limuru','Salon ',1,'1501250',120,20,4000.00,2,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0726759825','2021-04-12 09:21:11'),(868,'Dickson Ireri','spouse','0724143588','','FastCom Cyber','Kiambu','Kikuyu','Cyber',1,'138175',12,20,30000.00,0,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0721725957','2021-04-12 09:27:07'),(870,'Daniel Ndege','Spouse','0724218357','','Digital Intek','Nairobi','Embakasi Central','Cyber',1,'0009',98,20,8000.00,3,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0721405672','2021-04-12 09:48:29'),(871,'Benson Kambo','Son','0706357335','','Lobentec Comps ','Nairobi','Embakasi East','Cyber',1,'001',36,30,6000.00,0,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0722214837','2021-04-12 09:55:55'),(872,'Ian Karanja ','Son','0794565148','Ndirangu','Diverse Logistics','Nairobi','Embakasi Central','Cyber',1,'1721714',12,100,10000.00,4,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0725963896','2021-04-12 10:01:56'),(873,'Samuel Mugweru','Spouse','0721909515','','Olins Chemist','Nairobi','Mathare','Chemist',1,'1421973',6,20,8000.00,2,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0725094324','2021-04-12 10:20:45'),(874,'Judith Mwanga','wife','0723044477','Kevo ','JayBright Tech ','Nairobi','Mathare','Electronics ',1,'1717840',60,200,11000.00,2,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0700030843','2021-04-12 10:49:10'),(875,'John Oyugi','Brother','0712978748','Maxwell','Magical Salon and Cosmetics','Nairobi','Ruaraka','Cyber',1,'001',12,20,11000.00,2,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0700746647','2021-04-12 10:53:24'),(876,'Getrude Sivove','Spouse','0705935272','Peter','Smart Pharm Cyber','Nairobi','Mathare','Cyber/Chemist ',1,'1729749',120,40,15000.00,1,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0720493349','2021-04-12 10:59:46'),(877,'Amos Chege ','xxxx','0725311798','Gladys','Amosa Agencies','Kiambu','Kikuyu','Money Agency',1,'001',24,20,5500.00,1,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0720211490','2021-04-12 11:06:34'),(878,'Agnes Nyokabi','xxxxx','0720930073','','Gates Investments','Kajiado','Kajiado North','Money Agency ',1,'001',120,100,6000.00,1,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0719188193','2021-04-12 11:13:23'),(879,'Rose Nyambura','xxxx','0714739893','Peter','Matant Comm','Kiambu','Kikuyu','Money Agency',1,'1921910',120,50,9000.00,2,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0728166138','2021-04-12 11:18:57'),(880,'Caroline Rotich','Colleague ','0799839753','','Vast Scientific Kenya','Kiambu','Kabete','Supplies',3,'2020/30340035',24,0,7000.00,2,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0791723509','2021-04-12 11:28:35'),(881,'Zawadi Omary','Spouse','0737101101','Victor','Maita Enterprises','Kiambu','Ruiru','Cyber',1,'143861',180,40,20000.00,2,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0721635619','2021-04-12 11:39:43'),(882,'William Andere','Father ','0721590295','','Grizzly Gamers','Kiambu','Ruiru','Cyber ',1,'149316',12,200,8000.00,2,'','',500.00,'0','One Off Payment- Ksh 500.',NULL,NULL,'','M-PESA','','','','0790004770','2021-04-12 11:45:56'),(883,'Benard Kinyanjui ','Uncle','0722484422','Anto','Hudz Entertainment','Kiambu','Juja','Cyber/Movie Shop',1,'001',9,30,6000.00,1,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0798715209','2021-04-12 11:52:21'),(884,'Zachariah Nyoike','Spouse ','0723341366','','Skyz cyber','Nairobi','Embakasi South','Cyber',1,'1173489',12,20,19000.00,1,'','',500.00,'0','One Off Payment- Ksh 500.',NULL,NULL,'','M-PESA','','','','0714084644','2021-04-12 11:59:39'),(889,'Jane Wangeci Wakarima','Spouse','0716423243','Anto','Total Comp Solutions','Kiambu','Kiambaa','cyber',1,'1901901',60,50,10000.00,1,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0720316885','2021-04-13 13:09:13'),(890,'David kahira','colleague ','0708104860','','maxdynamic enterprise ','Nairobi','Westlands','cyber cafe ',1,'1722522',12,50,20000.00,1,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0723843382','2021-04-14 17:38:04'),(891,'David Kahira','colleague ','0708104860','N/A','maxdynamic enterprise ','Nairobi','Westlands','cyber cafe ',1,'1722522',12,50,20000.00,1,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0723843382','2021-04-14 18:02:08'),(892,'Agnes Wanjiku','Mother','0721807761','S-cube','S-CUBE CYBER','Nairobi','Dagoretti South','Internet/Cyber services',1,'BN/2016/430182',48,100,7500.00,0,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0714610602','2021-04-15 19:23:12'),(893,'James muiruri','Employer','0723731858','peter','waison investment','Kiambu','Ruiru','shop and mpesa',1,'058097',60,40,7000.00,1,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0723731858','2021-04-16 10:58:06'),(894,'Judy Kamau','spouse','0725216776','John','Dynamic graphics','Kiambu','Juja','cyber and accounting',1,'1212130',12,50,12000.00,2,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0722217056','2021-04-17 13:11:51'),(895,'Stephen Mwaniki','spouse','0723939640','Wa Ngendo','Ngendo Shop','Kiambu','Thika Town','Shop ',1,'1201260',24,20,5000.00,1,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0711481238','2021-04-21 12:16:58'),(896,'Harris Gitau ','Employee ','0727311288','Richard','Blessed Cyber','Nairobi','Kibra','Cyber',1,'001',72,20,5000.00,1,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0743111747','2021-04-21 12:28:15'),(897,'Elizabeth Kioko','Sister ','0704642474','Patrick ','Main Switch Electrical Repairs ','Nairobi','Makadara','Electronics ',1,'1241210',98,20,3500.00,1,'','',50.00,'0','Partial Payment',NULL,NULL,'','M-PESA','','','','0710221088','2021-04-21 12:33:54');

--
-- 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=151 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'),(150,47,'Embakasi North');

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



