Tabela |
VSM |
Inconvenientes da OS |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
VSM_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
VSM_NUMOSV |
C |
8 |
0 |
Nro da OS |
@E 99999999 |
FG_Seek("VO1","M->VSM_NUMOSV",1,.f.) |
|
|
|
|
S |
VSM_SEQUEN |
C |
3 |
0 |
Sequencia |
@E 999 |
|
|
|
|
|
S |
VSM_TIPAGR |
C |
1 |
0 |
Agrupador |
@! |
FS_OM010FOK() |
|
|
1=Inconveniente;2=Kit Pecas;3=Srv Agrupado;4=Pecas;5=Servicos |
|
N |
VSM_CODGRU |
C |
3 |
0 |
Cod do Grupo |
@!S3 |
FG_Seek("VSK","VE1->VE1_CODMAR+M->VSM_CODGRU",1,.f.) |
VSK |
|
|
|
S |
VSM_DESGRU |
C |
30 |
0 |
Descricao |
@!S30 |
|
|
V |
|
|
S |
VSM_CODINC |
C |
15 |
0 |
Inconvenient |
@!S15 |
FG_VALIDA(,"VSLTVE1->VE1_CODMAR+M->VSM_CODGRU+M->VSM_CODINC*","M->VSM_DESINC:=VSL->VSL_DESINC,M->VSM_TIPTEM:=VSL->VSL_TIPTEM") |
VSK |
|
|
|
S |
VSM_DESINC |
C |
30 |
0 |
Descr Inconv |
@!S30 |
|
|
|
|
|
S |
VSM_TIPTEM |
C |
4 |
0 |
Tipo Tempo |
@! |
FG_SEEK("VOI","M->VSM_TIPTEM",1,.F.) |
VOI |
|
|
|
S |
VSM_GRUITE |
C |
4 |
0 |
Grupo Item |
@! |
|
|
|
|
|
N |
VSM_CODITE |
C |
27 |
0 |
Cod. Item |
@! |
FG_VALIDA(,"SB1T7M->VSM_GRUITE+M->VSM_CODITE*","M->VSM_DESITE:=SB1->B1_DESC,M->VSM_TIPTEM:=VSL->VSL_TIPTEM") |
|
|
|
|
N |
VSM_DESITE |
C |
30 |
0 |
Desc Item |
@! |
|
|
V |
|
|
N |
VSM_CODSER |
C |
15 |
0 |
Servico |
@! |
FG_VALIDA(,"VO6T2VE1->VE1_CODMAR+M->VSM_CODSER*","M->VSM_DESSER:=VO6->VO6_DESSER") .And. FG_FAPLGM().and. OFC250_AUT() |
VO6SRV |
|
|
|
N |
VSM_DESSER |
C |
30 |
0 |
Desc Servico |
@! |
|
|
V |
|
|
N |
VSM_TEMPAD |
N |
5 |
0 |
Tempo Padrao |
@R 999:99 |
Positivo() |
|
R |
|
|
S |
VSM_QTDITE |
N |
6 |
0 |
Qtd item |
@E 999,999 |
|
|
|
|
|
N |
VSM_QTDEST |
N |
6 |
0 |
Qtd Estoque |
@E 999,999 |
|
|
V |
|
|
N |
VSM_TIPSER |
C |
3 |
0 |
Tipo Servico |
@!S3 |
FG_Seek("VOK","M->VSM_TIPSER",1,.f.) |
VK1 |
|
|
|
N |
VSM_CODPRO |
C |
6 |
0 |
Cod Produtiv |
@! |
FG_StrZero("M->VSM_CODPRO",6).AND.FG_Seek("VAI","M->VSM_CODPRO",1,.f.).AND.VAI->VAI_FUNPRO=="1" |
A1C |
R |
|
|
S |
VSM_CODSEC |
C |
3 |
0 |
Sec Ofi |
@!S3 |
FG_Seek("VOD","M->VSM_CODSEC",1,.f.) |
VOD |
|
|
|
N |
VSM_DATINI |
D |
8 |
0 |
Data inicial |
@D |
(dDataBase-M->VSM_DATINI) <= GETMV("MV_DIAALT") |
|
|
|
|
N |
VSM_HORINI |
N |
4 |
0 |
Hora inicial |
@R 99:99 |
Positivo() .And. M->VSM_HORINI < 2400 .And. Val(right(str(M->VSM_HORINI,4),2)) < 60 |
|
|
|
|
N |
VSM_DATFIN |
D |
8 |
0 |
Data final |
@D |
M->VSM_DATFIN>=M->VSM_DATINI |
|
|
|
|
N |
VSM_HORFIN |
N |
4 |
0 |
Hora final |
@R 99:99 |
Positivo() .And. M->VSM_HORFIN < 2400 .And. Val(Right(Str(M->VSM_HORFIN,4),2)) < 60 |
|
|
|
|
N |
VSM_IMPORT |
C |
1 |
0 |
Importado |
@! |
Pertence("01") |
|
|
0=Nao;1=Sim |
|
N |
VSM_CODCAM |
C |
6 |
0 |
Campanha |
@! |
|
VOP |
R |
|
|
N |
VSM_IDLIST |
N |
10 |
0 |
id lista |
@E 9,999,999,999 |
|
|
R |
|
|
N |
VSM_CODFAS |
C |
3 |
0 |
Fase Produca |
@! |
FG_Seek("VZC","M->VSM_CODFAS",1,.f.,"VSM_DESFAS","VZC_DESFAS") |
|
R |
|
M->VSM_TIPAGR=="3" |
N |
VSM_IDTREE |
C |
7 |
0 |
id tree |
@! |
|
|
R |
|
|
N |
VSM_DESFAS |
C |
30 |
0 |
Desc Fase |
@! |
|
|
V |
|
|
N |
VSM_IDCODE |
C |
7 |
0 |
id code |
@! |
|
|
R |
|
|
N |
VSM_ISTREE |
C |
1 |
0 |
is tree |
@! |
|
|
R |
|
|
N |
VSM_PROMPT |
C |
200 |
0 |
prompt |
@! |
|
|
R |
|
|
N |
VSM_CARGO |
C |
200 |
0 |
cargo |
@! |
|
|
R |
|
|
N |
VSM_CLIENT |
C |
10 |
0 |
client |
@! |
|
|
R |
|
|
N |
VSM_NUMORC |
C |
8 |
0 |
Nro do Orcto |
@ 99999999 |
|
|
|
|
|
N |
VSM_CODMAR |
C |
3 |
0 |
Marca |
@!S3 |
|
VE1 |
|
|
|
N |
VSM_VALOR |
N |
14 |
2 |
Valor |
@E 99,999,999,999.99 |
Positivo() |
|
|
|
|
S |
VSM_PERDES |
N |
6 |
2 |
% desc |
@E 999.99 |
Positivo() |
|
|
|
|
S |
VSM_VALDES |
N |
12 |
2 |
Valor desc |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
S |
VSM_TOTAL |
N |
12 |
2 |
Total |
@E 999,999,999.99 |
|
|
R |
|
|
S |
VSM_OBSERV |
M |
70 |
0 |
Observacao |
@! |
|
|
V |
|
|
S |
VSM_OBSMEM |
C |
6 |
0 |
Obs |
|
|
|
|
|
|
S |
VSM_APROVA |
C |
1 |
0 |
Aprovado |
@! |
Pertence("01") |
|
R |
0=Nao;1=Sim |
|
N |