DEBUG avant csrf_token
DEBUG après csrf_token
Query SELECT NUM_CHARGEMENT, MAPPING FROM T_CHARGEMENT WHERE NUM_CHARGEMENT =(SELECT MAX(NUM_CHARGEMENT) AS NUM_CHARGEMENT FROM T_CHARGEMENT WHERE USER = :param1 AND FICHIER = :param2 ) faity fichier_50000_avecunnomarallongepourvoirsicbon.csv
Num chargement : 7  et mapping : donnees_fictivesLight.csv-2025-3-1-13-8-51
Avant controlMeta
NB ESG : 4
Généré : 
                SELECT
                    ID_TIERS_PRINCP AS ID_LIGNE,
                    COUNT(DISTINCT TYPE_PERSONNE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(TYPE_PERSONNE = '', 'vide', TYPE_PERSONNE) ORDER BY TYPE_PERSONNE SEPARATOR ', ') AS LISTE_ERREURS,
                    ENCOURS_CERTIF_COMPTABLE
                FROM (
                    SELECT
                        ID_TIERS_PRINCP,
                        TYPE_PERSONNE,
                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE
                    FROM T_DONNEES_CLIENT_FAITY
                    WHERE NUM_CHARGEMENT = :num
                    GROUP BY ID_TIERS_PRINCP, TYPE_PERSONNE
                ) PERIMETRE
                WHERE 
                    TYPE_PERSONNE IS NOT NULL
                    AND ID_TIERS_PRINCP IS NOT NULL 
                    AND ID_TIERS_PRINCP <> '' 
                GROUP BY ID_TIERS_PRINCP 
                HAVING COUNT(DISTINCT TYPE_PERSONNE) > 1
                ORDER BY ID_TIERS_PRINCP
            
Généré : 
                SELECT
                    ID_TIERS_PRINCP AS ID_LIGNE,
                    COUNT(DISTINCT PAYS_RESIDENCE_FISCALE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(PAYS_RESIDENCE_FISCALE = '', 'vide', PAYS_RESIDENCE_FISCALE) ORDER BY PAYS_RESIDENCE_FISCALE SEPARATOR ', ') AS LISTE_ERREURS,
                    ENCOURS_CERTIF_COMPTABLE
                FROM (
                    SELECT
                        ID_TIERS_PRINCP,
                        PAYS_RESIDENCE_FISCALE,
                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE
                    FROM T_DONNEES_CLIENT_FAITY
                    WHERE NUM_CHARGEMENT = :num
                    GROUP BY ID_TIERS_PRINCP, PAYS_RESIDENCE_FISCALE
                ) PERIMETRE
                WHERE 
                    PAYS_RESIDENCE_FISCALE IS NOT NULL
                    AND ID_TIERS_PRINCP IS NOT NULL 
                    AND ID_TIERS_PRINCP <> '' 
                GROUP BY ID_TIERS_PRINCP 
                HAVING COUNT(DISTINCT PAYS_RESIDENCE_FISCALE) > 1
                ORDER BY ID_TIERS_PRINCP
            
Généré : 
                SELECT
                    ID_TIERS_PRINCP AS ID_LIGNE,
                    COUNT(DISTINCT PAYS_RESIDENCE_MONETAIRE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(PAYS_RESIDENCE_MONETAIRE = '', 'vide', PAYS_RESIDENCE_MONETAIRE) ORDER BY PAYS_RESIDENCE_MONETAIRE SEPARATOR ', ') AS LISTE_ERREURS,
                    ENCOURS_CERTIF_COMPTABLE
                FROM (
                    SELECT
                        ID_TIERS_PRINCP,
                        PAYS_RESIDENCE_MONETAIRE,
                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE
                    FROM T_DONNEES_CLIENT_FAITY
                    WHERE NUM_CHARGEMENT = :num
                    GROUP BY ID_TIERS_PRINCP, PAYS_RESIDENCE_MONETAIRE
                ) PERIMETRE
                WHERE 
                    PAYS_RESIDENCE_MONETAIRE IS NOT NULL
                    AND ID_TIERS_PRINCP IS NOT NULL 
                    AND ID_TIERS_PRINCP <> '' 
                GROUP BY ID_TIERS_PRINCP 
                HAVING COUNT(DISTINCT PAYS_RESIDENCE_MONETAIRE) > 1
                ORDER BY ID_TIERS_PRINCP
            
Généré : 
                SELECT
                    ID_TIERS_PRINCP AS ID_LIGNE,
                    COUNT(DISTINCT ADR_BIEN_FINANCE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(ADR_BIEN_FINANCE = '', 'vide', ADR_BIEN_FINANCE) ORDER BY ADR_BIEN_FINANCE SEPARATOR ', ') AS LISTE_ERREURS,
                    ENCOURS_CERTIF_COMPTABLE
                FROM (
                    SELECT
                        ID_TIERS_PRINCP,
                        ADR_BIEN_FINANCE,
                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE
                    FROM T_DONNEES_CLIENT_FAITY
                    WHERE NUM_CHARGEMENT = :num
                    GROUP BY ID_TIERS_PRINCP, ADR_BIEN_FINANCE
                ) PERIMETRE
                WHERE 
                    ADR_BIEN_FINANCE IS NOT NULL
                    AND ID_TIERS_PRINCP IS NOT NULL 
                    AND ID_TIERS_PRINCP <> '' 
                GROUP BY ID_TIERS_PRINCP 
                HAVING COUNT(DISTINCT ADR_BIEN_FINANCE) > 1
                ORDER BY ID_TIERS_PRINCP
            
Généré : 
                SELECT
                    ID_TIERS_PRINCP AS ID_LIGNE,
                    COUNT(DISTINCT ADR_BIEN_NOM_RUE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(ADR_BIEN_NOM_RUE = '', 'vide', ADR_BIEN_NOM_RUE) ORDER BY ADR_BIEN_NOM_RUE SEPARATOR ', ') AS LISTE_ERREURS,
                    ENCOURS_CERTIF_COMPTABLE
                FROM (
                    SELECT
                        ID_TIERS_PRINCP,
                        ADR_BIEN_NOM_RUE,
                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE
                    FROM T_DONNEES_CLIENT_FAITY
                    WHERE NUM_CHARGEMENT = :num
                    GROUP BY ID_TIERS_PRINCP, ADR_BIEN_NOM_RUE
                ) PERIMETRE
                WHERE 
                    ADR_BIEN_NOM_RUE IS NOT NULL
                    AND ID_TIERS_PRINCP IS NOT NULL 
                    AND ID_TIERS_PRINCP <> '' 
                GROUP BY ID_TIERS_PRINCP 
                HAVING COUNT(DISTINCT ADR_BIEN_NOM_RUE) > 1
                ORDER BY ID_TIERS_PRINCP
            
Généré : 
                SELECT
                    ID_TIERS_PRINCP AS ID_LIGNE,
                    COUNT(DISTINCT ADR_BIEN_NO_RUE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(ADR_BIEN_NO_RUE = '', 'vide', ADR_BIEN_NO_RUE) ORDER BY ADR_BIEN_NO_RUE SEPARATOR ', ') AS LISTE_ERREURS,
                    ENCOURS_CERTIF_COMPTABLE
                FROM (
                    SELECT
                        ID_TIERS_PRINCP,
                        ADR_BIEN_NO_RUE,
                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE
                    FROM T_DONNEES_CLIENT_FAITY
                    WHERE NUM_CHARGEMENT = :num
                    GROUP BY ID_TIERS_PRINCP, ADR_BIEN_NO_RUE
                ) PERIMETRE
                WHERE 
                    ADR_BIEN_NO_RUE IS NOT NULL
                    AND ID_TIERS_PRINCP IS NOT NULL 
                    AND ID_TIERS_PRINCP <> '' 
                GROUP BY ID_TIERS_PRINCP 
                HAVING COUNT(DISTINCT ADR_BIEN_NO_RUE) > 1
                ORDER BY ID_TIERS_PRINCP
            
Généré : 
                SELECT
                    ID_TIERS_PRINCP AS ID_LIGNE,
                    COUNT(DISTINCT ADR_BIEN_CODE_POSTAL) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(ADR_BIEN_CODE_POSTAL = '', 'vide', ADR_BIEN_CODE_POSTAL) ORDER BY ADR_BIEN_CODE_POSTAL SEPARATOR ', ') AS LISTE_ERREURS,
                    ENCOURS_CERTIF_COMPTABLE
                FROM (
                    SELECT
                        ID_TIERS_PRINCP,
                        ADR_BIEN_CODE_POSTAL,
                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE
                    FROM T_DONNEES_CLIENT_FAITY
                    WHERE NUM_CHARGEMENT = :num
                    GROUP BY ID_TIERS_PRINCP, ADR_BIEN_CODE_POSTAL
                ) PERIMETRE
                WHERE 
                    ADR_BIEN_CODE_POSTAL IS NOT NULL
                    AND ID_TIERS_PRINCP IS NOT NULL 
                    AND ID_TIERS_PRINCP <> '' 
                GROUP BY ID_TIERS_PRINCP 
                HAVING COUNT(DISTINCT ADR_BIEN_CODE_POSTAL) > 1
                ORDER BY ID_TIERS_PRINCP
            
Généré : 
                SELECT
                    ID_TIERS_PRINCP AS ID_LIGNE,
                    COUNT(DISTINCT ADR_BIEN_VILLE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(ADR_BIEN_VILLE = '', 'vide', ADR_BIEN_VILLE) ORDER BY ADR_BIEN_VILLE SEPARATOR ', ') AS LISTE_ERREURS,
                    ENCOURS_CERTIF_COMPTABLE
                FROM (
                    SELECT
                        ID_TIERS_PRINCP,
                        ADR_BIEN_VILLE,
                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE
                    FROM T_DONNEES_CLIENT_FAITY
                    WHERE NUM_CHARGEMENT = :num
                    GROUP BY ID_TIERS_PRINCP, ADR_BIEN_VILLE
                ) PERIMETRE
                WHERE 
                    ADR_BIEN_VILLE IS NOT NULL
                    AND ID_TIERS_PRINCP IS NOT NULL 
                    AND ID_TIERS_PRINCP <> '' 
                GROUP BY ID_TIERS_PRINCP 
                HAVING COUNT(DISTINCT ADR_BIEN_VILLE) > 1
                ORDER BY ID_TIERS_PRINCP
            
Généré [QDUTR2] : 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT TYPE_PROD) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(TYPE_PROD = '', 'vide', TYPE_PROD) ORDER BY TYPE_PROD SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT TYPE_PROD) > 1
                ORDER BY ID_PRET
            
Généré [QDUTR3] : 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT DEVISE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(DEVISE = '', 'vide', DEVISE) ORDER BY DEVISE SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT DEVISE) > 1
                ORDER BY ID_PRET
            
Généré [QDUTR4] : 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT PRODUIT) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(PRODUIT = '', 'vide', PRODUIT) ORDER BY PRODUIT SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT PRODUIT) > 1
                ORDER BY ID_PRET
            
Généré [QDUTR5] : 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT MODE_AMORTISSEMENT) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(MODE_AMORTISSEMENT = '', 'vide', MODE_AMORTISSEMENT) ORDER BY MODE_AMORTISSEMENT SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT MODE_AMORTISSEMENT) > 1
                ORDER BY ID_PRET
            
Généré [QDUTR6] : 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT NATURE_TAUX) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(NATURE_TAUX = '', 'vide', NATURE_TAUX) ORDER BY NATURE_TAUX SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT NATURE_TAUX) > 1
                ORDER BY ID_PRET
            
Généré [QDUTR7] : 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT MONTANT_OPERATION) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(MONTANT_OPERATION = '', 'vide', MONTANT_OPERATION) ORDER BY MONTANT_OPERATION SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT MONTANT_OPERATION) > 1
                ORDER BY ID_PRET
            
Généré [QDUTR8] : 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT ENCOURS_CERTIF_COMPTABLE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(ENCOURS_CERTIF_COMPTABLE = '', 'vide', ENCOURS_CERTIF_COMPTABLE) ORDER BY ENCOURS_CERTIF_COMPTABLE SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT ENCOURS_CERTIF_COMPTABLE) > 1
                ORDER BY ID_PRET
            
Généré [QDUTR10] : 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT TYPE_OPERATION) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(TYPE_OPERATION = '', 'vide', TYPE_OPERATION) ORDER BY TYPE_OPERATION SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT TYPE_OPERATION) > 1
                ORDER BY ID_PRET
            
Généré [QDUTR11] : 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT DUREE_TOTALE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(DUREE_TOTALE = '', 'vide', DUREE_TOTALE) ORDER BY DUREE_TOTALE SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT DUREE_TOTALE) > 1
                ORDER BY ID_PRET
            
Généré [QDUTR12] : 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT DUREE_RESTANTE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(DUREE_RESTANTE = '', 'vide', DUREE_RESTANTE) ORDER BY DUREE_RESTANTE SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT DUREE_RESTANTE) > 1
                ORDER BY ID_PRET
            
Généré [QDUTR13] : 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT DUREE_DIFF_AMORT) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(DUREE_DIFF_AMORT = '', 'vide', DUREE_DIFF_AMORT) ORDER BY DUREE_DIFF_AMORT SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT DUREE_DIFF_AMORT) > 1
                ORDER BY ID_PRET
            
Généré [QDUTR14] : 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT TYPE_BIEN) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(TYPE_BIEN = '', 'vide', TYPE_BIEN) ORDER BY TYPE_BIEN SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT TYPE_BIEN) > 1
                ORDER BY ID_PRET
            
Généré [QDUTR15] : 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT TAUX_NOMINAL_ANN_BRUT) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(TAUX_NOMINAL_ANN_BRUT = '', 'vide', TAUX_NOMINAL_ANN_BRUT) ORDER BY TAUX_NOMINAL_ANN_BRUT SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT TAUX_NOMINAL_ANN_BRUT) > 1
                ORDER BY ID_PRET
            
Généré [QDUTR16] : 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT TAUX_EFF_GLOBAL) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(TAUX_EFF_GLOBAL = '', 'vide', TAUX_EFF_GLOBAL) ORDER BY TAUX_EFF_GLOBAL SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT TAUX_EFF_GLOBAL) > 1
                ORDER BY ID_PRET
            
Généré [QDUTR17] : 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT DATE_SAISIE_COND_FIN) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(DATE_SAISIE_COND_FIN = '', 'vide', DATE_SAISIE_COND_FIN) ORDER BY DATE_SAISIE_COND_FIN SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT DATE_SAISIE_COND_FIN) > 1
                ORDER BY ID_PRET
            
Généré [QDUTR18] : 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT ADR_BIEN_FINANCE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(ADR_BIEN_FINANCE = '', 'vide', ADR_BIEN_FINANCE) ORDER BY ADR_BIEN_FINANCE SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT ADR_BIEN_FINANCE) > 1
                ORDER BY ID_PRET
            
Généré [QDUTR19] : 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT ADR_BIEN_NO_RUE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(ADR_BIEN_NO_RUE = '', 'vide', ADR_BIEN_NO_RUE) ORDER BY ADR_BIEN_NO_RUE SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT ADR_BIEN_NO_RUE) > 1
                ORDER BY ID_PRET
            
Généré [QDUTR20] : 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT ADR_BIEN_NOM_RUE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(ADR_BIEN_NOM_RUE = '', 'vide', ADR_BIEN_NOM_RUE) ORDER BY ADR_BIEN_NOM_RUE SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT ADR_BIEN_NOM_RUE) > 1
                ORDER BY ID_PRET
            
Généré [QDUTR21] : 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT ADR_BIEN_CODE_POSTAL) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(ADR_BIEN_CODE_POSTAL = '', 'vide', ADR_BIEN_CODE_POSTAL) ORDER BY ADR_BIEN_CODE_POSTAL SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT ADR_BIEN_CODE_POSTAL) > 1
                ORDER BY ID_PRET
            
Généré [QDUTR22] : 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT ADR_BIEN_VILLE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(ADR_BIEN_VILLE = '', 'vide', ADR_BIEN_VILLE) ORDER BY ADR_BIEN_VILLE SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT ADR_BIEN_VILLE) > 1
                ORDER BY ID_PRET
            
