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

DROP TABLE IF EXISTS `promstru`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `promstru` (
  `cod_articulo_ela` char(30) NOT NULL DEFAULT '' COMMENT 'Artíc. elaborado',
  `estruc_ela` int(11) NOT NULL DEFAULT '0' COMMENT 'Estructura',
  `nombre` text NOT NULL COMMENT 'Nombre',
  `cod_tipo_estruc` char(3) NOT NULL DEFAULT 'ESE' COMMENT 'Tipo estructura',
  `cod_articulo_ela_dup` char(30) NOT NULL DEFAULT '' COMMENT 'Artíc. elaborado a duplicar',
  `estruc_ela_dup` int(11) NOT NULL DEFAULT '0' COMMENT 'Estructura a duplicar',
  `revision_nivel` decimal(4,2) NOT NULL DEFAULT '0.00' COMMENT 'Nivel revisión',
  `revision_fecha` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Fecha revisión',
  `revision_cod_usuario` char(10) NOT NULL DEFAULT 'rgiribet' COMMENT 'Usuario revisión',
  `cod_tipo_bloqueo` char(5) NOT NULL DEFAULT '' COMMENT 'Bloqueado por',
  `cantidad_fab_min` decimal(20,8) NOT NULL DEFAULT '0.00000000' COMMENT 'Mín. fabricable',
  `cantidad_fab_max` decimal(20,8) NOT NULL DEFAULT '0.00000000' COMMENT 'Máx. fabricable',
  `cantidad_optima` decimal(20,8) NOT NULL DEFAULT '0.00000000' COMMENT 'Lote óptimo',
  `cantidad_multiplo` decimal(20,8) NOT NULL DEFAULT '0.00000000' COMMENT 'Fabricar múltiplo',
  `stock_minimo_esc` decimal(20,8) NOT NULL DEFAULT '0.00000000' COMMENT 'Mín. componts.',
  `observaciones` text NOT NULL COMMENT 'Observaciones',
  `id_maescombart_ela` int(11) NOT NULL DEFAULT '0' COMMENT 'Id Combinación',
  `id_tenant` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Nº empresa',
  `cod_cuenta` char(12) NOT NULL DEFAULT '' COMMENT 'Cliente',
  `num_dien` int(11) NOT NULL DEFAULT '0' COMMENT 'Dirección',
  UNIQUE KEY `key0` (`id_tenant`,`cod_articulo_ela`,`estruc_ela`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `promstru` WRITE;
/*!40000 ALTER TABLE `promstru` DISABLE KEYS */;
INSERT INTO `promstru` (`cod_articulo_ela`, `estruc_ela`, `nombre`, `cod_tipo_estruc`, `cod_articulo_ela_dup`, `estruc_ela_dup`, `revision_nivel`, `revision_fecha`, `revision_cod_usuario`, `cod_tipo_bloqueo`, `cantidad_fab_min`, `cantidad_fab_max`, `cantidad_optima`, `cantidad_multiplo`, `stock_minimo_esc`, `observaciones`, `id_maescombart_ela`, `id_tenant`, `cod_cuenta`, `num_dien`) VALUES ('clona-test',1,'CAMBIOS DE LONAS ','ESE','TOL-050hhh-lll-sss',1,1.00,'2016-11-11','SETUP','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('clona-test',3,'CAMBIOS DE LONAS ','ESE','TOL-050hhh-lll-sss',1,1.00,'2016-11-11','SETUP','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('CLONAAC',1,'LONA CONFECCIONADA ( Medidas Acabadas)','ESE','clona-test',1,1.00,'2016-11-11','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('CLONAAS',2,'CAMBIO LONA ACRILICO SOLDADO','ESE','clona-test',1,2.00,'2016-11-30','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('CLONABB',2,'BAMBALINA EN LONA ACRILICA','ESE','clona-test',1,2.00,'2016-11-30','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('CLONABI',2,'CAMBIO DE LONA B.INVISIBLE','ESE','clona-test',1,2.00,'2016-11-30','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('CLONABPR',56,'CAMBIO DE LONA B.P.R.','ESE','CLONAAC',1,1.00,'2016-01-08','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('CLONABT',1,'CAMBIO DE LONA TELON','ESE','clona-test',1,1.00,'2017-09-27','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('CLONACM',56,'CAMBIO LONA CORREDERO MARINO','ESE','CLONAAC',1,1.00,'2016-01-08','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('CLONACMS',1,'CAMBIO LONA CORREDERO MARINO SIMPLE','ESE','CLONACM',56,1.00,'2019-03-19','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('CLONAH',56,'CAMBIO DE LONA DE HIERRO','ESE','CLONAAC',1,1.00,'2016-01-08','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('CLONAS',2,'CAMBIO TEJIDO SCREEN/SOLTIS 96','ESE','clona-test',1,2.00,'2016-11-30','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('CLONAST',2,'CAMBIO TEJIDO SOLTIS 92','ESE','clona-test',1,2.00,'2016-11-30','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('COR-043-hhh-lll-sss',1,'CORTINA CONFECCIONADA','ESE','TOL-001hhh-lll-sss',1,1.00,'2017-01-17','SETUP','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('COR-043D-hhh-lll-sss',1,'CORTINA ENROLLABLE DESMULTIP. 43mm.','ESE','COR-043-hhh-lll-sss',1,1.00,'2017-01-31','SETUP','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('COR-043M-hhh-lll-sss',1,'CORTINA ENROLLABLE MOTOR 43mm.','ESE','COR-043-hhh-lll-sss',1,1.00,'2017-02-07','SETUP','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('COR-053D-hhh-lll-sss',1,'CORTINA ENROLLABLE DESMULTIP. 53mm.','ESE','COR-053-hhh-lll-sss',1,1.00,'2017-01-31','SETUP','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('COR-053M-hhh-lll-sss',1,'CORTINA ENROLLABLE MOTOR 53mm.','ESE','COR-043M-hhh-lll-sss',1,1.00,'2017-02-07','SETUP','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('COR-053MAN-hhh-lll-sss',1,'ENROLLABLE CORTINA MANIVELA 53mm.','ESE','COR-053D-hhh-lll-sss',1,1.00,'2017-02-07','SETUP','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('CORTINA CORREDERA',1,'CORTINA CORREDERA','ESE','clona-test',1,1.00,'2016-11-30','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('metraje-test',1,'','ESE','clona-test',1,1.00,'2016-11-11','SETUP','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('METRAJE090',1,'1','ESE','',0,1.00,'2023-08-08','XAVI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-001BOXhhh-lll-sss',1,'TOLDO TELON BOX','ESE','TOL-009hhh-lll-sss',1,1.00,'2015-01-23','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-001hhh-lll-sss',1,'TOLDO TELON hhh','ESE','TOL-051hhh-lll-sss',1,1.00,'2015-01-23','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-002hhh-lll-sss',1,'','ESE','TOL-051hhh-lll-sss',1,1.00,'2014-11-10','RGiribet','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-003hhh-lll-sss',1,'TOLDO BPR SIN TENSION','ESE','TOL-004hhh-lll-sss',1,1.00,'2015-12-01','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-004hhh-lll-sss',1,'TOLDO BPR CON SEMITENSION hhh','ESE','TOL-001hhh-lll-sss',1,1.00,'2015-01-23','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-005hhh-lll-sss',1,'TOLDO BPRT CON TENSION hhh','ESE','TOL-004hhh-lll-sss',1,2.00,'2015-12-01','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-006hhh-lll-sss',1,'TOLDO MONOBLOC KLIP SHADELAB chs','ESE','TOL-039hhh-lll-sss',1,1.00,'2019-01-21','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('tol-007hhh-lll-sss',1,'','ESE','TOL-052hhh-lll-sss',1,1.00,'2019-01-21','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-008hhh-lll-sss',1,'','ESE','TOL-051hhh-lll-sss',1,1.00,'2019-01-21','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-009hhh-lll-sss',1,'','ESE','TOL-004hhh-lll-sss',1,1.00,'2018-03-27','XAVI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-022hhh-lll-sss',1,'','ESE','TOL-050hhh-lll-sss',1,1.00,'2015-01-25','SETUP','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-025hhh-lll-sss',1,'','ESE','TOL-053hhh-lll-sss',1,1.00,'2018-04-12','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-0269010-450-0',1,'','ESE','',0,1.00,'2020-08-03','XAVI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-026hhh-lll-sss',1,'Cofre Ares','ESE','TOL-046hhh-lll-sss',1,1.00,'2020-05-23','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-027hhh-lll-sss',1,'','ESE','TOL-051hhh-lll-sss',1,1.00,'2015-01-25','SETUP','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-028hhh-lll-sss',1,'','ESE','TOL-027hhh-lll-sss',1,1.00,'2015-01-25','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-029-hhh-lll-sss',1,'COFRE SPLENBOX 300','ESE','TOL-026hhh-lll-sss',1,1.00,'2016-01-19','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-030hhh-lll-sss',1,'Cofre Storbox 400','ESE','TOL-029-hhh-lll-sss',1,1.00,'2019-01-21','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('tol-031hhh-lll-sss',1,'COFRE MATICBOX 350','ESE','TOL-030hhh-lll-sss',1,1.00,'2016-09-22','SETUP','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-032hhh-lll-sss',1,'COFRE KUMO SHADELAB','ESE','TOL-033hhh-lll-sss',1,1.00,'2019-01-21','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-033hhh-lll-sss',1,'COFRE YUKI','ESE','TOL-026hhh-lll-sss',1,1.00,'2019-01-21','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-034hhh-lll-sss',1,'COFRE KYMA','ESE','TOL-026hhh-lll-sss',1,1.00,'2017-12-11','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-035hhh-lll-sss',1,'COFRE SHAN chs','ESE','TOL-034hhh-lll-sss',1,1.00,'2018-05-21','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-038hhh-lll-sss',1,'COFRE ARKO','ESE','TOL-030hhh-lll-sss',1,1.00,'2018-04-03','XAVI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-039hhh-lll-sss',1,'TOL-039hhh-lll-sss','ESE','TOL-007hhh-lll-sss',1,1.00,'2019-01-21','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-042hhh-lll-sss',1,'Toldo Monobloc arko','ESE','TOL-007hhh-lll-sss',1,1.00,'2019-03-25','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-043hhh-lll-sss',1,'Cofre FENG Tipo1','ESE','TOL-035hhh-lll-sss',1,1.00,'2019-03-14','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-046hhh-lll-sss',1,'\r\n','ESE','TOL-026hhh-lll-sss',1,1.00,'2020-04-08','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-049hhh-lll-sss',1,'STILLA','ESE','TOL-051hhh-lll-sss',1,1.00,'2019-04-23','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-050hhh-lll-sss',1,'','ESE','TOL-051hhh-lll-sss',1,1.00,'2015-01-25','SETUP','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-051hhh-lll-sss',1,'CITY','ESE','',0,1.00,'2015-09-29','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-052hhh-lll-sss',1,'TOLDO CITY SEMICOFRE','ESE','TOL-051hhh-lll-sss',1,1.00,'2015-01-23','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-053hhh-lll-sss',1,'','ESE','TOL-051hhh-lll-sss',1,1.00,'2015-01-25','SETUP','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-054hhh-lll-sss',1,'','ESE','TOL-051hhh-lll-sss',1,1.00,'2019-01-21','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-055chl-lll-sss',1,'','ESE','TOL-054hhh-lll-sss',1,1.00,'2019-01-21','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-056hhh-lll-sss',1,'Veranda Giotto','ESE','TOL-059hhh-lll-sss',1,1.00,'2019-01-21','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-057hhh-lll-sss',1,'VERANDA GIOTTO DOBLE','ESE','TOL-056hhh-lll-sss',1,1.00,'2019-01-21','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-058hhh-lll-sss',1,'VERANDA GIOTTO PLUS','ESE','TOL-059hhh-lll-sss',1,1.00,'2019-01-21','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-059hhh-lll-sss',1,'TOLDO VERANDA  MITJAVILA','ESE','TOL-XXXhhh-lll-sss',1,1.00,'2019-01-21','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-061hhh-lll-sss',1,'VERANDA EOS','ESE','TOL-001hhh-lll-sss',1,1.00,'2019-01-21','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-062hhh-lll-sss',1,'VERANDA EOS COMPLET','ESE','TOL-061hhh-lll-sss',1,1.00,'2019-01-21','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-063hhh-lll-sss',1,'VERANDA ZIP ECLIPSE 130','ESE','V-036hhh-lll-sss',1,1.00,'2018-01-10','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-064hhh-lll-sss',1,'Veranda Eclipse 130 Plus','ESE','TOL-063hhh-lll-sss',1,1.00,'2019-01-22','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-065hhh-lll-sss',1,'VERANDA ZIP HERA','ESE','TOL-061hhh-lll-sss',1,1.00,'2020-04-25','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-066hhh-lll-sss',1,'Veranda Frame','ESE','TOL-063hhh-lll-sss',1,1.00,'2019-05-22','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-067hhh-lll-sss',1,'Veranda Sirio','ESE','TOL-065hhh-lll-sss',1,1.00,'2024-03-19','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-081hhh-lll-sss',1,'Bambalina Led','ESE','TOL-001hhh-lll-sss',1,1.00,'2022-11-28','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-100hhh-lll-sss',1,'','ESE','TOL-001hhh-lll-sss',1,1.00,'2015-02-06','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-101hhh-lll-sss',1,'CORREDERO MINIGUIA 40X40\r\n','ESE','TOL-001hhh-lll-sss',1,1.00,'2015-02-13','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-102hhh-lll-sss',1,'','ESE','TOL-101hhh-lll-sss',1,1.00,'2015-02-13','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-103hhh-lll-sss',1,'','ESE','TOL-102hhh-lll-sss',1,1.00,'2015-02-13','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-104hhh-lll-sss',1,'','ESE','TOL-103hhh-lll-sss',1,1.00,'2015-02-13','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-105hhh-lll-sss',1,'','ESE','TOL-103hhh-lll-sss',1,1.00,'2015-02-13','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-106hhh-lll-sss',1,'','ESE','TOL-104hhh-lll-sss',1,1.00,'2015-02-13','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-110hhh-lll-sss',1,'ZEN Nº1 ENTRE PAREDES','ESE','TOL-102hhh-lll-sss',1,1.00,'2015-02-13','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-111hhh-lll-sss',1,'','ESE','TOL-110hhh-lll-sss',1,1.00,'2015-02-17','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-112hhh-lll-sss',1,'CORREDERO ZEN Nº8 1 PORT. + REF. RIGIDO','ESE','TOL-114hhh-lll-sss',1,1.00,'2016-01-08','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-113hhh-lll-sss',1,'CORREDERO ZEN Nº 10 2 PORTERIAS','ESE','TOL-111hhh-lll-sss',1,1.00,'2015-02-17','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-114hhh-lll-sss',1,'','ESE','TOL-115hhh-lll-sss',1,1.00,'2015-02-17','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-115hhh-lll-sss',1,'','ESE','TOL-111hhh-lll-sss',1,1.00,'2015-02-17','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-116hhh-lll-sss',1,'','ESE','TOL-110hhh-lll-sss',1,1.00,'2015-02-17','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-117hhh-lll-sss',1,'CORREDERO ZEN Nº 2 ENTRE PAREDES CON INCLINACION','ESE','TOL-110hhh-lll-sss',1,1.00,'2016-01-07','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-118hhh-lll-sss',1,'CORREDERO ZEN Nº5  1PORT. CAPITEL','ESE','TOL-116hhh-lll-sss',1,1.00,'2016-01-07','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-119hhh-lll-sss',1,'CORREDERO ZEN 1 PORT. INCLINACION','ESE','TOL-115hhh-lll-sss',1,1.00,'2016-01-08','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-1209006-500-550',1,'','ESE','',0,1.00,'2016-11-10','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-120hhh-lll-sss',1,'CORREDERO ZEN Nº7 1PORT. CAPITEL/INCLINACION','ESE','TOL-118hhh-lll-sss',1,1.00,'2016-01-08','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-121hhh-lll-sss',1,'CORREDERO ZEN Nº11 2PORT.CAPITEL SUPERIOR','ESE','TOL-116hhh-lll-sss',1,1.00,'2016-01-08','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-122hhh-lll-sss',1,'CORREDERO ZEN Nº12  2PORT. INTERIOR','ESE','TOL-118hhh-lll-sss',1,1.00,'2016-01-08','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-123hhh-lll-sss',1,'Corredero Clima 120x120 IP','ESE','Tol-140hhh-lll-sss',1,1.00,'2020-04-15','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-124hhh-lll-sss',1,'Corredero Clima 120x120 1 Porteria','ESE','TOL-141hhh-lll-sss',1,1.00,'2020-04-15','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-125hhh-lll-sss',1,'Corredero Clima 120x120 1P+RP','ESE','TOL-142hhh-lll-sss',1,1.00,'2020-04-15','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-126hhh-lll-sss',1,'Clima 120x120 2 porterias','ESE','TOL-143hhh-lll-sss',1,1.00,'2020-04-15','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-1270004-550-650',1,'','ESE','',0,1.00,'2016-11-03','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-1277016-700-400',1,'','ESE','',0,1.00,'2016-11-03','SETUP','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-127hhh-lll-sss',1,'Corredero Clima 120x120 2P + RP','ESE','TOL-144hhh-lll-sss',1,1.00,'2020-04-15','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-135hhh-lll-sss',2,'CORREDERO SFERIC 90 X 96 I.P.','ESE','TOL-102hhh-lll-sss',1,1.00,'2017-11-22','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-136hhh-lll-sss',1,'CORREDERO SFERIC 90 X 96 1 PORTERIA','ESE','TOL-103hhh-lll-sss',1,1.00,'2017-11-22','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-137hhh-lll-sss',1,'CORREDERO SFERIC 90 X 96 1 PORTERIA. + REF. PERI.','ESE','TOL-104hhh-lll-sss',1,1.00,'2017-11-22','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-138hhh-lll-sss',1,'CORREDERO SFERIC 90 X 96 2 PORTERIAS','ESE','TOL-105hhh-lll-sss',1,1.00,'2017-11-22','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-139hhh-lll-sss',1,'CORREDERO SFERIC 90 X 96 2 PORTERIAS + REF.PER','ESE','TOL-106hhh-lll-sss',1,1.00,'2017-11-22','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('Tol-140hhh-lll-sss',1,'CORREDERO 125 X 125 I.P.','ESE','TOL-135hhh-lll-sss',2,1.00,'2017-12-11','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-141hhh-lll-sss',1,'CORREDERO 125 X 125 1 PORT.','ESE','TOL-136hhh-lll-sss',1,1.00,'2017-12-11','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-142hhh-lll-sss',1,'\r\n','ESE','TOL-137hhh-lll-sss',1,1.00,'2017-12-11','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-143hhh-lll-sss',1,'CORREDERO 125 X 125 2 PORT.','ESE','TOL-138hhh-lll-sss',1,1.00,'2017-12-11','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-144hhh-lll-sss',1,'CORREDERO 125 X 125 2 PORT. + REF.PER.','ESE','TOL-139hhh-lll-sss',1,1.00,'2017-12-11','ELI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-145hhh-lll-sss',1,'ZEN RAIN ENTRE PAREDES','ESE','TOL-147hhh-lll-sss',1,1.00,'2018-05-31','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-147hhh-lll-sss',1,'','ESE','TOL-115hhh-lll-sss',1,1.00,'2018-05-30','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-148hhh-lll-sss',1,'ZEN RAIN 1 PORTERIA MODULO.DOBLE','ESE','TOL-147hhh-lll-sss',1,1.00,'2018-09-26','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-155hhh-lll-sss',1,'Corredero de Ondas 80x40 IP Motorizado','ESE','TOL-102hhh-lll-sss',1,1.00,'2021-01-19','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('tol-156hhh-lll-sss',1,'CORREDERO ONDAS 1 Port. 80X40 MOTORIZADO','ESE','TOL-155hhh-lll-sss',1,1.00,'2021-01-20','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-157hhh-lll-sss',1,'CORREDERO DE ONDAS 1 Port.+RP MOTORIZADO','ESE','tol-156hhh-lll-sss',1,1.00,'2021-01-21','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-158hhh-lll-sss',2,'CORREDERO DE ONDAS 2P 80X40 MOTORIZADO','ESE','tol-156hhh-lll-sss',1,2.00,'2021-01-21','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-159hhh-lll-sss',1,'CORREDERO ONDAS (2Port.+RP) 80X40 MOTORIZADO','ESE','TOL-158hhh-lll-sss',2,1.00,'2021-01-21','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-161hhh-lll-sss',1,'Corredero Cable','ESE','tol-156hhh-lll-sss',1,1.00,'2024-07-25','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-200hhh-lll-sss',1,'TOLDO B.I. CITY CON LEDS','ESE','TOL-051hhh-lll-sss',1,1.00,'2020-10-28','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-202hhh-lll-sss',1,'COFRE ARES CON LEDS EN BRAZOS','ESE','TOL-026hhh-lll-sss',1,1.00,'2021-01-21','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-206hhh-lll-sss',1,'COFRE ALAND CON LEDS EN BRAZOS CONCEPT','ESE','TOL-046hhh-lll-sss',1,1.00,'2021-01-22','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-207hhh-lll-sss',1,'COFRE ALAND CON LEDS EN BRAZOS Y CAJON','ESE','TOL-206hhh-lll-sss',1,1.00,'2021-01-25','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('TOL-209hhh-lll-sss',1,'COFRE ARKO CON LEDS EN CAJON','ESE','TOL-038hhh-lll-sss',1,1.00,'2021-01-25','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('V-030hhh-lll-sss',1,'VERTICAL CABLE MINI','ESE','TOL-001hhh-lll-sss',1,1.00,'2018-05-15','XAVI','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('V-031hhh-lll-sss',1,'','ESE','V-030hhh-lll-sss',1,1.00,'2015-03-02','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('V-032hhh-lll-sss',1,'VERTICAL VARILLA XL','ESE','V-031hhh-lll-sss',1,1.00,'2015-11-18','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('V-033hhh-lll-sss',1,'VERTICAL CABLE BOX','ESE','V-034hhh-lll-sss',1,1.00,'2016-01-08','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('V-034hhh-lll-sss',1,'VERTICAL VARILLA BOX','ESE','V-032hhh-lll-sss',1,1.00,'2016-01-08','JORD','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('V-035hhh-lll-sss',1,'VERTICAL CORTAVIENTO','ESE','TOL-001hhh-lll-sss',1,1.00,'2015-01-30','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('V-036hhh-lll-sss',1,'VERTICAL SCREEN ZIP 100','ESE','V-048hhh-lll-sss',1,1.00,'2021-03-31','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('V-037hhh-lll-sss',1,'VERTICAL SCREEN ZIP 130','ESE','V-036hhh-lll-sss',1,1.00,'2019-01-21','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('V-038hhh-lll-sss',1,'VERTICAL PARAVENTO BOX ','ESE','V-035hhh-lll-sss',1,1.00,'2017-10-24','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('V-039hhh-lll-sss',1,'VERTICAL CABLE SUPERIOR','ESE','V-030hhh-lll-sss',1,1.00,'2017-02-06','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('V-040hhh-lll-sss',1,'VERTICAL CORTAVIENTO + PERFILES REFUERZO','ESE','V-035hhh-lll-sss',1,1.00,'2016-10-26','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('V-043hhh-lll-sss',1,'VERTICAL NIMBUS VARILLA','ESE','V-032hhh-lll-sss',1,1.00,'2021-03-31','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('V-044hhh-lll-sss',1,'Vertical Nimbus Varilla Box','ESE','V-034hhh-lll-sss',1,1.00,'2021-03-31','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('V-044hhh-lll-sss',2,'Vertical Nimbus Box Cable','ESE','V-033hhh-lll-sss',1,2.00,'2021-03-31','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('V-045hhh-lll-sss',2,'VERTICAL CAIDA LIBRE','ESE','V-035hhh-lll-sss',1,2.00,'2018-10-09','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('V-046hhh-lll-sss',1,'VERTICAL VERTIKO (BITOLDO)','ESE','V-030hhh-lll-sss',1,1.00,'2017-12-11','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('V-048hhh-lll-sss',1,'vertical screen zip 100 guia estrecha','ESE','V-036hhh-lll-sss',1,1.00,'2018-07-31','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('V-049hhh-lll-sss',1,'VERTICAL IGLOO','ESE','V-038hhh-lll-sss',2,1.00,'2019-03-18','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('V-050hhh-lll-sss',1,'Vertical Nimbus Cable','ESE','V-031hhh-lll-sss',1,1.00,'2021-03-31','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('V-052hhh-lll-sss',1,'Vertical Nexus 80 Guia','ESE','V-049hhh-lll-sss',1,1.00,'2021-03-31','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('V-053hhh-lll-sss',1,'Vertical Nexus 80 Guia-Cable','ESE','V-049hhh-lll-sss',1,1.00,'2021-03-31','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('V-054hhh-lll-sss',1,'Vertical Nexus 80 Guia Zip Estrecha','ESE','V-036hhh-lll-sss',1,1.00,'2021-03-31','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('V-055hhh-lll-sss',1,'Vertical Nexus 100 Guia','ESE','V-049hhh-lll-sss',1,1.00,'2021-03-31','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('V-056hhh-lll-sss',1,'Vertical Nexus 100 Guia Cable','ESE','V-049hhh-lll-sss',1,1.00,'2021-03-31','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('V-057hhh-lll-sss',1,'Veretical Nexus 100 Guia Zip Ancha','ESE','V-036hhh-lll-sss',1,1.00,'2021-03-31','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('V-058hhh-lll-sss',1,'Vertical Nexus 130 Guia','ESE','V-049hhh-lll-sss',1,1.00,'2021-03-31','AGUS','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0),('V-060hhh-lll-sss',1,'Vertical Nexus 130 Guia Cable','ESE','V-060hhh-lll-sss',2,3.00,'2023-04-18','SETUP','',0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,'',0,1,'',0);
/*!40000 ALTER TABLE `promstru` 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:57
