-- generated by export_tables.php on 2025-12-02 16:02:03
-- source: ip.sysfar.com.br/gtsyscon_gtsys -> table: gtsys_ibs_cbs_class

create table gtsys_ibs_cbs_class
(
  `codigo` int(11) NOT NULL AUTO_INCREMENT,
  `cod_ibscbs` char(3) COLLATE utf8mb4_unicode_ci NOT NULL,
  `descicao` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ctrib` char(6) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nome_ctrib` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `desc_ctrib` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lc_redacao` text COLLATE utf8mb4_unicode_ci,
  `lc_21425` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `al_ibscbs` int(11) DEFAULT NULL,
  `percr_ibs` int(11) DEFAULT NULL,
  `percr_cbs` int(11) DEFAULT NULL,
  `ind_bc` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ind_tribr` tinyint(1) DEFAULT NULL,
  `ind_crepre` tinyint(1) DEFAULT NULL,
  `ind_mono` tinyint(1) DEFAULT NULL,
  `ind_monorn` tinyint(1) DEFAULT NULL,
  `ind_monort` tinyint(1) DEFAULT NULL,
  `ind_monodi` tinyint(1) DEFAULT NULL,
  `data_ini` date DEFAULT NULL,
  `data_fim` date DEFAULT NULL,
  `data_atu` date DEFAULT NULL,
  PRIMARY KEY (`codigo`)
)ENGINE=InnoDB AUTO_INCREMENT=133 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