Généré : 
                SELECT
                    ID_COLLATERAL AS ID_LIGNE,
                    COUNT(DISTINCT COLLATERAL_GARANTIE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(COLLATERAL_GARANTIE = '', 'vide', COLLATERAL_GARANTIE) ORDER BY COLLATERAL_GARANTIE SEPARATOR ', ') AS LISTE_ERREURS,
                    ENCOURS_CERTIF_COMPTABLE
                FROM (
                    SELECT
                        ID_COLLATERAL,
                        COLLATERAL_GARANTIE,
                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE
                    FROM T_DONNEES_CLIENT_FAITY
                    WHERE NUM_CHARGEMENT = :num
                    GROUP BY ID_COLLATERAL, COLLATERAL_GARANTIE
                ) PERIMETRE
                WHERE 
                    COLLATERAL_GARANTIE IS NOT NULL
                    AND ID_COLLATERAL IS NOT NULL 
                    AND ID_COLLATERAL <> '' 
                GROUP BY ID_COLLATERAL 
                HAVING COUNT(DISTINCT COLLATERAL_GARANTIE) > 1
                ORDER BY ID_COLLATERAL
            
Généré : 
                SELECT
                    ID_COLLATERAL AS ID_LIGNE,
                    COUNT(DISTINCT COLLATERAL_MT_DERNIERE_EVALUATION) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(COLLATERAL_MT_DERNIERE_EVALUATION = '', 'vide', COLLATERAL_MT_DERNIERE_EVALUATION) ORDER BY COLLATERAL_MT_DERNIERE_EVALUATION SEPARATOR ', ') AS LISTE_ERREURS,
                    ENCOURS_CERTIF_COMPTABLE
                FROM (
                    SELECT
                        ID_COLLATERAL,
                        COLLATERAL_MT_DERNIERE_EVALUATION,
                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE
                    FROM T_DONNEES_CLIENT_FAITY
                    WHERE NUM_CHARGEMENT = :num
                    GROUP BY ID_COLLATERAL, COLLATERAL_MT_DERNIERE_EVALUATION
                ) PERIMETRE
                WHERE 
                    COLLATERAL_MT_DERNIERE_EVALUATION IS NOT NULL
                    AND ID_COLLATERAL IS NOT NULL 
                    AND ID_COLLATERAL <> '' 
                GROUP BY ID_COLLATERAL 
                HAVING COUNT(DISTINCT COLLATERAL_MT_DERNIERE_EVALUATION) > 1
                ORDER BY ID_COLLATERAL
            
Généré : 
                SELECT
                    ID_COLLATERAL AS ID_LIGNE,
                    COUNT(DISTINCT COLLATERAL_DT_DERNIERE_EVALUATION) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(COLLATERAL_DT_DERNIERE_EVALUATION = '', 'vide', COLLATERAL_DT_DERNIERE_EVALUATION) ORDER BY COLLATERAL_DT_DERNIERE_EVALUATION SEPARATOR ', ') AS LISTE_ERREURS,
                    ENCOURS_CERTIF_COMPTABLE
                FROM (
                    SELECT
                        ID_COLLATERAL,
                        COLLATERAL_DT_DERNIERE_EVALUATION,
                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE
                    FROM T_DONNEES_CLIENT_FAITY
                    WHERE NUM_CHARGEMENT = :num
                    GROUP BY ID_COLLATERAL, COLLATERAL_DT_DERNIERE_EVALUATION
                ) PERIMETRE
                WHERE 
                    COLLATERAL_DT_DERNIERE_EVALUATION IS NOT NULL
                    AND ID_COLLATERAL IS NOT NULL 
                    AND ID_COLLATERAL <> '' 
                GROUP BY ID_COLLATERAL 
                HAVING COUNT(DISTINCT COLLATERAL_DT_DERNIERE_EVALUATION) > 1
                ORDER BY ID_COLLATERAL
            
Généré : 
                SELECT
                    ID_COLLATERAL AS ID_LIGNE,
                    COUNT(DISTINCT ADR_COLLATERAL) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(ADR_COLLATERAL = '', 'vide', ADR_COLLATERAL) ORDER BY ADR_COLLATERAL SEPARATOR ', ') AS LISTE_ERREURS,
                    ENCOURS_CERTIF_COMPTABLE
                FROM (
                    SELECT
                        ID_COLLATERAL,
                        ADR_COLLATERAL,
                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE
                    FROM T_DONNEES_CLIENT_FAITY
                    WHERE NUM_CHARGEMENT = :num
                    GROUP BY ID_COLLATERAL, ADR_COLLATERAL
                ) PERIMETRE
                WHERE 
                    ADR_COLLATERAL IS NOT NULL
                    AND ID_COLLATERAL IS NOT NULL 
                    AND ID_COLLATERAL <> '' 
                GROUP BY ID_COLLATERAL 
                HAVING COUNT(DISTINCT ADR_COLLATERAL) > 1
                ORDER BY ID_COLLATERAL
            
Généré : 
                SELECT
                    ID_COLLATERAL AS ID_LIGNE,
                    COUNT(DISTINCT COLLATERAL_NUM_RUE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(COLLATERAL_NUM_RUE = '', 'vide', COLLATERAL_NUM_RUE) ORDER BY COLLATERAL_NUM_RUE SEPARATOR ', ') AS LISTE_ERREURS,
                    ENCOURS_CERTIF_COMPTABLE
                FROM (
                    SELECT
                        ID_COLLATERAL,
                        COLLATERAL_NUM_RUE,
                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE
                    FROM T_DONNEES_CLIENT_FAITY
                    WHERE NUM_CHARGEMENT = :num
                    GROUP BY ID_COLLATERAL, COLLATERAL_NUM_RUE
                ) PERIMETRE
                WHERE 
                    COLLATERAL_NUM_RUE IS NOT NULL
                    AND ID_COLLATERAL IS NOT NULL 
                    AND ID_COLLATERAL <> '' 
                GROUP BY ID_COLLATERAL 
                HAVING COUNT(DISTINCT COLLATERAL_NUM_RUE) > 1
                ORDER BY ID_COLLATERAL
            
Généré : 
                SELECT
                    ID_COLLATERAL AS ID_LIGNE,
                    COUNT(DISTINCT COLLATERAL_NOM_RUE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(COLLATERAL_NOM_RUE = '', 'vide', COLLATERAL_NOM_RUE) ORDER BY COLLATERAL_NOM_RUE SEPARATOR ', ') AS LISTE_ERREURS,
                    ENCOURS_CERTIF_COMPTABLE
                FROM (
                    SELECT
                        ID_COLLATERAL,
                        COLLATERAL_NOM_RUE,
                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE
                    FROM T_DONNEES_CLIENT_FAITY
                    WHERE NUM_CHARGEMENT = :num
                    GROUP BY ID_COLLATERAL, COLLATERAL_NOM_RUE
                ) PERIMETRE
                WHERE 
                    COLLATERAL_NOM_RUE IS NOT NULL
                    AND ID_COLLATERAL IS NOT NULL 
                    AND ID_COLLATERAL <> '' 
                GROUP BY ID_COLLATERAL 
                HAVING COUNT(DISTINCT COLLATERAL_NOM_RUE) > 1
                ORDER BY ID_COLLATERAL
            
Généré : 
                SELECT
                    ID_COLLATERAL AS ID_LIGNE,
                    COUNT(DISTINCT COLLATERAL_CP) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(COLLATERAL_CP = '', 'vide', COLLATERAL_CP) ORDER BY COLLATERAL_CP SEPARATOR ', ') AS LISTE_ERREURS,
                    ENCOURS_CERTIF_COMPTABLE
                FROM (
                    SELECT
                        ID_COLLATERAL,
                        COLLATERAL_CP,
                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE
                    FROM T_DONNEES_CLIENT_FAITY
                    WHERE NUM_CHARGEMENT = :num
                    GROUP BY ID_COLLATERAL, COLLATERAL_CP
                ) PERIMETRE
                WHERE 
                    COLLATERAL_CP IS NOT NULL
                    AND ID_COLLATERAL IS NOT NULL 
                    AND ID_COLLATERAL <> '' 
                GROUP BY ID_COLLATERAL 
                HAVING COUNT(DISTINCT COLLATERAL_CP) > 1
                ORDER BY ID_COLLATERAL
            
Généré : 
                SELECT
                    ID_COLLATERAL AS ID_LIGNE,
                    COUNT(DISTINCT COLLATERAL_VILLE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(COLLATERAL_VILLE = '', 'vide', COLLATERAL_VILLE) ORDER BY COLLATERAL_VILLE SEPARATOR ', ') AS LISTE_ERREURS,
                    ENCOURS_CERTIF_COMPTABLE
                FROM (
                    SELECT
                        ID_COLLATERAL,
                        COLLATERAL_VILLE,
                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE
                    FROM T_DONNEES_CLIENT_FAITY
                    WHERE NUM_CHARGEMENT = :num
                    GROUP BY ID_COLLATERAL, COLLATERAL_VILLE
                ) PERIMETRE
                WHERE 
                    COLLATERAL_VILLE IS NOT NULL
                    AND ID_COLLATERAL IS NOT NULL 
                    AND ID_COLLATERAL <> '' 
                GROUP BY ID_COLLATERAL 
                HAVING COUNT(DISTINCT COLLATERAL_VILLE) > 1
                ORDER BY ID_COLLATERAL
            
Généré [QDUES1] : 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT DPE_ETIQUETTE_ENERGIE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(DPE_ETIQUETTE_ENERGIE = '', 'vide', DPE_ETIQUETTE_ENERGIE) ORDER BY DPE_ETIQUETTE_ENERGIE SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT DPE_ETIQUETTE_ENERGIE) > 1
                ORDER BY ID_PRET
            
Généré [QDUES2] : 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT DPE_CONSO_ENERGIE_PRIMAIRE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(DPE_CONSO_ENERGIE_PRIMAIRE = '', 'vide', DPE_CONSO_ENERGIE_PRIMAIRE) ORDER BY DPE_CONSO_ENERGIE_PRIMAIRE SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT DPE_CONSO_ENERGIE_PRIMAIRE) > 1
                ORDER BY ID_PRET
            
Généré [QDUES3] : 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT DPE_EMISSION_GAZ) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(DPE_EMISSION_GAZ = '', 'vide', DPE_EMISSION_GAZ) ORDER BY DPE_EMISSION_GAZ SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT DPE_EMISSION_GAZ) > 1
                ORDER BY ID_PRET
            
Généré [QDUES4] : 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT DPE_DATE_REALISATION) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(DPE_DATE_REALISATION = '', 'vide', DPE_DATE_REALISATION) ORDER BY DPE_DATE_REALISATION SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT DPE_DATE_REALISATION) > 1
                ORDER BY ID_PRET
            
