Table: GAS_GSH_TRADES

GAS_GSH_TRADES

Name

GAS_GSH_TRADES

Comment

Provides participants (buyer and seller) a confirmation whenever a trade is executed through auto matching of bids and offers or by off-market trades. Also provides participants with a list of all their future trades when triggered daily after the end of the trades for the current day


Primary Key Columns

Name

LOCATION

PRODUCT

TRADE_DATE

TRADE_PRICE

TRANSACTION_TYPE


Content

Name

Data Type

Mandatory

Comment

TRADE_DATE

DATE

X

Date and time the trade is executed

TRANSACTION_TYPE

VARCHAR2(20)

X

The type of the trade. Valid values are AUTO_MATCHED, OFF_MARKET_TRADE

PRODUCT

VARCHAR2(80)

X

The product delivery period for the Gas Supply Hub market

LOCATION

VARCHAR2(100)

X

Product location for the Gas Supply Hub market

NO_OF_TRADES

NUMBER(10)

 

Count of number of trades

TRADE_PRICE

NUMBER(18,8)

X

Price value of the trade in $/GJ

DAILY_QTY_GJ

NUMBER(18,8)

 

Volume of gas transacted on the Trading Platform in GJ/day

START_DATE

DATE

 

The start gas day for the order delivery period

END_DATE

DATE

 

The end gas day for the order delivery period

MANUAL_TRADE

VARCHAR2(50)

 

Whether the trade is a manual trade

LASTCHANGED

DATE

 

The date the record was last updated