path="/n:PES_Aller/n:PES_DepenseAller/n:Bordereau/n:Piece/n:LigneDePiece/n:Tiers/n:InfoTiers/n:DteMalade/@V"
column="DATE_MALADE" format="yyyy-MM-dd" datatype="date"
table="lignepiece_depense"/>
+ <sql-index id="SQI_DA_55B"
+ path="/n:PES_Aller/n:PES_DepenseAller/n:Bordereau/n:Piece/n:LigneDePiece/n:Tiers/n:InfoTiers/n:DteNaissance/@V"
+ column="DATE_MALADE" format="yyyy-MM-dd" datatype="date"
+ table="lignepiece_depense"/>
<sql-index id="SQI_DA_56"
path="/n:PES_Aller/n:PES_DepenseAller/n:Bordereau/n:Piece/n:LigneDePiece/n:Tiers/n:InfoTiers/n:NatIdTiers/@V"
column="NAT_ID_TIERS" datatype="string" table="lignepiece_depense"/>
<sql-index id="SQI_RA_64"
path="/n:PES_Aller/n:PES_RecetteAller/n:Bordereau/n:Piece/n:LigneDePiece/n:Tiers/n:InfoTiers/n:DteMalade/@V"
datatype="date" column="DATE_MALADE" table="T_RA_6" format="yyyy-MM-dd"/>
+ <sql-index id="SQI_RA_64B"
+ path="/n:PES_Aller/n:PES_RecetteAller/n:Bordereau/n:Piece/n:LigneDePiece/n:Tiers/n:InfoTiers/n:DteNaissance/@V"
+ datatype="date" column="DATE_MALADE" table="T_RA_6" format="yyyy-MM-dd"/>
<sql-index id="SQI_RA_65"
path="/n:PES_Aller/n:PES_RecetteAller/n:Bordereau/n:Piece/n:LigneDePiece/n:Tiers/n:InfoTiers/n:NatIdTiers/@V"
datatype="string" column="NAT_ID_TIERS" table="T_RA_6"/>
</etat>
+ <etat id="PES_Facture" import-xslt-file="PES_V2/PES-Aller-Facture-import-mysql.xsl">
+
+ <key1>
+ <path>/n:PES_Aller/n:PES_Facture/n:FactureIndiv/@added:generated-id</path>
+ </key1>
+ <key2>
+ <path>/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture/@added:generated-id</path>
+ </key2>
+ <!--key10>
+ <path>/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture/n:Commentaire/@added:generated-id</path>
+ </key10-->
+ <key3>
+ <path>/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:DetailTVA/@added:generated-id</path>
+ </key3>
+ <key4>
+ <path>/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:RepartitionBudget/@added:generated-id</path>
+ </key4>
+ <key5>
+ <path>/n:PES_Aller/n:PES_Facture/n:Tiers/@added:generated-id</path>
+ </key5>
+ <key6>
+ <path>/n:PES_Aller/n:PES_Facture/n:Nomenclatures/n:NomenclatureProduit/n:Correspondance/@added:generated-id</path>
+ </key6>
+ <key7>
+ <path>/n:PES_Aller/n:PES_Facture/n:Nomenclatures/n:NomenclatureNature/n:Correspondance/@added:generated-id</path>
+ </key7>
+ <key8>
+ <path>/n:PES_Aller/n:PES_Facture/n:Nomenclatures/n:NomenclatureBudget/n:Correspondance/@added:generated-id</path>
+ </key8>
+ <key9>
+ <path>/n:PES_Aller/n:PES_Facture/n:RepartitionParNature/n:Repartition/@added:generated-id</path>
+ </key9>
+
+ <table type="document" base-name="PES_ALLER_FACTURE_DOCUMENTS" version="1" xml:space="preserve"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE VARCHAR(15) NOT NULL, BUDGET VARCHAR(24) NOT NULL, INITIAL_DOC_NAME VARCHAR(300) NOT NULL, DOC_ID VARCHAR(100) NOT NULL, DOC LONGBLOB, ENCODING VARCHAR(20), INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), 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_ALLER_FACTURE_IX" base-name="PES_ALLER_FACTURE_IX" version="1" main="true" xml:space="preserve"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE VARCHAR(15) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL, NODE_ID VARCHAR(50) NOT NULL, HORAIRESOUV VARCHAR(38) , VILLE VARCHAR(38) , TYPADR VARCHAR(255) , CP VARCHAR(5) , CATTIERS VARCHAR(255) , DATE DATE , NUMTVA VARCHAR(24) , IDTIERS VARCHAR(15) , ROLE VARCHAR(50) , CODRES VARCHAR(255) , CODPAYS INTEGER , ADRTIPI VARCHAR(200) , PRENOM VARCHAR(38) , PRENOMSIGN VARCHAR(38), NUMTEL VARCHAR(20) , IDVER INTEGER , NUMSEQUENCE INTEGER , TYPEFACT VARCHAR(255) , SERVICE VARCHAR(24) , ANNEE VARCHAR(255) , TYPTIERS VARCHAR(255) , NOM VARCHAR(38) ,NOMSIGN VARCHAR(38) , REFTIERS VARCHAR(30) , NATIDTIERS VARCHAR(255) , ADR3 VARCHAR(38) , ADR2 VARCHAR(38) , DTEIDTIERS DATE , ADR1 VARCHAR(38) , REFBDF VARCHAR(13) , CODETIPI INTEGER , NATJUR VARCHAR(255) , DESCRIPTION VARCHAR(100) , COMPLNOM VARCHAR(38) , CIVILITE VARCHAR(10) , RIB VARCHAR(40), INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), INDEX IX_${base-name}_DC (DOC_ID), INITIAL_DOC_NAME VARCHAR(300), 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_ALLER_FACTURE_FACTUREINDIV_IX" base-name="PES_ALLER_FACTURE_FACTUREINDIV_IX" version="1" main="false" based-on="key1" xml:space="preserve"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE VARCHAR(15) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL, NODE_ID VARCHAR(50) NOT NULL, CODPAYS INTEGER , NUMBORDEREAU VARCHAR(7) , COMPLNOM VARCHAR(38) , MTTOTALTTC DECIMAL(14,2), NUMLIGNE INTEGER , NUMTITRE VARCHAR(13) , OBJET VARCHAR(160) , DATEEMISSION DATE , DTEIDTIERS DATE , TEXTEGENERATEUR VARCHAR(160) , CP VARCHAR(5) , REFTIERS VARCHAR(30) , MODERECOUVREMENT VARCHAR(255) , ADR3 VARCHAR(38) , ADR2 VARCHAR(38) , CATTIERS VARCHAR(255) , NATJUR VARCHAR(255) , ADR1 VARCHAR(38) , NATIDTIERS VARCHAR(255) , MTTOTALTVA DECIMAL(14,2), PRENOM VARCHAR(38) , NUMEROFACTURE VARCHAR(50) , LIGNE2 VARCHAR(70) , LIGNE1 VARCHAR(70) , CODRES VARCHAR(255) , MTTOTALHT DECIMAL(14,2), NOM VARCHAR(38) , MODALITESREGLEMENT VARCHAR(250) , TYPTIERS VARCHAR(255) , DATEREGLEMENT DATE , CONDITIONSGEN VARCHAR(250) , EXERCICE VARCHAR(255) , VILLE VARCHAR(38) , IDTIERS VARCHAR(15) , TYPADR VARCHAR(255) , CIVILITE VARCHAR(10) , RIB VARCHAR(40), INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), INDEX IX_${base-name}_DC (DOC_ID), INITIAL_DOC_NAME VARCHAR(300), 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_ALLER_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX" base-name="PES_ALLER_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX" version="1" main="false" based-on="key2" xml:space="preserve"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE VARCHAR(15) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL, NODE_ID VARCHAR(50) NOT NULL, ORDRE VARCHAR(3) , MTTTC DECIMAL(14,2), TAUX DECIMAL(5,2), MTHT DECIMAL(14,2), TAUXTVA DECIMAL(5,2), MTTVA DECIMAL(14,2), ORDREEDITION INTEGER , CODEPRODUIT VARCHAR(24) , CODENATURE VARCHAR(24) , LIBELLE VARCHAR(200) , UNITE VARCHAR(38) , INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), INDEX IX_${base-name}_DC (DOC_ID), INITIAL_DOC_NAME VARCHAR(300), 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_ALLER_FACTURE_LIGNEFACTURE_COMMENTAIRE_IX" base-name="PES_ALLER_FACTURE_LIGNEFACTURE_COMMENTAIRE_IX" version="1" main="false" based-on="key10" xml:space="preserve"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE VARCHAR(15) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL, NODE_ID VARCHAR(50) NOT NULL, COMMENTAIRE VARCHAR(100) , INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), INDEX IX_${base-name}_DC (DOC_ID), INITIAL_DOC_NAME VARCHAR(300), 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_ALLER_FACTURE_FACTUREINDIV_DETAILTVA_IX" base-name="PES_ALLER_FACTURE_FACTUREINDIV_DETAILTVA_IX" version="1" main="false" based-on="key3" xml:space="preserve"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE VARCHAR(15) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL, NODE_ID VARCHAR(50) NOT NULL, TAUXTVA DECIMAL(5,2), MTTVA DECIMAL(14,2), MTBASEHT DECIMAL(14,2), INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), INDEX IX_${base-name}_DC (DOC_ID), INITIAL_DOC_NAME VARCHAR(300), 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_ALLER_FACTURE_FACTUREINDIV_REPARTITIONBUDGET_IX" base-name="PES_ALLER_FACTURE_FACTUREINDIV_REPARTITIONBUDGET_IX" version="1" main="false" based-on="key4" xml:space="preserve"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE VARCHAR(15) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL, NODE_ID VARCHAR(50) NOT NULL, CODEBUDGET VARCHAR(24) , INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), INDEX IX_${base-name}_DC (DOC_ID), INITIAL_DOC_NAME VARCHAR(300), 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_ALLER_FACTURE_TIERS_IX" base-name="PES_ALLER_FACTURE_TIERS_IX" version="1" main="false" based-on="key5" xml:space="preserve"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE VARCHAR(15) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL, NODE_ID VARCHAR(50) NOT NULL, VILLE VARCHAR(38) , TYPADR VARCHAR(255) , CP VARCHAR(5) , CATTIERS VARCHAR(255) , IDTIERS VARCHAR(15) , CODRES VARCHAR(255) , CODPAYS INTEGER , PRENOM VARCHAR(38) , TYPTIERS VARCHAR(255) , REFTIERS VARCHAR(30) , NOM VARCHAR(38) , ADR3 VARCHAR(38) , NATIDTIERS VARCHAR(255) , ADR2 VARCHAR(38) , ADR1 VARCHAR(38) , DTEIDTIERS DATE , NATJUR VARCHAR(255) , CIVILITE VARCHAR(10) , COMPLNOM VARCHAR(38) , RIB VARCHAR(40), INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), INDEX IX_${base-name}_DC (DOC_ID), INITIAL_DOC_NAME VARCHAR(300), 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_ALLER_FACTURE_NOMENCLATUREPRODUIT_IX" base-name="PES_ALLER_FACTURE_NOMENCLATUREPRODUIT_IX" version="1" main="false" based-on="key6" xml:space="preserve"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE VARCHAR(15) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL, NODE_ID VARCHAR(50) NOT NULL, LIBELLE VARCHAR(100) , CODE VARCHAR(24) , INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), INDEX IX_${base-name}_DC (DOC_ID), INITIAL_DOC_NAME VARCHAR(300), 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_ALLER_FACTURE_NOMENCLATURENATURE_IX" base-name="PES_ALLER_FACTURE_NOMENCLATURENATURE_IX" version="1" main="false" based-on="key7" xml:space="preserve"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE VARCHAR(15) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL, NODE_ID VARCHAR(50) NOT NULL, LIBELLE VARCHAR(100) , CODE VARCHAR(24) , INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), INDEX IX_${base-name}_DC (DOC_ID), INITIAL_DOC_NAME VARCHAR(300), 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_ALLER_FACTURE_NOMENCLATUREBUDGET_IX" base-name="PES_ALLER_FACTURE_NOMENCLATUREBUDGET_IX" version="1" main="false" based-on="key8" xml:space="preserve"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE VARCHAR(15) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL, NODE_ID VARCHAR(50) NOT NULL, LIBELLE VARCHAR(100) , CODE VARCHAR(24) , INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), INDEX IX_${base-name}_DC (DOC_ID), INITIAL_DOC_NAME VARCHAR(300), 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_ALLER_FACTURE_REPARTITIONPARNATURE_REPARTITION_IX" base-name="PES_ALLER_FACTURE_REPARTITIONPARNATURE_REPARTITION_IX" version="1" main="false" based-on="key9" xml:space="preserve"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE VARCHAR(15) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL, NODE_ID VARCHAR(50) NOT NULL, LIBELLE VARCHAR(100) , CODE VARCHAR(24) , MT DECIMAL(14,2), CODEFONCTION VARCHAR(24) , CODEBUDGET VARCHAR(24) , INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), INDEX IX_${base-name}_DC (DOC_ID), INITIAL_DOC_NAME VARCHAR(300), INDEX ${base-name}_IDN (INITIAL_DOC_NAME), ARCHIVE_NAME VARCHAR(100), INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM </table>
+
+
+ <!-- CRITERIA /n:PES_Aller/n:PES_Facture -->
+ <criteria id="CRI_PES_FACTURE_HORAIRESOUV" type="1" sql-index-id="SQI_PES_FACTURE_HORAIRESOUV">
+ <where-clause>fn:string-compare(${table}.${column},HorairesOuv)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_VILLE" type="1" sql-index-id="SQI_PES_FACTURE_VILLE">
+ <where-clause>fn:string-compare(${table}.${column},Ville)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_TYPADR" type="1" sql-index-id="SQI_PES_FACTURE_TYPADR">
+ <where-clause>fn:string-compare(${table}.${column},TypAdr)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_CP" type="1" sql-index-id="SQI_PES_FACTURE_CP">
+ <where-clause>fn:string-compare(${table}.${column},Cp)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_CATTIERS" type="1" sql-index-id="SQI_PES_FACTURE_CATTIERS">
+ <where-clause>fn:string-compare(${table}.${column},CatTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_DATE" type="1" sql-index-id="SQI_PES_FACTURE_DATE">
+ <where-clause>fn:date-compare(${table}.${column},Date)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_NUMTVA" type="1" sql-index-id="SQI_PES_FACTURE_NUMTVA">
+ <where-clause>fn:string-compare(${table}.${column},NumTVA)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_IDTIERS" type="1" sql-index-id="SQI_PES_FACTURE_IDTIERS">
+ <where-clause>fn:string-compare(${table}.${column},IdTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_ROLE" type="1" sql-index-id="SQI_PES_FACTURE_ROLE">
+ <where-clause>fn:string-compare(${table}.${column},Role)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_CODRES" type="1" sql-index-id="SQI_PES_FACTURE_CODRES">
+ <where-clause>fn:string-compare(${table}.${column},CodRes)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_CODPAYS" type="1" sql-index-id="SQI_PES_FACTURE_CODPAYS">
+ <where-clause>${table}.${column}##OPERATEUR:CodPays####VALEUR:CodPays##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_ADRTIPI" type="1" sql-index-id="SQI_PES_FACTURE_ADRTIPI">
+ <where-clause>fn:string-compare(${table}.${column},AdrTipi)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PRENOM" type="1" sql-index-id="SQI_PES_FACTURE_PRENOM">
+ <where-clause>fn:string-compare(${table}.${column},Prenom)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_NUMTEL" type="1" sql-index-id="SQI_PES_FACTURE_NUMTEL">
+ <where-clause>fn:string-compare(${table}.${column},NumTel)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_IDVER" type="1" sql-index-id="SQI_PES_FACTURE_IDVER">
+ <where-clause>${table}.${column}##OPERATEUR:IdVer####VALEUR:IdVer##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_NUMSEQUENCE" type="1" sql-index-id="SQI_PES_FACTURE_NUMSEQUENCE">
+ <where-clause>${table}.${column}##OPERATEUR:NumSequence####VALEUR:NumSequence##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_TYPEFACT" type="1" sql-index-id="SQI_PES_FACTURE_TYPEFACT">
+ <where-clause>fn:string-compare(${table}.${column},TypeFact)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_SERVICE" type="1" sql-index-id="SQI_PES_FACTURE_SERVICE">
+ <where-clause>fn:string-compare(${table}.${column},Service)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_ANNEE" type="1" sql-index-id="SQI_PES_FACTURE_ANNEE">
+ <where-clause>fn:string-compare(${table}.${column},Annee)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_TYPTIERS" type="1" sql-index-id="SQI_PES_FACTURE_TYPTIERS">
+ <where-clause>fn:string-compare(${table}.${column},TypTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_NOM" type="1" sql-index-id="SQI_PES_FACTURE_NOM">
+ <where-clause>fn:string-compare(${table}.${column},Nom)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_REFTIERS" type="1" sql-index-id="SQI_PES_FACTURE_REFTIERS">
+ <where-clause>fn:string-compare(${table}.${column},RefTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_NATIDTIERS" type="1" sql-index-id="SQI_PES_FACTURE_NATIDTIERS">
+ <where-clause>fn:string-compare(${table}.${column},NatIdTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_ADR3" type="1" sql-index-id="SQI_PES_FACTURE_ADR3">
+ <where-clause>fn:string-compare(${table}.${column},Adr3)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_ADR2" type="1" sql-index-id="SQI_PES_FACTURE_ADR2">
+ <where-clause>fn:string-compare(${table}.${column},Adr2)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_DTEIDTIERS" type="1" sql-index-id="SQI_PES_FACTURE_DTEIDTIERS">
+ <where-clause>fn:date-compare(${table}.${column},DteIdTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_ADR1" type="1" sql-index-id="SQI_PES_FACTURE_ADR1">
+ <where-clause>fn:string-compare(${table}.${column},Adr1)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_REFBDF" type="1" sql-index-id="SQI_PES_FACTURE_REFBDF">
+ <where-clause>fn:string-compare(${table}.${column},RefBdf)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_CODETIPI" type="1" sql-index-id="SQI_PES_FACTURE_CODETIPI">
+ <where-clause>${table}.${column}##OPERATEUR:CodeTipi####VALEUR:CodeTipi##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_NATJUR" type="1" sql-index-id="SQI_PES_FACTURE_NATJUR">
+ <where-clause>fn:string-compare(${table}.${column},NatJur)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_DESCRIPTION" type="1" sql-index-id="SQI_PES_FACTURE_DESCRIPTION">
+ <where-clause>fn:string-compare(${table}.${column},Description)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_COMPLNOM" type="1" sql-index-id="SQI_PES_FACTURE_COMPLNOM">
+ <where-clause>fn:string-compare(${table}.${column},ComplNom)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_CIVILITE" type="1" sql-index-id="SQI_PES_FACTURE_CIVILITE">
+ <where-clause>fn:string-compare(${table}.${column},Civilite)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_RIB" type="1" sql-index-id="SQI_PES_FACTURE_RIB">
+ <where-clause>fn:string-compare(${table}.${column},rib)</where-clause>
+ </criteria>
+
+ <!-- CRITERIA /n:PES_Aller/n:PES_Facture/n:Tiers -->
+ <criteria id="CRI_TIERS_VILLE" type="1" sql-index-id="SQI_TIERS_VILLE">
+ <where-clause>fn:string-compare(${table}.${column},Ville)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_TYPADR" type="1" sql-index-id="SQI_TIERS_TYPADR">
+ <where-clause>fn:string-compare(${table}.${column},TypAdr)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_CP" type="1" sql-index-id="SQI_TIERS_CP">
+ <where-clause>fn:string-compare(${table}.${column},Cp)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_CATTIERS" type="1" sql-index-id="SQI_TIERS_CATTIERS">
+ <where-clause>fn:string-compare(${table}.${column},CatTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_IDTIERS" type="1" sql-index-id="SQI_TIERS_IDTIERS">
+ <where-clause>fn:string-compare(${table}.${column},IdTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_CODRES" type="1" sql-index-id="SQI_TIERS_CODRES">
+ <where-clause>fn:string-compare(${table}.${column},CodRes)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_CODPAYS" type="1" sql-index-id="SQI_TIERS_CODPAYS">
+ <where-clause>${table}.${column}##OPERATEUR:CodPays####VALEUR:CodPays##</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_PRENOM" type="1" sql-index-id="SQI_TIERS_PRENOM">
+ <where-clause>fn:string-compare(${table}.${column},Prenom)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_TYPTIERS" type="1" sql-index-id="SQI_TIERS_TYPTIERS">
+ <where-clause>fn:string-compare(${table}.${column},TypTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_REFTIERS" type="1" sql-index-id="SQI_TIERS_REFTIERS">
+ <where-clause>fn:string-compare(${table}.${column},RefTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_NOM" type="1" sql-index-id="SQI_TIERS_NOM">
+ <where-clause>fn:string-compare(${table}.${column},Nom)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_ADR3" type="1" sql-index-id="SQI_TIERS_ADR3">
+ <where-clause>fn:string-compare(${table}.${column},Adr3)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_NATIDTIERS" type="1" sql-index-id="SQI_TIERS_NATIDTIERS">
+ <where-clause>fn:string-compare(${table}.${column},NatIdTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_ADR2" type="1" sql-index-id="SQI_TIERS_ADR2">
+ <where-clause>fn:string-compare(${table}.${column},Adr2)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_ADR1" type="1" sql-index-id="SQI_TIERS_ADR1">
+ <where-clause>fn:string-compare(${table}.${column},Adr1)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_DTEIDTIERS" type="1" sql-index-id="SQI_TIERS_DTEIDTIERS">
+ <where-clause>fn:date-compare(${table}.${column},DteIdTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_NATJUR" type="1" sql-index-id="SQI_TIERS_NATJUR">
+ <where-clause>fn:string-compare(${table}.${column},NatJur)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_CIVILITE" type="1" sql-index-id="SQI_TIERS_CIVILITE">
+ <where-clause>fn:string-compare(${table}.${column},Civilite)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_COMPLNOM" type="1" sql-index-id="SQI_TIERS_COMPLNOM">
+ <where-clause>fn:string-compare(${table}.${column},ComplNom)</where-clause>
+ </criteria>
+
+ <!-- CRITERIA /n:PES_Aller/n:PES_Facture/n:FactureIndiv -->
+ <criteria id="CRI_FACTUREINDIV_CODPAYS" type="1" sql-index-id="SQI_FACTUREINDIV_CODPAYS">
+ <where-clause>${table}.${column}##OPERATEUR:CodPays####VALEUR:CodPays##</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_NUMBORDEREAU" type="1" sql-index-id="SQI_FACTUREINDIV_NUMBORDEREAU">
+ <where-clause>fn:string-compare(${table}.${column},NumBordereau)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_COMPLNOM" type="1" sql-index-id="SQI_FACTUREINDIV_COMPLNOM">
+ <where-clause>fn:string-compare(${table}.${column},ComplNom)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_MTTOTALTTC" type="1" sql-index-id="SQI_FACTUREINDIV_MTTOTALTTC">
+ <where-clause>${table}.${column}##OPERATEUR:MtTotalTTC####VALEUR:MtTotalTTC##</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_NUMLIGNE" type="1" sql-index-id="SQI_FACTUREINDIV_NUMLIGNE">
+ <where-clause>${table}.${column}##OPERATEUR:NumLigne####VALEUR:NumLigne##</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_NUMTITRE" type="1" sql-index-id="SQI_FACTUREINDIV_NUMTITRE">
+ <where-clause>fn:string-compare(${table}.${column},NumTitre)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_OBJET" type="1" sql-index-id="SQI_FACTUREINDIV_OBJET">
+ <where-clause>fn:string-compare(${table}.${column},Objet)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_DATEEMISSION" type="1" sql-index-id="SQI_FACTUREINDIV_DATEEMISSION">
+ <where-clause>fn:date-compare(${table}.${column},DateEmission)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_DTEIDTIERS" type="1" sql-index-id="SQI_FACTUREINDIV_DTEIDTIERS">
+ <where-clause>fn:date-compare(${table}.${column},DteIdTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_TEXTEGENERATEUR" type="1" sql-index-id="SQI_FACTUREINDIV_TEXTEGENERATEUR">
+ <where-clause>fn:string-compare(${table}.${column},TexteGenerateur)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_CP" type="1" sql-index-id="SQI_FACTUREINDIV_CP">
+ <where-clause>fn:string-compare(${table}.${column},CP)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_REFTIERS" type="1" sql-index-id="SQI_FACTUREINDIV_REFTIERS">
+ <where-clause>fn:string-compare(${table}.${column},RefTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_MODERECOUVREMENT" type="1" sql-index-id="SQI_FACTUREINDIV_MODERECOUVREMENT">
+ <where-clause>fn:string-compare(${table}.${column},ModeRecouvrement)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_ADR3" type="1" sql-index-id="SQI_FACTUREINDIV_ADR3">
+ <where-clause>fn:string-compare(${table}.${column},Adr3)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_ADR2" type="1" sql-index-id="SQI_FACTUREINDIV_ADR2">
+ <where-clause>fn:string-compare(${table}.${column},Adr2)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_CATTIERS" type="1" sql-index-id="SQI_FACTUREINDIV_CATTIERS">
+ <where-clause>fn:string-compare(${table}.${column},CatTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_NATJUR" type="1" sql-index-id="SQI_FACTUREINDIV_NATJUR">
+ <where-clause>fn:string-compare(${table}.${column},NatJur)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_ADR1" type="1" sql-index-id="SQI_FACTUREINDIV_ADR1">
+ <where-clause>fn:string-compare(${table}.${column},Adr1)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_NATIDTIERS" type="1" sql-index-id="SQI_FACTUREINDIV_NATIDTIERS">
+ <where-clause>fn:string-compare(${table}.${column},NatIdTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_MTTOTALTVA" type="1" sql-index-id="SQI_FACTUREINDIV_MTTOTALTVA">
+ <where-clause>${table}.${column}##OPERATEUR:MtTotalTVA####VALEUR:MtTotalTVA##</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_PRENOM" type="1" sql-index-id="SQI_FACTUREINDIV_PRENOM">
+ <where-clause>fn:string-compare(${table}.${column},Prenom)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_NUMEROFACTURE" type="1" sql-index-id="SQI_FACTUREINDIV_NUMEROFACTURE">
+ <where-clause>fn:string-compare(${table}.${column},NumeroFacture)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_LIGNE2" type="1" sql-index-id="SQI_FACTUREINDIV_LIGNE2">
+ <where-clause>fn:string-compare(${table}.${column},Ligne2)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_LIGNE1" type="1" sql-index-id="SQI_FACTUREINDIV_LIGNE1">
+ <where-clause>fn:string-compare(${table}.${column},Ligne1)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_CODRES" type="1" sql-index-id="SQI_FACTUREINDIV_CODRES">
+ <where-clause>fn:string-compare(${table}.${column},CodRes)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_MTTOTALHT" type="1" sql-index-id="SQI_FACTUREINDIV_MTTOTALHT">
+ <where-clause>${table}.${column}##OPERATEUR:MtTotalHT####VALEUR:MtTotalHT##</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_NOM" type="1" sql-index-id="SQI_FACTUREINDIV_NOM">
+ <where-clause>fn:string-compare(${table}.${column},Nom)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_MODALITESREGLEMENT" type="1" sql-index-id="SQI_FACTUREINDIV_MODALITESREGLEMENT">
+ <where-clause>fn:string-compare(${table}.${column},ModalitesReglement)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_TYPTIERS" type="1" sql-index-id="SQI_FACTUREINDIV_TYPTIERS">
+ <where-clause>fn:string-compare(${table}.${column},TypTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_DATEREGLEMENT" type="1" sql-index-id="SQI_FACTUREINDIV_DATEREGLEMENT">
+ <where-clause>fn:date-compare(${table}.${column},DateReglement)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_CONDITIONSGEN" type="1" sql-index-id="SQI_FACTUREINDIV_CONDITIONSGEN">
+ <where-clause>fn:string-compare(${table}.${column},ConditionsGen)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_EXERCICE" type="1" sql-index-id="SQI_FACTUREINDIV_EXERCICE">
+ <where-clause>fn:string-compare(${table}.${column},Exercice)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_VILLE" type="1" sql-index-id="SQI_FACTUREINDIV_VILLE">
+ <where-clause>fn:string-compare(${table}.${column},Ville)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_IDTIERS" type="1" sql-index-id="SQI_FACTUREINDIV_IDTIERS">
+ <where-clause>fn:string-compare(${table}.${column},IdTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_TYPADR" type="1" sql-index-id="SQI_FACTUREINDIV_TYPADR">
+ <where-clause>fn:string-compare(${table}.${column},TypAdr)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_CIVILITE" type="1" sql-index-id="SQI_FACTUREINDIV_CIVILITE">
+ <where-clause>fn:string-compare(${table}.${column},Civilite)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_RIB" type="1" sql-index-id="SQI_FACTUREINDIV_RIB">
+ <where-clause>fn:string-compare(${table}.${column},rib)</where-clause>
+ </criteria>
+
+ <!-- CRITERIA /n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture -->
+ <criteria id="CRI_FACTUREINDIV_LIGNEFACTURE_ORDRE" type="1" sql-index-id="SQI_FACTUREINDIV_LIGNEFACTURE_ORDRE">
+ <where-clause>fn:string-compare(${table}.${column},Ordre)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_LIGNEFACTURE_MTTTC" type="1" sql-index-id="SQI_FACTUREINDIV_LIGNEFACTURE_MTTTC">
+ <where-clause>${table}.${column}##OPERATEUR:MtTTC####VALEUR:MtTTC##</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_LIGNEFACTURE_TAUX" type="1" sql-index-id="SQI_FACTUREINDIV_LIGNEFACTURE_TAUX">
+ <where-clause>${table}.${column}##OPERATEUR:Taux####VALEUR:Taux##</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_LIGNEFACTURE_MTHT" type="1" sql-index-id="SQI_FACTUREINDIV_LIGNEFACTURE_MTHT">
+ <where-clause>${table}.${column}##OPERATEUR:MtHT####VALEUR:MtHT##</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_LIGNEFACTURE_TAUXTVA" type="1" sql-index-id="SQI_FACTUREINDIV_LIGNEFACTURE_TAUXTVA">
+ <where-clause>${table}.${column}##OPERATEUR:TauxTVA####VALEUR:TauxTVA##</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_LIGNEFACTURE_MTTVA" type="1" sql-index-id="SQI_FACTUREINDIV_LIGNEFACTURE_MTTVA">
+ <where-clause>${table}.${column}##OPERATEUR:MtTVA####VALEUR:MtTVA##</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_LIGNEFACTURE_ORDREEDITION" type="1" sql-index-id="SQI_FACTUREINDIV_LIGNEFACTURE_ORDREEDITION">
+ <where-clause>${table}.${column}##OPERATEUR:OrdreEdition####VALEUR:OrdreEdition##</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_LIGNEFACTURE_CODEPRODUIT" type="1" sql-index-id="SQI_FACTUREINDIV_LIGNEFACTURE_CODEPRODUIT">
+ <where-clause>${table}.${column}="##VALEUR:CodeProduit##"</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_LIGNEFACTURE_CODENATURE" type="1" sql-index-id="SQI_FACTUREINDIV_LIGNEFACTURE_CODENATURE">
+ <where-clause>fn:string-compare(${table}.${column},CodeNature)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_LIGNEFACTURE_LIBELLE" type="1" sql-index-id="SQI_FACTUREINDIV_LIGNEFACTURE_LIBELLE">
+ <where-clause>fn:string-compare(${table}.${column},Libelle)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_LIGNEFACTURE_UNITE" type="1" sql-index-id="SQI_FACTUREINDIV_LIGNEFACTURE_UNITE">
+ <where-clause>fn:string-compare(${table}.${column},Unite)</where-clause>
+ </criteria>
+
+ <!-- CRITERIA /n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture/n:Commentaire -->
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_COMMENTAIRE_V" type="1" sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_COMMENTAIRE_V">
+ <where-clause>fn:string-compare(${table}.${column},V)</where-clause>
+ </criteria>
+
+ <!-- CRITERIA /n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:DetailTVA -->
+ <criteria id="CRI_FACTUREINDIV_DETAILTVA_TAUXTVA" type="1" sql-index-id="SQI_FACTUREINDIV_DETAILTVA_TAUXTVA">
+ <where-clause>${table}.${column}##OPERATEUR:TauxTVA####VALEUR:TauxTVA##</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_DETAILTVA_MTTVA" type="1" sql-index-id="SQI_FACTUREINDIV_DETAILTVA_MTTVA">
+ <where-clause>${table}.${column}##OPERATEUR:MtTVA####VALEUR:MtTVA##</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_DETAILTVA_MTBASEHT" type="1" sql-index-id="SQI_FACTUREINDIV_DETAILTVA_MTBASEHT">
+ <where-clause>${table}.${column}##OPERATEUR:MtBaseHT####VALEUR:MtBaseHT##</where-clause>
+ </criteria>
+
+ <!-- CRITERIA /n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:RepartitionBudget -->
+ <criteria id="CRI_FACTUREINDIV_REPARTITIONBUDGET_CODEBUDGET" type="1" sql-index-id="SQI_FACTUREINDIV_REPARTITIONBUDGET_CODEBUDGET">
+ <where-clause>fn:string-compare(${table}.${column},CodeBudget)</where-clause>
+ </criteria>
+
+ <!-- CRITERIA /n:PES_Aller/n:PES_Facture/n:Nomenclatures/n:NomenclatureProduit/n:Correspondance -->
+ <criteria id="CRI_PES_FACTURE_CORRESPONDANCE_LIBELLE" type="1" sql-index-id="SQI_PES_FACTURE_CORRESPONDANCE_LIBELLE">
+ <where-clause>fn:string-compare(${table}.${column},Libelle)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_CORRESPONDANCE_CODE" type="1" sql-index-id="SQI_PES_FACTURE_CORRESPONDANCE_CODE">
+ <where-clause>fn:string-compare(${table}.${column},Code)</where-clause>
+ </criteria>
+
+ <!-- CRITERIA /n:PES_Aller/n:PES_Facture/n:Nomenclatures/n:NomenclatureNature/n:Correspondance -->
+ <criteria id="CRI_PES_FACTURE_CORRESPONDANCE_LIBELLE" type="1" sql-index-id="SQI_PES_FACTURE_CORRESPONDANCE_LIBELLE">
+ <where-clause>fn:string-compare(${table}.${column},Libelle)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_CORRESPONDANCE_CODE" type="1" sql-index-id="SQI_PES_FACTURE_CORRESPONDANCE_CODE">
+ <where-clause>fn:string-compare(${table}.${column},Code)</where-clause>
+ </criteria>
+
+ <!-- CRITERIA /n:PES_Aller/n:PES_Facture/n:Nomenclatures/n:NomenclatureBudget/n:Correspondance -->
+ <criteria id="CRI_PES_FACTURE_CORRESPONDANCE_LIBELLE" type="1" sql-index-id="SQI_PES_FACTURE_CORRESPONDANCE_LIBELLE">
+ <where-clause>fn:string-compare(${table}.${column},Libelle)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_CORRESPONDANCE_CODE" type="1" sql-index-id="SQI_PES_FACTURE_CORRESPONDANCE_CODE">
+ <where-clause>fn:string-compare(${table}.${column},Code)</where-clause>
+ </criteria>
+
+ <!-- CRITERIA /n:PES_Aller/n:PES_Facture/n:RepartitionParNature/n:Repartition -->
+ <criteria id="CRI_PES_FACTURE_REPARTITION_LIBELLE" type="1" sql-index-id="SQI_PES_FACTURE_REPARTITION_LIBELLE">
+ <where-clause>fn:string-compare(${table}.${column},Libelle)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_REPARTITION_CODE" type="1" sql-index-id="SQI_PES_FACTURE_REPARTITION_CODE">
+ <where-clause>fn:string-compare(${table}.${column},Code)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_REPARTITION_MT" type="1" sql-index-id="SQI_PES_FACTURE_REPARTITION_MT">
+ <where-clause>${table}.${column}##OPERATEUR:Mt####VALEUR:Mt##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_REPARTITION_CODEFONCTION" type="1" sql-index-id="SQI_PES_FACTURE_REPARTITION_CODEFONCTION">
+ <where-clause>fn:string-compare(${table}.${column},CodeFonction)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_REPARTITION_CODEBUDGET" type="1" sql-index-id="SQI_PES_FACTURE_REPARTITION_CODEBUDGET">
+ <where-clause>fn:string-compare(${table}.${column},CodeBudget)</where-clause>
+ </criteria>
+
+
+ <!-- SQL-INDEX /n:PES_Aller/n:PES_Facture -->
+ <sql-index id="SQI_PES_FACTURE__NODE_ID" path="/n:PES_Aller/n:PES_Facture/@added:generated-id" column="NODE_ID" datatype="string" table="PES_ALLER_FACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_HORAIRESOUV" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoSuppl/n:HorairesOuv/@V" datatype="string" column="HORAIRESOUV" table="PES_ALLER_FACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_VILLE" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:Adresse/n:Ville/@V" datatype="string" column="VILLE" table="PES_ALLER_FACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_TYPADR" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:Adresse/n:TypAdr/@V" datatype="string" column="TYPADR" table="PES_ALLER_FACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_CP" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:Adresse/n:CP/@V" datatype="string" column="CP" table="PES_ALLER_FACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_CATTIERS" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoTiers/n:CatTiers/@V" datatype="string" column="CATTIERS" table="PES_ALLER_FACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_DATE" path="/n:PES_Aller/n:PES_Facture/n:Date/@V" datatype="date" column="DATE" table="PES_ALLER_FACTURE_IX" format="yyyy-MM-dd"/>
+ <sql-index id="SQI_PES_FACTURE_NUMTVA" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoTVAEmetteur/n:NumTVA/@V" datatype="string" column="NUMTVA" table="PES_ALLER_FACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_IDTIERS" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoTiers/n:IdTiers/@V" datatype="string" column="IDTIERS" table="PES_ALLER_FACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_ROLE" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:Signataire/n:Role/@V" datatype="string" column="ROLE" table="PES_ALLER_FACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_CODRES" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:Adresse/n:CodRes/@V" datatype="string" column="CODRES" table="PES_ALLER_FACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_CODPAYS" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:Adresse/n:CodPays/@V" datatype="integer" column="CODPAYS" table="PES_ALLER_FACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_ADRTIPI" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoSuppl/n:AdrTipi/@V" datatype="string" column="ADRTIPI" table="PES_ALLER_FACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_PRENOMSIGN" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:Signataire/n:Personne/n:Prenom/@V" datatype="string" column="PRENOMSIGN" table="PES_ALLER_FACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_NUMTEL" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoSuppl/n:NumTel/@V" datatype="string" column="NUMTEL" table="PES_ALLER_FACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_IDVER" path="/n:PES_Aller/n:PES_Facture/n:IdVer/@V" datatype="integer" column="IDVER" table="PES_ALLER_FACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_NUMSEQUENCE" path="/n:PES_Aller/n:PES_Facture/n:NumSequence/@V" datatype="integer" column="NUMSEQUENCE" table="PES_ALLER_FACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_TYPEFACT" path="/n:PES_Aller/n:PES_Facture/n:TypeFact/@V" datatype="string" column="TYPEFACT" table="PES_ALLER_FACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_SERVICE" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoTVAEmetteur/n:Service/@V" datatype="string" column="SERVICE" table="PES_ALLER_FACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_ANNEE" path="/n:PES_Aller/n:PES_Facture/n:Annee/@V" datatype="string" column="ANNEE" table="PES_ALLER_FACTURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_TYPTIERS" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoTiers/n:TypTiers/@V" datatype="string" column="TYPTIERS" table="PES_ALLER_FACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_NOMSIGN" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:Signataire/n:Personne/n:Nom/@V" datatype="string" column="NOMSIGN" table="PES_ALLER_FACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_REFTIERS" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoTiers/n:RefTiers/@V" datatype="string" column="REFTIERS" table="PES_ALLER_FACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_NATIDTIERS" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoTiers/n:NatIdTiers/@V" datatype="string" column="NATIDTIERS" table="PES_ALLER_FACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_ADR3" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:Adresse/n:Adr3/@V" datatype="string" column="ADR3" table="PES_ALLER_FACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_ADR2" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:Adresse/n:Adr2/@V" datatype="string" column="ADR2" table="PES_ALLER_FACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_DTEIDTIERS" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoTiers/n:DteIdTiers/@V" datatype="date" column="DTEIDTIERS" table="PES_ALLER_FACTURE_IX" format="yyyy-MM-dd"/>
+ <sql-index id="SQI_PES_FACTURE_ADR1" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:Adresse/n:Adr1/@V" datatype="string" column="ADR1" table="PES_ALLER_FACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_REFBDF" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoSuppl/n:RefBdf/@V" datatype="string" column="REFBDF" table="PES_ALLER_FACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_CODETIPI" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoSuppl/n:CodeTipi/@V" datatype="integer" column="CODETIPI" table="PES_ALLER_FACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_NATJUR" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoTiers/n:NatJur/@V" datatype="string" column="NATJUR" table="PES_ALLER_FACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_DESCRIPTION" path="/n:PES_Aller/n:PES_Facture/n:Nomenclatures/n:NomenclatureBudget/n:Description/@V" datatype="string" column="DESCRIPTION" table="PES_ALLER_FACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_COMPLNOM" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoTiers/n:ComplNom/@V" datatype="string" column="COMPLNOM" table="PES_ALLER_FACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_CIVILITE" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoTiers/n:Civilite/@V" datatype="string" column="CIVILITE" table="PES_ALLER_FACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_NOM" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoTiers/n:Nom/@V" datatype="string" column="NOM" table="PES_ALLER_FACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_PRENOM" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoTiers/n:Prenom/@V" datatype="string" column="PRENOM" table="PES_ALLER_FACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_RIB" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:CptBancaire/@rib" datatype="string" column="RIB" table="PES_ALLER_FACTURE_IX" format="uppercase"/>
+
+ <!-- SQL-INDEX /n:PES_Aller/n:PES_Facture/n:Tiers -->
+ <sql-index id="SQI_TIERS__NODE_ID" path="/n:PES_Aller/n:PES_Facture/n:Tiers/@added:generated-id" column="NODE_ID" datatype="string" table="PES_ALLER_FACTURE_TIERS_IX"/>
+ <sql-index id="SQI_TIERS_CATTIERS" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:InfoTiers/n:CatTiers/@V" datatype="string" column="CATTIERS" table="PES_ALLER_FACTURE_TIERS_IX" format="uppercase"/>
+ <sql-index id="SQI_TIERS_IDTIERS" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:InfoTiers/n:IdTiers/@V" datatype="string" column="IDTIERS" table="PES_ALLER_FACTURE_TIERS_IX" format="uppercase"/>
+ <sql-index id="SQI_TIERS_PRENOM" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:InfoTiers/n:Prenom/@V" datatype="string" column="PRENOM" table="PES_ALLER_FACTURE_TIERS_IX" format="uppercase"/>
+ <sql-index id="SQI_TIERS_TYPTIERS" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:InfoTiers/n:TypTiers/@V" datatype="string" column="TYPTIERS" table="PES_ALLER_FACTURE_TIERS_IX" format="uppercase"/>
+ <sql-index id="SQI_TIERS_REFTIERS" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:InfoTiers/n:RefTiers/@V" datatype="string" column="REFTIERS" table="PES_ALLER_FACTURE_TIERS_IX" format="uppercase"/>
+ <sql-index id="SQI_TIERS_NOM" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:InfoTiers/n:Nom/@V" datatype="string" column="NOM" table="PES_ALLER_FACTURE_TIERS_IX" format="uppercase"/>
+ <sql-index id="SQI_TIERS_NATIDTIERS" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:InfoTiers/n:NatIdTiers/@V" datatype="string" column="NATIDTIERS" table="PES_ALLER_FACTURE_TIERS_IX" format="uppercase"/>
+ <sql-index id="SQI_TIERS_VILLE" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:Adresse/n:Ville/@V" datatype="string" column="VILLE" table="PES_ALLER_FACTURE_TIERS_IX" format="uppercase"/>
+ <sql-index id="SQI_TIERS_TYPADR" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:Adresse/n:TypAdr/@V" datatype="string" column="TYPADR" table="PES_ALLER_FACTURE_TIERS_IX" format="uppercase"/>
+ <sql-index id="SQI_TIERS_CP" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:Adresse/n:CP/@V" datatype="string" column="CP" table="PES_ALLER_FACTURE_TIERS_IX" format="uppercase"/>
+ <sql-index id="SQI_TIERS_CODRES" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:Adresse/n:CodRes/@V" datatype="string" column="CODRES" table="PES_ALLER_FACTURE_TIERS_IX"/>
+ <sql-index id="SQI_TIERS_CODPAYS" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:Adresse/n:CodPays/@V" datatype="integer" column="CODPAYS" table="PES_ALLER_FACTURE_TIERS_IX" format="uppercase"/>
+ <sql-index id="SQI_TIERS_ADR3" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:Adresse/n:Adr3/@V" datatype="string" column="ADR3" table="PES_ALLER_FACTURE_TIERS_IX" format="uppercase"/>
+ <sql-index id="SQI_TIERS_ADR2" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:Adresse/n:Adr2/@V" datatype="string" column="ADR2" table="PES_ALLER_FACTURE_TIERS_IX" format="uppercase"/>
+ <sql-index id="SQI_TIERS_ADR1" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:Adresse/n:Adr1/@V" datatype="string" column="ADR1" table="PES_ALLER_FACTURE_TIERS_IX" format="uppercase"/>
+ <sql-index id="SQI_TIERS_DTEIDTIERS" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:InfoTiers/n:DteIdTiers/@V" datatype="date" column="DTEIDTIERS" table="PES_ALLER_FACTURE_TIERS_IX" format="yyyy-MM-dd"/>
+ <sql-index id="SQI_TIERS_NATJUR" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:InfoTiers/n:NatJur/@V" datatype="string" column="NATJUR" table="PES_ALLER_FACTURE_TIERS_IX" format="uppercase"/>
+ <sql-index id="SQI_TIERS_CIVILITE" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:InfoTiers/n:Civilite/@V" datatype="string" column="CIVILITE" table="PES_ALLER_FACTURE_TIERS_IX" format="uppercase"/>
+ <sql-index id="SQI_TIERS_COMPLNOM" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:InfoTiers/n:ComplNom/@V" datatype="string" column="COMPLNOM" table="PES_ALLER_FACTURE_TIERS_IX" format="uppercase"/>
+ <sql-index id="SQI_TIERS_RIB" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:CpteBancaire/@rib" datatype="string" column="RIB" table="PES_ALLER_FACTURE_TIERS_IX" format="uppercase"/>
+
+
+ <!-- SQL-INDEX /n:PES_Aller/n:PES_Facture/n:FactureIndiv -->
+ <sql-index id="SQI_FACTUREINDIV__NODE_ID" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/@added:generated-id" column="NODE_ID" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_FACTUREINDIV_CODPAYS" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:Adresse/n:CodPays/@V" datatype="integer" column="CODPAYS" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_NUMBORDEREAU" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:RefTitre/n:NumBordereau/@V" datatype="string" column="NUMBORDEREAU" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_COMPLNOM" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:ComplNom/@V" datatype="string" column="COMPLNOM" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_MTTOTALTTC" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:TotalAPayer/n:MtTotalTTC/@V" datatype="decimal" column="MTTOTALTTC" table="PES_ALLER_FACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_FACTUREINDIV_NUMLIGNE" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:RefTitre/n:NumLigne/@V" datatype="integer" column="NUMLIGNE" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_NUMTITRE" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:RefTitre/n:NumTitre/@V" datatype="string" column="NUMTITRE" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_OBJET" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Objet/@V" datatype="string" column="OBJET" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_DATEEMISSION" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:DateEmission/@V" datatype="date" column="DATEEMISSION" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" format="yyyy-MM-dd"/>
+ <sql-index id="SQI_FACTUREINDIV_DTEIDTIERS" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:DteIdTiers/@V" datatype="date" column="DTEIDTIERS" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" format="yyyy-MM-dd"/>
+ <sql-index id="SQI_FACTUREINDIV_TEXTEGENERATEUR" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:TexteGenerateur/@V" datatype="string" column="TEXTEGENERATEUR" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_CP" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:Adresse/n:CP/@V" datatype="string" column="CP" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_REFTIERS" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:RefTiers/@V" datatype="string" column="REFTIERS" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_MODERECOUVREMENT" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:ModeRecouvrement/@V" datatype="string" column="MODERECOUVREMENT" table="PES_ALLER_FACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_FACTUREINDIV_ADR3" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:Adresse/n:Adr3/@V" datatype="string" column="ADR3" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_ADR2" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:Adresse/n:Adr2/@V" datatype="string" column="ADR2" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_CATTIERS" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:CatTiers/@V" datatype="string" column="CATTIERS" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_NATJUR" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:NatJur/@V" datatype="string" column="NATJUR" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_ADR1" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:Adresse/n:Adr1/@V" datatype="string" column="ADR1" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_NATIDTIERS" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:NatIdTiers/@V" datatype="string" column="NATIDTIERS" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_MTTOTALTVA" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:TotalAPayer/n:MtTotalTVA/@V" datatype="decimal" column="MTTOTALTVA" table="PES_ALLER_FACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_FACTUREINDIV_PRENOM" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:Prenom/@V" datatype="string" column="PRENOM" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_NUMEROFACTURE" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:NumeroFacture/@V" datatype="string" column="NUMEROFACTURE" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_LIGNE2" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:TalonOptique2Lignes/n:Ligne2/@V" datatype="string" column="LIGNE2" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_LIGNE1" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:TalonOptique2Lignes/n:Ligne1/@V" datatype="string" column="LIGNE1" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_CODRES" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:Adresse/n:CodRes/@V" datatype="string" column="CODRES" table="PES_ALLER_FACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_FACTUREINDIV_MTTOTALHT" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:TotalAPayer/n:MtTotalHT/@V" datatype="decimal" column="MTTOTALHT" table="PES_ALLER_FACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_FACTUREINDIV_NOM" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:Nom/@V" datatype="string" column="NOM" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_MODALITESREGLEMENT" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:ModalitesReglement/@V" datatype="string" column="MODALITESREGLEMENT" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_TYPTIERS" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:TypTiers/@V" datatype="string" column="TYPTIERS" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_DATEREGLEMENT" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:DateReglement/@V" datatype="date" column="DATEREGLEMENT" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" format="yyyy-MM-dd"/>
+ <sql-index id="SQI_FACTUREINDIV_CONDITIONSGEN" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:ConditionsGen/@V" datatype="string" column="CONDITIONSGEN" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_EXERCICE" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:RefTitre/n:Exercice/@V" datatype="string" column="EXERCICE" table="PES_ALLER_FACTURE_FACTUREINDIV_IX"/>
+ <sql-index id="SQI_FACTUREINDIV_VILLE" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:Adresse/n:Ville/@V" datatype="string" column="VILLE" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_IDTIERS" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:IdTiers/@V" datatype="string" column="IDTIERS" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_TYPADR" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:Adresse/n:TypAdr/@V" datatype="string" column="TYPADR" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_CIVILITE" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:Civilite/@V" datatype="string" column="CIVILITE" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_RIB" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:CpteBancaire/@rib" datatype="string" column="RIB" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" format="uppercase"/>
+
+ <!-- SQL-INDEX /n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture -->
+ <sql-index id="SQI_FACTUREINDIV_LIGNEFACTURE__NODE_ID" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture/@added:generated-id" column="NODE_ID" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
+ <sql-index id="SQI_FACTUREINDIV_LIGNEFACTURE_ORDRE" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture/n:Ordre/@V" datatype="string" column="ORDRE" table="PES_ALLER_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_LIGNEFACTURE_MTTTC" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture/n:MtTTC/@V" datatype="decimal" column="MTTTC" table="PES_ALLER_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
+ <sql-index id="SQI_FACTUREINDIV_LIGNEFACTURE_TAUX" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture/n:Taux/@V" datatype="decimal" column="TAUX" table="PES_ALLER_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
+ <sql-index id="SQI_FACTUREINDIV_LIGNEFACTURE_MTHT" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture/n:MtHT/@V" datatype="decimal" column="MTHT" table="PES_ALLER_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
+ <sql-index id="SQI_FACTUREINDIV_LIGNEFACTURE_TAUXTVA" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture/n:TauxTVA/@V" datatype="decimal" column="TAUXTVA" table="PES_ALLER_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
+ <sql-index id="SQI_FACTUREINDIV_LIGNEFACTURE_MTTVA" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture/n:MtTVA/@V" datatype="decimal" column="MTTVA" table="PES_ALLER_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"/>
+ <sql-index id="SQI_FACTUREINDIV_LIGNEFACTURE_ORDREEDITION" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture/n:OrdreEdition/@V" datatype="integer" column="ORDREEDITION" table="PES_ALLER_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_LIGNEFACTURE_CODEPRODUIT" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture/n:CodeProduit/@V" datatype="string" column="CODEPRODUIT" table="PES_ALLER_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_LIGNEFACTURE_CODENATURE" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture/n:CodeNature/@V" datatype="string" column="CODENATURE" table="PES_ALLER_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_LIGNEFACTURE_LIBELLE" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture/n:Libelle/@V" datatype="string" column="LIBELLE" table="PES_ALLER_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_LIGNEFACTURE_UNITE" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture/n:Unite/@V" datatype="string" column="UNITE" table="PES_ALLER_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX" format="uppercase"/>
+
+ <!-- SQL-INDEX /n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture/n:Commentaire -->
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_COMMENTAIRE__NODE_ID" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture/n:Commentaire/@added:generated-id" column="NODE_ID" datatype="string" table="PES_ALLER_FACTURE_LIGNEFACTURE_COMMENTAIRE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_COMMENTAIRE_V" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture/n:Commentaire/@V" datatype="string" column="V" table="PES_ALLER_FACTURE_LIGNEFACTURE_COMMENTAIRE_IX" format="uppercase"/>
+
+ <!-- SQL-INDEX /n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:DetailTVA -->
+ <sql-index id="SQI_FACTUREINDIV_DETAILTVA__NODE_ID" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:DetailTVA/@added:generated-id" column="NODE_ID" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_DETAILTVA_IX"/>
+ <sql-index id="SQI_FACTUREINDIV_DETAILTVA_TAUXTVA" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:DetailTVA/n:TauxTVA/@V" datatype="decimal" column="TAUXTVA" table="PES_ALLER_FACTURE_FACTUREINDIV_DETAILTVA_IX"/>
+ <sql-index id="SQI_FACTUREINDIV_DETAILTVA_MTTVA" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:DetailTVA/n:MtTVA/@V" datatype="decimal" column="MTTVA" table="PES_ALLER_FACTURE_FACTUREINDIV_DETAILTVA_IX"/>
+ <sql-index id="SQI_FACTUREINDIV_DETAILTVA_MTBASEHT" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:DetailTVA/n:MtBaseHT/@V" datatype="decimal" column="MTBASEHT" table="PES_ALLER_FACTURE_FACTUREINDIV_DETAILTVA_IX"/>
+
+ <!-- SQL-INDEX /n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:RepartitionBudget -->
+ <sql-index id="SQI_FACTUREINDIV_REPARTITIONBUDGET__NODE_ID" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:RepartitionBudget/@added:generated-id" column="NODE_ID" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_REPARTITIONBUDGET_IX"/>
+ <sql-index id="SQI_FACTUREINDIV_REPARTITIONBUDGET_CODEBUDGET" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:RepartitionBudget/n:CodeBudget/@V" datatype="string" column="CODEBUDGET" table="PES_ALLER_FACTURE_FACTUREINDIV_REPARTITIONBUDGET_IX" format="uppercase"/>
+
+ <!-- SQL-INDEX /n:PES_Aller/n:PES_Facture/n:Nomenclatures/n:NomenclatureProduit/n:Correspondance -->
+ <sql-index id="SQI_PES_FACTURE_CORRESPONDANCE__NODE_ID" path="/n:PES_Aller/n:PES_Facture/n:Nomenclatures/n:NomenclatureProduit/n:Correspondance/@added:generated-id" column="NODE_ID" datatype="string" table="PES_ALLER_FACTURE_NOMENCLATUREPRODUIT_IX"/>
+ <sql-index id="SQI_PES_FACTURE_CORRESPONDANCE_LIBELLE" path="/n:PES_Aller/n:PES_Facture/n:Nomenclatures/n:NomenclatureProduit/n:Correspondance/n:Libelle/@V" datatype="string" column="LIBELLE" table="PES_ALLER_FACTURE_NOMENCLATUREPRODUIT_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_CORRESPONDANCE_CODE" path="/n:PES_Aller/n:PES_Facture/n:Nomenclatures/n:NomenclatureProduit/n:Correspondance/n:Code/@V" datatype="string" column="CODE" table="PES_ALLER_FACTURE_NOMENCLATUREPRODUIT_IX" format="uppercase"/>
+
+ <!-- SQL-INDEX /n:PES_Aller/n:PES_Facture/n:Nomenclatures/n:NomenclatureNature/n:Correspondance -->
+ <sql-index id="SQI_PES_FACTURE_CORRESPONDANCE__NODE_ID" path="/n:PES_Aller/n:PES_Facture/n:Nomenclatures/n:NomenclatureNature/n:Correspondance/@added:generated-id" column="NODE_ID" datatype="string" table="PES_ALLER_FACTURE_NOMENCLATURENATURE_IX"/>
+ <sql-index id="SQI_PES_FACTURE_CORRESPONDANCE_LIBELLE" path="/n:PES_Aller/n:PES_Facture/n:Nomenclatures/n:NomenclatureNature/n:Correspondance/n:Libelle/@V" datatype="string" column="LIBELLE" table="PES_ALLER_FACTURE_NOMENCLATURENATURE_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_CORRESPONDANCE_CODE" path="/n:PES_Aller/n:PES_Facture/n:Nomenclatures/n:NomenclatureNature/n:Correspondance/n:Code/@V" datatype="string" column="CODE" table="PES_ALLER_FACTURE_NOMENCLATURENATURE_IX" format="uppercase"/>
+
+ <!-- SQL-INDEX /n:PES_Aller/n:PES_Facture/n:Nomenclatures/n:NomenclatureBudget/n:Correspondance -->
+ <sql-index id="SQI_PES_FACTURE_CORRESPONDANCE__NODE_ID" path="/n:PES_Aller/n:PES_Facture/n:Nomenclatures/n:NomenclatureBudget/n:Correspondance/@added:generated-id" column="NODE_ID" datatype="string" table="PES_ALLER_FACTURE_NOMENCLATUREBUDGET_IX"/>
+ <sql-index id="SQI_PES_FACTURE_CORRESPONDANCE_LIBELLE" path="/n:PES_Aller/n:PES_Facture/n:Nomenclatures/n:NomenclatureBudget/n:Correspondance/n:Libelle/@V" datatype="string" column="LIBELLE" table="PES_ALLER_FACTURE_NOMENCLATUREBUDGET_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_CORRESPONDANCE_CODE" path="/n:PES_Aller/n:PES_Facture/n:Nomenclatures/n:NomenclatureBudget/n:Correspondance/n:Code/@V" datatype="string" column="CODE" table="PES_ALLER_FACTURE_NOMENCLATUREBUDGET_IX" format="uppercase"/>
+
+ <!-- SQL-INDEX /n:PES_Aller/n:PES_Facture/n:RepartitionParNature/n:Repartition -->
+ <sql-index id="SQI_PES_FACTURE_REPARTITION__NODE_ID" path="/n:PES_Aller/n:PES_Facture/n:RepartitionParNature/n:Repartition/@added:generated-id" column="NODE_ID" datatype="string" table="PES_ALLER_FACTURE_REPARTITIONPARNATURE_REPARTITION_IX"/>
+ <sql-index id="SQI_PES_FACTURE_REPARTITION_LIBELLE" path="/n:PES_Aller/n:PES_Facture/n:RepartitionParNature/n:Repartition/n:Libelle/@V" datatype="string" column="LIBELLE" table="PES_ALLER_FACTURE_REPARTITIONPARNATURE_REPARTITION_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_REPARTITION_CODE" path="/n:PES_Aller/n:PES_Facture/n:RepartitionParNature/n:Repartition/n:Code/@V" datatype="string" column="CODE" table="PES_ALLER_FACTURE_REPARTITIONPARNATURE_REPARTITION_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_REPARTITION_MT" path="/n:PES_Aller/n:PES_Facture/n:RepartitionParNature/n:Repartition/n:Mt/@V" datatype="decimal" column="MT" table="PES_ALLER_FACTURE_REPARTITIONPARNATURE_REPARTITION_IX"/>
+ <sql-index id="SQI_PES_FACTURE_REPARTITION_CODEFONCTION" path="/n:PES_Aller/n:PES_Facture/n:RepartitionParNature/n:Repartition/n:CodeFonction/@V" datatype="string" column="CODEFONCTION" table="PES_ALLER_FACTURE_REPARTITIONPARNATURE_REPARTITION_IX" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_REPARTITION_CODEBUDGET" path="/n:PES_Aller/n:PES_Facture/n:RepartitionParNature/n:Repartition/n:CodeBudget/@V" datatype="string" column="CODEBUDGET" table="PES_ALLER_FACTURE_REPARTITIONPARNATURE_REPARTITION_IX" format="uppercase"/>
+
+
+
+ <element id="PES_ALLER_FACTURE_FACTUREINDIV_IX">
+ <sql-count>COUNT(DISTINCT(CONCAT(PES_ALLER_FACTURE_IX.DOC_ID,PES_ALLER_FACTURE_FACTUREINDIV_IX.NODE_ID)))</sql-count>
+ <special-cond>PES_ALLER_FACTURE_FACTUREINDIV_IX.NODE_ID IS NOT NULL</special-cond>
+ </element>
+
+ <element id="PES_ALLER_FACTURE_TIERS_IX">
+ <sql-count>COUNT(DISTINCT(CONCAT(PES_FACTURE_IX.DOC_ID,PES_FACTURE_TIERS_IX.NODE_ID)))</sql-count>
+ <special-cond>PES_FACTURE_TIERS_IX.NODE_ID IS NOT NULL</special-cond>
+ </element>
+ <element id="PES_ALLER_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX">
+ <sql-count>COUNT(DISTINCT(CONCAT(PES_ALLER_PES_FACTURE_IX.DOC_ID,PES_ALLER_FACTUREINDIV_LIGNEFACTURE_IX.NODE_ID)))</sql-count>
+ <special-cond>PES_ALLER_FACTUREINDIV_LIGNEFACTURE_IX.NODE_ID IS NOT NULL</special-cond>
+ </element>
+ <element id="ALLER_FACTUREINDIV_LIGNEFACTURE_COMMENTAIRE_IX">
+ <sql-count>COUNT(DISTINCT(CONCAT(PES_ALLER_PES_FACTURE_IX.DOC_ID,ALLER_FACTUREINDIV_LIGNEFACTURE_COMMENTAIRE_IX.NODE_ID)))</sql-count>
+ <special-cond>ALLER_FACTUREINDIV_LIGNEFACTURE_COMMENTAIRE_IX.NODE_ID IS NOT NULL</special-cond>
+ </element>
+ <element id="PES_ALLER_FACTURE_FACTUREINDIV_DETAILTVA_IX">
+ <sql-count>COUNT(DISTINCT(CONCAT(PES_ALLER_PES_FACTURE_IX.DOC_ID,PES_ALLER_FACTUREINDIV_DETAILTVA_IX.NODE_ID)))</sql-count>
+ <special-cond>PES_ALLER_FACTUREINDIV_DETAILTVA_IX.NODE_ID IS NOT NULL</special-cond>
+ </element>
+ <element id="PES_ALLER_FACTURE_FACTUREINDIV_REPARTITIONBUDGET_IX">
+ <sql-count>COUNT(DISTINCT(CONCAT(PES_ALLER_PES_FACTURE_IX.DOC_ID,PES_ALLER_FACTUREINDIV_REPARTITIONBUDGET_IX.NODE_ID)))</sql-count>
+ <special-cond>PES_ALLER_FACTUREINDIV_REPARTITIONBUDGET_IX.NODE_ID IS NOT NULL</special-cond>
+ </element>
+ <element id="PES_ALLER_FACTURE_NOMENCLATUREPRODUIT_IX">
+ <sql-count>COUNT(DISTINCT(CONCAT(PES_ALLER_PES_FACTURE_IX.DOC_ID,ACTURE_NOMENCLATURES_NOMENCLATUREPRODUIT_IX.NODE_ID)))</sql-count>
+ <special-cond>ACTURE_NOMENCLATURES_NOMENCLATUREPRODUIT_IX.NODE_ID IS NOT NULL</special-cond>
+ </element>
+ <element id="PES_ALLER_FACTURE_NOMENCLATURENATURE_IX">
+ <sql-count>COUNT(DISTINCT(CONCAT(PES_ALLER_PES_FACTURE_IX.DOC_ID,FACTURE_NOMENCLATURES_NOMENCLATURENATURE_IX.NODE_ID)))</sql-count>
+ <special-cond>FACTURE_NOMENCLATURES_NOMENCLATURENATURE_IX.NODE_ID IS NOT NULL</special-cond>
+ </element>
+ <element id="PES_ALLER_FACTURE_NOMENCLATUREBUDGET_IX">
+ <sql-count>COUNT(DISTINCT(CONCAT(PES_ALLER_PES_FACTURE_IX.DOC_ID,FACTURE_NOMENCLATURES_NOMENCLATUREBUDGET_IX.NODE_ID)))</sql-count>
+ <special-cond>FACTURE_NOMENCLATURES_NOMENCLATUREBUDGET_IX.NODE_ID IS NOT NULL</special-cond>
+ </element>
+ <element id="PES_ALLER_FACTURE_REPARTITIONPARNATURE_REPARTITION_IX">
+ <sql-count>COUNT(DISTINCT(CONCAT(PES_ALLER_PES_FACTURE_IX.DOC_ID,PES_ALLER_PES_FACTURE_REPARTITIONPARNATURE_REPARTITION_IX.NODE_ID)))</sql-count>
+ <special-cond>PES_ALLER_PES_FACTURE_REPARTITIONPARNATURE_REPARTITION_IX.NODE_ID IS NOT NULL</special-cond>
+ </element>
+
+ </etat>
+
</document>
</layer>
<layer name="oracle" persistence-model="xemelios-sql">
path="/n:PES_Aller/n:PES_DepenseAller/n:Bordereau/n:Piece/n:LigneDePiece/n:Tiers/n:InfoTiers/n:DteMalade/@V"
datatype="date" table="lignepiece_depense" column="DATE_MALADE"
format="yyyy-MM-dd"/>
+ <sql-index id="SQI_DA_55B"
+ path="/n:PES_Aller/n:PES_DepenseAller/n:Bordereau/n:Piece/n:LigneDePiece/n:Tiers/n:InfoTiers/n:DteNaissance/@V"
+ datatype="date" table="lignepiece_depense" column="DATE_MALADE"
+ format="yyyy-MM-dd"/>
<sql-index id="SQI_DA_56"
path="/n:PES_Aller/n:PES_DepenseAller/n:Bordereau/n:Piece/n:LigneDePiece/n:Tiers/n:InfoTiers/n:NatIdTiers/@V"
datatype="string" table="lignepiece_depense" column="NAT_ID_TIERS"/>
<sql-index id="SQI_RA_64"
path="/n:PES_Aller/n:PES_RecetteAller/n:Bordereau/n:Piece/n:LigneDePiece/n:Tiers/n:InfoTiers/n:DteMalade/@V"
datatype="date" table="T_RA_6" column="DATE_MALADE" format="yyyy-MM-dd"/>
+ <sql-index id="SQI_RA_64B"
+ path="/n:PES_Aller/n:PES_RecetteAller/n:Bordereau/n:Piece/n:LigneDePiece/n:Tiers/n:InfoTiers/n:DteNaissance/@V"
+ datatype="date" table="T_RA_6" column="DATE_MALADE" format="yyyy-MM-dd"/>
<sql-index id="SQI_RA_65"
path="/n:PES_Aller/n:PES_RecetteAller/n:Bordereau/n:Piece/n:LigneDePiece/n:Tiers/n:InfoTiers/n:NatIdTiers/@V"
datatype="string" table="T_RA_6" column="NAT_ID_TIERS"/>
path="/n:PES_Aller/n:PES_RecetteAller/n:Bordereau/n:Piece/added:AllPJRef/n:NomPJ/@V"
datatype="string" table="recette_all_pj" column="NOM_PJ"/>
</etat>
+
+ <etat id="PES_Facture" import-xslt-file="PES_V2/PES-Aller-Facture-import-mysql.xsl">
+ <key1>
+ <path>/n:PES_Aller/n:PES_Facture/n:FactureIndiv/@added:generated-id</path>
+ </key1>
+ <key2>
+ <path>/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture/@added:generated-id</path>
+ </key2>
+ <key3>
+ <path>/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:DetailTVA/@added:generated-id</path>
+ </key3>
+ <key4>
+ <path>/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:RepartitionBudget/@added:generated-id</path>
+ </key4>
+ <key5>
+ <path>/n:PES_Aller/n:PES_Facture/n:Tiers/@added:generated-id</path>
+ </key5>
+ <key6>
+ <path>/n:PES_Aller/n:PES_Facture/n:Nomenclatures/n:NomenclatureProduit/n:Correspondance/@added:generated-id</path>
+ </key6>
+ <key7>
+ <path>/n:PES_Aller/n:PES_Facture/n:Nomenclatures/n:NomenclatureNature/n:Correspondance/@added:generated-id</path>
+ </key7>
+ <key8>
+ <path>/n:PES_Aller/n:PES_Facture/n:Nomenclatures/n:NomenclatureBudget/n:Correspondance/@added:generated-id</path>
+ </key8>
+ <key9>
+ <path>/n:PES_Aller/n:PES_Facture/n:RepartitionParNature/n:Repartition/@added:generated-id</path>
+ </key9>
+
+ <table base-name="PES_FACT_NOMBUD" id="PES_ALLER_FACTURE_NOMENCLATUREBUDGET_IX" type="index" main="false" based-on="key8" version="1">
+ <sql xml:space="preserve">CREATE TABLE ${base-name} (
+ BUDGET VARCHAR(1000) NOT NULL,
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ ARCHIVE_NAME VARCHAR(1000),
+ DOC_ID VARCHAR(1000) NOT NULL,
+ NODE_ID VARCHAR(1000) NOT NULL,
+ INITIAL_DOC_NAME VARCHAR(1000),
+ LIBELLE VARCHAR(1000),
+ CODE VARCHAR(1000)
+ )</sql>
+ <sql>CREATE INDEX IX_${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql>
+ <sql>CREATE INDEX IX_${base-name}_DC ON ${base-name} (DOC_ID)</sql>
+ <sql>CREATE INDEX ${base-name}_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql>
+ <sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql>
+ </table>
+ <table base-name="PES_FACT_NOMPROD" id="PES_ALLER_FACTURE_NOMENCLATUREPRODUIT_IX" type="index" main="false" based-on="key6" version="1">
+ <sql xml:space="preserve">CREATE TABLE ${base-name} (
+ BUDGET VARCHAR(1000) NOT NULL,
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ ARCHIVE_NAME VARCHAR(1000),
+ DOC_ID VARCHAR(1000) NOT NULL,
+ NODE_ID VARCHAR(1000) NOT NULL,
+ INITIAL_DOC_NAME VARCHAR(1000),
+ LIBELLE VARCHAR(1000),
+ CODE VARCHAR(1000)
+ )</sql>
+ <sql>CREATE INDEX IX_${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql>
+ <sql>CREATE INDEX IX_${base-name}_DC ON ${base-name} (DOC_ID)</sql>
+ <sql>CREATE INDEX ${base-name}_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql>
+ <sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql>
+ </table>
+ <table base-name="PES_FACT_LIGNE" id="PES_ALLER_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX" type="index" main="false" based-on="key2" version="1">
+ <sql xml:space="preserve">CREATE TABLE ${base-name} (
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ BUDGET VARCHAR(1000) NOT NULL,
+ DOC_ID VARCHAR(1000) NOT NULL,
+ TAUX DECIMAL(5,2),
+ CODEPRODUIT VARCHAR(1000),
+ INITIAL_DOC_NAME VARCHAR(1000),
+ UNITE VARCHAR(1000),
+ ARCHIVE_NAME VARCHAR(1000),
+ CODENATURE VARCHAR(1000),
+ ORDREEDITION NUMBER,
+ MTHT DECIMAL(14,2),
+ ORDRE VARCHAR(1000),
+ MTTTC DECIMAL(14,2),
+ MTTVA DECIMAL(14,2),
+ NODE_ID VARCHAR(1000) NOT NULL,
+ LIBELLE VARCHAR(1000),
+ TAUXTVA DECIMAL(5,2)
+ )</sql>
+ <sql>CREATE INDEX IX_${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql>
+ <sql>CREATE INDEX IX_${base-name}_DC ON ${base-name} (DOC_ID)</sql>
+ <sql>CREATE INDEX ${base-name}_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql>
+ <sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql>
+ </table>
+ <table base-name="PES_FACT_DOCS" type="document" version="1">
+ <sql xml:space="preserve">CREATE TABLE ${base-name} (
+ BUDGET VARCHAR(1000) NOT NULL,
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ ARCHIVE_NAME VARCHAR(1000),
+ DOC_ID VARCHAR(1000) NOT NULL,
+ DOC BLOB,
+ INITIAL_DOC_NAME VARCHAR(1000) NOT NULL
+ )</sql>
+ <sql>CREATE INDEX IX_${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql>
+ <sql>CREATE INDEX ${base-name}_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql>
+ <sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql>
+ </table>
+ <table base-name="PES_FACT_NOMNAT" id="PES_ALLER_FACTURE_NOMENCLATURENATURE_IX" type="index" main="false" based-on="key7" version="1">
+ <sql xml:space="preserve">CREATE TABLE ${base-name} (
+ BUDGET VARCHAR(1000) NOT NULL,
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ ARCHIVE_NAME VARCHAR(1000),
+ DOC_ID VARCHAR(1000) NOT NULL,
+ NODE_ID VARCHAR(1000) NOT NULL,
+ INITIAL_DOC_NAME VARCHAR(1000),
+ LIBELLE VARCHAR(1000),
+ CODE VARCHAR(1000)
+ )</sql>
+ <sql>CREATE INDEX IX_${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql>
+ <sql>CREATE INDEX IX_${base-name}_DC ON ${base-name} (DOC_ID)</sql>
+ <sql>CREATE INDEX ${base-name}_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql>
+ <sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql>
+ </table>
+ <table base-name="PES_FACT_REPNAT" id="PES_ALLER_FACTURE_REPARTITIONPARNATURE_REPARTITION_IX" type="index" main="false" based-on="key9" version="1">
+ <sql xml:space="preserve">CREATE TABLE ${base-name} (
+ BUDGET VARCHAR(1000) NOT NULL,
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ ARCHIVE_NAME VARCHAR(1000),
+ DOC_ID VARCHAR(1000) NOT NULL,
+ CODEFONCTION VARCHAR(1000),
+ CODEBUDGET VARCHAR(1000),
+ NODE_ID VARCHAR(1000) NOT NULL,
+ INITIAL_DOC_NAME VARCHAR(1000),
+ MT DECIMAL(14,2),
+ LIBELLE VARCHAR(1000),
+ CODE VARCHAR(1000)
+ )</sql>
+ <sql>CREATE INDEX IX_${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql>
+ <sql>CREATE INDEX IX_${base-name}_DC ON ${base-name} (DOC_ID)</sql>
+ <sql>CREATE INDEX ${base-name}_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql>
+ <sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql>
+ </table>
+ <table base-name="PES_FACTINDIV_IX" id="PES_ALLER_FACTURE_FACTUREINDIV_IX" type="index" main="false" based-on="key1" version="1">
+ <sql xml:space="preserve">CREATE TABLE ${base-name} (
+ BUDGET VARCHAR(1000) NOT NULL,
+ ADR3 VARCHAR(1000),
+ ADR1 VARCHAR(1000),
+ ADR2 VARCHAR(1000),
+ DATEEMISSION DATE,
+ NOM VARCHAR(1000),
+ CIVILITE VARCHAR(1000),
+ INITIAL_DOC_NAME VARCHAR(1000),
+ RIB VARCHAR(1000),
+ MTTOTALTVA DECIMAL(14,2),
+ ARCHIVE_NAME VARCHAR(1000),
+ NATIDTIERS VARCHAR(1000),
+ TEXTEGENERATEUR VARCHAR(1000),
+ TYPADR VARCHAR(1000),
+ MTTOTALTTC DECIMAL(14,2),
+ VILLE VARCHAR(1000),
+ EXERCICE VARCHAR(1000),
+ NODE_ID VARCHAR(1000) NOT NULL,
+ NUMEROFACTURE VARCHAR(1000),
+ NUMBORDEREAU VARCHAR(1000),
+ MODALITESREGLEMENT VARCHAR(1000),
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ DOC_ID VARCHAR(1000) NOT NULL,
+ REFTIERS VARCHAR(1000),
+ PRENOM VARCHAR(1000),
+ MODERECOUVREMENT VARCHAR(1000),
+ DATEREGLEMENT DATE,
+ DTEIDTIERS DATE,
+ COMPLNOM VARCHAR(1000),
+ CONDITIONSGEN VARCHAR(1000),
+ NUMTITRE VARCHAR(1000),
+ LIGNE2 VARCHAR(1000),
+ OBJET VARCHAR(1000),
+ TYPTIERS VARCHAR(1000),
+ LIGNE1 VARCHAR(1000),
+ IDTIERS VARCHAR(1000),
+ CODRES VARCHAR(1000),
+ NUMLIGNE NUMBER,
+ NATJUR VARCHAR(1000),
+ CP VARCHAR(1000),
+ MTTOTALHT DECIMAL(14,2),
+ CATTIERS VARCHAR(1000),
+ CODPAYS NUMBER
+ )</sql>
+ <sql>CREATE INDEX IX_${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql>
+ <sql>CREATE INDEX IX_${base-name}_DC ON ${base-name} (DOC_ID)</sql>
+ <sql>CREATE INDEX ${base-name}_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql>
+ <sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql>
+ </table>
+ <table base-name="PES_FAC_TIERS_IX" id="PES_ALLER_FACTURE_TIERS_IX" type="index" main="false" based-on="key5" version="1">
+ <sql xml:space="preserve">CREATE TABLE ${base-name} (
+ BUDGET VARCHAR(1000) NOT NULL,
+ ADR3 VARCHAR(1000),
+ ADR1 VARCHAR(1000),
+ ADR2 VARCHAR(1000),
+ NOM VARCHAR(1000),
+ CIVILITE VARCHAR(1000),
+ RIB VARCHAR(1000),
+ INITIAL_DOC_NAME VARCHAR(1000),
+ ARCHIVE_NAME VARCHAR(1000),
+ NATIDTIERS VARCHAR(1000),
+ TYPADR VARCHAR(1000),
+ VILLE VARCHAR(1000),
+ NODE_ID VARCHAR(1000) NOT NULL,
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ DOC_ID VARCHAR(1000) NOT NULL,
+ PRENOM VARCHAR(1000),
+ REFTIERS VARCHAR(1000),
+ DTEIDTIERS DATE,
+ COMPLNOM VARCHAR(1000),
+ TYPTIERS VARCHAR(1000),
+ IDTIERS VARCHAR(1000),
+ CODRES VARCHAR(1000),
+ NATJUR VARCHAR(1000),
+ CP VARCHAR(1000),
+ CATTIERS VARCHAR(1000),
+ CODPAYS NUMBER
+ )</sql>
+ <sql>CREATE INDEX IX_${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql>
+ <sql>CREATE INDEX IX_${base-name}_DC ON ${base-name} (DOC_ID)</sql>
+ <sql>CREATE INDEX ${base-name}_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql>
+ <sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql>
+ </table>
+ <table base-name="PES_FACT_INDIV_REPBUD" id="PES_ALLER_FACTURE_FACTUREINDIV_REPARTITIONBUDGET_IX" type="index" main="false" based-on="key4" version="1">
+ <sql xml:space="preserve">CREATE TABLE ${base-name} (
+ BUDGET VARCHAR(1000) NOT NULL,
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ ARCHIVE_NAME VARCHAR(1000),
+ DOC_ID VARCHAR(1000) NOT NULL,
+ CODEBUDGET VARCHAR(1000),
+ NODE_ID VARCHAR(1000) NOT NULL,
+ INITIAL_DOC_NAME VARCHAR(1000)
+ )</sql>
+ <sql>CREATE INDEX IX_${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql>
+ <sql>CREATE INDEX IX_${base-name}_DC ON ${base-name} (DOC_ID)</sql>
+ <sql>CREATE INDEX ${base-name}_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql>
+ <sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql>
+ </table>
+ <table base-name="PES_FACTINDIV_TVA_IX" id="PES_ALLER_FACTURE_FACTUREINDIV_DETAILTVA_IX" type="index" main="false" based-on="key3" version="1">
+ <sql xml:space="preserve">CREATE TABLE ${base-name} (
+ BUDGET VARCHAR(1000) NOT NULL,
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ ARCHIVE_NAME VARCHAR(1000),
+ DOC_ID VARCHAR(1000) NOT NULL,
+ MTTVA DECIMAL(14,2),
+ NODE_ID VARCHAR(1000) NOT NULL,
+ MTBASEHT DECIMAL(14,2),
+ INITIAL_DOC_NAME VARCHAR(1000),
+ TAUXTVA DECIMAL(5,2)
+ )</sql>
+ <sql>CREATE INDEX IX_${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql>
+ <sql>CREATE INDEX IX_${base-name}_DC ON ${base-name} (DOC_ID)</sql>
+ <sql>CREATE INDEX ${base-name}_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql>
+ <sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql>
+ </table>
+ <table base-name="PES_FACTURE_IX" id="PES_ALLER_FACTURE_IX" type="index" main="true" version="1">
+ <sql xml:space="preserve">CREATE TABLE ${base-name} (
+ BUDGET VARCHAR(1000) NOT NULL,
+ ADR3 VARCHAR(1000),
+ ADR1 VARCHAR(1000),
+ ADR2 VARCHAR(1000),
+ ROLE VARCHAR(1000),
+ NOM VARCHAR(38),
+ NOMSIGN VARCHAR(38),
+ NUMSEQUENCE NUMBER,
+ ANNEE VARCHAR(1000),
+ NUMTEL VARCHAR(1000),
+ CIVILITE VARCHAR(1000),
+ INITIAL_DOC_NAME VARCHAR(1000),
+ RIB VARCHAR(1000),
+ ARCHIVE_NAME VARCHAR(1000),
+ NATIDTIERS VARCHAR(1000),
+ TYPADR VARCHAR(1000),
+ VILLE VARCHAR(1000),
+ NODE_ID VARCHAR(1000) NOT NULL,
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ REFBDF VARCHAR(1000),
+ DOC_ID VARCHAR(1000) NOT NULL,
+ DESCRIPTION VARCHAR(1000),
+ REFTIERS VARCHAR(1000),
+ PRENOM VARCHAR(38),
+ PRENOMSIGN VARCHAR(38),
+ SERVICE VARCHAR(1000),
+ TYPEFACT VARCHAR(1000),
+ COMPLNOM VARCHAR(1000),
+ DTEIDTIERS DATE,
+ NUMTVA VARCHAR(1000),
+ TYPTIERS VARCHAR(1000),
+ IDTIERS VARCHAR(1000),
+ DATE_FACTURE DATE,
+ CODRES VARCHAR(1000),
+ CODETIPI NUMBER,
+ IDVER NUMBER,
+ NATJUR VARCHAR(1000),
+ HORAIRESOUV VARCHAR(1000),
+ CP VARCHAR(10),
+ CATTIERS VARCHAR(1000),
+ ADRTIPI VARCHAR(1000),
+ CODPAYS NUMBER
+ )</sql>
+ <sql>CREATE INDEX IX_${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql>
+ <sql>CREATE INDEX IX_${base-name}_DC ON ${base-name} (DOC_ID)</sql>
+ <sql>CREATE INDEX ${base-name}_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql>
+ <sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql>
+ </table>
+
+ <criteria id="CRI_PES_FACTURE_HORAIRESOUV" type="1" sql-index-id="SQI_PES_FACTURE_HORAIRESOUV">
+ <where-clause>fn:string-compare(${table}.${column},HorairesOuv)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_VILLE" type="1" sql-index-id="SQI_PES_FACTURE_VILLE">
+ <where-clause>fn:string-compare(${table}.${column},Ville)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_TYPADR" type="1" sql-index-id="SQI_PES_FACTURE_TYPADR">
+ <where-clause>fn:string-compare(${table}.${column},TypAdr)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_CP" type="1" sql-index-id="SQI_PES_FACTURE_CP">
+ <where-clause>fn:string-compare(${table}.${column},Cp)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_CATTIERS" type="1" sql-index-id="SQI_PES_FACTURE_CATTIERS">
+ <where-clause>fn:string-compare(${table}.${column},CatTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_DATE_FACTURE" type="1" sql-index-id="SQI_PES_FACTURE_DATE_FACTURE">
+ <where-clause>fn:date-compare(${table}.${column},Date)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_NUMTVA" type="1" sql-index-id="SQI_PES_FACTURE_NUMTVA">
+ <where-clause>fn:string-compare(${table}.${column},NumTVA)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_IDTIERS" type="1" sql-index-id="SQI_PES_FACTURE_IDTIERS">
+ <where-clause>fn:string-compare(${table}.${column},IdTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_ROLE" type="1" sql-index-id="SQI_PES_FACTURE_ROLE">
+ <where-clause>fn:string-compare(${table}.${column},Role)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_CODRES" type="1" sql-index-id="SQI_PES_FACTURE_CODRES">
+ <where-clause>fn:string-compare(${table}.${column},CodRes)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_CODPAYS" type="1" sql-index-id="SQI_PES_FACTURE_CODPAYS">
+ <where-clause>${table}.${column}##OPERATEUR:CodPays####VALEUR:CodPays##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_ADRTIPI" type="1" sql-index-id="SQI_PES_FACTURE_ADRTIPI">
+ <where-clause>fn:string-compare(${table}.${column},AdrTipi)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_PRENOM" type="1" sql-index-id="SQI_PES_FACTURE_PRENOM">
+ <where-clause>fn:string-compare(${table}.${column},Prenom)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_NUMTEL" type="1" sql-index-id="SQI_PES_FACTURE_NUMTEL">
+ <where-clause>fn:string-compare(${table}.${column},NumTel)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_IDVER" type="1" sql-index-id="SQI_PES_FACTURE_IDVER">
+ <where-clause>${table}.${column}##OPERATEUR:IdVer####VALEUR:IdVer##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_NUMSEQUENCE" type="1" sql-index-id="SQI_PES_FACTURE_NUMSEQUENCE">
+ <where-clause>${table}.${column}##OPERATEUR:NumSequence####VALEUR:NumSequence##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_TYPEFACT" type="1" sql-index-id="SQI_PES_FACTURE_TYPEFACT">
+ <where-clause>fn:string-compare(${table}.${column},TypeFact)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_SERVICE" type="1" sql-index-id="SQI_PES_FACTURE_SERVICE">
+ <where-clause>fn:string-compare(${table}.${column},Service)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_ANNEE" type="1" sql-index-id="SQI_PES_FACTURE_ANNEE">
+ <where-clause>fn:string-compare(${table}.${column},Annee)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_TYPTIERS" type="1" sql-index-id="SQI_PES_FACTURE_TYPTIERS">
+ <where-clause>fn:string-compare(${table}.${column},TypTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_NOM" type="1" sql-index-id="SQI_PES_FACTURE_NOM">
+ <where-clause>fn:string-compare(${table}.${column},Nom)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_REFTIERS" type="1" sql-index-id="SQI_PES_FACTURE_REFTIERS">
+ <where-clause>fn:string-compare(${table}.${column},RefTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_NATIDTIERS" type="1" sql-index-id="SQI_PES_FACTURE_NATIDTIERS">
+ <where-clause>fn:string-compare(${table}.${column},NatIdTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_ADR3" type="1" sql-index-id="SQI_PES_FACTURE_ADR3">
+ <where-clause>fn:string-compare(${table}.${column},Adr3)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_ADR2" type="1" sql-index-id="SQI_PES_FACTURE_ADR2">
+ <where-clause>fn:string-compare(${table}.${column},Adr2)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_DTEIDTIERS" type="1" sql-index-id="SQI_PES_FACTURE_DTEIDTIERS">
+ <where-clause>fn:date-compare(${table}.${column},DteIdTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_ADR1" type="1" sql-index-id="SQI_PES_FACTURE_ADR1">
+ <where-clause>fn:string-compare(${table}.${column},Adr1)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_REFBDF" type="1" sql-index-id="SQI_PES_FACTURE_REFBDF">
+ <where-clause>fn:string-compare(${table}.${column},RefBdf)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_CODETIPI" type="1" sql-index-id="SQI_PES_FACTURE_CODETIPI">
+ <where-clause>${table}.${column}##OPERATEUR:CodeTipi####VALEUR:CodeTipi##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_NATJUR" type="1" sql-index-id="SQI_PES_FACTURE_NATJUR">
+ <where-clause>fn:string-compare(${table}.${column},NatJur)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_DESCRIPTION" type="1" sql-index-id="SQI_PES_FACTURE_DESCRIPTION">
+ <where-clause>fn:string-compare(${table}.${column},Description)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_COMPLNOM" type="1" sql-index-id="SQI_PES_FACTURE_COMPLNOM">
+ <where-clause>fn:string-compare(${table}.${column},ComplNom)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_CIVILITE" type="1" sql-index-id="SQI_PES_FACTURE_CIVILITE">
+ <where-clause>fn:string-compare(${table}.${column},Civilite)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_RIB" type="1" sql-index-id="SQI_PES_FACTURE_RIB">
+ <where-clause>fn:string-compare(${table}.${column},rib)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_VILLE" type="1" sql-index-id="SQI_TIERS_VILLE">
+ <where-clause>fn:string-compare(${table}.${column},Ville)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_TYPADR" type="1" sql-index-id="SQI_TIERS_TYPADR">
+ <where-clause>fn:string-compare(${table}.${column},TypAdr)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_CP" type="1" sql-index-id="SQI_TIERS_CP">
+ <where-clause>fn:string-compare(${table}.${column},CP)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_CATTIERS" type="1" sql-index-id="SQI_TIERS_CATTIERS">
+ <where-clause>fn:string-compare(${table}.${column},CatTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_IDTIERS" type="1" sql-index-id="SQI_TIERS_IDTIERS">
+ <where-clause>fn:string-compare(${table}.${column},IdTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_CODRES" type="1" sql-index-id="SQI_TIERS_CODRES">
+ <where-clause>fn:string-compare(${table}.${column},CodRes)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_CODPAYS" type="1" sql-index-id="SQI_TIERS_CODPAYS">
+ <where-clause>${table}.${column}##OPERATEUR:CodPays####VALEUR:CodPays##</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_PRENOM" type="1" sql-index-id="SQI_TIERS_PRENOM">
+ <where-clause>fn:string-compare(${table}.${column},Prenom)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_TYPTIERS" type="1" sql-index-id="SQI_TIERS_TYPTIERS">
+ <where-clause>fn:string-compare(${table}.${column},TypTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_REFTIERS" type="1" sql-index-id="SQI_TIERS_REFTIERS">
+ <where-clause>fn:string-compare(${table}.${column},RefTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_NOM" type="1" sql-index-id="SQI_TIERS_NOM">
+ <where-clause>fn:string-compare(${table}.${column},Nom)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_ADR3" type="1" sql-index-id="SQI_TIERS_ADR3">
+ <where-clause>fn:string-compare(${table}.${column},Adr3)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_NATIDTIERS" type="1" sql-index-id="SQI_TIERS_NATIDTIERS">
+ <where-clause>fn:string-compare(${table}.${column},NatIdTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_ADR2" type="1" sql-index-id="SQI_TIERS_ADR2">
+ <where-clause>fn:string-compare(${table}.${column},Adr2)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_ADR1" type="1" sql-index-id="SQI_TIERS_ADR1">
+ <where-clause>fn:string-compare(${table}.${column},Adr1)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_DTEIDTIERS" type="1" sql-index-id="SQI_TIERS_DTEIDTIERS">
+ <where-clause>fn:date-compare(${table}.${column},DteIdTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_NATJUR" type="1" sql-index-id="SQI_TIERS_NATJUR">
+ <where-clause>fn:string-compare(${table}.${column},NatJur)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_CIVILITE" type="1" sql-index-id="SQI_TIERS_CIVILITE">
+ <where-clause>fn:string-compare(${table}.${column},Civilite)</where-clause>
+ </criteria>
+ <criteria id="CRI_TIERS_COMPLNOM" type="1" sql-index-id="SQI_TIERS_COMPLNOM">
+ <where-clause>fn:string-compare(${table}.${column},ComplNom)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_CODPAYS" type="1" sql-index-id="SQI_FACTUREINDIV_CODPAYS">
+ <where-clause>${table}.${column}##OPERATEUR:CodPays####VALEUR:CodPays##</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_NUMBORDEREAU" type="1" sql-index-id="SQI_FACTUREINDIV_NUMBORDEREAU">
+ <where-clause>fn:string-compare(${table}.${column},NumBordereau)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_COMPLNOM" type="1" sql-index-id="SQI_FACTUREINDIV_COMPLNOM">
+ <where-clause>fn:string-compare(${table}.${column},ComplNom)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_MTTOTALTTC" type="1" sql-index-id="SQI_FACTUREINDIV_MTTOTALTTC">
+ <where-clause>${table}.${column}##OPERATEUR:MtTotalTTC####VALEUR:MtTotalTTC##</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_NUMLIGNE" type="1" sql-index-id="SQI_FACTUREINDIV_NUMLIGNE">
+ <where-clause>${table}.${column}##OPERATEUR:NumLigne####VALEUR:NumLigne##</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_NUMTITRE" type="1" sql-index-id="SQI_FACTUREINDIV_NUMTITRE">
+ <where-clause>fn:string-compare(${table}.${column},NumTitre)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_OBJET" type="1" sql-index-id="SQI_FACTUREINDIV_OBJET">
+ <where-clause>fn:string-compare(${table}.${column},Objet)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_DATEEMISSION" type="1" sql-index-id="SQI_FACTUREINDIV_DATEEMISSION">
+ <where-clause>fn:date-compare(${table}.${column},DateEmission)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_DTEIDTIERS" type="1" sql-index-id="SQI_FACTUREINDIV_DTEIDTIERS">
+ <where-clause>fn:date-compare(${table}.${column},DteIdTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_TEXTEGENERATEUR" type="1" sql-index-id="SQI_FACTUREINDIV_TEXTEGENERATEUR">
+ <where-clause>fn:string-compare(${table}.${column},TexteGenerateur)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_CP" type="1" sql-index-id="SQI_FACTUREINDIV_CP">
+ <where-clause>fn:string-compare(${table}.${column},CP)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_REFTIERS" type="1" sql-index-id="SQI_FACTUREINDIV_REFTIERS">
+ <where-clause>fn:string-compare(${table}.${column},RefTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_MODERECOUVREMENT" type="1" sql-index-id="SQI_FACTUREINDIV_MODERECOUVREMENT">
+ <where-clause>fn:string-compare(${table}.${column},ModeRecouvrement)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_ADR3" type="1" sql-index-id="SQI_FACTUREINDIV_ADR3">
+ <where-clause>fn:string-compare(${table}.${column},Adr3)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_ADR2" type="1" sql-index-id="SQI_FACTUREINDIV_ADR2">
+ <where-clause>fn:string-compare(${table}.${column},Adr2)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_CATTIERS" type="1" sql-index-id="SQI_FACTUREINDIV_CATTIERS">
+ <where-clause>fn:string-compare(${table}.${column},CatTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_NATJUR" type="1" sql-index-id="SQI_FACTUREINDIV_NATJUR">
+ <where-clause>fn:string-compare(${table}.${column},NatJur)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_ADR1" type="1" sql-index-id="SQI_FACTUREINDIV_ADR1">
+ <where-clause>fn:string-compare(${table}.${column},Adr1)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_NATIDTIERS" type="1" sql-index-id="SQI_FACTUREINDIV_NATIDTIERS">
+ <where-clause>fn:string-compare(${table}.${column},NatIdTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_MTTOTALTVA" type="1" sql-index-id="SQI_FACTUREINDIV_MTTOTALTVA">
+ <where-clause>${table}.${column}##OPERATEUR:MtTotalTVA####VALEUR:MtTotalTVA##</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_PRENOM" type="1" sql-index-id="SQI_FACTUREINDIV_PRENOM">
+ <where-clause>fn:string-compare(${table}.${column},Prenom)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_NUMEROFACTURE" type="1" sql-index-id="SQI_FACTUREINDIV_NUMEROFACTURE">
+ <where-clause>fn:string-compare(${table}.${column},NumeroFacture)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_LIGNE2" type="1" sql-index-id="SQI_FACTUREINDIV_LIGNE2">
+ <where-clause>fn:string-compare(${table}.${column},Ligne2)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_LIGNE1" type="1" sql-index-id="SQI_FACTUREINDIV_LIGNE1">
+ <where-clause>fn:string-compare(${table}.${column},Ligne1)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_CODRES" type="1" sql-index-id="SQI_FACTUREINDIV_CODRES">
+ <where-clause>fn:string-compare(${table}.${column},CodRes)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_MTTOTALHT" type="1" sql-index-id="SQI_FACTUREINDIV_MTTOTALHT">
+ <where-clause>${table}.${column}##OPERATEUR:MtTotalHT####VALEUR:MtTotalHT##</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_NOM" type="1" sql-index-id="SQI_FACTUREINDIV_NOM">
+ <where-clause>fn:string-compare(${table}.${column},Nom)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_MODALITESREGLEMENT" type="1" sql-index-id="SQI_FACTUREINDIV_MODALITESREGLEMENT">
+ <where-clause>fn:string-compare(${table}.${column},ModalitesReglement)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_TYPTIERS" type="1" sql-index-id="SQI_FACTUREINDIV_TYPTIERS">
+ <where-clause>fn:string-compare(${table}.${column},TypTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_DATEREGLEMENT" type="1" sql-index-id="SQI_FACTUREINDIV_DATEREGLEMENT">
+ <where-clause>fn:date-compare(${table}.${column},DateReglement)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_CONDITIONSGEN" type="1" sql-index-id="SQI_FACTUREINDIV_CONDITIONSGEN">
+ <where-clause>fn:string-compare(${table}.${column},ConditionsGen)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_EXERCICE" type="1" sql-index-id="SQI_FACTUREINDIV_EXERCICE">
+ <where-clause>fn:string-compare(${table}.${column},Exercice)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_VILLE" type="1" sql-index-id="SQI_FACTUREINDIV_VILLE">
+ <where-clause>fn:string-compare(${table}.${column},Ville)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_IDTIERS" type="1" sql-index-id="SQI_FACTUREINDIV_IDTIERS">
+ <where-clause>fn:string-compare(${table}.${column},IdTiers)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_TYPADR" type="1" sql-index-id="SQI_FACTUREINDIV_TYPADR">
+ <where-clause>fn:string-compare(${table}.${column},TypAdr)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_CIVILITE" type="1" sql-index-id="SQI_FACTUREINDIV_CIVILITE">
+ <where-clause>fn:string-compare(${table}.${column},Civilite)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_RIB" type="1" sql-index-id="SQI_FACTUREINDIV_RIB">
+ <where-clause>fn:string-compare(${table}.${column},rib)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_LIGNEFACTURE_ORDRE" type="1" sql-index-id="SQI_FACTUREINDIV_LIGNEFACTURE_ORDRE">
+ <where-clause>fn:string-compare(${table}.${column},Ordre)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_LIGNEFACTURE_MTTTC" type="1" sql-index-id="SQI_FACTUREINDIV_LIGNEFACTURE_MTTTC">
+ <where-clause>${table}.${column}##OPERATEUR:MtTTC####VALEUR:MtTTC##</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_LIGNEFACTURE_TAUX" type="1" sql-index-id="SQI_FACTUREINDIV_LIGNEFACTURE_TAUX">
+ <where-clause>${table}.${column}##OPERATEUR:Taux####VALEUR:Taux##</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_LIGNEFACTURE_MTHT" type="1" sql-index-id="SQI_FACTUREINDIV_LIGNEFACTURE_MTHT">
+ <where-clause>${table}.${column}##OPERATEUR:MtHT####VALEUR:MtHT##</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_LIGNEFACTURE_TAUXTVA" type="1" sql-index-id="SQI_FACTUREINDIV_LIGNEFACTURE_TAUXTVA">
+ <where-clause>${table}.${column}##OPERATEUR:TauxTVA####VALEUR:TauxTVA##</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_LIGNEFACTURE_MTTVA" type="1" sql-index-id="SQI_FACTUREINDIV_LIGNEFACTURE_MTTVA">
+ <where-clause>${table}.${column}##OPERATEUR:MtTVA####VALEUR:MtTVA##</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_LIGNEFACTURE_ORDREEDITION" type="1" sql-index-id="SQI_FACTUREINDIV_LIGNEFACTURE_ORDREEDITION">
+ <where-clause>${table}.${column}##OPERATEUR:OrdreEdition####VALEUR:OrdreEdition##</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_LIGNEFACTURE_CODEPRODUIT" type="1" sql-index-id="SQI_FACTUREINDIV_LIGNEFACTURE_CODEPRODUIT">
+ <where-clause>${table}.${column}="##VALEUR:CodeProduit##"</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_LIGNEFACTURE_CODENATURE" type="1" sql-index-id="SQI_FACTUREINDIV_LIGNEFACTURE_CODENATURE">
+ <where-clause>fn:string-compare(${table}.${column},CodeNature)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_LIGNEFACTURE_LIBELLE" type="1" sql-index-id="SQI_FACTUREINDIV_LIGNEFACTURE_LIBELLE">
+ <where-clause>fn:string-compare(${table}.${column},Libelle)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_LIGNEFACTURE_UNITE" type="1" sql-index-id="SQI_FACTUREINDIV_LIGNEFACTURE_UNITE">
+ <where-clause>fn:string-compare(${table}.${column},Unite)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_LIGNEFACTURE_COMMENTAIRE_V" type="1" sql-index-id="SQI_PES_FACTURE_LIGNEFACTURE_COMMENTAIRE_V">
+ <where-clause>fn:string-compare(${table}.${column},V)</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_DETAILTVA_TAUXTVA" type="1" sql-index-id="SQI_FACTUREINDIV_DETAILTVA_TAUXTVA">
+ <where-clause>${table}.${column}##OPERATEUR:TauxTVA####VALEUR:TauxTVA##</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_DETAILTVA_MTTVA" type="1" sql-index-id="SQI_FACTUREINDIV_DETAILTVA_MTTVA">
+ <where-clause>${table}.${column}##OPERATEUR:MtTVA####VALEUR:MtTVA##</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_DETAILTVA_MTBASEHT" type="1" sql-index-id="SQI_FACTUREINDIV_DETAILTVA_MTBASEHT">
+ <where-clause>${table}.${column}##OPERATEUR:MtBaseHT####VALEUR:MtBaseHT##</where-clause>
+ </criteria>
+ <criteria id="CRI_FACTUREINDIV_REPARTITIONBUDGET_CODEBUDGET" type="1" sql-index-id="SQI_FACTUREINDIV_REPARTITIONBUDGET_CODEBUDGET">
+ <where-clause>fn:string-compare(${table}.${column},CodeBudget)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_CORRESPONDANCE_LIBELLE" type="1" sql-index-id="SQI_PES_FACTURE_CORRESPONDANCE_LIBELLE">
+ <where-clause>fn:string-compare(${table}.${column},Libelle)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_CORRESPONDANCE_CODE" type="1" sql-index-id="SQI_PES_FACTURE_CORRESPONDANCE_CODE">
+ <where-clause>fn:string-compare(${table}.${column},Code)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_CORRESPONDANCE_LIBELLE" type="1" sql-index-id="SQI_PES_FACTURE_CORRESPONDANCE_LIBELLE">
+ <where-clause>fn:string-compare(${table}.${column},Libelle)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_CORRESPONDANCE_CODE" type="1" sql-index-id="SQI_PES_FACTURE_CORRESPONDANCE_CODE">
+ <where-clause>fn:string-compare(${table}.${column},Code)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_CORRESPONDANCE_LIBELLE" type="1" sql-index-id="SQI_PES_FACTURE_CORRESPONDANCE_LIBELLE">
+ <where-clause>fn:string-compare(${table}.${column},Libelle)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_CORRESPONDANCE_CODE" type="1" sql-index-id="SQI_PES_FACTURE_CORRESPONDANCE_CODE">
+ <where-clause>fn:string-compare(${table}.${column},Code)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_REPARTITION_LIBELLE" type="1" sql-index-id="SQI_PES_FACTURE_REPARTITION_LIBELLE">
+ <where-clause>fn:string-compare(${table}.${column},Libelle)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_REPARTITION_CODE" type="1" sql-index-id="SQI_PES_FACTURE_REPARTITION_CODE">
+ <where-clause>fn:string-compare(${table}.${column},Code)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_REPARTITION_MT" type="1" sql-index-id="SQI_PES_FACTURE_REPARTITION_MT">
+ <where-clause>${table}.${column}##OPERATEUR:Mt####VALEUR:Mt##</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_REPARTITION_CODEFONCTION" type="1" sql-index-id="SQI_PES_FACTURE_REPARTITION_CODEFONCTION">
+ <where-clause>fn:string-compare(${table}.${column},CodeFonction)</where-clause>
+ </criteria>
+ <criteria id="CRI_PES_FACTURE_REPARTITION_CODEBUDGET" type="1" sql-index-id="SQI_PES_FACTURE_REPARTITION_CODEBUDGET">
+ <where-clause>fn:string-compare(${table}.${column},CodeBudget)</where-clause>
+ </criteria>
+
+ <sql-index id="SQI_PES_FACTURE__NODE_ID" path="/n:PES_Aller/n:PES_Facture/@added:generated-id" datatype="string" table="PES_ALLER_FACTURE_IX" column="NODE_ID"/>
+ <sql-index id="SQI_PES_FACTURE_HORAIRESOUV" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoSuppl/n:HorairesOuv/@V" datatype="string" table="PES_ALLER_FACTURE_IX" column="HORAIRESOUV" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_VILLE" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:Adresse/n:Ville/@V" datatype="string" table="PES_ALLER_FACTURE_IX" column="VILLE" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_TYPADR" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:Adresse/n:TypAdr/@V" datatype="string" table="PES_ALLER_FACTURE_IX" column="TYPADR" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_CP" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:Adresse/n:CP/@V" datatype="string" table="PES_ALLER_FACTURE_IX" column="CP"/>
+ <sql-index id="SQI_PES_FACTURE_CATTIERS" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoTiers/n:CatTiers/@V" datatype="string" table="PES_ALLER_FACTURE_IX" column="CATTIERS" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_DATE_FACTURE" path="/n:PES_Aller/n:PES_Facture/n:Date/@V" datatype="date" table="PES_ALLER_FACTURE_IX" column="DATE_FACTURE" format="yyyy-MM-dd"/>
+ <sql-index id="SQI_PES_FACTURE_NUMTVA" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoTVAEmetteur/n:NumTVA/@V" datatype="string" table="PES_ALLER_FACTURE_IX" column="NUMTVA" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_IDTIERS" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoTiers/n:IdTiers/@V" datatype="string" table="PES_ALLER_FACTURE_IX" column="IDTIERS" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_ROLE" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:Signataire/n:Role/@V" datatype="string" table="PES_ALLER_FACTURE_IX" column="ROLE" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_CODRES" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:Adresse/n:CodRes/@V" datatype="string" table="PES_ALLER_FACTURE_IX" column="CODRES"/>
+ <sql-index id="SQI_PES_FACTURE_CODPAYS" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:Adresse/n:CodPays/@V" datatype="integer" table="PES_ALLER_FACTURE_IX" column="CODPAYS" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_ADRTIPI" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoSuppl/n:AdrTipi/@V" datatype="string" table="PES_ALLER_FACTURE_IX" column="ADRTIPI" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_PRENOMSIGN" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:Signataire/n:Personne/n:Prenom/@V" datatype="string" table="PES_ALLER_FACTURE_IX" column="PRENOMSIGN" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_NUMTEL" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoSuppl/n:NumTel/@V" datatype="string" table="PES_ALLER_FACTURE_IX" column="NUMTEL" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_IDVER" path="/n:PES_Aller/n:PES_Facture/n:IdVer/@V" datatype="integer" table="PES_ALLER_FACTURE_IX" column="IDVER" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_NUMSEQUENCE" path="/n:PES_Aller/n:PES_Facture/n:NumSequence/@V" datatype="integer" table="PES_ALLER_FACTURE_IX" column="NUMSEQUENCE" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_TYPEFACT" path="/n:PES_Aller/n:PES_Facture/n:TypeFact/@V" datatype="string" table="PES_ALLER_FACTURE_IX" column="TYPEFACT" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_SERVICE" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoTVAEmetteur/n:Service/@V" datatype="string" table="PES_ALLER_FACTURE_IX" column="SERVICE" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_ANNEE" path="/n:PES_Aller/n:PES_Facture/n:Annee/@V" datatype="string" table="PES_ALLER_FACTURE_IX" column="ANNEE"/>
+ <sql-index id="SQI_PES_FACTURE_TYPTIERS" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoTiers/n:TypTiers/@V" datatype="string" table="PES_ALLER_FACTURE_IX" column="TYPTIERS" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_NOMSIGN" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:Signataire/n:Personne/n:Nom/@V" datatype="string" table="PES_ALLER_FACTURE_IX" column="NOMSIGN" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_REFTIERS" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoTiers/n:RefTiers/@V" datatype="string" table="PES_ALLER_FACTURE_IX" column="REFTIERS" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_NATIDTIERS" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoTiers/n:NatIdTiers/@V" datatype="string" table="PES_ALLER_FACTURE_IX" column="NATIDTIERS" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_ADR3" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:Adresse/n:Adr3/@V" datatype="string" table="PES_ALLER_FACTURE_IX" column="ADR3" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_ADR2" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:Adresse/n:Adr2/@V" datatype="string" table="PES_ALLER_FACTURE_IX" column="ADR2" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_DTEIDTIERS" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoTiers/n:DteIdTiers/@V" datatype="date" table="PES_ALLER_FACTURE_IX" column="DTEIDTIERS" format="yyyy-MM-dd"/>
+ <sql-index id="SQI_PES_FACTURE_ADR1" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:Adresse/n:Adr1/@V" datatype="string" table="PES_ALLER_FACTURE_IX" column="ADR1" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_REFBDF" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoSuppl/n:RefBdf/@V" datatype="string" table="PES_ALLER_FACTURE_IX" column="REFBDF" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_CODETIPI" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoSuppl/n:CodeTipi/@V" datatype="integer" table="PES_ALLER_FACTURE_IX" column="CODETIPI" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_NATJUR" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoTiers/n:NatJur/@V" datatype="string" table="PES_ALLER_FACTURE_IX" column="NATJUR" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_DESCRIPTION" path="/n:PES_Aller/n:PES_Facture/n:Nomenclatures/n:NomenclatureBudget/n:Description/@V" datatype="string" table="PES_ALLER_FACTURE_IX" column="DESCRIPTION" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_COMPLNOM" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoTiers/n:ComplNom/@V" datatype="string" table="PES_ALLER_FACTURE_IX" column="COMPLNOM" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_CIVILITE" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoTiers/n:Civilite/@V" datatype="string" table="PES_ALLER_FACTURE_IX" column="CIVILITE" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_NOM" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoTiers/n:Nom/@V" datatype="string" table="PES_ALLER_FACTURE_IX" column="NOM" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_PRENOM" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:InfoTiers/n:Prenom/@V" datatype="string" table="PES_ALLER_FACTURE_IX" column="PRENOM" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_RIB" path="/n:PES_Aller/n:PES_Facture/n:Emetteur/n:CptBancaire/@rib" datatype="string" table="PES_ALLER_FACTURE_IX" column="RIB" format="uppercase"/>
+ <sql-index id="SQI_TIERS__NODE_ID" path="/n:PES_Aller/n:PES_Facture/n:Tiers/@added:generated-id" datatype="string" table="PES_ALLER_FACTURE_TIERS_IX" column="NODE_ID"/>
+ <sql-index id="SQI_TIERS_CATTIERS" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:InfoTiers/n:CatTiers/@V" datatype="string" table="PES_ALLER_FACTURE_TIERS_IX" column="CATTIERS" format="uppercase"/>
+ <sql-index id="SQI_TIERS_IDTIERS" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:InfoTiers/n:IdTiers/@V" datatype="string" table="PES_ALLER_FACTURE_TIERS_IX" column="IDTIERS" format="uppercase"/>
+ <sql-index id="SQI_TIERS_PRENOM" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:InfoTiers/n:Prenom/@V" datatype="string" table="PES_ALLER_FACTURE_TIERS_IX" column="PRENOM" format="uppercase"/>
+ <sql-index id="SQI_TIERS_TYPTIERS" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:InfoTiers/n:TypTiers/@V" datatype="string" table="PES_ALLER_FACTURE_TIERS_IX" column="TYPTIERS" format="uppercase"/>
+ <sql-index id="SQI_TIERS_REFTIERS" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:InfoTiers/n:RefTiers/@V" datatype="string" table="PES_ALLER_FACTURE_TIERS_IX" column="REFTIERS" format="uppercase"/>
+ <sql-index id="SQI_TIERS_NOM" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:InfoTiers/n:Nom/@V" datatype="string" table="PES_ALLER_FACTURE_TIERS_IX" column="NOM" format="uppercase"/>
+ <sql-index id="SQI_TIERS_NATIDTIERS" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:InfoTiers/n:NatIdTiers/@V" datatype="string" table="PES_ALLER_FACTURE_TIERS_IX" column="NATIDTIERS" format="uppercase"/>
+ <sql-index id="SQI_TIERS_VILLE" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:Adresse/n:Ville/@V" datatype="string" table="PES_ALLER_FACTURE_TIERS_IX" column="VILLE" format="uppercase"/>
+ <sql-index id="SQI_TIERS_TYPADR" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:Adresse/n:TypAdr/@V" datatype="string" table="PES_ALLER_FACTURE_TIERS_IX" column="TYPADR" format="uppercase"/>
+ <sql-index id="SQI_TIERS_CP" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:Adresse/n:CP/@V" datatype="string" table="PES_ALLER_FACTURE_TIERS_IX" column="CP" format="uppercase"/>
+ <sql-index id="SQI_TIERS_CODRES" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:Adresse/n:CodRes/@V" datatype="string" table="PES_ALLER_FACTURE_TIERS_IX" column="CODRES"/>
+ <sql-index id="SQI_TIERS_CODPAYS" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:Adresse/n:CodPays/@V" datatype="integer" table="PES_ALLER_FACTURE_TIERS_IX" column="CODPAYS" format="uppercase"/>
+ <sql-index id="SQI_TIERS_ADR3" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:Adresse/n:Adr3/@V" datatype="string" table="PES_ALLER_FACTURE_TIERS_IX" column="ADR3" format="uppercase"/>
+ <sql-index id="SQI_TIERS_ADR2" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:Adresse/n:Adr2/@V" datatype="string" table="PES_ALLER_FACTURE_TIERS_IX" column="ADR2" format="uppercase"/>
+ <sql-index id="SQI_TIERS_ADR1" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:Adresse/n:Adr1/@V" datatype="string" table="PES_ALLER_FACTURE_TIERS_IX" column="ADR1" format="uppercase"/>
+ <sql-index id="SQI_TIERS_DTEIDTIERS" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:InfoTiers/n:DteIdTiers/@V" datatype="date" table="PES_ALLER_FACTURE_TIERS_IX" column="DTEIDTIERS" format="yyyy-MM-dd"/>
+ <sql-index id="SQI_TIERS_NATJUR" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:InfoTiers/n:NatJur/@V" datatype="string" table="PES_ALLER_FACTURE_TIERS_IX" column="NATJUR" format="uppercase"/>
+ <sql-index id="SQI_TIERS_CIVILITE" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:InfoTiers/n:Civilite/@V" datatype="string" table="PES_ALLER_FACTURE_TIERS_IX" column="CIVILITE" format="uppercase"/>
+ <sql-index id="SQI_TIERS_COMPLNOM" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:InfoTiers/n:ComplNom/@V" datatype="string" table="PES_ALLER_FACTURE_TIERS_IX" column="COMPLNOM" format="uppercase"/>
+ <sql-index id="SQI_TIERS_RIB" path="/n:PES_Aller/n:PES_Facture/n:Tiers/n:CpteBancaire/@rib" datatype="string" table="PES_ALLER_FACTURE_TIERS_IX" column="RIB" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV__NODE_ID" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/@added:generated-id" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="NODE_ID"/>
+ <sql-index id="SQI_FACTUREINDIV_CODPAYS" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:Adresse/n:CodPays/@V" datatype="integer" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="CODPAYS" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_NUMBORDEREAU" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:RefTitre/n:NumBordereau/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="NUMBORDEREAU" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_COMPLNOM" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:ComplNom/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="COMPLNOM" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_MTTOTALTTC" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:TotalAPayer/n:MtTotalTTC/@V" datatype="decimal" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="MTTOTALTTC"/>
+ <sql-index id="SQI_FACTUREINDIV_NUMLIGNE" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:RefTitre/n:NumLigne/@V" datatype="integer" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="NUMLIGNE" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_NUMTITRE" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:RefTitre/n:NumTitre/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="NUMTITRE" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_OBJET" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Objet/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="OBJET" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_DATEEMISSION" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:DateEmission/@V" datatype="date" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="DATEEMISSION" format="yyyy-MM-dd"/>
+ <sql-index id="SQI_FACTUREINDIV_DTEIDTIERS" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:DteIdTiers/@V" datatype="date" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="DTEIDTIERS" format="yyyy-MM-dd"/>
+ <sql-index id="SQI_FACTUREINDIV_TEXTEGENERATEUR" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:TexteGenerateur/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="TEXTEGENERATEUR" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_CP" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:Adresse/n:CP/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="CP" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_REFTIERS" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:RefTiers/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="REFTIERS" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_MODERECOUVREMENT" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:ModeRecouvrement/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="MODERECOUVREMENT"/>
+ <sql-index id="SQI_FACTUREINDIV_ADR3" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:Adresse/n:Adr3/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="ADR3" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_ADR2" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:Adresse/n:Adr2/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="ADR2" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_CATTIERS" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:CatTiers/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="CATTIERS" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_NATJUR" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:NatJur/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="NATJUR" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_ADR1" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:Adresse/n:Adr1/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="ADR1" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_NATIDTIERS" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:NatIdTiers/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="NATIDTIERS" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_MTTOTALTVA" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:TotalAPayer/n:MtTotalTVA/@V" datatype="decimal" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="MTTOTALTVA"/>
+ <sql-index id="SQI_FACTUREINDIV_PRENOM" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:Prenom/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="PRENOM" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_NUMEROFACTURE" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:NumeroFacture/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="NUMEROFACTURE" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_LIGNE2" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:TalonOptique2Lignes/n:Ligne2/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="LIGNE2" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_LIGNE1" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:TalonOptique2Lignes/n:Ligne1/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="LIGNE1" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_CODRES" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:Adresse/n:CodRes/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="CODRES"/>
+ <sql-index id="SQI_FACTUREINDIV_MTTOTALHT" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:TotalAPayer/n:MtTotalHT/@V" datatype="decimal" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="MTTOTALHT"/>
+ <sql-index id="SQI_FACTUREINDIV_NOM" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:Nom/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="NOM" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_MODALITESREGLEMENT" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:ModalitesReglement/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="MODALITESREGLEMENT" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_TYPTIERS" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:TypTiers/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="TYPTIERS" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_DATEREGLEMENT" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:DateReglement/@V" datatype="date" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="DATEREGLEMENT" format="yyyy-MM-dd"/>
+ <sql-index id="SQI_FACTUREINDIV_CONDITIONSGEN" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:ConditionsGen/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="CONDITIONSGEN" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_EXERCICE" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:RefTitre/n:Exercice/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="EXERCICE"/>
+ <sql-index id="SQI_FACTUREINDIV_VILLE" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:Adresse/n:Ville/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="VILLE" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_IDTIERS" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:IdTiers/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="IDTIERS" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_TYPADR" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:Adresse/n:TypAdr/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="TYPADR" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_CIVILITE" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:InfoTiers/n:Civilite/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="CIVILITE" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_RIB" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:Debiteur/n:CpteBancaire/@rib" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_IX" column="RIB" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_LIGNEFACTURE__NODE_ID" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture/@added:generated-id" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX" column="NODE_ID"/>
+ <sql-index id="SQI_FACTUREINDIV_LIGNEFACTURE_ORDRE" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture/n:Ordre/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX" column="ORDRE" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_LIGNEFACTURE_MTTTC" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture/n:MtTTC/@V" datatype="decimal" table="PES_ALLER_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX" column="MTTTC"/>
+ <sql-index id="SQI_FACTUREINDIV_LIGNEFACTURE_TAUX" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture/n:Taux/@V" datatype="decimal" table="PES_ALLER_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX" column="TAUX"/>
+ <sql-index id="SQI_FACTUREINDIV_LIGNEFACTURE_MTHT" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture/n:MtHT/@V" datatype="decimal" table="PES_ALLER_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX" column="MTHT"/>
+ <sql-index id="SQI_FACTUREINDIV_LIGNEFACTURE_TAUXTVA" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture/n:TauxTVA/@V" datatype="decimal" table="PES_ALLER_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX" column="TAUXTVA"/>
+ <sql-index id="SQI_FACTUREINDIV_LIGNEFACTURE_MTTVA" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture/n:MtTVA/@V" datatype="decimal" table="PES_ALLER_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX" column="MTTVA"/>
+ <sql-index id="SQI_FACTUREINDIV_LIGNEFACTURE_ORDREEDITION" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture/n:OrdreEdition/@V" datatype="integer" table="PES_ALLER_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX" column="ORDREEDITION" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_LIGNEFACTURE_CODEPRODUIT" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture/n:CodeProduit/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX" column="CODEPRODUIT" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_LIGNEFACTURE_CODENATURE" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture/n:CodeNature/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX" column="CODENATURE" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_LIGNEFACTURE_LIBELLE" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture/n:Libelle/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX" column="LIBELLE" format="uppercase"/>
+ <sql-index id="SQI_FACTUREINDIV_LIGNEFACTURE_UNITE" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture/n:Unite/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX" column="UNITE" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_COMMENTAIRE__NODE_ID" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture/n:Commentaire/@added:generated-id" datatype="string" table="PES_ALLER_FACTURE_LIGNEFACTURE_COMMENTAIRE_IX" column="NODE_ID"><!--WARNING: la colonne n'a pas été trouvée dans la définition de la table: PES_ALLER_FACTURE_LIGNEFACTURE_COMMENTAIRE_IX.NODE_ID--></sql-index>
+ <sql-index id="SQI_PES_FACTURE_LIGNEFACTURE_COMMENTAIRE_V" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:LigneFacture/n:Commentaire/@V" datatype="string" table="PES_ALLER_FACTURE_LIGNEFACTURE_COMMENTAIRE_IX" column="V" format="uppercase"><!--WARNING: la colonne n'a pas été trouvée dans la définition de la table: PES_ALLER_FACTURE_LIGNEFACTURE_COMMENTAIRE_IX.V--></sql-index>
+ <sql-index id="SQI_FACTUREINDIV_DETAILTVA__NODE_ID" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:DetailTVA/@added:generated-id" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_DETAILTVA_IX" column="NODE_ID"/>
+ <sql-index id="SQI_FACTUREINDIV_DETAILTVA_TAUXTVA" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:DetailTVA/n:TauxTVA/@V" datatype="decimal" table="PES_ALLER_FACTURE_FACTUREINDIV_DETAILTVA_IX" column="TAUXTVA"/>
+ <sql-index id="SQI_FACTUREINDIV_DETAILTVA_MTTVA" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:DetailTVA/n:MtTVA/@V" datatype="decimal" table="PES_ALLER_FACTURE_FACTUREINDIV_DETAILTVA_IX" column="MTTVA"/>
+ <sql-index id="SQI_FACTUREINDIV_DETAILTVA_MTBASEHT" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:DetailTVA/n:MtBaseHT/@V" datatype="decimal" table="PES_ALLER_FACTURE_FACTUREINDIV_DETAILTVA_IX" column="MTBASEHT"/>
+ <sql-index id="SQI_FACTUREINDIV_REPARTITIONBUDGET__NODE_ID" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:RepartitionBudget/@added:generated-id" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_REPARTITIONBUDGET_IX" column="NODE_ID"/>
+ <sql-index id="SQI_FACTUREINDIV_REPARTITIONBUDGET_CODEBUDGET" path="/n:PES_Aller/n:PES_Facture/n:FactureIndiv/n:RepartitionBudget/n:CodeBudget/@V" datatype="string" table="PES_ALLER_FACTURE_FACTUREINDIV_REPARTITIONBUDGET_IX" column="CODEBUDGET" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_CORRESPONDANCE__NODE_ID" path="/n:PES_Aller/n:PES_Facture/n:Nomenclatures/n:NomenclatureProduit/n:Correspondance/@added:generated-id" datatype="string" table="PES_ALLER_FACTURE_NOMENCLATUREPRODUIT_IX" column="NODE_ID"/>
+ <sql-index id="SQI_PES_FACTURE_CORRESPONDANCE_LIBELLE" path="/n:PES_Aller/n:PES_Facture/n:Nomenclatures/n:NomenclatureProduit/n:Correspondance/n:Libelle/@V" datatype="string" table="PES_ALLER_FACTURE_NOMENCLATUREPRODUIT_IX" column="LIBELLE" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_CORRESPONDANCE_CODE" path="/n:PES_Aller/n:PES_Facture/n:Nomenclatures/n:NomenclatureProduit/n:Correspondance/n:Code/@V" datatype="string" table="PES_ALLER_FACTURE_NOMENCLATUREPRODUIT_IX" column="CODE" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_CORRESPONDANCE__NODE_ID" path="/n:PES_Aller/n:PES_Facture/n:Nomenclatures/n:NomenclatureNature/n:Correspondance/@added:generated-id" datatype="string" table="PES_ALLER_FACTURE_NOMENCLATURENATURE_IX" column="NODE_ID"/>
+ <sql-index id="SQI_PES_FACTURE_CORRESPONDANCE_LIBELLE" path="/n:PES_Aller/n:PES_Facture/n:Nomenclatures/n:NomenclatureNature/n:Correspondance/n:Libelle/@V" datatype="string" table="PES_ALLER_FACTURE_NOMENCLATURENATURE_IX" column="LIBELLE" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_CORRESPONDANCE_CODE" path="/n:PES_Aller/n:PES_Facture/n:Nomenclatures/n:NomenclatureNature/n:Correspondance/n:Code/@V" datatype="string" table="PES_ALLER_FACTURE_NOMENCLATURENATURE_IX" column="CODE" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_CORRESPONDANCE__NODE_ID" path="/n:PES_Aller/n:PES_Facture/n:Nomenclatures/n:NomenclatureBudget/n:Correspondance/@added:generated-id" datatype="string" table="PES_ALLER_FACTURE_NOMENCLATUREBUDGET_IX" column="NODE_ID"/>
+ <sql-index id="SQI_PES_FACTURE_CORRESPONDANCE_LIBELLE" path="/n:PES_Aller/n:PES_Facture/n:Nomenclatures/n:NomenclatureBudget/n:Correspondance/n:Libelle/@V" datatype="string" table="PES_ALLER_FACTURE_NOMENCLATUREBUDGET_IX" column="LIBELLE" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_CORRESPONDANCE_CODE" path="/n:PES_Aller/n:PES_Facture/n:Nomenclatures/n:NomenclatureBudget/n:Correspondance/n:Code/@V" datatype="string" table="PES_ALLER_FACTURE_NOMENCLATUREBUDGET_IX" column="CODE" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_REPARTITION__NODE_ID" path="/n:PES_Aller/n:PES_Facture/n:RepartitionParNature/n:Repartition/@added:generated-id" datatype="string" table="PES_ALLER_FACTURE_REPARTITIONPARNATURE_REPARTITION_IX" column="NODE_ID"/>
+ <sql-index id="SQI_PES_FACTURE_REPARTITION_LIBELLE" path="/n:PES_Aller/n:PES_Facture/n:RepartitionParNature/n:Repartition/n:Libelle/@V" datatype="string" table="PES_ALLER_FACTURE_REPARTITIONPARNATURE_REPARTITION_IX" column="LIBELLE" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_REPARTITION_CODE" path="/n:PES_Aller/n:PES_Facture/n:RepartitionParNature/n:Repartition/n:Code/@V" datatype="string" table="PES_ALLER_FACTURE_REPARTITIONPARNATURE_REPARTITION_IX" column="CODE" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_REPARTITION_MT" path="/n:PES_Aller/n:PES_Facture/n:RepartitionParNature/n:Repartition/n:Mt/@V" datatype="decimal" table="PES_ALLER_FACTURE_REPARTITIONPARNATURE_REPARTITION_IX" column="MT"/>
+ <sql-index id="SQI_PES_FACTURE_REPARTITION_CODEFONCTION" path="/n:PES_Aller/n:PES_Facture/n:RepartitionParNature/n:Repartition/n:CodeFonction/@V" datatype="string" table="PES_ALLER_FACTURE_REPARTITIONPARNATURE_REPARTITION_IX" column="CODEFONCTION" format="uppercase"/>
+ <sql-index id="SQI_PES_FACTURE_REPARTITION_CODEBUDGET" path="/n:PES_Aller/n:PES_Facture/n:RepartitionParNature/n:Repartition/n:CodeBudget/@V" datatype="string" table="PES_ALLER_FACTURE_REPARTITIONPARNATURE_REPARTITION_IX" column="CODEBUDGET" format="uppercase"/>
+ </etat>
+
+
</document>
</layer>
</persistence-config>