File Format Document
Meter_Assets_Invoice_Supporting_Information (.MIF)
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: / XoserveOwner: / Xoserve
Version: / 1.1
Status: / For Approval
Date: / 07-Oct-2014
Version Control
Version / COR / Issue Date / Implementation Date / Summary of Change0.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. Minor changes in Q28 record to highlight the redundant field.
Contains 6 different 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_K49_METER_ASSETS_DETAIL / Up to 300 / M
3 / RT_K50_METER_PORTFOLIO_DETAIL / 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 ("")
Meter_Assets_Invoice_Supporting_Information (.MIF) Page 1 of 11 Submission Date: 07/10/2014
Version 1.1 For Approval Implementation Date: 01/10/2015
Record Type Definition
AI_O_METER_ASSETS_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:MIF
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_METER_ASSETS_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:MAS
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 / 4644
AI_O_METER_ASSETS_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: MAS
CHARGE_TYPE_CODE / M / T / 3 / 0 / DEFINITION: A unique three character code used to identify the charge type/s.
VALUE:N01, N18, N19, N20, P03
Following is the charge description:
N01–METER ASSET CHARGE
N18 – METER ASSET CHARGE - NTS
N19 –CORRECTOR ASSET CHARGE - LDZ
N20 – CORRECTOR ASSET CHARGE - NTS
P03 -DATALOGGER ASSET CHARGE
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_METER_ASSETS_Invoice_Supporting_Information
RT_K49_METER_ASSETS_DETAIL
RECORD/FIELD_NAME*Occurs Max 300* / OPT / DOM / LNG / DEC / DESCRIPTION
TRANSACTION TYPE / M / T / 3 / 0 / DEFINITION: A code identifying the type of request that this record represents.
VALUE: K49
START_DATE / M / D / 8 / 0 / Defines the start date of the period for which the charge item is calculated. Format: YYYYMMDD
END_DATE / M / D / 8 / 0 / Defines the end date of the period for which the charge item is calculated.
Format: YYYYMMDD
CHARGE_TYPE_CODE / M / T / 3 / 0 / DEFINITION: A unique three character code used to identify the charge type/s.
VALUE: N01, N18, N19, N20, P03
Following is the charge description:
N01 – METER ASSET CHARGE
N18 – METER ASSET CHARGE - NTS
N19 –CORRECTOR ASSET CHARGE - LDZ
N20 – CORRECTOR ASSET CHARGE - NTS
P03 - DATALOGGER ASSET CHARGE
CHARGE_ITEM / M / T / 1 / 0 / DEFINITION: Identifies the Charge Item Type – Installation, Provisional, and Maintenance.
VALUE: I, P, M
SITE_NAME / M / T / 50 / 0 / DEFINITION: The name of the site associated to the Supply Meter Point(s).
SUPPLY_POINT_CONFIRMATION_REFERENCE / O / T / 10 / 0 / DEFINITION: A reference that uniquely identifies the Confirmation
SUPPLY_METER_POINT / 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_ON_SITE / M / N / 3 / 0 / DEFINITION: Holds the number of shippers at the site.
ASSETS_ON_SITE / M / N / 3 / 0 / DEFINITION: Holds the number of assets at the site.
LDZ_IDENTIFIER / O / T / 4 / 0 / DEFINITION: Identifies the Local Distribution Zone to which the supply meter point is associated
NTS_IDENTIFIER / O / T / 4 / 0 / DEFINITION: Identifies the NTS to which the supply meter point is associated
NWO_SHORT_CODE / M / T / 3 / 0 / DEFINITION: A unique three character code used to identify a Network Operator
BILLABLE_DAYS / M / N / 2 / 0 / DEFINITION: Number of days in the billing period
UNIT_RATE / M / N / 10 / 4 / DEFINITION: The rate in pence per day which was used to calculate the charge.
CHARGE_AMOUNT / M / N / 14 / 2 / DEFINITION: Net Charge Amount; Negative values will have a prefix (-).
VALUE: Monetary values from -99999999999.99 to 99999999999.99
Total / 136
AI_O_METER_ASSETS_Invoice_Supporting_Information
RT_K50_METER_PORTFOLIO_DETAIL
RECORD/FIELD_NAME*Occurs Max 300* / OPT / DOM / LNG / DEC / DESCRIPTION
TRANSACTION TYPE / M / T / 3 / 0 / DEFINITION: A code identifying the type of request that this record represents.
VALUE: K50
SHIPPERS_ON_SITE / M / N / 3 / 0 / DEFINITION: Holds the number of shippers at the site.
SITE_NAME / M / T / 50 / 0 / DEFINITION: The name of the site associated to the Supply Meter Point(s).
DATALOGGERS_ON_SITE / M / N / 3 / 0 / DEFINITION: Holds the number of Dataloggers at the site.
CORRECTORS_ON_SITE / M / N / 3 / 0 / DEFINITION: Holds the number of Correctors at the site.
SUPPLY_POINT_CONFIRMATION_REFERENCE / O / T / 10 / 0 / DEFINITION: A reference that uniquely identifies the Confirmation
SUPPLY_METER_POINT / 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_TYPE / M / T / 15 / 0 / DEFINITION: Holds the meter type description.
VALUE: ROTARY, ORIFICE, TURBINE
METER_SIZE / M / N / 10 / 0 / DEFINITION: Holds the value of meter size.
PROVISIONAL_CHARGE_INDICATOR / M / T / 1 / 0 / DEFINITION: Identifies whether Provisional Charge is applicable to the asset/site.
VALUE: Y/N
INSTALLATION_CHARGE_INDICATOR / M / T / 1 / 0 / DEFINITION: Identifies whether Installation Charge is applicable to the asset/site.
VALUE: Y/N
MAINTENANCE_CHARGE_INDICATOR / M / T / 1 / 0 / DEFINITION: Identifies whether Maintenance Charge is applicable to the asset/site.
VALUE: Y/N
LOWER_BAND_LIMIT / M / N / 10 / 0 / DEFINITION: Holds the lower band limit value
UPPER_BAND_LIMIT / M / N / 10 / 0 / DEFINITION: Holds the upper band limit value
Total / 130
AI_O_METER_ASSETS_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: 391385
Version Control
Version / COR / Issue Date / Implementation Date / Summary of Change0.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
Meter_Assets_Invoice_Supporting_Information (.MIF) Page 1 of 11 Submission Date: 07/10/2014
Version 1.1 For Approval Implementation Date: 01/10/2015