Table: GSH_DELIVERY_OBLIGATIONS

GSH_DELIVERY_OBLIGATIONS

Name

GSH_DELIVERY_OBLIGATIONS

Comment

The purpose of this report is to provide the Participants with their Delivery Obligations at each location. Delivery Obligation quantities are results of the delivery netting process.


Primary Key Columns

Name

NETTING_TRANSACTION_ID


Content

Name

Data Type

Mandatory

Comment

NETTING_TRANSACTION_ID

VARCHAR2(20)

X

The unique identifier of the delivery transaction.

BUYER_PARTICIPANT_CODE

VARCHAR2(20)

 

The unique identifier for the participant on buy side of the trade that has an obligation to receipt gas
OR
The unique code for the participant with net zero position.

BUYER_PARTICIPANT_NAME

VARCHAR2(80)

 

The name for the participant on buy side of the trade that has an obligation to receipt gas
OR
The name of the participant with net zero position.

SELLER_PARTICIPANT_CODE

VARCHAR2(20)

 

The unique identifier for the participant on seller side of the trade that has an obligation to deliver gas
OR
The unique code for the participant with net zero position.

SELLER_PARTICIPANT_NAME

VARCHAR2(80)

 

The name for the participant on seller side of the trade that has an obligation to deliver gas
OR
The name of the participant with net zero position.

FROM_GAS_DATE

DATE

 

The first gas date in the netting period.

TO_GAS_DATE

DATE

 

The last gas date of the netting period.

PRODUCT_LOCATION

VARCHAR2(80)

 

The product location, product grouping code for the Gas Supply Hub market

DELIVERY_QUANTITY

NUMBER(18,8)

 

The quantity of the delivery transaction GJ/day
OR
Zero if the participant has a zero net position.

DELIVERY_POINT

VARCHAR2(40)

 

Delivery point/s and associated quantities determined as part of SUC7407a – Perform Participant Location Netting.
OR
NULL if the participant has a zero net position.

DELIVERY_TYPE_ALERT

VARCHAR2(20)

 

This field is empty if the transaction is an output of the delivery-netting module.
If the transaction is an original executed trade (due to a system failure), this field shows “Individual Contract Delivery”.

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.

RECEIPT_POINT

VARCHAR2(40)

 

Receipt point specified by the buyer or seller in an order submission for capacity products