BILLINGREALLOC_DETAIL

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

Package

BILLING_RUN

Visibility

Private

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
CONTRACTYEAR	numeric(4, 0)	smallint	BILLING CONTRACTYEAR
WEEKNO	numeric(3, 0)	smallint	BILLING WEEKNO
BILLRUNNO	numeric(3, 0)	smallint	BILLING RUN NO
PARTICIPANTID	varchar(10)	varchar(10)	REALLOCATION PARTICIPANTID
COUNTERPARTY	varchar(10)	varchar(10)	REALLOCATION COUNTERPARTY PARTICIPANTID
REALLOCATIONID	varchar(20)	varchar(20)	REALLOCATIONID
VALUE	numeric(15, 5)	numeric(15, 5)	REALLOCATION VALUE
LASTCHANGED	datetime(3)	datetime2(0)	DATETIME WHEN RECORD SAVED

Official MMS data model indexes

Index name	Index type	Index columns (in order)
BILLINGREALLOC_DETAIL_LCX	nonclustered	LASTCHANGED
BILLINGREALLOC_DETAIL_PK	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, COUNTERPARTY, REALLOCATIONID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_BILLINGREALLOC_DETAIL_LASTCHANGED	nonclustered	LASTCHANGED
PK_BILLINGREALLOC_DETAIL	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, COUNTERPARTY, REALLOCATIONID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
BILLINGREALLOC_DETAIL_LCX	nonclustered	LASTCHANGED
BILLINGREALLOC_DETAIL_PK	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, COUNTERPARTY, REALLOCATIONID