bank_iban

Data license: CC-BY-4.0 · Data source: bankproducts.info

164 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: iid_ranges (array)

Next page

CREATE TABLE bank_iban (
    bank_id          TEXT PRIMARY KEY REFERENCES bank(id),
    -- 5-digit clearing number / Bankleitzahl (BC). Same as `sic_iid` for most
    -- banks but stored separately because:
    --   1. some banks have multiple IIDs (a federation umbrella + its members)
    --   2. sic_iid is the SIX interbank-clearing participant number; clearing_number
    --      is the IBAN-routing number — usually equal, occasionally different
    clearing_number  TEXT,
    iban_pattern     TEXT,        -- "CHxx 0076 1xxx xxxx xxxx x"
    qr_iban_pattern  TEXT,        -- "CHxx 3076 1xxx xxxx xxxx x" (QR-IBAN format)
    iid_ranges       TEXT,        -- JSON array of 5-digit IIDs, e.g. '["00761"]'
                                  -- Multiple values for banks with multiple BC numbers
    qr_iid           INTEGER      -- Numeric QR-IBAN IID, e.g. 30761
                                  -- (Range 30000-31999 is reserved for QR-bills)
);