Name |
|
Comment |
List of delivery point preferences if delivery points are overridden. Child record of GSH_DELIVERY_NETT_PREFS |
Name |
MARKET_ID |
PARTICIPANT_CODE |
POSITION_TYPE |
PRIORITY |
PRODUCT_LOCATION |
VERSION_DATETIME |
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 |
|
|
|