Service Standard Liabilities Invoice Supporting Information (.LIA)

File Format Document

Service_Standard_Liabilities_Invoice_Supporting_Information (.LIA)

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.3A
Status: / Approved
Date: / 27-07-2015

Version Control

Version / COR / Issue Date / Implementation Date / Summary of Change
1FA / 1154 / 07-Oct-2014 / 01-Oct-2015 / File issued for representation
1A / 1154 / 12-Dec-2014 / 1-Oct-2015 / File Issued Approved
1.1FA / 1154 / 12-Dec-2014 / 1-Oct-2015 / Further Changes Identified (Highlighted Green)
1.1A / 1154 / 23-Dec-2014 / 1-Oct-2015 / Approved
1.2FA / 1154 / 09-Jun-2015 / TBC /

• Implementation Date amended to TBC
• Issue Date amended to 09/06/2015
• In K46 record type, changed the optionality from mandatory to optional for CCA_RATE, ZCA_RATE, ECN_RATE, RATES_TOTAL, FIXED_LIABILITY_RATE, COMBINED_CAPACITY_RATE, LIABILITY_FACTOR and TOTAL_AMOUNT fields.

1.3FA / 1154 / 03-July-2015 / TBC /

• K46 INVOICE_NUMBER description as had FORMAT YYYYMMDD removed

1.3A / 1154 / 27-July-2015 / Project Nexus Implementation Date / Approved
Contains 8 different 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_Q29_STANDARD_CHARGE_TYPE_SUMMARY / Up to 60 / M
3 / RT_K69_SSL_SUPPORTING_INFO_DETAIL / Up to10000 / O
3 / RT_K82_SSL_ONE_OFF_DETAIL / Up to 3000 / O
4 / RT_K83_SSL_NETWORK_PAYMENT_DETAIL / Up to 20000 / O
3 / RT_K46_SSL_FSG_SUPPORTING_INFO_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 ("")

SSL_Invoice_Supporting_Information(.LIA) Page 1 of 16 Issue Date: 27/07/2015
Version 1.3A Implementation Date: Project Nexus Implementation Date

Record Type Definition

AI_O_SERVICE_STANDARD_LIABILITIES_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:LIA
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_SERVICE_STANDARD_LIABILITIES_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
ORGANISATION_SHORT_CODE / M / T / 3 / 0 / DEFINITION: This field identifies the three character unique organisation short code.
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:LIA
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.
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 - December
FORMAT:MM
BILLING_YEAR / M / N / 4 / 0 / DEFINITION: The year of the billing period for which the Invoice relates.
FORMAT: YYYY
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_AMOUNT / M / N / 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‘if it is a payment to the system user. VALUE : Monetary values from -99999999999.99 to 99999999999.99
Total / 44

AI_O_SERVICE_STANDARD_LIABILITIES_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:LIA
CHARGE_TYPE_CODE / M / T / 3 / 0 / DEFINITION: A unique three character code used to identify the charge type/s.
VALUE: 823
Following is the charge description:
823 - SERVICE STANDARDS LIABILITIES
CHARGE_AMOUNT / M / N / 14 / 2 / DEFINITION: Holds the sum of the charges values of a particular charge type. The first character would be prefixed with (-) if it is a negative amountNegative values will have a prefix (-).
VALUE: Monetary values from -99999999999.99 to 99999999999.99
Total / 26

AI_O_SERVICE_STANDARD_LIABILITIES_INVOICE_SUPPORTING_INFORMATION

