| Field | Type | Defaults | Nulls? | Comments | | SalesTaxRateID | int - Identity | None | No | Primary key for SalesTaxRate records. |
| StateProvinceID | int | None | No | State, province, or country/region the sales tax applies to. |
| TaxType | tinyint | None | No | 1 = Tax applied to retail transactions, 2 = Tax applied to wholesale transactions, 3 = Tax applied to all sales (retail and wholesale) transactions. |
| TaxRate | smallmoney | ((0.00)) | No | Tax rate amount. |
| Name | nvarchar (50) | None | No | Tax rate description. |
| rowguid | uniqueidentifier | (newid()) | No | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| ModifiedDate | datetime | (getdate()) | No | Date and time the record was last updated. |