Skip to content

BILLING_IRSR_NSP_ALLOCATION

The report is used to show the participants the negative residue amount to TNSP based on regional share.

Package

BILLING_RUN

Visibility

Private

Table schema

Column Official MMS Datatype GR-MMS Datatype Comment
CONTRACTYEAR numeric(4, 0) 🔑 smallint 🔑 The Billing Contract Year.
WEEKNO numeric(3, 0) 🔑 smallint 🔑 The Billing WeekNo
BILLRUNNO numeric(3, 0) 🔑 smallint 🔑 The Billing RunNo
PARTICIPANTID varchar(20) 🔑 varchar(10) 🔑 TNSP Participant Identifier
REGIONID varchar(20) 🔑 varchar(10) 🔑 The Region Identifier
RESIDUE_AMOUNT numeric(18, 8) numeric(18, 8) Calculated Amount based on regional share
LASTCHANGED datetime(3) datetime2(0) The last changed date time of the record

Official MMS data model indexes

Index name Index type Index columns (in order)
BILLING_IRSR_NSP_ALLOCATION_PK clustered, unique, primary key CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, REGIONID

GR-MMS data model indexes

Index name Index type Index columns (in order)
PK_BILLING_IRSR_NSP_ALLOCATION clustered, unique, primary key CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, REGIONID

Historical-MMS data model indexes

Index name Index type Index columns (in order)
PK_BILLING_IRSR_NSP_ALLOCATION clustered, unique, primary key CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, REGIONID