--
-- Host: localhost    Database: click_api
-- ------------------------------------------------------


--
-- Dumping data for table `rlcos_fees`
--

INSERT INTO `rlcos_fees` VALUES (1,1,1,'Urban - Rural Rs.15000',0.00),(2,1,2,'Degree Awarding Urban - Rural Rs.20000',0.00),(3,2,3,'As per Schedule',0.00),(4,3,3,'As per Schedule',0.00),(5,4,3,'As per Schedule',0.00),(6,5,4,'Rs.6000',0.00),(7,6,5,'Rs.5000',0.00),(8,7,5,'Rs.5000',0.00),(9,8,5,'Rs.5000',0.00),(10,9,5,'Rs.5000',0.00),(11,10,6,'Rs.7,000',0.00),(12,11,7,'Rs.15,000',0.00),(13,12,8,'Rs.30,000',0.00),(14,13,9,'Rs.20,000',0.00),(15,14,10,'Rs.500',0.00),(16,15,11,'Rs.2,000',0.00),(17,16,12,'Rs.5,000',0.00),(18,17,3,'As per schedule',0.00),(19,18,13,'Rs.1,000',0.00),(20,19,14,'Rs.110',0.00),(21,20,15,'Rs.55',0.00),(22,21,16,'S.R.O.88(I)/2008)',0.00),(23,22,16,'S.R.O.88(I)/2008)',0.00),(24,23,16,'S.R.O.88(I)/2008)',0.00),(25,24,16,'S.R.O.88(I)/2008)',0.00),(26,25,16,'S.R.O.88(I)/2008)',0.00),(27,26,17,'Rs.50000',0.00),(28,27,17,'Rs.50000',0.00),(29,28,18,'Rs.50,000',0.00),(30,29,19,'Rs.100,000',0.00),(31,30,20,'Rs.200,000',0.00),(32,31,21,'Rs.400,000',0.00),(33,32,22,'Rs.600,000',0.00),(34,33,23,'PKR 40,000',0.00),(35,34,23,'PKR 40,000',0.00),(36,35,25,'Rs.20000',0.00),(37,36,17,'Rs.50000',0.00),(38,37,17,'Rs.50000',0.00),(39,38,26,'Rs.15 PSF',0.00),(40,39,27,'Rs.11 PSF',0.00),(41,40,28,'Rs.20 PSF',0.00),(42,41,29,'Rs.16 PSF',0.00),(43,42,30,'Rs.18',0.00),(44,42,31,'Rs.1',0.00),(45,43,27,'Rs.11 PSF',0.00),(46,44,26,'Rs.15 PSF',0.00),(47,45,27,'Rs.11 PSF',0.00),(48,46,28,'Rs.20 PSF',0.00),(49,47,29,'Rs.16 PSF',0.00),(50,48,30,'Rs.18',0.00),(51,48,31,'Rs.1',0.00),(52,49,27,'Rs.11 PSF',0.00),(53,50,26,'Rs.15 PSF',0.00),(54,51,27,'Rs.11 PSF',0.00),(55,52,28,'Rs.20 PSF',0.00),(56,53,29,'Rs.16 PSF',0.00),(57,54,30,'Rs.18 ',0.00),(58,54,31,'Rs.1',0.00),(59,55,27,'Rs.11 PSF',0.00),(60,56,33,'Rs. 5000/-',0.00),(61,57,33,'Rs. 5000/-',0.00),(62,58,34,'Rs. 2500/-',0.00),(63,59,34,'Rs. 2500/-',0.00),(64,60,35,'Rs. 1500/-',0.00),(65,61,36,'Rs. 700/-',0.00),(66,62,36,'Rs. 700/-',0.00),(67,63,3,'As per schedule',0.00),(68,70,37,'Rs.300,000',0.00),(69,71,38,'Rs.10000',0.00),(70,72,39,'Rs.20000 for Cat A For Cat B',0.00),(71,73,4,'Rs.6000',0.00),(72,74,4,'Rs.6000',0.00),(73,75,25,'Rs.20000',0.00),(74,76,38,'Rs.10000',0.00),(75,77,10,'Rs.500',0.00),(76,78,40,'Pesticide Rs.200,000/-',0.00),(77,79,41,'Fertilizer Rs. 50,000/-',0.00),(78,80,42,'Rs.5000 Lab Fee',0.00),(79,81,43,'Rs. 1,000 (for Factories - A group)',0.00),(80,82,44,'Rs. 500 (for wholesaler - B group)',0.00),(81,83,45,'Rs. 100 (for Retailers - C group)',0.00),(82,91,46,'Rs.50,000/-',0.00),(83,102,47,'Rs.300 Per Page',0.00),(84,111,3,'As per schedule',0.00),(85,112,3,'As per schedule',0.00),(86,113,3,'As per schedule',0.00),(87,114,3,'As per schedule',0.00),(88,115,3,'As per schedule',0.00),(89,116,48,'Residential Rs.1000',0.00),(90,117,49,'Commercial Rs.2000',0.00),(91,118,50,'Residential Rs.10,000',0.00),(92,119,51,'Residential Cum Commercial Rs.15,000',0.00),(93,120,52,'Commercial Rs.20,000',0.00),(94,121,3,'As per schedule',0.00),(95,122,3,'As per schedule',0.00),(96,123,53,'Residential Per Sq Yard Rs.100',0.00),(97,124,54,'Commerical per sq yard Rs.200',0.00),(98,125,3,'As per schedule',0.00),(99,126,55,'Resedential Rs.1000',0.00),(100,127,49,'Commercial Rs.2000',0.00),(101,128,50,'Residential Rs.10,000',0.00),(102,129,51,'Residential Cum Commercial Rs.15,000',0.00),(103,130,52,'Commercial Rs.20,000',0.00),(104,131,3,'As per schedule',0.00),(105,132,53,'Residential Per Sq Yard Rs.100',0.00),(106,133,54,'Commerical per sq yard Rs.200',0.00),(107,134,56,'Rs.1 Per Sq Ft Per Day',0.00),(108,135,57,'District Nort Rs.15000',0.00),(109,136,58,'District East Rs.10000',0.00),(110,137,59,'District Centeral Rs.7500',0.00),(111,138,60,'District West Rs.5000',0.00),(112,139,61,'On Streed Rs.10 Per Sq Ft',0.00),(113,140,62,'On Footpath Rs.5 Per Sq Ft',0.00),(114,141,63,'On street Rs.5 Per Sq Ft',0.00),(115,142,64,'On Footpath Rs.3 Per Sq Ft',0.00),(116,143,65,'Karachi Zoo & Park Rs.7000 Per Hour',0.00),(117,144,66,'Security Deposit Rs.25000',0.00),(118,145,67,'In Karachi Zoo Rs.10,000 Per Hour',0.00),(119,146,68,'Security Deposit Rs.50,000',0.00),(120,147,69,'Karachi Safari Park Rs.7,000',0.00),(121,148,70,'Secuirty Deposit Rs.25000',0.00),(122,149,3,'As per schedule',0.00),(123,150,3,'As per schedule',0.00),(124,151,71,'Rs.57000 as a cost of the cabin',0.00),(125,152,72,'Rs.4000 Per Match Per day',0.00),(126,153,12,'Rs.5,000',0.00),(127,154,73,'Rs.100',0.00),(128,155,74,'Late Fee: Rs.150',0.00),(129,156,10,'Rs.500',0.00),(130,157,75,'Late Fee Rs.750',0.00),(131,158,20,'Rs.200,000',0.00),(132,159,37,'Rs.300,000',0.00),(133,160,19,'Rs.100,000',0.00),(134,161,20,'Rs.200,000',0.00),(135,163,3,'As per schedule',0.00),(136,164,76,'Rs.200/-',0.00),(137,165,77,'Rs.800/-',0.00),(138,166,78,'Rs.1,000/-',0.00),(139,167,79,'Rs.400/-',0.00),(140,168,78,'Rs.1,000/-',0.00),(141,169,80,'Rs.1,500/-',0.00),(142,170,81,'Rs.1,250/-',0.00),(143,171,82,'Prescribed fee of Rs. 7,000/- (32-A challan for)',0.00),(144,172,3,'As per schedule',0.00),(145,173,83,'Distillery License for intoxicating Liquor 30,000/- per annum',0.00),(146,174,84,'Establishment Charges 3,500,000/- per annum',0.00),(147,175,85,'Manufacturing of PMFL License 30,000/- per annum',0.00),(148,176,84,'Establishment Charges 3,500,000/- per annum',0.00),(149,177,86,'Establishing a Brewery for Beer 30,000/- per annum',0.00),(150,178,87,'Establishment Charges 35,00,000/- per annum',0.00),(151,179,88,'Trade and Import License for Potable Liquor (Wholesale) Rs. 7,000,000/-',0.00),(152,180,89,'Retail off Liquor License 5,000,000/-',0.00),(153,181,90,'Distillery License for manufacturing of Ethanol 30,000/- per annum',0.00),(154,182,91,'Establishment Fee 3,500,000/- per annum',0.00),(155,183,92,'Sale of Rectified Spirit License 180,000/- per annum',0.00),(156,184,93,'Denaturation of Rectified Spirit License 24,000/- per annum',0.00),(157,185,94,'Denatured Spirit License for Wholesale Rs.30,000/- per annum',0.00),(158,186,95,'Denatured Spirit License for Retail-Sale 2400/- per anum (License fee) and 2400/- per anum (Bottling Fee)',0.00),(159,187,95,'Denatured Spirit License for Retail-Sale 2400/- per anum (License fee) and 2400/- per anum (Bottling Fee)',0.00),(160,188,96,'Intoxicants (Drugs) Commercial Sale License 25,000/- per annum',0.00),(161,189,3,'As per schedule',0.00),(162,190,97,'Club License 60,000/- per annum',0.00),(163,191,98,'Methanol Wholesale License for Commercial Use 30,000/- per annum',0.00),(164,192,99,'Permission to Purchase and Use of Methanol Spirit in Arts or Industry 3,000/- per annum',0.00),(165,193,100,'Permission to use Rectified Spirit in the Manufacturing of Spirituous / Medicinal/ Toilet  Preparation 15,000/- per annum',0.00),(166,194,101,'Permission to use Rectified Spirit in the Manufacturing Homeopathic Medicine Preparation 600/- per annum',0.00),(167,195,102,'Establishment Charges 3,500,000/- per anum',0.00),(168,196,103,'Transport Permit for Beer 76/- Per Liter',0.00),(169,197,104,'Transport Permit for PMFL 2,160/- per Proof Gallon',0.00),(170,198,105,'Transport Permit for Denatured Spirit 10/- per Bulk Gallon Vend Fee 6/- per Bulk Gallon',0.00),(171,199,106,'Transport Permit for Methanol 10/- per bulk gallon Vend Fee 6/- per Bulk Gallon',0.00),(172,200,107,'fee challan of Rs. 60/-',0.00),(173,201,108,'Transport Permit for Beer Rs.02/- per bottle of Beer',0.00),(174,202,109,'Transport Permit for PMFL Rs.15/- per unit of PMFL',0.00),(175,203,110,'Transport Permit for Methanol Rs.10/- per bulk Gallon and Vend fee of Rs. 6 /- per bulk Gallon (both collected together)',0.00),(176,204,111,'Free of cost',0.00),(177,206,3,'As per schedule',0.00),(178,207,112,'Non-refundable license fee per borehole Rs. 100,000/-',0.00),(179,208,113,'One-time advance security deposit per borehole Rs. 90,000/-',0.00),(180,209,114,'Monthly license fee per bore hole Rs. 30,000/-',0.00);


