# Leitura de regras da Reforma Tributária

- TBL\_CENARIO – Informações sobre cenários, ou seja, as operações disponíveis;
- TBL\_MATERIAL - Informações de mercadorias;
- TBL\_CENARIO\_MATERIAL\_REFORMA – Relacionamento entre os cenários e as mercadorias;
- TBL\_IMP\_CBS - Tabela principal do CBS (Contribuição sobre Bens e Serviços);
- TBL\_CBS – Tabela com as informações tributárias do CBS;
- TBL\_IMP\_IBS - Tabela principal do IBSUF (Imposto sobre Bens e Serviços Estaduais);
- TBL\_IBS – Tabela com as informações tributárias do IBSUF;
- TBL\_IMP\_IBSMUN - Tabela principal do IBSMUN (Imposto sobre Bens e Serviços Municipais);
- TBL\_IMP\_IS - Tabela principal do IS (Imposto seletivo);
- TBL\_IS - Tabela com as informações tributárias do IS.

Importante: As tabelas de material listadas aqui não são as mesmas do cadastro de produtos, para os dois processos são utilizadas tabelas diferentes.

# Exemplo 1 - Query do IBS

**select**

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">top 100</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cenario.ID\_CENARIO</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">ibsuf\_cst, </span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">ibsuf\_class\_trib</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">ibsuf\_aliq</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">ibsuf\_bc</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">cenario.ID\_CENARIO</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">material.COD\_PROD</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">material.MAT\_ORIGEM</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">ibsuf.imp\_status</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">material.MAT\_STATUS</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;"> </span>

**<span lang="EN-US" style="mso-ansi-language: EN-US;"> </span>**

**from**

<span style="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 CM (NOLOCK)</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">LEFT JOIN TBL\_MATERIAL M (NOLOCK) ON CM.MAT\_CODI = M.MAT\_CODI</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">INNER JOIN TBL\_CENARIO C (NOLOCK) ON CM.CENARIO\_CODI = C.CENARIO\_CODI</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">LEFT JOIN TBL\_IMP\_IBS I1 (NOLOCK) ON CM.CMA\_CODI = I1.CMA\_CODI AND I1.IMP\_ATIV = 1</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">LEFT JOIN TBL\_IBS IBS (NOLOCK) ON I1.IMP\_CODI = IBS.IMP\_CODI</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;"> </span>

**<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">where </span>**

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">material.COD\_PROD='X62002003405'</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cenario.UF\_ORIGEM='SP' AND</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cenario.UF\_DESTINO='SP' AND</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cenario.ORIGEM='3' AND</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cenario.DESTINACAO='3' AND</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">material.MAT\_STATUS='P' AND</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">material.MAT\_ATIVO=1 AND</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cen\_mat.cma\_ativ=1 AND</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">IBSUF.imp\_ativ='1' AND</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">IBSUF.imp\_status='A' </span>

# Exemplo 2 - Query do CBS

**<span style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">select</span>**

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">top 100</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cenario.ID\_CENARIO</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;"> </span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cbs\_cst</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cbs\_class\_trib</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cbs\_aliq</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cbs\_vlr\_aliq\_efetiva</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cbs\_displeg</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cbs\_obs</span>

<span style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cbs.base\_calculo</span>

<span style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cbs\_red\_aliq</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cbs\_inf\_adic</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cred\_cbs\_ind\_cred</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cred\_cbs\_cst\_entr</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cred\_cbs\_perc\_cred</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cred\_cbs\_vig\_de</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cred\_cbs\_vig\_ate</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cred\_cbs\_obs</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cbs\_tribreg\_CSTReg</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cbs\_tribreg\_cClassTribReg</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cbs\_tribreg\_pCBS</span>

<span style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cbs\_tribreg\_baseCalculoReg</span>

<span style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cbs\_tribreg\_pRedAliq</span>

<span style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">credpresu\_cbs\_cCredPres</span>

<span style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">credpresu\_cbs\_pCredPres</span>

<span style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">credpresu\_cbs\_vigenciaDe</span>

<span style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">credpresu\_cbs\_vigenciaAte</span>

<span style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">credpresu\_cbs\_observacoes</span>

**From**

<span style="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 CM (NOLOCK)</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">LEFT JOIN TBL\_MATERIAL M (NOLOCK) ON CM.MAT\_CODI = M.MAT\_CODI</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">INNER JOIN TBL\_CENARIO C (NOLOCK) ON CM.CENARIO\_CODI = C.CENARIO\_CODI</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">LEFT JOIN TBL\_IMP\_CBS I3 (NOLOCK) ON CM.CMA\_CODI = I3.CMA\_CODI</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">LEFT JOIN TBL\_CBS CBS (NOLOCK) ON I3.IMP\_CODI = CBS.IMP\_CODI</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;"> </span>

**<span lang="EN-US" style="mso-ansi-language: EN-US;">where </span>**

<span lang="EN-US" style="mso-ansi-language: EN-US;">material.COD\_PROD='X62002003405'</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">cenario.UF\_ORIGEM='SP' AND</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">cenario.UF\_DESTINO='SP' AND</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">cenario.ORIGEM='3' AND</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">cenario.DESTINACAO='3' AND</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">material.MAT\_STATUS='P' AND</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">material.MAT\_ATIVO=1 AND</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">cen\_mat.cma\_ativ=1 AND</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">IBSUF.imp\_ativ='1' AND</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">IBSUF.imp\_status='A'</span>

# Exemplo 3 - Query do IS

**<span style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">select</span>**

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">is\_cst, </span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">is\_class\_trib</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">is\_aliq </span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">is\_bc</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">is\_displeg</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">cenario.ID\_CENARIO</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">material.COD\_PROD</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">material.MAT\_ORIGEM</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">ibsuf.imp\_status</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">material.MAT\_STATUS</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;"> </span>

**<span lang="EN-US" style="mso-ansi-language: EN-US;">From</span>**

<span lang="EN-US" style="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 CM (NOLOCK)</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">LEFT JOIN TBL\_MATERIAL M (NOLOCK) ON CM.MAT\_CODI = M.MAT\_CODI</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">INNER JOIN TBL\_CENARIO C (NOLOCK) ON CM.CENARIO\_CODI = C.CENARIO\_CODI</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">LEFT JOIN TBL\_IMP\_CBS I3 (NOLOCK) ON CM.CMA\_CODI = I3.CMA\_CODI</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">LEFT JOIN TBL\_CBS CBS (NOLOCK) ON I3.IMP\_CODI = CBS.IMP\_CODI</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;"> </span>

**<span lang="EN-US" style="mso-ansi-language: EN-US;">where </span>**

<span lang="EN-US" style="mso-ansi-language: EN-US;">material.COD\_PROD='X62002003405'</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">cenario.UF\_ORIGEM='SP' AND</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">cenario.UF\_DESTINO='SP' AND</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">cenario.ORIGEM='3' AND</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">cenario.DESTINACAO='3' AND</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">material.MAT\_STATUS='P' AND</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">material.MAT\_ATIVO=1 AND</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">cen\_mat.cma\_ativ=1 AND</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">IBSUF.imp\_ativ='1' AND</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">IBSUF.imp\_status='A'</span>