-- MySQL dump 10.15  Distrib 10.0.20-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: mkradius
-- ------------------------------------------------------
-- Server version	10.0.20-MariaDB-1~jessie

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `sis_lanc`
--

DROP TABLE IF EXISTS `sis_lanc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sis_lanc` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `datavenc` datetime DEFAULT NULL,
  `nossonum` varchar(64) DEFAULT NULL,
  `datapag` datetime DEFAULT NULL,
  `valorpag` varchar(255) DEFAULT NULL,
  `nome` varchar(16) DEFAULT NULL,
  `valor` varchar(255) DEFAULT NULL,
  `recibo` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT 'aberto',
  `login` varchar(255) DEFAULT NULL,
  `tipo` varchar(255) DEFAULT NULL,
  `cfop_lanc` varchar(8) DEFAULT '5307',
  `obs` varchar(255) DEFAULT NULL,
  `processamento` datetime DEFAULT NULL,
  `aviso` varchar(3) DEFAULT 'nao',
  `url` longtext,
  `coletor` varchar(20) DEFAULT NULL,
  `usergerou` varchar(20) DEFAULT NULL,
  `valorger` varchar(20) DEFAULT 'completo',
  `linhadig` varchar(255) DEFAULT NULL,
  `gwt_numero` varchar(32) DEFAULT NULL,
  `imp` enum('sim','nao') NOT NULL DEFAULT 'nao',
  `referencia` varchar(8) DEFAULT NULL,
  `tipocob` enum('fat','car') NOT NULL DEFAULT 'fat',
  `codigo_carne` varchar(32) DEFAULT NULL,
  `chave_gnet` varchar(32) DEFAULT NULL,
  `chave_gnet2` varchar(32) DEFAULT NULL,
  `chave_juno` varchar(32) DEFAULT NULL,
  `chave_galaxpay` varchar(32) DEFAULT NULL,
  `chave_iugu` varchar(96) DEFAULT NULL,
  `numconta` int(11) DEFAULT NULL,
  `gerourem` tinyint(1) DEFAULT '0',
  `remvalor` decimal(12,2) DEFAULT '0.00',
  `remdata` datetime DEFAULT NULL,
  `formapag` varchar(100) DEFAULT NULL,
  `fcartaobandeira` varchar(100) DEFAULT NULL,
  `fcartaonumero` varchar(32) DEFAULT NULL,
  `fchequenumero` varchar(100) DEFAULT NULL,
  `fchequebanco` varchar(100) DEFAULT NULL,
  `fchequeagcc` varchar(100) DEFAULT NULL,
  `percmulta` decimal(4,2) DEFAULT '0.00',
  `valormulta` decimal(12,2) DEFAULT '0.00',
  `percmora` decimal(4,2) DEFAULT '0.00',
  `valormora` decimal(12,2) DEFAULT '0.00',
  `percdesc` decimal(4,2) DEFAULT '0.00',
  `valordesc` decimal(12,2) DEFAULT '0.00',
  `deltitulo` tinyint(1) DEFAULT '0',
  `datadel` datetime DEFAULT NULL,
  `num_recibos` int(11) DEFAULT '0',
  `num_retornos` int(11) DEFAULT '0',
  `alt_venc` tinyint(1) DEFAULT '0',
  `uuid_lanc` varchar(48) DEFAULT NULL,
  `tarifa_paga` decimal(12,2) DEFAULT '0.00',
  `id_empresa` varchar(16) DEFAULT NULL,
  `oco01` tinyint(1) DEFAULT '0',
  `oco02` tinyint(1) DEFAULT '0',
  `oco06` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `recibo` (`recibo`),
  UNIQUE KEY `id_empresa` (`id_empresa`),
  KEY `codigo_carne` (`codigo_carne`),
  KEY `remvalor` (`remvalor`),
  KEY `status` (`status`),
  KEY `datavenc` (`datavenc`),
  KEY `deltitulo` (`deltitulo`),
  KEY `login` (`login`),
  KEY `nome` (`nome`),
  KEY `uuid_lanc` (`uuid_lanc`),
  KEY `remdata` (`remdata`),
  KEY `alt_venc` (`alt_venc`),
  KEY `oco01` (`oco01`),
  KEY `oco02` (`oco02`),
  KEY `oco06` (`oco06`)
) ENGINE=InnoDB AUTO_INCREMENT=118815 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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-21  7:38:38
