|
Name |
|
|
Comment |
Provides trading participants a confirmation whenever an EFP trade is submitted to AEMO |
|
Name |
|
RECORD_ID |
|
Name |
Data Type |
Mandatory |
Comment |
|
RECORD_ID |
VARCHAR2(20) |
X |
The unique identifier of the record |
|
MARKET_ID |
VARCHAR2(20) |
|
The unique Market ID |
|
PARTICIPANT_ID |
VARCHAR2(20) |
|
The unique identifier of the participant |
|
GAS_FUTURE_ID |
VARCHAR2(20) |
|
The EFP Trade ID for matching trades |
|
PRODUCT_GROUP_CODE |
VARCHAR2(20) |
|
AEMO uses a default value only: GAS-WAL. Data submitted by participants is not stored |
|
PRODUCT_TYPE_CODE |
VARCHAR2(20) |
|
AEMO uses a default value only: NG Months. Data submitted by participants is not stored |
|
DELIVERY_POINT |
VARCHAR2(40) |
|
AEMO uses a default value only: WAL HP Trade Point. Data submitted by participants is not stored |
|
START_DATE |
DATE |
|
The gas start day for the EFP trade period |
|
END_DATE |
DATE |
|
The gas end day for the EFP trade period |
|
TRADE_TYPE |
VARCHAR2(20) |
|
Buy or Sell |
|
VOLUME |
NUMBER(18,8) |
|
Trade quantities measured in GJ for each Gas Day in the Delivery Period |
|
PRICE |
NUMBER(18,8) |
|
Trade price |
|
STATUS |
VARCHAR2(20) |
|
Submission Status: PENDING, FAIL, MATCH, OVERRIDE |
|
VALIDATION_MSG |
VARCHAR2(255) |
|
Submission validation message |
|
SUBMITTED_TIME |
DATE |
|
Data submission time |
|
LASTCHANGED |
DATE |
|
The date and time the report is generated |
|
|
|