tCurrency Table

Stores AIR currency codes.

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

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
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))

	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

Related Objects

AIRReference Database