RT_K69_SSL_SUPPORTING_INFO_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: K69
LIABILITY_CODE / M / T / 6 / 0 / DEFINITION: Holds the unique Transportation Standard & Liabilities Reference Number.
VALUE: TSL1, TSL8a, TSL8b, TSL13a, TSL13b, TSL13c, TSL14a, TSL14b, TSL14c
Following are the liability code descriptions:
TSL1-DAILY METERED READS,
TSL8a-NOMINATIONS REFERRED - LARGE,
TSL8b-NOMINATIONS REFERRED - SMALL,
TSL13a-QUERY RESOLUTION GT (Large) <=4 days,
TSL13b-QUERY RESOLUTION GT (Large) <=10 days,
TSL13c-QUERY RESOLUTION GT (Large) <=20 days,
TSL14a-QUERY RESOLUTION GT (Small) <=4 days,
TSL14b-QUERY RESOLUTION GT (Small) <=10 days,
TSL14c-QUERY RESOLUTION GT (Small) <=20 days
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.
SHIPPERS_AT_SHARED_SMP / O / N / 3 / 0 / DEFINITION: Holds the number of shippers for a Shared SMP.
SHIPPER_TOTAL / O / N / 14 / 0 / DEFINITION: Shipper's individual population for a particular standard.
ALL_SHIPPER_TOTAL / O / N / 14 / 0 / DEFINITION: Overall shippers’ population for particular standard.
SHIPPER_SUCCESS_COUNT / O / N / 14 / 0 / DEFINITION: Shipper's individual valid population in standard.
ALL_SHIPPER_SUCCESS_COUNT / O / N / 14 / 0 / DEFINITION: Overall shippers’ valid population in standard.
SHIPPER_PERFORMANCE% / O / N / 514 / 2 / DEFINITION: Shipper’s Performance percentage.
VALUE: 0 to 999.99
ALL_SHIPPER_PERFORMANCE% / O / N / 514 / 2 / DEFINITION: Overall shippers’ performance percentage.
VALUE: 0 to 999.99
PPL% / O / N / 514 / 2 / DEFINITION: Planned performance level for particular standard.
VALUE: 0 to 999.99
SHIPPER_PPL_TARGET / O / N / 14 / 2 / DEFINITION: individual target of shipper’s portfolio required to meet minimum PPL.
ALL_SHIPPER_PPL_TARGET / O / N / 14 / 2 / DEFINITION: Overall shippers’ target in order for liabilities not to be paid.
STAGE_CATEGORY / O / N / 1 / 0 / DEFINITION: Liability Payment Stage Category.
VALUE: 1, 2
STAGE_LIABILITY_RATE COST / M / N / 10 / 4 / DEFINITION: The unit cost related to Liability Stage Category.
The fixed rate (GBP per TSL failure) related to Liability Stage Category.
STAGE_SHIPPER_FAILURE_COUNT / O / N / 14 / 0 / DEFINITION: Shipper's individual stage failure count.
STAGE_ALL_SHIPPER_FAILURE_COUNT / O / N / 14 / 0 / DEFINITION: Overall shippers’ stage failure count.
STAGE_LIABILITY_AMOUNT / M / N / 14 / 2 / DEFINITION: individual shipper’sliability amount for the stage failure.
VALUE : Monetary values from -99999999999.99 to 99999999999.99
INVOICE_NUMBER / M / N / 12 / 0 / DEFINITION: Holds the unique number by which an Invoice is known.
INVOICE_ISSUE_DATE / M / D / 8 / 0 / DEFINITION: Invoice Issue Date.
FORMAT YYYYMMDD
Total / 194221

AI_O_SERVICE_STANDARD_LIABILITIES_INVOICE_SUPPORTING_INFORMATION

RT_K82_SSL_ONE_OFF_DETAIL

RECORD/FIELD_NAME
*Occurs Max 3000* / OPT / DOM / LNG / DEC / DESCRIPTION
TRANSACTION_TYPE / M / T / 3 / 0 / DEFINITION: A code identifying the type of request that this record represents.
VALUE: K82
LIABILITY_CODE / M / T / 6 / 0 / DEFINITION: Holds the unique Transportation Standard & Liabilities Reference Number.
VALUE: TSL2a, TSL2b, TSL7, TSL10a, TSL10c, TSL12a, TSL12b, TSL13d, TSL14d, TSL18a, TSL18b, TSL19a, TSL19b
Following are the liability code descriptions:
TSL2a-CALORIFIC VALUES,
TSL2b-CALORIFIC VALUES REVISIONS,
TSL7-GRE INVOICE QUERIES, TSL10a-FILE FORMATS - CONSULTATION,
TSL10c-FILE FORMATS - FAILURE TO IMPLEMENT,TSL12a-SYSTEMS FAILURE,
TSL12b-NON SYSTEMS RECOVERY,
TSL13d-QUERY RESOLUTION GT (Large) <=40 days,
TSL14d-QUERY RESOLUTION GT (Small) <=40 days,
TSL18a-SPECIAL SUPPLY POINTS > 293,000kWh >5days,
TSL18b-SPECIAL SUPPLY POINTS > 293,000kWh >20days,
TSL19a-SPECIAL SUPPLY POINTS <= 293,000kWh >5days,
TSL19b-SPECIAL SUPPLY POINTS <= 293,000kWh >20days
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 - December
FORMAT: MM
BILLING_YEAR / M / N / 4 / 0 / DEFINITION: The year of the billing period for which the Invoice relates
This attribute holds the year to which the invoice relates. Combined with BILLING MONTH will give billing period which the invoice covers.
FORMAT: YYYY
TOTAL_LIABILITY_AMOUNT / M / N / 14 / 2 / DEFINITION: Holds sum of One Offs Values for a particular liability code. Negative values will have a prefix (-).
VALUE: Monetary values from
-99999999999.99 to 99999999999.99
SERVICE STANDARD LIABILITIESCOMMENTS / O / T / 500 / 0 / DEFINITION: Comments provided to support the charges generated on the invoice.
INVOICE_NUMBER / M / N / 12 / 0 / DEFINITION: Holds the unique number by which an Invoice is known.
INVOICE_ISSUE_DATE / M / D / 8 / 0 / DEFINITION: Invoice Issue Date.
FORMAT: YYYYMMDD
Total / 549

