|
Name |
|
|
Comment |
SETMARKETFEES shows payments for market fees for each settlement date. |
|
SETMARKETFEES is confidential data. Source SETMARKETFEES updates with each settlement run. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private |
|
Name |
|
MARKETFEEID |
|
PARTICIPANTCATEGORYID |
|
PARTICIPANTID |
|
PERIODID |
|
RUNNO |
|
SETTLEMENTDATE |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement date |
|
RUNNO |
NUMBER(3,0) |
X |
Settlement run no |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
PERIODID |
NUMBER(3,0) |
X |
Period identifier |
|
MARKETFEEID |
VARCHAR2(10) |
X |
Market fee identifier (e.g. V_EST) |
|
MARKETFEEVALUE |
NUMBER(15,5) |
|
Fee charge |
|
ENERGY |
NUMBER(16,6) |
|
Energy amount for variable fees |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
PARTICIPANTCATEGORYID |
VARCHAR2(10) |
X |
The participant category that the market fee recovery pertains to. Corresponds to the PARTICIPANTCATEGORYID column of the PARTICIPANT_BANDFEE_CATEGORYALLOC_C_V view for BAND$ type fees, or to the MARKETFEETYPE column of the MARKETFEE_P_V view for all other fee types. |
|
FEERATE |
NUMBER(18,8) |
|
The rate applied to this fee for the participant at the settlement date |
|
FEEUNITS |
NUMBER(18,8) |
|
The number of units applicable to this fee for the participant, in the trading |
|
|
|