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
Modo: E
Modo Unid.: E
Modo Empr.: E
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) + C7D_CST + C7D_IT + STR(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 |