it e handbook new1

52
MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD. 1 INFORMATION TECHNOLOGY PUNE I. T. E-HANDBOOK IInd Edition

Upload: sachin-khandare

Post on 26-Oct-2015

392 views

Category:

Documents


7 download

DESCRIPTION

Handbok

TRANSCRIPT

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

1

INFORMATION TECHNOLOGY PUNE

I. T. E-HANDBOOK

IInd Edition

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

2

INFORMATION TECHNOLOGY PUNE

PREFACE

During the meeting it is observed that billing problem are mainly due to

wrong data feeding to IT. Either Code is not correct or billing data is not in

proper format etc. It is observed that employees are not familiar with data

code.

So it is decided in the meeting with Dy.GM IT and IT staff to circulate

user-friendly handbook among the employees for awareness of new ideas, new

code of IT system.

While going through handbook it is observed that this handbook

is ready reckoner for troubleshooting problem of IT related of data feeding.

Mr. S. P. Nagtilak

Chief Engineer,Pune Zone

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

3

INFORMATION TECHNOLOGY PUNE

“Quality means doing it right when no one is looking.”

Have you ever wondered why, a lot of times, you just can‟t seem to succeed despite the fact that you

know so much about what it takes to succeed? There just seems to be a gap between what you know

and what you actually do. I call this The Gap Between Knowledge and Action. rather I should say, it is

a lack of clarity that keeps us stuck in a certain pattern.

This E-Hand Book is an effort to help Billing Staff in their day to day work and make clear

What information is need to be feed for LT billing .

Knowing is not enough; we must apply. Willing is not enough; we must do.

Hope this Book will be helpful to billing Staff.

DGM (IT) PUNE

& I.T., PUNE Team

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

4

INFORMATION TECHNOLOGY PUNE

INDEX ---------------------------------------------------------------------------------------------------------------------------

Description Page Number

--------------------------------------------------------------------------------------------------------------------------

Input Forms Index 5 - 7

Rev. Category Tariff Code, Duty Code Combination 9

Industrial Category Codes 10

Government Consumers Codes 11

Other Cods Used 12

Power Cut Category Codes 13

Disconnection Tag Codes 13

Meter Status Codes 14

Security Deposit / Deletion Codes 14

Meter Brand Codes 15

Meter Codes 16

Adjustment Type Codes 17

Receipt Types 18

Relation Between Input Forms and Batching 19

Card Code Structure 20-27

Court Case File Structure 28

Electricity Duty Code Master 29-34

Meter Codes And Meter Subtype Master 35

JV Category And Meter Make Code 36-38

L.T. Billing System Reports 39-40

Billing Program 41

Prepaid Metering 42-43

Photo Entry Software 44-45

Ebill and Online Payment 45

eConnection-Online New Connection System 46

FAQ 47-52

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

5

INFORMATION TECHNOLOGY PUNE

L.T. BILLING SYSTEM

INPUT FORMS INDEX :

-----------------------------------------------------------------------------------------------------------------------

FORM DESCRIPTION CARD CODE

-----------------------------------------------------------------------------------------------------------------------

Batch Header (Normal) B01

LT Consumer Master Data Addition-Supply Details (New connection advance) B34,B25

Consumer Master Data Change (Static Data-Changes to B11) B31

Consumer Master Data Change (Name & Address Changes to B12,B13) B32,B33

Consumer Master Data Change (Changes TO B14) B34

LT Consumer Meter Change B19,B25

LT Consumer Meter Data Amendment (Fields other than Meter Identification) B45

LT Consumer Meter Data Amendment (Amendment to Computed Fields) B46

Security Deposit Deletion B17

Consumer Meter Deletion B19

Security Deposit Change B17, B18

Consumer Deletion from Master File B08

Permanent Disconnection Advice B09

Temporary Disconn. Adv.-(2),Reconn.Adv.-(3), UnMtr to Mtr(1), Ag.Load(A) B10

Bill Stub (Reading) B30

Receipts B60

Adjustment Advice-Current Bill B80

Court Case File Structure

-----------------------------------------------------------------------------------------------------------------------

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

6

INFORMATION TECHNOLOGY PUNE

SR.NO. PARTICULARS FORM IMPORTANT CODES.

1. CHANGE OF MRC,ROUTE,ORDER B-31 FILL ONLY REQUIRED FIELDS.

KEEP OTHER FIELDS BLANK,

BUT FILL IN MRC,ROUTE,ORDER

2. CHANGE OF REV,CAT,TARIFF,

DUTY CODE

B-31 FILL ONLY REQUIRED FIELDS----||- -

(REV.CAT,TARIFF AND DUTY)

3. CHANGE OF LOAD

CAPACITOR PENALTY

NO OF LOOMS

B-31 IN FIELD „73‟

1. FOR CONNECTED LOAD PUT-1

FOR SANCTION LOAD PUT – 2

FOR COMM.LOAD PUT – 3

2. FOR CAPACITOR PUT –Y IF YES

& PUT – N IF NO. IN FIELD –74.

3. NOS OF LOOMS IN 48-50 COL.

4. CHANGE IN METER DETAILS B-45 FILL ONLY REQUIRED FIELDS

1. OWNERSHIP OF METER

2. MF , 3. PHASE, 4. DIGITS.

5. CHANGE OF READING & TREND

OF CONSUMPTION

B-46 PLEASE CONFIRM THAT METER

STATUS IS – 0

WHILE CHANGING PREVIOUS

READING

6. TEMPORARY DISCONNECTION B10(2) SUPPLY DATE OF DISCONNECTION

WITH DOC TYPE-2

8. METER REPLACEMENT B19,B25 CONFIRM THE SAME METER NO

ON B-19 AS PER THE EB/57 REPORT

9. NEW SERVICE CONNECTIONS B34,B25 USE NOLY B34 FOR UNMETERED

SUPPLY

10. RECONNECTION OF TD/PD B10(3)

B25.

RECONNECTION CONS. B-10 DOC

TYPE-3 SEPARATE BATCH.

11. ADDITION OF S.D. AND

ADDITIONAL S.D.

B60,

1. USE RECEIPT TYPE- 03 FOR

ADDITION OF S.D. RT- 05 FOR

ADDITIONAL S.D. FILL IN

RUPEES.

12. DISONNECTION INDICATOR B31

Or

B11

CENTRAL GOVT- 1 STATE GOVT –2

LOCAL AUTHORITY-3 PUBLIC

UNDER TAKING-4, CONTINUOUS

PROCESS INDUSTRY-5, PUBLIC

UTILITY-6 RAIL.-8 MILITARY –9.

13. PAYMENT B60 MODE OF PAYMENT CASH-1,

CHEQUE-2, RECEIPT TYPE 01

AGAINST ENERGY BILL,

02 FIRST SERVICE CONNECTION

03 FIRST SECURE DEPOSIT

04RECONNECTION CHAARGES

05 ADDITIONAL SECURITY DEPOSIT

08 MSEB OFFICE BILL

14. FEEDER NO OF DTC FOR ENRGY B-34 COLUMN 49-57 9 CHARECTER (2

ZERO + 4 FEMS SUB DN CODE + 3

DTC CODE)

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

7

INFORMATION TECHNOLOGY PUNE

15. BILL REVISION B-80 USE +/- SYMBOL BEFOR FIGURE

ADJUSTMENT TYPE

01 REVISION OF PREVIOUS

BILL EC,ED,FCA

02 REVISION OF DELAY

PAYMENT

CHRGES.

03 REVISION OF ARREARS OF

INT

TEREST.

05 REVISION OF PAST YEAR

BILL

06 THEFT OF ENERGY 08 MALPRACTICE

17. CHANGE OF NAME AND

ADDRESS

B-32 &

B-33

FILL ALL FIELDS OF DOCUMENTS

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

8

INFORMATION TECHNOLOGY PUNE

PC NO. MR CYCLE PC NO. MR CYCLE

1. 01 02 03 04 05 2. 19,20,21,22,23

3. 06 07 08 09 4. 24,25,26,27

5. 10 11 12 13 14 6. 28,29,30,31,32

7. 15 16 17 18 8. 33,34,35,36

METER CODES A,C,D,E. (B25 Or B45 forms)

A:- Owner ship MSEB meter 0 D:- Meter Type Single phase 1

Consumer meter 1 Three phase 3 wire 3

CT/PT of Board 2 Three phase 4 wire 4

Static meter 6

Static meter CT 7

C:- Number of Digit E:-METERCAPACITY

2.5Amp 1 25 Amp 6

5 Amp 2 40 Amp 7

10 Amp 3 50 Amp 8

20 Amp 5 100 Amp 9

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

9

INFORMATION TECHNOLOGY PUNE

Table showing the required coding.

Consumer Category Rev.Cat

Code

Tariff

Code

Duty

Code Meter ID

Remark

Residential LD-1

11 01 01/51 90 01 for Mumbai & Pune

51 for other area

Commercial LD-2

21 04 06/07 80 06 Corporation area

07 For other area

Cinema LD-2

24 07 20 75

Industrial LTP-G

31 08 11 60

Agriculture

a) Metered LTP-AG

b) Unmetered LTP-HP

61

61

09

09

49

49

70

70

Disconnection tag = 0

Disconnection tag = 7

Water works

a) Urban LTP-PWW

b) Rural LTP-PWW

c) 'C' Class Municipality

d) Grampchyat

71

71

71

71

08

09

09

09

49

49

49

49

60

60

60

60

Disconnection tag = 0 Met

Disconnection tag =7 Unmet

Metered DT = 0 & load HP

Unmet DT = 7 & Ind Cat"C"

Unmet DT = 7 & Ind Cat"C"

Power loom

33 10 10 60 Disconnection tag = 0

Dissconnection tag = 7

Power loom Commercial 23 06 10 60 Load in KW

Poultry Farms

a)Lighting & Heating

b)Motive Power

14

34

11

12

46

46

80

80

Load in KW

Load in KW

Temp.Connection

12 02

** ** ** As applicable

Street light

13 03 49 91 Ind.Cat A,B,C as applicable

LT floor mill 31 08 11 0 Ind Cat “U” Min Ind = 0

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

10

INFORMATION TECHNOLOGY PUNE

Industrial Categories ( B31 Col. 35 )

Ind.

Cat.

RESIDENTIAL

CONSUMERS

COMMERCIAL CONSUMERS INDUSTRIAL

A 1 ROOM + KITCHEN HOTEL / BAR AGR./ CORPORATION

B 2 ROOM + KITCHEN HOTEL / BAR WITH AC COLD STORG /

MUNCIPALTY

C 3 ROOM + KITCHEN DELUX / STAR HOTEL / BAR

50kw

PHARMACUTCAL / C-CLASS

MUN/ GRAMPANCHAYAT

D 4 ROOM + KITCHEN /

BUNGLOW 50kw

DHABA / OPEN GARDEN /

RESORT

CHEMICALS

E CONSUMER WIH AC UNITS HOSPITAL PRIVATE 50kw FERTILIZER

