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

DROP TABLE IF EXISTS `cialinmo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cialinmo` (
  `id_cialinmo` int(11) NOT NULL DEFAULT '0' COMMENT 'Id inmovilizado',
  `descripcion` text NOT NULL COMMENT 'Descripción',
  `desc_amplia` text NOT NULL COMMENT 'Descripción ampliada',
  `sw_estado` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Estado',
  `sw_multiple` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Ficha múltiple',
  `fecha_no_activa` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Fecha desactivada',
  `id_cialinmogru` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Grupo amortización',
  `num_anyos_meses` decimal(6,2) NOT NULL DEFAULT '0.00' COMMENT 'Años/meses duración',
  `tpc_tabla` decimal(6,2) NOT NULL DEFAULT '0.00' COMMENT '% amortización tabla',
  `ind_corrector` decimal(6,2) NOT NULL DEFAULT '0.00' COMMENT 'Índice corrector',
  `tpc_anual` decimal(6,2) NOT NULL DEFAULT '0.00' COMMENT '% amortización anual',
  `num_anyos` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Años enteros',
  `num_meses` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Meses residuo',
  `sw_calculo` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'Tipo cálculo',
  `sw_ind_corrector` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'Índ.correc.automático <br>en base decreciente',
  `cod_cuenta_activo` char(12) NOT NULL DEFAULT '' COMMENT 'Cuenta activo',
  `orden` int(11) NOT NULL DEFAULT '0' COMMENT 'Nº de orden',
  `suborden` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Nº de suborden',
  `cod_cuenta_pasivo` char(12) NOT NULL DEFAULT '' COMMENT 'Cuenta pasivo',
  `cod_cuenta_amortiza` char(12) NOT NULL DEFAULT '' COMMENT 'Cuenta amortización',
  `id_cialceco` int(11) NOT NULL DEFAULT '0' COMMENT 'Centro de coste',
  `cod_cuenta_prov` char(12) NOT NULL DEFAULT '' COMMENT 'Proveedor',
  `nom_prov_diverso` text NOT NULL COMMENT 'Proveedor diverso',
  `su_documento` varchar(250) NOT NULL DEFAULT '' COMMENT 'Documento',
  `fecha_entrada` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Fecha entrada',
  `fecha_factura` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Fecha factura',
  `cod_moneda` char(3) NOT NULL DEFAULT 'EUR' COMMENT 'Moneda',
  `cambio_euro` decimal(18,9) NOT NULL DEFAULT '1.000000000' COMMENT 'Euros 1 Divisa',
  `imp_compra_mone` decimal(15,2) NOT NULL DEFAULT '0.00' COMMENT 'Importe compra',
  `imp_compra_euro` decimal(15,2) NOT NULL DEFAULT '0.00' COMMENT 'Imp. compra Eur',
  `imp_instala_mone` decimal(15,2) NOT NULL DEFAULT '0.00' COMMENT 'Importe instalación',
  `imp_instala_euro` decimal(15,2) NOT NULL DEFAULT '0.00' COMMENT 'Imp. instalación Eur',
  `imp_accesorio_mone` decimal(15,2) NOT NULL DEFAULT '0.00' COMMENT 'Importe accesorios',
  `imp_accesorio_euro` decimal(15,2) NOT NULL DEFAULT '0.00' COMMENT 'Imp. accesorios Eur',
  `f_soporte` char(2) NOT NULL DEFAULT '' COMMENT 'Tipo',
  `f_canal` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Canal',
  `f_cod_serie` char(3) NOT NULL DEFAULT '' COMMENT 'Serie',
  `f_anyo` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Año',
  `f_numero` int(11) NOT NULL DEFAULT '0' COMMENT 'Nº fra/iva',
  `f_id_cocabe` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Factura orígen',
  `f_linea_cont` int(11) NOT NULL DEFAULT '0' COMMENT 'Línea',
  `id_tenant` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Nº empresa',
  `f_linea_inmo` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Sublínea contabilización',
  UNIQUE KEY `key0` (`id_tenant`,`id_cialinmo`),
  KEY `key1` (`id_tenant`,`cod_cuenta_activo`,`orden`,`suborden`),
  KEY `key2` (`id_tenant`,`f_id_cocabe`,`f_linea_cont`,`f_linea_inmo`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `cialinmo` WRITE;
/*!40000 ALTER TABLE `cialinmo` DISABLE KEYS */;
INSERT INTO `cialinmo` (`id_cialinmo`, `descripcion`, `desc_amplia`, `sw_estado`, `sw_multiple`, `fecha_no_activa`, `id_cialinmogru`, `num_anyos_meses`, `tpc_tabla`, `ind_corrector`, `tpc_anual`, `num_anyos`, `num_meses`, `sw_calculo`, `sw_ind_corrector`, `cod_cuenta_activo`, `orden`, `suborden`, `cod_cuenta_pasivo`, `cod_cuenta_amortiza`, `id_cialceco`, `cod_cuenta_prov`, `nom_prov_diverso`, `su_documento`, `fecha_entrada`, `fecha_factura`, `cod_moneda`, `cambio_euro`, `imp_compra_mone`, `imp_compra_euro`, `imp_instala_mone`, `imp_instala_euro`, `imp_accesorio_mone`, `imp_accesorio_euro`, `f_soporte`, `f_canal`, `f_cod_serie`, `f_anyo`, `f_numero`, `f_id_cocabe`, `f_linea_cont`, `id_tenant`, `f_linea_inmo`) VALUES (1,'NAVE INDUSTRIAL','',2,0,'2024-01-01',0,0.00,3.00,0.00,3.00,33,4,1,1,'211000001',1,1,'281100001','681000000',0,'410000206','PARICUTI, S.L.','','2006-07-01','2006-07-01','EUR',1.000000000,347000.07,347000.07,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,1),(2,'NAVE INDUSTRIAL (COMISION)','',2,0,'2024-01-01',0,0.00,3.00,0.00,3.00,33,4,1,1,'211000002',1,1,'281100002','681000000',0,'410000203','ESTEBAN BACH SERRA','','2007-01-01','2007-01-01','EUR',1.000000000,189617.37,189617.37,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,2),(3,'GUIAS BILATERALES','',0,0,'0000-00-00',0,0.00,10.00,0.00,10.00,10,0,1,1,'212000001',1,1,'281200001','681000000',0,'410000232','MANUTAN, S.L.','','2006-04-01','2006-04-01','EUR',1.000000000,7437.73,7437.73,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,3),(4,'TRONZADORA','MG',0,0,'0000-00-00',0,0.00,16.66,0.00,16.66,6,1,1,1,'213000005',1,1,'281300005','681000000',0,'410999999','ACREEDORES VARIOS','','2002-03-25','2002-03-25','EUR',1.000000000,5470.56,5470.56,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,4),(5,'COMPRESOR Y CALDERA','',0,0,'0000-00-00',0,0.00,16.66,0.00,16.66,6,1,1,1,'213000006',1,1,'281300006','681000000',0,'410999999','ACREEDORES VARIOS','','2002-04-25','2002-04-25','EUR',1.000000000,4373.94,4373.94,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,5),(6,'MAQUINA UNION TALLAS CABEZAL MOVIL 6M','MATIC',0,0,'0000-00-00',0,0.00,16.66,0.00,16.66,6,1,1,1,'213000007',1,1,'281300007','681000000',0,'410000020','MATIC, S.A.','','2003-02-01','2003-02-01','EUR',1.000000000,37547.30,37547.30,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,6),(7,'BASCULA','EP-35VD',0,0,'0000-00-00',0,0.00,16.66,0.00,16.66,6,1,1,1,'213000008',1,1,'281300008','681000000',0,'410000080','EURO-PESAJE, S.L.','','2002-12-20','2002-12-20','EUR',1.000000000,579.50,579.50,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,7),(8,'TERMOSELLADORA','420 MAG',0,0,'0000-00-00',0,0.00,16.66,0.00,16.66,6,1,1,1,'213000009',1,1,'281300009','681000000',0,'410000108','ROVEBLOC, S.A.','','2003-10-03','2003-10-03','EUR',1.000000000,722.65,722.65,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,8),(9,'MAQUINA AUTOMATICA','E 0346070',0,0,'0000-00-00',0,0.00,16.66,0.00,16.66,6,1,1,1,'213000010',1,1,'281300010','681000000',0,'410000119','QUERO EXPORT, S.A.','','2003-12-01','2003-12-01','EUR',1.000000000,2415.42,2415.42,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,9),(10,'MAQUINA SOLDAR PLASTICO ALTA FRECUENCIA','SN-2.5',0,0,'0000-00-00',0,0.00,16.66,0.00,16.66,6,1,1,1,'213000011',1,1,'281300011','681000000',0,'410000121','AEM, S.A.','','2003-12-20','2003-12-20','EUR',1.000000000,17925.00,17925.00,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,10),(11,'MAQUINA','767-FAS-573 RAP HP',1,0,'2013-05-27',0,0.00,12.00,0.00,12.00,8,4,1,1,'213000012',1,1,'281300012','681000000',0,'410000020','MATIC, S.A.','','2004-12-22','2004-12-22','EUR',1.000000000,9845.10,9845.10,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,11),(12,'TERMOSELLADORA','420 MAG',0,0,'0000-00-00',0,0.00,12.00,0.00,12.00,8,4,1,1,'213000013',1,1,'281300013','681000000',0,'410000108','ROVEBLOC, S.A.','','2004-09-28','2004-09-28','EUR',1.000000000,760.00,760.00,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,12),(13,'SIERRA CINTA MANUAL','M',0,0,'0000-00-00',0,0.00,12.00,0.00,12.00,8,4,1,1,'213000014',1,1,'281300014','681000000',0,'410000162','BDA. MAQUINARIA, S.L.','','2004-11-12','2004-11-12','EUR',1.000000000,1848.53,1848.53,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,13),(14,'APILADOR','0256',0,0,'0000-00-00',0,0.00,12.00,0.00,12.00,8,4,1,1,'213000017',1,1,'281300017','681000000',0,'410000195','CARRETILLAS TERRASSA, S.L.','','2006-11-21','2006-11-21','EUR',1.000000000,3390.00,3390.00,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,14),(15,'MAQUINA JOVER','',0,0,'0000-00-00',0,0.00,12.00,0.00,12.00,8,4,1,1,'213000018',1,1,'281300018','681000000',0,'410000292','S.P. JOVER, S.L.','','2007-04-01','2007-04-01','EUR',1.000000000,8822.00,8822.00,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,15),(16,'MAQUINA SOLDADURA','913',0,0,'0000-00-00',0,0.00,12.00,0.00,12.00,8,4,1,1,'213000020',1,1,'281300020','681000000',0,'410000283','RAPIDA SISTEMAS INTEGRALES, SA','1002822','2007-05-23','2007-05-23','EUR',1.000000000,82104.00,82104.00,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,16),(17,'MAQUINAS VARIAS LEASING BCO. SABADELL','VARIAS',0,0,'0000-00-00',0,0.00,12.00,0.00,12.00,8,4,1,1,'213000021',1,1,'281300021','681000009',0,'410999999','ACREEDORES VARIOS','','2006-04-01','2006-04-01','EUR',1.000000000,73726.13,73726.13,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,17),(18,'RESTO MAQUINAS LEASING BCO.SABADELL','',0,0,'0000-00-00',0,0.00,12.00,0.00,12.00,8,4,1,1,'213000022',1,1,'281300022','681000009',0,'410999999','ACREEDORES VARIOS','','2007-01-01','2007-01-01','EUR',1.000000000,1349.68,1349.68,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,18),(19,'MAQUINA AERONAUT','',0,0,'0000-00-00',0,0.00,12.00,0.00,12.00,8,4,1,1,'213000023',1,1,'281300023','681000000',0,'410999999','ACREEDORES VARIOS','','2008-01-01','2008-01-01','EUR',1.000000000,69228.00,69228.00,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,19),(20,'DISPOSITIVO DE CORTE','SCREEN',0,0,'0000-00-00',0,0.00,12.00,0.00,12.00,8,4,1,1,'213000024',1,1,'281300024','681000000',0,'410000110','SCREEN PROTECTORS, S,L.','30747','2008-12-18','2008-12-18','EUR',1.000000000,9500.00,9500.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',0,1990,3100000210001990,1,1,1),(21,'MAQUINA COSER','KDD-4620H-30-BT/FL/PT',0,0,'0000-00-00',0,0.00,12.00,0.00,12.00,8,4,1,1,'213000025',1,1,'281300025','681000000',0,'410000385','EMILIO GARCIA NAVARRO','690','2010-05-14','2010-05-04','EUR',1.000000000,6500.00,6500.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',0,498,3100000210000498,1,1,1),(22,'HERRAMIENTA RECIPRO BAYONET','',0,0,'0000-00-00',0,0.00,12.00,0.00,12.00,8,4,1,1,'213000026',1,1,'281300026','681000000',0,'410000330','RANDIX TECHNOLOGY, S.L.','20076','2010-12-31','2010-12-09','EUR',1.000000000,2918.61,2918.61,0.00,0.00,0.00,0.00,'FC',1,'SOP',0,1310,3100000210001310,1,1,1),(23,'TRITURADOR INODORO','SANIBES',0,0,'0000-00-00',0,0.00,12.00,0.00,12.00,8,4,1,1,'213000028',1,1,'281300028','681000000',0,'410000220','MIQUEL CAMPS, S.A.','63','2013-02-21','2013-02-08','EUR',1.000000000,926.46,926.46,0.00,0.00,0.00,0.00,'FC',1,'SOP',0,151,3100000210000151,1,1,1),(24,'Nº SERIE 00334','STATION A665',0,0,'0000-00-00',0,0.00,12.00,0.00,12.00,8,4,1,1,'213000029',1,1,'281300029','681000000',0,'410000452','LUISA OLIVARES ROBLES','13/0001','2013-01-28','2013-01-28','EUR',1.000000000,2543.46,2543.46,0.00,0.00,0.00,0.00,'FC',1,'SOP',0,198,3100000210000198,1,1,1),(25,'MAQUINA ARES','5000 PLUS',0,0,'0000-00-00',0,0.00,12.00,0.00,12.00,8,4,1,1,'213000030',1,1,'281300030','681000000',0,'410000020','MATIC, S.A.','13/000498','2013-04-18','2013-04-16','EUR',1.000000000,41600.00,41600.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',0,317,3100000210000317,1,1,1),(26,'DURKOPP ADLER AG','TYPE 0767 9900016 767-FA-273',0,0,'0000-00-00',0,0.00,12.00,0.00,12.00,8,4,1,1,'213000031',1,1,'281300031','681000000',0,'410000452','LUISA OLIVARES ROBLES','13/0001','2013-01-28','2013-01-28','EUR',1.000000000,1300.00,1300.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',0,198,3100000210000198,2,1,1),(27,'BROTHER','REF. T-8722-405',0,0,'0000-00-00',0,0.00,12.00,0.00,12.00,8,4,1,1,'213000032',1,1,'281300032','681000000',0,'410000452','LUISA OLIVARES ROBLES','13/0001','2013-03-06','2013-01-28','EUR',1.000000000,1500.00,1500.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',0,198,3100000210000198,3,1,1),(28,'MAQUINA REMACHADORA JOVER','28F 4646',0,0,'0000-00-00',0,0.00,12.00,0.00,12.00,8,4,1,1,'213000033',1,1,'281300033','681000000',0,'410000452','LUISA OLIVARES ROBLES','13/0001','2013-03-06','2013-01-28','EUR',1.000000000,1300.00,1300.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',0,198,3100000210000198,4,1,1),(29,'MAQUINA SERRACINTA ESPECIAL','SERIE 57500',0,0,'0000-00-00',0,0.00,12.00,0.00,12.00,8,4,1,1,'213000034',1,1,'281300034','681000000',0,'410000452','LUISA OLIVARES ROBLES','13/0001','2013-03-06','2013-01-28','EUR',1.000000000,500.00,500.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',0,198,3100000210000198,5,1,1),(30,'MAQUINA COSER MATIC 2 AGUJAS','2 AGUJAS SEMIAUTOMATICAS',0,0,'0000-00-00',0,0.00,12.00,0.00,12.00,8,4,1,1,'213000035',1,1,'281300035','681000000',0,'410000452','LUISA OLIVARES ROBLES','13/0001','2013-03-06','2013-01-28','EUR',1.000000000,207.00,207.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',0,198,3100000210000198,6,1,1),(31,'MAQUINA COSER GLOBAL','1 AGUJA',1,0,'2013-05-27',0,0.00,12.00,0.00,12.00,8,4,1,1,'213000036',1,1,'281300036','681000000',0,'410000452','LUISA OLIVARES ROBLES','13/0001','2013-03-06','2013-01-28','EUR',1.000000000,207.00,207.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',0,198,3100000210000198,7,1,1),(32,'MAQUINA COSER 1 AGUJA MACARRON','D467',0,0,'0000-00-00',0,0.00,12.00,0.00,12.00,8,4,1,1,'213000037',1,1,'281300037','681000000',0,'410000452','LUISA OLIVARES ROBLES','13/0001','2013-03-06','2013-01-28','EUR',1.000000000,207.00,207.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',0,198,3100000210000198,8,1,1),(33,'MAQUINA TRONZADORA ALUMINIO','TN-350',0,0,'0000-00-00',0,0.00,12.00,0.00,12.00,8,4,1,1,'213000038',1,1,'281300038','681000000',0,'410000452','LUISA OLIVARES ROBLES','13/0001','2013-03-06','2013-01-28','EUR',1.000000000,500.00,500.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',0,198,3100000210000198,9,1,1),(34,'MAQUINA SOLDADURA','',0,0,'0000-00-00',0,0.00,12.00,0.00,12.00,8,4,1,1,'213000040',1,1,'281300040','681000000',0,'524000003','LEASING LA CAIXA','','2015-01-01','2014-12-11','EUR',1.000000000,57945.00,57945.00,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,20),(35,'EMBOLICADORA ORBITAL','NELEO 50',0,0,'0000-00-00',0,0.00,12.00,0.00,12.00,8,4,1,1,'213000041',1,1,'281300041','681000000',0,'410000240','PLASTICBAND, S.A.','114617','2015-04-20','2015-04-20','EUR',1.000000000,4445.00,4445.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',0,545,3100000210000545,1,1,1),(36,'SISTEMA AIRE CALIENTE COMPLETO','',0,0,'0000-00-00',0,0.00,12.00,0.00,12.00,8,4,1,1,'213000042',1,1,'281300042','681000000',0,'410000428','J.PUJOL MAQ.CONF., S.A.','16000227','2016-03-01','2016-02-29','EUR',1.000000000,8937.00,8937.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',0,224,3100000210000224,1,1,1),(37,'MOLDES SOPORTE Y ROTULA REG.','',0,0,'0000-00-00',0,0.00,10.00,0.00,10.00,10,0,1,1,'214000001',1,1,'281400001','681000000',0,'410000129','M.C.C.96','','2004-03-19','2004-03-19','EUR',1.000000000,10277.31,10277.31,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,21),(38,'MOLDE SOPORTE ALETAS','',0,0,'0000-00-00',0,0.00,10.00,0.00,10.00,10,0,1,1,'214000002',1,1,'281400002','681000000',0,'410000129','M.C.C.96','','2004-04-25','2004-04-25','EUR',1.000000000,4148.00,4148.00,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,22),(39,'MATRICES','',0,0,'0000-00-00',0,0.00,33.00,0.00,33.00,3,1,1,1,'214000003',1,1,'281400003','681000000',0,'400000396','EXTRUSIONES DE TOLEDO, S.A.','300014758','2010-12-31','2010-12-31','EUR',1.000000000,6700.00,6700.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',0,1303,3100000210001303,1,1,1),(40,'CLIMATIZACION OFICINA','AIR TENA',0,0,'0000-00-00',0,0.00,12.00,0.00,12.00,8,4,1,1,'215000001',1,1,'281500001','681000000',0,'410000238','AIR TENA 2004, S.L.U.','','2006-04-01','2006-04-01','EUR',1.000000000,2949.00,2949.00,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,23),(41,'INSTALACION ELECTRICA NAVE INDUSTRIAL','',0,0,'0000-00-00',0,0.00,7.00,0.00,7.00,14,4,1,1,'215000002',1,1,'281500002','681000000',0,'410000220','MIQUEL CAMPS, S.A.','','2006-07-01','2006-07-01','EUR',1.000000000,74767.53,74767.53,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,24),(42,'SISTEMA DE SEGURIDAD','TRANSMITEL',0,0,'0000-00-00',0,0.00,12.00,0.00,12.00,8,4,1,1,'215000003',1,1,'281500003','681000000',0,'410000248','TRANSMITEL, S.L.','','2006-07-01','2006-07-01','EUR',1.000000000,1241.88,1241.88,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,25),(43,'CLIMATIZACION OFICINA RECEPCION NAVE','INVERTER',0,0,'0000-00-00',0,0.00,12.00,0.00,12.00,8,4,1,1,'215000004',1,1,'281500004','681000000',0,'410000238','AIR TENA 2004, S.L.U.','','2007-01-01','2007-01-01','EUR',1.000000000,1868.00,1868.00,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,26),(44,'DESCALCIFICADOR','OLYMPIA',0,0,'0000-00-00',0,0.00,12.00,0.00,12.00,8,4,1,1,'215000005',1,1,'281500005','681000000',0,'410000453','CORSA','BV1300106','2013-03-22','2013-02-28','EUR',1.000000000,2441.79,2441.79,0.00,0.00,0.00,0.00,'FC',1,'SOP',0,231,3100000210000231,1,1,1),(45,'ORDENADORES IBM','IBM',0,0,'0000-00-00',0,0.00,25.00,0.00,25.00,4,0,1,1,'216000011',1,1,'281600011','681000000',0,'410000039','AIDA SET, S.C.C.L.','','2004-07-05','2004-07-05','EUR',1.000000000,5351.00,5351.00,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,27),(46,'ORDENADOR IBM + MONITOR','IBM',0,0,'0000-00-00',0,0.00,25.00,0.00,25.00,4,0,1,1,'216000013',1,1,'281600013','681000000',0,'410000039','AIDA SET, S.C.C.L.','','2004-09-01','2004-09-01','EUR',1.000000000,1200.00,1200.00,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,28),(47,'MOBILIARIO NAVE','',0,0,'0000-00-00',0,0.00,10.00,0.00,10.00,10,0,1,1,'216000015',1,1,'281600015','681000000',0,'410000040','ROJOUR MUEBLES, S.L.','','2006-07-01','2006-07-01','EUR',0.000000000,15970.09,15970.09,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,29),(48,'INSTALACION NAVE AIDA','',0,0,'0000-00-00',0,0.00,25.00,0.00,25.00,4,0,1,1,'216000017',1,1,'281600017','681000000',0,'410000039','AIDA SET, S.C.C.L.','','2006-07-01','2006-07-01','EUR',1.000000000,8615.00,8615.00,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,30),(49,'SISTEMA LECTOR','9535',0,0,'0000-00-00',0,0.00,25.00,0.00,25.00,4,0,1,1,'216000018',1,1,'281600018','681000000',0,'410000039','AIDA SET, S.C.C.L.','FAC 297','2007-07-01','2007-04-26','EUR',1.000000000,4959.00,4959.00,0.00,0.00,0.00,0.00,'FC',1,'RBI',0,3,3100000320000003,1,1,1),(50,'SAI','MEGALINE 4',0,0,'0000-00-00',0,0.00,25.00,0.00,25.00,4,0,1,1,'216000019',1,1,'281600019','681000000',0,'410000039','AIDA SET, S.C.C.L.','FAC 340','2007-07-01','2007-05-21','EUR',1.000000000,1562.57,1562.57,0.00,0.00,0.00,0.00,'FC',1,'RBI',0,4,3100000320000004,1,1,1),(51,'CONTROL DE PRESENCIA','',0,0,'0000-00-00',0,0.00,25.00,0.00,25.00,4,0,1,1,'217000100',1,1,'281700100','681000000',0,'410000236','J&B ENGINEERING GROUP, S.L.','','2006-04-01','2006-04-01','EUR',1.000000000,1047.60,1047.60,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,31),(52,'CONTROL GSM FURGONETAS','FAGOR',0,0,'0000-00-00',0,0.00,25.00,0.00,25.00,4,0,1,1,'217000101',1,1,'281700101','681000000',0,'410000291','FAGOR ELECTRONICA, S.COOP.','','2007-04-01','2007-04-01','EUR',1.000000000,2249.25,2249.25,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,32),(53,'FOTOCOPIADORA','AFICIO MP161',0,0,'0000-00-00',0,0.00,25.00,0.00,25.00,4,0,1,1,'217000102',1,1,'281700102','681000000',0,'410000079','RICOH ESPAÑA, S.A.','1275236','2007-11-09','2007-11-09','EUR',1.000000000,1186.12,1186.12,0.00,0.00,0.00,0.00,'FC',1,'RBI',0,5,3100000320000005,1,1,1),(54,'ORDENADOR PORTATIL','PAVILION DV7-1250/AMD X2',0,0,'0000-00-00',0,0.00,25.00,0.00,25.00,4,0,1,1,'217000103',1,1,'281700103','681000000',0,'410000161','EL CORTE INGLES, S.A.','0909005566','2009-06-05','2009-06-05','EUR',1.000000000,610.26,610.26,0.00,0.00,0.00,0.00,'FC',1,'SOP',0,654,3100000210000654,1,1,1),(55,'ORDINADOR','PRO 6005',0,0,'0000-00-00',0,0.00,25.00,0.00,25.00,4,0,1,1,'217000104',1,1,'281700104','681000000',0,'410000039','AIDA SET, S.C.C.L.','699','2011-10-28','2011-09-30','EUR',1.000000000,752.00,752.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',0,969,3100000210000969,1,1,1),(56,'ORDENADOR HP PRO 3300 SFF','PRO 3300 SFF',0,0,'0000-00-00',0,0.00,25.00,0.00,25.00,4,0,1,1,'217000105',1,1,'281700105','681000000',0,'410000039','AIDA SET, S.C.C.L.','354','2012-04-27','2012-04-27','EUR',1.000000000,613.00,613.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',0,286,3100000210000286,1,1,1),(57,'WORKSTATIONS Z210 HP','',0,0,'0000-00-00',0,0.00,25.00,0.00,25.00,4,0,1,1,'217000106',1,1,'281700106','681000000',0,'410000039','AIDA SET, S.C.C.L.','353','2012-04-30','2012-04-27','EUR',1.000000000,1378.00,1378.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',0,323,3100000210000323,1,1,1),(58,'SERVIDOR','TX100 S3P',0,0,'0000-00-00',0,0.00,25.00,0.00,25.00,4,0,1,1,'217000107',1,1,'281700107','681000000',0,'410000454','QUARTUP, S.L.','FAC67','2013-04-16','2013-04-16','EUR',1.000000000,1151.68,1151.68,0.00,0.00,0.00,0.00,'FC',1,'SOP',0,315,3100000210000315,1,1,1),(59,'ORDENADOR HP PRO 3500','3500',0,0,'0000-00-00',0,0.00,25.00,0.00,25.00,4,0,1,1,'217000108',1,1,'281700108','681000000',0,'410000454','QUARTUP, S.L.','FAC-106','2013-07-31','2013-07-01','EUR',1.000000000,649.00,649.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',0,707,3100000210000707,1,1,1),(60,'ORDENADOR HP PRO 4300 SFF','',0,0,'0000-00-00',0,0.00,25.00,0.00,25.00,4,0,1,1,'217000109',1,1,'281700109','681000000',0,'410000454','QUARTUP, S.L.','FAC-242','2013-12-31','2013-12-04','EUR',1.000000000,593.00,593.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',0,1276,3100000210001276,1,1,1),(61,'ORDENADOR HP 600B','600B',0,0,'0000-00-00',0,0.00,25.00,0.00,25.00,4,0,1,1,'217000110',1,1,'281700110','681000000',0,'410000454','QUARTUP, S.L.','FAC-140144','2014-02-28','2014-02-16','EUR',1.000000000,584.00,584.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',0,112,3100000210000112,1,1,1),(62,'VEHICULO TURISMO','BMW',0,0,'0000-00-00',0,0.00,16.67,0.00,16.67,6,0,1,1,'218000003',1,1,'281800003','681000000',0,'410999999','ACREEDORES VARIOS','','2002-01-01','2002-01-01','EUR',1.000000000,35321.78,35321.78,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,33),(63,'FURGONETA CITROEN JUMPY','JUMPY',0,0,'0000-00-00',0,0.00,16.00,0.00,16.00,6,3,1,1,'218000004',1,1,'281800004','681000000',0,'410999999','ACREEDORES VARIOS','','2004-02-01','2004-02-01','EUR',1.000000000,15309.48,15309.48,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,34),(64,'CAMION IVECO','IVECO',0,0,'0000-00-00',0,0.00,16.00,0.00,16.00,6,3,1,1,'218000005',1,1,'281800005','681000000',0,'410999999','ACREEDORES VARIOS','','2004-02-01','2004-02-01','EUR',1.000000000,21215.00,21215.00,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,35),(65,'FURGONETA JUMPY I','JUMPY',0,0,'0000-00-00',0,0.00,16.00,0.00,16.00,6,3,1,1,'218000006',1,1,'281800006','681000000',0,'410999999','ACREEDORES VARIOS','','2003-11-01','2003-11-01','EUR',1.000000000,14947.42,14947.42,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,36),(66,'FURGONETA CITROEN JUMPY 2','',0,0,'0000-00-00',0,0.00,16.00,0.00,16.00,6,3,1,1,'218000007',1,1,'281800007','681000000',0,'410000427','JOSEP Mª.GUITART','12-14','2012-05-17','2012-03-31','EUR',1.000000000,1800.00,1800.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',0,400,3100000210000400,1,1,1),(67,'CITRÖEN JUMPY','JUMPY 12529L2H1FG BU',1,0,'2024-03-28',0,0.00,16.00,0.00,16.00,6,3,1,1,'218000008',1,1,'281800008','681000000',0,'410000429','COMERCIAL CITROEN, S.A.','NA2230173','2013-05-01','2013-04-29','EUR',1.000000000,16380.17,16380.17,0.00,0.00,0.00,0.00,'FC',1,'SOP',0,387,3100000210000387,1,1,1),(68,'AUTOMOVIL','140 BLUEDTECNO',1,0,'2022-07-29',0,0.00,16.00,0.00,16.00,6,3,1,1,'218000009',1,1,'281800009','681000000',0,'410000474','AUTOMOBILS FONT DEL RADIUM,SL','','2013-09-30','2013-09-16','EUR',1.000000000,17446.27,17446.27,0.00,0.00,0.00,0.00,'FC',1,'SOP',0,945,3100000210000945,1,1,1),(69,'VW TOUAREG','',0,0,'0000-00-00',0,0.00,16.00,0.00,16.00,6,3,1,1,'218000010',1,1,'281800010','681000000',0,'400000361','ALUVISILES, S.L.','201400229','2014-11-30','2014-11-13','EUR',1.000000000,22830.58,22830.58,0.00,0.00,0.00,0.00,'FC',1,'SOP',0,1482,3100000210001482,1,1,1),(70,'CERRAMIENTO DE OFICINAS','MAMPAR',0,0,'0000-00-00',0,0.00,10.00,0.00,10.00,10,0,1,1,'219000005',1,1,'281900005','681000000',0,'410000268','MAMPAR, S.A.','','2007-01-01','2007-01-01','EUR',1.000000000,10603.56,10603.56,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,37),(71,'ESTANTERIAS MECALUX','MECALUX',0,0,'0000-00-00',0,0.00,10.00,0.00,10.00,10,0,1,1,'219000006',1,1,'281900006','681000000',0,'410000209','MECALUX, S.A.','','2007-01-01','2007-01-01','EUR',1.000000000,2025.00,2025.00,0.00,0.00,0.00,0.00,'FC',1,'',0,0,3100000270000000,0,1,38),(72,'CENTRALITA TELEFONO','LG',0,0,'0000-00-00',0,0.00,25.00,0.00,25.00,4,0,1,1,'219000007',1,1,'281900007','681000000',0,'410000345','SERCOM JAADT, S.L.','A/1121','2010-11-01','2010-11-01','EUR',1.000000000,1466.50,1466.50,0.00,0.00,0.00,0.00,'FC',1,'SOP',0,1127,3100000210001127,1,1,1),(73,'TRONZADORA MG TLG 352-A220V','SIERRA DE CINTA \r\nTOPE MEDIDOR',0,0,'0000-00-00',0,0.00,12.00,0.00,12.00,8,4,1,1,'213000043',0,1,'281300043','681000000',0,'400000620','','37000020','2017-02-28','2017-01-27','EUR',1.000000000,6436.60,6436.60,0.00,0.00,0.00,0.00,'FC',1,'SOP',2017,223,722956045369448478,1,1,1),(74,'CITROEN JUMPY MBLUHD115C','',0,0,'0000-00-00',218,0.00,16.00,0.00,16.00,6,3,1,1,'218000011',0,1,'281800011','681000000',0,'572000000','','LEASING','2017-02-01','2017-01-24','EUR',1.000000000,17200.00,17200.00,0.00,0.00,0.00,0.00,'',0,'',0,0,0,0,1,1),(75,'COMPRESOR + CALDERA + SECADOR + INSTALACION AIRE','',0,0,'0000-00-00',0,0.00,12.00,0.00,12.00,8,4,1,1,'213000044',0,1,'281300044','681000000',0,'410000056','','93','2017-03-31','2017-02-28','EUR',1.000000000,5720.40,5720.40,0.00,0.00,0.00,0.00,'FC',1,'SOP',2017,324,335346043690178156,1,1,1),(76,'ARES-6000-PLUS-TURBO-SEAMLESS-RT','',0,0,'0000-00-00',0,0.00,12.00,0.00,12.00,8,4,1,1,'213000045',0,1,'281300045','681000000',0,'410000020','','F1700580','2017-03-31','2017-03-31','EUR',1.000000000,72382.00,72382.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',2017,426,267863511508701697,1,1,1),(77,'MÁQUINA PANTÓGRAFO DE CORTE AUTOMÁTICO','',0,0,'0000-00-00',0,0.00,12.00,0.00,12.00,8,4,1,1,'213000046',0,1,'281300046','681000000',0,'410000428','','','2017-07-12','2017-07-12','EUR',1.000000000,84000.00,84000.00,0.00,0.00,0.00,0.00,'',0,'',0,0,0,0,1,2),(78,'MAQUINA CL 867-290142 MATIC','',0,0,'0000-00-00',0,0.00,12.00,0.00,12.00,8,4,1,1,'213000047',0,1,'281300047','681000000',0,'410000020','','F1701069','2017-06-29','2017-06-20','EUR',1.000000000,10716.29,10716.29,0.00,0.00,0.00,0.00,'FC',1,'SOP',2017,912,709934863579438275,1,1,1),(79,'APILADOR ELECTRICO STILL EXV 10 1000 2012','',0,0,'0000-00-00',213,0.00,12.00,0.00,12.00,8,4,1,1,'213000049',0,1,'281300049','681000000',0,'410000535','','F17/0562','2017-10-20','2017-10-20','EUR',1.000000000,4150.00,4150.00,0.00,0.00,0.00,0.00,'',0,'',0,0,0,0,1,3),(80,'FORD TRANSIT CONNECT B.LARGA FT210 L2 TREND 1.5 TDCI 74,2 KW','',0,1,'0000-00-00',218,0.00,16.00,0.00,16.00,6,3,1,1,'218000012',0,1,'281800012','681000000',0,'410000653','','N4140318 53','2018-04-21','2018-04-21','EUR',1.000000000,12478.71,12478.71,0.00,0.00,0.00,0.00,'FC',1,'SOP',2018,506,144131262753133976,1,1,1),(81,'IVECO','',0,0,'0000-00-00',218,0.00,16.00,0.00,16.00,6,3,1,1,'218000011',0,2,'281800013','681000000',0,'174000015','','','2018-04-16','2018-04-16','EUR',1.000000000,33023.00,33023.00,0.00,0.00,0.00,0.00,'',0,'',0,0,0,0,1,4),(82,'ADAPTACION IVECO','',0,0,'0000-00-00',218,0.00,16.00,0.00,16.00,6,3,1,1,'218000013',0,1,'281800014','681000000',0,'410000659','','1800998','2018-05-10','2018-05-02','EUR',1.000000000,1099.31,1099.31,0.00,0.00,0.00,0.00,'FC',1,'SOP',2018,587,398645520692417363,1,1,1),(83,'HYUNDAI KONA TGDI','',0,1,'0000-00-00',218,0.00,16.00,0.00,16.00,6,3,1,1,'218000014',0,1,'281800015','681000000',0,'410000647','','VN 1487','2018-09-08','2018-08-09','EUR',1.000000000,16500.99,16500.99,0.00,0.00,639.00,639.00,'',0,'',0,0,0,0,1,5),(84,'PACK DE SURFACE Y FUNDA CON TECLADO SIGNATURE PLATINO','',0,0,'0000-00-00',220,4.00,25.00,0.00,25.00,4,0,1,1,'217000111',0,1,'281700111','681000000',0,'410000671','','','2018-10-30','2018-09-11','EUR',1.000000000,800.82,800.82,0.00,0.00,0.00,0.00,'',0,'',0,0,0,0,1,6),(85,'SURFACE PRO','',0,0,'0000-00-00',220,4.00,25.00,0.00,25.00,4,0,1,1,'217000112',0,1,'281700112','681000000',0,'410000671','','14374019342','2018-11-30','2018-11-28','EUR',1.000000000,742.98,742.98,0.00,0.00,0.00,0.00,'FC',1,'SOP',2018,1476,875997840140862091,1,1,1),(86,'FORD TRANSIT COURIER','',0,0,'0000-00-00',218,0.00,16.00,0.00,16.00,6,3,1,1,'218000015',0,1,'281800016','681000000',0,'410000074','','','2019-03-08','2019-03-08','EUR',1.000000000,10785.13,10785.13,0.00,0.00,0.00,0.00,'',0,'',0,0,0,0,1,7),(87,'EQUIPOS E IMPRESORAS HP (QURTUP)','',0,0,'0000-00-00',220,4.00,25.00,0.00,25.00,4,0,1,1,'217000113',0,1,'281700113','681000000',0,'410000454','','','2019-10-15','2019-09-30','EUR',1.000000000,10048.89,10048.89,0.00,0.00,0.00,0.00,'',0,'',0,0,0,0,1,8),(88,'CAMIÓN IVECO','',0,0,'0000-00-00',218,0.00,16.00,0.00,16.00,6,3,1,1,'218000016',0,1,'281800017','681000000',0,'410000703','','520400179','2020-06-30','2020-03-19','EUR',1.000000000,33900.00,33900.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',2020,629,423591354147604712,1,1,1),(89,'REFORMA EQUIPAMIENTO IVECO','',0,0,'0000-00-00',218,0.00,16.00,0.00,16.00,6,3,1,1,'218000017',0,1,'281800018','681000000',0,'410000659','','2000942','2020-06-30','2020-05-20','EUR',1.000000000,3100.00,3100.00,0.00,0.00,0.00,0.00,'',0,'',0,0,0,0,1,9),(90,'MAQUINA JOVER MODELO 16-FEI','',0,0,'0000-00-00',213,0.00,12.00,0.00,12.00,8,4,1,1,'213000051',0,1,'281300051','681000000',0,'410000292','','','2021-02-16','2021-02-16','EUR',1.000000000,9918.00,9918.00,0.00,0.00,0.00,0.00,'',0,'',0,0,0,0,1,10),(91,'JACK COSTURA PROGRAMADA','1200 X 760 LASER + COSTURA\r\nNº SERIE 21013003835',0,0,'0000-00-00',213,0.00,12.00,0.00,12.00,8,4,1,1,'213000052',0,1,'281300052','681000000',0,'410000428','','21003677','2021-04-30','2021-04-15','EUR',1.000000000,18990.50,18990.50,0.00,0.00,0.00,0.00,'FC',1,'SOP',2021,537,909425598527469700,1,1,1),(92,'BANCO DE CORTE AUTOMAT','',0,0,'0000-00-00',213,0.00,12.00,0.00,12.00,8,4,1,1,'213000053',0,1,'281300053','681000000',0,'410000428','','21005386','2021-05-31','2021-05-30','EUR',1.000000000,65534.50,65534.50,0.00,0.00,0.00,0.00,'',0,'',0,0,0,0,1,11),(93,'RETRÁCTIL + BATERÍA','',0,0,'0000-00-00',213,0.00,12.00,0.00,12.00,8,4,1,1,'213000054',0,1,'281300054','681000000',0,'410000763','','F21/0424','2021-09-22','2021-09-22','EUR',1.000000000,10500.00,10500.00,0.00,0.00,0.00,0.00,'',0,'',0,0,0,0,1,12),(95,'ESTANTERIAS MECALUX','',0,0,'0000-00-00',0,0.00,10.00,0.00,10.00,10,0,1,1,'219000008',0,1,'281900008','681000000',0,'410000209','','1180137211','2021-09-08','2021-09-08','EUR',1.000000000,1326.00,1326.00,0.00,0.00,0.00,0.00,'',0,'',0,0,0,0,1,13),(96,'ESTANTERIAS MECALUX','',0,0,'0000-00-00',0,0.00,10.00,0.00,10.00,10,0,1,1,'213000009',0,1,'281900009','681000000',0,'410000209','','1180139007','2021-10-07','2021-10-07','EUR',1.000000000,3094.00,3094.00,0.00,0.00,0.00,0.00,'',0,'',0,0,0,0,1,14),(97,'ESTANTERIAS MECALUX','',0,0,'0000-00-00',0,0.00,10.00,0.00,10.00,10,0,1,1,'219000009',0,1,'281900009','681000000',0,'410000209','','1180139007','2021-10-07','2021-10-07','EUR',1.000000000,3094.00,3094.00,0.00,0.00,0.00,0.00,'',0,'',0,0,0,0,1,15),(98,'ORDENADORES ACER ASPIRE','',0,0,'0000-00-00',220,4.00,25.00,0.00,25.00,4,0,1,1,'217000114',0,1,'281700114','681000000',0,'410000648','','ES1PQ1NTAEUS','2021-12-31','2021-12-01','EUR',1.000000000,1735.49,1735.49,0.00,0.00,0.00,0.00,'FC',1,'SOP',2021,1845,666836705892688820,1,1,1),(99,'ESTANTERIAS MECALUX','',0,0,'0000-00-00',0,0.00,10.00,0.00,10.00,10,0,1,1,'219000010',0,1,'281900010','681000000',0,'410000209','','1180148699','2022-03-31','2022-03-11','EUR',1.000000000,460.00,460.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',2022,307,624974438494658631,1,1,1),(100,'PRENSA PARA TRANSFER MAGNÉTICA','',0,0,'0000-00-00',213,0.00,12.00,0.00,12.00,8,4,1,1,'213000056',0,1,'281300056','681000000',0,'410000428','','22003106','2022-03-31','2022-03-30','EUR',1.000000000,2200.00,2200.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',2022,392,796568748267850969,1,1,1),(101,'FURGONETA JUMPER','',0,0,'0000-00-00',218,0.00,16.00,0.00,16.00,6,3,1,1,'218000018',0,1,'281800019','681000000',0,'174000004','','','2022-04-25','2022-04-25','EUR',1.000000000,31553.91,31553.91,0.00,0.00,0.00,0.00,'',0,'',0,0,0,0,1,16),(102,'BANCO DE CORTE 1250 x 6000','',0,0,'0000-00-00',213,0.00,12.00,0.00,12.00,8,4,1,1,'213000057',0,1,'281300057','681000000',0,'430001387','','2203467','2022-05-03','2022-05-03','EUR',1.000000000,59000.00,59000.00,0.00,0.00,0.00,0.00,'',0,'',0,0,0,0,1,17),(103,'MAQUINA DE SOLDAR POR COLA 6 mts','',0,0,'0000-00-00',213,0.00,12.00,0.00,12.00,8,4,1,1,'213000058',0,1,'281300058','681000000',0,'430001387','','22003467','2022-05-03','2022-05-03','EUR',1.000000000,54094.00,54094.00,0.00,0.00,0.00,0.00,'',0,'',0,0,0,0,1,18),(104,'VEHICULO MERCEDES BENZ','',0,0,'0000-00-00',218,0.00,16.00,0.00,16.00,6,3,1,1,'218000019',0,1,'281800020','681000000',0,'410000790','','CONTRATO LEASING','2022-08-31','2022-07-22','EUR',1.000000000,70911.51,70911.51,0.00,0.00,0.00,0.00,'',0,'',0,0,0,0,1,19),(105,'QUARTUP GESTION DE PROCESOS','',0,0,'0000-00-00',206,0.00,33.00,0.00,33.00,3,1,1,1,'206000001',0,1,'280600001','680000000',0,'410000454','','FAC-221348','2022-08-31','2022-07-05','EUR',1.000000000,6000.00,6000.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',2022,1139,863371029680933219,1,1,1),(106,'QUARTUP ECOMMERCE','',0,0,'0000-00-00',206,0.00,33.00,0.00,33.00,3,1,1,1,'206000002',0,1,'280600002','680000000',0,'410000454','','FAC-221349','2022-08-31','2022-07-04','EUR',1.000000000,2000.00,2000.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',2022,1140,936484479647372517,1,1,1),(107,'QUARTUP GESTION DE CLIENTES','',0,0,'0000-00-00',206,0.00,33.00,0.00,33.00,3,1,1,1,'206000003',0,1,'280600003','680000000',0,'410000454','','FAC-221350','2022-08-31','2022-07-04','EUR',1.000000000,4000.00,4000.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',2022,1141,877401924744224455,1,1,1),(108,'IMPRESORA HP E40040DN','',0,0,'0000-00-00',217,4.00,25.00,1.00,25.00,4,0,1,1,'217000115',0,1,'281700115','681000000',0,'410000801','','22FV402925','2022-12-31','2022-11-30','EUR',1.000000000,998.01,998.01,0.00,0.00,0.00,0.00,'FC',1,'SOP',2022,1667,268589931389201552,1,1,1),(109,'MAQUINA SOLDAR ULTRASONIDOS','',0,0,'0000-00-00',213,0.00,12.00,0.00,12.00,8,4,1,1,'213000059',0,1,'281300059','681000000',0,'410000808','','','2023-02-28','2023-02-07','EUR',1.000000000,1900.00,1900.00,0.00,0.00,0.00,0.00,'',0,'',0,0,0,0,1,20),(110,'ESTANTERIAS MECALUX','',0,0,'0000-00-00',219,0.00,10.00,0.00,10.00,10,0,1,1,'219000011',0,1,'281900011','681000000',0,'410000209','','180172502','2023-04-30','2023-04-05','EUR',1.000000000,3966.90,3966.90,0.00,0.00,0.00,0.00,'FC',1,'SOP',2023,513,518493512219171779,1,1,1),(111,'TRONZADORA MG AUTOMATICA CORTE RECTO','',0,0,'0000-00-00',213,0.00,12.00,0.00,12.00,8,4,1,1,'213000060',0,1,'281300060','681000000',0,'410000814','','22-25','2023-05-31','2023-05-23','EUR',1.000000000,7400.00,7400.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',2023,733,875596583842040948,1,1,1),(112,'MARSEW MAQ TRIPLE CORTAHILOS 2 AGUJAS','',2,0,'2024-03-31',213,0.00,12.00,0.00,12.00,8,4,1,1,'213000061',0,1,'281300061','681000000',0,'410000428','','23005398','2023-05-31','2023-05-30','EUR',1.000000000,4439.50,4439.50,0.00,0.00,0.00,0.00,'FC',1,'SOP',2023,787,491406809800684566,1,1,1),(113,'TRONZADORA MG DOBLE CABEZAL DUO-450','',0,0,'0000-00-00',213,0.00,12.00,0.00,12.00,8,4,1,1,'213000062',0,1,'281300062','681000000',0,'410000814','','22-62','2023-11-30','2023-11-22','EUR',1.000000000,38639.20,38639.20,0.00,0.00,0.00,0.00,'FC',1,'SOP',2023,1567,592126743608277265,1,1,1),(114,'DESTRUCTORA TRITURADORA OFICINA','',0,0,'0000-00-00',213,0.00,12.00,0.00,12.00,8,4,1,1,'213000063',0,1,'281300063','681000000',0,'410000400','','','2023-12-14','2023-10-24','EUR',1.000000000,5493.49,5493.49,0.00,0.00,0.00,0.00,'',0,'',0,0,0,0,1,21),(116,'APILADOR ELECTRICO','',0,0,'0000-00-00',213,0.00,12.00,0.00,12.00,8,4,1,1,'213000065',0,1,'281300065','681000000',0,'410000022','','F23/0477','2024-01-31','2023-09-28','EUR',1.000000000,6300.00,6300.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',2024,93,202850417796575874,1,1,1),(117,'PLACAS SOLARES INDOX','',0,0,'0000-00-00',0,0.00,7.00,0.00,7.00,14,4,1,1,'212000002',0,1,'281200002','681000000',0,'410000786','','','2024-02-01','2024-02-01','EUR',1.000000000,18000.00,18000.00,0.00,0.00,0.00,0.00,'',0,'',0,0,0,0,1,22),(118,'ALMACEN VERTICAL','',0,0,'0000-00-00',213,0.00,12.00,0.00,12.00,8,4,1,1,'213000066',0,1,'281300066','681000000',0,'410000755','','','2024-02-01','2024-02-01','EUR',1.000000000,118835.66,118835.66,0.00,0.00,0.00,0.00,'',0,'',0,0,0,0,1,23),(119,'BANDEJAS ALMACEN VERTICAL','',0,0,'0000-00-00',213,0.00,12.00,0.00,12.00,8,4,1,1,'213000066',0,2,'281300066','681000000',0,'410000503','','','2024-02-01','2024-02-01','EUR',1.000000000,20601.70,20601.70,0.00,0.00,0.00,0.00,'',0,'',0,0,0,0,1,24),(120,'ELEVADOR PORTATIL KSF CM340','',0,0,'0000-00-00',213,0.00,12.00,0.00,12.00,8,4,1,1,'213000067',0,1,'281300067','681000000',0,'410000843','','24018','2024-02-29','2024-02-29','EUR',1.000000000,1491.50,1491.50,0.00,0.00,0.00,0.00,'FC',1,'SOP',2024,279,596137623110296544,1,1,1),(121,'INSTALACION TOMA CORRIENTE Y CONEXION A TIERRA PLACAS SOLARES','',0,0,'0000-00-00',0,0.00,7.00,0.00,7.00,14,4,1,1,'212000002',0,2,'281200002','681000000',0,'410000839','','2024058','2024-03-31','2024-03-18','EUR',1.000000000,942.95,942.95,0.00,0.00,0.00,0.00,'FC',1,'SOP',2024,349,795613396960545697,1,1,1),(122,'COMPRESOR 7\'5 CV K-MAX','',0,0,'0000-00-00',213,0.00,12.00,0.00,12.00,8,4,1,1,'213000068',0,1,'281300068','681000000',0,'410000056','','87','2024-03-31','2024-03-15','EUR',1.000000000,6890.00,6890.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',2024,362,326375022742366536,1,1,1),(123,'ESTANTERIAS MECALUX','',0,0,'0000-00-00',219,0.00,10.00,0.00,10.00,10,0,1,1,'219000012',0,1,'281900012','681000000',0,'410000209','','1180195801','2024-04-30','2024-04-23','EUR',1.000000000,13296.00,13296.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',2024,532,754421815750987204,1,1,1),(125,'FLEJADORA','',0,0,'0000-00-00',213,0.00,12.00,0.00,12.00,8,4,1,1,'213000070',0,1,'281300070','681000000',0,'410000200','','','2024-07-31','2024-07-09','EUR',1.000000000,950.00,950.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',2024,973,282482481422375103,1,1,1),(126,'DESTRUCTORAS DE TEJIDO','',0,0,'0000-00-00',213,0.00,12.00,0.00,12.00,8,4,1,1,'213000069',0,1,'281300069','681000000',0,'400000438','','LH241305','2024-08-01','2024-05-16','EUR',1.000000000,3272.08,3272.08,0.00,0.00,1493.40,1493.40,'',0,'',0,0,0,0,1,25),(127,'MAQUINA COSER 2 AGUJAS TRIPLE ARRASTRE','',0,0,'0000-00-00',213,0.00,12.00,0.00,12.00,8,4,1,1,'213000071',0,1,'281300071','681000000',0,'410000428','','','2024-09-30','2024-09-15','EUR',1.000000000,12161.75,12161.75,0.00,0.00,0.00,0.00,'FC',1,'SOP',2024,240090,300332779758101282,1,1,1),(128,'DACIA SANDERO','',0,0,'0000-00-00',218,0.00,16.00,0.00,16.00,6,3,1,1,'218000020',0,1,'281800021','681000000',0,'410000863','','','2024-11-05','2024-11-05','EUR',1.000000000,10307.93,10307.93,0.00,0.00,0.00,0.00,'',0,'',0,0,0,0,1,26),(130,'MÁQUINA DE DOS AGULLES AMB TRIPLE ARRESSEGAMENT','',0,0,'0000-00-00',213,0.00,12.00,0.00,12.00,8,4,1,1,'213000073',0,1,'281300072','681000000',0,'410000428','','','2024-12-31','2024-12-31','EUR',1.000000000,12723.71,12723.71,0.00,0.00,0.00,0.00,'FC',1,'SOP',2024,240502,384303549564602001,1,1,1),(131,'MACBOOK AIR','',0,0,'0000-00-00',213,0.00,12.00,0.00,12.00,8,4,1,1,'213000074',0,1,'281300074','681000000',0,'410000483','','','2025-02-28','2025-01-20','EUR',1.000000000,2931.41,2931.41,0.00,0.00,0.00,0.00,'FC',1,'SOP',2025,250187,304345503112275941,1,1,1),(132,'ESTANTERIAS MECALUX','',0,0,'0000-00-00',219,0.00,10.00,0.00,10.00,10,0,1,1,'219000013',0,1,'281900013','681000000',0,'410000209','','1180214019','2025-02-28','2025-02-20','EUR',1.000000000,7193.00,7193.00,0.00,0.00,0.00,0.00,'FC',1,'SOP',2025,250231,204395640493823308,1,1,1),(133,'ORDENADOR HP PRO 400 G9','',0,0,'0000-00-00',217,4.00,25.00,2.00,50.00,2,0,1,1,'217000116',0,1,'281700116','681000000',0,'410000454','','','2025-04-30','2025-04-22','EUR',1.000000000,1067.95,1067.95,0.00,0.00,0.00,0.00,'FC',1,'SOP',2025,250501,193425502991969011,1,1,1),(134,'PEUGEOT PARTNER HDI 120','',0,0,'0000-00-00',218,0.00,16.00,0.00,16.00,6,3,1,1,'218000021',0,1,'281800022','681000000',0,'400000999','','','2025-05-27','2025-05-27','EUR',1.000000000,23152.07,23152.07,0.00,0.00,0.00,0.00,'',0,'',0,0,0,0,1,27),(135,'MAQUINA DESTRUCTORA DE METAL','',0,0,'0000-00-00',213,0.00,12.00,0.00,12.00,8,4,1,1,'213000075',0,1,'281300075','681000000',0,'410000400','','FT250205','2025-06-30','2025-02-27','EUR',1.000000000,8859.17,8859.17,0.00,0.00,1539.51,1539.51,'FC',1,'IMP',2025,1,407537894595811398,1,1,1),(136,'SPLIT CASSETTE DESPATX JORDI','',0,0,'0000-00-00',213,0.00,12.00,0.00,12.00,8,4,1,1,'213000076',0,1,'281300076','681000000',0,'410000892','','','2025-07-31','2025-07-11','EUR',1.000000000,3425.56,3425.56,0.00,0.00,0.00,0.00,'',0,'',0,0,0,0,1,28);
/*!40000 ALTER TABLE `cialinmo` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-10-30  8:40:59
