# 8.50.8
INSERT INTO `financial_support` (`id_local`, `libelle`, `actif`, `type_support`, `src`, `type_pub`, `reservation_id`, `reportAffiliation`, `visible`, `type`, `type_flux`)
VALUES (00017, 'DEVISPROX JZCL', 'Y', 'Internet', 'devisprox-jzcl', 'emulation', NULL, 0, 0, NULL, NULL);

UPDATE financial_parametre SET valeur = '56,59,61,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,127'
WHERE variable = 'PASSERELLE' AND id_local = 17;


#8.36.3
INSERT INTO `financial_support` (`id_support`, `id_local`, `libelle`, `actif`, `type_support`, `src`, `type_pub`, `reservation_id`, `reportAffiliation`, `visible`) VALUES (NULL, 2, 'GOLEAD', 'Y', 'Internet', 'golead', 'creation', NULL, '0', '0');
UPDATE financial_parametre SET valeur = "56,59,61,62,63,64,65,67,78,77,76,75,74,73,72,71,70,69,79,80,81,82,83,85" WHERE variable = "PASSERELLE" AND id_local IN (2,17);


#8.30.0-rc2

INSERT INTO financial_banque (id_banque, libelle, actif, list_autorise_depot, adresse1, adresse2, cp, ville, pays, criteres_commissionnement, garanties, sous_libelle, payment_method_no_guarantees, payment_method_mortgage)
VALUES (13, 'Banque', 'Y', 'commercial_4-commercial_stagiaire-commercial_1-commercial_1_5-commercial_2-commercial_3-partenaire', '.', '', '.', '.', 'FRANCE', '', 'SGAR;HYPO', NULL, 'bank', 'notary');

INSERT INTO financial_banque (id_banque, libelle, actif, list_autorise_depot, adresse1, adresse2, cp, ville, pays, criteres_commissionnement, garanties, sous_libelle, payment_method_no_guarantees, payment_method_mortgage)
VALUES (15, 'LOCAFI', 'Y', 'commercial_stagiaire-commercial_1-commercial_1_5-commercial_2-commercial_3-commercial_4-partenaire', 'vide', NULL, 'vide', 'VIDE', 'FRANCE', NULL, 'SGAR;HYPO', NULL, 'bank', 'notary');

INSERT INTO financial_banque (id_banque, libelle, actif, list_autorise_depot, adresse1, adresse2, cp, ville, pays, criteres_commissionnement, garanties, sous_libelle, payment_method_no_guarantees, payment_method_mortgage)
VALUES (16, 'Credit 1', 'Y', '', '.', '', '.', '.', 'FRANCE', '', 'SGAR;HYPO', NULL, 'bank', 'notary');

INSERT INTO financial_banque (id_banque, libelle, actif, list_autorise_depot, adresse1, adresse2, cp, ville, pays, criteres_commissionnement, garanties, sous_libelle, payment_method_no_guarantees, payment_method_mortgage)
VALUES (42, 'CREDIT MUNICIPAL DE TOULON', 'Y', 'commercial_4-commercial_stagiaire-commercial_1-commercial_1_5-commercial_2-commercial_3-partenaire', 'Place Besagne', '', '83000', 'TOULON', 'FRANCE', '', 'SGAR;HYPO', NULL, 'bank', 'notary');

INSERT INTO financial_produit_typologie (id, id_banque, label, actif) VALUES
(40, 13, 'tous', 1),
(42, 42, 'Tous', 1),
(43, 16, 'tous', 1),
(46, 3, 'LOC SG choix C', 1),
(37, 3, 'PRO SG choix B', 1),
(38, 3, 'PRO SG choix C', 1),
(39, 3, 'PRO SG choix A', 1),
(44, 4, 'MINI RAC PR', 1),
(45, 4, 'MINI RAC LC', 1);


#preparation 8.21.0

TRUNCATE TABLE financial_banque_produit_type;

INSERT INTO `financial_banque_produit_type` (`id_banque_produit_type`, `libelle`, `actif`, `id_banque`)
VALUES
(001, 'PART IMMO > 60%', 'Y', 001),
(002, 'PART IMMO < 60%', 'Y', 001),
(014, 'CGI-SGAR-proprietaire-A', 'Y', 003),
(016, 'CGI-SGAR-proprietaire-B', 'Y', 003),
(017, 'CGI-SGAR-proprietaire-B', 'Y', 003),
(010, 'PART IMMO <60%', 'Y', 003),
(009, 'PART IMMO >60%', 'Y', 003),
(015, 'CGI-SGAR-proprietaire-A', 'Y', 003),
(018, 'CGI-SGAR-proprietaire-C', 'Y', 003),
(019, 'CGI-SGAR-proprietaire-C', 'Y', 003),
(013, 'PART IMMO < 60%', 'Y', 004),
(007, 'PART IMMO >60%', 'Y', 005),
(008, 'PART IMMO <60%', 'Y', 005),
(004, 'PART IMMO <60%', 'Y', 006),
(003, 'PART IMMO >60%', 'Y', 006),
(012, 'PART IMMO >60%', 'Y', 009),
(011, 'PART IMMO <60%', 'Y', 009),
(006, 'PART IMMO <60%', 'Y', 012),
(005, 'PART IMMO >60%', 'Y', 012),
(020, 'Sans garantie', 'Y', 040);


TRUNCATE TABLE financial_produit_banque;

