Name |
|
Comment |
The Settlements Supporting Data Report is generated when Final and Revision settlement statements are issued; it is also generated daily with details of the latest initial settlement run of the day. The report contains settlements summary information as well as participant specific data from that settlement run for the relevant charges and payments per gas day. It provides a breakdown of all executed trades and delivered quantities records included in this settlement run to assist participant in their settlement statements reconciliation. The Reallocations subreport provides a list of all individual reallocations included in the settlement run per gas day. |
Name |
GAS_DATE |
PARTICIPANT_CODE |
REALLOCATION_ID |
SETTLEMENT_RUN_ID |
Name |
Data Type |
Mandatory |
Comment |
SETTLEMENT_RUN_ID |
NUMBER(18,0) |
X |
The unique identifier for the settlement run |
PARTICIPANT_CODE |
VARCHAR2(20) |
X |
The participant code |
GAS_DATE |
DATE |
X |
The gas date for the reallocation |
REALLOCATION_ID |
VARCHAR2(20) |
X |
The unique identifier for the reallocation |
BILLING_PERIOD |
VARCHAR2(20) |
|
The billing period for the settlement run, note that the billing period will only have value for Final and Revision settlement run types, and it will be null for the initial settlement run |
REALLOCATION_SIDE |
VARCHAR2(20) |
|
This field specifies whether the participant was the credit or the debit party of the reallocation agreement |
AGREEMENT_TYPE |
VARCHAR2(80) |
|
The type of the reallocation agreement |
REFERENCE_PRICE |
NUMBER(18,8) |
|
The reference price used for Fixed Quantity Amount agreement type |
AMOUNT |
NUMBER(18,8) |
|
The daily dollar or quantity amount of the reallocation for the specified gas date |
|
|
|