AI_O_SERVICE_STANDARD_LIABILITIES_INVOICE_SUPPORTING_INFORMATION

RT_K83_SSL_NETWORK_PAYMENT_DETAIL

RECORD/FIELD_NAME
*Occurs Max 20000* / OPT / DOM / LNG / DEC / DESCRIPTION
TRANSACTION_TYPE / M / T / 3 / 0 / DEFINITION: A code identifying the type of request that this record represents.
VALUE: K83
LIABILITY_CODE / M / T / 6 / 0 / DEFINITION: Holds the unique Transportation Standard & Liabilities Reference Number.
VALUE: TSL1, TSL2a, TSL2b, TSL7, TSL8a, TSL8b, TSL10a, TSL10c, TSL12a, TSL12b, TSL13a, TSL13b, TSL13c, TSL13d, TSL14a, TSL14b, TSL14c, TSL14d, TSL18a, TSL18b, TSL19a, TSL19b
Following are the liability code descriptions:
TSL1-DAILY METERED READS,
TSL2a-CALORIFIC VALUES,
TSL2b-CALORIFIC VALUES REVISIONS,
TSL7-GRE INVOICE QUERIES, TSL8a-NOMINATIONS REFERRED - LARGE,
TSL8b-NOMINATIONS REFERRED - SMALL,
TSL10a-FILE FORMATS - CONSULTATION,
TSL10c-FILE FORMATS - FAILURE TO IMPLEMENT,
TSL12a-SYSTEMS FAILURE,
TSL12b-NON SYSTEMS RECOVERY,
TSL13a-QUERY RESOLUTION GT (Large) <=4 days,
TSL13b-QUERY RESOLUTION GT (Large) <=10 days,
TSL13c-QUERY RESOLUTION GT (Large) <=20 days,
TSL13d-QUERY RESOLUTION GT (Large) <=40 days,
TSL14a-QUERY RESOLUTION GT (Small) <=4 days,
TSL14b-QUERY RESOLUTION GT (Small) <=10 days,
TSL14c-QUERY RESOLUTION GT (Small) <=20 days,
TSL14d-QUERY RESOLUTION GT (Small) <=40 days,
TSL18a-SPECIAL SUPPLY POINTS > 293,000kWh >5days,
TSL18b-SPECIAL SUPPLY POINTS > 293,000kWh >20days,
TSL19a-SPECIAL SUPPLY POINTS <= 293,000kWh >5days,
TSL19b-SPECIAL SUPPLY POINTS <= 293,000kWh >20days
TOTAL_LIABILITY_AMOUNT / M / N / 14 / 2 / DEFINITION: Holds sum of One Offs Values for a particular liability code. Negative values will have a prefix (-).
VALUE: Monetary values from
-99999999999.99 to 99999999999.99
NWO_SHORT_CODE / M / T / 3 / 0 / DEFINITION: A unique three character code used to identify a Network Operator.
NWO_SP% / O / N / 5 / 2 / DEFINITION: Network Operator’s percentage share of supply points.
NWO_PAYMENT_AMOUNT / M / N / 14 / 2 / DEFINITION: Network’s share of stage payment amount based on their supply point percentage.
VALUE : Monetary values from -99999999999.99 to 99999999999.99
INVOICE_NUMBER / M / N / 12 / 0 / DEFINITION: Holds the unique number by which an Invoice is known.
INVOICE_ISSUE_DATE / M / D / 8 / 0 / DEFINITION: Invoice Issue Date.
FORMAT: YYYYMMDD
Total / 65

AI_O_SERVICE_STANDARD_LIABILITIES_INVOICE_SUPPORTING_INFORMATION

