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

DROP TABLE IF EXISTS `cialcartest`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cialcartest` (
  `semisoporte` char(1) NOT NULL DEFAULT 'C' COMMENT 'Tipo doc.',
  `cod_caesta` char(3) NOT NULL DEFAULT '' COMMENT 'Estado',
  `nombre` char(250) NOT NULL DEFAULT '' COMMENT 'Nombre',
  `nombre_proc` char(250) NOT NULL DEFAULT '' COMMENT 'Nombre Proceso',
  `sw_activo` char(1) NOT NULL DEFAULT 'S' COMMENT 'Activo',
  `sw_modificable` char(1) NOT NULL DEFAULT 'N' COMMENT 'Cartera modificable',
  `sw_cta_paco_obli` char(1) NOT NULL DEFAULT 'S' COMMENT 'Banco obligatorio',
  `sw_cta_paco_igual` char(1) NOT NULL DEFAULT 'N' COMMENT 'Solo banco orígen=destino',
  `sw_cuenta` char(1) NOT NULL DEFAULT 'N' COMMENT 'Pedir cta. Cli/Prov',
  `sw_remesable` char(1) NOT NULL DEFAULT 'T' COMMENT 'Remesables',
  `sw_norma` char(1) NOT NULL DEFAULT 'N' COMMENT 'Pedir norma remesa',
  `cod_norma` char(3) NOT NULL DEFAULT 'NON' COMMENT 'Norma remesa',
  `filter_caesta` char(250) NOT NULL DEFAULT '' COMMENT 'Filtro estados previos',
  `filter_fpago` char(250) NOT NULL DEFAULT '' COMMENT 'Filtro formas de pago',
  `observaciones` text NOT NULL COMMENT 'Observaciones',
  `cod_cuenta_deudas` char(12) NOT NULL DEFAULT '' COMMENT 'Deudas efectos descontados',
  `cod_cuenta_efectos` char(12) NOT NULL DEFAULT '' COMMENT 'Efectos ciales. descontados',
  `sw_riesgo` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'En riesgo',
  `sw_contab_banco` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Contabiliza banco',
  `sw_agrupa_banco` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'Agrupa apuntes banco',
  `sw_contab_adi` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Contabiliza cuenta adicional <br>(solo si contabiliza banco)',
  `sw_contab_deudas` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Contabiliza deudas efectos',
  `sw_agrupa_deudas` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'Agrupa apts deudas efectos',
  `sw_contab_cuenta` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Contabiliza cuenta',
  `sw_contab_efectos` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Contabiliza efectos ciales.',
  `sw_agrupa_efectos` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'Agrupa apts efectos ciales.',
  `id_tenant` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Nº empresa',
  `sw_contab_comicontra` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Contabiliza comisión banco contraparte',
  `cod_cuenta_comicontra` char(12) NOT NULL DEFAULT '' COMMENT 'Cta.comisión banco contraparte',
  `cod_cuenta_adi` char(12) NOT NULL DEFAULT '' COMMENT 'Cuenta adicional',
  `sw_fecha_postfinan` char(1) NOT NULL DEFAULT 'N' COMMENT 'Pedir fecha post-financiación',
  UNIQUE KEY `key0` (`id_tenant`,`semisoporte`,`cod_caesta`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `cialcartest` WRITE;
/*!40000 ALTER TABLE `cialcartest` DISABLE KEYS */;
INSERT INTO `cialcartest` (`semisoporte`, `cod_caesta`, `nombre`, `nombre_proc`, `sw_activo`, `sw_modificable`, `sw_cta_paco_obli`, `sw_cta_paco_igual`, `sw_cuenta`, `sw_remesable`, `sw_norma`, `cod_norma`, `filter_caesta`, `filter_fpago`, `observaciones`, `cod_cuenta_deudas`, `cod_cuenta_efectos`, `sw_riesgo`, `sw_contab_banco`, `sw_agrupa_banco`, `sw_contab_adi`, `sw_contab_deudas`, `sw_agrupa_deudas`, `sw_contab_cuenta`, `sw_contab_efectos`, `sw_agrupa_efectos`, `id_tenant`, `sw_contab_comicontra`, `cod_cuenta_comicontra`, `cod_cuenta_adi`, `sw_fecha_postfinan`) VALUES ('C','100','Pendiente','Pendientes','S','S','S','N','N','T','N','','','','','','',1,0,1,0,0,1,0,0,1,1,0,'','','N'),('C','210','Impagado','Entrada de Impagados','N','S','N','N','S','T','N','','=520+=900+=910+=920+=930+=940','','','','',1,1,1,2,0,1,2,0,1,1,0,'','','N'),('C','510','Ordenado para pagar','Órdenes de pago','S','N','S','N','N','S','N','','100..299','','','','',1,0,1,0,0,1,0,0,1,1,0,'','','N'),('C','520','Transferido para pagar','Transferencias de pago','S','N','S','N','N','S','S','','100..299','','','','',0,0,1,0,0,1,0,0,1,1,0,'','','N'),('C','530','Remesado como talón','Remesas de talones','N','N','S','N','N','T','N','','100..299','','','','',1,0,1,0,0,1,0,0,1,1,0,'','','N'),('C','540','Remesado como pagaré','Remesas de pagarés','N','N','S','N','N','S','N','','100..299','','','','',1,0,1,0,0,1,0,0,1,1,0,'','','N'),('C','550','Remesado confirming','Remesas de confirming','N','N','S','N','N','T','N','','100..299','','','520700000','400500000',1,0,1,0,2,1,1,0,1,1,0,'','','N'),('C','900','Pagado directamente','Pagos directos','S','N','S','N','S','T','N','','100..299','','','','',0,2,1,1,0,1,1,0,1,1,0,'','','N'),('C','901','Transferido','Transferencias de pago contabilizando','S','N','S','N','N','T','S','','100..299','','','','',0,2,1,1,0,1,1,0,1,1,0,'','','N'),('C','910','Confirmado órden pago','Confirmación de órdenes de Pago','S','N','S','S','N','T','N','','=510','','','','',0,2,1,1,0,1,1,0,1,1,0,'','','N'),('C','920','Confirmada transferencia','Confirmación de transferencias','S','N','S','S','N','T','N','','=520','','','','',0,2,1,1,0,1,1,0,1,1,0,'','','N'),('C','930','Confirmado talón','Confirmación de talones','N','N','S','S','N','T','N','','=530','','','','',0,2,1,1,0,1,1,0,1,1,0,'','','N'),('C','940','Confirmado pagaré','Confirmación de pagarés','N','N','S','S','N','T','N','','=540','','','','',0,2,1,1,0,1,1,0,1,1,0,'','','N'),('C','950','Confirmado confirming','Confirmación de confirmings','N','N','S','S','N','T','N','','=550','','','520700000','400500000',0,2,1,1,1,1,0,0,1,1,0,'','','N'),('V','100','Pendiente','Pendientes','S','S','S','N','N','T','N','','','','','','',1,0,1,0,0,1,0,0,1,1,0,'','','N'),('V','210','Impagado','Entrada de Impagados','S','S','N','N','S','T','N','','=530+=540+=900+=910','','','','',1,2,1,1,0,1,1,0,1,1,0,'','','N'),('V','220','Impagado remesa dto.','Entrada de Impagados de remesas al descuento','S','S','N','N','S','T','N','','=520','','','520800000','431100000',1,2,1,1,1,1,1,2,1,1,0,'','','N'),('V','510','Remesado al cobro','Remesas al cobro','S','N','S','N','N','S','S','','100..299','','','','',1,0,1,0,0,1,0,0,1,1,0,'','','N'),('V','520','Remesado al descuento','Remesas al descuento','S','N','S','N','N','S','S','','100..299','','','520800000','431100000',1,1,1,2,2,1,2,1,1,1,0,'','','N'),('V','530','Remesado como anticipo','Remesas de anticipos bancarios','N','N','S','N','N','S','N','','100..299','','','','',1,1,1,2,0,1,2,0,1,1,0,'','','N'),('V','540','Remesado como pagaré','Remesas de pagarés bancarios','N','N','S','N','N','S','N','','100..299','','','520800000','431100000',1,1,1,2,2,1,2,1,1,1,0,'','','N'),('V','900','Cobrado directamente','Cobros directos','S','N','S','N','S','T','N','','100..299','','','','',0,1,1,2,0,1,2,0,1,1,0,'','','N'),('V','910','Confirmado Remesa cobro','Confirmación de Remesas al cobro','S','N','S','S','N','T','N','','=510','','','','',0,1,1,2,0,1,2,0,1,1,0,'','','N'),('V','920','Confirmado Remesa descuento','Confirmación de Remesas al descuento','S','N','S','S','N','T','N','','=520','','','520800000','431100000',0,0,1,0,1,1,0,2,1,1,0,'','','N'),('V','930','Confirmado Remesa anticipos','Confirmación de Remesas de anticipos','N','N','S','S','N','T','N','','=530','','','','',0,1,1,2,0,1,2,0,1,1,0,'','','N'),('V','940','Confirmado Remesa pagarés','Confirmación de Remesas de pagarés','N','N','S','S','N','T','N','','=540','','','520800000','431100000',0,0,1,0,1,1,0,2,1,1,0,'','','N');
/*!40000 ALTER TABLE `cialcartest` 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:26
