01. Visão Geral

O Índice de Participação por Município (IPM) é um controle efetuado pelas Secretarias da Fazenda Estadual (SEFAZ) para identificar o montante de operações realizadas em cada município,
com o propósito de realizar uma melhor distribuição do imposto recolhido para os municípios de seu território. Essas informações são apresentadas no registro 1400 da EFD ICMS/IPI.
Essa funcionalidade permite rastrear quais os valores divididos para cada município e identificar (via relatório) como o sistema chegou nesses valores, trazendo informações dos documentos fiscais e das regras utilizadas.
O objetivo da rotina de apuração é que seja personalizável, permitindo que o cliente consiga configurar e montar as regras de geração do registro 1400 de acordo com sua movimentação.

02. Pré-Condições

2.0 Código de item para IPM ( CLN )

Importar os códigos do IPM por UF, na rotina Índice de Part. dos Municipios (FISA094).
https://www.sped.fazenda.gov.br/spedtabelas/AppConsulta/publico/aspx/ConsultaTabelasExternas.aspx?CodSistema=SpedFiscal


 As notas que serão consideradas no filtro de apuração devem possuir incidência de ICMS e o imposto criado no Configurador de Tributos.


          Exemplo de nota que será considerada na apuração:

OBS: No exemplo abaixo criamos o imposto IPM e iremos utilizá-lo na regra e apuração do IPM.


2.1  Criação do Tributo Genérico 

         Incluir no configurador de tributos o imposto que será utilizado na identificação das operações que serão considerados na apuração do IPM. No exemplo utilizamos a nomenclatura IPM. 

          --------- link da DOC do configurador

          Realizar o cadastro levando em consideração os itens abaixo:

              -  Perfil de Produto , Operação, Participante, Origem- Destino.

              -  Regra de Base de Cálculo,  Alíquota , Escrituração.

2.2 Cadastro Código IPM ( CKD \ CKE \ CKD )

           

            

               

            O cadastro da regra deve ser preenchido:

            Código:

            Descrição:   

            Data início e Data Final:  

            Na aba IPM deve ser preenchido:

            UF: Informar a UF que deseja utilizar na regra de cálculo do IPM, pode cadastrar mais de uma UF em um único cadastro.   

            IPM: Escolher o código da DIPAM que foi importado na rotina (FISA094).

            Descrição: Descrição do código da DIPAM

            Código Regra: Escolher o código de regra que foi cadastrado na Regra de Cálculo - Documentos Fiscais  

            Op. Município:

              1- Município Origem:

              2- Município Destino:

              3- Município Participante:

              4- Município Contribuinte:

              5- Rateio:

            Vl. Simbólico: Inclui o valor simbólico de 0,01 quando não houver operações.

            Na aba Rateio:

           

           

             


2.3 Perfil de Produto ( F20 \ F24 )

2.4 Perfil de Operação ( F20 \ F23  )

2.5 Perfil de Participante ( F20 \ F22 )

2.6 Perfil de Origem - Destino ( F20 \ F21 )

2.7 Regra Base de Cálculo  ( F27 )

2.8 Regra Alíquota ( F28 )

2.9 Regra Escrituração ( CJ2 )

2.10 Regra Apuração ( F2G )

2.11 Regra Cálculo Documento Fiscal ( F2B )

2.12 Cadastro Código IPM ( CKD \ CKE \ CKD )


        

03. Apuração

Acessar o Configurador de tributos (FISA170) \ Regras Fiscais \ Apuração \ Apuração de IPM ( FISA325 ).
Ao clicar em processar será necessário selecionar a filial onde será gravado a apuração, essa filial será considerada a filial centralizadora.



Posteriormente será necessário informar a data inicial e final, caso seja necessário apurar movimento de várias filiais para consolidar na centralizadora, marque seleciona filial com a opção 1 - Sim,
se for necessário marcar apenas as filiais selecionadas com a mesma raiz, habilite o campo Agrupo CNPJ + IE = 1 - Sim,
por fim, escolha se irá considerar os código IPMs da tabela CNL com o tipo mensal ou anual.

Na tabela abaixo, marque o tributo genérico de IPM que foi vinculado a regra de código IPM no cadastro do código IPM ( FISA322 ), pois servirá de filtro, caso haja necessidade de apurar parcial,
se existir mais de um tributo genérico de IPM.


Clique em avançar. Se houver êxito, será exibido a mensagem "Apuração concluída com sucesso!".


Posteriormente será exibido a tela com os dados apurados.

3.1 Regra 01 – Consolidação da Apuração

Consolida os movimentos utilizando os seguintes critérios:

Com base em:

Essa definição será utilizada para aplicar filtros e realizar a apuração dos movimentos.

3.2 Regra 02 – Reprocessamento da Apuração

3.3 Regra 03 – Considera município


3.4 Regra 04 - Rateio da Apuração

3.5 Regra 05 – Tipo de Período (Mensal / Anual)

3.6 Regra 06 – Valor Simbólico

3.7 Regra 07 – Filtragem por Tipo de Apuração


04. RELATÓRIO

05. DICIONÁRIO DE DADOS


SIX

INDICEORDEMCHAVEDESCRICAO
CKI1CKI_FILIAL+CKI_IDDETA+CKI_IDUNIQID Det. Apur + ID Único
CKH1CKH_FILIAL+CKH_IDAPUR+CKH_UF+CKH_DIPAM+CKH_CODMUNID Apuracao + UF + Cod. Dipam + Cod. Municip
CKG2CKG_FILIAL+DTOS(CKG_DTINI)+DTOS(CKG_DTFIM)Data Inicial + Data Final
CKG1CKG_FILIAL+CKG_IDID
CKF1CKF_FILIAL+CKF_IDIPM+CKF_UF+CKF_CODIPM+CKF_CODMUNID + UF + IPM + Município
CKE1CKE_FILIAL+CKE_ID+CKE_UF+CKE_CODIPM+CKE_REGCALID + UF + IPM + Código Regra
CKD2CKD_FILIAL+CKD_CODREGCódigo
CKD1CKD_FILIAL+CKD_ID+CKD_CODREGID + Código


SX2

X2_CHAVEX2_ARQUIVOX2_NOMEX2_UNICOX2_MODOX2_MODOUNX2_MODOEMPX2_SYSOBJ
CKICKIT10  Apuração de IPM - Relatório   CKI_FILIAL+CKI_IDDETA+CKI_IDUNIQEEE                                                                                                    
CKHCKHT10  Apuração de IPM - DetalhamentoCKH_FILIAL+CKH_IDAPUR+CKH_UF+CKH_DIPAM+CKH_CODMUNEEEFISA325                                                                                             
CKGCKGT10  Apuração de IPM - Cabecalho   CKG_FILIAL+CKG_IDEEEFISA325                                                                                             
CKFCKFT10  Regra de IPM - Rateio         CKF_FILIAL+CKF_IDIPM+CKF_UF+CKF_CODIPM+CKF_CODMUNEEEFISA322                                                                                             
CKECKET10  Regra de IPM - Cadastro       CKE_FILIAL+CKE_ID+CKE_UF+CKE_CODIPM+CKE_REGCALEEEFISA322                                                                                             
CKDCKDT10  Cab. Regra de IPM             CKD_FILIAL+CKD_ID+CKD_CODREGEEEFISA322                                                                                             


SX3

