Name |
|
Comment |
BILLING_MR_PAYMENT shows aggregate payments on a dispatchable unit/MR Event basis for accepted MR capacity |
BILLING_MR_PAYMENT data is confidential, and is available only to the relevant participant. Source Ad hoc - MR events only. Volume 3500 rows per year |
Name |
Comment |
Value |
Visibility |
Data in this table is: |
Private |
Name |
BILLRUNNO |
CONTRACTYEAR |
DUID |
MR_DATE |
REGIONID |
WEEKNO |
Name |
LASTCHANGED |
Name |
Data Type |
Mandatory |
Comment |
CONTRACTYEAR |
NUMBER(4,0) |
X |
Billing Contract Year |
WEEKNO |
NUMBER(3,0) |
X |
Billing Week number |
BILLRUNNO |
NUMBER(3,0) |
X |
Billing Run number |
MR_DATE |
DATE |
X |
Trading Date of Mandatory Restriction event; Mandatory Restriction imposition date |
REGIONID |
VARCHAR2(10) |
X |
Unique Region Identifier |
PARTICIPANTID |
VARCHAR2(10) |
|
Unique Participant identifier |
DUID |
VARCHAR2(10) |
X |
Unique identifier for DUID / MNSP LinkID |
MR_AMOUNT |
NUMBER(16,6) |
|
Payment amount by AEMO |
LASTCHANGED |
DATE |
|
Date/Time record inserted/modified |
|
|
|