|
Name |
|
|
Comment |
The purpose of this report is to provide the Participant a confirmation whenever an order (bid or offer) is submitted, amended, or cancelled. |
|
Name |
|
MARKET_ID |
|
ORDER_ID |
|
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 |
|
|
|