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