<?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="DocDemandeAchat" repository-import-xslt-file="">
            <table type="repository" base-name="FEN0067A_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="FEN0067A_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), key1 VARCHAR(100), LIB3 VARCHAR(200), INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET) ) TYPE MYISAM </table>
            <table type="list-bc" base-name="FEN0067A_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="FEN0067A" import-xslt-file="fen0067a/etatFen0067a-import-mysql.xsl" >
	
	<key1>
	    <path>/n:DocDemandeAchat/n:FEN0067A/n:DA/n:POSTE/@added:generated-id</path>
	</key1>
	<key2>
	    <path>/n:DocDemandeAchat/n:FEN0067A/n:DA/n:IMPUTATION/@added:generated-id</path>
	</key2>
	<key3>
	    <path>/n:DocDemandeAchat/n:FEN0067A/n:DA/n:PARTENAIRE/@added:generated-id</path>
	</key3>
	<key4>
	    <path>/n:DocDemandeAchat/n:FEN0067A/n:DA/n:TEXTE/@added:generated-id</path>
	</key4>

<table type="document" base-name="DA_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="FEN0067A_DA_IX" base-name="FEN0067A_DA_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, 
	LINETXT VARCHAR(255) ,
	ID_UNIQUE VARCHAR(75),
	ID_AE VARCHAR(255) ,
	DESCRIPTION VARCHAR(255) ,
	DOC_DATE VARCHAR(255) ,
	INITIATEUR VARCHAR(255) ,
	CODE_APPLI VARCHAR(255) ,
	CURRENCY 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="FEN0067A_DA_POSTE_IX" base-name="FEN0067A_DA_POSTE_IX" 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, 
	BE_PUR_GROUP VARCHAR(255) ,
	LINETXT VARCHAR(255) ,
	ID_LIG VARCHAR(255) ,
	STGE_LOC VARCHAR(255) ,
	PRICE VARCHAR(255) ,
	CTR_ITEM_NUMBER VARCHAR(255) ,
	ID_AE VARCHAR(255) ,
	ID_FONC_PROD VARCHAR(255) ,
	PARTNER_PROD VARCHAR(255) ,
	TYPE_ID_FONC VARCHAR(255) ,
	BE_PLANT VARCHAR(255) ,
	CATEGORY_ID VARCHAR(255) ,
	DESCRIPTION VARCHAR(255) ,
	DELIV_DATE VARCHAR(255) ,
	ID_CHORUS_PROD VARCHAR(255) ,
	CTR_NUMBER VARCHAR(255) ,
	UNIT_PRICE VARCHAR(255) ,
	UNIT VARCHAR(255) ,
	TAX_CODE VARCHAR(255) ,
	QUANTITY VARCHAR(255) ,
	GROSS_PRICE VARCHAR(255) ,
	INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), 
	INDEX IX_${base-name}_DC (DOC_ID) 
	) TYPE MYISAM
</table>
<table type="index" id="FEN0067A_DA_IMPUTATION_IX" base-name="FEN0067A_DA_IMPUTATION_IX" 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, 
	TRC_FONC VARCHAR(255) ,
	LINETXT VARCHAR(255) ,
	ID_LIG VARCHAR(255) ,
	SUB_NUMBER VARCHAR(255) ,
	ANA_MIN VARCHAR(255) ,
	COST_CTR VARCHAR(255) ,
	BUS_AREA VARCHAR(255) ,
	FUNC_AREA VARCHAR(255) ,
	ID_AE VARCHAR(255) ,
	LOC_MIN VARCHAR(255) ,
	GL_ACCT VARCHAR(255) ,
	NAT_MIN VARCHAR(255) ,
	WBS_ELEM VARCHAR(255) ,
	FUND VARCHAR(255) ,
	ASSET_NO VARCHAR(255) ,
	CMMT_ITEM VARCHAR(255) ,
	ACC_CAT VARCHAR(255) ,
	ACTIVITY VARCHAR(255) ,
	LOC_INT VARCHAR(255) ,
	RES_ITEM VARCHAR(255) ,
	PRESAGE VARCHAR(255) ,
	AXMIN2 VARCHAR(255) ,
	RES_DOC VARCHAR(255) ,
	AXMIN1 VARCHAR(255) ,
	CPER VARCHAR(255) ,
	FUNDS_CTR VARCHAR(255) ,
	INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), 
	INDEX IX_${base-name}_DC (DOC_ID) 
	) TYPE MYISAM
</table>
<table type="index" id="FEN0067A_DA_PARTENAIRE_IX" base-name="FEN0067A_DA_PARTENAIRE_IX" version="1" main="false" based-on="key3">
	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(255) ,
	E_MAIL VARCHAR(255) ,
	ADDR_ORIGIN VARCHAR(255) ,
	LINETXT VARCHAR(255) ,
	ID_LIG VARCHAR(255) ,
	COUNTRY VARCHAR(255) ,
	POSTL_COD VARCHAR(255) ,
	FAX_NUMBER VARCHAR(255) ,
	NAME VARCHAR(255) ,
	PARTNER_FCT VARCHAR(255) ,
	FLOOR VARCHAR(255) ,
	ID_AE VARCHAR(255) ,
	ADDR_TYPE VARCHAR(255) ,
	ROOM_NO VARCHAR(255) ,
	HOUSE_NO VARCHAR(255) ,
	ID_FONC_PARTNER VARCHAR(255) ,
	TEL_NUMBR VARCHAR(255) ,
	PARTNER_TYP VARCHAR(255) ,
	ID_CHORUS_PARTNER VARCHAR(255) ,
	BUILDING VARCHAR(255) ,
	STREET VARCHAR(255) ,
	INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), 
	INDEX IX_${base-name}_DC (DOC_ID) 
	) TYPE MYISAM
