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

DROP TABLE IF EXISTS `cialform`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cialform` (
  `cod_formula` char(12) NOT NULL DEFAULT '' COMMENT 'Fórmula',
  `nombre` text NOT NULL COMMENT 'Nombre',
  `sw_coste_margen` char(1) NOT NULL DEFAULT 'T' COMMENT 'Valoración Centro de coste',
  `num_orden` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Orden salida',
  `sw_ceco` char(1) NOT NULL DEFAULT 'S' COMMENT 'Ind. Centro coste',
  `sw_dh` char(1) NOT NULL DEFAULT 'D' COMMENT 'Ind. Debe / Haber',
  `sw_diferencia` char(1) NOT NULL DEFAULT 'N' COMMENT 'Sacar según saldo',
  `sw_presu` char(1) NOT NULL DEFAULT 'S' COMMENT 'Tiene Presupuesto',
  `sw_signo` char(1) NOT NULL DEFAULT '+' COMMENT 'Signo Presupuesto',
  `sw_obra` char(1) NOT NULL DEFAULT 'N' COMMENT 'Cuenta de obra',
  `digitos` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Digitos cuenta',
  `solo_total` char(1) NOT NULL DEFAULT 'S' COMMENT 'Solo total por grupo',
  `sw_pag_cob` char(1) NOT NULL DEFAULT 'P' COMMENT 'Tipo Formula',
  `id_tenant` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Nº empresa',
  UNIQUE KEY `key0` (`id_tenant`,`cod_formula`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `cialform` WRITE;
/*!40000 ALTER TABLE `cialform` DISABLE KEYS */;
INSERT INTO `cialform` (`cod_formula`, `nombre`, `sw_coste_margen`, `num_orden`, `sw_ceco`, `sw_dh`, `sw_diferencia`, `sw_presu`, `sw_signo`, `sw_obra`, `digitos`, `solo_total`, `sw_pag_cob`, `id_tenant`) VALUES ('Q-ABC','TOTAL PASIVO','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-AC','ACTIVO CORRIENTE','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-ACI','ACTIVOS NO CORRIENTES VENTA','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-ACII','EXISTENCIAS','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-ACIII','DEUDORES COMERCIALES','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-ACIIIA','CLIENTES POR VENTAS','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-ACIIIB','OTROS DEUDORES','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-ACIV','INVERSIONES EMPRESAS DEL GRUPO','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-ACV','INVERSIONES FINANCIERAS CORTO','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-ACVI','PERIODIFICCIONES A CORTO PLZ.','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-ANC','ACTIVO NO CORRIENTE','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-ANCAC','TOTAL ACTIVO','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-ANCI','INMOVILIZADO INTANGIBLE','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-ANCII','INMOVILIZADO MATERIAL','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-ANCIII','INVERSIONES INMOVILIARIAS','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-ANCIV','INVERSIONES FINANCIERAS L.PLZ','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-ANCV','INVERSIONES FINANCIERAS LARG.P','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-APSIIIA','','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-APSIIIB','','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-DEG','DEUDAS EMPRESAS DEL GRUPO','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-DLP','DEUDAS A LARGO PLAZO','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-DLPI','DEUDAS CON ENTIDADES CREDITO','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-DLPII','ACREEDORES ARREND.FINANCIERO','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-DLPIII','OTRAS DEUDAS A LARGO PLAZO.','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-E1','IMPORTE NETO CIFRA NEGOCIOS.','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-E10','EXCESOS DE PROVISIONES','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-E11','DETERIORO INMOVILZADO','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-E12','DIFERENCIA NEGATIV.COMB.NEGOCI','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-E13','OTROS RESULTADOS','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-E14','INGRESOS FINANCIEROS','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-E14a','IMP.SUV.DONC.CARACT.FINANCIERO','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-E14b','OTROS INGRESOS FINANCIEROS','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-E15','GASTOS FINANCIEROS','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-E16','VARIACION VALOR RAZ.INT.FINANC','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-E17','DIFERENCIAS DE CAMBIO','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-E18','DETERIORO Y REST.ENAJ.INST.FIN','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-E19','IMPUESTO SOBRE BENEFICIOS','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-E2','VARIACION DE EXISTENCIAS','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-E3','TRABAJOS REALIZADO ACTIVO.','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-E4','APROVISIONAMIENTOS','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-E5','OTROS INGRESOS DE EXPLOTACION','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-E6','GASTOS DE PERSONAL','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-E7','OTROS GASTOS DE EXPLOTACION','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-E8','AMORTIZACION DEL INMOVILIZADO','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-E9','IMPUTACIONES DE SUBVENCIONES','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN','OPERACIONES CONTINUADAS','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN1','IMPORTE NETO CIFRA DE NEGOCIOS','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN11','DETERIORO INMOVILIZADO','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN11a','DETERIORO Y PERDIDAS','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN11b','RESULTADO POR ENAJENACIONES','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN14','INGRESOS FINANCIEROS (NORMAL)','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN14a','PARETICIP.INSTRUM.PATRIMONIO','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN14a1','a1','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN14a2','a2','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN14b','b)','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN14b1','b1','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN14b2','b2','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN14c','c)','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN15','GASTOS FINANCIEROS','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN15a','GASTOS FINANCIEROS','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN15b','GASTOS FINANCIEROS','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN15c','GASTOS FINANCIEROS','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN16','VARIACION DE VALOR INST.FINANC','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN16a','CARTERA NEGOCIACION','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN16b','VARIACION INST.FINANCIEROS','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN18','DETERIORO INSTRUMENTS.FINANC.','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN18a','DETERIORO INSTRUMENTS.FINANC.','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN18b','DETERIORO INSTR.FINANCCIEROS','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN1a','VENTAS','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN1b','PRESTACION DE SERVICIOS','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN4','APROVISIONAMIENTOS','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN4a','CONSUMO DE MERCADERIAS','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN4b','CONSUMO DE MATERIAS PRIMAS','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN4c','TRABAJOS REALIZADOS OT.EMPRES.','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN4d','DETERIORO DE MERCADERIAS','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN5','OTROS INGRESOS DE EXPLOTACION','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN5a','INGRESOS ACCESORIOS Y OTROS','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN5b','SUBVENCIONES DE EXPLOTACION','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN6','GASTOS DE PERSONAL','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN6a','SUELDOS SALARIOS Y ASIMILADOS','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN6b','CARGAS SOCIALES','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN6c','PROVISIONES','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN7','OTROS GASTOS DE EXPLOTACION','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN7a','SERVICIOS EXTERIORES','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN7b','TRIBUTOS','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN7c','PERDIDAS VARIACION OP.CIALES.','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-EN7d','OTROS GASTOS DE GESTION CTE.','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-FACV','AJUSTES POR CAMBIOS DE VALOR','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-FP','FONDOS PROPIOS','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-FPA','CAPITAL','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-FPAI','CAPITAL ESCRITURADO','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-FPAII','CAPITAL NO EXIGIDO','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-FPB','RESERVAS','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-FPC','ACCIONES Y PARTICP.EN PATRIMON','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-FPD','RESULTADOS EJERCCIOS ANTER.','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-FPE','RESULTADO DEL EJERCICIO','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-FSDL','SUBVENCIONES DONACIONES Y LEG.','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-PC','PASIVO CORRIENTE','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-PCI','PASIVOS VINCULADOS CON ACT.','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-PCII','PROVISIONES A CORTO PLAZO','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-PCIII','DEUDAS A CORTO PLAZO.','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-PCIIIA','DEUDAS CON ENTIDADES DE CREDIT','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-PCIIIB','ACREEDORES ARREND.FINANCIERO','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-PCIIIC','OTRAS DEUDAS A CORTO PLAZO.','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-PCIV','DEUDAS CON EMPRESAS GRUP.CORTO','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-PCV','ACREDORES CIALESY OTRAS CTAS.','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-PCVA','PROVEEDORES','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-PCVB','OTROS ACREEDORES','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-PCVI','PERIODIFICACIONES A CORTO PLZ.','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-PCVII','DEUDA CARACTERS.ESPECIALES C.P','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-PNC','PASIVO NO CORRIENTE','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-RAI','RESULTADO ANTES DE IMPUESTOS','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-RAIN','RESULTADO ANTES DE IMPUESTOS','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-RE','RESULTADO DE EXPLOTACION','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-REJ','RESULTADO DEL EJERCICIO','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-REJA','RESULTADO EJERCICIO ABREVIADO','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-REJN','RESULTADO DEL EJERCICIO','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-REN','RESULTADO EXPLOTACION NORMAL','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-RF','RESULTADO FINANCIERO','T',0,'S','D','N','S','+','N',0,'S','P',1),('Q-RFN','RESULTADO FINANCIERO','T',0,'S','D','N','S','+','N',0,'S','P',1);
/*!40000 ALTER TABLE `cialform` 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