DEBUG [QDUTI1] - Catégorie : Tiers ; dbField : TYPE_PERSONNE
✅ Requête acceptée [QDUTI1] : Contrôle d'unicité du type de personne
DEBUG [QDUTI2] - Catégorie : Tiers ; dbField : PAYS_RESIDENCE_FISCALE
✅ Requête acceptée [QDUTI2] : Contrôle d'unicité du pays de résidence fiscale
DEBUG [QDUTI3] - Catégorie : Tiers ; dbField : PAYS_RESIDENCE_MONETAIRE
✅ Requête acceptée [QDUTI3] : Contrôle d'unicité du pays de résidence monétaire
DEBUG [QDUTI4] - Catégorie : Tiers ; dbField : ADR_BIEN_FINANCE
✅ Requête acceptée [QDUTI4] : Contrôle d'unicité de l'adresse complète
DEBUG [QDUTI5] - Catégorie : Tiers ; dbField : ADR_BIEN_NOM_RUE
✅ Requête acceptée [QDUTI5] : Contrôle d'unicité du nom de rue
DEBUG [QDUTI6] - Catégorie : Tiers ; dbField : ADR_BIEN_NO_RUE
✅ Requête acceptée [QDUTI6] : Contrôle d'unicité du numéro de rue
DEBUG [QDUTI7] - Catégorie : Tiers ; dbField : ADR_BIEN_CODE_POSTAL
✅ Requête acceptée [QDUTI7] : Contrôle d'unicité du code postal
DEBUG [QDUTI8] - Catégorie : Tiers ; dbField : ADR_BIEN_VILLE
✅ Requête acceptée [QDUTI8] : Contrôle d'unicité de la ville
DEBUG [QDUTR2] - Catégorie : Transaction ; dbField : TYPE_PROD
✅ Requête acceptée [QDUTR2] : Contrôle d'unicité du type de prod
DEBUG [QDUTR3] - Catégorie : Transaction ; dbField : DEVISE
✅ Requête acceptée [QDUTR3] : Contrôle d'unicité de la devise
DEBUG [QDUTR4] - Catégorie : Transaction ; dbField : PRODUIT
✅ Requête acceptée [QDUTR4] : Contrôle d'unicité du produit
DEBUG [QDUTR5] - Catégorie : Transaction ; dbField : MODE_AMORTISSEMENT
✅ Requête acceptée [QDUTR5] : Contrôle d'unicité du mode d'amortissement
DEBUG [QDUTR6] - Catégorie : Transaction ; dbField : NATURE_TAUX
✅ Requête acceptée [QDUTR6] : Contrôle d'unicité du type de taux
DEBUG [QDUTR7] - Catégorie : Transaction ; dbField : MONTANT_OPERATION
✅ Requête acceptée [QDUTR7] : Contrôle d'unicité du montant d'opération
DEBUG [QDUTR8] - Catégorie : Transaction ; dbField : ENCOURS_CERTIF_COMPTABLE
✅ Requête acceptée [QDUTR8] : Contrôle d'unicité de l'encours
DEBUG [QDUTR10] - Catégorie : Transaction ; dbField : TYPE_OPERATION
✅ Requête acceptée [QDUTR10] : Contrôle d'unicité du type d'opération
DEBUG [QDUTR11] - Catégorie : Transaction ; dbField : DUREE_TOTALE
✅ Requête acceptée [QDUTR11] : Contrôle d'unicité de la durée totale
DEBUG [QDUTR12] - Catégorie : Transaction ; dbField : DUREE_RESTANTE
✅ Requête acceptée [QDUTR12] : Contrôle d'unicité de la durée restante en mois
DEBUG [QDUTR13] - Catégorie : Transaction ; dbField : DUREE_DIFF_AMORT
✅ Requête acceptée [QDUTR13] : Contrôle d'unicité de la durée du différé
DEBUG [QDUTR14] - Catégorie : Transaction ; dbField : TYPE_BIEN
✅ Requête acceptée [QDUTR14] : Contrôle d'unicité du type de bien
DEBUG [QDUTR15] - Catégorie : Transaction ; dbField : TAUX_NOMINAL_ANN_BRUT
✅ Requête acceptée [QDUTR15] : Contrôle d'unicité du taux nom. annuel
DEBUG [QDUTR16] - Catégorie : Transaction ; dbField : TAUX_EFF_GLOBAL
✅ Requête acceptée [QDUTR16] : Contrôle d'unicité du taux eff. global
DEBUG [QDUTR17] - Catégorie : Transaction ; dbField : DATE_SAISIE_COND_FIN
✅ Requête acceptée [QDUTR17] : Contrôle d'unicité de changement cond. fin.
DEBUG [QDUTR18] - Catégorie : Transaction ; dbField : ADR_BIEN_FINANCE
✅ Requête acceptée [QDUTR18] : Contrôle d'unicité de l'adresse du bien
DEBUG [QDUTR19] - Catégorie : Transaction ; dbField : ADR_BIEN_NO_RUE
✅ Requête acceptée [QDUTR19] : Contrôle du numéro de rue du bien
DEBUG [QDUTR20] - Catégorie : Transaction ; dbField : ADR_BIEN_NOM_RUE
✅ Requête acceptée [QDUTR20] : Contrôle du nom de rue du bien
DEBUG [QDUTR21] - Catégorie : Transaction ; dbField : ADR_BIEN_CODE_POSTAL
✅ Requête acceptée [QDUTR21] : Contrôle du code postal du bien
DEBUG [QDUTR22] - Catégorie : Transaction ; dbField : ADR_BIEN_VILLE
✅ Requête acceptée [QDUTR22] : Contrôle de la ville du bien
DEBUG [QDUCO1] - Catégorie : Collateral ; dbField : COLLATERAL_GARANTIE
✅ Requête acceptée [QDUCO1] : Contrôle d'unicité du type de garantie
DEBUG [QDUCO2] - Catégorie : Collateral ; dbField : COLLATERAL_MT_DERNIERE_EVALUATION
✅ Requête acceptée [QDUCO2] : Contrôle d'unicité du montant de dern. éval.
DEBUG [QDUCO3] - Catégorie : Collateral ; dbField : COLLATERAL_DT_DERNIERE_EVALUATION
✅ Requête acceptée [QDUCO3] : Contrôle d'unicité de la date dern. éval.
DEBUG [QDUCO4] - Catégorie : Collateral ; dbField : ADR_COLLATERAL
✅ Requête acceptée [QDUCO4] : Contrôle d'unicité de l'adresse
DEBUG [QDUCO5] - Catégorie : Collateral ; dbField : COLLATERAL_NUM_RUE
✅ Requête acceptée [QDUCO5] : Contrôle d'unicité du n° rue
DEBUG [QDUCO6] - Catégorie : Collateral ; dbField : COLLATERAL_NOM_RUE
✅ Requête acceptée [QDUCO6] : Contrôle d'unicité du nom de rue
DEBUG [QDUCO7] - Catégorie : Collateral ; dbField : COLLATERAL_CP
✅ Requête acceptée [QDUCO7] : Contrôle d'unicité du CP
DEBUG [QDUCO8] - Catégorie : Collateral ; dbField : COLLATERAL_VILLE
✅ Requête acceptée [QDUCO8] : Contrôle d'unicité de la ville
DEBUG [QDUES1] - Catégorie : ESG ; dbField : DPE_ETIQUETTE_ENERGIE
✅ Requête acceptée [QDUES1] : Contrôle d'unicité de l'étiquette DPE
DEBUG [QDUES2] - Catégorie : ESG ; dbField : DPE_CONSO_ENERGIE_PRIMAIRE
✅ Requête acceptée [QDUES2] : Contrôle d'unicité de la conso. énergie
DEBUG [QDUES3] - Catégorie : ESG ; dbField : DPE_EMISSION_GAZ
✅ Requête acceptée [QDUES3] : Contrôle d'unicité de l'émission GES'
DEBUG [QDUES4] - Catégorie : ESG ; dbField : DPE_DATE_REALISATION
✅ Requête acceptée [QDUES4] : Contrôle d'unicité de date de réalisation DPE
Total check : 54
Nb records : 50000 pour numchargement = 7
Query SELECT ID_PRET FROM T_DONNEES_CLIENT_FAITY WHERE NUM_CHARGEMENT = :num AND (ID_TIERS_PRINCP IS NULL OR TRIM(ID_TIERS_PRINCP) = '') <br/>
Num Chargement : 7
Progress : current check : 1 , totalChecks : 54 , Pourcent : 1
NbErreursAgrégées Tiers : 270 / 50000 
controle : Erreur ; L'identifiant du tiers principal doit être renseigné
Query SELECT ID_PRET FROM T_DONNEES_CLIENT_FAITY WHERE NUM_CHARGEMENT = :num AND (TYPE_PERSONNE IS NULL OR TRIM(TYPE_PERSONNE) = '') <br/>
Num Chargement : 7
Progress : current check : 2 , totalChecks : 54 , Pourcent : 3
NbErreursAgrégées Tiers : 2500 / 50000 
controle : Erreur ; Le type de personne doit être renseigné
Query SELECT ID_PRET FROM T_DONNEES_CLIENT_FAITY WHERE NUM_CHARGEMENT = :num AND (ADRESSE_COMPLETE IS NULL OR TRIM(ADRESSE_COMPLETE) = '') <br/>
Num Chargement : 7
Progress : current check : 3 , totalChecks : 54 , Pourcent : 5
NbErreursAgrégées Tiers : 0 / 50000 
controle : Erreur ; L'adresse complète du client doit être renseignée
Query CPL010 SELECT ID_PRET FROM T_DONNEES_CLIENT_FAITY WHERE NUM_CHARGEMENT = :num AND (ADR_BIEN_FINANCE IS NULL OR TRIM(ADR_BIEN_FINANCE) = '') <br/>
Query après exécution CPL010 SELECT ID_PRET FROM T_DONNEES_CLIENT_FAITY WHERE NUM_CHARGEMENT = :num AND (ADR_BIEN_FINANCE IS NULL OR TRIM(ADR_BIEN_FINANCE) = '') <br/>
Progress : current check : 4 , totalChecks : 54 , Pourcent : 7
Progress : current check : 4 , totalChecks : 54 , Pourcent : 7
NbErreursAgrégées Transaction : 0 / 50000 
NbErreursAgrégées 3 <br/>
Query CPL011 SELECT ID_PRET FROM T_DONNEES_CLIENT_FAITY WHERE NUM_CHARGEMENT = :num AND (ADR_BIEN_NO_RUE IS NULL OR TRIM(ADR_BIEN_NO_RUE) = '') <br/>
Query après exécution CPL011 SELECT ID_PRET FROM T_DONNEES_CLIENT_FAITY WHERE NUM_CHARGEMENT = :num AND (ADR_BIEN_NO_RUE IS NULL OR TRIM(ADR_BIEN_NO_RUE) = '') <br/>
Progress : current check : 5 , totalChecks : 54 , Pourcent : 9
Progress : current check : 5 , totalChecks : 54 , Pourcent : 9
NbErreursAgrégées Transaction : 50000 / 50000 
NbErreursAgrégées 3 <br/>
Query CPL012 SELECT ID_PRET FROM T_DONNEES_CLIENT_FAITY WHERE NUM_CHARGEMENT = :num AND (ADR_BIEN_NOM_RUE IS NULL OR TRIM(ADR_BIEN_NOM_RUE) = '') <br/>
Query après exécution CPL012 SELECT ID_PRET FROM T_DONNEES_CLIENT_FAITY WHERE NUM_CHARGEMENT = :num AND (ADR_BIEN_NOM_RUE IS NULL OR TRIM(ADR_BIEN_NOM_RUE) = '') <br/>
Progress : current check : 6 , totalChecks : 54 , Pourcent : 11
Progress : current check : 6 , totalChecks : 54 , Pourcent : 11
NbErreursAgrégées Transaction : 50000 / 50000 
NbErreursAgrégées 3 <br/>
Query CPL013 SELECT ID_PRET FROM T_DONNEES_CLIENT_FAITY WHERE NUM_CHARGEMENT = :num AND (ADR_BIEN_CODE_POSTAL IS NULL OR TRIM(ADR_BIEN_CODE_POSTAL) = '') <br/>
Query après exécution CPL013 SELECT ID_PRET FROM T_DONNEES_CLIENT_FAITY WHERE NUM_CHARGEMENT = :num AND (ADR_BIEN_CODE_POSTAL IS NULL OR TRIM(ADR_BIEN_CODE_POSTAL) = '') <br/>
Progress : current check : 7 , totalChecks : 54 , Pourcent : 12
Progress : current check : 7 , totalChecks : 54 , Pourcent : 12
NbErreursAgrégées Transaction : 0 / 50000 
NbErreursAgrégées 3 <br/>
Query CPL014 SELECT ID_PRET FROM T_DONNEES_CLIENT_FAITY WHERE NUM_CHARGEMENT = :num AND (ADR_BIEN_VILLE IS NULL OR TRIM(ADR_BIEN_VILLE) = '') <br/>
Query après exécution CPL014 SELECT ID_PRET FROM T_DONNEES_CLIENT_FAITY WHERE NUM_CHARGEMENT = :num AND (ADR_BIEN_VILLE IS NULL OR TRIM(ADR_BIEN_VILLE) = '') <br/>
Progress : current check : 8 , totalChecks : 54 , Pourcent : 14
Progress : current check : 8 , totalChecks : 54 , Pourcent : 14
NbErreursAgrégées Transaction : 0 / 50000 
NbErreursAgrégées 3 <br/>
Query CPL015 SELECT ID_PRET FROM T_DONNEES_CLIENT_FAITY WHERE NUM_CHARGEMENT = :num AND (ADR_BIEN_PAYS IS NULL OR TRIM(ADR_BIEN_PAYS) = '') <br/>
Query après exécution CPL015 SELECT ID_PRET FROM T_DONNEES_CLIENT_FAITY WHERE NUM_CHARGEMENT = :num AND (ADR_BIEN_PAYS IS NULL OR TRIM(ADR_BIEN_PAYS) = '') <br/>
Progress : current check : 9 , totalChecks : 54 , Pourcent : 16
Progress : current check : 9 , totalChecks : 54 , Pourcent : 16
NbErreursAgrégées Transaction : 50000 / 50000 
NbErreursAgrégées 3 <br/>
collateral array 4
Query SELECT ID_PRET FROM T_DONNEES_CLIENT_FAITY WHERE NUM_CHARGEMENT = :num AND (ADR_COLLATERAL IS NULL OR TRIM(ADR_COLLATERAL) = '') <br/>
Query après exécution CPL041 SELECT ID_PRET FROM T_DONNEES_CLIENT_FAITY WHERE NUM_CHARGEMENT = :num AND (ADR_COLLATERAL IS NULL OR TRIM(ADR_COLLATERAL) = '') <br/>
Progress : current check : 10 , totalChecks : 54 , Pourcent : 18
Progress : current check : 10 , totalChecks : 54 , Pourcent : 18
NbErreursAgrégées Collat : 50000 / 50000 
NbErreursAgrégées 50000 <br/>
Query SELECT ID_PRET FROM T_DONNEES_CLIENT_FAITY WHERE NUM_CHARGEMENT = :num AND (COLLATERAL_CP IS NULL OR TRIM(COLLATERAL_CP) = '') <br/>
Query après exécution CPL044 SELECT ID_PRET FROM T_DONNEES_CLIENT_FAITY WHERE NUM_CHARGEMENT = :num AND (COLLATERAL_CP IS NULL OR TRIM(COLLATERAL_CP) = '') <br/>
Progress : current check : 11 , totalChecks : 54 , Pourcent : 20
Progress : current check : 11 , totalChecks : 54 , Pourcent : 20
NbErreursAgrégées Collat : 50000 / 50000 
NbErreursAgrégées 50000 <br/>
Query SELECT ID_PRET FROM T_DONNEES_CLIENT_FAITY WHERE NUM_CHARGEMENT = :num AND (COLLATERAL_GARANTIE IS NULL OR TRIM(COLLATERAL_GARANTIE) = '') <br/>
Query après exécution CPL047 SELECT ID_PRET FROM T_DONNEES_CLIENT_FAITY WHERE NUM_CHARGEMENT = :num AND (COLLATERAL_GARANTIE IS NULL OR TRIM(COLLATERAL_GARANTIE) = '') <br/>
Progress : current check : 12 , totalChecks : 54 , Pourcent : 22
Progress : current check : 12 , totalChecks : 54 , Pourcent : 22
NbErreursAgrégées Collat : 50000 / 50000 
NbErreursAgrégées 50000 <br/>
Query SELECT ID_PRET FROM T_DONNEES_CLIENT_FAITY WHERE NUM_CHARGEMENT = :num AND (COLLATERAL_TOTAL IS NULL OR TRIM(COLLATERAL_TOTAL) = '') <br/>
Query après exécution CPL057 SELECT ID_PRET FROM T_DONNEES_CLIENT_FAITY WHERE NUM_CHARGEMENT = :num AND (COLLATERAL_TOTAL IS NULL OR TRIM(COLLATERAL_TOTAL) = '') <br/>
Progress : current check : 13 , totalChecks : 54 , Pourcent : 24
Progress : current check : 13 , totalChecks : 54 , Pourcent : 24
NbErreursAgrégées Collat : 50000 / 50000 
NbErreursAgrégées 50000 <br/>
Query SELECT ID_PRET FROM T_DONNEES_CLIENT_FAITY WHERE NUM_CHARGEMENT = :num AND (DPE_ETIQUETTE_ENERGIE IS NULL OR TRIM(DPE_ETIQUETTE_ENERGIE) = '') <br/>
Progress : current check : 14 , totalChecks : 54 , Pourcent : 25
NbErreursAgrégées ESG : 0 / 50000 
NbErreursAgrégées 1 <br/>
Nb tiers distincts: 49511
QDU Queries
Tiers QDU Query : {"qduCode":"QDUTI1","nomControle":"Contr\u00f4le d'unicit\u00e9 du type de personne","niveau":"Erreur","type":"Contr\u00f4le d'unicit\u00e9 du type de personne","regle":"Un tiers client ne peut avoir plus de 2 'types de personnes' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_TIERS_PRINCP AS ID_LIGNE,\r\n                    COUNT(DISTINCT TYPE_PERSONNE) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(TYPE_PERSONNE = '', 'vide', TYPE_PERSONNE) ORDER BY TYPE_PERSONNE SEPARATOR ', ') AS LISTE_ERREURS,\r\n                    ENCOURS_CERTIF_COMPTABLE\r\n                FROM (\r\n                    SELECT\r\n                        ID_TIERS_PRINCP,\r\n                        TYPE_PERSONNE,\r\n                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE\r\n                    FROM T_DONNEES_CLIENT_FAITY\r\n                    WHERE NUM_CHARGEMENT = :num\r\n                    GROUP BY ID_TIERS_PRINCP, TYPE_PERSONNE\r\n                ) PERIMETRE\r\n                WHERE \r\n                    TYPE_PERSONNE IS NOT NULL\r\n                    AND ID_TIERS_PRINCP IS NOT NULL \r\n                    AND ID_TIERS_PRINCP <> '' \r\n                GROUP BY ID_TIERS_PRINCP \r\n                HAVING COUNT(DISTINCT TYPE_PERSONNE) > 1\r\n                ORDER BY ID_TIERS_PRINCP\r\n            ","objet":"Tiers","obligatoire":"1","dbField":"TYPE_PERSONNE"}
Query 
                SELECT
                    ID_TIERS_PRINCP AS ID_LIGNE,
                    COUNT(DISTINCT TYPE_PERSONNE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(TYPE_PERSONNE = '', 'vide', TYPE_PERSONNE) ORDER BY TYPE_PERSONNE SEPARATOR ', ') AS LISTE_ERREURS,
                    ENCOURS_CERTIF_COMPTABLE
                FROM (
                    SELECT
                        ID_TIERS_PRINCP,
                        TYPE_PERSONNE,
                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE
                    FROM T_DONNEES_CLIENT_FAITY
                    WHERE NUM_CHARGEMENT = :num
                    GROUP BY ID_TIERS_PRINCP, TYPE_PERSONNE
                ) PERIMETRE
                WHERE 
                    TYPE_PERSONNE IS NOT NULL
                    AND ID_TIERS_PRINCP IS NOT NULL 
                    AND ID_TIERS_PRINCP <> '' 
                GROUP BY ID_TIERS_PRINCP 
                HAVING COUNT(DISTINCT TYPE_PERSONNE) > 1
                ORDER BY ID_TIERS_PRINCP
             <br/>
Progress : current check : 15 , totalChecks : 54 , Pourcent : 27
NbErreursAgrégées : 5 / 50000 
NbErreursAgrégées 1 <br/>
Tiers QDU Query : {"qduCode":"QDUTI2","nomControle":"Contr\u00f4le d'unicit\u00e9 du pays de r\u00e9sidence fiscale","niveau":"Erreur critique","type":"Contr\u00f4le d'unicit\u00e9 du pays de r\u00e9sidence fiscale","regle":"Un tiers client ne peut avoir plus de 2 'pays de r\u00e9sidence fiscale' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_TIERS_PRINCP AS ID_LIGNE,\r\n                    COUNT(DISTINCT PAYS_RESIDENCE_FISCALE) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(PAYS_RESIDENCE_FISCALE = '', 'vide', PAYS_RESIDENCE_FISCALE) ORDER BY PAYS_RESIDENCE_FISCALE SEPARATOR ', ') AS LISTE_ERREURS,\r\n                    ENCOURS_CERTIF_COMPTABLE\r\n                FROM (\r\n                    SELECT\r\n                        ID_TIERS_PRINCP,\r\n                        PAYS_RESIDENCE_FISCALE,\r\n                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE\r\n                    FROM T_DONNEES_CLIENT_FAITY\r\n                    WHERE NUM_CHARGEMENT = :num\r\n                    GROUP BY ID_TIERS_PRINCP, PAYS_RESIDENCE_FISCALE\r\n                ) PERIMETRE\r\n                WHERE \r\n                    PAYS_RESIDENCE_FISCALE IS NOT NULL\r\n                    AND ID_TIERS_PRINCP IS NOT NULL \r\n                    AND ID_TIERS_PRINCP <> '' \r\n                GROUP BY ID_TIERS_PRINCP \r\n                HAVING COUNT(DISTINCT PAYS_RESIDENCE_FISCALE) > 1\r\n                ORDER BY ID_TIERS_PRINCP\r\n            ","objet":"Tiers","obligatoire":"1","dbField":"PAYS_RESIDENCE_FISCALE"}
Query 
                SELECT
                    ID_TIERS_PRINCP AS ID_LIGNE,
                    COUNT(DISTINCT PAYS_RESIDENCE_FISCALE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(PAYS_RESIDENCE_FISCALE = '', 'vide', PAYS_RESIDENCE_FISCALE) ORDER BY PAYS_RESIDENCE_FISCALE SEPARATOR ', ') AS LISTE_ERREURS,
                    ENCOURS_CERTIF_COMPTABLE
                FROM (
                    SELECT
                        ID_TIERS_PRINCP,
                        PAYS_RESIDENCE_FISCALE,
                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE
                    FROM T_DONNEES_CLIENT_FAITY
                    WHERE NUM_CHARGEMENT = :num
                    GROUP BY ID_TIERS_PRINCP, PAYS_RESIDENCE_FISCALE
                ) PERIMETRE
                WHERE 
                    PAYS_RESIDENCE_FISCALE IS NOT NULL
                    AND ID_TIERS_PRINCP IS NOT NULL 
                    AND ID_TIERS_PRINCP <> '' 
                GROUP BY ID_TIERS_PRINCP 
                HAVING COUNT(DISTINCT PAYS_RESIDENCE_FISCALE) > 1
                ORDER BY ID_TIERS_PRINCP
             <br/>
