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)
Modo: E
Modo Unid.: E
Modo Empr.: E
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 |