ScrewTurn Wiki

Edit

wikibot

TableSales.SalesTaxRate
DescriptionTax rate lookup table.

Edit

Columns

ColumnData TypeNullableDefaultDescription
SalesTaxRateIDintnot null Primary key for SalesTaxRate records.
StateProvinceIDintnot null State, province, or country/region the sales tax applies to.
TaxTypetinyintnot null 1 = Tax applied to retail transactions, 2 = Tax applied to wholesale transactions, 3 = Tax applied to all sales (retail and wholesale) transactions.
TaxRatesmallmoneynot null((0.00))Tax rate amount.
Namedbo.Namenot null Tax rate description.
rowguiduniqueidentifiernot null(newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Edit

Primary Key

Primary KeyColumns
PK_SalesTaxRate_SalesTaxRateIDSalesTaxRateID

Edit

Indexes

IndexTypeColumns
AK_SalesTaxRate_rowguidUniquerowguid
AK_SalesTaxRate_StateProvinceID_TaxTypeUniqueStateProvinceID, TaxType

Edit

Check Constraints

Check ConstraintExpressionDescription
CK_SalesTaxRate_TaxType(TaxType>=(1) AND TaxType<=(3))Check constraint TaxType BETWEEN (1) AND (3)

Edit

Foreign Keys

RelationColumnReferenced Column
Person.StateProvinceStateProvinceIDStateProvinceID

Edit

References

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Name
SchemaSchemaSales

Edit

automatically generated

TableSales.SalesTaxRate
DescriptionTax rate lookup table.

ColumnData TypeNullableDefaultDescription / PK / Index
SalesTaxRateIDintnot null Primary key for SalesTaxRate records.
PK_SalesTaxRate_SalesTaxRateID
StateProvinceIDintnot null State, province, or country/region the sales tax applies to.
AK_SalesTaxRate_StateProvinceID_TaxType
TaxTypetinyintnot null 1 = Tax applied to retail transactions, 2 = Tax applied to wholesale transactions, 3 = Tax applied to all sales (retail and wholesale) transactions.
AK_SalesTaxRate_StateProvinceID_TaxType
TaxRatesmallmoneynot null(0.00)Tax rate amount.
NameNamenot null Tax rate description.
rowguiduniqueidentifiernot null(NEWID())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
AK_SalesTaxRate_rowguid
ModifiedDatedatetimenot null(GETDATE())Date and time the record was last updated.



RelationColumnReferenced Column
Person.StateProvinceStateProvinceIDStateProvinceID

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Name
SchemaSchemaSales

ScrewTurn Wiki version 2.0.36. Some of the icons created by FamFamFam.