Table: GSH_DELIVERY_NETT_POINTS

GSH_DELIVERY_NETT_POINTS

Name

GSH_DELIVERY_NETT_POINTS

Comment

List of delivery point preferences if delivery points are overridden. Child record of GSH_DELIVERY_NETT_PREFS


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

MARKET_ID

PARTICIPANT_CODE

POSITION_TYPE

PRIORITY

PRODUCT_LOCATION

VERSION_DATETIME


Content

Name

Data Type

Mandatory

Comment

MARKET_ID

VARCHAR2(20)

X

Unique Market ID

PARTICIPANT_CODE

VARCHAR2(20)

X

The participant code

PRODUCT_LOCATION

VARCHAR2(80)

X

Product location for the GSH market

VERSION_DATETIME

DATE

X

Date and time preference entered

POSITION_TYPE

VARCHAR2(20)

X

Type of position used. Valid values are: NET, BUY, SELL

PRIORITY

NUMBER(3,0)

X

Order of priority for overriding delivery points

DELIVERY_POINT

VARCHAR2(40)

 

Name of delivery point

VOLUME

NUMBER(18,8)

 

Amount (Gj) to assign to delivery point

LAST_UPDATED

DATE

 

The date and time the preference was updated

LASTCHANGED

DATE

 

The date and time the report was generated