-- Table structure for table `archive_client_2`
--

CREATE TABLE `archive_client_2` (
  `ClientID` int(6) NOT NULL AUTO_INCREMENT,
  `AgentID` int(6) NOT NULL,
  `RentalID` int(6) NOT NULL,
  `client_id` varchar(25) NOT NULL,
  `agent_user_id` int(11) NOT NULL,
  `crb_no` varchar(25) NOT NULL,
  `minit_client_id` int(10) DEFAULT NULL,
  `client_status` varchar(150) NOT NULL,
  `Type` varchar(15) NOT NULL,
  `Status2` varchar(15) NOT NULL DEFAULT '0',
  `Title2` varchar(4) NOT NULL,
  `FirstName2` varchar(100) NOT NULL,
  `MiddleName2` varchar(100) NOT NULL,
  `LastName2` varchar(100) NOT NULL,
  `DOB2` varchar(10) NOT NULL,
  `DriversLicense2` varchar(100) NOT NULL,
  `Gender2` varchar(20) NOT NULL,
  `Marital2` varchar(20) NOT NULL,
  `Children2` int(2) NOT NULL,
  `HomePhone2` varchar(20) NOT NULL,
  `Workphone2` varchar(20) NOT NULL,
  `Mobile2` varchar(20) NOT NULL,
  `Email2` varchar(150) NOT NULL,
  `Address4` varchar(150) NOT NULL,
  `postal_address` varchar(255) NOT NULL,
  `Suburb4` varchar(50) NOT NULL,
  `State2` varchar(3) NOT NULL,
  `Postcode3` varchar(4) NOT NULL,
  `year` int(11) NOT NULL,
  `month` varchar(3) NOT NULL,
  `current_year` varchar(10) NOT NULL DEFAULT '0',
  `current_month` varchar(10) NOT NULL DEFAULT '0',
  `postal_suburb` varchar(150) NOT NULL,
  `postal_state` varchar(50) NOT NULL,
  `postal_postcode` varchar(4) NOT NULL,
  `previous_address` varchar(200) NOT NULL,
  `previous_suburb` varchar(150) NOT NULL,
  `previous_state` varchar(100) NOT NULL,
  `previous_postcode` varchar(10) NOT NULL,
  `date` varchar(25) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL,
  `delete_status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ClientID`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `archive_client_2`
--

INSERT INTO `archive_client_2` VALUES (3,25,59,'20137',48,'',10029,'','Loan','1','Ms','Kylie','Zoe','Boyd','09/12/1973','60961219','Female','Defacto',3,'','','0414655648','kylzlexy@yahoo.com','13 Merrigum Street','','Currimundi','QLD','4551',2013,'','0','0','','','','','','','','','2019-10-12 00:19:27','1579496017',0),(6,25,124,'10089',45,'',7539,'','Loan','1','Mrs','Karamia ','Mia','Folaumoeloa','10/10/1973','Photo ID 012394','Male','Married',4,'','','0406154671','island4me@yahoo.com','86 Flora Street','','Kirrawee','NSW','2232',0,'','0','0','','','','','','','','','2019-10-12 01:18:38','1579493761',0);

--
-- Table structure for table `archive_client_income`
--

CREATE TABLE `archive_client_income` (
  `ClientID` int(6) NOT NULL,
  `RentalID` int(6) NOT NULL,
  `LoanID` int(6) NOT NULL,
  `Fulltime` int(6) NOT NULL,
  `Fulltime2` int(6) NOT NULL,
  `Parttime` int(6) NOT NULL,
  `Partime2` int(6) NOT NULL,
  `Casual` int(6) NOT NULL,
  `Casual2` int(6) NOT NULL,
  `WeeklyIncomeSpare` varchar(35) NOT NULL,
  `WeeklyIncome1` int(6) NOT NULL,
  `WeeklyIncome2` int(6) NOT NULL,
  `Newstart` int(6) NOT NULL,
  `Newstart2` int(6) NOT NULL,
  `SpareBudget2` varchar(35) NOT NULL,
  `Benefits` int(6) NOT NULL,
  `Benefits2` int(6) NOT NULL,
  `MatureAge` int(6) NOT NULL,
  `MatureAge2` int(6) NOT NULL,
  `Sparebudget3` varchar(35) NOT NULL,
  `MatureAgBB1` int(6) NOT NULL,
  `MatureAgeB2` int(6) NOT NULL,
  `Carer` int(6) NOT NULL,
  `Carer2` int(6) NOT NULL,
  `Carer3` int(6) NOT NULL,
  `Carer4` int(6) NOT NULL,
  `Disability` int(6) NOT NULL,
  `Disability2` int(6) NOT NULL,
  `SpareBudget4` varchar(35) NOT NULL,
  `Disability3` int(6) NOT NULL,
  `Disability4` int(6) NOT NULL,
  `Parenting` int(6) NOT NULL,
  `Parenting2` int(6) NOT NULL,
  `LargeFamily` int(6) NOT NULL,
  `LargeFamily2` int(6) NOT NULL,
  `FamilyA` int(6) NOT NULL,
  `FamilyA2` int(6) NOT NULL,
  `FamilyB1` int(6) NOT NULL,
  `FamilyB2` int(6) NOT NULL,
  `SpareBudget5` varchar(35) NOT NULL,
  `FamilyB3` int(6) NOT NULL,
  `FamilyB4` int(6) NOT NULL,
  `RentAssist` int(6) NOT NULL,
  `RentAssist2` int(6) NOT NULL,
  `Pharmacy` int(6) NOT NULL,
  `Pharmacy2` int(6) NOT NULL,
  `Supliment` int(6) NOT NULL,
  `Supliment2` int(6) NOT NULL,
  `SpareBudget6` varchar(35) NOT NULL,
  `Supliment3` int(6) NOT NULL,
  `Supliment4` int(6) NOT NULL,
  `PhoneBudget` int(6) NOT NULL,
  `PhoneBudget2` int(6) NOT NULL,
  `SpareBudget7` varchar(35) NOT NULL,
  `PhoneBudget3` int(6) NOT NULL,
  `PhoneBudget4` int(6) NOT NULL,
  `ChildMaint` int(6) NOT NULL,
  `ChildMaint2` int(6) NOT NULL,
  `Board` int(6) NOT NULL,
  `Board2` int(6) NOT NULL,
  `OtherIncome` varchar(35) NOT NULL,
  `OtherIncomeB` varchar(35) NOT NULL,
  `OtherIncome1` int(6) NOT NULL,
  `OtherIncome2` int(6) NOT NULL,
  `OtherIncomeB1` int(6) NOT NULL,
  `OtherIncomeB2` int(6) NOT NULL,
  PRIMARY KEY (`ClientID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `archive_client_income`
--


--
-- Table structure for table `archive_client_product`
--

CREATE TABLE `archive_client_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `RentalID` int(11) NOT NULL,
  `type` varchar(20) NOT NULL,
  `purpose` varchar(255) NOT NULL,
  `feature` varchar(150) NOT NULL,
  `product_type` varchar(150) NOT NULL,
  `product_purpose` varchar(250) NOT NULL,
  `security` varchar(200) NOT NULL,
  `other_feature` varchar(200) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `delete_status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=160 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `archive_client_product`
--

INSERT INTO `archive_client_product` VALUES (159,691,'Rent','','No upfront fees','Medium Amount credit Contact','Medical','Chattels as listed in Contract','No Upfront Fees','2020-03-06 12:37:20',0);

--
-- Table structure for table `archive_client_refrences`
--

CREATE TABLE `archive_client_refrences` (
  `ClientID` int(6) NOT NULL AUTO_INCREMENT,
  `AgentID` int(6) NOT NULL,
  `Type` varchar(15) NOT NULL,
  `RentalID` int(6) NOT NULL,
  `LoanID` int(6) NOT NULL,
  `reference_number1` varchar(25) NOT NULL,
  `reference_number2` varchar(25) NOT NULL,
  `reference_number3` varchar(25) NOT NULL,
  `Status` int(11) NOT NULL,
  `Refrence_Name1` varchar(15) NOT NULL,
  `Refrence_LastName1` varchar(15) NOT NULL,
  `Refrence_LastName2` varchar(15) NOT NULL,
  `Refrence_LastName3` varchar(15) NOT NULL,
  `Refrence_Relationshion1` varchar(15) NOT NULL,
  `Reference_StreetAddress1` varchar(40) NOT NULL,
  `Refrence_Mobile1` varchar(10) NOT NULL,
  `Refrence_Name2` varchar(15) NOT NULL,
  `Refrence_Relationshion2` varchar(15) NOT NULL,
  `Reference_StreetAddress2` varchar(40) NOT NULL,
  `Refrence_Mobile1_1` varchar(20) NOT NULL,
  `Refrence_Name3` varchar(15) NOT NULL,
  `Refrence_Relationshion3` varchar(15) NOT NULL,
  `Reference_StreetAddress3` varchar(40) NOT NULL,
  `Refrence_Mobile1_2` varchar(10) NOT NULL,
  `delete_status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ClientID`)
) ENGINE=InnoDB AUTO_INCREMENT=633 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `archive_client_refrences`
--

INSERT INTO `archive_client_refrences` VALUES (626,29,'Rent',691,0,'','','',0,'Fff','Fff','Fff','Fff','Ffff','Fff','55','Rfff','Fff','Fff','855','Fff','Fff','Fff','555',0),(632,25,'Loan',724,0,'','','',0,'Sdasdsad','','','','','','','','','','','','','','',0);

--
-- Table structure for table `archive_client_verification_list`
--

CREATE TABLE `archive_client_verification_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `RentalID` int(11) NOT NULL,
  `type` varchar(50) NOT NULL,
  `source_type` varchar(70) NOT NULL,
  `income_source` varchar(50) NOT NULL,
  `loan_payment` varchar(50) NOT NULL,
  `inc_expense` varchar(50) NOT NULL,
  `credit_history` varchar(50) NOT NULL,
  `liabilities` varchar(50) NOT NULL,
  `personal_circum` varchar(50) NOT NULL,
  `foreseable` varchar(50) NOT NULL,
  `other_factor` varchar(50) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `delete_status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `archive_client_verification_list`
--


--
-- Table structure for table `archive_entertainment_client1`
--

CREATE TABLE `archive_entertainment_client1` (
  `entertainment_id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(100) NOT NULL COMMENT 'loan/rent',
  `loan_rent_id` int(11) NOT NULL,
  `xmas_hampera` varchar(200) NOT NULL,
  `pay_tv` varchar(200) NOT NULL,
  `entertainment_gambling` varchar(200) NOT NULL,
  `other_expenses_or_downloads` varchar(200) NOT NULL,
  `delete_status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`entertainment_id`)
) ENGINE=InnoDB AUTO_INCREMENT=571 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `archive_entertainment_client1`
--

INSERT INTO `archive_entertainment_client1` VALUES (473,'Loan',496,'','100','50','',0),(482,'Loan',522,'','','','',0),(488,'Loan',530,'','71','','',0),(496,'Loan',550,'','','','55',0),(498,'Loan',552,'','','150','',0),(501,'Loan',555,'','28','30','',0),(502,'Loan',556,'','12','40','',0),(516,'Loan',580,'','','40','',0),(524,'Loan',598,'11','','','',0),(525,'Loan',599,'','','60','',0),(527,'Loan',601,'14','11','','',0),(529,'Loan',603,'22','15','20','',0),(531,'Loan',607,'','','','',0),(533,'Loan',609,'10','','','',0),(539,'Loan',618,'12','','','',0),(542,'Loan',622,'','','100','',0),(544,'Loan',625,'','','100','',0),(545,'Loan',626,'','','100','',0),(546,'Loan',627,'','','','',0),(565,'Loan',649,'','14','','',0),(568,'Loan',652,'','','150','',0),(570,'Loan',654,'','','','',0);

--
-- Table structure for table `archive_entertainment_client2`
--

CREATE TABLE `archive_entertainment_client2` (
  `entertainment_id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(150) NOT NULL COMMENT 'loan/rent',
  `loan_rent_id` int(11) NOT NULL,
  `xmas_hampera` varchar(200) NOT NULL,
  `pay_tv` varchar(200) NOT NULL,
  `entertainment_gambling` varchar(200) NOT NULL,
  `other_expenses_or_downloads` varchar(200) NOT NULL,
  `delete_status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`entertainment_id`)
) ENGINE=InnoDB AUTO_INCREMENT=550 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `archive_entertainment_client2`
--

INSERT INTO `archive_entertainment_client2` VALUES (471,'Loan',496,'','','','',0),(480,'Loan',522,'','','','',0),(484,'Loan',530,'','','','',0),(491,'Loan',550,'','','','',0),(493,'Loan',552,'','','','',0),(495,'Loan',556,'','','','',0),(508,'Loan',580,'','','','',0),(515,'Loan',598,'','','','',0),(517,'Loan',601,'','','','',0),(518,'Loan',603,'','','','',0),(520,'Loan',607,'','','','',0),(527,'Loan',618,'','','','',0),(530,'Loan',622,'','','','',0),(532,'Loan',625,'','','','',0),(533,'Loan',626,'','','','',0),(534,'Loan',627,'','','','',0),(548,'Loan',652,'','','','',0),(549,'Loan',654,'','','','',0);

--
-- Table structure for table `archive_loan_calculator`
--

CREATE TABLE `archive_loan_calculator` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `RentalID` int(11) NOT NULL,
  `Type` varchar(6) NOT NULL,
  `Description` varchar(100) NOT NULL,
  `InterestRate` varchar(200) NOT NULL,
  `Amount` varchar(150) NOT NULL,
  `Duration` varchar(11) NOT NULL,
  `StartDate` varchar(15) NOT NULL,
  `FirstDate` varchar(15) NOT NULL,
  `Daily_Payment_fees` varchar(150) NOT NULL,
  `Up_front_fees` varchar(110) NOT NULL,
  `Payment_frequency` varchar(20) NOT NULL,
  `Percentage_rate` varchar(11) NOT NULL,
  `CompanyNumber` varchar(100) NOT NULL,
  `Transcode` varchar(11) NOT NULL,
  `Monthly_fees` varchar(11) NOT NULL,
  `final_total` varchar(150) NOT NULL,
  `AgentID` int(15) NOT NULL,
  `delete_status` int(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `archive_loan_calculator`
--


--
-- Table structure for table `archive_notes`
--

CREATE TABLE `archive_notes` (
  `ClientID` int(6) NOT NULL AUTO_INCREMENT,
  `AgentID` int(6) NOT NULL,
  `RentalID` int(6) NOT NULL,
  `Type` varchar(15) NOT NULL,
  `Status` varchar(15) NOT NULL,
  `Notes` text NOT NULL,
  `note_type` varchar(150) NOT NULL COMMENT 'Client/Mortgage/Loan/Rent',
  `future_finance` varchar(20) NOT NULL,
  `credit_history` varchar(20) NOT NULL,
  `bankrupt` varchar(20) NOT NULL,
  `assets_value` varchar(20) NOT NULL,
  `information` varchar(20) NOT NULL,
  `flexible_feature` varchar(20) NOT NULL,
  `additional_risk` varchar(20) NOT NULL,
  `MessageFromHeadOfice1` text NOT NULL,
  `delete_status` int(11) NOT NULL DEFAULT '0',
  `timestamp` varchar(50) NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`ClientID`)
) ENGINE=InnoDB AUTO_INCREMENT=1080 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `archive_notes`
--

INSERT INTO `archive_notes` VALUES (567,29,559,'Rent','','<p>\n ghfhfhfhffhfhf</p>\n<p>\n  </p>\n<p>\n h</p>\n<p>\n fgh</p>\n<p>\n fgh</p>\n<p>\n fh</p>\n','','','','','','','','','fgdfdfgfd',0,'1576061820',53),(733,25,649,'Loan','1','<p>\n	Existing AS client since 19/05/1995. Client is wanting to re-open account to borrow $1600. He is still currently working full time and owns his home.</p>\n','Client','No','No','No','1.00','Yes','Yes','Yes','',0,'1581469636',48),(734,25,649,'Loan','0','','Client','No','No','No','1.00','Yes','Yes','Yes','',0,'1581469691',48),(742,25,649,'Loan','1','','Client','No','No','No','1.00','Yes','Yes','Yes','',0,'1581566833',45),(743,25,649,'Loan','1','Is there any foreseeable changes financially in the near future? - No','Client','No','No','No','1.00','Yes','Yes','Yes','',0,'1581566833',45),(744,25,649,'Loan','1','Do you have any adverse credit history? - No','Client','No','No','No','1.00','Yes','Yes','Yes','',0,'1581566833',45),(745,25,649,'Loan','1','Have you ever been bankrupt? - No','Client','No','No','No','1.00','Yes','Yes','Yes','',0,'1581566833',45),(746,25,649,'Loan','1','Values of assets? - $1.00','Client','No','No','No','1.00','Yes','Yes','Yes','',0,'1581566833',45),(747,25,649,'Loan','1','Can you confirm that all the information provided is true and correct? - Yes','Client','No','No','No','1.00','Yes','Yes','Yes','',0,'1581566833',45),(748,25,649,'Loan','1','Are you satisfied with credit product feature and flexibility that is offered? - Yes','Client','No','No','No','1.00','Yes','Yes','Yes','',0,'1581566833',45),(749,25,649,'Loan','1','Are you satisfied with the cost of the features and any additional risk? - Yes','Client','No','No','No','1.00','Yes','Yes','Yes','',0,'1581566833',45),(750,25,652,'Loan','1','<p>\n	<b>CONTRACT DATE 05/07/2018 C/L $1500</b></p>\n<p>\n	Existing AS client for at least 8 years - household expenses have been halved as his wife also works and contributes to the household expenses.</p>\n','Client','No','No','No','3000','Yes','Yes','Yes','',0,'1581913681',48),(753,25,652,'Loan','1','<p>\n Client is wanting to increase his current limit by $500 to assist with household expenses. Client has been back to work for 3 weeks since brakiing his ankle 7 weeks ago. He had to purchase a car to get around; the loans for the car has been paid in full confirmation has been received. Client pays more than the minimum repayments.</p>\n','Client','No','No','No','3000','Yes','Yes','Yes','',0,'1581914013',45),(754,25,652,'Loan','1','Is there any foreseeable changes financially in the near future? - No','Client','No','No','No','3000','Yes','Yes','Yes','',0,'1581914013',45),(755,25,652,'Loan','1','Do you have any adverse credit history? - No','Client','No','No','No','3000','Yes','Yes','Yes','',0,'1581914013',45),(756,25,652,'Loan','1','Have you ever been bankrupt? - No','Client','No','No','No','3000','Yes','Yes','Yes','',0,'1581914013',45),(757,25,652,'Loan','1','Values of assets? - $3000','Client','No','No','No','3000','Yes','Yes','Yes','',0,'1581914013',45),(758,25,652,'Loan','1','Can you confirm that all the information provided is true and correct? - Yes','Client','No','No','No','3000','Yes','Yes','Yes','',0,'1581914013',45),(759,25,652,'Loan','1','Are you satisfied with credit product feature and flexibility that is offered? - Yes','Client','No','No','No','3000','Yes','Yes','Yes','',0,'1581914013',45),(760,25,652,'Loan','1','Are you satisfied with the cost of the features and any additional risk? - Yes','Client','No','No','No','3000','Yes','Yes','Yes','',0,'1581914013',45),(770,25,654,'Loan','1','<p>\n	<strong>Contract Date: 09/02/2018 C/L $1500</strong></p>\n<p>\n	Client has requested an increase - he has supplied bank statements, payslip and current ID. Expenses have been halved as wife works fulltime. He has 3 Daughters who pay board to his wife and also the internet and phone. CRB number is 521 163277. He gets paid f/n therefore would like to maintain the repayments the same.</p>\n','Client','No','No','No','1','Yes','Yes','Yes','',0,'1582002785',48),(771,25,654,'Loan','1','<p>\n	Client has requested a $400 increase for household expenses. Daughters pay board into wifes account, rent is payed out of wifes account aswell.&nbsp;</p>\n','Client','No','No','No','1','Yes','Yes','Yes','',0,'1582004665',48),(887,25,654,'Loan','1','','Client','No','No','No','1','Yes','Yes','Yes','',0,'1582506245',48),(888,25,654,'Loan','1','Is there any foreseeable changes financially in the near future? - No','Client','No','No','No','1','Yes','Yes','Yes','',0,'1582506245',48),(889,25,654,'Loan','1','Do you have any adverse credit history? - No','Client','No','No','No','1','Yes','Yes','Yes','',0,'1582506245',48),(890,25,654,'Loan','1','Have you ever been bankrupt? - No','Client','No','No','No','1','Yes','Yes','Yes','',0,'1582506245',48),(891,25,654,'Loan','1','Values of assets? - $1','Client','No','No','No','1','Yes','Yes','Yes','',0,'1582506245',48),(892,25,654,'Loan','1','Can you confirm that all the information provided is true and correct? - Yes','Client','No','No','No','1','Yes','Yes','Yes','',0,'1582506245',48),(893,25,654,'Loan','1','Are you satisfied with credit product feature and flexibility that is offered? - Yes','Client','No','No','No','1','Yes','Yes','Yes','',0,'1582506245',48),(894,25,654,'Loan','1','Are you satisfied with the cost of the features and any additional risk? - Yes','Client','No','No','No','1','Yes','Yes','Yes','',0,'1582506245',48),(925,29,691,'Rent','1','','Client','No','Yes','No','534543','No','Yes','No','',0,'1582632606',53),(929,25,722,'Loan','1','<p>\n fgfdgdgfdgfdg</p>\n','Client','No','Yes','No','33','Yes','No','No','',0,'1583392984',54),(930,25,722,'Loan','1','Is there any foreseeable changes financially in the near future? - No','Client','No','Yes','No','33','Yes','No','No','',0,'1583392984',54),(931,25,722,'Loan','1','Do you have any adverse credit history? - Yes','Client','No','Yes','No','33','Yes','No','No','',0,'1583392984',54),(932,25,722,'Loan','1','Have you ever been bankrupt? - No','Client','No','Yes','No','33','Yes','No','No','',0,'1583392984',54),(933,25,722,'Loan','1','Values of assets? - $33','Client','No','Yes','No','33','Yes','No','No','',0,'1583392984',54),(934,25,722,'Loan','1','Can you confirm that all the information provided is true and correct? - Yes','Client','No','Yes','No','33','Yes','No','No','',0,'1583392984',54),(935,25,722,'Loan','1','Are you satisfied with credit product feature and flexibility that is offered? - No','Client','No','Yes','No','33','Yes','No','No','',0,'1583392984',54),(936,25,722,'Loan','1','Are you satisfied with the cost of the features and any additional risk? - No','Client','No','Yes','No','33','Yes','No','No','',0,'1583392984',54),(945,25,724,'Loan','1','Are you satisfied with the cost of the features and any additional risk? - No','Client','No','Yes','No','33','Yes','No','No','',0,'1583392984',54),(946,25,724,'Loan','1','Are you satisfied with credit product feature and flexibility that is offered? - No','Client','No','Yes','No','33','Yes','No','No','',0,'1583392984',54),(947,25,724,'Loan','1','Can you confirm that all the information provided is true and correct? - Yes','Client','No','Yes','No','33','Yes','No','No','',0,'1583392984',54),(948,25,724,'Loan','1','Values of assets? - $33','Client','No','Yes','No','33','Yes','No','No','',0,'1583392984',54),(949,25,724,'Loan','1','Have you ever been bankrupt? - No','Client','No','Yes','No','33','Yes','No','No','',0,'1583392984',54),(950,25,724,'Loan','1','Do you have any adverse credit history? - Yes','Client','No','Yes','No','33','Yes','No','No','',0,'1583392984',54),(951,25,724,'Loan','1','Is there any foreseeable changes financially in the near future? - No','Client','No','Yes','No','33','Yes','No','No','',0,'1583392984',54),(952,25,724,'Loan','1','<p>\n fgfdgdgfdgfdg</p>\n','Client','No','Yes','No','33','Yes','No','No','',0,'1583392984',54),(1014,29,691,'Rent','1','<p>\n	gdfdgfdgfdgfdgfd</p>\n','Client','No','Yes','No','534543','No','Yes','No','',0,'1583498148',53),(1015,29,691,'Rent','1','Is there any foreseeable changes financially in the near future? - No','Client','No','Yes','No','534543','No','Yes','No','',0,'1583498148',53),(1016,29,691,'Rent','1','Do you have any adverse credit history? - Yes','Client','No','Yes','No','534543','No','Yes','No','',0,'1583498148',53),(1017,29,691,'Rent','1','Have you ever been bankrupt? - No','Client','No','Yes','No','534543','No','Yes','No','',0,'1583498148',53),(1018,29,691,'Rent','1','Values of assets? - $534543','Client','No','Yes','No','534543','No','Yes','No','',0,'1583498149',53),(1019,29,691,'Rent','1','Can you confirm that all the information provided is true and correct? - No','Client','No','Yes','No','534543','No','Yes','No','',0,'1583498149',53),(1020,29,691,'Rent','1','Are you satisfied with credit product feature and flexibility that is offered? - Yes','Client','No','Yes','No','534543','No','Yes','No','',0,'1583498149',53),(1021,29,691,'Rent','1','Are you satisfied with the cost of the features and any additional risk? - No','Client','No','Yes','No','534543','No','Yes','No','',0,'1583498149',53),(1071,29,751,'Rent','1','<p>\n hjghjhj</p>\n','Client','No','No','No','344243','No','No','No','',0,'1583903916',51),(1072,29,751,'Rent','1','Do you have any adverse credit history? - No','Client','No','No','No','344243','No','No','No','',0,'1583903916',51),(1073,29,751,'Rent','1','','Client','No','No','No','344243','No','No','No','',0,'1583929253',53),(1074,29,751,'Rent','1','Is there any foreseeable changes financially in the near future? - No','Client','No','No','No','344243','No','No','No','',0,'1583929253',53),(1075,29,751,'Rent','1','Have you ever been bankrupt? - No','Client','No','No','No','344243','No','No','No','',0,'1583929253',53),(1076,29,751,'Rent','1','Values of assets? - $344243','Client','No','No','No','344243','No','No','No','',0,'1583929253',53),(1077,29,751,'Rent','1','Can you confirm that all the information provided is true and correct? - No','Client','No','No','No','344243','No','No','No','',0,'1583929253',53),(1078,29,751,'Rent','1','Are you satisfied with credit product feature and flexibility that is offered? - No','Client','No','No','No','344243','No','No','No','',0,'1583929253',53),(1079,29,751,'Rent','1','Are you satisfied with the cost of the features and any additional risk? - No','Client','No','No','No','344243','No','No','No','',0,'1583929253',53);

--
-- Table structure for table `archive_other_expenses_client1`
--

CREATE TABLE `archive_other_expenses_client1` (
  `other_exp_id` int(11) NOT NULL AUTO_INCREMENT,
  `loan_rent_id` int(11) NOT NULL,
  `type` varchar(150) NOT NULL COMMENT 'loan/rent',
  `private_medical` varchar(255) NOT NULL,
  `medical_expenses` varchar(200) NOT NULL,
  `house_contents_insaurance` varchar(200) NOT NULL,
  `funeral_life_insaurance` varchar(200) NOT NULL,
  `vehicle_insaurance` varchar(200) NOT NULL,
  `vehicle_registration` varchar(200) NOT NULL,
  `petrol` varchar(200) NOT NULL,
  `tyres_repaires_maintenance` varchar(200) NOT NULL,
  `bus_train_taxis` varchar(200) NOT NULL,
  `delete_status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`other_exp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=574 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `archive_other_expenses_client1`
--

INSERT INTO `archive_other_expenses_client1` VALUES (473,496,'Loan','27','','','11','','490','50','20','',0),(482,522,'Loan','','','','','','','','','40',0),(488,530,'Loan','','','','','','350','30','10','',0),(497,550,'Loan','59','','','','','','','','70',0),(499,552,'Loan','','','','15','120','550','60','20','',0),(501,555,'Loan','','','','','','450','50','20','',0),(502,556,'Loan','','','','','','375','60','20','',0),(517,580,'Loan','','','','','','','','','10',0),(525,598,'Loan','','','','','113','450','30','25','',0),(526,599,'Loan','','','','13','110','380','50','20','',0),(528,601,'Loan','','','','','98','368','50','10','',0),(531,603,'Loan','','','','','','','','','50',0),(533,607,'Loan','','','','','','495','40','20','',0),(535,609,'Loan','','','','','','375','40','10','',0),(541,618,'Loan','','','162','200','69','500','60','20','',0),(545,622,'Loan','','','','','','','25','','',0),(547,625,'Loan','','','','','','','','','100',0),(548,626,'Loan','','','','','','','','','100',0),(549,627,'Loan','26','','','','','','','','40',0),(568,649,'Loan','','','37','','160','','50','','50',0),(571,652,'Loan','','','','','','400','40','20','',0),(573,654,'Loan','','','','','115','650','60','10','40',0);

--
-- Table structure for table `archive_other_expenses_client2`
--

CREATE TABLE `archive_other_expenses_client2` (
  `other_exp_id` int(11) NOT NULL AUTO_INCREMENT,
  `loan_rent_id` int(11) NOT NULL,
  `type` varchar(150) NOT NULL COMMENT 'loan/rent',
  `private_medical` varchar(200) NOT NULL,
  `medical_expenses` varchar(200) NOT NULL,
  `house_contents_insaurance` varchar(200) NOT NULL,
  `funeral_life_insaurance` varchar(200) NOT NULL,
  `vehicle_insaurance` varchar(200) NOT NULL,
  `vehicle_registration` varchar(200) NOT NULL,
  `petrol` varchar(200) NOT NULL,
  `tyres_repaires_maintenance` varchar(200) NOT NULL,
  `bus_train_taxis` varchar(200) NOT NULL,
  `delete_status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`other_exp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=540 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `archive_other_expenses_client2`
--

INSERT INTO `archive_other_expenses_client2` VALUES (461,496,'Loan','','','','','','','','','',0),(470,522,'Loan','','','','','','','','','',0),(474,530,'Loan','','','','','','','','','',0),(481,550,'Loan','','','','','','','','','',0),(483,552,'Loan','','','','','','','','','',0),(485,556,'Loan','','','','','','','','','',0),(498,580,'Loan','','','','','','','','','',0),(505,598,'Loan','','','','','','','','','',0),(507,601,'Loan','','','','','','','','','',0),(508,603,'Loan','','','','','','','','','',0),(510,607,'Loan','','','','','','','','','',0),(517,618,'Loan','','','','','','','','','',0),(520,622,'Loan','','','','','','','','','',0),(522,625,'Loan','','','','','','','','','',0),(523,626,'Loan','','','','','','','','','',0),(524,627,'Loan','','','','','','','','','',0),(538,652,'Loan','','','','','','','','','',0),(539,654,'Loan','','','','','','','','','',0);

--
-- Table structure for table `archive_other_expenses_incomes`
--

CREATE TABLE `archive_other_expenses_incomes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `loan_rent_id` int(11) NOT NULL,
  `type` varchar(255) NOT NULL COMMENT 'loan/rent',
  `type_expense_incomes` varchar(255) NOT NULL COMMENT 'income/benefits/expenses/personal_expenses/children/entertainment/others',
  `name` varchar(255) NOT NULL,
  `client1` varchar(255) NOT NULL,
  `client2` varchar(255) NOT NULL,
  `delete_status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1610 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `archive_other_expenses_incomes`
--

INSERT INTO `archive_other_expenses_incomes` VALUES (1503,530,'Loan','BUDGET Expenses','QEF','85','',0),(1504,530,'Loan','BUDGET Expenses','CBA Loan','100','',0),(1522,550,'Loan','OTHER EXPENSES','Apia','130','',0),(1523,550,'Loan','PERSONAL EXPENSES','NSW MA Union','15','',0),(1526,552,'Loan','OTHER EXPENSES','Other','20','',0),(1540,550,'Loan','BUDGET Expenses','Overdraft ANZ','115','',0),(1541,550,'Loan','BUDGET Expenses','Other','10','',1),(1593,601,'Loan','PERSONAL EXPENSES','Other','30','0',0),(1596,609,'Loan','BUDGET Expenses','St George Loan','197','',0),(1601,618,'Loan','CHILDREN','Pet','13','',0),(1602,618,'Loan','OTHER EXPENSES','Other','40','',0),(1607,625,'Loan','OTHER EXPENSES','Other','12','',0),(1608,626,'Loan','OTHER EXPENSES','Other','12','',0),(1609,627,'Loan','PERSONAL EXPENSES','Other','30','',0);

--
-- Table structure for table `archive_personal_expenses_client1`
--

CREATE TABLE `archive_personal_expenses_client1` (
  `personal_expense_id` int(11) NOT NULL AUTO_INCREMENT,
  `loan_rent_id` int(11) NOT NULL,
  `type` varchar(150) NOT NULL COMMENT 'loan/rent',
  `clothes` varchar(200) NOT NULL,
  `tobacco` varchar(200) NOT NULL,
  `drinks` varchar(200) NOT NULL,
  `delete_status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`personal_expense_id`)
) ENGINE=InnoDB AUTO_INCREMENT=573 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `archive_personal_expenses_client1`
--

INSERT INTO `archive_personal_expenses_client1` VALUES (473,496,'Loan','20','','',0),(482,522,'Loan','20','','10',0),(488,530,'Loan','10','','',0),(497,550,'Loan','','','',0),(499,552,'Loan','20','','40',0),(501,555,'Loan','40','','10',0),(502,556,'Loan','20','','',0),(517,580,'Loan','20','','30',0),(526,598,'Loan','15','35','',0),(527,599,'Loan','20','','',0),(529,601,'Loan','20','','',0),(532,603,'Loan','30','','50',0),(534,607,'Loan','15','','',0),(536,609,'Loan','10','','',0),(542,618,'Loan','40','','',0),(545,622,'Loan','','','',0),(548,625,'Loan','','','',0),(549,626,'Loan','','','',0),(550,627,'Loan','30','','',0),(568,649,'Loan','15','','20',0),(570,652,'Loan','10','','',0),(572,654,'Loan','20','','',0);

--
-- Table structure for table `archive_personal_expenses_client2`
--

CREATE TABLE `archive_personal_expenses_client2` (
  `personal_expens` int(11) NOT NULL AUTO_INCREMENT,
  `loan_rent_id` int(11) NOT NULL,
  `type` varchar(150) NOT NULL COMMENT 'loan/rent',
  `clothes` varchar(200) NOT NULL,
  `tobacco` varchar(200) NOT NULL,
  `drinks` varchar(200) NOT NULL,
  `delete_status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`personal_expens`)
) ENGINE=InnoDB AUTO_INCREMENT=550 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `archive_personal_expenses_client2`
--

INSERT INTO `archive_personal_expenses_client2` VALUES (471,496,'Loan','','','',0),(480,522,'Loan','','','',0),(484,530,'Loan','','','',0),(491,550,'Loan','','','',0),(493,552,'Loan','','','',0),(495,556,'Loan','','','',0),(508,580,'Loan','','','',0),(515,598,'Loan','','','',0),(517,601,'Loan','','','',0),(518,603,'Loan','','','',0),(520,607,'Loan','','','',0),(527,618,'Loan','','','',0),(530,622,'Loan','','','',0),(532,625,'Loan','','','',0),(533,626,'Loan','','','',0),(534,627,'Loan','','','',0),(548,652,'Loan','','','',0),(549,654,'Loan','','','',0);

--
-- Table structure for table `archive_privacy_details`
--

CREATE TABLE `archive_privacy_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rent_loan_id` int(11) NOT NULL,
  `type` varchar(50) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1' COMMENT '1=>accepted , 0=>denied',
  `timestamp` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `archive_privacy_details`
--


--
-- Table structure for table `archive_rental_goods`
--

CREATE TABLE `archive_rental_goods` (
  `ClientID` int(6) NOT NULL AUTO_INCREMENT,
  `RentalID` varchar(35) NOT NULL,
  `AgentID` int(15) NOT NULL,
  `Chattel1` varchar(50) NOT NULL,
  `Chattel2` varchar(50) NOT NULL,
  `Chattel3` varchar(50) NOT NULL,
  `Chattel4` varchar(50) NOT NULL,
  `Chattel5` varchar(50) NOT NULL,
  `Chattel6` varchar(50) NOT NULL,
  `Model1` varchar(40) NOT NULL,
  `Model2` varchar(40) NOT NULL,
  `Model3` varchar(40) NOT NULL,
  `Model4` varchar(40) NOT NULL,
  `Model5` varchar(40) NOT NULL,
  `Model6` varchar(40) NOT NULL,
  `ID1` varchar(45) NOT NULL,
  `ID2` varchar(45) NOT NULL,
  `ID3` varchar(45) NOT NULL,
  `ID4` varchar(45) NOT NULL,
  `ID5` varchar(45) NOT NULL,
  `ID6` varchar(45) NOT NULL,
  `Value1` varchar(50) NOT NULL,
  `Value2` varchar(50) NOT NULL,
  `Value3` varchar(50) NOT NULL,
  `Value4` varchar(50) NOT NULL,
  `Value5` varchar(50) NOT NULL,
  `Value6` varchar(50) NOT NULL,
  `Status` varchar(15) NOT NULL,
  `Weekly_Payment` varchar(50) NOT NULL,
  `rental1` varchar(50) NOT NULL,
  `rental2` varchar(50) NOT NULL,
  `rental3` varchar(50) NOT NULL,
  `rental4` varchar(50) NOT NULL,
  `rental5` varchar(50) NOT NULL,
  `rental6` varchar(50) NOT NULL,
  `Term` varchar(10) NOT NULL,
  `weekly_rent` varchar(50) NOT NULL,
  `delete_status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ClientID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `archive_rental_goods`
--


--
-- Table structure for table `archive_rental_goods_vehicles`
--

CREATE TABLE `archive_rental_goods_vehicles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `RentalID` int(11) NOT NULL,
  `AgentID` int(11) NOT NULL,
  `stock_number` varchar(150) NOT NULL,
  `description` varchar(255) NOT NULL,
  `CurrentStatus` varchar(50) NOT NULL,
  `CurrentValue` varchar(50) NOT NULL,
  `ItemCategory` varchar(50) NOT NULL,
  `PurchasedDate` varchar(50) NOT NULL,
  `PurchasedFrom` varchar(100) NOT NULL,
  `PurchasedPrice` varchar(50) NOT NULL,
  `RRPValue` varchar(50) NOT NULL,
  `Type` varchar(50) NOT NULL,
  `Accessories` varchar(100) NOT NULL,
  `BodyType` varchar(100) NOT NULL,
  `BondRequired` varchar(100) NOT NULL,
  `Colour` varchar(50) NOT NULL,
  `EngineNo` varchar(100) NOT NULL,
  `FurtherDesc` varchar(100) NOT NULL,
  `Hours` varchar(50) NOT NULL,
  `IMEINo` varchar(50) NOT NULL,
  `InvoiceNo` varchar(50) NOT NULL,
  `Kilometres` varchar(100) NOT NULL,
  `Location` varchar(100) NOT NULL,
  `Make` varchar(100) NOT NULL,
  `Model` varchar(100) NOT NULL,
  `ProductCode` varchar(100) NOT NULL,
  `RegistrationPlateNo` varchar(100) NOT NULL,
  `RegistrationState` varchar(100) NOT NULL,
  `SerialNo` varchar(100) NOT NULL,
  `SKUNo` varchar(100) NOT NULL,
  `VINNo` varchar(100) NOT NULL,
  `Year` varchar(20) NOT NULL,
  `term` varchar(20) NOT NULL,
  `weekly_payment` varchar(50) NOT NULL,
  `weekly_rent` varchar(50) NOT NULL,
  `rental_price` varchar(50) NOT NULL,
  `delete_status` int(11) NOT NULL DEFAULT '0' COMMENT '0=>active, 1=>inactive',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `archive_rental_goods_vehicles`
--


--
-- Table structure for table `archive_rental_goods_vehicles_old`
--

CREATE TABLE `archive_rental_goods_vehicles_old` (
  `ClientID` int(11) NOT NULL AUTO_INCREMENT,
  `RentalID` int(11) NOT NULL,
  `AgentID` int(11) NOT NULL,
  `type` varchar(25) NOT NULL DEFAULT 'Rent',
  `description` varchar(255) NOT NULL,
  `entry_type` varchar(20) NOT NULL COMMENT 'goods or vehicles',
  `stock_number` varchar(200) NOT NULL,
  `serial_number` varchar(150) NOT NULL,
  `product_type` varchar(150) NOT NULL,
  `make` varchar(150) NOT NULL,
  `vehicle_year` varchar(20) NOT NULL,
  `model` varchar(150) NOT NULL,
  `color` varchar(150) NOT NULL,
  `engine_no` varchar(150) NOT NULL,
  `vin_no` varchar(150) NOT NULL,
  `further_description` varchar(255) NOT NULL,
  `purchased_from` varchar(255) NOT NULL,
  `goods_purchase_price` varchar(50) NOT NULL,
  `invoice_number` varchar(255) NOT NULL,
  `vehicle_sell_price` varchar(50) NOT NULL,
  `current_value` varchar(200) NOT NULL,
  `repair_costs` varchar(200) NOT NULL,
  `purchase_date` varchar(100) NOT NULL,
  `current_status` varchar(100) NOT NULL,
  `term` varchar(50) NOT NULL,
  `weekly_payment` varchar(30) NOT NULL,
  `weekly_rent` varchar(30) NOT NULL,
  `price` varchar(30) NOT NULL,
  `rental_price` varchar(30) NOT NULL,
  `delete_status` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ClientID`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `archive_rental_goods_vehicles_old`
--

INSERT INTO `archive_rental_goods_vehicles_old` VALUES (16,691,29,'Rent','Fflf Fkfkf','goods','Z7Q1582632431229','','','Fflf','','Fkfkf','Fffk','','','Flfl','Fl','55','','','55','','','','26','55','5.14','','133.6',0,'2020-02-25 12:10:06');

--
-- Table structure for table `archive_total_budget_income`
--

CREATE TABLE `archive_total_budget_income` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rent_loan_id` int(11) NOT NULL,
  `type` varchar(20) NOT NULL,
  `total_income` varchar(20) NOT NULL,
  `total_expenses` varchar(20) NOT NULL,
  `total_balance` varchar(20) NOT NULL,
  `available` varchar(20) NOT NULL,
  `delete_status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=527 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `archive_total_budget_income`
--

INSERT INTO `archive_total_budget_income` VALUES (397,496,'Loan','865','701.73','163.27','108.85',0),(413,522,'Loan','988.5','612.13','376.37','250.91',0),(418,530,'Loan','877.00','718.97','158.03','105.35',0),(428,550,'Loan','1710','1102.58','607.42','404.94',0),(430,552,'Loan','1781','1306.58','474.42','316.28',0),(432,555,'Loan','939','655.45','283.55','189.04',0),(433,556,'Loan','1273','1051.26','221.74','147.83',0),(435,559,'Rent','51','2.86','48.14','32.1',0),(451,580,'Loan','602','298.92','303.08','202.05',0),(461,598,'Loan','1242','693.54','548.46','365.64',0),(462,599,'Loan','1804','399.83','1404.17','936.11',0),(463,601,'Loan','959','798.65','160.35','106.9',0),(466,603,'Loan','776','465.49','310.51','207.01',0),(468,607,'Loan','922','706.89','215.11','143.41',0),(470,609,'Loan','1165','972.11','192.89','128.59',0),(476,618,'Loan','2193','1796.27','396.73','264.49',0),(479,622,'Loan','531.5','298.54','232.96','155.31',0),(481,625,'Loan','900','721','179','119.33',0),(482,626,'Loan','900','721','179','119.33',0),(483,627,'Loan','897','744.31','152.69','101.79',0),(502,649,'Loan','736','314.53','421.47','280.98',0),(506,652,'Loan','1019','756.09','262.91','175.27',0),(508,654,'Loan','1129','753.02','375.98','250.65',0),(515,722,'Loan','102','7.4','94.6','63.07',0),(518,691,'Rent','12','7.40','4.60','3.07',0),(526,751,'Rent','42.00','7.40','34.60','23.07',0);

--
-- Table structure for table `archive_warning_details`
--

CREATE TABLE `archive_warning_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rent_loan_id` int(11) NOT NULL,
  `type` varchar(50) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1' COMMENT '1=>accepted , 0=>denied',
  `timestamp` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `archive_warning_details`
--


--
-- Table structure for table `bank_account_details`
--

CREATE TABLE `bank_account_details` (
  `bank_id` int(11) NOT NULL AUTO_INCREMENT,
  `loan_rent_id` int(6) NOT NULL,
  `contract_date` varchar(20) NOT NULL,
  `Day` varchar(15) NOT NULL,
  `payment_date` varchar(20) NOT NULL,
  `amount` varchar(13) NOT NULL,
  `Bank` varchar(25) NOT NULL,
  `Branch` varchar(20) NOT NULL,
  `AccountName` varchar(30) NOT NULL,
  `BSB` varchar(7) NOT NULL,
  `AccountNumber` varchar(20) NOT NULL,
  `payment_frequency` varchar(50) NOT NULL,
  `payment_method` varchar(1500) NOT NULL,
  `type` varchar(100) NOT NULL COMMENT 'loan/rental',
  `delete_status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`bank_id`),
  UNIQUE KEY `loan_rent_id` (`loan_rent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=784 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bank_account_details`
--

INSERT INTO `bank_account_details` VALUES (1,1,'13/08/2019','Monday','16/09/2019','6000','NAB','','Rodney Neville Arthur','802489','15242 0258','Monthly','Direct Debit','Loan',0),(2,2,'','','','','','','','','','Frequency','','Loan',0),(3,3,'29/07/2019','Wednesday','05/08/2019','4598.02','Commonwealth','','Iva M Cawa','062176','10374971','Fortnight','Direct Credit','Loan',0),(4,4,'','','','','Commonwealth','','Michael T Babbage','062517','10203490','Fortnight','Direct Credit','Loan',0),(5,5,'12/06/2019','Wednesday','19/06/2019','699.5','Commonwealth','','Michelle Back','062259','10140341','Fortnight','Direct Debit','Loan',0),(6,6,'','','','','','','','','','Frequency','','Loan',0),(7,7,'03/09/2019','Thursday','19/09/2019','1500','HSBC','','Raymond A Chambers','342011','800976412','Fortnight','Direct Debit','Loan',0),(8,8,'27/03/2018','Monday','03/04/2018','','Commonwealth','','Mohammed A Baiti','062-314','010 008 046','Monthly','Direct Credit','Loan',0),(9,9,'','','','','','','','','','Frequency','','Loan',0),(10,10,'06/11/2018','Monday','13/11/2018','2000','ANZ','','Peter W Chan','012-110','596329308','Monthly','Direct Credit','Loan',0),(11,11,'26/08/2019','Wednesday','02/09/2019','3356.56','Westpac','','Emma E Balancio','732005','000 821 100','Fortnight','Direct Credit','Loan',0),(12,12,'21/06/2019','Thursday','28/06/2019','5999.88','ANZ','','Deborah J Clark','012341','463 313 935','Weekly','Direct Credit','Loan',0),(13,13,'11/05/2018','Wednesday','18/05/2018','999.29','CBA','','L Baldonado','062438','10007382','Fortnight','Direct Credit','Loan',0),(14,14,'','','','','','','','','','Frequency','','Loan',0),(15,15,'24/05/2019','Thursday','31/05/2019','1799.15','St George','','David Clarke','112-879','028 815 519','Fortnight','Direct Credit','Loan',0),(16,16,'03/05/2018','Monday','10/05/2018','4406.46','Commonwealth','','Lawrence A Bamblett','062235','10002776','Fortnight','Direct Credit','Loan',0),(17,17,'14/05/2018','Friday','21/05/2018','5000','St George','','Mr A R Bangura','112879','57440736','Weekly','Direct Credit','Loan',0),(18,18,'22/02/2018','Monday','01/03/2018','999.46','Greater Union Building So','','Kylie J Conrad','637000','781 225 762','Fortnight','Direct Debit','Loan',0),(19,19,'','','','','CBA','','Mr J Cruz','062424','10105528','Monthly','Direct Credit','Loan',0),(20,20,'18/01/2019','Monday','25/01/2019','1000','St George','','S Barisic','112879','455226059','Fortnight','Direct Debit','Loan',0),(21,21,'','','','','Unity Bank','','Anthony Cook','882-000','000 048 150','Fortnight','Direct Credit','Loan',0),(22,22,'07/05/2019','Thursday','14/05/2019','4500','Bendigo','','Vinnie J Barker','633000','131 206 609','Weekly','Direct Debit','Loan',0),(23,23,'','','','','Commonwealth','','William Dansey','062-890','010 120 903','Monthly','Direct Credit','Loan',0),(24,24,'','','','','ANZ','','Mereani Cooke','012030','222572768','Fortnight','','Loan',0),(25,25,'20/09/2019','Monday','27/09/2019','4000','St George','','Josephine Barratt','112879','449643081','Monthly','Direct Credit','Loan',0),(26,26,'','','','','','','','','','Frequency','','Loan',0),(27,27,'06/04/2018','Monday','13/04/2018','2999.73','ANZ','','Tania P Cousins','012-233','195805836','Fortnight','Direct Credit','Loan',0),(28,28,'27/03/2018','Wednesday','03/04/2018','1499.3','Westpac','','James P Barrett','732-004','651162','Weekly','Direct Debit','Loan',0),(29,29,'20/03/2018','Wednesday','27/03/2018','900','Bendigo Bank','','Michael A Cox','633000','153558762','Fortnight','Direct Credit','Loan',0),(30,30,'03/06/2019','Thursday','13/06/2019','6608.12','Westpac','','Joel D Bason','732006','683440','Fortnight','Direct Credit','Loan',0),(31,31,'16/09/2019','Tuesday','23/09/2019','12600','Commonwealth','','Beverley A Bates','064474','010 438 604','Weekly','Direct Debit','Loan',0),(32,32,'','','','','Commonwealth','','William Dansey','062-890','010 120 903','Monthly','Direct Credit','Loan',0),(33,33,'23/08/2019','Thursday','30/08/2019','3098.62','CBA','','Brett T Cramp','62290','10017186','Weekly','Direct Debit','Loan',0),(34,34,'11/12/2018','Monday','18/12/2018','699.05','CBA','','Graham Bates','062016','10389990','Fortnight','Direct Debit','Loan',0),(35,35,'','','','','WBC','','D Danganan','062006','11688031','Monthly','Direct Credit','Loan',0),(36,36,'05/02/2018','Monday','12/02/2018','884.71','ANZ','','Mark Bates','012559','464145144','Fortnight','Direct Credit','Loan',0),(37,37,'13/04/2018','Friday','04/05/2018','958.42','St George','','Vasemaca T Daunivuku','112879','38466893','Weekly','Direct Credit','Loan',0),(38,38,'04/06/2019','Tuesday','11/06/2019','1299.08','Commonwealth','','Peter Bates','062517','10504090','Fortnight','Direct Credit','Loan',0),(39,39,'23/04/2019','Thursday','30/04/2019','1432.04','Credit Union Australia','','Neil B Davidson','814-282','10096149','Weekly','Direct Debit','Loan',0),(40,40,'29/08/2018','Monday','05/09/2018','847.01','ANZ','','S Bates','012556','504245124','Fortnight','Direct Debit','Loan',0),(41,41,'17/04/2018','Monday','24/04/2018','999.69','St George','','Genevieve De La Roche Du Ronze','112879','057 381 019','Fortnight','Direct Credit','Loan',0),(42,42,'24/01/2018','Monday','31/01/2018','575','CBA','','Fredrick Backer','062693','12715162','Fortnight','Direct Debit','Loan',0),(43,43,'','','','','Commonwealth','','Jordan Edwards','062-198','000 699 433','Fortnight','Direct Credit','Loan',0),(44,44,'','','','','St George Bank','','Debra E Beedle','112879','154 636 167','Monthly','Direct Credit','Loan',0),(45,45,'','Friday','','','St George','','Michelle Dean','112879','148852138','Fortnight','Direct Debit','Loan',0),(46,46,'04/05/2018','Monday','11/05/2018','798.74','Westpac','','Tracy Beehag','732-258','000 539 998','Weekly','Direct Credit','Loan',0),(47,47,'','','','','','','','','','Frequency','','Loan',0),(48,48,'11/07/2018','Monday','18/07/2018','799.3','Sydney Credit Union','','Naznim Begum','802084','149029','Weekly','Direct Debit','Loan',0),(49,49,'17/06/2019','Friday','02/07/2019','5000','St George','','Sylvia DePedro','112-879','482 026 253','Fortnight','Direct Credit','Loan',0),(50,50,'','','','','Maritime Credit Union','','802884','27717','Darren D Bell','Fortnight','Direct Credit','Loan',0),(51,51,'06/06/2018','Wednesday','14/06/2018','2549.05','CBA','','B L Dinham','62320','10536047','Fortnight','Direct Credit','Loan',0),(52,52,'','','','','WBC','','D Hale','732076','511804','Monthly','Direct Credit','Loan',0),(53,53,'22/02/2018','Monday','01/03/2018','1999.32','National Australia','','Joshua A Bell','082133','195161962','Weekly','Direct Credit','Loan',0),(54,54,'','','29/01/2019','','WBC','','V E Doelle','732032','596 893','Fortnight','Direct Debit','Loan',0),(55,55,'','','','','Commonwealth Bank','','Karen Bell','062-177','010 061 147','Fortnight','Direct Debit','Loan',0),(56,56,'13/06/2019','Monday','20/07/2019','5000','St George','','Sainmeri S Donnelly','112-879','458 643 796','Monthly','Direct Debit','Loan',0),(57,57,'09/03/2018','Monday','16/03/2018','1499.71','Commonwealth','','Melissa A Bell','062-121','656777','Monthly','Direct Credit','Loan',0),(58,58,'','','','','','','','','','Frequency','','Loan',0),(59,59,'28/05/2019','Monday','06/06/2019','3600','Commonwealth','','Robin double','064447','010611612','Weekly','Direct Debit','Loan',0),(60,60,'05/03/2018','Wednesday','12/03/2018','3004.71','Commonwealth','','Anie G Benitez','062107','11183478','Weekly','Direct Debit','Loan',0),(61,61,'24/01/2019','Monday','31/01/2019','2500','Commonwealth','','Patrick J Benitez','062424','10401861','Weekly','Direct Debit','Loan',0),(62,62,'','Tuesday','','','National Australia','','Josefa Nakui','082121','541 965 112','Weekly','Direct Credit','Loan',0),(63,63,'16/01/2018','Monday','23/01/2018','863.35','Credit Union','','Frank A Bennett','803-161','000 527 992','Monthly','Direct Credit','Loan',0),(64,64,'','','','','Westpac','','Craig J Douglas','032-249','000 200 346','Fortnight','Direct Credit','Loan',0),(65,65,'20/05/2019','Thursday','27/05/2019','1251.97','ING','','Mr M Bernarte','923100','68241993','Fortnight','Direct Credit','Loan',0),(66,66,'01/10/2019','Monday','08/10/2019','2182.44','Commonwealth','','Anthony A Dries','062317','010 316 286','Monthly','Direct Credit','Loan',0),(67,67,'04/09/2019','Friday','12/04/2019','4999.09','Westpac','','Sailosi T Biusara','732076','677281','Fortnight','Direct Credit','Loan',0),(68,68,'','','','','St George','','Phillip J Peek','112-998','099 116 256','Fortnight','Direct Credit','Loan',0),(69,69,'09/04/2018','Thursday','26/04/2018','2999.98','CBA','','Jean-Michel A Duchenne','062424','10755731','Weekly','Direct Credit','Loan',0),(70,70,'','','','','St George','','Christine Black','112-879','411 605 629','Fortnight','Direct Debit','Loan',0),(71,71,'25/06/2018','Monday','02/07/2018','500','Westpac','','John T Black','732072','686930','Fortnight','Direct Credit','Loan',0),(72,72,'28/02/2019','Wednesday','07/03/2019','4000','Commonwealth','','Darrin E Duncan','062574','10035779','Fortnight','Direct Credit','Loan',0),(73,73,'','','','','','','','','','Frequency','','Loan',0),(74,74,'01/02/2019','Monday','08/02/2019','1500','Credit Union Australia','','Rosario Boado','814282','010 175 273','Monthly','Direct Debit','Loan',0),(75,75,'','','','','Westpac','','Byran Dunlop','732-545','000 596 514','Monthly','Direct Credit','Loan',0),(76,76,'','','','','','','','','','Frequency','','Loan',0),(77,77,'03/06/2019','Monday','10/06/2019','4453.98','ANZ','','Cynthia Bordador','012468','561475081','Fortnight','Direct Credit','Loan',0),(78,78,'24/09/2019','Monday','01/10/2019','4999.11','Commonwealth','','John Durant','062-735','1034 6611','Monthly','Direct Credit','Loan',0),(79,79,'03/09/2019','Thursday','10/09/2019','4399.78','Westpac','','Graham D Bradley','732088','601145','Weekly','Direct Credit','Loan',0),(80,80,'19/02/2018','','26/02/2018','2032.28','Community First Credit Un','','Ferdinand Eastwood','804050','10108136','Fortnight','Direct Credit','Loan',0),(81,81,'28/03/2019','Friday','04/04/2019','2000','ANZ','','William J Bradshaw','012268','538 693 216','Weekly','Direct Credit','Loan',0),(82,82,'','','','','ANZ','','Paul R Edmunds','012301','559914436','Weekly','Direct Credit','Loan',0),(83,83,'08/03/2018','Wednesday','15/03/2018','1599.32','Commonwealth','','Andrew J Brenner','062155','10671371','Weekly','Direct Credit','Loan',0),(84,84,'','','','','','','','','','Frequency','','Loan',0),(85,85,'11/09/2019','Friday','18/09/2019','4999.87','St George','','Christopher J Edwards','112879','440 334 776','Weekly','Direct Debit','Loan',0),(86,86,'21/02/2018','Monday','28/02/2018','141.63','St George','','James Budge','112879','55390093','Fortnight','Direct Debit','Loan',0),(87,87,'13/06/2019','Friday','20/06/2019','3490','National Australia','','Gavin M Bunney','084223','438 938 781','Weekly','Direct Debit','Loan',0),(88,88,'28/02/2018','Thursday','07/03/2018','1999.4','CBA','','Karen L Edwards','062323','010167570','Fortnight','Direct Debit','Loan',0),(89,89,'','','','','National Australia','','Manolito Bunyi','082-067','435505315','Monthly','Direct Credit','Loan',0),(90,90,'','','','','','','','','','Frequency','','Loan',0),(91,91,'','','','','Westpac','','Daniel Eldabbagh','732-109','000 797 766','Fortnight','Direct Credit','Loan',0),(92,92,'02/10/2019','Monday','09/10/2019','4082.25','ANZ','','Ricky Burton','012336','500 237 944','Monthly','Direct Credit','Loan',0),(93,93,'08/06/2018','','15/06/2018','499.7','NAB','','Rowena Escano','082024','180494609','Fortnight','Direct Credit','Loan',0),(94,94,'','','','','National Australia','','Christina J Byrne','083-332','196 870 365','Fortnight','Direct Credit','Loan',0),(95,95,'','','','','','','','','','Frequency','','Loan',0),(96,96,'16/03/2018','Monday','23/03/2018','1499.55','National Australia','','Nicole R Byrne','082-332','175207791','Monthly','Direct Credit','Loan',0),(97,98,'24/06/2019','Thursday','30/07/2019','3000','CBA','','EEE Systems','112879','442415692','Monthly','Direct Credit','Loan',0),(98,99,'30/11/2018','Monday','07/12/2018','2999.01','Commonwealth','','Peter C Byrne','062308','28012443','Monthly','Direct Credit','Loan',0),(99,100,'04/06/2018','Monday','11/06/2018','2988.58','Westpac','','Gerardo V Cada','732003','627029','Monthly','Direct Credit','Loan',0),(100,101,'27/02/2018','','06/03/2018','4000','Syndey Credit Union','','Michael J Farrell','802-084','85715','Monthly','Direct Credit','Loan',0),(101,102,'01/04/2019','Tuesday','08/04/2019','3500','CBA','','Mr  Mrs Cameron','64793','10147638','Weekly','Direct Debit','Loan',0),(102,103,'06/01/2020','Thursday','26/02/2020','4963.89','Westpac','','Peter P Cannes','732-267','000 649 398','Monthly','Direct Credit','Loan',0),(103,104,'','','','','Unity Bank','','Jeffrey W Cantley','882000','36884','Monthly','Direct Credit','Loan',0),(104,105,'07/03/2018','','14/03/2018','1499.93','Westpac','','Joseph Ferrara','732-158','508967','Fortnight','Direct Credit','Loan',0),(105,106,'','','','','St George','','Analiza G Capati','112-879','054 346 533','Monthly','Direct Credit','Loan',0),(106,107,'','','','','','','','','','Frequency','','Loan',0),(107,108,'09/02/2018','Wednesday','16/02/2018','1999.9','Credit Union Australia CU','','Kevin Cappe','804050','30923982','Fortnight','Direct Credit','Loan',0),(108,109,'','Tuesday','','','National Australia','','David C Finch','082212','509540472','Fortnight','Direct Credit','Loan',0),(109,110,'','','','','St George','','Michael J Carter','112879','432940741','Monthly','Direct Credit','Loan',0),(110,111,'13/03/2019','','20/03/2019','1194.04','Westpac','','Maskoti Fine','732069','701554','Fortnight','Direct Credit','Loan',0),(111,112,'','Wednesday','','','ANZ','','Gerardo Zabat','012233','376294879','Fortnight','Direct Credit','Loan',0),(112,113,'','','22/03/2019','','Reliance Bank','','Steven Gerard','882000','000 003 550','Fortnight','Direct Credit','Loan',0),(113,114,'','','','','Maritime Credit Union','','Mathew Gifford','882000','47626','Fortnight','Direct Credit','Loan',0),(114,115,'30/01/2019','Wednesday','06/02/2019','1999.08','ANZ','','Diane D Baber','012881','216859797','Fortnight','Direct Credit','Loan',0),(115,116,'','','','','St George','','Blanca Gonzalez','112879','164 889 281','Weekly','Direct Credit','Loan',0),(116,117,'06/05/2019','Thursday','13/05/2019','3499.61','Westpac','','Peter W Fitzwalter','732067','000 779 825','Weekly','Direct Debit','Loan',0),(117,118,'','Friday','09/08/2019','','Heritage','','Garry D Graham','638010','146 81641','Weekly','Direct Debit','Loan',0),(118,119,'09/04/2018','','16/04/2018','604.04','Commonwealth','','James Flynn','062-102','10082951','Monthly','Direct Credit','Loan',0),(119,120,'15/03/2018','Wednesday','22/03/2018','499.42','ANZ','','Kay L Cunneen','012257','380035095','Fortnight','Direct Credit','Loan',0),(120,121,'15/02/2018','Wednesday','22/02/2018','383.98','Commonwealth','','Unaloto Folau','062317','10642209','Fortnight','Direct Debit','Loan',0),(121,122,'03/02/2020','Friday','14/02/2020','400','Bank Of Queensland','','Michael N Green','124053','020 434 142','Weekly','Direct Debit','Loan',0),(122,123,'','Friday','17/05/2019','','ANZ','','GM  SL Green','014257','410 140 137','Weekly','Direct Debit','Loan',0),(123,124,'02/02/2018','Thursday','15/02/2018','1650','St George','','K Folaumoeloa','112879','019482812','Fortnight','Direct Credit','Loan',0),(124,125,'','','','','Endeavour Mutual Bank','','Stephen Heart','802-184','000 075 567','Monthly','Direct Credit','Loan',0),(125,126,'','Thursday','','','Commonwealth Bank','','Patricia A Gregory','062202','11115806','Weekly','Direct Debit','Loan',0),(126,127,'','Wednesday','17/04/2019','','Bendigo','','Adama Forna','633000','125 615 278','Fortnight','Direct Debit','Loan',0),(127,128,'','','','','ANZ','','Tisa Haangana','012347','278783687','Monthly','Direct Credit','Loan',0),(128,129,'','','','','ANZ','','Peter M Kerr','012-071','183 983 985','Monthly','Direct Credit','Loan',0),(129,130,'','Sunday','08/08/2019','','Westpac','','Polonitina Fosita','732382','546677','Fortnight','Direct Debit','Loan',0),(130,131,'','','','','Westpac','','John R Hadden','732271','000 672 566','Fortnight','Direct Debit','Loan',0),(131,132,'','','15/03/2019','','Commonwealth','','Carlos Marti','064145','010 285 712','Monthly','Direct Debit','Loan',0),(132,133,'','','','','Westpac','','Fineata Hala','732-390','000 527 513','Fortnight','Direct Credit','Loan',0),(133,134,'05/03/2018','','12/03/2018','1199.17','Endeavour Mutual Bank','','Kelly L Hardy','611000','103654','Fortnight','Direct Debit','Loan',0),(134,135,'','','','','St George','','Belinda R Abel','112879','125982360','Monthly','Direct Debit','Loan',0),(135,136,'','','','','St George','','Alexander Fortheringham','112-879','041 771 426','Monthly','Direct Credit','Loan',0),(136,137,'05/03/2018','Friday','16/03/2018','1199.17','National Australia','','Mike J Hardy','082309','574604807','Fortnight','Direct Debit','Loan',0),(137,138,'','','','','','','','','','Monthly','Direct Credit','Loan',0),(138,139,'','','','','St George','','John Adamson','112879','113173696','Fortnight','Direct Credit','Loan',0),(139,140,'','','','','Commonwealth','','Feofaaki Tuulakitau','062458','10138576','Fortnight','Direct Credit','Loan',0),(140,141,'','','','','Commonwealth','','Teresita Heisele-Brown','062111','010 232 101','Monthly','Direct Credit','Loan',0),(141,142,'20/03/2018','Thursday','27/03/2018','1500','Maritime Credit Union','','Mark Franich','802884','31471','Monthly','Direct Debit','Loan',0),(142,143,'10/12/2018','Monday','17/12/2018','2999.94','ING','','Christina Zafra','923-100','032 063 713','Monthly','Direct Credit','Loan',0),(143,144,'','Thursday','','','CBA','','Carole Helman','062557','28000489','Fortnight','Direct Debit','Loan',0),(144,145,'','','','','Westpac','','Steven Hickey','732-059','000 611 096','Fortnight','Direct Debit','Loan',0),(145,146,'','Thursday','','','ING Direct','','Stephen M Alborough','923100','33601572','Fortnight','Direct Credit','Loan',0),(146,147,'','','19/02/1900','','CBA','','L Hobby','62150','28013661','Fortnight','Direct Debit','Loan',0),(147,148,'15/05/2018','Monday','18/06/2018','2999.83','Commonwealth','','Kenneth J Alchin','062121','10663352','Monthly','Direct Credit','Loan',0),(148,149,'27/02/2018','Wednesday','08/03/2018','1999.73','Westpac','','Peter J Honeysett','732340','502238','Fortnight','Direct Debit','Loan',0),(149,150,'20/04/2018','Monday','18/05/2018','2000','Commonwealth Bank','','Robert J Ali','062171','28000015','Weekly','Direct Credit','Loan',0),(150,151,'','Thursday','01/11/2018','','National Australia','','Samantha P Hooker','082133','173 708 808','Weekly','Direct Debit','Loan',0),(151,152,'','Wednesday','','','Westpac','','Alexander Fricska','732067','651645','Fortnight','Direct Credit','Loan',0),(152,153,'30/04/2018','Monday','07/06/2018','1999.99','Sydney Credit Union','','Steven B Anderson','802084','49175','Weekly','Direct Credit','Loan',0),(153,154,'','Monday','02/09/2019','','Commonwealth','','Lesley M Hoppit','062-421','010 460 704','Fortnight','Direct Debit','Loan',0),(154,155,'','','','','St George','','Peter W Houghton','112879','483261221','Monthly','Direct Credit','Loan',0),(155,156,'07/02/2018','Wednesday','14/02/2018','3018.87','Westpac','','Andrew Anronikou','732157','533108','Fortnight','Direct Credit','Loan',0),(156,157,'','Wednesday','','','ANZ','','Robert J Fuller','012881','382692056','Fortnight','Direct Credit','Loan',0),(157,158,'09/02/2018','Thursday','16/02/2018','3000.71','Westpac','','Brian K Houlcroft','732170','506040','Weekly','Direct Credit','Loan',0),(158,159,'05/03/2018','','06/04/2018','1000','ANZ','','Richard J Anslow','012-364','493 834 379','Monthly','Direct Credit','Loan',0),(159,160,'21/02/2018','Wednesday','01/03/2018','1954.51','Commonwealth','','John N Funaki','062223','10790216','Fortnight','Direct Credit','Loan',0),(160,161,'','','15/10/2018','','','','','','','Fortnight','Direct Credit','Loan',0),(161,162,'09/03/2018','','16/03/2018','4399.22','CBA','','Gino Galasso','063000','11297609','Fortnight','Direct Credit','Loan',0),(162,163,'','','','','Westpac','','Trevor Ingram','732-151','000 510 706','Fortnight','Direct Debit','Loan',0),(163,164,'14/02/2018','Monday','21/02/2018','1999.54','Westpac','','Victor Anthony','732167','624433','Fortnight','Direct Debit','Loan',0),(164,165,'','Tuesday','','','Westpac','','Mario Isidro','732065','681322','Fortnight','Direct Credit','Loan',0),(165,166,'','','','','CBA','','Jason Gale','062186','10224687','Monthly','Direct Credit','Loan',0),(166,167,'23/08/2018','Monday','30/08/2018','900','Commonwealth','','Demian B Iturra','062198','10611491','Weekly','Direct Credit','Loan',0),(167,168,'29/07/2019','Monday','05/08/2019','2500','CBA','','L aRGENT','062546','10492428','Weekly','Direct Debit','Loan',0),(168,169,'22/02/2018','Wednesday','02/03/2018','2499.15','Westpac','','Odilon V Galvan','732088','685473','Fortnight','Direct Debit','Loan',0),(169,170,'','','02/01/2018','','ANZ','','K Jackson-Chandler','12341','466492924','Fortnight','Direct Debit','Loan',0),(170,171,'','Friday','15/03/2019','','Commonwealth Bank','','Jacqueline A Johansson','064204','010 108 664','Weekly','Direct Debit','Loan',0),(171,172,'','Wednesday','','','Westpac','','Romeo Leonor','732260','624761','Fortnight','','Loan',0),(172,173,'','Wednesday','','','Commonwealth','','Tunggul D Aritonang','062439','10043233','Fortnight','Direct Credit','Loan',0),(173,174,'','Friday','','','St George','','Julie Johnson','112879','414489951','Fortnight','Direct Debit','Loan',0),(174,175,'','','','','Commonwealth','','Mark D Leslie','062-222','010 211 440','Monthly','Direct Credit','Loan',0),(175,176,'','Thursday','19/09/2019','','Commonwealth','','Alexander Judge','062229','1003 1192','Fortnight','Direct Debit','Loan',0),(176,177,'','Friday','','','CBA','','Christopher Storm Lette','062181','10974246','Weekly','Direct Debit','Loan',0),(177,178,'','','','','First Option Bank','','Mr C J Kearns','802876','95030','Monthly','Direct Debit','Loan',0),(178,179,'','Thursday','11/10/2019','','Commonwealth Bank','','Wayne W Kendrick','062693','120005654','Weekly','Direct Debit','Loan',0),(179,180,'','','','','CBA','','Stacey Nailer','062017','10108922','Fortnight','Direct Credit','Loan',0),(180,181,'','','','','Westpac','','Mark W Kenny','732024','747532','Monthly','Direct Credit','Loan',0),(181,182,'','','','','CBA','','Humayin Khan','062014','626957','Fortnight','Direct Debit','Loan',0),(182,183,'','','','','Commonwealth','','Rachel N Sisa','062-235','679969','Fortnight','Direct Credit','Loan',0),(183,184,'','Wednesday','','','National Australia','','Alan R King','82155','823790074','Fortnight','Direct Credit','Loan',0),(184,185,'24/05/2019','','30/05/2019','1299.2','CBA','','Patricia King','062234','10108397','Fortnight','Direct Debit','Loan',0),(185,186,'','Thursday','11/10/2018','','CBA','','Michele Zanellato','062020','10232329','Weekly','Direct Credit','Loan',0),(186,187,'16/03/2018','Thursday','03/05/2018','2219.21','Westpac','','Lionel kingham','732024','520282','Fortnight','Direct Credit','Loan',0),(187,188,'','','','','WBC','','Unaisi L Navila','732-065','612685','Fortnight','Direct Debit','Loan',0),(188,189,'','Wednesday','','','Bankwest','','Arieta N Kinivuai','302968','163579','Fortnight','Direct Credit','Loan',0),(189,190,'','','','','St George','','Teresita Nerona','112879','450 958 961','Fortnight','Direct Credit','Loan',0),(190,191,'','Friday','','','Commonwealth','','Michael J Knock','062223','10396649','Fortnight','Direct Credit','Loan',0),(191,192,'','','','','Commonwealth','','Samantha A Knock','062-223','000 729 922','Fortnight','Direct Credit','Loan',0),(192,193,'','','21/12/2018','','CBA','','Winston Newbond','62334','10950735','Monthly','Direct Credit','Loan',0),(193,194,'','Thursday','04/04/2019','','Westpac','','Bernard Konadu','732165','000 508 463','Weekly','Direct Debit','Loan',0),(194,195,'','','','','National Australia','','Michael A Newcombe','082-057','553 718 311','Monthly','Direct Credit','Loan',0),(195,196,'','','','','St George','','Grace A Koroiwara','112879','437658622','Fortnight','Direct Credit','Loan',0),(196,197,'','','','','St George Bank','','Harris Nicolaou','112879','410819887','Monthly','Direct Credit','Loan',0),(197,198,'','Friday','','','WBC','','Wayne Kouka','732694','623045','Weekly','Direct Debit','Loan',0),(198,199,'','','','','St George','','Craig Levy','112-879','67141844','Fortnight','Direct Debit','Loan',0),(199,200,'','Monday','02/09/2019','','First Option','','Arthur Kriticos','8028796','000 096 670','Monthly','Direct Credit','Loan',0),(200,201,'','','13/12/2018','','WBC','','Julie Nicoll','732059','588340','Fortnight','Direct Credit','Loan',0),(201,202,'','','','','Commonwealth','','Vijay Kumar','062-692','024 026 068','Monthly','Direct Credit','Loan',0),(202,203,'14/03/2018','Thursday','26/03/2018','3199.97','Westpac','','Muamai Levy','032065','198843','Fortnight','Direct Credit','Loan',0),(203,204,'','','','','St George','','Taraivosa Lagi','112879','68040092','Monthly','Direct Credit','Loan',0),(204,205,'','Tuesday','','','St George Bank','','David J Northey','112879','032 095 841','Fortnight','Direct Debit','Loan',0),(205,206,'','','','','ANZ','','Brett G Liddell','012432','516425325','Fortnight','Direct Credit','Loan',0),(206,207,'','','','','','','','','','Frequency','','Loan',0),(207,208,'18/03/2019','Wednesday','28/03/2018','2437.16','ANZ','','Mr T Lillie','012257','529772502','Weekly','Direct Debit','Loan',0),(208,209,'04/07/2018','Wednesday','20/07/2018','3000','National Australia','','Lorna Langford-Wilson','082916','140853371','Fortnight','Direct Debit','Loan',0),(209,210,'','','23/07/2018','','WBC','','Kevin Ovington','732717','533887','Monthly','Direct Credit','Loan',0),(210,211,'','','','','ANZ','','Alise Laws','12209','493218576','Fortnight','Direct Debit','Loan',0),(211,212,'','','','','Westpac','','Sa Lima','732-076','504006','Frequency','Direct Credit','Loan',0),(212,213,'20/12/2018','Thursday','28/12/2018','1399.38','Bank Of Queensland','','Sharon OBrien','124-001','020 439 110','Fortnight','Direct Debit','Loan',0),(213,214,'','Wednesday','','','Westpac','','Elena T Lealamanua','732035','567158','Fortnight','Direct Credit','Loan',0),(214,215,'','','','','Westpac','','Joan ONains','732-153','000 579 619','Fortnight','Direct Credit','Loan',0),(215,216,'','','','','Commonwealth','','Russell R Legaspi','062-190','010 419 039','Fortnight','Direct Credit','Loan',0),(216,217,'','','','','Unity Bank','','Andrew M Lemair','882-000','100 014 290','Fortnight','Direct Credit','Loan',0),(217,218,'','','','','Westpac','','Joan ONains','732-153','000 579 619','Fortnight','Direct Credit','Loan',0),(218,219,'','Friday','05/10/2018','','Westpac','','Brentnall J Rudduck','732059','000 569 748','Fortnight','Direct Debit','Loan',0),(219,220,'','','','','Commonwealth','','Wendy Ryan','062439','10104796','Fortnight','Direct Credit','Loan',0),(220,221,'28/02/2019','Thursday','18/03/2019','3000','Commonwealth','','Abs Saadi','062335','010060940','Monthly','Direct Debit','Loan',0),(221,222,'','','','','Westpac','','Tony Pace','732292','509549','Monthly','Direct Credit','Loan',0),(222,223,'','','','','Qantas Credit Union','','John Said','704865','002 161 087','Monthly','Direct Credit','Loan',0),(223,224,'','','','','Commonwealth Bank','','Ernesto Samonte','062471','10011020','Fortnight','Direct Credit','Loan',0),(224,225,'03/06/2019','','10/06/2019','3999.84','St George','','Nancy T Samonte','112879','456996168','Fortnight','Direct Credit','Loan',0),(225,226,'','','','','','','','','','Frequency','','Loan',0),(226,227,'','','','','Commonwealth','','George Saseve','062-111','010 631 946','Fortnight','Direct Credit','Loan',0),(227,228,'','','','','CBA','','Brian Schofield','062528','10461408','Fortnight','Direct Debit','Loan',0),(228,229,'21/06/2018','','28/06/2018','1699.97','Police Bank','','Dianne Paine','815000','40176','Fortnight','Direct Debit','Loan',0),(229,230,'','','','','CBA','','N Psellors','062016','28026362','Fortnight','Direct Credit','Loan',0),(230,231,'25/07/2019','','01/08/2019','4999.54','ANZ','','Mere B Sereinagate','012-405','509919836','Fortnight','Direct Credit','Loan',0),(231,232,'','Wednesday','','','Sydney Credit Union','','Bruce C Pardey','802084','61929','Weekly','','Loan',0),(232,233,'','','28/08/2019','','NAB','','H Sesay','082250','238069358','Monthly','Direct Credit','Loan',0),(233,234,'','Monday','16/09/2019','','ANZ','','Gary Parker','012262','5440 99029','Fortnight','Direct Debit','Loan',0),(234,235,'','','01/01/1970','','Westpac','','Dennis N Sewell','732061','787840','Monthly','Direct Credit','Loan',0),(235,236,'','','21/12/2018','','CBA','','Gavin Sheeran','062005','10712231','Fortnight','Direct Credit','Loan',0),(236,237,'08/02/2018','Thursday','15/02/2018','1673.96','ING','','Clark Short','923100','031385405','Monthly','Direct Credit','Loan',0),(237,238,'','','','','St George','','Iosefa Wright','112879f','441353987','Monthly','Direct Credit','Loan',0),(238,239,'','','','','ANZ','','Raymund J Shortill','012293','580 658 078','Monthly','Direct Credit','Loan',0),(239,240,'','Thursday','20/12/2018','','Sydney Credit Union','','Malcolm Parker','802084','133704','Fortnight','Direct Debit','Loan',0),(240,241,'16/02/2018','Thursday','23/02/2018','3999.53','Commonwealth','','Ivan A Simon','062259','28012372','Fortnight','Direct Credit','Loan',0),(241,242,'','','','','Commonwealth','','Stephen R Payne','066-192','010 235 800','Monthly','Direct Credit','Loan',0),(242,243,'','','','','St George','','Francesca Singca','112879','026 621 121','Monthly','Direct Credit','Loan',0),(243,244,'','','16/01/2019','','Sydney Credit Union','','Zane Sioneholo','802084','79123','Fortnight','Direct Credit','Loan',0),(244,245,'','Friday','','','Police Bank','','Pauline K Pearce','815-000','94876','Fortnight','Direct Debit','Loan',0),(245,246,'','','','','Metro Credit Union','','Severo Sisa','802-372','000 406 650','Monthly','Direct Credit','Loan',0),(246,247,'','','','','ANZ','','Roger Sison','012301','537223802','Monthly','Direct Credit','Loan',0),(247,248,'','','','','CBA','','Lesley Pearson','062177','10075872','Fortnight','Direct Debit','Loan',0),(248,249,'01/08/2019','Thursday','08/08/2019','2000','St George','','Vasiti R Sivaro','112-879','106 619 688','Fortnight','Direct Debit','Loan',0),(249,250,'','Thursday','','','Qantas Credit Union','','Julie Woodward','704865','59539','Fortnight','Direct Credit','Loan',0),(250,251,'','','19/11/2018','','ANZ','','Romano Pedroche','012402','5549035','Monthly','Direct Credit','Loan',0),(251,252,'','Friday','','','St George Bank','','Jason Skinner','112-879','003 757 631','Fortnight','Direct Credit','Loan',0),(252,253,'','Friday','28/12/2018','','Commonwealth','','Brett A Skomba','062177','010 037 649','Fortnight','Direct Debit','Loan',0),(253,254,'','','','','St George','','Edward R Peslak','112-879','114 921 221','Monthly','Direct Credit','Loan',0),(254,255,'','','','','Commonwealth','','Bradley S Smith','062736','10278302','Weekly','Direct Credit','Loan',0),(255,256,'02/04/2019','Thursday','09/04/2019','5490.92','Bendigo','','Stephen J Smith','633-100','120059860','Monthly','Direct Credit','Loan',0),(256,257,'','','18/09/2019','','Community First Credit Un','','Michelle G Phillips','512170','737607','Monthly','Direct Credit','Loan',0),(257,258,'','','','','','','','','','Frequency','','Loan',0),(258,259,'26/02/2018','Wednesday','06/03/2018','1000','GMC Mutual Bank','','Norman J Snowden','659000','77994','Fortnight','Direct Credit','Loan',0),(259,260,'','Friday','01/01/1970','','CBA','','Mr B Woods','062250','10307607','Fortnight','Direct Debit','Loan',0),(260,261,'02/05/2018','','09/05/2018','1999.33','CBA','','Patrick J Player','062004','10062681','Monthly','Direct Credit','Loan',0),(261,262,'11/06/2019','Monday','18/06/2019','948.19','GMC Mutual Bank','','Paul F Sobb','659-000','9590','Monthly','Direct Credit','Loan',0),(262,263,'','','','','IMB','','George Polyzos','641-800','200 582 385','Fortnight','Direct Credit','Loan',0),(263,264,'','','','','National Australia','','Blake A Sparre','082053','666 315 017','Monthly','Direct Credit','Loan',0),(264,265,'','','','','Westpac','','Peter R Wilson','732-060','792437','Monthly','Direct Credit','Loan',0),(265,266,'','','','','St George','','Jan Speer','112879','124606910','Fortnight','Direct Credit','Loan',0),(266,267,'','','','','Bendigo Bank','','Adrian G Lindo','633000','151 711 165','Monthly','Direct Credit','Loan',0),(267,268,'','','13/12/2018','','ANZ','','012 257','1837587','Leah Potter','Fortnight','Direct Credit','Loan',0),(268,269,'','Thursday','','','CBA','','Chirnsinte A Spowart','062259','10349065','Fortnight','Direct Debit','Loan',0),(269,270,'','Wednesday','','','ANZ','','Merycel A Llanza','012226','212526581','Fortnight','Direct Credit','Loan',0),(270,271,'','Friday','01/03/2019','','Westpac','','Deborah L Stephens','732151','000 630 046','Fortnight','Direct Debit','Loan',0),(271,272,'','Monday','','','Westpac','','Anthony M Lobo','732231','553028','Fortnight','Direct Credit','Loan',0),(272,273,'','Thursday','04/04/2019','','Commonwealth','','Watson Poulivaati','062116','010 074 269','Weekly','Direct Debit','Loan',0),(273,274,'10/09/2019','Monday','16/09/2019','1000','Westpac','','Eileen Stinson','732-258','000 526 273','Fortnight','Direct Debit','Loan',0),(274,275,'','','','','Commonwealth','','Alister C Longstaff','062-204','010 446 691','Monthly','Direct Credit','Loan',0),(275,276,'','','','','St George','','Epeli D Sukanaivalu','112879','466 160 760','Monthly','Direct Credit','Loan',0),(276,277,'','Friday','12/09/2019','','National Australia','','Jennifer Pracy','082451','494171490','Weekly','Direct Credit','Loan',0),(277,278,'','','','','Commonwealth','','David M Lowe','062-314','000 607 218','Monthly','Direct Credit','Loan',0),(278,279,'','Monday','','','ANZ','','Reece M Sutter','014699','219456969','Weekly','Direct Credit','Loan',0),(279,280,'','Thursday','01/01/1970','','Commonwealth','','Kenneth R Pracy','062-014','10052998','Fortnight','Direct Credit','Loan',0),(280,281,'28/05/2019','Friday','04/06/2019','5991.75','ING Direct','','William T Mackie','923100','338 598 72','Weekly','Direct Debit','Loan',0),(281,282,'','Tuesday','','','Commonwealth','','Paki Tabakanaca','062265','10649063','Fortnight','Direct Credit','Loan',0),(282,283,'','Thursday','12/09/2019','','Commonwealth Bank','','Cecilya R Takacs','062191','000 643 680','Weekly','Direct Debit','Loan',0),(283,284,'','Thursday','','','Commonwealth','','Stephen J Pracy','062536','010 046 861','Fortnight','Direct Debit','Loan',0),(284,285,'','','','','Westpac','','Paul A Wilson','732-067','727603','Monthly','Direct Credit','Loan',0),(285,286,'20/09/2019','Tuesday','27/09/2019','3200','Westpac','','Jeffrey S Maddock','732382','000 639 400','Weekly','Direct Debit','Loan',0),(286,287,'','Thursday','19/09/2019','','Commonwealth Bank','','Mark A J Takacs-Valenta','062611','010 460 732','Weekly','Direct Debit','Loan',0),(287,288,'','Wednesday','','','Commonwealth','','Latai M Talakai','062200','10391003','Fortnight','Direct Credit','Loan',0),(288,289,'','Wednesday','','','Commonwealth','','Marcus Madigan','062102','10233107','Fortnight','','Loan',0),(289,290,'','','','','Anz ','','','012301','423082001','Frequency','','Loan',0),(290,291,'','','','','St George','','Rosita Tan','112879','470466198','Frequency','Direct Credit','Loan',0),(291,292,'','Wednesday','','','St George','','Mohamad Taoube','112879','054 620 045','Fortnight','Direct Credit','Loan',0),(292,293,'','','','','Commonwealth Bank','','Mary Ann Maggi','062105','000710876','Fortnight','Direct Credit','Loan',0),(293,294,'','','19/07/2018','','CBA','','Benjamin Radliffe','62438','10099360','Fortnight','Direct Debit','Loan',0),(294,295,'','Thursday','26/07/2018','','Commonwealth','','James Tauataina','62948','16473683','Weekly','Direct Debit','Loan',0),(295,296,'','','01/01/1970','','QUDOS Credit Union','','Wayne M Williams','704865','14644','Monthly','Direct Credit','Loan',0),(296,297,'','Wednesday','01/01/1970','','St George','','Lelei Tawamacala','112879','145022614','Fortnight','Direct Debit','Loan',0),(297,298,'22/01/2018','Thursday','29/01/2018','945','ANZ','','Mr G  Rae','012299','460444251','Fortnight','Direct Credit','Loan',0),(298,299,'','','28/11/2018','','St George','','N Thornton','112879','38656152','Fortnight','Direct Debit','Loan',0),(299,300,'','','','','Commonwealth','','Odette M Malong','062-339','010 309 952','Monthly','Direct Credit','Loan',0),(300,301,'','','14/09/2019','','Nation Australia','','Poinsettia Manalo','082799','13 968 4275','Monthly','Direct Debit','Loan',0),(301,302,'','','','','Commonwealth','','Peter Tierney','062319','10033088','Weekly','Direct Credit','Loan',0),(302,303,'','','19/09/2019','','Commonwealth','','Robert A Raffaele','062200','2801 3473','Monthly','','Loan',0),(303,304,'','','','','National Australia','','Gary J Willard','082-268','671 916 888','Weekly','Direct Credit','Loan',0),(304,305,'','Wednesday','','','Westpac','','Suresh Mani','062000','12927387','Weekly','Direct Credit','Loan',0),(305,306,'','','','','CBA','','Maika Toga','062-107','10612067','Monthly','Direct Credit','Loan',0),(306,307,'','','','','Bank West','','Marie Rahmi','306821','7248','Fortnight','Direct Credit','Loan',0),(307,308,'','','17/04/2019','','CBA','','Sabina Toilolo','062133','11342832','Fortnight','','Loan',0),(308,309,'','','','','CBA','','Wilma A Williams','062227','10090577','Fortnight','Direct Credit','Loan',0),(309,310,'','','','','ANZ','','Robert S Mansour','012286','188498778','Fortnight','Direct Credit','Loan',0),(310,311,'','Wednesday','','','ANZ','','Asenaca Ralulu','012215','488849971','Fortnight','Direct Credit','Loan',0),(311,312,'','','','','Sydney Credit Union','','Melenaite Topui','802-084','000 062 239','Monthly','Direct Credit','Loan',0),(312,313,'','','14/12/2018','','St George','','Ann J Torrecampo','112879','483588063','Fortnight','Direct Credit','Loan',0),(313,314,'17/07/2018','Thursday','24/07/2018','2167.34','Westpac','','Cristina And Manuel Ramos','732070','596309','Fortnight','Direct Debit','Loan',0),(314,315,'','Thursday','','','CBA','','Houpilili Tuiono','062259','10103700','Fortnight','Direct Credit','Loan',0),(315,316,'','Wednesday','10/04/2019','','Commonwealth','','Iosefo Maomai','062232','010 323 674','Weekly','Direct Debit','Loan',0),(316,317,'','','','','Qantas Credit Union','','C D Wilder','704865','7072149','Monthly','Direct Credit','Loan',0),(317,318,'','','','','Commonwealth','','Vaioleti M Tuipulotu','026-133','10252253','Fortnight','Direct Credit','Loan',0),(318,319,'','Thursday','14/03/2019','','St George Bank','','Alice R Marshall','114879','438 700 183','Weekly','Direct Debit','Loan',0),(319,320,'','','','','Commonwealth','','Mark I Rayner','062-110','000 642 601','Fortnight','Direct Credit','Loan',0),(320,321,'','','01/01/1970','','Teachers Credit Union','','Diane Twentyman','812170','7560224','Fortnight','Direct Credit','Loan',0),(321,322,'','','','','','','','','','Frequency','','Loan',0),(322,323,'','Wednesday','22/08/2018','','ANZ','','Francine L Richey','012430','297 529 377','Weekly','Direct Debit','Loan',0),(323,324,'','Thursday','','','Westpac','','Ilaisaane N Ulavalu','732065','723342','Fortnight','Direct Credit','Loan',0),(324,325,'','Wednesday','15/05/2019','','Westpac','','Bayley G Martin','734154','000 523 501','Weekly','Direct Debit','Loan',0),(325,326,'','','','','St George','','Tevita T Ulavalu','112-879','448 231 430','Monthly','Direct Credit','Loan',0),(326,327,'','','','','CBA','','Amber L Wiggett','062606','10199150','Fortnight','Direct Debit','Loan',0),(327,328,'','','','','NAB','','MJ Rigby','082061','446443711','Monthly','','Loan',0),(328,329,'22/01/2018','Thursday','01/02/2018','1315','Commonwealth Bank','','Maureen Marton','062278','000 360 317','Fortnight','Direct Credit','Loan',0),(329,330,'','Friday','','','ANZ','','Afui Vailala','012430','297943674','Fortnight','Direct Debit','Loan',0),(330,331,'','Tuesday','24/09/2019','','St George','','G  T Vandine','112879','1210 74612','Weekly','Direct Debit','Loan',0),(331,332,'29/01/2018','Thursday','07/02/2018','1900','ING','','Rosemary Marton','923100','067719620','Fortnight','Direct Credit','Loan',0),(332,333,'08/05/2019','Thursday','16/05/2019','5000','GC Mutual Bank','','Michael S Riley','659000','003 088 868','Weekly','Direct Debit','Loan',0),(333,334,'','Friday','08/02/2019','','St George','','Taraivina B Vasu','112879','410660837','Fortnight','Direct Debit','Loan',0),(334,335,'','','','','Commonwealth ','','Lynette A Mason','062-239','010 078 593','Fortnight','Direct Credit','Loan',0),(335,336,'15/02/2018','Thursday','22/02/2018','999.19','St George','','Robyne J Wiblen','112879','003 190 621','Fortnight','Direct Credit','Loan',0),(336,337,'','','','','Commonwealth','','Nancy L S Robarobalevu','026-202','10808213','Monthly','Direct Debit','Loan',0),(337,338,'','','','','ANZ','','Merelita Vatavesi','012141','902779674','Fortnight','Direct Credit','Loan',0),(338,339,'','','','','CBA','','Elizabeth Vatuvei','62150','607835','Fortnight','Direct Debit','Loan',0),(339,340,'','Thursday','01/02/2019','','Commonwealth','','Kuini Mataka','062124','028 042 492','Weekly','Direct Credit','Loan',0),(340,341,'','','20/11/2018','','Credit Union Australia','','Barry W Robinson','814282','010 744 853','Monthly','Direct Debit','Loan',0),(341,342,'','','','','Community First Credit Un','','ValdisE Viksne','512170','000 091 619','Monthly','Direct Credit','Loan',0),(342,343,'','Wednesday','','','Beyond Bank','','Robert G Wenzel','325185','5816501','Fortnight','Direct Credit','Loan',0),(343,344,'','','','','St George','','Shahida Matthews','112-879','447 531 879','Monthly','Direct Credit','Loan',0),(344,345,'','','','','Commonwealth','','Joel Visda','062225','10145537','Weekly','Direct Credit','Loan',0),(345,346,'','','','','Commonwealth','','Sisilia Robinson','062174','01056 0323','Fortnight','Direct Debit','Loan',0),(346,347,'','Tuesday','23/04/2019','','ANZ','','Lindsay C Maunick','012408','541 264 922','Weekly','Direct Debit','Loan',0),(347,348,'','Friday','25/01/2019','','ANZ','','Shelana Visda','012401','589699714','Fortnight','Direct Credit','Loan',0),(348,349,'08/02/2019','Wednesday','28/03/2019','999.86','Commonwealth','','David M Robson','062233','10267470','Fortnight','Direct Credit','Loan',0),(349,350,'','','','','St George','','Steven L Wade','112-879','484567248','Weekly','Direct Credit','Loan',0),(350,351,'26/02/2018','','05/03/2018','999.09','St George','','Lynette A McAtammey','112-879','465036185','Weekly','Direct Debit','Loan',0),(351,352,'','','','','National Australia','','Glynis A Rodrigues','','958 141 098','Monthly','Direct Credit','Loan',0),(352,353,'','','','','CBA','','Mr S F Walker','062143','601013','Monthly','','Loan',0),(353,354,'','Thursday','22/08/2019','','Westpac','','Lee Ann M Wegener','734240','000 625 037','Fortnight','Direct Debit','Loan',0),(354,355,'','','01/01/1970','','NAB','','082 274','2448701','Gerard McAuliffe','Monthly','Direct Credit','Loan',0),(355,356,'13/01/2020','','24/01/2020','3000','National Australia','','Tracy A Rogers','083-832','178 028 887','Weekly','Direct Credit','Loan',0),(356,357,'','','','','Westpac','','Gary B Walls','732-099','000 629 856','Monthly','Direct Credit','Loan',0),(357,358,'','','14/10/2019','','St George','','Kate Walls','112879','118379677','Fortnight','Direct Debit','Loan',0),(358,359,'','','','','St George','','Anabelle McCredie','112-879','68591847','Fortnight','Direct Credit','Loan',0),(359,360,'07/03/2018','Thursday','14/03/2018','4039.32','Credit Union','','Sainiana Rokomaqisa','814282','10147854','Fortnight','Direct Credit','Loan',0),(360,361,'','Wednesday','15/05/2019','','Suncorp Bank','','Tania D Walmsley','484799','163 937 607','Fortnight','Direct Debit','Loan',0),(361,362,'','','','','CBA','','Gillian F Weemes','062235','10076185','Frequency','','Loan',0),(362,363,'','Tuesday','','','ANZ','','Ovini R Waqa','012-287','535081636','Fortnight','Direct Credit','Loan',0),(363,364,'','','','','','','','','','','','Loan',0),(364,365,'','','','','WBC','','Theresa Rokomaqisa','732030','522786','Fortnight','Direct Credit','Loan',0),(365,366,'','Thursday','','','Westpac','','Varitema L Waqa','732371','838703','Fortnight','Direct Credit','Loan',0),(366,367,'','','','','St George','','Kenneth J Ward','112879','492284301','Monthly','Direct Credit','Loan',0),(367,368,'','Monday','','','National Australia','','Marites M Ronidel','082140','582042031','Weekly','Direct Debit','Loan',0),(368,369,'','Thursday','','','Commonwealth','','Stephanie Warrior','062-259','010 424 440','Weekly','Direct Debit','Loan',0),(369,370,'','','','','St George','','Mr N McDonough','112879','430075070','Weekly','Direct Credit','Loan',0),(370,371,'','','','','Sydney Credit Union','','Karen L Rosewarne','802088','49154','Weekly','Direct Credit','Loan',0),(371,372,'','','','','NAB','','Stewart Andrew McGuire','084004','645501937','Fortnight','Direct Debit','Loan',0),(372,373,'','Wednesday','09/10/2019','','Commonwealth','','Barbara Jean Rowlands','062186','10170340','Fortnight','Direct Credit','Loan',0),(373,374,'','','','','St George','','Marilour Mcintosh','112-879','066 487 309','Weekly','Direct Credit','Loan',0),(374,375,'06/05/2019','Thursday','28/05/2019','599.12','ANZ','','Rona B Morrow','012-268','28917 1184','Monthly','Direct Credit','Loan',0),(375,376,'','','','','Commonwealth','','Bruce W McKenny','062-116','10117855','Fortnight','Direct Debit','Loan',0),(376,377,'','','','','ANZ','','Joanne Morrissey','012341','5786682585','Fortnight','Direct Debit','Loan',0),(377,378,'','','','','ANZ','','J McMahon','012408','182910055','Fortnightly','Direct Credit','Loan',0),(378,379,'','Friday','06/09/2019','','ANZ','','Mr G D Mead','012621','570625811','Weekly','Direct Debit','Loan',0),(379,380,'','Tuesday','','','Commonwealth','','James R Morgan','062191','10274252','Weekly','Direct Credit','Loan',0),(380,381,'','Thursday','','','Sydney Credit Union','','Veniana Mealey','802084','75133','Fortnightly','Direct Credit','Loan',0),(381,382,'13/03/2019','Tuesday','29/03/2019','1999.75','Westpac Bank','','Christopher James  June Clark','732062','563523','Fortnight','Direct Debit','Loan',0),(382,383,'','','','','Commonwealth','','Norman C Mendigorin','062692','15392461','Monthly','Direct Credit','Loan',0),(383,384,'','','','','St George','','Aida Mirdha','112-879','164 249 881','Fortnight','Direct Debit','Loan',0),(384,385,'','','','','Westpac','','Sylvia A Micallef','732060','626754','Weekly','Direct Credit','Loan',0),(385,386,'','','','','Commonwealth','','Antonio B Mendoza','062005','010 687 806','Monthly','Direct Credit','Loan',0),(386,387,'','','','','Bankwest','','Zeriza Mercado','303-092','6641908','Monthly','Direct Credit','Loan',0),(387,388,'','Thursday','','','Unity Bank','','Steven F Merlino','882000','64016709','Fortnight','Direct Credit','Loan',0),(388,389,'01/03/2018','Wednesday','01/04/2018','3499.58','Commonwealth','','Tunggul D Aritonang','062439','10043233','Fortnight','Direct Credit','Loan',0),(389,390,'','','','','','','','','','Frequency','','Loan',0),(390,391,'','','','','','','','','','Frequency','','Rent',0),(391,395,'','','','','','','','','','Frequency','','Loan',0),(392,396,'04/10/2019','','11/10/2019','2000','Xxxx','','Bank of kerry','11111','222222','Weekly','Direct Credit','Loan',0),(393,399,'23/01/2020','','30/01/2020','1000','Nab','','Name of acc','123456','1122334','Weekly','Direct Debit','Loan',0),(394,400,'','','','','','','','','','Frequency','','Loan',0),(395,402,'','','','','','','','','','Frequency','','Loan',0),(396,403,'','','','','','','','','','Frequency','','Loan',0),(397,404,'','','','','St George','','Belinda R Abel','112879','125982360','Monthly','Direct Debit','Loan',0),(398,405,'','','','','St George','','Belinda R Abel','112879','125982360','Monthly','Direct Debit','Loan',0),(399,406,'11/11/2019','','18/11/2019','4000','St George','','Belinda R Abel','112879','125982360','Monthly','Direct Debit','Loan',0),(400,407,'15/10/2019','Friday','25/10/2019','600','Firefighters mutual bank','','T J  L Richardson','802825','61032117','Fortnight','Direct Debit','Loan',0),(401,408,'','Thursday','','1700','CBA','','Lesley Pearson','062177','10075872','Fortnight','Direct Debit','Loan',0),(402,0,'15/10/2019','Friday','25/10/2019','600','Firefighters mutual bank','','T J  L Richardson','802825','61032117','Fortnight','Direct Debit','Loan',0),(403,409,'15/10/2019','Monday','29/10/2019','900','CBA','','TM  KJ Larsen','062185','10189589','Fortnight','','Loan',0),(404,411,'','','','','','','','','','Frequency','','Loan',0),(405,412,'06/11/2019','','13/11/2019','1000','','','','','','Frequency','','Loan',0),(406,413,'','Monday','01/10/2010','','Bank','','Account Name','123456','111 222 333','Weekly','Direct Credit','Loan',0),(407,414,'','Monday','01/10/2010','','Bank','','Account Name','123456','111 222 333','Weekly','Direct Credit','Loan',0),(408,415,'05/03/2018','','06/04/2018','1000','ANZ','','Richard J Anslow','012-364','493 834 379','Monthly','Direct Credit','Rent',0),(409,416,'16/10/2019','Monday','25/10/2019','1000','ANZ','','Richard J Anslow','012-364','493 834 379','Fortnight','Direct Debit','Loan',0),(410,417,'05/03/2018','','06/04/2018','1000','ANZ','','Richard J Anslow','012-364','493 834 379','Monthly','Direct Credit','Loan',0),(411,418,'06/11/2019','Monday','13/11/2019','5000','Bank','','Account Name','123456','111 222 333','Weekly','Direct Credit','Loan',0),(412,420,'18/10/2019','Wednesday','06/11/2019','3989.78','Commonwealth','','Latai M Talakai','062200','10391003','Fortnight','Direct Credit','Loan',0),(413,421,'18/10/2019','Wednesday','25/10/2019','2400','St George','','Grace A Koroiwara','112879','437658622','Fortnight','Direct Credit','Loan',0),(414,422,'','Monday','01/10/2010','','Bank','','Account Name','123456','111 222 333','Weekly','Direct Credit','Loan',0),(415,423,'18/10/2019','','25/10/2019','500','Suncorp','','','','','Frequency','','Loan',0),(416,427,'21/10/2019','','28/10/2019','1000','','','','','','Frequency','','Loan',0),(417,429,'','','','','ANZ','','G S Quinlin','012301','423082001','Frequency','','Loan',0),(418,430,'','','','','Bendigo Bank','','Adrian G Lindo','633000','151 711 165','Monthly','Direct Credit','Loan',0),(419,431,'23/10/2019','Friday','01/11/2019','5500','National Australia','','Kayla L Wade','084383','185 710 382','Fortnight','Direct Debit','Loan',0),(420,426,'','','','','','','','','','Frequency','','Loan',0),(421,432,'','Friday','31/05/2019','','ING Direct','','William T Mackie','923100','338 598 72','Weekly','Direct Debit','Loan',0),(422,433,'','Wednesday','10/04/2019','','Commonwealth','','Iosefo Maomai','062232','010 323 674','Weekly','Direct Debit','Loan',0),(423,434,'','','','','','','','','','Frequency','','Loan',0),(424,435,'01/10/2019','Tuesday','08/10/2019','32342','Cvvxcvc','','Sdfsdfsdf','sdsdfs','fsdfsdsd','Weekly','Cash','Rent',0),(425,436,'','','','','','','','','','Frequency','','Loan',0),(426,437,'','','','','Commonwealth','','Joel Visda','062225','10145537','Monthly','Direct Credit','Loan',0),(427,438,'19/12/2019','Monday','26/12/2019','500','A','','C','123456','11223344','Weekly','Direct Debit','Loan',0),(428,439,'01/11/2019','Monday','08/11/2019','2000','Commonwealth','','Melissa A Bell','062-121','656777','Monthly','Direct Credit','Loan',0),(429,440,'','Monday','02/09/2019','','Commonwealth','','Lesley M Hoppit','062-421','010 460 704','Fortnight','Direct Debit','Loan',0),(430,444,'','','01/01/1970','','QUDOS Credit Union','','Wayne M Williams','704865','14644','Monthly','Direct Credit','Loan',0),(431,445,'','','','','','','','','','Frequency','','Loan',0),(432,446,'','','','','ANZ','','Maxine A Farrelly','012299','554997682','Monthly','Direct Debit','Loan',0),(433,447,'22/11/2019','','29/11/2019','2000','ANZ','','Maxine A Farrelly','012299','554997682','Weekly','Direct Debit','Loan',0),(434,448,'05/11/2019','Monday','12/11/2019','1000','Commonwealth','','Aaron aaron','123456','99887766','Fortnight','Direct Credit','Loan',0),(435,449,'','Sunday','08/08/2019','','Westpac','','Polonitina Fosita','732382','546677','Fortnight','Direct Debit','Loan',0),(436,452,'','','','',' Westpac','','Lilly A Marton','562901','5831 9650','Fortnight','Direct Debit','Loan',0),(437,453,'','','','','Commonwealth','','John Bates','062556','4600 9876','Fortnightly','Direct Credit','Loan',0),(438,454,'08/11/2019','Friday','15/11/2019','1000','Westpac','','Lilly A Marton','562901','5831 9650','Fortnight','Direct Debit','Loan',0),(439,455,'17/12/2019','','24/12/2019','500','Westpac','','Lilly A Marton','562901','5831 9650','Frequency','Direct Debit','Loan',0),(440,456,'07/11/2019','','14/11/2019','555','Westpac','','Lilly A Marton','562901','5831 9650','Fortnight','Direct Debit','Loan',0),(441,459,'','','','','','','','','','Frequency','','Loan',0),(442,441,'','','','','','','','','','Frequency','','Loan',0),(443,460,'08/11/2019','','15/11/2019','1000','CBA','','Brian Schofield','062528','10461408','Fortnight','Direct Debit','Loan',0),(444,461,'08/11/2019','','22/11/2019','1000','CBA','','A Adams','112879','1025532','Fortnight','Direct Debit','Loan',0),(445,462,'11/11/2019','','25/11/2019','2000','Westpac','','Joel D Bason','732556','865485','Fortnight','Direct Credit','Loan',0),(446,463,'','Monday','01/10/2010','','Bank','','Account Name','BSB','Account number','Weekly','','Loan',0),(447,465,'16/01/2020','Monday','23/01/2020','100','Bank','','Account Name','123456','1223561454','Weekly','Direct Debit','Rent',0),(448,466,'11/11/2019','Thursday','21/11/2019','3000','ANZ','','Josephine Guerrero','012220','491908733','Fortnight','Direct Debit','Loan',0),(449,467,'','','','','Maritime Credit Union','','802884','27717','Darren D Bell','Fortnight','Direct Credit','Loan',0),(450,468,'11/11/2019','Monday','19/11/2019','3977.22','Maritime Credit Union','','802884','27717','Darren D Bell','Fortnight','Direct Credit','Loan',0),(451,471,'','','','','','','','','','Frequency','','Loan',0),(452,472,'12/11/2019','','21/11/2019','3000','ANZ','','G S Quinlin','012301','423082001','Fortnight','','Loan',0),(453,469,'10/01/2020','','17/01/2020','1000','Bank','','','123456','11223344','Frequency','','Loan',0),(454,470,'16/12/2019','','25/12/2019','1090.21','','','','','','Frequency','','Loan',0),(455,475,'','','','','Westpac','','Gloria Baki','732-004','000 528 914','Monthly','Direct Credit','Loan',0),(456,476,'','','','','St George','','Edward R Peslak','112-879','114 921 221','Monthly','Direct Credit','Loan',0),(457,477,'','Monday','02/09/2019','','Commonwealth','','Lesley M Hoppit','062-421','010 460 704','Fortnight','Direct Debit','Loan',0),(458,478,'01/11/2019','Thursday','08/11/2019','118.42','Commonwealth','','Kenneth R Pracy','062-014','10052998','Fortnight','Direct Credit','Loan',0),(459,486,'','','','','','','','','','Frequency','','Loan',0),(460,458,'','','','','','','','','','Frequency','','Rent',0),(461,487,'19/11/2019','Thursday','27/11/2019','800','CBA','','062 000','1533190','Steven Griffith','Weekly','Direct Debit','Loan',0),(462,489,'','','','','','','','','','Frequency','','Rent',0),(463,490,'21/11/2019','Thursday','28/11/2019','1759.87','CBA','','Chirnsinte A Spowart','062259','10349065','Fortnight','Direct Debit','Loan',0),(464,491,'','','','','','','','','','Frequency','','Loan',0),(465,492,'','','','','','','','','','Frequency','','Loan',0),(466,493,'','','','','','','','','','Frequency','','Loan',0),(467,495,'22/11/2019','Friday','28/11/2019','4000','CUA','','J Verba','814282','30587056','Frequency','','Loan',0),(468,496,'22/11/2019','Thursday','29/11/2019','6174.77','Sydney Credit Union','','Karen L Rosewarne','802088','49154','Weekly','Direct Credit','Loan',0),(469,497,'','','','','St George','','Damian G Jones','112-879','482 381 001','Monthly','Direct Credit','Loan',0),(470,498,'25/11/2019','Wednesday','05/12/2019','2000','St George','','Damian G Jones','112-879','482 381 001','Monthly','Direct Credit','Loan',0),(471,499,'19/11/2019','Wednesday','26/11/2019','2300','Ugyug','','Huihuihu','jkjkjh','hihuihuhui','Frequency','','Loan',0),(472,500,'20/11/2019','Thursday','27/11/2019','1500','Jhkhjkh','','Jhkjhgjhjk','jhkghj','jg654564jkhmkkj','Weekly','Direct Credit','Rent',0),(473,502,'','','','','','','','','','Frequency','','Loan',0),(474,508,'','','13/12/2018','','WBC','','Julie Nicoll','732059','588340','Fortnight','Direct Credit','Loan',0),(475,509,'','','','','Westpac','','Daniel Eldabbagh','732-109','000 797 766','Fortnight','Direct Credit','Loan',0),(476,510,'29/11/2019','Wednesday','06/12/2019','2999.69','ANZ','','Asenaca Ralulu','012215','488849971','Fortnight','Direct Credit','Loan',0),(477,511,'','Thursday','10/01/2019','','Commonwealth Bank','','Cecilya R Takacs','062191','000 643 680','Weekly','Direct Debit','Rent',0),(478,504,'','','','','','','','','','Frequency','','Rent',0),(479,520,'06/11/2019','Monday','13/11/2019','1000','Bank','','Account Name','123456','111 222 333','Weekly','Direct Credit','Rent',0),(480,521,'06/11/2019','Monday','13/11/2019','1000','Bank','','Account Name','123456','111 222 333','Weekly','Direct Credit','Rent',0),(481,522,'02/12/2019','Monday','28/01/2020','5973.8','National Australia','','Manolito Bunyi','082-067','435505315','Monthly','Direct Credit','Loan',0),(482,523,'06/11/2019','Monday','13/11/2019','5000','Bank','','Account Name','123456','111 222 333','Weekly','Direct Credit','Rent',0),(483,526,'03/12/2019','','18/12/2019','1000','CBA','','Brent Ragen','062227','10168549','Frequency','','Loan',0),(484,527,'','','','','St George','','Steven L Wade','112-879','484567248','Weekly','Direct Credit','Loan',0),(486,528,'03/12/2019','','13/12/2019','2000','St George Bank','','Angela Marshall','114879','127010847','Frequency','','Loan',0),(487,529,'','Wednesday','','','Westpac','','Peter J Honeysett','732340','502238','Fortnight','Direct Debit','Loan',0),(488,530,'04/12/2019','Monday','11/12/2019','4999.77','CBA','','Sabina Toilolo','062133','11342832','Fortnight','Direct Credit','Loan',0),(489,532,'','','','','ANZ','','Robert E Springfield','012-292','599691353','Monthly','Direct Credit','Loan',0),(490,524,'','','','','','','','','','Frequency','','Rent',0),(491,533,'','','','','','','','','','Frequency','','Rent',0),(492,535,'','Friday','06/12/2019','','Commonwealth Bank','','Cecilya R Takacs','062191','000 643 680','Weekly','Direct Debit','Loan',0),(493,536,'03/12/2019','','18/12/2019','1000','CBA','','Brent Ragen','062227','10168549','Frequency','','Loan',0),(494,537,'','Friday','06/12/2019','','Commonwealth Bank','','Cecilya R Takacs','062191','000 643 680','Weekly','Direct Debit','Rent',0),(495,525,'','','','','','','','','','Frequency','','Rent',0),(496,538,'','','','','Heritage','','Keira Leah Lavis','638 01','14604426S1','Frequency','','Loan',0),(497,539,'12/12/2019','Friday','20/12/2019','2800','Westpac','','Cheyenne R Stedwell','735101','835100','Fortnight','Direct Debit','Loan',0),(498,540,'05/12/2019','','12/12/2019','2500','','','','','','Frequency','','Loan',0),(499,542,'','Wednesday','16/10/2019','','Suncorp','','Andrew K Hunter','484799','054 707 192','Weekly','Direct Debit','Loan',0),(500,545,'','','','','','','','','','Frequency','','Loan',0),(501,547,'','','','','','','','','','Frequency','','Loan',0),(502,549,'','','19/02/1900','','CBA','','L Hobby','62150','28013661','Fortnight','Direct Debit','Loan',0),(503,550,'10/12/2019','Wednesday','18/12/2019','2000','ANZ','','Timaleti Droceva','012390','565130566','Fortnight','Direct Credit','Loan',0),(504,551,'10/12/2019','','13/12/2019','5161.97','WBC','','Theresa Rokomaqisa','732030','522786','Fortnight','Direct Credit','Loan',0),(505,552,'10/12/2019','Monday','16/01/2020','4058.76','CBA','','Jason Gale','062186','10224687','Monthly','Direct Credit','Loan',0),(506,554,'11/12/2019','Friday','20/12/2019','2400','Firefighters mutual bank','','T J  L Richardson','802825','61032117','Fortnight','Direct Debit','Loan',0),(507,556,'12/12/2019','Monday','24/12/2019','4999.84','ANZ','','Mereani Cooke','012030','222572768','Fortnight','Direct Credit','Loan',0),(508,555,'11/12/2019','Monday','18/12/2019','1000','Westpac','','John Christian ','732067','814854','Fortnight','Direct Debit','Loan',0),(509,559,'02/12/2019','Thursday','09/12/2019','44353','Ddsfsfsf','','Dfsdfsdfsdf','fsdfsd','dfsdfsdfsdf','Weekly','Cash','Rent',0),(510,560,'02/12/2019','Thursday','09/12/2019','44353','Ddsfsfsf','','Dfsdfsdfsdf','fsdfsd','dfsdfsdfsdf','Weekly','Cash','Rent',0),(511,553,'','','','','','','','','','Frequency','','Rent',0),(512,561,'13/12/2019','Friday','20/12/2019','4444','Vxxcxc','','Xcvxvxcv','xcvxcv','vcvxcvxc','Fortnight','Direct Debit','Loan',0),(513,558,'','','','','','','','','','Frequency','','Rent',0),(514,562,'12/12/2019','Sunday','26/12/2019','4100','Westpac','','Polonitina Fosita','732382','546677','Fortnight','Direct Debit','Loan',0),(515,563,'','','','','CBA','','EEE Systems','','','Monthly','Direct Credit','Loan',0),(516,564,'','','','','Commonwealth Bank ','','Maria Ann Kendrick','062693','12023238','Frequency','','Loan',0),(517,565,'16/12/2019','Wednesday','25/12/2019','1090.21','ANZ Bank','','Masina C Fenton','014023','294 409 548','Fortnight','','Loan',0),(518,566,'','Monday','01/10/2010','','Bank','','Account Name','BSB','Account number','Weekly','','Rent',0),(519,571,'','','','','Commonwealth','','Mark D Leslie','062-222','010 211 440','Monthly','Direct Credit','Loan',0),(520,572,'','','','','Bank West','','Marie Rahmi','306821','7248','Fortnight','Direct Credit','Loan',0),(521,573,'13/12/2019','Friday','27/12/2019','4999.46','St George','','Taraivina B Vasu','112879','410660837','Fortnight','Direct Debit','Loan',0),(522,451,'','','','','','','','','','Frequency','','Loan',0),(523,574,'23/12/2019','Friday','30/12/2019','1000','National Australia','','Helen M  Brock','084405','161 116 063','Fortnight','','Loan',0),(524,575,'','','','','Sydney Credit Union','','Steven B Anderson','802084','49175','Weekly','Direct Credit','Loan',0),(525,576,'','','','','St George','','Todd Bendeich','112879','119093611','Fortnight','','Loan',0),(526,577,'16/12/2019','','23/12/2019','500','St George','','Todd Bendeich','112879','119093611','Fortnight','','Loan',0),(527,578,'16/12/2019','Monday','23/12/2019','3300','Suncorp','','Anne E Harrison','484799','100 244 865','Fortnight','Direct Debit','Loan',0),(528,579,'','','','','','','','','','Frequency','','Rent',0),(529,580,'17/12/2019','Monday','01/01/2020','1664.38','St George','','John Adamson','112879','113173696','Fortnight','Direct Credit','Loan',0),(530,581,'18/12/2019','Thursday','26/12/2019','1000','Commonwealth Bank','','Cecilya R Takacs','062191','000 643 680','Weekly','Direct Debit','Loan',0),(531,582,'18/12/2019','','25/12/2019','2000','','','','','','Frequency','','Loan',0),(532,583,'16/12/2019','','25/12/2019','1090.21','','','','','','Frequency','','Loan',0),(533,584,'','','','','CBA','','L aRGENT','062546','10492428','Frequency','','Loan',0),(534,585,'20/12/2019','','30/12/2019','6000','','','','','','Frequency','','Loan',0),(535,586,'03/12/2019','Wednesday','10/12/2019','2001','Dfsfdsfs','','Sfdsfdfds','fsdfdf','sdfsdfsfdsfsd','Weekly','Centrepay','Loan',0),(536,587,'','','','','','','','','','Frequency','','Rent',0),(537,589,'','','','','NAB','','Kristy Lee Green','082745','201059586','Frequency','','Loan',0),(538,590,'23/12/2019','Thursday','03/01/2020','1000','Westpac','','Cristina And Manuel Ramos','732070','596309','Fortnight','','Loan',0),(539,591,'23/12/2019','Friday','30/12/2019','1000','National Australia','','Helen M  Brock','084405','161 116 063','Fortnight','','Rent',0),(540,588,'','','','','','','','','','Frequency','','Rent',0),(541,594,'','','','','','','','','','Frequency','','Loan',0),(542,595,'','','','','','','','','','Frequency','','Loan',0),(543,596,'','','','','','','','','','Frequency','','Rent',0),(544,597,'','','02/01/2018','','ANZ','','K Jackson-Chandler','12341','466492924','Fortnight','Direct Debit','Loan',0),(545,598,'07/01/2020','Wednesday','17/01/2020','1000','St George','','Angeline Magbanua','112879','464590467','Fortnight','Direct Credit','Loan',0),(546,599,'08/01/2020','Thursday','22/01/2020','1000','Westpac','','P M Longley ','732075','830299','Fortnight','Direct Credit','Loan',0),(547,600,'','Friday','30/08/2019','','ANZ','','Quinton J Harris','014506','309 792 982','Weekly','','Loan',0),(548,601,'08/01/2020','Friday','17/01/2020','4632.38','ANZ','','Quinton J Harris','014506','309 792 982','Weekly','Direct Debit','Loan',0),(549,602,'','','','','','','','','','Frequency','','Loan',0),(550,603,'10/01/2020','Thursday','23/01/2020','799.04','Commonwealth','','Alexander Judge','062229','1003 1192','Fortnight','Direct Debit','Loan',0),(551,606,'13/01/2020','','24/01/2020','3000','National Australia','','Tracy A Rogers','083-832','178 028 887','Weekly','Direct Credit','Loan',0),(552,607,'14/01/2020','Monday','24/01/2020','3000','CBA','','Winston Newbond','62334','10950735','Monthly','Direct Credit','Loan',0),(553,608,'','Wednesday','','','Westpac','','Romeo Leonor','732260','624761','Fortnight','','Loan',0),(554,609,'15/01/2020','Wednesday','22/01/2020','2900','St George','','Lelei tawamacala','112879','145022614','Weekly','Direct Debit','Loan',0),(555,610,'','','','','','','','','','Frequency','','Loan',0),(556,605,'13/01/2020','Friday','20/01/2020','3432','Sdasa','','Sdasda','sdasda','sdasda','Weekly','EFT','Rent',0),(557,611,'','Wednesday','04/12/2019','','ANZ','','Catherine E Bunney','014211','529 585 889','Fortnight','Direct Debit','Loan',0),(558,612,'','Wednesday','04/12/2019','','ANZ','','Catherine E Bunney','014211','529 585 889','Fortnight','Direct Debit','Rent',0),(559,613,'23/01/2020','Wednesday','30/01/2020','3499.97','St George','','Damian G Jones','112-879','482 381 001','Monthly','Direct Credit','Loan',0),(560,615,'','Thursday','15/08/2019','','NAB','','Cathy J Snellman','084383','774 113 383','Weekly','','Rent',0),(561,617,'','Friday','06/09/2019','','National Australia','','Gavin M Bunney','084223','438 938 781','Weekly','Direct Debit','Rent',0),(562,618,'05/02/2019','Thursday','12/02/2019','2500','National Australia','','Tracy A Rogers','083-832','178 028 887','Weekly','Direct Credit','Loan',0),(563,619,'','Friday','06/09/2019','','National Australia','','Gavin M Bunney','084223','438 938 781','Weekly','Direct Debit','Rent',0),(564,620,'14/01/2020','Friday','21/01/2020','1766.64','National Australia','','Gavin M Bunney','084223','438 938 781','Weekly','Direct Debit','Loan',0),(565,622,'17/01/2020','Monday','03/02/2020','4000','St George','','Todd Bendeich','112879','119093611','Fortnight','Direct Debit','Loan',0),(566,621,'17/01/2020','Wednesday','24/01/2020','400','NAB','','Tiffany Rose Hanks','084745','120296432','Fortnight','Direct Debit','Loan',0),(567,623,'01/03/2018','Wednesday','01/04/2018','3499.58','Commonwealth','','Tunggul D Aritonang','062439','10043233','Fortnight','Direct Credit','Loan',0),(568,625,'01/03/2018','Wednesday','05/04/2018','3499.58','Commonwealth','','Tunggul D Aritonang','062439','10043233','Fortnight','Direct Credit','Loan',0),(569,626,'01/03/2018','Wednesday','05/04/2018','3499.58','Commonwealth','','Tunggul D Aritonang','062439','10043233','Fortnight','Direct Credit','Loan',0),(570,627,'06/04/2019','','13/04/2019','500','ANZ','','Peter W Chan','012-110','596329308','Monthly','Direct Credit','Loan',0),(571,628,'','','','','Mereadani Wasigitoni','','Mereadani Wasigitoni','012226','414931366','Frequency','','Loan',0),(572,614,'','','','','','','','','','Frequency','','Rent',0),(573,616,'','','','','','','','','','Frequency','Direct Credit','Loan',0),(574,629,'','','','','','','','','','Frequency','','Rent',0),(575,630,'23/01/2020','Friday','07/02/2020','3979.37','National Australia','','Kayla L Wade','084383','185 710 382','Fortnight','Direct Debit','Loan',0),(576,631,'','','','','Commonwealth','','Steven Farrell','','','Frequency','','Loan',0),(577,633,'30/01/2020','Wednesday','06/02/2020','1500','CBA','','Shannon kouka','062259','10432926','Weekly','','Loan',0),(578,634,'07/02/2020','Wednesday','20/02/2020','9864.68','Westpac','','Peter J Honeysett','732340','502238','Fortnight','Direct Debit','Loan',0),(579,635,'03/02/2020','Friday','10/02/2020','400','Bank Of Queensland','','Michael N Green','124053','020 434 142','Weekly','Direct Debit','Loan',0),(580,636,'12/12/2019','Friday','20/12/2019','2800','Westpac','','Cheyenne R Stedwell','735101','835100','Fortnight','Direct Debit','Loan',0),(581,637,'04/02/2020','Thursday','19/02/2020','2000','CBA','','Amber L Wiggett','062606','10199150','Fortnight','Direct Debit','Loan',0),(582,639,'04/02/2020','Friday','18/02/2020','1404.24','Commonwealth','','Riza E Manguerra','064184','010 910 654','Fortnight','Direct Debit','Loan',0),(583,641,'06/02/2020','Thursday','13/02/2020','4661.1','Commonwealth','','Craig G Rolph','064168','010 703 364','Weekly','Direct Debit','Loan',0),(584,640,'07/02/2020','','14/02/2020','2000','Commonweath','','Kevin Arnan Casinto','062105','10188520','Frequency','','Loan',0),(585,642,'07/02/2020','Thursday','20/02/2020','2307.42','Credit Union Australia','','Kimberley D Kay','814282','050 432 204','Fortnight','Direct Credit','Loan',0),(586,643,'','Monday','22/04/2019','','Commonwealth','','DA & KM Hogan','062636','010 369 790','Fortnightly','Direct Debit','Loan',0),(587,644,'31/01/2020','Monday','10/02/2020','3977.9','Commonwealth','','DA  KM Hogan','062636','010 369 790','Fortnight','Direct Debit','Loan',0),(588,645,'','Thursday','04/10/2018','','St George','','Sandra E Marti','112879','034 626 183','Weekly','Direct Debit','Loan',0),(589,646,'30/01/2020','Wednesday','05/02/2020','4036.83','Commonwealth','','Zoe E Brannagan','062948','013 329 176','Fortnight','Direct Debit','Loan',0),(590,647,'','Wednesday','12/02/2020','1767.8','ANZ','','Carole Kinder','014524','391 906 618','Fortnight','Direct Debit','Loan',0),(591,648,'12/02/2020','','19/02/2020','6000','NAB','','Jye grant arnold','084134','291516946','Frequency','','Loan',0),(592,649,'12/02/2020','Monday','26/02/2020','1600','Endeavour Mutual','','Gerard P doran','611000','857055','Fortnight','Direct Credit','Loan',0),(593,638,'18/02/2020','','25/02/2020','555','','','','','','Frequency','','Loan',0),(594,650,'17/02/2020','','24/02/2020','3000','','','','','','Frequency','','Loan',0),(595,651,'17/02/2020','Thursday','27/02/2020','1000','Suncorp ','','Mr D L Pivott','484799','166592791','Weekly','Direct Debit','Loan',0),(596,652,'17/02/2020','Thursday','27/02/2020','1905.11','CBA','','Benjamin Radliffe','62438','10099360','Fortnight','Direct Debit','Loan',0),(597,653,'19/02/2020','Friday','28/02/2020','1000','Commonwealth bank','','Jamie sorrenson','064168','10394565','Weekly','','Loan',0),(600,654,'19/02/2020','Wednesday','26/02/2020','1899.11','Westpac','','Romeo Leonor','732260','624761','Fortnight','Direct Debit','Loan',0),(601,662,'','','','','','','','','','Frequency','','Rent',0),(602,663,'19/02/2020','','27/03/2020','3600','St George Bank','','Harris Nicolaou','112879','410819887','Monthly','Direct Credit','Loan',0),(603,664,'','Wednesday','26/02/2020','','Bank Of Queensland','','Amanda J Carpenter','124001','022 620 048','Fortnight','','Loan',0),(604,665,'14/02/2020','Wednesday','21/02/2020','','Credit Union Australia','','Marea A Haupt','814282','030 002 924','Fortnight','Direct Debit','Loan',0),(605,666,'','Wednesday','20/03/2019','','ANZ','','Denise James','012877','3813 30264','Fortnight','Direct Debit','Loan',0),(606,667,'14/02/2020','Thursday','21/02/2020','500','ANZ','','Juan G Lowe','014520','559 119 344','Fortnight','Direct Debit','Loan',0),(607,660,'','','','','','','','','','Frequency','','Loan',0),(608,668,'','','','','','','','','','Frequency','','Loan',0),(609,670,'','Wednesday','','','Commonwealth','','Marcus Madigan','062102','10233107','Fortnight','','Loan',0),(610,689,'','','','','','','','','','Frequency','','Rent',0),(611,690,'','','','','','','','','','Frequency','','Rent',0),(612,722,'10/03/2020','Wednesday','17/03/2020','323','Sadsas','','Wewqewq','sadsad','342342','Weekly','Cash','Loan',0),(613,723,'10/03/2020','Wednesday','17/03/2020','323','Sadsas','','Wewqewq','sadsad','342342','Weekly','Cash','Loan',0),(614,724,'10/03/2020','Wednesday','17/03/2020','323','Sadsas','','Wewqewq','sadsad','342342','Weekly','Cash','Loan',0),(615,725,'10/03/2020','Wednesday','17/03/2020','323','Sadsas','','Wewqewq','sadsad','342342','Weekly','Cash','Loan',0),(616,726,'10/03/2020','Wednesday','17/03/2020','323','Sadsas','','Wewqewq','sadsad','342342','Weekly','Cash','Loan',0),(617,727,'10/03/2020','Wednesday','17/03/2020','323','Sadsas','','Wewqewq','sadsad','342342','Weekly','Cash','Loan',0),(618,730,'10/03/2020','Wednesday','17/03/2020','323','Sadsas','','Wewqewq','sadsad','342342','Weekly','Cash','Loan',0),(619,731,'10/03/2020','Wednesday','17/03/2020','323','Sadsas','','Wewqewq','sadsad','342342','Weekly','Cash','Loan',0),(620,691,'09/03/2020','Monday','16/03/2020','45435','Fdg','','Dgdfgdf','dgdfgd','dgdfgdg','Fortnight','Cash','Rent',0),(621,732,'09/03/2020','Monday','16/03/2020','45435','Fdg','','Dgdfgdf','dgdfgd','dgdfgdg','Fortnight','Cash','Rent',0),(622,733,'09/03/2020','Monday','16/03/2020','45435','Fdg','','Dgdfgdf','dgdfgd','dgdfgdg','Fortnight','Cash','Rent',0),(623,734,'09/03/2020','Monday','16/03/2020','45435','Fdg','','Dgdfgdf','dgdfgd','dgdfgdg','Fortnight','Cash','Rent',0),(624,735,'09/03/2020','Monday','16/03/2020','45435','Fdg','','Dgdfgdf','dgdfgd','dgdfgdg','Fortnight','Cash','Rent',0),(625,736,'09/03/2020','Monday','16/03/2020','45435','Fdg','','Dgdfgdf','dgdfgd','dgdfgdg','Fortnight','Cash','Rent',0),(626,737,'09/03/2020','Monday','16/03/2020','45435','Fdg','','Dgdfgdf','dgdfgd','dgdfgdg','Fortnight','Cash','Rent',0),(627,738,'09/03/2020','Monday','16/03/2020','45435','Fdg','','Dgdfgdf','dgdfgd','dgdfgdg','Fortnight','Cash','Rent',0),(628,741,'','','','','','','','','','Frequency','','Mortgage',0),(629,742,'02/03/2020','Friday','09/03/2020','443543','Fdfdg','','Dgdfgd','dfgdfg','gdgd','Fortnight','EFT','Rent',0),(630,743,'02/03/2020','Friday','09/03/2020','443543','Fdfdg','','Dgdfgd','dfgdfg','gdgd','Fortnight','EFT','Rent',0),(631,744,'09/03/2020','Friday','16/03/2020','45435','Bnvn','','Nnvbn','vbnvnv','vbnvbnvn','Fortnight','Direct Credit','Rent',0),(632,721,'','','','','','','','','','Frequency','','Mortgage',0),(633,745,'09/03/2020','Friday','16/03/2020','45435','Bnvn','','Nnvbn','vbnvnv','vbnvbnvn','Fortnight','Direct Credit','Rent',0),(634,746,'09/03/2020','Friday','16/03/2020','45435','Bnvn','','Nnvbn','vbnvnv','vbnvbnvn','Fortnight','Direct Credit','Rent',0),(635,747,'19/12/2019','Monday','26/12/2019','500','A','','C','123456','11223344','Weekly','Direct Debit','Loan',0),(636,751,'03/03/2020','Thursday','10/03/2020','2342','Erwerw','','Rwerwe','rwerew','rwewerwe','Weekly','Cash','Rent',0),(637,748,'','','','','','','','','','Frequency','','Mortgage',0),(638,740,'','','','','','','','','','Frequency','','Rent',0),(639,704,'','','','','','','','','','Frequency','','Mortgage',0),(644,693,'','','','','','','','','','Frequency','','Rent',0),(649,812,'','','','','','','','','','Frequency','','Mortgage',0),(650,809,'','','','','','','','','','Frequency','','Mortgage',0),(651,811,'','','','','','','','','','Frequency','','Mortgage',0),(652,789,'','','','','','','','','','Frequency','','Mortgage',0),(653,824,'','','','','','','','','','Frequency','','Rent',0),(654,830,'','','','','','','','','','Frequency','','Rent',0),(655,834,'','','','','','','','','','Frequency','','Mortgage',0),(656,832,'','','','1.61','','','','','','Frequency','','Rent',0),(657,828,'','','','','','','','','','Frequency','','Rent',0),(658,842,'','','','1.46','','','','','','','','Rent',0),(659,847,'','','','37.22','','','','','','','','Rent',0),(660,850,'','','','39.65','','','','','','Frequency','','Rent',0),(661,851,'','','','1.07','','','','','','','','Rent',0),(662,849,'','','','21.5','','','','','','Frequency','','Rent',0),(663,852,'','','','','','','','','','Frequency','','Rent',0),(664,855,'13/04/2020','Friday','20/04/2020','0.98','Bvvcb','','Bcbcb','vcbcbc','bcvbc','Weekly','Cash','Rent',0),(665,856,'20/04/2020','Saturday','27/04/2020','0.91','Dsfdsfs','','Fsdfdsfdsd','fsfdsf','fsdfds','Monthly','Centrepay','Rent',0),(666,857,'','','','','','','','','','Frequency','','Mortgage',0),(667,833,'','','','','','','','','','Frequency','','Loan',0),(668,859,'','','','','','','','','','Frequency','','Rent',0),(669,858,'','','','60','','','','','','Frequency','','Rent',0),(670,860,'19/05/2020','Tuesday','26/05/2020','10.94','Adsad','','Daadsada','asdasd','dasdasdsa','Fortnight','Direct Credit','Rent',0),(671,862,'19/05/2020','Tuesday','26/05/2020','10.94','Adsad','','Daadsada','asdasd','dasdasdsa','Fortnight','Direct Credit','Rent',0),(672,863,'19/05/2020','Tuesday','26/05/2020','','Adsad','','Daadsada','asdasd','dasdasdsa','Fortnight','Direct Credit','Rent',0),(673,864,'','','','479.44','','','','','','Frequency','','Rent',0),(674,866,'','','','','','','','','','Frequency','','Loan',0),(675,878,'','','','','','','','','','Frequency','','Rent',0),(676,879,'','','','1436.89','','','','','','Frequency','','Rent',0),(677,877,'','','','','','','','','','Frequency','','Rent',0),(678,880,'','','','','','','','','','Frequency','','Loan',0),(679,882,'','','','','','','','','','Frequency','','Rent',0),(680,885,'','','','0.21','','','','','','Frequency','','Rent',0),(681,883,'','','','','','','','','','Frequency','','Rent',0),(682,884,'','','','21634.22','','','','','','Frequency','','Rent',0),(683,886,'','','','','','','','','','Frequency','','Rent',0),(684,888,'10/10/2017','','30/10/2017','','','','','','','Frequency','','Loan',0),(685,896,'','','','0.21','','','','','','Frequency','','Loan',0),(686,897,'','','','0.21','','','','','','Frequency','','Loan',0),(687,898,'','','','0.21','','','','','','Frequency','','Loan',0),(688,899,'','','','','','','','','','Frequency','','Loan',0),(689,900,'','','','','','','','','','Frequency','','Loan',0),(690,901,'','','','','','','','','','Frequency','','Loan',0),(691,903,'','','','21634.22','','','','','','Frequency','','Loan',0),(692,906,'','','','17.31','','','','','','Frequency','','Loan',0),(693,907,'','','','','','','','','','Frequency','','Mortgage',0),(694,567,'','','','','','','','','','Frequency','','Rent',0),(695,867,'','','','','','','','','','Frequency','','Rent',0),(701,916,'','','','','','','','','','Frequency','','Mortgage',0),(702,917,'','','','','','','','','','Frequency','','Mortgage',0),(703,918,'','','','','','','','','','Frequency','','Mortgage',0),(704,936,'','','','','','','','','','Frequency','','Rent',0),(705,937,'','','','21634.22','','','','','','Frequency','','Rent',0),(706,938,'','','','21634.22','','','','','','Frequency','','Rent',0),(707,939,'16/07/2020','Tuesday','23/07/2020','','Ewqewqe','','Eqweq','qewqe','qeqweq','Weekly','EFT','Rent',0),(708,940,'09/07/2020','Tuesday','16/07/2020','555','Dsadsadsad','','Asdadsa','sadasd','sadsadsad','Weekly','Direct Credit','Loan',0),(709,941,'16/07/2020','Tuesday','23/07/2020','','Ewqewqe','','Eqweq','qewqe','qeqweq','Weekly','EFT','Rent',0),(710,942,'16/07/2020','Tuesday','23/07/2020','','Ewqewqe','','Eqweq','qewqe','qeqweq','Weekly','EFT','Rent',0),(711,943,'16/07/2020','Tuesday','23/07/2020','','Ewqewqe','','Eqweq','qewqe','qeqweq','Weekly','EFT','Rent',0),(712,944,'16/07/2020','Tuesday','23/07/2020','','Ewqewqe','','Eqweq','qewqe','qeqweq','Weekly','EFT','Rent',0),(713,945,'16/07/2020','Tuesday','23/07/2020','','Ewqewqe','','Eqweq','qewqe','qeqweq','Weekly','EFT','Loan',0),(714,946,'16/07/2020','Tuesday','23/07/2020','','Ewqewqe','','Eqweq','qewqe','qeqweq','Weekly','EFT','Loan',0),(715,949,'09/07/2020','Tuesday','16/07/2020','','Dsadsadsad','','Asdadsa','sadasd','sadsadsad','Weekly','Direct Credit','Rent',0),(716,950,'09/07/2020','Tuesday','16/07/2020','555','Dsadsadsad','','Asdadsa','sadasd','sadsadsad','Weekly','Direct Credit','Rent',0),(717,951,'09/07/2020','Tuesday','16/07/2020','555','Dsadsadsad','','Asdadsa','sadasd','sadsadsad','Weekly','Direct Credit','Mortgage',0),(718,948,'','','','','','','','','','Frequency','','Mortgage',0),(719,947,'','','','','','','','','','Frequency','','Mortgage',0),(720,953,'09/07/2020','Tuesday','16/07/2020','555','Dsadsadsad','','Asdadsa','sadasd','sadsadsad','Weekly','Direct Credit','Loan',0),(721,954,'16/07/2020','Tuesday','23/07/2020','','Ewqewqe','','Eqweq','qewqe','qeqweq','Weekly','EFT','Rent',0),(722,955,'16/07/2020','Tuesday','23/07/2020','','Ewqewqe','','Eqweq','qewqe','qeqweq','Weekly','EFT','Loan',0),(723,956,'16/07/2020','Tuesday','23/07/2020','','Ewqewqe','','Eqweq','qewqe','qeqweq','Weekly','EFT','Rent',0),(724,957,'16/07/2020','Tuesday','23/07/2020','','Ewqewqe','','Eqweq','qewqe','qeqweq','Weekly','EFT','Loan',0),(725,958,'16/07/2020','Tuesday','23/07/2020','','Ewqewqe','','Eqweq','qewqe','qeqweq','Weekly','EFT','Loan',0),(726,959,'16/07/2020','Tuesday','23/07/2020','','Ewqewqe','','Eqweq','qewqe','qeqweq','Weekly','EFT','Rent',0),(727,960,'16/07/2020','Tuesday','23/07/2020','','Ewqewqe','','Eqweq','qewqe','qeqweq','Weekly','EFT','Loan',0),(728,961,'16/07/2020','Tuesday','23/07/2020','','Ewqewqe','','Eqweq','qewqe','qeqweq','Weekly','EFT','Loan',0),(729,962,'16/07/2020','Tuesday','23/07/2020','','Ewqewqe','','Eqweq','qewqe','qeqweq','Weekly','EFT','Rent',0),(730,963,'16/07/2020','Tuesday','23/07/2020','','Ewqewqe','','Eqweq','qewqe','qeqweq','Weekly','EFT','Loan',0),(731,964,'09/07/2020','Wednesday','16/07/2020','3432423','Dsfdsfdsf','','Dsfsdfs','sfsdfs','fsfsf','Weekly','EFT','Mortgage',0),(732,965,'09/07/2020','Wednesday','16/07/2020','3432423','Dsfdsfdsf','','Dsfsdfs','sfsdfs','fsfsf','Weekly','EFT','Mortgage',0),(733,966,'09/07/2020','Wednesday','16/07/2020','3432423','Dsfdsfdsf','','Dsfsdfs','sfsdfs','fsfsf','Weekly','EFT','Mortgage',0),(734,967,'09/07/2020','Wednesday','16/07/2020','3432423','Dsfdsfdsf','','Dsfsdfs','sfsdfs','fsfsf','Weekly','EFT','Mortgage',0),(735,968,'09/07/2020','Wednesday','16/07/2020','3432423','Dsfdsfdsf','','Dsfsdfs','sfsdfs','fsfsf','Weekly','EFT','Mortgage',0),(736,969,'09/07/2020','Tuesday','16/07/2020','555','Dsadsadsad','','Asdadsa','sadasd','sadsadsad','Weekly','Direct Credit','Loan',0),(737,970,'09/07/2020','Tuesday','16/07/2020','555','Dsadsadsad','','Asdadsa','sadasd','sadsadsad','Weekly','Direct Credit','Loan',0),(738,971,'09/07/2020','Tuesday','16/07/2020','555','Dsadsadsad','','Asdadsa','sadasd','sadsadsad','Weekly','Direct Credit','Loan',0),(739,972,'16/07/2020','Tuesday','23/07/2020','','Ewqewqe','','Eqweq','qewqe','qeqweq','Weekly','EFT','Loan',0),(740,973,'16/07/2020','Tuesday','23/07/2020','','Ewqewqe','','Eqweq','qewqe','qeqweq','Weekly','EFT','Loan',0),(741,974,'16/07/2020','Tuesday','23/07/2020','','Ewqewqe','','Eqweq','qewqe','qeqweq','Weekly','EFT','Rent',0),(742,975,'16/07/2020','Tuesday','23/07/2020','','Ewqewqe','','Eqweq','qewqe','qeqweq','Weekly','EFT','Loan',0),(743,976,'16/07/2020','Tuesday','23/07/2020','','Ewqewqe','','Eqweq','qewqe','qeqweq','Weekly','EFT','Loan',0),(744,977,'16/07/2020','Tuesday','23/07/2020','','Ewqewqe','','Eqweq','qewqe','qeqweq','Weekly','EFT','Loan',0),(745,978,'16/07/2020','Tuesday','23/07/2020','','Ewqewqe','','Eqweq','qewqe','qeqweq','Weekly','EFT','Loan',0),(746,979,'16/07/2020','Tuesday','23/07/2020','','Ewqewqe','','Eqweq','qewqe','qeqweq','Weekly','EFT','Loan',0),(747,980,'09/07/2020','Wednesday','16/07/2020','3432423','Dsfdsfdsf','','Dsfsdfs','sfsdfs','fsfsf','Weekly','EFT','Mortgage',0),(748,981,'09/07/2020','Wednesday','16/07/2020','3432423','Dsfdsfdsf','','Dsfsdfs','sfsdfs','fsfsf','Weekly','EFT','Mortgage',0),(749,982,'09/07/2020','Wednesday','16/07/2020','3432423','Dsfdsfdsf','','Dsfsdfs','sfsdfs','fsfsf','Weekly','EFT','Mortgage',0),(750,983,'16/07/2020','Tuesday','23/07/2020','','Ewqewqe','','Eqweq','qewqe','qeqweq','Weekly','EFT','Loan',0),(751,984,'09/07/2020','Wednesday','16/07/2020','3432423','Dsfdsfdsf','','Dsfsdfs','sfsdfs','fsfsf','Weekly','EFT','Mortgage',0),(752,985,'09/07/2020','Wednesday','16/07/2020','3432423','Dsfdsfdsf','','Dsfsdfs','sfsdfs','fsfsf','Weekly','EFT','Mortgage',0),(753,986,'09/07/2020','Wednesday','16/07/2020','3432423','Dsfdsfdsf','','Dsfsdfs','sfsdfs','fsfsf','Weekly','EFT','Mortgage',0),(754,987,'09/07/2020','Wednesday','16/07/2020','3432423','Dsfdsfdsf','','Dsfsdfs','sfsdfs','fsfsf','Weekly','EFT','Mortgage',0),(755,988,'09/07/2020','Wednesday','16/07/2020','3432423','Dsfdsfdsf','','Dsfsdfs','sfsdfs','fsfsf','Weekly','EFT','Mortgage',0),(756,989,'09/07/2020','Wednesday','16/07/2020','3432423','Dsfdsfdsf','','Dsfsdfs','sfsdfs','fsfsf','Weekly','EFT','Mortgage',0),(757,990,'09/07/2020','Wednesday','16/07/2020','3432423','Dsfdsfdsf','','Dsfsdfs','sfsdfs','fsfsf','Weekly','EFT','Mortgage',0),(758,991,'09/07/2020','Wednesday','16/07/2020','3432423','Dsfdsfdsf','','Dsfsdfs','sfsdfs','fsfsf','Weekly','EFT','Mortgage',0),(759,992,'09/07/2020','Wednesday','16/07/2020','3432423','Dsfdsfdsf','','Dsfsdfs','sfsdfs','fsfsf','Weekly','EFT','Mortgage',0),(760,993,'09/07/2020','Wednesday','16/07/2020','3432423','Dsfdsfdsf','','Dsfsdfs','sfsdfs','fsfsf','Weekly','EFT','Mortgage',0),(761,994,'09/07/2020','Wednesday','16/07/2020','3432423','Dsfdsfdsf','','Dsfsdfs','sfsdfs','fsfsf','Weekly','EFT','Mortgage',0),(762,995,'09/07/2020','Wednesday','16/07/2020','3432423','Dsfdsfdsf','','Dsfsdfs','sfsdfs','fsfsf','Weekly','EFT','Mortgage',0),(763,996,'09/07/2020','Wednesday','16/07/2020','3432423','Dsfdsfdsf','','Dsfsdfs','sfsdfs','fsfsf','Weekly','EFT','Mortgage',0),(764,997,'09/07/2020','Wednesday','16/07/2020','3432423','Dsfdsfdsf','','Dsfsdfs','sfsdfs','fsfsf','Weekly','EFT','Mortgage',0),(765,1749,'','','','','','','','','','Frequency','','Mortgage',0),(766,1795,'','','','','','','','','','Frequency','','Mortgage',0),(767,1794,'','','','','','','','','','Frequency','','Mortgage',0),(768,1817,'','','','','','','','','','Frequency','','Rent',0),(769,1818,'','','','','','','','','','Frequency','','Mortgage',0),(770,1820,'','','','','','','','','','Frequency','','Mortgage',0),(771,1826,'','','','','','','','','','Frequency','','Mortgage',0),(772,1828,'','','','','','','','','','Frequency','','Loan',0),(773,569,'','','','','','','','','','Frequency','','Rent',0),(774,1810,'','','','','','','','','','Frequency','','Loan',0),(775,1829,'','','','','','','','','','Frequency','','Loan',0),(776,1827,'','','','','','','','','','Frequency','','Mortgage',0),(777,1843,'','','','','','','','','','Frequency','','Mortgage',0),(778,1842,'','','','','','','','','','Frequency','','Rent',0),(779,1844,'','','','','','','','','','Frequency','','Loan',0),(780,1858,'03/11/2020','Monday','10/11/2020','2001','Fsdf','','Fsdfsf','sfsd','fsdfs','Weekly','EFT','Loan',0),(781,1890,'','','','','','','','','','Frequency','','Loan',0),(782,12523,'10/11/2020','Tuesday','17/11/2020','234234','Fsdf','','Sfsfs','sfsdfs','fsf','Monthly','Direct Credit','Loan',0),(783,21392,'','','','','','','','','','Frequency','','Loan',0);

--
-- Table structure for table `benefits_client1`
--

CREATE TABLE `benefits_client1` (
  `benefits_id_client1` int(11) NOT NULL AUTO_INCREMENT,
  `full_time` varchar(150) NOT NULL,
  `part_time` varchar(150) NOT NULL,
  `casual` varchar(150) NOT NULL,
  `other_income` varchar(200) NOT NULL,
  `loan_rent_id` int(11) NOT NULL,
  `type` varchar(150) NOT NULL COMMENT 'loan/rent',
  `career` varchar(150) NOT NULL,
  `career2` varchar(200) NOT NULL,
  `disability` varchar(200) NOT NULL,
  `parenting` varchar(200) NOT NULL,
  `large_family` varchar(220) NOT NULL,
  `family_a` varchar(150) NOT NULL,
  `family_b` varchar(255) NOT NULL,
  `rent_assist` varchar(255) NOT NULL,
  `pharmacutical` varchar(225) NOT NULL,
  `suppliment` varchar(225) NOT NULL,
  `phone` varchar(200) NOT NULL,
  `child_maintainence` varchar(200) NOT NULL,
  `board_received` varchar(200) NOT NULL,
  `additional_income` varchar(200) NOT NULL,
  `delete_status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`benefits_id_client1`)
) ENGINE=InnoDB AUTO_INCREMENT=638 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `benefits_client1`
--

INSERT INTO `benefits_client1` VALUES (1,'','0','','',1,'Loan','','','','','','','','','','','','','','',0),(2,'','','','',2,'Loan','','','','','','','','','','','','','','',0),(3,'','0','','',3,'Loan','','','','145','','392','155','','','','','','','',0),(4,'','0','','',4,'Loan','','','','','','','','','','','','','','',0),(5,'','0','644','',5,'Loan','','','','','','109','202','','','','','','','',0),(6,'','','','',6,'Loan','','','','','','','','','','','','','','',0),(7,'','0','','',7,'Loan','','','','','','','','','','','','','','',0),(8,'','0','','',8,'Loan','','','','','','','','','','','','','','',0),(9,'','','','',9,'Loan','','','','','','','','','','','','','','',0),(10,'','0','','',10,'Loan','','','','','','','','','','','','','','',0),(11,'','0','','',11,'Loan','','','','','','','','','','','','','540','70',0),(12,'','0','','',12,'Loan','','','','','','','','','','','','','','50',0),(13,'','0','','1035',13,'Loan','','','','','','','','','','','','','','',0),(14,'','','','',14,'Loan','','','','','','','','','','','','','','',0),(15,'','0','','',15,'Loan','','','','','','','','','','','','','','',0),(16,'','0','','',16,'Loan','','','','','','','','','','','','','','',0),(17,'','0','','',17,'Loan','','','','','','','','','','','','','','',0),(18,'','0','','',18,'Loan','','','','','','','','','','','','','230','',0),(19,'','','','',19,'Loan','','','','','','','','','','','','','','',0),(20,'','0','','',20,'Loan','','','','','','','','','','','','','','',0),(21,'','','','',21,'Loan','','','','','','','','','','','','','','',0),(22,'','0','','',22,'Loan','','','','','','','','','','','','','','',0),(23,'','','','',23,'Loan','','','','','','','','','','','','','','',0),(24,'','','69','',24,'Loan','130','257','','','','355','156','86','','10','','150','','100',0),(25,'','0','','',25,'Loan','','','','','','','','','','','','','','',0),(26,'','','','',26,'Loan','','','','','','','','','','','','','','',0),(27,'','0','','',27,'Loan','','','','','','','','','','','','','','',0),(28,'','0','521','',28,'Loan','','','','','','','','','','','','','','',0),(29,'','0','','',29,'Loan','','','','','','','','','','','','','','',0),(30,'','0','','',30,'Loan','','','','','','','','','','','','','','400',0),(31,'','0','843','',31,'Loan','129','','','','','242','110','161','','68','','','','',0),(32,'','','','',6,'Loan','','','','','','','','','','','','','','',0),(33,'','0','','',33,'Loan','','','','','','','','','','','','','','',0),(34,'','0','','',34,'Loan','','','904','','','','','','','','','','','',0),(35,'','','','',35,'Loan','','','','','','','','','','','','','','',0),(36,'','0','','',36,'Loan','','','','','','','','','','','','','','',0),(37,'','0','','',37,'Loan','','','','','','','','','','','','','','',0),(38,'','0','','',38,'Loan','','','350','','','','','','','','','','','50',0),(39,'','0','','',39,'Loan','','','','','','','','','','','','','150','',0),(40,'','','','',9,'Loan','','','','','','','','','','','','','','',0),(41,'','0','','',40,'Loan','','','','','','','','','','','','','','',0),(42,'','','','',14,'Loan','','','','','','','','','','','','','','',0),(43,'','','','',23,'Loan','','','','','','','','','','','','','','',0),(44,'','0','','',41,'Loan','945','127','','','','','','','','','','','','',0),(45,'','0','','',42,'Loan','','','548','','','','','','','','','','','',0),(46,'','','','',23,'Loan','','','','','','','','','','','','','','',0),(47,'','0','','',43,'Loan','','','','','','','','','','','','','','',0),(48,'','','','',44,'Loan','','','','','','','','','','','','','','',0),(49,'','','','',45,'Loan','127.1','724.1','','','','','','','','','','','250','',0),(50,'','0','','',46,'Loan','','','','','','','','','','','','','','',0),(51,'','','','',47,'Loan','','','','','','','','','','','','','','',0),(52,'','0','','',48,'Loan','','','','','','','','','','','','','','',0),(53,'','0','','',49,'Loan','','','','','','','','','','','','','','400',0),(54,'','0','','',50,'Loan','','','','','','','','','','','','','','',0),(55,'','0','','',51,'Loan','','','','','','','','','','','','','100','',0),(56,'','','','',52,'Loan','','','','','','','','','','','','','','',0),(57,'','0','','',53,'Loan','','','','','','','','','','','','','','',0),(58,'','','','',54,'Loan','','','','','','','','','','','','','','',0),(59,'','0','','',55,'Loan','','','','','','','','','','','','','','',0),(60,'','0','','',56,'Loan','','','','','','','','','','','','','','',0),(61,'','0','','',57,'Loan','','','','','','','','','','','','','','',0),(62,'','','','',58,'Loan','','','','','','','','','','','','','','',0),(63,'601','0','','',59,'Loan','','','','','','40','15','7','6','','','326','','',0),(64,'','0','','',60,'Loan','','','','','','','','','','','','','','',0),(65,'','0','','',61,'Loan','','','','','','','','','','','','','','',0),(66,'','','','',62,'Loan','','','','','','','','','','','','','400','',0),(67,'','0','','',63,'Loan','','','','','','','','','','','','','','',0),(68,'','','','',64,'Loan','','','','','','','','','','','','','','',0),(69,'','0','','',65,'Loan','','','','','','','','','','','','','','',0),(70,'','0','','',66,'Loan','','','','','','','','','','','','','','120',0),(71,'','0','','',67,'Loan','','','','','','','','','','','','','','',0),(72,'','','','',68,'Loan','','','','','','','','','','','','','','',0),(73,'','0','','',69,'Loan','','','','','','','','','','','','','','',0),(74,'','0','','',70,'Loan','','','','','','','','','','','','','','',0),(75,'','0','826','14',71,'Loan','45','','','','','','','','','67','','','','',0),(76,'','0','','',72,'Loan','','','','','','','','','','','','','','',0),(77,'','','','',73,'Loan','','','','','','','','','','','','','','',0),(78,'','0','','',74,'Loan','','','','','','','','','','','','','','',0),(79,'','','','',75,'Loan','','','','','','','','','','','','','','',0),(80,'','','','',76,'Loan','','','','','','','','','','','','','','',0),(81,'','0','','',77,'Loan','','','','','','','','','','','','','','',0),(82,'','0','','',78,'Loan','','','','','','','','','','','','','','',0),(83,'','0','','',79,'Loan','','','','','','','','','','','','','','',0),(84,'','0','','',80,'Loan','','','','','','','','','','','','','','',0),(85,'','0','','',81,'Loan','','','','','','','','','','','','','','',0),(86,'','','','',82,'Loan','','','','','','','','','','','','','','',0),(87,'','0','','',83,'Loan','','','','','','','','','','','','','','',0),(88,'','','','',84,'Loan','','','','','','','','','','','','','','',0),(89,'','0','','',85,'Loan','','','','','','','','','','','','','','',0),(90,'','0','597','',86,'Loan','','','','','','','','','','','','','','',0),(91,'','0','','',87,'Loan','','','','','','','','','','','','','','',0),(92,'','0','','',88,'Loan','','','','','','','','','','','','','','',0),(93,'','','','',89,'Loan','','','127','','','','','','','','','','','',0),(94,'','','','',90,'Loan','','','','','','','','','','','','','','',0),(95,'','','','',91,'Loan','','','','','','','','','','','','','','',0),(96,'','0','','',92,'Loan','','','','','','','','','','','','','','',0),(97,'','0','','',93,'Loan','','','953','','','','','','','','','','','',0),(98,'','','','',94,'Loan','','','','','','','','','','','','','','',0),(99,'','','','',95,'Loan','','','','','','','','','','','','','','',0),(100,'','0','','',96,'Loan','','','','','','140','108','','','','','110','','',0),(101,'','0','','',98,'Loan','','','','','','','','','','','','','','',0),(102,'','0','','',99,'Loan','','','','','','','','','','','','','','',0),(103,'','0','','',100,'Loan','','','','','','','','','','','','','','',0),(104,'','0','','',101,'Loan','','','','','','','','','','','','','','',0),(105,'','0','','',102,'Loan','','','','','','','','','','','','','','',0),(106,'','0','','',103,'Loan','','','','','','','','','','','','','','',0),(107,'','','','',104,'Loan','','','','','','','','','','','','','','',0),(108,'','0','','',105,'Loan','','','','','','','','','','','','','','',0),(109,'','0','','',106,'Loan','','','','','','','','','','','','','','',0),(110,'','','','',107,'Loan','','','','','','','','','','','','','','',0),(111,'','0','','',108,'Loan','','','','','','','','','','','','','','',0),(112,'','','826','14',109,'Loan','','','','','','','','135','','67','','','','',0),(113,'','','','',110,'Loan','','','','','','','','','','','','','','',0),(114,'','0','','',111,'Loan','','','924','','','','','','','','','','','',0),(115,'','','','',112,'Loan','','','','','','','','','','','','','','',0),(116,'','','','',113,'Loan','','','','','','','','','','','','','','',0),(117,'','','','',114,'Loan','','','','','','','','','','','','','','',0),(118,'','0','','',115,'Loan','','','','','','','','','','','','','','',0),(119,'','','','',116,'Loan','','','','','','','','','','','','','','',0),(120,'','0','','',117,'Loan','','','','','','','','','','','','','','',0),(121,'','','','',118,'Loan','','','','','','','','','','','','','','',0),(122,'214','0','','',119,'Loan','','','','','','','','','','','','','100','',0),(123,'','0','','',120,'Loan','','127','651','','','','','','','','','','','',0),(124,'','0','','',121,'Loan','','','','','','','','','','','','','','100',0),(125,'','0','','',122,'Loan','','','','','','','','','','','','','','',0),(126,'','','','',123,'Loan','','','','','','','','','','','','','','',0),(127,'','0','','',124,'Loan','254','','132','','902','110','','','','','','','50','',0),(128,'','','','',125,'Loan','','','','','','','','','','','','','','',0),(129,'','','','',126,'Loan','','','','','','','','','','','','','','',0),(130,'','','','',127,'Loan','','','','','','','','','','','','','','',0),(131,'','','','',128,'Loan','','','','','','','','','','','','','','',0),(132,'','','','',129,'Loan','','','','','','','','','','','','','','',0),(133,'','0','','',130,'Loan','','','','','','','','','','','','','100','',0),(134,'','','','',131,'Loan','','','','','','','','','','','','','','99',0),(135,'','0','','',132,'Loan','','','','','','','','','','','','','','',0),(136,'','','','',133,'Loan','','','','','','','','','','','','','','',0),(137,'','0','','',134,'Loan','','','','','','','','','','','','','','',0),(138,'','','','',135,'Loan','','','','','','','','','','','','','','',0),(139,'','','','',136,'Loan','','','','','','','','','','','','','','',0),(140,'','0','','',137,'Loan','','','','','','','','','','','','','','',0),(141,'','','504','',138,'Loan','','','','','','','','','','','','','','500',0),(142,'','0','953.1','',139,'Loan','','','','','','','','','','','','','100','',0),(143,'','','','',140,'Loan','','','','','','173','','','','','','','','',0),(144,'','','925','',141,'Loan','','','','','','','','','','','','','','',0),(145,'','0','','',142,'Loan','','','','','','','','','','','','','','',0),(146,'','0','','',143,'Loan','','','','157.8','','110.6','','','','','','','','',0),(147,'','','648','',144,'Loan','','','','','','','','','','','','','','',0),(148,'','','','',145,'Loan','','','','','','','','','','','','','','',0),(149,'','0','','',146,'Loan','','','','','','','','','','','','','','',0),(150,'','','916','',147,'Loan','','','','','','','','','','','','','200','',0),(151,'','0','','',148,'Loan','','','','','','','','','','','','','','',0),(152,'','0','','',149,'Loan','','','','','','','','','','','','','','',0),(153,'','0','','',150,'Loan','','','','','','','','','','','','','','',0),(154,'572','','','',151,'Loan','','','','','','571','110','','','','','8','','',0),(155,'','0','','',152,'Loan','','','','','','','','','','','','','','',0),(156,'','0','','',153,'Loan','','','','','','','','','','','','','','',0),(157,'','0','','',154,'Loan','','','','','','','','','','','','','','',0),(158,'','','','',155,'Loan','','','','','','','','','','','','','','',0),(159,'','0','','',156,'Loan','','','','','','','','','','','','','','',0),(160,'','','1052','',157,'Loan','','','','','','','','','','','','','','',0),(161,'','0','','',158,'Loan','','','','','','','','','','','','','','',0),(162,'','','','',159,'Loan','','','','','','','','','','','','','','',0),(163,'','0','','',160,'Loan','','','','','','','','','','','','','','',0),(164,'','','','',161,'Loan','','','','','','','','','','','','','','',0),(165,'','0','','',162,'Loan','','','','','','','','','','','','','','',0),(166,'','','','',163,'Loan','','','','','','','','','','','','','','',0),(167,'','0','','',164,'Loan','','','','','','','','','','','','','','',0),(168,'','','','',165,'Loan','','','','','','','','','','','','','','',0),(169,'','','','',166,'Loan','','','','','','','','','','','','','','',0),(170,'','0','','',167,'Loan','','','','','','','','','','','','','','',0),(171,'601.1','0','','',168,'Loan','','','','','','','','137.2','','15','','','','',0),(172,'','0','','',169,'Loan','','','','','','','','','','','','','','',0),(173,'','','','',170,'Loan','','','','741','','103','155','','','','','','','',0),(174,'','','','',171,'Loan','130','834','','','','202','108','130','','67','','186','100','195',0),(175,'','','','',172,'Loan','','','','','','','','','','','','','','',0),(176,'','','','',173,'Loan','','','','','','','','','','','','','','',0),(177,'','','515','',174,'Loan','','','','','','','','','','','','','','',0),(178,'','0','','',175,'Loan','','','','','107','162','','','','','','','','',0),(179,'','','','',176,'Loan','','','','','','','','','','','','','','',0),(180,'','','','',177,'Loan','','','','','','','','','','','','','','',0),(181,'','','','',178,'Loan','','','','','','','','','','','','','','',0),(182,'','','','',179,'Loan','','','','','','','','','','','','','','',0),(183,'','31','','',180,'Loan','','','','','','55','60','','','','','','','',0),(184,'','575','','',181,'Loan','127','','','','','','','','','','','','','',0),(185,'','','492','',182,'Loan','','','','','','','','','','','','','','',0),(186,'','0','','',183,'Loan','','','','','','','','','','','','','','147',0),(187,'','','','',184,'Loan','','','','','','','','','','','','','','',0),(188,'382','0','','61',185,'Loan','','','','','','275','110','','','','','','','',0),(189,'','0','','',186,'Loan','','','','','','','','','','','','','','',0),(190,'','0','','',187,'Loan','','','','','','','','','','','','','','',0),(191,'','','','',188,'Loan','','','','','','','','','','','','','','',0),(192,'','','','',189,'Loan','','','','','','','','','','','','','','',0),(193,'','','','',190,'Loan','','','','','','','','','','','','','','',0),(194,'','','','',191,'Loan','','','826','','','','','','','67','','','','',0),(195,'','','','',192,'Loan','','','','','','','','','','','','','','',0),(196,'','','','',193,'Loan','','','','','','','','','','','','','','',0),(197,'','','','',194,'Loan','','','','','','','','','','','','','','',0),(198,'','','','',195,'Loan','','','','','','','','','','','','','','',0),(199,'','','','',196,'Loan','','','','','','','','','','','','','','',0),(200,'','','','',197,'Loan','','','','','','','','','','','','','','',0),(201,'','','','',198,'Loan','','','','','','','','','','','','','','',0),(202,'','','','',199,'Loan','','','','','','','','','','','','','','',0),(203,'','','','',200,'Loan','','','','','','','','','','','','','','',0),(204,'','0','','',201,'Loan','','','','436.4','','787.5','158.34','','','','','','','',0),(205,'','','','',202,'Loan','','','','','','','','','','','','','','',0),(206,'','0','','',203,'Loan','','','','','','','','','','','','','','',0),(207,'','','','',204,'Loan','','','','','','128','','','','','','','','',0),(208,'','','','',205,'Loan','','','','','','','','','','','','','','',0),(209,'','','','',206,'Loan','127','','','','','','','','','','','','','',0),(210,'','','','',207,'Loan','','','','','','','','','','','','','','',0),(211,'','0','','',208,'Loan','','','','','224','','','','','','','','','',0),(212,'','','','',209,'Loan','','','','','','','','','','','','','','',0),(213,'','','','',210,'Loan','','','','','','','','','','','','','','',0),(214,'','','','',211,'Loan','127','622','','','','182','109','','','','','','','',0),(215,'','','','',212,'Loan','','','','','','','','','','','','','','',0),(216,'','0','','',213,'Loan','','','','','','','','','','','','','','',0),(217,'','','','',214,'Loan','','','','','','','','','','','','','','',0),(218,'','','368','',215,'Loan','','','','','','','','','','','','','','',0),(219,'','','','',216,'Loan','','','','','','','','','','','','','','',0),(220,'','','','',217,'Loan','','','','','','','','','','','','','','',0),(221,'','','','',215,'Loan','127.1','507.8','','','','155.54','155.26','','','','','100','','',0),(222,'','','','',218,'Loan','','','','','','','','','','','','','','',0),(223,'579','','','',219,'Loan','','','','','','238','109','','6','','','15','','',0),(224,'','','','',220,'Loan','664','','','','','','','','','','','','','',0),(225,'','0','','',221,'Loan','','','','','','','','','','','','','','',0),(226,'','','816.3','',222,'Loan','','','','','','','','','','','','','','',0),(227,'','','','',223,'Loan','','','','','','','','','','','','','','',0),(228,'','','','',224,'Loan','','','','','','','','','','','','','','',0),(229,'','0','','',225,'Loan','','','','','','','','','','','','','','',0),(230,'','','','',226,'Loan','127.1','507.8','','','','155.54','155.26','','','','','100','','',0),(231,'','','','',227,'Loan','','','','','','','','','','','','','','',0),(232,'','0','','',228,'Loan','','','','','','','','','','','','','','',0),(233,'','0','','',229,'Loan','','','','','','','','','','','','','','',0),(234,'','','','',230,'Loan','','','','','','','','','','','','','','',0),(235,'','0','','',231,'Loan','','','','','','','','','','','','','','530',0),(236,'','','','',232,'Loan','','','','','','','','','','','','','','',0),(237,'','','','',233,'Loan','','','','','','','','','','','','','','',0),(238,'','','458','',234,'Loan','','','','','','','','','','','','','','',0),(239,'','','','',235,'Loan','','','','','','','','','','','','','','',0),(240,'','','','',236,'Loan','','','','','','','','','','','','','','',0),(241,'382','0','','',237,'Loan','','','','','','','','','','','','','','',0),(242,'','0','','',238,'Loan','','','','','','','','','','','','','','',0),(243,'','','','',239,'Loan','','','','','','','','','','','','','','',0),(244,'','','','',240,'Loan','','','','','','','','','','','','','','',0),(245,'','0','','',241,'Loan','','','','','','','','','','','','','','',0),(246,'','','','',242,'Loan','','','','','','','','','','','','','','',0),(247,'','','','',243,'Loan','','','','','','','','','','','','','','',0),(248,'','','','',244,'Loan','','','','','','','','','','','','','','350',0),(249,'','','','',245,'Loan','','','','272','95','','','','','','','','','',0),(250,'','','','',246,'Loan','','','','','','','','','','','','','','',0),(251,'','','','',247,'Loan','','','','','','','','','','','','','','',0),(252,'590','','','',248,'Loan','','','','','','','','','6','10','','','100','',0),(253,'','0','','',249,'Loan','','','','','','','','','','','','','','',0),(254,'','','','',250,'Loan','','','','','','','','','','','','','','',0),(255,'','','','',251,'Loan','','','','','','','','','','','','','','',0),(256,'','','','',252,'Loan','','','655','','','','','','','','','','','',0),(257,'','','','',253,'Loan','','','','','','','','','','','','','','',0),(258,'','0','','',254,'Loan','129','944','','','','','','','','','','','','',0),(259,'','','','',255,'Loan','','','','','','','','','','','','','','',0),(260,'','0','','',256,'Loan','','','','','','','','','','','','','','',0),(261,'','','','',257,'Loan','','','','','','','','','','','','','','',0),(262,'','','','',258,'Loan','','','','','','','','','','','','','','',0),(263,'','0','','',259,'Loan','127.1','498.6','','','','','','','','','','','','',0),(264,'','','','',260,'Loan','','','609','','','','','','','','','','','',0),(265,'','0','','',261,'Loan','','','','','','','','','','','','','','',0),(266,'','0','920','',262,'Loan','','','','','','','','','','','','','','',0),(267,'','','397','',263,'Loan','','','','','','','','','','','','','','',0),(268,'','','','',264,'Loan','','','','','','','','','','','','','','',0),(269,'','','','',265,'Loan','','','','','','','','','','','','','','',0),(270,'','','916.30','',266,'Loan','','','','','','','','','','','','','','',0),(271,'','','','',267,'Loan','','','','','','','','','','','','','','',0),(272,'','','','',268,'Loan','','','','','','','','','','','','','','',0),(273,'','','','',269,'Loan','','','','','','','','','','','','','','',0),(274,'','','','',270,'Loan','','','','','','','','','','','','','','',0),(275,'','','','',271,'Loan','','','834','','','','','','','68','','','100','',0),(276,'','','','',272,'Loan','','','815','','','','','','','','','','','',0),(277,'','','','',273,'Loan','','','','','','','','','','','','','50','',0),(278,'857','0','','',274,'Loan','','','','','','','','','','','','','','',0),(279,'','','','',275,'Loan','','','','','','','','','','','','','','',0),(280,'','','','',276,'Loan','','','','','','','','','','','','','','',0),(281,'','','','',277,'Loan','130','','','','','','','','','','','','','',0),(282,'','','','',278,'Loan','','','','','','','','','','','','','','',0),(283,'','','','',279,'Loan','','','','','','','','','','','','','','120',0),(284,'','0','','664',280,'Loan','','','931','','','','','','','','','','','',0),(285,'','0','','',281,'Loan','','','','','','','','','','','','','','',0),(286,'','','','',282,'Loan','','','','','','','','','','','','','','',0),(287,'','','','',283,'Loan','260','843','','','','','','136','','68','','','','',0),(288,'605','','','',284,'Loan','','','','','','','','','','','','','','',0),(289,'','','','',285,'Loan','','','','','','','','','','','','','150','',0),(290,'474','0','','',286,'Loan','','','','','','','','','','','','','200','',0),(291,'','','','',287,'Loan','','','','','','','','','','','','','','130',0),(292,'','','','',288,'Loan','','','','','','466','110','','','','','','','',0),(293,'','0','','',289,'Loan','','','','395','','67','9','','','','','','','',0),(294,'','','','',290,'Loan','','','','','','','','','','','','','','',0),(295,'','','','',291,'Loan','','','','','','','','','','','','','','',0),(296,'','','','',292,'Loan','','','','','','','','','','','','','','',0),(297,'','','','',293,'Loan','','','','','','','','','','','','','','',0),(298,'','','','',294,'Loan','','','','','','','','','','','','','','',0),(299,'','','','',295,'Loan','','','','','','','','','','','','','','',0),(300,'','','','',296,'Loan','','','','','','','','','','','','','','',0),(301,'','','','',297,'Loan','','','','','','336','110','','','','','','340','',0),(302,'','0','','',298,'Loan','','','','','','','','','','','','','','',0),(303,'','','','',299,'Loan','','','','','','','','','','','','','','',0),(304,'','','','',300,'Loan','','','','','','','','','','','','','','',0),(305,'','','','',301,'Loan','','','','','','','','','','','','','','',0),(306,'','','','',302,'Loan','','','','','','','','','','','','','','',0),(307,'','','','',303,'Loan','','','','','','','','','','','','','','',0),(308,'','','','',304,'Loan','','','','','','','','','','','','','','',0),(309,'','','','',305,'Loan','','','','','','','','','','','','','150','',0),(310,'','','','',306,'Loan','','','','','','','','','','','','','130','',0),(311,'','0','831','14',307,'Loan','','','','','','','','','','68','','','','300',0),(312,'','0','','',308,'Loan','','','','','','','','','','','','','','',0),(313,'','','','',309,'Loan','','','','','','','','','','','','','','',0),(314,'','','','',310,'Loan','','','','','','','','','','','','','','',0),(315,'','','','',311,'Loan','','','','','','','','','','','','','','',0),(316,'','','','',312,'Loan','','','','','','','','','','','','','','',0),(317,'','','','',313,'Loan','','','','','','','','','','','','','','',0),(318,'','0','762.7','',314,'Loan','','','','','','','','','','','','','200','',0),(319,'','','797','',315,'Loan','','','','','','','','','','','','','','',0),(320,'','','','',316,'Loan','','','','','','','','','','','','','','',0),(321,'','','','',317,'Loan','','','','','','','','','','','','','','',0),(322,'','','','',318,'Loan','','','','','','','','','','','','','','',0),(323,'','','','',319,'Loan','','','','','','','','','','','','','','',0),(324,'','','','',320,'Loan','','','','','','','','','','','','','','',0),(325,'','','','',321,'Loan','','','','','','','','','','','','','','',0),(326,'','','','',322,'Loan','127.1','254.2','','','','603.54','108.64','','','13.38','','','','',0),(327,'384','','','',323,'Loan','','','','41','','110','','','','','','','','',0),(328,'','','','',324,'Loan','','','','','','','','','','','','','','',0),(329,'','','','',325,'Loan','','','','','','','','','','','','','','',0),(330,'','','','',326,'Loan','','','','','','','','','','','','','','',0),(331,'','','','',327,'Loan','','','','740','','252','158','','','','','','','',0),(332,'','','','',328,'Loan','','','','','','','','','','','','','','',0),(333,'','0','','',329,'Loan','','','','','','','','','','','','','','',0),(334,'','','','',330,'Loan','','','','','','','','','','','','','','',0),(335,'','','','',331,'Loan','','','','','','','','','','','','','','',0),(336,'','0','','',332,'Loan','','','','','','','','','','','','','','',0),(337,'','0','','',333,'Loan','','','','','','','','','','','','','','',0),(338,'','','','',334,'Loan','','','','','','','','','','','','','200','',0),(339,'','','','',335,'Loan','','','','','','','','','','','','','','',0),(340,'','0','850','',336,'Loan','','','','','','','','92','','14','69','','200','',0),(341,'','','','',337,'Loan','','','','','','','','','','','','','','',0),(342,'','','593','',338,'Loan','','','','','','','','','','','','','','',0),(343,'','','613','',339,'Loan','','','','','','','','','','','','','','',0),(344,'','','','',340,'Loan','','','','','','','','','','','','','','',0),(345,'','','','',341,'Loan','','','','','','','','','','','','','','',0),(346,'','','','',342,'Loan','','','','','','','','','','','','','150','',0),(347,'','0','','',343,'Loan','','','','','','','','','','','','','','',0),(348,'','','','',344,'Loan','','','','','','','','','','','','','','',0),(349,'','0','','',345,'Loan','','','','','','','','','','','','','','',0),(350,'','0','','',346,'Loan','','','','','','','','','','','','','','',0),(351,'','','','',347,'Loan','','','','','','','','','','','','','','',0),(352,'','','','',348,'Loan','','','','','','','','','','','','','','',0),(353,'','0','','',349,'Loan','','','','','','','','','','','','','','',0),(354,'','0','','',350,'Loan','','','','','','','','','','','','','','',0),(355,'','0','1052','',351,'Loan','','','','','','','','','','','','','','',0),(356,'','','','',352,'Loan','','','','','','','','','','','','','','',0),(357,'','','','',353,'Loan','','','','','','','','','','','','','','',0),(358,'','','69','',354,'Loan','675','129','','','','','','137','','14','','','','',0),(359,'','','','',355,'Loan','','','','','','','','','','','','','','',0),(360,'','0','','',356,'Loan','','','','','','','','','','','','','','',0),(361,'','','','',357,'Loan','','','','','','','','','','','','','','',0),(362,'','','24','',358,'Loan','','','','397','','60','158','','6','12','','','','207',0),(363,'','','','',359,'Loan','','','','','','','','','','','','','','',0),(364,'','0','','',360,'Loan','','','','','','','','','','','','','','',0),(365,'','','','',361,'Loan','','','844','','','','','','','68','','','','181',0),(366,'','','','',362,'Loan','','','587','','','','','','','','','','','',0),(367,'','','','',363,'Loan','','','','','','','','','','','','','','250',0),(368,'','','','',364,'Loan','','','','','','','','','','','','','','',0),(369,'','','','',365,'Loan','','','','','','','','','','','','','100','',0),(370,'','','','',366,'Loan','','','','','','','','','','','','','','',0),(371,'','','825','',367,'Loan','','','','','','','','','','','','','','',0),(372,'','','','',368,'Loan','','','','','','','','','','','','','','',0),(373,'','','','',369,'Loan','','','','','171','107','','','','','','','500','',0),(374,'','','','',370,'Loan','','','','','','','','','','','','','','',0),(375,'','0','','',371,'Loan','','','','','','','','','','','','','','',0),(376,'','','68','',372,'Loan','','','844','','','','','137','','','','','','7',0),(377,'','','698','',373,'Loan','','','','','','','','','','','','','','',0),(378,'','','','',374,'Loan','','','','','','','','','','','','','','',0),(379,'','0','68','',375,'Loan','','','827','','','','','135','','15','','','','',0),(380,'','0','','',376,'Loan','','','','','','','','','','','','','','',0),(381,'','','','',377,'Loan','','','','','','540.82','','','','','','','','',0),(382,'','','','',378,'Loan','','84','','','598','158','','','','','','','','',0),(383,'','','','',379,'Loan','','','','','','','','','','','','','','',0),(384,'','','','',380,'Loan','','','','','','','','','','','','','','',0),(385,'','','','',381,'Loan','','','','','','','','','','','','','','',0),(386,'','0','','',382,'Loan','','','','','','','','','','','','','','',0),(387,'','','','',383,'Loan','','','','','','','','','','','','','','',0),(388,'','','','',384,'Loan','','','','','','','','','','','','','','',0),(389,'','','','',385,'Loan','','','','','','','','','','','','','','',0),(390,'','','','',386,'Loan','','','','','','','','','','','','','','',0),(391,'','','','',387,'Loan','','','','','','','','','','','','','','',0),(392,'','','','',388,'Loan','','','','','','','','','','','','','','',0),(393,'','0','','',389,'Loan','','','','','','','','','','','','','','',0),(394,'','','','',390,'Loan','','','','','','','','','','','','','','',0),(395,'','','','',395,'Loan','','','','','','','','','','','','','','',0),(396,'','0','','',396,'Loan','','','','','','','','','','','','','','',0),(397,'','0','','',399,'Loan','','','','','','','','','','','','','','',0),(399,'','','','',402,'Loan','','','','','','','','','','','','','','',0),(400,'','','','',399,'Loan','','','','','','','','','','','','','','',0),(401,'','','','',399,'Loan','','','','','','','','','','','','','','',0),(402,'','','','',399,'Loan','','','','','','','','','','','','','','',0),(403,'','','','',399,'Loan','','','','','','','','','','','','','','',0),(404,'','','','',399,'Loan','','','','','','','','','','','','','','',0),(405,'','','','',404,'Loan','','','','','','','','','','','','','','',0),(406,'','','','',405,'Loan','','','','','','','','','','','','','','',0),(407,'','0','','',406,'Loan','','','','','','','','','','','','','','',0),(408,'','0','729','',407,'Loan','130','','','','','','','','','','','','','',0),(409,'578','','','',408,'Loan','','','','','','','','','6','10','','','100','',0),(410,'','','','',409,'Loan','','129','388','','','','','','','','','','','',0),(411,'','0','','',411,'Loan','','','','','','','','','','','','','','',0),(412,'','0','','',412,'Loan','','','','','','','','','','','','','','',0),(413,'5','6','7','8',413,'Loan','9','10','11','13','14','15','16','18','19','20','22','24','25','26',0),(414,'5','6','7','8',414,'Loan','9','10','11','13','14','15','16','18','19','20','22','24','25','26',0),(415,'','','','',415,'Rent','','','','','','','','','','','','','','',0),(416,'','0','','',416,'Loan','','','','','','','','','','','','','','',0),(417,'','','','',417,'Loan','','','','','','','','','','','','','','',0),(418,'5','0','7','8',418,'Loan','9','10','11','13','14','15','16','18','19','20','22','24','25','26',0),(421,'','0','','',420,'Loan','','','','','','613','112','','','','','','','',0),(422,'','0','','',421,'Loan','','','','','','','','','','','','','','',0),(423,'5','6','7','8',422,'Loan','9','10','11','13','14','15','16','18','19','20','22','24','25','26',0),(424,'','','630','',423,'Loan','130','','','','','','','','','','','','','',0),(425,'','','990','',423,'Loan','130','','','','','','','','','','','','','',0),(426,'','0','','',427,'Loan','','','','','','','','','','','','','','',0),(427,'','0','','',429,'Loan','','','','','','','','','','','','','','',0),(428,'','0','933','',430,'Loan','','','','','','','','','','53','','','','',0),(429,'','0','','',426,'Loan','','','','','','','','','','','','','','',0),(430,'','0','','10',431,'Loan','','','','495','','372','97','162','','8','','','','',0),(431,'','0','','',400,'Loan','','','','','','','','','','','','','','',0),(432,'','0','','',403,'Loan','','','','','','','','','','','','','','',0),(433,'','0','','',432,'Loan','','','','','','','','','','','','','','',0),(434,'','0','','',433,'Loan','','','','','','','','','','','','','','',0),(435,'1','0','1','1',434,'Loan','','1','1','1','1','1','','','','','','','','',0),(436,'1','0','1','1',435,'Rent','1','','1','1','1','','','','','','','','','1',0),(437,'1','0','788','78',436,'Loan','6','6','6','6','6','7','7','7','','','','','','',0),(438,'','0','','',437,'Loan','','','','','','','','','','','','','','',0),(439,'','0','','',438,'Loan','','','','','','','','','','','','','','',0),(440,'','0','','',439,'Loan','','','','','','','','','','','','','','',0),(441,'','0','','',440,'Loan','','','','','','','','','','','','','','',0),(442,'','0','','',441,'Loan','','','','','','','','','','','','','','',0),(443,'','0','','',442,'Loan','','','','','','','','','','','','','','',0),(444,'','0','','',443,'Loan','','','','','','','','','','','','','','',0),(445,'','0','','',444,'Loan','','','','','','','','','','','','','','',0),(446,'','0','','',445,'Loan','','','','','','','','','','','','','','',0),(447,'','0','','',446,'Loan','','','','','','','','','','','','','','',0),(448,'','0','','',447,'Loan','','','','','','','','','','','','','','',0),(449,'','0','','',0,'Loan','','','','','','','','','','','','','','',0),(450,'','0','','',448,'Loan','','','','','','','','','','','','','','',0),(451,'','0','','',449,'Loan','','','','','','','','','','','','','100','',0),(452,'','0','','',452,'Loan','','','','','','','','','','','','','300','',0),(453,'','','','',453,'Loan','','','','','','','','','','','','','','',0),(454,'','0','','',454,'Loan','','','','','','','','','','','','','300','',0),(455,'','0','','',455,'Loan','','','','','','','','','','','','','300','',0),(456,'','0','','',456,'Loan','','','','','','','','','','','','','300','',0),(457,'','0','','',457,'Loan','','','','','','','','','','','','','','',0),(458,'','0','','',460,'Loan','','','','','','','','','','','','','','',0),(459,'','0','','',461,'Loan','','','','','','','','','','','','','','',0),(460,'','0','','',462,'Loan','','','','','','','','','','','','','','400',0),(461,'5','0','7','8',463,'Loan','9','10','11','13','14','15','16','18','19','20','22','24','25','26',0),(462,'1','0','','',464,'Rent','','','','','','','','','','','','','','',0),(463,'5','0','7','8',465,'Rent','9','10','11','13','14','15','16','18','19','20','22','24','25','26',0),(464,'','0','','',467,'Loan','','','','','','','','','','','','','','',0),(465,'','0','','',468,'Loan','','','','','','','','','','','','','','',0),(466,'','0','','',472,'Loan','','','','','','','','','','','','','','',0),(467,'','0','','',475,'Loan','','','','','','','','','','','','','','',0),(468,'','0','','',476,'Loan','129','944','','','','','','','','','','','','',0),(469,'','0','','',477,'Loan','','','','','','','','','','','','','','',0),(470,'','0','','664',478,'Loan','','','1880','','','','','','','','','','','',0),(471,'','0','','',487,'Loan','','','','','','','','','','','','','','',0),(472,'','0','','',490,'Loan','','','','','','','','','','','','','200','',0),(473,'','0','','',496,'Loan','','','','','','','','','','','','','','',0),(474,'','0','','',497,'Loan','','','','','','','','','','','','','','',0),(475,'','0','','',498,'Loan','','','','','','','','','','','','','','',0),(476,'1','0','1','1',504,'Rent','1','1','1','1','1','1','1','1','1','1','1','1','1','1',0),(477,'1','0','1','1',507,'Rent','1','1','','','','','','','','','','','','',0),(478,'1','0','1','1',505,'Rent','','','','','','','','','','','','','','',0),(479,'','0','405','',508,'Loan','','','','','','858','161','','','','','','','',0),(480,'','0','','',509,'Loan','','','','','','','','','','','','','','',0),(481,'','0','','',510,'Loan','','','','','','','','','','','','','','',0),(482,'','0','','',511,'Rent','239','850','','','','','','138','','68','','','262','',0),(483,'5','0','7','8',520,'Rent','9','10','11','13','14','15','16','18','19','20','22','24','25','26',0),(484,'5','0','7','8',521,'Rent','9','10','11','13','14','15','16','18','19','20','22','24','25','26',0),(485,'','0','','',522,'Loan','','','129','','','','','','','','','','','',0),(486,'5','0','7','8',523,'Rent','9','10','11','13','14','15','16','18','19','20','22','24','25','26',0),(487,'','0','','',527,'Loan','','','','','','','','','','','','','','',0),(488,'','0','','',528,'Loan','','','','','','','','','','','','','200','',0),(489,'','0','','',529,'Loan','','','','','','','','','','','','','','',0),(490,'','0','','',530,'Loan','','','','','','','','','','','','','100','',0),(491,'','0','','',532,'Loan','','','','','','','','','','','','','','',0),(492,'1','0','','',533,'Rent','','','','','','','','','','','','','','',0),(493,'','0','','',535,'Loan','260','850','','','','','','138','','69','','','250','',0),(494,'','0','','',537,'Rent','260','850','','','','','','138','','69','','','250','',0),(495,'','0','','',538,'Loan','','','','','','401','','148','','','','','','',0),(496,'','0','','',539,'Loan','','','850','','','670','110','183','','68','','','','',0),(497,'','0','','',542,'Loan','','','397','','','','','','','52','','','','',0),(498,'1','0','11','1',543,'Rent','1','1','1','','','','','','','','','','','',0),(499,'','0','916','',549,'Loan','','','','','','','','','','','','','200','',0),(500,'','0','','',550,'Loan','','','','','','','','','','','','','','',0),(501,'','0','','',551,'Loan','','','','','','','','','','','','','','',0),(502,'','0','','',552,'Loan','','','','','','','','','','','','','','',0),(503,'','0','','',554,'Loan','','','','','','','','','','','','','','',0),(504,'','0','','',556,'Loan','254','130','','','','489','161','','','','','150','','',0),(505,'','0','69','',0,'Loan','266','130','','','','383','158','98','','14','10','150','','100',0),(506,'1','0','1','1',559,'Rent','11','1','1','1','1','1','1','1','1','1','11','1','1','1',0),(507,'1','0','1','1',560,'Rent','11','1','1','1','1','1','1','1','1','1','11','1','1','1',0),(508,'','0','1','1',561,'Loan','1','1','1','1','1','1','1','1','1','1','1','1','1','',0),(509,'','0','','',562,'Loan','','','','','','','','','','','','','100','',0),(510,'','0','','',563,'Loan','','','','','','','','','','','','','','',0),(511,'','0','668','',565,'Loan','','','','','','','','','','','','','','',0),(512,'5','0','7','8',566,'Rent','9','10','11','13','14','15','16','18','19','20','22','24','25','26',0),(513,'','0','','',571,'Loan','','','','','107','162','','','','','','','','',0),(514,'','0','480','',572,'Loan','','','','','','','','','','','','','','',0),(515,'','0','','',573,'Loan','','','','','','','','','','','','','200','',0),(516,'','0','','',574,'Loan','','','','','','','','','','','','','','',0),(517,'','0','','',575,'Loan','','','','','','','','','','','','','','',0),(518,'','0','','',576,'Loan','860','','','','','','','','','','','','','',0),(519,'','0','','',577,'Loan','860','','','','','','','','','','','','','',0),(520,'','0','668','',578,'Loan','','','','','','','','','','','','','','',0),(521,'','0','964','',580,'Loan','','','','','','','','','','','','','120','',0),(522,'','0','','',581,'Loan','239','850','','','','','','138','','68','','','262','',0),(523,'601.1','0','','',584,'Loan','','','','','','','','137.2','','15','','','','',0),(524,'4','0','43','23',586,'Loan','5','45','33','43','23','656','2','2','3','3','3','33','33','2',0),(525,'23','0','','',589,'Loan','','','','756','','371','158','92','','22','6','','','163',0),(526,'','0','762.7','',590,'Loan','','','','','','','','','','','','','200','',0),(527,'','0','','',591,'Rent','','','','','','','','','','','','','','',0),(528,'','0','','',597,'Loan','','','','741','','103','155','','','','','','','',0),(529,'','0','','',598,'Loan','','','','','','','','','','','','','300','',0),(530,'','0','','',599,'Loan','','','','','','','','','','','','','','',0),(531,'0','0','','',600,'Loan','','','','','','','','','','','','','','',0),(532,'','0','','',601,'Loan','','','','','','','','','','','','','','',0),(533,'','0','69','',602,'Loan','850','130','','','','','','103','','14','','','','',0),(534,'','0','','',603,'Loan','','','','','','','','','','','','','','',0),(535,'','0','','',606,'Loan','','','','','','','','','','','','','','',0),(536,'','0','','',607,'Loan','','','','','','','','','','','','','','',0),(537,'','0','','',608,'Loan','','','','','','','','','','','','','','',0),(538,'','0','','',609,'Loan','','','','','','','','','','','','','340','',0),(539,'','0','','',611,'Loan','','','','130','','','','','','','','','','100',0),(540,'','0','','',612,'Rent','','','','130','','','','','','','','','','100',0),(541,'','0','','',613,'Loan','','','','','','','','','','','','','','',0),(542,'483','0','','',615,'Rent','','','','','','','','','','','','170','','',0),(543,'','0','','',617,'Rent','','','','','','','','','','','','','','',0),(544,'','0','','',618,'Loan','','','','','','','','','','','','','','',0),(545,'','0','','',619,'Rent','','','','','','','','','','','','','','',0),(546,'','0','','',620,'Loan','','','','','','','','','','','','','','',0),(547,'','0','','',621,'Loan','','','','756','','186','158','','6','24','','','','',0),(548,'','0','69','',622,'Loan','850','130','','','','','','','','14','','','','',0),(549,'','0','','',623,'Loan','','','','','','','','','','','','','','',0),(550,'','0','','',625,'Loan','','','','','','','','','','','','','','',0),(551,'','0','','',626,'Loan','','','','','','','','','','','','','','',0),(552,'','0','','',627,'Loan','','','','145','','392','155','','','','','','','',0),(553,'','0','','',630,'Loan','','','','495','','372','97','162','','','','','','',0),(554,'','0','69','',631,'Loan','','','850','','','242','110','107','','14','','','','',0),(555,'','0','','',634,'Loan','','','','','','','','','','','','','','',0),(556,'','0','','',635,'Loan','','','','','','','','','','','','','','',0),(557,'','0','','',636,'Loan','','','850','','','670','110','183','','68','','','','',0),(558,'','0','','',637,'Loan','','','','693','','236','160','','','','','270','','',0),(559,'','0','','',639,'Loan','','','','','','59','112','83','','3','','','200','100',0),(560,'','0','','',641,'Loan','263','850','','','','428','110','','','69','','8','','',0),(561,'','0','','19',642,'Loan','','','','492','','446','72','171','','','','60','','',0),(562,'','0','','',643,'Loan','641','130','0','','','','','65','','52','','','150','',0),(563,'','0','','',644,'Loan','641','132','','','','','','65','','52','','','150','',0),(564,'','0','','',645,'Loan','','','','','','','','','','','','','','',0),(565,'','0','','',646,'Loan','','','','757','','186','158','162','6','24','','80','','',0),(566,'593','0','','17',647,'Loan','','','','','','345','109','','','','','98','','',0),(567,'354','0','','',616,'Loan','','','','','','','','','','','','','','',0),(568,'548','0','','11',650,'Loan','','','','','','','','138','6','9','','','','',0),(569,'','0','','',652,'Loan','','','','','','','','','','','','','','',0),(570,'','0','','',654,'Loan','','','','','','','','','','','','','','',0),(571,'','0','','',663,'Loan','','','','','','','','','','','','','','',0),(572,'','0','','',664,'Loan','','','','300','300','','','','','','','','','',0),(573,'','0','780','',665,'Loan','130','','','','','','','','','60','','','','',0),(574,'','0','','',666,'Loan','129','766','','','','','','','','','','','','',0),(575,'','0','','',667,'Loan','','','896','','','','','','','','','','','',0),(576,'490','0','','',670,'Loan','','','','','','65','9','','','','','','','',0),(577,'','0','','',747,'Loan','','','','','','','','','','','','','','',0),(578,'5000','','','',1758,'Loan','','','','','','','','','','','','','','',0),(579,'3','','','',1759,'Loan','','','','','','','','','','','','','','',0),(580,'3','','','',1760,'Loan','','','','','','','','','','','','','','',0),(581,'5000','','','',1761,'Loan','','','','','','','','','','','','','','',0),(582,'3','','','',1762,'Loan','','','','','','','','','','','','','','',0),(583,'3','','','',1763,'Loan','','','','','','','','','','','','','','',0),(584,'99','','','',1764,'Loan','','','','','','','','','','','','','','',0),(585,'3','','','',1765,'Loan','','','','','','','','','','','','','','',0),(586,'3','','','',1766,'Loan','','','','','','','','','','','','','','',0),(587,'3','','','',1767,'Loan','','','','','','','','','','','','','','',0),(588,'3','','','',1768,'Loan','','','','','','','','','','','','','','',0),(589,'800','','','',1769,'Loan','','','','','','','','','','','','','','',0),(590,'750','','','',1770,'Loan','','','','','','','','','','','','','','',0),(591,'67','','','',1771,'Loan','','','','','','','','','','','','','','',0),(592,'4','0','','',1772,'Loan','','','','','','','','','','','','','','',0),(593,'800','','','',1773,'Loan','','','','','','','','','','','','','','',0),(594,'800','','','',1774,'Loan','','','','','','','','','','','','','','',0),(595,'45','0','','',1775,'Loan','','','','','','','','','','','','','','',0),(596,'34','','','',1776,'Loan','','','','','','','','','','','','','','',0),(597,'800','','','',1777,'Loan','','','','','','','','','','','','','','',0),(598,'4','','','',1778,'Loan','','','','','','','','','','','','','','',0),(599,'565','','','',1779,'Loan','','','','','','','','','','','','','','',0),(600,'43','','','',1780,'Loan','','','','','','','','','','','','','','',0),(601,'32','','','',1781,'Loan','','','','','','','','','','','','','','',0),(602,'32','','','',1782,'Loan','','','','','','','','','','','','','','',0),(603,'20','','','',1783,'Loan','','','','','','','','','','','','','','',0),(604,'3','','','',1791,'Loan','','','','','','','','','','','','','','',0),(605,'33','','','',1792,'Loan','','','','','','','','','','','','','','',0),(606,'32','','','',1797,'Rent','','','','','','','','','','','','','','',0),(607,'23','','','',1801,'Loan','','','','','','','','','','','','','','',0),(608,'5','','','',1802,'Loan','','','','','','','','','','','','','','',0),(609,'24','','','',1805,'Loan','','','','','','','','','','','','','','',0),(610,'21','','','',1806,'Loan','','','','','','','','','','','','','','',0),(611,'20','','','',1807,'Loan','','','','','','','','','','','','','','',0),(612,'23','0','','',1808,'Loan','','','','','','','','','','','','','','',0),(613,'43','','','',1809,'Loan','','','','','','','','','','','','','','',0),(614,'54','0','','',1810,'Loan','','','','','','','','','','','','','','',0),(615,'','0','','',1829,'Loan','','','','','','','','','','','','','','',0),(616,'432','','','',1830,'Loan','','','','','','','','','','','','','','',0),(617,'32','0','','',1831,'Loan','','','','','','','','','','','','','','',0),(618,'23','','','',1832,'Loan','','','','','','','','','','','','','','',0),(619,'32','','','',1833,'Loan','','','','','','','','','','','','','','',0),(620,'32','','','',1834,'Loan','','','','','','','','','','','','','','',0),(621,'32','','','',1835,'Loan','','','','','','','','','','','','','','',0),(622,'5000','','','',1836,'Loan','','','','','','','','','','','','','','',0),(623,'21','','','',1839,'Loan','','','','','','','','','','','','','','',0),(624,'500','','','',1841,'Loan','','','','','','','','','','','','','','',0),(625,'4500','','','',1845,'Loan','','','','','','','','','','','','','','',0),(626,'3','','','',1846,'Loan','','','','','','','','','','','','','','',0),(627,'21','','','',1848,'Loan','','','','','','','','','','','','','','',0),(628,'120','','','',1849,'Loan','','','','','','','','','','','','','','',0),(629,'33','','','',1850,'Loan','','','','','','','','','','','','','','',0),(630,'21','','','',1851,'Loan','','','','','','','','','','','','','','',0),(631,'43','','','',1854,'Loan','','','','','','','','','','','','','','',0),(632,'23','','','',1856,'Loan','','','','','','','','','','','','','','',0),(633,'9000','','','',1869,'Loan','','','','','','','','','','','','','','',0),(634,'32','','','',1870,'Loan','','','','','','','','','','','','','','',0),(635,'32','','','',1871,'Loan','','','','','','','','','','','','','','',0),(636,'23','','','',1872,'Loan','','','','','','','','','','','','','','',0),(637,'3','','','',1873,'Loan','','','','','','','','','','','','','','',0);

--
-- Table structure for table `benefits_client2`
--

CREATE TABLE `benefits_client2` (
  `benefit_id_client2` int(11) NOT NULL AUTO_INCREMENT,
  `full_time` varchar(150) NOT NULL,
  `part_time` varchar(150) NOT NULL,
  `casual` varchar(150) NOT NULL,
  `other_income` varchar(200) NOT NULL,
  `loan_rent_id` int(11) NOT NULL,
  `type` varchar(150) NOT NULL COMMENT 'loan/rent',
  `career` varchar(255) NOT NULL,
  `career2` varchar(200) NOT NULL,
  `disability` varchar(255) NOT NULL,
  `parenting` varchar(200) NOT NULL,
  `large_family` varchar(200) NOT NULL,
  `family_a` varchar(200) NOT NULL,
  `family_b` varchar(255) NOT NULL,
  `rent_assist` varchar(200) NOT NULL,
  `pharmacutical` varchar(255) NOT NULL,
  `suppliment` varchar(200) NOT NULL,
  `phone` varchar(100) NOT NULL,
  `child_maintainence` varchar(200) NOT NULL,
  `board_received` varchar(200) NOT NULL,
  `additional_income` varchar(200) NOT NULL,
  `delete_status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`benefit_id_client2`)
) ENGINE=InnoDB AUTO_INCREMENT=567 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `benefits_client2`
--

INSERT INTO `benefits_client2` VALUES (1,'','0','','',1,'Loan','','','','','','','','','','','','','','',0),(2,'','','','',2,'Loan','','','0','','','','','','','','','','','',0),(3,'','0','','',3,'Loan','','','','','','','','','','','','','','',0),(4,'','0','','',4,'Loan','','','0','','','','','','','','','','','',0),(5,'','0','','',5,'Loan','','','','','','','','','','','','','','',0),(6,'','','','',6,'Loan','','','0','','','','','','','','','','','',0),(7,'','0','','',7,'Loan','','','','','','','','','','','','','','',0),(8,'','0','','',8,'Loan','','','','','','','','','','','','','','',0),(9,'','','','',9,'Loan','','','0','','','','','','','','','','','',0),(10,'','0','','',10,'Loan','','','','','','','','','','','','','','',0),(11,'','0','','',11,'Loan','','','','','','','','','','','','','','',0),(12,'','0','','',12,'Loan','','','','','','','','','','','','','','',0),(13,'','0','','',13,'Loan','','','','','','','','','','','','','','',0),(14,'','','','',14,'Loan','','','0','','','','','','','','','','','',0),(15,'','0','','',15,'Loan','','','','','','','','','','','','','','',0),(16,'','0','','',16,'Loan','','','','','','','','','','','','','','',0),(17,'','0','','',17,'Loan','','','','','','','','','','','','','','',0),(18,'','0','','',18,'Loan','','','','','','','','','','','','','','',0),(19,'','','','',19,'Loan','','','0','','','','','','','','','','','',0),(20,'','0','','',20,'Loan','','','','','','','','','','','','','','',0),(21,'','','','',21,'Loan','','','0','','','','','','','','','','','',0),(22,'','0','','',22,'Loan','','','','','','','','','','','','','','',0),(23,'','','','',23,'Loan','','','0','','','','','','','','','','','',0),(24,'','','','',24,'Loan','','','0','','','','','','','','','','','',0),(25,'','0','','',25,'Loan','','','','','','','','','','','','','','',0),(26,'','','','',26,'Loan','','','0','','','','','','','','','','','',0),(27,'','0','','',27,'Loan','','','','','','','','','','','','','','',0),(28,'','0','','',28,'Loan','','','','','','','','','','','','','','',0),(29,'','0','','',29,'Loan','','','','','','','','','','','','','','',0),(30,'','0','','',30,'Loan','','','','','','','','','','','','','','',0),(31,'','0','','',31,'Loan','','','','','','','','','','','','','','',0),(32,'','','','',6,'Loan','','','0','','','','','','','','','','','',0),(33,'','0','','',33,'Loan','','','','','','','','','','','','','','',0),(34,'','0','','',34,'Loan','','','','','','','','','','','','','','',0),(35,'','','','',35,'Loan','','','0','','','','','','','','','','','',0),(36,'','0','','',36,'Loan','','','','','','','','','','','','','','',0),(37,'','0','','',37,'Loan','','','','','','','','','','','','','','',0),(38,'','0','','',38,'Loan','','','','','','','','','','','','','','',0),(39,'','0','','',39,'Loan','','','','','','','','','','','','','','',0),(40,'','','','',9,'Loan','','','0','','','','','','','','','','','',0),(41,'','0','','',40,'Loan','','','','','','','','','','','','','','',0),(42,'','','','',14,'Loan','','','0','','','','','','','','','','','',0),(43,'','','','',23,'Loan','','','0','','','','','','','','','','','',0),(44,'','0','','',41,'Loan','','','','','','','','','','','','','','',0),(45,'','0','','',42,'Loan','','','','','','','','','','','','','','',0),(46,'','','','',23,'Loan','','','0','','','','','','','','','','','',0),(47,'','0','','',43,'Loan','','','','','','','','','','','','','','',0),(48,'','','','',44,'Loan','','','0','','','','','','','','','','','',0),(49,'','','','',45,'Loan','','','0','','','','','','','','','','','',0),(50,'','0','','',46,'Loan','','','','','','','','','','','','','','',0),(51,'','','','',47,'Loan','','','0','','','','','','','','','','','',0),(52,'','0','','',48,'Loan','','','','','','','','','','','','','','',0),(53,'','0','','',49,'Loan','','','','','','','','','','','','','','',0),(54,'','0','','',50,'Loan','','','0','','','','','','','','','','','',0),(55,'','0','','',51,'Loan','','','','','','','','','','','','','','',0),(56,'','','','',52,'Loan','','','0','','','','','','','','','','','',0),(57,'','0','','',53,'Loan','','','','','','','','','','','','','','',0),(58,'','','','',54,'Loan','','','0','','','','','','','','','','','',0),(59,'','0','','',55,'Loan','','','','','','','','','','','','','','',0),(60,'','0','','',56,'Loan','','','','','','','','','','','','','','',0),(61,'','0','','',57,'Loan','','','','','','','','','','','','','','',0),(62,'','','','',58,'Loan','','','0','','','','','','','','','','','',0),(63,'','0','','',59,'Loan','','','','','','','','','','','','','','',0),(64,'','0','','',60,'Loan','','','','','','','','','','','','','','',0),(65,'','0','','',61,'Loan','','','','','','','','','','','','','','',0),(66,'','','','',62,'Loan','','','0','','','','','','','','','','','',0),(67,'','0','','',63,'Loan','','','','','','','','','','','','','','',0),(68,'','','','',64,'Loan','','','0','','','','','','','','','','','',0),(69,'','0','','',65,'Loan','','','','','','','','','','','','','','',0),(70,'','0','','',66,'Loan','','','','','','','','','','','','','','',0),(71,'','0','','',67,'Loan','','','','','','','','','','','','','','',0),(72,'','','','',68,'Loan','','','0','','','','','','','','','','','',0),(73,'','0','','',69,'Loan','','','','','','','','','','','','','','',0),(74,'','0','','',70,'Loan','','','','','','','','','','','','','','',0),(75,'','0','','',71,'Loan','','','','','','','','','','','','','','',0),(76,'','0','','',72,'Loan','','','','','','','','','','','','','','',0),(77,'','','','',73,'Loan','','','0','','','','','','','','','','','',0),(78,'','0','','',74,'Loan','','','','','','','','','','','','','','',0),(79,'','','','',75,'Loan','','','0','','','','','','','','','','','',0),(80,'','','','',76,'Loan','','','0','','','','','','','','','','','',0),(81,'','0','','',77,'Loan','','','','','','','','','','','','','','',0),(82,'','0','','',78,'Loan','','','','','','','','','','','','','','',0),(83,'','0','','',79,'Loan','','','','','','','','','','','','','','',0),(84,'','0','','',80,'Loan','','','','','','','','','','','','','','',0),(85,'','0','','',81,'Loan','','','','','','','','','','','','','','',0),(86,'','','','',82,'Loan','','','0','','','','','','','','','','','',0),(87,'','0','','',83,'Loan','','','','','','','','','','','','','','',0),(88,'','','','',84,'Loan','','','0','','','','','','','','','','','',0),(89,'','0','','',85,'Loan','','','','','','','','','','','','','','',0),(90,'','0','','',86,'Loan','','','','','','','','','','','','','','',0),(91,'','0','','',87,'Loan','','','','','','','','','','','','','','',0),(92,'','0','','',88,'Loan','','','','','','','','','','','','','','',0),(93,'','','','',89,'Loan','','','0','','','','','','','','','','','',0),(94,'','','','',90,'Loan','','','0','','','','','','','','','','','',0),(95,'','','','',91,'Loan','','','0','','','','','','','','','','','',0),(96,'','0','','',92,'Loan','','','','','','','','','','','','','','',0),(97,'','0','','',93,'Loan','','','','','','','','','','','','','','',0),(98,'','','','',94,'Loan','','','0','','','','','','','','','','','',0),(99,'','','','',95,'Loan','','','0','','','','','','','','','','','',0),(100,'','0','','',96,'Loan','','','','','','','','','','','','','','',0),(101,'','0','','',98,'Loan','','','','','','','','','','','','','','',0),(102,'','0','','',99,'Loan','','','','','','','','','','','','','','',0),(103,'','0','','',100,'Loan','','','','','','','','','','','','','','',0),(104,'','0','','',101,'Loan','','','','','','','','','','','','','','',0),(105,'','0','','',102,'Loan','','','','','','','','','','','','','','',0),(106,'','0','','',103,'Loan','','','','','','','','','','','','','','',0),(107,'','','','',104,'Loan','','','0','','','','','','','','','','','',0),(108,'','0','','',105,'Loan','','','','','','','','','','','','','','',0),(109,'','0','','',106,'Loan','','','','','','','','','','','','','','',0),(110,'','','','',107,'Loan','','','0','','','','','','','','','','','',0),(111,'','0','','',108,'Loan','','','','','','','','','','','','','','',0),(112,'','','','',109,'Loan','','','0','','','','','','','','','','','',0),(113,'','','','',110,'Loan','','','0','','','','','','','','','','','',0),(114,'','0','','',111,'Loan','','','','','','','','','','','','','','',0),(115,'','','','',112,'Loan','','','0','','','','','','','','','','','',0),(116,'','','','',113,'Loan','','','0','','','','','','','','','','','',0),(117,'','','','',114,'Loan','','','0','','','','','','','','','','','',0),(118,'','0','','',115,'Loan','','','','','','','','','','','','','','',0),(119,'','','','',116,'Loan','','','0','','','','','','','','','','','',0),(120,'','0','','',117,'Loan','','','','','','','','','','','','','','',0),(121,'545','','','',118,'Loan','','','0','','','','','','','','','','','',0),(122,'','0','','',119,'Loan','','','','','','','','','','','','','','',0),(123,'','0','','',120,'Loan','','','','','','','','','','','','','','',0),(124,'','0','','',121,'Loan','','','','','','','','','','','','','','',0),(125,'','0','','',122,'Loan','','','','','','','','','','','','','','',0),(126,'','','','',123,'Loan','','','0','','','','','','','','','','','',0),(127,'','0','','',124,'Loan','','','','','','','','','','','','','','',0),(128,'','','','',125,'Loan','','','0','','','','','','','','','','','',0),(129,'','','','',126,'Loan','','','0','','','','','','','','','','','',0),(130,'','','','',127,'Loan','','','0','','','','','','','','','','','',0),(131,'','','','',128,'Loan','','','0','','','','','','','','','','','',0),(132,'','','','',129,'Loan','','','0','','','','','','','','','','','',0),(133,'','0','','',130,'Loan','','','0','','','','','','','','','','','',0),(134,'','','','',131,'Loan','','','0','','','','','','','','','','','',0),(135,'','0','','',132,'Loan','','','','','','','','','','','','','','',0),(136,'','','','',133,'Loan','','','0','','','','','','','','','','','',0),(137,'','0','','',134,'Loan','','','0','','','','','','','','','','','',0),(138,'','','','',135,'Loan','','','0','','','','','','','','','','','',0),(139,'','','','',136,'Loan','','','0','','','','','','','','','','','',0),(140,'','0','','',137,'Loan','','','','','','','','','','','','','','',0),(141,'','','','',138,'Loan','','','0','','','','','','','','','','','',0),(142,'','0','','',139,'Loan','','','0','','','','','','','','','','','',0),(143,'','','','',140,'Loan','','','0','','','','','','','','','','','',0),(144,'','','','',141,'Loan','','','0','','','','','','','','','','','',0),(145,'','0','','',142,'Loan','','','','','','','','','','','','','','',0),(146,'','0','','',143,'Loan','','','','','','','','','','','','','','',0),(147,'','','','',144,'Loan','','','0','','','','','','','','','','','',0),(148,'','','','',145,'Loan','','','0','','','','','','','','','','','',0),(149,'','0','','',146,'Loan','','','0','','','','','','','','','','','',0),(150,'','','','',147,'Loan','','','0','','','','','','','','','','','',0),(151,'','0','','',148,'Loan','','','','','','','','','','','','','','',0),(152,'','0','','',149,'Loan','','','','','','','','','','','','','','',0),(153,'','0','','',150,'Loan','','','','','','','','','','','','','','',0),(154,'','','','',151,'Loan','','','0','','','','','','','','','','','',0),(155,'','0','','',152,'Loan','','','','','','','','','','','','','','',0),(156,'','0','','',153,'Loan','','','','','','','','','','','','','','',0),(157,'','0','','',154,'Loan','','','0','','','','','','','','','','','',0),(158,'','','','',155,'Loan','','','0','','','','','','','','','','','',0),(159,'','0','','',156,'Loan','','','','','','','','','','','','','','',0),(160,'','','','',157,'Loan','','','0','','','','','','','','','','','',0),(161,'','0','','',158,'Loan','','','','','','','','','','','','','','',0),(162,'','','','',159,'Loan','','','0','','','','','','','','','','','',0),(163,'','0','','',160,'Loan','','','','','','','','','','','','','','',0),(164,'','','','',161,'Loan','','','0','','','','','','','','','','','',0),(165,'','0','','',162,'Loan','','','','','','','','','','','','','','',0),(166,'','','','',163,'Loan','','','0','','','','','','','','','','','',0),(167,'','0','','',164,'Loan','','','','','','','','','','','','','','',0),(168,'','','','',165,'Loan','','','0','','','','','','','','','','','',0),(169,'','','','',166,'Loan','','','0','','','','','','','','','','','',0),(170,'','0','','',167,'Loan','','','','','','','','','','','','','','',0),(171,'','0','','',168,'Loan','','','','','','','','','','','','','','',0),(172,'','0','','',169,'Loan','','','','','','','','','','','','','','',0),(173,'','','','',170,'Loan','','','0','','','','','','','','','','','',0),(174,'','','','',171,'Loan','','','0','','','','','','','','','','','',0),(175,'','','','',172,'Loan','','','0','','','','','','','','','','','',0),(176,'','','','',173,'Loan','','','0','','','','','','','','','','','',0),(177,'','','','',174,'Loan','','','0','','','','','','','','','','','',0),(178,'','0','','',175,'Loan','','','0','','','','','','','','','','','',0),(179,'','','','',176,'Loan','','','0','','','','','','','','','','','',0),(180,'','','','',177,'Loan','','','0','','','','','','','','','','','',0),(181,'','','','',178,'Loan','','','0','','','','','','','','','','','',0),(182,'','','','',179,'Loan','','','0','','','','','','','','','','','',0),(183,'','','','',180,'Loan','','','0','','','','','','','','','','','',0),(184,'','','','',181,'Loan','','','0','','','','','','','','','','','',0),(185,'','','','',182,'Loan','','','0','','','','','','','','','','','',0),(186,'','0','','',183,'Loan','','','','','','','','','','','','','','',0),(187,'','','','',184,'Loan','','','0','','','','','','','','','','','',0),(188,'','0','','',185,'Loan','','','','','','','','','','','','','','',0),(189,'','0','','',186,'Loan','','','','','','','','','','','','','','',0),(190,'','0','','',187,'Loan','','','','','','','','','','','','','','',0),(191,'','','','',188,'Loan','','','0','','','','','','','','','','','',0),(192,'','','','',189,'Loan','','','0','','','','','','','','','','','',0),(193,'','','','',190,'Loan','','','0','','','','','','','','','','','',0),(194,'','','','',191,'Loan','','','0','','','','','','','','','','','',0),(195,'','','','',192,'Loan','','','0','','','','','','','','','','','',0),(196,'','','','',193,'Loan','','','0','','','','','','','','','','','',0),(197,'','','','',194,'Loan','','','0','','','','','','','','','','','',0),(198,'','','','',195,'Loan','','','0','','','','','','','','','','','',0),(199,'','','','',196,'Loan','','','0','','','','','','','','','','','',0),(200,'','','','',197,'Loan','','','0','','','','','','','','','','','',0),(201,'','','','',198,'Loan','','','0','','','','','','','','','','','',0),(202,'','','','',199,'Loan','','','0','','','','','','','','','','','',0),(203,'','','','',200,'Loan','','','0','','','','','','','','','','','',0),(204,'','0','','',201,'Loan','','','0','','','','','','','','','','','',0),(205,'','','','',202,'Loan','','','0','','','','','','','','','','','',0),(206,'','0','','',203,'Loan','','','','','','','','','','','','','','',0),(207,'','','','',204,'Loan','','','0','','','','','','','','','','','',0),(208,'','','','',205,'Loan','','','0','','','','','','','','','','','',0),(209,'','','','',206,'Loan','','','0','','','','','','','','','','','',0),(210,'','','','',207,'Loan','','','0','','','','','','','','','','','',0),(211,'','0','','',208,'Loan','','','','','','','','','','','','','','',0),(212,'','','','',209,'Loan','','','0','','','','','','','','','','','',0),(213,'','','','',210,'Loan','','','0','','','','','','','','','','','',0),(214,'','','','',211,'Loan','','','0','','','','','','','','','','','',0),(215,'','','','',212,'Loan','','','0','','','','','','','','','','','',0),(216,'','0','','',213,'Loan','','','','','','','','','','','','','','',0),(217,'','','','',214,'Loan','','','0','','','','','','','','','','','',0),(218,'','','','',215,'Loan','','','0','','','','','','','','','','','',0),(219,'','','','',216,'Loan','','','0','','','','','','','','','','','',0),(220,'','','','',217,'Loan','','','0','','','','','','','','','','','',0),(221,'','','','',215,'Loan','','','0','','','','','','','','','','','',0),(222,'','','','',218,'Loan','','','0','','','','','','','','','','','',0),(223,'','','','',219,'Loan','','','0','','','','','','','','','','','',0),(224,'','','','',220,'Loan','','','0','','','','','','','','','','','',0),(225,'','0','','',221,'Loan','','','','','','','','','','','','','','',0),(226,'','','','',222,'Loan','','','0','','','','','','','','','','','',0),(227,'','','','',223,'Loan','','','0','','','','','','','','','','','',0),(228,'','','','',224,'Loan','','','0','','','','','','','','','','','',0),(229,'','0','','',225,'Loan','','','','','','','','','','','','','','',0),(230,'','','','',226,'Loan','','','0','','','','','','','','','','','',0),(231,'','','','',227,'Loan','','','0','','','','','','','','','','','',0),(232,'','0','','',228,'Loan','','','','','','','','','','','','','','',0),(233,'','0','','',229,'Loan','','','','','','','','','','','','','','',0),(234,'','','','',230,'Loan','','','0','','','','','','','','','','','',0),(235,'','0','','',231,'Loan','','','','','','','','','','','','','','',0),(236,'','','','',232,'Loan','','','0','','','','','','','','','','','',0),(237,'','','','',233,'Loan','','','0','','','','','','','','','','','',0),(238,'','','','',234,'Loan','','','0','','','','','','','','','','','',0),(239,'','','','',235,'Loan','','','0','','','','','','','','','','','',0),(240,'','','','',236,'Loan','','','0','','','','','','','','','','','',0),(241,'','0','','',237,'Loan','','','','','','','','','','','','','','',0),(242,'','0','','',238,'Loan','','','0','','','','','','','','','','','',0),(243,'','','','',239,'Loan','','','0','','','','','','','','','','','',0),(244,'','','','',240,'Loan','','','0','','','','','','','','','','','',0),(245,'','0','','',241,'Loan','','','','','','','','','','','','','','',0),(246,'','','','',242,'Loan','','','0','','','','','','','','','','','',0),(247,'','','','',243,'Loan','','','0','','','','','','','','','','','',0),(248,'','','','',244,'Loan','','','0','','','','','','','','','','','',0),(249,'','','','',245,'Loan','','','0','','','','','','','','','','','',0),(250,'','','','',246,'Loan','','','0','','','','','','','','','','','',0),(251,'','','','',247,'Loan','','','0','','','','','','','','','','','',0),(252,'','','','',248,'Loan','','','0','','','','','','','','','','','',0),(253,'','0','','',249,'Loan','','','','','','','','','','','','','','',0),(254,'','','','',250,'Loan','','','0','','','','','','','','','','','',0),(255,'','','','',251,'Loan','','','0','','','','','','','','','','','',0),(256,'','','','',252,'Loan','','','0','','','','','','','','','','','',0),(257,'','','','',253,'Loan','','','0','','','','','','','','','','','',0),(258,'','0','','',254,'Loan','','','0','','','','','','','','','','','',0),(259,'','','','',255,'Loan','','','0','','','','','','','','','','','',0),(260,'','0','','',256,'Loan','','','','','','','','','','','','','','',0),(261,'','','','',257,'Loan','','','0','','','','','','','','','','','',0),(262,'','','','',258,'Loan','','','0','','','','','','','','','','','',0),(263,'','0','','',259,'Loan','','','','','','','','','','','','','','',0),(264,'','','','',260,'Loan','','','0','','','','','','','','','','','',0),(265,'','0','','',261,'Loan','','','','','','','','','','','','','','',0),(266,'','0','','',262,'Loan','','','','','','','','','','','','','','',0),(267,'','','','',263,'Loan','','','0','','','','','','','','','','','',0),(268,'','','','',264,'Loan','','','0','','','','','','','','','','','',0),(269,'','','','',265,'Loan','','','0','','','','','','','','','','','',0),(270,'','','','',266,'Loan','','','0','','','','','','','','','','','',0),(271,'','','','',267,'Loan','','','0','','','','','','','','','','','',0),(272,'','','','',268,'Loan','','','0','','','','','','','','','','','',0),(273,'','','','',269,'Loan','','','0','','','','','','','','','','','',0),(274,'','','','',270,'Loan','','','0','','','','','','','','','','','',0),(275,'','','','',271,'Loan','','','0','','','','','','','','','','','',0),(276,'','','','',272,'Loan','','','0','','','','','','','','','','','',0),(277,'','','','',273,'Loan','','','0','','','','','','','','','','','',0),(278,'','0','','',274,'Loan','','','','','','','','','','','','','','',0),(279,'','','','',275,'Loan','','','0','','','','','','','','','','','',0),(280,'','','','',276,'Loan','','','0','','','','','','','','','','','',0),(281,'','','','',277,'Loan','','','0','','','','','','','','','','','',0),(282,'','','','',278,'Loan','','','0','','','','','','','','','','','',0),(283,'','','','',279,'Loan','','','0','','','','','','','','','','','',0),(284,'','0','','',280,'Loan','','','0','','','','','','','','','','','',0),(285,'','0','','',281,'Loan','','','','','','','','','','','','','','',0),(286,'','','','',282,'Loan','','','0','','','','','','','','','','','',0),(287,'','','','',283,'Loan','','','0','','','','','','','','','','','',0),(288,'','','','',284,'Loan','','','0','','','','','','','','','','','',0),(289,'','','','',285,'Loan','','','0','','','','','','','','','','','',0),(290,'','0','','',286,'Loan','','','','','','','','','','','','','','',0),(291,'','','','',287,'Loan','','','0','','','','','','','','','','','',0),(292,'','','','',288,'Loan','','','0','','','','','','','','','','','',0),(293,'','0','','',289,'Loan','','','','','','','','','','','','','','',0),(294,'','','','',290,'Loan','','','0','','','','','','','','','','','',0),(295,'','','','',291,'Loan','','','0','','','','','','','','','','','',0),(296,'','','','',292,'Loan','','','0','','','','','','','','','','','',0),(297,'','','','',293,'Loan','','','0','','','','','','','','','','','',0),(298,'','','','',294,'Loan','','','0','','','','','','','','','','','',0),(299,'','','','',295,'Loan','','','0','','','','','','','','','','','',0),(300,'','','','',296,'Loan','','','0','','','','','','','','','','','',0),(301,'','','','',297,'Loan','','','0','','','','','','','','','','','',0),(302,'','0','','',298,'Loan','','','','','','','','','','','','','','',0),(303,'','','','',299,'Loan','','','0','','','','','','','','','','','',0),(304,'','','','',300,'Loan','','','0','','','','','','','','','','','',0),(305,'','','','',301,'Loan','','','0','','','','','','','','','','','',0),(306,'','','','',302,'Loan','','','0','','','','','','','','','','','',0),(307,'','','','',303,'Loan','','','0','','','','','','','','','','','',0),(308,'','','','',304,'Loan','','','0','','','','','','','','','','','',0),(309,'','','','',305,'Loan','','','0','','','','','','','','','','','',0),(310,'','','','',306,'Loan','','','0','','','','','','','','','','','',0),(311,'','0','','',307,'Loan','','','0','','','','','','','','','','','',0),(312,'','0','','',308,'Loan','','','','','','','','','','','','','','',0),(313,'','','','',309,'Loan','','','0','','','','','','','','','','','',0),(314,'','','','',310,'Loan','','','0','','','','','','','','','','','',0),(315,'','','','',311,'Loan','','','0','','','','','','','','','','','',0),(316,'','','','',312,'Loan','','','0','','','','','','','','','','','',0),(317,'','','','',313,'Loan','','','0','','','','','','','','','','','',0),(318,'','0','','',314,'Loan','','','','','','','','','','','','','','',0),(319,'','','','',315,'Loan','','','0','','','','','','','','','','','',0),(320,'','','','',316,'Loan','','','0','','','','','','','','','','','',0),(321,'','','','',317,'Loan','','','0','','','','','','','','','','','',0),(322,'','','','',318,'Loan','','','0','','','','','','','','','','','',0),(323,'','','','',319,'Loan','','','0','','','','','','','','','','','',0),(324,'','','','',320,'Loan','','','0','','','','','','','','','','','',0),(325,'','','','',321,'Loan','','','0','','','','','','','','','','','',0),(326,'','','','',322,'Loan','','','0','','','','','','','','','','','',0),(327,'','','','',323,'Loan','','','0','','','','','','','','','','','',0),(328,'','','','',324,'Loan','','','0','','','','','','','','','','','',0),(329,'','','','',325,'Loan','','','0','','','','','','','','','','','',0),(330,'','','','',326,'Loan','','','0','','','','','','','','','','','',0),(331,'','','','',327,'Loan','','','0','','','','','','','','','','','',0),(332,'','','','',328,'Loan','','','0','','','','','','','','','','','',0),(333,'','0','','',329,'Loan','','','','','','','','','','','','','','',0),(334,'','','','',330,'Loan','','','0','','202','','','','','','','','','',0),(335,'','','','',331,'Loan','','','0','','','','','','','','','','','',0),(336,'','0','','',332,'Loan','','','','','','','','','','','','','','',0),(337,'','0','','',333,'Loan','','','','','','','','','','','','','','',0),(338,'','','','',334,'Loan','','','0','','','','','','','','','','','',0),(339,'','','','',335,'Loan','','','0','','','','','','','','','','','',0),(340,'','0','','',336,'Loan','','','','','','','','','','','','','','',0),(341,'','','','',337,'Loan','','','0','','','','','','','','','','','',0),(342,'','','','',338,'Loan','','','0','','','','','','','','','','','',0),(343,'','','','',339,'Loan','','','0','','','','','','','','','','','',0),(344,'','','','',340,'Loan','','','0','','','','','','','','','','','',0),(345,'','','','',341,'Loan','','','0','','','','','','','','','','','',0),(346,'','','','',342,'Loan','','','0','','','','','','','','','','','',0),(347,'','0','','',343,'Loan','','','','','','','','','','','','','','',0),(348,'','','','',344,'Loan','','','0','','','','','','','','','','','',0),(349,'','0','','',345,'Loan','','','0','','','','','','','','','','','',0),(350,'','0','','',346,'Loan','','','0','','','','','','','','','','','',0),(351,'','','','',347,'Loan','','','0','','','','','','','','','','','',0),(352,'','','','',348,'Loan','','','0','','','','','','','','','','','',0),(353,'','0','','',349,'Loan','','','','','','','','','','','','','','',0),(354,'','0','','',350,'Loan','','','0','','','','','','','','','','','',0),(355,'','0','','',351,'Loan','','','','','','','','','','','','','','',0),(356,'','','','',352,'Loan','','','0','','','','','','','','','','','',0),(357,'','','','',353,'Loan','','','0','','','','','','','','','','','',0),(358,'','','','',354,'Loan','','','0','','','','','','','','','','','',0),(359,'','','','',355,'Loan','','','0','','','','','','','','','','','',0),(360,'','0','','',356,'Loan','','','','','','','','','','','','','','',0),(361,'','','','',357,'Loan','','','0','','','','','','','','','','','',0),(362,'','','','',358,'Loan','','','0','','','','','','','','','','','',0),(363,'','','','',359,'Loan','','','0','','','','','','','','','','','',0),(364,'','0','','',360,'Loan','','','','','','','','','','','','','','',0),(365,'','','','',361,'Loan','','','0','','','','','','','','','','','',0),(366,'','','','',362,'Loan','','','0','','','','','','','','','','','',0),(367,'','','','',363,'Loan','','','0','','','','','','','','','','','',0),(368,'','','','',364,'Loan','','','0','','','','','','','','','','','',0),(369,'','','','',365,'Loan','','','0','','','','','','','','','','','',0),(370,'','','','',366,'Loan','','','0','','','','','','','','','','','',0),(371,'','','','',367,'Loan','','','0','','','','','','','','','','','',0),(372,'','','','',368,'Loan','','','0','','','','','','','','','','','',0),(373,'','','','',369,'Loan','','','0','','','','','','','','','','','',0),(374,'','','','',370,'Loan','','','0','','','','','','','','','','','',0),(375,'','0','','',371,'Loan','','','0','','','','','','','','','','','',0),(376,'','','','',372,'Loan','','','0','','','','','','','','','','','',0),(377,'','','','',373,'Loan','','','0','','','','','','','','','','','',0),(378,'','','','',374,'Loan','','','0','','','','','','','','','','','',0),(379,'','0','','',375,'Loan','','','','','','','','','','','','','','',0),(380,'','0','','',376,'Loan','','','','','','','','','','','','','','',0),(381,'','','','',377,'Loan','','','0','','','','','','','','','','','',0),(382,'','','','',378,'Loan','','','0','','','','','','','','','','','',0),(383,'','','','',379,'Loan','','','0','','','','','','','','','','','',0),(384,'','','','',380,'Loan','','','0','','','','','','','','','','','',0),(385,'','','','',381,'Loan','','','0','','','','','','','','','','','',0),(386,'','0','','',382,'Loan','','','','','','','','','','','','','','',0),(387,'','','','',383,'Loan','','','0','','','','','','','','','','','',0),(388,'','','','',384,'Loan','','','0','','','','','','','','','','','',0),(389,'','','','',385,'Loan','','','0','','','','','','','','','','','',0),(390,'','','','',386,'Loan','','','0','','','','','','','','','','','',0),(391,'','','','',387,'Loan','','','0','','','','','','','','','','','',0),(392,'','','','',388,'Loan','','','0','','','','','','','','','','','',0),(393,'','0','','',389,'Loan','','','','','','','','','','','','','','',0),(394,'','','','',390,'Loan','','','0','','','','','','','','','','','',0),(395,'','','','',395,'Loan','','','0','','','','','','','','','','','',0),(396,'','0','','',396,'Loan','','','0','','','','','','','','','','','',0),(397,'','0','','',399,'Loan','','','','','','','','','','','','','','',0),(399,'','','','',402,'Loan','','','0','','','','','','','','','','','',0),(400,'','','','',399,'Loan','','','0','','','','','','','','','','','',0),(401,'','','','',399,'Loan','','','0','','','','','','','','','','','',0),(402,'','','','',399,'Loan','','','0','','','','','','','','','','','',0),(403,'','','','',399,'Loan','','','0','','','','','','','','','','','',0),(404,'','','','',399,'Loan','','','0','','','','','','','','','','','',0),(405,'','','','',404,'Loan','','','0','','','','','','','','','','','',0),(406,'','','','',405,'Loan','','','0','','','','','','','','','','','',0),(407,'','0','','',406,'Loan','','','0','','','','','','','','','','','',0),(408,'','0','','',407,'Loan','','','0','','','','','','','','','','','',0),(409,'','','','',408,'Loan','','','0','','','','','','','','','','','',0),(410,'','','','',409,'Loan','','124','698','','','','','','','','','','','',0),(411,'','0','','',411,'Loan','','','0','','','','','','','','','','','',0),(412,'','0','','',412,'Loan','','','0','','','','','','','','','','','',0),(413,'78','79','80','81',413,'Loan','82','83','84','86','87','88','89','91','92','93','95','97','98','99',0),(414,'78','79','80','81',414,'Loan','82','83','84','86','87','88','89','91','92','93','95','97','98','99',0),(415,'','','','',415,'Rent','','','0','','','','','','','','','','','',0),(416,'','0','','',416,'Loan','','','','','','','','','','','','','','',0),(417,'','','','',417,'Loan','','','0','','','','','','','','','','','',0),(418,'78','0','80','81',418,'Loan','82','83','84','86','87','88','89','91','92','93','95','97','98','99',0),(421,'','0','','',420,'Loan','','','','','','','','','','','','','','',0),(422,'','0','','',421,'Loan','','','','','','','','','','','','','','',0),(423,'78','79','80','81',422,'Loan','82','83','84','86','87','88','89','91','92','93','95','97','98','99',0),(424,'','','','',423,'Loan','','','0','','','','','','','','','','','',0),(425,'','','','',423,'Loan','','','0','','','','','','','','','','','',0),(426,'','0','','',427,'Loan','','','0','','','','','','','','','','','',0),(427,'','0','','',429,'Loan','','','0','','','','','','','','','','','',0),(428,'','0','','',430,'Loan','','','0','','','','','','','','','','','',0),(429,'','0','','',426,'Loan','','','0','','','','','','','','','','','',0),(430,'','0','','',431,'Loan','','','0','','','','','','','','','','','',0),(431,'','0','','',400,'Loan','','','0','','','','','','','','','','','',0),(432,'','0','','',403,'Loan','','','0','','','','','','','','','','','',0),(433,'','0','','',432,'Loan','','','0','','','','','','','','','','','',0),(434,'','0','','',433,'Loan','','','0','','','','','','','','','','','',0),(435,'1','0','1','1',434,'Loan','1','1','1','1','','1','','','','','','','','',0),(436,'1','0','1','1',435,'Rent','1','1','1','1','1','','','','','','','','','1',0),(437,'2','0','78','78',436,'Loan','6','6','6','6','77','7','7','7','','','','','','',0),(438,'','0','','',437,'Loan','','','0','','','','','','','','','','','',0),(439,'','0','','',438,'Loan','','','','','','','','','','','','','','',0),(440,'','0','','',439,'Loan','','','','','','','','','','','','','','',0),(441,'','0','','',440,'Loan','','','0','','','','','','','','','','','',0),(442,'','0','','',441,'Loan','','','0','','','','','','','','','','','',0),(443,'','0','','',442,'Loan','','','0','','','','','','','','','','','',0),(444,'','0','','',443,'Loan','','','0','','','','','','','','','','','',0),(445,'','0','','',444,'Loan','','','0','','','','','','','','','','','',0),(446,'','0','','',445,'Loan','','','','','','','','','','','','','','',0),(447,'','0','','',446,'Loan','','','0','','','','','','','','','','','',0),(448,'','0','','',447,'Loan','','','','','','','','','','','','','','',0),(449,'','0','','',0,'Loan','','','0','','','','','','','','','','','',0),(450,'','0','','',448,'Loan','','','0','','','','','','','','','','','',0),(451,'','0','','',449,'Loan','','','0','','','','','','','','','','','',0),(452,'','0','','',452,'Loan','','','0','','','','','','','','','','','',0),(453,'','','','',453,'Loan','','','0','','','','','','','','','','','',0),(454,'','0','','',454,'Loan','','','0','','','','','','','','','','','',0),(455,'','0','','',455,'Loan','','','','','','','','','','','','','','',0),(456,'','0','','',456,'Loan','','','0','','','','','','','','','','','',0),(457,'','0','','',457,'Loan','','','0','','','','','','','','','','','',0),(458,'','0','','',460,'Loan','','','0','','','','','','','','','','','',0),(459,'','0','','',461,'Loan','','','','','','','','','','','','','','',0),(460,'','0','','',462,'Loan','','','0','','','','','','','','','','','',0),(461,'78','0','80','81',463,'Loan','82','83','84','86','87','88','89','91','92','93','95','97','98','99',0),(462,'','0','1','',464,'Rent','','','0','','','','','','','','','','','',0),(463,'78','0','80','81',465,'Rent','82','83','84','86','87','88','89','91','92','93','95','97','98','99',0),(464,'','0','','',467,'Loan','','','0','','','','','','','','','','','',0),(465,'','0','','',468,'Loan','','','','','','','','','','','','','','',0),(466,'','0','','',472,'Loan','','','0','','','','','','','','','','','',0),(467,'','0','','',475,'Loan','','','0','','','','','','','','','','','',0),(468,'','0','','',476,'Loan','','','0','','','','','','','','','','','',0),(469,'','0','','',477,'Loan','','','0','','','','','','','','','','','',0),(470,'','0','','',478,'Loan','','','0','','','','','','','','','','','',0),(471,'','0','','',487,'Loan','','','','','','','','','','','','','','',0),(472,'','0','','',490,'Loan','','','','','','','','','','','','','','',0),(473,'','0','','',496,'Loan','','','','','','','','','','','','','','',0),(474,'','0','','',497,'Loan','','','','','','','','','','','','','','',0),(475,'','0','','',498,'Loan','','','','','','','','','','','','','','',0),(476,'111','0','1','1',504,'Rent','1','1','1','1','1','1','1','1','','1','1','1','1','',0),(477,'1111','0','','11',507,'Rent','11','1','0','','','','','','','','','','','',0),(478,'','0','1','',505,'Rent','','','0','','','','','','','','','','','',0),(479,'','0','','',508,'Loan','','','0','','','','','','','','','','','',0),(480,'','0','','',509,'Loan','','','0','','','','','','','','','','','',0),(481,'','0','','',510,'Loan','','','','','','','','','','','','','','',0),(482,'','0','','',511,'Rent','','','0','','','','','','','','','','','',0),(483,'78','0','80','81',520,'Rent','82','83','84','86','87','88','89','91','92','93','95','97','98','99',0),(484,'78','0','80','81',521,'Rent','82','83','84','86','87','88','89','91','92','93','95','97','98','99',0),(485,'','0','','',522,'Loan','','','','','','','','','','','','','','',0),(486,'78','0','80','81',523,'Rent','82','83','84','86','87','88','89','91','92','93','95','97','98','99',0),(487,'','0','','',527,'Loan','','','0','','','','','','','','','','','',0),(488,'','0','','',529,'Loan','','','0','','','','','','','','','','','',0),(489,'','0','','',530,'Loan','','','','','','','','','','','','','','',0),(490,'','0','','',532,'Loan','','','0','','','','','','','','','','','',0),(491,'1111','0','','',533,'Rent','','','0','','','','','','','','','','','',0),(492,'','0','','',535,'Loan','','','0','','','','','','','','','','','',0),(493,'','0','','',537,'Rent','','','0','','','','','','','','','','','',0),(494,'','0','','',539,'Loan','','','','','','','','','','','','','','',0),(495,'','0','','',542,'Loan','','','641','','','','','','','52','','','','',0),(496,'1','0','1','1',543,'Rent','11','1','0','','','','','','','','','','','',0),(497,'','0','','',549,'Loan','','','0','','','','','','','','','','','',0),(498,'','0','','',550,'Loan','','','','','','','','','','','','','','',0),(499,'','0','','',551,'Loan','','','0','','','','','','','','','','','',0),(500,'','0','','',552,'Loan','','','','','','','','','','','','','','',0),(501,'','0','','',554,'Loan','','','0','','','','','','','','','','','',0),(502,'','0','','',556,'Loan','','','','','','','','','','','','','','',0),(503,'1','0','1','1',559,'Rent','1','1','1','1','1','11','1','1','1','1','1','1','1','1',0),(504,'1','0','1','1',560,'Rent','1','1','1','1','1','11','1','1','1','1','1','1','1','1',0),(505,'11','0','1','1',561,'Loan','1','1','1','1','1','1','1','1','1','1','1','1','','',0),(506,'','0','','',562,'Loan','','','0','','','','','','','','','','','',0),(507,'','0','','',563,'Loan','','','0','','','','','','','','','','','',0),(508,'','0','','',565,'Loan','','','','','','','','','','','','','','',0),(509,'78','0','80','81',566,'Rent','82','83','84','86','87','88','89','91','92','93','95','97','98','99',0),(510,'','0','','',571,'Loan','','','0','','','','','','','','','','','',0),(511,'','0','','',572,'Loan','','','0','','','','','','','','','','','',0),(512,'','0','','',573,'Loan','','','0','','','','','','','','','','','',0),(513,'','0','','',574,'Loan','','','','','','','','','','','','','','',0),(514,'','0','','',575,'Loan','','','0','','','','','','','','','','','',0),(515,'','0','','',576,'Loan','','','0','','','','','','','','','','','',0),(516,'','0','','',577,'Loan','','','','','','','','','','','','','','',0),(517,'','0','','',578,'Loan','','','0','','','','','','','','','','','',0),(518,'','0','','',580,'Loan','','','','','','','','','','','','','','',0),(519,'','0','','',581,'Loan','','','','','','','','','','','','','','',0),(520,'','0','','',584,'Loan','','','','','','','','','','','','','','',0),(521,'43','0','32','234',586,'Loan','54','453','34','23','54','443','34','3','33','3','33','33','33','2',0),(522,'','0','','',590,'Loan','','','','','','','','','','','','','','',0),(523,'','0','','',591,'Rent','','','','','','','','','','','','','','',0),(524,'','0','','',597,'Loan','','','','','','','','','','','','','','',0),(525,'','0','','',598,'Loan','','','','','','','','','','','','','','',0),(526,'0','0','','',600,'Loan','','','','','','','','','','0','','','','',0),(527,'','0','','',601,'Loan','','','','','','','','','','','','','','',0),(528,'','0','','',603,'Loan','','','','','','','','','','','','','','',0),(529,'','0','','',606,'Loan','','','','','','','','','','','','','','',0),(530,'','0','','',607,'Loan','','','','','','','','','','','','','','',0),(531,'','0','','',608,'Loan','','','','','','','','','','','','','','',0),(532,'','0','','',611,'Loan','','','','','','','','','','','','','','',0),(533,'','0','','',612,'Rent','','','','','','','','','','','','','','',0),(534,'','0','','',613,'Loan','','','','','','','','','','','','','','',0),(535,'','0','','',615,'Rent','','','','','','','','','','','','','','',0),(536,'','0','','',617,'Rent','','','','','','','','','','','','','','',0),(537,'','0','','',618,'Loan','','','','','','','','','','','','','','',0),(538,'','0','','',619,'Rent','','','','','','','','','','','','','','',0),(539,'','0','','',620,'Loan','','','','','','','','','','','','','','',0),(540,'','0','','',622,'Loan','','','','','','','','','','','','','','',0),(541,'','0','','',623,'Loan','','','','','','','','','','','','','','',0),(542,'','0','','',625,'Loan','','','','','','','','','','','','','','',0),(543,'','0','','',626,'Loan','','','','','','','','','','','','','','',0),(544,'','0','','',627,'Loan','','','','','','','','','','','','','','',0),(545,'','0','','',630,'Loan','','','','','','','','','','','','','','',0),(546,'','0','','',634,'Loan','','','','','','','','','','','','','','',0),(547,'','0','','',635,'Loan','','','','','','','','','','','','','','',0),(548,'','0','','',636,'Loan','','','','','','','','','','','','','','',0),(549,'','0','','',637,'Loan','','','','','','','','','','','','','','',0),(550,'','0','','',639,'Loan','','','','','','','','','','','','','','',0),(551,'','0','','',641,'Loan','','','','','','','','','','','','','','',0),(552,'585','0','','',642,'Loan','','','','','','158','','','','','','','','',0),(553,'','0','','',643,'Loan','','','641','','','','','65','','52','','','','',0),(554,'','0','','',644,'Loan','','','641','','','','','65','','52','','','','',0),(555,'','0','','',645,'Loan','','','','','','','','','','','','','','',0),(556,'','0','','',646,'Loan','','','','','','','','','','','','','','',0),(557,'','0','','',647,'Loan','','','','','','','','','','','','','','',0),(558,'','0','','',652,'Loan','','','','','','','','','','','','','','',0),(559,'','0','','',654,'Loan','','','','','','','','','','','','','','',0),(560,'','0','','',663,'Loan','','','','','','','','','','','','','','',0),(561,'','0','','',664,'Loan','','','','','','','','','','','','','','',0),(562,'','0','','',665,'Loan','','','','','','','','','','','','','','',0),(563,'','0','','',666,'Loan','','','','','','','','','','','','','','',0),(564,'','0','','',667,'Loan','','','','','','','','','','','','','','',0),(565,'','0','','',670,'Loan','','','','','','','','','','','','','','',0),(566,'','0','','',747,'Loan','','','','','','','','','','','','','','',0);

--
-- Table structure for table `boat_assets`
--

CREATE TABLE `boat_assets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `RentalID` int(11) NOT NULL COMMENT 'hkjh',
  `description` varchar(225) NOT NULL,
  `make_model` varchar(150) NOT NULL,
  `ownership` varchar(150) NOT NULL,
  `value` varchar(50) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  `timestamp` varchar(50) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `boat_assets`
--

INSERT INTO `boat_assets` VALUES (1,721,'','','','',0,'1595242353','2020-02-26 13:08:05'),(11,741,'','','','',0,'1583564057','2020-03-07 06:54:17'),(12,748,'','','','',0,'1583991240','2020-03-12 04:49:26'),(13,748,'','','','',0,'1583991240','2020-03-12 04:49:26'),(14,748,'','','','',0,'1583991240','2020-03-12 04:49:26'),(15,748,'','','','',0,'1583991240','2020-03-12 04:49:27'),(16,746,'','','','',0,'1583996409','2020-03-12 07:00:09'),(17,812,'','','','',0,'1594730966','2020-03-16 10:20:43'),(18,809,'','','','',0,'1584424041','2020-03-16 10:36:59'),(19,811,'','','','',0,'1585123450','2020-03-16 12:18:02'),(20,789,'','','','1,000',0,'1595306168','2020-03-18 07:58:57'),(21,704,'','','','',0,'1584525714','2020-03-18 09:41:19'),(22,834,'sfdfdsf','sdfsdfsdf','','10',0,'1594212905','2020-03-25 04:06:50'),(23,857,'','','','',0,'1587535190','2020-04-22 05:59:50'),(24,903,'','','','',0,'1593165864','2020-06-26 10:04:24'),(25,907,'','','','',0,'1594299392','2020-06-27 08:02:16'),(26,834,'','','','',0,'1594212905','2020-06-30 10:49:39'),(27,834,'','','','',0,'1594212905','2020-06-30 10:49:39'),(28,906,'','','','',0,'1594647043','2020-06-30 11:19:33'),(32,907,'','','','',0,'1594299392','2020-06-30 16:47:53'),(33,907,'','','','',0,'1594299392','2020-06-30 16:47:53'),(34,916,'','','','',0,'1594291264','2020-07-07 12:33:39'),(35,917,'','','','1,000',0,'1594378618','2020-07-09 13:26:53'),(36,917,'','','','1,000',0,'1594378618','2020-07-09 13:26:53'),(37,917,'','','','1,000',0,'1594378618','2020-07-09 13:26:53'),(38,917,'','','','1,000',0,'1594378618','2020-07-09 13:26:53'),(39,917,'','','','1,000',0,'1594378618','2020-07-09 13:26:53'),(40,917,'','','','1,000',0,'1594378618','2020-07-10 10:33:06'),(41,917,'','','','1,000',0,'1594378618','2020-07-10 10:33:06'),(42,917,'','','','1,000',0,'1594378618','2020-07-10 10:33:06'),(43,917,'','','','1,000',0,'1594378618','2020-07-10 10:33:07'),(44,917,'','','','1,000',0,'1594378618','2020-07-10 10:33:07'),(45,917,'','','','1,000',0,'1594378618','2020-07-10 10:33:07'),(46,918,'','','','',0,'1594646644','2020-07-10 11:47:50'),(47,935,'','','','',0,'1594789161','2020-07-15 04:59:21'),(48,789,'','','','1,000',0,'1595306168','2020-07-15 13:04:10'),(49,789,'','','','1,000',0,'1595306168','2020-07-15 13:04:10'),(50,789,'','','','1,000',0,'1595306168','2020-07-15 13:04:10'),(51,789,'','','','1,000',0,'1595306168','2020-07-15 13:04:10'),(52,789,'','','','1,000',0,'1595306168','2020-07-15 13:04:10'),(53,947,'','','','1,000',0,'1595305784','2020-07-20 10:43:04'),(54,947,'','','','1,000',0,'1595305784','2020-07-20 10:43:04'),(55,947,'','','','1,000',0,'1595305784','2020-07-20 10:43:04'),(56,947,'','','','',0,'1595305784','2020-07-20 10:43:04'),(57,947,'','','','',0,'1595305784','2020-07-20 10:43:04'),(58,948,'','','','',0,'1595310772','2020-07-20 11:41:28'),(59,951,'','','','',0,'1595315749','2020-07-21 05:43:11'),(60,964,'ewrwer','','','132',0,'1595329349','2020-07-21 10:31:27'),(61,982,'sfsdfsf','sfdsf','324','2,323',0,'1595400290','2020-07-22 06:10:26'),(62,984,'','','','',0,'1595401048','2020-07-22 06:46:26'),(63,997,'','','','',0,'1595498112','2020-07-23 09:55:12'),(64,967,'','','','',0,'1596010589','2020-07-28 09:56:31'),(65,965,'','','','',0,'1596020737','2020-07-29 11:05:37'),(66,1749,'','','','',0,'1596095079','2020-07-30 06:09:17'),(67,1795,'','','','',0,'1596694694','2020-08-06 06:16:16'),(68,1794,'','','','',0,'1596777723','2020-08-07 05:22:03'),(69,1796,'','','','',0,'1597298151','2020-08-07 05:48:16'),(70,1798,'','','','',0,'1597046610','2020-08-10 06:09:39'),(71,1811,'','','','',0,'1597306759','2020-08-13 08:02:47'),(72,975,'','','','',0,'1597307081','2020-08-13 08:24:41'),(73,1814,'','','','',0,'1597321454','2020-08-13 08:25:23'),(74,1818,'','','','',0,'1597737780','2020-08-18 06:21:40'),(75,1820,'','','','',0,'1597736346','2020-08-18 07:39:06'),(76,1822,'','','','',0,'1597736511','2020-08-18 07:41:29'),(77,1823,'','','','',0,'1597736549','2020-08-18 07:42:08'),(78,1826,'','','','',0,'1597746754','2020-08-18 09:40:18'),(79,1827,'','','','',0,'1599825988','2020-08-20 12:25:55'),(80,1843,'','','','',0,'1600252884','2020-09-09 11:55:35'),(81,1860,'','','','',0,'1600858387','2020-09-23 10:53:07');

--
-- Table structure for table `budget_income_client1`
--

CREATE TABLE `budget_income_client1` (
  `budget_id_client1` int(11) NOT NULL AUTO_INCREMENT,
  `full_time` varchar(200) NOT NULL,
  `part_time` varchar(100) NOT NULL,
  `casual` varchar(150) NOT NULL,
  `other_income` varchar(200) NOT NULL,
  `loan_rent_id` int(11) NOT NULL,
  `type` varchar(150) NOT NULL COMMENT 'loan/rent',
  `delete_status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`budget_id_client1`)
) ENGINE=InnoDB AUTO_INCREMENT=761 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `budget_income_client1`
--

INSERT INTO `budget_income_client1` VALUES (1,'810','','','',1,'Loan',0),(2,'','','','',2,'Loan',0),(3,'','551','','',3,'Loan',0),(4,'789','','','',4,'Loan',0),(5,'','','','',5,'Loan',0),(6,'','','','',6,'Loan',0),(7,'1295','','','',7,'Loan',0),(8,'','','','',8,'Loan',0),(9,'','','','',9,'Loan',0),(10,'1724','','','',10,'Loan',0),(11,'946','','','',11,'Loan',0),(12,'684','526','','400',12,'Loan',0),(13,'','','','',13,'Loan',0),(14,'','','','',14,'Loan',0),(15,'775','','','',15,'Loan',0),(16,'1054','','','162',16,'Loan',0),(17,'1384','','','',17,'Loan',0),(18,'1080','','','',18,'Loan',0),(19,'733','','','',19,'Loan',0),(20,'772','','','',20,'Loan',0),(21,'','','','',21,'Loan',0),(22,'984','','','',22,'Loan',0),(23,'','','','',23,'Loan',0),(24,'420','','','',24,'Loan',0),(25,'636','305','','',25,'Loan',0),(26,'','','','',26,'Loan',0),(27,'1321','','','',27,'Loan',0),(28,'513','','','',28,'Loan',0),(29,'988','','','',29,'Loan',0),(30,'1417','','','',30,'Loan',0),(31,'','','440','',31,'Loan',0),(32,'915','','','',6,'Loan',0),(33,'','','700','',33,'Loan',0),(34,'','','','',34,'Loan',0),(35,'551','407','','',35,'Loan',0),(36,'1662','','','',36,'Loan',0),(37,'1096','','','',37,'Loan',0),(38,'','','','',38,'Loan',0),(39,'728','','','',39,'Loan',0),(40,'','','','',9,'Loan',0),(41,'305','','','',40,'Loan',0),(42,'','','','',14,'Loan',0),(43,'','','','',23,'Loan',0),(44,'','','','',41,'Loan',0),(45,'','','','',42,'Loan',0),(46,'','','','',23,'Loan',0),(47,'','','','',43,'Loan',0),(48,'650','','','',44,'Loan',0),(49,'','','','',45,'Loan',0),(50,'851','','','',46,'Loan',0),(51,'','','','',47,'Loan',0),(52,'1074','','','',48,'Loan',0),(53,'720','','','',49,'Loan',0),(54,'1395','','','',50,'Loan',0),(55,'917','','','',51,'Loan',0),(56,'679','','','',52,'Loan',0),(57,'860','','','',53,'Loan',0),(58,'500','','','',54,'Loan',0),(59,'','','','',55,'Loan',0),(60,'1053','','','',56,'Loan',0),(61,'1127','413','','',57,'Loan',0),(62,'','','','',58,'Loan',0),(63,'1120','292','','',59,'Loan',0),(64,'865','','','',60,'Loan',0),(65,'775','','','',61,'Loan',0),(66,'1271','','','',62,'Loan',0),(67,'','','','',63,'Loan',0),(68,'','','','',64,'Loan',0),(69,'750','','','',65,'Loan',0),(70,'751','','','',66,'Loan',0),(71,'2053','','','',67,'Loan',0),(72,'','','','',68,'Loan',0),(73,'919','','','',69,'Loan',0),(74,'','','','',70,'Loan',0),(75,'','','','',71,'Loan',0),(76,'800','','','',72,'Loan',0),(77,'','','','',73,'Loan',0),(78,'1200','','','',74,'Loan',0),(79,'','','','',75,'Loan',0),(80,'','','','',76,'Loan',0),(81,'980','860','','',77,'Loan',0),(82,'2808','','','',78,'Loan',0),(83,'762','','','',79,'Loan',0),(84,'750','','','',80,'Loan',0),(85,'','','505','',81,'Loan',0),(86,'906','','','',82,'Loan',0),(87,'1240','','','',83,'Loan',0),(88,'','','','',84,'Loan',0),(89,'1127','','','',85,'Loan',0),(90,'','','','',86,'Loan',0),(91,'723','','','',87,'Loan',0),(92,'1362','','','86',88,'Loan',0),(93,'918','','','',89,'Loan',0),(94,'','','','',90,'Loan',0),(95,'1647','','','',91,'Loan',0),(96,'1448','','','',92,'Loan',0),(97,'','','','',93,'Loan',0),(98,'','','','',94,'Loan',0),(99,'','','','',95,'Loan',0),(100,'908','','','',96,'Loan',0),(101,'1118','','','',98,'Loan',0),(102,'1112','','','',99,'Loan',0),(103,'859','','','',100,'Loan',0),(104,'1096','','','',101,'Loan',0),(105,'980','','','',102,'Loan',0),(106,'1744','','','',103,'Loan',0),(107,'1554','','','',104,'Loan',0),(108,'760','','','',105,'Loan',0),(109,'','','','',106,'Loan',0),(110,'','','','',107,'Loan',0),(111,'591','','','',108,'Loan',0),(112,'','','116','',109,'Loan',0),(113,'2451','','','',110,'Loan',0),(114,'','','','',111,'Loan',0),(115,'764','','','',112,'Loan',0),(116,'1443','','','',113,'Loan',0),(117,'1400','','','',114,'Loan',0),(118,'805','','','',115,'Loan',0),(119,'761','','','',116,'Loan',0),(120,'1570','','','',117,'Loan',0),(121,'949','','','',118,'Loan',0),(122,'','','','',119,'Loan',0),(123,'','','','',120,'Loan',0),(124,'1092','','','61',121,'Loan',0),(125,'737','','','',122,'Loan',0),(126,'679','','','',123,'Loan',0),(127,'600','','','',124,'Loan',0),(128,'','','','',125,'Loan',0),(129,'550','','','',126,'Loan',0),(130,'792','','','',127,'Loan',0),(131,'1168','','','',128,'Loan',0),(132,'','','','',129,'Loan',0),(133,'1083','','','',130,'Loan',0),(134,'1180','','','',131,'Loan',0),(135,'1576','','','',132,'Loan',0),(136,'','','','',133,'Loan',0),(137,'870','','','',134,'Loan',0),(138,'','','1050','',135,'Loan',0),(139,'','','','',136,'Loan',0),(140,'828','','','',137,'Loan',0),(141,'','350','','',138,'Loan',0),(142,'','','','',139,'Loan',0),(143,'','','','',140,'Loan',0),(144,'','','','',141,'Loan',0),(145,'690','','','',142,'Loan',0),(146,'853','','','',143,'Loan',0),(147,'','','','',144,'Loan',0),(148,'','','','',145,'Loan',0),(149,'2462','','','',146,'Loan',0),(150,'','','','',147,'Loan',0),(151,'938','','','',148,'Loan',0),(152,'875','','','',149,'Loan',0),(153,'','','','',150,'Loan',0),(154,'','','','300',151,'Loan',0),(155,'810','','','',152,'Loan',0),(156,'699','','','',153,'Loan',0),(157,'1014','','','',154,'Loan',0),(158,'877','','','',155,'Loan',0),(159,'1400','','','',156,'Loan',0),(160,'','','','',157,'Loan',0),(161,'860','','','',158,'Loan',0),(162,'980','','','',159,'Loan',0),(163,'1192','','','',160,'Loan',0),(164,'834','','','',161,'Loan',0),(165,'1561','','','',162,'Loan',0),(166,'','','','',163,'Loan',0),(167,'1751','','','',164,'Loan',0),(168,'800','','','',165,'Loan',0),(169,'1101','603','','',166,'Loan',0),(170,'1000','','','',167,'Loan',0),(171,'0','150','','',168,'Loan',0),(172,'2422','','','',169,'Loan',0),(173,'','','350','',170,'Loan',0),(174,'','','','',171,'Loan',0),(175,'1025','','','',172,'Loan',0),(176,'900','','','',173,'Loan',0),(177,'','','','',174,'Loan',0),(178,'977','','','',175,'Loan',0),(179,'851','','','',176,'Loan',0),(180,'734','','','',177,'Loan',0),(181,'1069','','','',178,'Loan',0),(182,'945','','','',179,'Loan',0),(183,'','500','','',180,'Loan',0),(184,'','','','',181,'Loan',0),(185,'','','','',182,'Loan',0),(186,'608','','','',183,'Loan',0),(187,'895','','','',184,'Loan',0),(188,'','','','',185,'Loan',0),(189,'891','','','391',186,'Loan',0),(190,'1109','','','',187,'Loan',0),(191,'548','','','',188,'Loan',0),(192,'457','349','','',189,'Loan',0),(193,'1851','383','','',190,'Loan',0),(194,'','','','',191,'Loan',0),(195,'','','','',192,'Loan',0),(196,'847','','','',193,'Loan',0),(197,'1217','','','',194,'Loan',0),(198,'','','','',195,'Loan',0),(199,'850','','','',196,'Loan',0),(200,'1472','','','',197,'Loan',0),(201,'1200','','','',198,'Loan',0),(202,'790','','','',199,'Loan',0),(203,'1700','','','',200,'Loan',0),(204,'','','','',201,'Loan',0),(205,'','','','',202,'Loan',0),(206,'844','','','',203,'Loan',0),(207,'940','','','',204,'Loan',0),(208,'980','','','',205,'Loan',0),(209,'950','','','',206,'Loan',0),(210,'1100','','','',207,'Loan',0),(211,'1243','','','',208,'Loan',0),(212,'','889','','',209,'Loan',0),(213,'1325','','','',210,'Loan',0),(214,'','','','',211,'Loan',0),(215,'723','','','',212,'Loan',0),(216,'1350','','','',213,'Loan',0),(217,'900','','','',214,'Loan',0),(218,'','','','',215,'Loan',0),(219,'','','','',216,'Loan',0),(220,'1230','','','',217,'Loan',0),(221,'','','','',215,'Loan',0),(222,'','','','',218,'Loan',0),(223,'','','','',219,'Loan',0),(224,'','','','',220,'Loan',0),(225,'2932','','','',221,'Loan',0),(226,'','','','',222,'Loan',0),(227,'1500','','','',223,'Loan',0),(228,'750','','','',224,'Loan',0),(229,'760','','','',225,'Loan',0),(230,'','','','',226,'Loan',0),(231,'','','','',227,'Loan',0),(232,'2548','','','',228,'Loan',0),(233,'1673','','','',229,'Loan',0),(234,'600','','','',230,'Loan',0),(235,'534','','','',231,'Loan',0),(236,'1261','','','',232,'Loan',0),(237,'1111','310','','',233,'Loan',0),(238,'','','','',234,'Loan',0),(239,'950','','','',235,'Loan',0),(240,'1752','','','',236,'Loan',0),(241,'','423','','',237,'Loan',0),(242,'704','','','',238,'Loan',0),(243,'1108','','','',239,'Loan',0),(244,'705','','','',240,'Loan',0),(245,'1309','','','',241,'Loan',0),(246,'563','300','','',242,'Loan',0),(247,'700','','','',243,'Loan',0),(248,'525','','','',244,'Loan',0),(249,'892','','','',245,'Loan',0),(250,'','','','',246,'Loan',0),(251,'','','','',247,'Loan',0),(252,'','','','',248,'Loan',0),(253,'520','250','','',249,'Loan',0),(254,'1600','','','',250,'Loan',0),(255,'1065','','','',251,'Loan',0),(256,'','','','',252,'Loan',0),(257,'1064','','','',253,'Loan',0),(258,'','','','',254,'Loan',0),(259,'1200','','','',255,'Loan',0),(260,'1709','','','',256,'Loan',0),(261,'845','','','',257,'Loan',0),(262,'','','','',258,'Loan',0),(263,'','','','',259,'Loan',0),(264,'','','','',260,'Loan',0),(265,'2240','','','',261,'Loan',0),(266,'','','','',262,'Loan',0),(267,'','','100','',263,'Loan',0),(268,'992','','','',264,'Loan',0),(269,'919','','','',265,'Loan',0),(270,'','','','',266,'Loan',0),(271,'660','','','',267,'Loan',0),(272,'669','','','',268,'Loan',0),(273,'1115','','','',269,'Loan',0),(274,'1140','','','',270,'Loan',0),(275,'','','150','',271,'Loan',0),(276,'','','','',272,'Loan',0),(277,'798','','','',273,'Loan',0),(278,'','','293','',274,'Loan',0),(279,'','','','',275,'Loan',0),(280,'1009','','','',276,'Loan',0),(281,'718','','','',277,'Loan',0),(282,'','','','',278,'Loan',0),(283,'1200','','','',279,'Loan',0),(284,'','','','',280,'Loan',0),(285,'1200','','','250',281,'Loan',0),(286,'1022','','','',282,'Loan',0),(287,'','','','502',283,'Loan',0),(288,'','','','',284,'Loan',0),(289,'992','','','',285,'Loan',0),(290,'','','','',286,'Loan',0),(291,'1281','','','',287,'Loan',0),(292,'689','','','',288,'Loan',0),(293,'1250','','','',289,'Loan',0),(294,'1000','','','',290,'Loan',0),(295,'640','','','',291,'Loan',0),(296,'1932','','','',292,'Loan',0),(297,'923','','','',293,'Loan',0),(298,'863','','','',294,'Loan',0),(299,'729','','','',295,'Loan',0),(300,'1110','','','',296,'Loan',0),(301,'803','','','',297,'Loan',0),(302,'1444','','','',298,'Loan',0),(303,'1008','','','',299,'Loan',0),(304,'','','','',300,'Loan',0),(305,'1185','','','',301,'Loan',0),(306,'783','','','',302,'Loan',0),(307,'758','','','',303,'Loan',0),(308,'','','','',304,'Loan',0),(309,'1047','','','',305,'Loan',0),(310,'','','1050','',306,'Loan',0),(311,'','','','',307,'Loan',0),(312,'808','','','',308,'Loan',0),(313,'594','','','',309,'Loan',0),(314,'1950','','','',310,'Loan',0),(315,'732','','','',311,'Loan',0),(316,'807','','','',312,'Loan',0),(317,'1178','','','',313,'Loan',0),(318,'','','','230',314,'Loan',0),(319,'','','','',315,'Loan',0),(320,'900','','','',316,'Loan',0),(321,'800','','','',317,'Loan',0),(322,'783','','','',318,'Loan',0),(323,'','300','','150',319,'Loan',0),(324,'','','','',320,'Loan',0),(325,'1547','','','',321,'Loan',0),(326,'','','','',322,'Loan',0),(327,'680','','','',323,'Loan',0),(328,'1150','','','',324,'Loan',0),(329,'','','429','',325,'Loan',0),(330,'','','','',326,'Loan',0),(331,'360','','','',327,'Loan',0),(332,'1085','','','',328,'Loan',0),(333,'989','','','',329,'Loan',0),(334,'1601','','','',330,'Loan',0),(335,'2993','','','',331,'Loan',0),(336,'1251','','','',332,'Loan',0),(337,'1789','','','',333,'Loan',0),(338,'760','','','',334,'Loan',0),(339,'','','','',335,'Loan',0),(340,'','','','',336,'Loan',0),(341,'624','','','',337,'Loan',0),(342,'','','','',338,'Loan',0),(343,'','','','',339,'Loan',0),(344,'1060','','','',340,'Loan',0),(345,'979','','','',341,'Loan',0),(346,'1070','','','',342,'Loan',0),(347,'740','','','200',343,'Loan',0),(348,'','','','',344,'Loan',0),(349,'1500','','','',345,'Loan',0),(350,'','','','',346,'Loan',0),(351,'659','','','',347,'Loan',0),(352,'1073','','','',348,'Loan',0),(353,'1029','','','',349,'Loan',0),(354,'1194','','','',350,'Loan',0),(355,'','','','',351,'Loan',0),(356,'','','','',352,'Loan',0),(357,'1297','','','',353,'Loan',0),(358,'','329','','',354,'Loan',0),(359,'903','','','',355,'Loan',0),(360,'1043','','','',356,'Loan',0),(361,'','','','',357,'Loan',0),(362,'','','550','',358,'Loan',0),(363,'726','','','305',359,'Loan',0),(364,'599','173','','',360,'Loan',0),(365,'','','','',361,'Loan',0),(366,'','','','',362,'Loan',0),(367,'1013','','','',363,'Loan',0),(368,'','','','',364,'Loan',0),(369,'496','','','305',365,'Loan',0),(370,'950','','','',366,'Loan',0),(371,'','','','',367,'Loan',0),(372,'800','','','',368,'Loan',0),(373,'447','','','',369,'Loan',0),(374,'821','','','',370,'Loan',0),(375,'777','','','',371,'Loan',0),(376,'','','','',372,'Loan',0),(377,'','','','',373,'Loan',0),(378,'','','','',374,'Loan',0),(379,'','','','',375,'Loan',0),(380,'949','','','173',376,'Loan',0),(381,'','416','','',377,'Loan',0),(382,'','658','','',378,'Loan',0),(383,'880','','','',379,'Loan',0),(384,'1265','','','',380,'Loan',0),(385,'800','','','',381,'Loan',0),(386,'1031','','','1250',382,'Loan',0),(387,'1083','','','',383,'Loan',0),(388,'','','','',384,'Loan',0),(389,'773','','','',385,'Loan',0),(390,'','','','',386,'Loan',0),(391,'1413','','','',387,'Loan',0),(392,'770','','','',388,'Loan',0),(393,'900','','','',389,'Loan',0),(394,'','','','',390,'Loan',0),(395,'','','','',395,'Loan',0),(396,'1000','','','',396,'Loan',0),(397,'1945','','','',399,'Loan',0),(399,'444','','','',402,'Loan',0),(400,'','','1050','',399,'Loan',0),(401,'','','','',399,'Loan',0),(402,'','','','',399,'Loan',0),(403,'','','','',399,'Loan',0),(404,'','','','',399,'Loan',0),(405,'','','1050','',404,'Loan',0),(406,'','','1050','',405,'Loan',0),(407,'','','1050','',406,'Loan',0),(408,'','','','',407,'Loan',0),(409,'','','','',408,'Loan',0),(410,'','','','',409,'Loan',0),(411,'1000','','','',410,'Loan',0),(412,'5555','','','',411,'Loan',0),(413,'1000','','','',412,'Loan',0),(414,'1','2','3','4',413,'Loan',0),(415,'1','2','3','4',414,'Loan',0),(416,'980','','','',415,'Rent',0),(417,'980','','','',416,'Loan',0),(418,'980','','','',417,'Loan',0),(419,'1','500','600','4',418,'Loan',0),(422,'831','','','',420,'Loan',0),(423,'850','','','',421,'Loan',0),(424,'1','2','3','4',422,'Loan',0),(425,'','','','',423,'Loan',0),(426,'','','','',423,'Loan',0),(427,'1000','','','',427,'Loan',0),(428,'888','','','',429,'Loan',0),(429,'200','','','',430,'Loan',0),(430,'10000','','','',426,'Loan',0),(431,'','','','',431,'Loan',0),(432,'','','','',400,'Loan',0),(433,'','','','',403,'Loan',0),(434,'1200','','','250',432,'Loan',0),(435,'900','','','',433,'Loan',0),(436,'1','1','1','',434,'Loan',0),(437,'1','1','1','1',435,'Rent',0),(438,'1','1','','1',436,'Loan',0),(439,'1935','','','',437,'Loan',0),(440,'151','','','',438,'Loan',0),(441,'1127','413','','',439,'Loan',0),(442,'1014','','','',440,'Loan',0),(443,'1000','','','',441,'Loan',0),(444,'1','1','','',442,'Loan',0),(445,'1','1','1','',443,'Loan',0),(446,'1110','','','184',444,'Loan',0),(447,'1595','','','',445,'Loan',0),(448,'','','','840',446,'Loan',0),(449,'','','','840',447,'Loan',0),(450,'','','','',0,'Loan',0),(451,'1000','','','',448,'Loan',0),(452,'1083','','','',449,'Loan',0),(453,'1690','','310','',452,'Loan',0),(454,'1500','','','',453,'Loan',0),(455,'1690','','310','',454,'Loan',0),(456,'1690','','310','',455,'Loan',0),(457,'1690','','310','',456,'Loan',0),(458,'1','2','3','4',457,'Loan',0),(459,'1','1','1','1',458,'Rent',0),(460,'1','1','1','1',459,'Loan',0),(461,'2548','','','',460,'Loan',0),(462,'3500','','','',461,'Loan',0),(463,'1417','','','',462,'Loan',0),(464,'1','2','3','4',463,'Loan',0),(465,'1','1','1','1',464,'Rent',0),(466,'1','2','3','4',465,'Rent',0),(467,'798','','','242',466,'Loan',0),(468,'213','','','',467,'Loan',0),(469,'1051','','','',468,'Loan',0),(470,'685','','','173',472,'Loan',0),(471,'1000','','','',471,'Loan',0),(472,'443','','','',473,'Rent',0),(473,'33','','','',474,'Rent',0),(474,'1470','','','',475,'Loan',0),(475,'','','','',476,'Loan',0),(476,'1014','','','',477,'Loan',0),(477,'','','','',478,'Loan',0),(478,'934','','','',487,'Loan',0),(479,'1146','','','',490,'Loan',0),(480,'1','1','1','1',491,'Loan',0),(481,'1','1','1','1',492,'Loan',0),(482,'1','1','1','1',493,'Loan',0),(483,'1473','','','',495,'Loan',0),(484,'865','','','',496,'Loan',0),(485,'','','','',497,'Loan',0),(486,'896','420','','',498,'Loan',0),(487,'455','12','5','',499,'Loan',0),(488,'4500','540','','',500,'Rent',0),(489,'121','12','','',391,'Rent',0),(490,'15','15','10','10',501,'Rent',0),(491,'1500','150','','',502,'Loan',0),(492,'1','1','1','1',504,'Rent',0),(493,'1','1','1','1',507,'Rent',0),(494,'1','1','1','1',505,'Rent',0),(495,'','','','',508,'Loan',0),(496,'1694','','','',509,'Loan',0),(497,'322','','','295',510,'Loan',0),(498,'','','','550',511,'Rent',0),(499,'1','2','3','4',520,'Rent',0),(500,'1','2','3','4',521,'Rent',0),(501,'924','','','',522,'Loan',0),(502,'1','2','3','4',523,'Rent',0),(503,'1743','','','',526,'Loan',0),(504,'1194','','','',527,'Loan',0),(505,'1106','','','',528,'Loan',0),(506,'995','','','',529,'Loan',0),(507,'777','','','',530,'Loan',0),(508,'','','','',532,'Loan',0),(509,'1','1','1','1',533,'Rent',0),(510,'','','','480',535,'Loan',0),(511,'1743','','','',536,'Loan',0),(512,'','','','480',537,'Rent',0),(513,'','617','','',538,'Loan',0),(514,'','500','','',539,'Loan',0),(515,'','450','','',542,'Loan',0),(516,'1','1','1','1',543,'Rent',0),(517,'1','1','1','1',544,'Loan',0),(518,'','','','',549,'Loan',0),(519,'1540','','170','',550,'Loan',0),(520,'675','250','','',551,'Loan',0),(521,'977','','804','',552,'Loan',0),(522,'','','','377',554,'Loan',0),(523,'939','','','',555,'Loan',0),(524,'606','','','',556,'Loan',0),(525,'309','','','',0,'Loan',0),(526,'1','11','1','1',559,'Rent',0),(527,'1','11','1','1',560,'Rent',0),(528,'1','1','1','1',561,'Loan',0),(529,'1083','','','',562,'Loan',0),(530,'1118','','','',563,'Loan',0),(531,'841','','','',564,'Loan',0),(532,'','','','',565,'Loan',0),(533,'1','2','3','4',566,'Rent',0),(534,'977','','','',571,'Loan',0),(535,'','140','','',572,'Loan',0),(536,'760','','','',573,'Loan',0),(537,'','','609','',574,'Loan',0),(538,'699','','','',575,'Loan',0),(539,'','','','',576,'Loan',0),(540,'','','','',577,'Loan',0),(541,'','','','',578,'Loan',0),(542,'','','','',580,'Loan',0),(543,'','','','550',581,'Loan',0),(544,'0','150','','',584,'Loan',0),(545,'1800','','','',585,'Loan',0),(546,'1','1','1','12',586,'Loan',0),(547,'','','','230',590,'Loan',0),(548,'','','609','',591,'Rent',0),(549,'1613','','','',592,'Loan',0),(550,'12','','','',593,'Loan',0),(551,'','','350','',597,'Loan',0),(552,'942','','','',598,'Loan',0),(553,'1804','','','',599,'Loan',0),(554,'925','','','',600,'Loan',0),(555,'959','','','',601,'Loan',0),(556,'1000','','','100',469,'Loan',0),(557,'776','','','',603,'Loan',0),(558,'2193','','','',606,'Loan',0),(559,'922','','','',607,'Loan',0),(560,'1314','','','',608,'Loan',0),(561,'825','','','',609,'Loan',0),(562,'1','1','','',605,'Rent',0),(563,'865','','','',611,'Loan',0),(564,'865','','','',612,'Rent',0),(565,'896','420','','',613,'Loan',0),(566,'','300','','',615,'Rent',0),(567,'821','','','',617,'Rent',0),(568,'2193','','','',618,'Loan',0),(569,'821','','','',619,'Rent',0),(570,'821','','','',620,'Loan',0),(571,'','','','',622,'Loan',0),(572,'','','100','',621,'Loan',0),(573,'900','','','',623,'Loan',0),(574,'900','','','',625,'Loan',0),(575,'900','','','',626,'Loan',0),(576,'','551','','',627,'Loan',0),(577,'804','','','',628,'Loan',0),(578,'','','','',630,'Loan',0),(579,'','','930','',633,'Loan',0),(580,'995','','','',634,'Loan',0),(581,'737','','','',635,'Loan',0),(582,'','500','','',636,'Loan',0),(583,'','','75','',637,'Loan',0),(584,'','','150','',639,'Loan',0),(585,'','','','',641,'Loan',0),(586,'917','','','',640,'Loan',0),(587,'','','','',642,'Loan',0),(588,'','','','',643,'Loan',0),(589,'','','','',644,'Loan',0),(590,'1083','','','',645,'Loan',0),(591,'','','110','',646,'Loan',0),(592,'','','','',647,'Loan',0),(593,'649','','','',648,'Loan',0),(594,'736','','','',649,'Loan',0),(595,'1344','','','',651,'Loan',0),(596,'','','','',650,'Loan',0),(597,'1019','','','',652,'Loan',0),(598,'1600','','','',653,'Loan',0),(599,'1129','','','',654,'Loan',0),(600,'1367','','','',663,'Loan',0),(601,'954','','','',664,'Loan',0),(602,'0','','','',665,'Loan',0),(603,'','','','',666,'Loan',0),(604,'','','','',667,'Loan',0),(605,'820','','','',670,'Loan',0),(606,'33','33','','',722,'Loan',0),(607,'33','33','','',723,'Loan',0),(608,'33','33','','',724,'Loan',0),(609,'33','33','','',725,'Loan',0),(610,'33','33','','',726,'Loan',0),(611,'33','33','','',727,'Loan',0),(612,'33','33','','',730,'Loan',0),(613,'33','33','','',731,'Loan',0),(614,'3','3','','',691,'Rent',0),(615,'3','3','','',732,'Rent',0),(616,'3','3','','',733,'Rent',0),(617,'3','3','','',734,'Rent',0),(618,'3','3','','',735,'Rent',0),(619,'3','3','','',736,'Rent',0),(620,'3','3','','',737,'Rent',0),(621,'3','3','','',738,'Rent',0),(622,'34','43','','',742,'Rent',0),(623,'34','43','','',743,'Rent',0),(624,'433','3','','',744,'Rent',0),(625,'433','3','','',745,'Rent',0),(626,'433','3','','',746,'Rent',0),(627,'151','','','',747,'Loan',0),(628,'33','3','','',751,'Rent',0),(629,'10','20','30','40',834,'Loan',0),(630,'1','1','','',855,'Rent',0),(631,'1','1','','',856,'Rent',0),(632,'1','1','1','1',860,'Rent',0),(633,'1','1','1','1',862,'Rent',0),(634,'1','1','1','1',863,'Rent',0),(635,'10','20','30','40',907,'Loan',0),(636,'0','','','',913,'Loan',0),(637,'0','','','',914,'Loan',0),(638,'','','','',915,'Rent',0),(639,'1','','','',884,'Rent',0),(640,'1','','','',879,'Rent',0),(641,'30','','','',906,'Loan',0),(642,'1','1','1','1',918,'Loan',0),(643,'','1500','','900',921,'Rent',0),(644,'','1500','','900',923,'Loan',0),(645,'','1700','','',924,'Loan',0),(646,'','1500','','900',934,'Loan',0),(647,'1','','','',936,'Rent',0),(648,'1','','','',937,'Rent',0),(649,'1','','','',938,'Rent',0),(650,'1','1','1','1',939,'Rent',0),(651,'22','','','',940,'Loan',0),(652,'1','1','1','1',941,'Rent',0),(653,'1','1','1','1',942,'Rent',0),(654,'1','1','1','1',943,'Rent',0),(655,'1','1','1','1',944,'Rent',0),(656,'1','1','1','1',945,'Loan',0),(657,'1','1','1','1',946,'Loan',0),(658,'22','','','',949,'Rent',0),(659,'22','','','',950,'Rent',0),(660,'22','','','',951,'Loan',0),(661,'0','','','',948,'Mortgage',0),(662,'22','','','',953,'Loan',0),(663,'1','1','1','1',954,'Rent',0),(664,'1','1','1','1',955,'Loan',0),(665,'1','1','1','1',956,'Rent',0),(666,'1','1','1','1',957,'Loan',0),(667,'1','1','1','1',958,'Loan',0),(668,'1','1','1','1',959,'Rent',0),(669,'1','1','1','1',960,'Loan',0),(670,'1','1','1','1',961,'Loan',0),(671,'1','1','1','1',962,'Rent',0),(672,'1','1','1','1',963,'Loan',0),(673,'22','','','',969,'Loan',0),(674,'22','','','',970,'Loan',0),(675,'22','','','',971,'Loan',0),(676,'1','1','1','1',972,'Loan',0),(677,'1','1','1','1',973,'Loan',0),(678,'22','','','',974,'Rent',0),(679,'1000','','','',975,'Loan',0),(680,'1','1','1','1',976,'Loan',0),(681,'1','1','1','1',977,'Loan',0),(682,'1','1','1','1',978,'Loan',0),(683,'1','1','1','1',979,'Loan',0),(684,'1','1','1','1',983,'Loan',0),(685,'1030','1030','','',1727,'Loan',0),(686,'','1700','','',1729,'Loan',0),(687,'45','44','','3',1737,'Loan',0),(688,'12','22','','22',1742,'Loan',0),(689,'99','99','','88',1743,'Loan',0),(690,'99','99','','88',1746,'Loan',0),(691,'33','3','','33',1750,'Loan',0),(692,'99','99','','88',1751,'Loan',0),(693,'1000','','','',1752,'Loan',0),(694,'12','22','','22',1753,'Loan',0),(695,'1000','','','',1754,'Loan',0),(696,'1000','','','',1755,'Loan',0),(697,'33','','','33',1759,'Loan',0),(698,'33','','','33',1760,'Loan',0),(699,'33','','','33',1762,'Loan',0),(700,'33','','','33',1763,'Loan',0),(701,'99','','','88',1764,'Loan',0),(702,'33','','','33',1765,'Loan',0),(703,'33','','','33',1766,'Loan',0),(704,'33','','','33',1767,'Loan',0),(705,'33','','','33',1768,'Loan',0),(706,'33','','','55',1771,'Loan',0),(707,'4','','','43',1772,'Loan',0),(708,'554','','','54',1775,'Loan',0),(709,'45','','','23',1776,'Loan',0),(710,'23','','','45',1778,'Loan',0),(711,'23','','','111',1779,'Loan',0),(712,'54','','','43',1780,'Loan',0),(713,'32','','','21',1781,'Loan',0),(714,'3','','','21',1782,'Loan',0),(715,'45','','','54',1783,'Loan',0),(716,'22','','','32',1791,'Loan',0),(717,'3','','','22',1792,'Loan',0),(718,'0','','','',1795,'Mortgage',0),(719,'3','','','21',1797,'Rent',0),(720,'23','','','12',1801,'Loan',0),(721,'4','','','432',1802,'Loan',0),(722,'23123','','','',1803,'Loan',0),(723,'10000','','','',1804,'Loan',0),(724,'33','','','23',1805,'Loan',0),(725,'21','','','434',1806,'Loan',0),(726,'45','','','54',1807,'Loan',0),(727,'32','','','23',1808,'Loan',0),(728,'54','','','43',1809,'Loan',0),(729,'45','','','45',1810,'Loan',0),(730,'','3232','','',1829,'Loan',0),(731,'443','','','32',1830,'Loan',0),(732,'32','','','34',1831,'Loan',0),(733,'243','','','2',1832,'Loan',0),(734,'23','','','43',1833,'Loan',0),(735,'23','','','43',1834,'Loan',0),(736,'3','','','32',1835,'Loan',0),(737,'1500','','','',1838,'Loan',0),(738,'21','','','43',1839,'Loan',0),(739,'10000','','','',1840,'Loan',0),(740,'15400','','','1520',1845,'Loan',0),(741,'2','','','121',1846,'Loan',0),(742,'1070','','','',1847,'Loan',0),(743,'14','','','11',1848,'Loan',0),(744,'500','','','1540',1849,'Loan',0),(745,'324','','','32',1850,'Loan',0),(746,'1','','','213',1851,'Loan',0),(747,'43','','','23',1854,'Loan',0),(748,'23','','','23',1856,'Loan',0),(749,'1935','','','',1862,'Loan',0),(750,'1600','','','',1867,'Loan',0),(751,'32','','','23',1870,'Loan',0),(752,'32','','','23',1871,'Loan',0),(753,'32','','','23',1872,'Loan',0),(754,'4','','','2',1873,'Loan',0),(755,'1900','','','0',1893,'Loan',0),(756,'33','','','',1858,'Loan',0),(757,'1332','','','',1894,'Loan',0),(758,'1','','','$1',7768,'Loan',0),(759,'1653','','','',9134,'Loan',0),(760,'1','1','','',12523,'Loan',0);

--
-- Table structure for table `budget_income_client2`
--

CREATE TABLE `budget_income_client2` (
  `budget_id_client2` int(11) NOT NULL AUTO_INCREMENT,
  `full_time` varchar(150) NOT NULL,
  `part_time` varchar(150) NOT NULL,
  `casual` varchar(150) NOT NULL,
  `other_income` varchar(200) NOT NULL,
  `loan_rent_id` int(11) NOT NULL,
  `type` varchar(150) NOT NULL COMMENT 'loan/rent',
  `delete_status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`budget_id_client2`)
) ENGINE=InnoDB AUTO_INCREMENT=640 DEFAULT CHARSET=utf8;

--
