tCurrency Table

CEDE 9.0 Database Reference

tCurrency Table

Collapse All

AIRReference Database : tCurrency Table

Description

Stores AIR currency codes.

Properties

Creation Date	2/16/2011 6:00 PM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	171
Data Space Used	8.00 KB
Index Space Used	8.00 KB

Columns

	Column Name	Description	Datatype	Length	Allow Nulls	Default	Formula
	CurrencyCode	ISO 3-character code for the currency. The following currencies are not active, but are maintained for compatibility: ZWL CYP GHC MXP TMT UF/CLF AED = United Arab Emirates Dirham AFN = Afghanistan Afghani ALL = Albania Lek AMD = Armenia Dram ANG = Netherlands Antillean Guilder AOA = Angola Kwanza ARS = Argentina Peso AUD = Australia Dollar AWG = Aruba Guilder AZM = Old Azerbaijan Manat AZN = Azerbaijan Manat BAM= Bosnia Convertible Marks BBD = Barbados Dollar BDT = Bangladesh Taka BGN = Bulgaria Lev BHD = Bahrain Dinar BIF = Burundi Franc BMD = Bermuda Dollar BND = Brunei Dollar BOB = Bolivia Boliviano BOV = Bolivia Mvdol BRL = Brazil Real BSD = Bahamas Dollar BQ = United States Dollar BTN = Bhutan Ngultrum BWP = Botswana Pula BYR = Belarus Ruble BYN = Belarus Ruble BZD = Belize Dollar CAD = Canada Dollar CDF = DR Congo Franc Congolais CHF = Switzerland Franc CLF = Chilean Unidad de Fomento CLP = Chile Peso CNY = China Renminbi COP = Colombia Peso CRC = Costa Rica Colon CUC = Cuba Peso Covertible CUP = Cuba Peso CVE = Cape Verde Escudo CYP = Cypriot Pound CW = Netherlands Antillean guilder CZK = Czech Republic Koruna DJF = Djibouti Franc DKK = Denmark Krone DOP = Dominican Rep. Peso DZD = Algeria Dinar EEK = Estonia Kroon EGP = Egypt Pound ERN = Eritrea Nakfa ETB = Ethiopia Birr EUR = Euro FJD = Fiji Dollar FKP = Falkland Islands Pound GBP = Great Britain Pound GEL = Georgia Lari GHC = Ghana Cedi GHS = Ghana Cedi GIP = Gibraltar Pound GMD = Gambia Dalasi GNF = Guinea Franc GTQ = Guatemala Quetzal GYD = Guyana Dollar HKD = Hong Kong Dollar HNL = Honduras Lempira HRK = Croatia Kuna HTG = Haiti Gourde HUF = Hungary Forint IDR = Indonesia Rupiah ILS = Israel New Shekel INR= India Rupee IQD = Iraq Dinar IRR = Iran Rial ISK = Iceland Krona JMD = Jamaica Dollar JOD = Jordan Dinar JPY = Japan Yen KES = Kenya Shilling KGS = Kyrgyzstan Som KHR = Cambodia Riel KMF = Comoro Franc KPW = North Korea Won KRW = South Korea Won KWD= Kuwait Dinar KYD = Cayman Islands Dollar KZT = Kazakhstan Tenge LAK = Laos Kip LBP = Lebanon Pound LKR = Sri Lanka Rupee LRD = Liberia Dollar LSL = Lesotho Loti LTL = Lithuania Litas LVL = Latvia Lats LYD = Libya Dinar MAD = Morocco Dirham MDL = Moldova Leu MGA = Madagascar Malagasy Ariary MKD = Macedonia Denar MMK = Myanmar Kyat MNT = Mongolia Tugrik MOP = Macau Pataca MRO = Mauritania Ouguiya MTL = Malta Lira MUR = Mauritius Rupee MVR = Maldives Rufiyaa MWK = Malawi Kwacha MXN = Mexico Peso MXP = Mexico Peso MXV = Mexico Unidad de Inversion MYR = Malaysia Ringgit MZN = Mozambique Metical NAD = Namibia Dollar NGN = Nigeria Naira NIO = Nicaragua Cordoba Oro NOK = Norway Kroner NPR = Nepal Rupee NZD = New Zealand Dollar OMR = Oman Rial PAB = Panama Balboa PEN = Peru Nuevo Sol PGK = Papua New Guinea Kina PHP = Philippines Peso PKR = Pakistan Rupee PLN = Poland Zloty PYG = Paraguay Guarani QAR = Qatar Rial RON = Romania New Leu RSD = Serbia Dinar RUB = Russia Ruble RWF = Rwanda Franc SAR = Saudi Arabia Riyal SBD = Solomon Islands Dollar SCR = Seychelles Rupee SDD = Sudan Dinar SDG = Sudan Pound SEK = Sweden Krona SGD = Singapore Dollar SHP = Saint Helena Pound SIT = Slovenia Tolar SLL = Sierra Leone, Leone SOS = Somalia Shilling SRD = Suriname Dollar STD = Sao Tome and Principe Dobra SVC = El Salvador Colon SYP = Syria Pound SZL = Swaziland Lilangeni THB = Thailand Baht TJS = Tajikistan Somoni TMT = Turkmenistani Manat TND = Tunisia Dinar TOP = Tonga Paanga TRY = Turkey New Lira TTD = Trinidad and Tobago Dollar TWD = Taiwan Dollar TZS = Tanzania Shilling UAH = Ukraine Hryvnia UF = Chilean Unidad de Fomento UGX = Uganda Shilling USD = U.S. Dollar UYU = Uruguay Peso UZS = Uzbekistan Som VEF = Venezuela Bolivar Fuerte VES = Venezuelan Bolivar Soberano VND = Vietnam Dong VUV = Vanuatu Vatu WST = Samoa Tala XAF = CFA Franc BEAC XCD = Eastern Caribbean Dollar XOF = CFA Franc BCEAO XPF = CFP Franc YER = Yemen Rial ZAR = South Africa Rand ZMK = Zambia Kwacha ZWL = Zimbabwe Dollar	char	3
	Currency	Name of the currency code. Corresponds to the code in CurrencyCode.	varchar	40
	Description	Description of the currency code.	varchar	1024
	IsActive	Indicates whether the currency is available for use. 1 = Yes (available) 0 = No (not available)	bit	1		((1))
	IsAnalyzeReCompatible	Indicates whether the currency is supported in Analyze Re. 1 = Yes (supported) 0 = No (not supported)	bit	1		((1))

Objects that depend on tCurrency

	Database Object	Object Type	Description	Dep Level
	tCountryCurrencyXref	Table	System reference table used to map currencies to countries when exporting company loss files (CLFs) and UNICEDE/2 files for CATRADER.	1

See Also

Related Objects

AIRReference Database

© 2021. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.