Tabela |
NJR |
Contratos |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
NJR_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
NJR_CODCTR |
C |
6 |
0 |
Contrato |
@! |
ExistChav('NJR',M->NJR_CODCTR) |
|
R |
|
|
S |
NJR_ULTALT |
C |
3 |
0 |
Ult.Alt. |
@! |
|
|
R |
|
|
S |
NJR_DESCRI |
C |
40 |
0 |
Descricao |
@! |
|
|
|
|
|
S |
NJR_TIPO |
C |
1 |
0 |
Tipo Ctr. |
@! |
Pertence('1234') |
|
|
1=Compra;2=Venda;3=Armazenagem De 3;4=Armazenagem Em 3 |
|
S |
NJR_DATA |
D |
8 |
0 |
Data Ctr. |
|
|
|
|
|
M->NJR_STATUS='P' |
S |
NJR_CODENT |
C |
6 |
0 |
Cod.Entidade |
@! |
ExistCpo('NJ0',M->NJR_CODENT) |
NJ0 |
|
|
|
S |
NJR_LOJENT |
C |
2 |
0 |
Loj.Entidade |
@! |
ExistCpo('NJ0',M->NJR_CODENT+M->NJR_LOJENT) |
|
|
|
|
S |
NJR_NOMENT |
C |
40 |
0 |
Nom.Entidade |
@! |
|
|
V |
|
|
S |
NJR_NLJENT |
C |
20 |
0 |
Nom.Loj.Ent |
@! |
|
|
V |
|
|
S |
NJR_CODTER |
C |
6 |
0 |
Cod.Ter. |
@! |
|
NJ0 |
|
|
|
S |
NJR_LOJTER |
C |
2 |
0 |
Loj.Ter. |
@! |
ExistCpo('NJ0',M->NJR_CODTER+M->NJR_LOJTER) |
|
|
|
|
S |
NJR_NOMTER |
C |
40 |
0 |
Nom.Ter. |
@! |
|
|
V |
|
|
S |
NJR_NLJTER |
C |
20 |
0 |
N.Loj.Ter. |
@! |
|
|
V |
|
|
S |
NJR_OPETRI |
C |
1 |
0 |
Op.Triangula |
@! |
Pertence('12') |
|
|
1=Sim;2=Nao |
|
S |
NJR_OPEFUT |
C |
1 |
0 |
Op.Futura |
@! |
Pertence('12') |
|
|
1=Sim;2=Nao |
|
S |
NJR_CODOPE |
C |
6 |
0 |
Operacao |
@! |
ExistCpo('NNO') |
NNO |
|
|
|
S |
NJR_CODSAF |
C |
15 |
0 |
Cod. Safra |
@! |
ExistCpo('NJU') |
NJU |
|
|
OGA290NGCW() |
S |
NJR_TALHAO |
C |
16 |
0 |
Talhao |
@! |
|
|
|
|
|
S |
NJR_CODPRO |
C |
15 |
0 |
Cod. Produto |
@! |
|
SB1 |
|
|
OGA290NGCW() |
S |
NJR_DESPRO |
C |
30 |
0 |
Des. Produto |
@! |
|
|
V |
|
|
S |
NJR_UM1PRO |
C |
2 |
0 |
Unid.Med. |
@! |
ExistCpo('SAH') |
SAH |
R |
|
|
S |
NJR_TABELA |
C |
6 |
0 |
Tabela |
@! |
|
NNINJR |
|
|
IF( AGRTPALGOD(M->NJR_CODPRO) == .T.,.F.,.T.) |
S |
NJR_CODRPC |
C |
6 |
0 |
Cod. RPC. |
|
|
|
R |
|
|
S |
NJR_OPEFIS |
C |
3 |
0 |
Oper.Fis. |
|
Vazio().Or.ExistCpo('SX5','DJ'+M->NJR_OPEFIS) |
DJ |
|
|
|
S |
NJR_TESEST |
C |
3 |
0 |
TES |
|
Vazio().Or.ExistCpo('SF4') |
SF4 |
|
|
|
S |
NJR_TESFIN |
C |
3 |
0 |
TES Fin. |
@! |
Vazio().Or.ExistCpo('SF4') |
SF4 |
|
|
|
S |
NJR_TESQTE |
C |
3 |
0 |
TES Qb. Tecn |
@! |
Vazio().Or.ExistCpo('SF4') |
SF4 |
|
|
|
S |
NJR_TESRSI |
C |
3 |
0 |
TES Ret.Simb |
@! |
Vazio().Or.ExistCpo('SF4') |
SF4 |
|
|
|
S |
NJR_TIPEMB |
C |
15 |
0 |
Tipo Embal. |
@! |
Vazio() .OR. Texto() |
|
|
|
|
S |
NJR_MSGNFS |
C |
60 |
0 |
Msg. p/ NFs |
@! |
|
|
|
|
|
S |
NJR_OBSADT |
M |
10 |
0 |
Obs. Adic. |
|
|
|
|
|
|
S |
NJR_QTDINI |
N |
12 |
2 |
Qtd. Inicial |
@E 999,999,999.99 |
Positivo() |
|
|
|
M->NJR_STATUS='P' .and. OGA290NGCW() |
S |
NJR_QTDCTR |
N |
12 |
2 |
Qtd.Contrat. |
@E 999,999,999.99 |
|
|
R |
|
|
S |
NJR_AUTENT |
N |
12 |
2 |
Qt.Autz.Ent. |
@E 999,999,999.99 |
|
|
R |
|
|
S |
NJR_AUTSAI |
N |
12 |
2 |
NJR_AUTSAI |
@E 999,999,999.99 |
|
|
R |
|
|
S |
NJR_QTEEMB |
N |
12 |
2 |
Qtd.Ent.Emb. |
@E 999,999,999.99 |
|
|
R |
|
|
S |
NJR_QTEFCO |
N |
12 |
2 |
Qtd.Ent.Fco. |
@E 999,999,999.99 |
|
|
R |
|
|
S |
NJR_QTEFIS |
N |
12 |
2 |
Qtd.Ent.Fis. |
@E 999,999,999.99 |
|
|
R |
|
|
S |
NJR_VLEFIS |
N |
14 |
2 |
Vlr.Ent.Fis. |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
NJR_QTSEMB |
N |
12 |
2 |
Qtd.Sai.Emb. |
@E 999,999,999.99 |
|
|
R |
|
|
S |
NJR_QTSFCO |
N |
12 |
2 |
Qtd.Sai.Fco. |
@E 999,999,999.99 |
|
|
R |
|
|
S |
NJR_QTSFIS |
N |
12 |
2 |
Qtd.Sai.Fis. |
@E 999,999,999.99 |
|
|
R |
|
|
S |
NJR_VLSFIS |
N |
14 |
2 |
Vlr.Sai.Fis. |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
NJR_QSLEMB |
N |
12 |
2 |
Qtd.Sld.Emb. |
@E 999,999,999.99 |
|
|
R |
|
|
S |
NJR_QSLFCO |
N |
12 |
2 |
Qtd.Sld.Fco. |
@E 999,999,999.99 |
|
|
R |
|
|
S |
NJR_SLDFIS |
N |
12 |
2 |
Qtd.Sld.Fis. |
@E 999,999,999.99 |
|
|
R |
|
|
S |
NJR_SLDTOT |
N |
14 |
2 |
Vlr.Sld.Fis. |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
NJR_QTDRES |
N |
12 |
2 |
Qt.Reservada |
@E 999,999,999.99 |
|
|
R |
|
|
S |
NJR_QTDQUE |
N |
9 |
2 |
Qtd.Queb.Tec |
@E 999,999.99 |
Positivo() |
|
R |
|
|
S |
NJR_TIPFIX |
C |
1 |
0 |
Tipo Fix. |
@! |
Pertence('12') |
|
|
1=Fixo;2=A Fixar |
OGA290NGCW() |
S |
NJR_VLRBAS |
N |
14 |
2 |
Vlr.Base |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
NJR_MOEDA |
N |
2 |
0 |
Moeda |
@E 99 |
OGX010Moed(M->NJR_MOEDA) |
|
|
|
OGA290NGCW() |
S |
NJR_TXMOED |
N |
10 |
6 |
tx. Moeda |
@E 999.999999 |
|
|
|
|
M->NJR_MOEDA<>1 |
S |
NJR_VLRUNI |
N |
14 |
2 |
Vlr.Unit. |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
NJR_UMPRC |
C |
2 |
0 |
UM. Preco |
@! |
ExistCpo('SAH') |
SAH |
R |
|
|
S |
NJR_VLRTOT |
N |
14 |
2 |
Valor Total |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
NJR_PERCRD |
N |
3 |
0 |
% Lim.Cred. |
@E 999 |
M->NJR_PERCRD>=0.And.M->NJR_PERCRD<=100 |
|
|
|
|
S |
NJR_CODIDX |
C |
15 |
0 |
Indice |
@! |
Vazio().Or.ExistCpo('NK0') |
NK0 |
|
|
|
S |
NJR_ITVDAP |
C |
1 |
0 |
Incent. DAP |
@! |
Pertence('12') |
|
|
1=Sim;2=Nao |
|
S |
NJR_TPFRET |
C |
1 |
0 |
Tipo Frete |
X |
pertence("CFTRDS") |
|
|
C=CIF;F=FOB;T=Por conta de terceiros;R=Por conta remetente;D=Por conta destinatario;S=Sem frete |
OGA290NGCW() |
S |
NJR_CTRLLG |
C |
1 |
0 |
Ctrl.Logist |
@! |
Pertence('12') |
|
|
1=Sim;2=Nao |
|
S |
NJR_CTRLCD |
C |
1 |
0 |
Ctrl.Ent/Sa |
|
Pertence('0123') |
|
|
0=Nenhum;1=Saida;2=Entrada;3=Entrada/Saida |
|
S |
NJR_TRANSF |
C |
1 |
0 |
Transfer.? |
|
Pertence('12') |
|
R |
1=Sim;2=Nao |
|
S |
NJR_MODELO |
C |
1 |
0 |
Modelo Ctr. |
|
Pertence('123') |
|
R |
1=Pre-Contrato;2=Contrato;3=Automatico |
|
S |
NJR_MODBAS |
C |
6 |
0 |
Modelo Base |
|
Vazio().Or.ExistCpo('NJX') |
|
R |
|
|
S |
NJR_STSASS |
C |
1 |
0 |
Sts. Assinat |
|
Pertence('AF') |
|
|
A=Aberto;F=Finalizado |
|
S |
NJR_STSFIS |
C |
1 |
0 |
Sts. Fiscal |
|
Pertence('AF') |
|
|
A=Aberto;F=Finalizado |
|
S |
NJR_STSFIN |
C |
1 |
0 |
Sts. Financ |
|
Pertence('AF') |
|
R |
A=Aberto;F=Finalizado |
|
S |
NJR_STSEST |
C |
1 |
0 |
Sts. Estoq. |
|
Pertence('AF') |
|
|
A=Aberto;F=Finalizado |
|
S |
NJR_STATUS |
C |
1 |
0 |
Status Ctr. |
|
Pertence('PAIFE') |
|
R |
P=Previsto;A=Aberto;I=Iniciado;E=Cancelado;F=Finalizado |
|
S |
NJR_CODTSE |
C |
6 |
0 |
Tab.Servico |
@! |
Vazio().Or.ExistCpo('NKP',M->NJR_CODTSE) |
NKP |
|
|
|
S |
NJR_DESTSE |
C |
40 |
0 |
Desc.Tab.Srv |
@! |
|
|
V |
|
|
S |
NJR_MODAL |
C |
6 |
0 |
Modalidade |
@! |
ExistCpo('NK5').Or.Vazio() |
NK5 |
|
|
|
S |
NJR_DESMOD |
C |
25 |
0 |
Descr. Modal |
@! |
|
|
V |
|
|
S |
NJR_INSCPO |
C |
40 |
0 |
Insc.Campo |
|
|
|
|
|
|
S |
NJR_CTRPAR |
C |
6 |
0 |
Parceria |
|
|
|
|
|
|
S |
NJR_USADO |
L |
1 |
0 |
Usado |
|
|
|
|
|
|
S |
NJR_CLASSP |
C |
1 |
0 |
Contr. Qtd |
@! |
Pertence('12') |
|
R |
1=Origem;2=Destino |
|
S |
NJR_TPEXC |
C |
1 |
0 |
Exceder Vol? |
@! |
Pertence('123') |
|
R |
1=Nao Permite;2=Ultima Carga;3=Percentual |
|
S |
NJR_TOLENT |
N |
6 |
2 |
Tol. Entrega |
@E 999.99 |
OGA290CPO() |
|
R |
|
OGA280WTEN() |
S |
NJR_DATREF |
D |
8 |
0 |
DT.REF.FIX |
|
|
|
R |
|
|
S |
NJR_TIPMER |
C |
1 |
0 |
Tipo Mercado |
@! |
Pertence("12") |
|
R |
1=Interno;2=Externo |
|
S |
NJR_CTREXT |
C |
20 |
0 |
Ctr.Externo |
@! |
AGRUTILUN() |
|
R |
|
|
S |
NJR_TKPFIS |
C |
1 |
0 |
TKP Fisico? |
@! |
Pertence('12') |
|
R |
1=Sim;2=Nao |
|
S |
NJR_CLASSQ |
C |
1 |
0 |
Contr. Quali |
@! |
Pertence('12') |
|
R |
1=Origem;2=Destino |
|
S |
NJR_TIPALG |
C |
4 |
0 |
Tipo Padrao |
@9 99-9 |
OGA290CPO() |
DXA |
R |
|
|
S |
NJR_HVIUM |
C |
3 |
0 |
UM |
@! |
vazio() .or. existCpo("SAH") |
SAH |
R |
|
M->NJR_HVICAL > "1" |
S |
NJR_TIPUM |
C |
3 |
0 |
UM |
@! |
vazio() .or. existCpo("SAH") |
SAH |
R |
|
M->NJR_TIPCAL > "1" |
S |
NJR_HVICAL |
C |
1 |
0 |
For. Calculo |
@! |
OGA290CPO() |
|
R |
1=Nenhum;2=Valor;3=Percentagem;4=Pontuacao; |
|
S |
NJR_OUTUM |
C |
3 |
0 |
UM |
@! |
vazio() .or. existCpo("SAH") |
SAH |
R |
|
M->NJR_OUTCAL > "1" |
S |
NJR_TIPCAL |
C |
1 |
0 |
For. Calculo |
@! |
OGA290CPO() |
|
R |
1=Nenhum;2=Valor;3=Percentagem;4=Pontuacao; |
|
S |
NJR_HVIFAT |
N |
14 |
6 |
Fator |
@E 9,999,999.999999 |
Positivo() |
|
R |
|
M->NJR_HVICAL = "4" |
S |
NJR_OUTCAL |
C |
1 |
0 |
For. Calculo |
@! |
OGA290CPO() |
|
R |
1=Nenhum;2=Valor;3=Percentagem;4=Pontuacao; |
|
S |
NJR_TIPFAT |
N |
14 |
6 |
Fator |
@E 9,999,999.999999 |
Positivo() |
|
R |
|
M->NJR_TIPCAL = "4" |
S |
NJR_OUTFAT |
N |
14 |
6 |
Fator |
@E 9,999,999.999999 |
Positivo() |
|
R |
|
M->NJR_OUTCAL = "4" |
S |
NJR_HVIREG |
C |
1 |
0 |
Regra HVI |
@! |
OGA290CPO() |
|
R |
1=Media do bloco;2=Fardo a Fardo Todo o Bloco;3=Fardo a Fardo % do Bloco |
M->NJR_HVICAL > "1" |
S |
NJR_HVITOL |
N |
3 |
0 |
% Fardos |
@E 999 |
OGA290CPO() |
|
R |
|
M->NJR_HVICAL > "1" .AND. M->NJR_HVIREG = "3" |
S |
NJR_QAPADR |
C |
6 |
0 |
Padrao HVI |
@! |
OGA290CPO() |
N80NJR |
R |
|
|
S |
NJR_TIPACE |
C |
80 |
0 |
Tp. Opcional |
@! |
OGA290CPO() |
N80ES1 |
R |
|
|
S |
NJR_CODNGC |
C |
6 |
0 |
Cod. Negocio |
@! |
|
|
R |
|
|
S |
NJR_VERSAO |
C |
3 |
0 |
Versao |
@! |
|
|
R |
|
|
S |
NJR_CODEMB |
C |
30 |
0 |
Embalagem |
@! |
vazio() .or. ExistCPO("EE5") |
EE5 |
R |
|
|
S |
NJR_DESEMB |
C |
40 |
0 |
Desc. Emb. |
@! |
|
|
V |
|
|
S |
NJR_CONDPA |
C |
3 |
0 |
Mod.Pgto.Exp |
@! |
vazio() .or. existCpo("EEF") |
AGREEF |
R |
|
M->NJR_TIPMER = "2" |
S |
NJR_DESCPA |
C |
50 |
0 |
Descr. Pagto |
@! |
|
|
V |
|
|
S |
NJR_VIA |
C |
2 |
0 |
Via Transp. |
@! |
vazio() .or. existCPO("SYQ") |
NJRSYQ |
R |
|
M->NJR_TIPMER = "2" |
S |
NJR_DESVIA |
C |
30 |
0 |
Descr. Via |
@! |
|
|
V |
|
|
S |
NJR_INCOTE |
C |
3 |
0 |
Incoterm |
@! |
vazio() .or. existCPO("SYJ") |
SYJ |
R |
|
|
S |
NJR_DESINC |
C |
40 |
0 |
Des INCOTERM |
@! |
|
|
V |
|
|
S |
NJR_BOLSA |
C |
6 |
0 |
Bolsa Ref. |
@! |
ExistCpo("N8C", FwFldGet("NJR_BOLSA")) |
N8C |
R |
|
OGA290NGCW() |
S |
NJR_DBOLSA |
C |
30 |
0 |
Nome Bolsa R |
@! |
|
|
V |
|
|
S |
NJR_CODREM |
C |
3 |
0 |
Cod.Tp.Rem. |
@! |
|
N96 |
R |
|
M->NJR_TIPMER = "2" |
S |
NJR_DESREM |
C |
30 |
0 |
Des.Tp.Rem. |
@! |
|
|
V |
|
|
S |
NJR_TPSEVO |
C |
1 |
0 |
Tp Sel Volum |
@! |
Pertence('123') |
|
R |
1=Por Volume;2=Por Bloco;3=Por Fardo |
|
S |
NJR_CONDPG |
C |
5 |
0 |
Cond. Pagto |
@! |
|
SY6NJR |
R |
|
M->NJR_TIPMER = "2" |
S |
NJR_DIASPG |
N |
3 |
0 |
Dias Pagto |
999 |
|
|
R |
|
M->NJR_TIPMER = "2" |
S |
NJR_DESPG |
C |
50 |
0 |
Des Cond Pag |
@! |
|
|
V |
|
|
S |
NJR_TIPOCL |
C |
1 |
0 |
Tipo Cliente |
@! |
pertence("FLRSX") |
|
R |
F=Cons.Final;L=Prod.Rural;R=Revendedor;S=Solidario;X=Exportacao/Importacao |
|
S |
NJR_CODFIN |
C |
6 |
0 |
Finalidade |
@! |
Vazio() .or. existCpo("N8A") |
N8AN79 |
R |
|
|
S |
NJR_DESFIN |
C |
40 |
0 |
Des. Finalid |
@! |
|
|
V |
|
|
S |
NJR_CLVL |
C |
9 |
0 |
Classe Valor |
@! |
Vazio() .Or. CTB105CLVL() |
CTH |
R |
|
|
S |
NJR_RESFIX |
C |
1 |
0 |
Resp. Fix. |
@! |
Pertence('1/2/3') |
|
R |
1=Comprador;2=Vendedor;3=Ambos |
|
S |
NJR_CHKFIX |
C |
1 |
0 |
Exp. A Fixar |
|
Pertence("12") |
|
R |
1=Sim;2=Nao |
M->NJR_TIPFIX == '2' |
S |
NJR_OPERAC |
C |
1 |
0 |
Referencia |
|
PERTENCE("1/2") |
|
R |
1=Faturamento;2=Pagamento |
M->NJR_TIPMER = '1' .AND. M->NJR_MOEDA != 1 |
S |
NJR_MOEDAR |
N |
2 |
0 |
Moeda |
@E 99 |
OGX010Moed(M->NJR_MOEDAR) |
SM2 |
R |
|
M->NJR_TIPMER = '1' .AND. M->NJR_MOEDA != 1 |
S |
NJR_DESMOR |
C |
20 |
0 |
Des. Moeda |
@! |
|
|
V |
|
|
S |
NJR_DIASR |
N |
2 |
0 |
Qtd Dias |
@E 99 |
POSITIVO() |
|
R |
|
M->NJR_TIPMER = '1' .AND. M->NJR_MOEDA != 1 |
S |
NJR_MOEDAF |
N |
2 |
0 |
Moeda |
@E 99 |
OGX010Moed(M->NJR_MOEDAF) |
SM2 |
R |
|
M->NJR_MOEDA != 1 .AND. M->NJR_OPERAC == "2" |
S |
NJR_DESMOF |
C |
20 |
0 |
Des. Moeda |
@! |
|
|
V |
|
|
S |
NJR_DIASF |
N |
2 |
0 |
Qtd Dias |
@E 99 |
POSITIVO() |
|
R |
|
M->NJR_MOEDA != 1 .AND. M->NJR_OPERAC == "2" |
S |
NJR_TOTNN7 |
N |
13 |
2 |
Total Prev. |
@E 9,999,999,999.99 |
|
|
R |
|
|
S |
NJR_TOTN9G |
N |
13 |
2 |
Total Receb. |
@E 9,999,999,999.99 |
|
|
R |
|
|
S |
NJR_TOTN9K |
N |
13 |
2 |
Total Fat. |
@E 9,999,999,999.99 |
|
|
R |
|
|
S |
NJR_TOTAFT |
N |
13 |
2 |
A faturar |
@E 9,999,999,999.99 |
|
|
R |
|
|
S |
NJR_TOTARB |
N |
13 |
2 |
A receber |
@E 9,999,999,999.99 |
|
|
R |
|
|
S |
NJR_STSMIN |
C |
1 |
0 |
ST Minuta |
@! |
|
|
R |
1=Anexar;2=Aprovar;3=Assinar Resp;4=Envio Resp;5=Assinar Aprov;6=Envio Aprov;7=Retorno Minuta;8=Finalizado;9=Cancelado |
|
S |
NJR_PROMIN |
C |
30 |
0 |
Processo WF |
|
|
|
R |
|
|
S |
NJR_GENMOD |
C |
1 |
0 |
Gen. Modific |
@! |
|
|
R |
1=Nao;2=Sim |
|
S |
NJR_CONPES |
C |
1 |
0 |
Peso consid. |
@! |
Pertence('12') |
|
R |
1=Peso liquido;2=Peso subtotal |
|
S |
NJR_BCOPRV |
C |
3 |
0 |
Banco Prev. |
@! |
existcpo("SA6") |
BCOENT |
R |
|
|
S |
NJR_AGGPRV |
C |
5 |
0 |
Agenc. Prev. |
@! |
existcpo("SA6",FwFldGet("NJR_BCOPRV")+FwFldGet("NJR_AGGPRV")) |
|
R |
|
|
S |
NJR_CTAPRV |
C |
10 |
0 |
Conta Prev. |
@! |
existcpo("SA6",FwFldGet("NJR_BCOPRV")+FwFldGet("NJR_AGGPRV")+FwFldGet("NJR_CTAPRV")) |
|
R |
|
|
S |
NJR_QTDUM2 |
N |
12 |
2 |
Quantidade |
@E 999,999,999.99 |
Positivo() |
|
R |
|
|
S |
NJR_UM2PRO |
C |
2 |
0 |
Unid.Med. |
|
ExistCpo('SAH') |
SAH |
R |
|
|
S |