RT_K46_SSL_FSG_SUPPORTING_INFO_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: K46
LIABILITY_CODE / M / T / 6 / 0 / DEFINITION: Holds the unique Transportation Standard & Liabilities Reference Number.
VALUE: TSL11a
Following are the liability code descriptions:
TSL11a-GAS NOT AVAILABLE >2,500 tpa (I&C)
NWO_SHORT_CODE / M / T / 3 / 0 / DEFINITION: A unique three character code used to identify a Network Operator
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).
DISTRICT_ID / M / T / 2 / 0 / DEFINITION: A two character string uniquely identifying the TRANSPORTER District within the TRANSPORTER area.
GAS_OFF_DAY / M / D / 8 / 0 / DEFINITION: Calendar date gas supply off.
FORMAT: YYYYMMDD
GAS_ON_DAY / M / D / 8 / 0 / DEFINITION: Calendar date gas supply on.
FORMAT: YYYYMMDD
TIME_OFF / M / M / 4 / 0 / DEFINITION: Time (24hour) gas supply off.
FORMAT: HHMM
TIME_ON / M / M / 4 / 0 / DEFINITION: Time (24hour) gas supply on.
FORMAT: HHMM
BUILDING_NUMBER / O / N / 410 / 0 / DEFINITION: Building Number as defined in PAF.
BUILDING_NAME / O / T / 50 / 0 / DEFINITION: Building Name as defined in PAF.
PRINCIPAL_STREET / O / T / 40 / 0 / DEFINITION: A combination THOROUGHFARE NAME and THOROUGHFARE DESCRIPTOR as defined in PAF.
POST_TOWN / O / T / 40 / 0 / DEFINITION: The post town in which the street lies. CONTEXT: Post Town as defined in PAF.
COUNTY / O / T / 40 / 0 / DEFINITION: The county within which the street lies. The meaning is equivalent to that of the PAF field of the same name.
POSTCODE_OUTCODE / M / T / 4 / 0 / DEFINITION: Standard PAF Outcode as defined in the PAF digest
POSTCODE_INCODE / M / T / 4 / 0 / DEFINITION: Standard PAF Incode as defined in the PAF digest
FSG_COMPENSATION_CODE / M / T / 3 / 0 / DEFINITION: Reason code for the Failure to Supply Gas.
SUPPLY_METER_POINT
METER_POINT_REFERENCE / M / N / 10 / 0 / DEFINITION: AnA 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 / TN / 10 / 0 / DEFINITION: A sequential number that uniquely identifies the Confirmation
SMP_EXIT_ZONE / O / T / 4 / 0 / DEFINITION: An identifier representing the Exit Zone of the SMP.
CSEP_EXIT_ZONE / O / T / 4 / 0 / DEFINITION: An identifier representing the CSEPsepExit Zone of the SMP.
SUPPLY_METER_POINT_AQ / O / N / 15 / 0 / DEFINITION: This field identifies the total Annual Quantity associated with the Supply Meter Point Reference.
SUPPLY_METER_POINT_SOQ / O / N / 10 / 0 / DEFINITION: This field identifies the Supply Offtake Quantity (SOQ) of the meter point.
DURATION_IN_DAYS / M / N / 5 / 0 / DEFINITION: Duration of failure to supply.
CCA_RATE / M O / N / 8 / 4 / DEFINITION: The daily CCA rate (in pence)
ZCA_RATE / M O / N / 8 / 4 / DEFINITION: The daily ZCA rate (in pence)
ECN_RATE / M O / N / 8 / 4 / DEFINITION: The daily ECN rate (in pence)
RATES_TOTAL / M O / N / 8 / 4 / DEFINITION: Sum of all daily capacity rates - CCA_RATE, ZCA_RATE and ECN_RATE (in pence).
FIXED_LIABILITY_RATECOST / M O / N / 1014 / 42 / DEFINITION: The fixed liability rate defined for TSL 11a: Failure to Supply Gas(in GBP)
COMBINED_CAPACITY_CHARGE / M O / N / 14 / 2 / DEFINITION: Combined Capacity Charge value. Product of RATES_TOTAL and SUPPLY_METER_POINT_SOQ.
VALUE: Monetary values from
-99999999999.99 to 99999999999.99
LIABILITY_FACTOR / M O / N / 10 / 2 / DEFINITION: Factor used in liability calculation.
TOTAL_AMOUNT_IN_PENCE / M O / N / 14 / 2 / DEFINITION: Total amount in GBP. Product of RTXSOQ/100 andLIABILITY_FACTOR.
VALUE: Monetary values from
-99999999999.99 to 99999999999.99
TOTAL_COMPENSATION_VALUE / M / N / 14 / 2 / DEFINITION: Liability amount is determined by comparing Combined Capacity Charge value and Fixed Liability value for the duration of failure to supply gas. CONTEXT: FIXED_LIABILITY_COST * DURATION_IN_DAYS or COMBINED_CAPACITY_CHARGE* DURATION_IN_DAYS whichever is greater will determine the total compensation value. Negative values will have a prefix (-).
VALUE: Monetary values from
-99999999999.99 to 99999999999.99
INVOICE_NUMBER / M / N / 12 / 0 / DEFINITION: Holds the unique number by which an Invoice is known.
FORMAT YYYYMMDD
INVOICE_ISSUE_DATE / M / D / 8 / 0 / DEFINITION: Invoice Issue Date.
FORMAT: YYYYMMDD
Total / 399410

AI_O_SERVICE_STANDARD_LIABILITIES_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: 13261364

SSL_Invoice_Supporting_Information(.LIA) Page 1 of 16 Issue Date: 27/07/2015
Version 1.3A Implementation Date: Project Nexus Implementation Date