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

DROP TABLE IF EXISTS `cialfacedoc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cialfacedoc` (
  `id_cialfacedoc` int(11) NOT NULL DEFAULT '0' COMMENT 'Id. Factura-e',
  `id_cocabe_fv` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Factura',
  `face_version` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'Versión Factura-e',
  `tipo` char(2) NOT NULL DEFAULT 'FC' COMMENT 'Tipo documento',
  `clase` char(2) NOT NULL DEFAULT 'OO' COMMENT 'Clase de factura',
  `desc_text` text NOT NULL COMMENT 'Descripción general',
  `info_text` varchar(40) NOT NULL DEFAULT '' COMMENT 'Información adicional',
  `file_ref` varchar(20) NOT NULL DEFAULT '' COMMENT 'Expediente',
  `receiv_trans` varchar(20) NOT NULL DEFAULT '' COMMENT 'Referencia pedido',
  `receiv_contract` varchar(20) NOT NULL DEFAULT '' COMMENT 'Referencia contrato',
  `legal_text` varchar(250) NOT NULL DEFAULT '' COMMENT 'Literales legales',
  `lugar` varchar(20) NOT NULL DEFAULT 'Sant Vicenç dels Hor' COMMENT 'Lugar expidición',
  `cod_postal` varchar(20) NOT NULL DEFAULT '08620' COMMENT 'Cod Postal',
  `period_ini` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Periodo factura desde',
  `period_fin` date NOT NULL DEFAULT '0000-00-00' COMMENT 'hasta',
  `cod_idioma` char(4) NOT NULL DEFAULT 'ES' COMMENT 'Idioma fra.',
  `dto_fin_desc` text NOT NULL COMMENT 'Concepto dto./fin.',
  `rect_id_cocabe` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Factura rectificada',
  `rect_motivo` char(2) NOT NULL DEFAULT '' COMMENT 'Motivo',
  `rect_desc` text NOT NULL COMMENT 'Texto adicional',
  `rect_exp` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Fecha exped.',
  `rect_ini` date NOT NULL DEFAULT '0000-00-00' COMMENT 'inicio',
  `rect_fin` date NOT NULL DEFAULT '0000-00-00' COMMENT 'final',
  `id_tenant` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Nº empresa',
  UNIQUE KEY `key0` (`id_tenant`,`id_cialfacedoc`),
  UNIQUE KEY `key1` (`id_tenant`,`id_cocabe_fv`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `cialfacedoc` WRITE;
/*!40000 ALTER TABLE `cialfacedoc` DISABLE KEYS */;
INSERT INTO `cialfacedoc` (`id_cialfacedoc`, `id_cocabe_fv`, `face_version`, `tipo`, `clase`, `desc_text`, `info_text`, `file_ref`, `receiv_trans`, `receiv_contract`, `legal_text`, `lugar`, `cod_postal`, `period_ini`, `period_fin`, `cod_idioma`, `dto_fin_desc`, `rect_id_cocabe`, `rect_motivo`, `rect_desc`, `rect_exp`, `rect_ini`, `rect_fin`, `id_tenant`) VALUES (1,401139096317788247,1,'FC','OO','','','','ESCOLA BREÇOL','','','Sant Vicenç dels Hor','08620','0000-00-00','0000-00-00','ES','',0,'','','0000-00-00','0000-00-00','0000-00-00',1),(2,560004091899350046,1,'FC','OO','','','','','','','Sant Vicenç dels Hor','08620','0000-00-00','0000-00-00','ES','',0,'','','0000-00-00','0000-00-00','0000-00-00',1);
/*!40000 ALTER TABLE `cialfacedoc` 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
