Tabela |
VCC |
Carteira de Consorcios |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
VCC_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
VCC_EMPCON |
C |
2 |
0 |
Cod Consorc |
@!S2 |
FG_Seek("VV4","M->VCC_EMPCON",1,.f.,"VCC_NOMCON","VV4_DESCRI") |
VV4 |
|
|
|
S |
VCC_NOMCON |
C |
20 |
0 |
Consorciador |
@!S20 |
|
|
|
|
|
S |
VCC_SITCON |
C |
1 |
0 |
Situacao |
! |
Pertence("0123") |
|
|
0=Cancelado;1=Contemplado por Lance;2=Contemplado por Sorteio;3=Nao Contemplado |
|
S |
VCC_CODGRU |
C |
5 |
0 |
Grupo |
99999 |
FG_STRZERO("M->VCC_CODGRU",5) .and. NaoVazio() |
|
|
|
|
S |
VCC_NUMCOT |
C |
4 |
0 |
Nro Cota |
9999 |
FG_StrZero("M->VCC_NUMCOT",4).and.EXISTCHAV("VCC",M->VCC_CODGRU+M->VCC_NUMCOT) |
|
|
|
|
S |
VCC_DATVDA |
D |
8 |
0 |
Data Venda |
|
|
|
|
|
|
S |
VCC_CODCLI |
C |
6 |
0 |
Cod Cliente |
@! |
FG_Seek("SA1","M->VCC_CODCLI",1,.f.) |
VSA |
|
|
|
S |
VCC_LOJA |
C |
2 |
0 |
Loja |
@! |
FG_Seek("SA1","M->VCC_CODCLI+M->VCC_LOJA",1,.f.,"VCC_NOMCLI","A1_NOME") |
|
|
|
|
S |
VCC_NOMCLI |
C |
20 |
0 |
Nome |
@!S20 |
|
|
|
|
|
S |
VCC_QTDPAR |
N |
3 |
0 |
Parcelas |
@E 999 |
|
|
|
|
|
S |
VCC_CODMAR |
C |
3 |
0 |
Marca |
@!S3 |
If(FG_VALIDA(,"VE1TM->VCC_CODMAR*","M->VCC_DESMAR:=VE1->VE1_DESMAR"),.t.,.t.) |
VE1 |
|
|
|
S |
VCC_DESMAR |
C |
30 |
0 |
Descricao |
@!S30 |
|
|
V |
|
|
S |
VCC_MODVEI |
C |
30 |
0 |
Mod Veiculo |
@! |
If(FG_VALIDA(,"VV2TM->VCC_CODMAR+VCC_MODVEI*","M->VCC_DESMOD:=VV2->VV2_DESMOD"),.t.,.t.) |
MC7 |
|
|
|
S |
VCC_DESMOD |
C |
30 |
0 |
Descricao |
@!S30 |
|
|
V |
|
|
S |
VCC_COMCOT |
N |
12 |
2 |
Comiss Cota |
@E 999,999,999.99 |
|
|
|
|
|
S |
VCC_PERCOT |
N |
6 |
2 |
% Vda Cota |
@E 999.99 |
|
|
|
|
|
S |
VCC_DATCTP |
D |
8 |
0 |
Dt Contempla |
|
|
|
|
|
|
S |
VCC_PERCTP |
N |
6 |
2 |
% Vda Conten |
@E 999.99 |
|
|
|
|
|
S |
VCC_OBSERV |
M |
47 |
0 |
Observacao |
@! |
|
|
V |
|
|
S |
VCC_OBSMEM |
C |
6 |
0 |
Observ-MEMO |
|
|
|
|
|
|
S |
VCC_VALCRE |
N |
12 |
2 |
Vlr Credito |
@E 999,999,999.99 |
|
|
|
|
|
S |
VCC_ENCGRU |
D |
8 |
0 |
EncerGrupo |
|
|
|
|
|
|
S |