MeridianMERIDIAN

Currency Code (ISO 4217)

Three-letter currency code as defined by ISO 4217. Examples: USD, EUR, GBP, JPY. Used in financial data, trading systems, and international commerce.

Currency Code (ISO 4217)

finance.currency.currency_code

Three-letter currency code as defined by ISO 4217. Examples: USD, EUR, GBP, JPY. Used in financial data, trading systems, and international commerce.

Domain
finance
Category
currency
Casts to
VARCHAR
Scope
Universal

Try it

CLI
$ finetype infer -i "USD" --mode column
→ finance.currency.currency_code

DuckDB

Detect
SELECT ft_infer('USD');
-- → 'finance.currency.currency_code'
Cast expression
UPPER(CAST({col} AS VARCHAR))
Safe cast pipeline
-- Normalise and cast in one step
SELECT TRY_CAST(ft_cast(my_column) AS VARCHAR) AS clean_value
FROM my_table
WHERE ft_infer(my_column) = 'finance.currency.currency_code';

JSON Schema

finetype taxonomy finance.currency.currency_code -o json-schema
{
  "$id": "https://meridian.online/schemas/finance.currency.currency_code",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Three-letter currency code as defined by ISO 4217. Examples: USD, EUR, GBP, JPY. Used in financial data, trading systems, and international commerce.",
  "enum": [
    "AED",
    "AFN",
    "ALL",
    "AMD",
    "ANG",
    "AOA",
    "ARS",
    "AUD",
    "AWG",
    "AZN",
    "BAM",
    "BBD",
    "BDT",
    "BGN",
    "BHD",
    "BIF",
    "BMD",
    "BND",
    "BOB",
    "BRL",
    "BSD",
    "BTN",
    "BWP",
    "BYN",
    "BZD",
    "CAD",
    "CDF",
    "CHF",
    "CLP",
    "CNY",
    "COP",
    "CRC",
    "CUC",
    "CUP",
    "CVE",
    "CZK",
    "DJF",
    "DKK",
    "DOP",
    "DZD",
    "EGP",
    "ERN",
    "ETB",
    "EUR",
    "FJD",
    "FKP",
    "GBP",
    "GEL",
    "GHS",
    "GIP",
    "GMD",
    "GNF",
    "GTQ",
    "GYD",
    "HKD",
    "HNL",
    "HRK",
    "HTG",
    "HUF",
    "IDR",
    "ILS",
    "INR",
    "IQD",
    "IRR",
    "ISK",
    "JMD",
    "JOD",
    "JPY",
    "KES",
    "KGS",
    "KHR",
    "KMF",
    "KPW",
    "KRW",
    "KWD",
    "KYD",
    "KZT",
    "LAK",
    "LBP",
    "LKR",
    "LRD",
    "LSL",
    "LYD",
    "MAD",
    "MDL",
    "MGA",
    "MKD",
    "MMK",
    "MNT",
    "MOP",
    "MRU",
    "MUR",
    "MVR",
    "MWK",
    "MXN",
    "MYR",
    "MZN",
    "NAD",
    "NGN",
    "NIO",
    "NOK",
    "NPR",
    "NZD",
    "OMR",
    "PAB",
    "PEN",
    "PGK",
    "PHP",
    "PKR",
    "PLN",
    "PYG",
    "QAR",
    "RON",
    "RSD",
    "RUB",
    "RWF",
    "SAR",
    "SBD",
    "SCR",
    "SDG",
    "SEK",
    "SGD",
    "SHP",
    "SLE",
    "SOS",
    "SRD",
    "SSP",
    "STN",
    "SVC",
    "SYP",
    "SZL",
    "THB",
    "TJS",
    "TMT",
    "TND",
    "TOP",
    "TRY",
    "TTD",
    "TWD",
    "TZS",
    "UAH",
    "UGX",
    "USD",
    "UYU",
    "UZS",
    "VED",
    "VES",
    "VND",
    "VUV",
    "WST",
    "XAF",
    "XAG",
    "XAU",
    "XCD",
    "XDR",
    "XOF",
    "XPD",
    "XPF",
    "XPT",
    "YER",
    "ZAR",
    "ZMW",
    "ZWL"
  ],
  "examples": [
    "USD",
    "EUR",
    "GBP",
    "JPY",
    "CHF",
    "AUD"
  ],
  "title": "Currency Code (ISO 4217)",
  "type": "string",
  "x-finetype-label": "finance.currency.currency_code",
  "x-finetype-pii": false
}

Examples

USDEURGBPJPYCHFAUD

Aliases

iso_4217currency_iso

Type Registry