Table: GSH_SUPP_ADHOC

GSH_SUPP_ADHOC

Name

GSH_SUPP_ADHOC

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 Adhoc subreport provides a list of all individual ad-hoc payments and charges included in the settlement run.


Primary Key Columns

Name

GAS_DATE

PARTICIPANT_CODE

SETTLEMENT_RUN_ID

TYPE


Content

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 ad-hoc payment or charge

TYPE

VARCHAR2(20)

X

Type of the ad-hoc amount whether it is a charge or a payment

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

AMOUNT

NUMBER(18,8)

 

Total amount of ad-hoc charge or payment for the gas date excluding GST

GST_AMOUNT

NUMBER(18,8)

 

Total amount of GST on the ad-hoc payment or charge for the gas date

ADHOC_DESCRIPTION

VARCHAR2(255)

 

The description of the adhoc payment