Dashboard
202605 · May 2026 · Zone: All Zones
Total Consumers
1,24,560
↑ +342 this cycle
Bills Generated
98,234
79% of cycle complete
Revenue Collected
৳ 84.2 Cr
↑ +6.3% vs last cycle
Outstanding Dues
৳ 12.8 Cr
1,240 overdue consumers
Pending Actions: 5 amendments awaiting approval · 3 DCS mismatch records · 12 MRS exceptions · 1 DCS batch pending validation
Billing Cycle Progress
MRS Generation100%
Amendment Processing87%
Bill Generation79%
Bill Finalisation63%
Bill Dispatch52%
Payment Collection41%
Monthly Collection (৳ Crore)
৳ 84.2 Cr
April 2026
৳ 34.6 Cr
Mar (partial)
Recent Activity
Bill finalisation complete — Zone 4
12,450 bills finalized · 202605
10:42
DCS batch uploaded — Sonali Bank
3,210 records · ৳2.4 Cr validated
09:15
Amendment batch processed
48 meter exchange records updated
08:30
MRS exceptions flagged
12 consumers · estimated reading applied
Yest.
Bill generation batch complete — Zone 1
32,100 bills generated successfully
Yest.
Consumer Category Summary
| Category | Consumers | Avg Bill (৳) | Share |
|---|---|---|---|
| Residential LT | 89,420 | 1,240 | 71.8% |
| Commercial LT | 18,650 | 4,820 | 15.0% |
| Industrial HT | 2,340 | 1,84,500 | 1.9% |
| Agricultural | 8,900 | 890 | 7.1% |
| Govt / PSI | 5,250 | 12,400 | 4.2% |
🛡 System Error Monitoring
Last 24 hours · powered by LB_PKG_ERROR_HANDLER
Errors (24h)
142
across 18 codes
Unacknowledged
23
needs admin review
Critical / Fatal
2
immediate attention
Affected Users
12
unique IDs
Recent Errors
| Code | Module | Sev | User | When | Action |
|---|---|---|---|---|---|
-20780 | Reading Type required (3.39) | E | anjum | 10:42 | |
-20329 | Time Cycle not found (3.16) | E | rahim | 10:38 | |
-20405 | Combination duplicate (3.40) | W | karim | 10:25 | |
-20104 | Bill Cycle date invalid (3.5) | W | anjum | 09:55 | |
-20120 | Holiday already exists (3.6) | W | fatima | 09:42 | |
-20585 | Meter mapping closed (3.29) | W | jamil | 09:30 | ✓ ack |
-20780 | Reading Type required (3.39) | E | system | 08:15 | ✓ ack |
-20329 | Time Cycle not found (3.16) | E | rahim | 07:48 | ✓ ack |
-20100 | Year out of range (3.5) | W | anjum | 07:20 | ✓ ack |
Showing 9 of 142 errors
Auto-refresh: 30s
Top Error Patterns
| Code | Description | Page | Count | Users |
|---|---|---|---|---|
-20329 | Time Cycle not found for update | 3.16 | 28 | 4 |
-20780 | Reading Type Code required | 3.39 | 19 | 3 |
-20405 | Combination already exists | 3.40 | 17 | 2 |
-20120 | Holiday already exists | 3.6 | 14 | 5 |
-20104 | Bill Date validation failed | 3.5 | 12 | 3 |
-20585 | Meter mapping is closed | 3.29 | 11 | 2 |
-20100 | Year value out of range | 3.5 | 9 | 2 |
-20820 | Valid Defective duplicate | 3.41 | 7 | 1 |
💡 Tip: Code -20329 spiked from 4 to 28 today. Likely root cause: stale meter list cache. Investigate batch_meter_sync.sh.
Mailbox
Internal user-to-user messages
Select a message to read
Team Chat
Online
Select a user to start chatting
Census · Operations
Consumer Census
Consumer census entry, bulk update, validation, loading and reporting.
4.1.4 Consumer List
Search and manage all consumer accounts · BC_CUSTOMERS
| Consumer ID | Name | Category | Meter No. | Zone / Area | Bill Cycle | Last Bill (৳) | Outstanding (৳) | Status | Actions |
|---|---|---|---|---|---|---|---|---|---|
| BC-001-04521 | Md. Rafiqul Islam | Residential LT | M-44521-A | Z1 · Mirpur-10 | 202605 | 1,240 | — | Active | |
| BC-002-18903 | Rahman Garments Ltd. | Commercial LT | M-18903-B | Z2 · Motijheel | 202605 | 48,200 | 96,400 | Overdue | |
| BC-003-00871 | BSCIC Industrial Estate | Industrial HT | M-00871-HT | Z3 · Tongi BSCIC | 202605 | 2,14,800 | — | Active | |
| BC-004-33201 | Fatema Begum | Residential LT | M-33201-A | Z1 · Banani | 202605 | 980 | 1,960 | Due | |
| BC-005-09142 | Karim Brothers Store | Commercial LT | M-09142-B | Z4 · Gulshan-2 | — | — | — | Disconnected | |
| BC-006-77110 | Dhaka City Corp. Office | Govt / PSI | M-77110-G | Z2 · Nagar Bhaban | 202605 | 42,100 | — | Active |
Showing 6 of 1,24,560 records
...
Meter Management
Meter assignments, disconnection, reconnection and exchange
Meter Register
Disconnection (BC_DISCINT)
Reconnection (BC_RECOINT)
Meter Exchange (BC_MEXCINT)
Repair History
| Meter No. | Consumer ID | Consumer Name | Type | Make | Install Date | Last Reading | Status | Actions |
|---|---|---|---|---|---|---|---|---|
| M-44521-A | BC-001-04521 | Md. Rafiqul Islam | SP 5A | L&T | 2018-03-15 | 4,521 kWh | In Service | |
| M-18903-B | BC-002-18903 | Rahman Garments | 3P 10A | Schneider | 2019-07-20 | 18,903 kWh | In Service | |
| M-09142-B | BC-005-09142 | Karim Brothers | SP 5A | Energex | 2015-11-01 | 9,142 kWh | Disconnected | |
| M-33442-C | BC-007-33442 | Hasan Trading | SP 5A | L&T | 2020-01-10 | 3,344 kWh | Defective |
Location & Area Management
Consumer location change, area reassignment and walk order
Location Change
Move consumer to a different location within the same area
BC_LOCNENT
Area Change
Transfer consumer between different billing areas or zones
BC_AREAENT
Walk Order Update
Update reading collector walk sequence for a billing area
BC_WLKORUP
Pending Location / Area Changes
| Request ID | Consumer ID | Name | Type | From | To | Requested | Status | Action |
|---|---|---|---|---|---|---|---|---|
| LCH-2025-0021 | BC-004-33201 | Fatema Begum | Area Change | Z1 · Mirpur-10 | Z1 · Mirpur-1 | 2025-03-10 | Pending | |
| LCH-2025-0022 | BC-009-41120 | Amin Traders | Loc Change | House 12, Rd 4 | House 18, Rd 4 | 2025-03-11 | Validated |
3.2.2 Reading Collector
Field reading collectors — code, contact, assignment & status
Collector Details
New / Edit CollectorBC_RDG_COLL
Reading Collectors
| Code | Name | Mobile | Type | Status | Action |
|---|
0 collectorsList of Values
3.2.3 Out Sourcing
Outsourcing contracts — company, location, period & dates
Contract Details
New / Edit ContractBC_OUTSOURCE
Contracts
| Contract No | Company | Location | Period | Start | End | Status | Action |
|---|
0 contracts1/2/3 বছর মেয়াদি
Manpower (Reading Collectors)
Contract: —
1 · Posts (sanctioned) — কোন পোস্টে কত জন
| Post | Quota | Assigned | Action |
|---|
2 · Assigned Manpower — পোস্টের অধীনে লোক
Filled: — / —
| Collector | Post | Boss | Assign | Release | Status | Action |
|---|
0 assignedfrom 3.2.2 Reading Collector
📊 Reports
Full contract history:
MRS Generation
Generate Meter Reading Sheets for field staff
12 MRS Exceptions flagged in current cycle. Estimated readings applied for 8 consumers. Review required before finalisation.
Generate MRS
MRS Status — 202605
| Zone | Consumers | Sheets | Readings Returned | Exceptions | Status |
|---|---|---|---|---|---|
| Zone 1 | 32,100 | 321 | 32,100 (100%) | 2 | Complete |
| Zone 2 | 28,450 | 285 | 28,450 (100%) | 4 | Complete |
| Zone 3 | 37,684 | 377 | 37,684 (100%) | 6 | Complete |
| Zone 4 | 26,326 | 264 | 26,326 (100%) | 0 | Complete |
Meter Reading Data Entry
Enter meter readings returned by field staff
Regular Entry (BC_FMTRSHT)
First Time Entry (BC_FMTRSHT-FT)
Bulk Upload
Enter Reading
Today's Entry Progress
31,842
Readings Entered
258
Pending
Recent Entries
| Consumer | Prev | Current | Units | Type |
|---|---|---|---|---|
| BC-001-04521 | 4,398 | 4,521 | 123 | Actual |
| BC-001-04522 | 2,100 | 2,230 | 130 | Actual |
| BC-001-04523 | 8,900 | 8,900 | 0 | Estimated |
Amendments
Master amendments, meter exchange, disconnection and reconnection
Pending Approval (5)
Master Amendment (BC_MSTAMND)
Bill Correction (BC_BILCORR)
Bulk Amendment (BC_BLKMVLD)
Processing Errors
| Amend ID | Consumer | Type | Description | Requested By | Date | Status | Actions |
|---|---|---|---|---|---|---|---|
| AMD-2025-0301 | BC-001-04521 | Meter Exchange | Old M-44521-A → New M-44521-B (defective) | Zone1-Admin | 2025-03-10 | Pending | |
| AMD-2025-0302 | BC-002-18903 | Tariff Change | Category change: LT Commercial → HT Commercial | HO-Admin | 2025-03-11 | Pending | |
| AMD-2025-0303 | BC-007-55021 | Load Change | Sanctioned load updated: 5kW → 10kW | Zone2-Admin | 2025-03-12 | Pending | |
| AMD-2025-0298 | BC-003-00871 | Address Update | Address correction — plot no. update | Zone3-Admin | 2025-03-09 | Approved |
Bill Generation
Run bill calculation batch for current cycle
Total
1,24,560
Generated
98,234
Pending
26,326
Exceptions
412
Cycle
202605
Run Bill Generation
Batch Run History
| Batch ID | Zone | Bills | Duration | Status |
|---|---|---|---|---|
| BG-0312-01 | Zone 1 | 32,100 | 18 min | Done |
| BG-0312-02 | Zone 2 | 28,450 | 16 min | Done |
| BG-0312-03 | Zone 3 | 37,684 | Running... | Running |
| BG-0312-04 | Zone 4 | — | — | Queued |
Bill Finalisation
Finalise bills and populate bill image table
Bill finalisation locks the bill amounts and generates the official bill image (BC_BILL_IMAGE). After finalisation, bills cannot be recalculated without raising a bill correction amendment.
Run Finalisation
Finalisation Status
Zone 1 — 32,100 bills100%
Zone 2 — 28,450 bills100%
Zone 3 — 37,684 bills68%
Zone 4 — 26,326 bills0%
Bill Dispatch
Mark bills as dispatched and send to field offices
Run Dispatch
Dispatch Status
| Field Office | Bills | Dispatched | Status |
|---|---|---|---|
| Mirpur FO | 32,100 | 32,100 | Complete |
| Motijheel FO | 28,450 | 22,000 | Partial |
| Tongi FO | 37,684 | 0 | Pending |
| Gulshan FO | 26,326 | 0 | Pending |
Invoice Viewer
BC_INVOICE_HDR / BC_INVOICE_DTL · Search and view consumer invoices
| Invoice No. | Consumer | Bill Cycle | Units | Amount (৳) | Due Date | Status |
|---|---|---|---|---|---|---|
| INV-2025-03-04521 | BC-001-04521 | 202605 | 123 | 1,240 | 2025-04-15 | Unpaid |
| INV-2025-03-18903 | BC-002-18903 | 202605 | 1,840 | 48,200 | 2025-04-15 | Overdue |
| INV-2025-02-04521 | BC-001-04521 | 202604 | 118 | 1,180 | 2025-03-15 | Paid |
Invoice Detail
Bangladesh Power Development Board
Electricity Bill
202605 · May 2026
Consumer IDBC-001-04521
Consumer NameMd. Rafiqul Islam
Meter No.M-44521-A
Reading Period01 Mar – 31 Mar 2025
Previous Reading4,398 kWh
Current Reading4,521 kWh
Units Consumed123 kWh
Energy Charge৳ 1,082
VAT (15%)৳ 158
Total Due৳ 1,240
Due Date15 June 2026
Payment Entry
Manual payment entry and receipt generation
Today's Collection
৳ 42.8 L
1,240 transactions
This Week
৳ 2.1 Cr
5,890 transactions
This Cycle
৳ 34.6 Cr
41% of total billed
New Payment
Recent Receipts Today
| Receipt No. | Consumer | Amount (৳) | Mode | Time |
|---|---|---|---|---|
| RCP-240312-4521 | BC-001-04521 | 1,240 | Cash | 10:45 |
| RCP-240312-4522 | BC-002-18903 | 48,200 | Cheque | 10:38 |
| RCP-240312-4523 | BC-003-00871 | 2,14,800 | DCS | 09:55 |
| RCP-240312-4524 | BC-006-77110 | 42,100 | Online | 09:30 |
DCS Processing
BC_RECEIPT1_INT_HDR/DTL · BC_DCS_MISMATCH · Bank payment file validation and posting
3 DCS mismatch records require manual review. Possible causes: incorrect consumer ID, duplicate payment, or amount variance.
Batch Files
Validation Errors
Mismatches (3)
Posting Log
| Batch ID | Bank | File Date | Records | Amount (৳) | Validated | Mismatches | Status | Actions |
|---|---|---|---|---|---|---|---|---|
| DCS-240312-SB | Sonali Bank | 2025-03-12 | 3,210 | 2,40,18,000 | 3,207 | 3 | Partial | |
| DCS-240311-JB | Janata Bank | 2025-03-11 | 1,840 | 89,50,000 | 1,840 | 0 | Posted | |
| DCS-240311-AB | Agrani Bank | 2025-03-11 | 920 | 42,80,000 | 920 | 0 | Posted |
Receipt Management
Search, reprint and cancel receipts
| Receipt No. | Consumer ID | Name | Invoice | Amount (৳) | Mode | Date | Collector | Status | Actions |
|---|---|---|---|---|---|---|---|---|---|
| RCP-240312-4521 | BC-001-04521 | Md. Rafiqul Islam | INV-03-04521 | 1,240 | Cash | 2025-03-12 | Collector-01 | Valid | |
| RCP-240312-4522 | BC-002-18903 | Rahman Garments | INV-03-18903 | 48,200 | Cheque | 2025-03-12 | Collector-02 | Valid | |
| RCP-240310-4410 | BC-008-12300 | Rahim Store | INV-03-12300 | 2,400 | Cash | 2025-03-10 | Collector-01 | Cancelled |
Adjustments
Apply credit/debit adjustments to consumer accounts
New Adjustment
Recent Adjustments
| Adj ID | Consumer | Type | Amount (৳) | Status |
|---|---|---|---|---|
| ADJ-0312-001 | BC-002-18903 | Credit | 5,000 | Posted |
| ADJ-0311-002 | BC-007-55021 | LPS Waiver | 1,200 | Posted |
| ADJ-0310-003 | BC-004-33201 | Tariff Corr. | 450 | Pending |
Dispute Management
Log and resolve consumer bill disputes
Log Dispute
Open Disputes
| Dispute ID | Consumer | Type | Amount | Days Open | Status |
|---|---|---|---|---|---|
| DSP-0312-01 | BC-004-33201 | High Bill | ৳980 | 2 | Under Review |
| DSP-0308-02 | BC-010-88012 | Wrong Reading | ৳2,400 | 6 | Inspection Req. |
| DSP-0301-03 | BC-002-18903 | Arrear Dispute | ৳48,200 | 14 | Escalated |
Installment Plans
Manage payment installments for overdue consumers
Create Installment Plan
Active Installment Plans
| Plan ID | Consumer | Total (৳) | Paid | Balance | Next Due | Status |
|---|---|---|---|---|---|---|
| INS-2025-001 | BC-002-18903 | 96,400 | 32,133 | 64,267 | 2025-04-15 | Active |
| INS-2025-002 | BC-011-44201 | 24,000 | 12,000 | 12,000 | 2025-04-01 | Due |
GL Interface
Upload billing data to General Ledger system
GL Upload Parameters
GL Upload History
| Upload ID | Period | Records | Amount (৳ Cr) | Status |
|---|---|---|---|---|
| GL-2025-02 | April 2026 | 45,230 | 78.4 | Uploaded |
| GL-2025-01 | Jan 2025 | 43,120 | 81.3 | Uploaded |
Tariff Setup
Configure electricity tariff structure
Tariff Rate Master (BC_TRFRATE)
Tariff General (BC_TRFRGEN)
Tariff Type Codes
Tariff Group (BC_TARFCAT)
| Tariff Type | Category | Time Cycle | Rate (৳/kWh) | Lower Limit | Upper Limit | Min Charge (৳) | Eff. Cycle | Status | |
|---|---|---|---|---|---|---|---|---|---|
| 04 | Residential | 1 | 1.000 | 0 | 75.00 | 1.00 | 199804 | Active | |
| 04 | Residential | 1 | 1.000 | 75 | 150.00 | 85.00 | 199804 | Active | |
| 04 | Residential | 1 | 1.000 | 150 | 225.00 | 75.00 | 199804 | Active | |
| 12 | Commercial | 1 | 120.000 | 0 | — | — | 199804 | Active | |
| 07 | Industrial HT | 1 | 500.000 | 0 | — | — | 199804 | Active |
Settings
Configure master data, location hierarchy, categories and system settings
Location Level Master
Define location hierarchy levels (Division, District, Upazila, Union)
BC_LOCATION_LEVEL_MST
Location Combination
Map location level combinations for consumer area assignment
BC_LOCCMBN
Bill Cycle Master
Define billing cycles, cut-off dates and schedule
BC_BILL_CYCLE_MASTER
Category Master
Usage categories, business types, special consumer codes
BC_CATMAST · BC_BUSTYPE
Bank & Collection Centers
Banks, branches, DCS collection points
BC_BANKS · BC_COLL_CENTRE_MST
Bill Messages
Custom messages printed on consumer bills and notices
BC_BILLMSG
Holiday Master
Public holiday calendar for due date calculation
BC_HOLDMST
Unix Parameters
System-level batch processing parameters and paths
BC_UNIX_PARAMETERS
Arrear Suppression
Configure arrear suppression rules and waivers
BC_ARRSUP
Batch Processes
16 batch processes for background data processing — run from Unix/Oracle scheduler
Pre-Billing
BC_JOB_AMEND_PROCESS
Overall amendment processing — validates & applies all amendments
Last: OK 08:30
BC_JOB_MRS_SNAPSHOT
MRS snapshot generation — records reading data before processing
Last: OK
DPG_BC_CENSUSLOADING
Census data loading from interface tables to live consumer tables
Manual
Billing
DPG_BC_BILLCYCLE_INFO
Main bill calculation batch — computes charges for all consumers
Running (Zone 3)
DPG_BC_BILLIMAGE
Bill image population — finalises bills into BC_BILL_IMAGE table
Partial (Z1,Z2)
DPG_BC_BILL_DUE_DATE_EXTN
Due date extension processing for selected consumer groups
Not Run
Payment & Collection
DPG_BC_DCS_VALIDATE
DCS payment file validation — checks records against consumer database
3 mismatches
DPG_BC_RECEIPT_OFFSET
Payment offsetting — applies receipts against outstanding invoices
Last: OK 09:15
DPG_BC_CONS_ARR_ADV
Arrear/advance calculation and population of arrear tables
Last: OK
Month End
DPG_BC_MONTH_END
Month-end processing — closes cycle and prepares next period summary
Scheduled
DPG_BC_GL_UPLOAD
GL interface upload — posts billing transactions to financial system
Scheduled
DPG_BC_CLOSE_CONSUMER
Account closure processing — final billing and balance settlement
Manual
5. Reports
Oracle Reports · Select a report to set parameters and run
Census
5.1 LT/LT1 Census ListingBC_CENLSHT
5.2 HT Census ListingBC_CENLSHT
MRS / Meter Reading
5.3 MRS Sheet LT (Regular)BC_MRSLT
5.4 MRS Sheet HT (Regular)BC_MRSHT
5.5 MRS Sheet HT ConsumersBC_HTMRSPT
5.10 List of Defective Meters Having Valid ReadingBC_DFCTMTR
5.11 List of Meter Readings Not Available — LTBC_NOREDLT
Amendment / Exception
5.6 Exception Amendment Report LTBC_EXCEPLT
5.7 Exception Amendment Report HTBC_EXCEPHT
5.48 Accepted Master Amendment ReportBC_MSTAMRP
5.50 Accepted Reconnection ReportBC_RECNRPT
5.52 Accepted Bill Correction ReportBC_BILCRPT
Snapshot
5.8 Snapshot Report — LTBC_SNAPSLT
5.9 Snapshot Report — HTBC_SNAPSHT
Bill Printing
5.12 Bill Printing — LTBC_BILLPRN
5.13 Bill Printing — HT/LTIBC_BILLPHT
5.14 Bill Register — LT/LTIBC_REGISLT
5.15 Bill Register — HTBC_REGISHT
Outstanding / DCS
5.16 List of Consumers with Outstanding BalanceBC_OUTBALS
5.18 Disconnection Notice PrintingBC_DISCNOT
5.19 DCS Mismatch ReportBC_DCSMISC
5.20 DCS Validation ReportBC_DCSVALD
5.21 Payment Offsetting ReportBC_OFFREPT
5.22 Valid Payment ListingBC_VALIDPAY
5.24 DCS Batch Summary ReportBC_BACHSUM
Write-off / Closure
5.38 List of Write-off ConsumersBC_WROFLST
5.44 List of New Consumers (HT)BC_NCONSHT
Adjustment / Payment
5.58 Adjustment ListingBC_ADJLIST
5.62 List of Cancelled ReceiptsBC_PYCNLRP
5.66 List of All Disputed BillsBC_DISPREP
5.73 Audit Trail for GL PostingBC_IPOSTGL
Interface / GL
5.73 Audit Trail for GL PostingBC_IPOSTGL
5.75 Consumers From RDW — LTBC_IFRDWLT
Analysis
5.77 Age Analysis ReportBC_AGEANAL
5.81 List of Consumers With Zero ConsumptionBC_ZEROCNS
5.82 List of Consumers With Minimum ConsumptionBC_MINCNS
Online Query
5.90 Online Query — LTBC_CONLGLT
5.91 Online Query — HTBC_CONLGHT
3.2.4 Meter Reader Assignment
Location → Meter Reader → Areas · assign reading areas to collectors
1📍 Locations
2👤 Meter Readers
3🗺 Areas
📊 Reports
4.1.1 Census Entry — LT
Select a record to edit, or click New to register a new LT consumer
Total
—
Clean
—
Initial
—
Warning
—
Error
—
Settings · Appearance
Color Theme
Choose and preview the application colour theme for this deployment.
3.12.1 Color Theme Picker
Settings → Customize the UI color scheme for this deployment (BPDB / DPDC / NESCO / REB / WZPDCL / custom)
Preset Themes
Custom Theme — Live Preview
Live UI Sample
Primary Card
A sample card using
var(--primary-lt) background and var(--primary) border.Sidebar Sample
Background uses
--sb → --sb2 gradient.Active nav item
Consumer Census Entry — Data Entry LT
Billing & Collection → Master Maintenance → Census → Data Entry-LT
+ New Record
Location & Account
Consumer Details
Service Address
Mailing Address
Record: 1/1List of Values
Account Closure
Process final bill and close consumer account
Account closure generates a final bill, settles all dues and permanently closes the consumer account. This action cannot be reversed.
Closure Request
Recent Closures
| Consumer ID | Name | Date | Reason | Final Bill |
|---|---|---|---|---|
| BC-005-09142 | Karim Brothers | 2025-02-28 | Non-Payment | ৳ 24,000 |
| BC-012-33412 | Hasan Store | 2025-02-15 | Consumer Request | ৳ 1,840 |
Write-off & Bad Debt
Write off irrecoverable outstanding dues from consumer accounts
Write-off removes outstanding dues from active collections. Requires management approval before posting. All write-offs are logged for audit purposes.
Write-off Request
Write-off History
| Ref No. | Consumer | Amount (৳) | Type | Status |
|---|---|---|---|---|
| WO-2025-001 | BC-013-55010 | 15,200 | Bad Debt | Approved |
| WO-2025-002 | BC-018-72341 | 8,400 | Deceased | Pending |
Pre-Billing · Maintenance
Master Maintenance
Location and area changes, walk-order maintenance, write-off and account closure.
Consumer Location Change
Pre-Billing → Master Maintenance → Location Change → Entry
Location Area Change
Record: 1/1Enter value for: REF_NUM
Consumer Area Change
Pre-Billing → Master Maintenance → Area Change → Entry
Area Change Entry
Record: 1/1Enter value for: REF_NUM
MRS Generation — Regular
Pre-Billing → MRS → Generation-Regular
MRS Card Generation (BC_RMRSGEN)
Generate MRS · Cancel
Location Details
| Zone | Circle | Division | Sub Div | Location | Location Description | |
|---|---|---|---|---|---|---|
Record: 1/1Enter a query, press F9 to execute
Meter Reading Data Entry — Regular
Pre-Billing → MRS → Meter Reading Entry
MRS Entry Header (BC_FMTRSHT)
Consumer Reading Detail
| Cons. No. | Consumer Name | TOD | Time Cycle | Pr. Reading | Reading | Advance | Cum. No. | Mtr. Cond. | Tariff | Prs. PF |
|---|---|---|---|---|---|---|---|---|---|---|
| BC-001-04521 | Md. Rafiqul Islam | |||||||||
| BC-002-18903 | Rahman Garments | |||||||||
| BC-004-33201 | Fatema Begum |
Record: 1/1Enter value for: BILL_CYCLE
Master Amendment Data Entry
Pre-Billing → Amendment Entry → Master Amendment
Consumer Details
Meter Details
Record: 1/1Enter value for: Ref No.
Meter Disconnection Data Entry
Pre-Billing → Amendment Entry → Meter Disconnection
Disconnection Details
Meter Readings
| TOD | Time Cycle Code | Reading Type | Reading | Advance | Cum. No. | Meter Cond. | PF |
|---|---|---|---|---|---|---|---|
Record: 1/1Enter value for: Ref. No.
Meter Reconnection Data Entry
Pre-Billing → Amendment Entry → Meter Reconnection
Reconnection Details
Meter Readings
| TOD | Time Cycle Code | Reading Type | Reading | Advance | Cum. No. | Meter Cond. | PF |
|---|---|---|---|---|---|---|---|
Record: 1/1Enter value for: Ref. No.
Meter Exchange Data Entry
Pre-Billing → Amendment Entry → Meter Exchange
Consumer Details
Old Meter Details
Old Meter Readings
| TOD | Time Cycle | Reading Type | Reading | Advance | Cum. No. | Mtr. Cond. | PF | Assessed Consumption |
|---|---|---|---|---|---|---|---|---|
Record: 1/1Record: 1/1
Business Processes
Billing
Bill generation, billing-cycle and related billing operations.
Bill Generation
Billing → Bill Generation
Bill Generation (BC_BILLGEN)
Run Generation · Cancel
Location Details
| Zone | Circle | Division | Sub Div | Location | Location Description | |
|---|---|---|---|---|---|---|
Record: 1/1Enter a query, press F9 to execute
Bill Finalisation
Billing → Bill Finalisation
Bill Finalisation (BC_BILFINL)
Location Details
| Zone | Circle | Division | Sub Div | Location | Location Description | |
|---|---|---|---|---|---|---|
Record: 1/1Enter a query, press F9 to execute
Bill Dispatch
Billing → Bill Despatch
Bill Despatch (BC_DESPATC)
Location Details
| Zone | Circle | Division | Sub Div | Location | Location Description | |
|---|---|---|---|---|---|---|
Record: 1/1Enter a query, press F9 to execute
Business Processes
Post-Billing
Payments, adjustments, disputes and other post-billing operations.
DCS Entry — Supervisor Batch Header
Post Billing → DCS Entry → Supervisor Batch Header
Payment Entry Sheet (BC_BEDTDCS)
Record: 1/1Enter value for: LOCATION_CODE
Payment Offsetting
Post Billing → Payment Offsetting
Payment Offsetting (BC_PYMTOFF)
Location / Batch Detail
| Batch | Location | Zone | Bank | Payment Date | Total Amount (Tk.) | Status | |
|---|---|---|---|---|---|---|---|
| DCS-240312-SB | LOC-001 | Z1 | Sonali Bank | 2025-03-12 | 2,40,18,000 | Pending | |
| DCS-240311-JB | LOC-002 | Z2 | Janata Bank | 2025-03-11 | 89,50,000 | Validated |
Record: 1/1
Master Data · Organisation
Hierarchy
Organizational office hierarchy and the energy-supply network structure.
3.1.1 Office Hierarchy
Parameter Setup → Office Hierarchy · Zone › Circle › Division › Location
Zones
—
All zones
Circles
—
All circles
Divisions
—
All divisions
Locations
—
All locations
RAO Offices
—
All RAOs
Zones
—
Circles
—
Divisions
—
Locations
| Code | Name | SubDiv | Status |
|---|
—
3.1.2 Energy Supply Hierarchy
Parameter Setup → Energy Supply · Substation › Feeder › Transformer › Pole
Substations
—
All substations
Feeders
—
All feeders
Transformers
—
All transformers
Poles
—
All poles
Substations
—
Feeders
—
Transformers
—
Poles
| Code | Type | Height | GPS | Status | Action |
|---|
—
Master Data · Route Setup
Route Management
Area information, reading collectors, outsourcing and meter-reader assignment for route management.
3.2.1 Area Info
Parameter Setup → Area Info
Area Code
📋 Sourced from 3.1.1 Office Hierarchy → Location Master · কোড ও নাম এক লাইনে
— Select feeder & transformer first —
একসাথে কয়েকটি টিক দিয়ে যোগ করুন
কোনো pole নির্বাচিত নয়
সব নির্বাচিত pole এক ফিল্ডে (POLE_CODES) জমবে
Record: 1/1List of Values
Existing Area Codes
🔍
| Area Code | Book Code | Book Description | Bill Grp | Usage Type | Location | Feeder | Transformer | Status | Action |
|---|---|---|---|---|---|---|---|---|---|
| W0101 | W01 | A/94 | 01 | LT | H4 | F01 | T01 | Active | |
| W0201 | W02 | A/KO94 | 01 | LT | H4 | F02 | T02 | Active | |
| W0301 | W03 | A/KHO 80 | 01 | LT | H4 | F03 | T03 | Active | |
| K0402 | K04 | A-1 | 02 | LT | H5 | F04 | T04 | Active | |
| K0502 | K05 | A-2 | 02 | LT | H5 | F05 | T05 | Active | |
| K0602 | K06 | A-3 | 02 | LT | H5 | F06 | T01 | Active | |
| W0603 | W06 | A/KO 80 | 03 | LT | H4 | F01 | T01 | Active | |
| W0703 | W07 | A/16 | 03 | LT | H4 | F02 | T02 | Active | |
| W0803 | W08 | A/80 | 03 | LT | H4 | F03 | T03 | Active | |
| L2304 | L23 | A-26 | 04 | LT | H5 | F04 | T04 | Active | |
| L2404 | L24 | A-27 | 04 | LT | H5 | F05 | T05 | Active | |
| K3504 | K35 | A-5 | 04 | LT | H5 | F06 | T01 | Active | |
| L4005 | L40 | A-31 | 05 | LT | H5 | F04 | T04 | Active | |
| L4105 | L41 | A-30 | 05 | LT | H5 | F05 | T05 | Active | |
| K4705 | K47 | A-7 | 05 | LT | H5 | F06 | T01 | Active | |
| W1106 | W11 | A/242 | 06 | LT | H4 | F01 | T01 | Active | |
| W1206 | W12 | A/15 | 06 | LT | H4 | F02 | T02 | Active | |
| W1306 | W13 | A/ GO 24 | 06 | LT | H4 | F03 | T03 | Active | |
| L4807 | L48 | A-43 | 07 | LT | H5 | F04 | T04 | Active | |
| L4907 | L49 | A-40 | 07 | LT | H5 | F05 | T05 | Active | |
| L5007 | L50 | A-19 | 07 | LT | H5 | F06 | T01 | Active | |
| W1608 | W16 | A/ GO 61 | 08 | LT | H4 | F01 | T01 | Active | |
| W1708 | W17 | A/KHO 88 | 08 | LT | H4 | F02 | T02 | Active | |
| W1808 | W18 | A/KO 97 | 08 | LT | H4 | F03 | T03 | Active | |
| L6309 | L63 | A-45 | 09 | LT | H5 | F04 | T04 | Active | |
| L6209 | L62 | A-21 | 09 | LT | H5 | F05 | T05 | Active | |
| L6409 | L64 | A/129 | 09 | LT | H5 | F06 | T01 | Active | |
| W2110 | W21 | E/KO 51 | 10 | LT | H4 | F01 | T01 | Active | |
| W2210 | W22 | A/61 | 10 | LT | H4 | F02 | T02 | Active | |
| W2310 | W23 | A/KO 88 | 10 | LT | H4 | F03 | T03 | Active | |
| L7611 | L76 | A-32 | 11 | Both | H5 | F04 | T04 | Active | |
| L7711 | L77 | A-36 | 11 | Both | H5 | F05 | T05 | Active | |
| L7811 | L78 | A-34 | 11 | Both | H5 | F06 | T01 | Active | |
| L9715 | L97 | LTI-5 | 15 | LT | H5 | F04 | T04 | Active | |
| C6615 | C66 | BOOK-C/4 | 15 | LT | H6 | F08 | T03 | Active | |
| C6715 | C67 | BOOK-183/E | 15 | LT | H6 | F09 | T04 | Active | |
| P0116 | P01 | FDFD | 16 | LT | H6 | F07 | T02 | Active | |
| MH122 | MH1 | BOOK-HT-1 | 22 | HT | H6 | F08 | T03 | Active | |
| T0122 | T01 | HT-1 | 22 | HT | H6 | F09 | T04 | Active | |
| XX122 | XX1 | HT HO | 22 | HT | H4 | F01 | T01 | Active |
Showing 40 of 2708 area codesList of Values
6.4 Billing Parameters
Administration → Billing Parameters
Period Settings
Deviation & Consumption Thresholds
Power Factor & Conversion
Despatch & Print Settings
Miscellaneous
System-wide settings · Single record · Last updated by SYSADMIN
Parameter Setup · Schedule
Schedule Management
Holiday calendar and the bill-cycle schedules that drive meter reading, bill generation, due and disconnection dates.
3.3.3 Bill Cycle Schedule (New)
Schedule Management → Bill Cycle Schedule (New)
3.3.2 Bill Cycle Schedule
Parameter Setup → Bill Cycle Schedule
Existing Bill Cycles — Click a row to edit
| Bill Cycle Code | Year | Accounting Month | Status | Schedule Count | Action |
|---|---|---|---|---|---|
| 202503 | 2025 | 03 | Active | 147 | |
| 202502 | 2025 | 02 | Closed | 147 | |
| 202501 | 2025 | 01 | Closed | 147 | |
| 202412 | 2024 | 12 | Closed | 147 | |
| 202411 | 2024 | 11 | Closed | 147 |
Record: 5/5Bill Cycle Master
Bill Cycle Schedule
Parameter Setup → Bill Cycle ScheduleNew
Bill Cycle Code
Bill Cycle Schedule
| Location Code | Reading Start date | Reading End date | Bill Date | Bill due Date |
|---|---|---|---|---|
Record: 1/1List of Values
3.3.1 Holiday Master
Parameter Setup → Holiday Master
Add Holiday
Holiday List
| Holiday Date | Day | Type | Holiday Description | Action |
|---|---|---|---|---|
No holidays added yet Use the form above. | ||||
Record: 0/0List of Values
Parameter Setup · Master Data
Consumer Classification
Define and manage the master codes that classify every BPDB consumer — usage categories, business and customer types, and special tariff rules.
3.4.1 Usage Category Code
Parameter Setup → Category Setup → Usage Category
Entry Block
Current Bill Cycle: 202605 (May 2026). New entries default to this cycle.
Usage Categories
| Code | Description | Usage Type | Abn. Max | Abn. Min | Eff. BC | Exp. BC | Status | Action |
|---|
Record: 0/0List of Values
3.4.2 Business Type Master
Parameter Setup → Category Setup → Business Type
Entry Block
Code zones: 11-13 Residential · 21-29 Irrigation · 31-39 Industrial · 41-49 Public · 51-59 Commercial · 71-79 Special-rate · 81-83 Bulk · 91-92 Lighting/Pumping · FF/PP rebates.
Business Types
🔍
| Code | Description | Status | Action |
|---|
Record: 0/0List of Values
3.4.3 Customer Type Master
Parameter Setup → Category Setup → Customer Type
Entry Block
Customer Types
| Code | Description | Status | Action |
|---|
Record: 0/0List of Values
3.4.4 Special Consumer Code Master
Parameter Setup → Category Setup → Special Consumer Code
Entry Block
Special Codes
| Code | Description | Status | Action |
|---|
Record: 0/0List of Values
3.4.5 Special Type Code Master
Parameter Setup → Category Setup → Special Type Code
Entry Block
3-char mnemonic codes: REG (Regular), CPR/CPV/CPC (Check Point Real/Virtual/Child), SMV/SMC (Shared Meter), UMC (Unmetered), SPM (Single Point Metering).
Special Types
| Code | Description | Status | Action |
|---|
Record: 0/0List of Values
3.4.6 Special Type Rule Code Master
Parameter Setup → Category Setup → Special Type Rule Code
Entry Block
2-char rule codes: SL (Sanctioned Load), CL (Connected Load), PP (Percentage).
Special Type Rules
| Code | Description | Status | Action |
|---|
Record: 0/0List of Values
Parameter Setup · Master Data
Billing
Master codes that govern how bills are typed and charged, and how consumers are grouped by season and connected load.
3.5.1 Bill Type Code Master
Parameter Setup → Category Setup → Bill Type Code
Entry Block
Criteria: O=Other · S=Security · R=Refund · X=Suppl./Final · C=Connection · P=Penalty. Flag 'B' = Both/Blank.
Bill Types
| Code | Description | CD | CN | CR | MB | UC | BT | MC | Status | Action |
|---|
Record: 0/0List of Values
3.5.2 Bill Charge Base Master
Parameter Setup → Category Setup → Bill Charge Base
Entry Block
Serial No determines display order on the printed bill (Consumption=10, Demand=40, VAT=280, ...). Must be unique.
Charge Components
| Srl | Code | Description | Status | Action |
|---|
Record: 0/0List of Values
Parameter Setup · Master Data
Electrical
Voltage, current and phase master codes for electrical configuration.
3.6.1 Voltage Category Master
Parameter Setup → Category Setup → Voltage Category
Entry Block
Lower Val must be strictly less than Upper Val. Unit 2 = kV (production convention).
Voltage Categories
| Code | Description | Lower | Upper | Unit | Status | Action |
|---|
Record: 0/0List of Values
Parameter Setup · Master Data
Meter Config
Time cycles, meter types, protection, manufacturers and seal/reading configuration.
3.7.1 Time Cycle Code Master
Parameter Setup → Category Setup → Time Cycle Code
Entry Block
HH:MM 24-hour. Wrap-around past midnight is allowed (e.g. OFPK 23:59 → 17:00). TOD: 1=SR (Single Register), 2=DR (Double Register), 3=MR (Multi Register).
Time Cycles
| Code | TOD | Start | End | Description | Status | Action |
|---|
Record: 0/0List of Values
3.7.2 TOD Code Master
Parameter Setup → Category Setup → TOD Code
Entry Block
Production data: 01=SR, 02=DR, 03=MR — all three rows are Closed (locked) and cannot be modified. TOD_CODE must be a 2-digit string (01 to 99). Parent of Time Cycle (3.16).
TOD Codes
| Code | Description | Status | Action |
|---|
Record: 0/0List of Values
3.7.3 Time Switch Seal Master
Parameter Setup → Category Setup → Time Switch Seal
Entry Block
Records the physical seal status of a consumer's time-switch (TOD metering device). Production codes: 1=Present, 2=Broken, 3=Nil,No.
Time Switch Seals
| Code | Description | Status | Action |
|---|
Record: 0/0List of Values
Parameter Setup · Master Data
Rules
Validation rules, run statuses, defective codes and amendment-error masters.
3.8.1 Run Status Code Master
Parameter Setup → Category Setup → Run Status Code
Entry Block
Used by the batch job engine — every billing batch (bill generation, ledger posting, arrear roll-over, etc.) records its current state with one of these codes.
Run Status Codes
| Code | Status Text | Status | Action |
|---|
Record: 0/0List of Values
3.6.2 Rated Voltage Master
Parameter Setup → Category Setup → Rated Voltage
Entry Block
Discrete rated voltage of the meter device itself. Distinct from supply Voltage Category (3.15), which is range-based. Unit 1 = Volt (production convention).
Rated Voltages
| Code | Voltage | Unit | Description | Status | Action |
|---|
Record: 0/0List of Values
3.6.3 Rated Current Master
Parameter Setup → Category Setup → Rated Current
Entry Block
Description carries the bracketed CT-coupled form (e.g. 10(20)A means rated 10A with max 20A). Unit 7 = Ampere (production convention).
Rated Currents
| Code | Current | Unit | Description | Status | Action |
|---|
Record: 0/0List of Values
3.8.2 Rule Code Master
Parameter Setup → Category Setup → Rule Code
Entry Block
Billing calculation rule types — referenced by Tariff Rate Master. Tells the billing engine HOW to apply a rate (flat amount, multiplier, weighted, monthly interest, etc.).
Rule Codes
| Code | Description | Status | Rec | Action |
|---|
Record: 0/0List of Values
3.6.4 Phase Connect Master
Parameter Setup → Category Setup → Phase Connect
Entry Block
RYB phase identification for single-phase meters tapped from a 3-phase distribution line. 1=Red, 2=Yellow, 3=Blue.
Phase Codes
| Code | Description | Status | Action |
|---|
Record: 0/0List of Values
3.7.4 Protection Type Master
Parameter Setup → Category Setup → Protection Type
Entry Block
Upstream protection device on the consumer service entry: MCCB (breaker), Fuse, or Cut Off switch.
Protection Types
| Code | Description | Status | Action |
|---|
Record: 0/0List of Values
3.7.5 Manufacturer Code Master
Parameter Setup → Category Setup → Manufacturer Code
Entry Block
46 manufacturers from 1999-2016. Some 1999 entries carry preserved spelling errors (SIEMENNS, FERANTI, SCHELUMBERGER, CHAINA, ESTERN) — these remain Updatable. Code 99 = Others sentinel.
Manufacturers
| Code | Manufacturer Name | Status | Action |
|---|
Record: 0/0List of Values
3.8.3 Processing Exception Code Master
Parameter Setup → Category Setup → Proc Exception Code
Entry Block
C = Critical: bill blocked, manual correction required. R = Reportable: bill proceeds but flagged for review (PF, abnormal usage, meter condition mismatches).
Exception Codes
| Code | Level | Description | Status | Action |
|---|
Record: 0/0List of Values
3.7.6 Meter Location Master
Parameter Setup → Category Setup → Meter Location
Entry Block
Where the consumer meter is physically mounted. Drives meter-reader walk sequence and accessibility flags. Code 9 = Others sentinel; codes 7-8 unused in source.
Meter Locations
| Code | Description | Status | Action |
|---|
Record: 0/0List of Values
3.7.7 New Meter Type Code Master
Parameter Setup → Category Setup → New Meter Type Code
Entry Block
Parent of Meter Type Map (3.29). Hard-delete blocked if referenced by mapping rows. Code 99 = Dummy Meter sentinel for synthetic accounts.
Meter Types
| Code | Description | Status | Action |
|---|
Record: 0/0List of Values
3.7.8 Meter Type Code Map
Parameter Setup → Category Setup → Meter Type Code Map
Entry Block
Composite key: (New, Old). Translates legacy old meter type into new register pattern + phase. KVARH meters carry no phase tag (Phase=blank). FK to 3.28 (New Code) and 3.17 (TOD).
Type Code Mappings
| New | Old | TOD | Phase | Description | Status | Action |
|---|
Record: 0/0List of Values
3.7.9 Reading Type Code Master
Parameter Setup → Category Setup → Reading Type Code
Entry Block
Reading units captured at the meter (KW=demand, KWH=energy, KVA, KVAH, KVARH=reactive, HP). RDG_SRL_NO drives screen display order — not unique.
Reading Types
| Code | Description | Order | Status | Action |
|---|
Record: 0/0List of Values
3.5.3 Seasonal Category Code Master
Parameter Setup → Category Setup → Seasonal Category
Entry Block
⚠ Dates use MMDD integer encoding: 111=Jan 11, 2802=Feb 28, 3006=Jun 30, 3112=Dec 31. Use 0/0 for 'no-date' sentinel (code 98).
Seasonal Categories
| Code | Start | End | Description | Status | Action |
|---|
Record: 0/0List of Values
3.5.4 Load Category Code Master
Parameter Setup → Category Setup → Load Category
Entry Block
Sanctioned-load brackets for tariff selection. Bounds are inclusive (Lower ≤ load ≤ Upper). Unit 5 = kW. Brackets should not overlap.
Load Categories
| Code | Description | Lower | Upper | Status | Action |
|---|
Record: 0/0List of Values
3.8.4 Defective Code Master
Parameter Setup → Category Setup → Defective Code
Entry Block
Type groups by equipment family: D=Device (meter/MD/Ins.Transformer/Protection gear), T=Time-switch, G=Good (no defect). Code 0 'Good' is locked. Code allowed ≥ 0.
Defective Codes
| Code | Type | Description | Status | Action |
|---|
Record: 0/0List of Values
3.8.5 Amend Error Code Master
Parameter Setup → Category Setup → Amend Error Master
Entry Block
Parent catalog of all amendment error codes. 124 unique codes. Detail rows in 3.38 reference these — each code may map to multiple table/column contexts.
🔍 Use search box on the right to filter the 124-row catalog.
Error Code Catalog
| Code | Description | Action |
|---|
Record: 0/0List of Values
3.8.6 Amend Error Code (Detail)
Parameter Setup → Category Setup → Amend Error Detail
Entry Block
ERROR_SRL_NO is the unique PK. ERROR_CODE may repeat — same code applies to many (table, column, source) contexts. Source 'BC_BIlCORR' (lowercase l) is a production typo of BC_BILCORR — kept as-is.
Error Detail Rows
| Srl | Code | Description / Context | Source | Action |
|---|
Record: 0/0List of Values
3.8.7 Valid Reading-TimeCycle
Parameter Setup → Category Setup → Valid Reading Time Cycle
Entry Block
Junction (Reading × Time Cycle). Defines which time cycles can hold each reading type. Composite PK. FK to 3.30 (Reading) and 3.16 (Time Cycle).
Valid Combinations
| Reading Type | Time Cycle | Action |
|---|
Record: 0/0List of Values
3.8.8 Valid Reading Combinations
Parameter Setup → Category Setup → Valid Reading Combinations
Entry Block
4-way junction: Meter × TOD × TimeCycle × Reading. Composite PK across all 4 columns. Tells the reading engine WHICH register patterns are valid for each meter installation.
Combinations
| Meter | TOD | Cycle | Reading | Action |
|---|
Record: 0/0List of Values
3.8.9 Valid Defective Code
Parameter Setup → Category Setup → Valid Defective Code
Entry Block
3-way junction: Reading × TOD (nullable) × Defective. TOD is NULL for non-time-switch defects (meter, MD, IT, protection gear) — only Time-switch defects (codes 32-35) carry a TOD.
Valid Pairings
| Reading | TOD | Def Code | Defect Description | Action |
|---|
Record: 0/0List of Values
3.8.10 Valid Change Meter Types
Parameter Setup → Category Setup → Valid Change Meter Types
Entry Block
Whitelist of allowed meter-type transitions during meter change. Composite PK (Extg, Changed). Both columns FK to 3.28 Meter Type Master. Note: KVARH (12) can only change to KVARH.
Valid Transitions
| From (Existing) | → | To (Changed) | Action |
|---|
Record: 0/0List of Values
Parameter Setup · Master Data
Service Ops
Disconnection and reconnection reason codes for service operations.
3.9.1 Disconnection Reason Code
Parameter Setup → Category Setup → Disconnection Reason
Entry Block
⚠ PK is single-character VARCHAR (not numeric). N=Notice/Overdue, A=Advice, I=Illegal Use. Mnemonic-driven legacy convention from 1999.
Disconnection Reasons
| Code | Description | Status | Action |
|---|
Record: 0/0List of Values
3.9.2 Reconnection Reason Code
Parameter Setup → Category Setup → Reconnection Reason
Entry Block
Reasons for restoring electrical service to a previously disconnected consumer. Most commonly used during dues payment resolution workflow.
Reconnection Reasons
| Code | Description | Status | Action |
|---|
Record: 0/0List of Values
3.7.10 Seal Location Code
Parameter Setup → Category Setup → Seal Location
Entry Block
State of seal on metering equipment at inspection. EQUIP_TYPE column existed in legacy but is NULL across all production rows — kept for schema match only.
Seal Locations
| Code | Location Name | Status | Action |
|---|
Record: 0/0List of Values
3.4.7 Category Master
Parameter Setup → Category Setup → Category Master
Category Details
Record: 1/1List of Values
Parameter Setup · Master Data
Tariff
Tariff type, rate and group master codes that drive bill calculation.
3.5.5 Tariff Type Code Master
Parameter Setup → Tariff Setup → Tariff Type
Entry Block
LPS = Late Payment Surcharge. Manual Adj = whether manual adjustment is permitted. Preference drives display order (duplicates allowed in production data).
Tariff Types
| Code | Acc | Description | Pref | LPS | MAdj | Status | Action |
|---|
Record: 0/0List of Values
3.10.1 Tariff Rate Master
Parameter Setup → Tariff Setup → Tariff Rate Master
Tariff Master
Tariff Details
| Tariff Type | Time Cycle | Rate | Lower Limit | Upper Limit | Min Value (%) | Effective BC | Expiry | State | Action | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0.00 | 300.00 | 200011 | ||||||||
| 300.00 | 500.00 | 200011 |
Record: 1/1List of Values
3.10.2 Tariff Rate General
Parameter Setup → Tariff Setup → Tariff Rate General
Tariff General
| Tariff Type | Time Cycle | Rate | Lower Limit | Upper Limit | Min Value | Charge % | Effective BC | Expiry BC | State | Action | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0.00 | 75.00 | 1.00 | 199804 | ||||||||
| 75.00 | 150.00 | 85 | 199804 |
Record: 1/1List of Values
3.10.3 Tariff Group Master
Parameter Setup → Tariff Setup → Tariff Group
Entry
Record: 1/1List of Values
Tariff Group List
Existing Groups
| Code | Description | Usage Category | Action |
|---|---|---|---|
| TG01 | With VAT for Usage A | A | |
| TG02 | With VAT for Usage B | B |
Record: 1/1List of Values
Month End Cut Off Date
Billing → Billing Cycle → Month End Cut Off
Cut Off Parameters
Group-wise Cut Off Dates
| Bill Group | Receipt Cut Off Date | Invoice Cut Off Date |
|---|---|---|
Select Location, Month, Year and press Generate Add a new entry using the form | ||
Record: 0/0List of Values
Master Data · Miscellaneous
Others
Miscellaneous masters: bill messages, arrear suppression, bank branches and geographic districts.
3.11.5 Ministry Setup
Parameter Setup → Ministry → Division/Wing → Organization
Ministries (0)
Divisions / Wings
← Select a ministry
Organizations / Boards
← Select a division to view its organizations
3.11.1 Bill Message Master
Parameter Setup → Bill Message Master
Bill Message Master
Record: 1/1List of Values
3.11.2 Arrear Suppression
Parameter Setup → Arrear Suppression
Arrear Suppression Parameters
Record: 1/1List of Values
3.11.3 Bank Branch Master
Parameter Setup → Bank · Branch · GL Account Mapping
Total Banks
26
Active
Bank Branches
61
Across all locations
GL Mappings
61
Branch + Location pairs
Locations Covered
4
H4, H5, H6, H9
Banks
Branches
← Select a bank
GL Account Mappings
← Select a branch
3.11.4 District & Upazila/Thana Master
Parameter Setup → Bangladesh Administrative Geography
Divisions
8
All Bangladesh
Total Districts
64
Active
Total Upazilas / Thanas
494
All Bangladesh
BPDB Region
4
Districts (Sylhet Div)
Divisions (8)
Districts (64)
Upazila / Thana
← Select a district to view its upazilas / thanas
🗺 Map View
— Select a district to see thanas pinned
Map loads when you visit the page…
Powered by OpenStreetMap · Leaflet · leafletjs.com
Consumer Walk Order Update
Master Maintenance → Walk Order Update
Walk Order Update
Location Details
| Zone | Circle | Division | Sub Div | Location | Location Description | |
|---|---|---|---|---|---|---|
Record: 1/1List of Values
Walk Order Resequencing
Master Maintenance → Walk Order Resequencing
Walk Order Resequencing
Record: 1/1List of Values
Business Processes
Pre-Billing
Pre-billing entry, amendments, validation and loading steps.
MRS Generation - First Time
Pre-Billing → MRS → Generation First Time
MRS Card Generation First Time
Location Details
| Zone | Circle | Division | Sub Div | Location | Location Description | |
|---|---|---|---|---|---|---|
Record: 1/1List of Values
Bill Correction Data Entry
Pre-Billing → Amendment Entry → Bill Correction
Consumer Details
Meter Readings
| TOD | Time Cycle | Reading Type | Dyn Reading | Closing Reading | Advance | Initial Cum. No. | Cum. No. | Mtr. Cond. | PF |
|---|---|---|---|---|---|---|---|---|---|
Meter Details
Record: 1/1List of Values
Instalment Plan
Billing → Instalment Plan → Entry
Instalment Plan Header
Details
| Serial | Bill Cycle | Principal Amount (Tk.) | LPS Amount (Tk.) | VAT Amount (Tk.) | Addl LPS Amount | Instalment Status |
|---|---|---|---|---|---|---|
| 1 | ||||||
| 2 |
Cancellation
Record: 1/1List of Values
Adjustment Entry
Billing → Adjustment Entry
Adjustment Header
Account Adjusted
| Tariff Type | Code Description | Time Cycle | Adjusted Consumption | Invoice Amount | Corrected Amount | Adjusted Amount | Remarks |
|---|---|---|---|---|---|---|---|
Record: 1/1List of Values
DCS Mismatch
Post Billing → DCS Mismatch
DCS Mismatch
Location Details
| Zone | Circle | Division | Sub Div | Location | Location Description | |
|---|---|---|---|---|---|---|
Record: 1/1List of Values
Payment Cancellation
Post Billing → Payment Cancellation
Payment Cancellation
Recent Cancellations
| Receipt No. | Consumer | Bill Cycle | Amount (Tk.) | Cancel Date | Status |
|---|---|---|---|---|---|
| RCP-240310-4410 | BC-008-12300 | 202605 | 2,400 | 2025-03-10 | Cancelled |
Record: 1/1List of Values
Dispute Bill Processing
Miscellaneous → Dispute Bill Processing
Dispute Entry
Dispute Detail Block
| Dispute Id | Consumer | Type | Amount (Tk.) | Days Open | Status |
|---|---|---|---|---|---|
| DSP-0312-01 | BC-004-33201 | High Bill | 980 | 2 | Under Review |
| DSP-0308-02 | BC-010-88012 | Wrong Reading | 2,400 | 6 | Inspection Req. |
Record: 1/1List of Values
Consumer Location Change Validation
Master Maintenance → Location Change → Validation
Location Change Validation
Location Details
| Zone | Circle | Division | Sub Div | Location | Location Description | |
|---|---|---|---|---|---|---|
Record: 1/1List of Values
Consumer Location Change Loading
Master Maintenance → Location Change → Loading
Location Change Loading
Location Details
| Zone | Circle | Division | Sub Div | Location | Location Description | |
|---|---|---|---|---|---|---|
Record: 1/1List of Values
Consumer Area Change Validation
Master Maintenance → Area Change → Validation
Area Change Validation
Location Details
| Zone | Circle | Division | Sub Div | Location | Location Description | |
|---|---|---|---|---|---|---|
Record: 1/1List of Values
Consumer Area Change Loading
Master Maintenance → Area Change → Loading
Area Change Loading
Location Details
| Zone | Circle | Division | Sub Div | Location | Location Description | |
|---|---|---|---|---|---|---|
Record: 1/1List of Values
4.2.1 Consumer Census Entry — LT
Form: BC_CONSCEN · Master Maintenance → Census → Data Entry
1Location & Source
2Consumer Details
4.1.3 Census Data Bulk Update
Module Census → Census Data Bulk Update
Census Data Bulk Update
Record: 1/1List of Values
4.1.5 Census Data Validation
Module Census → Census Data Validation
Census Validation
Location Details
| Zone | Circle | Division | Sub Div | Location | Location Description | |
|---|---|---|---|---|---|---|
Record: 1/1List of Values
4.1.6 Census Data Loading
Module Census → Census Data Loading
Census Data Loading
Location Details
| Zone | Circle | Division | Sub Div | Location | Location Description | |
|---|---|---|---|---|---|---|
Record: 1/1List of Values
4.1.7 Census Report
Consumer Census → Census Report
Filter Block
Tip: Empty filters = all records. Run before export.
Summary
Not run yet
Total
—
Clean
—
Warning
—
Error
—
Pending
—
Census Records
| Consumer No. | Name | Location | Usage | Status | Entry Date | Bill Cycle |
|---|---|---|---|---|---|---|
No report run yet Set filters and click Run Report | ||||||
Record: 0/0BC_CONSUMER_INTERFACE
Meter Reading Data Entry — First Time
Pre-Billing → MRS → Meter Reading Entry First Time
MRS Entry First Time Header
Consumer Reading Detail
| Cons. No. | Consumer Name | TOD | Time Cycle | Pr. Reading | Reading | Advance | Cum. No. | Mtr. Cond. | Tariff | Prs. PF |
|---|---|---|---|---|---|---|---|---|---|---|
| BC-001-04521 | Md. Rafiqul Islam |
Record: 1/1List of Values
Consumer Data Bulk Update
Pre-Billing → Amendment Entry → Consumer Data Bulk Update
Bulk Master Amendment
Record: 1/1List of Values
Bulk Master Amendment Validation
Pre-Billing → Amendment Entry → Bulk Validation
Bulk Amendment Validation
Location Details
| Zone | Circle | Division | Sub Div | Location | Location Description | |
|---|---|---|---|---|---|---|
Record: 1/1List of Values
Bulk Master Amendment Loading
Pre-Billing → Amendment Entry → Bulk Loading
Bulk Amendment Loading
Location Details
| Zone | Circle | Division | Sub Div | Location | Location Description | |
|---|---|---|---|---|---|---|
Record: 1/1List of Values
Overall Processing
Pre-Billing → Overall Processing
Overall Processing (BC_OVRPROC)
Location Details
| Zone | Circle | Division | Sub Div | Location | Location Description | |
|---|---|---|---|---|---|---|
Record: 1/1List of Values
Overall Finalisation
Pre-Billing → Overall Finalisation
Overall Finalisation (BC_OVRFINL)
Location Details
| Zone | Circle | Division | Sub Div | Location | Location Description | |
|---|---|---|---|---|---|---|
Record: 1/1List of Values
DCS Entry — First Operator
Post Billing → DCS Entry → First Operator
DCS First Operator Entry
Consumer Payment Details
| Cons. No. | Book No. | Bill Cycle | Bill Amount (Tk.) | LPS (Tk.) | VAT (Tk.) | Net Amount (Tk.) |
|---|---|---|---|---|---|---|
Record: 1/1List of Values
DCS Entry — Second Operator
Post Billing → DCS Entry → Second Operator
DCS Second Operator — Verification
Consumer Payment Verification
| Cons. No. | Book No. | Bill Cycle | Bill Amount (Tk.) | LPS (Tk.) | VAT (Tk.) | Net Amount (Tk.) | Match? |
|---|---|---|---|---|---|---|---|
| Pending |
Record: 1/1List of Values
DCS Batch Header Query — Supervisor
Post Billing → DCS Entry → Supervisor Query
Batch Header Query Supervisor
Batch List
| Batch No. | Location | Bank | Branch | Payment Date | Total Amount | Pages | Status |
|---|---|---|---|---|---|---|---|
| DCS-240312-SB | LOC-001 | Sonali Bank | HQ Branch | 2025-03-12 | 2,40,18,000 | 32 | Partial |
| DCS-240311-JB | LOC-002 | Janata Bank | Motijheel | 2025-03-11 | 89,50,000 | 18 | Complete |
Record: 1/1List of Values
DCS Validation
Post Billing → DCS Validation
DCS Validation (BC_DCSVALD)
Location Details
| Zone | Circle | Division | Sub Div | Location | Location Description | |
|---|---|---|---|---|---|---|
Record: 1/1List of Values
Posting Forceful
Post Billing → Posting Forceful
Posting Forceful (BC_PSTFORC)
Force posting bypasses normal validation. Use only when authorised by supervisor.
Record: 1/1List of Values
Bill Due Date Extension
Miscellaneous → Bill Due Date Extension
Bill Due Date Extension
Record: 1/1List of Values
Mass LPS Waiver
Miscellaneous → Mass LPS Waiver
Mass LPS Waiver
Mass LPS Waiver affects all consumers in the selected location. Requires management approval.
Record: 1/1List of Values
Business Processes
Miscellaneous
Miscellaneous billing-operation utilities and processes.
Month End Process
Miscellaneous → Month End Process
Month End Process (BC_MNTHEND)
Location Details
| Zone | Circle | Division | Sub Div | Location | Location Description | |
|---|---|---|---|---|---|---|
Record: 1/1List of Values
Consumer Data Bulk Change
Pre-Billing → Amendment Entry → Consumer Data Bulk Change
Bulk Change Header
Record: 1/1List of Values
Meter Connect Date Update
Pre-Billing → Amendment Entry → Meter Connect Date
Meter Connect Date Update
Record: 1/1List of Values
STUB Batch Header Entry (Supervisor)
Post Billing → STUB Entry → Supervisor Batch Header
STUB Payment Entry Sheet (BC_BEDTSTB)
Record: 1/1List of Values
STUB Entry — First Operator
Post Billing → STUB Entry → First Operator
STUB First Operator Entry
Stub Payment Details
| Stub No. | Consumer No. | Bill Cycle | Bill Amount (Tk.) | LPS (Tk.) | VAT (Tk.) | Net Amount (Tk.) |
|---|---|---|---|---|---|---|
Record: 1/1List of Values
STUB Entry — Second Operator
Post Billing → STUB Entry → Second Operator
STUB Second Operator — Verification
Stub Verification
| Stub No. | Consumer No. | Bill Cycle | Operator 1 Amount | Operator 2 Amount | Match? |
|---|---|---|---|---|---|
| Pending |
Record: 1/1List of Values
STUB Batch Header Query — Supervisor
Post Billing → STUB Entry → Supervisor Query
STUB Batch Query
STUB Batch List
| Batch No. | Location | Bank | Payment Date | Total Amount (Tk.) | Pages | Status |
|---|---|---|---|---|---|---|
| STB-240312-01 | LOC-001 | Sonali Bank | 2025-03-12 | 18,40,000 | 12 | Partial |
| STB-240311-02 | LOC-002 | Janata Bank | 2025-03-11 | 9,20,000 | 8 | Complete |
Record: 1/1List of Values
MOD Report Generation
Miscellaneous → MOD Report Generation
MOD Report Generation (BC_MODRPRC)
Record: 1/1List of Values
MOD Manual Input
Miscellaneous → MOD Manual Input
MOD Manual Input Screen (BC_MODMNUL)
Energy Information
Energy Imported Information
Energy Generated Information
Record: 1/1List of Values
Meter Summary Entry
Miscellaneous → Meter Summary Entry
Meter Summary Entry Screen (BC_MONSUMM)
Meter Summary Details
| Consumer No. | Meter No. | TOD | Previous Reading | Current Reading | Consumption (KWH) | Remarks |
|---|---|---|---|---|---|---|
Record: 1/1List of Values
Miscellaneous Bills
Miscellaneous → Miscellaneous Bills
Miscellaneous Bill Entry (BC_MISCINV)
Miscellaneous bills will be included in the next billing cycle.
Record: 1/1List of Values
Tariff Rate Change — Retrospective
Miscellaneous → Tariff Rate Change Retrospective
Tariff Rate Change Retrospective (BC_BLNKBCR)
Retrospective tariff change will recalculate bills for all affected consumers. This action cannot be undone.
Record: 1/1List of Values
Admin
Admin
Administrative utilities, table maintenance and billing parameters.
Lock Clearing
Administration → Lock Clearing
Lock Clearing
Count: 2BC_LOCKCLR
| Lock Id | Lock Type | Machine / Run ID | Form / Process | User | Lock Time | Action |
|---|---|---|---|---|---|---|
| LK-001 | Machine | BPDB-PC-001 | BC_CONSCEN | SYSADMIN | 2025-03-12 10:42 | |
| LK-002 | Process | RUN-20250312-001 | BC_MSTAMND | OPERATOR1 | 2025-03-12 09:15 |
Bill Print Table Truncation
Admin → Bill Print Table Truncation
Bill Print Table Truncation (BC_TRUNCBL)
This operation permanently removes print data from the database. Ensure bills have been printed before proceeding.
Record: 1/1List of Values
Consumer Deletion
Admin → Consumer Deletion
Consumer Deletion (BC_CONSDEL)
Consumer deletion is PERMANENT and cannot be undone. Ensure all outstanding dues are settled before deletion.
Record: 1/1List of Values
Reports
Reports
All operational and management reports — census, MRS, billing, DCS, amendments and queries.
5.1 LT/LT1 Census Listing
Master Maintenance → Census → Listing LT
Report Parameters — BC_CENLSHT
Report Output Preview
Run report to see actual data
| Cons. No. ↕↕ | Customer Name ↕↕ | Father's Name ↕↕ | Service Address ↕↕ | Meter No. ↕↕ | Tariff ↕↕ | Connected Load ↕↕ | Status ↕↕ |
|---|---|---|---|---|---|---|---|
| — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — |
G Group By
S Sort By
↕ Click column to sort
Ready to RunOracle Reports
5.2 HT Census Listing
Master Maintenance → Census → Listing HT
Report Parameters — BC_CENLSHT
Report Output Preview
Run report to see actual data
| Cons. No. ↕↕ | Customer Name ↕↕ | Service Address ↕↕ | Meter No. ↕↕ | CT Ratio ↕↕ | PT Ratio ↕↕ | Tariff ↕↕ | KVA Rating ↕↕ |
|---|---|---|---|---|---|---|---|
| — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — |
G Group By
S Sort By
↕ Click column to sort
Ready to RunOracle Reports
5.3 MRS Sheet LT (Regular)
Pre-Billing → MRS → Printing LT
Report Parameters — BC_MRSLT
Report Output Preview
Run report to see actual data
| Walk Order ↕↕ | Cons. No. ↕↕ | Consumer Name ↕↕ | Meter No. ↕↕ | Previous Reading ↕↕ | Current Reading ↕↕ | TOD ↕↕ | Time Cycle ↕↕ |
|---|---|---|---|---|---|---|---|
| — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — |
G Group By
S Sort By
↕ Click column to sort
Ready to RunOracle Reports
5.4 MRS Sheet HT (Regular)
Pre-Billing → MRS → Printing HT
Report Parameters — BC_MRSHT
Ready to RunOracle Reports
5.5 MRS Sheet HT Consumers
Pre-Billing → MRS → Printing-HT
Report Parameters — BC_HTMRSPT
Ready to RunOracle Reports
5.6 Exception Amendment Report LT
Pre-Billing → Exception Amendment Report → LT
Report Parameters — BC_EXCEPLT
Report Output Preview
Run report to see actual data
| Cons. No. ↕↕ | Consumer Name ↕↕ | Meter No. ↕↕ | Exception Type ↕↕ | Previous Reading ↕↕ | Current Reading ↕↕ | Remarks ↕↕ |
|---|---|---|---|---|---|---|
| — | — | — | — | — | — | — |
| — | — | — | — | — | — | — |
| — | — | — | — | — | — | — |
G Group By
S Sort By
↕ Click column to sort
Ready to RunOracle Reports
5.7 Exception Amendment Report HT
Pre-Billing → Exception Amendment Report → HT
Report Parameters — BC_EXCEPHT
Ready to RunOracle Reports
5.8 Snapshot Report — LT
Pre-Billing → Snapshot → LT
Report Parameters — BC_SNAPSLT
Report Output Preview
Run report to see actual data
| Cons. No. ↕↕ | Consumer Name ↕↕ | Tariff ↕↕ | Prev Reading ↕↕ | Curr Reading ↕↕ | Consumption ↕↕ | Billed Amount ↕↕ | Status ↕↕ |
|---|---|---|---|---|---|---|---|
| — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — |
G Group By
S Sort By
↕ Click column to sort
Ready to RunOracle Reports
5.9 Snapshot Report — HT
Pre-Billing → Snapshot → HT
Report Parameters — BC_SNAPSHT
Ready to RunOracle Reports
5.10 List of Defective Meters Having Valid Reading
Pre-Billing → Defective Meters
Report Parameters — BC_DFCTMTR
Ready to RunOracle Reports
5.11 List of Meter Readings Not Available — LT
Pre-Billing → No Readings → LT
Report Parameters — BC_NOREDLT
Ready to RunOracle Reports
5.12 Bill Printing — LT
Billing → Bill Printing → LT
Report Parameters — BC_BILLPRN
Report Output Preview
Run report to see actual data
| Bill No. ↕↕ | Cons. No. ↕↕ | Consumer Name ↕↕ | Address ↕↕ | Bill Cycle ↕↕ | Energy Charge ↕↕ | LPS ↕↕ | VAT ↕↕ | Total Due ↕↕ |
|---|---|---|---|---|---|---|---|---|
| — | — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — | — |
G Group By
S Sort By
↕ Click column to sort
Ready to RunOracle Reports
5.13 Bill Printing — HT/LTI
Billing → Bill Printing → HT
Report Parameters — BC_BILLPHT
Ready to RunOracle Reports
5.14 Bill Register — LT/LTI
Billing → Bill Register → LT
Report Parameters — BC_REGISLT
Report Output Preview
Run report to see actual data
| Cons. No. ↕↕ | Consumer Name ↕↕ | Meter No. ↕↕ | Bill No. ↕↕ | Reading ↕↕ | Consumption ↕↕ | Energy Charge ↕↕ | LPS ↕↕ | VAT ↕↕ | Total ↕↕ |
|---|---|---|---|---|---|---|---|---|---|
| — | — | — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — | — | — |
G Group By
S Sort By
↕ Click column to sort
Ready to RunOracle Reports
5.15 Bill Register — HT
Billing → Bill Register → HT
Report Parameters — BC_REGISHT
Report Output Preview
Run report to see actual data
| Cons. No. ↕↕ | Consumer Name ↕↕ | Meter No. ↕↕ | KWH ↕↕ | KVARH ↕↕ | KW ↕↕ | Energy ↕↕ | Demand Charge ↕↕ | LPS ↕↕ | Total ↕↕ |
|---|---|---|---|---|---|---|---|---|---|
| — | — | — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — | — | — |
G Group By
S Sort By
↕ Click column to sort
Ready to RunOracle Reports
5.16 List of Consumers with Outstanding Balance
Post-Billing → Outstanding Balance
Report Parameters — BC_OUTBALS
Ready to RunOracle Reports
5.18 Disconnection Notice Printing
Post-Billing → Disconnection Notice
Report Parameters — BC_DISCNOT
Ready to RunOracle Reports
5.19 DCS Mismatch Report
Post-Billing → DCS Mismatch
Report Parameters — BC_DCSMISC
Report Output Preview
Run report to see actual data
| Batch No. ↕↕ | Cons. No. ↕↕ | Consumer Name ↕↕ | Book No. ↕↕ | Op1 Amount ↕↕ | Op2 Amount ↕↕ | Difference ↕↕ | Status ↕↕ |
|---|---|---|---|---|---|---|---|
| — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — |
G Group By
S Sort By
↕ Click column to sort
Ready to RunOracle Reports
5.20 DCS Validation Report
Post-Billing → DCS Validation
Report Parameters — BC_DCSVALD
Ready to RunOracle Reports
5.21 Payment Offsetting Report
Post-Billing → Payment Offsetting
Report Parameters — BC_OFFREPT
Ready to RunOracle Reports
5.22 Valid Payment Listing
Post-Billing → Valid Payment
Report Parameters — BC_VALIDPAY
Report Output Preview
Run report to see actual data
| Receipt No. ↕↕ | Cons. No. ↕↕ | Consumer Name ↕↕ | Bill Cycle ↕↕ | Amount (Tk.) ↕↕ | VAT ↕↕ | Revenue Stamp ↕↕ | Net Amount ↕↕ | Payment Date ↕↕ |
|---|---|---|---|---|---|---|---|---|
| — | — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — | — |
G Group By
S Sort By
↕ Click column to sort
Ready to RunOracle Reports
5.24 DCS Batch Summary Report
Post-Billing → Batch Summary
Report Parameters — BC_BACHSUM
Ready to RunOracle Reports
5.38 List of Write-off Consumers
Miscellaneous → Write-off List
Report Parameters — BC_WROFLST
Ready to RunOracle Reports
5.44 List of New Consumers (HT)
Census → New Consumers HT
Report Parameters — BC_NCONSHT
Ready to RunOracle Reports
5.48 Accepted Master Amendment Report
Pre-Billing → Amendment Reports
Report Parameters — BC_MSTAMRP
Ready to RunOracle Reports
5.50 Accepted Reconnection Report
Pre-Billing → Reconnection Reports
Report Parameters — BC_RECNRPT
Ready to RunOracle Reports
5.52 Accepted Bill Correction Report
Pre-Billing → Bill Correction Reports
Report Parameters — BC_BILCRPT
Ready to RunOracle Reports
5.58 Adjustment Listing
Billing → Adjustment Reports
Report Parameters — BC_ADJLIST
Report Output Preview
Run report to see actual data
| Adj. No. ↕↕ | Cons. No. ↕↕ | Consumer Name ↕↕ | Tariff Type ↕↕ | Invoice Amount ↕↕ | Adjusted Amount ↕↕ | Reason ↕↕ | Date ↕↕ |
|---|---|---|---|---|---|---|---|
| — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — |
G Group By
S Sort By
↕ Click column to sort
Ready to RunOracle Reports
5.62 List of Cancelled Receipts
Post-Billing → Cancelled Receipts
Report Parameters — BC_PYCNLRP
Ready to RunOracle Reports
5.66 List of All Disputed Bills
Miscellaneous → Disputes
Report Parameters — BC_DISPREP
Report Output Preview
Run report to see actual data
| Dispute No. ↕↕ | Cons. No. ↕↕ | Consumer Name ↕↕ | Bill Cycle ↕↕ | Disputed Amount ↕↕ | Status ↕↕ | Inspector ↕↕ | Days Open ↕↕ |
|---|---|---|---|---|---|---|---|
| — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — |
G Group By
S Sort By
↕ Click column to sort
Ready to RunOracle Reports
5.73 Audit Trail for GL Posting
Miscellaneous → GL Interface
Report Parameters — BC_IPOSTGL
Ready to RunOracle Reports
5.75 Consumers From RDW — LT
Interface → RDW LT
Report Parameters — BC_IFRDWLT
Ready to RunOracle Reports
5.77 Age Analysis Report
Post-Billing → Age Analysis
Report Parameters — BC_AGEANAL
Report Output Preview
Run report to see actual data
| Cons. No. ↕↕ | Consumer Name ↕↕ | ↕↕ | 3-6 Months ↕↕ | 6-12 Months ↕↕ | > 12 Months ↕↕ | Total Outstanding ↕↕ |
|---|---|---|---|---|---|---|
| — | — | — | — | — | — | — |
| — | — | — | — | — | — | — |
| — | — | — | — | — | — | — |
G Group By
S Sort By
↕ Click column to sort
Ready to RunOracle Reports
5.81 List of Consumers With Zero Consumption
Billing → Zero Consumption
Report Parameters — BC_ZEROCNS
Ready to RunOracle Reports
5.82 List of Consumers With Minimum Consumption
Billing → Minimum Consumption
Report Parameters — BC_MINCNS
Ready to RunOracle Reports
5.90 Online Query — LT
Reports → Online Query LT
Report Parameters — BC_CONLGLT
Report Output Preview
Run report to see actual data
| Bill Cycle ↕↕ | Bill Date ↕↕ | Consumption ↕↕ | Energy Charge ↕↕ | LPS ↕↕ | VAT ↕↕ | Total Bill ↕↕ | Payment ↕↕ | Outstanding ↕↕ |
|---|---|---|---|---|---|---|---|---|
| — | — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — | — |
G Group By
S Sort By
↕ Click column to sort
Ready to RunOracle Reports
5.91 Online Query — HT
Reports → Online Query HT
Report Parameters — BC_CONLGHT
Ready to RunOracle Reports