C78 - Registro Analitico Documentos


Sumario:


Campos

Campo Titulo Descricao Tipo
C78_FILIAL Filial Filial C
C78_ID ID Identificador Registro C
C78_CSTICM Id. CST ICMS Id. CST ICMS C
C78_DCSTIC Des.CST ICMS Descricao CST ICMS C
C78_ORIMER ID Origem Cod. Identific. Origem C
C78_DORIME Desc Ori.Mer Descr. Origem Mercadoria C
C78_CFOP Id. CFOP Identificador CFOP C
C78_DCFOP Des. CFOP Descricao CFOP C
C78_ALQICM Aliq. ICMS Aliquota do ICMS N
C78_VLOPR Vlr.Operacao Valor Operacao N
C78_VLBCIC Vlr.BC.ICMS Valor BC ICMS N
C78_VLICMS Vlr. ICMS Valor ICMS N
C78_VLBIUF Vlr.BC.UF Valor BC ICMS UF N
C78_VLICUF Vlr.ICMS.UF Valor ICMS UF N
C78_VLRDBC Vlr.RED.BC Valor RED BC N
C78_CODOBS C. Obs. Lanc Observacao Lanc. Fiscal C
C78_DCODOB Des.Obs.Lanc Descricao Obs. Lanc. Fisc C

Indices

Ordem Chave Descricao Nickname
1 C78_FILIAL+C78_ID+C78_CSTICM+C78_CFOP+STR(C78_ALQICM,5,2)+C78_ORIMER ID + Id. CST ICMS + Id. CFOP + Aliq. ICMS + ID Origem

Relacionamentos

Tabela Destino Expressao Origem Expressao Destino
C79 C78_ID+C78_CSTICM+C78_CFOP+C78_ALQICM C79_ID + C79_CSTICM + C79_CFOP + C79_ALQICM