File Format Document

Core_Commodity_Individual_SMP_Supporting_Information (.COI)

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.5
Status: / For Approval
Date: / 03-07-2015

Version Control

Version / COR / Issue Date / Implementation Date / Summary of Change
0.1 / 1154 / 20-Aug-2014 / 01-Oct-2015 / Preliminary file issued for representation
1.0 / 1154 / 30-Sep-2014 / 01-Oct-2015 / File issued for representation
1.1 / 1154 / 07-Oct-2014 / 01-Oct-2015 / File issued for representation.
Corrected the record count and field optionality
1.2 / 1154 / 12-Dec-2014 / 01Oct-2014 / Further Changes Identified (Highlighted Green)
1.3 / 1154 / 16- Dec-2014 / 01-Oct-2015 / Further Changes Identified (Highlighted Green)
1A / 1154 / 23-Dec-2014 / 01-Oct-2015 / Approved
1.4 / 1154 / 09-Jun-2015 / TBC /
  • Implementation Date amended to TBC
  • Issue Date amended to 09/06/2015
  • In record type table and K43 record table, occurence of K43 record amended to 500 and K44 record amended as level 2
  • In K43 record type, removed context from the description of ‘EUC_NUMBER’ field
  • In K43 record type, changed the optionality of ‘SUPPLIER_SHORT_CODE’ from mandatory to optional
  • In K43 record type, added the ‘MARKET_CATEGORY’ and ‘CLASS_TYPE’ fields
  • In K44 record type, amended the description of ‘FORMULA_YEAR_SMP_AQ’ and ‘FORMULA_YEAR_SMP_SOQ’ fields
  • In K44 record type, changed the field names of ‘CSEP_MAXIMUM_AQ’ and ‘CSEP_MAXIMUM_SOQ’ to ‘CSEP_CONNECTION_MAX_AQ’ and ‘CSEP_CONNECTION_MAX_SOQ‘ respectively and amended the description
  • In K44 record type, changed the field name ‘CHARGE_AMOUNT’ to ‘NTS_EXIT_COMM_CHARGE_COMPONENT’ , amended the field decimal length and description
  • In K44 record, renamed the field ‘CHARGE_TYPE_CODE’ to ‘NTS_EXIT_COMM_ CHARGE_TYPE_CODE’ and changed the optionality from mandatory to optional
  • In K44 record type, Invoice_Number, Charge_Item_Refernce_Number has been moved after the Deemed_Quantity and changed the optionality from mandatory to optional. They have also been renamed as follows:
At each INVOICE_NUMBER (INVOICE_NUMBER_FOR_NTS_EXIT_COMM, INVOICE_NUMBER_FOR_NTS_TO_EXIT_COMM, INVOICE_NUMBER_FOR_NTS_SO_EXIT_COMM and INVOICE_NUMBER_FOR_LDZ_COMM charges) to define linked charge types
  • In K44 record type , Charge_Rate field renamed as NTS_EXIT_COMM_CHARGE_RATE
  • The following charges have been included under K44 record: NTS_TO_EXIT_COMM NTS_SO_EXIT_COMM LDZ_COMM
  • Amended Total to K44 record
  • Grand Total changed from 334 to 503

1.5 / 1154 / 03-07-2015 / TBC /
  • K43 Record Type- Class Type & Market Category has been amended from Mandatory to Optional.

Contains4different Record Types
Level / Record Name / Occurrence / Optionalityly
1 / HD_A00_STANDARD_HEADER / 1 / M
1 / RT_K43_STANDARD_INDIVIDUAL_SMP_FILE_SUMMARY / Up to 1 500 / M
2 1 / RT_K44_COMM_INDIVIDUAL_SMP_DETAIL_CLASS_3_AND_4 / As per portfoliorequirements / M
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_Commodity_Individual_SMP_Supporting_Information (.COI) Page 1 of 14 Issue Date: 03/07/2015
Version 1.5 For Approval Implementation Date: TBC

Record Type Definition

