Transporter Site Visit Invoice Supporting Information (.TDS)

File Format Document

Transporter_Site_Visit_Invoice_Supporting_Information (.TDS)

Transporter to System User

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: / 2.1
Status: / For Approval
Date: / 07-Oct-2014

Version Control

Version / COR / Issue Date / Implementation Date / Summary of Change
1 / Current Live Version
0.1 / 1154 / 20-Aug-2014 / 01-Oct-2015 / Prelimany File. File issued for representation. Description Rationalisation.
Record Type: A00
GENERATION_NUMBER: Optional
Record Type: Q28
INVOICE_NUMBER: length from 6 12
ADHOC_REFERENCE_NUMBER renamed to
ANCILLARY_REFERENCE_NUMBER
INVOICE_AMOUNT_DUE renamed to INVOICE_AMOUNT length from 12 to 14.
Record Type Q29
CHARGE TYPE AMOUNT length from 12 to 14.
Record Type: T92
INVOICE_NUMBER removed
MOP_REFERENCE renamed to SUPPLY_METER_POINT
METER_SERIAL_NUMBER: fron M to O
PRINCIPAL_STREET, POST_TOWN and COUNTY, All have changed their length from 35 to 40.
POSTCODE_OUTCODE and POSTCODE_INCODE amended to POSTCODE INCODE/OUTCODE
METER_REMOVAL_SITE_VISIT replaced with METER_REMOVAL_DATE
CHARGE_VALUE renamed to CHARGE_TYPE_AMOUNT length from 12 to 14
CMS_REFERNCE_NUMBER is a new field
COMMENTS , Lengths from 250 - 100
SITE_VISIT_DATE new field
2 / 1154 / 30-Sep-2014 / 1-Oct-2015 / File issued for representation. Description Rationalisation.
Record Type: A00
FILE_TYPE: Value TDS
GENERATION_NUMBER: M
Record Type: Q28
OCCURS MAX: from 5 to 10
SHIPPER_SHORT_CODE renamed to ORGANISATION_SHORT_CODE
ADHIOC_REFERENCE_NUMBER removed
Record Type: Q29
OCCURS MAX: from 10 to 60
INVOICE_TYPE_CODE: Value: TSV
CHARGE_TYPE_AMOUNT renamed to CHARGE_AMOUNT
Record Type: T92
INVOICE_NUMBER: put back into record
METER SERIAL NUMBER ‘M’ TO ‘O’
BUILDING NUMBER kength from 10 to 4
SHIPPER_SHORT_CODE renamed to ORGANISATION_SHORT_CODE
SHIPPERLESS EFFECTIVE DATE from ‘M’ to ‘O’
METER REMOVAL/SITE VISIT DATE - Removed
CHARGE_TYPE_AMOUNT renamed to CHARGE_AMOUNT
COMMENTS: Length 250
2.1 / 1154 / 07-Oct-2014 / 01-Oct-2015 / File issued for representation.
Total Record length corrected. Invoice Number length corrected in T92 record
Contains5different Record Types
`
Level / Record Name / Occurrence / Optionally
1 / HD_A00_STANDARD_HEADER / 1 / M
1 / RT_Q28_STANDARD_INVOICE_SUMMARY / Up to 5 10 / M
2 / RT_Q29_STANDARD_CHARGE_TYPE_SUMMARY / Up to 6010 / M
3 / RT_T92_SITE_VISIT_CHARGE_DETAIL / Upto 5000 / 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 ("")

Transporter_Site_Visit_Invoice_Supporting_Information (.TDS) Page 1 of 10 Submission Date: 07/10/2014
Version 2.1 For Approval Implementation Date: 01/10/2015

Record Type Definition

AI_O_Transporter_Site_Visit_Charges_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:TDS
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_Transporter_Site_Visit_ChargeS_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
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:TSV
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 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. 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
INVOICE_AMOUNT_DUE / M / N / 1412 / 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 / 4446

AI_O_Transporter_Site_Visit_ChargeS_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:TSV
CHARGE_TYPE_CODE / M / T / 3 / 0 / DEFINITION: A unique three character code used to identify the charge type/s.
VALUE: M44, M46, M49, M45, M47, M48
Following is the charge description:
M44 – DISABLEMENT OF SUPPLY - DEBIT
M46 – GSR DN ABORTED SITE VISIT CR
M49 – MUS DN SITE VISIT DR
M45 – DISABLEMENT OF SUPPLY - CREDIT
M47 – GSR DN ABORTED SITE VISIT DR
M48 – MUS DN SITE VISIT CR
CHARGE_AMOUNT
CHARGE_TYPE_AMOUNT / M / N / 14
12 / 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
24

AI_O_Transporter_Site_Visit_ChargeS_Invoice_Supporting_Information

RT_T92_SITE_VISIT_CHARGE_DETAIL

RECORD/FIELD_NAME
*Occurs Max 5000* / OPT / DOM / LNG / DEC / DESCRIPTION
TRANSACTION TYPE / M / T / 3 / 0 / DEFINITION: A code identifying the type of request that this record represents.
VALUE: T92
INVOICE_NUMBER / M / N / 612 / 0 / DEFINITION: Invoice Number relating to the appropriate Invoice Summary
DEFINITION:Holds the unique number by which an invoice is known
CHARGE_TYPE_CODE / M / T / 3 / 0 / DEFINITION: A unique three character code used to identify the charge type/s.
VALUE: M44, M46, M49, M45, M47, M48
Following is the charge description:
M44 – DISABLEMENT OF SUPPLY - DEBIT
M46 – GSR DN ABORTED SITE VISIT CR
M49 – MUS DN SITE VISIT DR
M45 – DISABLEMENT OF SUPPLY - CREDIT
M47 – GSR DN ABORTED SITE VISIT DR
M48 – MUS DN SITE VISIT CR
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
Identifies the Local Distribution
Zone to which the supply point is
associated
SUPPLY_METER_POINT
MPO_REFERENCE / 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.
METER_SERIAL_NUMBER / OM / T / 14 / 0 / DEFINITION: The manufacturers meter serial number.
CONTEXT: The serial number of the meter from which the meter read was taken.
BUILDING_NUMBER / O / NT / 410 / 0 / DEFINITION: Building Number as defined in
PAF.
BUILDING_NAME / O / T / 50 / 0 / DEFINITION: Building Name as defined in PAF.
PRINCIPAL_STREET / M / T / 40
35 / 0 / DEFINITION: A combination
THOROUGHFARE NAME and
THOROUGHFARE
DESCRIPTOR as defined in PAF.
POST_TOWN / O / T / 40
35 / 0 / DEFINITION: The post town in which the street lies.
CONTEXT: Post Town as defined in PAF.
COUNTY / O / T / 40
35 / 0 / DEFINITION: The county in which the street lies. This meaning is equivalent to that of the PAF field of the same name.
The post county in which the town
lies. CONTEXT: County as
defined in PAF
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
ORGANISATION_SHORT_CODE
SHIPPER_SHORT_CODE / M / T / 3 / 0 / DEFINITION: This field identifies the three character unique organisation short code.
The three character code used to
identify each Shipper
SHIPPERLESS_EFFECTIVE_DATE / OM / D / 8 / 0 / DEFINITION: The date on which the site became Shipperless, Confirmation End Date D+1
FORMAT: YYYYMMDD
METER_REMOVAL_SITE_VISIT_DATE / M / D / 8 / 0 / The date on which the Meter was removed or site visit occurred.
Format:YYYMMDD
METER_REMOVAL_DATE / O / D / 8 / 0 / DEFINITION: The date on which the Meter was removed
FORMAT: YYYYMMDD
CHARGE_AMOUNT
CHARGE_VALUE / M / N / 1412 / 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
Holds sum of invoice amount due
for all invoice items on the
invoice. The first character would
be prefixed with a negative ‘-‘ if
its is a payment to the user
VALUES: Monetary Values 0 to
9999999999.99
CMS_REFERENCE_NUMBER / O / N / 10 / 0 / DEFINITION: The reference number for the
associated CMS contact
COMMENTS / O / T / 250 / 0 / DEFINITION: Any comments to help validate
the resulting supporting
information
SITE_VISIT_DATE / M / D / 8 / 0 / DEFINITION: The date on which the Site Visit
occurred
FORMAT: YYYYMMDD
Total / 497532

AI_O_Transporter_Site_Visit_ChargeS_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:645 651

Transporter_Site_Visit_Invoice_Supporting_Information (.TDS) Page 1 of 10 Submission Date: 07/10/2014
Version 2.1 For Approval Implementation Date: 01/10/2015