Sales.CountryRegionCurrency (table)

wikibot

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

Columns

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

Primary Key

Primary Key	Columns
PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode	CountryRegionCode, CurrencyCode

Indexes

Index	Type	Columns
IX_CountryRegionCurrency_CurrencyCode		CurrencyCode

Foreign Keys

Relation	Column	Referenced Column
Person.CountryRegion	CountryRegionCode	CountryRegionCode
Sales.Currency	CurrencyCode	CurrencyCode

References

Dependency Type	Object Type	Referenced Object
Schema	Schema	Sales

automatically generated

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.

Relation	Column	Referenced Column
Person.CountryRegion	CountryRegionCode	CountryRegionCode
Sales.Currency	CurrencyCode	CurrencyCode

Dependency Type	Object Type	Referenced Object
Schema	Schema	Sales