GST_BAS_CLASS

GST_BAS_CLASS contains a static list of BAS (Business Activity Statement) classifications supported by the MMS.

Package

BILLING_CONFIG

Visibility

Public

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
BAS_CLASS	varchar(30)	varchar(30)	The BAS classification
DESCRIPTION	varchar(100)	varchar(100)	Description of the BAS classification
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_BAS_CLASS_LCX	nonclustered	LASTCHANGED
GST_BAS_CLASS_PK	clustered, unique, primary key	BAS_CLASS

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_GST_BAS_CLASS_LASTCHANGED	nonclustered	LASTCHANGED
PK_GST_BAS_CLASS	clustered, unique, primary key	BAS_CLASS

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
GST_BAS_CLASS_LCX	nonclustered	LASTCHANGED
GST_BAS_CLASS_PK	clustered, unique, primary key	BAS_CLASS