Tabela |
NJB |
Controle de Reserva |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
NJB_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
NJB_CODRES |
C |
6 |
0 |
Codigo |
@! |
ExistChav('NJB',M->NJB_CODRES) |
|
|
|
|
S |
NJB_CODCTR |
C |
6 |
0 |
Contrato |
@! |
ExistCpo('NJR') |
NJR |
|
|
|
S |
NJB_CODENT |
C |
6 |
0 |
Cod.Ent. |
@! |
Vazio() .OR. ExistCpo('NJ0',M->NJB_CODENT) |
NJ0 |
|
|
|
S |
NJB_LOJENT |
C |
2 |
0 |
Loj.Ent. |
@! |
Vazio() .OR. ExistCpo('NJ0',M->NJB_CODENT+M->NJB_LOJENT) |
|
|
|
|
S |
NJB_NOMENT |
C |
40 |
0 |
Nome |
@! |
|
|
V |
|
|
S |
NJB_NLJENT |
C |
20 |
0 |
N. Loja |
@! |
|
|
V |
|
|
S |
NJB_TIPRES |
C |
3 |
0 |
Tip.Res. |
|
ExistCpo('NJ2') |
NJ2 |
|
|
|
S |
NJB_TIPDES |
C |
30 |
0 |
Desc.Res. |
@! |
|
|
V |
|
|
S |
NJB_CODTER |
C |
6 |
0 |
Cod.Ter. |
@! |
Vazio() .OR. ExistCpo('NJ0',M->NJB_CODTER) |
NJ0 |
|
|
|
S |
NJB_LOJTER |
C |
2 |
0 |
Loj.Ter. |
@! |
Vazio() .OR. ExistCpo('NJ0',M->NJB_CODTER+M->NJB_LOJTER) |
|
|
|
|
S |
NJB_NOMTER |
C |
40 |
0 |
Nome |
@! |
|
|
V |
|
|
S |
NJB_NLJTER |
C |
25 |
0 |
N. Loja |
@! |
|
|
V |
|
|
S |
NJB_TABELA |
C |
6 |
0 |
Tabela |
@! |
Vazio() .OR. ExistCpo('NNI',M->NJB_TABELA) |
|
|
|
|
S |
NJB_CODSAF |
C |
15 |
0 |
Cod. Safra |
@! |
ExistCpo('NJU',M->NJB_CODSAF) |
NJU |
|
|
|
S |
NJB_CODPRO |
C |
15 |
0 |
Cod.Prod. |
@! |
ExistCpo("SB1",M->NJB_CODPRO) |
SB1 |
|
|
|
S |
NJB_DESPRO |
C |
30 |
0 |
Des.Prod. |
@! |
|
|
V |
|
|
S |
NJB_UM1PRO |
C |
2 |
0 |
Unid.Med. |
@! |
ExistCpo('SAH') |
SAH |
R |
|
|
S |
NJB_CODROM |
C |
10 |
0 |
Romaneio |
@! |
|
|
|
|
|
S |
NJB_ITEROM |
C |
2 |
0 |
Seq.Rom. |
@! |
|
|
|
|
|
S |
NJB_ITECLA |
C |
3 |
0 |
Seq.Classif. |
@! |
|
|
|
|
|
S |
NJB_QTDTOT |
N |
12 |
2 |
Qtd.Rom. |
@E 999,999,999.99 |
|
|
|
|
|
S |
NJB_QTDCRE |
N |
12 |
2 |
Qtd.Cred. |
@E 999,999,999.99 |
|
|
|
|
|
S |
NJB_QTDFIN |
N |
12 |
2 |
Qtd.Financ. |
@E 999,999,999.99 |
|
|
|
|
|
S |
NJB_PERRET |
N |
5 |
2 |
% Retencao |
@E 99.99 |
|
|
|
|
|
S |
NJB_QTDPRO |
N |
12 |
2 |
Qtd.Reserv. |
@E 999,999,999.99 |
|
|
|
|
|
S |
NJB_STATUS |
C |
1 |
0 |
Status |
|
Pertence('0123') |
|
|
0=Solicitado;1=Reservado;2=Liberado;3=Cancelado |
|
S |
NJB_AVALIA |
C |
1 |
0 |
Avaliada |
|
Pertence('01') |
|
|
0=Nao;1=Sim |
|
S |
NJB_LIBERA |
C |
1 |
0 |
Tip.Liber |
|
Pertence('123') |
|
|
1=Manual;2=Credito;3=Financeiro |
|
S |
NJB_DATA |
D |
8 |
0 |
Data |
|
|
|
|
|
|
S |
NJB_DATVEN |
D |
8 |
0 |
Dt.Venc. |
|
M->NJB_DATVEN >= M->NJB_DATA |
|
|
|
|
S |
NJB_DATRES |
D |
8 |
0 |
Dt.Reserva |
|
|
|
|
|
|
S |
NJB_DATLIB |
D |
8 |
0 |
Dt.Liber. |
|
|
|
|
|
|
S |
NJB_DATCAN |
D |
8 |
0 |
Dt.Cancel. |
|
|
|
|
|
|
S |
NJB_OBS |
C |
128 |
0 |
Observacao |
@! |
|
|
|
|
|
S |
NJB_OBSLIB |
C |
128 |
0 |
Obs.Liber |
@! |
|
|
|
|
|
S |
NJB_WRRANT |
C |
10 |
0 |
Warrant |
@! |
|
|
|
|
|
S |
NJB_VLRBAS |
N |
14 |
2 |
Valor Base |
@E 99,999,999,999.99 |
Positivo() |
|
|
|
OG200lWarr(1) |
S |
NJB_CODEX1 |
C |
6 |
0 |
Cod. Exame1 |
@! |
ExistCpo("NNH") |
NNH |
|
|
OG200lWarr() |
S |
NJB_DESEX1 |
C |
25 |
0 |
Desc. Exame1 |
@! |
|
|
V |
|
|
S |
NJB_PMDEX1 |
N |
8 |
2 |
Med.Exame1 |
@E 99,999.99 |
Positivo() |
|
|
|
OG200lWarr() |
S |
NJB_CODEX2 |
C |
6 |
0 |
Cod. Exame2 |
@! |
ExistCpo("NNH") |
NNH |
|
|
OG200lWarr() |
S |
NJB_DESEX2 |
C |
25 |
0 |
Desc. Exame2 |
@! |
|
|
V |
|
|
S |
NJB_PMDEX2 |
N |
8 |
2 |
Med.Exame2 |
@E 99,999.99 |
Positivo() |
|
|
|
OG200lWarr() |
S |
NJB_CODEX3 |
C |
6 |
0 |
Cod. Exame3 |
@! |
ExistCpo("NNH") |
NNH |
|
|
OG200lWarr() |
S |
NJB_DESEX3 |
C |
25 |
0 |
Desc. Exame3 |
@! |
|
|
V |
|
|
S |
NJB_PMDEX3 |
N |
8 |
2 |
Med.Exame3 |
@E 99,999.99 |
Positivo() |
|
|
|
OG200lWarr() |
S |
NJB_CODEX4 |
C |
6 |
0 |
Cod. Exame4 |
@! |
ExistCpo("NNH") |
NNH |
|
|
OG200lWarr() |
S |
NJB_DESEX4 |
C |
25 |
0 |
Desc. Exame4 |
@! |
|
|
V |
|
|
S |
NJB_PMDEX4 |
N |
8 |
2 |
Med.Exame4 |
@E 99,999.99 |
Positivo() |
|
|
|
OG200lWarr() |
S |
NJB_FILPVN |
C |
2 |
0 |
Fil.Pl.Venda |
|
ExistCpo("SM0",cEmpAnt+M->NJB_FILPVN) |
SM0 |
R |
|
|
S |