<?xml version="1.0" encoding="ISO-8859-1"?>
<persistence-config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:noNamespaceSchemaLocation="../../../../defs/config-metier/Persistence.xsd">
    <layer name="mysql" persistence-model="xemelios-sql">
        <document id="DOC_PES_Facture" repository-import-xslt-file="">
            <table type="repository" base-name="PES_FACTURE_REPOSITORY" version="2">
                CREATE TABLE IF NOT EXISTS ${base-name} (
                ID VARCHAR(25),
                LIBELLE VARCHAR(100),
                COLLECTIVITE VARCHAR(15) NOT NULL,
                REPOSITORY LONGBLOB,
                ENCODING VARCHAR(20)
                ) TYPE MYISAM
                <patch from-version="1">
                    <sql failonerror="false">ALTER TABLE ${base-name} ADD ID VARCHAR(25)</sql>
                    <sql failonerror="false">ALTER TABLE ${base-name} ADD LIBELLE VARCHAR(100)</sql>
                </patch>
            </table>
            <table type="special-key" base-name="PES_FACTURE_SPECIAL_KEYS" version="1"> CREATE TABLE
                IF NOT EXISTS ${base-name} ( COLLECTIVITE VARCHAR(30) NOT NULL, BUDGET VARCHAR(24)
                NOT NULL, INITIAL_DOC_NAME VARCHAR(100) NOT NULL, KEY1 VARCHAR(100), LIB1
                VARCHAR(200), KEY2 VARCHAR(100), LIB2 VARCHAR(200), KEY3 VARCHAR(100), LIB3
                VARCHAR(200), KEY4 VARCHAR(100), LIB4 VARCHAR(200), KEY5 VARCHAR(100), LIB5
                VARCHAR(200), KEY6 VARCHAR(100), LIB6 VARCHAR(200), KEY7 VARCHAR(100), LIB7
                VARCHAR(200), KEY8 VARCHAR(100), LIB8 VARCHAR(200), KEY9 VARCHAR(100), LIB9
                VARCHAR(200), KEY10 VARCHAR(100), LIB10 VARCHAR(200), INDEX IX_${base-name}_BC
                (COLLECTIVITE,BUDGET) ) TYPE MYISAM </table>
            <table type="list-bc" base-name="PES_FACTURE_LIST_BUDG_COLL" version="1"> CREATE TABLE
                IF NOT EXISTS ${base-name} ( COLLECTIVITE VARCHAR(30) NOT NULL, BUDGET VARCHAR(24)
                NOT NULL, BUDGET_LIB VARCHAR(200), COLLECTIVITE_LIB VARCHAR(200), INITIAL_DOC_NAME
                VARCHAR(100) NOT NULL, INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET) ) TYPE MYISAM </table>

            <etat id="PESFacture" import-xslt-file="PES_Facture/PES-Facture-import-mysql.xsl">
                <key1>
                    <path>/n:DOC_PES_Facture/n:PESFacture/@added:generated-id</path>
                </key1>
                <key2>
                    <path>/n:DOC_PES_Facture/n:PESFacture/n:Tiers/@added:generated-id</path>
                </key2>
                <key3>
                    <path>/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/@added:generated-id</path>
                </key3>
                <key4>
                    <path>/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Reference/@added:generated-id</path>
                </key4>
                <key5>
                    <path>/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/@added:generated-id</path>
                </key5>
                <key6>
                    <path>/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/@added:generated-id</path>
                </key6>
                <key7>
                    <path>/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/@added:generated-id</path>
                </key7>
                <key8>
                    <path>/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:reference/@added:generated-id</path>
                </key8>
                <key9>
                    <path>/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:DetailTVA/@added:generated-id</path>
                </key9>

                <table type="document" base-name="PES_FACTURE_DOCUMENTS" version="1"> CREATE TABLE
                    IF NOT EXISTS ${base-name} ( COLLECTIVITE VARCHAR(30) NOT NULL, BUDGET
                    VARCHAR(24) NOT NULL, INITIAL_DOC_NAME VARCHAR(100) NOT NULL, DOC_ID
                    VARCHAR(100) NOT NULL, DOC LONGBLOB, ENCODING VARCHAR(20), INDEX
                    IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID) ) TYPE MYISAM </table>
                <table type="index" id="PES_FACTURE_PESFACTURE_IX"
                    base-name="PES_FACTURE_PESFACTURE_IX" version="1" main="true" based-on="key1">
                    CREATE TABLE IF NOT EXISTS ${base-name} ( 
                        COLLECTIVITE VARCHAR(30) NOT NULL,
                        BUDGET VARCHAR(24) NOT NULL,
                        DOC_ID VARCHAR(100) NOT NULL, 
                        PRIMARY_KEY VARCHAR(100) NOT NULL, 
                        NODE_ID VARCHAR(50) NOT NULL, 
                        TYPEFACT VARCHAR(255) ,
                        CODPAYS INTEGER , 
                        SERVICE VARCHAR(24) , 
                        COMPLNOM VARCHAR(38) , 
                        DEVISE VARCHAR(3),
                        IDBANCINT VARCHAR(11) ,
                        NUMSEQUENCE INTEGER ,
                        DTEIDTIERS DATE ,
                        TITCPTE VARCHAR(32) ,
                        CP VARCHAR(5) , 
                        DESCRIPTION VARCHAR(100) , 
                        REFTIERS VARCHAR(30) ,
                        DTEBANC DATE , 
                        ADR3 VARCHAR(38) , 
                        ADR2 VARCHAR(38) , 
                        CATTIERS VARCHAR(255) ,
                        NATJUR VARCHAR(255) , 
                        ADR1 VARCHAR(38) , 
                        NATIDTIERS VARCHAR(255) , 
                        DTEADR DATE ,
                        PRENOM VARCHAR(38) , 
                        LIBBANC VARCHAR(24) , 
                        NUMTVA VARCHAR(24) , 
                        CODRES VARCHAR(255) , 
                        NOM VARCHAR(38) , 
                        ANNEE VARCHAR(255) , 
                        CLERIB INTEGER , 
                        TYPTIERS VARCHAR(255) , 
                        CODEETAB VARCHAR(5) , 
                        VILLE VARCHAR(38) , 
                        DATE DATE , 
                        CODEGUIC VARCHAR(5) , 
                        IDPAYINT VARCHAR(4) , 
                        IDTIERS VARCHAR(30) , 
                        TYPETIERSFACTURE VARCHAR(255) , 
                        TYPADR VARCHAR(255) , 
                        DTEMALADE DATE , 
                        CIVILITE VARCHAR(10) ,
                        IDCPTE VARCHAR(11) , 
                        IDVER DECIMAL , 
                        MONTANT_HT DECIMAL(14,2), 
                        MONTANT_TVA DECIMAL(14,2), 
                        MONTANT_TTC DECIMAL(14,2), 
                        INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
                        INDEX IX_${base-name}_DC (DOC_ID) 
                     ) TYPE MYISAM </table>
                <table type="index" id="PES_FACTURE_PESFACTURE_TIERS_IX"
                    base-name="PES_FACTURE_PESFACTURE_TIERS_IX" version="1" main="false"
                    based-on="key2"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE
                    VARCHAR(30) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL,
                    NODE_ID VARCHAR(50) NOT NULL, DTEBANC DATE , VILLE VARCHAR(38) , TYPADR
                    VARCHAR(255) , CP VARCHAR(5) , CATTIERS VARCHAR(255) , TYPETIERSFACTURE
                    VARCHAR(255) , NUMTVA VARCHAR(24) , IDTIERS VARCHAR(30) , CODRES VARCHAR(255) ,
                    CLERIB INTEGER , CODEGUIC VARCHAR(5) , CODPAYS INTEGER , PRENOM VARCHAR(38) ,
                    IDPAYINT VARCHAR(4) , SERVICE VARCHAR(24) , IDBANCINT VARCHAR(11) , TYPTIERS
                    VARCHAR(255) , REFTIERS VARCHAR(30) , NOM VARCHAR(38) , CODEETAB VARCHAR(5) ,
                    ADR3 VARCHAR(38) , NATIDTIERS VARCHAR(255) , IDCPTE VARCHAR(11) , ADR2
                    VARCHAR(38) , TITCPTE VARCHAR(32) , LIBBANC VARCHAR(24) , ADR1 VARCHAR(38) ,
                    DTEIDTIERS DATE , NATJUR VARCHAR(255) , DTEADR DATE , DTEMALADE DATE , CIVILITE
                    VARCHAR(10) , COMPLNOM VARCHAR(38) , INDEX IX_${base-name}_BC
                    (COLLECTIVITE,BUDGET,DOC_ID), INDEX IX_${base-name}_DC (DOC_ID) ) TYPE MYISAM </table>
                <table type="index" id="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"
                    base-name="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX" version="3" main="false"
                    based-on="key3"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE
                    VARCHAR(30) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL,
                    NODE_ID VARCHAR(50) NOT NULL, TYPEFACT VARCHAR(255) , CODPAYS INTEGER , SERVICE
                    VARCHAR(24) , COMPLNOM VARCHAR(38) , MTTOTALTTC DECIMAL(14,2), IDBANCINT
                    VARCHAR(11) , OBJET VARCHAR(160) , DATEEMISSION DATE , TEXTEGENERATEUR
                    VARCHAR(160) , DTEIDTIERS DATE , TITCPTE VARCHAR(32) , CP VARCHAR(5) , REFTIERS
                    VARCHAR(30) , DTEBANC DATE , ADR3 VARCHAR(38) , ADR2 VARCHAR(38) , CATTIERS
                    VARCHAR(255) , NATJUR VARCHAR(255) , ADR1 VARCHAR(38) , NATIDTIERS VARCHAR(255)
                    , MTTOTALTVA DECIMAL(14,2), DTEADR DATE , MOYENPAIEMENT VARCHAR(255) ,
                    NUMEROCONTRAT VARCHAR(50) , PRENOM VARCHAR(38) , LIBBANC VARCHAR(24) ,
                    NUMEROFACTURE VARCHAR(50) , NUMEROMARCHE VARCHAR(50) , NUMTVA VARCHAR(24) ,
                    MTTOTALHT DECIMAL(14,2), CODRES VARCHAR(255) , NOM VARCHAR(38) ,
                    MODALITESREGLEMENT VARCHAR(250) , CLERIB INTEGER , TYPTIERS VARCHAR(255) ,
                    CODEETAB VARCHAR(5) , DATEREGLEMENT DATE , CONDITIONSGEN VARCHAR(250) , VILLE
                    VARCHAR(38) , CODEGUIC VARCHAR(5) , IDPAYINT VARCHAR(4) , IDTIERS VARCHAR(30) ,
                    TYPETIERSFACTURE VARCHAR(255) , TYPADR VARCHAR(255) , DTEMALADE DATE ,
                    TAUXREMISE DECIMAL(6,3), CIVILITE VARCHAR(10) , IDCPTE VARCHAR(11) , MTREMISE
                    DECIMAL(14,2), FOURNISSEUR VARCHAR(38), NUMERO_CARTEACHAT VARCHAR(30),
                    NUMERO_COMMANDE VARCHAR(50), MOIS_DATE_EMISSION VARCHAR(2), ANNEE_DATE_EMISSION
                    VARCHAR(4), ID_LOGEMENT VARCHAR(30), INDEX IX_${base-name}_BC
                    (COLLECTIVITE,BUDGET,DOC_ID), INDEX IX_${base-name}_DC (DOC_ID) ) TYPE MYISAM
                    <patch from-version="1">
                        <sql failonerror="false">ALTER TABLE ${base-name} ADD ANNEE_DATE_EMISSION VARCHAR(4)</sql>
                        <sql failonerror="false">ALTER TABLE ${base-name} ADD ID_LOGEMENT VARCHAR(30)</sql>
                    </patch>
                    <patch from-version="2">
                        <sql failonerror="false">ALTER TABLE ${base-name} ADD ID_LOGEMENT VARCHAR(30)</sql>
                    </patch>
                    
                </table>
                <table type="index" id="PES_FACTURE_FACTUREINDIV_REFERENCE_IX"
                    base-name="PES_FACTURE_FACTUREINDIV_REFERENCE_IX" version="1" main="false"
                    based-on="key4"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE
                    VARCHAR(30) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL,
                    NODE_ID VARCHAR(50) NOT NULL, NUMEROPIECE VARCHAR(50) , TYPEPIECE VARCHAR(255) ,
                    NUMLIGNE INTEGER , INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), INDEX
                    IX_${base-name}_DC (DOC_ID) ) TYPE MYISAM </table>
                <table type="index" id="PES_FACTURE_FACTUREINDIV_TIERS_IX"
                    base-name="PES_FACTURE_FACTUREINDIV_TIERS_IX" version="1" main="false"
                    based-on="key5"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE
                    VARCHAR(30) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL,
                    NODE_ID VARCHAR(50) NOT NULL, DTEBANC DATE , VILLE VARCHAR(38) , TYPADR
                    VARCHAR(255) , CP VARCHAR(5) , CATTIERS VARCHAR(255) , TYPETIERSFACTURE
                    VARCHAR(255) , NUMTVA VARCHAR(24) , IDTIERS VARCHAR(30) , CODRES VARCHAR(255) ,
                    CLERIB INTEGER , CODEGUIC VARCHAR(5) , CODPAYS INTEGER , PRENOM VARCHAR(38) ,
                    IDPAYINT VARCHAR(4) , SERVICE VARCHAR(24) , IDBANCINT VARCHAR(11) , TYPTIERS
                    VARCHAR(255) , REFTIERS VARCHAR(30) , NOM VARCHAR(38) , CODEETAB VARCHAR(5) ,
                    ADR3 VARCHAR(38) , NATIDTIERS VARCHAR(255) , IDCPTE VARCHAR(11) , ADR2
                    VARCHAR(38) , TITCPTE VARCHAR(32) , LIBBANC VARCHAR(24) , ADR1 VARCHAR(38) ,
                    DTEIDTIERS DATE , NATJUR VARCHAR(255) , DTEADR DATE , DTEMALADE DATE , CIVILITE
                    VARCHAR(10) , COMPLNOM VARCHAR(38) , INDEX IX_${base-name}_BC
                    (COLLECTIVITE,BUDGET,DOC_ID), INDEX IX_${base-name}_DC (DOC_ID) ) TYPE MYISAM </table>
                <table type="index" id="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"
                    base-name="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX" version="1" main="false"
                    based-on="key6"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE
                    VARCHAR(30) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL,
                    NODE_ID VARCHAR(50) NOT NULL, ORDRE INTEGER , CODEFONCTION VARCHAR(24) , MTTTC
                    DECIMAL(14,2), TAUX DECIMAL(6,3), MTREMISE DECIMAL(14,2), MTHT DECIMAL(14,2),
                    TAUXTVA DECIMAL(5,2), MTTVA DECIMAL(14,2), ORDREEDITION INTEGER , CODEPRODUIT
                    VARCHAR(24) , TAUXREMISE DECIMAL(6,3), CODENATURE VARCHAR(24) , LIBELLE
                    VARCHAR(100) , UNITE VARCHAR(38), QUANTITE DECIMAL(14,2), MTUNITAIRE
                    DECIMAL(16,4), MTBASE DECIMAL(5,2), INDEX IX_${base-name}_BC
                    (COLLECTIVITE,BUDGET,DOC_ID), INDEX IX_${base-name}_DC (DOC_ID) ) TYPE MYISAM </table>
                <table type="index" id="PES_FACTURE_LIGNEFACTURE_TIERS_IX"
                    base-name="PES_FACTURE_LIGNEFACTURE_TIERS_IX" version="1" main="false"
                    based-on="key7"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE
                    VARCHAR(30) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL,
                    NODE_ID VARCHAR(50) NOT NULL, DTEBANC DATE , VILLE VARCHAR(38) , TYPADR
                    VARCHAR(255) , CP VARCHAR(5) , CATTIERS VARCHAR(255) , TYPETIERSFACTURE
                    VARCHAR(255) , NUMTVA VARCHAR(24) , IDTIERS VARCHAR(30) , CODRES VARCHAR(255) ,
                    CLERIB INTEGER , CODEGUIC VARCHAR(5) , CODPAYS INTEGER , PRENOM VARCHAR(38) ,
                    IDPAYINT VARCHAR(4) , SERVICE VARCHAR(24) , IDBANCINT VARCHAR(11) , TYPTIERS
                    VARCHAR(255) , REFTIERS VARCHAR(30) , NOM VARCHAR(38) , CODEETAB VARCHAR(5) ,
                    ADR3 VARCHAR(38) , NATIDTIERS VARCHAR(255) , IDCPTE VARCHAR(11) , ADR2
                    VARCHAR(38) , TITCPTE VARCHAR(32) , LIBBANC VARCHAR(24) , ADR1 VARCHAR(38) ,
                    DTEIDTIERS DATE , NATJUR VARCHAR(255) , DTEADR DATE , DTEMALADE DATE , CIVILITE
                    VARCHAR(10) , COMPLNOM VARCHAR(38) , INDEX IX_${base-name}_BC
                    (COLLECTIVITE,BUDGET,DOC_ID), INDEX IX_${base-name}_DC (DOC_ID) ) TYPE MYISAM </table>
                <table type="index" id="PES_FACTURE_LIGNEFACTURE_REFERENCE_IX"
                    base-name="PES_FACTURE_LIGNEFACTURE_REFERENCE_IX" version="1" main="false"
                    based-on="key8"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE
                    VARCHAR(30) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL,
                    NODE_ID VARCHAR(50) NOT NULL, NUMEROPIECE VARCHAR(50) , TYPEPIECE VARCHAR(255) ,
                    NUMLIGNE INTEGER , INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), INDEX
                    IX_${base-name}_DC (DOC_ID) ) TYPE MYISAM </table>
                <table type="index" id="PES_FACTURE_FACTUREINDIV_DETAILTVA_IX"
                    base-name="PES_FACTURE_FACTUREINDIV_DETAILTVA_IX" version="1" main="false"
                    based-on="key9"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE
                    VARCHAR(30) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL,
                    NODE_ID VARCHAR(50) NOT NULL, TAUXTVA DECIMAL(5,2), MTTVA DECIMAL(14,2),
                    MTBASEHT DECIMAL(14,2), INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
                    INDEX IX_${base-name}_DC (DOC_ID) ) TYPE MYISAM </table>

                <!-- CRITERIA PERSO -->
                <criteria id="_CRI_PES_FACTURE_FOURNISSEUR"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_NOM">
                    <where-clause>(fn:string-compare(${table}.${column},fournisseur) AND
                        ${table}.TYPETIERSFACTURE='24')</where-clause>
                </criteria>
                <criteria id="_CRI_PES_FACTURE_MONTANT_HT" sql-index-id="SQI_PES_FACTURE_MONTANT_HT">
                    <where-clause>${table}.${column}##OPERATEUR:montantHT####VALEUR:montantHT##</where-clause>
                </criteria>
                <criteria id="_CRI_PES_FACTURE_MONTANT_TVA"
                    sql-index-id="SQI_PES_FACTURE_MONTANT_TVA">
                    <where-clause>${table}.${column}##OPERATEUR:montantTVA####VALEUR:montantTVA##</where-clause>
                </criteria>
                <criteria id="_CRI_PES_FACTURE_MONTANT_TTC"
                    sql-index-id="SQI_PES_FACTURE_MONTANT_TTC">
                    <where-clause>${table}.${column}##OPERATEUR:montantTTC####VALEUR:montantTTC##</where-clause>
                </criteria>
                <criteria id="_CRI_PES_FACTURE_NUMERO_CARTE"
                    sql-index-id="SQI_M_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMERO_CARTEACHAT2">
                    <where-clause>(fn:string-compare(${table}.${column},IdTiers))</where-clause>
                </criteria>
                <criteria id="_CRI_PES_FACTURE_NUMERO_COMMANDE"
                    sql-index-id="SQI_M_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMERO_COMMANDE2">
                    <where-clause>(fn:string-compare(${table}.${column},NumeroCommande))</where-clause>
                </criteria>
                <criteria id="_CRI_PES_FACTURE_PRIXUNITAIRE"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_MTUNITAIRE">
                    <where-clause>${table}.${column}##OPERATEUR:prixht####VALEUR:prixht##</where-clause>
                </criteria>
                <criteria id="_CRI_PES_FACTURE_QUANTITE"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_QUANTITE">
                    <where-clause>${table}.${column}##OPERATEUR:quantite####VALEUR:quantite##</where-clause>
                </criteria>

                <!-- CRITERIA /PES_ReleveCarteAchat/PES_CarteAchat -->

                <!-- CRITERIA /PES_ReleveCarteAchat/PES_CarteAchat/PESFacture -->
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TYPEFACT" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TYPEFACT">
                    <where-clause>fn:string-compare(${table}.${column},TypeFact)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_CODPAYS" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_CODPAYS">
                    <where-clause>${table}.${column}##OPERATEUR:CodPays####VALEUR:CodPays##</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_SERVICE" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_SERVICE">
                    <where-clause>fn:string-compare(${table}.${column},Service)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_COMPLNOM" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_COMPLNOM">
                    <where-clause>fn:string-compare(${table}.${column},ComplNom)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_DEVISE" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_DEVISE">
                    <where-clause>fn:string-compare(${table}.${column},Devise)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_IDBANCINT" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_IDBANCINT">
                    <where-clause>fn:string-compare(${table}.${column},IdBancInt)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_NUMSEQUENCE" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_NUMSEQUENCE">
                    <where-clause>${table}.${column}##OPERATEUR:NumSequence####VALEUR:NumSequence##</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_DTEIDTIERS" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_DTEIDTIERS">
                    <where-clause>fn:date-compare(${table}.${column},DteIdTiers)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TITCPTE" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TITCPTE">
                    <where-clause>fn:string-compare(${table}.${column},TitCpte)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_CP" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_CP">
                    <where-clause>fn:string-compare(${table}.${column},Cp)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_DESCRIPTION" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_DESCRIPTION">
                    <where-clause>fn:string-compare(${table}.${column},Description)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_REFTIERS" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_REFTIERS">
                    <where-clause>fn:string-compare(${table}.${column},RefTiers)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_DTEBANC" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_DTEBANC">
                    <where-clause>fn:date-compare(${table}.${column},DteBanc)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_ADR3" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_ADR3">
                    <where-clause>fn:string-compare(${table}.${column},Adr3)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_ADR2" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_ADR2">
                    <where-clause>fn:string-compare(${table}.${column},Adr2)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_CATTIERS" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_CATTIERS">
                    <where-clause>fn:string-compare(${table}.${column},CatTiers)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_NATJUR" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_NATJUR">
                    <where-clause>fn:string-compare(${table}.${column},NatJur)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_ADR1" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_ADR1">
                    <where-clause>fn:string-compare(${table}.${column},Adr1)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_NATIDTIERS" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_NATIDTIERS">
                    <where-clause>fn:string-compare(${table}.${column},NatIdTiers)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_DTEADR" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_DTEADR">
                    <where-clause>fn:date-compare(${table}.${column},DteAdr)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_PRENOM" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_PRENOM">
                    <where-clause>fn:string-compare(${table}.${column},Prenom)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_LIBBANC" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_LIBBANC">
                    <where-clause>fn:string-compare(${table}.${column},LibBanc)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_NUMTVA" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_NUMTVA">
                    <where-clause>fn:string-compare(${table}.${column},NumTVA)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_CODRES" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_CODRES">
                    <where-clause>fn:string-compare(${table}.${column},CodRes)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_NOM" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_NOM">
                    <where-clause>fn:string-compare(${table}.${column},Nom)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_ANNEE" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_ANNEE">
                    <where-clause>fn:string-compare(${table}.${column},Annee)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_CLERIB" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_CLERIB">
                    <where-clause>${table}.${column}##OPERATEUR:CleRib####VALEUR:CleRib##</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TYPTIERS" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TYPTIERS">
                    <where-clause>fn:string-compare(${table}.${column},TypTiers)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_CODEETAB" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_CODEETAB">
                    <where-clause>fn:string-compare(${table}.${column},CodeEtab)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_VILLE" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_VILLE">
                    <where-clause>fn:string-compare(${table}.${column},Ville)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_DATE" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_DATE">
                    <where-clause>fn:date-compare(${table}.${column},Date)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_CODEGUIC" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_CODEGUIC">
                    <where-clause>fn:string-compare(${table}.${column},CodeGuic)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_IDPAYINT" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_IDPAYINT">
                    <where-clause>fn:string-compare(${table}.${column},IdPayInt)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_IDTIERS" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_IDTIERS">
                    <where-clause>fn:string-compare(${table}.${column},IdTiers)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TYPETIERSFACTURE" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TYPETIERSFACTURE">
                    <where-clause>fn:string-compare(${table}.${column},TypeTiersFacture)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TYPADR" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TYPADR">
                    <where-clause>fn:string-compare(${table}.${column},TypAdr)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_DTEMALADE" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_DTEMALADE">
                    <where-clause>fn:date-compare(${table}.${column},DteMalade)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_CIVILITE" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_CIVILITE">
                    <where-clause>fn:string-compare(${table}.${column},Civilite)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_IDCPTE" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_IDCPTE">
                    <where-clause>fn:string-compare(${table}.${column},IdCpte)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_IDVER" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_IDVER">
                    <where-clause>${table}.${column}##OPERATEUR:IdVer####VALEUR:IdVer##</where-clause>
                </criteria>

                <!-- CRITERIA /PES_ReleveCarteAchat/PES_CarteAchat/PESFacture/Tiers -->
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_DTEBANC" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_DTEBANC">
                    <where-clause>fn:date-compare(${table}.${column},DteBanc)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_VILLE" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_VILLE">
                    <where-clause>fn:string-compare(${table}.${column},Ville)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_TYPADR" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_TYPADR">
                    <where-clause>fn:string-compare(${table}.${column},TypAdr)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_CP" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_CP">
                    <where-clause>fn:string-compare(${table}.${column},CP)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_CATTIERS" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_CATTIERS">
                    <where-clause>fn:string-compare(${table}.${column},CatTiers)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_TYPETIERSFACTURE" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_TYPETIERSFACTURE">
                    <where-clause>fn:string-compare(${table}.${column},TypeTiersFacture)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_NUMTVA" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_NUMTVA">
                    <where-clause>fn:string-compare(${table}.${column},NumTVA)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_IDTIERS" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_IDTIERS">
                    <where-clause>fn:string-compare(${table}.${column},IdTiers)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_CODRES" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_CODRES">
                    <where-clause>fn:string-compare(${table}.${column},CodRes)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_CLERIB" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_CLERIB">
                    <where-clause>${table}.${column}##OPERATEUR:CleRib####VALEUR:CleRib##</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_CODEGUIC" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_CODEGUIC">
                    <where-clause>fn:string-compare(${table}.${column},CodeGuic)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_CODPAYS" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_CODPAYS">
                    <where-clause>${table}.${column}##OPERATEUR:CodPays####VALEUR:CodPays##</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_PRENOM" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_PRENOM">
                    <where-clause>fn:string-compare(${table}.${column},Prenom)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_IDPAYINT" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_IDPAYINT">
                    <where-clause>fn:string-compare(${table}.${column},IdPayInt)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_SERVICE" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_SERVICE">
                    <where-clause>fn:string-compare(${table}.${column},Service)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_IDBANCINT" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_IDBANCINT">
                    <where-clause>fn:string-compare(${table}.${column},IdBancInt)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_TYPTIERS" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_TYPTIERS">
                    <where-clause>fn:string-compare(${table}.${column},TypTiers)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_REFTIERS" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_REFTIERS">
                    <where-clause>fn:string-compare(${table}.${column},RefTiers)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_NOM" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_NOM">
                    <where-clause>fn:string-compare(${table}.${column},Nom)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_CODEETAB" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_CODEETAB">
                    <where-clause>fn:string-compare(${table}.${column},CodeEtab)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_ADR3" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_ADR3">
                    <where-clause>fn:string-compare(${table}.${column},Adr3)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_NATIDTIERS" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_NATIDTIERS">
                    <where-clause>fn:string-compare(${table}.${column},NatIdTiers)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_IDCPTE" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_IDCPTE">
                    <where-clause>fn:string-compare(${table}.${column},IdCpte)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_ADR2" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_ADR2">
                    <where-clause>fn:string-compare(${table}.${column},Adr2)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_TITCPTE" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_TITCPTE">
                    <where-clause>fn:string-compare(${table}.${column},TitCpte)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_LIBBANC" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_LIBBANC">
                    <where-clause>fn:string-compare(${table}.${column},LibBanc)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_ADR1" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_ADR1">
                    <where-clause>fn:string-compare(${table}.${column},Adr1)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_DTEIDTIERS" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_DTEIDTIERS">
                    <where-clause>fn:date-compare(${table}.${column},DteIdTiers)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_NATJUR" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_NATJUR">
                    <where-clause>fn:string-compare(${table}.${column},NatJur)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_DTEADR" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_DTEADR">
                    <where-clause>fn:date-compare(${table}.${column},DteAdr)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_DTEMALADE" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_DTEMALADE">
                    <where-clause>fn:date-compare(${table}.${column},DteMalade)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_CIVILITE" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_CIVILITE">
                    <where-clause>fn:string-compare(${table}.${column},Civilite)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_COMPLNOM" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_COMPLNOM">
                    <where-clause>fn:string-compare(${table}.${column},ComplNom)</where-clause>
                </criteria>

                <!-- CRITERIA /PES_ReleveCarteAchat/PES_CarteAchat/PESFacture/FactureIndiv -->
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TYPEFACT" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TYPEFACT">
                    <where-clause>fn:string-compare(${table}.${column},TypeFact)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CODPAYS" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CODPAYS">
                    <where-clause>${table}.${column}##OPERATEUR:CodPays####VALEUR:CodPays##</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_SERVICE" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_SERVICE">
                    <where-clause>fn:string-compare(${table}.${column},Service)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_COMPLNOM" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_COMPLNOM">
                    <where-clause>fn:string-compare(${table}.${column},ComplNom)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MTTOTALTTC" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MTTOTALTTC">
                    <where-clause>${table}.${column}##OPERATEUR:MtTotalTTC####VALEUR:MtTotalTTC##</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_IDBANCINT" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_IDBANCINT">
                    <where-clause>fn:string-compare(${table}.${column},IdBancInt)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_OBJET" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_OBJET">
                    <where-clause>fn:string-compare(${table}.${column},Objet)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DATEEMISSION" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DATEEMISSION">
                    <where-clause>fn:date-compare(${table}.${column},DateEmission)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TEXTEGENERATEUR" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TEXTEGENERATEUR">
                    <where-clause>fn:string-compare(${table}.${column},TexteGenerateur)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DTEIDTIERS" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DTEIDTIERS">
                    <where-clause>fn:date-compare(${table}.${column},DteIdTiers)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TITCPTE" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TITCPTE">
                    <where-clause>fn:string-compare(${table}.${column},TitCpte)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CP" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CP">
                    <where-clause>fn:string-compare(${table}.${column},Cp)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_REFTIERS" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_REFTIERS">
                    <where-clause>fn:string-compare(${table}.${column},RefTiers)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DTEBANC" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DTEBANC">
                    <where-clause>fn:date-compare(${table}.${column},DteBanc)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_ADR3" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_ADR3">
                    <where-clause>fn:string-compare(${table}.${column},Adr3)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_ADR2" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_ADR2">
                    <where-clause>fn:string-compare(${table}.${column},Adr2)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CATTIERS" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CATTIERS">
                    <where-clause>fn:string-compare(${table}.${column},CatTiers)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NATJUR" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NATJUR">
                    <where-clause>fn:string-compare(${table}.${column},NatJur)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_ADR1" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_ADR1">
                    <where-clause>fn:string-compare(${table}.${column},Adr1)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NATIDTIERS" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NATIDTIERS">
                    <where-clause>fn:string-compare(${table}.${column},NatIdTiers)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MTTOTALTVA" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MTTOTALTVA">
                    <where-clause>${table}.${column}##OPERATEUR:MtTotalTVA####VALEUR:MtTotalTVA##</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DTEADR" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DTEADR">
                    <where-clause>fn:date-compare(${table}.${column},DteAdr)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MOYENPAIEMENT" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MOYENPAIEMENT">
                    <where-clause>fn:string-compare(${table}.${column},MoyenPaiement)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMEROCONTRAT" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMEROCONTRAT">
                    <where-clause>fn:string-compare(${table}.${column},NumeroContrat)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_PRENOM" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_PRENOM">
                    <where-clause>fn:string-compare(${table}.${column},Prenom)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_LIBBANC" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_LIBBANC">
                    <where-clause>fn:string-compare(${table}.${column},LibBanc)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMEROFACTURE" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMEROFACTURE">
                    <where-clause>fn:string-compare(${table}.${column},NumeroFacture)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMEROMARCHE" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMEROMARCHE">
                    <where-clause>fn:string-compare(${table}.${column},NumeroMarche)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMTVA" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMTVA">
                    <where-clause>fn:string-compare(${table}.${column},NumTVA)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MTTOTALHT" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MTTOTALHT">
                    <where-clause>${table}.${column}##OPERATEUR:MtTotalHT####VALEUR:MtTotalHT##</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CODRES" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CODRES">
                    <where-clause>fn:string-compare(${table}.${column},CodRes)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NOM" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NOM">
                    <where-clause>fn:string-compare(${table}.${column},Nom)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MODALITESREGLEMENT" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MODALITESREGLEMENT">
                    <where-clause>fn:string-compare(${table}.${column},ModalitesReglement)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CLERIB" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CLERIB">
                    <where-clause>${table}.${column}##OPERATEUR:CleRib####VALEUR:CleRib##</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TYPTIERS" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TYPTIERS">
                    <where-clause>fn:string-compare(${table}.${column},TypTiers)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CODEETAB" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CODEETAB">
                    <where-clause>fn:string-compare(${table}.${column},CodeEtab)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DATEREGLEMENT" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DATEREGLEMENT">
                    <where-clause>fn:date-compare(${table}.${column},DateReglement)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CONDITIONSGEN" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CONDITIONSGEN">
                    <where-clause>fn:string-compare(${table}.${column},ConditionsGen)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_VILLE" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_VILLE">
                    <where-clause>fn:string-compare(${table}.${column},Ville)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CODEGUIC" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CODEGUIC">
                    <where-clause>fn:string-compare(${table}.${column},CodeGuic)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_IDPAYINT" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_IDPAYINT">
                    <where-clause>fn:string-compare(${table}.${column},IdPayInt)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_IDTIERS" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_IDTIERS">
                    <where-clause>fn:string-compare(${table}.${column},IdTiers)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TYPETIERSFACTURE" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TYPETIERSFACTURE">
                    <where-clause>fn:string-compare(${table}.${column},TypeTiersFacture)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TYPADR" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TYPADR">
                    <where-clause>fn:string-compare(${table}.${column},TypAdr)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DTEMALADE" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DTEMALADE">
                    <where-clause>fn:date-compare(${table}.${column},DteMalade)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TAUXREMISE" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TAUXREMISE">
                    <where-clause>${table}.${column}##OPERATEUR:TauxRemise####VALEUR:TauxRemise##</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CIVILITE" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CIVILITE">
                    <where-clause>fn:string-compare(${table}.${column},Civilite)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_IDCPTE" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_IDCPTE">
                    <where-clause>fn:string-compare(${table}.${column},IdCpte)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MTREMISE" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MTREMISE">
                    <where-clause>${table}.${column}##OPERATEUR:MtRemise####VALEUR:MtRemise##</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_FOURNISSEUR" type="1"
                    sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_FOURNISSEUR">
                    <where-clause>fn:string-compare(${table}.${column},Fournisseur)</where-clause>
                </criteria>

                <!-- CRITERIA /PES_ReleveCarteAchat/PES_CarteAchat/PESFacture/FactureIndiv/Reference -->
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_REFERENCE_NUMEROPIECE" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_REFERENCE_NUMEROPIECE">
                    <where-clause>fn:string-compare(${table}.${column},NumeroPiece)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_REFERENCE_TYPEPIECE" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_REFERENCE_TYPEPIECE">
                    <where-clause>fn:string-compare(${table}.${column},TypePiece)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_REFERENCE_NUMLIGNE" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_REFERENCE_NUMLIGNE">
                    <where-clause>${table}.${column}##OPERATEUR:NumLigne####VALEUR:NumLigne##</where-clause>
                </criteria>

                <!-- CRITERIA /PES_ReleveCarteAchat/PES_CarteAchat/PESFacture/FactureIndiv/Tiers -->
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_DTEBANC" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_DTEBANC">
                    <where-clause>fn:date-compare(${table}.${column},DteBanc)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_VILLE" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_VILLE">
                    <where-clause>fn:string-compare(${table}.${column},Ville)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_TYPADR" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_TYPADR">
                    <where-clause>fn:string-compare(${table}.${column},TypAdr)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_CP" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CP">
                    <where-clause>fn:string-compare(${table}.${column},CP)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_CATTIERS" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CATTIERS">
                    <where-clause>fn:string-compare(${table}.${column},CatTiers)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_TYPETIERSFACTURE" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_TYPETIERSFACTURE">
                    <where-clause>fn:string-compare(${table}.${column},TypeTiersFacture)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_NUMTVA" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_NUMTVA">
                    <where-clause>fn:string-compare(${table}.${column},NumTVA)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_IDTIERS" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_IDTIERS">
                    <where-clause>fn:string-compare(${table}.${column},IdTiers)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_CODRES" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CODRES">
                    <where-clause>fn:string-compare(${table}.${column},CodRes)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_CLERIB" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CLERIB">
                    <where-clause>${table}.${column}##OPERATEUR:CleRib####VALEUR:CleRib##</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_CODEGUIC" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CODEGUIC">
                    <where-clause>fn:string-compare(${table}.${column},CodeGuic)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_CODPAYS" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CODPAYS">
                    <where-clause>${table}.${column}##OPERATEUR:CodPays####VALEUR:CodPays##</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_PRENOM" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_PRENOM">
                    <where-clause>fn:string-compare(${table}.${column},Prenom)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_IDPAYINT" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_IDPAYINT">
                    <where-clause>fn:string-compare(${table}.${column},IdPayInt)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_SERVICE" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_SERVICE">
                    <where-clause>fn:string-compare(${table}.${column},Service)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_IDBANCINT" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_IDBANCINT">
                    <where-clause>fn:string-compare(${table}.${column},IdBancInt)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_TYPTIERS" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_TYPTIERS">
                    <where-clause>fn:string-compare(${table}.${column},TypTiers)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_REFTIERS" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_REFTIERS">
                    <where-clause>fn:string-compare(${table}.${column},RefTiers)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_NOM" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_NOM">
                    <where-clause>fn:string-compare(${table}.${column},Nom)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_CODEETAB" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CODEETAB">
                    <where-clause>fn:string-compare(${table}.${column},CodeEtab)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_ADR3" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_ADR3">
                    <where-clause>fn:string-compare(${table}.${column},Adr3)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_NATIDTIERS" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_NATIDTIERS">
                    <where-clause>fn:string-compare(${table}.${column},NatIdTiers)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_IDCPTE" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_IDCPTE">
                    <where-clause>fn:string-compare(${table}.${column},IdCpte)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_ADR2" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_ADR2">
                    <where-clause>fn:string-compare(${table}.${column},Adr2)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_TITCPTE" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_TITCPTE">
                    <where-clause>fn:string-compare(${table}.${column},TitCpte)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_LIBBANC" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_LIBBANC">
                    <where-clause>fn:string-compare(${table}.${column},LibBanc)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_ADR1" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_ADR1">
                    <where-clause>fn:string-compare(${table}.${column},Adr1)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_DTEIDTIERS" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_DTEIDTIERS">
                    <where-clause>fn:date-compare(${table}.${column},DteIdTiers)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_NATJUR" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_NATJUR">
                    <where-clause>fn:string-compare(${table}.${column},NatJur)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_DTEADR" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_DTEADR">
                    <where-clause>fn:date-compare(${table}.${column},DteAdr)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_DTEMALADE" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_DTEMALADE">
                    <where-clause>fn:date-compare(${table}.${column},DteMalade)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_CIVILITE" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CIVILITE">
                    <where-clause>fn:string-compare(${table}.${column},Civilite)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_COMPLNOM" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_COMPLNOM">
                    <where-clause>fn:string-compare(${table}.${column},ComplNom)</where-clause>
                </criteria>

                <!-- CRITERIA /PES_ReleveCarteAchat/PES_CarteAchat/PESFacture/FactureIndiv/LigneFacture -->
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_ORDRE" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_ORDRE">
                    <where-clause>${table}.${column}##OPERATEUR:Ordre####VALEUR:Ordre##</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_CODEFONCTION" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_CODEFONCTION">
                    <where-clause>fn:string-compare(${table}.${column},CodeFonction)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_MTTTC" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_MTTTC">
                    <where-clause>${table}.${column}##OPERATEUR:MtTTC####VALEUR:MtTTC##</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_TAUX" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_TAUX">
                    <where-clause>${table}.${column}##OPERATEUR:Taux####VALEUR:Taux##</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_MTREMISE" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_MTREMISE">
                    <where-clause>${table}.${column}##OPERATEUR:MtRemise####VALEUR:MtRemise##</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_MTHT" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_MTHT">
                    <where-clause>${table}.${column}##OPERATEUR:MtHT####VALEUR:MtHT##</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_TAUXTVA" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_TAUXTVA">
                    <where-clause>${table}.${column}##OPERATEUR:TauxTVA####VALEUR:TauxTVA##</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_MTTVA" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_MTTVA">
                    <where-clause>${table}.${column}##OPERATEUR:MtTVA####VALEUR:MtTVA##</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_ORDREEDITION" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_ORDREEDITION">
                    <where-clause>${table}.${column}##OPERATEUR:OrdreEdition####VALEUR:OrdreEdition##</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_CODEPRODUIT" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_CODEPRODUIT">
                    <where-clause>${table}.${column}=&quot;##VALEUR:CodeProduit##&quot;</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_TAUXREMISE" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_TAUXREMISE">
                    <where-clause>${table}.${column}##OPERATEUR:TauxRemise####VALEUR:TauxRemise##</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_CODENATURE" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_CODENATURE">
                    <where-clause>${table}.${column}=&quot;##VALEUR:CodeNature##&quot;</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_LIBELLE" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_LIBELLE">
                    <where-clause>fn:string-compare(${table}.${column},Libelle)</where-clause>
                </criteria>

                <!-- CRITERIA /PES_ReleveCarteAchat/PES_CarteAchat/PESFacture/FactureIndiv/LigneFacture/Tiers -->
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_DTEBANC" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_DTEBANC">
                    <where-clause>fn:date-compare(${table}.${column},DteBanc)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_VILLE" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_VILLE">
                    <where-clause>fn:string-compare(${table}.${column},Ville)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_TYPADR" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_TYPADR">
                    <where-clause>fn:string-compare(${table}.${column},TypAdr)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_CP" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_CP">
                    <where-clause>fn:string-compare(${table}.${column},CP)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_CATTIERS" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_CATTIERS">
                    <where-clause>fn:string-compare(${table}.${column},CatTiers)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_TYPETIERSFACTURE" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_TYPETIERSFACTURE">
                    <where-clause>fn:string-compare(${table}.${column},TypeTiersFacture)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_NUMTVA" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_NUMTVA">
                    <where-clause>fn:string-compare(${table}.${column},NumTVA)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_IDTIERS" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_IDTIERS">
                    <where-clause>fn:string-compare(${table}.${column},IdTiers)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_CODRES" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_CODRES">
                    <where-clause>fn:string-compare(${table}.${column},CodRes)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_CLERIB" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_CLERIB">
                    <where-clause>${table}.${column}##OPERATEUR:CleRib####VALEUR:CleRib##</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_CODEGUIC" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_CODEGUIC">
                    <where-clause>fn:string-compare(${table}.${column},CodeGuic)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_CODPAYS" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_CODPAYS">
                    <where-clause>${table}.${column}##OPERATEUR:CodPays####VALEUR:CodPays##</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_PRENOM" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_PRENOM">
                    <where-clause>fn:string-compare(${table}.${column},Prenom)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_IDPAYINT" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_IDPAYINT">
                    <where-clause>fn:string-compare(${table}.${column},IdPayInt)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_SERVICE" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_SERVICE">
                    <where-clause>fn:string-compare(${table}.${column},Service)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_IDBANCINT" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_IDBANCINT">
                    <where-clause>fn:string-compare(${table}.${column},IdBancInt)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_TYPTIERS" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_TYPTIERS">
                    <where-clause>fn:string-compare(${table}.${column},TypTiers)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_REFTIERS" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_REFTIERS">
                    <where-clause>fn:string-compare(${table}.${column},RefTiers)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_NOM" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_NOM">
                    <where-clause>fn:string-compare(${table}.${column},Nom)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_CODEETAB" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_CODEETAB">
                    <where-clause>fn:string-compare(${table}.${column},CodeEtab)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_ADR3" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_ADR3">
                    <where-clause>fn:string-compare(${table}.${column},Adr3)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_NATIDTIERS" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_NATIDTIERS">
                    <where-clause>fn:string-compare(${table}.${column},NatIdTiers)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_IDCPTE" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_IDCPTE">
                    <where-clause>fn:string-compare(${table}.${column},IdCpte)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_ADR2" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_ADR2">
                    <where-clause>fn:string-compare(${table}.${column},Adr2)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_TITCPTE" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_TITCPTE">
                    <where-clause>fn:string-compare(${table}.${column},TitCpte)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_LIBBANC" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_LIBBANC">
                    <where-clause>fn:string-compare(${table}.${column},LibBanc)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_ADR1" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_ADR1">
                    <where-clause>fn:string-compare(${table}.${column},Adr1)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_DTEIDTIERS" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_DTEIDTIERS">
                    <where-clause>fn:date-compare(${table}.${column},DteIdTiers)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_NATJUR" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_NATJUR">
                    <where-clause>fn:string-compare(${table}.${column},NatJur)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_DTEADR" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_DTEADR">
                    <where-clause>fn:date-compare(${table}.${column},DteAdr)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_DTEMALADE" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_DTEMALADE">
                    <where-clause>fn:date-compare(${table}.${column},DteMalade)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_CIVILITE" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_CIVILITE">
                    <where-clause>fn:string-compare(${table}.${column},Civilite)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_COMPLNOM" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_COMPLNOM">
                    <where-clause>fn:string-compare(${table}.${column},ComplNom)</where-clause>
                </criteria>

                <!-- CRITERIA /PES_ReleveCarteAchat/PES_CarteAchat/PESFacture/FactureIndiv/LigneFacture/reference -->
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_REFERENCE_NUMEROPIECE" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_REFERENCE_NUMEROPIECE">
                    <where-clause>fn:string-compare(${table}.${column},NumeroPiece)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_REFERENCE_TYPEPIECE" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_REFERENCE_TYPEPIECE">
                    <where-clause>fn:string-compare(${table}.${column},TypePiece)</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_REFERENCE_NUMLIGNE" type="1"
                    sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_REFERENCE_NUMLIGNE">
                    <where-clause>${table}.${column}##OPERATEUR:NumLigne####VALEUR:NumLigne##</where-clause>
                </criteria>

                <!-- CRITERIA /PES_ReleveCarteAchat/PES_CarteAchat/PESFacture/FactureIndiv/DetailTVA -->
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_DETAILTVA_TAUXTVA" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_DETAILTVA_TAUXTVA">
                    <where-clause>${table}.${column}##OPERATEUR:TauxTVA####VALEUR:TauxTVA##</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_DETAILTVA_MTTVA" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_DETAILTVA_MTTVA">
                    <where-clause>${table}.${column}##OPERATEUR:MtTVA####VALEUR:MtTVA##</where-clause>
                </criteria>
                <criteria id="CRI_PES_FACTURE_FACTUREINDIV_DETAILTVA_MTBASEHT" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_DETAILTVA_MTBASEHT">
                    <where-clause>${table}.${column}##OPERATEUR:MtBaseHT####VALEUR:MtBaseHT##</where-clause>
                </criteria>


                <!--  CRITERES POUR LE QUITTANCEMENT -->
                <criteria id="LOGEMENT_IDTIERS" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_IDTIERS">
                    <where-clause>(fn:string-compare(${table}.${column},IDTiers) AND ${table}.TYPETIERSFACTURE='30')</where-clause>
                </criteria>
                <criteria id="LOGEMENT_VILLE" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_VILLE">
                    <where-clause>(fn:string-compare(${table}.${column},Ville) AND ${table}.TYPETIERSFACTURE='30')</where-clause>
                </criteria>
                <criteria id="LOGEMENT_CP" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CP">
                    <where-clause>(fn:string-compare(${table}.${column},Cp) AND ${table}.TYPETIERSFACTURE='30')</where-clause>
                </criteria>
                <criteria id="LOGEMENT_ADR3" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_ADR3">
                    <where-clause>(fn:string-compare(${table}.${column},Adr3) AND ${table}.TYPETIERSFACTURE='30')</where-clause>
                </criteria>
                <criteria id="LOGEMENT_ADR2" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_ADR2">
                    <where-clause>(fn:string-compare(${table}.${column},Adr2) AND ${table}.TYPETIERSFACTURE='30')</where-clause>
                </criteria>
                <criteria id="LOGEMENT_ADR1" type="1"
                    sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_ADR1">
                    <where-clause>(fn:string-compare(${table}.${column},Adr1) AND ${table}.TYPETIERSFACTURE='30')</where-clause>
                </criteria>
                <criteria id="MOIS_DATE_EMISSION" type="1"
                    sql-index-id="SQI_M_PES_FACTURE_PESFACTURE_FACTUREINDIV_MOIS_DATE_EMISSION">
                    <where-clause>${table}.${column}=##VALEUR:Mois##</where-clause>
                </criteria>
                <criteria id="ANNEE_DATE_EMISSION" sql-index-id="SQI_M_PES_FACTURE_PESFACTURE_FACTUREINDIV_ANNEE_DATE_EMISSION" type="1">
                    <where-clause>${table}.${column}=##VALEUR:Annee##</where-clause>
                </criteria>
                
                <criteria id="ID_LOGEMENT" type="1"
                    sql-index-id="SQI_M_PES_FACTURE_PESFACTURE_FACTUREINDIV_ID_LOGEMENT">
                    <where-clause>(fn:string-compare(${table}.${column},IDLogement) AND
                        ${table}.TYPETIERSFACTURE='30')</where-clause>
                </criteria>

                <!-- SQL-INDEX PERSO -->
                <sql-index id="SQI_PES_FACTURE_MONTANT_HT"
                    path="/n:DOC_PES_Facture/n:PESFacture/@added:montantHT" column="MONTANT_HT"
                    datatype="decimal" table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_MONTANT_TVA"
                    path="/n:DOC_PES_Facture/n:PESFacture/@added:montantTVA" column="MONTANT_TVA"
                    datatype="decimal" table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_MONTANT_TTC"
                    path="/n:DOC_PES_Facture/n:PESFacture/@added:montantTTC" column="MONTANT_TTC"
                    datatype="decimal" table="PES_FACTURE_PESFACTURE_IX"/>
        <!--sql-index id="SQI_M_PES_FACTURE_PESFACTURE__NODE_ID"
            path="/n:n:DOC_PES_Facture/n:n:PESFacture/@added:generated-id" column="NODE_ID"
            datatype="string" table="PES_FACTURE_PESFACTURE_IX"/-->
                <!--sql-index id="SQI_M_PES_FACTURE_PESFACTURE_PRIMARYKEY"
                    path="/n:n:DOC_PES_Facture/n:n:PESFacture/@added:primarykey" column="PRIMARY_KEY"
                    datatype="string" table="PES_FACTURE_PESFACTURE_IX"/-->
                <!--sql-index id="SQI_M_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMERO_CARTEACHAT"
                    path="/n:n:DOC_PES_Facture/n:n:PESFacture/n:n:FactureIndiv/@added:numero_carteachat"
                    column="NUMERO_CARTEACHAT" datatype="string"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/-->
                <sql-index id="SQI_M_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMERO_CARTEACHAT2"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/@added:numero_carteachat"
                    column="NUMERO_CARTEACHAT" datatype="string"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <!--sql-index id="SQI_M_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMERO_COMMANDE"
                    path="/n:n:DOC_PES_Facture/n:n:PESFacture/n:n:FactureIndiv/@added:numero_commande"
                    column="NUMERO_COMMANDE" datatype="string"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/-->
                <sql-index id="SQI_M_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMERO_COMMANDE2"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/@added:numero_commande"
                    column="NUMERO_COMMANDE" datatype="string"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_M_PES_FACTURE_PESFACTURE_FACTUREINDIV_MOIS_DATE_EMISSION"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/@added:moisDateEmission"
                    column="MOIS_DATE_EMISSION" datatype="string"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <!--sql-index id="SQI_M_PES_FACTURE_PESFACTURE_FACTUREINDIV_MOIS_DATE_EMISSION2"
                    path="/n:n:DOC_PES_Facture/n:n:PESFacture/n:n:FactureIndiv/@added:moisDateEmission"
                    column="MOIS_DATE_EMISSION" datatype="string"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/-->
                <sql-index id="SQI_M_PES_FACTURE_PESFACTURE_FACTUREINDIV_ANNEE_DATE_EMISSION"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/@added:anneeDateEmission"
                    column="ANNEE_DATE_EMISSION" datatype="string"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <!--sql-index id="SQI_M_PES_FACTURE_PESFACTURE_FACTUREINDIV_ANNEE_DATE_EMISSION2"
                    path="/n:n:DOC_PES_Facture/n:n:PESFacture/n:n:FactureIndiv/@added:anneeDateEmission"
                    column="ANNEE_DATE_EMISSION" datatype="string"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/-->
                <sql-index id="SQI_M_PES_FACTURE_PESFACTURE_FACTUREINDIV_ID_LOGEMENT"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/@added:IDLogement"
                    column="ID_LOGEMENT" datatype="string"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <!--sql-index id="SQI_M_PES_FACTURE_PESFACTURE_FACTUREINDIV_ID_LOGEMENT2"
                    path="/n:n:DOC_PES_Facture/n:n:PESFacture/n:n:FactureIndiv/@added:IDLogement"
                    column="ID_LOGEMENT" datatype="string"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/-->


                <!-- SQL-INDEX /n:DOC_PES_Facture/n:PES_CarteAchat -->

                <!-- SQL-INDEX /n:DOC_PES_Facture/n:PESFacture -->
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_PRIMARYKEY"
                    path="/n:DOC_PES_Facture/n:PESFacture/@added:primarykey" column="PRIMARY_KEY"
                    datatype="string" table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE__NODE_ID"
                    path="/n:DOC_PES_Facture/n:PESFacture/@added:generated-id" column="NODE_ID"
                    datatype="string" table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TYPEFACT"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:TypeFact/@V" datatype="string"
                    column="TYPEFACT" table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_CODPAYS"
                    path="/n:DOC_PES_Facture/n:Emetteur/n:Adresse/n:CodPays/@V" datatype="integer"
                    column="CODPAYS" table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_SERVICE"
                    path="/n:DOC_PES_Facture/n:Emetteur/n:Service/@V" datatype="string" column="SERVICE"
                    table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_COMPLNOM"
                    path="/n:DOC_PES_Facture/n:Emetteur/n:InfoTiers/n:ComplNom/@V" datatype="string"
                    column="COMPLNOM" table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_DEVISE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Devise/@V" datatype="string" column="DEVISE"
                    table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_IDBANCINT"
                    path="/n:DOC_PES_Facture/n:Emetteur/n:CpteBancaire/n:IdBancInt/@V" datatype="string"
                    column="IDBANCINT" table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_NUMSEQUENCE"
                    path="/n:DOC_PES_Facture/n:NumSequence/@V" datatype="integer" column="NUMSEQUENCE"
                    table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_DTEIDTIERS"
                    path="/n:DOC_PES_Facture/n:Emetteur/n:InfoTiers/n:DteIdTiers/@V" datatype="date"
                    format="yyyy-MM-dd" column="DTEIDTIERS" table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TITCPTE"
                    path="/n:DOC_PES_Facture/n:Emetteur/n:CpteBancaire/n:TitCpte/@V" datatype="string"
                    column="TITCPTE" table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_CP"
                    path="/n:DOC_PES_Facture/n:Emetteur/n:Adresse/n:CP/@V" datatype="string" column="CP"
                    table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_DESCRIPTION"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Nomenclatures/n:NomenclatureBudget/n:Description/@V"
                    datatype="string" column="DESCRIPTION" table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_REFTIERS"
                    path="/n:DOC_PES_Facture/n:Emetteur/n:InfoTiers/n:RefTiers/@V" datatype="string"
                    column="REFTIERS" table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_DTEBANC"
                    path="/n:DOC_PES_Facture/n:Emetteur/n:CpteBancaire/n:DteBanc/@V" datatype="date"
                    format="yyyy-MM-dd" column="DTEBANC" table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_ADR3"
                    path="/n:DOC_PES_Facture/n:Emetteur/n:Adresse/n:Adr3/@V" datatype="string" column="ADR3"
                    table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_ADR2"
                    path="/n:DOC_PES_Facture/n:Emetteur/n:Adresse/n:Adr2/@V" datatype="string" column="ADR2"
                    table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_CATTIERS"
                    path="/n:DOC_PES_Facture/n:Emetteur/n:InfoTiers/n:CatTiers/@V" datatype="string"
                    column="CATTIERS" table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_NATJUR"
                    path="/n:DOC_PES_Facture/n:Emetteur/n:InfoTiers/n:NatJur/@V" datatype="string"
                    column="NATJUR" table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_ADR1"
                    path="/n:DOC_PES_Facture/n:Emetteur/n:Adresse/n:Adr1/@V" datatype="string" column="ADR1"
                    table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_NATIDTIERS"
                    path="/n:DOC_PES_Facture/n:Emetteur/n:InfoTiers/n:NatIdTiers/@V" datatype="string"
                    column="NATIDTIERS" table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_DTEADR"
                    path="/n:DOC_PES_Facture/n:Emetteur/n:Adresse/n:DteAdr/@V" datatype="date"
                    format="yyyy-MM-dd" column="DTEADR" table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_PRENOM"
                    path="/n:DOC_PES_Facture/n:Emetteur/n:InfoTiers/n:Prenom/@V" datatype="string"
                    column="PRENOM" table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_LIBBANC"
                    path="/n:DOC_PES_Facture/n:Emetteur/n:CpteBancaire/n:LibBanc/@V" datatype="string"
                    column="LIBBANC" table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_NUMTVA"
                    path="/n:DOC_PES_Facture/n:Emetteur/n:NumTVA/@V" datatype="string" column="NUMTVA"
                    table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_CODRES"
                    path="/n:DOC_PES_Facture/n:Emetteur/n:Adresse/n:CodRes/@V" datatype="string"
                    column="CODRES" table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_NOM"
                    path="/n:DOC_PES_Facture/n:Emetteur/n:InfoTiers/n:Nom/@V" datatype="string" column="NOM"
                    table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_ANNEE" path="/n:DOC_PES_Facture/n:Annee/@V"
                    datatype="string" column="ANNEE" table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_CLERIB"
                    path="/n:DOC_PES_Facture/n:Emetteur/n:CpteBancaire/n:CleRib/@V" datatype="integer"
                    column="CLERIB" table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TYPTIERS"
                    path="/n:DOC_PES_Facture/n:Emetteur/n:InfoTiers/n:TypTiers/@V" datatype="string"
                    column="TYPTIERS" table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_CODEETAB"
                    path="/n:DOC_PES_Facture/n:Emetteur/n:CpteBancaire/n:CodeEtab/@V" datatype="string"
                    column="CODEETAB" table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_VILLE"
                    path="/n:DOC_PES_Facture/n:Emetteur/n:Adresse/n:Ville/@V" datatype="string"
                    column="VILLE" table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_DATE" path="/n:DOC_PES_Facture/n:Date/@V"
                    datatype="date" format="yyyy-MM-dd" column="DATE"
                    table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_CODEGUIC"
                    path="/n:DOC_PES_Facture/n:Emetteur/n:CpteBancaire/n:CodeGuic/@V" datatype="string"
                    column="CODEGUIC" table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_IDPAYINT"
                    path="/n:DOC_PES_Facture/n:Emetteur/n:CpteBancaire/n:IdPayInt/@V" datatype="string"
                    column="IDPAYINT" table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_IDTIERS"
                    path="/n:DOC_PES_Facture/n:Emetteur/n:InfoTiers/n:IdTiers/@V" datatype="string"
                    column="IDTIERS" table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TYPETIERSFACTURE"
                    path="/n:DOC_PES_Facture/n:Emetteur/n:TypeTiersFacture/@V" datatype="string"
                    column="TYPETIERSFACTURE" table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TYPADR"
                    path="/n:DOC_PES_Facture/n:Emetteur/n:Adresse/n:TypAdr/@V" datatype="string"
                    column="TYPADR" table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_DTEMALADE"
                    path="/n:DOC_PES_Facture/n:Emetteur/n:InfoTiers/n:DteMalade/@V" datatype="date"
                    format="yyyy-MM-dd" column="DTEMALADE" table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_CIVILITE"
                    path="/n:DOC_PES_Facture/n:Emetteur/n:InfoTiers/n:Civilite/@V" datatype="string"
                    column="CIVILITE" table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_IDCPTE"
                    path="/n:DOC_PES_Facture/n:Emetteur/n:CpteBancaire/n:IdCpte/@V" datatype="string"
                    column="IDCPTE" table="PES_FACTURE_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_IDVER" path="/n:DOC_PES_Facture/n:IdVer/@V"
                    datatype="decimal" column="IDVER" table="PES_FACTURE_PESFACTURE_IX"/>

                <!-- SQL-INDEX /n:DOC_PES_Facture/n:PESFacture/n:Tiers -->
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS__NODE_ID"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/@added:generated-id" column="NODE_ID"
                    datatype="string" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_DTEBANC"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:CpteBancaire/n:DteBanc/@V" datatype="date"
                    format="yyyy-MM-dd" column="DTEBANC" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_VILLE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:Adresse/n:Ville/@V" datatype="string"
                    column="VILLE" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_TYPADR"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:Adresse/n:TypAdr/@V" datatype="string"
                    column="TYPADR" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_CP"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:Adresse/n:CP/@V" datatype="string"
                    column="CP" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_CATTIERS"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:InfoTiers/n:CatTiers/@V" datatype="string"
                    column="CATTIERS" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_TYPETIERSFACTURE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:TypeTiersFacture/@V" datatype="string"
                    column="TYPETIERSFACTURE" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_NUMTVA"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:NumTVA/@V" datatype="string"
                    column="NUMTVA" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_IDTIERS"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:InfoTiers/n:IdTiers/@V" datatype="string"
                    column="IDTIERS" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_CODRES"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:Adresse/n:CodRes/@V" datatype="string"
                    column="CODRES" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_CLERIB"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:CpteBancaire/n:CleRib/@V"
                    datatype="integer" column="CLERIB" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_CODEGUIC"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:CpteBancaire/n:CodeGuic/@V"
                    datatype="string" column="CODEGUIC" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_CODPAYS"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:Adresse/n:CodPays/@V" datatype="integer"
                    column="CODPAYS" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_PRENOM"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:InfoTiers/n:Prenom/@V2" datatype="string"
                    column="PRENOM" table="PES_FACTURE_PESFACTURE_TIERS_IX" format="uppercase"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_IDPAYINT"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:CpteBancaire/n:IdPayInt/@V"
                    datatype="string" column="IDPAYINT" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_SERVICE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:Service/@V" datatype="string"
                    column="SERVICE" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_IDBANCINT"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:CpteBancaire/n:IdBancInt/@V"
                    datatype="string" column="IDBANCINT" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_TYPTIERS"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:InfoTiers/n:TypTiers/@V" datatype="string"
                    column="TYPTIERS" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_REFTIERS"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:InfoTiers/n:RefTiers/@V" datatype="string"
                    column="REFTIERS" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_NOM"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:InfoTiers/n:Nom/@V2" datatype="string"
                    column="NOM" table="PES_FACTURE_PESFACTURE_TIERS_IX" format="uppercase"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_CODEETAB"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:CpteBancaire/n:CodeEtab/@V"
                    datatype="string" column="CODEETAB" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_ADR3"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:Adresse/n:Adr3/@V" datatype="string"
                    column="ADR3" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_NATIDTIERS"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:InfoTiers/n:NatIdTiers/@V"
                    datatype="string" column="NATIDTIERS" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_IDCPTE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:CpteBancaire/n:IdCpte/@V"
                    datatype="string" column="IDCPTE" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_ADR2"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:Adresse/n:Adr2/@V" datatype="string"
                    column="ADR2" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_TITCPTE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:CpteBancaire/n:TitCpte/@V"
                    datatype="string" column="TITCPTE" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_LIBBANC"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:CpteBancaire/n:LibBanc/@V"
                    datatype="string" column="LIBBANC" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_ADR1"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:Adresse/n:Adr1/@V" datatype="string"
                    column="ADR1" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_DTEIDTIERS"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:InfoTiers/n:DteIdTiers/@V" datatype="date"
                    format="yyyy-MM-dd" column="DTEIDTIERS" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_NATJUR"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:InfoTiers/n:NatJur/@V" datatype="string"
                    column="NATJUR" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_DTEADR"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:Adresse/n:DteAdr/@V" datatype="date"
                    format="yyyy-MM-dd" column="DTEADR" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_DTEMALADE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:InfoTiers/n:DteMalade/@V" datatype="date"
                    format="yyyy-MM-dd" column="DTEMALADE" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_CIVILITE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:InfoTiers/n:Civilite/@V" datatype="string"
                    column="CIVILITE" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_COMPLNOM"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:InfoTiers/n:ComplNom/@V" datatype="string"
                    column="COMPLNOM" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>

                <!-- SQL-INDEX /n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv -->
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV__NODE_ID"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/@added:generated-id"
                    column="NODE_ID" datatype="string"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TYPEFACT"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:TypeFact/@V" datatype="string"
                    column="TYPEFACT" table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CODPAYS"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:Adresse/n:CodPays/@V"
                    datatype="integer" column="CODPAYS"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_SERVICE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:Service/@V"
                    datatype="string" column="SERVICE"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_COMPLNOM"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:ComplNom/@V"
                    datatype="string" column="COMPLNOM"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MTTOTALTTC"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:TotalAPayer/n:MtTotalTTC/@V"
                    datatype="decimal" column="MTTOTALTTC"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_IDBANCINT"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:CpteBancaire/n:IdBancInt/@V"
                    datatype="string" column="IDBANCINT"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_OBJET"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Objet/@V" datatype="string"
                    column="OBJET" table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DATEEMISSION"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:DateEmission/@V" datatype="date"
                    format="yyyy-MM-dd" column="DATEEMISSION"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TEXTEGENERATEUR"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:TexteGenerateur/@V"
                    datatype="string" column="TEXTEGENERATEUR"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DTEIDTIERS"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:DteIdTiers/@V"
                    datatype="date" format="yyyy-MM-dd" column="DTEIDTIERS"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TITCPTE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:CpteBancaire/n:TitCpte/@V"
                    datatype="string" column="TITCPTE"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CP"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:Adresse/n:CP/@V"
                    datatype="string" column="CP" table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_REFTIERS"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:RefTiers/@V"
                    datatype="string" column="REFTIERS"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DTEBANC"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:CpteBancaire/n:DteBanc/@V"
                    datatype="date" format="yyyy-MM-dd" column="DTEBANC"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_ADR3"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:Adresse/n:Adr3/@V"
                    datatype="string" column="ADR3" table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"
                    format="uppercase"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_ADR2"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:Adresse/n:Adr2/@V"
                    datatype="string" column="ADR2" table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"
                    format="uppercase"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CATTIERS"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:CatTiers/@V"
                    datatype="string" column="CATTIERS"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NATJUR"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:NatJur/@V"
                    datatype="string" column="NATJUR" table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_ADR1"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:Adresse/n:Adr1/@V"
                    datatype="string" column="ADR1" table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"
                    format="uppercase"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NATIDTIERS"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:NatIdTiers/@V"
                    datatype="string" column="NATIDTIERS"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MTTOTALTVA"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:TotalAPayer/n:MtTotalTVA/@V"
                    datatype="decimal" column="MTTOTALTVA"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DTEADR"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:Adresse/n:DteAdr/@V"
                    datatype="date" format="yyyy-MM-dd" column="DTEADR"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MOYENPAIEMENT"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:MoyenPaiement/@V"
                    datatype="string" column="MOYENPAIEMENT"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMEROCONTRAT"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:NumeroContrat/@V"
                    datatype="string" column="NUMEROCONTRAT"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_PRENOM"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:Prenom/@V"
                    datatype="string" column="PRENOM" table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"
                    format="uppercase"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_LIBBANC"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:CpteBancaire/n:LibBanc/@V"
                    datatype="string" column="LIBBANC"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMEROFACTURE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:NumeroFacture/@V"
                    datatype="string" column="NUMEROFACTURE"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMEROMARCHE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:NumeroMarche/@V"
                    datatype="string" column="NUMEROMARCHE"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMTVA"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:NumTVA/@V"
                    datatype="string" column="NUMTVA" table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MTTOTALHT"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:TotalAPayer/n:MtTotalHT/@V"
                    datatype="decimal" column="MTTOTALHT"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CODRES"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:Adresse/n:CodRes/@V"
                    datatype="string" column="CODRES" table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NOM"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:Nom/@V"
                    datatype="string" column="NOM" table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"
                    format="uppercase"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MODALITESREGLEMENT"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:ModalitesReglement/@V"
                    datatype="string" column="MODALITESREGLEMENT"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CLERIB"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:CpteBancaire/n:CleRib/@V"
                    datatype="integer" column="CLERIB"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TYPTIERS"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:TypTiers/@V"
                    datatype="string" column="TYPTIERS"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CODEETAB"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:CpteBancaire/n:CodeEtab/@V"
                    datatype="string" column="CODEETAB"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DATEREGLEMENT"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:DateReglement/@V" datatype="date"
                    format="yyyy-MM-dd" column="DATEREGLEMENT"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CONDITIONSGEN"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:ConditionsGen/@V"
                    datatype="string" column="CONDITIONSGEN"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_VILLE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:Adresse/n:Ville/@V"
                    datatype="string" column="VILLE" table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"
                    format="uppercase"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CODEGUIC"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:CpteBancaire/n:CodeGuic/@V"
                    datatype="string" column="CODEGUIC"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_IDPAYINT"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:CpteBancaire/n:IdPayInt/@V"
                    datatype="string" column="IDPAYINT"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_IDTIERS"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:IdTiers/@V"
                    datatype="string" column="IDTIERS"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX" format="uppercase"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TYPETIERSFACTURE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:TypeTiersFacture/@V"
                    datatype="string" column="TYPETIERSFACTURE"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TYPADR"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:Adresse/n:TypAdr/@V"
                    datatype="string" column="TYPADR" table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DTEMALADE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:DteMalade/@V"
                    datatype="date" format="yyyy-MM-dd" column="DTEMALADE"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TAUXREMISE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:TauxRemise/@V" datatype="decimal"
                    column="TAUXREMISE" table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CIVILITE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:Civilite/@V"
                    datatype="string" column="CIVILITE"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_IDCPTE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:CpteBancaire/n:IdCpte/@V"
                    datatype="string" column="IDCPTE" table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MTREMISE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:MtRemise/@V" datatype="decimal"
                    column="MTREMISE" table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_FOURNISSEUR"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/@added:fournisseur"
                    datatype="string" column="FOURNISSEUR"
                    table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>

                <!-- SQL-INDEX /n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Reference -->
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_REFERENCE__NODE_ID"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Reference/@added:generated-id"
                    column="NODE_ID" datatype="string" table="PES_FACTURE_FACTUREINDIV_REFERENCE_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_REFERENCE_NUMEROPIECE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Reference/n:NumeroPiece/@V"
                    datatype="string" column="NUMEROPIECE"
                    table="PES_FACTURE_FACTUREINDIV_REFERENCE_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_REFERENCE_TYPEPIECE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Reference/n:TypePiece/@V"
                    datatype="string" column="TYPEPIECE"
                    table="PES_FACTURE_FACTUREINDIV_REFERENCE_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_REFERENCE_NUMLIGNE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Reference/n:NumLigne/@V"
                    datatype="integer" column="NUMLIGNE"
                    table="PES_FACTURE_FACTUREINDIV_REFERENCE_IX"/>

                <!-- SQL-INDEX /n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers -->
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS__NODE_ID"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/@added:generated-id"
                    column="NODE_ID" datatype="string" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_DTEBANC"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:CpteBancaire/n:DteBanc/@V"
                    datatype="date" format="yyyy-MM-dd" column="DTEBANC"
                    table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_VILLE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:Adresse/n:Ville/@V"
                    datatype="string" column="VILLE" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_TYPADR"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:Adresse/n:TypAdr/@V"
                    datatype="string" column="TYPADR" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CP"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:Adresse/n:CP/@V"
                    datatype="string" column="CP" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CATTIERS"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:CatTiers/@V"
                    datatype="string" column="CATTIERS" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_TYPETIERSFACTURE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:TypeTiersFacture/@V"
                    datatype="string" column="TYPETIERSFACTURE"
                    table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_NUMTVA"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:NumTVA/@V"
                    datatype="string" column="NUMTVA" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_IDTIERS"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:IdTiers/@V"
                    datatype="string" column="IDTIERS" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CODRES"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:Adresse/n:CodRes/@V"
                    datatype="string" column="CODRES" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CLERIB"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:CpteBancaire/n:CleRib/@V"
                    datatype="integer" column="CLERIB" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CODEGUIC"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:CpteBancaire/n:CodeGuic/@V"
                    datatype="string" column="CODEGUIC" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CODPAYS"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:Adresse/n:CodPays/@V"
                    datatype="integer" column="CODPAYS" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_PRENOM"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:Prenom/@V2"
                    datatype="string" column="PRENOM" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"
                    format="uppercase"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_IDPAYINT"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:CpteBancaire/n:IdPayInt/@V"
                    datatype="string" column="IDPAYINT" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_SERVICE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:Service/@V"
                    datatype="string" column="SERVICE" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_IDBANCINT"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:CpteBancaire/n:IdBancInt/@V"
                    datatype="string" column="IDBANCINT" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_TYPTIERS"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:TypTiers/@V"
                    datatype="string" column="TYPTIERS" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_REFTIERS"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:RefTiers/@V"
                    datatype="string" column="REFTIERS" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_NOM"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:Nom/@V2"
                    datatype="string" column="NOM" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"
                    format="uppercase"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CODEETAB"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:CpteBancaire/n:CodeEtab/@V"
                    datatype="string" column="CODEETAB" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_ADR3"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:Adresse/n:Adr3/@V"
                    datatype="string" column="ADR3" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_NATIDTIERS"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:NatIdTiers/@V"
                    datatype="string" column="NATIDTIERS" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_IDCPTE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:CpteBancaire/n:IdCpte/@V"
                    datatype="string" column="IDCPTE" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_ADR2"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:Adresse/n:Adr2/@V"
                    datatype="string" column="ADR2" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_TITCPTE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:CpteBancaire/n:TitCpte/@V"
                    datatype="string" column="TITCPTE" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_LIBBANC"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:CpteBancaire/n:LibBanc/@V"
                    datatype="string" column="LIBBANC" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_ADR1"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:Adresse/n:Adr1/@V"
                    datatype="string" column="ADR1" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_DTEIDTIERS"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:DteIdTiers/@V"
                    datatype="date" format="yyyy-MM-dd" column="DTEIDTIERS"
                    table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_NATJUR"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:NatJur/@V"
                    datatype="string" column="NATJUR" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_DTEADR"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:Adresse/n:DteAdr/@V"
                    datatype="date" format="yyyy-MM-dd" column="DTEADR"
                    table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_DTEMALADE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:DteMalade/@V"
                    datatype="date" format="yyyy-MM-dd" column="DTEMALADE"
                    table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CIVILITE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:Civilite/@V"
                    datatype="string" column="CIVILITE" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_COMPLNOM"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:ComplNom/@V"
                    datatype="string" column="COMPLNOM" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>

                <!-- SQL-INDEX /n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture -->
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE__NODE_ID"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/@added:generated-id"
                    column="NODE_ID" datatype="string"
                    table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_ORDRE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Ordre/@V"
                    datatype="integer" column="ORDRE"
                    table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_CODEFONCTION"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:CodeFonction/@V"
                    datatype="string" column="CODEFONCTION"
                    table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_MTTTC"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:MtTTC/@V"
                    datatype="decimal" column="MTTTC"
                    table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_TAUX"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Taux/@V"
                    datatype="decimal" column="TAUX"
                    table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_MTREMISE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:MtRemise/@V"
                    datatype="decimal" column="MTREMISE"
                    table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_MTHT"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:MtHT/@V"
                    datatype="decimal" column="MTHT"
                    table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_TAUXTVA"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:TauxTVA/@V"
                    datatype="decimal" column="TAUXTVA"
                    table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_MTTVA"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:MtTVA/@V"
                    datatype="decimal" column="MTTVA"
                    table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_ORDREEDITION"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:OrdreEdition/@V"
                    datatype="integer" column="ORDREEDITION"
                    table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_CODEPRODUIT"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:CodeProduit/@V"
                    datatype="string" column="CODEPRODUIT"
                    table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_TAUXREMISE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:TauxRemise/@V"
                    datatype="decimal" column="TAUXREMISE"
                    table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_CODENATURE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:CodeNature/@V"
                    datatype="string" column="CODENATURE"
                    table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_LIBELLE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Libelle/@V"
                    datatype="string" column="LIBELLE" format="uppercase"
                    table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_UNITE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Unite/@V"
                    datatype="string" column="UNITE"
                    table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_QUANTITE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Quantite/@V"
                    datatype="decimal" column="QUANTITE"
                    table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_MTUNITAIRE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:MtUnitaire/@V"
                    datatype="decimal" column="MTUNITAIRE"
                    table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_MTBASE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:MtBase/@V"
                    datatype="decimal" column="MTBASE"
                    table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>

                <!-- SQL-INDEX /n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers -->
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS__NODE_ID"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/@added:generated-id"
                    column="NODE_ID" datatype="string" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_DTEBANC"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:CpteBancaire/n:DteBanc/@V"
                    datatype="date" format="yyyy-MM-dd" column="DTEBANC"
                    table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_VILLE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:Adresse/n:Ville/@V"
                    datatype="string" column="VILLE" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_TYPADR"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:Adresse/n:TypAdr/@V"
                    datatype="string" column="TYPADR" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_CP"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:Adresse/n:CP/@V"
                    datatype="string" column="CP" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_CATTIERS"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:CatTiers/@V"
                    datatype="string" column="CATTIERS" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_TYPETIERSFACTURE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:TypeTiersFacture/@V"
                    datatype="string" column="TYPETIERSFACTURE"
                    table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_NUMTVA"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:NumTVA/@V"
                    datatype="string" column="NUMTVA" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_IDTIERS"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:IdTiers/@V"
                    datatype="string" column="IDTIERS" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_CODRES"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:Adresse/n:CodRes/@V"
                    datatype="string" column="CODRES" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_CLERIB"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:CpteBancaire/n:CleRib/@V"
                    datatype="integer" column="CLERIB" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_CODEGUIC"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:CpteBancaire/n:CodeGuic/@V"
                    datatype="string" column="CODEGUIC" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_CODPAYS"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:Adresse/n:CodPays/@V"
                    datatype="integer" column="CODPAYS" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_PRENOM"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:Prenom/@V2"
                    datatype="string" column="PRENOM" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"
                    format="uppercase"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_IDPAYINT"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:CpteBancaire/n:IdPayInt/@V"
                    datatype="string" column="IDPAYINT" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_SERVICE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:Service/@V"
                    datatype="string" column="SERVICE" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_IDBANCINT"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:CpteBancaire/n:IdBancInt/@V"
                    datatype="string" column="IDBANCINT" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_TYPTIERS"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:TypTiers/@V"
                    datatype="string" column="TYPTIERS" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_REFTIERS"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:RefTiers/@V"
                    datatype="string" column="REFTIERS" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_NOM"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:Nom/@V2"
                    datatype="string" column="NOM" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"
                    format="uppercase"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_CODEETAB"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:CpteBancaire/n:CodeEtab/@V"
                    datatype="string" column="CODEETAB" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_ADR3"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:Adresse/n:Adr3/@V"
                    datatype="string" column="ADR3" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_NATIDTIERS"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:NatIdTiers/@V"
                    datatype="string" column="NATIDTIERS" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_IDCPTE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:CpteBancaire/n:IdCpte/@V"
                    datatype="string" column="IDCPTE" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_ADR2"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:Adresse/n:Adr2/@V"
                    datatype="string" column="ADR2" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_TITCPTE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:CpteBancaire/n:TitCpte/@V"
                    datatype="string" column="TITCPTE" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_LIBBANC"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:CpteBancaire/n:LibBanc/@V"
                    datatype="string" column="LIBBANC" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_ADR1"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:Adresse/n:Adr1/@V"
                    datatype="string" column="ADR1" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_DTEIDTIERS"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:DteIdTiers/@V"
                    datatype="date" format="yyyy-MM-dd" column="DTEIDTIERS"
                    table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_NATJUR"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:NatJur/@V"
                    datatype="string" column="NATJUR" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_DTEADR"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:Adresse/n:DteAdr/@V"
                    datatype="date" format="yyyy-MM-dd" column="DTEADR"
                    table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_DTEMALADE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:DteMalade/@V"
                    datatype="date" format="yyyy-MM-dd" column="DTEMALADE"
                    table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_CIVILITE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:Civilite/@V"
                    datatype="string" column="CIVILITE" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_COMPLNOM"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:ComplNom/@V"
                    datatype="string" column="COMPLNOM" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>

                <!-- SQL-INDEX /n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:reference -->
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_REFERENCE__NODE_ID"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:reference/@added:generated-id"
                    column="NODE_ID" datatype="string" table="PES_FACTURE_LIGNEFACTURE_REFERENCE_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_REFERENCE_NUMEROPIECE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:reference/n:NumeroPiece/@V"
                    datatype="string" column="NUMEROPIECE"
                    table="PES_FACTURE_LIGNEFACTURE_REFERENCE_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_REFERENCE_TYPEPIECE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:reference/n:TypePiece/@V"
                    datatype="string" column="TYPEPIECE"
                    table="PES_FACTURE_LIGNEFACTURE_REFERENCE_IX"/>
                <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_REFERENCE_NUMLIGNE"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:reference/n:NumLigne/@V"
                    datatype="integer" column="NUMLIGNE"
                    table="PES_FACTURE_LIGNEFACTURE_REFERENCE_IX"/>

                <!-- SQL-INDEX /n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:DetailTVA -->
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_DETAILTVA__NODE_ID"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:DetailTVA/@added:generated-id"
                    column="NODE_ID" datatype="string" table="PES_FACTURE_FACTUREINDIV_DETAILTVA_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_DETAILTVA_TAUXTVA"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:DetailTVA/n:TauxTVA/@V"
                    datatype="decimal" column="TAUXTVA"
                    table="PES_FACTURE_FACTUREINDIV_DETAILTVA_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_DETAILTVA_MTTVA"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:DetailTVA/n:MtTVA/@V"
                    datatype="decimal" column="MTTVA" table="PES_FACTURE_FACTUREINDIV_DETAILTVA_IX"/>
                <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_DETAILTVA_MTBASEHT"
                    path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:DetailTVA/n:MtBaseHT/@V"
                    datatype="decimal" column="MTBASEHT"
                    table="PES_FACTURE_FACTUREINDIV_DETAILTVA_IX"/>

                <element id="PES_FACTURE_PESFACTURE_TIERS_IX">
                    <sql-count>COUNT(DISTINCT(CONCAT(PES_FACTURE_PESFACTURE_IX.DOC_ID,PES_FACTURE_PESFACTURE_TIERS_IX.NODE_ID)))</sql-count>
                    <special-cond>PES_FACTURE_PESFACTURE_TIERS_IX.NODE_ID IS NOT NULL</special-cond>
                </element>
                <element id="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX">
                    <sql-count>COUNT(DISTINCT(CONCAT(PES_FACTURE_PESFACTURE_IX.DOC_ID,PES_FACTURE_PESFACTURE_FACTUREINDIV_IX.NODE_ID)))</sql-count>
                    <special-cond>PES_FACTURE_PESFACTURE_FACTUREINDIV_IX.NODE_ID IS NOT
                    NULL</special-cond>
                </element>
                <element id="PES_FACTURE_FACTUREINDIV_REFERENCE_IX">
                    <sql-count>COUNT(DISTINCT(CONCAT(PES_FACTURE_PESFACTURE_IX.DOC_ID,PES_FACTURE_FACTUREINDIV_REFERENCE_IX.NODE_ID)))</sql-count>
                    <special-cond>PES_FACTURE_FACTUREINDIV_REFERENCE_IX.NODE_ID IS NOT
                    NULL</special-cond>
                </element>
                <element id="PES_FACTURE_FACTUREINDIV_TIERS_IX">
                    <sql-count>COUNT(DISTINCT(CONCAT(PES_FACTURE_PESFACTURE_IX.DOC_ID,PES_FACTURE_FACTUREINDIV_TIERS_IX.NODE_ID)))</sql-count>
                    <special-cond>PES_FACTURE_FACTUREINDIV_TIERS_IX.NODE_ID IS NOT
                    NULL</special-cond>
                </element>
                <element id="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX">
                    <sql-count>COUNT(DISTINCT(CONCAT(PES_FACTURE_PESFACTURE_IX.DOC_ID,PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX.NODE_ID)))</sql-count>
                    <special-cond>PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX.NODE_ID IS NOT
                    NULL</special-cond>
                </element>
                <element id="PES_FACTURE_LIGNEFACTURE_TIERS_IX">
                    <sql-count>COUNT(DISTINCT(CONCAT(PES_FACTURE_PESFACTURE_IX.DOC_ID,PES_FACTURE_LIGNEFACTURE_TIERS_IX.NODE_ID)))</sql-count>
                    <special-cond>PES_FACTURE_LIGNEFACTURE_TIERS_IX.NODE_ID IS NOT
                    NULL</special-cond>
                </element>
                <element id="PES_FACTURE_LIGNEFACTURE_REFERENCE_IX">
                    <sql-count>COUNT(DISTINCT(CONCAT(PES_FACTURE_PESFACTURE_IX.DOC_ID,PES_FACTURE_LIGNEFACTURE_REFERENCE_IX.NODE_ID)))</sql-count>
                    <special-cond>PES_FACTURE_LIGNEFACTURE_REFERENCE_IX.NODE_ID IS NOT
                    NULL</special-cond>
                </element>
                <element id="PES_FACTURE_FACTUREINDIV_DETAILTVA_IX">
                    <sql-count>COUNT(DISTINCT(CONCAT(PES_FACTURE_PESFACTURE_IX.DOC_ID,PES_FACTURE_FACTUREINDIV_DETAILTVA_IX.NODE_ID)))</sql-count>
                    <special-cond>PES_FACTURE_FACTUREINDIV_DETAILTVA_IX.NODE_ID IS NOT
                    NULL</special-cond>
                </element>

            </etat>
        </document>
    </layer>
</persistence-config>
