| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| VSY | Aval de Venda de Pecas P/Fecto | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| VSY_FILIAL | C | 2 | 0 | Filial | S | ||||||
| VSY_NUMORC | C | 8 | 0 | Nro Orcamto | @E 99999999 | S | |||||
| VSY_NUMIDE | C | 8 | 0 | Nro Identif. | @! | S | |||||
| VSY_GRUITE | C | 4 | 0 | Grupo | @!S4 | S | |||||
| VSY_CODITE | C | 27 | 0 | Cod Item | @!S27 | S | |||||
| VSY_QTDITE | N | 10 | 2 | Quantidade | @E 9,999,999.99 | S | |||||
| VSY_VALBRU | N | 14 | 2 | Vlr Bruto | @ez 999,999,999.99 | S | |||||
| VSY_VMFBRU | N | 14 | 2 | Vlr Bruto MF | @ez 999,999,999.99 | S | |||||
| VSY_VALDES | N | 14 | 2 | Vlr Desconto | @ez 999,999,999.99 | S | |||||
| VSY_VALVDA | N | 14 | 2 | Vlr da Venda | @ez 999,999,999.99 | S | |||||
| VSY_VMFDES | N | 14 | 2 | Vlr Desc MF | @ez 999,999,999.99 | S | |||||
| VSY_VMFVDA | N | 14 | 2 | Vlr Vda MF | @ez 999,999,999.99 | S | |||||
| VSY_TOTIMP | N | 14 | 2 | Tt Impostos | @ez 999,999,999.99 | S | |||||
| VSY_TMFIMP | N | 14 | 2 | Tt Impost MF | @ez 999,999,999.99 | S | |||||
| VSY_VALFRE | N | 14 | 2 | Frete | @E 999,999,999.99 | S | |||||
| VSY_VALSEG | N | 14 | 2 | Seguro | @E 99,999,999,999.99 | S | |||||
| VSY_VMFFRE | N | 14 | 2 | Frete MF | @E 99,999,999,999.99 | S | |||||
| VSY_VMFSEG | N | 14 | 2 | Seguro MF | @E 99,999,999,999.99 | S | |||||
| VSY_VALICM | N | 14 | 2 | Vl do ICMS | @E 99,999,999,999.99 | S | |||||
| VSY_DESACE | N | 14 | 2 | Desp.Acessor | @E 99,999,999,999.99 | R | S | ||||
| VSY_DMFACE | N | 14 | 2 | Desp.Aces MF | @E 99,999,999,999.99 | R | S | ||||
| VSY_VMFICM | N | 14 | 2 | Vl ICMS MF | @E 99,999,999,999.99 | S | |||||
| VSY_ALQICM | N | 5 | 2 | Aliq. ICMS | @E 99.99 | S | |||||
| VSY_VALIPI | N | 14 | 2 | Valor IPI MF | @E 99,999,999,999.99 | R | S | ||||
| VSY_ICMSRT | N | 14 | 2 | ICMS Retido | @E 99,999,999,999.99 | R | S | ||||
| VSY_VALPIS | N | 14 | 2 | Vl do PIS | @E 99,999,999,999.99 | S | |||||
| VSY_IMFSRT | N | 14 | 2 | ICMS Ret MF | @E 99,999,999,999.99 | R | S | ||||
| VSY_VMFPIS | N | 14 | 2 | Vl do PIS MF | @E 99,999,999,999.99 | S | |||||
| VSY_VALCOF | N | 14 | 2 | Vl do COFINS | @E 99,999,999,999.99 | S | |||||
| VSY_VMFCOF | N | 14 | 2 | Vl COFINS MF | @E 99,999,999,999.99 | S | |||||
| VSY_CUSTOT | N | 14 | 2 | Custo Total | @E 99,999,999,999.99 | S | |||||
| VSY_CMFTOT | N | 14 | 2 | Custo Tot MF | @E 99,999,999,999.99 | S | |||||
| VSY_CUSMED | N | 14 | 2 | Custo Medio | @E 99,999,999,999.99 | S | |||||
| VSY_CMFMED | N | 14 | 2 | Custo Med MF | @E 99,999,999,999.99 | S | |||||
| VSY_JUREST | N | 14 | 2 | Jrs Estoque | @E 99,999,999,999.99 | S | |||||
| VSY_JMFEST | N | 14 | 2 | Jrs Estq MF | @E 99,999,999,999.99 | S | |||||
| VSY_LUCBRU | N | 14 | 2 | Lucro Bruto | @E 99,999,999,999.99 | S | |||||
| VSY_LMFBRU | N | 14 | 2 | Luc Bruto MF | @E 99,999,999,999.99 | S | |||||
| VSY_DESVAR | N | 14 | 2 | Dsp Variavel | @E 99,999,999,999.99 | S | |||||
| VSY_DMFVAR | N | 14 | 2 | Dsp Var MF | @E 99,999,999,999.99 | S | |||||
| VSY_COMVEN | N | 14 | 2 | Com Vendedor | @E 99,999,999,999.99 | S | |||||
| VSY_CMFVEN | N | 14 | 2 | Com Vend MF | @E 99,999,999,999.99 | S | |||||
| VSY_COMGER | N | 14 | 2 | Com Gerencia | @E 99,999,999,999.99 | S | |||||
| VSY_CMFGER | N | 14 | 2 | Com Ger MF | @E 99,999,999,999.99 | S | |||||
| VSY_LUCLIQ | N | 14 | 2 | Lucro Liquid | @E 99,999,999,999.99 | S | |||||
| VSY_LMFLIQ | N | 14 | 2 | Lucro Liq MF | @E 99,999,999,999.99 | S | |||||
| VSY_DESFIX | N | 14 | 2 | Despesa Fixa | @E 99,999,999,999.99 | S | |||||
| VSY_DMFFIX | N | 14 | 2 | Dsp Fixa MF | @E 99,999,999,999.99 | S | |||||
| VSY_CUSFIX | N | 14 | 2 | Custo Fixo | @E 99,999,999,999.99 | S | |||||
| VSY_CMFFIX | N | 14 | 2 | Custo Fxo MF | @E 99,999,999,999.99 | S | |||||
| VSY_DESDEP | N | 14 | 2 | Desp Depto | @E 99,999,999,999.99 | S | |||||
| VSY_DMFDEP | N | 14 | 2 | Dsp Depto MF | @E 99,999,999,999.99 | S | |||||
| VSY_DESADM | N | 14 | 2 | Desp Admin | @E 99,999,999,999.99 | S | |||||
| VSY_DMFADM | N | 14 | 2 | Dsp Admin MF | @E 99,999,999,999.99 | S | |||||
| VSY_RESFIN | N | 14 | 2 | Result Final | @E 99,999,999,999.99 | S | |||||
| VSY_RMFFIN | N | 14 | 2 | Resul Fin MF | @E 99,999,999,999.99 | S | |||||
| VSY_BALOFI | C | 1 | 0 | Balcao/Ofic | ! | S | |||||
| VSY_DEPVEN | C | 1 | 0 | Depto Venda | @! | S | |||||
| VSY_TIPTEM | C | 4 | 0 | Tpo de Tempo | @! | S | |||||
| VSY_DATVEN | D | 8 | 0 | Dt da Venda | S | ||||||
| VSY_SERNFI | C | 3 | 0 | Serie NFisc | @! | S | |||||
| VSY_ICMSST | N | 14 | 2 | ICMS ST | @E 99,999,999,999.99 | R | S | ||||
| VSY_NUMNFI | C | 9 | 0 | Nro NFiscal | @! | S | |||||
| VSY_NUMOSV | C | 8 | 0 | Nro Ord Srvc | @ 99999999 | S | |||||
| VSY_IMFSST | N | 14 | 2 | ICMS MF ST | @E 99,999,999,999.99 | R | S | ||||
| VSY_DCLBST | N | 14 | 2 | D/C ST | @E 99,999,999,999.99 | R | S | ||||
| VSY_NUMREL | C | 8 | 0 | Nr Rel Pecas | @ 99999999 | S | |||||
| VSY_DMFBST | N | 14 | 2 | D/C LB ST | @E 99,999,999,999.99 | R | S | ||||
| VSY_CODMAR | C | 3 | 0 | Marca | @!S3 | S | |||||
| VSY_PECINT | C | 15 | 0 | Cod Int Peca | @! | S | |||||
| VSY_COPIST | N | 14 | 2 | CRED ICM ST | @E 99,999,999,999.99 | R | S | ||||
| VSY_CMFIST | N | 14 | 2 | Cred OP ST | @E 99,999,999,999.99 | R | S | ||||
| VSY_VMFIPI | N | 14 | 2 | Valor IPI MF | @E 99,999,999,999.99 | R | S | ||||
| VSY_LIBVOO | C | 8 | 0 | Num. Lib. TT | R | S | |||||
| VSY_VALCMP | N | 12 | 2 | ICMS Compl. | @E 999,999,999.99 | S | |||||
| VSY_DIFAL | N | 12 | 2 | Dif.de ICMS | @E 999,999,999.99 | S | |||||
| VSY_SDOC | C | 3 | 0 | Serie Doc. | !!! | R | S | ||||