INSERT INTO `financial_produit_banque` (`id_produit_banque`, `libelle`, `age_max_debut_pret`, `age_min_debut_pret_emprunteur`, `endettement_avant_max`, `endettement_apres_ac`, `reste_a_vivre1`, `reste_a_vivre2`, `reste_a_vivre3`, `reste_a_vivre4`, `reste_a_vivre_supp`, `montant_max_pro`, `montant_min`, `ratio_hypo`, `ficp`, `fcc`, `dossier_refinance`, `type_produit`, `actif`, `id_banque`, `id_remarque`, `age_max_fin_pret`, `revenu_mini`, `duree_max`, `charge`, `apl`, `taux_nominal`, `frais_dossier`, `honoraire_cf`, `pourcentage_apl`, `pourcentage_revenus_fonciers`, `frais_dossier_plafond`, `nombre_pp_min`, `pourcentage_immo_min`, `pourcentage_immo_max`, `endettement_avant_min`, `ordre`, `montant_max_loc`, `type_dossier`, `pourcentage_immo_conso_with_treso`, `montant_rachat_with_honoraire`, `revenu_without_pension_versee`, `nombre_pp_max`, `reste_a_vivre5`, `duree_min`, `id_banque_produit_type`, `age_min_debut_pret_coemprunteur`, `revenu_with_salaire_ev`, `montant_rachat_with_frais_dossier`, `id_produit_typologie`, `type_part_immo`)
VALUES
(00085, 'Premium5', 70, 0, 0, 40, 700, 1000, 1300, 1600, 300, 1000000, 30000, 90, 'N', 'N', 'N', 'hypothecaire', 'N', 008, NULL, 86, 0, 420, 'Y', 'N', 4.2, 1.5, 0, 0, 80, 15000000000000, 10, 60, 100, 0, 11, 1000000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1900, 120, NULL, 0, 'N', 'Y', NULL, NULL),
(00101, '>60% IMMO EV 60% MAX', 70, 0, 100, 33, 900, 900, 1100, 1300, 200, 1000000, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 008, NULL, 86, 0, 240, 'Y', 'N', 3, 1.5, 0, 0, 85, 150000000000000, 3, 60, 100, 0, 2, 1000000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1500, 120, NULL, 0, 'N', 'Y', NULL, NULL),
(00102, '<60% IMMO EV 100% MAX 10PP MAX', 70, 0, 100, 33, 900, 900, 1100, 1300, 200, 1000000, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 008, NULL, 86, 0, 240, 'Y', 'N', 3.95, 1.5, 0, 0, 85, 150000000000000, 10, 0, 60, 0, 3, 1000000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1500, 120, NULL, 0, 'N', 'Y', NULL, NULL),
(00103, 'PREMIUM 4 : EV>60 360M LS2', 70, 0, 100, 33, 900, 900, 1100, 1300, 200, 1000000, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 008, NULL, 86, 0, 240, 'Y', 'N', 4.8, 1.5, 0, 0, 80, 150000000000000, 10, 60, 100, 0, 10, 1000000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1500, 120, NULL, 0, 'N', 'Y', NULL, NULL),
(00254, 'Sans garantie Proprietaire Duree entre 12 et 15 ans', 0, 0, 100, 45, 780, 1000, 1250, 1500, 250, 150000, 22000, 0, 'N', 'N', 'N', 'consommation', 'Y', 012, NULL, 84.91, 0, 180, 'N', 'N', 3.95, 2.5, 0, 100, 80, 2000, 0, 0, 60, 0, 3, 150000, 'proprietaire', 'Y', 'Y', 'N', 15, 1750, 60, NULL, 0, 'N', 'Y', NULL, NULL),
(00253, 'Sans garantie Proprietaire Duree entre 5 et 12 ans', 0, 0, 100, 45, 780, 1000, 1250, 1500, 250, 150000, 22000, 0, 'N', 'N', 'N', 'consommation', 'Y', 012, NULL, 84.91, 0, 144, 'N', 'N', 2.8, 2.5, 0, 100, 80, 2000, 0, 0, 60, 0, 2, 150000, 'proprietaire', 'Y', 'Y', 'N', 15, 1750, 60, NULL, 0, 'N', 'Y', NULL, NULL),
(00252, 'Sans garantie Proprietaire Duree entre 5 et 10 ans', 0, 0, 100, 45, 1000, 1500, 1800, 2100, 300, 150000, 22000, 0, 'N', 'N', 'N', 'consommation', 'Y', 012, NULL, 84.91, 0, 120, 'N', 'N', 2.6, 2.5, 0, 100, 80, 2000, 0, 0, 60, 0, 1, 150000, 'proprietaire', 'Y', 'Y', 'N', 15, 2400, 60, NULL, 0, 'N', 'Y', NULL, NULL),
(00249, 'Montant -20 000e Propriétaire', 0, 18, 0, 50, 650, 900, 1100, 1250, 150, 20000, 1500, NULL, 'N', 'N', 'N', 'consommation', 'N', 009, NULL, 81, 1300, 84, 'Y', 'N', 3.75, 7, 0, 100, 75, 0, 0, 0, 60, 0, 4, 20000, 'proprietaire', 'Y', 'Y', 'N', 0, 1400, 60, NULL, 18, 'N', 'N', NULL, NULL),
(00248, 'Proprietaire duree entre 156 et 180 mois revenu >  3000 montant entre 80 et 250k€', 0, 18, 90, 45, 800, 800, 1200, 1600, 200, 250000, 80000, 0, 'N', 'N', 'N', 'consommation', 'Y', 004, NULL, 80, 3000, 180, 'N', 'Y', 4.59, 1.9, 0, 0, 100, 0, 0, 0, 100, 0, 5, 250000, 'proprietaire', 'Y', 'Y', 'Y', 0, 2000, 156, NULL, 18, 'N', 'Y', NULL, NULL),
(00247, 'Propriétaire durée entre 156 et 180 mois revenu > 4500 montant entre 80 et 250ke', 0, 18, 90, 45, 810, 810, 1215, 1620, 228, 250000, 80000, 100, 'N', 'N', 'N', 'consommation', 'N', 004, NULL, 80, 4500, 180, 'Y', 'Y', 5.74, 0, 0, 100, 100, 0, 0, 0, 100, 0, 5, 250000, 'proprietaire', 'Y', 'Y', 'Y', 0, 2025, 156, NULL, 18, 'N', 'Y', NULL, NULL),
(00217, 'GE PROPRIETAIRE SANS GARANTIE > 10 ANS', 0, 0, 70, 40, 900, 1100, 1350, 1600, 250, 100000, 10000, 0, 'N', 'N', 'N', 'consommation', 'Y', 001, NULL, 80, 0, 144, 'N', 'N', 4.22, 2, 8, 0, 80, 1990, 0, 0, 0, 0, 3, 100000, 'proprietaire', 'Y', 'Y', 'Y', 0, 1850, 120, NULL, 0, 'N', 'Y', NULL, NULL),
(00100, '<60% IMMO EV 60% MAX', 70, 0, 60, 33, 900, 900, 1100, 1300, 200, 1000000, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 008, NULL, 86, 0, 240, 'Y', 'N', 3.45, 1.5, 0, 0, 85, 150000000000000, 3, 0, 60, 0, 1, 1000000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1500, 120, NULL, 0, 'N', 'Y', NULL, NULL),
(00099, 'Locataire 144M TEAP40% ou RAC de RAC >1 an MAF>25000€', 0, 18, 0, 40, 935, 1125, 1375, 1625, 312, 100000, 25000, 0, 'N', 'N', 'N', 'consommation', 'Y', 005, NULL, 89.91, 0, 144, 'Y', 'N', 4.9, 2, 5.66, 100, 100, 1500, 0, 0, 0, 0, 1, 100000, 'locataire', 'Y', 'Y', 'N', 0, 1937, 60, NULL, 18, 'N', 'Y', NULL, NULL),
(00097, 'IMMOLEGIO :  LS2', 75, 0, 70, 45, 1000, 1300, 1500, 1700, 200, 800000, 10000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 006, NULL, 85, 1300, 300, 'Y', 'N', 5.35, 1.5, 0, 0, 80, 1500, 0, 0, 90, 0, 6, 800000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1900, 12, NULL, 0, 'N', 'Y', NULL, NULL),
(00086, 'Premium6', 70, 0, 0, 40, 700, 1000, 1300, 1600, 300, 1000000, 30000, 90, 'N', 'N', 'N', 'hypothecaire', 'N', 008, NULL, 86, 0, 420, 'Y', 'N', 5.85, 1.5, 0, 0, 80, 150000000000000, 10, 60, 100, 0, 12, 1000000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1900, 120, NULL, 0, 'N', 'Y', NULL, NULL),
(00087, '>60% IMMO EV 100% MAX 10PP', 70, 0, 100, 33, 1000, 1000, 1250, 1500, 250, 1000000, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 008, NULL, 86, 0, 240, 'Y', 'N', 3.4, 1.5, 0, 0, 85, 15000000000000, 10, 60, 100, 0, 6, 1000000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1750, 120, NULL, 0, 'N', 'Y', NULL, NULL),
(00088, 'OPTIMUM 4 : +10PP 360M LS2', 70, 0, 100, 33, 1000, 1250, 1500, 1750, 250, 1000000, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 008, NULL, 86, 0, 240, 'Y', 'N', 5.1, 1.5, 0, 0, 80, 1500000000000, 100, 60, 100, 0, 14, 1000000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 2000, 120, NULL, 0, 'N', 'Y', NULL, NULL),
(00268, 'Propriétaire depuis + 10 ans ', 0, 18, 100, 40, 700, 900, 1050, 1400, 350, 150000, 15000, 0, 'N', 'N', 'N', 'consommation', 'N', 003, NULL, 80, 1300, 144, 'N', 'N', 5.35, 0, 0, 100, 70, 0, 0, 0, 0, 0, 9, 150000, 'proprietaire', 'Y', 'Y', 'N', 0, 1750, 84, NULL, 18, 'N', 'Y', NULL, NULL),
(00262, 'MINILIFT locataire CRD Mini 5000€', 0, 0, 0, 30, 750, 900, 1100, 1300, 250, 25000, 5000, 0, 'N', 'N', 'N', 'consommation', 'Y', 005, NULL, 89.91, 0, 96, 'Y', 'N', 5, 2, 4.5, 100, 100, 1500, 0, 0, 0, 0, 7, 25000, 'locataire', 'Y', 'Y', 'N', 0, 1550, 60, NULL, 0, 'N', 'Y', NULL, NULL),
(00261, 'Propriétaire +2 ans Montant entre 100 000€ et 150 000€', 0, 18, 0, 45, 750, 900, 1100, 1300, 250, 150000, 100000, 0, 'N', 'N', 'N', 'consommation', 'Y', 005, NULL, 89.91, 0, 144, 'Y', 'N', 4.498, 2, 5.66, 100, 60, 1500, 0, 0, 0, 0, 1, 150000, 'proprietaire', 'Y', 'Y', 'N', 0, 1550, 60, NULL, 18, 'N', 'N', NULL, NULL),
(00257, 'EASY TRESO RAC DE RAC>1 AN DUREE 144 MOIS', 0, 18, 70, 40, 900, 1100, 1350, 1600, 250, 100000, 10000, 0, 'N', 'N', 'N', 'consommation', 'Y', 001, NULL, 80, 0, 144, 'N', 'N', 4.42, 2, 8, 0, 80, 1990, 0, 0, 0, 0, 3, 100000, 'proprietaire', 'Y', 'Y', 'Y', 0, 1850, 60, NULL, 18, 'N', 'Y', NULL, NULL),
(00093, 'Locataire', 0, 18, 90, 45, 1000, 1000, 1500, 2000, 250, 100000, 7500, 0, 'N', 'N', 'N', 'consommation', 'Y', 004, NULL, 75, 0, 144, 'N', 'Y', 4.68, 1.9, 5, 0, 100, 0, 0, 0, 60, 0, 2, 100000, 'locataire', 'Y', 'Y', 'Y', 0, 2500, 84, NULL, 18, 'N', 'Y', NULL, NULL),
(00256, 'Accedant >5 ans, si proprietaire acquittÃ© ok 180M-MAF>40000', 0, 18, 0, 45, 750, 900, 1100, 1300, 250, 100000, 40000, 0, 'N', 'N', 'N', 'consommation', 'Y', 005, NULL, 89.91, 0, 180, 'Y', 'N', 4.624, 2, 5.66, 100, 100, 1500, 0, 0, 0, 0, 5, 100000, 'proprietaire', 'Y', 'Y', 'N', 0, 1550, 145, NULL, 18, 'N', 'N', NULL, NULL),
(00255, 'SANS GARANTIE 180M accedant >10 ans, si proprétaire ok 180M-CRD>40000', 0, 18, 0, 45, 935, 1125, 1375, 1625, 312, 100000, 40000, 0, 'N', 'N', 'N', 'consommation', 'N', 005, NULL, 83, 0, 180, 'Y', 'N', 6.28, 2, 0, 100, 100, 1500, 0, 0, 0, 0, 5, 100000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1937, 144, NULL, 18, 'N', 'N', NULL, NULL),
(00129, 'mini rac', 0, 0, 50, 40, 750, 1000, 1200, 1600, 400, 25000, 15000, 100, 'N', 'N', 'N', 'consommation', 'Y', 003, NULL, 80, 3000, 120, 'N', 'N', 4.54, 6, 0, 100, 70, 0, 0, 0, 0, 0, 1, 25000, 'proprietaire', 'Y', 'Y', 'N', 0, 2000, 84, NULL, 0, 'N', 'Y', NULL, NULL),
(00216, 'GE PROPRIETAIRE SANS GARANTIE DUREE ENTRE 9 ET 10 ANS', 0, 0, 70, 40, 900, 1100, 1350, 1600, 250, 100000, 10000, 0, 'N', 'N', 'N', 'consommation', 'Y', 001, NULL, 80, 0, 120, 'N', 'N', 3.95, 2, 8, 0, 80, 1990, 0, 0, 0, 0, 2, 100000, 'proprietaire', 'Y', 'Y', 'Y', 0, 1850, 96, NULL, 0, 'N', 'Y', NULL, NULL),
(00146, 'Locataire TEAP 50% HORS IMPOTS', 0, 18, 70, 50, 850, 1000, 1200, 1350, 150, 80000, 1500, 0, 'N', 'N', 'N', 'consommation', 'N', 009, NULL, 81, 1300, 120, 'Y', 'N', 4.8, 7, 0, 100, 75, 0, 0, 0, 60, 0, 1, 80000, 'locataire', 'Y', 'Y', 'N', 0, 1500, 60, NULL, 18, 'N', 'N', NULL, NULL),
(00148, 'connu 300 Immo>45%', 0, 0, 0, 42, 910, 910, 1120, 1330, 210, 10000000000000, 30000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 82, NULL, 300, 'Y', 'N', 5, 0, 0, 0, 80, 1000, 0, 45, 100, 0, 2, 1000000000000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1540, 60, NULL, 0, 'N', 'Y', NULL, NULL),
(00202, 'MINILIFT proprietaire CRD MINI 5000€', 0, 0, 0, 40, 750, 900, 1100, 1300, 250, 25000, 5000, 0, 'N', 'N', 'N', 'consommation', 'Y', 005, NULL, 89.91, 0, 96, 'Y', 'N', 5, 2, 5.66, 100, 100, 1500, 0, 0, 0, 0, 6, 25000, 'proprietaire', 'Y', 'Y', 'N', 0, 1550, 60, NULL, 0, 'N', 'Y', NULL, NULL),
(00152, 'Inconnu LS2 240M', 0, 0, 0, 42, 910, 910, 1120, 1330, 210, 10000000000000, 30000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 82, NULL, 300, 'Y', 'N', 4.2, 0, 0, 0, 80, 1000, 0, 45, 100, 0, 6, 1000000000000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1540, 60, NULL, 0, 'N', 'Y', NULL, NULL),
(00199, 'Propriétaire  +2 ans TEAP 45% RAC de RAC MAF> 25000', 0, 0, 0, 45, 750, 900, 1100, 1300, 250, 100000, 25000, 0, 'N', 'N', 'N', 'consommation', 'Y', 005, NULL, 89.91, 0, 144, 'Y', 'N', 4.396, 2, 5.66, 100, 100, 1500, 0, 0, 100, 0, 4, 100000, 'proprietaire', 'Y', 'Y', 'N', 0, 1550, 60, NULL, 0, 'N', 'Y', NULL, NULL),
(00155, 'EV 70% revenu 2000 Locataire', 74.5, 25, 70, 50, 850, 1000, 1200, 1350, 150, 80000, 10000, 0, 'N', 'N', 'N', 'consommation', 'N', 006, NULL, 84.5, 2000, 144, 'Y', 'N', 8, 1.5, 5, 0, 75, 1500, 0, 0, 0, 0, 1, 80000, 'locataire', 'Y', 'Y', 'N', 0, 1500, 12, NULL, 21, 'N', 'Y', NULL, NULL),
(00172, 'Proprietaire TEAP 50% HORS IMPOTS', 0, 18, 0, 50, 650, 900, 1100, 1250, 150, 100000, 1500, 0, 'N', 'N', 'N', 'consommation', 'N', 009, NULL, 81, 1300, 120, 'Y', 'N', 4.65, 7, 0, 100, 75, 0, 0, 0, 60, 0, 5, 100000, 'proprietaire', 'Y', 'Y', 'N', 0, 1400, 60, NULL, 18, 'N', 'N', NULL, NULL),
(00171, 'BNP Conso Pro', 0, 18, 80, 45, 500, 600, 700, 800, 100, 80000, 1525, 0, 'N', 'N', 'N', 'consommation', 'N', 009, NULL, 82, 0, 120, 'Y', 'N', 7.9, 0, 0, 100, 75, 0, 0, 0, 60, 0, 0, 80000, 'proprietaire', 'Y', 'Y', 'N', 0, 900, 60, NULL, 18, 'N', 'N', NULL, NULL),
(00170, 'DOM TOM Propriétaire', 74.5, 25, 0, 40, 780, 1080, 1320, 1500, 180, 50000, 10000, 0, 'N', 'N', 'N', 'consommation', 'N', 006, NULL, 84, 1500, 96, 'Y', 'N', 4.75, 1.5, 1.9, 0, 75, 1500, 0, 0, 100, 0, 8, 50000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1680, 12, NULL, 21, 'N', 'Y', NULL, NULL),
(00169, 'DOM TOM Locataire', 74.5, 25, 0, 40, 1020, 1200, 1440, 1620, 180, 50000, 10000, 0, 'N', 'N', 'N', 'consommation', 'N', 006, NULL, 84, 1500, 96, 'Y', 'N', 4.75, 1.5, 1.9, 0, 75, 1500, 0, 0, 100, 0, 7, 50000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1800, 12, NULL, 21, 'N', 'Y', NULL, NULL),
(00143, 'Locataire 144M TEAP 45%  MAF> 25000e', 0, 18, 0, 45, 935, 1125, 1375, 1625, 312, 100000, 25000, 0, 'N', 'N', 'N', 'consommation', 'Y', 005, NULL, 89.91, 0, 144, 'Y', 'N', 4.9, 2, 5.66, 100, 100, 1500, 0, 0, 0, 0, 3, 100000, 'locataire', 'Y', 'Y', 'N', 0, 1937, 60, NULL, 18, 'N', 'Y', NULL, NULL),
(00142, 'PROPRIETAIRE 150 000€', 74.5, 25, 0, 50, 1000, 1300, 1500, 1700, 200, 150000, 80001, 85, 'N', 'N', 'N', 'consommation', 'N', 006, NULL, 84.5, 1300, 144, 'Y', 'N', 4.55, 1.5, 6, 0, 75, 1500, 0, 0, 0, 0, 5, 150000, 'proprietaire', 'Y', 'Y', 'N', 0, 1900, 12, NULL, 21, 'N', 'Y', NULL, NULL),
(00141, 'Locataire revenu 4000€ mini', 0, 18, 90, 45, 900, 900, 1350, 1800, 250, 100000, 7500, 0, 'N', 'N', 'N', 'consommation', 'N', 004, NULL, 75, 4000, 144, 'N', 'Y', 5.22, 2.4, 5, 0, 100, 0, 0, 0, 60, 0, 3, 100000, 'locataire', 'Y', 'Y', 'Y', 0, 2250, 84, NULL, 18, 'N', 'Y', NULL, NULL),
(00215, 'Propriétaire/Accédant 10 rejets Max TEAP 40%', 0, 0, 85, 40, 700, 900, 1050, 1400, 350, 150000, 15000, 0, 'N', 'N', 'N', 'consommation', 'Y', 003, NULL, 80, 1300, 144, 'N', 'N', 4.72, 6, 1.9, 100, 70, 0, 0, 0, 0, 0, 4, 150000, 'proprietaire', 'Y', 'Y', 'N', 0, 1750, 84, NULL, 0, 'N', 'Y', NULL, NULL),
(00132, 'Optimum+ propriétaire  0 rejet TEAP 45%', 0, 18, 85, 45, 900, 1500, 2100, 2700, 600, 150000, 15000, 0, 'N', 'N', 'N', 'consommation', 'Y', 003, NULL, 80, 1300, 144, 'N', 'N', 4.64, 6, 0, 100, 70, 0, 0, 0, 0, 0, 3, 150000, 'proprietaire', 'Y', 'Y', 'N', 0, 33000, 84, NULL, 18, 'N', 'Y', NULL, NULL),
(00133, 'Endettement entre 50% et 85% Propriétaire', 0, 18, 85, 40, 700, 900, 1050, 1400, 350, 150000, 15000, 0, 'N', 'N', 'N', 'consommation', 'N', 003, NULL, 80, 1300, 144, 'N', 'N', 5.35, 6, 0, 100, 70, 0, 0, 0, 0, 50, 6, 150000, 'proprietaire', 'Y', 'Y', 'N', 0, 1750, 84, NULL, 18, 'N', 'Y', NULL, NULL),
(00134, 'Endettement avant < 85% revenu 2000 Locataire', 0, 18, 85, 40, 1200, 1200, 1800, 2400, 600, 80000, 15000, 0, 'N', 'N', 'N', 'consommation', 'Y', 003, NULL, 80, 2000, 120, 'N', 'N', 4.54, 6, 0, 100, 70, 0, 0, 0, 0, 0, 7, 80000, 'locataire', 'Y', 'Y', 'N', 0, 3000, 84, NULL, 18, 'N', 'Y', NULL, NULL),
(00135, 'EV entre 70% et 85% revenu 1300 Propriétaire', 0, 18, 100, 40, 700, 900, 1050, 1400, 350, 150000, 15000, 0, 'N', 'N', 'N', 'consommation', 'N', 003, NULL, 80, 1300, 144, 'N', 'N', 5.35, 6, 0, 100, 70, 0, 0, 0, 0, 0, 8, 150000, 'proprietaire', 'Y', 'Y', 'N', 0, 1750, 84, NULL, 18, 'N', 'Y', NULL, NULL),
(00136, 'CGI P4 Pro', 0, 18, 85, 40, 750, 1000, 1200, 1600, 400, 100000, 15000, 0, 'N', 'N', 'N', 'consommation', 'N', 003, NULL, 80, 1500, 120, 'N', 'N', 9.59, 6, 0, 100, 70, 0, 0, 0, 0, 0, 1, 70000, 'proprietaire', 'Y', 'N', 'N', 0, 2000, 84, NULL, 18, 'N', 'N', NULL, NULL),
(00137, 'CGI P5 PRO 144 MOIS', 0, 18, 85, 40, 750, 1000, 1200, 1600, 400, 100000, 15000, 0, 'N', 'N', 'N', 'consommation', 'N', 003, NULL, 80, 1000, 144, 'N', 'N', 9.59, 6, 0, 100, 70, 0, 0, 0, 0, 0, 1, 70000, 'proprietaire', 'Y', 'N', 'N', 0, 2000, 84, NULL, 18, 'N', 'N', NULL, NULL),
(00138, 'EV 70% revenu 2000 Propriétaire', 74.5, 25, 70, 50, 650, 900, 1101, 1252, 150, 80000, 10000, 0, 'N', 'N', 'N', 'consommation', 'N', 006, NULL, 84.5, 2000, 144, 'Y', 'N', 7.5, 1.5, 5, 0, 75, 1500, 0, 0, 0, 0, 2, 80000, 'proprietaire', 'Y', 'Y', 'N', 0, 1402, 12, NULL, 21, 'N', 'Y', NULL, NULL),
(00139, 'LOCATAIRE : EV>55%, revenu <3500e, RAC de  RAC', 74.5, 25, 0, 50, 850, 1000, 1200, 1350, 150, 80000, 10000, 0, 'N', 'N', 'N', 'consommation', 'N', 006, NULL, 84.5, 1300, 144, 'Y', 'N', 4.75, 1.5, 5, 0, 75, 1500, 0, 0, 0, 0, 3, 80000, 'locataire', 'Y', 'Y', 'N', 0, 1500, 12, NULL, 21, 'N', 'Y', NULL, NULL),
(00140, 'PROPRIETAIRE : EV>55%, revenu <3500€, RAC de  RAC', 74.5, 25, 0, 50, 650, 900, 1101, 1252, 150, 80000, 10000, 0, 'N', 'N', 'N', 'consommation', 'N', 006, NULL, 84.5, 1300, 144, 'Y', 'N', 4.55, 1.5, 5, 0, 75, 1500, 0, 0, 0, 0, 4, 80000, 'proprietaire', 'Y', 'Y', 'N', 0, 1402, 12, NULL, 21, 'N', 'Y', NULL, NULL),
(00168, 'gamme privilège', 70, 0, 40, 33, 1200, 1200, 1440, 1680, 240, 1000000, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 008, NULL, 85, 0, 240, 'Y', 'N', 2.25, 1.5, 1.9, 0, 85, 0, 0, 80, 100, 0, 7, 1000000, 'locataireproprietaire', 'Y', 'Y', 'N', 3, 1920, 120, NULL, 0, 'N', 'Y', NULL, NULL),
(00314, 'Propriétaire - 2 ANS TEAP 45% MAF > 25000€', 0, NULL, 0, 45, 935, 1125, 1375, 1625, 312, 100000, 25000, 0, 'N', 'N', 'N', 'consommation', 'Y', 005, NULL, 89.91, 0, 144, 'Y', 'N', 4.396, 2, 5.66, 100, 100, 1500, 0, 0, 0, 0, 0, 100000, 'proprietaire', 'Y', 'Y', 'N', 0, 1937, 60, NULL, NULL, 'N', 'Y', NULL, NULL),
(00010, 'Ev 50 % rev 3000 LOCATAIRE', 0, 18, 50, 40, 750, 1000, 1200, 1600, 400, 80000, 15000, 0, 'N', 'N', 'N', 'consommation', 'N', 003, NULL, 80, 3000, 120, 'N', 'N', 8.9, 6, 0, 100, 70, 0, 0, 0, 0, 0, 1, 80000, 'locataire', 'Y', 'N', 'N', 0, 2000, 84, NULL, 18, 'N', 'N', NULL, NULL),
(00011, 'Sans garantie proprietaire', 0, 18, 90, 45, 800, 800, 1200, 1600, 200, 150000, 7500, 0, 'N', 'Y', 'N', 'consommation', 'Y', 004, NULL, 80, 0, 144, 'N', 'Y', 4.34, 1.9, 5, 0, 100, 0, 0, 0, 60, 0, 1, 150000, 'proprietaire', 'Y', 'Y', 'Y', 0, 2000, 84, NULL, 18, 'N', 'Y', NULL, NULL),
(00012, 'Propriétaire +2 ANS TEAP 45% Primo RACMAF> 25000', 0, 18, 0, 45, 750, 900, 1100, 1300, 250, 100000, 25000, 0, 'N', 'N', 'N', 'consommation', 'Y', 005, NULL, 89.91, 0, 144, 'Y', 'N', 4.396, 2, 5.66, 100, 100, 1500, 0, 0, 0, 0, 0, 100000, 'proprietaire', 'Y', 'Y', 'N', 0, 1550, 60, NULL, 18, 'N', 'Y', NULL, NULL),
(00014, 'Primo RAC EV < 55% revenu >= 3500', 74.5, 25, 55, 50, 650, 900, 1100, 1252, 150, 80000, 10000, 0, 'N', 'N', 'N', 'consommation', 'N', 006, NULL, 84.5, 3500, 144, 'Y', 'N', 4.35, 1.5, 5, 0, 75, 1500, 0, 0, 0, 0, 0, 80000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1402, 12, NULL, 21, 'N', 'Y', NULL, NULL),
(00024, 'GE PROPRIETAIRE SANS GARANTIE DUREE DE 5 A 8 ANS', 0, 18, 70, 40, 900, 1100, 1350, 1600, 250, 100000, 10000, 0, 'N', 'N', 'N', 'consommation', 'Y', 001, NULL, 80, 0, 96, 'N', 'N', 3.55, 2, 8, 0, 80, 1990, 0, 0, 0, 0, 1, 100000, 'proprietaire', 'Y', 'Y', 'Y', 0, 1850, 60, NULL, 18, 'N', 'Y', NULL, NULL),
(00026, 'COFIDIS P', 0, 0, 90, 65, 490, 590, 690, 790, 100, 60000, 3000, 0, 'N', 'N', 'N', 'consommation', 'Y', 014, NULL, 80, 0, 120, 'Y', 'N', 8.94, 1.5, 5, 100, 80, 0, 0, 0, 0, 0, 0, 60000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 890, 60, NULL, 0, 'N', 'Y', NULL, NULL),
(00332, 'Sans garantie propriétaire 180 M TEAP 40% 10 rejets', 0, 0, 85, 40, 700, 900, 1050, 1400, 350, 150000, 30000, 0, 'N', 'N', 'N', 'consommation', 'Y', 003, NULL, 80, 1300, 180, 'N', 'N', 4.82, 6, 1.9, 100, 70, 0, 0, 0, 0, 0, NULL, 150000, 'proprietaire', 'Y', 'Y', 'N', 0, 1750, 144, NULL, 0, 'N', 'Y', NULL, NULL),
(00164, 'Sans garantie Proprietaire revenu > 4500?', 0, 18, 90, 45, 800, 800, 1200, 1600, 200, 150000, 7500, 0, 'N', 'N', 'N', 'consommation', 'Y', 004, NULL, 80, 4500, 144, 'N', 'Y', 4.34, 1.9, 0, 0, 100, 0, 0, 0, 100, 0, 4, 150000, 'proprietaire', 'Y', 'Y', 'Y', 0, 2000, 84, NULL, 18, 'N', 'Y', NULL, NULL),
(00334, 'Sans garantie propriétaire 180 M TEAP 45% 0 rejet', 0, 18, 85, 45, 900, 1500, 2100, 2700, 600, 150000, 30000, 0, 'N', 'N', 'N', 'consommation', 'Y', 003, NULL, 80, 1300, 180, 'N', 'N', 4.36, 6, 0, 100, 70, 0, 0, 0, 0, 0, NULL, 150000, 'proprietaire', 'Y', 'Y', 'N', 0, 3300, 144, NULL, 18, 'N', 'Y', NULL, NULL),
(00333, 'Sans garantie propriétaire 180 M TEAP 45% 10 rejets', 0, 18, 85, 45, 900, 1500, 2100, 2700, 600, 150000, 30000, 0, 'N', 'N', 'N', 'consommation', 'N', 003, NULL, 80, 1300, 180, 'N', 'N', 4.82, 6, 0, 100, 70, 0, 0, 0, 0, 0, NULL, 150000, 'proprietaire', 'Y', 'Y', 'N', 0, 3300, 144, NULL, 18, 'N', 'Y', NULL, NULL),
(00331, 'Propriétaire/Accédant  10 rejets Max TEAP 45%', 0, 18, 85, 45, 900, 1500, 2100, 2700, 600, 150000, 15000, 0, 'N', 'N', 'N', 'consommation', 'N', 003, NULL, 80, 1300, 144, 'N', 'N', 4.72, 6, 0, 100, 70, 0, 0, 0, 0, 0, NULL, 150000, 'proprietaire', 'Y', 'Y', 'N', 0, 3300, 84, NULL, 18, 'N', 'Y', NULL, NULL),
(00330, 'Mini RAC Locataire', 0, 18, 90, 45, 1000, 1000, 1500, 2000, 250, 300000, 5000, 0, 'N', 'N', 'N', 'consommation', 'Y', 004, NULL, 75, 1500, 84, 'N', 'Y', 4.01, 1.9, 5, 0, 100, 0, 0, 0, 60, 0, 2, 300000, 'locataire', 'Y', 'Y', 'Y', 0, 2500, 36, NULL, 18, 'N', 'Y', NULL, NULL),
(00329, 'Mini RAC  proprietaire', 0, 18, 90, 45, 800, 800, 1200, 1600, 200, 30000, 5000, 0, 'N', 'N', 'N', 'consommation', 'Y', 004, NULL, 75, 0, 84, 'N', 'Y', 3.46, 1.9, 5, 0, 100, 0, 0, 0, 60, 0, 1, 30000, 'proprietaire', 'Y', 'Y', 'Y', 0, 2000, 36, NULL, 18, 'N', 'Y', NULL, NULL),
(00328, 'EASY TRESO RAC DE RAC MONTANT SUPERIEUR A 100 000€', 0, 18, 70, 40, 1800, 2200, 2450, 2700, 250, 150000, 10000, 1, 'N', 'N', 'N', 'consommation', 'Y', 001, NULL, 80, 0, 144, 'N', 'N', 4.22, 2, 8, 0, 80, 1990, 0, 0, 0, 0, NULL, 150000, 'proprietaire', 'Y', 'Y', 'Y', 0, 2950, 60, NULL, 18, 'N', 'Y', NULL, NULL),
(00327, 'EASY TRESO MONTANT SUPERIEUR A 100 000€', 0, 18, 70, 40, 1800, 2200, 2450, 2950, 250, 150000, 10000, 1, 'N', 'N', 'N', 'consommation', 'Y', 001, NULL, 80, 0, 144, 'N', 'N', 4.22, 2, 8, 0, 80, 1990, 0, 0, 0, 0, NULL, 150000, 'proprietaire', 'Y', 'Y', 'Y', 0, 1850, 60, NULL, 18, 'N', 'Y', NULL, NULL),
(00274, 'Locataire 96M TEAP 45%  ou RAC de RAC >1 an  MAF> 25000e', 0, 18, 0, 45, 935, 1125, 1375, 1625, 312, 100000, 25000, 0, 'N', 'N', 'N', 'consommation', 'Y', 005, NULL, 89.91, 0, 95, 'Y', 'N', 4.1, 2, 5.66, 100, 100, 1500, 0, 0, 0, 0, 3, 100000, 'locataire', 'Y', 'Y', 'N', 0, 1937, 60, NULL, 18, 'N', 'Y', NULL, NULL),
(00273, 'Locataire 120M TEAP 45% ou RAC de RAC >1 an  MAF>25000€', 0, 18, 0, 45, 935, 1125, 1375, 1625, 312, 100000, 25000, 0, 'N', 'N', 'N', 'consommation', 'Y', 005, NULL, 89.91, 0, 119, 'Y', 'N', 4.45, 2, 5.66, 100, 100, 1500, 0, 0, 0, 0, 1, 100000, 'locataire', 'Y', 'Y', 'N', 0, 1937, 96, NULL, 18, 'N', 'Y', NULL, NULL),
(00074, 'SUMMUM 2 : EV60%, 360M LCC', 70, 0, 60, 33, 900, 900, 1100, 1300, 200, 1000000, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 008, NULL, 86, 0, 240, 'Y', 'N', 5.5, 1.5, 0, 0, 80, 1000000000000, 3, 0, 60, 0, 2, 1000000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1500, 120, NULL, 0, 'N', 'Y', NULL, NULL),
(00075, 'SUMMUM 3 : EV60%, 420M LCC', 70, 0, 60, 33, 900, 900, 1100, 1300, 200, 1000000, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 008, NULL, 86, 0, 240, 'Y', 'N', 6.5, 1.5, 0, 0, 80, 1500000000000, 3, 0, 60, 0, 3, 1000000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1500, 120, NULL, 0, 'N', 'Y', NULL, NULL),
(00076, 'PREMIUM 2 : EV>60 360M LCC', 70, 0, 100, 33, 900, 900, 1100, 1300, 200, 1000000, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 008, NULL, 86, 0, 240, 'Y', 'N', 6, 1.5, 0, 0, 80, 15000000000, 10, 0, 60, 0, 8, 1000000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1500, 120, NULL, 0, 'N', 'Y', NULL, NULL),
(00077, '>60% IMMO EV 100% MAX 10PP MAX', 70, 0, 100, 33, 900, 900, 1100, 1300, 200, 1000000, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 008, NULL, 86, 0, 240, 'Y', 'N', 3.1, 1.5, 0, 0, 85, 15000000000, 10, 60, 100, 0, 4, 1000000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1500, 120, NULL, 0, 'N', 'Y', NULL, NULL),
(00078, '<60% IMMO EV 100% MAX 10PP', 70, 0, 100, 33, 1000, 1000, 1250, 1500, 250, 1000000, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 008, NULL, 86, 0, 240, 'Y', 'N', 5.75, 1.5, 0, 0, 85, 15000000000000, 10, 0, 60, 0, 5, 1000000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1750, 120, NULL, 0, 'N', 'Y', NULL, NULL),
(00079, 'OPTIMUM 2 : +10PP 360M LCC', 70, 0, 100, 33, 1000, 1250, 1500, 1750, 250, 1000000, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 008, NULL, 86, 0, 240, 'Y', 'N', 7.8, 1.5, 0, 0, 80, 15000000000000, 100, 0, 60, 0, 12, 1000000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 2000, 120, NULL, 0, 'N', 'Y', NULL, NULL),
(00081, 'EV 70% revenu  3000 Locataire', 0, 18, 70, 40, 750, 1000, 1200, 1600, 400, 80000, 15000, 0, 'N', 'N', 'N', 'consommation', 'N', 003, NULL, 80, 3000, 120, 'N', 'N', 8.33, 6, 0, 100, 70, 0, 0, 0, 0, 0, 1, 80000, 'locataire', 'Y', 'N', 'N', 0, 2000, 84, NULL, 18, 'N', 'N', NULL, NULL),
(00082, 'Endettement avant max 85% proprietaire', 0, 18, 85, 40, 700, 900, 1050, 1400, 350, 150000, 15000, 0, 'N', 'N', 'N', 'consommation', 'N', 003, NULL, 80, 1300, 144, 'N', 'N', 4.79, 6, 0, 100, 70, 0, 0, 0, 0, 0, 2, 150000, 'proprietaire', 'Y', 'Y', 'N', 0, 1750, 84, NULL, 18, 'N', 'Y', NULL, NULL),
(00083, 'Summum 5 : EV60% 360M LS2', 70, 0, 0, 33, 900, 900, 1100, 1300, 200, 1000000, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 008, NULL, 86, 0, 240, 'Y', 'N', 4.7, 1.5, 0, 0, 80, 150000000000, 3, 60, 100, 0, 5, 1000000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1500, 120, NULL, 0, 'N', 'Y', NULL, NULL),
(00084, 'Summum 6 : EV60% 420M LS2', 70, 0, 0, 33, 900, 900, 1100, 1300, 200, 1000000, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 008, NULL, 86, 0, 240, 'Y', 'N', 5.7, 1.5, 0, 0, 80, 150000000000, 3, 60, 100, 0, 6, 1000000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1500, 120, NULL, 0, 'N', 'Y', NULL, NULL),
(00269, 'LOGES FAMILLE', 0, 18, 70, 50, 850, 1000, 1200, 1350, 150, 15000, 1500, 0, 'N', 'N', 'N', 'consommation', 'N', 009, NULL, 81, 1300, 84, 'N', 'N', 3.87, 0, 0, 100, 75, 0, 0, 0, 60, 0, 2, 15000, 'locataire', 'Y', 'Y', 'N', 0, 1500, 60, NULL, 18, 'N', 'N', NULL, NULL),
(00272, 'Locataire 96M TEAP 45% ou RAC de RAC CRD> 25000e', 0, 18, 0, 45, 935, 1125, 1375, 1625, 312, 100000, 25000, 0, 'N', 'N', 'N', 'consommation', 'N', 005, NULL, 83, 0, 96, 'Y', 'N', 5.87, 1.5, 5, 100, 100, 0, 0, 0, 0, 0, 3, 100000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1937, 36, NULL, 18, 'N', 'Y', NULL, NULL),
(00271, 'Locataire 96M TEAP40% ou RAC de RAC CRD > 25000e', 0, 18, 0, 40, 750, 900, 1100, 1300, 250, 100000, 2500, 0, 'N', 'N', 'N', 'consommation', 'N', 005, NULL, 83, 0, 96, 'Y', 'N', 4.5, 1.5, 5.66, 100, 100, 0, 0, 0, 0, 0, 1, 100000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1550, 36, NULL, 18, 'N', 'Y', NULL, NULL),
(00270, 'Montant -20 000e Locataire', 0, 18, 70, 50, 850, 1000, 1200, 1350, 150, 20000, 1500, 0, 'N', 'N', 'N', 'consommation', 'N', 009, NULL, 81, 1300, 84, 'Y', 'N', 3.87, 0, 0, 100, 75, 0, 0, 0, 60, 0, 3, 20000, 'locataire', 'Y', 'Y', 'N', 0, 1500, 60, NULL, 18, 'N', 'N', NULL, NULL),
(00167, 'EVOLUTO PREMIUM EV 45% LS2 360M', 0, 0, 50, 40, 750, 900, 1150, 1400, 250, 540000, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 001, NULL, 75, 0, 360, 'Y', 'N', 3.35, 0, 0, 0, 80, 1490, 0, 60, 100, 0, 4, 540000, 'locataireproprietaire', 'Y', 'Y', 'Y', 0, 1650, 96, 001, 0, 'N', 'Y', NULL, NULL),
(00166, 'LS2 SIMPLY ONE S : EV<50% 300M', 0, 0, 50, 40, 800, 950, 1200, 1450, 250, NULL, 30000, 90, 'N', 'N', 'N', 'hypothecaire', 'Y', 001, NULL, 85.91, 0, 300, 'N', 'N', 2.45, 1.5, 8, 0, 80, 1490, 0, 60, 100, 0, 3, 540000, 'proprietaire', 'Y', 'Y', 'Y', 1, 1700, 120, 001, 0, 'N', 'Y', NULL, NULL),
(00034, 'LS2 SIMPLY ONE M : EV<80% 239M', 0, 0, 80, 40, 800, 950, 1200, 1450, 250, NULL, 30000, 90, 'N', 'N', 'N', 'hypothecaire', 'Y', 001, NULL, 85.91, 0, 239, 'N', 'N', 2.35, 1.5, 8, 0, 80, 1490, 1, 60, 100, 0, 10, 540000, 'proprietaire', 'Y', 'Y', 'Y', 0, 1700, 120, 001, 0, 'N', 'Y', NULL, NULL),
(00201, 'LS2 SIMPLY ONE L : EV<100% 300M', 0, 0, 100, 40, 800, 950, 1200, 1450, 250, NULL, 30000, 70, 'N', 'N', 'N', 'hypothecaire', 'Y', 001, NULL, 85.91, 0, 300, 'N', 'N', 2.6, 1.5, 8, 0, 80, 1490, 1, 60, 100, 0, 12, 540000, 'proprietaire', 'Y', 'Y', 'Y', 0, 1700, 120, 001, 0, 'N', 'Y', NULL, NULL),
(00038, 'E4 2 : EV 80-100 300 MOIS LS2', 0, 0, 100, 38, 850, 1000, 1250, 1500, 250, 400000, 35000, 70, 'N', 'Y', 'N', 'hypothecaire', 'N', 001, NULL, 85, 0, 300, 'N', 'N', 2.6, 1.5, 0, 0, 80, 1490, 0, 60, 100, 0, 18, 400000, 'proprietaire', 'Y', 'Y', 'Y', 0, 1750, 120, 001, 0, 'N', 'Y', NULL, NULL),
(00031, 'LS2 SIMPLY ONE S : EV<50% 239M', 0, 0, 50, 40, 800, 950, 1200, 1450, 250, NULL, 30000, 90, 'N', 'N', 'N', 'hypothecaire', 'Y', 001, NULL, 85.91, 0, 239, 'N', 'N', 2.3, 1.5, 8, 0, 80, 1490, 1, 0, 60, 0, 5, 540000, 'proprietaire', 'Y', 'Y', 'Y', 0, 1700, 120, 001, 0, 'N', 'Y', NULL, NULL),
(00145, 'E6 2 : FICP IMMO 240M LS2', 0, 0, 65, 35, 850, 1000, 1250, 1500, 250, 400000, 35000, 65, 'Y', 'Y', 'N', 'hypothecaire', 'N', 001, NULL, 75, NULL, 240, 'N', 'N', 2.6, 1.5, 0, 0, 80, 1490, 10, 60, 100, 0, 22, 400000, 'proprietaire', 'Y', 'Y', 'Y', 0, 1750, 144, 001, 0, 'N', 'Y', NULL, NULL),
(00033, 'LS2 SIMPLY ONE M : EV<80% 300M', 0, 0, 80, 40, 800, 950, 1200, 1450, 250, NULL, 30000, 90, 'N', 'N', 'N', 'hypothecaire', 'Y', 001, NULL, 85.91, 0, 300, 'N', 'N', 2.5, 1.5, 8, 0, 80, 1490, 1, 60, 100, 0, 9, 540000, 'proprietaire', 'Y', 'Y', 'Y', 0, 1700, 120, 001, 0, 'N', 'Y', NULL, NULL),
(00035, 'LS2 SIMPLY ONE L (FICP CONSO/FCC) : EV<100% 239M', 0, 0, 100, 40, 800, 950, 1200, 1450, 250, NULL, 30000, 70, 'N', 'N', 'N', 'hypothecaire', 'Y', 001, NULL, 85.91, 0, 239, 'N', 'N', 2.45, 1.5, 8, 0, 80, 1490, 1, 0, 60, 0, 13, 400000, 'proprietaire', 'Y', 'Y', 'Y', 0, 1700, 120, 001, 0, 'N', 'Y', NULL, NULL),
(00112, 'E3.5 EV 60- 80%, 240M en LS2', 0, 0, 80, 40, 850, 1000, 1250, 1500, 210, 1000000, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 001, NULL, 85, 0, 240, 'Y', 'N', 5.05, 1.5, 0, 0, 80, 1490, 0, 60, 100, 0, 23, 1000000, 'locataireproprietaire', 'Y', 'Y', 'Y', 0, 1710, 60, 001, 0, 'N', 'Y', NULL, NULL),
(00111, 'LS2 SIMPLY ONE 2X : RAC DE RAC HYPO EV<80% 239M', 0, 0, 80, 40, 800, 950, 1200, 1450, 250, NULL, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'Y', 001, NULL, 85.91, 0, 239, 'N', 'N', 2.4, 1.5, 8, 0, 80, 1490, 1, 60, 100, 0, 16, 540000, 'proprietaire', 'Y', 'Y', 'Y', 0, 1700, 120, 001, 0, 'N', 'Y', NULL, NULL),
(00113, 'E3.6 EV 60- 80%, 300M en LS2', 0, 0, 80, 40, 850, 1000, 1250, 1500, 210, 1000000, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 001, NULL, 85, 0, 300, 'Y', 'N', 5.1, 1.5, 0, 0, 80, 1490, 0, 60, 100, 0, 24, 1000000, 'locataireproprietaire', 'Y', 'Y', 'Y', 0, 1710, 60, 001, 0, 'N', 'Y', NULL, NULL),
(00114, 'E4 3 EV 80-100% 240M EN LS2', 0, 0, 100, 38, 850, 1000, 1250, 1500, 250, 400000, 35000, 70, 'N', 'N', 'N', 'hypothecaire', 'N', 001, NULL, 85, 0, 240, 'Y', 'N', 5.55, 1.5, 0, 0, 80, 1490, 20, 60, 100, 0, 27, 400000, 'locataireproprietaire', 'Y', 'Y', 'Y', 0, 1750, 60, 001, 0, 'N', 'Y', NULL, NULL),
(00115, 'E4 4 EV 80-100% 300M EN LS2', 0, 0, 100, 38, 850, 1000, 1250, 1500, 250, 400000, 35000, 70, 'N', 'N', 'N', 'hypothecaire', 'N', 001, NULL, 85, 0, 300, 'Y', 'N', 5.1, 1.5, 0, 0, 80, 1490, 6, 60, 100, 0, 28, 400000, 'locataireproprietaire', 'Y', 'Y', 'Y', 0, 1750, 60, 001, 0, 'N', 'Y', NULL, NULL),
(00109, 'E1 4 : EV 50% 360M  EN LS2', 0, 0, 50, 40, 750, 900, 1150, 1400, 250, 540000, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 001, NULL, 85, 0, 360, 'Y', 'N', 3.45, 0, 0, 0, 80, 1490, 6, 60, 100, 0, 8, 540000, 'locataireproprietaire', 'Y', 'Y', 'Y', 0, 1650, 96, 001, 0, 'N', 'Y', NULL, NULL),
(00107, 'EP 4 : EV 40% 360M EN LCC', 0, 0, 40, 40, 750, 900, 1150, 1400, 250, 1000000, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 001, NULL, 85, 0, 360, 'Y', 'N', 5, 1.5, 0, 0, 80, 1490, 4, 60, 100, 0, 10, 1000000, 'locataireproprietaire', 'Y', 'Y', 'Y', 0, 1650, 60, 001, 0, 'N', 'Y', NULL, NULL),
(00106, 'EP 3 : EV 40%  300M EN LS2', 0, 0, 40, 40, 750, 900, 1150, 1400, 250, 1000000, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 001, NULL, 85, 0, 300, 'Y', 'N', 3.85, 1.5, 0, 0, 80, 1490, 4, 60, 100, 0, 9, 1000000, 'locataireproprietaire', 'Y', 'Y', 'Y', 0, 1650, 60, 001, 0, 'N', 'Y', NULL, NULL),
(00105, 'EP+4 : EV 50% 360M EN LS2', 0, 0, 50, 40, 750, 900, 1150, 1400, 250, 1000000, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 001, NULL, 85, 2500, 360, 'Y', 'N', 4.85, 1.5, 0, 0, 80, 700, 6, 60, 100, 0, 6, 1000000, 'locataireproprietaire', 'Y', 'Y', 'Y', 0, 1650, 60, 001, 0, 'N', 'Y', NULL, NULL),
(00104, 'EP+3 : EV 50% 300M EN LS2', 0, 0, 50, 40, 750, 900, 1150, 1400, 250, 1000000, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 001, NULL, 85, 2500, 300, 'Y', 'N', 3.85, 1.5, 0, 0, 80, 700, 6, 60, 100, 0, 5, 1000000, 'locataireproprietaire', 'Y', 'Y', 'Y', 0, 1650, 60, 001, 0, 'N', 'Y', NULL, NULL),
(00116, 'E5 2 : Fiché, 240M LS2', 0, 0, 100, 35, 850, 1000, 1250, 1500, 250, 400000, 35000, 65, 'N', 'Y', 'N', 'hypothecaire', 'N', 001, NULL, 80, 0, 240, 'N', 'N', 2.6, 1.5, 0, 0, 80, 1490, 20, 60, 100, 40, 20, 400000, 'proprietaire', 'Y', 'Y', 'Y', 0, 1750, 144, 001, 0, 'N', 'Y', NULL, NULL),
(00110, 'LS2 SIMPLY ONE 2X : RAC DE RAC HYPO EV<80% 300M', 0, 0, 80, 40, 800, 950, 1200, 1450, 250, NULL, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'Y', 001, NULL, 85.91, 0, 300, 'N', 'N', 2.55, 1.5, 8, 0, 80, 1490, 1, 60, 100, 0, 15, 540000, 'proprietaire', 'Y', 'Y', 'Y', 0, 1700, 120, 001, 0, 'N', 'Y', NULL, NULL),
(00037, 'LCC SIMPLY ONE 2X RAC DE RAC HYPO : EV<80% 300M', 0, 0, 80, 40, 800, 950, 1200, 1450, 250, NULL, 35000, 70, 'N', 'Y', 'N', 'hypothecaire', 'Y', 001, NULL, 85.91, 0, 300, 'N', 'N', 3.65, 2, 8, 0, 80, 1990, 1, 0, 60, 0, 17, 400000, 'proprietaire', 'Y', 'Y', 'Y', 0, 1700, 120, 002, 0, 'N', 'Y', NULL, NULL),
(00030, 'EP 2 : EV 40% 360M EN LCC', 0, 0, 40, 40, 750, 900, 1150, 1400, 250, 1000000, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 001, NULL, 85, 0, 360, 'Y', 'N', 5.5, 1.5, 0, 0, 80, 1490, 4, 0, 60, 0, 8, 1000000, 'locataireproprietaire', 'Y', 'Y', 'Y', 0, 1650, 60, 002, 0, 'N', 'Y', NULL, NULL),
(00029, 'EP 1 : EV 40% 300M EN LCC', 0, 0, 40, 40, 750, 900, 1150, 1400, 250, 1000000, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 001, NULL, 85, 0, 300, 'Y', 'N', 4.35, 1.5, 0, 0, 80, 1490, 4, 0, 60, 0, 7, 1000000, 'locataireproprietaire', 'Y', 'Y', 'Y', 0, 1650, 60, 002, 0, 'N', 'Y', NULL, NULL),
(00027, 'EP+1 EV 50% 300M EN LCC', 0, 0, 50, 40, 750, 900, 1150, 1400, 250, 1000000, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 001, NULL, 85, 2500, 300, 'Y', 'N', 4.35, 0, 0, 0, 80, 700, 6, 0, 60, 0, 3, 1000000, 'locataireproprietaire', 'Y', 'Y', 'Y', 0, 1650, 60, 002, 0, 'N', 'Y', NULL, NULL),
(00200, 'LCC SIMPLY ONE M : EV<80% 300M', 0, 0, 80, 40, 800, 950, 1200, 1450, 250, NULL, 30000, 90, 'N', 'N', 'N', 'hypothecaire', 'Y', 001, NULL, 85.91, 0, 300, 'N', 'N', 3.55, 2, 8, 0, 80, 1990, 1, 0, 60, 0, 11, 540000, 'proprietaire', 'Y', 'Y', 'Y', 0, 1700, 120, 002, 0, 'N', 'Y', NULL, NULL),
(00098, 'E5 1 : Fiché, 240M EN LCC', 0, 0, 100, 35, 850, 1000, 1250, 1500, 250, 400000, 35000, 65, 'Y', 'Y', 'N', 'hypothecaire', 'N', 001, NULL, 80, 0, 240, 'N', 'N', 3.9, 1.5, 0, 0, 80, 1490, 20, 0, 60, 40, 19, 400000, 'proprietaire', 'Y', 'Y', 'Y', 0, 1750, 144, 002, 0, 'N', 'Y', NULL, NULL),
(00144, 'E6 1 : FICP IMMO 240M LCC', 0, 0, 65, 35, 850, 1000, 1250, 1500, 250, 400000, 35000, 65, 'Y', 'Y', 'N', 'hypothecaire', 'N', 001, NULL, 75, NULL, 240, 'N', 'N', 3.9, 1.5, 0, 0, 80, 1490, 10, 0, 60, 0, 21, 400000, 'proprietaire', 'Y', 'Y', 'Y', 0, 1750, 144, 002, 0, 'N', 'Y', NULL, NULL),
(00032, 'E1 2 : EV 50% 360M EN LCC', 0, 0, 50, 40, 750, 900, 1150, 1400, 250, 540000, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 001, NULL, 85, 0, 360, 'Y', 'N', 3.9, 0, 0, 0, 80, 1490, 6, 0, 60, 0, 6, 540000, 'locataireproprietaire', 'Y', 'Y', 'Y', 0, 1650, 96, 002, 0, 'N', 'Y', NULL, NULL),
(00235, 'EVOLUTO PREMIUM EV 45% LCC 300M', 0, 0, 50, 40, 750, 900, 1150, 1400, 250, 540000, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 001, NULL, 75, 0, 300, 'Y', 'N', 2.85, 0, 0, 0, 80, 1490, 0, 0, 60, 0, 1, 540000, 'locataireproprietaire', 'Y', 'Y', 'Y', 0, 1650, 96, 002, 0, 'N', 'Y', NULL, NULL),
(00036, 'LCC SIMPLY ONE L (FICP CONSO/FCC) : EV<100% 300M', 0, 0, 100, 40, 800, 950, 1200, 1450, 250, NULL, 30000, 70, 'N', 'N', 'N', 'hypothecaire', 'Y', 001, NULL, 85.91, 0, 300, 'N', 'N', 3.95, 2, 8, 0, 80, 1990, 1, 0, 60, 0, 14, 400000, 'proprietaire', 'Y', 'Y', 'Y', 0, 1700, 120, 002, 0, 'N', 'Y', NULL, NULL),
(00236, 'EVOLUTO PREMIUM EV 45% LCC 360M', 0, 0, 50, 40, 750, 900, 1150, 1400, 250, 540000, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 001, NULL, 75, 0, 360, 'Y', 'N', 3.35, 0, 0, 0, 80, 1490, 0, 0, 60, 0, 2, 540000, 'locataireproprietaire', 'Y', 'Y', 'Y', 0, 1650, 96, 002, 0, 'N', 'Y', NULL, NULL),
(00108, 'LCC SIMPLY ONE S : EV<50% 300M', 0, 0, 50, 40, 800, 950, 1200, 1450, 250, NULL, 30000, 90, 'N', 'N', 'N', 'hypothecaire', 'Y', 001, NULL, 85.91, 0, 300, 'N', 'N', 3.4, 2, 8, 0, 80, 1990, 1, 60, 100, 0, 7, 540000, 'proprietaire', 'Y', 'Y', 'Y', 0, 1700, 120, 002, 0, 'N', 'Y', NULL, NULL),
(00028, 'EP+ 2 EV 50% 360M EN LCC', 0, 0, 50, 40, 750, 900, 1150, 1400, 250, 1000000, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 001, NULL, 85, 2500, 360, 'Y', 'N', 5.35, 0, 0, 0, 80, 700, 6, 0, 60, 0, 4, 1000000, 'locataireproprietaire', 'Y', 'Y', 'Y', 0, 1650, 60, 002, 0, 'N', 'Y', NULL, NULL),
(00298, 'HYPO LS2 Durèe <180M', 74.5, NULL, 0, 45, 650, 900, 1100, 1250, 150, 800000, 110000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 006, NULL, 84.5, 1300, 179, 'Y', 'N', 2.2, 2, 0, 0, 80, 2000, 0, 60, 0, 0, 4, 800000, 'proprietaire', 'Y', 'Y', 'N', 0, 1400, 36, 003, NULL, 'N', 'Y', NULL, NULL),
(00275, 'Immolegio fixe Prime', 84.5, 21, 55, 38, 1000, 1300, 1500, 1700, 200, 800000, 100000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 006, NULL, 84.5, 3000, 300, 'Y', 'N', 2.3, 1.5, 0, 0, 80, 1500, 0, 60, 90, 0, 10, 800000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1900, 12, 003, 21, 'N', 'Y', NULL, NULL),
(00232, 'Immolegio fixe', 84.5, 21, 0, 50, 650, 900, 1100, 1250, 150, 800000, 100000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 006, NULL, 84.5, 1300, 300, 'Y', 'N', 2.6, 1.5, 0, 0, 80, 1500, 0, 60, 90, 0, 10, 800000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1400, 12, 003, 21, 'N', 'Y', NULL, NULL),
(00234, 'Immolegio révisable  standard : revenu >2000', 84.5, 21, 0, 50, 1000, 1300, 1500, 1700, 150, 800000, 130000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 006, NULL, 84.5, 1300, 300, 'Y', 'N', 3.5, 1.5, 0, 0, 80, 1500, 0, 60, 90, 0, 12, 800000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1900, 12, 003, 21, 'N', 'Y', NULL, NULL),
(00306, 'HYPO LS2 EV<50% 3 renouvelables max Durée<300M', 74.5, NULL, 50, 45, 650, 900, 1100, 1250, 150, 800000, 250000, 100, 'N', 'N', 'N', 'hypothecaire', 'Y', 006, NULL, 84.5, 1300, 300, 'Y', 'N', 2.65, 1.5, 0, 0, 80, 1500, 0, 60, 60, 0, 12, 800000, 'proprietaire', 'Y', 'Y', 'N', 3, 1400, 240, 003, NULL, 'N', 'Y', NULL, NULL),
(00233, 'Immolegio révisable  prime : revenu >3000 TEAP 38%', 74.5, 21, 55, 38, 1000, 1300, 1500, 1700, 200, 800000, 130000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 006, NULL, 84.5, 3000, 300, 'Y', 'N', 3.3, 1.5, 0, 0, 80, 1500, 0, 60, 90, 0, 11, 800000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1900, 12, 003, 21, 'N', 'Y', NULL, NULL),
(00305, 'HYPO LS2 EV<50% 3 renouvelables max Durée <240M', 74.5, NULL, 50, 45, 650, 900, 1100, 1250, 150, 800000, 250000, 100, 'N', 'N', 'N', 'hypothecaire', 'Y', 006, NULL, 84.5, 1300, 239, 'Y', 'N', 2.35, 1.5, 0, 0, 80, 1500, 0, 60, 60, 0, 11, 800000, 'proprietaire', 'Y', 'Y', 'N', 3, 1400, 180, 003, NULL, 'N', 'Y', NULL, NULL),
(00304, 'HYPO LS2 EV<50% 3 renouvelables max Durée <180M', 74.5, NULL, 50, 45, 650, 900, 1100, 1250, 150, 800000, 110000, 100, 'N', 'N', 'N', 'hypothecaire', 'N', 006, NULL, 84.5, 1300, 179, 'Y', 'N', 2.15, 1.5, 0, 0, 80, 1500, 0, 60, 60, 0, 10, 800000, 'proprietaire', 'Y', 'Y', 'N', 3, 1400, 36, 003, NULL, 'N', 'Y', NULL, NULL),
(00300, 'HYPO LS2 Durèe <300M', 74.5, NULL, 0, 45, 650, 900, 1100, 1250, 150, 800000, 250000, 85, 'N', 'N', 'N', 'hypothecaire', 'Y', 006, NULL, 84.5, 1300, 300, 'Y', 'N', 2.65, 2, 0, 0, 80, 2000, 0, 60, 0, 0, 6, 800000, 'proprietaire', 'Y', 'Y', 'N', 0, 1400, 240, 003, NULL, 'N', 'Y', NULL, NULL),
(00299, 'HYPO LS2 Durèe <240M', 74.5, NULL, 0, 45, 650, 900, 1100, 1250, 150, 800000, 250000, 85, 'N', 'N', 'N', 'hypothecaire', 'Y', 006, NULL, 84.5, 1300, 239, 'Y', 'N', 2.45, 2, 0, 0, 80, 2000, 0, 60, 0, 0, 5, 800000, 'proprietaire', 'Y', 'Y', 'N', 0, 1400, 228, 003, NULL, 'N', 'Y', NULL, NULL),
(00231, 'Immolegio fixe prime : revenu >3000 TEAP 38%', 74.5, 21, 55, 38, 1000, 1300, 1500, 1700, 200, 800000, 100000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 006, NULL, 84.5, 3000, 300, 'Y', 'N', 3.5, 1.5, 0, 0, 80, 1500, 0, 60, 90, 0, 9, 800000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1900, 12, 003, 21, 'N', 'Y', NULL, NULL),
(00210, 'IMMOFIXE', 74.5, 0, 0, 50, 650, 900, 1100, 1250, 150, 800000, 130000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 006, NULL, 84.5, 1300, 300, 'Y', 'N', 3.9, 1.5, 1.9, 0, 80, 1500, 0, 60, 90, 0, 8, 800000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1400, 12, 003, 0, 'N', 'Y', NULL, NULL),
(00160, 'IMMOFLEX', 74.5, 0, 0, 45, 950, 1150, 1350, 1500, 200, 800000, 130000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 006, NULL, 79.5, 2000, 300, 'Y', 'N', 3.7, 0, 0, 0, 100, 1500, 0, 60, 90, 0, 7, 800000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1800, 12, 003, 0, 'N', 'Y', NULL, NULL),
(00218, 'ALLEGIO FIXE RAC DE RAC AVEC RETARD OU INCIDENT DUREE > 216M', 74.5, 0, 0, 50, 650, 900, 1100, 1250, 150, 800000, 30000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 006, NULL, 84.5, 1300, 300, 'Y', 'N', 6.8, 1.5, 0, 0, 80, 1500, 0, 0, 60, 70, 6, 800000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1400, 12, 004, 0, 'N', 'Y', NULL, NULL),
(00073, 'ALLEGIO FIXE RAC DE RAC SANS RETARD DUREE < ou = 216M', 74.5, 0, 55, 50, 650, 900, 1100, 1250, 150, 800000, 30000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 006, NULL, 84.5, 1300, 216, 'Y', 'N', 5.6, 1.5, 0, 0, 80, 1500, 0, 0, 60, 0, 3, 800000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1400, 12, 004, 0, 'N', 'Y', NULL, NULL),
(00072, 'ALLEGIO FIXE PRIMO RAC DUREE > 216m', 74.5, 0, 45, 50, 650, 900, 1100, 1250, 150, 800000, 30000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 006, NULL, 84.5, 1300, 300, 'Y', 'N', 5.8, 1.5, 0, 0, 80, 1500, 0, 0, 60, 0, 2, 800000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1400, 12, 004, 0, 'N', 'Y', NULL, NULL),
(00276, 'Mini SG Propriétaire <15000e (hors frais) de 12 à 59 mois', 74.5, NULL, 0, 45, 650, 900, 1100, 1250, 150, 15000, 1500, NULL, 'N', 'N', 'N', 'consommation', 'Y', 006, NULL, 84.5, 1300, 59, 'Y', 'N', 3.8, 2, 8, 0, 80, 300, 1, 0, 60, 0, 0, 15000, 'proprietaire', 'Y', 'Y', 'N', 0, 1400, 12, 004, NULL, 'N', 'Y', NULL, NULL),
(00277, 'Mini SG Mini SG Propriétaire <15000e (hors frais) de 60 à 84 mois	', 74.5, NULL, 0, 45, 650, 900, 1100, 1250, 150, 15000, 10001, NULL, 'N', 'N', 'N', 'consommation', 'Y', 006, NULL, 84.5, 1300, 84, 'Y', 'N', 4.45, 2, 8, 0, 80, 300, 1, 0, 60, 0, 0, 15000, 'proprietaire', 'Y', 'Y', 'N', 0, 1400, 60, 004, NULL, 'N', 'Y', NULL, NULL),
(00278, 'Mini SG Mini SG Locataire <15000e (hors frais) de 60 à 84 mois', 74.5, NULL, 0, 45, 850, 1000, 1200, 1350, 150, 15000, 10001, NULL, 'N', 'N', 'N', 'consommation', 'Y', 006, NULL, 84.5, 1300, 84, 'Y', 'N', 4.6, 2, 8, 0, 80, 300, 1, 0, 60, 0, 0, 15000, 'locataire', 'Y', 'Y', 'N', 0, 1500, 60, 004, NULL, 'N', 'Y', NULL, NULL),
(00279, 'Mini SG Locataire <15000e (hors frais) de 12 à 59 mois', 74.5, NULL, 0, 45, 850, 1000, 1200, 1350, 150, 15000, 1500, NULL, 'N', 'N', 'N', 'consommation', 'Y', 006, NULL, 84.5, 1300, 59, 'Y', 'N', 3.85, 2, 8, 0, 80, 300, 1, 0, 60, 0, 0, 15000, 'locataire', 'Y', 'Y', 'N', 0, 1500, 12, 004, NULL, 'N', 'Y', NULL, NULL),
(00280, 'SG Propriétaire >15000e (hors frais) durée <60 mois	', 74.5, NULL, 0, 45, 650, 900, 1100, 1250, 150, 20000, 15000, 0, 'N', 'N', 'N', 'consommation', 'Y', 006, NULL, 84.5, 1300, 59, 'Y', 'N', 3.05, 1.5, 5, 0, 80, 1000, 0, 0, 0, 0, 0, 20000, 'proprietaire', 'Y', 'Y', 'N', 0, 1400, 12, 004, NULL, 'N', 'Y', NULL, NULL),
(00281, 'SG Propriétaire >15000e (hors frais) durée 84 mois', 74.5, NULL, 0, 45, 650, 900, 1100, 1250, 150, 19999, 15000, 0, 'N', 'N', 'N', 'consommation', 'Y', 006, NULL, 84.5, 1300, 84, 'Y', 'N', 3.65, 1.5, 5, 0, 80, 1000, 0, 0, 0, 0, 0, 19999, 'proprietaire', 'Y', 'Y', 'N', 0, 1400, 60, 004, NULL, 'N', 'Y', NULL, NULL),
(00282, 'SG Proprietaire >20000e Duree entre 109 et 120 mois', 74.5, NULL, 0, 45, 650, 900, 1100, 1250, 150, 39999, 20000, 0, 'N', 'N', 'N', 'consommation', 'Y', 006, NULL, 84.5, 1300, 120, 'Y', 'N', 3.89, 1.5, 5, 0, 80, 1000, 0, 0, 0, 0, 0, 39999, 'proprietaire', 'Y', 'Y', 'N', 0, 1400, 109, 004, NULL, 'N', 'Y', NULL, NULL),
(00095, 'ALLEGIO FIXE RAC DE RAC SANS RETARD DUREE > 216M', 74.5, 0, 70, 50, 650, 900, 1100, 1250, 150, 800000, 30000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 006, NULL, 84.5, 1300, 300, 'Y', 'N', 6.2, 1.5, 0, 0, 80, 1500, 0, 0, 60, 0, 4, 800000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1400, 12, 004, 0, 'N', 'Y', NULL, NULL),
(00096, 'ALLEGIO FIXE RAC DE RAC AVEC RETARD OU INCIDENT DUREE < ou = 216M', 74.5, 0, 0, 50, 650, 900, 1100, 1250, 150, 800000, 30000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 006, NULL, 84.5, 1300, 216, 'Y', 'N', 6.2, 1.5, 0, 0, 80, 1500, 0, 0, 60, 70, 5, 800000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1400, 12, 004, 0, 'N', 'Y', NULL, NULL),
(00071, 'ALLEGIO FIXE PRIMO RAC DUREE < ou = 216m', 74.5, 0, 45, 50, 650, 900, 1100, 1250, 150, 800000, 30000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 006, NULL, 84.5, 3000, 216, 'Y', 'N', 5.2, 1.5, 0, 0, 80, 1500, 0, 0, 60, 0, 1, 800000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1400, 12, 004, 0, 'N', 'Y', NULL, NULL),
(00219, 'ALLEGIO FIXE RAC DE RAC AVEC RETARD OU INCIDENT DUREE > 216M', 74.5, 0, 0, 50, 650, 900, 1100, 1250, 150, 800000, 30000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 006, NULL, 84.5, 1300, 300, 'Y', 'N', 6.8, 1.5, 0, 0, 80, 1500, 0, 0, 60, 70, 6, 800000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1400, 12, 004, 0, 'N', 'Y', NULL, NULL),
(00223, 'Allegio fixe primo Rac 216 mois', 74.5, 21, 0, 50, 650, 900, 1100, 1250, 150, 800000, 30000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 006, NULL, 84.5, 1300, 216, 'Y', 'N', 3.45, 1.5, 0, 0, 80, 1500, 0, 0, 60, 0, 1, 800000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1400, 12, 004, 21, 'N', 'Y', NULL, NULL),
(00224, 'Allegio fixe primo Rac300 mois', 74.5, 21, 0, 50, 650, 900, 1100, 1250, 150, 800000, 30000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 006, NULL, 84.5, 1300, 300, 'Y', 'N', 3.8, 1.5, 0, 0, 80, 1500, 0, 0, 60, 0, 2, 800000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1400, 12, 004, 21, 'N', 'Y', NULL, NULL),
(00225, 'Allegio fixe sans incidents 216 mois', 74.5, 21, 0, 50, 650, 900, 1100, 1250, 150, 800000, 30000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 006, NULL, 84.5, 1300, 216, 'Y', 'N', 3.75, 1.5, 0, 0, 80, 1500, 0, 0, 60, 0, 3, 800000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1400, 12, 004, 21, 'N', 'Y', NULL, NULL),
(00226, 'Allegio fixe sans incidents 300 mois', 74.5, 21, 0, 50, 650, 900, 1100, 1250, 150, 800000, 30000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 006, NULL, 84.5, 1300, 300, 'Y', 'N', 4.2, 1.5, 0, 0, 80, 1500, 0, 0, 60, 0, 4, 800000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1400, 12, 004, 21, 'N', 'Y', NULL, NULL),
(00227, 'Allegio fixe avec incidents 216', 74.5, 21, 0, 50, 650, 900, 1100, 1250, 150, 800000, 30000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 006, NULL, 84.5, 1300, 216, 'Y', 'N', 4.5, 1.5, 0, 0, 80, 1500, 0, 0, 60, 0, 5, 800000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1400, 12, 004, 21, 'N', 'Y', NULL, NULL),
(00228, 'Allegio fixe avec incidents 300 mois', 74.5, 21, 0, 50, 650, 900, 1100, 1250, 150, 800000, 30000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 006, NULL, 84.5, 1300, 300, 'Y', 'N', 5, 1.5, 0, 0, 80, 1500, 0, 0, 60, 0, 6, 800000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1400, 12, 004, 21, 'N', 'Y', NULL, NULL),
(00229, 'Allegio révisable prime : revenu >3000 TEAP 38%', 74.5, 21, 55, 38, 1000, 1300, 1500, 1700, 200, 800000, 30000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 006, NULL, 79.5, 3000, 300, 'Y', 'N', 4.35, 1.5, 0, 0, 80, 1500, 0, 0, 60, 0, 7, 800000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1900, 12, 004, 21, 'N', 'Y', NULL, NULL),
(00230, 'Allegio révisable standard : revenu >2000', 74.5, 21, 0, 45, 1000, 1300, 1500, 1700, 150, 800000, 30000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 006, NULL, 79.5, 2000, 300, 'Y', 'N', 4.95, 1.5, 0, 0, 80, 1500, 0, 0, 60, 0, 8, 800000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1900, 12, 004, 21, 'N', 'Y', NULL, NULL),
(00283, 'SG Propriètaire >40000e Durèe 144 mois', 74.5, NULL, 0, 45, 650, 900, 1100, 1250, 150, 150000, 40000, 0, 'N', 'N', 'N', 'consommation', 'Y', 006, NULL, 84.5, 1300, 144, 'Y', 'N', 3.89, 1.5, 5, 0, 80, 1000, 0, 0, 0, 0, 0, 150000, 'proprietaire', 'Y', 'Y', 'N', 0, 1400, 120, 004, NULL, 'N', 'Y', NULL, NULL),
(00284, 'SG Locataire >15000e (hors frais) durée <60 mois	', 74.5, NULL, 0, 45, 850, 1000, 1200, 1350, 150, 20000, 15000, 0, 'N', 'N', 'N', 'consommation', 'Y', 006, NULL, 84.5, 1300, 59, 'Y', 'N', 3.35, 1.5, 5, 0, 80, 1000, 0, 0, 0, 0, 0, 20000, 'locataire', 'Y', 'Y', 'N', 0, 1500, 12, 004, NULL, 'N', 'Y', NULL, NULL),
(00285, 'SG Locataire >15000e (hors frais) Durée 84 mois', 74.5, NULL, 0, 45, 850, 1000, 1200, 1350, 150, 20000, 15000, 0, 'N', 'N', 'N', 'consommation', 'Y', 006, NULL, 84.5, 1300, 84, 'Y', 'N', 4.05, 1.5, 5, 0, 80, 1000, 0, 0, 0, 0, 0, 20000, 'locataire', 'Y', 'Y', 'N', 0, 1500, 60, 004, NULL, 'N', 'Y', NULL, NULL),
(00296, 'HYPO LS1 Durèe <240M', 74.5, NULL, 0, 45, 650, 900, 1100, 1250, 150, 800000, 30000, 85, 'N', 'N', 'N', 'hypothecaire', 'Y', 006, NULL, 84.5, 1300, 239, 'Y', 'N', 3.6, 2, 0, 0, 80, 2000, 0, 0, 60, 0, 2, 800000, 'proprietaire', 'Y', 'Y', 'N', 0, 1400, 180, 004, NULL, 'N', 'Y', NULL, NULL),
(00297, 'HYPO LS1 Durèe <300M', 74.5, NULL, 0, 45, 650, 900, 1100, 1250, 150, 800000, 30000, 85, 'N', 'N', 'N', 'hypothecaire', 'Y', 006, NULL, 84.5, 1300, 300, 'Y', 'N', 3.6, 2, 0, 0, 80, 2000, 0, 0, 60, 0, 3, 800000, 'proprietaire', 'Y', 'Y', 'N', 0, 1400, 240, 004, NULL, 'N', 'Y', NULL, NULL),
(00301, 'HYPO LS1 EV<50% 3 renouvelables max Durèe <180M', 74.5, NULL, 50, 45, 650, 900, 1100, 1250, 150, 800000, 30000, 100, 'N', 'N', 'N', 'hypothecaire', 'Y', 006, NULL, 84.5, 1300, 179, 'Y', 'N', 3.3, 1.5, 0, 0, 80, 1500, 0, 0, 60, 0, 7, 800000, 'proprietaire', 'Y', 'Y', 'N', 3, 1400, 36, 004, NULL, 'N', 'Y', NULL, NULL),
(00302, 'HYPO LS1 EV<50% 3 renouvelables max Durèe <240M', 74.5, NULL, 50, 45, 650, 900, 1100, 1250, 150, 800000, 30000, 100, 'N', 'N', 'N', 'hypothecaire', 'Y', 006, NULL, 84.5, 1300, 239, 'Y', 'N', 3.4, 1.5, 0, 0, 80, 1500, 0, 0, 60, 0, 8, 800000, 'proprietaire', 'Y', 'Y', 'N', 3, 1400, 180, 004, NULL, 'N', 'Y', NULL, NULL),
(00303, 'HYPO LS1 EV<50% 3 renouvelables max Durée <300M', 74.5, NULL, 50, 45, 650, 900, 1100, 1250, 150, 800000, 30000, 100, 'N', 'N', 'N', 'hypothecaire', 'Y', 006, NULL, 84.5, 1300, 300, 'Y', 'N', 3.4, 1.5, 0, 0, 80, 1500, 0, 0, 60, 0, 9, 800000, 'proprietaire', 'Y', 'Y', 'N', 3, 1400, 240, 004, NULL, 'N', 'Y', NULL, NULL),
(00308, 'SG Proprietaire EV < 50% Primo RAC Duree <108 M', 74.5, 0, 50, 45, 650, 900, 1100, 1250, 150, 40000, 20000, 0, 'N', 'N', 'N', 'consommation', 'Y', 006, NULL, 84.5, 1300, 108, 'Y', 'N', 3.89, 1.5, 5, 0, 80, 1000, 3, 0, 0, 0, 0, 40000, 'proprietaire', 'Y', 'Y', 'N', 0, 1400, 85, 004, 0, 'N', 'Y', NULL, NULL),
(00309, 'SG Locataire >20000e Duree de 85 a 108 mois', 74.5, 0, 0, 45, 850, 1000, 1200, 1350, 150, 40000, 20000, 0, 'N', 'N', 'N', 'consommation', 'Y', 006, NULL, 84.5, 1300, 108, 'Y', 'N', 4.6, 1.5, 5, 0, 80, 1000, 0, 0, 0, 0, 0, 40000, 'locataire', 'Y', 'Y', 'N', 0, 1500, 85, 004, 0, 'N', 'Y', NULL, NULL),
(00165, 'ALLEGIOFLEX REVISABLE', 74.5, 0, 0, 35, 950, 1150, 1150, 1500, 200, 800000, 30000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 006, NULL, 79.5, 2000, 300, 'Y', 'N', 4.95, 1.5, 0, 0, 80, 1500, 0, 0, 60, 0, 9, 800000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1800, 12, 004, 0, 'N', 'Y', NULL, NULL),
(00310, 'SG Proprietaire >20000e Duree entre 85 et 108  mois', 74.5, 0, 0, 45, 650, 900, 1100, 1250, 150, 39999, 20000, 0, 'N', 'N', 'N', 'consommation', 'Y', 006, NULL, 84.5, 1300, 108, 'Y', 'N', 3.89, 1.5, 5, 0, 80, 1000, 0, 0, 0, 0, 0, 39999, 'proprietaire', 'Y', 'Y', 'N', 0, 1400, 85, 004, 0, 'N', 'Y', NULL, NULL),
(00295, 'HYPO LS1 Durèe <180M', 74.5, NULL, 0, 45, 650, 900, 1100, 1250, 150, 800000, 30000, 85, 'N', 'N', 'N', 'hypothecaire', 'Y', 006, NULL, 84.5, 1300, 179, 'Y', 'N', 3.5, 2, 0, 0, 80, 2000, 0, 0, 60, 0, 1, 800000, 'proprietaire', 'Y', 'Y', 'N', 0, 1400, 36, 004, NULL, 'N', 'Y', NULL, NULL),
(00294, 'Propriètaire 180M Trèso + CRD Immo rachetès >50% du MAF', 74.5, NULL, 50, 45, 650, 900, 1100, 1250, 150, 200000, 100000, 0, 'N', 'N', 'N', 'consommation', 'Y', 006, NULL, 84.5, 1300, 180, 'Y', 'N', 3.89, 1.5, 8, 0, 80, 1000, 0, 0, 0, 0, 0, 200000, 'proprietaire', 'N', 'Y', 'N', 3, 1400, 145, 004, NULL, 'N', 'Y', NULL, NULL),
(00286, 'SG Locataire >20000e Duree entre 109 et 120 mois', 74.5, NULL, 0, 45, 850, 1000, 1200, 1350, 150, 40000, 20000, 0, 'N', 'N', 'N', 'consommation', 'Y', 006, NULL, 84.5, 1300, 120, 'Y', 'N', 4.6, 1.5, 5, 0, 80, 1000, 0, 0, 0, 0, 0, 40000, 'locataire', 'Y', 'Y', 'N', 0, 1500, 109, 004, NULL, 'N', 'Y', NULL, NULL),
(00335, 'SG 180M 3 renouvelable Max, 0 rejet RAC DE RAC HN', 74.5, NULL, 65, 45, 850, 1000, 1200, 1350, 150, 20000, 100000, 1, 'N', 'N', 'N', 'consommation', 'Y', 006, NULL, 84.5, 1300, 180, 'Y', 'N', 4.2, 1.5, 8, 0, 80, 1000, 0, 0, 0, 0, 0, 20000, 'proprietaire', 'Y', 'Y', 'N', 0, 1500, 145, 004, NULL, 'N', 'Y', NULL, NULL),
(00287, 'SG Locataire >40000e Durèe 144 mois', 74.5, NULL, 0, 45, 850, 1000, 1200, 1350, 150, 80000, 40000, 0, 'N', 'N', 'N', 'consommation', 'Y', 006, NULL, 84.5, 1300, 144, 'Y', 'N', 4.6, 1.5, 5, 0, 80, 1000, 0, 0, 0, 0, 0, 80000, 'locataire', 'Y', 'Y', 'N', 0, 1500, 120, 004, NULL, 'N', 'Y', NULL, NULL),
(00288, 'SG Propriètaire EV < 50% Primo RAC Durèe <60M', 74.5, NULL, 50, 45, 650, 900, 1100, 1250, 150, 20000, 15000, 0, 'N', 'N', 'N', 'consommation', 'Y', 006, NULL, 84.5, 1300, 59, 'Y', 'N', 2.75, 1.5, 5, 0, 80, 1000, 3, 0, 0, 0, 0, 20000, 'proprietaire', 'Y', 'Y', 'N', 0, 1400, 12, 004, NULL, 'N', 'Y', NULL, NULL),
(00289, 'SG Propriètaire EV < 50% Primo RAC Durèe <84M', 74.5, NULL, 50, 45, 650, 900, 1100, 1250, 150, 20000, 15000, 0, 'N', 'N', 'N', 'consommation', 'Y', 006, NULL, 84.5, 1300, 84, 'Y', 'N', 3.5, 1.5, 5, 0, 80, 1000, 3, 0, 0, 0, 0, 20000, 'proprietaire', 'Y', 'Y', 'N', 0, 1400, 60, 004, NULL, 'N', 'Y', NULL, NULL),
(00290, 'SG Proprietaire EV < 50% Primo RAC Duree entre 109 et 120 M', 74.5, NULL, 50, 45, 650, 900, 1100, 1250, 150, 40000, 20000, 0, 'N', 'N', 'N', 'consommation', 'Y', 006, NULL, 84.5, 1300, 120, 'Y', 'N', 3.89, 1.5, 5, 0, 80, 1000, 3, 0, 0, 0, 0, 40000, 'proprietaire', 'Y', 'Y', 'N', 0, 1400, 109, 004, NULL, 'N', 'Y', NULL, NULL),
(00291, 'SG Propriètaire EV < 50% Primo RAC Durèe <144M', 74.5, NULL, 50, 45, 650, 900, 1100, 1250, 150, 150000, 40000, 0, 'N', 'N', 'N', 'consommation', 'Y', 006, NULL, 84.5, 1300, 144, 'Y', 'N', 3.89, 1.5, 8, 0, 80, 1000, 3, 0, 0, 0, 0, 150000, 'proprietaire', 'Y', 'Y', 'N', 0, 1400, 120, 004, NULL, 'N', 'Y', NULL, NULL),
(00292, 'SG Proprietaire : residents a la reunion', 74.5, NULL, 0, 40, 780, 1080, 1320, 1500, 180, 50000, 15000, 0, 'N', 'N', 'N', 'consommation', 'Y', 006, NULL, 84, 1500, 96, 'Y', 'N', 3.89, 1.5, 8, 0, 80, 1000, 0, 0, 100, 0, 0, 50000, 'proprietaire', 'Y', 'Y', 'N', 0, 1680, 12, 004, NULL, 'N', 'Y', NULL, NULL),
(00293, 'SG Locataire : residents a la reunion', 74.5, NULL, 0, 40, 1020, 1200, 1440, 1620, 180, 50000, 15000, 0, 'N', 'N', 'N', 'consommation', 'Y', 006, NULL, 84, 1500, 96, 'Y', 'N', 4.6, 1.5, 8, 0, 80, 1000, 0, 0, 100, 0, 0, 50000, 'proprietaire', 'Y', 'Y', 'N', 0, 1680, 12, 004, NULL, 'N', 'Y', NULL, NULL),
(00307, 'hypo Immo First RH 90% 300M TEAP 35%', 0, 0, 100, 35, 1250, 1900, 2300, 2700, 400, 1500000, 22000, 90, 'N', 'N', 'N', 'hypothecaire', 'Y', 012, NULL, 95, 0, 300, 'N', 'N', 2.05, 2.1, 1.9, 0, 80, 1900, 0, 60, 100, 0, 13, 1500000, 'locataireproprietaire', 'Y', 'Y', 'N', 15, 3100, 60, 005, 0, 'N', 'Y', NULL, NULL),
(00065, 'HYPO IMMO TEAP 35% RH 85% DUREE 300M', 0, 0, 100, 35, 780, 1000, 1250, 1500, 250, 1500000, 22000, 85, 'N', 'N', 'N', 'hypothecaire', 'Y', 012, NULL, 95, 0, 300, 'N', 'N', 2.1, 2.1, 1.9, 0, 80, 1900, 0, 60, 100, 0, 7, 1500000, 'proprietaire', 'Y', 'Y', 'N', 20, 1750, 60, 005, 0, 'N', 'Y', NULL, NULL),
(00206, 'HYPO IMMO TEAP 35% RH 80% DUREE 420M', 0, 0, 100, 35, 780, 1000, 1250, 1500, 250, 1500000, 22000, 80, 'N', 'N', 'N', 'hypothecaire', 'Y', 012, NULL, 95, 0, 420, 'N', 'N', 2.65, 2.1, 1.9, 0, 80, 1900, 0, 60, 100, 0, 8, 1500000, 'proprietaire', 'Y', 'Y', 'N', 20, 1750, 60, 005, 0, 'N', 'Y', NULL, NULL),
(00130, 'Classique 7', 0, 0, 0, 35, 1250, 1900, 2300, 2700, 250, 1500000, 22000, 90, 'N', 'N', 'N', 'hypothecaire', 'N', 012, NULL, 95, 0, 420, 'Y', 'N', 4.3, 1, 0, 0, 80, 0, 0, 60, 100, 0, 7, 1500000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 2950, 60, 005, 0, 'N', 'Y', NULL, NULL),
(00207, 'HYPO IMMO  TEAP 38% RH 80% DUREE 420M', 0, 0, 100, 38, 930, 1200, 1450, 1700, 250, 1500000, 22000, 80, 'N', 'N', 'N', 'hypothecaire', 'Y', 012, NULL, 95, 0, 420, 'N', 'N', 2.65, 2.1, 1.9, 0, 80, 1900, 0, 60, 100, 0, 10, 1500000, 'proprietaire', 'Y', 'Y', 'N', 20, 1950, 60, 005, 0, 'N', 'Y', NULL, NULL),
(00208, 'HYPO IMMO TEAP 40% RH 80% DUREE 420M', 0, 0, 100, 40, 1130, 1400, 1650, 1900, 250, 1500000, 22000, 80, 'N', 'N', 'N', 'hypothecaire', 'Y', 012, NULL, 95, 0, 420, 'N', 'N', 2.65, 2.1, 1.9, 0, 80, 1900, 0, 60, 100, 0, 12, 1500000, 'proprietaire', 'Y', 'Y', 'N', 20, 2150, 60, 005, 0, 'N', 'Y', NULL, NULL),
(00161, 'HYPO IMMO TEAP 38% RH 85%  DUREE 300M', 0, 0, 100, 38, 930, 1200, 1450, 1700, 250, 1500000, 22000, 85, 'N', 'N', 'N', 'hypothecaire', 'Y', 012, NULL, 95, 0, 300, 'N', 'N', 2.1, 2.1, 1.9, 0, 80, 1900, 0, 60, 100, 0, 9, 1500000, 'proprietaire', 'Y', 'Y', 'N', 20, 1950, 60, 005, 0, 'N', 'Y', NULL, NULL),
(00162, 'HYPO IMMO TEAP 40% RH 85% DUREE 300M', 0, 0, 100, 40, 1130, 1400, 1650, 1900, 250, 1500000, 22000, 85, 'N', 'N', 'N', 'hypothecaire', 'Y', 012, NULL, 95, 0, 300, 'N', 'N', 2.1, 2.1, 1.9, 0, 80, 1900, 0, 60, 100, 0, 11, 1500000, 'proprietaire', 'Y', 'Y', 'N', 20, 2150, 60, 005, 0, 'N', 'Y', NULL, NULL),
(00163, 'hypo Immo First RH 80% 420M TEAP 35%', 0, 0, 100, 35, 1250, 1900, 2300, 2700, 400, 1500000, 22000, 80, 'N', 'N', 'N', 'hypothecaire', 'Y', 012, NULL, 95, 0, 420, 'N', 'N', 2.45, 2.1, 1.9, 0, 80, 1900, 0, 60, 100, 0, 13, 1500000, 'proprietaire', 'Y', 'Y', 'N', 15, 3100, 60, 005, 0, 'N', 'Y', NULL, NULL),
(00090, 'HYPOCLASSIQUE TEAP 40% RH 85% DUREE 300M', 0, 0, 0, 40, 1130, 1400, 1650, 1900, 250, 1500000, 22000, 85, 'N', 'N', 'N', 'hypothecaire', 'Y', 012, NULL, 95, 0, 300, 'N', 'N', 3.1, 2.1, 0, 0, 80, 4000, 0, 0, 60, 0, 5, 1500000, 'proprietaire', 'Y', 'Y', 'N', 20, 2150, 60, 006, 0, 'N', 'Y', NULL, NULL),
(00089, 'HYPOCLASSIQUE TEAP 38% RH 85% DUREE 300M', 0, 0, 0, 38, 930, 1200, 1450, 1700, 250, 1500000, 22000, 85, 'N', 'N', 'N', 'hypothecaire', 'Y', 012, NULL, 95, 0, 300, 'N', 'N', 3.1, 2.1, 0, 0, 80, 4000, 0, 0, 60, 0, 3, 1500000, 'proprietaire', 'Y', 'Y', 'N', 20, 1950, 60, 006, 0, 'N', 'Y', NULL, NULL),
(00092, 'Classique 6', 0, 0, 100, 35, 780, 1000, 1250, 1500, 250, 1500000, 22000, 90, 'N', 'N', 'N', 'hypothecaire', 'N', 012, NULL, 95, 0, 420, 'Y', 'N', 5.9, 1, 0, 0, 80, 0, 0, 0, 60, 0, 6, 1500000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1750, 60, 006, 0, 'N', 'Y', NULL, NULL),
(00091, 'Classique 5', 0, 0, 100, 35, 780, 1000, 1250, 1500, 250, 1500000, 22000, 90, 'N', 'N', 'N', 'hypothecaire', 'N', 012, NULL, 95, 0, 420, 'Y', 'N', 5.9, 1, 0, 0, 80, 0, 0, 0, 60, 0, 5, 1500000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1750, 60, 006, 0, 'N', 'Y', NULL, NULL),
(00064, 'HYPOCLASSIQUE TEAP 35% RH 85% DUREE 300M', 0, 0, 0, 35, 780, 1000, 1250, 1500, 250, 1500000, 22000, 85, 'N', 'N', 'N', 'hypothecaire', 'Y', 012, NULL, 95, 0, 300, 'N', 'N', 3.1, 2.1, 0, 0, 80, 4000, 0, 0, 60, 0, 1, 1500000, 'proprietaire', 'Y', 'Y', 'N', 20, 1750, 60, 006, 0, 'N', 'Y', NULL, NULL),
(00203, 'HYPOCLASSIQUE TEAP 35% RH 80% DUREE 420M', 0, 0, 0, 35, 780, 1000, 1250, 1500, 250, 1500000, 22000, 80, 'N', 'N', 'N', 'hypothecaire', 'Y', 012, NULL, 95, 0, 420, 'N', 'N', 3.7, 2.1, 1.9, 0, 80, 4000, 0, 0, 60, 0, 2, 1500000, 'proprietaire', 'Y', 'Y', 'N', 20, 1750, 60, 006, 0, 'N', 'Y', NULL, NULL),
(00066, 'HYPOWASH : FICP DUREE 300M MAX RH 70%', 0, 0, 0, 35, 780, 1000, 1250, 1500, 250, 300000, 22000, 70, 'Y', 'N', 'N', 'hypothecaire', 'Y', 012, NULL, 95, 0, 300, 'N', 'N', 4.95, 2.1, 0, 0, 80, 4000, 0, 0, 60, 50, 14, 300000, 'locataireproprietaire', 'Y', 'Y', 'N', 20, 1750, 60, 006, 0, 'N', 'Y', NULL, NULL),
(00204, 'HYPOCLASSIQUE TEAP 38% RH 80% DUREE 420M', 0, 0, 0, 38, 930, 1200, 1450, 1700, 250, 1500000, 22000, 80, 'N', 'N', 'N', 'hypothecaire', 'Y', 012, NULL, 95, 0, 420, 'N', 'N', 3.7, 2.1, 1.9, 0, 80, 4000, 0, 0, 60, 0, 4, 1500000, 'proprietaire', 'Y', 'Y', 'N', 20, 1950, 60, 006, 0, 'N', 'Y', NULL, NULL),
(00205, 'HYPOCLASSIQUE TEAP 40% RH 80% DUREE 420M', 0, 0, 0, 40, 1130, 1400, 1650, 1900, 250, 1500000, 22000, 80, 'N', 'N', 'N', 'hypothecaire', 'Y', 012, NULL, 95, 0, 420, 'N', 'N', 3.7, 2.1, 1.9, 0, 80, 4000, 0, 0, 60, 0, 6, 1500000, 'proprietaire', 'Y', 'Y', 'N', 20, 2150, 60, 006, 0, 'N', 'Y', NULL, NULL),
(00209, 'HYPOWASH : FICP DUREE 420M  RH 65%', 0, 0, 0, 35, 780, 1000, 1250, 1500, 250, 300000, 22000, 65, 'Y', 'N', 'N', 'hypothecaire', 'Y', 012, NULL, 95, 0, 420, 'N', 'N', 4.95, 2.1, 1.9, 0, 80, 4000, 0, 0, 60, 50, 15, 300000, 'locataireproprietaire', 'Y', 'Y', 'N', 20, 1750, 60, 006, 0, 'N', 'Y', NULL, NULL),
(00313, 'hypo Classique First 420M TEAP 35%', 0, 0, 100, 35, 1250, 1900, 2300, 2700, 400, 1500000, 22000, 80, 'N', 'N', 'N', 'hypothecaire', 'Y', 012, NULL, 95, 0, 420, 'N', 'N', 2.9, 2.1, 1.9, 0, 80, 1900, 0, 60, 100, 0, 13, 1500000, 'proprietaire', 'Y', 'Y', 'N', 6, 3100, 60, 006, 0, 'N', 'Y', NULL, NULL),
(00312, 'hypo Classique First 300M TEAP 40%', 0, 0, 100, 40, 1250, 1900, 2300, 2700, 400, 1500000, 22000, 90, 'N', 'N', 'N', 'hypothecaire', 'Y', 012, NULL, 95, 0, 300, 'N', 'N', 2.3, 2.1, 1.9, 0, 80, 1900, 0, 60, 100, 0, 13, 1500000, 'proprietaire', 'Y', 'Y', 'N', 15, 3100, 60, 006, 0, 'N', 'Y', NULL, NULL),
(00175, 'HYPOLIFT immo 300M TEAP40%', 0, 0, 80, 40, 1500, 1800, 2200, 2600, 500, 500000, 80000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 005, NULL, 83, 0, 300, 'Y', 'N', 4.1, 1, 1.9, 0, 100, 0, 0, 60, 100, 0, 7, 500000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 3100, 144, 007, 0, 'N', 'Y', NULL, NULL),
(00211, 'HYPOLIFT IMMO 300M TEAP 45% CRD>120 000', 0, 0, 80, 45, 2250, 2700, 3300, 3900, 750, 199999, 120000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 005, NULL, 83, 0, 300, 'Y', 'N', 3.7, 1, 1.9, 0, 100, 0, 0, 60, 100, 0, 19, 199999, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 4650, 144, 007, 0, 'N', 'Y', NULL, NULL),
(00176, 'HYPOLIFT immo 300M TEAP45%', 0, 0, 80, 45, 2250, 2700, 3300, 3900, 750, 500000, 80000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 005, NULL, 83, 0, 300, 'Y', 'N', 4.1, 1, 1.9, 0, 100, 0, 0, 60, 100, 0, 8, 500000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 4650, 144, 007, 0, 'N', 'Y', NULL, NULL),
(00244, 'HYPOLIFT IMMO 240M TEAP40% CRD>120 000', 0, 0, 90, 40, 750, 900, 1100, 1300, 250, 199999, 120000, 75, 'N', 'N', 'N', 'hypothecaire', 'N', 005, NULL, 83, 0, 240, 'Y', 'N', 3.7, 1, 1.9, 0, 100, 0, 0, 60, 100, 0, 15, 120000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1550, 144, 007, 0, 'N', 'Y', NULL, NULL),
(00245, 'HYPOLIFTIMMO 240M TEAP40% MAF>120K RH85%', 0, 0, 80, 40, 1500, 1800, 2200, 2600, 500, 1000000, 120000, 85, 'N', 'N', 'N', 'hypothecaire', 'Y', 005, NULL, 89.91, 0, 239, 'Y', 'N', 2.1, 1.5, 8, 0, 100, 2950, 0, 60, 100, 0, 8, 299999, 'proprietaire', 'Y', 'Y', 'N', 0, 3100, 144, 007, 0, 'N', 'Y', NULL, NULL),
(00195, 'HYPOLIFTIMMO 240M TEAP40% MAF>120K RH75%', 0, 0, 90, 40, 750, 900, 1100, 1300, 250, 1000000, 120000, 75, 'N', 'N', 'N', 'hypothecaire', 'Y', 005, NULL, 89.91, 0, 239, 'Y', 'N', 2.1, 1.5, 8, 0, 100, 2950, 0, 60, 100, 0, 6, 400000, 'proprietaire', 'Y', 'Y', 'N', 0, 1550, 144, 007, 0, 'N', 'Y', NULL, NULL),
(00311, 'HYPOLIFT IMMO RH 95% MAF>150K 240M', 0, 0, 90, 40, 1500, 1800, 2200, 2600, 500, 1000000, 150000, 95, 'N', 'N', 'N', 'hypothecaire', 'Y', 005, NULL, 83, 0, 239, 'Y', 'N', 2.1, 1, 8, 0, 100, 0, 0, 60, 100, 0, 0, 0, 'proprietaire', 'Y', 'Y', 'N', 0, 3100, 144, 007, 0, 'N', 'Y', NULL, NULL),
(00174, 'HYPOLIFT immo 300M TEAP35%', 0, 0, 80, 35, 750, 900, 1100, 1300, 250, 500000, 80000, 75, 'N', 'N', 'N', 'hypothecaire', 'N', 005, NULL, 83, 0, 300, 'Y', 'N', 4.1, 1, 1.9, 0, 100, 0, 0, 60, 100, 0, 6, 500000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1550, 144, 007, 0, 'N', 'Y', NULL, NULL),
(00237, 'HYPOLIFT IMMO 300M TEAP 35% CRD >120 000', 0, 0, 80, 35, 750, 900, 1100, 1550, 250, 199999, 120000, 75, 'N', 'N', 'N', 'hypothecaire', 'N', 005, NULL, 83, 0, 300, 'Y', 'N', 3.7, 1, 1.9, 0, 100, 0, 0, 60, 100, 0, 21, 199999, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 4650, 144, 007, 0, 'N', 'Y', NULL, NULL),
(00173, 'HYPOLIFT immo 240M TEAP40%', 0, 0, 90, 40, 750, 900, 1100, 1300, 250, 500000, 80000, 75, 'N', 'N', 'N', 'hypothecaire', 'N', 005, NULL, 83, 0, 240, 'Y', 'N', 3.9, 1, 1.9, 0, 100, 0, 0, 60, 100, 0, 5, 500000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1550, 144, 007, 0, 'N', 'Y', NULL, NULL),
(00197, 'HYPOLIFT IMMO 300M TEAP40% CRD>120 000', 0, 0, 80, 40, 1500, 1800, 2200, 2600, 500, 199999, 120000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 005, NULL, 83, 0, 300, 'Y', 'N', 3.7, 1, 1.9, 0, 100, 0, 0, 60, 100, 0, 17, 199999, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 3100, 144, 007, 0, 'N', 'Y', NULL, NULL),
(00246, 'HYPOLIFTIMMO 240M TEAP45% MAF>120K RH85%', 0, 0, 80, 45, 2250, 2700, 3300, 3900, 750, 1000000, 120000, 85, 'N', 'N', 'N', 'hypothecaire', 'Y', 005, NULL, 89.91, 0, 239, 'Y', 'N', 2.1, 1.5, 8, 0, 100, 2950, 0, 60, 100, 0, 9, 299999, 'proprietaire', 'Y', 'Y', 'N', 0, 4650, 144, 007, 0, 'N', 'Y', NULL, NULL),
(00198, 'H I 300M TEAP 45% > 150K CRD', 0, 0, 80, 45, 2250, 2700, 3300, 3900, 750, 300000, 150000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 005, NULL, 83, 0, 300, 'Y', 'N', 4.5, 1, 1.9, 0, 100, 0, 0, 60, 100, 0, 18, 300000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 4650, 144, 007, 0, 'N', 'Y', NULL, NULL),
(00267, 'HYPOLIFT IMMO RH 95% MAF>180K 240M', 0, 0, 90, 40, 1500, 1800, 2200, 2600, 500, 400000, 180000, 95, 'N', 'N', 'N', 'hypothecaire', 'N', 005, NULL, 89.91, 0, 239, 'Y', 'N', 2.4, 1.5, 8, 0, 100, 2950, 0, 60, 100, 0, 0, 400000, 'proprietaire', 'Y', 'Y', 'N', 0, 3100, 144, 007, 0, 'N', 'Y', NULL, NULL),
(00196, 'HYPOLIFTIMMO 300M TEAP35% MAF>120K  RH85%', 0, 0, 80, 35, 1500, 1800, 2200, 2600, 500, 1000000, 120000, 85, 'N', 'N', 'N', 'hypothecaire', 'Y', 005, NULL, 89.91, 0, 300, 'Y', 'N', 2.3, 1.5, 8, 0, 100, 2950, 0, 60, 100, 0, 7, 400000, 'proprietaire', 'Y', 'Y', 'N', 0, 3100, 144, 007, 0, 'N', 'Y', NULL, NULL),
(00194, 'HYPOLIFT CONSO  300M TEAP 45%   CRD<120 000', 0, 0, 90, 40, 750, 900, 1100, 1300, 250, 199999, 150000, 75, 'N', 'N', 'N', 'hypothecaire', 'N', 005, NULL, 83, 0, 180, 'Y', 'N', 6.7, 1, 1.9, 0, 100, 0, 0, 60, 100, 0, 13, 199999, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1550, 144, 007, 0, 'N', 'Y', NULL, NULL),
(00192, 'HYPOLIFT CONSO 300M TEAP 45% REVENU>3000 CRD entre 80 et 150K', 0, 0, 80, 45, 2250, 2700, 3300, 3900, 750, 500000, 80000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 005, NULL, 83, 3000, 300, 'Y', 'N', 6.6, 1, 1.9, 0, 100, 0, 0, 0, 60, 0, 11, 500000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 4650, 60, 008, 0, 'N', 'Y', NULL, NULL),
(00185, 'HYPOLIFT CONSO CRD>45000€ 300M TEAP 35% RH 75%', 0, 0, 80, 35, 750, 900, 1100, 1300, 250, 1000000, 45000, 75, 'N', 'N', 'N', 'hypothecaire', 'Y', 005, NULL, 89.91, 0, 300, 'Y', 'N', 3.6, 1.5, 8, 0, 100, 2950, 0, 0, 60, 0, 2, 500000, 'proprietaire', 'Y', 'Y', 'N', 0, 1500, 60, 008, 0, 'N', 'Y', NULL, NULL),
(00266, 'HYPOLIFT CONSO RH 95% MAF>150K 240M', 0, 0, 90, 40, 1500, 1800, 2200, 2600, 500, 1000000, 150000, 95, 'N', 'N', 'N', 'hypothecaire', 'Y', 005, NULL, 89.91, 0, 240, 'Y', 'N', 3.5, 1.5, 8, 0, 100, 2950, 0, 0, 60, 0, 0, 500000, 'proprietaire', 'Y', 'Y', 'N', 0, 3100, 60, 008, 0, 'N', 'Y', NULL, NULL),
(00191, 'HYPOLIFT CONSO CRD>45000€ 300M TEAP 45% RH 85%', 0, 0, 80, 45, 2250, 2700, 3300, 3900, 750, 1000000, 45000, 85, 'N', 'N', 'N', 'hypothecaire', 'Y', 005, NULL, 89.91, 0, 300, 'Y', 'N', 3.6, 1.5, 8, 0, 100, 2950, 0, 0, 60, 0, 4, 500000, 'proprietaire', 'Y', 'Y', 'N', 0, 4650, 60, 008, 0, 'N', 'Y', NULL, NULL),
(00190, 'HYPOLIFT CONSO  300M TEAP 40%   CRD<120 000', 0, 0, 80, 40, 1550, 1800, 2200, 2600, 500, 119999, 45000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 005, NULL, 83, 0, 300, 'Y', 'N', 6.5, 1, 1.9, 0, 100, 0, 0, 0, 60, 0, 6, 119999, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 3100, 60, 008, 0, 'N', 'Y', NULL, NULL),
(00159, 'HYPOLIFT conso 300M TEAP45%', 0, 0, 80, 45, 2250, 2700, 3300, 3900, 750, 500000, 45000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 005, NULL, 83, NULL, 300, 'Y', 'N', 5.92, 0, 0, 0, 100, 0, 0, 0, 60, 0, 4, 500000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 4650, 60, 008, 0, 'N', 'Y', NULL, NULL),
(00158, 'HYPOLIFT conso 300M TEAP40%', 0, 0, 80, 40, 1500, 1800, 2200, 2600, 500, 500000, 45000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 005, NULL, 83, NULL, 300, 'Y', 'N', 5.92, 0, 0, 0, 100, 0, 0, 0, 60, 0, 3, 500000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 3100, 60, 008, 0, 'N', 'Y', NULL, NULL),
(00157, 'HYPOLIFT conso 300M TEAP35%', 0, 0, 80, 35, 750, 900, 1100, 1300, 250, 500000, 45000, 75, 'N', 'N', 'N', 'hypothecaire', 'N', 005, NULL, 83, NULL, 300, 'Y', 'N', 6.96, 0, 0, 0, 100, 0, 0, 0, 60, 0, 2, 500000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1550, 60, 008, 0, 'N', 'Y', NULL, NULL),
(00184, 'HYPOLIFT CONSO CRD>45000€ 240M TEAP 40% RH 80%', 0, 0, 90, 40, 750, 900, 1100, 1300, 250, 1000000, 45000, 80, 'N', 'N', 'N', 'hypothecaire', 'Y', 005, NULL, 89.91, 0, 240, 'Y', 'N', 3.5, 1.5, 8, 0, 100, 2950, 0, 0, 60, 0, 1, 500000, 'proprietaire', 'Y', 'Y', 'N', 0, 1550, 60, 008, 0, 'N', 'Y', NULL, NULL),
(00182, 'HYPOLIFT CONSO 240M TEAP 40%  CRD>120000', 0, 0, 90, 40, 750, 900, 1100, 1300, 250, 500000, 120000, 75, 'N', 'N', 'N', 'hypothecaire', 'N', 005, NULL, 83, 0, 240, 'Y', 'N', 5, 1, 1.9, 0, 100, 0, 0, 0, 60, 0, 1, 500000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1500, 60, 008, 0, 'N', 'Y', NULL, NULL),
(00183, 'HYPOLIFT CONSO 240M TEAP 40% REVENU>3000 CRD ENTRE 80Ket 150K€', 0, 0, 90, 40, 750, 900, 1100, 1300, 250, 500000, 80000, 75, 'N', 'N', 'N', 'hypothecaire', 'N', 005, NULL, 83, 3000, 240, 'Y', 'N', 6.4, 1, 1.9, 0, 100, 0, 0, 0, 60, 0, 2, 500000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1550, 60, 008, 0, 'N', 'Y', NULL, NULL),
(00186, 'HYPOLIFT CONSO 300M TE35% REVENU>3000 CRD entre 80K et 150K', 0, 0, 80, 35, 750, 900, 1100, 1300, 250, 500000, 80000, 75, 'N', 'N', 'N', 'hypothecaire', 'N', 005, NULL, 83, 3000, 300, 'Y', 'N', 6.6, 1, 1.9, 0, 100, 0, 0, 0, 60, 0, 5, 500000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1550, 60, 008, 0, 'N', 'Y', NULL, NULL),
(00156, 'HYPOLIFT conso 240M TEAP40%', 0, 0, 90, 40, 750, 900, 1100, 1300, 250, 500000, 45000, 75, 'N', 'N', 'N', 'hypothecaire', 'N', 005, NULL, 83, NULL, 240, 'Y', 'N', 6.96, 0, 0, 0, 100, 0, 0, 0, 60, 0, 1, 500000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1550, 60, 008, 0, 'N', 'Y', NULL, NULL),
(00187, 'HYPOLIFT CONSO 300M TE 35%  CRD<120 000', 0, 0, 80, 35, 750, 900, 1100, 1300, 250, 119999, 45000, 75, 'N', 'N', 'N', 'hypothecaire', 'N', 005, NULL, 83, 0, 300, 'Y', 'N', 6.5, 1, 1.9, 0, 100, 0, 0, 0, 60, 0, 4, 119999, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1500, 60, 008, 0, 'N', 'Y', NULL, NULL),
(00188, 'HYPOLIFT CONSO CRD>45000€ 300M TEAP 40% RH 80%', 0, 0, 80, 40, 1500, 1800, 2200, 2600, 500, 1000000, 45000, 80, 'N', 'N', 'N', 'hypothecaire', 'Y', 005, NULL, 89.91, 0, 300, 'Y', 'N', 3.6, 1.5, 8, 0, 100, 2950, 0, 0, 60, 0, 3, 500000, 'proprietaire', 'Y', 'Y', 'N', 0, 3100, 60, 008, 0, 'N', 'Y', NULL, NULL),
(00189, 'HYPOLIFT CONSO TEAP40% REVENU>3000 CRD entre 80K et 150K', 0, 0, 80, 40, 1500, 1800, 2200, 2600, 500, 500000, 80000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 005, NULL, 83, 3000, 300, 'Y', 'N', 6.6, 1, 1.9, 0, 100, 0, 0, 0, 60, 0, 8, 500000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 3100, 60, 008, 0, 'N', 'Y', NULL, NULL),
(00193, 'HYPOLIFT CONSO 300M TEAP 45% CRD<120 000', 0, 0, 80, 45, 2250, 2700, 3300, 3900, 750, 119999, 45000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 005, NULL, 83, 0, 300, 'Y', 'N', 6.5, 1, 1.9, 0, 100, 0, 0, 0, 60, 0, 8, 119999, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 4650, 60, 008, 0, 'N', 'Y', NULL, NULL),
(00214, 'HYPO LS2 ENDETTEMENT AVANT<50% TEAP45% REVENU>4500€', 0, 0, 50, 45, 700, 900, 1050, 1400, 350, 400000, 120000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 003, NULL, 84, 4500, 240, 'N', 'N', 2.39, 3, 1.9, 0, 70, 0, 0, 60, 100, 0, 8, 400000, 'proprietaire', 'Y', 'Y', 'N', 0, 1750, 180, 009, 0, 'N', 'Y', NULL, NULL),
(00069, 'RAC I : PART IMMO > 60%', 0, 0, 45, 40, 700, 900, 1150, 1500, 350, 0, 15000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 003, NULL, 84, 3000, 300, 'Y', 'N', 6.21, 3, 0, 0, 70, 0, 0, 60, 100, 0, 4, 0, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1850, 84, 009, 0, 'N', 'N', NULL, NULL),
(00213, 'HYPO LS2 EV <50% TEAP45% REVENU>3000€ 0 REJET', 0, 0, 50, 45, 900, 1500, 2100, 2700, 600, 400000, 120000, 80, 'N', 'N', 'N', 'hypothecaire', 'Y', 003, NULL, 84, 3000, 240, 'N', 'N', 2.39, 3, 1.9, 0, 70, 0, 0, 60, 100, 0, 7, 400000, 'proprietaire', 'Y', 'Y', 'N', 0, 3300, 180, 009, 0, 'N', 'Y', NULL, NULL),
(00212, 'HYPO LS2 EV <50% TEAP40% REVENU>3000€ 0 REJET', 0, 0, 50, 40, 900, 1500, 2100, 2700, 600, 400000, 120000, 80, 'N', 'N', 'N', 'hypothecaire', 'Y', 003, NULL, 84, 3000, 240, 'N', 'N', 2.39, 3, 1.9, 0, 70, 0, 0, 60, 100, 0, 6, 400000, 'proprietaire', 'Y', 'Y', 'N', 0, 3300, 180, 009, 0, 'N', 'Y', NULL, NULL),
(00181, 'HYPO LCC Serenium 20 rejets Max TEAP 45', 0, 0, 80, 45, 900, 2100, 2700, 1400, 600, 400000, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 003, NULL, 84, 1300, 240, 'N', 'N', 4.52, 1, 0, 0, 70, 0, 0, 0, 60, 0, 5, 400000, 'proprietaire', 'Y', 'Y', 'N', 0, 3300, 120, 010, 0, 'N', 'Y', NULL, NULL),
(00180, 'HYPO LCC ENDETTEMENT AVANT <70% TEAP 40% revenu >2000', 0, 0, 70, 40, 700, 900, 1050, 1400, 350, 400000, 50000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 003, NULL, 84, 2000, 240, 'Y', 'N', 6.15, 1, 0, 0, 70, 0, 0, 0, 60, 0, 4, 400000, 'locataireproprietaire', 'Y', 'N', 'N', 0, 1750, 120, 010, 0, 'N', 'N', NULL, NULL),
(00179, 'HYPO LCC ENDETTEMENT AVANT <50% TEAP 45% revenu >4500', 0, 0, 50, 45, 700, 900, 1050, 1400, 350, 400000, 30000, 100, 'N', 'N', 'N', 'hypothecaire', 'N', 003, NULL, 84, 4500, 300, 'N', 'N', 4.57, 1, 0, 0, 70, 0, 0, 0, 60, 0, 3, 400000, 'proprietaire', 'Y', 'Y', 'N', 0, 1750, 120, 010, 0, 'N', 'Y', NULL, NULL),
(00178, 'HYPO LCC ENDETTEMENT AVANT <50% TEAP 42% revenu >3500', 0, 0, 50, 42, 700, 900, 1050, 1400, 350, 400000, 30000, 100, 'N', 'N', 'N', 'hypothecaire', 'N', 003, NULL, 84, 3500, 300, 'N', 'N', 4.57, 1, 0, 0, 70, 0, 0, 0, 60, 0, 2, 400000, 'proprietaire', 'Y', 'Y', 'N', 0, 1750, 120, 010, 0, 'N', 'Y', NULL, NULL),
(00177, 'HYPO LCC Optimum+ 0 rejet TEAP 45%', 0, 0, 85, 40, 900, 1500, 2100, 27000, 600, 400000, 30000, 100, 'N', 'N', 'N', 'hypothecaire', 'Y', 003, NULL, 84, 3000, 300, 'N', 'N', 4.48, 1, 0, 0, 70, 0, 0, 0, 60, 0, 1, 400000, 'proprietaire', 'Y', 'Y', 'N', 0, 33000, 120, 010, 0, 'N', 'Y', NULL, NULL),
(00131, 'PERFORMANCE EV 75%, REV 3000', 0, 0, 70, 40, 700, 900, 1050, 1400, 350, 0, 15000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 003, NULL, 84, 3000, 240, 'Y', 'N', 7.95, 3, 0, 0, 70, 0, 0, 0, 60, 0, 2, 0, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1750, 84, 010, 0, 'N', 'N', NULL, NULL),
(00263, 'HYPO LCC Serenium 20 rejets Max TEAP 40%', 0, 0, 85, 40, 700, 900, 1050, 1400, 350, 400000, 30000, 100, 'N', 'N', 'N', 'hypothecaire', 'Y', 003, NULL, 84, 1300, 240, 'N', 'N', 4.52, 1, 0, 0, 70, 0, 0, 0, 60, 0, 4, 400000, 'proprietaire', 'Y', 'Y', 'N', 0, 1750, 120, 010, 0, 'N', 'Y', NULL, NULL),
(00067, 'Optimum', 0, 0, 55, 45, 700, 900, 1150, 1500, 350, 0, 15000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 003, NULL, 84, 2000, 300, 'Y', 'N', 5, 3, 0, 0, 70, 0, 0, 0, 60, 0, 2, 0, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1850, 84, 010, 0, 'N', 'N', NULL, NULL),
(00068, 'OPTIMUM + : EV MAX 50%', 0, 0, 50, 40, 700, 900, 1050, 1400, 350, 0, 15000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 003, NULL, 84, 3000, 240, 'Y', 'N', 6.5, 3, 0, 0, 70, 0, 0, 0, 60, 0, 1, 0, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1750, 84, 010, 0, 'N', 'N', NULL, NULL),
(00070, 'SERENIUM : EV > 70%, REV 3000', 0, 0, 80, 40, 700, 900, 1050, 1400, 350, 0, 15000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 003, NULL, 84, 1500, 240, 'Y', 'N', 8.95, 3, 0, 0, 70, 0, 0, 0, 60, 0, 3, 0, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1750, 84, 010, 0, 'N', 'N', NULL, NULL),
(00062, 'RC4 2 EV>80%.REV 3000 LCC', 0, 0, 80, 31.5, 850, 1100, 1325, 1528, 182, 0, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 82, 3000, 300, 'Y', 'N', 5.15, 0, 0, 0, 80, 1250, 100, 0, 60, 0, 20, 0, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1710, 60, 011, 0, 'N', 'Y', NULL, NULL),
(00063, 'RC4 3 EV>80%.REV 4500 LCC', 0, 0, 80, 33, 850, 1100, 1325, 1528, 182, 0, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 82, 4500, 300, 'Y', 'N', 5.15, 0, 0, 0, 80, 1250, 100, 0, 60, 0, 21, 0, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1710, 60, 011, 0, 'N', 'Y', NULL, NULL),
(00147, 'LCC EV<50% 3 revolvings max 300M TEAP 42%', 0, 0, 50, 42, 939, 1173, 1407, 1641, 234, 10000000000000, 30000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 84.5, NULL, 300, 'Y', 'N', 3.8, 0, 0, 0, 80, 1000, 0, 0, 60, 0, 1, 1000000000000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1875, 96, 011, 0, 'N', 'Y', NULL, NULL),
(00061, 'RC4 1 EV>80%.REV 1500 LCC', 0, 0, 80, 30, 850, 1100, 1325, 1528, 182, 0, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 82, 1500, 300, 'Y', 'N', 5.15, 0, 0, 0, 80, 1250, 100, 0, 60, 0, 19, 0, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1710, 60, 011, 0, 'N', 'Y', NULL, NULL),
(00151, 'LCC EV>50% 300M TEAP 42%', 0, 0, 0, 42, 939, 1173, 1407, 1641, 234, 10000000000000, 30000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 84.5, NULL, 300, 'Y', 'N', 4.2, 0, 0, 0, 80, 1000, 0, 0, 60, 50, 7, 1000000000000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1875, 96, 011, 0, 'N', 'Y', NULL, NULL),
(00059, 'RC3 2 REVENU 3000 LCC', 0, 0, 60, 36, 550, 830, 1055, 1258, 182, 0, 30000, 90, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 82, 3000, 300, 'Y', 'N', 5.15, 0, 0, 0, 80, 1000, 100, 0, 60, 0, 14, 0, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1440, 60, 011, 0, 'N', 'Y', NULL, NULL),
(00052, 'RC1 1 : REVENU  1500 LCC', 0, 0, 40, 30, 550, 830, 1055, 1258, 182, 0, 30000, 90, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 82, 1500, 300, 'Y', 'N', 5.15, 0, 0, 0, 80, 600, 100, 0, 60, 0, 1, 0, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1440, 60, 011, 0, 'N', 'Y', NULL, NULL),
(00053, 'RC1 2 : REVENU 3000 LCC', 0, 0, 40, 36, 550, 830, 1055, 1258, 182, 0, 30000, 90, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 82, 3000, 300, 'Y', 'N', 5.15, 0, 0, 0, 80, 600, 100, 0, 60, 0, 2, 0, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1440, 60, 011, 0, 'N', 'Y', NULL, NULL),
(00054, 'RC1 3 : REVENU 4500 LCC', 0, 0, 40, 42, 550, 830, 1055, 1258, 182, 0, 30000, 90, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 82, 4500, 300, 'Y', 'N', 5.15, 0, 0, 0, 80, 600, 100, 0, 60, 0, 3, 0, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1440, 60, 011, 0, 'N', 'Y', NULL, NULL),
(00055, 'RC2 1 REVENU  1500 LCC', 0, 0, 50, 30, 550, 830, 1101, 1252, 182, 0, 30000, 90, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 82, 1500, 300, 'Y', 'N', 5.15, 0, 0, 0, 80, 850, 100, 0, 60, 0, 7, 0, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1434, 60, 011, 0, 'N', 'Y', NULL, NULL),
(00056, 'RC2 2  REVENU 3000 LCC', 0, 0, 50, 36, 550, 830, 1055, 1258, 182, 0, 30000, 90, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 82, 3000, 300, 'Y', 'N', 5.15, 0, 0, 0, 80, 850, 100, 0, 60, 0, 8, 0, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1440, 60, 011, 0, 'N', 'Y', NULL, NULL),
(00057, 'RC2 3 REVENU 4500 LCC', 0, 0, 50, 42, 550, 830, 1055, 1258, 182, 0, 30000, 90, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 82, 4500, 300, 'Y', 'N', 5.15, 0, 0, 0, 80, 850, 100, 0, 60, 0, 9, 0, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1440, 60, 011, 0, 'N', 'Y', NULL, NULL),
(00058, 'RC3 1 REVENU  1500 LCC', 0, 0, 60, 30, 550, 830, 1055, 1258, 182, 0, 30000, 90, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 82, 1500, 300, 'Y', 'N', 5.15, 0, 0, 0, 80, 1000, 100, 0, 60, 0, 13, 0, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1440, 60, 011, 0, 'N', 'Y', NULL, NULL),
(00251, 'LCC EV > 50% 240M TEAP 45%', 0, 0, 0, 45, 939, 1173, 1407, 1641, 234, 10000000000000, 30000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 84.5, NULL, 240, 'Y', 'N', 4, 0, 0, 0, 80, 1000, 0, 0, 60, 50, 8, 1000000000000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1875, 96, 011, 0, 'N', 'Y', NULL, NULL),
(00250, 'LCC EV < 50% 3 revolvings max 240M TEAP 45%', 0, 0, 50, 45, 939, 1173, 1407, 1641, 234, 10000000000000, 30000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 84.5, NULL, 240, 'Y', 'N', 3.6, 0, 0, 0, 80, 1000, 0, 0, 60, 0, 2, 1000000000000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1875, 96, 011, 0, 'N', 'Y', NULL, NULL),
(00060, 'RC3 3 REVENU 4500 LCC', 0, 0, 60, 42, 550, 830, 1055, 1258, 182, 0, 30000, 90, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 82, 4500, 300, 'Y', 'N', 5.15, 0, 0, 0, 80, 1000, 100, 0, 60, 0, 15, 0, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1440, 60, 011, 0, 'N', 'Y', NULL, NULL),
(00127, 'RC4 5 EV>80%.REV 3000 LS2', 0, 0, 60, 31.5, 850, 1100, 1325, 1528, 182, 0, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 82, 3000, 300, 'Y', 'N', 4.3, 0, 0, 0, 80, 1250, 100, 60, 100, 0, 23, 0, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1710, 60, 012, 0, 'N', 'Y', NULL, NULL),
(00128, 'RC4 6 EV>80%.REV 4500 LS2', 0, 0, 60, 33, 850, 1100, 1325, 1528, 182, 0, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 82, 4500, 300, 'Y', 'N', 4.3, 0, 0, 0, 80, 1250, 100, 60, 100, 0, 24, 0, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1710, 60, 012, 0, 'N', 'Y', NULL, NULL),
(00126, 'RC4 4 EV>80%.REV 1500 LS2', 0, 0, 60, 30, 850, 1100, 1325, 1528, 182, 0, 30000, 80, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 82, 1500, 300, 'Y', 'N', 4.3, 0, 0, 0, 80, 1250, 100, 60, 100, 0, 22, 0, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1710, 60, 012, 0, 'N', 'Y', NULL, NULL),
(00125, 'RC3 6 REVENU 4500 LS2', 0, 0, 60, 42, 550, 830, 1055, 1258, 182, 0, 30000, 90, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 82, 4500, 300, 'Y', 'N', 4.3, 0, 0, 0, 80, 1000, 100, 60, 100, 0, 18, 0, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1440, 60, 012, 0, 'N', 'Y', NULL, NULL),
(00124, 'RC3 5 REVENU 3000 LS2', 0, 0, 60, 36, 550, 830, 1055, 1258, 182, 0, 30000, 90, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 82, 3000, 300, 'Y', 'N', 4.3, 0, 0, 0, 80, 1000, 100, 60, 100, 0, 17, 0, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1440, 60, 012, 0, 'N', 'Y', NULL, NULL),
(00123, 'RC3 4 REVENU  1500 LS2', 0, 0, 60, 30, 550, 830, 1055, 1258, 182, 0, 30000, 90, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 82, 1500, 300, 'Y', 'N', 4.3, 0, 0, 0, 80, 1000, 100, 60, 100, 0, 16, 0, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1440, 60, 012, 0, 'N', 'Y', NULL, NULL),
(00149, 'LS2 EV < 50%, 3 revolvings max  240M  TEAP 45%', 0, 0, 50, 45, 939, 1173, 1407, 1641, 234, 10000000000000, 100000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 84.5, NULL, 240, 'Y', 'N', 2.6, 0, 0, 0, 80, 1000, 0, 60, 100, 0, 3, 1000000000000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1875, 96, 012, 0, 'N', 'Y', NULL, NULL),
(00119, 'RC1 6 REVENU 4500 LS2', 0, 0, 40, 42, 550, 830, 1055, 1258, 182, 0, 30000, 90, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 82, 4500, 300, 'Y', 'N', 4.3, 0, 0, 0, 80, 600, 100, 60, 100, 0, 6, 0, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1440, 60, 012, 0, 'N', 'Y', NULL, NULL),
(00118, 'RC1 5 REVENU 3000 LS2', 0, 0, 40, 36, 550, 830, 1055, 1258, 182, 0, 30000, 90, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 82, 3000, 300, 'Y', 'N', 4.3, 0, 0, 0, 80, 600, 100, 60, 100, 0, 5, 0, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1440, 60, 012, 0, 'N', 'Y', NULL, NULL),
(00117, 'RC1 4 REVENU  1500 LS2', 0, 0, 40, 30, 550, 830, 1055, 1258, 182, 0, 30000, 90, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 82, 1500, 300, 'Y', 'N', 4.3, 0, 0, 0, 80, 600, 100, 60, 100, 0, 4, 0, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1440, 60, 012, 0, 'N', 'Y', NULL, NULL),
(00150, 'LS2 EV<50% 3 revolvings max 300M TEAP 42%	', 0, 0, 50, 42, 939, 1173, 1407, 1641, 234, 100000000000, 100000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 84.5, NULL, 300, 'Y', 'N', 2.65, 0, 0, 0, 80, 1000, 0, 60, 100, 0, 4, 100000000000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1875, 96, 012, 0, 'N', 'Y', NULL, NULL),
(00265, 'LS2 EV>50% 300M TEAP 42%', 0, 0, 0, 42, 939, 1173, 1407, 1641, 234, 100000000000, 120000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 84.5, 0, 300, 'Y', 'N', 2.75, 0, 0, 0, 80, 1000, 0, 60, 100, 50, 6, 100000000000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1875, 96, 012, 0, 'N', 'Y', NULL, NULL),
(00153, 'EV >50%, LS2, RH 85% 240mois si montant>80K€ sinon 14 ans max', 0, 0, 0, 45, 939, 1173, 1407, 1641, 234, 10000000000000, 50000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 82, NULL, 240, 'Y', 'N', 3.3, 0, 0, 0, 80, 1000, 0, 60, 100, 0, 7, 1000000000000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1875, 96, 012, 0, 'N', 'Y', NULL, NULL),
(00120, 'RC2 4 REVENU  1500 LS2', 0, 0, 50, 30, 550, 830, 1055, 1258, 182, 0, 30000, 90, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 82, 1500, 300, 'Y', 'N', 4.3, 0, 0, 0, 80, 850, 100, 60, 100, 0, 10, 0, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1440, 60, 012, 0, 'N', 'Y', NULL, NULL),
(00264, 'LS2 EV > 50% 240M TEAP 45%', 0, 0, 0, 45, 939, 1173, 1407, 1641, 234, 1000000, 120000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 84.5, 0, 240, 'Y', 'N', 2.6, 0, 0, 0, 80, 1000, 0, 60, 100, 50, 5, 1000000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1875, 96, 012, 0, 'N', 'Y', NULL, NULL),
(00121, 'RC2 5 REVENU 3000 LS2', 0, 0, 50, 36, 550, 830, 1055, 1258, 182, 0, 30000, 90, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 82, 3000, 300, 'Y', 'N', 4.3, 0, 0, 0, 80, 850, 100, 60, 100, 0, 11, 0, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1440, 60, 012, 0, 'N', 'Y', NULL, NULL),
(00154, 'EV >50%, LS2, RH 85% 300M si montant>130 K€ sinon 20 ans max', 0, 0, 0, 42, 939, 1173, 1407, 1641, 234, 10000000000000, 80000, 85, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 82, NULL, 300, 'Y', 'N', 3.5, 0, 0, 0, 80, 1000, 0, 60, 100, 0, 8, 1000000000000, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1875, 96, 012, 0, 'N', 'Y', NULL, NULL),
(00122, 'RC2 6 REVENU 4500 LS2', 0, 0, 50, 42, 550, 830, 1055, 1258, 182, 0, 30000, 90, 'N', 'N', 'N', 'hypothecaire', 'N', 009, NULL, 82, 4500, 300, 'Y', 'N', 4.3, 0, 0, 0, 80, 850, 100, 60, 100, 0, 12, 0, 'locataireproprietaire', 'Y', 'Y', 'N', 0, 1440, 60, 012, 0, 'N', 'Y', NULL, NULL),
(00243, 'Avec garantie : Autres profils 180 M', 0, 0, 90, 45, 800, 800, 1200, 1600, 200, 400000, 50000, 90, 'N', 'N', 'N', 'hypothecaire', 'Y', 004, NULL, 85, 0, 180, 'N', 'N', 3.2, 1.5, 1.9, 0, 100, 1500, 0, 0, 60, 0, 7, 400000, 'proprietaire', 'Y', 'Y', 'Y', 0, 2000, 120, 013, 0, 'N', 'Y', NULL, NULL),
(00221, 'Avec garantie : 0 rejets - revenu sup 3 000 € 300M', 0, 0, 90, 45, 800, 800, 1200, 1600, 200, 400000, 50000, 90, 'N', 'N', 'N', 'hypothecaire', 'N', 004, NULL, 85, 3000, 300, 'Y', 'N', 4.32, 1.5, 1.9, 0, 100, 1500, 0, 0, 60, 0, 6, 400000, 'proprietaire', 'Y', 'Y', 'Y', 0, 2000, 120, 013, 0, 'N', 'Y', NULL, NULL),
(00222, 'Avec garantie : Autres profils 300 M', 0, 0, 90, 45, 800, 800, 1200, 1600, 200, 400000, 50000, 90, 'N', 'N', 'N', 'hypothecaire', 'Y', 004, NULL, 85, 0, 300, 'N', 'N', 3.65, 1.5, 1.9, 0, 100, 1500, 0, 0, 60, 0, 9, 400000, 'proprietaire', 'Y', 'Y', 'Y', 0, 2000, 120, 013, 0, 'N', 'Y', NULL, NULL),
(00220, 'Avec garantie : 0 rejts - end avt inf 50 % 300M', 0, 0, 50, 45, 800, 800, 1200, 1600, 200, 400000, 50000, 90, 'N', 'N', 'N', 'hypothecaire', 'Y', 004, NULL, 85, 0, 300, 'N', 'N', 3.35, 1.5, 1.9, 0, 100, 1500, 0, 0, 60, 0, 2, 400000, 'proprietaire', 'Y', 'Y', 'Y', 0, 2000, 120, 013, 0, 'N', 'Y', NULL, NULL),
(00241, 'Avec garantie : 0 rejts - end avt inf 50 % 180M', 0, 0, 50, 45, 800, 800, 1200, 1600, 200, 400000, 50000, 90, 'N', 'N', 'N', 'hypothecaire', 'Y', 004, NULL, 85, 0, 180, 'N', 'N', 2.95, 1.5, 1.9, 0, 100, 1500, 0, 0, 60, 0, 3, 400000, 'proprietaire', 'Y', 'Y', 'Y', 0, 2000, 120, 013, 0, 'N', 'Y', NULL, NULL),
(00242, 'Avec garantie : 0 rejets - revenu sup 3 000 € 180M', 0, 0, 90, 45, 800, 800, 1200, 1600, 200, 400000, 50000, 90, 'N', 'N', 'N', 'hypothecaire', 'N', 004, NULL, 85, 3000, 180, 'Y', 'N', 3.14, 1.5, 1.9, 0, 100, 1500, 0, 0, 60, 0, 4, 400000, 'proprietaire', 'Y', 'Y', 'Y', 0, 2000, 120, 013, 0, 'N', 'Y', NULL, NULL),
(00240, 'Avec garantie : Autres profils 240 M', 0, 0, 90, 45, 800, 800, 1200, 1600, 200, 400000, 50000, 90, 'N', 'N', 'N', 'hypothecaire', 'Y', 004, NULL, 85, 0, 240, 'N', 'N', 3.65, 1.5, 1.9, 0, 100, 1500, 0, 0, 60, 0, 8, 400000, 'proprietaire', 'Y', 'Y', 'Y', 0, 2000, 120, 013, 0, 'N', 'Y', NULL, NULL),
(00239, 'Avec garantie : 0 rejets - revenu sup 3 000 € 240M', 0, 0, 90, 45, 800, 800, 1200, 1600, 200, 400000, 50000, 90, 'N', 'N', 'N', 'hypothecaire', 'N', 004, NULL, 85, 3000, 240, 'Y', 'N', 3.99, 1.5, 1.9, 0, 100, 1500, 0, 0, 60, 0, 5, 400000, 'proprietaire', 'Y', 'Y', 'Y', 0, 2000, 120, 013, 0, 'N', 'Y', NULL, NULL),
(00238, 'Avec garantie : 0 rejets - end avt inf 50 % 240M', 0, 0, 50, 45, 800, 800, 1200, 1600, 200, 400000, 50000, 90, 'N', 'N', 'N', 'hypothecaire', 'N', 004, NULL, 85, 0, 240, 'Y', 'N', 3.96, 1.5, 1.9, 0, 100, 1500, 0, 0, 60, 0, 1, 400000, 'proprietaire', 'Y', 'Y', 'Y', 0, 2000, 120, 013, 0, 'N', 'Y', NULL, NULL),
(00319, 'Propriétaire de 85 à 120 mois < 50 000 €', 0, 18, 0, 66, 681, 791, 894, 997, 103, 50000, 8000, 0, 'N', 'N', 'N', 'consommation', 'Y', 040, NULL, 90, 1173, 120, 'N', 'Y', 4.7, 3.5, 0, 100, 80, 1500, 1, 0, 0, 0, NULL, 0, 'proprietaire', 'Y', 'N', 'N', 10, 1100, 85, 020, 0, 'N', 'Y', NULL, NULL),
(00326, 'Propriétaire entre 121-144 Mois > 75 000€ Accédant < 2 ans', 0, 18, 0, 45, 681, 792, 894, 997, 103, 100000, 75001, 0, 'N', 'N', 'N', 'consommation', 'Y', 040, NULL, 90, 1173, 144, 'N', 'Y', 5.3, 3.5, 0, 100, 80, 1500, 1, 0, 0, 0, NULL, 0, 'proprietaire', 'Y', 'N', 'N', 10, 1100, 121, 020, 0, 'N', 'Y', NULL, NULL),
(00325, 'Propriétaire entre 60-120 Mois > 75 000€ Accédant < 2 ans', 0, 18, 0, 45, 681, 793, 894, 997, 103, 100000, 75001, 0, 'N', 'N', 'N', 'consommation', 'Y', 040, NULL, 90, 1173, 120, 'N', 'Y', 5.15, 3.5, 0, 100, 80, 1500, 1, 0, 0, 0, NULL, 0, 'proprietaire', 'Y', 'N', 'N', 10, 1100, 60, 020, 0, 'N', 'Y', NULL, NULL),
(00315, 'Locataire 60 à 72 mois', 0, 18, 0, 66, 681, 791, 894, 997, 103, 0, 8000, 0, 'N', 'N', 'N', 'consommation', 'Y', 040, NULL, 90, 1173, 72, 'N', 'Y', 4.3, 3.5, 0, 100, 80, 1500, 1, 0, 0, 0, NULL, 50000, 'locataire', 'Y', 'N', 'N', 10, 1100, 60, 020, 0, 'N', 'Y', NULL, NULL),
(00316, 'Locataire 73 à 84 mois', 0, 18, 0, 66, 681, 791, 894, 997, 103, 0, 8000, 0, 'N', 'N', 'N', 'consommation', 'Y', 040, NULL, 90, 1173, 84, 'N', 'Y', 4.55, 3.5, 0, 100, 80, 1500, 1, 0, 0, 0, NULL, 50000, 'locataire', 'Y', 'N', 'N', 10, 1100, 73, 020, 0, 'N', 'Y', NULL, NULL),
(00317, 'Propriétaire de 60 à 72 mois < 50 000 €', 0, 18, 0, 66, 681, 791, 894, 997, 103, 50000, 8000, 0, 'N', 'N', 'N', 'consommation', 'Y', 040, NULL, 90, 1173, 72, 'N', 'Y', 4.3, 3.5, 0, 100, 80, 1500, 1, 0, 0, 0, NULL, 0, 'proprietaire', 'Y', 'N', 'N', 10, 1100, 60, 020, 0, 'N', 'Y', NULL, NULL),
(00318, 'Propriétaire de 73 à 84 mois < 50 000 €', 0, 18, 0, 66, 681, 791, 894, 997, 103, 50000, 8000, 0, 'N', 'N', 'N', 'consommation', 'Y', 040, NULL, 90, 1173, 84, 'N', 'Y', 4.55, 3.5, 0, 100, 80, 1500, 1, 0, 0, 0, NULL, 0, 'proprietaire', 'Y', 'N', 'N', 10, 1100, 73, 020, 0, 'N', 'Y', NULL, NULL),
(00320, 'Propriétaire 144 mois < 50 000 €', 0, 18, 0, 66, 681, 791, 894, 997, 103, 50000, 35000, 0, 'N', 'N', 'N', 'consommation', 'Y', 040, NULL, 90, 1173, 144, 'N', 'Y', 5, 3.5, 0, 100, 80, 1500, 1, 0, 0, 0, NULL, 0, 'proprietaire', 'Y', 'N', 'N', 10, 1100, 121, 020, 0, 'N', 'Y', NULL, NULL),
(00322, 'Propriétaire 144 mois > 50 000 €', 0, 18, 0, 66, 681, 791, 894, 997, 103, 75000, 50001, 0, 'N', 'N', 'N', 'consommation', 'Y', 040, NULL, 90, 1173, 144, 'N', 'Y', 5.1, 3.5, 0, 100, 80, 1500, 1, 0, 0, 0, NULL, 0, 'proprietaire', 'Y', 'N', 'N', 10, 1100, 121, 020, 0, 'N', 'Y', NULL, NULL),
(00323, 'Propriétaire entre 121-144 Mois > 75 000€ Accédant > 2 ans', 0, 18, 0, 50, 681, 792, 894, 997, 103, 100000, 75001, 0, 'N', 'N', 'N', 'consommation', 'Y', 040, NULL, 90, 1173, 144, 'N', 'Y', 5.3, 3.5, 0, 100, 80, 1500, 1, 0, 0, 0, NULL, 0, 'proprietaire', 'Y', 'N', 'N', 10, 1100, 121, 020, 0, 'N', 'Y', NULL, NULL),
(00324, 'Propriétaire entre 60-120 Mois > 75 000€ Accédant > 2 ans', 0, 18, 0, 50, 681, 792, 894, 997, 103, 100000, 75001, 0, 'N', 'N', 'N', 'consommation', 'Y', 040, NULL, 90, 1173, 120, 'N', 'Y', 5.25, 3.5, 0, 100, 80, 1500, 1, 0, 0, 0, NULL, 0, 'proprietaire', 'Y', 'N', 'N', 10, 1100, 60, 020, 0, 'N', 'Y', NULL, NULL),
(00321, 'Propriétaire jusqu\'à  120 mois > 50 000 €', 0, 18, 0, 66, 681, 791, 894, 997, 103, 75000, 50001, 0, 'N', 'N', 'N', 'consommation', 'Y', 040, NULL, 90, 1173, 120, 'N', 'Y', 4.85, 3.5, 0, 100, 80, 1500, 1, 0, 0, 0, NULL, 0, 'proprietaire', 'Y', 'N', 'N', 10, 1100, 60, 020, 0, 'N', 'Y', NULL, NULL);

