{% extends "base.html" %} {% block title %} » Supplier Contracts » {{batch.contract.name}} » Batches » {{batch.reference}} » Bill Imports {% endblock %} {% block nav %} Supplier Contracts » {{batch.contract.name}} » Batches » {{batch.reference}} » Bill Imports {% endblock %} {% block content %}
Import Bill File

Valid file name extensions are {{parser_names}}.

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 Chellow, sse.edi and bgb.edi 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
{% if importer_ids %} {% endif %} {% endblock %}