Árvore de páginas

01. DADOS GERAIS

Produto:


TOTVS Backoffice
Linha de Produto:


Linha Protheus
Segmento:


Serviços
Módulo:


TOTVS Backoffice (Linha Protheus) - Automação Fiscal
Função:

FISA170

FISA322

País:Brasil
Ticket:Não há.
Requisito/Story/Issue (informe o requisito relacionado) :DSERTAF2-21877

02. SITUAÇÃO/REQUISITO

  • Para que seja possível gerenciar a lógica de distribuição dos índices por município conforme as particularidades de cada cliente,
    será necessário criar uma nova tela no Configurador de Tributos para cadastrar as regras de apuração do IPM.
  • Deverá haver campos para informar a vigência do cadastro para que quando for realizar a apuração, somente sejam considerados o cadastro que está vigente.

03. SOLUÇÃO

  • Foi criado uma rotina MVC específica para o cadastro das regras de apuração do IPM.


  • O acesso será feito por meio da rotina FISA170, com inclusão da nova opção na treeview do menu do Configurador de Tributos, no seguinte caminho:
    Regras Fiscais \ Regra de IPM \ Cadastro de Regra de IPM (FISA322).

04. DEMAIS INFORMAÇÕES

É necessário aplicar o pacote e rodar o upddistr para criar os seguintes metadados:

  • SX2
X2_CHAVEX2_ARQUIVOX2_NOMEX2_MODOX2_MODOUNX2_MODOEMPX2_UNICOX2_SYSOBJ
CKFCKFT10  Regra de IPM - Rateio         EEECKF_FILIAL+CKF_IDIPM+CKF_UF+CKF_CODIPM+CKF_REGCAL+CKF_CODMUNFISA322
CKECKET10  Regra de IPM - Cadastro       EEECKE_FILIAL+CKE_ID+CKE_UF+CKE_CODIPM+CKE_REGCALFISA322
CKDCKDT10  Cab. Regra de IPM             EEECKD_FILIAL+CKD_ID+CKD_CODREGFISA322
  • SIX
INDICEORDEMCHAVEDESCRICAO
CKF1CKF_FILIAL+CKF_IDIPM+CKF_UF+CKF_CODIPM+CKF_REGCAL+CKF_CODMUN                                                                                                    ID + UF + IPM + Código Regra + Município                              
CKE1CKE_FILIAL+CKE_ID+CKE_UF+CKE_CODIPM+CKE_REGCAL                                                                                                                  ID + UF + IPM + Código Regra                                          
CKD2CKD_FILIAL+CKD_CODREG                                                                                                      Código                                    
CKD1CKD_FILIAL+CKD_ID+CKD_CODREG                                                                                                                                    ID + Código
  • SX3
X3_ARQUIVOX3_ORDEMX3_CAMPOX3_TIPOX3_TAMANHOX3_DECIMALX3_TITULOX3_DESCRICX3_PICTUREX3_VALIDX3_F3
CKF8CKF_RATEION52% Rateio    % Rateio                 @E 99.99                                                                                                                                                                                                           
CKF7CKF_DESCMUC500Descrição   Desc. Municipio          @!                                                                                                                                                                                                                 
CKF6CKF_CODMUNC50Município   Cód. Municipio           @!                                           Vazio() .Or. Fisa322Mun()                                                                                                                                       CC2CKF
CKF5CKF_REGCALC60Código RegraCódigo da Regra          @!                                                                                                                                                                                                                 
CKF4CKF_CODIPMC600IPM         Código de IPM            @!                                                                                                                                                                                                                 
CKF3CKF_UF    C20UF          Unidade Federativa       @!                                           ExistCpo("SX5","12"+M->CKF_UF)                                                                                                                                  12
CKF2CKF_IDIPM C360ID          Identificador Unico      @!                                                                                                                                                                                                                 
CKF1CKF_FILIALC80Filial      Filial                                                                                                                                                                                                                                      
CKE8CKE_CONVLSC10Vl SimbólicoConsidera Valor Simbolico@!                                           Pertence("12")                                                                                                                                                        
CKE7CKE_CONSMUC10Op.MunicípioConsidera Opção Município                                             Pertence("12345")                                                                                                                                                     
CKE6CKE_REGCALC60Código RegraCódigo Regra Tributária  @!                                           Vazio() .Or. ExistCpo("F2B",M->CKE_REGCAL)                                                                                                                      F2B3  
CKE5CKE_DSCIPMC600Decrição    Decrição Código IPM      @!                                                                                                                                                                                                                 
CKE4CKE_CODIPMC600IPM         Código de IPM            @!                                           Vazio() .Or. ExistCpo("CLN",FwFldGet("CKE_UF")+M->CKE_CODIPM)                                                                                                   CLNCKE
CKE3CKE_UF    C20UF          Unidade Federativa       @!                                           Vazio() .Or. ExistCpo('SX5','12'+M->CKE_UF)                                                                                                                     12
CKE2CKE_ID    C360ID          Identificador Unico      @!                                                                                                                                                                                                                 
CKE1CKE_FILIALC80Filial      Filial                                                                                                                                                                                                                                      
CKD6CKD_VIGFIMD80Data Final  Data Final                                                            Vazio() .OR. FwFldGet("CKD_VIGFIM")>=FwFldGet("CKD_VIGINI")                                                                                                           
CKD5CKD_VIGINID80Data Início Data Início                                                                                                                                                                                                                                 
CKD4CKD_DESCR C500Descrição   Descrição                @!                                                                                                                                                                                                                 
CKD3CKD_CODREGC60Código      Código                   @!                                           existchav("CKD")      
CKD2CKD_ID    C360ID          Identificar Unico                                                                                                                                                                                                                           
CKD1CKD_FILIALC80Filial      Filial                                                                                                                                                                                                                                

     

  • SX7
X7_CAMPOX7_SEQUENCX7_REGRAX7_CDOMINX7_TIPOX7_SEEKX7_ALIASX7_ORDEMX7_CHAVEX7_CONDICX7_PROPRI
CKF_CODMUN1Fisa322CC2(FwFldGet("CKE_UF"),FwFldGet("CKF_CODMUN"))                                                                                                                                                   CKF_DESCMUXN   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_USEFILX9_ENABLEX9_VINFILX9_CHVFOR
CKD1CKECKD_IDCKE_IDS1NSS11
CLN1CKECLN_UF+CLN_CODIPM                                                                                                                                                                                                                                         CKE_UF+CKE_CODIPMS1NSS22
F2B1CKEF2B_REGRACKE_REGCALS1NSS22
SX58CKEX5_TABELA+X5_CHAVE12'+CKE_UFS1NSS22
CC21CKFCC2_CODMUNCKF_CODMUNS1NSS22
CKE1CKFCKE_ID+CKE_UF+CKE_CODIPM+CKE_REGCALCKF_IDIPM+CKF_UF+CKF_CODIPM+CKF_REGCALS1NSS11
SX51CKFX5_TABELA+X5_CHAVE12'+CKF_UFS1NSS2

2

  • SXB
XB_ALIASXB_TIPOXB_SEQXB_COLUNAXB_DESCRIXB_DESCSPAXB_DESCENGXB_CONTEM
CLNCKE61                                                              CLN->CLN_UF==FwFldGet("CKE_UF")                                                                                                                                                                                                                           
CLNCKE51                                                              CLN_CODIPM                                                                                                                                                                                                                                                
CLNCKE414Descrição           Descripción                             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                                                                                                                                                                                                                                                       

05. ASSUNTOS RELACIONADOS