File Format Document
Core_Amendments_Inv_Supporting_Information (.ASP)
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: / 1.4
Status: / Approved
Date: / 28-Aug-2015
Contains14different Record Types
Level / Record Name / Occurrence / Optionality
1 / HD_A00_STANDARD_HEADER / 1 / M
1 / RT_Q28_STANDARD_INVOICE_SUMMARY / Up to 10 / M
2 /
RT_K42_STANDARD_CORE_INVOICE_ITEM_SUMMARY
/ Up to 60 / M3 / RT_K88_RECONCILIATION_INVOICE_CHARGE_CLASS_4_LSP / As per portfolio requirements / O
3 / RT_K89_RECONCILIATION_INVOICE_CHARGE_CLASS_1_2_ AND_CLASS_ 3_LSP / As per portfolio requirements / O
4 / RT_J42_ DAILY_SUMMARY_NTS_OPTIONAL_TARIFF / Up to 1000200000 / O
3 / RT_K90_RECONCILIATION_INV_AGGREGATE_DETAIL_CLASS_3_4_SSP / Up to 2500,000 / O
3 / RT_J13_REC_INV_RBD_CHARGE / Up to 40,000 / O
4 / RT_J14_REC_INV_RBD_LDZ_AGGREGATE / Up to 1000 / O
4 / RT_J15_REC_INV_RBD_SPG_DETAIL / Up to 1000 / O
3 / RT_K91_RECONCILIATION_INVOICE_UG_SMEAR / Up to 40,000900000 / O
3 / RT_K84_CAPACITY_RECONCILIATION_CHARGE / Up to 200040000 / O
3 / RT_K93_AMENDMENT_SMP_DETAIL / Up to 2,000,000 / 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 ("")
Core_Amendments_Inv_Supporting_Information (.ASP) Page 1 of 51Issue Date: 28/08/2015
Version 1.4 Approved Implementation Date: 01/10/2016
Version Control
Version / COR / Issue Date / Implementation Date / Summary of Change1.0FA / 1154 / 14-Oct-2014 / 01-Oct-2015 / Preliminary file issued for representation
1A / 1154 / 12-Dec-2014 / 01-Oct-2015 / Approved
1.1FA / 1154 / 09-06-2015 / TBC / K42 additional charge types & details added
In K88, the charge type codes, 895 and 83A have been added
K89 additional charge types and details added.
K93 additional charge types and details added.
K88 & K93 description updated for the fields FORMULA_PERIOD_SMP_AQ and FORMULA_PERIOD_SMP_SOQ. Renamed these fields to FORMULA_YEAR_SMP_AQ and FORMULA_YEAR_SMP_SOQ respectively
K90-Field name changed from RECONCILIATION_CHARGE_COMPONENTto RECONCILIATION_CHARGE_AMOUNT
J13 Context has been added to RBD_Reconciliation_Quantity.
K91 Context has been added to UIG_Reconciliation_Quantity.
1.2FA / 1154 / 03-07-2015 / TBC /
- Amended the description of K90 record at record description table
- Amended the Issue Date to 03/07/2015
- Amended the occurance of J42, K90, K91, K84 records in record level table
- Amended the occurance of K90, J13, J14, J15, K91 records at record level description
1.3FA / 1154 / 07-08-2015 / TBC / Q28 Record:
- Amended the value of INVOICE_AMOUNT
- Amended the Value of CHARGE_AMOUNT
- Amended the Value of RECONCILIATION_CHARGE_COMPONENT field
- Amended the definition and the value of METER_ROUND_THE_CLOCK field
- Amended the length, decimal and the definition of TOTAL_ACTUAL_VOLUME field
- Amended the length, decimal and the definition of TOTAL_DEEMED_VOLUME
- Amended the length, decimal and the definition of RECONCILIATION_FACTOR
- Amended the definition of RECONCILIATION_VARIANCE_TOTAL_DEEMED_ALLOC_VOLUME
- Amended the definition of RECONCILIATION_VARIANCE_TOTAL_DEEMED_ALLOC_ENERGY
- Amended the definition of RECONCILIATION_VARIANCE_ACTUAL_ENERGY
- Amended the definition of TOTAL_ACTUAL_ENERGY
- Amended the definition of SUB_ENERGY
- Amended the length, decimal and the definition of UNMETERED_CONSUMPTION
- Amended the definition of CONVERTER_ROUND_THE_CLOCK
- Amended the definition of RECONCILIATION_VARIANCE_QUANTITY
- Amended the Value of PREVAILING_RECONCILIATION_CHARGE_ COMPONENT
- Amended the Value of NEW_RECONCILIATION_CHARGE_ COMPONENT
- Amended the total of K88 record
- Amended the definition of CHARGE_RATE
- Amended the value of RECONCILIATION_CHARGE_COMPONENT
- Amended the definitionof PREVAILING_ENERGY
- Amended the definitionof REVISED_ENERGY
- Amended the definition of ENERGY_VARIANCE
- Amended the definitionof SUB_ENERGY
- Amended the definition of PREVAILING_ENERGY
- Amended the definition of REVISED_ENERGY
- Amended the definition of NTS_ENERGY_VARIANCE
- Amended the definitionof BILLED_ELIGIBLE_QUANTITY
- Amended the definitionof BILLED_STANDARD_QUANTITY
- Amended the definition of REVISED_ELIGIBLE_QUANTITY
- Amended the definition of REVISED_STANDARD_QUANTITY
- Amended the definition of ENERGY_QUANTITY_VARIANCE
- Amended the definition of STANDARD_QUANTITY_VARIANCE
- Amended the definition of NTS_OPTIONAL_COMM_RATE
- Amended the definition of NTS_RATE_COMBINED
- Amended the definition of NTS_TO_RATE
- Amended the definition of NTS_SO_RATE
- Amended the value of NRE_CHARGE_AMOUNT
- Amended the value of NTS_TO_CHARGE_AMOUNT
- Amended the value of NTS_SO_CHARGE_AMOUNT
- Amended the value of SRE_CHARGE_AMOUNT
- Amended the value of SAP_CHARGE_AMOUNT
- Amended the value of ZRE_CHARGE_AMOUNT
- Amended the value of TOTAL_CHARGE_AMOUNT
- Amended the definitionof CHARGE_RATE
- Amended the value of RECONCILIATION_CHARGE_AMOUNT
- Amended the value of RBD_AMOUNT
- Amended the definition of RECONCILIATION_QUANTITY
- Amended the value of RECONCILIATION_VALUE
- Amended the value of UIG_AMOUNT
- Amended the value of CHARGE_AMOUNT
- Amended the value of TOTAL_CHARGE_AMOUNT
- Amended the definitionand value of METER_ROUND_THE_CLOCK
- Amended the definition of PREVAILING_ENERGY
- Amended the definition of REVISED_ENERGY
- Amended the description of ADJUSTED_ENERGY
- Amended the value of PREVAILING_CHARGE_COMPONENT
- Amended the value of NEW_CHARGE_COMPONENT
- Amended the value of ADJUSTED_CHARGE_COMPONENT
1.4FA / 1154 / 21-08-2015 / Project Nexus Implementation Date /
- In K89 Record heading/title amended. Same change has been done in the record hierarchy table as well.
- In K93 record, field name for FORMULA_PERIOD_SMP_AQ and FORMULA_PERIOD_SMP_SOQ amended to FORMULA_YEAR_SMP_AQ and FORMULA_YEAR_SMP_SOQ respectively
1.4A / 1154 / 28-Aug-2015 / Project Nexus Implementation Date /
- Approved
Record Type Definition
AI_O_CORE_AMENDMENTS_INV_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: ASP
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 / 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_CORE_AMENDMENTS_INV_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 / DEFINITION: This field identifies the three character unique organisation short code
A unique three character code used to identify an organisation
CONTEXT: This is the Shipper Short Code
INVOICE_TYPE_CODE / M / T / 3 / 0 / DEFINITION: A three character code used to identify the Invoice Type.
VALUE: AMS
INVOICE_NUMBER / M / N / 126 / 0 / DEFINITION: Holds the unique number by which an Invoice is known.
ADHOC_REFERENCE_NUMBER / O / T / 10 / 0 / A unique reference number 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. 1 – 9 = January – September and 10 – 12 = October - December01= January.
FORMAT:MM
BILLING_YEAR / M / N / 4 / 0 / DEFINITION: This attribute holds the year to which the invoice relates. Combined with BILLING MONTH will give billing period which the invoice coversThe year of the billing period for which the Invoice relates.
FORMAT:YYYY
INVOICE_AMOUNT_DUE
INVOICE_AMOUNT / M / N / 12
14 / 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 999999999999.99
Total / 4644
AI_O_CORE_AMENDMENTS_INV_SUPPORTING_INFORMATION
RT_K42_STANDARD_CORE_INVOICE_ITEM_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:K42
INVOICE_NUMBER / M / N / 12 / 0 / DEFINITION: Holds the unique number by which an Invoice is known.
INVOICE_ITEM_REFERENCE_NUMBER / M / N / 16 / 0 / A unique reference number used to identify the invoice item associated to the invoice
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: AMS
CHARGE_TYPE_CODE / M / T / 3 / 0 / DEFINITION: A unique three character code used to identify the charge type/s.
VALUE:
ZRE, GRE, NRE, RBG, RBN, RBZ, RCG, RCN, RCZ, ACY, AUY, AUT, ACT, AUS, ACS, AUN, ACN, NRT, NRS, CRC, CRA, UGR, 705, 915, 916, 917, 918, 922, 926, S15, S16, S17, S18, S22, S26, AMC, AUA, AMZ, ACZ, AUZ, AMF, AME, ACE, AUE, SRD, ZRD, SCD, 88A,882, 895, 83A, 84A
ZRE – LDZ COMMODITY RECONCILIATION
GRE – GAS VARIABLE RECONCILIATION
NRE – NTS EXIT COMM RECONCILIATION
RBG – RBD GAS RECONCILIATION ENERGY
RBN – RBD NTS EXIT COMMODITY RECONCILIATION CHARGES
RBZ – RBD LDZ COMMODITY RECONCILIATION CHARGE
RCG – RBD CSEP GAS RECONCILIATION ENERGY
RCN – RBD CSEP NTS EXIT COMMODITY RECONCILIATION CHARGES
RCZ – RBD CSEP LDZ COMMODITY RECONCILIATION CHARGES
ACY – CSEPS – LDZ COMMODITY RECONCILIATION
AUY – UNIQUE – LDZ RECONCILIATION
AUT – UNIQUE – NTS TO EXIT COMMODITY RECONCILIATION CHARGE
ACT – CSEPS – NTS TO EXIT COMMODITY RECONCILIATION CHARGE
AUS – UNIQUE – NTS SO EXIT COMMODITY RECONCILIATION CHARGE
ACS – CSEPS – NTS SO EXIT COMMODITY RECONCILIATION CHARGE
AUN – UNIQUE – NTS EXIT COMMODITY RECONCILIATION
ACN – CSEP – NTS EXIT COMMODITY RECONCILIATION
NRT – NTS TO EXIT COMMODITY RECONCILIATION CHARGE
NRS – NTS SO EXIT COMMODITY RECONCILIATION CHARGE
CRC – CAPACITY RECONCILIATION CHARGE
CRA – CAPACITY RECONCILIATION CHARGE ADJ
UGR – UNIDENTIFIED GAS RECONCILIATION ENERGY
705 – NTS OPTIONAL COMMODITY RECONCILIATION
915 – CSEP AGG REC NTS TRANS CHARGE ADJ
916 – CSEP AGG REC LDZ RANS CHARGE ADJ
917 – USER AGG REC NTS TRANS CHARGE ADJ
918 – USER AGG REC LDZ TRANS CHARGE ADJ
922 – USER AGG REC CLEARING VALUE
926 – CSEP AGG REC CLEARING VALUE
S15 – CSEP AGG REC NTS TRANS CHG ANN SHR ADJ
S16 – CSEP AGG REC LDZ TRANS CHG ANN SHR ADJ
S17 – USER AGG REC NTS TRANS CHG ANN SHR ADJ
S18 – USER AGG REC LDZ TRANS CHG ANN SHR ADJ
S22 – USER AGG REC CLEARING VALUE ANN SHR
S26 – CSEP AGG REC CLEARING VALUE ANN SHR
AMC – CUSTOMER CAPACITY CHARGE ADJ
AUA – UNIQUE – CUST CAPACITY CHARGE ADJ
AMZ – SUPPLY POINT CAPACITY CHARGE ADJ
ACZ – CSEPS – LDZ CAPACITY CHARGE ADJ
AUZ – UNIQUE – LDZ CAPACITY CHARGE ADJ
AMF – CUSTOMER FIXED CHARGE ADJ
AME – EXIT CAPACITY LDZ ECN CHARGE ADJ
ACE – UNIQUE - EXIT CAPACITY LDZ ECN CHARGE ADJ
AUE – UNIQUE - EXIT CAPACITY LDZ ECN CHARGE ADJ
SRD – SOQ RATCHET CHARGE ADJ
ZRD – CUSTOMER RATCHET ADJ
SCD – SEASONAL CAPACITY FAILURE CHARGE ADJ
88A-Unique NTS Commodity Shorthaul ADJ
882-LDZ Optional Tariff Adj
895-CSEPs Administration charges ADJ
83A-Administration charge LDZ ADJ
84A-Administration charge NTS ADJ
CHARGE_AMOUNT / M / N / 14 / 2 / DEFINITION: Holds the sum of the charges of a particular charge type. The first character would be prefixed with a negative '-' if it is a payment to the system user
Holds the charge values for a particular charge type. The first character would be prefixed with (-) if it is a negative amount.
VALUE: Monetary values from -99999999999.99 to 999999999999.99
Total / 54
AI_O_CORE_AMENDMENTS_INV_SUPPORTING_INFORMATION
RT_K88_RECONCILIATION_INVOICE_CHARGE_CLASS_4_LSP
RECORD/FIELD_NAME*Occurs Max As per portfolio requirements / OPT / DOM / LNG / DEC / DESCRIPTION
TRANSACTION_TYPE / M / T / 3 / 0 / DEFINITION: A code identifying the type of request that this record represents.
VALUE : K88
SUPPLIER_SHORT_CODE / M / T / 3 / 0 / DEFINITION: Supplier code for the supply meter point
NWO_SHORT_CODE / M / T / 3 / 0 / DEFINITION: A unique three character code used to identify a Network Operator.
INVOICE_NUMBER / M / N / 12 / 0 / DEFINITION: Holds the unique Invoice number to identify the invoice number corresponding to the charge details.
SUPPLY_POINT_CONFIRMATION_REFERENCE / M / T / 10 / 0 / DEFINITION: A reference that that uniquely identifies the Confirmation
LDZ_IDENTIFIER / M / T / 4 / 0 / DEFINITION: This field identifies the LDZ to which the supply meter point is associated.
CHARGE_ITEM_REFERENCE_NUMBER / M / N / 16 / 0 / DEFINITION: A unique reference number used to identify the charge item associated to the charge type code within the invoice
SUPPLY_METER_POINT
METER_POINT_REFERENCE / M / NT / 10 / 0 / DEFINITION: A unique identifier for the point at which a meter is, has been or will be connected to the gas network. These references are less volatile than meter or service identifiers and do not change if the meter is replaced or the service is relayed to the same position. New Supply Meter Point References will only be created for new services or when a service is relayed to a different position.
CLASS_TYPE / M / N / 1 / 0 / DEFINITION: A unique reference for the Class type to which the SMP belongs to.
VALUE:
4 - Class 4
CSEP_ID / OM / T / 8 / 0 / DEFINITION: The Unique Identifier for the Connected System Exit Point.
CMS_REFERENCE_NUMBER / O / N / 10 / 0 / DEFINITION: The reference number for the associated CMS contact
RECONCILIATION_START_DATE / M / D / 8 / 0 / DEFINITION: Defines the start date of the reconciliation period FORMAT:YYYYMMDD
RECONCILIATION_END_DATE / M / D / 8 / 0 / DEFINITION: Defines the end date of the reconciliation period.
FORMAT:YYYMMDD
METER_SERIAL_NUMBER / O / T / 14 / 0 / DEFINITION: The manufacturers meter serial number.
CONTEXT: The serial number of the meter from which the meter read was taken.
ORIGINAL_INVOICE_NUMBER / O / N / 12 / 0 / DEFINITION: For anadjustment, reconciliation and re-reconciliation, the invoice number from the prevailing charges
CHARGE_TYPE_CODE / M / T / 3 / 0 / DEFINITION: A unique three character code used to identify the charge type/s.
VALUE:
ZRE, GRE, NRE, ACT, ACS, ACN, NRT, NRS,ACY,895,83A
ZRE – LDZ COMMODITY RECONCILIATION
GRE – GAS VARIABLE RECONCILIATION
NRE – NTS EXIT COMM RECONCILIATION
ACT – CSEPS – NTS TO EXIT RECONCILIATION COMMODITY CHARGE
ACS – CSEPS – NTS SO EXIT RECONCILIATION COMMODITY CHARGE
ACN – CSEP – NTS EXIT COMMODITY RECONCILIATION
NRT – NTS TO EXIT COMMODITY RECONCILIATION CHARGE
NRS – NTS SO EXIT COMMODITY RECONCILIATION CHARGE
ACY – CSEPS – LDZ COMMODITY RECONCILIATION
895-CSEPs Administration charges LDZ ADJ
83A-Administration charge LDZ ADJ
CHARGE_RATE / M / N / 10 / 4 / DEFINITION: The rate in pence which was used to calculate the charge.
RECONCILIATION_CHARGE_COMPONENT / M / N / 18 / 7 / DEFINITION: Holds the charge value for an individual Meter Point Reference SMP for a particular charge type calculated during the reconciliation variance Period. 'The first character would be prefixed with a negative '-' if it is a payment to the system user
VALUE: Monetary value from -9999999999.9999999 to 99999999999.9999999
START_METER_READ_DATE / O / D / 8 / 0 / DEFINITION: Previous Meter or corrector Converter Reading Date for start of rec period
FORMAT: YYYYMMDD
END_METER_READ_DATE / O / D / 8 / 0 / DEFINITION: Previous Meter or corrector Converter Reading Date for end of rec period
FORMAT: YYYYMMDD
START_METER_READING / O / T / 12 / 0 / DEFINITION: Meter reading applicable for the reconciliation start date
END_METER_READING / O / T / 12 / 0 / DEFINITION: Meter reading applicable for the reconciliation end date
METER_TTZ_COUNT
METER_ROUND_THE_CLOCK / MO / T / 2 / 0 / DEFINITION: Represents the number of times the meter or corrector converter measuring consumption has gone through the zeroes between the start and end readings of the relevant metered period.
Number of times the meter has gone round the clock between the start and end readings of the relevant metered period. i.e. through the zero’s. . The first character would be prefixed with a '-' sign for negative value
Values: Blank,-9 to 99
TOTAL_ACTUAL_VOLUME / M / N / 13 31 / 015 / DEFINITION: Difference between prevailing and latest meter reading multiplied by read units and then by correction factor and then (where appropriate) converted to Cubic Metres. The first character would be prefixed with a '-' sign for negative valueor zero if zero reconciliation for SMP never consumed or rec period has not used energy.
TOTAL_DEEMED_VOLUME / M / N / 13 31 / 015 / DEFINITION: Total deemed volume for the reconciliation period. The first character would be prefixed with a '-' sign for negative value
RECONCILIATION_FACTOR / M / N / 12 31 / 615 / DEFINITION: The Reconciliation Factor is the ratio of actual to the allocated volume for the reconciliation period. The first character would be prefixed with a '-' sign for negative value
RECONCILIATION_VARIANCE_START_DATE / M / D / 8 / 0 / DEFINITION: The start date of a period when all the supporting information in the reconciliation variance table has remained constant. Start date must be within a reconciliation period
FORMAT: YYYYMMDD
RECONCILIATION_VARIANCE_END_DATE / M / D / 8 / 0 / DEFINTION: The end date of a period when all the supporting information in the reconciliation variance table has remained constant. End date must be within a reconciliation period
FORMAT: YYYYMMDD
RECONCILIATION_VARIANCE_TOTAL_
DEEMED_ALLOC_VOLUME / M / N / 1331 / 150 / DEFINITION: Contains the total deemed allocated volume calculated for the period of the reconciliation variance. The first character would be prefixed with a '-' sign for negative value
UNIT: Cubic Meters
RECONCILIATION_VARIANCE_TOTAL_
DEEMED_ALLOC_ENERGY / M / N / 31 / 15 / DEFINITION: Contains the total deemed allocated energy calculated for the period of the reconciliation variance. The first character would be prefixed with a '-' sign for negative value
UNIT: kWh
RECONCILIATION_VARIANCE _ACTUAL_ENERGY / M / N / 31 / 15 / DEFINITION: The allocated energy at variance level is calculated across the variance start and end period dates using the energy factor. From this the Actual Energy is derived. The first character would be prefixed with a '-' sign for negative value
TOTAL_ACTUAL_ENERGY / M / N / 31 / 15 / DEFINITION: Derived by multiplying Allocated Energy by the Reconciliation Factor for the reconciliation period (Rec factor = Ratio of actual: allocated volume). . The first character would be prefixed with a '-' sign for negative value UNIT: kWh.
SUB_ENERGY / O / N / 31 / 15 / DEFINITION: The energy (in
kWh) used by the subs in case of P&S setup for the relevant variance period. The first character would be prefixed with a '-' sign for negative value
UNMETERED_CONSUMPTION / M-O / N / 12 31 / 015 / DEFINITION: Identifies any unregistered gas consumption . The first character would be prefixed with a '-' sign for negative value
UNIT: Cubic Metres
START_READ_REASON / O / T / 4 / 0 / DEFINITION: Holds the reason code for the reading that started the reconciliation period
END_READ_REASON / O / T / 4 / 0 / DEFINITION: Holds the reason code for the reading that ended the reconciliation period
VARIANCE_REASON_CODE / O / T / 3 / 0 / DEFINITION: A code identifying the reason a reconciliation variance was created.
RECONCILIATION_VARIANCE_EUC_NUMBER / M / N / 10 / 0 / DEFINITION: A unique number used to identify the End user Category
CONTEXT: The EUC number for the Supply Meter Point for the variance period.
CURRENT_CHARGE_INDICATOR / M / T / 2 / 0 / DEFINITION: Identifies the charge category which indicates whether the charge is related to the current billing month or released from a previous billing month
VALUES:
'CU' = Current Charge i.e. the charge has been created and invoiced in the current billing month.
'RS' = Released after being previously suppressed i.e. a charge was created prior to this billing period, but released for invoicing within current billing period, but invoiced in, the current billing period.
METER_MODEL_NAME / O / T / 10 / 0 / DEFINITION: The model description for the meter (e.g. "U6", "U16", "102M12" or "G2500").
CORRECTORCONVERTER_MODEL_NAME / O / T / 10 / 0 / DEFINITION: The model description for the corrector converter if fitted (e.g. “INSCOR2, “2C2102”).
METER_MODEL_NUMBER_OF_DIALS / O / N / 2 / 0 / DEFINITION: Number of dials or digits on the meter which are considered during meter reading.
CORRECTORCONVERTER_MODEL_NUMBER_OF_DIALS / O / N / 2 / 0 / DEFINITION: Number of dials or digits on the corrector converter which are considered during corrector converter reading.
SMP_CORRECTION_FACTOR / O / N / 9 / 6 / DEFINITION: This is the Supply Meter Point correction factor
CORRECTORCONVERTER_CORRECTION_FACTOR / O / N / 9 / 6 / DEFINITION: This is a fixed factor where noconvertercorrectoris fitted and the meter reading needs to be corrected for Pressure/altitude/temperature.
FORMAT: 999.999999
DEFAULT: 1.0
METER_MODEL_READING_FACTOR / O / N / 6 / 3 / DEFINITION: Multiply meter readings by this figure to
give readings in 100's cubic feet.
CORRECTORCONVERTER_READING_FACTOR / O / N / 6 / 3 / DEFINITION: Multiply convertercorrector readings by this figure to give readings in 100's cubic feet.
METER_INDICATOR / M / T / 1 / 0 / DEFINITION: Indicates whether the meter measures the volume of gas in imperial or metric units.
VALUES: I - Imperial, M – Metric. U – Unknown. When there is no meter present, the field will be set to U.
RECONCILIATION_VARIANCE_SMP_AQ / M / N / 15 / 0 / DEFINITION: The annual offtake quantity of a Supply Meter Point for the reconciliation variance period
RECONCILIATION_VARIANCE_SMP_SOQ / M / N / 10 / 0 / DEFINITION: This field identifies the Supply Offtake Quantity (SOQ) of the meter point for the variance period. Unit – kWh
FORMULA_YEARPERIOD_ SMP_ AQ / M / N / 15 / 0 / DEFINITION: The AQ of the Supply Meter Point that is fixed throughout the formula year for the determination of transportation rates for Class 3 and Class 4 for directly connected sites only.
CONTEXT: For CSEP SMPs this must be CSEP Max AQ for the determination of transportation rates.
FORMULA_YEARPERIOD_SMP_SOQ / M / N / 10 / 0 / DEFINITION: The SOQ of the Supply Meter Point that is fixed throughout the formula year for determination of transportation rates and LDZ Capacity Charges for Class 3 and Class 4 for directly connected sites. For IGT Supply Meter Points the Formula year SMP SOQ will be used only for LDZ Capacity Charges.
CONTEXT: For CSEP SMPs this must be CSEP Max SOQ for the determination of transportation rates.
START_CORRECTOR_CORRECTED_READING
START_CONVERTER_CORRECTED_READING / O / T / 12 / 0 / DEFINITION: The value of the start ConverterCorrector corrected reading. This field will be populated when a meter has a corrector –converter fitted and is functioning normally. ConvertersCorrectors provide two readings, uncorrected and corrected.
This field represents the corrected reading i.e. the value of a meter reading after the corrector converter corrects it.
END_CORRECTOR_CORRECTED_READING
END_CONVERTER_CORRECTED_READING / O / T / 12 / 0 / DEFINITION: The value of the end ConverterCorrector corrected reading. This field will be populated when a meter has a convertercorrector fitted and is functioning normally. ConvertersCorrectors provide two readings, uncorrected and corrected. This field represents the corrected reading i.e. the value of a meter reading after the convertercorrector corrects it.
CORRECTOR_TTZ_COUNT
CONVERTER_ROUND_THE_CLOCK / O / T / 2 / 0 / DEFINITION: Represents the number of times the meter or convertercorrector measuring consumption has gone through the zeroes between the start and end readings of the relevant metered period.
Number of times the Converter has gone round the clock (i.e. through the zero’s), between the start and end readings of the relevant metered period. The first character would be prefixed with a '-' sign for negative value
VALUES: 0 -9through to 99
This field is mandatory in case a Converter is recorded for the Supply Meter Point.
METER_READING_UNITS / O / N / 5 / 0 / Definition: This contains the units the meter is read in e.g. 10, 100, 1000
CORRECTOR_READING_FLAG
CONVERTER_READING_FLAG / O / T / 1 / 0 / DEFINITION: A flag which is set to ‘Y’ if corrector converter readings have been used, else ‘N’.
METER_LINK_CODE / O / T / 1 / 0 / DEFINITION: Meter link code
VALUE:
F – Freestanding
P –Prime
S – Sub
CONTEXT: In case of link code = P, the sub energy has been deducted from prime energy
RECONCILIATION_VARIANCE_QUANTITY RQ / O / N / 31 / 15 / DEFINITION: The net billable reconciliation energy for the variance period. The first character would be prefixed with a '-' sign for negative value
Units - kWh.
PREVAILING_RECONCILIATION_
CHARGE _COMPONENT / O / N / 18 / 7 / DEFINITION: For an adjustment, reconciliation or re-reconciliation, the charge amount in pounds and pence for a variance period from the prevailing charge. The first character would be prefixed with a negative '-' if it is a payment to the system user
VALUE: Monetary value from -9999999999.9999999 to 99999999999.9999999
NEW_RECONCILIATION_CHARGE _COMPONENT / O / N / 18 / 7 / DEFINITION: For areconciliation, adjustment or re-reconciliation, the charge amount in pounds and pence for a variance period from the financial value immediately prior to this calculation. The first character would be prefixed with a negative '-' if it is a payment to the system user
VALUE: Monetary value from -9999999999.9999999 to 99999999999.9999999
Total / 626 718
AI_O_CORE_AMENDMENTS_INV_SUPPORTING_INFORMATION