Tabela C7D - Resumo diario do ECF COFINS
Rotina (SysObj): TAFA093
Chave Unica: C7D_FILIAL + C7D_ID + DTOS(C7D_DTMOV) + C7D_CST + C7D_IT + STR(C7D_ALIQ) + C7D_CTA
Sumario:
Campos
| Campo
| Titulo
| Descricao
| Tipo
| Contexto
| Tamanho
|
| C7D_FILIAL |
Filial |
Filial |
C |
Real |
2 |
| C7D_ID |
ID |
Identificador Registro |
C |
Real |
6 |
| C7D_DTMOV |
Dt.Movimento |
Dt.Movimento |
D |
Real |
8 |
| C7D_IT |
Id. Item |
Id. Item |
C |
Real |
36 |
| C7D_ITEM |
Cod. Item |
Codigo do item |
C |
Virtual |
60 |
| C7D_DIT |
Des.Produto |
Descricao Produto |
C |
Virtual |
220 |
| C7D_CST |
Cod. CST |
Codigo CST |
C |
Real |
6 |
| C7D_DCST |
Des. CST |
Descricao CST |
C |
Virtual |
220 |
| C7D_CFOP |
Id. CFOP |
Identificador CFOP |
C |
Real |
6 |
| C7D_DCFOP |
Des. CFOP |
Descricao CFOP |
C |
Virtual |
220 |
| C7D_CTA |
Id. CContabi |
Id. Conta Contabil |
C |
Real |
36 |
| C7D_CTACTB |
Cta Contab |
Conta Contabil |
C |
Virtual |
60 |
| C7D_DCTA |
Des.Ccontab |
Des.Ccontab |
C |
Virtual |
220 |
| C7D_VLITEM |
Vlr.Item |
Valor Total Item |
N |
Real |
16, 2 |
| C7D_VLRBC |
Vlr.BC.Trib |
Vlr. BC. Tributo |
N |
Real |
16, 2 |
| C7D_ALIQ |
Alq. Trib. |
Alq. Tributo |
N |
Real |
6, 2 |
| C7D_VL |
Vlr. Tributo |
Valor do Tributo |
N |
Real |
16, 2 |
| C7D_QTDBC |
Qtde.BC.Trib |
Qtde.BC.Tributo |
N |
Real |
16, 3 |
| C7D_ALQQTD |
Qtd.Alq.Trib |
Qtd.Alq.Tributo |
N |
Real |
16, 2 |
Indices
| Ordem
| Chave
| Descricao
| Nickname
|
| 1 |
C7D_FILIAL + C7D_ID + DTOS(C7D_DTMOV) + C7D_CST + C7D_IT + STR(C7D_ALIQ) + C7D_CTA |
ID + Dt.Movimento + Cod. CST + Id. Item + Alq. Trib. + Id. CContabi |
|
| 2 |
C7D_FILIAL + DTOS(C7D_DTMOV) + STR(C7D_CST) + C7D_IT + C7D_ALIQ + C7D_CTA |
Dt.Movimento + Cod. CST + Id. Item + Alq. Trib. + Id. CContabi |
|
| 3 |
C7D_FILIAL + C7D_CST + C7D_IT + STR(C7D_ALIQ) + C7D_CTA |
Cod. CST + Id. Item + Alq. Trib. + Id. CContabi |
|
| 4 |
C7D_FILIAL + C7D_IT |
Id. Item |
|
Relacionamentos
| Tabela Origem
| Tabela Destino
| Expressao Origem
| Expressao Destino
| Relacionamento
|
| C0Y (Cadastro de CFOP) |
C7D (Resumo diario do ECF COFINS) |
C0Y_ID |
C7D_CFOP |
1 para N |
| C17 (Situacao Tributaria Pis/Cofins) |
C7D (Resumo diario do ECF COFINS) |
C17_ID |
C7D_CST |
1 para N |
| C1L (Identificacao do Item) |
C7D (Resumo diario do ECF COFINS) |
C1L_ID |
C7D_IT |
1 para N |
| C1O (Plano de Contas Contabeis) |
C7D (Resumo diario do ECF COFINS) |
C1O_ID |
C7D_CTA |
1 para N |
| C6G (Reducao Z) |
C7D (Resumo diario do ECF COFINS) |
C6G_ID + C6G_DTMOV |
C7D_ID + C7D_DTMOV |
1 para N |
Tabelas do Protheus v4.3 (baseado no P12.1.2210) - 16/10/2022 - 10.278 tabelas e 10.531 parametros