Dicionário Protheus
Início

Tabela VG8 no Protheus

Dados da Rr de Garantia

O que é a tabela VG8 no Protheus?

A tabela VG8 faz parte do sistema ERP Protheus da TOTVS e é utilizada para dados da rr de garantia.

Ela pertence ao dicionário de dados do Protheus (SX2) e armazena informações essenciais utilizadas em processos como cadastros, movimentações e integrações do sistema.

A tabela VG8 possui diversos campos (SX3), cada um com regras específicas como tipo, tamanho e validações, além de índices (SIX) que otimizam a performance das consultas.

Nesta página você pode consultar a estrutura completa da tabela VG8, incluindo todos os campos e índices relacionados.

Propriedades da Tabela

Propriedade Valor
X2_CHAVE VG8
X2_PATH \DATA\
X2_ARQUIVO VG8990
X2_NOME Dados da Rr de Garantia
X2_NOMESPA Datos de Rr de Garantia
X2_NOMEENG Guarantee Rr Data
X2_ROTINA -
X2_MODO E
X2_MODOUN E
X2_MODOEMP E
X2_DELET 0
X2_TTS -
X2_UNICO VG8_FILIAL+VG8_CODMAR+VG8_NUMOSV+VG8_ANORRC+VG8_NUMRRC
X2_PYME S
X2_MODULO 14
X2_DISPLAY -
X2_SYSOBJ -
X2_USROBJ -
X2_POSLGT 1
X2_CLOB 2
X2_AUTREC 2
X2_TAMFIL 2
X2_TAMUN 0
X2_TAMEMP 0
X2_STAMP 2
X2_INSDT 2
D_E_L_E_T_ -
R_E_C_N_O_ 10434
R_E_C_D_E_L_ 0

Campos da Tabela VG8 (107 campos)

