home / bankproducts

Products

Retail banking products. Each row is one product offered by one bank. Categories: current_account, savings_account, pillar_3a, vested_benefits, mortgage, credit_card, debit_card, term_deposit, wealth_management, securities_trading, etc.

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

27 rows where bank_id = "llb_ch" sorted by bank_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: category, currency, client_type, target_group, access_tier, product_type, valid_from (date)

id bank_id ▲ category name currency client_type target_group description valid_from source_document_id bpg access_tier is_tailored notice_period_days iso_account_type age_range_min age_range_max age_range_label age_range_max_extended age_range_extension_condition status product_type
llb_ch:privatkonto LLB (Schweiz) AG llb_ch current_account Privatkonto CHF private standard Privatkonto in CHF, EUR oder USD. Im LLB Daily Bankpaket inkludiert. Transparente Kontofuehrung, monatlicher Auszug.     BPG003SA5MMT free 0               active fx_account
llb_ch:privatkonto_youli LLB (Schweiz) AG llb_ch current_account Privatkonto youli (12-26 Jahre) CHF private youth Privatkonto fuer junge Erwachsene 12-26 Jahre. Im kostenlosen Paket LLB Flex inkludiert.     BPG003EKF8DF free 0               active current_account
llb_ch:fremdwaehrungskonto LLB (Schweiz) AG llb_ch current_account Fremdwaehrungskonto EUR private standard Konto in EUR/USD/anderen Fremdwaehrungen. Konkrete Konditionen ueber LLB Downloadcenter.     BPG0037AMWAV free 0               active fx_account
llb_ch:kontokorrent LLB (Schweiz) AG llb_ch current_account Kontokorrent CHF business standard Kontokorrent fuer Firmen. Monatlicher Auszug inkl. halbjaehrlichem Kontoabschluss.     BPG003YSGMVZ free 0               active current_account
llb_ch:mietkautionskonto LLB (Schweiz) AG llb_ch savings_account Mietkautionssparkonto CHF private standard Konto fuer Mietkautionen. Einmalige Eroeffnungsgebuehr CHF 50, dann kostenlose Kontofuehrung.     BPG003CVNJXE free 0               active rent_deposit_account
llb_ch:kapitaleinzahlungskonto LLB (Schweiz) AG llb_ch savings_account Kapitaleinzahlungskonto CHF business standard Zinsloses Konto fuer Hinterlegung des Gesellschaftskapitals bei Gruendung. Bestaetigung fuer Handelsregister. Bei Auszahlung: Bearbeitungsgebuehr 1 Promille (min CHF 250).     BPG003HRSCSR free 0               active capital_deposit_account
llb_ch:sparkonto_you_save LLB (Schweiz) AG llb_ch savings_account Sparkonto you save (12-26 Jahre) CHF private youth Sparkonto fuer Kinder und Jugendliche 12-26 Jahre. Kostenlose Kontofuehrung. Attraktiver Vorzugszins (Stand auf Anfrage).     BPG003HK38MY free 0               active savings_account
llb_ch:jugendsparkonto LLB (Schweiz) AG llb_ch savings_account Jugendsparkonto (bis 18 Jahre) CHF private youth Konto fuer Eltern/Grosseltern im Namen des Kindes. Vorzugszinssatz bis CHF 50'000 Saldo. Auszahlung nur auf Konto im Namen des Kindes. Kostenlose Kontofuehrung.     BPG003ZQ96JV free 0               active savings_account
llb_ch:geschenksparkonto LLB (Schweiz) AG llb_ch savings_account Geschenksparkonto CHF private youth Langfristiges Sparkonto fuer Geschenke an Kinder. Bis CHF 20'000/Monat kuendigungsfrei. Kostenlose Kontofuehrung, jaehrlicher Auszug.     BPG003JREC3E free 0               active gift_savings_account
llb_ch:vorsorgesparkonto_3a LLB (Schweiz) AG llb_ch pillar_3a Vorsorgesparkonto 3a CHF private standard Saeule 3a gebundene Vorsorge. Max-Einzahlung 2026: CHF 7'258 (mit PK-Anschluss) / CHF 36'288 (ohne; 20% des Einkommens).     BPG00398R4HK pro 0               active pillar_3a_account
llb_ch:freizuegigkeitskonto LLB (Schweiz) AG llb_ch vested_benefits Freizuegigkeitskonto CHF private standard Konto fuer freizuegige BVG-Gelder. Konkrete Verzinsung auf Anfrage.     BPG003BR8AKX pro 0               active vested_benefits_account
llb_ch:daily_pro LLB (Schweiz) AG llb_ch package LLB Pro CHF private wealthy Premium-Bankpaket: 2 Debitkarten + 2 Kreditkarten (Classic/Gold) inkludiert. Bargeldbezuege weltweit kostenlos. Ueberweisungen weltweit kostenlos. CHF 24.90/Monat.     BPG003JCEMD9 free 0               active banking_package
llb_ch:daily_flex LLB (Schweiz) AG llb_ch package LLB Flex CHF private standard Mittleres Bankpaket: 1 Debitkarte. Bargeldbezuege in CH/FL/AT/DE kostenlos. Kreditkarten optional. CHF 9.90/Monat.     BPG003SF49M9 free 0               active banking_package
llb_ch:daily_light LLB (Schweiz) AG llb_ch package LLB Light CHF private standard Basis-Bankpaket: 1 Debitkarte (CHF 2 Bezugsgebuehr). Keine Kreditkarte. Ueberweisungen weltweit kostenlos. CHF 4.90/Monat.     BPG003Y33S1K free 0               active banking_package
llb_ch:business_pro LLB (Schweiz) AG llb_ch package LLB Business Pro CHF business wealthy Premium-Firmenpaket: 2 Visa Debitkarten + 2 Kreditkarten. Bargeldbezuege weltweit kostenlos. EBICS + LLB Connect Schnittstellen. Ab CHF 25/Monat.     BPG003SXP0VF free 0               active banking_package
llb_ch:business_flex LLB (Schweiz) AG llb_ch package LLB Business Flex CHF business standard Mittleres Firmenpaket: 1 Visa Debitkarte. Bezuege in CH/FL/AT/DE kostenlos. EBICS + LLB Connect. CHF 15/Monat.     BPG003KGAKVS free 0               active banking_package
llb_ch:business_light LLB (Schweiz) AG llb_ch package LLB Business Light CHF business standard Basis-Firmenpaket: Ueberweisungen weltweit kostenlos. eBill/QR-Rechnung. Keine Karte inkludiert. CHF 10/Monat.     BPG003SEE2JG free 0               active banking_package
llb_ch:visa_debit LLB (Schweiz) AG llb_ch debit_card Visa Debitkarte CHF private standard Bargeldbezuege weltweit (Konditionen je nach Bankpaket). Bargeldloses Bezahlen weltweit. Bis CHF 80 kontaktlos ohne PIN. Im LLB Daily Paket inkludiert.     BPG003CNHTHY free 0               active debit_card
llb_ch:credit_classic LLB (Schweiz) AG llb_ch credit_card Kreditkarte Classic (Cornèrcard) CHF private standard Classic Visa/Mastercard, von Cornèrcard ausgegeben. Cashback 0.3% (CHF) / 0.6% (Fremdwaehrungen). Einkaufsschutz- und Rechtsschutz-Versicherung inkl.     BPG0032D62BJ free 0               active credit_card_classic
llb_ch:credit_gold LLB (Schweiz) AG llb_ch credit_card Kreditkarte Gold (Cornèrcard) CHF private premium Gold Visa/Mastercard, von Cornèrcard ausgegeben. Cashback 0.6% (CHF) / 1.2% (Fremdwaehrungen) — doppelte Rate gegenueber Classic. Einkaufsschutz- + Rechtsschutz-Versicherung.     BPG003PRC7HF free 0               active credit_card_gold
llb_ch:travel_karte LLB (Schweiz) AG llb_ch prepaid_card Swiss Bankers Travel Karte CHF private standard Prepaid Reisekarte via Swiss Bankers. Keine Jahresgebuehr. Aufladbar. Bei Verlust weltweit ersetzt (inkl. Restwert).     BPG003YY576Q free 0               active prepaid_card
llb_ch:variable_hypothek LLB (Schweiz) AG llb_ch mortgage Variable Hypothek CHF private standard Variable Hypothek ohne feste Laufzeit. 3 Monate Kuendigungsfrist. Mindestbetrag CHF 20'000. Konkreter Zinssatz auf Anfrage.     BPG003DXABQQ pro 0               active variable_mortgage
llb_ch:festhypothek LLB (Schweiz) AG llb_ch mortgage Festhypothek CHF private standard Festhypothek 2-10 Jahre Laufzeit. Zinsen 2026-05-08: 2J 1.36% / 5J 1.53% / 10J 1.94%. Basis: Bankfinanzierung selbstbewohntes Wohneigentum bis 70% Belehnung.     BPG00363WC7X pro 0               active fixed_rate_mortgage
llb_ch:geldmarkt_hypothek LLB (Schweiz) AG llb_ch mortgage Geldmarkt-Hypothek CHF private wealthy SARON/CMS-basierte Hypothek mit 3-Monatlicher Zinsabrechnung und 5-jaehriger Rahmen-Laufzeit. Bankmarge 1.05% (Stand 2026-05-08). Zinsfixierung 7 Tage vor Periodenende.     BPG003X0HDFK pro 0               active saron_mortgage
llb_ch:vermoegensverwaltung LLB (Schweiz) AG llb_ch wealth_management Vermoegensverwaltung CHF private wealthy Discretionaere Vermoegensverwaltung ab CHF 250'000. Asset Management Mandat. Wahl zwischen pauschalem Tarif und performanceabhaengigem Tarif mit High Watermark.     BPG003J0CEVS pro 0               active discretionary_mandate
llb_ch:online_mobile_banking LLB (Schweiz) AG llb_ch ebanking LLB Online + Mobile Banking CHF private standard E-Banking und Mobile App. Apple Pay, Google Pay, Samsung Pay, TWINT. Ueberweisungen weltweit (CHF/EUR) kostenlos. eBill, QR-Rechnung.     BPG003397MND free 0               active ebanking_access
llb_ch:sparkonto LLB (Schweiz) AG llb_ch savings_account Sparkonto CHF private standard LLB (Schweiz) Sparkonto fuer Erwachsene. Verzinsung paket-tier-differenziert: LLB Pro (auch LLB Xpert Pro) 0.200%/0.100%/0% (bis 25k/bis 50k/darueber), LLB Flex 0.100%/0.050%/0%, LLB Light + Weitere Sparkonten 0.000% ueber alle Tranchen. 2026-04-01 Zinssatzblatt (April 2026) 733 BPG0036WRJ10 free 0               active savings_account

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE product (
    id                  TEXT PRIMARY KEY,  -- zkb:privatkonto, ubs:key4_banking
    bank_id             TEXT NOT NULL REFERENCES bank(id),
    category            TEXT NOT NULL,     -- current_account, savings_account, pillar_3a, vested_benefits,
                                           -- debit_card, credit_card, prepaid_card, package, ebanking,
                                           -- mortgage, wealth_management, term_deposit, securities_trading,
                                           -- fiduciary_deposit, safe_deposit, guarantee, leasing,
                                           -- financial_planning, personal_advisory, loyalty_program,
                                           -- digital_vault, fx_subscription, robo_advisory, self_directed_trading,
                                           -- metal_account, deposit_account, check
    name                TEXT NOT NULL,     -- bank's own product name
    currency            TEXT DEFAULT 'CHF',
    client_type         TEXT DEFAULT 'private',  -- private, business, institutional
    target_group        TEXT,              -- standard, young, children, students, seniors, eco, gift, rental_deposit, member
    description         TEXT,
    valid_from          TEXT,
    source_document_id  INTEGER REFERENCES source_document(id),
    bpg                 CHAR(12)        -- opaque global id, BPG003xxxxxx; populated post-load by bpg_assignments.sql
        CHECK (bpg IS NULL OR bpg GLOB 'BPG003[0-9A-HJKMNP-TV-Z][0-9A-HJKMNP-TV-Z][0-9A-HJKMNP-TV-Z][0-9A-HJKMNP-TV-Z][0-9A-HJKMNP-TV-Z][0-9A-HJKMNP-TV-Z]'),
    access_tier         TEXT NOT NULL DEFAULT 'free'  -- freemium gating: free public, pro/business paid
        CHECK (access_tier IN ('free', 'pro', 'business')),
    is_tailored         INTEGER             -- v2.6 (atom #278): mirrors CDS-AU (Australian Open Banking) isTailored.
                                            --   0 = pricing publicly published in a schedule (machine-readable, comparable);
                                            --   1 = negotiated per client (UHNW classical private banking, business loans);
                                            --   NULL = unknown / not yet classified (default for new loads).
                                            -- Distinguishes "we haven't crawled it" (NULL) from "bank deliberately
                                            -- doesn't publish because it's relationship-priced" (1) — three states
                                            -- that previously collapsed into "fee.amount IS NULL".
        CHECK (is_tailored IS NULL OR is_tailored IN (0, 1)),
    notice_period_days  INTEGER             -- v2.7 (atom #307): normalised withdrawal notice in days.
                                            --   0/NULL = on-demand; X = days notice. Conversion: months×30,
                                            --   years×365, days verbatim. Backfilled from
                                            --   product_feature.notice_period free-text by
                                            --   db/notice_period_backfill.sql.
        CHECK (notice_period_days IS NULL OR notice_period_days >= 0),
    iso_account_type    CHAR(4)             -- v2.8 (atom #308): ISO 20022 ExternalCashAccountType1Code.
                                            --   4-letter code from the official ISO enum: CACC (Current),
                                            --   SVGS (Savings), LOAN, SACC (Special), MOMA (Money Market),
                                            --   CHAR (Charges), CASH, etc.
                                            --   NULL for categories outside ISO scope: cards
                                            --   (debit/credit/prepaid), mandates (wealth_management,
                                            --   securities_trading, fiduciary_deposit), CH-specific
                                            --   (pillar_3a, vested_benefits, pension_account).
                                            --   Mapped from `category` by db/iso_account_type_backfill.sql.
                                            --   Backfill is conservative — when in doubt, leave NULL rather
                                            --   than force-fit a code that misrepresents the product.
        CHECK (iso_account_type IS NULL OR iso_account_type GLOB '[A-Z][A-Z][A-Z][A-Z]'),
    -- v3.1 (2026-08-12): age-cohort progression fields (atom #397). NULL = unrestricted.
    -- Populated by db/age_range_backfill.sql from product.name/description regex.
    age_range_min       INTEGER
        CHECK (age_range_min IS NULL OR (age_range_min >= 0 AND age_range_min <= 120)),
    age_range_max       INTEGER
        CHECK (age_range_max IS NULL OR (age_range_max >= 0 AND age_range_max <= 120)),
    age_range_label     TEXT,
    -- v3.6 (2026-10-10): Extended-Youth-Promotion (atom #594, Pattern-Staerke 4:
    -- ubs, raiffeisen_schweiz, ce_courtelary, clientis_oberaargau). Zweite,
    -- konditionale Altersgrenze ("bis 26, Studierende bis 30"). NULL = keine
    -- Verlaengerung. extension_condition beschreibt die Bedingung verbatim-nah
    -- (z.B. 'Studierende mit Legi; Doktoranden in mind. zweijaehriger Ausbildung').
    age_range_max_extended INTEGER
        CHECK (age_range_max_extended IS NULL
               OR (age_range_max_extended >= 0 AND age_range_max_extended <= 120)),
    age_range_extension_condition TEXT,
    -- v3.3 (2026-08-12, PR #410): product-lifecycle status.
    status              TEXT NOT NULL DEFAULT 'active'
        CHECK (status IN ('active', 'legacy_bestand_only', 'retired')),
    -- v3.8 (2026-11-16, atom #622): funktionaler Produkttyp, geschlossene Liste.
    -- NULL = nicht klassifiziert (Validator INFO). Loader setzen den Wert direkt;
    -- db/product_type_backfill.sql fuellt nur NULL-Zeilen. Taxonomie und Regeln:
    -- db/product_type_taxonomy.md.
    product_type        TEXT
        CHECK (product_type IS NULL OR product_type IN (
            'current_account', 'fx_account', 'savings_account', 'investment_savings_account',
            'gift_savings_account', 'rent_deposit_account', 'rent_collection_account', 'capital_deposit_account',
            'call_money_account', 'term_deposit', 'medium_term_note', 'fiduciary_deposit',
            'metal_account', 'crypto_custody', 'pillar_3a_account', 'pillar_3a_securities',
            'vested_benefits_account', 'vested_benefits_securities', 'occupational_pension', 'debit_card',
            'credit_card_classic', 'credit_card_gold', 'credit_card_platinum', 'prepaid_card',
            'banking_package', 'ebanking_access', 'loyalty_program', 'execution_only',
            'advisory_mandate', 'discretionary_mandate', 'robo_advisory', 'fund_savings_plan',
            'private_banking', 'investment_fund', 'financial_planning', 'fixed_rate_mortgage',
            'saron_mortgage', 'variable_mortgage', 'construction_loan', 'lombard_loan',
            'consumer_loan', 'business_loan', 'leasing', 'bank_guarantee',
            'safe_deposit_box', 'cheque_service', 'capital_markets_service', 'b2b_banking_service'
        ))
);
CREATE INDEX idx_product_bank ON product(bank_id);
CREATE INDEX idx_product_category ON product(category);
CREATE INDEX idx_product_lookup ON product(bank_id, category, client_type, target_group);
CREATE UNIQUE INDEX idx_product_bpg ON product(bpg) WHERE bpg IS NOT NULL;
CREATE INDEX idx_product_access_tier ON product(access_tier);
CREATE INDEX idx_product_is_tailored ON product(is_tailored) WHERE is_tailored IS NOT NULL;
CREATE INDEX idx_product_iso_account_type ON product(iso_account_type) WHERE iso_account_type IS NOT NULL;
CREATE INDEX idx_product_notice_period ON product(notice_period_days) WHERE notice_period_days IS NOT NULL;
CREATE INDEX idx_product_age_range ON product(age_range_min, age_range_max) WHERE age_range_min IS NOT NULL OR age_range_max IS NOT NULL;
CREATE INDEX idx_product_status ON product(status) WHERE status != 'active';
Powered by Datasette · Queries took 44.598ms · Data license: CC-BY-4.0 · Data source: bankproducts.info