Table: GSH_SUPP_SERVICES

GSH_SUPP_SERVICES

Name

GSH_SUPP_SERVICES

Comment

This report adds details from the settlements run for the new Wallumbilla Compression Services product. It is produced when a settlements run is completed.


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 delivery variance payment or charge. Disregard the time component as this is not applicable.

TYPE

VARCHAR2(20)

X

Type of the delivery variance amount whether it is a charge or a payment.

BILLING_PERIOD

VARCHAR2(20)

 

The billing period for the settlement run.

AMOUNT

NUMBER(18,8)

 

Total amount of delivery variance charge or payment for the gas date excluding GST.

GST_AMOUNT

NUMBER(18,8)

 

Total amount of GST on the delivery variance payment or charge for the gas date.