BILLING_GST_DETAIL

BILLING_GST_DETAIL shows the BAS class, GST_Exclusive and GST amount (if any) attributable to a participant for each transaction type.

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
BAS_CLASS	varchar(30)	varchar(30)	The BAS classification that the transaction type belongs to.
TRANSACTION_TYPE	varchar(30)	varchar(30)	The transaction type (e.g. CUSTOMER_ENERGY_PURCHASES)
GST_EXCLUSIVE_AMOUNT	numeric(15, 5)	numeric(15, 5)	The GST exclusive amount paid by/to the participant to/by AEMO for this transaction type.
GST_AMOUNT	numeric(15, 5)	numeric(15, 5)	The GST amount for this transaction type.
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
BILLING_GST_DETAIL_LCX	nonclustered	LASTCHANGED
BILLING_GST_DETAIL_PK	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, TRANSACTION_TYPE, BAS_CLASS

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_BILLING_GST_DETAIL_LASTCHANGED	nonclustered	LASTCHANGED
PK_BILLING_GST_DETAIL	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, TRANSACTION_TYPE, BAS_CLASS

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
BILLING_GST_DETAIL_LCX	nonclustered	LASTCHANGED
BILLING_GST_DETAIL_PK	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, TRANSACTION_TYPE, BAS_CLASS