|
Name |
|
|
Comment |
Billing Reallocation Data aggregated by REALLOCATIONID for each billing run over the billing week. |
|
The BILLINGREALLOC_DETAIL table that will give a breakdown of the reallocations that form part of that billing run. This assists participants in their settlement reconciliation process.
Private data Volume max 100 rows per day |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
COUNTERPARTY |
|
PARTICIPANTID |
|
REALLOCATIONID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
BILLING CONTRACTYEAR |
|
WEEKNO |
NUMBER(3,0) |
X |
BILLING WEEKNO |
|
BILLRUNNO |
NUMBER(3,0) |
X |
BILLING RUN NO |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
REALLOCATION PARTICIPANTID |
|
COUNTERPARTY |
VARCHAR2(10) |
X |
REALLOCATION COUNTERPARTY PARTICIPANTID |
|
REALLOCATIONID |
VARCHAR2(20) |
X |
REALLOCATIONID |
|
VALUE |
NUMBER(15,5) |
|
REALLOCATION VALUE |
|
LASTCHANGED |
DATE |
|
DATETIME WHEN RECORD SAVED |
|
|
|