C7U - Bilhete Consolidados de Passag


Sumario:


Campos

Campo Titulo Descricao Tipo
C7U_FILIAL Filial Filial C
C7U_ID ID ID C
C7U_DTMOV Dt. Moviment Dt. Movimento D
C7U_CODMOD ID Modelo Cod. Identificacao Modelo C
C7U_DCOMO Descr Modelo Descricao do Modelo C
C7U_SER Ser. Doc.Fis Serie Doc.Fiscal C
C7U_SUB Sub.Ser. Doc Sub.Serie Doc.Fiscal C
C7U_DOCINI N Doc.Ini. N Documento Inicial C
C7U_DOCFIM N Doc.Fim N Documento Final C
C7U_CST Id. CST COD. CST C
C7U_DCST Des.CST Descricao CST C
C7U_CFOP CFOP Codigo Fiscal de Operacao C
C7U_DCFO Des.CFOP Descricao do CFOP C
C7U_ALIQ Aliq. ICMS Aliquota do ICMS N
C7U_DTDOC Dt. Doc. Fis Dt. Doc. Fiscal D
C7U_VLOPR Vlr. Operaca Valor Operacao N
C7U_VLDESC Val Tot Desc Valor total do desconto N
C7U_VLSERV Vlr de serv. Vlr da prest. servicos N
C7U_VLSEG Vlr do seg. Vlr do seguro N
C7U_OUTDES Vlr Out Desp Vlr Outras Despesas N
C7U_BCICM Vl. BC. ICMS Vl da base calc do ICMS N
C7U_VLICMS Vlr. ICMS Valor ICMS N
C7U_REDBC Vlr. Red. BC Vl da red base calc do IC N
C7U_CODOBS C. Obs Lanc Observacao Lanc. Fiscal C
C7U_DCODOB D. Obs Lan Descr. Obs. Lanc. Fiscal C
C7U_CTA Id. CContabi Id. Conta Contabil C
C7U_DCTA Des.Ccontab Des.Ccontab C
C7U_STATUS Status Reg. Status do registro C
C7U_CTACTB Cta Contab Conta Contabil C

Indices

Ordem Chave Descricao Nickname
1 C7U_FILIAL+C7U_ID ID
2 C7U_FILIAL+DTOS(C7U_DTMOV)+C7U_CODMOD+DTOS(C7U_DTDOC)+C7U_SER+C7U_SUB+C7U_DOCINI+C7U_DOCFIM+C7U_CST+C7U_CFOP Dt. Moviment + ID Modelo + Dt. Doc. Fis + Ser. Doc.Fis + Sub.Ser. Doc
3 C7U_FILIAL+C7U_CODMOD+DTOS(C7U_DTDOC)+C7U_SER+C7U_SUB+C7U_DOCINI+C7U_DOCFIM+C7U_CST+C7U_CFOP ID Modelo + Dt. Doc. Fis + Ser. Doc.Fis + Sub.Ser. Doc + N Doc.Ini. +
4 C7U_FILIAL+DTOS(C7U_DTDOC)+C7U_SER+C7U_SUB+C7U_DOCINI+C7U_DOCFIM+C7U_CST+C7U_CFOP Dt. Doc. Fis + Ser. Doc.Fis + Sub.Ser. Doc + N Doc.Ini. + N Doc.Fim
5 C7U_FILIAL+C7U_SER+C7U_SUB+C7U_DOCINI+C7U_DOCFIM+C7U_CST+C7U_CFOP Ser. Doc.Fis + Sub.Ser. Doc + N Doc.Ini. + N Doc.Fim + Id. CST + CFO
6 C7U_FILIAL+C7U_SUB+C7U_DOCINI+C7U_DOCFIM+C7U_CST+C7U_CFOP Sub.Ser. Doc + N Doc.Ini. + N Doc.Fim + Id. CST + CFOP
7 C7U_FILIAL+C7U_DOCINI+C7U_DOCFIM+C7U_CST+C7U_CFOP N Doc.Ini. + N Doc.Fim + Id. CST + CFOP
8 C7U_FILIAL+C7U_CST+C7U_CFOP Id. CST + CFOP
9 C7U_FILIAL+C7U_CFOP CFOP

Relacionamentos

Tabela Destino Expressao Origem Expressao Destino
C7X C7U_ID C7X_ID
C7V C7U_ID C7V_ID