AI_O_CORE_COMMODITY_INDIVIDUAL_SMP_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:COI
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_COMMODITY_INDIVIDUAL_SMP_Supporting_Information

RT_K43_STANDARD_INDIVIDUAL_SMP_FILE_SUMMARY

RECORD/FIELD_NAME
*Occurs Max 1 500* / OPT / DOM / LNG / DEC / DESCRIPTION
TRANSACTION_TYPE / M / T / 3 / 0 / DEFINITION: A code identifying the type of request that this record represents.
VALUE:K43
INVOICE_TYPE_CODE / M / T / 3 / 0 / DEFINITION: A three character code used to identify the Invoice Type.
VALUE:COM
FILE_DESCRIPTION / M / T / 50 / 0 / DEFINITION: Description of File Type
VALUE:COMM INDIVIDUAL SMP SUPPORTING INFO
SUPPLIER_SHORT_CODE / M O / T / 3 / 0 / DEFINITION: Supplier code for the meter point reference.
BILLING_MONTH / MO / TN / 2 / 0 / DEFINITION:The month of the billing period for which the Invoice relates, e.g. 1 – 9 = January– September and 10 – 12 = October - December FORMAT:MM
BILLING_YEAR / MO / N / 4 / 0 / DEFINITION: The year of the billing period for which the Invoice relates.
DEFINITION: This attribute holds the year to which the invoice relates. Combined with BILLING MONTH will give billing period which the invoice covers.
FORMAT:YYYY
INVOICE_NUMBER / O / N / 12 / 0 / DEFINITION: Holds the unique number by which an Invoice is known.
NWO_SHORT_CODE / O / T / 3 / 0 / DEFINITION: A unique three character code used to identify a Network Operator.
LDZ_IDENTIFIER / O / T / 4 / 0 / DEFINITION: This field identifies the LDZ to which the supply meter point is associated.
Unique reference code for the Local Distribution Zone (LDZ).
EUC_NUMBER DESCRIPTION / O / NT / 102 / 0 / DEFINITION: Acronym for the makeup of an End User Category (EUC). EUC's categorise end users in terms of their LDZ, AQ lower limit, AQ upper limit, meter read frequency, BGIC code, winter start, and end month and the ratio of upper and lower limit.
DEFINITION:A unique number used to identify the End user Category.
CONTEXT: The EUC Number for the Supply Meter Point
MARKET_CATEGORY / MO / T / 3 / 0 / DEFINITION:
Allowable VALUE: LSP(Large Supply Point), SSP(Small Supply Point)
CLASS_TYPE / MO / N / 1 / 0 / DEFINITION: A unique reference for the Class type to which the SMP belongs to.
VALUE:
3 – Class 3
4 - Class 4
Total / 443 48

AI_O_CORE_COMMODITY_INDIVIDUAL_SMP_Supporting_Information

