| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| VSC | Avaliacao de Venda de Servicos | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| VSC_FILIAL | C | 2 | 0 | Filial | S | ||||||
| VSC_NUMOSV | C | 8 | 0 | Nro Ord Srvc | @E 99999999 | S | |||||
| VSC_CODSER | C | 15 | 0 | Cod Servico | @!S15 | S | |||||
| VSC_TIPSER | C | 3 | 0 | Tipo Servico | @!S3 | S | |||||
| VSC_TIPTEM | C | 4 | 0 | Tpo de Tempo | @! | S | |||||
| VSC_KILROD | N | 8 | 0 | Km Rodado | @e 99,999,999 | S | |||||
| VSC_TEMPAD | N | 5 | 0 | Tpo Padrao | @R 999:99 | S | |||||
| VSC_TEMTRA | N | 5 | 0 | Tpo Aplicado | @R 999:99 | S | |||||
| VSC_TEMCOB | N | 5 | 0 | Tpo Cobrado | @R 999:99 | S | |||||
| VSC_TEMVEN | N | 5 | 0 | Tpo Vendido | @R 999:99 | S | |||||
| VSC_GRUSER | C | 2 | 0 | Grp Servico | @!S2 | S | |||||
| VSC_CODPRO | C | 6 | 0 | Produtivo | @!S6 | S | |||||
| VSC_CODSEC | C | 3 | 0 | Sec Oficina | @!S3 | FG_Seek("VOD","M->VO4_CODSEC",1,.f.,"VO4_DESSEC","VOD_DESSEC") | VOD | S | |||
| VSC_DATVEN | D | 8 | 0 | Dt da Venda | @D | S | |||||
| VSC_VALBRU | N | 14 | 2 | Vlr Bruto | @ez 999,999,999.99 | S | |||||
| VSC_VMFBRU | N | 14 | 2 | Vlr Bruto MF | @ez 999,999,999.99 | S | |||||
| VSC_VALDES | N | 14 | 2 | Vlr Desconto | @ez 999,999,999.99 | S | |||||
| VSC_VALSER | N | 14 | 2 | Vlr Servicos | @ez 999,999,999.99 | S | |||||
| VSC_VMFDES | N | 14 | 2 | Vl Descto MF | @E 99,999,999,999.99 | S | |||||
| VSC_VMFSER | N | 14 | 2 | Vlr Servs MF | @ez 999,999,999.99 | S | |||||
| VSC_TOTIMP | N | 14 | 2 | Tt Impostos | @ez 999,999,999.99 | S | |||||
| VSC_TMFIMP | N | 14 | 2 | Tt Imp MF | @ez 999,999,999.99 | S | |||||
| VSC_VALISS | N | 14 | 2 | Vl do ISS | @ez 999,999,999.99 | S | |||||
| VSC_VMFISS | N | 14 | 2 | Vl do ISS MF | @ez 999,999,999.99 | S | |||||
| VSC_VALPIS | N | 14 | 2 | Vl do PIS | @ez 999,999,999.99 | S | |||||
| VSC_VMFPIS | N | 14 | 2 | Vl do PIS MF | @ez 999,999,999.99 | S | |||||
| VSC_VALCOF | N | 14 | 2 | Vl do Cofins | @ez 999,999,999.99 | S | |||||
| VSC_VMFCOF | N | 14 | 2 | Vl Cofins MF | @ez 999,999,999.99 | S | |||||
| VSC_RECLIQ | N | 14 | 2 | Rec Liquida | @ez 999,999,999.99 | S | |||||
| VSC_RMFLIQ | N | 14 | 2 | Rec Liq MF | @ez 999,999,999.99 | S | |||||
| VSC_CUSTOT | N | 14 | 2 | Custo Total | @ez 999,999,999.99 | S | |||||
| VSC_CMFTOT | N | 14 | 2 | Custo Tot MF | @ez 999,999,999.99 | S | |||||
| VSC_CUSSER | N | 14 | 2 | Custo Srvcs | @ez 999,999,999.99 | S | |||||
| VSC_CMFSER | N | 14 | 2 | Custo Srv MF | @ez 999,999,999.99 | S | |||||
| VSC_LUCBRU | N | 14 | 2 | Lucro Bruto | @ez 999,999,999.99 | S | |||||
| VSC_LMFBRU | N | 14 | 2 | Luc Bruto MF | @ez 999,999,999.99 | S | |||||
| VSC_DESVAR | N | 14 | 2 | Dsp Variavel | @ez 999,999,999.99 | S | |||||
| VSC_DMFVAR | N | 14 | 2 | Dsp Var MF | @ez 999,999,999.99 | S | |||||
| VSC_COMVEN | N | 14 | 2 | Com Vendedor | @ez 999,999,999.99 | S | |||||
| VSC_CMFVEN | N | 14 | 2 | Com Vend MF | @ez 999,999,999.99 | S | |||||
| VSC_COMGER | N | 14 | 2 | Com Gerencia | @ez 999,999,999.99 | S | |||||
| VSC_CMFGER | N | 14 | 2 | Com Ger MF | @ez 999,999,999.99 | S | |||||
| VSC_CUSFIX | N | 14 | 2 | Custo Fixo | @ez 999,999,999.99 | S | |||||
| VSC_DESFIX | N | 14 | 2 | Despesa Fixa | @ez 999,999,999.99 | S | |||||
| VSC_DMFFIX | N | 14 | 2 | Dsp Fixa MF | @ez 999,999,999.99 | S | |||||
| VSC_CMFFIX | N | 14 | 2 | Custo Fxo MF | @ez 999,999,999.99 | S | |||||
| VSC_LUCLIQ | N | 14 | 2 | Lucro Liquid | @ez 999,999,999.99 | S | |||||
| VSC_LMFLIQ | N | 14 | 2 | Lucro Liq MF | @ez 999,999,999.99 | S | |||||
| VSC_DESADM | N | 14 | 2 | Dsp Administ | @ez 999,999,999.99 | S | |||||
| VSC_DESDEP | N | 14 | 2 | Desp Depto | @ez 999,999,999.99 | S | |||||
| VSC_DMFDEP | N | 14 | 2 | Dsp Depto MF | @ez 999,999,999.99 | S | |||||
| VSC_DMFADM | N | 14 | 2 | Dsp Adm MF | @ez 999,999,999.99 | S | |||||
| VSC_RESFIN | N | 14 | 2 | Result Final | @ez 999,999,999.99 | S | |||||
| VSC_RMFFIN | N | 14 | 2 | Res Final MF | @ez 999,999,999.99 | S | |||||
| VSC_SERINT | C | 6 | 0 | Cod Int Srvc | @ez 999,999,999.99 | S | |||||
| VSC_CODMAR | C | 3 | 0 | Marca | @!!! | S | |||||
| VSC_MODVEI | C | 30 | 0 | Modelo | @! | S | |||||
| VSC_SERNFI | C | 3 | 0 | Serie NFisc | @!!! | S | |||||
| VSC_NUMNFI | C | 9 | 0 | Nro NFiscal | @! | S | |||||
| VSC_DEPINT | C | 1 | 0 | Depto OS Int | @!S1 | Vazio() .or. FG_Seek("SX5","'VD'+M->VO4_DEPINT",1,.f.) | VD | VOI->VOI_DEPINT=="1" | S | ||
| VSC_DEPGAR | C | 1 | 0 | Depto Garant | @!S1 | Vazio() .or. FG_Seek("SX5","'VF'+M->VO4_DEPGAR",1,.f.) | VF | VOI->VOI_DEPGAR=="1" | S | ||
| VSC_RECVO4 | C | 9 | 0 | Recno VO4 | @e 999999999 | S | |||||
| VSC_NUMIDE | C | 10 | 0 | Nro Identif | @e 99999999 | S | |||||
| VSC_DESACE | N | 14 | 2 | Despesa | @E 99,999,999,999.99 | S | |||||
| VSC_DMFACE | N | 14 | 2 | Despesa MF | @E 99,999,999,999.99 | S | |||||
| VSC_VALFRE | N | 14 | 2 | Frete | @E 99,999,999,999.99 | S | |||||
| VSC_VMFFRE | N | 14 | 2 | frete mf | @E 99,999,999,999.99 | S | |||||
| VSC_VALSEG | N | 14 | 2 | Frete | @E 99,999,999,999.99 | S | |||||
| VSC_VMFSEG | N | 14 | 2 | Seguro MF | @E 99,999,999,999.99 | S | |||||
| VSC_LIBVOO | C | 8 | 0 | Num. Lib. TT | R | S | |||||
| VSC_PEDNUM | C | 6 | 0 | Num. Pedido | @x | R | S | ||||
| VSC_PEDITE | C | 2 | 0 | Item Pedido | @! | R | S | ||||
| VSC_ITENFI | C | 2 | 0 | Item NFiscal | @! | R | S | ||||
| VSC_CENCUS | C | 9 | 0 | Centro Custo | @! | (Vazio() .or. Ctb105CC()) | CTT | S | |||
| VSC_CONTA | C | 20 | 0 | C Contabil | @! | (Vazio() .or. Ctb105CTA()) | CT1 | S | |||
| VSC_ITEMCT | C | 9 | 0 | Item Conta | @! | (Vazio() .or. Ctb105ITEM()) | CTD | S | |||
| VSC_CLVL | C | 9 | 0 | Classe Valor | @! | (Vazio() .or. Ctb105CLVL()) | CTH | S | |||
| VSC_SDOC | C | 3 | 0 | Serie Doc. | !!! | R | S | ||||