-- MySQL dump 10.16  Distrib 10.1.48-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: SPYquartup1
-- ------------------------------------------------------
-- Server version	10.1.48-MariaDB-0+deb9u2

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

DROP TABLE IF EXISTS `cialasieplalin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cialasieplalin` (
  `num_planasi` int(11) NOT NULL DEFAULT '0' COMMENT 'Plantilla',
  `num_apunte` int(11) NOT NULL DEFAULT '0' COMMENT 'Apunte plantilla',
  `cod_cuenta` char(12) NOT NULL DEFAULT '' COMMENT 'Cuenta',
  `cod_contracuenta` char(12) NOT NULL DEFAULT '' COMMENT 'Contracuenta',
  `documento` char(30) NOT NULL DEFAULT '' COMMENT 'Documento',
  `cod_clave` char(2) NOT NULL DEFAULT '' COMMENT 'Clave contable',
  `concepto` char(250) NOT NULL DEFAULT '' COMMENT 'Concepto',
  `importe_mone_d` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Importe Debe',
  `importe_euro_d` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Importe Debe Euros ',
  `importe_mone_h` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Importe Haber',
  `importe_euro_h` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Importe Haber Euros',
  `id_tenant` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Nº empresa',
  `id_cialceco` int(11) NOT NULL DEFAULT '0' COMMENT 'Centro coste',
  UNIQUE KEY `key0` (`id_tenant`,`num_planasi`,`num_apunte`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cialasieplalin`
--
-- WHERE:  id_tenant='1'

LOCK TABLES `cialasieplalin` WRITE;
/*!40000 ALTER TABLE `cialasieplalin` DISABLE KEYS */;
INSERT INTO `cialasieplalin` (`num_planasi`, `num_apunte`, `cod_cuenta`, `cod_contracuenta`, `documento`, `cod_clave`, `concepto`, `importe_mone_d`, `importe_euro_d`, `importe_mone_h`, `importe_euro_h`, `id_tenant`, `id_cialceco`) VALUES (1,10,'465000003','','','N','PAGO NOMINAS',1210.76,1210.76,0.00,0.00,1,0),(1,20,'465000004','','','N','PAGO NOMINAS',1274.21,1274.21,0.00,0.00,1,0),(1,30,'465000005','','','N','PAGO NOMINAS',1311.46,1311.46,0.00,0.00,1,0),(1,50,'465000007','','','N','PAGO NOMINAS',632.85,632.85,0.00,0.00,1,0),(1,51,'465000008','','','N','PAGO NOMINAS',1010.20,1010.20,0.00,0.00,1,0),(1,53,'465000010','','','N','PAGO NOMINAS',4757.86,4757.86,0.00,0.00,1,0),(1,54,'465000011','','','N','PAGO NOMINAS',1361.37,1361.37,0.00,0.00,1,0),(1,55,'465000012','','','N','PAGO NOMINAS',1326.95,1326.95,0.00,0.00,1,0),(1,56,'465000013','','','N','PAGO NOMINAS',1004.01,1004.01,0.00,0.00,1,0),(1,60,'465000020','','','N','PAGO NOMINAS',1175.00,1175.00,0.00,0.00,1,0),(1,61,'465000022','','','N','PAGO NOMINAS',950.00,950.00,0.00,0.00,1,0),(1,63,'465000025','','','N','PAGO NOMINAS',1500.00,1500.00,0.00,0.00,1,0),(1,64,'465000026','','','N','PAGO NOMINAS',1785.00,1785.00,0.00,0.00,1,0),(1,65,'465000027','','','N','PAGO NOMINAS',950.00,950.00,0.00,0.00,1,0),(1,66,'465000028','','','N','PAGO NOMINAS',950.00,950.00,0.00,0.00,1,0),(1,67,'465000030','','','N','PAGO NOMINAS',2270.00,2270.00,0.00,0.00,1,0),(1,68,'465000031','','','N','PAGO NOMINAS',970.00,970.00,0.00,0.00,1,0),(1,75,'465000040','','','N','PAGO NOMINAS',950.00,950.00,0.00,0.00,1,0),(1,76,'465000041','','','N','PAGO NOMINAS',939.74,939.74,0.00,0.00,1,0),(1,79,'465000039','','','N','NOMINA',1100.00,1100.00,0.00,0.00,1,0),(1,83,'465000053','','','N','NOMINA',950.00,950.00,0.00,0.00,1,0),(1,84,'465000046','','','N','NOMINA',2107.18,2107.18,0.00,0.00,1,0),(1,87,'465000051','','','N','NOMINA',1500.00,1500.00,0.00,0.00,1,0),(1,89,'465000052','','','N','NOMINA',1124.18,1124.18,0.00,0.00,1,0),(1,91,'465000047','','','N','NOMINA',935.00,935.00,0.00,0.00,1,0),(1,92,'572000000','','','','PAGO NOMINAS',0.00,0.00,34045.77,34045.77,1,0),(2,10,'520000001','','','56','RECIBO PP. ICO',1.00,1.00,0.00,0.00,1,0),(2,20,'662200001','','','56','RECIBO PP. ICO',1.00,1.00,0.00,0.00,1,0),(2,30,'572000001','','','57','RECIBO PP. ICO',0.00,0.00,1.00,1.00,1,0),(3,10,'572000001','','','58','INT.N/F.DEUTE S',1.00,1.00,0.00,0.00,1,0),(3,20,'769000000','','','59','INT. DS. CPVE',0.00,0.00,1.00,1.00,1,0),(4,10,'520000000','','','56','RECIBO PP. ICO',1.00,1.00,0.00,0.00,1,0),(4,20,'662200000','','','56','RECIBO PP. ICO',1.00,1.00,0.00,0.00,1,0),(4,40,'572000001','','','57','RECIBO PP. ICO',0.00,0.00,1.00,1.00,1,0),(5,10,'769000000','','','60','INT. N/F. CEC',0.00,0.00,1.00,1.00,1,0),(5,20,'572000000','','','51','INTERESES N/F',1.00,1.00,0.00,0.00,1,0),(5,30,'473000000','','','61','IRC. INT. CEC',1.00,1.00,0.00,0.00,1,0),(5,40,'572000000','','','53','IRC. INT.',0.00,0.00,1.00,1.00,1,0),(6,10,'769000000','','','50','INT. N/F CPVE',0.00,0.00,1.00,1.00,1,0),(6,20,'572000001','','','51','INTERESES N/F',1.00,1.00,0.00,0.00,1,0),(6,30,'473000000','','','52','IRC. INT. CPVE',1.00,1.00,0.00,0.00,1,0),(6,40,'572000001','','','53','IRC. INT.',0.00,0.00,1.00,1.00,1,0),(6,50,'626000000','','','54','COM. MANTTO.',1.00,1.00,0.00,0.00,1,0),(6,60,'572000001','','','55','G. Y SERV.BANC.',0.00,0.00,1.00,1.00,1,0),(7,10,'522000001','','','LE','LEASING',1.00,1.00,0.00,0.00,1,0),(7,20,'478000001','','','LE','LEASING',0.00,0.00,1.00,1.00,1,0),(7,30,'660000001','','','LE','LEASING',1.00,1.00,0.00,0.00,1,0),(7,40,'276000001','','','LE','LEASING',0.00,0.00,1.00,1.00,1,0),(7,50,'681000001','','','LE','LEASING',1.00,1.00,0.00,0.00,1,0),(7,60,'281000001','','','LE','LEASING',0.00,0.00,1.00,1.00,1,0),(9,10,'522000004','','','LE','LEASING',1.00,1.00,0.00,0.00,1,0),(9,20,'478000004','','','LE','LEASING',0.00,0.00,1.00,1.00,1,0),(9,30,'660000004','','','LE','LEASING',1.00,1.00,0.00,0.00,1,0),(9,40,'276000004','','','LE','LEASING',0.00,0.00,1.00,1.00,1,0),(9,50,'681000004','','','LE','LEASING',1.00,1.00,0.00,0.00,1,0),(9,60,'281000004','','','LE','LEASING',0.00,0.00,1.00,1.00,1,0),(10,10,'522000005','','','LE','LEASING',1.00,1.00,0.00,0.00,1,0),(10,20,'478000005','','','LE','LEASING',0.00,0.00,1.00,1.00,1,0),(10,30,'660000005','','','LE','LEASING',1.00,1.00,0.00,0.00,1,0),(10,40,'276000005','','','LE','LEASING',0.00,0.00,1.00,1.00,1,0),(10,50,'681000005','','','LE','LEASING',1.00,1.00,0.00,0.00,1,0),(10,60,'281000005','','','LE','LEASING',0.00,0.00,1.00,1.00,1,0),(11,10,'522000006','','','LE','LEASING',1.00,1.00,0.00,0.00,1,0),(11,20,'487000006','','','LE','LEASING',0.00,0.00,1.00,1.00,1,0),(11,30,'662000006','','','LE','LEASING',1.00,1.00,0.00,0.00,1,0),(11,40,'276000006','','','LE','LEASING',0.00,0.00,1.00,1.00,1,0),(11,50,'681000006','','','LE','LEASING',1.00,1.00,0.00,0.00,1,0),(11,60,'281000006','','','LE','LEASING',0.00,0.00,1.00,1.00,1,0),(12,10,'522000007','','','LE','LEASING',1.00,1.00,0.00,0.00,1,0),(12,20,'487000007','','','LE','LEASING',0.00,0.00,1.00,1.00,1,0),(12,21,'662000007','','','LE','LEASING',1.00,1.00,0.00,0.00,1,0),(12,40,'276000007','','','LE','LEASING',0.00,0.00,1.00,1.00,1,0),(12,50,'681000007','','','LE','LEASING',1.00,1.00,0.00,0.00,1,0),(12,60,'281000007','','','LE','LEASING',0.00,0.00,1.00,1.00,1,0),(13,10,'522000008','','','LE','LEASING',1.00,1.00,0.00,0.00,1,0),(13,20,'487000008','','','LE','LEASING',0.00,0.00,1.00,1.00,1,0),(13,21,'662000008','','','LE','LEASING',1.00,1.00,0.00,0.00,1,0),(13,40,'276000008','','','LE','LEASING',0.00,0.00,1.00,1.00,1,0),(13,50,'681000008','','','LE','LEASING',1.00,1.00,0.00,0.00,1,0),(13,60,'281000008','','','LE','LEASING',0.00,0.00,1.00,1.00,1,0),(14,1,'640000003','','','9N','NOMINA',1647.44,1647.44,0.00,0.00,1,0),(14,2,'476000000','','','9N','NOMINA',0.00,0.00,117.72,117.72,1,0),(14,3,'475100000','','','9N','NOMINA',0.00,0.00,193.57,193.57,1,0),(14,4,'465000003','','','9N','NOMINA',0.00,0.00,1336.15,1336.15,1,0),(15,1,'640000004','','','9N','NOMINA',1558.95,1558.95,0.00,0.00,1,0),(15,2,'476000000','','','9N','NOMINA',0.00,0.00,111.23,111.23,1,0),(15,3,'475100000','','','9N','NOMINA',0.00,0.00,173.51,173.51,1,0),(15,4,'465000004','','','9N','NOMINA',0.00,0.00,1274.21,1274.21,1,0),(16,1,'640000005','','','9N','NOMINA',1633.19,1633.19,0.00,0.00,1,0),(16,2,'476000000','','','9N','NOMINA',0.00,0.00,115.78,115.78,1,0),(16,3,'475100000','','','9N','NOMINA',0.00,0.00,205.95,205.95,1,0),(16,4,'465000005','','','9N','NOMINA',0.00,0.00,1311.46,1311.46,1,0),(18,1,'640000007','','','9N','NOMINA',681.72,681.72,0.00,0.00,1,0),(18,2,'476000000','','','9N','NOMINA',0.00,0.00,48.66,48.66,1,0),(18,3,'465000007','','','9N','NOMINA',0.00,0.00,633.06,633.06,1,0),(19,1,'640000008','','','9N','NOMINA',1139.90,1139.90,0.00,0.00,1,0),(19,2,'476000000','','','9N','NOMINA',0.00,0.00,81.94,81.94,1,0),(19,3,'475100000','','','9N','NOMINA',0.00,0.00,47.76,47.76,1,0),(19,4,'465000008','','','9N','NOMINA',0.00,0.00,1010.20,1010.20,1,0),(21,1,'640000010','','','9N','NOMINA',7142.86,7142.86,0.00,0.00,1,0),(21,2,'475100000','','','9N','NOMINA',0.00,0.00,2385.00,2385.00,1,0),(21,3,'465000010','','','9N','NOMINA',0.00,0.00,4757.86,4757.86,1,0),(22,1,'640000011','','','9N','NOMINA',1692.51,1692.51,0.00,0.00,1,0),(22,2,'476000000','','','9N','NOMINA',0.00,0.00,123.64,123.64,1,0),(22,3,'475100000','','','9N','NOMINA',0.00,0.00,207.50,207.50,1,0),(22,4,'465000011','','','9N','NOMINA',0.00,0.00,1361.37,1361.37,1,0),(23,1,'640000012','','','9N','NOMINA',1649.45,1649.45,0.00,0.00,1,0),(23,2,'476000000','','','9N','NOMINA',0.00,0.00,115.16,115.16,1,0),(23,3,'475100000','','','9N','NOMINA',0.00,0.00,207.34,207.34,1,0),(23,4,'465000012','','','9N','NOMINA',0.00,0.00,1326.95,1326.95,1,0),(24,1,'640000013','','','9N','NOMINA',1135.51,1135.51,0.00,0.00,1,0),(24,2,'476000000','','','9N','NOMINA',0.00,0.00,82.22,82.22,1,0),(24,3,'475100000','','','9N','NOMINA',0.00,0.00,49.28,49.28,1,0),(24,4,'465000013','','','9N','NOMINA',0.00,0.00,1004.01,1004.01,1,0),(30,1,'640000022','','','9N','NOMINA',1145.95,1145.95,0.00,0.00,1,0),(30,2,'476000000','','','9N','NOMINA',0.00,0.00,79.66,79.66,1,0),(30,3,'475100000','','','9N','NOMINA',0.00,0.00,85.29,85.29,1,0),(30,4,'465000022','','','9N','NOMINA',0.00,0.00,950.00,950.00,1,0),(32,1,'640000025','','','9N','NOMINA',1906.17,1906.17,0.00,0.00,1,0),(32,2,'476000000','','','9N','NOMINA',0.00,0.00,139.50,139.50,1,0),(32,3,'475100000','','','9N','NOMINA',0.00,0.00,266.67,266.67,1,0),(32,4,'465000025','','','9N','NOMINA',0.00,0.00,1500.00,1500.00,1,0),(33,1,'640000026','','','9N','NOMINA',2209.71,2209.71,0.00,0.00,1,0),(33,2,'476000000','','','9N','NOMINA',0.00,0.00,140.32,140.32,1,0),(33,3,'475100000','','','9N','NOMINA',0.00,0.00,284.39,284.39,1,0),(33,4,'465000026','','','9N','NOMINA',0.00,0.00,1785.00,1785.00,1,0),(34,1,'640000027','','','9N','NOMINA',1027.40,1027.40,0.00,0.00,1,0),(34,2,'476000000','','','9N','NOMINA',0.00,0.00,74.52,74.52,1,0),(34,3,'475100000','','','9N','NOMINA',0.00,0.00,2.88,2.88,1,0),(34,4,'465000027','','','9N','NOMINA',0.00,0.00,950.00,950.00,1,0),(35,1,'640000028','','','9N','NOMINA',1024.33,1024.33,0.00,0.00,1,0),(35,2,'476000000','','','9N','NOMINA',0.00,0.00,74.33,74.33,1,0),(35,4,'465000028','','','9N','NOMINA',0.00,0.00,950.00,950.00,1,0),(36,1,'640000030','','','9N','NOMINA',2857.14,2857.14,0.00,0.00,1,0),(36,2,'475100000','','','9N','NOMINA',0.00,0.00,587.14,587.14,1,0),(36,3,'465000030','','','9N','NOMINA',0.00,0.00,2270.00,2270.00,1,0),(37,1,'640000031','','','9N','NOMINA',1088.96,1088.96,0.00,0.00,1,0),(37,2,'476000000','','','9N','NOMINA',0.00,0.00,78.51,78.51,1,0),(37,3,'475100000','','','9N','NOMINA',0.00,0.00,10.45,10.45,1,0),(37,4,'465000031','','','9N','NOMINA',0.00,0.00,1000.00,1000.00,1,0),(44,1,'640000041','','','','NOMINA',1083.00,1083.00,0.00,0.00,1,0),(44,2,'476000000','','','','NOMINA',0.00,0.00,80.22,80.22,1,0),(44,3,'475100000','','','','NOMINA',0.00,0.00,81.98,81.98,1,0),(44,4,'465000041','','','','NOMINA',0.00,0.00,920.80,920.80,1,0),(45,1,'640000038','','','','NOMINA',1047.34,1047.34,0.00,0.00,1,0),(45,2,'476000000','','','','NOMINA',0.00,0.00,76.39,76.39,1,0),(45,3,'475100000','','','','NOMINA',0.00,0.00,20.95,20.95,1,0),(45,4,'465000038','','','','NOMINA',0.00,0.00,950.00,950.00,1,0),(46,1,'640000039','','','','NOMINA',1300.92,1300.92,0.00,0.00,1,0),(46,2,'476000000','','','','NOMINA',0.00,0.00,91.90,91.90,1,0),(46,3,'475100000','','','','NOMINA',0.00,0.00,109.02,109.02,1,0),(46,4,'465000039','','','','NOMINA',0.00,0.00,1100.00,1100.00,1,0),(47,1,'640000040','','','','NOMINA',992.00,992.00,0.00,0.00,1,0),(47,2,'476000000','','','','NOMINA',0.00,0.00,72.16,72.16,1,0),(47,3,'475100000','','','','NOMINA',0.00,0.00,19.84,19.84,1,0),(47,4,'465000040','','','','NOMINA',0.00,0.00,900.00,900.00,1,0),(50,1,'640000046','','','','NOMINA',2857.14,2857.14,0.00,0.00,1,0),(50,2,'476000000','','','','NOMINA',0.00,0.00,211.67,211.67,1,0),(50,3,'475100000','','','','NOMINA',0.00,0.00,538.29,538.29,1,0),(50,4,'465000046','','','','NOMINA',0.00,0.00,2107.18,2107.18,1,0),(52,1,'640000047','','','','NOMINA',1047.34,1047.34,0.00,0.00,1,0),(52,2,'476000000','','','','NOMINA',0.00,0.00,76.39,76.39,1,0),(52,3,'475100000','','','','NOMINA',0.00,0.00,20.95,20.95,1,0),(52,4,'465000047','','','','NOMINA',0.00,0.00,950.00,950.00,1,0),(53,1,'640000049','','','','NOMINA',1047.34,1047.34,0.00,0.00,1,0),(53,2,'476000000','','','','NOMINA',0.00,0.00,76.39,76.39,1,0),(53,3,'475100000','','','','NOMINA',0.00,0.00,20.95,20.95,1,0),(53,4,'465000049','','','','NOMINA',0.00,0.00,950.00,950.00,1,0),(55,1,'640000051','','','','NOMINA JULIO GONZALEZ',1699.66,1699.66,0.00,0.00,1,0),(55,2,'476000000','','','','NOMINA',0.00,0.00,124.54,124.54,1,0),(55,3,'475100000','','','','NOMINA',0.00,0.00,75.12,75.12,1,0),(55,4,'465000051','','','','NOMINA',0.00,0.00,1500.00,1500.00,1,0),(56,1,'640000052','','','','NOMINA',950.76,950.76,0.00,0.00,1,0),(56,2,'476000000','','','','NOMINA',0.00,0.00,69.88,69.88,1,0),(56,3,'475100000','','','','NOMINA',0.00,0.00,19.02,19.02,1,0),(56,4,'465000052','','','','NOMINA',0.00,0.00,861.86,861.86,1,0),(57,1,'640000053','','','N','NOMINA',663.33,663.33,0.00,0.00,1,0),(57,2,'476000000','','','N','NOMINA',0.00,0.00,48.39,48.39,1,0),(57,3,'475100000','','','N','NOMINA',0.00,0.00,13.27,13.27,1,0),(57,4,'465000053','','','N','NOMINA',0.00,0.00,601.67,601.67,1,0),(58,1,'640000058','','','','NOMINA',1270.74,1270.74,0.00,0.00,1,0),(58,2,'476000000','','','','NOMINA',0.00,0.00,90.05,90.05,1,0),(58,3,'475100000','','','','NOMINA',0.00,0.00,80.69,80.69,1,0),(58,4,'465000058','','','','NOMINA',0.00,0.00,1100.00,1100.00,1,0),(59,1,'640000059','','','','NOMINA',2941.55,2941.55,0.00,0.00,1,0),(59,2,'476000000','','','','NOMINA',0.00,0.00,217.92,217.92,1,0),(59,3,'475100000','','','','NOMINA',0.00,0.00,570.95,570.95,1,0),(59,4,'465000059','','','','NOMINA',0.00,0.00,2152.68,2152.68,1,0);
/*!40000 ALTER TABLE `cialasieplalin` 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 2025-10-30  8:40:25
