--
-- Host: localhost    Database: waqfdb
-- ------------------------------------------------------


--
-- Table structure for table `wmr_loans_and_advances`
--

CREATE TABLE `wmr_loans_and_advances` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `months` varchar(33) NOT NULL,
  `year` varchar(33) NOT NULL,
  `date` varchar(33) NOT NULL,
  `code` varchar(33) NOT NULL,
  `employee_head` varchar(33) NOT NULL,
  `account_head` varchar(33) NOT NULL,
  `nature_advance` varchar(33) NOT NULL,
  `amount_sanctioned` varchar(33) NOT NULL,
  `adjusted_not` varchar(55) NOT NULL,
  `amount_recovered` varchar(33) NOT NULL,
  `balance` varchar(33) NOT NULL,
  `remarks` longtext NOT NULL,
  `username` varchar(33) NOT NULL,
  `timestamp` varchar(33) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=42 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wmr_loans_and_advances`
--

INSERT INTO `wmr_loans_and_advances` VALUES (10,'October','2018','01-10-2018','NA','Waqf Fund','GIA','Advance for Buses arrangement at ','64000','not','0000','64000','Advance an amount of Rs. 64000 vide token No. 342, dated: 01-10-2018 towards arrangement of buses at Darul shifa to Golconda during the month Moharram.','admin_it','1541580358'),(11,'August','2018','10-8-18','NA','Mirza Imtiyaz Baig maintenance su','Waqf fund','Fiag hosting 15th August items','5000','Adjusted','5000','0000','toward Arrangement for Flag hosting day of 15th August Adjused vide token No 307 Dt:- 18-9-18','abdulwaheed','1541584633'),(12,'October','2018','3-10-2018','NA','M.A Waheed I.A Waqf','Waqf fund','Ashoorkhana for White wish','4000','Not','4000','4000','towards moharram Grant Ashoorkhana to White washing Etc.','abdulwaheed','1541585113'),(13,'August','2018','20-8-18','NA','Mohd Faiz Uddin','Waqf Fund','Arrangement for Eidul fitr','1,00,000','Not','0000','1,00,000','towards Arrangement for Eidul Fitr prayer Eidgah New Hafeezpet.','abdulwaheed','1541585828'),(14,'August','2018','1-8-18','NA','MD Javeed baig Jr Asst','Waqf Fund','Refreshment Snacks','3000','Not','0000','3000','Refreshment snacks','abdulwaheed','1541586297'),(15,'September','2018','4-9-18','NA','MD Azmathulla Retd CRi','GIA','Sabeel Maintenance to Ashoorkhana','10,00,000','Adjusted','10,00,000','0000','toward Sabeel maintenance to Ashoorkhanas Anjumans Etc in twin cities','abdulwaheed','1541587407'),(16,'August','2018','10-8-18','NA','Shareef Khan','Waqf Fund','Cancellation of Gift Settlement D','3000','Not','0000','0000','Cancellation of Gift settlement Deed No 1064 of 2009 and Sale Deed No 4914 of 2012.','abdulwaheed','1541587822'),(17,'August','2018','13-8-18','NA','Shareef Khan','Waqf Fund','Cancellation of Gift Settlement D','3000','Not','0000','3000','Towards Cancellation of Gift Settlement Deed No 1113 of 2006 and Deed No 2529 of 2014.','abdulwaheed','1541588142'),(18,'August','2018','27-8-18','NA','Shareef Khan','Waqf Fund','Cancellation of Gift Deed.','3000','Not','0000','3000','Cancellation of Gift Deed No 2286 of 1980 and Sale Deed No 2321 of 2012.','abdulwaheed','1541588428'),(19,'October','2018','22-10-18','NA','Basha Hayyum Khan','Waqf Fund','Cancellation Of Sale Deed.','3000','Not','0000','3000','Towards Cancellation of sale Deed No 1328 of 2017 And 1329 of 2017, Vide Token No 367 Dt:- 22-10-2018.','abdulwaheed','1541588966'),(20,'August','2018','3-8-2018','NA','Ameer Ahmed','HHMDC','Arrangement Iftar and Food','46120','Adjusted','46120','0000','Towards Arrangement of Iftar and fruit for 100 Rozedar. Adjusted Vide Token No 331 Dt: 27-9-2018','abdulwaheed','1541590125'),(21,'September','2018','5-9-18','NA','Syed Ali ahmed','Ashoorkhana Nale -e- Mubarak.','Arrangement for Moharram','1,60,000','Not','0000','0000','Towards Arrangement For Moharam at Ashoorkhana Nale -E- Mubarak.','abdulwaheed','1541590528'),(22,'September','2018','5-9-2018','NA','Mohd Saber Hussain I,A Waqf','Mecca Madina Alluddin Waqf.','Annual Maintenance works','167336','Not','0000','0000','Towards annual Maintenance works White Washing and Enamel Panting Idgah Mir Alam And Idgah Madanapet.','abdulwaheed','1541591052'),(23,'August','2018','14-8-18','NA','M.A Waheed','Macca Madina Alluddin Waqf.','Hadiya T.A To UlMas D.A To Staff','30,000','Not','0000','0000','Towards Hadiya T&gt;A To Ulmas D.A to Staff for Eidul azha Miralam','abdulwaheed','1541591414'),(24,'October','2018','04-10-2018','NA','Khader Mohiudddin','Dargah Hzt. Yousufain','maintenance at Dargah Hzt. Yousuf','15000','Not','0000','15000','Advanced sanctioned to Sri Khader Mohiuddin, I.A. Waqf for maintenance at Dargah Hzt. Yousufain Rh., Nampally, hyderabad','abdulwaheed','1541591743'),(25,'September','2018','01-09-2018','NA','Mirza Imtiyaz Bai','Ashoorkhana Nale Mubrak Pathergat','Arrangements of meeting','10000','NOT','0000','10000','Amount sanction to Mirza Imtiyaz Baig, Incharge Maintenance toward arrangement of meeting of Moharram at Secretariat.','abdulwaheed','1541591871'),(26,'March','2021','01-09-2021','11','Ameer Ahmed','Waqf Fund','official Advance','75000','adjusted','1','1','Adjusted','abdulwaheed','1630505034'),(27,'March','2021','01-09-2021','11','Ameer Ahmed','Waqf Fund','official Advance','75000','adjusted','Nil','Nil','Adjusted','abdulwaheed','1630505110'),(28,'September','2021','01-09-2021','11','Ameer Ahmed','Waqf Fund','official Advance','75000','adjusted','Nil','Nil','Adjusted','abdulwaheed','1630505173'),(29,'September','2021','01-09-2021','11','Ameer Ahmed','Waqf Fund','official Advance','75000','adjusted','75000','1','Adjusted','abdulwaheed','1630505258'),(30,'March','2021','01-09-2021','11','Ameer Ahmed','Waqf Fund','official Advance','75000','adjusted','Nil','Nil','Adjusted','abdulwaheed','1630506206'),(31,'September','2021','01-09-2021','11','Ameer Ahmed','Waqf Fund','official Advance','75000','adjusted','1','Nil','Adjusted','abdulwaheed','1630506262'),(32,'March','2021','01-09-2021','11','Ameer Ahmed','Waqf Fund','official Advance','75000','adjusted','Nil','Nil','Adjusted','akheelpasha','1630506328'),(33,'January','2021','01-09-2021','11','Waqf Fund','Ameer Ahmed','Official Advance','75000','Adjusted','75000','Nil','Adjusted vide Token No.','abdulwaheed','1630512077'),(34,'March','2021','02-09-2021','11','Ameer Ahmed','Waqf Fund','official Advance','75000','adjusted','Nil','Nil','adjusted','abdulwaheed','1630560269'),(35,'July','2021','01-11-2021','22','Mohd adul Subhan','waqf fund Interest','Cancellation of (12) sale Deeds','18000/-','not','Nil','18000/-','Amount not adjusted as on Date','abdulwaheed','1635763525'),(36,'November','2021','01-11-2021','22','Mohd adul Subhan','waqf fund Interest','Cancellation of 12 sale Deeds','18000/-','Nil','Nil','18000/-','Amount not Adjusted as on date','abdulwaheed','1635764017'),(37,'July','2021','01-11-2021','22','Mohd adul Subhan','waqf fund Interest','Cancellation of 12 sale Deeds','18000/-','not','Nil','18000/-','amounts not adjused as on date.','abdulwaheed','1635764171'),(38,'July','2021','01-11-2021','22','Mohd adul Subhan','waqf fund Interest','Cancellation of 12 sale Deeds','18,000','not','Nil','18,000','Amount not Adjused as on date.','abdulwaheed','1635764297'),(39,'April','2024','06-05-2024','22','Syed Jaleel Ahmed','D.H.S.S.Hussaini Rh','Official Advance','50,000.00','01','01','50,000.00','Convenience allowances and Hadiya to Ullamas for eid fitr 2024.','abdulwaheed','1714978702'),(40,'April','2024','06-05-2024','22','Syed Jaleel Ahmed','D H S S H','Official Advance','50000','Not','00','50000','Convenience allowance and hadiya to Ulemas for Eidul Fitr 2024','abdulwaheed','1714978847'),(41,'April','2024','06-05-2024','22','Syed Jaleel Ahmed','DSSH Rh','Official Advances','50000','Not Adjusted','Not Recovered','50000','Convivence allowance to hadiya to Ulemas for Eid ul Fitr 2024','abdulwaheed','1714987694');


