Tabela |
VV0 |
Saidas de Veiculos |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
VV0_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
VV0_NUMTRA |
C |
10 |
0 |
Transacao |
@! |
|
|
R |
|
|
S |
VV0_TIPFAT |
C |
1 |
0 |
Tp Fatura/to |
@!S1 |
PERTENCE("01") |
|
R |
0=Normal Novo;1=Normal Usado;2=Faturamento Direto |
|
S |
VV0_OPEMOV |
C |
1 |
0 |
Operacao |
@!S1 |
PERTENCE("012345678") |
|
|
0=Venda;1=Simulacao;2=Transferencia;3=Remessa;4=Devolucao;5=Consignado;6=Ret Remessa;7=Ret Consignado;8=Venda Futura |
|
S |
VV0_DATMOV |
D |
8 |
0 |
Data Movto |
@D |
If(INCLUI,M->VV0_DATMOV==DDATABASE,if(M->VV0_OPEMOV=="S",(M->VV0_DATMOV==DataValida(M->VV0_DATMOV)),M->VV0_DATMOV==VV0_DATMOV)) |
|
|
|
|
S |
VV0_CODCLI |
C |
6 |
0 |
Cliente |
@! |
VX001VLDENC() |
|
R |
|
|
S |
VV0_LOJA |
C |
2 |
0 |
Loja |
@! |
VX001VLDENC() |
|
R |
|
|
S |
VV0_NOMCLI |
C |
20 |
0 |
Nome Cliente |
@!S20 |
|
|
V |
|
|
S |
VV0_ENDCLI |
C |
30 |
0 |
Endereco |
@! |
|
|
V |
|
|
N |
VV0_CIDCLI |
C |
20 |
0 |
Cidade |
@! |
|
|
V |
|
|
N |
VV0_ESTCLI |
C |
2 |
0 |
Estado |
@! |
|
12 |
R |
|
|
S |
VV0_SIMULA |
C |
1 |
0 |
Simulacao |
@! |
PERTENCE("01") |
|
V |
0=Nao;1=Sim |
|
N |
VV0_CHASSI |
C |
25 |
0 |
Chassi |
@!S25 |
FG_POSVEI("M->VV0_CHASSI") .AND. VX002VEIC() |
V11 |
V |
|
M->VV0_SIMULA=="0".and.FUNNAME()#"VEIVM011" |
S |
VV0_CHAINT |
C |
6 |
0 |
Chassi Int. |
@!S6 |
|
|
V |
|
|
N |
VV0_CODMAR |
C |
3 |
0 |
Cod. Marca |
@! |
|
VE1 |
|
|
M->VV0_SIMULA == "1" |
N |
VV0_DESMAR |
C |
30 |
0 |
Marca |
@! |
|
|
V |
|
|
N |
VV0_GRUMOD |
C |
30 |
0 |
Cod. Grupo |
@! |
FG_Seek("VVR","M->VV0_CODMAR+M->VV0_GRUMOD",2,.f.,"VV0_DESGRU","VVR_DESCRI") |
VVR |
R |
|
M->VV0_SIMULA == "1" |
N |
VV0_DESGRU |
C |
30 |
0 |
Des. Grupo |
@!S30 |
|
|
V |
|
|
N |
VV0_MODVEI |
C |
30 |
0 |
Modelo |
@! |
|
VV2 |
|
|
M->VV0_SIMULA == "1" |
N |
VV0_DESMOD |
C |
30 |
0 |
Desc. Modelo |
@! |
|
|
V |
|
|
N |
VV0_CORVEI |
C |
6 |
0 |
Cor |
@! |
|
VVC |
|
|
M->VV0_SIMULA == "1" |
N |
VV0_DESCOR |
C |
30 |
0 |
Desc. Cor |
@! |
|
|
V |
|
|
N |
VV0_FABMOD |
C |
8 |
0 |
Fab / Modelo |
@R 9999/9999 |
|
|
V |
|
|
N |
VV0_PLAVEI |
C |
10 |
0 |
Placa |
@R! AAA-!!!!!!! |
|
|
|
|
|
N |
VV0_DATEMI |
D |
8 |
0 |
Data Emissao |
@D |
M->VV0_DATEMI >= M->VV0_DATMOV - 120 .and. (M->VV0_DATEMI==DataValida(M->VV0_DATEMI)) |
|
|
|
|
S |
VV0_CODVEN |
C |
6 |
0 |
Vendedor |
@!S6 |
FG_Seek("SA3","M->VV0_CODVEN",1,.f.,"VV0_NOMVEN","A3_NOME") |
SA3 |
R |
|
|
S |
VV0_NOMVEN |
C |
15 |
0 |
Nome Vend. |
@! |
|
|
V |
|
|
N |
VV0_VCARCR |
N |
12 |
2 |
Carta Credit |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
S |
VV0_EMPCON |
C |
2 |
0 |
EmpConsorcio |
@!S2 |
IF(M->VV0_VCARCR>0,if( Vazio() .or. FG_Seek("VV4","M->VV0_EMPCON","VV0_NOMCOM","VV4_DESCRI"),.t.,.f.),.t.) |
VV4 |
R |
|
|
S |
VV0_NOMCON |
C |
20 |
0 |
Nome Consorc |
@!S20 |
|
|
V |
|
|
S |
VV0_CODGRU |
C |
6 |
0 |
Grupo Consor |
999999 |
Vazio() .or. FG_STRZERO("M->VV0_CODGRU",6) .and. IF(M->VV0_VCARCR>0,!Empty(M->VV0_CODGRU),.T.) |
VCC |
R |
|
|
S |
VV0_NUMCOT |
C |
4 |
0 |
Numero Cota |
9999 |
IF(M->VV0_VCARCR>0,!Empty(M->VV0_NUMCOT),.T.) |
|
R |
|
|
S |
VV0_VALMOV |
N |
12 |
2 |
Valor Venda |
@E 999,999,999.99 |
MaFisRef("NF_VALMERC","VX001",M->VV0_VALMOV) |
|
R |
|
|
S |
VV0_ACESSO |
N |
12 |
2 |
Acessorios |
@E 999,999,999.99 |
Positivo() |
|
R |
|
|
N |
VV0_OPCION |
N |
12 |
2 |
Opcionais |
@E 999,999,999.99 |
Positivo() |
|
R |
|
|
N |
VV0_DESACE |
N |
12 |
2 |
Outras Desps |
@E 999,999,999.99 |
MaFisRef("NF_DESPESA","VX001",M->VV0_DESACE).AND.VX002VLDENC() |
|
R |
|
|
S |
VV0_VALNEG |
N |
14 |
2 |
Vl Negociado |
@E 99,999,999,999.99 |
|
|
|
|
|
N |
VV0_VALCOR |
N |
12 |
2 |
Valor da Cor |
@E 999,999,999.99 |
Positivo() |
|
R |
|
|
N |
VV0_IMPOST |
N |
12 |
2 |
Impostos |
@E 999,999,999.99 |
|
|
R |
|
|
N |
VV0_TOTENT |
N |
12 |
2 |
Entrada |
@E 999,999,999.99 |
|
|
|
|
|
N |
VV0_PERDES |
N |
6 |
2 |
% Desconto |
@E 999.99 |
|
|
R |
|
|
N |
VV0_VALDES |
N |
12 |
2 |
Desconto |
@E 999,999,999.99 |
MaFisRef("NF_DESCONTO","VX001",M->VV0_VALDES) |
|
R |
|
|
S |
VV0_VALTOT |
N |
14 |
2 |
Valor total |
@E 99,999,999,999.99 |
MaFisRef("NF_TOTAL","VX001",M->VV0_VALMOV) |
|
R |
|
.F. |
S |
VV0_FORPAG |
C |
3 |
0 |
Forma Pagto |
!!! |
FG_Seek("SE4","M->VV0_FORPAG",1,.f.,"VV0_DESFPG","E4_DESCRI") .and. VX001VLDENC() |
SE4 |
R |
|
|
S |
VV0_DESFPG |
C |
15 |
0 |
Descr F Pagt |
@!S15 |
|
|
V |
|
|
S |
VV0_AGEFIN |
C |
3 |
0 |
Ag. Financei |
@! |
Vazio() .or. FG_StrZero("M->VV0_AGEFIN",3,.f.) .and. FG_Seek("SA6","M->VV0_AGEFIN",1,.f.) |
A62 |
R |
|
|
S |
VV0_CODBCO |
C |
3 |
0 |
Banco |
@! |
Vazio() .or. FG_StrZero("M->VV0_CODBCO",3,.f.) .and. FG_Seek("SA6","M->VV0_CODBCO",1,.f.,"VV0_CODAGE","A6_AGENCIA") |
A61 |
R |
|
|
S |
VV0_CCUSTO |
C |
9 |
0 |
C.Custo Cred |
@! |
Vazio() .or. CTB105CC() |
CTT |
R |
|
|
S |
VV0_CODAGE |
C |
5 |
0 |
Agencia |
@! |
FG_Seek("SA6","M->VV0_CODBCO+M->VV0_CODAGE",1,.f.) |
|
|
|
|
S |
VV0_TOTICM |
N |
12 |
2 |
Vl Tot ICMS |
@E 999,999,999.99 |
MaFisRef("NF_VALICM","VX001",M->VV0_TOTICM) |
|
R |
|
|
S |
VV0_NUMLIB |
C |
8 |
0 |
No Liberacao |
@! |
|
|
R |
|
|
S |
VV0_TABFAI |
C |
6 |
0 |
Tab F&I |
@! |
Vazio().or.FG_SEEK("VAR","M->VV0_CODBCO+M->VV0_TABFAI",1,.F.,"VV0_DESFAI","VAR_DESCOD") |
VAS |
R |
|
|
S |
VV0_SITNFI |
C |
1 |
0 |
Situacao NF |
! |
|
|
|
0=Cancelada;1=Valida;2=Devolvida |
|
S |
VV0_DESFAI |
C |
20 |
0 |
Desc F&I |
@! |
|
|
V |
|
|
S |
VV0_VBAICM |
N |
12 |
2 |
Vl Base ICM |
@E 999,999,999.99 |
MaFisRef("NF_BASEICM","VX001",M->VV0_VBAICM) |
|
R |
|
|
S |
VV0_CODTRA |
C |
6 |
0 |
Transp. |
@! |
FG_Seek("SA4","M->VV0_CODTRA",1,.f.) |
SA4 |
R |
|
|
S |
VV0_OBSMNF |
C |
6 |
0 |
MEMO |
|
|
|
|
|
|
S |
VV0_CLIFTD |
C |
6 |
0 |
Cliente FD |
@! |
FG_Seek("SA1","M->VV0_CLIFTD",1,.f.) |
VSA |
R |
|
|
S |
VV0_OBSENF |
M |
70 |
0 |
Observ. NF |
@! |
|
|
V |
|
|
S |
VV0_EXPVEI |
C |
1 |
0 |
Veic.Export. |
@!S1 |
|
|
|
1=Sim;0=Nao |
|
S |
VV0_LOJFTD |
C |
2 |
0 |
Loja FD |
@! |
FG_Seek("SA1","M->VV0_CLIFTD+M->VV0_LOJFTD") |
|
R |
|
|
S |
VV0_NNFFDI |
C |
9 |
0 |
No NF FatDir |
@! |
|
|
|
|
|
S |
VV0_SNFFDI |
C |
3 |
0 |
Serie NF FD |
@!S3 |
|
|
|
|
|
S |
VV0_AUTFAT |
C |
1 |
0 |
Autoriz. Fat |
@!S1 |
|
|
|
1=Sim;0=Nao |
|
S |
VV0_DATUSU |
C |
15 |
0 |
Data/Usuario |
@!S24 |
|
|
R |
|
|
S |
VV0_TRADEV |
C |
10 |
0 |
Transac Dev. |
@! |
|
|
R |
|
|
S |
VV0_VALPAR |
N |
12 |
2 |
Vl. Parcela |
@E 999,999,999.99 |
|
|
R |
|
|
S |
VV0_DEVTRA |
C |
10 |
0 |
T. Dev.Saida |
@! |
|
|
R |
|
|
S |
VV0_NNFCOM |
C |
9 |
0 |
NF Comis Csg |
@! |
|
|
|
|
|
S |
VV0_CRMOK1 |
C |
1 |
0 |
Flag CRM |
@! |
|
|
R |
|
|
S |
VV0_CRMOK2 |
C |
1 |
0 |
Flag CRM |
@! |
|
|
R |
|
|
S |
VV0_AGREGA |
N |
12 |
2 |
Agregados |
@E 999,999,999.99 |
Positivo() |
|
R |
|
.f. |
S |
VV0_CATVEN |
C |
1 |
0 |
Categ. Venda |
@!S1 |
Pertence("345670") |
|
R |
3=CDC/Financiamento;4=Finame;5=Consorcio Nao Quitado;6=Consorcio Quitado;7=Leasing;0=Outros |
|
S |
VV0_DTHEMI |
C |
19 |
0 |
Dta./Hr Emis |
@!S17 |
|
|
R |
|
|
S |
VV0_VALFIN |
N |
12 |
2 |
V.Financiado |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
S |
VV0_TIPVEN |
C |
2 |
0 |
Tipo Venda |
@!S2 |
FG_Seek("VV3","M->VV0_TIPVEN",1,.f.,"VV0_DESTVD","VV3_DESCRI") |
VV3 |
|
|
|
S |
VV0_DESTVD |
C |
20 |
0 |
Descr Tp Vda |
@!S20 |
|
|
V |
|
|
S |
VV0_CODAVA |
C |
6 |
0 |
Avalista |
@! |
Empty(M->VV0_CODAVA) .OR. Vazio() .or. FG_Seek("SA1","M->VV0_CODAVA",1,.f.) |
|
R |
|
|
S |
VV0_ALIICM |
N |
5 |
2 |
Aliq. ICMS |
@E 99.99 |
|
|
|
|
|
S |
VV0_LOJAAV |
C |
2 |
0 |
Loja |
@! |
Empty(M->VV0_LOJAAV) .OR. FG_Seek("SA1","M->VV0_CODAVA+M->VV0_LOJAAV",1,.f.,"VV0_NOMAVA","A1_NREDUZ") |
|
R |
|
|
S |
VV0_NOMAVA |
C |
20 |
0 |
Nome Avalist |
@!S20 |
|
|
V |
|
|
S |
VV0_CLIALI |
C |
6 |
0 |
Alienado a |
@! |
If(VV3->VV3_ALIARR == "S",!Empty(M->VV0_CLIALI),.T.) .and. Vazio() .or. FG_Seek("SA1","M->VV0_CLIALI",1,.f.) |
VSA |
|
|
|
S |
VV0_LOJALI |
C |
2 |
0 |
Loja |
@! |
If(VV3->VV3_ALIARR == "S",!Empty(M->VV0_LOJALI),.t.) .and. FG_Seek("SA1","M->VV0_CLIALI+M->VV0_LOJALI",1,.f.) |
|
|
|
|
S |
VV0_NUMPED |
C |
6 |
0 |
Nro Pedido |
@X |
|
|
|
|
|
S |
VV0_NUMNFI |
C |
9 |
0 |
Nro NFiscal |
@! |
|
|
|
|
|
S |
VV0_SERNFI |
C |
3 |
0 |
Serie NF |
@!S3 |
ExistChav("VV0",M->VV0_NUMNFI+M->VV0_SERNFI,4,"EXINOTFIS") |
|
|
|
|
S |
VV0_DPGFAB |
D |
8 |
0 |
Dt. Pag Fab. |
|
|
|
|
|
|
N |
VV0_DPGVEN |
D |
8 |
0 |
Dt Pag. Vend |
|
|
|
|
|
|
N |
VV0_CRECON |
C |
6 |
0 |
Cred. Conces |
@! |
|
|
R |
|
|
N |
VV0_SEQVIS |
C |
6 |
0 |
Seq. Visita |
@! |
|
|
R |
|
|
N |
VV0_VALRES |
N |
12 |
2 |
Total-Entrad |
@E 999,999,999.99 |
|
|
R |
|
.f. |
S |
VV0_MODVDA |
C |
1 |
0 |
Mod. Venda |
@! |
|
|
|
|
|
N |
VV0_CODTES |
C |
3 |
0 |
T.E.S. |
@! |
FG_Seek("SF4","M->VV0_CODTES",1,.f.).and.VX002VLDENC() |
SF4 |
V |
|
|
N |
VV0_DIA1PC |
N |
3 |
0 |
Dia 1 Parc. |
999 |
|
|
|
|
|
N |
VV0_OBSMEM |
C |
6 |
0 |
Memo-Observ |
|
|
|
|
|
|
N |
VV0_CLFINA |
C |
6 |
0 |
Client.Finam |
@! |
|
VSA |
R |
|
|
S |
VV0_LJFINA |
C |
2 |
0 |
Loja Finame |
@! |
|
|
R |
|
|
S |
VV0_TIPFTD |
C |
2 |
0 |
Tipo Fat.Dir |
@! |
ExistCpo("SX5","77"+M->VV0_TIPFTD) |
77 |
R |
|
|
S |
VV0_CFINAM |
C |
15 |
0 |
Cod. Finame |
@! |
|
|
R |
|
|
S |
VV0_DATAPR |
D |
8 |
0 |
Dt.Aprovacao |
|
|
|
R |
|
|
S |
VV0_USRAPR |
C |
6 |
0 |
UsuAprovacao |
@! |
|
USR |
R |
|
|
S |
VV0_FIXDIA |
C |
1 |
0 |
Fixa Dia |
@! |
PERTENCE("01") |
|
R |
0=Nao;1=Sim |
|
N |
VV0_SEQFTD |
C |
3 |
0 |
SeqTp FatDir |
@! |
|
|
R |
|
|
S |
VV0_VALFRE |
N |
12 |
2 |
Valor Frete |
@E 999,999,999.99 |
MaFisRef("NF_FRETE","VX001",M->VV0_VALFRE).and.VX002VLDENC() |
|
R |
|
|
S |
VV0_VDAFUT |
C |
1 |
0 |
Venda Futura |
@! |
Pertence("01") |
|
R |
0=Nao;1=Sim |
|
S |
VV0_NFINAM |
C |
25 |
0 |
PAC Finame |
@! |
|
|
R |
|
|
S |
VV0_FPGFTD |
C |
3 |
0 |
Forma Pagto |
@! |
|
SE4 |
R |
|
|
S |
VV0_VALFPR |
N |
12 |
2 |
Vl.Fin.Propr |
@E 999,999,999.99 |
Positivo() |
|
R |
|
|
S |
VV0_DTIFPR |
D |
8 |
0 |
Dt.Ini.FinPr |
|
|
|
R |
|
|
S |
VV0_D1PFPR |
N |
4 |
0 |
Dias P FinPr |
@E 9999 |
|
|
R |
|
|
S |
VV0_PARFPR |
N |
4 |
0 |
Qtde P FinPr |
@E 9999 |
|
|
R |
|
|
S |
VV0_INTFPR |
N |
4 |
0 |
Interv.FinPr |
@E 9999 |
|
|
R |
|
|
S |
VV0_FIXFPR |
C |
1 |
0 |
FixaDiaFinPr |
@! |
Pertence("01") |
|
R |
0=Nao;1=Sim |
|
S |
VV0_DIAFPR |
N |
2 |
0 |
DiaFixoFinPr |
@E 99 |
|
|
R |
|
|
S |
VV0_JURFPR |
N |
12 |
6 |
JurMes FinPr |
@E 99,999.999999 |
|
|
R |
|
|
S |
VV0_PREBFN |
N |
6 |
2 |
% Rebate Fin |
@E 999.99 |
Positivo() |
|
R |
|
|
S |
VV0_VALREB |
N |
12 |
2 |
Vl.Rebate Fi |
@E 999,999,999.99 |
Positivo() |
|
R |
|
|
S |
VV0_TACLIQ |
N |
14 |
2 |
Vlr Liq TAC |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
VV0_SUBFIN |
N |
5 |
2 |
% Subsid Fin |
@E 99.99 |
|
|
R |
|
|
S |
VV0_VALPIS |
N |
12 |
2 |
Vl. PIS |
@E 999,999,999.99 |
MaFisRef("NF_VALPS2","VX001",M->VV0_VALPIS) |
|
R |
|
|
S |
VV0_TACSUB |
C |
1 |
0 |
TAC no Subs. |
@! |
Pertence("01") |
|
R |
0=Nao;1=Sim |
|
S |
VV0_VALCOF |
N |
12 |
2 |
Vl. COFINS |
@E 999,999,999.99 |
MaFisRef("NF_VALCF2","VX001",M->VV0_VALCOF) |
|
R |
|
|
S |
VV0_TACFIN |
C |
1 |
0 |
TAC Financ. |
@! |
Pertence("01") |
|
R |
0=Nao;1=Sim |
|
S |
VV0_VALTAB |
N |
12 |
2 |
Vlr Tabela |
@E 999,999,999.99 |
|
|
R |
|
|
N |
VV0_MESFPR |
C |
13 |
0 |
Meses consid |
@! |
|
|
R |
|
|
S |
VV0_OBSERV |
M |
70 |
0 |
Observacao |
@! |
|
|
V |
|
|
N |
VV0_STATUS |
C |
1 |
0 |
Status |
@! |
PERTENCE("ILCF") |
|
|
I=Inicializado;L=Liberado;C=Cancelado;F=Finalizado |
|
N |
VV0_OPER |
C |
2 |
0 |
Tip.Operacao |
@! |
(Vazio().or.ExistCpo("SX5","DJ"+M->VV0_OPER)).and.VX002VLDENC() |
DJ |
V |
|
|
S |
VV0_DATINI |
D |
8 |
0 |
Data Inicial |
|
|
|
R |
|
|
N |
VV0_PARCEL |
N |
4 |
0 |
Parcelas |
9999 |
|
|
|
|
|
N |
VV0_INTERV |
N |
2 |
0 |
Intervalo |
99 |
|
|
|
|
|
N |
VV0_DIAFIX |
C |
2 |
0 |
Dia Fixo |
99 |
|
|
R |
|
M->VV0_FIXDIA == "S" |
N |
VV0_RESERV |
C |
1 |
0 |
Reserva |
@! |
PERTENCE("01") |
|
R |
1=Sim;0=Nao |
|
N |
VV0_DATVAL |
D |
8 |
0 |
Dt. Validade |
|
M->VV0_DATVAL >= dDataBase |
|
R |
|
M->VV0_RESERV == "1" |
N |
VV0_HORVAL |
C |
4 |
0 |
Hora |
@R 99:99 |
|
|
R |
|
M->VV0_RESERV == "1" |
N |
VV0_PERCOM |
N |
6 |
2 |
% Comissao |
@E 999.99 |
|
|
R |
|
|
N |
VV0_COMFTD |
N |
12 |
2 |
Comissao |
@E 999,999,999.99 |
M->VV0_COMFTD > 0 |
|
|
|
|
N |
VV0_TPFRET |
C |
1 |
0 |
Tipo Frete |
@! |
MaFisRef("NF_TPFRETE","VX001",M->VV0_TPFRET) .and. VX001RECALC() |
|
R |
C=CIF;F=FOB;T=Por Conta Terceiro;S=Sem Frete |
|
S |
VV0_PERREP |
N |
6 |
2 |
% Repasse |
@E 999.99 |
|
|
R |
|
|
N |
VV0_REPFTD |
N |
12 |
2 |
Repasse |
@E 999,999,999.99 |
M->VV0_REPFTD > 0 |
|
R |
|
|
N |
VV0_TXAFIN |
N |
12 |
6 |
Taxa Financ |
@E 99,999.999999 |
|
|
R |
|
|
N |
VV0_COEFIC |
N |
16 |
6 |
Coeficiente |
@E 999,999,999.999999 |
|
|
|
|
|
N |
VV0_PTXRET |
N |
6 |
2 |
% Retorno |
@E 999.99 |
|
|
R |
|
|
N |
VV0_VTXRET |
N |
12 |
2 |
Taxa Retorno |
@E 999,999,999.99 |
|
|
R |
|
|
N |
VV0_PCUSFN |
N |
6 |
2 |
% Cus. Ret |
@E 999.99 |
|
|
R |
|
|
N |
VV0_VCUSFN |
N |
12 |
2 |
Custo Ret |
@E 999,999,999.99 |
|
|
R |
|
|
N |
VV0_FILCHA |
C |
2 |
0 |
FilialChassi |
|
|
|
R |
|
|
N |
VV0_PCOMFN |
N |
6 |
2 |
% Com. Finan |
@E 999.99 |
|
|
R |
|
|
N |
VV0_VCOMFN |
N |
12 |
2 |
Comis. Finan |
@E 999,999,999.99 |
|
|
R |
|
|
N |
VV0_VALTAC |
N |
12 |
2 |
Valor TAC |
@E 999,999,999.99 |
|
|
|
|
|
S |
VV0_VALTRO |
N |
12 |
2 |
Valor Troco |
@E 999,999,999.99 |
|
|
|
|
|
S |
VV0_TIPFIN |
C |
1 |
0 |
Tipo Financ |
@! |
PERTENCE("01") |
|
R |
0=Proprio;1=Financeira |
|
N |
VV0_CBCOAA |
C |
3 |
0 |
Banco Aliena |
@! |
|
A62 |
R |
|
AL_AR011(.T.) |
S |
VV0_ABCOAA |
C |
5 |
0 |
Agencia |
@! |
FG_Seek("SA6","M->VV0_CBCOAA+M->VV0_ABCOAA",1,.f.,"VV0_NBCOAA","A6_NOME") |
|
R |
|
AL_AR011(.T.) |
S |
VV0_DATENT |
D |
8 |
0 |
Dt. Entrega |
|
|
|
R |
|
|
N |
VV0_DEPTO |
C |
2 |
0 |
Ponto Venda |
@! |
Vazio() .or. ExistCpo("SX5", "76"+M->VV0_DEPTO) |
76 |
R |
|
|
S |
VV0_NATFIN |
C |
10 |
0 |
Natureza |
@! |
Vazio() .or. FinVldNat(.f.) |
SED |
|
|
|
N |
VV0_NUMOSV |
C |
8 |
0 |
Numero OSV |
@! |
|
|
R |
|
|
S |
VV0_BASSOL |
N |
12 |
2 |
Base Solidar |
@E 999,999,999.99 |
MaFisRef("NF_BASESOL","VX001",M->VV0_BASSOL) |
|
R |
|
|
N |
VV0_VALSOL |
N |
12 |
2 |
Vlr Solidar |
@E 999,999,999.99 |
MaFisRef("NF_VALSOL","VX001",M->VV0_VALSOL) |
|
R |
|
|
N |
VV0_SNFCOM |
C |
3 |
0 |
Sr Comis Csg |
!!! |
|
|
R |
|
|
S |
VV0_CLICSG |
C |
6 |
0 |
Cliente Csg |
@! |
|
|
R |
|
|
S |
VV0_LOJCSG |
C |
2 |
0 |
Loja Cli Csg |
@! |
|
|
R |
|
|
N |
VV0_DPGGER |
D |
8 |
0 |
Dt Pg Ger |
|
|
|
R |
|
|
S |
VV0_HISPGC |
C |
50 |
0 |
Hist Pg Com |
@! |
|
|
R |
|
|
S |
VV0_DPGSUP |
C |
8 |
0 |
Dt Pg Sup |
|
|
|
R |
|
|
N |
VV0_SIMVDA |
C |
1 |
0 |
Simulac/Vda |
@! |
PERTENCE("SV") |
|
R |
|
|
S |
VV0_PESQLJ |
C |
6 |
0 |
Orcamento Lj |
@! |
|
|
R |
|
|
S |
VV0_VENVDI |
C |
6 |
0 |
Vend.Vda.Dir |
@! |
vazio().or.FG_Seek("SA3","M->VV0_VENVDI",1,.f.) |
SA3 |
R |
|
|
S |
VV0_NUMTIT |
C |
9 |
0 |
Nro. Titulo |
@! |
|
|
R |
|
|
S |
VV0_BONEMP |
N |
12 |
2 |
Bonus Emplac |
@E 999,999,999.99 |
|
|
R |
|
|
S |
VV0_NUMEMP |
C |
8 |
0 |
Num Emplaca. |
@! |
|
|
R |
|
|
S |
VV0_DATEMP |
D |
8 |
0 |
Data Emplaca |
|
|
|
R |
|
|
S |
VV0_TIPO |
C |
1 |
0 |
Tipo da nota |
@! |
|
|
R |
|
|
S |
VV0_TIPMOV |
C |
1 |
0 |
Tp Movimento |
@! |
Pertence("012") |
|
R |
0=Normal;1=Agrega;2=Desagrega |
|
S |
VV0_MENNOT |
C |
60 |
0 |
Mens.p/ Nota |
@S45 |
|
|
R |
|
|
S |
VV0_MENPAD |
C |
3 |
0 |
Mens. Padrao |
@! |
Vazio().Or.ExistCpo("SM4") |
SM4 |
R |
|
|
S |
VV0_CLIFOR |
C |
1 |
0 |
Utiliza |
@! |
VX001CLIFOR() .and. Pertence("FC") |
|
|
C=Cliente;F=Fornecedor |
|
S |
VV0_INDPRE |
C |
1 |
0 |
Presenca Cpa |
@! |
Pertence ("01239") |
|
|
0=Nao se Aplica;1=Op.Presencial;2=Op. nao Presencial, Internet;3=Op.nao Presencial, Teleatendimento;9=Op.nao Presencial, outros |
|
S |
VV0_TIPOCL |
C |
1 |
0 |
Tipo Cliente |
@! |
Vazio() .or. Pertence("FLRSX") |
|
|
F=Cons.Final;L=Prod.Rural;R=Revendedor;S=Solidario;X=Exportacao/Importacao |
|
S |
VV0_CFFINA |
C |
1 |
0 |
Finame Titul |
@! |
Pertence("12") |
|
R |
1=Cliente;2=Financeira/Banco |
|
S |
VV0_VFFINA |
N |
12 |
2 |
Vlr Flat |
@E 999,999,999.99 |
positivo() |
|
R |
|
|
S |
VV0_DFFINA |
D |
8 |
0 |
Vencto Flat |
|
|
|
R |
|
|
S |
VV0_VRFINA |
N |
12 |
2 |
Vlr Risco |
@E 999,999,999.99 |
positivo() |
|
R |
|
|
S |
VV0_DRFINA |
D |
8 |
0 |
Vencto Risco |
|
|
|
R |
|
|
S |
VV0_PESOL |
N |
11 |
4 |
Peso Liquido |
@E 999,999.9999 |
Positivo() |
|
|
|
|
S |
VV0_PBRUTO |
N |
11 |
4 |
Peso Bruto |
@E 999,999.9999 |
Positivo() |
|
|
|
|
S |
VV0_VOLUME |
N |
5 |
0 |
Volume |
@E 99999 |
Positivo() |
|
|
|
|
S |
VV0_ESPECI |
C |
10 |
0 |
Especie |
@! |
|
|
|
|
|
S |
VV0_VEICUL |
C |
8 |
0 |
Veic. Transp |
@! |
|
DA3 |
|
|
|
S |
VV0_SEGURO |
N |
12 |
2 |
Seguro |
@E 999,999,999.99 |
|
|
|
|
|
S |
VV0_FCICOD |
C |
36 |
0 |
Cod. FCI |
@! |
VX002VLDENC() |
|
V |
|
|
S |
VV0_SDOC |
C |
3 |
0 |
Serie Doc |
!!! |
|
|
R |
|
|
S |
VV0_SDOCCO |
C |
3 |
0 |
Serie Dc CSG |
!!! |
|
|
R |
|
|
N |
VV0_SDOCFD |
C |
3 |
0 |
Serie Doc FD |
!!! |
|
|
R |
|
|
S |
VV0_CLIENT |
C |
6 |
0 |
Cli.Entrega |
@! |
|
SA1 |
|
|
|
S |
VV0_LOJENT |
C |
2 |
0 |
Loja Entrega |
@! |
|
|
|
|
|
S |
VV0_FLUXO |
C |
1 |
0 |
Fluxo Caixa |
@! |
pertence("SN") |
|
R |
S=Sim;N=Nao |
|
S |
VV0_GERFIN |
C |
1 |
0 |
Gerou Financ |
@! |
Pertence("01") |
|
R |
0=Nao;1=Sim |
|
S |
VV0_TIPDOC |
C |
1 |
0 |
Tp.Doc.Gerar |
@! |
Pertence("12") |
|
R |
1=NF;2=Mov.Interna |
|
S |
VV0_EMPLAC |
C |
1 |
0 |
Zero Emplaca |
@! |
Pertence("01") |
|
R |
0=Nao;1=Sim |
|
S |
VV0_CAMPAN |
C |
50 |
0 |
Campanha |
@! |
|
|
V |
|
|
S |
VV0_VALCMP |
N |
12 |
2 |
ICMS Compl. |
@E 999,999,999.99 |
MaFisRef("NF_VALCMP","VX001",M->VV0_VALCMP) |
|
R |
|
|
S |
VV0_DIFAL |
N |
12 |
2 |
Dif.de ICMS |
@E 999,999,999.99 |
MaFisRef("NFIT_DIFAL","VX001",M->VV0_DIFAL) |
|
R |
|
|
S |