RT_K44_COMM_INDIVIDUAL_SMP_DETAIL_CLASS_3_AND_4

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 this record represents.
VALUE:K44
INVOICE_NUMBER / M / N / 12 / 0 / DEFINITION: Holds the unique number by which an Invoice is known.
NWO_SHORT_CODE / M / T / 3 / 0 / DEFINITION: A unique three character code used to identify a Network Operator.
SUPPLIER_SHORT_CODE / M / T / 3 / 0 / DEFINITION: Supplier code for the supply meter point reference
LDZ_IDENTIFIER / M / T / 4 / 0 / DEFINITION: This field identifies the LDZ to which the supply meter point is associated
Unique reference code for the Local Distribution Zone (LDZ).
EUC_NUMBER DESCRIPTION / M / NT / 102 / 0 / DEFINITION: Acronym for the makeup of an End User Category (EUC). EUC's categorise end users in terms of their LDZ, AQ lower limit, AQ upper limit, meter read frequency, BGIC code, winter start, and end month and the ratio of upper and lower limit.
DEFINITION: A unique number used to identify the End user Category.
CONTEXT: The EUC Number for the Supply Meter Point
SUPPLY_METER_POINT
METER_POINT_REFERENCE / MO / 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.
SUPPLY_POINT_CONFIRMATION_REFERENCE / M / T / 10 / 0 / DEFINITION:A sequential reference that number that uniquely identifies the Confirmation
CHARGE_ITEM_REFERENCE_NUMBER / M / N / 16 / 0 / DEFINITION: A unique reference number used to identify the charge item associated to the invoice
SUPPLY_METER_POINT_AQ / M / N / 15 / 0 / DEFINITION: The annual offtake quantity of a Supply Meter Point. This AQ may be revised following read submission
VALUE: KWH
SUPPLY_METER_POINT_SOQ / M / N / 10 / 0 / DEFINITION: The peak daily supply offtake quantity (SOQ) of the Supply Meter Point
FORMULA_YEAR_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
DEFINITION: The AQ of the Supply Meter Point that is fixed throughout the formula year for determination of transportation rates for Class 3 and Class 4for directly connect sites only
CONTEXT: For CSEP SMPs this must be CSEP Max AQ for the determination of transportation rates
FORMULA_YEAR_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 AQ
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 connect 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
CSEP_IDPROJECT_REFERENCE / O / T / 8 / 0 / DEFINITION: Unique CSEP Reference Identifier
CSEP_MAXIMUM_AQ
CSEP_CONNECTION_MAX_AQ / O / N / 15 / 0 / DEFINITION: Maximum CSEP AQ
DEFINITION: The total projected maximum annual offtake (AQ) of gas (measured in kWh) of all Supply Meter Points associated with this CSEP’s connection to the upstream network.
CSEP_MAXIMUM_SOQ
CSEP_CONNECTION_MAX_SOQ / O / N / 1310 / 0 / DEFINITION: Maximum CSEP SOQ
DEFINITION: The total projected maximum daily offtake (SOQ) of gas (measured in kWh) of all Supply Meter Points associated with this CSEP’s connection to the upstream network, calculated from the EUC AQ and DM SOQ information provided.
IGT_ORGANISATION_ID / O / N / 10 / 0 / DEFINITION:A reference which uniquely identifies the independent gas transporters
BILLABLE_START_DATE / M / D / 8 / 0 / DEFINITION: Defines the start date of the billing period for which the charge item is calculated.
FORMAT:YYYYMMDD
BILLABLE_END_DATE / M / D / 8 / 0 / DEFINITION: Defines the end date of the billing period for which the charge item is calculated.
FORMAT:YYYYMMDD
DEEMED_QUANTITY / M / N / 31 / 15 / DEFINITION: The Energy amount, in kWh, deemed to be used by the supply meter point reference.
INVOICE_NUMBER_FOR_NTS_EXIT_COMM / M O / N / 12 / 0 / DEFINITION: Holds the unique number by which an Invoice is known.
CONTEXT: This is for NTS_EXIT_COMM Charges
NTS_EXIT_COMM_CHARGE_ITEM_REFERENCE_NUMBER / M O / N / 16 / 0 / DEFINITION: A unique reference number used to identify the charge item associated to the invoice
NTS_EXIT_COMM_CHARGE_TYPE_CODE / M O / T / 3 / 0 / DEFINITION: A code to identify the type of charge.
VALUE:
NCO,NCT,NCS,ZCO,892, 89T,89S,893
Following is the charge description:
NCO – NTS EXIT COMMODITY CHARGE
NCT - NTS TO EXIT COMMODITY CHARGE
NCS - NTS SO EXIT COMMODITY CHARGE
ZCO – LDZ COMMODITY CHARGE
892 – CSEPS- NTS EXIT COMM CHARGE
89T – CSEPS- NTS TO EXIT COMM CHARGE
89S – CSEPS- NTS SO EXIT COMM CHARGE
893 –CSEPS - LDZ COMMODTY CHARGE
NTS_EXIT_COMM_CHARGE_RATE / M / N / 10 / 4 / DEFINITION: The rate, in pence, which was used to calculate the charge.
NTS_EXIT_COMM_CHARGE_COMPONENT
CHARGE_AMOUNT / M / N / 1418 / 7 2 /
DEFINITION: Holds the charge value for an individual SMP for a particular charge type calculated during the Billing Period
Holds the charge values of 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
VALUE: Monetary value from -999999.9999999 to 9999999.9999999
INVOICE_NUMBER_FOR_NTS_TO_EXIT_COMM / O / N / 12 / 0 / DEFINITION: Holds the unique number by which an Invoice is known.
CONTEXT: This is for NTS_TO_EXIT_COMM Charges
NTS_TO_EXIT_COMM_CHARGE_ITEM_REFERENCE_NUMBER / O / N / 16 / 0 / DEFINITION: A unique reference number used to identify the charge item associated to the invoice
NTS_TO_EXIT_COMM_CHARGE_TYPE_CODE / O / T / 3 / 0 / DEFINITION: A code to identify the type of charge.
VALUE: NCT, 89T
Following is the charge description:
NCT - NTS TO EXIT COMMODITY CHARGE
89T – CSEPS- NTS TO EXIT COMM CHARGE
NTS_TO_EXIT_COMM_CHARGE_RATE / O / N / 10 / 4 / DEFINITION: The rate, in pence, which was used to calculate the charge.
NTS_TO_EXIT_COMM_CHARGE_COMPONENT / O / N / 18 / 7 /
DEFINITION: Holds the charge value for an individual SMP for a particular charge type calculated during the Billing Period
VALUE: Monetary value from -999999.9999999 to 9999999.9999999
INVOICE_NUMBER_FOR_NTS_SO_EXIT_COMM / O / N / 12 / 0 / DEFINITION: Holds the unique number by which an Invoice is known.
CONTEXT: NTS_SO_EXIT_COMM Charges
NTS_SO_EXIT_COMM_CHARGE_ITEM_REFERENCE_NUMBER / O / N / 16 / 0 / DEFINITION: A unique reference number used to identify the charge item associated to the invoice
NTS_SO_EXIT_COMM_CHARGE_TYPE_CODE / O / T / 3 / 0 / DEFINITION: A code to identify the type of charge.
VALUE:
NCS,89S
Following is the charge description:
NCS - NTS SO EXIT COMMODITY CHARGE
89S – CSEPS- NTS SO EXIT COMM CHARGE
NTS_SO_EXIT_COMM_CHARGE_RATE / O / N / 10 / 4 / DEFINITION: The rate, in pence, which was used to calculate the charge.
NTS_SO_EXIT_COMM_CHARGE_COMPONENT / O / N / 18 / 7 /
DEFINITION: Holds the charge value for an individual SMP for a particular charge type calculated during the Billing Period
VALUE: Monetary value from -999999.9999999 to 9999999.9999999
INVOICE_NUMBER_FOR_LDZ_COMM / M / N / 12 / 0 / DEFINITION: Holds the unique number by which an Invoice is known.
CONTEXT: This is for LDZ_COMM Charges
LDZ_COMM_CHARGE_ITEM_REFERENCE_NUMBER / M / N / 16 / 0 / DEFINITION: A unique reference number used to identify the charge item associated to the invoice
LDZ_COMM_CHARGE_TYPE_CODE / M / T / 3 / 0 / DEFINITION: A code to identify the type of charge.
VALUE:
ZCO,893
Following is the charge description:
ZCO – LDZ COMMODITY CHARGE
893 –CSEPS - LDZ COMMODTY CHARGE
LDZ_COMM_CHARGE_RATE / M / N / 10 / 4 / DEFINITION: The rate, in pence, which was used to calculate the charge.
LDZ_COMM_CHARGE_COMPONENT / M / N / 18 / 7 /
DEFINITION: Holds the charge value for an individual SMP for a particular charge type calculated during the Billing Period
VALUE: Monetary value from -999999.9999999 to 9999999.9999999
Total / 240241 422

AI_O_CORE_COMMODITY_INDIVIDUAL_SMP_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: 334332 519

Core_Commodity_Individual_SMP_Supporting_Information (.COI) Page 1 of 14 Issue Date: 03/07/2015
Version 1.5 For Approval Implementation Date: TBC