The '.csv' Format
# Bill Type (N - Normal, W - Withdrawn or F -Final) |
Account Reference |
MPAN Core |
Invoice Reference |
Issue Date (YYYY-mm-dd HH:MM) |
Start Date (YYYY-mm-dd HH:MM) |
Finish Date (YYYY-mm-dd HH:MM) |
kWh |
Net |
VAT |
Gross |
Breakdown |
R1 Meter Serial Number |
R1 MPAN |
R1 Coefficient |
R1 Units (kWh, kW, kVA or kVArh) |
R1 TPR (Blank if kW or kVA) |
R1 Previous Read Date |
R1 Previous Read Value |
R1 Previous Read Type |
R1 Present Read Date |
R1 Present Read Value |
R1 Present Read Type |
The register read block of fields can be repeated for each
register, or can be left out entirely if the bill doesn't have
any readings associated with it.
Mapping Between Read Types
Chellow |
J0171
|
SSE EDI |
BGB EDI |
Haven CSV |
Haven EDI |
Code |
Description |
Code |
Description |
Code |
Description |
Code |
Description |
Code |
Description |
Code |
Description |
A |
Actual Change of Supplier Read |
A |
Actual Change of Supplier Read |
|
|
|
|
A |
Actual Read |
00 |
Actual Read |
C |
Customer |
C |
Customer own read |
04 |
Customer's Own Reading |
04 |
Customer's own reading |
C |
Customer's Own Read |
04 |
Customer's Own Read |
CP |
Computer |
|
|
05 |
Computer Reading |
|
|
|
|
|
|
D |
Deemed (Settlement Registers) or Estimated (Non-Settlement
Registers)
|
D |
Deemed (Settlement Registers) or Estimated (Non-Settlement
Registers)
|
|
|
|
|
D |
Deemed Read |
02 |
Deemed Read |
E |
Estimated |
|
|
02 |
Estimated (Computer) Reading |
02 |
Estimated (computer) |
E |
Estimated |
02 |
Estimated |
E3 |
Estimated 3rd Party |
|
|
11 |
Third Party Estimated (Computer) Reading |
|
|
|
|
|
|
EM |
Estimated Manual |
|
|
01 |
Estimated (manual) |
|
|
|
|
|
|
F |
Final |
F |
Final |
|
|
|
|
F |
Final Read |
03 |
Final Read |
H |
Data Collector Reading Queried By Supplier |
|
|
|
|
|
|
X |
Data Collector Reading Queried By Haven |
|
|
I |
Initial |
I |
Initial |
|
|
|
|
I |
Initial Read |
06 |
Initial Read |
IF |
Information |
|
|
12 |
Reading for Information only |
|
|
|
|
|
|
|
|
M |
MAR |
|
|
|
|
|
|
05 |
MAR |
N |
Normal |
R |
Routine |
00 |
Normal Reading |
00 |
Normal Reading - Default |
R |
Routine |
|
|
N3 |
Normal 3rd Party |
|
|
09 |
Third Party Normal Reading |
|
|
|
|
|
|
O |
Old Supplier's Estimated CoS Reading |
O |
Old Supplier's Estimated CoS Reading |
|
|
|
|
O |
Old Suppliers Estimated Change of Supplier Reading |
02 |
Old Suppliers Estimated Change of Supplier Reading |
|
|
P |
Electronically collected via PPMIP |
|
|
|
|
|
|
|
|
Q |
Meter Reading modified manually by DC |
Q |
Meter Reading modified manually by DC |
|
|
|
|
Q |
Reading Modified Manually by DC |
01 |
Reading Modified Manually by DC |
S |
Special |
S |
Special |
|
|
|
|
S |
Actual Read |
00 |
Actual Read |
|
|
T |
Proving Test Reading |
|
|
|
|
|
|
00 |
Proving Test Reading |
W |
Withdrawn |
W |
Withdrawn |
03 |
Removed meter reading |
|
|
|
|
|
|
X |
Exchange |
|
|
06 |
Exchange Meter Reading |
06 |
Exchange Meter Reading |
|
|
|
|
Z |
Actual Change of Tenancy Read |
Z |
Actual Change of Tenancy Read |
|
|
|
|
Z |
Actual Change of Tenancy Read |
04 |
Actual Change of Tenancy Read |