Tabela
VVA Itens das Saidas de Veiculos
Campo Tipo Tamanho Decimal Titulo Formato Validacao F3 Contexto Lista Condicao PYME
VVA_FILIAL C 2 0 Filial S
VVA_NUMTRA C 10 0 Transacao @! R S
VVA_ITETRA C 2 0 Item @! R S
VVA_CHASSI C 25 0 Chassi @!S25 VX001CHASSI().and.VX001VNFE() V11 R S
VVA_CHAINT C 6 0 Chassi Int @! FG_Seek("VV1","M->VVA_CHAINT",1,.f.) S
VVA_CODMAR C 3 0 Codigo Marca @! VE1 R S
VVA_DESMAR C 30 0 Desc. Marca @!S30 V N
VVA_CODTES C 3 0 T.E.S. 999 FG_Seek("SF4","VVA_CODTES",1,.f.).and.MaAvalTes("S",M->VVA_CODTES).and.MaFisRef("IT_TES","VX001",M->VVA_CODTES) SF4 R S
VVA_GRUMOD C 30 0 Grupo Modelo @! VVR R S
VVA_MODVEI C 30 0 Modelo @! VV2 R S
VVA_DESMOD C 30 0 Desc. Model. @!S30 V N
VVA_CORVEI C 6 0 Codigo Cor @! VVC R S
VVA_DESCOR C 30 0 Desc. Cor @!S30 V N
VVA_FILENT C 2 0 Fil.Entrada S
VVA_TRACPA C 10 0 Transac Cpa @! S
VVA_PLAVEI C 10 0 Placa @R! AAA-!!!!!!! V N
VVA_ESTVEI C 1 0 Estado Veic @!S1 PERTENCE("01") 0=Novo;1=Usado S
VVA_CODORI C 1 0 Origem @!S1 PERTENCE("012") 0=Fabrica;1=Concessionaria;2=Outros S
VVA_CMFPGC N 12 2 ComPgComp MF @E 999,999,999.99 R S
VVA_COMPGC N 12 2 ComPgComp MF @E 999,999,999.99 R S
VVA_CODIND C 2 0 Cod. Indice !! Vazio() .or. FG_Seek("VVH","M->VVA_CODIND",1,.f.) VVH R S
VVA_VALDES N 12 2 Desconto @E 999,999,999.99 MaFisRef("IT_DESCONTO","VX001",M->VVA_VALDES) R S
VVA_FATTOT N 12 2 Fatur. Total @E 999,999,999.99 R S
VVA_FMFTOT N 12 2 Fat Total MF @E 999,999,999.99 S
VVA_VALTAB N 12 2 Vlr Tabela @E 999,999,999.99 MaFisRef("IT_PRCUNI","VX001",M->VVA_VALTAB) R S
VVA_VALMOV N 12 2 Vl Movto @E 999,999,999.99 MaFisRef("IT_VALMERC","VX001",M->VVA_VALMOV) R S
VVA_VMFMOV N 12 2 Vl Movto MF @E 999,999,999.99 M->VV0_VALMOV > 0 R S
VVA_VBAICM N 12 2 Vl Base ICM @E 999,999,999.99 MaFisRef("IT_BASEICM","VX001",M->VVA_VBAICM) R S
VVA_ALIICM N 5 2 Aliq. ICMS @E 99.99 MaFisRef("IT_ALIQICM","VX001",M->VVA_ALIICM) R S
VVA_VALVDA N 12 2 Vl Total Vda @E 999,999,999.99 MaFisRef("IT_TOTAL","VX001",M->VVA_VALVDA) R S
VVA_VMFVDA N 12 2 Vl Tot Vd MF @E 999,999,999.99 M->VVA_VALVEI > 0 R S
VVA_VALCVD N 12 2 ComLiqVdaDir @E 999,999,999.99 if(M->VV0_TIPFAT == [C],>0,.T.) S
VVA_VMFCVD N 12 2 CoLqVdDir MF @E 999,999,999.99 if(M->VV0_TIPFAT == [C],>0,.T.) S
VVA_COMCOT N 12 2 Vl Com Cota @E 999,999,999.99 R S
VVA_CMFCOT N 12 2 V ComCota MF @E 999,999,999.99 R S
VVA_COMCTP N 12 2 Vl Com Conte @E 999,999,999.99 R S
VVA_CMFCTP N 12 2 V ComCont MF @E 999,999,999.99 R S
VVA_RECTEC N 12 2 Rec Tecnica @E 999,999,999.99 S
VVA_RMFTEC N 12 2 Rec Tec MF @E 999,999,999.99 S
VVA_DATRTC D 8 0 Dt Rec Tecn If(INCLUI,M->VVA_DATRTC==DDATABASE,if(M->VV0_OPEMOV=="1",(M->VVA_DATRTC==DataValida(M->VVA_DATRTC)),M->VVA_DATRTC==VVA_DATRTC)) S
VVA_INPICO C 1 0 PIS/COF Vda ! PERTENCE("10") 1=Sim;0=Nao S
VVA_INPCRT C 1 0 PIS/COF RTec ! PERTENCE("10") R 1=Sim;0=Nao S
VVA_INPCBF C 1 0 PIS/COFBonus ! PERTENCE("10") R 1=Sim;0=Nao S
VVA_INISRT C 1 0 ISS RecTec ! PERTENCE("10") R 1=Sim;0=Nao S
VVA_INISBF C 1 0 ISS Bonus FB ! PERTENCE("10") R 1=Sim;0=Nao S
VVA_BONFAB N 12 2 Bonus Fabric @E 999,999,999.99 R S
VVA_BMFFAB N 12 2 Bonus Fab MF @E 999,999,999.99 S
VVA_DATBFB D 8 0 Dt Bonus Fab If(INCLUI,M->VVA_DATBFB==DDATABASE,if(M->VV0_OPEMOV=="1",(M->VVA_DATBFB==DataValida(M->VVA_DATBFB)),M->VVA_DATBFB==VVA_DATBFB)) S
VVA_TOTIMP N 12 2 Tot Impostos @E 999,999,999.99 S
VVA_TMFIMP N 12 2 Tot Imp MF @E 999,999,999.99 S
VVA_BONREG N 12 2 Bonus Regiao @E 999,999,999.99 R S
VVA_BONCON N 12 2 Bonus Conces @E 999,999,999.99 S
VVA_ICMVEN N 12 2 ICMS Venda @E 999,999,999.99 MaFisRef("IT_VALICM","VX001",M->VVA_ICMVEN) R S
VVA_IMFVEN N 12 2 ICMS Vda MF @E 999,999,999.99 S
VVA_BMFREG N 12 2 Bonus MF Reg @E 999,999,999.99 S
VVA_ISSCVD N 12 2 Iss Intermed @E 999,999,999.99 MaFisRef("IT_VALISS","VX001",M->VVA_ISSCVD) R S
VVA_IMFCVD N 12 2 Iss Inter MF @E 999,999,999.99 S
VVA_BMFCON N 12 2 Bonus Fab MF @E 999,999,999.99 S
VVA_PISVEN N 12 2 Vl. PIS (ST) @E 999,999,999.99 MaFisRef("IT_VALPS3","VX001",M->VVA_PISVEN) R S
VVA_PMFVEN N 12 2 Pis MF @E 999,999,999.99 S
VVA_COFVEN N 12 2 Vl. COF(ST) @E 999,999,999.99 MaFisRef("IT_VALCF3","VX001",M->VVA_COFVEN) R S
VVA_CMFVEN N 12 2 Vl Cofins MF @E 999,999,999.99 S
VVA_ISSRTE N 12 2 Vl ISS RecTc @E 999,999,999.99 S
VVA_ISSBFB N 12 2 Vl ISS Bonus @E 999,999,999.99 S
VVA_IMFRTE N 12 2 V ISSRcTc MF @E 999,999,999.99 S
VVA_IMFBFB N 12 2 ISS Bonus MF @E 999,999,999.99 S
VVA_PISRTE N 12 2 Vl PISCOF RT @E 999,999,999.99 S
VVA_PISBFB N 12 2 PISCOF Bonus @E 999,999,999.99 S
VVA_PMFRTE N 12 2 V PICO RT MF @E 999,999,999.99 S
VVA_PMFBFB N 12 2 PICO BonusMF @E 999,999,999.99 S
VVA_TOTCUS N 12 2 Tot Custos @E 999,999,999.99 S
VVA_TMFCUS N 12 2 Tot Custo MF @E 999,999,999.99 S
VVA_VCAVEI N 12 2 Custo Atual @E 999,999,999.99 S
VVA_VMFVEI N 12 2 Custo Atu MF @E 999,999,999.99 S
VVA_ICMCOM N 12 2 ICMS Compra @E 999,999,999.99 S
VVA_IMFCOM N 12 2 ICMS Cpa MF @E 999,999,999.99 S
VVA_PISENT N 12 2 Pis Compra @E 999,999,999.99 S
VVA_PMFENT N 12 2 Pis Cpa MF @E 999,999,999.99 S
VVA_COFENT N 12 2 V Cofins Cpa @E 999,999,999.99 S
VVA_CMFENT N 12 2 V Cof Cpa MF @E 999,999,999.99 S
VVA_JUREST N 12 2 Juros Estq @E 999,999,999.99 S
VVA_JMFEST N 12 2 Juro Estq MF @E 999,999,999.99 S
VVA_REDCUS N 12 2 RedutorCusto @E 999,999,999.99 S
VVA_RMFCUS N 12 2 RedCusto MF @E 999,999,999.99 S
VVA_DATRCU D 8 0 Dt Red Custo If(INCLUI,M->VVA_DATRCU==DDATABASE,if(M->VV0_OPEMOV=="1",(M->VVA_DATRCU==DataValida(M->VVA_DATRCU)),M->VVA_DATRCU==VVA_DATRCU)) S
VVA_ACESSO N 12 2 Acessorios @E 999,999,999.99 S
VVA_AMFSSO N 12 2 Acessor MF @E 999,999,999.99 S
VVA_VDESCO N 12 2 V Descontado @E 999,999,999.99 S
VVA_VMFSCO N 12 2 V Descont MF @E 999,999,999.99 S
VVA_LUCBRU N 12 2 Lucro Bruto @E 999,999,999.99 S
VVA_LMFBRU N 12 2 Luc Bruto MF @E 999,999,999.99 S
VVA_TOTDES N 12 2 Tot Despesas @E 999,999,999.99 S
VVA_TMFDES N 12 2 Tot Dsp MF @E 999,999,999.99 S
VVA_DESCLI N 12 2 Desp Cliente @E 999,999,999.99 S
VVA_DMFCLI N 12 2 Desp Cli MF @E 999,999,999.99 S
VVA_ASSIMP N 12 2 Asses Import @E 999,999,999.99 S
VVA_DATDCL D 8 0 Dt Desp Cli If(INCLUI,M->VVA_DATDCL==DDATABASE,if(M->VV0_OPEMOV=="1",(M->VVA_DATDCL==DataValida(M->VVA_DATDCL)),M->VVA_DATDCL==VVA_DATDCL)) S
VVA_SEGVIA N 12 2 Seg Viagem @E 999,999,999.99 MaFisRef("IT_SEGURO","VX001",M->VVA_SEGVIA) R S
VVA_SMFVIA N 12 2 Seg Viag MF @E 999,999,999.99 S
VVA_VALASS N 12 2 Associacao @E 999,999,999.99 S
VVA_VALFRE N 12 2 Valor Frete @E 999,999,999.99 MaFisRef("IT_FRETE","VX001",M->VVA_VALFRE) R S
VVA_VMFASS N 12 2 Associac MF @E 999,999,999.99 S
VVA_VALREV N 12 2 Vl Revisao @E 999,999,999.99 S
VVA_VMFREV N 12 2 Vl Revis. MF @E 999,999,999.99 S
VVA_VMFFRE N 12 2 Fre V Dir MF @E 999,999,999.99 S
VVA_DESVEI N 12 2 Vl Despesas @E 999,999,999.99 S
VVA_UTROCO N 12 2 Utiliz.Troco @E 999,999,999.99 R S
VVA_CUSVDA N 12 2 Custo Venda @E 999,999,999.99 R S
VVA_DMFVEI N 12 2 Vl Dsp MF @E 999,999,999.99 S
VVA_RECVEI N 12 2 Vl Receitas @E 999,999,999.99 S
VVA_VALIRF N 12 2 Valor do IR @E 999,999,999.99 MaFisRef("IT_VALIRR","VX001",M->VVA_VALIRF) R S
VVA_RMFVEI N 12 2 Vl Receit MF @E 999,999,999.99 S
VVA_AMFIMP N 12 2 Asses Imp MF @E 999,999,999.99 S
VVA_LUCLQ1 N 12 2 Lucro Liq. 1 @E 999,999,999.99 S
VVA_LMFLQ1 N 12 2 Luc Liq.1 MF @E 999,999,999.99 S
VVA_DESFIX N 12 2 Despesa Fixa @E 999,999,999.99 S
VVA_DMFFIX N 12 2 Dsp Fixa MF @E 999,999,999.99 S
VVA_VMFIRF N 12 2 Vlr do IR MF @E 999,999,999.99 S
VVA_COMVDE N 12 2 Com Vendedor @E 999,999,999.99 S
VVA_CMFVDE N 12 2 Com Vend MF @E 999,999,999.99 S
VVA_COMGER N 12 2 Com Gerencia @E 999,999,999.99 S
VVA_CMFGER N 12 2 Com Ger MF @E 999,999,999.99 S
VVA_COMPAT N 12 2 ComissPatio @E 999,999,999.99 S
VVA_CMFPAT N 12 2 ComPatio MF @E 999,999,999.99 S
VVA_DSPFIN N 12 2 Dsp Financei @E 999,999,999.99 S
VVA_DMFFIN N 12 2 Dsp Finan MF @E 999,999,999.99 S
VVA_LUCLQ2 N 12 2 Lucro Liq. 2 @E 999,999,999.99 S
VVA_LMFLQ2 N 12 2 Luc Liq.2 MF @E 999,999,999.99 S
VVA_EMINVD C 1 0 Emite NFVDir ! PERTENCE("10") 1=Sim;0=Nao S
VVA_USUARI C 15 0 Usuario @!S15 R S
VVA_PERDVD N 5 2 % Desc FtDir @E 99.99 R S
VVA_RESERV C 1 0 Reserva Veic @!S1 PERTENCE("01") 0=Nao;1=Sim S
VVA_VALDVD N 12 2 VlDesc FtDir @E 999,999,999.99 R S
VVA_OBSERV M 47 0 Observacao @! V S
VVA_DTLIBF D 8 0 Dt.Lib.Fatur R S
VVA_OBSMEM C 6 0 Memo-Observ S
VVA_ALIIPI N 5 2 Aliq. IPI @E 99.99 MaFisRef("IT_ALIQIPI","VX001",M->VVA_ALIIPI) R S
VVA_DTLIBE D 8 0 Dt.Lib.Entr. R S
VVA_ALIPIC N 5 2 Aliq.Pis/Cof @E 99.99 S
VVA_PERDES N 5 2 % Desconto @E 99.99 S
VVA_PERCVD N 5 2 % Com. FtDir @E 99.99 S
VVA_VRENET N 12 2 Vl Real Net @E 999,999,999.99 S
VVA_DATVAL D 8 0 Dt. Validade S
VVA_HORVAL C 4 0 Hora validad @R 99:99 R S
VVA_TITBON C 1 0 Bonus no CR @! R S
VVA_BONUS N 12 2 Vlr Bonus @E 999,999,999.99 R N
VVA_CPGVEN N 14 2 Com Pg Vde @E 99,999,999,999.99 R N
VVA_CPGGER N 14 2 Com Pg Ger @E 99,999,999,999.99 R N
VVA_CPGSUP N 14 2 Com Pg Sup @E 99,999,999,999.99 S
VVA_ENTMEM C 6 0 Cod.Mem.Entr @! R S
VVA_OBSENT M 70 0 Obs.Alt.Entr @! V S
VVA_REBATE N 12 2 Vlr Rebate @E 999,999,999.99 R N
VVA_DTESUG D 8 0 Dt.Entr.Sug. R S
VVA_DTEPRV D 8 0 Dt.Entr.Prev R S
VVA_USUREA C 6 0 Usuar.Entreg @! R S
VVA_DTEREA D 8 0 Dt.Entr.Real R S
VVA_HORREA N 4 0 Hr Entrega @R 99:99 R S
VVA_SIMVDA C 1 0 Simulac/Vda @! PERTENCE("SV") R S
VVA_DATENT D 8 0 Data Entrega R S
VVA_VALSOL N 12 2 Vlr Solidar @E 999,999,999.99 MaFisRef("IT_VALSOL","VX001",M->VVA_VALSOL) R S
VVA_DESACE N 12 2 Outras Desps @E 999,999,999.99 MaFisRef("IT_DESPESA","VX001",M->VVA_DESACE).AND.VX002VLDENC() R S
VVA_BASSOL N 12 2 Base Solidar @E 999,999,999.99 MaFisRef("IT_BASESOL","VX001",M->VVA_BASSOL) R S
VVA_FRETE N 12 2 Vlr Frete @E 999,999,999.99 R N
VVA_OPER C 2 0 Tip.Operacao @! ExistCpo("SX5","DJ"+M->VVA_OPER) DJ V S
VVA_REDVDA N 12 2 Redutor Vda. @E 999,999,999.99 R S
VVA_AGREGA N 12 2 Vda.Agregada @E 999,999,999.99 R S
VVA_VALPIS N 12 2 Vl. PIS @E 999,999,999.99 MaFisRef("IT_VALPS2","VX001",M->VVA_VALPIS) R S
VVA_VALCOF N 12 2 Vl. COFINS @E 999,999,999.99 MaFisRef("IT_VALCF2","VX001",M->VVA_VALCOF) R S
VVA_CODPED C 8 0 Cod Int Ped R S
VVA_NUMPED C 8 0 Num Ped Fabr @! R S
VVA_HREPRV N 2 0 Hr.Entr.Prev @E 99 S
VVA_FIEPRV C 2 0 Filial Box S
VVA_BOEPRV C 3 0 Codigo Box @! S
VVA_USEPRV C 6 0 Usuario Box @! vazio() .or. FG_Seek("VAI","M->VVA_USUBOX",1,.f.) VAI S
VVA_CENCUS C 9 0 Centro Custo @! (Vazio() .or. Ctb105CC()) CTT S
VVA_CONTA C 20 0 C Contabil @! (Vazio() .or. Ctb105CTA()) CT1 S
VVA_ITEMCT C 9 0 Item Conta @! (Vazio() .or. Ctb105ITEM()) CTD S
VVA_CLVL C 9 0 Classe Valor @! (Vazio() .or. Ctb105CLVL()) CTH S
VVA_FCICOD C 36 0 Cod. FCI @! R S
VVA_FORMUL C 6 0 Form Val Mov @! FG_Seek("VEG","M->VVA_FORMUL",1,.f.) VEG R S
VVA_CAMPAN C 50 0 Campanha @! V S
VVA_VENREA C 6 0 Vend.Entreg @! SA3 R S
VVA_VALCMP N 12 2 ICMS Compl. @E 999,999,999.99 MaFisRef("IT_VALCMP","VX001",M->VVA_VALCMP) R S
VVA_DIFAL N 12 2 Dif.de ICMS @E 999,999,999.99 MaFisRef("IT_DIFAL","VX001",M->VVA_DIFAL) R S