01. DADOS GERAIS

Produto:


Linha de Produto:


Segmento:


Módulo:


Função:

FISA170

FISA322

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

02. SITUAÇÃO/REQUISITO

03. SOLUÇÃO

04. DEMAIS INFORMAÇÕES

Necessário aplicar o pacote e rodar o upddistr para criar os seguintes

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
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
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                                                                                                                                                                                                                                

     

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
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

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