Table: GAS_SEC_CAP_ORDERS

GAS_SEC_CAP_ORDERS

Name

GAS_SEC_CAP_ORDERS

Comment

Information related to the bids and offers of secondary pipeline capacity, which is derived from a secondary pipeline capacity trading platform


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

OrderId


Index Columns

Name

SUBMITTINGCOMPANYID

VERSIONDATETIME


Index Columns

Name

FROMGASDATE

TOGASDATE


Content

Name

Data Type

Mandatory

Comment

OrderId

VARCHAR2(40)

X

Unique identifier for the order

SubmittingCompanyId

NUMBER(10,0)

 

Name of the company submitting the data to AEMO

VersionDateTime

DATE

 

Version timestamp of the record

FacilityId

NUMBER(10,0)

 

Unique facility Identifier

BuySell

VARCHAR2(5)

 

Indicates whether the shipper is either looking to buy or sell spare capacity

AvailableQuantity

NUMBER(18,3)

 

Quantity of actual flow for the gas date

Price

NUMBER(18,2)

 

Spare capacity price expressed in $ per GJ

FromGasDate

DATE

 

Date spare capacity comes into effect

ToGasDate

DATE

 

Date spare capacity is effective to

ReceiptLocation

NUMBER(10,0)

 

Connection Point ID that best represents the receipt location

DeliveryLocation

NUMBER(10,0)

 

Connection Point ID that best represents the Delivery Location

ContactDetails

VARCHAR2(1000)

 

Name and number of the shippers contact person

LastChanged

DATE

 

Last changed date for the record