Table: GSH_SUPP_CAPACITY_AUCTION

GSH_SUPP_CAPACITY_AUCTION

Name

GSH_SUPP_CAPACITY_AUCTION

Comment

Includes Auction items won that are included in the settlement run


Primary Key Columns

Name

GAS_DATE

PARTICIPANT_CODE

SETTLEMENT_RUN_ID

TYPE


Content

Name

Data Type

Mandatory

Comment

MARKET_ID

VARCHAR2(20)

 

Unique Market ID

SETTLEMENT_RUN_ID

NUMBER(18,0)

X

The unique identifier for the settlement run.

BILLING_PERIOD

VARCHAR2(20)

 

The billing period for the settlement run.

PARTICIPANT_CODE

VARCHAR2(20)

X

The participant code.

GAS_DATE

DATE

X

The gas date for the capacity auction payment or charge. Disregard the time component as this is not applicable.

TYPE

VARCHAR2(20)

X

Type of the capacity auction amount whether it is a charge or a payment.

AMOUNT

NUMBER(18,8)

 

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

GST_AMOUNT

NUMBER(18,8)

 

Total amount of GST on the capacity auction payment or charge for the gas date.