F COMMON CONNECTION

(FLAT SCEME) 50kw

HOSPITAL GOVERNMENT

50kw

CEMENT,CEMTNT TILES,

STONE CRUSHER

G CORPORATION,

MUNICIPALITY, GRAM

PANCHYAT

FABRICATION / WELDING PAPER

H GOVT. QUARTER DRY CLEANING / PRESSING SUGAR, BAKERY, BISCUITS

CONFECTIONARY

I GOVT. OFFICES 50kw SHOP / STORE / SHOW ROOM

J VIP CONSUMERS 50kw SHOP / STORE / SHOW ROOM

WITH A.C.

SYNTHETICS, PLASTICS

K HEAVY CONSUMPTION

CONSUMERS 50kw

BEAUTY PARLOUR / GYM. /

POOL

TEXTILES, POWER LOOM

L BPL CONSUMER ICECREAM PARLOUR COAL, DAL

M OFFICE METALLURGY, SAW MILLS

N OFFICE WITH A.C NON-FEROUS, COMPUTERS,

ELECTRONICS

O DEPARTMENTAL STORE 50kw

P DEPARTMENTAL STORE WITH

A.C. 50kw

IRON & STEEL

Q VIDEO PARLOUR DEFENCE

R Rajeev Gandhi Gramin Vidyut

Yojana (RGGVY) BPL

MUNCIPALITY / GOVT /

CORPORATION CONNECTION

RAILWAY TRACTION

S TEMP SUPPLY

WITH TRF:02

COMMUNITY HALL / MANGAL

KARYALAYA / CLUB

ENGINEERING, WORK

SHOPS

T HEAVY CONSUMPTION

CONSUMER 50kw

ICE FACTORY

U COMMERCIAL COMPLEX 50kw FLOUR MILL

V COMPUTER INSTITUTE / CAFE

W PETROL PUMP

X STD / XEROX / FAX MISCELLANEOUS

Y PAN TEHLA / SMALL SHOPS

Z MULTIPLEX AND SHOPPING

MALL (LOAD >= 20 KW)

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

11

INFORMATION TECHNOLOGY PUNE

Code Govt Category Description Codes for Codes provide in L.T. Billing

Circlulated HT Billing System Fields to be Updated

by System Disconnection District Code

C.E.(Comm.) Indicatior

0 Others 0 0

1 Central Government 1 1

2 Public Sector (Central Government) 46 97

4 Public Sector (State Government) 47 98

5 M.I.D.C. 43 94

6 C.I.D.C.O 44 95

7 M.S.E.B. 45 96

- Local Authority 3 3

- State Government 2 2

- Public Sector 4 4

- Continuous Process 5 5

- Public Utilities 6 6

- Important Consumers 7 7

8 Railway 8 8

9 Military 9 9

10 Zilla Parishad 10 87

11 Jeevan Pradhikaran 11 88

12 Municipal Corporation 12 89

13 A' Class Muncipalities 13 90

14 B' Class Muncipalities 14 91

15 C' Class Muncipalities 15 92

16 Grampanchayat 16 93

17 General Adminstration Deptt. State Govt. 17 A

18 Planning Deptt. State Govt. 18 B

19 Home Deptt. State Govt.. 19 C

20 Co-operation & Textiles Deptt. State Govt. 20 D

21 Revenue & Forest Deptt. State Govt. 21 E

22 School Education Deptt. State Govt. 22 F

23 Urban Development Deptt. State Govt. 23 G

24 Finance Deptt. State Govt. 24 H

25 Law & Judiciary Deptt. State Govt. 25 I

26 Housing Development & Special Assistance Deptt. 26 J

27 Pubilc Works Deptt. State Govt. 27 K

28 Food & Civil Supplies Deptt. State Govt. 28 L

29 Irrigation Deptt. State Govt. 29 M

30 Rural Development & Water Conservation 30 N

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

12

INFORMATION TECHNOLOGY PUNE

Govt. Consumers Codes.

Code Govt. Category Description Codes for Codes provide in L.T. Billing

Circlulated HT Billing System Fields to be Updated

by System Disconnection District Code

C.E.(Comm.) Indicatior

31 Public Health Deptt. State Govt. 31 O

32 Medical Education & Drugs Deptt. State Govt. 32 P

33 Industry, Engery & Labour Deptt. State Govt. 33 Q

34 Social Justice, Cultural Affairs & Sports Deptt. 34 R

35 Tribal Development Deptt. State Govt. 35 S

36 Parliamentary Affairs Deptt. State Govt. 36 T

37 Agriculture,Animal Husbandry, Dairy 37 U

Development & Fisheries Deptt.

38 Higher & Technical Education Deptt. State Govt. 38 V

39 Water Supply & Sanitation Deptt. State Govt. 39 W

40 Environment Deptt. State Govt. 40 X

41 Women & Children Welfare Deptt 41 Y

42 Employment & Self Empolyment Deptt. 42 Z

Note : 1. For HT billing system update Authority Type through consumer profile folder

2. for LT Billing system use B31 form field no 26,27 for District code

and 34 for Disconnection indicator

Other Codes Used.

1. To Change Conn.Load (1) / Sanction Load (2) feed 1 / 2 at Col. 73 in B31.

2. To Charge Capacitor Penalty (N) / Stop Cap. Penalty (Y) feed Y/N at Col. 74 in B31.

Addl. Supply. Charges (ASC) Flag : ( B11/31- Col. 46 ) [ A:-Ag.Dominated Areas, I:-Ind. &

Urbn. Agglomerates, O:-Other Areas, M:- MIDC]

B10 DOC TYPE (23) :1 – UNMTR – METERED, 2 – DISCONNECTION, 3 – RECONNECTION

4 – New CFL Installment, 5 – To Stop CFL Installment, 6 – Restart the CFL Installment,

7 – New Choke Installment, 8 – To Stop Choke Installment, 9 – Restart the Choke Installment.

A – Krushi Swabhiman Yojana Load Extension Part Payment (AME0907)

T – THEFT CASE , C -- COMPOUNDING CASES

B10 COMPANY CODE (24-25) : 01 – OSRAM , 02 – PHILIPS , 03 – ASIAN ELECTRONICS

04 – PHONIX

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

13

INFORMATION TECHNOLOGY PUNE

POWER CUT CATEGORY CODES : (B11/31 Col.No. 36)

-------------------------------------------------------------------------------------------------------------------------

DESCRIPTION CODE

--------------------------------------------------------------------------------------------------------------------------

GENERAL INDUSTRIES A

COTTON TEXTILES B

COMMERCIAL C

ESSENTIAL PART-I D

ESSENTIAL PART-II E

ESSENTIAL PART-III F

ESSENTIAL PART-IV G

SERVICE PART-I H

SERVICE PART-II J

CONTINEOUS PROCESSING K

GOVT./LOCAL AUTHORITY CORPORATION owned/CONTROLED BY GOVT. L

SEASONAL INDUSTRIES M

THEATERS & CINEMAS N

EXEMPTED X

--------------------------------------------------------------------------------------------------------------------------

DISCONNECTION TAG CODES : (B11/31 Col, No. 69)

-------------------------------------------------------------------------------------------

DESCRIPTION CODE

-------------------------------------------------------------------------------------------

Live Consumer 0

Temporary Disconnected Consumer 1

Live Consumer but Billing on HP Basis 7

New Consumer (to be connected) 8

Permanently Disconnected Consumer 9

-------------------------------------------------------------------------------------------

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

14

INFORMATION TECHNOLOGY PUNE

METER STATUS CODES : (B30)

-------------------------------------------------------------------------------------------

DESCRIPTION CODE

-------------------------------------------------------------------------------------------

Normal Meter (Meter reading available) 0

Faulty Meter 1

Locked Meter 2

Meter overflow 3

Meter change 4

Meter inaccessible 5

Reading not available (Generated by system) 6

Meter Missing 7

Reading Not Taken 8

Tampered Meter (Photo Meter Reading AME0907) 9

-------------------------------------------------------------------------------------------

SECURITY DEPOSIT CODES : (B17)

-------------------------------------------------------------------------------------------------

DESCRIPTION CODE

Security Deposit Deletion Code : (B17)

Refund SD for Full amount of Receipt 0

Deletion : if SD Receipt is incorrect 1

Reducing : SD Demand or Arrears 2

-------------------------------------------------------------------------------------------------

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

15

INFORMATION TECHNOLOGY PUNE

METER BRAND CODES : (B25 Col.No.27-28)

Code Description Code Description

02 ECE-EAW 60 ENTITY

03 AEG 61 ELYMER

04 BEM 62 AVENER

06 C AND H 63 ALSTOM

08 DASS – HITACHI 64 ACCURATE

10 ECE 65 GENUS

12 EEC 66 Capital Meters Pvt Ltd

14 CIMC 67 Van Electro Devices Pvt Ltd

15 HAVELLS ELECT 68 GEC ALSTHOM India Ltd

16 INDIA METERS 69 Gilbert Elec.and Elect.Pvt Ltd

18 IMP 70 Kei Electricals Pvt Ltd

20 JAIPUR 71 Moden Instuments Pvt Ltd

22 L AND G 72 Powertec Meters

24 MALIK AND MEW 73 ELSTER

26 M AND I 74 EMCO

28 REMCO 75 ANKAR

30 SIMCO 76 HPL

32 UNILEC 77 ANCHOR

34 UE 78 SHENZEN

35 VOLTAS 79 Semiconductor Complex Ltd

36 AEC COMPANY 80 Lotus Wires and Cables

38 ARON 81 Omni Agate System

40 BUXLESS 82 Palmohan

42 CRE WOOD 83 Synergy

44 CONTIMETS 84 RC Energy metering Pvt. Ltd

46 GANG BUDAPEST 85 Capital power system

48 KRIZIK 86 Motwani Manufacture

50 SIEMENS 87 Modern Instruments pvt Ltd

51 MAXWELL 88 Avon meters

52 SCHLUMBERGER 89 Keltron counters Ltd

53 L AND T 91 Terana Infoteck

54 DATAPRO 92 National Telecom

55 SECURE 93 TTL Ltd

56 DUKE ARNES 94 Towers and Transformers

57 A.B.B. 95 Esprite Switchgear pvt ltd

58 SOCOMAC 96 Bentex electricals

59 LG 97 Bharat Heavy Electrical Ltd

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

16

INFORMATION TECHNOLOGY PUNE

METER CODES : (B25 Col no. 17-18)

------------------------------------------------------------------------------------------

DESCRIPTION CODE

LT Industrial 60

LT Agricultural 70

Cinema (Main Meter) 75

(Lighting Meter) 76

Commercial Light & Fan/L&F & Small Power (combined) 80

Commercial Small Power only 81

Domestic Light & Fan/L&E & Small Power combined 90

Domestic Small Power only. 91

Domestic Water Pump 92

------------------------------------------------------------------------------------------------------

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

17

INFORMATION TECHNOLOGY PUNE

ADJUSTMENT TYPE CODES : (B80)

