{% 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 Mpans 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 Code Chellow Description sse.edi Code sse.edi Description bgb.edi Code bgb.edi Description
N Normal 00 Normal Reading 00 Normal Reading - Default
N3 Normal 3rd Party 09 Third Party Normal Reading
C Customer 04 Customer's Own Reading 04 Customer's own reading
E Estimated 02 Estimated (Computer) Reading 02 Estimated (computer)
E3 Estimated 3rd Party 11 Third Party Estimated (Computer) Reading
EM Estimated Manual 01 Estimated (manual)
W Withdrawn 03 Removed meter reading
X Exchange 06 Exchange Meter Reading 06 Exchange Meter Reading
CP Computer 05 Computer Reading
IF Information 12 Reading for Information only
{% if importer_ids %}
    {% for id in importer_ids %}
  • {{id}}
  • {% endfor %}
{% endif %}
{% endblock %}