Sales.SalesTaxRate - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	Sales
Name	SalesTaxRate
Module	Sales

Tax rate lookup table.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		SalesTaxRateID	int		Identity		Primary key for SalesTaxRate records.
Primary key for SalesTaxRate records. Identity
	2		StateProvinceID	int			Person.StateProvince	State, province, or country/region the sales tax applies to.
State, province, or country/region the sales tax applies to. References: Person.StateProvince
	3		TaxType	tinyint				1 = Tax applied to retail transactions, 2 = Tax applied to wholesale transactions, 3 = Tax applied to all sales (retail and wholesale) transactions.
1 = Tax applied to retail transactions, 2 = Tax applied to wholesale transactions, 3 = Tax applied to all sales (retail and wholesale) transactions.
	4		TaxRate	smallmoney		Default: 0.00		Tax rate amount.
Tax rate amount. Default: 0.00
	5		Name	nvarchar(50)				Tax rate description.
Tax rate description.
	6		rowguid	uniqueidentifier		Default: newid()		ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. Default: newid()
	7		ModifiedDate	datetime		Default: getdate()		Date and time the record was last updated.
Date and time the record was last updated. Default: getdate()

Relations

Foreign table		Primary table	Join	Title / Name / Description
Sales.SalesTaxRate		Person.StateProvince	Sales.SalesTaxRate.StateProvinceID = Person.StateProvince.StateProvinceID	FK_SalesTaxRate_StateProvince_StateProvinceID Foreign key constraint referencing StateProvince.StateProvinceID.
Sales.SalesTaxRate.StateProvinceID = Person.StateProvince.StateProvinceID Name: FK_SalesTaxRate_StateProvince_StateProvinceID Foreign key constraint referencing StateProvince.StateProvinceID.

Unique keys

	Key name	Columns	Description
	PK_SalesTaxRate_SalesTaxRateID	SalesTaxRateID	Primary key (clustered) constraint
Primary key (clustered) constraint
	AK_SalesTaxRate_rowguid	rowguid	Unique nonclustered index. Used to support replication samples.
Unique nonclustered index. Used to support replication samples.
	AK_SalesTaxRate_StateProvinceID_TaxType	StateProvinceID, TaxType	Unique nonclustered index.
Unique nonclustered index.

Uses

Name
Sales.SalesTaxRate
Person.StateProvince

Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56