DESCRIPTION CODE

Past Billing(Current Financial Year) 01

DPC 02

Interest 03

E.C. Shortfall 04

Prior Period Recovery/Receipt(Excl.Curr Fin.Year) 05

Theft of Energy 06

Interest on Security Deposit 07

Recovery from Malpractice 08

Meter Cost 09

Bounce Cheque 11

Adjustment against Supplier bill 12

MSEB Bill Adjustment 13

S.D. Adjustment against arrears 14

PROMPT PAYMENT 15

CPP, whealing banking Adjustment 16

Removal of fictitious arrears 17

Cr Adj for Govt.Subsidy 18

LOAD FACTOR INCENTIVE 19

Tax On Sale of Elect. 20

Reliability Charge 22

ASC ADJUSTMENT 24

RC ADJUSTMENT 25

RGPPL ADJ 27

Credit Card CHARGE Back ADJ 28

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

18

INFORMATION TECHNOLOGY PUNE

RECEIPT TYPE CODE AND MODE OF PAYMENT CODES : (B60)

DESCRIPTION CODE

Receipt against Energy Bill 01

Receipt against First Service Connection Charges 02

Receipt against First Security Deposit 03

Receipt against Reconnection Charges 04

Receipt against Additional Security 05

Receipt against Meter Cost 06

Receipt against V.D.S. 07

Receipt for Reducing the Arrears during initial Reconnection

on adjustment of MSEDCL Office Bills, etc. (Non Operated)) 08

Receipt against Compounding Charges 09

Receipt for Theft Case 10

Receipt for Malpractice 11

Govt. Installment Plans 12

Court Bills 13

Tariff Revision Bills 14

P.D. Advice Bills 15

Receipt for ORC 16

Receipt for Additional SLC 17

Receipt for Cost of Agreement 18

Krushi Swabhiman Yojana/ Misc.Charges (1007) 19

Refundable ORC (ORC-SLC) 20

Interest Receipt 21

New S.C.Supervision Charges 22

Meter Testing Charges 23

CT/PT Testing Charges 24

Processing Fees Shifting Chrg 25

AG KSY Bill Receipt 26

* MODE OF PAYMENT

Cash Receipts 1

Cheque Receipts 2

DD 3

ATOM(Mobile Payment) 4

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

19

INFORMATION TECHNOLOGY PUNE

RELATION BETWEEN INPUT FORM AND BATCHINGS

CARD CODE/S BATCH CONTORL TOTALS

APPLICABLE TYPE 1 2 3 4 5 6

B11,B12, 01 TARIFF M. R. ROUTE LEDGER CONNECTED NIL

B13 CODE CYCLE (B11) CYCLE LOAD

(B11) (B11) (B11) (B11)

B34, B25 14 NIL PC TOTAL INTIAL AVG. MF (B25) AUTHORISED

(B25&B34) READING CONS. UNITS

(B25) (B25)

B17, B18 11 SD AMT NIL NIL NIL NIL NIL

(B18)

B60 06 RECEIPT RECEIPT RECEIPT RECEIPT NIL NIL

AMT. OF AMT. OF AMT. OF AMT. OF

01, 08 2,6,16,17,18 3,5,7 4,9,10,11

TYPE TYPE TYPE TYPE

(B60) (B60) (B60) (B60)

B80 16 TOTAL EC+FCA ELEC. OTHERS ADJ.UNITS NIL

ADJ. AMT. (B80) DUTY (B80) (B80)

(B80) (B80)

B31 02 TARIFF MR CYCLE ROUTE LEDGER CONNECTED NIL

CODE (B31) (B31) (B31) CYCLE LOAD

(B31)

B19, B25 15 READING PC TOTAL INITIAL EST.AVG. M.F. (B25) AUTHORISED

AT DISC (B19 & B25) METER CONSUM- UNITS

(B19) UNIT READING TION (B25)

READING (B25) (B25)

B45 02 NIL NIL NIL AVERAGE M.F INITIAL

CONS. READING

B46 02 PREV. YYMM-1 UNIT-1 NIL NIL NIL

READING YYMM-2 UNIT-2

B,8,9,10,17,19 02 NIL NIL NIL NIL NIL NIL

B32,33,34 02 NIL NIL NIL NIL NIL NIL

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

20

INFORMATION TECHNOLOGY PUNE

I.CARD B08

1.CARD CODE (CC) 1 3 3 AN B08 as pre – printed on form

2 Consumer.No. 4 15 12 N Common with card-code B-11

3.Processing Cycle

(PC)

16 16 1 N Common with card code- B -11

II.CARD B 09

1.Card Code (CC) 1 3 3 AN B09 as pre-printed on form

2.Consumer.No. 4 5 12 N Common with card code B-11

3.Processing Cycle 16 16 1 N Common with card code B11

4.Disc.Date 17 22 6 N Fill in date as DDMMYY

III.CARD – B17

1.Card Code (CC) 1 3 3 AN B17 as pre-printed on the form

2.Consumer No. 4 15 12 N Fill in the number of consumer

whose SD Details are to be

deleted (SD to be reduced)

3.Processing Cycle

(PC)

16 16 1 N Fill in appropriate PC

4.Receipt.No. 17 23 7 N Fill in the S.D. Receipt Number

to be deleted /refunded

5.Receipt.Date 24 29 6 N Fill in the SD Receipt Date

(DDMMYY)

6.Receipt Amount 30 36 7 N Fill in the S.D. Amount of the

receipt to be deleted .The field is

in rupees only.

7.Deletion Date 37 42 6 N Fill in the date of SD Deletion/

refund

8.Deletion Code 43 43 1 N Code purpose remarks 0 = refund

this is of SD for full amount of

receipt.

1 Deletion Code Where the

original SD Receipt is incorrect.

2 Reducing – where the S.D.

earlier arrears demand / arrears is

to be reduced.

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

21

INFORMATION TECHNOLOGY PUNE

IV. Card.B19

1.Card.Code. (CC) 1 3 3 AN B19 as pre-printed on the form

2.Consumer

Number

4 15 12 N Fill in the No.of Consumer

whose matter is to be deleted

3.Processing Cycle

(PC)

16 16 1 N Fill in appropriate PC

4.Meter

Identification

17 26 10 N Fill in the Meter – ID of the

meter to be deleted (which

should be identical with the one

on the master)

5.Reading at

disconnection

27 32 6 N Fill in the meter reading at the

time of meter removal if

available. Otherwise leave blank.

This is to be filled in for

L.T.System only.

6.Estimated

Consumption

(KWH)

33 38 6 N This field is to be filled in only

where there is faulty meter or

where reading at disconnection is

not available or where there is an

overflow in meter reading.

7.Deletion Date 39 44 6 N Fill in the date (ddmmyy) of

meter removal

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

22

INFORMATION TECHNOLOGY PUNE

CARD B25 & B45

1.Card Code (CC) 1 3 3 AN B25 & B45 as pre-printed on

form

2.Consumer .No. 4 15 12 N Common with card code B11

3.Processing 16 16 1 N Common with card code B11

4.Meter

Identification

(Meter-ID)

a..CODE 17 18 2 N Fill in appropriate meter code.

Refer table of meter codes.

b .MFR.No. 19 26 8 N Fill in Meter Manufacturers serial

Number on the meter nameplate

5.Meter Brand 27 28 2 N Fill in the appropriate meter

brand code table of meter brand

codes

6.Meter Codes A 29 29 1 N Fill in 0 if the meter is owned by

the MSEB otherwise “1” if it is

owned by the

consumer.connected with

C.T.Operators Meters and

C.T.Owned by MSEB .”3”

C.T.Owned by MSEB and meter

by consumers.”4” Meter owned

by MSEB & C.T.Owned by

consumer.”5” C.T.and meter

owned by consumer.

C 30 30 1 N Fill in the number of digits of the

meter

D 31 31 1 N Fill in the appropriate meter type

code table of meter type code (a)

E 32 32 1 N Fill in the appropriate code to

indicate amperage. Refer table of

meter type code.

7.Installation code 33 38 6 N Fill in the date of installation of

the meter.

8.Laboratory

Number

39 48 10 AN After testing each meter is

allotted a separate number of

testing units. This number could

be filled in here if available other

wise blank.

9.Testing date 49 54 6 N Fill in date on which the meter

last tested available during

master data feeding in standard

date of master data compilation.

10.Multyplying

Factor

55 56 2 N Fill in the M.F. of a meter if

applicable otherwise leave this

field as blank. For 3 phase meter

it should be invariably given if it

is not there then fill “01”

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

23

INFORMATION TECHNOLOGY PUNE

11.Authorised Units 57 62 6 N Fill in authorized units allowed to

the consumer if the power cut is

applicable. Otherwise leave

blank. For industrial consumers

(tariff code-08) this field should

invariably be filled in.

12.Estimated

Average

Consumption

69 74 6 N Fill in Monthly Estimated

average consumption. For

existing consumers this could be

filled in based on average

consumption for previous three

months and for new consumers

this could be estimated and given

based on his connected load. If

not available this may be left

blank.

Card.B30

1.Card.Code (CC) 1 3 3 AN B30 as pre-printed

2.Consumer.no. 4 15 13 N As pre-printed on the reading.

3.ProcessingCycle

(PC)

16 16 1 N Computer

4.Meter Status 1

MS1

17 17 1 N If Normal leave blank otherwise

meter status .see note below.

5.Current Reading 1 18 23 6 N If MS is 2/4/5/7/8 leave this

blank the current reading of the

first meter no. is printed by the

computer.

6.Meter status 2

(MS2)

24 24 1 N If second meter is available fill in

appropriate column. If normal

leave blank see note below.

7. Current Reading

2

25 30 6 N If second meter is available and

MS is not available 2/4/5/7/8 fill

the current reading of second

meter.

Note: If the meter status of the first meter is 2/4/5/7/8 indicate the same meter status for the

second meter if available and vice versa.

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

24

INFORMATION TECHNOLOGY PUNE

Card.B46

1.Card Code (CC) 1 3 3 AN B46 as pre-printed on the form

2.Consumer No. 4 15 12 N Fill in the number of consumer

whose details are to be filled.

3.Processing Cycle. 16 16 1 N Fill in the appropriate PC

4.Meter

Identification

17 26 10 N Fill in the meter identification

number as per master.

5.Faulty since date 27 30 4 N Fill in the faulty since date as

year and month (yymm)

6. Locked since date 31 34 4 N Fill in locked since date as year

and month (yymm)

7.Previous Reading 35 40 6 N Fill in the previous reading.

8.Previous reading 47 50 4 N Fill in previous reading date as

year and month (yymm) It should

not be greater than one year from

current month.

9.Consumption date 55 58 4 N Fill in the date (yymm) and

consumption details of first

month

10.Consumption 59 64 6 N Fill in the date (yymm) and

consumption details of first

month

11.Consumption

Date

65 68 4 N Fill in the date (yymm) and

consumption details of second

month

