| Column | Data Type | Nullable | Default | Description / PK / Index |
| SalesTaxRateID | int | not null | | Primary key for SalesTaxRate records.
PK_SalesTaxRate_SalesTaxRateID |
| StateProvinceID | int | not null | | State, province, or country/region the sales tax applies to.
AK_SalesTaxRate_StateProvinceID_TaxType |
| TaxType | tinyint | not null | | 1 = Tax applied to retail transactions, 2 = Tax applied to wholesale transactions, 3 = Tax applied to all sales (retail and wholesale) transactions.
AK_SalesTaxRate_StateProvinceID_TaxType |
| TaxRate | smallmoney | not null | ((0.00)) | Tax rate amount.
|
| Name | dbo.Name | not null | | Tax rate description.
|
| rowguid | uniqueidentifier | not null | (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
AK_SalesTaxRate_rowguid |
| ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated.
|