X3_ARQUIVOX3_ORDEMX3_CAMPOX3_TIPOX3_TAMANHOX3_DECIMALX3_TITULOX3_PICTUREX3_F3X3_BROWSEX3_VISUALX3_CONTEXT
CKI32CKI_CODFORC60Cod. Fornec.@!                                           FOR   SAR
CKI31CKI_CODCLIC60Cod. Cliente@!                                           SA1   SAR
CKI30CKI_FORNECC500Nome Fornec @!                                                 NVR
CKI29CKI_CLIENTC600Nome Cliente@!                                                 NVR
CKI28CKI_VLTRIBN142Vlr. Tributo@E 99,999,999,999.99                               NVR
CKI27CKI_ALIQ  N106Aliq Aplica @E 999.999999                                      NVR
CKI26CKI_BSECALN142Base Calc   @E 99,999,999,999.99                               NVR
CKI25CKI_VLTOT N162Vlr. Total  @E 9,999,999,999,999.99                            SVR
CKI24CKI_VLCONTN142Vlr.Contabil@E 99,999,999,999.99                               NVR
CKI23CKI_MUNDESC600Munic. Dest @!                                                 NVR
CKI22CKI_UFDESTC20UF Destino  @!                                           12NVR
CKI21CKI_MUNORIC600Munic Origem@!                                                 NVR
CKI20CKI_UFORIGC20UF de Origem@!                                           12NVR
CKI19CKI_MUNPARC600Munic Partic@!                                                 NVR
CKI18CKI_UFPARTC20UF Partic   @!                                           12NVR
CKI17CKI_LOJA  C20Loja        @!                                                 NVR
CKI16CKI_UFNOTAC20UF Emi/Des  @!                                           12NVR
CKI15CKI_DTEMISD80DT. Emissao                                                    NVR
CKI14CKI_DTENT D80DT.Ent. Doc                                                    NVR
CKI13CKI_ITEM  C40Item        @!                                                 NVR
CKI12CKI_TPMOV C10Tp.Movimento@!                                                 NVR
CKI11CKI_SERIE C30Serie       !!!                                                NVR
CKI10CKI_NF    C90NF          @!                                                 NVR
CKI9CKI_CODTRIC60Cod. Tributo@!                                                 NAR
CKI8CKI_REGAPUC60Reg/Proc Apu@!                                                 NVR
CKI7CKI_CODMUNC600Cod. Municip@!                                                 NAR
CKI6CKI_FILDOCC80Filial Doc                                                     NAR
CKI5CKI_CODIPMC600Cod. IPM    @!                                                 NVR
CKI4CKI_UFDOC C20UF documento@!                                           12NVR
CKI3CKI_IDUNIQC360ID Único    @!                                                 NAR
CKI2CKI_IDDETAC360ID Det. Apur@!                                                 NVR
CKI1CKI_FILIALC80Filial                                                         NVR
CKH9CKH_DSCDIPC800Descr. Dipam@!                                                 NVV
CKH8CKH_TIPO  C10Tipo        @!                                                 NVR
CKH7CKH_VLRADCN142Vlr. Adic   @E 99,999,999,999.99                               NVR
CKH6CKH_MUNICIC600Município   @!                                                 NVR
CKH5CKH_CODMUNC50Cod. Municip@!                                                 NAR
CKH4CKH_DIPAM C600Cod. Dipam  @!                                                 NVR
CKH3CKH_UF    C20UF          @!                                                 NVR
CKH2CKH_IDAPURC360ID Apuracao @!                                                 NAR
CKH1CKH_FILIALC80Filial                                                         NVR
CKG4CKG_DTFIM D80Data Final                                                     SVR
CKG3CKG_DTINI D80Data Inicial                                                   SVR
CKG2CKG_ID    C360ID          @!                                                 NVR
CKG1CKG_FILIALC80Filial                                                         SVR
CKF7CKF_RATEION52% Rateio    @E 99.99                                           SAR
CKF6CKF_DESCMUC600Descrição   @!                                                 SVR
CKF5CKF_CODMUNC50Município   @!                                           CC2CKFSAR
CKF4CKF_CODIPMC600IPM         @!                                                 SAR
CKF3CKF_UF    C20UF          @!                                           12SAR
CKF2CKF_IDIPM C360ID          @!                                                 SAR
CKF1CKF_FILIALC80Filial                                                         SAR
CKE9CKE_IDF2B C360ID Reg Calc @!                                                 NAR
CKE8CKE_CONVLSC10Vl Simbólico@!                                                 SAR
CKE7CKE_CONSMUC10Op.Município@!                                                 SAR
CKE6CKE_REGCALC60Código Regra@!                                           F2B3  SAR
CKE5CKE_DSCIPMC600Decrição    @!                                                 SVR
CKE4CKE_CODIPMC600IPM         @!                                           CLNCKESAR
CKE3CKE_UF    C20UF          @!                                           12SAR
CKE2CKE_ID    C360ID          @!                                                 SAR
CKE1CKE_FILIALC80Filial                                                         SVR
CKD6CKD_VIGFIMD80Data Final                                                     SAR
CKD5CKD_VIGINID80Data Início                                                    SAR
CKD4CKD_DESCR C500Descrição   @!                                                 SAR
CKD3CKD_CODREGC60Código      @!                                                 SAR
CKD2CKD_ID    C360ID          @!                                                 NVR
CKD1CKD_FILIALC80Filial                                                         SVR


