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 |