Tabela |
VG5 |
Pecas x Servicos Garantia |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
VG5_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
VG5_NUMOSV |
C |
8 |
0 |
Numero da OS |
@!S8 |
|
|
|
|
|
S |
VG5_NUMNFI |
C |
9 |
0 |
Numero da NF |
@! |
|
|
R |
|
|
S |
VG5_SERIEN |
C |
3 |
0 |
Serie NF |
@!S3 |
|
|
|
|
|
S |
VG5_ORDITE |
C |
2 |
0 |
Ordem Item |
@!S2 |
FG_StrZero("M->VG5_ORDITE",2) |
|
|
|
|
S |
VG5_CODMAR |
C |
3 |
0 |
Marca |
@!S3 |
FG_Seek("VE1","VGA->VGA_CODMAR",1,.f.,"VG5_DESMAR","VE1_DESMAR") |
VE1 |
|
|
|
S |
VG5_DESMAR |
C |
30 |
0 |
Descricao |
@!S30 |
|
|
V |
|
|
S |
VG5_ITEEXT |
C |
1 |
0 |
Item Adicion |
@!S1 |
Pertence("01") |
|
|
0=Nao;1=Sim |
|
S |
VG5_GRUITE |
C |
4 |
0 |
Grupo Item |
@!S4 |
Vazio() .or.(FG_Seek("SBM","M->VG5_GRUITE",1,.f.,"VG5_DESGRU","BM_DESC")) |
E03 |
|
|
|
S |
VG5_DESGRU |
C |
30 |
0 |
Descricao |
@!S30 |
|
|
V |
|
|
S |
VG5_CODITE |
C |
27 |
0 |
Codigo Item |
@!S27 |
Vazio() .or. FG_Seek("SB1","M->VG5_GRUITE+M->VG5_CODITE",7,.f.,"VG5_DESITE","B1_DESC") |
B04 |
|
|
|
S |
VG5_DESITE |
C |
30 |
0 |
Descricao |
@!S30 |
|
|
R |
|
|
S |
VG5_PECINT |
C |
15 |
0 |
Cod. Int. PC |
@! |
|
|
|
|
|
S |
VG5_QTDITE |
N |
6 |
0 |
Quantidade |
@E 999,999 |
Positivo() |
|
|
|
|
S |
VG5_CODDEF |
C |
3 |
0 |
Cod. Defeito |
@!S3 |
FG_Seek("VG0","M->VGA_CODMAR+M->VG5_CODDEF",1,.f.,"VG5_DESDEF","VG0_DESDEF") |
VG0 |
|
|
|
S |
VG5_DESDEF |
C |
15 |
0 |
Desc.Defeito |
@!S15 |
|
|
V |
|
|
S |
VG5_CODFOR |
C |
3 |
0 |
Cd Forneced. |
@!S3 |
NaoVazio() |
VG7 |
|
|
|
S |
VG5_SEREXT |
C |
1 |
0 |
Srv Adicion |
@!S1 |
Pertence("01") |
|
|
0=Nao;1=Sim |
|
S |
VG5_CODSER |
C |
15 |
0 |
Cod Servico |
@!S15 |
Vazio() .or. FG_Seek("VO6","M->VGA_CODMAR+M->VG5_CODSER",2,.f.,"VG5_DESSER","VO6_DESSER") |
VGS |
|
|
|
S |
VG5_DESSER |
C |
20 |
0 |
Desc.Servico |
@!S20 |
|
|
V |
|
|
S |
VG5_SERINT |
C |
6 |
0 |
Cod.Int.Serv |
@!S6 |
FG_Seek("VO6","FG_MARSRV(VGA->VGA_CODMAR)+M->VG5_CODSER",2,.f.,"VG5_SERINT","VO6_SERINT") |
|
|
|
|
S |
VG5_TEMPAD |
N |
5 |
0 |
T.P.Reparo |
@E 99,999 |
Positivo() |
|
|
|
|
S |
VG5_VALPEC |
N |
12 |
2 |
Vl Material |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
S |
VG5_OBSERV |
C |
175 |
0 |
Observacao |
@!S175 |
NaoVazio() |
|
|
|
|
S |
VG5_TRANSM |
C |
1 |
0 |
Transmitido |
@!S1 |
|
|
|
|
|
S |
VG5_LANCRE |
C |
6 |
0 |
Num. Lancto. |
@! |
|
|
R |
|
|
S |
VG5_DATCRE |
D |
8 |
0 |
Data Credito |
|
|
|
R |
|
|
S |
VG5_DATRET |
D |
8 |
0 |
Data Retorno |
|
|
|
R |
|
|
S |
VG5_QTDREC |
N |
6 |
0 |
Qtd. Recall |
@E 999,999 |
|
|
R |
|
|
S |
VG5_NFIENT |
C |
6 |
0 |
NF. Entrada |
@! |
|
|
R |
|
|
S |
VG5_SERENT |
C |
3 |
0 |
Serie NF Ent |
@! |
|
|
R |
|
|
S |
VG5_GRUINC |
C |
3 |
0 |
Grupo Inc |
@! |
FG_Seek("VSK","M->VGA_CODMAR+M->VG5_GRUINC",1,.f.) |
VSK |
|
|
|
S |
VG5_CODINC |
C |
15 |
0 |
Inconvenient |
@! |
FG_Seek("VSL","M->VGA_CODMAR+M->VG5_GRUINC+M->VG5_CODINC",1,.f.) |
VSL |
|
|
|
S |
VG5_ENVGAR |
C |
1 |
0 |
Enviar |
@! |
Pertence("01") |
|
|
1=Sim;0=Nao |
|
S |
VG5_DATDEB |
D |
8 |
0 |
Dt Lancament |
|
|
|
R |
|
|
N |
VG5_LANDEB |
C |
6 |
0 |
Nro Lanc |
@! |
|
|
R |
|
|
N |
VG5_SDOCE |
C |
3 |
0 |
Ser.NF Entra |
!!! |
|
|
R |
|
|
S |
VG5_SDOCS |
C |
3 |
0 |
Serie Doc. |
!!! |
|
|
R |
|
|
S |