| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| VVG | Itens das Entradas de Veiculos | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| VVG_FILIAL | C | 2 | 0 | Filial | S | ||||||
| VVG_TRACPA | C | 10 | 0 | Transacao | @E9 | M->VVG_TRACPA == M->VVF_TRACPA | S | ||||
| VVG_CHASSI | C | 25 | 0 | Chassi | @!S25 | IIF(LEFT(FUNNAME(),5) == "VEIXA",VX000Inc("VV1",0,3),(FG_POSVEI("M->VVG_CHASSI",).or..t.).and.VE000Inc("VV1",0,3)) | V11 | R | S | ||
| VVG_CHAINT | C | 6 | 0 | Chassi Int | @E 999999 | S | |||||
| VVG_CODTES | C | 3 | 0 | T.E.S. | @!S3 | FG_Seek("SF4","M->VVG_CODTES",1,.f.).and.MaAvalTes("E",M->VVG_CODTES).and.MaFisRef("IT_TES","VVG00",M->VVG_CODTES).and.VM000TE() | SF4 | R | S | ||
| VVG_ESTVEI | C | 1 | 0 | Estado Veic | @!S1 | IIF(LEFT(FUNNAME(),5)=="VEIXA",Pertence("01").and.VX000ALMVEI(),Pertence("01").and.FS_AlmVei()) | R | 0=Novo;1=Usado | S | ||
| VVG_CONTA | C | 20 | 0 | Cta Contabil | @! | vazio().or.existcpo("CT1") | CT1 | S | |||
| VVG_CENCUS | C | 9 | 0 | Centro Custo | @! | vazio().or.existcpo("CTT") | CTT | S | |||
| VVG_CODIND | C | 2 | 0 | Cod. Indice | @! | FG_Seek("VVH","M->VVG_CODIND",1,.f.,"M->VVG_DIACAR","VVH_DIACAR") | VVH | R | S | ||
| VVG_DIACAR | N | 3 | 0 | Dias Carenci | 999 | Positivo() | R | S | |||
| VVG_CODORI | C | 1 | 0 | Origem | @!S1 | PERTENCE("01234") | 0=Fabrica;1=Concessionaria;2=Outros;3=Troca por Novo;4=Troca por Usado | S | |||
| VVG_LOCALI | C | 15 | 0 | Localizacao | @! | ExistCpo("VZL",M->VVG_LOCPAD+M->VVG_LOCALI,1) | VZL | R | S | ||
| VVG_LOCPAD | C | 2 | 0 | Local Padrao | @! | ExistCpo("NNR",M->VVG_LOCPAD,1) | NNR | R | S | ||
| VVG_SITTRI | C | 3 | 0 | Sit.Tributar | @! | NaoVazio() .And. ExistCpo("SX5","S0"+Left(M->VVG_SITTRI,1)) | S0 | S | |||
| VVG_VALUNI | N | 12 | 2 | Vlr Unitario | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("IT_VALMERC","VVG00",M->VVG_VALUNI),VX000VLD()) | R | S | |||
| VVG_VALDES | N | 12 | 2 | Desconto | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("IT_DESCONTO","VVG00",M->VVG_VALDES),VX000VLD()) | R | S | |||
| VVG_TOTSEG | N | 12 | 2 | Vl Tot Segur | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("IT_SEGURO","VVG00",M->VVG_TOTSEG),VX000VLD()) | R | S | |||
| VVG_TOTFRE | N | 12 | 2 | Vl Frete NF | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("IT_FRETE","VVG00",M->VVG_TOTFRE),VX000VLD()) | R | S | |||
| VVG_DESACE | N | 12 | 2 | Outras Desps | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("IT_DESPESA","VVG00",M->VVG_DESACE),VX000VLD()) | R | S | |||
| VVG_VBAIPI | N | 12 | 2 | Vl Base IPI | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("IT_BASEIPI","VVG00",M->VVG_VBAIPI),VX000VLD()) | S | ||||
| VVG_ALIIPI | N | 5 | 2 | Aliq. IPI | @E 99.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("IT_ALIQIPI","VVG00",M->VVG_ALIIPI),VX000VLD()) | S | ||||
| VVG_VALIPI | N | 12 | 2 | Vl IPI | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("IT_VALIPI","VVG00",M->VVG_VALIPI),VX000VLD()) | S | ||||
| VVG_VBAICM | N | 12 | 2 | Vl Base ICM | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("IT_BASEICM","VVG00",M->VVG_VBAICM),VX000VLD()) | S | ||||
| VVG_ALIICM | N | 5 | 2 | Aliq. ICMS | @E 99.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("IT_ALIQICM","VVG00",M->VVG_ALIICM),VX000VLD()) | S | ||||
| VVG_ICMCOM | N | 12 | 2 | Vl ICMS Cpa | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("IT_VALICM","VVG00",M->VVG_ICMCOM),VX000VLD()) | S | ||||
| VVG_VBICRT | N | 12 | 2 | Base ICM Sol | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("IT_BASESOL","VVG00",M->VVG_VBICRT),VX000VLD()) | S | ||||
| VVG_ICMRET | N | 12 | 2 | ICMS Solid | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("IT_VALSOL","VVG00",M->VVG_ICMRET),VX000VLD()) | S | ||||
| VVG_VCNVEI | N | 12 | 2 | CustoNominal | @E 999,999,999.99 | Positivo() | S | ||||
| VVG_VDESCO | N | 12 | 2 | V Descontado | @E 999,999,999.99 | M->VVG_ESTVEI == "0" | S | ||||
| VVG_PICOSB | C | 1 | 0 | Pis/Cof Subs | @!S1 | Pertence("01") .and. FS_CalCPCS() | 0=Nao;1=Sim | M->VVG_ESTVEI == "0" | S | ||
| VVG_PISENT | N | 12 | 2 | Pis Substit | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("IT_VALPS2","VVG00",M->VVG_PISENT),.T.) | M->VVG_ESTVEI == "0" | S | |||
| VVG_COFENT | N | 12 | 2 | Cofins Subst | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("IT_VALCF2","VVG00",M->VVG_COFENT),.T.) | M->VVG_ESTVEI == "0" | S | |||
| VVG_REDCUS | N | 12 | 2 | Vl RedCusto | @E 999,999,999.99 | S | |||||
| VVG_SEGVIA | N | 12 | 2 | Vl SegViagem | @E 999,999,999.99 | S | |||||
| VVG_VALASS | N | 12 | 2 | Vl Associaca | @E 999,999,999.99 | S | |||||
| VVG_VALREV | N | 12 | 2 | Vl Revisoes | @E 999,999,999.99 | S | |||||
| VVG_VALPIS | N | 12 | 2 | Pis | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("IT_VALPIS","VVG00",M->VVG_VALPIS),VX000VLD()) | R | S | |||
| VVG_VALFRE | N | 12 | 2 | Conhec Frete | @E 999,999,999.99 | S | |||||
| VVG_COMPGC | N | 12 | 2 | ComisPgCompr | @E 999,999,999.99 | S | |||||
| VVG_VALCOF | N | 12 | 2 | Cofins | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("IT_VALCOF","VVG00",M->VVG_VALCOF),VX000VLD()) | R | S | |||
| VVG_ASSIMP | N | 12 | 2 | Vl Assessori | @E 999,999,999.99 | S | |||||
| VVG_ATDFTD | C | 10 | 0 | Atend. VDI | @! | R | N | ||||
| VVG_NUMPED | C | 6 | 0 | Pedido | @! | SC7 | R | S | |||
| VVG_ITPED | C | 4 | 0 | Item Pedido | @! | R | S | ||||
| VVG_OPER | C | 2 | 0 | Tip.Operacao | @! | ExistCpo("SX5","DJ"+M->VVG_OPER) | DJ | V | S | ||
| VVG_CONIMP | N | 9 | 4 | Cnt. Import. | @E 9,999.9999 | R | S | ||||
| VVG_FCICOD | C | 36 | 0 | Cod. FCI | @! | R | S | ||||
| VVG_ITEMCT | C | 9 | 0 | Item Conta | @! | (Vazio() .or. Ctb105ITEM()) | CTD | S | |||
| VVG_CLVL | C | 9 | 0 | Classe Valor | @! | (Vazio() .or. Ctb105CLVL()) | CTH | S | |||
| VVG_II | N | 12 | 2 | Vlr.I.I. | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("IT_VALII","VVG00",M->VVG_II),VX000VLD()) | R | S | |||
| VVG_ALIQII | N | 6 | 2 | Aliq Import | @E 999.99 | Positivo() .And. IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("IT_ALIQII","VVG00",M->VVG_ALIQII),VX000VLD()) | R | S | |||
| VVG_BASCOF | N | 12 | 2 | Base Cofins | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("IT_BASECF2","VVG00",M->VVG_BASCOF),VX000VLD()) | R | S | |||
| VVG_ALICOF | N | 6 | 2 | Aliq. Cofins | @E 999.99 | Positivo() .And. IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("IT_ALIQCF2","VVG00",M->VVG_ALICOF),VX000VLD()) | R | S | |||
| VVG_BASPIS | N | 12 | 2 | Base Pis | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("IT_BASEPS2","VVG00",M->VVG_BASPIS),VX000VLD()) | R | S | |||
| VVG_ALIPIS | N | 6 | 2 | Aliq. Pis | @E 999.99 | Positivo() .And. IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("IT_ALIQPS2","VVG00",M->VVG_ALIPIS),VX000VLD()) | R | S | |||
| VVG_BAIMP5 | N | 12 | 2 | Base Imp. 5 | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("IT_BASECF2","VVG00",M->VVG_BAIMP5),VX000VLD()) | R | S | |||
| VVG_ALIMP5 | N | 6 | 2 | Aliq. Imp. 5 | @E 999.99 | Positivo() .And. IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("IT_ALIQCF2","VVG00",M->VVG_ALIMP5),VX000VLD()) | R | S | |||
| VVG_VLIMP5 | N | 12 | 2 | Valor Imp. 5 | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("IT_VALCF2","VVG00",M->VVG_VLIMP5),VX000VLD()) | R | S | |||
| VVG_BAIMP6 | N | 12 | 2 | Base Imp. 6 | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("IT_BASEPS2","VVG00",M->VVG_BAIMP6),VX000VLD()) | R | S | |||
| VVG_ALIMP6 | N | 6 | 2 | Aliq. Imp. 6 | @E 999.99 | Positivo() .And. IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("IT_ALIQPS2","VVG00",M->VVG_ALIMP6),VX000VLD()) | R | S | |||
| VVG_VLIMP6 | N | 12 | 2 | Valor Imp. 6 | @E 999,999,999.99 | IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("IT_VALPS2","VVG00",M->VVG_VLIMP6),VX000VLD()) | R | S | |||
| VVG_CF | C | 5 | 0 | Cod. Fiscal | @9 | NaoVazio() .And. AvalCfo("VVG",M->VVG_CF) .And. IIF(LEFT(FUNNAME(),5)=="VEIXA",MaFisRef("IT_CF","VVG00",M->VVG_CF),VX000VLD()) | 13 | R | S | ||