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 = "vskb" sorted by bank_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: category, currency, client_type, target_group, valid_from, 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
vskb:conto_premium Banque Cantonale du Valais vskb package BCVS Conto Pack Premium CHF private standard 3 comptes inclus, 2 Debit Mastercard, 1 carte de credit Or, online/mobile banking inclus     BPG003AEY34E free 0               active banking_package
vskb:conto_confort Banque Cantonale du Valais vskb package BCVS Conto Pack Confort CHF private standard 2 comptes inclus, 2 Debit Mastercard, 1 carte de credit Argent, online/mobile banking inclus     BPG003N7GN8P free 0               active banking_package
vskb:conto_standard Banque Cantonale du Valais vskb package BCVS Conto Pack Standard CHF private standard 2 comptes inclus, 2 Debit Mastercard, online/mobile banking inclus     BPG003DKCAM8 free 0               active banking_package
vskb:conto_bienvenue Banque Cantonale du Valais vskb package BCVS Conto Pack Bienvenue CHF private standard 1 compte inclus, 1 carte incluse, online/mobile banking inclus     BPG003T4WG75 free 0               active banking_package
vskb:conto_jeunes Banque Cantonale du Valais vskb package BCVS Conto Pack Jeunes CHF private youth 12-26 ans, 1 compte, 1 carte, 50% rabais carte credit argent, 1 carte Prepaid incluse     BPG003C1TSD6 free 0     0 25 Jugend     active banking_package
vskb:conto_formation Banque Cantonale du Valais vskb package BCVS Conto Pack Formation CHF private students Jusqu'a 30 ans, 1 compte, 1 carte, 50% rabais carte credit argent, 1 carte Prepaid incluse     BPG0039EW5V0 free 0     0 30 Formation     active banking_package
vskb:compte_prive Banque Cantonale du Valais vskb current_account Compte prive CHF private standard Compte de base pour salaire et trafic des paiements     BPG003TCE77K free 0               active current_account
vskb:compte_monnaie_etrangere Banque Cantonale du Valais vskb current_account Compte en monnaie etrangere multi private standard Compte prive en devises     BPG003T0Q847 free 0               active fx_account
vskb:compte_start Banque Cantonale du Valais vskb current_account Compte BCVS Start CHF private standard Compte gratuit sans frais de releve     BPG0035M8CFB free 0               active current_account
vskb:compte_courant Banque Cantonale du Valais vskb current_account Compte courant CHF private standard Bouclement trimestriel, frais par ecriture     BPG00346PZ2N free 0               active current_account
vskb:compte_club Banque Cantonale du Valais vskb current_account Compte Club CHF private standard Compte associatif     BPG003C99BGQ free 0               active current_account
vskb:compte_epargne Banque Cantonale du Valais vskb savings_account Compte epargne CHF private standard       BPG003EN1450 free 0               active savings_account
vskb:compte_epargne_cadeau Banque Cantonale du Valais vskb savings_account Compte epargne cadeau CHF private youth       BPG0034PMG32 free 0               active gift_savings_account
vskb:epargne_garantie_loyer Banque Cantonale du Valais vskb savings_account Compte epargne garantie loyer CHF private standard Ouverture CHF 20 (clients) / CHF 300 (autres)     BPG003EY0TSJ free 0               active rent_collection_account
vskb:consignation_loyer Banque Cantonale du Valais vskb deposit_account Compte de consignation loyer CHF private standard Ouverture CHF 70 (clients BCVS) / CHF 120 (autres)     BPG003FVHEM8 free 0               active rent_collection_account
vskb:consignation_societe Banque Cantonale du Valais vskb deposit_account Compte consignation societe en formation CHF business standard 1 pour mille sur montant consigne, min CHF 250, max CHF 2500     BPG0038PP7TJ free 0               active capital_deposit_account
vskb:epargne3 Banque Cantonale du Valais vskb pillar_3a Compte Epargne 3 CHF private standard       BPG003FKC2KH pro 0               active pillar_3a_account
vskb:libre_passage Banque Cantonale du Valais vskb vested_benefits Compte de libre passage CHF private standard       BPG003GN6QDE pro 0               active vested_benefits_account
vskb:conto_business_m Banque Cantonale du Valais vskb current_account BCVS Conto Business M CHF business standard 1 compte entreprise CHF, 30 ecritures/trimestre incluses puis CHF 0.40     BPG0033AAPCK free 0               active current_account
vskb:conto_business_l Banque Cantonale du Valais vskb current_account BCVS Conto Business L CHF business standard 1 compte entreprise CHF, ecritures illimitees     BPG003PG4SS1 free 0               active current_account
vskb:conto_business_xl Banque Cantonale du Valais vskb current_account BCVS Conto Business XL CHF business standard 3 comptes entreprise CHF, ecritures illimitees     BPG0033J7NYC free 0               active current_account
vskb:compte_monnaie_etrangere_pro Banque Cantonale du Valais vskb current_account Compte en monnaie etrangere (professionnel) multi business standard Bouclement CHF 10/annuel, des la 25e ecriture CHF 1.50     BPG0031ND8BX free 0               active fx_account
vskb:epargne_entreprise Banque Cantonale du Valais vskb savings_account Compte Epargne Entreprise CHF business standard Des la 25e ecriture CHF 1.50     BPG003YFD0K7 free 0               active savings_account
vskb:business_pack_premium Banque Cantonale du Valais vskb package BCVS Business Pack Premium CHF business standard 1 compte devise, 1 Debit Mastercard + 1 carte credit Or, 12 retraits, 12 ordres Fit + 4 ordres paiement     BPG0036FN23Z free 0               active banking_package
vskb:business_pack_confort Banque Cantonale du Valais vskb package BCVS Business Pack Confort CHF business standard 1 compte devise, 1 Debit Mastercard + 1 carte credit Argent, 12 retraits, 12 ordres Fit + 4 ordres paiement     BPG0035196T2 free 0               active banking_package
vskb:business_pack_standard Banque Cantonale du Valais vskb package BCVS Business Pack Standard CHF business standard 1 compte devise, 1 Debit Mastercard, 12 retraits, 12 ordres Fit     BPG003Q26FD0 free 0               active banking_package
vskb:safe Banque Cantonale du Valais vskb safe_deposit Safe CHF private standard CHF 90 a CHF 1000 par an selon taille, TVA non comprise     BPG0030NTQ2V free 0               active safe_deposit_box
vskb:gestion_star_select Banque Cantonale du Valais vskb wealth_management BCVs Star Select CHF private standard Gestion discretionnaire active orientee sur la selection des meilleurs produits. Avoir minimum recommande CHF 200k. Tarif forfaitaire couvrant administration + gestion + courtage + souscription/rachat fonds + releve fiscal suisse.     BPG003BQ4H3D pro 0               active discretionary_mandate
vskb:gestion_active_swiss_focus Banque Cantonale du Valais vskb wealth_management BCVs Active Portfolio Swiss Focus CHF private standard Gestion discretionnaire dynamique orientee sur la maitrise du risque. 4 strategies: Securite, Defensif, Balance, Offensif. Avoir minimum CHF 200k.     BPG003C4YHKM pro 0               active discretionary_mandate
vskb:gestion_smart Banque Cantonale du Valais vskb wealth_management BCVs Smart CHF private standard Gestion discretionnaire concentree, basee sur des produits passifs. 3 strategies: Modere, Equilibre, Dynamique. Avoir minimum recommande CHF 100k.     BPG003C2XZMN pro 0               active discretionary_mandate
vskb:conseil_advanced Banque Cantonale du Valais vskb wealth_management BCVs Advanced CHF private standard Mandat de conseil avec accompagnement regulier et professionnel. Commission de conseil 0.35% + commission administration depot. 50% de rabais sur courtage et fonds BCVS. Avoir minimum recommande CHF 200k.     BPG0038J4BMM pro 0               active discretionary_mandate
vskb:conseil_compact Banque Cantonale du Valais vskb wealth_management BCVs Compact CHF private standard Mandat de conseil simple pour la construction de portefeuille. Commission de conseil 0.15% + commission administration depot. 25% de rabais sur courtage. Pas de minimum.     BPG003Q12DPW pro 0               active discretionary_mandate
vskb:wertschriften_depot Banque Cantonale du Valais vskb securities_trading BCVs Depot-titres CHF private standard Depot-titres avec commission d'administration tiered (0.22%-0.28% selon volume) + frais de courtage par transaction. Tarification non cumulative. Rabais 20% pour fonds BCVS, gratuit pour actions/obligations de caisse BCVS.     BPG0038PD6E1 pro 0               active execution_only
vskb:etrade Banque Cantonale du Valais vskb self_directed_trading BCVs e-trade CHF private standard Transactions boursieres en self-service via application mobile e-trade. Courtage facture a 50% du tarif standard. Ordres par telephone restent au tarif standard.     BPG003K7DHCD pro 0               active execution_only
vskb:metallkonto Banque Cantonale du Valais vskb metal_account BCVs Compte metaux CHF private standard Compte metaux precieux. Commission d'administration annuelle: 0.30% (or, platine, palladium) ou 0.40% (argent). Minimum CHF 50.     BPG0035TDXRA pro 0               active metal_account
vskb:fiduciary_terme Banque Cantonale du Valais vskb fiduciary_deposit BCVs Depot fiduciaire ferme CHF private standard Depot fiduciaire a echeance ferme (minimum CHF 100k ou contre-valeur). Commission tiered 0.50%/0.375%/0.25%/0.125% selon volume.     BPG003W5XMGS pro 0               active fiduciary_deposit
vskb:fiduciary_callgeld Banque Cantonale du Valais vskb fiduciary_deposit BCVs Depot fiduciaire a 2 jours de preavis CHF private standard Depot fiduciaire callable a 2 jours de preavis. Selon conditions du marche et contreparties agreees.     BPG003B1AM4A pro 0               active fiduciary_deposit
vskb:debit_mastercard Banque Cantonale du Valais vskb debit_card WKB Debit Mastercard CHF private standard Debit Mastercard fuer taegliche Zahlungen und Bezuege weltweit. Kontaktloses Bezahlen bis CHF 80. 2026-07-01   BPG0030GXSMQ free 0               active debit_card
vskb:credit_argent Banque Cantonale du Valais vskb credit_card World Mastercard Silber / Visa Silber CHF private standard Kreditkarte mit Auswahl Visa oder Mastercard. Reise- und Einkaufsversicherungen inklusive. 2026-07-01   BPG003QD2QNE free 0               active credit_card_classic
vskb:credit_or Banque Cantonale du Valais vskb credit_card World Mastercard Gold / Visa Gold CHF private standard Premium-Kreditkarte Visa oder Mastercard. Erweiterte Reise- und Einkaufsversicherungen. 2026-07-01   BPG003KQ5T7V free 0               active credit_card_gold
vskb:credit_platinum Banque Cantonale du Valais vskb credit_card Visa Platinum CHF private premium Visa Platinum Karte mit umfassenden Reise- und Einkaufsversicherungen. Bonusprogramm surprize. 2026-07-01   BPG0034FQWG3 free 0               active credit_card_platinum
vskb:prepaid_mastercard Banque Cantonale du Valais vskb prepaid_card BCVs Prepaid Mastercard CHF private standard Prepaid Mastercard fuer Online-Zahlungen und Budget-Kontrolle. Programme bonus surprize. 2026-07-01   BPG003B2CW5A free 0               active prepaid_card
vskb:travel_karte Banque Cantonale du Valais vskb prepaid_card Swiss Bankers Travel Karte CHF private standard Prepaid-Karte fuer Reisen ohne Cotisation annuelle. In CHF, EUR oder USD erhaeltlich. 2026-07-01   BPG003S87TNF free 0               active prepaid_card
vskb:ebanking Banque Cantonale du Valais vskb ebanking BCVs Digital Banking (e-banking + Mobile + one App) CHF private standard Digital Banking Bundle: e-banking + Mobile Banking + one App + e-documents + e-trade. 2026-07-01   BPG003MNMMSD free 0               active ebanking_access
vskb:hypotheque Banque Cantonale du Valais vskb mortgage Hypotheque CHF private standard BCVS Hypotheque — Nouveaux Credits / Augmentations / Reprises: Progression tarifaire par tranche (100k / 300k / 500k / >500k). Modifications, remboursements et consolidations tarifes separement. 2026-01-01 Tarif des frais 595 BPG003JNS3J7 pro                 active fixed_rate_mortgage

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