Tabela |
SS5 |
Dados Adicionais do Produto |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
S5_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
R |
|
|
S |
S5_COD |
C |
15 |
0 |
Produto |
@! |
existcpo("SS4").and.existchav("SS5") .and. Freeforuse("SS5") |
SB1 |
R |
|
|
S |
S5_PRV2 |
N |
14 |
2 |
Preco Venda2 |
@E 99,999,999,999.99 |
positivo() .and. A010Preco() |
|
R |
|
|
S |
S5_PRV3 |
N |
14 |
2 |
Preco Venda3 |
@E 99,999,999,999.99 |
positivo() .and. A010Preco() |
|
R |
|
|
S |
S5_PRV4 |
N |
14 |
2 |
Preco Venda4 |
@E 99,999,999,999.99 |
positivo() .and. A010Preco() |
|
R |
|
|
S |
S5_PRV5 |
N |
14 |
2 |
Preco Venda5 |
@E 99,999,999,999.99 |
positivo() .and. A010Preco() |
|
R |
|
|
S |
S5_PRV6 |
N |
14 |
2 |
Preco Venda6 |
@E 99,999,999,999.99 |
positivo() .and. A010Preco() |
|
R |
|
|
S |
S5_PRV7 |
N |
14 |
2 |
Preco Venda7 |
@E 99,999,999,999.99 |
positivo() .and. A010Preco() |
|
R |
|
|
S |
S5_CEME |
C |
200 |
0 |
Nome Cientif |
@!S45 |
|
|
R |
|
|
S |
S5_CODCLI |
C |
15 |
0 |
Cod no Clien |
@! |
|
|
R |
|
|
S |
S5_CERT |
C |
1 |
0 |
Tem Certif. |
@! |
Pertence("SN") |
|
R |
1=Sim;2=Nao |
|
S |
S5_COMPR |
N |
9 |
2 |
Comprimento |
@E 999999.99 |
positivo() .and. IF(cModulo="EIC",TP254Val(10),.T.) |
|
R |
|
|
S |
S5_DES |
C |
15 |
0 |
Cod.Desenho |
@! |
|
|
R |
|
|
S |
S5_EMB1 |
C |
10 |
0 |
Embalagem 1 |
@! |
|
|
R |
|
|
S |
S5_EMB2 |
C |
10 |
0 |
Embalagem 2 |
@! |
|
|
R |
|
|
S |
S5_ESPESS |
N |
9 |
2 |
Espessura |
@E 999999.99 |
positivo() .and. If(cModulo="EIC",TP254Val(10),.T.) |
|
R |
|
|
S |
S5_ESTMAT |
C |
1 |
0 |
Estado Fisic |
@! |
|
|
R |
S=Solido;L=Liquido;G=Gasoso |
|
S |
S5_LARG |
N |
9 |
2 |
Largura |
@E 999999.99 |
positivo() .and. If(cModulo="EIC",TP254Val(10),.T.) |
|
R |
|
|
S |
S5_QE1 |
N |
5 |
0 |
Qtd.Embalag1 |
99999 |
positivo() |
|
R |
|
|
S |
S5_QE2 |
N |
5 |
0 |
Qtd.Embalag2 |
99999 |
positivo() |
|
R |
|
|
S |
S5_CONVDIP |
N |
9 |
4 |
Conv.DIPI |
@E 9999.9999 |
positivo() |
|
R |
|
|
S |
S5_UMDIPI |
C |
2 |
0 |
UM DIPI |
|
vazio() .or. existCpo("SAH") |
SAH |
R |
|
|
S |
S5_DTREFP2 |
D |
8 |
0 |
Dt.Ref.Prc 2 |
|
|
|
|
|
|
S |
S5_CARPER |
C |
1 |
0 |
Car.Perigosa |
@! |
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
S5_DTREFP3 |
D |
8 |
0 |
Dt.Ref.Prc 3 |
|
|
|
R |
|
|
S |
S5_IDADEM |
N |
2 |
0 |
Idade Maxima |
99 |
positivo() |
|
R |
|
|
S |
S5_DTREFP4 |
D |
8 |
0 |
Dt.Ref.Prc 4 |
|
|
|
R |
|
|
S |
S5_DTREFP5 |
D |
8 |
0 |
Dt.Ref.Prc 5 |
|
|
|
R |
|
|
S |
S5_DTREFP6 |
D |
8 |
0 |
Dt.Ref.Prc 6 |
|
|
|
R |
|
|
S |
S5_DTREFP7 |
D |
8 |
0 |
Dt.Ref.Prc 7 |
|
|
|
R |
|
|
S |
S5_COMPRLC |
N |
9 |
2 |
Compr.Armaz. |
@E 999999.99 |
positivo() |
|
R |
|
|
S |
S5_LARGLC |
N |
9 |
2 |
Largu.Armaz. |
@E 999999.99 |
positivo() |
|
R |
|
|
S |
S5_ALTURLC |
N |
9 |
2 |
Altur.Armaz. |
@E 999999.99 |
positivo() |
|
R |
|
|
S |
S5_FATARMA |
N |
5 |
2 |
Fator Armaz. |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
S5_EMPMAX |
N |
5 |
2 |
Empilhagem |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
S5_ROTACAO |
C |
1 |
0 |
Rotaciona Pr |
@! |
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
S5_VOLUME |
N |
11 |
5 |
Volume M3 |
@E 99,999.99999 |
|
|
V |
|
|
S |
S5_CODCAI |
C |
6 |
0 |
C.A.I. |
@ 999999 |
|
|
R |
|
|
S |
S5_LOCALIZ |
C |
15 |
0 |
Endereco |
|
|
|
|
|
|
S |
S5_CODGRP |
C |
4 |
0 |
Grupo |
@!!!! |
VldAuxCod1("S5_CODGRP","S5_CODITE") |
SBM |
V |
|
Inclui |
S |
S5_CODITE |
C |
27 |
0 |
Cod.Produto |
|
VldAuxCod2("S5_COD","S5_CODGRP") |
B00 |
V |
|
Inclui |
S |
S5_CODZON |
C |
6 |
0 |
Zona Armaz. |
@! |
ExistCpo("DC4",M->S5_CODZON) |
DC4 |
R |
|
|
S |
S5_UMIND |
C |
1 |
0 |
UM.Industria |
9 |
Pertence('12') |
|
R |
1=1a Unidade de Medida;2=2a Unidade de Medida |
|
S |
S5_SERVENT |
C |
3 |
0 |
Serv.Entrada |
@! |
ExistCPO('DC5').And.DC5->DC5_TIPO=='1' |
DC5 |
R |
|
|
S |
S5_SERVINT |
C |
3 |
0 |
Serv.Interno |
@! |
ExistCPO('DC5').And.DC5->DC5_TIPO=='3' |
DC5 |
R |
|
|
S |
S5_SERVSAI |
C |
3 |
0 |
Serv.Saida |
@! |
ExistCPO('DC5').And.DC5->DC5_TIPO=='2' |
DC5 |
R |
|
|
S |
S5_LVLEMB |
N |
14 |
2 |
Lim.Val. Emb |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
S5_LPSEMB |
N |
11 |
4 |
Lim.Peso Emb |
@E 999,999.9999 |
|
|
R |
|
|
S |
S5_PERCUB |
N |
6 |
2 |
Per.Cubagem |
@E 999.99% |
|
|
R |
|
|
S |
S5_IMPGRUP |
C |
1 |
0 |
Imp.Produto |
@! |
|
|
R |
|
|
S |
S5_BENDL |
C |
1 |
0 |
Benf. DLL |
@! |
|
|
R |
|
|
S |
S5_PINSUMO |
C |
1 |
0 |
PINSUMO |
@! |
|
|
R |
|
|
S |
S5_PORTMS |
C |
1 |
0 |
Portal TMS? |
|
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
N |
S5_PRODDNF |
N |
3 |
0 |
Codigo DNF |
999 |
|
|
R |
|
|
S |
S5_NPULMAO |
C |
1 |
0 |
Pulmao |
@! |
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
S5_INSUMO |
N |
3 |
0 |
Cod. Insumo |
@E 999 |
|
|
R |
|
|
S |
S5_VOLRECI |
N |
5 |
0 |
Volume Rec. |
@E 99999 |
|
|
R |
|
|
S |
S5_CODISRF |
N |
6 |
0 |
Codigo SRF |
@E 999999 |
|
|
|
|
|
S |
S5_USOITE |
C |
1 |
0 |
Uso do Item |
@! |
pertence("CI") |
|
R |
C=Comercial;I=Industrial |
|
S |
S5_LOCALI2 |
C |
15 |
0 |
Loc.Secundar |
|
|
|
R |
|
|
S |
S5_CONCENT |
N |
6 |
2 |
Concentracao |
@E 999.99 |
|
|
R |
|
|
S |
S5_DENSID |
N |
6 |
2 |
Densidade |
@E 999.99 |
|
|
R |
|
|
S |
S5_FTIN |
N |
7 |
2 |
FTI Nacional |
@E 9999.99 |
|
|
R |
|
|
S |
S5_FTIF |
N |
7 |
2 |
FTI Fat. |
@E 9999.99 |
|
|
R |
|
|
S |
S5_PROPOR1 |
N |
7 |
2 |
Proporcao1 |
@E 9999.99 |
|
|
R |
|
|
S |
S5_PROPOR2 |
N |
7 |
2 |
Proporcao2 |
@E 9999.99 |
|
|
R |
|
|
S |
S5_CRDEST1 |
N |
7 |
2 |
% Estimulo |
@E 9999.99 |
|
|
R |
|
|
S |
S5_CRDEST2 |
N |
7 |
2 |
% Estimulo 2 |
@E 9999.99 |
|
|
R |
|
|
S |
S5_SERVEMB |
C |
3 |
0 |
Servico/Emb. |
999 |
WmsVldSrv("1",M->S5_SERVEMB) |
DC5 |
|
|
|
S |
S5_CALORIA |
N |
7 |
2 |
Bas Calorica |
@E 9999.99 |
Positivo() |
|
R |
|
|
S |
S5_PESO |
N |
12 |
4 |
Peso |
@E 9999999.9999 |
Positivo() |
|
R |
|
|
S |
S5_TOTGOR |
N |
7 |
2 |
Gordura |
@E 9999.99 |
Positivo() |
|
R |
|
|
S |
S5_TOTGORS |
N |
7 |
2 |
Gor Saturada |
@E 9999.99 |
Positivo() |
|
R |
|
|
S |
S5_TOTGORT |
N |
7 |
2 |
Gor Trans |
@E 9999.99 |
Positivo() |
|
R |
|
|
S |
S5_COR |
C |
15 |
0 |
Cor |
@! |
|
|
R |
|
|
S |
S5_ALTURA |
N |
9 |
2 |
Altura |
@E 999999.99 |
Positivo() |
|
R |
|
|
S |
S5_MODELO |
C |
30 |
0 |
Modelo |
@! |
|
|
R |
|
|
S |
S5_ESPECIE |
C |
5 |
0 |
Especie Prod |
@! |
|
|
R |
|
|
S |
S5_QUALIDA |
C |
5 |
0 |
Qualidade |
@! |
|
|
R |
|
|
S |
S5_ONU |
C |
4 |
0 |
N. ONU |
@! |
ExistCpo("DY3",M->S5_ONU) |
DY3 |
R |
|
|
S |
S5_ITEM |
C |
2 |
0 |
Item |
@! |
ExistCpo("DY3",M->S5_ONU+M->S5_ITEM) |
|
R |
|
|
S |
S5_CODTP |
C |
3 |
0 |
Cod Tp Merc |
@! |
|
|
R |
|
|
S |
S5_CMPEXTR |
C |
1 |
0 |
Prod. Extrat |
|
|
|
R |
|
|
S |
S5_EAN141 |
N |
6 |
0 |
Qtd 1 EAN14 |
999999 |
|
|
R |
|
|
N |
S5_EAN142 |
N |
6 |
0 |
Qtd 2 EAN14 |
999999 |
|
|
R |
|
|
N |
S5_EAN143 |
N |
6 |
0 |
Qtd 3 EAN14 |
999999 |
|
|
R |
|
|
N |
S5_EAN144 |
N |
6 |
0 |
Qtd 4 EAN14 |
999999 |
|
|
R |
|
|
N |
S5_EAN145 |
N |
6 |
0 |
Qtd 5 EAN14 |
999999 |
|
|
R |
|
|
N |
S5_EAN146 |
N |
6 |
0 |
Qtd 6 EAN14 |
999999 |
|
|
R |
|
|
N |
S5_EAN147 |
N |
6 |
0 |
Qtd 7 EAN14 |
999999 |
|
|
R |
|
|
N |
S5_EAN148 |
N |
6 |
0 |
Qtd 8 EAN14 |
999999 |
|
|
R |
|
|
N |
S5_TIPUNIT |
C |
1 |
0 |
Tipo Unit. |
|
|
|
R |
|
|
N |
S5_QTDVAR |
C |
1 |
0 |
Qtd Variavel |
@! |
|
|
R |
1=Sim;2=Nao |
|
N |
S5_IMPETI |
C |
1 |
0 |
Imprime ETI |
@! |
|
|
R |
1=Sim;2=Nao |
|
N |
S5_VLDOPER |
C |
1 |
0 |
Valida Seq |
@! |
"1" |
|
R |
1=Sim;2=Nao |
|
N |
S5_VLDREQ |
C |
1 |
0 |
Valida Req |
@! |
|
|
R |
1=Valida na primeira operacao; 2=Valida na ultima operacao; 3= Nao Valida |
|
N |
S5_DTINV |
D |
8 |
0 |
Data Invent. |
|
|
|
R |
|
|
N |
S5_PERIOT |
C |
3 |
0 |
Periodo |
999 |
|
|
R |
|
|
N |
S5_NSERIE |
C |
1 |
0 |
Num.serie |
@! |
Pertence("SN") |
|
R |
1=Sim;2=Nao |
|
N |
S5_QEI |
N |
9 |
0 |
Qtd.Emb.Imp. |
@ 999,999,999 |
Positivo() |
|
R |
|
|
N |
S5_QEL |
N |
9 |
0 |
Qtd.Emb.Lei. |
@ 999,999,999 |
Positivo() |
|
R |
|
|
N |
S5_CDDMDBA |
C |
5 |
0 |
Cod.DMD-BA |
@! |
|
|
R |
|
|
S |
S5_SITDIEF |
C |
2 |
0 |
Cod.Sit.DIEF |
@! |
Pertence(" 01020304050607") |
|
R |
|
|
S |
S5_DESCNFE |
M |
10 |
0 |
Inf.Ad.Prod. |
@! |
|
|
R |
|
|
N |
S5_TABINC |
C |
2 |
0 |
Cod.Tab.Inc. |
@! |
Pertence(" 01/02/03/04/05/06/07/08/09/10/11/12") |
|
R |
|
|
S |
S5_CODGRU |
C |
2 |
0 |
Cod. Grupo |
@1 |
|
|
R |
|
|
S |
S5_MARCA |
C |
60 |
0 |
Marca |
@! |
|
|
R |
|
|
S |
S5_DIASHL |
N |
3 |
0 |
Horiz.Liber. |
@E 999 |
Positivo() |
|
R |
|
|
S |
S5_DIASHF |
N |
3 |
0 |
Horiz.Firme |
@E 999 |
Positivo() |
|
R |
|
|
S |
S5_REVPROD |
C |
1 |
0 |
Rev.Estrutur |
@! |
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
S5_PRZCQ |
N |
2 |
0 |
Prazo CQ |
99 |
Positivo() |
|
R |
|
|
S |
S5_FORMMRP |
C |
1 |
0 |
Form. MRP |
@! |
Pertence('123') |
|
R |
1=Pelo programa;2=Por OP;3=Por necessidade |
|
S |
S5_CODATIV |
C |
8 |
0 |
Cod. Ativ. |
@! |
ExistCpo("CG1") |
|
R |
|
|
S |
S5_MONTA |
C |
1 |
0 |
Montagem ? |
9 |
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
S5_INSPAT |
C |
1 |
0 |
INSS Patron |
@! |
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
S5_FPRZCQ |
C |
3 |
0 |
Form. Prz CQ |
|
ExistCpo("SM4") |
SM4 |
R |
|
|
S |
S5_BLQINVD |
N |
2 |
0 |
Dias Blq Inv |
@E 99 |
Positivo() |
|
R |
|
|
S |
S5_AGLUMRP |
C |
1 |
0 |
Aglu. MRP |
@! |
ExistCpo("SX5","LU"+M->S5_AGLUMRP) |
LU |
R |
|
|
S |
S5_DIASES |
N |
3 |
0 |
Dias p/ ES |
@E 999 |
Positivo() |
|
R |
|
|
S |
S5_BLQINVA |
C |
1 |
0 |
Blq. Invent. |
|
Pertence('12') |
|
R |
1=Sim;2=Nao |
|
S |
S5_VERSAO |
C |
3 |
0 |
Versao |
@! |
|
|
R |
|
|
S |
S5_GRPIVA |
C |
3 |
0 |
Grupo IVA |
@! |
|
|
R |
|
|
S |
S5_IDHIST |
C |
20 |
0 |
ID.Hist. |
@! |
|
|
R |
|
|
S |
S5_AMMULTO |
N |
5 |
2 |
Mult.AM.Ou |
@E 99.99 |
|
|
R |
|
|
S |
S5_AMMULTS |
N |
5 |
2 |
Mult.AM.SE |
@E 99.99 |
|
|
R |
|
|
S |
S5_CODSERC |
C |
9 |
0 |
Cod SERC |
@! |
|
|
|
|
|
S |
S5_DESCSER |
M |
10 |
0 |
Desc. Serv. |
|
|
|
R |
|
|
S |
S5_ISEN |
C |
1 |
0 |
Prod.Isento |
@! |
Pertence(' 12') |
|
|
1=Sim;2=Nao |
|
S |
S5_ZFMULTO |
N |
5 |
2 |
Mult.ZF.Ou |
@E 99.99 |
|
|
R |
|
|
S |
S5_ZFMULTS |
N |
5 |
2 |
Mult.ZF.SE |
@E 99.99 |
|
|
R |
|
|
S |
S5_VLRCID |
N |
9 |
2 |
CIDE Pauta |
@E 999,999.99 |
Positivo() |
|
R |
|
|
S |