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.3 (baseado no P12.1.2210) - 16/10/2022 - 10.278 tabelas e 10.531 parametros