-<?xml version="1.0" encoding="ISO-8859-1"?>
-<persistence-config>
+<?xml version="1.0" encoding="UTF-8"?><persistence-config>
<layer name="mysql" persistence-model="xemelios-sql">
<document id="cg-etat">
<table type="repository" base-name="CGE_REPOSITORY" version="1">
</etat>
<!--***************************************************************************************************************-->
- <!--********************************************** Balance générale ***********************************************-->
+ <!--********************************************** Balance générale ***********************************************-->
<!--***************************************************************************************************************-->
<etat id="BalanceGenerale" import-xslt-file="cg-etat/cg-etat-import-mysql.xsl">
<key1>
</etat>
<!--***************************************************************************************************************-->
- <!-- **************************************** Développements des Dépenses **************************************** -->
+ <!-- **************************************** Développements des Dépenses **************************************** -->
<!--***************************************************************************************************************-->
<etat id="DeveloppementDepense" import-xslt-file="cg-etat/cg-etat-import-mysql.xsl">
<key1>
</etat>
<!--***************************************************************************************************************-->
- <!-- **************************************** Développements des Recettes **************************************** -->
+ <!-- **************************************** Développements des Recettes **************************************** -->
<!--***************************************************************************************************************-->
<etat id="DeveloppementRecette" import-xslt-file="cg-etat/cg-etat-import-mysql.xsl">
<key1>
</etat>
<!--***************************************************************************************************************-->
- <!-- ***************************************** Récapitulation **************************************************** -->
+ <!-- ***************************************** Récapitulation **************************************************** -->
<!--***************************************************************************************************************-->
<etat id="Recapitulation" import-xslt-file="cg-etat/cg-etat-import-mysql.xsl">
<key1>
</etat>
</document>
</layer>
-</persistence-config>
+<layer name="oracle" persistence-model="xemelios-sql"><document id="cg-etat"><table base-name="CGE_SPECIAL_KEYS" type="special-key" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
+ BUDGET VARCHAR(1000) NOT NULL,
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ ARCHIVE_NAME VARCHAR(1000),
+ KEY2 VARCHAR(1000),
+ KEY1 VARCHAR(1000) NOT NULL,
+ KEY3 VARCHAR(1000),
+ LIB2 VARCHAR(1000),
+ LIB1 VARCHAR(1000),
+ LIB3 VARCHAR(1000),
+ INITIAL_DOC_NAME VARCHAR(1000) NOT NULL
+)</sql><sql>CREATE INDEX IX_${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET)</sql><sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table><table base-name="CGE_LIST_BUDG_COLL" type="list-bc" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
+ PARENT_COLL2_LIB VARCHAR(1000),
+ BUDGET VARCHAR(1000) NOT NULL,
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ ARCHIVE_NAME VARCHAR(1000),
+ PARENT_COLL1_LIB VARCHAR(1000),
+ PARENT_COLL1 VARCHAR(1000),
+ PARENT_COLL2 VARCHAR(1000),
+ BUDGET_LIB VARCHAR(1000),
+ INITIAL_DOC_NAME VARCHAR(1000) NOT NULL,
+ COLLECTIVITE_LIB VARCHAR(1000)
+)</sql><sql>CREATE INDEX IX_${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET)</sql><sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table><table base-name="CGE_REPOSITORY" type="repository" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ ID VARCHAR(1000),
+ REPOSITORY BLOB,
+ LIBELLE VARCHAR(1000)
+)</sql></table><etat id="BalanceGenerale" import-xslt-file="cg-etat/cg-etat-import-mysql.xsl"><key1>
+ <path>/n:CompteGestionEtat/n:BalanceGenerale/n:PageBalanceGenerale/n:LigneBalanceGenerale/@added:generated-id</path>
+ </key1><table base-name="CGE_BALANCEGALE_DOCS" type="document" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
+ BUDGET VARCHAR(1000) NOT NULL,
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ ARCHIVE_NAME VARCHAR(1000),
+ DOC_ID VARCHAR(1000) NOT NULL,
+ DOC BLOB,
+ INITIAL_DOC_NAME VARCHAR(1000) NOT NULL
+)</sql><sql>CREATE INDEX IX_${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table><table base-name="CGE_BALANCEGALE_LIGNE" id="CGE_BALANCEGENERALE_LIGNE_IX" type="index" main="false" based-on="key1" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ BUDGET VARCHAR(1000) NOT NULL,
+ MT_BAL_SORTIE_DEBIT NUMBER,
+ MT_BAL_ENTREE_DEBIT NUMBER,
+ DOC_ID VARCHAR(1000) NOT NULL,
+ NUMCOMPTE VARCHAR(1000),
+ MT_OPE_ANNEE_DEBIT NUMBER,
+ MT_BAL_SORTIE_CREDIT NUMBER,
+ SHOWTOTAUX NUMBER,
+ MT_BAL_ENTREE_CREDIT NUMBER,
+ INITIAL_DOC_NAME VARCHAR(1000),
+ ARCHIVE_NAME VARCHAR(1000),
+ MT_OPE_ANNEE_CREDIT NUMBER,
+ MT_OPE_FIN_ANNEE_CREDIT NUMBER,
+ MT_OPE_FIN_ANNEE_DEBIT NUMBER,
+ NODE_ID VARCHAR(1000) NOT NULL
+)</sql><sql>CREATE INDEX IX_${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX IX_${base-name}_DC ON ${base-name} (DOC_ID)</sql><sql>CREATE INDEX ${base-name}_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql><sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table><table base-name="CGE_BALANCEGALE" id="CGE_BALANCEGENERALE_IX" type="index" main="true" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
+ BUDGET VARCHAR(1000) NOT NULL,
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ ARCHIVE_NAME VARCHAR(1000),
+ DOC_ID VARCHAR(1000) NOT NULL,
+ EXERCICE VARCHAR(1000),
+ NUMPAGE NUMBER,
+ COMPTABLE VARCHAR(1000),
+ INITIAL_DOC_NAME VARCHAR(1000)
+)</sql><sql>CREATE INDEX IX_${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX IX_${base-name}_DC ON ${base-name} (DOC_ID)</sql><sql>CREATE INDEX ${base-name}_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql><sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table><criteria id="CRI_BALANCEGENERALE_BALANCEGENERALE_NUMPAGE" type="1" sql-index-id="SQI_BALANCEGENERALE_NUMPAGE">
+ <where-clause>${table}.${column}##OPERATEUR:NumPage####VALEUR:NumPage##</where-clause>
+ </criteria><criteria id="CRI_BALANCEGENERALE_LIGNE_NUMCOMPTE" type="1" sql-index-id="SQI_BALANCEGENERALE_LIGNE_NUMCOMPTE">
+ <where-clause>fn:string-compare(${table}.${column},NumCompte)</where-clause>
+ </criteria><criteria id="CRI_BALANCEGENERALE_EXERCICE" type="1" sql-index-id="SQI_BALANCEGENERALE_EXERCICE">
+ <where-clause>fn:string-compare(${table}.${column},Exercice)</where-clause>
+ </criteria><criteria id="CRI_BALANCEGENERALE_LIGNE_COMPTABLE" type="1" sql-index-id="SQI_BALANCEGENERALE_LIGNE_COMPTABLE">
+ <where-clause>fn:string-compare(${table}.${column},Comptable)</where-clause>
+ </criteria><criteria id="CRI_BALANCEGENERALE_LIGNE_MONTANTBALANCEENTREEDEBIT" type="1" sql-index-id="SQI_BALANCEGENERALE_LIGNE_MONTANTBALANCEENTREEDEBIT">
+ <where-clause>${table}.${column}##OPERATEUR:BalanceEntreeDebit####VALEUR:BalanceEntreeDebit##</where-clause>
+ </criteria><criteria id="CRI_BALANCEGENERALE_LIGNE_MONTANTBALANCEENTREECREDIT" type="1" sql-index-id="SQI_BALANCEGENERALE_LIGNE_MONTANTBALANCEENTREECREDIT">
+ <where-clause>${table}.${column}##OPERATEUR:BalanceEntreeCredit####VALEUR:BalanceEntreeCredit##</where-clause>
+ </criteria><criteria id="CRI_BALANCEGENERALE_LIGNE_MONTANTOPEANNEEDEBIT" type="1" sql-index-id="SQI_BALANCEGENERALE_LIGNE_MONTANTOPEANNEEDEBIT">
+ <where-clause>${table}.${column}##OPERATEUR:OperationDebit####VALEUR:OperationDebit##</where-clause>
+ </criteria><criteria id="CRI_BALANCEGENERALE_LIGNE_MONTANTOPEANNEECREDIT" type="1" sql-index-id="SQI_BALANCEGENERALE_LIGNE_MONTANTOPEANNEECREDIT">
+ <where-clause>${table}.${column}##OPERATEUR:OperationCredit####VALEUR:OperationCredit##</where-clause>
+ </criteria><criteria id="CRI_BALANCEGENERALE_LIGNE_MONTANTOPEFINANNEEDEBIT" type="1" sql-index-id="SQI_BALANCEGENERALE_LIGNE_MONTANTOPEFINANNEEDEBIT">
+ <where-clause>${table}.${column}##OPERATEUR:OperationFinDebit####VALEUR:OperationFinDebit##</where-clause>
+ </criteria><criteria id="CRI_BALANCEGENERALE_LIGNE_MONTANTOPEFINANNEECREDIT" type="1" sql-index-id="SQI_BALANCEGENERALE_LIGNE_MONTANTOPEFINANNEECREDIT">
+ <where-clause>${table}.${column}##OPERATEUR:OperationFinCredit####VALEUR:OperationFinCredit##</where-clause>
+ </criteria><criteria id="CRI_BALANCEGENERALE_LIGNE_MONTANTBALANCESORTIEDEBIT" type="1" sql-index-id="SQI_BALANCEGENERALE_LIGNE_MONTANTBALANCESORTIEDEBIT">
+ <where-clause>${table}.${column}##OPERATEUR:BalanceSortieDebit####VALEUR:BalanceSortieDebit##</where-clause>
+ </criteria><criteria id="CRI_BALANCEGENERALE_LIGNE_MONTANTBALANCESORTIECREDIT" type="1" sql-index-id="SQI_BALANCEGENERALE_LIGNE_MONTANTBALANCESORTIECREDIT">
+ <where-clause>${table}.${column}##OPERATEUR:BalanceSortieCredit####VALEUR:BalanceSortieCredit##</where-clause>
+ </criteria><criteria id="show_totaux" type="1" sql-index-id="SQI_BALANCEGENERALE_LIGNE_SHOW_TOTAUX">
+ <where-clause>${table}.${column} = ##VALEUR:show_totaux##</where-clause>
+ </criteria><sql-index id="SQI_BALANCEGENERALE_NUMPAGE" path="/n:CompteGestionEtat/n:BalanceGenerale/n:PageBalanceGenerale/n:Pied/@NumPage" datatype="integer" table="CGE_BALANCEGENERALE_IX" column="NUMPAGE"/><sql-index id="SQI_BALANCEGENERALE_EXERCICE" path="/n:CompteGestionEtat/n:Entete/n:Infos/n:Collectivite/@Exercice" datatype="string" table="CGE_BALANCEGENERALE_IX" column="EXERCICE"/><sql-index id="SQI_BALANCEGENERALE_EXERCICEB" path="/CompteGestionEtat/Entete/Infos/Collectivite/@Exercice" datatype="string" table="CGE_BALANCEGENERALE_IX" column="EXERCICE"/><sql-index id="SQI_BALANCEGENERALE_LIGNE_NODE_ID" path="/n:CompteGestionEtat/n:BalanceGenerale/n:PageBalanceGenerale/n:LigneBalanceGenerale/@added:generated-id" datatype="string" table="CGE_BALANCEGENERALE_LIGNE_IX" column="NODE_ID"/><sql-index id="SQI_BALANCEGENERALE_LIGNE_NUMCOMPTE_IS_SEARCHABLE" path="/n:CompteGestionEtat/n:BalanceGenerale/n:PageBalanceGenerale/n:LigneBalanceGenerale[@added:isSearchable]/@NumCompte" datatype="string" table="CGE_BALANCEGENERALE_LIGNE_IX" column="NUMCOMPTE"/><sql-index id="SQI_BALANCEGENERALE_LIGNE_NUMCOMPTE" path="/n:CompteGestionEtat/n:BalanceGenerale/n:PageBalanceGenerale/n:LigneBalanceGenerale/@NumCompte" datatype="string" table="CGE_BALANCEGENERALE_LIGNE_IX" column="NUMCOMPTE"/><sql-index id="SQI_BALANCEGENERALE_LIGNE_COMPTABLE" path="/n:CompteGestionEtat/n:BalanceGenerale/n:PageBalanceGenerale/n:Pied/@Comptable" datatype="string" table="CGE_BALANCEGENERALE_IX" column="COMPTABLE"/><sql-index id="SQI_BALANCEGENERALE_LIGNE_NUMCOMPTEB" path="/CompteGestionEtat/BalanceGenerale/PageBalanceGenerale/LigneBalanceGenerale/@NumCompte" datatype="string" table="CGE_BALANCEGENERALE_LIGNE_IX" column="NUMCOMPTE"/><sql-index id="SQI_BALANCEGENERALE_LIGNE_MONTANTBALANCEENTREEDEBIT" path="/n:CompteGestionEtat/n:BalanceGenerale/n:PageBalanceGenerale/n:LigneBalanceGenerale/@BalanceEntreeDebit" datatype="decimal" table="CGE_BALANCEGENERALE_LIGNE_IX" column="MT_BAL_ENTREE_DEBIT"/><sql-index id="SQI_BALANCEGENERALE_LIGNE_MONTANTBALANCEENTREECREDIT" path="/n:CompteGestionEtat/n:BalanceGenerale/n:PageBalanceGenerale/n:LigneBalanceGenerale/@BalanceEntreeCredit" datatype="decimal" table="CGE_BALANCEGENERALE_LIGNE_IX" column="MT_BAL_ENTREE_CREDIT"/><sql-index id="SQI_BALANCEGENERALE_LIGNE_MONTANTOPEANNEEDEBIT" path="/n:CompteGestionEtat/n:BalanceGenerale/n:PageBalanceGenerale/n:LigneBalanceGenerale/@OperationDebit" datatype="decimal" table="CGE_BALANCEGENERALE_LIGNE_IX" column="MT_OPE_ANNEE_DEBIT"/><sql-index id="SQI_BALANCEGENERALE_LIGNE_MONTANTOPEANNEECREDIT" path="/n:CompteGestionEtat/n:BalanceGenerale/n:PageBalanceGenerale/n:LigneBalanceGenerale/@OperationCredit" datatype="decimal" table="CGE_BALANCEGENERALE_LIGNE_IX" column="MT_OPE_ANNEE_CREDIT"/><sql-index id="SQI_BALANCEGENERALE_LIGNE_MONTANTOPEFINANNEEDEBIT" path="/n:CompteGestionEtat/n:BalanceGenerale/n:PageBalanceGenerale/n:LigneBalanceGenerale/@OperationFinDebit" datatype="decimal" table="CGE_BALANCEGENERALE_LIGNE_IX" column="MT_OPE_FIN_ANNEE_DEBIT"/><sql-index id="SQI_BALANCEGENERALE_LIGNE_MONTANTOPEFINANNEECREDIT" path="/n:CompteGestionEtat/n:BalanceGenerale/n:PageBalanceGenerale/n:LigneBalanceGenerale/@OperationFinCredit" datatype="decimal" table="CGE_BALANCEGENERALE_LIGNE_IX" column="MT_OPE_FIN_ANNEE_CREDIT"/><sql-index id="SQI_BALANCEGENERALE_LIGNE_MONTANTBALANCESORTIEDEBIT" path="/n:CompteGestionEtat/n:BalanceGenerale/n:PageBalanceGenerale/n:LigneBalanceGenerale/@BalanceSortieDebit" datatype="decimal" table="CGE_BALANCEGENERALE_LIGNE_IX" column="MT_BAL_SORTIE_DEBIT"/><sql-index id="SQI_BALANCEGENERALE_LIGNE_MONTANTBALANCESORTIECREDIT" path="/n:CompteGestionEtat/n:BalanceGenerale/n:PageBalanceGenerale/n:LigneBalanceGenerale/@BalanceSortieCredit" datatype="decimal" table="CGE_BALANCEGENERALE_LIGNE_IX" column="MT_BAL_SORTIE_CREDIT"/><sql-index id="SQI_BALANCEGENERALE_LIGNE_SHOW_TOTAUX" path="/n:CompteGestionEtat/n:BalanceGenerale/n:PageBalanceGenerale/n:LigneBalanceGenerale/@added:isNotShowResultat" datatype="integer" table="CGE_BALANCEGENERALE_LIGNE_IX" column="SHOWTOTAUX"/></etat><etat id="DeveloppementRecette" import-xslt-file="cg-etat/cg-etat-import-mysql.xsl"><key1>
+ <path>/n:CompteGestionEtat/n:DeveloppementRecette/n:PageDeveloppementRecette/n:LigneDeveloppementRecette/@added:generated-id</path>
+ </key1><table base-name="CGE_DEV_REC_DOCS" type="document" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
+ BUDGET VARCHAR(1000) NOT NULL,
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ ARCHIVE_NAME VARCHAR(1000),
+ DOC_ID VARCHAR(1000) NOT NULL,
+ DOC BLOB,
+ INITIAL_DOC_NAME VARCHAR(1000) NOT NULL
+)</sql><sql>CREATE INDEX IX_${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table><table base-name="CGE_DEV_REC" id="CGE_DEVELOPPEMENTRECETTE_PAGE_IX" type="index" main="true" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
+ BUDGET VARCHAR(1000) NOT NULL,
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ ARCHIVE_NAME VARCHAR(1000),
+ DOC_ID VARCHAR(1000) NOT NULL,
+ EXERCICE VARCHAR(1000),
+ NUMPAGE NUMBER,
+ COMPTABLE VARCHAR(1000),
+ INITIAL_DOC_NAME VARCHAR(1000)
+)</sql><sql>CREATE INDEX IX_${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX IX_${base-name}_DC ON ${base-name} (DOC_ID)</sql><sql>CREATE INDEX ${base-name}_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql><sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table><table base-name="CGE_DEV_REC_LIGNE" id="CGE_DEVELOPPEMENTRECETTE_LIGNE_IX" type="index" main="false" based-on="key1" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ BUDGET VARCHAR(1000) NOT NULL,
+ COMPTEPEC NUMBER,
+ DOC_ID VARCHAR(1000) NOT NULL,
+ NUMCOMPTE VARCHAR(1000),
+ DROITS NUMBER,
+ TOTRECETTEBUDG NUMBER,
+ TOTDROITS NUMBER,
+ SHOWTOTAUX NUMBER,
+ RECOUVREMENT NUMBER,
+ RARDEB NUMBER,
+ INITIAL_DOC_NAME VARCHAR(1000),
+ ARCHIVE_NAME VARCHAR(1000),
+ RARFIN NUMBER,
+ NATUREPRODUIT VARCHAR(1000),
+ NODE_ID VARCHAR(1000) NOT NULL,
+ LIGNERECETTE NUMBER,
+ RECETTESCOMPTANT NUMBER,
+ TYPE_REC VARCHAR(1000),
+ ANNULATIONS NUMBER
+)</sql><sql>CREATE INDEX IX_${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX IX_${base-name}_DC ON ${base-name} (DOC_ID)</sql><sql>CREATE INDEX ${base-name}_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql><sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table><criteria id="CRI_DEVELOPPEMENTRECETTE_PAGE_EXERCICE" type="1" sql-index-id="SQI_DEVELOPPEMENTRECETTE_PAGE_EXERCICE">
+ <where-clause>fn:string-compare(${table}.${column},Exercice)</where-clause>
+ </criteria><criteria id="CRI_DEVELOPPEMENTRECETTE_PAGE_NUMPAGE" type="1" sql-index-id="SQI_DEVELOPPEMENTRECETTE_PAGE_NUMPAGE">
+ <where-clause>${table}.${column}##OPERATEUR:NumPage####VALEUR:NumPage##</where-clause>
+ </criteria><criteria id="CRI_DEVELOPPEMENTRECETTE_PAGE_COMPTABLE" type="1" sql-index-id="SQI_DEVELOPPEMENTRECETTE_PAGE_COMPTABLE">
+ <where-clause>fn:string-compare(${table}.${column},Comptable)</where-clause>
+ </criteria><criteria id="CRI_DEVELOPPEMENTRECETTE_LIGNE_TYPE" type="1" sql-index-id="SQI_DEVELOPPEMENTRECETTE_LIGNE_TYPE">
+ <where-clause>fn:string-compare(${table}.${column},Type)</where-clause>
+ </criteria><criteria id="CRI_DEVELOPPEMENTRECETTE_LIGNE_RARFIN" type="1" sql-index-id="SQI_DEVELOPPEMENTRECETTE_LIGNE_RARFIN">
+ <where-clause>${table}.${column}##OPERATEUR:RARFin####VALEUR:RARFin##</where-clause>
+ </criteria><criteria id="CRI_DEVELOPPEMENTRECETTE_LIGNE_DROITS" type="1" sql-index-id="SQI_DEVELOPPEMENTRECETTE_LIGNE_DROITS">
+ <where-clause>${table}.${column}##OPERATEUR:Droits####VALEUR:Droits##</where-clause>
+ </criteria><criteria id="CRI_DEVELOPPEMENTRECETTE_LIGNE_RECOUVREMENT" type="1" sql-index-id="SQI_DEVELOPPEMENTRECETTE_LIGNE_RECOUVREMENT">
+ <where-clause>${table}.${column}##OPERATEUR:Recouvrement####VALEUR:Recouvrement##</where-clause>
+ </criteria><criteria id="CRI_DEVELOPPEMENTRECETTE_LIGNE_ANNULATIONS" type="1" sql-index-id="SQI_DEVELOPPEMENTRECETTE_LIGNE_ANNULATIONS">
+ <where-clause>${table}.${column}##OPERATEUR:Annulations####VALEUR:Annulations##</where-clause>
+ </criteria><criteria id="CRI_DEVELOPPEMENTRECETTE_LIGNE_LIGNERECETTE" type="1" sql-index-id="SQI_DEVELOPPEMENTRECETTE_LIGNE_LIGNERECETTE">
+ <where-clause>fn:string-compare(${table}.${column},LigneRecette)</where-clause>
+ </criteria><criteria id="CRI_DEVELOPPEMENTRECETTE_LIGNE_RARDEB" type="1" sql-index-id="SQI_DEVELOPPEMENTRECETTE_LIGNE_RARDEB">
+ <where-clause>${table}.${column}##OPERATEUR:RARDeb####VALEUR:RARDeb##</where-clause>
+ </criteria><criteria id="CRI_DEVELOPPEMENTRECETTE_LIGNE_RECETTESCOMPTANT" type="1" sql-index-id="SQI_DEVELOPPEMENTRECETTE_LIGNE_RECETTESCOMPTANT">
+ <where-clause>${table}.${column}##OPERATEUR:RecettesComptant####VALEUR:RecettesComptant##</where-clause>
+ </criteria><criteria id="CRI_DEVELOPPEMENTRECETTE_LIGNE_COMPTEPEC" type="1" sql-index-id="SQI_DEVELOPPEMENTRECETTE_LIGNE_COMPTEPEC">
+ <where-clause>fn:string-compare(${table}.${column},ComptePEC)</where-clause>
+ </criteria><criteria id="CRI_DEVELOPPEMENTRECETTE_LIGNE_TOTDROITS" type="1" sql-index-id="SQI_DEVELOPPEMENTRECETTE_LIGNE_TOTDROITS">
+ <where-clause>${table}.${column}##OPERATEUR:TotDroits####VALEUR:TotDroits##</where-clause>
+ </criteria><criteria id="CRI_DEVELOPPEMENTRECETTE_LIGNE_TOTRECETTEBUDG" type="1" sql-index-id="SQI_DEVELOPPEMENTRECETTE_LIGNE_TOTRECETTEBUDG">
+ <where-clause>${table}.${column}##OPERATEUR:TotRecetteBudg####VALEUR:TotRecetteBudg##</where-clause>
+ </criteria><criteria id="CRI_DEVELOPPEMENTRECETTE_LIGNE_NATUREPRODUIT" type="1" sql-index-id="SQI_DEVELOPPEMENTRECETTE_LIGNE_NATUREPRODUIT">
+ <where-clause>fn:string-compare(${table}.${column},NatureProduit)</where-clause>
+ </criteria><criteria id="CRI_DEVELOPPEMENTRECETTE_LIGNE_NUMCOMPTE" type="1" sql-index-id="SQI_DEVELOPPEMENTRECETTE_LIGNE_NUMCOMPTE">
+ <where-clause>fn:string-compare(${table}.${column},NumCompte)</where-clause>
+ </criteria><criteria id="show_totaux" type="1" sql-index-id="SQI_DEVELOPPEMENTRECETTE_LIGNE_SHOW_TOTAUX">
+ <where-clause>${table}.${column} = ##VALEUR:show_totaux##</where-clause>
+ </criteria><sql-index id="SQI_DEVELOPPEMENTRECETTE_PAGE_EXERCICE" path="/n:CompteGestionEtat/n:DeveloppementRecette/n:PageDeveloppementRecette/n:Pied/@Exercice" datatype="string" table="CGE_DEVELOPPEMENTRECETTE_PAGE_IX" column="EXERCICE" format="uppercase"/><sql-index id="SQI_DEVELOPPEMENTRECETTE_PAGE_NUMPAGE" path="/n:CompteGestionEtat/n:DeveloppementRecette/n:PageDeveloppementRecette/n:Pied/@NumPage" datatype="integer" table="CGE_DEVELOPPEMENTRECETTE_PAGE_IX" column="NUMPAGE" format="uppercase"/><sql-index id="SQI_DEVELOPPEMENTRECETTE_PAGE_COMPTABLE" path="/n:CompteGestionEtat/n:DeveloppementRecette/n:PageDeveloppementRecette/n:Pied/@Comptable" datatype="string" table="CGE_DEVELOPPEMENTRECETTE_PAGE_IX" column="COMPTABLE" format="uppercase"/><sql-index id="SQI_DEVELOPPEMENTRECETTE_PAGE_EXERCICE" path="/n:CompteGestionEtat/n:Entete/n:Infos/n:Collectivite/@Exercice" datatype="string" table="CGE_DEVELOPPEMENTRECETTE_PAGE_IX" column="EXERCICE"/><sql-index id="SQI_DEVELOPPEMENTRECETTE_PAGE_EXERCICEB" path="/CompteGestionEtat/Entete/Infos/Collectivite/@Exercice" datatype="string" table="CGE_DEVELOPPEMENTRECETTE_PAGE_IX" column="EXERCICE"/><sql-index id="SQI_DEVELOPPEMENTRECETTE_LIGNE_NODE_ID" path="/n:CompteGestionEtat/n:DeveloppementRecette/n:PageDeveloppementRecette/n:LigneDeveloppementRecette/@added:generated-id" datatype="string" table="CGE_DEVELOPPEMENTRECETTE_LIGNE_IX" column="NODE_ID"/><sql-index id="SQI_DEVELOPPEMENTRECETTE_LIGNE_TYPE" path="/n:CompteGestionEtat/n:DeveloppementRecette/n:PageDeveloppementRecette/n:LigneDeveloppementRecette/@Type" datatype="string" table="CGE_DEVELOPPEMENTRECETTE_LIGNE_IX" column="TYPE_REC" format="uppercase"/><sql-index id="SQI_DEVELOPPEMENTRECETTE_LIGNE_RARFIN" path="/n:CompteGestionEtat/n:DeveloppementRecette/n:PageDeveloppementRecette/n:LigneDeveloppementRecette/@RARFin" datatype="decimal" table="CGE_DEVELOPPEMENTRECETTE_LIGNE_IX" column="RARFIN"/><sql-index id="SQI_DEVELOPPEMENTRECETTE_LIGNE_DROITS" path="/n:CompteGestionEtat/n:DeveloppementRecette/n:PageDeveloppementRecette/n:LigneDeveloppementRecette/@Droits" datatype="decimal" table="CGE_DEVELOPPEMENTRECETTE_LIGNE_IX" column="DROITS"/><sql-index id="SQI_DEVELOPPEMENTRECETTE_LIGNE_RECOUVREMENT" path="/n:CompteGestionEtat/n:DeveloppementRecette/n:PageDeveloppementRecette/n:LigneDeveloppementRecette/@Recouvrement" datatype="decimal" table="CGE_DEVELOPPEMENTRECETTE_LIGNE_IX" column="RECOUVREMENT"/><sql-index id="SQI_DEVELOPPEMENTRECETTE_LIGNE_ANNULATIONS" path="/n:CompteGestionEtat/n:DeveloppementRecette/n:PageDeveloppementRecette/n:LigneDeveloppementRecette/@Annulations" datatype="decimal" table="CGE_DEVELOPPEMENTRECETTE_LIGNE_IX" column="ANNULATIONS"/><sql-index id="SQI_DEVELOPPEMENTRECETTE_LIGNE_LIGNERECETTE" path="/n:CompteGestionEtat/n:DeveloppementRecette/n:PageDeveloppementRecette/n:LigneDeveloppementRecette/@LigneRecette" datatype="integer" table="CGE_DEVELOPPEMENTRECETTE_LIGNE_IX" column="LIGNERECETTE" format="uppercase"/><sql-index id="SQI_DEVELOPPEMENTRECETTE_LIGNE_RARDEB" path="/n:CompteGestionEtat/n:DeveloppementRecette/n:PageDeveloppementRecette/n:LigneDeveloppementRecette/@RARDeb" datatype="decimal" table="CGE_DEVELOPPEMENTRECETTE_LIGNE_IX" column="RARDEB"/><sql-index id="SQI_DEVELOPPEMENTRECETTE_LIGNE_RECETTESCOMPTANT" path="/n:CompteGestionEtat/n:DeveloppementRecette/n:PageDeveloppementRecette/n:LigneDeveloppementRecette/@RecettesComptant" datatype="decimal" table="CGE_DEVELOPPEMENTRECETTE_LIGNE_IX" column="RECETTESCOMPTANT"/><sql-index id="SQI_DEVELOPPEMENTRECETTE_LIGNE_COMPTEPEC" path="/n:CompteGestionEtat/n:DeveloppementRecette/n:PageDeveloppementRecette/n:LigneDeveloppementRecette/@ComptePEC" datatype="integer" table="CGE_DEVELOPPEMENTRECETTE_LIGNE_IX" column="COMPTEPEC" format="uppercase"/><sql-index id="SQI_DEVELOPPEMENTRECETTE_LIGNE_TOTDROITS" path="/n:CompteGestionEtat/n:DeveloppementRecette/n:PageDeveloppementRecette/n:LigneDeveloppementRecette/@TotDroits" datatype="decimal" table="CGE_DEVELOPPEMENTRECETTE_LIGNE_IX" column="TOTDROITS"/><sql-index id="SQI_DEVELOPPEMENTRECETTE_LIGNE_TOTRECETTEBUDG" path="/n:CompteGestionEtat/n:DeveloppementRecette/n:PageDeveloppementRecette/n:LigneDeveloppementRecette/@TotRecetteBudg" datatype="decimal" table="CGE_DEVELOPPEMENTRECETTE_LIGNE_IX" column="TOTRECETTEBUDG"/><sql-index id="SQI_DEVELOPPEMENTRECETTE_LIGNE_NATUREPRODUIT" path="/n:CompteGestionEtat/n:DeveloppementRecette/n:PageDeveloppementRecette/n:LigneDeveloppementRecette/@NatureProduit" datatype="string" table="CGE_DEVELOPPEMENTRECETTE_LIGNE_IX" column="NATUREPRODUIT" format="uppercase"/><sql-index id="SQI_DEVELOPPEMENTRECETTE_LIGNE_NUMCOMPTE" path="/n:CompteGestionEtat/n:DeveloppementRecette/n:PageDeveloppementRecette/n:LigneDeveloppementRecette/@NumCompte" datatype="string" table="CGE_DEVELOPPEMENTRECETTE_LIGNE_IX" column="NUMCOMPTE" format="uppercase"/><sql-index id="SQI_DEVELOPPEMENTRECETTE_LIGNE_NUMCOMPTE_IS_SEARCHABLE" path="/n:CompteGestionEtat/n:DeveloppementRecette/n:PageDeveloppementRecette/n:LigneDeveloppementRecette[@added:isSearchable]/@NumCompte" datatype="string" table="CGE_DEVELOPPEMENTRECETTE_LIGNE_IX" column="NUMCOMPTE" format="uppercase"/><sql-index id="SQI_DEVELOPPEMENTRECETTE_LIGNE_SHOW_TOTAUX" path="/n:CompteGestionEtat/n:DeveloppementRecette/n:PageDeveloppementRecette/n:LigneDeveloppementRecette/@added:isNotShowResultat" datatype="integer" table="CGE_DEVELOPPEMENTRECETTE_LIGNE_IX" column="SHOWTOTAUX"/></etat><etat id="Recapitulation" import-xslt-file="cg-etat/cg-etat-import-mysql.xsl"><key1>
+ <path>/n:CompteGestionEtat/n:Recapitulation/n:PageRecapitulation/n:LigneRecapitulation/@added:generated-id</path>
+ </key1><table base-name="CGE_RECAP_DOCS" type="document" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
+ BUDGET VARCHAR(1000) NOT NULL,
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ ARCHIVE_NAME VARCHAR(1000),
+ DOC_ID VARCHAR(1000) NOT NULL,
+ DOC BLOB,
+ INITIAL_DOC_NAME VARCHAR(1000) NOT NULL
+)</sql><sql>CREATE INDEX IX_${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table><table base-name="CGE_RECAP_LIGNE" id="CGE_RECAPITULATION_LIGNE_IX" type="index" main="false" based-on="key1" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ BUDGET VARCHAR(1000) NOT NULL,
+ COMPTEPEC NUMBER,
+ DOC_ID VARCHAR(1000) NOT NULL,
+ NUMCOMPTE VARCHAR(1000),
+ DROITS NUMBER,
+ TOTRECETTEBUDG NUMBER,
+ TOTDROITS NUMBER,
+ SHOWTOTAUX NUMBER,
+ RECOUVREMENT NUMBER,
+ RARDEB NUMBER,
+ INITIAL_DOC_NAME VARCHAR(1000),
+ ARCHIVE_NAME VARCHAR(1000),
+ RARFIN NUMBER,
+ NATUREPRODUIT VARCHAR(1000),
+ NODE_ID VARCHAR(1000) NOT NULL,
+ LIGNERECETTE NUMBER,
+ RECETTESCOMPTANT NUMBER,
+ TYPE_RECAP VARCHAR(1000),
+ ANNULATIONS NUMBER
+)</sql><sql>CREATE INDEX IX_${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX IX_${base-name}_DC ON ${base-name} (DOC_ID)</sql><sql>CREATE INDEX ${base-name}_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql><sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table><table base-name="CGE_RECAP" id="CGE_RECAPITULATION_PAGE_IX" type="index" main="true" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
+ BUDGET VARCHAR(1000) NOT NULL,
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ ARCHIVE_NAME VARCHAR(1000),
+ DOC_ID VARCHAR(1000) NOT NULL,
+ EXERCICE VARCHAR(1000),
+ NUMPAGE NUMBER,
+ COMPTABLE VARCHAR(1000),
+ INITIAL_DOC_NAME VARCHAR(1000)
+)</sql><sql>CREATE INDEX IX_${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX IX_${base-name}_DC ON ${base-name} (DOC_ID)</sql><sql>CREATE INDEX ${base-name}_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql><sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table><criteria id="CRI_RECAPITULATION_PAGE_EXERCICE" type="1" sql-index-id="SQI_RECAPITULATION_PAGE_EXERCICE">
+ <where-clause>fn:string-compare(${table}.${column},Exercice)</where-clause>
+ </criteria><criteria id="CRI_RECAPITULATION_PAGE_NUMPAGE" type="1" sql-index-id="SQI_RECAPITULATION_PAGE_NUMPAGE">
+ <where-clause>${table}.${column}##OPERATEUR:NumPage####VALEUR:NumPage##</where-clause>
+ </criteria><criteria id="CRI_RECAPITULATION_PAGE_COMPTABLE" type="1" sql-index-id="SQI_RECAPITULATION_PAGE_COMPTABLE">
+ <where-clause>fn:string-compare(${table}.${column},Comptable)</where-clause>
+ </criteria><criteria id="CRI_RECAPITULATION_LIGNE_TYPE" type="1" sql-index-id="SQI_RECAPITULATION_LIGNE_TYPE">
+ <where-clause>fn:string-compare(${table}.${column},Type)</where-clause>
+ </criteria><criteria id="CRI_RECAPITULATION_LIGNE_RARFIN" type="1" sql-index-id="SQI_RECAPITULATION_LIGNE_RARFIN">
+ <where-clause>${table}.${column}##OPERATEUR:RARFin####VALEUR:RARFin##</where-clause>
+ </criteria><criteria id="CRI_RECAPITULATION_LIGNE_DROITS" type="1" sql-index-id="SQI_RECAPITULATION_LIGNE_DROITS">
+ <where-clause>${table}.${column}##OPERATEUR:Droits####VALEUR:Droits##</where-clause>
+ </criteria><criteria id="CRI_RECAPITULATION_LIGNE_RECOUVREMENT" type="1" sql-index-id="SQI_RECAPITULATION_LIGNE_RECOUVREMENT">
+ <where-clause>${table}.${column}##OPERATEUR:Recouvrement####VALEUR:Recouvrement##</where-clause>
+ </criteria><criteria id="CRI_RECAPITULATION_LIGNE_ANNULATIONS" type="1" sql-index-id="SQI_RECAPITULATION_LIGNE_ANNULATIONS">
+ <where-clause>${table}.${column}##OPERATEUR:Annulations####VALEUR:Annulations##</where-clause>
+ </criteria><criteria id="CRI_RECAPITULATION_LIGNE_LIGNERECETTE" type="1" sql-index-id="SQI_RECAPITULATION_LIGNE_LIGNERECETTE">
+ <where-clause>fn:string-compare(${table}.${column},LigneRecette)</where-clause>
+ </criteria><criteria id="CRI_RECAPITULATION_LIGNE_RARDEB" type="1" sql-index-id="SQI_RECAPITULATION_LIGNE_RARDEB">
+ <where-clause>${table}.${column}##OPERATEUR:RARDeb####VALEUR:RARDeb##</where-clause>
+ </criteria><criteria id="CRI_RECAPITULATION_LIGNE_RECETTESCOMPTANT" type="1" sql-index-id="SQI_RECAPITULATION_LIGNE_RECETTESCOMPTANT">
+ <where-clause>${table}.${column}##OPERATEUR:RecettesComptant####VALEUR:RecettesComptant##</where-clause>
+ </criteria><criteria id="CRI_RECAPITULATION_LIGNE_COMPTEPEC" type="1" sql-index-id="SQI_RECAPITULATION_LIGNE_COMPTEPEC">
+ <where-clause>fn:string-compare(${table}.${column},ComptePEC)</where-clause>
+ </criteria><criteria id="CRI_RECAPITULATION_LIGNE_TOTDROITS" type="1" sql-index-id="SQI_RECAPITULATION_LIGNE_TOTDROITS">
+ <where-clause>${table}.${column}##OPERATEUR:TotDroits####VALEUR:TotDroits##</where-clause>
+ </criteria><criteria id="CRI_RECAPITULATION_LIGNE_TOTRECETTEBUDG" type="1" sql-index-id="SQI_RECAPITULATION_LIGNE_TOTRECETTEBUDG">
+ <where-clause>${table}.${column}##OPERATEUR:TotRecetteBudg####VALEUR:TotRecetteBudg##</where-clause>
+ </criteria><criteria id="CRI_RECAPITULATION_LIGNE_NATUREPRODUIT" type="1" sql-index-id="SQI_RECAPITULATION_LIGNE_NATUREPRODUIT">
+ <where-clause>fn:string-compare(${table}.${column},NatureProduit)</where-clause>
+ </criteria><criteria id="CRI_RECAPITULATION_LIGNE_NUMCOMPTE" type="1" sql-index-id="SQI_RECAPITULATION_LIGNE_NUMCOMPTE">
+ <where-clause>${table}.${column}##OPERATEUR:NumCompte####VALEUR:NumCompte##</where-clause>
+ </criteria><criteria id="show_totaux" type="1" sql-index-id="SQI_RECAPITULATION_LIGNE_SHOW_TOTAUX">
+ <where-clause>${table}.${column} = ##VALEUR:show_totaux##</where-clause>
+ </criteria><sql-index id="SQI_RECAPITULATION_PAGE_EXERCICE" path="/n:CompteGestionEtat/n:Recapitulation/n:PageRecapitulation/n:Pied/@Exercice" datatype="string" table="CGE_RECAPITULATION_PAGE_IX" column="EXERCICE" format="uppercase"/><sql-index id="SQI_RECAPITULATION_PAGE_NUMPAGE" path="/n:CompteGestionEtat/n:Recapitulation/n:PageRecapitulation/n:Pied/@NumPage" datatype="integer" table="CGE_RECAPITULATION_PAGE_IX" column="NUMPAGE" format="uppercase"/><sql-index id="SQI_RECAPITULATION_PAGE_COMPTABLE" path="/n:CompteGestionEtat/n:Recapitulation/n:PageRecapitulation/n:Pied/@Comptable" datatype="string" table="CGE_RECAPITULATION_PAGE_IX" column="COMPTABLE" format="uppercase"/><sql-index id="SQI_RECAPITULATION_PAGE_EXERCICE" path="/n:CompteGestionEtat/n:Entete/n:Infos/n:Collectivite/@Exercice" datatype="string" table="CGE_RECAPITULATION_PAGE_IX" column="EXERCICE"/><sql-index id="SQI_RECAPITULATION_PAGE_EXERCICEB" path="/CompteGestionEtat/Entete/Infos/Collectivite/@Exercice" datatype="string" table="CGE_RECAPITULATION_PAGE_IX" column="EXERCICE"/><sql-index id="SQI_RECAPITULATION_LIGNE_NODE_ID" path="/n:CompteGestionEtat/n:Recapitulation/n:PageRecapitulation/n:LigneRecapitulation/@added:generated-id" datatype="string" table="CGE_RECAPITULATION_LIGNE_IX" column="NODE_ID"/><sql-index id="SQI_RECAPITULATION_LIGNE_TYPE" path="/n:CompteGestionEtat/n:Recapitulation/n:PageRecapitulation/n:LigneRecapitulation/@Type" datatype="string" table="CGE_RECAPITULATION_LIGNE_IX" column="TYPE_RECAP" format="uppercase"/><sql-index id="SQI_RECAPITULATION_LIGNE_RARFIN" path="/n:CompteGestionEtat/n:Recapitulation/n:PageRecapitulation/n:LigneRecapitulation/@RARFin" datatype="decimal" table="CGE_RECAPITULATION_LIGNE_IX" column="RARFIN"/><sql-index id="SQI_RECAPITULATION_LIGNE_DROITS" path="/n:CompteGestionEtat/n:Recapitulation/n:PageRecapitulation/n:LigneRecapitulation/@Droits" datatype="decimal" table="CGE_RECAPITULATION_LIGNE_IX" column="DROITS"/><sql-index id="SQI_RECAPITULATION_LIGNE_RECOUVREMENT" path="/n:CompteGestionEtat/n:Recapitulation/n:PageRecapitulation/n:LigneRecapitulation/@Recouvrement" datatype="decimal" table="CGE_RECAPITULATION_LIGNE_IX" column="RECOUVREMENT"/><sql-index id="SQI_RECAPITULATION_LIGNE_ANNULATIONS" path="/n:CompteGestionEtat/n:Recapitulation/n:PageRecapitulation/n:LigneRecapitulation/@Annulations" datatype="decimal" table="CGE_RECAPITULATION_LIGNE_IX" column="ANNULATIONS"/><sql-index id="SQI_RECAPITULATION_LIGNE_LIGNERECETTE" path="/n:CompteGestionEtat/n:Recapitulation/n:PageRecapitulation/n:LigneRecapitulation/@LigneRecette" datatype="integer" table="CGE_RECAPITULATION_LIGNE_IX" column="LIGNERECETTE" format="uppercase"/><sql-index id="SQI_RECAPITULATION_LIGNE_RARDEB" path="/n:CompteGestionEtat/n:Recapitulation/n:PageRecapitulation/n:LigneRecapitulation/@RARDeb" datatype="decimal" table="CGE_RECAPITULATION_LIGNE_IX" column="RARDEB"/><sql-index id="SQI_RECAPITULATION_LIGNE_RECETTESCOMPTANT" path="/n:CompteGestionEtat/n:Recapitulation/n:PageRecapitulation/n:LigneRecapitulation/@RecettesComptant" datatype="decimal" table="CGE_RECAPITULATION_LIGNE_IX" column="RECETTESCOMPTANT"/><sql-index id="SQI_RECAPITULATION_LIGNE_COMPTEPEC" path="/n:CompteGestionEtat/n:Recapitulation/n:PageRecapitulation/n:LigneRecapitulation/@ComptePEC" datatype="integer" table="CGE_RECAPITULATION_LIGNE_IX" column="COMPTEPEC" format="uppercase"/><sql-index id="SQI_RECAPITULATION_LIGNE_TOTDROITS" path="/n:CompteGestionEtat/n:Recapitulation/n:PageRecapitulation/n:LigneRecapitulation/@TotDroits" datatype="decimal" table="CGE_RECAPITULATION_LIGNE_IX" column="TOTDROITS"/><sql-index id="SQI_RECAPITULATION_LIGNE_TOTRECETTEBUDG" path="/n:CompteGestionEtat/n:Recapitulation/n:PageRecapitulation/n:LigneRecapitulation/@TotRecetteBudg" datatype="decimal" table="CGE_RECAPITULATION_LIGNE_IX" column="TOTRECETTEBUDG"/><sql-index id="SQI_RECAPITULATION_LIGNE_NATUREPRODUIT" path="/n:CompteGestionEtat/n:Recapitulation/n:PageRecapitulation/n:LigneRecapitulation/@NatureProduit" datatype="string" table="CGE_RECAPITULATION_LIGNE_IX" column="NATUREPRODUIT" format="uppercase"/><sql-index id="SQI_RECAPITULATION_LIGNE_NUMCOMPTE" path="/n:CompteGestionEtat/n:Recapitulation/n:PageRecapitulation/n:LigneRecapitulation/@NumCompte" datatype="string" table="CGE_RECAPITULATION_LIGNE_IX" column="NUMCOMPTE" format="uppercase"/><sql-index id="SQI_RECAPITULATION_LIGNE_SHOW_TOTAUX" path="/n:CompteGestionEtat/n:Recapitulation/n:PageRecapitulation/n:LigneRecapitulation/@added:isNotShowResultat" datatype="integer" table="CGE_RECAPITULATION_LIGNE_IX" column="SHOWTOTAUX"/></etat><etat id="DeveloppementDepense" import-xslt-file="cg-etat/cg-etat-import-mysql.xsl"><key1>
+ <path>/n:CompteGestionEtat/n:DeveloppementDepense/n:PageDeveloppementDepense/n:LigneDeveloppementDepense/@added:generated-id</path>
+ </key1><table base-name="CGE_DEV_DEP" id="DEVELOPPEMENT_DEPENSE_PAGE_IX" type="index" main="true" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ BUDGET VARCHAR(1000) NOT NULL,
+ LIBCOL7 VARCHAR(1000),
+ DOC_ID VARCHAR(1000) NOT NULL,
+ LIBCOL6 VARCHAR(1000),
+ LIBCOL5 VARCHAR(1000),
+ LIBCOL4 VARCHAR(1000),
+ LIBCOL3 VARCHAR(1000),
+ LIBCOL2 VARCHAR(1000),
+ LIBCOL1 VARCHAR(1000),
+ LIBCOL0 VARCHAR(1000),
+ NUMPAGE NUMBER,
+ COMPTABLE VARCHAR(1000),
+ INITIAL_DOC_NAME VARCHAR(1000),
+ ARCHIVE_NAME VARCHAR(1000),
+ EXERCICE NUMBER
+)</sql><sql>CREATE INDEX IX_${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX IX_${base-name}_DC ON ${base-name} (DOC_ID)</sql><sql>CREATE INDEX ${base-name}_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql><sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table><table base-name="CGE_DEV_DEP_DOCS" type="document" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
+ BUDGET VARCHAR(1000) NOT NULL,
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ ARCHIVE_NAME VARCHAR(1000),
+ DOC_ID VARCHAR(1000) NOT NULL,
+ DOC BLOB,
+ INITIAL_DOC_NAME VARCHAR(1000) NOT NULL
+)</sql><sql>CREATE INDEX IX_${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table><table base-name="CGE_DEV_DEP_LIGNE" id="DEVELOPPEMENT_DEPENSE_LIGNE_IX" type="index" main="false" based-on="key1" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ BUDGET VARCHAR(1000) NOT NULL,
+ DOC_ID VARCHAR(1000) NOT NULL,
+ NUMCOMPTE NUMBER,
+ ARTICLEEXEC NUMBER,
+ LIBELLEDPT VARCHAR(1000),
+ PROGRAMME NUMBER,
+ SHOWTOTAUX NUMBER,
+ COMPTABLE VARCHAR(1000),
+ MTDEBIT NUMBER,
+ INITIAL_DOC_NAME VARCHAR(1000),
+ ARCHIVE_NAME VARCHAR(1000),
+ MINISTERE VARCHAR(1000),
+ NODE_ID VARCHAR(1000) NOT NULL,
+ LIBELLECOMPTABLE VARCHAR(1000)
+)</sql><sql>CREATE INDEX IX_${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX IX_${base-name}_DC ON ${base-name} (DOC_ID)</sql><sql>CREATE INDEX ${base-name}_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql><sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table><criteria id="CRI_DEVELOPPEMENT_DEPENSE_PAGE_LIBCOL0" type="1" sql-index-id="SQI_DEVELOPPEMENT_DEPENSE_PAGE_LIBCOL0">
+ <where-clause>fn:string-compare(${table}.${column},LibCol0)</where-clause>
+ </criteria><criteria id="CRI_DEVELOPPEMENT_DEPENSE_PAGE_LIBCOL1" type="1" sql-index-id="SQI_DEVELOPPEMENT_DEPENSE_PAGE_LIBCOL1">
+ <where-clause>fn:string-compare(${table}.${column},LibCol1)</where-clause>
+ </criteria><criteria id="CRI_DEVELOPPEMENT_DEPENSE_PAGE_LIBCOL2" type="1" sql-index-id="SQI_DEVELOPPEMENT_DEPENSE_PAGE_LIBCOL2">
+ <where-clause>fn:string-compare(${table}.${column},LibCol2)</where-clause>
+ </criteria><criteria id="CRI_DEVELOPPEMENT_DEPENSE_PAGE_LIBCOL3" type="1" sql-index-id="SQI_DEVELOPPEMENT_DEPENSE_PAGE_LIBCOL3">
+ <where-clause>fn:string-compare(${table}.${column},LibCol3)</where-clause>
+ </criteria><criteria id="CRI_DEVELOPPEMENT_DEPENSE_PAGE_LIBCOL4" type="1" sql-index-id="SQI_DEVELOPPEMENT_DEPENSE_PAGE_LIBCOL4">
+ <where-clause>fn:string-compare(${table}.${column},LibCol4)</where-clause>
+ </criteria><criteria id="CRI_DEVELOPPEMENT_DEPENSE_PAGE_LIBCOL5" type="1" sql-index-id="SQI_DEVELOPPEMENT_DEPENSE_PAGE_LIBCOL5">
+ <where-clause>fn:string-compare(${table}.${column},LibCol5)</where-clause>
+ </criteria><criteria id="CRI_DEVELOPPEMENT_DEPENSE_PAGE_LIBCOL6" type="1" sql-index-id="SQI_DEVELOPPEMENT_DEPENSE_PAGE_LIBCOL6">
+ <where-clause>fn:string-compare(${table}.${column},LibCol6)</where-clause>
+ </criteria><criteria id="CRI_DEVELOPPEMENT_DEPENSE_PAGE_LIBCOL7" type="1" sql-index-id="SQI_DEVELOPPEMENT_DEPENSE_PAGE_LIBCOL7">
+ <where-clause>fn:string-compare(${table}.${column},LibCol7)</where-clause>
+ </criteria><criteria id="CRI_DEVELOPPEMENT_DEPENSE_PAGE_COMPTABLE" type="1" sql-index-id="SQI_DEVELOPPEMENT_DEPENSE_PAGE_COMPTABLE">
+ <where-clause>fn:string-compare(${table}.${column},Comptable)</where-clause>
+ </criteria><criteria id="CRI_DEVELOPPEMENT_DEPENSE_PAGE_NUMPAGE" type="1" sql-index-id="SQI_DEVELOPPEMENT_DEPENSE_PAGE_NUMPAGE">
+ <where-clause>${table}.${column}##OPERATEUR:NumPage####VALEUR:NumPage##</where-clause>
+ </criteria><criteria id="CRI_DEVELOPPEMENT_DEPENSE_EXERCICE" type="1" sql-index-id="SQI_DEVELOPPEMENT_DEPENSE_EXERCICE">
+ <where-clause>fn:string-compare(${table}.${column},Exercice)</where-clause>
+ </criteria><criteria id="CRI_DEVELOPPEMENT_DEPENSE_LIGNE_NUMCOMPTE" type="1" sql-index-id="SQI_DEVELOPPEMENT_DEPENSE_LIGNE_NUMCOMPTE">
+ <where-clause>fn:string-compare(${table}.${column},NumCompte)</where-clause>
+ </criteria><criteria id="CRI_DEVELOPPEMENT_DEPENSE_LIGNE_COMPTABLE" type="1" sql-index-id="SQI_DEVELOPPEMENT_DEPENSE_LIGNE_COMPTABLE">
+ <where-clause>fn:string-compare(${table}.${column},Comptable)</where-clause>
+ </criteria><criteria id="CRI_DEVELOPPEMENT_DEPENSE_LIGNE_MINISTERE" type="1" sql-index-id="SQI_DEVELOPPEMENT_DEPENSE_LIGNE_MINISTERE">
+ <where-clause>fn:string-compare(${table}.${column},Ministere)</where-clause>
+ </criteria><criteria id="CRI_DEVELOPPEMENT_DEPENSE_LIGNE_PROGRAMME" type="1" sql-index-id="SQI_DEVELOPPEMENT_DEPENSE_LIGNE_PROGRAMME">
+ <where-clause>${table}.${column}##OPERATEUR:Programme####VALEUR:Programme##</where-clause>
+ </criteria><criteria id="CRI_DEVELOPPEMENT_DEPENSE_LIGNE_ARTICLEEXEC" type="1" sql-index-id="SQI_DEVELOPPEMENT_DEPENSE_LIGNE_ARTICLEEXEC">
+ <where-clause>${table}.${column}##OPERATEUR:ArticleExec####VALEUR:ArticleExec##</where-clause>
+ </criteria><criteria id="CRI_DEVELOPPEMENT_DEPENSE_LIGNE_MTDEBIT" type="1" sql-index-id="SQI_DEVELOPPEMENT_DEPENSE_LIGNE_MTDEBIT">
+ <where-clause>${table}.${column}##OPERATEUR:MtDebit####VALEUR:MtDebit##</where-clause>
+ </criteria><criteria id="CRI_DEVELOPPEMENT_DEPENSE_LIGNE_LIBELLECOMPTABLE" type="1" sql-index-id="SQI_DEVELOPPEMENT_DEPENSE_LIGNE_LIBELLECOMPTABLE">
+ <where-clause>fn:string-compare(${table}.${column},LibelleComptable)</where-clause>
+ </criteria><criteria id="CRI_DEVELOPPEMENT_DEPENSE_LIGNE_LIBELLEDPT" type="1" sql-index-id="SQI_DEVELOPPEMENT_DEPENSE_LIGNE_LIBELLEDPT">
+ <where-clause>fn:string-compare(${table}.${column},LibelleDpt)</where-clause>
+ </criteria><criteria id="show_totaux" type="1" sql-index-id="SQI_DEVELOPPEMENT_DEPENSE_LIGNE_TOTAUX">
+ <where-clause>${table}.${column} = ##VALEUR:show_totaux##</where-clause>
+ </criteria><sql-index id="SQI_DEVELOPPEMENT_DEPENSE_PAGE_LIBCOL0" path="/n:CompteGestionEtat/n:DeveloppementDepense/n:PageDeveloppementDepense/n:LigneEnteteDeveloppementDepense/@LibCol0" datatype="string" table="DEVELOPPEMENT_DEPENSE_PAGE_IX" column="LIBCOL0" format="uppercase"/><sql-index id="SQI_DEVELOPPEMENT_DEPENSE_PAGE_LIBCOL7" path="/n:CompteGestionEtat/n:DeveloppementDepense/n:PageDeveloppementDepense/n:LigneEnteteDeveloppementDepense/@LibCol7" datatype="string" table="DEVELOPPEMENT_DEPENSE_PAGE_IX" column="LIBCOL7" format="uppercase"/><sql-index id="SQI_DEVELOPPEMENT_DEPENSE_PAGE_COMPTABLE" path="/n:CompteGestionEtat/n:DeveloppementDepense/n:PageDeveloppementDepense/n:Pied/@Comptable" datatype="string" table="DEVELOPPEMENT_DEPENSE_PAGE_IX" column="COMPTABLE" format="uppercase"/><sql-index id="SQI_DEVELOPPEMENT_DEPENSE_PAGE_LIBCOL6" path="/n:CompteGestionEtat/n:DeveloppementDepense/n:PageDeveloppementDepense/n:LigneEnteteDeveloppementDepense/@LibCol6" datatype="string" table="DEVELOPPEMENT_DEPENSE_PAGE_IX" column="LIBCOL6" format="uppercase"/><sql-index id="SQI_DEVELOPPEMENT_DEPENSE_PAGE_LIBCOL5" path="/n:CompteGestionEtat/n:DeveloppementDepense/n:PageDeveloppementDepense/n:LigneEnteteDeveloppementDepense/@LibCol5" datatype="string" table="DEVELOPPEMENT_DEPENSE_PAGE_IX" column="LIBCOL5" format="uppercase"/><sql-index id="SQI_DEVELOPPEMENT_DEPENSE_PAGE_NUMPAGE" path="/n:CompteGestionEtat/n:DeveloppementDepense/n:PageDeveloppementDepense/n:Pied/@NumPage" datatype="integer" table="DEVELOPPEMENT_DEPENSE_PAGE_IX" column="NUMPAGE" format="uppercase"/><sql-index id="SQI_DEVELOPPEMENT_DEPENSE_PAGE_NUMPAGEB" path="/CompteGestionEtat/DeveloppementDepense/PageDeveloppementDepense/Pied/@NumPage" datatype="integer" table="DEVELOPPEMENT_DEPENSE_PAGE_IX" column="NUMPAGE" format="uppercase"/><sql-index id="SQI_DEVELOPPEMENT_DEPENSE_PAGE_LIBCOL4" path="/n:CompteGestionEtat/n:DeveloppementDepense/n:PageDeveloppementDepense/n:LigneEnteteDeveloppementDepense/@LibCol4" datatype="string" table="DEVELOPPEMENT_DEPENSE_PAGE_IX" column="LIBCOL4" format="uppercase"/><sql-index id="SQI_DEVELOPPEMENT_DEPENSE_PAGE_LIBCOL3" path="/n:CompteGestionEtat/n:DeveloppementDepense/n:PageDeveloppementDepense/n:LigneEnteteDeveloppementDepense/@LibCol3" datatype="string" table="DEVELOPPEMENT_DEPENSE_PAGE_IX" column="LIBCOL3" format="uppercase"/><sql-index id="SQI_DEVELOPPEMENT_DEPENSE_PAGE_LIBCOL2" path="/n:CompteGestionEtat/n:DeveloppementDepense/n:PageDeveloppementDepense/n:LigneEnteteDeveloppementDepense/@LibCol2" datatype="string" table="DEVELOPPEMENT_DEPENSE_PAGE_IX" column="LIBCOL2" format="uppercase"/><sql-index id="SQI_DEVELOPPEMENT_DEPENSE_PAGE_LIBCOL1" path="/n:CompteGestionEtat/n:DeveloppementDepense/n:PageDeveloppementDepense/n:LigneEnteteDeveloppementDepense/@LibCol1" datatype="string" table="DEVELOPPEMENT_DEPENSE_PAGE_IX" column="LIBCOL1" format="uppercase"/><sql-index id="SQI_DEVELOPPEMENT_DEPENSE_EXERCICE" path="/n:CompteGestionEtat/n:Entete/n:Infos/n:Collectivite/@Exercice" datatype="string" table="DEVELOPPEMENT_DEPENSE_PAGE_IX" column="EXERCICE" format="uppercase"/><sql-index id="SQI_DEVELOPPEMENT_DEPENSE_EXERCICEB" path="/CompteGestionEtat/Entete/Infos/Collectivite/@Exercice" datatype="string" table="DEVELOPPEMENT_DEPENSE_PAGE_IX" column="EXERCICE"/><sql-index id="SQI_DEVELOPPEMENT_DEPENSE_LIGNE_NODE_ID" path="/n:CompteGestionEtat/n:DeveloppementDepense/n:PageDeveloppementDepense/n:LigneDeveloppementDepense/@added:generated-id" datatype="string" table="DEVELOPPEMENT_DEPENSE_LIGNE_IX" column="NODE_ID"/><sql-index id="SQI_DEVELOPPEMENT_DEPENSE_LIGNE_PROGRAMME" path="/n:CompteGestionEtat/n:DeveloppementDepense/n:PageDeveloppementDepense/n:LigneDeveloppementDepense/@Programme" datatype="integer" table="DEVELOPPEMENT_DEPENSE_LIGNE_IX" column="PROGRAMME" format="uppercase"/><sql-index id="SQI_DEVELOPPEMENT_DEPENSE_LIGNE_NUMCOMPTE" path="/n:CompteGestionEtat/n:DeveloppementDepense/n:PageDeveloppementDepense/n:LigneDeveloppementDepense/@NumCompte" datatype="string" table="DEVELOPPEMENT_DEPENSE_LIGNE_IX" column="NUMCOMPTE"/><sql-index id="SQI_DEVELOPPEMENT_DEPENSE_LIGNE_NUMCOMPTEB" path="/CompteGestionEtat/DeveloppementDepense/PageDeveloppementDepense/LigneDeveloppementDepense/@NumCompte" datatype="string" table="DEVELOPPEMENT_DEPENSE_LIGNE_IX" column="NUMCOMPTE"/><sql-index id="SQI_DEVELOPPEMENT_DEPENSE_LIGNE_ARTICLEEXEC" path="/n:CompteGestionEtat/n:DeveloppementDepense/n:PageDeveloppementDepense/n:LigneDeveloppementDepense/@ArticleExec" datatype="integer" table="DEVELOPPEMENT_DEPENSE_LIGNE_IX" column="ARTICLEEXEC" format="uppercase"/><sql-index id="SQI_DEVELOPPEMENT_DEPENSE_LIGNE_LIBELLECOMPTABLE" path="/n:CompteGestionEtat/n:DeveloppementDepense/n:PageDeveloppementDepense/n:LigneDeveloppementDepense/@LibelleComptable" datatype="string" table="DEVELOPPEMENT_DEPENSE_LIGNE_IX" column="LIBELLECOMPTABLE" format="uppercase"/><sql-index id="SQI_DEVELOPPEMENT_DEPENSE_LIGNE_MINISTERE" path="/n:CompteGestionEtat/n:DeveloppementDepense/n:PageDeveloppementDepense/n:LigneDeveloppementDepense/@Ministere" datatype="string" table="DEVELOPPEMENT_DEPENSE_LIGNE_IX" column="MINISTERE" format="uppercase"/><sql-index id="SQI_DEVELOPPEMENT_DEPENSE_LIGNE_LIBELLEDPT" path="/n:CompteGestionEtat/n:DeveloppementDepense/n:PageDeveloppementDepense/n:LigneDeveloppementDepense/@LibelleDpt" datatype="string" table="DEVELOPPEMENT_DEPENSE_LIGNE_IX" column="LIBELLEDPT" format="uppercase"/><sql-index id="SQI_DEVELOPPEMENT_DEPENSE_LIGNE_COMPTABLE" path="/n:CompteGestionEtat/n:DeveloppementDepense/n:PageDeveloppementDepense/n:LigneDeveloppementDepense/@Comptable" datatype="string" table="DEVELOPPEMENT_DEPENSE_LIGNE_IX" column="COMPTABLE" format="uppercase"/><sql-index id="SQI_DEVELOPPEMENT_DEPENSE_LIGNE_MTDEBIT" path="/n:CompteGestionEtat/n:DeveloppementDepense/n:PageDeveloppementDepense/n:LigneDeveloppementDepense/@MtDebit" datatype="decimal" table="DEVELOPPEMENT_DEPENSE_LIGNE_IX" column="MTDEBIT" format="uppercase"/><sql-index id="SQI_DEVELOPPEMENT_DEPENSE_LIGNE_TOTAUX" path="/n:CompteGestionEtat/n:DeveloppementDepense/n:PageDeveloppementDepense/n:LigneDeveloppementDepense/@added:isNotShowResultat" datatype="integer" table="DEVELOPPEMENT_DEPENSE_LIGNE_IX" column="SHOWTOTAUX"/></etat><etat id="Accueil" import-xslt-file="cg-etat/cg-etat-import-mysql.xsl"><key1>
+ <path>/n:CompteGestionEtat/n:Accueil/n:PageAccueil/n:LigneAccueil/@added:generated-id</path>
+ </key1><table base-name="CGE_ACCUEIL_DOCS" type="document" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
+ BUDGET VARCHAR(1000) NOT NULL,
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ ARCHIVE_NAME VARCHAR(1000),
+ DOC_ID VARCHAR(1000) NOT NULL,
+ DOC BLOB,
+ INITIAL_DOC_NAME VARCHAR(1000) NOT NULL
+)</sql><sql>CREATE INDEX IX_${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table><table base-name="CGE_ACCUEIL_LIGNE" id="CGE_ACCUEIL_LIGNEACCUEIL_IX" type="index" main="false" based-on="key1" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
+ BUDGET VARCHAR(1000) NOT NULL,
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ ARCHIVE_NAME VARCHAR(1000),
+ DOC_ID VARCHAR(1000) NOT NULL,
+ TITRE VARCHAR(1000),
+ PATH VARCHAR(1000),
+ INITIAL_DOC_NAME VARCHAR(1000),
+ ETAT VARCHAR(1000)
+)</sql><sql>CREATE INDEX IX_${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX IX_${base-name}_DC ON ${base-name} (DOC_ID)</sql><sql>CREATE INDEX ${base-name}_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql><sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table><table base-name="CGE_ACCUEIL" id="CGE_ACCUEIL_IX" type="index" main="true" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
+ BUDGET VARCHAR(1000) NOT NULL,
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ ARCHIVE_NAME VARCHAR(1000),
+ CODEEDITION VARCHAR(1000),
+ DOC_ID VARCHAR(1000) NOT NULL,
+ EXERCICE NUMBER,
+ NUMPAGE NUMBER,
+ INITIAL_DOC_NAME VARCHAR(1000),
+ NUMFIRSTPAGE NUMBER,
+ MODELE NUMBER
+)</sql><sql>CREATE INDEX IX_${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX IX_${base-name}_DC ON ${base-name} (DOC_ID)</sql><sql>CREATE INDEX ${base-name}_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql><sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table><criteria id="CRI_ACCUEIL_ACCUEIL_NUMPAGE" type="1" sql-index-id="SQI_ACCUEIL_ACCUEIL_NUMPAGE">
+ <where-clause>${table}.${column}##OPERATEUR:NumPage####VALEUR:NumPage##</where-clause>
+ </criteria><criteria id="CRI_ACCUEIL_LIGNEACCUEIL_ETAT" type="1" sql-index-id="SQI_ACCUEIL_LIGNEACCUEIL_ETAT">
+ <where-clause>fn:string-compare(${table}.${column},Etat)</where-clause>
+ </criteria><criteria id="CRI_ACCUEIL_LIGNEACCUEIL_TITRE" type="1" sql-index-id="SQI_ACCUEIL_LIGNEACCUEIL_TITRE">
+ <where-clause>fn:string-compare(${table}.${column},Titre)</where-clause>
+ </criteria><criteria id="CRI_ACCUEIL_LIGNEACCUEIL_PATH" type="1" sql-index-id="SQI_ACCUEIL_LIGNEACCUEIL_PATH">
+ <where-clause>fn:string-compare(${table}.${column},Path)</where-clause>
+ </criteria><sql-index id="SQI_ACCUEIL_ACCUEIL_MODELE" path="/n:CompteGestionEtat/n:Accueil/n:PageAccueil/@Modele" datatype="integer" table="CGE_ACCUEIL_IX" column="MODELE"/><sql-index id="SQI_ACCUEIL_ACCUEIL_NUMPAGE" path="/n:CompteGestionEtat/n:Accueil/n:PageAccueil/n:Pied/@NumPage" datatype="integer" table="CGE_ACCUEIL_IX" column="NUMPAGE"/><sql-index id="SQI_ACCUEIL_EXERCICE" path="/n:CompteGestionEtat/n:Entete/n:Infos/n:Collectivite/@Exercice" datatype="integer" table="CGE_ACCUEIL_IX" column="EXERCICE"/><sql-index id="SQI_ACCUEIL_EXERCICEB" path="/CompteGestionEtat/Entete/Infos/Collectivite/@Exercice" datatype="integer" table="CGE_ACCUEIL_IX" column="EXERCICE"/><sql-index id="SQI_ACCUEIL_LIGNEACCUEIL_ETAT" path="/n:CompteGestionEtat/n:Accueil/n:PageAccueil/n:LigneAccueil/@Etat" datatype="string" table="CGE_ACCUEIL_LIGNEACCUEIL_IX" column="ETAT"/><sql-index id="SQI_ACCUEIL_LIGNEACCUEIL_TITRE" path="/n:CompteGestionEtat/n:Accueil/n:PageAccueil/n:LigneAccueil/@Titre" datatype="string" table="CGE_ACCUEIL_LIGNEACCUEIL_IX" column="TITRE"/><sql-index id="SQI_ACCUEIL_LIGNEACCUEIL_PATH" path="/n:CompteGestionEtat/n:Accueil/n:PageAccueil/n:LigneAccueil/@Path" datatype="string" table="CGE_ACCUEIL_LIGNEACCUEIL_IX" column="PATH"/></etat><etat id="Reversement" import-xslt-file="cg-etat/cg-etat-import-mysql.xsl"><key1>
+ <path>/n:CompteGestionEtat/n:Reversement/n:PageReversement/n:LigneReversement/@added:generated-id</path>
+ </key1><table base-name="CGE_REVERS_LIGNE" id="CGE_REVERSEMENT_LIGNE_IX" type="index" main="false" based-on="key1" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ BUDGET VARCHAR(1000) NOT NULL,
+ COMPTEPEC NUMBER,
+ DOC_ID VARCHAR(1000) NOT NULL,
+ NUMCOMPTE VARCHAR(1000),
+ DROITS NUMBER,
+ TOTRECETTEBUDG NUMBER,
+ TOTDROITS NUMBER,
+ SHOWTOTAUX NUMBER,
+ RECOUVREMENT NUMBER,
+ RARDEB NUMBER,
+ INITIAL_DOC_NAME VARCHAR(1000),
+ ARCHIVE_NAME VARCHAR(1000),
+ RARFIN NUMBER,
+ NATUREPRODUIT VARCHAR(1000),
+ NODE_ID VARCHAR(1000) NOT NULL,
+ LIGNERECETTE NUMBER,
+ RECETTESCOMPTANT NUMBER,
+ TYPE_REVERS VARCHAR(1000),
+ ANNULATIONS NUMBER
+)</sql><sql>CREATE INDEX IX_${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX IX_${base-name}_DC ON ${base-name} (DOC_ID)</sql><sql>CREATE INDEX ${base-name}_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql><sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table><table base-name="CGE_REVERS_DOCS" type="document" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
+ BUDGET VARCHAR(1000) NOT NULL,
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ ARCHIVE_NAME VARCHAR(1000),
+ DOC_ID VARCHAR(1000) NOT NULL,
+ DOC BLOB,
+ INITIAL_DOC_NAME VARCHAR(1000) NOT NULL
+)</sql><sql>CREATE INDEX IX_${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table><table base-name="CGE_REVERS" id="CGE_REVERSEMENT_PAGE_IX" type="index" main="true" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
+ BUDGET VARCHAR(1000) NOT NULL,
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ ARCHIVE_NAME VARCHAR(1000),
+ DOC_ID VARCHAR(1000) NOT NULL,
+ EXERCICE VARCHAR(1000),
+ NUMPAGE NUMBER,
+ COMPTABLE VARCHAR(1000),
+ INITIAL_DOC_NAME VARCHAR(1000)
+)</sql><sql>CREATE INDEX IX_${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX IX_${base-name}_DC ON ${base-name} (DOC_ID)</sql><sql>CREATE INDEX ${base-name}_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql><sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table><criteria id="CRI_REVERSEMENT_PAGE_EXERCICE" type="1" sql-index-id="SQI_REVERSEMENT_PAGE_EXERCICE">
+ <where-clause>fn:string-compare(${table}.${column},Exercice)</where-clause>
+ </criteria><criteria id="CRI_REVERSEMENT_PAGE_NUMPAGE" type="1" sql-index-id="SQI_REVERSEMENT_PAGE_NUMPAGE">
+ <where-clause>${table}.${column}##OPERATEUR:NumPage####VALEUR:NumPage##</where-clause>
+ </criteria><criteria id="CRI_REVERSEMENT_PAGE_COMPTABLE" type="1" sql-index-id="SQI_REVERSEMENT_PAGE_COMPTABLE">
+ <where-clause>fn:string-compare(${table}.${column},Comptable)</where-clause>
+ </criteria><criteria id="CRI_REVERSEMENT_LIGNE_TYPE" type="1" sql-index-id="SQI_REVERSEMENT_LIGNE_TYPE">
+ <where-clause>fn:string-compare(${table}.${column},Type)</where-clause>
+ </criteria><criteria id="CRI_REVERSEMENT_LIGNE_RARFIN" type="1" sql-index-id="SQI_REVERSEMENT_LIGNE_RARFIN">
+ <where-clause>${table}.${column}##OPERATEUR:RARFin####VALEUR:RARFin##</where-clause>
+ </criteria><criteria id="CRI_REVERSEMENT_LIGNE_DROITS" type="1" sql-index-id="SQI_REVERSEMENT_LIGNE_DROITS">
+ <where-clause>${table}.${column}##OPERATEUR:Droits####VALEUR:Droits##</where-clause>
+ </criteria><criteria id="CRI_REVERSEMENT_LIGNE_RECOUVREMENT" type="1" sql-index-id="SQI_REVERSEMENT_LIGNE_RECOUVREMENT">
+ <where-clause>${table}.${column}##OPERATEUR:Recouvrement####VALEUR:Recouvrement##</where-clause>
+ </criteria><criteria id="CRI_REVERSEMENT_LIGNE_ANNULATIONS" type="1" sql-index-id="SQI_REVERSEMENT_LIGNE_ANNULATIONS">
+ <where-clause>${table}.${column}##OPERATEUR:Annulations####VALEUR:Annulations##</where-clause>
+ </criteria><criteria id="CRI_REVERSEMENT_LIGNE_LIGNERECETTE" type="1" sql-index-id="SQI_REVERSEMENT_LIGNE_LIGNERECETTE">
+ <where-clause>fn:string-compare(${table}.${column},LigneRecette)</where-clause>
+ </criteria><criteria id="CRI_REVERSEMENT_LIGNE_RARDEB" type="1" sql-index-id="SQI_REVERSEMENT_LIGNE_RARDEB">
+ <where-clause>${table}.${column}##OPERATEUR:RARDeb####VALEUR:RARDeb##</where-clause>
+ </criteria><criteria id="CRI_REVERSEMENT_LIGNE_RECETTESCOMPTANT" type="1" sql-index-id="SQI_REVERSEMENT_LIGNE_RECETTESCOMPTANT">
+ <where-clause>${table}.${column}##OPERATEUR:RecettesComptant####VALEUR:RecettesComptant##</where-clause>
+ </criteria><criteria id="CRI_REVERSEMENT_LIGNE_COMPTEPEC" type="1" sql-index-id="SQI_REVERSEMENT_LIGNE_COMPTEPEC">
+ <where-clause>fn:string-compare(${table}.${column},ComptePEC)</where-clause>
+ </criteria><criteria id="CRI_REVERSEMENT_LIGNE_TOTDROITS" type="1" sql-index-id="SQI_REVERSEMENT_LIGNE_TOTDROITS">
+ <where-clause>${table}.${column}##OPERATEUR:TotDroits####VALEUR:TotDroits##</where-clause>
+ </criteria><criteria id="CRI_REVERSEMENT_LIGNE_TOTRECETTEBUDG" type="1" sql-index-id="SQI_REVERSEMENT_LIGNE_TOTRECETTEBUDG">
+ <where-clause>${table}.${column}##OPERATEUR:TotRecetteBudg####VALEUR:TotRecetteBudg##</where-clause>
+ </criteria><criteria id="CRI_REVERSEMENT_LIGNE_NATUREPRODUIT" type="1" sql-index-id="SQI_REVERSEMENT_LIGNE_NATUREPRODUIT">
+ <where-clause>fn:string-compare(${table}.${column},NatureProduit)</where-clause>
+ </criteria><criteria id="CRI_REVERSEMENT_LIGNE_NUMCOMPTE" type="1" sql-index-id="SQI_REVERSEMENT_LIGNE_NUMCOMPTE">
+ <where-clause>fn:string-compare(${table}.${column},NumCompte)</where-clause>
+ </criteria><criteria id="show_totaux" type="1" sql-index-id="SQI_REVERSEMENT_LIGNE_SHOW_TOTAUX">
+ <where-clause>${table}.${column} = ##VALEUR:show_totaux##</where-clause>
+ </criteria><sql-index id="SQI_REVERSEMENT_PAGE_EXERCICE" path="/n:CompteGestionEtat/n:Reversement/n:PageReversement/n:Pied/@Exercice" datatype="string" table="CGE_REVERSEMENT_PAGE_IX" column="EXERCICE" format="uppercase"/><sql-index id="SQI_REVERSEMENT_PAGE_NUMPAGE" path="/n:CompteGestionEtat/n:Reversement/n:PageReversement/n:Pied/@NumPage" datatype="integer" table="CGE_REVERSEMENT_PAGE_IX" column="NUMPAGE" format="uppercase"/><sql-index id="SQI_REVERSEMENT_PAGE_COMPTABLE" path="/n:CompteGestionEtat/n:Reversement/n:PageReversement/n:Pied/@Comptable" datatype="string" table="CGE_REVERSEMENT_PAGE_IX" column="COMPTABLE" format="uppercase"/><sql-index id="SQI_REVERSEMENT_PAGE_EXERCICE" path="/n:CompteGestionEtat/n:Entete/n:Infos/n:Collectivite/@Exercice" datatype="string" table="CGE_REVERSEMENT_PAGE_IX" column="EXERCICE"/><sql-index id="SQI_REVERSEMENT_PAGE_EXERCICEB" path="/CompteGestionEtat/Entete/Infos/Collectivite/@Exercice" datatype="string" table="CGE_REVERSEMENT_PAGE_IX" column="EXERCICE"/><sql-index id="SQI_REVERSEMENT_LIGNE_NODE_ID" path="/n:CompteGestionEtat/n:Reversement/n:PageReversement/n:LigneReversement/@added:generated-id" datatype="string" table="CGE_REVERSEMENT_LIGNE_IX" column="NODE_ID"/><sql-index id="SQI_REVERSEMENT_LIGNE_TYPE" path="/n:CompteGestionEtat/n:Reversement/n:PageReversement/n:LigneReversement/@Type" datatype="string" table="CGE_REVERSEMENT_LIGNE_IX" column="TYPE_REVERS" format="uppercase"/><sql-index id="SQI_REVERSEMENT_LIGNE_RARFIN" path="/n:CompteGestionEtat/n:Reversement/n:PageReversement/n:LigneReversement/@RARFin" datatype="decimal" table="CGE_REVERSEMENT_LIGNE_IX" column="RARFIN"/><sql-index id="SQI_REVERSEMENT_LIGNE_DROITS" path="/n:CompteGestionEtat/n:Reversement/n:PageReversement/n:LigneReversement/@Droits" datatype="decimal" table="CGE_REVERSEMENT_LIGNE_IX" column="DROITS"/><sql-index id="SQI_REVERSEMENT_LIGNE_RECOUVREMENT" path="/n:CompteGestionEtat/n:Reversement/n:PageReversement/n:LigneReversement/@Recouvrement" datatype="decimal" table="CGE_REVERSEMENT_LIGNE_IX" column="RECOUVREMENT"/><sql-index id="SQI_REVERSEMENT_LIGNE_ANNULATIONS" path="/n:CompteGestionEtat/n:Reversement/n:PageReversement/n:LigneReversement/@Annulations" datatype="decimal" table="CGE_REVERSEMENT_LIGNE_IX" column="ANNULATIONS"/><sql-index id="SQI_REVERSEMENT_LIGNE_LIGNERECETTE" path="/n:CompteGestionEtat/n:Reversement/n:PageReversement/n:LigneReversement/@LigneRecette" datatype="integer" table="CGE_REVERSEMENT_LIGNE_IX" column="LIGNERECETTE" format="uppercase"/><sql-index id="SQI_REVERSEMENT_LIGNE_RARDEB" path="/n:CompteGestionEtat/n:Reversement/n:PageReversement/n:LigneReversement/@RARDeb" datatype="decimal" table="CGE_REVERSEMENT_LIGNE_IX" column="RARDEB"/><sql-index id="SQI_REVERSEMENT_LIGNE_RECETTESCOMPTANT" path="/n:CompteGestionEtat/n:Reversement/n:PageReversement/n:LigneReversement/@RecettesComptant" datatype="decimal" table="CGE_REVERSEMENT_LIGNE_IX" column="RECETTESCOMPTANT"/><sql-index id="SQI_REVERSEMENT_LIGNE_COMPTEPEC" path="/n:CompteGestionEtat/n:Reversement/n:PageReversement/n:LigneReversement/@ComptePEC" datatype="integer" table="CGE_REVERSEMENT_LIGNE_IX" column="COMPTEPEC" format="uppercase"/><sql-index id="SQI_REVERSEMENT_LIGNE_TOTDROITS" path="/n:CompteGestionEtat/n:Reversement/n:PageReversement/n:LigneReversement/@TotDroits" datatype="decimal" table="CGE_REVERSEMENT_LIGNE_IX" column="TOTDROITS"/><sql-index id="SQI_REVERSEMENT_LIGNE_TOTRECETTEBUDG" path="/n:CompteGestionEtat/n:Reversement/n:PageReversement/n:LigneReversement/@TotRecetteBudg" datatype="decimal" table="CGE_REVERSEMENT_LIGNE_IX" column="TOTRECETTEBUDG"/><sql-index id="SQI_REVERSEMENT_LIGNE_NATUREPRODUIT" path="/n:CompteGestionEtat/n:Reversement/n:PageReversement/n:LigneReversement/@NatureProduit" datatype="string" table="CGE_REVERSEMENT_LIGNE_IX" column="NATUREPRODUIT" format="uppercase"/><sql-index id="SQI_REVERSEMENT_LIGNE_NUMCOMPTE" path="/n:CompteGestionEtat/n:Reversement/n:PageReversement/n:LigneReversement/@NumCompte" datatype="string" table="CGE_REVERSEMENT_LIGNE_IX" column="NUMCOMPTE" format="uppercase"/><sql-index id="SQI_REVERSEMENT_LIGNE_SHOW_TOTAUX" path="/n:CompteGestionEtat/n:Reversement/n:PageReversement/n:LigneReversement/@added:isNotShowResultat" datatype="integer" table="CGE_REVERSEMENT_LIGNE_IX" column="SHOWTOTAUX"/></etat></document></layer></persistence-config>
\ No newline at end of file