Difference between revisions of "Sales.Currency (table)"

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

Revision as of 16:29, 3 January 2009

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
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
Retrieved from "http://dbshelp.devio.at/index.php?title=Sales.Currency_(table)&oldid=323"