
| 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 | ||||