--- /dev/null
+<?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="etat-frais"
+ repository-import-xslt-file="">
+ <table type="list-bc" base-name="EF_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)
+ ) ENGINE MYISAM
+ </table>
+ <etat id="EtatFrais" import-xslt-file="etat-frais/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_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)
+ ) ENGINE MYISAM
+ </table>
+ <table base-name="EF_EF_FRAIS_IX" type="index" version="2" main="true" id="EF_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),
+ 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_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),
+ EMETTEUR_ID VARCHAR(75),
+ EMETTEUR_NOM VARCHAR(75),
+ MT_TOTAL DECIMAL(14,2),
+ INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET)
+ ) ENGINE MYISAM
+ <patch from-version="1">
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD ID_UNIQUE VARCHAR(75)</sql>
+ </patch>
+ </table>
+ <table base-name="EF_EF_FRAIS_LINE_IX" type="index" version="1" based-on="key2" id="EF_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)
+ ) ENGINE MYISAM
+ </table>
+ <table base-name="EF_EF_FRAIS_LINE_TMPLINE_IX" type="index" version="1" based-on="key1" id="EF_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)
+ ) ENGINE MYISAM
+ </table>
+ <table base-name="EF_EF_FRAIS_LINE_ADDPROP" type="index" version="2" based-on="key3" id="EF_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)
+ ) ENGINE MYISAM
+ <patch from-version="1">
+ <sql failonerror="false">ALTER TABLE ${base-name} MODIFY PROPERTY_NAME VARCHAR(35)</sql>
+ </patch>
+
+ </table>
+
+ <!-- criteres sur Invoice -->
+ <criteria id="c.ID" sql-index-id="EF_IX">
+ <where-clause>fn:string-compare(${table}.${column},c.EF.ID)</where-clause>
+ </criteria>
+ <criteria id="agent.id" sql-index-id="EF_AG_ID">
+ <where-clause>fn:string-compare(${table}.${column},agent.id)</where-clause>
+ </criteria>
+ <criteria id="agent.nom" sql-index-id="EF_AG_NOM">
+ <where-clause>fn:string-compare(${table}.${column},agent.nom)</where-clause>
+ </criteria>
+ <criteria id="agent.prenom" sql-index-id="EF_AG_PRENOM">
+ <where-clause>fn:string-compare(${table}.${column},agent.prenom)</where-clause>
+ </criteria>
+ <criteria id="agent.civilite" sql-index-id="EF_AG_TITLE">
+ <where-clause>fn:string-compare(${table}.${column},agent.civilite)</where-clause>
+ </criteria>
+ <criteria id="agent.address.zone" sql-index-id="EF_AG_FAMADDRCP">
+ <where-clause>fn:string-compare(${table}.${column},agent.address.zone)</where-clause>
+ </criteria>
+ <criteria id="agent.address.city" sql-index-id="EF_AG_FAMADDRVILLE">
+ <where-clause>fn:string-compare(${table}.${column},agent.address.city)</where-clause>
+ </criteria>
+ <criteria id="agent.address.country" sql-index-id="EF_AG_FAMADDRCOUNTRY">
+ <where-clause>${table}.${column}='##VALEUR:agent.address.country##'</where-clause>
+ </criteria>
+ <criteria id="agent.residence.zone" sql-index-id="EF_AG_RESADMCP">
+ <where-clause>fn:string-compare(${table}.${column},agent.residence.zone)</where-clause>
+ </criteria>
+ <criteria id="agent.residence.city" sql-index-id="EF_AG_RESADMVILLE">
+ <where-clause>fn:string-compare(${table}.${column},agent.residence.city)</where-clause>
+ </criteria>
+ <criteria id="agent.residence.country" sql-index-id="EF_AG_RESADMCOUNTRY">
+ <where-clause>${table}.${column}='##VALEUR:agent.residence.country##'</where-clause>
+ </criteria>
+ <criteria id="agent.grade" sql-index-id="EF_AG_GRADE">
+ <where-clause>fn:string-compare(${table}.${column},agent.grade)</where-clause>
+ </criteria>
+ <criteria id="agent.emploi" sql-index-id="EF_AG_EMPLOI">
+ <where-clause>fn:string-compare(${table}.${column},agent.emploi)</where-clause>
+ </criteria>
+ <criteria id="agent.statut" sql-index-id="EF_AG_STATUT">
+ <where-clause>${table}.${column}='##VALEUR:agent.statut##'</where-clause>
+ </criteria>
+ <criteria id="agent.famille.situation" sql-index-id="EF_AG_SITUATIONFAMILLE">
+ <where-clause>${table}.${column}='##VALEUR:agent.famille.situation##'</where-clause>
+ </criteria>
+ <criteria id="agent.nbenfants" sql-index-id="EF_AG_NBENFANTS">
+ <where-clause>${table}.${column}##OPERATEUR:agent.nbenfants####VALEUR:agent.nbenfants##</where-clause>
+ </criteria>
+ <criteria id="agent.chorus.typetiers" sql-index-id="EF_AG_CHORUS_TYPETIERS">
+ <where-clause>${table}.${column}='##VALEUR:agent.chorus.typetiers##'</where-clause>
+ </criteria>
+ <criteria id="agent.chorus.id.fonct" sql-index-id="EF_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_AG_CHORUS_ID">
+ <where-clause>fn:string-compare(${table}.${column},agent.chorus.id)</where-clause>
+ </criteria>
+ <criteria id="OM.id" sql-index-id="EF_OM_ID">
+ <where-clause>fn:string-compare(${table}.${column},OM.id)</where-clause>
+ </criteria>
+ <criteria id="OM.valideur.ID" sql-index-id="EF_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_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_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_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_OM_NATURE_OM">
+ <where-clause>${table}.${column}='##VALEUR:OM.nature.om##'</where-clause>
+ </criteria>
+ <criteria id="OM.montant.estimatif" sql-index-id="EF_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_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_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_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_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_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_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_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_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_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_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_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_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_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_EF_VALIDEUR_PRENOM">
+ <where-clause>fn:string-compare(${table}.${column},EF.valideur.prenom)</where-clause>
+ </criteria>
+ <criteria id="EF.comptable.assign" sql-index-id="EF_COMPTA_ASSIGN">
+ <where-clause>fn:string-compare(${table}.${column},EF.comptable.assign)</where-clause>
+ </criteria>
+ <criteria id="EF.total.transport" sql-index-id="EF_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_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_CHORUS_SOCIETE">
+ <where-clause>fn:string-compare(${table}.${column},EF.chorus.societe)</where-clause>
+ </criteria>
+ <criteria id="EF.chorus.domaine" sql-index-id="EF_CHORUS_DOMAINE">
+ <where-clause>fn:string-compare(${table}.${column},EF.chorus.domaine)</where-clause>
+ </criteria>
+ <criteria id="emetteur.ID" sql-index-id="EF_EMETTEUR_ID">
+ <where-clause>fn:string-compare(${table}.${column},emetteur.id)</where-clause>
+ </criteria>
+ <criteria id="emetteur.nom" sql-index-id="EF_EMETTEUR_NOM">
+ <where-clause>fn:string-compare(${table}.${column},emetteur.nom)</where-clause>
+ </criteria>
+ <criteria id="EF.mt.total" sql-index-id="EF_MT_TOTAL">
+ <where-clause>${table}.${column}##OPERATEUR:EF.mt.total####VALEUR:EF.mt.total##</where-clause>
+ </criteria>
+ <!-- criteres sur lignes -->
+ <criteria id="line.type.ligne" sql-index-id="EF_LINE_TYPE">
+ <where-clause>${table}.${column}="##VALEUR:line.type.ligne##"</where-clause>
+ </criteria>
+ <criteria id="line.description" sql-index-id="EF_LINE_DESC">
+ <where-clause>fn:string-compare(${table}.${column},line.description)</where-clause>
+ </criteria>
+ <criteria id="line.qty" sql-index-id="EF_LINE_QTY">
+ <where-clause>${table.column}##OPERATEUR:line.qty####VALEUR:line.qty##</where-clause>
+ </criteria>
+ <criteria id="line.compte.imput" sql-index-id="EF_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_PROP_PROP_VALUE">
+ <where-clause>${table}.PROPERTY_NAME='##VALEUR:prop##' AND fn:string-compare(${table}.${column},value)</where-clause>
+ </criteria>
+
+ <sql-index id="EF_UNIQUE_ID_IX" table="EF_EF_FRAIS_IX" column="ID_UNIQUE" path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/@ano:unique-id" datatype="string"/>
+ <sql-index id="EF_IX" table="EF_EF_FRAIS_IX" column="ID" path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cbc:ID/text()" datatype="string" format="uppercase"/>
+ <sql-index id="EF_AG_ID" table="EF_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_AG_NOM" table="EF_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_AG_PRENOM" table="EF_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_AG_TITLE" table="EF_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_AG_FAMADDRCP" table="EF_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_AG_FAMADDRVILLE" table="EF_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_AG_FAMADDRLINE" table="EF_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_AG_FAMADDRCOUNTRY" table="EF_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_AG_RESADMCP" table="EF_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_AG_RESADMVILLE" table="EF_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_AG_RESADMLINE" table="EF_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_AG_RESADMCOUNTRY" table="EF_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_AG_GRADE" table="EF_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_AG_EMPLOI" table="EF_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_AG_STATUT" table="EF_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_AG_SITUATIONFAMILLE" table="EF_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_AG_NBENFANTS" table="EF_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_AG_CHORUS_TYPETIERS" table="EF_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_AG_CHORUS_FONC" table="EF_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_AG_CHORUS_ID" table="EF_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_OM_ID" table="EF_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_OM_VALIDEUR_ID" table="EF_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_OM_VALIDEUR_NOM" table="EF_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_OM_VALIDEUR_PRENOM" table="EF_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_OM_DATE_VALIDATION" table="EF_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_OM_NATURE_OM" table="EF_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_OM_MT_ESTIM" table="EF_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_OM_DEPL_PAYS" table="EF_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_OM_DEPL_CP" table="EF_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_OM_DEPL_VILLE" table="EF_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_OM_DEP_PAYS" table="EF_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_OM_DEP_CP" table="EF_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_OM_DEP_VILLE" table="EF_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_OM_ARR_PAYS" table="EF_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_OM_ARR_CP" table="EF_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_OM_ARR_VILLE" table="EF_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_OM_DATE_DEPART" table="EF_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_OM_DATE_RETOUR" table="EF_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_EF_VALIDEUR_ID" table="EF_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_EF_VALIDEUR_NOM" table="EF_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_EF_VALIDEUR_PRENOM" table="EF_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_COMPTA_ASSIGN" table="EF_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_TOTAL_TRANSP" table="EF_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_TOTAL_SEJOUR" table="EF_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_CHORUS_SOCIETE" table="EF_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_CHORUS_DOMAINE" table="EF_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_EMETTEUR_ID" table="EF_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_EMETTEUR_NOM" table="EF_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_MT_TOTAL" table="EF_EF_FRAIS_IX" column="MT_TOTAL" path="/added:DocEtatsFrais/ef:EtatsFrais/ef:Invoice/cac:LegalMonetaryTotal/cbc:PayableAmount/text()" datatype="decimal"/>
+
+ <sql-index id="EF_LINE_ID_INVOICE" table="EF_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_LINE_ID" table="EF_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_LINE_TYPE" table="EF_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_LINE_DESC" table="EF_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_LINE_AMOUNT" table="EF_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_LINE_QTY" table="EF_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_PROP_ID_INVOICE" table="EF_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_PROP_ID_LINE" table="EF_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_PROP_ID_PROP" table="EF_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_PROP_PROP_NAME" table="EF_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_PROP_PROP_VALUE" table="EF_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>
+