Core Amendments Inv Supporting Information (.ASP)

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: / Xoserve
Owner: / Xoserve
Version: / 1
Status: / Approved
Date: / 12-Dec-2014
Contains14different Record Types
Level / Record Name / Occurrence / Optionality ly
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 / M
3 / RT_K88_RECONCILIATION_INVOICE_CHARGE_CLASS_4_LSP / As per portfolio requirements / O
3 / RT_K89_RECONCILIATION_INVOICE_CHARGE_CLASS_1_2_3_LSP / As per portfolio requirements / O
4 / RT_J42_ DAILY_SUMMARY_NTS_OPTIONAL_TARIFF / Up to 1000 / O
3 / RT_K90_RECONCILIATION_INV_AGGREGATE_DETAIL_CLASS_3_4_SSP / Up to 200,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,000 / O
3 / RT_K84_CAPACITY_RECONCILIATION_CHARGE / Up to 2000 / 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 21 Issue Date: 12/12/2014
Version 1_Approved Implementation Date: Project Nexus Implementation Date

Version Control

Version / COR / Issue Date / Implementation Date / Summary of Change
1.0 / 1154 / 14-Oct-2014 / 01-Oct-2015 / Preliminary file issued for representation
1 / 1154 / 12-Dec-2014 / 01-Oct-2015 / 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 99999999999.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
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 CHARGE
ACT – CSEPS – NTS TO EXIT COMMODITY CHARGE
AUS – UNIQUE – NTS SO EXIT COMMODITY CHARGE
ACS – CSEPS – NTS SO EXIT COMMODITY CHARGE
AUN – UNIQUE – NTS EXIT COMMODITY RECONCILIATION
ACN – CSEP – NTS EXIT COMMODITY RECONCILIATION
NRT – NTS TO EXIT COMMODITY CHARGE
NRS – NTS SO EXIT COMMODITY 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 – EXIT CAPACITY LDZ ECN CHARGE ADJ
AUE – EXIT CAPACITY LDZ ECN CHARGE ADJ
SRD – SOQ RATCHET CHARGE ADJ
ZRD – CUSTOMER RATCHET ADJ
SCD – SEASONAL CAPACITY FAILURE CHARGE 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 99999999999.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
ZRE – LDZ COMMODITY RECONCILIATION
GRE – GAS VARIABLE RECONCILIATION
NRE – NTS EXIT COMM RECONCILIATION
ACT – CSEPS – NTS TO EXIT COMMODITY CHARGE
ACS – CSEPS – NTS SO EXIT COMMODITY CHARGE
ACN – CSEP – NTS EXIT COMMODITY RECONCILIATION
NRT – NTS TO EXIT COMMODITY CHARGE
NRS – NTS SO EXIT COMMODITY CHARGE
ACY – CSEPS – LDZ COMMODITY RECONCILIATION
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 SMPfor 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 9999999999.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.
TOTAL_ACTUAL_VOLUME / M / N / 13 / 0 / 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 or zero if zero reconciliation for SMP never consumed or rec period has not used energy.
TOTAL_DEEMED_VOLUME / M / N / 13 / 0 / DEFINITION: Total deemed volume for the reconciliation period
RECONCILIATION_FACTOR / M / N / 12 / 6 / DEFINITION: The Reconciliation Factor is the ratio of actual to the allocated volume for the reconciliation period.
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 / 13 / 0 / DEFINITION: Contains the total deemed allocated volume calculated for the period of the reconciliation variance.
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.
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.
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). 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
UNMETERED_CONSUMPTION / M-O / N / 12 / 0 / DEFINITION: Identifies any unregistered gas consumption
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_PERIOD_ 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
CONTEXT: Only for Class 3 and Class 4 SMPs. For CSEP SMPs this must be CSEP Max AQ
FORMULA_PERIOD_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
CONTEXT: Only for Class 3 and Class 4 SMPs. For CSEP SMPs this must be CSEP Max SOQ
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. VALUES: 0 through 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.
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 9999999999.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 9999999999.9999999
Total / 626

AI_O_CORE_AMENDMENTS_INV_SUPPORTING_INFORMATION

RT_K89_RECONCILIATION_INVOICE_CHARGE_CLASS_1_2_3_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 : K89
CHARGE_ITEM_REFERENCE_NUMBER / M / N / 16 / 0 / DEFINITION: Aunique reference number used to identify the charge item associated to the charge type code within the invoice
SUPPLIER_SHORT_CODE / MO / 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.
CMS_REFERENCE_NUMBER / O / N / 10 / 0 / DEFINITION: The reference number for the associated CMS contact
SUPPLY_POINT_CONFIRMATION_REFERENCE / M / T / 10 / 0 / DEFINITION: A reference 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
CSEP_ID / OM / T / 8 / 0 / DEFINITION: The Unique Identifier for the Connected System Exit Point.
SUPPLY_METER_POINT
METER_POINT_REFERENCE / O / N / 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.
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_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
RECONCILIATION_VARIANCE_START_DATE / O / 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 / O / 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
GAS_FLOW_DAY / O / D / 8 / 0 / DEFINITION: The date to which the gasallocation relates to
FORMAT:YYYYMMDD
CV / O / N / 4 / 1 / DEFINITION: This holds the CV for the relevant gas flow day.
ORIGINAL_INVOICE_NUMBER / O / N / 12 / 0 / DEFINITION: For an adjustment, 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, AUY, AUT, AUS, AUN,705
ZRE – LDZ COMMODITY RECONCILIATION
GRE – GAS VARIABLE RECONCILIATION
NRE – NTS EXIT COMM RECONCILIATION
ACT – CSEPS – NTS TO EXIT COMMODITY CHARGE
ACS – CSEPS – NTS SO EXIT COMMODITY CHARGE
ACN – CSEP – NTS EXIT COMMODITY RECONCILIATION
NRT – NTS TO EXIT COMMODITY CHARGE
NRS – NTS SO EXIT COMMODITY CHARGE
ACY – CSEPS – LDZ COMMODITY RECONCILIATION
AUY – UNIQUE – LDZ COMMODITY RECONCILIATION
AUT – UNIQUE – NTS TO EXIT COMMODITY CHARGE
AUS – UNIQUE – NTS SO EXIT COMMODITY CHARGE
AUN – UNIQUE – NTS EXIT COMM RECONCILIATION
705 – NTS OPTIONAL COMMODITY RECONCILIATION
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 SMP for a particular charge type calculated during the reconciliation varianceperiod. '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 9999999999.9999999
SUPPLY_METER_POINT / M / N / 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.
PREVAILING_ENERGY / M / N / 31 / 15 / DEFINITION:
The prevailing billed energy (in kWh) used the relevant gas flow
Day Prevailing energy for the SMP which is used for the calculation of the amendment charge
REVISED_ENERGY / M / N / 31 / 15 / DEFINITION:
The revised energy (inkWh) used by the SMP for the relevant variance period
CONTEXT: This may be applicable for the relevant variance periodor a GFD
ENERGY_VARIANCE / M / N / 31 / 15 / DEFINITION: Difference between prevailing energy and revised energy (in
kWh)
SUB_ENERGY / O / N / 31 / 15 / DEFINITION: The energy (inkWh) used by the subs in case of P&S setup for the relevant 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.
Total / 293303

AI_O_CORE_AMENDMENTS_INV_SUPPORTING_INFORMATION