|
Name |
|
|
Comment |
Billing result table for reserve trader contract recovery |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
REGIONID |
|
WEEKNO |
|
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 |
|
REGIONID |
VARCHAR2(20) |
X |
Region id for the aggregated recovery amount |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
Participant identifier |
|
RECOVERY_AMOUNT |
NUMBER(18,8) |
|
Payment amount to be recovered from the participant |
|
|
|