</table>
<table type="index" id="FEN0067A_DA_TEXTE_IX" base-name="FEN0067A_DA_TEXTE_IX" version="1" main="false" based-on="key4">
	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, 
	ID_AE VARCHAR(255) ,
	LINETXT VARCHAR(255) ,
	TEXT_LINE VARCHAR(255) ,
	ID_LIG VARCHAR(255) ,
	TEXT_ID VARCHAR(255) ,
	INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), 
	INDEX IX_${base-name}_DC (DOC_ID) 
	) TYPE MYISAM
</table>


<!-- CRITERIA /FEN0067A -->

<!-- CRITERIA /FEN0067A/DA -->
<criteria id="CRI_FEN0067A_DA_LINETXT" type="1" sql-index-id="SQI_FEN0067A_DA_LINETXT">
	<where-clause>fn:string-compare(${table}.${column},LineTxt)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_ID_AE" type="1" sql-index-id="SQI_FEN0067A_DA_ID_AE">
	<where-clause>fn:string-compare(${table}.${column},ID_AE)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_DESCRIPTION" type="1" sql-index-id="SQI_FEN0067A_DA_DESCRIPTION">
	<where-clause>fn:string-compare(${table}.${column},DESCRIPTION)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_DOC_DATE" type="1" sql-index-id="SQI_FEN0067A_DA_DOC_DATE">
	<where-clause>fn:string-compare(${table}.${column},DOC_DATE)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_INITIATEUR" type="1" sql-index-id="SQI_FEN0067A_DA_INITIATEUR">
	<where-clause>fn:string-compare(${table}.${column},INITIATEUR)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_CODE_APPLI" type="1" sql-index-id="SQI_FEN0067A_DA_CODE_APPLI">
	<where-clause>fn:string-compare(${table}.${column},CODE_APPLI)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_CURRENCY" type="1" sql-index-id="SQI_FEN0067A_DA_CURRENCY">
	<where-clause>fn:string-compare(${table}.${column},CURRENCY)</where-clause>
</criteria>

<!-- CRITERIA /FEN0067A/DA/POSTE -->
<criteria id="CRI_FEN0067A_DA_POSTE_BE_PUR_GROUP" type="1" sql-index-id="SQI_FEN0067A_DA_POSTE_BE_PUR_GROUP">
	<where-clause>fn:string-compare(${table}.${column},BE_PUR_GROUP)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_POSTE_LINETXT" type="1" sql-index-id="SQI_FEN0067A_DA_POSTE_LINETXT">
	<where-clause>fn:string-compare(${table}.${column},LineTxt)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_POSTE_ID_LIG" type="1" sql-index-id="SQI_FEN0067A_DA_POSTE_ID_LIG">
	<where-clause>fn:string-compare(${table}.${column},ID_LIG)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_POSTE_STGE_LOC" type="1" sql-index-id="SQI_FEN0067A_DA_POSTE_STGE_LOC">
	<where-clause>fn:string-compare(${table}.${column},STGE_LOC)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_POSTE_PRICE" type="1" sql-index-id="SQI_FEN0067A_DA_POSTE_PRICE">
	<where-clause>fn:string-compare(${table}.${column},PRICE)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_POSTE_CTR_ITEM_NUMBER" type="1" sql-index-id="SQI_FEN0067A_DA_POSTE_CTR_ITEM_NUMBER">
	<where-clause>fn:string-compare(${table}.${column},CTR_ITEM_NUMBER)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_POSTE_ID_AE" type="1" sql-index-id="SQI_FEN0067A_DA_POSTE_ID_AE">
	<where-clause>fn:string-compare(${table}.${column},ID_AE)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_POSTE_ID_FONC_PROD" type="1" sql-index-id="SQI_FEN0067A_DA_POSTE_ID_FONC_PROD">
	<where-clause>fn:string-compare(${table}.${column},ID_FONC_PROD)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_POSTE_PARTNER_PROD" type="1" sql-index-id="SQI_FEN0067A_DA_POSTE_PARTNER_PROD">
	<where-clause>fn:string-compare(${table}.${column},PARTNER_PROD)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_POSTE_TYPE_ID_FONC" type="1" sql-index-id="SQI_FEN0067A_DA_POSTE_TYPE_ID_FONC">
	<where-clause>fn:string-compare(${table}.${column},TYPE_ID_FONC)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_POSTE_BE_PLANT" type="1" sql-index-id="SQI_FEN0067A_DA_POSTE_BE_PLANT">
	<where-clause>fn:string-compare(${table}.${column},BE_PLANT)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_POSTE_CATEGORY_ID" type="1" sql-index-id="SQI_FEN0067A_DA_POSTE_CATEGORY_ID">
	<where-clause>fn:string-compare(${table}.${column},CATEGORY_ID)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_POSTE_DESCRIPTION" type="1" sql-index-id="SQI_FEN0067A_DA_POSTE_DESCRIPTION">
	<where-clause>fn:string-compare(${table}.${column},DESCRIPTION)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_POSTE_DELIV_DATE" type="1" sql-index-id="SQI_FEN0067A_DA_POSTE_DELIV_DATE">
	<where-clause>fn:string-compare(${table}.${column},DELIV_DATE)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_POSTE_ID_CHORUS_PROD" type="1" sql-index-id="SQI_FEN0067A_DA_POSTE_ID_CHORUS_PROD">
	<where-clause>fn:string-compare(${table}.${column},ID_CHORUS_PROD)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_POSTE_CTR_NUMBER" type="1" sql-index-id="SQI_FEN0067A_DA_POSTE_CTR_NUMBER">
	<where-clause>fn:string-compare(${table}.${column},CTR_NUMBER)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_POSTE_UNIT_PRICE" type="1" sql-index-id="SQI_FEN0067A_DA_POSTE_UNIT_PRICE">
	<where-clause>fn:string-compare(${table}.${column},UNIT_PRICE)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_POSTE_UNIT" type="1" sql-index-id="SQI_FEN0067A_DA_POSTE_UNIT">
	<where-clause>fn:string-compare(${table}.${column},UNIT)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_POSTE_TAX_CODE" type="1" sql-index-id="SQI_FEN0067A_DA_POSTE_TAX_CODE">
	<where-clause>fn:string-compare(${table}.${column},TAX_CODE)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_POSTE_QUANTITY" type="1" sql-index-id="SQI_FEN0067A_DA_POSTE_QUANTITY">
	<where-clause>fn:string-compare(${table}.${column},QUANTITY)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_POSTE_GROSS_PRICE" type="1" sql-index-id="SQI_FEN0067A_DA_POSTE_GROSS_PRICE">
	<where-clause>fn:string-compare(${table}.${column},GROSS_PRICE)</where-clause>
