Overview

SBM Download
SBM Upload
SCM Download

Sheet 1: SBM Download
VERSION : 1.00 (02nd January 2008)
PC to SBM Record Structure
S. No Column Name Data Type Length Location Format
1 Customer Number Char 13 0
2 Customer Name Char 20 13
3 Address – 1 Char 15 33
4 Address – 2 Char 15 48
5 DTR Code Number 10 63
6 FDR Code Number 12 73
7 ERO Code Number 3 85
8 Group Char 2 88
9 Meter No Char 10 90
10 Meter Make Char 15 100
11 TC Seal No Char 6 115
12 Category Number 1 121
13 Sub Category Number 2 122
14 Phase Number 1 124
15 Multiplication Factor Number 7 125 7,2
16 Previous Reading Number 11 132 11,2
17 Previous Status Number 2 143
18 Previous Reading Date Date 10 145
19 Last Paid Date Date 10 155
20 Mobile Number Number 10 165
21 Arrears Before Number 9 175 9,2
22 Arrears After Number 9 184 9,2
23 Additional Charges(ACD Surchg) Number 9 193 9,2
24 Special Charges Number 9 202 9,2
25 Surcharges Number 9 211 9,2
26 ED Interest Number 9 220 9,2
27 Avg Units/Month Number 6 229
28 Provisional Amount Number 9 235 9,2
29 Provisional ED Amount Number 9 244 9,2
30 Connected Load in KW/HP Number 10 253 10,3
31 ACD Number 9 263 9,2
32 FSA Number 9 272 9,2
33 Seasonal Flag Char 1 281
34 Capacitor Charges Flag Char 1 282
35 Metered/ Unmetered service flag Char 1 283
36 Trivector flag Char 1 284
37 LV side flag Char 1 285
38 ED Exemption Flag Char 1 286
39 SC/ST Flag Char 1 287
40 Electronics/Non Electronics Flag Char 1 288
41 Contracted Load in HP Number 10 289 10,3
42 Connected Maximum Demand Number 10 299 10,3
43 Lighting Load in KW Number 10 309 10,3
44 Previous Reading in KVAH Number 11 319 11,2
45 Previous Avg KVAH Number 6 330
46 Connected Points (6 Category) Number 6 336
47 Door lock Count Number 2 342
48 CalBuf Units (6 Category) Number 6 344
49 Agriculture Service – 1 Char 13 350
50 Agriculture Service – 2 Char 13 363
51 Agriculture Service – 3 Char 13 376
52 Agriculture Arrears Number 9 389 9,2
53 Area Code Char 6 398






Total length of the Record 404

Sheet 2: SBM Upload
VERSION : 1.00 (02nd January 2008)
SBM to PC Record Structure
S. No Column Name Data Type Length Location Format
1 Customer Number Char 13 0
2 Bill Date Date 9 13 DD-MMM-YY
3 Disconnection Date Date 9 22 DD-MMM-YY
4 Due Date Date 9 31 DD-MMM-YY
5 Bill Number Number 4 40
6 Meter Closing Reading Number 11 44 11,2
7 Meter Closing Status Number 2 55
8 Billed Units Number 6 57
9 Energy Charges Number 11 63 11,2
10 Customer Charges Number 11 74 11,2
11 Electricity Duty Number 11 85 11,2
12 Fixed Charges Number 11 96 11,2
13 Demand Charges Number 11 107 11,2
14 Capacitor Charges/ LPF Surcharge Number 11 118 11,2
15 Total Bill Amount Number 11 129 11,2
16 Provisional Amount Number 11 140 11,2
17 Provisional ED Number 11 151 11,2
18 LLD Surcharge Number 11 162 11,2
19 LLD Units Number 6 173
20 Loss/Gain in Adjustment Number 7 179 11,2
21 Net Amount Number 11 186 11,2
22 Average Units Number 6 197
23 Door Lock Count Number 2 203
24 Abnormal Char 1 205
25 Meter Electronics/Non Electronics Flag Char 1 206
26 TC Seal Flag Char 1 207
27 Mobile Number Number 10 208 DD-MMM-YY
28 DTR Code Number 10 218
29 Disconnection Reading Number 11 228 11,2
30 Meter Change Date Date 9 239 DD-MMM-YY
31 New Meter Make Char 15 248
32 New Meter Number Char 10 263
33 New Multiplication Factor Number 7 273 7,2
34 Initial Reading Number 11 280 11,2
35 UDC Date Date 9 291 DD-MMM-YY
36 Re Connection Date Date 9