Table: BILLRESERVETRADERPAYMENT

BILLRESERVETRADERPAYMENT

Name

BILLRESERVETRADERPAYMENT

Comment

Details of the RERT Usage and Availability Payments made to the participant.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

BILLRUNNO

CONTRACTID

CONTRACTYEAR

PAYMENT_TYPE_ID

WEEKNO


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 posted run number

PARTICIPANTID

VARCHAR2(20)

 

Participant identifier.

CONTRACTID

VARCHAR2(20)

X

RERT payment contract ID

PAYMENT_TYPE_ID

VARCHAR2(20)

X

RERT payment type ID. Possible values are USAGE or OTHER

PAYMENT_AMOUNT

NUMBER(18,8)

 

RERT payment amount for the payment type