-<?xml version="1.0" encoding="UTF-8"?>
-<document>
- <table base-name="PES_ALLER_SPECIAL_KEYS" new-name="PES_ALLER_SK">
- <column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)"
- new-qualif="NOT NULL"/>
- <column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"
- new-qualif="NOT NULL"/>
- <column id="KEY1" new-name="KEY1" new-type="VARCHAR(1000)"/>
- <column id="LIB1" new-name="LIB1" new-type="VARCHAR(1000)"/>
- <column id="KEY2" new-name="KEY2" new-type="VARCHAR(1000)"/>
- <column id="LIB2" new-name="LIB2" new-type="VARCHAR(1000)"/>
- <column id="KEY3" new-name="KEY3" new-type="VARCHAR(1000)"/>
- <column id="LIB3" new-name="LIB3" new-type="VARCHAR(1000)"/>
- <column id="KEY4" new-name="KEY4" new-type="VARCHAR(1000)" avoid-generate="true"/>
- <column id="LIB4" new-name="LIB4" new-type="VARCHAR(1000)" avoid-generate="true"/>
- <column id="KEY5" new-name="KEY5" new-type="VARCHAR(1000)" avoid-generate="true"/>
- <column id="LIB5" new-name="LIB5" new-type="" avoid-generate="true"/>
- <column id="KEY6" new-name="KEY6" new-type="VARCHAR(1000)" avoid-generate="true"/>
- <column id="LIB6" new-name="LIB6" new-type="VARCHAR(1000)" avoid-generate="true"/>
- <column id="KEY7" new-name="KEY7" new-type="VARCHAR(1000)" avoid-generate="true"/>
- <column id="LIB7" new-name="LIB7" new-type="" avoid-generate="true"/>
- <column id="KEY8" new-name="KEY8" new-type="VARCHAR(1000)" avoid-generate="true"/>
- <column id="LIB8" new-name="LIB8" new-type="VARCHAR(1000)" avoid-generate="true"/>
- <column id="KEY9" new-name="KEY9" new-type="VARCHAR(1000)" avoid-generate="true"/>
- <column id="LIB9" new-name="LIB9" new-type="" avoid-generate="true"/>
- <column id="KEY10" new-name="KEY10" new-type="VARCHAR(1000)" avoid-generate="true"/>
- <column id="LIB10" new-name="LIB10" new-type="VARCHAR(1000)" avoid-generate="true"/>
- <column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/>
- <index id="IX_${base-name}_BC" new-name="${base-name}_BC"/>
- <index id="${base-name}_AN" new-name="${base-name}_AN"/>
- </table>
- <table base-name="PES_ALLER_LIST_BUDG_COLL" new-name="PES_ALLER_LBC">
- <column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)"
- new-qualif="NOT NULL"/>
- <column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="BUDGET_LIB" new-name="BUDGET_LIB" new-type="VARCHAR(1000)"/>
- <column id="COLLECTIVITE_LIB" new-name="COLLECTIVITE_LIB" new-type="VARCHAR(1000)"/>
- <column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"
- new-qualif="NOT NULL"/>
- <column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/>
- <index id="IX_${base-name}_BC" new-name="${base-name}_BC"/>
- <index id="${base-name}_AN" new-name="${base-name}_AN"/>
- </table>
- <table base-name="PES_ALLER_REPOSITORY" new-name="PES_ALLER_REPOSITORY">
- <column id="ID" new-name="ID" new-type="VARCHAR(1000)"/>
- <column id="LIBELLE" new-name="LIBELLE" new-type="VARCHAR(1000)"/>
- <column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)"
- new-qualif="NOT NULL"/>
- <column id="REPOSITORY" new-name="REPOSITORY" new-type="BLOB"/>
- <column id="ENCODING" new-name="ENCODING" new-type="VARCHAR(1000)" avoid-generate="true"/>
- </table>
- <etat id="PES_DepenseAller">
- <table base-name="PES_ALLER_DA_DOCUMENTS" new-name="PES_ALLER_D_DOCS">
- <column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)"
- new-qualif="NOT NULL"/>
- <column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"
- new-qualif="NOT NULL"/>
- <column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="DOC" new-name="DOC" new-type="BLOB"/>
- <column id="ENCODING" new-name="ENCODING" new-type="VARCHAR(1000)" avoid-generate="true"/>
- <column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/>
- <index id="IX_${base-name}_BC" new-name="${base-name}_BC"/>
- <index id="${base-name}_AN" new-name="${base-name}_AN"/>
- </table>
- <table base-name="PES_ALLER_DA_LIGNE_PIECE_PJREF" new-name="PES_ALLER_D_LIG_PJ">
- <column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)"
- new-qualif="NOT NULL"/>
- <column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)"/>
- <column id="SUPPORT_PJ" new-name="SUPPORT_PJ" new-type="VARCHAR(1000)"/>
- <column id="ID_UNIQUE_PJ" new-name="ID_UNIQUE_PJ" new-type="VARCHAR(1000)"/>
- <column id="NOM_PJ" new-name="NOM_PJ" new-type="VARCHAR(1000)"/>
- <column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/>
- <column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/>
- <index id="IX_${base-name}_BC" new-name="${base-name}_BC"/>
- <index id="IX_${base-name}_DC" new-name="${base-name}_DC"/>
- <index id="${base-name}_IDN" new-name="${base-name}_IDN"/>
- <index id="${base-name}_AN" new-name="${base-name}_AN"/>
- </table>
- <table base-name="PES_ALLER_DA_ALL_PJ" new-name="PES_ALLER_D_ALL_PJ">
- <column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)"
- new-qualif="NOT NULL"/>
- <column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)"/>
- <column id="SUPPORT_PJ" new-name="SUPPORT_PJ" new-type="VARCHAR(1000)"/>
- <column id="ID_UNIQUE_PJ" new-name="ID_UNIQUE_PJ" new-type="VARCHAR(1000)"/>
- <column id="NOM_PJ" new-name="NOM_PJ" new-type="VARCHAR(1000)"/>
- <column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/>
- <column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/>
- <index id="IX_${base-name}_BC" new-name="${base-name}_BC"/>
- <index id="IX_${base-name}_DC" new-name="${base-name}_DC"/>
- <index id="${base-name}_IDN" new-name="${base-name}_IDN"/>
- <index id="${base-name}_AN" new-name="${base-name}_AN"/>
- </table>
- <table base-name="PES_ALLER_DA_PIECE_PJREF" new-name="PES_ALLER_D_PCE_PJ">
- <column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)"
- new-qualif="NOT NULL"/>
- <column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOt NULL"/>
- <column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)"/>
- <column id="SUPPORT_PJ" new-name="SUPPORT_PJ" new-type="VARCHAR(1000)"/>
- <column id="ID_UNIQUE_PJ" new-name="ID_UNIQUE_PJ" new-type="VARCHAR(1000)"/>
- <column id="NOM_PJ" new-name="NOM_PJ" new-type="VARCHAR(1000)"/>
- <column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/>
- <column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/>
- <index id="IX_${base-name}_BC" new-name="${base-name}_BC"/>
- <index id="IX_${base-name}_DC" new-name="${base-name}_DC"/>
- <index id="${base-name}_IDN" new-name="${base-name}_IDN"/>
- <index id="${base-name}_AN" new-name="${base-name}_AN"/>
- </table>
- <table base-name="PES_ALLER_DA_LIGNE_PIECE_IX" new-name="PES_ALLER_D_LIG">
- <column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)"
- new-qualif="NOT NULL"/>
- <column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)"/>
- <column id="ID_LIGNE" new-name="ID_LIGNE" new-type="INTEGER"/>
- <column id="NATURE" new-name="NATURE" new-type="VARCHAR(1000)"/>
- <column id="FONCTION" new-name="FONCTION" new-type="VARCHAR(1000)"/>
- <column id="OPERATION" new-name="OPERATION" new-type="VARCHAR(1000)"/>
- <column id="COMPTE_ANA" new-name="COMPTE_ANA" new-type="VARCHAR(1000)"/>
- <column id="FACTURE" new-name="FACTURE" new-type="VARCHAR(1000)"/>
- <column id="LIBELLE_VIREMENT_1" new-name="LIBELLE_VIREMENT_1" new-type="VARCHAR(1000)"/>
- <column id="LIBELLE_VIREMENT_2" new-name="LIBELLE_VIREMENT_2" new-type="VARCHAR(1000)"/>
- <column id="MODE_REGLEMENT" new-name="MODE_REGLEMENT" new-type="VARCHAR(1000)"/>
- <column id="TVA_INTRA_COM" new-name="TVA_INTRA_COM" new-type="INTEGER"/>
- <column id="COMPTE_TVA" new-name="COMPTE_TVA" new-type="VARCHAR(1000)"/>
- <column id="COMPTE_TIERS" new-name="COMPTE_TIERS" new-type="VARCHAR(1000)"/>
- <column id="MT_HT" new-name="MT_HT" new-type="DECIMAL(14,2)"/>
- <column id="MT_TTC" new-name="MT_TTC" new-type="DECIMAL(14,2)"/>
- <column id="MT_TVA" new-name="MT_TVA" new-type="DECIMAL(14,2)"/>
- <column id="MT_FACTURE_HT" new-name="MT_FACTURE_HT" new-type="DECIMAL(14,2)"/>
- <column id="REC_TVA" new-name="REC_TVA" new-type="INTEGER"/>
- <column id="MT_HT_RES" new-name="MT_HT_RES" new-type="DECIMAL(14,2)"/>
- <column id="CODE_OP_SPEC" new-name="CODE_OP_SPEC" new-type="VARCHAR(1000)"/>
- <column id="ID_OP_SPEC" new-name="ID_OP_SPEC" new-type="VARCHAR(1000)"/>
- <column id="NATURE_PIECE_ORIGINE" new-name="NATURE_PIECE_ORIGINE"
- new-type="VARCHAR(1000)"/>
- <column id="EXERCICE_RAT" new-name="EXERCICE_RAT" new-type="INTEGER"/>
- <column id="ID_PIECE_ORIGINE" new-name="ID_PIECE_ORIGINE" new-type="INTEGER"/>
- <column id="ID_LIGNE_ORIGINE" new-name="ID_LIGNE_ORIGINE" new-type="VARCHAR(1000)"/>
- <column id="ID_CONV" new-name="ID_CONV" new-type="VARCHAR(1000)"/>
- <column id="ID_MARCHE" new-name="ID_MARCHE" new-type="VARCHAR(1000)"/>
- <column id="ID_EMPRUNT_ORDO" new-name="ID_EMPRUNT_ORDO" new-type="VARCHAR(1000)"/>
- <column id="ID_ACTIF" new-name="ID_ACTIF" new-type="VARCHAR(1000)"/>
- <column id="ID_REGIE" new-name="ID_REGIE" new-type="INTEGER"/>
- <column id="ID_TIERS" new-name="ID_TIERS" new-type="VARCHAR(1000)"/>
- <column id="DATE_MALADE" new-name="DATE_MALADE" new-type="DATE"/>
- <column id="NAT_ID_TIERS" new-name="NAT_ID_TIERS" new-type="VARCHAR(1000)"/>
- <column id="DATE_ID_TIERS" new-name="DATE_ID_TIERS" new-type="DATE"/>
- <column id="REF_TIERS" new-name="REF_TIERS" new-type="VARCHAR(1000)"/>
- <column id="CAT_TIERS" new-name="CAT_TIERS" new-type="VARCHAR(1000)"/>
- <column id="NAT_JUR" new-name="NAT_JUR" new-type="VARCHAR(1000)"/>
- <column id="CIVILITE" new-name="CIVILITE" new-type="VARCHAR(1000)"/>
- <column id="NOM" new-name="NOM" new-type="VARCHAR(1000)"/>
- <column id="COMPLEMENT_NOM" new-name="COMPLEMENT_NOM" new-type="VARCHAR(1000)"/>
- <column id="PRENOM" new-name="PRENOM" new-type="VARCHAR(1000)"/>
- <column id="TYPE_ADRESSE" new-name="TYPE_ADRESSE" new-type="VARCHAR(1000)"/>
- <column id="ADR1" new-name="ADR1" new-type="VARCHAR(1000)"/>
- <column id="ADR2" new-name="ADR2" new-type="VARCHAR(1000)"/>
- <column id="ADR3" new-name="ADR3" new-type="VARCHAR(1000)"/>
- <column id="CODE_POSTAL" new-name="CODE_POSTAL" new-type="VARCHAR(1000)"/>
- <column id="VILLE" new-name="VILLE" new-type="VARCHAR(1000)"/>
- <column id="CODE_RES" new-name="CODE_RES" new-type="VARCHAR(1000)"/>
- <column id="CODE_PAYS" new-name="CODE_PAYS" new-type="VARCHAR(1000)"/>
- <column id="DATE_ADR" new-name="DATE_ADR" new-type="DATE"/>
- <column id="RIB" new-name="RIB" new-type="VARCHAR(1000)"/>
- <column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/>
- <column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/>
- <index id="IX_${base-name}_BC" new-name="${base-name}_BC"/>
- <index id="IX_${base-name}_DC" new-name="${base-name}_DC"/>
- <index id="${base-name}_IDN" new-name="${base-name}_IDN"/>
- <index id="${base-name}_AN" new-name="${base-name}_AN"/>
- </table>
- <table base-name="PES_ALLER_DA_PIECE_IX" new-name="PES_ALLER_D_PCE">
- <column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)"
- new-qualif="NOt NULL"/>
- <column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)"/>
- <column id="NB_LIGNES" new-name="NB_LIGNES" new-type="INTEGER"/>
- <column id="MONTANT_HT" new-name="MONTANT_HT" new-type="DECIMAL(14,2)"/>
- <column id="MONTANT_TTC" new-name="MONTANT_TTC" new-type="DECIMAL(14,2)"/>
- <column id="CODE_SERVICE" new-name="CODE_SERVICE" new-type="VARCHAR(1000)"/>
- <column id="AFFECT" new-name="AFFECT" new-type="VARCHAR(1000)"/>
- <column id="ID_PIECE" new-name="ID_PIECE" new-type="INTEGER"/>
- <column id="TYPE_PIECE" new-name="TYPE_PIECE" new-type="VARCHAR(1000)"/>
- <column id="NATURE_PIECE" new-name="NATURE_PIECE" new-type="VARCHAR(1000)"/>
- <column id="OBJ" new-name="OBJ" new-type="VARCHAR(1000)"/>
- <column id="DATE_ECHEANCE" new-name="DATE_ECHEANCE" new-type="DATE"/>
- <column id="PJ" new-name="PJ" new-type="VARCHAR(1000)"/>
- <column id="DGP" new-name="DGP" new-type="VARCHAR(1000)"/>
- <column id="DGP_DATE_DEB" new-name="DGP_DATE_DEB" new-type="DATE"/>
- <column id="DGP_DATE_FIN" new-name="DGP_DATE_FIN" new-type="DATE"/>
- <column id="DGP_DUREE" new-name="DGP_DUREE" new-type="VARCHAR(1000)"/>
- <column id="CODE_INTERNE_MOR" new-name="CODE_INTERNE_MOR" new-type="VARCHAR(1000)"/>
- <column id="TAUX_INTERNE_MOR" new-name="TAUX_INTERNE_MOR" new-type="DECIMAL(5,2)"/>
- <column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/>
- <column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/>
- <index id="IX_${base-name}_BC" new-name="${base-name}_BC"/>
- <index id="IX_${base-name}_DC" new-name="${base-name}_DC"/>
- <index id="${base-name}_IDN" new-name="${base-name}_IDN"/>
- <index id="${base-name}_AN" new-name="${base-name}_AN"/>
- </table>
- <table base-name="PES_ALLER_DA_BORDEREAU_IX" new-name="PES_ALLER_D_BORD">
- <column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)"
- new-qualif="NOT NULL"/>
- <column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="PRIMARY_KEY" new-name="PRIMARY_KEY" new-type="VARCHAR(1000)"
- new-qualif="NOT NULL"/>
- <column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)"/>
- <column id="NB_MANDATS" new-name="NB_MANDATS" new-type="INTEGER"/>
- <column id="EXERCICE" new-name="EXERCICE" new-type="VARCHAR(1000)"/>
- <column id="ID_BORDEREAU" new-name="ID_BORDEREAU" new-type="INTEGER"/>
- <column id="DATE_EMISSION_BORDEREAU" new-name="DATE_EMISSION_BORDEREAU" new-type="DATE"/>
- <column id="TYPE_BORDEREAU" new-name="TYPE_BORDEREAU" new-type="VARCHAR(1000)"/>
- <column id="NB_PIECES" new-name="NB_PIECES" new-type="INTEGER"/>
- <column id="MT_CUMUL_ANNUEL" new-name="MT_CUMUL_ANNUEL" new-type="DECIMAL(14,2)"/>
- <column id="MT_BOREREAU_HT" new-name="MT_BOREREAU_HT" new-type="DECIMAL(14,2)"/>
- <column id="MT_BORDEREAU_TVA" new-name="MT_BORDEREAU_TVA" new-type="DECIMAL(14,2)"/>
- <column id="MT_BORDEREAU_TTC" new-name="MT_BORDEREAU_TTC" new-type="DECIMAL(14,2)"/>
- <column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/>
- <column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/>
- <index id="IX_${base-name}_BC" new-name="${base-name}_BC"/>
- <index id="IX_${base-name}_DC" new-name="${base-name}_DC"/>
- <index id="${base-name}_IDN" new-name="${base-name}_IDN"/>
- <index id="${base-name}_AN" new-name="${base-name}_AN"/>
- </table>
- </etat>
- <etat id="PES_PJ">
- <table base-name="PES_PJ_DOCUMENTS" new-name="PES_ALLER_PJ_DOCS">
- <column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)"
- new-qualif="NOT NULL"/>
- <column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"
- new-qualif="NOT NULL"/>
- <column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="DOC" new-name="DOC" new-type="BLOB"/>
- <column id="ENCODING" new-name="ENCODING" new-type="VARCHAR(1000)" avoid-generate="true"/>
- <column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/>
- <index id="IX_${base-name}_BC" new-name="${base-name}_BC"/>
- <index id="${base-name}_AN" new-name="${base-name}_AN"/>
- </table>
- <table base-name="PES_PJ_PJ_IX" new-name="PES_ALLER_PJ_IX">
- <column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)"
- new-qualif="NOT NULL"/>
- <column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)" new-qualif=""/>
- <column id="TYPEPJ" new-name="TYPEPJ" new-type="VARCHAR(1000)"/>
- <column id="NOMPJ" new-name="NOMPJ" new-type="VARCHAR(1000)"/>
- <column id="DESCRIPTION" new-name="DESCRIPTION" new-type="VARCHAR(1000)"/>
- <column id="IDUNIQUE" new-name="IDUNIQUE" new-type="VARCHAR(1000)"/>
- <column id="SERVEURID" new-name="SERVEURID" new-type="VARCHAR(1000)"/>
- <column id="LIBTYPEPJ" new-name="LIBTYPEPJ" new-type="VARCHAR(1000)"/>
- <column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/>
- <column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/>
- <index id="IX_${base-name}_BC" new-name="${base-name}_BC"/>
- <index id="IX_${base-name}_DC" new-name="${base-name}_DC"/>
- <index id="${base-name}_IDN" new-name="${base-name}_IDN"/>
- <index id="${base-name}_AN" new-name="${base-name}_AN"/>
- </table>
- <table base-name="PES_PJ_PJ_REFCOMPTA_IX" new-name="PES_ALLER_PJ_REFCOMPTA">
- <column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)"
- new-qualif="NOT NULL"/>
- <column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)" new-qualif=""/>
- <column id="IDENTIFIANT" new-name="IDENTIFIANT" new-type="VARCHAR(1000)"/>
- <column id="TYPEOBJET" new-name="TYPEOBJET" new-type="INTEGER"/>
- <column id="EXERCICE" new-name="EXERCICE" new-type="VARCHAR(1000)"/>
- <column id="DOMAINE" new-name="DOMAINE" new-type="VARCHAR(1000)"/>
- <column id="IDTIERS" new-name="IDTIERS" new-type="VARCHAR(1000)"/>
- <column id="CODPROD" new-name="CODPROD" new-type="VARCHAR(1000)"/>
- <column id="COMPLEMENTIDENTIFIANT" new-name="COMPLEMENTIDENTIFIANT"
- new-type="VARCHAR(1000)"/>
- <column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/>
- <column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/>
- <index id="IX_${base-name}_BC" new-name="${base-name}_BC"/>
- <index id="IX_${base-name}_DC" new-name="${base-name}_DC"/>
- <index id="${base-name}_IDN" new-name="${base-name}_IDN"/>
- <index id="${base-name}_AN" new-name="${base-name}_AN"/>
- </table>
- <table base-name="PES_PJ_PES_ALLER_PES_PJ_IX" new-name="PES_ALLER_PJ">
- <column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)"
- new-qualif="NOT NULL"/>
- <column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="IDVER" new-name="IDVER" new-type="INTEGER"/>
- <column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/>
- <column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/>
- <index id="IX_${base-name}_BC" new-name="${base-name}_BC"/>
- <index id="IX_${base-name}_DC" new-name="${base-name}_DC"/>
- <index id="${base-name}_IDN" new-name="${base-name}_IDN"/>
- <index id="${base-name}_AN" new-name="${base-name}_AN"/>
- </table>
- </etat>
- <etat id="PES_RecetteAller">
- <table base-name="PES_ALLER_RA_ALL_PJ" new-name="PES_ALLER_R_ALL_PJ">
- <column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)"
- new-qualif="NOT NULL"/>
- <column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)"/>
- <column id="SUPPORT_PJ" new-name="SUPPORT_PJ" new-type="VARCHAR(1000)"/>
- <column id="ID_UNIQUE_PJ" new-name="ID_UNIQUE_PJ" new-type="VARCHAR(1000)"/>
- <column id="NOM_PJ" new-name="NOM_PJ" new-type="VARCHAR(1000)"/>
- <column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/>
- <column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/>
- <index id="IX_${base-name}_BC" new-name="${base-name}_BC"/>
- <index id="IX_${base-name}_DC" new-name="${base-name}_DC"/>
- <index id="${base-name}_IDN" new-name="${base-name}_IDN"/>
- <index id="${base-name}_AN" new-name="${base-name}_AN"/>
- </table>
- <table base-name="PES_ALLER_RA_DOCUMENTS" new-name="PES_ALLER_R_DOCS">
- <column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)"
- new-qualif="NOT NULL"/>
- <column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"
- new-qualif="NOT NULL"/>
- <column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="DOC" new-name="DOC" new-type="BLOB"/>
- <column id="ENCODING" new-name="ENCODING" new-type="VARCHAR(1000)" avoid-generate="true"/>
- <column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/>
- <index id="IX_${base-name}_BC" new-name="${base-name}_BC"/>
- <index id="${base-name}_AN" new-name="${base-name}_AN"/>
- </table>
- <table base-name="PES_ALLER_RA_LIGNE_PIECE_TIERS" new-name="PES_ALLER_R_LIG_TIERS">
- <column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)"
- new-qualif="NOT NULL"/>
- <column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)" new-qualif=""/>
- <column id="ID_TIERS" new-name="ID_TIERS" new-type="VARCHAR(1000)"/>
- <column id="DATE_MALADE" new-name="DATE_MALADE" new-type="DATE"/>
- <column id="NAT_ID_TIERS" new-name="NAT_ID_TIERS" new-type="VARCHAR(1000)"/>
- <column id="DATE_ID_TIERS" new-name="DATE_ID_TIERS" new-type="DATE"/>
- <column id="REF_TIERS" new-name="REF_TIERS" new-type="VARCHAR(1000)"/>
- <column id="CAT_TIERS" new-name="CAT_TIERS" new-type="VARCHAR(1000)"/>
- <column id="NAT_JUR" new-name="NAT_JUR" new-type="VARCHAR(1000)"/>
- <column id="TYP_TIERS" new-name="TYP_TIERS" new-type="VARCHAR(1000)"/>
- <column id="CIVILITE" new-name="CIVILITE" new-type="VARCHAR(1000)"/>
- <column id="NOM" new-name="NOM" new-type="VARCHAR(1000)"/>
- <column id="COMPLEMENT_NOM" new-name="COMPLEMENT_NOM" new-type="VARCHAR(1000)"/>
- <column id="PRENOM" new-name="PRENOM" new-type="VARCHAR(1000)"/>
- <column id="TYP_ADR" new-name="TYP_ADR" new-type="VARCHAR(1000)"/>
- <column id="ADR1" new-name="ADR1" new-type="VARCHAR(1000)"/>
- <column id="ADR2" new-name="ADR2" new-type="VARCHAR(1000)"/>
- <column id="ADR3" new-name="ADR3" new-type="VARCHAR(1000)"/>
- <column id="CP" new-name="CP" new-type="VARCHAR(1000)"/>
- <column id="VILLE" new-name="VILLE" new-type="VARCHAR(1000)"/>
- <column id="COD_RES" new-name="COD_RES" new-type="VARCHAR(1000)"/>
- <column id="COD_PAYS" new-name="COD_PAYS" new-type="INTEGER"/>
- <column id="DATE_ADR" new-name="DATE_ADR" new-type="DATE"/>
- <column id="RIB" new-name="RIB" new-type="VARCHAR(1000)"/>
- <column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/>
- <column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/>
- <index id="IX_${base-name}_BC" new-name="${base-name}_BC"/>
- <index id="IX_${base-name}_DC" new-name="${base-name}_DC"/>
- <index id="${base-name}_IDN" new-name="${base-name}_IDN"/>
- <index id="${base-name}_AN" new-name="${base-name}_AN"/>
- </table>
- <table base-name="PES_ALLER_RA_LIGNE_PIECE_PJREF" new-name="PES_ALLER_R_LIG_PJ">
- <column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)"
- new-qualif="NOT NULL"/>
- <column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)" new-qualif=""/>
- <column id="SUPPORT_PJ" new-name="SUPPORT_PJ" new-type="VARCHAR(1000)"/>
- <column id="ID_UNIQUE_PJ" new-name="ID_UNIQUE_PJ" new-type="VARCHAR(1000)"/>
- <column id="NOM_PJ" new-name="NOM_PJ" new-type="VARCHAR(1000)"/>
- <column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/>
- <column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/>
- <index id="IX_${base-name}_BC" new-name="${base-name}_BC"/>
- <index id="IX_${base-name}_DC" new-name="${base-name}_DC"/>
- <index id="${base-name}_IDN" new-name="${base-name}_IDN"/>
- <index id="${base-name}_AN" new-name="${base-name}_AN"/>
- </table>
- <table base-name="PES_ALLER_RA_LIGNE_PIECE_RECOUVREMENT" new-name="PES_ALLER_R_LIG_RECOU">
- <column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)"
- new-qualif="NOT NULL"/>
- <column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)" new-qualif=""/>
- <column id="TYP_FLUX" new-name="TYP_FLUX" new-type="VARCHAR(1000)"/>
- <column id="MODE_REGLEMENT" new-name="MODE_REGLEMENT" new-type="VARCHAR(1000)"/>
- <column id="DATE_RECOUVREMENT" new-name="DATE_RECOUVREMENT" new-type="DATE"/>
- <column id="ID_ENCAISSEMENT" new-name="ID_ENCAISSEMENT" new-type="INTEGER"/>
- <column id="MNT_RECOUVREMENT" new-name="MNT_RECOUVREMENT" new-type="DECIMAL(14,2)"/>
- <column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/>
- <column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/>
- <index id="IX_${base-name}_BC" new-name="${base-name}_BC"/>
- <index id="IX_${base-name}_DC" new-name="${base-name}_DC"/>
- <index id="${base-name}_IDN" new-name="${base-name}_IDN"/>
- <index id="${base-name}_AN" new-name="${base-name}_AN"/>
- </table>
- <table base-name="PES_ALLER_RA_PIECE_IX" new-name="PES_ALLER_R_PCE">
- <column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)"
- new-qualif="NOT NULL"/>
- <column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)" new-qualif=""/>
- <column id="CODE_SERVICE" new-name="CODE_SERVICE" new-type="VARCHAR(1000)"/>
- <column id="AFFECT" new-name="AFFECT" new-type="VARCHAR(1000)"/>
- <column id="CODE_PROD" new-name="CODE_PROD" new-type="VARCHAR(1000)"/>
- <column id="ID_PIECE" new-name="ID_PIECE" new-type="INTEGER"/>
- <column id="TYPE_PIECE" new-name="TYPE_PIECE" new-type="VARCHAR(1000)"/>
- <column id="NATURE_PIECE" new-name="NATURE_PIECE" new-type="VARCHAR(1000)"/>
- <column id="ID_ROL" new-name="ID_ROL" new-type="INTEGER"/>
- <column id="DATE_ASP" new-name="DATE_ASP" new-type="DATE"/>
- <column id="OBJ" new-name="OBJ" new-type="VARCHAR(1000)"/>
- <column id="DEB_FACT" new-name="DEB_FACT" new-type="DATE"/>
- <column id="FIN_FACT" new-name="FIN_FACT" new-type="DATE"/>
- <column id="NB_LIGNE" new-name="NB_LIGNE" new-type="INTEGER"/>
- <column id="MONTANT_TTC" new-name="MONTANT_TTC" new-type="DECIMAL(14,2)"/>
- <column id="MONTANT_HT" new-name="MONTANT_HT" new-type="DECIMAL(14,2)"/>
- <column id="AVEC_PJ" new-name="AVEC_PJ" new-type="VARCHAR(1000)"/>
- <column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/>
- <column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/>
- <index id="IX_${base-name}_BC" new-name="${base-name}_BC"/>
- <index id="IX_${base-name}_DC" new-name="${base-name}_DC"/>
- <index id="${base-name}_IDN" new-name="${base-name}_IDN"/>
- <index id="${base-name}_AN" new-name="${base-name}_AN"/>
- </table>
- <table base-name="PES_ALLER_RA_BORDEREAU_IX" new-name="PES_ALLER_R_BORD">
- <column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)"
- new-qualif="NOT NULL"/>
- <column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="PRIMARY_KEY" new-name="PRIMARY_KEY" new-type="VARCHAR(1000)"
- new-qualif="NOT NULL"/>
- <column id="EXERCICE" new-name="EXERCICE" new-type="INTEGER"/>
- <column id="ID_BORDEREAU" new-name="ID_BORDEREAU" new-type="INTEGER"/>
- <column id="DATE_EMISSION_BORDEREAU" new-name="DATE_EMISSION_BORDEREAU" new-type="DATE"/>
- <column id="TYPE_BORDEREAU" new-name="TYPE_BORDEREAU" new-type="VARCHAR(1000)"/>
- <column id="NB_PIECES" new-name="NB_PIECES" new-type="INTEGER"/>
- <column id="MT_CUMUL_ANNUEL" new-name="MT_CUMUL_ANNUEL" new-type="DECIMAL(14,2)"/>
- <column id="MT_BOREREAU_HT" new-name="MT_BOREREAU_HT" new-type="DECIMAL(14,2)"/>
- <column id="MT_BORDEREAU_TVA" new-name="MT_BORDEREAU_TVA" new-type="DECIMAL(14,2)"/>
- <column id="MONTANT_TTC" new-name="MONTANT_TTC" new-type="DECIMAL(14,2)"/>
- <column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/>
- <column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/>
- <index id="IX_${base-name}_BC" new-name="${base-name}_BC"/>
- <index id="IX_${base-name}_DC" new-name="${base-name}_DC"/>
- <index id="${base-name}_IDN" new-name="${base-name}_IDN"/>
- <index id="${base-name}_AN" new-name="${base-name}_AN"/>
- </table>
- <table base-name="PES_ALLER_RA_LIGNE_PIECE_IX" new-name="PES_ALLER_R_LIG">
- <column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)"
- new-qualif="NOT NULL"/>
- <column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)" new-qualif=""/>
- <column id="ID_LIGNE" new-name="ID_LIGNE" new-type="VARCHAR(1000)"/>
- <column id="OBJET" new-name="OBJET" new-type="VARCHAR(1000)"/>
- <column id="CODE_PROD" new-name="CODE_PROD" new-type="VARCHAR(1000)"/>
- <column id="FIN_GEO" new-name="FIN_GEO" new-type="INTEGER"/>
- <column id="COD_ET_GEO" new-name="COD_ET_GEO" new-type="VARCHAR(1000)"/>
- <column id="NATURE" new-name="NATURE" new-type="VARCHAR(1000)"/>
- <column id="FONCTION" new-name="FONCTION" new-type="VARCHAR(1000)"/>
- <column id="OPERATION" new-name="OPERATION" new-type="VARCHAR(1000)"/>
- <column id="COMPTE_ANA" new-name="COMPTE_ANA" new-type="VARCHAR(1000)"/>
- <column id="FACTURE" new-name="FACTURE" new-type="VARCHAR(1000)"/>
- <column id="TAUX_TVA" new-name="TAUX_TVA" new-type="DECIMAL(5,2)"/>
- <column id="MAJO" new-name="MAJO" new-type="VARCHAR(1000)"/>
- <column id="DATE_MAJO" new-name="DATE_MAJO" new-type="DATE"/>
- <column id="TAUX_MAJO" new-name="TAUX_MAJO" new-type="DECIMAL(5,2)"/>
- <column id="COMPTE_TIERS" new-name="COMPTE_TIERS" new-type="VARCHAR(1000)"/>
- <column id="TVA_INTRA_COM" new-name="TVA_INTRA_COM" new-type="VARCHAR(1000)"/>
- <column id="COMPTE_TVA" new-name="COMPTE_TVA" new-type="VARCHAR(1000)"/>
- <column id="MT_HT" new-name="MT_HT" new-type="DECIMAL(14,2)"/>
- <column id="MT_TVA" new-name="MT_TVA" new-type="DECIMAL(14,2)"/>
- <column id="MT_NON_MAJO" new-name="MT_NON_MAJO" new-type="DECIMAL(14,2)"/>
- <column id="NAT_PREL" new-name="NAT_PREL" new-type="VARCHAR(1000)"/>
- <column id="PER_PREL" new-name="PER_PREL" new-type="VARCHAR(1000)"/>
- <column id="DATE_PREL" new-name="DATE_PREL" new-type="DATE"/>
- <column id="MNT_PREL" new-name="MNT_PREL" new-type="DECIMAL(14,2)"/>
- <column id="COD_ASS_DEB" new-name="COD_ASS_DEB" new-type="VARCHAR(1000)"/>
- <column id="COD_AYANT_DROIT" new-name="COD_AYANT_DROIT" new-type="VARCHAR(1000)"/>
- <column id="NATURE_PIECE_ORIGINE" new-name="NATURE_PIECE_ORIGINE"
- new-type="VARCHAR(1000)"/>
- <column id="EXERCICE_RAT" new-name="EXERCICE_RAT" new-type="VARCHAR(1000)"/>
- <column id="ID_PIECE_ORIGINE" new-name="ID_PIECE_ORIGINE" new-type="INTEGER"/>
- <column id="ID_LIGNE_ORIGINE" new-name="ID_LIGNE_ORIGINE" new-type="VARCHAR(1000)"/>
- <column id="ID_ENCAISSEMENT" new-name="ID_ENCAISSEMENT" new-type="INTEGER"/>
- <column id="ID_CONV" new-name="ID_CONV" new-type="VARCHAR(1000)"/>
- <column id="ID_MARCHE" new-name="ID_MARCHE" new-type="VARCHAR(1000)"/>
- <column id="ID_CAUTION" new-name="ID_CAUTION" new-type="VARCHAR(1000)"/>
- <column id="ID_EMPRUNT_ORDO" new-name="ID_EMPRUNT_ORDO" new-type="VARCHAR(1000)"/>
- <column id="ID_ACTIF" new-name="ID_ACTIF" new-type="VARCHAR(1000)"/>
- <column id="ID_REGIE" new-name="ID_REGIE" new-type="VARCHAR(1000)"/>
- <column id="MONTANT_TTC" new-name="MONTANT_TTC" new-type="DECIMAL(14,2)"/>
- <column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/>
- <column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/>
- <index id="IX_${base-name}_BC" new-name="${base-name}_BC"/>
- <index id="IX_${base-name}_DC" new-name="${base-name}_DC"/>
- <index id="${base-name}_IDN" new-name="${base-name}_IDN"/>
- <index id="${base-name}_AN" new-name="${base-name}_AN"/>
- </table>
- <table base-name="PES_ALLER_RA_PIECE_PJREF_IX" new-name="PES_ALLER_R_PCE_PJ">
- <column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)"
- new-qualif="NOT NULL"/>
- <column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/>
- <column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)" new-qualif=""/>
- <column id="SUPPORT_PJ" new-name="SUPPORT_PJ" new-type="VARCHAR(1000)"/>
- <column id="ID_UNIQUE_PJ" new-name="ID_UNIQUE_PJ" new-type="VARCHAR(1000)"/>
- <column id="NOM_PJ" new-name="NOM_PJ" new-type="VARCHAR(1000)"/>
- <column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/>
- <column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/>
- <index id="IX_${base-name}_BC" new-name="${base-name}_BC"/>
- <index id="IX_${base-name}_DC" new-name="${base-name}_DC"/>
- <index id="${base-name}_IDN" new-name="${base-name}_IDN"/>
- <index id="${base-name}_AN" new-name="${base-name}_AN"/>
- </table>
- </etat>
-</document>
+<?xml version="1.0" encoding="UTF-8"?><document><table base-name="PES_ALLER_SPECIAL_KEYS" new-name="PES_ALLER_SK"><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="KEY1" new-name="KEY1" new-type="VARCHAR(1000)"/><column id="LIB1" new-name="LIB1" new-type="VARCHAR(1000)"/><column id="KEY2" new-name="KEY2" new-type="VARCHAR(1000)"/><column id="LIB2" new-name="LIB2" new-type="VARCHAR(1000)"/><column id="KEY3" new-name="KEY3" new-type="VARCHAR(1000)"/><column id="LIB3" new-name="LIB3" new-type="VARCHAR(1000)"/><column id="KEY4" new-name="KEY4" new-type="VARCHAR(1000)" avoid-generate="true"/><column id="LIB4" new-name="LIB4" new-type="VARCHAR(1000)" avoid-generate="true"/><column id="KEY5" new-name="KEY5" new-type="VARCHAR(1000)" avoid-generate="true"/><column id="LIB5" new-name="LIB5" new-type="" avoid-generate="true"/><column id="KEY6" new-name="KEY6" new-type="VARCHAR(1000)" avoid-generate="true"/><column id="LIB6" new-name="LIB6" new-type="VARCHAR(1000)" avoid-generate="true"/><column id="KEY7" new-name="KEY7" new-type="VARCHAR(1000)" avoid-generate="true"/><column id="LIB7" new-name="LIB7" new-type="" avoid-generate="true"/><column id="KEY8" new-name="KEY8" new-type="VARCHAR(1000)" avoid-generate="true"/><column id="LIB8" new-name="LIB8" new-type="VARCHAR(1000)" avoid-generate="true"/><column id="KEY9" new-name="KEY9" new-type="VARCHAR(1000)" avoid-generate="true"/><column id="LIB9" new-name="LIB9" new-type="" avoid-generate="true"/><column id="KEY10" new-name="KEY10" new-type="VARCHAR(1000)" avoid-generate="true"/><column id="LIB10" new-name="LIB10" new-type="VARCHAR(1000)" avoid-generate="true"/><column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/><index id="IX_${base-name}_BC" new-name="${base-name}_BC"/><index id="${base-name}_AN" new-name="${base-name}_AN"/></table><table base-name="PES_ALLER_LIST_BUDG_COLL" new-name="PES_ALLER_LBC"><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="BUDGET_LIB" new-name="BUDGET_LIB" new-type="VARCHAR(1000)"/><column id="COLLECTIVITE_LIB" new-name="COLLECTIVITE_LIB" new-type="VARCHAR(1000)"/><column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/><index id="IX_${base-name}_BC" new-name="${base-name}_BC"/><index id="${base-name}_AN" new-name="${base-name}_AN"/></table><table base-name="PES_ALLER_REPOSITORY" new-name="PES_ALLER_REPOSITORY"><column id="ID" new-name="ID" new-type="VARCHAR(1000)"/><column id="LIBELLE" new-name="LIBELLE" new-type="VARCHAR(1000)"/><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="REPOSITORY" new-name="REPOSITORY" new-type="BLOB"/><column id="ENCODING" new-name="ENCODING" new-type="VARCHAR(1000)" avoid-generate="true"/></table><etat id="PES_DepenseAller"><table base-name="PES_ALLER_DA_DOCUMENTS" new-name="PES_ALLER_D_DOCS"><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC" new-name="DOC" new-type="BLOB"/><column id="ENCODING" new-name="ENCODING" new-type="VARCHAR(1000)" avoid-generate="true"/><column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/><index id="IX_${base-name}_BC" new-name="${base-name}_BC"/><index id="${base-name}_AN" new-name="${base-name}_AN"/></table><table base-name="PES_ALLER_DA_LIGNE_PIECE_PJREF" new-name="PES_ALLER_D_LIG_PJ"><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="SUPPORT_PJ" new-name="SUPPORT_PJ" new-type="VARCHAR(1000)"/><column id="ID_UNIQUE_PJ" new-name="ID_UNIQUE_PJ" new-type="VARCHAR(1000)"/><column id="NOM_PJ" new-name="NOM_PJ" new-type="VARCHAR(1000)"/><column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/><column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/><index id="IX_${base-name}_BC" new-name="${base-name}_BC"/><index id="IX_${base-name}_DC" new-name="${base-name}_DC"/><index id="${base-name}_IDN" new-name="${base-name}_IDN"/><index id="${base-name}_AN" new-name="${base-name}_AN"/></table><table base-name="PES_ALLER_DA_ALL_PJ" new-name="PES_ALLER_D_ALL_PJ"><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)"/><column id="SUPPORT_PJ" new-name="SUPPORT_PJ" new-type="VARCHAR(1000)"/><column id="ID_UNIQUE_PJ" new-name="ID_UNIQUE_PJ" new-type="VARCHAR(1000)"/><column id="NOM_PJ" new-name="NOM_PJ" new-type="VARCHAR(1000)"/><column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/><column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/><index id="IX_${base-name}_BC" new-name="${base-name}_BC"/><index id="IX_${base-name}_DC" new-name="${base-name}_DC"/><index id="${base-name}_AN" new-name="${base-name}_AN"/></table><table base-name="PES_ALLER_DA_PIECE_PJREF" new-name="PES_ALLER_D_PCE_PJ"><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOt NULL"/><column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)"/><column id="SUPPORT_PJ" new-name="SUPPORT_PJ" new-type="VARCHAR(1000)"/><column id="ID_UNIQUE_PJ" new-name="ID_UNIQUE_PJ" new-type="VARCHAR(1000)"/><column id="NOM_PJ" new-name="NOM_PJ" new-type="VARCHAR(1000)"/><column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/><column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/><index id="IX_${base-name}_BC" new-name="${base-name}_BC"/><index id="IX_${base-name}_DC" new-name="${base-name}_DC"/><index id="${base-name}_AN" new-name="${base-name}_AN"/></table><table base-name="PES_ALLER_DA_LIGNE_PIECE_IX" new-name="PES_ALLER_D_LIG"><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)"/><column id="ID_LIGNE" new-name="ID_LIGNE" new-type="INTEGER"/><column id="NATURE" new-name="NATURE" new-type="VARCHAR(1000)"/><column id="FONCTION" new-name="FONCTION" new-type="VARCHAR(1000)"/><column id="OPERATION" new-name="OPERATION" new-type="VARCHAR(1000)"/><column id="COMPTE_ANA" new-name="COMPTE_ANA" new-type="VARCHAR(1000)"/><column id="FACTURE" new-name="FACTURE" new-type="VARCHAR(1000)"/><column id="LIBELLE_VIREMENT_1" new-name="LIBELLE_VIREMENT_1" new-type="VARCHAR(1000)"/><column id="LIBELLE_VIREMENT_2" new-name="LIBELLE_VIREMENT_2" new-type="VARCHAR(1000)"/><column id="MODE_REGLEMENT" new-name="MODE_REGLEMENT" new-type="VARCHAR(1000)"/><column id="TVA_INTRA_COM" new-name="TVA_INTRA_COM" new-type="INTEGER"/><column id="COMPTE_TVA" new-name="COMPTE_TVA" new-type="VARCHAR(1000)"/><column id="COMPTE_TIERS" new-name="COMPTE_TIERS" new-type="VARCHAR(1000)"/><column id="MT_HT" new-name="MT_HT" new-type="DECIMAL(14,2)"/><column id="MT_TTC" new-name="MT_TTC" new-type="DECIMAL(14,2)"/><column id="MT_TVA" new-name="MT_TVA" new-type="DECIMAL(14,2)"/><column id="MT_FACTURE_HT" new-name="MT_FACTURE_HT" new-type="DECIMAL(14,2)"/><column id="REC_TVA" new-name="REC_TVA" new-type="INTEGER"/><column id="MT_HT_RES" new-name="MT_HT_RES" new-type="DECIMAL(14,2)"/><column id="CODE_OP_SPEC" new-name="CODE_OP_SPEC" new-type="VARCHAR(1000)"/><column id="ID_OP_SPEC" new-name="ID_OP_SPEC" new-type="VARCHAR(1000)"/><column id="NATURE_PIECE_ORIGINE" new-name="NATURE_PIECE_ORIGINE" new-type="VARCHAR(1000)"/><column id="EXERCICE_RAT" new-name="EXERCICE_RAT" new-type="INTEGER"/><column id="ID_PIECE_ORIGINE" new-name="ID_PIECE_ORIGINE" new-type="INTEGER"/><column id="ID_LIGNE_ORIGINE" new-name="ID_LIGNE_ORIGINE" new-type="VARCHAR(1000)"/><column id="ID_CONV" new-name="ID_CONV" new-type="VARCHAR(1000)"/><column id="ID_MARCHE" new-name="ID_MARCHE" new-type="VARCHAR(1000)"/><column id="ID_EMPRUNT_ORDO" new-name="ID_EMPRUNT_ORDO" new-type="VARCHAR(1000)"/><column id="ID_ACTIF" new-name="ID_ACTIF" new-type="VARCHAR(1000)"/><column id="ID_REGIE" new-name="ID_REGIE" new-type="INTEGER"/><column id="ID_TIERS" new-name="ID_TIERS" new-type="VARCHAR(1000)"/><column id="DATE_MALADE" new-name="DATE_MALADE" new-type="DATE"/><column id="NAT_ID_TIERS" new-name="NAT_ID_TIERS" new-type="VARCHAR(1000)"/><column id="DATE_ID_TIERS" new-name="DATE_ID_TIERS" new-type="DATE"/><column id="REF_TIERS" new-name="REF_TIERS" new-type="VARCHAR(1000)"/><column id="CAT_TIERS" new-name="CAT_TIERS" new-type="VARCHAR(1000)"/><column id="NAT_JUR" new-name="NAT_JUR" new-type="VARCHAR(1000)"/><column id="CIVILITE" new-name="CIVILITE" new-type="VARCHAR(1000)"/><column id="NOM" new-name="NOM" new-type="VARCHAR(1000)"/><column id="COMPLEMENT_NOM" new-name="COMPLEMENT_NOM" new-type="VARCHAR(1000)"/><column id="PRENOM" new-name="PRENOM" new-type="VARCHAR(1000)"/><column id="TYPE_ADRESSE" new-name="TYPE_ADRESSE" new-type="VARCHAR(1000)"/><column id="ADR1" new-name="ADR1" new-type="VARCHAR(1000)"/><column id="ADR2" new-name="ADR2" new-type="VARCHAR(1000)"/><column id="ADR3" new-name="ADR3" new-type="VARCHAR(1000)"/><column id="CODE_POSTAL" new-name="CODE_POSTAL" new-type="VARCHAR(1000)"/><column id="VILLE" new-name="VILLE" new-type="VARCHAR(1000)"/><column id="CODE_RES" new-name="CODE_RES" new-type="VARCHAR(1000)"/><column id="CODE_PAYS" new-name="CODE_PAYS" new-type="VARCHAR(1000)"/><column id="DATE_ADR" new-name="DATE_ADR" new-type="DATE"/><column id="RIB" new-name="RIB" new-type="VARCHAR(1000)"/><column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/><column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/><index id="IX_${base-name}_BC" new-name="${base-name}_BC"/><index id="IX_${base-name}_DC" new-name="${base-name}_DC"/><index id="${base-name}_IDN" new-name="${base-name}_IDN"/><index id="${base-name}_AN" new-name="${base-name}_AN"/></table><table base-name="PES_ALLER_DA_PIECE_IX" new-name="PES_ALLER_D_PCE"><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOt NULL"/><column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)"/><column id="NB_LIGNES" new-name="NB_LIGNES" new-type="INTEGER"/><column id="MONTANT_HT" new-name="MONTANT_HT" new-type="DECIMAL(14,2)"/><column id="MONTANT_TTC" new-name="MONTANT_TTC" new-type="DECIMAL(14,2)"/><column id="CODE_SERVICE" new-name="CODE_SERVICE" new-type="VARCHAR(1000)"/><column id="AFFECT" new-name="AFFECT" new-type="VARCHAR(1000)"/><column id="ID_PIECE" new-name="ID_PIECE" new-type="INTEGER"/><column id="TYPE_PIECE" new-name="TYPE_PIECE" new-type="VARCHAR(1000)"/><column id="NATURE_PIECE" new-name="NATURE_PIECE" new-type="VARCHAR(1000)"/><column id="OBJ" new-name="OBJ" new-type="VARCHAR(1000)"/><column id="DATE_ECHEANCE" new-name="DATE_ECHEANCE" new-type="DATE"/><column id="PJ" new-name="PJ" new-type="VARCHAR(1000)"/><column id="DGP" new-name="DGP" new-type="VARCHAR(1000)"/><column id="DGP_DATE_DEB" new-name="DGP_DATE_DEB" new-type="DATE"/><column id="DGP_DATE_FIN" new-name="DGP_DATE_FIN" new-type="DATE"/><column id="DGP_DUREE" new-name="DGP_DUREE" new-type="VARCHAR(1000)"/><column id="CODE_INTERNE_MOR" new-name="CODE_INTERNE_MOR" new-type="VARCHAR(1000)"/><column id="TAUX_INTERNE_MOR" new-name="TAUX_INTERNE_MOR" new-type="DECIMAL(5,2)"/><column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/><column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/><index id="IX_${base-name}_BC" new-name="${base-name}_BC"/><index id="IX_${base-name}_DC" new-name="${base-name}_DC"/><index id="${base-name}_AN" new-name="${base-name}_AN"/></table><table base-name="PES_ALLER_DA_BORDEREAU_IX" new-name="PES_ALLER_D_BORD"><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="PRIMARY_KEY" new-name="PRIMARY_KEY" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)"/><column id="NB_MANDATS" new-name="NB_MANDATS" new-type="INTEGER"/><column id="EXERCICE" new-name="EXERCICE" new-type="VARCHAR(1000)"/><column id="ID_BORDEREAU" new-name="ID_BORDEREAU" new-type="INTEGER"/><column id="DATE_EMISSION_BORDEREAU" new-name="DATE_EMISSION_BORDEREAU" new-type="DATE"/><column id="TYPE_BORDEREAU" new-name="TYPE_BORDEREAU" new-type="VARCHAR(1000)"/><column id="NB_PIECES" new-name="NB_PIECES" new-type="INTEGER"/><column id="MT_CUMUL_ANNUEL" new-name="MT_CUMUL_ANNUEL" new-type="DECIMAL(14,2)"/><column id="MT_BOREREAU_HT" new-name="MT_BOREREAU_HT" new-type="DECIMAL(14,2)"/><column id="MT_BORDEREAU_TVA" new-name="MT_BORDEREAU_TVA" new-type="DECIMAL(14,2)"/><column id="MT_BORDEREAU_TTC" new-name="MT_BORDEREAU_TTC" new-type="DECIMAL(14,2)"/><column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/><column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/><index id="IX_${base-name}_BC" new-name="${base-name}_BC"/><index id="IX_${base-name}_DC" new-name="${base-name}_DC"/><index id="${base-name}_IDN" new-name="${base-name}_IDN"/><index id="${base-name}_AN" new-name="${base-name}_AN"/></table></etat><etat id="PES_PJ"><table base-name="PES_PJ_DOCUMENTS" new-name="PES_ALLER_PJ_DOCS"><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC" new-name="DOC" new-type="BLOB"/><column id="ENCODING" new-name="ENCODING" new-type="VARCHAR(1000)" avoid-generate="true"/><column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/><index id="IX_${base-name}_BC" new-name="${base-name}_BC"/><index id="${base-name}_AN" new-name="${base-name}_AN"/></table><table base-name="PES_PJ_PJ_IX" new-name="PES_ALLER_PJ_IX"><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)" new-qualif=""/><column id="TYPEPJ" new-name="TYPEPJ" new-type="VARCHAR(1000)"/><column id="NOMPJ" new-name="NOMPJ" new-type="VARCHAR(1000)"/><column id="DESCRIPTION" new-name="DESCRIPTION" new-type="VARCHAR(1000)"/><column id="IDUNIQUE" new-name="IDUNIQUE" new-type="VARCHAR(1000)"/><column id="SERVEURID" new-name="SERVEURID" new-type="VARCHAR(1000)"/><column id="LIBTYPEPJ" new-name="LIBTYPEPJ" new-type="VARCHAR(1000)"/><column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/><column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/><index id="IX_${base-name}_BC" new-name="${base-name}_BC"/><index id="IX_${base-name}_DC" new-name="${base-name}_DC"/><index id="${base-name}_AN" new-name="${base-name}_AN"/></table><table base-name="PES_PJ_PJ_REFCOMPTA_IX" new-name="PES_ALLER_PJ_REFCOMPTA"><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="IDENTIFIANT" new-name="IDENTIFIANT" new-type="VARCHAR(1000)"/><column id="TYPEOBJET" new-name="TYPEOBJET" new-type="INTEGER"/><column id="EXERCICE" new-name="EXERCICE" new-type="VARCHAR(1000)"/><column id="DOMAINE" new-name="DOMAINE" new-type="VARCHAR(1000)"/><column id="IDTIERS" new-name="IDTIERS" new-type="VARCHAR(1000)"/><column id="CODPROD" new-name="CODPROD" new-type="VARCHAR(1000)"/><column id="COMPLEMENTIDENTIFIANT" new-name="COMPLEMENTIDENTIFIANT" new-type="VARCHAR(1000)"/><column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/><column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/><index id="IX_${base-name}_BC" new-name="${base-name}_BC"/><index id="IX_${base-name}_DC" new-name="${base-name}_DC"/><index id="${base-name}_IDN" new-name="${base-name}_IDN"/><index id="${base-name}_AN" new-name="${base-name}_AN"/></table><table base-name="PES_PJ_PES_ALLER_PES_PJ_IX" new-name="PES_ALLER_PJ"><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="IDVER" new-name="IDVER" new-type="INTEGER"/><column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/><column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/><index id="IX_${base-name}_BC" new-name="${base-name}_BC"/><index id="IX_${base-name}_DC" new-name="${base-name}_DC"/><index id="${base-name}_IDN" new-name="${base-name}_IDN"/><index id="${base-name}_AN" new-name="${base-name}_AN"/></table></etat><etat id="PES_Facture"><table base-name="PES_ALLER_FACTURE_NOMENCLATUREBUDGET_IX" new-name="PES_ALLER_FACTURE_NOMENCLATUREBUDGET_IX"><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="LIBELLE" new-name="LIBELLE" new-type="VARCHAR(1000)"/><column id="CODE" new-name="CODE" new-type="VARCHAR(1000)"/><column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/><column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/><index id="IX_${base-name}_BC" new-name="IX_${base-name}_BC"/><index id="IX_${base-name}_DC" new-name="IX_${base-name}_DC"/><index id="${base-name}_IDN" new-name="${base-name}_IDN"/><index id="${base-name}_AN" new-name="${base-name}_AN"/></table><table base-name="PES_ALLER_FACTURE_NOMENCLATUREPRODUIT_IX" new-name="PES_ALLER_FACTURE_NOMENCLATUREPRODUIT_IX"><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="LIBELLE" new-name="LIBELLE" new-type="VARCHAR(1000)"/><column id="CODE" new-name="CODE" new-type="VARCHAR(1000)"/><column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/><column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/><index id="IX_${base-name}_BC" new-name="IX_${base-name}_BC"/><index id="IX_${base-name}_DC" new-name="IX_${base-name}_DC"/><index id="${base-name}_IDN" new-name="${base-name}_IDN"/><index id="${base-name}_AN" new-name="${base-name}_AN"/></table><table base-name="PES_ALLER_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX" new-name="PES_ALLER_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="ORDRE" new-name="ORDRE" new-type="VARCHAR(1000)"/><column id="MTTTC" new-name="MTTTC" new-type="DECIMAL(14,2)"/><column id="TAUX" new-name="TAUX" new-type="DECIMAL(5,2)"/><column id="MTHT" new-name="MTHT" new-type="DECIMAL(14,2)"/><column id="TAUXTVA" new-name="TAUXTVA" new-type="DECIMAL(5,2)"/><column id="MTTVA" new-name="MTTVA" new-type="DECIMAL(14,2)"/><column id="ORDREEDITION" new-name="ORDREEDITION" new-type="NUMBER"/><column id="CODEPRODUIT" new-name="CODEPRODUIT" new-type="VARCHAR(1000)"/><column id="CODENATURE" new-name="CODENATURE" new-type="VARCHAR(1000)"/><column id="LIBELLE" new-name="LIBELLE" new-type="VARCHAR(1000)"/><column id="UNITE" new-name="UNITE" new-type="VARCHAR(1000)"/><column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/><column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/><index id="IX_${base-name}_BC" new-name="IX_${base-name}_BC"/><index id="IX_${base-name}_DC" new-name="IX_${base-name}_DC"/><index id="${base-name}_IDN" new-name="${base-name}_IDN"/><index id="${base-name}_AN" new-name="${base-name}_AN"/></table><table base-name="PES_ALLER_FACTURE_DOCUMENTS" new-name="PES_ALLER_FACTURE_DOCUMENTS"><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC" new-name="DOC" new-type="BLOB"/><column id="ENCODING" new-name="ENCODING" new-type="VARCHAR(1000)" avoid-generate="true"/><column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/><index id="IX_${base-name}_BC" new-name="IX_${base-name}_BC"/><index id="${base-name}_IDN" new-name="${base-name}_IDN"/><index id="${base-name}_AN" new-name="${base-name}_AN"/></table><table base-name="PES_ALLER_FACTURE_NOMENCLATURENATURE_IX" new-name="PES_ALLER_FACTURE_NOMENCLATURENATURE_IX"><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="LIBELLE" new-name="LIBELLE" new-type="VARCHAR(1000)"/><column id="CODE" new-name="CODE" new-type="VARCHAR(1000)"/><column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/><column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/><index id="IX_${base-name}_BC" new-name="IX_${base-name}_BC"/><index id="IX_${base-name}_DC" new-name="IX_${base-name}_DC"/><index id="${base-name}_IDN" new-name="${base-name}_IDN"/><index id="${base-name}_AN" new-name="${base-name}_AN"/></table><table base-name="PES_ALLER_FACTURE_REPARTITIONPARNATURE_REPARTITION_IX" new-name="PES_ALLER_FACTURE_REPARTITIONPARNATURE_REPARTITION_IX"><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="LIBELLE" new-name="LIBELLE" new-type="VARCHAR(1000)"/><column id="CODE" new-name="CODE" new-type="VARCHAR(1000)"/><column id="MT" new-name="MT" new-type="DECIMAL(14,2)"/><column id="CODEFONCTION" new-name="CODEFONCTION" new-type="VARCHAR(1000)"/><column id="CODEBUDGET" new-name="CODEBUDGET" new-type="VARCHAR(1000)"/><column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/><column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/><index id="IX_${base-name}_BC" new-name="IX_${base-name}_BC"/><index id="IX_${base-name}_DC" new-name="IX_${base-name}_DC"/><index id="${base-name}_IDN" new-name="${base-name}_IDN"/><index id="${base-name}_AN" new-name="${base-name}_AN"/></table><table base-name="PES_ALLER_FACTURE_FACTUREINDIV_IX" new-name="PES_ALLER_FACTURE_FACTUREINDIV_IX"><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="CODPAYS" new-name="CODPAYS" new-type="NUMBER"/><column id="NUMBORDEREAU" new-name="NUMBORDEREAU" new-type="VARCHAR(1000)"/><column id="COMPLNOM" new-name="COMPLNOM" new-type="VARCHAR(1000)"/><column id="MTTOTALTTC" new-name="MTTOTALTTC" new-type="DECIMAL(14,2)"/><column id="NUMLIGNE" new-name="NUMLIGNE" new-type="NUMBER"/><column id="NUMTITRE" new-name="NUMTITRE" new-type="VARCHAR(1000)"/><column id="OBJET" new-name="OBJET" new-type="VARCHAR(1000)"/><column id="DATEEMISSION" new-name="DATEEMISSION" new-type="DATE"/><column id="DTEIDTIERS" new-name="DTEIDTIERS" new-type="DATE"/><column id="TEXTEGENERATEUR" new-name="TEXTEGENERATEUR" new-type="VARCHAR(1000)"/><column id="CP" new-name="CP" new-type="VARCHAR(1000)"/><column id="REFTIERS" new-name="REFTIERS" new-type="VARCHAR(1000)"/><column id="MODERECOUVREMENT" new-name="MODERECOUVREMENT" new-type="VARCHAR(1000)"/><column id="ADR3" new-name="ADR3" new-type="VARCHAR(1000)"/><column id="ADR2" new-name="ADR2" new-type="VARCHAR(1000)"/><column id="CATTIERS" new-name="CATTIERS" new-type="VARCHAR(1000)"/><column id="NATJUR" new-name="NATJUR" new-type="VARCHAR(1000)"/><column id="ADR1" new-name="ADR1" new-type="VARCHAR(1000)"/><column id="NATIDTIERS" new-name="NATIDTIERS" new-type="VARCHAR(1000)"/><column id="MTTOTALTVA" new-name="MTTOTALTVA" new-type="DECIMAL(14,2)"/><column id="PRENOM" new-name="PRENOM" new-type="VARCHAR(1000)"/><column id="NUMEROFACTURE" new-name="NUMEROFACTURE" new-type="VARCHAR(1000)"/><column id="LIGNE2" new-name="LIGNE2" new-type="VARCHAR(1000)"/><column id="LIGNE1" new-name="LIGNE1" new-type="VARCHAR(1000)"/><column id="CODRES" new-name="CODRES" new-type="VARCHAR(1000)"/><column id="MTTOTALHT" new-name="MTTOTALHT" new-type="DECIMAL(14,2)"/><column id="NOM" new-name="NOM" new-type="VARCHAR(1000)"/><column id="MODALITESREGLEMENT" new-name="MODALITESREGLEMENT" new-type="VARCHAR(1000)"/><column id="TYPTIERS" new-name="TYPTIERS" new-type="VARCHAR(1000)"/><column id="DATEREGLEMENT" new-name="DATEREGLEMENT" new-type="DATE"/><column id="CONDITIONSGEN" new-name="CONDITIONSGEN" new-type="VARCHAR(1000)"/><column id="EXERCICE" new-name="EXERCICE" new-type="VARCHAR(1000)"/><column id="VILLE" new-name="VILLE" new-type="VARCHAR(1000)"/><column id="IDTIERS" new-name="IDTIERS" new-type="VARCHAR(1000)"/><column id="TYPADR" new-name="TYPADR" new-type="VARCHAR(1000)"/><column id="CIVILITE" new-name="CIVILITE" new-type="VARCHAR(1000)"/><column id="RIB" new-name="RIB" new-type="VARCHAR(1000)"/><column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/><column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/><index id="IX_${base-name}_BC" new-name="IX_${base-name}_BC"/><index id="IX_${base-name}_DC" new-name="IX_${base-name}_DC"/><index id="${base-name}_IDN" new-name="${base-name}_IDN"/><index id="${base-name}_AN" new-name="${base-name}_AN"/></table><table base-name="PES_ALLER_FACTURE_TIERS_IX" new-name="PES_ALLER_FACTURE_TIERS_IX"><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="VILLE" new-name="VILLE" new-type="VARCHAR(1000)"/><column id="TYPADR" new-name="TYPADR" new-type="VARCHAR(1000)"/><column id="CP" new-name="CP" new-type="VARCHAR(1000)"/><column id="CATTIERS" new-name="CATTIERS" new-type="VARCHAR(1000)"/><column id="IDTIERS" new-name="IDTIERS" new-type="VARCHAR(1000)"/><column id="CODRES" new-name="CODRES" new-type="VARCHAR(1000)"/><column id="CODPAYS" new-name="CODPAYS" new-type="NUMBER"/><column id="PRENOM" new-name="PRENOM" new-type="VARCHAR(1000)"/><column id="TYPTIERS" new-name="TYPTIERS" new-type="VARCHAR(1000)"/><column id="REFTIERS" new-name="REFTIERS" new-type="VARCHAR(1000)"/><column id="NOM" new-name="NOM" new-type="VARCHAR(1000)"/><column id="ADR3" new-name="ADR3" new-type="VARCHAR(1000)"/><column id="NATIDTIERS" new-name="NATIDTIERS" new-type="VARCHAR(1000)"/><column id="ADR2" new-name="ADR2" new-type="VARCHAR(1000)"/><column id="ADR1" new-name="ADR1" new-type="VARCHAR(1000)"/><column id="DTEIDTIERS" new-name="DTEIDTIERS" new-type="DATE"/><column id="NATJUR" new-name="NATJUR" new-type="VARCHAR(1000)"/><column id="CIVILITE" new-name="CIVILITE" new-type="VARCHAR(1000)"/><column id="COMPLNOM" new-name="COMPLNOM" new-type="VARCHAR(1000)"/><column id="RIB" new-name="RIB" new-type="VARCHAR(1000)"/><column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/><column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/><index id="IX_${base-name}_BC" new-name="IX_${base-name}_BC"/><index id="IX_${base-name}_DC" new-name="IX_${base-name}_DC"/><index id="${base-name}_IDN" new-name="${base-name}_IDN"/><index id="${base-name}_AN" new-name="${base-name}_AN"/></table><table base-name="PES_ALLER_FACTURE_FACTUREINDIV_REPARTITIONBUDGET_IX" new-name="PES_ALLER_FACTURE_FACTUREINDIV_REPARTITIONBUDGET_IX"><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="CODEBUDGET" new-name="CODEBUDGET" new-type="VARCHAR(1000)"/><column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/><column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/><index id="IX_${base-name}_BC" new-name="IX_${base-name}_BC"/><index id="IX_${base-name}_DC" new-name="IX_${base-name}_DC"/><index id="${base-name}_IDN" new-name="${base-name}_IDN"/><index id="${base-name}_AN" new-name="${base-name}_AN"/></table><table base-name="PES_ALLER_FACTURE_FACTUREINDIV_DETAILTVA_IX" new-name="PES_ALLER_FACTURE_FACTUREINDIV_DETAILTVA_IX"><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="TAUXTVA" new-name="TAUXTVA" new-type="DECIMAL(5,2)"/><column id="MTTVA" new-name="MTTVA" new-type="DECIMAL(14,2)"/><column id="MTBASEHT" new-name="MTBASEHT" new-type="DECIMAL(14,2)"/><column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/><column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/><index id="IX_${base-name}_BC" new-name="IX_${base-name}_BC"/><index id="IX_${base-name}_DC" new-name="IX_${base-name}_DC"/><index id="${base-name}_IDN" new-name="${base-name}_IDN"/><index id="${base-name}_AN" new-name="${base-name}_AN"/></table><table base-name="PES_ALLER_FACTURE_IX" new-name="PES_ALLER_FACTURE_IX"><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="HORAIRESOUV" new-name="HORAIRESOUV" new-type="VARCHAR(1000)"/><column id="VILLE" new-name="VILLE" new-type="VARCHAR(1000)"/><column id="TYPADR" new-name="TYPADR" new-type="VARCHAR(1000)"/><column id="CP" new-name="CP" new-type="VARCHAR(1000)"/><column id="CATTIERS" new-name="CATTIERS" new-type="VARCHAR(1000)"/><column id="DATE" new-name="DATE" new-type="DATE"/><column id="NUMTVA" new-name="NUMTVA" new-type="VARCHAR(1000)"/><column id="IDTIERS" new-name="IDTIERS" new-type="VARCHAR(1000)"/><column id="ROLE" new-name="ROLE" new-type="VARCHAR(1000)"/><column id="CODRES" new-name="CODRES" new-type="VARCHAR(1000)"/><column id="CODPAYS" new-name="CODPAYS" new-type="NUMBER"/><column id="ADRTIPI" new-name="ADRTIPI" new-type="VARCHAR(1000)"/><column id="PRENOM" new-name="PRENOM" new-type="VARCHAR(1000)"/><column id="NUMTEL" new-name="NUMTEL" new-type="VARCHAR(1000)"/><column id="IDVER" new-name="IDVER" new-type="NUMBER"/><column id="NUMSEQUENCE" new-name="NUMSEQUENCE" new-type="NUMBER"/><column id="TYPEFACT" new-name="TYPEFACT" new-type="VARCHAR(1000)"/><column id="SERVICE" new-name="SERVICE" new-type="VARCHAR(1000)"/><column id="ANNEE" new-name="ANNEE" new-type="VARCHAR(1000)"/><column id="TYPTIERS" new-name="TYPTIERS" new-type="VARCHAR(1000)"/><column id="NOM" new-name="NOM" new-type="VARCHAR(1000)"/><column id="REFTIERS" new-name="REFTIERS" new-type="VARCHAR(1000)"/><column id="NATIDTIERS" new-name="NATIDTIERS" new-type="VARCHAR(1000)"/><column id="ADR3" new-name="ADR3" new-type="VARCHAR(1000)"/><column id="ADR2" new-name="ADR2" new-type="VARCHAR(1000)"/><column id="DTEIDTIERS" new-name="DTEIDTIERS" new-type="DATE"/><column id="ADR1" new-name="ADR1" new-type="VARCHAR(1000)"/><column id="REFBDF" new-name="REFBDF" new-type="VARCHAR(1000)"/><column id="CODETIPI" new-name="CODETIPI" new-type="NUMBER"/><column id="NATJUR" new-name="NATJUR" new-type="VARCHAR(1000)"/><column id="DESCRIPTION" new-name="DESCRIPTION" new-type="VARCHAR(1000)"/><column id="COMPLNOM" new-name="COMPLNOM" new-type="VARCHAR(1000)"/><column id="CIVILITE" new-name="CIVILITE" new-type="VARCHAR(1000)"/><column id="RIB" new-name="RIB" new-type="VARCHAR(1000)"/><column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/><column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/><index id="IX_${base-name}_BC" new-name="IX_${base-name}_BC"/><index id="IX_${base-name}_DC" new-name="IX_${base-name}_DC"/><index id="${base-name}_IDN" new-name="${base-name}_IDN"/><index id="${base-name}_AN" new-name="${base-name}_AN"/></table></etat><etat id="PES_RecetteAller"><table base-name="PES_ALLER_RA_ALL_PJ" new-name="PES_ALLER_R_ALL_PJ"><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)"/><column id="SUPPORT_PJ" new-name="SUPPORT_PJ" new-type="VARCHAR(1000)"/><column id="ID_UNIQUE_PJ" new-name="ID_UNIQUE_PJ" new-type="VARCHAR(1000)"/><column id="NOM_PJ" new-name="NOM_PJ" new-type="VARCHAR(1000)"/><column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/><column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/><index id="IX_${base-name}_BC" new-name="${base-name}_BC"/><index id="IX_${base-name}_DC" new-name="${base-name}_DC"/><index id="${base-name}_AN" new-name="${base-name}_AN"/></table><table base-name="PES_ALLER_RA_DOCUMENTS" new-name="PES_ALLER_R_DOCS"><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC" new-name="DOC" new-type="BLOB"/><column id="ENCODING" new-name="ENCODING" new-type="VARCHAR(1000)" avoid-generate="true"/><column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/><index id="IX_${base-name}_BC" new-name="${base-name}_BC"/><index id="${base-name}_AN" new-name="${base-name}_AN"/></table><table base-name="PES_ALLER_RA_LIGNE_PIECE_TIERS" new-name="PES_ALLER_R_LIG_TIERS"><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)" new-qualif=""/><column id="ID_TIERS" new-name="ID_TIERS" new-type="VARCHAR(1000)"/><column id="DATE_MALADE" new-name="DATE_MALADE" new-type="DATE"/><column id="NAT_ID_TIERS" new-name="NAT_ID_TIERS" new-type="VARCHAR(1000)"/><column id="DATE_ID_TIERS" new-name="DATE_ID_TIERS" new-type="DATE"/><column id="REF_TIERS" new-name="REF_TIERS" new-type="VARCHAR(1000)"/><column id="CAT_TIERS" new-name="CAT_TIERS" new-type="VARCHAR(1000)"/><column id="NAT_JUR" new-name="NAT_JUR" new-type="VARCHAR(1000)"/><column id="TYP_TIERS" new-name="TYP_TIERS" new-type="VARCHAR(1000)"/><column id="CIVILITE" new-name="CIVILITE" new-type="VARCHAR(1000)"/><column id="NOM" new-name="NOM" new-type="VARCHAR(1000)"/><column id="COMPLEMENT_NOM" new-name="COMPLEMENT_NOM" new-type="VARCHAR(1000)"/><column id="PRENOM" new-name="PRENOM" new-type="VARCHAR(1000)"/><column id="TYP_ADR" new-name="TYP_ADR" new-type="VARCHAR(1000)"/><column id="ADR1" new-name="ADR1" new-type="VARCHAR(1000)"/><column id="ADR2" new-name="ADR2" new-type="VARCHAR(1000)"/><column id="ADR3" new-name="ADR3" new-type="VARCHAR(1000)"/><column id="CP" new-name="CP" new-type="VARCHAR(1000)"/><column id="VILLE" new-name="VILLE" new-type="VARCHAR(1000)"/><column id="COD_RES" new-name="COD_RES" new-type="VARCHAR(1000)"/><column id="COD_PAYS" new-name="COD_PAYS" new-type="INTEGER"/><column id="DATE_ADR" new-name="DATE_ADR" new-type="DATE"/><column id="RIB" new-name="RIB" new-type="VARCHAR(1000)"/><column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/><column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/><index id="IX_${base-name}_BC" new-name="${base-name}_BC"/><index id="IX_${base-name}_DC" new-name="${base-name}_DC"/><index id="${base-name}_AN" new-name="${base-name}_AN"/></table><table base-name="PES_ALLER_RA_LIGNE_PIECE_PJREF" new-name="PES_ALLER_R_LIG_PJ"><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)" new-qualif=""/><column id="SUPPORT_PJ" new-name="SUPPORT_PJ" new-type="VARCHAR(1000)"/><column id="ID_UNIQUE_PJ" new-name="ID_UNIQUE_PJ" new-type="VARCHAR(1000)"/><column id="NOM_PJ" new-name="NOM_PJ" new-type="VARCHAR(1000)"/><column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/><column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/><index id="IX_${base-name}_BC" new-name="${base-name}_BC"/><index id="IX_${base-name}_DC" new-name="${base-name}_DC"/><index id="${base-name}_AN" new-name="${base-name}_AN"/></table><table base-name="PES_ALLER_RA_LIGNE_PIECE_RECOUVREMENT" new-name="PES_ALLER_R_LIG_RECOU"><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)" new-qualif=""/><column id="TYP_FLUX" new-name="TYP_FLUX" new-type="VARCHAR(1000)"/><column id="MODE_REGLEMENT" new-name="MODE_REGLEMENT" new-type="VARCHAR(1000)"/><column id="DATE_RECOUVREMENT" new-name="DATE_RECOUVREMENT" new-type="DATE"/><column id="ID_ENCAISSEMENT" new-name="ID_ENCAISSEMENT" new-type="INTEGER"/><column id="MNT_RECOUVREMENT" new-name="MNT_RECOUVREMENT" new-type="DECIMAL(14,2)"/><column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/><column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/><index id="IX_${base-name}_BC" new-name="${base-name}_BC"/><index id="IX_${base-name}_DC" new-name="${base-name}_DC"/><index id="${base-name}_AN" new-name="${base-name}_AN"/></table><table base-name="PES_ALLER_RA_PIECE_IX" new-name="PES_ALLER_R_PCE"><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)" new-qualif=""/><column id="CODE_SERVICE" new-name="CODE_SERVICE" new-type="VARCHAR(1000)"/><column id="AFFECT" new-name="AFFECT" new-type="VARCHAR(1000)"/><column id="CODE_PROD" new-name="CODE_PROD" new-type="VARCHAR(1000)"/><column id="ID_PIECE" new-name="ID_PIECE" new-type="INTEGER"/><column id="TYPE_PIECE" new-name="TYPE_PIECE" new-type="VARCHAR(1000)"/><column id="NATURE_PIECE" new-name="NATURE_PIECE" new-type="VARCHAR(1000)"/><column id="ID_ROL" new-name="ID_ROL" new-type="INTEGER"/><column id="DATE_ASP" new-name="DATE_ASP" new-type="DATE"/><column id="OBJ" new-name="OBJ" new-type="VARCHAR(1000)"/><column id="DEB_FACT" new-name="DEB_FACT" new-type="DATE"/><column id="FIN_FACT" new-name="FIN_FACT" new-type="DATE"/><column id="NB_LIGNE" new-name="NB_LIGNE" new-type="INTEGER"/><column id="MONTANT_TTC" new-name="MONTANT_TTC" new-type="DECIMAL(14,2)"/><column id="MONTANT_HT" new-name="MONTANT_HT" new-type="DECIMAL(14,2)"/><column id="AVEC_PJ" new-name="AVEC_PJ" new-type="VARCHAR(1000)"/><column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/><column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/><index id="IX_${base-name}_BC" new-name="${base-name}_BC"/><index id="IX_${base-name}_DC" new-name="${base-name}_DC"/><index id="${base-name}_AN" new-name="${base-name}_AN"/></table><table base-name="PES_ALLER_RA_BORDEREAU_IX" new-name="PES_ALLER_R_BORD"><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="PRIMARY_KEY" new-name="PRIMARY_KEY" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="EXERCICE" new-name="EXERCICE" new-type="INTEGER"/><column id="ID_BORDEREAU" new-name="ID_BORDEREAU" new-type="INTEGER"/><column id="DATE_EMISSION_BORDEREAU" new-name="DATE_EMISSION_BORDEREAU" new-type="DATE"/><column id="TYPE_BORDEREAU" new-name="TYPE_BORDEREAU" new-type="VARCHAR(1000)"/><column id="NB_PIECES" new-name="NB_PIECES" new-type="INTEGER"/><column id="MT_CUMUL_ANNUEL" new-name="MT_CUMUL_ANNUEL" new-type="DECIMAL(14,2)"/><column id="MT_BOREREAU_HT" new-name="MT_BOREREAU_HT" new-type="DECIMAL(14,2)"/><column id="MT_BORDEREAU_TVA" new-name="MT_BORDEREAU_TVA" new-type="DECIMAL(14,2)"/><column id="MONTANT_TTC" new-name="MONTANT_TTC" new-type="DECIMAL(14,2)"/><column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/><column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/><index id="IX_${base-name}_BC" new-name="${base-name}_BC"/><index id="IX_${base-name}_DC" new-name="${base-name}_DC"/><index id="${base-name}_AN" new-name="${base-name}_AN"/></table><table base-name="PES_ALLER_RA_LIGNE_PIECE_IX" new-name="PES_ALLER_R_LIG"><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)" new-qualif=""/><column id="ID_LIGNE" new-name="ID_LIGNE" new-type="VARCHAR(1000)"/><column id="OBJET" new-name="OBJET" new-type="VARCHAR(1000)"/><column id="CODE_PROD" new-name="CODE_PROD" new-type="VARCHAR(1000)"/><column id="FIN_GEO" new-name="FIN_GEO" new-type="INTEGER"/><column id="COD_ET_GEO" new-name="COD_ET_GEO" new-type="VARCHAR(1000)"/><column id="NATURE" new-name="NATURE" new-type="VARCHAR(1000)"/><column id="FONCTION" new-name="FONCTION" new-type="VARCHAR(1000)"/><column id="OPERATION" new-name="OPERATION" new-type="VARCHAR(1000)"/><column id="COMPTE_ANA" new-name="COMPTE_ANA" new-type="VARCHAR(1000)"/><column id="FACTURE" new-name="FACTURE" new-type="VARCHAR(1000)"/><column id="TAUX_TVA" new-name="TAUX_TVA" new-type="DECIMAL(5,2)"/><column id="MAJO" new-name="MAJO" new-type="VARCHAR(1000)"/><column id="DATE_MAJO" new-name="DATE_MAJO" new-type="DATE"/><column id="TAUX_MAJO" new-name="TAUX_MAJO" new-type="DECIMAL(5,2)"/><column id="COMPTE_TIERS" new-name="COMPTE_TIERS" new-type="VARCHAR(1000)"/><column id="TVA_INTRA_COM" new-name="TVA_INTRA_COM" new-type="VARCHAR(1000)"/><column id="COMPTE_TVA" new-name="COMPTE_TVA" new-type="VARCHAR(1000)"/><column id="MT_HT" new-name="MT_HT" new-type="DECIMAL(14,2)"/><column id="MT_TVA" new-name="MT_TVA" new-type="DECIMAL(14,2)"/><column id="MT_NON_MAJO" new-name="MT_NON_MAJO" new-type="DECIMAL(14,2)"/><column id="NAT_PREL" new-name="NAT_PREL" new-type="VARCHAR(1000)"/><column id="PER_PREL" new-name="PER_PREL" new-type="VARCHAR(1000)"/><column id="DATE_PREL" new-name="DATE_PREL" new-type="DATE"/><column id="MNT_PREL" new-name="MNT_PREL" new-type="DECIMAL(14,2)"/><column id="COD_ASS_DEB" new-name="COD_ASS_DEB" new-type="VARCHAR(1000)"/><column id="COD_AYANT_DROIT" new-name="COD_AYANT_DROIT" new-type="VARCHAR(1000)"/><column id="NATURE_PIECE_ORIGINE" new-name="NATURE_PIECE_ORIGINE" new-type="VARCHAR(1000)"/><column id="EXERCICE_RAT" new-name="EXERCICE_RAT" new-type="VARCHAR(1000)"/><column id="ID_PIECE_ORIGINE" new-name="ID_PIECE_ORIGINE" new-type="INTEGER"/><column id="ID_LIGNE_ORIGINE" new-name="ID_LIGNE_ORIGINE" new-type="VARCHAR(1000)"/><column id="ID_ENCAISSEMENT" new-name="ID_ENCAISSEMENT" new-type="INTEGER"/><column id="ID_CONV" new-name="ID_CONV" new-type="VARCHAR(1000)"/><column id="ID_MARCHE" new-name="ID_MARCHE" new-type="VARCHAR(1000)"/><column id="ID_CAUTION" new-name="ID_CAUTION" new-type="VARCHAR(1000)"/><column id="ID_EMPRUNT_ORDO" new-name="ID_EMPRUNT_ORDO" new-type="VARCHAR(1000)"/><column id="ID_ACTIF" new-name="ID_ACTIF" new-type="VARCHAR(1000)"/><column id="ID_REGIE" new-name="ID_REGIE" new-type="VARCHAR(1000)"/><column id="MONTANT_TTC" new-name="MONTANT_TTC" new-type="DECIMAL(14,2)"/><column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/><column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/><index id="IX_${base-name}_BC" new-name="${base-name}_BC"/><index id="IX_${base-name}_DC" new-name="${base-name}_DC"/><index id="${base-name}_IDN" new-name="${base-name}_IDN"/><index id="${base-name}_AN" new-name="${base-name}_AN"/></table><table base-name="PES_ALLER_RA_PIECE_PJREF_IX" new-name="PES_ALLER_R_PCE_PJ"><column id="COLLECTIVITE" new-name="COLLECTIVITE" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="BUDGET" new-name="BUDGET" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="DOC_ID" new-name="DOC_ID" new-type="VARCHAR(1000)" new-qualif="NOT NULL"/><column id="NODE_ID" new-name="NODE_ID" new-type="VARCHAR(1000)" new-qualif=""/><column id="SUPPORT_PJ" new-name="SUPPORT_PJ" new-type="VARCHAR(1000)"/><column id="ID_UNIQUE_PJ" new-name="ID_UNIQUE_PJ" new-type="VARCHAR(1000)"/><column id="NOM_PJ" new-name="NOM_PJ" new-type="VARCHAR(1000)"/><column id="INITIAL_DOC_NAME" new-name="INITIAL_DOC_NAME" new-type="VARCHAR(1000)"/><column id="ARCHIVE_NAME" new-name="ARCHIVE_NAME" new-type="VARCHAR(1000)"/><index id="IX_${base-name}_BC" new-name="${base-name}_BC"/><index id="IX_${base-name}_DC" new-name="${base-name}_DC"/><index id="${base-name}_IDN" new-name="${base-name}_IDN"/><index id="${base-name}_AN" new-name="${base-name}_AN"/></table></etat></document>
\ No newline at end of file