Sales CountryRegionCurrency (table)

wikibot

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

Columns

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

Primary Key

Primary KeyColumns
PK_CountryRegionCurrency_CountryRegionCode_CurrencyCodeCountryRegionCode, CurrencyCode

Indexes

IndexTypeColumns
IX_CountryRegionCurrency_CurrencyCode CurrencyCode

Foreign Keys

RelationColumnReferenced Column
Person.CountryRegionCountryRegionCodeCountryRegionCode
Sales.CurrencyCurrencyCodeCurrencyCode

References

Dependency TypeObject TypeReferenced Object
SchemaSchemaSales