	Login		Register
File: testData.sql

Recommend this page to a friend!
Stumble It!
Bookmark in del.icio.us
	Classes of Prakash Khanchandani	>	Table Maintenance	>	testData.sql	>	Download
File:	`testData.sql`
Role:	Auxiliary data
Content type:	`text/plain`
Description:	test data
Class:	Table Maintenance Manage forms for CRUD MySQL table records
Author:	By Prakash Khanchandani
Last change:	removed some redundant statements
Date:	2013-07-20 21:44
Size:	`120,836 bytes`
Download
/*
SQLyog Community Edition- MySQL GUI v8.14 
MySQL - 5.0.51 : Database - test
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE IF NOT EXISTS `test`;

USE `test`;

/*Table structure for table `audittrail` */

DROP TABLE IF EXISTS `audittrail`;

CREATE TABLE `audittrail` (
  `id` bigint(16) NOT NULL auto_increment,
  `clkTime` timestamp NULL default CURRENT_TIMESTAMP,
  `bank` char(3) default NULL,
  `tbl` varchar(30) default NULL,
  `clmn` varchar(30) default NULL,
  `actn` enum('d','u','i') default NULL,
  `oldVal` varchar(60) default NULL,
  `newVal` varchar(60) default NULL,
  `userId` varchar(20) default NULL,
  `sysDate` date default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6  ;

/*Data for the table `audittrail` */

/*Table structure for table `authrules` */

DROP TABLE IF EXISTS `authrules`;

CREATE TABLE `authrules` (
  `bank` char(3) NOT NULL,
  `txnType` enum('CSCR','CSDR','CLCR','CLDR') NOT NULL,
  `slabAmt` decimal(21,6) NOT NULL default '0.000000',
  `nofAuth` smallint(1) NOT NULL default '0',
  UNIQUE KEY `authRule` (`bank`,`txnType`,`slabAmt`)
) ENGINE=MyISAM  ;

/*Data for the table `authrules` */

insert  into `authrules`(`bank`,`txnType`,`slabAmt`,`nofAuth`) values ('412','CSCR','1000.000000',1);
insert  into `authrules`(`bank`,`txnType`,`slabAmt`,`nofAuth`) values ('412','CSCR','15000.000000',2);
insert  into `authrules`(`bank`,`txnType`,`slabAmt`,`nofAuth`) values ('412','CSCR','25000.000000',3);
insert  into `authrules`(`bank`,`txnType`,`slabAmt`,`nofAuth`) values ('412','CSDR','5000.000000',1);
insert  into `authrules`(`bank`,`txnType`,`slabAmt`,`nofAuth`) values ('412','CSDR','15000.000000',2);
insert  into `authrules`(`bank`,`txnType`,`slabAmt`,`nofAuth`) values ('413','CSCR','1000.000000',1);
insert  into `authrules`(`bank`,`txnType`,`slabAmt`,`nofAuth`) values ('413','CSCR','15000.000000',2);
insert  into `authrules`(`bank`,`txnType`,`slabAmt`,`nofAuth`) values ('413','CSCR','25000.000000',3);
insert  into `authrules`(`bank`,`txnType`,`slabAmt`,`nofAuth`) values ('413','CSDR','5000.000000',1);
insert  into `authrules`(`bank`,`txnType`,`slabAmt`,`nofAuth`) values ('413','CSDR','15000.000000',2);
insert  into `authrules`(`bank`,`txnType`,`slabAmt`,`nofAuth`) values ('987','CSCR','1000.000000',1);
insert  into `authrules`(`bank`,`txnType`,`slabAmt`,`nofAuth`) values ('987','CSCR','15000.000000',2);
insert  into `authrules`(`bank`,`txnType`,`slabAmt`,`nofAuth`) values ('987','CSCR','25000.000000',3);
insert  into `authrules`(`bank`,`txnType`,`slabAmt`,`nofAuth`) values ('987','CSDR','5000.000000',1);
insert  into `authrules`(`bank`,`txnType`,`slabAmt`,`nofAuth`) values ('987','CSDR','15000.000000',2);

/*Table structure for table `bankcurrencies` */

DROP TABLE IF EXISTS `bankcurrencies`;

CREATE TABLE `bankcurrencies` (
  `bankCode` char(3) NOT NULL,
  `currencyCode` char(3) NOT NULL,
  `cohGLacNo` char(17) NOT NULL COMMENT 'cash on hand GL account',
  `minRetentionAmt` decimal(21,6) default NULL,
  `maxRetentionAmt` decimal(21,6) NOT NULL,
  PRIMARY KEY  (`bankCode`,`currencyCode`),
  KEY `bankCode` (`bankCode`,`cohGLacNo`),
  KEY `currencyCode` (`currencyCode`),
  CONSTRAINT `bankcurrencies_ibfk_1` FOREIGN KEY (`bankCode`, `cohGLacNo`) REFERENCES `generalledgermstr` (`bank`, `acNo`),
  CONSTRAINT `bankcurrencies_ibfk_2` FOREIGN KEY (`currencyCode`) REFERENCES `currencies` (`currencyCode`),
  CONSTRAINT `bankcurrencies_ibfk_3` FOREIGN KEY (`bankCode`) REFERENCES `bnkprmtrs` (`bank`)
) ENGINE=InnoDB  ;

/*Data for the table `bankcurrencies` */

insert  into `bankcurrencies`(`bankCode`,`currencyCode`,`cohGLacNo`,`minRetentionAmt`,`maxRetentionAmt`) values ('412','aud','99001101102',NULL,'0.000000');
insert  into `bankcurrencies`(`bankCode`,`currencyCode`,`cohGLacNo`,`minRetentionAmt`,`maxRetentionAmt`) values ('412','eur','99001101102',NULL,'0.000000');
insert  into `bankcurrencies`(`bankCode`,`currencyCode`,`cohGLacNo`,`minRetentionAmt`,`maxRetentionAmt`) values ('412','gbp','99001101102',NULL,'0.000000');
insert  into `bankcurrencies`(`bankCode`,`currencyCode`,`cohGLacNo`,`minRetentionAmt`,`maxRetentionAmt`) values ('412','inr','99001101101',NULL,'0.000000');
insert  into `bankcurrencies`(`bankCode`,`currencyCode`,`cohGLacNo`,`minRetentionAmt`,`maxRetentionAmt`) values ('412','usd','99001101102',NULL,'0.000000');

/*Table structure for table `bnkmstr` */

DROP TABLE IF EXISTS `bnkmstr`;

CREATE TABLE `bnkmstr` (
  `bank` char(3) NOT NULL,
  `bankName` varchar(45) NOT NULL,
  PRIMARY KEY  (`bank`)
) ENGINE=MyISAM  ;

/*Data for the table `bnkmstr` */

insert  into `bnkmstr`(`bank`,`bankName`) values ('002','State Bank Of India');
insert  into `bnkmstr`(`bank`,`bankName`) values ('003','State Bank Of Bikaner & Jaipur');
insert  into `bnkmstr`(`bank`,`bankName`) values ('010','Allahabad Bank');
insert  into `bnkmstr`(`bank`,`bankName`) values ('011','Andhra Bank');
insert  into `bnkmstr`(`bank`,`bankName`) values ('012','Bank Of Baroda');
insert  into `bnkmstr`(`bank`,`bankName`) values ('013','Bank Of India');
insert  into `bnkmstr`(`bank`,`bankName`) values ('004','State Bank Of Hyderabad');
insert  into `bnkmstr`(`bank`,`bankName`) values ('001','Reserve Bank Of India');
insert  into `bnkmstr`(`bank`,`bankName`) values ('005','State Bank Of Indore');
insert  into `bnkmstr`(`bank`,`bankName`) values ('007','State Bank Of Patiala');
insert  into `bnkmstr`(`bank`,`bankName`) values ('006','State Bank Mysore');

/*Table structure for table `bnkprmtrs` */

DROP TABLE IF EXISTS `bnkprmtrs`;

CREATE TABLE `bnkprmtrs` (
  `bank` char(3) NOT NULL default '',
  `bankName` varchar(45) NOT NULL default '',
  `AcNoDependOnPrdSubType` enum('Y','N') default 'N',
  `baseCurrency` char(3) NOT NULL,
  `multiCurrency` enum('Y','N') default 'N',
  `maxCashCr` decimal(21,6) NOT NULL COMMENT 'max at batch level',
  `maxCashDr` decimal(21,6) NOT NULL COMMENT 'max at batch level',
  `maxCashCrNewAc` decimal(21,6) NOT NULL,
  `maxCashDrNewAc` decimal(21,6) NOT NULL,
  `tellerLimit` decimal(21,6) NOT NULL,
  `dateFormat` enum('dmy','mdy') NOT NULL default 'dmy',
  `moneyFormat` enum('R','T') NOT NULL default 'R',
  `includeBrCodeInAcNo` enum('Y','N') NOT NULL default 'N',
  `ageMinorToMajor` tinyint(2) NOT NULL default '18',
  `maxCashCrMinor` decimal(21,6) NOT NULL,
  `maxCashDrMinor` decimal(21,6) NOT NULL,
  `maxCrBalMinor` decimal(21,6) NOT NULL,
  `newAcDefnDays` int(3) default NULL,
  `GLprdType` char(3) NOT NULL,
  `useAuthRules` enum('Y','N') NOT NULL default 'N',
  `useLimitSumAuth` enum('Y','N') NOT NULL default 'N',
  `acNoLength` tinyint(2) NOT NULL,
  `autoFillZeroes` enum('Y','N') NOT NULL default 'Y' COMMENT 'during account entry',
  `trgLog` enum('Y','N') default 'N' COMMENT 'log details from within triggers, procedures, etc.',
  `postGLimmediate` enum('Y','N') NOT NULL default 'N',
  `rmtTxnGLid` bigint(16) default NULL,
  `rmtTxnGL` char(17) NOT NULL COMMENT 'remote transaction GL',
  `passWrdValidity` tinyint(2) NOT NULL default '30',
  `minPasswordLength` tinyint(2) NOT NULL default '3',
  `minAlphaInPassword` tinyint(1) NOT NULL default '0',
  `minDigitsInPassword` tinyint(1) NOT NULL default '0',
  `minSpecialCharsInPassword` tinyint(1) NOT NULL default '0',
  `minIterationsInPassword` tinyint(2) NOT NULL default '0',
  `maxPassAttempts` tinyint(1) default '3',
  `tokensUsed` enum('Y','N') NOT NULL default 'Y',
  `CSDRdisburse` enum('Y','N') NOT NULL default 'Y',
  `stalePeriod` tinyint(1) NOT NULL,
  `atParOffered` enum('Y','N') default 'N',
  UNIQUE KEY `bank` (`bank`),
  KEY `bank_2` (`bank`,`baseCurrency`),
  CONSTRAINT `bnkprmtrs_ibfk_1` FOREIGN KEY (`bank`, `baseCurrency`) REFERENCES `bankcurrencies` (`bankCode`, `currencyCode`)
) ENGINE=InnoDB  ;

/*Data for the table `bnkprmtrs` */

insert  into `bnkprmtrs`(`bank`,`bankName`,`AcNoDependOnPrdSubType`,`baseCurrency`,`multiCurrency`,`maxCashCr`,`maxCashDr`,`maxCashCrNewAc`,`maxCashDrNewAc`,`tellerLimit`,`dateFormat`,`moneyFormat`,`includeBrCodeInAcNo`,`ageMinorToMajor`,`maxCashCrMinor`,`maxCashDrMinor`,`maxCrBalMinor`,`newAcDefnDays`,`GLprdType`,`useAuthRules`,`useLimitSumAuth`,`acNoLength`,`autoFillZeroes`,`trgLog`,`postGLimmediate`,`rmtTxnGLid`,`rmtTxnGL`,`passWrdValidity`,`minPasswordLength`,`minAlphaInPassword`,`minDigitsInPassword`,`minSpecialCharsInPassword`,`minIterationsInPassword`,`maxPassAttempts`,`tokensUsed`,`CSDRdisburse`,`stalePeriod`,`atParOffered`) values ('412','The Seva Vikas Cooperative Bank Ltd.','Y','inr','Y','49999.990000','49999.990000','5000.000000','5000.000000','3000.000000','dmy','R','Y',18,'15000.000000','5000.000000','999999999.000000',30,'99','Y','N',6,'Y','Y','Y',1887,'99001109002',30,3,0,0,0,0,3,'Y','Y',6,'N');

/*Table structure for table `brnchmstr` */

DROP TABLE IF EXISTS `brnchmstr`;

CREATE TABLE `brnchmstr` (
  `bank` char(3) NOT NULL,
  `branch` char(4) NOT NULL,
  `branchName` varchar(45) NOT NULL,
  `clrgCode` bigint(9) default NULL,
  PRIMARY KEY  (`bank`,`branch`)
) ENGINE=MyISAM  ;

/*Data for the table `brnchmstr` */

insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('002','0002','Pune Main Branch',411002002);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('002','0056','Ccpc',411002056);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('004','0007','Centralised Clg',411004007);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('010','0003','Manjari',411010003);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('010','0005','Kondhava',411010005);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('011','0002','Quarter Gate',411011002);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('002','0913','Malkapur',443002913);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('002','0841','Malkapur',443002841);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('001','0001','Mumbai',400001001);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('004','0001','Service Branch (ser)',400004001);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('010','0001','Service Branch (ser)',400010001);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('002','0001','Service Br.',400002001);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('005','0001','Service Branch(ser)',400005001);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('011','0001','Service Branch(ser)',400011001);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('002','0014','Carmichael Road',400002014);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('004','0014','Shahaganj Govt. A/c Section',431004014);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('004','0006','Chawani',431004006);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('002','0012','Maliwada',431002012);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('011','0003','Jalna Road',431011003);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('004','0002','Shahaganj',431004002);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('010','0000','Service Branch (ser)',400010000);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('005','0003','Kranti Chowk',431005003);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('007','0003','Aurangabad',431007003);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('002','0845','Sbi Midc Jalgaon',425002845);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('004','0005','Railway Station',431004005);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('002','0010','Samarth Nagar',431002010);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('002','0003','Waluj Branch',431002003);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('002','0000','SBI',400002000);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('004','0004','Shastri Nagar',431004004);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('002','0844','Sbi Dana Bazar Jalgaon',425002844);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('004','0000','Sbh',400004000);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('002','0842','State Bank Of India Main Br Jalgaon',425002842);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('004','0011','Town Centre',431004011);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('002','0846','Sbi Adb Jalgaon',425002846);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('005','0002','Fort (for)',400005002);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('004','0916','State Bank Of Hyderabad Jalgaon',425004916);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('010','0912','Allahabad Bank Jalgaon',425010912);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('006','0001','Service Branch(ser)',400006001);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('007','0052','Sbpatiyala',400007052);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('011','0000','Andhra Bank',400011000);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('002','0011','Harsul',431002011);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('002','0009','Juna Mondha',431002009);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('004','0003','Mill Corner',431004003);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('004','0008','Sanmitra Colony',431004008);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('010','0004','Bhandup (bhp)',400010004);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('002','0843','Sbi Zila Peth Jalgaon',425002843);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('010','0052','Allahabad Bank',400010052);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('010','0002','Andheri (and)',400010002);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('004','0013','Waluj Branch',431004013);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('004','0010','Kanchanwadi',431004010);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('002','0005','Kranti Chowk',431002005);
insert  into `brnchmstr`(`bank`,`branch`,`branchName`,`clrgCode`) values ('002','0018','Churchgate',400002018);

/*Table structure for table `brnchprmtrs` */

DROP TABLE IF EXISTS `brnchprmtrs`;

CREATE TABLE `brnchprmtrs` (
  `bank` char(3) NOT NULL default '',
  `branch` char(4) NOT NULL default '',
  `branchName` varchar(45) NOT NULL,
  `todaysDate` date NOT NULL default '0000-00-00',
  `multiCurrency` enum('Y','N') default 'N',
  `denomRequired` enum('Y','N') default 'N',
  `tellerSystem` enum('Y','N') NOT NULL default 'N',
  `active` enum('Y','N') default 'N',
  `autoAuthorise` enum('Y','N') default 'N',
  `goByLevels` enum('Y','N') default 'N',
  `clrgParticipate` enum('Y','N') default NULL COMMENT 'participate in clrg?',
  `clrgIwMltplBatches` enum('Y','N') default NULL COMMENT 'allow multiple batches?',
  `clrgIwAc` varchar(19) default NULL COMMENT 'iw clrg ac',
  `clrgIwAcid` bigint(16) default NULL,
  `clrgIwSusAc` varchar(19) default NULL COMMENT 'clrg suspense ac',
  `clrgIwSusAcid` bigint(16) default NULL,
  `clrgIwRcvblAc` varchar(19) default NULL COMMENT 'clrg receivable ac',
  `clrgIwRcvblAcid` bigint(16) default NULL,
  `clrgIwPayblAc` varchar(19) default NULL COMMENT 'clrg payable ac',
  `clrgIwPayblAcid` bigint(16) default NULL,
  `clrgIwSrvcBrnch` char(4) default NULL COMMENT 'branch code of service branch',
  `clrgIwSrvcBrnchAdjAc` varchar(19) default NULL COMMENT 'adj ac for this branch in srvcBranch books',
  `clrgIwSrvcBrnchAdjAcid` bigint(16) default NULL,
  UNIQUE KEY `bankBranch` (`bank`,`branch`)
) ENGINE=MyISAM  ;

/*Data for the table `brnchprmtrs` */

insert  into `brnchprmtrs`(`bank`,`branch`,`branchName`,`todaysDate`,`multiCurrency`,`denomRequired`,`tellerSystem`,`active`,`autoAuthorise`,`goByLevels`,`clrgParticipate`,`clrgIwMltplBatches`,`clrgIwAc`,`clrgIwAcid`,`clrgIwSusAc`,`clrgIwSusAcid`,`clrgIwRcvblAc`,`clrgIwRcvblAcid`,`clrgIwPayblAc`,`clrgIwPayblAcid`,`clrgIwSrvcBrnch`,`clrgIwSrvcBrnchAdjAc`,`clrgIwSrvcBrnchAdjAcid`) values ('412','0002','Pradhikaran, Nigdi','2011-08-18','Y','N','Y','Y','N','N','N','N','99 001 101309',775,'99 001 101310',776,'99 001 101310',776,'99 001 101310',776,'0004','99 001 211001',151);
insert  into `brnchprmtrs`(`bank`,`branch`,`branchName`,`todaysDate`,`multiCurrency`,`denomRequired`,`tellerSystem`,`active`,`autoAuthorise`,`goByLevels`,`clrgParticipate`,`clrgIwMltplBatches`,`clrgIwAc`,`clrgIwAcid`,`clrgIwSusAc`,`clrgIwSusAcid`,`clrgIwRcvblAc`,`clrgIwRcvblAcid`,`clrgIwPayblAc`,`clrgIwPayblAcid`,`clrgIwSrvcBrnch`,`clrgIwSrvcBrnchAdjAc`,`clrgIwSrvcBrnchAdjAcid`) values ('412','0004','Pimpri Main Branch','2011-08-18','Y','N','Y','Y','N','N','Y','N','99 001 101309',1173,'99 001 210007',120,'99 001 111001',232,'99 001 206001',103,'0004','99 001 211003',153);
insert  into `brnchprmtrs`(`bank`,`branch`,`branchName`,`todaysDate`,`multiCurrency`,`denomRequired`,`tellerSystem`,`active`,`autoAuthorise`,`goByLevels`,`clrgParticipate`,`clrgIwMltplBatches`,`clrgIwAc`,`clrgIwAcid`,`clrgIwSusAc`,`clrgIwSusAcid`,`clrgIwRcvblAc`,`clrgIwRcvblAcid`,`clrgIwPayblAc`,`clrgIwPayblAcid`,`clrgIwSrvcBrnch`,`clrgIwSrvcBrnchAdjAc`,`clrgIwSrvcBrnchAdjAcid`) values ('412','0003','Nehru Stadium, Balewadi','2011-08-18','Y','Y','Y','Y','N','N','N','N','99 001 101309',1172,'99 001 101310',745,'99 001 101310',745,'99 001 101310',745,'0004','99 001 211002',152);

/*Table structure for table `currencies` */

DROP TABLE IF EXISTS `currencies`;

CREATE TABLE `currencies` (
  `currencyCode` char(3) NOT NULL,
  `description` varchar(45) NOT NULL,
  `demoColumn1` date default NULL,
  `dcmlPlaces` smallint(1) NOT NULL default '2',
  `demoColumn2` varchar(10) default NULL,
  PRIMARY KEY  (`currencyCode`)
) ENGINE=InnoDB  ;

/*Data for the table `currencies` */

insert  into `currencies`(`currencyCode`,`description`,`demoColumn1`,`dcmlPlaces`,`demoColumn2`) values ('abc','some new code',NULL,5,NULL);
insert  into `currencies`(`currencyCode`,`description`,`demoColumn1`,`dcmlPlaces`,`demoColumn2`) values ('aud','Australian Dollar',NULL,2,NULL);
insert  into `currencies`(`currencyCode`,`description`,`demoColumn1`,`dcmlPlaces`,`demoColumn2`) values ('bth','Thailand Bhath',NULL,2,NULL);
insert  into `currencies`(`currencyCode`,`description`,`demoColumn1`,`dcmlPlaces`,`demoColumn2`) values ('eur','Euro',NULL,2,NULL);
insert  into `currencies`(`currencyCode`,`description`,`demoColumn1`,`dcmlPlaces`,`demoColumn2`) values ('gbp','British Pound',NULL,3,NULL);
insert  into `currencies`(`currencyCode`,`description`,`demoColumn1`,`dcmlPlaces`,`demoColumn2`) values ('inr','Indian Rupees',NULL,2,NULL);
insert  into `currencies`(`currencyCode`,`description`,`demoColumn1`,`dcmlPlaces`,`demoColumn2`) values ('krn','Swedish Kroner',NULL,2,NULL);
insert  into `currencies`(`currencyCode`,`description`,`demoColumn1`,`dcmlPlaces`,`demoColumn2`) values ('lir','Italian Lira',NULL,2,NULL);
insert  into `currencies`(`currencyCode`,`description`,`demoColumn1`,`dcmlPlaces`,`demoColumn2`) values ('npr','Nepalese Ruppee',NULL,2,NULL);
insert  into `currencies`(`currencyCode`,`description`,`demoColumn1`,`dcmlPlaces`,`demoColumn2`) values ('usd','US Dollar',NULL,2,NULL);
insert  into `currencies`(`currencyCode`,`description`,`demoColumn1`,`dcmlPlaces`,`demoColumn2`) values ('yen','Japanese Yen',NULL,0,NULL);

/*Table structure for table `generalledgermstr` */

DROP TABLE IF EXISTS `generalledgermstr`;

CREATE TABLE `generalledgermstr` (
  `id` bigint(10) NOT NULL auto_increment,
  `bank` char(3) NOT NULL,
  `acNo` char(17) NOT NULL,
  `acName` varchar(45) default NULL,
  `glType` enum('A','L','E','R') NOT NULL,
  `permittedTransactions` varchar(30) NOT NULL,
  `active` enum('Y','N') NOT NULL default 'N',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `GLmstr` (`bank`,`acNo`)
) ENGINE=InnoDB AUTO_INCREMENT=1895  ;

/*Data for the table `generalledgermstr` */

insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1501,'412','99001101312','S B I MOTALA','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1502,'412','99001101313','S.B.I. AURANGABAD','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1503,'412','99001101401','BANK OF MAHA.MLK','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1504,'412','99001101402','BANK OF MAHA.MEHEKAR','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1505,'412','99001101403','BANK OF BARODA AKOLA','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1506,'412','99001101404','BANK OF BARODA A\'BAD','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1507,'412','99001101405','BANK OF BARODA JALNA','A','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1508,'412','99001101406','PUNJAB NATIONAL BANK','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1509,'412','99001101501','AKOLA JANTA COMM.','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1510,'412','99001101502','JALGAON JANTA BANK','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1511,'412','99001101503','JALNA PEOPLES BANK','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1512,'412','99001101504','MADHAVPURA - MUMBAI','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1513,'412','99001101505','MADHAVPURA AHMEDABAD','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1514,'412','99001101506','MADHAVPURA - SURAT','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1515,'412','99001101507','SARASWAT BANK WALUJ','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1516,'412','99001101508','AKOLA URBAN BANK AKL','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1517,'412','99001101509','ICHALK. JANTA H.O','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1518,'412','99001101510','ICHALKAR. JANTA PUNE','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1519,'412','99001101512','SANGLI BANK LTD.','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1520,'412','99001101513','H.D.F.C.BANK,PUNE','A','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1521,'412','99001101514','ICICI BANK LTD.,','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1522,'412','99001101515','I.D.B.I.BANK','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1523,'412','99001101516','INDUSIND BANK A/C','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1524,'412','99001101601','B.D.C.C.MALKAPUR','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1525,'412','99001101602','B.D.C.C.CHIKHLI','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1526,'412','99001101603','B.D.C.C.MEHEKAR','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1527,'412','99001101604','B.D.C.C.MOTALA','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1528,'412','99001101605','J.D.C.C.BHOKARDAN','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1529,'412','99001101606','A.D.C.C.SILLOD','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1530,'412','99001101607','A.D.C.C. AURANGABAD','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1531,'412','99001101608','J.D.C.C. BANK JALNA','A','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1532,'412','99001101701','POST OFFICE S.B.A/C','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1533,'412','99001101702','B.D.C.C.SAVING A/C','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1534,'412','99001101703','STOCK HOLDING CORPO','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1535,'412','99001102101','FD M.S.C.BANK MUMBAI','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1536,'412','99001102102','FD M.S.C.BANK NAGPUR','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1537,'412','99001102103','FD M.S.C.BANK A\'BAD','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1538,'412','99001102201','FD APEX BANK (M&G)','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1539,'412','99001102301','FD B.D.C.C.BANK MKU.','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1540,'412','99001102302','FD A.D.C.C.BANK','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1541,'412','99001102303','FD J.D.C.C.BANK','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1542,'412','99001102401','FD IN CBI- BULDHANA','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1543,'412','99001102402','FD MADHAVPURA AHMD.','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1544,'412','99001102403','FD MADHAVPURA SURAT','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1545,'412','99001102404','FD WITH JALG\'N JANTA','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1546,'412','99001102405','FD MADHAVPURA MUMBAI','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1547,'412','99001102406','FD WITH H.D.F.C.BANK','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1548,'412','99001102407','FDR SARASWAT BANK','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1549,'412','99001102408','FDR WITH AKOLA JANTA','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1550,'412','99001102501','FDR WITH SBI / SBH','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1551,'412','99001102502','FD BANK OF BARODA','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1552,'412','99001102503','FD WITH ICICI BANK','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1553,'412','99001102504','FD PANJAB NATIONAL','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1554,'412','99001102505','FD BANK OF RAJASTAN','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1555,'412','99001103001','FD B.D.C.C.BANK(RFI)','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1556,'412','99001103002','FD B.D.C.C.(STAF WF)','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1557,'412','99001103003','FD M.S.C.BANK(RFI)','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1558,'412','99001103004','INDIRA VIKAS PATRA','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1559,'412','99001103005','SHARE IN B.D.C.C.','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1560,'412','99001103006','SHARE IN M.S.C.BANK','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1561,'412','99001103007','SHARE IN APEX BANK','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1562,'412','99001103008','SEC.DEPO.M.S.C.BANK','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1563,'412','99001103009','GOVERNMENT SECURITY','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1564,'412','99001103010','FD A.D.C.C.BANK(RFI)','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1565,'412','99001103011','M C D C 7 YEAR BOND','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1566,'412','99001103012','GOI HELD FOR MATURIT','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1567,'412','99001103013','GOI AVBLE FOR SALE','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1568,'412','99001103014','GOI HELD FOR TRADING','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1569,'412','99001103015','UNITS OF U.T.I.','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1570,'412','99001103016','NON-SLR INVESTMENTS','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1571,'412','99001104101','ADV.AGST.PLEDGE','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1572,'412','99001104102','ADV.AGST W.HOUSE REC','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1573,'412','99001104103','HYPO.AGST.STOCK','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1574,'412','99001104104','GOLD LOAN','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1575,'412','99001104105','HOUSING LOAN','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1576,'412','99001104106','C.C.AGST REAL ESTATE','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1577,'412','99001104107','ADV.AGST GOVT.SECU.','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1578,'412','99001104108','VEHICAL LOAN','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1579,'412','99001104109','L.P.S.(SECURED)','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1580,'412','99001104110','LOAN AGST F.D.R.','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1581,'412','99001204103','SAVING DEPOSIT STAFF','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1582,'412','99001204201','FIXED DEPOSITS','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1583,'412','99001204202','KUBER FIXED DEPOSITS','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1584,'412','99001204203','CURRENT DEPOSIT(OP)','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1585,'412','99001204204','RECURRING DEPOSIT','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1586,'412','99001204205','PIGMY DEPOSITS','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1587,'412','99001204206','STAFF SECU.DEPOSITS','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1588,'412','99001204207','MATURED FIX DEPOSIT','L','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1589,'412','99001204208','CURRENT DEPOSIT(NOP)','L','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1590,'412','99001204209','FIX DEPOSIT(MONTHLY)','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1591,'412','99001204210','DHANSHREE BOND 2001','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1592,'412','99001204211','DHANSHREE BOND 2007','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1593,'412','99001204212','GOLDEN JUBILEE BOND','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1594,'412','99001204213','DAILY RECCURING  DEPOSIT','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1595,'412','99001204214','MATURE DEPOSIT(OVERDUE)','L','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1596,'412','99001205001','C.C.WITH M.S.C.BANK','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1597,'412','99001205002','O.D.WITH DIST.BANK','L','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1598,'412','99001205003','O.D.WITH M.S.C.BANK','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1599,'412','99001205004','O.D.WITH JAL.JAN.SAH','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1600,'412','99001205005','O.D.JANTA COMM AKOLA','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1601,'412','99001205006','O.D.WITH OTHER BANKS','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1602,'412','99001206001','INWARD BILLS PAYABLE','L','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1603,'412','99001206002','BILLS COLLECTION','L','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1604,'412','99001207001','OVERDUES INT.RESERVE','L','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1605,'412','99001207002','SUNDRY DEBITOR PROV.','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1606,'412','99001208001','INT PAYABLE ON F.D.','L','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1607,'412','99001208002','INT PAYABLE ON M.RD','L','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1608,'412','99001208003','INT PAYABLE ON PIGMY','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1609,'412','99001208004','INT PAYABLE (MFD)','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1610,'412','99001208005','O.D.INT PAYABLE-NPA','L','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1611,'412','99001208006','INT PAYABLE BROWING','L','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1612,'412','99001209001','BANK GUARANTEE PAYBL','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1613,'412','99001210001','SUNDRY CREDITORS','L','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1614,'412','99001210002','UNCLAIMED DIVIDEND','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1615,'412','99001210003','AUDIT FEE PAYABLE','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1616,'412','99001210004','EDUCATION FUND PAY','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1617,'412','99001210005','EX-GRACIA PAYABLE','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1618,'412','99001210006','SHARES SUSPENSE','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1619,'412','99001210007','SUSPENSE A/C','L','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1620,'412','99001210008','MPL.TAX PAYABLE','L','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1621,'412','99001210009','DEP.FOR DIRECTORSHIP','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1622,'412','99001210010','MISCELLOUS','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1623,'412','99001210011','UNCLAIMED DIV.: 9495','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1624,'412','99001210012','UNCLAIMED DIV.: 9596','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1625,'412','99001210013','PROFESSIONAL TAX','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1626,'412','99001210014','SHARES SUSPENSE A/C.','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1627,'412','99001210015','UNCLAIMED DIV.:96-97','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1628,'412','99001210016','UNCLAIM DIV.:97-98','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1629,'412','99001210017','BONUS PAY TO STAFF','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1630,'412','99001210018','T.D.S. A/C','L','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1631,'412','99001210019','UNCLAIM DIVI.: 98-99','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1632,'412','99001210020','UNCLAIM DIV. 99-2000','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1633,'412','99001210021','UNCLAIM DIV.:2000-01','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1634,'412','99001210022','D D PAYABLE A/C','L','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1635,'412','99001210023','SUBSIDY R.F.A/C','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1636,'412','99001210024','UNCLAIM DIV. 2001-02','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1637,'412','99001210025','STALE D.D. O/S A/C','L','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1638,'412','99001210026','UNCLAIM DIVI.2002-03','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1639,'412','99001210027','DIVIDEND PAYABLE A/C','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1640,'412','99001210028','SERVICE TAX PAYABLE','L','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1641,'412','99001210029','STF.GRATU.PRE.PAYABL','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1642,'412','99001210030','UNCLAIM DIVI 2004-05','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1643,'412','99001210031','INTT. DISCOUNT PROV.','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1644,'412','99001210032','UNCLAIM DIV. 2005-06','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1645,'412','99001210033','PROV FOR INCOME TAX','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1646,'412','99001210034','PROVISION FOR F.B.T.','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1647,'412','99001210035','PROV OF LEAVE ENCASH','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1648,'412','99001210036','UNCLAIM DIV.2006-07','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1649,'412','99001210040','DRD SUSPENCE A/C','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1650,'412','99001211001','Br.Adj, Pradhikaran','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1651,'412','99001211002','Br.Adj, Nehru Stadium','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1652,'412','99001211003','Br.Adj, Pimpri Main','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1653,'412','99001211004','BR.ADJ.SILLOD','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1654,'412','99001211005','BR.ADJ.CHIKHLI','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1655,'412','99001211006','BR.ADJ. MALKAPUR BR.','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1656,'412','99001211007','BR.ADJ.GULMANDI','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1657,'412','99001211008','BR.ADJ.WALUJ','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1658,'412','99001211009','BR.ADJ.JALNA','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1659,'412','99001211010','BR.ADJ.JADHAVWADI','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1660,'412','99001211011','BR.ADJ.JAWAHARCOLONY','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1661,'412','99001211012','BR.ADJ.RLY.STATION','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1662,'412','99001212001','PROFIT & LOSS A/C (LIABILITY)','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1663,'412','99002301001','XXXXXXXX','R','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1664,'412','99002302101','INT REC ON HYPO','R','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1665,'412','99002302102','INT REC ON LOAN FDR','R','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1666,'412','99002302103','INT REC ON LOAN R D ','R','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1667,'412','99002302104','INT REC ON GOLD','R','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1668,'412','99002302105','INT REC ON W HOUSE','R','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1669,'412','99002302106','INT REC ON TERM LOAN','R','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1670,'412','99002302107','INT REC ON CCRE','R','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1671,'412','99002302108','INT REC ON S L P S','R','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1672,'412','99001104111','LOAN AGST R.D.','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1673,'412','99001104112','OVERDRAFT','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1674,'412','99001104113','TERM LOAN A/C','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1675,'412','99001104114','VASTUPURTI HOUSING','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1676,'412','99001104115','EDUCATIONAL LOAN','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1677,'412','99001104201','CLEAN CASH CREDIT','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1678,'412','99001104202','L.P.S. (UNSECURED)','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1679,'412','99001104301','CONSIDERED B & DOUBT','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1680,'412','99001105101','INT RECVBLE ON TERM LOANS','A','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1681,'412','99001105102','INT RECVBLE WE-HOUSE','A','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1682,'412','99001105103','INT RECVBLE ON HYPO','A','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1683,'412','99001105104','INT RECVBLE ON GOLD','A','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1684,'412','99001105106','INT RECVBLE ON HOUSE','A','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1685,'412','99001105107','INT RECVBLE ON CCRE','A','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1686,'412','99001105108','INT RECVBLE ON EDUCATION','A','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1687,'412','99001105109','INT RECVBLE ON VEHI','A','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1688,'412','99001105110','INT RECVBLE ON SLPS','A','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1689,'412','99001105111','INT RECVBLE ON O.D.','A','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1690,'412','99001105112','INT RECVBLE ON C.C.','A','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1691,'412','99001105113','INT RECVBLE ON ULPS','A','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1692,'412','99001105114','INT RECVBLE HOU-STAF','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1693,'412','99001105201','INT RECEIVABLE (INV)','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1694,'412','99001106101','BUILDING A/C','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1695,'412','99001106102','FURNITURE & FIXTURES','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1696,'412','99001106103','DEAD STOCK A/C','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1697,'412','99001106104','LIBRARY BOOKS A/C','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1698,'412','99001106105','VEHICALS A/C','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1699,'412','99001106106','COMPUTER H/W & S/W','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1700,'412','99001106107','COMP.SOFTWARE A/C.','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1701,'412','99001106108','ELECTRICAL & ELE.EQU','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1702,'412','99001106109','SECURITY EQUIPMENTS','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1703,'412','99001106110','LAND A/C','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1704,'412','99001107101','STOCK OF STATIONARY','A','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1705,'412','99001107102','ADV.TO STAFF (VEH)','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1706,'412','99001107103','ADV.TO STAFF (HOUSE)','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1707,'412','99001107104','ADV.TO STAFF (FEST)','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1708,'412','99001107105','TELEPHONE DEPOSIT','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1709,'412','99001107106','M.S.E.B. DEPOSITS','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1710,'412','99001107107','GENERAL STAMP PAPERS','A','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1711,'412','99001107108','SILVER COINS','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1712,'412','99001107109','PREPAID EXPENSES','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1713,'412','99001107110','PREPAID TAX(VEHICAL)','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1714,'412','99001107112','DEP.WITH MPL.(WATER)','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1715,'412','99001107113','MISCELLANEOUS','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1716,'412','99001107114','ADVANCES TO STAFF','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1717,'412','99001107115','ADV.INS.PRE.ACC.POL.','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1718,'412','99001107116','DEPO.FOR BR.PREMISES','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1719,'412','99001107117','SUNDRI DEBITORS','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1720,'412','99001107118','BULD.CONSTRU.MOTALA','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1721,'412','99001107119','BR.FURNI.UNDER PROCE','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1722,'412','99001107120','ADVANCE INCOME TAX','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1723,'412','99001107121','CENVET CREDIT A/C','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1724,'412','99001107122','FRINGE BENEFIT TAX','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1725,'412','99001107123','DEPOSIT FOR LPG A/C','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1726,'412','99001107124','ADVANCE PMT. OF S/W','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1727,'412','99001107125','ADV. PAYMENT OF CBS','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1728,'412','99001107126','MAHA GOVT AGRI DEBT WAIVER','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1729,'412','99001109001','HEAD OFFICE ADJUSTME','A','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1730,'412','99001110101','PROFIT & LOSS A/C. LOSS','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1731,'412','99001111001','INWARD BILL RECVBLE','A','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1732,'412','99001111002','BILLS RECEIVABLE','A','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1733,'412','99001112001','BANK GUARANTEE RECV.','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1734,'412','99001115101','C.B.I.- MALKAPUR BR.','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1735,'412','99001115102','U.W.BANK MALKAPUR','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1736,'412','99001115103','NANDURA URBAN MKU.BR','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1737,'412','99001115104','S B I - ADB MKU. BR.','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1738,'412','99001115105','BULDANA GRAMIN BANK','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1739,'412','99001115106','AKOLA JANTA COMM.MKU','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1740,'412','99001115107','JIJAMATA M.N.S.BANK','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1741,'412','99001201002','SHARE CAPITAL','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1742,'412','99001201099','AUTHORISED CAPITAL','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1743,'412','99001202001','ENTRANCE FEE','L','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1744,'412','99001203001','STATUTORY RESERVE','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1745,'412','99001203002','BUILDING FUND','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1746,'412','99001203003','DIVIDEND EQU.FUND','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1747,'412','99001203004','B & D DEBTS RESERVE','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1748,'412','99001203005','STAFF WELFARE FUND','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1749,'412','99001203006','CHARITY FUND','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1750,'412','99001203007','SILVER JUBILEE FUND','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1751,'412','99001203008','BONUS EQU FUND','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1752,'412','99001203009','MEMBERS WELFARE FUND','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1753,'412','99001203010','N.P.A. PROVISION','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1754,'412','99001203011','STAFF PROVIDEND FUND','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1755,'412','99001203012','SOCIAL WELFARE FUND','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1756,'412','99001203013','CONTI.PROV.STANDARD','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1757,'412','99001203014','RESERVE FOR INVESTME','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1758,'412','99001203015','INVEST FLUCTION FUND','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1759,'412','99001203016','INV DEPRE\'N RESERVE','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1760,'412','99001203017','TECH.DEVLOPMENT FUND','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1761,'412','99001203018','STAFF BENIFIT FUND','L','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1762,'412','99001203019','ELECTION FUND','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1763,'412','99001204101','SAVING DEPOSIT (OP)','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1764,'412','99001204102','SAVING DEPOSIT (NOP)','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1765,'412','99002302109','INT REC ON VASTUPURTI','R','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1766,'412','99002302110','INT REC ON VEHICAL','R','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1767,'412','99002302111','INTEREST ON INVESTMN','R','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1768,'412','99002302112','INT REC ON EDUCATION LOAN','R','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1769,'412','99002302113','INT REC ON HOSE LOAN','R','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1770,'412','99002302114','INTER BR INTT.(R)','R','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1771,'412','99002302115','INTEREST ON SECUTITY','R','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1772,'412','99002302201','COMMISSION A/C','R','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1773,'412','99002302202','LOCK-INCIDENTAL A/C','R','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1774,'412','99002302203','SALE OF FORM A/C','R','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1775,'412','99002302204','SHARE TRANSFER FEE','R','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1776,'412','99002302205','BANK SHARE DEVIDEND','R','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1777,'412','99002302206','LOCKERS RENT A/C','R','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1778,'412','99002302207','PROFIT ON SECURITIES','R','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1779,'412','99002302208','PROFIT ON ASSET SALE','R','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1780,'412','99002302209','PROCESSING FEE A/C','R','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1781,'412','99002302210','OTHER COMMISSION','R','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1782,'412','99002302211','INCOME FROM KOTAK LI','R','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1783,'412','99002302212','INCOME TAX REFUND','R','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1784,'412','99002302213','F.B.T. REFUND','R','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1785,'412','99002302301','PROFIT & LOSS A/C','R','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1786,'412','99002401001','XXXXXXXX','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1787,'412','99002401002','XXXXXXXX','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1788,'412','99002402101','SALARY A/C','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1789,'412','99002402201','STAFF-PF BANK CONTRI','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1790,'412','99002402202','STAF WELFARE B.CONT','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1791,'412','99002402203','INSURANCE EXPENSES','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1792,'412','99002402204','PROFESSIONAL TAX EXP','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1793,'412','99002402205','REMONURATION EXPENSE','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1794,'412','99002402206','BONUS PAID TO STAFF','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1795,'412','99002402207','BONUS EX-GRATIA EXP.','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1796,'412','99002402208','FRINGE & OTH.BENIFIT','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1797,'412','99002402209','SHIEFTING CHARGES','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1798,'412','99002402210','TRAINING FEE (STAFF)','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1799,'412','99002402211','P.F. BANK MANGEMENT','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1800,'412','99002402212','STAFF REC.EXAM FEE','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1801,'412','99002402213','EMP.UNIFORM(DRESSES)','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1802,'412','99002402214','TRAINING FEE (DIREC)','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1803,'412','99002402301','LIGHTING EXPENSES','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1804,'412','99002402302','POST & TELEGRAPH','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1805,'412','99002402303','TELEPHONE EXPENSES','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1806,'412','99002402304','TRAVELLING EXPENSES','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1807,'412','99002402305','ADVERTISEMENT EXPEN','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1808,'412','99002402306','WATER EXPENSES','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1809,'412','99002402307','BUILDING REP & MAINT','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1810,'412','99002402308','VEHICAL EXPENSES','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1811,'412','99002402309','M.S.C.BANK ASSO.FEE','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1812,'412','99002402310','BOARD SITTING CHARGE','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1813,'412','99002402311','COMPUTER EXPENSES','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1814,'412','99002402312','DEPRECIATION','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1815,'412','99002402313','AUDIT FEE EXPENSES','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1816,'412','99002402314','EDUCATION FEE EXPEN.','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1817,'412','99002402315','SHOP ACT FEE','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1818,'412','99002402316','LEGAL FEE','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1819,'412','99002402317','O.D.INTEREST EXPENS.','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1820,'412','99002402318','POST OFFICE BOX RENT','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1821,'412','99002402319','MUNICIPAL TAX','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1822,'412','99002402320','GENERAL-STAMP EXPEN.','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1823,'412','99002402321','BAD & DOUBTFUL EXP.','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1824,'412','99002402322','CAR MAINTAINANCE A/C','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1825,'412','99002402323','XXXXXXXX','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1826,'412','99002402324','BR.EXPENSES - JALNA','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1827,'412','99002402325','DONATION ARMY FUND','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1828,'412','99002402326','A.G.M. EXPENSES A/C','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1829,'412','99002402327','ELECTION EXPENSES','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1830,'412','99002402328','BR.EXP.JADHAVWADI BR','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1831,'412','99002402329','BR.EXP.JAWAHAR COLON','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1832,'412','99002402330','OFFICE RENT A/C','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1833,'412','99002402331','RECOVERY EXPENSES','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1834,'412','99002402332','A.M.C. EXPENSES','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1835,'412','99002402333','BANK SECURITY CHARGE','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1836,'412','99002402334','EMPLOYEE WELFARE EXP','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1837,'412','99002402335','EQUIPMENT REPAIR A/C','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1838,'412','99002402336','LOSS SALE OF ASSETS','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1839,'412','99002402337','AUDIT EXPENSES','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1840,'412','99002402338','TRANS.TAX DEDUCT','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1841,'412','99002402339','F.B.T.EXPENSES A/C','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1842,'412','99002402340','CLEARING HOUSE EXP','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1843,'412','99002402341','RTO TRADE CERT.CHRG','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1844,'412','99002402342','NAZUL TAX EXP. A/C','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1845,'412','99002402399','XIGHTING EXPENSES','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1846,'412','99002402401','PRINTING-STATIONARY','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1847,'412','99002402501','CONTINGENCY A/C','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1848,'412','99002402601','DR COMMISSION','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1849,'412','99002402602','D. RECURRING COMM.','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1850,'412','99002403101','INTT ON SAVING DEPOSITS','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1851,'412','99002403102','INTT PAID ON DEPOSIT','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1852,'412','99002403103','INT PAID ON BORROWIN','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1853,'412','99002403104','INT PAID ON RECURRING DEPOSIT','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1854,'412','99002403105','INTT PAID ON PIGMY','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1855,'412','99002403106','XXXXXXXX','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1856,'412','99002403107','XXXXXXXX','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1857,'412','99002403108','INTER BRANCH INT.A/C','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1858,'412','99001101101','CASH IN HAND - INR','A','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1859,'412','99001101201','M.S.C.BANK MUMBAI','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1860,'412','99001101202','M.S.C.BANK NAGPUR','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1861,'412','99001101203','M.S.C.BANK AURANGABAD','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1862,'412','99001101204','APEX CO-OP MUMBAI','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1863,'412','99001101301','S.B.I. MALKAPUR','A','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1864,'412','99001101302','S.B.I. MEHKAR','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1865,'412','99001101303','S.B.I. CHIKHLI','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1866,'412','99001101304','S.B.I. A\'BAD','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1867,'412','99001101305','S.B.H. BHOKARDAN','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1868,'412','99001101306','S.B.H. SILLOD','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1869,'412','99001101307','S.B.H. AURANGABAD','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1870,'412','99001101308','S.B.H. JALNA','A','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1871,'412','99001101310','CLG HOUSE ADJ. A\\C','A','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1872,'412','99002402347','AMENITIES CHARGES','E','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1873,'412','99001101314','S.B.I.JALGAON','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1874,'412','99001101609','J.D.C.C. JALGAON','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1875,'412','99001101519','JALGAON JANTA SAHKARI BANK','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1876,'412','99002402346','BRANCH OPENING EXPENCES','E','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1877,'412','99001104117','DHANSHREE HOUSING LOAN','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1878,'412','99001105116','INTT RECVBLE ON DHAN HOUS LOAN','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1879,'412','99001104116','DHANSHREE VEHICAL LOAN','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1880,'412','99001105115','INTT RECVBLE ON DHAN VEH LOAN','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1881,'412','99002302116','INTT RECVD ON DHAN VEH LOAN','R','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1882,'412','99002302117','INTT RECVD ON DHAN HOUS LOAN','R','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1883,'412','99001107127','T D S RECEIVABLE','A','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1884,'412','99001211013','BR.ADJ.JALGAON','L','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1885,'412','99001101517','CLG ACCOUNT HDFC BANK','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1886,'412','99001101309','CLG.HOUSE ACCOUNT','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1887,'412','99001109002','ABB TRANSACTIONS','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1888,'412','99001211014','BR ADJ BHUSAWAL','L','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1889,'412','99001203021','BAD DEBT-MMCB PROVISION','L','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1890,'412','99001101520','SVC BANK AURANGABAD','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1891,'412','99001101518','AXIS BANK AURANGABAD','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1892,'412','99001101315','S.B.I. BHUSAWAL','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1893,'412','99001101610','J.D.C.C. BANK BHUSAWAL','A','','Y');
insert  into `generalledgermstr`(`id`,`bank`,`acNo`,`acName`,`glType`,`permittedTransactions`,`active`) values (1894,'412','99001101102','CASH IN HAND - OTHER CURRENCIES','A','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','Y');

/*Table structure for table `groups` */

DROP TABLE IF EXISTS `groups`;

CREATE TABLE `groups` (
  `grpId` varchar(20) NOT NULL,
  `grpDes` varchar(45) default NULL,
  `userMenu` varchar(25) NOT NULL,
  PRIMARY KEY  (`grpId`)
) ENGINE=InnoDB  ;

/*Data for the table `groups` */

insert  into `groups`(`grpId`,`grpDes`,`userMenu`) values ('clerk',NULL,'Teller');
insert  into `groups`(`grpId`,`grpDes`,`userMenu`) values ('manager',NULL,'Full');
insert  into `groups`(`grpId`,`grpDes`,`userMenu`) values ('officer',NULL,'Full');

/*Table structure for table `menuitem` */

DROP TABLE IF EXISTS `menuitem`;

CREATE TABLE `menuitem` (
  `itemId` bigint(10) NOT NULL auto_increment,
  `item` varchar(30) NOT NULL,
  `isParent` enum('Y','N') NOT NULL default 'N',
  `URL` varchar(75) default '',
  PRIMARY KEY  (`itemId`)
) ENGINE=MyISAM AUTO_INCREMENT=85  ;

/*Data for the table `menuitem` */

insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (1,'Main','Y','');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (2,'Accounts','Y','');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (3,'Customers','Y','');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (4,'Transactions','Y','');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (5,'Administration','Y','');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (6,'Account Opening','Y','');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (7,'Account Closing','Y','');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (8,'Account Maintenance','N','something.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (9,'Open Savings and Current','N','');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (10,'Open Term Deposits','N','');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (11,'Open Cash Credit','N','');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (12,'Open Term Loans','N','');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (13,'Close Savings and Current','N','');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (14,'Close Term Deposits','N','');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (15,'Close Cash Credit','N','');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (16,'Close Term Loans','N','');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (17,'Customer Creation','N','');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (18,'Customer Details Entry','N','');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (19,'Customer Authorisation','N','');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (20,'Cash Deposit','N','transactions/cash/cashDeposit/cashDeposit.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (21,'Cash Withdrawal','N','transactions/cash/cashWithdraw/cashW.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (22,'Transfer','N','transactions/xfr/xfr.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (78,'Clearing batch','N','Transactions/clearing/iClrg/iBtch.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (77,'Inward clearing','Y','');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (57,'Reset user password','N','maint/rstPswd.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (56,'Users','Y','');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (28,'Bank Param Maintenance','N','maint\\bank.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (29,'Masters','Y','');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (30,'Branch Param Maintenance','N','maint\\branch.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (74,'Vault','Y','');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (32,'Currency Maintenance','N','maint/crncy.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (33,'Exchange Rates','N','maint/exRt.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (34,'Menu Items','N','maint/mnuItm.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (35,'Cash Deposit Authorise','N','transactions/cash/cashDepositAuth/cashDepositAuth.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (44,'Reports and Queries','Y','');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (45,'Balance Sheet','N','rq/balSht.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (46,'Account balances','N','rq/acBalances.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (47,'Cash on hand','N','rq/cashOnHand.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (48,'User Cash','N','rq/userCash.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (49,'Statement of account','N','rq/stmnt.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (50,'Authorisation Rules','N','maint/authRules.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (51,'Menus','N','maint/menu.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (52,'Create new menu','N','maint/crNmenu.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (53,'Product Types','N','maint/prodTypes.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (54,'Product Sub Types','N','maint/prodSubTypes.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (55,'User maintenance','N','maint/user.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (62,'Denominations Maintenance','N','maint/denom.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (63,'User Limits maintenance','N','maint/usrLmt.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (64,'Cash Withdrawal Authorise','N','transactions/cash/cashWithdrawAuth/cashWauth.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (65,'Cash Disbursal','N','transactions/cash/cashWithdraw/cashDsbrs.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (66,'Signature Register','N','transactions/sign/sr.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (67,'Groups','N','maint/groups.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (68,'Group Limits','N','maint/grpLmt.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (69,'Short Cuts','N','maint/usrShrtCts.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (70,'Transfer Authorise','N','transactions/xfr/xfrAuth.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (71,'Cash Receipt Scroll','N','rq/cs.php?tp=R');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (72,'Cash Payment Scroll','N','rq/cs.php?tp=P');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (73,'Transfer Scroll','N','rq/ts.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (75,'Cash out','N','transactions/vault/vo.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (76,'Cash in','N','transactions/vault/vi.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (79,'Clearing entries','N','Transactions/clearing/iClrg/iEntry.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (80,'ProdType transCodes maintenanc','N','maint/prodTypeTransCodes.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (81,'Service branch Domain maint','N','maint/srvcBrnchDmn.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (82,'Bank currencies maintenance','N','maint/bnkCrncy.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (83,'Tally','N','Transactions/clearing/iClrg/iTally.php');
insert  into `menuitem`(`itemId`,`item`,`isParent`,`URL`) values (84,'Upload','N','Transactions/clearing/iClrg/iUpld.php');

/*Table structure for table `prodsubtypes` */

DROP TABLE IF EXISTS `prodsubtypes`;

CREATE TABLE `prodsubtypes` (
  `bank` varchar(3) NOT NULL,
  `prdType` varchar(3) NOT NULL,
  `prdSubType` varchar(4) NOT NULL,
  `name` varchar(45) default NULL,
  `nameShort` varchar(20) default NULL,
  `active` enum('Y','N') NOT NULL default 'N',
  `activatedDate` date default NULL,
  `permittedTransactions` varchar(30) NOT NULL,
  `deactivated` enum('Y','N') default NULL,
  `deactivateDate` date default NULL,
  `crncyCd` char(3) NOT NULL,
  `minBalWTchkBk` decimal(21,6) NOT NULL,
  `minBalWOchkBk` decimal(21,6) NOT NULL,
  `GLid` bigint(10) NOT NULL,
  `GLacNo` char(17) NOT NULL,
  `allowWithSlip` enum('Y','N') default 'N',
  `allowChkBk` enum('Y','N') default 'Y',
  `odTp` enum('Y','N') NOT NULL default 'N',
  PRIMARY KEY  (`bank`,`prdType`,`prdSubType`)
) ENGINE=MyISAM  ;

/*Data for the table `prodsubtypes` */

insert  into `prodsubtypes`(`bank`,`prdType`,`prdSubType`,`name`,`nameShort`,`active`,`activatedDate`,`permittedTransactions`,`deactivated`,`deactivateDate`,`crncyCd`,`minBalWTchkBk`,`minBalWOchkBk`,`GLid`,`GLacNo`,`allowWithSlip`,`allowChkBk`,`odTp`) values ('412','60','010','Fixed deposits','Fixed deposit','Y','2004-07-27','CSCR,CSDR,TRCR,TRDR,CLCR,','N','2004-07-27','inr','0.000000','0.000000',1582,'99001204201','N','N','N');
insert  into `prodsubtypes`(`bank`,`prdType`,`prdSubType`,`name`,`nameShort`,`active`,`activatedDate`,`permittedTransactions`,`deactivated`,`deactivateDate`,`crncyCd`,`minBalWTchkBk`,`minBalWOchkBk`,`GLid`,`GLacNo`,`allowWithSlip`,`allowChkBk`,`odTp`) values ('412','13','020','Adv.agst w.house rec','Ccwhr','Y','2004-07-31','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','N','2004-07-26','inr','0.000000','0.000000',1572,'99001104102','N','Y','N');
insert  into `prodsubtypes`(`bank`,`prdType`,`prdSubType`,`name`,`nameShort`,`active`,`activatedDate`,`permittedTransactions`,`deactivated`,`deactivateDate`,`crncyCd`,`minBalWTchkBk`,`minBalWOchkBk`,`GLid`,`GLacNo`,`allowWithSlip`,`allowChkBk`,`odTp`) values ('412','60','090','Dhanshree bond 2007','Db07','Y','2004-07-27','CSCR,CSDR,TRCR,TRDR,CLCR,','N','2004-07-27','inr','0.000000','0.000000',1592,'99001204211','N','N','N');
insert  into `prodsubtypes`(`bank`,`prdType`,`prdSubType`,`name`,`nameShort`,`active`,`activatedDate`,`permittedTransactions`,`deactivated`,`deactivateDate`,`crncyCd`,`minBalWTchkBk`,`minBalWOchkBk`,`GLid`,`GLacNo`,`allowWithSlip`,`allowChkBk`,`odTp`) values ('412','60','100','Golden jubilee bond','Gjb','Y','2004-07-27','CSCR,CSDR,TRCR,TRDR,CLCR,','N','2004-07-27','inr','0.000000','0.000000',1593,'99001204212','N','N','N');
insert  into `prodsubtypes`(`bank`,`prdType`,`prdSubType`,`name`,`nameShort`,`active`,`activatedDate`,`permittedTransactions`,`deactivated`,`deactivateDate`,`crncyCd`,`minBalWTchkBk`,`minBalWOchkBk`,`GLid`,`GLacNo`,`allowWithSlip`,`allowChkBk`,`odTp`) values ('412','50','130','Vastupurti housing','Vastu','Y','2004-07-30','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','N','2004-07-30','inr','0.000000','0.000000',1675,'99001104114','Y','N','N');
insert  into `prodsubtypes`(`bank`,`prdType`,`prdSubType`,`name`,`nameShort`,`active`,`activatedDate`,`permittedTransactions`,`deactivated`,`deactivateDate`,`crncyCd`,`minBalWTchkBk`,`minBalWOchkBk`,`GLid`,`GLacNo`,`allowWithSlip`,`allowChkBk`,`odTp`) values ('412','50','090','L.p.s.(secured)','Lpss','Y','2004-07-30','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','N','2004-07-30','inr','0.000000','0.000000',1579,'99001104109','Y','N','N');
insert  into `prodsubtypes`(`bank`,`prdType`,`prdSubType`,`name`,`nameShort`,`active`,`activatedDate`,`permittedTransactions`,`deactivated`,`deactivateDate`,`crncyCd`,`minBalWTchkBk`,`minBalWOchkBk`,`GLid`,`GLacNo`,`allowWithSlip`,`allowChkBk`,`odTp`) values ('412','50','120','Term loan a/c','Tll','Y','2004-07-30','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','N','2004-07-30','inr','0.000000','0.000000',1674,'99001104113','Y','N','N');
insert  into `prodsubtypes`(`bank`,`prdType`,`prdSubType`,`name`,`nameShort`,`active`,`activatedDate`,`permittedTransactions`,`deactivated`,`deactivateDate`,`crncyCd`,`minBalWTchkBk`,`minBalWOchkBk`,`GLid`,`GLacNo`,`allowWithSlip`,`allowChkBk`,`odTp`) values ('412','13','110','Loan agst r.d.','Lard','Y','2004-07-30','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','N','2004-07-30','inr','0.000000','0.000000',1672,'99001104111','Y','Y','N');
insert  into `prodsubtypes`(`bank`,`prdType`,`prdSubType`,`name`,`nameShort`,`active`,`activatedDate`,`permittedTransactions`,`deactivated`,`deactivateDate`,`crncyCd`,`minBalWTchkBk`,`minBalWOchkBk`,`GLid`,`GLacNo`,`allowWithSlip`,`allowChkBk`,`odTp`) values ('412','13','100','Loan agst f.d.r.','Lafd','Y','2004-07-30','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','N','2004-07-30','inr','0.000000','0.000000',1580,'99001104110','Y','Y','N');
insert  into `prodsubtypes`(`bank`,`prdType`,`prdSubType`,`name`,`nameShort`,`active`,`activatedDate`,`permittedTransactions`,`deactivated`,`deactivateDate`,`crncyCd`,`minBalWTchkBk`,`minBalWOchkBk`,`GLid`,`GLacNo`,`allowWithSlip`,`allowChkBk`,`odTp`) values ('412','50','180','Housing loan','Hl','Y','2004-07-30','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','N','2004-07-30','inr','0.000000','0.000000',1575,'99001104105','Y','N','N');
insert  into `prodsubtypes`(`bank`,`prdType`,`prdSubType`,`name`,`nameShort`,`active`,`activatedDate`,`permittedTransactions`,`deactivated`,`deactivateDate`,`crncyCd`,`minBalWTchkBk`,`minBalWOchkBk`,`GLid`,`GLacNo`,`allowWithSlip`,`allowChkBk`,`odTp`) values ('412','50','080','Vehical loan','Vl','Y','2004-09-04','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','N','2004-09-04','inr','0.000000','0.000000',1578,'99001104108','Y','N','N');
insert  into `prodsubtypes`(`bank`,`prdType`,`prdSubType`,`name`,`nameShort`,`active`,`activatedDate`,`permittedTransactions`,`deactivated`,`deactivateDate`,`crncyCd`,`minBalWTchkBk`,`minBalWOchkBk`,`GLid`,`GLacNo`,`allowWithSlip`,`allowChkBk`,`odTp`) values ('412','13','030','Hypo.agst.stock','Cchyp','Y','2004-07-31','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','N','2004-07-26','inr','0.000000','0.000000',1573,'99001104103','Y','Y','N');
insert  into `prodsubtypes`(`bank`,`prdType`,`prdSubType`,`name`,`nameShort`,`active`,`activatedDate`,`permittedTransactions`,`deactivated`,`deactivateDate`,`crncyCd`,`minBalWTchkBk`,`minBalWOchkBk`,`GLid`,`GLacNo`,`allowWithSlip`,`allowChkBk`,`odTp`) values ('412','60','020','Kuber fixed deposits','Kuber fixed deposit','Y','2004-07-27','CSCR,CSDR,TRCR,TRDR,CLCR,','N','2004-07-27','inr','0.000000','0.000000',1583,'99001204202','N','N','N');
insert  into `prodsubtypes`(`bank`,`prdType`,`prdSubType`,`name`,`nameShort`,`active`,`activatedDate`,`permittedTransactions`,`deactivated`,`deactivateDate`,`crncyCd`,`minBalWTchkBk`,`minBalWOchkBk`,`GLid`,`GLacNo`,`allowWithSlip`,`allowChkBk`,`odTp`) values ('412','60','030','Recurring deposit','Rd','Y','2004-07-27','CSCR,CSDR,TRCR,TRDR,CLCR,','N','2004-07-27','inr','0.000000','0.000000',1585,'99001204204','N','N','N');
insert  into `prodsubtypes`(`bank`,`prdType`,`prdSubType`,`name`,`nameShort`,`active`,`activatedDate`,`permittedTransactions`,`deactivated`,`deactivateDate`,`crncyCd`,`minBalWTchkBk`,`minBalWOchkBk`,`GLid`,`GLacNo`,`allowWithSlip`,`allowChkBk`,`odTp`) values ('412','11','010','Current deposit(op)','Cd','Y','2004-07-26','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','N','2004-07-26','inr','1000.000000','1000.000000',1584,'99001204203','Y','Y','N');
insert  into `prodsubtypes`(`bank`,`prdType`,`prdSubType`,`name`,`nameShort`,`active`,`activatedDate`,`permittedTransactions`,`deactivated`,`deactivateDate`,`crncyCd`,`minBalWTchkBk`,`minBalWOchkBk`,`GLid`,`GLacNo`,`allowWithSlip`,`allowChkBk`,`odTp`) values ('412','13','050','C.c.agst real estate','Ccrel','Y','2004-07-31','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','N','2004-07-26','inr','0.000000','0.000000',1576,'99001104106','Y','Y','N');
insert  into `prodsubtypes`(`bank`,`prdType`,`prdSubType`,`name`,`nameShort`,`active`,`activatedDate`,`permittedTransactions`,`deactivated`,`deactivateDate`,`crncyCd`,`minBalWTchkBk`,`minBalWOchkBk`,`GLid`,`GLacNo`,`allowWithSlip`,`allowChkBk`,`odTp`) values ('412','99','001','Balance sheet h/o','Balance sheet h/o','N','2004-08-13','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','N','2004-12-20','inr','0.000000','0.000000',-1,'','Y','N','N');
insert  into `prodsubtypes`(`bank`,`prdType`,`prdSubType`,`name`,`nameShort`,`active`,`activatedDate`,`permittedTransactions`,`deactivated`,`deactivateDate`,`crncyCd`,`minBalWTchkBk`,`minBalWOchkBk`,`GLid`,`GLacNo`,`allowWithSlip`,`allowChkBk`,`odTp`) values ('412','99','002','Profit & loss a/c','Profit & loss a/c','N','2004-08-13','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','N','2004-12-20','inr','0.000000','0.000000',-1,'','Y','N','N');
insert  into `prodsubtypes`(`bank`,`prdType`,`prdSubType`,`name`,`nameShort`,`active`,`activatedDate`,`permittedTransactions`,`deactivated`,`deactivateDate`,`crncyCd`,`minBalWTchkBk`,`minBalWOchkBk`,`GLid`,`GLacNo`,`allowWithSlip`,`allowChkBk`,`odTp`) values ('412','10','010','Saving deposit (op)','Sb','Y','1901-07-19','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','N','1901-08-19','inr','500.000000','100.000000',1763,'99001204101','Y','Y','N');
insert  into `prodsubtypes`(`bank`,`prdType`,`prdSubType`,`name`,`nameShort`,`active`,`activatedDate`,`permittedTransactions`,`deactivated`,`deactivateDate`,`crncyCd`,`minBalWTchkBk`,`minBalWOchkBk`,`GLid`,`GLacNo`,`allowWithSlip`,`allowChkBk`,`odTp`) values ('412','60','080','Dhanshree bond 2001','Db01','Y','2004-07-27','CSCR,CSDR,TRCR,TRDR,CLCR,','N','2004-07-27','inr','0.000000','0.000000',1591,'99001204210','Y','N','Y');
insert  into `prodsubtypes`(`bank`,`prdType`,`prdSubType`,`name`,`nameShort`,`active`,`activatedDate`,`permittedTransactions`,`deactivated`,`deactivateDate`,`crncyCd`,`minBalWTchkBk`,`minBalWOchkBk`,`GLid`,`GLacNo`,`allowWithSlip`,`allowChkBk`,`odTp`) values ('412','13','040','Clean cash credit','Ccc','Y','2004-07-31','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','N','2004-07-26','inr','0.000000','0.000000',1677,'99001104201','Y','Y','N');
insert  into `prodsubtypes`(`bank`,`prdType`,`prdSubType`,`name`,`nameShort`,`active`,`activatedDate`,`permittedTransactions`,`deactivated`,`deactivateDate`,`crncyCd`,`minBalWTchkBk`,`minBalWOchkBk`,`GLid`,`GLacNo`,`allowWithSlip`,`allowChkBk`,`odTp`) values ('412','50','170','Gold loan','Gld','Y','2004-08-13','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','N','2004-08-13','inr','0.000000','0.000000',1574,'99001104104','Y','N','N');
insert  into `prodsubtypes`(`bank`,`prdType`,`prdSubType`,`name`,`nameShort`,`active`,`activatedDate`,`permittedTransactions`,`deactivated`,`deactivateDate`,`crncyCd`,`minBalWTchkBk`,`minBalWOchkBk`,`GLid`,`GLacNo`,`allowWithSlip`,`allowChkBk`,`odTp`) values ('412','50','150','L.p.s. (unsecured)','Lpsu','Y','2004-07-30','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','N','2004-07-30','inr','0.000000','0.000000',1678,'99001104202','Y','N','N');
insert  into `prodsubtypes`(`bank`,`prdType`,`prdSubType`,`name`,`nameShort`,`active`,`activatedDate`,`permittedTransactions`,`deactivated`,`deactivateDate`,`crncyCd`,`minBalWTchkBk`,`minBalWOchkBk`,`GLid`,`GLacNo`,`allowWithSlip`,`allowChkBk`,`odTp`) values ('412','50','140','Educational loan','Edul','Y','2004-07-30','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','N','2004-07-30','inr','0.000000','0.000000',1676,'99001104115','Y','N','N');
insert  into `prodsubtypes`(`bank`,`prdType`,`prdSubType`,`name`,`nameShort`,`active`,`activatedDate`,`permittedTransactions`,`deactivated`,`deactivateDate`,`crncyCd`,`minBalWTchkBk`,`minBalWOchkBk`,`GLid`,`GLacNo`,`allowWithSlip`,`allowChkBk`,`odTp`) values ('412','50','081','Dhanshree vehical loan','Vld','Y','2009-12-19','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','N',NULL,'inr','0.000000','0.000000',1879,'99001104116','Y','N','N');
insert  into `prodsubtypes`(`bank`,`prdType`,`prdSubType`,`name`,`nameShort`,`active`,`activatedDate`,`permittedTransactions`,`deactivated`,`deactivateDate`,`crncyCd`,`minBalWTchkBk`,`minBalWOchkBk`,`GLid`,`GLacNo`,`allowWithSlip`,`allowChkBk`,`odTp`) values ('412','50','240','Dhanshri house loan','Dhl','Y','2009-12-19','CSCR,CSDR,TRCR,TRDR,CLCR,CLDR,','N',NULL,'inr','0.000000','0.000000',1877,'99001104117','Y','N','N');
insert  into `prodsubtypes`(`bank`,`prdType`,`prdSubType`,`name`,`nameShort`,`active`,`activatedDate`,`permittedTransactions`,`deactivated`,`deactivateDate`,`crncyCd`,`minBalWTchkBk`,`minBalWOchkBk`,`GLid`,`GLacNo`,`allowWithSlip`,`allowChkBk`,`odTp`) values ('412','60','070','Fix deposit(monthly)','Mip','Y','2004-07-27','CSCR,CSDR,TRCR,TRDR,CLCR,','N','2004-07-27','inr','0.000000','0.000000',1590,'99001204209','N','N','N');
insert  into `prodsubtypes`(`bank`,`prdType`,`prdSubType`,`name`,`nameShort`,`active`,`activatedDate`,`permittedTransactions`,`deactivated`,`deactivateDate`,`crncyCd`,`minBalWTchkBk`,`minBalWOchkBk`,`GLid`,`GLacNo`,`allowWithSlip`,`allowChkBk`,`odTp`) values ('412','63','010','Daily reccuring deposit','Drd','Y','2008-12-19','CSCR,CSDR,TRCR,TRDR,CLCR,','N',NULL,'inr','0.000000','0.000000',1594,'99001204213','Y','N','N');

/*Table structure for table `prodtypes` */

DROP TABLE IF EXISTS `prodtypes`;

CREATE TABLE `prodtypes` (
  `bank` varchar(3) NOT NULL,
  `productCd` varchar(3) NOT NULL,
  `description` varchar(45) NOT NULL,
  `maxCashCr` decimal(21,6) NOT NULL,
  `maxCashDr` decimal(21,6) NOT NULL default '0.000000',
  `active` enum('Y','N') NOT NULL default 'N',
  `basePrdType` enum('BG','BL','DD','DL','LC','OT','TD','TL') NOT NULL,
  PRIMARY KEY  (`bank`,`productCd`)
) ENGINE=MyISAM  ;

/*Data for the table `prodtypes` */

insert  into `prodtypes`(`bank`,`productCd`,`description`,`maxCashCr`,`maxCashDr`,`active`,`basePrdType`) values ('412','11','Current account','49999.000000','99999.000000','Y','DD');
insert  into `prodtypes`(`bank`,`productCd`,`description`,`maxCashCr`,`maxCashDr`,`active`,`basePrdType`) values ('412','13','Cash credit','0.000000','0.000000','Y','DL');
insert  into `prodtypes`(`bank`,`productCd`,`description`,`maxCashCr`,`maxCashDr`,`active`,`basePrdType`) values ('412','99','General ledger','0.000000','0.000000','Y','OT');
insert  into `prodtypes`(`bank`,`productCd`,`description`,`maxCashCr`,`maxCashDr`,`active`,`basePrdType`) values ('412','18','Overdraft','0.000000','0.000000','Y','DL');
insert  into `prodtypes`(`bank`,`productCd`,`description`,`maxCashCr`,`maxCashDr`,`active`,`basePrdType`) values ('412','10','Saving bank','49999.000000','99999.000000','Y','DD');
insert  into `prodtypes`(`bank`,`productCd`,`description`,`maxCashCr`,`maxCashDr`,`active`,`basePrdType`) values ('412','60','Term deposit','0.000000','0.000000','Y','TD');
insert  into `prodtypes`(`bank`,`productCd`,`description`,`maxCashCr`,`maxCashDr`,`active`,`basePrdType`) values ('412','50','Term loan','0.000000','0.000000','Y','TL');
insert  into `prodtypes`(`bank`,`productCd`,`description`,`maxCashCr`,`maxCashDr`,`active`,`basePrdType`) values ('412','BD','Bill discounted','0.000000','0.000000','Y','BL');
insert  into `prodtypes`(`bank`,`productCd`,`description`,`maxCashCr`,`maxCashDr`,`active`,`basePrdType`) values ('412','63','Daily rd deposit','0.000000','0.000000','Y','TD');

/*Table structure for table `users` */

DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `userId` varchar(20) NOT NULL default '',
  `userName` varchar(45) default NULL,
  `passWrd` varchar(32) NOT NULL default '',
  `passWrdDt` date NOT NULL,
  `passwordStatus` enum('N','O','X','L') default 'N' COMMENT 'Normal, Onetime, eXpired, bLocked',
  `validUpto` date NOT NULL,
  `parentBank` char(3) NOT NULL default '',
  `parentBranch` varchar(4) NOT NULL default '',
  `multiCurrency` enum('N','Y') default 'N' COMMENT 'can operate multi currencies?',
  `isCashTell` enum('C','T','N','V') default 'N' COMMENT 'Cashier, Teller, None, Vault',
  `lang` char(2) NOT NULL default 'en',
  `autoAuthorise` enum('Y','N') NOT NULL default 'N',
  `selfAuthorise` enum('Y','N') default 'N',
  `userLevel` smallint(2) NOT NULL default '0',
  `userType` enum('DBA','SDBA','NORM') NOT NULL default 'NORM',
  `sgnAlw` enum('Y','N') default 'N' COMMENT 'can view signatures?',
  `grp` varchar(20) default NULL COMMENT 'group code',
  `isHC` enum('Y','N') default 'N' COMMENT 'head cashier',
  `canOperateVault` enum('Y','N') default 'N',
  PRIMARY KEY  (`userId`),
  KEY `users_ibfk_1` (`grp`),
  CONSTRAINT `users_ibfk_1` FOREIGN KEY (`grp`) REFERENCES `groups` (`grpId`)
) ENGINE=InnoDB  ;

/*Data for the table `users` */

insert  into `users`(`userId`,`userName`,`passWrd`,`passWrdDt`,`passwordStatus`,`validUpto`,`parentBank`,`parentBranch`,`multiCurrency`,`isCashTell`,`lang`,`autoAuthorise`,`selfAuthorise`,`userLevel`,`userType`,`sgnAlw`,`grp`,`isHC`,`canOperateVault`) values ('abc','some name','','2001-01-01','N','2001-01-01','412','0004','N','T','en','N','N',4,'NORM','N','officer','N','N');
insert  into `users`(`userId`,`userName`,`passWrd`,`passWrdDt`,`passwordStatus`,`validUpto`,`parentBank`,`parentBranch`,`multiCurrency`,`isCashTell`,`lang`,`autoAuthorise`,`selfAuthorise`,`userLevel`,`userType`,`sgnAlw`,`grp`,`isHC`,`canOperateVault`) values ('apeksha','Apeksha Bhagchandani','907a12b8fc4467f9e66b0f2cd24cd7df','2001-01-01','N','2001-01-01','412','0004','N','C','en','N','N',0,'NORM','N','officer','Y','N');
insert  into `users`(`userId`,`userName`,`passWrd`,`passWrdDt`,`passwordStatus`,`validUpto`,`parentBank`,`parentBranch`,`multiCurrency`,`isCashTell`,`lang`,`autoAuthorise`,`selfAuthorise`,`userLevel`,`userType`,`sgnAlw`,`grp`,`isHC`,`canOperateVault`) values ('asha','Asha Khanchandani','bc8f5e44ee067f049ac6629fa2a2095d','2001-01-01','N','2001-01-01','412','0004','N','C','en','N','N',9,'NORM','N','officer','N','N');
insert  into `users`(`userId`,`userName`,`passWrd`,`passWrdDt`,`passwordStatus`,`validUpto`,`parentBank`,`parentBranch`,`multiCurrency`,`isCashTell`,`lang`,`autoAuthorise`,`selfAuthorise`,`userLevel`,`userType`,`sgnAlw`,`grp`,`isHC`,`canOperateVault`) values ('deepak','Deepak Khanchandani','','2001-01-01','N','2001-01-01','412','0004','N','N','en','N','N',7,'NORM','N','officer','N','N');
insert  into `users`(`userId`,`userName`,`passWrd`,`passWrdDt`,`passwordStatus`,`validUpto`,`parentBank`,`parentBranch`,`multiCurrency`,`isCashTell`,`lang`,`autoAuthorise`,`selfAuthorise`,`userLevel`,`userType`,`sgnAlw`,`grp`,`isHC`,`canOperateVault`) values ('pmk','Prakash Mohanlal Khanchandani','6cda46ca999052a34a11e6eaa7c6afd6','2001-01-01','N','2001-01-01','412','0004','Y','C','en','N','Y',5,'SDBA','Y','officer','N','Y');
insert  into `users`(`userId`,`userName`,`passWrd`,`passWrdDt`,`passwordStatus`,`validUpto`,`parentBank`,`parentBranch`,`multiCurrency`,`isCashTell`,`lang`,`autoAuthorise`,`selfAuthorise`,`userLevel`,`userType`,`sgnAlw`,`grp`,`isHC`,`canOperateVault`) values ('sram','Sidharam Narote','29b5fcccea0229435953900e8189be2d','2001-01-01','N','2001-01-01','412','0007','N','','en','N','N',7,'NORM','N','officer','N','N');
insert  into `users`(`userId`,`userName`,`passWrd`,`passWrdDt`,`passwordStatus`,`validUpto`,`parentBank`,`parentBranch`,`multiCurrency`,`isCashTell`,`lang`,`autoAuthorise`,`selfAuthorise`,`userLevel`,`userType`,`sgnAlw`,`grp`,`isHC`,`canOperateVault`) values ('vault0004','Vault for branch 0004','','2001-01-01','N','2001-01-01','412','0004','N','V','en','N','N',4,'NORM','N','officer','N','N');
insert  into `users`(`userId`,`userName`,`passWrd`,`passWrdDt`,`passwordStatus`,`validUpto`,`parentBank`,`parentBranch`,`multiCurrency`,`isCashTell`,`lang`,`autoAuthorise`,`selfAuthorise`,`userLevel`,`userType`,`sgnAlw`,`grp`,`isHC`,`canOperateVault`) values ('vishal','Vishal Bhagchandani','','2001-01-01','N','2001-01-01','412','0004','N','C','en','N','N',9,'NORM','N','officer','N','N');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
Advertise on this site
For more information send a message to info at phpclasses dot org.
File: testData.sql

Contents
