LEI

identity.payment.lei

Legal Entity Identifier. 20-character alphanumeric code that uniquely identifies legal entities participating in financial transactions. Format: 4-digit LOU (Local Operating Unit) prefix + 14-character entity identifier + 2 check digits (ISO 7064 Mod 97-10, same algorithm as IBAN check digits).

Domain identity›payment

Casts to VARCHAR

Scope Universal

Try it

CLI

$ finetype infer -i "529900T8BM49AURSDO55"
→ identity.payment.lei

DuckDB

Detect

SELECT finetype('529900T8BM49AURSDO55');
-- → 'identity.payment.lei'

Cast expression

CAST({col} AS VARCHAR)

Safe cast pipeline

-- Normalise and cast in one step
SELECT TRY_CAST(finetype_cast(my_column) AS VARCHAR) AS clean_value
FROM my_table
WHERE finetype(my_column) = 'identity.payment.lei';

Struct Expansion

check_digits: SUBSTRING({col}, 19, 2)
entity_id: SUBSTRING({col}, 5, 14)
lou_prefix: SUBSTRING({col}, 1, 4)

JSON Schema

finetype schema identity.payment.lei

{
  "$id": "https://noon.sh/schemas/identity.payment.lei",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Legal Entity Identifier. 20-character alphanumeric code that uniquely identifies legal entities participating in financial transactions. Format: 4-digit LOU (Local Operating Unit) prefix + 14-character entity identifier + 2 check digits (ISO 7064 Mod 97-10, same algorithm as IBAN check digits).",
  "examples": [
    "529900T8BM49AURSDO55",
    "213800WSGIIZCXF1P572",
    "549300MLUDYVRQOOXS22"
  ],
  "pattern": "^[0-9]{4}[A-Z0-9]{14}[0-9]{2}$",
  "title": "LEI",
  "type": "string"
}

Examples

529900T8BM49AURSDO55213800WSGIIZCXF1P572549300MLUDYVRQOOXS22

Also known as

legal_entity_identifier

LEI

LEI