Progress : current check : 16 , totalChecks : 54 , Pourcent : 29
NbErreursAgrégées : 0 / 50000 
NbErreursAgrégées 1 <br/>
Tiers QDU Query : {"qduCode":"QDUTI3","nomControle":"Contr\u00f4le d'unicit\u00e9 du pays de r\u00e9sidence mon\u00e9taire","niveau":"Erreur critique","type":"Contr\u00f4le d'unicit\u00e9 du pays de r\u00e9sidence mon\u00e9taire","regle":"Validation fonctionnelle","sqlQuery":"\r\n                SELECT\r\n                    ID_TIERS_PRINCP AS ID_LIGNE,\r\n                    COUNT(DISTINCT PAYS_RESIDENCE_MONETAIRE) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(PAYS_RESIDENCE_MONETAIRE = '', 'vide', PAYS_RESIDENCE_MONETAIRE) ORDER BY PAYS_RESIDENCE_MONETAIRE SEPARATOR ', ') AS LISTE_ERREURS,\r\n                    ENCOURS_CERTIF_COMPTABLE\r\n                FROM (\r\n                    SELECT\r\n                        ID_TIERS_PRINCP,\r\n                        PAYS_RESIDENCE_MONETAIRE,\r\n                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE\r\n                    FROM T_DONNEES_CLIENT_FAITY\r\n                    WHERE NUM_CHARGEMENT = :num\r\n                    GROUP BY ID_TIERS_PRINCP, PAYS_RESIDENCE_MONETAIRE\r\n                ) PERIMETRE\r\n                WHERE \r\n                    PAYS_RESIDENCE_MONETAIRE IS NOT NULL\r\n                    AND ID_TIERS_PRINCP IS NOT NULL \r\n                    AND ID_TIERS_PRINCP <> '' \r\n                GROUP BY ID_TIERS_PRINCP \r\n                HAVING COUNT(DISTINCT PAYS_RESIDENCE_MONETAIRE) > 1\r\n                ORDER BY ID_TIERS_PRINCP\r\n            ","objet":"Tiers","obligatoire":"1","dbField":"PAYS_RESIDENCE_MONETAIRE"}
Query 
                SELECT
                    ID_TIERS_PRINCP AS ID_LIGNE,
                    COUNT(DISTINCT PAYS_RESIDENCE_MONETAIRE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(PAYS_RESIDENCE_MONETAIRE = '', 'vide', PAYS_RESIDENCE_MONETAIRE) ORDER BY PAYS_RESIDENCE_MONETAIRE SEPARATOR ', ') AS LISTE_ERREURS,
                    ENCOURS_CERTIF_COMPTABLE
                FROM (
                    SELECT
                        ID_TIERS_PRINCP,
                        PAYS_RESIDENCE_MONETAIRE,
                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE
                    FROM T_DONNEES_CLIENT_FAITY
                    WHERE NUM_CHARGEMENT = :num
                    GROUP BY ID_TIERS_PRINCP, PAYS_RESIDENCE_MONETAIRE
                ) PERIMETRE
                WHERE 
                    PAYS_RESIDENCE_MONETAIRE IS NOT NULL
                    AND ID_TIERS_PRINCP IS NOT NULL 
                    AND ID_TIERS_PRINCP <> '' 
                GROUP BY ID_TIERS_PRINCP 
                HAVING COUNT(DISTINCT PAYS_RESIDENCE_MONETAIRE) > 1
                ORDER BY ID_TIERS_PRINCP
             <br/>
Progress : current check : 17 , totalChecks : 54 , Pourcent : 31
NbErreursAgrégées : 0 / 50000 
NbErreursAgrégées 1 <br/>
Tiers QDU Query : {"qduCode":"QDUTI4","nomControle":"Contr\u00f4le d'unicit\u00e9 de l'adresse compl\u00e8te","niveau":"Erreur critique","type":"Contr\u00f4le d'unicit\u00e9 de l'adresse compl\u00e8te","regle":"Un tiers client ne peut avoir plus de 2 'adresse compl\u00e8te' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_TIERS_PRINCP AS ID_LIGNE,\r\n                    COUNT(DISTINCT ADR_BIEN_FINANCE) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(ADR_BIEN_FINANCE = '', 'vide', ADR_BIEN_FINANCE) ORDER BY ADR_BIEN_FINANCE SEPARATOR ', ') AS LISTE_ERREURS,\r\n                    ENCOURS_CERTIF_COMPTABLE\r\n                FROM (\r\n                    SELECT\r\n                        ID_TIERS_PRINCP,\r\n                        ADR_BIEN_FINANCE,\r\n                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE\r\n                    FROM T_DONNEES_CLIENT_FAITY\r\n                    WHERE NUM_CHARGEMENT = :num\r\n                    GROUP BY ID_TIERS_PRINCP, ADR_BIEN_FINANCE\r\n                ) PERIMETRE\r\n                WHERE \r\n                    ADR_BIEN_FINANCE IS NOT NULL\r\n                    AND ID_TIERS_PRINCP IS NOT NULL \r\n                    AND ID_TIERS_PRINCP <> '' \r\n                GROUP BY ID_TIERS_PRINCP \r\n                HAVING COUNT(DISTINCT ADR_BIEN_FINANCE) > 1\r\n                ORDER BY ID_TIERS_PRINCP\r\n            ","objet":"Tiers","obligatoire":"1","dbField":"ADR_BIEN_FINANCE"}
Query 
                SELECT
                    ID_TIERS_PRINCP AS ID_LIGNE,
                    COUNT(DISTINCT ADR_BIEN_FINANCE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(ADR_BIEN_FINANCE = '', 'vide', ADR_BIEN_FINANCE) ORDER BY ADR_BIEN_FINANCE SEPARATOR ', ') AS LISTE_ERREURS,
                    ENCOURS_CERTIF_COMPTABLE
                FROM (
                    SELECT
                        ID_TIERS_PRINCP,
                        ADR_BIEN_FINANCE,
                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE
                    FROM T_DONNEES_CLIENT_FAITY
                    WHERE NUM_CHARGEMENT = :num
                    GROUP BY ID_TIERS_PRINCP, ADR_BIEN_FINANCE
                ) PERIMETRE
                WHERE 
                    ADR_BIEN_FINANCE IS NOT NULL
                    AND ID_TIERS_PRINCP IS NOT NULL 
                    AND ID_TIERS_PRINCP <> '' 
                GROUP BY ID_TIERS_PRINCP 
                HAVING COUNT(DISTINCT ADR_BIEN_FINANCE) > 1
                ORDER BY ID_TIERS_PRINCP
             <br/>
Progress : current check : 18 , totalChecks : 54 , Pourcent : 33
NbErreursAgrégées : 5 / 50000 
NbErreursAgrégées 1 <br/>
Tiers QDU Query : {"qduCode":"QDUTI5","nomControle":"Contr\u00f4le d'unicit\u00e9 du nom de rue","niveau":"Erreur critique","type":"Contr\u00f4le d'unicit\u00e9 du nom de rue","regle":"Un tiers client ne peut avoir plus de 2 'nom de rue' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_TIERS_PRINCP AS ID_LIGNE,\r\n                    COUNT(DISTINCT ADR_BIEN_NOM_RUE) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(ADR_BIEN_NOM_RUE = '', 'vide', ADR_BIEN_NOM_RUE) ORDER BY ADR_BIEN_NOM_RUE SEPARATOR ', ') AS LISTE_ERREURS,\r\n                    ENCOURS_CERTIF_COMPTABLE\r\n                FROM (\r\n                    SELECT\r\n                        ID_TIERS_PRINCP,\r\n                        ADR_BIEN_NOM_RUE,\r\n                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE\r\n                    FROM T_DONNEES_CLIENT_FAITY\r\n                    WHERE NUM_CHARGEMENT = :num\r\n                    GROUP BY ID_TIERS_PRINCP, ADR_BIEN_NOM_RUE\r\n                ) PERIMETRE\r\n                WHERE \r\n                    ADR_BIEN_NOM_RUE IS NOT NULL\r\n                    AND ID_TIERS_PRINCP IS NOT NULL \r\n                    AND ID_TIERS_PRINCP <> '' \r\n                GROUP BY ID_TIERS_PRINCP \r\n                HAVING COUNT(DISTINCT ADR_BIEN_NOM_RUE) > 1\r\n                ORDER BY ID_TIERS_PRINCP\r\n            ","objet":"Tiers","obligatoire":"1","dbField":"ADR_BIEN_NOM_RUE"}
Query 
                SELECT
                    ID_TIERS_PRINCP AS ID_LIGNE,
                    COUNT(DISTINCT ADR_BIEN_NOM_RUE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(ADR_BIEN_NOM_RUE = '', 'vide', ADR_BIEN_NOM_RUE) ORDER BY ADR_BIEN_NOM_RUE SEPARATOR ', ') AS LISTE_ERREURS,
                    ENCOURS_CERTIF_COMPTABLE
                FROM (
                    SELECT
                        ID_TIERS_PRINCP,
                        ADR_BIEN_NOM_RUE,
                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE
                    FROM T_DONNEES_CLIENT_FAITY
                    WHERE NUM_CHARGEMENT = :num
                    GROUP BY ID_TIERS_PRINCP, ADR_BIEN_NOM_RUE
                ) PERIMETRE
                WHERE 
                    ADR_BIEN_NOM_RUE IS NOT NULL
                    AND ID_TIERS_PRINCP IS NOT NULL 
                    AND ID_TIERS_PRINCP <> '' 
                GROUP BY ID_TIERS_PRINCP 
                HAVING COUNT(DISTINCT ADR_BIEN_NOM_RUE) > 1
                ORDER BY ID_TIERS_PRINCP
             <br/>
Progress : current check : 19 , totalChecks : 54 , Pourcent : 35
NbErreursAgrégées : 0 / 50000 
NbErreursAgrégées 1 <br/>
Tiers QDU Query : {"qduCode":"QDUTI6","nomControle":"Contr\u00f4le d'unicit\u00e9 du num\u00e9ro de rue","niveau":"Erreur critique","type":"Contr\u00f4le d'unicit\u00e9 du num\u00e9ro de rue","regle":"Un tiers client ne peut avoir plus de 2 'num\u00e9ro de rue' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_TIERS_PRINCP AS ID_LIGNE,\r\n                    COUNT(DISTINCT ADR_BIEN_NO_RUE) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(ADR_BIEN_NO_RUE = '', 'vide', ADR_BIEN_NO_RUE) ORDER BY ADR_BIEN_NO_RUE SEPARATOR ', ') AS LISTE_ERREURS,\r\n                    ENCOURS_CERTIF_COMPTABLE\r\n                FROM (\r\n                    SELECT\r\n                        ID_TIERS_PRINCP,\r\n                        ADR_BIEN_NO_RUE,\r\n                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE\r\n                    FROM T_DONNEES_CLIENT_FAITY\r\n                    WHERE NUM_CHARGEMENT = :num\r\n                    GROUP BY ID_TIERS_PRINCP, ADR_BIEN_NO_RUE\r\n                ) PERIMETRE\r\n                WHERE \r\n                    ADR_BIEN_NO_RUE IS NOT NULL\r\n                    AND ID_TIERS_PRINCP IS NOT NULL \r\n                    AND ID_TIERS_PRINCP <> '' \r\n                GROUP BY ID_TIERS_PRINCP \r\n                HAVING COUNT(DISTINCT ADR_BIEN_NO_RUE) > 1\r\n                ORDER BY ID_TIERS_PRINCP\r\n            ","objet":"Tiers","obligatoire":"1","dbField":"ADR_BIEN_NO_RUE"}
Query 
                SELECT
                    ID_TIERS_PRINCP AS ID_LIGNE,
                    COUNT(DISTINCT ADR_BIEN_NO_RUE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(ADR_BIEN_NO_RUE = '', 'vide', ADR_BIEN_NO_RUE) ORDER BY ADR_BIEN_NO_RUE SEPARATOR ', ') AS LISTE_ERREURS,
                    ENCOURS_CERTIF_COMPTABLE
                FROM (
                    SELECT
                        ID_TIERS_PRINCP,
                        ADR_BIEN_NO_RUE,
                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE
                    FROM T_DONNEES_CLIENT_FAITY
                    WHERE NUM_CHARGEMENT = :num
                    GROUP BY ID_TIERS_PRINCP, ADR_BIEN_NO_RUE
                ) PERIMETRE
                WHERE 
                    ADR_BIEN_NO_RUE IS NOT NULL
                    AND ID_TIERS_PRINCP IS NOT NULL 
                    AND ID_TIERS_PRINCP <> '' 
                GROUP BY ID_TIERS_PRINCP 
                HAVING COUNT(DISTINCT ADR_BIEN_NO_RUE) > 1
                ORDER BY ID_TIERS_PRINCP
             <br/>
Progress : current check : 20 , totalChecks : 54 , Pourcent : 37
NbErreursAgrégées : 0 / 50000 
NbErreursAgrégées 1 <br/>
Tiers QDU Query : {"qduCode":"QDUTI7","nomControle":"Contr\u00f4le d'unicit\u00e9 du code postal","niveau":"Erreur critique","type":"Contr\u00f4le d'unicit\u00e9 du code postal","regle":"Un tiers client ne peut avoir plus de 2 'code postal' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_TIERS_PRINCP AS ID_LIGNE,\r\n                    COUNT(DISTINCT ADR_BIEN_CODE_POSTAL) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(ADR_BIEN_CODE_POSTAL = '', 'vide', ADR_BIEN_CODE_POSTAL) ORDER BY ADR_BIEN_CODE_POSTAL SEPARATOR ', ') AS LISTE_ERREURS,\r\n                    ENCOURS_CERTIF_COMPTABLE\r\n                FROM (\r\n                    SELECT\r\n                        ID_TIERS_PRINCP,\r\n                        ADR_BIEN_CODE_POSTAL,\r\n                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE\r\n                    FROM T_DONNEES_CLIENT_FAITY\r\n                    WHERE NUM_CHARGEMENT = :num\r\n                    GROUP BY ID_TIERS_PRINCP, ADR_BIEN_CODE_POSTAL\r\n                ) PERIMETRE\r\n                WHERE \r\n                    ADR_BIEN_CODE_POSTAL IS NOT NULL\r\n                    AND ID_TIERS_PRINCP IS NOT NULL \r\n                    AND ID_TIERS_PRINCP <> '' \r\n                GROUP BY ID_TIERS_PRINCP \r\n                HAVING COUNT(DISTINCT ADR_BIEN_CODE_POSTAL) > 1\r\n                ORDER BY ID_TIERS_PRINCP\r\n            ","objet":"Tiers","obligatoire":"1","dbField":"ADR_BIEN_CODE_POSTAL"}
Query 
                SELECT
                    ID_TIERS_PRINCP AS ID_LIGNE,
                    COUNT(DISTINCT ADR_BIEN_CODE_POSTAL) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(ADR_BIEN_CODE_POSTAL = '', 'vide', ADR_BIEN_CODE_POSTAL) ORDER BY ADR_BIEN_CODE_POSTAL SEPARATOR ', ') AS LISTE_ERREURS,
                    ENCOURS_CERTIF_COMPTABLE
                FROM (
                    SELECT
                        ID_TIERS_PRINCP,
                        ADR_BIEN_CODE_POSTAL,
                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE
                    FROM T_DONNEES_CLIENT_FAITY
                    WHERE NUM_CHARGEMENT = :num
                    GROUP BY ID_TIERS_PRINCP, ADR_BIEN_CODE_POSTAL
                ) PERIMETRE
                WHERE 
                    ADR_BIEN_CODE_POSTAL IS NOT NULL
                    AND ID_TIERS_PRINCP IS NOT NULL 
                    AND ID_TIERS_PRINCP <> '' 
                GROUP BY ID_TIERS_PRINCP 
                HAVING COUNT(DISTINCT ADR_BIEN_CODE_POSTAL) > 1
                ORDER BY ID_TIERS_PRINCP
             <br/>
