Tabela |
VS4 |
Itens de Orcamento (Servicos) |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
VS4_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
VS4_SEQINC |
C |
3 |
0 |
Seq. Inconv. |
@! |
|
|
R |
|
|
S |
VS4_GRUINC |
C |
3 |
0 |
Grupo Incon. |
@!S3 |
FG_Seek("VSK","VV1->VV1_CODMAR+M->VS4_GRUINC",1,.f.) |
VSK |
V |
|
|
S |
VS4_CODINC |
C |
8 |
0 |
Cod. Incon. |
@! |
FG_Seek("VSL","VV1->VV1_CODMAR+M->VS4_GRUINC+M->VS4_CODINC",1,.f.) |
VSL |
V |
|
|
S |
VS4_DESINC |
C |
120 |
0 |
Descr Inconv |
@!S30 |
|
|
V |
|
|
S |
VS4_SEQUEN |
C |
3 |
0 |
Sequencia |
@!S3 |
|
|
R |
|
|
S |
VS4_NUMORC |
C |
8 |
0 |
Nro Orcam/o |
@ 99999999 |
|
|
|
|
|
S |
VS4_GRUSER |
C |
2 |
0 |
Grupo Servic |
@!S2 |
OX001GRSER(VV1->VV1_CODMAR,M->VS4_CODSER) |
VS4 |
|
|
|
S |
VS4_CODSER |
C |
15 |
0 |
Cod Servico |
@!S15 |
OX001SERV(VV1->VV1_CODMAR,M->VS4_CODSER) .AND. FG_CHEREV() |
V61 |
|
|
|
S |
VS4_DESSER |
C |
20 |
0 |
Descricao |
@!S20 |
|
|
V |
|
|
S |
VS4_SEQSER |
C |
6 |
0 |
Seq.Servico |
@! |
|
|
R |
|
|
S |
VS4_TIPSER |
C |
3 |
0 |
Tipo Servico |
@!S3 |
FG_Seek("VOK","M->VS4_TIPSER",1,.f.).AND.FS_PRECPO("S") |
VOK |
|
|
|
S |
VS4_CODSEC |
C |
3 |
0 |
Secao Oficin |
@! |
FG_Seek("VOD","M->VS4_CODSEC",1,.f.) |
VOD |
R |
|
|
N |
VS4_TEMPAD |
N |
5 |
0 |
Tempo Padrao |
@R 999:99 |
|
|
|
|
VOK->VOK_INCTEM=="4" |
S |
VS4_VALHOR |
N |
8 |
2 |
Vl da Hora |
@E 99,999.99 |
|
|
|
|
|
S |
VS4_KILROD |
N |
8 |
0 |
Km Rodado |
@e 99,999,999 |
|
|
|
|
VOK->VOK_INCMOB=="5" |
S |
VS4_VALSER |
N |
12 |
2 |
Vl Servico |
@E 999,999,999.99 |
|
|
|
|
VOK->VOK_INCMOB=="7" |
S |
VS4_PERDES |
N |
6 |
2 |
% Desc |
@E 999.99 |
POSITIVO() |
|
|
|
|
S |
VS4_VALDES |
N |
12 |
2 |
Vl Desconto |
@E 999,999,999.99 |
|
|
|
|
|
S |
VS4_VALTOT |
N |
12 |
2 |
Vl Total |
@E 999,999,999.99 |
|
|
|
|
|
S |
VS4_CODFOR |
C |
6 |
0 |
Fornecedor |
@! |
Vazio() .or. FG_Seek("SA2","M->VS4_CODFOR",1,.f.) |
|
R |
|
VOK->VOK_INCMOB=="2" |
S |
VS4_FOLOJA |
C |
2 |
0 |
Loja Fornec |
@! |
FG_Seek("SA2","M->VS4_CODFOR+M->VS4_FOLOJA",1,.f.,"VS4_NOMFOR","A2_NREDUZ") |
|
R |
|
VOK->VOK_INCMOB=="2" |
S |
VS4_NOMFOR |
C |
30 |
0 |
Nome |
@!S30 |
|
|
V |
|
VOK->VOK_INCMOB=="2" |
S |
VS4_NUMTIT |
C |
9 |
0 |
Nro Docto |
@! |
NaoVazio() |
|
R |
|
VOK->VOK_INCMOB=="2" |
S |
VS4_TIPTIT |
C |
3 |
0 |
Tipo |
@! |
|
05 |
R |
|
VOK->VOK_INCMOB=="2" |
S |
VS4_NATURE |
C |
10 |
0 |
Natureza |
@! |
Vazio() .or. FG_Seek("SED","M->VS4_NATURE") |
SED |
R |
|
VOK->VOK_INCMOB=="2" |
S |
VS4_CODPAG |
C |
3 |
0 |
Cond Pagto |
@! |
FG_Seek("SE4","M->VS4_CODPAG",1,.f.) |
SE4 |
R |
|
VOK->VOK_INCMOB=="2" |
S |
VS4_VALCUS |
N |
12 |
2 |
Vl do Custo |
@E 999,999,999.99 |
|
|
R |
|
VOK->VOK_INCMOB=="2" |
S |
VS4_VALVEN |
N |
12 |
2 |
Vl da Venda |
@E 999,999,999.99 |
|
|
R |
|
VOK->VOK_INCMOB=="2" |
S |
VS4_DATPAG |
D |
8 |
0 |
Data Pgto. |
|
|
|
R |
|
VOK->VOK_INCMOB=="2" |
S |
VS4_DEPGAR |
C |
1 |
0 |
Depto Garant |
@! |
Vazio() .or. FG_Seek("SX5","'VF'+M->VS4_DEPGAR",1,.f.) |
VF |
R |
|
|
S |
VS4_DEPINT |
C |
1 |
0 |
Depto Intern |
@! |
Vazio() .or. FG_Seek("SX5","'VD'+M->VS4_DEPINT",1,.f.) |
VD |
R |
|
|
S |
VS4_OBSERV |
M |
100 |
0 |
Observacao |
@! |
|
|
V |
|
|
S |
VS4_OBSMEM |
C |
6 |
0 |
Oco-MEMO |
|
|
|
R |
|
|
S |