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 |
|
|
|