-- MySQL dump 10.11
--
-- Host: localhost    Database: CPTA_0_MaBoutic
-- ------------------------------------------------------
-- Server version	5.0.32-Debian_7etch8-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `COMPTE`
--

DROP TABLE IF EXISTS `COMPTE`;
CREATE TABLE `COMPTE` (
  `Numero_Compte` varchar(8) NOT NULL,
  `Libelle` varchar(100) default '',
  `Compte_Gen` char(1) default 'G',
  `Code_TVA` int(10) unsigned default '1',
  `Lettrage` char(1) default 'n',
  `Lettre` varchar(3) default '',
  `Centraliser` char(1) default 'n',
  `Cumul_Journal` char(1) default 'n',
  `Detail_Cloture` char(1) default 'n',
  `Solde` decimal(16,2) default '0.00',
  `Date_Creation` bigint(20) unsigned default '0',
  `Total_Credit` decimal(16,2) default '0.00',
  `Total_Debit` decimal(16,2) default '0.00',
  PRIMARY KEY  (`Numero_Compte`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `COMPTE`
--

LOCK TABLES `COMPTE` WRITE;
/*!40000 ALTER TABLE `COMPTE` DISABLE KEYS */;
INSERT INTO `COMPTE` VALUES ('01000000','CLIENTS DIVERS','C',1,'n','','n','n','n','2679.33',0,'68488.64','65809.31'),('01000001','Clients particuliers','C',1,'n','','n','n','n','200.00',1200583068189,'2412.60','2212.60'),('01000002','Client Divers Caisse','C',1,'n','','n','n','n','0.00',1211295826770,'0.00','0.00'),('01010000','Clients Libraires','C',1,'n','','n','n','n','0.00',1199723646800,'120199.72','120199.72'),('01020000','Garagistes','C',1,'n','','n','n','n','0.00',1199896280244,'48872.09','48872.09'),('01030000','Salons de coiffure','C',1,'n','','n','n','n','0.00',1200557805669,'0.00','0.00'),('08000000','FOURNISSEURS DIVERS','F',1,'n','','n','n','n','406.64',0,'51897.58','51490.94'),('08000100','MON FOURNISSEUR','F',1,'n','','n','n','n','100.00',1200309770058,'100.00','0.00'),('08000101','Fournisseurs de confiture','F',1,'n','','n','n','n','0.00',1224071950796,'0.00','0.00'),('08000102','Fournisseurs d\'épicerie fine','F',1,'n','','n','n','n','0.00',1224074053491,'0.00','0.00'),('08000103','LE FLEURON','F',1,'n','','n','n','n','0.00',1226569486764,'0.00','0.00'),('08001000','CITROEN','F',1,'n','','n','n','n','0.00',1224075917625,'0.00','0.00'),('08001001','PEUGEOT','F',1,'n','','n','n','n','0.00',1224076028018,'0.00','0.00'),('08001002','TOUTPOURLAUTO','F',1,'n','','n','n','n','0.00',1224076669949,'0.00','0.00'),('08100000','Telephonie','F',1,'n','','n','n','n','0.00',1224594684107,'0.00','0.00'),('12000000','COMPTE DE RESULTAT','G',1,'n','','n','n','n','0.00',0,'0.00','0.00'),('40100000','COLLECTIF FOURNISSEURS','G',1,'n','','n','n','n','506.64',0,'51997.58','51490.94'),('41100000','COLLECTIF CLIENTS','G',1,'n','','n','n','n','2879.33',0,'239973.05','237093.72'),('44566100','TVA SUR ACHAT 2.1%','G',1,'n','','n','n','n','0.00',0,'0.00','0.00'),('44566200','TVA SUR ACHAT 5.5%','G',1,'n','','n','n','n','-1057.32',0,'0.00','1057.32'),('44566300','TVA SUR ACHAT 19.6%','G',1,'n','','n','n','n','-5181.26',0,'0.00','5181.26'),('44571100','TVA SUR VENTE 2.1%','G',1,'n','','n','n','n','0.00',0,'0.00','0.00'),('44571200','TVA SUR VENTE 5.5%','G',1,'n','','n','n','n','6.05',0,'6.05','0.00'),('44571300','TVA SUR VENTE 19.6%','G',1,'n','','n','n','n','38545.43',0,'38851.65','306.22'),('47210100','ECRITURES DE BANQUE EN ATTENTE','G',1,'n','','n','n','n','0.00',0,'0.00','0.00'),('51200000','BANQUE','G',1,'n','','n','n','n','-186713.53',0,'51490.94','238204.47'),('60700000','ACHATS DE MARCHANDISES','G',4,'n','','n','n','n','-45428.00',0,'0.00','45428.00'),('60701000','Achats Pièces déttachées','G',4,'n','','n','n','n','0.00',1224075735959,'0.00','0.00'),('60702000','Achats Outillages','G',4,'n','','n','n','n','0.00',1225808305084,'0.00','0.00'),('60703000','Achats de produits à 5.5%','G',3,'n','','n','n','n','0.00',1225808547433,'0.00','0.00'),('60704000','Achats matière première à 19.6%','G',4,'n','','n','n','n','0.00',1226566268886,'0.00','0.00'),('62410000','FRAIS DE PORT SUR ACHAT','G',4,'n','','n','n','n','-231.00',0,'0.00','231.00'),('62620000','FRAIS DE TELEPHONIE','G',1,'n','','n','n','n','0.00',1224594807306,'0.00','0.00'),('65800000','CHARGES DIVERSES DE GESTION COURANTE','G',1,'n','','n','n','n','0.00',0,'0.00','0.00'),('66500000','ESCOMPTES ACCORDES','G',1,'n','','n','n','n','-96.69',0,'0.00','96.69'),('70610100','VENTE PRESTATION SPECIALE','G',1,'n','','n','n','n','63013.10',1200308002364,'63123.10','110.00'),('70610101','Dépanage sur site','G',1,'n','','n','n','n','0.00',1224075409568,'0.00','0.00'),('70610102','Dépanage hors site','G',1,'n','','n','n','n','0.00',1224075547641,'0.00','0.00'),('70700000','VENTES DE MARCHANDISES 19,6%','G',4,'n','','n','n','n','132821.25',0,'134273.61','1452.36'),('70701000','Vente de pièces déttachées','G',1,'n','','n','n','n','0.00',1224075793249,'0.00','0.00'),('70701001','Vente Pièces déttachées Climatisation','G',1,'n','','n','n','n','0.00',1224076849426,'0.00','0.00'),('70701002','Vente d\'outillage','G',4,'n','','n','n','n','0.00',1225808337274,'0.00','0.00'),('70703000','Ventes de produit à 5.5%','G',3,'n','','n','n','n','0.00',1225808584507,'0.00','0.00'),('70704000','Vente de matière première à 19.6%','G',4,'n','','n','n','n','0.00',1226566298573,'0.00','0.00'),('70710000','VENTE DE MARCHANDISE 5,5 %','G',3,'n','','n','n','n','0.00',1224071646330,'0.00','0.00'),('70850000','FRAIS DE PORT SUR VENTE','G',4,'n','','n','n','n','936.00',0,'936.00','0.00'),('74000000','SUBVENTIONS D\'EXPLOITATION','G',4,'n','','n','n','n','0.00',0,'0.00','0.00'),('75800000','PRODUITS DIVERS DE GESTION COURANTE','G',1,'n','','n','n','n','0.00',0,'0.00','0.00'),('76500000','ESCOMPTES OBTENUS','G',1,'n','','n','n','n','0.00',0,'0.00','0.00');
/*!40000 ALTER TABLE `COMPTE` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ECRITURE`
--

DROP TABLE IF EXISTS `ECRITURE`;
CREATE TABLE `ECRITURE` (
  `Num_Ecriture` int(10) unsigned NOT NULL auto_increment,
  `Code_Journal` char(3) NOT NULL default '',
  `Date_Ecriture` bigint(20) unsigned default '0',
  `Vide` tinyint(3) unsigned default '1',
  PRIMARY KEY  (`Num_Ecriture`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ECRITURE`
--

LOCK TABLES `ECRITURE` WRITE;
/*!40000 ALTER TABLE `ECRITURE` DISABLE KEYS */;
INSERT INTO `ECRITURE` VALUES (1,'VE',1199142000000,0),(2,'BQ',1199142000000,1),(3,'BQ',1199142000000,0),(4,'BQ',1199142000000,1),(5,'BQ',1199142000000,0),(6,'BQ',1199142000000,0),(7,'VE',1199142000000,0),(8,'VE',1199142000000,0),(9,'VE',1199142000000,1),(10,'BQ',1199142000000,0),(11,'BQ',1199142000000,0),(12,'BQ',1199142000000,0),(13,'VE',1199142000000,0),(14,'VE',1199142000000,0),(15,'VE',1199142000000,0),(16,'BQ',1199142000000,0),(17,'BQ',1199142000000,0),(18,'BQ',1199142000000,0),(19,'BQ',1199142000000,0),(20,'VE',1199142000000,0),(21,'VE',1199142000000,0),(22,'VE',1199142000000,0),(23,'VE',1199142000000,0),(24,'VE',1199142000000,0),(25,'VE',1199142000000,0),(26,'BQ',1199142000000,0),(27,'BQ',1199142000000,0),(28,'BQ',1199142000000,0),(29,'VE',1199142000000,1),(30,'BQ',1199142000000,1),(31,'BQ',1196463600000,0),(32,'BQ',1196463600000,1),(33,'VE',1199142000000,0),(34,'VE',1199142000000,0),(35,'VE',1199142000000,1),(36,'AC',1196463600000,1),(37,'VE',1199142000000,0),(38,'BQ',1199142000000,1),(39,'VE',1199142000000,1),(40,'AC',1209592800000,0),(41,'AC',1209592800000,1),(42,'AC',1209592800000,0),(43,'AC',1209592800000,0),(44,'AC',1209592800000,1),(45,'BQ',1209592800000,0),(46,'BQ',1209592800000,0),(47,'BQ',1209592800000,1),(48,'AC',1209592800000,0),(49,'BQ',1209592800000,0),(50,'BQ',1209592800000,0),(51,'BQ',1209592800000,1),(52,'AC',1209592800000,0),(53,'BQ',1199142000000,0),(54,'BQ',1199142000000,0),(55,'BQ',1209592800000,0),(56,'VE',1209592800000,0),(57,'VE',1204326000000,0),(58,'VE',1204326000000,0),(59,'VE',1204326000000,0),(60,'VE',1204326000000,1),(61,'VE',1207000800000,1),(62,'VE',1209592800000,1),(63,'VE',1209592800000,0),(64,'VE',1209592800000,0),(65,'VE',1217541600000,0),(66,'VE',1217541600000,0),(67,'VE',1217541600000,0),(68,'VE',1217541600000,1),(69,'BQ',1217541600000,0),(70,'VE',1217541600000,0),(71,'VE',1217541600000,1),(72,'VE',1214863200000,1),(73,'VE',1212271200000,1),(74,'BQ',1217541600000,1),(75,'AC',1207000800000,0),(76,'AC',1207000800000,1),(77,'BQ',1199142000000,0),(78,'BQ',1199142000000,0),(79,'BQ',1201820400000,0),(80,'BQ',1212271200000,0),(81,'BQ',1217541600000,0),(82,'BQ',1217541600000,0),(83,'BQ',1220220000000,0),(84,'BQ',1220220000000,0),(85,'BQ',1201820400000,0),(86,'BQ',1201820400000,0),(87,'BQ',1201820400000,0),(88,'BQ',1201820400000,0),(89,'BQ',1212271200000,0),(90,'BQ',1212271200000,0),(91,'BQ',1217541600000,0),(92,'BQ',1217541600000,0),(93,'BQ',1217541600000,0),(94,'BQ',1220220000000,0),(95,'BQ',1220220000000,0),(96,'BQ',1209592800000,0),(97,'BQ',1212271200000,0),(98,'BQ',1214863200000,0),(99,'BQ',1217541600000,0),(100,'VE',1220220000000,0),(101,'VE',1220220000000,0),(102,'VE',1220220000000,0),(103,'VE',1220220000000,0),(104,'VE',1220220000000,0);
/*!40000 ALTER TABLE `ECRITURE` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `JOURNAL`
--

DROP TABLE IF EXISTS `JOURNAL`;
CREATE TABLE `JOURNAL` (
  `Code_Journal` char(3) NOT NULL,
  `Libelle` varchar(50) default '',
  `Type_Journal` char(2) NOT NULL,
  `Contre_Partie` varchar(8) default '',
  PRIMARY KEY  (`Code_Journal`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `JOURNAL`
--

LOCK TABLES `JOURNAL` WRITE;
/*!40000 ALTER TABLE `JOURNAL` DISABLE KEYS */;
INSERT INTO `JOURNAL` VALUES ('AC','ACHATS','AC',''),('AN','A NOUVEAU','AN',''),('BQ','BANQUE','TR','51200000'),('CS','CAISSE','TR','51200000'),('OD','OPERATIONS DIVERSES','OD',''),('VE','VENTES','VE','');
/*!40000 ALTER TABLE `JOURNAL` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `NB_OP_JOURNAUX`
--

DROP TABLE IF EXISTS `NB_OP_JOURNAUX`;
CREATE TABLE `NB_OP_JOURNAUX` (
  `Code_Journal` char(3) NOT NULL,
  `Periode` bigint(20) NOT NULL default '0',
  `Nb_Op` int(10) unsigned default '0',
  PRIMARY KEY  (`Code_Journal`,`Periode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `NB_OP_JOURNAUX`
--

LOCK TABLES `NB_OP_JOURNAUX` WRITE;
/*!40000 ALTER TABLE `NB_OP_JOURNAUX` DISABLE KEYS */;
INSERT INTO `NB_OP_JOURNAUX` VALUES ('AC',1207000800000,5),('AC',1209592800000,12),('BQ',1196463600000,2),('BQ',1199142000000,34),('BQ',1201820400000,10),('BQ',1209592800000,12),('BQ',1212271200000,8),('BQ',1214863200000,2),('BQ',1217541600000,14),('BQ',1220220000000,8),('VE',1199142000000,48),('VE',1204326000000,9),('VE',1209592800000,9),('VE',1217541600000,18),('VE',1220220000000,18);
/*!40000 ALTER TABLE `NB_OP_JOURNAUX` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `OPERATION`
--

DROP TABLE IF EXISTS `OPERATION`;
CREATE TABLE `OPERATION` (
  `Op_Id` int(10) unsigned NOT NULL auto_increment,
  `Num_Ligne` int(10) unsigned NOT NULL,
  `Num_Ecriture` int(10) unsigned NOT NULL,
  `Numero_Compte` varchar(8) NOT NULL,
  `Montant_D` decimal(14,2) unsigned default '0.00',
  `Montant_C` decimal(14,2) unsigned default '0.00',
  `Libelle` varchar(100) default '',
  `Num_Piece` varchar(20) default '',
  `Contrepartie` varchar(8) default '',
  `Type` varchar(8) default '',
  `Raccourci` char(1) default '',
  `Lettre` varchar(3) default '',
  `Date_Op` bigint(20) unsigned default '0',
  `Date_Echeance` bigint(20) unsigned default '0',
  PRIMARY KEY  (`Op_Id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `OPERATION`
--

LOCK TABLES `OPERATION` WRITE;
/*!40000 ALTER TABLE `OPERATION` DISABLE KEYS */;
INSERT INTO `OPERATION` VALUES (1,2,1,'01000000','9610.15','0.00','CLIENTS DIVERS','F08010001','','','','',1199660400000,1199660400000),(2,1,1,'44571300','0.00','1574.91','TVA SUR VENTE 19.6%','F08010001','','','','',1199660400000,1199660400000),(3,0,1,'70700000','0.00','8035.24','VENTES DE MARCHANDISES','F08010001','','','','',1199660400000,1199660400000),(4,1,3,'51200000','9610.15','0.00','BANQUE','F08010001','','','','',1199660400000,0),(5,0,3,'01000000','0.00','9610.15','CLIENTS DIVERS','F08010001','','','','',1199660400000,0),(6,1,5,'51200000','2198.46','0.00','BANQUE','F08010002','','','','',1199746800000,0),(7,0,5,'01000000','0.00','2198.46','CLIENTS DIVERS','F08010002','','','','',1199746800000,0),(8,1,6,'51200000','599.72','0.00','BANQUE','F08010003','','','','',1199746800000,0),(9,0,6,'01010000','0.00','599.72','Clients Libraires','F08010003','','','','',1199746800000,0),(10,2,7,'01000000','2198.46','0.00','CLIENTS DIVERS','F08010002','','','','',1199746800000,1199746800000),(11,1,7,'44571300','0.00','360.28','TVA SUR VENTE 19.6%','F08010002','','','','',1199746800000,1199746800000),(12,0,7,'70700000','0.00','1838.18','VENTES DE MARCHANDISES','F08010002','','','','',1199746800000,1199746800000),(13,2,8,'01010000','599.72','0.00','Clients Libraires','F08010003','','','','',1199746800000,1199746800000),(14,1,8,'44571300','0.00','98.28','TVA SUR VENTE 19.6%','F08010003','','','','',1199746800000,1199746800000),(15,0,8,'70700000','0.00','501.44','VENTES DE MARCHANDISES','F08010003','','','','',1199746800000,1199746800000),(16,1,10,'51200000','1578.72','0.00','BANQUE','F08010005','','','','',1199919600000,0),(17,0,10,'01000000','0.00','1578.72','CLIENTS DIVERS','F08010005','','','','',1199919600000,0),(18,1,11,'51200000','1973.40','0.00','BANQUE','F08010004','','','','',1199919600000,0),(19,0,11,'01020000','0.00','1973.40','Garagistes','F08010004','','','','',1199919600000,0),(20,1,12,'51200000','6972.68','0.00','BANQUE','F08010006','','','','',1199919600000,0),(21,0,12,'01000000','0.00','6972.68','CLIENTS DIVERS','F08010006','','','','',1199919600000,0),(22,2,13,'01020000','1973.40','0.00','Garagistes','F08010004','','','','',1199833200000,1201734000000),(23,1,13,'44571300','0.00','323.40','TVA SUR VENTE 19.6%','F08010004','','','','',1199833200000,1201734000000),(24,0,13,'70700000','0.00','1650.00','VENTES DE MARCHANDISES','F08010004','','','','',1199833200000,1201734000000),(25,2,14,'01000000','1578.72','0.00','CLIENTS DIVERS','F08010005','','','','',1199919600000,1199919600000),(26,1,14,'44571300','0.00','258.72','TVA SUR VENTE 19.6%','F08010005','','','','',1199919600000,1199919600000),(27,0,14,'70700000','0.00','1320.00','VENTES DE MARCHANDISES','F08010005','','','','',1199919600000,1199919600000),(28,2,15,'01000000','6972.68','0.00','CLIENTS DIVERS','F08010006','','','','',1199919600000,1199919600000),(29,1,15,'44571300','0.00','1142.68','TVA SUR VENTE 19.6%','F08010006','','','','',1199919600000,1199919600000),(30,0,15,'70700000','0.00','5830.00','VENTES DE MARCHANDISES','F08010006','','','','',1199919600000,1199919600000),(31,1,16,'51200000','23920.00','0.00','BANQUE','F08010008','','','','',1200092400000,0),(32,0,16,'01000000','0.00','23920.00','CLIENTS DIVERS','F08010008','','','','',1200092400000,0),(33,1,17,'51200000','59800.00','0.00','BANQUE','F08010010','','','','',1200092400000,0),(34,0,17,'01010000','0.00','59800.00','Clients Libraires','F08010010','','','','',1200092400000,0),(35,1,18,'51200000','5980.00','0.00','BANQUE','F08010009','','','','',1200092400000,0),(36,0,18,'01020000','0.00','5980.00','Garagistes','F08010009','','','','',1200092400000,0),(37,1,19,'51200000','32925.88','0.00','BANQUE','F08010007','','','','',1200092400000,0),(38,0,19,'01020000','0.00','32925.88','Garagistes','F08010007','','','','',1200092400000,0),(39,3,20,'01020000','32925.88','0.00','Garagistes','F08010007','','','','',1200092400000,1201734000000),(40,2,20,'44571300','0.00','5395.88','TVA SUR VENTE 19.6%','F08010007','','','','',1200092400000,1201734000000),(41,1,20,'70700000','0.00','25000.00','VENTES DE MARCHANDISES','F08010007','','','','',1200092400000,1201734000000),(42,0,20,'70610100','0.00','2530.00','VENTE PRESTATION SPECIALE','F08010007','','','','',1200092400000,1201734000000),(43,2,21,'01000000','23920.00','0.00','CLIENTS DIVERS','F08010008','','','','',1200092400000,1200092400000),(44,1,21,'44571300','0.00','3920.00','TVA SUR VENTE 19.6%','F08010008','','','','',1200092400000,1200092400000),(45,0,21,'70700000','0.00','20000.00','VENTES DE MARCHANDISES','F08010008','','','','',1200092400000,1200092400000),(46,2,22,'01020000','5980.00','0.00','Garagistes','F08010009','','','','',1200092400000,1201734000000),(47,1,22,'44571300','0.00','980.00','TVA SUR VENTE 19.6%','F08010009','','','','',1200092400000,1201734000000),(48,0,22,'70700000','0.00','5000.00','VENTES DE MARCHANDISES','F08010009','','','','',1200092400000,1201734000000),(49,2,23,'01010000','59800.00','0.00','Clients Libraires','F08010010','','','','',1200092400000,1200092400000),(50,1,23,'44571300','0.00','9800.00','TVA SUR VENTE 19.6%','F08010010','','','','',1200092400000,1200092400000),(51,0,23,'70700000','0.00','50000.00','VENTES DE MARCHANDISES','F08010010','','','','',1200092400000,1200092400000),(52,3,24,'01000000','4732.44','0.00','CLIENTS DIVERS','F08010011','','','','',1200265200000,1200265200000),(53,2,24,'44571300','0.00','775.55','TVA SUR VENTE 19.6%','F08010011','','','','',1200265200000,1200265200000),(54,1,24,'70700000','0.00','3413.75','VENTES DE MARCHANDISES','F08010011','','','','',1200265200000,1200265200000),(55,0,24,'70610100','0.00','543.14','VENTE PRESTATION SPECIALE','F08010011','','','','',1200265200000,1200265200000),(56,2,25,'01000000','2805.42','0.00','CLIENTS DIVERS','F08010012','','','','',1200265200000,1200265200000),(57,1,25,'44571300','0.00','459.75','TVA SUR VENTE 19.6%','F08010012','','','','',1200265200000,1200265200000),(58,0,25,'70700000','0.00','2345.67','VENTES DE MARCHANDISES','F08010012','','','','',1200265200000,1200265200000),(59,1,26,'51200000','2000.00','0.00','BANQUE','F08010011','','','','',1200265200000,0),(60,0,26,'01000000','0.00','2000.00','CLIENTS DIVERS','F08010011','','','','',1200265200000,0),(61,1,27,'51200000','2805.42','0.00','BANQUE','F08010012','','','','',1200265200000,0),(62,0,27,'01000000','0.00','2805.42','CLIENTS DIVERS','F08010012','','','','',1200265200000,0),(63,1,28,'51200000','1000.00','0.00','BANQUE','F08010011','','','','',1200265200000,0),(64,0,28,'01000000','0.00','1000.00','CLIENTS DIVERS','F08010011','','','','',1200265200000,0),(65,1,31,'08000100','0.00','100.00','MON FOURNISSEUR','F07120002','','FAC','','',1196722800000,0),(66,0,31,'51200000','100.00','0.00','MON FOURNISSEUR','F07120002','','FAC','','',1196722800000,0),(67,3,33,'01000000','501.52','0.00','CLIENTS DIVERS','F08010013','','','','',1200265200000,1201734000000),(68,2,33,'44571300','0.00','82.19','TVA SUR VENTE 19.6%','F08010013','','','','',1200265200000,1201734000000),(69,1,33,'70700000','0.00','309.33','VENTES DE MARCHANDISES','F08010013','','','','',1200265200000,1201734000000),(70,0,33,'70610100','0.00','110.00','VENTE PRESTATION SPECIALE','F08010013','','','','',1200265200000,1201734000000),(71,2,34,'01000000','0.00','131.56','CLIENTS DIVERS','A08010014','','','','',1200265200000,0),(72,1,34,'44571300','21.56','0.00','TVA SUR VENTE 19.6%','A08010014','','','','',1200265200000,0),(73,0,34,'70610100','110.00','0.00','VENTE PRESTATION SPECIALE','A08010014','','','','',1200265200000,0),(74,2,37,'01000000','2990.00','0.00','CLIENTS DIVERS','F08010015','','','','',1200438000000,1200438000000),(75,1,37,'44571300','0.00','490.00','TVA SUR VENTE 19.6%','F08010015','','','','',1200438000000,1200438000000),(76,0,37,'70700000','0.00','2500.00','VENTES DE MARCHANDISES','F08010015','','','','',1200438000000,1200438000000),(77,2,40,'08000000','0.00','23.92','FOURNISSEURS DIVERS','F000125','','','','',1210888800000,1212184800000),(78,1,40,'44566300','3.92','0.00','TVA SUR ACHAT 19.6%','F000125','','','','',1210888800000,1212184800000),(79,0,40,'60700000','20.00','0.00','ACHATS DE MARCHANDISES','F000125','','','','',1210888800000,1212184800000),(80,2,43,'08000000','0.00','119.60','FOURNISSEURS DIVERS','FAC00125','','','','',1211148000000,1212184800000),(81,1,43,'44566300','19.60','0.00','TVA SUR ACHAT 19.6%','FAC00125','','','','',1211148000000,1212184800000),(82,0,43,'60700000','100.00','0.00','ACHATS DE MARCHANDISES','FAC00125','','','','',1211148000000,1212184800000),(83,1,45,'51200000','0.00','119.60','BANQUE','F08050012','','','','',1211234400000,0),(84,0,45,'08000000','119.60','0.00','FOURNISSEURS DIVERS','F08050012','','','','',1211234400000,0),(85,1,46,'51200000','0.00','119.60','BANQUE','FAC00125','','','','',1211234400000,0),(86,0,46,'08000000','119.60','0.00','FOURNISSEURS DIVERS','FAC00125','','','','',1211234400000,0),(87,2,48,'08000000','0.00','8108.88','FOURNISSEURS DIVERS','FAC987456','','','','',1210802400000,1212184800000),(88,1,48,'44566300','1328.88','0.00','TVA SUR ACHAT 19.6%','FAC987456','','','','',1210802400000,1212184800000),(89,0,48,'60700000','6780.00','0.00','ACHATS DE MARCHANDISES','FAC987456','','','','',1210802400000,1212184800000),(90,1,49,'51200000','0.00','23.92','BANQUE','','','','','',1210802400000,0),(91,0,49,'08000000','23.92','0.00','FOURNISSEURS DIVERS','','','','','',1210802400000,0),(92,1,50,'51200000','0.00','8108.88','BANQUE','TEST','','','','',1211234400000,0),(93,0,50,'08000000','8108.88','0.00','FOURNISSEURS DIVERS','TEST','','','','',1211234400000,0),(94,2,52,'08000000','0.00','526.24','FOURNISSEURS DIVERS','FAC789654','','','','',1210197600000,1212184800000),(95,1,52,'44566300','86.24','0.00','TVA SUR ACHAT 19.6%','FAC789654','','','','',1210197600000,1212184800000),(96,0,52,'60700000','440.00','0.00','ACHATS DE MARCHANDISES','FAC789654','','','','',1210197600000,1212184800000),(97,1,53,'51200000','2990.00','0.00','BANQUE','f8010015','','','','',1200438000000,0),(98,0,53,'01000000','0.00','2990.00','CLIENTS DIVERS','f8010015','','','','',1200438000000,0),(99,1,54,'51200000','1732.44','0.00','BANQUE','f08010011','','','','',1200438000000,0),(100,0,54,'01000000','0.00','1732.44','CLIENTS DIVERS','f08010011','','','','',1200438000000,0),(101,1,55,'51200000','5980.00','0.00','BANQUE','F0805001','','','','',1211234400000,0),(102,0,55,'01020000','0.00','5980.00','Garagistes','F0805001','','','','',1211234400000,0),(103,2,56,'01000001','2093.00','0.00','Clients particuliers','F08050002','','','','',1211752800000,1212184800000),(104,1,56,'44571300','0.00','343.00','TVA SUR VENTE 19.6%','F08050002','','','','',1211752800000,1212184800000),(105,0,56,'70610100','0.00','1750.00','VENTE PRESTATION SPECIALE','F08050002','','','','',1211752800000,1212184800000),(106,2,57,'01000000','131.56','0.00','CLIENTS DIVERS','F08030001','','','','',1205708400000,1205708400000),(107,1,57,'44571300','0.00','21.56','TVA SUR VENTE 19.6%','F08030001','','','','',1205708400000,1205708400000),(108,0,57,'70610100','0.00','110.00','VENTE PRESTATION SPECIALE','F08030001','','','','',1205708400000,1205708400000),(109,2,58,'01000000','5980.00','0.00','CLIENTS DIVERS','F08030004','','','','',1206914400000,1207046722025),(110,1,58,'44571300','0.00','980.00','TVA SUR VENTE 19.6%','F08030004','','','','',1206914400000,1207046722025),(111,0,58,'70700000','0.00','5000.00','VENTES DE MARCHANDISES','F08030004','','','','',1206914400000,1207046722025),(112,2,59,'01000000','0.00','1196.00','CLIENTS DIVERS','A08030005','','','','',1206914400000,0),(113,1,59,'44571300','196.00','0.00','TVA SUR VENTE 19.6%','A08030005','','','','',1206914400000,0),(114,0,59,'70700000','1000.00','0.00','VENTES DE MARCHANDISES','A08030005','','','','',1206914400000,0),(115,2,63,'01020000','5980.00','0.00','Garagistes','F08050001','','','','',1211234400000,1212184800000),(116,1,63,'44571300','0.00','980.00','TVA SUR VENTE 19.6%','F08050001','','','','',1211234400000,1212184800000),(117,0,63,'70610100','0.00','5000.00','VENTE PRESTATION SPECIALE','F08050001','','','','',1211234400000,1212184800000),(118,2,64,'01010000','59800.00','0.00','Clients Libraires','F08050003','','','','',1211752800000,1211752800000),(119,1,64,'44571300','0.00','9800.00','TVA SUR VENTE 19.6%','F08050003','','','','',1211752800000,1211752800000),(120,0,64,'70610100','0.00','50000.00','VENTE PRESTATION SPECIALE','F08050003','','','','',1211752800000,1211752800000),(121,2,65,'01000001','119.60','0.00','Clients particuliers','F08080001','','','','',1217628000000,1217628000000),(122,1,65,'44571300','0.00','19.60','TVA SUR VENTE 19.6%','F08080001','','','','',1217628000000,1217628000000),(123,0,65,'70700000','0.00','100.00','VENTES DE MARCHANDISES','F08080001','','','','',1217628000000,1217628000000),(124,4,66,'01000000','1113.72','0.00','CLIENTS DIVERS','F08080002','','','','',1217800800000,1217800800000),(125,3,66,'66500000','34.44','0.00','ESCOMPTES ACCORDES','F08080002','','','','',1217800800000,1217800800000),(126,2,66,'44571300','0.00','188.16','TVA SUR VENTE 19.6%','F08080002','','','','',1217800800000,1217800800000),(127,1,66,'70850000','0.00','80.00','FRAIS DE PORT SUR VENTE','F08080002','','','','',1217800800000,1217800800000),(128,0,66,'70610100','0.00','880.00','VENTE PRESTATION SPECIALE','F08080002','','','','',1217800800000,1217800800000),(129,4,67,'01000000','235.65','0.00','CLIENTS DIVERS','F08080003','','','','',1219788000000,1219788000000),(130,3,67,'44571200','0.00','6.05','TVA SUR VENTE 5.5%','F08080003','','','','',1219788000000,1219788000000),(131,2,67,'44571300','0.00','19.60','TVA SUR VENTE 19.6%','F08080003','','','','',1219788000000,1219788000000),(132,1,67,'70850000','0.00','100.00','FRAIS DE PORT SUR VENTE','F08080003','','','','',1219788000000,1219788000000),(133,0,67,'70610100','0.00','110.00','VENTE PRESTATION SPECIALE','F08080003','','','','',1219788000000,1219788000000),(134,1,69,'51200000','1000.00','0.00','BANQUE','F08080004','','','','',1219788000000,0),(135,0,69,'01020000','0.00','1000.00','Garagistes','F08080004','','','','',1219788000000,0),(136,4,70,'01020000','2012.81','0.00','Garagistes','F08080004','','','','',1219788000000,1220133600000),(137,3,70,'66500000','62.25','0.00','ESCOMPTES ACCORDES','F08080004','','','','',1219788000000,1220133600000),(138,2,70,'44571300','0.00','340.06','TVA SUR VENTE 19.6%','F08080004','','','','',1219788000000,1220133600000),(139,1,70,'70850000','0.00','500.00','FRAIS DE PORT SUR VENTE','F08080004','','','','',1219788000000,1220133600000),(140,0,70,'70610100','0.00','1235.00','VENTE PRESTATION SPECIALE','F08080004','','','','',1219788000000,1220133600000),(141,4,75,'08000000','0.00','43118.94','FOURNISSEURS DIVERS','FAC6541230','','','','',1207000800000,1212184800000),(142,3,75,'44566300','3742.62','0.00','TVA SUR ACHAT 19.6%','FAC6541230','','','','',1207000800000,1212184800000),(143,2,75,'44566200','1057.32','0.00','TVA SUR ACHAT 5.5%','FAC6541230','','','','',1207000800000,1212184800000),(144,1,75,'62410000','231.00','0.00','FRAIS DE PORT SUR ACHAT','FAC6541230','','','','',1207000800000,1212184800000),(145,0,75,'60700000','38088.00','0.00','ACHATS DE MARCHANDISES','FAC6541230','','','','',1207000800000,1212184800000),(146,1,77,'51200000','2243.33','0.00','BANQUE','1199722948408','','','','',1199746800000,0),(147,0,77,'01000000','0.00','2243.33','CLIENTS DIVERS','1199722948408','','','','',1199746800000,0),(148,1,78,'51200000','100.00','0.00','BANQUE','f08010013','','','','',1200438000000,0),(149,0,78,'01000000','0.00','100.00','CLIENTS DIVERS','f08010013','','','','',1200438000000,0),(150,1,79,'51200000','269.96','0.00','BANQUE','F08010013','','','','',1201993200000,0),(151,0,79,'01000000','0.00','269.96','CLIENTS DIVERS','F08010013','','','','',1201993200000,0),(152,1,80,'51200000','239.20','0.00','BANQUE','F08050004','','','','',1212444000000,0),(153,0,80,'01000000','0.00','239.20','CLIENTS DIVERS','F08050004','','','','',1212444000000,0),(154,1,81,'51200000','235.65','0.00','BANQUE','F08080003','','','','',1219960800000,0),(155,0,81,'01000000','0.00','235.65','CLIENTS DIVERS','F08080003','','','','',1219960800000,0),(156,1,82,'51200000','500.00','0.00','BANQUE','F08080004','','','','',1219788000000,0),(157,0,82,'01020000','0.00','500.00','Garagistes','F08080004','','','','',1219788000000,0),(158,1,83,'51200000','512.81','0.00','BANQUE','F08080004','','','','',1222639200000,0),(159,0,83,'01020000','0.00','512.81','Garagistes','F08080004','','','','',1222639200000,0),(160,1,84,'51200000','466.44','0.00','BANQUE','F08090001','','','','',1222639200000,0),(161,0,84,'01000000','0.00','466.44','CLIENTS DIVERS','F08090001','','','','',1222639200000,0),(162,1,85,'51200000','131.56','0.00','BANQUE','F08030001','','','','',1201993200000,0),(163,0,85,'01000000','0.00','131.56','CLIENTS DIVERS','F08030001','','','','',1201993200000,0),(164,1,86,'51200000','27.69','0.00','BANQUE','F0803001','','','','',1201993200000,0),(165,0,86,'01000000','0.00','27.69','CLIENTS DIVERS','F0803001','','','','',1201993200000,0),(166,1,87,'51200000','1016.60','0.00','BANQUE','F08030003','','','','',1201993200000,0),(167,0,87,'01000000','0.00','1016.60','CLIENTS DIVERS','F08030003','','','','',1201993200000,0),(168,1,88,'51200000','4784.00','0.00','BANQUE','F08030004','','','','',1201993200000,0),(169,0,88,'01000000','0.00','4784.00','CLIENTS DIVERS','F08030004','','','','',1201993200000,0),(170,1,89,'51200000','59800.00','0.00','BANQUE','F08050003','','','','',1212444000000,0),(171,0,89,'01010000','0.00','59800.00','Clients Libraires','F08050003','','','','',1212444000000,0),(172,1,90,'51200000','2093.00','0.00','BANQUE','F08050002','','','','',1212444000000,0),(173,0,90,'01000001','0.00','2093.00','Clients particuliers','F08050002','','','','',1212444000000,0),(174,1,91,'51200000','500.00','0.00','BANQUE','F08080002','','','','',1218578400000,0),(175,0,91,'01000000','0.00','500.00','CLIENTS DIVERS','F08080002','','','','',1218578400000,0),(176,1,92,'51200000','119.60','0.00','BANQUE','F08080001','','','','',1218578400000,0),(177,0,92,'01000001','0.00','119.60','Clients particuliers','F08080001','','','','',1218578400000,0),(178,1,93,'51200000','613.72','0.00','BANQUE','F08080002','','','','',1218578400000,0),(179,0,93,'01000000','0.00','613.72','CLIENTS DIVERS','F08080002','','','','',1218578400000,0),(180,1,94,'51200000','1184.04','0.00','BANQUE','F08090004','','','','',1221861600000,0),(181,0,94,'01000000','0.00','1184.04','CLIENTS DIVERS','F08090004','','','','',1221861600000,0),(182,1,95,'51200000','200.00','0.00','BANQUE','1-1','','','','',1221861600000,0),(183,0,95,'01000001','0.00','200.00','Clients particuliers','1-1','','','','',1221861600000,0),(184,1,96,'51200000','0.00','1000.00','BANQUE','FAC6541230','','','','',1212184800000,0),(185,0,96,'08000000','1000.00','0.00','FOURNISSEURS DIVERS','FAC6541230','','','','',1212184800000,0),(186,1,97,'51200000','0.00','1000.00','BANQUE','FAC6541230','','','','',1214776800000,0),(187,0,97,'08000000','1000.00','0.00','FOURNISSEURS DIVERS','FAC6541230','','','','',1214776800000,0),(188,1,98,'51200000','0.00','1000.00','BANQUE','FAC6541230','','','','',1217368800000,0),(189,0,98,'08000000','1000.00','0.00','FOURNISSEURS DIVERS','FAC6541230','','','','',1217368800000,0),(190,1,99,'51200000','0.00','40118.94','BANQUE','FAC6541230','','','','',1220047200000,0),(191,0,99,'08000000','40118.94','0.00','FOURNISSEURS DIVERS','FAC6541230','','','','',1220047200000,0),(192,3,100,'01000000','466.44','0.00','CLIENTS DIVERS','F08090001','','','','',1221084000000,1221084000000),(193,2,100,'44571300','0.00','76.44','TVA SUR VENTE 19.6%','F08090001','','','','',1221084000000,1221084000000),(194,1,100,'70700000','0.00','40.00','VENTES DE MARCHANDISES 19,6%','F08090001','','','','',1221084000000,1221084000000),(195,0,100,'70610100','0.00','350.00','VENTE PRESTATION SPECIALE','F08090001','','','','',1221084000000,1221084000000),(196,4,101,'01000000','1310.82','0.00','CLIENTS DIVERS','F08090002','','','','',1221084000000,1221084000000),(197,3,101,'44571300','0.00','214.82','TVA SUR VENTE 19.6%','F08090002','','','','',1221084000000,1221084000000),(198,2,101,'70850000','0.00','256.00','FRAIS DE PORT SUR VENTE','F08090002','','','','',1221084000000,1221084000000),(199,1,101,'70700000','0.00','400.00','VENTES DE MARCHANDISES 19,6%','F08090002','','','','',1221084000000,1221084000000),(200,0,101,'70610100','0.00','440.00','VENTE PRESTATION SPECIALE','F08090002','','','','',1221084000000,1221084000000),(201,2,102,'01000000','1184.04','0.00','CLIENTS DIVERS','F08090004','','','','',1221602400000,1221666519799),(202,1,102,'44571300','0.00','194.04','TVA SUR VENTE 19.6%','F08090004','','','','',1221602400000,1221666519799),(203,0,102,'70700000','0.00','990.00','VENTES DE MARCHANDISES 19,6%','F08090004','','','','',1221602400000,1221666519799),(204,2,103,'01000000','77.69','0.00','CLIENTS DIVERS','F08090005','','','','',1222639200000,1222639200000),(205,1,103,'44571300','0.00','12.73','TVA SUR VENTE 19.6%','F08090005','','','','',1222639200000,1222639200000),(206,0,103,'70610100','0.00','64.96','VENTE PRESTATION SPECIALE','F08090005','','','','',1222639200000,1222639200000),(207,2,104,'01000000','0.00','541.02','CLIENTS DIVERS','A08090003','','','','',1221084000000,0),(208,1,104,'44571300','88.66','0.00','TVA SUR VENTE 19.6%','A08090003','','','','',1221084000000,0),(209,0,104,'70700000','452.36','0.00','VENTES DE MARCHANDISES 19,6%','A08090003','','','','',1221084000000,0);
/*!40000 ALTER TABLE `OPERATION` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `OPERATION_RAPPROCHEMENT`
--

DROP TABLE IF EXISTS `OPERATION_RAPPROCHEMENT`;
CREATE TABLE `OPERATION_RAPPROCHEMENT` (
  `Op_Id` int(10) unsigned NOT NULL auto_increment,
  `Code_Journal` char(3) default '',
  `Periode` bigint(20) unsigned default '0',
  `Date_Op` bigint(20) unsigned default '0',
  `Numero_Compte` varchar(8) default '',
  `Libelle` varchar(100) default '',
  `Num_Piece` varchar(20) default '',
  `Pointe` char(1) default '',
  `Montant_D` decimal(14,2) default '0.00',
  `Montant_C` decimal(14,2) default '0.00',
  `Equilibre` char(1) default 'n',
  `Ligne_Id` int(10) unsigned default '0',
  PRIMARY KEY  (`Op_Id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `OPERATION_RAPPROCHEMENT`
--

LOCK TABLES `OPERATION_RAPPROCHEMENT` WRITE;
/*!40000 ALTER TABLE `OPERATION_RAPPROCHEMENT` DISABLE KEYS */;
/*!40000 ALTER TABLE `OPERATION_RAPPROCHEMENT` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `RAPPROCHEMENT_BANCAIRE`
--

DROP TABLE IF EXISTS `RAPPROCHEMENT_BANCAIRE`;
CREATE TABLE `RAPPROCHEMENT_BANCAIRE` (
  `Code_Journal` char(3) NOT NULL,
  `Periode` bigint(20) unsigned NOT NULL,
  `Libelle` varchar(50) default '',
  `Solde_Comptable` decimal(16,2) default '0.00',
  `Ancien_Solde_Banque` decimal(16,2) default '0.00',
  `Nouveau_Solde_Banque` decimal(16,2) default '0.00',
  `Clos` char(1) default 'n',
  `Date_Validation` bigint(20) unsigned default '0',
  PRIMARY KEY  (`Code_Journal`,`Periode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `RAPPROCHEMENT_BANCAIRE`
--

LOCK TABLES `RAPPROCHEMENT_BANCAIRE` WRITE;
/*!40000 ALTER TABLE `RAPPROCHEMENT_BANCAIRE` DISABLE KEYS */;
/*!40000 ALTER TABLE `RAPPROCHEMENT_BANCAIRE` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2008-12-15 10:22:49