</criteria>

<!-- CRITERIA /FEN0067A/DA/n:IMPUTATION -->
<criteria id="CRI_FEN0067A_DA_IMPUTATION_TRC_FONC" type="1" sql-index-id="SQI_FEN0067A_DA_IMPUTATION_TRC_FONC">
	<where-clause>fn:string-compare(${table}.${column},TRC_FONC)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_IMPUTATION_LINETXT" type="1" sql-index-id="SQI_FEN0067A_DA_IMPUTATION_LINETXT">
	<where-clause>fn:string-compare(${table}.${column},LineTxt)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_IMPUTATION_ID_LIG" type="1" sql-index-id="SQI_FEN0067A_DA_IMPUTATION_ID_LIG">
	<where-clause>fn:string-compare(${table}.${column},ID_LIG)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_IMPUTATION_SUB_NUMBER" type="1" sql-index-id="SQI_FEN0067A_DA_IMPUTATION_SUB_NUMBER">
	<where-clause>fn:string-compare(${table}.${column},SUB_NUMBER)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_IMPUTATION_ANA_MIN" type="1" sql-index-id="SQI_FEN0067A_DA_IMPUTATION_ANA_MIN">
	<where-clause>fn:string-compare(${table}.${column},ANA_MIN)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_IMPUTATION_COST_CTR" type="1" sql-index-id="SQI_FEN0067A_DA_IMPUTATION_COST_CTR">
	<where-clause>fn:string-compare(${table}.${column},COST_CTR)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_IMPUTATION_BUS_AREA" type="1" sql-index-id="SQI_FEN0067A_DA_IMPUTATION_BUS_AREA">
	<where-clause>fn:string-compare(${table}.${column},BUS_AREA)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_IMPUTATION_FUNC_AREA" type="1" sql-index-id="SQI_FEN0067A_DA_IMPUTATION_FUNC_AREA">
	<where-clause>fn:string-compare(${table}.${column},FUNC_AREA)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_IMPUTATION_ID_AE" type="1" sql-index-id="SQI_FEN0067A_DA_IMPUTATION_ID_AE">
	<where-clause>fn:string-compare(${table}.${column},ID_AE)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_IMPUTATION_LOC_MIN" type="1" sql-index-id="SQI_FEN0067A_DA_IMPUTATION_LOC_MIN">
	<where-clause>fn:string-compare(${table}.${column},LOC_MIN)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_IMPUTATION_GL_ACCT" type="1" sql-index-id="SQI_FEN0067A_DA_IMPUTATION_GL_ACCT">
	<where-clause>fn:string-compare(${table}.${column},GL_ACCT)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_IMPUTATION_NAT_MIN" type="1" sql-index-id="SQI_FEN0067A_DA_IMPUTATION_NAT_MIN">
	<where-clause>fn:string-compare(${table}.${column},NAT_MIN)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_IMPUTATION_WBS_ELEM" type="1" sql-index-id="SQI_FEN0067A_DA_IMPUTATION_WBS_ELEM">
	<where-clause>fn:string-compare(${table}.${column},WBS_ELEM)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_IMPUTATION_FUND" type="1" sql-index-id="SQI_FEN0067A_DA_IMPUTATION_FUND">
	<where-clause>fn:string-compare(${table}.${column},FUND)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_IMPUTATION_ASSET_NO" type="1" sql-index-id="SQI_FEN0067A_DA_IMPUTATION_ASSET_NO">
	<where-clause>fn:string-compare(${table}.${column},ASSET_NO)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_IMPUTATION_CMMT_ITEM" type="1" sql-index-id="SQI_FEN0067A_DA_IMPUTATION_CMMT_ITEM">
	<where-clause>fn:string-compare(${table}.${column},CMMT_ITEM)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_IMPUTATION_ACC_CAT" type="1" sql-index-id="SQI_FEN0067A_DA_IMPUTATION_ACC_CAT">
	<where-clause>fn:string-compare(${table}.${column},ACC_CAT)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_IMPUTATION_ACTIVITY" type="1" sql-index-id="SQI_FEN0067A_DA_IMPUTATION_ACTIVITY">
	<where-clause>fn:string-compare(${table}.${column},ACTIVITY)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_IMPUTATION_LOC_INT" type="1" sql-index-id="SQI_FEN0067A_DA_IMPUTATION_LOC_INT">
	<where-clause>fn:string-compare(${table}.${column},LOC_INT)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_IMPUTATION_RES_ITEM" type="1" sql-index-id="SQI_FEN0067A_DA_IMPUTATION_RES_ITEM">
	<where-clause>fn:string-compare(${table}.${column},RES_ITEM)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_IMPUTATION_PRESAGE" type="1" sql-index-id="SQI_FEN0067A_DA_IMPUTATION_PRESAGE">
	<where-clause>fn:string-compare(${table}.${column},PRESAGE)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_IMPUTATION_AXMIN2" type="1" sql-index-id="SQI_FEN0067A_DA_IMPUTATION_AXMIN2">
	<where-clause>fn:string-compare(${table}.${column},AXMIN2)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_IMPUTATION_RES_DOC" type="1" sql-index-id="SQI_FEN0067A_DA_IMPUTATION_RES_DOC">
	<where-clause>fn:string-compare(${table}.${column},RES_DOC)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_IMPUTATION_AXMIN1" type="1" sql-index-id="SQI_FEN0067A_DA_IMPUTATION_AXMIN1">
	<where-clause>fn:string-compare(${table}.${column},AXMIN1)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_IMPUTATION_CPER" type="1" sql-index-id="SQI_FEN0067A_DA_IMPUTATION_CPER">
	<where-clause>fn:string-compare(${table}.${column},CPER)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_IMPUTATION_FUNDS_CTR" type="1" sql-index-id="SQI_FEN0067A_DA_IMPUTATION_FUNDS_CTR">
	<where-clause>fn:string-compare(${table}.${column},FUNDS_CTR)</where-clause>
