Editing Sales.Currency (table)

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''Table
| Sales.Currency
|- valign="top"
| '''Description
| Lookup table containing standard ISO currencies.
|}

=== Columns ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column
| '''Data Type
| '''Nullable
| '''Default
| '''Description

|- valign="top"
| CurrencyCode
| nchar(3)
| not null
| 
| The ISO code for the Currency.
|- valign="top"
| Name
| dbo.Name
| not null
| 
| Currency name.
|- valign="top"
| ModifiedDate
| datetime
| not null
| (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"
|- style="background:silver"
| '''Detail Table
| '''Column
| '''Referencing Column

|- valign="top"
| [[Sales.CountryRegionCurrency_(table)|Sales.CountryRegionCurrency]]
| CurrencyCode
| CurrencyCode
|- valign="top"
| [[Sales.CurrencyRate_(table)|Sales.CurrencyRate]]
| CurrencyCode
| FromCurrencyCode
|- valign="top"
| [[Sales.CurrencyRate_(table)|Sales.CurrencyRate]]
| CurrencyCode
| 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 ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''Table Values
| Sales.Currency
|-
|}


{| border="1" cellpadding="5" cellspacing="0"  style="border-collapse:collapse"
|- style="background:silver" 
| '''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 ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''Table
| Sales.Currency
|- valign="top"
| '''Description
| Lookup table containing standard ISO currencies.
|-
|}


{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column
| '''Data Type
| '''Nullable
| '''Default
| '''Description / PK / Index
		
|- valign="top"
| CurrencyCode
| nchar(3)
| not null
| 
| The ISO code for the Currency.<br />PK_Currency_CurrencyCode
|- valign="top"
| Name
| Name
| not null
| 
| Currency name.<br />AK_Currency_Name
|- valign="top"
| ModifiedDate
| datetime
| not null
| (GETDATE())
| Date and time the record was last updated.<br />
|}



{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Detail Table
| '''Column
| '''Referencing Column
		
|-
| [[Sales.CountryRegionCurrency_(table)|Sales.CountryRegionCurrency]]
| CurrencyCode
| CurrencyCode
|-
| [[Sales.CurrencyRate_(table)|Sales.CurrencyRate]]
| CurrencyCode
| FromCurrencyCode
|-
| [[Sales.CurrencyRate_(table)|Sales.CurrencyRate]]
| CurrencyCode
| ToCurrencyCode
|}


{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Dependency Type
| '''Object Type
| '''Referenced Object

|-
| Data Type
| Type
| [[dbo.Name_(type)|dbo.Name]]

|-
| Schema
| Schema
| [[Sales_(schema)|Sales]]

|}