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/01/09 17:45


wikibot

TableSales.Currency
DescriptionLookup table containing standard ISO currencies.

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



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

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Name

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