</criteria>

<!-- CRITERIA /FEN0067A/DA/PARTENAIRE -->
<criteria id="CRI_FEN0067A_DA_PARTENAIRE_CITY" type="1" sql-index-id="SQI_FEN0067A_DA_PARTENAIRE_CITY">
	<where-clause>fn:string-compare(${table}.${column},CITY)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_PARTENAIRE_E_MAIL" type="1" sql-index-id="SQI_FEN0067A_DA_PARTENAIRE_E_MAIL">
	<where-clause>fn:string-compare(${table}.${column},E_MAIL)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_PARTENAIRE_ADDR_ORIGIN" type="1" sql-index-id="SQI_FEN0067A_DA_PARTENAIRE_ADDR_ORIGIN">
	<where-clause>fn:string-compare(${table}.${column},ADDR_ORIGIN)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_PARTENAIRE_LINETXT" type="1" sql-index-id="SQI_FEN0067A_DA_PARTENAIRE_LINETXT">
	<where-clause>fn:string-compare(${table}.${column},LineTxt)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_PARTENAIRE_ID_LIG" type="1" sql-index-id="SQI_FEN0067A_DA_PARTENAIRE_ID_LIG">
	<where-clause>fn:string-compare(${table}.${column},ID_LIG)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_PARTENAIRE_COUNTRY" type="1" sql-index-id="SQI_FEN0067A_DA_PARTENAIRE_COUNTRY">
	<where-clause>fn:string-compare(${table}.${column},COUNTRY)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_PARTENAIRE_POSTL_COD" type="1" sql-index-id="SQI_FEN0067A_DA_PARTENAIRE_POSTL_COD">
	<where-clause>fn:string-compare(${table}.${column},POSTL_COD)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_PARTENAIRE_FAX_NUMBER" type="1" sql-index-id="SQI_FEN0067A_DA_PARTENAIRE_FAX_NUMBER">
	<where-clause>fn:string-compare(${table}.${column},FAX_NUMBER)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_PARTENAIRE_NAME" type="1" sql-index-id="SQI_FEN0067A_DA_PARTENAIRE_NAME">
	<where-clause>fn:string-compare(${table}.${column},NAME)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_PARTENAIRE_PARTNER_FCT" type="1" sql-index-id="SQI_FEN0067A_DA_PARTENAIRE_PARTNER_FCT">
	<where-clause>fn:string-compare(${table}.${column},PARTNER_FCT)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_PARTENAIRE_FLOOR" type="1" sql-index-id="SQI_FEN0067A_DA_PARTENAIRE_FLOOR">
	<where-clause>fn:string-compare(${table}.${column},FLOOR)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_PARTENAIRE_ID_AE" type="1" sql-index-id="SQI_FEN0067A_DA_PARTENAIRE_ID_AE">
	<where-clause>fn:string-compare(${table}.${column},ID_AE)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_PARTENAIRE_ADDR_TYPE" type="1" sql-index-id="SQI_FEN0067A_DA_PARTENAIRE_ADDR_TYPE">
	<where-clause>fn:string-compare(${table}.${column},ADDR_TYPE)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_PARTENAIRE_ROOM_NO" type="1" sql-index-id="SQI_FEN0067A_DA_PARTENAIRE_ROOM_NO">
	<where-clause>fn:string-compare(${table}.${column},ROOM_NO)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_PARTENAIRE_HOUSE_NO" type="1" sql-index-id="SQI_FEN0067A_DA_PARTENAIRE_HOUSE_NO">
	<where-clause>fn:string-compare(${table}.${column},HOUSE_NO)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_PARTENAIRE_ID_FONC_PARTNER" type="1" sql-index-id="SQI_FEN0067A_DA_PARTENAIRE_ID_FONC_PARTNER">
	<where-clause>fn:string-compare(${table}.${column},ID_FONC_PARTNER)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_PARTENAIRE_TEL_NUMBR" type="1" sql-index-id="SQI_FEN0067A_DA_PARTENAIRE_TEL_NUMBR">
	<where-clause>fn:string-compare(${table}.${column},TEL_NUMBR)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_PARTENAIRE_PARTNER_TYP" type="1" sql-index-id="SQI_FEN0067A_DA_PARTENAIRE_PARTNER_TYP">
	<where-clause>fn:string-compare(${table}.${column},PARTNER_TYP)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_PARTENAIRE_ID_CHORUS_PARTNER" type="1" sql-index-id="SQI_FEN0067A_DA_PARTENAIRE_ID_CHORUS_PARTNER">
	<where-clause>fn:string-compare(${table}.${column},ID_CHORUS_PARTNER)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_PARTENAIRE_BUILDING" type="1" sql-index-id="SQI_FEN0067A_DA_PARTENAIRE_BUILDING">
	<where-clause>fn:string-compare(${table}.${column},BUILDING)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_PARTENAIRE_STREET" type="1" sql-index-id="SQI_FEN0067A_DA_PARTENAIRE_STREET">
	<where-clause>fn:string-compare(${table}.${column},STREET)</where-clause>
</criteria>