Progress : current check : 21 , totalChecks : 54 , Pourcent : 38
NbErreursAgrégées : 5 / 50000 
NbErreursAgrégées 1 <br/>
Tiers QDU Query : {"qduCode":"QDUTI8","nomControle":"Contr\u00f4le d'unicit\u00e9 de la ville","niveau":"Erreur critique","type":"Contr\u00f4le d'unicit\u00e9 de la ville","regle":"Un tiers client ne peut avoir plus de 2 'ville' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_TIERS_PRINCP AS ID_LIGNE,\r\n                    COUNT(DISTINCT ADR_BIEN_VILLE) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(ADR_BIEN_VILLE = '', 'vide', ADR_BIEN_VILLE) ORDER BY ADR_BIEN_VILLE SEPARATOR ', ') AS LISTE_ERREURS,\r\n                    ENCOURS_CERTIF_COMPTABLE\r\n                FROM (\r\n                    SELECT\r\n                        ID_TIERS_PRINCP,\r\n                        ADR_BIEN_VILLE,\r\n                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE\r\n                    FROM T_DONNEES_CLIENT_FAITY\r\n                    WHERE NUM_CHARGEMENT = :num\r\n                    GROUP BY ID_TIERS_PRINCP, ADR_BIEN_VILLE\r\n                ) PERIMETRE\r\n                WHERE \r\n                    ADR_BIEN_VILLE IS NOT NULL\r\n                    AND ID_TIERS_PRINCP IS NOT NULL \r\n                    AND ID_TIERS_PRINCP <> '' \r\n                GROUP BY ID_TIERS_PRINCP \r\n                HAVING COUNT(DISTINCT ADR_BIEN_VILLE) > 1\r\n                ORDER BY ID_TIERS_PRINCP\r\n            ","objet":"Tiers","obligatoire":"1","dbField":"ADR_BIEN_VILLE"}
Query 
                SELECT
                    ID_TIERS_PRINCP AS ID_LIGNE,
                    COUNT(DISTINCT ADR_BIEN_VILLE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(ADR_BIEN_VILLE = '', 'vide', ADR_BIEN_VILLE) ORDER BY ADR_BIEN_VILLE SEPARATOR ', ') AS LISTE_ERREURS,
                    ENCOURS_CERTIF_COMPTABLE
                FROM (
                    SELECT
                        ID_TIERS_PRINCP,
                        ADR_BIEN_VILLE,
                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE
                    FROM T_DONNEES_CLIENT_FAITY
                    WHERE NUM_CHARGEMENT = :num
                    GROUP BY ID_TIERS_PRINCP, ADR_BIEN_VILLE
                ) PERIMETRE
                WHERE 
                    ADR_BIEN_VILLE IS NOT NULL
                    AND ID_TIERS_PRINCP IS NOT NULL 
                    AND ID_TIERS_PRINCP <> '' 
                GROUP BY ID_TIERS_PRINCP 
                HAVING COUNT(DISTINCT ADR_BIEN_VILLE) > 1
                ORDER BY ID_TIERS_PRINCP
             <br/>
Progress : current check : 22 , totalChecks : 54 , Pourcent : 40
NbErreursAgrégées : 5 / 50000 
NbErreursAgrégées 1 <br/>
Nb pret distincts: 46174
Transaction QDU Query : {"qduCode":"QDUTR2","nomControle":"Contr\u00f4le d'unicit\u00e9 du type de prod","niveau":"Erreur","type":"Contr\u00f4le d'unicit\u00e9 du type de prod","regle":"Une transaction ne peut avoir plus de 2 'type de prod' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_PRET AS ID_LIGNE,\r\n                    COUNT(DISTINCT TYPE_PROD) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(TYPE_PROD = '', 'vide', TYPE_PROD) ORDER BY TYPE_PROD SEPARATOR ', ') AS LISTE_ERREURS\r\n                FROM T_DONNEES_CLIENT_FAITY\r\n                WHERE NUM_CHARGEMENT = :num\r\n                GROUP BY ID_PRET\r\n                HAVING COUNT(DISTINCT TYPE_PROD) > 1\r\n                ORDER BY ID_PRET\r\n            ","objet":"Transaction","obligatoire":"1","dbField":"TYPE_PROD"}
Query 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT TYPE_PROD) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(TYPE_PROD = '', 'vide', TYPE_PROD) ORDER BY TYPE_PROD SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT TYPE_PROD) > 1
                ORDER BY ID_PRET
             <br/>
Progress : current check : 23 , totalChecks : 54 , Pourcent : 42
NbErreursAgrégées : 0 / 50000 
NbErreursAgrégées 1 <br/>
Transaction QDU Query : {"qduCode":"QDUTR3","nomControle":"Contr\u00f4le d'unicit\u00e9 de la devise","niveau":"Erreur","type":"Contr\u00f4le d'unicit\u00e9 de la devise","regle":"Une transaction ne peut avoir plus de 2 'devise' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_PRET AS ID_LIGNE,\r\n                    COUNT(DISTINCT DEVISE) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(DEVISE = '', 'vide', DEVISE) ORDER BY DEVISE SEPARATOR ', ') AS LISTE_ERREURS\r\n                FROM T_DONNEES_CLIENT_FAITY\r\n                WHERE NUM_CHARGEMENT = :num\r\n                GROUP BY ID_PRET\r\n                HAVING COUNT(DISTINCT DEVISE) > 1\r\n                ORDER BY ID_PRET\r\n            ","objet":"Transaction","obligatoire":"1","dbField":"DEVISE"}
Query 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT DEVISE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(DEVISE = '', 'vide', DEVISE) ORDER BY DEVISE SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT DEVISE) > 1
                ORDER BY ID_PRET
             <br/>
Progress : current check : 24 , totalChecks : 54 , Pourcent : 44
NbErreursAgrégées : 0 / 50000 
NbErreursAgrégées 1 <br/>
Transaction QDU Query : {"qduCode":"QDUTR4","nomControle":"Contr\u00f4le d'unicit\u00e9 du produit","niveau":"Erreur","type":"Contr\u00f4le d'unicit\u00e9 du produit","regle":"Une transaction ne peut avoir plus de 2 'produit' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_PRET AS ID_LIGNE,\r\n                    COUNT(DISTINCT PRODUIT) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(PRODUIT = '', 'vide', PRODUIT) ORDER BY PRODUIT SEPARATOR ', ') AS LISTE_ERREURS\r\n                FROM T_DONNEES_CLIENT_FAITY\r\n                WHERE NUM_CHARGEMENT = :num\r\n                GROUP BY ID_PRET\r\n                HAVING COUNT(DISTINCT PRODUIT) > 1\r\n                ORDER BY ID_PRET\r\n            ","objet":"Transaction","obligatoire":"1","dbField":"PRODUIT"}
Query 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT PRODUIT) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(PRODUIT = '', 'vide', PRODUIT) ORDER BY PRODUIT SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT PRODUIT) > 1
                ORDER BY ID_PRET
             <br/>
Progress : current check : 25 , totalChecks : 54 , Pourcent : 46
NbErreursAgrégées : 0 / 50000 
NbErreursAgrégées 1 <br/>
Transaction QDU Query : {"qduCode":"QDUTR5","nomControle":"Contr\u00f4le d'unicit\u00e9 du mode d'amortissement","niveau":"Erreur","type":"Contr\u00f4le d'unicit\u00e9 du mode d'amortissement","regle":"Une transaction ne peut avoir plus de 2 'mode d'amortissement' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_PRET AS ID_LIGNE,\r\n                    COUNT(DISTINCT MODE_AMORTISSEMENT) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(MODE_AMORTISSEMENT = '', 'vide', MODE_AMORTISSEMENT) ORDER BY MODE_AMORTISSEMENT SEPARATOR ', ') AS LISTE_ERREURS\r\n                FROM T_DONNEES_CLIENT_FAITY\r\n                WHERE NUM_CHARGEMENT = :num\r\n                GROUP BY ID_PRET\r\n                HAVING COUNT(DISTINCT MODE_AMORTISSEMENT) > 1\r\n                ORDER BY ID_PRET\r\n            ","objet":"Transaction","obligatoire":"1","dbField":"MODE_AMORTISSEMENT"}
Query 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT MODE_AMORTISSEMENT) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(MODE_AMORTISSEMENT = '', 'vide', MODE_AMORTISSEMENT) ORDER BY MODE_AMORTISSEMENT SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT MODE_AMORTISSEMENT) > 1
                ORDER BY ID_PRET
             <br/>
Progress : current check : 26 , totalChecks : 54 , Pourcent : 48
NbErreursAgrégées : 0 / 50000 
NbErreursAgrégées 1 <br/>
Transaction QDU Query : {"qduCode":"QDUTR6","nomControle":"Contr\u00f4le d'unicit\u00e9 du type de taux","niveau":"Erreur","type":"Contr\u00f4le d'unicit\u00e9 du type de taux","regle":"Une transaction ne peut avoir plus de 2 'type de taux' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_PRET AS ID_LIGNE,\r\n                    COUNT(DISTINCT NATURE_TAUX) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(NATURE_TAUX = '', 'vide', NATURE_TAUX) ORDER BY NATURE_TAUX SEPARATOR ', ') AS LISTE_ERREURS\r\n                FROM T_DONNEES_CLIENT_FAITY\r\n                WHERE NUM_CHARGEMENT = :num\r\n                GROUP BY ID_PRET\r\n                HAVING COUNT(DISTINCT NATURE_TAUX) > 1\r\n                ORDER BY ID_PRET\r\n            ","objet":"Transaction","obligatoire":"1","dbField":"NATURE_TAUX"}
Query 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT NATURE_TAUX) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(NATURE_TAUX = '', 'vide', NATURE_TAUX) ORDER BY NATURE_TAUX SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT NATURE_TAUX) > 1
                ORDER BY ID_PRET
             <br/>
Progress : current check : 27 , totalChecks : 54 , Pourcent : 50
NbErreursAgrégées : 0 / 50000 
NbErreursAgrégées 1 <br/>
Transaction QDU Query : {"qduCode":"QDUTR7","nomControle":"Contr\u00f4le d'unicit\u00e9 du montant d'op\u00e9ration","niveau":"Erreur","type":"Contr\u00f4le d'unicit\u00e9 du montant d'op\u00e9ration","regle":"Une transaction ne peut avoir plus de 2 'montant d'op\u00e9ration' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_PRET AS ID_LIGNE,\r\n                    COUNT(DISTINCT MONTANT_OPERATION) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(MONTANT_OPERATION = '', 'vide', MONTANT_OPERATION) ORDER BY MONTANT_OPERATION SEPARATOR ', ') AS LISTE_ERREURS\r\n                FROM T_DONNEES_CLIENT_FAITY\r\n                WHERE NUM_CHARGEMENT = :num\r\n                GROUP BY ID_PRET\r\n                HAVING COUNT(DISTINCT MONTANT_OPERATION) > 1\r\n                ORDER BY ID_PRET\r\n            ","objet":"Transaction","obligatoire":"1","dbField":"MONTANT_OPERATION"}
Query 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT MONTANT_OPERATION) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(MONTANT_OPERATION = '', 'vide', MONTANT_OPERATION) ORDER BY MONTANT_OPERATION SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT MONTANT_OPERATION) > 1
                ORDER BY ID_PRET
             <br/>
Progress : current check : 28 , totalChecks : 54 , Pourcent : 51
NbErreursAgrégées : 0 / 50000 
NbErreursAgrégées 1 <br/>
Transaction QDU Query : {"qduCode":"QDUTR8","nomControle":"Contr\u00f4le d'unicit\u00e9 de l'encours","niveau":"Erreur","type":"Contr\u00f4le d'unicit\u00e9 de l'encours","regle":"Une transaction ne peut avoir plus de 2 'encours' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_PRET AS ID_LIGNE,\r\n                    COUNT(DISTINCT ENCOURS_CERTIF_COMPTABLE) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(ENCOURS_CERTIF_COMPTABLE = '', 'vide', ENCOURS_CERTIF_COMPTABLE) ORDER BY ENCOURS_CERTIF_COMPTABLE SEPARATOR ', ') AS LISTE_ERREURS\r\n                FROM T_DONNEES_CLIENT_FAITY\r\n                WHERE NUM_CHARGEMENT = :num\r\n                GROUP BY ID_PRET\r\n                HAVING COUNT(DISTINCT ENCOURS_CERTIF_COMPTABLE) > 1\r\n                ORDER BY ID_PRET\r\n            ","objet":"Transaction","obligatoire":"1","dbField":"ENCOURS_CERTIF_COMPTABLE"}
Query 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT ENCOURS_CERTIF_COMPTABLE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(ENCOURS_CERTIF_COMPTABLE = '', 'vide', ENCOURS_CERTIF_COMPTABLE) ORDER BY ENCOURS_CERTIF_COMPTABLE SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT ENCOURS_CERTIF_COMPTABLE) > 1
                ORDER BY ID_PRET
             <br/>
Progress : current check : 29 , totalChecks : 54 , Pourcent : 53
NbErreursAgrégées : 3305 / 50000 
NbErreursAgrégées 1 <br/>
Transaction QDU Query : {"qduCode":"QDUTR10","nomControle":"Contr\u00f4le d'unicit\u00e9 du type d'op\u00e9ration","niveau":"Erreur","type":"Contr\u00f4le d'unicit\u00e9 du type d'op\u00e9ration","regle":"Une transaction ne peut avoir plus de 2 'type d'op\u00e9ration' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_PRET AS ID_LIGNE,\r\n                    COUNT(DISTINCT TYPE_OPERATION) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(TYPE_OPERATION = '', 'vide', TYPE_OPERATION) ORDER BY TYPE_OPERATION SEPARATOR ', ') AS LISTE_ERREURS\r\n                FROM T_DONNEES_CLIENT_FAITY\r\n                WHERE NUM_CHARGEMENT = :num\r\n                GROUP BY ID_PRET\r\n                HAVING COUNT(DISTINCT TYPE_OPERATION) > 1\r\n                ORDER BY ID_PRET\r\n            ","objet":"Transaction","obligatoire":"1","dbField":"TYPE_OPERATION"}
Query 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT TYPE_OPERATION) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(TYPE_OPERATION = '', 'vide', TYPE_OPERATION) ORDER BY TYPE_OPERATION SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT TYPE_OPERATION) > 1
                ORDER BY ID_PRET
             <br/>
Progress : current check : 30 , totalChecks : 54 , Pourcent : 55
NbErreursAgrégées : 0 / 50000 
NbErreursAgrégées 1 <br/>
Transaction QDU Query : {"qduCode":"QDUTR11","nomControle":"Contr\u00f4le d'unicit\u00e9 de la dur\u00e9e totale","niveau":"Erreur","type":"Contr\u00f4le d'unicit\u00e9 de la dur\u00e9e totale","regle":"Une transaction ne peut avoir plus de 2 'dur\u00e9e totale' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_PRET AS ID_LIGNE,\r\n                    COUNT(DISTINCT DUREE_TOTALE) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(DUREE_TOTALE = '', 'vide', DUREE_TOTALE) ORDER BY DUREE_TOTALE SEPARATOR ', ') AS LISTE_ERREURS\r\n                FROM T_DONNEES_CLIENT_FAITY\r\n                WHERE NUM_CHARGEMENT = :num\r\n                GROUP BY ID_PRET\r\n                HAVING COUNT(DISTINCT DUREE_TOTALE) > 1\r\n                ORDER BY ID_PRET\r\n            ","objet":"Transaction","obligatoire":"1","dbField":"DUREE_TOTALE"}
Query 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT DUREE_TOTALE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(DUREE_TOTALE = '', 'vide', DUREE_TOTALE) ORDER BY DUREE_TOTALE SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT DUREE_TOTALE) > 1
                ORDER BY ID_PRET
             <br/>
