C5F - Contr.Crd PIS/PASEP/COFINS


Sumario:


Campos

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

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 Destino Expressao Origem Expressao Destino
C5G C5F_ID C5G_ID