Sales.CountryRegionCurrency (table)

wikibot

Table

Sales.CountryRegionCurrency

Column	Data Type	Nullable	Default	PK	Index
CountryRegionCode	nvarchar(3)	not null		PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode
CurrencyCode	nchar(3)	not null		PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode	IX_CountryRegionCurrency_CurrencyCode
ModifiedDate	datetime	not null	(getdate())

Table	Sales.CountryRegionCurrency
Description	Cross-reference table mapping ISO currency codes to a country or region.

Column	Data Type	Nullable	Default	Description / PK / Index
CountryRegionCode	nvarchar(3)	not null		ISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode.PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode
CurrencyCode	nchar(3)	not null		ISO standard currency code. Foreign key to Currency.CurrencyCode.PK_CountryRegionCurrency_CountryRegionCode_CurrencyCodeIX_CountryRegionCurrency_CurrencyCode
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.