<!-- CRITERIA /FEN0067A/DA/TEXTE -->
<criteria id="CRI_FEN0067A_DA_TEXTE_ID_AE" type="1" sql-index-id="SQI_FEN0067A_DA_TEXTE_ID_AE">
	<where-clause>fn:string-compare(${table}.${column},ID_AE)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_TEXTE_LINETXT" type="1" sql-index-id="SQI_FEN0067A_DA_TEXTE_LINETXT">
	<where-clause>fn:string-compare(${table}.${column},LineTxt)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_TEXTE_TEXT_LINE" type="1" sql-index-id="SQI_FEN0067A_DA_TEXTE_TEXT_LINE">
	<where-clause>fn:string-compare(${table}.${column},TEXT_LINE)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_TEXTE_ID_LIG" type="1" sql-index-id="SQI_FEN0067A_DA_TEXTE_ID_LIG">
	<where-clause>fn:string-compare(${table}.${column},ID_LIG)</where-clause>
</criteria>
<criteria id="CRI_FEN0067A_DA_TEXTE_TEXT_ID" type="1" sql-index-id="SQI_FEN0067A_DA_TEXTE_TEXT_ID">
	<where-clause>fn:string-compare(${table}.${column},TEXT_ID)</where-clause>
</criteria>


<!-- SQL-INDEX /FEN0067A -->

<!-- SQL-INDEX /FEN0067A/DA -->
 <sql-index id="EF_UNIQUE_ID_IX" table="FEN0067A_DA_IX" column="ID_UNIQUE" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/@ano:unique-id" datatype="string"/>
<sql-index id="SQI_FEN0067A_DA__NODE_ID" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/@added:generated-id" column="NODE_ID" datatype="string" table="FEN0067A_DA_IX"/>
<sql-index id="SQI_FEN0067A_DA_LINETXT" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:ENTETE/@LineTxt" datatype="string" column="LINETXT" table="FEN0067A_DA_IX" />
<sql-index id="SQI_FEN0067A_DA_ID_AE" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:ENTETE/n:ID_AE/text()" datatype="string" column="ID_AE" table="FEN0067A_DA_IX" />
<sql-index id="SQI_FEN0067A_DA_DESCRIPTION" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:ENTETE/n:DESCRIPTION/text()" datatype="string" column="DESCRIPTION" table="FEN0067A_DA_IX" />
<sql-index id="SQI_FEN0067A_DA_DOC_DATE" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:ENTETE/n:DOC_DATE/text()" datatype="string" column="DOC_DATE" table="FEN0067A_DA_IX" />
<sql-index id="SQI_FEN0067A_DA_INITIATEUR" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:ENTETE/n:INITIATEUR/text()" datatype="string" column="INITIATEUR" table="FEN0067A_DA_IX" />
<sql-index id="SQI_FEN0067A_DA_CODE_APPLI" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:ENTETE/n:CODE_APPLI/text()" datatype="string" column="CODE_APPLI" table="FEN0067A_DA_IX" />
<sql-index id="SQI_FEN0067A_DA_CURRENCY" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:ENTETE/n:CURRENCY/text()" datatype="string" column="CURRENCY" table="FEN0067A_DA_IX" />

<!-- SQL-INDEX /FEN0067A/DA/POSTE -->
<sql-index id="SQI_FEN0067A_DA_POSTE__NODE_ID" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:POSTE/@added:generated-id" column="NODE_ID" datatype="string" table="FEN0067A_DA_POSTE_IX"/>
            <sql-index id="SQI_FEN0067A_DA_POSTE_BE_PUR_GROUP" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:POSTE/n:BE_PUR_GROUP/text()" datatype="string" column="BE_PUR_GROUP" table="FEN0067A_DA_POSTE_IX" />
<sql-index id="SQI_FEN0067A_DA_POSTE_LINETXT" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:POSTE/@LineTxt" datatype="string" column="LINETXT" table="FEN0067A_DA_POSTE_IX" />
<sql-index id="SQI_FEN0067A_DA_POSTE_ID_LIG" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:POSTE/n:ID_LIG/text()" datatype="string" column="ID_LIG" table="FEN0067A_DA_POSTE_IX" />
<sql-index id="SQI_FEN0067A_DA_POSTE_STGE_LOC" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:POSTE/n:STGE_LOC/text()" datatype="string" column="STGE_LOC" table="FEN0067A_DA_POSTE_IX" />
<sql-index id="SQI_FEN0067A_DA_POSTE_PRICE" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:POSTE/n:PRICE/text()" datatype="string" column="PRICE" table="FEN0067A_DA_POSTE_IX" />
<sql-index id="SQI_FEN0067A_DA_POSTE_CTR_ITEM_NUMBER" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:POSTE/n:CTR_ITEM_NUMBER/text()" datatype="string" column="CTR_ITEM_NUMBER" table="FEN0067A_DA_POSTE_IX" />
<sql-index id="SQI_FEN0067A_DA_POSTE_ID_AE" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:POSTE/n:ID_AE/text()" datatype="string" column="ID_AE" table="FEN0067A_DA_POSTE_IX" />
 <sql-index id="SQI_FEN0067A_DA_POSTE_ID_FONC_PROD" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:POSTE/n:ID_FONC_PROD/text()" datatype="string" column="ID_FONC_PROD" table="FEN0067A_DA_POSTE_IX" />
