Tabela |
QE6 |
Insp.Entradas - Especificacoes |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
QE6_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
N |
QE6_PRODUT |
C |
15 |
0 |
Produto |
@! |
QIE010VlPr() .And. QIE010Chav() |
ALT |
|
|
|
N |
QE6_REVI |
C |
2 |
0 |
Revisao |
@! |
QIE010Chav() |
|
|
|
A010WhRv() |
N |
QE6_REVINV |
C |
2 |
0 |
Revisao Inv. |
@! |
|
|
|
|
|
N |
QE6_DESCPO |
C |
40 |
0 |
Descricao |
|
|
|
|
|
|
N |
QE6_DESCIN |
C |
40 |
0 |
Desc. Ingles |
|
|
|
|
|
|
N |
QE6_DESCES |
C |
40 |
0 |
Desc. Espan. |
|
|
|
|
|
|
N |
QE6_TIPO |
C |
2 |
0 |
Tipo |
@! |
ExistCpo("SX5","02"+M->QE6_TIPO) |
02 |
|
|
|
N |
QE6_BITMAP |
C |
8 |
0 |
Foto |
|
|
|
|
|
|
N |
QE6_APLIC |
C |
12 |
0 |
Aplicacao |
|
|
|
|
|
|
N |
QE6_CROQUI |
C |
40 |
0 |
Croqui |
|
|
|
|
|
|
N |
QE6_DTCAD |
D |
8 |
0 |
Data Atualiz |
|
|
|
|
|
|
N |
QE6_DTINI |
D |
8 |
0 |
In. Vigencia |
|
A010VIni(M->QE6_PRODUT,M->QE6_REVI,M->QE6_DTINI) |
|
|
|
A010WhIn(.t.) |
N |
QE6_DTDES |
D |
8 |
0 |
Data Desenho |
|
|
|
|
|
|
N |
QE6_RVDES |
C |
2 |
0 |
Rev. Desenho |
@! |
|
|
|
|
|
N |
QE6_PTOLER |
N |
6 |
2 |
Porc.Toler. |
@E 999.99 |
M->QE6_PTOLER >= 0.00 .and. M->QE6_PTOLER <= 100.00 |
|
|
|
|
N |
QE6_PEDEST |
N |
6 |
2 |
Porc.Destrut |
@E 999.99 |
M->QE6_PEDEST >= 0.00 .and. M->QE6_PEDEST <= 100.00 |
|
|
|
|
N |
QE6_DOCOBR |
C |
1 |
0 |
Doc. Obrigat |
! |
Pertence("SN") |
|
|
S=Sim;N=Nao |
|
N |
QE6_SHLF |
N |
4 |
0 |
Shelf_life |
9999 |
M->QE6_SHLF >= 0 |
|
|
|
|
N |
QE6_UNSHEL |
C |
1 |
0 |
Un. Sh. Life |
@! |
Pertence("123") |
|
|
1=Dia;2=Mes;3=Ano |
|
N |
QE6_UNMED1 |
C |
2 |
0 |
Un. Medida 1 |
|
ExistCpo("SAH",M->QE6_UNMED1) |
SAH |
|
|
QE010WU1() |
N |
QE6_DUNME1 |
C |
9 |
0 |
Des.Un.Med.1 |
|
|
|
V |
|
|
N |
QE6_UNAMO1 |
C |
2 |
0 |
Un. Amostr.1 |
|
ExistCpo("SAH",M->QE6_UNAMO1) |
SAH |
|
|
QE010WU3() |
N |
QE6_DUNAM1 |
C |
9 |
0 |
Des.Un.Amo.1 |
|
|
|
V |
|
|
N |
QE6_FATCO1 |
C |
6 |
0 |
Fat. Conv. 1 |
|
QE010VlFc(1) |
|
|
|
A010WFC1() |
N |
QE6_TIPCO1 |
C |
1 |
0 |
Tipo Conv. 1 |
! |
Pertence("MD") |
|
|
M=Multiplicador;D=Divisor |
A010WFC1() |
N |
QE6_UNMED2 |
C |
2 |
0 |
Un. Medida 2 |
|
Iif(!Empty(M->QE6_UNMED2),ExistCpo("SAH",M->QE6_UNMED2),.t.) |
SAH |
|
|
QE010WU2() |
N |
QE6_DUNME2 |
C |
9 |
0 |
Des.Un.Med.2 |
|
|
|
V |
|
|
N |
QE6_UNAMO2 |
C |
2 |
0 |
Un. Amostr.2 |
|
Iif(!Empty(M->QE6_UNAMO2),ExistCpo("SAH",M->QE6_UNAMO2),.t.) |
SAH |
|
|
QE010WU4() |
N |
QE6_DUNAM2 |
C |
9 |
0 |
Des.Un.Amo.2 |
|
|
|
V |
|
|
N |
QE6_FATCO2 |
C |
6 |
0 |
Fat. Conv. 2 |
|
QE010VlFc(2) |
|
|
|
A010WFC2() |
N |
QE6_TIPCO2 |
C |
1 |
0 |
Tipo Conv. 2 |
! |
Pertence("MD") |
|
|
M=Multiplicador;D=Divisor |
A010WFC2() |
N |
QE6_CHAVE |
C |
8 |
0 |
Cod. Ligacao |
99999999 |
|
|
|
|
|
N |
QE6_SITREV |
C |
1 |
0 |
Situacao Esp |
@! |
Pertence("012") .and. M->QE6_SITREV<>"2" |
|
R |
0=Disponivel;1=Bloqueado;2=Pendente |
|
N |