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 Settlement Summary subreport provides summary details of the settlement run. |
Name |
PARTICIPANT_CODE |
REVISION_SETTLEMENT_RUN_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 |
REVISION_SETTLEMENT_RUN_ID |
NUMBER(18,0) |
X |
Identifier of the revision included if the settlement run is of type ‘Final’. |
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 |
PARTICIPANT_NAME |
VARCHAR2(80) |
|
The name of the participant |
NET_SETTLEMENT_AMOUNT |
NUMBER(18,8) |
|
Sum of all payments and charges exclusive of GST |
NET_SETTLEMENT_AMOUNT_GST |
NUMBER(18,8) |
|
Sum of all GST amounts on payments and charges |
TOTAL_REALLOCATION_DEBIT_AMT |
NUMBER(18,8) |
|
Sum of all reallocation debit amounts included in the settlement |
TOTAL_REALLOCATION_CREDIT_AMT |
NUMBER(18,8) |
|
Sum of all reallocation credit amounts included in the settlement |
TOTAL_SECURITY_DEPOSITS |
NUMBER(18,8) |
|
The total of all security deposits included in the settlement run. This value will always be a negative value for consistency with invoices (multiplied with -1) |
SECURITY_DEPOSIT_INTEREST |
NUMBER(18,8) |
|
Total interest amounts calculated on security deposits. This value will always be a negative value for consistency with invoices (multiplied with -1) |
SETTLEMENT_ADJUSTMENT_AMOUNT |
NUMBER(18,8) |
|
Adjustment amount of the settlement if applicable |
INTEREST_ON_REVISION |
NUMBER(18,8) |
|
Amount of interest calculated for revision statement if the run type is Revision |
TOTAL_PAYABLE_AMOUNT |
NUMBER(18,8) |
|
The net payable amount for this settlement run |
|
|
|