Tabela CAB - Reg Anali. CF-e (CODIGO 59)
Rotina (SysObj): TAFA095
Chave Unica: CAB_FILIAL + CAB_ID + DTOS(CAB_DTDOC) + CAB_CODSIT + CAB_NUMCFE + CAB_CFOP + CAB_CSTPIS + STR(CAB_ALQPIS) + CAB_CSTCOF + STR(CAB_ALQCOF)
Sumario:
Campos
Campo
| Titulo
| Descricao
| Tipo
| Contexto
| Tamanho
|
CAB_FILIAL |
Filial |
Filial |
C |
Real |
2 |
CAB_ID |
ID |
Identificador do Registro |
C |
Real |
6 |
CAB_DTDOC |
Dt Doc |
Data do Documento |
D |
Real |
8 |
CAB_CODSIT |
Cod. Sit |
Cod. Situacao |
C |
Real |
6 |
CAB_NUMCFE |
Num. CFE |
Numero CFE |
C |
Real |
6 |
CAB_CFOP |
CFOP |
CFOP |
C |
Real |
6 |
CAB_DCFOP |
Des CFOP |
Descricao CFOP |
C |
Virtual |
220 |
CAB_VLOPR |
Val Operacao |
Valor Operacao |
N |
Real |
16, 2 |
CAB_VLDESC |
Val. Descont |
Valor Desconto |
N |
Real |
16, 2 |
CAB_CSTPIS |
Cst Pis |
Cst Pis |
C |
Real |
6 |
CAB_DCSTPI |
Des. Pis |
Descricao Pis |
C |
Virtual |
220 |
CAB_VLBCPI |
BC Pis |
Base de Calculo Pis |
N |
Real |
16, 2 |
CAB_ALQPIS |
Aliq. Pis |
Aliquota Pis |
N |
Real |
8, 4 |
CAB_QTBCPI |
BC Pis Qt |
Base de Calculo Pis Qt |
N |
Real |
16, 3 |
CAB_ALPIQT |
Aliq. Pis Qt |
Aliquota Pis Qt |
N |
Real |
16, 4 |
CAB_VLPIS |
Valor Pis |
Valor Pis |
N |
Real |
16, 2 |
CAB_CSTCOF |
Cst Cofins |
Cst Cofins |
C |
Real |
6 |
CAB_DCSTCO |
Des. Cofins |
Descricao Cofins |
C |
Virtual |
220 |
CAB_VLBCCO |
BC Cofins |
Base de Calculo Cofins |
N |
Real |
16, 2 |
CAB_ALQCOF |
Aliq. Cofins |
Aliquota Cofins |
N |
Real |
8, 4 |
CAB_QTBCCO |
BC Cof Qt |
Base de Calculo Cofins Qt |
N |
Real |
16, 3 |
CAB_ALCOQT |
Aliq. Cof Qt |
Aliquota Cofins Qt |
N |
Real |
16, 4 |
CAB_VLCOFI |
Valor Cofins |
Valor Cofins |
N |
Real |
16, 2 |
CAB_CODCTA |
Id. Cod. Con |
Id. Codigo Conta |
C |
Real |
36 |
CAB_CTACTB |
Cta Contab |
Conta Contabil |
C |
Virtual |
60 |
CAB_DCODCT |
Des Conta |
Descricao Conta |
C |
Virtual |
220 |
CAB_INFCOM |
Inf. Comp. |
Inf. Complementar |
C |
Real |
220 |
Indices
Ordem
| Chave
| Descricao
| Nickname
|
1 |
CAB_FILIAL + CAB_ID + DTOS(CAB_DTDOC) + CAB_CODSIT + CAB_NUMCFE + CAB_CFOP + CAB_CSTPIS + STR(CAB_ALQPIS) + CAB_CSTCOF + STR(CAB_ALQCOF) |
ID + Dt Doc + Cod. Sit + Num. CFE + CFOP + Cst Pis + Aliq. Pis + Cst C |
|
2 |
CAB_FILIAL + CAB_CFOP + CAB_CSTPIS + STR(CAB_ALQPIS) + CAB_CSTCOF + STR(CAB_ALQCOF) |
CFOP + Cst Pis + Aliq. Pis + Cst Cofins + Aliq. Cofins |
|
Relacionamentos
Tabela Origem
| Tabela Destino
| Expressao Origem
| Expressao Destino
| Relacionamento
|
C0Y (Cadastro de CFOP) |
CAB (Reg Anali. CF-e (CODIGO 59)) |
C0Y_ID |
CAB_CFOP |
1 para N |
C17 (Situacao Tributaria Pis/Cofins) |
CAB (Reg Anali. CF-e (CODIGO 59)) |
C17_ID |
CAB_CSTCOF |
1 para N |
C17 (Situacao Tributaria Pis/Cofins) |
CAB (Reg Anali. CF-e (CODIGO 59)) |
C17_ID |
CAB_CSTPIS |
1 para N |
C1O (Plano de Contas Contabeis) |
CAB (Reg Anali. CF-e (CODIGO 59)) |
C1O_ID |
CAB_CODCTA |
1 para N |
C5R (Cupom Fiscal SAT-CF-e) |
CAB (Reg Anali. CF-e (CODIGO 59)) |
C5R_ID + C5R_DTDOC + C5R_CODSIT + C5R_NUMCFE |
CAB_ID + CAB_DTDOC + CAB_CODSIT + CAB_NUMCFE |
1 para N |
Tabelas do Protheus v4.3 (baseado no P12.1.2210) - 16/10/2022 - 10.278 tabelas e 10.531 parametros