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 |