Generated using SQL Data Dictionary demo version.


Table Sales.SalesTaxRate (29 rows)


Tax rate lookup table.


  Column Data Type Identity Nullable Default
PK SalesTaxRateID int X
Primary key for SalesTaxRate records.
UK, FK StateProvinceID int
State, province, or country/region the sales tax applies to.
UK TaxType tinyint
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
Tax rate amount.
Name Name(nvarchar(50))
Tax rate description.
UK rowguid uniqueidentifier newid()
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate datetime getdate()
Date and time the record was last updated.

Indexes:


References: