Tabela |
VMB |
Garantia JD cabecalho |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
VMB_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
VMB_CODGAR |
C |
8 |
0 |
Cod.Garantia |
@! |
|
|
R |
|
|
S |
VMB_DEALER |
C |
6 |
0 |
Dealer Accou |
@! |
|
|
R |
|
|
S |
VMB_TIPGAR |
C |
4 |
0 |
Tipo Garant |
@! |
ExistCPO("VX5","006"+M->VMB_TIPGAR) |
VX5 |
R |
|
|
S |
VMB_DTPGAR |
C |
25 |
0 |
Desc. TP.Gar |
@! |
|
|
V |
|
|
S |
VMB_SUBGAR |
C |
3 |
0 |
Subtipo Gar. |
@! |
ExistCPO("VX5","010"+M->VMB_SUBGAR) |
VX5 |
R |
|
M->VMB_TIPGAR="ZZMK" |
S |
VMB_DSBGAR |
C |
25 |
0 |
Desc. Subtip |
@! |
|
|
V |
|
|
S |
VMB_LIFTIM |
C |
1 |
0 |
Life Time |
@! |
Percente("01") |
|
R |
0=Nao;1=Sim |
M->VMB_TIPGAR="ZPAR" |
S |
VMB_NUMOSV |
C |
8 |
0 |
Ord.Servico |
@! |
OFNJD15VLD() |
VO1 |
R |
|
INCLUI |
S |
VMB_REPARO |
C |
2 |
0 |
N. Reparo |
@! |
|
|
R |
|
INCLUI |
S |
VMB_NREFE2 |
C |
12 |
0 |
N. Refer. 2 |
@! |
|
|
R |
|
|
S |
VMB_CLAIM |
C |
12 |
0 |
Num. S.G. JD |
@! |
|
|
R |
|
|
S |
VMB_CRMEMO |
C |
10 |
0 |
Credit Memo |
@! |
|
|
R |
|
|
S |
VMB_STATUS |
C |
2 |
0 |
Status J.D. |
@! |
|
|
R |
#OFIOA560CB("016",2) |
|
S |
VMB_MEMTYP |
C |
1 |
0 |
Tipo do WM |
@! |
|
|
R |
1=Pagamento Efetuado;2=Debitado;4=Aguardando NF |
|
S |
VMB_STATSG |
C |
1 |
0 |
Status S.G. |
@! |
Vazio().or.Pertence("12345") |
|
R |
1=Pendente NF;2=NF Enviada;3=Pendente Atualizacao NF;4=Pendente Atual. O.S.;5=Pagto Efetuado |
|
S |
VMB_DTABER |
D |
8 |
0 |
Dt. Abertura |
|
|
|
R |
|
|
S |
VMB_DTENVI |
D |
8 |
0 |
Dt. Envio |
|
|
|
R |
|
|
S |
VMB_DTRETO |
D |
8 |
0 |
Dt. Retorno |
|
|
|
R |
|
|
S |
VMB_DTATUA |
D |
8 |
0 |
Dt. Atualiz. |
|
|
|
R |
|
|
S |
VMB_CHASSI |
C |
25 |
0 |
Chassi |
@! |
OFNJD15VLD() |
|
R |
|
INCLUI |
S |
VMB_CHAINT |
C |
6 |
0 |
Chassi Inter |
@! |
OFNJD15VLD() |
|
R |
|
INCLUI |
S |
VMB_TIPMAQ |
C |
5 |
0 |
Tp Maquina |
@! |
Vazio() .or. ExistCPO("VX5","015"+M->VMB_TIPMAQ) |
VX5 |
R |
|
|
S |
VMB_APLICA |
C |
4 |
0 |
Aplicacao |
@! |
Vazio().or.FG_Seek("VX5","IF(M->VMB_TIPGAR='ZZBT','008','009')+M->VMB_APLICA",1,.F.,"M->VMB_APLICD","VX5_DESCRI") |
VX5 |
R |
|
M->VMB_TIPGAR$"ZZTK/ZZBT" |
S |
VMB_APLICD |
C |
50 |
0 |
Desc. Aplic. |
@! |
|
|
V |
|
|
S |
VMB_NROAUT |
C |
20 |
0 |
Nro.Autoriz |
@! |
|
|
R |
|
M->VMB_TIPGAR="ZZTK" |
S |
VMB_INSPOR |
C |
1 |
0 |
Instalad por |
@! |
OFNJD15VLD() |
|
R |
C=Cliente;D=Concessionario;F=Fabrica;R=Concessionaria/Cliente |
M->VMB_TIPGAR$"ZZPAR/ZPTK/ZZBT" |
S |
VMB_MODELO |
C |
30 |
0 |
Modelo |
@! |
|
|
R |
|
|
S |
VMB_SERMOD |
C |
18 |
0 |
Serial Model |
@! |
|
|
R |
|
|
S |
VMB_NROPIP |
C |
40 |
0 |
Nro.PIP |
@! |
|
|
R |
|
M->VMB_TIPGAR="ZPIP" |
S |
VMB_INSDAT |
D |
8 |
0 |
Dt.Instalac |
|
|
|
R |
|
|
S |
VMB_QTDUTI |
N |
8 |
0 |
Uso da Maq. |
@E 99,999,999 |
OFNJD15UH() |
|
R |
|
|
S |
VMB_UNIMED |
C |
6 |
0 |
Unid.Medida |
@! |
Vazio() .or. ExistCPO("VX5","005"+M->VMB_UNIMED) |
VX5 |
R |
|
|
S |
VMB_CODSTA |
C |
1 |
0 |
Status Prop. |
@! |
Vazio() .or. Pertence("1234") |
|
R |
1=Vendido;2=Em Estoque;3=Alugado;4=Demonstracao |
|
S |
VMB_GRUITE |
C |
4 |
0 |
Grupo Peca |
@! |
OFNJD15VLD() |
|
R |
|
M->VMB_TIPGAR#"ZZMK" |
S |
VMB_CODITE |
C |
27 |
0 |
Codigo Peca |
@! |
OFNJD15VLD() |
|
R |
|
M->VMB_TIPGAR#"ZZMK" |
S |
VMB_KEYPAR |
C |
18 |
0 |
Peca Chave |
@! |
|
|
R |
|
|
S |
VMB_SERCOM |
C |
18 |
0 |
Serial Comp |
@! |
|
|
R |
|
|
S |
VMB_PLAMAN |
C |
18 |
0 |
Plano Manut |
@! |
|
|
R |
|
|
S |
VMB_INTSRV |
C |
4 |
0 |
Interv. Srvc |
@! |
Vazio() .or. FG_Seek("VX5","'014'+M->VMB_INTSRV",1,.F.,"M->VMB_INTSRD","VX5_DESCRI") |
VX5 |
R |
|
|
S |
VMB_INTSRD |
C |
30 |
0 |
Descricao |
@! |
|
|
V |
|
|
S |
VMB_USOPEC |
N |
16 |
0 |
Uso da Peca |
@E 9,999,999,999,999,999 |
|
|
R |
|
|
S |
VMB_UNUSPC |
C |
6 |
0 |
Un. Uso Peca |
@! |
Vazio() .or. ExistCPO("VX5","005"+M->VMB_UNUSPC) |
VX5 |
R |
|
|
S |
VMB_TESRES |
C |
20 |
0 |
Result. Test |
@! |
|
|
R |
|
M->VMB_TIPGAR="ZZBT" |
S |
VMB_DTFALH |
D |
8 |
0 |
Dt. da Falha |
|
|
|
R |
|
|
S |
VMB_FALHA |
C |
2 |
0 |
Cod. Falha |
@! |
Vazio() .or. OFNJD15VLD() |
VX5 |
R |
|
|
S |
VMB_FALHAD |
C |
30 |
0 |
Desc. Falha |
@! |
|
|
V |
|
|
S |
VMB_FALCOM |
C |
40 |
0 |
Coment Falha |
@! |
|
|
R |
|
|
S |
VMB_ALTMED |
N |
5 |
0 |
Alt.M. Talao |
@E 99,999 |
|
|
R |
|
|
S |
VMB_UNIALT |
C |
6 |
0 |
Unid. Altura |
@! |
|
|
R |
|
|
S |
VMB_FALARE |
C |
40 |
0 |
Area Falha |
@! |
|
|
R |
|
|
S |
VMB_MAQPAR |
C |
2 |
0 |
Tempo Parada |
@! |
Vazio() .or. FG_Seek("VX5","'012'+M->VMB_MAQPAR",1,.F.,"M->VMB_MAQPAD","VX5_DESCRI") |
VX5 |
R |
|
|
S |
VMB_MAQPAD |
C |
30 |
0 |
Descricao |
@! |
|
|
V |
|
|
S |
VMB_DTACCS |
C |
20 |
0 |
Caso DTAC |
@! |
|
|
R |
|
|
S |
VMB_DTACSL |
C |
10 |
0 |
Solucao DTAC |
@! |
|
|
R |
|
|
S |
VMB_OSANTE |
C |
8 |
0 |
OS Anterior |
@! |
Vazio() .or. OFNJD15VLD() |
VO1 |
R |
|
M->VMB_INSPOR $ "D/R" |
S |
VMB_SRANTE |
C |
3 |
0 |
Serie NF Ant |
!!! |
Vazio() .or. OFNJD15VLD() |
|
R |
|
M->VMB_INSPOR == "C" |
S |
VMB_NFANTE |
C |
9 |
0 |
NF Anterior |
@! |
Vazio() .or. OFNJD15VLD() |
|
R |
|
M->VMB_INSPOR == "C" |
S |
VMB_DATMAN |
D |
8 |
0 |
Data Reparo |
|
|
|
R |
|
|
S |
VMB_TIPESP |
C |
2 |
0 |
Tp. Especial |
@! |
Vazio() .or. FG_Seek("VX5","'013'+M->VMB_TIPESP",1,.F.,"M->VMB_TIPESD","VX5_DESCRI") |
VX5 |
R |
|
M->VMB_TIPGAR="ZSPA" |
S |
VMB_TIPESD |
C |
30 |
0 |
Descricao |
@! |
|
|
V |
|
|
S |
VMB_TOTALG |
N |
11 |
2 |
Total S.G. |
@E 99,999,999.99 |
|
|
R |
|
|
S |
VMB_TOTALD |
N |
11 |
2 |
Total Distr. |
@E 99,999,999.99 |
|
|
R |
|
|
S |
VMB_CLIVAL |
N |
11 |
2 |
Cliente (R$) |
@E 99,999,999.99 |
Vazio() .or. OFNJD15VLD() |
|
R |
|
M->VMB_TIPGAR="ZSPA" |
S |
VMB_CLIPER |
N |
6 |
2 |
Cliente (%) |
@E 999.99 |
Vazio() .or. OFNJD15VLD() |
|
R |
|
M->VMB_TIPGAR="ZSPA" |
S |
VMB_CLIVAR |
N |
11 |
2 |
Cli. Ret (R$ |
@E 99,999,999.99 |
|
|
R |
|
|
S |
VMB_CONVAL |
N |
11 |
2 |
Conces. (R$) |
@E 99,999,999.99 |
Vazio() .or. OFNJD15VLD() |
|
R |
|
M->VMB_TIPGAR="ZSPA" |
S |
VMB_CONPER |
N |
6 |
2 |
Conces. (%) |
@E 999.99 |
Vazio() .or. OFNJD15VLD() |
|
R |
|
M->VMB_TIPGAR="ZSPA" |
S |
VMB_CONVAR |
N |
11 |
2 |
Con. Ret(R$) |
@E 99,999,999.99 |
|
|
R |
|
|
S |
VMB_JDVAL |
N |
11 |
2 |
J. Deere (R$ |
@E 99,999,999.99 |
Vazio() .or. OFNJD15VLD() |
|
R |
|
M->VMB_TIPGAR="ZSPA" |
S |
VMB_JDPER |
N |
6 |
2 |
J. Deere (%) |
@E 999.99 |
Vazio() .or. OFNJD15VLD() |
|
R |
|
M->VMB_TIPGAR="ZSPA" |
S |
VMB_JDVAR |
N |
11 |
2 |
J.D. Ret(R$) |
@E 99,999,999.99 |
|
|
R |
|
|
S |
VMB_QUEOBS |
M |
47 |
0 |
Rec Operador |
@! |
|
|
V |
|
|
S |
VMB_QUEMEM |
C |
6 |
0 |
Rec Operador |
@! |
|
|
R |
|
|
S |
VMB_CAUOBS |
M |
47 |
0 |
Causa Falha |
@! |
|
|
V |
|
|
S |
VMB_CAUMEM |
C |
6 |
0 |
Causa Falha |
@! |
|
|
R |
|
|
S |
VMB_COROBS |
M |
47 |
0 |
Correcao |
@! |
|
|
V |
|
|
S |
VMB_CORMEM |
C |
6 |
0 |
Correcao |
@! |
|
|
R |
|
|
S |
VMB_ESPOBS |
M |
47 |
0 |
Reg. Acordo |
@! |
|
|
V |
|
|
S |
VMB_ESPMEM |
C |
6 |
0 |
Reg. Acordo |
@! |
|
|
R |
|
|
S |
VMB_NOTRAV |
C |
1 |
0 |
Deslocamento |
@! |
|
|
R |
0=Nao;1=Sim |
|
S |
VMB_CODDBS |
C |
10 |
0 |
Codigo DBS |
@! |
|
|
R |
|
|
S |
VMB_DTWMEM |
D |
8 |
0 |
Dt. Proc. WM |
|
|
|
R |
|
|
S |
VMB_WARRME |
C |
70 |
0 |
Warranty M. |
@! |
|
|
R |
|
|
S |
VMB_SRVSNF |
C |
3 |
0 |
Serie NF Srv |
!!! |
|
|
R |
|
|
S |
VMB_SRVNNF |
C |
9 |
0 |
Num. NF Srv |
@! |
|
|
R |
|
|
S |
VMB_WAROBS |
M |
80 |
0 |
Obs. WM |
@! |
|
|
V |
|
|
S |
VMB_WARMEM |
C |
6 |
0 |
Obs. WM |
@! |
|
|
R |
|
|
S |
VMB_STOTPC |
N |
11 |
2 |
Sub-Tot Pc |
@E 99,999,999.99 |
|
|
R |
|
|
S |
VMB_ADITPC |
N |
11 |
2 |
Aditivo Pc |
@E 99,999,999.99 |
|
|
R |
|
|
S |
VMB_RETEPC |
N |
11 |
2 |
Retencao Pc |
@E 99,999,999.99 |
|
|
R |
|
|
S |
VMB_TOTAPC |
N |
11 |
2 |
Total Pc |
@E 99,999,999.99 |
|
|
R |
|
|
S |
VMB_STOTSV |
N |
11 |
2 |
Sub-Tot Srv |
@E 99,999,999.99 |
|
|
R |
|
|
S |
VMB_ADITSV |
N |
11 |
2 |
Aditivo Srv |
@E 99,999,999.99 |
|
|
R |
|
|
S |
VMB_RETESV |
N |
11 |
2 |
Retencao Srv |
@E 99,999,999.99 |
|
|
R |
|
|
S |
VMB_TOTASV |
N |
11 |
2 |
Total Srv |
@E 99,999,999.99 |
|
|
R |
|
|
S |
VMB_DESLOC |
N |
11 |
2 |
Deslocamento |
@E 99,999,999.99 |
|
|
R |
|
|
S |
VMB_OUTRAS |
N |
11 |
2 |
Outras Desp. |
@E 99,999,999.99 |
|
|
R |
|
|
S |
VMB_TOTALW |
N |
11 |
2 |
Total Gar. |
@E 99,999,999.99 |
|
|
R |
|
|
S |
VMB_REMPEC |
C |
1 |
0 |
Remessa Peca |
@! |
Vazio() .or. Pertence("01") |
|
R |
0=Nao;1=Sim |
|
S |
VMB_MREEMP |
N |
11 |
2 |
M. Reem Peca |
@E 99,999,999.99 |
|
|
R |
|
|
S |
VMB_MREEMS |
N |
11 |
2 |
M. Reem Srvc |
@E 99,999,999.99 |
|
|
R |
|
|
S |
VMB_SDOC |
C |
3 |
0 |
Serie NF Srv |
!!! |
|
|
R |
|
|
S |
VMB_SDOCA |
C |
3 |
0 |
Serie NF Ant |
!!! |
|
|
R |
|
|
S |
VMB_SREEMB |
C |
1 |
0 |
Sem Reemb. |
@! |
Vazio() .or. Pertence("01") |
|
R |
0=Nao;1=Sim |
|
S |