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)
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 + STR(C7G_CSTICM) + C7G_CFOP + 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 |
Tabelas do Protheus v4.3 (baseado no P12.1.2210) - 16/10/2022 - 10.278 tabelas e 10.531 parametros