Progress : current check : 31 , totalChecks : 54 , Pourcent : 57
NbErreursAgrégées : 0 / 50000 
NbErreursAgrégées 1 <br/>
Transaction QDU Query : {"qduCode":"QDUTR12","nomControle":"Contr\u00f4le d'unicit\u00e9 de la dur\u00e9e restante en mois","niveau":"Erreur","type":"Contr\u00f4le d'unicit\u00e9 de la dur\u00e9e restante en mois","regle":"Une transaction ne peut avoir plus de 2 'dur\u00e9e restante en mois' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_PRET AS ID_LIGNE,\r\n                    COUNT(DISTINCT DUREE_RESTANTE) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(DUREE_RESTANTE = '', 'vide', DUREE_RESTANTE) ORDER BY DUREE_RESTANTE SEPARATOR ', ') AS LISTE_ERREURS\r\n                FROM T_DONNEES_CLIENT_FAITY\r\n                WHERE NUM_CHARGEMENT = :num\r\n                GROUP BY ID_PRET\r\n                HAVING COUNT(DISTINCT DUREE_RESTANTE) > 1\r\n                ORDER BY ID_PRET\r\n            ","objet":"Transaction","obligatoire":"1","dbField":"DUREE_RESTANTE"}
Query 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT DUREE_RESTANTE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(DUREE_RESTANTE = '', 'vide', DUREE_RESTANTE) ORDER BY DUREE_RESTANTE SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT DUREE_RESTANTE) > 1
                ORDER BY ID_PRET
             <br/>
Progress : current check : 32 , totalChecks : 54 , Pourcent : 59
NbErreursAgrégées : 0 / 50000 
NbErreursAgrégées 1 <br/>
Transaction QDU Query : {"qduCode":"QDUTR13","nomControle":"Contr\u00f4le d'unicit\u00e9 de la dur\u00e9e du diff\u00e9r\u00e9","niveau":"Erreur","type":"Contr\u00f4le d'unicit\u00e9 de la dur\u00e9e du diff\u00e9r\u00e9","regle":"Une transaction ne peut avoir plus de 2 'dur\u00e9e du diff\u00e9r\u00e9' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_PRET AS ID_LIGNE,\r\n                    COUNT(DISTINCT DUREE_DIFF_AMORT) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(DUREE_DIFF_AMORT = '', 'vide', DUREE_DIFF_AMORT) ORDER BY DUREE_DIFF_AMORT SEPARATOR ', ') AS LISTE_ERREURS\r\n                FROM T_DONNEES_CLIENT_FAITY\r\n                WHERE NUM_CHARGEMENT = :num\r\n                GROUP BY ID_PRET\r\n                HAVING COUNT(DISTINCT DUREE_DIFF_AMORT) > 1\r\n                ORDER BY ID_PRET\r\n            ","objet":"Transaction","obligatoire":"1","dbField":"DUREE_DIFF_AMORT"}
Query 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT DUREE_DIFF_AMORT) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(DUREE_DIFF_AMORT = '', 'vide', DUREE_DIFF_AMORT) ORDER BY DUREE_DIFF_AMORT SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT DUREE_DIFF_AMORT) > 1
                ORDER BY ID_PRET
             <br/>
Progress : current check : 33 , totalChecks : 54 , Pourcent : 61
NbErreursAgrégées : 0 / 50000 
NbErreursAgrégées 1 <br/>
Transaction QDU Query : {"qduCode":"QDUTR14","nomControle":"Contr\u00f4le d'unicit\u00e9 du type de bien","niveau":"Erreur","type":"Contr\u00f4le d'unicit\u00e9 du type de bien","regle":"Une transaction ne peut avoir plus de 2 'type de bien' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_PRET AS ID_LIGNE,\r\n                    COUNT(DISTINCT TYPE_BIEN) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(TYPE_BIEN = '', 'vide', TYPE_BIEN) ORDER BY TYPE_BIEN SEPARATOR ', ') AS LISTE_ERREURS\r\n                FROM T_DONNEES_CLIENT_FAITY\r\n                WHERE NUM_CHARGEMENT = :num\r\n                GROUP BY ID_PRET\r\n                HAVING COUNT(DISTINCT TYPE_BIEN) > 1\r\n                ORDER BY ID_PRET\r\n            ","objet":"Transaction","obligatoire":"1","dbField":"TYPE_BIEN"}
Query 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT TYPE_BIEN) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(TYPE_BIEN = '', 'vide', TYPE_BIEN) ORDER BY TYPE_BIEN SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT TYPE_BIEN) > 1
                ORDER BY ID_PRET
             <br/>
Progress : current check : 34 , totalChecks : 54 , Pourcent : 62
NbErreursAgrégées : 0 / 50000 
NbErreursAgrégées 1 <br/>
Transaction QDU Query : {"qduCode":"QDUTR15","nomControle":"Contr\u00f4le d'unicit\u00e9 du taux nom. annuel","niveau":"Erreur","type":"Contr\u00f4le d'unicit\u00e9 du taux nom. annuel","regle":"Une transaction ne peut avoir plus de 2 'taux nom. annuel' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_PRET AS ID_LIGNE,\r\n                    COUNT(DISTINCT TAUX_NOMINAL_ANN_BRUT) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(TAUX_NOMINAL_ANN_BRUT = '', 'vide', TAUX_NOMINAL_ANN_BRUT) ORDER BY TAUX_NOMINAL_ANN_BRUT SEPARATOR ', ') AS LISTE_ERREURS\r\n                FROM T_DONNEES_CLIENT_FAITY\r\n                WHERE NUM_CHARGEMENT = :num\r\n                GROUP BY ID_PRET\r\n                HAVING COUNT(DISTINCT TAUX_NOMINAL_ANN_BRUT) > 1\r\n                ORDER BY ID_PRET\r\n            ","objet":"Transaction","obligatoire":"1","dbField":"TAUX_NOMINAL_ANN_BRUT"}
Query 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT TAUX_NOMINAL_ANN_BRUT) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(TAUX_NOMINAL_ANN_BRUT = '', 'vide', TAUX_NOMINAL_ANN_BRUT) ORDER BY TAUX_NOMINAL_ANN_BRUT SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT TAUX_NOMINAL_ANN_BRUT) > 1
                ORDER BY ID_PRET
             <br/>
Progress : current check : 35 , totalChecks : 54 , Pourcent : 64
NbErreursAgrégées : 0 / 50000 
NbErreursAgrégées 1 <br/>
Transaction QDU Query : {"qduCode":"QDUTR16","nomControle":"Contr\u00f4le d'unicit\u00e9 du taux eff. global","niveau":"Erreur","type":"Contr\u00f4le d'unicit\u00e9 du taux eff. global","regle":"Une transaction ne peut avoir plus de 2 'taux eff. global' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_PRET AS ID_LIGNE,\r\n                    COUNT(DISTINCT TAUX_EFF_GLOBAL) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(TAUX_EFF_GLOBAL = '', 'vide', TAUX_EFF_GLOBAL) ORDER BY TAUX_EFF_GLOBAL SEPARATOR ', ') AS LISTE_ERREURS\r\n                FROM T_DONNEES_CLIENT_FAITY\r\n                WHERE NUM_CHARGEMENT = :num\r\n                GROUP BY ID_PRET\r\n                HAVING COUNT(DISTINCT TAUX_EFF_GLOBAL) > 1\r\n                ORDER BY ID_PRET\r\n            ","objet":"Transaction","obligatoire":"1","dbField":"TAUX_EFF_GLOBAL"}
Query 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT TAUX_EFF_GLOBAL) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(TAUX_EFF_GLOBAL = '', 'vide', TAUX_EFF_GLOBAL) ORDER BY TAUX_EFF_GLOBAL SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT TAUX_EFF_GLOBAL) > 1
                ORDER BY ID_PRET
             <br/>
Progress : current check : 36 , totalChecks : 54 , Pourcent : 66
NbErreursAgrégées : 0 / 50000 
NbErreursAgrégées 1 <br/>
Transaction QDU Query : {"qduCode":"QDUTR17","nomControle":"Contr\u00f4le d'unicit\u00e9 de changement cond. fin.","niveau":"Erreur","type":"Contr\u00f4le d'unicit\u00e9 de changement cond. fin.","regle":"Une transaction ne peut avoir plus de 2 'changement cond. fin.' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_PRET AS ID_LIGNE,\r\n                    COUNT(DISTINCT DATE_SAISIE_COND_FIN) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(DATE_SAISIE_COND_FIN = '', 'vide', DATE_SAISIE_COND_FIN) ORDER BY DATE_SAISIE_COND_FIN SEPARATOR ', ') AS LISTE_ERREURS\r\n                FROM T_DONNEES_CLIENT_FAITY\r\n                WHERE NUM_CHARGEMENT = :num\r\n                GROUP BY ID_PRET\r\n                HAVING COUNT(DISTINCT DATE_SAISIE_COND_FIN) > 1\r\n                ORDER BY ID_PRET\r\n            ","objet":"Transaction","obligatoire":"1","dbField":"DATE_SAISIE_COND_FIN"}
Query 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT DATE_SAISIE_COND_FIN) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(DATE_SAISIE_COND_FIN = '', 'vide', DATE_SAISIE_COND_FIN) ORDER BY DATE_SAISIE_COND_FIN SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT DATE_SAISIE_COND_FIN) > 1
                ORDER BY ID_PRET
             <br/>
Progress : current check : 37 , totalChecks : 54 , Pourcent : 68
NbErreursAgrégées : 0 / 50000 
NbErreursAgrégées 1 <br/>
Transaction QDU Query : {"qduCode":"QDUTR18","nomControle":"Contr\u00f4le d'unicit\u00e9 de l'adresse du bien","niveau":"Erreur","type":"Contr\u00f4le d'unicit\u00e9 de l'adresse du bien","regle":"Une transaction ne peut avoir plus de 2 'adresse du bien' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_PRET AS ID_LIGNE,\r\n                    COUNT(DISTINCT ADR_BIEN_FINANCE) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(ADR_BIEN_FINANCE = '', 'vide', ADR_BIEN_FINANCE) ORDER BY ADR_BIEN_FINANCE SEPARATOR ', ') AS LISTE_ERREURS\r\n                FROM T_DONNEES_CLIENT_FAITY\r\n                WHERE NUM_CHARGEMENT = :num\r\n                GROUP BY ID_PRET\r\n                HAVING COUNT(DISTINCT ADR_BIEN_FINANCE) > 1\r\n                ORDER BY ID_PRET\r\n            ","objet":"Transaction","obligatoire":"1","dbField":"ADR_BIEN_FINANCE"}
Query 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT ADR_BIEN_FINANCE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(ADR_BIEN_FINANCE = '', 'vide', ADR_BIEN_FINANCE) ORDER BY ADR_BIEN_FINANCE SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT ADR_BIEN_FINANCE) > 1
                ORDER BY ID_PRET
             <br/>
Progress : current check : 38 , totalChecks : 54 , Pourcent : 70
NbErreursAgrégées : 3305 / 50000 
NbErreursAgrégées 1 <br/>
Transaction QDU Query : {"qduCode":"QDUTR19","nomControle":"Contr\u00f4le du num\u00e9ro de rue du bien","niveau":"Erreur","type":"Contr\u00f4le du num\u00e9ro de rue du bien","regle":"Une transaction ne peut avoir plus de 2 'num\u00e9ro de rue du bien' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_PRET AS ID_LIGNE,\r\n                    COUNT(DISTINCT ADR_BIEN_NO_RUE) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(ADR_BIEN_NO_RUE = '', 'vide', ADR_BIEN_NO_RUE) ORDER BY ADR_BIEN_NO_RUE SEPARATOR ', ') AS LISTE_ERREURS\r\n                FROM T_DONNEES_CLIENT_FAITY\r\n                WHERE NUM_CHARGEMENT = :num\r\n                GROUP BY ID_PRET\r\n                HAVING COUNT(DISTINCT ADR_BIEN_NO_RUE) > 1\r\n                ORDER BY ID_PRET\r\n            ","objet":"Transaction","obligatoire":"1","dbField":"ADR_BIEN_NO_RUE"}
Query 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT ADR_BIEN_NO_RUE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(ADR_BIEN_NO_RUE = '', 'vide', ADR_BIEN_NO_RUE) ORDER BY ADR_BIEN_NO_RUE SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT ADR_BIEN_NO_RUE) > 1
                ORDER BY ID_PRET
             <br/>
Progress : current check : 39 , totalChecks : 54 , Pourcent : 72
NbErreursAgrégées : 0 / 50000 
NbErreursAgrégées 1 <br/>
Transaction QDU Query : {"qduCode":"QDUTR20","nomControle":"Contr\u00f4le du nom de rue du bien","niveau":"Erreur","type":"Contr\u00f4le du nom de rue du bien","regle":"Une transaction ne peut avoir plus de 2 'nom de rue du bien' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_PRET AS ID_LIGNE,\r\n                    COUNT(DISTINCT ADR_BIEN_NOM_RUE) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(ADR_BIEN_NOM_RUE = '', 'vide', ADR_BIEN_NOM_RUE) ORDER BY ADR_BIEN_NOM_RUE SEPARATOR ', ') AS LISTE_ERREURS\r\n                FROM T_DONNEES_CLIENT_FAITY\r\n                WHERE NUM_CHARGEMENT = :num\r\n                GROUP BY ID_PRET\r\n                HAVING COUNT(DISTINCT ADR_BIEN_NOM_RUE) > 1\r\n                ORDER BY ID_PRET\r\n            ","objet":"Transaction","obligatoire":"1","dbField":"ADR_BIEN_NOM_RUE"}
Query 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT ADR_BIEN_NOM_RUE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(ADR_BIEN_NOM_RUE = '', 'vide', ADR_BIEN_NOM_RUE) ORDER BY ADR_BIEN_NOM_RUE SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT ADR_BIEN_NOM_RUE) > 1
                ORDER BY ID_PRET
             <br/>
Progress : current check : 40 , totalChecks : 54 , Pourcent : 74
NbErreursAgrégées : 0 / 50000 
NbErreursAgrégées 1 <br/>
Transaction QDU Query : {"qduCode":"QDUTR21","nomControle":"Contr\u00f4le du code postal du bien","niveau":"Erreur","type":"Contr\u00f4le du code postal du bien","regle":"Une transaction ne peut avoir plus de 2 'code postal du bien' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_PRET AS ID_LIGNE,\r\n                    COUNT(DISTINCT ADR_BIEN_CODE_POSTAL) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(ADR_BIEN_CODE_POSTAL = '', 'vide', ADR_BIEN_CODE_POSTAL) ORDER BY ADR_BIEN_CODE_POSTAL SEPARATOR ', ') AS LISTE_ERREURS\r\n                FROM T_DONNEES_CLIENT_FAITY\r\n                WHERE NUM_CHARGEMENT = :num\r\n                GROUP BY ID_PRET\r\n                HAVING COUNT(DISTINCT ADR_BIEN_CODE_POSTAL) > 1\r\n                ORDER BY ID_PRET\r\n            ","objet":"Transaction","obligatoire":"1","dbField":"ADR_BIEN_CODE_POSTAL"}
Query 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT ADR_BIEN_CODE_POSTAL) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(ADR_BIEN_CODE_POSTAL = '', 'vide', ADR_BIEN_CODE_POSTAL) ORDER BY ADR_BIEN_CODE_POSTAL SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT ADR_BIEN_CODE_POSTAL) > 1
                ORDER BY ID_PRET
             <br/>
Progress : current check : 41 , totalChecks : 54 , Pourcent : 75
NbErreursAgrégées : 3305 / 50000 
NbErreursAgrégées 1 <br/>
Transaction QDU Query : {"qduCode":"QDUTR22","nomControle":"Contr\u00f4le de la ville du bien","niveau":"Erreur","type":"Contr\u00f4le de la ville du bien","regle":"Une transaction ne peut avoir plus de 2 'ville du bien' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_PRET AS ID_LIGNE,\r\n                    COUNT(DISTINCT ADR_BIEN_VILLE) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(ADR_BIEN_VILLE = '', 'vide', ADR_BIEN_VILLE) ORDER BY ADR_BIEN_VILLE SEPARATOR ', ') AS LISTE_ERREURS\r\n                FROM T_DONNEES_CLIENT_FAITY\r\n                WHERE NUM_CHARGEMENT = :num\r\n                GROUP BY ID_PRET\r\n                HAVING COUNT(DISTINCT ADR_BIEN_VILLE) > 1\r\n                ORDER BY ID_PRET\r\n            ","objet":"Transaction","obligatoire":"1","dbField":"ADR_BIEN_VILLE"}
Query 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT ADR_BIEN_VILLE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(ADR_BIEN_VILLE = '', 'vide', ADR_BIEN_VILLE) ORDER BY ADR_BIEN_VILLE SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT ADR_BIEN_VILLE) > 1
                ORDER BY ID_PRET
             <br/>
