Tabela
NN7 Previsao Financeira do Contrat
Campo Tipo Tamanho Decimal Titulo Formato Validacao F3 Contexto Lista Condicao PYME
NN7_FILIAL C 2 0 Filial S
NN7_CODCTR C 6 0 Contrato @! ExistCpo('NJR') NJR R S
NN7_ITEM C 3 0 Item @! R S
NN7_PARCEL C 2 0 Parcela S
NN7_DTVENC D 8 0 Dt. Vencto S
NN7_VALOR N 14 2 Valor @E 99,999,999,999.99 S
NN7_CODBCO C 3 0 Banco @! NN0 S
NN7_CODAGE C 5 0 Agencia @! S
NN7_DVAGE C 1 0 DV Agencia X S
NN7_CODCTA C 10 0 Conta @! S
NN7_DVCTA C 1 0 DV Conta X S
NN7_CODFAV C 6 0 Favorecido @! Vazio() .Or. ExistCpo("NJ0") NJ0 S
NN7_LOJFAV C 2 0 Loja @! ExistCpo("NJ0",FWFldGet("NN7_CODFAV")+FWFldGet("NN7_LOJFAV")) S
NN7_NOMFAV C 40 0 Nome Fav. V S
NN7_NLJFAV C 20 0 Nome Loj. @! V S
NN7_NATURE C 10 0 natureza @! FinVldNat( .F., M->NN7_NATURE,2) SED S
NN7_CCD C 9 0 C.Custo Deb. @! Vazio() .or. CTB105CC() CTT R S
NN7_CODCOM C 6 0 Cod.Comp. @! R S
NN7_ITMCOM C 4 0 Item Comp. @! R S
NN7_DESCOM C 30 0 Des.Compont @! R S
NN7_STATUS C 1 0 Sts. Financ @! R 1=Aberta;2=Confirmado;3=Divergente;4=EmAtraso;5=Finalizado S
NN7_DESMOE C 15 0 Desc.Moeda @! V S
NN7_VLSALD N 14 2 Vlr. Saldo @E 99,999,999,999.99 R S
NN7_VLUNIP N 12 2 Vl. Uni. Pre @E 999,999,999.99 R S
NN7_TIPO C 1 0 Tipo @! Pertence("1/2/3/4") R 1=Previsao;2=Pagamento;3=Despesa;4=Provisional S
NN7_FILORG C 2 0 Fil. Origem Vazio() .OR. OGX700VSM0('NN7_FILORG') SM0N7A R S
NN7_FILDES C 40 0 Filial Descr @! V S
NN7_CHATIT C 20 0 Ch. Titulo @! R S
NN7_CONTOB M 10 0 Obs. Contato R S
NN7_CONTST C 1 0 Sts. Contato R 1=Confirmado;2=Divergente S
NN7_MOEDA N 2 0 Moeda @E 99 R S
NN7_VLRTAX N 10 6 Cotacao @E 999.999999 R S
NN7_QTDE N 12 2 Quantidade @E 999,999,999.99 R S
NN7_SLDQTD N 12 2 Saldo Qtde. @E 999,999,999.99 R S
NN7_STSTIT C 1 0 Sts. Titulos @ Pertence("0|1|2|3") R 0=Atualizado;1=Incluir;2=Alterar;3=Excluir; S
NN7_VLCOMP N 14 2 Vl a Compens @E 99,999,999,999.99 R S
NN7_VLTEMI N 14 2 Vl. Tit. Emi @E 99,999,999,999.99 R S
NN7_VLTNCO N 14 2 Vl. Nao Comp @E 99,999,999,999.99 R S
NN7_VLRAVI N 14 2 Vlr. RA Vinc @E 99,999,999,999.99 R S
NN7_VLDEVL N 14 2 Vlr. Devol @E 99,999,999,999.99 S
NN7_TIPEVE C 1 0 Tipo Evento @! Pertence("12") R 1=Sim;2=Nao S
NN7_NOMENT C 60 0 Nome Ent @! V S
NN7_TIPMER C 12 0 Tipo Mercado @! V S
NN7_CTREXT C 20 0 Ctr. Externo @! V S
NN7_DESPRO C 50 0 Desc. Prod. @! V S
NN7_MOEREF C 20 0 Moeda Ctr @! V S
NN7_VALMOE N 14 2 Val Moed Ctr @E 99,999,999,999.99 V S
NN7_OPERAC C 14 0 Ref. Moeda @! V S
NN7_CODPGT C 20 0 Cond. Pagto @! V S