C7N - Reg. Analitico Docum.


Sumario:


Campos

Campo Titulo Descricao Tipo
C7N_FILIAL Filial Filial C
C7N_ID ID Identificador C
C7N_CSTICM Id. CST ICMS Id. CST ICMS C
C7N_DCSTIC Des.CST ICMS Descricao CST ICMS C
C7N_CFOP Id. CFOP Identificador CFOP C
C7N_DCFOP Des. CFOP Descricao CFOP C
C7N_ALQICM Aliq. ICMS Aliquota do ICMS N
C7N_VLOPR Vlr.Operacao Valor Operacao N
C7N_VLBCIC Vlr.BC.ICMS Valor BC ICMS N
C7N_VLICMS Vlr. ICMS Valor ICMS N
C7N_VBCSTI Vlr.BC.ST.IC Vlr. BC. ST. ICMS N
C7N_VLSTIC Vlr.ICMS.ST Valor BC ICMS ST N
C7N_VLREBC Vlr. Red. BC Valor Reducao BC N
C7N_CODOBS C. Obs. Lanc Observacao Lanc. Fiscal C
C7N_DCODOB Des.Obs.Lanc Descricao Obs. Lanc. Fisc C

Indices

Ordem Chave Descricao Nickname
1 C7N_FILIAL+C7N_ID+C7N_CSTICM+C7N_CFOP+STR(C7N_ALQICM,5,2) ID + Id. CST ICMS + Id. CFOP + Aliq. ICMS

Relacionamentos

Tabela Destino Expressao Origem Expressao Destino
C7O C7N_ID+C7N_CSTICM+C7N_CFOP+C7N_ALQICM C7O_ID+C7O_CSTICM+C7O_CFOP+C7O_ALQICM
C7O C7N_ID+C7N_CSTICM+C7N_CFOP+C7N_ALQICM C7O_ID+C7O_CSTICM+C7O_CFOP+C7O_ALQICM