File Format Document
DNI_Exercise_&_Option_Invoice Supporting_Information (.EOI)
Transporter to System User
Copyright Xoserve 2014©, all rights reserved.
No part of this publication may be reproduced in any material form (including photocopying and restoring in any medium or electronic means and whether or not transiently or incidentally) without the written permission of Xoserve except in accordance with the provisions of the Copyright, Designs and Patents Act 1998.
Author: / XoserveOwner: / Xoserve
Version: / 23.1
Status: / For Approval
Date: / 07-Oct-2014
Version Control
Version / COR / Issue Date / Implementation Date / Summary of Change21 / Current Live version
3 / 1154 / 30-Sep-2014 / 01-Oct-2015 / File issued for representation
3.1 / 1154 / 07-Oct-2014 / 01-Oct-2015 / File issued for representation. The value for Invoice Type Code has been given in Q28 record
Contains8 different Record Types
Level / Record Name / Occurrence / Optionally
1 / HD_A00_STANDARD_HEADER / 1 / M
1 / RT_Q28_STANDARD_INVOICE_SUMMARY / Up to 2010 / M
2 / RT_Q29_STANDARD_CHARGE_TYPE_SUMMARY / Up to2060 / M
3 / RT_Q30_INTERRUPTION_OPTION_DETAIL / Up to 10000 / O
3 / RT_Q31_INTERRUPTION_EXERCISE_DETAIL / Up to 10000 / O
3 / RT_Q32_INTERRUPTION_OPTION_ADJUSTMENT_DETAIL / Up to 10000 / O
3 / RT_Q33_INTERRUPTION_EXERCISE_ADJUSTMENT_DETAIL / Up to 10000 / O
1 / TR_Z99_STANDARD_TRAILER / 1 / M
Note 1
OPT - Optional/Mandatory (O - Optional, M - Mandatory)
DOM - Domain (T - text, N - Numeric, D - Date (YYYYMMDD), M - Timestamp)
LNG - Number of characters
DEC - Number of decimal places
Note 2
All text fields will be enclosed in double quotes ("")
DNI_Exercise_&_Option_Invoice_
Supporting_Information(.EOI) Page 1 of 15 Submission Date: 07/10/2014
Version 3.1 For Approval Implementation Date: 01/10/2015
Record Type Definition
AI_O_DNI_EXERCISE_&_OPTION_INVOICE_SUPPORTING_INFORMATION
HD_A00_STANDARD_HEADER
RECORD/FIELD_NAME*Occurs Max 1* / OPT / DOM / LNG / DEC / DESCRIPTION
TRANSACTION_TYPE / M / T / 3 / 0 / DEFINITION: A code identifying the type of request that this record represents.
VALUE:A00
ORGANISATION_ID / M / N / 10 / 0 / DEFINITION: A reference which uniquely identifies a User/Organisation.
FILE_TYPE / M / T / 3 / 0 / DEFINITION: An application specific code used to identify the structure and the usage of the file.
VALUE:EOI
CREATION_DATE / M / D / 8 / 0 / DEFINITION: The date on which the file was generated.
FORMAT: YYYYMMDD
CREATION_TIME / M / M / 6 / 0 / DEFINITION: The time at which the file was generated (within the Creation Date).
FORMAT: HHMMSS
GENERATION_NUMBER / M / N / 6 / 0 / A sequence number which represents an issue of a file from the organisation (indicated by the organisation id), and, of the file type (indicated by file type)
DEFINITION: A sequence number which represents an issue of a file that is unique for a combination of System User and file type.
Files of the same file type submitted by a System User or to a System User must have consecutive numbers.
Total / 36
AI_O_DNI_EXERCISE_&_OPTION_INVOICE_SUPPORTING_INFORMATION
RT_Q28_STANDARD_INVOICE_SUMMARY
RECORD/FIELD_NAME*Occurs Max 10* / OPT / DOM / LNG / DEC / DESCRIPTION
TRANSACTION TYPE / M / T / 3 / 0 / DEFINITION: A code identifying the type of request that this record represents.
VALUE:Q28
SHIPPER_SHORT_CODE
ORGANISATION_SHORT_CODE / M / T / 3 / 0 / A unique three character code used to identify an organisation
DEFINITION: This field identifies the three character unique organisation short code.
INVOICE_TYPE_CODE / M / T / 3 / 0 / DEFINITION: A three character code used to identify the Invoice Type.
VALUE:ADNEOI
INVOICE_NUMBER / M / N / 612 / 0 / DEFINITION: Holds the unique number by which an Invoice is known.
ADHOC_REFERENCE_NUMBER / O / T / 10 / 0 / A unique reference assigned to
each Adhoc invoice issued
NWO_SHORT_CODE / M / T / 3 / 0 / DEFINITION: A unique three character code used to identify a Network Operator.
BILLING_MONTH / M / N / 2 / 0 / DEFINITION: The month of the billing period for which the Invoice relates, e.g. 01= January.
FORMAT:MM
BILLING_YEAR / M / N / 4 / 0 / DEFINITION: The year of the billing period for which the Invoice relates.
FORMAT:YYYY
INVOICE_AMOUNT_DUE
INVOICE_AMOUNT / M / N / 1214 / 2 / DEFINITION: Holds sum of invoice amount due for all invoice items on the invoice. The first character would be prefixed with a negative ‘-‘ if it is a payment to the system user. VALUE : Monetary values from -99999999999.99 to 99999999999.99
Total / 4644
AI_O_DNI_EXERCISE_&_OPTION_INVOICE_SUPPORTING_INFORMATION
RT_Q29_STANDARD_CHARGE_TYPE_SUMMARY
RECORD/FIELD_NAME*Occurs Max 60* / OPT / DOM / LNG / DEC / DESCRIPTION
TRANSACTION TYPE / M / T / 3 / 0 / DEFINITION: A code identifying the type of request that this record represents. VALUE:Q29
NWO_SHORT_CODE / M / T / 3 / 0 / DEFINITION: A unique three character code used to identify a Network Operator.
INVOICE_TYPE_CODE / M / T / 3 / 0 / DEFINITION: A three character code used to identify the Invoice Type.
VALUE:EOI
CHARGE_TYPE_CODE / M / T / 3 / 0 / DEFINITION: A unique three character code used to identify the charge type/s.
VALUE: N59, N60, N61, N62
Following is the charge description:
N59 – DN INTERRUPT OPTION FEE DR
N60 – DN INTERRUPT OPTION FEE CR
N61: DN INTERRUPT EXERCISE FEE DR
N62 – DN INTERRUPT EXERCISE FEE CR
CHARGE_TYPE_AMOUNT
CHARGE_AMOUNT / M / N / 1214 / 2 / DEFINITION: Holds the sum of the charges of a particular charge type. Negative values will have a prefix (-)
VALUE:Monetary values
-99999999999.99 to 99999999999.99
Total / 2426
AI_O_DNI_EXERCISE_&_OPTION_INVOICE_SUPPORTING_INFORMATION
RT_Q30_INTERRUPTION_OPTION_DETAIL
RECORD/FIELD_NAME*Occurs Max 10000* / OPT / DOM / LNG / DEC / DESCRIPTION
TRANSACTION_TYPE / M / T / 3 / 0 / DEFINITION: A code identifying the type of request that this record represents.
VALUE: Q30
CHARGE_TYPE_CODE / M / T / 3 / 0 /
A code to identify the type of charge.
VALUE:N60
Following is the charge description:
N60- DN INTERRUPT OPTION FEE CR
INTERRUPTION_OPTION_AMOUNT / M / N / 1214 / 2 / DEFINITION: Offered Tranche Capacity X Overall Tranche Rate X Number of days within month / 100. The first character would be prefixed with a negative '' if it is a payment to the user.
VALUE:Monetary values
0 to 99999999999.99
VALUE: Monetory values -99999999999.99 to 99999999999.99
CONFIRMATION_REFERENCE_NUMBER
SUPPLY_POINT_CONFIRMATION_REFERENCE / O / N T / 9 10 / 0 / A unique numeric reference associated to the supply point. This field is populated for UKLINK supply points
DEFINITION: A sequential number that uniquely identifies the Confirmation.
LOGICAL_METER_NUMBER / O / T / 10 / 0 / The Logical Meter Number that identifies the Site
BILLING_PERIOD_START_DATE
BILLING_START_DATE / M / D / 8 / 0 / Identifies the start date of
the billing period..
DEFINITION:First date in a billing period for which the invoice has been calculated.
FORMAT:YYYYMMDD
BILLING_PERIOD_END_DATE
BILLING_END_DATE / M / D / 8 / 0 / Identifies the end date of
the billing period.
DEFINITION: Last date in a billing period for which the invoice has been calculated.
FORMAT:YYYYMMDD
BILLING_PERIOD_NUMBER_OF_DAYS / M / N / 3 / 0 / DEFINITION: Number of days within the billing period.
SITE_NAME / O / T / 50 / 0 / Identifies the LDZ or NTS Site Name
DEFINITION: The name of the site associated to the Supply Meter Point(s)
INTERRUPTION_TRANCHE_NUMBER
TRANCHE_NUMBER
/ O / N / 2 / 0 / DEFINITION: The tranche number associated to the INTERRUPTION_BID_NUMBER
DEFINITION:This field identifies the tranche number
INTERRUPTION_BID_NUMBER / O / N / 5 / 0 / DEFINITION: The unique bid number.
LDZ_INDICATOR
LDZ_IDENTIFIER / M / T / 4 / 0 / DEFINITION: This field identifies the LDZ to which the supply meter point is associated.
OFFERED_TRANCHE_CAPACITY
OFFERED_TRANCHE_CAPACITY / M / N / 10 / 0 / The amount of Supply point Interruptible Tranche Capacity (kWh/Day) at the Supply point
DEFINITION:This field identifies the tranche capacity offered for interruption
INTERRUPTION_OPTION_RATE
INTERRUPTION_OPTION_PRICE / O / N / 107 / 4 / The rate (p/kWh/day) that
will be paid to the User for
the interruption option
DEFINITION:The amount specified as p/kWh/day that the DN operator is required to pay the user irrespective of physical interruption
Total / 137127
AI_O_DNI_EXERCISE_&_OPTION_INVOICE_SUPPORTING_INFORMATION
RT_Q31_INTERRUPTION_EXERCISE_DETAIL
RECORD/FIELD_NAME*Occurs Max 10000* / OPT / DOM / LNG / DEC / DESCRIPTION
TRANSACTION_TYPE / M / T / 3 / 0 / DEFINITION: A code identifying the type of information that this record contains.
VALUE: Q31
CHARGE_TYPE_CODE / M / T / 3 / 0 /
A code to identify the type of charge.
VALUE:N59 Following is the charge description:
N59-DN INTERRUPT OPTION FEE DR
INTERRUPTION_EXERCISE_AMOUNT / M / N / 1214 / 2 / DEFINITION: Offered Tranche Capacity X Interruption Exercise Rate X Days Interrupted Count / 100. The first character would be prefixed with a negative '-' if it is a payment to the user.
VALUE:Monetary values
0 to 99999999999.99
VALUE: Monetory values -99999999999.99 to 99999999999.99
CONFIRMATION_REFERENCE_NUMBER
SUPPLY_POINT_CONFIRMATION_REFERENCE / O / N / 910 / 0 / DEFINITION: A reference that uniquely identifies the Confirmation.
LOGICAL_METER_NUMBER / O / T / 10 / 0 /
The Logical Meter Number that identifies the Site.
SITE_NAME / O / T / 50 / 0 / Site name which contract refers
DEFINITION: The name of the site associated to the Supply Neter Point(s)
INTERRUPTION_TRANCHE_NUMBER
TRANCHE_NUMBER / O / N / 2 / 0 / DEFINITION: The tranche number associated to the INTERRUPTION_BID_NUMBER
This field identifies the tranche number
INTERRUPTION_BID_NUMBER / O / N / 5 / 0 / DEFINITION: The unique bid number
LDZ_INDICATOR
LDZ_INDENTIFIER / M / T / 4 / 0 / DEFINITION: This field identifies the LDZ to which the supply meter point is associated
OFFERED_TRANCHE_CAPACITY / M / N / 10 / 0 / DEFINITION: The amount of Supply Point Interruptible Tranche Capacity (kWh / Day) at the Supply Point
INTERRUPTION_EXERCISE_RATE
INTERRUPTION_EXERCISE_PRICE / M / N / 107 / 45 / DEFINITION: The amount specified as p/kWh/day that he DN Operator is required to pay the User irrespective of physical interruption
INTERRUPTION_START_DATE / M / D / 8 / 0 / DEFINITION: Date of the start of interruption
FORMAT: YYYYMMDD
INTERRUPTION_END_DATE / M / D / 8 / 0 / DEFINITION: Date of the end of interruption
FORMAT: YYYYMMDD
DAYS_INTERRUPTED_COUNT / M / N / 3 / 0 / DEFINITION: No of days interrupted
Total / 127
137
AI_O_DNI_EXERCISE_&_OPTION_INVOICE_SUPPORTING_INFORMATION
RT_Q32_INTERUPTION_EXERCISE_DETAIL
RECORD/FIELD_NAME*Occurs Max 10000* / OPT / DOM / LNG / DEC / DESCRIPTION
TRANSACTION_TYPE / M / T / 3 / 0 / DEFINITION: A code identifying the type of request that this record represents.
VALUE:Q32
CHARGE_TYPE_CODE / M / T / 3 / 0 /
A code to identify the type of charge.
VALUE:N62 Following is the charge description:
N62- DN INTERRUPT EXERCISE FEE CR
INTERRUPTION_OPTION_AMOUNT / M / N / 14 / 2 / DEFINITION: Offered Tranche Capacity X Overall Tranche Rate X Number of days within Option Adjustment / 100. The first character would be prefixed with a negative '-' if it is a payment to the user.
VALUE:Monetary values
0 to 99999999999.99
VALUE: Monetory values -99999999999.99 to 99999999999.99
CONFIRMATION_REFERENCE_NUMBER
SUPPLY_POINT_CONFIRMATION_REFERENCE / O / N / 910 / 0 / A unique numeric reference
associated to the supply
point. This field is populated
for UKLINK supply points
DEFINITION: A reference that uniquely identifies the Confrmation
LOGICAL_METER_NUMBER / O / T / 10 / 0 / The logical meter number that identifies the site
BILLING_PERIOD_ADJ_START_ DATE / M / D / 8 / 0 / DEFINITION: Identifies the start date of the billing adjustment period
FORMAT: YYYYMMDD
BILLING_PERIOD_ADJ _END_DATE / M / D / 8 / 0 / DEFINITION: Identifies the end date of the billing adjustment period
FORMAT: YYYYMMDD
BILLING_PERIOD_ADJ _NO_OF_DAYS / M / N / 3 / 0 / DEFINITION: Number of days for adjustment.
SITE_NAME / O / T / 50 / 0 / Site name which contract refers.
DEFINITION: The name of the site associated to the Supply Meter Point (s)
INTERRUPTION_TRANCHE_NUMBER
TRANCHE_NUMBER / O / N / 2 / 0 / The tranche number
associated to the
INTERRUPTION BID
NUMBER
This Field identifies the tranche number.
INTERRUPTION_BID_NUMBER / O / N / 5 / 0 / DEFINITION: The unique bid number.
LDZ_INDICATOR
LDZ_IDENTIFIER / M / T / 4 / 0 / DEFINITION: This field identifies the LDZ to which the supply meter point is associated.
OFFERED_TRANCHE_CAPACITY / M / N / 10 / 0 / The amount of Supply Point
Interruptible Tranche
Capacity (kWh / Day) at the
Supply Point
DEFENITION: This field identifies the tranche capacity offered for interruption
INTERRUPTION_OPTION_RATE
INTERRUPTION_OPTION_PRICE / M / N / 107 / 45 / The rate (p/kWh/day) that will be paid to the user for the interruption option
DEFINITION: The amount specified as p/kWh/day that the DN Operatior is required to pay the User irrespective of physical interruption.
ADJUSTMENT_CODE / O / T / 10 / 0 / DEFINITION: Reason code for adjustment allowable fields 1-6.
ADJUSTMENT_COMMENTS / O / T / 200 / 0 / DEFINITION: Comments in relation to the adjustment.
Total / 337
347
AI_DNI_EXERCISE_&_OPTION_INVOICE_SUPPORTING_INFORMATION
RT_Q33_INTERUPTION_ADJUSTMENT_DETAIL
RECORD/FIELD_NAME*Occurs Max 10000* / OPT / DOM / LNG / DEC / DESCRIPTION
TRANSACTION_TYPE / M / T / 3 / 0 / DEFINITION: A code identifying the type of information that this record contains.
VALUE: Q33
CHARGE_TYPE_CODE / M / T / 3 / 0 /
A code to identify the type of charge.
VALUE:N61 Following is the charge description: N61-DN INTERRUPT EXERCISE FEE DR
INTERRUPTION_EXERCISE_AMOUNT / M / N / 1214 / 2 / DEFINITION: Offered Tranche Capacity X Interruption Exercise Rate X Number of days within Exercise Adjustment / 100. The first character would be prefixed with a negative '-' if it is a payment to the user.
VALUE:Monetary values
0 to 99999999999.99
VALUE: Monetory values -99999999999.99 to 99999999999.99
CONFIRMATION_REFERENCE_NUMBER
SUPPLY_POINT_CONFIRMATION_REFERENCE / O / N / 910 / 0 / A unique numeric reference
associated to the supply
point. This field is populated
for UKLINK supply points
DEFINITION: A reference that uniquely identifies the Confrmation
LOGICAL_METER_NUMBER / O / T / 10 / 0 / The logical meter number that identifies the site
SITE_NAME / O / T / 50 / 0 / Site name which contract refers.
DEFINITION: The name of the site associated to the Supply Meter Point (s)
TRANCHE_NUMBER / O / N / 2 / 0 / DEFINITION: This field identifies the tranche number
INTERRUPTION_BID_NUMBER / O / N / 5 / 0 / DEFINITION: The unique bid number
LDZ_INDICATOR
LDZ_IDENTIFIER / M / T / 4 / 0 / DEFINITION: This field identifies the LDZ to which the supply meter point is associated
OFFERED_TRANCHE_CAPACITY / M / N / 10 / 0 / The amount of Supply Point
Interruptible Tranche
Capacity (kWh / Day) at the
Supply Point
DEFENITION: This field identifies the tranche capacity offered for interruption
INTERRUPTION_EXERCISE_RATE / O / N / 10 / 4 / DEFINITION: The rate, (in p/kWh/day) that will be paid to the User for each day of interruption that occurs within the period
INTERRUPTION_ADJ_START_DATE
INTERRUPTION_START_DATE / M / D / 8 / 0 / DEFINITION: Date of the start of interruption adjustment.
FORMAT: YYYYMMDD
INTERRUPTION_ADJ_END_DATE
INTERRUPTION_END_DATE / M / D / 8 / 0 / DEFINITION: Date of the end of interruption adjustment.
FORMAT: YYYYMMDD
DAYS_INTERRUPTED_ADJ_COUNT / M / N / 3 / 0 / DEFINITION: No of days interrupted for adjustment
ADJUSTMENT_CODE / O / T / 10 / 0 / DEFINITION: Reason code for adjustment allowable fields 1-6
ADJUSTMENT_COMMENTS / O / T / 200 / 0 / DEFINITION: Comments in relation to the adjustment
Total / 340
350
AI_DNI_EXERCISE_&_OPTION_INVOICE_SUPPORTING_INFORMATION
TR_Z99_STANDARD_TRAILER
RECORD/FIELD_NAME*Occurs Max 1* / OPT / DOM / LNG / DEC / DESCRIPTION
TRANSACTION_TYPE / M / T / 3 / 0 / DEFINITION: A code identifying the type of request that this record represents
VALUE:Z99
RECORD_COUNT / M / N / 10 / 0 / DEFINITION: The number of detail records contained within the file. This should not include the Standard Header (A00) and Standard Trailer (Z99) but should include any file specific Headers and Trailers specified for this file type.
Total / 13
Total Length: 1087 1050
DNI_Exercise_&_Option_Invoice_
Supporting_Information(.EOI) Page 1 of 15 Submission Date: 07/10/2014
Version 3.1 For Approval Implementation Date: 01/10/2015