Table: BILLING_MR_PAYMENT

BILLING_MR_PAYMENT

Name

BILLING_MR_PAYMENT

Comment

BILLING_MR_PAYMENT shows aggregate payments on a dispatchable unit/MR Event basis for accepted MR capacity


Description

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


Primary Key Columns

Name

BILLRUNNO

CONTRACTYEAR

DUID

MR_DATE

REGIONID

WEEKNO


Index Columns

Name

LASTCHANGED


Content

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