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