Ajude o site desativando o bloqueador de anúncio
Cabeçalho

Tabela 2410 EE8

Autor: Eurai Criado: 01/03/2025 Atualizado: 01/03/2025 Protheus
Postagem

Salve salve, blz?

 

 

Tabela EE8. #EE8

 

 

 

 

SX2 - TABELA

X2_CHAVE X2_PATH X2_ARQUIVO X2_NOME X2_NOMESPA X2_NOMEENG X2_ROTINA X2_MODO X2_MODOUN X2_MODOEMP X2_DELET X2_TTS X2_UNICO X2_PYME X2_MODULO X2_DISPLAY X2_SYSOBJ X2_USROBJ X2_POSLGT X2_CLOB X2_AUTREC X2_TAMFIL X2_TAMUN X2_TAMEMP X2_STAMP X2_INSDT
EE8 DATA EE8990 Itens Processo de Exportação Items Proceso de Exportacion Export Process Items E E E 0 EE8_FILIAL+EE8_PEDIDO+EE8_SEQUEN+EE8_ITEMGR N 29 EE8_PEDIDO+EE8_COD_I+EE8_VM_DES+EE8_CODQUA+EE8_CODPEN+EE8+DSCPEN EECAP100 1 2 2 2 0 0

 

 

 

 

SX3 - CAMPOS