12.Consumption 69 74 6 N Fill in the date (yymm) and

consumption details of second

month.

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

25

INFORMATION TECHNOLOGY PUNE

CARD.B80

1.Card.Code.(CC) 1 3 3 AN B80 as pre-printed on the form

2.Consumer .No. 4 15 12 N Fill in the consumer Number

3.Processing Cycle 16 16 1 N Fill in the appropriate processing

cycle.

4.Adjustment Type 17 18 2 N Fill in appropriate adjustment

type. Refer table of adjustment

type codes.

5.Adjustement

Amount

19 28 10 N Fill in the total adjustment

amount in paise (debit or credit)

6.Total Energy 29 36 8 N Fill in the total of energy charges

in paise

7.Electrical Duty 37 44 8 N Fill in the electricity duty amount

in paise. If not present leave

blank. If this and the preceding

field are present then the

adjustment type should be “01”

8.Other charges 45 52 8 N Fill in any other sundry charges

in paise. If not present leave

blank.

9.Adjustement Units 53 60 8 N At present adjustment in units is

not taken into the system , as it is

available in the manual register.

However this should be filled in.

10.Document

Number

61 67 7 N Fill in the document number.

This should be a running serial

number.

Theft cases :( Financial documents to feed to billing system)

Theft assessment to be debited to consumer (DR. B80 ADJ TYPE=‟06‟)

Receipt against Theft (B60 RCPT TYPE=‟10‟)

Compounding cases ::( Financial documents to feed to billing system)

ONLY Compounding receipt. (B60 RCPT TYPE=‟09‟)

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

26

INFORMATION TECHNOLOGY PUNE

„B10‟ DOCUMENT FOR FEEDING THEFT/COMPOUNDING DETAILS

DESCRIPTION COLUMN

NO.

VALUE REMARK

CARD CODE 1-3 B10 CONSTANT

CONSUMER NO. 4-15 NUMERIC

PC 16 1 TO 8

DATE OF

CHECKING

17-22 DDMMYY

THEFT CODE 23 T FOR THEFT

C FOR COMPOUNDING

CONSTANT

THEFT

ASSESSMENT

AMOUNT

24-33 AMOUNT TO BE FILLED IN

RS/PAISE

Eg 0000500000

for Rs. 5000.00

NUMERIC

COMPOUNDING

AMOUNT

34-43 AMOUNT TO BE FILLED IN

RS/PAISE

Eg 0000500000

for Rs. 5000.00

NUMERIC

OTHER AMOUNT

eg METER COST

ETC (IF ANY)

44-53 AMOUNT TO BE FILLED IN

RS/PAISE

Eg 0000090000

for Rs. 900.00

NUMERIC

FIR NUMBER 54-74 ALPHA-NUMERIC

FILLER 44-74 BLANK SPACES

BATCH NO. 75-80 NUMERIC

Note : 1) Batch Type should be „02‟ in Batch Header B01(73-74 position). Batch

Header same as for regular B10 documents

2) IF THEFT CODE = „T‟, THEFT ASSESSMENT AMOUNT AND FIR NO.

CAN NOT BE BLANK

3) DATE OF CHECKING CAN NOT BE BLANK AND MUST HAVE VALID

DATE.

Checking of excessive Load : Excessive load value are fed for Residential/Commercial

consumers. The limit for Residential consumer is 50KW and for commercial consumer it is

80KW. The load above these values will be permissible only in following cases.

Tariff Industrial Category Description

01 D 4 Room + Kitchen

F Common connection(Flat

Scheme)

I Govt. Offices

J VIP Consumers

K Heavy consumption consumers

04 C Delux/Star Hotel

E Private Hospital

F Govt. Hospital

O Dept. Store

P Dept Store with A.C.

T Heavy consumption consumer

U Commercial complex

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

27

INFORMATION TECHNOLOGY PUNE

If the program terminates, pl. check the consumer data and feed appropriate Ind. Category(B31)

document or correct the load and reprocess.

B19 /B25

B19/B25 document for meter deletion and replacement-

To capture The reson behind this user need to feed the Meter Deletion reason in B19 document. The

position of Meter deletion reason code in B19 document is from column position 45-46. The reason

code is given in the table-

Meter Deletion Reason Codes

Reason Code Description

01 Meter Burnt

02 Consumer request

03 'Meter Tampered'

04 'Meter Faulty'

05 'Meter Replacement Drive'

06 'Meter Slow'

07 'Meter Fast'

08 'Meter Display Failed'

09 'Theft'

10 'Meter Testing'

11 'Meter Doubtful'

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

28

INFORMATION TECHNOLOGY PUNE

Input Court Case Information File Strucure

Column Position Description Remark

*1-2 „CC‟ 2 char Value CC to identify Court Case.

*3-6 Billing Unit (BU) 4 char

*7-7 PC 1 char

*8-19 Consumer Number 12 char

*20-269 Case reference 250 char, Mandatory and Unique.

*270-280 Case Start Date [DD-MON-YYYY] 11 char Mandatory

*281-292 Disputed Bill Amount 12 char Amount in Paise

293-304 Disputed Interest Amount 12 char Amount in Paise.

305-354 Court Name 50 char

355-355 CASE STATUS FLAG 1 char (O-OPEN ,C-CLOSED)

356-357 No. of Installments if any default(0) 2 char

358-367 CASE NUMBER 10 char MANDATORY and UNIQUE

* Mandatory fields in the input text file.

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

29

INFORMATION TECHNOLOGY PUNE

ELECTRICITY DUTY CODE MASTER

DESCRIPTION DUTY_CODE

------------------------------------------------------------ ------

PREMISES FOR RESIDENTIAL PURPOSE 01

MEDICAL AND EDUCATIONAL: PRIVATE 02

NOT UNDER SCHEDULE ELEC. ACT 1958 03

LIFTING WATER FOR DOMESTIC USE 04

COMMERCIAL: IN CORPORATION AREA 06

COMMERCIAL: IN OTHER AREAS 07

No name 08

INDUSTRIAL: PURCHASING AW MATERIAL & MANUFACTURING ARTICLES 10

INDUSTRIAL UNDERTAKING IN ANNEX. A, ELEC. ACT 1958 11

INDUSTRIAL UNDERTAKING IN ANNEX. B, ELEC. ACT 1958 12

ANNEX. C, ELEC. ACT 1958 13

COLD STORAGE FOR AGRICULTURAL & FOOD PRODUCTS 14

WORKSHOP OF STATE ROAD TRANSPORT 15

COTTON GINNING & PRESSING 16

PRINTING PRESS 17

VIDARBHA DUTY CHANGE 18

CINEMA & THEATRE A.C. 20

ADVERTISMENT OR DISPLAY IN PUBLIC PLACES 21

INDUSTRIAL LT: PRODUCTION DEMAND 10%-25% 30

INDUSTRIAL HT: PRODUCTION DEMAND 10%-25% 31

INDUSTRIAL HT: CONCESSIONAL RATE 32

INDUSTRIAL LT: CONCESSIONAL RATE 33

STUDIO LIGHTING 40

AGRICULTURAL 45

POULTRY & HATCHERY 46

DUTY EXEMPT 49

PREMISES FOR RESIDENTIAL PURPOSE 51

MEDICAL AND EDUCATIONAL: PRIVATE 52

NOT UNDER SCHEDULE ELEC. ACT 1958 53

LIFTING WATER FOR DOMESTIC USE 54

COMMERCIAL: LIGHT & FAN IN GREATER BOMBAY ONLY 55

COMMERCIAL: IN GREATER BOMBAY ONLY 56

INDUSTRIAL JOB WORK: LIGHT & FAN IN GREATER BOMBAY 57

INDUSTRIAL JOB WORK: IN GREATER BOMBAY 58

INDUSTRIAL: PURCHASING AW MATERIAL & MANUFACTURING ARTICLES 60

INDUSTRIAL UNDERTAKING IN ANNEX. A, ELEC. ACT 1958 61

INDUSTRIAL UNDERTAKING IN ANNEX. B, ELEC. ACT 1958 62

ANNEX. C, ELEC. ACT 1958 63

COLD STORAGE FOR AGRICULTURAL & FOOD PRODUCTS 64

WORKSHOP OF STATE ROAD TRANSPORT 65

COTTON GINNING & PRESSING 66

PRINTING PRESS 67

CINEMA & THEATRE A.C. 70

ADVERTISMENT OR DISPLAY IN PUBLIC PLACES 71

INDUSTRIAL LT: PRODUCTION DEMAND 10%-25% 80

INDUSTRIAL HT: PRODUCTION DEMAND 10%-25% 81

INDUSTRIAL HT: CONCESSIONAL RATE 82

INDUSTRIAL LT: CONCESSIONAL RATE 83

STUDIO LIGHTING 90

AGRICULTURAL 95

POULTRY & HATCHERY 96

DUTY EXEMPT VIDHARBHA 97

DUTY EXEMPT MARATHWADA 98

DUTY EXEMPTED 99

--------------------------------------------------------------------

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

30

INFORMATION TECHNOLOGY PUNE

INDUSTRY CODE DESCRIPTION INDU

-------------------------------------------------- ----

Temp religious 0006

AGRICULTURE 0015

VEGETABLES & MELON 0016

FRUITS & TREE NUTS 0017

HORTICULTURE SPL. 0018

GEN FARMS PRIM CROP 0019

CROP SERVICES 0072

LNDSP & HORTCL SRVCE 0078

FOREST PRODUCTS 0083

IRON ORES 0101

MISC. METAL ORE 0109

NATURAL GAS LIQUIDS 0132

OIL & GAS FIELD SERV 0138

CRSHED & BROKN STON 0142

CL CERMX & REFTR MNR 0145

MISC. Non_metal MNRL 0149

NON RES. BLDG CONST 0154

HIWAY & STREET CONST 0161

HEVY CONST EXPT HWAY 0162

WATER WELL DRILLING 0178

MEAT PRODUCTS 0201

DAIRY PRODUCTS 0202

PRESRVED FRUIT & VEG 0203

GRAIN MILL PRODUCTS 0204

BAKERY PRODUCTS 0205

SUGAR REFINING 0206

FATS AND OILS 0207

BEVERAGES 0208

MISC. FD & KDRD PROD 0209

CIGARETTES 0211

WEAVING MILLS-COTTON 0221

POWER LOOM 0222

WEVG & FNHG MIL WOOL 0223

POWER LOOM COMM 0224

KNITTING MILLS 0225

TEXT FINHG EXPT WOOL 0226

YARN & THREAD MILLS 0228

MISC. TEXTL GOODS 0229

MN'S BOY'S SUITCOAT 0231

MEN'S & BOY'S FURNHG 0232

WMEN & MISS OUTWEARE 0233

MSC. APL & ACESRIES 0238

MISC. FAB TXT PRO 0239

MILW PLYW & STRL MBR 0243

HOUSEHOLD FURNITURE 0251

OFFICE FURNITURE 0252

PUB BLDG &RLTD FURTR 0253

