Table: GSH_ORDERS

GSH_ORDERS

Name

GSH_ORDERS

Comment

The purpose of this report is to provide the Participant a confirmation whenever an order (bid or offer) is submitted, amended, or cancelled.


Primary Key Columns

Name

MARKET_ID

ORDER_ID


Content

Name

Data Type

Mandatory

Comment

MARKET_ID

VARCHAR2(20)

X

Unique Market ID

ORDER_ID

VARCHAR2(20)

X

Unique order id generated by the Trading Platform on submission of the order

PARTICIPANT_CODE

VARCHAR2(20)

 

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

PARTICIPANT_NAME

VARCHAR2(80)

 

The name of the participant that the order belongs to

PRODUCT_LOCATION

VARCHAR2(80)

 

Product location for the Gas Supply Hub market

PRODUCT_TYPE

VARCHAR2(80)

 

The product delivery period for the Gas Supply Hub market

FROM_GAS_DATE

DATE

 

The start gas day for the order delivery period

TO_GAS_DATE

DATE

 

The end gas day for the order delivery period

ORDER_DATE

DATE

 

The date and time that the order is submitted on

ORDER_STATUS

VARCHAR2(20)

 

The status of the order. Valid values are: NEW, UPDATE, CANCELLED

ORDER_SIDE

VARCHAR2(5)

 

This field is to indicate whether the order is a Bid or Offer

ORDER_QUANTITY

NUMBER(18,8)

 

Gas volume of the order in GJ/day

ORDER_PRICE

NUMBER(18,8)

 

Price value of the order in $/GJ

EXPIRY_TYPE

VARCHAR2(80)

 

Order expiry type, for example (Good Till Cancelled, Good For Day, Good Till Date)

EXPIRY_DATE

DATE

 

Date and time the order will expire. Only applies to "Good_Till_Date" expiry type

DELIVERY_POINT

VARCHAR2(40)

 

Delivery Point specified by the seller in an order submission for non-netted commodity products, or the buyer or seller in an order submission for capacity products

LAST_UPDATED

DATE

 

The date and time the bid/offer was updated i.e. saved into database

LAST_UPDATED_BY

VARCHAR2(20)

 

The user name used in the bid/offer submission

LASTCHANGED

DATE

 

The date and time the report was generated

ALL_OR_NONE

NUMBER(1,0)

 

Populated if the trading participant selects the "All or None" option when submitting an order

DURATION

VARCHAR2(20)

 

Time from order submission until expiry. Data has day format (ISO 8601)

HIDDEN_VOLUME

NUMBER(18,8)

 

Populated if the trading participant specifies a "Hidden Volume" when submitting an order

RECEIPT_POINT

VARCHAR2(40)

 

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

VALID_SERVICE_REFERENCE

VARCHAR2(3)

 

Flag to indicate whether a valid service reference exists for the capacity product. Will be NULL for orders involving commodity products

VALID_STTM_CONTRACT_REFERENCE

VARCHAR2(3)

 

Flag to indicate whether a valid STTM contract reference exists for the capacity product. Will be NULL for orders involving commodity products and non-STTM integrated capacity products

VALID_DWGM_REFERENCE

VARCHAR2(3)

 

Flag to indicate whether a valid DWGM accreditation reference exists for the capacity product where a DWGM interface point has been specified. Will be NULL for orders involving commodity products and capacity products that do not have a DWGM interface point specified