Tabela
SB5 Dados Adicionais do Produto
Campo Tipo Tamanho Decimal Titulo Formato Validacao F3 Contexto Lista Condicao PYME
B5_FILIAL C 2 0 Filial S
B5_COD C 15 0 Produto @! existcpo("SB1").and.existchav("SB5") .and. Freeforuse("SB5") SB1 S
B5_X_DESC C 30 0 Descricao V
B5_PRV2 N 14 2 Preco Venda2 @E 99,999,999,999.99 positivo() .and. A010Preco() S
B5_PRV3 N 14 2 Preco Venda3 @E 99,999,999,999.99 positivo() .and. A010Preco() S
B5_PRV4 N 14 2 Preco Venda4 @E 99,999,999,999.99 positivo() .and. A010Preco() S
B5_PRV5 N 14 2 Preco Venda5 @E 99,999,999,999.99 positivo() .and. A010Preco() S
B5_PRV6 N 14 2 Preco Venda6 @E 99,999,999,999.99 positivo() .and. A010Preco() S
B5_PRV7 N 14 2 Preco Venda7 @E 99,999,999,999.99 positivo() .and. A010Preco() S
B5_CEME C 200 0 Nome Cientif @!S45 S
B5_CODCLI C 15 0 Cod no Clien @! S
B5_CERT C 1 0 Tem Certif. @! Pertence("SN ") S=Sim;N=Nao S
B5_COMPR N 9 2 Comprimento @E 999999.99 positivo() .and. IF(cModulo="EIC",TP254Val(10),.T.) S
B5_DES C 15 0 Cod.Desenho @! S
B5_EMB1 C 10 0 Embalagem 1 @! S
B5_EMB2 C 10 0 Embalagem 2 @! S
B5_ESPESS N 9 2 Espessura @E 999999.99 positivo() .and. If(cModulo="EIC",TP254Val(10),.T.) S
B5_ESTMAT C 1 0 Estado Fisic @! S=Solido;L=Liquido;G=Gasoso S
B5_LARG N 9 2 Largura @E 999999.99 positivo() .and. If(cModulo="EIC",TP254Val(10),.T.) S
B5_QE1 N 5 0 Qtd.Embalag1 99999 positivo() S
B5_QE2 N 5 0 Qtd.Embalag2 99999 positivo() S
B5_CONVDIP N 9 4 Conv. DIPI @E 9999.9999 Positivo() S
B5_DTREFP2 D 8 0 Dt.Ref.Prc 2 S
B5_UMDIPI C 2 0 UM DIPI @! vazio() .or. existCpo("SAH") SAH S
B5_DTREFP3 D 8 0 Dt.Ref.Prc 3 S
B5_CARPER C 1 0 Car.Perigosa @! Pertence("12") R 1=Sim;2=Nao S
B5_DTREFP4 D 8 0 Dt.Ref.Prc 4 S
B5_DTREFP5 D 8 0 Dt.Ref.Prc 5 S
B5_DTREFP6 D 8 0 Dt.Ref.Prc 6 S
B5_DTREFP7 D 8 0 Dt.Ref.Prc 7 S
B5_IDADEM N 2 0 Idade Maxima 99 Positivo() S
B5_COMPRLC N 9 2 Compr.Armaz. @E 999999.99 positivo() S
B5_LARGLC N 9 2 Largu.Armaz. @E 999999.99 positivo() S
B5_ALTURLC N 9 2 Altur.Armaz. @E 999999.99 positivo() S
B5_FATARMA N 5 2 Fator Armaz. @E 99.99 Positivo() S
B5_EMPMAX N 5 2 Empilhagem @E 99.99 Positivo() S
B5_ROTACAO C 1 0 Rotaciona Pr @! Pertence("12") 1=Sim;2=Nao S
B5_CODCAI C 6 0 C.A.I. @E 999999 S
B5_VOLUME N 11 5 Volume M3 @E 99,999.99999 V S
B5_LOCALIZ C 15 0 Endereco S
B5_CODGRP C 4 0 Grupo @!!!! VldAuxCod1("B5_CODGRP","B5_CODITE") SBM V Inclui S
B5_CODITE C 27 0 Cod. Produto VldAuxCod2("B5_COD","B5_CODGRP") B00 V Inclui S
B5_AM4PORC N 5 2 Mult.AM.4% @E 99.99 R S
B5_ZF4PORC N 5 2 Mult.ZF.4% @E 99.99 R S
B5_CODZON C 6 0 Zona Armaz. @! ExistCpo("DC4",M->B5_CODZON) DC4 S
B5_UMIND C 1 0 UM.Industria 9 Pertence('12') 1=1a Unidade de Medida;2=2a Unidade de Medida S
B5_SERVENT C 3 0 Serv.Entrada @! StaticCall(MATA180,VldSvcWMS,'1') DC5 S
B5_SERVINT C 3 0 Serv.Transf. @! StaticCall(MATA180,VldSvcWMS,'3') DC5 S
B5_SERVSAI C 3 0 Serv.Saida @! StaticCall(MATA180,VldSvcWMS,'2') DC5 S
B5_LVLEMB N 14 2 Lim.Val. Emb @E 99,999,999,999.99 S
B5_LPSEMB N 11 4 Lim.Peso Emb @E 999,999.9999 S
B5_INTDI C 1 0 Integ. DI @! Pertence("12") R 1=SIM;2=NAO S
B5_IMPGRUP C 1 0 Imp. Produto @! S
B5_BENDL C 1 0 Benf. DLL @! S
B5_PINSUMO C 1 0 PINSUMO @! S
B5_PERCUB N 6 2 Per.Cubagem @E 999.99% S
B5_PRODDNF N 3 0 Codigo DNF 999 S
B5_PORTMS C 1 0 Portal TMS? Pertence("12") R 1=Sim;2=Nao N
B5_NPULMAO C 1 0 Pulmao @! Pertence("12") R 1=Sim;2=Nao; S
B5_REGMAPA C 10 0 Reg.Agr.Mapa @! R S
B5_INDPETR C 1 0 Ind.Oper. pertence("012") 0=Sem Petr/Comb;1=Deriv. Petr;2=Petr/Comb nao deriv. Petr S
B5_EMBAGRO C 3 0 Cod.Embal. @! S
B5_INSUMO N 3 0 Cod. Insumo @E 999 S
B5_VOLRECI N 5 0 Volume Rec. @E 99999 S
B5_CODISRF N 6 0 Codigo SRF @E 999999 S
B5_USOITE C 1 0 Uso do Item @! pertence("CI") C=Comercial;I=Industrial S
B5_CONCENT N 6 2 Concentracao @E 999.99 R S
B5_DENSID N 6 2 Densidade @E 999.99 R S
B5_FTIN N 7 2 FTI Nacional @E 9999.99 R S
B5_FTIF N 7 2 FTI Fat. @E 9999.99 R S
B5_PROPOR1 N 7 2 Proporcao 1 @E 9999.99 R S
B5_PROPOR2 N 7 2 Proporcao 2 @E 9999.99 R S
B5_CRDEST1 N 7 2 % Estimulo 1 @E 9999.99 R S
B5_CRDEST2 N 7 2 % Estimulo 2 @E 9999.99 R S
B5_LOCALI2 C 15 0 Loc.Secundar @! S
B5_SERVEMB C 3 0 Servico/Emb. 999 StaticCall(MATA180,VldSvcWMS,'2') DC5 S
B5_CALORIA N 7 2 Bas Calorica @E 9999.99 Positivo() R S
B5_PESO N 12 4 Peso @E 9999999.9999 Positivo() R S
B5_TOTGOR N 7 2 Gordura @E 9999.99 Positivo() R S
B5_TOTGORS N 7 2 Gor Saturada @E 9999.99 Positivo() R S
B5_TOTGORT N 7 2 Gor Trans @E 9999.99 Positivo() R S
B5_COR C 15 0 Cor @! R S
B5_ALTURA N 9 2 Altura @E 999999.99 Positivo() R S
B5_MODELO C 30 0 Modelo @! R S
B5_ESPECIE C 5 0 Especie Prod @! R S
B5_ONU C 4 0 Nš ONU @! ExistCpo("DY3",M->B5_ONU) DY3 R S
B5_ITEM C 2 0 Item @! ExistCpo("DY3",M->B5_ONU+M->B5_ITEM) R S
B5_QUALIDA C 5 0 Qualidade @! R N
B5_CMPEXTR C 1 0 Prod. Extrat @! Pertence(" SN") R S=Sim;N=Nao S
B5_CODTP C 3 0 Cod Tp Merc @! R S
B5_EAN141 N 6 0 Qtd 1 EAN14 999999 R N
B5_EAN142 N 6 0 Qtd 2 EAN14 999999 R N
B5_EAN143 N 6 0 Qtd 3 EAN14 999999 R N
B5_EAN144 N 6 0 Qtd 4 EAN14 999999 R N
B5_EAN145 N 6 0 Qtd 5 EAN14 999999 R N
B5_EAN146 N 6 0 Qtd 6 EAN14 999999 R N
B5_EAN147 N 6 0 Qtd 7 EAN14 999999 N
B5_EAN148 N 6 0 Qtd 8 EAN14 999999 R N
B5_TIPUNIT C 1 0 Tipo Unit. Pertence("01") R 0=Nao;1=Sim N
B5_QTDVAR C 1 0 Qtd Variavel @! R 1=Sim;2=Nao N
B5_IMPETI C 1 0 Imprime Eti @! R 1=Sim;2=Nao N
B5_VLDOPER C 1 0 Valida Seq @! Pertence("12") R 1=Sim;2=Nao N
B5_VLDREQ C 1 0 Valida Req @! R 1=Valida na primeira operacao; 2=Valida na ultima operacao; 3= Nao Valida N
B5_DTINV D 8 0 Data Invent. N
B5_PERIOT N 3 0 Periodo 999 R N
B5_NSERIE C 1 0 Num. serie @! Pertence("SN") R S=Sim;N=Nao N
B5_QEI N 9 0 Qtd.Emb.Imp. @E 999,999,999 Positivo() R N
B5_CDDMDBA C 5 0 Cod.DMD-BA @! S
B5_SITDIEF C 2 0 Cod.Sit.DIEF @! Pertence(" 01020304050607") S
B5_DESCNFE M 500 0 Inf.Ad.Prod @! R N
B5_TABINC C 2 0 Cod.Tab.Inc. @! Pertence(" 01/02/03/04/05/06/07/08/09/10/11/12") R S
B5_CODGRU C 2 0 Cod. Grupo @! R S
B5_MARCA C 60 0 Marca @! R S
B5_DIASHL N 3 0 Horiz.Liber. @E 999 Positivo() R S
B5_DIASHF N 3 0 Horiz.Firme @E 999 Positivo() R S
B5_REVPROD C 1 0 Rev.Estrutur @! Pertence("12") R 1=Sim;2=Nao S
B5_CODTRAM C 4 0 Cod.Trib.AM @! S
B5_TPSERV C 1 0 Tp Servico R 1=CC/Ref;2=Conc/Out S
B5_QEL N 9 0 Qtd.Emb.Lei. @E 999,999,999 Positivo() R N
B5_SEMENTE C 1 0 Semente? @! Pertence("12") R 1=Sim;2=Nao N
B5_CULTRA C 10 0 Cultura @! Vazio() .Or. ExistCpo("NP3") NP3 R N
B5_CTVAR C 10 0 Cultivar @! Vazio() .Or. ExistCPO("NP4") NP4 R S
B5_CATEG C 2 0 Categoria @! Vazio() .Or. ExistCpo("SX5","K1"+M->B5_CATEG) K1 R N
B5_COMPEND C 1 0 Comp. Ender. @! Pertence("12") R 1=Permite;2=Nao Permite S
B5_TPESOC C 2 0 Tipo de Serv Vazio() .Or. ExistCpo('SX5','DZ'+ M->B5_TPESOC) DZ R S
B5_MARGPRE N 6 2 % Margem Pre @E 999.99 Positivo() R S
B5_IDHIST C 20 0 ID Hist. @! R S
B5_NRECAGR C 15 0 Num Rec Agro @! R S
B5_INGATV C 40 0 Nom Ingr Atv @! R S
B5_FORCAO C 70 0 Formulacao @! R S
B5_CLASSE C 70 0 Class Agrot @! R S
B5_CONCEN C 25 0 Concentracao @! R S
B5_PROJDES C 1 0 Vinc.Prj.Des @! Pertence("12 ") R 1=Sim;2=Nao S
B5_DESCSER M 10 0 Desc. Serv. R S
B5_PENE C 4 0 Peneira @! Vazio() .Or. ExistCpo("NP7") NP7 R N
B5_PRZCQ N 2 0 Prazo CQ 99 Positivo() R S
B5_VERIND C 1 0 Verif Ind @! Pertence(" 12") R 1=Sim;2=Nao S
B5_CODATIV C 8 0 Cod. Ativ. @! ExistCpo("CG1") CG1 S
B5_REDALIQ C 1 0 Red. Aliq. @! Pertence('12') R 1=Sim; 2=Nao S
B5_FCIPRV N 12 2 Pr.Est.FCI @E 999,999,999.99 S
B5_ISEN C 1 0 Prod.Isento @! Pertence(' 12') 1=Sim;2=Nao S
B5_ZFMULTO N 5 2 Mult.ZF.Ou @E 99.99 R S
B5_ZFMULTS N 5 2 Mult.ZF.SE @E 99.99 R S
B5_AMMULTO N 5 2 Mult.AM.Ou @E 99.99 R S
B5_AMMULTS N 5 2 Mult.AM.SE @E 99.99 R S
B5_CODSERC C 9 0 Cod SERC @! S
B5_NBS C 9 0 NBS @R 9.9999.99.99 Iif(!Empty(M->B5_NBS),EXISTCPO('EL0',M->B5_NBS) .AND. If(FindFunction('LjValidNBS'),LjValidNBS(Alltrim(M->B5_COD)),.T.) ,.T.) EL0 R S
B5_ENDSAI C 15 0 End.Saida @! Vazio() .Or. ExistCpo('SBE', M->B5_ENDSAI,9) SBE S
B5_ECINDIC M 10 0 Indicacao R S
B5_FORMMRP C 1 0 Form. MRP @! Pertence('123') 1=Pelo programa;2=Por OP;3=Por necessidade S
B5_GRPIVA C 3 0 Grupo IVA @! S
B5_MONTA C 1 0 Montagem? 9 Pertence('12') R 1=Sim;2=Nao S
B5_INSPAT C 1 0 INSS Patron @! pertence(" 12") R 1=Sim;2=Nao S
B5_VERSAO C 3 0 Versao @! S
B5_FPRZCQ C 3 0 Form. Prz CQ ExistCpo("SM4") SM4 R S
B5_BLQINVD N 2 0 Dias Blq Inv @E 99 Positivo() R S
B5_DIASES N 3 0 Dias p/ ES @E 999 Positivo() R S
B5_AGLUMRP C 1 0 Aglu. MRP @! Vazio() .Or. ExistCpo("SX5","LU"+M->B5_AGLUMRP) LU R S
B5_PROTCON C 30 0 Prot/Conv @! R S
B5_ALTTRIB C 1 0 Alter. Trib. @! Pertence("12 ") R 1=Sim;2=Nao S
B5_CODGNRE N 3 0 Cod.Prod. 999 R S
B5_ECSEQ2 C 15 0 Seq Export2 R S
B5_ENDENT C 15 0 End.Entrada @! Vazio() .Or. ExistCpo('SBE', M->B5_ENDENT, 9) SBE S
B5_SERVREQ C 3 0 Serv.Requis @! StaticCall(MATA180,VldSvcWMS,'2') DC5 S
B5_ENDREQ C 15 0 End.Requis. @! Vazio() .Or. ExistCpo('SBE', M->B5_ENDREQ, 9) SBE S
B5_SERVDEV C 3 0 Serv.Devoluc @! StaticCall(MATA180,VldSvcWMS,'1') DC5 S
B5_ENDDEV C 15 0 End.Devoluc. @! Vazio() .Or. ExistCpo('SBE', M->B5_ENDDEV, 9) SBE S
B5_FORSER C 3 0 Formula End. ExistCpo("SM4") SM4 R S
B5_ENVMKT C 1 0 ENVIA MKT @! Pertence("012") R 0=Nao;1=Sim;2=Talvez S
B5_CTDACON C 9 0 Cat. Dacon @! R S
B5_BLQINVA C 1 0 Blq. Invent. Pertence('12') R 1=Sim;2=Nao S
B5_TIPO C 1 0 TIpo @! Pertence("12") R 1=Material;2=Servico S
B5_DEC7174 C 1 0 Dec. 7174 @! Pertence("12") R 1=Sim;2=Nao S
B5_CTRWMS C 1 0 Ctr WMS @! Pertence("12") .and. A180CtrWms() R 1=Sim;2=Nao S
B5_ECCUBAG N 9 0 Cubagem C3 @E 999,999,999 R S
B5_ECAPRES M 10 0 Apresentacao R S
B5_ECBENFI M 10 0 Beneficio R S
B5_ECDTEX2 C 8 0 Dt Export2 R S
B5_ECIMGFI C 90 0 Imagem Prod @! R S
B5_ECPCHAV C 254 0 Palavra Chav @! R S
B5_ECDTLAN D 8 0 Data Lancam. R S
B5_CATMAT C 20 0 Cat. Governo @! R S
B5_PROTOTI L 1 0 Prototipo A180VldPrt() R S
B5_TPISERV C 1 0 Tipo Insumo Pertence('12345') R 1=Arma;2=Colete;3=Municoes;4=Recursos Humanos;5=Outros S
B5_GSMI C 1 0 Mat Implant? @! Pertence('12') R 1=Sim;2=Nao A180TPSERV("B5_GSMI") S
B5_GSMC C 1 0 Mat Consumo? @! Pertence("12") R 1=Sim;2=Nao A180TPSERV("B5_GSMC") S
B5_CDFATD C 5 0 Familia Tec. @! ExistCpo("CZL") CZL001 R S
B5_ECDESCR M 10 0 Descricao @! S
B5_ECENQUA C 20 0 Cod Int Enqu S
B5_ECPESOE N 10 2 Peso Emb @E 9,999,999.99 S
B5_ECALTEM N 10 2 Alt Emb @E 9,999,999.99 S
B5_WMSEMB C 1 0 Utiliza Emb. @! R 1=Sim; 2=Nao; S
B5_NATBEN C 2 0 Nat. Benef. @! NU R S
B5_DTDECRE D 8 0 Dt.Decreto R S
B5_FUNCEP C 1 0 FUNCEP @! R 1=Sim; 2=Nao S
B5_VLRCID N 9 2 CIDE Pauta @E 999,999.99 Positivo() R S
B5_ECSUBT C 100 0 Subtitulo @! R S
B5_GSLE C 1 0 Loc. Equip? @! Pertence("12") R 1=Sim;2=Nao A180TPSERV("B5_GSLE") S
B5_ECEAN1 C 20 0 Cod EAN13 @! R S
B5_NATALBE C 2 0 Nat.Alt.Ben NU R S
B5_NUMBEAL C 5 0 Num.Decr.Alt @! R S
B5_ECSEQ C 15 0 Seq Export @! S
B5_ECLARGE N 10 2 Largura Emb @E 9,999,999.99 S
B5_DTDECAL D 8 0 Dt.Decre.Alt R S
B5_NUMBEN C 5 0 Num. Decreto @! R S
B5_ANOBEN C 4 0 Ano.Vig.Ben 9999 R S
B5_ISIDUNI C 1 0 Id unico @9 Pertence("12") R 1=Sim;2=Nao A180TPSERV("B5_ISIDUNI") S
B5_LEADTR N 5 0 LT Trans @E 99999 Positivo() R S
B5_CODFAM C 6 0 Familia Peca ExistCpo("SX5","0B"+M->B5_CODFAM) 0B R S
B5_MARPEC C 6 0 Marca Pela ExistCpo("VQS",M->B5_MARPEC) VQS R S
B5_TPAPUR C 1 0 Tp Apuracao @! R S
B5_ECCARAC M 10 0 Caracterist. R S
B5_ECPROFU N 10 2 Prof. Produt @E 9,999,999.99 S
B5_ECLARGU N 10 2 Largura @E 9,999,999.99 R S
B5_ECDTEX C 8 0 Dt Exportac S
B5_ECTITU C 100 0 Titulo @! R S
B5_ECCOMP N 10 2 Comprimento @E 9,999,999.99 R S
B5_ECFLAG C 1 0 E-Commerce R 1=Ativo;2=Inativo S
B5_CODLIN C 6 0 Linha Peca ExistCpo("SX5","0A"+M->B5_CODLIN) 0A R S
B5_DESTRAT C 40 0 Desc. Trata. @! V S
B5_TRATAM C 6 0 Tp. Tratame. @! Vazio() .Or. ExistCpo("NKD") R S
B5_UMPRC C 2 0 UM Preco @! ExistCpo("SAH") SAH R S
B5_CLAUBA C 3 0 Cla. Produto @! R S
B5_ISDSHIP C 1 0 Vda Dir. DPM @! Pertence("01") R 0=Nao;1=Sim S
B5_INSSPAT C 1 0 Inc.Ins.Pat. @! Pertence("12") R 1=Sim;2=Nao S
B5_VLZERO C 1 0 Valor Zero @! Pertence("12") 1=Sim;2=Nao S
B5_ECDESF C 1 0 Envia Desc. @! Pertence("12") R 1=Sim;2=Nao S
B5_INDCPRB C 1 0 Ind. CPRB @! Pertence("01") R 0=Nao;1=Sim S
B5_SERVTDV C 3 0 Serv.TrDev. @! StaticCall(MATA180,VldSvcWMS,'3') DC5 R S
B5_ENDECD C 15 0 End.En.Cross @! Vazio() .Or. ExistCpo('SBE' , M->B5_ENDECD,9) SBE R S
B5_SERSCD C 3 0 Ser.Sai.Cros @! StaticCall(MATA180,VldSvcWMS,'2') DC5 R S
B5_ARREQTD C 1 0 Arred.Qt.Dis Pertence("12") R 1=Sim;2=Nao S
B5_ENDSCD C 15 0 End.Sai.Cros @! Vazio() .Or. ExistCpo('SBE' , M->B5_ENDSCD,9) SBE R S
B5_SERECD C 3 0 Ser.En.Cross @! StaticCall(MATA180,VldSvcWMS,'1') DC5 R S
B5_2CODBAR C 15 0 2 UN Cod Bar @! A010COdBar(M->B5_2CODBAR) S
B5_TPCOMMO C 1 0 Tp.Commodit. @! Pertence(" 02") R 0=Nao se Aplica;2=Algodao S
B5_TAKEUP C 1 0 Take-Up? @! Pertence("12") R 1=Sim;2=Nao If(M->B5_TPCOMMO=="2", .T., .F.) S