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

Tabela 2410 EEC

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

Salve salve, blz?

 

 

Tabela EEC. #EEC

 

 

 

 

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
EEC DATA EEC990 Embarque Embarque Shipping E E E 0 EEC_FILIAL+EEC_PREEMB N 29 EEC_PREEMB+EEC_PEDREF+EEC_STTDES+EEC_MOTSIT+EEC_DSCMTS EECAE100 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
EEC 01 EEC_FILIAL C 2 0 Filial Filial do Sistema AE100CRIT('EEC_QTDEMB') 1 N 033
EEC 05 EEC_FIM_PE D 8 0 Dt.Encerram. Dt.Encerramamento @D 1 S .F.
EEC 06 EEC_VM_AMO C 25 0 Amostra Amostra 1 S V IniBrwAmostra("EEC")
EEC 09 EEC_STATUS C 1 0 Status Situacao do proce.exp. DSCSITEE7(,"E") 1 N lALTERA
EEC A2 EEC_DSCGEN C 6 0 Desc.Gen.Pr. Desc.Gen.Pr. @! 1 N lALTERA
EEC A4 EEC_CODOBP C 6 0 Cod.Mem.Ped. Memo Obs para Emissao 1 N lALTERA
EEC A7 EEC_CODMEM C 6 0 Codigo Memo Codigo do Campo Memo 1 N
EEC A8 EEC_PESLIQ N 12 4 Peso Liquid. Peso liquido total @E 9,999,999.9999 1 N V lALTERA
EEC A9 EEC_PESBRU N 12 4 Peso Bruto Peso bruto total @E 9,999,999.9999 1 N V lALTERA
EEC B0 EEC_TOTPED N 16 2 Total Pedido Vlr. Total do pedido @E 9,999,999,999,999.99 1 N V lALTERA
EEC B1 EEC_TOTITE N 16 2 Total Itens Total de itens @E 9,999,999,999,999.99 1 N V lALTERA
EEC 02 EEC_PREEMB C 20 0 Processo Codigo Embarque @! NaoVazio() .And. EXISTCHAV("EEC") 1 S S 1
EEC 03 EEC_PEDREF C 20 0 Processo Ref Processo Referencia @! Existcpo("EE7",M->EEC_PEDREF) .And. Ae108VldSelPed(M->EEC_PEDREF) EE7 1 S N AE100W("EEC_PEDREF") .And. !lProcReplicado 1
EEC 04 EEC_DTPROC D 8 0 Dt.Processo Data Processo @D dDatabase 1 S lALTERA 1
EEC 07 EEC_ENVAMO C 1 0 Env.Amostra? Envia Amostra? Pertence("12") "2" 1 N A R 1=Sim; 2=Nao 1
EEC 08 EEC_AMOSTR C 1 0 Amostra Amostra @! PERTENCE('124').AND.AE100CRIT('EEC_AMOSTR') "2" 1 N 1=Sim – Sem Faturamento;2=Não;4=Sim – Com Faturamento lALTERA 1
EEC 10 EEC_IMPORT C 6 0 Cod. Import. Codigo do Importador @! AE100CRIT("EEC_IMPORT").And.AE100Crit("EEC_MARCAC") AVE001 1 S N AE100W("EEC_IMPORT") 001 1
EEC 11 EEC_IMLOJA C 2 0 Loja Import. Loja do Importador @! AE100CRIT("EEC_IMLOJA") .And. AE100Crit("EEC_MARCAC") 1 S N AE100W("EEC_IMLOJA") 002 1
EEC 12 EEC_IMPODE C 50 0 Importador Nome do Importador @! NAOVAZIO() 1 S A R lALTERA 175 1
EEC 13 EEC_STTDES C 60 0 Status Descricao situacao 1 S V lALTERA 1
EEC 14 EEC_MOTSIT C 15 0 Situacao Motivo situacao Vazio() .Or. AE100CRIT("EEC_MOTSIT") EE4 1 S N lSITUACAO 1
EEC 15 EEC_DSCMTS C 60 0 Dsc.Situacao Descricao motivo situacao @! E_FIELD2(EEC->EEC_MOTSIT+"1-Descricao de Situacao","EE4",1,,"EE4->EE4_TEXTO",60) 1 N V V 1
EEC 16 EEC_ENDIMP C 100 0 End. Import. Endereço Importador @! 1 N lALTERA 1
EEC 17 EEC_END2IM C 100 0 Compl.End Compl.End Importador @! 1 N lALTERA 1
EEC 18 EEC_REFIMP C 40 0 Ref.Import. Referencia Importador @! AE100Crit("EEC_MARCAC") 1 N lALTERA 1
EEC A3 EEC_GENERI M 60 0 Desc.Gen.Pr. Desc.Gen.Pr. E_MSMM(EEC->EEC_DSCGEN,60) 1 N V lALTERA 1
EEC A6 EEC_OBS M 60 0 Observacao Observacao E_MSMM(EEC->EEC_CODMEM,60) 1 N V 1
EEC I0 EEC_DSCCOM C 100 0 Comissao Resumo da Comissao EECResCom() 1 N V V 2
EEC K6 EEC_TITCAM C 9 0 Tit.Cam Num. Tit. Cambio 1 N V R 2
EEC J3 EEC_MRCOIC M 60 0 Marc. Oic Marcação Oic MSMM(M->EEC_OICMCC,AVSX3("EEC_MRCOIC",3)) 1 N A V 3
EEC D4 EEC_DTFCPR D 8 0 Fech.Praca Data Fech.Praca 1 N lALTERA 4
EEC D5 EEC_ETA D 8 0 E.T.A. E.T.A. 1 N lALTERA 4
EEC D6 EEC_TRSTIM N 10 0 Transit Time Transit Time @e 9999999999 POSITIVO().AND.AE100CRIT("EEC_TRSTIM") 1 N lALTERA 4
EEC D7 EEC_ETD D 8 0 E.T.D. E.T.D. AE100CRIT("EEC_ETD") 1 N lALTERA 4
EEC D8 EEC_ETADES D 8 0 E.T.A. Dest. E.T.A. Destino AE100CRIT("EEC_ETADES") 1 N lALTERA 4
EEC D9 EEC_EMBARC C 25 0 Embarcacao Codigo da Embarcacao @! Vazio() .Or. Ae100Crit("EEC_EMBARC") E6_ 1 S N lALTERA 4
EEC E0 EEC_VIAGEM C 20 0 Nr.Voo/Viag. Nr. Voo/Viagem @! Vazio().Or.Ae100Crit('EEC_VIAGEM') EE6001 1 N lALTERA 4
EEC F2 EEC_DTEMBA D 8 0 Dt.Embarque Dt.Embarque AE100CRIT("EEC_DTEMBA") 1 S N AE100W("EEC_DTEMBA") 4
EEC F7 EEC_DTREC D 8 0 Dt. Receb. Data de Recebimento Ae100Crit("EEC_DTREC") if(TYpe('M->EEC_DTREC')=='D',M->EEC_DTREC,CTOD(' / / ')) 1 S N A V AE100W("EEC_DTEMBA") 4
EEC G0 EEC_ARM C 6 0 Cod. Arm. Codigo do Armazem @! Ae108VldConsig("EEC_ARM") AVE001 1 S N A R 001 4
EEC G1 EEC_ARLOJA C 2 0 Loja Arm. Loja do Armazem @! Ae108VldConsig("EEC_ARLOJA") 1 S N A R 002 4
EEC G2 EEC_ARMDES C 50 0 Armazem Nome do Armazem @! 1 N A R 175 4
EEC I3 EEC_PTINT C 3 0 Porto Interm Porto Interm. @! Vazio() .OR. ExistCpo("SY9",M->EEC_PTINT,2) 1 4
EEC I5 EEC_DTESTU D 8 0 Dt.Estufagem Data Estufagem 1 N A R LALTERA 4
EEC I8 EEC_MODEST C 1 0 Mod. Estuf. Modal. Estuf. @! Vazio() .or. Pertence("12") 1 N A R 1=FCL-Responsabilidade do Exportador; 2=LCL-Responsabilidade do Armador LALTERA 4
EEC J1 EEC_TIPEST C 1 0 Tipo Estuf. Tipo Estufagem ! Vazio() .or. Pertence("12") 1 N A R 1=Granel; 2=Sacaria LALTERA 4
EEC K7 EEC_ETAHR C 5 0 Hora ETA Horário ETA 99:99 1 N laltera 4
EEC K8 EEC_ETB D 8 0 ETB ETB 1 N laltera 4
EEC K9 EEC_ETBHR C 5 0 Hora ETB Hora ETB 99:99 1 N lAltera 4
EEC L0 EEC_ETDHR C 5 0 Hora ETD Hora ETD 99:99 1 N lAltera 4
EEC L1 EEC_DLDRAF D 8 0 D.L. Draft Dead Line entrega Draft 1 N lAltera 4
EEC L2 EEC_DLDRHR C 5 0 Hora Draft Hora D.L. entrega Draft 99:99 1 N lAltera 4
EEC L3 EEC_DLCARG D 8 0 D.L. Carga Dead Line entrega Carga 1 N lAltera 4
EEC L4 EEC_DLCAHR C 5 0 Hora Carga Hora D.L. entrega Carga 99:99 1 N lAltera 4
EEC 95 EEC_ENQCOX C 5 0 Enq.DrawBack Cod. Enq. p/ R.E.DrawBack @! VAZIO().OR.EXISTCPO("EED") EED 1 N lALTERA 5
EEC 96 EEC_ENQCOD C 5 0 Cod.Enquadra Codigo enquadramento @! VAZIO().OR.EXISTCPO("EED") "80000" EED 1 N lALTERA 5
EEC 97 EEC_ENQCO1 C 5 0 Cod.Enq.2 Codigo enquadramento 2 @! VAZIO().OR.EXISTCPO("EED").AND.AE100CRIT('EEC_ENQCO1') EED 1 N lALTERA.AND.!Empty(M->EEC_ENQCOD) 5
EEC 98 EEC_ENQCO2 C 5 0 Cod.Enq.3 Codigo enquadramento 3 @! VAZIO().OR.EXISTCPO('EED').AND.AE100CRIT('EEC_ENQCO2') EED 1 N lALTERA.AND.!Empty(M->EEC_ENQCOD) 5
EEC 99 EEC_ENQCO3 C 5 0 Cod.Enq.4 Codigo enquadramento 4 @! VAZIO().OR.EXISTCPO('EED').AND.AE100CRIT('EEC_ENQCO3') EED 1 N lALTERA.AND.!Empty(M->EEC_ENQCOD).AND.Empty(M->EEC_ENQCOX) 5
EEC A0 EEC_ENQCO4 C 5 0 Cod.Enq.5 Codigo enquadramento 5 @! EED 1 N 5
EEC A1 EEC_ENQCO5 C 5 0 Cod.Enq.6 Codigo enquadramento 6 @! EED 1 N 5
EEC B2 EEC_REGVEN C 9 0 Reg.Venda Reg.Venda @! 1 N lALTERA 5
EEC B3 EEC_OPCRED C 9 0 Op.Credito Op.Credito @! 1 N lALTERA 5
EEC B4 EEC_LIMOPE D 8 0 Limite Oper. Limite Operacao 1 N lALTERA 5
EEC B5 EEC_GEDERE C 13 0 GE/DE/RE/Vn. GE/DE/RE/Vinculado @! 1 N lALTERA 5
EEC B6 EEC_GDRPRO C 15 0 Num.Processo Num.Processo GE/DE/RE/Vn. @! 1 N lALTERA 5
EEC B7 EEC_DIRIVN C 15 0 DI/RI/Vinc. DI/RI/Vinculado @! 1 N lALTERA 5
EEC B8 EEC_SECEX C 5 0 Ag. SECEX SECEX @! ExistCPO("SJ9",M->EEC_SECEX) SJ9 1 N lALTERA 5
EEC B9 EEC_MRGNSC N 15 7 % Marg.N.Sac % Margem Nao Sacada @E 9,999,999.9999999 POSITIVO() 1 N lALTERA 5
EEC C0 EEC_VLMNSC N 15 2 VL.M.N.Sac. Valor da Margen Nao Sacad @E 999,999,999,999.99 POSITIVO().AND.AE100CRIT("EEC_VLMNSC") 1 N AE100W("EEC_VLMNSC") 5
EEC C1 EEC_ANTECI N 15 2 VL. Antecip. Valor Antecipado @E 999,999,999,999.99 POSITIVO().AND.AE100CRIT("EEC_ANTECI") 1 N AE100W("EEC_ANTECI") 5
EEC C2 EEC_VISTA N 15 2 VL. a Vista Vl.A Vista @E 999,999,999,999.99 POSITIVO() 1 N lALTERA 5
EEC C3 EEC_NPARC N 3 0 Nr. Parcelas Nr. Parcelas 999 NAOVAZIO().AND.POSITIVO().AND.AE100CRIT("EEC_NPARC") 1 1 N lALTERA 5
EEC C4 EEC_PARCEL N 15 2 VL. Parcela Vl.Parcela @E 999,999,999,999.99 POSITIVO().AND.AE100CRIT("EEC_PARCEL") 1 N AE100W("EEC_PARCEL") 5
EEC C5 EEC_VLCONS N 15 2 VL. Consig. Valor em Consignacao @E 999,999,999,999.99 POSITIVO() 1 N lALTERA 5
EEC C6 EEC_COBCAM C 1 0 Cob.Cambial Cobertura Cambial @! PERTENCE("12") "1" 1 N 1=Sim;2=Nao lALTERA 5
EEC C7 EEC_FINCIA N 15 2 Vl.Financ.RC Vl.Financiamento RC @E 999,999,999,999.99 1 N lALTERA 5
EEC H9 EEC_LIBSIS D 8 0 Dt.Lib.Sis. Dt de Liberacao SISCOMEX AE100CRIT("EEC_LIBSIS") 1 S N lALTERA 5
EEC I6 EEC_TSISC C 1 0 Tp.Siscomex Tipo Siscomex AE100CRIT("EEC_TSISC") 1 N A R lAltera 5
EEC K1 EEC_PTCROM C 1 0 CCPTC/CCROM ME. Amparada CCPTC/CCROM @! Pertence("12") "2" 1 A R 1=Sim; 2=Nao lAltera 5
EEC L9 EEC_INFGER C 6 0 Inf. Gerais Informações Gerais 1 N V R 5
EEC M0 EEC_VMINGE M 200 0 Inf. Gerais Informações Gerais 1 N V V 5
EEC M4 EEC_VLRIE N 15 2 Vlr Rec IE Valor a Recolher I.E. @E 999,999,999,999.99 POSITIVO() 1 N V R 5
EEC M5 EEC_VVLIE C 20 0 Vlr Rec IE Valor a Recolher I.E. 1 N V V 5
EEC M6 EEC_EMFRRC C 3 0 Tipo Despach Tipo do Despacho Export. 1 S A R 19=Fora de Recinto Alfandegado-Domiciliar;22=Fora de Recinto Alfandegado-Não Domiciliar;281=Despacho em recinto alfandegado 5
EEC M7 EEC_RECALF C 7 0 Recinto Alf. Recinto Alfandegado vazio() .or. ExistCpo("SJA") SJA 1 S A R 5
EEC 94 EEC_INSCOD C 6 0 Instr.Neg. Instrumento Negociacao @! VAZIO() .OR. EXISTCPO("EEE") .And. AE100Crit("EEC_INSCOD") EEE 1 N lALTERA 5
EEC 62 EEC_PAISET C 3 0 Pais Entrega Pais Entrega @! Existcpo("SYA") .And. AE100CRIT("EEC_PAISET",.T.) SYA 1 N lALTERA 5
EEC 61 EEC_PAISDT C 3 0 Pais Destino Pais Destino @! Existcpo("SYA") SYA 1 N V lALTERA 5
EEC 60 EEC_URFENT C 7 0 URF Entrega U.R.F. Entrega @R 9999999 ExistCPO("SJ0",M->EEC_URFENT) URF 1 N lALTERA 5
EEC 59 EEC_URFDSP C 7 0 URF Despacho U.R.F. DESPACHO @R 9999999 ExistCPO("SJ0",M->EEC_URFDSP) URF 1 N lALTERA 5
EEC 58 EEC_TIPTRA C 1 0 Tipo Transp. Tipo de transporte 9 PERTENCE("123").AND.AE100CRIT("EEC_TIPTRA") 1 N 1=Cheio;2=Picados;3=Carga Solta AE100W("EEC_TIPTRA") 4
EEC 57 EEC_DSCDES C 25 0 Desc.Destino Descricao Destino @! E_FIELD("EEC_DEST","Y9_DESCR",,,2) 1 N V V lALTERA 4
EEC 56 EEC_DEST C 3 0 Destino Destino @! AE100CRIT("EEC_MARCAC") .AND.AE100CRIT("EEC_DEST") EV8 1 N AE100W("EEC_DEST") 4
EEC 55 EEC_DSCORI C 25 0 Desc.Origem Descricao Origem @! E_FIELD("EEC_ORIGEM","Y9_DESCR",,,2) 1 N V V lALTERA 4
EEC 54 EEC_ORIGEM C 3 0 Origem Origem @! AE100CRIT("EEC_ORIGEM") EV8 1 N AE100W("EEC_ORIGEM") 4
EEC 53 EEC_VIA_DE C 50 0 Descr.da Via Descricao Via Transporte @! E_FIELD("EEC_VIA","YQ_DESCR") 1 N V V lALTERA 4
EEC 52 EEC_VIA C 2 0 Via Transp. Via Transp. AE100CRIT("EEC_VIA") SYQ 1 N lALTERA 4
EEC L7 EEC_QTDEMB N 7 2 Qtd.Embalag Quantidade Embalagem @E 9,999.99 1 N 3
EEC 84 EEC_GROSSW C 15 0 Gross Wgt Gross Weight @! 1 N lALTERA 3
EEC 83 EEC_NETWGT C 15 0 Net Wgt Net Weight @! 1 N lALTERA 3
EEC 82 EEC_UNIT C 20 0 Unit Unit @! 1 N lALTERA 3
EEC 81 EEC_QUANTI C 20 0 Quantity Quantity @! 1 N lALTERA 3
EEC 80 EEC_ONTHEP C 20 0 On the Pack. On the Packages @! 1 N lALTERA 3
EEC 79 EEC_CONFEC C 60 0 Confeccionar Confeccionar @! 1 N lALTERA 3
EEC 78 EEC_PACKAG C 60 0 Package Descricao Package @! 1 N lALTERA 3
EEC 77 EEC_CUBAGE N 15 4 Cubagem Cubagem @E 9,999,999,999.9999 AP100CUBAGEM(.F.,"Q") 1 N lALTERA 3
EEC 76 EEC_CALCEM C 1 0 Calc.Embalag Tipo de calculo da embala @! NaoVazio() .And. Pertence("12") IF(inclui,"1",M->EEC_CALCEM) 1 N 1=Volume;2=Quantidade lALTERA 3
EEC 75 EEC_EMBAFI C 20 0 Volume Embalagem final @! (Vazio().Or.EXISTCPO("EE5")) .AND. AE100CRIT("EEC_EMBAFI") EE5 1 S N lALTERA 3
EEC 64 EEC_CODMAR C 6 0 Cod.Mem.Marc Codigo Campo Memo Marcac. 1 N lALTERA 3
EEC 63 EEC_MARCAC M 60 0 Marcacao Marcacao E_MSMM(EEC->EEC_CODMAR,20) 1 N A V lALTERA 3
EEC P3 EEC_STADTO C 200 0 Status ADTO Status dos Adiantamentos IIF(!INCLUI,AE102ADTVLD(.T.),"") 1 N V V 2
EEC P2 EEC_DTADTE D 8 0 Lib.Pend.Ad Liberação Financeira 1 S A R 2
EEC M2 EEC_DESSEG C 1 0 Desc. Seg. Desconto no Seguro @! AE100CRIT("EEC_DESSEG") "2" 1 S A R 1=Sim;2=Nao M->EEC_PRECOA == "1" 2
EEC L5 EEC_TPDESC C 1 0 Tp. Desconto Tipo de Desconto @! AE100CRIT('EEC_TPDESC') '1' 1 S A R 1=Subtrai; 2=Soma lAltera '1' 2
EEC 93 EEC_REFAGE C 20 0 Ref.Agente Referencia do Agente @! 1 N lALTERA 2
EEC 92 EEC_VALCOM N 14 2 Comissao Valor da Comissao @E 99,999,999,999.99 Positivo() .and. AE100Crit("EEC_VALCOM") 1 N AE100W("EEC_VALCOM") 2
EEC 91 EEC_TIPCVL C 1 0 Tipo Vl.Com. Tipo de Valor comissao ! Pertence("123 ") "1" 1 N 1=Percentual;2=Valor Fixo;3=Percentual por Item lALTERA 2
EEC 90 EEC_TIPCOM C 1 0 Tipo Comis. Tipo comissao ! Pertence("123 ") "2" 1 N 1=A Remeter;2=Conta Grafica;3=Deduzir da Fatura LALTERA 2
EEC 89 EEC_PGTANT C 1 0 Pagto Antec. Pagamento antecipado @! PERTENCE("12") "2" 1 N 1=Sim;2=Nao lALTERA 2
EEC 88 EEC_SL_EME D 8 0 Dt.Sl.Emenda Data solicitacao emenda 1 N lALTERA 2
EEC 87 EEC_SL_LC D 8 0 Dt.Sol.L/C Data solicitacao L/C 1 N lALTERA 2
EEC 86 EEC_LC_NUM C 20 0 No. L/C No. L/C @! (VAZIO() .OR. EXISTCPO("EEL",M->EEC_LC_NUM)) .And. AE100CRIT("EEC_LC_NUM") EEL 1 N lALTERA 2
EEC 74 EEC_PRECOA C 1 0 Preco Ab. Preco aberto (FOB+FRETE) @! PERTENCE("12") .And. AE100PrecoI(.T.) .And. AE100CRIT("EEC_PRECOA") "1" 1 N 1=Sim;2=Nao lALTERA 2
EEC 73 EEC_DESCON N 15 2 Desconto Desconto @E 999,999,999,999.99 Positivo().AND.AE100PRECOI() 1 N LALTERA .AND. !lDESCIT 2
EEC 72 EEC_DESPIN N 15 2 Desp.Interna Despesas Internas @E 999,999,999,999.99 (Vazio() .or. Positivo()) .and. AE100PrecoI(.T.) 1 N V 2
EEC 71 EEC_SEGPRE N 15 2 Seguro Intl. Seguro Intl. @E 999,999,999,999.99 Positivo() .AND. AE100CRIT("EEC_SEGPRE") 1 N V 2
EEC 70 EEC_SEGURO N 15 7 Seguro % Seguro % @E 9,999,999.9999999 AE100CRIT("EEC_SEGURO") 1 N lALTERA 2
EEC 69 EEC_FRPCOM N 15 2 Frete Adic. Frete Adic. @E 999,999,999,999.99 Positivo() .AND. AE100PrecoI(.T.) 1 N V 2
EEC 68 EEC_FREEMB N 15 2 Fre. Embut Frete Embutido @E 999,999,999,999.99 Vazio() .Or. Positivo() 1 N A R lAltera 2
EEC 67 EEC_FRPREV N 15 2 Frete Intl. Frete Intl. @E 999,999,999,999.99 AE100Crit("EEC_FRPREV") .and. AE100PrecoI(.T.) 1 N V 2
EEC 66 EEC_FRPPCC C 2 0 Tipo Frete Tipo Frete @! "CC" 1 N CC=Collect;PP=Prepaid lALTERA 2
EEC 65 EEC_MOEDA C 3 0 Moeda Neg. Moeda negociada @! DIVldMoeda() .and. NaoVazio() .AND. EXISTCPO("SYF") GETMV("MV_EECUSS") SYF 1 N lALTERA 2
EEC 51 EEC_INCOTE C 3 0 Incoterm Incoterm @! ExistCpo("SYJ",M->EEC_INCOTE) .and. DIVldIcoterm() "2" SYJ 1 S N lALTERA 2
EEC 50 EEC_DSCMPE C 52 0 Descricao Descricao Modal.Pgto. @! E_FIELD("EEC_MPGEXP","EEF_DESC") 1 N V V lALTERA 2
EEC 49 EEC_MPGEXP C 3 0 Mod.Pgto.Exp Modalidade Pagto @! EXISTCPO("EEF",M->EEC_MPGEXP) .And. AE100CRIT("EEC_MPGEXP") "003" EEF 1 S N lALTERA 2
EEC 48 EEC_DESCPA C 60 0 Descricao Descricao em Portugues E_FIELD2(M->EEC_CONDPA+STR(M->EEC_DIASPA,3),"SY6",1,,"SY6->Y6_DESC_P",60) 1 N V V lALTERA 2
EEC 47 EEC_DIASPA N 3 0 Dias Pagto Dias Pagto 999 ExistCpo("SY6",M->EEC_CONDPA+Str(M->EEC_DIASPA,AVSX3("EEC_DIASPA",3)),1) .AND. AE100CRIT("EEC_DIASPA") 1 S N lALTERA 2
EEC 44 EEC_CONDPA C 5 0 Cond. Pagto Cond. Pagto @! ExistCpo("SY6",M->EEC_CONDPA,1).AND.AE100CRIT("EEC_CONDPA") SY6 1 S N lALTERA 2
EEC 43 EEC_END2BE C 100 0 Comp.End. Endereco Beneficiario @! 1 N lALTERA 2
EEC 42 EEC_ENDBEN C 100 0 End.Benef. Endereco Beneficiario @! 1 N lALTERA 2
EEC 41 EEC_BENEDE C 60 0 Beneficiario Nome do Beneficiario @! 1 S lALTERA 2
EEC 40 EEC_BELOJA C 2 0 Loja Benef. Loja do Beneficiario @! AE100CRIT("EEC_BELOJA") 1 S N lALTERA 002 2
EEC 39 EEC_BENEF C 6 0 Cod.Benef. Beneficiario @! VAZIO().OR.AE100CRIT("EEC_BENEF") AVE007 1 S N AE100W("EEC_BENEF") 001 2
EEC K5 EEC_CODERP C 10 0 Cod. ERP Codigo ERP @! 1 1
EEC J7 EEC_EMAIL C 40 0 E-Mail E-Mail EECIniPad('EEC_EMAIL') 1 N V V 1
EEC J6 EEC_USUDIG C 40 0 Usuario Usuario EECIniPad('EEC_USUDIG') 1 N V V 1
EEC J5 EEC_CODUSU C 15 0 Cod.Usuario Codigo do usuario If(nSelecao = 3, __cUserid,) 1 N V R 1
EEC H0 EEC_PEDFAT C 6 0 Ped.de Venda Numero do Pedido SigaFat @X 1 N V R 1
EEC 85 EEC_IDIOMA C 25 0 Idioma Doc. Idioma documentos @! NaoVazio().AND.EECDSIDIOMA("M->EEC_IDIOMA") ID 1 S N lALTERA 1
EEC 46 EEC_CLOJAF C 2 0 Lj. Cliente Loja do Cliente Final @! Vazio() .OR. ExistCpo("SA1",M->EEC_CLIENF+M->EEC_CLOJAF) 1 N A R lAltera 002 1
EEC 45 EEC_CLIENF C 6 0 Cli.Mult.Off Cli. final Multi-OffShore @! Vazio() .OR. AE100CRIT("EEC_CLIENF") ER3 1 N A R lAltera 001 1
EEC 38 EEC_RESPON C 35 0 Anal. Resp. Analista Responsavel @! AVE009 1 N AE100W("EEC_RESPON") 1
EEC 37 EEC_CONSDE C 50 0 Consignee Nome do consignatario @! if(!empty(M->EEC_CONSIG), NaoVazio(),.T.) POSICIONE("SA1",1,XFILIAL("SA1")+M->EEC_CONSIG+M->EEC_COLOJA,"A1_NOME") 1 S A R lALTERA POSICIONE("SA1",1,XFILIAL("SA1")+EEC->EEC_CONSIG+EEC->EEC_COLOJA,"A1_NOME") 175 1
EEC 36 EEC_COLOJA C 2 0 Loja Consig. Loja do Consignatario @! AE100CRIT("EEC_COLOJA") 1 S N lALTERA 002 1
EEC 35 EEC_CONSIG C 6 0 Cod.Consign. Codigo do consignatario @! AE100CRIT("EEC_CONSIG") AVE003 1 S N AE100W("EEC_CONSIG") 001 1
EEC 28 EEC_FORNDE C 50 0 Fornecedor Nome do Fornecedor @! POSICIONE("SA2",1,XFILIAL("SA2")+M->EEC_FORN+M->EEC_FOLOJA,"A2_NOME") 1 S V V lALTERA E_Field("EEC_FORN","A2_NOME","B",.T.) 177 1
EEC 27 EEC_FOLOJA C 2 0 Loja Fornec. Loja do Fornecedor @! AE100CRIT("EEC_FOLOJA") .And. AE100Crit("EEC_MARCAC") 1 S N AE100W("EEC_FOLOJA") 002 1
EEC 26 EEC_FORN C 6 0 Cod.Fornec. Fornecedor @! AE100CRIT("EEC_FORN").And.AE100Crit("EEC_MARCAC") AVE005 1 S N AE100W("EEC_FORN") 001 1
EEC P4 EEC_STPTUN C 60 0 Portal Único Status Portal Único 1 S V R
EEC L8 EEC_TOTLIQ N 15 2 Total Liquid Total Liquid @E 999,999,999,999.99 1 N V
EEC L6 EEC_TOTFOB N 15 2 Total FOB Total FOB @E 999,999,999,999.99 1 N V
EEC K4 EEC_ID_LB C 10 0 ID WF LB ID WF LB @! 1 S A R
EEC K3 EEC_ID_EMB C 10 0 ID WF EMB ID WF EMB @! 1 S A R
EEC K2 EEC_ID_LC C 10 0 ID WF LC ID WF LC @! 1 S A R
EEC J9 EEC_NIOFFS C 2 0 Niv.OffShore Nivel Off-Shore 1 N A R
EEC J8 EEC_VLFOB N 16 2 Total FOB Vl. Total FOB do Embarque @E 9,999,999,999,999.99 1 N A R
EEC J4 EEC_SPOT C 1 0 Venda Spot? Venda Spot? NaoVazio() .or. Pertence("12") 1 N A R 1=Sim; 2=Nao
EEC J2 EEC_OICMCC C 6 0 Cod.Mrc. OIC Código da Marcação OIC 1 N A R
EEC I7 EEC_DTEFE D 8 0 Dt. Efetiv. Data de efetivação Ae109Valid() M->EEC_DTEMBA 1 N A R
EEC I4 EEC_PEDEMB C 6 0 Ped.NF.Emb. Ped.NF.Embarque @X 1 N V
EEC I2 EEC_PEDDES C 6 0 Ped.NF.Desp. Ped.NF.Despesas @X 1 N V
EEC I1 EEC_STASIS C 1 0 Status Sis. Status SISCOMEX @! 1 N lALTERA
EEC H8 EEC_FATURA D 8 0 Dt.Faturam. Data de Faturamento 1 N
EEC H4 EEC_BCDCRF C 20 0 Ref.Bco.Doc. Banco Documentos Refer. @! 1 N lALTERA
EEC H2 EEC_DTDCIM D 8 0 Dt.Dct.Imp. Dt.Doctos p/Importador 1 N lALTERA
EEC H1 EEC_IN86 C 1 0 Flag IN86 Flag IN86 ! 1 V
EEC F6 EEC_TIPO C 1 0 Tipo Emb. Tipo do Embarque @! 1 N A R
EEC E6 EEC_DECAM C 1 0 DECAM DECAM @! PERTENCE("12") "2" 1 N 1=Sim;2=Nao LSLCAMB
EEC D3 EEC_DSCAGT C 40 0 Razao Social Razao Social Transportad @! E_Field("EEC_CODAGT","Y5_NOME") 1 N V V
EEC D2 EEC_CODAGT C 6 0 Tran.Interno Transportadora Interna @! Vazio().And.ExistCpo("SY5") Y5D 1 S N lALTERA 001
EEC M8 EEC_RECEMB C 7 0 Rec.Alf.Emb. Recinto Alfandegado Emb. vazio() .or. ExistCpo("SJA") SJA 1 S A R 5
EEC M9 EEC_STTDUE C 1 0 Status DU-E Status de integração DU-E DU400Relacao("EEC_STTDUE") 1 S V R #DU400StDue() 5
EEC N0 EEC_FOREXP C 4 0 Forma Export Forma Exportação @! Vazio() .Or. ExistCPO("EVN",M->EEC_FOREXP+"CUS",1) EVN01 1 S A 5
EEC N1 EEC_DESFOR C 30 0 Desc F. Expo Descrição Forma Exportaçã @! If(INCLUI,'',Posicione('EVN',1,xFilial('EVN')+EEC->EEC_FOREXP+'CUS','EVN_DESCRI')) 1 V V 5
EEC N2 EEC_OBSFOR M 80 0 Obs.Forma Obs.Forma @! 1 A R 5
EEC N3 EEC_SITESP C 4 0 Situação Esp Situação Especial @! Vazio() .Or. ExistCPO("EVN",M->EEC_SITESP+"AHZ",1) EVN02 1 S A R 5
EEC N4 EEC_DESSIT C 30 0 Desc Sit esp Descrição Situacao Especi @! If(INCLUI,'',Posicione('EVN',1,xFilial('EVN')+EEC->EEC_SITESP+'AHZ','EVN_DESCRI')) 1 V V 5
EEC N5 EEC_OBSSIT M 80 0 Obs.Sit.Esp Obs.Sit.Esp @! 1 A R 5
EEC N6 EEC_ESPTRA C 4 0 Caso Especia Caso Especial Transporte @! Vazio() .Or. ExistCPO("EVN",M->EEC_ESPTRA+"TRA",1) EVN03 1 S A R 5
EEC N7 EEC_DESTRA C 30 0 Desc Caso Tr Desc. Caso Esp. Transport @! If(INCLUI,'',Posicione('EVN',1,xFilial('EVN')+EEC->EEC_ESPTRA+'TRA','EVN_DESCRI')) 1 V V 5
EEC N8 EEC_OBSTRA M 80 0 Obs.CasoTr. Obs.CasoTr. @! 1 A R 5
EEC N9 EEC_MOTDIS C 4 0 Motivo Dispe Motivo Dispensa NF @! Vazio() .Or. ExistCPO("EVN",M->EEC_MOTDIS+"ACG",1) EVN04 1 S A R 5
EEC O0 EEC_DESDIS C 30 0 Desc Disp NF Desc. Motivo Dispensa NF @! If(INCLUI,'',Posicione('EVN',1,xFilial('EVN')+EEC->EEC_MOTDIS+'ACG','EVN_DESCRI')) 1 N V V 5
EEC O1 EEC_OBSDIS M 80 0 Obs.Mot.NF Obs.Mot.NF @! 1 A R 5
EEC O2 EEC_NRODUE C 14 0 Nro. da DUE Nro. da DUE @! 1 A R 5
EEC O3 EEC_NRORUC C 35 0 Nro. RUC Número RUC @! 1 A R AE100W("EEC_NRORUC") 5
EEC O4 EEC_DTDUE D 8 0 Dt. DUE Data Transmissão DUE 1 N A R AE100W("EEC_DTDUE") 5
EEC O5 EEC_CHVDUE C 30 0 Chave DUE Chave de Acesso DUE 1 A R 5
EEC O6 EEC_RESPDE C 14 0 CNPJ Res Des CNPJ Responsável Despacho @R 99.999.999/9999-99 CGC(M->EEC_RESPDE) 1 M->EEC_EMFRRC <> "281" 5
EEC O7 EEC_LATDES N 11 7 Lat. Desp. Latitude do Local de Desp @E 999.9999999 1 M->EEC_EMFRRC <> "281" 5
EEC O8 EEC_LONDES N 11 7 Long. Desp. Longitude do Local de Des @E 999.9999999 1 M->EEC_EMFRRC <> "281" 5
EEC O9 EEC_ENDDES C 240 0 End. Desp Endereço do Local de Desp 1 M->EEC_EMFRRC <> "281" 5
EEC P0 EEC_DUEAVR D 8 0 Dt Averb DUE Data da Averbação DUE AE100CRIT("EEC_DUEAVR") 1 A 5
EEC P1 EEC_JUSRET M 80 0 Just.Retific Justificativa Retificação 1 A R !Empty(M->EEC_NRODUE) 5
EEC P5 EEC_DUEMAN C 14 0 DUE Manual DUE Manual @! 1 S N A R AE100W("EEC_DUEMAN") 5
EEC P6 EEC_ALRDUE C 1 0 Alerta DUE Ciente Alertas Sistema? @! Pertence('12') '2' 1 N A R 1=Sim;2=Não AE100W("EEC_ALRDUE") 5
EEC A5 EEC_OBSPED M 60 0 Obs.Doctos Obs.Doctos E_MSMM(EEC->EEC_CODOBP,60) 1 N V lALTERA 6
EEC E7 EEC_NRCTOR C 20 0 Cert. Origem Nr.Certificado Origem @! 1 N lALTERA 6
EEC E8 EEC_NRCTFA C 20 0 Form A Nr.Certificado FORM A @! 1 N lALTERA 6
EEC E9 EEC_NRCONH C 20 0 Nr.Conhecim. Nr.Conhecimento @! 1 N lALTERA 6
EEC F0 EEC_MAWB C 20 0 Master Master AWB @! 1 N lALTERA 6
EEC F1 EEC_DTCONH D 8 0 Dt.Conhec. Data Conhecimento AE100CRIT("EEC_DTCONH") 1 N lALTERA 6
EEC F3 EEC_TOTVOL N 10 0 Qtde Volume Quantidade de Volumes @E 9,999,999,999 1 N 6
EEC F4 EEC_DTSLPL D 8 0 Sol.Paletiz. Solecitacao de Paletiza 1 N lALTERA 6
EEC F5 EEC_DTSLIN D 8 0 Sol.Inspecao Solicitacao de Inspecao 1 N lALTERA 6
EEC F8 EEC_DTPALE D 8 0 Dt.Paletiz. Dt.Paletiz. 1 N lALTERA 6
EEC F9 EEC_DTINSP D 8 0 Dt.Inspecao Dt.Inspecao 1 N lALTERA 6
EEC G3 EEC_NRINSP C 20 0 Nr.Inspecao Nr.Inspecao @! 1 N lALTERA 6
EEC G4 EEC_NRCTSG C 20 0 Cert. Seguro Nr.Certificado Seguro @! AE100CRIT("EEC_NRCTSG") 1 N lALTERA 6
EEC G5 EEC_NRAVSG C 20 0 Nr.Av.Seguro Nr.Averbacao Seguro @! AE100CRIT("EEC_NRAVSG") 1 N AE100W("EEC_NRAVSG") 6
EEC G6 EEC_DTSEGU D 8 0 Data Seguro Data Seguro 1 N lALTERA 6
EEC G7 EEC_APLCSG C 15 0 Apolice Seg. Apolice Seg. @! 1 N lALTERA 6
EEC G8 EEC_TRSDOC N 10 0 T.Time Doc. Transit Time Documentos @e 9999999999 POSITIVO().AND.AE100CRIT("EEC_TRSDOC") 1 N lALTERA 6
EEC G9 EEC_DTLMDC D 8 0 Dt.Lim.Doc. Dt.Limite Envio Document. AE100CRIT("EEC_DTLMDC") 1 N lALTERA 6
EEC H3 EEC_DTENDC D 8 0 Dt.Envio Doc Dt.Envio documentos 1 N lALTERA 6
EEC H5 EEC_BCEXRF C 20 0 Ref.Bco.Ext. Banco Exterior Refer. @! 1 N lALTERA 6
EEC H6 EEC_COURIE C 30 0 Courier Imp. Courier Imp. @! 1 N lALTERA 6
EEC H7 EEC_COURI2 C 30 0 Courier Bco. Courier Bco. @! 1 N lALTERA 6
EEC M1 EEC_INFCOF C 6 0 Inf.Adc.COF Inf.Adc.Cert.FIERGS 1 N V R 6
EEC M3 EEC_VMDCOF M 200 0 Inf.Adc.COF Inf.Adc.Cert.FIERGS 1 N A V lALTERA 6
EEC 19 EEC_EXLIMP C 1 0 Exige L.I. Exige licenca importacao @! PERTENCE("12") "2" 1 N 1=Sim;2=Nao lALTERA 7
EEC 20 EEC_LICIMP C 60 0 Licenc.Imp. Nr. Licenca Importacao @! 1 N lALTERA 7
EEC 21 EEC_INTERM C 1 0 OffShore OffShore @! Pertence("12") .And. Ae100Crit("EEC_INTERM") "2" 1 N 1=Sim;2=Nao lALTERA 7
EEC 22 EEC_DTLIMP D 8 0 Prazo L.I. Validade Licenca Imp. 1 N lALTERA 7
EEC 23 EEC_CLIENT C 6 0 Cod.Cliente Codigo do cliente final @! Vazio().OR.AE100CRIT("EEC_CLIENT") AVE002 1 S N AE100W("EEC_CLIENT") 001 7
EEC 24 EEC_CLLOJA C 2 0 Loja Cliente Loja do Cliente @! AE100CRIT("EEC_CLLOJA") 1 S N lALTERA 002 7
EEC 25 EEC_CLIEDE C 50 0 Client.Final Nome do cliente final @! POSICIONE("SA1",1,XFILIAL("SA1")+M->EEC_CLIENT+M->EEC_CLLOJA,"A1_NOME") 1 S V V lALTERA E_Field("EEC_CLIENT","A1_NOME","B",.T.) 175 7
EEC 29 EEC_INCO2 C 3 0 Incoterm Incoterm @! ExistCpo("SYJ",M->EEC_INCO2) SYJ 1 N M->EEC_INTERM="1" 7
EEC 30 EEC_EXPORT C 6 0 Cod.Export. Exportador @! AE100CRIT("EEC_EXPORT") .AND. AE100Crit("EEC_MARCAC") AVE006 1 S N AE100W("EEC_EXPORT") 001 7
EEC 31 EEC_EXLOJA C 2 0 Loja Export. Loja do Exportador @! AE100CRIT("EEC_EXLOJA") .And. AE100Crit("EEC_MARCAC") 1 S N lALTERA 002 7
EEC 32 EEC_EXPODE C 50 0 Exportador Nome do Exportador @! POSICIONE("SA2",1,XFILIAL("SA2")+M->EEC_EXPORT+M->EEC_EXLOJA,"A2_NOME") 1 S V V lALTERA E_Field("EEC_EXPORT","A2_NOME","B",.T.) 177 7
EEC 33 EEC_COND2 C 5 0 Cond.Pagto. Condicao de pagamento @! ExistCpo("SY6",M->EEC_COND2,1) SY6 1 S N M->EEC_INTERM="1" 7
EEC 34 EEC_DIAS2 N 3 0 Dias Pagto. Dias Pagamento 999 ExistCpo("SY6",M->EEC_COND2+STR(M->EEC_DIAS2,AVSX3("EEC_DIAS2",3)),1) 1 N M->EEC_INTERM="1" 7
EEC I9 EEC_PERC N 5 2 %OffShore % OffShore @E 99.99 Positivo() 1 N M->EEC_INTERM="1" 7
EEC C8 EEC_DECPES N 2 0 Dec.Peso Dec.Peso 99 2 1 N lALTERA 8
EEC C9 EEC_DECQTD N 2 0 Dec.Qtde Dec.Qtde 99 2 1 N lALTERA 8
EEC D0 EEC_DECPRC N 2 0 Dec.Preco Dec.Preco 99 2 1 N lALTERA 8
EEC D1 EEC_BRUEMB C 1 0 Ps.Br.XEmb. Usar peso embalagem @! PERTENCE("12") "1" 1 N 1=Sim;2=Nao lALTERA 8
EEC J0 EEC_UNIDAD C 2 0 Unid.Medida Unidade de Medida ExistCpo("SAH") SAH 1 S N lALTERA 122 8
EEC E1 EEC_NRINVO C 20 0 Nr.Invoice Nr.Invoice @! AE100Crit("EEC_NRINVO") M->EEC_PREEMB 1 N lALTERA 9
EEC E2 EEC_DTINVO D 8 0 Dt.Invoice Dt.Invoice dDATABASE 1 N lALTERA 9
EEC E3 EEC_DTSLNF D 8 0 Sol.N.F. Solecitacao de N.F. 1 N lALTERA 9
EEC E4 EEC_DTSDFB D 8 0 Saida Fabric Saida Fabrica 1 N lALTERA 9
EEC E5 EEC_VLNFC N 10 0 Seq.Ord. Sequencial para Ordenacao @E 9,999,999,999 POSITIVO() 1 N lALTERA 9
EEC K0 EEC_EXL C 1 0 Folder Dados Complementares @! 1 N A R A

 

 

 

 

