Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Sales SalesTaxRate (table)

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: 2010/02/11 09:07


wikibot

TableSales.SalesTaxRate
DescriptionTax rate lookup table.

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.

Primary Key

Primary KeyColumns
PK_SalesTaxRate_SalesTaxRateIDSalesTaxRateID

Indexes

IndexTypeColumns
AK_SalesTaxRate_StateProvinceID_TaxTypeUniqueStateProvinceID, TaxType
AK_SalesTaxRate_rowguidUniquerowguid

Check Constraints

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

Foreign Keys

RelationColumnReferenced Column
Person.StateProvinceStateProvinceIDStateProvinceID

References

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Name
SchemaSchemaSales

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