PARTITIONS & FIXTURE 0254

MSC. FUR & FIXTURES 0259

NEWSPAPERS 0271

MISC. PUBLISHING 0274

MANIF'D BUSINES FORM 0276

IND INORGNC CHEMICAL 0281

PLSTC MTRL & SYNTHEC 0282

DRUGS 0283

SOAP CLNR & TOLT G'D 0284

PAINTS & ALLIED PROD 0285

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

31

INFORMATION TECHNOLOGY PUNE

DESCRIPTION INDU

IND ORGNC CHEMICALS 0286

AGRCTRL CHEML FERTIL 0287

MISC. CHEMCL PRODT 0289

HS BLT GSKT & PCKNG 0305

FBRC RUB PROD NEC 0306

MISC. PLST PROD NEC 0307

LEATHER TANNG & FNHG 0311

FOOTWEAR CUT STOCK 0313

FOOTWEAR EXPT RUBER 0314

LUGGAGE 0316

HDBG & PER LTH GOODS 0317

LEATHER GOODS NEC 0319

GLS & GLSWRE PRSD BL 0322

CEMENT HYDRLC PRODTS 0324

STRUCTRL CLAY PRODTS 0325

POTTERY & RELTD PROD 0326

CNT GYSM & PLSTR PRO 0327

CUT ST & STONE PRODT 0328

MSC. NONMTLC MNR PR 0329

Blast Furnace steel 0331

IRON & STEEL FOUNDRS 0332

PRMRY NONFERS METALS 0333

SECDRY NONFERS METL 0334

NONFERS FOUDRS CSTNG 0336

MTL CAN SHIP CONTNRS 0341

CTLY H'D TLS & HRDWR 0342

FABR STRL MTL PRODTS 0344

SCRW MCH PR BOLT ETC 0345

MTL FRGNG & STMPNG 0346

ORDNC & ACCESERS NEC 0348

MISC. FABCTD MTL PRO 0349

FARM & GARDEN MCHNRY 0352

CNSTN & RLTD MCHNRY 0353

METLWORKNG MACHINERY 0354

SPECIAL IND MCHNERY 0355

GENERAL IND MCHNERY 0356

COMPTR & OFF EQUPMNT 0357

REFGTR & SER MCHNR 0358

IND MACHINERY NEC 0359

ELE DISTRBTN EQPMENT 0361

ELECT IND APPARATUS 0362

HOUSEHOLD APPLIANCES 0363

ELCT LTG & WRNG EQP 0364

HSEH'D AUD & VID EQP 0365

COMUNICTNS EQPMENT 0366

ELCTRNC C'PONT&ACERS 0367

MISC. ELCT EQP & SUP 0369

MOTR VEH & EQUIPMENT 0371

AIRCRAFT & PARTS 0372

SHP BOAT BLDG & REP 0373

RAILROAD EQUIPMENT 0374

MOTRCYL BCYL & PART 0375

MISC. TRPT EQPMENT 0379

MESUR INST & SUPLIS 0382

MEDCL INSTRMT & SUPL 0384

OPHTHALMIC GOODS 0385

WATCH CLOCK WTCS PRT 0387

JEW SILV & PLT WARES 0391

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

32

INFORMATION TECHNOLOGY PUNE

DESCRIPTION INDU

TOYS & SPORT GOODS 0394

PEN PNCL OFF & AT SP 0395

MISC. MANUFACTRES 0399

PUB WAREHOUSE& STORG 0422

WTR TRPT OF FRGT NEC 0444

WATER TRPTN SERVICES 0446

AIR TRPTN SCHEDULED 0451

ARPRT FLYG FLD & SER 0458

PSNGR TRPTN ARANGMNT 0472

FRGHT TRNSP ARANGMNT 0473

MISC TRNSPRT SERVCE 0478

TEL. COMMUNICATIONS 0481

RADIO & TV BRODCSTNG 0483

COMMUN SERVICES NEC 0489

ELECTRIC SERVICES 0491

GAS PROD & DISTRBTN 0492

COMBINE UTILTY SERVC 0493

WATER SUPPLY 0494

SANITARY SERVICES 0495

MOTOR VEH & AUTO EQP 0501

SPORT TOY & HBY GOOD 0504

MTL & MNL EXPT PETRL 0505

ELECTRICAL GOODS 0506

MCHNRY EQPMNT & SUPL 0508

MISC DURABLE GOODS 0509

PAPER & PAPER PRODCT 0511

DRG PROPTRY & SUNDRY 0512

APRL PECE GDS & NTN 0513

GRCRES & RLTD PRODCT 0514

FARM PRODT RAW MTRLS 0515

CHEMLS & ALIED MTRLS 0516

PETROLM & PETRO PROD 0517

MISC NONDURBL GOOD 0519

DEPARTMENT STORES 0531

PAPER & PAPER PROD. 0551

EATNG DRINKNG PLACES 0581

BANKS 0600

COM & STCK SVNG BKS 0602

SAVINGS INSTITUTIONS 0603

SAFE DEPOSIT BOXES 0605

FUNCT. BANK RELATED 0609

PERSONAL CREDIT INST 0614

SEC. BROKERS DEALRS 0621

INSURN AGNT BKR & SR 0641

REL ESTE AGNT & MNGR 0653

HTL MOTL & TRST CRT 0701

MISC PRSNL SRVICS 0729

ADVERTISING 0731

CRDT REPORTING & COL 0732

PRSNL SPLY SERVICES 0736

COMPTR DATA PROC SR 0737

AURO SRV EXCEPT REPR 0754

ELECT REPAIR SHOPS 0762

MISC REPAIR SHOPS 0769

HOSPITALS 0806

COLLEGE & UNVRSITIES 0822

LIBRARS & INFRTN CTR 0823

SCHL EDUCTNL SRV NEC 0829

ENGRNG & ACTRL SRVCS 0871

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

33

INFORMATION TECHNOLOGY PUNE

DESCRIPTION INDU

ACCTS. AUDIT BK KPNG 0872

RESEARCH & TST SRVCE 0873

MGT. & PUBL RELATION 0874

SERVICES NEC 0899

COAL 0901

DEFENCE 0902

RAILWAY 0903

RAILWAY NON-TRACTION 0904

ENGINEERING 0905

ICE FACTORY 0906

FISHERY 0907

Public Insti. ZP 0908

S/W Tech. park 0909

Pub.Inst.Educa 0910

Pub.Insti.Religious 0911

Pub.Inst.Munci.Hos. 0912

Pub.Inst.Govt.Hos. 0913

SUGAR FACT PVT 0914

SUGAR FACT COOP 0915

SOOT GIRNI PVT 0916

SOOT GIRNI COOP 0917

Educational Institutes 1

Poultry LF 1001

Poultry 3 Phase 1002

Poultry Motive power 1003

Cinema 1004

Rajiv Gandhi Yojana 1005

PreCool/Cold Storage 1006

BPL - OTHERS 1007

CORPORATION,GRAM PANCHAYAT 1008

GOVT QUARTERS 1009

VIP CONSUMERS 1010

HEAVY CONSUMPTION CONSUMER 1011

COMMON CONN(FLAT SC) 1012

RES-OTHER 1013

Advt.Hoarding 1101

TEMP - OTHERS 1201

TEMP - RELIGIOUS 1202

Govt Hospitals 2

Educational Institue 2001

Dispensaries 2002

Private Hospital 2003

Govt.Hospital 2004

Malls 2005

Construction 2006

HOTEL / BAR 2007

HOTEL / BAR WITH AC 2008

DELUX / STAR HOTEL BAR 2009

DHABA / RESORT 2010

FABRICATION / WELDING 2011

DRY CLEANING / PRESSING 2012

SHOP / STORE / SHOW ROOM 2013

SHOP / STORE / SHOW ROOM WITH AC 2014

BEAUTY PARLOUR / GYM. / POOL 2015

ICE CREAM PARLOUR 2016

OFFICE 2017

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

34

INFORMATION TECHNOLOGY PUNE

DESCRIPTION INDU

OFFICE WITH AC 2018

DEPARTMENTAL STORE 2019

DEPARTMENTAL STORE WITH AC 2020

VIDEO PARLOUR 2021

MUNCIPALITY / GOVT / CORPORATION CONNECTION 2022

COMMUNITY HALL / MANGAL KARYALAYA 2023

COMMERCIAL COMPLEX 2024

COMPUTER INSTITUE/ CYBER CAFE 2025

PETROL PUMP 2026

STD/FAX/PHOTO COPY CENTER 2027

PAN THELA / SMALL SHOPS 2028

COMM-OTHER 2029

Mobile Tower 3

Mobile Towers 3001

AGRICULTURAL 3002

PHARAMACEUTICAL 3003

CHEMICAL 3004

CEMENT 3005

PAPER 3006

SUGAR 3007

SYNTHETICS 3008

TEXTTILES 3009

IND-OTHER 3010

METALLURGY 3011

RAILWAY-TRACTION 3012

ICE FACTORY 3013

FLOUR MILL 3014

MISCELLANEOUS 3015

Malls 4

POWER LOOM 4001

OTHERS 4002

Construction Activity 5

PWW - STATE GOVT 5001

PWW - MUNCIPALTY 5002

PWW - GRAM PANCHAYAT 5003

PWW - OTHERS 5004

Temp R 6

STREET LIGHT - MUNCIPALTY 6001

STREET LIGHT - GRAM PANCHAYAT 6002

AGRICULTURAL 7001

AGRICULTURAL - OTHERS 7002

Poultry LF 8001

Poultry 3 Phase 8002

Poultry Motive power 8003

PreCool/Cold Storage 9001

SOOT GIRANI 910

LIFT IRRIGATION 911

Agricultural A

Cold Storage B

Pharmaceutical C

Chemical D

Fertilizer E

Cement F

Paper G

Sugar H

GOVT. OFFICES I

Synthetics J

Textiles K

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

35

INFORMATION TECHNOLOGY PUNE

DESCRIPTION INDU

Coal L

Metallurgy M

Non-ferrous N

DEPARTMENTAL STORE O

Iron & Steel P

Defence Q

Railways - Traction R

Engineering S

Ice Factory T

COMP.INST/CAFE V

Newspaper W

Miscellaneous X

PAN/SMALL SHOPS Y

METER SUBTYPE MASTER;

-------- ----------------------------------

SUB TYPE DESCRIPTION

-------- ----------------------------------

MECH Mechanical

HYBR Hybrid

STAT Static

SOLID Solidstate

CTELEC CT Electronic

CTELMN CT Electromagnetic

IRPORT METER WITH IR PORT

-------------------------------------------

METER TYPE CODE

DESCRIPTION ME

------------------------------------------------------------ --

HT MAIN: TRI-VECTORMETER WITH OPTIONAL DIALS 11

HT MAIN: TRI-VECTORMETER WITHOUT OPTIONAL DIALS 12

HT MAIN: KWH and KW DEMAND METER 13

HT MAIN: RKVAH METER 14

