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.2 (baseado no P12.1.33) - 08/10/2021 - 10.106 tabelas e 10.324 parametros