Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Sales CountryRegionCurrency (table)

Compare Page Revisions



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


Page Revision: 2010/01/09 18:01


wikibot

TableSales.CountryRegionCurrency
DescriptionCross-reference table mapping ISO currency codes to a country or region.

ColumnData TypeNullableDefaultDescription / PK / Index
CountryRegionCodenvarchar(3)not null ISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode.
PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode
CurrencyCodenchar(3)not null ISO standard currency code. Foreign key to Currency.CurrencyCode.
PK_CountryRegionCurrency_CountryRegionCode_CurrencyCodeIX_CountryRegionCurrency_CurrencyCode
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.



RelationColumnReferenced Column
Person.CountryRegionCountryRegionCodeCountryRegionCode
Sales.CurrencyCurrencyCodeCurrencyCode

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