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