Tabela |
SB1 |
Descricao Generica do Produto |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
B1_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
R |
|
|
S |
B1_COD |
C |
15 |
0 |
Codigo |
@! |
A093Prod(.F.).and.existchav("SB1").and.IIF(Subs(M->B1_COD,1,3)=="MOD",A010MOD(),.T.) .And. A010GRADE() .And. Freeforuse("SB1") |
|
|
|
|
S |
B1_DESC |
C |
30 |
0 |
Descricao |
@! |
|
|
|
|
|
S |
B1_TIPO |
C |
2 |
0 |
Tipo |
@! |
A010Tipo() |
02 |
|
|
|
S |
B1_CODITE |
C |
27 |
0 |
Cod Item |
@! |
NaoVazio() |
|
|
|
|
S |
B1_UM |
C |
2 |
0 |
Unidade |
|
ExistCpo("SAH") |
SAH |
|
|
|
S |
B1_LOCPAD |
C |
2 |
0 |
Armazem Pad. |
@! |
ExistCpo("NNR") .and. A010VLoc() |
NNR |
|
|
|
S |
B1_GRUPO |
C |
4 |
0 |
Grupo |
@! |
Vazio() .Or. A010Grupo() |
SBM |
|
|
|
S |
B1_PICM |
N |
5 |
2 |
Aliq. ICMS |
@E 99.99 |
if(nModulo==11.or.nModulo==14,.t.,VldAliqIcm(M->B1_PICM)) |
|
|
|
|
S |
B1_IPI |
N |
5 |
2 |
Aliq. IPI |
@E 99.99 |
Positivo() |
|
|
|
|
S |
B1_POSIPI |
C |
10 |
0 |
Pos.IPI/NCM |
@R 9999.99.99 |
If(cModulo$"EEC/EDC/EIC/ESS",AC120Valid("B1_POSIPI"),Vazio() .Or. ExistCpo("SYD",M->B1_POSIPI)) |
SYD |
|
|
|
S |
B1_ESPECIE |
C |
2 |
0 |
Especie TIPI |
@! |
|
|
|
|
|
S |
B1_EX_NCM |
C |
3 |
0 |
Ex-NCM |
@! |
Empty(M->B1_POSIPI) .OR. ExistCpo("SYD",LEFT(M->B1_POSIPI,8)+" "+M->B1_EX_NCM) .OR. Vazio() |
WD2 |
|
|
|
S |
B1_EX_NBM |
C |
3 |
0 |
Ex-NBM |
@! |
Empty(M->B1_POSIPI) .OR. ExistCpo("SYD",LEFT(M->B1_POSIPI,8)+" "+M->B1_EX_NBM) |
WD3 |
|
|
|
S |
B1_ALIQISS |
N |
5 |
2 |
Aliq. ISS |
99.99 |
Positivo() |
|
|
|
|
S |
B1_CODISS |
C |
9 |
0 |
Cod.Serv.ISS |
@9 |
|
60 |
|
|
|
S |
B1_TE |
C |
3 |
0 |
TE Padrao |
@9 |
vazio().or.existcpo("SF4").And.M->B1_TE<="500" |
SF4 |
|
|
|
S |
B1_TS |
C |
3 |
0 |
TS Padrao |
@9 |
vazio().or.existcpo("SF4").And.M->B1_TS>"500" |
SF4 |
|
|
|
S |
B1_PICMRET |
N |
6 |
2 |
Solid. Saida |
@E 999.99 |
Positivo() |
|
|
|
|
S |
B1_PICMENT |
N |
6 |
2 |
Solid. Entr. |
@E 999.99 |
Positivo() |
|
|
|
|
S |
B1_IMPZFRC |
C |
1 |
0 |
Imp.Z.Franca |
@! |
Pertence(' SN') |
|
|
S=Sim;N=Nao |
|
S |
B1_BITMAP |
C |
20 |
0 |
Foto |
|
|
|
|
|
|
S |
B1_SEGUM |
C |
2 |
0 |
Seg.Un.Medi. |
|
Vazio() .Or. ExistCpo("SAH") |
SAH |
|
|
|
S |
B1_CONV |
N |
5 |
2 |
Fator Conv. |
@E 99.99 |
Positivo() |
|
|
|
|
S |
B1_TIPCONV |
C |
1 |
0 |
Tipo de Conv |
@! |
Pertence("MD") |
|
|
M=Multiplicador;D=Divisor |
|
S |
B1_ALTER |
C |
15 |
0 |
Alternativo |
@! |
vazio().or.existcpo("SB1") |
ALT |
|
|
|
S |
B1_QE |
N |
9 |
0 |
Qtd.Embalag. |
@E 999,999,999 |
A010Mult() |
|
|
|
|
S |
B1_PRV1 |
N |
12 |
2 |
Preco Venda |
@E 999,999,999.99 |
A010Preco() |
|
|
|
|
S |
B1_EMIN |
N |
12 |
2 |
Ponto Pedido |
@E 999,999,999.99 |
|
|
|
|
|
S |
B1_CUSTD |
N |
12 |
2 |
Custo Stand. |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
S |
B1_UCALSTD |
D |
8 |
0 |
Ult. Calculo |
|
|
|
|
|
|
S |
B1_UPRC |
N |
12 |
2 |
Ult. Preco |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
S |
B1_MCUSTD |
C |
1 |
0 |
Moeda C.Std |
@! |
Pertence("12345") |
|
|
1=Moeda1;2=Moeda2;3=Moeda3;4=Moeda4;5=Moeda5 |
|
S |
B1_UCOM |
D |
8 |
0 |
Ult. Compra |
|
|
|
|
|
|
S |
B1_PESO |
N |
11 |
4 |
Peso Liquido |
@E 999,999.9999 |
POSITIVO(M->B1_PESO) |
|
|
|
|
S |
B1_ESTSEG |
N |
12 |
2 |
Seguranca |
@E 999,999,999.99 |
|
|
|
|
|
S |
B1_ESTFOR |
C |
3 |
0 |
Form.Est.Seg |
@! |
vazio().or.existcpo("SM4") |
SM4 |
|
|
|
S |
B1_FORPRZ |
C |
3 |
0 |
Form. Prazo |
@! |
vazio().or.existcpo("SM4") |
SM4 |
|
|
|
S |
B1_PE |
N |
5 |
0 |
Entrega |
@E 99999 |
Positivo() |
|
|
|
|
S |
B1_TIPE |
C |
1 |
0 |
Tipo Prazo |
@! |
|
|
|
H=Horas;D=Dias;S=Semana;M=Mes;A=Ano |
|
S |
B1_LE |
N |
12 |
2 |
Lote Econom. |
@E 999,999,999.99 |
A010Mult() |
|
|
|
|
S |
B1_LM |
N |
12 |
2 |
Lote Minimo |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
S |
B1_CONTA |
C |
20 |
0 |
Cta Contabil |
@! |
vazio().or. Ctb105Cta() |
CT1 |
|
|
|
S |
B1_TOLER |
N |
3 |
0 |
Tolerancia |
999 |
Positivo() |
|
|
|
|
S |
B1_CC |
C |
9 |
0 |
Centro Custo |
@! |
Vazio().or.Ctb105Cc() |
CTT |
|
|
|
S |
B1_ITEMCC |
C |
9 |
0 |
Item Conta |
@! |
Vazio() .Or. Ctb105Item() |
CTD |
|
|
|
S |
B1_FAMILIA |
C |
1 |
0 |
Familia |
! |
pertence("SN ") |
|
|
S=Sim;N=Nao |
|
S |
B1_PROC |
C |
6 |
0 |
Forn. Padrao |
@! |
A010Proc() |
SA2 |
|
|
|
S |
B1_QB |
N |
7 |
0 |
Base Estrut. |
9999999 |
Positivo() |
|
|
|
|
S |
B1_LOJPROC |
C |
2 |
0 |
Loja Padrao |
@! |
A010LojProc() |
|
|
|
|
S |
B1_APROPRI |
C |
1 |
0 |
Apropriacao |
! |
|
|
|
D=Direto;I=Indireto |
|
S |
B1_TIPODEC |
C |
1 |
0 |
Tipo Dec. OP |
! |
Vazio() .Or. Pertence("NAIT") |
|
|
N=Normal;A=Arred.5/4;I=Incrementa;T=Trunca |
|
S |
B1_ORIGEM |
C |
1 |
0 |
Origem |
@! |
Vazio() .or. ExistCpo("SX5","S0"+M->B1_ORIGEM) |
S0 |
|
|
|
S |
B1_CLASFIS |
C |
2 |
0 |
Class.Fiscal |
@! |
Vazio().or.Texto() |
|
|
|
|
S |
B1_FANTASM |
C |
1 |
0 |
Fantasma |
! |
|
|
|
S=Sim;N=Nao |
|
S |
B1_RASTRO |
C |
1 |
0 |
Rastro |
! |
pertence("SLN") .And. AvalLote(M->B1_COD,,.T.) |
|
|
S=SubLote;L=Lote;N=Nao utiliza |
|
S |
B1_UREV |
D |
8 |
0 |
Ult. Revisao |
|
|
|
|
|
|
S |
B1_DATREF |
D |
8 |
0 |
DT Referenc. |
|
|
|
|
|
|
S |
B1_FORAEST |
C |
1 |
0 |
Fora estado |
! |
|
|
|
S=Sim;N=Nao |
|
S |
B1_COMIS |
N |
5 |
2 |
% Comissao |
@E 99.99 |
Positivo() |
|
|
|
|
S |
B1_MONO |
C |
1 |
0 |
Forn. Canal |
@! |
|
|
|
S=Sim;N=Nao |
|
S |
B1_PERINV |
N |
3 |
0 |
Per.Invent. |
999 |
Positivo() |
|
|
|
|
S |
B1_DTREFP1 |
D |
8 |
0 |
Dt.Ref.Prc 1 |
|
|
|
|
|
|
S |
B1_GRTRIB |
C |
6 |
0 |
Grupo Trib. |
@! |
Vazio() .Or. ExistCpo("SX5","21"+M->B1_GRTRIB) |
21 |
|
|
|
S |
B1_MRP |
C |
1 |
0 |
Entra MRP |
@! |
|
|
|
S=Sim;N=Nao;E=Especial |
|
S |
B1_NOTAMIN |
N |
1 |
0 |
Nota Minima |
9 |
|
|
|
|
|
S |
B1_PRVALID |
N |
3 |
0 |
Prazo Valid. |
999 |
Positivo() |
|
|
|
|
S |
B1_NUMCOP |
N |
5 |
0 |
Qtde. Copias |
99999 |
|
|
|
|
|
S |
B1_CONINI |
D |
8 |
0 |
Cons.Inicial |
|
|
|
|
|
|
S |
B1_CONTSOC |
C |
1 |
0 |
Cont.Seg.Soc |
@! |
|
|
|
S=Sim;N=Nao |
|
S |
B1_IRRF |
C |
1 |
0 |
Impos.Renda |
@! |
|
|
|
S=Sim;N=Nao |
|
S |
B1_CODBAR |
C |
15 |
0 |
Cod Barras |
@! |
A010CodBar(M->B1_CODBAR) |
|
|
|
|
S |
B1_GRADE |
C |
1 |
0 |
Grade |
@! |
Pertence("SN") |
|
|
S=Sim;N=Nao |
|
S |
B1_FORMLOT |
C |
3 |
0 |
Cod Form Lot |
@! |
Vazio() .Or. ExistCpo("SM4",M->B1_FORMLOT) |
SM4 |
|
|
|
S |
B1_LOCALIZ |
C |
1 |
0 |
Contr.Endere |
@! |
Pertence("SN") .And. AvalLocali(M->B1_COD) |
|
|
S=Sim;N=Nao |
|
S |
B1_FPCOD |
C |
10 |
0 |
Cod.Familia |
@! |
Vazio() .or. ExistCpo("SYC",M->B1_FPCOD) |
SYC |
|
|
|
S |
B1_OPERPAD |
C |
2 |
0 |
Rt.Op Padrao |
@! |
If(!Empty(M->B1_OPERPAD),ExistCPO('SG2',M->B1_COD+M->B1_OPERPAD),.T.) |
SG2 |
|
|
|
S |
B1_CONTRAT |
C |
1 |
0 |
Contrato |
@! |
Pertence("SNA ") |
|
|
S=Sim;N=Nao;A=Ambos |
|
S |
B1_DESC_P |
C |
6 |
0 |
Desc. Portug |
999999 |
|
|
|
|
|
S |
B1_DESC_I |
C |
6 |
0 |
Desc. Ingles |
999999 |
|
|
|
|
|
S |
B1_DESC_GI |
C |
6 |
0 |
Desc. L.I. |
999999 |
|
|
|
|
|
S |
B1_VLREFUS |
N |
15 |
5 |
Val.Ref.US$ |
@E 999,999,999.99999 |
POSITIVO(M->B1_VLREFUS) |
|
|
|
|
S |
B1_IMPORT |
C |
1 |
0 |
Prod. Import |
! |
Pertence("SN ") |
|
|
S=Sim;N=Nao |
|
S |
B1_VM_I |
M |
36 |
0 |
Desc. Ingles |
|
|
|
V |
|
|
S |
B1_VM_GI |
M |
48 |
0 |
Desc. LI |
|
|
|
V |
|
|
S |
B1_VM_P |
M |
36 |
0 |
Desc. Portug |
|
|
|
V |
|
|
S |
B1_ANUENTE |
C |
1 |
0 |
Anuente |
@! |
Pertence("12") |
|
|
1=Sim;2=Nao |
|
S |
B1_OPC |
C |
80 |
0 |
Opc. Default |
@!S40 |
|
|
|
|
|
S |
B1_CODOBS |
C |
6 |
0 |
Cod. Obs. |
|
|
|
|
|
|
S |
B1_OBS |
M |
60 |
0 |
Observacao |
|
|
|
V |
|
|
S |
B1_SITPROD |
C |
2 |
0 |
Situacao |
|
|
T2 |
|
|
|
S |
B1_FABRIC |
C |
20 |
0 |
Fabricante |
|
|
|
|
|
|
S |
B1_MODELO |
C |
15 |
0 |
Modelo |
@! |
|
|
|
|
|
S |
B1_SETOR |
C |
2 |
0 |
Setor |
99 |
ExistCpo("SX5","72"+M->B1_SETOR) |
72 |
|
|
|
S |
B1_BALANCA |
C |
1 |
0 |
Balanca |
! |
M->B1_BALANCA $ "0123" |
|
|
0=NOo usa;1=Prežo;2=Peso;3=Unidade |
|
S |
B1_TECLA |
C |
3 |
0 |
Tecla |
999 |
|
|
|
|
|
S |
B1_PRODPAI |
C |
15 |
0 |
Produto Pai |
999999999999999 |
|
|
|
|
|
S |
B1_TIPOCQ |
C |
1 |
0 |
Tipo de C.Q. |
@! |
Pertence("MQ") .And. a010LotQlt() |
|
|
M=Materiais;Q=SigaQuality |
|
S |
B1_SOLICIT |
C |
1 |
0 |
Restricao |
@! |
|
|
|
S=Sim;N=Nao |
|
S |
B1_GRUPCOM |
C |
6 |
0 |
Gr. Compras |
@! |
Vazio() .Or. ExistCpo("SAJ",M->B1_GRUPCOM) |
SAJ |
|
|
|
S |
B1_QUADPRO |
C |
1 |
0 |
Classe Repos |
@! |
|
|
R |
1=Classe I;2=Classe II;3=Classe III;4=Classe IV |
|
S |
B1_DESPIMP |
C |
1 |
0 |
Desp.Import. |
@! |
Pertence("SN ") |
|
|
S=Sim;N=Nao |
|
S |
B1_AGREGCU |
C |
1 |
0 |
Custeio OP |
@! |
Pertence("12 ") |
|
R |
1=Permite;2=Nao permite; |
|
S |
B1_BASE3 |
C |
14 |
0 |
SFamilia |
|
|
|
R |
|
|
S |
B1_DESBSE3 |
C |
60 |
0 |
Des SubFam |
|
|
|
R |
|
|
S |
B1_NUMCQPR |
N |
3 |
0 |
Producoes CQ |
999 |
Positivo() |
|
|
|
|
S |
B1_CONTCQP |
N |
3 |
0 |
Cont.Prod.CQ |
999 |
Positivo() |
|
|
|
|
S |
B1_REVATU |
C |
3 |
0 |
Rev.Estrutur |
@! |
|
|
|
|
|
S |
B1_INSS |
C |
1 |
0 |
Calcula INSS |
@! |
|
|
|
S=Sim;N=Nao |
|
S |
B1_CODEMB |
C |
30 |
0 |
Embalagem |
@! |
Existcpo('EE5',M->B1_CODEMB) .Or. Vazio() |
EE5 |
|
|
|
S |
B1_ESPECIF |
C |
80 |
0 |
Descr.Espec. |
@! |
|
|
|
|
|
S |
B1_MAT_PRI |
C |
20 |
0 |
Materia Pri. |
@! |
|
|
|
|
|
S |
B1_NALNCCA |
C |
7 |
0 |
NALADI NCCA |
@R 9999.99.9 |
ExistCpo("SJ2",M->B1_NALNCCA) |
SJ2 |
|
|
|
S |
B1_REDINSS |
N |
5 |
2 |
% Red. INSS |
@E 99.99 |
Positivo() |
|
|
|
|
S |
B1_REDIRRF |
N |
5 |
2 |
% Red. IRRF |
@E 99.99 |
Positivo() |
|
|
|
|
S |
B1_ALADI |
C |
3 |
0 |
ALADI |
@! |
ExistCPO("SJC",M->B1_ALADI) |
SJC |
|
|
|
S |
B1_NALSH |
C |
8 |
0 |
NALADI SH |
@R 9999.99.99 |
ExistCpo("SJ1",M->B1_NALSH) |
SJ1 |
|
|
|
S |
B1_TAB_IPI |
C |
2 |
0 |
IPI de Pauta |
@! |
(Vazio() .Or. ExistCpo('EI6')) |
EI6 |
|
|
|
S |
B1_GRUDES |
C |
3 |
0 |
Grupo Descon |
@! |
FG_Seek("VE5","SBM->BM_CODMAR+M->B1_GRUDES") |
VE5 |
|
|
|
S |
B1_REDPIS |
N |
5 |
2 |
%Red.PIS |
@E 99.99 |
Positivo() |
|
|
|
|
S |
B1_REDCOF |
N |
5 |
2 |
% Red.COFINS |
@E 99.99 |
Positivo() |
|
|
|
|
S |
B1_DATASUB |
D |
8 |
0 |
Data Substit |
@D |
|
|
|
|
|
S |
B1_PCSLL |
N |
5 |
2 |
Perc. CSLL |
@E 99.99 |
|
|
|
|
|
S |
B1_PCOFINS |
N |
5 |
2 |
Perc. COFINS |
@E 99.99 |
|
|
|
|
|
S |
B1_PPIS |
N |
5 |
2 |
Perc. PIS |
@E 99.99 |
Positivo() |
|
|
|
|
S |
B1_MTBF |
N |
9 |
2 |
MTBF em Hr. |
@E 999,999.99 |
|
|
|
|
|
S |
B1_MTTR |
N |
9 |
2 |
MTTR em Hr. |
@E 999,999.99 |
|
|
|
|
|
S |
B1_FLAGSUG |
C |
1 |
0 |
Tip Sugestao |
@! |
Pertence("1234 ") |
|
|
1=Normal;2=Cancelado;3=Novo;4=Lucrativo |
|
S |
B1_CLASSVE |
C |
1 |
0 |
Status Venda |
@! |
pertence("1234 ") |
|
|
1=Normal;2=Promocao;3=Descarte;4=Eliminado |
|
S |
B1_MIDIA |
C |
1 |
0 |
Calc.Midia |
@! |
Pertence("12") |
|
|
1=Sim;2=Nao |
|
S |
B1_QTMIDIA |
N |
14 |
2 |
Qtde. Midia |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
S |
B1_VLR_IPI |
N |
9 |
2 |
IPI de Pauta |
@E 999,999.99 |
Positivo() |
|
|
|
|
S |
B1_ENVOBR |
C |
1 |
0 |
Env. Obrigat |
@! |
Pertence("01") |
|
|
0=Sim;1=Nao |
|
S |
B1_QTDSER |
C |
1 |
0 |
Vld Num Seri |
9 |
|
|
|
1=1a Unidade de Medida;2=2a Unidade de Medida |
|
S |
B1_SERIE |
C |
20 |
0 |
Serie/Colec. |
@! |
Vazio() .Or. Texto() |
|
|
|
|
S |
B1_FAIXAS |
N |
2 |
0 |
Nr.faixas CD |
99 |
Positivo() |
|
|
|
|
S |
B1_NROPAG |
N |
4 |
0 |
Nro. Paginas |
9999 |
Positivo() |
|
|
|
|
S |
B1_ISBN |
C |
10 |
0 |
Codigo ISBN |
@! |
|
|
|
|
|
S |
B1_TITORIG |
C |
50 |
0 |
Tit.Original |
@! |
|
|
|
|
|
S |
B1_LINGUA |
C |
20 |
0 |
Lingua Orig. |
@! |
Vazio().Or.Texto() |
|
|
|
|
S |
B1_EDICAO |
C |
3 |
0 |
Nro.Edicao |
@! |
Vazio().Or.Texto() |
|
|
|
|
S |
B1_OBSISBN |
C |
40 |
0 |
Obs ISBN |
@! |
Vazio().Or.Texto() |
|
|
|
|
S |
B1_CLVL |
C |
9 |
0 |
Classe Valor |
@! |
Vazio() .Or. Ctb105ClVl() |
CTH |
|
|
CtbInUse() |
S |
B1_ATIVO |
C |
1 |
0 |
Ativo |
@! |
|
|
|
|
|
S |
B1_EMAX |
N |
12 |
2 |
Estoq Maximo |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
S |
B1_PESBRU |
N |
11 |
4 |
Peso Bruto |
@E 999,999.9999 |
Positivo() |
|
|
|
|
S |
B1_TIPCAR |
C |
6 |
0 |
Tipo Carga |
@! |
Vazio() .Or. ExistCpo("DB0") |
DB0 |
|
|
|
S |
B1_FRACPER |
N |
5 |
2 |
Frac Permit |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
B1_VLR_ICM |
N |
14 |
2 |
Icms Pauta |
@E 99,999,999.99 |
Positivo() |
|
|
|
|
S |
B1_INT_ICM |
N |
12 |
2 |
P.ICMS Prop. |
@e 999,999.99 |
Positivo() |
|
R |
|
|
S |
B1_VLRSELO |
N |
15 |
2 |
Valor Selo |
@E 999,999,999,999.99 |
POSITIVO(M->B1_VLRSELO) |
|
|
|
|
S |
B1_CODNOR |
C |
3 |
0 |
Cod. Norma |
@! |
Vazio() .or. ExistCpo("EEI") |
EEI |
|
|
|
S |
B1_CORPRI |
C |
6 |
0 |
Cor Princip. |
@! |
Vazio() .Or. ExistCpo("SX5","EE"+M->B1_CORPRI) |
EE |
|
|
|
S |
B1_CORSEC |
C |
6 |
0 |
Cor Secund. |
@! |
Vazio() .Or. ExistCpo("SX5","EE"+M->B1_CORSEC) |
EE |
|
|
|
S |
B1_NICONE |
C |
15 |
0 |
Icone APS |
@! |
|
|
|
|
|
S |
B1_ATRIB1 |
C |
6 |
0 |
Atributo 1 |
@! |
A612VldAtr("1") |
AT1 |
|
|
|
S |
B1_ATRIB2 |
C |
6 |
0 |
Atributo 2 |
@! |
A612VldAtr("2") |
AT2 |
|
|
|
S |
B1_ATRIB3 |
C |
6 |
0 |
Atributo 3 |
@! |
A612VldAtr("3") |
AT3 |
|
|
|
S |
B1_REGSEQ |
C |
6 |
0 |
Regra Sequ. |
@! |
Vazio() .Or. ExistCpo("SX5","EK"+M->B1_REGSEQ) |
EK |
|
|
|
S |
B1_CPOTENC |
C |
1 |
0 |
Contr. Poten |
! |
pertence(" 12") .And. If(M->B1_CPOTENC$"1",If(M->B1_RASTRO$"LS",.T.,(Help(" ",1,"NAORASTRO"),.F.)),.T.) |
|
|
1=Sim;2=Nao |
|
S |
B1_POTENCI |
N |
6 |
2 |
Potencia Pad |
@E 999.99 |
If(M->B1_RASTRO$"LS".And.M->B1_CPOTENCI$"1",Positivo(),A010Potenci()) |
|
|
|
|
S |
B1_QTDACUM |
N |
9 |
0 |
Qtde. Acum. |
@E 999,999,999 |
|
|
|
|
|
S |
B1_QTDINIC |
N |
9 |
0 |
Qtd Inic Mes |
@E 999,999,999 |
|
|
|
|
|
S |
B1_REQUIS |
C |
1 |
0 |
Requisitado |
|
Pertence("0123") |
|
|
0=Centro de Custo;1=Paciente;2=Farmacia;3=Ambos |
|
S |
B1_SELO |
C |
1 |
0 |
Utiliza Selo |
|
|
|
|
1=Sim;2=Nao |
|
S |
B1_LOTVEN |
N |
12 |
2 |
Qtde Venda |
@E 99,999,999.99 |
Positivo() |
|
|
|
|
S |
B1_OK |
C |
4 |
0 |
OK |
|
|
|
|
|
|
S |
B1_USAFEFO |
C |
1 |
0 |
FEFO |
@! |
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
B1_IAT |
C |
1 |
0 |
Trunc ou Arr |
@! |
Pertence("AT") |
|
R |
|
|
S |
B1_IPPT |
C |
1 |
0 |
Prop ou Terc |
@! |
Pertence("PT") |
|
R |
|
|
S |
B1_CNATREC |
C |
3 |
0 |
Cod Nat Rec |
@! |
ExistCpo("CCZ",M->B1_TNATREC+M->B1_CNATREC) |
|
|
|
|
S |
B1_TNATREC |
C |
4 |
0 |
Tab. Na. Rec |
@! |
Vazio() .Or. ExistCpo('CCZ') |
CCZSB1 |
|
|
|
S |
B1_CODPROC |
C |
6 |
0 |
Cod.Desc.Pro |
999999 |
|
|
R |
|
|
S |
B1_VM_PROC |
M |
48 |
0 |
Desc.Process |
|
|
|
V |
|
|
S |
B1_QBP |
N |
7 |
0 |
Base Pre-Es. |
9999999 |
Positivo() |
|
R |
|
|
S |
B1_PRODSBP |
C |
1 |
0 |
Atende Nec? |
@! |
Pertence('PC') |
|
R |
P=Produzindo;C=Comprando |
|
S |
B1_VLCIF |
N |
12 |
3 |
Valor CIF |
@E 99,999,999.999 |
|
|
R |
|
|
S |
B1_CRICMS |
C |
1 |
0 |
ICMS 271 |
@! |
Pertence(" 01") |
|
R |
0=Nao;1=Sim |
|
S |
B1_LOTESBP |
N |
12 |
2 |
Lote SBP |
@E 999,999,999.99 |
Positivo() |
|
R |
|
|
S |
B1_UMOEC |
N |
2 |
0 |
Ult Moe Comp |
|
|
|
R |
|
|
S |
B1_UVLRC |
N |
12 |
2 |
Ult Vlr Comp |
@E 999,999,999.99 |
|
|
R |
|
|
S |
B1_PIS |
C |
1 |
0 |
Retem PIS |
@! |
Pertence("12") |
|
|
1=Sim;2=Nao |
|
S |
B1_GCCUSTO |
C |
8 |
0 |
Gr Cnt Custo |
@! |
Vazio() .Or. ExistCpo('CTR',,1) |
CTR |
R |
|
|
S |
B1_CCCUSTO |
C |
9 |
0 |
CC p/ Custo |
@! |
Vazio() .Or. Ctb105CC() |
CTT |
R |
|
|
S |
B1_CLASSE |
C |
6 |
0 |
Classe Selo |
|
A010B1Class() |
A9 |
|
|
|
S |
B1_VLR_PIS |
N |
12 |
2 |
Pis Pauta |
@e 999,999.99 |
Positivo() |
|
R |
|
|
S |
B1_PARCEI |
C |
6 |
0 |
Parceiro |
@! |
Vazio().OR.ExistCpo('AC4') |
AC4 |
R |
|
|
S |
B1_TALLA |
C |
6 |
0 |
Tamanho |
|
|
|
R |
|
|
S |
B1_GDODIF |
C |
1 |
0 |
Grau Dificul |
|
IF ( !EMPTY(M->B1_GDODIF),EXISTCPO("SX5","GG"+M->B1_GDODIF,1),.T.) |
GG |
R |
|
|
S |
B1_ESCRIPI |
C |
1 |
0 |
Est Cred IPI |
@! |
Pertence(" 123") |
|
|
1=M.P;2=P.A;3=Nao |
|
S |
B1_VALEPRE |
C |
1 |
0 |
Vale Present |
|
Pertence('12') |
|
|
1=Sim;2=Nao |
|
S |
B1_FUSTF |
C |
1 |
0 |
Fust/Funttel |
@! |
Pertence(" 12") |
|
R |
1=Sim;2=Nao |
|
S |
B1_CODQAD |
C |
13 |
0 |
Dep Correcao |
|
FQNCCHKCC(cFilAnt,M->B1_CODQAD) |
QAD |
R |
|
|
S |
B1_PMACNUT |
N |
6 |
2 |
% Macronutr. |
@E 999.99 |
Positivo() |
|
R |
|
|
S |
B1_PMICNUT |
N |
6 |
2 |
% Micronutr. |
@E 999.99 |
Positivo() |
|
R |
|
|
S |
B1_MSBLQL |
C |
1 |
0 |
Blq. de Tela |
|
pertence("12") |
|
|
1=Sim;2=Nao |
|
S |
B1_GRPNATR |
C |
2 |
0 |
Grp.Nat.Rec. |
@! |
|
|
R |
|
|
S |
B1_DTFIMNT |
D |
8 |
0 |
Dt.Fim N. R. |
|
|
|
R |
|
|
S |
B1_DCRE |
C |
10 |
0 |
Nr. DCRE |
@! |
Dcigat('DCRE') |
|
R |
|
|
S |
B1_DCR |
C |
9 |
0 |
Nr. DCR |
@! |
Dcigat('DCR') |
|
R |
|
|
S |
B1_DCRII |
N |
16 |
7 |
Vl. DCRII |
@E 99,999,999.9999999 |
|
|
R |
|
|
S |
B1_COEFDCR |
N |
5 |
2 |
Coef. DCR |
@E 99.99 |
|
|
R |
|
|
S |
B1_DCI |
C |
1 |
0 |
Prod. DCI |
@! |
Pertence(" 12") |
|
R |
1=Sim;2=Nao |
|
S |
B1_DIFCNAE |
C |
11 |
0 |
Dif. CNAE |
@! |
|
|
R |
|
|
S |
B1_DTCORTE |
D |
8 |
0 |
Mud.Reg.Trib |
|
|
|
|
|
|
S |
B1_MARKUP |
N |
5 |
2 |
% Markup |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
B1_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 |
B1_TPPROD |
C |
2 |
0 |
Tipo Medic. |
|
Vazio() .Or. ExistCpo('SX5','92'+M->B1_TPPROD) |
92 |
R |
|
|
S |
B1_FECP |
N |
5 |
2 |
Aliq FECP |
@E 99.99 |
|
|
R |
|
|
S |
B1_CHASSI |
C |
25 |
0 |
Num Chassi |
@! |
|
|
R |
|
|
S |
B1_AFABOV |
N |
5 |
2 |
Aliq. FABOV |
@E 99.99 |
Positivo() |
|
|
|
|
S |
B1_TIPOBN |
C |
2 |
0 |
Tipo BN |
@! |
Vazio() .Or. A010tipo() |
02 |
|
|
|
S |
B1_TPREG |
C |
1 |
0 |
Tp. Reg |
@! |
Pertence(" 12") |
|
|
1=Nao Cumulativo;2=Cumulativo |
|
S |
B1_VEREAN |
C |
2 |
0 |
Codigo EAN |
@! |
|
|
|
|
|
S |
B1_VIGENC |
D |
8 |
0 |
Data Vigenc |
|
|
|
|
|
|
S |
B1_DESBSE2 |
C |
60 |
0 |
Des SubFam |
|
|
|
R |
|
|
S |
B1_TIPVEC |
C |
6 |
0 |
Tipo Vetor |
|
if (!empty(m->b1_tipvec),existcpo("SX5","VC"+M->B1_TIPVEC,1),.T.) |
VC |
R |
|
|
S |
B1_COLOR |
C |
10 |
0 |
Cor |
|
|
|
R |
|
|
S |
B1_SELOEN |
C |
6 |
0 |
Enq. Selo |
@! |
|
|
|
|
|
S |
B1_PRODREC |
C |
1 |
0 |
Material Rec |
@! |
Pertence(" 12") |
|
|
1=Sim;2=Nao |
|
S |
B1_VLR_COF |
N |
12 |
2 |
COFINS Pauta |
@e 999,999.99 |
Positivo() |
|
R |
|
|
S |
B1_PRFDSUL |
N |
12 |
8 |
Pr.Fundersul |
@E 999.9999999 |
|
|
R |
|
|
S |
B1_CNAE |
C |
9 |
0 |
CNAE |
@! |
|
|
R |
|
|
S |
B1_RETOPER |
C |
1 |
0 |
Ret.Operacao |
@! |
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
B1_COFINS |
C |
1 |
0 |
Retem COF |
@! |
Pertence("12") |
|
|
1=Sim;2=Nao |
|
S |
B1_CSLL |
C |
1 |
0 |
Retem CSLL |
@! |
Pertence("12") |
|
|
1=Sim;2=Nao |
|
S |
B1_FETHAB |
C |
1 |
0 |
Inc.FETHAB |
@! |
Pertence("NS") |
|
R |
N=Nao;S=Sim |
|
S |
B1_BASE |
C |
14 |
0 |
Cod Familia |
|
if (!empty(m->b1_BASE),existcpo("SBP",+M->B1_BASE,1),.T.) |
SBP |
R |
|
|
S |
B1_IVAAJU |
C |
1 |
0 |
Cal. IVA Aju |
@! |
Pertence(" 12") |
|
R |
1=SIM;2=NAO |
|
S |
B1_ESTRORI |
C |
15 |
0 |
Estr. Origem |
@! |
A010EstOri() |
SG1SBP |
R |
|
|
S |
B1_CALCFET |
C |
1 |
0 |
Calc. FETHAB |
@! |
Pertence("12") |
|
|
1=Sim;2=Nao |
|
S |
B1_PAUTFET |
N |
9 |
4 |
Pauta FETHAB |
@E 9,999.9999 |
|
|
|
|
|
S |
B1_AFACS |
N |
5 |
2 |
Aliq. FACS |
@E 99.99 |
Positivo() |
|
|
|
|
S |
B1_ALFECRN |
N |
5 |
2 |
Ali.FECOP-RN |
@E 99.99 |
|
|
R |
|
|
S |
B1_ALFECST |
N |
5 |
2 |
Al. FECOP ST |
@E 99.99 |
|
|
|
|
|
S |
B1_CFEM |
C |
1 |
0 |
Cal. CFEM |
@! |
Pertence(" 12") |
|
|
1=Sim;2=Nao |
|
S |
B1_CFEMA |
N |
6 |
2 |
Aliq. CFEMA |
@E 999.99 |
|
|
R |
|
|
S |
B1_CFEMS |
C |
1 |
0 |
Sit. CFEM |
@! |
Pertence(" 123") |
|
|
1=Receita;2=Deduz Seg.;3=Deduz Trans. |
|
S |
B1_CRDPRES |
N |
5 |
2 |
%Cred. Pres |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
B1_CRICMST |
C |
1 |
0 |
Cont ICMS-ST |
@! |
Pertence(" 01") |
|
R |
0=Nao;1=Sim |
|
S |
B1_FECPBA |
N |
5 |
2 |
Aliq FECP BA |
@E 99.99 |
|
|
|
|
|
S |
B1_IDHIST |
C |
20 |
0 |
ID.Hist. |
@! |
|
|
R |
|
|
S |
B1_AJUDIF |
C |
1 |
0 |
Ajust/Difer |
@! |
Pertence(" 1/2") |
|
R |
1=Sim;2=Nao |
|
S |
B1_ALFECOP |
N |
5 |
2 |
Aliq. FECOP |
@E 99.99 |
|
|
|
|
|
S |
B1_FECOP |
C |
1 |
0 |
Calc. FECOP |
@! |
Pertence(" 12") |
|
|
1=Sim;2=Nao |
|
S |
B1_MEPLES |
C |
1 |
0 |
Exe. Servico |
@9 9 |
Pertence(" 12") |
|
R |
1=EP;2=LES |
|
S |
B1_MSEXP |
C |
8 |
0 |
Ident.Export |
|
|
|
R |
|
|
S |
B1_PAFMD5 |
C |
32 |
0 |
MD5 |
|
|
|
|
|
|
S |
B1_PRDORI |
C |
15 |
0 |
Cod. Orig. |
@! |
Vazio() .Or. ExistCpo("SB1") |
SB1 |
R |
|
|
S |
B1_TRIBMUN |
C |
20 |
0 |
C. Trib. Mun |
@! |
|
|
R |
|
|
S |
B1_CODANT |
C |
15 |
0 |
Cod. ant. |
@! |
Vazio() .Or. ExistCpo("SB1") |
SB1 |
R |
|
|
S |
B1_GARANT |
C |
1 |
0 |
Garantia? |
|
Pertence("12") |
|
R |
1=Sim;2=Nao |
M->B1_TIPO <> SuperGetMV("MV_LJTPGAR", ,"GE") |
S |
B1_PERGART |
N |
5 |
2 |
% Garantia |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
B1_ADMIN |
C |
10 |
0 |
Admin. |
@! |
|
PGA |
R |
|
M->B1_TIPO == SuperGetMV("MV_LJTPGAR", ,"GE") |
S |
B1_PR43080 |
N |
6 |
2 |
%Red.43080 |
@E 999.99 |
|
|
|
|
|
S |
B1_REGRISS |
C |
2 |
0 |
Regra ISS Pg |
@! |
|
|
R |
|
|
S |
B1_RPRODEP |
C |
1 |
0 |
Rel. Prodepe |
@! |
Pertence(" 12") |
|
|
1=Sim;2=Nao |
|
S |
B1_RICM65 |
C |
1 |
0 |
Art65 RICMPR |
@! |
Pertence(" 12") |
|
|
1=Sim;2=Nao |
|
N |
B1_PRN944I |
C |
1 |
0 |
Prod. RN944i |
@! |
Pertence("SN") |
|
|
S=Sim;N=Nao |
|
S |
B1_PRINCMG |
N |
6 |
2 |
Pr.Inc.Leite |
@E 999.99 |
|
|
R |
|
|
S |
B1_ALFUMAC |
N |
5 |
2 |
Alq. FUMACOP |
@E 99.99 |
|
|
R |
|
|
S |
B1_CODLAN |
C |
6 |
0 |
Cod.Cat83 |
@! |
Vazio() .Or. ExistCpo('CDZ') |
CDZ |
R |
|
|
S |
B1_CARGAE |
C |
1 |
0 |
Carga Esp? |
@! |
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
B1_BASE2 |
C |
14 |
0 |
SubSubFamil |
|
|
|
R |
|
|
S |
B1_REGESIM |
C |
1 |
0 |
Rg. Simp. MT |
@! |
Pertence(" 12") |
|
|
1=Sim;2=Nao |
|
S |
B1_RSATIVO |
C |
1 |
0 |
Rastro Ativo |
@! |
Pertence(" 12") |
|
R |
1=Sim;2=Nao |
|
S |
B1_SITTRIB |
C |
1 |
0 |
Sit Trib |
@! |
|
|
R |
|
|
N |
B1_TFETHAB |
C |
1 |
0 |
Tipo FETHAB |
@! |
Pertence(" 12345") |
|
R |
1=Soja;2=Algodao;3=Gado;4=Madeira;5=Milho |
|
S |
B1_TPDP |
C |
1 |
0 |
Calc. TPDP |
@! |
Pertence(" 12") |
|
|
1=Sim;2=Nao |
|
S |
B1_CRDEST |
N |
5 |
2 |
Crd Estimulo |
@E 99.99 |
Positivo() |
|
|
|
|
S |
B1_FRETISS |
C |
1 |
0 |
F.Ret.ISS |
@! |
Pertence(' 12') |
|
R |
1=Cons Vlr Minimo;2=Sempre Retem |
|
S |
B1_AFETHAB |
N |
5 |
2 |
Aliq. FETHAB |
@E 99.99 |
Positivo() |
|
|
|
|
S |
B1_AFASEMT |
N |
5 |
2 |
Aliq.FASE-MT |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
B1_AIMAMT |
N |
5 |
2 |
Aliq. IMA-MT |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
B1_AFUNDES |
N |
5 |
2 |
Alq.FUNDESA |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
B1_MOPC |
M |
80 |
0 |
M. Opcional |
@! |
|
|
R |
|
|
S |
B1_CEST |
C |
9 |
0 |
CEST |
@R 99.999.99 |
|
|
R |
|
|
S |
B1_GRPTIDC |
C |
50 |
0 |
Desc. Gr. TI |
@! |
|
|
V |
|
|
S |
B1_HREXPO |
C |
8 |
0 |
Hr. Ult. Exp |
|
|
|
R |
|
|
S |
B1_GRPCST |
C |
3 |
0 |
Enq. IPI |
@! |
Vazio() .or. ExistCpo("F08") |
F08 |
R |
|
|
S |
B1_INTEG |
C |
1 |
0 |
Integracao |
@! |
|
|
|
1=Sim; 2 =Nao |
|
S |
B1_USERLGA |
C |
17 |
0 |
Log de Alter |
|
|
|
R |
|
|
S |
B1_USERLGI |
C |
17 |
0 |
Log de Inclu |
|
|
|
R |
|
|
S |
B1_IMPNCM |
N |
14 |
2 |
Aliq. de Imp |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
B1_PORCPRL |
C |
2 |
0 |
Porc. PRL |
!@ |
Vazio() .Or. Pertence("20/30/40") |
|
R |
20=20%;30=30%;40=40% |
|
S |
B1_GRPTI |
C |
4 |
0 |
Grupo - TI |
@! |
Vazio() .Or. ExistCpo("SX5","XJ"+M->B1_GRPTI) |
XJ |
R |
|
|
S |
B1_AFAMAD |
N |
5 |
2 |
Aliq. FAMAD |
@E 99.99 |
Positivo() |
|
|
|
|
S |
B1_TERUM |
C |
2 |
0 |
Terc Un Med |
@! |
|
|
|
|
|
S |
B1_CODGTIN |
C |
15 |
0 |
Cod. GTIN |
|
A010CodBar(M->B1_CODGTIN,.F.) |
|
R |
|
|
S |
B1_X_APP |
L |
1 |
0 |
Exp. App |
|
|
|
R |
|
|
|