Table: GSH_DELIVERY_NETT_PREFS

GSH_DELIVERY_NETT_PREFS

Name

GSH_DELIVERY_NETT_PREFS

Comment

Provide a history of Delivery Netting Preferences entered through the new Delivery Netting Web Interface.


Primary Key Columns

Name

MARKET_ID

PARTICIPANT_CODE

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

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