Tabela |
VVP |
Tabela de Precos de Veiculos |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
VVP_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
VVP_CODMAR |
C |
3 |
0 |
Marca |
@!S3 |
FG_Seek("VE1","M->VVP_CODMAR",1,.f.,"VVP_DESMAR","VE1_DESMAR") |
VE1 |
|
|
|
S |
VVP_DESMAR |
C |
30 |
0 |
Descricao |
@!S30 |
|
|
V |
|
|
S |
VVP_MODVEI |
C |
30 |
0 |
Mod Veiculo |
@! |
FG_Seek("VV2","VVP_CODMAR+VVP_MODVEI",,,"VVP_DESMOD","VV2_DESMOD").and.ExistChav("VVP",M->VVP_CODMAR+M->VVP_MODVEI,1,"EXIMODVE") |
MCD |
|
|
|
S |
VVP_SEGMOD |
C |
10 |
0 |
Segmento |
@!S10 |
FG_Seek("VVX","M->VVP_CODMAR+M->VVP_SEGMOD",1,.f.) |
|
|
|
|
S |
VVP_DESMOD |
C |
30 |
0 |
Descricao |
@!S30 |
|
|
V |
|
|
S |
VVP_DATPRC |
D |
8 |
0 |
Dt Validade |
@D |
EXISTCHAV("VVP",M->VV2_CODMAR+M->VV2_MODVEI+M->VV2_SEGMOD+Dtos(M->VVP_DATPRC)) |
|
R |
|
|
S |
VVP_CUSTAB |
N |
12 |
2 |
Valor Custo |
@E 999,999,999.99 |
M->VVP_CUSTAB > 0 |
|
|
|
|
S |
VVP_VALTAB |
N |
12 |
2 |
Valor Venda |
@E 999,999,999.99 |
M->VVP_VALTAB > 0 |
|
|
|
|
S |
VVP_VACRPR |
N |
12 |
2 |
Vl Acr Perol |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
S |
VVP_VACRMT |
N |
12 |
2 |
Vl Acr Metal |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
S |
VVP_DATUSU |
C |
15 |
0 |
Data/Usuario |
@!S15 |
|
|
|
|
|
S |
VVP_CUCRPR |
N |
12 |
2 |
Cs Cor Perol |
@ez 999,999,999.99 |
|
|
R |
|
|
S |
VVP_CUCRMT |
N |
12 |
2 |
Cs Cor Metal |
@ez 999,999,999.99 |
|
|
R |
|
|
S |
VVP_MINVEN |
N |
14 |
2 |
Vl. Min Vend |
@E 999,999,999.99 |
|
|
R |
|
|
N |
VVP_MINGER |
N |
14 |
2 |
Vl. Min Ger |
@E 999,999,999.99 |
|
|
R |
|
|
N |