Tabela |
NVY |
Despesas |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
NVY_FILIAL |
C |
2 |
0 |
Filial |
|
J202RTKT("NVY") |
|
R |
|
|
N |
NVY_TKRET |
L |
1 |
0 |
Marcar ? |
|
J202RTKT("NVY") |
|
V |
|
!Empty(FwFldGet("NVY_CPREFT")) |
N |
NVY_OK |
C |
4 |
0 |
Marca Ok |
|
|
|
R |
|
|
N |
NVY_COD |
C |
8 |
0 |
Codigo |
|
|
|
R |
|
JA049WHEN() |
N |
NVY_CGRUPO |
C |
6 |
0 |
Cod Grupo |
|
Vazio() .OR. J049VldCli() |
ACY2 |
R |
|
JA049WHEN() |
N |
NVY_DGRUPO |
C |
30 |
0 |
Desc Grupo |
|
|
|
V |
|
JA049WHEN() |
N |
NVY_CCLIEN |
C |
6 |
0 |
Cod Cliente |
@! |
Vazio() .OR. J049VldCli() |
SA1NUH |
R |
|
JA049WHEN() |
N |
NVY_CLOJA |
C |
2 |
0 |
Cod Loja |
@! |
Vazio() .OR. J049VldCli() |
|
R |
|
JA049WHEN() |
N |
NVY_DCLIEN |
C |
40 |
0 |
Nome Cliente |
|
|
|
V |
|
JA049WHEN() |
N |
NVY_CCASO |
C |
6 |
0 |
Cod Caso |
|
VAZIO() .OR. J049VldCli() |
NVELOJ |
R |
|
JA49VLCLI().AND.JA049WHEN() |
N |
NVY_DCASO |
C |
200 |
0 |
Titulo Caso |
@S20 |
|
|
V |
|
JA049WHEN() |
N |
NVY_DATA |
D |
8 |
0 |
Data |
|
JurVlDtDp(FwFldGet("NVY_DATA")).And.J049VlDDP().And.JurVldPart("NVY_DATA").And.J049VldCli() |
|
R |
|
JA049WHFIN().AND.JA049WHEN() |
N |
NVY_SIGLA |
C |
5 |
0 |
Sig Solicit |
|
Vazio().OR.JurVldPart("NVY_SIGLA") |
RD0ATV |
V |
|
|
S |
NVY_CPART |
C |
6 |
0 |
Cod Solicita |
|
Vazio().Or.Iif(JurIsRest(),JurVldPart("NVY_CPART"), .T.) |
RD0ATV |
R |
|
JA049WHEN() |
N |
NVY_DPART |
C |
30 |
0 |
Solicitante |
|
|
|
V |
|
JA049WHEN() |
N |
NVY_CTPDSP |
C |
4 |
0 |
Cod Tp Desp |
|
JA049VALC() |
NRH |
R |
|
JA049WHEN() |
N |
NVY_DTPDSP |
C |
50 |
0 |
Desc Tp Desp |
|
|
|
V |
|
JA049WHEN() |
N |
NVY_CMOEDA |
C |
2 |
0 |
Moeda |
|
(ExistCpo('CTO',FWFLDGET('NVY_CMOEDA'),1).AND.(JAVLDCAMPO('NVYMASTER', 'NVY_CMOEDA','CTO', 'CTO_BLOQ', '2' ))).OR.Vazio() |
JURCTO |
R |
|
JA049WHFIN().AND.JA049WHEN() |
N |
NVY_DMOEDA |
C |
10 |
0 |
Desc Moeda |
|
|
|
V |
|
JA049WHEN() |
N |
NVY_VALOR |
N |
9 |
2 |
Valor |
@E 999,999.99 |
|
|
R |
|
JA049WHFIN().AND.JA049WHEN() |
N |
NVY_QTD |
N |
3 |
0 |
Quantidade |
@E 999 |
Positivo() |
|
R |
|
JA049WHEN() |
N |
NVY_DESCRI |
M |
10 |
0 |
Descricao |
|
|
|
R |
|
|
N |
NVY_COBRAR |
C |
1 |
0 |
Cobrar? |
|
JA49VLDCB() |
|
R |
1=Sim;2=Nao |
JA049WHEN() |
N |
NVY_OBSCOB |
C |
200 |
0 |
Obs Nao Cob |
@S20 |
|
|
R |
|
FwFldGet("NVY_COBRAR") == "2" |
N |
NVY_USRNCB |
C |
15 |
0 |
User N Cob |
|
|
|
R |
|
JA049WHEN() |
N |
NVY_OBS |
M |
10 |
0 |
Observacao |
|
|
|
R |
|
JA049WHEN() |
N |
NVY_SITUAC |
C |
1 |
0 |
Situacao |
|
|
|
R |
1=Pendente;2=Concluido |
JA049WHEN() |
N |
NVY_CPREFT |
C |
8 |
0 |
Cod Pre-Fat |
|
|
|
R |
|
JA049WHEN() |
N |
NVY_CRAT |
C |
10 |
0 |
Cod Rateio |
|
|
|
R |
|
JA049WHEN() |
N |
NVY_CDETRT |
C |
3 |
0 |
Cod Item Rat |
|
|
|
R |
|
JA049WHEN() |
N |
NVY_DESDIV |
C |
1 |
0 |
Dividida? |
|
|
|
R |
1=Sim;2=Nao |
JA049WHEN() |
N |
NVY_CODPAI |
C |
8 |
0 |
Cod Pai Desp |
|
|
|
R |
|
JA049WHEN() |
N |
NVY_ANOMES |
C |
6 |
0 |
Ano-Mes |
|
|
|
R |
|
JA049WHEN() |
N |
NVY_COTAC1 |
N |
8 |
5 |
Cotacao 1 |
@E 99.99999 |
|
|
R |
|
|
N |
NVY_COTAC2 |
N |
8 |
5 |
Cotacao 2 |
@E 99.99999 |
|
|
R |
|
|
N |
NVY_TPCOB |
C |
1 |
0 |
Cobravel? |
@! |
|
|
V |
1=Cobravel;2=Nao cobravel |
|
N |
NVY_DURTEL |
N |
16 |
0 |
Tempo Liga |
@E 9,999,999,999,999,999 |
Positivo() |
|
R |
|
|
S |
NVY_ACAOLD |
C |
1 |
0 |
Acoes LD |
|
Vazio().Or.Pertence("12345") |
|
R |
1=Retirar;2=Transferir;3=WO;4=Lancamento indevido;5=Transferir e retirar |
|
S |
NVY_CCLILD |
C |
6 |
0 |
Cl Transf LD |
@! |
Vazio().OR.J049VldCli() |
|
R |
|
|
S |
NVY_CLJLD |
C |
2 |
0 |
Lj Transf LD |
@! |
Vazio().OR.J049VldCli() |
|
R |
|
|
S |
NVY_CCSLD |
C |
6 |
0 |
Caso Tsf LD |
|
Vazio().OR.J049VldCli() |
|
R |
|
|
S |
NVY_PARTLD |
C |
6 |
0 |
Part Acao LD |
|
Vazio().Or.ExistCpo('RD0',FWFLDGET('NVY_PARTLD'),1) |
|
R |
|
|
S |
NVY_CMOTWO |
C |
3 |
0 |
Cd Mot WO LD |
|
Vazio().Or.JurVldMot("4",.T.,.F.,"NXVEMI") |
|
R |
|
|
S |
NVY_OBSWO |
M |
10 |
0 |
Observ WO LD |
|
|
|
R |
|
|
S |
NVY_FILLAN |
C |
2 |
0 |
Filial Lanc. |
|
|
|
R |
|
|
S |
NVY_CDWOLD |
C |
50 |
0 |
Cod WO no LD |
|
|
|
R |
|
|
S |
NVY_CLANC |
C |
10 |
0 |
Codigo Lanc. |
|
|
|
R |
|
|
S |
NVY_CPAGTO |
C |
100 |
0 |
C Ctas Pagar |
|
|
|
R |
|
|
S |
NVY_ITDES |
C |
4 |
0 |
It. Desdobra |
|
|
|
R |
|
|
S |
NVY_ITDPGT |
C |
4 |
0 |
It. Desd Pag |
|
|
|
R |
|
|
S |
NVY_COTAC |
N |
8 |
5 |
Cotacao |
@E 99.99999 |
|
|
R |
|
|
S |