Tabela |
SS6 |
Indicadores de Produtos |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
S6_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
R |
|
|
S |
S6_COD |
C |
15 |
0 |
Codigo |
@! |
Existcpo("SB1") .And. existchav("SBZ") .And. Freeforuse("SBZ") |
SB1 |
R |
|
|
S |
S6_LOCPAD |
C |
2 |
0 |
Armazem Pad. |
@! |
ExistCpo("NNR") |
NNR |
R |
|
|
S |
S6_TE |
C |
3 |
0 |
TE Padrao |
@9 |
vazio().or.existcpo("SF4").And.M->S6_TE<="500" |
SF4 |
R |
|
|
S |
S6_TS |
C |
3 |
0 |
TS Padrao |
@9 |
vazio().or.existcpo("SF4").And.M->S6_TS>"500" |
SF4 |
R |
|
|
S |
S6_QE |
N |
9 |
0 |
Qtd.Embalag. |
@E 999,999,999 |
A018Mult() |
|
R |
|
|
S |
S6_EMIN |
N |
12 |
2 |
Ponto Pedido |
@E 999,999,999.99 |
|
|
R |
|
|
S |
S6_CUSTD |
N |
12 |
2 |
Custo Stand. |
@E 999,999,999.99 |
Positivo() |
|
R |
|
|
S |
S6_UCALSTD |
D |
8 |
0 |
Ult. Calculo |
|
|
|
R |
|
|
S |
S6_MCUSTD |
C |
1 |
0 |
Moeda C.Std |
@! |
Pertence("12345") |
|
R |
1=Moeda1;2=Moeda2;3=Moeda3;4=Moeda4;5=Moeda5 |
|
S |
S6_UCOM |
D |
8 |
0 |
Ult. Compra |
|
|
|
R |
|
|
S |
S6_ESTSEG |
N |
12 |
2 |
Seguranca |
@E 999,999,999.99 |
|
|
R |
|
|
S |
S6_ESTFOR |
C |
3 |
0 |
Form.Est.Seg |
@! |
vazio().or.existcpo("SM4") |
SM4 |
|
|
|
S |
S6_FORPRZ |
C |
3 |
0 |
Form. Prazo |
@! |
vazio().or.existcpo("SM4") |
SM4 |
R |
|
|
S |
S6_PE |
N |
5 |
0 |
Entrega |
@E 99,999 |
Positivo() |
|
R |
|
|
S |
S6_TIPE |
C |
1 |
0 |
Tipo Prazo |
@! |
|
|
R |
H=Horas;D=Dias;S=Semana;M=Mes;A=Ano |
|
S |
S6_LE |
N |
12 |
2 |
Lote Econom. |
@E 999,999,999.99 |
A018Mult() |
|
R |
|
|
S |
S6_LM |
N |
12 |
2 |
Lote Minimo |
@E 999,999,999.99 |
Positivo() |
|
R |
|
|
S |
S6_TOLER |
N |
3 |
0 |
Tolerancia |
999 |
Positivo() |
|
R |
|
|
S |
S6_CONINI |
D |
8 |
0 |
Cons.Inicial |
|
|
|
R |
|
|
S |
S6_DATREF |
D |
8 |
0 |
Dt. Referenc |
|
|
|
R |
|
|
S |
S6_EMAX |
N |
12 |
2 |
Estoq Maximo |
@E 999,999,999.99 |
Positivo() |
|
R |
|
|
S |
S6_UPRC |
N |
12 |
2 |
Ult. Preco |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
S |
S6_TIPOCQ |
C |
1 |
0 |
Tipo de C.Q. |
@! |
Pertence('MQ') .And. a010LotQlt() |
|
R |
M=Materiais;Q=SigaQuality |
|
S |
S6_QB |
N |
7 |
0 |
Base Estrut. |
9999999 |
Positivo() |
|
R |
|
|
S |
S6_PICM |
N |
5 |
2 |
Aliq. ICMS |
@E 99.99 |
|
|
|
|
|
S |
S6_VLR_ICM |
N |
14 |
2 |
ICMS pauta |
@E 99,999,999,999.99 |
Positivo() |
|
R |
|
|
N |
S6_INT_ICM |
N |
12 |
2 |
P.ICMS Prop. |
@E 999,999,999.99 |
Positivo() |
|
R |
|
|
S |
S6_PICMRET |
N |
5 |
2 |
Solid.Saida |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
S6_PICMENT |
N |
5 |
2 |
Solid. Entr. |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
S6_IPI |
N |
5 |
2 |
Aliq. IPI |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
S6_VLR_IPI |
N |
9 |
2 |
IPI de Pauta |
@E 999,999.99 |
Positivo() |
|
R |
|
|
N |
S6_REDPIS |
N |
5 |
2 |
Red. PIS |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
S6_REDCOF |
N |
5 |
2 |
Red. COFINS |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
S6_IRRF |
C |
1 |
0 |
Imp Renda |
@! |
|
|
R |
|
|
S |
S6_ORIGEM |
C |
1 |
0 |
Origem |
@! |
Vazio() .or. ExistCpo("SX5","S0"+M->S6_ORIGEM) |
S0 |
R |
|
|
S |
S6_GRTRIB |
C |
6 |
0 |
Grupo Trib. |
@! |
Vazio() .Or. ExistCpo("SX5","21"+M->S6_GRTRIB) |
|
R |
|
|
N |
S6_ALIQISS |
N |
5 |
2 |
ALIQ. ISS |
@E 99.99 |
|
|
R |
|
|
S |
S6_ALFUMAC |
N |
5 |
2 |
ALQ. FUMACOP |
@E 99.99 |
|
|
R |
|
|
S |
S6_OPC |
C |
80 |
0 |
Opc. Default |
@!S40 |
|
|
R |
|
|
N |
S6_MARKUP |
N |
5 |
2 |
% Markup |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
S6_CODISS |
C |
9 |
0 |
Cod.Serv.ISS |
@9 |
|
60 |
R |
|
|
S |
S6_MRP |
C |
1 |
0 |
Entra MRP |
@! |
Pertence("SN") |
|
R |
S=Sim;N=Nao |
|
N |
S6_FANTASM |
C |
1 |
0 |
Fantasma |
@! |
Pertence("SN") |
|
R |
S=Sim;N=Nao |
|
N |
S6_DTINCLU |
D |
8 |
0 |
Data Incl. |
|
|
|
R |
|
|
S |
S6_IDHIST |
C |
20 |
0 |
ID Hist. |
@! |
|
|
R |
|
|
S |
S6_CNAE |
C |
9 |
0 |
CNAE |
@! |
|
|
R |
|
|
S |
S6_CSLL |
C |
1 |
0 |
Retem CSLL |
@! |
pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
S6_FCIPRV |
N |
12 |
2 |
Pr.Est.FCI |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
S |
S6_COFINS |
C |
1 |
0 |
Retem COF |
@! |
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
S6_FECP |
N |
5 |
2 |
Aliq FECP |
@E 99.99 |
|
|
R |
|
|
S |
S6_PCSLL |
N |
5 |
2 |
Perc. CSLL |
@E 99.99 |
|
|
R |
|
|
S |
S6_PIS |
C |
1 |
0 |
Retem PIS |
@! |
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
S6_CLASFIS |
C |
2 |
0 |
Class.Fiscal |
@! |
|
|
R |
|
|
S |
S6_FECPBA |
N |
5 |
2 |
Aliq FECP BA |
@E 99.99 |
|
|
R |
|
|
S |
S6_ALFECRN |
N |
5 |
2 |
Ali.FECOP-RN |
@E 99.99 |
|
|
R |
|
|
S |
S6_PCOFINS |
N |
5 |
2 |
Perc. COFINS |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
S6_PPIS |
N |
5 |
2 |
Perc. PIS |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
S6_AFUNDES |
N |
5 |
2 |
Alq.FUNDESA |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
S6_TRIBMUN |
C |
20 |
0 |
C. Trib. Mun |
@! |
|
|
|
|
|
S |