<sql-index id="SQI_FEN0067A_DA_POSTE_PARTNER_PROD" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:POSTE/n:PARTNER_PROD/text()" datatype="string" column="PARTNER_PROD" table="FEN0067A_DA_POSTE_IX" />
<sql-index id="SQI_FEN0067A_DA_POSTE_TYPE_ID_FONC" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:POSTE/n:TYPE_ID_FONC/text()" datatype="string" column="TYPE_ID_FONC" table="FEN0067A_DA_POSTE_IX" />
<sql-index id="SQI_FEN0067A_DA_POSTE_BE_PLANT" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:POSTE/n:BE_PLANT/text()" datatype="string" column="BE_PLANT" table="FEN0067A_DA_POSTE_IX" />
<sql-index id="SQI_FEN0067A_DA_POSTE_CATEGORY_ID" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:POSTE/n:CATEGORY_ID/text()" datatype="string" column="CATEGORY_ID" table="FEN0067A_DA_POSTE_IX" />
<sql-index id="SQI_FEN0067A_DA_POSTE_DESCRIPTION" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:POSTE/n:DESCRIPTION/text()" datatype="string" column="DESCRIPTION" table="FEN0067A_DA_POSTE_IX" />
<sql-index id="SQI_FEN0067A_DA_POSTE_DELIV_DATE" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:POSTE/n:DELIV_DATE/text()" datatype="string" column="DELIV_DATE" table="FEN0067A_DA_POSTE_IX" />
<sql-index id="SQI_FEN0067A_DA_POSTE_ID_CHORUS_PROD" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:POSTE/n:ID_CHORUS_PROD/text()" datatype="string" column="ID_CHORUS_PROD" table="FEN0067A_DA_POSTE_IX" />
<sql-index id="SQI_FEN0067A_DA_POSTE_CTR_NUMBER" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:POSTE/n:CTR_NUMBER/text()" datatype="string" column="CTR_NUMBER" table="FEN0067A_DA_POSTE_IX" />
<sql-index id="SQI_FEN0067A_DA_POSTE_UNIT_PRICE" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:POSTE/n:UNIT_PRICE/text()" datatype="string" column="UNIT_PRICE" table="FEN0067A_DA_POSTE_IX" />
<sql-index id="SQI_FEN0067A_DA_POSTE_UNIT" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:POSTE/n:UNIT/text()" datatype="string" column="UNIT" table="FEN0067A_DA_POSTE_IX" />
<sql-index id="SQI_FEN0067A_DA_POSTE_TAX_CODE" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:POSTE/n:TAX_CODE/text()" datatype="string" column="TAX_CODE" table="FEN0067A_DA_POSTE_IX" />
<sql-index id="SQI_FEN0067A_DA_POSTE_QUANTITY" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:POSTE/n:QUANTITY/text()" datatype="string" column="QUANTITY" table="FEN0067A_DA_POSTE_IX" />
 <sql-index id="SQI_FEN0067A_DA_POSTE_GROSS_PRICE" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:POSTE/n:GROSS_PRICE/text()" datatype="string" column="GROSS_PRICE" table="FEN0067A_DA_POSTE_IX" />

<!-- SQL-INDEX /n:FEN0067A/DA/n:IMPUTATION -->
<sql-index id="SQI_FEN0067A_DA_IMPUTATION__NODE_ID" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:IMPUTATION/@added:generated-id" column="NODE_ID" datatype="string" table="FEN0067A_DA_IMPUTATION_IX"/>
<sql-index id="SQI_FEN0067A_DA_IMPUTATION_TRC_FONC" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:IMPUTATION/n:TRC_FONC/text()" datatype="string" column="TRC_FONC" table="FEN0067A_DA_IMPUTATION_IX" />
<sql-index id="SQI_FEN0067A_DA_IMPUTATION_LINETXT" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:IMPUTATION/@LineTxt" datatype="string" column="LINETXT" table="FEN0067A_DA_IMPUTATION_IX" />
<sql-index id="SQI_FEN0067A_DA_IMPUTATION_ID_LIG" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:IMPUTATION/n:ID_LIG/text()" datatype="string" column="ID_LIG" table="FEN0067A_DA_IMPUTATION_IX" />
<sql-index id="SQI_FEN0067A_DA_IMPUTATION_SUB_NUMBER" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:IMPUTATION/n:SUB_NUMBER/text()" datatype="string" column="SUB_NUMBER" table="FEN0067A_DA_IMPUTATION_IX" />
<sql-index id="SQI_FEN0067A_DA_IMPUTATION_ANA_MIN" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:IMPUTATION/n:ANA_MIN/text()" datatype="string" column="ANA_MIN" table="FEN0067A_DA_IMPUTATION_IX" />
<sql-index id="SQI_FEN0067A_DA_IMPUTATION_COST_CTR" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:IMPUTATION/n:COST_CTR/text()" datatype="string" column="COST_CTR" table="FEN0067A_DA_IMPUTATION_IX" />
<sql-index id="SQI_FEN0067A_DA_IMPUTATION_BUS_AREA" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:IMPUTATION/n:BUS_AREA/text()" datatype="string" column="BUS_AREA" table="FEN0067A_DA_IMPUTATION_IX" />
<sql-index id="SQI_FEN0067A_DA_IMPUTATION_FUNC_AREA" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:IMPUTATION/n:FUNC_AREA/text()" datatype="string" column="FUNC_AREA" table="FEN0067A_DA_IMPUTATION_IX" />
<sql-index id="SQI_FEN0067A_DA_IMPUTATION_ID_AE" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:IMPUTATION/n:ID_AE/text()" datatype="string" column="ID_AE" table="FEN0067A_DA_IMPUTATION_IX" />
<sql-index id="SQI_FEN0067A_DA_IMPUTATION_LOC_MIN" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:IMPUTATION/n:LOC_MIN/text()" datatype="string" column="LOC_MIN" table="FEN0067A_DA_IMPUTATION_IX" />
<sql-index id="SQI_FEN0067A_DA_IMPUTATION_GL_ACCT" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:IMPUTATION/n:GL_ACCT/text()" datatype="string" column="GL_ACCT" table="FEN0067A_DA_IMPUTATION_IX" />
<sql-index id="SQI_FEN0067A_DA_IMPUTATION_NAT_MIN" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:IMPUTATION/n:NAT_MIN/text()" datatype="string" column="NAT_MIN" table="FEN0067A_DA_IMPUTATION_IX" />
<sql-index id="SQI_FEN0067A_DA_IMPUTATION_WBS_ELEM" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:IMPUTATION/n:WBS_ELEM/text()" datatype="string" column="WBS_ELEM" table="FEN0067A_DA_IMPUTATION_IX" />
<sql-index id="SQI_FEN0067A_DA_IMPUTATION_FUND" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:IMPUTATION/n:FUND/text()" datatype="string" column="FUND" table="FEN0067A_DA_IMPUTATION_IX" />
<sql-index id="SQI_FEN0067A_DA_IMPUTATION_ASSET_NO" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:IMPUTATION/n:ASSET_NO/text()" datatype="string" column="ASSET_NO" table="FEN0067A_DA_IMPUTATION_IX" />
<sql-index id="SQI_FEN0067A_DA_IMPUTATION_CMMT_ITEM" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:IMPUTATION/n:CMMT_ITEM/text()" datatype="string" column="CMMT_ITEM" table="FEN0067A_DA_IMPUTATION_IX" />
<sql-index id="SQI_FEN0067A_DA_IMPUTATION_ACC_CAT" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:IMPUTATION/n:ACC_CAT/text()" datatype="string" column="ACC_CAT" table="FEN0067A_DA_IMPUTATION_IX" />
<sql-index id="SQI_FEN0067A_DA_IMPUTATION_ACTIVITY" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:IMPUTATION/n:ACTIVITY/text()" datatype="string" column="ACTIVITY" table="FEN0067A_DA_IMPUTATION_IX" />
<sql-index id="SQI_FEN0067A_DA_IMPUTATION_LOC_INT" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:IMPUTATION/n:LOC_INT/text()" datatype="string" column="LOC_INT" table="FEN0067A_DA_IMPUTATION_IX" />
<sql-index id="SQI_FEN0067A_DA_IMPUTATION_RES_ITEM" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:IMPUTATION/n:RES_ITEM/text()" datatype="string" column="RES_ITEM" table="FEN0067A_DA_IMPUTATION_IX" />
<sql-index id="SQI_FEN0067A_DA_IMPUTATION_PRESAGE" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:IMPUTATION/n:PRESAGE/text()" datatype="string" column="PRESAGE" table="FEN0067A_DA_IMPUTATION_IX" />
<sql-index id="SQI_FEN0067A_DA_IMPUTATION_AXMIN2" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:IMPUTATION/n:AXMIN2/text()" datatype="string" column="AXMIN2" table="FEN0067A_DA_IMPUTATION_IX" />
<sql-index id="SQI_FEN0067A_DA_IMPUTATION_RES_DOC" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:IMPUTATION/n:RES_DOC/text()" datatype="string" column="RES_DOC" table="FEN0067A_DA_IMPUTATION_IX" />
<sql-index id="SQI_FEN0067A_DA_IMPUTATION_AXMIN1" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:IMPUTATION/n:AXMIN1/text()" datatype="string" column="AXMIN1" table="FEN0067A_DA_IMPUTATION_IX" />
<sql-index id="SQI_FEN0067A_DA_IMPUTATION_CPER" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:IMPUTATION/n:CPER/text()" datatype="string" column="CPER" table="FEN0067A_DA_IMPUTATION_IX" />
<sql-index id="SQI_FEN0067A_DA_IMPUTATION_FUNDS_CTR" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/n:IMPUTATION/n:FUNDS_CTR/text()" datatype="string" column="FUNDS_CTR" table="FEN0067A_DA_IMPUTATION_IX" />

