BILLRESERVETRADERPAYMENT
Details of the RERT Usage and Availability Payments made to the participant.
Package
BILLING_RUN
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CONTRACTYEAR |
numeric(4, 0)  |
smallint |
Billing contract year |
| WEEKNO |
numeric(3, 0) |
tinyint |
Billing week number |
| BILLRUNNO |
numeric(3, 0) |
smallint |
Billing posted run number |
| PARTICIPANTID |
varchar(20) |
varchar(20) |
Participant identifier. |
| CONTRACTID |
varchar(20) |
varchar(20) |
RERT payment contract ID |
| PAYMENT_ID |
numeric(3, 0) |
smallint |
RERT payment number |
| PAYMENT_TYPE |
varchar(40) |
varchar(40) |
Description for the reserve trader contract payment amount. |
| PAYMENT_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
RERT payment amount for the payment type |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLRESERVETRADERPAYMENT_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, CONTRACTID, PAYMENT_ID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_BILLRESERVETRADERPAYMENT |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, CONTRACTID, PAYMENT_ID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLRESERVETRADERPAYMENT_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, CONTRACTID, PAYMENT_ID |