|
Name |
|
|
Comment |
List of delivery point preferences if delivery points are overridden. Child record of GSH_DELIVERY_NETT_PREFS |
|
Name |
Comment |
Value |
|
Visibility |
Data confidentiality of this table |
Private |
|
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 |
|
|
|