Difference between revisions of "Sales.Currency (table)"
(9 intermediate revisions by the same user not shown) | |||
Line 2: | Line 2: | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
− | |- | + | |- valign="top" |
| '''Table | | '''Table | ||
| Sales.Currency | | Sales.Currency | ||
− | |- | + | |- valign="top" |
+ | | '''Description | ||
+ | | Lookup table containing standard ISO currencies. | ||
|} | |} | ||
− | + | === Columns === | |
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
|- style="background:silver" | |- style="background:silver" | ||
Line 15: | Line 17: | ||
| '''Nullable | | '''Nullable | ||
| '''Default | | '''Default | ||
− | | ''' | + | | '''Description |
− | + | ||
− | + | |- valign="top" | |
− | |- | ||
| CurrencyCode | | CurrencyCode | ||
| nchar(3) | | nchar(3) | ||
| not null | | not null | ||
| | | | ||
− | | | + | | The ISO code for the Currency. |
− | + | |- valign="top" | |
− | |- | ||
| Name | | Name | ||
| dbo.Name | | dbo.Name | ||
| not null | | not null | ||
| | | | ||
− | | | + | | Currency name. |
− | + | |- valign="top" | |
− | |- | ||
| ModifiedDate | | ModifiedDate | ||
| datetime | | datetime | ||
| not null | | not null | ||
| (getdate()) | | (getdate()) | ||
− | | | + | | Date and time the record was last updated. |
− | | | + | |} |
+ | |||
+ | === Primary Key === | ||
+ | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
+ | |- style="background:silver" | ||
+ | | '''Primary Key | ||
+ | | '''Columns | ||
+ | |- valign="top" | ||
+ | | PK_Currency_CurrencyCode | ||
+ | | CurrencyCode | ||
|} | |} | ||
+ | === Indexes === | ||
+ | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
+ | |- style="background:silver" | ||
+ | | '''Index | ||
+ | | '''Type | ||
+ | | '''Columns | ||
+ | |- valign="top" | ||
+ | | AK_Currency_Name | ||
+ | | Unique | ||
+ | | Name | ||
+ | |} | ||
+ | === Detail Tables === | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
|- style="background:silver" | |- style="background:silver" | ||
Line 48: | Line 68: | ||
| '''Column | | '''Column | ||
| '''Referencing Column | | '''Referencing Column | ||
− | + | ||
− | |- | + | |- valign="top" |
| [[Sales.CountryRegionCurrency_(table)|Sales.CountryRegionCurrency]] | | [[Sales.CountryRegionCurrency_(table)|Sales.CountryRegionCurrency]] | ||
| CurrencyCode | | CurrencyCode | ||
| CurrencyCode | | CurrencyCode | ||
− | |- | + | |- valign="top" |
| [[Sales.CurrencyRate_(table)|Sales.CurrencyRate]] | | [[Sales.CurrencyRate_(table)|Sales.CurrencyRate]] | ||
| CurrencyCode | | CurrencyCode | ||
| FromCurrencyCode | | FromCurrencyCode | ||
− | |- | + | |- valign="top" |
| [[Sales.CurrencyRate_(table)|Sales.CurrencyRate]] | | [[Sales.CurrencyRate_(table)|Sales.CurrencyRate]] | ||
| CurrencyCode | | CurrencyCode | ||
| ToCurrencyCode | | ToCurrencyCode | ||
|} | |} | ||
+ | |||
+ | === References === | ||
+ | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
+ | |- style="background:silver" | ||
+ | | '''Dependency Type | ||
+ | | '''Object Type | ||
+ | | '''Referenced Object | ||
+ | |||
+ | |- valign="top" | ||
+ | | Data Type | ||
+ | | Type | ||
+ | | [[dbo.Name_(type)|dbo.Name]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | Schema | ||
+ | | Schema | ||
+ | | [[Sales_(schema)|Sales]] | ||
+ | |||
+ | |} | ||
+ | |||
+ | |||
== wikivalues == | == wikivalues == | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
− | |- | + | |- valign="top" |
| '''Table Values | | '''Table Values | ||
| Sales.Currency | | Sales.Currency | ||
− | |||
|} | |} | ||
+ | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
+ | |- style="background:silver" | ||
− | |||
− | |||
| '''CurrencyCode | | '''CurrencyCode | ||
| '''Name | | '''Name | ||
− | |- | + | |- valign="top" |
− | | AFA | + | |
− | | Afghani | + | | AFA |
− | |- | + | | Afghani |
− | | DZD | + | |- valign="top" |
− | | Algerian Dinar | + | |
− | |- | + | | DZD |
− | | ARS | + | | Algerian Dinar |
− | | Argentine Peso | + | |- valign="top" |
− | |- | + | |
− | | AMD | + | | ARS |
− | | Armenian Dram | + | | Argentine Peso |
− | |- | + | |- valign="top" |
− | | AWG | + | |
− | | Aruban Guilder | + | | AMD |
− | |- | + | | Armenian Dram |
− | | AUD | + | |- valign="top" |
− | | Australian Dollar | + | |
− | |- | + | | AWG |
− | | AZM | + | | Aruban Guilder |
− | | Azerbaijanian Manat | + | |- valign="top" |
− | |- | + | |
− | | BSD | + | | AUD |
− | | Bahamian Dollar | + | | Australian Dollar |
− | |- | + | |- valign="top" |
− | | BHD | + | |
− | | Bahraini Dinar | + | | AZM |
− | |- | + | | Azerbaijanian Manat |
− | | THB | + | |- valign="top" |
− | | Baht | + | |
− | |- | + | | BSD |
− | | PAB | + | | Bahamian Dollar |
− | | Balboa | + | |- valign="top" |
− | |- | + | |
− | | BBD | + | | BHD |
− | | Barbados Dollar | + | | Bahraini Dinar |
− | |- | + | |- valign="top" |
− | | BEF | + | |
− | | Belgian Franc | + | | THB |
− | |- | + | | Baht |
− | | VEB | + | |- valign="top" |
− | | Bolivar | + | |
− | |- | + | | PAB |
− | | BOB | + | | Balboa |
− | | Boliviano | + | |- valign="top" |
− | |- | + | |
− | | BRL | + | | BBD |
− | | Brazilian Real | + | | Barbados Dollar |
− | |- | + | |- valign="top" |
− | | BND | + | |
− | | Brunei Dollar | + | | BEF |
− | |- | + | | Belgian Franc |
− | | BGN | + | |- valign="top" |
− | | Bulgarian Lev | + | |
− | |- | + | | VEB |
− | | CAD | + | | Bolivar |
− | | Canadian Dollar | + | |- valign="top" |
− | |- | + | |
− | | GHC | + | | BOB |
− | | Cedi | + | | Boliviano |
− | |- | + | |- valign="top" |
− | | XOF | + | |
− | | CFA Franc BCEAO | + | | BRL |
− | |- | + | | Brazilian Real |
− | | CLP | + | |- valign="top" |
− | | Chilean Peso | + | |
− | |- | + | | BND |
− | | COP | + | | Brunei Dollar |
− | | Colombian Peso | + | |- valign="top" |
− | |- | + | |
− | | CRC | + | | BGN |
− | | Costa Rican Colon | + | | Bulgarian Lev |
− | |- | + | |- valign="top" |
− | | HRK | + | |
− | | Croatian Kuna | + | | CAD |
− | |- | + | | Canadian Dollar |
− | | CYP | + | |- valign="top" |
− | | Cyprus Pound | + | |
− | |- | + | | GHC |
− | | CZK | + | | Cedi |
− | | Czech Koruna | + | |- valign="top" |
− | |- | + | |
− | | DKK | + | | XOF |
− | | Danish Krone | + | | CFA Franc BCEAO |
− | |- | + | |- valign="top" |
− | | DEM | + | |
− | | Deutsche Mark | + | | CLP |
− | |- | + | | Chilean Peso |
− | | DOP | + | |- valign="top" |
− | | Dominican Peso | + | |
− | |- | + | | COP |
− | | VND | + | | Colombian Peso |
− | | Dong | + | |- valign="top" |
− | |- | + | |
− | | GRD | + | | CRC |
− | | Drachma | + | | Costa Rican Colon |
− | |- | + | |- valign="top" |
− | | EGP | + | |
− | | Egyptian Pound | + | | HRK |
− | |- | + | | Croatian Kuna |
− | | SVC | + | |- valign="top" |
− | | El Salvador Colon | + | |
− | |- | + | | CYP |
− | | AED | + | | Cyprus Pound |
− | | Emirati Dirham | + | |- valign="top" |
− | |- | + | |
− | | EUR | + | | CZK |
− | | EURO | + | | Czech Koruna |
− | |- | + | |- valign="top" |
− | | FJD | + | |
− | | Fiji Dollar | + | | DKK |
− | |- | + | | Danish Krone |
− | | HUF | + | |- valign="top" |
− | | Forint | + | |
− | |- | + | | DEM |
− | | FRF | + | | Deutsche Mark |
− | | French Franc | + | |- valign="top" |
− | |- | + | |
− | | PYG | + | | DOP |
− | | Guarani | + | | Dominican Peso |
− | |- | + | |- valign="top" |
− | | HKD | + | |
− | | Hong Kong Dollar | + | | VND |
− | |- | + | | Dong |
− | | ISK | + | |- valign="top" |
− | | Iceland Krona | + | |
− | |- | + | | GRD |
− | | INR | + | | Drachma |
− | | Indian Rupee | + | |- valign="top" |
− | |- | + | |
− | | IEP | + | | EGP |
− | | Irish Pound | + | | Egyptian Pound |
− | |- | + | |- valign="top" |
− | | ITL | + | |
− | | Italian Lira | + | | SVC |
− | |- | + | | El Salvador Colon |
− | | JMD | + | |- valign="top" |
− | | Jamaican Dollar | + | |
− | |- | + | | AED |
− | | JOD | + | | Emirati Dirham |
− | | Jordanian Dinar | + | |- valign="top" |
− | |- | + | |
− | | KES | + | | EUR |
− | | Kenyan Shilling | + | | EURO |
− | |- | + | |- valign="top" |
− | | EEK | + | |
− | | Kroon | + | | FJD |
− | |- | + | | Fiji Dollar |
− | | KWD | + | |- valign="top" |
− | | Kuwaiti Dinar | + | |
− | |- | + | | HUF |
− | | AOA | + | | Forint |
− | | Kwanza | + | |- valign="top" |
− | |- | + | |
− | | LVL | + | | FRF |
− | | Latvian Lats | + | | French Franc |
− | |- | + | |- valign="top" |
− | | LBP | + | |
− | | Lebanese Pound | + | | PYG |
− | |- | + | | Guarani |
− | | ALL | + | |- valign="top" |
− | | Lek | + | |
− | |- | + | | HKD |
− | | ROL | + | | Hong Kong Dollar |
− | | Leu | + | |- valign="top" |
− | |- | + | |
− | | LTL | + | | ISK |
− | | Lithuanian Litas | + | | Iceland Krona |
− | |- | + | |- valign="top" |
− | | MYR | + | |
− | | Malaysian Ringgit | + | | INR |
− | |- | + | | Indian Rupee |
− | | MTL | + | |- valign="top" |
− | | Maltese Lira | + | |
− | |- | + | | IEP |
− | | FIM | + | | Irish Pound |
− | | Markka | + | |- valign="top" |
− | |- | + | |
− | | MUR | + | | ITL |
− | | Mauritius Rupee | + | | Italian Lira |
− | |- | + | |- valign="top" |
− | | MXN | + | |
− | | Mexican Peso | + | | JMD |
− | |- | + | | Jamaican Dollar |
− | | MAD | + | |- valign="top" |
− | | Moroccan Dirham | + | |
− | |- | + | | JOD |
− | | NGN | + | | Jordanian Dinar |
− | | Naira | + | |- valign="top" |
− | |- | + | |
− | | NAD | + | | KES |
− | | Namibia Dollar | + | | Kenyan Shilling |
− | |- | + | |- valign="top" |
− | | NPR | + | |
− | | Nepalese Rupee | + | | EEK |
− | |- | + | | Kroon |
− | | ANG | + | |- valign="top" |
− | | Netherlands Antillian Guilder | + | |
− | |- | + | | KWD |
− | | NLG | + | | Kuwaiti Dinar |
− | | Netherlands Guilder | + | |- valign="top" |
− | |- | + | |
− | | ILS | + | | AOA |
− | | New Israeli Shekel | + | | Kwanza |
− | |- | + | |- valign="top" |
− | | TWD | + | |
− | | New Taiwan Dollar | + | | LVL |
− | |- | + | | Latvian Lats |
− | | NZD | + | |- valign="top" |
− | | New Zealand Dollar | + | |
− | |- | + | | LBP |
− | | BTN | + | | Lebanese Pound |
− | | Ngultrum | + | |- valign="top" |
− | |- | + | |
− | | NOK | + | | ALL |
− | | Norwegian Krone | + | | Lek |
− | |- | + | |- valign="top" |
− | | PEN | + | |
− | | Nuevo Sol | + | | ROL |
− | |- | + | | Leu |
− | | OMR | + | |- valign="top" |
− | | Omani Rial | + | |
− | |- | + | | LTL |
− | | PKR | + | | Lithuanian Litas |
− | | Pakistan Rupee | + | |- valign="top" |
− | |- | + | |
− | | PHP | + | | MYR |
− | | Philippine Peso | + | | Malaysian Ringgit |
− | |- | + | |- valign="top" |
− | | PLZ | + | |
− | | Polish Zloty(old) | + | | MTL |
− | |- | + | | Maltese Lira |
− | | PTE | + | |- valign="top" |
− | | Portuguese Escudo | + | |
− | |- | + | | FIM |
− | | GTQ | + | | Markka |
− | | Quetzal | + | |- valign="top" |
− | |- | + | |
− | | ZAR | + | | MUR |
− | | Rand | + | | Mauritius Rupee |
− | |- | + | |- valign="top" |
− | | MVR | + | |
− | | Rufiyaa | + | | MXN |
− | |- | + | | Mexican Peso |
− | | IDR | + | |- valign="top" |
− | | Rupiah | + | |
− | |- | + | | MAD |
− | | RUB | + | | Moroccan Dirham |
− | | Russian Ruble | + | |- valign="top" |
− | |- | + | |
− | | RUR | + | | NGN |
− | | Russian Ruble(old) | + | | Naira |
− | |- | + | |- valign="top" |
− | | SAR | + | |
− | | Saudi Riyal | + | | NAD |
− | |- | + | | Namibia Dollar |
− | | ATS | + | |- valign="top" |
− | | Shilling | + | |
− | |- | + | | NPR |
− | | SGD | + | | Nepalese Rupee |
− | | Singapore Dollar | + | |- valign="top" |
− | |- | + | |
− | | SKK | + | | ANG |
− | | Slovak Koruna | + | | Netherlands Antillian Guilder |
− | |- | + | |- valign="top" |
− | | ESP | + | |
− | | Spanish Peseta | + | | NLG |
− | |- | + | | Netherlands Guilder |
− | | LKR | + | |- valign="top" |
− | | Sri Lankan Rupee | + | |
− | |- | + | | ILS |
− | | SEK | + | | New Israeli Shekel |
− | | Swedish Krona | + | |- valign="top" |
− | |- | + | |
− | | CHF | + | | TWD |
− | | Swiss Franc | + | | New Taiwan Dollar |
− | |- | + | |- valign="top" |
− | | BDT | + | |
− | | Taka | + | | NZD |
− | |- | + | | New Zealand Dollar |
− | | SIT | + | |- valign="top" |
− | | Tolar | + | |
− | |- | + | | BTN |
− | | TTD | + | | Ngultrum |
− | | Trinidad and Tobago Dollar | + | |- valign="top" |
− | |- | + | |
− | | TND | + | | NOK |
− | | Tunisian Dinar | + | | Norwegian Krone |
− | |- | + | |- valign="top" |
− | | TRL | + | |
− | | Turkish Lira | + | | PEN |
− | |- | + | | Nuevo Sol |
− | | GBP | + | |- valign="top" |
− | | United Kingdom Pound | + | |
− | |- | + | | OMR |
− | | UYU | + | | Omani Rial |
− | | Uruguayan Peso | + | |- valign="top" |
− | |- | + | |
− | | USD | + | | PKR |
− | | US Dollar | + | | Pakistan Rupee |
− | |- | + | |- valign="top" |
− | | KRW | + | |
− | | Won | + | | PHP |
− | |- | + | | Philippine Peso |
− | | JPY | + | |- valign="top" |
− | | Yen | + | |
− | |- | + | | PLZ |
− | | CNY | + | | Polish Zloty(old) |
− | | Yuan Renminbi | + | |- valign="top" |
− | |- | + | |
− | | ZWD | + | | PTE |
− | | Zimbabwe Dollar | + | | Portuguese Escudo |
− | |- | + | |- valign="top" |
− | | PLN | + | |
− | | Zloty | + | | GTQ |
+ | | Quetzal | ||
+ | |- valign="top" | ||
+ | |||
+ | | ZAR | ||
+ | | Rand | ||
+ | |- valign="top" | ||
+ | |||
+ | | MVR | ||
+ | | Rufiyaa | ||
+ | |- valign="top" | ||
+ | |||
+ | | IDR | ||
+ | | Rupiah | ||
+ | |- valign="top" | ||
+ | |||
+ | | RUB | ||
+ | | Russian Ruble | ||
+ | |- valign="top" | ||
+ | |||
+ | | RUR | ||
+ | | Russian Ruble(old) | ||
+ | |- valign="top" | ||
+ | |||
+ | | SAR | ||
+ | | Saudi Riyal | ||
+ | |- valign="top" | ||
+ | |||
+ | | ATS | ||
+ | | Shilling | ||
+ | |- valign="top" | ||
+ | |||
+ | | SGD | ||
+ | | Singapore Dollar | ||
+ | |- valign="top" | ||
+ | |||
+ | | SKK | ||
+ | | Slovak Koruna | ||
+ | |- valign="top" | ||
+ | |||
+ | | ESP | ||
+ | | Spanish Peseta | ||
+ | |- valign="top" | ||
+ | |||
+ | | LKR | ||
+ | | Sri Lankan Rupee | ||
+ | |- valign="top" | ||
+ | |||
+ | | SEK | ||
+ | | Swedish Krona | ||
+ | |- valign="top" | ||
+ | |||
+ | | CHF | ||
+ | | Swiss Franc | ||
+ | |- valign="top" | ||
+ | |||
+ | | BDT | ||
+ | | Taka | ||
+ | |- valign="top" | ||
+ | |||
+ | | SIT | ||
+ | | Tolar | ||
+ | |- valign="top" | ||
+ | |||
+ | | TTD | ||
+ | | Trinidad and Tobago Dollar | ||
+ | |- valign="top" | ||
+ | |||
+ | | TND | ||
+ | | Tunisian Dinar | ||
+ | |- valign="top" | ||
+ | |||
+ | | TRL | ||
+ | | Turkish Lira | ||
+ | |- valign="top" | ||
+ | |||
+ | | GBP | ||
+ | | United Kingdom Pound | ||
+ | |- valign="top" | ||
+ | |||
+ | | UYU | ||
+ | | Uruguayan Peso | ||
+ | |- valign="top" | ||
+ | |||
+ | | USD | ||
+ | | US Dollar | ||
+ | |- valign="top" | ||
+ | |||
+ | | KRW | ||
+ | | Won | ||
+ | |- valign="top" | ||
+ | |||
+ | | JPY | ||
+ | | Yen | ||
+ | |- valign="top" | ||
+ | |||
+ | | CNY | ||
+ | | Yuan Renminbi | ||
+ | |- valign="top" | ||
+ | |||
+ | | ZWD | ||
+ | | Zimbabwe Dollar | ||
+ | |- valign="top" | ||
+ | |||
+ | | PLN | ||
+ | | Zloty | ||
|} | |} | ||
+ | |||
== automatically generated == | == automatically generated == | ||
Line 399: | Line 545: | ||
| Sales.Currency | | Sales.Currency | ||
|- valign="top" | |- valign="top" | ||
− | |||
| '''Description | | '''Description | ||
| Lookup table containing standard ISO currencies. | | Lookup table containing standard ISO currencies. | ||
|- | |- | ||
− | |||
|} | |} | ||
Latest revision as of 09:56, 27 August 2011
Contents
wikibot[edit]
Table | Sales.Currency |
Description | Lookup table containing standard ISO currencies. |
Columns[edit]
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[edit]
Primary Key | Columns |
PK_Currency_CurrencyCode | CurrencyCode |
Indexes[edit]
Index | Type | Columns |
AK_Currency_Name | Unique | Name |
Detail Tables[edit]
Detail Table | Column | Referencing Column |
Sales.CountryRegionCurrency | CurrencyCode | CurrencyCode |
Sales.CurrencyRate | CurrencyCode | FromCurrencyCode |
Sales.CurrencyRate | CurrencyCode | ToCurrencyCode |
References[edit]
Dependency Type | Object Type | Referenced Object |
Data Type | Type | dbo.Name |
Schema | Schema | Sales |
wikivalues[edit]
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 |
automatically generated[edit]
Table | Sales.Currency |
Description | Lookup table containing standard ISO currencies. |
Column | Data Type | Nullable | Default | Description / PK / Index |
CurrencyCode | nchar(3) | not null | The ISO code for the Currency. PK_Currency_CurrencyCode | |
Name | Name | not null | Currency name. AK_Currency_Name | |
ModifiedDate | datetime | not null | (GETDATE()) | Date and time the record was last updated. |
Detail Table | Column | Referencing Column |
Sales.CountryRegionCurrency | CurrencyCode | CurrencyCode |
Sales.CurrencyRate | CurrencyCode | FromCurrencyCode |
Sales.CurrencyRate | CurrencyCode | ToCurrencyCode |
Dependency Type | Object Type | Referenced Object |
Data Type | Type | dbo.Name |
Schema | Schema | Sales |