Welcome Guest, you are in: <root> • Login

Page History: Sales CountryRegionCurrency (table)

Compare Page Revisions

4 3 2 1 0 Current 4 3 2 1 0

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

Page Revision: 2010/02/11 09:07

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