Tabela |
VGA |
Dados da OS de Garantia Vw |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
VGA_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
VGA_CODMAR |
C |
3 |
0 |
Marca |
@!S3 |
FG_EK("VGA").And.FG_Seek("VE1","M->VGA_CODMAR",1,.f.,"VGA_DESMAR","VE1_DESMAR").AND.OFIGM000VAL("M->VGA_CODMAR") |
XE1 |
|
|
|
S |
VGA_DESMAR |
C |
30 |
0 |
Descricao |
@!S30 |
|
|
V |
|
|
S |
VGA_NUMOSV |
C |
8 |
0 |
Numero da OS |
@!S8 |
FG_EK("VGA").And.FG_Strzero("M->VGA_NUMOSV",8).And.ExistCpo("VO1") |
VO1VGA |
|
|
|
S |
VGA_SERIEN |
C |
3 |
0 |
Serie NF |
@!S3 |
|
|
|
|
|
S |
VGA_NUMNFI |
C |
9 |
0 |
Numero da NF |
@! |
FG_NumNot("M->VGA_NUMNFI") |
|
|
|
|
S |
VGA_ESPGAR |
C |
1 |
0 |
Especie Gar. |
@!S1 |
FG_EK("VGA") |
XG3 |
|
|
|
S |
VGA_CODGAR |
C |
5 |
0 |
Cod. Garant. |
@!S5 |
FG_PosVE4("M->VGA_CODMAR").and.if(VE4->VE4_GARZER="1",FG_Strzero("M->VGA_CODGAR",5,.T.),.T.).and.FG_CODGARVGA() |
VG1 |
|
|
|
S |
VGA_DESGAR |
C |
15 |
0 |
Desc. Garan. |
@!S15 |
|
|
V |
|
|
S |
VGA_CHAINT |
C |
6 |
0 |
Cod.Int.Chas |
@!S6 |
FG_Seek("VV1","M->VGA_CHAINT",1,.f.,"VGA_CHASSI","VV1_CHASSI") |
V17 |
|
|
|
S |
VGA_CHASSI |
C |
25 |
0 |
Chassi |
@!25 |
|
|
V |
|
|
S |
VGA_ABEGAR |
D |
8 |
0 |
Abert.Garan. |
|
M->VGA_ABEGAR <= DDATABASE |
|
|
|
|
S |
VGA_KILGAR |
N |
6 |
0 |
Kil. Garant. |
@E 999,999 |
FS_VerGar().AND.Positivo() |
|
R |
|
|
S |
VGA_SEGMOD |
C |
10 |
0 |
TMA |
@!3 |
FS_VerGar() |
VXV |
R |
|
|
S |
VGA_CODREV |
C |
2 |
0 |
Cod. Revisao |
@!S2 |
FG_Strzero("M->VGA_CODREV",2,.F.) .and. FG_Seek("VG2","M->VGA_CODMAR+M->VGA_CODREV",1,.f.,"VGA_GRUREV","VG2_GRUREV") |
VG2 |
|
|
|
S |
VGA_GRUREV |
C |
1 |
0 |
Grupo Revis. |
@!S1 |
NaoVazio() |
V2G |
R |
|
|
S |
VGA_DNRESP |
C |
6 |
0 |
DN Respons. |
999999 |
FG_STRZERO("M->VGA_DNRESP",6,.F.).AND.FG_SEEK("VVK","M->VGA_CODMAR+M->VGA_DNRESP",1,.F.) |
VVN |
R |
|
|
S |
VGA_RECONS |
C |
1 |
0 |
Tp Consider |
@!S1 |
NaoVazio() .and. Pertence("123") |
|
|
1=Normal;2=Reconsideracao;3=Complemento |
|
S |
VGA_NFIFEC |
C |
9 |
0 |
NF Fechament |
@! |
FG_NumNot("M->VGA_NUMNFI") |
|
R |
|
|
S |
VGA_SERFEC |
C |
3 |
0 |
Serie NF Fec |
@!S3 |
|
|
|
|
|
S |
VGA_DATFEC |
D |
8 |
0 |
Dt.Fech/Disp |
|
|
|
|
|
|
S |
VGA_AUTFAB |
C |
6 |
0 |
Nro.Aut.Fab. |
@!S6 |
FS_VerGar() |
|
|
|
|
S |
VGA_RESER1 |
C |
6 |
0 |
Reservado1 |
@!S6 |
|
|
|
|
|
S |
VGA_RESER2 |
C |
6 |
0 |
Reservado2 |
@!S6 |
|
|
|
|
|
S |
VGA_RESER3 |
C |
6 |
0 |
Reservado3 |
@!S6 |
|
|
|
|
|
S |
VGA_RESER4 |
C |
6 |
0 |
Reservado4 |
@!S6 |
|
|
|
|
|
S |
VGA_VALPEC |
N |
12 |
2 |
Vl.Peca Tran |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
S |
VGA_VALTPO |
N |
12 |
2 |
Vl.Tpo.Tran. |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
S |
VGA_TEMPAD |
N |
5 |
0 |
Un.Tpo.Tran. |
@E 99,999 |
Positivo() |
|
|
|
|
S |
VGA_CODCLI |
C |
6 |
0 |
Cod Cliente |
@! |
|
|
|
|
|
S |
VGA_LOJA |
C |
2 |
0 |
Loja |
@! |
FG_Seek("SA1","M->VGA_CODCLI+M->VGA_LOJA",1,.f.,"VGA_NOMCLI","A1_NREDUZ") |
|
|
|
|
S |
VGA_NOMCLI |
C |
20 |
0 |
Nome |
@!S20 |
|
|
V |
|
|
S |
VGA_IMPOSV |
C |
1 |
0 |
OS Importada |
@!S1 |
|
|
|
|
|
S |
VGA_EXPGAR |
C |
1 |
0 |
Exporta OS |
@!S1 |
|
|
|
|
|
S |
VGA_DATTRA |
D |
8 |
0 |
Data Transm. |
|
|
|
|
|
|
S |
VGA_DATRET |
D |
8 |
0 |
Data Retorno |
|
|
|
|
|
|
S |
VGA_SITUAC |
C |
2 |
0 |
Sit Processo |
@!S2 |
FG_Strzero("M->VGA_SITUAC",2,.F.).AND.PERTENCE("00010203040506") |
|
|
00=Sol.OK;01=Sol.Erro;02=Sol.Credito;03=Sol.Debito;04=Cup.Rev.Erro/OK;05=Cup.Rev.Credito;06=Cup.Rev.Debito |
|
S |
VGA_DESSIT |
C |
60 |
0 |
Desc. Situac |
@!S60 |
|
|
|
|
|
S |
VGA_DATCRE |
D |
8 |
0 |
Data Credito |
|
|
|
|
|
|
S |
VGA_VALCRE |
N |
12 |
2 |
Vl. Credito |
@E 999,999,999.99 |
|
|
|
|
|
S |
VGA_LANCRE |
C |
6 |
0 |
Lancto.Cred. |
@!S6 |
|
|
|
|
|
S |
VGA_DATDEB |
D |
8 |
0 |
Data Debito |
|
|
|
|
|
|
S |
VGA_VALDEB |
N |
12 |
2 |
Vl. Debito |
@E 999,999,999.99 |
|
|
|
|
|
S |
VGA_LANDEB |
C |
6 |
0 |
Lanct.Debito |
@!S6 |
|
|
|
|
|
S |
VGA_CODEST |
C |
3 |
0 |
Cod. Estorno |
@!S3 |
|
|
|
|
|
S |
VGA_DIFPGT |
N |
12 |
2 |
Dif. Pagto. |
@E 999,999,999.99 |
|
|
|
|
|
S |
VGA_TRANSM |
C |
1 |
0 |
Transmitido |
@!S1 |
|
|
|
|
|
S |
VGA_OK |
C |
2 |
0 |
Iden.Selecao |
|
|
|
R |
|
|
S |
VGA_OBSERV |
M |
80 |
0 |
OBSERVACAO |
@! |
|
|
V |
|
|
S |
VGA_OBSMEM |
C |
6 |
0 |
OCO-MEMO |
@! |
|
|
R |
|
|
S |
VGA_ROMANE |
C |
10 |
0 |
Romaneio |
@! |
|
|
R |
|
|
S |
VGA_DATLAN |
D |
8 |
0 |
Dt. Lanc. |
|
|
|
R |
|
|
S |
VGA_DTAVDA |
D |
8 |
0 |
Data Venda |
|
|
|
|
|
|
S |
VGA_DNEXEC |
C |
6 |
0 |
DN Executant |
@! |
|
|
R |
|
|
S |
VGA_CONTRA |
C |
10 |
0 |
NR.CONTRA |
@! |
|
|
R |
|
|
S |
VGA_SDOCC |
C |
3 |
0 |
Serie NF Fec |
!!! |
|
|
R |
|
|
S |
VGA_SDOCE |
C |
3 |
0 |
Serie Doc. |
!!! |
|
|
R |
|
|
S |