X3_ARQUIVO X3_ORDEM X3_CAMPO X3_TIPO X3_TAMANHO X3_DECIMAL X3_TITULO X3_DESCRIC X3_PICTURE X3_VALID X3_RELACAO X3_F3 X3_NIVEL X3_TRIGGER X3_BROWSE X3_VISUAL X3_CONTEXT X3_OBRIGAT X3_CBOX X3_PICTVAR X3_WHEN X3_INIBRW X3_GRPSXG X3_FOLDER
EE8 09 EE8_QUADES C 6 0 Desc. Quali. Descrição Qualidade 1 N A R
EE8 01 EE8_FILIAL C 2 0 Filial Filial do Sistema 1 N 033 1
EE8 02 EE8_PEDIDO C 20 0 Pedido Codigo Pedido 1 N lALTERA 1
EE8 03 EE8_SEQUEN C 6 0 Sequencia Ordem de input 1 N lALTERA 1
EE8 04 EE8_COD_I C 15 0 Codigo Item Codigo Item @! NaoVazio() .And. EECVLEE8("EE8_COD_I") .And. AP102Grade("EE8_COD_I") EB1 1 S S lALTERA 030 1
EE8 05 EE8_DESC C 6 0 Descricao Descricao @! 1 S lALTERA 1
EE8 06 EE8_VM_DES M 60 0 Descr. Item Descr. Item EECIniPad("EE8_VM_DES") 1 N V lALTERA 1
EE8 07 EE8_CODQUA C 10 0 Qualidade Codigo da qualidade @! ExistCpo("EXW") EXW 1 S N A R 1
EE8 08 EE8_DSCQUA M 60 0 Desc. Quali. Descricao Qualidade EECIniPad('EE8_DCSQUA') 1 N A V 1
EE8 10 EE8_CODPEN C 10 0 Peneira Cod. Peneira @! ExistCpo("EXX") EXX 1 S N A R 1
EE8 11 EE8_DSCPEN C 60 0 Dsc. Peneira Desc. peneira 1 N A R 1
EE8 12 EE8_CODTIP C 10 0 Tipo Cod. Tipo @! ExistCpo("EXY") EXY 1 S N A R 1
EE8 13 EE8_DSCTIP C 60 0 Dsc. Tipo Dsc. Tipo 1 N A R 1
EE8 14 EE8_CODBEB C 10 0 Cod Bebida Código Bebida @! ExistCpo("EY3") EYA 1 S S A R lAltera 1
EE8 15 EE8_DSCBEB C 60 0 Descr Bebida Descrição da Bebida @! 1 N lAltera 1
EE8 16 EE8_FORN C 6 0 Fornecedor Fornecedor @! AP100CRIT("EE8_FORN") .AND. AP100Crit("EE7_MARCAC") AVE005 1 S S A R lALTERA 001 1
EE8 17 EE8_FOLOJA C 2 0 Loja Loja do Fornecedor @! AP100CRIT("EE8_FOLOJA") .AND. AP100Crit("EE7_MARCAC") 1 S lALTERA 002 1
EE8 18 EE8_FABR C 6 0 Fabricante Fabricante @! AP100CRIT("EE8_FABR") .AND. AP100Crit("EE7_MARCAC") AVE014 1 S S lALTERA 001 1
EE8 19 EE8_FALOJA C 2 0 Loja Loja do FABRICANTE @! AP100CRIT("EE8_FALOJA") .AND. AP100Crit("EE7_MARCAC") 1 S lALTERA 002 1
EE8 20 EE8_SLDINI N 14 5 Quantidade Quantidade inicial item @E 99,999,999.99999 NaoVazio() .And. Positivo() .And. EECVLEE8("EE8_SLDINI") .And. AP102Grade("EE8_SLDINI") 1 S N AP100W("EE8_SLDINI") 1
EE8 21 EE8_UNIDAD C 2 0 U.M.Qtde Unidade Medida Quantidade ExistCpo("SAH") SAH 1 S N lALTERA 122 1
EE8 A7 EE8_ATOCON C 13 0 Ato Conces Ato concessorio 9999999999999 1 S A R AP100W("EE8_ATOCON") 1
EE8 A6 EE8_MOP M 10 0 M. Opcional Memo Opcional @! 1 N V .F. 1
EE8 A5 EE8_OPC C 80 0 Opcional PE Opcionais utilizados p/PE @!S40 1 N V .F. 1
EE8 A2 EE8_PEDERP C 20 0 Pedido ERP Pedido de origem ERP @! 1 S V R 1
EE8 A1 EE8_DESOPE C 60 0 Desc. Op. Es Desc Operacão Especial @! Posicione('EJ0',1,xFilial('EJ0') + M->EE8_CODOPE ,'EJ0_DESC') 1 S V V 1
EE8 A0 EE8_CODOPE C 2 0 Cód. Ope. Es Cód. Operacão Especial @! ValidOpe('EE8_CODOPE') EJ0 1 S S lALTERA 1
EE8 96 EE8_DIFE2 N 12 4 Diferenc.Off Diferencial Off-Shore @E 999,999.9999 1 N A R M->EE7_INTERM="1" 2
EE8 69 EE8_DTQNCM C 2 0 Destaque NCM Destaque da NCM @R 99 EECVLEE8("EE8_DTQNCM") 1 S lALTERA 1
EE8 68 EE8_DTCOTA D 8 0 Dt.Cotacao Data Cotacao @D 1 N AP100W("EE8_DTCOTA") 2
EE8 67 EE8_RV C 9 0 Numero do RV Numero do RV @R 99/9999999 EECVLEE8("EE8_RV") 1 N V lALTERA 1
EE8 66 EE8_POSIPI C 10 0 NCM Nomenclatura Ext.Mercosul @R 9999.99.99 Vazio() .OR.ExistCpo("SYD",M->EE8_POSIPI) SYD2 1 S S lALTERA 1
EE8 65 EE8_MESFIX C 6 0 Mes Fixacao Mes Fixacao @R 99/9999 1 N lALTERA 2
EE8 64 EE8_STA_RV C 1 0 Status do RV Status do RV ! EECVLEE8("EE8_STA_RV") 1 N lALTERA 1
EE8 63 EE8_SEQ_RV C 2 0 Sequencia RV Sequencia do RV 99 EECVLEE8("EE8_SEQ_RV") 1 N lALTERA 1
EE8 62 EE8_VM_FIX C 60 0 Sit. Fixacao Situacao da fixacao AP100ShowStFix() 1 N V .F. 2
EE8 61 EE8_VLCOM N 16 2 Comissao Valor da comissao @E 9,999,999,999,999.99 Positivo() .AND. AP100CRIT("EE8_VLCOM") 1 N A R AP100W("EE8_VLCOM") 1
EE8 60 EE8_PERCOM N 5 2 Comissao % Comissao Siscomex % @E 99.99 Positivo() .AND. AP100CRIT("EE8_PERCOM") 1 S N AP100W("EE8_PERCOM") 1
EE8 59 EE8_CODAGE C 6 0 Agente Com. Codigo Agente Comissao @! EECValidAg() .And. Ap100Crit("EE8_CODAGE") AGE 1 S S AP100W("EE8_CODAGE") 001 1
EE8 58 EE8_STATUS C 1 0 Situacao Situacao do produto 1 N lALTERA 1
EE8 57 EE8_OPER C 2 0 Tp. Operacao Tipo de Operacao Vazio() .Or. ExistCpo("SX5","DJ"+M->EE8_OPER) DJ 1 N A R ECAP100When("EE8_OPER") 1
EE8 56 EE8_FATIT C 2 0 Item do PV Item do Pedido de Venda 1 N V 1
EE8 55 EE8_NALSH C 8 0 NALADI SH NALADI SH @R 9999.99.99 VAZIO().OR.ExistCpo("SJ1",M->EE8_NALSH) SJ1 1 N lALTERA 1
EE8 54 EE8_TES C 3 0 Tipo Saida Tipo de Saida do Item @9 NaoVazio() .And. ExistCpo("SF4") SF4 1 S N ECAP100When("EE8_TES") 1
EE8 53 EE8_CF C 5 0 Cod. Fiscal Codigo Fiscal da Operaçao @9 NaoVazio() .AND. AP100Valid() 13 1 N ECAP100When("EE8_CF") 1
EE8 52 EE8_PRCINC N 14 2 Prc.Tot.FOB Preco Total FOB @E 99,999,999,999.99 naovazio().and.POSITIVO() 1 S lALTERA 1
EE8 51 EE8_REFCLI C 20 0 Ref.Cliente Ref.Cliente @! 1 N lALTERA 1
EE8 50 EE8_NLNCCA C 7 0 NALADI NCCA NALADI NCCA @R 9999.99.9 VAZIO().OR.ExistCpo("SJ2",M->EE8_NLNCCA) SJ2 1 N lALTERA 1
EE8 49 EE8_TPONCM C 2 0 Tipo NCM Tipo do NCM 99 EECVLEE8("EE8_TPONCM") 1 S lALTERA 1
EE8 48 EE8_DPCOD C 15 0 Cod.Divisao Codigo da Divisao @! VAZIO() .OR. EXISTCPO("EEG",cIDCAPA+M->EE8_DPCOD,1) AVE012 1 N lALTERA 1
EE8 47 EE8_PSBRTO N 12 4 Peso Bru.Tot Peso Bruto Total @E 9,999,999.9999 1 N V lALTERA 1
EE8 46 EE8_GPCOD C 15 0 Cod.Grupo Codigo do Grupo @! ExistCpo("EEH",M->EE7_IDIOMA+M->EE8_GPCOD) AVE010 1 N lALTERA 1
EE8 45 EE8_FPCOD C 10 0 Cod.Familia Codigo da Familia @! VAZIO() .OR. EXISTCPO("SYC",M->EE8_FPCOD,1) SYC 1 N lALTERA 1
EE8 44 EE8_PSBRUN N 14 5 Peso Bru.Un. Peso Bruto Unitario @E 99,999,999.99999 Positivo().AND.EECVLEE8("EE8_PSBRUN") 1 N lALTERA 1
EE8 43 EE8_PSLQTO N 12 4 Peso Liq.Tot Peso Liquido Total @E 9,999,999.9999 1 N V lALTERA 1
EE8 42 EE8_PSLQUN N 14 5 Peso Liq.Un. Peso Liquido Unitario @E 99,999,999.99999 POSITIVO().AND.EECVLEE8("EE8_PSLQUN") 1 N lALTERA 1
EE8 41 EE8_UNPES C 2 0 U.M. Peso Unidade de medida peso Vazio() .Or. ExistCpo("SAH") SAH 1 S N lALTERA 122 1
EE8 40 EE8_SLDATU N 14 5 Sld.Atual Quantidade atual do item @E 99,999,999.99999 1 N lALTERA 1
EE8 39 EE8_PRCTOT N 14 2 Preco Total Preco total item @E 99,999,999,999.99 naovazio().and.POSITIVO().AND. EECVLEE8("EE8_PRCTOT").and.ap100precoI() 1 S lALTERA 1
EE8 38 EE8_PRECOI N 15 7 Preco FOB Preco FOB @E 9,999,999.9999999 POSITIVO() 1 S V lALTERA 1
EE8 37 EE8_DTENTR D 8 0 Dt.Entrega Data entrega @D Vazio() .Or. EECVLEE8("EE8_DTENTR") dDATABASE 1 N lALTERA 1
EE8 36 EE8_DTPREM D 8 0 Dt.Prev.Emb. Data previsao embarque @D Vazio() .Or. EECVLEE8("EE8_DTPREM") dDATABASE 1 N lALTERA 1
EE8 35 EE8_DESCON N 15 2 Desconto Desconto @E 999,999,999,999.99 (VAZIO() .OR. POSITIVO()) .AND. AP100CRIT("EE8_DESCON") 1 A R lAltera 1
EE8 34 EE8_PRENEG N 15 7 Preço Negoc. Preço Negociado @E 9,999,999.9999999 VAZIO() .OR. Positivo() 1 S N A R M->EE7_INTERM="1" 1
EE8 33 EE8_DTPROD D 8 0 Dt.Producao Data de Producao 1 1
EE8 32 EE8_PRECO2 N 15 7 Preco $/60Kg Preco US$/Saca de 60Kg @E 9,999,999.9999999 POSITIVO() .AND. AP104GATPRECO() 1 N A R AP100W("EE8_PRECO") 1
EE8 31 EE8_PRECO3 N 15 7 Preco cen/Lb Preco Cents/Libra @E 9,999,999.9999999 POSITIVO() .AND. AP104GATPRECO() 1 S A R AP100W("EE8_PRECO") 1
EE8 30 EE8_PRECO4 N 15 7 Preco $/Ton Preco US$/Tonelada @E 9,999,999.9999999 POSITIVO() .AND. AP104GATPRECO() 1 S A R AP100W("EE8_PRECO") 1
EE8 29 EE8_PRECO5 N 15 7 Preco $/50Kg Preco US$/Saca de 50 Kg @E 9,999,999.9999999 POSITIVO() .AND. AP104GATPRECO() 1 N A R AP100W("EE8_PRECO") 1
EE8 28 EE8_PART_N C 20 0 Part-Number Part-Number @! 1 S lALTERA 1
EE8 27 EE8_PRECO N 15 7 Preco Unit. Preco Unit. @E 9,999,999.9999999 AP100CRIT("EE8_PRECO") .AND. POSITIVO() .AND. EECVLEE8("EE8_PRECO") .AND. AP104GATPRECO(,.T.) 1 S S AP100W("EE8_PRECO") 1
EE8 26 EE8_QE N 14 5 Qt.na Embal. Quantidade na Embalagem @E 99,999,999.99999 NaoVazio().And.Positivo().AND.EECVLEE8("EE8_QE") 1 N Ap100w("EE8_QE") 1
EE8 25 EE8_PRVPRO D 8 0 Prev. Prod. Prev. Prod 1 1
EE8 24 EE8_QTDEM1 N 10 0 Qt.de Embal. Quantidade de Embalagem @E 9,999,999,999 naovazio().and.positivo().AND.EECVLEE8("EE8_QTDEM1") 1 N Ap100w("EE8_QTDEM1") 1
EE8 23 EE8_UNPRC C 2 0 U.M. Preco Unidade de medida preco Vazio() .Or. ExistCpo("SAH") .AND. AP104GATPRECO() SAH 1 S N lALTERA 122 1
EE8 22 EE8_EMBAL1 C 20 0 Embalagem 1. embalagem NaoVazio().And.ExistCpo("EE5",M->EE8_EMBAL1).And.EECVLEE8("EE8_EMBAL1") EE5 1 S N Ap100w("EE8_EMBAL1") 1
EE8 A4 EE8_DTELIM D 8 0 Dt. Elimin. Data da Eliminação 1 N
EE8 A3 EE8_SLDELI N 14 5 Sld. Elimin. Saldo Eliminado @E 99,999,999.99999 1 N
EE8 99 EE8_RESERV C 6 0 Num.Reserva Numero da Reserva @! Vazio() .or. EECVLEE8("EE8_RESERV") SC0 1 N
EE8 98 EE8_ITEMGR C 3 0 Item Grade Item da grade 1 N A R
EE8 97 EE8_GRADE C 1 0 GRADE Grade de produtos 1 N A R S=SIM;N=NAO
EE8 95 EE8_VLDESC N 14 2 Vl. Desconto Valor do Desconto @E 99,999,999,999.99 1 N A R
EE8 94 EE8_VLOUTR N 14 2 Outras Desp. Vl. de Outras Despesas @E 99,999,999,999.99 1 N A R
EE8 91 EE8_SEQ_LC C 6 0 Seq. L/C Sequência do Item da L/C @ 999999 (Vazio() .Or. ExistCpo("EXS",M->(EE8_LC_NUM+EE8_SEQ_LC))) .And. Ap100Crit("EE8_SEQ_LC") EXS 1 N A R lAltera .And. Ap100W("EE8_SEQ_LC") 1
EE8 89 EE8_VLPAG N 15 7 Pre. Un. Pag Preco Unitario a Pagar @E 9,999,999.9999999 AP106Valid("EE8_VLPAG") 1 N A R 3
EE8 88 EE8_LC_NUM C 20 0 Nr. L/C Número da L/C @! (Vazio() .Or. ExistCpo("EEL")) .And. Ap100Crit("EE8_LC_NUM") EEL 1 N A R lAltera 1
EE8 87 EE8_INVPAG C 20 0 Invoice Pag. Invoice a Pagar @! AP106Valid("EE8_INVPAG") If(len(aColsBtB) > 0,aColsBtB[1][3],SPACE(SX3->X3_TAMANHO)) IVP 1 N A R 3
EE8 86 EE8_DIFERE N 12 4 Diferencial Diferencial @E 999,999.9999 1 S N A R lALTERA 2
EE8 85 EE8_VM_NOR C 60 0 Desc.Norma Descricao da Norma @! EECIniPad("EE8_VM_NOR") 1 N V V 1
EE8 83 EE8_CODNOR C 3 0 Cod.Norma Codigo da Norma @! Vazio() .Or. AC120NorVal("EE8_CODNOR") EXN 1 S N 1
EE8 81 EE8_DTVALI D 8 0 Valid. Lote Valid. Lote 1 1
EE8 80 EE8_NUMLOT C 6 0 Sub-Lote Sub-Lote @! 1 1
EE8 79 EE8_TIPCOM C 1 0 Tipo Comiss. Tipo da Comissão ! Vazio() .Or. (Pertence("123 ") .And. EECValidAg(.f.) .And. Ap100Crit("EE8_TIPCOM")) 1 N A R 1=A Remeter;2=Conta Gráfica;3=Deduzir da Fatura !Empty(M->EE8_CODAGE) 1
EE8 78 EE8_LOTECT C 10 0 Lote Lote 1 068 1
EE8 77 EE8_DSCAGE C 40 0 Desc.Agente Desc.Agente @! EECDscAg() 1 S V V 1
EE8 76 EE8_ORIGEM C 6 0 Origem Sequencia do item pai 1 S 1
EE8 75 EE8_QTDLOT N 14 5 Qtde. Lots Quantidade Lots @E 99,999,999.99999 Positivo() 1 N AP100W("EE8_QTDLOT") 2
EE8 73 EE8_QTDFIX N 14 5 Qtde.Fixada Quantidade Fixada @E 99,999,999.99999 If(!Empty(M->EE8_DTFIX),M->EE8_SLDINI,0) 1 S N V AP100W("EE8_QTDFIX") 2
EE8 72 EE8_PRCFIX N 15 7 Preco Fixado Preco Fixado @E 9,999,999.9999999 If(!Empty(M->EE8_DTFIX),M->EE8_PRECO,0) 1 S N V AP100W("EE8_PRCFIX") 2
EE8 71 EE8_DTFIX D 8 0 Dt.Fixacao Data Fixacao @D 1 S N AP100W("EE8_DTFIX") 2
EE8 93 EE8_VLSEGU N 14 2 Vl. Seguro Valor do Seguro @E 99,999,999,999.99 1 N A R
EE8 92 EE8_VLFRET N 14 2 Vl. do Frete Valor do Frete @E 99,999,999,999.99 1 N A R
EE8 90 EE8_PRCUN N 15 7 Prc.Un.Incot Preco Unit. Incoterm @E 9,999,999.9999999 1 N A R
EE8 84 EE8_ORIGV C 6 0 Orig.Vinc.RV Origem Vinculacöo RV 1 N V
EE8 82 EE8_DTVCRV D 8 0 Dt.Vinc.RV Data de Vinculacöo do RV @D 1 S V
EE8 74 EE8_STFIX C 1 0 Sit.Fixacao Situacao da Fixacao 1 N
EE8 70 EE8_DTRV D 8 0 Data do RV Data do RV @D 1 N V

 

 

 

 

