<?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="PES_ReleveCarteAchat" repository-import-xslt-file="">
            <table type="repository" base-name="PES_CARTEACHAT_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_CARTEACHAT_SPECIAL_KEYS" version="1">
                CREATE TABLE IF NOT EXISTS ${base-name} (
                COLLECTIVITE VARCHAR(15) 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_CARTEACHAT_LIST_BUDG_COLL" version="1">
                CREATE TABLE IF NOT EXISTS ${base-name} (
                COLLECTIVITE VARCHAR(15) 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="PES_CarteAchat" import-xslt-file="CARTE_ACHAT/PES-Releve-CarteAchat-import-mysql.xsl" >
	<!--key1>
		<path>/PES_ReleveCarteAchat/PES_CarteAchat/@added:generated-id</path>
	</key1-->
	<key1>
	    <path>/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/@added:generated-id</path>
	</key1>
	<key2>
	    <path>/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/@added:generated-id</path>
	</key2>
	<key3>
	    <path>/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/@added:generated-id</path>
	</key3>
	<key4>
	    <path>/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Reference/@added:generated-id</path>
	</key4>
	<key5>
	    <path>/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/@added:generated-id</path>
	</key5>
	<key6>
	    <path>/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/@added:generated-id</path>
	</key6>
	<key7>
	    <path>/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/@added:generated-id</path>
	</key7>
	<key8>
	    <path>/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:reference/@added:generated-id</path>
	</key8>
	<key9>
	    <path>/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:DetailTVA/@added:generated-id</path>
	</key9>

<table type="document" base-name="PES_CARTEACHAT_DOCUMENTS" version="1">
	CREATE TABLE IF NOT EXISTS ${base-name} ( 
	COLLECTIVITE VARCHAR(15) 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_CARTEACHAT_PESFACTURE_IX" base-name="PES_CARTEACHAT_PESFACTURE_IX" version="2" main="true" based-on="key1">
	CREATE TABLE IF NOT EXISTS ${base-name} ( 
	COLLECTIVITE VARCHAR(15) 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) ,
	MOIS VARCHAR(2),
	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
	<patch from-version="1">
	    <sql failonerror="false">ALTER TABLE ${base-name} ADD MOIS VARCHAR(2)</sql>
	</patch>
</table>
<table type="index" id="PES_CARTEACHAT_PESFACTURE_TIERS_IX" base-name="PES_CARTEACHAT_PESFACTURE_TIERS_IX" version="1" main="false" based-on="key2">
	CREATE TABLE IF NOT EXISTS ${base-name} ( 
	COLLECTIVITE VARCHAR(15) 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_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" base-name="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" version="2" main="false" based-on="key3">
	CREATE TABLE IF NOT EXISTS ${base-name} ( 
	COLLECTIVITE VARCHAR(15) 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),
	NUMEROENGAGEMENT VARCHAR(50),
	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 NUMEROENGAGEMENT VARCHAR(50)</sql>
    </patch>

</table>
<table type="index" id="PES_CARTEACHAT_FACTUREINDIV_REFERENCE_IX" base-name="PES_CARTEACHAT_FACTUREINDIV_REFERENCE_IX" version="2" main="false" based-on="key4">
	CREATE TABLE IF NOT EXISTS ${base-name} ( 
	COLLECTIVITE VARCHAR(15) 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 ,
	NUMEROFACTURE VARCHAR(50) ,
	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 NUMEROFACTURE VARCHAR(50)</sql>
	</patch>
</table>
<table type="index" id="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" base-name="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" version="2" main="false" based-on="key5">
	CREATE TABLE IF NOT EXISTS ${base-name} ( 
	COLLECTIVITE VARCHAR(15) 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) ,
	NUMEROFACTURE VARCHAR(50) ,
	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 NUMEROFACTURE VARCHAR(50)</sql>
    </patch>
</table>
<table type="index" id="PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_IX" base-name="PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_IX" version="3" main="false" based-on="key6">
	CREATE TABLE IF NOT EXISTS ${base-name} ( 
	COLLECTIVITE VARCHAR(15) 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),
	NUMEROIMPUTATION VARCHAR(50),
	NUMEROFACTURE VARCHAR(50),
	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 NUMEROIMPUTATION VARCHAR(50)</sql>
  	    <sql failonerror="false">ALTER TABLE ${base-name} ADD NUMEROFACTURE VARCHAR(50)</sql>
  	</patch> 	
    <patch from-version="2">
        <sql failonerror="false">ALTER TABLE ${base-name} ADD NUMEROFACTURE VARCHAR(50)</sql>
    </patch>
    <patch from-version="3">
        <sql failonerror="false">ALTER TABLE ${base-name} ADD NUMEROFACTURE VARCHAR(50)</sql>
    </patch>
</table>
<table type="index" id="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" base-name="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" version="2" main="false" based-on="key7">
	CREATE TABLE IF NOT EXISTS ${base-name} ( 
	COLLECTIVITE VARCHAR(15) 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) ,
	NUMEROFACTURE VARCHAR(50) ,
	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 NUMEROFACTURE VARCHAR(50)</sql>
    </patch>
</table>
<table type="index" id="PES_CARTEACHAT_LIGNEFACTURE_REFERENCE_IX" base-name="PES_CARTEACHAT_LIGNEFACTURE_REFERENCE_IX" version="2" main="false" based-on="key8">
	CREATE TABLE IF NOT EXISTS ${base-name} ( 
	COLLECTIVITE VARCHAR(15) 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 ,
	NUMEROFACTURE VARCHAR(50) ,
	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 NUMEROFACTURE VARCHAR(50)</sql>
    </patch>
</table>
<table type="index" id="PES_CARTEACHAT_FACTUREINDIV_DETAILTVA_IX" base-name="PES_CARTEACHAT_FACTUREINDIV_DETAILTVA_IX" version="2" main="false" based-on="key9">
	CREATE TABLE IF NOT EXISTS ${base-name} ( 
	COLLECTIVITE VARCHAR(15) 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),
	NUMEROFACTURE VARCHAR(50) ,
	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 NUMEROFACTURE VARCHAR(50)</sql>
    </patch>
</table>

<!-- CRITERIA PERSO -->
<criteria id="_CRI_PES_CARTEACHAT_FOURNISSEUR" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_NOM">
    <where-clause>(fn:string-compare(${table}.${column},fournisseur) AND ${table}.TYPETIERSFACTURE='24')</where-clause>
</criteria>                
<criteria id="_CRI_PES_CARTEACHAT_MONTANT_HT" sql-index-id="SQI_PES_CARTEACHAT_MONTANT_HT">
    <where-clause>${table}.${column}##OPERATEUR:montantHT####VALEUR:montantHT##</where-clause>
</criteria>
<criteria id="_CRI_PES_CARTEACHAT_MONTANT_TVA" sql-index-id="SQI_PES_CARTEACHAT_MONTANT_TVA">
    <where-clause>${table}.${column}##OPERATEUR:montantTVA####VALEUR:montantTVA##</where-clause>
</criteria>
<criteria id="_CRI_PES_CARTEACHAT_MONTANT_TTC" sql-index-id="SQI_PES_CARTEACHAT_MONTANT_TTC">
    <where-clause>${table}.${column}##OPERATEUR:montantTTC####VALEUR:montantTTC##</where-clause>
</criteria>

<criteria id="_CRI_PES_CARTEACHAT_NUMERO_COMMANDE" sql-index-id="SQI_M_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_NUMERO_COMMANDE">
    <where-clause>(fn:string-compare(${table}.${column},NumeroCommande))</where-clause>
</criteria>
<criteria id="_CRI_PES_CARTEACHAT_PRIXUNITAIRE" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_MTUNITAIRE">
    <where-clause>${table}.${column}##OPERATEUR:prixht####VALEUR:prixht##</where-clause>
</criteria>
<criteria id="_CRI_PES_CARTEACHAT_QUANTITE" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_QUANTITE">
    <where-clause>${table}.${column}##OPERATEUR:quantite####VALEUR:quantite##</where-clause>
</criteria><criteria id="_CRI_PES_CARTEACHAT_NUMERO_CARTE" sql-index-id="SQI_M_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_NUMERO_CARTEACHAT">
    <where-clause>(fn:string-compare(${table}.${column},IdTiers))</where-clause>
</criteria>
<!-- CRITERIA /PES_ReleveCarteAchat/PES_CarteAchat -->

<!-- CRITERIA /PES_ReleveCarteAchat/PES_CarteAchat/PESFacture -->
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TYPEFACT" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TYPEFACT">
	<where-clause>fn:string-compare(${table}.${column},TypeFact)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_CODPAYS" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_CODPAYS">
	<where-clause>${table}.${column}##OPERATEUR:CodPays####VALEUR:CodPays##</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_SERVICE" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_SERVICE">
	<where-clause>fn:string-compare(${table}.${column},Service)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_COMPLNOM" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_COMPLNOM">
	<where-clause>fn:string-compare(${table}.${column},ComplNom)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_DEVISE" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_DEVISE">
	<where-clause>fn:string-compare(${table}.${column},Devise)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_IDBANCINT" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_IDBANCINT">
	<where-clause>fn:string-compare(${table}.${column},IdBancInt)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_NUMSEQUENCE" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_NUMSEQUENCE">
	<where-clause>${table}.${column}##OPERATEUR:NumSequence####VALEUR:NumSequence##</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_DTEIDTIERS" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_DTEIDTIERS">
	<where-clause>fn:date-compare(${table}.${column},DteIdTiers)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TITCPTE" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TITCPTE">
	<where-clause>fn:string-compare(${table}.${column},TitCpte)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_CP" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_CP">
	<where-clause>fn:string-compare(${table}.${column},CP)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_DESCRIPTION" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_DESCRIPTION">
	<where-clause>fn:string-compare(${table}.${column},Description)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_REFTIERS" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_REFTIERS">
	<where-clause>fn:string-compare(${table}.${column},RefTiers)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_DTEBANC" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_DTEBANC">
	<where-clause>fn:date-compare(${table}.${column},DteBanc)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_ADR3" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_ADR3">
	<where-clause>fn:string-compare(${table}.${column},Adr3)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_ADR2" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_ADR2">
	<where-clause>fn:string-compare(${table}.${column},Adr2)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_CATTIERS" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_CATTIERS">
	<where-clause>fn:string-compare(${table}.${column},CatTiers)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_NATJUR" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_NATJUR">
	<where-clause>fn:string-compare(${table}.${column},NatJur)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_ADR1" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_ADR1">
	<where-clause>fn:string-compare(${table}.${column},Adr1)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_NATIDTIERS" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_NATIDTIERS">
	<where-clause>fn:string-compare(${table}.${column},NatIdTiers)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_DTEADR" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_DTEADR">
	<where-clause>fn:date-compare(${table}.${column},DteAdr)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_PRENOM" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_PRENOM">
	<where-clause>fn:string-compare(${table}.${column},Prenom)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_LIBBANC" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_LIBBANC">
	<where-clause>fn:string-compare(${table}.${column},LibBanc)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_NUMTVA" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_NUMTVA">
	<where-clause>fn:string-compare(${table}.${column},NumTVA)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_CODRES" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_CODRES">
	<where-clause>fn:string-compare(${table}.${column},CodRes)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_NOM" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_NOM">
	<where-clause>fn:string-compare(${table}.${column},Nom)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_ANNEE" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_ANNEE">
	<where-clause>${table}.${column}='##VALEUR:Annee##'</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_CLERIB" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_CLERIB">
	<where-clause>${table}.${column}##OPERATEUR:CleRib####VALEUR:CleRib##</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TYPTIERS" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TYPTIERS">
	<where-clause>fn:string-compare(${table}.${column},TypTiers)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_CODEETAB" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_CODEETAB">
	<where-clause>fn:string-compare(${table}.${column},CodeEtab)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_VILLE" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_VILLE">
	<where-clause>fn:string-compare(${table}.${column},Ville)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_DATE" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_DATE">
	<where-clause>fn:date-compare(${table}.${column},Date)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_CODEGUIC" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_CODEGUIC">
	<where-clause>fn:string-compare(${table}.${column},CodeGuic)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_IDPAYINT" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_IDPAYINT">
	<where-clause>fn:string-compare(${table}.${column},IdPayInt)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_IDTIERS" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_IDTIERS">
	<where-clause>fn:string-compare(${table}.${column},IdTiers)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TYPETIERSFACTURE" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TYPETIERSFACTURE">
	<where-clause>fn:string-compare(${table}.${column},TypeTiersFacture)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TYPADR" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TYPADR">
	<where-clause>fn:string-compare(${table}.${column},TypAdr)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_DTEMALADE" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_DTEMALADE">
	<where-clause>fn:date-compare(${table}.${column},DteMalade)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_CIVILITE" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_CIVILITE">
	<where-clause>fn:string-compare(${table}.${column},Civilite)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_IDCPTE" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_IDCPTE">
	<where-clause>fn:string-compare(${table}.${column},IdCpte)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_IDVER" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_IDVER">
	<where-clause>${table}.${column}##OPERATEUR:IdVer####VALEUR:IdVer##</where-clause>
</criteria>

<!-- CRITERIA /PES_ReleveCarteAchat/PES_CarteAchat/PESFacture/Tiers -->
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TIERS_DTEBANC" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_DTEBANC">
	<where-clause>fn:date-compare(${table}.${column},DteBanc)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TIERS_VILLE" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_VILLE">
	<where-clause>fn:string-compare(${table}.${column},Ville)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TIERS_TYPADR" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_TYPADR">
	<where-clause>fn:string-compare(${table}.${column},TypAdr)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TIERS_CP" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_CP">
	<where-clause>fn:string-compare(${table}.${column},CP)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TIERS_CATTIERS" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_CATTIERS">
	<where-clause>fn:string-compare(${table}.${column},CatTiers)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TIERS_TYPETIERSFACTURE" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_TYPETIERSFACTURE">
	<where-clause>fn:string-compare(${table}.${column},TypeTiersFacture)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TIERS_NUMTVA" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_NUMTVA">
	<where-clause>fn:string-compare(${table}.${column},NumTVA)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TIERS_IDTIERS" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_IDTIERS">
	<where-clause>fn:string-compare(${table}.${column},IdTiers)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TIERS_CODRES" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_CODRES">
	<where-clause>fn:string-compare(${table}.${column},CodRes)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TIERS_CLERIB" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_CLERIB">
	<where-clause>${table}.${column}##OPERATEUR:CleRib####VALEUR:CleRib##</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TIERS_CODEGUIC" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_CODEGUIC">
	<where-clause>fn:string-compare(${table}.${column},CodeGuic)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TIERS_CODPAYS" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_CODPAYS">
	<where-clause>${table}.${column}##OPERATEUR:CodPays####VALEUR:CodPays##</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TIERS_PRENOM" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_PRENOM">
	<where-clause>fn:string-compare(${table}.${column},Prenom)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TIERS_IDPAYINT" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_IDPAYINT">
	<where-clause>fn:string-compare(${table}.${column},IdPayInt)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TIERS_SERVICE" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_SERVICE">
	<where-clause>fn:string-compare(${table}.${column},Service)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TIERS_IDBANCINT" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_IDBANCINT">
	<where-clause>fn:string-compare(${table}.${column},IdBancInt)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TIERS_TYPTIERS" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_TYPTIERS">
	<where-clause>fn:string-compare(${table}.${column},TypTiers)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TIERS_REFTIERS" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_REFTIERS">
	<where-clause>fn:string-compare(${table}.${column},RefTiers)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TIERS_NOM" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_NOM">
	<where-clause>fn:string-compare(${table}.${column},Nom)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TIERS_CODEETAB" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_CODEETAB">
	<where-clause>fn:string-compare(${table}.${column},CodeEtab)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TIERS_ADR3" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_ADR3">
	<where-clause>fn:string-compare(${table}.${column},Adr3)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TIERS_NATIDTIERS" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_NATIDTIERS">
	<where-clause>fn:string-compare(${table}.${column},NatIdTiers)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TIERS_IDCPTE" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_IDCPTE">
	<where-clause>fn:string-compare(${table}.${column},IdCpte)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TIERS_ADR2" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_ADR2">
	<where-clause>fn:string-compare(${table}.${column},Adr2)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TIERS_TITCPTE" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_TITCPTE">
	<where-clause>fn:string-compare(${table}.${column},TitCpte)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TIERS_LIBBANC" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_LIBBANC">
	<where-clause>fn:string-compare(${table}.${column},LibBanc)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TIERS_ADR1" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_ADR1">
	<where-clause>fn:string-compare(${table}.${column},Adr1)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TIERS_DTEIDTIERS" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_DTEIDTIERS">
	<where-clause>fn:date-compare(${table}.${column},DteIdTiers)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TIERS_NATJUR" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_NATJUR">
	<where-clause>fn:string-compare(${table}.${column},NatJur)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TIERS_DTEADR" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_DTEADR">
	<where-clause>fn:date-compare(${table}.${column},DteAdr)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TIERS_DTEMALADE" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_DTEMALADE">
	<where-clause>fn:date-compare(${table}.${column},DteMalade)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TIERS_CIVILITE" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_CIVILITE">
	<where-clause>fn:string-compare(${table}.${column},Civilite)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_TIERS_COMPLNOM" type="1" sql-index-id="SQI_PES_CARTEACHAT_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_CARTEACHAT_PESFACTURE_FACTUREINDIV_TYPEFACT" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_TYPEFACT">
	<where-clause>fn:string-compare(${table}.${column},TypeFact)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_CODPAYS" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_CODPAYS">
	<where-clause>${table}.${column}##OPERATEUR:CodPays####VALEUR:CodPays##</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_SERVICE" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_SERVICE">
	<where-clause>fn:string-compare(${table}.${column},Service)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_COMPLNOM" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_COMPLNOM">
	<where-clause>fn:string-compare(${table}.${column},ComplNom)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_MTTOTALTTC" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_MTTOTALTTC">
    <where-clause>${table}.${column}##OPERATEUR:montantTTC####VALEUR:montantTTC##</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IDBANCINT" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IDBANCINT">
	<where-clause>fn:string-compare(${table}.${column},IdBancInt)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_OBJET" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_OBJET">
	<where-clause>fn:string-compare(${table}.${column},Objet)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_DATEEMISSION" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_DATEEMISSION">
	<where-clause>fn:date-compare(${table}.${column},DateEmission)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_TEXTEGENERATEUR" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_TEXTEGENERATEUR">
	<where-clause>fn:string-compare(${table}.${column},TexteGenerateur)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_DTEIDTIERS" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_DTEIDTIERS">
	<where-clause>fn:date-compare(${table}.${column},DteIdTiers)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_TITCPTE" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_TITCPTE">
	<where-clause>fn:string-compare(${table}.${column},TitCpte)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_CP" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_CP">
	<where-clause>fn:string-compare(${table}.${column},CP)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_REFTIERS" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_REFTIERS">
	<where-clause>fn:string-compare(${table}.${column},RefTiers)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_DTEBANC" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_DTEBANC">
	<where-clause>fn:date-compare(${table}.${column},DteBanc)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_ADR3" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_ADR3">
	<where-clause>fn:string-compare(${table}.${column},Adr3)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_ADR2" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_ADR2">
	<where-clause>fn:string-compare(${table}.${column},Adr2)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_CATTIERS" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_CATTIERS">
	<where-clause>fn:string-compare(${table}.${column},CatTiers)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_NATJUR" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_NATJUR">
	<where-clause>fn:string-compare(${table}.${column},NatJur)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_ADR1" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_ADR1">
	<where-clause>fn:string-compare(${table}.${column},Adr1)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_NATIDTIERS" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_NATIDTIERS">
	<where-clause>fn:string-compare(${table}.${column},NatIdTiers)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_MTTOTALTVA" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_MTTOTALTVA">
	<where-clause>${table}.${column}##OPERATEUR:MtTotalTVA####VALEUR:MtTotalTVA##</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_DTEADR" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_DTEADR">
	<where-clause>fn:date-compare(${table}.${column},DteAdr)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_MOYENPAIEMENT" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_MOYENPAIEMENT">
	<where-clause>fn:string-compare(${table}.${column},MoyenPaiement)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_NUMEROCONTRAT" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_NUMEROCONTRAT">
	<where-clause>fn:string-compare(${table}.${column},NumeroContrat)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_PRENOM" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_PRENOM">
	<where-clause>fn:string-compare(${table}.${column},Prenom)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_LIBBANC" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_LIBBANC">
	<where-clause>fn:string-compare(${table}.${column},LibBanc)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_NUMEROFACTURE" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_NUMEROFACTURE">
	<where-clause>fn:string-compare(${table}.${column},NumeroFacture)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_NUMEROMARCHE" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_NUMEROMARCHE">
	<where-clause>fn:string-compare(${table}.${column},NumeroMarche)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_NUMTVA" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_NUMTVA">
	<where-clause>fn:string-compare(${table}.${column},NumTVA)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_MTTOTALHT" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_MTTOTALHT">
	<where-clause>${table}.${column}##OPERATEUR:MtTotalHT####VALEUR:MtTotalHT##</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_CODRES" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_CODRES">
	<where-clause>fn:string-compare(${table}.${column},CodRes)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_NOM" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_NOM">
	<where-clause>fn:string-compare(${table}.${column},Nom)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_MODALITESREGLEMENT" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_MODALITESREGLEMENT">
	<where-clause>fn:string-compare(${table}.${column},ModalitesReglement)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_CLERIB" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_CLERIB">
	<where-clause>${table}.${column}##OPERATEUR:CleRib####VALEUR:CleRib##</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_TYPTIERS" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_TYPTIERS">
	<where-clause>fn:string-compare(${table}.${column},TypTiers)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_CODEETAB" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_CODEETAB">
	<where-clause>fn:string-compare(${table}.${column},CodeEtab)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_DATEREGLEMENT" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_DATEREGLEMENT">
	<where-clause>fn:date-compare(${table}.${column},DateReglement)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_CONDITIONSGEN" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_CONDITIONSGEN">
	<where-clause>fn:string-compare(${table}.${column},ConditionsGen)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_VILLE" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_VILLE">
	<where-clause>fn:string-compare(${table}.${column},Ville)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_CODEGUIC" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_CODEGUIC">
	<where-clause>fn:string-compare(${table}.${column},CodeGuic)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IDPAYINT" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IDPAYINT">
	<where-clause>fn:string-compare(${table}.${column},IdPayInt)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IDTIERS" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IDTIERS">
	<where-clause>fn:string-compare(${table}.${column},IdTiers)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_TYPETIERSFACTURE" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_TYPETIERSFACTURE">
	<where-clause>fn:string-compare(${table}.${column},TypeTiersFacture)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_TYPADR" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_TYPADR">
	<where-clause>fn:string-compare(${table}.${column},TypAdr)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_DTEMALADE" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_DTEMALADE">
	<where-clause>fn:date-compare(${table}.${column},DteMalade)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_TAUXREMISE" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_TAUXREMISE">
	<where-clause>${table}.${column}##OPERATEUR:TauxRemise####VALEUR:TauxRemise##</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_CIVILITE" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_CIVILITE">
	<where-clause>fn:string-compare(${table}.${column},Civilite)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IDCPTE" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IDCPTE">
	<where-clause>fn:string-compare(${table}.${column},IdCpte)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_MTREMISE" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_MTREMISE">
	<where-clause>${table}.${column}##OPERATEUR:MtRemise####VALEUR:MtRemise##</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_FOURNISSEUR" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_FOURNISSEUR">
    <where-clause>fn:string-compare(${table}.${column},Fournisseur)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_NUMEROENGAGEMENT" type="1" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_NUMEROENGAGEMENT">
    <where-clause>fn:string-compare(${table}.${column},NumeroEngagement)</where-clause>
</criteria>
                
<!-- CRITERIA /PES_ReleveCarteAchat/PES_CarteAchat/PESFacture/FactureIndiv/Reference -->
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_REFERENCE_NUMEROPIECE" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_REFERENCE_NUMEROPIECE">
	<where-clause>fn:string-compare(${table}.${column},NumeroPiece)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_REFERENCE_TYPEPIECE" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_REFERENCE_TYPEPIECE">
	<where-clause>fn:string-compare(${table}.${column},TypePiece)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_REFERENCE_NUMLIGNE" type="1" sql-index-id="SQI_PES_CARTEACHAT_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_CARTEACHAT_FACTUREINDIV_TIERS_DTEBANC" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_DTEBANC">
	<where-clause>fn:date-compare(${table}.${column},DteBanc)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_TIERS_VILLE" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_VILLE">
	<where-clause>fn:string-compare(${table}.${column},Ville)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_TIERS_TYPADR" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_TYPADR">
	<where-clause>fn:string-compare(${table}.${column},TypAdr)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_TIERS_CP" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_CP">
	<where-clause>fn:string-compare(${table}.${column},CP)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_TIERS_CATTIERS" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_CATTIERS">
	<where-clause>fn:string-compare(${table}.${column},CatTiers)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_TIERS_TYPETIERSFACTURE" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_TYPETIERSFACTURE">
	<where-clause>fn:string-compare(${table}.${column},TypeTiersFacture)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_TIERS_NUMTVA" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_NUMTVA">
	<where-clause>fn:string-compare(${table}.${column},NumTVA)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_TIERS_IDTIERS" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_IDTIERS">
	<where-clause>fn:string-compare(${table}.${column},IdTiers)</where-clause>
</criteria>
<criteria id="centreFi" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_IDTIERS">
    <where-clause>(${table}.TYPETIERSFACTURE='13' AND fn:string-compare(${table}.${column},centreFi))</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_TIERS_CODRES" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_CODRES">
	<where-clause>fn:string-compare(${table}.${column},CodRes)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_TIERS_CLERIB" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_CLERIB">
	<where-clause>${table}.${column}##OPERATEUR:CleRib####VALEUR:CleRib##</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_TIERS_CODEGUIC" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_CODEGUIC">
	<where-clause>fn:string-compare(${table}.${column},CodeGuic)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_TIERS_CODPAYS" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_CODPAYS">
	<where-clause>${table}.${column}##OPERATEUR:CodPays####VALEUR:CodPays##</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_TIERS_PRENOM" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_PRENOM">
	<where-clause>fn:string-compare(${table}.${column},Prenom)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_TIERS_IDPAYINT" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_IDPAYINT">
	<where-clause>fn:string-compare(${table}.${column},IdPayInt)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_TIERS_SERVICE" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_SERVICE">
	<where-clause>fn:string-compare(${table}.${column},Service)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_TIERS_IDBANCINT" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_IDBANCINT">
	<where-clause>fn:string-compare(${table}.${column},IdBancInt)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_TIERS_TYPTIERS" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_TYPTIERS">
	<where-clause>fn:string-compare(${table}.${column},TypTiers)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_TIERS_REFTIERS" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_REFTIERS">
	<where-clause>fn:string-compare(${table}.${column},RefTiers)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_TIERS_NOM" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_NOM">
	<where-clause>fn:string-compare(${table}.${column},Nom)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_TIERS_CODEETAB" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_CODEETAB">
	<where-clause>fn:string-compare(${table}.${column},CodeEtab)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_TIERS_ADR3" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_ADR3">
	<where-clause>fn:string-compare(${table}.${column},Adr3)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_TIERS_NATIDTIERS" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_NATIDTIERS">
	<where-clause>fn:string-compare(${table}.${column},NatIdTiers)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_TIERS_IDCPTE" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_IDCPTE">
	<where-clause>fn:string-compare(${table}.${column},IdCpte)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_TIERS_ADR2" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_ADR2">
	<where-clause>fn:string-compare(${table}.${column},Adr2)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_TIERS_TITCPTE" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_TITCPTE">
	<where-clause>fn:string-compare(${table}.${column},TitCpte)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_TIERS_LIBBANC" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_LIBBANC">
	<where-clause>fn:string-compare(${table}.${column},LibBanc)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_TIERS_ADR1" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_ADR1">
	<where-clause>fn:string-compare(${table}.${column},Adr1)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_TIERS_DTEIDTIERS" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_DTEIDTIERS">
	<where-clause>fn:date-compare(${table}.${column},DteIdTiers)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_TIERS_NATJUR" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_NATJUR">
	<where-clause>fn:string-compare(${table}.${column},NatJur)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_TIERS_DTEADR" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_DTEADR">
	<where-clause>fn:date-compare(${table}.${column},DteAdr)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_TIERS_DTEMALADE" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_DTEMALADE">
	<where-clause>fn:date-compare(${table}.${column},DteMalade)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_TIERS_CIVILITE" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_CIVILITE">
	<where-clause>fn:string-compare(${table}.${column},Civilite)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_TIERS_COMPLNOM" type="1" sql-index-id="SQI_PES_CARTEACHAT_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_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_ORDRE" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_ORDRE">
	<where-clause>${table}.${column}##OPERATEUR:Ordre####VALEUR:Ordre##</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_CODEFONCTION" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_CODEFONCTION">
	<where-clause>fn:string-compare(${table}.${column},CodeFonction)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_MTTTC" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_MTTTC">
	<where-clause>${table}.${column}##OPERATEUR:MtTTC####VALEUR:MtTTC##</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_TAUX" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_TAUX">
	<where-clause>${table}.${column}##OPERATEUR:Taux####VALEUR:Taux##</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_MTREMISE" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_MTREMISE">
	<where-clause>${table}.${column}##OPERATEUR:MtRemise####VALEUR:MtRemise##</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_MTHT" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_MTHT">
	<where-clause>${table}.${column}##OPERATEUR:MtHT####VALEUR:MtHT##</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_TAUXTVA" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_TAUXTVA">
	<where-clause>${table}.${column}##OPERATEUR:TauxTVA####VALEUR:TauxTVA##</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_MTTVA" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_MTTVA">
	<where-clause>${table}.${column}##OPERATEUR:MtTVA####VALEUR:MtTVA##</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_ORDREEDITION" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_ORDREEDITION">
	<where-clause>${table}.${column}##OPERATEUR:OrdreEdition####VALEUR:OrdreEdition##</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_CODEPRODUIT" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_CODEPRODUIT">
	<where-clause>fn:string-compare(${table}.${column},CodeProduit)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_TAUXREMISE" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_TAUXREMISE">
	<where-clause>${table}.${column}##OPERATEUR:TauxRemise####VALEUR:TauxRemise##</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_CODENATURE" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_CODENATURE">
	<where-clause>fn:string-compare(${table}.${column},CodeNature)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_LIBELLE" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_LIBELLE">
	<where-clause>fn:string-compare(${table}.${column},Libelle)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_NUMEROIMPUTATION" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_NUMEROIMPUTATION">
    <where-clause>fn:string-compare(${table}.${column},NumeroImputation)</where-clause>
</criteria>

<!-- CRITERIA /PES_ReleveCarteAchat/PES_CarteAchat/PESFacture/FactureIndiv/LigneFacture/Tiers -->
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_DTEBANC" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_DTEBANC">
	<where-clause>fn:date-compare(${table}.${column},DteBanc)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_VILLE" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_VILLE">
	<where-clause>fn:string-compare(${table}.${column},Ville)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_TYPADR" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_TYPADR">
	<where-clause>fn:string-compare(${table}.${column},TypAdr)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_CP" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_CP">
	<where-clause>fn:string-compare(${table}.${column},CP)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_CATTIERS" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_CATTIERS">
	<where-clause>fn:string-compare(${table}.${column},CatTiers)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_TYPETIERSFACTURE" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_TYPETIERSFACTURE">
	<where-clause>fn:string-compare(${table}.${column},TypeTiersFacture)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_NUMTVA" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_NUMTVA">
	<where-clause>fn:string-compare(${table}.${column},NumTVA)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_IDTIERS" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_IDTIERS">
	<where-clause>fn:string-compare(${table}.${column},IdTiers)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_CODRES" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_CODRES">
	<where-clause>fn:string-compare(${table}.${column},CodRes)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_CLERIB" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_CLERIB">
	<where-clause>${table}.${column}##OPERATEUR:CleRib####VALEUR:CleRib##</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_CODEGUIC" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_CODEGUIC">
	<where-clause>fn:string-compare(${table}.${column},CodeGuic)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_CODPAYS" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_CODPAYS">
	<where-clause>${table}.${column}##OPERATEUR:CodPays####VALEUR:CodPays##</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_PRENOM" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_PRENOM">
	<where-clause>fn:string-compare(${table}.${column},Prenom)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_IDPAYINT" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_IDPAYINT">
	<where-clause>fn:string-compare(${table}.${column},IdPayInt)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_SERVICE" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_SERVICE">
	<where-clause>fn:string-compare(${table}.${column},Service)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_IDBANCINT" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_IDBANCINT">
	<where-clause>fn:string-compare(${table}.${column},IdBancInt)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_TYPTIERS" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_TYPTIERS">
	<where-clause>fn:string-compare(${table}.${column},TypTiers)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_REFTIERS" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_REFTIERS">
	<where-clause>fn:string-compare(${table}.${column},RefTiers)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_NOM" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_NOM">
	<where-clause>fn:string-compare(${table}.${column},Nom)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_CODEETAB" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_CODEETAB">
	<where-clause>fn:string-compare(${table}.${column},CodeEtab)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_ADR3" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_ADR3">
	<where-clause>fn:string-compare(${table}.${column},Adr3)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_NATIDTIERS" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_NATIDTIERS">
	<where-clause>fn:string-compare(${table}.${column},NatIdTiers)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_IDCPTE" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_IDCPTE">
	<where-clause>fn:string-compare(${table}.${column},IdCpte)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_ADR2" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_ADR2">
	<where-clause>fn:string-compare(${table}.${column},Adr2)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_TITCPTE" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_TITCPTE">
	<where-clause>fn:string-compare(${table}.${column},TitCpte)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_LIBBANC" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_LIBBANC">
	<where-clause>fn:string-compare(${table}.${column},LibBanc)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_ADR1" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_ADR1">
	<where-clause>fn:string-compare(${table}.${column},Adr1)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_DTEIDTIERS" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_DTEIDTIERS">
	<where-clause>fn:date-compare(${table}.${column},DteIdTiers)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_NATJUR" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_NATJUR">
	<where-clause>fn:string-compare(${table}.${column},NatJur)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_DTEADR" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_DTEADR">
	<where-clause>fn:date-compare(${table}.${column},DteAdr)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_DTEMALADE" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_DTEMALADE">
	<where-clause>fn:date-compare(${table}.${column},DteMalade)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_CIVILITE" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_CIVILITE">
	<where-clause>fn:string-compare(${table}.${column},Civilite)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_COMPLNOM" type="1" sql-index-id="SQI_PES_CARTEACHAT_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_CARTEACHAT_LIGNEFACTURE_REFERENCE_NUMEROPIECE" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_REFERENCE_NUMEROPIECE">
	<where-clause>fn:string-compare(${table}.${column},NumeroPiece)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_REFERENCE_TYPEPIECE" type="1" sql-index-id="SQI_PES_CARTEACHAT_LIGNEFACTURE_REFERENCE_TYPEPIECE">
	<where-clause>fn:string-compare(${table}.${column},TypePiece)</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_LIGNEFACTURE_REFERENCE_NUMLIGNE" type="1" sql-index-id="SQI_PES_CARTEACHAT_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_CARTEACHAT_FACTUREINDIV_DETAILTVA_TAUXTVA" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_DETAILTVA_TAUXTVA">
	<where-clause>${table}.${column}##OPERATEUR:TauxTVA####VALEUR:TauxTVA##</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_DETAILTVA_MTTVA" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_DETAILTVA_MTTVA">
	<where-clause>${table}.${column}##OPERATEUR:MtTVA####VALEUR:MtTVA##</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_FACTUREINDIV_DETAILTVA_MTBASEHT" type="1" sql-index-id="SQI_PES_CARTEACHAT_FACTUREINDIV_DETAILTVA_MTBASEHT">
	<where-clause>${table}.${column}##OPERATEUR:MtBaseHT####VALEUR:MtBaseHT##</where-clause>
</criteria>
<criteria id="CRI_PES_CARTEACHAT_MOIS" sql-index-id="SQI_PES_CARTEACHAT_PESFACTURE_MOIS">
    <where-clause>${table}.${column}='##VALEUR:mois##'</where-clause>
</criteria>
                
                
<!-- SQL-INDEX PERSO -->
                <sql-index id="SQI_PES_CARTEACHAT_MONTANT_HT" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/@added:montantHT" column="MONTANT_HT" datatype="decimal" table="PES_CARTEACHAT_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_CARTEACHAT_MONTANT_TVA" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/@added:montantTVA" column="MONTANT_TVA" datatype="decimal" table="PES_CARTEACHAT_PESFACTURE_IX"/>
                <sql-index id="SQI_PES_CARTEACHAT_MONTANT_TTC" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/@added:montantTTC" column="MONTANT_TTC" datatype="decimal" table="PES_CARTEACHAT_PESFACTURE_IX"/>
<sql-index id="SQI_M_PES_CARTEACHAT_PESFACTURE__NODE_ID" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/@added:generated-id" column="NODE_ID" datatype="string" table="PES_CARTEACHAT_PESFACTURE_IX"/>
<sql-index id="SQI_M_PES_CARTEACHAT_PESFACTURE_PRIMARYKEY" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/@added:primarykey" column="PRIMARY_KEY" table="PES_CARTEACHAT_PESFACTURE_IX" datatype="string" />
<sql-index id="SQI_M_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_NUMERO_CARTEACHAT" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/@added:numero_carteachat" column="NUMERO_CARTEACHAT" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" datatype="string"/>
<!--sql-index id="SQI_M_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_NUMERO_CARTEACHAT2" path="/PES_ReleveCarteAchat/PES_CarteAchat/PESFacture/FactureIndiv/@added:numero_carteachat" column="NUMERO_CARTEACHAT" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" datatype="string"/-->
<sql-index id="SQI_M_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_NUMERO_COMMANDE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/@added:numero_commande" column="NUMERO_COMMANDE" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" datatype="string"/>
<!--sql-index id="SQI_M_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_NUMERO_COMMANDE2" path="/PES_ReleveCarteAchat/PES_CarteAchat/PESFacture/FactureIndiv/@added:numero_commande" column="NUMERO_COMMANDE" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" datatype="string"/-->
                
<!-- SQL-INDEX /PES_ReleveCarteAchat/PES_CarteAchat -->

<!-- SQL-INDEX /PES_ReleveCarteAchat/PES_CarteAchat/PESFacture -->
                <!--sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_PRIMARYKEY" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/@added:primarykey" column="PRIMARY_KEY" table="PES_CARTEACHAT_PESFACTURE_IX" datatype="string"/-->
                <!--sql-index id="SQI_PES_CARTEACHAT_PESFACTURE__NODE_ID" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/@added:generated-id" column="NODE_ID" datatype="string" table="PES_CARTEACHAT_PESFACTURE_IX"/-->
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TYPEFACT" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:TypeFact/@V" datatype="string" column="TYPEFACT" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_CODPAYS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Emetteur/n:Adresse/n:CodPays/@V" datatype="integer" column="CODPAYS" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_SERVICE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Emetteur/n:Service/@V" datatype="string" column="SERVICE" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_COMPLNOM" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Emetteur/n:InfoTiers/n:ComplNom/@V" datatype="string" column="COMPLNOM" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_DEVISE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Devise/@V" datatype="string" column="DEVISE" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_IDBANCINT" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Emetteur/n:CpteBancaire/n:IdBancInt/@V" datatype="string" column="IDBANCINT" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_NUMSEQUENCE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:NumSequence/@V" datatype="integer" column="NUMSEQUENCE" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_DTEIDTIERS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Emetteur/n:InfoTiers/n:DteIdTiers/@V" datatype="date" format="yyyy-MM-dd" column="DTEIDTIERS" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TITCPTE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Emetteur/n:CpteBancaire/n:TitCpte/@V" datatype="string" column="TITCPTE" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_CP" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Emetteur/n:Adresse/n:CP/@V" datatype="string" column="CP" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_DESCRIPTION" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Nomenclatures/n:NomenclatureBudget/n:Description/@V" datatype="string" column="DESCRIPTION" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_REFTIERS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Emetteur/n:InfoTiers/n:RefTiers/@V" datatype="string" column="REFTIERS" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_DTEBANC" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Emetteur/n:CpteBancaire/n:DteBanc/@V" datatype="date" format="yyyy-MM-dd" column="DTEBANC" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_ADR3" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Emetteur/n:Adresse/n:Adr3/@V" datatype="string" column="ADR3" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_ADR2" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Emetteur/n:Adresse/n:Adr2/@V" datatype="string" column="ADR2" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_CATTIERS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Emetteur/n:InfoTiers/n:CatTiers/@V" datatype="string" column="CATTIERS" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_NATJUR" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Emetteur/n:InfoTiers/n:NatJur/@V" datatype="string" column="NATJUR" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_ADR1" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Emetteur/n:Adresse/n:Adr1/@V" datatype="string" column="ADR1" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_NATIDTIERS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Emetteur/n:InfoTiers/n:NatIdTiers/@V" datatype="string" column="NATIDTIERS" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_DTEADR" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Emetteur/n:Adresse/n:DteAdr/@V" datatype="date" format="yyyy-MM-dd" column="DTEADR" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_PRENOM" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Emetteur/n:InfoTiers/n:Prenom/@V" datatype="string" column="PRENOM" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_LIBBANC" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Emetteur/n:CpteBancaire/n:LibBanc/@V" datatype="string" column="LIBBANC" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_NUMTVA" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Emetteur/n:NumTVA/@V" datatype="string" column="NUMTVA" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_CODRES" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Emetteur/n:Adresse/n:CodRes/@V" datatype="string" column="CODRES" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_NOM" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Emetteur/n:InfoTiers/n:Nom/@V" datatype="string" column="NOM" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_ANNEE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Annee/@V" datatype="string" column="ANNEE" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_CLERIB" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Emetteur/n:CpteBancaire/n:CleRib/@V" datatype="integer" column="CLERIB" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TYPTIERS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Emetteur/n:InfoTiers/n:TypTiers/@V" datatype="string" column="TYPTIERS" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_CODEETAB" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Emetteur/n:CpteBancaire/n:CodeEtab/@V" datatype="string" column="CODEETAB" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_VILLE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Emetteur/n:Adresse/n:Ville/@V" datatype="string" column="VILLE" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_DATE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Date/@V" datatype="date" format="yyyy-MM-dd" column="DATE" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_CODEGUIC" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Emetteur/n:CpteBancaire/n:CodeGuic/@V" datatype="string" column="CODEGUIC" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_IDPAYINT" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Emetteur/n:CpteBancaire/n:IdPayInt/@V" datatype="string" column="IDPAYINT" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_IDTIERS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Emetteur/n:InfoTiers/n:IdTiers/@V" datatype="string" column="IDTIERS" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TYPETIERSFACTURE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Emetteur/n:TypeTiersFacture/@V" datatype="string" column="TYPETIERSFACTURE" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TYPADR" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Emetteur/n:Adresse/n:TypAdr/@V" datatype="string" column="TYPADR" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_DTEMALADE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Emetteur/n:InfoTiers/n:DteMalade/@V" datatype="date" format="yyyy-MM-dd" column="DTEMALADE" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_CIVILITE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Emetteur/n:InfoTiers/n:Civilite/@V" datatype="string" column="CIVILITE" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_IDCPTE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Emetteur/n:CpteBancaire/n:IdCpte/@V" datatype="string" column="IDCPTE" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_IDVER" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:IdVer/@V" datatype="decimal" column="IDVER" table="PES_CARTEACHAT_PESFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_MOIS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/@added:mois" datatype="string" table="PES_CARTEACHAT_PESFACTURE_IX" column="MOIS"/>                

<!-- SQL-INDEX /PES_ReleveCarteAchat/PES_CarteAchat/PESFacture/Tiers -->
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS__NODE_ID" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/@added:generated-id" column="NODE_ID" datatype="string" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX"/>
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_DTEBANC" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/n:CpteBancaire/n:DteBanc/@V" datatype="date" format="yyyy-MM-dd" column="DTEBANC" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_VILLE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/n:Adresse/n:Ville/@V" datatype="string" column="VILLE" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_TYPADR" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/n:Adresse/n:TypAdr/@V" datatype="string" column="TYPADR" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_CP" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/n:Adresse/n:CP/@V" datatype="string" column="CP" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_CATTIERS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/n:InfoTiers/n:CatTiers/@V" datatype="string" column="CATTIERS" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_TYPETIERSFACTURE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/n:TypeTiersFacture/@V" datatype="string" column="TYPETIERSFACTURE" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_NUMTVA" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/n:NumTVA/@V" datatype="string" column="NUMTVA" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_IDTIERS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/n:InfoTiers/n:IdTiers/@V" datatype="string" column="IDTIERS" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_CODRES" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/n:Adresse/n:CodRes/@V" datatype="string" column="CODRES" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_CLERIB" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/n:CpteBancaire/n:CleRib/@V" datatype="integer" column="CLERIB" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_CODEGUIC" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/n:CpteBancaire/n:CodeGuic/@V" datatype="string" column="CODEGUIC" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_CODPAYS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/n:Adresse/n:CodPays/@V" datatype="integer" column="CODPAYS" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_PRENOM" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/n:InfoTiers/n:Prenom/@V" datatype="string" column="PRENOM" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_IDPAYINT" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/n:CpteBancaire/n:IdPayInt/@V" datatype="string" column="IDPAYINT" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_SERVICE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/n:Service/@V" datatype="string" column="SERVICE" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_IDBANCINT" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/n:CpteBancaire/n:IdBancInt/@V" datatype="string" column="IDBANCINT" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_TYPTIERS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/n:InfoTiers/n:TypTiers/@V" datatype="string" column="TYPTIERS" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_REFTIERS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/n:InfoTiers/n:RefTiers/@V" datatype="string" column="REFTIERS" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_NOM" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/n:InfoTiers/n:Nom/@V" datatype="string" column="NOM" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_CODEETAB" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/n:CpteBancaire/n:CodeEtab/@V" datatype="string" column="CODEETAB" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_ADR3" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/n:Adresse/n:Adr3/@V" datatype="string" column="ADR3" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_NATIDTIERS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/n:InfoTiers/n:NatIdTiers/@V" datatype="string" column="NATIDTIERS" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_IDCPTE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/n:CpteBancaire/n:IdCpte/@V" datatype="string" column="IDCPTE" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_ADR2" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/n:Adresse/n:Adr2/@V" datatype="string" column="ADR2" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_TITCPTE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/n:CpteBancaire/n:TitCpte/@V" datatype="string" column="TITCPTE" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_LIBBANC" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/n:CpteBancaire/n:LibBanc/@V" datatype="string" column="LIBBANC" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_ADR1" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/n:Adresse/n:Adr1/@V" datatype="string" column="ADR1" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_DTEIDTIERS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/n:InfoTiers/n:DteIdTiers/@V" datatype="date" format="yyyy-MM-dd" column="DTEIDTIERS" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_NATJUR" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/n:InfoTiers/n:NatJur/@V" datatype="string" column="NATJUR" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_DTEADR" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/n:Adresse/n:DteAdr/@V" datatype="date" format="yyyy-MM-dd" column="DTEADR" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_DTEMALADE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/n:InfoTiers/n:DteMalade/@V" datatype="date" format="yyyy-MM-dd" column="DTEMALADE" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_CIVILITE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/n:InfoTiers/n:Civilite/@V" datatype="string" column="CIVILITE" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_TIERS_COMPLNOM" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:Tiers/n:InfoTiers/n:ComplNom/@V" datatype="string" column="COMPLNOM" table="PES_CARTEACHAT_PESFACTURE_TIERS_IX" />

<!-- SQL-INDEX /PES_ReleveCarteAchat/PES_CarteAchat/PESFacture/FactureIndiv -->
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV__NODE_ID" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/@added:generated-id" column="NODE_ID" datatype="string" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX"/>
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_TYPEFACT" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:TypeFact/@V" datatype="string" column="TYPEFACT" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_CODPAYS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Debiteur/n:Adresse/n:CodPays/@V" datatype="integer" column="CODPAYS" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_SERVICE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Debiteur/n:Service/@V" datatype="string" column="SERVICE" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_COMPLNOM" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:ComplNom/@V" datatype="string" column="COMPLNOM" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_MTTOTALTTC" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:TotalAPayer/n:MtTotalTTC/@V" datatype="decimal" column="MTTOTALTTC" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IDBANCINT" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Debiteur/n:CpteBancaire/n:IdBancInt/@V" datatype="string" column="IDBANCINT" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_OBJET" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Objet/@V" datatype="string" column="OBJET" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_DATEEMISSION" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:DateEmission/@V" datatype="date" format="yyyy-MM-dd" column="DATEEMISSION" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_TEXTEGENERATEUR" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:TexteGenerateur/@V" datatype="string" column="TEXTEGENERATEUR" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_DTEIDTIERS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:DteIdTiers/@V" datatype="date" format="yyyy-MM-dd" column="DTEIDTIERS" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_TITCPTE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Debiteur/n:CpteBancaire/n:TitCpte/@V" datatype="string" column="TITCPTE" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_CP" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Debiteur/n:Adresse/n:CP/@V" datatype="string" column="CP" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_REFTIERS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:RefTiers/@V" datatype="string" column="REFTIERS" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_DTEBANC" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Debiteur/n:CpteBancaire/n:DteBanc/@V" datatype="date" format="yyyy-MM-dd" column="DTEBANC" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_ADR3" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Debiteur/n:Adresse/n:Adr3/@V" datatype="string" column="ADR3" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_ADR2" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Debiteur/n:Adresse/n:Adr2/@V" datatype="string" column="ADR2" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_CATTIERS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:CatTiers/@V" datatype="string" column="CATTIERS" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_NATJUR" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:NatJur/@V" datatype="string" column="NATJUR" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_ADR1" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Debiteur/n:Adresse/n:Adr1/@V" datatype="string" column="ADR1" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_NATIDTIERS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:NatIdTiers/@V" datatype="string" column="NATIDTIERS" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_MTTOTALTVA" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:TotalAPayer/n:MtTotalTVA/@V" datatype="decimal" column="MTTOTALTVA" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_DTEADR" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Debiteur/n:Adresse/n:DteAdr/@V" datatype="date" format="yyyy-MM-dd" column="DTEADR" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_MOYENPAIEMENT" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:MoyenPaiement/@V" datatype="string" column="MOYENPAIEMENT" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_NUMEROCONTRAT" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:NumeroContrat/@V" datatype="string" column="NUMEROCONTRAT" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_PRENOM" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:Prenom/@V" datatype="string" column="PRENOM" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_LIBBANC" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Debiteur/n:CpteBancaire/n:LibBanc/@V" datatype="string" column="LIBBANC" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_NUMEROFACTURE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:NumeroFacture/@V" datatype="string" column="NUMEROFACTURE" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_NUMEROMARCHE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:NumeroMarche/@V" datatype="string" column="NUMEROMARCHE" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_NUMTVA" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Debiteur/n:NumTVA/@V" datatype="string" column="NUMTVA" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_MTTOTALHT" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:TotalAPayer/n:MtTotalHT/@V" datatype="decimal" column="MTTOTALHT" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_CODRES" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Debiteur/n:Adresse/n:CodRes/@V" datatype="string" column="CODRES" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_NOM" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:Nom/@V" datatype="string" column="NOM" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_MODALITESREGLEMENT" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:ModalitesReglement/@V" datatype="string" column="MODALITESREGLEMENT" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_CLERIB" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Debiteur/n:CpteBancaire/n:CleRib/@V" datatype="integer" column="CLERIB" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_TYPTIERS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:TypTiers/@V" datatype="string" column="TYPTIERS" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_CODEETAB" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Debiteur/n:CpteBancaire/n:CodeEtab/@V" datatype="string" column="CODEETAB" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_DATEREGLEMENT" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:DateReglement/@V" datatype="date" format="yyyy-MM-dd" column="DATEREGLEMENT" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_CONDITIONSGEN" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:ConditionsGen/@V" datatype="string" column="CONDITIONSGEN" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_VILLE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Debiteur/n:Adresse/n:Ville/@V" datatype="string" column="VILLE" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_CODEGUIC" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Debiteur/n:CpteBancaire/n:CodeGuic/@V" datatype="string" column="CODEGUIC" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IDPAYINT" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Debiteur/n:CpteBancaire/n:IdPayInt/@V" datatype="string" column="IDPAYINT" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IDTIERS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:IdTiers/@V" datatype="string" column="IDTIERS" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_TYPETIERSFACTURE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Debiteur/n:TypeTiersFacture/@V" datatype="string" column="TYPETIERSFACTURE" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_TYPADR" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Debiteur/n:Adresse/n:TypAdr/@V" datatype="string" column="TYPADR" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_DTEMALADE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:DteMalade/@V" datatype="date" format="yyyy-MM-dd" column="DTEMALADE" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_TAUXREMISE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:TauxRemise/@V" datatype="decimal" column="TAUXREMISE" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_CIVILITE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:Civilite/@V" datatype="string" column="CIVILITE" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IDCPTE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Debiteur/n:CpteBancaire/n:IdCpte/@V" datatype="string" column="IDCPTE" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_MTREMISE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:MtRemise/@V" datatype="decimal" column="MTREMISE" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_FOURNISSEUR" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/@added:fournisseur" datatype="string" column="FOURNISSEUR" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
<sql-index id="SQI_PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_NUMEROENGAGEMENT" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:NumeroEngagement/@V" datatype="string" column="NUMEROENGAGEMENT" table="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX" />
                
<!-- SQL-INDEX /n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Reference -->
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_REFERENCE__NODE_ID" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Reference/@added:generated-id" column="NODE_ID" datatype="string" table="PES_CARTEACHAT_FACTUREINDIV_REFERENCE_IX"/>
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_REFERENCE_NUMEROPIECE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Reference/n:NumeroPiece/@V" datatype="string" column="NUMEROPIECE" table="PES_CARTEACHAT_FACTUREINDIV_REFERENCE_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_REFERENCE_TYPEPIECE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Reference/n:TypePiece/@V" datatype="string" column="TYPEPIECE" table="PES_CARTEACHAT_FACTUREINDIV_REFERENCE_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_REFERENCE_NUMLIGNE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Reference/n:NumLigne/@V" datatype="integer" column="NUMLIGNE" table="PES_CARTEACHAT_FACTUREINDIV_REFERENCE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_REF_NUMEROFACTURE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:NumeroFacture/@V" datatype="string" column="NUMEROFACTURE" table="PES_CARTEACHAT_FACTUREINDIV_REFERENCE_IX" use-in-criteria="false" reset-on="key3"/>
                

<!-- SQL-INDEX /n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers -->
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS__NODE_ID" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/@added:generated-id" column="NODE_ID" datatype="string" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX"/>
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_DTEBANC" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/n:CpteBancaire/n:DteBanc/@V" datatype="date" format="yyyy-MM-dd" column="DTEBANC" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_VILLE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/n:Adresse/n:Ville/@V" datatype="string" column="VILLE" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_TYPADR" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/n:Adresse/n:TypAdr/@V" datatype="string" column="TYPADR" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_CP" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/n:Adresse/n:CP/@V" datatype="string" column="CP" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_CATTIERS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:CatTiers/@V" datatype="string" column="CATTIERS" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_TYPETIERSFACTURE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/n:TypeTiersFacture/@V" datatype="string" column="TYPETIERSFACTURE" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_NUMTVA" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/n:NumTVA/@V" datatype="string" column="NUMTVA" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_IDTIERS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:IdTiers/@V" datatype="string" column="IDTIERS" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_CODRES" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/n:Adresse/n:CodRes/@V" datatype="string" column="CODRES" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_CLERIB" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/n:CpteBancaire/n:CleRib/@V" datatype="integer" column="CLERIB" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_CODEGUIC" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/n:CpteBancaire/n:CodeGuic/@V" datatype="string" column="CODEGUIC" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_CODPAYS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/n:Adresse/n:CodPays/@V" datatype="integer" column="CODPAYS" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_PRENOM" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:Prenom/@V" datatype="string" column="PRENOM" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_IDPAYINT" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/n:CpteBancaire/n:IdPayInt/@V" datatype="string" column="IDPAYINT" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_SERVICE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/n:Service/@V" datatype="string" column="SERVICE" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_IDBANCINT" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/n:CpteBancaire/n:IdBancInt/@V" datatype="string" column="IDBANCINT" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_TYPTIERS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:TypTiers/@V" datatype="string" column="TYPTIERS" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_REFTIERS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:RefTiers/@V" datatype="string" column="REFTIERS" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_NOM" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:Nom/@V" datatype="string" column="NOM" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" format="uppercase"/>
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_CODEETAB" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/n:CpteBancaire/n:CodeEtab/@V" datatype="string" column="CODEETAB" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_ADR3" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/n:Adresse/n:Adr3/@V" datatype="string" column="ADR3" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_NATIDTIERS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:NatIdTiers/@V" datatype="string" column="NATIDTIERS" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_IDCPTE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/n:CpteBancaire/n:IdCpte/@V" datatype="string" column="IDCPTE" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_ADR2" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/n:Adresse/n:Adr2/@V" datatype="string" column="ADR2" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_TITCPTE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/n:CpteBancaire/n:TitCpte/@V" datatype="string" column="TITCPTE" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_LIBBANC" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/n:CpteBancaire/n:LibBanc/@V" datatype="string" column="LIBBANC" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_ADR1" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/n:Adresse/n:Adr1/@V" datatype="string" column="ADR1" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_DTEIDTIERS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:DteIdTiers/@V" datatype="date" format="yyyy-MM-dd" column="DTEIDTIERS" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_NATJUR" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:NatJur/@V" datatype="string" column="NATJUR" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_DTEADR" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/n:Adresse/n:DteAdr/@V" datatype="date" format="yyyy-MM-dd" column="DTEADR" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_DTEMALADE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:DteMalade/@V" datatype="date" format="yyyy-MM-dd" column="DTEMALADE" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_CIVILITE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:Civilite/@V" datatype="string" column="CIVILITE" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_COMPLNOM" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:ComplNom/@V" datatype="string" column="COMPLNOM" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_TIERS_NUMEROFACTURE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:NumeroFacture/@V" datatype="string" column="NUMEROFACTURE" table="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX" use-in-criteria="false" reset-on="key3"/>
                
<!-- SQL-INDEX /n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture -->
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE__NODE_ID" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/@added:generated-id" column="NODE_ID" datatype="string" table="PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_IX"/>
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_ORDRE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Ordre/@V" datatype="integer" column="ORDRE" table="PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_CODEFONCTION" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:CodeFonction/@V" datatype="string" column="CODEFONCTION" table="PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_MTTTC" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:MtTTC/@V" datatype="decimal" column="MTTTC" table="PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_TAUX" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Taux/@V" datatype="decimal" column="TAUX" table="PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_MTREMISE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:MtRemise/@V" datatype="decimal" column="MTREMISE" table="PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_MTHT" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:MtHT/@V" datatype="decimal" column="MTHT" table="PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_TAUXTVA" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:TauxTVA/@V" datatype="decimal" column="TAUXTVA" table="PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_MTTVA" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:MtTVA/@V" datatype="decimal" column="MTTVA" table="PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_ORDREEDITION" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:OrdreEdition/@V" datatype="integer" column="ORDREEDITION" table="PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_CODEPRODUIT" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:CodeProduit/@V" datatype="string" column="CODEPRODUIT" table="PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_TAUXREMISE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:TauxRemise/@V" datatype="decimal" column="TAUXREMISE" table="PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_CODENATURE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:CodeNature/@V" datatype="string" column="CODENATURE" table="PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_LIBELLE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Libelle/@V" datatype="string" column="LIBELLE" table="PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_UNITE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Unite/@V" datatype="string" column="UNITE" table="PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_IX"/>                
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_QUANTITE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Quantite/@V" datatype="decimal" column="QUANTITE" table="PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_IX"/>                
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_MTUNITAIRE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:MtUnitaire/@V" datatype="decimal" column="MTUNITAIRE" table="PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_IX"/>                
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_MTBASE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:MtBase/@V" datatype="decimal" column="MTBASE" table="PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_IX"/>                
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_NUMEROIMPUTATION" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:NumeroImputation/@V" datatype="string" column="NUMEROIMPUTATION" table="PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_LIG_NUMEROFACTURE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:NumeroFacture/@V" datatype="string" column="NUMEROFACTURE" table="PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_IX" use-in-criteria="false" reset-on="key3"/>

<!-- SQL-INDEX /n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers -->
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS__NODE_ID" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/@added:generated-id" column="NODE_ID" datatype="string" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX"/>
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_DTEBANC" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:CpteBancaire/n:DteBanc/@V" datatype="date" format="yyyy-MM-dd" column="DTEBANC" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_VILLE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:Adresse/n:Ville/@V" datatype="string" column="VILLE" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_TYPADR" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:Adresse/n:TypAdr/@V" datatype="string" column="TYPADR" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_CP" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:Adresse/n:CP/@V" datatype="string" column="CP" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_CATTIERS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:CatTiers/@V" datatype="string" column="CATTIERS" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_TYPETIERSFACTURE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:TypeTiersFacture/@V" datatype="string" column="TYPETIERSFACTURE" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_NUMTVA" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:NumTVA/@V" datatype="string" column="NUMTVA" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_IDTIERS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:IdTiers/@V" datatype="string" column="IDTIERS" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_CODRES" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:Adresse/n:CodRes/@V" datatype="string" column="CODRES" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_CLERIB" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:CpteBancaire/n:CleRib/@V" datatype="integer" column="CLERIB" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_CODEGUIC" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:CpteBancaire/n:CodeGuic/@V" datatype="string" column="CODEGUIC" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_CODPAYS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:Adresse/n:CodPays/@V" datatype="integer" column="CODPAYS" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_PRENOM" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:Prenom/@V" datatype="string" column="PRENOM" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_IDPAYINT" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:CpteBancaire/n:IdPayInt/@V" datatype="string" column="IDPAYINT" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_SERVICE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:Service/@V" datatype="string" column="SERVICE" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_IDBANCINT" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:CpteBancaire/n:IdBancInt/@V" datatype="string" column="IDBANCINT" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_TYPTIERS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:TypTiers/@V" datatype="string" column="TYPTIERS" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_REFTIERS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:RefTiers/@V" datatype="string" column="REFTIERS" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_NOM" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:Nom/@V" datatype="string" column="NOM" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_CODEETAB" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:CpteBancaire/n:CodeEtab/@V" datatype="string" column="CODEETAB" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_ADR3" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:Adresse/n:Adr3/@V" datatype="string" column="ADR3" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_NATIDTIERS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:NatIdTiers/@V" datatype="string" column="NATIDTIERS" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_IDCPTE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:CpteBancaire/n:IdCpte/@V" datatype="string" column="IDCPTE" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_ADR2" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:Adresse/n:Adr2/@V" datatype="string" column="ADR2" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_TITCPTE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:CpteBancaire/n:TitCpte/@V" datatype="string" column="TITCPTE" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_LIBBANC" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:CpteBancaire/n:LibBanc/@V" datatype="string" column="LIBBANC" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_ADR1" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:Adresse/n:Adr1/@V" datatype="string" column="ADR1" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_DTEIDTIERS" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:DteIdTiers/@V" datatype="date" format="yyyy-MM-dd" column="DTEIDTIERS" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_NATJUR" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:NatJur/@V" datatype="string" column="NATJUR" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_DTEADR" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:Adresse/n:DteAdr/@V" datatype="date" format="yyyy-MM-dd" column="DTEADR" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_DTEMALADE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:DteMalade/@V" datatype="date" format="yyyy-MM-dd" column="DTEMALADE" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_CIVILITE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:Civilite/@V" datatype="string" column="CIVILITE" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_TIERS_COMPLNOM" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:ComplNom/@V" datatype="string" column="COMPLNOM" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_LFTIERS_NUMEROFACTURE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:NumeroFacture/@V" datatype="string" column="NUMEROFACTURE" table="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX" use-in-criteria="false" reset-on="key3"/>
                
<!-- SQL-INDEX /n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:reference -->
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_REFERENCE__NODE_ID" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:reference/@added:generated-id" column="NODE_ID" datatype="string" table="PES_CARTEACHAT_LIGNEFACTURE_REFERENCE_IX"/>
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_REFERENCE_NUMEROPIECE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:reference/n:NumeroPiece/@V" datatype="string" column="NUMEROPIECE" table="PES_CARTEACHAT_LIGNEFACTURE_REFERENCE_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_REFERENCE_TYPEPIECE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:reference/n:TypePiece/@V" datatype="string" column="TYPEPIECE" table="PES_CARTEACHAT_LIGNEFACTURE_REFERENCE_IX" />
<sql-index id="SQI_PES_CARTEACHAT_LIGNEFACTURE_REFERENCE_NUMLIGNE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:reference/n:NumLigne/@V" datatype="integer" column="NUMLIGNE" table="PES_CARTEACHAT_LIGNEFACTURE_REFERENCE_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_LFREF_NUMEROFACTURE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:NumeroFacture/@V" datatype="string" column="NUMEROFACTURE" table="PES_CARTEACHAT_LIGNEFACTURE_REFERENCE_IX" use-in-criteria="false" reset-on="key3"/>
                
<!-- SQL-INDEX /n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:DetailTVA -->
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_DETAILTVA__NODE_ID" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:DetailTVA/@added:generated-id" column="NODE_ID" datatype="string" table="PES_CARTEACHAT_FACTUREINDIV_DETAILTVA_IX"/>
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_DETAILTVA_TAUXTVA" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:DetailTVA/n:TauxTVA/@V" datatype="decimal" column="TAUXTVA" table="PES_CARTEACHAT_FACTUREINDIV_DETAILTVA_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_DETAILTVA_MTTVA" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:DetailTVA/n:MtTVA/@V" datatype="decimal" column="MTTVA" table="PES_CARTEACHAT_FACTUREINDIV_DETAILTVA_IX" />
<sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_DETAILTVA_MTBASEHT" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:DetailTVA/n:MtBaseHT/@V" datatype="decimal" column="MTBASEHT" table="PES_CARTEACHAT_FACTUREINDIV_DETAILTVA_IX" />
                <sql-index id="SQI_PES_CARTEACHAT_FACTUREINDIV_FTVA_NUMEROFACTURE" path="/n:PES_ReleveCarteAchat/n:PES_CarteAchat/n:PESFacture/n:FactureIndiv/n:NumeroFacture/@V" datatype="string" column="NUMEROFACTURE" table="PES_CARTEACHAT_FACTUREINDIV_DETAILTVA_IX" use-in-criteria="false" reset-on="key3"/>
                
<element id="PES_CARTEACHAT_PESFACTURE_TIERS_IX"> 
<sql-count>COUNT(DISTINCT(CONCAT(PES_CARTEACHAT_PESFACTURE_IX.DOC_ID,PES_CARTEACHAT_PESFACTURE_TIERS_IX.NODE_ID)))</sql-count>
<special-cond>PES_CARTEACHAT_PESFACTURE_TIERS_IX.NODE_ID IS NOT NULL</special-cond>
</element>
<element id="PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX"> 
<sql-count>COUNT(DISTINCT(CONCAT(PES_CARTEACHAT_PESFACTURE_IX.DOC_ID,PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX.NODE_ID)))</sql-count>
<special-cond>PES_CARTEACHAT_PESFACTURE_FACTUREINDIV_IX.NODE_ID IS NOT NULL</special-cond>
</element>
<element id="PES_CARTEACHAT_FACTUREINDIV_REFERENCE_IX"> 
<sql-count>COUNT(DISTINCT(CONCAT(PES_CARTEACHAT_PESFACTURE_IX.DOC_ID,PES_CARTEACHAT_FACTUREINDIV_REFERENCE_IX.NODE_ID)))</sql-count>
<special-cond>PES_CARTEACHAT_FACTUREINDIV_REFERENCE_IX.NODE_ID IS NOT NULL</special-cond>
</element>
<element id="PES_CARTEACHAT_FACTUREINDIV_TIERS_IX"> 
<sql-count>COUNT(DISTINCT(CONCAT(PES_CARTEACHAT_PESFACTURE_IX.DOC_ID,PES_CARTEACHAT_FACTUREINDIV_TIERS_IX.NODE_ID)))</sql-count>
<special-cond>PES_CARTEACHAT_FACTUREINDIV_TIERS_IX.NODE_ID IS NOT NULL</special-cond>
</element>
<element id="PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_IX"> 
<sql-count>COUNT(DISTINCT(CONCAT(PES_CARTEACHAT_PESFACTURE_IX.DOC_ID,PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_IX.NODE_ID)))</sql-count>
<special-cond>PES_CARTEACHAT_FACTUREINDIV_LIGNEFACTURE_IX.NODE_ID IS NOT NULL</special-cond>
</element>
<element id="PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX"> 
<sql-count>COUNT(DISTINCT(CONCAT(PES_CARTEACHAT_PESFACTURE_IX.DOC_ID,PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX.NODE_ID)))</sql-count>
<special-cond>PES_CARTEACHAT_LIGNEFACTURE_TIERS_IX.NODE_ID IS NOT NULL</special-cond>
</element>
<element id="PES_CARTEACHAT_LIGNEFACTURE_REFERENCE_IX"> 
<sql-count>COUNT(DISTINCT(CONCAT(PES_CARTEACHAT_PESFACTURE_IX.DOC_ID,PES_CARTEACHAT_LIGNEFACTURE_REFERENCE_IX.NODE_ID)))</sql-count>
<special-cond>PES_CARTEACHAT_LIGNEFACTURE_REFERENCE_IX.NODE_ID IS NOT NULL</special-cond>
</element>
<element id="PES_CARTEACHAT_FACTUREINDIV_DETAILTVA_IX"> 
<sql-count>COUNT(DISTINCT(CONCAT(PES_CARTEACHAT_PESFACTURE_IX.DOC_ID,PES_CARTEACHAT_FACTUREINDIV_DETAILTVA_IX.NODE_ID)))</sql-count>
<special-cond>PES_CARTEACHAT_FACTUREINDIV_DETAILTVA_IX.NODE_ID IS NOT NULL</special-cond>
</element>

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