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

DROP TABLE IF EXISTS `maescuendir`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `maescuendir` (
  `cod_cuenta` char(12) NOT NULL DEFAULT '' COMMENT 'Cuenta',
  `num_dien` int(11) NOT NULL DEFAULT '0' COMMENT 'Nº Dirección',
  `nombre` char(250) NOT NULL DEFAULT '' COMMENT 'Nombre',
  `cif` char(30) NOT NULL DEFAULT '' COMMENT 'C.I.F.',
  `cod_cae` char(15) NOT NULL DEFAULT '' COMMENT 'Código CAE',
  `cae_fecha_caduca` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Fecha caduca CAE',
  `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',
  `horario` text NOT NULL COMMENT 'Horario',
  `telefono` text NOT NULL COMMENT 'Teléfono',
  `fax` text NOT NULL COMMENT 'Fax',
  `movil` text NOT NULL COMMENT 'Móvil',
  `conexion` text NOT NULL COMMENT 'Persona contacto',
  `email` text NOT NULL COMMENT 'Email',
  `web` text NOT NULL COMMENT 'Página Web',
  `num_domi` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Nº Domiciliación',
  `ean` char(13) NOT NULL DEFAULT '' COMMENT 'Código Ean',
  `cod_agencia` char(6) NOT NULL DEFAULT '' COMMENT 'Medio de envío (agencia)',
  `cod_ruta` char(3) NOT NULL DEFAULT '' COMMENT 'Ruta de Transporte',
  `cod_destino` char(5) NOT NULL DEFAULT '' COMMENT 'Código Destino',
  `sw_reexpedicion` char(1) NOT NULL DEFAULT 'N' COMMENT 'Reexpedición ',
  `cod_almacen_mov` char(3) NOT NULL DEFAULT '' COMMENT 'Almacén Ent/Sal',
  `cod_repres` char(6) NOT NULL DEFAULT '' COMMENT 'Agente',
  `base_comi` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Base comisión',
  `tpc_comi_dir` decimal(4,2) NOT NULL DEFAULT '0.00' COMMENT '% Comisión directa',
  `cod_ruta_com` char(4) NOT NULL DEFAULT '' COMMENT 'Ruta comercial',
  `sw_delegacion` char(1) NOT NULL DEFAULT 'N' COMMENT 'Indic. Delegación',
  `sw_visita` char(1) NOT NULL DEFAULT 'N' COMMENT 'Visita Comercial',
  `observaciones` text NOT NULL COMMENT 'Observaciones',
  `nombre_cial` text NOT NULL COMMENT 'Nombre comercial',
  `clave_operacion_349` char(1) NOT NULL DEFAULT '-' COMMENT 'Clave operación 349',
  `clave_303_v` char(1) NOT NULL DEFAULT '-' COMMENT 'Tipo venta 303',
  `clave_303_c` char(2) NOT NULL DEFAULT '-' COMMENT 'Tipo compra 303',
  `cuen_tax_rule` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Tipo de IVA general',
  `id_tenant` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Nº empresa',
  `sw_envio` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'Dirección entregas',
  `sw_factura` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'Dirección facturas',
  `sw_cobro` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'Dirección cobros',
  `cod_fpago` char(2) NOT NULL DEFAULT '' COMMENT 'Forma de pago',
  `cod_pago` char(4) NOT NULL DEFAULT '' COMMENT 'Condiciones de pago',
  `cod_moneda` char(3) NOT NULL DEFAULT '' COMMENT 'Moneda habitual',
  `cod_idioma` char(4) NOT NULL DEFAULT '' COMMENT 'Idioma',
  `cod_cuenta_paco` char(12) NOT NULL DEFAULT '' COMMENT 'Banco Prev./Transf.',
  `sw_default` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Dirección por defecto',
  `acceso` char(50) NOT NULL DEFAULT '' COMMENT 'Acceso',
  `sw_recinto` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'Dirección recinto',
  `email_fac` text NOT NULL COMMENT 'Email facturación',
  `eori` varchar(30) NOT NULL DEFAULT '' COMMENT 'EORI',
  UNIQUE KEY `key0` (`id_tenant`,`cod_cuenta`,`num_dien`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `maescuendir` WRITE;
/*!40000 ALTER TABLE `maescuendir` DISABLE KEYS */;
INSERT INTO `maescuendir` (`cod_cuenta`, `num_dien`, `nombre`, `cif`, `cod_cae`, `cae_fecha_caduca`, `direccion`, `cod_postal`, `poblacion`, `provincia`, `cod_nacion`, `horario`, `telefono`, `fax`, `movil`, `conexion`, `email`, `web`, `num_domi`, `ean`, `cod_agencia`, `cod_ruta`, `cod_destino`, `sw_reexpedicion`, `cod_almacen_mov`, `cod_repres`, `base_comi`, `tpc_comi_dir`, `cod_ruta_com`, `sw_delegacion`, `sw_visita`, `observaciones`, `nombre_cial`, `clave_operacion_349`, `clave_303_v`, `clave_303_c`, `cuen_tax_rule`, `id_tenant`, `sw_envio`, `sw_factura`, `sw_cobro`, `cod_fpago`, `cod_pago`, `cod_moneda`, `cod_idioma`, `cod_cuenta_paco`, `sw_default`, `acceso`, `sw_recinto`, `email_fac`, `eori`) VALUES ('400000004',1,'','','','0000-00-00','C/ SANT JOAN 5, C','08620','SANT VICENÇ DELS HORTS','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('400000004',2,'','','','0000-00-00','Masía Can Coll, 21','08620','Sant Vicenç dels Horts','Barcelona','ES','','','','','','jordilopez@solplay.es','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'jordilopez@solplay.es',''),('400000014',1,'AP. CORREOS, 110','','','0000-00-00','','08870','SITGES','BARCELONA','ES','','','','','','','',0,'','','','','N','','0',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('400000025',1,'','','','0000-00-00','Masía Can Coll, 21','08620','Sant Vicenç dels Horts','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',0,'',''),('400000025',2,'','','','0000-00-00','Masía Can Coll, 11','08620','Sant Vicenç dels Horts','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('400000025',3,'','','','0000-00-00','C/ Baixada del Camp de Fútbol, 7','08620','Sant Vicenç dels Horts','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('410000602',1,'','','','0000-00-00','C/ Marcelí, Gener, 36','08800','Vilanova i la Geltru','Barcelona','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','TOT KILAIN (recogida y entrega de material)','-','-','-',0,1,1,1,1,'','','','','',1,'',1,'',''),('430000003',99,'','','','0000-00-00','','','','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000014',1,'TOLDOS MARTIN','','','0000-00-00','C/ VIRGEN DEL ROCIO 38 NAVE','23620','MENGIBAR','JAEN','ES','','','','','SANTIAGO MARTIN RUIZ','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000014',2,'SANTIAGO MARTIN RUIZ','','','0000-00-00','PASEO ESPAÑA, 1  CASA Nº 7','23620','MENGIBAR','JAEN','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000036',99,'','','','0000-00-00','','','','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000044',1,'MANUE CAMACHO CASTILLO','','','0000-00-00','RAFAEL CAMPANALS, 136','08903','HOSPITALET','BARCELONA','ES','','93.331.93.91','93.332.11.77','CIF 38514740K','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000055',99,'','','','0000-00-00','','','','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000067',99,'','','','0000-00-00','','','','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000085',1,'UNITOLDO S.L.*****************','','','0000-00-00','C/ Molí d\'en Ginestar, 27','08291','RIPOLLET','BARCELONA','ES','','','','','SR. RAMIRO','','',0,'0000000000000','','','','N','','',0,0.00,'0000','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000116',1,'','','','0000-00-00','Avda América, 128','','Hospitalet de LLobregat','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000122',1,'','','','0000-00-00','C/.SANT FERRAN S,/N NAVE 10\r\n(POLIGONO ALMEDA)','08940','CORNELLA','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','TOLDOS MONCANO','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000129',1,'JOSEFA CALDERON ALVAREZ','','','0000-00-00','CL. JOAQUIN TORRES GARCIA,75','','MATARO','BARCELONA','ES','','','','','TOLDOS HIDALGO (MATARO)','','',0,'','','','','N','','',0,0.00,'0000','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000140',1,'FRANCISCO ALSO VIZCARRO','','','0000-00-00','AVDA CANIGÓ, 11','43500','TORTOSA','TARRAGONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000156',1,'','','','0000-00-00','CARRETERA D\'ALFORJA, 6','43350','LES BORGES DEL CAMP','TARRAGONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','TIGSOL','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430000162',1,'SALVADOR COLL I MASSANEDA','','','0000-00-00','CL. CAMPRODON, 16','17430','STA. COLOMA DE FARNERS','GIRONA','ES','','972.877072','EL MISMO','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000174',1,'TOLDO COLOR, S.L.','','','0000-00-00','C / PINTOR FUSTER, 16','43205','-REUS','TARRAGONA','ES','9.00 A 13.30  llamar 1 hora antes','977754075   691802772 (Josep Maria)','','','JOSE Mª TEL.655810637','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000182',1,'RETOLS JMG S.L','','','0000-00-00','C/ Penedés, S/N\nPol. Ind. Can Prunera','08759','Vallirana','BARCELONA','ES','','93.6830684','93.6830684','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000184',1,'CIRIA DECORACION,S.A','','','0000-00-00','POLIGONO PAULES  PARCELA 64','22400','MONZON','HUESCA','ES','','','','','','','',0,'','000010','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000188',1,'SERGIO VICENTE PUENTE','','','0000-00-00','Alfonso II de Aragón, 22 1ºD','22005','Huesca','Huesca','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,0,1,1,'','','','','',0,'',0,'',''),('430000188',2,'SERGIO VICENTE PUENTE','','','0000-00-00','Av. Monegros, 23 Bajos','22005','Huesca','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430000243',1,'INASOL','','','0000-00-00','CALLE ALACANT,20','08830','SANT BOI','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000266',1,'FAURECIA INTERIOR SYSTEMS ESPA','','','0000-00-00','Autovía A-3, Madrid-Valencia,\nKm. 344,5','46930','Quart de Poblet','Valencia','ES','','','','','Dpto. de Contabilidad','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000266',2,'SAI AUTOMOTIVE LIGNOTOCK','','','0000-00-00','PROGRESO, 18-20\nP.I. SANT ERMENGOL','08630','ABRERA','BARCELONA','ES','09:00 - 17:00','','','','MARCOS LORENTE','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000275',1,'','','','0000-00-00','CAN MOLLET, 15-17','08100','MOLLET DEL VALLES','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','AVISAR EL DIA ANTES DE SERVIR','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000294',1,'SOL SANT BOI, S.L.','','','0000-00-00','CL. LA PLANA, 44-46 2º 1ª','08830','SANT BOI DE LL.','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000294',2,'SOL SANT BOI, S.L.','','','0000-00-00','C/ VICTORIA 113, LOCAL 1','08830','SANT BOI','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000314',1,'','','','0000-00-00','C/ Tarragona, nave 14\r\nPol.Ind.Els Arcs','43713','St Jaume dels Domenys','Tarragona','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000461',1,'RAIGO CONSTRUCCIONES 2015,S.L.','','','0000-00-00','SANT JUST DESVERNS, 7, 2º 2','08970','SANT JOAN DESPI','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000472',1,'','','','0000-00-00','CTRA. N-152, KM.108\r\nPOL. ROCAFIGUERA','17500','RIPOLL','GIRONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',1,'',''),('430000488',1,'LUMAR 2000, S.L.**************','','','0000-00-00','SAN MIQUEL, 9','08620','-SANT VICENÇS DELS HORTS','BARCELONA','ES','','','','','SR. JOSE LUIS','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000494',1,'RAFAEL NAVAJAS, S.L.','','','0000-00-00','C/TARRAGONA, Nº2','-IGUALADA','-IGUALADA','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000496',1,'MUNDI TOLDO SCP***************','','','0000-00-00','ENRIC SAGNIER, 7, 1º 1ª\n08172','08172','SANT CUGAT DEL VALLES','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000515',1,'','','','0000-00-00','Mare Deu Port,269 Interior;\r\nBajar rampa en número 251 (llamar 15 min.antes)','','','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000571',1,'HERMINIO DIAZ GRANDE','','','0000-00-00','APDO. 047','07817','Sant Jordi','IBIZA','ES','','','','','TOLDOS / ROTULOS DIAZ','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000573',1,'VENTUX EXCLUSIVE S.L.U.','','','0000-00-00','C/ Rumanía, 5 Nave B8-B9\nPolígon Industrial Inbisa','28802','ALCALA DE HENARES','Madrid','ES','Lu-Vi 09:00 a 14:00','','','','Sr. Jaime Calderón','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000574',1,'ALUMISAN ASISTENCIA, S.L.','','','0000-00-00','RUA DAS CESTEIRAS 7\r\nPOLIGONO INDUSTRIAL DEL CEAO','27003','LUGO','','ES','','','','','SINGULAR LUGO','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000574',2,'ALUMISAN ASISTENCIA, S.L.','','','0000-00-00','San Lázaro, 88','15703','SANTIAGO DE COMPOSTELA','A CORUÑA','ES','','','','','SINGULAR SANTIAGO','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000574',3,'ALUMISAN ASISTENCIA S.L.','','','0000-00-00','C/ HOJALDRE PARCELA 47\r\nPOL. IND. ASTORGA','24700','LEON','LEON','ES','','987 600 007','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','ALUMISAN ASISTENCIA S.L.','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430000575',1,'TOLDOS ESMASOL','','','0000-00-00','Antigua Ctra. Reus a Alcover','43460','ALCOVER','Tarragona','ES','','','','','Sr. Ramón Masdeu García','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000582',1,'Grup Finestres S.C.P.','','','0000-00-00','C/ Sant Joan, 36 A y B','08635','','','ES','','','','','Sr. Tamar','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000588',1,'CORTINA DE LUZ','','','0000-00-00','QUINTA DE SÇO JORGE ASSENTOS','7300-','7300-000 PORTALEGRE','','ES','','','','','Sr. Nuno Cordeiro','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000593',1,'INTERLAMA, S.L.','','','0000-00-00','C/ Gutemberg, 11\nP.I. Mas Roger','08397','PINEDA DE MAR','Barcelona','ES','08:00 - 15:00 h','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000618',1,'Instasol Cortines i Tendals S.L.','','','0000-00-00','C/ Huelva, 38','','Barcelona','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000654',1,'T.S. Tecnosol 2006 Reus S.L.','','','0000-00-00','C/ Luxemburgo, 14','43120','P.I. de Constanti','Tarragona','ES','','','','','Sra. Elisabeth','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000655',1,'','','','0000-00-00','','','','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000691',2,'','','','0000-00-00','C/. FREIXES, Nº 4 LOCAL','08960','SANT JUST DESVERN','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','ALUMAG','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000700',1,'NOVA NAU, S.L.','','','0000-00-00','Avda. Santa María, 46 4º3ª','08340','Vilassar de Mar','Barcelona','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000700',2,'NOVA NAU, S.L.','','','0000-00-00','C/ Isaac Albéniz, 16 Nave 4\nPoligono Industrial Sud','08440','Cardedeu','Barcelona','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000704',2,'PROTECSOL','','','0000-00-00','Avda.Catalunya,23(tienda)St Antoni calonge','','','Girona','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','TOLDOS PROTECSOL','-','-','-',0,1,1,1,1,'','','','','',0,'PROTECSOL',1,'',''),('430000708',1,'TENDALS NATURA','','','0000-00-00','C/ Concepción Arenal, 135-139\nLocal 2','08027','Barcelona','','ES','','','','','Joan Tudó Puertas','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000718',1,'ALU-STYL,SCP','','','0000-00-00','C/ Ull de Llebre, 13 Bajos\nP.I. Clot de Moja','08734','- Olèrdola','Barcelona','ES','','','','','Tel. 938 175 176','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000723',1,'','','','0000-00-00','C/ Nou, 27','08729','LES MASUQUES','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','PROTENDALLS','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430000736',1,'JORDI OLIVELLA ILARI**********','','','0000-00-00','AVDA. TARRAGONA, 76','43720','L\'ARBOÇ','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000759',1,'QUALITAT I SERVEIS 1965,SCP','','','0000-00-00','C/CAN OLIVA 107-109','BARCE','BARCELONA','BARCELONA','ES','9 A 13:30 15:30 A 18','','','','ALBERT','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000765',1,'TENDALS GUITART S.L.','','','0000-00-00','MAJOR, 216 BAIXOS','08759','VALLIRANA','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000765',2,'TOLDOS LLOBREGAT','','','0000-00-00','MOSSEN CINTO VERDAGUER, 197','08830','SANT BOI DE LLOBREGAT','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000766',1,'','','','0000-00-00','C/ Ajuntament, 7','08810','SANT PERE DE RIBES','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,0,1,1,'','','','','',0,'',1,'',''),('430000787',1,'SANCHEZ SERVICIOS DE TAPICERIA','','','0000-00-00','C/ Gomis, 33 A Local 20','08760','MARTORELL','Barcelona','ES','','','','','Sr. Manuel','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000795',1,'TOLDOS HIDALGO','','','0000-00-00','C/ MARCONI','08397','PINEDA DE MAR','BARCELONA','ES','','','','697 506 477','J. Miguel','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',1,'',''),('430000797',1,'CESPED SOLUCION','','','0000-00-00','C/.TEMPLER GUIDO,53','08187','-PALAU SOLITA I PLEGAMANS','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000820',1,'GRUPO TOLDOS PÉREZ, S.L.','','','0000-00-00','C/ MOLLET, 24\r\nLLAMAR ANTES DE SERVIR','08401','GRANOLLERS','BARCELONA','ES','','678685313','','678685313','Daniel Solavera','','',0,'','','','','N','','',0,0.00,'','N','N','','GRUPO TOLDOS PÉREZ, S.L.','-','-','-',0,1,1,0,0,'','','','','',0,'TOLDOS PÉREZ',0,'',''),('430000822',1,'','','','0000-00-00','C/ PONT, 65 ','08250','SANT JOAN DE VILATORRADA','BARCELONA','ES','','938 751 312 (LLAMAR ANTES)','','626 987 481','','','',0,'','','','','N','','',0,0.00,'','N','N','','ESTUDIO CHIC','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430000827',1,'','','','0000-00-00','C/ Industria, s/n ','','Riera de Gaià','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430000831',1,'','','','0000-00-00','C/ Joaquim Folguera, 64','','GAVA','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','SERVIR EN VILACAPAFONS','-','-','-',0,1,1,0,0,'','','','','',0,'',1,'',''),('430000833',2,'THINKING BIG BUSINESS S.L.','','','0000-00-00','C/ D\'en Draper, 32 nave,4','08350','ARENYS DE MAR','Barcelona','ES','09:30 a 15:00 h','','','','Sr. Kilian','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000833',3,'TBB SL','','','0000-00-00','Recoge en Solplay','','','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000834',1,'','','','0000-00-00','C/ Joaquim Folguera, 64','08850','GAVA','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','SERVIR EN VILACAPAFONS','-','-','-',0,1,1,0,0,'','','','','',0,'',1,'',''),('430000838',1,'INFO. Y TELECOM. RATRI 2002, S.L.','B43669423','','0000-00-00','C/ DINAMARCA, MANZANA 7 PARC. 3 Y 4 NAVE 8\r\nP.I. DE CONSTANTÍ','43120','CONSTANTÍ','TARRAGONA','ES','','977 296 518','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','SERVEIS INTEGRALS RATRI','-','-','-',0,1,0,1,0,'','','','','',0,'',1,'',''),('430000838',2,'INFO. Y TELECOM. RATRI 2002, S.L.','B43669423','','0000-00-00','C/RIERA DEL GAYA S/N. PAR.J-11 -POLIG IND ROQUES PLANES','43830','TORREDEMBARRA','TARRAGONA','ES','','626 030 737(MIGUEL)','977 130 265','','','info@aluministatri.com','',0,'','','','','N','','',0,0.00,'','N','N','','SERVEIS INTEGRALS RATRI','-','-','-',0,1,1,0,0,'','','','','',1,'',1,'',''),('430000838',3,'INFO. Y TELECOM. RATRI 2002, S.L.','B43669423','','0000-00-00','C/ ROVIRA I VIRGILI. 41','43002','TARRAGONA','TARRAGONA','ES','','977 224 326','','','','tarragona@aluminisratri.com','',0,'','','','','N','','',0,0.00,'','N','N','','SERVEIS INTEGRALS RATRI','-','-','-',0,1,0,0,0,'','','','','',0,'',1,'',''),('430000838',4,'INFO. Y TELECOM. RATRI 2002, S.L.','','','0000-00-00','C/ MAJOR, 36','43840','SALOU','TARRAGONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','SERVEIS INTEGRALS RATRI','-','-','-',0,1,0,0,0,'','','','','',0,'',1,'',''),('430000841',1,'Dirección de entrega:','','','0000-00-00','C/ Joaquim Folguera, 64','08850','Gavá','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000849',1,'','','','0000-00-00','C/Albacete, 8 (llmar siempre antes)','','','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000851',1,'','','','0000-00-00','PLAZA EUROPA 42','08902','L\'HOSPITALET DE LLOBREGAT','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000851',2,'FABRICA***********************','','','0000-00-00','C/SANT MARTI DE L\'ERM, 5-7','08970','SANT JOAN DESPI','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000852',1,'FIBRAS PRINCIPADO','','','0000-00-00','Calle la Peña, 27 Bajos','33212','Gijón','Asturias','ES','','','','','Sr. Roberto - Sra. Lali','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000854',1,'','','','0000-00-00','C/ Sant Pau, 31','08720','VILAFRANCA DEL PENEDÈS','Barcelona','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430000856',1,'CAROLA GROMMES PALOMEQUE','','','0000-00-00','C/BADAJOZ 88 BAJOS\nCOWORKING021','08005','BARCELONA','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000876',1,'','','','0000-00-00','','','','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000876',2,'JOAO MENDOÇA DE CARVALHO,LDA','','','0000-00-00','EST.PAÇO DE ARCOS 163 ARMZ2-B','2735-','2735-000CACEM','PORTUGAL','ES','','','','','ANTONIO MENDES 00351917274953','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000883',1,'INNOVO************************','','','0000-00-00','C/RAMON Y CAJAL 3 BAJOS','08620','SANT VICENÇS DELS HORTS','BARCELONA','ES','','','','','DAVID','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000885',1,'CORTICOLOMA','','','0000-00-00','Av. Can Lluch, 21 Local 2','08690','Sta Coloma de Cervelló','Barcelona','ES','','','','','SR. Tomás','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000885',2,'CORTICOLOMA','','','0000-00-00','Av. Oriol Martorell, 14 4º1ª','08690','Sta. Coloma de Cervelló','Barcelona','ES','','','','','Sr. Tomás','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000886',1,'','','','0000-00-00','TALLER: C/ Pere Mateu, 6','08506','CALLDETENES','','ES','','93-886 15 68   600662253','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','DIRECCION DE ENVIO','-','-','-',0,1,1,1,1,'','','','','',1,'',1,'',''),('430000910',1,'ROBERTO DEL BLANCO(FIBRAS PRIN','','','0000-00-00','CALLE DE LA PEÑA,27 BAJOS','33212','-GIJON','ASTURIAS','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000917',1,'GMD LK','','','0000-00-00','6 Rue du Pont Rouge\nZA LA PLAINE','11100','MONTREDON DES CORBIÈRES','FRANCIA','ES','','','','','Mathieu Gessier','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000922',1,'','','','0000-00-00','C/.JOC DE LA PILOTA,14','17780','GARRIGUELLA','GIRONA','ES','','972672603','','658965681','','','',0,'','','','','N','','',0,0.00,'','N','N','','FUSTA VERDA','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000926',1,'ALU-REI, S.L.','','','0000-00-00','C/DE LES AIGUADARES,8','08750','MOLINS DE REI','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000928',1,'CORTITOLDO S.L.','','','0000-00-00','MARE DE DEU DEL CARMEN,7CASA B','08620','SANT VICENÇ DEL HORTS','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000931',1,'OMBRA S.C.','','','0000-00-00','C/ San Isidro, 24','07760','CIUTADELLA DE MENORCA','Menorca','ES','','','','','Sr. Luís Anglada Carreras','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000932',1,'PERSIRAPID, S.L.','','','0000-00-00','C/ BARCELONA, S/N (POL.IND.TORRE-SERONA)','25131','TORRE-SERONA','25131-(LLEIDA)','ES','08:00-13:00 / 15:00-19:00','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','PERSIRAPID, S.L.','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430000934',1,'Marc Klamburg Roque','','','0000-00-00','Ronda General Mitre, 125','08022','BARCELONA','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000936',1,'PERGOLAS MARTÍ','','','0000-00-00','C/AMERICA 49\n08041','BARCE','BARCELONA','BARCELONA','ES','','','','','JOSEP MARTI','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000938',1,'ATRIUM CONCEPT','','','0000-00-00','GRAND RUE\n57310 BERTRANGE','26247','26247','','ES','','','','','MR.MME LERACH JEANNOT 33','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000958',1,'FRANCE RENOVATION','','','0000-00-00','38, Avenue Robert sschumann','13700','MARIGNANE','BOUCHES DU RHONE','FR','','','','','Mr. Akyol','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000974',1,'JARDI HOSTEL','','','0000-00-00','C/ Libertad, 38','17200','PALAFRUGELL','Girona','ES','','','','','Philippe Coissac','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000977',1,'BECKHEUN ANDALUCIA','','','0000-00-00','C/ Libertad, 28','29100','COIN','Málaga','ES','','','','','Sr. Alejandro o Sr. Isaac','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000979',1,'AZUR FERRONNERIE','','','0000-00-00','23, route du Plan de la Tour','83120','SAINTE MAXIME','VAR - FRANCE','ES','','','','','Mr. Thierry Reiz','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000982',1,'RHODANIENNE MENUISERIE ALUMINI','','','0000-00-00','5, boulevard Marcel Dassault','69330','JONAGE','RHONE - FRANCE','ES','','','','','L.Didia','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000983',1,'SARL R1 FERMETURES','','','0000-00-00','37, rue Prospère Merine','38000','GRENOBLE','ISERE - FRANCE','ES','','','','','Mr. Ruslay Robert','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000989',1,'SUR MESURE MENUISERIE ET STORE','','','0000-00-00','174, impasse Lavoisier\nZAE L\'Estagnol - La Moutonne','83260','- LA CRAU','VAR - FRANCE','ES','Tel. 0033494217142','','','','Mr. Bernad Massias','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430000994',1,'TRANSCOMAR / SERVIMENSA','','','0000-00-00','P.I. PALMONES III\nC/ Océano Pacífico, 3','11370','LOS BARRIOS','ALGECIRAS','ES','','','','','956 678 683','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001009',1,'ROSA MARIA SAINZ SAENZ','','','0000-00-00','C/ LA MASO, 2\n28034','28034','MADRID','MADRID','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001018',1,'EURL POLICAND chez JFB','','','0000-00-00','6, rue le Brix','38100','- GRENOBLE','ISERE ( FRANCE )','ES','','','','','Mr. Morgan Policand','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001024',1,'PRO FERM Maison du Menuisier','','','0000-00-00','179, route des Vignerons - D96','13112','- LA DESTROUSSE','BOUCHES DU RHONE','ES','','','','','Patrice Khougazian','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001035',1,'MANUEL SANCHEZ SANCHEZ','','','0000-00-00','PUIG I VALLS, 13-15,LOCAL 15','08028','BARCELONA','BARELONA','ES','SI NO ESTA DEJAR Nº19','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001036',1,'PORTES ER FENETRES DU TRIANGLE','','','0000-00-00','21, rue de Varennes','52130','VAUX SUR BLAISE','HAUTE MARNE','ES','','','','','chez ADMS','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001040',1,'DANIEL LUXO UNIPERSSOAL, LDA','','','0000-00-00','Rua Mauricio Pinto, 5','3080-','3080-149 FIGUEIRA DA FOZ','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001042',1,'CMS 92','','','0000-00-00','335, Rue de la Garenne','9200','NANTERRE','HAUTS DE SEINE','ES','','','','','Mr. Angel Medina','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001053',1,'GUNNI TRENTINO HOME CENTRAL','','','0000-00-00','C/ Lago carucero s/n\nP.I. COBO CALLEJA','28947','Fuenlabrada','Madrid','ES','','','','','Sra. Pilar Díaz  Tel.916424410','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001058',1,'ANTALEX','','','0000-00-00','36, rue de la Gare','70110','- EXPRELS','HAUTE SAONE - FRANCE','ES','','','','','Mr. CARENJOT JEAN-JACQUES','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001066',1,'RB TOLDOS','','','0000-00-00','Zona Industrial rua B5\nLote 270','7370-','7370-114 CAMPO MAIOR','PORTUGAL','ES','','','','','Sr. Rui Brito','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001068',1,'XD SOLUTIONS, UNIPESSOAL LDA','','','0000-00-00','RUA DE MAURICIO PINTO, 5','3080-','3080-149 FIGUEIRA DA FOZ','PORTUGAL','ES','','','','','Sra. Sofia Silva','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001069',1,'TECSUN','','','0000-00-00','RIU EBRE, 41 (CAP PONT)','25005','LLEIDA','','ES','','','','','Sr. Rafael González Paton','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001074',1,'SARL MENUISERIE DU SUD','','','0000-00-00','24, rue Louis Proust','30900','- NIMES','GARD - FRANCE','ES','','','','','Mr. Fabien Bramly','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001076',1,'FINESTRES BCN','','','0000-00-00','C/ Aribau, 149','08036','Barcelona','','ES','','','','','SR. XAVI','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001080',1,'ABAYS PREMIUM, S.L.','','','0000-00-00','Ronda General Mitre, 125','08022','','Barcelona','ES','','','','','Sr. Marc Klamburg','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001088',1,'','','','0000-00-00','ENTREGA EN:\r\nC/ ROCA I UMBERT,  26','08907','HOSPITALET DE LLOBREGAT','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001091',2,'AVISAR A MARTA 93 314 5800 ANTES DE DESCARGAR','','','0000-00-00','Moli D´en Bisbe 35','08110','Montcada i Reixach','Barcelona','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001093',1,'STORES DI LUCCA','','','0000-00-00','1153, Avenue Jean Monnet','83190','OLLIOULES','VAR - FRANCE','ES','','','','','Mme di Lucca','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001105',1,'ARTIS TERRA CONSTRUCCIONES SL','','','0000-00-00','','','','MADRID','ES','','','','','Sra. Silvia','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001111',1,'','','','0000-00-00','COSTA BRAVA, 33  ','08380','MALGRAT DE MAR','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001120',1,'ECO HABITAT BOURGOGNE SAS','','','0000-00-00','13 Route de Sens','89100','- GRON','','ES','','','','','Ste. Markovic','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001121',1,'CONCEPT RENOVATION CONSTRUC-','','','0000-00-00','69, Rue de l\'Eygala','38430','- MOIRANS','ISERE','ES','','','','','TION-HAPI HABITAT.','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001123',1,'PLASAN METAL, S.L.','','','0000-00-00','ELECTRICIDAD, 8','08110','MONTCADA I REIXAC','BARCELONA','ES','08:00 - 14:00 - 15:00 - 19:00','607630429 Dani/606728598 Isma','','','Sr Ismael / Sr. Ruben','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001128',1,'JEAN-MARIE BAILLARGEAT chez','','','0000-00-00','8 rue Mondon','87160','MAILHAC SUR BENAIZE','HAUTE VIENNE','ES','','','','','GORGE GERARD','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001135',1,'','','','0000-00-00','Carrer Pere Costa 14 local','08024','Barcelona','Barcelona','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001141',1,'SARL F.A.S.','','','0000-00-00','95, ROUTE DE CHATEAUGAILLARD','45470','- REBRECHIEN','LOIRET','ES','','','','','Mr. Franck Lefaucheux','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001150',1,'JOAN DE JOAN RIBA','','','0000-00-00','CAMI DE CAN GANXET, 97','08195','SANT CUGAT','','ES','','','','','SISMICS','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001169',1,'MDESIGN OSMANI SA*************','','','0000-00-00','Impasse de la Cua 2 à 1563','1563','1563 - DOMPIERRE','SUIZA','CH','','','','','Laora Chiuminatti','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001169',2,'MDESIGN OSMANI SA','','','0000-00-00','Chemin de Daviau, 2','1805','JONGNY ','SUSSE','CH','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001174',1,'MATHIEU MENUISERIE','','','0000-00-00','64, RUE DE L\'EUGALA\nCentre Aklpes','38430','- MOIRANS','ISERE','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001178',1,'COTOSEDA','','','0000-00-00','DOCTOR MARTI I JULIA. 109','08903','HOSPITALET','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','COTOSEDA','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001184',1,'','FR75821933595','','0000-00-00','1, Allée Françoise Giroud','33310','LORMONT','GIRONDE','FR','','0033764419882','','','Monsieur Sellan','gdlfermeture@gmail.com','',0,'','','','','N','','',0,0.00,'','N','N','','GENTLEMAN DE LA FERMETURE','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001197',1,'DIRECCION DE ENVÍO','','','0000-00-00','C/ BILBAO, 63-75 NAVE 9 ','08100','MOLLET DEL VALLES','BARCELONA','ES','','','','','Sr. Eloy','','',0,'','','','','N','','',0,0.00,'','N','N','','VALLASPVC.ES','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001214',1,'CONFORT MENUISERIE chez TRANSPORT PORTAL','FR12529615247','','0000-00-00','MEMER RD 926','12200','VAILHOURLES','AVEYRON','FR','','','','','Mr. Alain Viguier','cms.av12@orange.fr','',0,'','000019','021','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001221',1,'EURL J.A.M. DIFFUSION','FR69817509326','','0000-00-00','MDM HABITAT\r\nZA les Paluds (chemin du hangar d\'Emilien)','13430','EYGUIERES','BOUCHES DU RHÔNE','FR','','0033633592000','','','Julie Grangier','mdmhabitat@hotmail.com','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001232',1,'TOLDOS CANUT','','','0000-00-00','C/Aiguafreda, 14','08480','L\'ATMETLLA DEL VALLES','Barcelona','ES','','','','','JOSE Mª VADILLO CANUT','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001236',1,'Toldos Barcelona','','','0000-00-00','C/ HUELVA,  38','08020','Barcelona','BARCELONA','ES','','','','','','','',0,'','','110','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001253',1,'DAVID NAVAS BLANQUEZ','','','0000-00-00','C/ FRANCESC SALVANS, 48','08225','TERRASSA','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','RELAXCONFORT','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001256',1,'','','','0000-00-00','POIG.CAN ROSES C/.ATLETISME,15','00080','RUBI','','ES','','93-5882220','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001257',1,'CRISTALERIA ANOIA ARSAL S.L.','B59931790','','0000-00-00','P.I. CAN FERRER I\r\nC/ GRECIA, 10','08770','SANT SADURNÍ D\'ANOIA','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001261',1,'','','','0000-00-00','P.I. Sant Ermengol\r\nC/ Progrès, 18-20','08630','ABRERA','Barcelona','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001270',1,'','','','0000-00-00','Av. Vidreres, 36 ','17310','LLORET DE MAR','GIRONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001276',1,'','','','0000-00-00','POLIGONO BOFARULL\r\nC/. BARCELONA, 411 NAVE 19\r\n','08620','SANT VICENÇ DELS HORTS','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','ADAI','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001291',1,'','','','0000-00-00','Plza Cap de Creu, 7','08800','Vilanova i la Geltrú','Barcelona','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001298',1,'HK STORES / ALSACE APPLICATION','FR0H805227352','','0000-00-00','5 IMPASSE DE L\'EUROPE ','57370','PHALSBOURG','Presupuesto TMP','FR','','','','0033612495629','Herve Klein','h.klein@hotmail.fr','',0,'','','','','N','','',0,0.00,'','N','N','','HK STORES','-','-','-',0,1,1,0,0,'','','','','',0,'',1,'',''),('430001300',1,'Alper Alumini i Vidre SLU','B66664871','','0000-00-00','c/ Santander, 17','08620','Sant Vicenç dels Horts','Barcelona','ES','','650515683','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001302',1,'MD CONCEPT MEUNISERIE','','','0000-00-00','39 Avenue de Sarlat','46200','SOUILLAC','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','MAGASIN PULSAT','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001304',1,'','','','0000-00-00','C/ Marcelí, Gener, 24','08800','VILANOVA I LA GELTRÚ','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','TOT KILAIN','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001306',1,'Montesquieu RF-R1 Reno','','','0000-00-00','9, Avenue Marius Chorot','38430','Moirans','','FR','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','EUR','','',0,'',1,'',''),('430001312',1,'Menuiserie Design SA','','','0000-00-00','Impasse de la Cua 2','1563','Compierre','','CH','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001312',2,'','','','0000-00-00','18 Route de Chailly','1814','LA TOUR DE PELTZ','','CH','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001312',3,'','','','0000-00-00','Le grand Chemin 52','1066','Chantier Epalinges','','CH','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','Menuierie Design SA','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001312',4,'Menuiserie Design SA','','','0000-00-00','20, Route de l\'Arche','1880','Chantier BEX','bex','CH','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001317',1,'','','','0000-00-00','12 Route de Louvois','51520','St Martin','','FR','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',1,'',''),('430001319',1,'','','','0000-00-00','Lieu dit le Boulay','37380','MONNAIE','INDRE ET LOIRE','FR','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','SARL CONCEPT MENUISERIE','-','-','-',0,1,1,0,0,'','','','','',0,'',1,'',''),('430001320',1,'','','','0000-00-00','C/ Sevilla, 3','08740','Sant Andreu de la Barca','Barcelona','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001322',1,'Okatent, S.L.','','','0000-00-00','Polígon Vilapou, Nau 2 ','08640','Olesa de Montserrat','Barcelona','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','Okatent, S.L.','-','-','-',0,1,1,0,0,'','','','','',0,'',1,'',''),('430001322',2,'Okatent, S.L.','','','0000-00-00','c/ Roger de Llúria, 124  3º 1ª','08037','Barcelona','Barcelona','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','Okatent, S.L.','-','-','-',0,1,0,1,0,'','','','','',0,'',1,'',''),('430001328',1,'INFINITY CONSTRUCTION','FR27812946820','','0000-00-00','42 rue Trachel','06200','NICE','ALPES MARITIMES','FR','','0033626292614','','','Romuald','','',0,'','','','','N','','',0,0.00,'','N','N','','INFINITY CONSTRUCTION','-','-','-',0,1,1,0,0,'','','','','',0,'',1,'',''),('430001334',1,'SCREEN VOGUE','','','0000-00-00','C/Aribau 108','08036','BARCELONA','BARCELONA','ES','10-14','93.211.64.98','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','SCREEN VOGUE','-','-','-',0,1,1,0,0,'','','','','',0,'',1,'',''),('430001348',1,'XAVIER COMELLAS ALERT','','','0000-00-00','C/ FRANCESC MACIÀ, 55  BAIXOS','08630','OLESA DE MONTSERRAT','BARCELONA','ES','','','','','Xavier Comellas','','',0,'','','','','N','','',0,0.00,'','N','N','','ANTIGA CASA SANCHO','-','-','-',0,1,1,0,0,'','','','','',0,'ANTIGA CASA SANCHO',0,'',''),('430001350',1,'','','','0000-00-00','C/ Gélida, 8','08783','Masquefa','Barcelona','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001360',1,'Alutex','','','0000-00-00','c/ Barcelona,1','08800','VILANOVA I LA GELTRÚ ','Barcelona','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','Alutex','-','-','-',0,1,1,0,1,'','','','','',0,'',1,'',''),('430001393',1,'PITARQUE VIDRIERS S.L.','','','0000-00-00','PLAÇA SALVADOR ALLENDE S/N','08740','SANT ANDREU DE LA BARCA','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','PITARQUE VIDRIERS S.L.','-','-','-',0,1,1,0,0,'','','','','',0,'PITARQUE',0,'',''),('430001400',1,'','','','0000-00-00','Avinguda Mestre Muntaner, 31','08788','IGUALADA','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','TOLDOS IGUALADA','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001405',1,'','','','0000-00-00','4 rue de ballan','37300','JOUE LES TOURS','','FR','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','MENUISERIE TOURANGELLE','-','-','-',0,1,1,0,0,'','','','','',0,'',1,'',''),('430001408',1,'ACSA, OBRAS INFRAESTRUCTURAS, S.L.','','','0000-00-00','FEIXA LLARGA, 55-61 ','08907','L´HOPSPITALET DEL LLOBREGAT','BARCELONA','ES','','934131609 EXT 531609','','600927768','','','',0,'','','','','N','','',0,0.00,'','N','N','','SORIGUÉ','-','-','-',0,1,1,0,0,'','','','','',0,'',1,'',''),('430001413',1,'','','','0000-00-00','C/ HUELVA,  38','08020','BARCELONA','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001420',1,'VITCAT S.C.P.','','','0000-00-00','C/ JACINT VERDAGUER, 4 - 6','25600','BALAGUER','LLEIDA','ES','','','','626404633','Marc','','',0,'','','','','N','','',0,0.00,'','N','N','','TENDALS BALAGUER','-','-','-',0,1,1,0,0,'','','','','',0,'BALAGUER',0,'',''),('430001425',1,'DAVID VILANOVA SANCHO','46743754A','','0000-00-00','C/ JOSEP MESTRES, 1','08880','CUBELLES ','BARCELONA','ES','','','','678720551','David Vilanova','','',0,'','','','','N','','',0,0.00,'','N','N','','DAVID VILANOVA SANCHO','-','-','-',0,1,1,0,0,'','','','','',0,'DAVID VILANOVA',0,'',''),('430001430',1,'','','','0000-00-00','C/Mossen Cinto Verdaguer, 9','','','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001431',1,'HOLIDEX TEXTIL S.L.','','','0000-00-00','C/ HUELVA, 38','08020','BARCELONA','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','HOLIDEX TEXTIL S.L.','-','-','-',0,1,1,1,0,'','','','','',0,'TOLDOS PENEDES',0,'',''),('430001435',1,'MIGUEL ANGEL MOLINA DIAZ','','','0000-00-00','C/ JAIME CASANOVAS, 189 LOCAL 3','08820','EL PRAT DE LLOBREGAT','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'MIGUEL ANGEL MOLINA DIAZ',0,'',''),('430001436',1,'TOLDOS Y CORTINAS PASTOR','','','0000-00-00','AVDA. PALLARESA, 176','08923','SANTA COLOMA DE GRAMANET','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','TOLDOS Y CORTINAS PASTOR','-','-','-',0,1,1,0,0,'','','','','',0,'PASTOR',0,'',''),('430001440',1,'ANTONIO LOPEZ LLAMAS','','','0000-00-00','C/ RAMÓN LLULL, 18  LOCAL 6','08830','SANT BOI DE LLOBREGAT','BARCELONA','ES','','','','654 379 808','','','',0,'','','','','N','','',0,0.00,'','N','N','','ANTONIO LOPEZ LLAMAS','-','-','-',0,1,1,0,0,'','','','','',0,'LA CASA DE LAS CORTINAS',0,'',''),('430001449',1,'Entrega Toldos Ades','','','0000-00-00','avda.francesc Macià, 14','','Cunit','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001450',1,'','','','0000-00-00','CTRA DE BARCELONA 81','08740','SANT ANDREU DE LA BARCA','BARCELONA','ES','','642569936','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001450',2,'llamar un día antes de la entrega','','','0000-00-00','','','','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001454',1,'','','','0000-00-00','C/ DE LA SEQUIA COMTAL, 10-12 LOCAL','08018','BARCELONA','','ES','','','','','Cristina','','',0,'','','','','N','','',0,0.00,'','N','N','','TOLDOS CLOT','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001462',1,'','','','0000-00-00','C/. BONAVENTURA PEDEMONTE, 8','08740','SANT ANDREU DE LA BARCA','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001463',1,'','','','0000-00-00','C/ VALLE DEL CINCA, 48  POL. PAULES','22400','MONZON','HUESCA','ES','','686 902 454','','','Martín González','info@toldosciria.es','',0,'','','','','N','','',0,0.00,'','N','N','','CIRIA TOLDOS','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001468',1,'C/ ROSA RIBAS I PARELLADA, 20','','','0000-00-00','','','','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'ALUMINIS HG',0,'',''),('430001472',1,'','','','0000-00-00','C/ TARRAGONA, 10-12','08820','EL PRAT DE LLOBREGAT','BARCELONA','ES','','','','682 735 810','José','joseguerra3330@gmail.com','',0,'','','','','N','','',0,0.00,'','N','N','','ALUDECOR','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001477',1,'','','','0000-00-00','61, Avenue des Chasséens - ZI AVON','13120','GARDANNE','','FR','','33 (0) 970 70 77 57','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','STORES & PERGOLAS','-','-','-',0,1,1,0,0,'','','','','',0,'STORES',0,'',''),('430001483',1,'','','','0000-00-00','C/ Tamarit, 116','','Ripollet','','ES','8h a 18h','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001488',1,'','','','0000-00-00','C/ SANTA MARTA, 1-3 LOCAL','08860','CASTELLDEFELS','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','TOLDOS Y PERSIANAS EL CASTELL','-','-','-',0,1,1,0,0,'','','','','',0,'EL CASTELL',0,'',''),('430001489',1,'','','','0000-00-00','C/ FILADORS, 6 AP PISO 33','43860','TORREDEMBARRA','TARRAGONA','ES','10:00-13:30-17:30','977 640 518 / 657 389 400','977640518','','Jaume Mercader','info@decoracioleo.com','',0,'','','','','N','','',0,0.00,'','N','N','','DECORACIÓ LEO\r\n','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001493',1,'','','','0000-00-00','C/ Isabel la Católica, 8','08788','Vilanova d\'Espoia','Barcelona','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001495',1,'','','','0000-00-00','C/ Acadèmia, 42','25002','Lleida','','ES','','973 262 060','','','Mercè Arbonés i Aragües','marbones@toldosarbones.com','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,0,1,1,'','','','','',0,'',0,'',''),('430001506',1,'','','','0000-00-00','61, Avenue des Chasséens - ZI AVON','13120','GARDANNE','','FR','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','QUALITOILES S.L.','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001507',1,'','','','0000-00-00','C/ Valentí Escalas, 19 Local','08923','SANTA COLOMA DE GRAMANET','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001509',1,'','','','0000-00-00','C/ Horts, 42','08194','Sant Quirze del Vallés','Barcelona','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','PUERTAS Y AUTOMATISMOS VALLES','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001516',1,'','','','0000-00-00','C/ Montjuïc, 16 ','17300','BLANES','GIRONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','ECO SENY','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001517',1,'','B65803181','','0000-00-00','Rambla Paisos Catalans, n 10','08800','VILANOVA I LA GELTRU','BARCELONA','ES','','','','','Fermín','info@qualitytoldos.com','',0,'','','','','N','','',0,0.00,'','N','N','','QUALITY TOLDOS ','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001526',2,'','','','0000-00-00','C/ CARRERAS I CANDI, 24 LOCAL','08028','BARCELONA','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001542',1,'','','','0000-00-00','C/ ALEXANDER BELL, 15 LOCAL','08221','TERRASSA','BARCELONA','ES','','','','649 430 208','','','',0,'','','','','N','','',0,0.00,'','N','N','','CRISTINA TOL-2','-','-','-',0,1,1,0,0,'','','','','',0,'',1,'',''),('430001549',1,'TOLDOS Y ALUMINIOS MARESME','73195917G','','0000-00-00','C/ B, NAVE 12 \r\nP.I. C. VERDALET','08490','TORDERA','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','TOLDOS Y ALUMINIOS MARESME','-','-','-',0,1,1,0,0,'','','','','',0,'',1,'',''),('430001572',1,'ALU-JORDI S.L.','','','0000-00-00','SALVADOR BARONE, 36','08840','VILADECANS','BARCELONA','ES','','','','655533660','','','',0,'','','','','N','','',0,0.00,'','N','N','','ALU-JORDI S.L.','-','-','-',0,1,1,0,0,'','','','','',0,'ALUJORDI',0,'',''),('430001577',1,'','','','0000-00-00','IMPERIAL TARRACO, 2 LOCAL 1C','43880','COMARRUGA','TARRAGONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',1,'',''),('430001580',1,'C/ Entenza, 24 Esc.D S-3','','','0000-00-00','','','','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'Technical',0,'',''),('430001588',1,'','','','0000-00-00','Calle Marconi','','Pineda de Mar','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001593',1,'','','','0000-00-00','Carrer Barcelona, 411','08620','St Vicenç dels Horts','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001593',2,'DAVID VILANOVA','','','0000-00-00','JOSEP MESTRES, 1','08880','CUBELLES','BARCELONA','ES','','','','678 720 551','DAVID','','',0,'','','','','N','','',0,0.00,'','N','N','','DAVID VILANOVA SANCHO','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001597',1,'FIREWALL MECOSA, S.L.U.','','','0000-00-00','C/ ANDORRA , 63- 65 NAVE 5','08840','VILADECANS','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','FIREWALL MECOSA, S.L.U.','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001598',1,'','','','0000-00-00','CABAS TRANSITARIOS S.L.\r\nP.I. LA MENACHA\r\nAV. EL PUERTO NAVE 6.22','11205','ALGECIRAS','CADIZ','ES','09:00 - 14:00  /  16:00 - 19:00','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001605',1,'','','','0000-00-00','C/ Consorts de Sans Bernet, 31 (esquina C/Palafox) (LLAMAR ANTES)','','','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001612',1,'','','','0000-00-00','CARRER DE LES CABANYES, 4-18\r\nTELEFONO 633852223','08720','VILAFRANCA DEL PENEDÈS','BARCELONA','ES','8-18h','','','633852223','Daniel','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001619',1,'LORES METAL, S.L.','B64667629','','0000-00-00','C/ MONTILLA, 2','08970','SANT JOAN DESPÍ','BARCELONA','ES','','','','667 719 162','','','',0,'','','','','N','','',0,0.00,'','N','N','','LORES METAL, S.L.','-','-','-',0,1,1,0,0,'','','','','',0,'LORES',0,'',''),('430001624',1,'','','','0000-00-00','C/Masquefa, 7  ','08791','SANT LLORENÇ D\'HORTONS  ( COEMVA )','Barcelona','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001646',1,'Delegación Barcelona','','','0000-00-00','Delegación Barcelona','','','','ES','','93.303.74.15','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','\r\n','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001647',1,'','','','0000-00-00','DIRECCIÓN DE ENTREGA:\r\n\r\nJOANOT MARTORELL, 272 GRANOLLERS','08401','GRANOLLERS','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001653',1,'Silent Gliss Madrid','','','0000-00-00','Av. Canteras, 64, Módulo 2, Nave A','28343','Valdemoro','Madrid','ES','','91.296.38.31','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','Silent Gliss Madrid','-','-','-',0,1,1,1,1,'','','','','',0,'Silent',1,'',''),('430001662',1,'','','','0000-00-00','Juan de Garay, 24 (llamar antes)','','','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001669',1,'','','','0000-00-00','C/ GUILLEM DE MUNTANYANS, 49\r\npuerta roja','08223','TERRASSA','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001685',1,'','','','0000-00-00','PJE. TOPACIO, 4 ','08191','RUBÍ','BARCELONA','ES','','','','605 479 764','Juan Piñol','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001690',1,'','','','0000-00-00','C/ RETAMA, 73 LOCAL','08840','VILADECANS','BARCELONA','ES','','','','','Oliver','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001693',1,'','','','0000-00-00','C/ Masía Notari, 29 Nave 5','08800','VILANOVA I LA GELTRU','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001697',1,'','','','0000-00-00','C/ Francesc Macià, 55','08640','Olesa de Montserrat','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001699',1,'','','','0000-00-00','PASSEIG ESPANYA, 54','08710','SANTA MARGARIDA DE MONTBUI','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001709',1,'','','','0000-00-00','C/ AMPLE, 60-62','08225','TERRASSA ','','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','TOLDOS Y CARPINTERÍA IRIS, S.L.','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001715',1,'','','','0000-00-00','C/ Voluntaris, 44','08223','Terrassa','Barcelona','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001718',1,'','','','0000-00-00','CARRER DE LA MASIA EN NOTARI','08758','CERVELLÓ','','ES','','','','661 659 901','Miguel Angel','','',0,'','','','','N','','',0,0.00,'','N','N','','ALUMINIS VIALMA','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001724',1,'','','','0000-00-00','C/ Pare Font, 116 ','08223','TERRASSA','Barcelona','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','DE LOLA','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001725',1,'','','','0000-00-00','C/ Rafael Casanovas, 3','08788','Vilanova del Camí','Barcelona','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001727',1,'','','','0000-00-00','CALLE VALLPARADIS 85 ','08223','TERRASSA','','ES','LLAMAR ANTES A MARTA SOLO POR LAS MAÑANAS ','','','607 361 818	','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001734',1,'BAGES TENDALS','','','0000-00-00','CARRETERA PONT DE VILOMARA,92     ( COMERCIAL PRAT  )','08241','Manresa','BARCELONA','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'BAGES',0,'',''),('430001750',1,'','','','0000-00-00','C/ Ramón Llull, 18 Local 6','08830','Sant Boi de Llobregat','Barcelona','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001759',1,'','','','0000-00-00','C/ Grevol, 7','08211','Castellar del Vallés','Barcelona','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001761',1,'Santos Transportes','','','0000-00-00','P.I. CIM VALLES - ZONA e, PARCELA 8 Nave 7','08130','Santa Perpetua de Mogoda','Barcelona','ES','De 09:00 - 19:00 h  preferentemente de 11:00 - 16:00 h','933 366 045','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001788',1,'','','','0000-00-00','C/ Josep Mestres, 1','08880','Cubelles','Barcelona','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001789',1,'','','','0000-00-00','Plaça Anselm Clavé, 1  Baixos','08192','Sant Quirze del Vallès','Barcelona','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001792',1,'','','','0000-00-00','Crta.del Pla, 285,Pol.Ind.Valls Nau-33','43800','Valls','Tarragona','ES','','','','','Mariona','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001802',1,'','','','0000-00-00','C/ Onze de Setembre, 19','08450','Llinars del Valles ','Barcelona','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','Tapisseria Llinars ','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001803',1,'','','','0000-00-00','C/ Barcelona, 411 Nave 19','08620','Sant Vicenç dels Horts','Barcelona','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('430001815',1,'','','','0000-00-00','C/ Autobomia, 122 A','08225','Terrassa','Barcelona','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('430001816',1,'','','','0000-00-00','C/ Arenys, 5  ( P.I. Can Patalina )','08380','Malgrat de Mar','Barcelona','ES','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','','-','-','-',0,1,1,0,0,'','','','','',0,'',0,'',''),('436000723',1,'','','','0000-00-00','C/ Nou, 27','08729','LES MASUQUES','BARCELONA','ES','','','','','Montse','protendalls@gmail.com','',0,'','','','','N','','',0,0.00,'','N','N','','PROTENDALLS','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'',''),('PRE000815',1,'Quimanna Arquitectura','B63847313','','0000-00-00','C/ Miquel Torelló i Pagès, 58','08750','Molins de Reí','Barcelona','ES','','93.211.96.28','','676479051','Quim Ferrer','','',0,'','','','','N','','',0,0.00,'','N','N','','ECOSPAI','-','-','-',0,1,1,1,1,'','','','','',0,'Quimana',1,'',''),('PRE000882',1,'Factory 1','','','0000-00-00','No. 7 Xiushan West Road, Lishui Development Zone, Lishui District','211200','Nanjing City','Jiangsu Province','CN','','','','','','','',0,'','','','','N','','',0,0.00,'','N','N','','Fante Shredder & Machinery','-','-','-',0,1,1,1,1,'','','','','',0,'',1,'','');
/*!40000 ALTER TABLE `maescuendir` 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:16