HT AUX: TRI-VECTORMETER WITH OPTIONAL DIALS 21

HT AUX: TRI-VECTORMETER WITHOUT OPTIONAL DIALS 22

HT AUX: KWH and KW DEMAND METER 23

HT AUX: RKVAH METER 24

Migration_name 32

SUB TO MAIN: CONSUMPTION WHEN DUTY IS EXEMPTED 40

SUB TO MAIN: COLD STORAGE COMSUMPTION IN ICE FACTORY 41

SUB TO MAIN: COMMERCIAL CONSUMPTION INSIDE FACTORY PREMISES 42

SUB TO MAIN: COMMERCIAL CONSUMPTION OUTSIDE FACTORY PREMISES 43

SUB TO MAIN: FLOUR MILL CONSUMPTION 44

SUB TO MAIN: RESIDENTIAL CONSUMPTION 45

SUB TO MAIN: AIR-CONDITIONING POWER IN BP AREA 46

SUB TO MAIN: TO LIFT WATER FOR DOMESTIC USE 47

SUB TO MAIN: CONSUMPTION BILLED SAPERATELY (NOT IN HT BILL) 49

SUB TO SUB: COMMERCIAL CONSUMPTION OUTSIDE FACTORY PREMISES 53

SUB TO SUB: CONSUMPTION OF FLOUR MILL AS SUB-METER TO RESIDE 54

SUB TO SUB: RESIDENTIAL CONSUMPTION AS SUB-METER TO TYPE 43 55

SUB TO SUB: FACTORY CONSUMPTION AS SUB-METER TO RESIDENTIAL 56

Factory consumption to sub meter type 43 57

SUB TO SUB: DUTY FREE FACTORY CONSUMPTION AS SUB-METER TO RE 59

EXPORT METER 61

TOD-MAIN METER 3 CNT 71

DESCRIPTION ME

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

36

INFORMATION TECHNOLOGY PUNE

------------------------------------------------------------ --

TOD-MAIN METER KW COUNTER 72

TOD-MAIN METER RKVA COUNTER 73

LT CONV 75

ADD-TOD-MAIN METER 3 CNT 76

ADD-TOD-MAIN METER KW COUNTER 77

ADD-TOD-MAIN METER RKVA COUNTER 78

EXPRESS METER 81

SUMMATION METER 91

--------------------------------------------------------------------------------

JV CATEGORY MASTER

-- --------------------------------------

DESCRIPTION CA

-------------------------------------------------- --

RESIDENTIAL 01

COMMERCIAL 02

L.T. INDUSTRIAL 03

P.W. WORKS (RURAL) 04

L.T. AGRICULTURAL 05

L.T. MILITARY 06

L.T. P.W.WORKS (UNMETERED) 07

H.T. INDUSTRIAL 08

H.T. P.W. WORKS 09

H.T. RLY. TRACTION 10

H.T. AGRICULTURE 11

H.T. BULK SUPPLY 12

H.T. MILLITARY 13

H.T. P.W.WORKS (UNMETERED) 14

P.D. CONSUMERS 15

Street Light 16

Temp. Lighting 17

Theft of enegry 18

LT-poultry farm 19

HT- Res/Com complex 20

HT-Poultry farm 21

POWER LOOM 22

Mismatch Category 99

-----------------------------------------

METER MAKE CODE

--- -------------------------------------------------------------- --- ---

NAME SHORT_NAME MAK ITE

-------------------------------------------------- --------------- --- ---

ANDHRA PRADESH ELECTRIC EQUIPMENT COR. LTD. ECE-EAW 002 MET

A.E.G. AEG 003 MET

GYRO LABORATORIES,BOMBAY 004 CTP

CHAMBERLAIN & HOOKHAM LTD. C & H 006 MET

DASS HITACHI PVT. LTD., NEW DELHI DASS HITACHI 008 MET

AUTOMATIC ELECTRIC LTD.,THANE 01 CTP

TARIFF APPLIANCES PVT. LTD.,CALCUTTA 010 CTP

CHAMBERIANE & HOOKAHNS 014 CTP

HAVELLS ELECTRICALS HAVELLS ELEC. 015 MET

INDRIGIN ELECT. OVT. LIMITED 016 CTP

BHARAT HEAVY ELECTRICALS LTD.,BHOPAL 02 CTP

EMCO TRANSFORMERS LTD.,BOMBAY 03 CTP

FERRANTI FERRANTI 030 CTP

BARODA ELECTRIC METERS LTD., VALLABH VIDYANAGAR BEW 04 MET

HINDUSTAN BROWN BOVERI LTD.,BARODA 05 CTP

L & T L & T 053 MET

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

37

INFORMATION TECHNOLOGY PUNE

--- -------------------------------------------------------------- --- ---

NAME SHORT_NAME MAK ITE

-------------------------------------------------- --------------- --- ---

Datapro Datapro 054 MET

Secure Secure 055 MET

A.B.B A.B.B 057 MET

SEAHORSE SEAHORSE 058 CTP

L&G L&G 059 MET

IND. AGRICULTURAL ENGG. CORP.,BOMBAY 06 CTP

ELYMER ELYMER 061 MET

AVENER AVENER 062 MET

STELMEC LTD. STELMEC 063 CTP

ELSTER METERING ELST 063 MET

EPITRANS ELECTRICALS EPITRANS 064 CTP

ACCURATE ACCURATE 064 MET

CG LUCY CG LUCY 065 CTP

GENUS GENUS 065 MET

SUPER WINDING WIRES PVT. LTD. SUPERWINDING 066 CTP

CAPITAL METERS PVT LTD CAPITAL METERS 066 MET

VAN ELECTRO DEVICES PVT LTD VAN ELECTRO DEV 067 MET

GEC ALSTHOM INDIA LTD GEC ALSTHOM IND 068 MET

GILBERT ELECTRICALS AND ELECTRONICS PVT LTD GILBERT ELECTRI 069 MET

INDUSTRIAL METERS PVT. LTD.,BOMBAY 07 CTP

KEI ELECTRICALS PVT LTD KEI ELECTRICALS 070 MET

MODEN INSTUMENTS PVT LTD MODEN INSTUMENT 071 MET

POWERTEC METERS POWERTEC METERS 072 MET

EMCO EMCO 074 MET

HPL HPL 076 MET

SHENZEN SHENZEN 078 MET

SEMICONDUCTOR COMPLEX LTD SEMICONDUCTOR C 079 MET

NAGPUR TRANSFORMERS LTD.,NAGPUR 08 CTP

LOTUS WIRES AND CABLES LOTUS WIRES AND 080 MET

OMNI AGATE SYSTEM OMNI AGATE SYST 081 MET

PALMOHAN PALMOHAN 082 MET

SYNERGY SYNERGY 083 MET

RC ENERGY METERING PVT. LTD RC ENERGY METER 084 MET

CAPITAL POWER SYSTEM CAPITAL POWER S 085 MET

MOTWANI MANUFACTURE MOTWANI MANUFAC 086 MET

MODERN INSTRUMENTS PVT LTD MODERN INSTRUME 087 MET

AVON METERS AVON METERS 088 MET

KELTRON COUNTERS LTD KELTRON COUNTER 089 MET

POWER & CONTROL TRANSFORMER IND. PVT. LTD.,BOMBAY 09 CTP

TERANA INFOTECK TERANA INFOTECK 091 MET

NATIONAL TELECOM NATIONAL TELECO 092 MET

TTL LTD TTL LTD 093 MET

TOWERS AND TRANSFORMERS TOWERS AND TRAN 094 MET

ESPRITE SWITCHGEAR PVT LTD ESPRITE SWITCHG 095 MET

BENTEX ELECTRICALS BENTEX ELECTRIC 096 MET

BHARAT HEAVY ELECTRICAL LTD BHARAT HEAVY EL 097 MET

ELECTRIC CONSTRUCTION & EQUIPMENT CO., SONEPAT ECE 10 MET

TRANSFORMERS & ELECTRICALS KERALA LTD.,ANGAMALLY 11 CTP

VOLTAS LTD.,BOMBAY 12 CTP

NELCO 13 CTP

ELECTRICAL INSTRUMENTS MFG.CO.LTD. AHMEDABAD CIMC 14 MET

PRECISE ELECTRICALS 15 CTP

INDIA METERS LIMITED, MADRAS INDIA-METERS 16 MET

S & M EQUIPMENT 17 CTP

T.M.G. 18 CTP

INDUSTRIAL METERS PRIVATE LIMITED IMP 18 MET

CROMPTON & GREAVES 19 CTP

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

38

INFORMATION TECHNOLOGY PUNE

--- -------------------------------------------------------------- --- ---

NAME SHORT_NAME MAK ITE

-------------------------------------------------- --------------- --- ---

SIEMENS 20 CTP

JAIPUR METERS & ELECTRICALS LIMITED, JAIPUR JAIPUR 20 MET

UNIVERSAL ELECTRICALS LIMITED UE 21 CTP

UDAY UDAY 22 CTP

LANDIES & GYR LIMITED L & G 22 MET

METROPOLITAN METROPOLITAN 23 CTP

NSDA NSDA 24 CTP

MALIK METERS PRIVATE LIMITED, BOMBAY MALIK & MEW 24 MET

FOSTER FOSTER 25 CTP

LANDIES & GYR L & G 26 CTP

METERS & INSTRUMENTS PVT. LTD., NEW DELHI M & I 26 MET

METERS & INSTRUMENTS PVT. LTD. M & I 27 CTP

POWER PACK ENTERPRISES 28 CTP

RADIO & ELECTRICALS MFG.CO.LTD., BANGALORE REMCO 28 MET

IVDT IVDT 29 CTP

SIMCO METERS LIMITED, TIRUCHIRAPALLI SIMCO 30 MET

WEBER & OCRSTED W & O 31 CTP

NIPPEN NIPPEN 32 CTP

ASEA ASEA 33 CTP

ELECTRIC CONSTRUCTON & EQUIPMENT CO. LTD. ECE 34 CTP

UNITED ELECTRICAL INDUSTRIES LTD.,CALCUTTA UE 34 MET

VOLTAS VOLTAS 35 MET

AEC COMPANY AEC 36 MET

ARON ARON 38 MET

BUXLELS BUXLELS 40 MET

C.R.E. WOD CO. PVT. LTD. C.R.E.WOD 42 MET

CONTIMENTS CONTIMENTS 44 MET

GANG & CO. LTD., BUDAPEST GANG & CO. 46 MET

KRIZIC KRIZIC 48 MET

SIEMENS SIEMENS 50 MET

SCLUMBER SCLUMBER 52 MET

DUKE ARNIES DUKE ARNES 56 MET

HIMACHAL ENERGY HIMACHAL 75 MET

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

39

INFORMATION TECHNOLOGY PUNE

REPORTS LIST

For Regular PC

Sr.

No.

Report Description File Name e.g.

1. AUDIT_01.PRT CONSUMER/METER STATIC DATA

CHANGE(B31,B32,B33,B34,B45,B46)

