GST_RATE
GST_RATE maintains the GST rates on a BAS (Business Activity Statement) class basis.
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 |
| BAS_CLASS |
varchar(30) |
varchar(30) |
The BAS classification |
| GST_RATE |
numeric(8, 5) |
numeric(8, 5) |
The GST rate that applies to this 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_RATE_LCX |
nonclustered |
LASTCHANGED |
| GST_RATE_PK |
clustered, unique, primary key |
EFFECTIVEDATE, VERSIONNO, BAS_CLASS |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_GST_RATE_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_GST_RATE |
clustered, unique, primary key |
EFFECTIVEDATE, VERSIONNO, BAS_CLASS |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| GST_RATE_LCX |
nonclustered |
LASTCHANGED |
| GST_RATE_PK |
clustered, unique, primary key |
EFFECTIVEDATE, VERSIONNO, BAS_CLASS |