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