|
Name |
|
|
Comment |
Provide a history of Delivery Netting Preferences entered through the new Delivery Netting Web Interface. |
|
Name |
|
MARKET_ID |
|
PARTICIPANT_CODE |
|
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 |
|
START_DATE |
DATE |
|
Date preference takes effect from |
|
END_DATE |
DATE |
|
Date preference takes effect until |
|
CHOSEN_POSITION |
VARCHAR2(20) |
|
Type of position used. Valid values are: NET, BUY/SELL |
|
USE_TRANSACTIONS |
VARCHAR2(1) |
|
Whether original delivery points specified in trades will be used. Valid values are Y | N |
|
USE_GROUPS |
VARCHAR2(1) |
|
Indicates if positions are matched using groups. Valid values are Y | N |
|
LAST_UPDATED |
DATE |
|
The date and time the preference was updated |
|
LAST_UPDATED_BY |
VARCHAR2(20) |
|
The user name who updated the preference |
|
LASTCHANGED |
DATE |
|
The date and time the report was generated |
|
|
|