<?xml version="1.0" encoding="UTF-8"?>
<persistence-config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:noNamespaceSchemaLocation="../../../../defs/config-metier/Persistence.xsd">
    <layer 
        name="mysql" 
        persistence-model="xemelios-sql">
        <document 
            id="DocEtatsFraisSPL"
            repository-import-xslt-file="">

            <table type="list-bc" base-name="EF_SPL_LIST_BUDG_COLL" version="1">
                CREATE TABLE IF NOT EXISTS ${base-name} (
                    COLLECTIVITE VARCHAR(75) 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="EtatFrais" import-xslt-file="etat-frais-spl/etat-frais-import-mysql.xsl">
                <key1>
                    <path>/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/@added:generated-id</path>
                </key1>
                <key2>
                    <path>/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cac:InvoiceLine/@added:generated-id</path>
                </key2>
                <key3>
                    <path>/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cac:InvoiceLine/cac:Item/cac:AdditionalItemProperty/@added:generated-id</path>
                </key3>
                <table base-name="EF_SPL_EF_DOCUMENTS" type="document" version="1">
                    CREATE TABLE IF NOT EXISTS ${base-name} (
                        COLLECTIVITE VARCHAR(75) 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)
                    ) TYPE MYISAM
                </table>
                <table base-name="EF_SPL_EF_FRAIS_IX" type="index" version="3" main="true" id="EF_SPL_EF_FRAIS_IX">
                    CREATE TABLE IF NOT EXISTS ${base-name} (
                        COLLECTIVITE VARCHAR(75) NOT NULL,
                        BUDGET VARCHAR(24) NOT NULL,
                        DOC_ID VARCHAR(100) NOT NULL,
                        ID VARCHAR(75),
                        ID_UNIQUE VARCHAR(75),
                        AGENT_ID VARCHAR(75),
                        AGENT_FAMILYNAME VARCHAR(75),
                        AGENT_FIRSTNAME VARCHAR(75),
                        AGENT_TITLE VARCHAR(75),
                        AGENT_FAMILYADDR_POSTALZONE VARCHAR(10),
                        AGENT_FAMILYADDR_CITYNAME VARCHAR(75),
                        AGENT_FAMILYADDR_LINE VARCHAR(75),
                        AGENT_FAMILYADDR_COUNTRY VARCHAR(2),
                        AGENT_RESADM_POSTALZONE VARCHAR(10),
                        AGENT_RESADM_CITYNAME VARCHAR(75),
                        AGENT_RESADM_LINE VARCHAR(75),
                        AGENT_RESADM_COUNTRY VARCHAR(2),
                        AGENT_GRADE VARCHAR(75),
                        AGENT_EMPLOI VARCHAR(38),
                        AGENT_STATUT VARCHAR(9),
                        AGENT_SITUATIONFAMILLE VARCHAR(11),
                        AGENT_NBENFANTS INT,
                        AGENT_CHORUS_TYPETIERS VARCHAR(4),
                        AGENT_CHORUS_FONC VARCHAR(80),
                        AGENT_CHORUS_ID VARCHAR(10),
                        AGENT_TYPE_PERSONNE VARCHAR(10),
                        OM_ID VARCHAR(75),
                        OM_VALIDEUR_ID VARCHAR(75),
                        OM_VALIDEUR_NOM VARCHAR(75),
                        OM_VALIDEUR_PRENOM VARCHAR(75),
                        OM_DATE_VALIDATION DATE,
                        OM_NATURE_OM VARCHAR(18),
                        OM_MOTIF_DEPLACEMENT VARCHAR(80),
                        OM_FAITGENERATEUR_TYPE VARCHAR(30),
                        OM_FAITGENERATEUR_REFERENCE VARCHAR(80),
                        OM_FAITGENERATEUR_DATE DATE,
                        OM_FAITGENERATEUR_DUREE_OM VARCHAR(10),
                        OM_MOYEN_TRANSP_AUTORISE VARCHAR(75),
                        OM_MOYEN_TRANSP_AUTORISE_CLASSE VARCHAR(75),
                        OM_MT_ESTIM DECIMAL(14,2),
                        OM_DEPL_PAYS VARCHAR(2),
                        OM_DEPL_CP VARCHAR(10),
                        OM_DEPL_VILLE VARCHAR(38),
                        OM_DEP_PAYS VARCHAR(2),
                        OM_DEP_CP VARCHAR(10),
                        OM_DEP_VILLE VARCHAR(38),
                        OM_ARR_PAYS VARCHAR(2),
                        OM_ARR_CP VARCHAR(10),
                        OM_ARR_VILLE VARCHAR(38),
                        OM_DATE_DEPART DATE,
                        OM_DATE_RETOUR DATE,
                        EF_VALIDEUR_ID VARCHAR(75),
                        EF_VALIDEUR_NOM VARCHAR(75),
                        EF_VALIDEUR_PRENOM VARCHAR(75),
                        EF_COMPTA_ASSIGN VARCHAR(100),
                        EF_TOTAL_TRANSP DECIMAL(14,2),
                        EF_TOTAL_SEJOUR DECIMAL(14,2),
                        EF_CHORUS_SOCIETE VARCHAR(4),
                        EF_CHORUS_DOMAINE VARCHAR(4),
                        EF_IDREF VARCHAR(40),
                        EMETTEUR_ID VARCHAR(75),
                        EMETTEUR_NOM VARCHAR(75),
                        MT_TOTAL DECIMAL(14,2),
                        MT_TOTAL_AVANCE_FRAIS DECIMAL(14,2),
                        INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET)
                    ) TYPE MYISAM
                    <patch from-version="2">
                        <sql failonerror="false">ALTER TABLE ${base-name} ADD EF_IDREF VARCHAR(40)</sql>
                    </patch>
                </table>
                <table base-name="EF_SPL_EF_FRAIS_LINE_IX" type="index" version="1" based-on="key2" id="EF_SPL_EF_FRAIS_LINE_IX">
                    CREATE TABLE IF NOT EXISTS ${base-name} (
                        COLLECTIVITE VARCHAR(75) NOT NULL,
                        BUDGET VARCHAR(24) NOT NULL,
                        DOC_ID VARCHAR(100) NOT NULL,
                        INVOICE_ID VARCHAR(75) NOT NULL,
                        LINE_ID VARCHAR(75) NOT NULL,
                        TYPE_LIGNE VARCHAR(22) NOT NULL,
                        LINE_DESCRIPTION VARCHAR(250),
                        LINE_AMOUNT DECIMAL(14,2),
                        LINE_QTY DECIMAL (14,2),
                        INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET)
                    ) TYPE MYISAM
                </table>
                <table base-name="EF_SPL_EF_FRAIS_LINE_TMPLINE_IX" type="index" version="1" based-on="key1" id="EF_SPL_EF_FRAIS_LINE_TMPLINE_IX">
                    CREATE TABLE IF NOT EXISTS ${base-name} (
                    COLLECTIVITE VARCHAR(75) NOT NULL,
                    BUDGET VARCHAR(24) NOT NULL,
                    DOC_ID VARCHAR(100) NOT NULL,
                    INVOICE_ID VARCHAR(75) NOT NULL,
                    INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET)
                    ) TYPE MYISAM
                </table>
                <table base-name="EF_SPL_EF_FRAIS_LINE_ADDPROP" type="index" version="2" based-on="key3" id="EF_SPL_EF_FRAIS_LINE_ADDPROP">
                    CREATE TABLE IF NOT EXISTS ${base-name} (
                        COLLECTIVITE VARCHAR(75) NOT NULL,
                        BUDGET VARCHAR(24) NOT NULL,
                        DOC_ID VARCHAR(100) NOT NULL,
                        INVOICE_ID VARCHAR(75) NOT NULL,
                        LINE_ID VARCHAR(75) NOT NULL,
                        PROPERTY_ID VARCHAR(10) NOT NULL,
                        PROPERTY_NAME VARCHAR(35) NOT NULL,
                        PROPERTY_VALUE VARCHAR(75),
                        INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET)
                    ) TYPE MYISAM
                </table>
                
                <!-- criteres sur Invoice -->
                <criteria id="c.ID" sql-index-id="EF_SPL_IX">
                    <where-clause>fn:string-compare(${table}.${column},c.EF.ID)</where-clause>
                </criteria>
                <criteria id="agent.id" sql-index-id="EF_SPL_AG_ID">
                    <where-clause>fn:string-compare(${table}.${column},agent.id)</where-clause>
                </criteria>
                <criteria id="agent.nom" sql-index-id="EF_SPL_AG_NOM">
                    <where-clause>fn:string-compare(${table}.${column},agent.nom)</where-clause>
                </criteria>
                <criteria id="agent.prenom" sql-index-id="EF_SPL_AG_PRENOM">
                    <where-clause>fn:string-compare(${table}.${column},agent.prenom)</where-clause>
                </criteria>
                <criteria id="agent.civilite" sql-index-id="EF_SPL_AG_TITLE">
                    <where-clause>fn:string-compare(${table}.${column},agent.civilite)</where-clause>
                </criteria>
                <criteria id="agent.address.zone" sql-index-id="EF_SPL_AG_FAMADDRCP">
                    <where-clause>fn:string-compare(${table}.${column},agent.address.zone)</where-clause>
                </criteria>
                <criteria id="agent.address.city" sql-index-id="EF_SPL_AG_FAMADDRVILLE">
                    <where-clause>fn:string-compare(${table}.${column},agent.address.city)</where-clause>
                </criteria>
                <criteria id="agent.address.country" sql-index-id="EF_SPL_AG_FAMADDRCOUNTRY">
                    <where-clause>${table}.${column}='##VALEUR:agent.address.country##'</where-clause>
                </criteria>
                <criteria id="agent.residence.zone" sql-index-id="EF_SPL_AG_RESADMCP">
                    <where-clause>fn:string-compare(${table}.${column},agent.residence.zone)</where-clause>
                </criteria>
                <criteria id="agent.residence.city" sql-index-id="EF_SPL_AG_RESADMVILLE">
                    <where-clause>fn:string-compare(${table}.${column},agent.residence.city)</where-clause>
                </criteria>
                <criteria id="agent.residence.country" sql-index-id="EF_SPL_AG_RESADMCOUNTRY">
                    <where-clause>${table}.${column}='##VALEUR:agent.residence.country##'</where-clause>
                </criteria>
                <criteria id="agent.grade" sql-index-id="EF_SPL_AG_GRADE">
                    <where-clause>fn:string-compare(${table}.${column},agent.grade)</where-clause>
                </criteria>
                <criteria id="agent.emploi" sql-index-id="EF_SPL_AG_EMPLOI">
                    <where-clause>fn:string-compare(${table}.${column},agent.emploi)</where-clause>
                </criteria>
                <criteria id="agent.statut" sql-index-id="EF_SPL_AG_STATUT">
                    <where-clause>${table}.${column}='##VALEUR:agent.statut##'</where-clause>
                </criteria>
                <criteria id="agent.famille.situation" sql-index-id="EF_SPL_AG_SITUATIONFAMILLE">
                    <where-clause>${table}.${column}='##VALEUR:agent.famille.situation##'</where-clause>
                </criteria>
                <criteria id="agent.nbenfants" sql-index-id="EF_SPL_AG_NBENFANTS">
                    <where-clause>${table}.${column}##OPERATEUR:agent.nbenfants####VALEUR:agent.nbenfants##</where-clause>
                </criteria>
                <criteria id="agent.chorus.typetiers" sql-index-id="EF_SPL_AG_CHORUS_TYPETIERS">
                    <where-clause>${table}.${column}='##VALEUR:agent.chorus.typetiers##'</where-clause>
                </criteria>
                <criteria id="agent.chorus.id.fonct" sql-index-id="EF_SPL_AG_CHORUS_FONC">
                    <where-clause>fn:string-compare(${table}.${column},agent.chorus.id.fonct)</where-clause>
                </criteria>
                <criteria id="agent.chorus.id" sql-index-id="EF_SPL_AG_CHORUS_ID">
                    <where-clause>fn:string-compare(${table}.${column},agent.chorus.id)</where-clause>
                </criteria>
                <criteria id="agent.type.personne" sql-index-id="EF_SPL_AG_TYPE_PERSONNE">
                    <where-clause>${table}.${column}='##VALEUR:agent.type.personne##'</where-clause>
                </criteria>
                <criteria id="OM.id" sql-index-id="EF_SPL_OM_ID">
                    <where-clause>fn:string-compare(${table}.${column},OM.id)</where-clause>
                </criteria>
                <criteria id="OM.valideur.ID" sql-index-id="EF_SPL_OM_VALIDEUR_ID">
                    <where-clause>fn:string-compare(${table}.${column},OM.valideur.ID)</where-clause>
                </criteria>
                <criteria id="OM.valideur.nom" sql-index-id="EF_SPL_OM_VALIDEUR_NOM">
                    <where-clause>fn:string-compare(${table}.${column},OM.valideur.nom)</where-clause>
                </criteria>
                <criteria id="OM.valideur.prenom" sql-index-id="EF_SPL_OM_VALIDEUR_PRENOM">
                    <where-clause>fn:string-compare(${table}.${column},OM.valideur.prenom)</where-clause>
                </criteria>
                <criteria id="OM.date.validation" sql-index-id="EF_SPL_OM_DATE_VALIDATION">
                    <where-clause>fn:date-compare(${table}.${column},OM.date.validation)</where-clause>
                </criteria>
                <criteria id="OM.nature.om" sql-index-id="EF_SPL_OM_NATURE_OM">
                    <where-clause>${table}.${column}='##VALEUR:OM.nature.om##'</where-clause>
                </criteria>
                <criteria id="OM.motif.deplacement" sql-index-id="EF_SPL_OM_MOTIF_DEPLACEMENT">
                    <where-clause>fn:string-compare(${table}.${column},OM.motif.deplacement)</where-clause>
                </criteria>
                <criteria id="OM.faitgenerateur.type" sql-index-id="EF_SPL_OM_FAITGENERATEUR_TYPE">
                    <where-clause>${table}.${column}='##VALEUR:OM.faitgenerateur.type##'</where-clause>
                </criteria>
                <criteria id="OM.faitgenerateur.reference" sql-index-id="EF_SPL_OM_FAITGENERATEUR_REFERENCE">
                    <where-clause>fn:string-compare(${table}.${column},OM.faitgenerateur.reference)</where-clause>
                </criteria>
                <criteria id="OM.faitgenerateur.date" sql-index-id="EF_SPL_OM_FAITGENERATEUR_DATE">
                    <where-clause>fn:date-compare(${table}.${column},OM.faitgenerateur.date)</where-clause>
                </criteria>
                <criteria id="OM.faitgenerateur.duree.om" sql-index-id="EF_SPL_OM_FAITGENERATEUR_DUREE_OM">
                    <where-clause>${table}.${column}='##VALEUR:OM.faitgenerateur.duree.om##'</where-clause>
                </criteria>
                <criteria id="OM.moyen.transport.autorise" sql-index-id="EF_SPL_OM_MOYEN_TRANSP_AUTORISE">
                    <where-clause>fn:string-compare(${table}.${column},OM.moyen.transport.autorise)</where-clause>
                </criteria>
                <criteria id="OM.moyen.transport.autorise.classe" sql-index-id="EF_SPL_OM_MOYEN_TRANSP_AUTORISE_CLASSE">
                    <where-clause>fn:string-compare(${table}.${column},OM.moyen.transport.autorise.classe)</where-clause>
                </criteria>
                <criteria id="OM.montant.estimatif" sql-index-id="EF_SPL_OM_MT_ESTIM">
                    <where-clause>${table}.${column}##OPERATEUR:OM.mt.estimatif####VALEUR:OM.mt.estimatif##</where-clause>
                </criteria>
                <criteria id="OM.lieu.depl.pays" sql-index-id="EF_SPL_OM_DEPL_PAYS">
                    <where-clause>${table}.${column}='##VALEUR:OM.lieu.depl.pays##'</where-clause>
                </criteria>
                <criteria id="OM.lieu.depl.cp" sql-index-id="EF_SPL_OM_DEPL_CP">
                    <where-clause>fn:string-compare(${table}.${column},OM.lieu.depl.CP)</where-clause>
                </criteria>
                <criteria id="OM.lieu.depl.ville" sql-index-id="EF_SPL_OM_DEPL_VILLE">
                    <where-clause>fn:string-compare(${table}.${column},OM.lieu.depl.ville)</where-clause>
                </criteria>
                <criteria id="OM.lieu.dep.pays" sql-index-id="EF_SPL_OM_DEP_PAYS">
                    <where-clause>${table}.${column}='##VALEUR:OM.lieu.depl.pays##'</where-clause>
                </criteria>
                <criteria id="OM.lieu.dep.cp" sql-index-id="EF_SPL_OM_DEP_CP">
                    <where-clause>fn:string-compare(${table}.${column},OM.lieu.dep.CP)</where-clause>
                </criteria>
                <criteria id="OM.lieu.dep.ville" sql-index-id="EF_SPL_OM_DEP_VILLE">
                    <where-clause>fn:string-compare(${table}.${column},OM.lieu.dep.ville)</where-clause>
                </criteria>
                <criteria id="OM.lieu.arr.pays" sql-index-id="EF_SPL_OM_ARR_PAYS">
                    <where-clause>${table}.${column}='##VALEUR:OM.lieu.arr.pays##'</where-clause>
                </criteria>
                <criteria id="OM.lieu.arr.cp" sql-index-id="EF_SPL_OM_ARR_CP">
                    <where-clause>fn:string-compare(${table}.${column},OM.lieu.arr.CP)</where-clause>
                </criteria>
                <criteria id="OM.lieu.arr.ville" sql-index-id="EF_SPL_OM_ARR_VILLE">
                    <where-clause>fn:string-compare(${table}.${column},OM.lieu.arr.ville)</where-clause>
                </criteria>
                <criteria id="OM.date.depart" sql-index-id="EF_SPL_OM_DATE_DEPART">
                    <where-clause>fn:date-compare(${table}.${column},OM.date.depart)</where-clause>
                </criteria>
                <criteria id="OM.date.retour" sql-index-id="EF_SPL_OM_DATE_RETOUR">
                    <where-clause>fn:date-compare(${table}.${column},OM.date.retour)</where-clause>
                </criteria>
                <criteria id="EF.valideur.ID" sql-index-id="EF_SPL_EF_VALIDEUR_ID">
                    <where-clause>fn:string-compare(${table}.${column},EF.valideur.ID)</where-clause>
                </criteria>
                <criteria id="EF.valideur.nom" sql-index-id="EF_SPL_EF_VALIDEUR_NOM">
                    <where-clause>fn:string-compare(${table}.${column},EF.valideur.nom)</where-clause>
                </criteria>
                <criteria id="EF.valideur.prenom" sql-index-id="EF_SPL_EF_VALIDEUR_PRENOM">
                    <where-clause>fn:string-compare(${table}.${column},EF.valideur.prenom)</where-clause>
                </criteria>
                <criteria id="EF.idref" sql-index-id="EF_SPL_EF_IDREF">
                    <where-clause>fn:string-compare(${table}.${column},EF.idref)</where-clause>
                </criteria>
                <criteria id="EF.comptable.assign" sql-index-id="EF_SPL_COMPTA_ASSIGN">
                    <where-clause>fn:string-compare(${table}.${column},EF.comptable.assign)</where-clause>
                </criteria>
                <criteria id="EF.total.transport" sql-index-id="EF_SPL_TOTAL_TRANSP">
                    <where-clause>${table}.${column}##OPERATEUR:EF.total.transport####VALEUR:EF.total.transport##</where-clause>
                </criteria>
                <criteria id="EF.total.residence" sql-index-id="EF_SPL_TOTAL_SEJOUR">
                    <where-clause>${table}.${column}##OPERATEUR:EF.total.residence####VALEUR:EF.total.residence##</where-clause>
                </criteria>
                <criteria id="EF.chorus.societe" sql-index-id="EF_SPL_CHORUS_SOCIETE">
                    <where-clause>fn:string-compare(${table}.${column},EF.chorus.societe)</where-clause>
                </criteria>
                <criteria id="EF.chorus.domaine" sql-index-id="EF_SPL_CHORUS_DOMAINE">
                    <where-clause>fn:string-compare(${table}.${column},EF.chorus.domaine)</where-clause>
                </criteria>
                <criteria id="emetteur.ID" sql-index-id="EF_SPL_EMETTEUR_ID">
                    <where-clause>fn:string-compare(${table}.${column},emetteur.id)</where-clause>
                </criteria>
                <criteria id="emetteur.nom" sql-index-id="EF_SPL_EMETTEUR_NOM">
                    <where-clause>fn:string-compare(${table}.${column},emetteur.nom)</where-clause>
                </criteria>
                <criteria id="EF.mt.total" sql-index-id="EF_SPL_MT_TOTAL">
                    <where-clause>${table}.${column}##OPERATEUR:EF.mt.total####VALEUR:EF.mt.total##</where-clause>
                </criteria>
                <criteria id="EF.mt.total.avance.frais" sql-index-id="EF_SPL_MT_TOTAL_AVANCE_FRAIS">
                    <where-clause>${table}.${column}##OPERATEUR:EF.mt.total.avance.frais####VALEUR:EF.mt.total.avance.frais##</where-clause>
                </criteria>
                <!-- criteres sur lignes -->
                <criteria id="line.type.ligne" sql-index-id="EF_SPL_LINE_TYPE">
                    <where-clause>${table}.${column}=&quot;##VALEUR:line.type.ligne##&quot;</where-clause>
                </criteria>
                <criteria id="line.description" sql-index-id="EF_SPL_LINE_DESC">
                    <where-clause>fn:string-compare(${table}.${column},line.description)</where-clause>
                </criteria>
                <criteria id="line.qty" sql-index-id="EF_SPL_LINE_QTY">
                    <where-clause>${table.column}##OPERATEUR:line.qty####VALEUR:line.qty##</where-clause>
                </criteria>
                <criteria id="line.compte.imput" sql-index-id="EF_SPL_PROP_PROP_VALUE">
                    <where-clause>${table}.PROPERTY_NAME='CH_COMPTE_PCE' AND fn:string-compare(${table}.${column},compte)</where-clause>
                </criteria>
                <criteria id="line.prop" sql-index-id="EF_SPL_PROP_PROP_VALUE">
                    <where-clause>${table}.PROPERTY_NAME='##VALEUR:prop##' AND fn:string-compare(${table}.${column},value)</where-clause>
                </criteria>
                
                <sql-index id="EF_SPL_UNIQUE_ID_IX"         table="EF_SPL_EF_FRAIS_IX"              column="ID_UNIQUE"                      path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/@ano:unique-id" datatype="string"/>
                <sql-index id="EF_SPL_IX"                   table="EF_SPL_EF_FRAIS_IX"              column="ID"                             path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cbc:ID/text()" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_AG_ID"                table="EF_SPL_EF_FRAIS_IX"              column="AGENT_ID"                       path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cac:AccountingSupplierParty/cac:Party/cac:PartyIdentification/cbc:ID/text()" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_AG_NOM"               table="EF_SPL_EF_FRAIS_IX"              column="AGENT_FAMILYNAME"               path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cac:AccountingSupplierParty/cac:Party/cac:Person/cbc:FamilyName/text()" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_AG_PRENOM"            table="EF_SPL_EF_FRAIS_IX"              column="AGENT_FIRSTNAME"                path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cac:AccountingSupplierParty/cac:Party/cac:Person/cbc:FirstName/text()" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_AG_TITLE"             table="EF_SPL_EF_FRAIS_IX"              column="AGENT_TITLE"                    path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cac:AccountingSupplierParty/cac:Party/cac:Person/cbc:Title/text()" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_AG_FAMADDRCP"         table="EF_SPL_EF_FRAIS_IX"              column="AGENT_FAMILYADDR_POSTALZONE"    path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cac:AccountingSupplierParty/cac:Party/cac:PostalAddress/cbc:PostalZone/text()" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_AG_FAMADDRVILLE"      table="EF_SPL_EF_FRAIS_IX"              column="AGENT_FAMILYADDR_CITYNAME"      path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cac:AccountingSupplierParty/cac:Party/cac:PostalAddress/cbc:CityName/text()" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_AG_FAMADDRLINE"       table="EF_SPL_EF_FRAIS_IX"              column="AGENT_FAMILYADDR_LINE"          path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cac:AccountingSupplierParty/cac:Party/cac:PostalAddress/cac:AddressLine/cbc:Line/text()" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_AG_FAMADDRCOUNTRY"    table="EF_SPL_EF_FRAIS_IX"              column="AGENT_FAMILYADDR_COUNTRY"       path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cac:AccountingSupplierParty/cac:Party/cac:PostalAddress/cac:Country/cbc:IdentificationCode/text()" datatype="string"/>
                <sql-index id="EF_SPL_AG_RESADMCP"          table="EF_SPL_EF_FRAIS_IX"              column="AGENT_RESADM_POSTALZONE"        path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cac:AccountingSupplierParty/cac:Party/cac:PhysicalLocation/cac:Address/cbc:PostalZone/text()" datatype="string"/>
                <sql-index id="EF_SPL_AG_RESADMVILLE"       table="EF_SPL_EF_FRAIS_IX"              column="AGENT_RESADM_CITYNAME"          path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cac:AccountingSupplierParty/cac:Party/cac:PhysicalLocation/cac:Address/cbc:CityName/text()" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_AG_RESADMLINE"        table="EF_SPL_EF_FRAIS_IX"              column="AGENT_RESADM_LINE"              path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cac:AccountingSupplierParty/cac:Party/cac:PhysicalLocation/cac:Address/cac:AddressLine/cbc:Line/text()" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_AG_RESADMCOUNTRY"     table="EF_SPL_EF_FRAIS_IX"              column="AGENT_RESADM_COUNTRY"           path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cac:AccountingSupplierParty/cac:Party/cac:PhysicalLocation/cac:Address/cac:Country/cbc:IdentificationCode/text()" datatype="string"/>
                <sql-index id="EF_SPL_AG_GRADE"             table="EF_SPL_EF_FRAIS_IX"              column="AGENT_GRADE"                    path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:Agent/dgfip:Grade/text()" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_AG_EMPLOI"            table="EF_SPL_EF_FRAIS_IX"              column="AGENT_EMPLOI"                   path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:Agent/dgfip:EmploiFonction/text()" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_AG_STATUT"            table="EF_SPL_EF_FRAIS_IX"              column="AGENT_STATUT"                   path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:Agent/dgfip:Statut/text()" datatype="string"/>
                <sql-index id="EF_SPL_AG_SITUATIONFAMILLE"  table="EF_SPL_EF_FRAIS_IX"              column="AGENT_SITUATIONFAMILLE"         path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:Agent/dgfip:SituationFamille/text()" datatype="string"/>
                <sql-index id="EF_SPL_AG_NBENFANTS"         table="EF_SPL_EF_FRAIS_IX"              column="AGENT_NBENFANTS"                path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:Agent/dgfip:NbEnfants/text()" datatype="integer"/>
                <sql-index id="EF_SPL_AG_CHORUS_TYPETIERS"  table="EF_SPL_EF_FRAIS_IX"              column="AGENT_CHORUS_TYPETIERS"         path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:Agent/dgfip:AgentChorus/dgfip:TypeTiers/text()" datatype="string"/>
                <sql-index id="EF_SPL_AG_CHORUS_FONC"       table="EF_SPL_EF_FRAIS_IX"              column="AGENT_CHORUS_FONC"              path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:Agent/dgfip:AgentChorus/dgfip:IdFoncTiers/text()" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_AG_CHORUS_ID"         table="EF_SPL_EF_FRAIS_IX"              column="AGENT_CHORUS_ID"                path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:Agent/dgfip:AgentChorus/dgfip:IdChorusTiers/text()" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_AG_TYPE_PERSONNE"     table="EF_SPL_EF_FRAIS_IX"              column="AGENT_TYPE_PERSONNE"            path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:Agent/dgfip:TypePersonne/text()" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_OM_ID"                table="EF_SPL_EF_FRAIS_IX"              column="OM_ID"                          path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:ID/text()" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_OM_VALIDEUR_ID"       table="EF_SPL_EF_FRAIS_IX"              column="OM_VALIDEUR_ID"                 path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:Valideur/cac:PartyIdentification/cbc:ID/text()" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_OM_VALIDEUR_NOM"      table="EF_SPL_EF_FRAIS_IX"              column="OM_VALIDEUR_NOM"                path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:Valideur/cac:Person/cbc:FamilyName/text()" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_OM_VALIDEUR_PRENOM"   table="EF_SPL_EF_FRAIS_IX"              column="OM_VALIDEUR_PRENOM"             path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:Valideur/cac:Person/cbc:FirstName/text()" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_OM_DATE_VALIDATION"   table="EF_SPL_EF_FRAIS_IX"              column="OM_DATE_VALIDATION"             path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:DateValidation/text()" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="EF_SPL_OM_NATURE_OM"         table="EF_SPL_EF_FRAIS_IX"              column="OM_NATURE_OM"                   path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:NatureOM/text()" datatype="string"/>
                <sql-index id="EF_SPL_OM_MOTIF_DEPLACEMENT" table="EF_SPL_EF_FRAIS_IX"              column="OM_MOTIF_DEPLACEMENT"           path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:MotifDeplacement/text()" datatype="string"/>
                <sql-index id="EF_SPL_OM_FAITGENERATEUR_TYPE"   table="EF_SPL_EF_FRAIS_IX"          column="OM_FAITGENERATEUR_TYPE"         path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:FaitGenerateur/dgfip:Type/text()" datatype="string"/>
                <sql-index id="EF_SPL_OM_FAITGENERATEUR_REFERENCE" table="EF_SPL_EF_FRAIS_IX"       column="OM_FAITGENERATEUR_REFERENCE"    path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:FaitGenerateur/dgfip:Reference/text()" datatype="string"/>
                <sql-index id="EF_SPL_OM_FAITGENERATEUR_DATE"   table="EF_SPL_EF_FRAIS_IX"          column="OM_FAITGENERATEUR_DATE"         path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:FaitGenerateur/dgfip:Date/text()" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="EF_SPL_OM_FAITGENERATEUR_DUREE_OM" table="EF_SPL_EF_FRAIS_IX"        column="OM_FAITGENERATEUR_DUREE_OM"     path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:FaitGenerateur/dgfip:DureeOM/text()" datatype="string"/>
                <sql-index id="EF_SPL_OM_MOYEN_TRANSP_AUTORISE" table="EF_SPL_EF_FRAIS_IX"          column="OM_MOYEN_TRANSP_AUTORISE" path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:MoyenTransportAutorise/text()" datatype="string"/>
                <sql-index id="EF_SPL_OM_MOYEN_TRANSP_AUTORISE_CLASSE" table="EF_SPL_EF_FRAIS_IX"   column="OM_MOYEN_TRANSP_AUTORISE_CLASSE" path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:MoyenTransportAutorise/@ClasseAutorisee" datatype="string"/>
                <sql-index id="EF_SPL_OM_MT_ESTIM"          table="EF_SPL_EF_FRAIS_IX"              column="OM_MT_ESTIM"                    path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:MontantEstimatif/text()" datatype="decimal"/>
                <sql-index id="EF_SPL_OM_DEPL_PAYS"         table="EF_SPL_EF_FRAIS_IX"              column="OM_DEPL_PAYS"                   path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:LieuDeplacement/@CodPays" datatype="string"/>
                <sql-index id="EF_SPL_OM_DEPL_CP"           table="EF_SPL_EF_FRAIS_IX"              column="OM_DEPL_CP"                     path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:LieuDeplacement/@CP" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_OM_DEPL_VILLE"        table="EF_SPL_EF_FRAIS_IX"              column="OM_DEPL_VILLE"                  path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:LieuDeplacement/@Commune" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_OM_DEP_PAYS"          table="EF_SPL_EF_FRAIS_IX"              column="OM_DEP_PAYS"                    path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:LieuDepart/@CodPays" datatype="string"/>
                <sql-index id="EF_SPL_OM_DEP_CP"            table="EF_SPL_EF_FRAIS_IX"              column="OM_DEP_CP"                      path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:LieuDepart/@CP" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_OM_DEP_VILLE"         table="EF_SPL_EF_FRAIS_IX"              column="OM_DEP_VILLE"                   path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:LieuDepart/@Commune" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_OM_ARR_PAYS"          table="EF_SPL_EF_FRAIS_IX"              column="OM_ARR_PAYS"                    path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:LieuArrivee/@CodPays" datatype="string"/>
                <sql-index id="EF_SPL_OM_ARR_CP"            table="EF_SPL_EF_FRAIS_IX"              column="OM_ARR_CP"                      path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:LieuArrivee/@CP" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_OM_ARR_VILLE"         table="EF_SPL_EF_FRAIS_IX"              column="OM_ARR_VILLE"                   path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:LieuArrivee/@Commune" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_OM_DATE_DEPART"       table="EF_SPL_EF_FRAIS_IX"              column="OM_DATE_DEPART"                 path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:DateDepart/text()" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="EF_SPL_OM_DATE_RETOUR"       table="EF_SPL_EF_FRAIS_IX"              column="OM_DATE_RETOUR"                 path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:OrdreMission/dgfip:DateRetour/text()" datatype="date" format="yyyy-MM-dd"/>
                <sql-index id="EF_SPL_EF_VALIDEUR_ID"       table="EF_SPL_EF_FRAIS_IX"              column="EF_VALIDEUR_ID"                 path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:EtatFrais/dgfip:Valideur/cac:PartyIdentification/cbc:ID/text()" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_EF_VALIDEUR_NOM"      table="EF_SPL_EF_FRAIS_IX"              column="EF_VALIDEUR_NOM"                path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:EtatFrais/dgfip:Valideur/cac:Person/cbc:FamilyName/text()" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_EF_VALIDEUR_PRENOM"   table="EF_SPL_EF_FRAIS_IX"              column="EF_VALIDEUR_PRENOM"             path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:EtatFrais/dgfip:Valideur/cac:Person/cbc:FirstName/text()" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_EF_IDREF"             table="EF_SPL_EF_FRAIS_IX"              column="EF_IDREF"                       path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:EtatFrais/dgfip:IdRef/text()" datatype="string"/>
                <sql-index id="EF_SPL_COMPTA_ASSIGN"        table="EF_SPL_EF_FRAIS_IX"              column="EF_COMPTA_ASSIGN"               path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:EtatFrais/dgfip:ComptableAssignataire/text()" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_TOTAL_TRANSP"         table="EF_SPL_EF_FRAIS_IX"              column="EF_TOTAL_TRANSP"                path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:EtatFrais/dgfip:TotalFraisTransport/text()" datatype="decimal"/>
                <sql-index id="EF_SPL_TOTAL_SEJOUR"         table="EF_SPL_EF_FRAIS_IX"              column="EF_TOTAL_SEJOUR"                path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:EtatFrais/dgfip:TotalIndemnitesSejour/text()" datatype="decimal"/>
                <sql-index id="EF_SPL_CHORUS_SOCIETE"       table="EF_SPL_EF_FRAIS_IX"              column="EF_CHORUS_SOCIETE"              path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:EtatFrais/dgfip:EtatFraisChorus/dgfip:Societe/text()" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_CHORUS_DOMAINE"       table="EF_SPL_EF_FRAIS_IX"              column="EF_CHORUS_DOMAINE"              path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cec:UBLExtensions/cec:UBLExtension/cec:ExtensionContent/dgfip:EtatFraisExtension/dgfip:EtatFrais/dgfip:EtatFraisChorus/dgfip:DomaineActivite/text()" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_EMETTEUR_ID"          table="EF_SPL_EF_FRAIS_IX"              column="EMETTEUR_ID"                    path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cac:AccountingCustomerParty/cac:Party/cac:PartyIdentification/cbc:ID/text()" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_EMETTEUR_NOM"         table="EF_SPL_EF_FRAIS_IX"              column="EMETTEUR_NOM"                   path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cac:AccountingCustomerParty/cac:Party/cac:PartyLegalEntity/cbc:RegistrationName/text()" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_MT_TOTAL"             table="EF_SPL_EF_FRAIS_IX"              column="MT_TOTAL"                       path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cac:LegalMonetaryTotal/cbc:PayableAmount/text()" datatype="decimal"/>
                <sql-index id="EF_SPL_MT_TOTAL_AVANCE_FRAIS" table="EF_SPL_EF_FRAIS_IX"             column="MT_TOTAL_AVANCE_FRAIS"          path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cac:LegalMonetaryTotal/cbc:PrepaidAmount/text()" datatype="decimal"/>
                
                <sql-index id="EF_SPL_LINE_ID_INVOICE"      table="EF_SPL_EF_FRAIS_LINE_IX"         column="INVOICE_ID"                     path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cbc:ID/text()" use-in-criteria="false" datatype="string" format="uppercase" reset-on="key1"/>
                <sql-index id="EF_SPL_LINE_ID"              table="EF_SPL_EF_FRAIS_LINE_IX"         column="LINE_ID"                        path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cac:InvoiceLine/@added:generated-id" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_LINE_TYPE"            table="EF_SPL_EF_FRAIS_LINE_IX"         column="TYPE_LIGNE"                     path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cac:InvoiceLine/cac:Item/cac:BuyersItemIdentification/cbc:ID/text()" datatype="string"/>
                <sql-index id="EF_SPL_LINE_DESC"            table="EF_SPL_EF_FRAIS_LINE_IX"         column="LINE_DESCRIPTION"               path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cac:InvoiceLine/cac:Item/cbc:Description/text()" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_LINE_AMOUNT"          table="EF_SPL_EF_FRAIS_LINE_IX"         column="LINE_AMOUNT"                    path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cac:InvoiceLine/cac:Price/cbc:PriceAmount/text()" datatype="decimal"/>
                <sql-index id="EF_SPL_LINE_QTY"             table="EF_SPL_EF_FRAIS_LINE_IX"         column="LINE_QTY"                       path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cac:InvoiceLine/cbc:InvoicedQuantity/text()" datatype="decimal"/>
                
                <sql-index id="EF_SPL_PROP_ID_INVOICE"      table="EF_SPL_EF_FRAIS_LINE_ADDPROP"    column="INVOICE_ID"                     path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cbc:ID/text()" use-in-criteria="false" datatype="string" format="uppercase" reset-on="key1"/>
                <sql-index id="EF_SPL_PROP_ID_LINE"         table="EF_SPL_EF_FRAIS_LINE_ADDPROP"    column="LINE_ID"                        path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cac:InvoiceLine/@added:generated-id" use-in-criteria="false" reset-on="key2" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_PROP_ID_PROP"         table="EF_SPL_EF_FRAIS_LINE_ADDPROP"    column="PROPERTY_ID"                    path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cac:InvoiceLine/cac:Item/cac:AdditionalItemProperty/@added:generated-id" datatype="string"/>
                <sql-index id="EF_SPL_PROP_PROP_NAME"       table="EF_SPL_EF_FRAIS_LINE_ADDPROP"    column="PROPERTY_NAME"                  path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cac:InvoiceLine/cac:Item/cac:AdditionalItemProperty/cbc:Name/text()" datatype="string" format="uppercase"/>
                <sql-index id="EF_SPL_PROP_PROP_VALUE"      table="EF_SPL_EF_FRAIS_LINE_ADDPROP"    column="PROPERTY_VALUE"                 path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cac:InvoiceLine/cac:Item/cac:AdditionalItemProperty/cbc:Value/text()" datatype="string" format="uppercase"/>
                
            </etat>
        </document>
    </layer>
</persistence-config>

