Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Sales Currency (table)

Compare Page Revisions



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


Page Revision: 2010/02/11 09:07


wikibot

TableSales.Currency
DescriptionLookup table containing standard ISO currencies.

Columns

ColumnData TypeNullableDefaultDescription
CurrencyCodenchar(3)not null The ISO code for the Currency.
Namedbo.Namenot null Currency name.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Primary Key

Primary KeyColumns
PK_Currency_CurrencyCodeCurrencyCode

Indexes

IndexTypeColumns
AK_Currency_NameUniqueName

Detail Tables

Detail TableColumnReferencing Column
Sales.CountryRegionCurrencyCurrencyCodeCurrencyCode
Sales.CurrencyRateCurrencyCodeFromCurrencyCode
Sales.CurrencyRateCurrencyCodeToCurrencyCode

References

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Name
SchemaSchemaSales

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.