Progress : current check : 42 , totalChecks : 54 , Pourcent : 77
NbErreursAgrégées : 3305 / 50000 
NbErreursAgrégées 1 <br/>
File name transaction : ./exports/erreurs_details_QDU_Transaction_9ds7em21p98i01roeoppej7a7i.xlsx
Nb collat distincts: 50000
Collateral QDU Query : {"qduCode":"QDUCO1","nomControle":"Contr\u00f4le d'unicit\u00e9 du type de garantie","niveau":"Erreur","type":"Contr\u00f4le d'unicit\u00e9 du type de garantie","regle":"Un collat\u00e9ral ne peut avoir plus de 2 'garantie' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_COLLATERAL AS ID_LIGNE,\r\n                    COUNT(DISTINCT COLLATERAL_GARANTIE) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(COLLATERAL_GARANTIE = '', 'vide', COLLATERAL_GARANTIE) ORDER BY COLLATERAL_GARANTIE SEPARATOR ', ') AS LISTE_ERREURS,\r\n                    ENCOURS_CERTIF_COMPTABLE\r\n                FROM (\r\n                    SELECT\r\n                        ID_COLLATERAL,\r\n                        COLLATERAL_GARANTIE,\r\n                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE\r\n                    FROM T_DONNEES_CLIENT_FAITY\r\n                    WHERE NUM_CHARGEMENT = :num\r\n                    GROUP BY ID_COLLATERAL, COLLATERAL_GARANTIE\r\n                ) PERIMETRE\r\n                WHERE \r\n                    COLLATERAL_GARANTIE IS NOT NULL\r\n                    AND ID_COLLATERAL IS NOT NULL \r\n                    AND ID_COLLATERAL <> '' \r\n                GROUP BY ID_COLLATERAL \r\n                HAVING COUNT(DISTINCT COLLATERAL_GARANTIE) > 1\r\n                ORDER BY ID_COLLATERAL\r\n            ","objet":"Collateral","obligatoire":"1","dbField":"COLLATERAL_GARANTIE"}
Query 
                SELECT
                    ID_COLLATERAL AS ID_LIGNE,
                    COUNT(DISTINCT COLLATERAL_GARANTIE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(COLLATERAL_GARANTIE = '', 'vide', COLLATERAL_GARANTIE) ORDER BY COLLATERAL_GARANTIE SEPARATOR ', ') AS LISTE_ERREURS,
                    ENCOURS_CERTIF_COMPTABLE
                FROM (
                    SELECT
                        ID_COLLATERAL,
                        COLLATERAL_GARANTIE,
                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE
                    FROM T_DONNEES_CLIENT_FAITY
                    WHERE NUM_CHARGEMENT = :num
                    GROUP BY ID_COLLATERAL, COLLATERAL_GARANTIE
                ) PERIMETRE
                WHERE 
                    COLLATERAL_GARANTIE IS NOT NULL
                    AND ID_COLLATERAL IS NOT NULL 
                    AND ID_COLLATERAL <> '' 
                GROUP BY ID_COLLATERAL 
                HAVING COUNT(DISTINCT COLLATERAL_GARANTIE) > 1
                ORDER BY ID_COLLATERAL
             <br/>
Progress : current check : 43 , totalChecks : 54 , Pourcent : 79
NbErreursAgrégées : 0 / 50000 
Collateral QDU Query : {"qduCode":"QDUCO2","nomControle":"Contr\u00f4le d'unicit\u00e9 du montant de dern. \u00e9val.","niveau":"Erreur","type":"Contr\u00f4le d'unicit\u00e9 du montant de dern. \u00e9val.","regle":"Un collat\u00e9ral ne peut avoir plus de 2 'montant de dern. \u00e9val.' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_COLLATERAL AS ID_LIGNE,\r\n                    COUNT(DISTINCT COLLATERAL_MT_DERNIERE_EVALUATION) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(COLLATERAL_MT_DERNIERE_EVALUATION = '', 'vide', COLLATERAL_MT_DERNIERE_EVALUATION) ORDER BY COLLATERAL_MT_DERNIERE_EVALUATION SEPARATOR ', ') AS LISTE_ERREURS,\r\n                    ENCOURS_CERTIF_COMPTABLE\r\n                FROM (\r\n                    SELECT\r\n                        ID_COLLATERAL,\r\n                        COLLATERAL_MT_DERNIERE_EVALUATION,\r\n                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE\r\n                    FROM T_DONNEES_CLIENT_FAITY\r\n                    WHERE NUM_CHARGEMENT = :num\r\n                    GROUP BY ID_COLLATERAL, COLLATERAL_MT_DERNIERE_EVALUATION\r\n                ) PERIMETRE\r\n                WHERE \r\n                    COLLATERAL_MT_DERNIERE_EVALUATION IS NOT NULL\r\n                    AND ID_COLLATERAL IS NOT NULL \r\n                    AND ID_COLLATERAL <> '' \r\n                GROUP BY ID_COLLATERAL \r\n                HAVING COUNT(DISTINCT COLLATERAL_MT_DERNIERE_EVALUATION) > 1\r\n                ORDER BY ID_COLLATERAL\r\n            ","objet":"Collateral","obligatoire":"1","dbField":"COLLATERAL_MT_DERNIERE_EVALUATION"}
Query 
                SELECT
                    ID_COLLATERAL AS ID_LIGNE,
                    COUNT(DISTINCT COLLATERAL_MT_DERNIERE_EVALUATION) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(COLLATERAL_MT_DERNIERE_EVALUATION = '', 'vide', COLLATERAL_MT_DERNIERE_EVALUATION) ORDER BY COLLATERAL_MT_DERNIERE_EVALUATION SEPARATOR ', ') AS LISTE_ERREURS,
                    ENCOURS_CERTIF_COMPTABLE
                FROM (
                    SELECT
                        ID_COLLATERAL,
                        COLLATERAL_MT_DERNIERE_EVALUATION,
                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE
                    FROM T_DONNEES_CLIENT_FAITY
                    WHERE NUM_CHARGEMENT = :num
                    GROUP BY ID_COLLATERAL, COLLATERAL_MT_DERNIERE_EVALUATION
                ) PERIMETRE
                WHERE 
                    COLLATERAL_MT_DERNIERE_EVALUATION IS NOT NULL
                    AND ID_COLLATERAL IS NOT NULL 
                    AND ID_COLLATERAL <> '' 
                GROUP BY ID_COLLATERAL 
                HAVING COUNT(DISTINCT COLLATERAL_MT_DERNIERE_EVALUATION) > 1
                ORDER BY ID_COLLATERAL
             <br/>
Progress : current check : 44 , totalChecks : 54 , Pourcent : 81
NbErreursAgrégées : 0 / 50000 
Collateral QDU Query : {"qduCode":"QDUCO3","nomControle":"Contr\u00f4le d'unicit\u00e9 de la date dern. \u00e9val.","niveau":"Erreur","type":"Contr\u00f4le d'unicit\u00e9 de la date dern. \u00e9val.","regle":"Un collat\u00e9ral ne peut avoir plus de 2 'types de personnes' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_COLLATERAL AS ID_LIGNE,\r\n                    COUNT(DISTINCT COLLATERAL_DT_DERNIERE_EVALUATION) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(COLLATERAL_DT_DERNIERE_EVALUATION = '', 'vide', COLLATERAL_DT_DERNIERE_EVALUATION) ORDER BY COLLATERAL_DT_DERNIERE_EVALUATION SEPARATOR ', ') AS LISTE_ERREURS,\r\n                    ENCOURS_CERTIF_COMPTABLE\r\n                FROM (\r\n                    SELECT\r\n                        ID_COLLATERAL,\r\n                        COLLATERAL_DT_DERNIERE_EVALUATION,\r\n                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE\r\n                    FROM T_DONNEES_CLIENT_FAITY\r\n                    WHERE NUM_CHARGEMENT = :num\r\n                    GROUP BY ID_COLLATERAL, COLLATERAL_DT_DERNIERE_EVALUATION\r\n                ) PERIMETRE\r\n                WHERE \r\n                    COLLATERAL_DT_DERNIERE_EVALUATION IS NOT NULL\r\n                    AND ID_COLLATERAL IS NOT NULL \r\n                    AND ID_COLLATERAL <> '' \r\n                GROUP BY ID_COLLATERAL \r\n                HAVING COUNT(DISTINCT COLLATERAL_DT_DERNIERE_EVALUATION) > 1\r\n                ORDER BY ID_COLLATERAL\r\n            ","objet":"Collateral","obligatoire":"1","dbField":"COLLATERAL_DT_DERNIERE_EVALUATION"}
Query 
                SELECT
                    ID_COLLATERAL AS ID_LIGNE,
                    COUNT(DISTINCT COLLATERAL_DT_DERNIERE_EVALUATION) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(COLLATERAL_DT_DERNIERE_EVALUATION = '', 'vide', COLLATERAL_DT_DERNIERE_EVALUATION) ORDER BY COLLATERAL_DT_DERNIERE_EVALUATION SEPARATOR ', ') AS LISTE_ERREURS,
                    ENCOURS_CERTIF_COMPTABLE
                FROM (
                    SELECT
                        ID_COLLATERAL,
                        COLLATERAL_DT_DERNIERE_EVALUATION,
                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE
                    FROM T_DONNEES_CLIENT_FAITY
                    WHERE NUM_CHARGEMENT = :num
                    GROUP BY ID_COLLATERAL, COLLATERAL_DT_DERNIERE_EVALUATION
                ) PERIMETRE
                WHERE 
                    COLLATERAL_DT_DERNIERE_EVALUATION IS NOT NULL
                    AND ID_COLLATERAL IS NOT NULL 
                    AND ID_COLLATERAL <> '' 
                GROUP BY ID_COLLATERAL 
                HAVING COUNT(DISTINCT COLLATERAL_DT_DERNIERE_EVALUATION) > 1
                ORDER BY ID_COLLATERAL
             <br/>
Progress : current check : 45 , totalChecks : 54 , Pourcent : 83
NbErreursAgrégées : 0 / 50000 
Collateral QDU Query : {"qduCode":"QDUCO4","nomControle":"Contr\u00f4le d'unicit\u00e9 de l'adresse","niveau":"Erreur","type":"Contr\u00f4le d'unicit\u00e9 de l'adresse","regle":"Un collat\u00e9ral ne peut avoir plus de 2 'adresse' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_COLLATERAL AS ID_LIGNE,\r\n                    COUNT(DISTINCT ADR_COLLATERAL) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(ADR_COLLATERAL = '', 'vide', ADR_COLLATERAL) ORDER BY ADR_COLLATERAL SEPARATOR ', ') AS LISTE_ERREURS,\r\n                    ENCOURS_CERTIF_COMPTABLE\r\n                FROM (\r\n                    SELECT\r\n                        ID_COLLATERAL,\r\n                        ADR_COLLATERAL,\r\n                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE\r\n                    FROM T_DONNEES_CLIENT_FAITY\r\n                    WHERE NUM_CHARGEMENT = :num\r\n                    GROUP BY ID_COLLATERAL, ADR_COLLATERAL\r\n                ) PERIMETRE\r\n                WHERE \r\n                    ADR_COLLATERAL IS NOT NULL\r\n                    AND ID_COLLATERAL IS NOT NULL \r\n                    AND ID_COLLATERAL <> '' \r\n                GROUP BY ID_COLLATERAL \r\n                HAVING COUNT(DISTINCT ADR_COLLATERAL) > 1\r\n                ORDER BY ID_COLLATERAL\r\n            ","objet":"Collateral","obligatoire":"1","dbField":"ADR_COLLATERAL"}
Query 
                SELECT
                    ID_COLLATERAL AS ID_LIGNE,
                    COUNT(DISTINCT ADR_COLLATERAL) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(ADR_COLLATERAL = '', 'vide', ADR_COLLATERAL) ORDER BY ADR_COLLATERAL SEPARATOR ', ') AS LISTE_ERREURS,
                    ENCOURS_CERTIF_COMPTABLE
                FROM (
                    SELECT
                        ID_COLLATERAL,
                        ADR_COLLATERAL,
                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE
                    FROM T_DONNEES_CLIENT_FAITY
                    WHERE NUM_CHARGEMENT = :num
                    GROUP BY ID_COLLATERAL, ADR_COLLATERAL
                ) PERIMETRE
                WHERE 
                    ADR_COLLATERAL IS NOT NULL
                    AND ID_COLLATERAL IS NOT NULL 
                    AND ID_COLLATERAL <> '' 
                GROUP BY ID_COLLATERAL 
                HAVING COUNT(DISTINCT ADR_COLLATERAL) > 1
                ORDER BY ID_COLLATERAL
             <br/>
Progress : current check : 46 , totalChecks : 54 , Pourcent : 85
NbErreursAgrégées : 0 / 50000 
Collateral QDU Query : {"qduCode":"QDUCO5","nomControle":"Contr\u00f4le d'unicit\u00e9 du n\u00b0 rue","niveau":"Erreur","type":"Contr\u00f4le d'unicit\u00e9 du n\u00b0 rue","regle":"Un collat\u00e9ral ne peut avoir plus de 2 'n\u00b0 rue' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_COLLATERAL AS ID_LIGNE,\r\n                    COUNT(DISTINCT COLLATERAL_NUM_RUE) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(COLLATERAL_NUM_RUE = '', 'vide', COLLATERAL_NUM_RUE) ORDER BY COLLATERAL_NUM_RUE SEPARATOR ', ') AS LISTE_ERREURS,\r\n                    ENCOURS_CERTIF_COMPTABLE\r\n                FROM (\r\n                    SELECT\r\n                        ID_COLLATERAL,\r\n                        COLLATERAL_NUM_RUE,\r\n                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE\r\n                    FROM T_DONNEES_CLIENT_FAITY\r\n                    WHERE NUM_CHARGEMENT = :num\r\n                    GROUP BY ID_COLLATERAL, COLLATERAL_NUM_RUE\r\n                ) PERIMETRE\r\n                WHERE \r\n                    COLLATERAL_NUM_RUE IS NOT NULL\r\n                    AND ID_COLLATERAL IS NOT NULL \r\n                    AND ID_COLLATERAL <> '' \r\n                GROUP BY ID_COLLATERAL \r\n                HAVING COUNT(DISTINCT COLLATERAL_NUM_RUE) > 1\r\n                ORDER BY ID_COLLATERAL\r\n            ","objet":"Collateral","obligatoire":"1","dbField":"COLLATERAL_NUM_RUE"}
Query 
                SELECT
                    ID_COLLATERAL AS ID_LIGNE,
                    COUNT(DISTINCT COLLATERAL_NUM_RUE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(COLLATERAL_NUM_RUE = '', 'vide', COLLATERAL_NUM_RUE) ORDER BY COLLATERAL_NUM_RUE SEPARATOR ', ') AS LISTE_ERREURS,
                    ENCOURS_CERTIF_COMPTABLE
                FROM (
                    SELECT
                        ID_COLLATERAL,
                        COLLATERAL_NUM_RUE,
                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE
                    FROM T_DONNEES_CLIENT_FAITY
                    WHERE NUM_CHARGEMENT = :num
                    GROUP BY ID_COLLATERAL, COLLATERAL_NUM_RUE
                ) PERIMETRE
                WHERE 
                    COLLATERAL_NUM_RUE IS NOT NULL
                    AND ID_COLLATERAL IS NOT NULL 
                    AND ID_COLLATERAL <> '' 
                GROUP BY ID_COLLATERAL 
                HAVING COUNT(DISTINCT COLLATERAL_NUM_RUE) > 1
                ORDER BY ID_COLLATERAL
             <br/>
