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

45 rows where bank_id = "tgkb" 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

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
tgkb:privatkonto Thurgauer Kantonalbank tgkb current_account Privatkonto CHF private standard Kostenlose Kontofuehrung     BPG0039RA954 free 0               active current_account
tgkb:privatkonto_young Thurgauer Kantonalbank tgkb current_account Privatkonto Young CHF private youth 0.10% bis CHF 10000     BPG003SP6K82 free 0               active current_account
tgkb:vereinskonto Thurgauer Kantonalbank tgkb current_account Vereinskonto CHF private standard       BPG003FMKZ0E free 0               active current_account
tgkb:wertschriftenkonto Thurgauer Kantonalbank tgkb current_account Wertschriftenkonto CHF private standard       BPG003YDRMZV free 0               active current_account
tgkb:eurokonto Thurgauer Kantonalbank tgkb current_account Eurokonto EUR private standard       BPG003C50BHC free 0               active fx_account
tgkb:sparkonto Thurgauer Kantonalbank tgkb savings_account Sparkonto CHF private standard CHF 20000/Monat frei, darueber 35 Tage Kuendigungsfrist     BPG003F38X55 free 0               active savings_account
tgkb:sparkonto_young Thurgauer Kantonalbank tgkb savings_account Sparkonto Young CHF private youth 0.35% bis CHF 100000     BPG003ZAK6Q0 free 0               active savings_account
tgkb:anlagekonto_180 Thurgauer Kantonalbank tgkb savings_account Anlagekonto 180 CHF private standard 0.20% bis CHF 20 Mio., andere Kuendigungsbedingungen     BPG0030QVC5H free 0               active investment_savings_account
tgkb:geschenksparkonto Thurgauer Kantonalbank tgkb savings_account Geschenksparkonto CHF private youth Fuer Einlagen von Grosseltern/Goetti, 0.35% bis CHF 20000     BPG0030E8EXX free 0               active gift_savings_account
tgkb:carlo_konto Thurgauer Kantonalbank tgkb savings_account Carlo Konto CHF private children Kinderkonto, 0.35% bis CHF 20000     BPG0037QNGF6 free 0               active savings_account
tgkb:euro_sparkonto Thurgauer Kantonalbank tgkb savings_account Euro-Sparkonto EUR private standard       BPG0033J8SVR free 0               active fx_account
tgkb:sparkonto_mietkaution Thurgauer Kantonalbank tgkb savings_account Sparkonto Mietkaution CHF private standard       BPG003RWWCME free 0               active rent_deposit_account
tgkb:sparen3 Thurgauer Kantonalbank tgkb pillar_3a Sparen 3 CHF private standard       BPG003VVKR2F pro 0               active pillar_3a_account
tgkb:freizuegigkeit_swisscanto Thurgauer Kantonalbank tgkb vested_benefits Freizuegigkeitskonto Swisscanto CHF private standard       BPG003MAN8W2 pro 0               active vested_benefits_account
tgkb:freizuegigkeit_stiftungen Thurgauer Kantonalbank tgkb vested_benefits Freizuegigkeitskonto Stiftungen CHF private standard       BPG003Z31BBF pro 0               active vested_benefits_account
tgkb:wertpapiersparen3a Thurgauer Kantonalbank tgkb pillar_3a Wertpapiersparen 3a CHF private standard TER ca. 0.85-1.19% je Strategie, keine zusaetzlichen Depot-/Transaktionskosten     BPG003PACPGW pro 0               active pillar_3a_account
tgkb:debit_mastercard Thurgauer Kantonalbank tgkb debit_card TKB Debit Mastercard CHF private standard CHF 24/Jahr physisch, CHF 12/Jahr virtuell; Zusatzleistungen zubuchbar     BPG003W747ZS free 0               active debit_card
tgkb:kontokarte Thurgauer Kantonalbank tgkb debit_card TKB Kontokarte CHF private standard       BPG003N43B67 free 0               active debit_card
tgkb:credit_silber Thurgauer Kantonalbank tgkb credit_card TKB World Mastercard / Visa Silber CHF private standard CHF 60/Jahr; kostenlos mit TKB Young     BPG003CKNQK3 free 0               active credit_card_classic
tgkb:credit_gold Thurgauer Kantonalbank tgkb credit_card TKB World Mastercard / Visa Gold CHF private standard       BPG0035KQAK8 free 0               active credit_card_gold
tgkb:ebanking Thurgauer Kantonalbank tgkb ebanking TKB E-Banking / Mobile Banking CHF private standard       BPG003YFHK41 free 0               active ebanking_access
tgkb:hypothek Thurgauer Kantonalbank tgkb mortgage Hypothek CHF private standard       BPG0035QNC05 pro 0               active fixed_rate_mortgage
tgkb:securities_ch Thurgauer Kantonalbank tgkb securities_trading Boersenhandel Hauptmaerkte CHF private standard       BPG0039ST5ZE pro 0               active execution_only
tgkb:securities_intl Thurgauer Kantonalbank tgkb securities_trading Boersenhandel Nebenmaerkte multi private standard       BPG003GQQR45 pro 0               active execution_only
tgkb:anlageberatung Thurgauer Kantonalbank tgkb self_directed_trading TKB Anlageberatung CHF private standard Depot 0.40% p.a., Min CHF 350/Quartal, 50% Courtage-Rabatt     BPG00358WXS7 pro 0               active advisory_mandate
tgkb:anlageberatung_pb Thurgauer Kantonalbank tgkb self_directed_trading TKB Anlageberatung Private Banking CHF private standard Depot 0.50% p.a., Min CHF 187.50/Quartal, 50% Courtage-Rabatt     BPG0033B9P4S pro 0               active advisory_mandate
tgkb:anlageberatung_pb_plus Thurgauer Kantonalbank tgkb self_directed_trading TKB Anlageberatung Private Banking Plus CHF private standard Pauschal 1.10%, Min CHF 2750/Jahr, Courtagen inbegriffen     BPG003Q8B04G pro 0               active advisory_mandate
tgkb:depot Thurgauer Kantonalbank tgkb self_directed_trading TKB Depot CHF private standard Eigene Depotgebuehr 0.25% p.a., Min CHF 12.50/Quartal, 50% E-Banking Courtage-Rabatt     BPG003S5CEWS pro 0               active execution_only
tgkb:vv_premiummandat Thurgauer Kantonalbank tgkb wealth_management Vermoegensverwaltung Premiummandat CHF private standard Ab CHF 1.5 Mio., Pauschal 1.50% oder 1.00% + 15% Performance     BPG0039Y4AFR pro 0               active discretionary_mandate
tgkb:metallkonto Thurgauer Kantonalbank tgkb metal_account Edelmetallkonto CHF private standard Gold/Platin/Palladium 0.30%, Silber 0.60%, Min CHF 30     BPG003PBQ1SD pro 0               active metal_account
tgkb:krypto Thurgauer Kantonalbank tgkb securities_trading Kryptowaehrungen CHF private standard Transaktionsgebuehr 0.90%, Min CHF 200, execution-only     BPG003RN2T8P pro 0               active crypto_custody
tgkb:finanzplanung Thurgauer Kantonalbank tgkb financial_planning TKB Pensionszentrum CHF private standard Finanzplanung CHF 2500 Basis, Pensionsberatung CHF 450, Steuererklaerung ab CHF 300     BPG003MPYM2B pro 0               active financial_planning
tgkb:kassenobligation Thurgauer Kantonalbank tgkb term_deposit Kassenobligation CHF private standard       BPG003CGNAZR pro 0               active medium_term_note
tgkb:treuhand_anlage Thurgauer Kantonalbank tgkb fiduciary_deposit TKB Treuhandanlage CHF private standard Treuhand-Festgeldanlage. Tiered Kommission 0.500%/0.375%/0.250% nach Volumen.     BPG003T6QETM pro 0               active fiduciary_deposit
tgkb:kryptowaehrungen Thurgauer Kantonalbank tgkb digital_vault TKB Kryptowaehrungen CHF private standard Handel und Verwahrung von Kryptowaehrungen. 0.10% Zuschlag auf Depotgebuehr. Transaktionsgebuehr 0.90% (Minimum CHF 200).     BPG003A04R3E free 0               active crypto_custody
tgkb:geldmarktanlage Thurgauer Kantonalbank tgkb deposit_account TKB Geldmarktanlage CHF private standard Geldmarktanlage (Callgeld). Keine Kommission gemaess Anlagegeschaeft-Tarif.     BPG00354B9YR free 0               active call_money_account
tgkb:kontokorrent Thurgauer Kantonalbank tgkb current_account TKB Kontokorrent CHF business standard Geschäfts-Kontokorrent. Kontoführung kostenlos. Buchungsgebühr CHF 0.20/Buchung.     BPG003H5W1J2 free 0               active current_account
tgkb:kapital_einzahlung Thurgauer Kantonalbank tgkb current_account TKB Kapitaleinzahlungskonto CHF business standard Aktienkapital-Einzahlung. 1‰ einbezahltes Kapital min CHF 200 (max CHF 2000 falls Kapital nicht bei TKB bleibt).     BPG003R24QNV free 0               active capital_deposit_account
tgkb:vv_basis Thurgauer Kantonalbank tgkb wealth_management TKB Vermögensverwaltung Basis CHF private wealthy Kollektivanlagen-VV. Gesamtkosten-Quote 1.23-1.47% je Strategie (Konservativ-Aktien). Mindestanlagebetrag CHF/EUR 20,000.     BPG003C39T8T pro 0               active discretionary_mandate
tgkb:vv_privatmandat Thurgauer Kantonalbank tgkb wealth_management TKB Vermögensverwaltung Privatmandat CHF private high_net_worth Pauschal- oder Perf-abhängiges Mandat. 0.90-1.20% pauschal je Strategie. Min CHF/EUR 200k. +0.10% für Auslandkunden / Restriktionen.     BPG003QGFQ4B pro 0               active discretionary_mandate
tgkb:vv_premium Thurgauer Kantonalbank tgkb wealth_management TKB Vermögensverwaltung Premiummandat CHF private high_net_worth Premium-Mandat. 1.50% p.a. oder 1.00% + 15% performance. Min CHF/EUR 1,500,000.     BPG003RP5C3A pro 0               active discretionary_mandate
tgkb:vv_beistand_vormund Thurgauer Kantonalbank tgkb wealth_management TKB VV für Beistandschaften/Vormundschaften (VBVV 7.1) CHF private standard 1.00% p.a. pauschal. Min CHF 50,000. Spezial-Mandat per Art. 7.1 VBVV.     BPG003A732TW pro 0               active discretionary_mandate
tgkb:beratungsdepot_standard Thurgauer Kantonalbank tgkb securities_trading TKB Anlageberatung (Standard-Beratungsdepot) CHF private standard 0.40% p.a. Mindestpreis CHF 50/Quartal. Wertschriftentransaktionen: 50% Rabatt auf Courtage-Tarif.     BPG003VP61E7 pro 0               active advisory_mandate
tgkb:beratungsdepot_private Thurgauer Kantonalbank tgkb wealth_management TKB Anlageberatung Private Banking CHF private high_net_worth 0.50% p.a. Mindestpreis CHF 187.50/Quartal. Wertschriftentransaktionen: 50% Rabatt.     BPG0038Y4SN8 pro 0               active private_banking
tgkb:beratungsdepot_private_plus Thurgauer Kantonalbank tgkb wealth_management TKB Anlageberatung Private Banking Plus CHF private high_net_worth 1.10% p.a. pauschal. Mindestpreis CHF 2,750/Quartal. Wertschriftentransaktionen INBEGRIFFEN.     BPG0031EF3ER pro 0               active private_banking

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 35.715ms · Data license: CC-BY-4.0 · Data source: bankproducts.info