File Format Document

Own_Use_Gas_Supporting_Information (.OSG)

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.1
Status: / For Approval
Date: / 07-10-2014

Version Control

Version / COR / Issue Date / Implementation Date / Summary of Change
0.3 / 1154 / 01-Sep-2014 / 01-Oct-2015 / Preliminary File issued for representation
1 / 1154 / 30-Sep-2014 / 01-Oct-2015 / File issued for representation
Description rationalisation
Record type H00
GENERATION_NUMBER mandatory
Record type Q28
SHIPPER_SHORT_CODE renamed to ORGANISATION_SHORT_CODE
INVOICE_TYPE_CODE value now OWG
Record type Q29
Max records now 60
CHARGET_TYPE_AMOUNT renamed to CHARGE_AMOUNT
Record Type K55
FIELD NAME OCCURS MAX 50 changed to 300
LOGICAL_METER_NUMBER renamed to OUG_METER_ID
DAILY_ALLOCATED_ENERGY renamed to ALLOCATED_QUANTITY
OWN_USE_GAS_RATE_CHARGE_(P/k wh) renamed to OWN_USE_GAS_RATE
OWN_USE_GAS_CHARGE(£) renamed to OWN_USE_GAS_CHARGE
LENGTH CHANGED FROM 8 to 10 OWN_USE_GAS_CHARGE
1.1 / 1154 / 07-10-2014 / 01-10-2015 / File issued for representation
Q28 Record length corrected
Contains5different Record Types
Level / Record Name / Occurrence / Optionally
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_K55_OWN_USE_GAS_SUPPORTING_INFORMATION / Up to 300 / 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 ("")

Own_Use_Gas_Supporting_Information (.OSG) Page 1 of 9 Submission Date: 07/10/2014
Version: 1.1For Approval Implementation Date: 01/10/2015

Record Type Definition

AI_O_OWN_USE_GAS_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:OSG
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 / OM / 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 one 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_OWN_USE_GAS_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
INVOICE_TYPE_CODE / M / T / 3 / 0 / DEFINITION: A three character code used to identify the Invoice Type.
VALUE: ADN OWG
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 issue
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 / 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 / 46 44

AI_O_OWN_USE_GAS_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:OWG
CHARGE_TYPE_CODE / M / T / 3 / 0 / DEFINITION: A unique three character code used to identify the charge type/s.
VALUE:840
Following is the charge description:
840 – NTS EXIT COMMODITY CHARGE NCO
CHARGE_TYPE_AMOUNT CHARGE_AMOUNT / M / N / 14 / 2 / DEFINITION: Holds the sum of the charges of a particular charge type. Negative values will have a prefix (-)
VALUE: Monetary values from -99999999999.99 to 99999999999.99
Total / 26

AI_O_OWN_USE_GAS_Supporting_Information

RT_K55_OWN_USE_GAS_SUPPORTING_INFORMATION

RECORD/FIELD_NAME
*Occurs Max 50300* / OPT / DOM / LNG / DEC / DESCRIPTION
TRANSACTION_TYPE / M / T / 3 / 0 / DEFINITION: A code identifying the type of request that this record represents.
VALUE:K55
LOGICAL_METER_NUMBER OUG_METER_ID / M / T / 10 / 0 / The Logical Meter Number that identifies the Site
DEFINITION:Meter Unique Identifier
GAS_FLOW_DAY / M / D / 8 / 0 / DEFINITION: The date to which the gas allocation relates
FORMAT:YYYYMMDD
DAILY_ALLOCATED_ENERGY ALLOCATED_QUANTITY / M / N / 15 / 0 / DEFINITION: Daily allocated quantity in kWhs (Per Gas Flow Day)
OWN_USE_GAS_RATE_CHARGE_(P/k wh)
OWN_USE_GAS_RATE / M / N / 810 / 4 / DEFINITION: Charge Rate (Pence per kWh)
OWN_USE_GAS_CHARGE(£) OWN_USE_GAS_CHARGE / M / N / 14 / 2 / DEFINITION: Own Use Gas Charge per Gas Flow Day.
VALUE:Monetary values from -99999999999.99 to 99999999999.99
Total / 60

AI_O_OWN_USE_GAS_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: 179

Own_Use_Gas_Supporting_Information (.OSG) Page 1 of 9 Submission Date: 07/10/2014
Version: 1.1For Approval Implementation Date: 01/10/2015