| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| VG8 | Dados da Rr de Garantia | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| VG8_FILIAL | C | 2 | 0 | Filial | S | ||||||
| VG8_NUMOSV | C | 8 | 0 | Numero da OS | @!S8 | VO1 | R | S | |||
| VG8_CODMAR | C | 3 | 0 | Marca | @!S3 | FG_Seek("VE1","M->VG8_CODMAR",1,.f.,"VG8_DESMAR","VE1_DESMAR") .AND. IIf(Funname()=="OFIGM070",FS_CHECMAR() .AND. FS_CHEGMF(),) | VE1 | R | S | ||
| VG8_DESMAR | C | 30 | 0 | Descricao | @!S30 | V | S | ||||
| VG8_ANORRC | C | 4 | 0 | Ano da RR | @!S4 | FG_Seek("VG4","M->VG8->ANORRC",1,.f.) | R | S | |||
| VG8_NUMRRC | C | 7 | 0 | Numero da RR | @!S7 | FG_Strzero("M->VG8_NUMRRC",7,.F.) .and. ExistChav("VG8",M->VG8_CODMAR+M->VG8_ANORRC+M->VG8_NUMRRC,1,"EXINUMRRC") | VG4 | R | S | ||
| VG8_CHAINT | C | 6 | 0 | Cod.Int.Chas | @!S6 | FG_Seek("VV1","M->VG8_CHAINT",1,.f.,"VG8_CHASSI","VV1_CHASSI") | R | S | |||
| VG8_CHASSI | C | 25 | 0 | Chassi | @!S25 | FG_Seek("VV1","M->VG8_CHASSI",2,.f.,"VG8_CHAINT","VV1_CHAINT") | R | S | |||
| VG8_ABEGAR | D | 8 | 0 | Abert.Garan. | M->VG8_ABEGAR==DataValida(M->VG8_ABEGAR) | R | S | ||||
| VG8_DATDIS | D | 8 | 0 | Dta.Disponib | R | S | |||||
| VG8_KILGAR | N | 6 | 0 | KM/Hora | @E 999,999 | M->VG8_KILGAR>0 | R | S | |||
| VG8_NF1REM | C | 9 | 0 | NF Remessa 1 | @9 | R | S | ||||
| VG8_NF2REM | C | 9 | 0 | NF Remessa 2 | @! | S | |||||
| VG8_GRUSER | C | 2 | 0 | Grupo Servic | @!S2 | FG_StrZero("M->VG8_GRUSER",2).and.FG_Seek("VOS","M->VG8_CODMAR+M->VG8_GRUSER",1,.f.,"VG8_DESGRS","VOS_DESGRU") | VOS | R | S | ||
| VG8_DESGRS | C | 30 | 0 | Descricao | @!S30 | V | S | ||||
| VG8_CODSER | C | 15 | 0 | Cod Servico | @!S15 | FG_Seek("VO6","FG_MARSRV(M->VG8_CODMAR)+M->VG8_CODSER",2,.f.,"VG8_DESSER","VO6_DESSER") | V6O | R | S | ||
| VG8_DESSER | C | 30 | 0 | Descricao | @!S30 | V | S | ||||
| VG8_SERINT | C | 6 | 0 | Cod.Serv.Int | @!S6 | R | S | ||||
| VG8_GRUITE | C | 4 | 0 | Grupo Item | @!S4 | FG_Seek("SBM","M->VG8_GRUITE",1,.f.,"VG8_DESGRU","BM_DESC") | E05 | R | S | ||
| VG8_DESGRU | C | 30 | 0 | Descricao | @!S30 | V | S | ||||
| VG8_ITECAU | C | 27 | 0 | ItemCausador | @!S27 | FG_Seek("SB1","M->VG8_GRUITE+M->VG8_ITECAU",7,.f.,"VG8_DESITE","B1_DESC") | B06 | R | S | ||
| VG8_DESITE | C | 30 | 0 | Desc. Item | @!S30 | V | S | ||||
| VG8_PECINT | C | 15 | 0 | Cod.Int.Peca | @!S15 | R | S | ||||
| VG8_CODDEF | C | 3 | 0 | Cod. Defeito | @!S3 | FS_INFNUM(M->VG8_CODDEF) .AND. FG_Seek("VG0","M->VG8_CODMAR+M->VG8_CODDEF",1,.f.,"VG8_DESDEF","VG0_DESDEF") | XG0 | R | S | ||
| VG8_DESDEF | C | 15 | 0 | Desc.Defeito | @!S15 | V | S | ||||
| VG8_SERCON | N | 9 | 0 | Serie Conju. | @E 999,999,999 | R | S | ||||
| VG8_TIPCON | C | 10 | 0 | Tip.Conjunto | @!S10 | R | S | ||||
| VG8_CODCAM | N | 6 | 0 | Cod.Campanha | @E 999,999 | R | S | ||||
| VG8_CAMTIP | C | 2 | 0 | Tipo de Camp | @! | Vazio() .or. Pertence("RA,TC,RC") | R | RA=Acao Recomendada;TC=Campanha Tecnica;RC=Recall | S | ||
| VG8_CODREC | C | 1 | 0 | Tipo Produto | @!S1 | FG_Seek("VG3","M->VG8_CODMAR+M->VG8_CODREC",1,.f.,"VG8_DESREC","VG3_DESREC") | VG3 | R | S | ||
| VG8_DESREC | C | 15 | 0 | Desc.Produto | @!S15 | V | S | ||||
| VG8_CODGAR | C | 5 | 0 | Cod.Garantia | @!S5 | FG_Seek("VG1","M->VG8_CODMAR+M->VG8_CODGAR",1,.f.,"VG8_DESGAR","VG1_DESGAR") | XG1 | R | S | ||
| VG8_DESGAR | C | 15 | 0 | Dsc.Garantia | @!S15 | V | S | ||||
| VG8_TESCPO | N | 6 | 0 | Teste Campo | @E 999,999 | R | S | ||||
| VG8_KILPIC | N | 7 | 0 | KM Pick Up | @E 9,999,999 | R | S | ||||
| VG8_KILGUI | N | 7 | 0 | KM Guincho | @E 9,999,999 | R | S | ||||
| VG8_VEIEXP | C | 1 | 0 | Veic. Export | @!S1 | Pertence("01") | R | 0=Nao;1=Sim | S | ||
| VG8_RECONS | C | 1 | 0 | Reconsiderac | @!S1 | Pertence("01") | R | 0=Nao;1=Sim | S | ||
| VG8_MOTREC | C | 177 | 0 | Motivo Recl. | @!S177 | NaoVazio() | S | ||||
| VG8_RRCOLD | C | 70 | 0 | RR Anterior | @!S70 | S | |||||
| VG8_RRCNEW | C | 70 | 0 | RR Nova | @!S70 | S | |||||
| VG8_CODCLI | C | 6 | 0 | Cod Cliente | @! | FG_Seek("SA1","M->VG8_CODCLI",1,.f.) | R | S | |||
| VG8_LOJA | C | 2 | 0 | Loja | @! | FG_Seek("SA1","M->VG8_CODCLI+M->VG8_LOJA",1,.f.,"VG8_NOMCLI","A1_NREDUZ") | R | S | |||
| VG8_NOMCLI | C | 20 | 0 | Nome | @!S20 | V | S | ||||
| VG8_VALITE | N | 12 | 2 | Vl.Item Tra. | @E 999,999,999.99 | IIf(Funname()=="OFIGM070",FG_CCVALOR() ,) | S | ||||
| VG8_PORAPC | N | 6 | 2 | % Ad Peca | @E 999.99 | FG_CCVALOR() | R | S | |||
| VG8_VLRAPC | N | 12 | 2 | Ad Peca | @E 999,999,999.99 | FG_CCVALOR() | R | S | |||
| VG8_VLPVLA | N | 12 | 2 | Tot Peca | @E 999,999,999.99 | V | S | ||||
| VG8_VALSER | N | 12 | 2 | Vl.Serv.Tra. | @E 999,999,999.99 | S | |||||
| VG8_VLKMCA | N | 12 | 2 | Valor Km | @E 999,999,999.99 | FG_CCVALOR() | R | S | |||
| VG8_VLRSET | N | 12 | 2 | Serv 3o | @E 999,999,999.99 | FG_CCVALOR() | R | S | |||
| VG8_TRANSM | C | 1 | 0 | Transmitida | @!S1 | S | |||||
| VG8_EXPGAR | C | 1 | 0 | Exporta | @!S1 | S | |||||
| VG8_DATTRA | D | 8 | 0 | Data Transm. | S | ||||||
| VG8_DATRET | D | 8 | 0 | Data Retorno | S | ||||||
| VG8_DESSIT | C | 120 | 0 | Descr.Situac | @!S120 | S | |||||
| VG8_ITEPGT | N | 12 | 2 | Vl.Item Pago | @E 999,999,999.99 | S | |||||
| VG8_SERPGT | N | 12 | 2 | Vl.Serv.Pago | @E 999,999,999.99 | S | |||||
| VG8_CUSESP | N | 12 | 2 | Vl.Cus.Esp. | @E 999,999,999.99 | R | S | ||||
| VG8_TPONCT | N | 12 | 2 | Vl.T.N.Cat. | @E 999,999,999.99 | R | S | ||||
| VG8_DATEST | D | 8 | 0 | Data Estorno | S | ||||||
| VG8_ITEEST | N | 12 | 2 | Vl.Item.Est. | @E 999,999,999.99 | S | |||||
| VG8_SEREST | N | 12 | 2 | Vl.Ser.Est. | @E 999,999,999.99 | S | |||||
| VG8_EXCLUI | C | 1 | 0 | Excluido | @!S1 | S | |||||
| VG8_OK | C | 2 | 0 | Iden.Selecao | R | S | |||||
| VG8_NFIENT | C | 9 | 0 | N.F.Entrada | @! | R | N | ||||
| VG8_SERENT | C | 3 | 0 | Ser. Entrada | !!! | R | N | ||||
| VG8_OBSERV | M | 100 | 0 | Observacao | @! | V | S | ||||
| VG8_OBSMEM | C | 6 | 0 | Oco-MEMO | S | ||||||
| VG8_SITRRC | C | 3 | 0 | Situacao RR | @!S3 | Vazio() .or. ExistCpo("SX5","86"+M->VG8_SITRRC) | S | ||||
| VG8_TTPKST | N | 12 | 2 | Total | @E 999,999,999.99 | V | S | ||||
| VG8_VLDACE | N | 12 | 2 | Busca | @E 999,999,999.99 | R | S | ||||
| VG8_MOTORE | N | 10 | 0 | Motor | @E 9,999,999,999 | R | S | ||||
| VG8_KILANT | N | 7 | 0 | Km Anterior | @E 9,999,999 | R | S | ||||
| VG8_TIPONF | C | 1 | 0 | TIPO DE NF | @! | R | 1=Garantia;2=Contrato;3=Acordo | S | |||
| VG8_DTAANT | D | 8 | 0 | Dt Repar Ant | R | S | |||||
| VG8_PRIREV | D | 8 | 0 | Dt 1 revisao | !empty(M->VG8_PRIREV) | R | S | ||||
| VG8_GDWILL | C | 7 | 0 | Goodwill | @! | R | S | ||||
| VG8_CODPLU | N | 8 | 0 | Cod. Plus | @E 99,999,999 | R | S | ||||
| VG8_REPANT | D | 8 | 0 | Dt. Rep. Ant | R | S | |||||
| VG8_LIBVOP | C | 8 | 0 | Lib. TT Peca | R | S | |||||
| VG8_LIBVOS | C | 8 | 0 | Lib. TT Srvc | R | S | |||||
| VG8_DATNFI | D | 8 | 0 | Data NF Rem. | R | S | |||||
| VG8_NUMNFI | C | 9 | 0 | Nro NFiscal | @! | R | S | ||||
| VG8_SERNFI | C | 3 | 0 | Serie NF | @!S3 | S | |||||
| VG8_DATCRE | D | 8 | 0 | Data Credito | S | ||||||
| VG8_NFCRED | C | 9 | 0 | NF Credito | @! | R | S | ||||
| VG8_SERNFC | C | 3 | 0 | Serie NF Crd | !!! | R | S | ||||
| VG8_WEBSIT | C | 1 | 0 | Trans. Web | @A | R | S | ||||
| VG8_VLMOCC | N | 12 | 2 | Mao Obra | @E 999,999,999.99 | R | S | ||||
| VG8_VLPECC | N | 12 | 2 | Peca | @E 999,999,999.99 | FG_CCVALOR() | R | S | |||
| VG8_POAPCC | N | 12 | 2 | % Ad Peca | @E 999,999,999.99 | R | S | ||||
| VG8_VRAPCC | N | 12 | 2 | Ad Peca | @E 999,999,999.99 | FG_CCVALOR() | R | S | |||
| VG8_VPVLAC | N | 12 | 2 | Tot Peca | @E 999,999,999.99 | V | S | ||||
| VG8_VKMCAC | N | 12 | 2 | Valor Km | @E 999,999,999.99 | FG_CCVALOR() | R | S | |||
| VG8_VRSETC | N | 12 | 2 | Serv 3o | @E 999,999,999.99 | FG_CCVALOR() | R | S | |||
| VG8_TPKSTC | N | 12 | 2 | Total | @E 999,999,999.99 | V | S | ||||
| VG8_CACREC | N | 10 | 0 | Carta Cred | @E 9,999,999,999 | R | S | ||||
| VG8_REGACO | C | 25 | 0 | Regiao | @! | R | S | ||||
| VG8_SDOCE | C | 3 | 0 | Ser.NF Entra | !!! | R | S | ||||
| VG8_SDOCS | C | 3 | 0 | Serie Doc. | !!! | R | S | ||||
| VG8_SDOCC | C | 3 | 0 | Serie NF Crd | !!! | R | S | ||||
| VG8_DTREPA | D | 8 | 0 | Dt. Reparo | R | S | |||||
| VG8_IDMODC | C | 100 | 0 | Id. Modulo | @! | R | S | ||||
| VG8_IDPLAM | C | 100 | 0 | Id. Plan. M. | @! | R | S | ||||
| VG8_CDTMOD | C | 20 | 0 | Cod. Tipo M. | @! | R | S | ||||
| VG8_KMPLAN | N | 8 | 0 | Km. Plan. | @E 99999999 | R | S | ||||