Tabela |
VG6 |
Pecas x Servicos Garantia |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
VG6_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
R |
|
|
S |
VG6_NUMOSV |
C |
8 |
0 |
Numero da OS |
@!S8 |
|
|
R |
|
|
S |
VG6_CODMAR |
C |
3 |
0 |
Marca |
@!S3 |
Vazio() .or. FG_Seek("VE1","M->VG6_CODMAR",1,.f.,"VG6_DESMAR","VE1_DESMAR") |
VE1 |
R |
|
|
S |
VG6_DESMAR |
C |
30 |
0 |
Descricao |
@!S30 |
|
|
V |
|
|
S |
VG6_ANORRC |
C |
4 |
0 |
Ano da RR |
@!S4 |
FG_Seek("VG4","M->VG6_ANORRC",1,.f.) |
|
R |
|
|
S |
VG6_NUMRRC |
C |
7 |
0 |
Numero da RR |
@!S7 |
FG_Strzero("M->VG6_NUMRRC",7,.F.).and. IIF(FUNNAME()=="OFIGM060()",M->VG6_NUMRRC==VG4->VG4_NUMERO,NaoVazio()) |
VG4 |
R |
|
|
S |
VG6_ITEEXT |
C |
1 |
0 |
Item Espec. |
@!S1 |
Pertence("01") |
|
R |
0=Nao;1=Sim |
|
S |
VG6_TPCUST |
C |
1 |
0 |
Tp Custo |
@K! |
PERTENCE("1239") |
|
R |
1=MO Terceiro;2=Mat Terceiro;3=Oleo/Lubrificante;9=MO nao Catalogada |
|
S |
VG6_GRUITE |
C |
4 |
0 |
Grupo Item |
@!S4 |
IF(M->VG6_ITEEXT="0", Vazio() .or. FG_Seek("SBM","M->VG6_GRUITE",1,.f.,"VG6_DESGRU","BM_DESC"),.T.) |
E04 |
R |
|
|
S |
VG6_DESGRU |
C |
30 |
0 |
Descricao |
@!S30 |
|
|
V |
|
|
S |
VG6_CODITE |
C |
27 |
0 |
Codigo Item |
@!S27 |
IF(M->VG6_ITEEXT="0", Vazio() .or. FG_Seek("SB1","M->VG6_GRUITE+M->VG6_CODITE",7,.f.,"VG6_DESITE","B1_DESC"),.T.) |
B05 |
R |
|
|
S |
VG6_DESITE |
C |
30 |
0 |
Descricao |
@!S30 |
|
|
V |
|
|
S |
VG6_PECINT |
C |
15 |
0 |
Cod.Int. Pc. |
@! |
|
|
R |
|
|
S |
VG6_QTDITE |
N |
6 |
0 |
Quantidade |
@E 999,999 |
M->VG6_QTDITE>0 |
|
R |
|
|
S |
VG6_VALITE |
N |
12 |
2 |
Valor Item |
@E 999,999,999.99 |
M->VG6_VALITE>0 |
|
R |
|
|
S |
VG6_NOSNUP |
C |
8 |
0 |
Nos.Nro.Peca |
@!S8 |
|
|
R |
|
|
S |
VG6_SEREXT |
C |
1 |
0 |
Sv. Especial |
@!S1 |
Pertence("01") |
|
R |
0=Nao;1=Sim |
|
S |
VG6_CODSER |
C |
15 |
0 |
Cod Servico |
@!S15 |
if(M->VG6_SEREXT="0",FG_SeeK("VO6","M->VG6_SERINT",1,.f.,"VG6_DESSER","VO6_DESSER"),.T.) |
OX6 |
R |
|
|
S |
VG6_DESSER |
C |
40 |
0 |
Desc Servico |
@!S30 |
|
|
R |
|
|
S |
VG6_SERINT |
C |
6 |
0 |
Cod.Int.Ser. |
@!S6 |
|
|
R |
|
|
S |
VG6_TPOGAR |
N |
5 |
0 |
Tpo.Garantia |
@E 99,999 |
M->VG6_TPOGAR>0 |
|
R |
|
|
S |
VG6_VALSER |
N |
12 |
2 |
Valor Servic |
@E 999,999,999.99 |
M->VG6_VALSER>0 |
|
R |
|
|
S |
VG6_NOSNUS |
C |
8 |
0 |
Nos.Nro.Serv |
@!S8 |
|
|
R |
|
|
S |
VG6_RRCOLD |
C |
7 |
0 |
Nro.RR Velha |
@!S7 |
FG_Strzero("M->VG6_RRCOLD",7) |
|
|
|
|
S |
VG6_ANOANT |
C |
4 |
0 |
Ano RR Ant. |
@!S4 |
|
|
|
|
|
S |
VG6_RRCANT |
C |
7 |
0 |
Nro.RR Anter |
@!S7 |
FG_Strzero("M->VG6_RRCANT",7) |
|
|
|
|
S |
VG6_RRCNEW |
C |
7 |
0 |
Nro.RR Nova |
@!S7 |
FG_Strzero("M->VG6_RRCNEW",7) |
|
|
|
|
S |
VG6_TRANSM |
C |
1 |
0 |
Transmitido |
@!S1 |
|
|
|
|
|
S |
VG6_EXCLUI |
C |
1 |
0 |
Excluido |
@!S1 |
|
|
|
|
|
S |
VG6_USUEXC |
C |
6 |
0 |
Usuario |
@! |
|
|
|
|
|
S |
VG6_DATEXC |
D |
8 |
0 |
Dt Exclusao |
|
|
|
|
|
|
S |
VG6_HOREXC |
N |
4 |
0 |
Hora |
@E 9,999 |
|
|
|
|
|
S |
VG6_TIPTEM |
C |
4 |
0 |
Tipo Tempo |
@! |
ExistCpo("VOI") |
VOI |
|
|
|
S |
VG6_NFIENT |
C |
9 |
0 |
N.F.Entrada |
@! |
|
|
R |
|
|
N |
VG6_SERENT |
C |
3 |
0 |
Ser. Entrada |
!!! |
|
|
R |
|
|
N |
VG6_RENNF2 |
C |
9 |
0 |
NF Remessa |
@! |
|
|
R |
|
|
S |
VG6_ITEMNF |
C |
2 |
0 |
Item NF |
@! |
|
|
|
|
|
S |
VG6_ORDENS |
C |
2 |
0 |
Ordens |
@! |
|
|
R |
|
|
S |
VG6_RENNF1 |
C |
9 |
0 |
NF Remessa |
@! |
|
|
R |
|
|
S |
VG6_SERNFI |
C |
3 |
0 |
Serie NF Rem |
!!! |
|
|
R |
|
|
S |
VG6_LIBVOO |
C |
8 |
0 |
Num. Lib. TT |
|
|
|
R |
|
|
S |
VG6_QTDAPR |
N |
6 |
0 |
Qtde Aprv. |
@E 999999 |
|
|
R |
|
|
S |
VG6_LIQUID |
C |
1 |
0 |
Liquidada |
@A |
|
|
R |
|
|
S |
VG6_ENVPEC |
C |
1 |
0 |
Envia Peca |
@A |
|
|
R |
S=Sim;N=Nao;I=Inspecao |
|
S |
VG6_SDOCE |
C |
3 |
0 |
Ser.NF Entra |
!!! |
|
|
R |
|
|
S |
VG6_SDOCS |
C |
3 |
0 |
Serie NF Rem |
!!! |
|
|
R |
|
|
S |