|
Name |
|
|
Comment |
MNSP_OFFERTRK records all valid MNSPOFFERS loaded into the MMS system. The authorised date reflects the date and time of the load. MNSP_OFFERTRK is key for tracking MNSP bid submission. |
|
MNSP_OFFERTRK shows own (confidential) data updates as bids are processed. All bids are available as part of next day market data. Volume 4000 per year |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private; Public Next-Day |
|
Name |
|
FILENAME |
|
OFFERDATE |
|
PARTICIPANTID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
|
|
OFFERDATE |
DATE |
X |
|
|
VERSIONNO |
NUMBER(3,0) |
X |
|
|
PARTICIPANTID |
VARCHAR2(10) |
X |
|
|
FILENAME |
VARCHAR2(40) |
X |
|
|
AUTHORISEDDATE |
DATE |
|
|
|
AUTHORISEDBY |
VARCHAR2(15) |
|
|
|
LASTCHANGED |
DATE |
|
|
|
|
|