Tabela |
NN5 |
Ordem Financeira |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
NN5_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
NN5_CODOPG |
C |
6 |
0 |
Codigo |
@! |
ExistChave('NN5') |
|
|
|
|
S |
NN5_DATA |
D |
8 |
0 |
Data |
|
|
|
|
|
|
S |
NN5_TIPO |
C |
1 |
0 |
Tipo |
|
Pertence('12') |
|
|
1=Recebimento;2=Pagamento |
|
S |
NN5_FORMA |
C |
1 |
0 |
Forma |
|
Pertence('12') |
|
|
1=Normal;2=Antecipada |
|
S |
NN5_CODCTR |
C |
6 |
0 |
Contrato |
@! |
|
|
|
|
|
S |
NN5_CODFIX |
C |
3 |
0 |
Fixacao |
@! |
|
|
|
|
|
S |
NN5_MOEDA |
N |
2 |
0 |
Moeda |
@E 99 |
OGX010Moed(M->NN5_MOEDA) |
|
|
|
|
S |
NN5_DTEXEC |
D |
8 |
0 |
Dt.Exec. |
|
|
|
|
|
|
S |
NN5_QTDFIN |
N |
12 |
2 |
Qtd. P/R |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
S |
NN5_QTDRES |
N |
12 |
2 |
Qtd. P/R Res |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
S |
NN5_VLRUNI |
N |
14 |
2 |
Val.Unit. |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
NN5_VRFIXT |
N |
14 |
2 |
Vr.Fix.Total |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
NN5_FRETE |
N |
14 |
2 |
Vr.Ref.Frete |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
NN5_SEGURO |
N |
14 |
2 |
Vr.Ref.Segu. |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
NN5_DESPES |
N |
14 |
2 |
Vr.Ref.Desp. |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
NN5_VLRTOT |
N |
14 |
2 |
Val.Total |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
NN5_PERJUR |
N |
8 |
4 |
% Juros |
@E 999.9999 |
|
|
|
|
|
S |
NN5_STATUS |
C |
1 |
0 |
Status |
|
Pertence('123') |
|
|
1=Programada;2=Parciamente Executada;3=Totalmente Executada |
|
S |
NN5_CONPAG |
C |
3 |
0 |
Cond. Pagto |
|
ExistCpo('SE4') |
SE4 |
|
|
|
S |
NN5_TPLIQ |
C |
1 |
0 |
TP.Liquidaca |
@! |
VAZIO() .OR. PERTEMCE('1') |
|
|
1=Atual |
|
S |
NN5_VRACRE |
N |
16 |
2 |
Vr. Acresc. |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
NN5_VRDECR |
N |
16 |
2 |
Vr. Decresc. |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
NN5_DATVNC |
D |
8 |
0 |
Dt.Vencto. |
|
|
|
|
|
|
S |