INDEX OF MASTERS

SL. No

of Sheet Name Remark

1 Major Head not to be filled

2 Minor Head not to be filled

3 Detailed Head to be filled by ULB

4 Bank Master to be filled by ULB

5 Cheque Book Stock Control to be filled by ULB

6 Project Detail Master to be filled by ULB

7 Party Master to be filled by ULB

8 File Master to be filled by ULB

9 Department Master to be filled by ULB

10 Zone Master not to be filled

11 Ward Master not to be filled

12 Primary Cost Centre to be filled by ULB

13 Secondary Cost Centre to be filled by ULB

14 Primary Budget Centre to be filled by ULB

15 Secondary Budget Centre to be filled by ULB

For Any query, please contact :-------------------

Mr Sandeep Pandey- 9454744076

after filling the form please sent it back by email to

sandeep.pandey@cmcltd.comrahul.khera@cmcltd.com

mfopiuidssmt@gmail.com

Master name

Description

M M

NUMBER NUMBER(*,3) VARCHAR2(50 CHAR) VARCHAR2(200)

1 130 Rental Income from Municipal Properties

1 110 TAX REVENUE

1 140 Fees and User Charges

1 190 Other Income

1 180 Interest Earned

1 170 Income from investments

1 160 Revenue Grants Contribution and Subsidies

1 150 Sale Charges

1 120 Assigned Revenues

2 220 Administrative Expenses

2 210 Establishment Expenses

2 240 Interest Charge

2 272 Depreciation

2 280 Prior Period Item

2 270 Provisions and Write off

2 260 Revenue Grants Contribution

2 250 Programme Expenses

2 230 Operation

2 271 Miscellaneous Expenses

3 312 Reserve

3 360 Provisions

3 331 Unsecured Loans

3 330 Secured Loans

3 311 Earmarked Funds

3 310 Municipal General Fund

3 350 Other Liabilities

3 341 Deposit Works

3 340 Deposits Received EMD Security Deposit

3 320 Grants Contribution for specific purposes

4 450 Cash and Bank Balance

4 411 Accumulated Depreciation

4 410 Fixed Assets

4 420 Investment General Fund

4 412 Capital work In Progress

4 431 Sundry Debtors Receivables

4 480 Miscellaneous Expenditure to be Written Off

4 460 Loans Advances and Deposits

4 440 Pre Paid Expenses

4 432 Accumulated Provission against Debtors Receivables

4 430 Stock in hand

4 470 Other Assets

Major Head

Defining the Master data set up for Major Head

Account