SIX - INDICES

INDICE ORDEM CHAVE DESCRICAO DESCSPA DESCENG PROPRI F3 NICKNAME SHOWPESQ IX_VIRTUAL IX_VIRCUST
EEC 1 EEC_FILIAL+EEC_PREEMB Processo Proceso Process S S 2 3
EEC 2 EEC_FILIAL+DTOS(EEC_DTPROC) Dt.Processo Fch.Proceso Process Date S S 2 3
EEC 3 EEC_FILIAL+EEC_LC_NUM No. L/C Num. L/C License Nr. S S 2 3
EEC 4 EEC_FILIAL+DTOS(EEC_FATURA) Dt.Faturam. Fch.Facturac Invoic. Date S S 2 3
EEC 5 EEC_FILIAL+EEC_STASIS+DTOS(EEC_LIBSIS) Status Sis. + Dt.Lib.Sis. Estat. Sis. + Fch.Aprob.Si SISCOMEX St. + Siscomex Dt. S S 2 3
EEC 6 EEC_FILIAL+EEC_IMPORT+EEC_IMLOJA Cod. Import. + Loja Import. Cod. Import. + Tienda Impor Import. Code + Imp. Store S S 2 3
EEC 7 EEC_FILIAL+EEC_CLIENT+EEC_CLLOJA Cod.Cliente + Loja Cliente Cod.Cliente + Tienda Clte Cust. Code + Client Store S S 2 3
EEC 8 EEC_FILIAL+EEC_FORN+EEC_FOLOJA Cod.Fornec. + Loja Fornec. Cod.Proveed. + Tienda Prov Sup. Code + Sup. Store S S 2 3
EEC 9 EEC_FILIAL+EEC_EXPORT+EEC_EXLOJA Cod.Export. + Loja Export. Cod.Export. + Tienda Expo Export. Code + Exp. Store S S 2 3
EEC A EEC_FILIAL+EEC_CONSIG+EEC_COLOJA Cod.Consign. + Loja Consig. Cod.Consign. + Tienda Consi Consign.Code + Cons. Store S S 2 3
EEC B EEC_FILIAL+EEC_BENEF+EEC_BELOJA Cod.Benef. + Loja Benef. Cod.Benef. + Tienda Benef Benef. Code + Ben. Store S S 2 3
EEC C EEC_FILIAL+DTOS(EEC_DTEMBA) Dt.Embarque Fch.Embarque Ship. Date S S 2 3
EEC D EEC_FILIAL+STR(EEC_VLNFC,10,0) Seq.Ord. Sec. Ord. Ord.Seq. S S 2 3
EEC E EEC_FILIAL+EEC_PEDREF Processo Ref Proceso Ref Ref. Process S S 2 3
EEC F EEC_FILIAL+EEC_NRINVO Nr.Invoice Num. Invoice Invoice Nr. S S 2 3
EEC G EEC_FILIAL+EEC_EMBARC+EEC_VIAGEM+EEC_ORIGEM Embarcacao + Nr.Voo/Viag. + Origem Embarcacion + Nro.Vuel/Via + Origen Vessel + Flig.No./Tr. + Source 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
EEC_ARLOJA 001 SA1->A1_NOME EEC_ARMDES P S SA1 1 xFilial("SA1")+M->(EEC_ARM+EEC_ARLOJA) !Empty(M->EEC_ARM) S
EEC_ARM 001 SA1->A1_LOJA EEC_ARLOJA P S SA1 1 xFilial("SA1")+M->(EEC_ARM+EEC_ARLOJA) !Empty(M->EEC_ARLOJA) S
EEC_ARM 002 SA1->A1_NOME EEC_ARMDES P S SA1 1 xFilial("SA1")+M->(EEC_ARM+EEC_ARLOJA) !Empty(M->EEC_ARLOJA) S
EEC_BELOJA 001 IF(!EMPTY(M->EEC_BELOJA),SA2->A2_NOME,"") EEC_BENEDE P S SA2 1 XFILIAL("SA2")+M->EEC_BENEF+M->EEC_BELOJA S
EEC_BELOJA 002 IF(!EMPTY(M->EEC_BENEF),EECMEND("SA2",1,M->EEC_BENEF+M->EEC_BELOJA,.T.,AvSx3("EEC_ENDBEN",3),1),"") EEC_ENDBEN P N 0 S
EEC_BELOJA 003 IF(!EMPTY(M->EEC_BENEF),EECMEND("SA2",1,M->EEC_BENEF+M->EEC_BELOJA,.T.,AvSx3("EEC_END2BE",3),2),"") EEC_END2BE P N 0 S
EEC_BELOJA 004 IF(!EMPTY(M->EEC_BENEF).AND.AE100CRIT("EEC_BENEF",.F.),M->EEC_BENEF,M->EEC_BENEF) EEC_BENEF P N 0 S
EEC_BENEF 001 AVGatilho(M->EEC_BENEF,'SA2','3|5') EEC_BELOJA P N 0 !IsInCallStack("CONPAD1") S
EEC_BENEF 002 IF(!EMPTY(M->EEC_BENEF),SA2->A2_NOME,"") EEC_BENEDE P N 0 S
EEC_BENEF 003 IF(!EMPTY(M->EEC_BENEF),EECMEND("SA2",1,M->EEC_BENEF+M->EEC_BELOJA,.T.,AvSx3("EEC_ENDBEN",3),1),"") EEC_ENDBEN P N 0 S
EEC_BENEF 004 IF(!EMPTY(M->EEC_BENEF),EECMEND("SA2",1,M->EEC_BENEF+M->EEC_BELOJA,.T.,AvSx3("EEC_END2BE",3),2),"") EEC_END2BE P N 0 S
EEC_BENEF 005 IF(!EMPTY(M->EEC_BENEF).AND.AE100CRIT("EEC_BENEF",.F.),M->EEC_BENEF,M->EEC_BENEF) EEC_BENEF P N 0 S
EEC_CLIENT 001 AVGatilho(M->EEC_CLIENT,'SA1') EEC_CLLOJA P N 0 !IsInCallStack("CONPAD1") S
EEC_CLIENT 002 IF(!EMPTY(M->EEC_CLIENT),SA1->A1_NOME,"") EEC_CLIEDE P N 0 S
EEC_CLIENT 003 IF(!EMPTY(M->EEC_CLIENT),SA1->A1_PAIS,M->EEC_PAISET) EEC_PAISET P N 0 S
EEC_CLLOJA 001 IF(!EMPTY(M->EEC_CLLOJA),SA1->A1_NOME,"") EEC_CLIEDE P S SA1 1 XFILIAL("SA1")+M->EEC_CLIENT+M->EEC_CLLOJA S
EEC_CODAGT 001 IF(!EMPTY(M->EEC_CODAGT),SY5->Y5_NOME,"") EEC_DSCAGT P S SY5 1 XFILIAL("SY5")+M->EEC_CODAGT S
EEC_COLOJA 001 IF(!EMPTY(M->EEC_COLOJA),SA1->A1_NOME,"") EEC_CONSDE P S SA1 1 XFILIAL("SA1")+M->EEC_CONSIG+IF(!EMPTY(M->EEC_COLOJA),M->EEC_COLOJA,"") S
EEC_COND2 001 SY6->Y6_DIAS_PA EEC_DIAS2 P S SY6 1 XFILIAL("SY6")+M->EEC_COND2 S
EEC_CONDPA 001 SY6->Y6_DIAS_PA EEC_DIASPA P S SY6 1 XFILIAL("SY6")+M->EEC_CONDPA EMPTY(M->EEC_DIASPA) S
EEC_CONDPA 002 IF(SY6->(EOF()),Posicione("SY6",1,xFilial("SY6")+M->EEC_CONDPA,"Y6_DIAS_PA"),M->EEC_DIASPA) EEC_DIASPA P S SY6 1 XFILIAL("SY6")+M->EEC_CONDPA+STR(M->EEC_DIASPA,AVSX3("EEC_DIASPA",3)) !EMPTY(M->EEC_DIASPA) S
EEC_CONDPA 003 SY6->(MSMM(SY6->Y6_DESC_P,50,,,3)) EEC_DESCPA P S SY6 1 XFILIAL("SY6")+M->EEC_CONDPA+STR(M->EEC_DIASPA,AVSX3("EEC_DIASPA",3)) !EMPTY(M->EEC_CONDPA) S
EEC_CONDPA 004 IF(EMPTY(M->EEC_CONDPA),"",SY6->Y6_MDPGEXP) EEC_MPGEXP P N 0 S
EEC_CONDPA 005 IF(EMPTY(M->EEC_CONDPA),"",EEF->EEF_DESC) EEC_DSCMPE P S EEF 1 XFILIAL("EEF")+M->EEC_MPGEXP S
EEC_CONSIG 001 AVGatilho(M->EEC_CONSIG,'SA1','2|4') EEC_COLOJA P N SA1 1 !IsInCallStack("CONPAD1") S
EEC_CONSIG 002 IF(!EMPTY(M->EEC_CONSIG),SA1->A1_NOME,"") EEC_CONSDE P S SA1 1 XFILIAL("SA1")+M->EEC_CONSIG+IF(!EMPTY(M->EEC_COLOJA),M->EEC_COLOJA,"") S
EEC_DIASPA 001 SY6->(MSMM(SY6->Y6_DESC_P,50,,,3)) EEC_DESCPA P S SY6 1 XFILIAL("SY6")+M->EEC_CONDPA+STR(M->EEC_DIASPA,AVSX3("EEC_DIASPA",3)) !EMPTY(M->EEC_DIASPA) S
EEC_DTEMBA 001 "6" EEC_STATUS P N 0 !EMPTY(M->EEC_DTEMBA) S
EEC_DTEMBA 002 DSCSITEE7(,"E") EEC_STTDES P N 0 !EMPTY(M->EEC_DTEMBA) S
EEC_DTREC 001 M->EEC_DTREC EXL_DTREC P 0 S
EEC_DUEMAN 001 M->EEC_DUEMAN EEC_NRODUE P N 0 S
EEC_EMBAFI 001 AP100CUBAGEM(.T.,"Q") EEC_CUBAGE P N 0 !EMPTY(M->EEC_EMBAFI) S
EEC_EMBARC 001 IIF(EMPTY(M->EEC_EMBARC),'', EE6->EE6_VIAGEM) EEC_VIAGEM P S EE6 1 xFilial('EE6')+M->EEC_EMBARC S
EEC_ESPTRA 001 If(!Empty(M->EEC_ESPTRA),Posicione('EVN',1,xFilial('EVN')+M->EEC_ESPTRA+'TRA','EVN_DESCRI'),"") EEC_DESTRA P N 0 S
EEC_EXLOJA 001 IF(!EMPTY(M->EEC_EXLOJA),SA2->A2_NOME,"") EEC_EXPODE P S SA2 1 XFILIAL("SA2")+M->EEC_EXPORT+IF(!EMPTY(M->EEC_EXLOJA),M->EEC_EXLOJA,"") S
EEC_EXPORT 001 AVGatilho(M->EEC_EXPORT,'SA2','3|4') EEC_EXLOJA P N 0 !IsInCallStack("CONPAD1") S
EEC_EXPORT 002 IF(!EMPTY(M->EEC_EXPORT),SA2->A2_NOME,"") EEC_EXPODE P S SA2 1 XFILIAL("SA2")+M->EEC_EXPORT+IF(!EMPTY(M->EEC_EXLOJA),M->EEC_EXLOJA,"") S
EEC_FOLOJA 001 IF(!EMPTY(M->EEC_FOLOJA),SA2->A2_NOME,"") EEC_FORNDE P S SA2 1 XFILIAL("SA2")+M->EEC_FORN+M->EEC_FOLOJA S
EEC_FOREXP 001 If(!Empty(M->EEC_FOREXP),Posicione('EVN',1,xFilial('EVN')+M->EEC_FOREXP+'CUS','EVN_DESCRI'),"") EEC_DESFOR P N 0 S
EEC_FORN 001 AVGatilho(M->EEC_FORN,'SA2','2|3') EEC_FOLOJA P N 0 !IsInCallStack("CONPAD1") S
EEC_FORN 002 SA2->A2_NOME EEC_FORNDE P N 0 !Empty(SA2->A2_NOME) S
EEC_IDIOMA 001 AP106IDIOMA("Q") EEC_IDIOMA P 0 S
EEC_IMLOJA 001 SA1->A1_NOME EEC_IMPODE P S SA1 1 XFILIAL("SA1")+M->EEC_IMPORT+M->EEC_IMLOJA S
EEC_IMLOJA 002 IF(EMPTY(M->EEC_PAISET),SA1->A1_PAIS,M->EEC_PAISET) EEC_PAISET P N 0 S
EEC_IMLOJA 003 AE100Import() EEC_VALCOM P N 0 S
EEC_IMLOJA 004 IF(AE100CRIT("EEC_IMPORT",.F.),M->EEC_IMPORT,M->EEC_IMPORT) EEC_IMPORT P N 0 S
EEC_IMLOJA 005 EECMEND("SA1",1,M->EEC_IMPORT+M->EEC_IMLOJA,.T.,AvSx3("EEC_ENDIMP",3),1) EEC_ENDIMP P N 0 S
EEC_IMLOJA 006 EECMEND("SA1",1,M->EEC_IMPORT+M->EEC_IMLOJA,.T.,AvSx3("EEC_END2IM",3),2) EEC_END2IM P N 0 S
EEC_IMLOJA 007 POSICIONE("SYA",1,xFilial("SYA")+SA1->A1_PAIS,"YA_IDIOMA") EEC_IDIOMA P N 0 !Empty(SA1->A1_PAIS) S
EEC_IMPORT 001 AVGatilho(M->EEC_IMPORT,'SA1','1|4') EEC_IMLOJA P N 0 !IsInCallStack("CONPAD1") S
EEC_IMPORT 002 SA1->A1_NOME EEC_IMPODE P N 0 S
EEC_IMPORT 003 IF(EMPTY(M->EEC_PAISET),SA1->A1_PAIS,M->EEC_PAISET) EEC_PAISET P N 0 S
EEC_IMPORT 004 AE100Import() EEC_VALCOM P N 0 S
EEC_IMPORT 005 IF(AE100CRIT("EEC_IMPORT",.F.),M->EEC_IMPORT,M->EEC_IMPORT) EEC_IMPORT P N 0 S
EEC_IMPORT 006 EECMEND("SA1",1,M->EEC_IMPORT+M->EEC_IMLOJA,.T.,AvSx3("EEC_ENDIMP",3),1) EEC_ENDIMP P N 0 S
EEC_IMPORT 007 EECMEND("SA1",1,M->EEC_IMPORT+M->EEC_IMLOJA,.T.,AvSx3("EEC_END2IM",3),2) EEC_END2IM P N 0 S
EEC_IMPORT 008 POSICIONE("SYA",1,xFilial("SYA")+SA1->A1_PAIS,"YA_IDIOMA") EEC_IDIOMA P N 0 AP102CondGat() S
EEC_INCOTE 001 SYJ->YJ_FRPPCC EEC_FRPPCC P S SYJ 1 XFILIAL("SYJ")+M->EEC_INCOTE S
EEC_LIBSIS 001 IF(EMPTY(M->EEC_LIBSIS),"1","2") EEC_STASIS P N 0 S
EEC_MOTDIS 001 If(!Empty(M->EEC_MOTDIS),Posicione('EVN',1,xFilial('EVN')+M->EEC_MOTDIS+'ACG','EVN_DESCRI'),"") EEC_DESDIS P N 0 S
EEC_MOTSIT 001 IF(!EMPTY(M->EEC_MOTSIT),EE4->(MSMM(EE4->EE4_TEXTO,60)),"") EEC_DSCMTS P S EE4 1 XFILIAL("EE4")+M->EEC_MOTSIT+"1" S
EEC_MPGEXP 001 IF(EMPTY(M->EEC_MPGEXP),"",EEF->EEF_DESC) EEC_DSCMPE P S EEF 1 XFILIAL("EEF")+M->EEC_MPGEXP S
EEC_PEDREF 001 AE100PEDREF() EEC_IMPORT P N 0 !EMPTY(M->EEC_PEDREF) S
EEC_PREEMB 001 "1" EEC_STASIS P N 0 !EMPTY(M->EEC_PREEMB) S
EEC_PREEMB 002 M->EEC_PREEMB EEC_NRINVO P N 0 S
EEC_SITESP 001 If(!Empty(M->EEC_SITESP),Posicione('EVN',1,xFilial('EVN')+M->EEC_SITESP+'AHZ','EVN_DESCRI'),"") EEC_DESSIT P N 0 S
EEC_UNIDAD 001 IF(ALLWAYSTRUE(AE100TTELA(.F.)),M->EEC_UNIDAD,NIL) EEC_UNIDAD P N 0 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
EEC 001 EEN EEC_PREEMB EEN_PROCES S 1 N #EEN_OCORRE='Q' S S 2 2
EEC 002 EY9 EEC_PREEMB EY9_PREEMB S 1 N S S 2 2
EEC 003 EXT EEC_PREEMB EXT_PREEMB S 1 N S S 2 2
EEC 004 EET EEC_PREEMB EET_PEDIDO S 1 N #EET_OCORRE='Q' S S 2 2
EEC 005 EER EEC_PREEMB EER_PREEMB S 1 N S S 2 2
EEC 006 EXZ EEC_PREEMB EXZ_PREEMB S 1 N S 2 2
EEC 007 EXK EEC_PREEMB EXK_PROC S 1 N #EXK_TIPO ='Q' S S 2 2
EEC 008 EXP EEC_PREEMB EXP_PREEMB S 1 N S S 2 2
EEC 009 ECA EEC_PREEMB ECA_PREEMB S 1 N #ECA_FASE ='E' AND #ECA_TPMODU='EXPORT' S S 2 2
EEC 010 EEJ EEC_PREEMB EEJ_PEDIDO S 1 N #EEJ_OCORRE='Q' S S 2 2
EEC 011 EE9 EEC_PREEMB EE9_PREEMB S 1 N S S 2 2
EEC 012 EF3 EEC_PREEMB EF3_PREEMB S 1 N S S 2 2
EEC 013 EX9 EEC_PREEMB EX9_PREEMB S 1 N S S 2 2
EEC 014 EXG EEC_PREEMB EXG_PREEMB S 1 N S S 2 2
EEC 015 EXM EEC_PREEMB EXM_PREEMB S 1 N S S 2 2
EEC 016 ED1 EEC_PREEMB ED1_PREEMB S 1 N S S 2 2
EEC 017 EXB EEC_PREEMB EXB_PREEMB S 1 N S S 2 2
EEC 018 EXL EEC_PREEMB EXL_PREEMB S 1 N S S 2 2
EEC 019 EEM EEC_PREEMB EEM_PREEMB S 1 N S S 2 2
EEC 020 EEB EEC_PREEMB EEB_PEDIDO S 1 N #EEB_OCORRE='Q' 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 @!
033 Tamanho da Filial Tamano de la Sucursal Branch Size 12 2 2
122 Unidade de Medida Unidad de medida Measure Unit 10 2 2
175 Nome do Cliente Nombre del cliente Customer Name 254 50 50 @!
177 Nome do Fornecedor Nombre del proveedor Supplier Name 254 50 50 @!

 

 

 

 

 

 

 

 

 

 

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