AUDIT_01-4611-30-DEC-11.PRT

2. Billctl LIST OF CONSUMERS WHOSE

NETBILAMOUNT > Rs. 10,000.00

BILL_CTL-4611-6-DEC11.PRT

3. Bill_Stat Billing Status,No of Cons(live,pd,td,paid

pending etc),Arrs,billing dates,Meter

Status wise no.of Consumers.

bill-stat4611-6-201112.PRT

4. Damini Diff COMPARISON OF CONSUMPTION

OF Current BILL MONTH WITH

LAST DAMINI READING

DAMINI-DIFF-4611-6-201112.PRT

5. DB48/05 STATEMENT OF EXCESSIVE

CONSUMPTION

DB48EXCESSCONS-4611-6-201112.PRT

6. DB48/02/03 METERS AVERAGE

CONSUMPTION, METERS HAVING

STATUS FAULTY,

DB48meterstatus-4611-6-201112.PRT

7. DB48/01 CONSUMERS NOT CONNECTED

(PAID PENDING) UPTO

DB48PAID-4611-6-201112.PRT

8. DB48/12 CONSUMERS WITH ZERO

CONSUMPTION

DB48ZEROCONSUMP-4611-6-201112.PRT

9. DB57 LT POST BILL REGISTER FOR

BILL MONTH (Ledger) DB57-4611-6-Dec11-001.PRT

10.

,, DB57-4611-6-Dec11-002.PRT

11. LT_DDL_REPORT List of Consumers in Arrears between

Rs. 500 and 99999999 ALL

CATEGORY

DDL-4611-ALL-500-99999999-27122011.PRT

12. EB15 INPUT DOCUMENTS FED FOR

BILLING

EB15-4611-1248-1261.PRT

13. CONSUMERS FROM

ECONNECTION (NO SECURITY

DEPOSIT RECEIPTS IN REGULAR

CASHTALLY)

Econn-No-SD-4611.PRT

14. FINANCIAL AUTHENTICATION

Statistics

Fin-Auth-Stat-4611-201112-301211-022955.PRT

15. STATEMENT OF ELECTRICITY

DUTY PAYABLE FOR BILL MONTH

LTDUTY-4611-6-201112.PRT

16. LTIP R22 JV CATEGORY/TARIFF WISE BILL

ELEMENTS (LT) FOR BILL MONTH

LTIP_R22-4611-6-201112.PRT

17. STATEMENT OF CATEGORYWISE

METER STATUS POSITION FOR

THE BILL MONTH

MI02-4611-6-201112.PRN

18. Notices 15 Days notice for Disconnection notices-4611-6-30122011.pdf

19. PDLIST P.D. CONSUMERS AS ON BILL

MONTH

PDLIST-4611-6-201112.PRT

20. PN24 NEWLY CONNECTED CONSUMERS

FOR THE BILL MONTH

PN24-4611-6-201112.PRT

21. PN33-4611-6-1112

22. LT-R59 ADJUSTMENT TALLY STATEMENT

FOR THE BILL MONTH

R59-4611-6-201112.PRT

23. reading_change- CURRENT READINGS CHANGED

FOR RERUN

reading_change-4611-30122011.prn

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

40

INFORMATION TECHNOLOGY PUNE

24. METER

REPLACEMENT

INFORMATION

REPORT FOR METER

REPLACEMENT INFORMATION

REPLACEMENT-DIFF4611-6-201112.PRT

25. RGTR RGTR File to load in CMS rgtr-4611-6-1112.zip

26. RR RR Sheet For next Reading RR-DTC-4611-6-201112.PRT

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

41

INFORMATION TECHNOLOGY PUNE

BILLING PROGRAM

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION COMPANY LTD.

BU : ___________ BU Name : ____________________________________________

To, Ref :- ______________________________

Dy. General Manager (IT), Date :- ______________________________

MSEDCL, I.T. Center,

Pune.

Sub: - Monthly Photo Billing Reading Program for month of __________________________.

Ref:- 1. Commercial Circular no. 3 issued by CE (Comm.) vide P.com A/Cs monthly bill 21882 dated 01.07.2005.

2. Circular by Director (Finance) letter No. DIR(F)/3562/33897 dated 23.10.2009.

PC CYCLE

NO

Billing Period

From To

Meter Reading Program Date of

Submission

of CD / DVD

of Photo

Readings to

S/Dn

Date of

Submission of

Billing Input

Data to IT by

S/Dn

Bill Printing

Date

Receipts

Cut-Off Date

Previous

Due Date

Current

Due Date

From To

0 ALL

1 01 to 05

2 19 to 23

3 06 to 09

4 24 to 27

5 10 to 14

6 28 to 32

7 15 to 18

8 33 to 36

Copy s.w.r.to :-

1) Superintending Engineer, MSEDCL, _________________________ Asstt. Engineer/Dy.E.E.

2) Executive Engineer, MSEDCL, _________________________ MSEDCL,

_____________________ Sub Dn.

Copy to : Agency : _____________________________________________ Your are requested to complete the reading program as per schedule in above billing program & submit B30, Photo CD, DTC reading file, LCMS and validation report in

duplicate to this office within time for further processing.

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

42

INFORMATION TECHNOLOGY PUNE

Prepaid Meter

Concept-

Pay as you use concept

Similar to Pre-Paid Cell Phone Connections

Consumer Pays in advance

Budgeting of consumption can be done

Requirement defines the amount of Pre-payment

On using Prepaid Meters consumers will get a 5 per cent discount in their electricity bills.

A consumer interface unit will be given that will include information regarding the unit and

instructions on how to recharge the meter. The consumer will be able to conserve energy and use as

per requirement.

Consumers who install prepaid meters can avail of happy-hour scheme as well. Their power supply

will not be disconnected on weekends or national holidays and they can buy and insert the recharge

coupon later. The units consumed during the weekend will be adjusted against the recharge balance.

The online recharge facility is also available on www.mahadiscom.in.

Pre-paid Metering Advantages:

No Manpower required for Meter Reading and Disconnection

Revenue in advance

Transparent System

Consumer can budget their consumption requirements

Automatic Connection/Disconnection for non-paying consumers

Provides all anti-tamper features

5% incentive on tariff.

Pre-paid Metering Components:

Prepaid Energy Meter

Consumer Interface Unit (CIU)

Web-based Vending Software system

Pre-paid Meter Features:

Real Time Clock

Anti-Tamper Features

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

43

INFORMATION TECHNOLOGY PUNE

Load disconnection in case current exceeds the predefined load limit

Load disconnection in case credit becomes zero

User friendly keypad and display

Code encryption/decryption using Triple DES

Buzzer alarm in case of low credit and overload

Bi-coloured LED for low credit warning

Provision for Happy Hours

Meter Programmed with MERC Billing structure

Tariff Slab Structure

Fuel Surcharge

Fixed Charges

Emergency Credit

Load Limit

Calendar Management

National and State Fixed Holidays

Second & Fourth Saturdays and Sundays

Happy Hours

Consumer Interface Unit Features:

User Friendly Display and Keyboard, same as meter

Connectivity between CIU and Meter up to 100m

Buzzer to generate alarm signal in case of low credit

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

44

INFORMATION TECHNOLOGY PUNE

Photo Entry Software

Photo Meter Software is used for Meter Photo Viewing, Data Entry,B30 Reading File Creation

& generation of exception reports.

DTC wise consumers meter images are captured by digital camera and uploaded on a PC every

day by meter reading agencies

Video shooting can be taken wherever necessary in case of theft

Data entry ( in B30 text format ) using meter photo, is done by the agency using PHOTOENT

software.

After conversion into B30 file, it has to be validated through MSEBVAL3 ( offline validation

software).

Exception reports are generated at the time of offiline validation and errors can be removed

through validation software.

Following 5 Types of Reports are generated.

1. No Reading (Punched) consumers list.

2. Zero consumption consumers list

3. 1 to 30 units consumption consumers list

4. Tempered (Meter status 9) consumers list

5. Meter status wise no of consumers list.

No Use Master (Consumers having no use) can be created so that these consumers will not

appear in Exception Reports ,thus reducing the checking time of subdivision.

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

45

INFORMATION TECHNOLOGY PUNE

Ebill And Online Payment

Request For E-bill

If Consumer registers for E-Bill , he will receive the ebill in addition to the normal bill, which he will

receive through the normal billing procedure of the distribution channel.

(All Fields Are Required) *

Consumer No *

Processing Cycle *

Billing Unit *

Email Address to receive e-Bill *

Online Payment

Consumers can pay Bill Online through debit and credit card.

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

46

INFORMATION TECHNOLOGY PUNE

Online eConnection System

New connection data is to be entered on line at Sub Division Offices on daily basis.

Section Officer will submit the new connection application as well as status reports up to

release of connection to Sub Division Office, at pre-determined intervals. Urban section

offices will submit data every alternate day, while Rural section will submit data on weekly

basis, on a particular day assigned to the Section Office by the Sub Division. Sub Division

offices will feed A-1 forms on-line and then will send the applications, with System

generated Application number and Consumer number, to Section Offices for further

necessary action.

Section Office Activities:

On the assigned day, Section Office will submit following documents to the Sub Division

office-

1) Applications received A-1 forms

2) Site Survey ATR with system-generated Application No.

3) Load Estimate ATR

4) Estimates / Firm Quotations issued details

5) Release of connections

Sub Division Office Activities:

Sub Division Office will perform following activities, every day-

1) On receipt of meters from Stores, will update the Meter master.

2) Update Billing Details codes like Tariff Codes, Electricity Duty Codes etc.

3) Update Payment Details.

The New Service Connection System is designed on the Work Flow basis. Each Application

entered in the system will flow through a pre-defined set of Process Flow observed in the

manual New Connection System.

The Process Flow for the Online NSC System is as follows:

a. New Connection Request.

b. Load Assessment.

c. Estimate Generation.

d. Payment by Applicant (Receipt Generation).

e. Meter Assignment & Supply Details.

f. Connection to Consumer.

The NSC System will generate Status report depending on the Status of each Application

entered in the system.

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

47

INFORMATION TECHNOLOGY PUNE

Frequently Asked Questions

Security Deposit

Q1. In case of many consumers, it is observed that the amount appearing as S.D.Paid in EB72

report is much more ( 100 times ). Why ?

A. While filling the B18 Document, the amount of S.D. paid is required to be written in Rupees

only and not in Rupees and Paise as in case of other financial documents e.g. B80, B60 etc.

Q2. Is it possible to reduce the amount of S.D.Paid against a particular Receipt.?

A. No. The particular S.D.Receipt is required to be deleted by feeding B17 Document with

deletion code as 0. Be careful to write the amount in Rupees only in the B17 document and

correct Receipt Number and Date. Through B17 document will be rejected by the System if

these three does not match with master record.

Q3. What are S.D.Arrears appearing in DB57 Report ?

A. Normally there is a practice to raise Additional S.D. Demand whenever there is Tariff change.

The amount of ASD Demanded goes in arrears and is printed in the DB57 Report from next

