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

Page History: Sales Currency (table)

Compare Page Revisions

5 4 3 2 1 0 Current 5 4 3 2 1 0

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

Page Revision: 2010/06/24 01:09

wikibot ¶

Table	Sales.Currency
Description	Lookup table containing standard ISO currencies.

Columns ¶

Column	Data Type	Nullable	Default	Description
CurrencyCode	nchar(3)	not null		The ISO code for the Currency.
Name	dbo.Name	not null		Currency name.
ModifiedDate	datetime	not null	(getdate())	Date and time the record was last updated.

Primary Key ¶

Primary Key	Columns
PK_Currency_CurrencyCode	CurrencyCode

Indexes ¶

Index	Type	Columns
AK_Currency_Name	Unique	Name

Detail Tables ¶

Detail Table	Column	Referencing Column
Sales.CountryRegionCurrency	CurrencyCode	CurrencyCode
Sales.CurrencyRate	CurrencyCode	FromCurrencyCode
Sales.CurrencyRate	CurrencyCode	ToCurrencyCode

References ¶

Dependency Type	Object Type	Referenced Object
Data Type	Type	dbo.Name
Schema	Schema	Sales