home / bankproducts

product_feature

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

2 rows where product_id = "ce_nyon:obligations_caisse"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ product_id feature_key feature_value note source_page
ce_nyon:obligations_caisse:pf:obligation_8_stufen_2_10_jahre_065_110_min_5k_novel_full_ladder Obligations de Caisse CEN ce_nyon:obligations_caisse pricing_condition CEN Obligations de Caisse 8-Stufen-Zinsladder (Laufzeit-basiert): **0.65% 2 Jahre; 0.75% 3 Jahre; 0.75% 4 Jahre; 0.85% 5 Jahre; 0.85% 6 Jahre; 0.95% 7 Jahre; 1.00% 8 Jahre; 1.10% 10 Jahre**. Minimum CHF 5'000. Novel: 8-stufige Zinstreppe publiziert. Cross-Bank-Muster: Kassenobligation-Zinstreppe. Cross-Bank-Vergleich: URKB Kassenobligation-Zinstreppe (bereits vor 2026), AEK Kassenobligation (Batch 36). CEN publiziert volle 8-Jahr-Ladder mit Interpolations-Sichtbarkeit. 1
ce_nyon:obligations_caisse:pf:own_brand_kassenobligation_ceduls_hypothek_kein_courtage_kein_depot Obligations de Caisse CEN ce_nyon:obligations_caisse pricing_condition CEN Own-Brand-Exception: **Aucun courtage ni droits de garde ne sont appliques pour la gestion des obligations de caisse CEN et/ou de vos cedules hypothecaires**. Novel: Volle Fee-Exemption fuer Own-Brand-Kassenobligation UND Kunden-Schuldbriefe. Cross-Bank-Muster: Own-Brand-Cost-Zero-Exemption. Cross-Bank-Vergleich: SZKB Vorsorge-Depot komplett-kostenlos (Batch 29), GEKB Actions BCGE gratis (Batch 22). CEN unique: auch Schuldbriefe des Kunden gratis verwahrt (Grundpfand-Deponierung). Signal: kleine Regional-Bank mit lokalem Grundbuch-Fokus (Nyon-Region). 1

Advanced export

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

CSV options:

CREATE TABLE product_feature (
    id          TEXT PRIMARY KEY,
    product_id  TEXT NOT NULL REFERENCES product(id),
    feature_key TEXT NOT NULL,          -- withdrawal_limit_free, notice_period, daily_limit, monthly_limit,
                                        -- interest_late_payment, max_balance, included_services, ...
    feature_value TEXT,
    note        TEXT,
    source_page INTEGER
);
CREATE INDEX idx_product_feature_product ON product_feature(product_id);
CREATE INDEX idx_product_feature_key ON product_feature(feature_key);
Powered by Datasette · Queries took 10.622ms · Data license: CC-BY-4.0 · Data source: bankproducts.info