Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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