-- Table structure for table `aide_notices`
--

CREATE TABLE `aide_notices` (
  `DATE_MISE_A_JOUR` date DEFAULT NULL,
  `ID_AIDE_NOTICES` varchar(32) NOT NULL DEFAULT '',
  `NOM` varchar(100) NOT NULL DEFAULT '',
  `NOM_DOSSIER` varchar(100) NOT NULL DEFAULT '',
  `NOTICES_FICHIER_CONTENU` longblob DEFAULT NULL,
  `NOTICES_FICHIER_DATE` datetime DEFAULT NULL,
  `NOTICES_FICHIER_NOM` varchar(100) NOT NULL DEFAULT '',
  `NOTICES_FICHIER_TAILLE` double NOT NULL DEFAULT 0,
  `NOTICES_FICHIER_TYPE` varchar(50) NOT NULL DEFAULT '',
  `NUMERO` double NOT NULL DEFAULT 0,
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `VUE_APPLICATION` varchar(50) NOT NULL DEFAULT '',
  `LAST_NEWS` varchar(2) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_NOTICES`),
  KEY `NOTICES_FICHIER_DATE` (`NOTICES_FICHIER_DATE`) USING BTREE,
  KEY `NOTICES_FICHIER_NOM` (`NOTICES_FICHIER_NOM`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `LAST_NEWS` (`LAST_NEWS`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_operateur`
--

CREATE TABLE `aide_operateur` (
  `ID_AIDE_OPERATEUR` varchar(32) NOT NULL DEFAULT '',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `NOM` varchar(100) NOT NULL DEFAULT '',
  `PRENOM` varchar(100) NOT NULL DEFAULT '',
  `INIT` varchar(3) NOT NULL DEFAULT '',
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  PRIMARY KEY (`ID_AIDE_OPERATEUR`),
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_origine_prospect`
--

CREATE TABLE `aide_origine_prospect` (
  `ID_AIDE_ORIGINE_PROSPECT` varchar(32) NOT NULL DEFAULT '',
  `NUMERO` double NOT NULL DEFAULT 0,
  `ORIGNIE` varchar(100) NOT NULL DEFAULT '',
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_ORIGINE_PROSPECT`),
  KEY `NUMERO` (`NUMERO`) USING BTREE,
  KEY `ORIGNIE` (`ORIGNIE`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_pays`
--

CREATE TABLE `aide_pays` (
  `ALPHA2` varchar(2) NOT NULL DEFAULT '',
  `ALPHA3` varchar(3) NOT NULL DEFAULT '',
  `CODE` double NOT NULL DEFAULT 0,
  `ID_AIDE_PAYS` varchar(32) NOT NULL DEFAULT '',
  `NOM_EN_GB` varchar(50) NOT NULL DEFAULT '',
  `NOM_FR_FR` varchar(50) NOT NULL DEFAULT '',
  `NUMERO` double NOT NULL DEFAULT 0,
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_PAYS`),
  KEY `ALPHA2` (`ALPHA2`) USING BTREE,
  KEY `ALPHA3` (`ALPHA3`) USING BTREE,
  KEY `CODE` (`CODE`) USING BTREE,
  KEY `NOM_EN_GB` (`NOM_EN_GB`) USING BTREE,
  KEY `NOM_FR_FR` (`NOM_FR_FR`) USING BTREE,
  KEY `NUMERO` (`NUMERO`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_perio_annuelle`
--

CREATE TABLE `aide_perio_annuelle` (
  `ID_AIDE_PERIO_ANNUELLE` varchar(32) NOT NULL DEFAULT '',
  `LIBELLE` varchar(20) NOT NULL DEFAULT '',
  `MULTIPLE` double NOT NULL DEFAULT 0,
  `NUMERO` varchar(10) NOT NULL DEFAULT '',
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `NBRE_PERIO` double NOT NULL DEFAULT 0,
  PRIMARY KEY (`ID_AIDE_PERIO_ANNUELLE`),
  KEY `LIBELLE` (`LIBELLE`) USING BTREE,
  KEY `MULTIPLE` (`MULTIPLE`) USING BTREE,
  KEY `NUMERO` (`NUMERO`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_perio_mois`
--

CREATE TABLE `aide_perio_mois` (
  `ID_AIDE_PERIO_MOIS` varchar(32) NOT NULL DEFAULT '',
  `INTITULE` varchar(10) NOT NULL DEFAULT '',
  `N_DOSSIER` double NOT NULL DEFAULT 0,
  `N_MOIS_ANNEE` double NOT NULL DEFAULT 0,
  `N_MOIS_EXERCICE` double NOT NULL DEFAULT 0,
  `PID_AIDE_PERIODICITE` varchar(32) NOT NULL DEFAULT '',
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_PERIO_MOIS`),
  KEY `INTITULE` (`INTITULE`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `N_MOIS_ANNEE` (`N_MOIS_ANNEE`) USING BTREE,
  KEY `N_MOIS_EXERCICE` (`N_MOIS_EXERCICE`) USING BTREE,
  KEY `PID_AIDE_PERIODICITE` (`PID_AIDE_PERIODICITE`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_periodicite`
--

CREATE TABLE `aide_periodicite` (
  `ID_AIDE_PERIODICITE` varchar(32) NOT NULL DEFAULT '',
  `INTITULE` varchar(20) NOT NULL DEFAULT '',
  `MOIS` varchar(5) NOT NULL DEFAULT '',
  `NOM_DOSSIER` varchar(20) NOT NULL DEFAULT '',
  `NUMERO` double NOT NULL DEFAULT 0,
  `NUMERO_MOIS_ANNEE_CIVILE` double NOT NULL DEFAULT 0,
  `NUMERO_MOIS_EXERCICE` double NOT NULL DEFAULT 0,
  `N_DOSSIER` varchar(10) NOT NULL DEFAULT '',
  `N_EXERCICE` double NOT NULL DEFAULT 0,
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `MOIS_TRAV_GOOD` varchar(10) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_PERIODICITE`),
  KEY `MOIS` (`MOIS`) USING BTREE,
  KEY `NOM_DOSSIER` (`NOM_DOSSIER`) USING BTREE,
  KEY `NUMERO` (`NUMERO`) USING BTREE,
  KEY `NUMERO_MOIS_ANNEE_CIVILE` (`NUMERO_MOIS_ANNEE_CIVILE`) USING BTREE,
  KEY `NUMERO_MOIS_EXERCICE` (`NUMERO_MOIS_EXERCICE`) USING BTREE,
  KEY `N_EXERCICE` (`N_EXERCICE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_piece_substitution`
--

CREATE TABLE `aide_piece_substitution` (
  `DENOMINATION` varchar(50) NOT NULL DEFAULT '',
  `ID_AIDE_PIECE_SUBSTITUTION` varchar(32) NOT NULL DEFAULT '',
  `REFERENCE` varchar(10) NOT NULL DEFAULT '',
  `REF_SUBSTITUTION` varchar(30) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  PRIMARY KEY (`ID_AIDE_PIECE_SUBSTITUTION`),
  KEY `DENOMINATION` (`DENOMINATION`) USING BTREE,
  KEY `REFERENCE` (`REFERENCE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_plan_comptable`
--

CREATE TABLE `aide_plan_comptable` (
  `ACTIF` char(1) NOT NULL DEFAULT '',
  `DOCUMENT` double NOT NULL DEFAULT 0,
  `DOCUMENT8NOM` varchar(30) NOT NULL DEFAULT '',
  `ID_AIDE_PLAN_COMPTABLE` varchar(32) NOT NULL DEFAULT '',
  `INTITULE` varchar(200) NOT NULL DEFAULT '',
  `NOM_COMPTE_TVA` varchar(100) NOT NULL DEFAULT '',
  `NOM_DOSSIER` varchar(200) NOT NULL DEFAULT '',
  `NOM_TIERS` varchar(20) NOT NULL DEFAULT '',
  `NUMERO_COMPTE` varchar(10) NOT NULL DEFAULT '',
  `NUMERO_NOM` varchar(200) NOT NULL DEFAULT '',
  `N_COMPTE3` double NOT NULL DEFAULT 0,
  `N_COMPTE8` varchar(8) NOT NULL DEFAULT '',
  `N_COMPTE_TVA` varchar(8) NOT NULL DEFAULT '',
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TAUX_TVA` double NOT NULL DEFAULT 0,
  `NOM_COMPTE_ABREGE` varchar(50) NOT NULL DEFAULT '',
  `DATE_HEURE` varchar(60) NOT NULL DEFAULT '',
  `N_TRESO` double NOT NULL DEFAULT 0,
  `RIEN` varchar(30) NOT NULL DEFAULT '',
  `TYPE_TVA_LIBELLE` varchar(20) NOT NULL DEFAULT '',
  `TYPE_TVA_NUMERO` double NOT NULL DEFAULT 0,
  `N_EXCEL` double NOT NULL DEFAULT 0,
  `ECRITURE_N-1` char(1) NOT NULL DEFAULT '',
  `ECRITURE_SIMULATION` char(1) NOT NULL DEFAULT '',
  `ECRITURE_SITUATION` char(1) NOT NULL DEFAULT '',
  `TOTAL_ANA` double NOT NULL DEFAULT 0,
  `ACTIVITE` varchar(20) NOT NULL DEFAULT '',
  `N_ACTIVITE` decimal(12,0) NOT NULL DEFAULT 0,
  `IDENTIFICATION_TIERS` varchar(32) NOT NULL DEFAULT '',
  `NOM_REGROUPEMENT_PRINCIPAL` varchar(100) NOT NULL DEFAULT '',
  `NOM_REGROUPEMENT_SECONDAIRE_1` varchar(100) NOT NULL DEFAULT '',
  `N_REGROUPEMENT_PRINCIPAL` double NOT NULL DEFAULT 0,
  `N_REGROUPEMENT_SECONDAIRE_1` double NOT NULL DEFAULT 0,
  `ONGLET` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_PLAN_COMPTABLE`),
  KEY `ACTIF` (`ACTIF`) USING BTREE,
  KEY `DOCUMENT` (`DOCUMENT`) USING BTREE,
  KEY `DOCUMENT8NOM` (`DOCUMENT8NOM`) USING BTREE,
  KEY `NUMERO_COMPTE` (`NUMERO_COMPTE`) USING BTREE,
  KEY `N_COMPTE8` (`N_COMPTE8`) USING BTREE,
  KEY `N_COMPTE_TVA` (`N_COMPTE_TVA`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `TAUX_TVA` (`TAUX_TVA`) USING BTREE,
  KEY `DATE_HEURE` (`DATE_HEURE`) USING BTREE,
  KEY `N_TRESO` (`N_TRESO`) USING BTREE,
  KEY `NOM_COMPTE_ABREGE` (`NOM_COMPTE_ABREGE`) USING BTREE,
  KEY `NUMERO_NOM` (`NUMERO_NOM`) USING BTREE,
  KEY `N_EXCEL` (`N_EXCEL`) USING BTREE,
  KEY `ECRITURE_N-1` (`ECRITURE_N-1`) USING BTREE,
  KEY `ECRITURE_SIMULATION` (`ECRITURE_SIMULATION`) USING BTREE,
  KEY `ECRITURE_SITUATION` (`ECRITURE_SITUATION`) USING BTREE,
  KEY `NOM_DOSSIER` (`NOM_DOSSIER`) USING BTREE,
  KEY `ACTIVITE` (`ACTIVITE`) USING BTREE,
  KEY `N_ACTIVITE` (`N_ACTIVITE`) USING BTREE,
  KEY `IDENTIFICATION_TIERS` (`IDENTIFICATION_TIERS`) USING BTREE,
  KEY `N_REGROUPEMENT_PRINCIPAL` (`N_REGROUPEMENT_PRINCIPAL`) USING BTREE,
  KEY `N_REGROUPEMENT_SECONDAIRE_1` (`N_REGROUPEMENT_SECONDAIRE_1`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_plan_comptable_ana`
--

CREATE TABLE `aide_plan_comptable_ana` (
  `ID_AIDE_PLAN_COMPTABLE_ANA` varchar(32) NOT NULL DEFAULT '',
  `N_DOSSIER` double NOT NULL DEFAULT 0,
  `PID_AIDE_PLAN_COMPTABLE` varchar(32) NOT NULL DEFAULT '',
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `NOM_DOSSIER` varchar(20) NOT NULL DEFAULT '',
  `NUMERO_ANA1` double NOT NULL DEFAULT 0,
  `POURC_ANA1` decimal(12,0) NOT NULL DEFAULT 0,
  `CODE_ANA1` varchar(10) NOT NULL DEFAULT '',
  `CODE_ANA2` varchar(10) NOT NULL DEFAULT '',
  `CODE_ANA3` varchar(10) NOT NULL DEFAULT '',
  `CODE_ANA4` varchar(10) NOT NULL DEFAULT '',
  `CODE_ANA5` varchar(10) NOT NULL DEFAULT '',
  `NUMERO_ANA2` decimal(12,0) NOT NULL DEFAULT 0,
  `NUMERO_ANA3` decimal(12,0) NOT NULL DEFAULT 0,
  `NUMERO_ANA4` decimal(12,0) NOT NULL DEFAULT 0,
  `NUMERO_ANA5` decimal(12,0) NOT NULL DEFAULT 0,
  `POURC_ANA2` decimal(12,0) NOT NULL DEFAULT 0,
  `POURC_ANA3` decimal(12,0) NOT NULL DEFAULT 0,
  `POURC_ANA4` decimal(12,0) NOT NULL DEFAULT 0,
  `POURC_ANA5` decimal(12,0) NOT NULL DEFAULT 0,
  `POUR_TOTAL` decimal(12,0) NOT NULL DEFAULT 0,
  `N_COMPTE8` varchar(8) NOT NULL DEFAULT '',
  `N_DOSSIER_COMPTE` varchar(15) NOT NULL DEFAULT '',
  `ANS_MAN` char(1) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_PLAN_COMPTABLE_ANA`),
  KEY `PID_AIDE_PLAN_COMPTABLE` (`PID_AIDE_PLAN_COMPTABLE`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `NUMERO_ANA1` (`NUMERO_ANA1`) USING BTREE,
  KEY `CODE_ANA1` (`CODE_ANA1`) USING BTREE,
  KEY `CODE_ANA2` (`CODE_ANA2`) USING BTREE,
  KEY `CODE_ANA3` (`CODE_ANA3`) USING BTREE,
  KEY `CODE_ANA4` (`CODE_ANA4`) USING BTREE,
  KEY `CODE_ANA5` (`CODE_ANA5`) USING BTREE,
  KEY `NUMERO_ANA2` (`NUMERO_ANA2`) USING BTREE,
  KEY `NUMERO_ANA3` (`NUMERO_ANA3`) USING BTREE,
  KEY `NUMERO_ANA4` (`NUMERO_ANA4`) USING BTREE,
  KEY `NUMERO_ANA5` (`NUMERO_ANA5`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `N_COMPTE8` (`N_COMPTE8`) USING BTREE,
  KEY `N_DOSSIER_COMPTE` (`N_DOSSIER_COMPTE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_plan_comptable_parametrage`
--

CREATE TABLE `aide_plan_comptable_parametrage` (
  `N_DOCUMENT` varchar(20) NOT NULL DEFAULT '',
  `NOM_DOCUMENT` varchar(30) NOT NULL DEFAULT '',
  `ID_AIDE_PLAN_COMPTABLE_PARAMETRAGE` varchar(32) NOT NULL DEFAULT '',
  `NOM_REGROUPEMENT_PRINCIPAL` varchar(100) NOT NULL DEFAULT '',
  `N_REGROUPEMENT_PRINCIPAL` double NOT NULL DEFAULT 0,
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `PID_AIDE_PLAN_COMPTABLE_PARAMETRAGE` varchar(32) NOT NULL DEFAULT '',
  `ONGLET` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_PLAN_COMPTABLE_PARAMETRAGE`),
  KEY `N_DOCUMENT` (`N_DOCUMENT`) USING BTREE,
  KEY `NOM_DOCUMENT` (`NOM_DOCUMENT`) USING BTREE,
  KEY `N_REGROUPEMENT_PRINCIPAL` (`N_REGROUPEMENT_PRINCIPAL`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `PID_AIDE_PLAN_COMPTABLE_PARAMETRAGE` (`PID_AIDE_PLAN_COMPTABLE_PARAMETRAGE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_plan_comptable_parametrage_detail1`
--

CREATE TABLE `aide_plan_comptable_parametrage_detail1` (
  `ID_AIDE_PLAN_COMPTABLE_PARAMETRAGE_DETAIL1` varchar(32) NOT NULL DEFAULT '',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `N_REGROUPEMENT_SECONDAIRE_1` decimal(12,0) NOT NULL DEFAULT 0,
  `NOM_REGROUPEMENT_SECONDAIRE_1` varchar(100) NOT NULL DEFAULT '',
  `N_REGROUPEMENT_PRINCIPAL` decimal(12,0) NOT NULL DEFAULT 0,
  `NOM_REGROUPEMENT_PRINCIPAL` varchar(100) NOT NULL DEFAULT '',
  `PID_AIDE_PLAN_COMPTABLE_PARAMETRAGE` varchar(32) NOT NULL DEFAULT '',
  `ONGLET` varchar(50) NOT NULL DEFAULT '',
  `VERROU` char(1) NOT NULL DEFAULT '',
  `N_DOSSIER` decimal(12,0) NOT NULL DEFAULT 0,
  `NOM_DOSSIER` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_PLAN_COMPTABLE_PARAMETRAGE_DETAIL1`),
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `N_REGROUPEMENT_SECONDAIRE_1` (`N_REGROUPEMENT_SECONDAIRE_1`) USING BTREE,
  KEY `PID_AIDE_PLAN_COMPTABLE_PARAMETRAGE` (`PID_AIDE_PLAN_COMPTABLE_PARAMETRAGE`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_plan_comptable_parametrage_detail2`
--

CREATE TABLE `aide_plan_comptable_parametrage_detail2` (
  `ID_AIDE_PLAN_COMPTABLE_PARAMETRAGE_DETAIL2` varchar(32) NOT NULL DEFAULT '',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `N_REGROUPEMENT_SECONDAIRE_2` decimal(12,0) NOT NULL DEFAULT 0,
  `NOM_REGROUPEMENT_SECONDAIRE_2` varchar(100) NOT NULL DEFAULT '',
  `N_REGROUPEMENT_PRINCIPAL` decimal(12,0) NOT NULL DEFAULT 0,
  `NOM_REGROUPEMENT_PRINCIPAL` varchar(100) NOT NULL DEFAULT '',
  `N_REGROUPEMENT_SECONDAIRE_1` decimal(12,0) NOT NULL DEFAULT 0,
  `NOM_REGROUPEMENT_SECONDAIRE_1` varchar(100) NOT NULL DEFAULT '',
  `PID_AIDE_PLAN_COMPTABLE_PARAMETRAGE` varchar(32) NOT NULL DEFAULT '',
  `PID_AIDE_PLAN_COMPTABLE_PARAMETRAGE_DETAIL1` varchar(32) NOT NULL DEFAULT '',
  `ONGLET` varchar(50) NOT NULL DEFAULT '',
  `VERROU` char(1) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_PLAN_COMPTABLE_PARAMETRAGE_DETAIL2`),
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `PID_AIDE_PLAN_COMPTABLE_PARAMETRAGE` (`PID_AIDE_PLAN_COMPTABLE_PARAMETRAGE`) USING BTREE,
  KEY `PID_AIDE_PLAN_COMPTABLE_PARAMETRAGE_DETAIL1` (`PID_AIDE_PLAN_COMPTABLE_PARAMETRAGE_DETAIL1`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_plan_comptable_regroupement`
--

CREATE TABLE `aide_plan_comptable_regroupement` (
  `ID_AIDE_PLAN_COMPTABLE_REGROUPEMENT` varchar(32) NOT NULL DEFAULT '',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `PID_AIDE_PLAN_COMPTABLE` varchar(32) NOT NULL DEFAULT '',
  `N_COMPTE8` varchar(8) NOT NULL DEFAULT '',
  `N_DOSSIER` decimal(12,0) NOT NULL DEFAULT 0,
  `NOM_DOSSIER` varchar(50) NOT NULL DEFAULT '',
  `N_REGROUPEMENT_PRINCIPAL` decimal(12,2) NOT NULL DEFAULT 0.00,
  `NOM_REGROUPEMENT_PRINCIPAL` varchar(50) NOT NULL DEFAULT '',
  `N_REGROUPEMENT_SECONDAIRE_1` decimal(12,0) NOT NULL DEFAULT 0,
  `NOM_REGROUPEMENT_SECONDAIRE_1` varchar(50) NOT NULL DEFAULT '',
  `N_REGROUPEMENT_SECONCAIRE_2` decimal(12,0) NOT NULL DEFAULT 0,
  `NOM_REGROUPEMENT_SECONDAIRE_2` varchar(50) NOT NULL DEFAULT '',
  `N_COMPTE_DOSSIER` varchar(15) NOT NULL DEFAULT '',
  `ONGLET` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_PLAN_COMPTABLE_REGROUPEMENT`),
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `PID_AIDE_PLAN_COMPTABLE` (`PID_AIDE_PLAN_COMPTABLE`) USING BTREE,
  KEY `N_COMPTE8` (`N_COMPTE8`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `N_REGROUPEMENT_PRINCIPAL` (`N_REGROUPEMENT_PRINCIPAL`) USING BTREE,
  KEY `N_REGROUPEMENT_SECONDAIRE_1` (`N_REGROUPEMENT_SECONDAIRE_1`) USING BTREE,
  KEY `N_REGROUPEMENT_SECONCAIRE_2` (`N_REGROUPEMENT_SECONCAIRE_2`) USING BTREE,
  KEY `N_COMPTE_DOSSIER` (`N_COMPTE_DOSSIER`) USING BTREE,
  KEY `ONGLET` (`ONGLET`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_plan_comptable_revision`
--

CREATE TABLE `aide_plan_comptable_revision` (
  `ID_AIDE_PLAN_COMPTABLE_REVISION` varchar(32) NOT NULL DEFAULT '',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `PID_AIDE_PLAN_COMPTABLE` varchar(32) NOT NULL DEFAULT '',
  `N_DOSSIER` decimal(12,0) NOT NULL DEFAULT 0,
  `NOM_DOSSIER` varchar(50) NOT NULL DEFAULT '',
  `N_EXERCICE` decimal(12,0) NOT NULL DEFAULT 0,
  `REVISION_DATE` date DEFAULT NULL,
  `REVISION_QUI` varchar(10) NOT NULL DEFAULT '',
  `N_COMPTE8` varchar(10) NOT NULL DEFAULT '',
  `DOSSIER_EXERCICE_COMPTE` varchar(40) NOT NULL DEFAULT '',
  `N_CPTE_TIERS` varchar(30) NOT NULL DEFAULT '',
  `DOSSIER_EXERCICE_COMPTE_RECIPROCITE` varchar(40) NOT NULL DEFAULT '',
  `COMMENTAIRE` varchar(200) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_PLAN_COMPTABLE_REVISION`),
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `PID_AIDE_PLAN_COMPTABLE` (`PID_AIDE_PLAN_COMPTABLE`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `N_EXERCICE` (`N_EXERCICE`) USING BTREE,
  KEY `REVISION_DATE` (`REVISION_DATE`) USING BTREE,
  KEY `REVISION_QUI` (`REVISION_QUI`) USING BTREE,
  KEY `DOSSIER_EXERCICE_COMPTE` (`DOSSIER_EXERCICE_COMPTE`) USING BTREE,
  KEY `N_CPTE_TIERS` (`N_CPTE_TIERS`) USING BTREE,
  KEY `DOSSIER_EXERCICE_COMPTE_RECIPROCITE` (`DOSSIER_EXERCICE_COMPTE_RECIPROCITE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_points_livraisons`
--

CREATE TABLE `aide_points_livraisons` (
  `ID_AIDE_POINTS_LIVRAISONS` varchar(32) NOT NULL DEFAULT '',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `DESIGNATION` varchar(150) NOT NULL DEFAULT '',
  `N_JOURS` varchar(13) NOT NULL DEFAULT '',
  `JOURS` varchar(150) NOT NULL DEFAULT '',
  `ACTIF` char(1) NOT NULL DEFAULT '',
  `N_REGROUPEMENT` decimal(12,0) NOT NULL DEFAULT 0,
  `IDENT_TIERS` varchar(32) NOT NULL DEFAULT '',
  `CODE_TIERS` varchar(32) NOT NULL DEFAULT '',
  `N_TARIF` varchar(10) NOT NULL DEFAULT '',
  `IDENT_TARIF` varchar(32) NOT NULL DEFAULT '',
  `HEURE_LIVRAISON` varchar(5) NOT NULL DEFAULT '',
  `ORDRE_AFFICHAGE_FORM` decimal(12,0) NOT NULL DEFAULT 0,
  PRIMARY KEY (`ID_AIDE_POINTS_LIVRAISONS`),
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `N_REGROUPEMENT` (`N_REGROUPEMENT`) USING BTREE,
  KEY `IDENT_TIERS` (`IDENT_TIERS`) USING BTREE,
  KEY `N_TARIF` (`N_TARIF`) USING BTREE,
  KEY `IDENT_TARIF` (`IDENT_TARIF`) USING BTREE,
  KEY `DESIGNATION` (`DESIGNATION`) USING BTREE,
  KEY `HEURE_LIVRAISON` (`HEURE_LIVRAISON`) USING BTREE,
  KEY `CODE_TIERS` (`CODE_TIERS`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_prime_qualite`
--

CREATE TABLE `aide_prime_qualite` (
  `ID_AIDE_PRIME_QUALITE` varchar(32) NOT NULL DEFAULT '',
  `MOTIF` varchar(100) NOT NULL DEFAULT '',
  `NUMERO` double NOT NULL DEFAULT 0,
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_PRIME_QUALITE`),
  KEY `MOTIF` (`MOTIF`) USING BTREE,
  KEY `NUMERO` (`NUMERO`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_primes`
--

CREATE TABLE `aide_primes` (
  `ANNEE` double NOT NULL DEFAULT 0,
  `DATE_APPLICATION` date DEFAULT NULL,
  `DIMANCHE_MATIN` double NOT NULL DEFAULT 0,
  `DIMANCHE_SOIR` double NOT NULL DEFAULT 0,
  `DIMANCHE_TRAVAILLE` double NOT NULL DEFAULT 0,
  `ID_AIDE_PRIMES` varchar(32) NOT NULL DEFAULT '',
  `JOURNALIERE` double NOT NULL DEFAULT 0,
  `JOUR_FERIE` double NOT NULL DEFAULT 0,
  `JOUR_FORMATION` double NOT NULL DEFAULT 0,
  `N_DOSSIER` double NOT NULL DEFAULT 0,
  `QUALITE` double NOT NULL DEFAULT 0,
  `REMPLACEMENT` double NOT NULL DEFAULT 0,
  `SAMEDI_TRAVAILLE` double NOT NULL DEFAULT 0,
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `VENDREDI_SOIR` double NOT NULL DEFAULT 0,
  PRIMARY KEY (`ID_AIDE_PRIMES`),
  KEY `ANNEE` (`ANNEE`) USING BTREE,
  KEY `DATE_APPLICATION` (`DATE_APPLICATION`) USING BTREE,
  KEY `DIMANCHE_MATIN` (`DIMANCHE_MATIN`) USING BTREE,
  KEY `DIMANCHE_SOIR` (`DIMANCHE_SOIR`) USING BTREE,
  KEY `DIMANCHE_TRAVAILLE` (`DIMANCHE_TRAVAILLE`) USING BTREE,
  KEY `JOURNALIERE` (`JOURNALIERE`) USING BTREE,
  KEY `JOUR_FERIE` (`JOUR_FERIE`) USING BTREE,
  KEY `JOUR_FORMATION` (`JOUR_FORMATION`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `QUALITE` (`QUALITE`) USING BTREE,
  KEY `REMPLACEMENT` (`REMPLACEMENT`) USING BTREE,
  KEY `SAMEDI_TRAVAILLE` (`SAMEDI_TRAVAILLE`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `VENDREDI_SOIR` (`VENDREDI_SOIR`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_remise`
--

CREATE TABLE `aide_remise` (
  `ID_AIDE_REMISE` varchar(32) NOT NULL DEFAULT '',
  `NOM` varchar(20) NOT NULL DEFAULT '',
  `NOM_DOSSER` varchar(20) NOT NULL DEFAULT '',
  `NUMERO` double NOT NULL DEFAULT 0,
  `N_DOSSIER` double NOT NULL DEFAULT 0,
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_REMISE`),
  KEY `NOM` (`NOM`) USING BTREE,
  KEY `NOM_DOSSER` (`NOM_DOSSER`) USING BTREE,
  KEY `NUMERO` (`NUMERO`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_salarie_motif_depart`
--

CREATE TABLE `aide_salarie_motif_depart` (
  `ID_AIDE_SALARIE_MOTIF_DEPART` varchar(32) NOT NULL DEFAULT '',
  `MOTIF` varchar(40) NOT NULL DEFAULT '',
  `NUMERO` double NOT NULL DEFAULT 0,
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_SALARIE_MOTIF_DEPART`),
  KEY `MOTIF` (`MOTIF`) USING BTREE,
  KEY `NUMERO` (`NUMERO`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_secteur_activite`
--

CREATE TABLE `aide_secteur_activite` (
  `ID_AIDE_SECTEUR_ACTIVITE` varchar(32) NOT NULL DEFAULT '',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `CODE_NAF` varchar(1000) NOT NULL DEFAULT '',
  `SECTEUR_ACTIVITE` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_SECTEUR_ACTIVITE`),
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `CODE_NAF` (`CODE_NAF`) USING BTREE,
  KEY `SECTEUR_ACTIVITE` (`SECTEUR_ACTIVITE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_situation_famille`
--

CREATE TABLE `aide_situation_famille` (
  `ID_AIDE_SITUATION_FAMILLE` varchar(32) NOT NULL DEFAULT '',
  `NUMERO` double NOT NULL DEFAULT 0,
  `SITUATION` varchar(40) NOT NULL DEFAULT '',
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_SITUATION_FAMILLE`),
  KEY `NUMERO` (`NUMERO`) USING BTREE,
  KEY `SITUATION` (`SITUATION`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_societe_commune`
--

CREATE TABLE `aide_societe_commune` (
  `CODE_POSTAL` varchar(6) NOT NULL DEFAULT '',
  `COMMUNE` varchar(45) NOT NULL DEFAULT '',
  `ID_AIDE_SOCIETE_COMMUNE` varchar(32) NOT NULL DEFAULT '',
  `INSEE` varchar(6) NOT NULL DEFAULT '',
  `LIB_DEPARTEMENT` varchar(35) NOT NULL DEFAULT '',
  `NUM_DEPARTEMENT` varchar(3) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_SOCIETE_COMMUNE`),
  KEY `COMMUNE` (`COMMUNE`) USING BTREE,
  KEY `INSEE` (`INSEE`) USING BTREE,
  KEY `NUM_DEPARTEMENT` (`NUM_DEPARTEMENT`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_societe_naf`
--

CREATE TABLE `aide_societe_naf` (
  `CODE` varchar(10) NOT NULL DEFAULT '',
  `ID_AIDE_SOCIETE_NAF` varchar(32) NOT NULL DEFAULT '',
  `LIBELLE` varchar(200) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_SOCIETE_NAF`),
  KEY `CODE` (`CODE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_societe_pays`
--

CREATE TABLE `aide_societe_pays` (
  `CONTINENT` varchar(25) NOT NULL DEFAULT '',
  `ID_AIDE_SOCIETE_PAYS` varchar(32) NOT NULL DEFAULT '',
  `INDICATIF_TEL` varchar(10) NOT NULL DEFAULT '',
  `LATITUDE` double NOT NULL DEFAULT 0,
  `LONGITUDE` double NOT NULL DEFAULT 0,
  `NOM_PAYS` varchar(43) NOT NULL DEFAULT '',
  `NOM_PAYS_MAJ` varchar(43) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_SOCIETE_PAYS`),
  KEY `NOM_PAYS_MAJ` (`NOM_PAYS_MAJ`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_spanco_avancement`
--

CREATE TABLE `aide_spanco_avancement` (
  `AVANCEMENT` varchar(30) NOT NULL DEFAULT '',
  `ID_AIDE_SPANCO_AVANCEMENT` varchar(32) NOT NULL DEFAULT '',
  `LS` double NOT NULL DEFAULT 0,
  `NOM_DOSSIER` varchar(200) NOT NULL DEFAULT '',
  `N_AVANCEMENT` double NOT NULL DEFAULT 0,
  `N_DOSSIER` varchar(10) NOT NULL DEFAULT '',
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_SPANCO_AVANCEMENT`),
  KEY `AVANCEMENT` (`AVANCEMENT`) USING BTREE,
  KEY `LS` (`LS`) USING BTREE,
  KEY `NOM_DOSSIER` (`NOM_DOSSIER`) USING BTREE,
  KEY `N_AVANCEMENT` (`N_AVANCEMENT`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_spanco_confiance`
--

CREATE TABLE `aide_spanco_confiance` (
  `ID_AIDE_SPANCO_CONFIANCE` varchar(32) NOT NULL DEFAULT '',
  `INDICE` double NOT NULL DEFAULT 0,
  `LS` double NOT NULL DEFAULT 0,
  `NOM_DOSSIER` varchar(50) NOT NULL DEFAULT '',
  `NUMERO` double NOT NULL DEFAULT 0,
  `N_DOSSIER` varchar(10) NOT NULL DEFAULT '',
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_SPANCO_CONFIANCE`),
  KEY `INDICE` (`INDICE`) USING BTREE,
  KEY `LS` (`LS`) USING BTREE,
  KEY `NUMERO` (`NUMERO`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `NOM_DOSSIER` (`NOM_DOSSIER`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_spanco_phase`
--

CREATE TABLE `aide_spanco_phase` (
  `ID_AIDE_SPANCO_PHASE` varchar(32) NOT NULL DEFAULT '',
  `LS` double NOT NULL DEFAULT 0,
  `NOM_DOSSIER` varchar(200) NOT NULL DEFAULT '',
  `N_DOSSIER` varchar(10) NOT NULL DEFAULT '',
  `N_DOSSIER_ACTIF` double NOT NULL DEFAULT 0,
  `N_PHASE` double NOT NULL DEFAULT 0,
  `PHASE` varchar(100) NOT NULL DEFAULT '',
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `PHASE_CLIENT` varchar(100) NOT NULL DEFAULT '',
  `ACTIF` char(1) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_SPANCO_PHASE`),
  KEY `LS` (`LS`) USING BTREE,
  KEY `NOM_DOSSIER` (`NOM_DOSSIER`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `N_DOSSIER_ACTIF` (`N_DOSSIER_ACTIF`) USING BTREE,
  KEY `N_PHASE` (`N_PHASE`) USING BTREE,
  KEY `PHASE` (`PHASE`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `ACTIF` (`ACTIF`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_stock_depot`
--

CREATE TABLE `aide_stock_depot` (
  `ADR1` varchar(50) NOT NULL DEFAULT '',
  `ADR2` varchar(50) NOT NULL DEFAULT '',
  `CP` varchar(10) NOT NULL DEFAULT '',
  `ID_AIDE_STOCK_DEPOT` varchar(32) NOT NULL DEFAULT '',
  `NOM_DEPOT` varchar(50) NOT NULL DEFAULT '',
  `NOM_DOSSIER` varchar(50) NOT NULL DEFAULT '',
  `N_DEPOT` double NOT NULL DEFAULT 0,
  `N_DOSSIER` double NOT NULL DEFAULT 0,
  `RS_DEPOT` varchar(50) NOT NULL DEFAULT '',
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TEL` varchar(15) NOT NULL DEFAULT '',
  `VILLE` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_STOCK_DEPOT`),
  KEY `CP` (`CP`) USING BTREE,
  KEY `NOM_DEPOT` (`NOM_DEPOT`) USING BTREE,
  KEY `NOM_DOSSIER` (`NOM_DOSSIER`) USING BTREE,
  KEY `N_DEPOT` (`N_DEPOT`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `RS_DEPOT` (`RS_DEPOT`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `TEL` (`TEL`) USING BTREE,
  KEY `VILLE` (`VILLE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_stock_qualite`
--

CREATE TABLE `aide_stock_qualite` (
  `ID_AIDE_STOCK_QUALITE` varchar(32) NOT NULL DEFAULT '',
  `NOM_DOSSIER` varchar(50) NOT NULL DEFAULT '',
  `N_DOSSIER` double NOT NULL DEFAULT 0,
  `N_QUALITE` double NOT NULL DEFAULT 0,
  `QUALITE` varchar(20) NOT NULL DEFAULT '',
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_STOCK_QUALITE`),
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `N_QUALITE` (`N_QUALITE`) USING BTREE,
  KEY `QUALITE` (`QUALITE`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `NOM_DOSSIER` (`NOM_DOSSIER`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_suivi_commande_phase`
--

CREATE TABLE `aide_suivi_commande_phase` (
  `ID_AIDE_SUIVI_COMMANDE_PHASE` varchar(32) NOT NULL DEFAULT '',
  `LS` double NOT NULL DEFAULT 0,
  `NOM_DOSSIER` varchar(200) NOT NULL DEFAULT '',
  `NUMERO` varchar(10) NOT NULL DEFAULT '',
  `N_DOSSIER` varchar(10) NOT NULL DEFAULT '',
  `PHASE` varchar(100) NOT NULL DEFAULT '',
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_SUIVI_COMMANDE_PHASE`),
  KEY `LS` (`LS`) USING BTREE,
  KEY `NOM_DOSSIER` (`NOM_DOSSIER`) USING BTREE,
  KEY `NUMERO` (`NUMERO`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `PHASE` (`PHASE`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_support_categorie`
--

CREATE TABLE `aide_support_categorie` (
  `ID_AIDE_SUPPORT_CATEGORIE` varchar(32) NOT NULL DEFAULT '',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `CATEGORIE` varchar(30) NOT NULL DEFAULT '',
  `SOUS_CATEGORIE` varchar(50) NOT NULL DEFAULT '',
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  PRIMARY KEY (`ID_AIDE_SUPPORT_CATEGORIE`),
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_support_nature_pb`
--

CREATE TABLE `aide_support_nature_pb` (
  `ID_AIDE_SUPPORT_NATURE_PB` varchar(32) NOT NULL DEFAULT '',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `NATURE` varchar(25) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_SUPPORT_NATURE_PB`),
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_support_prio`
--

CREATE TABLE `aide_support_prio` (
  `ID_AIDE_SUPPORT_PRIO` varchar(32) NOT NULL DEFAULT '',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `PRIORITE` varchar(40) NOT NULL DEFAULT '',
  `N_PRIORITE` varchar(10) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_SUPPORT_PRIO`),
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_support_type_prio`
--

CREATE TABLE `aide_support_type_prio` (
  `ID_AIDE_SUPPORT_TYPE_PRIO` varchar(32) NOT NULL DEFAULT '',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `PRIORITE` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_SUPPORT_TYPE_PRIO`),
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_table_carte_carburant`
--

CREATE TABLE `aide_table_carte_carburant` (
  `ID_AIDE_TABLE_CARTE_CARBURANT` varchar(32) NOT NULL DEFAULT '',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `NUMERO_CARTE` varchar(20) NOT NULL DEFAULT '',
  `CODE` varchar(20) NOT NULL DEFAULT '',
  `VALIDITE` date DEFAULT NULL,
  `N_DOSSIER` double NOT NULL DEFAULT 0,
  `NOM_DOSSIER` varchar(50) NOT NULL DEFAULT '',
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `FOURNISSEUR` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_TABLE_CARTE_CARBURANT`),
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `NUMERO_CARTE` (`NUMERO_CARTE`) USING BTREE,
  KEY `CODE` (`CODE`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `NOM_DOSSIER` (`NOM_DOSSIER`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_taux_horaires`
--

CREATE TABLE `aide_taux_horaires` (
  `ANCIENNETE` double NOT NULL DEFAULT 0,
  `ANNEE` double NOT NULL DEFAULT 0,
  `CATEGORIE` varchar(20) NOT NULL DEFAULT '',
  `CINQ_ANS` double NOT NULL DEFAULT 0,
  `COEFFICIENT` varchar(10) NOT NULL DEFAULT '',
  `CONCAT` varchar(40) NOT NULL DEFAULT '',
  `DATE_APPLICATION` date DEFAULT NULL,
  `DEUX_ANS` double NOT NULL DEFAULT 0,
  `DIX_ANS` double NOT NULL DEFAULT 0,
  `DOUZE_ANS` double NOT NULL DEFAULT 0,
  `EMBAUCHE` double NOT NULL DEFAULT 0,
  `GROUPE` varchar(10) NOT NULL DEFAULT '',
  `ID_AIDE_TAUX_HORAIRES` varchar(32) NOT NULL DEFAULT '',
  `NEUF_ANS` double NOT NULL DEFAULT 0,
  `N_DOSSIER` double NOT NULL DEFAULT 0,
  `QUINZE_ANS` double NOT NULL DEFAULT 0,
  `SIX_ANS` double NOT NULL DEFAULT 0,
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TAUX_HORAIRE` double NOT NULL DEFAULT 0,
  `TROIS_ANS` double NOT NULL DEFAULT 0,
  PRIMARY KEY (`ID_AIDE_TAUX_HORAIRES`),
  KEY `ANCIENNETE` (`ANCIENNETE`) USING BTREE,
  KEY `ANNEE` (`ANNEE`) USING BTREE,
  KEY `CATEGORIE` (`CATEGORIE`) USING BTREE,
  KEY `CINQ_ANS` (`CINQ_ANS`) USING BTREE,
  KEY `COEFFICIENT` (`COEFFICIENT`) USING BTREE,
  KEY `CONCAT` (`CONCAT`) USING BTREE,
  KEY `DATE_APPLICATION` (`DATE_APPLICATION`) USING BTREE,
  KEY `DEUX_ANS` (`DEUX_ANS`) USING BTREE,
  KEY `DIX_ANS` (`DIX_ANS`) USING BTREE,
  KEY `DOUZE_ANS` (`DOUZE_ANS`) USING BTREE,
  KEY `EMBAUCHE` (`EMBAUCHE`) USING BTREE,
  KEY `GROUPE` (`GROUPE`) USING BTREE,
  KEY `NEUF_ANS` (`NEUF_ANS`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `QUINZE_ANS` (`QUINZE_ANS`) USING BTREE,
  KEY `SIX_ANS` (`SIX_ANS`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `TAUX_HORAIRE` (`TAUX_HORAIRE`) USING BTREE,
  KEY `TROIS_ANS` (`TROIS_ANS`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_taux_marge_brute`
--

CREATE TABLE `aide_taux_marge_brute` (
  `ID_AIDE_TAUX_MARGE_BRUTE` varchar(32) NOT NULL DEFAULT '',
  `NOM` varchar(20) NOT NULL DEFAULT '',
  `NOM_DOSSIER` varchar(100) NOT NULL DEFAULT '',
  `NUMERO` double NOT NULL DEFAULT 0,
  `N_DOSSIER` double NOT NULL DEFAULT 0,
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_TAUX_MARGE_BRUTE`),
  KEY `NOM` (`NOM`) USING BTREE,
  KEY `NOM_DOSSIER` (`NOM_DOSSIER`) USING BTREE,
  KEY `NUMERO` (`NUMERO`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_taxe_tva_type`
--

CREATE TABLE `aide_taxe_tva_type` (
  `ID_AIDE_TAXE_TVA_TYPE` varchar(32) NOT NULL DEFAULT '',
  `NUMERO` double NOT NULL DEFAULT 0,
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TYPE` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_TAXE_TVA_TYPE`),
  KEY `NUMERO` (`NUMERO`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `TYPE` (`TYPE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_taxes`
--

CREATE TABLE `aide_taxes` (
  `ID_AIDE_TAXES` varchar(32) NOT NULL DEFAULT '',
  `LIBELLE_TAUX_TVA` varchar(10) NOT NULL DEFAULT '',
  `NOM_COMPTE` varchar(100) NOT NULL DEFAULT '',
  `N_COMPTE` varchar(8) NOT NULL DEFAULT '',
  `N_TAXES` varchar(10) NOT NULL DEFAULT '',
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_N_DE_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TAUX_TVA` double NOT NULL DEFAULT 0,
  `TYPE_TAXE` varchar(1) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_TAXES`),
  KEY `N_COMPTE` (`N_COMPTE`) USING BTREE,
  KEY `N_TAXES` (`N_TAXES`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `TAUX_TVA` (`TAUX_TVA`) USING BTREE,
  KEY `TYPE_TAXE` (`TYPE_TAXE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_taxes_taux`
--

CREATE TABLE `aide_taxes_taux` (
  `ID_AIDE_TAXES_TAUX` varchar(32) NOT NULL DEFAULT '',
  `N_TAUX` double NOT NULL DEFAULT 0,
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TAUX` double NOT NULL DEFAULT 0,
  PRIMARY KEY (`ID_AIDE_TAXES_TAUX`),
  KEY `N_TAUX` (`N_TAUX`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `TAUX` (`TAUX`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_temps_travail_theorique`
--

CREATE TABLE `aide_temps_travail_theorique` (
  `ANNEE` double NOT NULL DEFAULT 0,
  `DATE_APPLICATION` date DEFAULT NULL,
  `HEURES_25` double NOT NULL DEFAULT 0,
  `HEURES_50` double NOT NULL DEFAULT 0,
  `HEURES_NORMALES` double NOT NULL DEFAULT 0,
  `ID_AIDE_TEMPS_TRAVAIL_THEORIQUE` varchar(32) NOT NULL DEFAULT '',
  `N_DOSSIER` double NOT NULL DEFAULT 0,
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_TEMPS_TRAVAIL_THEORIQUE`),
  KEY `ANNEE` (`ANNEE`) USING BTREE,
  KEY `DATE_APPLICATION` (`DATE_APPLICATION`) USING BTREE,
  KEY `HEURES_25` (`HEURES_25`) USING BTREE,
  KEY `HEURES_50` (`HEURES_50`) USING BTREE,
  KEY `HEURES_NORMALES` (`HEURES_NORMALES`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_texte_memo`
--

CREATE TABLE `aide_texte_memo` (
  `FAMILLE` varchar(20) NOT NULL DEFAULT '',
  `ID_AIDE_TEXTE_MEMO` varchar(32) NOT NULL DEFAULT '',
  `MEMO` blob DEFAULT NULL,
  `MEMO_BRUT` blob DEFAULT NULL,
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TITRE_MEMO` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_TEXTE_MEMO`),
  KEY `FAMILLE` (`FAMILLE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_tiers_secteur_activite`
--

CREATE TABLE `aide_tiers_secteur_activite` (
  `ID_AIDE_TIERS_SECTEUR_ACTIVITE` varchar(32) NOT NULL DEFAULT '',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `NOM_SECTEUR` varchar(100) NOT NULL DEFAULT '',
  `NAF` varchar(1000) NOT NULL DEFAULT '',
  `N_DOSSIER` varchar(2) NOT NULL DEFAULT '',
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  PRIMARY KEY (`ID_AIDE_TIERS_SECTEUR_ACTIVITE`),
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `NOM_SECTEUR` (`NOM_SECTEUR`) USING BTREE,
  KEY `NAF` (`NAF`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_titre_document_comptable`
--

CREATE TABLE `aide_titre_document_comptable` (
  `ID_AIDE_TITRE_DOCUMENT_COMPTABLE` varchar(32) NOT NULL DEFAULT '',
  `NOM` varchar(40) NOT NULL DEFAULT '',
  `NUMERO` double NOT NULL DEFAULT 0,
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_TITRE_DOCUMENT_COMPTABLE`),
  KEY `NOM` (`NOM`) USING BTREE,
  KEY `NUMERO` (`NUMERO`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_type_action`
--

CREATE TABLE `aide_type_action` (
  `ID_AIDE_TYPE_ACTION` varchar(32) NOT NULL DEFAULT '',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `TYPE_ACTION` varchar(200) NOT NULL DEFAULT '',
  `FAMILLE` varchar(50) NOT NULL DEFAULT '',
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `N_PHASE` varchar(2) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_TYPE_ACTION`),
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `TYPE_ACTION` (`TYPE_ACTION`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_type_adresse`
--

CREATE TABLE `aide_type_adresse` (
  `ID_AIDE_TYPE_ADRESSE` varchar(32) NOT NULL DEFAULT '',
  `NUMERO` double NOT NULL DEFAULT 0,
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TYPE_ADRESSE` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_TYPE_ADRESSE`),
  KEY `NUMERO` (`NUMERO`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `TYPE_ADRESSE` (`TYPE_ADRESSE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_type_batiment`
--

CREATE TABLE `aide_type_batiment` (
  `ID_AIDE_TYPE_BATIMENT` varchar(32) NOT NULL DEFAULT '',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `NOM_TYPE_BATIMENT` varchar(32) NOT NULL DEFAULT '',
  `NOM_DOSSIER` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_TYPE_BATIMENT`),
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_type_contrat_travail`
--

CREATE TABLE `aide_type_contrat_travail` (
  `ID_AIDE_TYPE_CONTRAT_TRAVAIL` varchar(32) NOT NULL DEFAULT '',
  `NUMERO` double NOT NULL DEFAULT 0,
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TYPE` varchar(40) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_TYPE_CONTRAT_TRAVAIL`),
  KEY `NUMERO` (`NUMERO`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `TYPE` (`TYPE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_type_document_rh`
--

CREATE TABLE `aide_type_document_rh` (
  `ID_AIDE_TYPE_DOCUMENT_RH` varchar(32) NOT NULL DEFAULT '',
  `INTITULE` varchar(40) NOT NULL DEFAULT '',
  `NUMERO` double NOT NULL DEFAULT 0,
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_TYPE_DOCUMENT_RH`),
  KEY `INTITULE` (`INTITULE`) USING BTREE,
  KEY `NUMERO` (`NUMERO`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_type_ecriture_sitation`
--

CREATE TABLE `aide_type_ecriture_sitation` (
  `ID_AIDE_TYPE_ECRITURE_SITATION` varchar(32) NOT NULL DEFAULT '',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `N_TYPE_ECRITURE_SITUATION` decimal(12,0) NOT NULL DEFAULT 0,
  `TYPE_ECRTITURE_SITAUTION` varchar(40) NOT NULL DEFAULT '',
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  PRIMARY KEY (`ID_AIDE_TYPE_ECRITURE_SITATION`),
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `N_TYPE_ECRITURE_SITUATION` (`N_TYPE_ECRITURE_SITUATION`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_type_equipement_securite`
--

CREATE TABLE `aide_type_equipement_securite` (
  `ID_AIDE_TYPE_EQUIPEMENT_SECURITE` varchar(32) NOT NULL DEFAULT '',
  `NOM_DOSSIER` varchar(50) NOT NULL DEFAULT '',
  `N_DOSSIER` double NOT NULL DEFAULT 0,
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TYPE` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_TYPE_EQUIPEMENT_SECURITE`),
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `NOM_DOSSIER` (`NOM_DOSSIER`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_type_financement`
--

CREATE TABLE `aide_type_financement` (
  `ID_AIDE_TYPE_FINANCEMENT` varchar(32) NOT NULL DEFAULT '',
  `NUMERO` double NOT NULL DEFAULT 0,
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TYPE_FINANCEMENT` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_TYPE_FINANCEMENT`),
  KEY `NUMERO` (`NUMERO`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `TYPE_FINANCEMENT` (`TYPE_FINANCEMENT`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_type_groupe_user`
--

CREATE TABLE `aide_type_groupe_user` (
  `GROUP_USER` varchar(10) NOT NULL DEFAULT '',
  `ID_AIDE_TYPE_GROUPE_USER` varchar(32) NOT NULL DEFAULT '',
  `NOM_GROUPE` varchar(20) NOT NULL DEFAULT '',
  `N_GROUPE_USER` double NOT NULL DEFAULT 0,
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_TYPE_GROUPE_USER`),
  KEY `GROUP_USER` (`GROUP_USER`) USING BTREE,
  KEY `N_GROUPE_USER` (`N_GROUPE_USER`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_type_moteur_vehicule`
--

CREATE TABLE `aide_type_moteur_vehicule` (
  `ID_AIDE_TYPE_MOTEUR_VEHICULE` varchar(32) NOT NULL DEFAULT '',
  `N_TYPE_MOTEUR` varchar(2) NOT NULL DEFAULT '',
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TYPE_MOTEUR` varchar(32) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_TYPE_MOTEUR_VEHICULE`),
  KEY `N_TYPE_MOTEUR` (`N_TYPE_MOTEUR`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_type_ordre_reparation`
--

CREATE TABLE `aide_type_ordre_reparation` (
  `ID_AIDE_TYPE_ORDRE_REPARATION` varchar(32) NOT NULL DEFAULT '',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `TYPE_OR` varchar(40) NOT NULL DEFAULT '',
  `NUMERO` double NOT NULL DEFAULT 0,
  `N_DOSSIER` double NOT NULL DEFAULT 0,
  `NOM_DOSSIER` varchar(50) NOT NULL DEFAULT '',
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  PRIMARY KEY (`ID_AIDE_TYPE_ORDRE_REPARATION`),
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `TYPE_OR` (`TYPE_OR`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `NOM_DOSSIER` (`NOM_DOSSIER`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_type_rdvs_rh`
--

CREATE TABLE `aide_type_rdvs_rh` (
  `FREQUENCE_ANNUELLE` varchar(10) NOT NULL DEFAULT '',
  `ID_AIDE_TYPE_RDVS_RH` varchar(32) NOT NULL DEFAULT '',
  `NUMERO` double NOT NULL DEFAULT 0,
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TYPE` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_TYPE_RDVS_RH`),
  KEY `FREQUENCE_ANNUELLE` (`FREQUENCE_ANNUELLE`) USING BTREE,
  KEY `NUMERO` (`NUMERO`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `TYPE` (`TYPE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_type_reglement`
--

CREATE TABLE `aide_type_reglement` (
  `ID_AIDE_TYPE_REGLEMENT` varchar(32) NOT NULL DEFAULT '',
  `LIBELLE` varchar(20) NOT NULL DEFAULT '',
  `N_FICHE` double NOT NULL DEFAULT 0,
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `VISIBLE_RGT` char(1) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_TYPE_REGLEMENT`),
  KEY `LIBELLE` (`LIBELLE`) USING BTREE,
  KEY `N_FICHE` (`N_FICHE`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `VISIBLE_RGT` (`VISIBLE_RGT`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_type_reglement_client`
--

CREATE TABLE `aide_type_reglement_client` (
  `IDENTIFICATION_SUIVI_COMMANDE` varchar(32) NOT NULL DEFAULT '',
  `ID_AIDE_TYPE_REGLEMENT_CLIENT` varchar(32) NOT NULL DEFAULT '',
  `NOM_CLIENT` varchar(50) NOT NULL DEFAULT '',
  `NUMERO` double NOT NULL DEFAULT 0,
  `N_DOSSIER` double NOT NULL DEFAULT 0,
  `PHASE` varchar(20) NOT NULL DEFAULT '',
  `POURCENTAGE` double NOT NULL DEFAULT 0,
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_LIEN_CONTEXTE_MAITRE` varchar(32) NOT NULL DEFAULT '',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TOTAL_TTC` double NOT NULL DEFAULT 0,
  PRIMARY KEY (`ID_AIDE_TYPE_REGLEMENT_CLIENT`),
  KEY `IDENTIFICATION_SUIVI_COMMANDE` (`IDENTIFICATION_SUIVI_COMMANDE`) USING BTREE,
  KEY `NOM_CLIENT` (`NOM_CLIENT`) USING BTREE,
  KEY `NUMERO` (`NUMERO`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `POURCENTAGE` (`POURCENTAGE`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_LIEN_CONTEXTE_MAITRE` (`SYS_LIEN_CONTEXTE_MAITRE`) USING BTREE,
  KEY `SYS_NO_LIGNE` (`SYS_NO_LIGNE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_visite_periodique_batiment`
--

CREATE TABLE `aide_visite_periodique_batiment` (
  `ID_AIDE_VISITE_PERIODIQUE_BATIMENT` varchar(32) NOT NULL DEFAULT '',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `FAMILLE` varchar(50) NOT NULL DEFAULT '',
  `NOM` varchar(50) NOT NULL DEFAULT '',
  `DELAIS_PREVENANCE` double NOT NULL DEFAULT 0,
  `DUREE` double NOT NULL DEFAULT 0,
  `DOSSIERS` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_VISITE_PERIODIQUE_BATIMENT`),
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `FAMILLE` (`FAMILLE`) USING BTREE,
  KEY `NOM` (`NOM`) USING BTREE,
  KEY `DOSSIERS` (`DOSSIERS`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_visite_periodique_batiment_famille`
--

CREATE TABLE `aide_visite_periodique_batiment_famille` (
  `ID_AIDE_VISITE_PERIODIQUE_BATIMENT_FAMILLE` varchar(32) NOT NULL DEFAULT '',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `NOM` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AIDE_VISITE_PERIODIQUE_BATIMENT_FAMILLE`),
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `aide_visites_perio`
--

CREATE TABLE `aide_visites_perio` (
  `ID_AIDE_VISITES_PERIO` varchar(32) NOT NULL DEFAULT '',
  `LIBELE_VISITE` varchar(50) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `DELAI` decimal(12,0) NOT NULL DEFAULT 0,
  `DELAI_PREVENANCE` decimal(12,0) NOT NULL DEFAULT 0,
  `NUMERO` decimal(12,0) NOT NULL DEFAULT 0,
  PRIMARY KEY (`ID_AIDE_VISITES_PERIO`),
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `LIBELE_VISITE` (`LIBELE_VISITE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `alerte_message`
--

CREATE TABLE `alerte_message` (
  `DATE` date DEFAULT NULL,
  `IDENTIFICATION_TIERS` varchar(32) NOT NULL DEFAULT '',
  `ID_ALERTE_MESSAGE` varchar(32) NOT NULL DEFAULT '',
  `IMMAT` varchar(10) NOT NULL DEFAULT '',
  `KM` decimal(12,0) NOT NULL DEFAULT 0,
  `MESSAGE` blob DEFAULT NULL,
  `NOM` varchar(50) NOT NULL DEFAULT '',
  `NOM_DOSSIER` varchar(50) NOT NULL DEFAULT '',
  `N_DOSSIER` decimal(12,0) NOT NULL DEFAULT 0,
  `PRENOM` varchar(50) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `PID_MATERIEL_ET` varchar(32) NOT NULL DEFAULT '',
  `SELECTION_ENVOIE_GROUPE` char(1) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_ALERTE_MESSAGE`),
  KEY `IDENTIFICATION_TIERS` (`IDENTIFICATION_TIERS`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `PID_MATERIEL_ET` (`PID_MATERIEL_ET`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `amort_facture`
--

CREATE TABLE `amort_facture` (
  `DATE_FACTURE` date DEFAULT NULL,
  `FOURNISSEUR` varchar(20) NOT NULL DEFAULT '',
  `IDENT_AMORT` varchar(32) NOT NULL DEFAULT '',
  `ID_AMORT_FACTURE` varchar(32) NOT NULL DEFAULT '',
  `MONTANT_HT` double NOT NULL DEFAULT 0,
  `N_FACTURE` varchar(10) NOT NULL DEFAULT '',
  `PID_AMORT_ET` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_AMORT_FACTURE`),
  KEY `DATE_FACTURE` (`DATE_FACTURE`) USING BTREE,
  KEY `IDENT_AMORT` (`IDENT_AMORT`) USING BTREE,
  KEY `N_FACTURE` (`N_FACTURE`) USING BTREE,
  KEY `PID_AMORT_ET` (`PID_AMORT_ET`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `article`
--

CREATE TABLE `article` (
  `A_COMMANDER` char(1) NOT NULL DEFAULT '',
  `CODE` varchar(25) NOT NULL DEFAULT '',
  `COMMANDE_ENCOURS` char(1) NOT NULL DEFAULT '',
  `CONDITIONNEMENT` varchar(20) NOT NULL DEFAULT '',
  `COULEUR` varchar(20) NOT NULL DEFAULT '',
  `DESCRIPTIF` blob DEFAULT NULL,
  `DESIGNATION` varchar(50) NOT NULL DEFAULT '',
  `FAMILLE` varchar(50) NOT NULL DEFAULT '',
  `FOURNISSEUR` varchar(100) NOT NULL DEFAULT '',
  `IDENT_FOURNISSEUR` varchar(32) NOT NULL DEFAULT '',
  `ID_ARTICLE` varchar(32) NOT NULL DEFAULT '',
  `NOM_CATALOGUE` varchar(50) NOT NULL DEFAULT '',
  `NOM_DOSSIER` varchar(100) NOT NULL DEFAULT '',
  `N_DOSSIER` double NOT NULL DEFAULT 0,
  `Q_CONDITIONNEMENT` double NOT NULL DEFAULT 0,
  `Q_MVT` double NOT NULL DEFAULT 0,
  `REFERENCE` varchar(30) NOT NULL DEFAULT '',
  `REF_PHOTO` varchar(200) NOT NULL DEFAULT '',
  `STOCK` char(1) NOT NULL DEFAULT '',
  `STOCK_METHODE` varchar(10) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TX_MB` double NOT NULL DEFAULT 0,
  `UNITE_FAC` varchar(10) NOT NULL DEFAULT '',
  `VERROU_REF` char(1) NOT NULL DEFAULT '',
  `DATE_DEPART_STOCK` date DEFAULT NULL,
  `MARGE_HT` double NOT NULL DEFAULT 0,
  `PRIX_ACHAT_HT` double NOT NULL DEFAULT 0,
  `PRIX_VENTE_HT` double NOT NULL DEFAULT 0,
  `QUALITE_STOCK` varchar(20) NOT NULL DEFAULT '',
  `Q_STOCK_MINI` double NOT NULL DEFAULT 0,
  `NOM_CPTE_GENERAL_ACHAT` varchar(100) NOT NULL DEFAULT '',
  `NOM_CPTE_GENERAL_VENTE` varchar(100) NOT NULL DEFAULT '',
  `N_CPTE_GENERAL_ACHAT` varchar(10) NOT NULL DEFAULT '',
  `N_CPTE_GENERAL_VENTE` varchar(10) NOT NULL DEFAULT '',
  `PID_AIDE_ARTICLE_FAMILLE` varchar(32) NOT NULL DEFAULT '',
  `CODE_ATELIER` varchar(10) NOT NULL DEFAULT '',
  `COCHE` char(1) NOT NULL DEFAULT '',
  `COMMENTAIRES` blob DEFAULT NULL,
  `NOM_CPTE_GENERAL_ACHAT_GROUPE` varchar(100) NOT NULL DEFAULT '',
  `N_CPTE_GENERAL_ACHAT_GROUPE` varchar(10) NOT NULL DEFAULT '',
  `A_SUPPRIMER` char(1) NOT NULL DEFAULT '',
  `NOM_COMPTE_GENERAL_ACHAT_GROUPE` varchar(100) NOT NULL DEFAULT '',
  `ANALYTIQUE` char(1) NOT NULL DEFAULT '',
  `ANS1` double NOT NULL DEFAULT 0,
  `ANS10` double NOT NULL DEFAULT 0,
  `ANS11` double NOT NULL DEFAULT 0,
  `ANS12` double NOT NULL DEFAULT 0,
  `ANS13` double NOT NULL DEFAULT 0,
  `ANS14` double NOT NULL DEFAULT 0,
  `ANS15` double NOT NULL DEFAULT 0,
  `ANS16` double NOT NULL DEFAULT 0,
  `ANS17` double NOT NULL DEFAULT 0,
  `ANS18` double NOT NULL DEFAULT 0,
  `ANS19` double NOT NULL DEFAULT 0,
  `ANS2` double NOT NULL DEFAULT 0,
  `ANS20` double NOT NULL DEFAULT 0,
  `ANS3` double NOT NULL DEFAULT 0,
  `ANS4` double NOT NULL DEFAULT 0,
  `ANS5` double NOT NULL DEFAULT 0,
  `ANS6` double NOT NULL DEFAULT 0,
  `ANS7` double NOT NULL DEFAULT 0,
  `ANS8` double NOT NULL DEFAULT 0,
  `ANS9` double NOT NULL DEFAULT 0,
  `ETAGERE` varchar(10) NOT NULL DEFAULT '',
  `ETAGERE_L` varchar(10) NOT NULL DEFAULT '',
  `RAYON` varchar(10) NOT NULL DEFAULT '',
  `RAYON_L` varchar(10) NOT NULL DEFAULT '',
  `REF_SIMILAIRE` varchar(20) NOT NULL DEFAULT '',
  `REF_SUBSTITUTION` varchar(20) NOT NULL DEFAULT '',
  `_` varchar(20) NOT NULL DEFAULT '',
  `FACTURE_POIDS` char(1) NOT NULL DEFAULT '',
  `PRIX_HT_KILO` double NOT NULL DEFAULT 0,
  `POIDS_GR` double NOT NULL DEFAULT 0,
  `FORM_WEB` char(1) NOT NULL DEFAULT '',
  `N_CPTE_BILAN` varchar(10) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_ARTICLE`),
  KEY `A_COMMANDER` (`A_COMMANDER`) USING BTREE,
  KEY `CODE` (`CODE`) USING BTREE,
  KEY `COMMANDE_ENCOURS` (`COMMANDE_ENCOURS`) USING BTREE,
  KEY `IDENT_FOURNISSEUR` (`IDENT_FOURNISSEUR`) USING BTREE,
  KEY `NOM_DOSSIER` (`NOM_DOSSIER`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `Q_CONDITIONNEMENT` (`Q_CONDITIONNEMENT`) USING BTREE,
  KEY `REFERENCE` (`REFERENCE`) USING BTREE,
  KEY `STOCK` (`STOCK`) USING BTREE,
  KEY `STOCK_METHODE` (`STOCK_METHODE`) USING BTREE,
  KEY `TX_MB` (`TX_MB`) USING BTREE,
  KEY `VERROU_REF` (`VERROU_REF`) USING BTREE,
  KEY `DATE_DEPART_STOCK` (`DATE_DEPART_STOCK`) USING BTREE,
  KEY `QUALITE_STOCK` (`QUALITE_STOCK`) USING BTREE,
  KEY `N_CPTE_GENERAL_ACHAT` (`N_CPTE_GENERAL_ACHAT`) USING BTREE,
  KEY `N_CPTE_GENERAL_VENTE` (`N_CPTE_GENERAL_VENTE`) USING BTREE,
  KEY `PID_AIDE_ARTICLE_FAMILLE` (`PID_AIDE_ARTICLE_FAMILLE`) USING BTREE,
  KEY `DESIGNATION` (`DESIGNATION`) USING BTREE,
  KEY `A_SUPPRIMER` (`A_SUPPRIMER`) USING BTREE,
  KEY `FORM_WEB` (`FORM_WEB`) USING BTREE,
  KEY `ETAGERE` (`ETAGERE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `article_depot`
--

CREATE TABLE `article_depot` (
  `IDENT_BLHA_ORIGINE` varchar(32) NOT NULL DEFAULT '',
  `IDENT_BL_FACTHA_ORIGINE` varchar(32) NOT NULL DEFAULT '',
  `IDENT_BL_FACTVTES_ORIGINE` varchar(32) NOT NULL DEFAULT '',
  `IDENT_BL_VTES_ORIGINE` varchar(32) NOT NULL DEFAULT '',
  `ID_ARTICLE_DEPOT` varchar(32) NOT NULL DEFAULT '',
  `NOM_DEPOT` varchar(20) NOT NULL DEFAULT '',
  `PID_ARTICLE` varchar(32) NOT NULL DEFAULT '',
  `PID_STOCK` varchar(32) NOT NULL DEFAULT '',
  `PRIX_ACHAT_UNITAIRE` double NOT NULL DEFAULT 0,
  `PRIX_TOTAL` double NOT NULL DEFAULT 0,
  `QUANTITE` double NOT NULL DEFAULT 0,
  `QUANTITE_SORTIE` double NOT NULL DEFAULT 0,
  `SOLDE` double NOT NULL DEFAULT 0,
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_ARTICLE_DEPOT`),
  KEY `IDENT_BLHA_ORIGINE` (`IDENT_BLHA_ORIGINE`) USING BTREE,
  KEY `IDENT_BL_FACTHA_ORIGINE` (`IDENT_BL_FACTHA_ORIGINE`) USING BTREE,
  KEY `IDENT_BL_FACTVTES_ORIGINE` (`IDENT_BL_FACTVTES_ORIGINE`) USING BTREE,
  KEY `IDENT_BL_VTES_ORIGINE` (`IDENT_BL_VTES_ORIGINE`) USING BTREE,
  KEY `NOM_DEPOT` (`NOM_DEPOT`) USING BTREE,
  KEY `PID_ARTICLE` (`PID_ARTICLE`) USING BTREE,
  KEY `PID_STOCK` (`PID_STOCK`) USING BTREE,
  KEY `PRIX_ACHAT_UNITAIRE` (`PRIX_ACHAT_UNITAIRE`) USING BTREE,
  KEY `PRIX_TOTAL` (`PRIX_TOTAL`) USING BTREE,
  KEY `QUANTITE` (`QUANTITE`) USING BTREE,
  KEY `QUANTITE_SORTIE` (`QUANTITE_SORTIE`) USING BTREE,
  KEY `SOLDE` (`SOLDE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `batiment_et`
--

CREATE TABLE `batiment_et` (
  `ID_BATIMENT_ET` varchar(32) NOT NULL DEFAULT '',
  `PID_AIDE_CONFIGURATION_ENTREPRISE` varchar(32) NOT NULL DEFAULT '',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `N_DOSSIER` varchar(2) NOT NULL DEFAULT '',
  `NOM_DOSSIER` varchar(20) NOT NULL DEFAULT '',
  `TYPE_BATIMENT` varchar(32) NOT NULL DEFAULT '',
  `PID_CONTRAT` varchar(32) NOT NULL DEFAULT '',
  `INTITULE_BATIMENT` varchar(100) NOT NULL DEFAULT '',
  `N_BATIMENT` varchar(10) NOT NULL DEFAULT '',
  `HAUTEUR_BATIMENT_SOUS_PLAFOND` decimal(12,0) NOT NULL DEFAULT 0,
  `LARGEUR_BATIMENT` decimal(12,0) NOT NULL DEFAULT 0,
  `ADRESSE` varchar(200) NOT NULL DEFAULT '',
  `PROPRIETAIRE` varchar(50) NOT NULL DEFAULT '',
  `CLASSIFICATION` longblob DEFAULT NULL,
  PRIMARY KEY (`ID_BATIMENT_ET`),
  KEY `PID_AIDE_CONFIGURATION_ENTREPRISE` (`PID_AIDE_CONFIGURATION_ENTREPRISE`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `NOM_DOSSIER` (`NOM_DOSSIER`) USING BTREE,
  KEY `PID_CONTRAT` (`PID_CONTRAT`) USING BTREE,
  KEY `N_BATIMENT` (`N_BATIMENT`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `bible_mail`
--

CREATE TABLE `bible_mail` (
  `COURRIER` char(1) NOT NULL DEFAULT '',
  `FAMILLE` varchar(40) NOT NULL DEFAULT '',
  `ID_BIBLE_MAIL` varchar(32) NOT NULL DEFAULT '',
  `MAIL` char(1) NOT NULL DEFAULT '',
  `NOM` varchar(50) NOT NULL DEFAULT '',
  `NUMERO` double NOT NULL DEFAULT 0,
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TEXTE` blob DEFAULT NULL,
  `FAMILLE_EGP` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_BIBLE_MAIL`),
  KEY `COURRIER` (`COURRIER`) USING BTREE,
  KEY `FAMILLE` (`FAMILLE`) USING BTREE,
  KEY `MAIL` (`MAIL`) USING BTREE,
  KEY `NOM` (`NOM`) USING BTREE,
  KEY `NUMERO` (`NUMERO`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `FAMILLE_EGP` (`FAMILLE_EGP`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `boite_a_outils_egp`
--

CREATE TABLE `boite_a_outils_egp` (
  `ID_BOITE_A_OUTILS_EGP` varchar(32) NOT NULL DEFAULT '',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `N_OUTIL` double NOT NULL DEFAULT 0,
  `CAT_OUTIL` varchar(32) NOT NULL DEFAULT '',
  `DESCRIPTION` blob DEFAULT NULL,
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `NOM` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_BOITE_A_OUTILS_EGP`),
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `N_OUTIL` (`N_OUTIL`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `budget_det`
--

CREATE TABLE `budget_det` (
  `AJUSTEMENT_MANUEL` char(1) NOT NULL DEFAULT '',
  `DATE` date DEFAULT NULL,
  `ID_BUDGET_DET` varchar(32) NOT NULL DEFAULT '',
  `M10_B` double NOT NULL DEFAULT 0,
  `M10_P` decimal(12,2) NOT NULL DEFAULT 0.00,
  `M10_P1` double NOT NULL DEFAULT 0,
  `M10_V` double NOT NULL DEFAULT 0,
  `M11_B` double NOT NULL DEFAULT 0,
  `M11_P` decimal(12,2) NOT NULL DEFAULT 0.00,
  `M11_P1` double NOT NULL DEFAULT 0,
  `M11_V` double NOT NULL DEFAULT 0,
  `M12_B` double NOT NULL DEFAULT 0,
  `M12_P` decimal(12,2) NOT NULL DEFAULT 0.00,
  `M12_P1` double NOT NULL DEFAULT 0,
  `M12_V` double NOT NULL DEFAULT 0,
  `M1_B` double NOT NULL DEFAULT 0,
  `M1_P` decimal(12,2) NOT NULL DEFAULT 0.00,
  `M1_P1` double NOT NULL DEFAULT 0,
  `M1_V` double NOT NULL DEFAULT 0,
  `M2_B` double NOT NULL DEFAULT 0,
  `M2_P` decimal(12,2) NOT NULL DEFAULT 0.00,
  `M2_P1` double NOT NULL DEFAULT 0,
  `M2_V` double NOT NULL DEFAULT 0,
  `M3_B` double NOT NULL DEFAULT 0,
  `M3_P` decimal(12,2) NOT NULL DEFAULT 0.00,
  `M3_P1` double NOT NULL DEFAULT 0,
  `M3_V` double NOT NULL DEFAULT 0,
  `M4_B` double NOT NULL DEFAULT 0,
  `M4_P` decimal(12,2) NOT NULL DEFAULT 0.00,
  `M4_P1` double NOT NULL DEFAULT 0,
  `M4_V` double NOT NULL DEFAULT 0,
  `M5_B` double NOT NULL DEFAULT 0,
  `M5_P` decimal(12,2) NOT NULL DEFAULT 0.00,
  `M5_P1` double NOT NULL DEFAULT 0,
  `M5_V` double NOT NULL DEFAULT 0,
  `M6_B` double NOT NULL DEFAULT 0,
  `M6_P` decimal(12,2) NOT NULL DEFAULT 0.00,
  `M6_P1` double NOT NULL DEFAULT 0,
  `M6_V` double NOT NULL DEFAULT 0,
  `M7_B` double NOT NULL DEFAULT 0,
  `M7_P` decimal(12,2) NOT NULL DEFAULT 0.00,
  `M7_P1` double NOT NULL DEFAULT 0,
  `M7_V` double NOT NULL DEFAULT 0,
  `M8_B` double NOT NULL DEFAULT 0,
  `M8_P` decimal(12,2) NOT NULL DEFAULT 0.00,
  `M8_P1` double NOT NULL DEFAULT 0,
  `M8_V` double NOT NULL DEFAULT 0,
  `M9_B` double NOT NULL DEFAULT 0,
  `M9_P` decimal(12,2) NOT NULL DEFAULT 0.00,
  `M9_P1` double NOT NULL DEFAULT 0,
  `M9_V` double NOT NULL DEFAULT 0,
  `NOM_BUDGET` varchar(50) NOT NULL DEFAULT '',
  `NOM_DOSSIER` varchar(50) NOT NULL DEFAULT '',
  `N_CPTE_GENERAL` varchar(10) NOT NULL DEFAULT '',
  `N_DOSSIER` double NOT NULL DEFAULT 0,
  `N_EX` double NOT NULL DEFAULT 0,
  `N_EXCEL` double NOT NULL DEFAULT 0,
  `N_EX_BUD` double NOT NULL DEFAULT 0,
  `N_EX_REEL` double NOT NULL DEFAULT 0,
  `N_EX_REF` double NOT NULL DEFAULT 0,
  `PID_BUDGET_ET` varchar(32) NOT NULL DEFAULT '',
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `SELECT` varchar(1) NOT NULL DEFAULT '',
  `REGROUPEMENT` varchar(10) NOT NULL DEFAULT '',
  `M_P1_TOTAL` decimal(12,2) NOT NULL DEFAULT 0.00,
  `N_BUDGET` varchar(10) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_BUDGET_DET`),
  KEY `AJUSTEMENT_MANUEL` (`AJUSTEMENT_MANUEL`) USING BTREE,
  KEY `DATE` (`DATE`) USING BTREE,
  KEY `M1_P1` (`M1_P1`) USING BTREE,
  KEY `N_CPTE_GENERAL` (`N_CPTE_GENERAL`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `N_EX` (`N_EX`) USING BTREE,
  KEY `N_EX_REEL` (`N_EX_REEL`) USING BTREE,
  KEY `PID_BUDGET_ET` (`PID_BUDGET_ET`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `REGROUPEMENT` (`REGROUPEMENT`) USING BTREE,
  KEY `N_BUDGET` (`N_BUDGET`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `budget_et`
--

CREATE TABLE `budget_et` (
  `DATE_M_DEBUT` date DEFAULT NULL,
  `ID_BUDGET_ET` varchar(32) NOT NULL DEFAULT '',
  `NOM_BUDGET` varchar(100) NOT NULL DEFAULT '',
  `NOM_DOSSIER` varchar(50) NOT NULL DEFAULT '',
  `N_DOSSIER` double NOT NULL DEFAULT 0,
  `N_DOSSIER_BUD` varchar(10) NOT NULL DEFAULT '',
  `N_EX_BUD` double NOT NULL DEFAULT 0,
  `N_EX_REF` double NOT NULL DEFAULT 0,
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `VARIATION_GLOBALE` decimal(12,2) NOT NULL DEFAULT 0.00,
  `VARIATION_M1` decimal(12,2) NOT NULL DEFAULT 0.00,
  `VARIATION_M2` decimal(12,2) NOT NULL DEFAULT 0.00,
  `VARIATION_M3` decimal(12,2) NOT NULL DEFAULT 0.00,
  `VARIATION_M4` decimal(12,2) NOT NULL DEFAULT 0.00,
  `VARIATION_M5` decimal(12,2) NOT NULL DEFAULT 0.00,
  `VARIATION_M6` decimal(12,2) NOT NULL DEFAULT 0.00,
  `VARIATION_M7` decimal(12,2) NOT NULL DEFAULT 0.00,
  `VARIATION_M8` decimal(12,2) NOT NULL DEFAULT 0.00,
  `VARIATION_M9` decimal(12,2) NOT NULL DEFAULT 0.00,
  `VARIATION_M10` decimal(12,2) NOT NULL DEFAULT 0.00,
  `VARIATION_M11` decimal(12,2) NOT NULL DEFAULT 0.00,
  `VARIATION_M12` decimal(12,2) NOT NULL DEFAULT 0.00,
  `N_CPTE_GENERAL` varchar(12) NOT NULL DEFAULT '',
  `NOM_CPTE_GENERAL` varchar(50) NOT NULL DEFAULT '',
  `AVEC_SITUA` char(1) NOT NULL DEFAULT '',
  `N_BUDGET` varchar(10) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_BUDGET_ET`),
  KEY `N_EX_BUD` (`N_EX_BUD`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `N_BUDGET` (`N_BUDGET`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `caisse`
--

CREATE TABLE `caisse` (
  `ID_CAISSE` varchar(32) NOT NULL DEFAULT '',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `NUMERO_ECRITURE` varchar(10) NOT NULL DEFAULT '',
  `NUMERO_LIGNE_ECRITURE` varchar(10) NOT NULL DEFAULT '',
  `JOURNAL` varchar(10) NOT NULL DEFAULT '',
  `LIBELLE_ECRITURE` varchar(40) NOT NULL DEFAULT '',
  `DATE` date DEFAULT NULL,
  `HEURE` time NOT NULL DEFAULT '00:00:00',
  `N_COMPTE` varchar(10) NOT NULL DEFAULT '',
  `DEBIT_CREDIT` varchar(10) NOT NULL DEFAULT '',
  `DEBIT` double NOT NULL DEFAULT 0,
  `CREDIT` double NOT NULL DEFAULT 0,
  `LIBELLE_LIGNE` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_CAISSE`),
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `NUMERO_ECRITURE` (`NUMERO_ECRITURE`) USING BTREE,
  KEY `NUMERO_LIGNE_ECRITURE` (`NUMERO_LIGNE_ECRITURE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `campagne`
--

CREATE TABLE `campagne` (
  `COURRIER` char(1) NOT NULL DEFAULT '',
  `DATE` date DEFAULT NULL,
  `EMAILING` char(1) NOT NULL DEFAULT '',
  `ID_CAMPAGNE` varchar(32) NOT NULL DEFAULT '',
  `MEMO` blob DEFAULT NULL,
  `NO_CAMPAGNE` varchar(9) NOT NULL DEFAULT '',
  `PHONING` char(1) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TITRE` varchar(100) NOT NULL DEFAULT '',
  `VISITE` char(1) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_CAMPAGNE`),
  KEY `NO_CAMPAGNE` (`NO_CAMPAGNE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `campagne_mkt_det`
--

CREATE TABLE `campagne_mkt_det` (
  `ADRESSE1` varchar(36) NOT NULL DEFAULT '',
  `ADRESSE2` varchar(36) NOT NULL DEFAULT '',
  `ADRESSE3` varchar(36) NOT NULL DEFAULT '',
  `ADRESSE_SPECIFIQUE` char(1) NOT NULL DEFAULT '',
  `CIVILITE` varchar(12) NOT NULL DEFAULT '',
  `CODE_JOURNAL` varchar(10) NOT NULL DEFAULT '',
  `CODE_POSTAL` varchar(9) NOT NULL DEFAULT '',
  `COMPL_RAISON_SOC` varchar(36) NOT NULL DEFAULT '',
  `CREDIT` double NOT NULL DEFAULT 0,
  `DATE_ECHEANCE` date DEFAULT NULL,
  `DATE_FACTURE` date DEFAULT NULL,
  `DEBIT` double NOT NULL DEFAULT 0,
  `EMAIL_CONTACT` varchar(1000) NOT NULL DEFAULT '',
  `EMAIL_SOCIETE` varchar(60) NOT NULL DEFAULT '',
  `FAIT_COURRIER` char(1) NOT NULL DEFAULT '',
  `FAIT_EMAILING` char(1) NOT NULL DEFAULT '',
  `FAIT_PHONING` char(1) NOT NULL DEFAULT '',
  `FAIT_SMS` char(1) NOT NULL DEFAULT '',
  `FAIT_VISITE` char(1) NOT NULL DEFAULT '',
  `FICHIER_ORIGINE` varchar(30) NOT NULL DEFAULT '',
  `FONCTION` varchar(32) NOT NULL DEFAULT '',
  `IDENTIFICATION_COMPTABILIT_DET` varchar(32) NOT NULL DEFAULT '',
  `IDENTIFICATION_TIERS` varchar(32) NOT NULL DEFAULT '',
  `IDENT_CONTACT` varchar(32) NOT NULL DEFAULT '',
  `ID_CAMPAGNE_MKT_DET` varchar(32) NOT NULL DEFAULT '',
  `IMP` varchar(10) NOT NULL DEFAULT '',
  `LIBELLE` varchar(100) NOT NULL DEFAULT '',
  `MEMO` blob DEFAULT NULL,
  `NOM` varchar(36) NOT NULL DEFAULT '',
  `NO_LOT` varchar(13) NOT NULL DEFAULT '',
  `N_COMPTE_TIERS` varchar(100) NOT NULL DEFAULT '',
  `N_DOSSIER` double NOT NULL DEFAULT 0,
  `N_ECRITURE` varchar(15) NOT NULL DEFAULT '',
  `N_PIECE` varchar(15) NOT NULL DEFAULT '',
  `PAYS` varchar(40) NOT NULL DEFAULT '',
  `PID_CAMPAGNE` varchar(32) NOT NULL DEFAULT '',
  `PID_CAMPAGNE_MKT_ET` varchar(32) NOT NULL DEFAULT '',
  `PID_CONTACT` varchar(32) NOT NULL DEFAULT '',
  `PID_IDENTIFICATION` varchar(32) NOT NULL DEFAULT '',
  `PID_LOT` varchar(32) NOT NULL DEFAULT '',
  `PID_SUSPECTS` varchar(32) NOT NULL DEFAULT '',
  `PRENOM` varchar(36) NOT NULL DEFAULT '',
  `RAISON_SOC` varchar(36) NOT NULL DEFAULT '',
  `SERVICE` varchar(20) NOT NULL DEFAULT '',
  `SUIVI_PAR` varchar(20) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TELEPHONE_DIRECT` varchar(20) NOT NULL DEFAULT '',
  `TELEPHONE_MOBILE` varchar(20) NOT NULL DEFAULT '',
  `TELEPHONE_SOCIETE` varchar(20) NOT NULL DEFAULT '',
  `TYPE_ERREUR` varchar(50) NOT NULL DEFAULT '',
  `TYPE_FICHE` varchar(20) NOT NULL DEFAULT '',
  `TYPE_LOT` varchar(15) NOT NULL DEFAULT '',
  `VILLE` varchar(45) NOT NULL DEFAULT '',
  `IMMAT` varchar(10) NOT NULL DEFAULT '',
  `KL_ABO_VTES` varchar(10) NOT NULL DEFAULT '',
  `NOM_DOSSIER` varchar(50) NOT NULL DEFAULT '',
  `SENT` char(1) NOT NULL DEFAULT '',
  `ERR` char(1) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_CAMPAGNE_MKT_DET`),
  KEY `IDENTIFICATION_COMPTABILIT_DET` (`IDENTIFICATION_COMPTABILIT_DET`) USING BTREE,
  KEY `IDENTIFICATION_TIERS` (`IDENTIFICATION_TIERS`) USING BTREE,
  KEY `IDENT_CONTACT` (`IDENT_CONTACT`) USING BTREE,
  KEY `NO_LOT` (`NO_LOT`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `PID_CAMPAGNE` (`PID_CAMPAGNE`) USING BTREE,
  KEY `PID_CAMPAGNE_MKT_ET` (`PID_CAMPAGNE_MKT_ET`) USING BTREE,
  KEY `PID_CONTACT` (`PID_CONTACT`) USING BTREE,
  KEY `PID_IDENTIFICATION` (`PID_IDENTIFICATION`) USING BTREE,
  KEY `PID_LOT` (`PID_LOT`) USING BTREE,
  KEY `PID_SUSPECTS` (`PID_SUSPECTS`) USING BTREE,
  KEY `SUIVI_PAR` (`SUIVI_PAR`) USING BTREE,
  KEY `TYPE_ERREUR` (`TYPE_ERREUR`) USING BTREE,
  KEY `TYPE_LOT` (`TYPE_LOT`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `campagne_mkt_egp_det`
--

CREATE TABLE `campagne_mkt_egp_det` (
  `EMAIL` varchar(50) NOT NULL DEFAULT '',
  `ID_CAMPAGNE_MKT_EGP_DET` varchar(32) NOT NULL DEFAULT '',
  `NOM` varchar(50) NOT NULL DEFAULT '',
  `NOM_CAMPAGNE` varchar(150) NOT NULL DEFAULT '',
  `N_CAMPAGNE` varchar(10) NOT NULL DEFAULT '',
  `PID_CAMPAGNE_MKT_EGP_ET` varchar(32) NOT NULL DEFAULT '',
  `PID_TIERS` varchar(32) NOT NULL DEFAULT '',
  `PRENOM` varchar(150) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `PID_CONTACT` varchar(32) NOT NULL DEFAULT '',
  `N_DOSSIER` double NOT NULL DEFAULT 0,
  `REP_MAIL` char(1) NOT NULL DEFAULT '',
  `N_REP` decimal(12,0) NOT NULL DEFAULT 0,
  `TYPE_TIERS` varchar(100) NOT NULL DEFAULT '',
  `CODE_NAF` varchar(10) NOT NULL DEFAULT '',
  `RAISON_SOCIALE` varchar(100) NOT NULL DEFAULT '',
  `PID_LOT` varchar(32) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_CAMPAGNE_MKT_EGP_DET`),
  KEY `PID_CAMPAGNE_MKT_EGP_ET` (`PID_CAMPAGNE_MKT_EGP_ET`) USING BTREE,
  KEY `PID_TIERS` (`PID_TIERS`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `PID_CONTACT` (`PID_CONTACT`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `N_CAMPAGNE` (`N_CAMPAGNE`) USING BTREE,
  KEY `CODE_NAF` (`CODE_NAF`) USING BTREE,
  KEY `PID_LOT` (`PID_LOT`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `campagne_mkt_egp_et`
--

CREATE TABLE `campagne_mkt_egp_et` (
  `DATE_ENVOI` date DEFAULT NULL,
  `ID_CAMPAGNE_MKT_EGP_ET` varchar(32) NOT NULL DEFAULT '',
  `MAIL_BTN_1` varchar(50) NOT NULL DEFAULT '',
  `MAIL_BTN_2` varchar(50) NOT NULL DEFAULT '',
  `MAIL_BTN_3` varchar(50) NOT NULL DEFAULT '',
  `MAIL_QUESTION` varchar(500) NOT NULL DEFAULT '',
  `MAIL_SUJET` varchar(150) NOT NULL DEFAULT '',
  `NOM_CAMPAGNE` varchar(50) NOT NULL DEFAULT '',
  `N_CAMPAGNE` varchar(10) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `MEMO` longblob DEFAULT NULL,
  `N_DOSSIER` double NOT NULL DEFAULT 0,
  `NB_MAIL` decimal(12,0) NOT NULL DEFAULT 0,
  `NB_REP` decimal(12,0) NOT NULL DEFAULT 0,
  `TX_CONV` decimal(12,2) NOT NULL DEFAULT 0.00,
  `NB_REP1` decimal(12,0) NOT NULL DEFAULT 0,
  `NB_REP2` decimal(12,0) NOT NULL DEFAULT 0,
  `NB_REP3` decimal(12,0) NOT NULL DEFAULT 0,
  `ACCROCHE` varchar(150) NOT NULL DEFAULT '',
  `NO_QUESTION` char(1) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_CAMPAGNE_MKT_EGP_ET`),
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `N_CAMPAGNE` (`N_CAMPAGNE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `campagne_mkt_et`
--

CREATE TABLE `campagne_mkt_et` (
  `CLOTURE` char(1) NOT NULL DEFAULT '',
  `COURRIER` char(1) NOT NULL DEFAULT '',
  `DATE_CLOTURE` date DEFAULT NULL,
  `DATE_CREATION` date DEFAULT NULL,
  `DATE_HEURE` varchar(60) NOT NULL DEFAULT '',
  `EMAILING` char(1) NOT NULL DEFAULT '',
  `FAIT` char(1) NOT NULL DEFAULT '',
  `ID_CAMPAGNE_MKT_ET` varchar(32) NOT NULL DEFAULT '',
  `MEMO` blob DEFAULT NULL,
  `NOMBRE_LIGNE` decimal(12,0) NOT NULL DEFAULT 0,
  `NOMBRE_TIERS` decimal(12,0) NOT NULL DEFAULT 0,
  `NOM_DOSSIER` varchar(50) NOT NULL DEFAULT '',
  `NO_LOT` varchar(10) NOT NULL DEFAULT '',
  `N_CAMPAGNE` varchar(10) NOT NULL DEFAULT '',
  `N_DOSSIER` decimal(12,0) NOT NULL DEFAULT 0,
  `PHONING` char(1) NOT NULL DEFAULT '',
  `PID_CAMPAGNE_MKT_ET` varchar(32) NOT NULL DEFAULT '',
  `SMS` char(1) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TITRE` varchar(100) NOT NULL DEFAULT '',
  `VISITE` char(1) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_CAMPAGNE_MKT_ET`),
  KEY `CLOTURE` (`CLOTURE`) USING BTREE,
  KEY `COURRIER` (`COURRIER`) USING BTREE,
  KEY `DATE_HEURE` (`DATE_HEURE`) USING BTREE,
  KEY `EMAILING` (`EMAILING`) USING BTREE,
  KEY `FAIT` (`FAIT`) USING BTREE,
  KEY `NO_LOT` (`NO_LOT`) USING BTREE,
  KEY `N_CAMPAGNE` (`N_CAMPAGNE`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `PHONING` (`PHONING`) USING BTREE,
  KEY `PID_CAMPAGNE_MKT_ET` (`PID_CAMPAGNE_MKT_ET`) USING BTREE,
  KEY `SMS` (`SMS`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `VISITE` (`VISITE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `cheque_et`
--

CREATE TABLE `cheque_et` (
  `CLOTURE` char(1) NOT NULL DEFAULT '',
  `DATE_HEURE` varchar(60) NOT NULL DEFAULT '',
  `FAIT` varchar(10) NOT NULL DEFAULT '',
  `ID_CHEQUE_ET` varchar(32) NOT NULL DEFAULT '',
  `NOM_DOSSIER` varchar(50) NOT NULL DEFAULT '',
  `NOM_FICHIER_CHEQUE` varchar(200) NOT NULL DEFAULT '',
  `NOM_TRESO_CHEQUE` varchar(10) NOT NULL DEFAULT '',
  `N_CHEQUE` varchar(20) NOT NULL DEFAULT '',
  `N_DOSSIER` double NOT NULL DEFAULT 0,
  `N_LIGNE_REGROUPEMENT` double NOT NULL DEFAULT 0,
  `N_LIGNE_SANS_REGROUPEMENT` double NOT NULL DEFAULT 0,
  `N_TRESO_CHEQUE` double NOT NULL DEFAULT 0,
  `REGROUPEMENT` char(1) NOT NULL DEFAULT '',
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TOTAL_CHEQUE` double NOT NULL DEFAULT 0,
  `TOTAL_CHEQUE_VALIDE` double NOT NULL DEFAULT 0,
  `N_DOSSIER_TRESO` varchar(10) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_CHEQUE_ET`),
  KEY `CLOTURE` (`CLOTURE`) USING BTREE,
  KEY `DATE_HEURE` (`DATE_HEURE`) USING BTREE,
  KEY `FAIT` (`FAIT`) USING BTREE,
  KEY `NOM_DOSSIER` (`NOM_DOSSIER`) USING BTREE,
  KEY `NOM_TRESO_CHEQUE` (`NOM_TRESO_CHEQUE`) USING BTREE,
  KEY `N_CHEQUE` (`N_CHEQUE`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `N_TRESO_CHEQUE` (`N_TRESO_CHEQUE`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `client_douteux_det`
--

CREATE TABLE `client_douteux_det` (
  `A_SOLDER` char(1) NOT NULL DEFAULT '',
  `DATE` date DEFAULT NULL,
  `DATE1` date DEFAULT NULL,
  `DATE_HEURE` varchar(60) NOT NULL DEFAULT '',
  `DEPRECIATION_PERIODE_HT` double NOT NULL DEFAULT 0,
  `DEPRECIATION_SOMME_HT` double NOT NULL DEFAULT 0,
  `DOTATION_TTC` double NOT NULL DEFAULT 0,
  `DU_DEBUT_HT` double NOT NULL DEFAULT 0,
  `DU_DEBUT_TTC` double NOT NULL DEFAULT 0,
  `ENCAISSEMENT_PERIODE_HT` double NOT NULL DEFAULT 0,
  `ENCAISSEMENT_PERIODE_TTC` double NOT NULL DEFAULT 0,
  `ENCAISSMENT_SOMME_HT` double NOT NULL DEFAULT 0,
  `IDENTIFICATION_ECRITURE` varchar(32) NOT NULL DEFAULT '',
  `IDENTIFICATION_TIERS` varchar(32) NOT NULL DEFAULT '',
  `ID_CLIENT_DOUTEUX_DET` varchar(32) NOT NULL DEFAULT '',
  `NOM_DOSSIER` varchar(50) NOT NULL DEFAULT '',
  `N_CPTE_TIERS` varchar(30) NOT NULL DEFAULT '',
  `N_DOSSIER` double NOT NULL DEFAULT 0,
  `N_ECRITURE` varchar(10) NOT NULL DEFAULT '',
  `N_LIGNE` double NOT NULL DEFAULT 0,
  `PERTE_PERIODE_HT` double NOT NULL DEFAULT 0,
  `PERTE_PERIODE_TTC` double NOT NULL DEFAULT 0,
  `PERTE_SOMME_HT` double NOT NULL DEFAULT 0,
  `PID_CLIENT_DOUTEUX_ET` varchar(32) NOT NULL DEFAULT '',
  `PROVISION_NECESSAIRE_TTC` double NOT NULL DEFAULT 0,
  `PROVISION_PERIODE_HT` double NOT NULL DEFAULT 0,
  `PROVISION_SOMME_HT` double NOT NULL DEFAULT 0,
  `PROVISION_SOMME_TTC` double NOT NULL DEFAULT 0,
  `REPRISE_PERIODE_HT` double NOT NULL DEFAULT 0,
  `REPRISE_SOMME_HT` double NOT NULL DEFAULT 0,
  `REPRISE_TTC` double NOT NULL DEFAULT 0,
  `RESTANT_DU_TTC` double NOT NULL DEFAULT 0,
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TVA_A_RECUPERER_PERIODE_HT` double NOT NULL DEFAULT 0,
  `TVA_A_RECUPERER_SOMME_HT` double NOT NULL DEFAULT 0,
  `VERROU` char(1) NOT NULL DEFAULT '',
  `RESTANT_DU_HT` double NOT NULL DEFAULT 0,
  `TAUX_TVA` double NOT NULL DEFAULT 0,
  `TOTAL_PROVISION_TTC` double NOT NULL DEFAULT 0,
  `SOLDE_FIN_EX` double NOT NULL DEFAULT 0,
  `PROVISION_NECESSAIRE_HT` double NOT NULL DEFAULT 0,
  `DOTATION_HT` double NOT NULL DEFAULT 0,
  PRIMARY KEY (`ID_CLIENT_DOUTEUX_DET`),
  KEY `A_SOLDER` (`A_SOLDER`) USING BTREE,
  KEY `DATE` (`DATE`) USING BTREE,
  KEY `DATE_HEURE` (`DATE_HEURE`) USING BTREE,
  KEY `DU_DEBUT_TTC` (`DU_DEBUT_TTC`) USING BTREE,
  KEY `IDENTIFICATION_ECRITURE` (`IDENTIFICATION_ECRITURE`) USING BTREE,
  KEY `IDENTIFICATION_TIERS` (`IDENTIFICATION_TIERS`) USING BTREE,
  KEY `N_CPTE_TIERS` (`N_CPTE_TIERS`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `N_ECRITURE` (`N_ECRITURE`) USING BTREE,
  KEY `N_LIGNE` (`N_LIGNE`) USING BTREE,
  KEY `PID_CLIENT_DOUTEUX_ET` (`PID_CLIENT_DOUTEUX_ET`) USING BTREE,
  KEY `RESTANT_DU_TTC` (`RESTANT_DU_TTC`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `NOM_DOSSIER` (`NOM_DOSSIER`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `client_douteux_et`
--

CREATE TABLE `client_douteux_et` (
  `A_SOLDER` char(1) NOT NULL DEFAULT '',
  `DATE_ECRITURE` date DEFAULT NULL,
  `DOTATIONS` double NOT NULL DEFAULT 0,
  `ENCAISS_HT` double NOT NULL DEFAULT 0,
  `ENCAISS_TTC` double NOT NULL DEFAULT 0,
  `IDENTIFICATION_ECRITURE_COMPTABLE_DET` varchar(32) NOT NULL DEFAULT '',
  `IDENTIFICATION_ECRITURE_COMPTABLE_ET` varchar(32) NOT NULL DEFAULT '',
  `IDENTIFICATION_TIERS` varchar(32) NOT NULL DEFAULT '',
  `ID_CLIENT_DOUTEUX_ET` varchar(32) NOT NULL DEFAULT '',
  `MONTANT_INITIAL_HT` double NOT NULL DEFAULT 0,
  `MONTANT_INITIAL_TTC` double NOT NULL DEFAULT 0,
  `NOM_DOSSIER` varchar(50) NOT NULL DEFAULT '',
  `NUMERO` double NOT NULL DEFAULT 0,
  `N_CPTE_TIERS` varchar(30) NOT NULL DEFAULT '',
  `N_DOSSIER` double NOT NULL DEFAULT 0,
  `N_ECRITURE_COMPTABLE` double NOT NULL DEFAULT 0,
  `PERTE` double NOT NULL DEFAULT 0,
  `PROVISION_HT` double NOT NULL DEFAULT 0,
  `PROVISION_NECESSAIRE_HT` double NOT NULL DEFAULT 0,
  `REPRISES` double NOT NULL DEFAULT 0,
  `RESTANT_DU_HT` double NOT NULL DEFAULT 0,
  `RESTANT_DU_TTC` double NOT NULL DEFAULT 0,
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TVA_A_RECUPERER` double NOT NULL DEFAULT 0,
  `TAUX_TVA` double NOT NULL DEFAULT 0,
  `POURC_PROVISION` double NOT NULL DEFAULT 0,
  `N_PIECE` varchar(10) NOT NULL DEFAULT '',
  `N_EXERCICE_PASSAGE_DOUTEUX` decimal(12,0) NOT NULL DEFAULT 0,
  `N_CPTE_GENERAL` varchar(10) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_CLIENT_DOUTEUX_ET`),
  KEY `A_SOLDER` (`A_SOLDER`) USING BTREE,
  KEY `DATE_ECRITURE` (`DATE_ECRITURE`) USING BTREE,
  KEY `IDENTIFICATION_ECRITURE_COMPTABLE_DET` (`IDENTIFICATION_ECRITURE_COMPTABLE_DET`) USING BTREE,
  KEY `IDENTIFICATION_ECRITURE_COMPTABLE_ET` (`IDENTIFICATION_ECRITURE_COMPTABLE_ET`) USING BTREE,
  KEY `IDENTIFICATION_TIERS` (`IDENTIFICATION_TIERS`) USING BTREE,
  KEY `NUMERO` (`NUMERO`) USING BTREE,
  KEY `N_CPTE_TIERS` (`N_CPTE_TIERS`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `N_ECRITURE_COMPTABLE` (`N_ECRITURE_COMPTABLE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `NOM_DOSSIER` (`NOM_DOSSIER`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `commande_abonnement`
--

CREATE TABLE `commande_abonnement` (
  `ID_COMMANDE_ABONNEMENT` varchar(32) NOT NULL DEFAULT '',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `DATE_COMMANDE` date DEFAULT NULL,
  `DATE_LIVRAISON` date DEFAULT NULL,
  `DESIGNATION` varchar(150) NOT NULL DEFAULT '',
  `CLIENTS` varchar(50) NOT NULL DEFAULT '',
  `TOTAL` decimal(12,0) NOT NULL DEFAULT 0,
  `NOM` varchar(50) NOT NULL DEFAULT '',
  `PRENOM` varchar(50) NOT NULL DEFAULT '',
  `EMAIL` varchar(50) NOT NULL DEFAULT '',
  `TEL` varchar(20) NOT NULL DEFAULT '',
  `CODE_CLIENT` varchar(32) NOT NULL DEFAULT '',
  `IDENT_TIERS` varchar(32) NOT NULL DEFAULT '',
  `POINT_LIVRAISON` varchar(200) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_COMMANDE_ABONNEMENT`),
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `CODE_CLIENT` (`CODE_CLIENT`) USING BTREE,
  KEY `IDENT_TIERS` (`IDENT_TIERS`) USING BTREE,
  KEY `POINT_LIVRAISON` (`POINT_LIVRAISON`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `commande_decoupe`
--

CREATE TABLE `commande_decoupe` (
  `CODE_ARTICLE` varchar(10) NOT NULL DEFAULT '',
  `CODE_ARTICLE_DIFF` varchar(10) NOT NULL DEFAULT '',
  `DATE_LIVRAISON` varchar(10) NOT NULL DEFAULT '',
  `DIVISON` double NOT NULL DEFAULT 0,
  `HEURE_LIVRAISON` varchar(10) NOT NULL DEFAULT '',
  `ID_COMMANDE_DECOUPE` varchar(32) NOT NULL DEFAULT '',
  `INTITULE` varchar(10) NOT NULL DEFAULT '',
  `PID_COMMANDE_WEB` varchar(32) NOT NULL DEFAULT '',
  `PID_PRODUCTION_RECETTE_ET` varchar(32) NOT NULL DEFAULT '',
  `Q_ARTICLE` double NOT NULL DEFAULT 0,
  `SUPPRESSION` char(1) NOT NULL DEFAULT '',
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TOTAL_CRUS` double NOT NULL DEFAULT 0,
  PRIMARY KEY (`ID_COMMANDE_DECOUPE`),
  KEY `CODE_ARTICLE` (`CODE_ARTICLE`) USING BTREE,
  KEY `PID_COMMANDE_WEB` (`PID_COMMANDE_WEB`) USING BTREE,
  KEY `PID_PRODUCTION_RECETTE_ET` (`PID_PRODUCTION_RECETTE_ET`) USING BTREE,
  KEY `SUPPRESSION` (`SUPPRESSION`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `TOTAL_CRUS` (`TOTAL_CRUS`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `commande_det`
--

CREATE TABLE `commande_det` (
  `CODE_ARTICLE` varchar(10) NOT NULL DEFAULT '',
  `CODE_CLIENT` varchar(32) NOT NULL DEFAULT '',
  `DATE_FACTURE` date DEFAULT NULL,
  `DATE_LIVRAISON` date DEFAULT NULL,
  `DATE_LIVRAISON_REEL` date DEFAULT NULL,
  `DATE_RECAP` date DEFAULT NULL,
  `DESIGNATION` varchar(100) NOT NULL DEFAULT '',
  `FACTURE` char(1) NOT NULL DEFAULT '',
  `HEURE_LIVRAISON` varchar(10) NOT NULL DEFAULT '',
  `IDENT_TIERS` varchar(32) NOT NULL DEFAULT '',
  `ID_COMMANDE_DET` varchar(32) NOT NULL DEFAULT '',
  `NOM` varchar(50) NOT NULL DEFAULT '',
  `NOM_RECETTE` varchar(20) NOT NULL DEFAULT '',
  `P` varchar(32) NOT NULL DEFAULT '',
  `PID_COMMANDE_ET` varchar(32) NOT NULL DEFAULT '',
  `PID_COMMANDE_WEB` varchar(32) NOT NULL DEFAULT '',
  `PID_PRODUCTION_RECETTE_ET` varchar(32) NOT NULL DEFAULT '',
  `PRET` char(1) NOT NULL DEFAULT '',
  `Q` double NOT NULL DEFAULT 0,
  `Q_GRAMME` double NOT NULL DEFAULT 0,
  `Q_GRAMME_UNITAIRE` double NOT NULL DEFAULT 0,
  `Q_KILO` varchar(10) NOT NULL DEFAULT '',
  `RECAP` char(1) NOT NULL DEFAULT '',
  `RECUP` char(1) NOT NULL DEFAULT '',
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `SCAN_3` char(1) NOT NULL DEFAULT '',
  `IDENT_TARIF` varchar(32) NOT NULL DEFAULT '',
  `POINT_LIVRAISON` varchar(50) NOT NULL DEFAULT '',
  `ETAGERE` varchar(10) NOT NULL DEFAULT '',
  `IDENT_ABO` varchar(32) NOT NULL DEFAULT '',
  `IDENT_POINT_LIVRAISON` varchar(32) NOT NULL DEFAULT '',
  `PRET_PDL` char(1) NOT NULL DEFAULT '',
  `PARTICULIER` char(1) NOT NULL DEFAULT '',
  `N_DOSSIER` varchar(2) NOT NULL DEFAULT '',
  `N_COMMANDE` varchar(10) NOT NULL DEFAULT '',
  `LOT` varchar(10) NOT NULL DEFAULT '',
  `IDENT_LOT_ET` varchar(32) NOT NULL DEFAULT '',
  `IDENT_LOT_DET` varchar(32) NOT NULL DEFAULT '',
  `ID_CREATION_LOT` varchar(32) NOT NULL DEFAULT '',
  `EXCLUSION_FACT` char(1) NOT NULL DEFAULT '',
  `N_CPTE_FEC` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_COMMANDE_DET`),
  KEY `CODE_ARTICLE` (`CODE_ARTICLE`) USING BTREE,
  KEY `CODE_CLIENT` (`CODE_CLIENT`) USING BTREE,
  KEY `DATE_LIVRAISON` (`DATE_LIVRAISON`) USING BTREE,
  KEY `DATE_LIVRAISON_REEL` (`DATE_LIVRAISON_REEL`) USING BTREE,
  KEY `DATE_RECAP` (`DATE_RECAP`) USING BTREE,
  KEY `DESIGNATION` (`DESIGNATION`) USING BTREE,
  KEY `FACTURE` (`FACTURE`) USING BTREE,
  KEY `HEURE_LIVRAISON` (`HEURE_LIVRAISON`) USING BTREE,
  KEY `IDENT_TIERS` (`IDENT_TIERS`) USING BTREE,
  KEY `NOM` (`NOM`) USING BTREE,
  KEY `P` (`P`) USING BTREE,
  KEY `PID_COMMANDE_ET` (`PID_COMMANDE_ET`) USING BTREE,
  KEY `PID_COMMANDE_WEB` (`PID_COMMANDE_WEB`) USING BTREE,
  KEY `PID_PRODUCTION_RECETTE_ET` (`PID_PRODUCTION_RECETTE_ET`) USING BTREE,
  KEY `PRET` (`PRET`) USING BTREE,
  KEY `Q` (`Q`) USING BTREE,
  KEY `RECAP` (`RECAP`) USING BTREE,
  KEY `RECUP` (`RECUP`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `SCAN_3` (`SCAN_3`) USING BTREE,
  KEY `IDENT_TARIF` (`IDENT_TARIF`) USING BTREE,
  KEY `ETAGERE` (`ETAGERE`) USING BTREE,
  KEY `IDENT_POINT_LIVRAISON` (`IDENT_POINT_LIVRAISON`) USING BTREE,
  KEY `PRET_PDL` (`PRET_PDL`) USING BTREE,
  KEY `PARTICULIER` (`PARTICULIER`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `N_COMMANDE` (`N_COMMANDE`) USING BTREE,
  KEY `LOT` (`LOT`) USING BTREE,
  KEY `IDENT_LOT_ET` (`IDENT_LOT_ET`) USING BTREE,
  KEY `IDENT_LOT_DET` (`IDENT_LOT_DET`) USING BTREE,
  KEY `ID_CREATION_LOT` (`ID_CREATION_LOT`) USING BTREE,
  KEY `EXCLUSION_FACT` (`EXCLUSION_FACT`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `commande_et`
--

CREATE TABLE `commande_et` (
  `ADRESE` varchar(600) NOT NULL DEFAULT '',
  `CODE_CLIENT` varchar(50) NOT NULL DEFAULT '',
  `CODE_J` varchar(2) NOT NULL DEFAULT '',
  `CODE_M` varchar(2) NOT NULL DEFAULT '',
  `CODE_S` varchar(2) NOT NULL DEFAULT '',
  `DATE_FACTURE` date DEFAULT NULL,
  `DATE_LIVRAISON` date DEFAULT NULL,
  `DATE_LIVRAISON_2` date DEFAULT NULL,
  `ENVOI_VALIDATION` char(1) NOT NULL DEFAULT '',
  `FACTURE` char(1) NOT NULL DEFAULT '',
  `HEURE_LIVRAISON` varchar(10) NOT NULL DEFAULT '',
  `IDENT_TIERS` varchar(32) NOT NULL DEFAULT '',
  `IDENT_TRS` varchar(32) NOT NULL DEFAULT '',
  `ID_COMMANDE_ET` varchar(32) NOT NULL DEFAULT '',
  `IP_ADR` varchar(150) NOT NULL DEFAULT '',
  `MAIL` varchar(300) NOT NULL DEFAULT '',
  `NOM` varchar(30) NOT NULL DEFAULT '',
  `NOTE` blob DEFAULT NULL,
  `PRETE` char(1) NOT NULL DEFAULT '',
  `RECAP` char(1) NOT NULL DEFAULT '',
  `RECUP` char(1) NOT NULL DEFAULT '',
  `REFERER` varchar(150) NOT NULL DEFAULT '',
  `SAC_01` char(1) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TRANSPORTEUR` varchar(100) NOT NULL DEFAULT '',
  `USERAGENT` blob DEFAULT NULL,
  `VALIDATION` char(1) NOT NULL DEFAULT '',
  `WEB` char(1) NOT NULL DEFAULT '',
  `SCAN_1` char(1) NOT NULL DEFAULT '',
  `SCAN_2` char(1) NOT NULL DEFAULT '',
  `IDENT_TARIF` varchar(32) NOT NULL DEFAULT '',
  `POINT_LIVRAISON` varchar(50) NOT NULL DEFAULT '',
  `TELEPHONNE` varchar(20) NOT NULL DEFAULT '',
  `EMAIL` varchar(50) NOT NULL DEFAULT '',
  `IDENT_ABO` varchar(32) NOT NULL DEFAULT '',
  `IDENT_POINT_LIVRAISON` varchar(32) NOT NULL DEFAULT '',
  `PRETE_PDL` char(1) NOT NULL DEFAULT '',
  `PARTICULIER` char(1) NOT NULL DEFAULT '',
  `N_DOSSIER` varchar(2) NOT NULL DEFAULT '',
  `N_COMMANDE` varchar(10) NOT NULL DEFAULT '',
  `LOT` varchar(10) NOT NULL DEFAULT '',
  `IDENT_LOT_ET` varchar(32) NOT NULL DEFAULT '',
  `ID_CREATION_LOT` varchar(32) NOT NULL DEFAULT '',
  `EXCLUSION_FACT` char(1) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_COMMANDE_ET`),
  KEY `ADRESE` (`ADRESE`) USING BTREE,
  KEY `CODE_CLIENT` (`CODE_CLIENT`) USING BTREE,
  KEY `CODE_J` (`CODE_J`) USING BTREE,
  KEY `CODE_M` (`CODE_M`) USING BTREE,
  KEY `CODE_S` (`CODE_S`) USING BTREE,
  KEY `DATE_FACTURE` (`DATE_FACTURE`) USING BTREE,
  KEY `DATE_LIVRAISON` (`DATE_LIVRAISON`) USING BTREE,
  KEY `DATE_LIVRAISON_2` (`DATE_LIVRAISON_2`) USING BTREE,
  KEY `ENVOI_VALIDATION` (`ENVOI_VALIDATION`) USING BTREE,
  KEY `FACTURE` (`FACTURE`) USING BTREE,
  KEY `HEURE_LIVRAISON` (`HEURE_LIVRAISON`) USING BTREE,
  KEY `IDENT_TIERS` (`IDENT_TIERS`) USING BTREE,
  KEY `IDENT_TRS` (`IDENT_TRS`) USING BTREE,
  KEY `MAIL` (`MAIL`) USING BTREE,
  KEY `NOM` (`NOM`) USING BTREE,
  KEY `PRETE` (`PRETE`) USING BTREE,
  KEY `RECAP` (`RECAP`) USING BTREE,
  KEY `RECUP` (`RECUP`) USING BTREE,
  KEY `SAC_01` (`SAC_01`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `TRANSPORTEUR` (`TRANSPORTEUR`) USING BTREE,
  KEY `VALIDATION` (`VALIDATION`) USING BTREE,
  KEY `WEB` (`WEB`) USING BTREE,
  KEY `SCAN_1` (`SCAN_1`) USING BTREE,
  KEY `SCAN_2` (`SCAN_2`) USING BTREE,
  KEY `IDENT_TARIF` (`IDENT_TARIF`) USING BTREE,
  KEY `IDENT_POINT_LIVRAISON` (`IDENT_POINT_LIVRAISON`) USING BTREE,
  KEY `EMAIL` (`EMAIL`) USING BTREE,
  KEY `PARTICULIER` (`PARTICULIER`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `N_COMMANDE` (`N_COMMANDE`) USING BTREE,
  KEY `LOT` (`LOT`) USING BTREE,
  KEY `IDENT_LOT_ET` (`IDENT_LOT_ET`) USING BTREE,
  KEY `ID_CREATION_LOT` (`ID_CREATION_LOT`) USING BTREE,
  KEY `EXCLUSION_FACT` (`EXCLUSION_FACT`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `commande_lot_det`
--

CREATE TABLE `commande_lot_det` (
  `ID_COMMANDE_LOT_DET` varchar(32) NOT NULL DEFAULT '',
  `PID_COMMANDE_LOT_ET` varchar(32) NOT NULL DEFAULT '',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `CODE_TIERS` varchar(50) NOT NULL DEFAULT '',
  `D1` date DEFAULT NULL,
  `D3` date DEFAULT NULL,
  `D2` date DEFAULT NULL,
  `D4` date DEFAULT NULL,
  `D5` date DEFAULT NULL,
  `D6` date DEFAULT NULL,
  `D7` date DEFAULT NULL,
  `IDENT_POINT_LIVRAISON` varchar(32) NOT NULL DEFAULT '',
  `NOM_POINT_LIVRAISON` varchar(100) NOT NULL DEFAULT '',
  `IDENT_TIERS` varchar(32) NOT NULL DEFAULT '',
  `N_DOSSIER` varchar(2) NOT NULL DEFAULT '',
  `N_LOT` varchar(10) NOT NULL DEFAULT '',
  `NOM_LOT` varchar(50) NOT NULL DEFAULT '',
  `NOM_DOSSIER` varchar(50) NOT NULL DEFAULT '',
  `NOM_TIERS` varchar(50) NOT NULL DEFAULT '',
  `CODE_ARTICLE` varchar(10) NOT NULL DEFAULT '',
  `DESIGNATION` varchar(50) NOT NULL DEFAULT '',
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `QUANTITE_D1` double NOT NULL DEFAULT 0,
  `QUANTITE_D2` double NOT NULL DEFAULT 0,
  `QUANTITE_D3` double NOT NULL DEFAULT 0,
  `QUANTITE_D4` double NOT NULL DEFAULT 0,
  `QUANTITE_D5` double NOT NULL DEFAULT 0,
  `QUANTITE_D6` double NOT NULL DEFAULT 0,
  `QUANTITE_D7` double NOT NULL DEFAULT 0,
  `ID1` varchar(32) NOT NULL DEFAULT '',
  `ID2` varchar(32) NOT NULL DEFAULT '',
  `ID3` varchar(32) NOT NULL DEFAULT '',
  `ID4` varchar(32) NOT NULL DEFAULT '',
  `ID5` varchar(32) NOT NULL DEFAULT '',
  `ID6` varchar(32) NOT NULL DEFAULT '',
  `ID7` varchar(32) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_COMMANDE_LOT_DET`),
  KEY `PID_COMMANDE_LOT_ET` (`PID_COMMANDE_LOT_ET`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `IDENT_TIERS` (`IDENT_TIERS`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `ID1` (`ID1`) USING BTREE,
  KEY `ID2` (`ID2`) USING BTREE,
  KEY `ID3` (`ID3`) USING BTREE,
  KEY `ID4` (`ID4`) USING BTREE,
  KEY `ID5` (`ID5`) USING BTREE,
  KEY `ID6` (`ID6`) USING BTREE,
  KEY `ID7` (`ID7`) USING BTREE,
  KEY `N_LOT` (`N_LOT`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `commande_lot_et`
--

CREATE TABLE `commande_lot_et` (
  `ID_COMMANDE_LOT_ET` varchar(32) NOT NULL DEFAULT '',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `CODE_TIERS` varchar(50) NOT NULL DEFAULT '',
  `D1` date DEFAULT NULL,
  `D2` date DEFAULT NULL,
  `D3` date DEFAULT NULL,
  `D5` date DEFAULT NULL,
  `D6` date DEFAULT NULL,
  `D7` date DEFAULT NULL,
  `D4` date DEFAULT NULL,
  `IDENT_POINT_LIVRAISON` varchar(32) NOT NULL DEFAULT '',
  `IDENT_TIERS` varchar(32) NOT NULL DEFAULT '',
  `MAIL_TIERS` varchar(100) NOT NULL DEFAULT '',
  `N_DOSSIER` varchar(2) NOT NULL DEFAULT '',
  `N_LOT` varchar(10) NOT NULL DEFAULT '',
  `NOM_LOT` varchar(50) NOT NULL DEFAULT '',
  `NOM_DOSSIER` varchar(50) NOT NULL DEFAULT '',
  `NOM_POINT_LIVRAISON` varchar(50) NOT NULL DEFAULT '',
  `NOM_TIERS` varchar(50) NOT NULL DEFAULT '',
  `TEL_TIERS` varchar(20) NOT NULL DEFAULT '',
  `ID1` varchar(32) NOT NULL DEFAULT '',
  `ID2` varchar(32) NOT NULL DEFAULT '',
  `ID3` varchar(32) NOT NULL DEFAULT '',
  `ID4` varchar(32) NOT NULL DEFAULT '',
  `ID5` varchar(32) NOT NULL DEFAULT '',
  `ID6` varchar(32) NOT NULL DEFAULT '',
  `ID7` varchar(32) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_COMMANDE_LOT_ET`),
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `IDENT_POINT_LIVRAISON` (`IDENT_POINT_LIVRAISON`) USING BTREE,
  KEY `IDENT_TIERS` (`IDENT_TIERS`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `ID1` (`ID1`) USING BTREE,
  KEY `ID2` (`ID2`) USING BTREE,
  KEY `ID3` (`ID3`) USING BTREE,
  KEY `ID4` (`ID4`) USING BTREE,
  KEY `ID5` (`ID5`) USING BTREE,
  KEY `ID6` (`ID6`) USING BTREE,
  KEY `ID7` (`ID7`) USING BTREE,
  KEY `N_LOT` (`N_LOT`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `commande_web`
--

CREATE TABLE `commande_web` (
  `ADRESSE` varchar(600) NOT NULL DEFAULT '',
  `AN` varchar(4) NOT NULL DEFAULT '',
  `BAG_01` double NOT NULL DEFAULT 0,
  `BAG_02` double NOT NULL DEFAULT 0,
  `BERCL_01` double NOT NULL DEFAULT 0,
  `BERCL_02` double NOT NULL DEFAULT 0,
  `BERC_01` double NOT NULL DEFAULT 0,
  `BERC_02` double NOT NULL DEFAULT 0,
  `BERL_01` double NOT NULL DEFAULT 0,
  `BERL_02` double NOT NULL DEFAULT 0,
  `BER_01` double NOT NULL DEFAULT 0,
  `BER_02` double NOT NULL DEFAULT 0,
  `BRIC_01` double NOT NULL DEFAULT 0,
  `BRI_01` double NOT NULL DEFAULT 0,
  `BUN_01` double NOT NULL DEFAULT 0,
  `CIA_01` double NOT NULL DEFAULT 0,
  `CIA_01_POIDS` varchar(5) NOT NULL DEFAULT '',
  `CODE_CLIENT` varchar(40) NOT NULL DEFAULT '',
  `CODE_FRS` varchar(40) NOT NULL DEFAULT '',
  `CODE_J` varchar(2) NOT NULL DEFAULT '',
  `CODE_M` varchar(2) NOT NULL DEFAULT '',
  `CODE_S` varchar(2) NOT NULL DEFAULT '',
  `COO_01` double NOT NULL DEFAULT 0,
  `COO_02` double NOT NULL DEFAULT 0,
  `CUB_01` double NOT NULL DEFAULT 0,
  `DATE_FACTURE` date DEFAULT NULL,
  `DATE_LIVRAISON` date DEFAULT NULL,
  `DATE_LIVRAISON_2` date DEFAULT NULL,
  `DATE_POUR_RECAP` date DEFAULT NULL,
  `ENG_01` double NOT NULL DEFAULT 0,
  `ENG_02` double NOT NULL DEFAULT 0,
  `ENVOI_VALIDATION` char(1) NOT NULL DEFAULT '',
  `FACTURE` char(1) NOT NULL DEFAULT '',
  `FAR_01` double NOT NULL DEFAULT 0,
  `FAR_02` double NOT NULL DEFAULT 0,
  `FAR_02_POIDS` varchar(5) NOT NULL DEFAULT '',
  `FAR_03` double NOT NULL DEFAULT 0,
  `FIN_01` double NOT NULL DEFAULT 0,
  `GRA_01` double NOT NULL DEFAULT 0,
  `GRA_02` double NOT NULL DEFAULT 0,
  `HEURE_LIVRAISON` varchar(10) NOT NULL DEFAULT '',
  `IDENT_COMMANDE` varchar(32) NOT NULL DEFAULT '',
  `IDENT_TIERS` varchar(40) NOT NULL DEFAULT '',
  `ID_COMMANDE_WEB` varchar(32) NOT NULL DEFAULT '',
  `JOUR` varchar(2) NOT NULL DEFAULT '',
  `LEV_01` double NOT NULL DEFAULT 0,
  `LOGL_01` double NOT NULL DEFAULT 0,
  `LOGL_02` double NOT NULL DEFAULT 0,
  `LOGSL_01` double NOT NULL DEFAULT 0,
  `LOGSL_02` double NOT NULL DEFAULT 0,
  `LOGS_01` double NOT NULL DEFAULT 0,
  `LOGS_02` double NOT NULL DEFAULT 0,
  `LOG_01` double NOT NULL DEFAULT 0,
  `LOG_02` double NOT NULL DEFAULT 0,
  `MAIL` varchar(300) NOT NULL DEFAULT '',
  `MAL_01` double NOT NULL DEFAULT 0,
  `MAL_02` double NOT NULL DEFAULT 0,
  `MOIS` varchar(2) NOT NULL DEFAULT '',
  `NOM` varchar(36) NOT NULL DEFAULT '',
  `NOM_FRS` varchar(40) NOT NULL DEFAULT '',
  `NOTE` blob DEFAULT NULL,
  `PAICA_01` double NOT NULL DEFAULT 0,
  `PAICA_02` double NOT NULL DEFAULT 0,
  `PAICH_01` double NOT NULL DEFAULT 0,
  `PAICH_02` double NOT NULL DEFAULT 0,
  `PAIG_01` double NOT NULL DEFAULT 0,
  `PAIG_02` double NOT NULL DEFAULT 0,
  `PAIM_01` double NOT NULL DEFAULT 0,
  `PAIS_01` double NOT NULL DEFAULT 0,
  `PAIS_02` double NOT NULL DEFAULT 0,
  `PID_COMMANDE_WEB` varchar(32) NOT NULL DEFAULT '',
  `PID_COMMANDE_WEB_RECAP` varchar(32) NOT NULL DEFAULT '',
  `PID_PRODUCTION_RECETTE_ET` varchar(32) NOT NULL DEFAULT '',
  `PRETE` char(1) NOT NULL DEFAULT '',
  `RECAP` char(1) NOT NULL DEFAULT '',
  `RECUP` char(1) NOT NULL DEFAULT '',
  `SAC_01` varchar(3) NOT NULL DEFAULT '',
  `SAC_02` double NOT NULL DEFAULT 0,
  `SEL_DATE` date DEFAULT NULL,
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `VALIDATION` char(1) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_COMMANDE_WEB`),
  KEY `CIA_01_POIDS` (`CIA_01_POIDS`) USING BTREE,
  KEY `CODE_CLIENT` (`CODE_CLIENT`) USING BTREE,
  KEY `CODE_J` (`CODE_J`) USING BTREE,
  KEY `CODE_M` (`CODE_M`) USING BTREE,
  KEY `CODE_S` (`CODE_S`) USING BTREE,
  KEY `DATE_LIVRAISON` (`DATE_LIVRAISON`) USING BTREE,
  KEY `DATE_LIVRAISON_2` (`DATE_LIVRAISON_2`) USING BTREE,
  KEY `DATE_POUR_RECAP` (`DATE_POUR_RECAP`) USING BTREE,
  KEY `ENVOI_VALIDATION` (`ENVOI_VALIDATION`) USING BTREE,
  KEY `IDENT_COMMANDE` (`IDENT_COMMANDE`) USING BTREE,
  KEY `MAIL` (`MAIL`) USING BTREE,
  KEY `NOM` (`NOM`) USING BTREE,
  KEY `PID_COMMANDE_WEB` (`PID_COMMANDE_WEB`) USING BTREE,
  KEY `PID_COMMANDE_WEB_RECAP` (`PID_COMMANDE_WEB_RECAP`) USING BTREE,
  KEY `PID_PRODUCTION_RECETTE_ET` (`PID_PRODUCTION_RECETTE_ET`) USING BTREE,
  KEY `PRETE` (`PRETE`) USING BTREE,
  KEY `RECUP` (`RECUP`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `VALIDATION` (`VALIDATION`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `commande_web_recap`
--

CREATE TABLE `commande_web_recap` (
  `BAG_01` double NOT NULL DEFAULT 0,
  `BAG_02` double NOT NULL DEFAULT 0,
  `BERCL_01` double NOT NULL DEFAULT 0,
  `BERCL_02` double NOT NULL DEFAULT 0,
  `BERC_01` double NOT NULL DEFAULT 0,
  `BERC_02` double NOT NULL DEFAULT 0,
  `BERL_01` double NOT NULL DEFAULT 0,
  `BERL_02` double NOT NULL DEFAULT 0,
  `BER_01` double NOT NULL DEFAULT 0,
  `BER_02` double NOT NULL DEFAULT 0,
  `BRIC_01` double NOT NULL DEFAULT 0,
  `BRI_01` double NOT NULL DEFAULT 0,
  `BUN_01` double NOT NULL DEFAULT 0,
  `CIA_01` double NOT NULL DEFAULT 0,
  `COCHE` char(1) NOT NULL DEFAULT '',
  `COO_01` double NOT NULL DEFAULT 0,
  `COO_02` double NOT NULL DEFAULT 0,
  `CUB_01` double NOT NULL DEFAULT 0,
  `DATE_DEPART` date DEFAULT NULL,
  `DATE_LIVRAISON` date DEFAULT NULL,
  `DATE_LIVRAISON_2` date DEFAULT NULL,
  `ENG_01` double NOT NULL DEFAULT 0,
  `ENG_02` double NOT NULL DEFAULT 0,
  `FAR_01` double NOT NULL DEFAULT 0,
  `FAR_02` double NOT NULL DEFAULT 0,
  `FAR_03` double NOT NULL DEFAULT 0,
  `FIN_01` double NOT NULL DEFAULT 0,
  `GRA_01` double NOT NULL DEFAULT 0,
  `GRA_02` double NOT NULL DEFAULT 0,
  `HEURE_LIVRAISON` time NOT NULL DEFAULT '00:00:00',
  `ID_COMMANDE_WEB_RECAP` varchar(32) NOT NULL DEFAULT '',
  `LEV_01` double NOT NULL DEFAULT 0,
  `LOGL_01` double NOT NULL DEFAULT 0,
  `LOGL_02` double NOT NULL DEFAULT 0,
  `LOGSL_01` double NOT NULL DEFAULT 0,
  `LOGSL_02` double NOT NULL DEFAULT 0,
  `LOGS_01` double NOT NULL DEFAULT 0,
  `LOGS_02` double NOT NULL DEFAULT 0,
  `LOG_01` double NOT NULL DEFAULT 0,
  `LOG_02` double NOT NULL DEFAULT 0,
  `MAL_01` double NOT NULL DEFAULT 0,
  `MAL_02` double NOT NULL DEFAULT 0,
  `NOM_RECAP` varchar(20) NOT NULL DEFAULT '',
  `PAICA_01` double NOT NULL DEFAULT 0,
  `PAICA_02` double NOT NULL DEFAULT 0,
  `PAICH_01` double NOT NULL DEFAULT 0,
  `PAICH_02` double NOT NULL DEFAULT 0,
  `PAIG_01` double NOT NULL DEFAULT 0,
  `PAIG_02` double NOT NULL DEFAULT 0,
  `PAIM_01` double NOT NULL DEFAULT 0,
  `PAIS_01` double NOT NULL DEFAULT 0,
  `PAIS_02` double NOT NULL DEFAULT 0,
  `PID_COMMANDE_WEB` varchar(32) NOT NULL DEFAULT '',
  `SAC_01` double NOT NULL DEFAULT 0,
  `SAC_02` double NOT NULL DEFAULT 0,
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_COMMANDE_WEB_RECAP`),
  KEY `BAG_02` (`BAG_02`) USING BTREE,
  KEY `BERCL_01` (`BERCL_01`) USING BTREE,
  KEY `BERCL_02` (`BERCL_02`) USING BTREE,
  KEY `BERC_01` (`BERC_01`) USING BTREE,
  KEY `BERC_02` (`BERC_02`) USING BTREE,
  KEY `BERL_01` (`BERL_01`) USING BTREE,
  KEY `BERL_02` (`BERL_02`) USING BTREE,
  KEY `BER_01` (`BER_01`) USING BTREE,
  KEY `BER_02` (`BER_02`) USING BTREE,
  KEY `BRIC_01` (`BRIC_01`) USING BTREE,
  KEY `BRI_01` (`BRI_01`) USING BTREE,
  KEY `BUN_01` (`BUN_01`) USING BTREE,
  KEY `CIA_01` (`CIA_01`) USING BTREE,
  KEY `COO_01` (`COO_01`) USING BTREE,
  KEY `COO_02` (`COO_02`) USING BTREE,
  KEY `CUB_01` (`CUB_01`) USING BTREE,
  KEY `ENG_01` (`ENG_01`) USING BTREE,
  KEY `ENG_02` (`ENG_02`) USING BTREE,
  KEY `FAR_01` (`FAR_01`) USING BTREE,
  KEY `FAR_02` (`FAR_02`) USING BTREE,
  KEY `FAR_03` (`FAR_03`) USING BTREE,
  KEY `FIN_01` (`FIN_01`) USING BTREE,
  KEY `GRA_01` (`GRA_01`) USING BTREE,
  KEY `GRA_02` (`GRA_02`) USING BTREE,
  KEY `HEURE_LIVRAISON` (`HEURE_LIVRAISON`) USING BTREE,
  KEY `LEV_01` (`LEV_01`) USING BTREE,
  KEY `LOGL_01` (`LOGL_01`) USING BTREE,
  KEY `LOGL_02` (`LOGL_02`) USING BTREE,
  KEY `LOGSL_01` (`LOGSL_01`) USING BTREE,
  KEY `LOGSL_02` (`LOGSL_02`) USING BTREE,
  KEY `LOGS_01` (`LOGS_01`) USING BTREE,
  KEY `LOGS_02` (`LOGS_02`) USING BTREE,
  KEY `LOG_01` (`LOG_01`) USING BTREE,
  KEY `LOG_02` (`LOG_02`) USING BTREE,
  KEY `MAL_01` (`MAL_01`) USING BTREE,
  KEY `MAL_02` (`MAL_02`) USING BTREE,
  KEY `PAICA_01` (`PAICA_01`) USING BTREE,
  KEY `PAICA_02` (`PAICA_02`) USING BTREE,
  KEY `PAICH_01` (`PAICH_01`) USING BTREE,
  KEY `PAICH_02` (`PAICH_02`) USING BTREE,
  KEY `PAIG_01` (`PAIG_01`) USING BTREE,
  KEY `PAIG_02` (`PAIG_02`) USING BTREE,
  KEY `PAIM_01` (`PAIM_01`) USING BTREE,
  KEY `PAIS_01` (`PAIS_01`) USING BTREE,
  KEY `PAIS_02` (`PAIS_02`) USING BTREE,
  KEY `PID_COMMANDE_WEB` (`PID_COMMANDE_WEB`) USING BTREE,
  KEY `SAC_01` (`SAC_01`) USING BTREE,
  KEY `SAC_02` (`SAC_02`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `commande_web_type`
--

CREATE TABLE `commande_web_type` (
  `CODE_CLIENT` varchar(32) NOT NULL DEFAULT '',
  `CODE_J` varchar(10) NOT NULL DEFAULT '',
  `COMMANDE_OK` char(1) NOT NULL DEFAULT '',
  `HEURE` time NOT NULL DEFAULT '00:00:00',
  `ID_COMMANDE_WEB_TYPE` varchar(32) NOT NULL DEFAULT '',
  `MAIL` varchar(300) NOT NULL DEFAULT '',
  `PID_TIERS` varchar(32) NOT NULL DEFAULT '',
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_COMMANDE_WEB_TYPE`),
  KEY `CODE_CLIENT` (`CODE_CLIENT`) USING BTREE,
  KEY `CODE_J` (`CODE_J`) USING BTREE,
  KEY `COMMANDE_OK` (`COMMANDE_OK`) USING BTREE,
  KEY `HEURE` (`HEURE`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `commande_web_verticale`
--

CREATE TABLE `commande_web_verticale` (
  `CODE_ARTICLE` varchar(10) NOT NULL DEFAULT '',
  `CODE_CLIENT` varchar(35) NOT NULL DEFAULT '',
  `DATE` date DEFAULT NULL,
  `IDENT_COMMANDE_WEB` varchar(32) NOT NULL DEFAULT '',
  `ID_COMMANDE_WEB_VERTICALE` varchar(32) NOT NULL DEFAULT '',
  `NOM_ARTICLE` varchar(100) NOT NULL DEFAULT '',
  `QUANTITE` varchar(10) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_COMMANDE_WEB_VERTICALE`),
  KEY `CODE_ARTICLE` (`CODE_ARTICLE`) USING BTREE,
  KEY `CODE_CLIENT` (`CODE_CLIENT`) USING BTREE,
  KEY `DATE` (`DATE`) USING BTREE,
  KEY `IDENT_COMMANDE_WEB` (`IDENT_COMMANDE_WEB`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Temporary table structure for view `compta_ana`
--

/*!50001 DROP VIEW IF EXISTS `compta_ana`*/;
/*!50001 CREATE VIEW `compta_ana` AS SELECT
 1 AS `n_cpte_general`,
  1 AS `debit`,
  1 AS `credit`,
  1 AS `ans1`,
  1 AS `ans2`,
  1 AS `ans3`,
  1 AS `ans4`,
  1 AS `ans5`,
  1 AS `N_DOSSIER`,
  1 AS `N_EXERCICE`,
  1 AS `id`,
  1 AS `n_ecriture` */;

--
-- Temporary table structure for view `compta_ana_situa`
--

/*!50001 DROP VIEW IF EXISTS `compta_ana_situa`*/;
/*!50001 CREATE VIEW `compta_ana_situa` AS SELECT
 1 AS `n_cpte_general`,
  1 AS `debit`,
  1 AS `credit`,
  1 AS `ans1`,
  1 AS `ans2`,
  1 AS `ans3`,
  1 AS `ans4`,
  1 AS `ans5`,
  1 AS `N_DOSSIER`,
  1 AS `N_EXERCICE`,
  1 AS `id`,
  1 AS `n_ecriture` */;

--
-- Table structure for table `comptabilit_archive_det`
--

CREATE TABLE `comptabilit_archive_det` (
  `ANS1` double NOT NULL DEFAULT 0,
  `ANS10` double NOT NULL DEFAULT 0,
  `ANS11` double NOT NULL DEFAULT 0,
  `ANS12` double NOT NULL DEFAULT 0,
  `ANS13` double NOT NULL DEFAULT 0,
  `ANS14` double NOT NULL DEFAULT 0,
  `ANS15` double NOT NULL DEFAULT 0,
  `ANS16` double NOT NULL DEFAULT 0,
  `ANS17` double NOT NULL DEFAULT 0,
  `ANS18` double NOT NULL DEFAULT 0,
  `ANS19` double NOT NULL DEFAULT 0,
  `ANS2` double NOT NULL DEFAULT 0,
  `ANS20` double NOT NULL DEFAULT 0,
  `ANS3` double NOT NULL DEFAULT 0,
  `ANS4` double NOT NULL DEFAULT 0,
  `ANS5` double NOT NULL DEFAULT 0,
  `ANS6` double NOT NULL DEFAULT 0,
  `ANS7` double NOT NULL DEFAULT 0,
  `ANS8` double NOT NULL DEFAULT 0,
  `ANS9` double NOT NULL DEFAULT 0,
  `A_LETTRER` char(1) NOT NULL DEFAULT '',
  `A_LETTRER_1` char(1) NOT NULL DEFAULT '',
  `A_LETTRER_PAR` varchar(10) NOT NULL DEFAULT '',
  `BAP` varchar(10) NOT NULL DEFAULT '',
  `BLOCAGE_ECRITURE` char(1) NOT NULL DEFAULT '',
  `BLOCAGE_EXERCICE` char(1) NOT NULL DEFAULT '',
  `BLOCAGE_REGLEMENT` char(1) NOT NULL DEFAULT '',
  `BLOCAGE_VALIDATION` char(1) NOT NULL DEFAULT '',
  `CLOTURE_EXERCICE` char(1) NOT NULL DEFAULT '',
  `CODE_JOURNAL` varchar(10) NOT NULL DEFAULT '',
  `CODE_OMP` varchar(10) NOT NULL DEFAULT '',
  `CREDIT` decimal(20,2) NOT NULL DEFAULT 0.00,
  `CREDIT_ETR1` decimal(20,2) NOT NULL DEFAULT 0.00,
  `DATE` date DEFAULT NULL,
  `DATEHEURE` varchar(60) NOT NULL DEFAULT '',
  `DATE_CLOTURE_EXERCICE` date DEFAULT NULL,
  `DATE_ECHEANCE` date DEFAULT NULL,
  `DATE_ENVOI_FACTURE` date DEFAULT NULL,
  `DATE_ENVOYE` date DEFAULT NULL,
  `DATE_LETTRAGE` date DEFAULT NULL,
  `DATE_TRESO` date DEFAULT NULL,
  `DATE_VALIDATION_ECRITURE` date DEFAULT NULL,
  `DEBIT` decimal(20,2) NOT NULL DEFAULT 0.00,
  `DEBIT_ETR1` decimal(20,2) NOT NULL DEFAULT 0.00,
  `DEVISE` double NOT NULL DEFAULT 0,
  `ECRITURE_DIRECTE` char(1) NOT NULL DEFAULT '',
  `ECRITURE_INITIALE_DET` varchar(32) NOT NULL DEFAULT '',
  `ECRITURE_INITIALE_ET` varchar(32) NOT NULL DEFAULT '',
  `ECRITURE_SITUATION_CUMULABLE` char(1) NOT NULL DEFAULT '',
  `EXTOURNABLE` char(1) NOT NULL DEFAULT '',
  `FACTO` char(1) NOT NULL DEFAULT '',
  `IDENTIFICATION_CHEQUE` varchar(32) NOT NULL DEFAULT '',
  `IDENTIFICATION_PRELEVEMENT` varchar(32) NOT NULL DEFAULT '',
  `IDENTIFICATION_TIERS` varchar(32) NOT NULL DEFAULT '',
  `IDENTIFICATION_TRAITE` varchar(32) NOT NULL DEFAULT '',
  `IDENTIFICATION_VIREMENT` varchar(60) NOT NULL DEFAULT '',
  `IDENT_DOCUMENT_ARCHIVE` varchar(32) NOT NULL DEFAULT '',
  `ID_COMPTABILIT_ARCHIVE_DET` varchar(32) NOT NULL DEFAULT '',
  `IMPRESSION_LIGNE` char(1) NOT NULL DEFAULT '',
  `JOUR_DATE_ECHEANCE` varchar(2) NOT NULL DEFAULT '',
  `LETTRAGE` varchar(10) NOT NULL DEFAULT '',
  `LETTRAGE_1` varchar(10) NOT NULL DEFAULT '',
  `LETTRAGE_CHIFFRE` double NOT NULL DEFAULT 0,
  `LETTRAGE_CHIFFRE_1` double NOT NULL DEFAULT 0,
  `LIBELLE` varchar(150) NOT NULL DEFAULT '',
  `LITIGE_TRANSPORT` varchar(20) NOT NULL DEFAULT '',
  `MAIL_ENVOI_FACTURE` varchar(50) NOT NULL DEFAULT '',
  `MODE_ENVOI_FACTURE` varchar(20) NOT NULL DEFAULT '',
  `MODULE_EGP` char(1) NOT NULL DEFAULT '',
  `NOM_DOSSIER` varchar(50) NOT NULL DEFAULT '',
  `NOM_JOURNAL` varchar(50) NOT NULL DEFAULT '',
  `NOM_TRESO` varchar(10) NOT NULL DEFAULT '',
  `N_CPTE_GENERAL` varchar(10) NOT NULL DEFAULT '',
  `N_CPTE_TIERS` varchar(100) NOT NULL DEFAULT '',
  `N_DOSSIER` double NOT NULL DEFAULT 0,
  `N_ECRITURE` varchar(12) DEFAULT NULL,
  `N_EXERCICE` double NOT NULL DEFAULT 0,
  `N_IMPORT` varchar(15) NOT NULL DEFAULT '',
  `N_LIGNE` decimal(12,0) NOT NULL DEFAULT 0,
  `N_LIGNE_INFO_COMPTA` double NOT NULL DEFAULT 0,
  `N_PIECE` varchar(20) NOT NULL DEFAULT '',
  `N_PIECE_INTERNE` varchar(20) NOT NULL DEFAULT '',
  `N_PIECE_INTERNE_NUM` varchar(20) NOT NULL DEFAULT '',
  `N_PI_SPEC` char(1) NOT NULL DEFAULT '',
  `N_TRESO` double NOT NULL DEFAULT 0,
  `N_TYPE_REGLEMENT` double NOT NULL DEFAULT 0,
  `PAYE` char(1) NOT NULL DEFAULT '',
  `PERIO_DEBUT` date DEFAULT NULL,
  `PERIO_FIN` date DEFAULT NULL,
  `PID_COMPTABILIT_ARCHIVE_ET` varchar(32) NOT NULL DEFAULT '',
  `RD` double NOT NULL DEFAULT 0,
  `SELECT` varchar(1) NOT NULL DEFAULT '',
  `SELECT_USER` varchar(10) NOT NULL DEFAULT '',
  `SOLDE_DEBIT_365` double NOT NULL DEFAULT 0,
  `SUP_RELANCE` char(1) NOT NULL DEFAULT '',
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_ETAT_PLIE` varchar(5) NOT NULL DEFAULT '',
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_LIEN_CONTEXTE_MAITRE` varchar(32) NOT NULL DEFAULT '',
  `SYS_NIVEAU_NOMENCLATURE` double NOT NULL DEFAULT 0,
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TAUX_TVA` double NOT NULL DEFAULT 0,
  `TOTAL_ANA` double NOT NULL DEFAULT 0,
  `TVA_DECLARE_MOIS` varchar(10) NOT NULL DEFAULT '',
  `TYPE_REGLEMENT` varchar(50) NOT NULL DEFAULT '',
  `TYPE_TVA_LIBELLE` varchar(20) NOT NULL DEFAULT '',
  `TYPE_TVA_NUMERO` double NOT NULL DEFAULT 0,
  `UTILISE_RGT` char(1) NOT NULL DEFAULT '',
  `VTF` char(1) NOT NULL DEFAULT '',
  `RECIPROCITE` char(1) NOT NULL DEFAULT '',
  `ANS_MAN` char(1) NOT NULL DEFAULT '',
  `L_TVA` char(1) NOT NULL DEFAULT '',
  `CLOTURE_PARTIELLE` char(1) NOT NULL DEFAULT '',
  `DATE_CLOTURE_PARTIELLE` date DEFAULT NULL,
  `CODE_CLOTURE_PARTIELLE` varchar(10) NOT NULL DEFAULT '',
  `DATE_INITIALE_DOCUMENT` date DEFAULT NULL,
  `IDENT_AMORT` varchar(32) NOT NULL DEFAULT '',
  `IDENT_PRET` varchar(32) NOT NULL DEFAULT '',
  `IDENT_LOC` varchar(32) NOT NULL DEFAULT '',
  `IDENT_CB` varchar(32) NOT NULL DEFAULT '',
  `IDENT_ABO_HA` varchar(32) NOT NULL DEFAULT '',
  `IDENT_ABO_VTE` varchar(32) NOT NULL DEFAULT '',
  `LIEN_DOCUMENT_ARCHIVE_LISTE` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_COMPTABILIT_ARCHIVE_DET`),
  KEY `A_LETTRER` (`A_LETTRER`) USING BTREE,
  KEY `A_LETTRER_PAR` (`A_LETTRER_PAR`) USING BTREE,
  KEY `BLOCAGE_ECRITURE` (`BLOCAGE_ECRITURE`) USING BTREE,
  KEY `CODE_JOURNAL` (`CODE_JOURNAL`) USING BTREE,
  KEY `CREDIT` (`CREDIT`) USING BTREE,
  KEY `DATE` (`DATE`) USING BTREE,
  KEY `DATEHEURE` (`DATEHEURE`) USING BTREE,
  KEY `DATE_CLOTURE_EXERCICE` (`DATE_CLOTURE_EXERCICE`) USING BTREE,
  KEY `DATE_ECHEANCE` (`DATE_ECHEANCE`) USING BTREE,
  KEY `DATE_LETTRAGE` (`DATE_LETTRAGE`) USING BTREE,
  KEY `DATE_TRESO` (`DATE_TRESO`) USING BTREE,
  KEY `DATE_VALIDATION_ECRITURE` (`DATE_VALIDATION_ECRITURE`) USING BTREE,
  KEY `DEBIT` (`DEBIT`) USING BTREE,
  KEY `ECRITURE_INITIALE_DET` (`ECRITURE_INITIALE_DET`) USING BTREE,
  KEY `ECRITURE_INITIALE_ET` (`ECRITURE_INITIALE_ET`) USING BTREE,
  KEY `ECRITURE_SITUATION_CUMULABLE` (`ECRITURE_SITUATION_CUMULABLE`) USING BTREE,
  KEY `IDENTIFICATION_TIERS` (`IDENTIFICATION_TIERS`) USING BTREE,
  KEY `IDENTIFICATION_VIREMENT` (`IDENTIFICATION_VIREMENT`) USING BTREE,
  KEY `IDENT_DOCUMENT_ARCHIVE` (`IDENT_DOCUMENT_ARCHIVE`) USING BTREE,
  KEY `IMPRESSION_LIGNE` (`IMPRESSION_LIGNE`) USING BTREE,
  KEY `LETTRAGE` (`LETTRAGE`) USING BTREE,
  KEY `LETTRAGE_1` (`LETTRAGE_1`) USING BTREE,
  KEY `LETTRAGE_CHIFFRE` (`LETTRAGE_CHIFFRE`) USING BTREE,
  KEY `LETTRAGE_CHIFFRE_1` (`LETTRAGE_CHIFFRE_1`) USING BTREE,
  KEY `NOM_DOSSIER` (`NOM_DOSSIER`) USING BTREE,
  KEY `NOM_JOURNAL` (`NOM_JOURNAL`) USING BTREE,
  KEY `NOM_TRESO` (`NOM_TRESO`) USING BTREE,
  KEY `N_CPTE_GENERAL` (`N_CPTE_GENERAL`) USING BTREE,
  KEY `N_CPTE_TIERS` (`N_CPTE_TIERS`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `N_EXERCICE` (`N_EXERCICE`) USING BTREE,
  KEY `N_IMPORT` (`N_IMPORT`) USING BTREE,
  KEY `N_LIGNE` (`N_LIGNE`) USING BTREE,
  KEY `N_PIECE` (`N_PIECE`) USING BTREE,
  KEY `N_PIECE_INTERNE` (`N_PIECE_INTERNE`) USING BTREE,
  KEY `N_PIECE_INTERNE_NUM` (`N_PIECE_INTERNE_NUM`) USING BTREE,
  KEY `N_PI_SPEC` (`N_PI_SPEC`) USING BTREE,
  KEY `N_TRESO` (`N_TRESO`) USING BTREE,
  KEY `N_TYPE_REGLEMENT` (`N_TYPE_REGLEMENT`) USING BTREE,
  KEY `PAYE` (`PAYE`) USING BTREE,
  KEY `PID_COMPTABILIT_ARCHIVE_ET` (`PID_COMPTABILIT_ARCHIVE_ET`) USING BTREE,
  KEY `RD` (`RD`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_LIEN_CONTEXTE_MAITRE` (`SYS_LIEN_CONTEXTE_MAITRE`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `TAUX_TVA` (`TAUX_TVA`) USING BTREE,
  KEY `TYPE_REGLEMENT` (`TYPE_REGLEMENT`) USING BTREE,
  KEY `TYPE_TVA_NUMERO` (`TYPE_TVA_NUMERO`) USING BTREE,
  KEY `VTF` (`VTF`) USING BTREE,
  KEY `DATE_INITIALE_DOCUMENT` (`DATE_INITIALE_DOCUMENT`) USING BTREE,
  KEY `IDENT_AMORT` (`IDENT_AMORT`) USING BTREE,
  KEY `IDENT_PRET` (`IDENT_PRET`) USING BTREE,
  KEY `IDENT_LOC` (`IDENT_LOC`) USING BTREE,
  KEY `IDENT_CB` (`IDENT_CB`) USING BTREE,
  KEY `IDENT_ABO_HA` (`IDENT_ABO_HA`) USING BTREE,
  KEY `IDENT_ABO_VTE` (`IDENT_ABO_VTE`) USING BTREE,
  KEY `N_ECRITURE` (`N_ECRITURE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `comptabilit_archive_et`
--

CREATE TABLE `comptabilit_archive_et` (
  `AFFECT_VALIDATION_PAR_DEFAUT_DOSSIER` char(1) NOT NULL DEFAULT '',
  `BLOCAGE_ECRITURE` char(1) NOT NULL DEFAULT '',
  `BLOCAGE_EXERCICE` char(1) NOT NULL DEFAULT '',
  `BLOCAGE_REGLEMENT` char(1) NOT NULL DEFAULT '',
  `BLOCAGE_VALIDATION` char(1) NOT NULL DEFAULT '',
  `CLOTURE_EXERCICE` char(1) NOT NULL DEFAULT '',
  `CODE_JOURNAL` varchar(10) NOT NULL DEFAULT '',
  `COMMENTAIRE` blob DEFAULT NULL,
  `COMPTAGE_TIERS` double NOT NULL DEFAULT 0,
  `CORPS_MESSAGE_VALIDATION` blob DEFAULT NULL,
  `CREDIT` decimal(20,2) NOT NULL DEFAULT 0.00,
  `CREDIT_ETR1` decimal(20,2) NOT NULL DEFAULT 0.00,
  `DATE` date DEFAULT NULL,
  `DATEHEURE` varchar(60) NOT NULL DEFAULT '',
  `DATE_CLOTURE_EXERCICE` date DEFAULT NULL,
  `DATE_ECHEANCE` date DEFAULT NULL,
  `DATE_ENVOYE` date DEFAULT NULL,
  `DATE_VALIDATION_ECRITURE` date DEFAULT NULL,
  `DEBIT` decimal(20,2) NOT NULL DEFAULT 0.00,
  `DEBIT_ETR1` decimal(20,2) NOT NULL DEFAULT 0.00,
  `DEVISE` double NOT NULL DEFAULT 0,
  `DEVISE_1` double NOT NULL DEFAULT 0,
  `DEVISE_2` double NOT NULL DEFAULT 0,
  `ECRITURE_DIRECTE` char(1) NOT NULL DEFAULT '',
  `ECRITURE_INITIALE_ET` varchar(32) NOT NULL DEFAULT '',
  `EXTOURNABLE` char(1) NOT NULL DEFAULT '',
  `HISTO` blob DEFAULT NULL,
  `IDENTIFICATION_CHEQUE` varchar(32) NOT NULL DEFAULT '',
  `IDENTIFICATION_MODELE` varchar(40) NOT NULL DEFAULT '',
  `IDENTIFICATION_PRELEVEMENT` varchar(32) NOT NULL DEFAULT '',
  `IDENTIFICATION_TRAITE` varchar(32) NOT NULL DEFAULT '',
  `IDENTIFICATION_VIREMENT` varchar(60) NOT NULL DEFAULT '',
  `IDENT_AMORT` varchar(32) NOT NULL DEFAULT '',
  `IDENT_DOCUMENT_ARCHIVE` varchar(40) NOT NULL DEFAULT '',
  `ID_COMPTABILIT_ARCHIVE_ET` varchar(32) NOT NULL DEFAULT '',
  `MEMO_BLOCAGE` blob DEFAULT NULL,
  `NB_ENVOI_VALID` double NOT NULL DEFAULT 0,
  `NOM_DOSSIER` varchar(50) NOT NULL DEFAULT '',
  `NOM_JOURNAL` varchar(50) NOT NULL DEFAULT '',
  `NOM_TRESO` varchar(10) NOT NULL DEFAULT '',
  `NOM_VALIDATEUR_PRINCIPAL_DOSSIER` varchar(32) NOT NULL DEFAULT '',
  `NOM_VALIDATEUR_SECONDAIRE_DOSSIER` varchar(32) NOT NULL DEFAULT '',
  `N_CPTE_TIERS` varchar(30) NOT NULL DEFAULT '',
  `N_DOSSIER` double NOT NULL DEFAULT 0,
  `N_ECRITURE` varchar(12) DEFAULT NULL,
  `N_ECRITURE_INITIALE` varchar(10) NOT NULL DEFAULT '',
  `N_EXERCICE` double NOT NULL DEFAULT 0,
  `N_IMPORT` varchar(15) NOT NULL DEFAULT '',
  `N_PIECE` varchar(20) NOT NULL DEFAULT '',
  `N_PIECE_INTERNE` varchar(20) NOT NULL DEFAULT '',
  `N_PIECE_INTERNE_NUM` varchar(20) NOT NULL DEFAULT '',
  `N_PI_SPEC` char(1) NOT NULL DEFAULT '',
  `N_TRESO` double NOT NULL DEFAULT 0,
  `N_TYPE_REGLEMENT` double NOT NULL DEFAULT 0,
  `RD` double NOT NULL DEFAULT 0,
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TOTAL_GED` double NOT NULL DEFAULT 0,
  `TVA_SPEC` char(1) NOT NULL DEFAULT '',
  `TX_CHANGE_12` double NOT NULL DEFAULT 0,
  `TX_CHANGE_21` double NOT NULL DEFAULT 0,
  `TYPE_REGLEMENT` varchar(20) NOT NULL DEFAULT '',
  `VERIF_CREDIT` double NOT NULL DEFAULT 0,
  `VERIF_DEBIT` double NOT NULL DEFAULT 0,
  `VERIF_ECART` double NOT NULL DEFAULT 0,
  `VIREMENT_INTERNE` char(1) NOT NULL DEFAULT '',
  `VTF` char(1) NOT NULL DEFAULT '',
  `CLOTURE_PARTIELLE` char(1) NOT NULL DEFAULT '',
  `DATE_CLOTURE_PARTIELLE` date DEFAULT NULL,
  `CODE_CLOTURE_PARTIELLE` varchar(10) NOT NULL DEFAULT '',
  `DATE_TRESO` date DEFAULT NULL,
  `COMPTAGE_LIGNE` decimal(12,0) NOT NULL DEFAULT 0,
  `IDENT_PRET` varchar(32) NOT NULL DEFAULT '',
  `IDENT_LOC` varchar(32) NOT NULL DEFAULT '',
  `IDENT_CB` varchar(32) NOT NULL DEFAULT '',
  `IDENT_ABO_HA` varchar(32) NOT NULL DEFAULT '',
  `IDENT_ABO_VTE` varchar(32) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_COMPTABILIT_ARCHIVE_ET`),
  KEY `AFFECT_VALIDATION_PAR_DEFAUT_DOSSIER` (`AFFECT_VALIDATION_PAR_DEFAUT_DOSSIER`) USING BTREE,
  KEY `BLOCAGE_ECRITURE` (`BLOCAGE_ECRITURE`) USING BTREE,
  KEY `BLOCAGE_EXERCICE` (`BLOCAGE_EXERCICE`) USING BTREE,
  KEY `BLOCAGE_REGLEMENT` (`BLOCAGE_REGLEMENT`) USING BTREE,
  KEY `BLOCAGE_VALIDATION` (`BLOCAGE_VALIDATION`) USING BTREE,
  KEY `CLOTURE_EXERCICE` (`CLOTURE_EXERCICE`) USING BTREE,
  KEY `CODE_JOURNAL` (`CODE_JOURNAL`) USING BTREE,
  KEY `CREDIT` (`CREDIT`) USING BTREE,
  KEY `DATE` (`DATE`) USING BTREE,
  KEY `DATEHEURE` (`DATEHEURE`) USING BTREE,
  KEY `DATE_CLOTURE_EXERCICE` (`DATE_CLOTURE_EXERCICE`) USING BTREE,
  KEY `DATE_ECHEANCE` (`DATE_ECHEANCE`) USING BTREE,
  KEY `DATE_ENVOYE` (`DATE_ENVOYE`) USING BTREE,
  KEY `DATE_VALIDATION_ECRITURE` (`DATE_VALIDATION_ECRITURE`) USING BTREE,
  KEY `DEBIT` (`DEBIT`) USING BTREE,
  KEY `ECRITURE_INITIALE_ET` (`ECRITURE_INITIALE_ET`) USING BTREE,
  KEY `IDENTIFICATION_MODELE` (`IDENTIFICATION_MODELE`) USING BTREE,
  KEY `IDENTIFICATION_VIREMENT` (`IDENTIFICATION_VIREMENT`) USING BTREE,
  KEY `IDENT_AMORT` (`IDENT_AMORT`) USING BTREE,
  KEY `IDENT_DOCUMENT_ARCHIVE` (`IDENT_DOCUMENT_ARCHIVE`) USING BTREE,
  KEY `NOM_DOSSIER` (`NOM_DOSSIER`) USING BTREE,
  KEY `NOM_JOURNAL` (`NOM_JOURNAL`) USING BTREE,
  KEY `NOM_TRESO` (`NOM_TRESO`) USING BTREE,
  KEY `NOM_VALIDATEUR_PRINCIPAL_DOSSIER` (`NOM_VALIDATEUR_PRINCIPAL_DOSSIER`) USING BTREE,
  KEY `NOM_VALIDATEUR_SECONDAIRE_DOSSIER` (`NOM_VALIDATEUR_SECONDAIRE_DOSSIER`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `N_ECRITURE_INITIALE` (`N_ECRITURE_INITIALE`) USING BTREE,
  KEY `N_EXERCICE` (`N_EXERCICE`) USING BTREE,
  KEY `N_IMPORT` (`N_IMPORT`) USING BTREE,
  KEY `N_PIECE` (`N_PIECE`) USING BTREE,
  KEY `N_PIECE_INTERNE` (`N_PIECE_INTERNE`) USING BTREE,
  KEY `N_PIECE_INTERNE_NUM` (`N_PIECE_INTERNE_NUM`) USING BTREE,
  KEY `N_TRESO` (`N_TRESO`) USING BTREE,
  KEY `N_TYPE_REGLEMENT` (`N_TYPE_REGLEMENT`) USING BTREE,
  KEY `RD` (`RD`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `TVA_SPEC` (`TVA_SPEC`) USING BTREE,
  KEY `TYPE_REGLEMENT` (`TYPE_REGLEMENT`) USING BTREE,
  KEY `VIREMENT_INTERNE` (`VIREMENT_INTERNE`) USING BTREE,
  KEY `VTF` (`VTF`) USING BTREE,
  KEY `CLOTURE_PARTIELLE` (`CLOTURE_PARTIELLE`) USING BTREE,
  KEY `DATE_TRESO` (`DATE_TRESO`) USING BTREE,
  KEY `IDENT_PRET` (`IDENT_PRET`) USING BTREE,
  KEY `IDENT_LOC` (`IDENT_LOC`) USING BTREE,
  KEY `IDENT_CB` (`IDENT_CB`) USING BTREE,
  KEY `IDENT_ABO_HA` (`IDENT_ABO_HA`) USING BTREE,
  KEY `IDENT_ABO_VTE` (`IDENT_ABO_VTE`) USING BTREE,
  KEY `N_ECRITURE` (`N_ECRITURE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`eglobalpro`@`%`*/ /*!50003 TRIGGER SVT_JOUR_DATE_ECHEANCE BEFORE INSERT ON comptabilit_det
FOR EACH ROW
SET new.JOUR_DATE_ECHEANCE=EXTRACT(DAY FROM new.DATE_TRESO) */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`eglobalpro`@`%`*/ /*!50003 TRIGGER SVT_update_compta_det BEFORE INSERT ON comptabilit_det
FOR EACH ROW
SET new.LIEN_DOCUMENT_ARCHIVE_LISTE=ifnull( 
(SELECT max(d.LIEN_DOCUMENT_ARCHIVE)                                       
FROM document_archive d 
where new.PID_COMPTABILIT_ET = d.PID_COMPTABILIT_ET 
AND PID_COMPTABILIT_ET !=''), new.LIEN_DOCUMENT_ARCHIVE_LISTE) */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`eglobalpro`@`%`*/ /*!50003 TRIGGER SVT_ECRITURE_INITIALE_SYS BEFORE INSERT ON comptabilit_det
FOR EACH ROW
SET new.ECRITURE_INITIALE_SYS=if((new.CODE_JOURNAL='HA' or new.CODE_JOURNAL='VTES' or new.CODE_JOURNAL='OD') and new.LIBELLE NOT LIKE '%Ventilation AN%' and new.N_CPTE_TIERS<>'' and new.ECRITURE_INITIALE_SYS='',new.ID_COMPTABILIT_DET,new.ECRITURE_INITIALE_SYS) */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`eglobalpro`@`%`*/ /*!50003 TRIGGER SVT_N_EXERCICE_SYS BEFORE INSERT ON comptabilit_det
FOR EACH ROW
SET new.N_EXERCICE_SYS=if((new.CODE_JOURNAL='HA' or new.CODE_JOURNAL='VTES' or new.CODE_JOURNAL='OD') and new.LIBELLE NOT LIKE '%Ventilation AN%' and new.N_CPTE_TIERS<>'' and new.N_EXERCICE_SYS='',new.N_EXERCICE,new.N_EXERCICE_SYS) */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`eglobalpro`@`%`*/ /*!50003 TRIGGER SVT_JOUR_DATE_ECHEANCE_UP BEFORE UPDATE ON comptabilit_det
FOR EACH ROW
SET new.JOUR_DATE_ECHEANCE=EXTRACT(DAY FROM new.DATE_TRESO) */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`eglobalpro`@`%`*/ /*!50003 TRIGGER SVT_ECRITURE_INITIALE_SYS_UP BEFORE UPDATE ON comptabilit_det
FOR EACH ROW
SET new.ECRITURE_INITIALE_SYS=if((new.CODE_JOURNAL='HA' or new.CODE_JOURNAL='VTES' or new.CODE_JOURNAL='OD') and new.LIBELLE NOT LIKE '%Ventilation AN%' and new.N_CPTE_TIERS<>'' and new.ECRITURE_INITIALE_SYS='',new.ID_COMPTABILIT_DET,new.ECRITURE_INITIALE_SYS) */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`eglobalpro`@`%`*/ /*!50003 TRIGGER SVT_N_EXERCICE_SYS_UP BEFORE UPDATE ON comptabilit_det
FOR EACH ROW
SET new.N_EXERCICE_SYS=if((new.CODE_JOURNAL='HA' or new.CODE_JOURNAL='VTES' or new.CODE_JOURNAL='OD') and new.LIBELLE NOT LIKE '%Ventilation AN%' and new.N_CPTE_TIERS<>'' and new.N_EXERCICE_SYS='',new.N_EXERCICE,new.N_EXERCICE_SYS) */;;
DELIMITER ;

--
-- Table structure for table `comptabilit_et`
--

CREATE TABLE `comptabilit_et` (
  `BLOCAGE_ECRITURE` char(1) NOT NULL DEFAULT '',
  `BLOCAGE_EXERCICE` char(1) NOT NULL DEFAULT '',
  `BLOCAGE_REGLEMENT` char(1) NOT NULL DEFAULT '',
  `BLOCAGE_VALIDATION` char(1) NOT NULL DEFAULT '',
  `CLOTURE_EXERCICE` char(1) NOT NULL DEFAULT '',
  `CODE_JOURNAL` varchar(10) NOT NULL DEFAULT '',
  `CREDIT` decimal(20,2) NOT NULL DEFAULT 0.00,
  `DATE` date DEFAULT NULL,
  `DATEHEURE` varchar(60) NOT NULL DEFAULT '',
  `DATE_CLOTURE_EXERCICE` date DEFAULT NULL,
  `DATE_ECHEANCE` date DEFAULT NULL,
  `DATE_ENVOYE` date DEFAULT NULL,
  `DATE_VALIDATION_ECRITURE` date DEFAULT NULL,
  `DEBIT` decimal(20,2) NOT NULL DEFAULT 0.00,
  `ECRITURE_DIRECTE` char(1) NOT NULL DEFAULT '',
  `ECRITURE_INITIALE_ET` varchar(32) NOT NULL DEFAULT '',
  `EXTOURNABLE` char(1) NOT NULL DEFAULT '',
  `IDENTIFICATION_MODELE` varchar(40) NOT NULL DEFAULT '',
  `IDENTIFICATION_VIREMENT` varchar(60) NOT NULL DEFAULT '',
  `ID_COMPTABILIT_ET` varchar(32) NOT NULL DEFAULT '',
  `NOM_DOSSIER` varchar(50) NOT NULL DEFAULT '',
  `NOM_JOURNAL` varchar(50) NOT NULL DEFAULT '',
  `NOM_TRESO` varchar(10) NOT NULL DEFAULT '',
  `N_DOSSIER` double NOT NULL DEFAULT 0,
  `N_ECRITURE` varchar(12) DEFAULT NULL,
  `N_ECRITURE_INITIALE` varchar(10) NOT NULL DEFAULT '',
  `N_EXERCICE` double NOT NULL DEFAULT 0,
  `N_PIECE` varchar(20) NOT NULL DEFAULT '',
  `N_PIECE_INTERNE` varchar(20) NOT NULL DEFAULT '',
  `N_TRESO` double NOT NULL DEFAULT 0,
  `N_TYPE_REGLEMENT` double NOT NULL DEFAULT 0,
  `RD` double NOT NULL DEFAULT 0,
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TYPE_REGLEMENT` varchar(20) NOT NULL DEFAULT '',
  `VERIF_CREDIT` double NOT NULL DEFAULT 0,
  `VERIF_DEBIT` double NOT NULL DEFAULT 0,
  `VERIF_ECART` double NOT NULL DEFAULT 0,
  `VIREMENT_INTERNE` char(1) NOT NULL DEFAULT '',
  `VTF` char(1) NOT NULL DEFAULT '',
  `COMMENTAIRE` blob DEFAULT NULL,
  `TVA_SPEC` char(1) NOT NULL DEFAULT '',
  `IDENT_AMORT` varchar(32) NOT NULL DEFAULT '',
  `IDENT_DOCUMENT_ARCHIVE` varchar(40) NOT NULL DEFAULT '',
  `MEMO_BLOCAGE` blob DEFAULT NULL,
  `HISTO` blob DEFAULT NULL,
  `CORPS_MESSAGE_VALIDATION` blob DEFAULT NULL,
  `TOTAL_GED` double NOT NULL DEFAULT 0,
  `COMPTAGE_TIERS` double NOT NULL DEFAULT 0,
  `CREDIT_ETR1` decimal(20,2) NOT NULL DEFAULT 0.00,
  `DEBIT_ETR1` decimal(20,2) NOT NULL DEFAULT 0.00,
  `DEVISE` double NOT NULL DEFAULT 0,
  `DEVISE_1` double NOT NULL DEFAULT 0,
  `DEVISE_2` double NOT NULL DEFAULT 0,
  `IDENTIFICATION_CHEQUE` varchar(32) NOT NULL DEFAULT '',
  `IDENTIFICATION_PRELEVEMENT` varchar(32) NOT NULL DEFAULT '',
  `IDENTIFICATION_TRAITE` varchar(32) NOT NULL DEFAULT '',
  `N_CPTE_TIERS` varchar(30) NOT NULL DEFAULT '',
  `TX_CHANGE_12` double NOT NULL DEFAULT 0,
  `TX_CHANGE_21` double NOT NULL DEFAULT 0,
  `N_IMPORT` varchar(15) NOT NULL DEFAULT '',
  `NOM_VALIDATEUR_PRINCIPAL_DOSSIER` varchar(32) NOT NULL DEFAULT '',
  `NOM_VALIDATEUR_SECONDAIRE_DOSSIER` varchar(32) NOT NULL DEFAULT '',
  `AFFECT_VALIDATION_PAR_DEFAUT_DOSSIER` char(1) NOT NULL DEFAULT '',
  `NB_ENVOI_VALID` double NOT NULL DEFAULT 0,
  `N_PI_SPEC` char(1) NOT NULL DEFAULT '',
  `N_PIECE_INTERNE_NUM` varchar(20) NOT NULL DEFAULT '',
  `CLOTURE_PARTIELLE` char(1) NOT NULL DEFAULT '',
  `DATE_CLOTURE_PARTIELLE` date DEFAULT NULL,
  `CODE_CLOTURE_PARTIELLE` varchar(10) NOT NULL DEFAULT '',
  `DATE_TRESO` date DEFAULT NULL,
  `COMPTAGE_LIGNE` decimal(12,0) NOT NULL DEFAULT 0,
  `IDENT_PRET` varchar(36) NOT NULL DEFAULT '',
  `IDENT_LOC` varchar(36) NOT NULL DEFAULT '',
  `IDENT_CB` varchar(36) NOT NULL DEFAULT '',
  `IDENT_ABO_HA` varchar(36) NOT NULL DEFAULT '',
  `IDENT_ABO_VTE` varchar(36) NOT NULL DEFAULT '',
  `N_ECRITURE_FEC_IMPORT` varchar(32) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_COMPTABILIT_ET`),
  KEY `BLOCAGE_ECRITURE` (`BLOCAGE_ECRITURE`) USING BTREE,
  KEY `BLOCAGE_EXERCICE` (`BLOCAGE_EXERCICE`) USING BTREE,
  KEY `BLOCAGE_REGLEMENT` (`BLOCAGE_REGLEMENT`) USING BTREE,
  KEY `BLOCAGE_VALIDATION` (`BLOCAGE_VALIDATION`) USING BTREE,
  KEY `CLOTURE_EXERCICE` (`CLOTURE_EXERCICE`) USING BTREE,
  KEY `CODE_JOURNAL` (`CODE_JOURNAL`) USING BTREE,
  KEY `DATE` (`DATE`) USING BTREE,
  KEY `DATEHEURE` (`DATEHEURE`) USING BTREE,
  KEY `DATE_CLOTURE_EXERCICE` (`DATE_CLOTURE_EXERCICE`) USING BTREE,
  KEY `DATE_ECHEANCE` (`DATE_ECHEANCE`) USING BTREE,
  KEY `DATE_ENVOYE` (`DATE_ENVOYE`) USING BTREE,
  KEY `DATE_VALIDATION_ECRITURE` (`DATE_VALIDATION_ECRITURE`) USING BTREE,
  KEY `ECRITURE_INITIALE_ET` (`ECRITURE_INITIALE_ET`) USING BTREE,
  KEY `IDENTIFICATION_VIREMENT` (`IDENTIFICATION_VIREMENT`) USING BTREE,
  KEY `NOM_DOSSIER` (`NOM_DOSSIER`) USING BTREE,
  KEY `NOM_JOURNAL` (`NOM_JOURNAL`) USING BTREE,
  KEY `NOM_TRESO` (`NOM_TRESO`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `N_ECRITURE_INITIALE` (`N_ECRITURE_INITIALE`) USING BTREE,
  KEY `N_EXERCICE` (`N_EXERCICE`) USING BTREE,
  KEY `N_PIECE` (`N_PIECE`) USING BTREE,
  KEY `N_PIECE_INTERNE` (`N_PIECE_INTERNE`) USING BTREE,
  KEY `N_TRESO` (`N_TRESO`) USING BTREE,
  KEY `N_TYPE_REGLEMENT` (`N_TYPE_REGLEMENT`) USING BTREE,
  KEY `RD` (`RD`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `VIREMENT_INTERNE` (`VIREMENT_INTERNE`) USING BTREE,
  KEY `VTF` (`VTF`) USING BTREE,
  KEY `TVA_SPEC` (`TVA_SPEC`) USING BTREE,
  KEY `IDENTIFICATION_MODELE` (`IDENTIFICATION_MODELE`) USING BTREE,
  KEY `CREDIT` (`CREDIT`) USING BTREE,
  KEY `DEBIT` (`DEBIT`) USING BTREE,
  KEY `IDENT_DOCUMENT_ARCHIVE` (`IDENT_DOCUMENT_ARCHIVE`) USING BTREE,
  KEY `TYPE_REGLEMENT` (`TYPE_REGLEMENT`) USING BTREE,
  KEY `N_IMPORT` (`N_IMPORT`) USING BTREE,
  KEY `NOM_VALIDATEUR_PRINCIPAL_DOSSIER` (`NOM_VALIDATEUR_PRINCIPAL_DOSSIER`) USING BTREE,
  KEY `NOM_VALIDATEUR_SECONDAIRE_DOSSIER` (`NOM_VALIDATEUR_SECONDAIRE_DOSSIER`) USING BTREE,
  KEY `AFFECT_VALIDATION_PAR_DEFAUT_DOSSIER` (`AFFECT_VALIDATION_PAR_DEFAUT_DOSSIER`) USING BTREE,
  KEY `N_PIECE_INTERNE_NUM` (`N_PIECE_INTERNE_NUM`) USING BTREE,
  KEY `CLOTURE_PARTIELLE` (`CLOTURE_PARTIELLE`) USING BTREE,
  KEY `DATE_TRESO` (`DATE_TRESO`) USING BTREE,
  KEY `N_ECRITURE` (`N_ECRITURE`) USING BTREE,
  KEY `IDENT_PRET` (`IDENT_PRET`) USING BTREE,
  KEY `IDENT_LOC` (`IDENT_LOC`) USING BTREE,
  KEY `IDENT_CB` (`IDENT_CB`) USING BTREE,
  KEY `IDENT_ABO_HA` (`IDENT_ABO_HA`) USING BTREE,
  KEY `IDENT_ABO_VTE` (`IDENT_ABO_VTE`) USING BTREE,
  KEY `IDENT_AMORT` (`IDENT_AMORT`) USING BTREE,
  KEY `IC_EGP_SUPPRESSION_ET` (`N_DOSSIER`,`SYS_USER_CREATION`,`COMPTAGE_LIGNE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `comptabilit_facto`
--

CREATE TABLE `comptabilit_facto` (
  `COMMENTAIRES` varchar(100) NOT NULL DEFAULT '',
  `DATE_DOC` date DEFAULT NULL,
  `DATE_ECH` date DEFAULT NULL,
  `ID_COMPTABILIT_FACTO` varchar(32) NOT NULL DEFAULT '',
  `MODE_RGT` varchar(10) NOT NULL DEFAULT '',
  `MONTANT_DOC` double NOT NULL DEFAULT 0,
  `NOM_ACHETEUR` varchar(100) NOT NULL DEFAULT '',
  `NOM_DOSSIER` varchar(50) NOT NULL DEFAULT '',
  `NUMERO` varchar(15) NOT NULL DEFAULT '',
  `NUM_CPTE_CLIENT` varchar(10) NOT NULL DEFAULT '',
  `NUM_DOC` varchar(10) NOT NULL DEFAULT '',
  `N_DOSSIER` double NOT NULL DEFAULT 0,
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TYPE_DOC` varchar(10) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_COMPTABILIT_FACTO`),
  KEY `DATE_DOC` (`DATE_DOC`) USING BTREE,
  KEY `DATE_ECH` (`DATE_ECH`) USING BTREE,
  KEY `MODE_RGT` (`MODE_RGT`) USING BTREE,
  KEY `MONTANT_DOC` (`MONTANT_DOC`) USING BTREE,
  KEY `NOM_ACHETEUR` (`NOM_ACHETEUR`) USING BTREE,
  KEY `NUM_CPTE_CLIENT` (`NUM_CPTE_CLIENT`) USING BTREE,
  KEY `NUM_DOC` (`NUM_DOC`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `TYPE_DOC` (`TYPE_DOC`) USING BTREE,
  KEY `NUMERO` (`NUMERO`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `comptabilit_situation_det`
--

CREATE TABLE `comptabilit_situation_det` (
  `BLOCAGE_MODELE` char(1) NOT NULL DEFAULT '',
  `CODE_JOURNAL` varchar(50) NOT NULL DEFAULT '',
  `CREDIT` double NOT NULL DEFAULT 0,
  `DATE` date DEFAULT NULL,
  `DATE_ECHEANCE` date DEFAULT NULL,
  `DEBIT` double NOT NULL DEFAULT 0,
  `IDENTIFICATION_TIERS` varchar(32) NOT NULL DEFAULT '',
  `IDENTIFICATION_TIERS_ECRITURE_ID` varchar(32) NOT NULL DEFAULT '',
  `IDENTIFICATION_TIERS_ECRITURE_N_COMPTE_TIERS` varchar(100) NOT NULL DEFAULT '',
  `ID_COMPTABILIT_SITUATION_DET` varchar(32) NOT NULL DEFAULT '',
  `LIBELLE` varchar(100) NOT NULL DEFAULT '',
  `MOIS_ECRITURE` varchar(5) NOT NULL DEFAULT '',
  `MOIS_TRESO` varchar(5) NOT NULL DEFAULT '',
  `MOIS_TVA` varchar(5) NOT NULL DEFAULT '',
  `NOM_COMPTE_GENERAL` varchar(100) NOT NULL DEFAULT '',
  `NOM_DOSSIER` varchar(20) NOT NULL DEFAULT '',
  `NOM_JOURNAL` varchar(20) NOT NULL DEFAULT '',
  `NOM_TRESO` varchar(20) NOT NULL DEFAULT '',
  `N_CPTE_GENERAL` varchar(8) NOT NULL DEFAULT '',
  `N_CPTE_TIERS` varchar(200) NOT NULL DEFAULT '',
  `N_DOSSIER` double NOT NULL DEFAULT 0,
  `N_ECRITURE` varchar(10) NOT NULL DEFAULT '',
  `N_PIECE` varchar(15) NOT NULL DEFAULT '',
  `N_PIECE_INTERNE` varchar(10) NOT NULL DEFAULT '',
  `N_TRESO` double NOT NULL DEFAULT 0,
  `N_TYPE_REGLEMENT` varchar(20) NOT NULL DEFAULT '',
  `PID_COMPTABILIT_SITUATION_ET` varchar(32) NOT NULL DEFAULT '',
  `RD` double NOT NULL DEFAULT 0,
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TX_TVA` double NOT NULL DEFAULT 0,
  `TYPE_REGLEMENT` varchar(20) NOT NULL DEFAULT '',
  `TYPE_TVA_LIBELLE` varchar(20) NOT NULL DEFAULT '',
  `VTF` char(1) NOT NULL DEFAULT '',
  `IDENTIFICATION_N_CPTE_GENERAL` varchar(32) NOT NULL DEFAULT '',
  `N_EXERCICE` double NOT NULL DEFAULT 0,
  `DATEHEURE` varchar(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_COMPTABILIT_SITUATION_DET`),
  KEY `BLOCAGE_MODELE` (`BLOCAGE_MODELE`) USING BTREE,
  KEY `IDENTIFICATION_TIERS` (`IDENTIFICATION_TIERS`) USING BTREE,
  KEY `MOIS_TRESO` (`MOIS_TRESO`) USING BTREE,
  KEY `MOIS_TVA` (`MOIS_TVA`) USING BTREE,
  KEY `NOM_DOSSIER` (`NOM_DOSSIER`) USING BTREE,
  KEY `NOM_JOURNAL` (`NOM_JOURNAL`) USING BTREE,
  KEY `NOM_TRESO` (`NOM_TRESO`) USING BTREE,
  KEY `N_CPTE_GENERAL` (`N_CPTE_GENERAL`) USING BTREE,
  KEY `N_CPTE_TIERS` (`N_CPTE_TIERS`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `N_PIECE` (`N_PIECE`) USING BTREE,
  KEY `N_PIECE_INTERNE` (`N_PIECE_INTERNE`) USING BTREE,
  KEY `N_TRESO` (`N_TRESO`) USING BTREE,
  KEY `N_TYPE_REGLEMENT` (`N_TYPE_REGLEMENT`) USING BTREE,
  KEY `PID_COMPTABILIT_SITUATION_ET` (`PID_COMPTABILIT_SITUATION_ET`) USING BTREE,
  KEY `RD` (`RD`) USING BTREE,
  KEY `TYPE_REGLEMENT` (`TYPE_REGLEMENT`) USING BTREE,
  KEY `TYPE_TVA_LIBELLE` (`TYPE_TVA_LIBELLE`) USING BTREE,
  KEY `VTF` (`VTF`) USING BTREE,
  KEY `N_EXERCICE` (`N_EXERCICE`) USING BTREE,
  KEY `IDENTIFICATION_N_CPTE_GENERAL` (`IDENTIFICATION_N_CPTE_GENERAL`) USING BTREE,
  KEY `DATEHEURE` (`DATEHEURE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `comptabilit_situation_et`
--

CREATE TABLE `comptabilit_situation_et` (
  `CODE_JOURNAL` varchar(10) NOT NULL DEFAULT '',
  `CREDIT` decimal(12,2) NOT NULL DEFAULT 0.00,
  `DATE` date DEFAULT NULL,
  `DATEHEURE` varchar(60) NOT NULL DEFAULT '',
  `DATE_ECHEANCE` date DEFAULT NULL,
  `DATE_TRANSFERT` date DEFAULT NULL,
  `DEBIT` decimal(12,2) NOT NULL DEFAULT 0.00,
  `ECRITURE_SITUATION_CUMULABLE` char(1) NOT NULL DEFAULT '',
  `ID_COMPTABILIT_SITUATION_ET` varchar(32) NOT NULL DEFAULT '',
  `LIBELLE` varchar(100) NOT NULL DEFAULT '',
  `M1` double NOT NULL DEFAULT 0,
  `M10` double NOT NULL DEFAULT 0,
  `M10P` double NOT NULL DEFAULT 0,
  `M10PC` char(1) NOT NULL DEFAULT '',
  `M10R` double NOT NULL DEFAULT 0,
  `M10RC` char(1) NOT NULL DEFAULT '',
  `M11` double NOT NULL DEFAULT 0,
  `M11P` double NOT NULL DEFAULT 0,
  `M11PC` char(1) NOT NULL DEFAULT '',
  `M11R` double NOT NULL DEFAULT 0,
  `M11RC` char(1) NOT NULL DEFAULT '',
  `M12` double NOT NULL DEFAULT 0,
  `M12P` double NOT NULL DEFAULT 0,
  `M12PC` char(1) NOT NULL DEFAULT '',
  `M12R` double NOT NULL DEFAULT 0,
  `M12RC` char(1) NOT NULL DEFAULT '',
  `M1P` double NOT NULL DEFAULT 0,
  `M1PC` char(1) NOT NULL DEFAULT '',
  `M1R` double NOT NULL DEFAULT 0,
  `M1RC` char(1) NOT NULL DEFAULT '',
  `M2` double NOT NULL DEFAULT 0,
  `M2P` double NOT NULL DEFAULT 0,
  `M2PC` char(1) NOT NULL DEFAULT '',
  `M2R` double NOT NULL DEFAULT 0,
  `M2RC` char(1) NOT NULL DEFAULT '',
  `M3` double NOT NULL DEFAULT 0,
  `M3P` double NOT NULL DEFAULT 0,
  `M3PC` char(1) NOT NULL DEFAULT '',
  `M3R` double NOT NULL DEFAULT 0,
  `M3RC` char(1) NOT NULL DEFAULT '',
  `M4` double NOT NULL DEFAULT 0,
  `M4P` double NOT NULL DEFAULT 0,
  `M4PC` char(1) NOT NULL DEFAULT '',
  `M4R` double NOT NULL DEFAULT 0,
  `M4RC` char(1) NOT NULL DEFAULT '',
  `M5` double NOT NULL DEFAULT 0,
  `M5P` double NOT NULL DEFAULT 0,
  `M5PC` char(1) NOT NULL DEFAULT '',
  `M5R` double NOT NULL DEFAULT 0,
  `M5RC` char(1) NOT NULL DEFAULT '',
  `M6` double NOT NULL DEFAULT 0,
  `M6P` double NOT NULL DEFAULT 0,
  `M6PC` char(1) NOT NULL DEFAULT '',
  `M6R` double NOT NULL DEFAULT 0,
  `M6RC` char(1) NOT NULL DEFAULT '',
  `M7` double NOT NULL DEFAULT 0,
  `M7P` double NOT NULL DEFAULT 0,
  `M7PC` char(1) NOT NULL DEFAULT '',
  `M7R` double NOT NULL DEFAULT 0,
  `M7RC` char(1) NOT NULL DEFAULT '',
  `M8` double NOT NULL DEFAULT 0,
  `M8P` double NOT NULL DEFAULT 0,
  `M8PC` char(1) NOT NULL DEFAULT '',
  `M8R` double NOT NULL DEFAULT 0,
  `M8RC` char(1) NOT NULL DEFAULT '',
  `M9` double NOT NULL DEFAULT 0,
  `M9P` double NOT NULL DEFAULT 0,
  `M9PC` char(1) NOT NULL DEFAULT '',
  `M9R` double NOT NULL DEFAULT 0,
  `M9RC` char(1) NOT NULL DEFAULT '',
  `MONTANT` double NOT NULL DEFAULT 0,
  `NOM_DOSSIER` varchar(50) NOT NULL DEFAULT '',
  `NOM_ECRITURE_SITUATION` varchar(100) NOT NULL DEFAULT '',
  `NOM_JOURNAL` varchar(20) NOT NULL DEFAULT '',
  `NOM_TRESO` varchar(20) NOT NULL DEFAULT '',
  `N_CPTE_GENERAL_CREDIT` varchar(10) NOT NULL DEFAULT '',
  `N_CPTE_GENERAL_DEBIT` varchar(10) NOT NULL DEFAULT '',
  `N_CPTE_TIERS` varchar(100) NOT NULL DEFAULT '',
  `N_DOSSIER` double NOT NULL DEFAULT 0,
  `N_TRESO` double NOT NULL DEFAULT 0,
  `PERIODICITE` varchar(10) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TRANSFERT_GROUPE` char(1) NOT NULL DEFAULT '',
  `DEBUT_EX_PERIO` date DEFAULT NULL,
  `FIN_EX_PERIO` date DEFAULT NULL,
  `MEMO` blob DEFAULT NULL,
  `N_EXERCICE` double NOT NULL DEFAULT 0,
  `ANALYTIQUE` char(1) NOT NULL DEFAULT '',
  `ANS1` double NOT NULL DEFAULT 0,
  `ANS10` double NOT NULL DEFAULT 0,
  `ANS11` double NOT NULL DEFAULT 0,
  `ANS12` double NOT NULL DEFAULT 0,
  `ANS13` double NOT NULL DEFAULT 0,
  `ANS2` double NOT NULL DEFAULT 0,
  `ANS3` double NOT NULL DEFAULT 0,
  `ANS4` double NOT NULL DEFAULT 0,
  `ANS5` double NOT NULL DEFAULT 0,
  `ANS6` double NOT NULL DEFAULT 0,
  `ANS7` double NOT NULL DEFAULT 0,
  `ANS8` double NOT NULL DEFAULT 0,
  `ANS9` double NOT NULL DEFAULT 0,
  `N_ECRITURE` varchar(15) NOT NULL DEFAULT '',
  `TYPE_ECRITURE_SITUATION` varchar(40) NOT NULL DEFAULT '',
  `N_TYPE_ECRITURE_SITUATION` decimal(12,0) NOT NULL DEFAULT 0,
  PRIMARY KEY (`ID_COMPTABILIT_SITUATION_ET`),
  KEY `DATE` (`DATE`) USING BTREE,
  KEY `DATEHEURE` (`DATEHEURE`) USING BTREE,
  KEY `DATE_ECHEANCE` (`DATE_ECHEANCE`) USING BTREE,
  KEY `DATE_TRANSFERT` (`DATE_TRANSFERT`) USING BTREE,
  KEY `ECRITURE_SITUATION_CUMULABLE` (`ECRITURE_SITUATION_CUMULABLE`) USING BTREE,
  KEY `NOM_JOURNAL` (`NOM_JOURNAL`) USING BTREE,
  KEY `NOM_TRESO` (`NOM_TRESO`) USING BTREE,
  KEY `N_CPTE_GENERAL_CREDIT` (`N_CPTE_GENERAL_CREDIT`) USING BTREE,
  KEY `N_CPTE_GENERAL_DEBIT` (`N_CPTE_GENERAL_DEBIT`) USING BTREE,
  KEY `N_CPTE_TIERS` (`N_CPTE_TIERS`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `N_TRESO` (`N_TRESO`) USING BTREE,
  KEY `PERIODICITE` (`PERIODICITE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `TRANSFERT_GROUPE` (`TRANSFERT_GROUPE`) USING BTREE,
  KEY `DEBUT_EX_PERIO` (`DEBUT_EX_PERIO`) USING BTREE,
  KEY `FIN_EX_PERIO` (`FIN_EX_PERIO`) USING BTREE,
  KEY `NOM_DOSSIER` (`NOM_DOSSIER`) USING BTREE,
  KEY `N_ECRITURE` (`N_ECRITURE`) USING BTREE,
  KEY `N_TYPE_ECRITURE_SITUATION` (`N_TYPE_ECRITURE_SITUATION`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `comptabilite_modele_det`
--

CREATE TABLE `comptabilite_modele_det` (
  `BLOCAGE_MODELE` char(1) NOT NULL DEFAULT '',
  `CODE_JOURNAL` varchar(50) NOT NULL DEFAULT '',
  `CREDIT` decimal(20,2) NOT NULL DEFAULT 0.00,
  `DATE` date DEFAULT NULL,
  `DATE_ECHEANCE` date DEFAULT NULL,
  `DEBIT` decimal(20,2) NOT NULL DEFAULT 0.00,
  `IDENTIFICATION_TIERS` varchar(32) NOT NULL DEFAULT '',
  `IDENTIFICATION_TIERS_ECRITURE_ID` varchar(32) NOT NULL DEFAULT '',
  `IDENTIFICATION_TIERS_ECRITURE_N_COMPTE_TIERS` varchar(100) NOT NULL DEFAULT '',
  `ID_COMPTABILITE_MODELE_DET` varchar(32) NOT NULL DEFAULT '',
  `LIBELLE` varchar(100) NOT NULL DEFAULT '',
  `MOIS_ECRITURE` varchar(5) NOT NULL DEFAULT '',
  `MOIS_TRESO` varchar(5) NOT NULL DEFAULT '',
  `MOIS_TVA` varchar(5) NOT NULL DEFAULT '',
  `NOM_COMPTE_GENERAL` varchar(100) NOT NULL DEFAULT '',
  `NOM_DOSSIER` varchar(50) NOT NULL DEFAULT '',
  `NOM_JOURNAL` varchar(20) NOT NULL DEFAULT '',
  `NOM_TRESO` varchar(20) NOT NULL DEFAULT '',
  `N_CPTE_GENERAL` varchar(8) NOT NULL DEFAULT '',
  `N_CPTE_TIERS` varchar(200) NOT NULL DEFAULT '',
  `N_DOSSIER` double NOT NULL DEFAULT 0,
  `N_ECRITURE` varchar(10) NOT NULL DEFAULT '',
  `N_PIECE` varchar(15) NOT NULL DEFAULT '',
  `N_PIECE_INTERNE` varchar(10) NOT NULL DEFAULT '',
  `N_TRESO` double NOT NULL DEFAULT 0,
  `N_TYPE_REGLEMENT` varchar(20) NOT NULL DEFAULT '',
  `PID_COMPTABILITE_MODELE_ET` varchar(32) NOT NULL DEFAULT '',
  `RD` double NOT NULL DEFAULT 0,
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TX_TVA` double NOT NULL DEFAULT 0,
  `TYPE_REGLEMENT` varchar(20) NOT NULL DEFAULT '',
  `TYPE_TVA_LIBELLE` varchar(20) NOT NULL DEFAULT '',
  `VTF` char(1) NOT NULL DEFAULT '',
  `TYPE_TVA_NUMERO` double NOT NULL DEFAULT 0,
  `N_LIGNE_INFO_COMPTA` double NOT NULL DEFAULT 0,
  `EXTOURNABLE` char(1) NOT NULL DEFAULT '',
  `ANS1` double NOT NULL DEFAULT 0,
  `ANS10` double NOT NULL DEFAULT 0,
  `ANS11` double NOT NULL DEFAULT 0,
  `ANS12` double NOT NULL DEFAULT 0,
  `ANS13` double NOT NULL DEFAULT 0,
  `ANS14` double NOT NULL DEFAULT 0,
  `ANS15` double NOT NULL DEFAULT 0,
  `ANS16` double NOT NULL DEFAULT 0,
  `ANS17` double NOT NULL DEFAULT 0,
  `ANS18` double NOT NULL DEFAULT 0,
  `ANS19` double NOT NULL DEFAULT 0,
  `ANS2` double NOT NULL DEFAULT 0,
  `ANS20` double NOT NULL DEFAULT 0,
  `ANS3` double NOT NULL DEFAULT 0,
  `ANS4` double NOT NULL DEFAULT 0,
  `ANS5` double NOT NULL DEFAULT 0,
  `ANS6` double NOT NULL DEFAULT 0,
  `ANS7` double NOT NULL DEFAULT 0,
  `ANS8` double NOT NULL DEFAULT 0,
  `ANS9` double NOT NULL DEFAULT 0,
  `CREDIT_ETR1` decimal(12,2) NOT NULL DEFAULT 0.00,
  `DEBIT_ETR1` decimal(12,2) NOT NULL DEFAULT 0.00,
  `PERIO_DEBUT` date DEFAULT NULL,
  `PERIO_FIN` date DEFAULT NULL,
  `TOTAL_ANA` double NOT NULL DEFAULT 0,
  `ECRITURE_DIRECTE` char(1) NOT NULL DEFAULT '',
  `L_TVA` char(1) NOT NULL DEFAULT '',
  `ANS_MAN` char(1) NOT NULL DEFAULT '',
  `DATE_TRESO` date DEFAULT NULL,
  PRIMARY KEY (`ID_COMPTABILITE_MODELE_DET`),
  KEY `BLOCAGE_MODELE` (`BLOCAGE_MODELE`) USING BTREE,
  KEY `IDENTIFICATION_TIERS` (`IDENTIFICATION_TIERS`) USING BTREE,
  KEY `MOIS_TRESO` (`MOIS_TRESO`) USING BTREE,
  KEY `MOIS_TVA` (`MOIS_TVA`) USING BTREE,
  KEY `NOM_JOURNAL` (`NOM_JOURNAL`) USING BTREE,
  KEY `NOM_TRESO` (`NOM_TRESO`) USING BTREE,
  KEY `N_CPTE_GENERAL` (`N_CPTE_GENERAL`) USING BTREE,
  KEY `N_CPTE_TIERS` (`N_CPTE_TIERS`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `N_PIECE` (`N_PIECE`) USING BTREE,
  KEY `N_PIECE_INTERNE` (`N_PIECE_INTERNE`) USING BTREE,
  KEY `N_TRESO` (`N_TRESO`) USING BTREE,
  KEY `N_TYPE_REGLEMENT` (`N_TYPE_REGLEMENT`) USING BTREE,
  KEY `PID_COMPTABILITE_MODELE_ET` (`PID_COMPTABILITE_MODELE_ET`) USING BTREE,
  KEY `RD` (`RD`) USING BTREE,
  KEY `TYPE_REGLEMENT` (`TYPE_REGLEMENT`) USING BTREE,
  KEY `TYPE_TVA_LIBELLE` (`TYPE_TVA_LIBELLE`) USING BTREE,
  KEY `VTF` (`VTF`) USING BTREE,
  KEY `TYPE_TVA_NUMERO` (`TYPE_TVA_NUMERO`) USING BTREE,
  KEY `N_LIGNE_INFO_COMPTA` (`N_LIGNE_INFO_COMPTA`) USING BTREE,
  KEY `EXTOURNABLE` (`EXTOURNABLE`) USING BTREE,
  KEY `NOM_DOSSIER` (`NOM_DOSSIER`) USING BTREE,
  KEY `DATE_TRESO` (`DATE_TRESO`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `comptabilite_modele_et`
--

CREATE TABLE `comptabilite_modele_et` (
  `CODE_JOURNAL` varchar(20) NOT NULL DEFAULT '',
  `CREDIT` decimal(20,2) NOT NULL DEFAULT 0.00,
  `DATE` date DEFAULT NULL,
  `DATEHEURE` varchar(60) NOT NULL DEFAULT '',
  `DATE_ECHEANCE` date DEFAULT NULL,
  `DATE_TRESO` date DEFAULT NULL,
  `DEBIT` decimal(20,2) NOT NULL DEFAULT 0.00,
  `ECRITURE_SITUATION_CUMULABLE` char(1) NOT NULL DEFAULT '',
  `ID_COMPTABILITE_MODELE_ET` varchar(32) NOT NULL DEFAULT '',
  `JOURS_SUP` double NOT NULL DEFAULT 0,
  `MONTANT_TTC` double NOT NULL DEFAULT 0,
  `NOM_DOSSIER` varchar(50) NOT NULL DEFAULT '',
  `NOM_JOURNAL` varchar(50) NOT NULL DEFAULT '',
  `NOM_MODELE` varchar(100) NOT NULL DEFAULT '',
  `NOM_TRESO` varchar(20) NOT NULL DEFAULT '',
  `N_DOSSIER` double NOT NULL DEFAULT 0,
  `N_ECRITURE` varchar(10) NOT NULL DEFAULT '',
  `N_PIECE` varchar(15) NOT NULL DEFAULT '',
  `N_PIECE_INTERNE` varchar(10) NOT NULL DEFAULT '',
  `N_TRESO` double NOT NULL DEFAULT 0,
  `N_TYPE_REGLEMENT` double NOT NULL DEFAULT 0,
  `PERIODICITE` varchar(20) NOT NULL DEFAULT '',
  `RD` double NOT NULL DEFAULT 0,
  `SAISIE_AUTOMATIQUE` char(1) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TYPE_REGLEMENT` varchar(40) NOT NULL DEFAULT '',
  `VIREMENT_INTERNE` char(1) NOT NULL DEFAULT '',
  `VTF` char(1) NOT NULL DEFAULT '',
  `EXTOURNABLE` char(1) NOT NULL DEFAULT '',
  `DEBUT_EX_PERIO` date DEFAULT NULL,
  `FIN_EX_PERIO` date DEFAULT NULL,
  `IDENT_MODELE_UNIQUE` varchar(40) NOT NULL DEFAULT '',
  `IDENT_DOCUMENT_ARCHIVE` varchar(32) NOT NULL DEFAULT '',
  `CREDIT_ETR1` decimal(12,2) NOT NULL DEFAULT 0.00,
  `DEBIT_ETR1` decimal(12,2) NOT NULL DEFAULT 0.00,
  `DEVISE_1` double NOT NULL DEFAULT 0,
  `DEVISE_2` double NOT NULL DEFAULT 0,
  `TX_CHANGE_12` decimal(12,5) NOT NULL DEFAULT 0.00000,
  `TX_CHANGE_21` decimal(12,5) NOT NULL DEFAULT 0.00000,
  `ECRITURE_DIRECTE` char(1) NOT NULL DEFAULT '',
  `NOM_VALIDATEUR_PRINCIPAL_DOSSIER` varchar(32) NOT NULL DEFAULT '',
  `NOM_VALIDATEUR_SECONDAIRE_DOSSIER` varchar(32) NOT NULL DEFAULT '',
  `CORPS_MESSAGE_VALIDATION` blob DEFAULT NULL,
  `AFFECT_VALIDATION_PAR_DEFAUT_DOSSIER` char(1) NOT NULL DEFAULT '',
  `NB_ENVOI_VALID` double NOT NULL DEFAULT 0,
  `N_PI_SPEC` char(1) NOT NULL DEFAULT '',
  `N_PIECE_INTERNE_NUM` varchar(20) NOT NULL DEFAULT '',
  `COMPTAGE_TIERS` decimal(12,0) NOT NULL DEFAULT 0,
  `COMPTAGE_LIGNE` decimal(12,0) NOT NULL DEFAULT 0,
  `LIEN_DOCUMENT_ARCHIVE_LISTE` varchar(40) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_COMPTABILITE_MODELE_ET`),
  KEY `CODE_JOURNAL` (`CODE_JOURNAL`) USING BTREE,
  KEY `DATEHEURE` (`DATEHEURE`) USING BTREE,
  KEY `DATE_ECHEANCE` (`DATE_ECHEANCE`) USING BTREE,
  KEY `DATE_TRESO` (`DATE_TRESO`) USING BTREE,
  KEY `ECRITURE_SITUATION_CUMULABLE` (`ECRITURE_SITUATION_CUMULABLE`) USING BTREE,
  KEY `NOM_MODELE` (`NOM_MODELE`) USING BTREE,
  KEY `NOM_TRESO` (`NOM_TRESO`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `N_ECRITURE` (`N_ECRITURE`) USING BTREE,
  KEY `N_PIECE` (`N_PIECE`) USING BTREE,
  KEY `N_PIECE_INTERNE` (`N_PIECE_INTERNE`) USING BTREE,
  KEY `N_TRESO` (`N_TRESO`) USING BTREE,
  KEY `N_TYPE_REGLEMENT` (`N_TYPE_REGLEMENT`) USING BTREE,
  KEY `PERIODICITE` (`PERIODICITE`) USING BTREE,
  KEY `RD` (`RD`) USING BTREE,
  KEY `SAISIE_AUTOMATIQUE` (`SAISIE_AUTOMATIQUE`) USING BTREE,
  KEY `VIREMENT_INTERNE` (`VIREMENT_INTERNE`) USING BTREE,
  KEY `VTF` (`VTF`) USING BTREE,
  KEY `EXTOURNABLE` (`EXTOURNABLE`) USING BTREE,
  KEY `DEBUT_EX_PERIO` (`DEBUT_EX_PERIO`) USING BTREE,
  KEY `FIN_EX_PERIO` (`FIN_EX_PERIO`) USING BTREE,
  KEY `IDENT_DOCUMENT_ARCHIVE` (`IDENT_DOCUMENT_ARCHIVE`) USING BTREE,
  KEY `IDENT_MODELE_UNIQUE` (`IDENT_MODELE_UNIQUE`) USING BTREE,
  KEY `NOM_VALIDATEUR_PRINCIPAL_DOSSIER` (`NOM_VALIDATEUR_PRINCIPAL_DOSSIER`) USING BTREE,
  KEY `NOM_VALIDATEUR_SECONDAIRE_DOSSIER` (`NOM_VALIDATEUR_SECONDAIRE_DOSSIER`) USING BTREE,
  KEY `AFFECT_VALIDATION_PAR_DEFAUT_DOSSIER` (`AFFECT_VALIDATION_PAR_DEFAUT_DOSSIER`) USING BTREE,
  KEY `NOM_DOSSIER` (`NOM_DOSSIER`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `contact`
--

CREATE TABLE `contact` (
  `ACCES_ACTION` char(1) NOT NULL DEFAULT '',
  `ADRESSE` varchar(200) NOT NULL DEFAULT '',
  `CIVILITE` varchar(30) NOT NULL DEFAULT '',
  `CODE_CLIENT` varchar(200) NOT NULL DEFAULT '',
  `CODE_MAILING` varchar(20) NOT NULL DEFAULT '',
  `CODE_POSTAL` varchar(10) NOT NULL DEFAULT '',
  `DATE_NAISSANCE` date DEFAULT NULL,
  `DESTINATAIRE_MAILING` varchar(50) NOT NULL DEFAULT '',
  `DESTINATAIRE_RELANCE` char(1) NOT NULL DEFAULT '',
  `E_MAIL` varchar(300) NOT NULL DEFAULT '',
  `FAX` varchar(15) NOT NULL DEFAULT '',
  `FONCTION` varchar(100) NOT NULL DEFAULT '',
  `ID_CONTACT` varchar(32) NOT NULL DEFAULT '',
  `LIEU_NAISSANCE` varchar(50) NOT NULL DEFAULT '',
  `MAIL_REJETE` varchar(100) NOT NULL DEFAULT '',
  `MEMO` blob DEFAULT NULL,
  `MOBILE` varchar(15) NOT NULL DEFAULT '',
  `NE_PAS_ENVOYER_MAIL` char(1) NOT NULL DEFAULT '',
  `NOM` varchar(100) NOT NULL DEFAULT '',
  `NOM_DOSSIER` varchar(100) NOT NULL DEFAULT '',
  `NOTE` varchar(200) NOT NULL DEFAULT '',
  `PID_ACTION` varchar(32) NOT NULL DEFAULT '',
  `PID_TIERS` varchar(32) NOT NULL DEFAULT '',
  `PRENOM` varchar(100) NOT NULL DEFAULT '',
  `RAISON_SOCIALE` varchar(100) NOT NULL DEFAULT '',
  `SERVICE` varchar(100) NOT NULL DEFAULT '',
  `SIGNATURE` longblob DEFAULT NULL,
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TELEPHONE` varchar(15) NOT NULL DEFAULT '',
  `TELEPHONE2` varchar(15) NOT NULL DEFAULT '',
  `VILLE` varchar(50) NOT NULL DEFAULT '',
  `DESTINATAIRE_SIGNATURE` char(1) NOT NULL DEFAULT '',
  `DESTINATAIRE_COMMANDE` char(1) NOT NULL DEFAULT '',
  `SPONSOR` char(1) NOT NULL DEFAULT '',
  `COMMERCIAL_LIE` varchar(200) NOT NULL DEFAULT '',
  `CODE_COMMERCIAL_LIE` varchar(10) NOT NULL DEFAULT '',
  `COMMERCIAL` char(1) NOT NULL DEFAULT '',
  `SPANCO_DEFAUT` char(1) NOT NULL DEFAULT '',
  `N_IMPORT` varchar(15) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_CONTACT`),
  KEY `ACCES_ACTION` (`ACCES_ACTION`) USING BTREE,
  KEY `CODE_MAILING` (`CODE_MAILING`) USING BTREE,
  KEY `CODE_POSTAL` (`CODE_POSTAL`) USING BTREE,
  KEY `DESTINATAIRE_MAILING` (`DESTINATAIRE_MAILING`) USING BTREE,
  KEY `DESTINATAIRE_RELANCE` (`DESTINATAIRE_RELANCE`) USING BTREE,
  KEY `MAIL_REJETE` (`MAIL_REJETE`) USING BTREE,
  KEY `NE_PAS_ENVOYER_MAIL` (`NE_PAS_ENVOYER_MAIL`) USING BTREE,
  KEY `PID_ACTION` (`PID_ACTION`) USING BTREE,
  KEY `PID_TIERS` (`PID_TIERS`) USING BTREE,
  KEY `TELEPHONE2` (`TELEPHONE2`) USING BTREE,
  KEY `CIVILITE` (`CIVILITE`) USING BTREE,
  KEY `DESTINATAIRE_COMMANDE` (`DESTINATAIRE_COMMANDE`) USING BTREE,
  KEY `SPONSOR` (`SPONSOR`) USING BTREE,
  KEY `COMMERCIAL_LIE` (`COMMERCIAL_LIE`) USING BTREE,
  KEY `CODE_COMMERCIAL_LIE` (`CODE_COMMERCIAL_LIE`) USING BTREE,
  KEY `COMMERCIAL` (`COMMERCIAL`) USING BTREE,
  KEY `SPANCO_DEFAUT` (`SPANCO_DEFAUT`) USING BTREE,
  KEY `N_IMPORT` (`N_IMPORT`) USING BTREE,
  KEY `CODE_CLIENT` (`CODE_CLIENT`) USING BTREE,
  KEY `RAISON_SOCIALE` (`RAISON_SOCIALE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `courrier`
--

CREATE TABLE `courrier` (
  `BIBLE` varchar(100) NOT NULL DEFAULT '',
  `BROUILLON` char(1) NOT NULL DEFAULT '',
  `CIVILITE` varchar(20) NOT NULL DEFAULT '',
  `COPIE` varchar(100) NOT NULL DEFAULT '',
  `COURRIER_ENVOYE` char(1) NOT NULL DEFAULT '',
  `DATE_ENVOI_COURRIER` date DEFAULT NULL,
  `DE` varchar(30) NOT NULL DEFAULT '',
  `DESTINATAIRE` varchar(100) NOT NULL DEFAULT '',
  `ID_COURRIER` varchar(32) NOT NULL DEFAULT '',
  `MEMO` blob DEFAULT NULL,
  `N_DOSSIER` double NOT NULL DEFAULT 0,
  `PID_TIERS` varchar(32) NOT NULL DEFAULT '',
  `PJ` varchar(100) NOT NULL DEFAULT '',
  `PRENOM` varchar(50) NOT NULL DEFAULT '',
  `RAISON_SOCIALE` varchar(100) NOT NULL DEFAULT '',
  `SIGNATURE` blob DEFAULT NULL,
  `SUJET` varchar(100) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `ADRESSE_SECONDAIRE` varchar(100) NOT NULL DEFAULT '',
  `ADRESSE_SECONDAIRE_BOLEEN` char(1) NOT NULL DEFAULT '',
  `FAMILLE_CLIENT` varchar(100) NOT NULL DEFAULT '',
  `FAMILLE_EGP` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_COURRIER`),
  KEY `BIBLE` (`BIBLE`) USING BTREE,
  KEY `BROUILLON` (`BROUILLON`) USING BTREE,
  KEY `CIVILITE` (`CIVILITE`) USING BTREE,
  KEY `COPIE` (`COPIE`) USING BTREE,
  KEY `COURRIER_ENVOYE` (`COURRIER_ENVOYE`) USING BTREE,
  KEY `DATE_ENVOI_COURRIER` (`DATE_ENVOI_COURRIER`) USING BTREE,
  KEY `DE` (`DE`) USING BTREE,
  KEY `DESTINATAIRE` (`DESTINATAIRE`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `PID_TIERS` (`PID_TIERS`) USING BTREE,
  KEY `PJ` (`PJ`) USING BTREE,
  KEY `RAISON_SOCIALE` (`RAISON_SOCIALE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `ADRESSE_SECONDAIRE` (`ADRESSE_SECONDAIRE`) USING BTREE,
  KEY `ADRESSE_SECONDAIRE_BOLEEN` (`ADRESSE_SECONDAIRE_BOLEEN`) USING BTREE,
  KEY `FAMILLE_CLIENT` (`FAMILLE_CLIENT`) USING BTREE,
  KEY `FAMILLE_EGP` (`FAMILLE_EGP`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `credit_bail_det`
--

CREATE TABLE `credit_bail_det` (
  `ANNEE` double NOT NULL DEFAULT 0,
  `ASSURANCES` decimal(12,2) NOT NULL DEFAULT 0.00,
  `BASE` decimal(12,2) NOT NULL DEFAULT 0.00,
  `CAPITAL` decimal(12,2) NOT NULL DEFAULT 0.00,
  `COEFFICIENT` decimal(12,2) NOT NULL DEFAULT 0.00,
  `DATE` date DEFAULT NULL,
  `DATE1` date DEFAULT NULL,
  `DUREE` double NOT NULL DEFAULT 0,
  `ENTRETIEN` decimal(12,2) NOT NULL DEFAULT 0.00,
  `ID_CREDIT_BAIL_DET` varchar(32) NOT NULL DEFAULT '',
  `INTERET` decimal(12,2) NOT NULL DEFAULT 0.00,
  `INTITULE` varchar(100) NOT NULL DEFAULT '',
  `MENSUALITE` decimal(12,2) NOT NULL DEFAULT 0.00,
  `MULTIPLE` decimal(12,0) NOT NULL DEFAULT 0,
  `NBRE_ANNEE_RESTANTE` double NOT NULL DEFAULT 0,
  `NOM_DOSSIER` varchar(50) NOT NULL DEFAULT '',
  `NUMERO` double NOT NULL DEFAULT 0,
  `N_DOSSIER` double NOT NULL DEFAULT 0,
  `N_EXERCICE` double NOT NULL DEFAULT 0,
  `P` varchar(32) NOT NULL DEFAULT '',
  `PERIODICITE` varchar(30) NOT NULL DEFAULT '',
  `PID_CREDIT_BAIL_ET` varchar(32) NOT NULL DEFAULT '',
  `POURCENTAGE` decimal(12,2) NOT NULL DEFAULT 0.00,
  `PRET_CUMUL` decimal(12,2) NOT NULL DEFAULT 0.00,
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TVA` decimal(12,2) NOT NULL DEFAULT 0.00,
  `VERROU` char(1) NOT NULL DEFAULT '',
  `VR` decimal(12,2) NOT NULL DEFAULT 0.00,
  `DATE_HEURE` varchar(60) NOT NULL DEFAULT '',
  `IDENTIFICATION_ECRITURE` varchar(32) NOT NULL DEFAULT '',
  `N_ECRITURE` varchar(32) NOT NULL DEFAULT '',
  `DATE_SORTIE` date DEFAULT NULL,
  `N_PI_SPEC` varchar(20) NOT NULL DEFAULT '',
  `N_PIECE_INTERNE_NUM_SEUL` varchar(10) NOT NULL DEFAULT '',
  `NUMERO_CB` varchar(10) NOT NULL DEFAULT '',
  `CALAGE` char(1) NOT NULL DEFAULT '',
  `MENSUALITE1` decimal(12,2) NOT NULL DEFAULT 0.00,
  `N_IMPORT` varchar(20) NOT NULL DEFAULT '',
  `ASSURANCES1` decimal(12,2) NOT NULL DEFAULT 0.00,
  `ENTRETIEN1` decimal(12,2) NOT NULL DEFAULT 0.00,
  `TVA1` decimal(12,2) NOT NULL DEFAULT 0.00,
  `PREMIER_LOYER` decimal(12,2) NOT NULL DEFAULT 0.00,
  `DATE_PAIEMENT` date DEFAULT NULL,
  PRIMARY KEY (`ID_CREDIT_BAIL_DET`),
  KEY `ANNEE` (`ANNEE`) USING BTREE,
  KEY `DATE` (`DATE`) USING BTREE,
  KEY `DATE1` (`DATE1`) USING BTREE,
  KEY `NUMERO` (`NUMERO`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `N_EXERCICE` (`N_EXERCICE`) USING BTREE,
  KEY `P` (`P`) USING BTREE,
  KEY `PID_CREDIT_BAIL_ET` (`PID_CREDIT_BAIL_ET`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `VERROU` (`VERROU`) USING BTREE,
  KEY `DATE_HEURE` (`DATE_HEURE`) USING BTREE,
  KEY `IDENTIFICATION_ECRITURE` (`IDENTIFICATION_ECRITURE`) USING BTREE,
  KEY `N_ECRITURE` (`N_ECRITURE`) USING BTREE,
  KEY `MULTIPLE` (`MULTIPLE`) USING BTREE,
  KEY `DATE_SORTIE` (`DATE_SORTIE`) USING BTREE,
  KEY `NOM_DOSSIER` (`NOM_DOSSIER`) USING BTREE,
  KEY `CALAGE` (`CALAGE`) USING BTREE,
  KEY `N_IMPORT` (`N_IMPORT`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `credit_bail_et`
--

CREATE TABLE `credit_bail_et` (
  `ASSURANCE_MONTANT` decimal(12,2) NOT NULL DEFAULT 0.00,
  `BASE` decimal(12,2) NOT NULL DEFAULT 0.00,
  `BASE_EC` decimal(12,2) NOT NULL DEFAULT 0.00,
  `BASE_FINANCEMENT` decimal(12,2) NOT NULL DEFAULT 0.00,
  `COUT_FINANCEMENT` decimal(12,2) NOT NULL DEFAULT 0.00,
  `DEBUT` date DEFAULT NULL,
  `DEBUT_EC` date DEFAULT NULL,
  `DELTA_EX_ANT` varchar(10) NOT NULL DEFAULT '',
  `DELTA_J` decimal(12,0) NOT NULL DEFAULT 0,
  `DELTA_JOUR` decimal(12,0) NOT NULL DEFAULT 0,
  `DURE` decimal(12,0) NOT NULL DEFAULT 0,
  `ECHEANCE` decimal(12,2) NOT NULL DEFAULT 0.00,
  `ENTRETIEN_MONTANT` decimal(12,2) NOT NULL DEFAULT 0.00,
  `FIN` date DEFAULT NULL,
  `FIN_EC` date DEFAULT NULL,
  `FRAIS_MONTANT` decimal(12,2) NOT NULL DEFAULT 0.00,
  `ID_CREDIT_BAIL_ET` varchar(32) NOT NULL DEFAULT '',
  `INTITULE` varchar(100) NOT NULL DEFAULT '',
  `JOURNAL` varchar(10) NOT NULL DEFAULT '',
  `MENSUALITE` decimal(12,2) NOT NULL DEFAULT 0.00,
  `MEOMO` blob DEFAULT NULL,
  `MULTIPLE` decimal(12,0) NOT NULL DEFAULT 0,
  `NBRE_JOURS_MOIS_COURANT` double NOT NULL DEFAULT 0,
  `NOM_BANQUE` varchar(10) NOT NULL DEFAULT '',
  `NOM_COMPTE_ASSURANCE` varchar(50) NOT NULL DEFAULT '',
  `NOM_COMPTE_CAPITAL` varchar(50) NOT NULL DEFAULT '',
  `NOM_COMPTE_ENTRETIEN` varchar(50) NOT NULL DEFAULT '',
  `NOM_COMPTE_INTERET` varchar(50) NOT NULL DEFAULT '',
  `NOM_COMPTE_TIERS` varchar(100) NOT NULL DEFAULT '',
  `NOM_COMPTE_TRESO` varchar(100) NOT NULL DEFAULT '',
  `NOM_COMPTE_TVA` varchar(50) NOT NULL DEFAULT '',
  `NOM_JOURNAL` varchar(50) NOT NULL DEFAULT '',
  `NUMERO` varchar(10) NOT NULL DEFAULT '',
  `N_COMPTE_ASSURANCE` double NOT NULL DEFAULT 0,
  `N_COMPTE_CAPITAL` double NOT NULL DEFAULT 0,
  `N_COMPTE_ENTRETIEN` double NOT NULL DEFAULT 0,
  `N_COMPTE_INTERET` double NOT NULL DEFAULT 0,
  `N_COMPTE_TVA` double NOT NULL DEFAULT 0,
  `N_CONTRAT` varchar(15) NOT NULL DEFAULT '',
  `N_DOSSIER` double NOT NULL DEFAULT 0,
  `N_EXERCICE` varchar(10) NOT NULL DEFAULT '',
  `N_PERIO` double NOT NULL DEFAULT 0,
  `N_TRESO` double NOT NULL DEFAULT 0,
  `PERIODICITE` varchar(20) NOT NULL DEFAULT '',
  `PID_TIERS` varchar(32) NOT NULL DEFAULT '',
  `PREMIER_LOYER` decimal(12,2) NOT NULL DEFAULT 0.00,
  `PRET_ANT` decimal(12,2) NOT NULL DEFAULT 0.00,
  `PRET_CUMUL` decimal(12,2) NOT NULL DEFAULT 0.00,
  `PRET_JOUR` decimal(12,5) NOT NULL DEFAULT 0.00000,
  `PRET_PERIO` decimal(12,2) NOT NULL DEFAULT 0.00,
  `PRET_PERIODICITE` decimal(12,2) NOT NULL DEFAULT 0.00,
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TAUX` decimal(12,5) NOT NULL DEFAULT 0.00000,
  `TAUX_ASSURANCES` decimal(12,5) NOT NULL DEFAULT 0.00000,
  `TAUX_FRAIS` decimal(12,5) NOT NULL DEFAULT 0.00000,
  `TAUX_VALEUR_RESIDUELLE` decimal(12,2) NOT NULL DEFAULT 0.00,
  `TEG` decimal(12,5) NOT NULL DEFAULT 0.00000,
  `TYPE_PRET` varchar(20) NOT NULL DEFAULT '',
  `VALEUR_RESIDUELLE` decimal(12,2) NOT NULL DEFAULT 0.00,
  `DATE_SORTIE` date DEFAULT NULL,
  `BLOCAGE_CREDIT_BAIL` char(1) NOT NULL DEFAULT '',
  `DATE_HEURE` varchar(60) NOT NULL DEFAULT '',
  `N_COMPTE_BILAN` double NOT NULL DEFAULT 0,
  `N_CPTE_TIERS` varchar(100) NOT NULL DEFAULT '',
  `N_LIGNE_INFO_COMPTA` double NOT NULL DEFAULT 0,
  `TERME` varchar(10) NOT NULL DEFAULT '',
  `SOLDE` char(1) NOT NULL DEFAULT '',
  `ANALYTIQUE` char(1) NOT NULL DEFAULT '',
  `PASSAGE_365` char(1) NOT NULL DEFAULT '',
  `SOMME_LOYER` double NOT NULL DEFAULT 0,
  `NOM_DOSSIER` varchar(50) NOT NULL DEFAULT '',
  `DATE_PREAVIS` date DEFAULT NULL,
  `ANS1` double NOT NULL DEFAULT 0,
  `ANS10` double NOT NULL DEFAULT 0,
  `ANS11` double NOT NULL DEFAULT 0,
  `ANS12` double NOT NULL DEFAULT 0,
  `ANS13` double NOT NULL DEFAULT 0,
  `ANS14` double NOT NULL DEFAULT 0,
  `ANS15` double NOT NULL DEFAULT 0,
  `ANS16` double NOT NULL DEFAULT 0,
  `ANS17` double NOT NULL DEFAULT 0,
  `ANS18` double NOT NULL DEFAULT 0,
  `ANS19` double NOT NULL DEFAULT 0,
  `ANS2` double NOT NULL DEFAULT 0,
  `ANS20` double NOT NULL DEFAULT 0,
  `ANS3` double NOT NULL DEFAULT 0,
  `ANS4` double NOT NULL DEFAULT 0,
  `ANS5` double NOT NULL DEFAULT 0,
  `ANS6` double NOT NULL DEFAULT 0,
  `ANS7` double NOT NULL DEFAULT 0,
  `ANS8` double NOT NULL DEFAULT 0,
  `ANS9` double NOT NULL DEFAULT 0,
  `TOTAL_ANA` double NOT NULL DEFAULT 0,
  `IMMATRICULATION` varchar(15) NOT NULL DEFAULT '',
  `PID_MATERIEL_ET` varchar(32) NOT NULL DEFAULT '',
  `N_PI_SPEC` char(1) NOT NULL DEFAULT '',
  `IDENT_TARIF` varchar(32) NOT NULL DEFAULT '',
  `CALAGE` char(1) NOT NULL DEFAULT '',
  `COMPTAGE_LIGNE` decimal(12,0) NOT NULL DEFAULT 0,
  `SOMME_ENTRETIEN` double NOT NULL DEFAULT 0,
  `SOMME_ASSURANCES` double NOT NULL DEFAULT 0,
  `ANS_MAN` char(1) NOT NULL DEFAULT '',
  `TX_TVA` decimal(12,2) NOT NULL DEFAULT 0.00,
  `N_TYPE_TVA` decimal(12,0) NOT NULL DEFAULT 0,
  `TYPE_TVA` varchar(20) NOT NULL DEFAULT '',
  `N_TYPE_RGT` decimal(12,0) NOT NULL DEFAULT 0,
  `NOM_TYPE_RGT` varchar(20) NOT NULL DEFAULT '',
  `DATE_PAIEMENT` date DEFAULT NULL,
  PRIMARY KEY (`ID_CREDIT_BAIL_ET`),
  KEY `DEBUT` (`DEBUT`) USING BTREE,
  KEY `FIN` (`FIN`) USING BTREE,
  KEY `JOURNAL` (`JOURNAL`) USING BTREE,
  KEY `NOM_BANQUE` (`NOM_BANQUE`) USING BTREE,
  KEY `NUMERO` (`NUMERO`) USING BTREE,
  KEY `N_COMPTE_ASSURANCE` (`N_COMPTE_ASSURANCE`) USING BTREE,
  KEY `N_COMPTE_CAPITAL` (`N_COMPTE_CAPITAL`) USING BTREE,
  KEY `N_COMPTE_INTERET` (`N_COMPTE_INTERET`) USING BTREE,
  KEY `N_DOSSIER` (`N_DOSSIER`) USING BTREE,
  KEY `N_PERIO` (`N_PERIO`) USING BTREE,
  KEY `N_TRESO` (`N_TRESO`) USING BTREE,
  KEY `PERIODICITE` (`PERIODICITE`) USING BTREE,
  KEY `PID_TIERS` (`PID_TIERS`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `TYPE_PRET` (`TYPE_PRET`) USING BTREE,
  KEY `BLOCAGE_CREDIT_BAIL` (`BLOCAGE_CREDIT_BAIL`) USING BTREE,
  KEY `DATE_HEURE` (`DATE_HEURE`) USING BTREE,
  KEY `N_COMPTE_BILAN` (`N_COMPTE_BILAN`) USING BTREE,
  KEY `N_CPTE_TIERS` (`N_CPTE_TIERS`) USING BTREE,
  KEY `DATE_SORTIE` (`DATE_SORTIE`) USING BTREE,
  KEY `BASE` (`BASE`) USING BTREE,
  KEY `DELTA_J` (`DELTA_J`) USING BTREE,
  KEY `DURE` (`DURE`) USING BTREE,
  KEY `ECHEANCE` (`ECHEANCE`) USING BTREE,
  KEY `FRAIS_MONTANT` (`FRAIS_MONTANT`) USING BTREE,
  KEY `MENSUALITE` (`MENSUALITE`) USING BTREE,
  KEY `MULTIPLE` (`MULTIPLE`) USING BTREE,
  KEY `TAUX` (`TAUX`) USING BTREE,
  KEY `TAUX_ASSURANCES` (`TAUX_ASSURANCES`) USING BTREE,
  KEY `TAUX_FRAIS` (`TAUX_FRAIS`) USING BTREE,
  KEY `TEG` (`TEG`) USING BTREE,
  KEY `SOLDE` (`SOLDE`) USING BTREE,
  KEY `INTITULE` (`INTITULE`) USING BTREE,
  KEY `N_PI_SPEC` (`N_PI_SPEC`) USING BTREE,
  KEY `IDENT_TARIF` (`IDENT_TARIF`) USING BTREE,
  KEY `CALAGE` (`CALAGE`) USING BTREE,
  KEY `N_TYPE_TVA` (`N_TYPE_TVA`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `devis_det`
--

CREATE TABLE `devis_det` (
  `CATALOGUE` varchar(100) NOT NULL DEFAULT '',
  `DESIGNATION` varchar(100) NOT NULL DEFAULT '',
  `ID_DEVIS_DET` varchar(32) NOT NULL DEFAULT '',
  `MB_TOTALE` double NOT NULL DEFAULT 0,
  `MB_UNITAIRE` double NOT NULL DEFAULT 0,
  `P` varchar(32) NOT NULL DEFAULT '',
  `PID_DEVIS_ET` varchar(32) NOT NULL DEFAULT '',
  `PID_TIERS` varchar(32) NOT NULL DEFAULT '',
  `PRIX_ACHAT_TOTAL` double NOT NULL DEFAULT 0,
  `PRIX_ACHAT_UNITAIRE` double NOT NULL DEFAULT 0,
  `PRIX_ACHAT_UNITAIRE_TOTAL` double NOT NULL DEFAULT 0,
  `PRIX_VENTE_TOTAL` double NOT NULL DEFAULT 0,
  `PRIX_VENTE_UNITAIRE` double NOT NULL DEFAULT 0,
  `PRIX_VENTE_UNITAIRE_NET` double NOT NULL DEFAULT 0,
  `Q` double NOT NULL DEFAULT 0,
  `REF` varchar(30) NOT NULL DEFAULT '',
  `REMISE` double NOT NULL DEFAULT 0,
  `SYS_CONTEXTE` varchar(32) NOT NULL DEFAULT '',
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_NO_LIGNE` double NOT NULL DEFAULT 0,
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `FAMILLE` varchar(40) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_DEVIS_DET`),
  KEY `CATALOGUE` (`CATALOGUE`) USING BTREE,
  KEY `DESIGNATION` (`DESIGNATION`) USING BTREE,
  KEY `MB_TOTALE` (`MB_TOTALE`) USING BTREE,
  KEY `MB_UNITAIRE` (`MB_UNITAIRE`) USING BTREE,
  KEY `P` (`P`) USING BTREE,
  KEY `PID_DEVIS_ET` (`PID_DEVIS_ET`) USING BTREE,
  KEY `PID_TIERS` (`PID_TIERS`) USING BTREE,
  KEY `PRIX_ACHAT_TOTAL` (`PRIX_ACHAT_TOTAL`) USING BTREE,
  KEY `PRIX_ACHAT_UNITAIRE` (`PRIX_ACHAT_UNITAIRE`) USING BTREE,
  KEY `PRIX_ACHAT_UNITAIRE_TOTAL` (`PRIX_ACHAT_UNITAIRE_TOTAL`) USING BTREE,
  KEY `PRIX_VENTE_TOTAL` (`PRIX_VENTE_TOTAL`) USING BTREE,
  KEY `PRIX_VENTE_UNITAIRE` (`PRIX_VENTE_UNITAIRE`) USING BTREE,
  KEY `PRIX_VENTE_UNITAIRE_NET` (`PRIX_VENTE_UNITAIRE_NET`) USING BTREE,
  KEY `Q` (`Q`) USING BTREE,
  KEY `REF` (`REF`) USING BTREE,
  KEY `REMISE` (`REMISE`) USING BTREE,
  KEY `SYS_CONTEXTE` (`SYS_CONTEXTE`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `FAMILLE` (`FAMILLE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `devis_et`
--

CREATE TABLE `devis_et` (
  `CIVILITE` varchar(10) NOT NULL DEFAULT '',
  `COUT_MENSUEL` double NOT NULL DEFAULT 0,
  `CT_PAR_LICENCE` double NOT NULL DEFAULT 0,
  `DATE` date DEFAULT NULL,
  `DUREE` double NOT NULL DEFAULT 0,
  `FONCTION` varchar(40) NOT NULL DEFAULT '',
  `ID_DEVIS_ET` varchar(32) NOT NULL DEFAULT '',
  `MB_GLOBALE` double NOT NULL DEFAULT 0,
  `MB_INVEST` double NOT NULL DEFAULT 0,
  `MB_MENSUALISE` double NOT NULL DEFAULT 0,
  `MEMO` blob DEFAULT NULL,
  `MEMO1` blob DEFAULT NULL,
  `MEMO__ET` blob DEFAULT NULL,
  `NBRE_LICENCE` double NOT NULL DEFAULT 0,
  `NOM_BIBLE` varchar(50) NOT NULL DEFAULT '',
  `NOM_BIBLE2` varchar(50) NOT NULL DEFAULT '',
  `NOM_BILBE1` varchar(50) NOT NULL DEFAULT '',
  `NOM_CONTACT` varchar(50) NOT NULL DEFAULT '',
  `PID_TIERS` varchar(32) NOT NULL DEFAULT '',
  `PRENOM_CONTACT` varchar(30) NOT NULL DEFAULT '',
  `REMISE_EGLOBALPRO` double NOT NULL DEFAULT 0,
  `REMISE_E_PROCESS` double NOT NULL DEFAULT 0,
  `SYS_DATE_CREATION` date DEFAULT NULL,
  `SYS_DATE_MODIFICATION` date DEFAULT NULL,
  `SYS_HEURE_CREATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_HEURE_MODIFICATION` time NOT NULL DEFAULT '00:00:00',
  `SYS_USER_CREATION` varchar(20) NOT NULL DEFAULT '',
  `SYS_USER_MODIFICATION` varchar(20) NOT NULL DEFAULT '',
  `TITRE` varchar(100) NOT NULL DEFAULT '',
  `TOTAL_HT_GLOBAL` double NOT NULL DEFAULT 0,
  `TOTAL_HT_INVEST` double NOT NULL DEFAULT 0,
  `TOTAL_HT_MENS` double NOT NULL DEFAULT 0,
  `TOTAL_HT_MENSUALISE` double NOT NULL DEFAULT 0,
  `TYPE_CLIENT` varchar(20) NOT NULL DEFAULT '',
  `MB_PRESTA` double NOT NULL DEFAULT 0,
  `MEMO2` blob DEFAULT NULL,
  `NOM_BIBLE3` varchar(50) NOT NULL DEFAULT '',
  `TOTAL_HT_PRESTA` double NOT NULL DEFAULT 0,
  `VERIFICATION` char(1) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_DEVIS_ET`),
  KEY `COUT_MENSUEL` (`COUT_MENSUEL`) USING BTREE,
  KEY `CT_PAR_LICENCE` (`CT_PAR_LICENCE`) USING BTREE,
  KEY `DATE` (`DATE`) USING BTREE,
  KEY `DUREE` (`DUREE`) USING BTREE,
  KEY `MB_GLOBALE` (`MB_GLOBALE`) USING BTREE,
  KEY `MB_INVEST` (`MB_INVEST`) USING BTREE,
  KEY `MB_MENSUALISE` (`MB_MENSUALISE`) USING BTREE,
  KEY `NBRE_LICENCE` (`NBRE_LICENCE`) USING BTREE,
  KEY `NOM_BIBLE` (`NOM_BIBLE`) USING BTREE,
  KEY `NOM_BIBLE2` (`NOM_BIBLE2`) USING BTREE,
  KEY `NOM_BILBE1` (`NOM_BILBE1`) USING BTREE,
  KEY `NOM_CONTACT` (`NOM_CONTACT`) USING BTREE,
  KEY `PID_TIERS` (`PID_TIERS`) USING BTREE,
  KEY `REMISE_EGLOBALPRO` (`REMISE_EGLOBALPRO`) USING BTREE,
  KEY `REMISE_E_PROCESS` (`REMISE_E_PROCESS`) USING BTREE,
  KEY `SYS_DATE_CREATION` (`SYS_DATE_CREATION`) USING BTREE,
  KEY `SYS_DATE_MODIFICATION` (`SYS_DATE_MODIFICATION`) USING BTREE,
  KEY `SYS_HEURE_CREATION` (`SYS_HEURE_CREATION`) USING BTREE,
  KEY `SYS_HEURE_MODIFICATION` (`SYS_HEURE_MODIFICATION`) USING BTREE,
  KEY `SYS_USER_CREATION` (`SYS_USER_CREATION`) USING BTREE,
  KEY `SYS_USER_MODIFICATION` (`SYS_USER_MODIFICATION`) USING BTREE,
  KEY `TITRE` (`TITRE`) USING BTREE,
  KEY `TOTAL_HT_GLOBAL` (`TOTAL_HT_GLOBAL`) USING BTREE,
  KEY `TOTAL_HT_INVEST` (`TOTAL_HT_INVEST`) USING BTREE,
  KEY `TOTAL_HT_MENS` (`TOTAL_HT_MENS`) USING BTREE,
  KEY `TOTAL_HT_MENSUALISE` (`TOTAL_HT_MENSUALISE`) USING BTREE,
  KEY `TYPE_CLIENT` (`TYPE_CLIENT`) USING BTREE,
  KEY `NOM_BIBLE3` (`NOM_BIBLE3`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `doc_archive_support`
--

