-- MySQL dump 10.11
--
-- Host: localhost    Database: peg_erp
-- ------------------------------------------------------
-- Server version	5.0.84-community-nt

/*!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 `z_t02_2cp`
--

DROP TABLE IF EXISTS `z_t02_2cp`;
CREATE TABLE `z_t02_2cp` (
  `nr01` bigint(10) NOT NULL default '0',
  `p01` int(6) NOT NULL default '0',
  `p02` char(40) NOT NULL default '',
  `p03` int(2) NOT NULL default '0',
  `p04` int(2) NOT NULL default '0',
  `p05` int(2) NOT NULL default '0',
  `p011` int(2) NOT NULL default '0',
  `p010` int(2) NOT NULL default '0',
  `p07` int(2) NOT NULL default '0',
  `p08` int(2) NOT NULL default '0',
  `p09` int(2) NOT NULL default '0',
  `p012` int(1) NOT NULL default '0',
  `p0101` tinyint(1) NOT NULL default '0',
  `p0102` tinyint(1) NOT NULL default '0',
  `p0901` char(20) NOT NULL default '',
  `p0902` char(100) NOT NULL default '',
  `p0903` bigint(10) NOT NULL default '0',
  `p201` bigint(10) NOT NULL default '0',
  `p30` longtext,
  `remdate` date NOT NULL default '0100-01-01',
  `remtime` char(10) NOT NULL default '',
  `remuser` char(30) NOT NULL default '',
  `remfdate` date NOT NULL default '0100-01-01',
  `remftime` char(10) NOT NULL default '',
  `remfuser` char(30) NOT NULL default '',
  `remguc` char(30) NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=greek;

--
-- Dumping data for table `z_t02_2cp`
--

LOCK TABLES `z_t02_2cp` WRITE;
/*!40000 ALTER TABLE `z_t02_2cp` DISABLE KEYS */;
INSERT INTO `z_t02_2cp` VALUES (71,90001,'Λογιστικό Σημείωμα',1,1,0,0,0,0,0,0,1,0,0,'','',0,0,'#','2017-06-21','13:22:51','tesae','2017-06-21','13:21:38','tesae','');
/*!40000 ALTER TABLE `z_t02_2cp` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `z_t10_2cp`
--

DROP TABLE IF EXISTS `z_t10_2cp`;
CREATE TABLE `z_t10_2cp` (
  `nr01` bigint(10) NOT NULL default '0',
  `p01` int(5) NOT NULL default '0',
  `p00` char(5) NOT NULL default '',
  `p02` char(40) NOT NULL default '',
  `p02_1` char(60) NOT NULL default '',
  `p04` int(6) NOT NULL default '0',
  `p06` bigint(10) NOT NULL default '0',
  `p010` int(5) NOT NULL default '0',
  `p07` char(40) NOT NULL default '',
  `p08` char(100) NOT NULL default '',
  `p040` int(6) NOT NULL default '0',
  `p203` tinyint(1) NOT NULL default '0',
  `p0100` tinyint(1) NOT NULL default '0',
  `p0101` tinyint(1) NOT NULL default '0',
  `p0102` int(1) NOT NULL default '0',
  `p110` tinyint(1) NOT NULL default '0',
  `p0106` char(10) NOT NULL default '',
  `p0107` char(10) NOT NULL default '',
  `p30` longtext,
  `p0103` int(4) NOT NULL default '0',
  `p0104` int(4) NOT NULL default '0',
  `p0201` tinyint(1) NOT NULL default '0',
  `p0202` tinyint(1) NOT NULL default '0',
  `p0203` char(30) NOT NULL default '',
  `p0204` tinyint(1) NOT NULL default '0',
  `remdate` date NOT NULL default '0100-01-01',
  `remtime` char(10) NOT NULL default '',
  `remuser` char(30) NOT NULL default '',
  `remfdate` date NOT NULL default '0100-01-01',
  `remftime` char(10) NOT NULL default '',
  `remfuser` char(30) NOT NULL default '',
  `remguc` char(30) NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=greek;

--
-- Dumping data for table `z_t10_2cp`
--

LOCK TABLES `z_t10_2cp` WRITE;
/*!40000 ALTER TABLE `z_t10_2cp` DISABLE KEYS */;
INSERT INTO `z_t10_2cp` VALUES (35,90001,'ΛΟΓ','Λογιστικό Σημείωμα','',90001,0,0,'apopa.frp','',0,1,0,0,3,0,'100','','',0,0,0,0,'',0,'2020-09-14','14:57:59','tesae','2017-06-21','13:20:09','tesae','');
/*!40000 ALTER TABLE `z_t10_2cp` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `z_t11_2cp`
--

DROP TABLE IF EXISTS `z_t11_2cp`;
CREATE TABLE `z_t11_2cp` (
  `nr01` bigint(10) NOT NULL default '0',
  `p01` char(10) NOT NULL default '',
  `p02` char(50) NOT NULL default '',
  `p017` decimal(14,2) NOT NULL default '0.00',
  `p018` decimal(14,2) NOT NULL default '0.00',
  `p015` tinyint(1) NOT NULL default '0',
  `p08` tinyint(1) NOT NULL default '0',
  `p03` int(1) NOT NULL default '0',
  `p019` int(2) NOT NULL default '0',
  `p04` tinyint(1) NOT NULL default '0',
  `p05` tinyint(1) NOT NULL default '0',
  `p06` char(30) NOT NULL default '',
  `p07` char(30) NOT NULL default '',
  `p010` tinyint(1) NOT NULL default '0',
  `p012` int(5) NOT NULL default '0',
  `p014` char(10) NOT NULL default '',
  `p020` int(6) NOT NULL default '0',
  `p09` char(100) NOT NULL default '',
  `p016` int(4) NOT NULL default '0',
  `p201` bigint(10) NOT NULL default '0',
  `p30` longtext,
  `remdate` date NOT NULL default '0100-01-01',
  `remtime` char(10) NOT NULL default '',
  `remuser` char(30) NOT NULL default '',
  `remfdate` date NOT NULL default '0100-01-01',
  `remftime` char(10) NOT NULL default '',
  `remfuser` char(30) NOT NULL default '',
  `remguc` char(30) NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=greek;

--
-- Dumping data for table `z_t11_2cp`
--

LOCK TABLES `z_t11_2cp` WRITE;
/*!40000 ALTER TABLE `z_t11_2cp` DISABLE KEYS */;
INSERT INTO `z_t11_2cp` VALUES (2,'90001.01','Χρέωση Λογαριασμού (Καθαρά)','0.00','0.00',0,0,2,0,1,0,'','',0,-1,'',0,'',0,0,'#90001#','2017-06-21','13:25:35','tesae','2017-06-21','13:24:48','tesae',''),(3,'90001.02','Πίστωση Λογαριασμού (ΦΠΑ)','0.00','0.00',0,0,3,0,0,1,'','',0,-1,'',0,'',0,0,'#90001#','2017-06-21','13:25:38','tesae','2017-06-21','13:25:28','tesae',''),(4,'90001.03','Χρέωση Αντισυμβαλλόμενου (Καθαρά)','0.00','0.00',0,0,2,0,1,0,'','',1,-1,'',4001,'',0,0,'#90001#','2020-09-14','14:58:29','tesae','2017-06-21','13:26:33','tesae',''),(5,'90001.04','Πίστωση Αντισυμβαλλόμενου (ΦΠΑ)','0.00','0.00',0,0,3,0,0,1,'','',1,-1,'',4101,'',0,0,'#90001#','2020-09-14','14:58:47','tesae','2017-06-21','13:27:06','tesae','');
/*!40000 ALTER TABLE `z_t11_2cp` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `z_l20_2cp`
--

DROP TABLE IF EXISTS `z_l20_2cp`;
CREATE TABLE `z_l20_2cp` (
  `nr01` bigint(10) NOT NULL default '0',
  `p1` int(6) NOT NULL default '0',
  `p2` int(4) NOT NULL default '0',
  `p4` char(30) NOT NULL default '',
  `p700` tinyint(1) NOT NULL default '0',
  `p5` int(1) NOT NULL default '0',
  `p01` int(2) NOT NULL default '0',
  `p02` int(2) NOT NULL default '0',
  `p03` int(2) NOT NULL default '0',
  `p101` int(2) NOT NULL default '0',
  `p102` int(2) NOT NULL default '0',
  `p103` int(2) NOT NULL default '0',
  `p104` int(2) NOT NULL default '0',
  `p105` int(2) NOT NULL default '0',
  `p106` int(2) NOT NULL default '0',
  `p107` int(2) NOT NULL default '0',
  `p108` int(2) NOT NULL default '0',
  `p109` int(2) NOT NULL default '0',
  `p201` int(2) NOT NULL default '0',
  `p202` int(2) NOT NULL default '0',
  `p203` int(2) NOT NULL default '0',
  `p204` int(2) NOT NULL default '0',
  `p205` int(2) NOT NULL default '0',
  `p206` int(2) NOT NULL default '0',
  `p207` int(2) NOT NULL default '0',
  `p208` int(2) NOT NULL default '0',
  `p209` int(2) NOT NULL default '0',
  `p300` tinyint(1) NOT NULL default '0',
  `p301` int(2) NOT NULL default '0',
  `p302` int(2) NOT NULL default '0',
  `p401` char(100) NOT NULL default '',
  `p402` char(100) NOT NULL default '',
  `p403` char(100) NOT NULL default '',
  `p404` char(100) NOT NULL default '',
  `p405` char(100) NOT NULL default '',
  `p406` char(100) NOT NULL default '',
  `p407` char(100) NOT NULL default '',
  `p408` char(100) NOT NULL default '',
  `p409` char(100) NOT NULL default '',
  `p410` char(100) NOT NULL default '',
  `p411` longtext,
  `p501` longtext,
  `p502` int(2) NOT NULL default '0',
  `pd01` int(5) NOT NULL default '0',
  `p180` int(2) NOT NULL default '0',
  `p181` int(2) NOT NULL default '0',
  `p182` int(2) NOT NULL default '0',
  `p183` int(2) NOT NULL default '0',
  `p184` int(2) NOT NULL default '0',
  `p185` int(2) NOT NULL default '0',
  `p303` tinyint(1) NOT NULL default '0',
  `p304` int(2) NOT NULL default '0',
  `p305` int(2) NOT NULL default '0',
  `p306` int(2) NOT NULL default '0',
  `p701` int(1) NOT NULL default '0',
  `p412` longtext,
  `p307` int(2) NOT NULL default '0',
  `p308` int(2) NOT NULL default '0',
  `p309` int(2) NOT NULL default '0',
  `remdate` date NOT NULL default '0100-01-01',
  `remtime` char(10) NOT NULL default '',
  `remuser` char(30) NOT NULL default '',
  `remfdate` date NOT NULL default '0100-01-01',
  `remftime` char(10) NOT NULL default '',
  `remfuser` char(30) NOT NULL default '',
  `remguc` char(30) NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=greek;

--
-- Dumping data for table `z_l20_2cp`
--

LOCK TABLES `z_l20_2cp` WRITE;
/*!40000 ALTER TABLE `z_l20_2cp` DISABLE KEYS */;
INSERT INTO `z_l20_2cp` VALUES (72,90001,1,'',0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,'k, 1, 13','','','','','','','','','','','',0,1,0,0,0,0,0,0,1,0,0,0,1,'',0,0,0,'2017-06-21','13:35:35','tesae','2017-06-21','13:35:35','tesae',''),(73,90001,1,'',0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,'f, 1, 13','','','','','','','','','','','',0,2,0,0,0,0,0,0,1,0,0,0,1,'',0,0,0,'2017-06-21','13:35:36','tesae','2017-06-21','13:35:36','tesae','');
/*!40000 ALTER TABLE `z_l20_2cp` 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 2020-09-14 12:03:07
