<?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">
        <!-- persistence-model defines the way informations are defined -->
        <!-- only xemelios-sql is defined at this moment -->
        <document id="DocDPDirecte" repository-import-xslt-file="">
            <table type="repository" base-name="FEN0029A_REPOSITORY" version="2">
                CREATE TABLE IF NOT EXISTS ${base-name} ( ID VARCHAR(25), LIBELLE VARCHAR(100), COLLECTIVITE VARCHAR(15) NOT NULL, REPOSITORY LONGBLOB, ENCODING VARCHAR(20) ) TYPE MYISAM <patch from-version="1">
                    <sql failonerror="false">ALTER TABLE ${base-name} ADD ID VARCHAR(25)</sql>
                    <sql failonerror="false">ALTER TABLE ${base-name} ADD LIBELLE VARCHAR(100)</sql>
                </patch>
            </table>
            <table type="special-key" base-name="FEN0029A_SPECIAL_KEYS" version="1"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE VARCHAR(15) NOT NULL, BUDGET VARCHAR(24) NOT NULL, INITIAL_DOC_NAME VARCHAR(100) NOT NULL, KEY1 VARCHAR(100) NOT NULL, LIB1 VARCHAR(200), KEY2 VARCHAR(100), LIB2 VARCHAR(200), KEY3 VARCHAR(100), LIB3 VARCHAR(200), INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET) ) TYPE MYISAM </table>
            <table type="list-bc" base-name="FEN0029A_LIST_BUDG_COLL" version="1"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE VARCHAR(15) NOT NULL, BUDGET VARCHAR(24) NOT NULL, BUDGET_LIB VARCHAR(200), COLLECTIVITE_LIB VARCHAR(200), INITIAL_DOC_NAME VARCHAR(100) NOT NULL, INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET) ) TYPE MYISAM </table>

            <etat id="FEN0029A" import-xslt-file="fen0029a/etatFen0029a-import-mysql.xsl">
                <key1>
                    <path>/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:LIGNE_CHARGE/@added:generated-id</path>
                </key1>

                <table type="document" base-name="FEN0029A_DP_DIRECTE_DOCUMENTS" version="1">
                    CREATE TABLE IF NOT EXISTS ${base-name} ( 
                        COLLECTIVITE VARCHAR(15) NOT NULL, 
                        BUDGET VARCHAR(24) NOT NULL, 
                        INITIAL_DOC_NAME VARCHAR(100) NOT NULL, 
                        DOC_ID VARCHAR(100) NOT NULL, 
                        DOC LONGBLOB, 
                        ENCODING VARCHAR(20), 
                        INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID) ) TYPE MYISAM </table>
                
                <table type="index" id="FEN0029A_DP_DIRECTE_IX" base-name="FEN0029A_DP_DIRECTE_IX" 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, 
                        NODE_ID VARCHAR(50) NOT NULL, 
                        CITY VARCHAR(35) , 
                        CODE_PAYS_OSD VARCHAR(14) ,
                        TRANS_DATE VARCHAR(255) ,
                        TYPE_DP VARCHAR(2) , 
                        CTRL_KEY VARCHAR(2) , 
                        CODE_APPLI VARCHAR(6) , 
                        CP VARCHAR(10) , 
                        INITIATEUR VARCHAR(12) , 
                        DOC_DATE VARCHAR(255) , 
                        TYPE_TIERS VARCHAR(4) , 
                        COUNTRY VARCHAR(2) , 
                        BANK_CTRY VARCHAR(2) , 
                        VALIDEUR_DP VARCHAR(50) ,                     
                        BUS_AREA VARCHAR(4) , 
                        RAISON_BR VARCHAR(2) , 
                        ID_AE VARCHAR(12) , 
                        ID_UNIQUE VARCHAR(75),
                        DELAI_BR VARCHAR(4) , 
                        DESCRIPTION VARCHAR(50) , 
                        ID_CHORUS_TIERS VARCHAR(10) , 
                        CODE_IBAN VARCHAR(34) , 
                        RECEPT_DATE_BR VARCHAR(255) , 
                        REF_DOC_NO_FOUR VARCHAR(25) , 
                        PMNTTRMS VARCHAR(4) , 
                        BANK_ACCT VARCHAR(18) , 
                        SIRET_CPD VARCHAR(14) , 
                        BANK_NO VARCHAR(15) , 
                        NAME4 VARCHAR(35) , 
                        NAME3 VARCHAR(35) , 
                        CODE_INTERETS VARCHAR(2) , 
                        NAME2 VARCHAR(35) , 
                        ID_FONCT_TIERS VARCHAR(80) , 
                        NAME1 VARCHAR(35) , 
                        PAYMT_REF VARCHAR(30) ,
                        CURRENCY  VARCHAR(3) , 
                        COMP_CODE VARCHAR(4) , 
                        FILLER250 VARCHAR(250) , 
                        STREET VARCHAR(35) , 
                        BASE_DATE VARCHAR(255) , 
                        PYMT_METH VARCHAR(1) , 
                        INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), 
                        INDEX IX_${base-name}_DC (DOC_ID) ) TYPE MYISAM
                  
                    <patch from-version="1">  
                    <sql failonerror="false">ALTER TABLE ${base-name} ADD ID_UNIQUE VARCHAR(75)</sql>
                    </patch>
                    <patch from-version="2">  
                        <sql failonerror="false">ALTER TABLE ${base-name} ADD PAYMT_REF VARCHAR(30)</sql>
                        <sql failonerror="false">ALTER TABLE ${base-name} ADD CODE_PAYS_OSD VARCHAR(14)</sql>
                        <sql failonerror="false">ALTER TABLE ${base-name} ADD TRANS_DATE VARCHAR(255)</sql>
                        <sql failonerror="false">ALTER TABLE ${base-name} ADD VALIDEUR_DP VARCHAR(50)</sql>
                    </patch>
                </table>
                
                <table type="index" id="LIGNE_CHARGE_IX" base-name="FEN0029A_LIGNE_CHARGE_IX" version="2" 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, 
                        T_FONC VARCHAR(24) , 
                        ACTIVITE VARCHAR(24) , 
                        ASSET_NO VARCHAR(12) ,
                        VALUE_DATE VARCHAR(255) ,  
                        ALLOC_NMBR VARCHAR(18) ,
                        CODE_MVT_IMMO VARCHAR(3) ,
                        SUB_NUMBER VARCHAR(4) ,
                        PROJ_ANA_MINIST VARCHAR(22) , 
                        FUNC_AREA VARCHAR(16) , 
                        COSTCENTER VARCHAR(10) , 
                        ITEM_TEXT VARCHAR(50) , 
                        ID_AE VARCHAR(12) , 
                        NATURE_MINIST VARCHAR(11) , 
                        LOCAL_MINIST VARCHAR(22) , 
                        MONTANT VARCHAR(25) , 
                        WBS_ELEM_E VARCHAR(24) , 
                        FUND VARCHAR(10) ,
                        AXE_2 VARCHAR(22) , 
                        AXE_1 VARCHAR(22) , 
                        LOCAL_INTER_MINIST VARCHAR(8) , 
                        NUM_LIGNE VARCHAR(6) , 
                        GL_ACCOUNT VARCHAR(10) , 
                        PRESAGE VARCHAR(15) , 
                        FILLER250 VARCHAR(250) , 
                        TAX_CODE VARCHAR(2) , 
                        CPER VARCHAR(15) , 
                        FUNDS_CTR VARCHAR(16) , 
                        INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), 
                        INDEX IX_${base-name}_DC (DOC_ID) )
                   
                    <patch from-version="1">  
                        <sql failonerror="false">ALTER TABLE ${base-name} ADD ASSET_NO VARCHAR(12)</sql>
                        <sql failonerror="false">ALTER TABLE ${base-name} ADD SUB_NUMBER VARCHAR(4)</sql>
                        <sql failonerror="false">ALTER TABLE ${base-name} ADD CODE_MVT_IMMO VARCHAR(3)</sql>
                        <sql failonerror="false">ALTER TABLE ${base-name} ADD ALLOC_NMBR VARCHAR(18)</sql>
                        <sql failonerror="false">ALTER TABLE ${base-name} ADD VALUE_DATE VARCHAR(255)</sql>
                    </patch>
                        
                        TYPE MYISAM </table>

              
                <!-- CRITERIA /DP_DIRECTE -->
                <criteria id="CRI_DP_DIRECTE_CITY" type="1" sql-index-id="SQI_DP_DIRECTE_CITY">
                    <where-clause>fn:string-compare(${table}.${column},CITY)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_CODE_PAYS_OSD" type="1" sql-index-id="SQI_DP_DIRECTE_CODE_PAYS_OSD">
                    <where-clause>fn:string-compare(${table}.${column},CODE_PAYS_OSD)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_TRANS_DATE" type="1" sql-index-id="SQI_DP_DIRECTE_TRANS_DATE">
                    <where-clause>fn:string-compare(${table}.${column},TRANS_DATE)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_TYPE_DP" type="1" sql-index-id="SQI_DP_DIRECTE_TYPE_DP">
                    <where-clause>fn:string-compare(${table}.${column},TYPE_DP)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_CTRL_KEY" type="1" sql-index-id="SQI_DP_DIRECTE_CTRL_KEY">
                    <where-clause>fn:string-compare(${table}.${column},CTRL_KEY)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_CODE_APPLI" type="1" sql-index-id="SQI_DP_DIRECTE_CODE_APPLI">
                    <where-clause>fn:string-compare(${table}.${column},CODE_APPLI)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_CP" type="1" sql-index-id="SQI_DP_DIRECTE_CP">
                    <where-clause>fn:string-compare(${table}.${column},CP)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_INITIATEUR" type="1" sql-index-id="SQI_DP_DIRECTE_INITIATEUR">
                    <where-clause>fn:string-compare(${table}.${column},INITIATEUR)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_DOC_DATE" type="1" sql-index-id="SQI_DP_DIRECTE_DOC_DATE">
                    <where-clause>fn:string-compare(${table}.${column},DOC_DATE)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_TYPE_TIERS" type="1" sql-index-id="SQI_DP_DIRECTE_TYPE_TIERS">
                    <where-clause>fn:string-compare(${table}.${column},TYPE_TIERS)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_COUNTRY" type="1" sql-index-id="SQI_DP_DIRECTE_COUNTRY">
                    <where-clause>fn:string-compare(${table}.${column},COUNTRY)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_BANK_CTRY" type="1" sql-index-id="SQI_DP_DIRECTE_BANK_CTRY">
                    <where-clause>fn:string-compare(${table}.${column},BANK_CTRY)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_VALIDEUR_DP" type="1" sql-index-id="SQI_DP_DIRECTE_VALIDEUR_DP">
                    <where-clause>fn:string-compare(${table}.${column},VALIDEUR_DP)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_BUS_AREA" type="1" sql-index-id="SQI_DP_DIRECTE_BUS_AREA">
                    <where-clause>fn:string-compare(${table}.${column},BUS_AREA)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_RAISON_BR" type="1" sql-index-id="SQI_DP_DIRECTE_RAISON_BR">
                    <where-clause>fn:string-compare(${table}.${column},RAISON_BR)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_ID_AE" type="1" sql-index-id="SQI_DP_DIRECTE_ID_AE">
                    <where-clause>fn:string-compare(${table}.${column},ID_AE)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_DELAI_BR" type="1" sql-index-id="SQI_DP_DIRECTE_DELAI_BR">
                    <where-clause>fn:string-compare(${table}.${column},DELAI_BR)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_DESCRIPTION" type="1" sql-index-id="SQI_DP_DIRECTE_DESCRIPTION">
                    <where-clause>fn:string-compare(${table}.${column},DESCRIPTION)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_ID_CHORUS_TIERS" type="1" sql-index-id="SQI_DP_DIRECTE_ID_CHORUS_TIERS">
                    <where-clause>fn:string-compare(${table}.${column},ID_CHORUS_TIERS)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_CODE_IBAN" type="1" sql-index-id="SQI_DP_DIRECTE_CODE_IBAN">
                    <where-clause>fn:string-compare(${table}.${column},CODE_IBAN)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_RECEPT_DATE_BR" type="1" sql-index-id="SQI_DP_DIRECTE_RECEPT_DATE_BR">
                    <where-clause>fn:string-compare(${table}.${column},RECEPT_DATE_BR)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_REF_DOC_NO_FOUR" type="1" sql-index-id="SQI_DP_DIRECTE_REF_DOC_NO_FOUR">
                    <where-clause>fn:string-compare(${table}.${column},REF_DOC_NO_FOUR)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_PMNTTRMS" type="1" sql-index-id="SQI_DP_DIRECTE_PMNTTRMS">
                    <where-clause>fn:string-compare(${table}.${column},PMNTTRMS)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_BANK_ACCT" type="1" sql-index-id="SQI_DP_DIRECTE_BANK_ACCT">
                    <where-clause>fn:string-compare(${table}.${column},BANK_ACCT)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_SIRET_CPD" type="1" sql-index-id="SQI_DP_DIRECTE_SIRET_CPD">
                    <where-clause>fn:string-compare(${table}.${column},SIRET_CPD)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_BANK_NO" type="1" sql-index-id="SQI_DP_DIRECTE_BANK_NO">
                    <where-clause>fn:string-compare(${table}.${column},BANK_NO)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_NAME4" type="1" sql-index-id="SQI_DP_DIRECTE_NAME4">
                    <where-clause>fn:string-compare(${table}.${column},NAME4)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_NAME3" type="1" sql-index-id="SQI_DP_DIRECTE_NAME3">
                    <where-clause>fn:string-compare(${table}.${column},NAME3)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_CODE_INTERETS" type="1" sql-index-id="SQI_DP_DIRECTE_CODE_INTERETS">
                    <where-clause>fn:string-compare(${table}.${column},CODE_INTERETS)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_NAME2" type="1" sql-index-id="SQI_DP_DIRECTE_NAME2">
                    <where-clause>fn:string-compare(${table}.${column},NAME2)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_ID_FONCT_TIERS" type="1" sql-index-id="SQI_DP_DIRECTE_ID_FONCT_TIERS">
                    <where-clause>fn:string-compare(${table}.${column},ID_FONCT_TIERS)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_NAME1" type="1" sql-index-id="SQI_DP_DIRECTE_NAME1">
                    <where-clause>fn:string-compare(${table}.${column},NAME1)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_PAYMT_REF" type="1" sql-index-id="SQI_DP_DIRECTE_PAYMT_REF">
                    <where-clause>fn:string-compare(${table}.${column},PAYMT_REF)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_CURRENCY" type="1" sql-index-id="SQI_DP_DIRECTE_CURRENCY">
                    <where-clause>fn:string-compare(${table}.${column},CURRENCY)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_COMP_CODE" type="1" sql-index-id="SQI_DP_DIRECTE_COMP_CODE">
                    <where-clause>fn:string-compare(${table}.${column},COMP_CODE)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_FILLER250" type="1" sql-index-id="SQI_DP_DIRECTE_FILLER250">
                    <where-clause>fn:string-compare(${table}.${column},FILLER250)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_STREET" type="1" sql-index-id="SQI_DP_DIRECTE_STREET">
                    <where-clause>fn:string-compare(${table}.${column},STREET)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_BASE_DATE" type="1" sql-index-id="SQI_DP_DIRECTE_BASE_DATE">
                    <where-clause>fn:string-compare(${table}.${column},BASE_DATE)</where-clause>
                </criteria>
                <criteria id="CRI_DP_DIRECTE_PYMT_METH" type="1" sql-index-id="SQI_DP_DIRECTE_PYMT_METH">
                    <where-clause>fn:string-compare(${table}.${column},PYMT_METH)</where-clause>
                </criteria>

                <!-- CRITERIA /DP_DIRECTE/LIGNE_CHARGE -->
                <criteria id="CRI_LIGNE_CHARGE_T_FONC" type="1" sql-index-id="SQI_LIGNE_CHARGE_T_FONC">
                    <where-clause>fn:string-compare(${table}.${column},T_FONC)</where-clause>
                </criteria>
                <criteria id="CRI_LIGNE_CHARGE_ACTIVITE" type="1" sql-index-id="SQI_LIGNE_CHARGE_ACTIVITE">
                    <where-clause>fn:string-compare(${table}.${column},ACTIVITE)</where-clause>
                </criteria>
                
                <criteria id="CRI_LIGNE_CHARGE_ASSET_NO" type="1" sql-index-id="SQI_LIGNE_CHARGE_ASSET_NO">
                    <where-clause>fn:string-compare(${table}.${column},ASSET_NO)</where-clause>
                </criteria>
                
                <criteria id="CRI_LIGNE_CHARGE_VALUE_DATE" type="1" sql-index-id="SQI_LIGNE_CHARGE_VALUE_DATE">
                    <where-clause>fn:string-compare(${table}.${column},VALUE_DATE)</where-clause>
                </criteria>
                <criteria id="CRI_LIGNE_CHARGE_ALLOC_NMBR" type="1" sql-index-id="SQI_LIGNE_CHARGE_ALLOC_NMBR">
                    <where-clause>fn:string-compare(${table}.${column},ALLOC_NMBR)</where-clause>
                </criteria>
                <criteria id="CRI_LIGNE_CHARGE_CODE_MVT_IMMO" type="1" sql-index-id="SQI_LIGNE_CHARGE_CODE_MVT_IMMO">
                    <where-clause>fn:string-compare(${table}.${column},CODE_MVT_IMMO)</where-clause>
                </criteria>
                <criteria id="CRI_LIGNE_CHARGE_SUB_NUMBER" type="1" sql-index-id="SQI_LIGNE_CHARGE_SUB_NUMBER">
                    <where-clause>fn:string-compare(${table}.${column},SUB_NUMBER)</where-clause>
                </criteria>
                <criteria id="CRI_LIGNE_CHARGE_PROJ_ANA_MINIST" type="1" sql-index-id="SQI_LIGNE_CHARGE_PROJ_ANA_MINIST">
                    <where-clause>fn:string-compare(${table}.${column},PROJ_ANA_MINIST)</where-clause>
                </criteria>
                <criteria id="CRI_LIGNE_CHARGE_FUNC_AREA" type="1" sql-index-id="SQI_LIGNE_CHARGE_FUNC_AREA">
                    <where-clause>fn:string-compare(${table}.${column},FUNC_AREA)</where-clause>
                </criteria>
                <criteria id="CRI_LIGNE_CHARGE_COSTCENTER" type="1" sql-index-id="SQI_LIGNE_CHARGE_COSTCENTER">
                    <where-clause>fn:string-compare(${table}.${column},COSTCENTER)</where-clause>
                </criteria>
                <criteria id="CRI_LIGNE_CHARGE_ITEM_TEXT" type="1" sql-index-id="SQI_LIGNE_CHARGE_ITEM_TEXT">
                    <where-clause>fn:string-compare(${table}.${column},ITEM_TEXT)</where-clause>
                </criteria>
                <criteria id="CRI_LIGNE_CHARGE_ID_AE" type="1" sql-index-id="SQI_LIGNE_CHARGE_ID_AE">
                    <where-clause>fn:string-compare(${table}.${column},ID_AE)</where-clause>
                </criteria>
                <criteria id="CRI_LIGNE_CHARGE_NATURE_MINIST" type="1" sql-index-id="SQI_LIGNE_CHARGE_NATURE_MINIST">
                    <where-clause>fn:string-compare(${table}.${column},NATURE_MINIST)</where-clause>
                </criteria>
                <criteria id="CRI_LIGNE_CHARGE_LOCAL_MINIST" type="1" sql-index-id="SQI_LIGNE_CHARGE_LOCAL_MINIST">
                    <where-clause>fn:string-compare(${table}.${column},LOCAL_MINIST)</where-clause>
                </criteria>
                <criteria id="CRI_LIGNE_CHARGE_MONTANT" type="1" sql-index-id="SQI_LIGNE_CHARGE_MONTANT">
                    <where-clause>fn:string-compare(${table}.${column},MONTANT)</where-clause>
                </criteria>
                <criteria id="CRI_LIGNE_CHARGE_WBS_ELEM_E" type="1" sql-index-id="SQI_LIGNE_CHARGE_WBS_ELEM_E">
                    <where-clause>fn:string-compare(${table}.${column},WBS_ELEM_E)</where-clause>
                </criteria>
                <criteria id="CRI_LIGNE_CHARGE_FUND" type="1" sql-index-id="SQI_LIGNE_CHARGE_FUND">
                    <where-clause>fn:string-compare(${table}.${column},FUND)</where-clause>
                </criteria>
            
                <criteria id="CRI_LIGNE_CHARGE_AXE_2" type="1" sql-index-id="SQI_LIGNE_CHARGE_AXE_2">
                    <where-clause>fn:string-compare(${table}.${column},AXE_2)</where-clause>
                </criteria>
                <criteria id="CRI_LIGNE_CHARGE_AXE_1" type="1" sql-index-id="SQI_LIGNE_CHARGE_AXE_1">
                    <where-clause>fn:string-compare(${table}.${column},AXE_1)</where-clause>
                </criteria>
                <criteria id="CRI_LIGNE_CHARGE_LOCAL_INTER_MINIST" type="1" sql-index-id="SQI_LIGNE_CHARGE_LOCAL_INTER_MINIST">
                    <where-clause>fn:string-compare(${table}.${column},LOCAL_INTER_MINIST)</where-clause>
                </criteria>
                <criteria id="CRI_LIGNE_CHARGE_NUM_LIGNE" type="1" sql-index-id="SQI_LIGNE_CHARGE_NUM_LIGNE">
                    <where-clause>fn:string-compare(${table}.${column},NUM_LIGNE)</where-clause>
                </criteria>
                <criteria id="CRI_LIGNE_CHARGE_GL_ACCOUNT" type="1" sql-index-id="SQI_LIGNE_CHARGE_GL_ACCOUNT">
                    <where-clause>fn:string-compare(${table}.${column},GL_ACCOUNT)</where-clause>
                </criteria>
                <criteria id="CRI_LIGNE_CHARGE_PRESAGE" type="1" sql-index-id="SQI_LIGNE_CHARGE_PRESAGE">
                    <where-clause>fn:string-compare(${table}.${column},PRESAGE)</where-clause>
                </criteria>
                <criteria id="CRI_LIGNE_CHARGE_FILLER250" type="1" sql-index-id="SQI_LIGNE_CHARGE_FILLER250">
                    <where-clause>fn:string-compare(${table}.${column},FILLER250)</where-clause>
                </criteria>
                <criteria id="CRI_LIGNE_CHARGE_TAX_CODE" type="1" sql-index-id="SQI_LIGNE_CHARGE_TAX_CODE">
                    <where-clause>fn:string-compare(${table}.${column},TAX_CODE)</where-clause>
                </criteria>
                <criteria id="CRI_LIGNE_CHARGE_CPER" type="1" sql-index-id="SQI_LIGNE_CHARGE_CPER">
                    <where-clause>fn:string-compare(${table}.${column},CPER)</where-clause>
                </criteria>
                <criteria id="CRI_LIGNE_CHARGE_FUNDS_CTR" type="1" sql-index-id="SQI_LIGNE_CHARGE_FUNDS_CTR">
                    <where-clause>fn:string-compare(${table}.${column},FUNDS_CTR)</where-clause>
                </criteria>


                <!-- SQL-INDEX /DP_DIRECTE -->
                <sql-index id="EF_UNIQUE_ID_IX" table="FEN0029A_DP_DIRECTE_IX" column="ID_UNIQUE" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/@ano:unique-id" datatype="string"/>
                <sql-index id="SQI_DP_DIRECTE__NODE_ID" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/@added:generated-id" column="NODE_ID" datatype="string" table="FEN0029A_DP_DIRECTE_IX"/>
                <sql-index id="SQI_DP_DIRECTE_CITY" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:CITY/text()" datatype="string" column="CITY" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_CODE_PAYS_OSD" path="/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:CODE_PAYS_OSD/text()" datatype="string" column="CODE_PAYS_OSD" table="FEN0029A_DP_DIRECTE_IX" format="uppercase" />
                <sql-index id="SQI_DP_DIRECTE_TRANS_DATE" path="/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:TRANS_DATE/text()" datatype="string" column="TRANS_DATE" table="FEN0029A_DP_DIRECTE_IX" format="uppercase" />
                <sql-index id="SQI_DP_DIRECTE_TYPE_DP" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:TYPE_DP/text()" datatype="string" column="TYPE_DP" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_CTRL_KEY" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:CTRL_KEY/text()" datatype="string" column="CTRL_KEY" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_CODE_APPLI" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:CODE_APPLI/text()" datatype="string" column="CODE_APPLI" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_CP" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:CP/text()" datatype="string" column="CP" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_INITIATEUR" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:INITIATEUR/text()" datatype="string" column="INITIATEUR" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_DOC_DATE" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:DOC_DATE/text()" datatype="string" column="DOC_DATE" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_TYPE_TIERS" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:TYPE_TIERS/text()" datatype="string" column="TYPE_TIERS" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_COUNTRY" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:COUNTRY/text()" datatype="string" column="COUNTRY" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_BANK_CTRY" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:BANK_CTRY/text()" datatype="string" column="BANK_CTRY" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_BUS_AREA" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:BUS_AREA/text()" datatype="string" column="BUS_AREA" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_RAISON_BR" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:RAISON_BR/text()" datatype="string" column="RAISON_BR" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_ID_AE" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:ID_AE/text()" datatype="string" column="ID_AE" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_DELAI_BR" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:DELAI_BR/text()" datatype="string" column="DELAI_BR" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_DESCRIPTION" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:DESCRIPTION/text()" datatype="string" column="DESCRIPTION" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_ID_CHORUS_TIERS" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:ID_CHORUS_TIERS/text()" datatype="string" column="ID_CHORUS_TIERS" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_CODE_IBAN" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:CODE_IBAN/text()" datatype="string" column="CODE_IBAN" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_RECEPT_DATE_BR" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:RECEPT_DATE_BR/text()" datatype="string" column="RECEPT_DATE_BR" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_REF_DOC_NO_FOUR" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:REF_DOC_NO_FOUR/text()" datatype="string" column="REF_DOC_NO_FOUR" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_PMNTTRMS" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:PMNTTRMS/text()" datatype="string" column="PMNTTRMS" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_BANK_ACCT" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:BANK_ACCT/text()" datatype="string" column="BANK_ACCT" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_VALIDEUR_DP" path="/n:FEN0029A/n:DP_DIRECTE/ENTETE/n:VALIDEUR_DP/text()" datatype="string" column="VALIDEUR_DP" table="FEN0029A_DP_DIRECTE_IX" format="uppercase" />
                <sql-index id="SQI_DP_DIRECTE_SIRET_CPD" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:SIRET_CPD/text()" datatype="string" column="SIRET_CPD" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_BANK_NO" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:BANK_NO/text()" datatype="string" column="BANK_NO" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_NAME4" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:NAME4/text()" datatype="string" column="NAME4" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_NAME3" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:NAME3/text()" datatype="string" column="NAME3" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_CODE_INTERETS" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:CODE_INTERETS/text()" datatype="string" column="CODE_INTERETS" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_NAME2" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:NAME2/text()" datatype="string" column="NAME2" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_ID_FONCT_TIERS" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:ID_FONCT_TIERS/text()" datatype="string" column="ID_FONCT_TIERS" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_NAME1" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:NAME1/text()" datatype="string" column="NAME1" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_PAYMT_REF" path="/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:PAYMT_REF/text()" datatype="string" column="PAYMT_REF" table="FEN0029A_DP_DIRECTE_IX" format="uppercase" />
                <sql-index id="SQI_DP_DIRECTE_CURRENCY" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:CURRENCY/text()" datatype="string" column="CURRENCY" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_COMP_CODE" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:COMP_CODE/text()" datatype="string" column="COMP_CODE" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_FILLER250" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:FILLER250/text()" datatype="string" column="FILLER250" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_STREET" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:STREET/text()" datatype="string" column="STREET" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_BASE_DATE" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:BASE_DATE/text()" datatype="string" column="BASE_DATE" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>
                <sql-index id="SQI_DP_DIRECTE_PYMT_METH" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:ENTETE/n:PYMT_METH/text()" datatype="string" column="PYMT_METH" table="FEN0029A_DP_DIRECTE_IX" format="uppercase"/>

                <!-- SQL-INDEX /DP_DIRECTE/LIGNE_CHARGE -->
                <sql-index id="SQI_LIGNE_CHARGE__NODE_ID" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:LIGNE_CHARGE/@added:generated-id" column="NODE_ID" datatype="string" table="LIGNE_CHARGE_IX"/>
                <sql-index id="SQI_LIGNE_CHARGE_T_FONC" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:LIGNE_CHARGE/n:T_FONC/text()" datatype="string" column="T_FONC" table="LIGNE_CHARGE_IX" format="uppercase"/>
                <sql-index id="SQI_LIGNE_CHARGE_ACTIVITE" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:LIGNE_CHARGE/n:ACTIVITE/text()" datatype="string" column="ACTIVITE" table="LIGNE_CHARGE_IX" format="uppercase"/>
                <sql-index id="SQI_LIGNE_CHARGE_ASSET_NO" path="/n:FEN0029A/n:DP_DIRECTE/n:LIGNE_CHARGE/n:ASSET_NO/text()" datatype="string" column="ASSET_NO" table="LIGNE_CHARGE_IX" format="uppercase" />
                <sql-index id="SQI_LIGNE_CHARGE_VALUE_DATE" path="/n:FEN0029A/n:DP_DIRECTE/n:LIGNE_CHARGE/n:VALUE_DATE/text()" datatype="string" column="VALUE_DATE" table="LIGNE_CHARGE_IX" format="uppercase" />
                <sql-index id="SQI_LIGNE_CHARGE_ALLOC_NMBR" path="/n:FEN0029A/n:DP_DIRECTE/n:LIGNE_CHARGE/n:ALLOC_NMBR/text()" datatype="string" column="ALLOC_NMBR" table="LIGNE_CHARGE_IX" format="uppercase" />
                <sql-index id="SQI_LIGNE_CHARGE_CODE_MVT_IMMO" path="/n:FEN0029A/n:DP_DIRECTE/n:LIGNE_CHARGE/n:CODE_MVT_IMMO/text()" datatype="string" column="CODE_MVT_IMMO" table="LIGNE_CHARGE_IX" format="uppercase" />
                <sql-index id="SQI_LIGNE_CHARGE_SUB_NUMBER" path="/n:FEN0029A/n:DP_DIRECTE/n:LIGNE_CHARGE/n:SUB_NUMBER/text()" datatype="string" column="SUB_NUMBER" table="LIGNE_CHARGE_IX" format="uppercase" />
                <sql-index id="SQI_LIGNE_CHARGE_PROJ_ANA_MINIST" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:LIGNE_CHARGE/n:PROJ_ANA_MINIST/text()" datatype="string" column="PROJ_ANA_MINIST" table="LIGNE_CHARGE_IX" format="uppercase"/>  
                <sql-index id="SQI_LIGNE_CHARGE_FUNC_AREA" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:LIGNE_CHARGE/n:FUNC_AREA/text()" datatype="string" column="FUNC_AREA" table="LIGNE_CHARGE_IX" format="uppercase"/>
                <sql-index id="SQI_LIGNE_CHARGE_COSTCENTER" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:LIGNE_CHARGE/n:COSTCENTER/text()" datatype="string" column="COSTCENTER" table="LIGNE_CHARGE_IX" format="uppercase"/>
                <sql-index id="SQI_LIGNE_CHARGE_ITEM_TEXT" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:LIGNE_CHARGE/n:ITEM_TEXT/text()" datatype="string" column="ITEM_TEXT" table="LIGNE_CHARGE_IX" format="uppercase"/>
                <sql-index id="SQI_LIGNE_CHARGE_ID_AE" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:LIGNE_CHARGE/n:ID_AE/text()" datatype="string" column="ID_AE" table="LIGNE_CHARGE_IX" format="uppercase"/>
                <sql-index id="SQI_LIGNE_CHARGE_NATURE_MINIST" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:LIGNE_CHARGE/n:NATURE_MINIST/text()" datatype="string" column="NATURE_MINIST" table="LIGNE_CHARGE_IX" format="uppercase"/>
                <sql-index id="SQI_LIGNE_CHARGE_LOCAL_MINIST" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:LIGNE_CHARGE/n:LOCAL_MINIST/text()" datatype="string" column="LOCAL_MINIST" table="LIGNE_CHARGE_IX" format="uppercase"/>
                <sql-index id="SQI_LIGNE_CHARGE_MONTANT" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:LIGNE_CHARGE/n:MONTANT/text()" datatype="string" column="MONTANT" table="LIGNE_CHARGE_IX" format="uppercase"/>
                <sql-index id="SQI_LIGNE_CHARGE_WBS_ELEM_E" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:LIGNE_CHARGE/n:WBS_ELEM_E/text()" datatype="string" column="WBS_ELEM_E" table="LIGNE_CHARGE_IX" format="uppercase"/>
                <sql-index id="SQI_LIGNE_CHARGE_FUND" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:LIGNE_CHARGE/n:FUND/text()" datatype="string" column="FUND" table="LIGNE_CHARGE_IX" format="uppercase"/>
                <sql-index id="SQI_LIGNE_CHARGE_AXE_2" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:LIGNE_CHARGE/n:AXE_2/text()" datatype="string" column="AXE_2" table="LIGNE_CHARGE_IX" format="uppercase"/>
                <sql-index id="SQI_LIGNE_CHARGE_AXE_1" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:LIGNE_CHARGE/n:AXE_1/text()" datatype="string" column="AXE_1" table="LIGNE_CHARGE_IX" format="uppercase"/>
                <sql-index id="SQI_LIGNE_CHARGE_LOCAL_INTER_MINIST" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:LIGNE_CHARGE/n:LOCAL_INTER_MINIST/text()" datatype="string" column="LOCAL_INTER_MINIST" table="LIGNE_CHARGE_IX" format="uppercase"/>
                <sql-index id="SQI_LIGNE_CHARGE_NUM_LIGNE" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:LIGNE_CHARGE/n:NUM_LIGNE/text()" datatype="string" column="NUM_LIGNE" table="LIGNE_CHARGE_IX" format="uppercase"/>
                <sql-index id="SQI_LIGNE_CHARGE_GL_ACCOUNT" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:LIGNE_CHARGE/n:GL_ACCOUNT/text()" datatype="string" column="GL_ACCOUNT" table="LIGNE_CHARGE_IX" format="uppercase"/>
                <sql-index id="SQI_LIGNE_CHARGE_PRESAGE" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:LIGNE_CHARGE/n:PRESAGE/text()" datatype="string" column="PRESAGE" table="LIGNE_CHARGE_IX" format="uppercase"/>
                <sql-index id="SQI_LIGNE_CHARGE_FILLER250" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:LIGNE_CHARGE/n:FILLER250/text()" datatype="string" column="FILLER250" table="LIGNE_CHARGE_IX" format="uppercase"/>
                <sql-index id="SQI_LIGNE_CHARGE_TAX_CODE" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:LIGNE_CHARGE/n:TAX_CODE/text()" datatype="string" column="TAX_CODE" table="LIGNE_CHARGE_IX" format="uppercase"/>
                <sql-index id="SQI_LIGNE_CHARGE_CPER" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:LIGNE_CHARGE/n:CPER/text()" datatype="string" column="CPER" table="LIGNE_CHARGE_IX" format="uppercase"/>
                <sql-index id="SQI_LIGNE_CHARGE_FUNDS_CTR" path="/n:DocDPDirecte/n:FEN0029A/n:DP_DIRECTE/n:LIGNE_CHARGE/n:FUNDS_CTR/text()" datatype="string" column="FUNDS_CTR" table="LIGNE_CHARGE_IX" format="uppercase"/>

                <element id="LIGNE_CHARGE_IX">
                    <sql-count>COUNT(DISTINCT(CONCAT(DP_DIRECTE_IX.DOC_ID,LIGNE_CHARGE_IX.NODE_ID)))</sql-count>
                    <special-cond>LIGNE_CHARGE_IX.NODE_ID IS NOT NULL</special-cond>
                </element>

            </etat>

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