| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| VVF | Entradas de Veiculos | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| VVF_FILIAL | C | 2 | 0 | Filial | S | ||||||
| VVF_FORPRO | C | 1 | 0 | Form Proprio | @!S1 | PERTENCE("10") | 1=Sim;0=Nao | S | |||
| VVF_OPEMOV | C | 1 | 0 | Operac Movto | @!S1 | PERTENCE("012345678") | 0=Normal;1=Ped.Fabrica;2=Remessa;3=Transferencia;4=Consignacao;5=Devolucao;6=Frete;7=Retorno de Remessa;8=Retorno de Consignacao | S | |||
| VVF_TRACPA | C | 10 | 0 | Transacao | @E9 | S | |||||
| VVF_DATMOV | D | 8 | 0 | Data Movto | @D | If(Inclui,M->VVF_DATMOV == DDATABASE,M->VVF_DATMOV == VVF_DATMOV) | S | ||||
| VVF_DATEMI | D | 8 | 0 | Data Emissao | M->VVF_DATEMI >= M->VVF_DATMOV - 120 .and. M->VVF_DATEMI <= M->VVF_DATMOV | S | |||||
| VVF_DATFAB | D | 8 | 0 | Dt SaidaFabr | @D | M->VVF_DATFAB >= M->VVF_DATMOV - 120 .and. M->VVF_DATFAB <= M->VVF_DATMOV | S | ||||
| VVF_CODFOR | C | 6 | 0 | Fornecedor | @! | IIF(LEFT(FUNNAME(),5)=="VEIXA",VX000VLDENC(),VX000VLD()) | VV6A | R | S | ||
| VVF_LOJA | C | 2 | 0 | Loja | @! | IIF(LEFT(FUNNAME(),5)=="VEIXA",VX000VLDENC(),VX000VLD()) | R | S | |||
| VVF_NOMFOR | C | 20 | 0 | Nome do Forn | @!S20 | V | S | ||||
| VVF_CODCOM | C | 6 | 0 | Comprador | @!S6 | Vazio() .or. FG_Seek("SY1","M->VVF_CODCOM",1,.f.) | SY1 | S | |||
| VVF_FORPAG | C | 3 | 0 | Cond.Pgto | !!! | IIF(LEFT(FUNNAME(),5)=="VEIXA",FG_Seek("SE4","M->VVF_FORPAG",1,.f.,"VVF_DESFPG","E4_DESCRI") .and. VX000VLDENC(),VX000VLD()) | SE4 | R | S | ||
| VVF_DESFPG | C | 15 | 0 | Descricao | @!S15 | V | S | ||||
| VVF_NATURE | C | 10 | 0 | Natureza | @! | FinVldNat( .F. ) | SED | R | S | ||
| VVF_TESFRE | C | 3 | 0 | T.E.S. | @!S3 | IIF(LEFT(FUNNAME(),5)=="VEIXA",FG_Seek("SF4","M->VVF_TESFRE",1,.f.) .and. MaAvalTES("E",M->VVF_TESFRE),VX000VLD()) | SF4 | R | S | ||
| VVF_NUMNFI | C | 9 | 0 | Nro NFiscal | @! | M->VVF_FORPRO=="0" | S | ||||
| VVF_SERNFI | C | 3 | 0 | Serie NF | @!S3 | IIF(LEFT(FUNNAME(),5)=="VEIXA",VX000VLDENC(),VM000VERNF(M->VVF_NUMNFI+M->VVF_SERNFI+M->VVF_CODFOR+M->VVF_LOJA)) | 01 | R | M->VVF_FORPRO=="0" | S | |
| VVF_VALMOV | N | 12 | 2 | Vl Total NF | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("NF_TOTAL","VX000",M->VVF_VALMOV),VX000VLD()) | R | S | |||
| VVF_TOTSEG | N | 12 | 2 | Vl Tot Segur | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("NF_SEGURO","VX000",M->VVF_VALSEG),VX000VLD()) | R | S | |||
| VVF_TOTFRE | N | 12 | 2 | Vl Tot Frete | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("NF_FRETE","VVG00",M->VVF_TOTFRE) .And. VX000ATUF1("FRETE"),VX000VLD()) | R | S | |||
| VVF_DESACE | N | 12 | 2 | Outras Desps | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("NF_DESPESA","VVG00",M->VVF_DESACE) .And. VX000ATUF1("DESPESA"),VX000VLD()) | R | S | |||
| VVF_VBAIPI | N | 12 | 2 | Vl Base IPI | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("NF_BASEIPI","VX000",M->VVF_VBAIPI),VX000VLD()) | R | S | |||
| VVF_ALIIPI | N | 5 | 2 | Aliquota IPI | @E 99.99 | Positivo() | S | ||||
| VVF_VALIPI | N | 12 | 2 | Vl IPI | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("NF_VALIPI","VX000",M->VVF_VALIPI),VX000VLD()) | R | S | |||
| VVF_VBAICM | N | 12 | 2 | Vl Base ICMS | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("NF_BASEICM","VX000",M->VVF_VBAICM),VX000VLD()) | R | S | |||
| VVF_ALIICM | N | 5 | 2 | Aliquot ICMS | @E 99.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",.T.,VX000VLD()) | R | S | |||
| VVF_TOTICM | N | 12 | 2 | Vl Tot ICMS | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("NF_VALICM","VX000",M->VVF_TOTICM),VX000VLD()) | R | S | |||
| VVF_ICMRET | N | 12 | 2 | ICMS Retido | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("NF_VALSOL","VX000",M->VVF_ICMRET),VX000VLD()) | R | S | |||
| VVF_CODBCO | C | 3 | 0 | Banco | @! | IIF(LEFT(FUNNAME(),4)=="VEIX",Vazio().or.FG_StrZero("M->VVF_CODBCO",3,.f.).and.FG_Seek("SA6","M->VVF_CODBCO",1,.f.),VX000VLD()) | R | S | |||
| VVF_QTDVEI | N | 2 | 0 | Qtd Veic NF | @E 99 | M->VVF_QTDVEI>0 | S | ||||
| VVF_SITNFI | C | 1 | 0 | Situacao NF | ! | 0=Cancelada;1=Valida;2=Devolvida;3=Devol.Parcial | S | ||||
| VVF_CODAGE | C | 5 | 0 | Agencia | @! | FG_Seek("SA6","M->VVF_CODBCO+M->VVF_CODAGE",1,.f.).or.vazio() | S | ||||
| VVF_NUMPED | C | 6 | 0 | Nro Pedido | @X | S | |||||
| VVF_CONFRE | N | 12 | 2 | V Conh Frete | @E 999,999,999.99 | Positivo() | S | ||||
| VVF_NUMTRA | C | 10 | 0 | NF de Saida | @E9 | S | |||||
| VVF_DATUSU | C | 15 | 0 | Data/Usuario | @!S24 | S | |||||
| VVF_DTHEMI | C | 19 | 0 | Dt/Hr Digita | @!S14 | S | |||||
| VVF_OBSERV | M | 47 | 0 | Observacao | @! | V | S | ||||
| VVF_OBSMEM | C | 6 | 0 | Memo-Observ | R | S | |||||
| VVF_EXPVEI | C | 1 | 0 | Exp Fab | @! | R | S | ||||
| VVF_ESPECI | C | 5 | 0 | Espec.Docum. | @! | Vazio() .or. ExistCpo("SX5","42"+M->VVF_ESPECI) | 42 | R | S | ||
| VVF_PLIQUI | N | 11 | 4 | Peso Liquido | @E 999999.9999 | R | S | ||||
| VVF_PBRUTO | N | 11 | 4 | Peso Bruto | @E 999999.9999 | R | S | ||||
| VVF_TRANSP | C | 6 | 0 | Transp. | @! | ExistCpo("SA4",M->VVF_TRANSP,1) | SA4 | R | S | ||
| VVF_ESPEC1 | C | 10 | 0 | Especie 1 | @! | R | S | ||||
| VVF_VOLUM1 | N | 6 | 0 | Volume 1 | @E 999999 | R | S | ||||
| VVF_ESPEC2 | C | 10 | 0 | Especie 2 | @! | R | S | ||||
| VVF_VOLUM2 | N | 6 | 0 | Volume 2 | @E 999999 | R | S | ||||
| VVF_ESPEC3 | C | 10 | 0 | Especie 3 | @! | R | S | ||||
| VVF_VOLUM3 | N | 6 | 0 | Volume 3 | @E 999999 | R | S | ||||
| VVF_ESPEC4 | C | 10 | 0 | Especie 4 | @! | R | S | ||||
| VVF_VOLUM4 | N | 6 | 0 | Volume 4 | @E 999999 | R | S | ||||
| VVF_OBSMNF | C | 6 | 0 | Oco-MEMO | R | S | |||||
| VVF_OBSENF | M | 70 | 0 | Observ. NF | @! | V | S | ||||
| VVF_TIPO | C | 1 | 0 | Tipo da nota | @! | R | S | ||||
| VVF_CHVNFE | C | 44 | 0 | Chave da NFE | @! | VXVlChvNfe(M->VVF_FORPRO,M->VVF_ESPECIE) | R | M->VVF_FORPRO=="0" | S | ||
| VVF_TIPMOV | C | 1 | 0 | Tp Movimento | @! | Pertence("012") | R | 0=Normal;1=Agrega;2=Desagrega | S | ||
| VVF_RECSF1 | N | 9 | 0 | Recno | @E 999,999,999 | S | |||||
| VVF_CLIFOR | C | 1 | 0 | Utiliza | @! | VX000CLIFOR() .AND. Pertence("FC") | C=Cliente;F=Fornecedor | S | |||
| VVF_MENNOT | C | 60 | 0 | Mens.p/Nota | @S45 | texto() .Or. Vazio() | M->VVF_FORPRO=="1" | S | |||
| VVF_MENPAD | C | 3 | 0 | Mens.Padrao | @! | vazio() .or. existcpo("SM4") | SM4 | M->VVF_FORPRO=="1" | S | ||
| VVF_SDOC | C | 3 | 0 | Serie Doc | !!! | R | S | ||||
| VVF_TIPDOC | C | 1 | 0 | Tp.Doc.Gerar | @! | Pertence("12") | R | 1=NF;2=Mov.Interna | S | ||
| VVF_MUORIT | C | 5 | 0 | Mun Ori Tran | @! | vazio() .or. ExistCpo("CC2",M->VVF_UFORIT+M->VVF_MUORIT) | CC2SA1 | R | S | ||
| VVF_UFORIT | C | 2 | 0 | UF Ori Trans | @! | Vazio() .or. (ExistCpo("SX5","12"+M->VVF_UFORIT) .and. MaFisRef("NF_UFORIGEM","MT100",M->VVF_UFORIT) .and. VM006FldOK() ) | 12 | R | S | ||
| VVF_MUDEST | C | 5 | 0 | Mun Dest Tra | @! | vazio() .or. ExistCpo("CC2",M->VVF_UFDEST+M->VVF_MUDEST) | CC2SA1 | R | S | ||
| VVF_UFDEST | C | 2 | 0 | UF Dest Tran | @! | Vazio() .or. (ExistCpo("SX5","12"+M->VVF_UFDEST) .and. MaFisRef("NF_UFDEST","MT100",M->VVF_UFDEST) .and. VM006FldOK() ) | 12 | R | S | ||
| VVF_DEVMER | C | 1 | 0 | Dev.merc.n.r | @! | Pertence(" SN") | R | M->VVF_FORPRO=="1" | S | ||
| VVF_VEICU1 | C | 8 | 0 | Veiculo 1 | @! | DA3 | R | S | |||
| VVF_VEICU2 | C | 8 | 0 | Veiculo 2 | @! | DA3 | R | S | |||
| VVF_VEICU3 | C | 8 | 0 | Veiculo 3 | @! | DA3 | R | S | |||
| VVF_CLIRET | C | 6 | 0 | Cod.Cli.Ret. | @! | SA1 | R | S | |||
| VVF_LOJRET | C | 2 | 0 | Loj.Cli.Ret. | @! | R | S | ||||
| VVF_CLIENT | C | 6 | 0 | Cod.Cli.Ent. | @! | SA1 | R | S | |||
| VVF_LOJENT | C | 2 | 0 | Loj.Cli.Entr | @! | R | S | ||||
| VVF_MOEDA | N | 2 | 0 | Moeda | @E 99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("NF_MOEDA","VVF00",M->VVF_MOEDA),VX000VLD()) | R | S | |||
| VVF_TXMOED | N | 11 | 4 | Taxa Moeda | @E 999,999.9999 | R | S | ||||
| VVF_BASCOF | N | 12 | 2 | Base Cofins | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("NF_BASECF2","VVF00",M->VVF_BASCOF),VX000VLD()) | R | S | |||
| VVF_ALICOF | N | 6 | 2 | Aliq. Cofins | @E 999.99 | R | S | ||||
| VVF_VALCOF | N | 12 | 2 | Cofins | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("NF_VALCF2","VVF00",M->VVF_VALCOF),VX000VLD()) | R | S | |||
| VVF_BASPIS | N | 12 | 2 | Base Pis | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("NF_BASEPS2","VVF00",M->VVF_BASPIS),VX000VLD()) | R | S | |||
| VVF_ALIPIS | N | 6 | 2 | Aliq. Pis | @E 999.99 | R | S | ||||
| VVF_VALPIS | N | 12 | 2 | Pis | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("NF_VALPS2","VVF00",M->VVF_VALPIS),VX000VLD()) | R | S | |||