Tabela C5F - Contr.Crd PIS/PASEP/COFINS


Rotina (SysObj): TAFA081

Chave Unica: C5F_FILIAL + C5F_ID


Sumario:


Campos

Campo Titulo Descricao Tipo Contexto Tamanho
C5F_FILIAL Filial Filial C Real 2
C5F_ID ID Identificador Registro C Real 6
C5F_TPTRIB Tipo Trib. Tipo do Tributo C Real 1
C5F_PERIOD Data Movto Data do Movimento Decl. D Real 8
C5F_PERAPR Per.Ap.Crd Per. Apuracao do Credito C Real 6
C5F_ORCRE Ind.Org.Crd Ind.Origem.Credito C Real 2
C5F_CNPJ CNPJ Ced.Crd CNPJ Cedente Credito C Real 14
C5F_CDCRE Cod.Tp.Crdto Codigo do Tipo do Credito C Real 6
C5F_DCDCR Des.Tp.Crdto Desc. Tipo do Credito C Virtual 220
C5F_VLCRAP Vlr.Crd.Apur Vlr.Crdto.Apur N Real 16, 2
C5F_VLCREX Vlr.Crd.Ext. Vlr.Crd.Extemp. N Real 16, 2
C5F_TCRAPU Vl.Cred.Apur Tot.Crdto.Apurado N Real 16, 2
C5F_VLCRDS VlrCrdDesAnt Vlr.Crd.Descont.PAnterior N Real 16, 2
C5F_VCRRAN VlCrdResAnt Vl.Crd.Ressarc.Per.Ant. N Real 16, 2
C5F_VCRCAN VlCrdCompAnt Vlr.Crd.Comp.Per.Ant N Real 16, 2
C5F_SLCDIS Sld.Crd.Disp Sald.Cred.Disponivel N Real 16, 2
C5F_VLCRDE VlrCrdDesAtu Vlr.Crd.Descont.PAtual N Real 16, 2
C5F_VCRRAT VlCrdResAtu Vl.Crd.Ressarc.Per.Atu. N Real 16, 2
C5F_VCRCAT VlCrdCompAtu Vlr.Crd.Comp.Per.Atu N Real 16, 2
C5F_VCRTRA VlCrdTransf. Vlr.Crd.Transferido N Real 16, 2
C5F_VLOTCR Vlr.Out.Crd Vlr.Out.Creditos N Real 16, 2
C5F_SLCUTL Sld.Crd.AUtl Sld.Crd. a Utilizar N Real 16, 2
C5F_STATUS Status Reg. Status do registro C Real 1

Indices

Ordem Chave Descricao Nickname
1 C5F_FILIAL + C5F_TPTRIB + DTOS(C5F_PERIOD) + C5F_PERAPR + C5F_ORCRE + C5F_CNPJ + C5F_CDCRE Tipo Trib. + Data Movto + Per.Ap.Crd + Ind.Org.Crd + CNPJ Ced.Crd + Co
2 C5F_FILIAL + C5F_PERAPR + C5F_ORCRE + C5F_CNPJ + C5F_CDCRE Per.Ap.Crd + Ind.Org.Crd + CNPJ Ced.Crd + Cod.Tp.Crdto
3 C5F_FILIAL + C5F_CNPJ + C5F_CDCRE CNPJ Ced.Crd + Cod.Tp.Crdto
4 C5F_FILIAL + C5F_CDCRE Cod.Tp.Crdto
5 C5F_FILIAL + C5F_ID ID
6 C5F_FILIAL + DTOS(C5F_PERIOD) + C5F_PERAPR + C5F_ORCRE + C5F_CNPJ + C5F_CDCRE Data Movto + Per.Ap.Crd + Ind.Org.Crd + CNPJ Ced.Crd + Cod.Tp.Crdto

Relacionamentos

Tabela Origem Tabela Destino Expressao Origem Expressao Destino Relacionamento
C4D (Tipo de Credito Diferido) C5F (Contr.Crd PIS/PASEP/COFINS) C4D_ID C5F_CDCRE 1 para N
C5F (Contr.Crd PIS/PASEP/COFINS) C5G (Ap. Crdto Extemp. Doc.Fiscais) C5F_ID C5G_ID 1 para N
Tabelas do Protheus v4.2 (baseado no P12.1.33) - 08/10/2021 - 10.106 tabelas e 10.324 parametros