GST_TRANSACTION_CLASS

GST_TRANSACTION_CLASS maps NEM settlement transaction types with BAS (Business Activity Statement) classifications.

Package

BILLING_CONFIG

Visibility

Public

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
EFFECTIVEDATE	datetime(3)	datetime2(0)	The effective date of the data set
VERSIONNO	numeric(3, 0)	smallint	The version number of the data set
TRANSACTION_TYPE	varchar(30)	varchar(30)	NEM settlement transaction type
BAS_CLASS	varchar(30)	varchar(30)	The BAS classification that the transaction type corresponds to
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time the record changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
GST_TRAN_CLASS_LCX	nonclustered	LASTCHANGED
GST_TRANS_CLASS_PK	clustered, unique, primary key	EFFECTIVEDATE, VERSIONNO, TRANSACTION_TYPE, BAS_CLASS

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_GST_TRANSACTION_CLASS_LASTCHANGED	nonclustered	LASTCHANGED
PK_GST_TRANSACTION_CLASS	clustered, unique, primary key	EFFECTIVEDATE, VERSIONNO, TRANSACTION_TYPE, BAS_CLASS

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
GST_TRAN_CLASS_LCX	nonclustered	LASTCHANGED
GST_TRANS_CLASS_PK	clustered, unique, primary key	EFFECTIVEDATE, VERSIONNO, TRANSACTION_TYPE, BAS_CLASS