Type (1 MAJOR HEAD CODE MAJOR HEAD NAME REMARKS

Major Head

Defining the Master data set up for Major Head

Master

name

Descripti

on

M M M

NUMBER(*,3)NUMBER(*,2) CHAR(50 CHAR) CHAR(200 CHAR)

110 1 PROPERTY TAX

110 2 Water Tax

110 3 Sewerage Tax

110 4 Conservancy Tax

110 5 Lighting Tax

110 6 Education Tax

110 7 Vehicle Tax

110 8 Tax on Animals

110 9 Electricity Tax

110 10 Professional Tax

110 11 ADVERTISEMENT TAX

110 12 Pilgrimage Tax

110 51 Octroi

110 52 Cess

110 80 Other Taxes

110 90 Tax Remission

130 10 Rent from Civic Amenities

130 20 Rent from Office Buildings

130 30 Rent from Guest Houses

130 40 Rent from lease of lands

130 80 Other Rents

130 90 Rent remission and refund

140 11 Licensing Fees

140 12 Fees For grant of Permit

140 13 Fees for Certificate or Extract

140 14 Developement Charges

140 15 Regulaiton Fees

140 20 Penalties and Fines

140 40 Other Fees

140 50 User Charges

140 60 Entry Fees

140 70 Service admininstrative charge

140 80 Other Charges

140 90 Fees Remission and Refund

150 10 Sale Of Product

150 11 Sale of Forms

150 12 Sale of stores

150 30 Sale of others

150 40 Hire Charges For Vehicles

150 41 Hire Charges On Equipment

160 10 Revenue Grant

160 20 Re imbursement of expenses

160 30 Contribution towards schemes

170 10 Interest

170 20 Dividend

170 30 Income From Projects taken up on Commercial basis

Minor Head

Defining the Master data set up for Minor Head

MAJOR

HEAD

CODE MINOR HEAD CODEMINOR HEAD NAME REMARKS

170 40 Profit In Sale of Investment

170 80 Others

180 10 Interest from Bank Accounts

180 30 Interest on loans to others

180 80 Other Interest

190 10 Deposit forfeited

190 11 Lapsed Deposit

190 20 Insurance Claim Recovery

190 40 Recovery from Employees

190 60 Excess provisions written back

190 80 Miscellaneous Income

210 10 Salaries Wages and Bonus

210 20 Benefits and Allowances

210 30 Pensions

210 40 Other Terminal Benifits

220 10 Rent Rates and Taxes

220 11 Office maintainence

220 12 Communication Expenses

220 20 Books

220 21 Printing and Stationary

220 30 Travelling

220 40 Insurance

220 50 Audit Fees

220 51 Legal Expenses

220 52 Professional Fee

220 60 Advertisement

220 61 Membership

230 10 Power

230 20 Bulk Purchages

230 30 Consumption of Stores

230 40 Hire Charges

230 50 Repair and Maintenance

230 51 Repair

230 52 Repair

230 53 Repair

230 59 Repair

230 80 Other Operating

240 70 Bank Charges

240 80 Other Financial Expenses

250 10 Election Expenses

250 20 Own Programme Mela

250 30 Share in Programme Of Others

260 10 Grants

260 20 contribution

260 30 Subsidies

270 20 Provisions of Other Assets

270 30 Revenues Wriiten Off

270 40 Assets wriiten offf

271 10 Loss on disposal of Assets

271 20 Loss on disposal of investment

271 30 Decline in Value of Investment

272 20 Building

272 23 Roads

272 31 Sewerage and Draiage

272 32 WaterWays

272 33 Public Lighting

272 40 Plant

272 50 Vehicles

272 60 Office Equipments

272 80 Other Fixed Assets

280 50 Refund Of Taxes

310 10 Municipal Fund

310 20 Water Works Fund

311 10 Special Fund

311 13 Special Fund Finance Comission

311 14 Infrastructure Fund

311 15 Special Fund MP MLA Fund

311 16 Special Fund Community Participation Fund

311 17 National Highway Fund

311 18 Special Fund URIF Fund

311 52 Sinking Fund

311 70 Trust or Agency Fund

320 10 Central Government

320 20 State Government

320 30 Other Government agencies

320 40 Financial Institutions

320 50 Welfare Bodies

320 60 Inter UP Organisations

330 10 Loans From Central Government

330 20 Loans From State Government

330 40 Loans fron Inter UP Agencies

330 60 Other Term Loans

330 70 Bonds

330 80 Other Loans

340 10 From Contractors Supliers

340 20 Deposits Revenue

340 30 From Staff

340 80 From Other

341 10 Civial works

341 20 Electrical Works

350 10 Creditors

350 11 Employee liabilities

350 12 Interest Accurd and due

350 20 Recoveries Payables

350 40 Refund payable

350 41 Advance Collection of Revenues

350 80 Other

350 90 Sale Proceeds

360 20 Provision for Interest

360 30 Provision for Other Assets

410 10 Land

410 20 Buildings

410 30 Roads

410 31 Sewerage and Drainage

410 32 water ways

410 40 Plant

410 50 Vehicle

410 60 Office Equipments

410 90 Assets under Disposal

411 30 Roads

411 31 Sewarage and Drainage

411 40 Plant

411 60 Office Equipments

412 10 Special Grants

412 20 Special Funds

420 10 Central Government Securities

420 20 State Government Securities

420 30 Debenture and Bonds

420 40 Preference Shares

420 50 Equity Shares

420 60 Units Of Mutual Funds

420 80 Other Investments

420 90 Accumulated Provision

430 10 Stores

430 20 Loose Tools

431 10 Receivable for Property Taxes

431 19 Receivable for Other Taxes

431 40 Receivables from other sources

431 50 Receivables from Government

431 80 Receivable Control Accounts

440 10 Establishment

440 20 Adminstration

440 30 Operations

450 10 Cash

450 21 Balance With Bank Municipal Fund

450 63 Balance With Banks Grant Funds

450 64 Balance With Banks Grat Funds

460 10 Loans and Advances to employees

460 20 Employee Provident Fund Loans

460 30 Loans to Other

460 50 Advance to Others

460 60 Deposits with External agencie

460 80 Other Current Assets

470 10 Deposit Works

470 20 Inter Unit Account

470 30 Interest Control Payable

480 10 Loan Issue Expenses

480 20 Discount on Issue of loans

GL Code

DETAILS

SHORT

NAME

OPENIN

G

BALAN

CE Dr or Cr

M M M M

VARCHAR2(50 CHAR) NUMBER NUMBER VARCHAR2(15)NUMBER(13,2)VARCHAR2(2 CHAR)CHAR(1)

residential property

tax 1100101 1 110 110-01-01 100000 Dr Y

commercial property

tax 1100102 1 110 110-01-02 123456 Dr Y

land property tax 1100103 1 110 110-01-03 2.3E+07 Dr Y

service charges

property tax 1100104 1 110 110-01-04 123213 Dr Y

property tax 1100105 1 110 110-01-05 100000 Dr Y

land hoarding 1101101 11 110 110-11-01 123456 Dr Y

bus 1101102 11 110 110-11-02 2.3E+07 Dr Y

shelters 1101103 11 110 110-11-03 123213 Dr Y

traffic signals 1101104 11 110 110-11-04 100000 Dr Y

advertisement tax 1101105 11 110 110-11-05 123456 Dr Y

Markets 1301001 10 130 130-10-01 2.3E+07 Dr Y

Shopping Complexes 1301002 10 130 130-10-02 123213 Dr Y

Auditorium 1301003 10 130 130-10-03 100000 Dr Y

Art Galleries 1301004 10 130 130-10-04 123456 Dr Y

Marriage Community

Halls 1301005 10 130 130-10-05 2.3E+07 Dr Y

Playgrounds 1301006 10 130 130-10-06 123213 Dr Y

Nurseries 1301007 10 130 130-10-07 100000 Dr Y

other infrastructure

assets 2305009 50 230 230-50-09 123213 Cr Y

temple 2305010 50 230 230-50-10 122312 Dr Y

cemetry 2305011 50 230 230-50-11 0 Dr Y

Parks 2305101 51 230 230-51-01 123232 Dr Y

Gardens 2305102 51 230 230-51-02 123123 Dr Y

TDS CONTRACTOR 3502009 20 350 350-20-09 2.3E+07 Cr N

Property Tax 3504001 40 350 350-40-01 123213 Cr N

Water Supply 3504002 40 350 350-40-02 122312 Cr N

Licence Fees 3504003 40 350 350-40-03 0 Cr N

RENT 3504004 40 350 350-40-04 123232 Cr N

Advertisement

Charge 3504005 40 350 350-40-05 123123 Cr N

Compensation

Payable 3504101 41 350 350-41-01 123123 Cr N

Stale cheque 3504102 41 350 350-41-02 12 Cr N

HP Payable 3504103 41 350 350-41-03 0 Cr N

Details Head

Defining the Master data set up for Details Head

DETAILS HEAD

NAME

MINOR

HEAD CODE

(refer to

Minor

Head.xls)

MAJOR

HEAD

CODE

(Refer to

Major

COST

CENTER

APPLICA

BLE Y/N

(for

Master name

Description

Banks

short

name BANK NAME

ACCOUNT

DESCRIPTION

M M M M M

CHAR(8

CHAR) CHAR2(50) CHAR2(50) CHAR2(100)

CHA

R2(1

6) NUMBER

AB

Allahabad

Bank Main Branch Main Branch 18490200010001 NIDHI

AB

Allahabad

Bank Gomti Nagar

Gomti

Nagar 11121211212121

SALARY

ACCOUNT

SBI

State Bank

Of India Main Branch Main Branch 355010200004107

PNB

Punjab

National

Bank Gomti Nagar

Gomti

Nagar 355010100083049

IB Indian Bank Ashok Marg Ashok Marg

BOB

Bank of

Baroda Narhi Narhi

UCO UCO Bank Aaishbagh Aaishbagh

UCO UCO Bank Aliganj Aliganj

SB

Syndicate

Bank Gomti Nagar

Gomti

Nagar

CB

Central

Bank

Chandan

Nagar

Chandan

Nagar

Branch Master

Defining the Master data

BRANCH

NAME ADDRESS1

BAN

K

IFSC

COD

E

BANK ACCOUNT

NUMBER

BANK

OPENING

BALANCE

AMOUNT

OPENING

DATE

M M M M M

NUMBER(13,

2)

DATE (DD-

MM-YYYY)

CHAR(2

)

NUMB

ER

NUMB

ER NUMBER

20000.00 23-03-2013 DR 1 21 450

30000.00 23-03-2013 CR 1 21 450

50000.00 23-03-2013 CR 2 21 450

21 450

21 450

21 450

21 450

21 450

21 450

22 450

MAJOR

HEAD(Refer

to Major Head

Template)

TO be Filled by Account Department

Dr or Cr

DETAI

L

HEAD

CODE

(Refer

MINOR

HEAD

(Refer

to Minor

Head

Master name

Description

BANK NAME Branch Name

Starting

Chequ

no

Ending

Cheque

No

M M M M M M M

VARCHAR2(50) Number (20) NUMBER (3)NUMBER (3)NUMBER VARCHAR2(20)

Allahabad Bank HazratGanj Branch 18490200010001 10 1 1 549281 549290

Allahabad Bank Gomti Nagar Branch 18490200010001 20 1 1 549121 549140

State Bank Of India HazratGanj Branch 355010200004107 10 1 1 549301 549310

Punjab National Bank Aliganj 355010100083049 50 2 1 549321 549370

Punjab National Bank Lalbagh 355010100083049 100 2 2 549341 549440

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

CHEQUE BOOK STOCK CONTROL

Defining the Master data set up for Cheque Book Stock Control

Account No

No of

Leav

es

No of

Chequ

e Book Sequence No

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

-1

VARCHAR2(20)

PROJECT

CODE

PROJECT

NAME

PROJECT

DESCRIPTION

PROJECT

START

DATE

PROJECT

LOCATIO

N

ESTIMATE

COST

PROJECTC

OST

(SANCTION

COST)

ACTUAL

COST

M M M M M M M

CHAR(50

CHAR)

VARCHA

R2(100)

VARCHAR2(100

CHAR)

DATE VARCHAR

2(50 )

NUMBER NUMBER NUMBER

4/R&D/Engg Road and

Drains

Road improvement

from Hanuman

mandir to church.

Ward-23

23-03-

2013

Rameshwa

r ward 23

zone-1

100,000.00 100,000.00 100,000.00

Master name

Description

M

VARCHAR2(50

CHAR) VARCHAR2(50 ) VARCHAR2(15)

M/s Saksham

Construction Sh.Manoj Srivastava 9453565445

Suleiman Suleiman 9415788140

M/s Gangotri

Constructions Narendra Tiwari 9415026162

Maheshwari Enterprises

Avinash Mani

Tripathi 9453602371

Shivshakti Constructions Shambhu Yadav 9415832229

Himanshu Constructions Saroj Mishra 9415579363

Friend Traders Bharat Lal Sharma 9335927301

Vijay Associates Yogesh Nandan 9415027412

Manish Kumar Gupta

Manish Kumar

Gupta 9415425700

M/s Vaishno Traders Kailash Nath Mishra 9335215172

Party Master

Defining the Master data set up for Party Master

Party Name/Agency

CONTACT

PERSON

PARTY CONTACT

NO

PAN NO BANKSI

D (Refer

to

Bank.xls)

BRANCHNAME BANK

ACCOUNT NO

M M M M M

VARCHAR2(100 )

VARCHAR2(10 ) NUMBE

R

VARCHAR2(20) VARCHAR2(20)

UGF-027 Adhaarshila Complex Kursi

Road Aliganj Lucknow

AROPS2582G 11 D-123, Amausi 4545554666

431/943 Momin Nagar Campbell Road

Lucknow

AJXPS3904P 11 A-123, Aliganj 56756756757

7/62 Vikas Nagar Lucknow

ACOPT5678J 12 B-3411, Lalbagh 6547777777

4/73A Viram Khand Gomtinagar Lucknow

AHWPT7145R 13 C-1212, Hazrat

Ganj

2433243445

3/866 Vastu Khand Gomtinagar Lucknow

AHXPG7134A 14 A-123, Pocket B,

Nishant ganj

4523534535

11/12k Hata Garidha Uday Ganj Lucknow

AHXPG3534A 15 A-1/23, Indira

Nagar

789798688

13B Indrani Nagar Kundri Rakabganj

Lucknow

AHXPG8934A 16 D-3421, Indira

nagar

453543545

2/493 Vinamra Khand Gomtinagar

Lucknow

ACPPN7265B 17 G-123, Badshah

nagar

5565656566

161/77 Taji Khana Masak Ganj Lucknow

AHXPG6234A 17 G-123, Badshah

nagar

66667688999

509/144 Old Hyderabad Lucknow

AKFPM8568C 17 G-123, Badshah

nagar

9976878567

Party Master

Defining the Master data set up for Party Master

ADDRESS 1

IFSC

CODE

MINORH

EAD (Refer to

(4)Minor

head.xls)

MAJORH

EAD (Refer to

(3)Major

Head.xls )

DETAILH

EAD (Refer to

(5)Detail

Head.xls)

OPENIN

G

BALANC

E

DR OR

CR

GL

Account

Code

(Refer to

Detail

Head.xls)

M

VARCHAR2(

20)

NUMBER NUMBER NUMBER NUMBER CHAR(2) VARCHAR2(

9 )

10 350 23 1000 Cr 3501023

10 350 23 200000 Dr 3501023

10 350 23 30000 Cr 3501023

10 350 23 4000000 Cr 3501023

10 350 23 100 Cr 3501023

10 350 23 200 Cr 3501023

10 350 23 300000 Dr 3501023

10 350 23 120000 Cr 3501023

10 350 23 13000 Cr 2501023

10 350 23 1400 Cr 2501023

TO BE FILLED BY ACCOUNT DEPARTMENT

Name of

Party(refer

to

(7)Party.xl

s)

FILE

NUMBER

FILE

DATE

ULB

PERSO

N

NAME

DESIG

NATIO

N

CONTA

CT NO

PROJEC

T CODE

(REFER

TO

Project

master)

Total

Project

Value)

OUTSTAN

DING

BALANCE

OUTSTA

NDING

DATE

M M M M M M

VARCHAR

2(50

CHAR)

VARCHAR

2(50

CHAR)

DATE VARCH

AR2(50)

VARCH

AR2(20

)

VARCH

AR2(15)

VARCHA

R2(50

CHAR)

number NUMBER DATE

ANNA

CONSTRU

CTION

2/R&D/En

gg/Zone1/

23

01/01/2

012

MANDE

EP JHA

SERNI

OR

OFFIC

ER

9.9E+09 2/R&D/En

gg

100,000.00

Master name Department

Description To enter the department master data

DEPARTMENT NAME

M M

Number VARCHAR2(50)

1 Health Department

3 Accounts Deparment

4 Audit Department

5 R R Department

6 Street Light Department

7 Cattle Catching Department

8 Garden department

9 Revenue Department

10 Advertisement Department

11 Rent Department

12 Sampatti Department

Department ID

MaDes

Ser

ial

No

M M M

NUM

BER(

4)

VARCHAR2(50 CHAR) VARCHAR2(100

CHAR)

VARCHAR2(

100 CHAR)

VARCHA

R2(100

CHAR)

Number(6)

1 1 ZONE-1 ZONE-1 110056

2 1 TALPURA TALPURA 110029

3 1 Varunapar Varunapar 110031

4 1 KHULDABAD KHULDABAD 110054

5 1 Mukhyalay Zone Mukhyalay Zone 110026

6 1 City Zone City Zone 110061

7 1 Zone-1 Zone-1 110067

8 1 Zone-1 Zone-1 110018

9 1 Nagar nigam Saharanpur Nagar nigam

Saharanpur

110011

10 1 Zone 1 Zone 1 110020

11 1 sanitari Ward-01 sanitari Ward-01 110045

12 1 Hariparwat Hariparwat 110014

13 1 Kila Kila 110041

14 2 NAGRA NAGRA 110030

15 2 Kankarkheda Zone Kankarkheda Zone 110027

16 2 Kavinagar Zone Kavinagar Zone 110062

17 2 Zone 2 Zone 2 110021

18 2 Zone-2 Zone-2 110019

19 2 sanitari Ward-02 sanitari Ward-02 110046

20 2 MUTTHIGANJ MUTTHIGANJ 110055

21 2 Chatta Chatta 110015

22 2 Nagar Nigam Nagar Nigam 110042

23 2 Zone-2 Zone-2 110068

24 2 ZONE-2 ZONE-2 110057

25 2 Bhelupur Bhelupur 110032

26 3 Tajganj Tajganj 110016

27 3 Zone 3 Zone 3 110022

28 3 KATRA KATRA 110038

29 3 Jagatpur Jagatpur 110043

30 3 Shastrinagar Zone Shastrinagar Zone 110028

31 3 ZONE-3 ZONE-3 110058

32 3 Mohan Nagar Zone Mohan Nagar Zone 110063

33 3 Adampur Adampur 110033

34 3 sanitari Ward-03 sanitari Ward-03 110047

35 3 Zone-3 Zone-3 110069

36 4 sanitari Ward-04 sanitari Ward-04 110048

37 4 Rajendra Nagar Rajendra Nagar 110044

ZONE

ADDRES

S 3

Zone

Pincode

ZONE MASTERDefining the Master data set up for ZONE

ZONE

CODE

ZONE NAME ZONE ADDRESS 1 ZONE

ADDRESS 2

38 4 Zone-4 Zone-4 110070

39 4 Kotwali Kotwali 110034

40 4 Zone 4 Zone 4 110023

41 4 Lohamandi Lohamandi 110017

42 4 ALLAHAPUR ALLAHAPUR 110039

43 4 Vijaynagar Zone Vijaynagar Zone 110064

44 4 ZONE-4 ZONE-4 110059

45 5 sanitari Ward-05 sanitari Ward-05 110049

46 5 NAINI NAINI 110040

47 5 Vasundhra Zone Vasundhra Zone 110065

MaDes

ZONE

CODE(r

efer 10)

zone Ser

ial

No

M M M M

NUMBE

R(4)

NUMB

ER(4)

VARCHAR2(50

CHAR)

VARCHAR2(100

CHAR)

VARCHA

R2(100

CHAR)

VARC

HAR2(

100

CHAR)

Number(6)

1 2 1 Nai Basti Lallapur Nai Basti Lallapur 110111

2 1 1 Hansari gird-1 Hansari gird-1 110145

3 5 1 IBRAHIM PUR WARD IBRAHIM PUR

WARD

110455

4 1 1 Kalka Garhi Jatwara Kalka Garhi

Jatwara

110493

5 6 1 Sahpur tigri Sahpur tigri 110294

6 10 1 test test 110573

7 1 1 Indrapur Indrapur 110207

8 1 1 Ward-1 Ward-1 110256

9 1 1 Hariparwat Hariparwat 110734

10 2 1 ward-1 ward-1 110742

11 1 1 MUNDERA MUNDERA 110776

12 2 1 Jatavpura Jatavpura 110835

13 10 1 test test 110887

14 1 1 WARD-1 WARD-1 110664

15 1 2 Bhagvatpura Bhagvatpura 110065

16 1 2 Hansari gird-II Hansari gird-II 110146

17 5 2 RAJA BIJLI PASI

WARD

RAJA BIJLI PASI

WARD

110456

18 7 2 Lakdi fazalpur Lakdi fazalpur 110308

19 4 2 Old Vijay Nagar Old Vijay Nagar 110551

20 10 2 t t 110574

21 2 2 Vinayka Vinayka 110241

22 10 2 t t 110243

23 1 2 Ward-2 Ward-2 110257

24 2 2 Chatta Chatta 110735

25 1 2 ward-2 ward-2 110743

26 1 2 SULEM SARAI SULEM SARAI 110777

27 2 2 Biharipur Civil Lines Biharipur Civil Lines 110836

28 3 2 WARD-2 WARD-2 110665

29 2 3 Maliyana Maliyana 110112

WARD MASTERDefining the Master data set up for WARD

WARD

CODE

WARD NAME ADDRESS 1

ADDRES

S 2

ADDR

ESS 3

PINCODE

30 1 3 Out Side Shair Gate Out Side Shair

Gate

110147

31 3 3 Pandit nagla Pandit nagla 110269

32 4 3 Bagu Christian Nagar Bagu Christian

Nagar

110552

33 5 3 GOVIND NAGAR

HARIJAN  BASTI

GOVIND NAGAR

HARIJAN  BASTI

110575

34 1 3 Tarna Tarna 110205

35 1 3 Ward-3 Ward-3 110244

36 3 3 Tajganj Tajganj 110739

37 2 3 ward-3 ward-3 110744

38 1 3 KARELI KARELI 110778

39 3 3 Navada Shekhan Navada Shekhan 110857

40 2 3 TILAK NAGAR WARD TILAK NAGAR

WARD

110397

CFLAG =1 for

fund

2 for

function

w

Master name

Description

PCOST

IDENTIFIER

M M M M M

NUMBER(3) NUMBER(3) VARCHAR2(50

CHAR)

VARCHAR2(100 CHAR) NUMBE

R

1 101 General

Administration

General Administration 1

2 201 LOANS LOAN 2

PRIMARY COST CENTER NAME

Defining the Master data set up for Primary Cost

PRIMARY

COST CODE

PRIMARY COST

SHORT NAME

PRIMARY COST CENTER

DESC

CFLAG

Master name SECONDA

RY COST

CENTER

NAME

Description Defining

the Master

data set

up for

Secondary

Cost

Center

PRIMARY COST

CODE Refer to

Primary Cost

Center

Template)

SCOST ID SECONDARY

COST

CENTER

CODE

SECONDARY

COST NAME

SECONDARY COST

CENTER DESC

M M M M

NUMBER(3) Number NUMBER(3) VARCHAR2(5

0 CHAR)

VARCHAR2(100

CHAR)

101 1 1011 Municipal

Corporation

Municipal Corporation

102 2 1021 EDUCATION

LOAN

EDUCATION LOAN

Master nameDescription

PBUDGET

UNIQUE

NO

M M M

NUMBER NUMBER(3) VARCHAR2(50

CHAR)

VARCHAR2(100 CHAR)

1 10 Income Income

2 20 Income Taxes Income Tax WidthHeld

3 30 Exp Home Expenses Home

4 40 Exp Utilities Expenses Utilities

5 50 Exp Food Expenses Food

6 60 Exp Family Obl Expenses Family Obligation

7 70 Exp Health and Medical Expenses Health and Medical

8 80 Exp Transportation Expenses Transportation

9 90 Exp Dr Pay Expenses Debit Payment

10 100 Exp Pets Expenses Pets

PRIMARY BUDGET CENTER NAME

Defining the Master data set up for Primary Budget Center

PRIMARY

BUDGET

CODE

PRIMARY BUDGET

NAME

PRIMARY BUDGET CENTER DESC

Master nameDescription

PRIMARY

BUDGET CODE

(Please refer to

Primary

Budget Center)

SECONDARY

BUDGET

CENTER

CODE

SECONDARY BUDGET

NAME

SECONDARY BUDGET

CENTER DESC

M M M

NUMBER(3) NUMBER(3) VARCHAR2(50 CHAR) VARCHAR2(100 CHAR)

10 101 Wages and Bonus Wages and Bonus

10 102 Interest Income Interest Income

10 103 Invest. Income Investment Income

10 104 Misc Income Miscellaneous Income

20 201 Fedral IT Fedral Income Tax

20 202 S&LIT State and Local Income Tax

20 203 Medicare Tax Medicare Tax

30 301 Mortage or Rent Mortage or Rent

30 302 Property Tax Property Tax

40 401 Electricity Electricity

40 402 Water and Sewer Water and Sewer

40 403 Natural, gas or Oil Natural, gas or Oil

50 501 Staff Welfare Staff Welfare

60 601 Child Support Child Support

70 701 Insurance Insurance (medical,dental,

vision)

70 702 Auto Insurance Auto Insurance

SECONDARY BUDGET CENTER NAME

Defining the Master data set up for Secondary Budget Center