# Estrutura do banco de dados

Como forma de detalhar o conteúdo de nossas tabelas, este capítulo apresenta a visualização das tabelas internas do nosso sistema, já atualizadas com os tributos da Reforma Tributária.

# Estrutura Tributação Atual

<span style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif; color: windowtext; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">Abaixo iremos detalhar melhor as principais tabelas do sistema que envolve as regras de tributos.</span>

<span style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif; color: windowtext; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">Principais tabelas:</span>

<span style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif; color: windowtext; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">TBL\_CENARIO, TBL\_MATERIAL, TBL\_CENARIO\_MATERIAL, TBL\_IMP\_ICMS, TBL\_ICMS, TBL\_IMP\_IPI, TBL\_IPI, TBL\_IMP\_PIS\_COFINS, TBL\_PIS\_COFINS.</span>

<span style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif; color: windowtext; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">A tabela TBL\_CENARIO\_MATERIAL é responsável pela vinculação do cenário com o material onde consideramos esse registro em uma regra de tributos.</span>

<span style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif; color: windowtext; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">[![05 - Estrutura Trib. Atual_001.png](https://documentacao.systax.com.br/uploads/images/gallery/2025-07/scaled-1680-/05-estrutura-trib-atual-001.png)](https://documentacao.systax.com.br/uploads/images/gallery/2025-07/05-estrutura-trib-atual-001.png)</span>

<span style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">Essa regra que é criada na tabela TBL\_CENARIO\_MATERIAL é vinculada nas tabelas de tributos.</span>

[![image.png](https://documentacao.systax.com.br/uploads/images/gallery/2025-07/scaled-1680-/69bimage.png)](https://documentacao.systax.com.br/uploads/images/gallery/2025-07/69bimage.png)

<span style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">Essas tabelas de tributos são para controlar a validação individual de cada tributo, através dessas tabelas existem as tabelas com todos os campos do tributo.</span>

<span style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">[![05 - Estrutura Trib. Atual_003.png](https://documentacao.systax.com.br/uploads/images/gallery/2025-07/scaled-1680-/05-estrutura-trib-atual-003.png)](https://documentacao.systax.com.br/uploads/images/gallery/2025-07/05-estrutura-trib-atual-003.png)</span>

<span style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">Então conseguimos chegar a todas as informações necessárias da regra através da tabela TBL\_CENARIO\_MATERIAL.</span>

# Estrutura Reforma Tributária

<span style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">As principais tabelas são:</span>

- <span style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">TBL\_CENARIO\_MATERIAL\_REFORMA</span>
- <span lang="EN-US" style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">TBL\_IMP\_CBS</span>
- <span lang="EN-US" style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">TBL\_CBS</span>
- <span lang="EN-US" style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">TBL\_IMP\_IBS</span>
- <span lang="EN-US" style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">TBL\_IBS</span>
- <span lang="EN-US" style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">TBL\_IMP\_IBSMUN</span>
- <span lang="EN-US" style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">TBL\_IMP\_IS</span>
- <span style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">TBL\_IS</span>

<span style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">Tabelas já utilizadas nas Regras</span>

- <span style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">TBL\_MATERIAL</span>
- <span style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">TBL\_CENARIO</span>

<span style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">A tabela TBL\_CENARIO\_MATERIAL\_REFORMA é responsável pela vinculação do cenário com o material onde consideramos esse registro em uma regra de tributos.</span>

<span style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">[![06 - Estrutura RT_001.png](https://documentacao.systax.com.br/uploads/images/gallery/2025-07/scaled-1680-/06-estrutura-rt-001.png)](https://documentacao.systax.com.br/uploads/images/gallery/2025-07/06-estrutura-rt-001.png)</span>

<span style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">Essa regra que é criada na tabela TBL\_CENARIO\_MATERIAL\_REFORMA é vinculada nas tabelas de tributos, conforme pode visualizar na figura abaixo.</span>

<span style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">[![06 - Estrutura RT_002.png](https://documentacao.systax.com.br/uploads/images/gallery/2025-07/scaled-1680-/06-estrutura-rt-002.png)](https://documentacao.systax.com.br/uploads/images/gallery/2025-07/06-estrutura-rt-002.png)</span>

<span style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">Essas tabelas de tributos são para controlar a validação individual de cada tributo, através dessas tabelas existem as tabelas com todos os campos do tributo.</span>

<span style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">Então conseguimos chegar a todas as informações necessárias da regra através da tabela TBL\_CENARIO\_MATERIAL\_REFORMA</span>