Tabela C75 - Cmple.Consolidacao COFINS
Rotina (SysObj): TAFA207
Chave Unica: C75_FILIAL + C75_ID + C75_CSTCOF
Modo: E
Modo Unid.: E
Modo Empr.: E
Sumario:
Campos
| Campo | Titulo | Descricao | Tipo | Contexto | Tamanho |
|---|---|---|---|---|---|
| C75_FILIAL | Filial | Filial | C | Real | 2 |
| C75_ID | ID | Identificador Registro | C | Real | 6 |
| C75_CCLASS | ID Clas Item | Cod. Class. Item | C | Real | 6 |
| C75_DCCLAS | D.Clas.It. | Descr. Classif. Item | C | Virtual | 220 |
| C75_VLRITE | Vlr.Item | Valor Tot Item | N | Real | 16, 2 |
| C75_VLDESC | Val Tot Desc | Valor total do desconto | N | Real | 16, 2 |
| C75_CSTCOF | CST COFINS | Cod Sit Tributaria COFINS | C | Real | 6 |
| C75_DCSTC | CST COFINS | Desc. CST COFINS | C | Virtual | 220 |
| C75_BCCOF | Vl BC COFINS | Valor da BC da COFINS | N | Real | 16, 2 |
| C75_ALQCOF | Aliq. COFINS | Aliquota COFINS | N | Real | 6, 2 |
| C75_VLCOF | Valor COFINS | Valor COFINS | N | Real | 16, 2 |
| C75_CTA | CContabil | Conta Contabil | C | Real | 36 |
| C75_CTACTB | Cod Cta Ctb | Cod Conta Contabil | C | Virtual | 60 |
| C75_DCTA | Des.Ccontab | Des.Ccontab | C | Virtual | 220 |
Indices
| Ordem | Chave | Descricao | Nickname |
|---|---|---|---|
| 1 | C75_FILIAL + C75_ID + C75_CSTCOF + C75_CCLASS | ID + CST COFINS + ID Clas Item |
Relacionamentos
| Tabela Origem | Tabela Destino | Expressao Origem | Expressao Destino | Relacionamento |
|---|---|---|---|---|
| C0K (Classificacao Item EE/Com.Tel.) | C75 (Cmple.Consolidacao COFINS) | C0K_ID | C75_CCLASS | 1 para 1 |
| C17 (Situacao Tributaria Pis/Cofins) | C75 (Cmple.Consolidacao COFINS) | C17_ID | C75_CSTCOF | 1 para 1 |
| C1O (Plano de Contas Contabeis) | C75 (Cmple.Consolidacao COFINS) | C1O_ID | C75_CTA | 1 para 1 |
| C73 (Consolidacao Prestacao de Serv) | C75 (Cmple.Consolidacao COFINS) | C73_ID | C75_ID | 1 para 1 |