Tabela
NV4 Lancamento Tabelado
Campo Tipo Tamanho Decimal Titulo Formato Validacao F3 Contexto Lista Condicao PYME
NV4_FILIAL C 2 0 Filial J202RTKT("NV4") R N
NV4_TKRET L 1 0 Marcar ? J202RTKT("NV4") V !Empty(FwFldGet("NV4_CPREFT")) N
NV4_COD C 6 0 Codigo ExistChav('NV4',M->NV4_COD,1) R N
NV4_DTLANC D 8 0 Dt Lanc R FwFldGet('NV4_SITUAC') == '1' N
NV4_CGRUPO C 6 0 Cod Grupo @! Vazio() .Or. J027ValCpo() ACY R FwFldGet('NV4_SITUAC') == '1' N
NV4_DGRUPO C 30 0 Grupo @! V N
NV4_CCLIEN C 6 0 Cod Cliente @! Vazio() .Or. J027ValCpo() SA1NUH R FwFldGet('NV4_SITUAC') == '1' N
NV4_CLOJA C 2 0 Cod Loja @! Vazio() .Or. J027ValCpo() R FwFldGet('NV4_SITUAC') == '1' N
NV4_DCLIEN C 40 0 Nome Cliente V N
NV4_CCASO C 6 0 Cod Caso Vazio() .Or. J027ValCpo() NVELOJ R FwFldGet('NV4_SITUAC') == '1'.AND.JA027VLCLC('NV4_CCASO') N
NV4_DCASO C 200 0 Desc Caso @S100 V N
NV4_SIGLA C 5 0 Sigla part Vazio().OR.JurVldPart("NV4_SIGLA") RD0ATV V FwFldGet('NV4_SITUAC') == '1' S
NV4_CPART C 6 0 Cod Part Vazio().Or.Iif(JurIsRest(),JurVldPart("NV4_CPART"), .T.) R FwFldGet('NV4_SITUAC') == '1' N
NV4_DPART C 30 0 Participante V N
NV4_CTPSRV C 20 0 Cod Tp Serv Vazio() .OR. J027ValCpo() NRD R FwFldGet('NV4_SITUAC') == '1'.AND.JA027VLCLC('NV4_CTPSRV') N
NV4_DTPSRV C 200 0 Desc Tp Serv @S100 V N
NV4_QUANT N 4 0 Qtd Servicos @E 9999 POSITIVO() .AND. J027ValCpo() R FwFldGet('NV4_SITUAC') == '1' N
NV4_CMOEH C 2 0 Cod. Moeda J027ValCpo() JURCTO R FwFldGet("NV4_SITUAC") == "1".AND.JA027VLCLC("NV4_CMOEH") N
NV4_DMOEH C 10 0 Desc Moeda V N
NV4_VLHFAT N 16 2 Vlr Hon Fat @E 9,999,999,999,999.99 JA202VAL( 'NV4_VLHFAT' ) R FwFldGet('NV4_SITUAC') == '1' N
NV4_VLHTAB N 16 2 Vlr Hon Tab @E 9,999,999,999,999.99 R FwFldGet('NV4_SITUAC') == '1' N
NV4_CMOED C 2 0 Cod Moe Taxa J027ValCpo() JURCTO R FwFldGet("NV4_SITUAC") == "1".AND.JA027VLCLC("NV4_CMOED") N
NV4_DMOED C 10 0 Des Moe Taxa V N
NV4_VLDFAT N 16 2 Vlr Taxa Fat @E 9,999,999,999,999.99 R FwFldGet('NV4_SITUAC') == '1' N
NV4_VLDTAB N 16 2 Vlr Taxa Tab @E 9,999,999,999,999.99 R FwFldGet('NV4_SITUAC') == '1' N
NV4_DESCRI M 10 0 Desc Lanc R N
NV4_CONC C 1 0 Concluido? Pertence("12") R 1=Sim;2=Nao FwFldGet('NV4_SITUAC') == '1' N
NV4_DTCONC D 8 0 Dt Conclusao Vazio() .OR. (JurVldPart("NV4_DTCONC") .AND. J027ValCpo()) R FwFldGet('NV4_SITUAC') == '1'.and.FwFldGet('NV4_CONC') =='1' N
NV4_COBRAR C 1 0 Cobrar? Pertence("12") R 1=Sim;2=Nao FwFldGet('NV4_SITUAC') == '1' N
NV4_SITUAC C 1 0 Situacao Pertence("12") R 1=Pendente;2=Concluido N
NV4_DTINC D 8 0 Dt Inclusao R FwFldGet('NV4_SITUAC') == '1' N
NV4_HRINC C 8 0 Hr Inclusao @R 99:99:99 R FwFldGet('NV4_SITUAC') == '1' N
NV4_FINANC C 1 0 Gerar CP? Pertence("12") R 1=Sim;2=Nao FwFldGet("NV4_SITUAC") == "1".AND.J027CPW() N
NV4_ANOMES C 6 0 Ano-Mes @R 9999-99 R FwFldGet('NV4_SITUAC') == '1' N
NV4_CPREFT C 8 0 Cod Pre-Fat R FwFldGet('NV4_SITUAC') == '1' N
NV4_OK C 2 0 Marca OK R FwFldGet('NV4_SITUAC') == '1' N
NV4_COTAC1 N 8 5 Cotacao 1 @E 99.99999 R FwFldGet('NV4_SITUAC') == '1' N
NV4_COTAC2 N 8 5 Cotacao 2 @E 99.99999 R FwFldGet('NV4_SITUAC') == '1' N
NV4_CLOTE C 6 0 Codigo Lote R N
NV4_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
NV4_CCLILD C 6 0 Cl Transf LD @! Vazio() .Or. J027ValCpo() R S
NV4_CLJLD C 2 0 Lj Transf LD @! Vazio() .Or. J027ValCpo() R S
NV4_CCSLD C 6 0 Caso Tsf LD Vazio() .Or. J027ValCpo() R S
NV4_PARTLD C 6 0 Part Acao LD Vazio().Or.ExistCpo('RD0',FWFLDGET('NV4_PARTLD'),1) R S
NV4_CMOTWO C 3 0 Cd Mot WO LD Vazio().Or.JurVldMot("4",.T.,.F.,"NXVEMI") R S
NV4_OBSWO M 10 0 Observ WO LD R S
NV4_CDWOLD C 50 0 Cod WO no LD R S
NV4_COTAC N 8 5 Cotacao @E 99.99999 R S