Table: GSH_DELIVERED_QUANTITY

GSH_DELIVERED_QUANTITY

Name

GSH_DELIVERED_QUANTITY

Comment

The purpose of this report is to provide the Participants (buyer and seller) an acknowledgement whenever a delivered quantity record is submitted or confirmed. The report will also provide Participants with a list of all their delivered quantity records updated within the last thirty days when triggered daily prior to the start of trades for the current day.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

GAS_DATE

TRANSACTION_ID

VERSION_DATETIME


Content

Name

Data Type

Mandatory

Comment

GAS_DATE

DATE

X

The delivery gas day of the trade

TRANSACTION_ID

VARCHAR2(20)

X

Unique identifier for the transaction

VERSION_DATETIME

DATE

X

The date and time of when the entry was last modified in the source table.

BUYER_PARTICIPANT_CODE

VARCHAR2(20)

 

The participant code used in the Exchange Trading System (ETS)

BUYER_PARTICIPANT_NAME

VARCHAR2(80)

 

The name for the participant on buy side of the trade

SELLER_PARTICIPANT_CODE

VARCHAR2(20)

 

The participant code used in the Exchange Trading System (ETS) for the participant on the seller side of the trade

SELLER_PARTICIPANT_NAME

VARCHAR2(80)

 

The name for the participant on seller side of the trade

PRODUCT_LOCATION

VARCHAR2(80)

 

The product location for the Gas Supply Hub market

TRANSACTION_QUANTITY

NUMBER(18,8)

 

Initial gas volume of the transaction in GJ/day

SETTLEMENTS_OFF_MARKET

VARCHAR2(1)

 

Indicates whether the buyer and seller wish to settle the delivery variance outside of the GSH market. Valid values are: Y, N

DELIVERED_QUANTITY

NUMBER(18,8)

 

The delivered quantity in GJ/day

REASON_FOR_VARIATION

VARCHAR2(80)

 

The reason for the variance in the delivered quantity

STATUS

VARCHAR2(20)

 

The status of the delivery confirmation. Valid values are: SUBMITTED, CONFIRMED

LAST_UPDATED_BY_PARTICIPANT

VARCHAR2(20)

 

The participant code used in the Exchange Trading System (ETS) for the participant who last updated the delivered quantity record

LAST_UPDATED

DATE

 

The date and time the delivered quantity was updated i.e. saved into database

LASTCHANGED

DATE

 

The date and time the report was generated

ETS_TRADE_ID

VARCHAR2(20)

 

The exchange transaction ID associated with the delivery obligation for transactions in non-netted products. This field can be cross referenced with the TRADE_ID field in the Trade Execution report to identify the transaction price.
This field is empty for trades involving netted products