| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| VMC | Garantia JD itens | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| VMC_FILIAL | C | 2 | 0 | Filial | S | ||||||
| VMC_CODGAR | C | 8 | 0 | Cod.Garantia | @! | R | S | ||||
| VMC_SEQGAR | C | 3 | 0 | Seq Item Gar | @! | R | S | ||||
| VMC_TIPOPS | C | 1 | 0 | Tipo Reg. | @! | Pertence("PSO") | R | P=Pecas;S=Servicos;O=Outros Creditos | S | ||
| VMC_TIPTEM | C | 4 | 0 | Tipo Tempo | @! | R | S | ||||
| VMC_LIBVOO | C | 8 | 0 | Num. Lib. TT | @! | R | S | ||||
| VMC_GRUITE | C | 4 | 0 | Grupo Peca | @! | OFNJD15VLG() | R | M->VMC_TIPOPS=="P" | S | ||
| VMC_CODITE | C | 27 | 0 | Codigo Peca | @! | OFNJD15VLG() | R | M->VMC_TIPOPS=="P" | S | ||
| VMC_DESCRI | C | 30 | 0 | Descricao | @! | V | S | ||||
| VMC_PARTNO | C | 18 | 0 | Cod. Peca F. | @! | R | S | ||||
| VMC_UM | C | 2 | 0 | Unidade | @! | ExistCpo("SAH") | R | M->VMC_TIPOPS=="P" | S | ||
| VMC_QTDPEC | N | 15 | 3 | Qtde | @E 99,999,999,999.999 | R | M->VMC_TIPOPS=="P" | S | |||
| VMC_QPCRET | N | 15 | 3 | Qtde Ret. | @E 99,999,999,999.999 | R | S | ||||
| VMC_VUPECE | N | 15 | 4 | Vl. Unit. | @E 9,999,999,999.9999 | R | M->VMC_TIPOPS=="P" | S | |||
| VMC_VUPECR | N | 15 | 4 | Vl. Unit. Re | @E 9,999,999,999.9999 | R | S | ||||
| VMC_VTPECE | N | 15 | 2 | Vl. Total | @E 999,999,999,999.99 | R | M->VMC_TIPOPS=="P" | S | |||
| VMC_VTPECR | N | 15 | 2 | Vl. Total Re | @E 999,999,999,999.99 | R | S | ||||
| VMC_ADITIV | N | 15 | 2 | Vl. Aditivo | @E 999,999,999,999.99 | R | S | ||||
| VMC_SERINO | C | 18 | 0 | Serial No | @! | R | M->VMC_TIPOPS=="P" | S | |||
| VMC_MEDALT | C | 4 | 0 | Un. Med. Alt | @! | R | M->VMC_TIPOPS=="P" | S | |||
| VMC_EXCODE | C | 1 | 0 | Cod. Troca | @! | Vazio() .or. ExistCPO("VX5","029"+M->VMB_EXCODE) | R | S | |||
| VMC_EXCODD | C | 30 | 0 | Descr. Troca | @! | V | S | ||||
| VMC_GRUSER | C | 2 | 0 | Grupo Serv. | @! | R | M->VMC_TIPOPS $ "S/O" | S | |||
| VMC_CODSER | C | 15 | 0 | Cod. Servico | @! | R | M->VMC_TIPOPS $ "S/O" | S | |||
| VMC_TIPTRA | C | 18 | 0 | Tp Trabalho | @! | OFNJD15VLG() | VX5 | R | M->VMC_TIPOPS=="S" | S | |
| VMC_TIPTRD | C | 30 | 0 | Descricao | @! | V | M->VMC_TIPOPS=="S" | S | |||
| VMC_LOCTRA | C | 4 | 0 | Local Trab | @! | Vazio() .or. FG_Seek("VX5","'018'+M->VMC_LOCTRA",1,.F.) | R | #OFIOA560CB("018",4) | M->VMC_TIPOPS=="S" | S | |
| VMC_QTDTRA | N | 15 | 3 | Horas Trab. | @E 99,999,999,999.999 | R | M->VMC_TIPOPS=="S" | S | |||
| VMC_QSRRET | N | 15 | 3 | Horas Ret. | @E 99,999,999,999.999 | R | S | ||||
| VMC_VALHRE | N | 6 | 2 | Vl. Hora | @E 999.99 | R | M->VMC_TIPOPS=="S" | S | |||
| VMC_VALHRR | N | 6 | 2 | Vl. Hora Re. | @E 999.99 | R | S | ||||
| VMC_VTSERE | N | 10 | 2 | Vl. Total | @E 9,999,999.99 | R | S | ||||
| VMC_VTSERR | N | 10 | 2 | Vl. Total Re | @E 9,999,999.99 | R | S | ||||
| VMC_SPGKEY | C | 40 | 0 | Chave SPG | @! | R | M->VMC_TIPOPS=="S" | S | |||
| VMC_TECHID | C | 20 | 0 | Tech ID | @! | R | M->VMC_TIPOPS=="S" | S | |||
| VMC_CODMAT | C | 18 | 0 | Cod Material | @! | OFNJD15VLG() | VX5 | R | M->VMC_TIPOPS=="O" | S | |
| VMC_CODMAD | C | 30 | 0 | Descricao | @! | R | M->VMC_TIPOPS=="O" | S | |||
| VMC_CUSMAT | N | 15 | 2 | Custo | @E 999,999,999,999.99 | R | M->VMC_TIPOPS=="O" | S | |||
| VMC_CUSMAR | N | 15 | 2 | Custo Ret. | @E 999,999,999,999.99 | R | S | ||||
| VMC_COMENT | C | 254 | 0 | Comentario | R | S | |||||
| VMC_ORIGEM | C | 1 | 0 | Origem Reg. | @! | Vazio() .or. Pertence("123") | R | 1=Fabrica;2=Manual;3=Proc. Retorno | S | ||