Share via


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.