| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| VEC | Avaliacao de Venda de Pecas | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| VEC_FILIAL | C | 2 | 0 | Filial | S | ||||||
| VEC_NUMORC | C | 8 | 0 | Nro Orcamto | @E 99999999 | S | |||||
| VEC_GRUITE | C | 4 | 0 | Grupo | @!S4 | S | |||||
| VEC_CODITE | C | 27 | 0 | Cod Item | @!S27 | S | |||||
| VEC_QTDITE | N | 10 | 2 | Quantidade | @E 9,999,999.99 | S | |||||
| VEC_VALBRU | N | 14 | 2 | Vlr Bruto | @E 99,999,999,999.99 | S | |||||
| VEC_VMFBRU | N | 14 | 2 | Vlr Bruto MF | @E 99,999,999,999.99 | S | |||||
| VEC_VALDES | N | 14 | 2 | Vlr Desconto | @E 99,999,999,999.99 | S | |||||
| VEC_VALVDA | N | 14 | 2 | Vlr da Venda | @E 99,999,999,999.99 | S | |||||
| VEC_VMFDES | N | 14 | 2 | Vlr Desc MF | @E 99,999,999,999.99 | S | |||||
| VEC_VMFVDA | N | 14 | 2 | Vlr Vda MF | @E 99,999,999,999.99 | S | |||||
| VEC_TOTIMP | N | 14 | 2 | Tt Impostos | @E 99,999,999,999.99 | S | |||||
| VEC_TMFIMP | N | 14 | 2 | Tt Impost MF | @E 99,999,999,999.99 | S | |||||
| VEC_VALICM | N | 14 | 2 | Vl do ICMS | @E 99,999,999,999.99 | S | |||||
| VEC_ALQICM | N | 5 | 2 | Aliq. ICMS | @E 99.99 | S | |||||
| VEC_VALPIS | N | 14 | 2 | Vl do PIS | @E 99,999,999,999.99 | S | |||||
| VEC_VMFPIS | N | 14 | 2 | Vl do PIS MF | @E 99,999,999,999.99 | S | |||||
| VEC_VALCOF | N | 14 | 2 | Vl do COFINS | @E 99,999,999,999.99 | S | |||||
| VEC_VMFCOF | N | 14 | 2 | Vl COFINS MF | @E 99,999,999,999.99 | S | |||||
| VEC_IMFSRT | N | 14 | 2 | ICMS Ret MF | @E 99,999,999,999.99 | R | S | ||||
| VEC_CUSTOT | N | 14 | 2 | Custo Total | @E 99,999,999,999.99 | S | |||||
| VEC_CMFTOT | N | 14 | 2 | Custo Tot MF | @E 99,999,999,999.99 | S | |||||
| VEC_CUSMED | N | 14 | 2 | Custo Medio | @E 99,999,999,999.99 | S | |||||
| VEC_CMFMED | N | 14 | 2 | Custo Med MF | @E 99,999,999,999.99 | S | |||||
| VEC_VMFICM | N | 14 | 2 | Vl ICMS MF | @E 99,999,999,999.99 | S | |||||
| VEC_JUREST | N | 14 | 2 | Jrs Estoque | @E 99,999,999,999.99 | S | |||||
| VEC_JMFEST | N | 14 | 2 | Jrs Estq MF | @E 99,999,999,999.99 | S | |||||
| VEC_LUCBRU | N | 14 | 2 | Lucro Bruto | @E 99,999,999,999.99 | S | |||||
| VEC_LMFBRU | N | 14 | 2 | Luc Bruto MF | @E 99,999,999,999.99 | S | |||||
| VEC_DESVAR | N | 14 | 2 | Dsp Variavel | @E 99,999,999,999.99 | S | |||||
| VEC_DMFVAR | N | 14 | 2 | Dsp Var MF | @E 99,999,999,999.99 | S | |||||
| VEC_COMVEN | N | 14 | 2 | Com Vendedor | @E 99,999,999,999.99 | S | |||||
| VEC_CMFVEN | N | 14 | 2 | Com Vend MF | @E 99,999,999,999.99 | S | |||||
| VEC_COMGER | N | 14 | 2 | Com Gerencia | @E 99,999,999,999.99 | S | |||||
| VEC_CMFGER | N | 14 | 2 | Com Ger MF | @E 99,999,999,999.99 | S | |||||
| VEC_LUCLIQ | N | 14 | 2 | Lucro Liquid | @E 99,999,999,999.99 | S | |||||
| VEC_LMFLIQ | N | 14 | 2 | Lucro Liq MF | @E 99,999,999,999.99 | S | |||||
| VEC_DESFIX | N | 14 | 2 | Despesa Fixa | @E 99,999,999,999.99 | S | |||||
| VEC_DMFFIX | N | 14 | 2 | Desp Fixa MF | @E 99,999,999,999.99 | S | |||||
| VEC_CUSFIX | N | 14 | 2 | Custo Fixo | @E 99,999,999,999.99 | S | |||||
| VEC_CMFFIX | N | 14 | 2 | Custo Fxo MF | @E 99,999,999,999.99 | S | |||||
| VEC_DESDEP | N | 14 | 2 | Desp Depto | @E 99,999,999,999.99 | S | |||||
| VEC_DMFDEP | N | 14 | 2 | Dsp Depto MF | @E 99,999,999,999.99 | S | |||||
| VEC_DESADM | N | 14 | 2 | Desp Admin | @E 99,999,999,999.99 | S | |||||
| VEC_DMFADM | N | 14 | 2 | Dsp Admin MF | @E 99,999,999,999.99 | S | |||||
| VEC_RESFIN | N | 14 | 2 | Result Final | @E 99,999,999,999.99 | S | |||||
| VEC_RMFFIN | N | 14 | 2 | Resul Fin MF | @E 99,999,999,999.99 | S | |||||
| VEC_BALOFI | C | 1 | 0 | Balcao/Ofic | @! | S | |||||
| VEC_DEPVEN | C | 1 | 0 | Depto Venda | @! | S | |||||
| VEC_TIPTEM | C | 4 | 0 | Tpo de Tempo | @! | S | |||||
| VEC_DATVEN | D | 8 | 0 | Dt da Venda | S | ||||||
| VEC_SERNFI | C | 3 | 0 | Serie NFisc | @! | S | |||||
| VEC_NUMNFI | C | 9 | 0 | Nro NFiscal | @! | S | |||||
| VEC_NUMOSV | C | 8 | 0 | Nro Ord Srvc | @ 99999999 | S | |||||
| VEC_NUMREL | C | 8 | 0 | Nr Rel Pecas | @ 99999999 | S | |||||
| VEC_NUMIDE | C | 10 | 0 | Nro Identif | @ 99999999 | S | |||||
| VEC_CODMAR | C | 3 | 0 | Marca | @!S3 | S | |||||
| VEC_MODVEI | C | 30 | 0 | Modelo | @! | S | |||||
| VEC_PECINT | C | 15 | 0 | Cod Int Peca | @! | S | |||||
| VEC_SERORI | C | 3 | 0 | Serie Origem | @! | S | |||||
| VEC_NFIORI | C | 9 | 0 | NFiscal Orig | @! | S | |||||
| VEC_LOTECT | C | 10 | 0 | Lote | FG_RASTRO(M->VEC_GRUITE,M->VEC_CODITE,M->VEC_QTDITE,M->VEC_LOTECT,M->VEC_NUMLOT) | S | |||||
| VEC_NUMLOT | C | 6 | 0 | Sub-Lote | @! | FG_RASTRO(M->VEC_GRUITE,M->VEC_CODITE,M->VEC_QTDITE,M->VEC_LOTECT,M->VEC_NUMLOT) | S | ||||
| VEC_NUMSER | C | 20 | 0 | Num de Serie | @! | FG_RASTRO(M->VEC_GRUITE,M->VEC_CODITE,M->VEC_QTDITE,M->VEC_LOTECT,M->VEC_NUMLOT,M->VEC_NUMSER) | S | ||||
| VEC_VALFRE | N | 14 | 2 | Vlr do Frete | @E 99,999,999,999.99 | S | |||||
| VEC_VALSEG | N | 14 | 2 | Vlr Seguro | @E 99,999,999,999.99 | S | |||||
| VEC_VMFFRE | N | 14 | 2 | Vl MF Frete | @E 99,999,999,999.99 | S | |||||
| VEC_ICMSST | N | 14 | 2 | ICMS ST | @E 99,999,999,999.99 | R | S | ||||
| VEC_VMFSEG | N | 14 | 2 | Vl MF Seguro | @E 99,999,999,999.99 | S | |||||
| VEC_IMFSST | N | 14 | 2 | RESSARCIMENT | @E 99,999,999,999.99 | R | S | ||||
| VEC_DCLBST | N | 14 | 2 | D/C LC ICMS | @E 99,999,999,999.99 | R | S | ||||
| VEC_DMFBST | N | 14 | 2 | D/C LB ICMS | @E 99,999,999,999.99 | R | S | ||||
| VEC_COPIST | N | 14 | 2 | CRED ICMS ST | @E 99,999,999,999.99 | R | S | ||||
| VEC_CMFIST | N | 14 | 2 | CRED ST MF | @E 99,999,999,999.99 | R | S | ||||
| VEC_ICMSRT | N | 14 | 2 | ICMS Retido | @E 99,999,999,999.99 | R | S | ||||
| VEC_DESACE | N | 14 | 2 | Desp.Acessor | @E 99,999,999,999.99 | R | S | ||||
| VEC_DMFACE | N | 14 | 2 | Desp.Aces MF | @E 99,999,999,999.99 | R | S | ||||
| VEC_VALIPI | N | 14 | 2 | Valor IPI | @E 99,999,999,999.99 | R | S | ||||
| VEC_VMFIPI | N | 14 | 2 | Valor IPI MF | @E 99,999,999,999.99 | R | S | ||||
| VEC_PEDXML | C | 15 | 0 | NroPedCli | @! | R | S | ||||
| VEC_ITEXML | C | 6 | 0 | ItePedCli | @! | R | S | ||||
| VEC_LIBVOO | C | 8 | 0 | Num. Lib. TT | R | S | |||||
| VEC_ITENFI | C | 2 | 0 | Item NFiscal | @! | R | S | ||||
| VEC_PEDNUM | C | 6 | 0 | Num. Pedido | @x | R | S | ||||
| VEC_PEDITE | C | 2 | 0 | Item Pedido | @! | R | S | ||||
| VEC_CENCUS | C | 9 | 0 | Centro Custo | @! | (Vazio() .or. Ctb105CC()) | CTT | S | |||
| VEC_CONTA | C | 20 | 0 | C Contabil | @! | (Vazio() .or. Ctb105CTA()) | CT1 | S | |||
| VEC_ITEMCT | C | 9 | 0 | Item Conta | @! | (Vazio() .or. Ctb105ITEM()) | CTD | S | |||
| VEC_CLVL | C | 9 | 0 | Classe Valor | @! | (Vazio() .or. Ctb105CLVL()) | CTH | S | |||
| VEC_VALCMP | N | 12 | 2 | ICMS Compl. | @E 999,999,999.99 | S | |||||
| VEC_DIFAL | N | 12 | 2 | Dif.de ICMS | @E 999,999,999.99 | S | |||||
| VEC_SDOC | C | 3 | 0 | Serie Doc. | !!! | R | S | ||||
| VEC_SDOCOR | C | 3 | 0 | Serie Origem | !!! | R | S | ||||