Tabela C5F - Contr.Crd PIS/PASEP/COFINS
Rotina (SysObj): TAFA081
Chave Unica: C5F_FILIAL + C5F_ID
Modo: E
Modo Unid.: E
Modo Empr.: E
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 |