Tabela
TNF EPI Entregues Funcionarios
Campo Tipo Tamanho Decimal Titulo Formato Validacao F3 Contexto Lista Condicao PYME
TNF_FILIAL C 2 0 Filial N
TNF_CODEPI C 15 0 Codigo @! MDTVALTNF() .And. MDTProEpi(M->TNF_CODEPI,cTipo,lSX5) .AND. fEPIMDT695(M->TNF_CODEPI) MDTSB1 N
TNF_DESC C 20 0 Descricao @! V N
TNF_FORNEC C 6 0 Fornecedor @! SA2 lWhenEpi N
TNF_LOJA C 2 0 Loja @! SA2 lWhenEpi N
TNF_NUMCAP C 12 0 Num. C. A. @! lWhenEpi N
TNF_MAT C 6 0 Matricula 999999 MDTVALTNF() .And. ExCpoMDT("SRA",M->TNF_MAT) MDTSRA N
TNF_NOME C 20 0 Funcionario @! V N
TNF_DTENTR D 8 0 Data Entrega MDTVALTNF() .And. fNgDtTNF(M->TNF_DTENTR) N
TNF_HRENTR C 5 0 Hora Entrega 99:99 MDTVALTNF() N
TNF_QTDENT N 6 2 Quant. Entr. @E 999.99 MDTVALTNF() .And. fQtdadeTNF(M->TNF_QTDENT) N
TNF_QTDEVO N 6 2 Quant.Devol. @E 999.99 R N
TNF_MOTIVO C 1 0 Motivo Entr. @! MDTVALTNF() 1=Admissional;2=Desgaste;3=Defeito;4=Perda;5=Roubo;6=Demissional;7=Higienizacao;8=Teste Dieletrico;X=Outros N
TNF_LOCAL C 2 0 Almoxarifado @! MDTVALTNF() .And. ExistCpo("NNR") R N
TNF_INDDEV C 1 0 Situacao EPI @! fIndiDvTNF(M->TNF_INDDEV) 1=Epi devolvido;2=Epi em uso;3=Epi em Solic. Armazem N
TNF_DTDEVO D 8 0 Data Devol. fDataDvTNF(M->TNF_DTDEVO) .And. MDT695DEVO() MDTTNFWHEN() N
TNF_TIPODV C 1 0 Repor Estoq. @! R 1=Sim;2=Nao MDTTNFWHEN() N
TNF_EPIEFI C 1 0 Epi Eficaz MDTVALTNF() R 1=Sim;2=Nao;3=NA Alltrim(GETMV("MV_NG2CEPI")) == "S" N
TNF_DTRECI D 8 0 Data Emissao N
TNF_DTMANU D 8 0 Ult. Manut. MDTVALTNF() R N
TNF_CODFUN C 5 0 Funcao @! EXISTCPO("SRJ",M->TNF_CODFUN) SRJ N
TNF_NUMSEQ C 6 0 Num.Seq.SD3 @! R N
TNF_CUSTO N 12 2 Custo @E 99,999,999.99 R N
TNF_NUMSA C 6 0 Numero S.A. @! R N
TNF_ITEMSA C 2 0 Item S.A. @! R N
TNF_LOTECT C 10 0 Lote MDTVALTNF() .And. MdtVldSBF(1) R N
TNF_LOTESB C 6 0 Sub-Lote @! MDTVALTNF() .And. MdtVldSBF(2) R N
TNF_ENDLOC C 15 0 Localizacao @! MDTVALTNF() .And. MdtVldSBF(3) SBE R N
TNF_NSERIE C 20 0 Numero Serie @! MDTVALTNF() R N
TNF_DIGIT1 C 200 0 Dig. Part. 1 @! R N
TNF_DIGIT2 C 200 0 Dig. Part. 2 @! R N
TNF_DEVBIO C 1 0 Dev. Biomet @! PERTENCE('12') R 1=Sim;2=Nao S
TNF_LOCDV C 2 0 Armazem Dev. @! If(!Empty(M->TNF_LOCDV),ExistCpo("NNR"),.T.) R MDTTNFWHEN() S
TNF_SAILOG C 15 0 Saida Logix @! R N
TNF_ENTLOG C 15 0 Entr. Logix @! R N
TNF_CODOBS C 6 0 Observacoes @! R N
TNF_OBSLOG M 80 0 Observacoes V N