Tabela C7G - Registro Analitico do Moviment
Rotina (SysObj): TAFA093
Chave Unica: C7G_FILIAL + C7G_ID + DTOS(C7G_DTMOV) + C7G_CSTICM + C7G_CFOP + STR(C7G_ALQICM)
Modo: E
Modo Unid.: E
Modo Empr.: E
Sumario:
Campos
| Campo | Titulo | Descricao | Tipo | Contexto | Tamanho |
|---|---|---|---|---|---|
| C7G_FILIAL | Filial | Filial | C | Real | 2 |
| C7G_ID | ID | ID | C | Real | 6 |
| C7G_DTMOV | Dt. Moviment | Dt. Movimento | D | Real | 8 |
| C7G_CSTICM | ID CST ICMS | CST ICMS | C | Real | 6 |
| C7G_DCSTIC | Des CST ICMS | Descricao CST ICMS | C | Virtual | 220 |
| C7G_CFOP | CFOP | Codigo Fiscal de Operacao | C | Real | 6 |
| C7G_DCFOP | Des. CFOP | Descricao do CFOP | C | Virtual | 220 |
| C7G_ALQICM | Aliq. ICMS | Aliquota do ICMS | N | Real | 6, 2 |
| C7G_VLOPR | Vl. Operacao | Valor Operacao | N | Real | 16, 2 |
| C7G_BCISSQ | Vl. BC ISSQN | Valor da B.C. ISSQN | N | Real | 16, 2 |
| C7G_ALISSQ | Aliqta ISSQN | Aliquota ISSQN | N | Real | 16, 2 |
| C7G_VLISSQ | Valor ISSQN | Valor do ISSQN | N | Real | 16, 2 |
| C7G_BCICMS | Vl Base ICMS | Valor base calculo ICMS | N | Real | 16, 2 |
| C7G_VLICMS | Valor ICMS | Valor ICMS | N | Real | 16, 2 |
| C7G_CODOBS | C. Obs. Lanc | Observacao Lanc. Fiscal | C | Real | 6 |
| C7G_DCODOB | D. Obs Lan | Descr. Obs. Lanc. Fiscal | C | Virtual | 220 |
Indices
| Ordem | Chave | Descricao | Nickname |
|---|---|---|---|
| 1 | C7G_FILIAL + C7G_ID + DTOS(C7G_DTMOV) + C7G_CSTICM + C7G_CFOP + STR(C7G_ALQICM) | ID + Dt. Moviment + ID CST ICMS + CFOP + Aliq. ICMS | |
| 2 | C7G_FILIAL + C7G_CSTICM + C7G_CFOP + STR(C7G_ALQICM) | ID CST ICMS + CFOP + Aliq. ICMS |
Relacionamentos
| Tabela Origem | Tabela Destino | Expressao Origem | Expressao Destino | Relacionamento |
|---|---|---|---|---|
| C0Y (Cadastro de CFOP) | C7G (Registro Analitico do Moviment) | C0Y_ID | C7G_CFOP | 1 para N |
| C14 (Situacao Tributaria ICMS) | C7G (Registro Analitico do Moviment) | C14_ID | C7G_CSTICM | 1 para N |
| C3R (Lancamento Fiscal do Documeto) | C7G (Registro Analitico do Moviment) | C3R_ID | C7G_CODOBS | 1 para N |
| C6G (Reducao Z) | C7G (Registro Analitico do Moviment) | C6G_FILIAL + C6G_ID + C6G_DTMOV | C7G_FILIAL + C7G_ID + C7G_DTMOV | 1 para N |
| C6G (Reducao Z) | C7G (Registro Analitico do Moviment) | C6G_ID + C6G_DTMOV | C7G_ID + C7G_DTMOV | 1 para N |