X3_ARQUIVO X3_ORDEM X3_CAMPO X3_TIPO X3_TAMANHO X3_DECIMAL X3_TITULO X3_TITSPA X3_TITENG X3_DESCRIC X3_DESCSPA X3_DESCENG X3_PICTURE X3_VALID X3_USADO X3_RELACAO X3_F3 X3_NIVEL X3_RESERV X3_CHECK X3_TRIGGER X3_PROPRI X3_BROWSE X3_VISUAL X3_CONTEXT X3_OBRIGAT X3_VLDUSER X3_CBOX X3_CBOXSPA X3_CBOXENG X3_PICTVAR X3_WHEN X3_INIBRW X3_GRPSXG X3_FOLDER X3_PYME X3_CONDSQL X3_CHKSQL X3_IDXSRV X3_ORTOGRA X3_IDXFLD X3_TELA X3_PICBRV X3_AGRUP X3_POSLGT X3_MODAL X3_CHKSUM X3_ADDSUM D_E_L_E_T_ R_E_C_N_O_ R_E_C_D_E_L_
VG8 01 VG8_FILIAL C 2 0 Filial Sucursal Branch Filial do Sistema Sucursal del Sistema System Branch - - x x x x x x x x x x x x x x x - - 1 - - - - N - - - - - - - - - - 033 - S - - N N N - - - 1 2 - - - 169833 0
VG8 02 VG8_NUMOSV C 8 0 Numero da OS Numero de OS SO Number Numero Ordem de Servico Numero Orden de Servicio Service Order Nmb @!S8 - x x x xx x x x x x x x x x x x x x x - VO1 1 x xxxx - - - S A R - - - - - - - - - - S - - N N N - - - 1 1 - - - 169834 0
VG8 03 VG8_CODMAR C 3 0 Marca Marca Brand Codigo da Marca Codigo de la Marca Brand Code @!S3 FG_Seek("VE1","M->VG8_CODMAR",1,.f.,"VG8_DESMAR","VE1_DESMAR") .AND. IIf(Funname()=="OFIGM070",FS_CHECMAR() .AND. FS_CHEGMF(),) x x x x x x x x x x x x x x x xx - VE1 1 x xx x - - - S A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169835 0
VG8 04 VG8_DESMAR C 30 0 Descricao Descripcion Description Descricao da Marca Descripcion de la Marca Brand Description @!S30 - x x x x x x x x x x x x x x x x IF(!INCLUI,POSICIONE("VE1",1,XFILIAL("VE1")+VG8->VG8_CODMAR,"VE1_DESMAR"),"") - 1 x xx x - - - N V V - - - - - - - Posicione("VE1",1,xFilial("VE1")+VG8->VG8_CODMAR,"VE1_DESMAR") - - S - - N N N - - - 1 2 - - - 169836 0
VG8 05 VG8_ANORRC C 4 0 Ano da RR Ano de la RR RR Year Ano da RR Ano de la RR RR Year @!S4 FG_Seek("VG4","M->VG8->ANORRC",1,.f.) x x x x x x x x x x x x x x x xx STR(YEAR(DDATABASE),4) - 1 x xx x - - - S A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169837 0
VG8 06 VG8_NUMRRC C 7 0 Numero da RR Numero RR RR Number Numero da RR Numero de la RR RR Number @!S7 FG_Strzero("M->VG8_NUMRRC",7,.F.) .and. ExistChav("VG8",M->VG8_CODMAR+M->VG8_ANORRC+M->VG8_NUMRRC,1,"EXINUMRRC") x x x x x x x x x x x x x x x xx - VG4 1 x xx x - - - S A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169838 0
VG8 07 VG8_CHAINT C 6 0 Cod.Int.Chas Cod.Int.Chas Chas.Int.Cod Codigo Interno do Chassi Codigo Interno del Chasis Chassis Intr.Code @!S6 FG_Seek("VV1","M->VG8_CHAINT",1,.f.,"VG8_CHASSI","VV1_CHASSI") x x x x x x x x x x x x x x x x - - 1 x xx x - - - N V R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169839 0
VG8 08 VG8_CHASSI C 25 0 Chassi Chasis Chassis Chassi Chasis Chassis @!S25 FG_Seek("VV1","M->VG8_CHASSI",2,.f.,"VG8_CHAINT","VV1_CHAINT") x x x x x x x x x x x x x x x x IF(!INCLUI,POSICIONE("VV1",1,XFILIAL("VV1")+VG8->VG8_CHAINT,"VV1_CHASSI"),"") - 1 x xx x - - - S A R - - - - - - - Posicione("VV1",1,xFilial("VV1")+VG8->VG8_CHAINT,"VV1_CHASSI") - - S - - N N N - - - 1 2 - - - 169840 0
VG8 09 VG8_ABEGAR D 8 0 Abert.Garan. Apert.Garan. Warr.Open Data Abertura Gar. p/Fab. Fecha Apertura Gar. p/Fab Warr.Open Date for Manuf. - M->VG8_ABEGAR==DataValida(M->VG8_ABEGAR) x x x x x x x x x x x x x x x x - - 1 x xxxx - - - S A R - - - - - - - - - - S - - N N N - - - 1 1 - - - 169841 0
VG8 10 VG8_DATDIS D 8 0 Dta.Disponib Fch.Disponib Avail.Date Data da Disponibilidade Fecha de Disponibilidad Availability Date - - x x x x x x x x x x x x x x x x - - 1 x xx x - - - S V R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169842 0
VG8 11 VG8_KILGAR N 6 0 KM/Hora KM/Hora KM/Hour Kilometragem Garantia Quilometraje Garantía Guarantee Km @E 999,999 M->VG8_KILGAR>0 x x x x x x x x x x x x x x x x - - 1 xxxx x - - - S A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169843 0
VG8 12 VG8_NF1REM C 9 0 NF Remessa 1 Fact Envio 1 Remit.1 Inv. Nota Fiscal De Remessa 1 Factura de Envio 1 Remitance 1 Invoice @9 - x x x x x x x x x x x x x x x x - - 1 x xx x - - - S A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169844 0
VG8 13 VG8_NF2REM C 9 0 NF Remessa 2 Fact Env 2 Disp. Inv. 2 Nota Fiscal de Remessa 2 Factura de Envio 2 Dispatch Invoice 2 @! - x x x xx x x x x x x x x x x x x x - - 1 x x x - - - S V - - - - - - - - - 018 - S - - N N N - - - 1 2 - - - 169845 0
VG8 14 VG8_GRUSER C 2 0 Grupo Servic Grupo Servic Serv.Grp. Grupo de Servico Grupo de Servicio Service Group @!S2 FG_StrZero("M->VG8_GRUSER",2).and.FG_Seek("VOS","M->VG8_CODMAR+M->VG8_GRUSER",1,.f.,"VG8_DESGRS","VOS_DESGRU") x x x x x x x x x x x x x x x x - VOS 1 x xxxx - - - S A R - - - - - - - - - - S - - N N N - - - 1 1 - - - 169846 0
VG8 15 VG8_DESGRS C 30 0 Descricao Descripcion Description Descricao Grupo Servico Descripc. Grupo Servicio Serv.Group Desc. @!S30 - x x x x x x x x x x x x x x x x IF(!INCLUI,POSICIONE("VOS",1,XFILIAL("VOS")+VG8->VG8_CODMAR+VG8->VG8_GRUSER,"VOS_DESGRU"),"") - 1 x xx x - - - S V V - - - - - - - Posicione("VOS",1,xFilial("VOS")+VG8->VG8_CODMAR+VG8->VG8_GRUSER,"VOS_DESGRU") - - S - - N N N - - - 1 2 - - - 169847 0
VG8 16 VG8_CODSER C 15 0 Cod Servico Cod Servicio Serv.Code Codigo do Servico Codigo del Servicio Service Code @!S15 FG_Seek("VO6","FG_MARSRV(M->VG8_CODMAR)+M->VG8_CODSER",2,.f.,"VG8_DESSER","VO6_DESSER") x x x x x x x x x x x x x x x x - V6O 1 x xx x - - - S A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169848 0
VG8 17 VG8_DESSER C 30 0 Descricao Descripcion Description Descricao do Servico Descripcion del Servicio Serv.Description @!S30 - x x x x x x x x x x x x x x x x IF(!INCLUI,POSICIONE("VO6",2,XFILIAL("VO6")+FG_MARSRV(VG8->VG8_CODMAR,VG8->VG8_CODSER)+VG8->VG8_CODSER,"VO6_DESSER"),"") - 1 x xx x - - - S A V - - - - - - - Posicione("VO6",2,xFilial("VO6")+VG8->VG8_CODMAR+VG8->VG8_CODSER,"VO6_DESSER") - - S - - N N N - - - 1 2 - - - 169849 0
VG8 18 VG8_SERINT C 6 0 Cod.Serv.Int Cod.Serv.Int Int.Serv.Cod Codigo Servico Interno Codigo Servicio Interno Inter.Serv.Code @!S6 - x x x x x x x x x x x x x x x x - - 1 x xx x - - - S V R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169850 0
VG8 19 VG8_GRUITE C 4 0 Grupo Item Grupo Item Item Grp. Grupo do Item Grupo del Item Item Group @! FG_Seek("SBM","M->VG8_GRUITE",1,.f.,"VG8_DESGRU","BM_DESC") x x x x x x x x x x x x x x x x - E05 1 x xxxx - - - S A R - - - - - - - - 162 - S - - N N N - - - 1 1 - - - 169851 0
VG8 20 VG8_DESGRU C 30 0 Descricao Descripcion Description Descricao do Grupo Descripcion del Grupo Group Desc. @!S30 - x x x x x x x x x x x x x x x x IF(!INCLUI,POSICIONE("SBM",1,XFILIAL("SBM")+VG8->VG8_GRUITE,"BM_DESC"),"") - 1 x xx x - - - S V V - - - - - - - Posicione("SBM",1,xFilial("SBM")+VG8->VG8_GRUITE,"BM_DESC") - - S - - N N N - - - 1 2 - - - 169852 0
VG8 21 VG8_ITECAU C 27 0 ItemCausador ItemCausador Prvk. Item Item Causador Item Causador Provoking Item @!S27 FG_Seek("SB1","M->VG8_GRUITE+M->VG8_ITECAU",7,.f.,"VG8_DESITE","B1_DESC") x x x x x x x x x x x x x x x x - B06 1 x xx x - - - S A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169853 0
VG8 22 VG8_DESITE C 50 0 Desc. Item Desc. Item Item Desc. Descricao do Item Descripcion del Item Item Description @! - x x x x x x x x x x x x x x x x if(!Inclui,Posicione("SB1",7,xFilial("SB1")+VG8->VG8_GRUITE+VG8->VG8_ITECAU,"B1_DESC"),"") - 1 x xx x - - - S V V - - - - - - - Posicione("SB1",7,xFilial("SB1")+VG8->VG8_GRUITE+VG8->VG8_ITECAU,"B1_DESC") 171 - S - - N N N - - - 1 2 - - - 169854 0
VG8 23 VG8_PECINT C 15 0 Cod.Int.Peca Cod.Int.Part PartIntCode Codigo Interno da Peca Codigo Interno de Parte Part Internal Code @!S15 - x x x x x x x x x x x x x x x x - - 1 x xx x - - - N V R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169855 0
VG8 24 VG8_CODDEF C 3 0 Cod. Defeito Cod. Defecto Defet.Code Codigo do Defeito Codigo del Defecto Defeat Code @!S3 FS_INFNUM(M->VG8_CODDEF) .AND. FG_Seek("VG0","M->VG8_CODMAR+M->VG8_CODDEF",1,.f.,"VG8_DESDEF","VG0_DESDEF") x x x x x x x x x x x x x x x x - XG0 1 x xx x - - - S A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169856 0
VG8 25 VG8_DESDEF C 15 0 Desc.Defeito Desc.Defecto Defet.Desc. Descricao do Defeito Descripcion del Defecto Defeat Descrip. @!S15 - x x x x x x x x x x x x x x x x IF(!INCLUI,POSICIONE("VG0",1,XFILIAL("VG0")+VG8->VG8_CODMAR+VG8->VG8_CODDEF,"VG0_DESDEF"),"") - 1 x xx x - - - S V V - - - - - - - Posicione("VG0",1,xFilial("VG0")+VG8->VG8_CODMAR+VG8->VG8_CODDEF,"VG0_DESDEF") - - S - - N N N - - - 1 2 - - - 169857 0
VG8 26 VG8_SERCON N 9 0 Serie Conju. Serie Conju. Set Series Serie do Conjunto Serie del Conjunto Set Series @E 999,999,999 - x x x x x x x x x x x x x x x x - - 1 xxxx x - - - S A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169858 0
VG8 27 VG8_TIPCON C 10 0 Tip.Conjunto Tip.Conjunto Tp.Set Tipo de Conjunto Tipo de Conjunto Type of Set @!S10 - x x x x x x x x x x x x x x x x - - 1 x xx x - - - S A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169859 0
VG8 28 VG8_CODCAM N 6 0 Cod.Campanha Cod.Campana Camp.Code Codigo da Campanha Codigo de la Campana Campaign Code @E 999,999 - x x x x x x x x x x x x x x x x - - 1 xxxx x - - - S A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169860 0
VG8 29 VG8_CAMTIP C 2 0 Tipo de Camp Tipo de Camp Type Field Tipo de campanha Tipo de campana Type of Campaign @! Vazio() .or. Pertence("RA,TC,RC") x x x x x x x x x x x x x x x x - - 1 x - - - N A R - - RA=Acao Recomendada;TC=Campanha Tecnica;RC=Recall RA=Accion Recomendada;TC=Campana Tecnica;RC=Recall RA=Recomended Action;TC=Technical Campaign;RC=Recall - - - - - S - - N - N - - - 1 2 - - - 169861 0
VG8 30 VG8_CODREC C 1 0 Tipo Produto Tp Producto Tp Prod. Tipo do Produto Tipo del Producto Type of Product @!S1 FG_Seek("VG3","M->VG8_CODMAR+M->VG8_CODREC",1,.f.,"VG8_DESREC","VG3_DESREC") x x x x x x x x x x x x x x x x - VG3 1 x xx x - - - S A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169862 0
VG8 31 VG8_DESREC C 15 0 Desc.Produto DescProducto Prod.Desc. Descricao do Produto Descripcion del Producto Product Description @!S15 - x x x x x x x x x x x x x x x x IF(!INCLUI,POSICIONE("VG3",1,XFILIAL("VG3")+VG8->VG8_CODMAR+VG8->VG8_CODREC,"VG3_DESREC"),"") - 1 x xx x - - - S V V - - - - - - - Posicione("VG3",1,xFilial("VG3")+VG8->VG8_CODMAR+VG8->VG8_CODREC,"VG3_DESREC") - - S - - N N N - - - 1 2 - - - 169863 0
VG8 32 VG8_CODGAR C 5 0 Cod.Garantia Cod.Garantia Warr.Code Codigo da Garantia Codigo de la Garantia Warranty Code @!S5 FG_Seek("VG1","M->VG8_CODMAR+M->VG8_CODGAR",1,.f.,"VG8_DESGAR","VG1_DESGAR") x x x x x x x x x x x x x x x x - XG1 1 x xx x - - - S A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169864 0
VG8 33 VG8_DESGAR C 15 0 Dsc.Garantia Dsc.Garantia Warr.Desc. Descricao da Garantia Descripc. de la Garantia Warranty Desc. @!S15 - x x x x x x x x x x x x x x x x IF(!INCLUI,POSICIONE("VG1",1,XFILIAL("VG1")+VG8->VG8_CODMAR+VG8->VG8_CODGAR,"VG1_DESGAR"),"") - 1 x xx x - - - S V V - - - - - - - Posicione("VG1",1,xFilial("VG1")+VG8->VG8_CODMAR+VG8->VG8_CODGAR,"VG1_DESGAR") - - S - - N N N - - - 1 2 - - - 169865 0
VG8 34 VG8_TESCPO N 6 0 Teste Campo Prueba Campo Field Test Teste de Campo Prueba de Campo Field Test @E 999,999 - x x x x x x x x x x x x x x x x - - 1 xxxx x - - - S A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169866 0
VG8 35 VG8_KILPIC N 7 0 KM Pick Up KM Pick Up Pick Up Km Kilometragem da Pick Up Kilometraje de la Pick Up Pick Up Km @E 9,999,999 - x x x x x x x x x x x x x x x x - - 1 xxxx x - - - S A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169867 0
VG8 36 VG8_KILGUI N 7 0 KM Guincho KM Grua Tow Km Kilometragem do Guincho Kilometraje de la Grua Tow Km @E 9,999,999 - x x x x x x x x x x x x x x x x - - 1 xxxx x - - - S A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169868 0
VG8 37 VG8_VEIEXP C 1 0 Veic. Export Vehic. Expor Exp.Veh. Veiculo Exportado Vehiculo Exportado Export Vehicle @!S1 Pertence("01") x x x x x x x x x x x x x x x x "0" - 1 x xx x - - - S A R - - 0=Nao;1=Sim 0=No;1=Si 0=No;1=Yes - - - - - S - - N N N - - - 1 2 - - - 169869 0
VG8 38 VG8_RECONS C 1 0 Reconsiderac Reconsiderac Recons. Reconsideracao Reconsideracion Reconsid. @!S1 Pertence("01") x x x x x x x x x x x x x x x x "0" - 1 x xx x - - - S A R - - 0=Nao;1=Sim 0=No;1=Si 0=No;1=Yes - - - - - S - - N N N - - - 1 2 - - - 169870 0
VG8 39 VG8_MOTREC C 177 0 Motivo Recl. Motivo Queja Compl. Reas. Motivo da Reclamacao Motivo de la Queja Complaint Reason @!S177 NaoVazio() x x x xx x x x x x x x x x x x x x - - 1 x xx - - - S - - - - - - - - - - - - S - - N N N - - - 1 1 - - - 169871 0
VG8 40 VG8_RRCOLD C 70 0 RR Anterior RR Anterior Previous RR RR Anterior RR Anterior Previous RR @!S70 - x x x xx x x x x x x x x x x x x x - - 1 x x x - - - S V - - - - - - - - - - - S - - N N N - - - 1 2 - - - 169872 0
VG8 41 VG8_RRCNEW C 70 0 RR Nova RR Nueva RR New RR Nova RR Nueva RR New @!S70 - x x x xx x x x x x x x x x x x x x - - 1 x x x - - - S V - - - - - - - - - - - S - - N N N - - - 1 2 - - - 169873 0
VG8 42 VG8_CODCLI C 6 0 Cod Cliente Cod Cliente Custm.Code Codigo do Cliente Codigo del Cliente Customer Code @! FG_Seek("SA1","M->VG8_CODCLI",1,.f.) x x x x x x x x x x x x x x x x - - 1 x xx x - - - S A R - - - - - - - - 001 - S - - N N N - - - 1 2 - - - 169874 0
VG8 43 VG8_LOJA C 2 0 Loja Tienda Unit Loja do Cliente Tienda del Cliente Unit Name @! FG_Seek("SA1","M->VG8_CODCLI+M->VG8_LOJA",1,.f.,"VG8_NOMCLI","A1_NREDUZ") x x x x x x x x x x x x x x x x - - 1 x xx x - - - N A R - - - - - - - - 002 - S - - N N N - - - 1 2 - - - 169875 0
VG8 44 VG8_NOMCLI C 20 0 Nome Nombre Name Nome Cliente Nombre Cliente Customer Name @!S20 - x x x x x x x x x x x x x x x x IF(!INCLUI,POSICIONE("SA1",1,XFILIAL("SA1")+VG8->VG8_CODCLI+VG8->VG8_LOJA,"A1_NREDUZ"),"") - 1 x xx x - - - N V V - - - - - - - Posicione("SA1",1,xFilial("SA1")+VG8->VG8_CODCLI+VG8->VG8_LOJA,"A1_NREDUZ") - - S - - N N N - - - 1 2 - - - 169876 0
VG8 45 VG8_VALITE N 12 2 Vl.Item Tra. Vl.Item Tra. T.Item Vl. Valor de Peca Transmitido Valor de Pieza Transmitid Trans.Part Value @E 999,999,999.99 IIf(Funname()=="OFIGM070",FG_CCVALOR() ,) x x x xx x x x x x x x x x x x x x - - 1 xx x x - - - S - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 169877 0
VG8 46 VG8_PORAPC N 6 2 % Ad Peça % Agr Pieza Part Vl.Add% % Adicionada Vlr Peça % Agregada Val Pieza Part Added Value % @E 999.99 FG_CCVALOR() x x x x x x x x x x x x x x x x - - 1 xx - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169878 0
VG8 47 VG8_VLRAPC N 12 2 Ad Peça Agr Pieza Part Add Vl. Vlr adicional Peça Val agregadol Pieza Part Added Val. @E 999,999,999.99 FG_CCVALOR() x x x x x x x x x x x x x x x x - - 1 xx - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169879 0
VG8 48 VG8_VLPVLA N 12 2 Tot Peça Tot Pieza Part Total Vlr Peça + Vlr Adicional Val Pieza + Val Agregado Part Val. + Added Val. @E 999,999,999.99 - x x x x x x x x x x x x x x x x IIF(!INCLUI,(VG8->VG8_VALITE+VG8->VG8_VLRAPC),0) - 1 xx - - - N V V - - - - - - - (VG8->VG8_VALITE+VG8->VG8_VLRAPC) - - S - - N N N - - - 1 2 - - - 169880 0
VG8 49 VG8_VALSER N 12 2 Vl.Serv.Tra. Vl.Serv.Tra. T.Serv.Vl Valor Servico Transmitido Valor Servicio Transmitid Trans.Serv.Value @E 999,999,999.99 - x x x xx x x x x x x x x x x x x x - - 1 xx x x - - - S - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 169881 0
VG8 50 VG8_VLKMCA N 12 2 Valor Km Valor Km Km Value Vlr Km cobrados p/atedmto Val Km cobrados p/atec. Km vl. charged per serv. @E 999,999,999.99 FG_CCVALOR() x x x x x x x x x x x x x x x x - - 1 xx - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169882 0
VG8 51 VG8_VLRSET N 12 2 Serv 3o Serv Tercero 3rd-P. Serv. Vlr Serviço de Terceiro Val. Serv. de Tercero 3rd-party Service Value @E 999,999,999.99 FG_CCVALOR() x x x x x x x x x x x x x x x x - - 1 xx - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169883 0
VG8 52 VG8_TRANSM C 1 0 Transmitida Transmitida Transmitted Transmitida Transmitida Transmitted @!S1 - x x x xx x x x x x x x x x x x x x - - 1 x x x - - - S V - - - - - - - - - - - S - - N N N - - - 1 2 - - - 169884 0
VG8 53 VG8_EXPGAR C 1 0 Exporta Exporta Export Exporta Exporta Export @!S1 - x x x xx x x x x x x x x x x x x x - - 1 x x x - - - S V - - - - - - - - - - - S - - N N N - - - 1 2 - - - 169885 0
VG8 54 VG8_DATTRA D 8 0 Data Transm. Fecha Transm Trans.Date Data da Transmissao Fecha Transmision Trans.Date - - x x x xx x x x x x x x x x x x x x DDATABASE - 1 x x x - - - S V - - - - - - - - - - - S - - N N N - - - 1 2 - - - 169886 0
VG8 55 VG8_DATRET D 8 0 Data Retorno Fecha Retorn Return Date Data do Retorno Fecha Retorno Return Date - - x x x xx x x x x x x x x x x x x x DDATABASE - 1 x x x - - - S - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 169887 0
VG8 56 VG8_DESSIT C 120 0 Descr.Situac Descr.Situac Status Desc. Descricao da Situacao RR Descripcion Situacion RR RR Status Desc. @!S120 - x x x xx x x x x x x x x x x x x x - - 1 x x x - - - S V - - - - - - - - - - - S - - N N N - - - 1 2 - - - 169888 0
VG8 57 VG8_ITEPGT N 12 2 Vl.Item Pago Vl.Item Pag. Paid It.Vl. Valor de Item Pago Valor de Item Pagado Paid Item Value @E 999,999,999.99 - x x x xx x x x x x x x x x x x x x - - 1 xx x x - - - S - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 169889 0
VG8 58 VG8_SERPGT N 12 2 Vl.Serv.Pago Vl.Serv.Pag. Paid Sev.Vl. Valor de Servico Pago Valor de Servicio Pagado Paid Serv.Vl. @E 999,999,999.99 - x x x xx x x x x x x x x x x x x x - - 1 xx x x - - - S - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 169890 0
VG8 59 VG8_CUSESP N 12 2 Vl.Cus.Esp. Vl.Cos.Esp. Sp.Cos.Vl Vl. Custo Especial Pago Vl. Costo Especial Pagado Cost Value Special Paid @E 999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x - - - N V R - - - - - - - - - - S - - N - N - - - 1 2 - - - 169891 0
VG8 60 VG8_TPONCT N 12 2 Vl.T.N.Cat. Vl.T.N.Cat. Vl.T.N.Cat. Vl. Tempo Nao Catalogado Vl. Tiempo No Catalogado Time Val Not Registered @E 999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x - - - N V R - - - - - - - - - - S - - N - N - - - 1 2 - - - 169892 0
VG8 61 VG8_DATEST D 8 0 Data Estorno Fecha Revers Reverse Dt. Data de Estorno Fecha de Reversion Reverse Date - - x x x xx x x x x x x x x x x x x x - - 1 x x x - - - S - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 169893 0
VG8 62 VG8_ITEEST N 12 2 Vl.Item.Est. Vl.Item.Rev. Rev.Item Vl. Valor de Item Estornado Valor de Item Revertido Reversed Item Value @E 999,999,999.99 - x x x xx x x x x x x x x x x x x x - - 1 xx x x - - - S - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 169894 0
VG8 63 VG8_SEREST N 12 2 Vl.Ser.Est. Vl.Ser.Rev. Rev.Ser.Vl. Valor Servico Estornado Valor Servicio Revertido Reversed Service Value @E 999,999,999.99 - x x x xx x x x x x x x x x x x x x - - 1 xx x x - - - S - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 169895 0
VG8 64 VG8_EXCLUI C 1 0 Excluido Borrado Deleted Excluido/Cliente Borrado/Cliente Deleted/Client @!S1 - x x x x x x x x x x x x x x x - - 1 - - - - N V - - - - - - - - - - - S - - N N N - - - 1 2 - - - 169896 0
VG8 65 VG8_OK C 2 0 Iden.Selecao Iden.Selecci Select. ID Identificador de Selecao Identificador de Seleccio Selection Identifier - - x x x x x x x x x x x x x x x - - 1 xxxx x x - - - N - R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169897 0
VG8 66 VG8_NFIENT C 9 0 N.F.Entrada Fact.Entrada Inf.Inv. Nota Fiscal de Entrada Factura de Entrada Inflow Invoice @! - x x x xx x x x x x x x x x x x x x - - 1 x - - - N A R - - - - - - - - 018 - N - - N N N - - - 1 2 - - - 169898 0
VG8 67 VG8_SERENT C 3 0 Ser. Entrada Ser. Entrada Infl.Series Serie da N.F. de Entrada Serie Factura de Entrada Inflow Invoice Series !!! - x x x xx x x x x x x x x x x x x x - - 1 x - - - N A R - - - - - - - - 094 - N - - N N N - - - 1 2 - - - 169899 0
VG8 68 VG8_OBSERV M 100 0 Observacao Observacion Note Observacao Observacion Note @! - x x x x x x x x x x x x x x x x E_MSMM(VG8->VG8_OBSMEM,100) - 1 x x xx x - - - N A V - - - - - - - - - - S - - N N N - - - 1 2 - - - 169900 0
VG8 69 VG8_OBSMEM C 6 0 Oco-MEMO Oco-MEMO Oco-MEMO Oco-MEMO Oco-MEMO Oco-MEMO - - x x x x x x x x x x x x x x x - - 1 - - - - - - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 169901 0
VG8 70 VG8_SITRRC C 3 0 Situacao RR Situac. RR RR Status Situacao da RR na Fabrica Situacion RR en Fabrica RR Status in the Factory @!S3 Vazio() .or. ExistCpo("SX5","86"+M->VG8_SITRRC) x x x xx x x x x x x x x x x x x x - - 1 x x x - - - S - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 169902 0
VG8 71 VG8_TTPKST N 12 2 Total Total Total Total Peça + Km + Serv 3o Total Pieza + Km + Serv 3 Part+Km+3rd-p. Serv. Tot. @E 999,999,999.99 - x x x x x x x x x x x x x x x IIF(!INCLUI,((VG8->VG8_VALITE+VG8->VG8_VLRAPC)+VG8->VG8_VLKMCA+VG8->VG8_VLRSET),0) - 1 xx x - - - N V V - - - - - - - ((VG8->VG8_VALITE+VG8->VG8_VLRAPC)+VG8->VG8_VLKMCA+VG8->VG8_VLRSET) - - S - - N N N - - - 1 2 - - - 169903 0
VG8 72 VG8_VLDACE N 12 2 Busca Busqueda Search Vlr despesas acessorias Val. gastos accesorios Additional expenses value @E 999,999,999.99 - x x x x x x x x x x x x x x x - - 1 xx x - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169904 0
VG8 73 VG8_MOTORE N 10 0 Motor Motor Engine Motor Motor Engine @E 9,999,999,999 - x x x x x x x x x x x x x x x x - - 1 xx x - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169905 0
VG8 74 VG8_KILANT N 7 0 Km Anterior Km Anterior Prev.Km Km Anterior Km Anterior Previous Km @E 9,999,999 - x x x x x x x x x x x x x x x x - - 1 xx x - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169906 0
VG8 75 VG8_TIPONF C 1 0 TIPO DE NF Tipo Factura FI Type TIPO DE NF Tipo de Factura Type of Fiscal Invoice @! - x x x x x x x x x x x x x x x x - - 1 xxxx - - - S A R - PERTENCE("123") 1=Garantia;2=Contrato;3=Acordo 1=Garantia;2=Contrato;3=Acuerdo 1=Warranty;2=Contract;3=Agreement - - - - - S - - N N N - - - 1 1 - - - 169907 0
VG8 76 VG8_DTAANT D 8 0 Dt Repar Ant Fch Repar An Pr.Repair Dt Data Reparo Anterior Fecha Reparo Anterior Date of Previous Repair - - x x x x x x x x x x x x x x x x - - 1 xx x - - - N V R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169908 0
VG8 77 VG8_PRIREV D 8 0 Dt 1 revisao Fch 1 revisi Rev.1 Dt. Dt 1 revisao Fch 1 revision Revision 1 Date - !empty(M->VG8_PRIREV) x x x x x x x x x x x x x x x x - - 1 xx x - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169909 0
VG8 78 VG8_GDWILL C 7 0 Goodwill Goodwill Goodwill Goodwill Goodwill Goodwill @! - x x x x x x x x x x x x x x x x - - 1 xx x - - - S A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169910 0
VG8 79 VG8_CODPLU N 8 0 Cod. Plus Cod. Plus PLUS Code Codigo PLUS Codigo PLUS PLUS Code @E 99,999,999 - x x x x x x x x x x x x x x x x - - 1 xx x - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169911 0
VG8 80 VG8_REPANT D 8 0 Dt. Rep. Ant Fch.Rep.Ant. Prv.Rep.Dt. Data do reparo anterior Fecha del reparo anterior Previous Rep.Date - - x x x x x x x x x x x x x x x x - - 1 xx x - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169912 0
VG8 81 VG8_LIBVOP C 8 0 Lib. TT Peca Apr. TT Piez Part TT Rel. Num. Lib. do TT de Peca Num Apr de TT de Pieza Part TT Rel. Nr. - - x x x x x x x x x x x x x x x x - - 1 x - - - S V R - - - - - - - - - - S - - N - N - - - 1 2 - - - 169913 0
VG8 82 VG8_LIBVOS C 8 0 Lib. TT Srvc Apr. TT Srvc Srvc TT Rel. Num. Lib. do TT de Srvc Num Apr de TT de Srvc Srvc TT Rel. Nr. - - x x x x x x x x x x x x x x x x - - 1 x - - - S V R - - - - - - - - - - S - - N - N - - - 1 2 - - - 169914 0
VG8 83 VG8_DATNFI D 8 0 Data NF Rem. Fch Fac Env Remit Inv.Dt Data da NF de Remessa Fecha de la Fact de Envio Remitcance Inv.Date - - x x x x x x x x x x x x x x x x - - 1 x xx x - - - S V R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169915 0
VG8 84 VG8_NUMNFI C 9 0 Nro NFiscal No Factura Inv. No. Numero da Nota Fiscal Numero de la factura Invoice Number @! - x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - 018 - S - - N - N - - - 1 2 - - - 169916 0
VG8 85 VG8_SERNFI C 3 0 Serie NF Serie Fact Inv.Series Serie da Nota Fiscal Serie de la Factura Invoice Series !!! - x x x xx x x x x x x x x x x x x x - - 1 x x x - - - S V - - - - - - - - - 094 - S - - N N N - - - 1 2 - - - 169917 0
VG8 86 VG8_DATCRE D 8 0 Data Credito Fecha Credit Credit Date Data do Credito Fecha del Credito Credit Date - - x x x xx x x x x x x x x x x x x x - - 1 x x x - - - S - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 169918 0
VG8 87 VG8_NFCRED C 9 0 NF Credito Fact. Cred. Credit Inv. NF Credito Factura Credito Credit Invoice @! - x x x x x x x x x x x x x x x x - - 1 xx - - - N A R - - - - - - - - 018 - S - - N N N - - - 1 2 - - - 169919 0
VG8 88 VG8_SERNFC C 3 0 Serie NF Crd Serie Fac Cr Crd Inv. Ser Serie NF Credito Serie factura de credito Crd. Inv. Series !!! - x x x x x x x x x x x x x x x x - - 1 x x - - - N A R - - - - - - - - 094 - S - - N - N - - - 1 2 - - - 169920 0
VG8 89 VG8_WEBSIT C 1 0 Trans. Web Trans. Web Trans. Web Transmis. via Website Transmis. via Website Transmis. via Website @A - x x x x x x x x x x x x x x x x - - 1 x - - - N V R - - - - - - - - - - S - - N - N - - - 1 2 - - - 169921 0
VG8 90 VG8_REGACO C 25 0 Região Region Region Regiao atuação Concession Region actuac. Conces. Dealership covered region @! - x x x x x x x x x x x x x x x - - 1 xx x - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169922 0
VG8 91 VG8_VLMOCC N 12 2 Mão Obra Mano Obra Labor Vl MObra CC(T rep x VrHr) Val MObra CC(T rep x VrHr Labor Vl LC(T rep x HrVl) @E 999,999,999.99 - x x x x x x x x x x x x x x x - - 1 xx x - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169923 0
VG8 92 VG8_VLPECC N 12 2 Peça Pieza Part Valor Peça CC Valor Pieza CC CC Part Value @E 999,999,999.99 FG_CCVALOR() x x x x x x x x x x x x x x x - - 1 xx x - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169924 0
VG8 93 VG8_POAPCC N 12 2 % Ad Peça % Agr Pieza Part Vl.Add% % Adicionada Vlr Peça CC % Agregado Val Pieza CC Part CC Added Value % @E 999,999,999.99 - x x x x x x x x x x x x x x x - - 1 xx x - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169925 0
VG8 94 VG8_VRAPCC N 12 2 Ad Peça Ad Pieza Part Add.Vl. Vlr adicional Peça CC Val adicional Pieza CC CC Part Added Val. @E 999,999,999.99 FG_CCVALOR() x x x x x x x x x x x x x x x - - 1 xx x - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169926 0
VG8 95 VG8_VPVLAC N 12 2 Tot Peça Tot Pieza Part Total Vlr Peça + Vlr Adicio. CC Val Pza + Val Adicio. CC Part Val. CC Added Val. @E 999,999,999.99 - x x x x x x x x x x x x x x x IIF(!INCLUI,(VG8->VG8_VLPECC+VG8->VG8_VRAPCC),0) - 1 xx x - - - N V V - - - - - - - (VG8->VG8_VLPECC+VG8->VG8_VRAPCC) - - S - - N N N - - - 1 2 - - - 169927 0
VG8 96 VG8_VKMCAC N 12 2 Valor Km Valor Km KM Value Vlr Km cobrados p/aten CC Vlr Km cobrados p/aten CC Km Vl. charged p/ serv.CC @E 999,999,999.99 FG_CCVALOR() x x x x x x x x x x x x x x x - - 1 xx x - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169928 0
VG8 97 VG8_VRSETC N 12 2 Serv 3o Serv 3o 3rd-P. Serv. Vlr Serviço de TerceiroCC Val Servicio de 3º CC CC 3rd-Party Serv. Value @E 999,999,999.99 FG_CCVALOR() x x x x x x x x x x x x x x x - - 1 xx x - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169929 0
VG8 98 VG8_TPKSTC N 12 2 Total Total Total Tot Peça + Km +Serv 3o CC Tot Pza + Km +Serv 3o CC Part+KM+3rd-p Serv. TotCC @E 999,999,999.99 - x x x x x x x x x x x x x x x IIF(!INCLUI,((VG8->VG8_VLPECC+VG8->VG8_VRAPCC)+VG8->VG8_VKMCAC+VG8->VG8_VRSETC),0) - 1 xx x - - - N V V - - - - - - - ((VG8->VG8_VLPECC+VG8->VG8_VRAPCC)+VG8->VG8_VKMCAC+VG8->VG8_VRSETC) - - S - - N N N - - - 1 2 - - - 169930 0
VG8 99 VG8_CACREC N 10 0 Carta Cred Carta Cred Lett. Credit Nr da Carta de Crédito Nº de Carta de Credito Letter of Credit No. @E 9,999,999,999 - x x x x x x x x x x x x x x x - - 1 xx x - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 169931 0
VG8 A0 VG8_SDOCC C 3 0 Série NF Crd Serie Fac Cr Cred.Inv.Ser Série NF Credito Serie Fact Credito Credit Invoice Series !!! - x x x x x x x x x x x x x x x - - 1 xx x - - - N V R - - - - - - - - 095 - S - - N - N - - - 1 2 - - - 169932 0
VG8 A1 VG8_SDOCE C 3 0 Sér.NF Entra Ser.Fac Entr Inb.Inv.Ser. Série da NF Entrada Serie de Fact Entrada Inbound Invoice Series !!! - x x x x x x x x x x x x x x x - - 1 xx x - - - N V R - - - - - - - - 095 - S - - N - N - - - 1 2 - - - 169933 0
VG8 A2 VG8_SDOCS C 3 0 Série Doc. Serie Doc. Inv. Series Série do Documento Fiscal Serie del documento Fisca Invoice Series !!! - x x x x x x x x x x x x x x x - - 1 xx x - - - N V R - - - - - - - - 095 - S - - N - N - - - 1 2 - - - 169934 0
VG8 A3 VG8_DTREPA D 8 0 Dt. Reparo Fch Repar. Repair Dt. Data de Reparo Fecha de reparación Repair Date - - x x x x x x x x x x x x x x x x - - 1 xx - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 169935 0
VG8 A4 VG8_IDMODC C 100 0 Id. Modulo Id. Módulo Module Id Id. Modulo a ser exec. Id. Módulo que se Ejec. Id. Module to be exec. @! - x x x x x x x x x x x x x x x x - - 1 xx - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 169936 0
VG8 A5 VG8_IDPLAM C 100 0 Id. Plan. M. Id. Plan. M. M Plan Id Id. Plano de Manutencao Id. Plan de mantenimiento Maintenance Plan Id @! - x x x x x x x x x x x x x x x x - - 1 xx - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 169937 0
VG8 A6 VG8_CDTMOD C 20 0 Cod. Tipo M. Cód. Tipo M. M Type Code Codigo do Tipo do Mod. Código del Tipo de Mod. Mod Type Code @! - x x x x x x x x x x x x x x x x - - 1 xx - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 169938 0
VG8 A7 VG8_KMPLAN N 8 0 Km. Plan. Km. Plan. Km. Plan. Km Plan. Execução Reparo Km Plan. Ejecución repara Km Plan. Execution Repair @E 99999999 - x x x x x x x x x x x x x x x x - - 1 xx - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 169939 0

Índices da Tabela VG8 (3 índices)

INDICE ORDEM CHAVE DESCRICAO DESCSPA DESCENG PROPRI F3 NICKNAME SHOWPESQ IX_VIRTUAL IX_VIRCUST D_E_L_E_T_ R_E_C_N_O_ R_E_C_D_E_L_
VG8 1 VG8_FILIAL+VG8_CODMAR+VG8_NUMOSV+VG8_ANORRC+VG8_NUMRRC Marca + Numero da OS + Ano da RR + Numero da RR Marca + Numero de OS + Ano de la RR + Numero RR Brand + SO Number + RR Year + RR Number S - - S 2 3 - 24683 0
VG8 2 VG8_FILIAL+VG8_CODMAR+VG8_ANORRC+VG8_NUMRRC Marca + Ano da RR + Numero da RR Marca + Ano de la RR + Numero RR Brand + RR Year + RR Number S - - S 2 3 - 24684 0
VG8 3 VG8_FILIAL+VG8_NUMOSV+VG8_CODMAR Numero da OS + Marca Numero de OS + Marca SO Number + Brand S - - S 2 3 - 24685 0

Perguntas frequentes

Para que serve a tabela VG8 no Protheus?

Ela é utilizada para dados da rr de garantia dentro do sistema ERP Protheus.

Como consultar os campos da tabela VG8?

Nesta página você pode visualizar todos os campos, incluindo tipo, tamanho e validações.

O que são os índices da tabela VG8?

Os índices são estruturas que melhoram a performance de busca e acesso aos dados dentro do Protheus.

Exemplo de consulta SQL da tabela VG8

Modelo de query gerado automaticamente com base na estrutura da tabela. 

SELECT
    VG8_FILIAL,
    VG8_NUMOSV,
    VG8_CODMAR,
    VG8_DESMAR,
    VG8_ANORRC,
    VG8_NUMRRC,
    VG8_CHAINT,
    VG8_CHASSI,
    VG8_ABEGAR,
    VG8_DATDIS,
    VG8_KILGAR,
    VG8_NF1REM,
    VG8_NF2REM,
    VG8_GRUSER,
    VG8_DESGRS,
    VG8_CODSER,
    VG8_DESSER,
    VG8_SERINT,
    VG8_GRUITE,
    VG8_DESGRU,
    VG8_ITECAU,
    VG8_DESITE,
    VG8_PECINT,
    VG8_CODDEF,
    VG8_DESDEF,
    VG8_SERCON,
    VG8_TIPCON,
    VG8_CODCAM,
    VG8_CAMTIP,
    VG8_CODREC,
    VG8_DESREC,
    VG8_CODGAR,
    VG8_DESGAR,
    VG8_TESCPO,
    VG8_KILPIC,
    VG8_KILGUI,
    VG8_VEIEXP,
    VG8_RECONS,
    VG8_MOTREC,
    VG8_RRCOLD,
    VG8_RRCNEW,
    VG8_CODCLI,
    VG8_LOJA,
    VG8_NOMCLI,
    VG8_VALITE,
    VG8_PORAPC,
    VG8_VLRAPC,
    VG8_VLPVLA,
    VG8_VALSER,
    VG8_VLKMCA,
    VG8_VLRSET,
    VG8_TRANSM,
    VG8_EXPGAR,
    VG8_DATTRA,
    VG8_DATRET,
    VG8_DESSIT,
    VG8_ITEPGT,
    VG8_SERPGT,
    VG8_CUSESP,
    VG8_TPONCT,
    VG8_DATEST,
    VG8_ITEEST,
    VG8_SEREST,
    VG8_EXCLUI,
    VG8_OK,
    VG8_NFIENT,
    VG8_SERENT,
    VG8_OBSERV,
    VG8_OBSMEM,
    VG8_SITRRC,
    VG8_TTPKST,
    VG8_VLDACE,
    VG8_MOTORE,
    VG8_KILANT,
    VG8_TIPONF,
    VG8_DTAANT,
    VG8_PRIREV,
    VG8_GDWILL,
    VG8_CODPLU,
    VG8_REPANT,
    VG8_LIBVOP,
    VG8_LIBVOS,
    VG8_DATNFI,
    VG8_NUMNFI,
    VG8_SERNFI,
    VG8_DATCRE,
    VG8_NFCRED,
    VG8_SERNFC,
    VG8_WEBSIT,
    VG8_REGACO,
    VG8_VLMOCC,
    VG8_VLPECC,
    VG8_POAPCC,
    VG8_VRAPCC,
    VG8_VPVLAC,
    VG8_VKMCAC,
    VG8_VRSETC,
    VG8_TPKSTC,
    VG8_CACREC,
    VG8_SDOCC,
    VG8_SDOCE,
    VG8_SDOCS,
    VG8_DTREPA,
    VG8_IDMODC,
    VG8_IDPLAM,
    VG8_CDTMOD,
    VG8_KMPLAN
FROM VG8
WHERE
    D_E_L_E_T_ = ' '
    AND VG8_FILIAL = 'VALOR'
    AND VG8_NUMOSV = 'VALOR'
    AND VG8_CODMAR = 'VALOR'
    AND VG8_DESMAR = 'VALOR'
    AND VG8_ANORRC = 'VALOR'
    AND VG8_NUMRRC = 'VALOR'
    AND VG8_CHAINT = 'VALOR'
    AND VG8_CHASSI = 'VALOR'
    AND VG8_ABEGAR BETWEEN '20260501' AND '20260531'
    AND VG8_DATDIS BETWEEN '20260501' AND '20260531'
    AND VG8_KILGAR = 0
    AND VG8_NF1REM = 'VALOR'
    AND VG8_NF2REM = 'VALOR'
    AND VG8_GRUSER = 'VALOR'
    AND VG8_DESGRS = 'VALOR'
    AND VG8_CODSER = 'VALOR'
    AND VG8_DESSER = 'VALOR'
    AND VG8_SERINT = 'VALOR'
    AND VG8_GRUITE = 'VALOR'
    AND VG8_DESGRU = 'VALOR'
    AND VG8_ITECAU = 'VALOR'
    AND VG8_DESITE = 'VALOR'
    AND VG8_PECINT = 'VALOR'
    AND VG8_CODDEF = 'VALOR'
    AND VG8_DESDEF = 'VALOR'
    AND VG8_SERCON = 0
    AND VG8_TIPCON = 'VALOR'
    AND VG8_CODCAM = 0
    AND VG8_CAMTIP = 'VALOR'
    AND VG8_CODREC = 'VALOR'
    AND VG8_DESREC = 'VALOR'
    AND VG8_CODGAR = 'VALOR'
    AND VG8_DESGAR = 'VALOR'
    AND VG8_TESCPO = 0
    AND VG8_KILPIC = 0
    AND VG8_KILGUI = 0
    AND VG8_VEIEXP = 'VALOR'
    AND VG8_RECONS = 'VALOR'
    AND VG8_MOTREC = 'VALOR'
    AND VG8_RRCOLD = 'VALOR'
    AND VG8_RRCNEW = 'VALOR'
    AND VG8_CODCLI = 'VALOR'
    AND VG8_LOJA = 'VALOR'
    AND VG8_NOMCLI = 'VALOR'
    AND VG8_VALITE = 0
    AND VG8_PORAPC = 0
    AND VG8_VLRAPC = 0
    AND VG8_VLPVLA = 0
    AND VG8_VALSER = 0
    AND VG8_VLKMCA = 0
    AND VG8_VLRSET = 0
    AND VG8_TRANSM = 'VALOR'
    AND VG8_EXPGAR = 'VALOR'
    AND VG8_DATTRA BETWEEN '20260501' AND '20260531'
    AND VG8_DATRET BETWEEN '20260501' AND '20260531'
    AND VG8_DESSIT = 'VALOR'
    AND VG8_ITEPGT = 0
    AND VG8_SERPGT = 0
    AND VG8_CUSESP = 0
    AND VG8_TPONCT = 0
    AND VG8_DATEST BETWEEN '20260501' AND '20260531'
    AND VG8_ITEEST = 0
    AND VG8_SEREST = 0
    AND VG8_EXCLUI = 'VALOR'
    AND VG8_OK = 'VALOR'
    AND VG8_NFIENT = 'VALOR'
    AND VG8_SERENT = 'VALOR'
    AND VG8_OBSMEM = 'VALOR'
    AND VG8_SITRRC = 'VALOR'
    AND VG8_TTPKST = 0
    AND VG8_VLDACE = 0
    AND VG8_MOTORE = 0
    AND VG8_KILANT = 0
    AND VG8_TIPONF = 'VALOR'
    AND VG8_DTAANT BETWEEN '20260501' AND '20260531'
    AND VG8_PRIREV BETWEEN '20260501' AND '20260531'
    AND VG8_GDWILL = 'VALOR'
    AND VG8_CODPLU = 0
    AND VG8_REPANT BETWEEN '20260501' AND '20260531'
    AND VG8_LIBVOP = 'VALOR'
    AND VG8_LIBVOS = 'VALOR'
    AND VG8_DATNFI BETWEEN '20260501' AND '20260531'
    AND VG8_NUMNFI = 'VALOR'
    AND VG8_SERNFI = 'VALOR'
    AND VG8_DATCRE BETWEEN '20260501' AND '20260531'
    AND VG8_NFCRED = 'VALOR'
    AND VG8_SERNFC = 'VALOR'
    AND VG8_WEBSIT = 'VALOR'
    AND VG8_REGACO = 'VALOR'
    AND VG8_VLMOCC = 0
    AND VG8_VLPECC = 0
    AND VG8_POAPCC = 0
    AND VG8_VRAPCC = 0
    AND VG8_VPVLAC = 0
    AND VG8_VKMCAC = 0
    AND VG8_VRSETC = 0
    AND VG8_TPKSTC = 0
    AND VG8_CACREC = 0
    AND VG8_SDOCC = 'VALOR'
    AND VG8_SDOCE = 'VALOR'
    AND VG8_SDOCS = 'VALOR'
    AND VG8_DTREPA BETWEEN '20260501' AND '20260531'
    AND VG8_IDMODC = 'VALOR'
    AND VG8_IDPLAM = 'VALOR'
    AND VG8_CDTMOD = 'VALOR'
    AND VG8_KMPLAN = 0