-- 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 `cialaeat347`
--

DROP TABLE IF EXISTS `cialaeat347`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cialaeat347` (
  `num_declara` int(11) NOT NULL DEFAULT '0' COMMENT 'Nº Declaración',
  `nombre` text NOT NULL COMMENT 'Descripción',
  `ejercicio` smallint(6) NOT NULL DEFAULT '2024' COMMENT 'Ejercicio',
  `importe_d` decimal(15,2) NOT NULL DEFAULT '3005.06' COMMENT 'Desde importe',
  `importe_h` decimal(15,2) NOT NULL DEFAULT '0.00' COMMENT 'Hasta importe',
  `sw_preparar` char(1) NOT NULL DEFAULT 'S' COMMENT 'Preparar',
  `sw_download` char(1) NOT NULL DEFAULT 'N' COMMENT 'Descargar',
  `cif` char(9) NOT NULL DEFAULT 'B19903236' COMMENT 'CIF declarante',
  `nombre_declara` char(40) NOT NULL DEFAULT 'SERVICIOS DE CONFECCION INDUSTRIAL SOLPL' COMMENT 'Nombre declarante',
  `telefono_contacto` char(9) NOT NULL DEFAULT '934737758' COMMENT 'Teléfono contacto',
  `nombre_contacto` char(40) NOT NULL DEFAULT 'B61667598' COMMENT 'Persona de contacto',
  `tipo_soporte` char(1) NOT NULL DEFAULT 'C' COMMENT 'Transmisión',
  `sw_complementaria` char(1) NOT NULL DEFAULT 'N' COMMENT 'Complementaria',
  `sw_sustitutiva` char(1) NOT NULL DEFAULT 'N' COMMENT 'Sustitutiva',
  `aeat_num_declara` int(11) NOT NULL DEFAULT '1' COMMENT 'Nº declar. AEAT',
  `aeat_num_declara_ant` int(11) NOT NULL DEFAULT '0' COMMENT 'Nº declar. anterior AEAT',
  `cif_representante` char(9) NOT NULL DEFAULT '' COMMENT 'CIF representante legal',
  `fecha_t1_d` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Desde Fecha T1',
  `fecha_t1_h` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Hasta Fecha T1',
  `fecha_t2_d` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Desde Fecha T2',
  `fecha_t2_h` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Hasta Fecha T2',
  `fecha_t3_d` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Desde Fecha T3',
  `fecha_t3_h` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Hasta Fecha T3',
  `fecha_t4_d` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Desde Fecha T4',
  `fecha_t4_h` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Hasta Fecha T4',
  `sw_preparar_done` char(1) NOT NULL DEFAULT 'N' COMMENT 'Preparado',
  `fecha_cre` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Fecha creación',
  `hora_cre` time NOT NULL DEFAULT '00:00:00' COMMENT 'Hora creación',
  `sw_download_done` char(1) NOT NULL DEFAULT 'N' COMMENT 'Descarga hecha',
  `fecha_download` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Fecha descarga',
  `hora_download` time NOT NULL DEFAULT '00:00:00' COMMENT 'Hora descarga',
  `sw_nom_dir_fra` char(1) NOT NULL DEFAULT 'N' COMMENT 'Usar nombre dir.fra.',
  `sw_nif_dir_fra` char(1) NOT NULL DEFAULT 'N' COMMENT 'Usar CIF dir.fra.',
  `sw_fecha` char(1) NOT NULL DEFAULT 'F' COMMENT 'Tipo fecha a usar',
  `sw_groupby_cuenta` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'Agrupación',
  `id_tenant` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Nº empresa',
  UNIQUE KEY `key0` (`id_tenant`,`num_declara`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `cialaeat347` WRITE;
/*!40000 ALTER TABLE `cialaeat347` DISABLE KEYS */;
INSERT INTO `cialaeat347` (`num_declara`, `nombre`, `ejercicio`, `importe_d`, `importe_h`, `sw_preparar`, `sw_download`, `cif`, `nombre_declara`, `telefono_contacto`, `nombre_contacto`, `tipo_soporte`, `sw_complementaria`, `sw_sustitutiva`, `aeat_num_declara`, `aeat_num_declara_ant`, `cif_representante`, `fecha_t1_d`, `fecha_t1_h`, `fecha_t2_d`, `fecha_t2_h`, `fecha_t3_d`, `fecha_t3_h`, `fecha_t4_d`, `fecha_t4_h`, `sw_preparar_done`, `fecha_cre`, `hora_cre`, `sw_download_done`, `fecha_download`, `hora_download`, `sw_nom_dir_fra`, `sw_nif_dir_fra`, `sw_fecha`, `sw_groupby_cuenta`, `id_tenant`) VALUES (1,'Declaración 2016',2016,3005.06,0.00,'N','N','B61667598','S.C.I.SOLPLAY SL','610274123','EROLES CANELA JOSE','T','N','N',1,0,'','2016-01-01','2016-03-31','2016-04-01','2016-06-30','2016-07-01','2016-09-30','2016-10-01','2016-12-31','S','2017-02-23','17:19:42','S','2017-02-23','17:48:30','N','N','F',1,1),(2,'Declaración 2017',2017,3005.06,0.00,'N','N','B61667598','SOLPLAY SL','610274123','EROLES CANELA JOSE','T','N','N',1,0,'','2017-01-01','2017-03-31','2017-04-01','2017-06-30','2017-07-01','2017-09-30','2017-10-01','2017-12-31','S','2018-02-05','13:04:39','S','2018-02-23','10:55:22','N','N','F',1,1),(3,'Declaración 2018',2018,3005.06,0.00,'N','N','B61667598','SERVICIOS DE CONFECCION INDUSTRIAL SOLPL','610274123','EROLES CANELA JOSE','C','N','N',1,0,'','2018-01-01','2018-03-31','2018-04-01','2018-06-30','2018-07-01','2018-09-30','2018-10-01','2018-12-31','S','2019-01-18','21:02:17','S','2019-02-27','19:59:18','N','N','F',1,1),(4,'Declaración 2019',2019,3005.06,0.00,'N','N','B61667598','SERVICIOS DE CONFECCION INDUSTRIAL SOLPL','610274123','EROLES CANELA JOSE','T','N','N',1,0,'','2019-01-01','2019-03-31','2019-04-01','2019-06-30','2019-07-01','2019-09-30','2019-10-01','2019-12-31','S','2020-01-27','10:21:18','S','2020-02-12','18:09:30','N','N','F',1,1),(5,'Declaración 2020',2020,3005.06,0.00,'N','N','B61667598','SERVICIOS DE CONFECCION INDUSTRIAL SOLPL','610274123','EROLES CANELA JOSE','T','N','N',1,0,'','2020-01-01','2020-03-31','2020-04-01','2020-06-30','2020-07-01','2020-09-30','2020-10-01','2020-12-31','S','2021-01-12','19:52:32','S','2021-02-22','12:47:02','N','N','F',1,1),(6,'Declaración 2021',2021,3005.06,0.00,'N','N','B61667598','SERVICIOS DE CONFECCION INDUSTRIAL SOLPL','610274123','EROLES CANELA JOSE','T','N','N',1,0,'','2021-01-01','2021-03-31','2021-04-01','2021-06-30','2021-07-01','2021-09-30','2021-10-01','2021-12-31','S','2022-01-15','12:43:36','S','2022-02-27','14:12:45','N','N','F',1,1),(9,'Declaración 2022',2022,3005.06,0.00,'N','N','B61667598','SERVICIOS DE CONFECCION INDUSTRIAL SOLPL','610274123','EROLES CANELA JOSE','C','N','N',1,0,'','2022-01-01','2022-03-31','2022-04-01','2022-06-30','2022-07-01','2022-09-30','2022-10-01','2022-12-31','S','2023-01-30','12:29:34','S','2023-02-24','20:01:29','N','N','F',1,1),(10,'Declaración 2023',2023,3005.06,0.00,'N','N','B61667598','SERVICIOS DE CONFECCION INDUSTRIAL SOLPL','610274123','EROLES CANELA JOSE','T','N','N',1,0,'','2023-01-01','2023-03-31','2023-04-01','2023-06-30','2023-07-01','2023-09-30','2023-10-01','2023-12-31','S','2024-01-18','13:27:35','S','2024-02-27','18:03:18','N','N','F',1,1),(11,'Declaración 2024',2024,3005.06,0.00,'N','N','B19903236','SERVICIOS DE CONFECCION INDUSTRIAL SOLPL','934737758','B61667598','C','N','N',1,0,'','2024-01-01','2024-03-31','2024-04-01','2024-06-30','2024-07-01','2024-09-30','2024-10-01','2024-12-31','S','2025-01-17','16:20:09','N','0000-00-00','00:00:00','N','N','F',1,1);
/*!40000 ALTER TABLE `cialaeat347` 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
