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.
The SalesTaxRate table is contained in the Sales schema.
Primary key for SalesTaxRate rows.
State, province, or country/region to which the sale tax applies.
1 = Tax applied to retail transactions.
2 = Tax applied to wholesale transactions.
3 = Tax applied to all sales, retail and wholesale, transactions.
Tax rate amount.
Name (user-defined type)
Tax rate description.
ROWGUIDCOL number uniquely identifying the row. Used to support a merge replication sample.
Date and time the row was last updated.