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

DROP TABLE IF EXISTS `cialtrafimo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cialtrafimo` (
  `id_cialtrafimo` int(11) NOT NULL DEFAULT '0' COMMENT 'Nº Importación',
  `id_cialtrafpai` int(11) NOT NULL DEFAULT '0' COMMENT 'Parámetros',
  `id_cialtrafent` int(11) NOT NULL DEFAULT '0' COMMENT 'Entidad',
  `sw_preparar` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Preparar',
  `sw_api` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Tipo',
  `char_delimiter` char(1) NOT NULL DEFAULT ',' COMMENT 'Separa cols',
  `char_enclosure` char(1) NOT NULL DEFAULT '' COMMENT 'Delimita cols',
  `char_decimal` char(1) NOT NULL DEFAULT '' COMMENT 'Separa decims',
  `num_decimal` char(1) NOT NULL DEFAULT '2' COMMENT 'Nº decimales',
  `id_reg` char(5) NOT NULL DEFAULT '' COMMENT 'Lectura regs. tipo',
  `lin_inicio` int(11) NOT NULL DEFAULT '5' COMMENT 'Empezar línea',
  `lin_account` int(11) NOT NULL DEFAULT '0' COMMENT 'Línea cuenta',
  `col_account` int(11) NOT NULL DEFAULT '0' COMMENT 'Columna cuenta',
  `col_reg` int(11) NOT NULL DEFAULT '0' COMMENT 'Col. Registros',
  `col_trans` int(11) NOT NULL DEFAULT '0' COMMENT 'Col. Transacción',
  `col_code` int(11) NOT NULL DEFAULT '0' COMMENT 'Col. Cód.Transacción',
  `col_date` int(11) NOT NULL DEFAULT '0' COMMENT 'Col. Fecha',
  `col_update` int(11) NOT NULL DEFAULT '0' COMMENT 'Col. Ult. Modif',
  `col_credit` int(11) NOT NULL DEFAULT '0' COMMENT 'Col. Cred/Deb',
  `col_cart` int(11) NOT NULL DEFAULT '0' COMMENT 'Col. ID Venta',
  `col_invoice` int(11) NOT NULL DEFAULT '0' COMMENT 'Col. ID Factura',
  `col_customer` int(11) NOT NULL DEFAULT '0' COMMENT 'Col. ID Cliente',
  `col_payment` int(11) NOT NULL DEFAULT '0' COMMENT 'Col. ID Pago',
  `col_store` int(11) NOT NULL DEFAULT '0' COMMENT 'Col. ID Tienda',
  `col_bank` int(11) NOT NULL DEFAULT '0' COMMENT 'Col. ID Banco',
  `col_impo_bru` int(11) NOT NULL DEFAULT '0' COMMENT 'Col. Imp. Bruto',
  `col_mone_bru` int(11) NOT NULL DEFAULT '0' COMMENT 'Col. Div.Imp.Bru.',
  `col_cred_bru` int(11) NOT NULL DEFAULT '0' COMMENT 'Col. C/D Imp.Bru.',
  `col_impo_fee` int(11) NOT NULL DEFAULT '0' COMMENT 'Col. Imp.Tarifa',
  `col_mone_fee` int(11) NOT NULL DEFAULT '0' COMMENT 'Col. Div.Tarifa',
  `col_cred_fee` int(11) NOT NULL DEFAULT '0' COMMENT 'Col. C/D Tarifa',
  `col_impo_ins` int(11) NOT NULL DEFAULT '0' COMMENT 'Col. Imp.Seguro',
  `col_mone_ins` int(11) NOT NULL DEFAULT '0' COMMENT 'Col. Div.Seguro',
  `col_impo_shi` int(11) NOT NULL DEFAULT '0' COMMENT 'Col. Imp.Envío',
  `col_mone_shi` int(11) NOT NULL DEFAULT '0' COMMENT 'Col. Div.Envío',
  `sw_preparar_done` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Preparado',
  `fecha_cre` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Fecha creación',
  `hora_cre` time NOT NULL DEFAULT '00:00:00' COMMENT 'Hora creación',
  `id_tenant` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Nº empresa',
  `fec_desde` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Fec. desde',
  `fec_hasta` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Fec. hasta',
  `request_url` text NOT NULL COMMENT 'URL',
  `request_query` text NOT NULL COMMENT 'Query Petición',
  `size` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Reg. x pag.',
  `req_trans` text NOT NULL COMMENT 'ID externo Transacción',
  `req_code` text NOT NULL COMMENT 'Código Transacción',
  `req_date` text NOT NULL COMMENT 'Fecha Transacción',
  `req_hour` text NOT NULL COMMENT 'Hora Transacción',
  `req_update` text NOT NULL COMMENT 'Fecha Ult. Modif',
  `req_cart` text NOT NULL COMMENT 'ID Venta',
  `req_invoice` text NOT NULL COMMENT 'ID Factura',
  `req_customer` text NOT NULL COMMENT 'ID Cliente',
  `req_payment` text NOT NULL COMMENT 'ID Pago',
  `req_store` text NOT NULL COMMENT 'ID Tienda',
  `req_bank` text NOT NULL COMMENT 'ID Banco',
  `req_impo_bru` text NOT NULL COMMENT 'Imp. Bruto',
  `req_mone_bru` text NOT NULL COMMENT 'Div.Imp.Bru.',
  `req_cred_bru` text NOT NULL COMMENT 'C/D Imp.Bru.',
  `req_impo_fee` text NOT NULL COMMENT 'Imp.Fee',
  `req_mone_fee` text NOT NULL COMMENT 'Div.Fee',
  `req_cred_fee` text NOT NULL COMMENT 'C/D Fee',
  `req_impo_ins` text NOT NULL COMMENT 'Imp.Seguro',
  `req_mone_ins` text NOT NULL COMMENT 'Div.Seguro',
  `req_impo_shi` text NOT NULL COMMENT 'Imp.Envío',
  `req_mone_shi` text NOT NULL COMMENT 'Div.Envío',
  `widget_parms` text NOT NULL COMMENT 'Parámetros',
  `auth_url` text NOT NULL COMMENT 'URL',
  `auth_header` text NOT NULL COMMENT 'Basic Auth',
  `auth_response` text NOT NULL COMMENT 'Response',
  `request_header` text NOT NULL COMMENT 'Headers',
  `response_filter` text NOT NULL COMMENT 'Filtro Respuesta',
  `sw_response` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Almacenar respuesta',
  `request_response` longtext NOT NULL COMMENT 'Requests Response',
  `map_req` text NOT NULL COMMENT 'Mapeo peticiones',
  `valid` text NOT NULL COMMENT 'Regla validación mov.',
  `sw_insert` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'Movs. inválidos',
  `req_date_2` text NOT NULL COMMENT 'Fecha 2 Transacción',
  `req_hour_2` text NOT NULL COMMENT 'Hora 2 Transacción',
  `req_description` text NOT NULL COMMENT 'Descripción Transacción',
  `req_creditor_name` text NOT NULL COMMENT 'Nombre acreedor',
  `req_debtor_name` text NOT NULL COMMENT 'Nombre deudor',
  `dispute_request` text NOT NULL COMMENT 'Petición disputa',
  `dispute_date` text NOT NULL COMMENT 'Fecha Disputa',
  `dispute_hour` text NOT NULL COMMENT 'Hora Disputa',
  `dispute_id` text NOT NULL COMMENT 'ID externo de disputa',
  `dispute_code` text NOT NULL COMMENT 'Código Disputa',
  `dispute_status` text NOT NULL COMMENT 'Estado Disputa',
  `dispute_refundable` text NOT NULL COMMENT 'Disputa Reembolsable',
  `dispute_impo_bru` text NOT NULL COMMENT 'Importe Disputa',
  `dispute_mone_bru` text NOT NULL COMMENT 'Moneda Disputa',
  `map_dispute` text NOT NULL COMMENT 'Mapeo disputas',
  `request_method` char(20) NOT NULL DEFAULT 'query' COMMENT 'Method',
  `response_context` text NOT NULL COMMENT 'Contexto Respuesta',
  `req_imp_balance` text NOT NULL COMMENT 'Balance',
  `req_status` text NOT NULL COMMENT 'Status',
  UNIQUE KEY `key0` (`id_tenant`,`id_cialtrafimo`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `cialtrafimo` WRITE;
/*!40000 ALTER TABLE `cialtrafimo` DISABLE KEYS */;
/*!40000 ALTER TABLE `cialtrafimo` 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:01
