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 - Current Revision

Page Revision: 2010/06/24 01:10

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

wikivalues ¶

Table Values

Sales.Currency

CurrencyCode	Name
AFA	Afghani
DZD	Algerian Dinar
ARS	Argentine Peso
AMD	Armenian Dram
AWG	Aruban Guilder
AUD	Australian Dollar
AZM	Azerbaijanian Manat
BSD	Bahamian Dollar
BHD	Bahraini Dinar
THB	Baht
PAB	Balboa
BBD	Barbados Dollar
BEF	Belgian Franc
VEB	Bolivar
BOB	Boliviano
BRL	Brazilian Real
BND	Brunei Dollar
BGN	Bulgarian Lev
CAD	Canadian Dollar
GHC	Cedi
XOF	CFA Franc BCEAO
CLP	Chilean Peso
COP	Colombian Peso
CRC	Costa Rican Colon
HRK	Croatian Kuna
CYP	Cyprus Pound
CZK	Czech Koruna
DKK	Danish Krone
DEM	Deutsche Mark
DOP	Dominican Peso
VND	Dong
GRD	Drachma
EGP	Egyptian Pound
SVC	El Salvador Colon
AED	Emirati Dirham
EUR	EURO
FJD	Fiji Dollar
HUF	Forint
FRF	French Franc
PYG	Guarani
HKD	Hong Kong Dollar
ISK	Iceland Krona
INR	Indian Rupee
IEP	Irish Pound
ITL	Italian Lira
JMD	Jamaican Dollar
JOD	Jordanian Dinar
KES	Kenyan Shilling
EEK	Kroon
KWD	Kuwaiti Dinar
AOA	Kwanza
LVL	Latvian Lats
LBP	Lebanese Pound
ALL	Lek
ROL	Leu
LTL	Lithuanian Litas
MYR	Malaysian Ringgit
MTL	Maltese Lira
FIM	Markka
MUR	Mauritius Rupee
MXN	Mexican Peso
MAD	Moroccan Dirham
NGN	Naira
NAD	Namibia Dollar
NPR	Nepalese Rupee
ANG	Netherlands Antillian Guilder
NLG	Netherlands Guilder
ILS	New Israeli Shekel
TWD	New Taiwan Dollar
NZD	New Zealand Dollar
BTN	Ngultrum
NOK	Norwegian Krone
PEN	Nuevo Sol
OMR	Omani Rial
PKR	Pakistan Rupee
PHP	Philippine Peso
PLZ	Polish Zloty(old)
PTE	Portuguese Escudo
GTQ	Quetzal
ZAR	Rand
MVR	Rufiyaa
IDR	Rupiah
RUB	Russian Ruble
RUR	Russian Ruble(old)
SAR	Saudi Riyal
ATS	Shilling
SGD	Singapore Dollar
SKK	Slovak Koruna
ESP	Spanish Peseta
LKR	Sri Lankan Rupee
SEK	Swedish Krona
CHF	Swiss Franc
BDT	Taka
SIT	Tolar
TTD	Trinidad and Tobago Dollar
TND	Tunisian Dinar
TRL	Turkish Lira
GBP	United Kingdom Pound
UYU	Uruguayan Peso
USD	US Dollar
KRW	Won
JPY	Yen
CNY	Yuan Renminbi
ZWD	Zimbabwe Dollar
PLN	Zloty