SX7

X7_CAMPOX7_SEQUENCX7_REGRAX7_CDOMINX7_TIPOX7_SEEKX7_ALIASX7_ORDEMX7_CHAVEX7_PROPRI
CKF_CODMUN1Fisa322CC2(FwFldGet("CKE_UF"),FwFldGet("CKF_CODMUN"))                                                                                                                                                   CKF_DESCMUXN   0                                                                                                                                                                                                        S
CKE_REGCAL1F2B->F2B_ID                                                                                                                                                                                             CKE_IDF2B PN   0                                                                                                                                                                                                        S
CKE_CODIPM1SUBSTR(CLN->CLN_DSCIPM,1,60)                                                                                                                                                                            CKE_DSCIPMPSCLN1XFILIAL("CLN")+FwFldGet("CKE_UF")+FwFldGet("CKE_CODIPM")                                                                                                                                                S


SX9

X9_DOMX9_IDENTX9_CDOMX9_EXPDOMX9_EXPCDOMX9_PROPRIX9_LIGDOMX9_LIGCDOMX9_CONDSQLX9_USEFILX9_ENABLEX9_VINFILX9_CHVFOR
SX58CKEX5_TABELA+X5_CHAVE'12'+CKE_UF                                                                                                                                                                                                                                               S1N                                                                                                                                                                                                                                                          SS22
SX57CKIX5_TABELA+X5_CHAVE'12'+CKI_UFDEST                                                                                                                                                                                                                                           S1N                                                                                                                                                                                                                                                          SS22
SX56CKIX5_TABELA+X5_CHAVE'12'+CKI_UFORIG                                                                                                                                                                                                                                           S1N                                                                                                                                                                                                                                                          SS22
SX55CKIX5_TABELA+X5_CHAVE'12'+CKI_UFPART                                                                                                                                                                                                                                           S1N                                                                                                                                                                                                                                                          SS22
SX54CKIX5_TABELA+X5_CHAVE'12'+CKI_UFNOTA                                                                                                                                                                                                                                           S1N                                                                                                                                                                                                                                                          SS22
SX53CKIX5_TABELA+X5_CHAVE'12'+CKI_UFDOC                                                                                                                                                                                                                                            S1N                                                                                                                                                                                                                                                          SS22
SX52CKHX5_TABELA+X5_CHAVE'12'+CKH_UF                                                                                                                                                                                                                                               S1N                                                                                                                                                                                                                                                          SS22
SX51CKFX5_TABELA+X5_CHAVE'12'+CKF_UF                                                                                                                                                                                                                                               S1N                                                                                                                                                                                                                                                          SS22
SA21CKIA2_COD+A2_LOJACKI_CODFOR+CKI_LOJA                                                                                                                                                                                                                                       S1N                                                                                                                                                                                                                                                          SS22
SA11CKIA1_COD+A1_LOJACKI_CODCLI+CKI_LOJA                                                                                                                                                                                                                                       S1N                                                                                                                                                                                                                                                          SS22
F2B1CKEF2B_REGRACKE_REGCAL                                                                                                                                                                                                                                                S1N                                                                                                                                                                                                                                                          SS22
CLN1CKECLN_UF+CLN_CODIPMCKE_UF+CKE_CODIPM                                                                                                                                                                                                                                         S1N                                                                                                                                                                                                                                                          SS22
CKG1CKHCKG_IDCKH_IDAPUR                                                                                                                                                                                                                                                S1N                                                                                                                                                                                                                                                          SS11
CKE1CKFCKE_ID+CKE_UF+CKE_CODIPMCKF_IDIPM+CKF_UF+CKF_CODIPM                                                                                                                                                                                                                               S1N                                                                                                                                                                                                                                                          SS11
CKD1CKECKD_IDCKE_ID                                                                                                                                                                                                                                                    S1N                                                                                                                                                                                                                                                          SS11
CC22CKHCC2_CODMUNCKH_CODMUN                                                                                                                                                                                                                                                S1N                                                                                                                                                                                                                                                          SS22
CC21CKFCC2_CODMUNCKF_CODMUN                                                                                                                                                                                                                                                S1N                                                                                                                                                                                                                                                          SS22


