Tabela |
SS4 |
Descricao Generica do Produto |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
S4_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
R |
|
|
S |
S4_COD |
C |
15 |
0 |
Codigo |
@! |
A093Prod(.F.).and.existchav("SS4").and.IIF(Subs(M->S4_COD,1,3)=="MOD",A010MOD(),.T.) .And. A010GRADE() .And. Freeforuse("SS4") |
|
|
|
|
S |
S4_DESC |
C |
30 |
0 |
Descricao |
@! |
|
|
|
|
|
S |
S4_TIPO |
C |
2 |
0 |
Tipo |
@1 |
A010Tipo() |
02 |
|
|
|
S |
S4_CODITE |
C |
27 |
0 |
Cod Item |
@! |
NaoVazio() |
|
|
|
|
S |
S4_UM |
C |
2 |
0 |
Unidade |
|
ExistCpo("SAH") |
SAH |
|
|
|
S |
S4_LOCPAD |
C |
2 |
0 |
Armazem Pad. |
@! |
ExistCpo("NNR") |
NNR |
|
|
|
S |
S4_GRUPO |
C |
4 |
0 |
Grupo |
@! |
Vazio() .Or. A010Grupo() |
SBM |
|
|
|
S |
S4_PICM |
N |
5 |
2 |
Aliq. ICMS |
@E 99.99 |
if(nModulo==11.or.nModulo==14,.t.,VldAliqIcm(M->S4_PICM)) |
|
|
|
|
S |
S4_IPI |
N |
5 |
2 |
Aliq. IPI |
@E 99.99 |
Positivo() |
|
|
|
|
S |
S4_POSIPI |
C |
10 |
0 |
Pos.IPI/NCM |
@R 9999.99.99 |
Vazio() .Or. If(cModulo$"EEC/EDC/EIC",ExistCpo("SYD",M->S4_POSIPI),.T.) |
|
|
|
|
S |
S4_ESPECIE |
C |
2 |
0 |
Especie TIPI |
@! |
NaoVazio() |
|
|
|
|
S |
S4_EX_NCM |
C |
3 |
0 |
Ex-NCM |
@! |
Empty(M->S4_POSIPI) .OR. ExistCpo("SYD",LEFT(M->S4_POSIPI,8)+" "+M->S4_EX_NCM) .OR. Vazio() |
|
|
|
|
S |
S4_EX_NBM |
C |
3 |
0 |
Ex-NBM |
@! |
Empty(M->S4_POSIPI) .OR. ExistCpo("SYD",LEFT(M->S4_POSIPI,8)+" "+M->S4_EX_NBM) |
|
|
|
|
S |
S4_ALIQISS |
N |
5 |
2 |
Aliq. ISS |
@E 99.99 |
Positivo() |
|
|
|
|
S |
S4_CODISS |
C |
9 |
0 |
Cod.Serv.ISS |
@9 |
|
60 |
|
|
|
S |
S4_TE |
C |
3 |
0 |
TE Padrao |
@9 |
vazio().or.existcpo("SF4").And.M->S4_TE<="500" |
SF4 |
|
|
|
S |
S4_TS |
C |
3 |
0 |
TS Padrao |
@9 |
vazio().or.existcpo("SF4").And.M->S4_TS>"500" |
SF4 |
|
|
|
S |
S4_PICMRET |
N |
5 |
2 |
Solid. Saida |
@E 99.99 |
Positivo() |
|
|
|
|
S |
S4_PICMENT |
N |
5 |
2 |
Solid. Entr. |
@E 99.99 |
Positivo() |
|
|
|
|
S |
S4_IMPZFRC |
C |
1 |
0 |
Imp.Z.Franca |
@! |
Pertence(' SN') |
|
|
S=Sim;N=Nao |
|
S |
S4_BITMAP |
C |
20 |
0 |
Foto |
|
|
|
|
|
|
S |
S4_SEGUM |
C |
2 |
0 |
Seg.Un.Medi. |
|
Vazio() .Or. ExistCpo("SAH") |
SAH |
|
|
|
S |
S4_CONV |
N |
5 |
2 |
Fator Conv. |
@E 99.99 |
Positivo() |
|
|
|
|
S |
S4_TIPCONV |
C |
1 |
0 |
Tipo de Conv |
@! |
Pertence("MD") |
|
|
M=Multiplicador;D=Divisor |
|
S |
S4_ALTER |
C |
15 |
0 |
Alternativo |
@! |
vazio().or.existcpo("SS4") |
|
|
|
|
S |
S4_QE |
N |
9 |
0 |
Qtd.Embalag. |
@E 999,999,999 |
A010Mult() |
|
|
|
|
S |
S4_PRV1 |
N |
12 |
2 |
Preco Venda |
@E 999,999,999.99 |
A010Preco() |
|
|
|
|
S |
S4_EMIN |
N |
12 |
2 |
Ponto Pedido |
@E 999,999,999.99 |
|
|
|
|
|
S |
S4_CUSTD |
N |
12 |
2 |
Custo Stand. |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
S |
S4_UCALSTD |
D |
8 |
0 |
Ult. Calculo |
|
|
|
|
|
|
S |
S4_UPRC |
N |
12 |
2 |
Ult. Preco |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
S |
S4_MCUSTD |
C |
1 |
0 |
Moeda C.Std |
@! |
Pertence("12345") |
|
|
1=Moeda1;2=Moeda2;3=Moeda3;4=Moeda4;5=Moeda5 |
|
S |
S4_UCOM |
D |
8 |
0 |
Ult. Compra |
|
|
|
|
|
|
S |
S4_PESO |
N |
11 |
4 |
Peso Liquido |
@E 999,999.9999 |
POSITIVO(M->S4_PESO) |
|
|
|
|
S |
S4_ESTSEG |
N |
12 |
2 |
Seguranca |
@E 999,999,999.99 |
|
|
|
|
|
S |
S4_ESTFOR |
C |
3 |
0 |
Form.Est.Seg |
@! |
vazio().or.existcpo("SM4") |
SM4 |
|
|
|
S |
S4_FORPRZ |
C |
3 |
0 |
Form. Prazo |
@! |
vazio().or.existcpo("SM4") |
SM4 |
|
|
|
S |
S4_PE |
N |
5 |
0 |
Entrega |
@E 99,999 |
Positivo() |
|
|
|
|
S |
S4_TIPE |
C |
1 |
0 |
Tipo Prazo |
@! |
|
|
|
H=Horas;D=Dias;S=Semana;M=Mes;A=Ano |
|
S |
S4_LE |
N |
12 |
2 |
Lote Econom. |
@E 999,999,999.99 |
A010Mult() |
|
|
|
|
S |
S4_LM |
N |
12 |
2 |
Lote Minimo |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
S |
S4_CONTA |
C |
20 |
0 |
Cta Contabil |
@! |
vazio().or. Ctb105Cta() |
CT1 |
|
|
|
S |
S4_TOLER |
N |
3 |
0 |
Tolerancia |
@E 999 |
Positivo() |
|
|
|
|
S |
S4_CC |
C |
9 |
0 |
Centro Custo |
@! |
Vazio().or.Ctb105Cc() |
CTT |
|
|
|
S |
S4_ITEMCC |
C |
9 |
0 |
Item Conta |
@! |
Vazio() .Or. Ctb105Item() |
CTD |
|
|
|
S |
S4_FAMILIA |
C |
1 |
0 |
Familia |
! |
pertence("SN ") |
|
|
S=Sim;N=Nao |
|
S |
S4_PROC |
C |
6 |
0 |
Forn. Padrao |
@! |
A010Proc() |
SA2 |
|
|
|
S |
S4_QB |
N |
7 |
0 |
Base Estrut. |
@E 9,999,999 |
Positivo() |
|
|
|
|
S |
S4_LOJPROC |
C |
2 |
0 |
Loja Padrao |
@! |
A010LojProc() |
|
|
|
|
S |
S4_APROPRI |
C |
1 |
0 |
Apropriacao |
! |
|
|
|
&D=Direto;I=Indireto |
|
S |
S4_TIPODEC |
C |
1 |
0 |
Tipo Dec. OP |
! |
Vazio() .Or. Pertence("NAIT") |
|
|
N=Normal;A=Arred.5/4;I=Incrementa;T=Trunca |
|
S |
S4_ORIGEM |
C |
1 |
0 |
Origem |
@! |
Vazio() .or. ExistCpo("SX5","S0"+M->S4_ORIGEM) |
S0 |
|
|
|
S |
S4_CLASFIS |
C |
2 |
0 |
Class.Fiscal |
@1 |
Vazio().or.Texto() |
|
|
|
|
S |
S4_FANTASM |
C |
1 |
0 |
Fantasma |
! |
|
|
|
S=Sim;&N=Nao , |
|
S |
S4_RASTRO |
C |
1 |
0 |
Rastro |
! |
pertence("SLN") .And. AvalLote(M->S4_COD) |
|
|
S=SubLote;L=Lote;N=Nao utiliza |
|
S |
S4_UREV |
D |
8 |
0 |
Ult. Revisao |
|
|
|
|
|
|
S |
S4_DATREF |
D |
8 |
0 |
DT Referenc. |
|
|
|
|
|
|
S |
S4_FORAEST |
C |
1 |
0 |
Fora estado |
! |
|
|
|
S=Sim;N=Nao |
|
S |
S4_COMIS |
N |
5 |
2 |
% Comissao |
@E 99.99 |
Positivo() |
|
|
|
|
S |
S4_MONO |
C |
1 |
0 |
Forn. Canal |
@! |
Vazio().or.(Pertence("SN").And.A010MONO()) |
|
|
S=Sim;N=Nao |
|
S |
S4_PERINV |
N |
3 |
0 |
Per.Invent. |
@E 999 |
Positivo() |
|
|
|
|
S |
S4_DTREFP1 |
D |
8 |
0 |
Dt.Ref.Prc 1 |
|
|
|
|
|
|
S |
S4_GRTRIB |
C |
6 |
0 |
Grupo Trib. |
@! |
Vazio() .Or. ExistCpo("SX5","21"+M->S4_GRTRIB) |
21 |
|
|
|
S |
S4_MRP |
C |
1 |
0 |
Entra MRP |
@! |
|
|
|
S=Sim;N=Nao |
|
S |
S4_NOTAMIN |
N |
1 |
0 |
Nota Minima |
9 |
|
|
|
|
|
S |
S4_PRVALID |
N |
3 |
0 |
Prazo Valid. |
@E 999 |
Positivo() |
|
|
|
|
S |
S4_NUMCOP |
N |
5 |
0 |
Qtde. Copias |
@E 99,999 |
|
|
|
|
|
S |
S4_CONINI |
D |
8 |
0 |
Cons.Inicial |
|
|
|
|
|
|
S |
S4_CONTSOC |
C |
1 |
0 |
Cont.Seg.Soc |
@! |
|
|
|
S=Sim;N=Nao |
|
S |
S4_IRRF |
C |
1 |
0 |
Impos.Renda |
@! |
|
|
|
S=Sim;N=Nao |
|
S |
S4_CODBAR |
C |
15 |
0 |
Cod Barras |
@! |
|
|
|
|
|
S |
S4_GRADE |
C |
1 |
0 |
Grade |
@! |
Pertence("SN") |
|
|
S=Sim;N=Nao |
|
S |
S4_FORMLOT |
C |
3 |
0 |
Cod Form Lot |
@! |
Vazio() .Or. ExistCpo("SM4",M->S4_FORMLOT) |
SM4 |
|
|
|
S |
S4_FPCOD |
C |
2 |
0 |
Cod.Familia |
@! |
Vazio() .or. ExistCpo("SYC",M->S4_FPCOD) |
SYC |
|
|
|
S |
S4_LOCALIZ |
C |
1 |
0 |
Contr.Endere |
@! |
Pertence("SN") .And. AvalLocali(M->S4_COD) |
|
|
S=Sim;N=Nao |
|
S |
S4_OPERPAD |
C |
2 |
0 |
Rt.Op Padrao |
@! |
If(!Empty(M->S4_OPERPAD),ExistCPO('SG2',M->S4_COD+M->S4_OPERPAD),.T.) |
SG2 |
|
|
|
S |
S4_CONTRAT |
C |
1 |
0 |
Contrato |
@! |
Pertence("SN ") .And. A010Contr() |
|
|
S=Sim;N=Nao |
|
S |
S4_DESC_P |
C |
6 |
0 |
Desc. Portug |
999999 |
|
|
|
|
|
S |
S4_DESC_GI |
C |
6 |
0 |
Desc. L.I. |
999999 |
|
|
|
|
|
S |
S4_DESC_I |
C |
6 |
0 |
Desc. Ingles |
999999 |
|
|
|
|
|
S |
S4_VLREFUS |
N |
15 |
5 |
Val.Ref.US$ |
@E 999,999,999.99999 |
POSITIVO(M->S4_VLREFUS) |
|
|
|
|
S |
S4_IMPORT |
C |
1 |
0 |
Prod. Import |
! |
Pertence("SN ") |
|
|
S=Sim;N=Nao |
|
S |
S4_VM_I |
M |
36 |
0 |
Desc. Ingles |
|
|
|
V |
|
|
S |
S4_VM_GI |
M |
48 |
0 |
Desc. LI |
|
|
|
V |
|
|
S |
S4_VM_P |
M |
36 |
0 |
Desc. Portug |
|
|
|
V |
|
|
S |
S4_ANUENTE |
C |
1 |
0 |
Anuente |
@! |
Pertence("12") |
|
|
1=Sim;2=Nao |
|
S |
S4_OPC |
C |
80 |
0 |
Opc. Default |
@!S40 |
|
|
|
|
|
S |
S4_CODOBS |
C |
6 |
0 |
Cod. Obs. |
|
|
|
|
|
|
S |
S4_OBS |
M |
60 |
0 |
Observacao |
|
|
|
V |
|
|
S |
S4_SITPROD |
C |
2 |
0 |
Situacao |
|
|
T2 |
|
|
|
S |
S4_FABRIC |
C |
20 |
0 |
Fabricante |
|
|
|
|
|
|
S |
S4_MODELO |
C |
15 |
0 |
Modelo |
@! |
|
|
|
|
|
S |
S4_SETOR |
C |
2 |
0 |
Setor |
99 |
ExistCpo("SX5","72"+M->S4_SETOR) |
72 |
|
|
|
S |
S4_BALANCA |
C |
1 |
0 |
Balanca |
! |
M->S4_BALANCA $ "0123" |
|
|
0=Nao usa;1=Preco;2=Peso;3=Unidade |
|
S |
S4_TECLA |
C |
3 |
0 |
Tecla |
999 |
|
|
|
|
|
S |
S4_PRODPAI |
C |
15 |
0 |
Produto Pai |
999999999999999 |
|
|
|
|
|
S |
S4_TIPOCQ |
C |
1 |
0 |
Tipo de C.Q. |
@! |
Pertence("MQ") .And. a010LotQlt() |
|
|
M=Materiais;Q=SigaQuality |
|
S |
S4_SOLICIT |
C |
1 |
0 |
Restricao |
@! |
|
|
|
S=Sim;N=Nao |
|
S |
S4_BASE3 |
C |
14 |
0 |
SFamilia |
|
|
|
R |
|
|
S |
S4_DESBSE3 |
C |
60 |
0 |
Des SubFam |
|
|
|
R |
|
|
S |
S4_AGREGCU |
C |
1 |
0 |
Custeio OP |
@! |
Pertence("12 ") |
|
R |
1=Permite;2=Nao permite; |
|
S |
S4_DESPIMP |
C |
1 |
0 |
Desp.Import. |
@! |
Pertence("SN ") |
|
|
S=Sim;N=Nao |
|
S |
S4_QUADPRO |
C |
1 |
0 |
Classe Repos |
@! |
|
|
R |
1=Classe I;2=Classe II;3=Classe III;4=Classe IV |
|
S |
S4_GRUPCOM |
C |
6 |
0 |
Gr. Compras |
@! |
Vazio() .Or. ExistCpo("SAJ",M->S4_GRUPCOM) |
SAJ |
|
|
|
S |
S4_NUMCQPR |
N |
3 |
0 |
Producoes CQ |
@E 999 |
Positivo() |
|
|
|
|
S |
S4_CONTCQP |
N |
3 |
0 |
Cont.Prod.CQ |
@E 999 |
Positivo() |
|
|
|
|
S |
S4_REVATU |
C |
3 |
0 |
Rev.Estrutur |
@! |
|
|
|
|
|
S |
S4_CODEMB |
C |
20 |
0 |
Embalagem |
@! |
Existcpo('EE5',M->S4_CODEMB) .Or. Vazio() |
|
|
|
|
S |
S4_INSS |
C |
1 |
0 |
Calcula INSS |
@! |
|
|
|
S=Sim;N=Nao |
|
S |
S4_ESPECIF |
C |
80 |
0 |
Descr.Espec. |
@! |
|
|
|
|
|
S |
S4_MAT_PRI |
C |
20 |
0 |
Materia Pri. |
@! |
|
|
|
|
|
S |
S4_NALNCCA |
C |
7 |
0 |
NALADI NCCA |
@R 9999.99.9 |
ExistCpo("SJ2",M->S4_NALNCCA) |
SJ2 |
|
|
|
S |
S4_REDINSS |
N |
5 |
2 |
% Red. INSS |
@E 99.99 |
Positivo() |
|
|
|
|
S |
S4_NALSH |
C |
8 |
0 |
NALADI SH |
@R 9999.99.99 |
ExistCpo("SJ1",M->S4_NALSH) |
SJ1 |
|
|
|
S |
S4_ALADI |
C |
3 |
0 |
ALADI |
@! |
ExistCPO("SJC",M->S4_ALADI) |
SJC |
|
|
|
S |
S4_REDIRRF |
N |
5 |
2 |
% Red. IRRF |
@E 99.99 |
Positivo() |
|
|
|
|
S |
S4_TAB_IPI |
C |
2 |
0 |
IPI de Pauta |
@! |
Vazio() .Or. ExistCpo("EI6") |
E16 |
|
|
|
S |
S4_GRUDES |
C |
3 |
0 |
Grupo Descon |
@! |
FG_Seek("VE5","SBM->BM_CODMAR+M->S4_GRUDES") |
VE5 |
|
|
|
S |
S4_REDPIS |
N |
5 |
2 |
%Red.PIS |
@E 99.99 |
Positivo() |
|
|
|
|
S |
S4_REDCOF |
N |
5 |
2 |
% Red.COFINS |
@E 99.99 |
Positivo() |
|
|
|
|
S |
S4_DATASUB |
D |
8 |
0 |
Data Substit |
|
|
|
|
|
|
S |
S4_PCSLL |
N |
5 |
2 |
Perc. CSLL |
@E 99.99 |
|
|
|
|
|
S |
S4_PCOFINS |
N |
5 |
2 |
Perc. COFINS |
@E 99.99 |
|
|
|
|
|
S |
S4_PPIS |
N |
5 |
2 |
Perc. PIS |
@E 99.99 |
Positivo() |
|
|
|
|
S |
S4_MTBF |
N |
9 |
2 |
MTBF em Hr. |
@E 999,999.99 |
|
|
|
|
|
S |
S4_MTTR |
N |
9 |
2 |
MTTR em Hr. |
@E 999,999.99 |
|
|
|
|
|
S |
S4_FLAGSUG |
C |
1 |
0 |
Tip Sugestao |
@! |
Pertence("1234 ") |
|
|
1=Normal;2=Cancelado;3=Novo;4=Lucrativo |
|
S |
S4_CLASSVE |
C |
1 |
0 |
Status Venda |
@! |
Pertence("1234") |
|
|
1=Normal;2=Promocao;3=Descarte;4=Eliminado |
|
S |
S4_MIDIA |
C |
1 |
0 |
Calc.Midia C |
@! |
Pertence("12") |
|
|
1=Sim;2=Nao |
|
S |
S4_QTMIDIA |
N |
14 |
2 |
Qtde. Midia |
@E 99,999,999,999.99 |
Positivo() |
|
|
|
|
S |
S4_VLR_IPI |
N |
9 |
2 |
IPI de Pauta |
@E 999,999.99 |
Positivo() |
|
|
|
|
S |
S4_ENVOBR |
C |
1 |
0 |
Env. Obrigat |
@! |
Pertence("01") |
|
|
0=Sim;1=Nao |
|
S |
S4_QTDSER |
N |
1 |
0 |
Vld Num Seri |
9 |
|
|
|
1=1a Unidade de Medida;2=2a Unidade de Medida |
|
S |
S4_SERIE |
C |
20 |
0 |
Serie/Colec. |
@! |
Vazio() .Or. Texto() |
|
|
|
|
S |
S4_FAIXAS |
N |
2 |
0 |
Nr.faixas CD |
99 |
Positivo() |
|
|
|
|
S |
S4_NROPAG |
N |
4 |
0 |
Nro. Paginas |
@E 9,999 |
Positivo() |
|
|
|
|
S |
S4_ISBN |
C |
10 |
0 |
Codigo ISBN |
@! |
|
|
|
|
|
S |
S4_TITORIG |
C |
50 |
0 |
Tit.Original |
@! |
|
|
|
|
|
S |
S4_LINGUA |
C |
20 |
0 |
Lingua Orig. |
@! |
Vazio().Or.Texto() |
|
|
|
|
S |
S4_EDICAO |
C |
3 |
0 |
Nro.Edicao |
@! |
Vazio().Or.Texto() |
|
|
|
|
S |
S4_OBSISBN |
C |
40 |
0 |
Obs ISBN |
@! |
Vazio().Or.Texto() |
|
|
|
|
S |
S4_CLVL |
C |
9 |
0 |
Classe Valor |
@! |
Vazio() .Or. Ctb105ClVl() |
CTH |
|
|
CtbInUse() |
S |
S4_ATIVO |
C |
1 |
0 |
Ativo |
@! |
|
|
|
|
|
S |
S4_EMAX |
N |
12 |
2 |
Estoq Maximo |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
S |
S4_PESBRU |
N |
11 |
4 |
Peso Bruto |
@E 999,999.9999 |
Positivo() |
|
|
|
|
S |
S4_TIPCAR |
C |
6 |
0 |
Tipo Carga |
@! |
ExistCpo("DB0") |
DB0 |
|
|
|
S |
S4_FRACPER |
N |
5 |
2 |
Frac Permit |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
S4_INT_ICM |
N |
12 |
2 |
P.ICMS Prop. |
@E 999,999,999.99 |
Positivo() |
|
R |
|
|
S |
S4_VLR_ICM |
N |
14 |
2 |
Icms Pauta |
@E 99,999,999,999.99 |
Positivo() |
|
|
|
|
S |
S4_VLRSELO |
N |
15 |
2 |
Valor Selo |
@E 999,999,999,999.99 |
POSITIVO(M->S4_VLRSELO) |
|
|
|
|
S |
S4_CODNOR |
C |
3 |
0 |
Cod. Norma |
@! |
Vazio() .or. ExistCpo("EEI") |
EEI |
|
|
|
S |
S4_CORPRI |
C |
6 |
0 |
Cor Princip. |
@! |
Vazio() .Or. ExistCpo("SX5","EE"+M->S4_CORPRI) |
EE |
|
|
|
S |
S4_CORSEC |
C |
6 |
0 |
Cor Secund. |
@! |
Vazio() .Or. ExistCpo("SX5","EE"+M->S4_CORSEC) |
EE |
|
|
|
S |
S4_NICONE |
C |
15 |
0 |
Icone APS |
@! |
|
|
|
|
|
S |
S4_ATRIB1 |
C |
6 |
0 |
Atributo 1 |
@! |
A612VldAtr("1") |
AT1 |
|
|
|
S |
S4_ATRIB2 |
C |
6 |
0 |
Atributo 2 |
@! |
A612VldAtr("2") |
AT2 |
|
|
|
S |
S4_ATRIB3 |
C |
6 |
0 |
Atributo 3 |
@! |
A612VldAtr("3") |
AT3 |
|
|
|
S |
S4_REGSEQ |
C |
6 |
0 |
Regra Sequ. |
@! |
Vazio() .Or. ExistCpo("SX5","EK"+M->S4_REGSEQ) |
EK |
|
|
|
S |
S4_CPOTENC |
C |
1 |
0 |
Contr. Poten |
! |
pertence(" 12") .And. If(M->S4_CPOTENC$"1",If(M->S4_RASTRO$"LS",.T.,(Help(" ",1,"NAORASTRO"),.F.)),.T.) |
|
|
1=Sim;2=Nao |
|
S |
S4_POTENCI |
N |
6 |
0 |
Potencia Pad |
@E 999,999 |
If(M->S4_RASTRO$"LS".And.M->S4_CPOTENCI$"1",Positivo(),A010Potenci()) |
|
|
|
|
S |
S4_QTDACUM |
N |
9 |
0 |
Qtde. Acum. |
@E 999,999,999 |
|
|
|
|
|
S |
S4_QTDINIC |
N |
9 |
0 |
Qtd Inic Mes |
@E 999,999,999 |
|
|
|
|
|
S |
S4_REQUIS |
C |
1 |
0 |
Requisitado |
|
Pertence("0123") |
|
|
0=Centro de Custo;1=Paciente;2=Farmacia;3=Ambos |
|
S |
S4_SELO |
C |
1 |
0 |
Utiliza Selo |
|
|
|
|
1=Sim;2=Nao |
|
S |
S4_LOTVEN |
N |
12 |
2 |
Qtde Venda |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
S |
S4_OK |
C |
4 |
0 |
OK |
|
|
|
|
|
|
S |
S4_USAFEFO |
C |
1 |
0 |
FEFO |
@! |
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
S4_IAT |
C |
1 |
0 |
Trunc ou Arr |
@! |
Pertence("AT") |
|
R |
|
|
S |
S4_IPPT |
C |
1 |
0 |
Prop ou Terc |
@! |
Pertence("PT") |
|
R |
|
|
S |
S4_CNATREC |
C |
3 |
0 |
Cod Nat Rec |
@! |
ExistCpo("CCZ",M->B1_TNATREC+M->B1_CNATREC) |
|
|
|
|
S |
S4_TNATREC |
C |
4 |
0 |
Tab. Na. Rec |
@! |
ExistCpo('CCZ') |
CCZ |
|
|
|
S |
S4_DCRII |
N |
16 |
7 |
Vl. DCRII |
@E 99,999,999.9999999 |
|
|
R |
|
|
S |
S4_DCR |
C |
9 |
0 |
Nr. DCR |
@! |
Dcigat('DCR') |
|
R |
|
|
S |
S4_DCI |
C |
1 |
0 |
Prod. DCI |
@! |
Pertence(" 12") |
|
R |
1=Sim;2=Nao |
|
S |
S4_DCRE |
C |
10 |
0 |
Nr. DCRE |
@! |
Dcigat('DCRE') |
|
R |
|
|
S |
S4_COEFDCR |
N |
5 |
2 |
Coef. DCR |
@E 99.99 |
|
|
R |
|
|
S |
S4_DIFCNAE |
C |
11 |
0 |
Dif. CNAE |
@! |
|
|
R |
|
|
S |
S4_GRPNATR |
C |
2 |
0 |
Grp.Nat.Rec. |
@! |
|
|
R |
|
|
S |
S4_DTFIMNT |
D |
8 |
0 |
Dt.Fim N. R. |
|
|
|
R |
|
|
S |
S4_REFBAS |
C |
1 |
0 |
Ref. Base |
|
Pertence(" 012") |
|
|
0=Preco Tabelado/Maximo;1=Valor Agregado;2=Lista Negativa;3=Lista Positiva;4=Lista Neutra |
|
S |
S4_TPPROD |
C |
1 |
0 |
Tipo Medic. |
|
Pertence(" 01234") |
|
R |
0=Similar;1=Generico;2=Etico ou de Marca |
|
S |
S4_FECP |
N |
5 |
2 |
Aliq FECP |
@E 99.99 |
|
|
R |
|
|
S |
S4_UMOEC |
N |
2 |
0 |
Ult Moe Comp |
99 |
|
|
R |
|
|
S |
S4_UVLRC |
N |
12 |
2 |
Ult Vlr Comp |
@E 999,999,999.99 |
|
|
R |
|
|
S |
S4_PIS |
C |
1 |
0 |
Retem PIS |
@! |
Pertence("12") |
|
|
1=Sim;2=Nao |
|
S |
S4_TIPOBN |
C |
2 |
0 |
Tipo BN |
@! |
A010tipo() |
02 |
|
|
|
S |
S4_VALEPRE |
C |
1 |
0 |
Vale Present |
|
Pertence('12') |
|
|
1=Sim;2=Nao |
|
S |
S4_FUSTF |
C |
1 |
0 |
Fust/Funttel |
@! |
Pertence(" 12") |
|
R |
1=Sim;2=Nao |
|
S |
S4_ESCRIPI |
C |
1 |
0 |
Est Cred IPI |
@! |
Pertence(" 123") |
|
|
1=M.P;2=P.A;3=Nao |
|
S |
S4_MSBLQL |
C |
1 |
0 |
Blq. de Tela |
|
pertence("12") |
|
|
1=Sim;2=Nao |
|
S |
S4_CODQAD |
C |
13 |
0 |
Dep Correcao |
|
FQNCCHKCC(cFilAnt,M->S4_CODQAD) |
QAD |
R |
|
|
S |
S4_PMACNUT |
N |
6 |
0 |
% Macronutr. |
@E 999,999 |
Positivo() |
|
R |
|
|
S |
S4_PMICNUT |
N |
6 |
0 |
% Micronutr. |
@E 999,999 |
Positivo() |
|
R |
|
|
S |
S4_TALLA |
C |
6 |
0 |
Tamanho |
|
|
|
R |
|
|
S |
S4_GDODIF |
C |
1 |
0 |
Grau Dificul |
|
IF ( !EMPTY(M->S4_GDODIF),EXISTCPO("SX5","GG"+M->S4_GDODIF,1),.T.) |
GG |
R |
|
|
S |
S4_CLASSE |
C |
6 |
0 |
Classe Selo |
|
|
A9 |
|
|
|
S |
S4_PARCEI |
C |
6 |
0 |
Parceiro |
@! |
Vazio().OR.ExistCpo('AC4') |
AC4 |
R |
|
|
S |
S4_VLR_PIS |
N |
12 |
2 |
Pis Pauta |
@E 999,999,999.99 |
Positivo() |
|
R |
|
|
S |
S4_GCCUSTO |
C |
8 |
0 |
Gr Cnt Custo |
@! |
Vazio() .Or. ExistCpo('CTR',,1) |
CTR |
R |
|
|
S |
S4_CCCUSTO |
C |
9 |
0 |
CC p/ Custo |
@! |
Vazio() .Or. Ctb105CC() |
CTT |
R |
|
|
S |
S4_CODPROC |
C |
6 |
0 |
Cod.Desc.Pro |
999999 |
|
|
R |
|
|
S |
S4_VM_PROC |
M |
48 |
0 |
Desc.Process |
|
|
|
V |
|
|
S |
S4_VLCIF |
N |
12 |
3 |
Valor CIF |
@E 99,999,999.999 |
|
|
R |
|
|
S |
S4_CRICMS |
C |
1 |
0 |
ICMS 271 |
@! |
Pertence(" 01") |
|
R |
0=Nao;1=Sim |
|
S |
S4_QBP |
N |
7 |
0 |
Base Pre-Es. |
9999999 |
Positivo() |
|
R |
|
|
S |
S4_PRODSBP |
C |
1 |
0 |
Atende Nec? |
@! |
Pertence('PC') |
|
R |
P=Produzindo;C=Comprando |
|
S |
S4_LOTESBP |
N |
12 |
2 |
Lote SBP |
@E 999,999,999.99 |
Positivo() |
|
R |
|
|
S |
S4_MARKUP |
N |
5 |
2 |
% Markup |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
S4_DTCORTE |
D |
8 |
0 |
Mud.Reg.Trib |
|
|
|
|
|
|
S |
S4_PRN944I |
C |
1 |
0 |
Prod. RN944i |
@! |
Pertence("SN") |
|
|
S=Sim;N=Nao |
|
S |
S4_CODLAN |
C |
6 |
0 |
Cod.Cat83 |
@! |
Vazio() .Or. ExistCpo('CDZ') |
CDZ |
R |
|
|
S |
S4_CARGAE |
C |
1 |
0 |
Carga Esp? |
@! |
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
S4_PRINCMG |
N |
6 |
2 |
Pr.Inc.Leite |
@E 999.99 |
|
|
R |
|
|
S |
S4_TRIBMUN |
C |
20 |
0 |
C. Trib. Mun |
@! |
|
|
R |
|
|
S |
S4_ADMIN |
C |
10 |
0 |
Admin. |
@! |
|
PGA |
R |
|
M->S4_TIPO == SuperGetMV("MV_LJTPGAR", ,"GE") |
S |
S4_PERGART |
N |
5 |
2 |
% Garantia |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
S4_PR43080 |
N |
6 |
2 |
%Red.43080 |
@E 999.99 |
|
|
|
|
|
S |
S4_GARANT |
C |
1 |
0 |
Garantia? |
|
Pertence("12") |
|
R |
1=Sim;2=Nao |
M->S4_TIPO <> SuperGetMV("MV_LJTPGAR", ,"GE") |
S |
S4_RPRODEP |
C |
1 |
0 |
Rel. Prodepe |
@! |
Pertence(" 12") |
|
|
1=Sim;2=Nao |
|
S |
S4_COFINS |
C |
1 |
0 |
Retem COF |
@! |
Pertence("12") |
|
|
1=Sim;2=Nao |
|
S |
S4_CSLL |
C |
1 |
0 |
Retem CSLL |
@! |
Pertence("12") |
|
|
1=Sim;2=Nao |
|
S |
S4_CRDEST |
N |
5 |
2 |
Crd Estimulo |
@E 99.99 |
Positivo() |
|
|
|
|
S |
S4_VLR_COF |
N |
12 |
2 |
COFINS Pauta |
@E 999,999,999.99 |
Positivo() |
|
R |
|
|
S |
S4_FRETISS |
C |
1 |
0 |
F.Ret.ISS |
@! |
Pertence(' 12') |
|
R |
|
|
S |
S4_PRFDSUL |
N |
12 |
8 |
Pr.Fundersul |
@E 999.99999999 |
|
|
R |
|
|
S |
S4_RETOPER |
C |
1 |
0 |
Ret.Operacao |
@! |
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
S4_CNAE |
C |
9 |
0 |
CNAE |
@! |
|
|
R |
|
|
S |
S4_TIPVEC |
C |
6 |
0 |
Tipo Vetor |
|
if (!empty(m->S4_tipvec),existcpo("SX5","VC"+M->S4_TIPVEC,1),.T.) |
VC |
R |
|
|
S |
S4_SELOEN |
C |
5 |
0 |
Enq. Selo |
@! |
|
|
|
|
|
S |
S4_PRODREC |
C |
1 |
0 |
Material Rec |
@! |
Pertence(" 12") |
|
|
1=Sim;2=Nao |
|
S |
S4_DESBSE2 |
C |
60 |
0 |
Des SubFam |
|
|
|
R |
|
|
S |
S4_COLOR |
C |
10 |
0 |
Cor |
|
|
|
R |
|
|
S |
S4_IVAAJU |
C |
1 |
0 |
Cal. IVA Aju |
@! |
Pertence(" 12") |
|
R |
1=Sim;2=Nao |
|
S |
S4_BASE |
C |
14 |
0 |
Cod Familia |
|
if (!empty(m->S4_BASE),existcpo("SBP",+M->S4_BASE,1),.T.) |
SBP |
R |
|
|
S |
S4_RICM65 |
C |
1 |
0 |
Art65 RICMPR |
@! |
Pertence(" 12") |
|
|
"1=Sim;2=Nao" |
|
S |
S4_ALFUMAC |
N |
5 |
2 |
Alq. FUMACOP |
@E 99.99 |
|
|
R |
|
|
S |
S4_FETHAB |
C |
1 |
0 |
Inc.FETHAB |
@! |
Pertence("NS") |
|
R |
N=Nao;S=Sim |
|
S |
S4_ESTRORI |
C |
15 |
0 |
Estr. Origem |
@! |
A010EstOri() |
SG1SBP |
R |
|
|
S |
S4_CALCFET |
C |
1 |
0 |
Calc. FETHAB |
@! |
Pertence("12") |
|
|
|
|
S |
S4_PAUTFET |
N |
9 |
4 |
Pauta FETHAB |
@E 9,999.9999 |
|
|
|
|
|
S |
S4_REGRISS |
C |
2 |
0 |
Regra ISS Pg |
@! |
|
|
R |
|
|
S |
S4_CODANT |
C |
15 |
0 |
Cod. ant. |
@! |
ExistCpo("SB1") |
SB1 |
R |
|
|
S |
S4_BASE2 |
C |
14 |
0 |
SubSubFamil |
|
|
|
R |
|
|
S |
S4_CHASSI |
C |
17 |
0 |
Num Chassi |
@! |
|
|
R |
|
|
S |
S4_AFETHAB |
N |
5 |
2 |
Aliq. FETHAB |
@E 99.99 |
Positivo() |
|
|
|
|
S |
S4_CFEMA |
N |
6 |
2 |
Aliq. CFEMA |
@E 999.99 |
|
|
R |
|
|
S |
S4_TPDP |
C |
1 |
0 |
Calc. TPDP |
@! |
Pertence(' 12') |
|
|
1=Sim;2=Nao |
|
S |
S4_TPREG |
C |
1 |
0 |
Tp. Reg |
@! |
Pertence(" 12") |
|
|
1=Nao Cumulativo;2=Cumulativo |
|
S |
S4_VEREAN |
C |
2 |
0 |
Codigo EAN |
@! |
|
|
|
|
|
S |
S4_VIGENC |
D |
8 |
0 |
Data Vigenc |
|
|
|
|
|
|
S |
S4_CFEMS |
C |
1 |
0 |
Sit. CFEM |
@! |
Pertence(" 123") |
|
|
1=Receita;2=Deduz Seg.;3=Deduz Trans. |
|
S |
S4_CRDPRES |
N |
5 |
2 |
%Crd. Pres |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
S4_CRICMST |
C |
1 |
0 |
Cont ICMS-ST |
@! |
Pertence(" 01") |
|
R |
0=Nao;1=Sim |
|
S |
S4_FECOP |
C |
1 |
0 |
Calc. FECOP |
@! |
Pertence(" 12") |
|
|
1=Sim;2=Nao |
|
S |
S4_FECPBA |
N |
5 |
2 |
Aliq FECP BA |
@E 99.99 |
|
|
|
|
|
S |
S4_AJUDIF |
C |
1 |
0 |
Ajust/Difer |
@! |
Pertence(" 1/2") |
|
R |
1=Sim;2=Nao |
|
S |
S4_ALFECOP |
N |
5 |
2 |
Aliq. FECOP |
@E 99.99 |
|
|
|
|
|
S |
S4_ALFECRN |
N |
5 |
2 |
Ali.FECOP-RN |
@E 99.99 |
|
|
R |
|
|
S |
S4_ALFECST |
N |
5 |
2 |
Al. FECOP ST |
@E 99.99 |
|
|
|
|
|
S |
S4_CFEM |
C |
1 |
0 |
Cal. CFEM |
@! |
Pertence(" 12") |
|
|
1=Sim;2=Nao |
|
S |
S4_AFABOV |
N |
5 |
2 |
Aliq. FABOV |
@E 99.99 |
Positivo() |
|
|
|
|
S |
S4_AFACS |
N |
5 |
2 |
Aliq. FACS |
@E 99.99 |
Positivo() |
|
|
|
|
S |
S4_IDHIST |
C |
20 |
0 |
ID.Hist. |
@! |
|
|
R |
|
|
S |
S4_MEPLES |
C |
1 |
0 |
Exe. Servico |
9 |
Pertence(" 12") |
|
R |
1=EP;2=LES |
|
S |
S4_PRDORI |
C |
15 |
0 |
Cod.Orig. |
@! |
ExistCpo("SB1") |
SB1 |
R |
|
|
S |
S4_REGESIM |
C |
1 |
0 |
Rg. Simp. MT |
@! |
Pertence(" 12") |
|
|
1=Sim;2=Nao |
|
S |
S4_RSATIVO |
C |
1 |
0 |
Rastro Ativo |
@! |
Pertence(" 12") |
|
R |
1=Sim;2=Nao |
|
S |
S4_TFETHAB |
C |
1 |
0 |
Tipo FETHAB |
@! |
Pertence(" 123") |
|
R |
1=Soja;2=Algodao;3=Gado |
|
S |
S4_AIMAMT |
N |
5 |
2 |
Aliq. IMA-MT |
@E 99.99 |
|
|
R |
|
|
S |
S4_AFUNDES |
N |
5 |
2 |
Alq.FUNDESA |
@E 99.99 |
|
|
R |
|
|
S |
S4_AFASEMT |
N |
5 |
2 |
Aliq.FASE-MT |
@E 99.99 |
|
|
R |
|
|
S |