<!-- SQL-INDEX /n:FEN0067A/n:DA/PARTENAIRE -->
<sql-index id="SQI_FEN0067A_DA_PARTENAIRE__NODE_ID" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/PARTENAIRE/@added:generated-id" column="NODE_ID" datatype="string" table="FEN0067A_DA_PARTENAIRE_IX"/>
<sql-index id="SQI_FEN0067A_DA_PARTENAIRE_CITY" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/PARTENAIRE/CITY/text()" datatype="string" column="CITY" table="FEN0067A_DA_PARTENAIRE_IX" />
<sql-index id="SQI_FEN0067A_DA_PARTENAIRE_E_MAIL" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/PARTENAIRE/E_MAIL/text()" datatype="string" column="E_MAIL" table="FEN0067A_DA_PARTENAIRE_IX" />
<sql-index id="SQI_FEN0067A_DA_PARTENAIRE_ADDR_ORIGIN" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/PARTENAIRE/ADDR_ORIGIN/text()" datatype="string" column="ADDR_ORIGIN" table="FEN0067A_DA_PARTENAIRE_IX" />
<sql-index id="SQI_FEN0067A_DA_PARTENAIRE_LINETXT" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/PARTENAIRE/@LineTxt" datatype="string" column="LINETXT" table="FEN0067A_DA_PARTENAIRE_IX" />
<sql-index id="SQI_FEN0067A_DA_PARTENAIRE_ID_LIG" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/PARTENAIRE/ID_LIG/text()" datatype="string" column="ID_LIG" table="FEN0067A_DA_PARTENAIRE_IX" />
<sql-index id="SQI_FEN0067A_DA_PARTENAIRE_COUNTRY" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/PARTENAIRE/COUNTRY/text()" datatype="string" column="COUNTRY" table="FEN0067A_DA_PARTENAIRE_IX" />
<sql-index id="SQI_FEN0067A_DA_PARTENAIRE_POSTL_COD" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/PARTENAIRE/POSTL_COD/text()" datatype="string" column="POSTL_COD" table="FEN0067A_DA_PARTENAIRE_IX" />
<sql-index id="SQI_FEN0067A_DA_PARTENAIRE_FAX_NUMBER" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/PARTENAIRE/FAX_NUMBER/text()" datatype="string" column="FAX_NUMBER" table="FEN0067A_DA_PARTENAIRE_IX" />
<sql-index id="SQI_FEN0067A_DA_PARTENAIRE_NAME" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/PARTENAIRE/NAME/text()" datatype="string" column="NAME" table="FEN0067A_DA_PARTENAIRE_IX" />
<sql-index id="SQI_FEN0067A_DA_PARTENAIRE_PARTNER_FCT" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/PARTENAIRE/PARTNER_FCT/text()" datatype="string" column="PARTNER_FCT" table="FEN0067A_DA_PARTENAIRE_IX" />
<sql-index id="SQI_FEN0067A_DA_PARTENAIRE_FLOOR" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/PARTENAIRE/FLOOR/text()" datatype="string" column="FLOOR" table="FEN0067A_DA_PARTENAIRE_IX" />
<sql-index id="SQI_FEN0067A_DA_PARTENAIRE_ID_AE" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/PARTENAIRE/ID_AE/text()" datatype="string" column="ID_AE" table="FEN0067A_DA_PARTENAIRE_IX" />
<sql-index id="SQI_FEN0067A_DA_PARTENAIRE_ADDR_TYPE" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/PARTENAIRE/ADDR_TYPE/text()" datatype="string" column="ADDR_TYPE" table="FEN0067A_DA_PARTENAIRE_IX" />
<sql-index id="SQI_FEN0067A_DA_PARTENAIRE_ROOM_NO" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/PARTENAIRE/ROOM_NO/text()" datatype="string" column="ROOM_NO" table="FEN0067A_DA_PARTENAIRE_IX" />
<sql-index id="SQI_FEN0067A_DA_PARTENAIRE_HOUSE_NO" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/PARTENAIRE/HOUSE_NO/text()" datatype="string" column="HOUSE_NO" table="FEN0067A_DA_PARTENAIRE_IX" />
<sql-index id="SQI_FEN0067A_DA_PARTENAIRE_ID_FONC_PARTNER" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/PARTENAIRE/ID_FONC_PARTNER/text()" datatype="string" column="ID_FONC_PARTNER" table="FEN0067A_DA_PARTENAIRE_IX" />
<sql-index id="SQI_FEN0067A_DA_PARTENAIRE_TEL_NUMBR" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/PARTENAIRE/TEL_NUMBR/text()" datatype="string" column="TEL_NUMBR" table="FEN0067A_DA_PARTENAIRE_IX" />
<sql-index id="SQI_FEN0067A_DA_PARTENAIRE_PARTNER_TYP" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/PARTENAIRE/PARTNER_TYP/text()" datatype="string" column="PARTNER_TYP" table="FEN0067A_DA_PARTENAIRE_IX" />
<sql-index id="SQI_FEN0067A_DA_PARTENAIRE_ID_CHORUS_PARTNER" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/PARTENAIRE/ID_CHORUS_PARTNER/text()" datatype="string" column="ID_CHORUS_PARTNER" table="FEN0067A_DA_PARTENAIRE_IX" />
<sql-index id="SQI_FEN0067A_DA_PARTENAIRE_BUILDING" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/PARTENAIRE/BUILDING/text()" datatype="string" column="BUILDING" table="FEN0067A_DA_PARTENAIRE_IX" />
<sql-index id="SQI_FEN0067A_DA_PARTENAIRE_STREET" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/PARTENAIRE/STREET/text()" datatype="string" column="STREET" table="FEN0067A_DA_PARTENAIRE_IX" />

