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/01/09 18:04


wikibot

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.
Namedbo.Namenot 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

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