billing if the same is not paid by the consumer.

Q4. How S.D.Demand is calculated by the system when A.S.D. Demand is raised ?

A. M.S.E.B. Conditions of Supply at Sr.No. 6 of Scale of Miscellaneous and General Charges

have specified the proportionate amounts of S.D. Amounts required to be paid by the

Consumers depending frequency of billing. The System computes amount of S.D. required to

be paid by the consumer by multiplying the amount of current month bill and frequency of

billing. Sum of S.D. paid by the consumer and S.D.Arrears is reduced from the calculated

amount and the remaining amount, rounded to nearest Ten Rupees, is raised as S.D. Demand.

Q5. Abnormal S.D Demand is raised in few cases. Why ? Can it be reduced since it reflects the S.D

Arrears figures adversely ?

A. If the consumer is billed on average in the month in which A.S.D. Demand is raised , and the

average developed is very high due to other meter reading related reasons , the amount of

A.S.D. Demand would be naturally high with the computation procedure explained in answer

to Q5 above. The amount of S.D Arrears can be reduced by feeding B17 Document with

deletion code as 2.

Q6. What action is required to be taken when consumers arrears are adjusted against Security

Deposit ?

A. Feed Document B17 for deletion of S.D. in case full amount of S.D. Paid by the consumer is

adjusted. In case part amount of S.D. Paid is adjusted , take action explained in answer to Q2

above. Feed Document B80 for giving credit to arrears with document type 05.

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

48

INFORMATION TECHNOLOGY PUNE

Q7. It is observed in few cases that the amount of S.D. shown on consumers bill is different than the

amount of S.D. shown in the EB72 Report. Why ? and What is solution to make these two

figures identical ?

Or

In few cases the Amount of S.D. Interest given in the bill does not match ( is less ) with the

amount calculated for the Amount of S.D. shown on the Bill. Why ?

Ans. Computerized L.T.Billing is designed to operate in two different ways i.e. L.T. Billing and

Security Deposit System. These two Systems are inter dependent on each other and are

interlinked by Documents related to S.D. Payment i.e. B17/B18 or Receipt Type 03 or 05.

When such document comes as transaction, the L.T.Billing System prepares internally

Document type B018 or B017 dependent on S.D. addition or deletion. These documents are

updated to S.D.Master normally once in year i.e. after processing of every March Billing and

then run of S.D. Interest Calculation , i.e. EB72 , is taken. It is possible that some of the files of

SD receipts are not taken inadvertently at the time of S.D. Master Update run. Due to this The

amount old S.D. held is less by the amount of the left out SD transaction. The concerned IT

Center can update such left out transactions if proper details are given.

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

49

INFORMATION TECHNOLOGY PUNE

Meter Related

Q1. How to deal with the cases of L.T.Consumers having C.L. > 67 HP and to be billed on demand

basis ? They are provided with electronic meter having demand recording facility.

Ans. Such consumers should be disconnected i.e. made P.D. from L.T.Billing System and should be

billed in H.T.Billing System.

Q2. How to deal with multiple meter replacement cases of same consumer ?

Ans. Feed B19/25 Document set. If there are multiple meter replacements within a period of bill

frequency, feed details of first replaced meter in B19 and details of last meter replaced in B25.

Consumption for intervening period can be charged by advancing the closing reading of

replaced meter by those many units. Similar treatment can be given in case additional units are

to be charged for faulty period with less average. Do not feed two or more sets of B19/25 in

same cycle if meter is replaced more than once in same cycle.

Q3. How to handle cases arising out of wrong meter digits in overflow cases ?

Ans. Feed Document B46 to change previous reading ,change average and B80 to give appropriate

credit.

In order to avoid recurrences of similar cases ask the data entry agency to use MSEBVAL3

Software to validate data. This software gives B30 Error report which highlights the consumer

having consumption more than 4 times average consumption. The Agency is required to take

meter reading master after every processing to validate the reading data of next cycle. If the

report generated by this software is properly attended many cases of abnormal billing can be

reduced at the validation level only.

Q4. I have changed tariff code of a consumer from 01 to 04. How do I change meter ID of the meter

of consumer from 90 to 80 in order to avoid the consumer appearing in Static Master Update

Report with reason „Wrong Meter / Extra Live Meter‟ ?

Or

While feeding B25 Document Meter Number given is wrong . How can I change the same ?

Ans. Document for updation of Meter related Data is B45. However as this document is used for

modification in the details of existing meter , meter number is a key field in addition to

consumer number and PC. It is therefore necessary to give treatment of meter replacement by

feeding set of B19/25 document.

Q5. Which Report is to be referred to verify the effect of meter replacement ?

Ans. B25 report gives details of old meter as well as amended meter.

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

50

INFORMATION TECHNOLOGY PUNE

Static Update

Q1. Some times Change of Average fed through Document B46 or Change to previous Meter

Reading fed through Document B45 does not get effect. Why ?

Ans. It is necessary to see that in both the cases meter status should be zero. The System does not

change these details for a period earlier than six months.

Q2. What Document is to be used for feeding change of Connected Load / Sanctioned Load ?

Ans. Feed Document B31 with 1 at column 73 for change of connected load and 2 for change of

sanctioned load. Note that load is in HP for IP and Ag. Consumers only. For other categories it

is in KW. The loads in HP are to be fed in two digits and those in KW are to be fed in one digit.

Q3. What Document is to be used for feeding commercial connected load of industrial, power loom

consumer ?

Ans. Feed Document B31 with 3 at column 73. Convert the connected load in KW and feed in one

digit.

Q4. What Document is to be used for charging Capacitor Penalty ?

Ans. Feed „Y‟ at column number 74 of B31 document if capacitor is available i.e. penalty is not to

be charged. Feed „N‟ at column number 74 of B31 document if capacitor is not available i.e.

penalty is to be charged.

Q5. How to feed test date , Laboratory number etc fields leftout to be filled while feeding B25

Document.

Ans. Meter Update of all fields of form B25 can be done through Document B45 with same coloumn

number. It is however necessary to give proper meter number in addition to consumer number

and PC.

Q6. What report is required to be referred for finding the effect of static changes fed ?

Ans. Audit 01, Audit 03.

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

51

INFORMATION TECHNOLOGY PUNE

LT Billing ( General )

Q1. What is difference between Interest Arrears and Interest on Arrears appearing on the Bill ?

Ans. We do not calculate compound interest. It is therefore necessary to keep record of principle

arrears and interest calculated thereon separately. Interest is calculated on outstanding arrears

for a period from COD (cut off date) to COD. Amount of unpaid interest is accumulated as

interest arrears.

Q2. In absence of Meter Rent , how to know that a consumer is single phase or three phase. ?

Ans. 1. Fixed Charges are different for single/three phase consumers.

2. In the column of meter rent 1 is printed for three phase consumers.

Q3. Is there any provision to feed information of one time cost of meter recovered ?

Ans. Yes. New Receipt Type 06 is introduced for this purpose.

Q4. In some Bills the Energy Charges are zero even though there is consumption. What is wrong ?

Ans. Proper Industrial category code is not fed for street light consumers. Number of power looms

are not given for power loom consumer.

Q5. What Document is to be used for feeding Number of Power Looms.

Ans. Document B11 / B31 Column Number 48to50.

Q6. What Document is to be used for feeding FEMS Code ?

Ans. Document B34 Column Number 49-57.

Q7. What is fractional Billing ? Why is necessary ? How is it calculated ?

Ans. The Energy Billing System has a concept of month of 30 days. However it is possible that we

do not take consumers readings after exactly 30 / 60 /90 days due to reasons beyond our

control. In such cases the period of consumption is exceeded by few days. The tariff is based on

slab wise rates and the consumption slabs defined in the tariff are month wise slabs. In order

that the consumer is not charged at higher rate , it is necessary to divide the used consumption

in slabs properly.

Fraction is calculated as proportionate month exceeding the defined bill frequency months. If

difference in current reading date and previous reading date is 61 days for a bimonthly PC the

fraction is 0.03 i..e 1/30 month.

Q9. Interest is charged even though full payment of last bill is made within due date ?

Ans. In case previous bill was having arrears, the system calculates interest from earlier COD to

current COD.

Q10. On some bills „Pay by DD or Cash‟ message is coming. Why this message is printed ? What

Document is required to be fed to remove the same ?

Ans. This message is printed on Bill if you feed B66 document to increase arrears due to cheque

bounce. No Document is specified for removal of this message. However the message can be

removed by giving an authorized letter from circle to IT.

MAHARASHTRA STATE ELECTRICITY DISTRIBUTION CO.LTD.

52

INFORMATION TECHNOLOGY PUNE

Miscellenous

Q1. Electrical Inspector has asked

for details (i.e. State Govt. , Central Govt. etc ) of number of consumers and consumption for duty

exempted consumers. Where do we get such details?

Ans. End Statistics of DB57 Report i.e. Report DB57/4 give these details. However in order to get

these details correctly it is essential to fed correct disconnection indicator for the respective

consumers. Refer to the table of disconnection indicator in the manual and feed change through

B31 Document.

Q2. How to change unmetered consumer to metered one ?

Ans. Feed B10 Document with document type 3 with date of change and B25 Document to add

meter with appropriate meter details.

Q3. Consumer is added but Bill is not generated. Why ?

Ans. B34/25 is not fed at all. Feed the Document B34/25. It is possible that in Document B34 data of

supply is wrongfully fed as 00.

Q4. In some of Ag. Consumers, the amount of annual minimum shortfall charged in Sept Bill is too

high. Why?

Ans. The Billing system is designed to calculate the annual minimum short fall at the time of Sept

Bill. It is expected that reading of consumer ( i.e. with live meter status ) is given at least in

Sept Billing i.e. when AMC is worked out. The cases referred in question arise in case of

billing on Average for longer periods. Longer the period of Average Billing, bigger is the

amount of AMC calculated by the System. Solution is give reading with meter status zero with

every billing of Sept.

Q5. Why MS-9 comes ? How to tackle such cases ?

Ans. If the current consumption < 90% of the average consumption. In case of successive two meter

lock status current consumption is taken as the consumption since last reading available with

the system. To get read of this problem bring reading.

Q6. How to change PC ?

Ans. If large number of consumers are involved in PC change activity i.e. due to reallocation of

geographical area due to inception of new sub division or new division, the concerned IT center

shall attend to the PC change activity. However active involvement of both the units is

necessary. In other cases where very few cases are involved, the concerned billing unit is

required to compile such requirements. The IT Centers shall be in a position to take up the

activity of PC change once in a year if sufficient number consumers require to be transferred to

other PCs/ Billing Units. It is to be noted by all the users that it is not possible for any IT Center

to change PC of any individual consumer at any time.

In case the PC change is very urgent, following procedure may be followed..

1. The consumer in old PC should be made PD and arrears to be made nil.

2. Feed New consumer with different consumer number in the PC in which he is required to

be billed. Transfer arrears by feeding debit B80.