<!-- SQL-INDEX /n:FEN0067A/DA/TEXTE -->
<sql-index id="SQI_FEN0067A_DA_TEXTE__NODE_ID" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/TEXTE/@added:generated-id" column="NODE_ID" datatype="string" table="FEN0067A_DA_TEXTE_IX"/>
<sql-index id="SQI_FEN0067A_DA_TEXTE_ID_AE" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/TEXTE/ID_AE/text()" datatype="string" column="ID_AE" table="FEN0067A_DA_TEXTE_IX" />
<sql-index id="SQI_FEN0067A_DA_TEXTE_LINETXT" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/TEXTE/@LineTxt" datatype="string" column="LINETXT" table="FEN0067A_DA_TEXTE_IX" />
<sql-index id="SQI_FEN0067A_DA_TEXTE_TEXT_LINE" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/TEXTE/TEXT_LINE/text()" datatype="string" column="TEXT_LINE" table="FEN0067A_DA_TEXTE_IX" />
<sql-index id="SQI_FEN0067A_DA_TEXTE_ID_LIG" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/TEXTE/ID_LIG/text()" datatype="string" column="ID_LIG" table="FEN0067A_DA_TEXTE_IX" />
<sql-index id="SQI_FEN0067A_DA_TEXTE_TEXT_ID" path="/n:DocDemandeAchat/n:FEN0067A/n:DA/TEXTE/TEXT_ID/text()" datatype="string" column="TEXT_ID" table="FEN0067A_DA_TEXTE_IX" />

<element id="FEN0067A_DA_POSTE_IX"> 
<sql-count>COUNT(DISTINCT(CONCAT(FEN0067A_DA_IX.DOC_ID,FEN0067A_DA_POSTE_IX.NODE_ID)))</sql-count>
<special-cond>FEN0067A_DA_POSTE_IX.NODE_ID IS NOT NULL</special-cond>
</element>
<element id="FEN0067A_DA_IMPUTATION_IX"> 
<sql-count>COUNT(DISTINCT(CONCAT(FEN0067A_DA_IX.DOC_ID,FEN0067A_DA_IMPUTATION_IX.NODE_ID)))</sql-count>
<special-cond>FEN0067A_DA_IMPUTATION_IX.NODE_ID IS NOT NULL</special-cond>
</element>
<element id="FEN0067A_DA_PARTENAIRE_IX"> 
<sql-count>COUNT(DISTINCT(CONCAT(FEN0067A_DA_IX.DOC_ID,FEN0067A_DA_PARTENAIRE_IX.NODE_ID)))</sql-count>
<special-cond>FEN0067A_DA_PARTENAIRE_IX.NODE_ID IS NOT NULL</special-cond>
</element>
<element id="FEN0067A_DA_TEXTE_IX"> 
<sql-count>COUNT(DISTINCT(CONCAT(FEN0067A_DA_IX.DOC_ID,FEN0067A_DA_TEXTE_IX.NODE_ID)))</sql-count>
<special-cond>FEN0067A_DA_TEXTE_IX.NODE_ID IS NOT NULL</special-cond>
</element>

</etat>

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