Touchstone 4.0 Database Documentation
tCurrency Table
Description

Stores the AIR currency codes.

Properties
Creation Date2/16/2011 6:00 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows169
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key 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
  • BTN = Bhutan Ngultrum
  • BWP = Botswana Pula
  • BYR = Belarus Ruble
  • BZD = Belize Dollar
  • CAD = Canada Dollar
  • CDF = DR Congo Franc Congolais
  • CHF = Switzerland Franc
  • CLF = (Chile) Unidad de fomento
  • CLP = Chile Peso
  • CNY = China Renminbi
  • COP = Colombia Peso
  • CRC = Costa Rica Colon
  • CUP = Cuba Peso
  • CVE = Cape Verde Escudo
  • CYP = Cypriot Pound
  • 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 = (Chile) Unidades de fomento
  • UGX = Uganda Shilling
  • USD = U.S. Dollar
  • UYU = Uruguay Peso
  • UZS = Uzbekistan Som
  • VEF = Venezuela Bolivar Fuerte
  • 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
Char3   
 Currency

Name of the currency code.

Corresponds to the code in CurrencyCode.

VarChar40   
 DescriptionDescription of the currency code.VarChar1024  
 IsActive

Indicates whether the currency is available for use. 

  • 1 = Yes (available
  • 0 = No (not available)
Boolean1 
((1))
 
Check Constraints
NameDescriptionExpression
CK__tCurrency__IsAct__62CF9BA3 
([IsActive]>=(0) AND [IsActive]<=(1))
Objects that depend on tCurrency
 Database ObjectObject TypeDescriptionDep Level
tCountryCurrencyXref tabletCountryCurrencyXrefTableReserved for internal use, this system reference table is used by Touchstone to map currency to a county when exporting CLF and UNICEDE/2 files for CATRADER .1
See Also

Related Objects

AIRReference Database

 

 


AIR Client Confidential

© 2016. 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.