SalesTaxRate Table (AdventureWorks)
Is a lookup table that contains the tax rates applicable to states, provinces, or country/regions in which Adventure Works Cycles has a local business presence.
SalesTaxRate Table Definition
The SalesTaxRate table is contained in the Sales schema.
| Column | Data type | Nullability | Description |
|---|---|---|---|
SalesTaxRateID |
int |
Not null |
Primary key for SalesTaxRate rows. |
StateProvinceID |
int |
Not null |
State, province, or country/region to which the sale tax applies. |
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. |
TaxRate |
smallmoney |
Not null |
Tax rate amount. |
Name |
Name (user-defined type) nvarchar(50) |
Not null |
Tax rate description. |
rowguid |
uniqueidentifier |
Not null |
ROWGUIDCOL number uniquely identifying the row. Used to support a merge replication sample. |
ModifiedDate |
datetime |
Not null |
Date and time the row was last updated. |
See Also
Reference
SalesOrderHeader Table (AdventureWorks)
StateProvince Table (AdventureWorks)
Other Resources
AdventureWorks Data Dictionary