Sales.Currency (table)

From dbscript Online Help
Revision as of 15:53, 3 January 2009 by Bot (talk | contribs)
Jump to: navigation, search

wikibot

Table Sales.Currency


Column Data Type Nullable Default PK Index
CurrencyCode nchar(0) not null PK_Currency_CurrencyCode
Name dbo.Name not null AK_Currency_Name
ModifiedDate datetime not null (getdate())


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

wikivalues

Table Values Sales.Currency


CurrencyCode Name
A Afghani
D Algerian Dinar
A Argentine Peso
A Armenian Dram
A Aruban Guilder
A Australian Dollar
A Azerbaijanian Manat
B Bahamian Dollar
B Bahraini Dinar
T Baht
P Balboa
B Barbados Dollar
B Belgian Franc
V Bolivar
B Boliviano
B Brazilian Real
B Brunei Dollar
B Bulgarian Lev
C Canadian Dollar
G Cedi
X CFA Franc BCEAO
C Chilean Peso
C Colombian Peso
C Costa Rican Colon
H Croatian Kuna
C Cyprus Pound
C Czech Koruna
D Danish Krone
D Deutsche Mark
D Dominican Peso
V Dong
G Drachma
E Egyptian Pound
S El Salvador Colon
A Emirati Dirham
E EURO
F Fiji Dollar
H Forint
F French Franc
P Guarani
H Hong Kong Dollar
I Iceland Krona
I Indian Rupee
I Irish Pound
I Italian Lira
J Jamaican Dollar
J Jordanian Dinar
K Kenyan Shilling
E Kroon
K Kuwaiti Dinar
A Kwanza
L Latvian Lats
L Lebanese Pound
A Lek
R Leu
L Lithuanian Litas
M Malaysian Ringgit
M Maltese Lira
F Markka
M Mauritius Rupee
M Mexican Peso
M Moroccan Dirham
N Naira
N Namibia Dollar
N Nepalese Rupee
A Netherlands Antillian Guilder
N Netherlands Guilder
I New Israeli Shekel
T New Taiwan Dollar
N New Zealand Dollar
B Ngultrum
N Norwegian Krone
P Nuevo Sol
O Omani Rial
P Pakistan Rupee
P Philippine Peso
P Polish Zloty(old)
P Portuguese Escudo
G Quetzal
Z Rand
M Rufiyaa
I Rupiah
R Russian Ruble
R Russian Ruble(old)
S Saudi Riyal
A Shilling
S Singapore Dollar
S Slovak Koruna
E Spanish Peseta
L Sri Lankan Rupee
S Swedish Krona
C Swiss Franc
B Taka
S Tolar
T Trinidad and Tobago Dollar
T Tunisian Dinar
T Turkish Lira
G United Kingdom Pound
U Uruguayan Peso
U US Dollar
K Won
J Yen
C Yuan Renminbi
Z Zimbabwe Dollar
P Zloty