Tabela |
TT1 |
PROGRAMACAO DE OS |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
TT1_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
TT1_CODIGO |
C |
6 |
0 |
Programacao |
999999 |
|
|
R |
|
|
S |
TT1_DESCRI |
C |
60 |
0 |
Descricao |
@! |
|
|
R |
|
|
S |
TT1_DTPROG |
D |
8 |
0 |
Data Prog. |
99/99/9999 |
|
|
R |
|
|
S |
TT1_DTFIM |
D |
8 |
0 |
Data Fim |
99/99/9999 |
|
|
R |
|
|
S |
TT1_RESPON |
C |
6 |
0 |
Responsavel |
@! |
|
SRA |
R |
|
|
S |
TT1_NOMRES |
C |
30 |
0 |
Nome Resp. |
@! |
|
|
V |
|
|
S |
TT1_USERGI |
C |
17 |
0 |
Log de Inclu |
|
|
|
R |
|
|
S |
TT1_USERGA |
C |
17 |
0 |
Log de Alter |
|
|
|
R |
|
|
S |
TT1_BEMDE |
C |
16 |
0 |
De Bem |
@! |
|
|
R |
|
|
S |
TT1_BEMATE |
C |
16 |
0 |
Ate Bem |
@! |
|
|
R |
|
|
S |
TT1_EQUDE |
C |
6 |
0 |
De Equipe |
@! |
|
|
R |
|
|
S |
TT1_EQUATE |
C |
6 |
0 |
Ate Equipe |
@! |
|
|
R |
|
|
S |
TT1_CCDE |
C |
9 |
0 |
De C.Custo |
@! |
|
|
R |
|
|
S |
TT1_CCATE |
C |
9 |
0 |
Ate C.Custo |
@! |
|
|
R |
|
|
S |
TT1_STADE |
C |
6 |
0 |
De Status |
@! |
|
|
R |
|
|
S |
TT1_STAATE |
C |
6 |
0 |
Ate Status |
@! |
|
|
R |
|
|
S |
TT1_DTDE |
D |
8 |
0 |
De Data |
99/99/99 |
|
|
R |
|
|
S |
TT1_DTATE |
D |
8 |
0 |
Ate Data |
99/99/99 |
|
|
R |
|
|
S |
TT1_DTCALE |
D |
8 |
0 |
Dt. Calendar |
99/99/9999 |
|
|
R |
|
|
S |
TT1_TRADE |
C |
6 |
0 |
De C. Trab. |
@! |
|
|
R |
|
|
N |
TT1_TRAATE |
C |
6 |
0 |
Ate C. Trab. |
@! |
|
|
R |
|
|
N |
TT1_TIPDE |
C |
3 |
0 |
De Tipo |
@! |
|
|
R |
|
|
N |
TT1_TIPATE |
C |
3 |
0 |
Ate Tipo |
@! |
|
|
R |
|
|
N |
TT1_AREDE |
C |
6 |
0 |
De Area |
@! |
|
|
R |
|
|
N |
TT1_AREATE |
C |
6 |
0 |
Ate Area |
@! |
|
|
R |
|
|
N |
TT1_FAMDE |
C |
6 |
0 |
De Familia |
@! |
|
|
R |
|
|
N |
TT1_FAMATE |
C |
6 |
0 |
Ate Familia |
@! |
|
|
R |
|
|
N |
TT1_SERDE |
C |
6 |
0 |
De Servico |
@! |
|
|
R |
|
|
N |
TT1_SERATE |
C |
6 |
0 |
Ate Servico |
@! |
|
|
R |
|
|
N |
TT1_ORDDE |
C |
6 |
0 |
De Ordem |
@! |
|
|
R |
|
|
N |
TT1_ORDATE |
C |
6 |
0 |
Ate Ordem |
@! |
|
|
R |
|
|
N |
TT1_PLADE |
C |
6 |
0 |
De Plano |
@! |
|
|
R |
|
|
N |
TT1_PLAATE |
C |
6 |
0 |
Ate Plano |
@! |
|
|
R |
|
|
N |
TT1_VEROSS |
C |
1 |
0 |
Ver OS? |
@! |
|
|
R |
1=Todas;2=OS da data selecionada |
|
N |
TT1_EVEDE |
C |
6 |
0 |
De Evento |
@! |
|
|
R |
|
|
N |
TT1_EVEATE |
C |
6 |
0 |
Ate Evento |
@! |
|
|
R |
|
|
N |
TT1_CDEVEN |
C |
6 |
0 |
Evento |
@! |
If(Empty(M->TT1_CDEVEN),.T.,ExistCpo('TTQ',M->TT1_CDEVEN)) |
TTQ |
R |
|
|
N |
TT1_INDLUB |
C |
1 |
0 |
O.S. Lubrif. |
@! |
|
|
R |
1=Sim;2=Nao |
|
N |
TT1_INDLOC |
C |
1 |
0 |
O.S. Locali. |
@! |
|
|
R |
1=Sim;2=Nao |
|
N |
TT1_CONDTA |
C |
1 |
0 |
Dt. atrasada |
@! |
Pertence('12') |
|
R |
1=Sim;2=Nao |
|
S |
TT1_PROGAU |
C |
1 |
0 |
Prog. Auto.? |
@! |
Pertence('1234') |
|
R |
1=Corretiva;2=Preventiva;3=Ambas;4=Nenhuma |
|
S |
TT1_PRIDE |
C |
3 |
0 |
De Priorid. |
@! |
|
|
R |
|
|
S |
TT1_PRIATE |
C |
3 |
0 |
Ate Priorid. |
@! |
|
|
R |
|
|
S |
TT1_ETADE |
C |
6 |
0 |
De Etapa |
@! |
|
|
R |
|
|
S |
TT1_ETAAT |
C |
6 |
0 |
Ate Etapa |
@! |
|
|
R |
|
|
S |
TT1_INCRE |
C |
1 |
0 |
Incremento |
@! |
|
|
|
1=Igual a;2=Menor que;3=Nemor ou Igual a;4=Maior que;5=Maior ou igual que |
|
S |
TT1_QTDDIA |
N |
4 |
0 |
Dias |
9999 |
|
|
R |
|
|
S |
TT1_CALEDE |
C |
3 |
0 |
De Calend. |
@! |
|
|
R |
|
|
S |
TT1_CALEAT |
C |
3 |
0 |
Ate Calend. |
@! |
|
|
R |
|
|
S |
TT1_ESTRUT |
C |
1 |
0 |
Estrutura |
@! |
|
|
|
|
|
S |