BILLINGFINANCIALADJUSTMENTS

BILLINGFINANCIALADJUSTMENTS contains any manual adjustments included in the billing run.

Package

BILLING_RUN

Visibility

Private

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
CONTRACTYEAR	numeric(4, 0)	smallint	AEMO Contract Year number starting in week containing 1st January
WEEKNO	numeric(3, 0)	smallint	Week no within the contract year. Week no 1 is the week containing 1st January
BILLRUNNO	numeric(3, 0)	smallint	Unique run no within a given contract year and week no
PARTICIPANTID	varchar(10)	varchar(10)	Unique participant identifier
ADJUSTMENTITEM	varchar(64)	varchar(64)	Description of the adjustment being made
PARTICIPANTTYPE	varchar(10)	varchar(10)	Not Used
AMOUNT	numeric(15, 5)	numeric(15, 5)	The amount of the manual adjustment line item
VALUE	numeric(15, 5)	numeric(15, 5)	Not Used
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time the record changed.
FINANCIALCODE	numeric(10, 0)	bigint	The GL financial code of the manual adjustment line item. Used internally by AEMO systems.
BAS_CLASS	varchar(30)	varchar(30)	The BAS classification of the manual adjustment line item.

Official MMS data model indexes

Index name	Index type	Index columns (in order)
BILLINGFINANCIALADJUSTMEN_LCX	nonclustered	LASTCHANGED
BILLINGFINANCIALADJUSTMENTS_PK	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, ADJUSTMENTITEM

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_BILLINGFINANCIALADJUSTMENTS_LASTCHANGED	nonclustered	LASTCHANGED
PK_BILLINGFINANCIALADJUSTMENTS	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, ADJUSTMENTITEM

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
BILLINGFINANCIALADJUSTMEN_LCX	nonclustered	LASTCHANGED
PK_BILLINGFINANCIALADJUSTMENTS	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, ADJUSTMENTITEM