Sales.SalesTaxRate

Field Name Data Type Size Original Type Default Nullable Description Check

SalesTaxRateID int identity int Not null Primary key for SalesTaxRate records.

StateProvinceID int Not null State, province, or country/region the sales tax applies to.

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. ([TaxType]>=(1) AND [TaxType]<=(3))

TaxRate smallmoney 10,4 decimal(10,4) (0.00) Not null Tax rate amount.

Name Name nvarchar(50) Not null Tax rate description.

rowguid uniqueidentifier newid() Not null ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.

ModifiedDate datetime getdate() Not null Date and time the record was last updated.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
SalesTaxRateID	int identity		int		Not null	Primary key for SalesTaxRate records.
StateProvinceID	int				Not null	State, province, or country/region the sales tax applies to.
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.	([TaxType]>=(1) AND [TaxType]<=(3))
TaxRate	smallmoney	10,4	decimal(10,4)	(0.00)	Not null	Tax rate amount.
Name	Name		nvarchar(50)		Not null	Tax rate description.
rowguid	uniqueidentifier			newid()	Not null	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Sales.SalesTaxRate'

Primary Key Name Field Name

PK_SalesTaxRate_SalesTaxRateID SalesTaxRateID

Primary Key Name	Field Name
PK_SalesTaxRate_SalesTaxRateID	SalesTaxRateID

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

Foreign Primary Key Name

SalesTaxRate.StateProvinceID StateProvince.StateProvinceID FK_SalesTaxRate_StateProvince_StateProvinceID

Foreign	Primary	Key Name
SalesTaxRate.StateProvinceID	StateProvince.StateProvinceID	FK_SalesTaxRate_StateProvince_StateProvinceID

Indexes for table 'Sales.SalesTaxRate', 3 items

Index Name Description Clustered Unique Fields

PK_SalesTaxRate_SalesTaxRateID Clustered index created by a primary key constraint. Yes Yes SalesTaxRateID

AK_SalesTaxRate_rowguid Unique nonclustered index. Used to support replication samples. No Yes rowguid

AK_SalesTaxRate_StateProvinceID_TaxType Unique nonclustered index. No Yes StateProvinceID, TaxType

Index Name	Description	Clustered	Unique	Fields
PK_SalesTaxRate_SalesTaxRateID	Clustered index created by a primary key constraint.	Yes	Yes	SalesTaxRateID
AK_SalesTaxRate_rowguid	Unique nonclustered index. Used to support replication samples.	No	Yes	rowguid
AK_SalesTaxRate_StateProvinceID_TaxType	Unique nonclustered index.	No	Yes	StateProvinceID, TaxType

Triggers for table 'Sales.SalesTaxRate', 1 item

Name Description Type Enabled

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

Name	Description	Type	Enabled
uSalesTaxRate	AFTER 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 Name Type Field Name

Sales.CK_SalesTaxRate_TaxType check cns N/A

Sales.uSalesTaxRate trigger N/A