Sales.SalesTaxRate

Table: 'Sales.SalesTaxRate'

7 fields. 153 bytes.

Tax rate lookup table.

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
SalesTaxRateIDint identity int Not nullPrimary key for SalesTaxRate records. 
StateProvinceIDint   Not nullState, province, or country/region the sales tax applies to. 
TaxTypetinyint   Not null1 = Tax applied to retail transactions, 2 = Tax applied to wholesale transactions, 3 = Tax applied to all sales (retail and wholesale) transactions.([TaxType]>=(1) AND [TaxType]<=(3))
TaxRatesmallmoney10,4decimal(10,4)(0.00)Not nullTax rate amount. 
NameName nvarchar(50) Not nullTax rate description. 
rowguiduniqueidentifier  newid()Not nullROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
ModifiedDatedatetime  getdate()Not nullDate and time the record was last updated. 

Extended Properties

The object has no extended properties.

Primary key for table 'Sales.SalesTaxRate'

Primary Key NameField Name
PK_SalesTaxRate_SalesTaxRateIDSalesTaxRateID

Foreign keys for table 'Sales.SalesTaxRate', 1 item

ForeignPrimaryKey Name
SalesTaxRate.StateProvinceIDStateProvince.StateProvinceIDFK_SalesTaxRate_StateProvince_StateProvinceID

Indexes for table 'Sales.SalesTaxRate', 3 items

Index NameDescriptionClusteredUniqueFields
PK_SalesTaxRate_SalesTaxRateIDClustered index created by a primary key constraint.YesYesSalesTaxRateID
AK_SalesTaxRate_rowguidUnique nonclustered index. Used to support replication samples.NoYesrowguid
AK_SalesTaxRate_StateProvinceID_TaxTypeUnique nonclustered index.NoYesStateProvinceID, TaxType

Triggers for table 'Sales.SalesTaxRate', 1 item

NameDescriptionTypeEnabled
uSalesTaxRateAFTER UPDATE trigger setting the ModifiedDate column in the SalesTaxRate table to the current date.after Update Yes

Dependencies for table 'Sales.SalesTaxRate', 2 items

Object NameTypeField Name
Sales.CK_SalesTaxRate_TaxTypecheck cnsN/A
Sales.uSalesTaxRatetriggerN/A