Tabela |
VVN |
Tabela de Garantia Estendida |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
VVN_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
VVN_TPGREX |
C |
1 |
0 |
Tp Gar Esten |
@!S1 |
PERTENCE("12").and.FG_EK("VVN",,,"EXITPGREX") |
|
|
1=Fabrica;2=Concessionaria |
|
S |
VVN_CODMAR |
C |
3 |
0 |
Marca |
@!S3 |
FG_Seek("VE1","M->VVN_CODMAR",1,.f.,"VVN_DESMAR","VE1_DESMAR").AND.FG_EK("VVN",,,"EXITPGREX") |
VE1 |
|
|
|
S |
VVN_DESMAR |
C |
30 |
0 |
Descricao |
@!S30 |
|
|
V |
|
|
S |
VVN_CODGAR |
C |
15 |
0 |
Cod Garantia |
@!S15 |
FG_EK("VVN",,,"EXITPGREX") |
|
|
|
|
S |
VVN_DESCRI |
C |
30 |
0 |
Descr Garant |
@!S30 |
NaoVazio() |
|
|
|
|
S |
VVN_COBPEC |
C |
1 |
0 |
Cobre Pecas |
@!S1 |
PERTENCE("01") |
|
|
1=Sim;0=Nao |
|
S |
VVN_COBSRV |
C |
1 |
0 |
Cobre Srvs |
@!S1 |
PERTENCE("01") |
|
|
1=Sim;0=Nao |
|
S |
VVN_PRZGAR |
N |
4 |
0 |
Prz Validade |
@E 9999 |
M->VVN_PRZGAR > 0 |
|
|
|
|
S |
VVN_KILGAR |
N |
8 |
0 |
Km Gar Esten |
@E 99,999,999 |
M->VVN_KILGAR > 0 |
|
|
|
|
S |
VVN_DATPRC |
D |
8 |
0 |
Dt Apl Preco |
|
|
|
R |
|
|
S |
VVN_SEGMOD |
C |
10 |
0 |
Segmento |
@!S10 |
Vazio() .or. FG_Seek("VVX","M->VVN_CODMAR+M->VVN_SEGMOD",1,.f.) |
|
|
|
|
S |
VVN_VALMOD |
N |
12 |
2 |
Valor |
@E 999,999,999.99 |
|
|
|
|
|
S |
VVN_MODVEI |
C |
30 |
0 |
Mod Veiculo |
@! |
FG_Seek("VV2","M->VVN_CODMAR+M->VVN_MODVEI",1,.f.,"VVN_DESMOD","VV2_DESMOD").AND.M->VVN_CODMAR==VE1->VE1_CODMAR |
|
|
|
|
S |
VVN_DESMOD |
C |
30 |
0 |
Descricao |
@!S30 |
|
|
V |
|
|
S |