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

DROP TABLE IF EXISTS `maescuenrep`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `maescuenrep` (
  `cod_repres` char(6) NOT NULL DEFAULT '' COMMENT 'Agente',
  `nombre` text NOT NULL COMMENT 'Nombre',
  `conexion` text NOT NULL COMMENT 'Responsable',
  `direccion` text NOT NULL COMMENT 'Dirección',
  `cod_postal` char(10) NOT NULL DEFAULT '' COMMENT 'Código Postal',
  `poblacion` text NOT NULL COMMENT 'Población',
  `provincia` text NOT NULL COMMENT 'Provincia',
  `cod_nacion` char(4) NOT NULL DEFAULT 'ES' COMMENT 'País',
  `cif` char(30) NOT NULL DEFAULT '' COMMENT 'Cif.',
  `horario` text NOT NULL COMMENT 'Horario',
  `observaciones` text NOT NULL COMMENT 'Observaciones',
  `telefono` text NOT NULL COMMENT 'Teléfono',
  `fax` text NOT NULL COMMENT 'Fax',
  `movil` text NOT NULL COMMENT 'Móvil',
  `email` text NOT NULL COMMENT 'Email',
  `web` text NOT NULL COMMENT 'Página Web',
  `comision_1` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 1',
  `imp_euro_1` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 1',
  `comision_2` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 2',
  `imp_euro_2` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 2',
  `comision_3` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 3',
  `imp_euro_3` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 3',
  `comision_4` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 4',
  `imp_euro_4` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 4',
  `comision_5` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 5',
  `imp_euro_5` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 5',
  `comision_6` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 6',
  `imp_euro_6` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 6',
  `comision_7` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 7',
  `imp_euro_7` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 7',
  `comision_8` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 8',
  `imp_euro_8` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 8',
  `comision_9` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 9',
  `imp_euro_9` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 9',
  `cod_cuenta` char(12) NOT NULL DEFAULT '' COMMENT 'Código contable',
  `tipo_iva` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'Grupo iva cuentas',
  `cod_tipo_iva` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Tipo de IVA específico',
  `irpf` decimal(2,0) NOT NULL DEFAULT '0' COMMENT 'IRPF.',
  `tpc_ret` decimal(4,2) NOT NULL DEFAULT '0.00' COMMENT 'Retención',
  `tpc_rappel` decimal(4,2) NOT NULL DEFAULT '0.00' COMMENT 'Rappel',
  `cod_almacen` char(3) NOT NULL DEFAULT '' COMMENT 'Almacén',
  `distribuidor` char(1) NOT NULL DEFAULT 'N' COMMENT 'Distribuidor',
  `id_cialceco` int(11) NOT NULL DEFAULT '0' COMMENT 'Centro Coste',
  `cod_repres_parent` char(6) NOT NULL DEFAULT '' COMMENT 'Agente director',
  `sw_director` char(1) NOT NULL DEFAULT 'N' COMMENT 'Director',
  `comi_dir_1` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 1',
  `idi_euro_1` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 1',
  `comi_dir_2` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 2',
  `idi_euro_2` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 2',
  `comi_dir_3` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 3',
  `idi_euro_3` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 3',
  `comi_dir_4` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 4',
  `idi_euro_4` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 4',
  `comi_dir_5` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 5',
  `idi_euro_5` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 5',
  `comi_dir_6` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 6',
  `idi_euro_6` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 6',
  `comi_dir_7` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 7',
  `idi_euro_7` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 7',
  `comi_dir_8` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 8',
  `idi_euro_8` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 8',
  `comi_dir_9` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 9',
  `idi_euro_9` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 9',
  `comision_10` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 10',
  `imp_euro_10` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 10',
  `comision_11` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 11',
  `imp_euro_11` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 11',
  `comision_12` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 12',
  `imp_euro_12` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 12',
  `comision_13` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 13',
  `imp_euro_13` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 13',
  `comision_14` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 14',
  `imp_euro_14` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 14',
  `comision_15` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 15',
  `imp_euro_15` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 15',
  `comision_16` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 16',
  `imp_euro_16` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 16',
  `comision_17` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 17',
  `imp_euro_17` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 17',
  `comision_18` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 18',
  `imp_euro_18` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 18',
  `comision_19` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 19',
  `imp_euro_19` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 19',
  `comision_20` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 20',
  `imp_euro_20` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 20',
  `comi_dir_10` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 10',
  `idi_euro_10` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 10',
  `comi_dir_11` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 11',
  `idi_euro_11` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 11',
  `comi_dir_12` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 12',
  `idi_euro_12` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 12',
  `comi_dir_13` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 13',
  `idi_euro_13` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 13',
  `comi_dir_14` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 14',
  `idi_euro_14` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 14',
  `comi_dir_15` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 15',
  `idi_euro_15` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 15',
  `comi_dir_16` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 16',
  `idi_euro_16` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 16',
  `comi_dir_17` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 17',
  `idi_euro_17` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 17',
  `comi_dir_18` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 18',
  `idi_euro_18` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 18',
  `comi_dir_19` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 19',
  `idi_euro_19` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 19',
  `comi_dir_20` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '% com. 20',
  `idi_euro_20` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Comisión fija 20',
  `id_tenant` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Nº empresa',
  `fecha_alta` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Fecha de alta',
  `fecha_baja` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Fecha de baja',
  UNIQUE KEY `key0` (`id_tenant`,`cod_repres`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `maescuenrep` WRITE;
/*!40000 ALTER TABLE `maescuenrep` DISABLE KEYS */;
INSERT INTO `maescuenrep` (`cod_repres`, `nombre`, `conexion`, `direccion`, `cod_postal`, `poblacion`, `provincia`, `cod_nacion`, `cif`, `horario`, `observaciones`, `telefono`, `fax`, `movil`, `email`, `web`, `comision_1`, `imp_euro_1`, `comision_2`, `imp_euro_2`, `comision_3`, `imp_euro_3`, `comision_4`, `imp_euro_4`, `comision_5`, `imp_euro_5`, `comision_6`, `imp_euro_6`, `comision_7`, `imp_euro_7`, `comision_8`, `imp_euro_8`, `comision_9`, `imp_euro_9`, `cod_cuenta`, `tipo_iva`, `cod_tipo_iva`, `irpf`, `tpc_ret`, `tpc_rappel`, `cod_almacen`, `distribuidor`, `id_cialceco`, `cod_repres_parent`, `sw_director`, `comi_dir_1`, `idi_euro_1`, `comi_dir_2`, `idi_euro_2`, `comi_dir_3`, `idi_euro_3`, `comi_dir_4`, `idi_euro_4`, `comi_dir_5`, `idi_euro_5`, `comi_dir_6`, `idi_euro_6`, `comi_dir_7`, `idi_euro_7`, `comi_dir_8`, `idi_euro_8`, `comi_dir_9`, `idi_euro_9`, `comision_10`, `imp_euro_10`, `comision_11`, `imp_euro_11`, `comision_12`, `imp_euro_12`, `comision_13`, `imp_euro_13`, `comision_14`, `imp_euro_14`, `comision_15`, `imp_euro_15`, `comision_16`, `imp_euro_16`, `comision_17`, `imp_euro_17`, `comision_18`, `imp_euro_18`, `comision_19`, `imp_euro_19`, `comision_20`, `imp_euro_20`, `comi_dir_10`, `idi_euro_10`, `comi_dir_11`, `idi_euro_11`, `comi_dir_12`, `idi_euro_12`, `comi_dir_13`, `idi_euro_13`, `comi_dir_14`, `idi_euro_14`, `comi_dir_15`, `idi_euro_15`, `comi_dir_16`, `idi_euro_16`, `comi_dir_17`, `idi_euro_17`, `comi_dir_18`, `idi_euro_18`, `comi_dir_19`, `idi_euro_19`, `comi_dir_20`, `idi_euro_20`, `id_tenant`, `fecha_alta`, `fecha_baja`) VALUES ('000000','No precisa asignación comercial','','','','','','ES','','','','','','','','',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'',1,0,0,0.00,0.00,'','N',0,'','N',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1,'2019-10-15','0000-00-00'),('000001','Jordi ','','','','','','ES','','','','','','','','',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'410000000',1,0,0,0.00,0.00,'','N',0,'','S',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1,'0000-00-00','0000-00-00'),('000002','Javier Deza','','C/MASIA CAN COLL','08620','','','ES','','','','934737758','','','elisolplay@gmail.com','',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'410000000',1,0,0,0.00,0.00,'','N',0,'','N',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1,'0000-00-00','2023-12-31'),('000003','José Luís ','','','','','','ES','','','','','','','','',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'410000000',1,0,0,0.00,0.00,'','N',0,'','N',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1,'0000-00-00','0000-00-00'),('000004','Antoni Marcè','','','','','','ES','','','','','','','','',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'410000000',1,0,0,0.00,0.00,'','N',0,'','N',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1,'0000-00-00','2024-10-05'),('000005','Luis Lourenço','Luis Antonio D Santos Lourenço','Rua das Romazeiras, 88 2º Esq','','2750-479 CASCAIS','','ES','PT199121737','','','+351 962 713 384','','','luis.lourenco@oniduo.pt','',7.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'400000000',3,0,0,0.00,0.00,'','N',0,'','N',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1,'0000-00-00','2024-10-05'),('000006','Isma','','','','','','ES','','','','','','','','',5.00,0.00,7.00,0.00,10.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'410000000',1,0,0,0.00,0.00,'','N',0,'','N',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1,'0000-00-00','0000-00-00'),('000007','Avilés','','','','','','ES','','','','','','609732807','antoni@solplay.es','',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'',1,0,0,0.00,0.00,'','N',0,'','N',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1,'0000-00-00','0000-00-00'),('000008','Xavier García','','','','','','ES','','','','','','','','',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'',1,0,0,0.00,0.00,'','N',0,'','N',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1,'0000-00-00','0000-00-00'),('000009','Agus','','','','','','ES','','','','','','','','',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'',1,0,0,0.00,0.00,'','N',0,'','N',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1,'0000-00-00','0000-00-00'),('000010','Yolanda González ','','','','','','ES','','','','','','','','',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'',1,0,0,0.00,0.00,'','N',0,'','N',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1,'2020-01-23','0000-00-00'),('000011','Rubén Rincón','','','','','','ES','','','','','','','','',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'',1,0,0,0.00,0.00,'','N',0,'','N',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1,'2024-10-21','0000-00-00'),('000013','Univers Home Solutions, S.L.','Joan Francesc Pyod i Selles','Marquès Caldes Montbuí,23 3º2ª','','17003 GIRONA','','ES','','','08/02/2017\r\nDTOS. PARA PODER OFRECER EN LA PÉRGOLA DAKHLA DE NEVALUZ: 30%','','','','','',13.00,0.00,9.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'410000000',1,0,0,0.00,0.00,'','N',0,'','N',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1,'0000-00-00','2024-10-05'),('000014','Maison du Menuisier','Pyod','Avenue des combattants d\'AFN','','13700 MARIGNANE','','ES','FR33483302022','','','','','','','',8.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'410000000',1,0,0,0.00,0.00,'','N',0,'','N',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1,'0000-00-00','2024-10-05'),('000015','Sur Mesure','Pyod','','','','','ES','','','','','','','','',8.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'410000000',1,0,0,0.00,0.00,'','N',0,'','N',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1,'0000-00-00','2024-10-05'),('000099','Obras puntuales','','','','','','ES','','','','','','','','',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'',1,0,0,0.00,0.00,'','N',0,'','N',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1,'0000-00-00','0000-00-00');
/*!40000 ALTER TABLE `maescuenrep` 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:41:20
