| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| VS3 | Itens de Orcamento (Pecas) | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| VS3_FILIAL | C | 2 | 0 | Filial | S | ||||||
| VS3_SEQINC | C | 3 | 0 | Seq. Inconv. | @! | R | S | ||||
| VS3_GRUINC | C | 3 | 0 | Grupo Incon. | @!S3 | FG_Seek("VSK","VV1->VV1_CODMAR+M->VS3_GRUINC",1,.f.) | VSK | V | S | ||
| VS3_CODINC | C | 8 | 0 | Cod. Incon. | @! | FG_Seek("VSL","VV1->VV1_CODMAR+M->VS3_GRUINC+M->VS3_CODINC",1,.f.) | VSL | V | S | ||
| VS3_DESINC | C | 120 | 0 | Descr Inconv | @!S30 | V | S | ||||
| VS3_SEQUEN | C | 3 | 0 | Sequencia | @! | FS_VALSEQ() | R | S | |||
| VS3_GRUITE | C | 4 | 0 | Grupo Item | @!S4 | VAZIO() .OR. FG_Seek("SBM","M->VS3_GRUITE",1,.F.).and.If(M->VS1_TIPORC == "2",FG_GRUTEM(M->VS1_TIPTEM),.T.) | BM2 | S | |||
| VS3_KEYALT | C | 27 | 0 | Cod Alternat | @! | V | S | ||||
| VS3_CODITE | C | 27 | 0 | Codigo Item | @! | OFIOA520C().AND.(FG_POSSB1("M->VS3_CODITE","SB1->B1_CODITE","M->VS3_GRUITE")).and.FS_BATUGRP().and.FS_VERPEC().AND.OFXX01V2UM() | B07 | R | S | ||
| VS3_NUMORC | C | 8 | 0 | Nro Orcam/o | @ 99999999 | S | |||||
| VS3_DESITE | C | 30 | 0 | Descricao | @!S40 | V | S | ||||
| VS3_CODSIT | C | 2 | 0 | Cod Situacao | @! | FG_Seek("V09","M->VS3_CODSIT",1,.F.) | V09 | S | |||
| VS3_QTDEST | N | 10 | 2 | Qtd. Estoque | @E 9,999,999.99 | V | S | ||||
| VS3_SITTRI | C | 3 | 0 | Sit.Trib. | @! | R | S | ||||
| VS3_QTDITE | N | 10 | 2 | Qtd Requisit | @E 9,999,999.99 | FS_TOTPEC() .and. VALPMOD020( M->VS3_GRUITE ,M->VS3_CODITE ,M->VS3_QTDITE,"1", "1") | R | S | |||
| VS3_VALPEC | N | 12 | 2 | Vl Peca | @E 999,999,999.99 | FS_TOTPEC() | R | S | |||
| VS3_QTD2UM | N | 10 | 2 | 2a Un Medida | @E 9,999,999.99 | FS_TOTPEC() | R | S | |||
| VS3_PERDES | N | 6 | 2 | % Desc | @E 999.99 | POSITIVO().AND.FS_TOTPEC() | S | ||||
| VS3_VALDES | N | 12 | 2 | Vl Desconto | @E 999,999,999.99 | Positivo().and.FS_TOTPEC() | S | ||||
| VS3_VALTOT | N | 12 | 2 | Vl Total | @E 999,999,999.99 | S | |||||
| VS3_FORMUL | C | 6 | 0 | Formula | @! | FG_STRZERO("M->VS3_FORMUL",6).and.FG_Seek("VEG","M->VS3_FORMUL").and.VEG->VEG_GRUFOR==cGruFor.and.FS_PRECPO("P",2) | VEG | S | |||
| VS3_MODVEI | C | 30 | 0 | Mod Veiculo | @! | FG_SEEK("VV2","M->VS1_CODMAR+M->VS3_MODVEI",1,.F.) | VV2 | S | |||
| VS3_ARMORI | C | 2 | 0 | Arm. origem | @! | R | M->VS1_TIPORC == "3" | N | |||
| VS3_VBAICM | N | 12 | 2 | Vl Base ICM | @E 999,999,999.99 | S | |||||
| VS3_QTDPED | N | 10 | 2 | Qtd.Pedido | @E 9,999,999.99 | R | S | ||||
| VS3_QTDATE | N | 8 | 2 | Qtd.Atendida | @E 99999.99 | R | S | ||||
| VS3_QTDELI | N | 10 | 2 | Qt.Eliminada | @E 9,999,999.99 | R | S | ||||
| VS3_QTDAGU | N | 10 | 2 | Qtd.Aguard. | @E 9,999,999.99 | R | S | ||||
| VS3_QTDTRA | N | 10 | 2 | Qt.Agrd.Trf. | @E 9,999,999.99 | R | S | ||||
| VS3_ALIICM | N | 6 | 2 | Aliquota ICM | @E 999.99 | Positivo() | S | ||||
| VS3_ICMCAL | N | 12 | 2 | ICM Calcul | @E 999,999,999.99 | S | |||||
| VS3_CODTES | C | 3 | 0 | T.E.S. | @! | FG_Seek("SF4","M->VS3_CODTES",1,.f.).and.FS_TOTPEC().and. MaAvalTes("S",M->VS3_CODTES) .and. FS_OFM430OPER() | SF4 | S | |||
| VS3_QTDRES | N | 10 | 2 | Qtd Reservad | @E 9,999,999.99 | R | S | ||||
| VS3_CODKIT | C | 27 | 0 | Codigo Kit | @! | S | |||||
| VS3_CONBAR | C | 1 | 0 | Conferencia | R | N | |||||
| VS3_LOCAL | C | 2 | 0 | Armazem | @! | R | S | ||||
| VS3_GRUKIT | C | 4 | 0 | Grupo Kit | @! | S | |||||
| VS3_DTNFFB | D | 8 | 0 | Data NF Fab | R | S | |||||
| VS3_NOTFAB | C | 6 | 0 | NF Fabrica | @! | R | S | ||||
| VS3_PIPIFB | N | 5 | 2 | % IPI Fab | @E 99.99 | R | S | ||||
| VS3_VIPIFB | N | 11 | 2 | Vl IPI Fab | @E 99,999,999.99 | R | S | ||||
| VS3_PICMFB | N | 5 | 2 | % ICM Fab | @E 99.99 | R | S | ||||
| VS3_QTDINI | N | 10 | 2 | Qtd.Inicial | @E 9,999,999.99 | FS_OFM430OPER() | R | S | |||
| VS3_QTDCON | N | 10 | 2 | Qtd.Conferid | @E 9,999,999.99 | R | S | ||||
| VS3_VICMFB | N | 11 | 2 | Vl ICM Fab | @E 99,999,999.99 | R | S | ||||
| VS3_PICMSB | N | 5 | 2 | % ICM Sub | @E 99.99 | R | S | ||||
| VS3_VICMSB | N | 11 | 2 | Vl ICM Sub | @E 99,999,999.99 | R | S | ||||
| VS3_NUMIDE | C | 6 | 0 | Etiq. Ident | @! | R | S | ||||
| VS3_ITESUB | C | 27 | 0 | Cod. Ite Sub | @! | FS_TOTPEC() | R | S | |||
| VS3_OPER | C | 2 | 0 | Tip Operacao | @! | Existcpo("SX5","DJ"+M->VS3_OPER) .and. FS_OFM430OPER() | DJ | R | S | ||
| VS3_BASPIS | N | 14 | 2 | Base PIS | @E 99,999,999,999.99 | R | S | ||||
| VS3_BASCOF | N | 14 | 2 | Base COFINS | @E 99,999,999,999.99 | R | S | ||||
| VS3_VALPIS | N | 14 | 2 | Valor PIS | @E 99,999,999,999.99 | R | S | ||||
| VS3_LOTECT | C | 10 | 0 | Lote | FG_RASTRO(M->VS3_GRUITE,M->VS3_CODITE,M->VS3_QTDITE,M->VS3_LOTECT,M->VS3_NUMLOT) | R | S | ||||
| VS3_VALCOF | N | 14 | 2 | Valor COFINS | @E 99,999,999,999.99 | R | S | ||||
| VS3_NUMLOT | C | 6 | 0 | Sub-Lote | @! | FG_RASTRO(M->VS3_GRUITE,M->VS3_CODITE,M->VS3_QTDITE,M->VS3_LOTECT,M->VS3_NUMLOT) | R | S | |||
| VS3_ALQPIS | N | 14 | 2 | Aliq. PIS | @E 99,999,999,999.99 | R | S | ||||
| VS3_ALQCOF | N | 14 | 2 | Aliq.Cofins | @E 99,999,999,999.99 | R | S | ||||
| VS3_DTVALI | D | 8 | 0 | Valid. Lote | R | S | |||||
| VS3_LOCALI | C | 15 | 0 | Localizacao | @! | VldLocaliz( "O011" ) | SBE | R | S | ||
| VS3_BICMSB | N | 12 | 2 | Base ICMS Re | @E 999,999,999.99 | R | S | ||||
| VS3_NUMSER | C | 20 | 0 | Num.Serie | @! | FG_RASTRO(M->VS3_GRUITE,M->VS3_CODITE,M->VS3_QTDITE,M->VS3_LOTECT,M->VS3_NUMLOT,M->VS3_NUMSER) | R | S | |||
| VS3_MARLUC | N | 7 | 2 | Marg.Lucro | @E 9999.99 | R | S | ||||
| VS3_TESENT | C | 3 | 0 | Tes Entrada | @! | FG_Seek("SF4","M->VS3_TESENT",1,.f.).and.FS_TOTPEC() .and. MaAvalTes("E",M->VS3_TESENT) .and. FS_OFM430OPER() | SF4 | R | If(FunName()<>"OFIOM430",M->VS1_TIPORC == "3",.t.) | S | |
| VS3_VALLIQ | N | 14 | 4 | Vl Peca Liq | @E 999,999,999.9999 | R | S | ||||
| VS3_TESSAI | C | 3 | 0 | Tes Saida | @! | FG_Seek("SF4","M->VS3_TESSAI",1,.f.).and.FS_TOTPEC().and. MaAvalTes("S",M->VS3_TESSAI) .and. FS_OFM430OPER() | SF4 | R | If(FunName()<>"OFIOM430",M->VS1_TIPORC == "3",.t.) | S | |
| VS3_DEPGAR | C | 1 | 0 | Depto Garant | @! | Vazio() .or. FG_Seek("SX5","'VF'+M->VS3_DEPGAR",1,.f.) | VF | R | S | ||
| VS3_DEPINT | C | 1 | 0 | Depto Intern | @! | Vazio() .or. FG_Seek("SX5","'VD'+M->VS3_DEPINT",1,.f.) | VD | R | S | ||
| VS3_DOCSDB | C | 9 | 0 | Num.Doc. SDB | @! | R | S | ||||
| VS3_PECKIT | C | 1 | 0 | Peca Kit | @! | Pertence("01") | R | 0=Nao;1=Sim | S | ||
| VS3_MOTPED | C | 6 | 0 | MotivoCancel | @! | VS0 | R | S | |||
| VS3_QESTNA | N | 10 | 2 | Estoque N.A. | @E 9,999,999.99 | R | S | ||||
| VS3_FLGNAT | C | 1 | 0 | Flag Niv Ate | @! | PERTENCE("01") | R | 0=Nao Lido;1=Lido | S | ||
| VS3_RESERV | C | 1 | 0 | Reserva Peca | @! | Pertence("01") | R | 0=Nao;1=Sim | S | ||
| VS3_DESMOT | C | 40 | 0 | Descr Motivo | @! | V | S | ||||
| VS3_CENCUS | C | 9 | 0 | Centro Custo | @! | (Vazio() .or. Ctb105CC()) | CTT | M->VS1_TIPORC != "2" | S | ||
| VS3_CONTA | C | 20 | 0 | C Contabil | @! | (Vazio() .or. Ctb105CTA()) | CT1 | M->VS1_TIPORC != "2" | S | ||
| VS3_ITEMCT | C | 9 | 0 | Item Conta | @! | (Vazio() .or. Ctb105ITEM()) | CTD | M->VS1_TIPORC != "2" | S | ||
| VS3_CLVL | C | 9 | 0 | Classe Valor | @! | (Vazio() .or. Ctb105CLVL()) | CTH | M->VS1_TIPORC != "2" | S | ||
| VS3_IMPRES | C | 1 | 0 | Impresso | @! | Pertence("01") | R | 0=Nao;1=Sim | S | ||
| VS3_VALCMP | N | 12 | 2 | ICMS Compl. | @E 999,999,999.99 | S | |||||
| VS3_DIFAL | N | 12 | 2 | Dif.de ICMS | @E 999,999,999.99 | S | |||||
| VS3_PEDXML | C | 15 | 0 | NroPedCli | @! | S | |||||
| VS3_ITEXML | C | 6 | 0 | ItePedCli | @! | S | |||||
| VS3_FCICOD | C | 36 | 0 | Cod. FCI | @! | S | |||||
| VS3_QTDAPR | N | 10 | 4 | Qtd.Aprovada | @E 99999.9999 | R | S | ||||
| VS3_TIPTRA | C | 1 | 0 | Tipo Transf. | @! | Pertence("0123") | R | 0=Avulsa;1=Reposicao;2=Devolucao;3=Garantia | S | ||
| VS3_VENTRA | C | 6 | 0 | Vend.Transf. | @! | R | S | ||||
| VS3_LOCPRO | C | 15 | 0 | Locacao | @! | V | S | ||||
| VS3_TRSFER | C | 1 | 0 | Transf. DPM? | @! | R | 0=Nao;1=Sim | S | |||
| VS3_PROMOC | C | 1 | 0 | Promocao ? | @! | Pertence("01") | R | 0=Nao;1=Sim | S | ||