ScrewTurn Wiki

Edit

wikibot

TableSales.Currency
DescriptionLookup table containing standard ISO currencies.

Edit

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.

Edit

Primary Key

Primary KeyColumns
PK_Currency_CurrencyCodeCurrencyCode

Edit

Indexes

IndexTypeColumns
AK_Currency_NameUniqueName

Edit

Detail Tables

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

Edit

References

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Name
SchemaSchemaSales

Edit

wikivalues

Table ValuesSales.Currency

CurrencyCodeName
AFAAfghani
DZDAlgerian Dinar
ARSArgentine Peso
AMDArmenian Dram
AWGAruban Guilder
AUDAustralian Dollar
AZMAzerbaijanian Manat
BSDBahamian Dollar
BHDBahraini Dinar
THBBaht
PABBalboa
BBDBarbados Dollar
BEFBelgian Franc
VEBBolivar
BOBBoliviano
BRLBrazilian Real
BNDBrunei Dollar
BGNBulgarian Lev
CADCanadian Dollar
GHCCedi
XOFCFA Franc BCEAO
CLPChilean Peso
COPColombian Peso
CRCCosta Rican Colon
HRKCroatian Kuna
CYPCyprus Pound
CZKCzech Koruna
DKKDanish Krone
DEMDeutsche Mark
DOPDominican Peso
VNDDong
GRDDrachma
EGPEgyptian Pound
SVCEl Salvador Colon
AEDEmirati Dirham
EUREURO
FJDFiji Dollar
HUFForint
FRFFrench Franc
PYGGuarani
HKDHong Kong Dollar
ISKIceland Krona
INRIndian Rupee
IEPIrish Pound
ITLItalian Lira
JMDJamaican Dollar
JODJordanian Dinar
KESKenyan Shilling
EEKKroon
KWDKuwaiti Dinar
AOAKwanza
LVLLatvian Lats
LBPLebanese Pound
ALLLek
ROLLeu
LTLLithuanian Litas
MYRMalaysian Ringgit
MTLMaltese Lira
FIMMarkka
MURMauritius Rupee
MXNMexican Peso
MADMoroccan Dirham
NGNNaira
NADNamibia Dollar
NPRNepalese Rupee
ANGNetherlands Antillian Guilder
NLGNetherlands Guilder
ILSNew Israeli Shekel
TWDNew Taiwan Dollar
NZDNew Zealand Dollar
BTNNgultrum
NOKNorwegian Krone
PENNuevo Sol
OMROmani Rial
PKRPakistan Rupee
PHPPhilippine Peso
PLZPolish Zloty(old)
PTEPortuguese Escudo
GTQQuetzal
ZARRand
MVRRufiyaa
IDRRupiah
RUBRussian Ruble
RURRussian Ruble(old)
SARSaudi Riyal
ATSShilling
SGDSingapore Dollar
SKKSlovak Koruna
ESPSpanish Peseta
LKRSri Lankan Rupee
SEKSwedish Krona
CHFSwiss Franc
BDTTaka
SITTolar
TTDTrinidad and Tobago Dollar
TNDTunisian Dinar
TRLTurkish Lira
GBPUnited Kingdom Pound
UYUUruguayan Peso
USDUS Dollar
KRWWon
JPYYen
CNYYuan Renminbi
ZWDZimbabwe Dollar
PLNZloty

Edit

automatically generated

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
NameNamenot 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
SchemaSchemaSales

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