Table: BILLING_RES_TRADER_PAYMENT

BILLING_RES_TRADER_PAYMENT

Name

BILLING_RES_TRADER_PAYMENT

Comment

Billing result table for reserve trader contract payments


Primary Key Columns

Name

BILLRUNNO

CONTRACTID

CONTRACTYEAR

PARTICIPANTID

PAYMENT_TYPE

WEEKNO


Content

Name

Data Type

Mandatory

Comment

CONTRACTYEAR

NUMBER(4)

X

Billing contract year

WEEKNO

NUMBER(3)

X

Billing week number

BILLRUNNO

NUMBER(3)

X

Billing run number

CONTRACTID

VARCHAR2(20)

X

Reserve trader contract identifier

PAYMENT_TYPE

VARCHAR2(40)

X

Payment type for the reserve trader contract payment amount

PARTICIPANTID

VARCHAR2(20)

X

Participant identifier associated with the contract

PAYMENT_AMOUNT

NUMBER(18,8)

 

Payment amount to the participant