<?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="DocEntreesDirectesStock" repository-import-xslt-file="">
            <table type="repository" base-name="FEN0070A_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="FEN0070A_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,  LIB1 VARCHAR(200), LIB2 VARCHAR(200), LIB3 VARCHAR(200), INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET) ) TYPE MYISAM </table>
            <table type="list-bc" base-name="FEN0070A_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="FEN0070A" import-xslt-file="fen0070a/etatFen0070a-import-mysql.xsl" >
                  <key1>
                    <path>/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:POSTE/@added:generated-id</path>
                </key1>
                
                <table type="document" base-name="EDS_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="FEN0070A_EDS_IX" base-name="FEN0070A_EDS_IX" version="2" 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, 
                    BILL_OF_LADING VARCHAR(16) ,
                    ID_UNIQUE VARCHAR(75),
                    GR_GI_SLIP_NO VARCHAR(255) ,
                    DATE_CPT VARCHAR(255) ,
                    TXT_ENTETE VARCHAR(255) ,
                    CODE_APPLI VARCHAR(6) ,
                    MOTIF_MVT VARCHAR(255) ,
                    DATE_PHY VARCHAR(255) ,
                    LINETXT VARCHAR(255) ,
                    CODE_MVT VARCHAR(255) ,
                    ID_AE VARCHAR(16) ,
                    PR_UNAME VARCHAR(255) ,
                    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>
                </table>
                <table type="index" id="FEN0070A_EDS_POSTE_IX" base-name="FEN0070A_EDS_POSTE_IX" version="2" 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, 
                    VAL VARCHAR(255) ,
                    RECEPT VARCHAR(255) ,
                    ID_CHOR_SUPPL VARCHAR(255) ,
                    LINETXT VARCHAR(255) ,
                    ID_LIG VARCHAR(255) ,
                    STGE_LOC VARCHAR(4) ,
                    ANA_MIN VARCHAR(255) ,
                    FUNC_AREA VARCHAR(255) ,
                    ID_AE VARCHAR(16) ,
                    PLANT VARCHAR(4) ,
                    LOC_MIN VARCHAR(255) ,
                    ID_FONC_PROD VARCHAR(255) ,
                    TYPE_ID_FONC VARCHAR(255) ,
                    NAT_MIN VARCHAR(255) ,
                    WBS_ELEM VARCHAR(255) ,
                    ID_FONC_PARTNER VARCHAR(255) ,
                    GR_COMPTES_PARTNER VARCHAR(255) ,
                    ID_CHORUS_PROD VARCHAR(255) ,
                    PO_ITEM VARCHAR(255) ,
                    ID_CHORUS_PARTNER VARCHAR(255) ,
                    ID_FONC_SUPPL VARCHAR(255) ,
                    GR_COMPTES_SUPPL VARCHAR(255) ,
                    UNIT VARCHAR(255) ,
                    PO_NUMBER VARCHAR(255) ,
                    AXMIN2 VARCHAR(255) ,
                    AXMIN1 VARCHAR(255) ,
                    QUANTITY VARCHAR(255) ,
                    TXT_PST VARCHAR(255) ,
                    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 GR_COMPTES_PARTNER VARCHAR(225)</sql>
                        <sql failonerror="false">ALTER TABLE ${base-name} ADD GR_COMPTES_SUPPL VARCHAR(225)</sql>
                    </patch>
                </table>
                
                
                <!-- CRITERIA /FEN0070A -->
                
                <!-- CRITERIA /FEN0070A/EDS -->
                
                <criteria id="CRI_FEN0070A_EDS_BILL_OF_LADING" type="1" sql-index-id="SQI_FEN0070A_EDS_BILL_OF_LADING">
                    <where-clause>fn:string-compare(${table}.${column},BILL_OF_LADING)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_GR_GI_SLIP_NO" type="1" sql-index-id="SQI_FEN0070A_EDS_GR_GI_SLIP_NO">
                    <where-clause>fn:string-compare(${table}.${column},GR_GI_SLIP_NO)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_DATE_CPT" type="1" sql-index-id="SQI_FEN0070A_EDS_DATE_CPT">
                    <where-clause>fn:string-compare(${table}.${column},DATE_CPT)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_TXT_ENTETE" type="1" sql-index-id="SQI_FEN0070A_EDS_TXT_ENTETE">
                    <where-clause>fn:string-compare(${table}.${column},TXT_ENTETE)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_CODE_APPLI" type="1" sql-index-id="SQI_FEN0070A_EDS_CODE_APPLI">
                    <where-clause>fn:string-compare(${table}.${column},CODE_APPLI)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_MOTIF_MVT" type="1" sql-index-id="SQI_FEN0070A_EDS_MOTIF_MVT">
                    <where-clause>fn:string-compare(${table}.${column},MOTIF_MVT)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_DATE_PHY" type="1" sql-index-id="SQI_FEN0070A_EDS_DATE_PHY">
                    <where-clause>fn:string-compare(${table}.${column},DATE_PHY)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_LINETXT" type="1" sql-index-id="SQI_FEN0070A_EDS_LINETXT">
                    <where-clause>fn:string-compare(${table}.${column},LineTxt)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_CODE_MVT" type="1" sql-index-id="SQI_FEN0070A_EDS_CODE_MVT">
                    <where-clause>fn:string-compare(${table}.${column},CODE_MVT)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_ID_AE" type="1" sql-index-id="SQI_FEN0070A_EDS_ID_AE">
                    <where-clause>fn:string-compare(${table}.${column},ID_AE)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_PR_UNAME" type="1" sql-index-id="SQI_FEN0070A_EDS_PR_UNAME">
                    <where-clause>fn:string-compare(${table}.${column},PR_UNAME)</where-clause>
                </criteria>
                
                <!-- CRITERIA /FEN0070A/EDS/POSTE -->
                <criteria id="CRI_FEN0070A_EDS_POSTE_VAL" type="1" sql-index-id="SQI_FEN0070A_EDS_POSTE_VAL">
                    <where-clause>fn:string-compare(${table}.${column},VAL)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_POSTE_RECEPT" type="1" sql-index-id="SQI_FEN0070A_EDS_POSTE_RECEPT">
                    <where-clause>fn:string-compare(${table}.${column},RECEPT)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_POSTE_ID_CHOR_SUPPL" type="1" sql-index-id="SQI_FEN0070A_EDS_POSTE_ID_CHOR_SUPPL">
                    <where-clause>fn:string-compare(${table}.${column},ID_CHOR_SUPPL)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_POSTE_LINETXT" type="1" sql-index-id="SQI_FEN0070A_EDS_POSTE_LINETXT">
                    <where-clause>fn:string-compare(${table}.${column},LineTxt)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_POSTE_ID_LIG" type="1" sql-index-id="SQI_FEN0070A_EDS_POSTE_ID_LIG">
                    <where-clause>fn:string-compare(${table}.${column},ID_LIG)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_POSTE_STGE_LOC" type="1" sql-index-id="SQI_FEN0070A_EDS_POSTE_STGE_LOC">
                    <where-clause>fn:string-compare(${table}.${column},STGE_LOC)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_POSTE_ANA_MIN" type="1" sql-index-id="SQI_FEN0070A_EDS_POSTE_ANA_MIN">
                    <where-clause>fn:string-compare(${table}.${column},ANA_MIN)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_POSTE_FUNC_AREA" type="1" sql-index-id="SQI_FEN0070A_EDS_POSTE_FUNC_AREA">
                    <where-clause>fn:string-compare(${table}.${column},FUNC_AREA)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_POSTE_ID_AE" type="1" sql-index-id="SQI_FEN0070A_EDS_POSTE_ID_AE">
                    <where-clause>fn:string-compare(${table}.${column},ID_AE)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_POSTE_PLANT" type="1" sql-index-id="SQI_FEN0070A_EDS_POSTE_PLANT">
                    <where-clause>fn:string-compare(${table}.${column},PLANT)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_POSTE_LOC_MIN" type="1" sql-index-id="SQI_FEN0070A_EDS_POSTE_LOC_MIN">
                    <where-clause>fn:string-compare(${table}.${column},LOC_MIN)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_POSTE_ID_FONC_PROD" type="1" sql-index-id="SQI_FEN0070A_EDS_POSTE_ID_FONC_PROD">
                    <where-clause>fn:string-compare(${table}.${column},ID_FONC_PROD)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_POSTE_TYPE_ID_FONC" type="1" sql-index-id="SQI_FEN0070A_EDS_POSTE_TYPE_ID_FONC">
                    <where-clause>fn:string-compare(${table}.${column},TYPE_ID_FONC)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_POSTE_NAT_MIN" type="1" sql-index-id="SQI_FEN0070A_EDS_POSTE_NAT_MIN">
                    <where-clause>fn:string-compare(${table}.${column},NAT_MIN)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_POSTE_WBS_ELEM" type="1" sql-index-id="SQI_FEN0070A_EDS_POSTE_WBS_ELEM">
                    <where-clause>fn:string-compare(${table}.${column},WBS_ELEM)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_POSTE_ID_FONC_PARTNER" type="1" sql-index-id="SQI_FEN0070A_EDS_POSTE_ID_FONC_PARTNER">
                    <where-clause>fn:string-compare(${table}.${column},ID_FONC_PARTNER)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_POSTE_GR_COMPTES_PARTNER" type="1" sql-index-id="SQI_FEN0070A_EDS_POSTE_GR_COMPTES_PARTNER">
                    <where-clause>fn:string-compare(${table}.${column},GR_COMPTES_PARTNER)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_POSTE_ID_CHORUS_PROD" type="1" sql-index-id="SQI_FEN0070A_EDS_POSTE_ID_CHORUS_PROD">
                    <where-clause>fn:string-compare(${table}.${column},ID_CHORUS_PROD)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_POSTE_PO_ITEM" type="1" sql-index-id="SQI_FEN0070A_EDS_POSTE_PO_ITEM">
                    <where-clause>fn:string-compare(${table}.${column},PO_ITEM)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_POSTE_ID_CHORUS_PARTNER" type="1" sql-index-id="SQI_FEN0070A_EDS_POSTE_ID_CHORUS_PARTNER">
                    <where-clause>fn:string-compare(${table}.${column},ID_CHORUS_PARTNER)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_POSTE_ID_FONC_SUPPL" type="1" sql-index-id="SQI_FEN0070A_EDS_POSTE_ID_FONC_SUPPL">
                    <where-clause>fn:string-compare(${table}.${column},ID_FONC_SUPPL)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_POSTE_GR_COMPTES_SUPPL" type="1" sql-index-id="SQI_FEN0070A_EDS_POSTE_GR_COMPTES_SUPPL">
                    <where-clause>fn:string-compare(${table}.${column},GR_COMPTES_SUPPL)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_POSTE_UNIT" type="1" sql-index-id="SQI_FEN0070A_EDS_POSTE_UNIT">
                    <where-clause>fn:string-compare(${table}.${column},UNIT)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_POSTE_PO_NUMBER" type="1" sql-index-id="SQI_FEN0070A_EDS_POSTE_PO_NUMBER">
                    <where-clause>fn:string-compare(${table}.${column},PO_NUMBER)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_POSTE_AXMIN2" type="1" sql-index-id="SQI_FEN0070A_EDS_POSTE_AXMIN2">
                    <where-clause>fn:string-compare(${table}.${column},AXMIN2)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_POSTE_AXMIN1" type="1" sql-index-id="SQI_FEN0070A_EDS_POSTE_AXMIN1">
                    <where-clause>fn:string-compare(${table}.${column},AXMIN1)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_POSTE_QUANTITY" type="1" sql-index-id="SQI_FEN0070A_EDS_POSTE_QUANTITY">
                    <where-clause>fn:string-compare(${table}.${column},QUANTITY)</where-clause>
                </criteria>
                <criteria id="CRI_FEN0070A_EDS_POSTE_TXT_PST" type="1" sql-index-id="SQI_FEN0070A_EDS_POSTE_TXT_PST">
                    <where-clause>fn:string-compare(${table}.${column},TXT_PST)</where-clause>
                </criteria>
                
                
                <!-- SQL-INDEX /FEN0070A -->
                
                <!-- SQL-INDEX /FEN0070A/EDS -->
                <sql-index id="EF_UNIQUE_ID_IX" table="FEN0070A_EDS_IX" column="ID_UNIQUE" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/@ano:unique-id" datatype="string"/>
                <sql-index id="SQI_FEN0070A_EDS__NODE_ID" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/@added:generated-id" column="NODE_ID" datatype="string" table="FEN0070A_EDS_IX"/>
                <sql-index id="SQI_FEN0070A_EDS_BILL_OF_LADING" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:ENTETE/n:BILL_OF_LADING/text()" datatype="string" column="BILL_OF_LADING" table="FEN0070A_EDS_IX" format="uppercase" />
                <sql-index id="SQI_FEN0070A_EDS_GR_GI_SLIP_NO" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:ENTETE/n:GR_GI_SLIP_NO/text()" datatype="string" column="GR_GI_SLIP_NO" table="FEN0070A_EDS_IX" />
                <sql-index id="SQI_FEN0070A_EDS_DATE_CPT" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:ENTETE/n:DATE_CPT/text()" datatype="string" column="DATE_CPT" table="FEN0070A_EDS_IX" />
                <sql-index id="SQI_FEN0070A_EDS_TXT_ENTETE" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:ENTETE/n:TXT_ENTETE/text()" datatype="string" column="TXT_ENTETE" table="FEN0070A_EDS_IX" />
                <sql-index id="SQI_FEN0070A_EDS_CODE_APPLI" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:ENTETE/n:CODE_APPLI/text()" datatype="string" column="CODE_APPLI" table="FEN0070A_EDS_IX" format="uppercase" />
                <sql-index id="SQI_FEN0070A_EDS_MOTIF_MVT" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:ENTETE/n:MOTIF_MVT/text()" datatype="string" column="MOTIF_MVT" table="FEN0070A_EDS_IX" />
                <sql-index id="SQI_FEN0070A_EDS_DATE_PHY" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:ENTETE/n:DATE_PHY/text()" datatype="string" column="DATE_PHY" table="FEN0070A_EDS_IX" />
                <sql-index id="SQI_FEN0070A_EDS_LINETXT" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:ENTETE/n:@LineTxt" datatype="string" column="LINETXT" table="FEN0070A_EDS_IX" />
                <sql-index id="SQI_FEN0070A_EDS_CODE_MVT" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:ENTETE/n:CODE_MVT/text()" datatype="string" column="CODE_MVT" table="FEN0070A_EDS_IX" />
                <sql-index id="SQI_FEN0070A_EDS_ID_AE" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:ENTETE/n:ID_AE/text()" datatype="string" column="ID_AE" table="FEN0070A_EDS_IX" format="uppercase" />
                <sql-index id="SQI_FEN0070A_EDS_PR_UNAME" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:ENTETE/n:PR_UNAME/text()" datatype="string" column="PR_UNAME" table="FEN0070A_EDS_IX" />
                
                <!-- SQL-INDEX /FEN0070A/EDS/POSTE -->
                <sql-index id="SQI_FEN0070A_EDS_POSTE__NODE_ID" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:POSTE/@added:generated-id" column="NODE_ID" datatype="string" table="FEN0070A_EDS_POSTE_IX"/>
                <sql-index id="SQI_FEN0070A_EDS_POSTE_VAL" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:POSTE/n:VAL/text()" datatype="string" column="VAL" table="FEN0070A_EDS_POSTE_IX" />
                <sql-index id="SQI_FEN0070A_EDS_POSTE_RECEPT" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:POSTE/n:RECEPT/text()" datatype="string" column="RECEPT" table="FEN0070A_EDS_POSTE_IX" />
                <sql-index id="SQI_FEN0070A_EDS_POSTE_ID_CHOR_SUPPL" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:POSTE/n:ID_CHOR_SUPPL/text()" datatype="string" column="ID_CHOR_SUPPL" table="FEN0070A_EDS_POSTE_IX" />
                <sql-index id="SQI_FEN0070A_EDS_POSTE_LINETXT" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:POSTE/@LineTxt" datatype="string" column="LINETXT" table="FEN0070A_EDS_POSTE_IX" />
                <sql-index id="SQI_FEN0070A_EDS_POSTE_ID_LIG" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:POSTE/n:ID_LIG/text()" datatype="string" column="ID_LIG" table="FEN0070A_EDS_POSTE_IX" />
                <sql-index id="SQI_FEN0070A_EDS_POSTE_STGE_LOC" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:POSTE/n:STGE_LOC/text()" datatype="string" column="STGE_LOC" table="FEN0070A_EDS_POSTE_IX" format="uppercase" />
                <sql-index id="SQI_FEN0070A_EDS_POSTE_ANA_MIN" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:POSTE/n:ANA_MIN/text()" datatype="string" column="ANA_MIN" table="FEN0070A_EDS_POSTE_IX" />
                <sql-index id="SQI_FEN0070A_EDS_POSTE_FUNC_AREA" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:POSTE/n:FUNC_AREA/text()" datatype="string" column="FUNC_AREA" table="FEN0070A_EDS_POSTE_IX" />
                <sql-index id="SQI_FEN0070A_EDS_POSTE_ID_AE" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:POSTE/n:ID_AE/text()" datatype="string" column="ID_AE" table="FEN0070A_EDS_POSTE_IX" format="uppercase" />
                <sql-index id="SQI_FEN0070A_EDS_POSTE_PLANT" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:POSTE/n:PLANT/text()" datatype="string" column="PLANT" table="FEN0070A_EDS_POSTE_IX" format="uppercase" />
                <sql-index id="SQI_FEN0070A_EDS_POSTE_LOC_MIN" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:POSTE/n:LOC_MIN/text()" datatype="string" column="LOC_MIN" table="FEN0070A_EDS_POSTE_IX" />
                <sql-index id="SQI_FEN0070A_EDS_POSTE_ID_FONC_PROD" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:POSTE/n:ID_FONC_PROD/text()" datatype="string" column="ID_FONC_PROD" table="FEN0070A_EDS_POSTE_IX" />
                <sql-index id="SQI_FEN0070A_EDS_POSTE_TYPE_ID_FONC" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:POSTE/n:TYPE_ID_FONC/text()" datatype="string" column="TYPE_ID_FONC" table="FEN0070A_EDS_POSTE_IX" />
                <sql-index id="SQI_FEN0070A_EDS_POSTE_NAT_MIN" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:POSTE/n:NAT_MIN/text()" datatype="string" column="NAT_MIN" table="FEN0070A_EDS_POSTE_IX" />
                <sql-index id="SQI_FEN0070A_EDS_POSTE_WBS_ELEM" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:POSTE/n:WBS_ELEM/text()" datatype="string" column="WBS_ELEM" table="FEN0070A_EDS_POSTE_IX" />
                <sql-index id="SQI_FEN0070A_EDS_POSTE_ID_FONC_PARTNER" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:POSTE/n:ID_FONC_PARTNER/text()" datatype="string" column="ID_FONC_PARTNER" table="FEN0070A_EDS_POSTE_IX" />
                <sql-index id="SQI_FEN0070A_EDS_POSTE_GR_COMPTES_PARTNER" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:POSTE/n:GR_COMPTES_PARTNER/text()" datatype="string" column="GR_COMPTES_PARTNER" table="FEN0070A_EDS_POSTE_IX" />
                <sql-index id="SQI_FEN0070A_EDS_POSTE_ID_CHORUS_PROD" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:POSTE/n:ID_CHORUS_PROD/text()" datatype="string" column="ID_CHORUS_PROD" table="FEN0070A_EDS_POSTE_IX" />
                <sql-index id="SQI_FEN0070A_EDS_POSTE_PO_ITEM" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:POSTE/n:PO_ITEM/text()" datatype="string" column="PO_ITEM" table="FEN0070A_EDS_POSTE_IX" />
                <sql-index id="SQI_FEN0070A_EDS_POSTE_ID_CHORUS_PARTNER" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:POSTE/n:ID_CHORUS_PARTNER/text()" datatype="string" column="ID_CHORUS_PARTNER" table="FEN0070A_EDS_POSTE_IX" />
                <sql-index id="SQI_FEN0070A_EDS_POSTE_ID_FONC_SUPPL" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:POSTE/n:ID_FONC_SUPPL/text()" datatype="string" column="ID_FONC_SUPPL" table="FEN0070A_EDS_POSTE_IX" />
                <sql-index id="SQI_FEN0070A_EDS_POSTE_GR_COMPTES_SUPPL" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:POSTE/n:GR_COMPTES_SUPPL/text()" datatype="string" column="GR_COMPTES_SUPPL" table="FEN0070A_EDS_POSTE_IX" />
                <sql-index id="SQI_FEN0070A_EDS_POSTE_UNIT" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:POSTE/UNIT/text()" datatype="string" column="UNIT" table="FEN0070A_EDS_POSTE_IX" />
                <sql-index id="SQI_FEN0070A_EDS_POSTE_PO_NUMBER" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:POSTE/n:PO_NUMBER/text()" datatype="string" column="PO_NUMBER" table="FEN0070A_EDS_POSTE_IX" />
                <sql-index id="SQI_FEN0070A_EDS_POSTE_AXMIN2" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:POSTE/n:AXMIN2/text()" datatype="string" column="AXMIN2" table="FEN0070A_EDS_POSTE_IX" />
                <sql-index id="SQI_FEN0070A_EDS_POSTE_AXMIN1" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:POSTE/n:AXMIN1/text()" datatype="string" column="AXMIN1" table="FEN0070A_EDS_POSTE_IX" />
                <sql-index id="SQI_FEN0070A_EDS_POSTE_QUANTITY" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:POSTE/n:QUANTITY/text()" datatype="string" column="QUANTITY" table="FEN0070A_EDS_POSTE_IX" />
                <sql-index id="SQI_FEN0070A_EDS_POSTE_TXT_PST" path="/n:DocEntreesDirectesStock/n:FEN0070A/n:EDS/n:POSTE/n:TXT_PST/text()" datatype="string" column="TXT_PST" table="FEN0070A_EDS_POSTE_IX" />
                
                <element id="FEN0070A_EDS_POSTE_IX"> 
                    <sql-count>COUNT(DISTINCT(CONCAT(FEN0070A_EDS_IX.DOC_ID,FEN0070A_EDS_POSTE_IX.NODE_ID)))</sql-count>
                    <special-cond>FEN0070A_EDS_POSTE_IX.NODE_ID IS NOT NULL</special-cond>
                </element>
                
            </etat>

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