SIX - INDICES

INDICE ORDEM CHAVE DESCRICAO DESCSPA DESCENG PROPRI F3 NICKNAME SHOWPESQ IX_VIRTUAL IX_VIRCUST
EE8 1 EE8_FILIAL+EE8_PEDIDO+EE8_SEQUEN+EE8_COD_I Pedido + Sequencia + Codigo Item Pedido + Secuencia + Codigo Item Order + Sequence + Item Code S S 2 3
EE8 2 EE8_FILIAL+EE8_FORN+EE8_FOLOJA Fornecedor + Loja Proveedor + Tienda Supplier + Store S S 2 3
EE8 3 EE8_FILIAL+EE8_FABR+EE8_FALOJA Fabricante + Loja Fabricante + Tienda Manufacturer + Store S S 2 3
EE8 4 EE8_FILIAL+EE8_PEDIDO+EE8_ORIGEM Pedido + Origem Pedido + Origen Order + Source S S 2 3
EE8 5 EE8_FILIAL+EE8_LC_NUM+EE8_SEQ_LC Nr. L/C + Seq. L/C Nr. L/C + Sec. L/C L/C Nbr + Seq. L/C S S 2 3

 

 

 

 

SX7 - GATILHOS

X7_CAMPO X7_SEQUENC X7_REGRA X7_CDOMIN X7_TIPO X7_SEEK X7_ALIAS X7_ORDEM X7_CHAVE X7_CONDIC X7_PROPRI
EE8_COD_I 001 SB1->B1_PESO EE8_PSLQUN P S SB1 1 XFILIAL("SB1")+M->EE8_COD_I S
EE8_COD_I 002 SB1->B1_CODEMB EE8_EMBAL1 P N 0 Empty(M->EE8_EMBAL1) S
EE8_COD_I 003 IF(GetMv("MV_GRADE",,.F.) .And. !Empty(M->EE8_UNIDAD), M->EE8_UNIDAD, SB1->B1_UM) EE8_UNIDAD P N 0 S
EE8_COD_I 004 SB1->B1_QE EE8_QE P N 0 Empty(M->EE8_QE) S
EE8_COD_I 005 IF(EECPPE07("CALCEMB"),M->EE8_DESC,M->EE8_DESC) EE8_DESC P N 0 S
EE8_COD_I 006 IF(AP100PrecoI(),M->EE8_DESC,M->EE8_DESC) EE8_DESC P N 0 S
EE8_COD_I 007 IF(!Empty(SA5->A5_VLCOTUS),SA5->A5_VLCOTUS,M->EE8_PRECO) EE8_PRECO P S SA5 1 XFILIAL("SA5")+M->EE8_FORN+M->EE8_FOLOJA+M->EE8_COD_I S
EE8_COD_I 008 IF(!Empty(SA5->A5_CODPRF),SA5->A5_CODPRF,M->EE8_PART_N) EE8_PART_N P S SA5 1 XFILIAL("SA5")+M->EE8_FORN+M->EE8_FOLOJA+M->EE8_COD_I S
EE8_COD_I 009 IF(!Empty(SA5->A5_UNID),SA5->A5_UNID,M->EE8_UNIDAD) EE8_UNIDAD P S SA5 1 XFILIAL("SA5")+M->EE8_FORN+M->EE8_FOLOJA+M->EE8_COD_I S
EE8_COD_I 010 IF(!Empty(SA5->A5_FABR),SA5->A5_FABR,M->EE8_FABR) EE8_FABR P S SA5 1 XFILIAL("SA5")+M->EE8_FORN+M->EE8_FOLOJA+M->EE8_COD_I S
EE8_COD_I 011 IF(!Empty(SA5->A5_FALOJA),SA5->A5_FALOJA,M->EE8_FALOJA) EE8_FALOJA P S SA5 1 XFILIAL("SA5")+M->EE8_FORN+M->EE8_FOLOJA+M->EE8_COD_I S
EE8_COD_I 012 Ap100ShowStFix(.T.) EE8_VM_FIX P 0 S
EE8_COD_I 013 TABPRECO(M->EE8_PRECO,M->EE8_COD_I,"",M->EE7_IMPORT+M->EE7_IMLOJA,M->EE7_MOEDA) EE8_PRECO P N 0 S
EE8_COD_I 014 M->EE8_VM_DES EE8_VM_DES P N 0 BUSCAPROCLI() S
EE8_COD_I 015 EXN->EXN_NORMA EE8_CODNOR P S EXN 1 xFilial("EXN")+M->EE8_COD_I+M->EE7_PAISET S
EE8_COD_I 016 MSMM(EEI->EEI_DESC,60,1) EE8_VM_NOR P S EEI 1 XFILIAL("EEI")+M->EE8_CODNOR !EMPTY(M->EE8_CODNOR) S
EE8_CODAGE 001 If(!Empty(M->EE8_CODAGE),WorkAg->EEB_NOME,Space(1)) EE8_DSCAGE P N 0 S
EE8_CODBEB 001 EY3->EY3_DSCBEB EE8_DSCBEB P S EY3 1 xFilial("EY3")+M->EE8_CODBEB S
EE8_CODNOR 001 MSMM(EEI->EEI_DESC,60,1) EE8_VM_NOR P S EEI 1 XFILIAL("EEI")+M->EE8_CODNOR !EMPTY(M->EE8_CODNOR) S
EE8_CODOPE 001 EJ0->EJ0_DESC EE8_DESOPE P S EJ0 1 xFilial('EJ0')+M->EE8_CODOPE S
EE8_CODPEN 001 EXX->EXX_DSCPEN EE8_DSCPEN P S EXX 1 xFilial("EXX")+M->EE8_CODPEN S
EE8_CODQUA 001 MSMM(EXW->EXW_QUADES,AVSX3("EXW_DSCQUA",3),,,) EE8_DSCQUA P S EXW 1 xFilial("EXW")+M->EE8_CODQUA S
EE8_CODTIP 001 EXY->EXY_DSCTIP EE8_DSCTIP P S EXY 1 xFilial("EXY")+M->EE8_CODTIP S
EE8_DIFERE 001 Ap100ShowStFix(.T.) EE8_VM_FIX P 0 S
EE8_DTFIX 001 Ap100ShowStFix(.T.) EE8_VM_FIX P 0 S
EE8_EMBAL1 001 IF(EECPPE07("CALCEMB"),M->EE8_DESC,M->EE8_DESC) EE8_DESC P N 0 S
EE8_FABR 001 AVGatilho(M->EE8_FABR ,"SA2","1|3") EE8_FALOJA P N 0 !IsInCallStack("CONPAD1") S
EE8_FORN 001 AVGatilho(M->EE8_FORN ,"SA2","2|3") EE8_FOLOJA P N 0 !IsInCallStack("CONPAD1") S
EE8_PERCOM 001 Round(M->EE8_PRCINC*(M->EE8_PERCOM/100),AVSX3("EE8_VLCOM",4)) EE8_VLCOM P 0 S
EE8_POSIPI 001 SYD->YD_DESTAQU EE8_DTQNCM P S SYD 3 XFILIAL("SYD")+M->EE8_POSIPI S
EE8_PRCFIX 001 If(!Empty(M->EE8_DTFIX),M->EE8_DTFIX,Nil) EE8_PRECO P 0 S
EE8_PRECO 001 If(lCommodity,Ap100ShowStFix(.T.),Nil) EE8_VM_FIX P 0 S
EE8_PRECO 002 Round(M->EE8_PRCINC*(M->EE8_PERCOM/100),AVSX3("EE8_VLCOM",4)) EE8_VLCOM P 0 S
EE8_PRENEG 001 IF(M->EE7_PERC>0,(M->EE8_PRENEG - M->EE8_PRENEG*(M->EE7_PERC/100)),M->EE8_PRENEG) EE8_PRECO P N 0 S
EE8_PRENEG 002 Eval({|| Ap104GatPreco("EE8_PRECO",.T.,"M"),M->EE8_PRECO}) EE8_PRECO P N 0 S
EE8_QTDFIX 001 If(!Empty(M->EE8_DTFIX,M->EE8_QTDFIX,Nil) EE8_SLDINI P 0 S
EE8_SLDINI 001 Round(M->EE8_PRCINC*(M->EE8_PERCOM/100),AVSX3("EE8_VLCOM",4)) EE8_VLCOM P 0 S
EE8_TES 001 SF4->F4_CF EE8_CF P S SF4 1 xFilial()+M->EE8_TES S
EE8_UNIDAD 001 AP102GerTotIt() EE8_PRCINC P 0 !EMPTY(M->EE8_UNPRC) S
EE8_UNIDAD 002 Round(M->EE8_PRCINC*(M->EE8_PERCOM/100),AVSX3("EE8_VLCOM",4)) EE8_VLCOM P 0 !EMPTY(M->EE8_UNPRC) S
EE8_UNPES 001 IF(ALLWAYSTRUE(AP100DETTELA(.F.)),M->EE8_UNPES,NIL) EE8_UNPES P N 0 S
EE8_UNPRC 001 AP102GerTotIt() EE8_PRCINC P 0 .T. S
EE8_UNPRC 002 Round(M->EE8_PRCINC*(M->EE8_PERCOM/100),AVSX3("EE8_VLCOM",4)) EE8_VLCOM P 0 .T. S

 

 

 

 

SX9 - Relacionamento entre Tabelas

X9_DOM X9_IDENT X9_CDOM X9_EXPDOM X9_EXPCDOM X9_PROPRI X9_LIGDOM X9_LIGCDOM X9_CONDSQL X9_USEFIL X9_ENABLE X9_VINFIL X9_CHVFOR
EE8 001 EES EE8_SEQUEN+EE8_COD_I EES_SEQUEN+EES_COD_I S 1 N S S 2 2

 

 

 

 

SXG - Grupo de Campos

XG_GRUPO XG_DESCRI XG_DESSPA XG_DESENG XG_SIZEMAX XG_SIZEMIN XG_SIZE XG_PICTURE
001 Codigo Cliente/Fornecedor Codigo Cliente/Proveedor Customer/Supplier Code 20 6 6 @!
002 Loja Cliente/Fornecedor Tienda Cliente/Proveedor Customer/Supplier Unit 4 2 2 @!
030 Tamanho do Produto Tamano del Producto Product Size 30 15 15 @!
033 Tamanho da Filial Tamano de la Sucursal Branch Size 12 2 2
068 Lote - rastreabilidade Lote - rastreabilidad Lot - Traceability 40 10 10
122 Unidade de Medida Unidad de medida Measure Unit 10 2 2

 

 

 

 

 

 

 

 

 

 

Gostou? Compartilhe com seus amigos e deixe um comentário! ??

Um abraço, e até a próxima  

 

 

 

 

 

📰 Posts Relacionados

ASSINE A NEWSLETTER

Cadastrando...

PIX uDesenv

PIX QR Code para depósito

Clique para doar

Siga-nos

YouTube GitHub LinkedIn

Parceiros

Tudo em ADVPL - Blog parceiro

Blog ADVPL