Tabela |
VC4 |
Bolsa de Veiculos |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
VC4_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
VC4_CHAINT |
C |
6 |
0 |
Chassi Int. |
@E 999999 |
|
|
|
|
|
S |
VC4_CONCES |
C |
20 |
0 |
Concessionar |
@!S20 |
NaoVazio() |
|
|
|
|
S |
VC4_VEI_CV |
C |
1 |
0 |
Interesse |
! |
PERTENCE("01") |
|
|
0=Compra;1=Venda |
|
S |
VC4_CHASSI |
C |
25 |
0 |
Chassi |
@!S25 |
NaoVazio() |
|
|
|
M->VC4_VEI_CV=="1" |
S |
VC4_PLAVEI |
C |
10 |
0 |
Nro Placa |
@R! AAA-9999 |
|
|
|
|
M->VC4_VEI_CV=="1" |
S |
VC4_CODCLI |
C |
6 |
0 |
Cod. Proprie |
@! |
Vazio() .or. FG_VALIDA(NIL,"SA1TM->VC4_CODCLI*","M->VC4_TELCON:=SA1->A1_TEL") |
VSA |
|
|
|
S |
VC4_LOJA |
C |
2 |
0 |
Loja |
@! |
Vazio() .or. FG_VALIDA(NIL,"SA1TM->VC4_CODCLI+M->VC4_LOJA*","M->VC4_NOMPRO:=SA1->A1_NOME,M->VC4_TELCON:=SA1->A1_TEL") |
|
|
|
|
S |
VC4_NOMPRO |
C |
30 |
0 |
Nome |
@!S30 |
NaoVazio() |
|
|
|
Empty(M->VC4_CODCLI) |
S |
VC4_TELCON |
C |
15 |
0 |
Fone Contato |
|
NaoVazio() |
|
|
|
|
S |
VC4_NOVUSA |
C |
1 |
0 |
Novo/Usado |
! |
PERTENCE("01") |
|
|
0=Novo;1=Usado |
|
S |
VC4_CODMAR |
C |
3 |
0 |
Marca |
@!S3 |
If(FG_VALIDA(,"VE1TM->VC4_CODMAR*","M->VC4_DESMAR:=VE1->VE1_DESMAR"),.t.,.t.) |
VE1 |
|
|
|
S |
VC4_DESMAR |
C |
20 |
0 |
Descricao |
@!S20 |
|
|
V |
|
|
S |
VC4_MODVEI |
C |
30 |
0 |
Mod Veiculo |
@! |
If(FG_VALIDA(,"VV2TM->VC4_CODMAR+VC4_MODVEI*","M->VC4_DESMOD:=VV2->VV2_DESMOD"),.t.,.t.) |
MC4 |
|
|
|
S |
VC4_DESMOD |
C |
30 |
0 |
Descricao |
@!S30 |
|
|
V |
|
|
S |
VC4_FABMOD |
C |
8 |
0 |
Ano Fabr/Mod |
@R 9999/9999 |
If(Right(M->VC4_FABMOD,4)==Left(M->VC4_FABMOD,4).Or.Val(Right(M->VC4_FABMOD,4))==(Val(Left(M->VC4_FABMOD,4))+1),.t.,.f.) |
|
|
|
|
S |
VC4_COMVEI |
C |
1 |
0 |
Combustivel |
@!S1 |
PERTENCE("01239") |
|
|
0=Gasolina;1=Alcool;2=Diesel;3=Gas Natural;9=Sem Combustivel |
|
S |
VC4_CORVEI |
C |
6 |
0 |
Cor |
@!S6 |
FG_Seek("VVC","M->VC4_CODMAR+M->VC4_CORVEI",1,.f.,"VC4_DESCOR","VVC_DESCRI") |
VVC |
|
|
|
S |
VC4_DESCOR |
C |
30 |
0 |
Descr Cor |
@S20 |
|
|
V |
|
|
S |
VC4_DATINI |
D |
8 |
0 |
DtIni Oferta |
|
M->VC4_DATINI>=dDataBase |
|
|
|
|
S |
VC4_DATFIN |
D |
8 |
0 |
DtFin Oferta |
|
M->VC4_DATFIN>=dDataBase .and. M->VC4_DATINI<=M->VC4_DATFIN |
|
|
|
|
S |
VC4_VALOFE |
N |
12 |
2 |
Vl Oferta |
@E 999,999,999.99 |
M->VC4_VALOFE > 0 |
|
|
|
|
S |
VC4_KILATU |
N |
8 |
0 |
Km Atual |
@E 99,999,999 |
M->VC4_KILATU >= 0 |
|
|
|
|
S |
VC4_OFEVAL |
C |
1 |
0 |
OfertaValida |
@!S1 |
PERTENCE("01") |
|
|
0=Sim;1=Nao |
|
S |
VC4_OBSMEM |
C |
6 |
0 |
Observ-MEMO |
|
|
|
|
|
|
S |
VC4_OBSERV |
M |
47 |
0 |
Observacao |
@! |
|
|
V |
|
|
S |
VC4_FOIAVA |
C |
1 |
0 |
Avaliado? |
@!S1 |
PERTENCE("01") |
|
|
0=Nao;1=Sim |
M->VC4_VEI_CV=="1" |
S |
VC4_NOMAVA |
C |
30 |
0 |
Nome Avalid |
@!S30 |
|
|
|
|
M->VC4_FOIAVA=="1" |
S |
VC4_VALAVA |
N |
12 |
2 |
Vl Avaliacao |
@E 999,999,999.99 |
M->VC4_VALAVA > 0 |
|
|
|
M->VC4_FOIAVA=="1" |
S |