SXB

XB_ALIASXB_TIPOXB_SEQXB_COLUNAXB_DESCRIXB_DESCSPAXB_DESCENGXB_CONTEM
CLNCKE61                                                              CLN->CLN_UF==FwFldGet("CKE_UF")                                                                                                                                                                                                                           
CLNCKE51                                                              CLN_CODIPM                                                                                                                                                                                                                                                
CLNCKE414Descrição           Descripción         Description         CLN_DSCIPM                                                                                                                                                                                                                                                
CLNCKE413Código IPM          Código IPM          IPM Code            CLN_CODIPM                                                                                                                                                                                                                                                
CLNCKE412Dt Final            Fch. Final          End Date            CLN_DTFIMV                                                                                                                                                                                                                                                
CLNCKE411Dt Início           Fch. Inicial        Start Date          CLN_DTINIV                                                                                                                                                                                                                                                
CLNCKE211Filial+estado+codigoSuc+E/P/R+Código    Branch+State+Code                                                                                                                                                                                                                                                             
CLNCKE11DBInd.Partic.Munic.   Ind.Partic.Munic.   City Partic. Ind.   CLN                                                                                                                                                                                                                                                       
CC2CKF61                                                              CC2->CC2_EST==FwFldGet("CKE_UF")                                                                                                                                                                                                                          
CC2CKF51                                                              CC2_CODMUN                                                                                                                                                                                                                                                
CC2CKF426Municipio           Municipio           City                CC2_MUN                                                                                                                                                                                                                                                   
CC2CKF425Cod. IBGE           Cód. IBGE           IBGE Code           CC2_CODMUN                                                                                                                                                                                                                                                
CC2CKF424Estado              Est/Prov/Reg        State               CC2_EST                                                                                                                                                                                                                                                   
CC2CKF413Municipio           Municipio           City                CC2_MUN                                                                                                                                                                                                                                                   
CC2CKF412Cod. IBGE           Cód. IBGE           IBGE Code           CC2_CODMUN                                                                                                                                                                                                                                                
CC2CKF411Estado              Est/Prov/Reg        State               CC2_EST                                                                                                                                                                                                                                                   
CC2CKF222Codigo Ibge         Código IBGE         IBGE Code                                                                                                                                                                                                                                                                     
CC2CKF211Municipio           Municipio           City                                                                                                                                                                                                                                                                          
CC2CKF11DBMunicipio Rateio    Municipio Prorrateo Apportionment City  CC2                                                                                                                                                                                                                                                       


06. DEMAIS INFORMAÇÕES

Implementação cadastro Código IPM

Implementação da tela de apuração

Implementação do relatório SmartView (IPM)