Tabela |
VPN |
PEDIDO DE VEICULOS |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
VPN_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
R |
|
|
S |
VPN_NUMPED |
C |
10 |
0 |
Transacao |
@E9 |
|
|
R |
|
|
S |
VPN_OPEMOV |
C |
1 |
0 |
Operacao |
@!S1 |
PERTENCE("012345678") |
|
R |
0=Venda;1=Simulacao;2=Transferencia;3=Remessa;4=Devolucao;5=Consignado;6=Retorno de Remessa;7=Retorno de consignado |
|
S |
VPN_DATPED |
D |
8 |
0 |
Data Movto |
@D |
If(INCLUI,M->VPN_DATMOV==DDATABASE,if(M->VPN_OPEMOV=="S",(M->VPN_DATMOV==DataValida(M->VPN_DATMOV)),M->VPN_DATMOV==VPN_DATMOV)) |
|
R |
|
|
S |
VPN_CODCLI |
C |
6 |
0 |
Cliente |
@! |
VX021VLDENC() |
VSA |
R |
|
|
S |
VPN_LOJA |
C |
2 |
0 |
Loja |
@! |
VX021VLDENC() |
|
R |
|
|
S |
VPN_NOMCLI |
C |
20 |
0 |
Nome Cliente |
@!S20 |
|
|
V |
|
|
S |
VPN_ENDCLI |
C |
30 |
0 |
End Propr |
@! |
|
|
V |
|
|
S |
VPN_CIDCLI |
C |
20 |
0 |
Cidade |
@! |
|
|
V |
|
|
S |
VPN_ESTCLI |
C |
2 |
0 |
Estado |
@! |
|
12 |
R |
|
|
S |
VPN_DATEMI |
D |
8 |
0 |
Data Emissao |
@D |
M->VPN_DATEMI >= M->VPN_DATMOV - 120 .and. (M->VPN_DATEMI==DataValida(M->VPN_DATEMI)) |
|
R |
|
|
S |
VPN_VALMOV |
N |
12 |
2 |
Valor Venda |
@E 999,999,999.99 |
M->VPN_VALMOV > 0 .and. MaFisRef("NF_VALMERC","VX021",M->VPN_VALMOV) |
|
R |
|
|
S |
VPN_PERDES |
N |
6 |
2 |
% Desconto |
@E 999.99 |
|
|
R |
|
|
S |
VPN_VALDES |
N |
12 |
2 |
Desconto |
@E 999,999,999.99 |
MaFisRef("NF_DESCONTO","VX021",M->VPN_VALDES) |
|
R |
|
|
S |
VPN_VALTOT |
N |
12 |
2 |
Valor Total |
@E 999,999,999.99 |
MaFisRef("NF_TOTAL","VX021",M->VPN_VALTOT) |
|
R |
|
.F. |
S |
VPN_CODVEN |
C |
6 |
0 |
Vendedor |
@!S6 |
FG_Seek("SA3","M->VPN_CODVEN",1,.f.,"VPN_NOMVEN","A3_NOME") |
SA3 |
R |
|
|
S |
VPN_NOMVEN |
C |
15 |
0 |
Nome Vended |
@! |
|
|
V |
|
|
S |
VPN_DESACE |
N |
12 |
2 |
Outras Desps |
@E 999,999,999.99 |
Positivo().and. MaFisRef("NF_DESPESA","VX021",M->VPN_DESACE) |
|
R |
|
|
S |
VPN_DTHEMI |
C |
19 |
0 |
Dta./Hr Emis |
@!S17 |
|
|
R |
|
|
S |
VPN_FORPAG |
C |
3 |
0 |
Forma Pagto |
!!! |
FG_Seek("SE4","M->VPN_FORPAG",1,.f.,"VPN_DESFPG","E4_DESCRI") .AND. SE4->E4_TIPO <> "A" |
SE4 |
R |
|
|
S |
VPN_DESFPG |
C |
15 |
0 |
Descricao |
@!S15 |
|
|
V |
|
|
S |
VPN_CODBCO |
C |
3 |
0 |
Banco |
@! |
Vazio().or.FG_StrZero("M->VPN_CODBCO",3,.f.).and.FG_Seek("SA6","M->VPN_CODBCO",1,.f.,"VPN_CODAGE","A6_AGENCIA") |
A61 |
R |
|
|
S |
VPN_CODAGE |
C |
5 |
0 |
Agencia |
@! |
FG_Seek("SA6","M->VPN_CODBCO+M->VPN_CODAGE",1,.f.) |
|
R |
|
|
S |
VPN_OBSERV |
M |
47 |
0 |
Observacao |
@! |
|
|
V |
|
|
S |
VPN_OBSMEM |
C |
6 |
0 |
Memo-Observ |
|
|
|
R |
|
|
S |
VPN_STATUS |
C |
1 |
0 |
Status |
@! |
PERTENCE("AFCP") |
|
R |
A=Aberto;F=Fechado;C=Cancelado;P=Parcialmente Atendido |
|
S |