Table: BILLINGREALLOC_DETAIL

BILLINGREALLOC_DETAIL

Name

BILLINGREALLOC_DETAIL

Comment

Billing Reallocation Data aggregated by REALLOCATIONID for each billing run over the billing week.


Description

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


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

BILLRUNNO

CONTRACTYEAR

COUNTERPARTY

PARTICIPANTID

REALLOCATIONID

WEEKNO


Index Columns

Name

LASTCHANGED


Content

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