--- /dev/null
+<?xml version="1.0" encoding="ISO-8859-1"?>
+<persistence-config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+ xsi:noNamespaceSchemaLocation="../../../../defs/config-metier/Persistence.xsd">
+ <layer name="mysql" persistence-model="xemelios-sql">
+ <document
+ id="erar"
+ repository-import-xslt-file="">
+ <table type="list-bc" base-name="ERAR_LIST_BUDG_COLL_2" version="1">
+ CREATE TABLE IF NOT EXISTS ${base-name} (
+ COLLECTIVITE VARCHAR(15) NOT NULL,
+ BUDGET VARCHAR(24) NOT NULL,
+ BUDGET_LIB VARCHAR(200),
+ COLLECTIVITE_LIB VARCHAR(200),
+ INITIAL_DOC_NAME VARCHAR(100) NOT NULL,
+ INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
+ INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET),
+ ARCHIVE_NAME VARCHAR(100),
+ INDEX ${base-name}_AN (ARCHIVE_NAME)
+ ) ENGINE MYISAM
+ </table>
+ <etat id="ligneErarV2" import-xslt-file="erar/erarv2-import-mysql.xsl">
+ <key1>
+ <path>/n:PosteComptable/n:Piece/n:LigneERAR/n:Empechement/@added:generated-id</path>
+ </key1>
+ <key2>
+ <path>/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@added:generated-id</path>
+ </key2>
+
+ <table type="document" base-name="TBL_ERAR_DOCUMENTS_2" version="1">
+ CREATE TABLE IF NOT EXISTS ${base-name} (
+ COLLECTIVITE VARCHAR(15) NOT NULL,
+ BUDGET VARCHAR(24) NOT NULL,
+ INITIAL_DOC_NAME VARCHAR(100) NOT NULL,
+ DOC_ID VARCHAR(100) NOT NULL,
+ DOC LONGBLOB,
+ ENCODING VARCHAR(20),
+ INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
+ ARCHIVE_NAME VARCHAR(100),
+ INDEX ${base-name}_AN (ARCHIVE_NAME)
+ ) ENGINE MYISAM </table>
+ <table type="index" id="TBL_LIGNEERAR_IX" base-name="ERAR_LIGNEERAR_2" version="3" main="true">
+ CREATE TABLE IF NOT EXISTS ${base-name} (
+ COLLECTIVITE VARCHAR(15) NOT NULL,
+ BUDGET VARCHAR(24) NOT NULL,
+ DOC_ID VARCHAR(100) NOT NULL,
+ EXER INTEGER,
+ ID_COLL VARCHAR(14),
+ FINJUR VARCHAR(20),
+ COD_COLL VARCHAR(3),
+ COD_BUD VARCHAR(2),
+ LIBELLE_COLBUD VARCHAR(38),
+ SERVICE_ORDONNATEUR VARCHAR(10),
+ REF_COMPTA_TYPE_REF VARCHAR(2),
+ REF_COMPTA_ID_BORD INTEGER,
+ REF_COMPTA_ID_PIECE INTEGER,
+ REF_COMPTA_EXER_RATTACH INTEGER,
+ REF_COMPTA_ID_LIGNE INTEGER,
+ REF_COMPTA_NUM_FACT VARCHAR(15),
+ REF_COMPTA_CODE_PERIODE VARCHAR(5),
+ REF_COMPTA_COD_PROD VARCHAR(3),
+ REF_COMPTA_LIB_PROD VARCHAR(30),
+ REF_COMPTA_DATE_EMISSION_PCE DATE,
+ DEB_ID_TIERS VARCHAR(15),
+ DEB_DATE_MALADE DATE,
+ DEB_TYP_TIERS VARCHAR(2),
+ DEB_NAT_ID_TIERS VARCHAR(2),
+ DEB_DATE_ID_TIERS DATE,
+ DEB_REF_TIERS VARCHAR(30),
+ DEB_CAT_TIERS VARCHAR(2),
+ DEB_NAT_JUR VARCHAR(2),
+ DEB_CIVILITE VARCHAR(10),
+ DEB_NOM VARCHAR(38),
+ DEB_COMPLNOM VARCHAR(38),
+ DEB_PRENOM VARCHAR(38),
+ DEB_TYP_ADR VARCHAR(1),
+ DEB_ADR1 VARCHAR(38),
+ DEB_ADR2 VARCHAR(38),
+ DEB_ADR3 VARCHAR(38),
+ DEB_CP VARCHAR(5),
+ DEB_VILLE VARCHAR(38),
+ DEB_CODPAYS VARCHAR(50),
+ DEB_DATE_ADR DATE,
+ DEB_NPAI VARCHAR(1),
+ DEB_REF_ALLOCATAIRE VARCHAR(20),
+ ASS_ID_TIERS VARCHAR(15),
+ ASS_DATE_MALADE DATE,
+ ASS_TYP_TIERS VARCHAR(2),
+ ASS_NAT_ID_TIERS VARCHAR(2),
+ ASS_DATE_ID_TIERS DATE,
+ ASS_REF_TIERS VARCHAR(30),
+ ASS_CAT_TIERS VARCHAR(2),
+ ASS_NAT_JUR VARCHAR(2),
+ ASS_CIVILITE VARCHAR(10),
+ ASS_NOM VARCHAR(38),
+ ASS_COMPLNOM VARCHAR(38),
+ ASS_PRENOM VARCHAR(38),
+ MAL_ID_TIERS VARCHAR(15),
+ MAL_DATE_MALADE DATE,
+ MAL_TYP_TIERS VARCHAR(2),
+ MAL_NAT_ID_TIERS VARCHAR(2),
+ MAL_DATE_ID_TIERS DATE,
+ MAL_REF_TIERS VARCHAR(30),
+ MAL_CAT_TIERS VARCHAR(2),
+ MAL_NAT_JUR VARCHAR(2),
+ MAL_CIVILITE VARCHAR(10),
+ MAL_NOM VARCHAR(38),
+ MAL_COMPLNOM VARCHAR(38),
+ MAL_PRENOM VARCHAR(38),
+ MAL_DATE_ENTREE DATE,
+ MAL_DATE_SORTIE DATe,
+ MAL_NUM_ENTREE VARCHAR(14),
+ MT_PRINC DECIMAL(14,2),
+ MT_FRAIS DECIMAL(14,2),
+ RAR_PRINC DECIMAL(14,2),
+ RAR_FRAIS DECIMAL(14,2),
+ DATE_PRESCRIPTION DATE,
+ DATE_ADMISSION_NV DATE,
+ MT_NV DECIMAL(14,2),
+ DATE_MAJORATION DATE,
+ COD_PROD_LOCAL VARCHAR(3),
+ ETAB_GEO VARCHAR(10),
+ DATE_DEB_FACT DATE,
+ DATE_FIN_FACT DATE,
+ OBJET_PIECE VARCHAR(160),
+ INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), INDEX IX_${base-name}_DC (DOC_ID),
+ INITIAL_DOC_NAME VARCHAR(100),
+ INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
+ ARCHIVE_NAME VARCHAR(100),
+ INDEX ${base-name}_AN (ARCHIVE_NAME)
+ ) ENGINE MYISAM
+ <patch from-version="1">
+ <sql failonerror="false">ALTER TABLE ${base-name} MODIFY DEB_CODPAYS VARCHAR(50)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD OBJET_PIECE VARCHAR(160)</sql>
+ </patch>
+ <patch from-version="2">
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD OBJET_PIECE VARCHAR(160)</sql>
+ </patch>
+ </table>
+ <table type="index" id="TBL_ERAR_EMPECHEMENT_IX" base-name="ERAR_EMPECHEMENT_2" version="1" main="false" based-on="key1">
+ CREATE TABLE IF NOT EXISTS ${base-name} (
+ COLLECTIVITE VARCHAR(15) NOT NULL,
+ BUDGET VARCHAR(24) NOT NULL,
+ DOC_ID VARCHAR(100) NOT NULL,
+ NODE_ID VARCHAR(50) NOT NULL,
+ CODEMP VARCHAR(15),
+ LIBEMP VARCHAR(30),
+ DATE_DEBUT_EMP DATE,
+ DATE_FIN_EMP DATE,
+ INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
+ INDEX IX_${base-name}_DC (DOC_ID),
+ INITIAL_DOC_NAME VARCHAR(100),
+ INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
+ ARCHIVE_NAME VARCHAR(100),
+ INDEX ${base-name}_AN (ARCHIVE_NAME)
+ ) ENGINE MYISAM
+ </table>
+ <table type="index" id="TBL_ERAR_ETAPE_IX" base-name="ERAR_ETAPE_2" version="1" main="false" based-on="key2">
+ CREATE TABLE IF NOT EXISTS ${base-name} (
+ COLLECTIVITE VARCHAR(15) NOT NULL,
+ BUDGET VARCHAR(24) NOT NULL,
+ DOC_ID VARCHAR(100) NOT NULL,
+ NODE_ID VARCHAR(50) NOT NULL,
+ CODE_ETAPE VARCHAR(3),
+ NAT_ETAPE VARCHAR(2),
+ LIB_ETAPE VARCHAR(30),
+ DATE_ETAPE DATE,
+ DATE_ANNULATION DATE,
+ CODE_ACTU VARCHAR(2),
+ LIB_ACTU VARCHAR(30),
+ DATE_ACTU DATE,
+ REF_ACTE VARCHAR(14),
+ DATE_DEMANDE_ACTE DATE,
+ DATE_ENVOI_ACTE DATE,
+ DATE_AUTOMATE DATE,
+ DATE_REMISE_ACTE DATE,
+ ETAT_VALIDATION VARCHAR(1),
+ ETAT_ETAPE VARCHAR(1),
+ NUM_ACTE_POURSUITE VARCHAR(14),
+ MT_ACTE_POURSUITE DECIMAL(14,2),
+ MT_ETAPE DECIMAL(14,2),
+ MT_FRAIS_ETAPE DECIMAL(14,2),
+ ORIGINE_ETAPE VARCHAR(1),
+ ORDREPRES INTEGER,
+ INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
+ INDEX IX_${base-name}_DC (DOC_ID),
+ INITIAL_DOC_NAME VARCHAR(100),
+ INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
+ ARCHIVE_NAME VARCHAR(100),
+ INDEX ${base-name}_AN (ARCHIVE_NAME)
+ ) ENGINE MYISAM
+ </table>
+
+
+ <!-- CRITERIA /PES_Restit/PES_ERAR/LigneERAR -->
+ <criteria id="IdColl" sql-index-id="IdColl">
+ <where-clause>fn:string-compare(${table}.${column},IdColl)</where-clause>
+ </criteria>
+ <criteria id="FinJur" sql-index-id="FinJur">
+ <where-clause>fn:string-compare(${table}.${column},FinJur)</where-clause>
+ </criteria>
+ <criteria id="CodCol" sql-index-id="CodCol">
+ <where-clause>fn:string-compare(${table}.${column},CodCol)</where-clause>
+ </criteria>
+ <criteria id="CodBud" sql-index-id="CodBud">
+ <where-clause>fn:string-compare(${table}.${column},CodBud)</where-clause>
+ </criteria>
+ <criteria id="LibColBud" sql-index-id="LibelleColBud">
+ <where-clause>fn:string-compare(${table}.${column},LibColBud)</where-clause>
+ </criteria>
+
+ <criteria id="ordo" sql-index-id="SvcOrdo">
+ <where-clause>fn:string-compare(${table}.${column},ordo)</where-clause>
+ </criteria>
+ <criteria id="RefComptaTypeRef" sql-index-id="refComptaTypeRef">
+ <where-clause>${table}.${column}='##VALEUR:TypeRef##'</where-clause>
+ </criteria>
+ <criteria id="RefComptaIdBord" sql-index-id="refComptaIdBord">
+ <where-clause>${table}.${column}##OPERATEUR:IdBord####VALEUR:IdBord##</where-clause>
+ </criteria>
+ <criteria id="RefComptaIdPiece" sql-index-id="refComptaIdPiece">
+ <where-clause>${table}.${column}##OPERATEUR:IdPiece####VALEUR:IdPiece##</where-clause>
+ </criteria>
+ <criteria id="RefComptaExerRattach" sql-index-id="refComptaExerRattach">
+ <where-clause>${table}.${column}##OPERATEUR:exer####VALEUR:exer##</where-clause>
+ </criteria>
+ <criteria id="RefComptaIdLigne" sql-index-id="refComptaIdLigne">
+ <where-clause>${table}.${column}##OPERATEUR:IdLigne####VALEUR:IdLigne##</where-clause>
+ </criteria>
+ <criteria id="RefComptaNumFact" sql-index-id="refComptaNumFact">
+ <where-clause>fn:string-compare(${table}.${column},NumFact)</where-clause>
+ </criteria>
+ <criteria id="RefComptaCodePeriode" sql-index-id="refComptaCodePeriode">
+ <where-clause>fn:string-compare(${table}.${column},CodePeriode)</where-clause>
+ </criteria>
+ <criteria id="RefComptaCodProd" sql-index-id="refComptaCodProd">
+ <where-clause>fn:string-compare(${table}.${column},CodProd)</where-clause>
+ </criteria>
+ <criteria id="RefComptaLibProd" sql-index-id="refComptaLibProd">
+ <where-clause>fn:string-compare(${table}.${column},LibProd)</where-clause>
+ </criteria>
+ <criteria id="RefComptaDatePce" sql-index-id="refComptaDateEmissionPce">
+ <where-clause>fn:date-compare(${table}.${column},DatePce)</where-clause>
+ </criteria>
+
+ <criteria id="ObjetPiece" sql-index-id="objetPiece">
+ <where-clause>fn:string-compare(${table}.${column},ObjetPiece)</where-clause>
+ </criteria>
+
+
+ <criteria id="DebIdTiers" sql-index-id="debIdTiers">
+ <where-clause>fn:string-compare(${table}.${column},IdTiers)</where-clause>
+ </criteria>
+ <criteria id="DebNom" sql-index-id="debNom">
+ <where-clause>fn:string-compare(${table}.${column},DebNom)</where-clause>
+ </criteria>
+ <criteria id="DebComplNom" sql-index-id="debComplNom">
+ <where-clause>fn:string-compare(${table}.${column},DebComplNom)</where-clause>
+ </criteria>
+ <criteria id="DebPrenom" sql-index-id="debPrenom">
+ <where-clause>fn:string-compare(${table}.${column},DebPrenom)</where-clause>
+ </criteria>
+ <criteria id="DebTypTiers" sql-index-id="debTypTiers">
+ <where-clause>${table}.${column}='##VALEUR:TypTiers##'</where-clause>
+ </criteria>
+ <criteria id="DebDteIdTiers" sql-index-id="debDateIdTiers">
+ <where-clause>fn:date-compare(${table}.${column},DebDteIdTiers)</where-clause>
+ </criteria>
+ <criteria id="DebRefTiers" sql-index-id="debRefTiers">
+ <where-clause>fn:string-compare(${table}.${column},DebRefTiers)</where-clause>
+ </criteria>
+ <criteria id="DebCatTiers" sql-index-id="debCatTiers">
+ <where-clause>${table}.${column}='##VALEUR:DebCatTiers##'</where-clause>
+ </criteria>
+ <criteria id="DebNatJur" sql-index-id="debNatJur">
+ <where-clause>${table}.${column}='##VALEUR:DebNatJur##'</where-clause>
+ </criteria>
+ <criteria id="DebCivilite" sql-index-id="debCivilite">
+ <where-clause>${table}.${column}='##VALEUR:DebCivilite##'</where-clause>
+ </criteria>
+ <!--criteria id="DebTypAdr" sql-index-id="debTypAdr">
+ <where-clause>${table}.${column}='##VALEUR:DebTypAdr##'</where-clause>
+ </criteria-->
+ <criteria id="DebAdr1" sql-index-id="debAdr1">
+ <where-clause>fn:string-compare(${table}.${column},DebAdr1)</where-clause>
+ </criteria>
+ <criteria id="DebAdr2" sql-index-id="debAdr2">
+ <where-clause>fn:string-compare(${table}.${column},DebAdr2)</where-clause>
+ </criteria>
+ <criteria id="DebAdr3" sql-index-id="debAdr3">
+ <where-clause>fn:string-compare(${table}.${column},DebAdr3)</where-clause>
+ </criteria>
+ <criteria id="DebCP" sql-index-id="debCp">
+ <where-clause>fn:string-compare(${table}.${column},DebCP)</where-clause>
+ </criteria>
+ <criteria id="DebVille" sql-index-id="debVille">
+ <where-clause>fn:string-compare(${table}.${column},DebVille)</where-clause>
+ </criteria>
+ <criteria id="DebPays" sql-index-id="debCodPays">
+ <where-clause>fn:string-compare(${table}.${column},DebPays)</where-clause>
+ </criteria>
+ <criteria id="DebNPAI" sql-index-id="debNpai">
+ <where-clause>${table}.${column}='##VALEUR:DebNPAI##'</where-clause>
+ </criteria>
+ <criteria id="DebRefAllocataire" sql-index-id="debRefAllocataire">
+ <where-clause>fn:string-compare(${table}.${column},DebRefAllocataire)</where-clause>
+ </criteria>
+
+ <criteria id="AssIdTiers" sql-index-id="assIdTiers">
+ <where-clause>fn:string-compare(${table}.${column},IdTiers)</where-clause>
+ </criteria>
+ <criteria id="AssNom" sql-index-id="assNom">
+ <where-clause>fn:string-compare(${table}.${column},AssNom)</where-clause>
+ </criteria>
+ <criteria id="AssComplNom" sql-index-id="assComplNom">
+ <where-clause>fn:string-compare(${table}.${column},AssComplNom)</where-clause>
+ </criteria>
+ <criteria id="AssPrenom" sql-index-id="assPrenom">
+ <where-clause>fn:string-compare(${table}.${column},AssPrenom)</where-clause>
+ </criteria>
+ <criteria id="AssTypTiers" sql-index-id="assTypTiers">
+ <where-clause>${table}.${column}='##VALEUR:TypTiers##'</where-clause>
+ </criteria>
+ <criteria id="AssDteIdTiers" sql-index-id="assDateIdTiers">
+ <where-clause>fn:date-compare(${table}.${column},AssDteIdTiers)</where-clause>
+ </criteria>
+ <criteria id="AssRefTiers" sql-index-id="assRefTiers">
+ <where-clause>fn:string-compare(${table}.${column},AssRefTiers)</where-clause>
+ </criteria>
+ <criteria id="AssCatTiers" sql-index-id="assCatTiers">
+ <where-clause>${table}.${column}='##VALEUR:AssCatTiers##'</where-clause>
+ </criteria>
+ <criteria id="AssNatJur" sql-index-id="assNatJur">
+ <where-clause>${table}.${column}='##VALEUR:AssNatJur##'</where-clause>
+ </criteria>
+ <criteria id="AssCivilite" sql-index-id="assCivilite">
+ <where-clause>${table}.${column}='##VALEUR:AssCivilite##'</where-clause>
+ </criteria>
+
+ <criteria id="MalIdTiers" sql-index-id="malIdTiers">
+ <where-clause>fn:string-compare(${table}.${column},IdTiers)</where-clause>
+ </criteria>
+ <criteria id="MalNom" sql-index-id="malNom">
+ <where-clause>fn:string-compare(${table}.${column},MalNom)</where-clause>
+ </criteria>
+ <criteria id="MalComplNom" sql-index-id="malComplNom">
+ <where-clause>fn:string-compare(${table}.${column},MalComplNom)</where-clause>
+ </criteria>
+ <criteria id="MalPrenom" sql-index-id="malPrenom">
+ <where-clause>fn:string-compare(${table}.${column},MalPrenom)</where-clause>
+ </criteria>
+ <criteria id="MalTypTiers" sql-index-id="malTypTiers">
+ <where-clause>${table}.${column}='##VALEUR:TypTiers##'</where-clause>
+ </criteria>
+ <criteria id="MalDteIdTiers" sql-index-id="malDateIdTiers">
+ <where-clause>fn:date-compare(${table}.${column},MalDteIdTiers)</where-clause>
+ </criteria>
+ <criteria id="MalRefTiers" sql-index-id="malRefTiers">
+ <where-clause>fn:string-compare(${table}.${column},MalRefTiers)</where-clause>
+ </criteria>
+ <criteria id="MalCatTiers" sql-index-id="malCatTiers">
+ <where-clause>${table}.${column}='##VALEUR:MalCatTiers##'</where-clause>
+ </criteria>
+ <criteria id="MalNatJur" sql-index-id="malNatJur">
+ <where-clause>${table}.${column}='##VALEUR:MalNatJur##'</where-clause>
+ </criteria>
+ <criteria id="MalCivilite" sql-index-id="malCivilite">
+ <where-clause>${table}.${column}='##VALEUR:MalCivilite##'</where-clause>
+ </criteria>
+ <criteria id="MalDateEntree" sql-index-id="malDateEntree">
+ <where-clause>fn:date-compare(${table}.${column},MalDateEntree)</where-clause>
+ </criteria>
+ <criteria id="MalDateSortie" sql-index-id="malDateSortie">
+ <where-clause>fn:date-compare(${table}.${column},MalDateSortie)</where-clause>
+ </criteria>
+ <criteria id="MalNumEntree" sql-index-id="malNumEntree">
+ <where-clause>fn:string-compare(${table}.${column},MalNumEntree)</where-clause>
+ </criteria>
+
+ <criteria id="MtPrinc" sql-index-id="mtPrinc">
+ <where-clause>${table}.${column}##OPERATEUR:MtPrinc####VALEUR:MtPrinc##</where-clause>
+ </criteria>
+ <criteria id="MtFrais" sql-index-id="mtFrais">
+ <where-clause>${table}.${column}##OPERATEUR:MtFrais####VALEUR:MtFrais##</where-clause>
+ </criteria>
+ <criteria id="RarPrinc" sql-index-id="RarPrinc">
+ <where-clause>${table}.${column}##OPERATEUR:RarPrinc####VALEUR:RarPrinc##</where-clause>
+ </criteria>
+ <criteria id="RarFrais" sql-index-id="RarFrais">
+ <where-clause>${table}.${column}##OPERATEUR:RarFrais####VALEUR:RarFrais##</where-clause>
+ </criteria>
+ <criteria id="DateNV" sql-index-id="dateAdmissionNV">
+ <where-clause>fn:date-compare(${table}.${column},DateNV)</where-clause>
+ </criteria>
+ <criteria id="MtNV" sql-index-id="mtNv">
+ <where-clause>${table}.${column}##OPERATEUR:MtNV####VALEUR:MtNV##</where-clause>
+ </criteria>
+ <criteria id="DateMajoration" sql-index-id="dateMajoration">
+ <where-clause>fn:date-compare(${table}.${column},DateMajoration)</where-clause>
+ </criteria>
+ <criteria id="DatePrescription" sql-index-id="datePrescription">
+ <where-clause>fn:date-compare(${table}.${column},DatePrescription)</where-clause>
+ </criteria>
+ <criteria id="etabGeo" sql-index-id="etabGeo">
+ <where-clause>fn:string-compare(${table}.${column},etabGeo)</where-clause>
+ </criteria>
+ <criteria id="CodProdLocal" sql-index-id="codProdLocal">
+ <where-clause>fn:string-compare(${table}.${column},CodProdLocal)</where-clause>
+ </criteria>
+ <criteria id="DateDebFact" sql-index-id="dateDebFact">
+ <where-clause>fn:date-compare(${table}.${column},DateDebFact)</where-clause>
+ </criteria>
+ <criteria id="DateFinFact" sql-index-id="dateFinFact">
+ <where-clause>fn:date-compare(${table}.${column},DateFinFact)</where-clause>
+ </criteria>
+
+ <criteria id="EmpCodEmp" sql-index-id="empCodEmp">
+ <where-clause>${table}.${column}=##VALEUR:CodEmp##</where-clause>
+ </criteria>
+ <criteria id="EmpDateDebEmp" sql-index-id="empDateDebEmp">
+ <where-clause>fn:date-compare(${table}.${column},DateDebEmp)</where-clause>
+ </criteria>
+ <criteria id="EmpDateFinEmp" sql-index-id="empDateFinEmp">
+ <where-clause>fn:date-compare(${table}.${column},DateFinEmp)</where-clause>
+ </criteria>
+
+ <criteria id="EtpCodeEtape" sql-index-id="etpCodeEtape">
+ <where-clause>fn:string-compare(${table}.${column},CodeEtape)</where-clause>
+ </criteria>
+ <criteria id="EtpNatEtape" sql-index-id="etpCodeEtape">
+ <where-clause>${table}.${column}='##VALEUR:NatEtape##'</where-clause>
+ </criteria>
+ <!--criteria id="EtpLibEtape" sql-index-id="etpLibEtape">
+ <where-clause>fn:string-compare(${table}.${column},LibEtape)</where-clause>
+ </criteria-->
+ <criteria id="EtpDateEtape" sql-index-id="etpDateEtape">
+ <where-clause>fn:date-compare(${table}.${column},DateEtape)</where-clause>
+ </criteria>
+ <criteria id="EtpDateAnnulation" sql-index-id="etpDateAnnulation">
+ <where-clause>fn:date-compare(${table}.${column},DateAnnulation)</where-clause>
+ </criteria>
+ <criteria id="EtpDateActu" sql-index-id="etpDateActu">
+ <where-clause>fn:date-compare(${table}.${column},DateActu)</where-clause>
+ </criteria>
+
+ <criteria id="EtpCodeActu" sql-index-id="etpCodeActu">
+ <where-clause>${table}.${column}='##VALEUR:CodeActu##'</where-clause>
+ </criteria>
+ <!--criteria id="EtpLibActu" sql-index-id="etpLibActu">
+ <where-clause>fn:string-compare(${table}.${column},LibActu)</where-clause>
+ </criteria-->
+ <criteria id="EtpRefActe" sql-index-id="etpRefActe">
+ <where-clause>fn:string-compare(${table}.${column},RefActe)</where-clause>
+ </criteria>
+ <criteria id="EtpDateDemandeActe" sql-index-id="etpDateDemandeActe">
+ <where-clause>fn:date-compare(${table}.${column},DateDemande)</where-clause>
+ </criteria>
+ <criteria id="EtpDateEnvoiActe" sql-index-id="etpDateEnvoiActe">
+ <where-clause>fn:date-compare(${table}.${column},DateEnvoi)</where-clause>
+ </criteria>
+ <criteria id="EtpDateRemiseActe" sql-index-id="etpDateRemiseActe">
+ <where-clause>fn:date-compare(${table}.${column},DateRemise)</where-clause>
+ </criteria>
+ <criteria id="EtpDateAutomate" sql-index-id="etpDateAutomate">
+ <where-clause>fn:date-compare(${table}.${column},DateAutomate)</where-clause>
+ </criteria>
+ <criteria id="EtpEtatValidation" sql-index-id="etpEtatValidation">
+ <where-clause>${table}.${column}='##VALEUR:EtatValidation##'</where-clause>
+ </criteria>
+ <criteria id="EtpEtatEtape" sql-index-id="etpEtatEtape">
+ <where-clause>${table}.${column}='##VALEUR:EtatEtape##'</where-clause>
+ </criteria>
+ <criteria id="EtpNumActe" sql-index-id="etpNumActePoursuite">
+ <where-clause>fn:string-compare(${table}.${column},NumActe)</where-clause>
+ </criteria>
+ <criteria id="EtpMtActe" sql-index-id="etpMtActePoursuite">
+ <where-clause>${table}.${column}##OPERATEUR:MtActe####VALEUR:MtActe##</where-clause>
+ </criteria>
+ <criteria id="EtpMtEtape" sql-index-id="etpMtEtape">
+ <where-clause>${table}.${column}##OPERATEUR:MtEtape####VALEUR:MtEtape##</where-clause>
+ </criteria>
+ <criteria id="EtpMtFraisEtape" sql-index-id="etpMtFraisEtape">
+ <where-clause>${table}.${column}##OPERATEUR:MtFraisEtape####VALEUR:MtFraisEtape##</where-clause>
+ </criteria>
+ <criteria id="EtpOrigineEtape" sql-index-id="etpOrigineEtape">
+ <where-clause>${table}.${column}='##VALEUR:OrigineEtape##'</where-clause>
+ </criteria>
+ <criteria id="docId" sql-index-id="debIdTiers">
+ <where-clause>ERAR_LIGNEERAR_2.DOC_ID='##VALEUR:docId##'</where-clause>
+ </criteria>
+
+
+
+ <sql-index id="exer" table="TBL_LIGNEERAR_IX" column="EXER" path="/n:PosteComptable/n:Piece/@ExerRattach" datatype="string" format="uppercase"/>
+ <sql-index id="IdColl" table="TBL_LIGNEERAR_IX" column="ID_COLL" path="/n:PosteComptable/@IdColl" datatype="string" format="uppercase"/>
+ <sql-index id="FinJur" table="TBL_LIGNEERAR_IX" column="FINJUR" path="/n:PosteComptable/@FinJur" datatype="string" format="uppercase"/>
+ <sql-index id="CodCol" table="TBL_LIGNEERAR_IX" column="COD_COLL" path="/n:PosteComptable/@CodCol" datatype="string" format="uppercase"/>
+ <sql-index id="CodBud" table="TBL_LIGNEERAR_IX" column="COD_BUD" path="/n:PosteComptable/@CodBud" datatype="string" format="uppercase"/>
+ <sql-index id="LibelleColBud" table="TBL_LIGNEERAR_IX" column="LIBELLE_COLBUD" path="/n:PosteComptable/@LibelleColBud" datatype="string" format="uppercase"/>
+ <sql-index id="SvcOrdo" table="TBL_LIGNEERAR_IX" column="SERVICE_ORDONNATEUR" path="/n:PosteComptable/n:Piece/n:LigneERAR/@ServiceOrdonnateur" datatype="string" format="uppercase"/>
+ <sql-index id="refComptaTypeRef" table="TBL_LIGNEERAR_IX" column="REF_COMPTA_TYPE_REF" path="/n:PosteComptable/n:Piece/@TypeRef" datatype="string"/>
+ <sql-index id="refComptaIdBord" table="TBL_LIGNEERAR_IX" column="REF_COMPTA_ID_BORD" path="/n:PosteComptable/n:Piece/@IdBord" datatype="integer"/>
+ <sql-index id="refComptaIdPiece" table="TBL_LIGNEERAR_IX" column="REF_COMPTA_ID_PIECE" path="/n:PosteComptable/n:Piece/@IdPiece" datatype="integer"/>
+ <sql-index id="refComptaExerRattach" table="TBL_LIGNEERAR_IX" column="REF_COMPTA_EXER_RATTACH" path="/n:PosteComptable/n:Piece/@ExerRattach" datatype="integer"/>
+ <sql-index id="refComptaIdLigne" table="TBL_LIGNEERAR_IX" column="REF_COMPTA_ID_LIGNE" path="/n:PosteComptable/n:Piece/n:LigneERAR/@IdLigne" datatype="integer"/>
+ <sql-index id="refComptaNumFact" table="TBL_LIGNEERAR_IX" column="REF_COMPTA_NUM_FACT" path="/n:PosteComptable/n:Piece/n:LigneERAR/@NumFact" datatype="string" format="uppercase"/>
+ <sql-index id="refComptaCodePeriode" table="TBL_LIGNEERAR_IX" column="REF_COMPTA_CODE_PERIODE" path="/n:PosteComptable/n:Piece/n:LigneERAR/@CodePeriode" datatype="string" format="uppercase"/>
+ <sql-index id="refComptaCodProd" table="TBL_LIGNEERAR_IX" column="REF_COMPTA_COD_PROD" path="/n:PosteComptable/n:Piece/n:LigneERAR/@CodProduit" datatype="string" format="uppercase"/>
+ <sql-index id="refComptaLibProd" table="TBL_LIGNEERAR_IX" column="REF_COMPTA_LIB_PROD" path="/n:PosteComptable/n:Piece/n:LigneERAR/@LibProduit" datatype="string" format="uppercase"/>
+ <sql-index id="refComptaDateEmissionPce" table="TBL_LIGNEERAR_IX" column="REF_COMPTA_DATE_EMISSION_PCE" path="/n:PosteComptable/n:Piece/@DateEmissionPiece" datatype="date" format="yyyy-MM-dd"/>
+ <sql-index id="debIdTiers" table="TBL_LIGNEERAR_IX" column="DEB_ID_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@IdTiers" datatype="string" format="uppercase"/>
+ <sql-index id="debDateMalade" table="TBL_LIGNEERAR_IX" column="DEB_DATE_MALADE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@DteMalade" datatype="date" format="yyyy-MM-dd"/>
+ <sql-index id="debTypTiers" table="TBL_LIGNEERAR_IX" column="DEB_TYP_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@TypTiers" datatype="string"/>
+ <sql-index id="debNatIdTiers" table="TBL_LIGNEERAR_IX" column="DEB_NAT_ID_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@NatIdTiers" datatype="string"/>
+ <sql-index id="debDateIdTiers" table="TBL_LIGNEERAR_IX" column="DEB_DATE_ID_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@DteIdTiers" datatype="date" format="yyyy-MM-dd"/>
+ <sql-index id="debRefTiers" table="TBL_LIGNEERAR_IX" column="DEB_REF_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@RefTiers" datatype="string" format="uppercase"/>
+ <sql-index id="debCatTiers" table="TBL_LIGNEERAR_IX" column="DEB_CAT_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@CatTiers" datatype="string"/>
+ <sql-index id="debNatJur" table="TBL_LIGNEERAR_IX" column="DEB_NAT_JUR" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@NatJur" datatype="string"/>
+ <sql-index id="debCivilite" table="TBL_LIGNEERAR_IX" column="DEB_CIVILITE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@Civilite" datatype="string" format="uppercase"/>
+ <sql-index id="debNom" table="TBL_LIGNEERAR_IX" column="DEB_NOM" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@Nom" datatype="string" format="uppercase"/>
+ <sql-index id="debComplNom" table="TBL_LIGNEERAR_IX" column="DEB_COMPLNOM" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@ComplNom" datatype="string" format="uppercase"/>
+ <sql-index id="debPrenom" table="TBL_LIGNEERAR_IX" column="DEB_PRENOM" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@Prenom" datatype="string" format="uppercase"/>
+ <sql-index id="debAdr1" table="TBL_LIGNEERAR_IX" column="DEB_ADR1" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@Adr1" datatype="string" format="uppercase"/>
+ <sql-index id="debAdr2" table="TBL_LIGNEERAR_IX" column="DEB_ADR2" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@Adr2" datatype="string" format="uppercase"/>
+ <sql-index id="debAdr3" table="TBL_LIGNEERAR_IX" column="DEB_ADR3" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@Adr3" datatype="string" format="uppercase"/>
+ <sql-index id="debCp" table="TBL_LIGNEERAR_IX" column="DEB_CP" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@CP" datatype="string" format="uppercase"/>
+ <sql-index id="debVille" table="TBL_LIGNEERAR_IX" column="DEB_VILLE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@Ville" datatype="string" format="uppercase"/>
+ <sql-index id="debCodPays" table="TBL_LIGNEERAR_IX" column="DEB_CODPAYS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@CodPays" datatype="string" format="uppercase"/>
+ <sql-index id="debDateAdr" table="TBL_LIGNEERAR_IX" column="DEB_DATE_ADR" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@DteAdr" datatype="date" format="yyyy-MM-dd"/>
+ <sql-index id="debNpai" table="TBL_LIGNEERAR_IX" column="DEB_NPAI" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@added:NPAI-normalized" datatype="boolean"/>
+ <sql-index id="debRefAllocataire" table="TBL_LIGNEERAR_IX" column="DEB_REF_ALLOCATAIRE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Debiteur/@RefAllocataire" datatype="string" format="uppercase"/>
+ <sql-index id="assIdTiers" table="TBL_LIGNEERAR_IX" column="ASS_ID_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Assure/@IdTiers" datatype="string" format="uppercase"/>
+ <sql-index id="assDateMalade" table="TBL_LIGNEERAR_IX" column="ASS_DATE_MALADE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Assure/@DteMalade" datatype="date" format="yyyy-MM-dd"/>
+ <sql-index id="assTypTiers" table="TBL_LIGNEERAR_IX" column="ASS_TYP_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Assure/@TypTiers" datatype="string"/>
+ <sql-index id="assNatIdTiers" table="TBL_LIGNEERAR_IX" column="ASS_NAT_ID_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Assure/@NatIdTiers" datatype="string"/>
+ <sql-index id="assDateIdTiers" table="TBL_LIGNEERAR_IX" column="ASS_DATE_ID_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Assure/@DteIdTiers" datatype="date" format="yyyy-MM-dd"/>
+ <sql-index id="assRefTiers" table="TBL_LIGNEERAR_IX" column="ASS_REF_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Assure/@RefTiers" datatype="string" format="uppercase"/>
+ <sql-index id="assCatTiers" table="TBL_LIGNEERAR_IX" column="ASS_CAT_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Assure/@CatTiers" datatype="string"/>
+ <sql-index id="assNatJur" table="TBL_LIGNEERAR_IX" column="ASS_NAT_JUR" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Assure/@NatJur" datatype="string"/>
+ <sql-index id="assCivilite" table="TBL_LIGNEERAR_IX" column="ASS_CIVILITE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Assure/@Civilite" datatype="string" format="uppercase"/>
+ <sql-index id="assNom" table="TBL_LIGNEERAR_IX" column="ASS_NOM" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Assure/@Nom" datatype="string" format="uppercase"/>
+ <sql-index id="assComplNom" table="TBL_LIGNEERAR_IX" column="ASS_COMPLNOM" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Assure/@ComplNom" datatype="string" format="uppercase"/>
+ <sql-index id="assPrenom" table="TBL_LIGNEERAR_IX" column="ASS_PRENOM" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Assure/@Prenom" datatype="string" format="uppercase"/>
+ <sql-index id="malIdTiers" table="TBL_LIGNEERAR_IX" column="MAL_ID_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Malade/@IdTiers" datatype="string" format="uppercase"/>
+ <sql-index id="malDateMalade" table="TBL_LIGNEERAR_IX" column="MAL_DATE_MALADE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Malade/@DteMalade" datatype="date" format="yyyy-MM-dd"/>
+ <sql-index id="malTypTiers" table="TBL_LIGNEERAR_IX" column="MAL_TYP_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Malade/@TypTiers" datatype="string"/>
+ <sql-index id="malNatIdTiers" table="TBL_LIGNEERAR_IX" column="MAL_NAT_ID_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Malade/@NatIdTiers" datatype="string"/>
+ <sql-index id="malDateIdTiers" table="TBL_LIGNEERAR_IX" column="MAL_DATE_ID_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Malade/@DteIdTiers" datatype="date" format="yyyy-MM-dd"/>
+ <sql-index id="malRefTiers" table="TBL_LIGNEERAR_IX" column="MAL_REF_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Malade/@RefTiers" datatype="string" format="uppercase"/>
+ <sql-index id="malCatTiers" table="TBL_LIGNEERAR_IX" column="MAL_CAT_TIERS" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Malade/@CatTiers" datatype="string"/>
+ <sql-index id="malNatJur" table="TBL_LIGNEERAR_IX" column="MAL_NAT_JUR" path="/n:PES_Restit/n:PES_ERAR/n:LigneERAR/n:Malade/n:InfoTiers/n:NatJur/@V" datatype="string"/>
+ <sql-index id="malCivilite" table="TBL_LIGNEERAR_IX" column="MAL_CIVILITE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Malade/@Civilite" datatype="string" format="uppercase"/>
+ <sql-index id="malNom" table="TBL_LIGNEERAR_IX" column="MAL_NOM" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Malade/@Nom" datatype="string" format="uppercase"/>
+ <sql-index id="malComplNom" table="TBL_LIGNEERAR_IX" column="MAL_COMPLNOM" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Malade/@ComplNom" datatype="string" format="uppercase"/>
+ <sql-index id="malPrenom" table="TBL_LIGNEERAR_IX" column="MAL_PRENOM" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Malade/@Prenom" datatype="string" format="uppercase"/>
+ <sql-index id="malDateEntree" table="TBL_LIGNEERAR_IX" column="MAL_DATE_ENTREE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Malade/@DateEntree" datatype="date" format="yyyy-MM-dd"/>
+ <sql-index id="malDateSortie" table="TBL_LIGNEERAR_IX" column="MAL_DATE_SORTIE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Malade/@DateSorite" datatype="date" format="yyyy-MM-dd"/>
+ <sql-index id="malNumEntree" table="TBL_LIGNEERAR_IX" column="MAL_NUM_ENTREE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Malade/@NumEntree" datatype="string" format="uppercase"/>
+ <sql-index id="mtPrinc" table="TBL_LIGNEERAR_IX" column="MT_PRINC" path="/n:PosteComptable/n:Piece/n:LigneERAR/@MtPrincipal" datatype="decimal"/>
+ <sql-index id="mtFrais" table="TBL_LIGNEERAR_IX" column="MT_FRAIS" path="/n:PosteComptable/n:Piece/n:LigneERAR/@MtFrais" datatype="decimal"/>
+ <sql-index id="RarPrinc" table="TBL_LIGNEERAR_IX" column="RAR_PRINC" path="/n:PosteComptable/n:Piece/n:LigneERAR/@RarPrincipal" datatype="decimal"/>
+ <sql-index id="RarFrais" table="TBL_LIGNEERAR_IX" column="RAR_FRAIS" path="/n:PosteComptable/n:Piece/n:LigneERAR/@RarFrais" datatype="decimal"/>
+ <sql-index id="datePrescription" table="TBL_LIGNEERAR_IX" column="DATE_PRESCRIPTION" path="/n:PosteComptable/n:Piece/n:LigneERAR/@DatePrescription" datatype="date" format="yyyy-MM-dd"/>
+ <sql-index id="dateAdmissionNV" table="TBL_LIGNEERAR_IX" column="DATE_ADMISSION_NV" path="/n:PosteComptable/n:Piece/n:LigneERAR/@DateAdmissionNV" datatype="date" format="yyyy-MM-dd"/>
+ <sql-index id="mtNv" table="TBL_LIGNEERAR_IX" column="MT_NV" path="/n:PosteComptable/n:Piece/n:LigneERAR/@MtNV" datatype="decimal"/>
+ <sql-index id="dateMajoration" table="TBL_LIGNEERAR_IX" column="DATE_MAJORATION" path="/n:PosteComptable/n:Piece/n:LigneERAR/@DateMajoration" datatype="date" format="yyyy-MM-dd"/>
+ <sql-index id="codProdLocal" table="TBL_LIGNEERAR_IX" column="COD_PROD_LOCAL" path="/n:PosteComptable/n:Piece/n:LigneERAR/@CodProdLocal" datatype="string" format="uppercase"/>
+ <sql-index id="etabGeo" table="TBL_LIGNEERAR_IX" column="ETAB_GEO" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Malade/@Maison" datatype="string" format="uppercase"/>
+ <sql-index id="dateDebFact" table="TBL_LIGNEERAR_IX" column="DATE_DEB_FACT" path="/n:PosteComptable/n:Piece/n:LigneERAR/@DateDebFact" datatype="date" format="yyyy-MM-dd"/>
+ <sql-index id="dateFinFact" table="TBL_LIGNEERAR_IX" column="DATE_FIN_FACT" path="/n:PosteComptable/n:Piece/n:LigneERAR/@DateFinFact" datatype="date" format="yyyy-MM-dd"/>
+ <sql-index id="objetPiece" table="TBL_LIGNEERAR_IX" column="OBJET_PIECE" path="/n:PosteComptable/n:Piece/n:LigneERAR/@ObjetPiece" datatype="string" format="uppercase"/>
+
+ <sql-index id="empNodeId" table="TBL_ERAR_EMPECHEMENT_IX" column="NODE_ID" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Empechement/@added:generated-id" datatype="string"/>
+ <sql-index id="empCodEmp" table="TBL_ERAR_EMPECHEMENT_IX" column="CODEMP" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Empechement/@Code" datatype="string" format="uppercase"/>
+ <sql-index id="empDateDebEmp" table="TBL_ERAR_EMPECHEMENT_IX" column="DATE_DEBUT_EMP" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Empechement/@DateDebut" datatype="date" format="yyyy-MM-dd"/>
+ <sql-index id="empDateFinEmp" table="TBL_ERAR_EMPECHEMENT_IX" column="DATE_FIN_EMP" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Empechement/@DateFin" datatype="date" format="yyyy-MM-dd"/>
+
+ <sql-index id="etpNodeId" table="TBL_ERAR_ETAPE_IX" column="NODE_ID" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@added:generated-id" datatype="string"/>
+ <sql-index id="etpCodeEtape" table="TBL_ERAR_ETAPE_IX" column="CODE_ETAPE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@CodeEtape" datatype="string"/>
+ <sql-index id="etpDateEtape" table="TBL_ERAR_ETAPE_IX" column="DATE_ETAPE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@DateEtape" datatype="date" format="yyyy-MM-dd"/>
+ <sql-index id="etpDateAnnulation" table="TBL_ERAR_ETAPE_IX" column="DATE_ANNULATION" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@DateAnnulation" datatype="date" format="yyyy-MM-dd"/>
+ <sql-index id="etpCodeActu" table="TBL_ERAR_ETAPE_IX" column="CODE_ACTU" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@CodeActu" datatype="string" format="uppercase"/>
+ <sql-index id="etpDateActu" table="TBL_ERAR_ETAPE_IX" column="DATE_ACTU" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@DateActu" datatype="date" format="yyyy-MM-dd"/>
+ <sql-index id="etpRefActe" table="TBL_ERAR_ETAPE_IX" column="REF_ACTE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@RefActe" datatype="string" format="uppercase"/>
+ <sql-index id="etpDateDemandeActe" table="TBL_ERAR_ETAPE_IX" column="DATE_DEMANDE_ACTE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@DateDemandeActe" datatype="date" format="yyyy-MM-dd"/>
+ <sql-index id="etpDateEnvoiActe" table="TBL_ERAR_ETAPE_IX" column="DATE_ENVOI_ACTE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@DateEnvoiActe" datatype="date" format="yyyy-MM-dd"/>
+ <sql-index id="etpDateAutomate" table="TBL_ERAR_ETAPE_IX" column="DATE_AUTOMATE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@DateAutomate" datatype="date" format="yyyy-MM-dd"/>
+ <sql-index id="etpDateRemiseActe" table="TBL_ERAR_ETAPE_IX" column="DATE_REMISE_ACTE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@DateRemiseActe" datatype="date" format="yyyy-MM-dd"/>
+ <sql-index id="etpEtatValidation" table="TBL_ERAR_ETAPE_IX" column="ETAT_VALIDATION" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@ValiditeEtape" datatype="string"/>
+ <sql-index id="etpEtatEtape" table="TBL_ERAR_ETAPE_IX" column="ETAT_ETAPE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@EtatEtape" datatype="string"/>
+ <sql-index id="etpNumActePoursuite" table="TBL_ERAR_ETAPE_IX" column="NUM_ACTE_POURSUITE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@RefActe" datatype="string" format="uppercase"/>
+ <sql-index id="etpMtActePoursuite" table="TBL_ERAR_ETAPE_IX" column="MT_ACTE_POURSUITE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@MtActe" datatype="decimal"/>
+ <sql-index id="etpMtEtape" table="TBL_ERAR_ETAPE_IX" column="MT_ETAPE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@MtEtape" datatype="decimal"/>
+ <sql-index id="etpMtFraisEtape" table="TBL_ERAR_ETAPE_IX" column="MT_FRAIS_ETAPE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@MtFraisEtape" datatype="decimal"/>
+ <sql-index id="etpOrigineEtape" table="TBL_ERAR_ETAPE_IX" column="ORIGINE_ETAPE" path="/n:PosteComptable/n:Piece/n:LigneERAR/n:Etape/@OrigineEtape" datatype="string"/>
+
+ <element id="PES_RESTIT_PES_ERAR_LIGNEERAR_EMPECHEMENT_IX">
+ <sql-count>COUNT(DISTINCT(CONCAT(PES_RESTIT_PES_ERAR_LIGNEERAR_IX.DOC_ID,PES_RESTIT_PES_ERAR_LIGNEERAR_EMPECHEMENT_IX.NODE_ID)))</sql-count>
+ <special-cond>PES_RESTIT_PES_ERAR_LIGNEERAR_EMPECHEMENT_IX.NODE_ID IS NOT NULL</special-cond>
+ </element>
+ <element id="PES_RESTIT_PES_ERAR_LIGNEERAR_ETAPE_IX">
+ <sql-count>COUNT(DISTINCT(CONCAT(PES_RESTIT_PES_ERAR_LIGNEERAR_IX.DOC_ID,PES_RESTIT_PES_ERAR_LIGNEERAR_ETAPE_IX.NODE_ID)))</sql-count>
+ <special-cond>PES_RESTIT_PES_ERAR_LIGNEERAR_ETAPE_IX.NODE_ID IS NOT NULL</special-cond>
+ </element>
+
+ </etat>
+ </document>
+ </layer>
+</persistence-config>
+