--- /dev/null
+<?xml version="1.0" encoding="ISO-8859-1"?>
+<!DOCTYPE xsl:stylesheet [
+<!ENTITY nbsp " ">
+]><xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
+ xmlns:n="http://www.minefi.gouv.fr/cp/helios/pes_v2/facture"
+ xmlns:added="http://projets.admisource.gouv.fr/xemelios/namespaces#added"
+ xmlns:ano="http://projets.admisource.gouv.fr/xemelios/namespaces#anomally"
+ xmlns:data="data.uri"
+ version="2.0">
+ <xsl:param name="elementId"/> <!-- 'PESFacture' pour afficher le releve, vide sinon -->
+ <xsl:param name="numeroFacture"/> <!-- dans le cas de l'affichage d'une FactureIndiv FactureIndiv/NumeroFacture/@V -->
+ <xsl:param name="browser-destination" />
+ <xsl:param name="anoId"/> <!-- id de l'anomalie a mettre en surbrillance -->
+ <xsl:output encoding="ISO-8859-1" method="xhtml" exclude-result-prefixes="n added ano data" doctype-public="-//W3C//DTD XHTML 1.0 Strict//EN" include-content-type="no" indent="yes"/>
+ <xsl:decimal-format name="decformat"
+ decimal-separator=","
+ grouping-separator=" "
+ digit="#"
+ pattern-separator=";"
+ NaN="NaN"
+ minus-sign="-"/>
+ <xsl:variable name="tags-ano">
+ <xsl:for-each select="//ano:Anomalie[@ano:anoId = $anoId]/ano:node">
+ <xsl:element name="node">
+ <xsl:attribute name="id" select="./@ano:id"/>
+ </xsl:element>
+ </xsl:for-each>
+ </xsl:variable>
+ <!-- Données pour les équivalences des codes -->
+ <xsl:variable name="data">
+ <data:data>
+ <data:codePaysINSEE>
+ <data:p V="99125">ALBANIE</data:p>
+ <data:p V="99109">ALLEMAGNE</data:p>
+ <data:p V="99130">ANDORRE</data:p>
+ <data:p V="99110">AUTRICHE</data:p>
+ <data:p V="99131">BELGIQUE</data:p>
+ <data:p V="99148">BIELORUSSIE</data:p>
+ <data:p V="99118">BOSNIE-HERZEGOVINE</data:p>
+ <data:p V="99103">BOUVET (ILE)</data:p>
+ <data:p V="99111">BULGARIE</data:p>
+ <data:p V="99119">CROATIE</data:p>
+ <data:p V="99101">DANEMARK</data:p>
+ <data:p V="99134">ESPAGNE</data:p>
+ <data:p V="99106">ESTONIE</data:p>
+ <data:p V="99156">EX-REPUBLIQUE YOUGOSLAVE DE MACEDOINE</data:p>
+ <data:p V="99101">FEROE (ILES)</data:p>
+ <data:p V="99105">FINLANDE</data:p>
+ <data:p V="99133">GIBRALTAR</data:p>
+ <data:p V="99126">GRECE</data:p>
+ <data:p V="99112">HONGRIE</data:p>
+ <data:p V="99136">IRLANDE, ou EIRE</data:p>
+ <data:p V="99102">ISLANDE</data:p>
+ <data:p V="99127">ITALIE</data:p>
+ <data:p V="99107">LETTONIE</data:p>
+ <data:p V="99113">LIECHTENSTEIN</data:p>
+ <data:p V="99108">LITUANIE</data:p>
+ <data:p V="99137">LUXEMBOURG</data:p>
+ <data:p V="99144">MALTE</data:p>
+ <data:p V="99151">MOLDAVIE</data:p>
+ <data:p V="99138">MONACO</data:p>
+ <data:p V="99120">MONTENEGRO</data:p>
+ <data:p V="99103">NORVEGE</data:p>
+ <data:p V="99135">PAYS-BAS</data:p>
+ <data:p V="99122">POLOGNE</data:p>
+ <data:p V="99139">PORTUGAL</data:p>
+ <data:p V="99141">REPUBLIQUE DEMOCRATIQUE ALLEMANDE</data:p>
+ <data:p V="99142">REPUBLIQUE FEDERALE D'ALLEMAGNE</data:p>
+ <data:p V="99114">ROUMANIE</data:p>
+ <data:p V="99132">ROYAUME-UNI</data:p>
+ <data:p V="99123">RUSSIE</data:p>
+ <data:p V="99128">SAINT-MARIN</data:p>
+ <data:p V="99121">SERBIE-ET-MONTÉNÉGRO</data:p>
+ <data:p V="99117">SLOVAQUIE</data:p>
+ <data:p V="99145">SLOVENIE</data:p>
+ <data:p V="99104">SUEDE</data:p>
+ <data:p V="99140">SUISSE</data:p>
+ <data:p V="99103">SVALBARD et ILE JAN MAYEN</data:p>
+ <data:p V="99115">TCHECOSLOVAQUIE</data:p>
+ <data:p V="99116">TCHEQUE (REPUBLIQUE)</data:p>
+ <data:p V="99124">TURQUIE D'EUROPE</data:p>
+ <data:p V="99155">UKRAINE</data:p>
+ <data:p V="99129">VATICAN, ou SAINT-SIEGE</data:p>
+ <data:p V="99212">AFGHANISTAN</data:p>
+ <data:p V="99201">ARABIE SAOUDITE</data:p>
+ <data:p V="99252">ARMENIE</data:p>
+ <data:p V="99253">AZERBAIDJAN</data:p>
+ <data:p V="99249">BAHREIN</data:p>
+ <data:p V="99246">BANGLADESH</data:p>
+ <data:p V="99214">BHOUTAN</data:p>
+ <data:p V="99224">BIRMANIE</data:p>
+ <data:p V="99225">BRUNEI</data:p>
+ <data:p V="99234">CAMBODGE</data:p>
+ <data:p V="99216">CHINE</data:p>
+ <data:p V="99254">CHYPRE</data:p>
+ <data:p V="99237">COREE</data:p>
+ <data:p V="99239">COREE (REPUBLIQUE DE)</data:p>
+ <data:p V="99238">COREE (REPUBLIQUE POPULAIRE DEMOCRATIQUE DE)</data:p>
+ <data:p V="99247">EMIRATS ARABES UNIS</data:p>
+ <data:p V="99228">ETATS MALAIS NON FEDERES</data:p>
+ <data:p V="99255">GEORGIE</data:p>
+ <data:p V="99223">GOA</data:p>
+ <data:p V="99230">HONG-KONG</data:p>
+ <data:p V="99223">INDE</data:p>
+ <data:p V="99231">INDONESIE</data:p>
+ <data:p V="99204">IRAN</data:p>
+ <data:p V="99203">IRAQ</data:p>
+ <data:p V="99207">ISRAEL</data:p>
+ <data:p V="99217">JAPON</data:p>
+ <data:p V="99222">JORDANIE</data:p>
+ <data:p V="99211">KAMTCHATKA</data:p>
+ <data:p V="99256">KAZAKHSTAN</data:p>
+ <data:p V="99257">KIRGHIZISTAN</data:p>
+ <data:p V="99240">KOWEIT</data:p>
+ <data:p V="99241">LAOS</data:p>
+ <data:p V="99205">LIBAN</data:p>
+ <data:p V="99232">MACAO</data:p>
+ <data:p V="99227">MALAISIE</data:p>
+ <data:p V="99229">MALDIVES</data:p>
+ <data:p V="99218">MANDCHOURIE</data:p>
+ <data:p V="99242">MONGOLIE</data:p>
+ <data:p V="99215">NEPAL</data:p>
+ <data:p V="99250">OMAN</data:p>
+ <data:p V="99258">OUZBEKISTAN</data:p>
+ <data:p V="99213">PAKISTAN</data:p>
+ <data:p V="99261">PALESTINE</data:p>
+ <data:p V="99220">PHILIPPINES</data:p>
+ <data:p V="99221">POSSESSIONS BRITANNIQUES AU PROCHE-ORIENT</data:p>
+ <data:p V="99248">QATAR</data:p>
+ <data:p V="99209">SIBERIE</data:p>
+ <data:p V="99226">SINGAPOUR</data:p>
+ <data:p V="99235">SRI LANKA</data:p>
+ <data:p V="99206">SYRIE</data:p>
+ <data:p V="99259">TADJIKISTAN</data:p>
+ <data:p V="99236">TAIWAN</data:p>
+ <data:p V="99219">THAILANDE</data:p>
+ <data:p V="99262">TIMOR ORIENTAL</data:p>
+ <data:p V="99210">TURKESTAN RUSSE</data:p>
+ <data:p V="99260">TURKMENISTAN</data:p>
+ <data:p V="99208">TURQUIE</data:p>
+ <data:p V="99243">VIET NAM</data:p>
+ <data:p V="99244">VIET NAM DU NORD</data:p>
+ <data:p V="99245">VIET NAM DU SUD</data:p>
+ <data:p V="99251">YEMEN</data:p>
+ <data:p V="99233">YEMEN DEMOCRATIQUE</data:p>
+ <data:p V="99202">YEMEN (REPUBLIQUE ARABE DU)</data:p>
+ <data:p V="99319">ACORES, MADERE</data:p>
+ <data:p V="99303">AFRIQUE DU SUD</data:p>
+ <data:p V="99352">ALGERIE</data:p>
+ <data:p V="99395">ANGOLA</data:p>
+ <data:p V="99327">BENIN</data:p>
+ <data:p V="99347">BOTSWANA</data:p>
+ <data:p V="99331">BURKINA</data:p>
+ <data:p V="99321">BURUNDI</data:p>
+ <data:p V="99322">CAMEROUN</data:p>
+ <data:p V="99305">CAMEROUN ET TOGO</data:p>
+ <data:p V="99313">CANARIES (ILES)</data:p>
+ <data:p V="99396">CAP-VERT</data:p>
+ <data:p V="99323">CENTRAFRICAINE (REPUBLIQUE)</data:p>
+ <data:p V="99397">COMORES</data:p>
+ <data:p V="99324">CONGO</data:p>
+ <data:p V="99312">CONGO (REPUBLIQUE DEMOCRATIQUE)</data:p>
+ <data:p V="99326">COTE D'IVOIRE</data:p>
+ <data:p V="99399">DJIBOUTI</data:p>
+ <data:p V="99301">EGYPTE</data:p>
+ <data:p V="99317">ERYTHREE</data:p>
+ <data:p V="99315">ETHIOPIE</data:p>
+ <data:p V="99328">GABON</data:p>
+ <data:p V="99304">GAMBIE</data:p>
+ <data:p V="99329">GHANA</data:p>
+ <data:p V="99330">GUINEE</data:p>
+ <data:p V="99314">GUINEE EQUATORIALE</data:p>
+ <data:p V="99392">GUINEE-BISSAU</data:p>
+ <data:p V="99320">ILES PORTUGAISES DE L'OCEAN INDIEN</data:p>
+ <data:p V="99332">KENYA</data:p>
+ <data:p V="99348">LESOTHO</data:p>
+ <data:p V="99302">LIBERIA</data:p>
+ <data:p V="99316">LIBYE</data:p>
+ <data:p V="99333">MADAGASCAR</data:p>
+ <data:p V="99334">MALAWI</data:p>
+ <data:p V="99335">MALI</data:p>
+ <data:p V="99350">MAROC</data:p>
+ <data:p V="99390">MAURICE</data:p>
+ <data:p V="99336">MAURITANIE</data:p>
+ <data:p V="99393">MOZAMBIQUE</data:p>
+ <data:p V="99311">NAMIBIE</data:p>
+ <data:p V="99337">NIGER</data:p>
+ <data:p V="99338">NIGERIA</data:p>
+ <data:p V="99308">OCEAN INDIEN (TERRITOIRE BRITANNIQUE DE L')</data:p>
+ <data:p V="99339">OUGANDA</data:p>
+ <data:p V="99313">PRESIDES</data:p>
+ <data:p V="99313">PROVINCES ESPAGNOLES D'AFRIQUE</data:p>
+ <data:p V="99340">RWANDA</data:p>
+ <data:p V="99389">SAHARA OCCIDENTAL</data:p>
+ <data:p V="99306">SAINTE-HELENE</data:p>
+ <data:p V="99394">SAO TOME-ET-PRINCIPE</data:p>
+ <data:p V="99341">SENEGAL</data:p>
+ <data:p V="99398">SEYCHELLES</data:p>
+ <data:p V="99342">SIERRA LEONE</data:p>
+ <data:p V="99318">SOMALIE</data:p>
+ <data:p V="99343">SOUDAN</data:p>
+ <data:p V="99307">SOUDAN ANGLO-EGYPTIEN, KENYA, OUGANDA</data:p>
+ <data:p V="99391">SWAZILAND</data:p>
+ <data:p V="99325">TANGER</data:p>
+ <data:p V="99309">TANZANIE</data:p>
+ <data:p V="99344">TCHAD</data:p>
+ <data:p V="99345">TOGO</data:p>
+ <data:p V="99351">TUNISIE</data:p>
+ <data:p V="99346">ZAMBIE</data:p>
+ <data:p V="99308">ZANZIBAR</data:p>
+ <data:p V="99310">ZIMBABWE</data:p>
+ <data:p V="99404">ALASKA</data:p>
+ <data:p V="99425">ANGUILLA</data:p>
+ <data:p V="99441">ANTIGUA-ET-BARBUDA</data:p>
+ <data:p V="99431">ANTILLES NEERLANDAISES</data:p>
+ <data:p V="99415">ARGENTINE</data:p>
+ <data:p V="99431">ARUBA</data:p>
+ <data:p V="99436">BAHAMAS</data:p>
+ <data:p V="99434">BARBADE</data:p>
+ <data:p V="99429">BELIZE</data:p>
+ <data:p V="99425">BERMUDES</data:p>
+ <data:p V="99418">BOLIVIE</data:p>
+ <data:p V="99416">BRESIL</data:p>
+ <data:p V="99425">CAIMAN (ILES)</data:p>
+ <data:p V="99401">CANADA</data:p>
+ <data:p V="99417">CHILI</data:p>
+ <data:p V="99419">COLOMBIE</data:p>
+ <data:p V="99406">COSTA RICA</data:p>
+ <data:p V="99407">CUBA</data:p>
+ <data:p V="99408">DOMINICAINE (REPUBLIQUE)</data:p>
+ <data:p V="99438">DOMINIQUE</data:p>
+ <data:p V="99414">EL SALVADOR</data:p>
+ <data:p V="99420">EQUATEUR</data:p>
+ <data:p V="99404">ETATS-UNIS</data:p>
+ <data:p V="99427">GEORGIE DU SUD ET LES ILES SANDWICH DU SUD</data:p>
+ <data:p V="99435">GRENADE</data:p>
+ <data:p V="99430">GROENLAND</data:p>
+ <data:p V="99409">GUATEMALA</data:p>
+ <data:p V="99428">GUYANA</data:p>
+ <data:p V="99410">HAITI</data:p>
+ <data:p V="99411">HONDURAS</data:p>
+ <data:p V="99426">JAMAIQUE</data:p>
+ <data:p V="99403">LABRADOR</data:p>
+ <data:p V="99427">MALOUINES, OU FALKLAND (ILES)</data:p>
+ <data:p V="99405">MEXIQUE</data:p>
+ <data:p V="99425">MONTSERRAT</data:p>
+ <data:p V="99412">NICARAGUA</data:p>
+ <data:p V="99413">PANAMA</data:p>
+ <data:p V="99421">PARAGUAY</data:p>
+ <data:p V="99422">PEROU</data:p>
+ <data:p V="99432">PORTO RICO</data:p>
+ <data:p V="99442">SAINT-CHRISTOPHE-ET-NIEVES</data:p>
+ <data:p V="99439">SAINTE-LUCIE</data:p>
+ <data:p V="99440">SAINT-VINCENT-ET-LES GRENADINES</data:p>
+ <data:p V="99437">SURINAME</data:p>
+ <data:p V="99432">TERR. DES ETATS-UNIS D'AMERIQUE EN AMERIQUE</data:p>
+ <data:p V="99427">TERR. DU ROYAUME-UNI DANS L'ATLANTIQUE SUD</data:p>
+ <data:p V="99402">TERRE-NEUVE</data:p>
+ <data:p V="99431">TERRITOIRE DES PAYS-BAS</data:p>
+ <data:p V="99425">TERRITOIRES DU ROYAUME-UNI AUX ANTILLES</data:p>
+ <data:p V="99433">TRINITE-ET-TOBAGO</data:p>
+ <data:p V="99425">TURKS ET CAIQUES (ILES)</data:p>
+ <data:p V="99423">URUGUAY</data:p>
+ <data:p V="99424">VENEZUELA</data:p>
+ <data:p V="99425">VIERGES BRITANNIQUES (ILES)</data:p>
+ <data:p V="99432">VIERGES DES ETATS-UNIS (ILES)</data:p>
+ <data:p V="99501">AUSTRALIE</data:p>
+ <data:p V="99501">CHRISTMAS (ILE)</data:p>
+ <data:p V="99501">COCOS ou KEELING (ILES)</data:p>
+ <data:p V="99502">COOK (ILES)</data:p>
+ <data:p V="99508">FIDJI</data:p>
+ <data:p V="99505">GUAM</data:p>
+ <data:p V="99504">HAWAII (ILES)</data:p>
+ <data:p V="99501">HEARD ET MACDONALD (ILES)</data:p>
+ <data:p V="99513">KIRIBATI</data:p>
+ <data:p V="99505">MARIANNES DU NORD (ILES)</data:p>
+ <data:p V="99515">MARSHALL (ILES)</data:p>
+ <data:p V="99516">MICRONESIE (ETATS FEDERES DE)</data:p>
+ <data:p V="99507">NAURU</data:p>
+ <data:p V="99502">NIUE</data:p>
+ <data:p V="99501">NORFOLK (ILE)</data:p>
+ <data:p V="99502">NOUVELLE-ZELANDE</data:p>
+ <data:p V="99517">PALAOS (ILES)</data:p>
+ <data:p V="99510">PAPOUASIE-NOUVELLE-GUINEE</data:p>
+ <data:p V="99503">PITCAIRN (ILE)</data:p>
+ <data:p V="99512">SALOMON (ILES)</data:p>
+ <data:p V="99505">SAMOA AMERICAINES</data:p>
+ <data:p V="99506">SAMOA OCCIDENTALES</data:p>
+ <data:p V="99505">TERR. DES ETATS-UNIS D'AMERIQUE EN OCEANIE</data:p>
+ <data:p V="99502">TOKELAU</data:p>
+ <data:p V="99509">TONGA</data:p>
+ <data:p V="99511">TUVALU</data:p>
+ <data:p V="99514">VANUATU</data:p>
+ </data:codePaysINSEE>
+ </data:data>
+ </xsl:variable>
+
+ <!-- Correspondance entre le code de pays INSEE et son nom -->
+ <xsl:template name="codePaysINSEE" xmlns:data="data.uri">
+ <xsl:param name="codePays"/>
+ <xsl:value-of select="$data/data:data/data:codePaysINSEE/data:p[@V=$codePays]/text()"/>
+ </xsl:template>
+
+ <xsl:template name="slash-date">
+ <xsl:param name="datebrute"/>
+ <date xmlns:data="data.uri" xsl:exclude-result-prefixes="data">
+ <xsl:value-of select="substring($datebrute, 9, 2)"/>
+ <xsl:text>/</xsl:text>
+ <xsl:value-of select="substring($datebrute, 6, 2)"/>
+ <xsl:text>/</xsl:text>
+ <xsl:value-of select="substring($datebrute, 1, 4)"/>
+ </date>
+ </xsl:template>
+ <xsl:template name="number">
+ <xsl:param name="num"/>
+ <xsl:choose>
+ <xsl:when test="string-length(string($num)) = 0"/>
+ <xsl:when test="number($num) = 0">0,00</xsl:when>
+ <xsl:when test="string(number($num)) = 'NaN'"/>
+ <xsl:otherwise>
+ <xsl:value-of select="format-number($num,'# ###,00;-# ###,00','decformat')"/>
+ </xsl:otherwise>
+ </xsl:choose>
+ </xsl:template>
+
+ <xsl:template name="FAC_CadreFournisseur">
+ <xsl:param name="fournisseur"/>
+ <table class="fournisseur">
+ <tr>
+ <td class="fournisseurcolonne1">Fournisseur : </td>
+ <td class="fournisseurcolonne2"><xsl:value-of select="$fournisseur/n:InfoTiers/n:Nom/@V"/></td>
+ </tr>
+ <tr>
+ <td class="fournisseurcolonne1">Adresse : </td>
+ <td class="fournisseurcolonne2">
+ <xsl:if test="string-length($fournisseur/n:Adresse/n:Adr1/@V) > 0">
+ <xsl:value-of select="$fournisseur/n:Adresse/n:Adr1/@V"/>
+ </xsl:if>
+ <xsl:if test="string-length($fournisseur/n:Adresse/n:Adr2/@V) > 0">
+ <xsl:value-of select="$fournisseur/n:Adresse/n:Adr2/@V"/>
+ </xsl:if>
+ <xsl:if test="string-length($fournisseur/n:Adresse/n:Adr3/@V) > 0">
+ <xsl:value-of select="$fournisseur/n:Adresse/n:Adr3/@V"/>
+ </xsl:if>
+ <br/>
+ <xsl:value-of select="$fournisseur/n:Adresse/n:CP/@V"/>
+ <xsl:value-of select="$fournisseur/n:Adresse/n:Ville/@V"/>
+ <xsl:call-template name="codePaysINSEE">
+ <xsl:with-param name="codePays" select="$fournisseur/n:Adresse/n:CodPays/@V"/>
+ </xsl:call-template>
+ </td>
+ </tr>
+ <tr>
+ <td class="fournisseurcolonne1">SIRET : </td>
+ <td class="fournisseurcolonne2">XXX XXX XXX XXXXX</td>
+ </tr>
+ </table>
+ </xsl:template>
+
+ <xsl:template name="FAC_CadreFacture">
+ <xsl:param name="facture"/>
+ <table class="facture" cellpadding="0" cellspacing="0">
+ <tr>
+ <td class="facturecolonneTitre1" colspan="3" align="left"><b>Titulaire : <xsl:value-of select="$facture/n:Tiers[n:TypeTiersFacture/@V=11]/n:InfoTiers/n:Civilite/@V"/> <xsl:value-of select="$facture/n:Tiers[n:TypeTiersFacture/@V=11]/n:InfoTiers/n:Prenom/@V"/> <xsl:value-of select="$facture/n:Tiers[n:TypeTiersFacture/@V=11]/n:InfoTiers/n:Nom/@V"/></b></td>
+ <td class="facturecolonneTitre2" colspan="6" align="right"><b>Carte N° : <xsl:value-of select="$facture/n:Tiers[n:TypeTiersFacture/@V=11]/n:InfoTiers/n:IdTiers/@V"/></b></td>
+ </tr>
+ <tr>
+ <td class="facturecolonne1" style="border-bottom: solid 1px #000000;" align="center">Date</td>
+ <td class="facturecolonne2" style="border-bottom: solid 1px #000000;" align="center"> </td>
+ <td class="facturecolonne3" style="border-bottom: solid 1px #000000;" align="center">Désignation</td>
+ <td class="facturecolonne4" style="border-bottom: solid 1px #000000;" align="center">Qté.</td>
+ <td class="facturecolonne5" style="border-bottom: solid 1px #000000;" align="center">Prix<br/>unitaire HT</td>
+ <td class="facturecolonne6" style="border-bottom: solid 1px #000000;" align="center">Taux<br/>TVA</td>
+ <td class="facturecolonne7" style="border-bottom: solid 1px #000000;" align="center">Montant<br/>TVA</td>
+ <td class="facturecolonne8" style="border-bottom: solid 1px #000000;" align="center">TVA</td>
+ <td class="facturecolonne9" style="border-bottom: solid 1px #000000;" align="center">Montant<br/>TTC</td>
+ </tr>
+ <tr>
+ <td class="facturecolonne1"><xsl:value-of select="$facture/n:DateEmission/@V"/></td>
+ <td class="facturecolonne2" colspan="2">Marché n° <b><xsl:value-of select="$facture/n:NumeroMarche/@V"/></b></td>
+ <td class="facturecolonne4"> </td>
+ <td class="facturecolonne5"> </td>
+ <td class="facturecolonne6"> </td>
+ <td class="facturecolonne7"> </td>
+ <td class="facturecolonne8"> </td>
+ <td class="facturecolonne9"> </td>
+ </tr>
+ <tr>
+ <td class="facturecolonne1"> </td>
+ <td class="facturecolonne2" colspan="2">Facture n° <b><xsl:value-of select="$facture/n:NumeroFacture/@V"/></b>
+ Cde n° <b><xsl:value-of select="$facture/n:Reference[n:TypePiece/@V='COMMANDE']/n:NumeroPiece/@V"/></b>
+ </td>
+ <td class="facturecolonne4"> </td>
+ <td class="facturecolonne5"> </td>
+ <td class="facturecolonne6"> </td>
+ <td class="facturecolonne7"> </td>
+ <td class="facturecolonne8"> </td>
+ <td class="facturecolonne9"> </td>
+ </tr>
+ <tr>
+ <td class="facturecolonne1"> </td>
+ <td class="facturecolonne2" colspan="2"> </td>
+ <td class="facturecolonne4"> </td>
+ <td class="facturecolonne5"> </td>
+ <td class="facturecolonne6"> </td>
+ <td class="facturecolonne7"> </td>
+ <td class="facturecolonne8"> </td>
+ <td class="facturecolonne9"> </td>
+ </tr>
+ <!-- LIGNES DE FACTURE DE CETTE FACTURE -->
+ <xsl:for-each select="$facture/n:LigneFacture">
+ <tr>
+ <td class="facturecolonne1"> </td>
+ <td class="facturecolonne2"><xsl:value-of select="./n:CodeProduit/@V"/></td>
+ <td class="facturecolonne3"><xsl:value-of select="./n:Libelle/@V"/></td>
+ <td class="facturecolonne4" align="right"><xsl:value-of select="./n:Quantite/@V"/></td>
+ <td class="facturecolonne5" align="right"><xsl:value-of select="format-number(./n:MtUnitaire/@V,'# ##0,00','decformat')"/></td>
+ <td class="facturecolonne6" align="right"><xsl:value-of select="format-number(./n:TauxTVA/@V,'# ##0,00','decformat')"/></td>
+ <td class="facturecolonne7" align="right"><xsl:value-of select="format-number(./n:MtHT/@V,'# ##0,00','decformat')"/></td>
+ <td class="facturecolonne8" align="right"><xsl:value-of select="format-number(./n:MtTVA/@V,'# ##0,00','decformat')"/></td>
+ <td class="facturecolonne9" align="right"><xsl:value-of select="format-number(./n:MtTTC/@V,'# ##0,00','decformat')"/></td>
+ </tr>
+ </xsl:for-each>
+ <!-- REFERENCES DIVERS -->
+ <tr>
+ <td class="facturecolonne1"> </td>
+ <td class="facturecolonne2" colspan="2"> </td>
+ <td class="facturecolonne4"> </td>
+ <td class="facturecolonne5"> </td>
+ <td class="facturecolonne6"> </td>
+ <td class="facturecolonne7"> </td>
+ <td class="facturecolonne8"> </td>
+ <td class="facturecolonne9"> </td>
+ </tr>
+ <tr>
+ <td class="facturecolonne1"> </td>
+ <td class="facturecolonne2" colspan="2">REFERENCE DE PAIEMENT BANQUE</td>
+ <td class="facturecolonne4"> </td>
+ <td class="facturecolonne5"> </td>
+ <td class="facturecolonne6"> </td>
+ <td class="facturecolonne7"> </td>
+ <td class="facturecolonne8"> </td>
+ <td class="facturecolonne9"> </td>
+ </tr>
+ <tr>
+ <td class="facturecolonne1"> </td>
+ <td class="facturecolonne2" colspan="2">IDENTIFIANT LONG : XXX XXX</td>
+ <td class="facturecolonne4"> </td>
+ <td class="facturecolonne5"> </td>
+ <td class="facturecolonne6"> </td>
+ <td class="facturecolonne7"> </td>
+ <td class="facturecolonne8"> </td>
+ <td class="facturecolonne9"> </td>
+ </tr>
+ <tr>
+ <td class="facturecolonne1"> </td>
+ <td class="facturecolonne2" colspan="2">IDENTIFIANT COURT : XXX</td>
+ <td class="facturecolonne4"> </td>
+ <td class="facturecolonne5"> </td>
+ <td class="facturecolonne6"> </td>
+ <td class="facturecolonne7"> </td>
+ <td class="facturecolonne8"> </td>
+ <td class="facturecolonne9"> </td>
+ </tr>
+ </table>
+ <!-- TOTAUX -->
+ <xsl:variable name="lignes_5_5" select="./n:LigneFacture[n:TauxTVA/@V='5.5']"/>
+ <xsl:variable name="lignes_19_6" select="./n:LigneFacture[n:TauxTVA/@V='19.6']"/>
+ <xsl:if test="$lignes_5_5!='' or $lignes_19_6!=''">
+ <div class="total">
+ <table style="text-align: left;" class="tableau3">
+ <tbody>
+ <tr>
+ <td class="cell_titre_col" colspan="2">Totaux T.V.A par Taux</td>
+ </tr>
+ <xsl:if test="$lignes_5_5!=''">
+ <tr>
+ <td class="cell_tableau1">5.5 %</td>
+ <td class="cell_numeric_g">
+ <xsl:apply-templates select="$lignes_5_5"/>
+ <xsl:value-of select="format-number(sum($lignes_5_5/n:MtTVA/@V),'# ##0,00','decformat')"/>
+ </td>
+ </tr>
+ </xsl:if>
+ <xsl:if test="$lignes_19_6!=''">
+ <tr>
+ <td class="cell_tableau1">19.6 %</td>
+ <td class="cell_numeric_g">
+ <xsl:apply-templates select="$lignes_19_6"/>
+ <xsl:value-of select="format-number(sum($lignes_19_6/n:MtTVA/@V),'# ##0,00','decformat')"/>
+ </td>
+ </tr>
+ </xsl:if>
+ </tbody>
+ </table>
+ </div>
+ </xsl:if>
+
+ <div class="total">
+ <table style="text-align: left;" class="tableau3">
+ <tbody>
+ <tr>
+ <td class="cell_titre_col" colspan="2">Total</td>
+ </tr>
+ <tr>
+ <td class="cell_tableau1">Montant HT</td>
+ <td class="cell_numeric_g"><xsl:value-of select="format-number(./n:TotalAPayer/n:MtTotalHT/@V,'# ##0,00','decformat')"/></td>
+ </tr>
+ <tr>
+ <td class="cell_tableau1">Montant TVA</td>
+ <td class="cell_numeric_g"><xsl:value-of select="format-number(./n:TotalAPayer/n:MtTotalTVA/@V,'# ##0,00','decformat')"/></td>
+ </tr>
+ <tr>
+ <td class="cell_tableau1">Montant TTC</td>
+ <td class="cell_numeric_g"><xsl:value-of select="format-number(./n:TotalAPayer/n:MtTotalTTC/@V,'# ##0,00','decformat')"/></td>
+ </tr>
+ </tbody>
+ </table>
+ </div>
+
+ </xsl:template>
+
+ <!-- début du document -->
+ <xsl:template match="/n:DOC_PES_Facture">
+ <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
+ <head>
+ <style type="text/css">
+ @page {
+ size: 29.7cm 21cm;
+ margins: 0.5 0.5 0.5 0.5;
+ }
+ body {
+ width: 29cm;
+ font-family: verdana, sans-serif;
+ font-size: 10px;
+ background-color: #FFFFFF;
+ }
+ div.divpage {
+ width: 29cm;
+ margin: 0 0 0 0;
+ }
+ table.entete {
+ margin: 0;
+ border-style: none;
+ border-width: 0px;
+ border-color: black;
+ width: 100%;
+ font-size: 14px;
+ }
+ anomalie { background-color: #FFFF66; }
+ tr { margin: 0; }
+ td {
+ margin: 0;
+ border-style: inset;
+ border-width: 1px;
+ border-color: black;
+ vertical-align: top;
+ line-height: 13px;
+ }
+ td.entetecolonne1 {
+ width: 1.5cm;
+ border-style: none;
+ }
+ td.entetecolonne2 {
+ width: 1.5cm;
+ border-style: none;
+ }
+ td.entetecolonne3 {
+ width: 4cm;
+ border-style: none;
+ }
+ td.entetecolonne4 {
+ width: 1cm;
+ border-style: none;
+ }
+ td.entetecolonne5 {
+ width: 3.5cm;
+ border-style: none;
+ }
+ td.entetecolonne6 {
+ width: 7.5cm;
+ border-style: none;
+ }
+
+ table.fournisseur {
+ margin: 0;
+ border-style: solid;;
+ border-width: 1px;
+ border-color: black;
+ width: 8.5cm;
+ font-size: 12px;
+ align: left;
+ }
+ td.fournisseurcolonne1 {
+ width: 3cm;
+ border-style: none;
+ text-align: right;
+ }
+ td.fournisseurcolonne2 {
+ width: 5.5cm;
+ border-style: none;
+ text-align: left;
+ }
+
+ table.facture {
+ margin: 0;
+ border-style: solid;
+ border-width: 1px;
+ border-color: #000000;
+ width: 100%;
+ font-size: 12px;
+ align: left;
+ }
+ td.facturecolonneTitre1 {
+ width: 1cm;
+ border-top: none;
+ border-left: none;
+ border-bottom: solid 1px #000000;
+ border-right: none;
+ }
+ td.facturecolonneTitre2 {
+ width: 1cm;
+ border-top: none;
+ border-left: solid 1px #000000;
+ border-bottom: solid 1px #000000;
+ border-right: none;
+ }
+ td.facturecolonne1 {
+ width: 1cm;
+ border-top: none;
+ border-left: none;
+ border-bottom: none;
+ border-right: none;
+ }
+ td.facturecolonne2 {
+ width: 1.5cm;
+ border-top: none;
+ border-left: solid 1px #000000;
+ border-bottom: none;
+ border-right: none;
+ }
+ td.facturecolonne3 {
+ width: 9.75cm;
+ border-top: none;
+ border-left: none;
+ border-bottom: none;
+ border-right: none;
+ }
+ td.facturecolonne4 {
+ width: 1cm;
+ border-top: none;
+ border-left: solid 1px #000000;
+ border-bottom: none;
+ border-right: none;
+ }
+ td.facturecolonne5 {
+ width: 1.25cm;
+ border-top: none;
+ border-left: solid 1px #000000;
+ border-bottom: none;
+ border-right: none;
+ }
+ td.facturecolonne6 {
+ width: 1.25cm;
+ border-top: none;
+ border-left: solid 1px #000000;
+ border-bottom: none;
+ border-right: none;
+ }
+ td.facturecolonne7 {
+ width: 1.25cm;
+ border-top: none;
+ border-left: solid 1px #000000;
+ border-bottom: none;
+ border-right: none;
+ }
+ td.facturecolonne8 {
+ width: 1.25cm;
+ border-top: none;
+ border-left: solid 1px #000000;
+ border-bottom: none;
+ border-right: solid 1px #000000;
+ }
+ td.facturecolonne9 {
+ width: 1.25cm;
+ border-style: none;
+ }
+
+ .bordHaut { border-top: solid 1px #000000; }
+ .bordGauche { border-left: solid 1px #000000; }
+ .bordBas { border-bottom: solid 1px #000000; }
+ .bordDroit { border-right: solid 1px #000000; }
+
+ noupper { border-top-style: none; }
+ :link { color: #00c; background: transparent }
+ :visited { color: #609; background: transparent }
+ a:active { color: #c00; background: transparent }
+ a:link img, a:visited img { border-style: none }
+ .gras { font-weight: bold; }
+ .gauche { text-align: left; }
+ .droite { text-align: right; }
+ .nomBanque {border: solid 1px #000000; text-align: center; font-size: 12px; font-weight: bold;}
+
+ .total {
+ position: relative;
+ left: 23cm;
+ width: 6cm;
+ }
+
+ .tableau3 { border-style: none;
+ border-width: 0px;
+ font-size: 12px;
+ font-family: Verdana;
+ font-style: normal;
+ }
+ .cell_titre_col {border-top-style: solid;
+ border-bottom-style: solid;
+ border-top-width: 1px;
+ border-bottom-width: 1px;
+ font-weight: bold;
+ text-align: center;
+ background-color: rgb(202, 202, 202);
+
+ }
+ .cell_numeric_g {border-top-style: solid;
+ border-bottom-style: solid;
+ border-top-width: 1px;
+ border-bottom-width: 1px;
+ text-align: right;
+ font-weight: bold;
+ width: 3.5cm;
+ }
+
+ .cell_tableau1 {
+ border-top-style: solid;
+ border-bottom-style: solid;
+ border-top-width: 1px;
+ border-bottom-width: 1px;
+ width: 2.5cm;
+ }
+
+ </style>
+ </head>
+ <body>
+ <div class="divpage">
+
+ <!-- pour une facture -->
+ <xsl:for-each select="./n:PESFacture/n:FactureIndiv[n:NumeroFacture/@V = $numeroFacture]">
+ <!-- FOURNISSEUR -->
+ <xsl:call-template name="FAC_CadreFournisseur">
+ <xsl:with-param name="fournisseur" select="./n:Tiers[n:TypeTiersFacture/@V=24]"/>
+ </xsl:call-template>
+ <br/>
+ <!-- FACTURE -->
+ <xsl:call-template name="FAC_CadreFacture">
+ <xsl:with-param name="facture" select="."/>
+ </xsl:call-template>
+ </xsl:for-each>
+
+ </div>
+ </body>
+
+ </html>
+ </xsl:template>
+
+</xsl:stylesheet>
--- /dev/null
+<?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-facture" repository-import-xslt-file="">
+ <table type="repository" base-name="PES_FACTURE_REPOSITORY" version="2">
+ CREATE TABLE IF NOT EXISTS ${base-name} (
+ ID VARCHAR(25),
+ LIBELLE VARCHAR(100),
+ COLLECTIVITE VARCHAR(15) NOT NULL,
+ REPOSITORY LONGBLOB,
+ ENCODING VARCHAR(20)
+ ) ENGINE MYISAM
+ <patch from-version="1">
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD ID VARCHAR(25)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD LIBELLE VARCHAR(100)</sql>
+ </patch>
+ </table>
+ <table type="special-key" base-name="PES_FACTURE_SPECIAL_KEYS" version="1"> CREATE TABLE
+ IF NOT EXISTS ${base-name} ( COLLECTIVITE VARCHAR(30) NOT NULL, BUDGET VARCHAR(24)
+ NOT NULL, INITIAL_DOC_NAME VARCHAR(100) NOT NULL, KEY1 VARCHAR(100), LIB1
+ VARCHAR(200), KEY2 VARCHAR(100), LIB2 VARCHAR(200), KEY3 VARCHAR(100), LIB3
+ VARCHAR(200), KEY4 VARCHAR(100), LIB4 VARCHAR(200), KEY5 VARCHAR(100), LIB5
+ VARCHAR(200), KEY6 VARCHAR(100), LIB6 VARCHAR(200), KEY7 VARCHAR(100), LIB7
+ VARCHAR(200), KEY8 VARCHAR(100), LIB8 VARCHAR(200), KEY9 VARCHAR(100), LIB9
+ VARCHAR(200), KEY10 VARCHAR(100), LIB10 VARCHAR(200), INDEX IX_${base-name}_BC
+ (COLLECTIVITE,BUDGET),
+ ARCHIVE_NAME VARCHAR(100),
+ INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM </table>
+ <table type="list-bc" base-name="PES_FACTURE_LIST_BUDG_COLL" version="1"> CREATE TABLE
+ IF NOT EXISTS ${base-name} ( COLLECTIVITE VARCHAR(30) NOT NULL, BUDGET VARCHAR(24)
+ NOT NULL, BUDGET_LIB VARCHAR(200), COLLECTIVITE_LIB VARCHAR(200), INITIAL_DOC_NAME
+ VARCHAR(100) NOT NULL, INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET),
+ ARCHIVE_NAME VARCHAR(100),
+ INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM </table>
+
+ <etat id="PESFacture" import-xslt-file="PES_Facture/PES-Facture-import-mysql.xsl">
+ <key1>
+ <path>/n:DOC_PES_Facture/n:PESFacture/@added:generated-id</path>
+ </key1>
+ <key2>
+ <path>/n:DOC_PES_Facture/n:PESFacture/n:Tiers/@added:generated-id</path>
+ </key2>
+ <key3>
+ <path>/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/@added:generated-id</path>
+ </key3>
+ <key4>
+ <path>/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Reference/@added:generated-id</path>
+ </key4>
+ <key5>
+ <path>/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/@added:generated-id</path>
+ </key5>
+ <key6>
+ <path>/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/@added:generated-id</path>
+ </key6>
+ <key7>
+ <path>/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/@added:generated-id</path>
+ </key7>
+ <key8>
+ <path>/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:reference/@added:generated-id</path>
+ </key8>
+ <key9>
+ <path>/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:DetailTVA/@added:generated-id</path>
+ </key9>
+
+ <table type="document" base-name="PES_FACTURE_DOCUMENTS" version="1"> CREATE TABLE
+ IF NOT EXISTS ${base-name} ( COLLECTIVITE VARCHAR(30) NOT NULL, BUDGET
+ VARCHAR(24) NOT NULL, INITIAL_DOC_NAME VARCHAR(100) NOT NULL, DOC_ID
+ VARCHAR(100) NOT NULL, DOC LONGBLOB, ENCODING VARCHAR(20), INDEX
+ IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
+ ARCHIVE_NAME VARCHAR(100),
+ INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM </table>
+ <table type="index" id="PES_FACTURE_PESFACTURE_IX"
+ base-name="PES_FACTURE_PESFACTURE_IX" version="1" main="true" based-on="key1">
+ CREATE TABLE IF NOT EXISTS ${base-name} (
+ COLLECTIVITE VARCHAR(30) NOT NULL,
+ BUDGET VARCHAR(24) NOT NULL,
+ DOC_ID VARCHAR(100) NOT NULL,
+ PRIMARY_KEY VARCHAR(100) NOT NULL,
+ NODE_ID VARCHAR(50) NOT NULL,
+ TYPEFACT VARCHAR(255) ,
+ CODPAYS INTEGER ,
+ SERVICE VARCHAR(24) ,
+ COMPLNOM VARCHAR(38) ,
+ DEVISE VARCHAR(3),
+ IDBANCINT VARCHAR(11) ,
+ NUMSEQUENCE INTEGER ,
+ DTEIDTIERS DATE ,
+ TITCPTE VARCHAR(32) ,
+ CP VARCHAR(5) ,
+ DESCRIPTION VARCHAR(100) ,
+ REFTIERS VARCHAR(30) ,
+ DTEBANC DATE ,
+ ADR3 VARCHAR(38) ,
+ ADR2 VARCHAR(38) ,
+ CATTIERS VARCHAR(255) ,
+ NATJUR VARCHAR(255) ,
+ ADR1 VARCHAR(38) ,
+ NATIDTIERS VARCHAR(255) ,
+ DTEADR DATE ,
+ PRENOM VARCHAR(38) ,
+ LIBBANC VARCHAR(24) ,
+ NUMTVA VARCHAR(24) ,
+ CODRES VARCHAR(255) ,
+ NOM VARCHAR(38) ,
+ ANNEE VARCHAR(255) ,
+ CLERIB INTEGER ,
+ TYPTIERS VARCHAR(255) ,
+ CODEETAB VARCHAR(5) ,
+ VILLE VARCHAR(38) ,
+ DATE DATE ,
+ CODEGUIC VARCHAR(5) ,
+ IDPAYINT VARCHAR(4) ,
+ IDTIERS VARCHAR(30) ,
+ TYPETIERSFACTURE VARCHAR(255) ,
+ TYPADR VARCHAR(255) ,
+ DTEMALADE DATE ,
+ CIVILITE VARCHAR(10) ,
+ IDCPTE VARCHAR(11) ,
+ IDVER DECIMAL ,
+ MONTANT_HT DECIMAL(14,2),
+ MONTANT_TVA DECIMAL(14,2),
+ MONTANT_TTC DECIMAL(14,2),
+ INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
+ INDEX IX_${base-name}_DC (DOC_ID) ,
+ INITIAL_DOC_NAME VARCHAR(100),
+ INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
+ ARCHIVE_NAME VARCHAR(100),
+ INDEX ${base-name}_AN (ARCHIVE_NAME)
+ ) ENGINE MYISAM </table>
+ <table type="index" id="PES_FACTURE_PESFACTURE_TIERS_IX"
+ base-name="PES_FACTURE_PESFACTURE_TIERS_IX" version="1" main="false"
+ based-on="key2"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE
+ VARCHAR(30) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL,
+ NODE_ID VARCHAR(50) NOT NULL, DTEBANC DATE , VILLE VARCHAR(38) , TYPADR
+ VARCHAR(255) , CP VARCHAR(5) , CATTIERS VARCHAR(255) , TYPETIERSFACTURE
+ VARCHAR(255) , NUMTVA VARCHAR(24) , IDTIERS VARCHAR(30) , CODRES VARCHAR(255) ,
+ CLERIB INTEGER , CODEGUIC VARCHAR(5) , CODPAYS INTEGER , PRENOM VARCHAR(38) ,
+ IDPAYINT VARCHAR(4) , SERVICE VARCHAR(24) , IDBANCINT VARCHAR(11) , TYPTIERS
+ VARCHAR(255) , REFTIERS VARCHAR(30) , NOM VARCHAR(38) , CODEETAB VARCHAR(5) ,
+ ADR3 VARCHAR(38) , NATIDTIERS VARCHAR(255) , IDCPTE VARCHAR(11) , ADR2
+ VARCHAR(38) , TITCPTE VARCHAR(32) , LIBBANC VARCHAR(24) , ADR1 VARCHAR(38) ,
+ DTEIDTIERS DATE , NATJUR VARCHAR(255) , DTEADR DATE , DTEMALADE DATE , CIVILITE
+ VARCHAR(10) , COMPLNOM VARCHAR(38) , INDEX IX_${base-name}_BC
+ (COLLECTIVITE,BUDGET,DOC_ID), INDEX IX_${base-name}_DC (DOC_ID),
+ INITIAL_DOC_NAME VARCHAR(100),
+ INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
+ ARCHIVE_NAME VARCHAR(100),
+ INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM </table>
+ <table type="index" id="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"
+ base-name="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX" version="3" main="false"
+ based-on="key3"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE
+ VARCHAR(30) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL,
+ NODE_ID VARCHAR(50) NOT NULL, TYPEFACT VARCHAR(255) , CODPAYS INTEGER , SERVICE
+ VARCHAR(24) , COMPLNOM VARCHAR(38) , MTTOTALTTC DECIMAL(14,2), IDBANCINT
+ VARCHAR(11) , OBJET VARCHAR(160) , DATEEMISSION DATE , TEXTEGENERATEUR
+ VARCHAR(160) , DTEIDTIERS DATE , TITCPTE VARCHAR(32) , CP VARCHAR(5) , REFTIERS
+ VARCHAR(30) , DTEBANC DATE , ADR3 VARCHAR(38) , ADR2 VARCHAR(38) , CATTIERS
+ VARCHAR(255) , NATJUR VARCHAR(255) , ADR1 VARCHAR(38) , NATIDTIERS VARCHAR(255)
+ , MTTOTALTVA DECIMAL(14,2), DTEADR DATE , MOYENPAIEMENT VARCHAR(255) ,
+ NUMEROCONTRAT VARCHAR(50) , PRENOM VARCHAR(38) , LIBBANC VARCHAR(24) ,
+ NUMEROFACTURE VARCHAR(50) , NUMEROMARCHE VARCHAR(50) , NUMTVA VARCHAR(24) ,
+ MTTOTALHT DECIMAL(14,2), CODRES VARCHAR(255) , NOM VARCHAR(38) ,
+ MODALITESREGLEMENT VARCHAR(250) , CLERIB INTEGER , TYPTIERS VARCHAR(255) ,
+ CODEETAB VARCHAR(5) , DATEREGLEMENT DATE , CONDITIONSGEN VARCHAR(250) , VILLE
+ VARCHAR(38) , CODEGUIC VARCHAR(5) , IDPAYINT VARCHAR(4) , IDTIERS VARCHAR(30) ,
+ TYPETIERSFACTURE VARCHAR(255) , TYPADR VARCHAR(255) , DTEMALADE DATE ,
+ TAUXREMISE DECIMAL(6,3), CIVILITE VARCHAR(10) , IDCPTE VARCHAR(11) , MTREMISE
+ DECIMAL(14,2), FOURNISSEUR VARCHAR(38), NUMERO_CARTEACHAT VARCHAR(30),
+ NUMERO_COMMANDE VARCHAR(50), MOIS_DATE_EMISSION VARCHAR(2), ANNEE_DATE_EMISSION
+ VARCHAR(4), ID_LOGEMENT VARCHAR(30), INDEX IX_${base-name}_BC
+ (COLLECTIVITE,BUDGET,DOC_ID), INDEX IX_${base-name}_DC (DOC_ID),
+ INITIAL_DOC_NAME VARCHAR(100),
+ INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
+ ARCHIVE_NAME VARCHAR(100),
+ INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM
+ <patch from-version="1">
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD ANNEE_DATE_EMISSION VARCHAR(4)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD ID_LOGEMENT VARCHAR(30)</sql>
+ </patch>
+ <patch from-version="2">
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD ID_LOGEMENT VARCHAR(30)</sql>
+ </patch>
+
+ </table>
+ <table type="index" id="PES_FACTURE_FACTUREINDIV_REFERENCE_IX"
+ base-name="PES_FACTURE_FACTUREINDIV_REFERENCE_IX" version="1" main="false"
+ based-on="key4"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE
+ VARCHAR(30) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL,
+ NODE_ID VARCHAR(50) NOT NULL, NUMEROPIECE VARCHAR(50) , TYPEPIECE VARCHAR(255) ,
+ NUMLIGNE INTEGER , INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), INDEX
+ IX_${base-name}_DC (DOC_ID),
+ INITIAL_DOC_NAME VARCHAR(100),
+ INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
+ ARCHIVE_NAME VARCHAR(100),
+ INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM </table>
+ <table type="index" id="PES_FACTURE_FACTUREINDIV_TIERS_IX"
+ base-name="PES_FACTURE_FACTUREINDIV_TIERS_IX" version="1" main="false"
+ based-on="key5"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE
+ VARCHAR(30) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL,
+ NODE_ID VARCHAR(50) NOT NULL, DTEBANC DATE , VILLE VARCHAR(38) , TYPADR
+ VARCHAR(255) , CP VARCHAR(5) , CATTIERS VARCHAR(255) , TYPETIERSFACTURE
+ VARCHAR(255) , NUMTVA VARCHAR(24) , IDTIERS VARCHAR(30) , CODRES VARCHAR(255) ,
+ CLERIB INTEGER , CODEGUIC VARCHAR(5) , CODPAYS INTEGER , PRENOM VARCHAR(38) ,
+ IDPAYINT VARCHAR(4) , SERVICE VARCHAR(24) , IDBANCINT VARCHAR(11) , TYPTIERS
+ VARCHAR(255) , REFTIERS VARCHAR(30) , NOM VARCHAR(38) , CODEETAB VARCHAR(5) ,
+ ADR3 VARCHAR(38) , NATIDTIERS VARCHAR(255) , IDCPTE VARCHAR(11) , ADR2
+ VARCHAR(38) , TITCPTE VARCHAR(32) , LIBBANC VARCHAR(24) , ADR1 VARCHAR(38) ,
+ DTEIDTIERS DATE , NATJUR VARCHAR(255) , DTEADR DATE , DTEMALADE DATE , CIVILITE
+ VARCHAR(10) , COMPLNOM VARCHAR(38) , INDEX IX_${base-name}_BC
+ (COLLECTIVITE,BUDGET,DOC_ID), INDEX IX_${base-name}_DC (DOC_ID),
+ INITIAL_DOC_NAME VARCHAR(100),
+ INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
+ ARCHIVE_NAME VARCHAR(100),
+ INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM </table>
+ <table type="index" id="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"
+ base-name="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX" version="1" main="false"
+ based-on="key6"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE
+ VARCHAR(30) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL,
+ NODE_ID VARCHAR(50) NOT NULL, ORDRE INTEGER , CODEFONCTION VARCHAR(24) , MTTTC
+ DECIMAL(14,2), TAUX DECIMAL(6,3), MTREMISE DECIMAL(14,2), MTHT DECIMAL(14,2),
+ TAUXTVA DECIMAL(5,2), MTTVA DECIMAL(14,2), ORDREEDITION INTEGER , CODEPRODUIT
+ VARCHAR(24) , TAUXREMISE DECIMAL(6,3), CODENATURE VARCHAR(24) , LIBELLE
+ VARCHAR(100) , UNITE VARCHAR(38), QUANTITE DECIMAL(14,2), MTUNITAIRE
+ DECIMAL(16,4), MTBASE DECIMAL(5,2), INDEX IX_${base-name}_BC
+ (COLLECTIVITE,BUDGET,DOC_ID), INDEX IX_${base-name}_DC (DOC_ID),
+ INITIAL_DOC_NAME VARCHAR(100),
+ INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
+ ARCHIVE_NAME VARCHAR(100),
+ INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM </table>
+ <table type="index" id="PES_FACTURE_LIGNEFACTURE_TIERS_IX"
+ base-name="PES_FACTURE_LIGNEFACTURE_TIERS_IX" version="1" main="false"
+ based-on="key7"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE
+ VARCHAR(30) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL,
+ NODE_ID VARCHAR(50) NOT NULL, DTEBANC DATE , VILLE VARCHAR(38) , TYPADR
+ VARCHAR(255) , CP VARCHAR(5) , CATTIERS VARCHAR(255) , TYPETIERSFACTURE
+ VARCHAR(255) , NUMTVA VARCHAR(24) , IDTIERS VARCHAR(30) , CODRES VARCHAR(255) ,
+ CLERIB INTEGER , CODEGUIC VARCHAR(5) , CODPAYS INTEGER , PRENOM VARCHAR(38) ,
+ IDPAYINT VARCHAR(4) , SERVICE VARCHAR(24) , IDBANCINT VARCHAR(11) , TYPTIERS
+ VARCHAR(255) , REFTIERS VARCHAR(30) , NOM VARCHAR(38) , CODEETAB VARCHAR(5) ,
+ ADR3 VARCHAR(38) , NATIDTIERS VARCHAR(255) , IDCPTE VARCHAR(11) , ADR2
+ VARCHAR(38) , TITCPTE VARCHAR(32) , LIBBANC VARCHAR(24) , ADR1 VARCHAR(38) ,
+ DTEIDTIERS DATE , NATJUR VARCHAR(255) , DTEADR DATE , DTEMALADE DATE , CIVILITE
+ VARCHAR(10) , COMPLNOM VARCHAR(38) , INDEX IX_${base-name}_BC
+ (COLLECTIVITE,BUDGET,DOC_ID), INDEX IX_${base-name}_DC (DOC_ID),
+ INITIAL_DOC_NAME VARCHAR(100),
+ INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
+ ARCHIVE_NAME VARCHAR(100),
+ INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM </table>
+ <table type="index" id="PES_FACTURE_LIGNEFACTURE_REFERENCE_IX"
+ base-name="PES_FACTURE_LIGNEFACTURE_REFERENCE_IX" version="1" main="false"
+ based-on="key8"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE
+ VARCHAR(30) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL,
+ NODE_ID VARCHAR(50) NOT NULL, NUMEROPIECE VARCHAR(50) , TYPEPIECE VARCHAR(255) ,
+ NUMLIGNE INTEGER , INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), INDEX
+ IX_${base-name}_DC (DOC_ID),
+ INITIAL_DOC_NAME VARCHAR(100),
+ INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
+ ARCHIVE_NAME VARCHAR(100),
+ INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM </table>
+ <table type="index" id="PES_FACTURE_FACTUREINDIV_DETAILTVA_IX"
+ base-name="PES_FACTURE_FACTUREINDIV_DETAILTVA_IX" version="1" main="false"
+ based-on="key9"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE
+ VARCHAR(30) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL,
+ NODE_ID VARCHAR(50) NOT NULL, TAUXTVA DECIMAL(5,2), MTTVA DECIMAL(14,2),
+ MTBASEHT DECIMAL(14,2), INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
+ INDEX IX_${base-name}_DC (DOC_ID),
+ INITIAL_DOC_NAME VARCHAR(100),
+ INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
+ ARCHIVE_NAME VARCHAR(100),
+ INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM </table>
+
+ <!-- CRITERIA PERSO -->
+ <criteria id="_CRI_PES_FACTURE_FOURNISSEUR"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_NOM">
+ <where-clause>(fn:string-compare(${table}.${column},fournisseur) AND
+ ${table}.TYPETIERSFACTURE='24')</where-clause>
+ </criteria>
+ <criteria id="_CRI_PES_FACTURE_MONTANT_HT" sql-index-id="SQI_PES_FACTURE_MONTANT_HT">
+ <where-clause>${table}.${column}##OPERATEUR:montantHT####VALEUR:montantHT##</where-clause>
+ </criteria>
+ <criteria id="_CRI_PES_FACTURE_MONTANT_TVA"
+ sql-index-id="SQI_PES_FACTURE_MONTANT_TVA">
+ <where-clause>${table}.${column}##OPERATEUR:montantTVA####VALEUR:montantTVA##</where-clause>
+ </criteria>
+ <criteria id="_CRI_PES_FACTURE_MONTANT_TTC"
+ sql-index-id="SQI_PES_FACTURE_MONTANT_TTC">
+ <where-clause>${table}.${column}##OPERATEUR:montantTTC####VALEUR:montantTTC##</where-clause>
+ </criteria>
+ <criteria id="_CRI_PES_FACTURE_NUMERO_CARTE"
+ sql-index-id="SQI_M_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMERO_CARTEACHAT2">
+ <where-clause>(fn:string-compare(${table}.${column},IdTiers))</where-clause>
+ </criteria>
+ <criteria id="_CRI_PES_FACTURE_NUMERO_COMMANDE"
+ sql-index-id="SQI_M_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMERO_COMMANDE2">
+ <where-clause>(fn:string-compare(${table}.${column},NumeroCommande))</where-clause>
+ </criteria>
+ <criteria id="_CRI_PES_FACTURE_PRIXUNITAIRE"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_MTUNITAIRE">
+ <where-clause>${table}.${column}##OPERATEUR:prixht####VALEUR:prixht##</where-clause>
+ </criteria>
+ <criteria id="_CRI_PES_FACTURE_QUANTITE"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_QUANTITE">
+ <where-clause>${table}.${column}##OPERATEUR:quantite####VALEUR:quantite##</where-clause>
+ </criteria>
+
+ <!-- CRITERIA /PES_ReleveCarteAchat/PES_CarteAchat -->
+
+ <!-- CRITERIA /PES_ReleveCarteAchat/PES_CarteAchat/PESFacture -->
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TYPEFACT" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TYPEFACT">
+ <where-clause>fn:string-compare(${table}.${column},TypeFact)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_CODPAYS" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_CODPAYS">
+ <where-clause>${table}.${column}##OPERATEUR:CodPays####VALEUR:CodPays##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_SERVICE" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_SERVICE">
+ <where-clause>fn:string-compare(${table}.${column},Service)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_COMPLNOM" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_COMPLNOM">
+ <where-clause>fn:string-compare(${table}.${column},ComplNom)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_DEVISE" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_DEVISE">
+ <where-clause>fn:string-compare(${table}.${column},Devise)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_IDBANCINT" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_IDBANCINT">
+ <where-clause>fn:string-compare(${table}.${column},IdBancInt)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_NUMSEQUENCE" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_NUMSEQUENCE">
+ <where-clause>${table}.${column}##OPERATEUR:NumSequence####VALEUR:NumSequence##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_DTEIDTIERS" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_DTEIDTIERS">
+ <where-clause>fn:date-compare(${table}.${column},DteIdTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TITCPTE" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TITCPTE">
+ <where-clause>fn:string-compare(${table}.${column},TitCpte)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_CP" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_CP">
+ <where-clause>fn:string-compare(${table}.${column},Cp)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_DESCRIPTION" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_DESCRIPTION">
+ <where-clause>fn:string-compare(${table}.${column},Description)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_REFTIERS" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_REFTIERS">
+ <where-clause>fn:string-compare(${table}.${column},RefTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_DTEBANC" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_DTEBANC">
+ <where-clause>fn:date-compare(${table}.${column},DteBanc)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_ADR3" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_ADR3">
+ <where-clause>fn:string-compare(${table}.${column},Adr3)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_ADR2" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_ADR2">
+ <where-clause>fn:string-compare(${table}.${column},Adr2)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_CATTIERS" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_CATTIERS">
+ <where-clause>fn:string-compare(${table}.${column},CatTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_NATJUR" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_NATJUR">
+ <where-clause>fn:string-compare(${table}.${column},NatJur)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_ADR1" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_ADR1">
+ <where-clause>fn:string-compare(${table}.${column},Adr1)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_NATIDTIERS" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_NATIDTIERS">
+ <where-clause>fn:string-compare(${table}.${column},NatIdTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_DTEADR" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_DTEADR">
+ <where-clause>fn:date-compare(${table}.${column},DteAdr)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_PRENOM" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_PRENOM">
+ <where-clause>fn:string-compare(${table}.${column},Prenom)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_LIBBANC" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_LIBBANC">
+ <where-clause>fn:string-compare(${table}.${column},LibBanc)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_NUMTVA" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_NUMTVA">
+ <where-clause>fn:string-compare(${table}.${column},NumTVA)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_CODRES" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_CODRES">
+ <where-clause>fn:string-compare(${table}.${column},CodRes)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_NOM" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_NOM">
+ <where-clause>fn:string-compare(${table}.${column},Nom)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_ANNEE" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_ANNEE">
+ <where-clause>fn:string-compare(${table}.${column},Annee)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_CLERIB" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_CLERIB">
+ <where-clause>${table}.${column}##OPERATEUR:CleRib####VALEUR:CleRib##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TYPTIERS" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TYPTIERS">
+ <where-clause>fn:string-compare(${table}.${column},TypTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_CODEETAB" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_CODEETAB">
+ <where-clause>fn:string-compare(${table}.${column},CodeEtab)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_VILLE" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_VILLE">
+ <where-clause>fn:string-compare(${table}.${column},Ville)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_DATE" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_DATE">
+ <where-clause>fn:date-compare(${table}.${column},Date)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_CODEGUIC" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_CODEGUIC">
+ <where-clause>fn:string-compare(${table}.${column},CodeGuic)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_IDPAYINT" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_IDPAYINT">
+ <where-clause>fn:string-compare(${table}.${column},IdPayInt)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_IDTIERS" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_IDTIERS">
+ <where-clause>fn:string-compare(${table}.${column},IdTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TYPETIERSFACTURE" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TYPETIERSFACTURE">
+ <where-clause>fn:string-compare(${table}.${column},TypeTiersFacture)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TYPADR" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TYPADR">
+ <where-clause>fn:string-compare(${table}.${column},TypAdr)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_DTEMALADE" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_DTEMALADE">
+ <where-clause>fn:date-compare(${table}.${column},DteMalade)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_CIVILITE" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_CIVILITE">
+ <where-clause>fn:string-compare(${table}.${column},Civilite)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_IDCPTE" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_IDCPTE">
+ <where-clause>fn:string-compare(${table}.${column},IdCpte)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_IDVER" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_IDVER">
+ <where-clause>${table}.${column}##OPERATEUR:IdVer####VALEUR:IdVer##</where-clause>
+ </criteria>
+
+ <!-- CRITERIA /PES_ReleveCarteAchat/PES_CarteAchat/PESFacture/Tiers -->
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_DTEBANC" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_DTEBANC">
+ <where-clause>fn:date-compare(${table}.${column},DteBanc)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_VILLE" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_VILLE">
+ <where-clause>fn:string-compare(${table}.${column},Ville)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_TYPADR" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_TYPADR">
+ <where-clause>fn:string-compare(${table}.${column},TypAdr)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_CP" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_CP">
+ <where-clause>fn:string-compare(${table}.${column},CP)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_CATTIERS" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_CATTIERS">
+ <where-clause>fn:string-compare(${table}.${column},CatTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_TYPETIERSFACTURE" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_TYPETIERSFACTURE">
+ <where-clause>fn:string-compare(${table}.${column},TypeTiersFacture)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_NUMTVA" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_NUMTVA">
+ <where-clause>fn:string-compare(${table}.${column},NumTVA)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_IDTIERS" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_IDTIERS">
+ <where-clause>fn:string-compare(${table}.${column},IdTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_CODRES" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_CODRES">
+ <where-clause>fn:string-compare(${table}.${column},CodRes)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_CLERIB" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_CLERIB">
+ <where-clause>${table}.${column}##OPERATEUR:CleRib####VALEUR:CleRib##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_CODEGUIC" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_CODEGUIC">
+ <where-clause>fn:string-compare(${table}.${column},CodeGuic)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_CODPAYS" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_CODPAYS">
+ <where-clause>${table}.${column}##OPERATEUR:CodPays####VALEUR:CodPays##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_PRENOM" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_PRENOM">
+ <where-clause>fn:string-compare(${table}.${column},Prenom)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_IDPAYINT" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_IDPAYINT">
+ <where-clause>fn:string-compare(${table}.${column},IdPayInt)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_SERVICE" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_SERVICE">
+ <where-clause>fn:string-compare(${table}.${column},Service)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_IDBANCINT" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_IDBANCINT">
+ <where-clause>fn:string-compare(${table}.${column},IdBancInt)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_TYPTIERS" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_TYPTIERS">
+ <where-clause>fn:string-compare(${table}.${column},TypTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_REFTIERS" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_REFTIERS">
+ <where-clause>fn:string-compare(${table}.${column},RefTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_NOM" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_NOM">
+ <where-clause>fn:string-compare(${table}.${column},Nom)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_CODEETAB" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_CODEETAB">
+ <where-clause>fn:string-compare(${table}.${column},CodeEtab)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_ADR3" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_ADR3">
+ <where-clause>fn:string-compare(${table}.${column},Adr3)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_NATIDTIERS" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_NATIDTIERS">
+ <where-clause>fn:string-compare(${table}.${column},NatIdTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_IDCPTE" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_IDCPTE">
+ <where-clause>fn:string-compare(${table}.${column},IdCpte)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_ADR2" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_ADR2">
+ <where-clause>fn:string-compare(${table}.${column},Adr2)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_TITCPTE" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_TITCPTE">
+ <where-clause>fn:string-compare(${table}.${column},TitCpte)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_LIBBANC" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_LIBBANC">
+ <where-clause>fn:string-compare(${table}.${column},LibBanc)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_ADR1" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_ADR1">
+ <where-clause>fn:string-compare(${table}.${column},Adr1)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_DTEIDTIERS" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_DTEIDTIERS">
+ <where-clause>fn:date-compare(${table}.${column},DteIdTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_NATJUR" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_NATJUR">
+ <where-clause>fn:string-compare(${table}.${column},NatJur)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_DTEADR" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_DTEADR">
+ <where-clause>fn:date-compare(${table}.${column},DteAdr)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_DTEMALADE" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_DTEMALADE">
+ <where-clause>fn:date-compare(${table}.${column},DteMalade)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_CIVILITE" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_CIVILITE">
+ <where-clause>fn:string-compare(${table}.${column},Civilite)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_TIERS_COMPLNOM" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_TIERS_COMPLNOM">
+ <where-clause>fn:string-compare(${table}.${column},ComplNom)</where-clause>
+ </criteria>
+
+ <!-- CRITERIA /PES_ReleveCarteAchat/PES_CarteAchat/PESFacture/FactureIndiv -->
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TYPEFACT" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TYPEFACT">
+ <where-clause>fn:string-compare(${table}.${column},TypeFact)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CODPAYS" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CODPAYS">
+ <where-clause>${table}.${column}##OPERATEUR:CodPays####VALEUR:CodPays##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_SERVICE" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_SERVICE">
+ <where-clause>fn:string-compare(${table}.${column},Service)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_COMPLNOM" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_COMPLNOM">
+ <where-clause>fn:string-compare(${table}.${column},ComplNom)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MTTOTALTTC" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MTTOTALTTC">
+ <where-clause>${table}.${column}##OPERATEUR:MtTotalTTC####VALEUR:MtTotalTTC##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_IDBANCINT" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_IDBANCINT">
+ <where-clause>fn:string-compare(${table}.${column},IdBancInt)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_OBJET" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_OBJET">
+ <where-clause>fn:string-compare(${table}.${column},Objet)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DATEEMISSION" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DATEEMISSION">
+ <where-clause>fn:date-compare(${table}.${column},DateEmission)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TEXTEGENERATEUR" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TEXTEGENERATEUR">
+ <where-clause>fn:string-compare(${table}.${column},TexteGenerateur)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DTEIDTIERS" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DTEIDTIERS">
+ <where-clause>fn:date-compare(${table}.${column},DteIdTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TITCPTE" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TITCPTE">
+ <where-clause>fn:string-compare(${table}.${column},TitCpte)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CP" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CP">
+ <where-clause>fn:string-compare(${table}.${column},Cp)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_REFTIERS" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_REFTIERS">
+ <where-clause>fn:string-compare(${table}.${column},RefTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DTEBANC" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DTEBANC">
+ <where-clause>fn:date-compare(${table}.${column},DteBanc)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_ADR3" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_ADR3">
+ <where-clause>fn:string-compare(${table}.${column},Adr3)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_ADR2" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_ADR2">
+ <where-clause>fn:string-compare(${table}.${column},Adr2)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CATTIERS" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CATTIERS">
+ <where-clause>fn:string-compare(${table}.${column},CatTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NATJUR" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NATJUR">
+ <where-clause>fn:string-compare(${table}.${column},NatJur)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_ADR1" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_ADR1">
+ <where-clause>fn:string-compare(${table}.${column},Adr1)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NATIDTIERS" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NATIDTIERS">
+ <where-clause>fn:string-compare(${table}.${column},NatIdTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MTTOTALTVA" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MTTOTALTVA">
+ <where-clause>${table}.${column}##OPERATEUR:MtTotalTVA####VALEUR:MtTotalTVA##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DTEADR" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DTEADR">
+ <where-clause>fn:date-compare(${table}.${column},DteAdr)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MOYENPAIEMENT" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MOYENPAIEMENT">
+ <where-clause>fn:string-compare(${table}.${column},MoyenPaiement)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMEROCONTRAT" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMEROCONTRAT">
+ <where-clause>fn:string-compare(${table}.${column},NumeroContrat)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_PRENOM" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_PRENOM">
+ <where-clause>fn:string-compare(${table}.${column},Prenom)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_LIBBANC" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_LIBBANC">
+ <where-clause>fn:string-compare(${table}.${column},LibBanc)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMEROFACTURE" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMEROFACTURE">
+ <where-clause>fn:string-compare(${table}.${column},NumeroFacture)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMEROMARCHE" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMEROMARCHE">
+ <where-clause>fn:string-compare(${table}.${column},NumeroMarche)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMTVA" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMTVA">
+ <where-clause>fn:string-compare(${table}.${column},NumTVA)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MTTOTALHT" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MTTOTALHT">
+ <where-clause>${table}.${column}##OPERATEUR:MtTotalHT####VALEUR:MtTotalHT##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CODRES" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CODRES">
+ <where-clause>fn:string-compare(${table}.${column},CodRes)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NOM" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NOM">
+ <where-clause>fn:string-compare(${table}.${column},Nom)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MODALITESREGLEMENT" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MODALITESREGLEMENT">
+ <where-clause>fn:string-compare(${table}.${column},ModalitesReglement)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CLERIB" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CLERIB">
+ <where-clause>${table}.${column}##OPERATEUR:CleRib####VALEUR:CleRib##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TYPTIERS" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TYPTIERS">
+ <where-clause>fn:string-compare(${table}.${column},TypTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CODEETAB" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CODEETAB">
+ <where-clause>fn:string-compare(${table}.${column},CodeEtab)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DATEREGLEMENT" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DATEREGLEMENT">
+ <where-clause>fn:date-compare(${table}.${column},DateReglement)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CONDITIONSGEN" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CONDITIONSGEN">
+ <where-clause>fn:string-compare(${table}.${column},ConditionsGen)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_VILLE" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_VILLE">
+ <where-clause>fn:string-compare(${table}.${column},Ville)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CODEGUIC" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CODEGUIC">
+ <where-clause>fn:string-compare(${table}.${column},CodeGuic)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_IDPAYINT" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_IDPAYINT">
+ <where-clause>fn:string-compare(${table}.${column},IdPayInt)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_IDTIERS" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_IDTIERS">
+ <where-clause>fn:string-compare(${table}.${column},IdTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TYPETIERSFACTURE" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TYPETIERSFACTURE">
+ <where-clause>fn:string-compare(${table}.${column},TypeTiersFacture)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TYPADR" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TYPADR">
+ <where-clause>fn:string-compare(${table}.${column},TypAdr)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DTEMALADE" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DTEMALADE">
+ <where-clause>fn:date-compare(${table}.${column},DteMalade)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TAUXREMISE" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TAUXREMISE">
+ <where-clause>${table}.${column}##OPERATEUR:TauxRemise####VALEUR:TauxRemise##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CIVILITE" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CIVILITE">
+ <where-clause>fn:string-compare(${table}.${column},Civilite)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_IDCPTE" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_IDCPTE">
+ <where-clause>fn:string-compare(${table}.${column},IdCpte)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MTREMISE" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MTREMISE">
+ <where-clause>${table}.${column}##OPERATEUR:MtRemise####VALEUR:MtRemise##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PESFACTURE_FACTUREINDIV_FOURNISSEUR" type="1"
+ sql-index-id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_FOURNISSEUR">
+ <where-clause>fn:string-compare(${table}.${column},Fournisseur)</where-clause>
+ </criteria>
+
+ <!-- CRITERIA /PES_ReleveCarteAchat/PES_CarteAchat/PESFacture/FactureIndiv/Reference -->
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_REFERENCE_NUMEROPIECE" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_REFERENCE_NUMEROPIECE">
+ <where-clause>fn:string-compare(${table}.${column},NumeroPiece)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_REFERENCE_TYPEPIECE" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_REFERENCE_TYPEPIECE">
+ <where-clause>fn:string-compare(${table}.${column},TypePiece)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_REFERENCE_NUMLIGNE" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_REFERENCE_NUMLIGNE">
+ <where-clause>${table}.${column}##OPERATEUR:NumLigne####VALEUR:NumLigne##</where-clause>
+ </criteria>
+
+ <!-- CRITERIA /PES_ReleveCarteAchat/PES_CarteAchat/PESFacture/FactureIndiv/Tiers -->
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_DTEBANC" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_DTEBANC">
+ <where-clause>fn:date-compare(${table}.${column},DteBanc)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_VILLE" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_VILLE">
+ <where-clause>fn:string-compare(${table}.${column},Ville)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_TYPADR" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_TYPADR">
+ <where-clause>fn:string-compare(${table}.${column},TypAdr)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_CP" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CP">
+ <where-clause>fn:string-compare(${table}.${column},CP)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_CATTIERS" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CATTIERS">
+ <where-clause>fn:string-compare(${table}.${column},CatTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_TYPETIERSFACTURE" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_TYPETIERSFACTURE">
+ <where-clause>fn:string-compare(${table}.${column},TypeTiersFacture)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_NUMTVA" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_NUMTVA">
+ <where-clause>fn:string-compare(${table}.${column},NumTVA)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_IDTIERS" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_IDTIERS">
+ <where-clause>fn:string-compare(${table}.${column},IdTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_CODRES" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CODRES">
+ <where-clause>fn:string-compare(${table}.${column},CodRes)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_CLERIB" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CLERIB">
+ <where-clause>${table}.${column}##OPERATEUR:CleRib####VALEUR:CleRib##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_CODEGUIC" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CODEGUIC">
+ <where-clause>fn:string-compare(${table}.${column},CodeGuic)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_CODPAYS" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CODPAYS">
+ <where-clause>${table}.${column}##OPERATEUR:CodPays####VALEUR:CodPays##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_PRENOM" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_PRENOM">
+ <where-clause>fn:string-compare(${table}.${column},Prenom)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_IDPAYINT" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_IDPAYINT">
+ <where-clause>fn:string-compare(${table}.${column},IdPayInt)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_SERVICE" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_SERVICE">
+ <where-clause>fn:string-compare(${table}.${column},Service)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_IDBANCINT" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_IDBANCINT">
+ <where-clause>fn:string-compare(${table}.${column},IdBancInt)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_TYPTIERS" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_TYPTIERS">
+ <where-clause>fn:string-compare(${table}.${column},TypTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_REFTIERS" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_REFTIERS">
+ <where-clause>fn:string-compare(${table}.${column},RefTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_NOM" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_NOM">
+ <where-clause>fn:string-compare(${table}.${column},Nom)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_CODEETAB" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CODEETAB">
+ <where-clause>fn:string-compare(${table}.${column},CodeEtab)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_ADR3" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_ADR3">
+ <where-clause>fn:string-compare(${table}.${column},Adr3)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_NATIDTIERS" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_NATIDTIERS">
+ <where-clause>fn:string-compare(${table}.${column},NatIdTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_IDCPTE" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_IDCPTE">
+ <where-clause>fn:string-compare(${table}.${column},IdCpte)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_ADR2" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_ADR2">
+ <where-clause>fn:string-compare(${table}.${column},Adr2)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_TITCPTE" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_TITCPTE">
+ <where-clause>fn:string-compare(${table}.${column},TitCpte)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_LIBBANC" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_LIBBANC">
+ <where-clause>fn:string-compare(${table}.${column},LibBanc)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_ADR1" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_ADR1">
+ <where-clause>fn:string-compare(${table}.${column},Adr1)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_DTEIDTIERS" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_DTEIDTIERS">
+ <where-clause>fn:date-compare(${table}.${column},DteIdTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_NATJUR" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_NATJUR">
+ <where-clause>fn:string-compare(${table}.${column},NatJur)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_DTEADR" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_DTEADR">
+ <where-clause>fn:date-compare(${table}.${column},DteAdr)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_DTEMALADE" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_DTEMALADE">
+ <where-clause>fn:date-compare(${table}.${column},DteMalade)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_CIVILITE" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CIVILITE">
+ <where-clause>fn:string-compare(${table}.${column},Civilite)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_TIERS_COMPLNOM" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_COMPLNOM">
+ <where-clause>fn:string-compare(${table}.${column},ComplNom)</where-clause>
+ </criteria>
+
+ <!-- CRITERIA /PES_ReleveCarteAchat/PES_CarteAchat/PESFacture/FactureIndiv/LigneFacture -->
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_ORDRE" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_ORDRE">
+ <where-clause>${table}.${column}##OPERATEUR:Ordre####VALEUR:Ordre##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_CODEFONCTION" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_CODEFONCTION">
+ <where-clause>fn:string-compare(${table}.${column},CodeFonction)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_MTTTC" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_MTTTC">
+ <where-clause>${table}.${column}##OPERATEUR:MtTTC####VALEUR:MtTTC##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_TAUX" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_TAUX">
+ <where-clause>${table}.${column}##OPERATEUR:Taux####VALEUR:Taux##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_MTREMISE" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_MTREMISE">
+ <where-clause>${table}.${column}##OPERATEUR:MtRemise####VALEUR:MtRemise##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_MTHT" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_MTHT">
+ <where-clause>${table}.${column}##OPERATEUR:MtHT####VALEUR:MtHT##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_TAUXTVA" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_TAUXTVA">
+ <where-clause>${table}.${column}##OPERATEUR:TauxTVA####VALEUR:TauxTVA##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_MTTVA" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_MTTVA">
+ <where-clause>${table}.${column}##OPERATEUR:MtTVA####VALEUR:MtTVA##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_ORDREEDITION" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_ORDREEDITION">
+ <where-clause>${table}.${column}##OPERATEUR:OrdreEdition####VALEUR:OrdreEdition##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_CODEPRODUIT" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_CODEPRODUIT">
+ <where-clause>${table}.${column}="##VALEUR:CodeProduit##"</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_TAUXREMISE" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_TAUXREMISE">
+ <where-clause>${table}.${column}##OPERATEUR:TauxRemise####VALEUR:TauxRemise##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_CODENATURE" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_CODENATURE">
+ <where-clause>${table}.${column}="##VALEUR:CodeNature##"</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_LIBELLE" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_LIBELLE">
+ <where-clause>fn:string-compare(${table}.${column},Libelle)</where-clause>
+ </criteria>
+
+ <!-- CRITERIA /PES_ReleveCarteAchat/PES_CarteAchat/PESFacture/FactureIndiv/LigneFacture/Tiers -->
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_DTEBANC" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_DTEBANC">
+ <where-clause>fn:date-compare(${table}.${column},DteBanc)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_VILLE" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_VILLE">
+ <where-clause>fn:string-compare(${table}.${column},Ville)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_TYPADR" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_TYPADR">
+ <where-clause>fn:string-compare(${table}.${column},TypAdr)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_CP" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_CP">
+ <where-clause>fn:string-compare(${table}.${column},CP)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_CATTIERS" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_CATTIERS">
+ <where-clause>fn:string-compare(${table}.${column},CatTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_TYPETIERSFACTURE" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_TYPETIERSFACTURE">
+ <where-clause>fn:string-compare(${table}.${column},TypeTiersFacture)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_NUMTVA" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_NUMTVA">
+ <where-clause>fn:string-compare(${table}.${column},NumTVA)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_IDTIERS" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_IDTIERS">
+ <where-clause>fn:string-compare(${table}.${column},IdTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_CODRES" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_CODRES">
+ <where-clause>fn:string-compare(${table}.${column},CodRes)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_CLERIB" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_CLERIB">
+ <where-clause>${table}.${column}##OPERATEUR:CleRib####VALEUR:CleRib##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_CODEGUIC" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_CODEGUIC">
+ <where-clause>fn:string-compare(${table}.${column},CodeGuic)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_CODPAYS" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_CODPAYS">
+ <where-clause>${table}.${column}##OPERATEUR:CodPays####VALEUR:CodPays##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_PRENOM" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_PRENOM">
+ <where-clause>fn:string-compare(${table}.${column},Prenom)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_IDPAYINT" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_IDPAYINT">
+ <where-clause>fn:string-compare(${table}.${column},IdPayInt)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_SERVICE" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_SERVICE">
+ <where-clause>fn:string-compare(${table}.${column},Service)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_IDBANCINT" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_IDBANCINT">
+ <where-clause>fn:string-compare(${table}.${column},IdBancInt)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_TYPTIERS" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_TYPTIERS">
+ <where-clause>fn:string-compare(${table}.${column},TypTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_REFTIERS" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_REFTIERS">
+ <where-clause>fn:string-compare(${table}.${column},RefTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_NOM" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_NOM">
+ <where-clause>fn:string-compare(${table}.${column},Nom)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_CODEETAB" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_CODEETAB">
+ <where-clause>fn:string-compare(${table}.${column},CodeEtab)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_ADR3" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_ADR3">
+ <where-clause>fn:string-compare(${table}.${column},Adr3)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_NATIDTIERS" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_NATIDTIERS">
+ <where-clause>fn:string-compare(${table}.${column},NatIdTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_IDCPTE" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_IDCPTE">
+ <where-clause>fn:string-compare(${table}.${column},IdCpte)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_ADR2" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_ADR2">
+ <where-clause>fn:string-compare(${table}.${column},Adr2)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_TITCPTE" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_TITCPTE">
+ <where-clause>fn:string-compare(${table}.${column},TitCpte)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_LIBBANC" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_LIBBANC">
+ <where-clause>fn:string-compare(${table}.${column},LibBanc)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_ADR1" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_ADR1">
+ <where-clause>fn:string-compare(${table}.${column},Adr1)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_DTEIDTIERS" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_DTEIDTIERS">
+ <where-clause>fn:date-compare(${table}.${column},DteIdTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_NATJUR" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_NATJUR">
+ <where-clause>fn:string-compare(${table}.${column},NatJur)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_DTEADR" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_DTEADR">
+ <where-clause>fn:date-compare(${table}.${column},DteAdr)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_DTEMALADE" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_DTEMALADE">
+ <where-clause>fn:date-compare(${table}.${column},DteMalade)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_CIVILITE" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_CIVILITE">
+ <where-clause>fn:string-compare(${table}.${column},Civilite)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_TIERS_COMPLNOM" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_COMPLNOM">
+ <where-clause>fn:string-compare(${table}.${column},ComplNom)</where-clause>
+ </criteria>
+
+ <!-- CRITERIA /PES_ReleveCarteAchat/PES_CarteAchat/PESFacture/FactureIndiv/LigneFacture/reference -->
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_REFERENCE_NUMEROPIECE" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_REFERENCE_NUMEROPIECE">
+ <where-clause>fn:string-compare(${table}.${column},NumeroPiece)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_REFERENCE_TYPEPIECE" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_REFERENCE_TYPEPIECE">
+ <where-clause>fn:string-compare(${table}.${column},TypePiece)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_REFERENCE_NUMLIGNE" type="1"
+ sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_REFERENCE_NUMLIGNE">
+ <where-clause>${table}.${column}##OPERATEUR:NumLigne####VALEUR:NumLigne##</where-clause>
+ </criteria>
+
+ <!-- CRITERIA /PES_ReleveCarteAchat/PES_CarteAchat/PESFacture/FactureIndiv/DetailTVA -->
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_DETAILTVA_TAUXTVA" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_DETAILTVA_TAUXTVA">
+ <where-clause>${table}.${column}##OPERATEUR:TauxTVA####VALEUR:TauxTVA##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_DETAILTVA_MTTVA" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_DETAILTVA_MTTVA">
+ <where-clause>${table}.${column}##OPERATEUR:MtTVA####VALEUR:MtTVA##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_FACTUREINDIV_DETAILTVA_MTBASEHT" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_DETAILTVA_MTBASEHT">
+ <where-clause>${table}.${column}##OPERATEUR:MtBaseHT####VALEUR:MtBaseHT##</where-clause>
+ </criteria>
+
+
+ <!-- CRITERES POUR LE QUITTANCEMENT -->
+ <criteria id="LOGEMENT_IDTIERS" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_IDTIERS">
+ <where-clause>(fn:string-compare(${table}.${column},IDTiers) AND ${table}.TYPETIERSFACTURE='30')</where-clause>
+ </criteria>
+ <criteria id="LOGEMENT_VILLE" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_VILLE">
+ <where-clause>(fn:string-compare(${table}.${column},Ville) AND ${table}.TYPETIERSFACTURE='30')</where-clause>
+ </criteria>
+ <criteria id="LOGEMENT_CP" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CP">
+ <where-clause>(fn:string-compare(${table}.${column},Cp) AND ${table}.TYPETIERSFACTURE='30')</where-clause>
+ </criteria>
+ <criteria id="LOGEMENT_ADR3" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_ADR3">
+ <where-clause>(fn:string-compare(${table}.${column},Adr3) AND ${table}.TYPETIERSFACTURE='30')</where-clause>
+ </criteria>
+ <criteria id="LOGEMENT_ADR2" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_ADR2">
+ <where-clause>(fn:string-compare(${table}.${column},Adr2) AND ${table}.TYPETIERSFACTURE='30')</where-clause>
+ </criteria>
+ <criteria id="LOGEMENT_ADR1" type="1"
+ sql-index-id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_ADR1">
+ <where-clause>(fn:string-compare(${table}.${column},Adr1) AND ${table}.TYPETIERSFACTURE='30')</where-clause>
+ </criteria>
+ <criteria id="MOIS_DATE_EMISSION" type="1"
+ sql-index-id="SQI_M_PES_FACTURE_PESFACTURE_FACTUREINDIV_MOIS_DATE_EMISSION">
+ <where-clause>${table}.${column}=##VALEUR:Mois##</where-clause>
+ </criteria>
+ <criteria id="ANNEE_DATE_EMISSION" sql-index-id="SQI_M_PES_FACTURE_PESFACTURE_FACTUREINDIV_ANNEE_DATE_EMISSION" type="1">
+ <where-clause>${table}.${column}=##VALEUR:Annee##</where-clause>
+ </criteria>
+
+ <criteria id="ID_LOGEMENT" type="1"
+ sql-index-id="SQI_M_PES_FACTURE_PESFACTURE_FACTUREINDIV_ID_LOGEMENT">
+ <where-clause>(fn:string-compare(${table}.${column},IDLogement) AND
+ ${table}.TYPETIERSFACTURE='30')</where-clause>
+ </criteria>
+
+ <!-- SQL-INDEX PERSO -->
+ <sql-index id="SQI_PES_FACTURE_MONTANT_HT"
+ path="/n:DOC_PES_Facture/n:PESFacture/@added:montantHT" column="MONTANT_HT"
+ datatype="decimal" table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_MONTANT_TVA"
+ path="/n:DOC_PES_Facture/n:PESFacture/@added:montantTVA" column="MONTANT_TVA"
+ datatype="decimal" table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_MONTANT_TTC"
+ path="/n:DOC_PES_Facture/n:PESFacture/@added:montantTTC" column="MONTANT_TTC"
+ datatype="decimal" table="PES_FACTURE_PESFACTURE_IX"/>
+ <!--sql-index id="SQI_M_PES_FACTURE_PESFACTURE__NODE_ID"
+ path="/n:n:DOC_PES_Facture/n:n:PESFacture/@added:generated-id" column="NODE_ID"
+ datatype="string" table="PES_FACTURE_PESFACTURE_IX"/-->
+ <!--sql-index id="SQI_M_PES_FACTURE_PESFACTURE_PRIMARYKEY"
+ path="/n:n:DOC_PES_Facture/n:n:PESFacture/@added:primarykey" column="PRIMARY_KEY"
+ datatype="string" table="PES_FACTURE_PESFACTURE_IX"/-->
+ <!--sql-index id="SQI_M_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMERO_CARTEACHAT"
+ path="/n:n:DOC_PES_Facture/n:n:PESFacture/n:n:FactureIndiv/@added:numero_carteachat"
+ column="NUMERO_CARTEACHAT" datatype="string"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/-->
+ <sql-index id="SQI_M_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMERO_CARTEACHAT2"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/@added:numero_carteachat"
+ column="NUMERO_CARTEACHAT" datatype="string"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <!--sql-index id="SQI_M_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMERO_COMMANDE"
+ path="/n:n:DOC_PES_Facture/n:n:PESFacture/n:n:FactureIndiv/@added:numero_commande"
+ column="NUMERO_COMMANDE" datatype="string"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/-->
+ <sql-index id="SQI_M_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMERO_COMMANDE2"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/@added:numero_commande"
+ column="NUMERO_COMMANDE" datatype="string"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_M_PES_FACTURE_PESFACTURE_FACTUREINDIV_MOIS_DATE_EMISSION"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/@added:moisDateEmission"
+ column="MOIS_DATE_EMISSION" datatype="string"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <!--sql-index id="SQI_M_PES_FACTURE_PESFACTURE_FACTUREINDIV_MOIS_DATE_EMISSION2"
+ path="/n:n:DOC_PES_Facture/n:n:PESFacture/n:n:FactureIndiv/@added:moisDateEmission"
+ column="MOIS_DATE_EMISSION" datatype="string"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/-->
+ <sql-index id="SQI_M_PES_FACTURE_PESFACTURE_FACTUREINDIV_ANNEE_DATE_EMISSION"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/@added:anneeDateEmission"
+ column="ANNEE_DATE_EMISSION" datatype="string"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <!--sql-index id="SQI_M_PES_FACTURE_PESFACTURE_FACTUREINDIV_ANNEE_DATE_EMISSION2"
+ path="/n:n:DOC_PES_Facture/n:n:PESFacture/n:n:FactureIndiv/@added:anneeDateEmission"
+ column="ANNEE_DATE_EMISSION" datatype="string"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/-->
+ <sql-index id="SQI_M_PES_FACTURE_PESFACTURE_FACTUREINDIV_ID_LOGEMENT"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/@added:IDLogement"
+ column="ID_LOGEMENT" datatype="string"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <!--sql-index id="SQI_M_PES_FACTURE_PESFACTURE_FACTUREINDIV_ID_LOGEMENT2"
+ path="/n:n:DOC_PES_Facture/n:n:PESFacture/n:n:FactureIndiv/@added:IDLogement"
+ column="ID_LOGEMENT" datatype="string"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/-->
+
+
+ <!-- SQL-INDEX /n:DOC_PES_Facture/n:PES_CarteAchat -->
+
+ <!-- SQL-INDEX /n:DOC_PES_Facture/n:PESFacture -->
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_PRIMARYKEY"
+ path="/n:DOC_PES_Facture/n:PESFacture/@added:primarykey" column="PRIMARY_KEY"
+ datatype="string" table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE__NODE_ID"
+ path="/n:DOC_PES_Facture/n:PESFacture/@added:generated-id" column="NODE_ID"
+ datatype="string" table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TYPEFACT"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:TypeFact/@V" datatype="string"
+ column="TYPEFACT" table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_CODPAYS"
+ path="/n:DOC_PES_Facture/n:Emetteur/n:Adresse/n:CodPays/@V" datatype="integer"
+ column="CODPAYS" table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_SERVICE"
+ path="/n:DOC_PES_Facture/n:Emetteur/n:Service/@V" datatype="string" column="SERVICE"
+ table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_COMPLNOM"
+ path="/n:DOC_PES_Facture/n:Emetteur/n:InfoTiers/n:ComplNom/@V" datatype="string"
+ column="COMPLNOM" table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_DEVISE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Devise/@V" datatype="string" column="DEVISE"
+ table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_IDBANCINT"
+ path="/n:DOC_PES_Facture/n:Emetteur/n:CpteBancaire/n:IdBancInt/@V" datatype="string"
+ column="IDBANCINT" table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_NUMSEQUENCE"
+ path="/n:DOC_PES_Facture/n:NumSequence/@V" datatype="integer" column="NUMSEQUENCE"
+ table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_DTEIDTIERS"
+ path="/n:DOC_PES_Facture/n:Emetteur/n:InfoTiers/n:DteIdTiers/@V" datatype="date"
+ format="yyyy-MM-dd" column="DTEIDTIERS" table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TITCPTE"
+ path="/n:DOC_PES_Facture/n:Emetteur/n:CpteBancaire/n:TitCpte/@V" datatype="string"
+ column="TITCPTE" table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_CP"
+ path="/n:DOC_PES_Facture/n:Emetteur/n:Adresse/n:CP/@V" datatype="string" column="CP"
+ table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_DESCRIPTION"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Nomenclatures/n:NomenclatureBudget/n:Description/@V"
+ datatype="string" column="DESCRIPTION" table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_REFTIERS"
+ path="/n:DOC_PES_Facture/n:Emetteur/n:InfoTiers/n:RefTiers/@V" datatype="string"
+ column="REFTIERS" table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_DTEBANC"
+ path="/n:DOC_PES_Facture/n:Emetteur/n:CpteBancaire/n:DteBanc/@V" datatype="date"
+ format="yyyy-MM-dd" column="DTEBANC" table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_ADR3"
+ path="/n:DOC_PES_Facture/n:Emetteur/n:Adresse/n:Adr3/@V" datatype="string" column="ADR3"
+ table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_ADR2"
+ path="/n:DOC_PES_Facture/n:Emetteur/n:Adresse/n:Adr2/@V" datatype="string" column="ADR2"
+ table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_CATTIERS"
+ path="/n:DOC_PES_Facture/n:Emetteur/n:InfoTiers/n:CatTiers/@V" datatype="string"
+ column="CATTIERS" table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_NATJUR"
+ path="/n:DOC_PES_Facture/n:Emetteur/n:InfoTiers/n:NatJur/@V" datatype="string"
+ column="NATJUR" table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_ADR1"
+ path="/n:DOC_PES_Facture/n:Emetteur/n:Adresse/n:Adr1/@V" datatype="string" column="ADR1"
+ table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_NATIDTIERS"
+ path="/n:DOC_PES_Facture/n:Emetteur/n:InfoTiers/n:NatIdTiers/@V" datatype="string"
+ column="NATIDTIERS" table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_DTEADR"
+ path="/n:DOC_PES_Facture/n:Emetteur/n:Adresse/n:DteAdr/@V" datatype="date"
+ format="yyyy-MM-dd" column="DTEADR" table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_PRENOM"
+ path="/n:DOC_PES_Facture/n:Emetteur/n:InfoTiers/n:Prenom/@V" datatype="string"
+ column="PRENOM" table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_LIBBANC"
+ path="/n:DOC_PES_Facture/n:Emetteur/n:CpteBancaire/n:LibBanc/@V" datatype="string"
+ column="LIBBANC" table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_NUMTVA"
+ path="/n:DOC_PES_Facture/n:Emetteur/n:NumTVA/@V" datatype="string" column="NUMTVA"
+ table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_CODRES"
+ path="/n:DOC_PES_Facture/n:Emetteur/n:Adresse/n:CodRes/@V" datatype="string"
+ column="CODRES" table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_NOM"
+ path="/n:DOC_PES_Facture/n:Emetteur/n:InfoTiers/n:Nom/@V" datatype="string" column="NOM"
+ table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_ANNEE" path="/n:DOC_PES_Facture/n:Annee/@V"
+ datatype="string" column="ANNEE" table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_CLERIB"
+ path="/n:DOC_PES_Facture/n:Emetteur/n:CpteBancaire/n:CleRib/@V" datatype="integer"
+ column="CLERIB" table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TYPTIERS"
+ path="/n:DOC_PES_Facture/n:Emetteur/n:InfoTiers/n:TypTiers/@V" datatype="string"
+ column="TYPTIERS" table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_CODEETAB"
+ path="/n:DOC_PES_Facture/n:Emetteur/n:CpteBancaire/n:CodeEtab/@V" datatype="string"
+ column="CODEETAB" table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_VILLE"
+ path="/n:DOC_PES_Facture/n:Emetteur/n:Adresse/n:Ville/@V" datatype="string"
+ column="VILLE" table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_DATE" path="/n:DOC_PES_Facture/n:Date/@V"
+ datatype="date" format="yyyy-MM-dd" column="DATE"
+ table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_CODEGUIC"
+ path="/n:DOC_PES_Facture/n:Emetteur/n:CpteBancaire/n:CodeGuic/@V" datatype="string"
+ column="CODEGUIC" table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_IDPAYINT"
+ path="/n:DOC_PES_Facture/n:Emetteur/n:CpteBancaire/n:IdPayInt/@V" datatype="string"
+ column="IDPAYINT" table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_IDTIERS"
+ path="/n:DOC_PES_Facture/n:Emetteur/n:InfoTiers/n:IdTiers/@V" datatype="string"
+ column="IDTIERS" table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TYPETIERSFACTURE"
+ path="/n:DOC_PES_Facture/n:Emetteur/n:TypeTiersFacture/@V" datatype="string"
+ column="TYPETIERSFACTURE" table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TYPADR"
+ path="/n:DOC_PES_Facture/n:Emetteur/n:Adresse/n:TypAdr/@V" datatype="string"
+ column="TYPADR" table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_DTEMALADE"
+ path="/n:DOC_PES_Facture/n:Emetteur/n:InfoTiers/n:DteMalade/@V" datatype="date"
+ format="yyyy-MM-dd" column="DTEMALADE" table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_CIVILITE"
+ path="/n:DOC_PES_Facture/n:Emetteur/n:InfoTiers/n:Civilite/@V" datatype="string"
+ column="CIVILITE" table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_IDCPTE"
+ path="/n:DOC_PES_Facture/n:Emetteur/n:CpteBancaire/n:IdCpte/@V" datatype="string"
+ column="IDCPTE" table="PES_FACTURE_PESFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_IDVER" path="/n:DOC_PES_Facture/n:IdVer/@V"
+ datatype="decimal" column="IDVER" table="PES_FACTURE_PESFACTURE_IX"/>
+
+ <!-- SQL-INDEX /n:DOC_PES_Facture/n:PESFacture/n:Tiers -->
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS__NODE_ID"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/@added:generated-id" column="NODE_ID"
+ datatype="string" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_DTEBANC"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:CpteBancaire/n:DteBanc/@V" datatype="date"
+ format="yyyy-MM-dd" column="DTEBANC" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_VILLE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:Adresse/n:Ville/@V" datatype="string"
+ column="VILLE" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_TYPADR"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:Adresse/n:TypAdr/@V" datatype="string"
+ column="TYPADR" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_CP"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:Adresse/n:CP/@V" datatype="string"
+ column="CP" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_CATTIERS"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:InfoTiers/n:CatTiers/@V" datatype="string"
+ column="CATTIERS" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_TYPETIERSFACTURE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:TypeTiersFacture/@V" datatype="string"
+ column="TYPETIERSFACTURE" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_NUMTVA"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:NumTVA/@V" datatype="string"
+ column="NUMTVA" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_IDTIERS"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:InfoTiers/n:IdTiers/@V" datatype="string"
+ column="IDTIERS" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_CODRES"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:Adresse/n:CodRes/@V" datatype="string"
+ column="CODRES" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_CLERIB"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:CpteBancaire/n:CleRib/@V"
+ datatype="integer" column="CLERIB" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_CODEGUIC"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:CpteBancaire/n:CodeGuic/@V"
+ datatype="string" column="CODEGUIC" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_CODPAYS"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:Adresse/n:CodPays/@V" datatype="integer"
+ column="CODPAYS" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_PRENOM"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:InfoTiers/n:Prenom/@V2" datatype="string"
+ column="PRENOM" table="PES_FACTURE_PESFACTURE_TIERS_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_IDPAYINT"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:CpteBancaire/n:IdPayInt/@V"
+ datatype="string" column="IDPAYINT" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_SERVICE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:Service/@V" datatype="string"
+ column="SERVICE" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_IDBANCINT"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:CpteBancaire/n:IdBancInt/@V"
+ datatype="string" column="IDBANCINT" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_TYPTIERS"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:InfoTiers/n:TypTiers/@V" datatype="string"
+ column="TYPTIERS" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_REFTIERS"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:InfoTiers/n:RefTiers/@V" datatype="string"
+ column="REFTIERS" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_NOM"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:InfoTiers/n:Nom/@V2" datatype="string"
+ column="NOM" table="PES_FACTURE_PESFACTURE_TIERS_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_CODEETAB"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:CpteBancaire/n:CodeEtab/@V"
+ datatype="string" column="CODEETAB" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_ADR3"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:Adresse/n:Adr3/@V" datatype="string"
+ column="ADR3" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_NATIDTIERS"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:InfoTiers/n:NatIdTiers/@V"
+ datatype="string" column="NATIDTIERS" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_IDCPTE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:CpteBancaire/n:IdCpte/@V"
+ datatype="string" column="IDCPTE" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_ADR2"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:Adresse/n:Adr2/@V" datatype="string"
+ column="ADR2" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_TITCPTE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:CpteBancaire/n:TitCpte/@V"
+ datatype="string" column="TITCPTE" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_LIBBANC"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:CpteBancaire/n:LibBanc/@V"
+ datatype="string" column="LIBBANC" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_ADR1"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:Adresse/n:Adr1/@V" datatype="string"
+ column="ADR1" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_DTEIDTIERS"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:InfoTiers/n:DteIdTiers/@V" datatype="date"
+ format="yyyy-MM-dd" column="DTEIDTIERS" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_NATJUR"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:InfoTiers/n:NatJur/@V" datatype="string"
+ column="NATJUR" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_DTEADR"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:Adresse/n:DteAdr/@V" datatype="date"
+ format="yyyy-MM-dd" column="DTEADR" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_DTEMALADE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:InfoTiers/n:DteMalade/@V" datatype="date"
+ format="yyyy-MM-dd" column="DTEMALADE" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_CIVILITE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:InfoTiers/n:Civilite/@V" datatype="string"
+ column="CIVILITE" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_TIERS_COMPLNOM"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:Tiers/n:InfoTiers/n:ComplNom/@V" datatype="string"
+ column="COMPLNOM" table="PES_FACTURE_PESFACTURE_TIERS_IX"/>
+
+ <!-- SQL-INDEX /n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv -->
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV__NODE_ID"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/@added:generated-id"
+ column="NODE_ID" datatype="string"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TYPEFACT"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:TypeFact/@V" datatype="string"
+ column="TYPEFACT" table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CODPAYS"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:Adresse/n:CodPays/@V"
+ datatype="integer" column="CODPAYS"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_SERVICE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:Service/@V"
+ datatype="string" column="SERVICE"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_COMPLNOM"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:ComplNom/@V"
+ datatype="string" column="COMPLNOM"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MTTOTALTTC"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:TotalAPayer/n:MtTotalTTC/@V"
+ datatype="decimal" column="MTTOTALTTC"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_IDBANCINT"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:CpteBancaire/n:IdBancInt/@V"
+ datatype="string" column="IDBANCINT"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_OBJET"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Objet/@V" datatype="string"
+ column="OBJET" table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DATEEMISSION"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:DateEmission/@V" datatype="date"
+ format="yyyy-MM-dd" column="DATEEMISSION"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TEXTEGENERATEUR"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:TexteGenerateur/@V"
+ datatype="string" column="TEXTEGENERATEUR"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DTEIDTIERS"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:DteIdTiers/@V"
+ datatype="date" format="yyyy-MM-dd" column="DTEIDTIERS"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TITCPTE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:CpteBancaire/n:TitCpte/@V"
+ datatype="string" column="TITCPTE"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CP"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:Adresse/n:CP/@V"
+ datatype="string" column="CP" table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_REFTIERS"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:RefTiers/@V"
+ datatype="string" column="REFTIERS"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DTEBANC"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:CpteBancaire/n:DteBanc/@V"
+ datatype="date" format="yyyy-MM-dd" column="DTEBANC"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_ADR3"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:Adresse/n:Adr3/@V"
+ datatype="string" column="ADR3" table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"
+ format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_ADR2"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:Adresse/n:Adr2/@V"
+ datatype="string" column="ADR2" table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"
+ format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CATTIERS"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:CatTiers/@V"
+ datatype="string" column="CATTIERS"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NATJUR"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:NatJur/@V"
+ datatype="string" column="NATJUR" table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_ADR1"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:Adresse/n:Adr1/@V"
+ datatype="string" column="ADR1" table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"
+ format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NATIDTIERS"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:NatIdTiers/@V"
+ datatype="string" column="NATIDTIERS"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MTTOTALTVA"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:TotalAPayer/n:MtTotalTVA/@V"
+ datatype="decimal" column="MTTOTALTVA"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DTEADR"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:Adresse/n:DteAdr/@V"
+ datatype="date" format="yyyy-MM-dd" column="DTEADR"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MOYENPAIEMENT"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:MoyenPaiement/@V"
+ datatype="string" column="MOYENPAIEMENT"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMEROCONTRAT"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:NumeroContrat/@V"
+ datatype="string" column="NUMEROCONTRAT"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_PRENOM"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:Prenom/@V"
+ datatype="string" column="PRENOM" table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"
+ format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_LIBBANC"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:CpteBancaire/n:LibBanc/@V"
+ datatype="string" column="LIBBANC"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMEROFACTURE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:NumeroFacture/@V"
+ datatype="string" column="NUMEROFACTURE"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMEROMARCHE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:NumeroMarche/@V"
+ datatype="string" column="NUMEROMARCHE"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NUMTVA"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:NumTVA/@V"
+ datatype="string" column="NUMTVA" table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MTTOTALHT"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:TotalAPayer/n:MtTotalHT/@V"
+ datatype="decimal" column="MTTOTALHT"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CODRES"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:Adresse/n:CodRes/@V"
+ datatype="string" column="CODRES" table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_NOM"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:Nom/@V"
+ datatype="string" column="NOM" table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"
+ format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MODALITESREGLEMENT"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:ModalitesReglement/@V"
+ datatype="string" column="MODALITESREGLEMENT"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CLERIB"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:CpteBancaire/n:CleRib/@V"
+ datatype="integer" column="CLERIB"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TYPTIERS"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:TypTiers/@V"
+ datatype="string" column="TYPTIERS"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CODEETAB"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:CpteBancaire/n:CodeEtab/@V"
+ datatype="string" column="CODEETAB"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DATEREGLEMENT"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:DateReglement/@V" datatype="date"
+ format="yyyy-MM-dd" column="DATEREGLEMENT"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CONDITIONSGEN"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:ConditionsGen/@V"
+ datatype="string" column="CONDITIONSGEN"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_VILLE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:Adresse/n:Ville/@V"
+ datatype="string" column="VILLE" table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"
+ format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CODEGUIC"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:CpteBancaire/n:CodeGuic/@V"
+ datatype="string" column="CODEGUIC"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_IDPAYINT"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:CpteBancaire/n:IdPayInt/@V"
+ datatype="string" column="IDPAYINT"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_IDTIERS"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:IdTiers/@V"
+ datatype="string" column="IDTIERS"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TYPETIERSFACTURE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:TypeTiersFacture/@V"
+ datatype="string" column="TYPETIERSFACTURE"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TYPADR"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:Adresse/n:TypAdr/@V"
+ datatype="string" column="TYPADR" table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_DTEMALADE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:DteMalade/@V"
+ datatype="date" format="yyyy-MM-dd" column="DTEMALADE"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_TAUXREMISE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:TauxRemise/@V" datatype="decimal"
+ column="TAUXREMISE" table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_CIVILITE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:Civilite/@V"
+ datatype="string" column="CIVILITE"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_IDCPTE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Debiteur/n:CpteBancaire/n:IdCpte/@V"
+ datatype="string" column="IDCPTE" table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_MTREMISE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:MtRemise/@V" datatype="decimal"
+ column="MTREMISE" table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_PES_FACTURE_PESFACTURE_FACTUREINDIV_FOURNISSEUR"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/@added:fournisseur"
+ datatype="string" column="FOURNISSEUR"
+ table="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"/>
+
+ <!-- SQL-INDEX /n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Reference -->
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_REFERENCE__NODE_ID"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Reference/@added:generated-id"
+ column="NODE_ID" datatype="string" table="PES_FACTURE_FACTUREINDIV_REFERENCE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_REFERENCE_NUMEROPIECE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Reference/n:NumeroPiece/@V"
+ datatype="string" column="NUMEROPIECE"
+ table="PES_FACTURE_FACTUREINDIV_REFERENCE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_REFERENCE_TYPEPIECE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Reference/n:TypePiece/@V"
+ datatype="string" column="TYPEPIECE"
+ table="PES_FACTURE_FACTUREINDIV_REFERENCE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_REFERENCE_NUMLIGNE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Reference/n:NumLigne/@V"
+ datatype="integer" column="NUMLIGNE"
+ table="PES_FACTURE_FACTUREINDIV_REFERENCE_IX"/>
+
+ <!-- SQL-INDEX /n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers -->
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS__NODE_ID"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/@added:generated-id"
+ column="NODE_ID" datatype="string" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_DTEBANC"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:CpteBancaire/n:DteBanc/@V"
+ datatype="date" format="yyyy-MM-dd" column="DTEBANC"
+ table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_VILLE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:Adresse/n:Ville/@V"
+ datatype="string" column="VILLE" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_TYPADR"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:Adresse/n:TypAdr/@V"
+ datatype="string" column="TYPADR" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CP"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:Adresse/n:CP/@V"
+ datatype="string" column="CP" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CATTIERS"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:CatTiers/@V"
+ datatype="string" column="CATTIERS" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_TYPETIERSFACTURE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:TypeTiersFacture/@V"
+ datatype="string" column="TYPETIERSFACTURE"
+ table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_NUMTVA"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:NumTVA/@V"
+ datatype="string" column="NUMTVA" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_IDTIERS"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:IdTiers/@V"
+ datatype="string" column="IDTIERS" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CODRES"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:Adresse/n:CodRes/@V"
+ datatype="string" column="CODRES" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CLERIB"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:CpteBancaire/n:CleRib/@V"
+ datatype="integer" column="CLERIB" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CODEGUIC"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:CpteBancaire/n:CodeGuic/@V"
+ datatype="string" column="CODEGUIC" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CODPAYS"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:Adresse/n:CodPays/@V"
+ datatype="integer" column="CODPAYS" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_PRENOM"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:Prenom/@V2"
+ datatype="string" column="PRENOM" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"
+ format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_IDPAYINT"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:CpteBancaire/n:IdPayInt/@V"
+ datatype="string" column="IDPAYINT" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_SERVICE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:Service/@V"
+ datatype="string" column="SERVICE" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_IDBANCINT"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:CpteBancaire/n:IdBancInt/@V"
+ datatype="string" column="IDBANCINT" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_TYPTIERS"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:TypTiers/@V"
+ datatype="string" column="TYPTIERS" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_REFTIERS"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:RefTiers/@V"
+ datatype="string" column="REFTIERS" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_NOM"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:Nom/@V2"
+ datatype="string" column="NOM" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"
+ format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CODEETAB"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:CpteBancaire/n:CodeEtab/@V"
+ datatype="string" column="CODEETAB" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_ADR3"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:Adresse/n:Adr3/@V"
+ datatype="string" column="ADR3" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_NATIDTIERS"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:NatIdTiers/@V"
+ datatype="string" column="NATIDTIERS" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_IDCPTE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:CpteBancaire/n:IdCpte/@V"
+ datatype="string" column="IDCPTE" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_ADR2"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:Adresse/n:Adr2/@V"
+ datatype="string" column="ADR2" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_TITCPTE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:CpteBancaire/n:TitCpte/@V"
+ datatype="string" column="TITCPTE" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_LIBBANC"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:CpteBancaire/n:LibBanc/@V"
+ datatype="string" column="LIBBANC" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_ADR1"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:Adresse/n:Adr1/@V"
+ datatype="string" column="ADR1" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_DTEIDTIERS"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:DteIdTiers/@V"
+ datatype="date" format="yyyy-MM-dd" column="DTEIDTIERS"
+ table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_NATJUR"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:NatJur/@V"
+ datatype="string" column="NATJUR" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_DTEADR"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:Adresse/n:DteAdr/@V"
+ datatype="date" format="yyyy-MM-dd" column="DTEADR"
+ table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_DTEMALADE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:DteMalade/@V"
+ datatype="date" format="yyyy-MM-dd" column="DTEMALADE"
+ table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_CIVILITE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:Civilite/@V"
+ datatype="string" column="CIVILITE" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_TIERS_COMPLNOM"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:Tiers/n:InfoTiers/n:ComplNom/@V"
+ datatype="string" column="COMPLNOM" table="PES_FACTURE_FACTUREINDIV_TIERS_IX"/>
+
+ <!-- SQL-INDEX /n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture -->
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE__NODE_ID"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/@added:generated-id"
+ column="NODE_ID" datatype="string"
+ table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_ORDRE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Ordre/@V"
+ datatype="integer" column="ORDRE"
+ table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_CODEFONCTION"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:CodeFonction/@V"
+ datatype="string" column="CODEFONCTION"
+ table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_MTTTC"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:MtTTC/@V"
+ datatype="decimal" column="MTTTC"
+ table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_TAUX"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Taux/@V"
+ datatype="decimal" column="TAUX"
+ table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_MTREMISE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:MtRemise/@V"
+ datatype="decimal" column="MTREMISE"
+ table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_MTHT"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:MtHT/@V"
+ datatype="decimal" column="MTHT"
+ table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_TAUXTVA"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:TauxTVA/@V"
+ datatype="decimal" column="TAUXTVA"
+ table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_MTTVA"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:MtTVA/@V"
+ datatype="decimal" column="MTTVA"
+ table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_ORDREEDITION"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:OrdreEdition/@V"
+ datatype="integer" column="ORDREEDITION"
+ table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_CODEPRODUIT"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:CodeProduit/@V"
+ datatype="string" column="CODEPRODUIT"
+ table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_TAUXREMISE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:TauxRemise/@V"
+ datatype="decimal" column="TAUXREMISE"
+ table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_CODENATURE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:CodeNature/@V"
+ datatype="string" column="CODENATURE"
+ table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_LIBELLE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Libelle/@V"
+ datatype="string" column="LIBELLE" format="uppercase"
+ table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_UNITE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Unite/@V"
+ datatype="string" column="UNITE"
+ table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_QUANTITE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Quantite/@V"
+ datatype="decimal" column="QUANTITE"
+ table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_MTUNITAIRE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:MtUnitaire/@V"
+ datatype="decimal" column="MTUNITAIRE"
+ table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_MTBASE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:MtBase/@V"
+ datatype="decimal" column="MTBASE"
+ table="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
+
+ <!-- SQL-INDEX /n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers -->
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS__NODE_ID"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/@added:generated-id"
+ column="NODE_ID" datatype="string" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_DTEBANC"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:CpteBancaire/n:DteBanc/@V"
+ datatype="date" format="yyyy-MM-dd" column="DTEBANC"
+ table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_VILLE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:Adresse/n:Ville/@V"
+ datatype="string" column="VILLE" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_TYPADR"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:Adresse/n:TypAdr/@V"
+ datatype="string" column="TYPADR" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_CP"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:Adresse/n:CP/@V"
+ datatype="string" column="CP" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_CATTIERS"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:CatTiers/@V"
+ datatype="string" column="CATTIERS" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_TYPETIERSFACTURE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:TypeTiersFacture/@V"
+ datatype="string" column="TYPETIERSFACTURE"
+ table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_NUMTVA"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:NumTVA/@V"
+ datatype="string" column="NUMTVA" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_IDTIERS"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:IdTiers/@V"
+ datatype="string" column="IDTIERS" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_CODRES"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:Adresse/n:CodRes/@V"
+ datatype="string" column="CODRES" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_CLERIB"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:CpteBancaire/n:CleRib/@V"
+ datatype="integer" column="CLERIB" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_CODEGUIC"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:CpteBancaire/n:CodeGuic/@V"
+ datatype="string" column="CODEGUIC" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_CODPAYS"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:Adresse/n:CodPays/@V"
+ datatype="integer" column="CODPAYS" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_PRENOM"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:Prenom/@V2"
+ datatype="string" column="PRENOM" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"
+ format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_IDPAYINT"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:CpteBancaire/n:IdPayInt/@V"
+ datatype="string" column="IDPAYINT" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_SERVICE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:Service/@V"
+ datatype="string" column="SERVICE" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_IDBANCINT"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:CpteBancaire/n:IdBancInt/@V"
+ datatype="string" column="IDBANCINT" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_TYPTIERS"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:TypTiers/@V"
+ datatype="string" column="TYPTIERS" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_REFTIERS"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:RefTiers/@V"
+ datatype="string" column="REFTIERS" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_NOM"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:Nom/@V2"
+ datatype="string" column="NOM" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"
+ format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_CODEETAB"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:CpteBancaire/n:CodeEtab/@V"
+ datatype="string" column="CODEETAB" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_ADR3"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:Adresse/n:Adr3/@V"
+ datatype="string" column="ADR3" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_NATIDTIERS"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:NatIdTiers/@V"
+ datatype="string" column="NATIDTIERS" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_IDCPTE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:CpteBancaire/n:IdCpte/@V"
+ datatype="string" column="IDCPTE" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_ADR2"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:Adresse/n:Adr2/@V"
+ datatype="string" column="ADR2" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_TITCPTE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:CpteBancaire/n:TitCpte/@V"
+ datatype="string" column="TITCPTE" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_LIBBANC"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:CpteBancaire/n:LibBanc/@V"
+ datatype="string" column="LIBBANC" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_ADR1"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:Adresse/n:Adr1/@V"
+ datatype="string" column="ADR1" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_DTEIDTIERS"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:DteIdTiers/@V"
+ datatype="date" format="yyyy-MM-dd" column="DTEIDTIERS"
+ table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_NATJUR"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:NatJur/@V"
+ datatype="string" column="NATJUR" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_DTEADR"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:Adresse/n:DteAdr/@V"
+ datatype="date" format="yyyy-MM-dd" column="DTEADR"
+ table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_DTEMALADE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:DteMalade/@V"
+ datatype="date" format="yyyy-MM-dd" column="DTEMALADE"
+ table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_CIVILITE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:Civilite/@V"
+ datatype="string" column="CIVILITE" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_TIERS_COMPLNOM"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:Tiers/n:InfoTiers/n:ComplNom/@V"
+ datatype="string" column="COMPLNOM" table="PES_FACTURE_LIGNEFACTURE_TIERS_IX"/>
+
+ <!-- SQL-INDEX /n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:reference -->
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_REFERENCE__NODE_ID"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:reference/@added:generated-id"
+ column="NODE_ID" datatype="string" table="PES_FACTURE_LIGNEFACTURE_REFERENCE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_REFERENCE_NUMEROPIECE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:reference/n:NumeroPiece/@V"
+ datatype="string" column="NUMEROPIECE"
+ table="PES_FACTURE_LIGNEFACTURE_REFERENCE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_REFERENCE_TYPEPIECE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:reference/n:TypePiece/@V"
+ datatype="string" column="TYPEPIECE"
+ table="PES_FACTURE_LIGNEFACTURE_REFERENCE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_REFERENCE_NUMLIGNE"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:LigneFacture/n:reference/n:NumLigne/@V"
+ datatype="integer" column="NUMLIGNE"
+ table="PES_FACTURE_LIGNEFACTURE_REFERENCE_IX"/>
+
+ <!-- SQL-INDEX /n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:DetailTVA -->
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_DETAILTVA__NODE_ID"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:DetailTVA/@added:generated-id"
+ column="NODE_ID" datatype="string" table="PES_FACTURE_FACTUREINDIV_DETAILTVA_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_DETAILTVA_TAUXTVA"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:DetailTVA/n:TauxTVA/@V"
+ datatype="decimal" column="TAUXTVA"
+ table="PES_FACTURE_FACTUREINDIV_DETAILTVA_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_DETAILTVA_MTTVA"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:DetailTVA/n:MtTVA/@V"
+ datatype="decimal" column="MTTVA" table="PES_FACTURE_FACTUREINDIV_DETAILTVA_IX"/>
+ <sql-index id="SQI_PES_FACTURE_FACTUREINDIV_DETAILTVA_MTBASEHT"
+ path="/n:DOC_PES_Facture/n:PESFacture/n:FactureIndiv/n:DetailTVA/n:MtBaseHT/@V"
+ datatype="decimal" column="MTBASEHT"
+ table="PES_FACTURE_FACTUREINDIV_DETAILTVA_IX"/>
+
+ <element id="PES_FACTURE_PESFACTURE_TIERS_IX">
+ <sql-count>COUNT(DISTINCT(CONCAT(PES_FACTURE_PESFACTURE_IX.DOC_ID,PES_FACTURE_PESFACTURE_TIERS_IX.NODE_ID)))</sql-count>
+ <special-cond>PES_FACTURE_PESFACTURE_TIERS_IX.NODE_ID IS NOT NULL</special-cond>
+ </element>
+ <element id="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX">
+ <sql-count>COUNT(DISTINCT(CONCAT(PES_FACTURE_PESFACTURE_IX.DOC_ID,PES_FACTURE_PESFACTURE_FACTUREINDIV_IX.NODE_ID)))</sql-count>
+ <special-cond>PES_FACTURE_PESFACTURE_FACTUREINDIV_IX.NODE_ID IS NOT
+ NULL</special-cond>
+ </element>
+ <element id="PES_FACTURE_FACTUREINDIV_REFERENCE_IX">
+ <sql-count>COUNT(DISTINCT(CONCAT(PES_FACTURE_PESFACTURE_IX.DOC_ID,PES_FACTURE_FACTUREINDIV_REFERENCE_IX.NODE_ID)))</sql-count>
+ <special-cond>PES_FACTURE_FACTUREINDIV_REFERENCE_IX.NODE_ID IS NOT
+ NULL</special-cond>
+ </element>
+ <element id="PES_FACTURE_FACTUREINDIV_TIERS_IX">
+ <sql-count>COUNT(DISTINCT(CONCAT(PES_FACTURE_PESFACTURE_IX.DOC_ID,PES_FACTURE_FACTUREINDIV_TIERS_IX.NODE_ID)))</sql-count>
+ <special-cond>PES_FACTURE_FACTUREINDIV_TIERS_IX.NODE_ID IS NOT
+ NULL</special-cond>
+ </element>
+ <element id="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX">
+ <sql-count>COUNT(DISTINCT(CONCAT(PES_FACTURE_PESFACTURE_IX.DOC_ID,PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX.NODE_ID)))</sql-count>
+ <special-cond>PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX.NODE_ID IS NOT
+ NULL</special-cond>
+ </element>
+ <element id="PES_FACTURE_LIGNEFACTURE_TIERS_IX">
+ <sql-count>COUNT(DISTINCT(CONCAT(PES_FACTURE_PESFACTURE_IX.DOC_ID,PES_FACTURE_LIGNEFACTURE_TIERS_IX.NODE_ID)))</sql-count>
+ <special-cond>PES_FACTURE_LIGNEFACTURE_TIERS_IX.NODE_ID IS NOT
+ NULL</special-cond>
+ </element>
+ <element id="PES_FACTURE_LIGNEFACTURE_REFERENCE_IX">
+ <sql-count>COUNT(DISTINCT(CONCAT(PES_FACTURE_PESFACTURE_IX.DOC_ID,PES_FACTURE_LIGNEFACTURE_REFERENCE_IX.NODE_ID)))</sql-count>
+ <special-cond>PES_FACTURE_LIGNEFACTURE_REFERENCE_IX.NODE_ID IS NOT
+ NULL</special-cond>
+ </element>
+ <element id="PES_FACTURE_FACTUREINDIV_DETAILTVA_IX">
+ <sql-count>COUNT(DISTINCT(CONCAT(PES_FACTURE_PESFACTURE_IX.DOC_ID,PES_FACTURE_FACTUREINDIV_DETAILTVA_IX.NODE_ID)))</sql-count>
+ <special-cond>PES_FACTURE_FACTUREINDIV_DETAILTVA_IX.NODE_ID IS NOT
+ NULL</special-cond>
+ </element>
+
+ </etat>
+ </document>
+ </layer>
+</persistence-config>