Progress : current check : 47 , totalChecks : 54 , Pourcent : 87
NbErreursAgrégées : 0 / 50000 
Collateral QDU Query : {"qduCode":"QDUCO6","nomControle":"Contr\u00f4le d'unicit\u00e9 du nom de rue","niveau":"Erreur","type":"Contr\u00f4le d'unicit\u00e9 du nom de rue","regle":"Un collat\u00e9ral ne peut avoir plus de 2 'nom de rue' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_COLLATERAL AS ID_LIGNE,\r\n                    COUNT(DISTINCT COLLATERAL_NOM_RUE) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(COLLATERAL_NOM_RUE = '', 'vide', COLLATERAL_NOM_RUE) ORDER BY COLLATERAL_NOM_RUE SEPARATOR ', ') AS LISTE_ERREURS,\r\n                    ENCOURS_CERTIF_COMPTABLE\r\n                FROM (\r\n                    SELECT\r\n                        ID_COLLATERAL,\r\n                        COLLATERAL_NOM_RUE,\r\n                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE\r\n                    FROM T_DONNEES_CLIENT_FAITY\r\n                    WHERE NUM_CHARGEMENT = :num\r\n                    GROUP BY ID_COLLATERAL, COLLATERAL_NOM_RUE\r\n                ) PERIMETRE\r\n                WHERE \r\n                    COLLATERAL_NOM_RUE IS NOT NULL\r\n                    AND ID_COLLATERAL IS NOT NULL \r\n                    AND ID_COLLATERAL <> '' \r\n                GROUP BY ID_COLLATERAL \r\n                HAVING COUNT(DISTINCT COLLATERAL_NOM_RUE) > 1\r\n                ORDER BY ID_COLLATERAL\r\n            ","objet":"Collateral","obligatoire":"1","dbField":"COLLATERAL_NOM_RUE"}
Query 
                SELECT
                    ID_COLLATERAL AS ID_LIGNE,
                    COUNT(DISTINCT COLLATERAL_NOM_RUE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(COLLATERAL_NOM_RUE = '', 'vide', COLLATERAL_NOM_RUE) ORDER BY COLLATERAL_NOM_RUE SEPARATOR ', ') AS LISTE_ERREURS,
                    ENCOURS_CERTIF_COMPTABLE
                FROM (
                    SELECT
                        ID_COLLATERAL,
                        COLLATERAL_NOM_RUE,
                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE
                    FROM T_DONNEES_CLIENT_FAITY
                    WHERE NUM_CHARGEMENT = :num
                    GROUP BY ID_COLLATERAL, COLLATERAL_NOM_RUE
                ) PERIMETRE
                WHERE 
                    COLLATERAL_NOM_RUE IS NOT NULL
                    AND ID_COLLATERAL IS NOT NULL 
                    AND ID_COLLATERAL <> '' 
                GROUP BY ID_COLLATERAL 
                HAVING COUNT(DISTINCT COLLATERAL_NOM_RUE) > 1
                ORDER BY ID_COLLATERAL
             <br/>
Progress : current check : 48 , totalChecks : 54 , Pourcent : 88
NbErreursAgrégées : 0 / 50000 
Collateral QDU Query : {"qduCode":"QDUCO7","nomControle":"Contr\u00f4le d'unicit\u00e9 du CP","niveau":"Erreur","type":"Contr\u00f4le d'unicit\u00e9 du CP","regle":"Un collat\u00e9ral ne peut avoir plus de 2 'CP' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_COLLATERAL AS ID_LIGNE,\r\n                    COUNT(DISTINCT COLLATERAL_CP) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(COLLATERAL_CP = '', 'vide', COLLATERAL_CP) ORDER BY COLLATERAL_CP SEPARATOR ', ') AS LISTE_ERREURS,\r\n                    ENCOURS_CERTIF_COMPTABLE\r\n                FROM (\r\n                    SELECT\r\n                        ID_COLLATERAL,\r\n                        COLLATERAL_CP,\r\n                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE\r\n                    FROM T_DONNEES_CLIENT_FAITY\r\n                    WHERE NUM_CHARGEMENT = :num\r\n                    GROUP BY ID_COLLATERAL, COLLATERAL_CP\r\n                ) PERIMETRE\r\n                WHERE \r\n                    COLLATERAL_CP IS NOT NULL\r\n                    AND ID_COLLATERAL IS NOT NULL \r\n                    AND ID_COLLATERAL <> '' \r\n                GROUP BY ID_COLLATERAL \r\n                HAVING COUNT(DISTINCT COLLATERAL_CP) > 1\r\n                ORDER BY ID_COLLATERAL\r\n            ","objet":"Collateral","obligatoire":"1","dbField":"COLLATERAL_CP"}
Query 
                SELECT
                    ID_COLLATERAL AS ID_LIGNE,
                    COUNT(DISTINCT COLLATERAL_CP) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(COLLATERAL_CP = '', 'vide', COLLATERAL_CP) ORDER BY COLLATERAL_CP SEPARATOR ', ') AS LISTE_ERREURS,
                    ENCOURS_CERTIF_COMPTABLE
                FROM (
                    SELECT
                        ID_COLLATERAL,
                        COLLATERAL_CP,
                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE
                    FROM T_DONNEES_CLIENT_FAITY
                    WHERE NUM_CHARGEMENT = :num
                    GROUP BY ID_COLLATERAL, COLLATERAL_CP
                ) PERIMETRE
                WHERE 
                    COLLATERAL_CP IS NOT NULL
                    AND ID_COLLATERAL IS NOT NULL 
                    AND ID_COLLATERAL <> '' 
                GROUP BY ID_COLLATERAL 
                HAVING COUNT(DISTINCT COLLATERAL_CP) > 1
                ORDER BY ID_COLLATERAL
             <br/>
Progress : current check : 49 , totalChecks : 54 , Pourcent : 90
NbErreursAgrégées : 0 / 50000 
Collateral QDU Query : {"qduCode":"QDUCO8","nomControle":"Contr\u00f4le d'unicit\u00e9 de la ville","niveau":"Erreur","type":"Contr\u00f4le d'unicit\u00e9 de la ville","regle":"Un collat\u00e9ral ne peut avoir plus de 2 'ville' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_COLLATERAL AS ID_LIGNE,\r\n                    COUNT(DISTINCT COLLATERAL_VILLE) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(COLLATERAL_VILLE = '', 'vide', COLLATERAL_VILLE) ORDER BY COLLATERAL_VILLE SEPARATOR ', ') AS LISTE_ERREURS,\r\n                    ENCOURS_CERTIF_COMPTABLE\r\n                FROM (\r\n                    SELECT\r\n                        ID_COLLATERAL,\r\n                        COLLATERAL_VILLE,\r\n                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE\r\n                    FROM T_DONNEES_CLIENT_FAITY\r\n                    WHERE NUM_CHARGEMENT = :num\r\n                    GROUP BY ID_COLLATERAL, COLLATERAL_VILLE\r\n                ) PERIMETRE\r\n                WHERE \r\n                    COLLATERAL_VILLE IS NOT NULL\r\n                    AND ID_COLLATERAL IS NOT NULL \r\n                    AND ID_COLLATERAL <> '' \r\n                GROUP BY ID_COLLATERAL \r\n                HAVING COUNT(DISTINCT COLLATERAL_VILLE) > 1\r\n                ORDER BY ID_COLLATERAL\r\n            ","objet":"Collateral","obligatoire":"1","dbField":"COLLATERAL_VILLE"}
Query 
                SELECT
                    ID_COLLATERAL AS ID_LIGNE,
                    COUNT(DISTINCT COLLATERAL_VILLE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(COLLATERAL_VILLE = '', 'vide', COLLATERAL_VILLE) ORDER BY COLLATERAL_VILLE SEPARATOR ', ') AS LISTE_ERREURS,
                    ENCOURS_CERTIF_COMPTABLE
                FROM (
                    SELECT
                        ID_COLLATERAL,
                        COLLATERAL_VILLE,
                        SUM(ENCOURS_CERTIF_COMPTABLE) AS ENCOURS_CERTIF_COMPTABLE
                    FROM T_DONNEES_CLIENT_FAITY
                    WHERE NUM_CHARGEMENT = :num
                    GROUP BY ID_COLLATERAL, COLLATERAL_VILLE
                ) PERIMETRE
                WHERE 
                    COLLATERAL_VILLE IS NOT NULL
                    AND ID_COLLATERAL IS NOT NULL 
                    AND ID_COLLATERAL <> '' 
                GROUP BY ID_COLLATERAL 
                HAVING COUNT(DISTINCT COLLATERAL_VILLE) > 1
                ORDER BY ID_COLLATERAL
             <br/>
Progress : current check : 50 , totalChecks : 54 , Pourcent : 92
NbErreursAgrégées : 0 / 50000 
File name transaction : ./exports/erreurs_details_QDU_Collateral_9ds7em21p98i01roeoppej7a7i.xlsx
ESG QDU Query : {"qduCode":"QDUES1","nomControle":"Contr\u00f4le d'unicit\u00e9 de l'\u00e9tiquette DPE","niveau":"Erreur","type":"Contr\u00f4le d'unicit\u00e9 de l'\u00e9tiquette DPE","regle":"Une transaction ne peut avoir plus de 2 '\u00e9tiquette DPE' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_PRET AS ID_LIGNE,\r\n                    COUNT(DISTINCT DPE_ETIQUETTE_ENERGIE) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(DPE_ETIQUETTE_ENERGIE = '', 'vide', DPE_ETIQUETTE_ENERGIE) ORDER BY DPE_ETIQUETTE_ENERGIE SEPARATOR ', ') AS LISTE_ERREURS\r\n                FROM T_DONNEES_CLIENT_FAITY\r\n                WHERE NUM_CHARGEMENT = :num\r\n                GROUP BY ID_PRET\r\n                HAVING COUNT(DISTINCT DPE_ETIQUETTE_ENERGIE) > 1\r\n                ORDER BY ID_PRET\r\n            ","objet":"ESG","obligatoire":"1","dbField":"DPE_ETIQUETTE_ENERGIE"}
Query 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT DPE_ETIQUETTE_ENERGIE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(DPE_ETIQUETTE_ENERGIE = '', 'vide', DPE_ETIQUETTE_ENERGIE) ORDER BY DPE_ETIQUETTE_ENERGIE SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT DPE_ETIQUETTE_ENERGIE) > 1
                ORDER BY ID_PRET
             <br/>
Progress : current check : 51 , totalChecks : 54 , Pourcent : 94
Progress : current check : 51 , totalChecks : 54 , Pourcent : 94
NbErreursAgrégées : 2836 / 50000 
NbErreursAgrégées 1 <br/>
ESG QDU Query : {"qduCode":"QDUES2","nomControle":"Contr\u00f4le d'unicit\u00e9 de la conso. \u00e9nergie","niveau":"Erreur","type":"Contr\u00f4le d'unicit\u00e9 de la conso. \u00e9nergie","regle":"Une transaction ne peut avoir plus de 2 'conso. \u00e9nergie' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_PRET AS ID_LIGNE,\r\n                    COUNT(DISTINCT DPE_CONSO_ENERGIE_PRIMAIRE) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(DPE_CONSO_ENERGIE_PRIMAIRE = '', 'vide', DPE_CONSO_ENERGIE_PRIMAIRE) ORDER BY DPE_CONSO_ENERGIE_PRIMAIRE SEPARATOR ', ') AS LISTE_ERREURS\r\n                FROM T_DONNEES_CLIENT_FAITY\r\n                WHERE NUM_CHARGEMENT = :num\r\n                GROUP BY ID_PRET\r\n                HAVING COUNT(DISTINCT DPE_CONSO_ENERGIE_PRIMAIRE) > 1\r\n                ORDER BY ID_PRET\r\n            ","objet":"ESG","obligatoire":"1","dbField":"DPE_CONSO_ENERGIE_PRIMAIRE"}
Query 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT DPE_CONSO_ENERGIE_PRIMAIRE) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(DPE_CONSO_ENERGIE_PRIMAIRE = '', 'vide', DPE_CONSO_ENERGIE_PRIMAIRE) ORDER BY DPE_CONSO_ENERGIE_PRIMAIRE SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT DPE_CONSO_ENERGIE_PRIMAIRE) > 1
                ORDER BY ID_PRET
             <br/>
Progress : current check : 52 , totalChecks : 54 , Pourcent : 96
Progress : current check : 52 , totalChecks : 54 , Pourcent : 96
NbErreursAgrégées : 3298 / 50000 
NbErreursAgrégées 1 <br/>
ESG QDU Query : {"qduCode":"QDUES3","nomControle":"Contr\u00f4le d'unicit\u00e9 de l'\u00e9mission GES'","niveau":"Erreur","type":"Contr\u00f4le d'unicit\u00e9 de l'\u00e9mission GES'","regle":"Une transaction ne peut avoir plus de 2 '\u00e9mission GES' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_PRET AS ID_LIGNE,\r\n                    COUNT(DISTINCT DPE_EMISSION_GAZ) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(DPE_EMISSION_GAZ = '', 'vide', DPE_EMISSION_GAZ) ORDER BY DPE_EMISSION_GAZ SEPARATOR ', ') AS LISTE_ERREURS\r\n                FROM T_DONNEES_CLIENT_FAITY\r\n                WHERE NUM_CHARGEMENT = :num\r\n                GROUP BY ID_PRET\r\n                HAVING COUNT(DISTINCT DPE_EMISSION_GAZ) > 1\r\n                ORDER BY ID_PRET\r\n            ","objet":"ESG","obligatoire":"1","dbField":"DPE_EMISSION_GAZ"}
Query 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT DPE_EMISSION_GAZ) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(DPE_EMISSION_GAZ = '', 'vide', DPE_EMISSION_GAZ) ORDER BY DPE_EMISSION_GAZ SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT DPE_EMISSION_GAZ) > 1
                ORDER BY ID_PRET
             <br/>
Progress : current check : 53 , totalChecks : 54 , Pourcent : 98
Progress : current check : 53 , totalChecks : 54 , Pourcent : 98
NbErreursAgrégées : 3286 / 50000 
NbErreursAgrégées 1 <br/>
ESG QDU Query : {"qduCode":"QDUES4","nomControle":"Contr\u00f4le d'unicit\u00e9 de date de r\u00e9alisation DPE","niveau":"Erreur","type":"Contr\u00f4le d'unicit\u00e9 de date de r\u00e9alisation DPE","regle":"Une transaction ne peut avoir plus de 2 'r\u00e9alisation DPE' diff\u00e9rents","sqlQuery":"\r\n                SELECT\r\n                    ID_PRET AS ID_LIGNE,\r\n                    COUNT(DISTINCT DPE_DATE_REALISATION) AS NBRE_DISTINCTS,\r\n                    GROUP_CONCAT(DISTINCT IF(DPE_DATE_REALISATION = '', 'vide', DPE_DATE_REALISATION) ORDER BY DPE_DATE_REALISATION SEPARATOR ', ') AS LISTE_ERREURS\r\n                FROM T_DONNEES_CLIENT_FAITY\r\n                WHERE NUM_CHARGEMENT = :num\r\n                GROUP BY ID_PRET\r\n                HAVING COUNT(DISTINCT DPE_DATE_REALISATION) > 1\r\n                ORDER BY ID_PRET\r\n            ","objet":"ESG","obligatoire":"1","dbField":"DPE_DATE_REALISATION"}
Query 
                SELECT
                    ID_PRET AS ID_LIGNE,
                    COUNT(DISTINCT DPE_DATE_REALISATION) AS NBRE_DISTINCTS,
                    GROUP_CONCAT(DISTINCT IF(DPE_DATE_REALISATION = '', 'vide', DPE_DATE_REALISATION) ORDER BY DPE_DATE_REALISATION SEPARATOR ', ') AS LISTE_ERREURS
                FROM T_DONNEES_CLIENT_FAITY
                WHERE NUM_CHARGEMENT = :num
                GROUP BY ID_PRET
                HAVING COUNT(DISTINCT DPE_DATE_REALISATION) > 1
                ORDER BY ID_PRET
             <br/>
Progress : current check : 54 , totalChecks : 54 , Pourcent : 100
Progress : current check : 54 , totalChecks : 54 , Pourcent : 100
NbErreursAgrégées : 3304 / 50000 
NbErreursAgrégées 1 <br/>
ErreurDetailESG 4 <br/>
Progress : current check : 54 , totalChecks : 54 , Pourcent : 100
ErreurDetailCollateral 4 <br/>
File name transaction : ./exports/erreurs_details_QDU_ESG_9ds7em21p98i01roeoppej7a7i.xlsx
Avant envoi vers AJAX
Après envoi vers AJAX
