Dicionário Protheus
Início
O Poder da Hiperautomação

Tabela EEC no Protheus

Embarque

O que é a tabela EEC no Protheus?

A tabela EEC faz parte do sistema ERP Protheus da TOTVS e é utilizada para embarque.

Ela pertence ao dicionário de dados do Protheus (SX2) e armazena informações essenciais utilizadas em processos como cadastros, movimentações e integrações do sistema.

A tabela EEC possui diversos campos (SX3), cada um com regras específicas como tipo, tamanho e validações, além de índices (SIX) que otimizam a performance das consultas.

Nesta página você pode consultar a estrutura completa da tabela EEC, incluindo todos os campos e índices relacionados.

Propriedades da Tabela

Propriedade Valor
X2_CHAVE EEC
X2_PATH \DATA\
X2_ARQUIVO EEC990
X2_NOME Embarque
X2_NOMESPA Embarque
X2_NOMEENG Shipping
X2_ROTINA -
X2_MODO E
X2_MODOUN E
X2_MODOEMP E
X2_DELET 0
X2_TTS -
X2_UNICO EEC_FILIAL+EEC_PREEMB
X2_PYME N
X2_MODULO 29
X2_DISPLAY EEC_PREEMB+EEC_PEDREF+EEC_STTDES+EEC_MOTSIT+EEC_DSCMTS
X2_SYSOBJ EECAE100
X2_USROBJ -
X2_POSLGT 1
X2_CLOB 2
X2_AUTREC 2
X2_TAMFIL 2
X2_TAMUN 0
X2_TAMEMP 0
X2_STAMP 2
X2_INSDT 2
D_E_L_E_T_ -
R_E_C_N_O_ 3746
R_E_C_D_E_L_ 0

Campos da Tabela EEC (256 campos)

X3_ARQUIVO X3_ORDEM X3_CAMPO X3_TIPO X3_TAMANHO X3_DECIMAL X3_TITULO X3_TITSPA X3_TITENG X3_DESCRIC X3_DESCSPA X3_DESCENG X3_PICTURE X3_VALID X3_USADO X3_RELACAO X3_F3 X3_NIVEL X3_RESERV X3_CHECK X3_TRIGGER X3_PROPRI X3_BROWSE X3_VISUAL X3_CONTEXT X3_OBRIGAT X3_VLDUSER X3_CBOX X3_CBOXSPA X3_CBOXENG X3_PICTVAR X3_WHEN X3_INIBRW X3_GRPSXG X3_FOLDER X3_PYME X3_CONDSQL X3_CHKSQL X3_IDXSRV X3_ORTOGRA X3_IDXFLD X3_TELA X3_PICBRV X3_AGRUP X3_POSLGT X3_MODAL X3_CHKSUM X3_ADDSUM D_E_L_E_T_ R_E_C_N_O_ R_E_C_D_E_L_
EEC 01 EEC_FILIAL C 2 0 Filial Sucursal Branch Filial do Sistema Sucursal del Sistema System Branch - AE100CRIT('EEC_QTDEMB') x x x x x x x x x x x x x x x - - 1 - - - - N - - - - - - - - - - 033 - N - - N N N - - - 1 2 - - - 59196 0
EEC 02 EEC_PREEMB C 20 0 Processo Proceso Process Codigo Embarque Codigo Embarque Shipment Code @! NaoVazio() .And. EXISTCHAV("EEC") x x x x x xxx x x xx x x x x x x x x - - 1 x xxx - S - S - - - - - - - - - - - 1 N - - S N N - - - 1 1 - - - 59197 0
EEC 03 EEC_PEDREF C 20 0 Processo Ref Proceso Ref Ref. Process Processo Referencia Proceso Referencia Reference Process @! Existcpo("EE7",M->EEC_PEDREF) .And. Ae108VldSelPed(M->EEC_PEDREF) x x x x x xx x x xx x x x x x x x - EE7 1 x xx x - S - N - - - - - - - - AE100W("EEC_PEDREF") .And. !lProcReplicado - - 1 N - - S N N - - - 1 2 - - - 59198 0
EEC 04 EEC_DTPROC D 8 0 Dt.Processo Fch.Proceso Process Date Data Processo Fecha Proceso Process Date @D - x x x x x xxx x x xx x x x x x x x dDatabase - 1 xx x - - - S - - - - - - - - lALTERA - - 1 N - - N N N - - - 1 2 - - - 59199 0
EEC 05 EEC_FIM_PE D 8 0 Dt.Encerram. Fch.Cierre Closing Date Dt.Encerramamento Fecha Cierre Closing Date @D - x x x x x xx x x xx x x x x x x x - - 1 xx x - - - S - - - - - - - - .F. - - - N - - N N N - - - 1 2 - - - 59200 0
EEC 06 EEC_VM_AMO C 25 0 Amostra Muestra Sample Amostra Muestra Sample - - x x x x x x x x x x x x x x x - - 1 x x x - - - S - V - - - - - - - IniBrwAmostra("EEC") - - N - - N N N - - - 1 2 - - - 59201 0
EEC 07 EEC_ENVAMO C 1 0 Env.Amostra? ¿Env.Muest.? Send sample Envia Amostra? ¿Envia Muestra? Send sample - Pertence("12") x x x x xx x x x x x x x x x x "2" - 1 x - - - N A R - - 1=Sim; 2=Nao 1=Si; 2=No 1=Yes; 2=No - - - - 1 N - - N N N - - - 1 2 - - - 59202 0
EEC 08 EEC_AMOSTR C 1 0 Amostra Muestra Sample Amostra Muestra Sample @! PERTENCE('124').AND.AE100CRIT('EEC_AMOSTR') x x x x xx x x xx x x x x x x x "2" - 1 x x x - - - N - - - - 1=Sim – Sem Faturamento;2=Não;4=Sim – Com Faturamento 1=Sí – Sin facturación;2=No;4=Sí – Con facturación 1=Yes – Without Invoicing;2=No;4=Yes – With Invoicing - lALTERA - - 1 N - - N N N - - - 1 2 - - - 59203 0
EEC 09 EEC_STATUS C 1 0 Status Estatus Status Situacao do proce.exp. Situacion de proce.exp. Exp. process status - DSCSITEE7(,"E") x x x x x xx x x xx x x x x x x x - - 1 x xx x - - - N - - - - - - - - lALTERA - - - N - - N N N - - - 1 2 - - - 59204 0
EEC 10 EEC_IMPORT C 6 0 Cod. Import. Cod. Import. Import. Code Codigo do Importador Codigo del Importador Importer Code @! AE100CRIT("EEC_IMPORT").And.AE100Crit("EEC_MARCAC") x x x x x xx x x xx x x x x x x x - AVE001 1 x xx - S - N - - - - - - - - AE100W("EEC_IMPORT") - 001 1 N - - N N N - - - 1 1 - - - 59205 0
EEC 11 EEC_IMLOJA C 2 0 Loja Import. Tienda Impor Imp. Store Loja do Importador Tienda de Importador Importer Store @! AE100CRIT("EEC_IMLOJA") .And. AE100Crit("EEC_MARCAC") x x x x xx x x xx x x x x x x x - - 1 x xx - S - N - - - - - - - - AE100W("EEC_IMLOJA") - 002 1 N - - N N N - - - 1 1 - - - 59206 0
EEC 12 EEC_IMPODE C 50 0 Importador Importador Importer Nome do Importador Nombre del Importador Importer Name @! NAOVAZIO() x x x x x xx x x xx x x x x x x x - - 1 x xxx - - - S A R - - - - - - lALTERA - 175 1 N - - N N N - - - 1 1 - - - 59207 0
EEC 13 EEC_STTDES C 60 0 Status Estatus Status Descricao situacao Descripcion situacion Status description - - x x x x x xx x x xx x x x x x x x - - 1 x xx x - - - S V - - - - - - - lALTERA - - 1 N - - S N N - - - 1 2 - - - 59208 0
EEC 14 EEC_MOTSIT C 15 0 Situacao Situacion Status Motivo situacao Motivo situacion Status Reason - Vazio() .Or. AE100CRIT("EEC_MOTSIT") x x x x x xx x x xx x x x x x x x - EE4 1 x xx x - S - N - - - - - - - - lSITUACAO - - 1 N - - S N N - - - 1 2 - - - 59209 0
EEC 15 EEC_DSCMTS C 60 0 Dsc.Situacao Dsc.Situac. Status Desc. Descricao motivo situacao Descr. motivo situacion Motive/Status Description @! - x x x x x xx x x xx x x x x x x x E_FIELD2(EEC->EEC_MOTSIT+"1-Descricao de Situacao","EE4",1,,"EE4->EE4_TEXTO",60) - 1 x xx x - - - N V V - - - - - - - - - 1 N - - N N N - - - 1 2 - - - 59210 0
EEC 16 EEC_ENDIMP C 100 0 End. Import. Dir. Import. Import.Addr. Endereço Importador Direccion Importador Importer Address @! - x x x x x xx x x xx x x x x x x x - - 1 x xx x - - - N - - - - - - - - lALTERA - - 1 N - - N N N - - - 1 2 - - - 59211 0
EEC 17 EEC_END2IM C 100 0 Compl.End Compl.Direc. Im.Adr.Com. Compl.End Importador Compl. Dir. Importador Importer Complem. Address @! - x x x x x xx x x xx x x x x x x x - - 1 x xx x - - - N - - - - - - - - lALTERA - - 1 N - - N N N - - - 1 2 - - - 59212 0
EEC 18 EEC_REFIMP C 40 0 Ref.Import. Ref. Import. Importer Rf. Referencia Importador Referencia Importador Importer Reference @! AE100Crit("EEC_MARCAC") x x x x x xx x x xx x x x x x x x - - 1 x xx x - - - N - - - - - - - - lALTERA - - 1 N - - N N N - - - 1 2 - - - 59213 0
EEC 19 EEC_EXLIMP C 1 0 Exige L.I. +Exige L.I.? Require I.L. Exige licenca importacao Exige licencia importac. Require Import License @! PERTENCE("12") x x x x xx x x xx x x x x x x x "2" - 1 x x x - - - N - - - - 1=Sim;2=Nao 1=Si;2=No 1=Yes;2=No - lALTERA - - 7 N - - N N N - - - 1 2 - - - 59214 0
EEC 20 EEC_LICIMP C 60 0 Licenc.Imp. Licenc. Imp. Impor.Licen. Nr. Licenca Importacao Nro. Licencia Importacion Import License Number @! - x x x x x xx x x xx x x x x x x x - - 1 x x x - - - N - - - - - - - - lALTERA - - 7 N - - N N N - - - 1 2 - - - 59215 0
EEC 21 EEC_INTERM C 1 0 OffShore OffShore OffShore OffShore OffShore OffShore @! Pertence("12") .And. Ae100Crit("EEC_INTERM") x x x x x x x x x x x x x x x x "2" - 1 x xx x - - - N - - - - 1=Sim;2=Nao 1=Si;2=No 1=Yes;2=No - lALTERA - - 7 N - - N N N - - - 1 2 - - - 59216 0
EEC 22 EEC_DTLIMP D 8 0 Prazo L.I. Plazo L.I. IL Due Date Validade Licenca Imp. Validez Licencia Imp. Import License Exp. Date - - x x x x xx x x xx x x x x x x x - - 1 xx x - - - N - - - - - - - - lALTERA - - 7 N - - N N N - - - 1 2 - - - 59217 0
EEC 23 EEC_CLIENT C 6 0 Cod.Cliente Cod.Cliente Cust. Code Codigo do cliente final Codigo del cliente final End Customer Code @! Vazio().OR.AE100CRIT("EEC_CLIENT") x x x x x xx x x xx x x x x x x x - AVE002 1 x xx x - S - N - - - - - - - - AE100W("EEC_CLIENT") - 001 7 N - - N N N - - - 1 2 - - - 59218 0
EEC 24 EEC_CLLOJA C 2 0 Loja Cliente Tienda Clte Client Store Loja do Cliente Tienda de Cliente Client Store @! AE100CRIT("EEC_CLLOJA") x x x x xx x x xx x x x x x x x - - 1 x x x - S - N - - - - - - - - lALTERA - 002 7 N - - N N N - - - 1 2 - - - 59219 0
EEC 25 EEC_CLIEDE C 50 0 Client.Final ClienteFinal Fin.Customer Nome do cliente final Nombre del cliente final Final Customer Name @! - x x x x x xx x x xx x x x x x x x POSICIONE("SA1",1,XFILIAL("SA1")+M->EEC_CLIENT+M->EEC_CLLOJA,"A1_NOME") - 1 x xx x - - - S V V - - - - - - lALTERA E_Field("EEC_CLIENT","A1_NOME","B",.T.) 175 7 N - - N N N - - - 1 2 - - - 59220 0
EEC 26 EEC_FORN C 6 0 Cod.Fornec. Cod.Proveed. Sup. Code Fornecedor Proveedor Supplier @! AE100CRIT("EEC_FORN").And.AE100Crit("EEC_MARCAC") x x x x xx x x xx x x x x x x x - AVE005 1 x xx - S - N - - - - - - - - AE100W("EEC_FORN") - 001 1 N - - N N N - - - 1 1 - - - 59221 0
EEC 27 EEC_FOLOJA C 2 0 Loja Fornec. Tienda Prov Sup. Store Loja do Fornecedor Tienda de Proveedor Supplier Store @! AE100CRIT("EEC_FOLOJA") .And. AE100Crit("EEC_MARCAC") x x x x xx x x xx x x x x x x x - - 1 x xx - S - N - - - - - - - - AE100W("EEC_FOLOJA") - 002 1 N - - N N N - - - 1 1 - - - 59222 0
EEC 28 EEC_FORNDE C 50 0 Fornecedor Proveedor Supplier Nome do Fornecedor Nombre del Proveedor Supplier's Name @! - x x x x xx x x xx x x x x x x x POSICIONE("SA2",1,XFILIAL("SA2")+M->EEC_FORN+M->EEC_FOLOJA,"A2_NOME") - 1 x xx - - - S V V - - - - - - lALTERA E_Field("EEC_FORN","A2_NOME","B",.T.) 177 1 N - - N N N - - - 1 1 - - - 59223 0
EEC 29 EEC_INCO2 C 3 0 Incoterm Incoterm NCOTERM Incoterm Incoterm NCOTERM @! ExistCpo("SYJ",M->EEC_INCO2) x x x x x x x x x x x x x x x x - SYJ 1 x xx x - - - N - - - - - - - - M->EEC_INTERM="1" - - 7 N - - N N N - - - 1 2 - - - 59224 0
EEC 30 EEC_EXPORT C 6 0 Cod.Export. Cod.Export. Export. Code Exportador Exportador Exporter @! AE100CRIT("EEC_EXPORT") .AND. AE100Crit("EEC_MARCAC") x x x x x xx x x xx x x x x x x x - AVE006 1 x x x - S - N - - - - - - - - AE100W("EEC_EXPORT") - 001 7 N - - N N N - - - 1 2 - - - 59225 0
EEC 31 EEC_EXLOJA C 2 0 Loja Export. Tienda Expo Exp. Store Loja do Exportador Tienda de Exportador Exporter Store @! AE100CRIT("EEC_EXLOJA") .And. AE100Crit("EEC_MARCAC") x x x x xx x x xx x x x x x x x - - 1 x x x - S - N - - - - - - - - lALTERA - 002 7 N - - N N N - - - 1 2 - - - 59226 0
EEC 32 EEC_EXPODE C 50 0 Exportador Exportador Exporter Nome do Exportador Nombre del Exportador Exporter Name @! - x x x x x xx x x xx x x x x x x x POSICIONE("SA2",1,XFILIAL("SA2")+M->EEC_EXPORT+M->EEC_EXLOJA,"A2_NOME") - 1 x xx x - - - S V V - - - - - - lALTERA E_Field("EEC_EXPORT","A2_NOME","B",.T.) 177 7 N - - N N N - - - 1 2 - - - 59227 0
EEC 33 EEC_COND2 C 5 0 Cond.Pagto. Cond.Pago Paym. Term Condicao de pagamento Condicion de pago Payment Term @! ExistCpo("SY6",M->EEC_COND2,1) x x x x x x x x x x x x x x x x - SY6 1 x xx x - S - N - - - - - - - - M->EEC_INTERM="1" - - 7 N - - N N N - - - 1 2 - - - 59228 0
EEC 34 EEC_DIAS2 N 3 0 Dias Pagto. Dias Pago Paym.Days Dias Pagamento Dias pago Payment Days 999 ExistCpo("SY6",M->EEC_COND2+STR(M->EEC_DIAS2,AVSX3("EEC_DIAS2",3)),1) x x x x x x x x x x x x x x x x - - 1 xxxx x - - - N - - - - - - - - M->EEC_INTERM="1" - - 7 N - - N N N - - - 1 2 - - - 59229 0
EEC 35 EEC_CONSIG C 6 0 Cod.Consign. Cod.Consign. Consign.Code Codigo do consignatario Codigo del consignatario Consignee Code @! AE100CRIT("EEC_CONSIG") x x x x x xx x x xx x x x x x x x - AVE003 1 x xx x - S - N - - - - - - - - AE100W("EEC_CONSIG") - 001 1 N - - N N N - - - 1 2 - - - 59230 0
EEC 36 EEC_COLOJA C 2 0 Loja Consig. Tienda Consi Cons. Store Loja do Consignatario Tienda de Consignatario Consignee Store @! AE100CRIT("EEC_COLOJA") x x x x xx x x xx x x x x x x x - - 1 x x x - S - N - - - - - - - - lALTERA - 002 1 N - - N N N - - - 1 2 - - - 59231 0
EEC 37 EEC_CONSDE C 50 0 Consignee Consignee Consignee Nome do consignatario Nombre del consignatario Name of Consignee @! if(!empty(M->EEC_CONSIG), NaoVazio(),.T.) x x x x x xx x x xx x x x x x x x POSICIONE("SA1",1,XFILIAL("SA1")+M->EEC_CONSIG+M->EEC_COLOJA,"A1_NOME") - 1 x xx x - - - S A R - - - - - - lALTERA POSICIONE("SA1",1,XFILIAL("SA1")+EEC->EEC_CONSIG+EEC->EEC_COLOJA,"A1_NOME") 175 1 N - - N N N - - - 1 2 - - - 59232 0
EEC 38 EEC_RESPON C 35 0 Anal. Resp. Analis.Resp. Analyst Res. Analista Responsavel Analista Responsable Analyst Responsable @! - x x x x x xxx x x xx x x x x x x x - AVE009 1 x x x - - - N - - - - - - - - AE100W("EEC_RESPON") - - 1 N - - N N N - - - 1 2 - - - 59233 0
EEC 39 EEC_BENEF C 6 0 Cod.Benef. Cod.Benef. Benef. Code Beneficiario Beneficiario Beneficiary @! VAZIO().OR.AE100CRIT("EEC_BENEF") x x x x xx x x xx x x x x x x x - AVE007 1 x x x - S - N - - - - - - - - AE100W("EEC_BENEF") - 001 2 N - - N N N - - - 1 2 - - - 59234 0
EEC 40 EEC_BELOJA C 2 0 Loja Benef. Tienda Benef Ben. Store Loja do Beneficiario Tienda de Beneficiario Beneficiary Store @! AE100CRIT("EEC_BELOJA") x x x x xx x x xx x x x x x x x - - 1 x x x - S - N - - - - - - - - lALTERA - 002 2 N - - N N N - - - 1 2 - - - 59235 0
EEC 41 EEC_BENEDE C 60 0 Beneficiario Beneficiario Beneficiary Nome do Beneficiario Nombre del Beneficiario Beneficiary Name @! - x x x x xx x x xx x x x x x x x - - 1 x x x - - - S - - - - - - - - lALTERA - - 2 N - - N N N - - - 1 2 - - - 59236 0
EEC 42 EEC_ENDBEN C 100 0 End.Benef. Dir. Benef. Benef. Addr. Endereco Beneficiario Direccion Beneficiario Beneficiary Address @! - x x x x x xx x x xx x x x x x x x - - 1 x xx x - - - N - - - - - - - - lALTERA - - 2 N - - N N N - - - 1 2 - - - 59237 0
EEC 43 EEC_END2BE C 100 0 Comp.End. Comp.Direc. Addr.Comp. Endereco Beneficiario Direccion Beneficiario Beneficiary Address @! - x x x x x xx x x xx x x x x x x x - - 1 x xx x - - - N - - - - - - - - lALTERA - - 2 N - - N N N - - - 1 2 - - - 59238 0
EEC 44 EEC_CONDPA C 5 0 Cond. Pagto Cond. Pago Payment Term Cond. Pagto Cond. Pago Payment Term @! ExistCpo("SY6",M->EEC_CONDPA,1).AND.AE100CRIT("EEC_CONDPA") x x x x x xx x x xx x x x x x x x - SY6 1 x xxx - S - N - - - - - - - - lALTERA - - 2 N - - N N N - - - 1 1 - - - 59239 0
EEC 45 EEC_CLIENF C 6 0 Cli.Mult.Off Cli.Mult.Off Cli.Mult.Off Cli. final Multi-OffShore Cli. final Multi-OffShore End.Client Multi-offshore @! Vazio() .OR. AE100CRIT("EEC_CLIENF") x x x x xx x x x x x x x x x x - ER3 1 x - - - N A R - - - - - - lAltera - 001 1 N - - N N N - - - 1 2 - - - 59240 0
EEC 46 EEC_CLOJAF C 2 0 Lj. Cliente Tda Cliente Cust. Store Loja do Cliente Final Tienda de Cliente Final Final Customer Store @! Vazio() .OR. ExistCpo("SA1",M->EEC_CLIENF+M->EEC_CLOJAF) x x x x xx x x x x x x x x x x - - 1 x - - - N A R - - - - - - lAltera - 002 1 N - - N N N - - - 1 2 - - - 59241 0
EEC 47 EEC_DIASPA N 3 0 Dias Pagto Dias Pago Days Paym. Dias Pagto Dias Pago Days for Payment 999 ExistCpo("SY6",M->EEC_CONDPA+Str(M->EEC_DIASPA,AVSX3("EEC_DIASPA",3)),1) .AND. AE100CRIT("EEC_DIASPA") x x x x x xx x x xx x x x x x x x - - 1 xxxx x - S - N - - - - - - - - lALTERA - - 2 N - - N N N - - - 1 2 - - - 59242 0
EEC 48 EEC_DESCPA C 60 0 Descricao Descripcion Description Descricao em Portugues Descripcion en Portugues Description in Portuguese - - x x x x x xx x x xx x x x x x x x E_FIELD2(M->EEC_CONDPA+STR(M->EEC_DIASPA,3),"SY6",1,,"SY6->Y6_DESC_P",60) - 1 x xx x - - - N V V - - - - - - lALTERA - - 2 N - - N N N - - - 1 2 - - - 59243 0
EEC 49 EEC_MPGEXP C 3 0 Mod.Pgto.Exp Mod.Pago Exp Exp.Pay.Mod. Modalidade Pagto Naturaleza de Pago Payment Mode @! EXISTCPO("EEF",M->EEC_MPGEXP) .And. AE100CRIT("EEC_MPGEXP") x x x x xx x x xx x x x x x x x "003" EEF 1 x xx - S - N - - - - - - - - lALTERA - - 2 N - - N N N - - - 1 1 - - - 59244 0
EEC 50 EEC_DSCMPE C 52 0 Descricao Descripcion Description Descricao Modal.Pgto. Descripc. Modalidad Pago Payment Mode Description @! - x x x x xx x x xx x x x x x x x E_FIELD("EEC_MPGEXP","EEF_DESC") - 1 x x x - - - N V V - - - - - - lALTERA - - 2 N - - N N N - - - 1 2 - - - 59245 0
EEC 51 EEC_INCOTE C 3 0 Incoterm Incoterm Incoterm Incoterm Incoterm Incoterm @! ExistCpo("SYJ",M->EEC_INCOTE) .and. DIVldIcoterm() x x x x x xx x x xx x x x x x x x "2" SYJ 1 x xxx - S - N - - - - - - - - lALTERA - - 2 N - - N N N - - - 1 1 - - - 59246 0
EEC 52 EEC_VIA C 2 0 Via Transp. Medio Transp Transp. Mean Via Transp. Medio Transporte Transportation Means - AE100CRIT("EEC_VIA") x x x x x xx x x xx x x x x x x x - SYQ 1 x xxxx - - - N - - - - - - - - lALTERA - - 4 N - - N N N - - - 1 1 - - - 59247 0
EEC 53 EEC_VIA_DE C 50 0 Descr.da Via Descr.Medio Means Descr. Descricao Via Transporte Descrip. Medio Transporte Transp. Means Description @! - x x x x x xx x x xx x x x x x x x E_FIELD("EEC_VIA","YQ_DESCR") - 1 x xx x - - - N V V - - - - - - lALTERA - - 4 N - - N N N - - - 1 2 - - - 59248 0
EEC 54 EEC_ORIGEM C 3 0 Origem Origen Source Origem Origen Source @! AE100CRIT("EEC_ORIGEM") x x x x x xx x x xx x x x x x x x - EV8 1 x xxxx - - - N - - - - - - - - AE100W("EEC_ORIGEM") - - 4 N - - N N N - - - 1 1 - - - 59249 0
EEC 55 EEC_DSCORI C 25 0 Desc.Origem Desc.Origen Sour. Desc. Descricao Origem Descripcion Origen Source Description @! - x x x x x xx x x xx x x x x x x x E_FIELD("EEC_ORIGEM","Y9_DESCR",,,2) - 1 x x x - - - N V V - - - - - - lALTERA - - 4 N - - N N N - - - 1 2 - - - 59250 0
EEC 56 EEC_DEST C 3 0 Destino Destino Target Destino Destino Target @! AE100CRIT("EEC_MARCAC") .AND.AE100CRIT("EEC_DEST") x x x x x xx x x xx x x x x x x x - EV8 1 x xxxx - - - N - - - - - - - - AE100W("EEC_DEST") - - 4 N - - N N N - - - 1 1 - - - 59251 0
EEC 57 EEC_DSCDES C 25 0 Desc.Destino Desc.Destino Targ.Descr. Descricao Destino Descripcion Destino Target Description @! - x x x x x xx x x xx x x x x x x x E_FIELD("EEC_DEST","Y9_DESCR",,,2) - 1 x x x - - - N V V - - - - - - lALTERA - - 4 N - - N N N - - - 1 2 - - - 59252 0
EEC 58 EEC_TIPTRA C 1 0 Tipo Transp. Tipo Transp. Transp. Type Tipo de transporte Tipo de transporte Transportation Type 9 PERTENCE("123").AND.AE100CRIT("EEC_TIPTRA") x x x x x xx x x xx x x x x x x x - - 1 x xxxx - - - N - - - - 1=Cheio;2=Picados;3=Carga Solta 1=Lleno;2=De a poco;3=Carga Suelta 1=Full;2=Bulk;3=Untied Cargo - AE100W("EEC_TIPTRA") - - 4 N - - N N N - - - 1 1 - - - 59253 0
EEC 59 EEC_URFDSP C 7 0 URF Despacho URF Despacho Shipment URF U.R.F. DESPACHO U.R.F. DESPACHO Shipment URF @R 9999999 ExistCPO("SJ0",M->EEC_URFDSP) x x x x xx x x xx x x x x x x x - URF 1 x x x - - - N - - - - - - - - lALTERA - - 5 N - - N N N - - - 1 2 - - - 59254 0
EEC 60 EEC_URFENT C 7 0 URF Entrega URF Entrega Delivery URF U.R.F. Entrega U.R.F. Entrega Delivery URF @R 9999999 ExistCPO("SJ0",M->EEC_URFENT) x x x x xx x x xx x x x x x x x - URF 1 x x x - - - N - - - - - - - - lALTERA - - 5 N - - N N N - - - 1 2 - - - 59255 0
EEC 61 EEC_PAISDT C 3 0 Pais Destino Pais Destino Dest.Country Pais Destino Pais Destino Destination Country @! Existcpo("SYA") x x x x xx x x xx x x x x x x x - SYA 1 x x x - - - N V - - - - - - - lALTERA - - 5 N - - N N N - - - 1 2 - - - 59256 0
EEC 62 EEC_PAISET C 3 0 Pais Entrega Pais Entrega Deliv.Count. Pais Entrega Pais Entrega Delivery Country @! Existcpo("SYA") .And. AE100CRIT("EEC_PAISET",.T.) x x x x xx x x xx x x x x x x x - SYA 1 x xx - - - N - - - - - - - - lALTERA - - 5 N - - N N N - - - 1 1 - - - 59257 0
EEC 63 EEC_MARCAC M 60 0 Marcacao Marcacion Mark Marcacao Marcacion Mark - - x x x x x xx x x xx x x x x x x x E_MSMM(EEC->EEC_CODMAR,20) - 1 x xx x - - - N A V - - - - - - lALTERA - - 3 N - - N N N - - - 1 2 - - - 59258 0
EEC 64 EEC_CODMAR C 6 0 Cod.Mem.Marc Cod.Mem.Marc Grad.Mem.Cod Codigo Campo Memo Marcac. Codigo Campo Memo Marcac. Grad. Memo Field Code - - x x x x x xx x x xx x x x x x x x - - 1 x xx x - - - N - - - - - - - - lALTERA - - 3 N - - N N N - - - 1 2 - - - 59259 0
EEC 65 EEC_MOEDA C 3 0 Moeda Neg. Moneda Neg. Neg.Currency Moeda negociada Moneda negociada Negot. Currency @! DIVldMoeda() .and. NaoVazio() .AND. EXISTCPO("SYF") x x x x x xxx x x xx x x x x x x x GETMV("MV_EECUSS") SYF 1 x xx - - - N - - - - - - - - lALTERA - - 2 N - - N N N - - - 1 1 - - - 59260 0
EEC 66 EEC_FRPPCC C 2 0 Tipo Frete Tipo Flete Freight Type Tipo Frete Tipo Flete Freight Type @! - x x x x x xx x x xx x x x x x x x "CC" - 1 x xxx - - - N - - - - CC=Collect;PP=Prepaid CC=Collect;PP=Prepaid CC=Collect;PP=Prepaid - lALTERA - - 2 N - - N N N - - - 1 1 - - - 59261 0
EEC 67 EEC_FRPREV N 15 2 Frete Intl. Flete Intl. Int. Freight Frete Intl. Flete Intl. International Freight @E 999,999,999,999.99 AE100Crit("EEC_FRPREV") .and. AE100PrecoI(.T.) x x x x x xx x x xx x x x x x x x - - 1 xxxx x - - - N V - - - - - - - - - - 2 N - - N N N - - - 1 2 - - - 59262 0
EEC 68 EEC_FREEMB N 15 2 Fre. Embut Flt Incorp Freight Incl Frete Embutido Flete Incorporado Freight Included @E 999,999,999,999.99 Vazio() .Or. Positivo() x x x x x x x x x x x x x x x x - - 1 x - - - N A R - - - - - - lAltera - - 2 N - - N - N - - - 1 2 - - - 59263 0
EEC 69 EEC_FRPCOM N 15 2 Frete Adic. Flete Adic. Add. Freight Frete Adic. Flete Adic. Addit.Freight @E 999,999,999,999.99 Positivo() .AND. AE100PrecoI(.T.) x x x x x xx x x xx x x x x x x x - - 1 xxxx x - - - N V - - - - - - - - - - 2 N - - N N N - - - 1 2 - - - 59264 0
EEC 70 EEC_SEGURO N 15 7 Seguro % Seguro % Insurance % Seguro % Seguro % Insurance % @E 9,999,999.9999999 AE100CRIT("EEC_SEGURO") x x x x x xx x x xx x x x x x x x - - 1 xxxx x - - - N - - - - - - - - lALTERA - - 2 N - - N N N - - - 1 2 - - - 59265 0
EEC 71 EEC_SEGPRE N 15 2 Seguro Intl. Seguro Intl. Int. Insur. Seguro Intl. Seguro Intl. International Insurance @E 999,999,999,999.99 Positivo() .AND. AE100CRIT("EEC_SEGPRE") x x x x x xx x x xx x x x x x x x - - 1 xxxx x - - - N V - - - - - - - - - - 2 N - - N N N - - - 1 2 - - - 59266 0
EEC 72 EEC_DESPIN N 15 2 Desp.Interna Gast.Interno Int. Expense Despesas Internas Gastos Internos Internal Expenses @E 999,999,999,999.99 (Vazio() .or. Positivo()) .and. AE100PrecoI(.T.) x x x x xx x x xx x x x x x x x - - 1 xxxx x - - - N V - - - - - - - - - - 2 N - - N N N - - - 1 2 - - - 59267 0
EEC 73 EEC_DESCON N 15 2 Desconto Descuento Discount Desconto Descuento Discount @E 999,999,999,999.99 Positivo().AND.AE100PRECOI() x x x x x xx x x xx x x x x x x x - - 1 xxxx x - - - N - - - - - - - - LALTERA .AND. !lDESCIT - - 2 N - - N N N - - - 1 2 - - - 59268 0
EEC 74 EEC_PRECOA C 1 0 Preco Ab. +Precio Ab.? Open Price Preco aberto (FOB+FRETE) Precio abierto(FOB+FLETE) Open Price (FOB+FREIGHT) @! PERTENCE("12") .And. AE100PrecoI(.T.) .And. AE100CRIT("EEC_PRECOA") x x x x x xx x x xx x x x x x x x "1" - 1 x xx x - - - N - - - - 1=Sim;2=Nao 1=Si;2=No 1=Yes;2=No - lALTERA - - 2 N - - N N N - - - 1 2 - - - 59269 0
EEC 75 EEC_EMBAFI C 20 0 Volume Volumen Volume Embalagem final Embalaje final Final Packing @! (Vazio().Or.EXISTCPO("EE5")) .AND. AE100CRIT("EEC_EMBAFI") x x x x x xx x x xx x x x x x x x - EE5 1 x x x - S - N - - - - - - - - lALTERA - - 3 N - - N N N - - - 1 2 - - - 59270 0
EEC 76 EEC_CALCEM C 1 0 Calc.Embalag Calc.Embalaj Packing Cal. Tipo de calculo da embala Tipo de calculo de embal. Packing Calcul. Type @! NaoVazio() .And. Pertence("12") x x x x x xx x x xx x x x x x x x IF(inclui,"1",M->EEC_CALCEM) - 1 x xxx - - - N - - - - 1=Volume;2=Quantidade 1=Volumen;2=Cantidad 1=Volume;2=Quantity - lALTERA - - 3 N - - N N N - - - 1 1 - - - 59271 0
EEC 77 EEC_CUBAGE N 15 4 Cubagem Cubaje Capacity Cubagem Cubaje Capacity @E 9,999,999,999.9999 - x x x x x xx x x xx x x x x x x x AP100CUBAGEM(.F.,"Q") - 1 xxxx x - - - N - - - - - - - - lALTERA - - 3 N - - N N N - - - 1 2 - - - 59272 0
EEC 78 EEC_PACKAG C 60 0 Package Package Package Descricao Package Descripcion Package Package Description @! - x x x x xx x x xx x x x x x x x - - 1 x x x - - - N - - - - - - - - lALTERA - - 3 N - - N N N - - - 1 2 - - - 59273 0
EEC 79 EEC_CONFEC C 60 0 Confeccionar Confeccionar Make Confeccionar Confeccionar Make @! - x x x x xx x x xx x x x x x x x - - 1 x x x - - - N - - - - - - - - lALTERA - - 3 N - - N N N - - - 1 2 - - - 59274 0
EEC 80 EEC_ONTHEP C 20 0 On the Pack. On the Pack. On the Pack. On the Packages On the Packages On the Packages @! - x x x x xx x x xx x x x x x x x - - 1 x xx x - - - N - - - - - - - - lALTERA - - 3 N - - N N N - - - 1 2 - - - 59275 0
EEC 81 EEC_QUANTI C 20 0 Quantity Quantity Quantity Quantity Quantity Quantity @! - x x x x xx x x xx x x x x x x x - - 1 x xx x - - - N - - - - - - - - lALTERA - - 3 N - - N N N - - - 1 2 - - - 59276 0
EEC 82 EEC_UNIT C 20 0 Unit Unit Unit. Unit Unit Unit @! - x x x x xx x x xx x x x x x x x - - 1 x xx x - - - N - - - - - - - - lALTERA - - 3 N - - N N N - - - 1 2 - - - 59277 0
EEC 83 EEC_NETWGT C 15 0 Net Wgt Net Wgt Net Wgt Net Weight Net Weight Net Weight @! - x x x x xx x x xx x x x x x x x - - 1 x xx x - - - N - - - - - - - - lALTERA - - 3 N - - N N N - - - 1 2 - - - 59278 0
EEC 84 EEC_GROSSW C 15 0 Gross Wgt Gross Wgt Gross Wgt Gross Weight Gross Weight Gross Weight @! - x x x x xx x x xx x x x x x x x - - 1 x xx x - - - N - - - - - - - - lALTERA - - 3 N - - N N N - - - 1 2 - - - 59279 0
EEC 85 EEC_IDIOMA C 25 0 Idioma Doc. Idioma Doc. Doc. Lang. Idioma documentos Idioma documentos Ducument Language @! NaoVazio().AND.EECDSIDIOMA("M->EEC_IDIOMA") x x x x x xx x x xx x x x x x x x - ID 1 x xx - S - N - - - - - - - - lALTERA - - 1 N - - N N N - - - 1 1 - - - 59280 0
EEC 86 EEC_LC_NUM C 20 0 No. L/C Num. L/C License Nr. No. L/C Num. L/C License Number @! (VAZIO() .OR. EXISTCPO("EEL",M->EEC_LC_NUM)) .And. AE100CRIT("EEC_LC_NUM") x x x x x xx x x xx x x x x x x x - EEL 1 x xx x - - - N - - - - - - - - lALTERA - - 2 N - - N N N - - - 1 2 - - - 59281 0
EEC 87 EEC_SL_LC D 8 0 Dt.Sol.L/C Fch.Sol.L/C L/C Req.Dt. Data solicitacao L/C Fecha solicitud L/C L/C Requis. Date - - x x x x x xx x x xx x x x x x x x - - 1 xx x - - - N - - - - - - - - lALTERA - - 2 N - - N N N - - - 1 2 - - - 59282 0
EEC 88 EEC_SL_EME D 8 0 Dt.Sl.Emenda Fch.Sl.Enmie Amen.Req.Dt Data solicitacao emenda Fecha solicitud enmienda Amendment Req. Date - - x x x x x xx x x xx x x x x x x x - - 1 xx x - - - N - - - - - - - - lALTERA - - 2 N - - N N N - - - 1 2 - - - 59283 0
EEC 89 EEC_PGTANT C 1 0 Pagto Antec. Pago Antic. Paym. Advan. Pagamento antecipado Pago anticipado Payment in Advance @! PERTENCE("12") x x x x x xx x x xx x x x x x x x "2" - 1 x xx x - - - N - - - - 1=Sim;2=Nao 1=Si;2=No 1=Yes;2=No - lALTERA - - 2 N - - N N N - - - 1 2 - - - 59284 0
EEC 90 EEC_TIPCOM C 1 0 Tipo Comis. Tipo Comis. Comm. Type Tipo comissao Tipo comision Commission Type ! Pertence("123 ") x x x x x xx x x xx x x x x x x x "2" - 1 x xx x - - - N - - - - 1=A Remeter;2=Conta Grafica;3=Deduzir da Fatura 1=A Remitir;2=Cuenta Grafica;3=Deducir de Factura 1=To Be Sent;3=Graphic Account;4=Subtract from Invoice - LALTERA - - 2 N - - N N N - - - 1 2 - - - 59285 0
EEC 91 EEC_TIPCVL C 1 0 Tipo Vl.Com. Tipo Vl.Com. Com.Am.Type Tipo de Valor comissao Tipo de Valor comision Commission Amount Type ! Pertence("123 ") x x x x x xx x x xx x x x x x x x "1" - 1 x xx x - - - N - - - - 1=Percentual;2=Valor Fixo;3=Percentual por Item 1=Porcentaje;2=Valor Fijo;3=Porcentaje por Item 1=Percentage;2=Fixed Value;3=Percentage per item - lALTERA - - 2 N - - N N N - - - 1 2 - - - 59286 0
EEC 92 EEC_VALCOM N 14 2 Comissao Comision Commission Valor da Comissao Valor de la Comision Commision Amount @E 99,999,999,999.99 Positivo() .and. AE100Crit("EEC_VALCOM") x x x x x xx x x xx x x x x x x x - - 1 xxxx x - - - N - - - - - - - - AE100W("EEC_VALCOM") - - 2 N - - N N N - - - 1 2 - - - 59287 0
EEC 93 EEC_REFAGE C 20 0 Ref.Agente Ref. Agente Broker Ref. Referencia do Agente Referencia del Agente Broker Reference @! - x x x x x xx x x xx x x x x x x x - - 1 x xx x - - - N - - - - - - - - lALTERA - - 2 N - - N N N - - - 1 2 - - - 59288 0
EEC 94 EEC_INSCOD C 6 0 Instr.Neg. Instr. Neg. Neg. Instr. Instrumento Negociacao Instrumento Negociacion Negotiation Instrument @! VAZIO() .OR. EXISTCPO("EEE") .And. AE100Crit("EEC_INSCOD") x x x x xx x x xx x x x x x x x - EEE 1 x xx x - - - N - - - - - - - - lALTERA - - 5 N - - N N N - - - 1 2 - - - 59289 0
EEC 95 EEC_ENQCOX C 5 0 Enq.DrawBack Enc.DrawBack Drawb.Class. Cod. Enq. p/ R.E.DrawBack Cod. Enc. p/ R.E.DrawBack Clas.Cod.for Drawback R.E @! VAZIO().OR.EXISTCPO("EED") x x x x xx x x xx x x x x x x x - EED 1 x x x - - - N - - - - - - - - lALTERA - - 5 N - - N N N - - - 1 2 - - - 59290 0
EEC 96 EEC_ENQCOD C 5 0 Cod.Enquadra Cod.Encuadra Classif Code Codigo enquadramento Codigo encuadramiento Classification Code @! VAZIO().OR.EXISTCPO("EED") x x x x xx x x xx x x x x x x x "80000" EED 1 x xxx - - - N - - - - - - - - lALTERA - - 5 N - - N N N - - - 1 1 - - - 59291 0
EEC 97 EEC_ENQCO1 C 5 0 Cod.Enq.2 Cod.Enc.2 Clas. Code 2 Codigo enquadramento 2 Codigo encuadramiento 2 Classification Code 2 @! VAZIO().OR.EXISTCPO("EED").AND.AE100CRIT('EEC_ENQCO1') x x x x xx x x xx x x x x x x x - EED 1 x x x - - - N - - - - - - - - lALTERA.AND.!Empty(M->EEC_ENQCOD) - - 5 N - - N N N - - - 1 2 - - - 59292 0
EEC 98 EEC_ENQCO2 C 5 0 Cod.Enq.3 Cod.Enc.3 Clas. Code 3 Codigo enquadramento 3 Codigo encuadramiento 3 Classification Code 3 @! VAZIO().OR.EXISTCPO('EED').AND.AE100CRIT('EEC_ENQCO2') x x x x xx x x xx x x x x x x x - EED 1 x x x - - - N - - - - - - - - lALTERA.AND.!Empty(M->EEC_ENQCOD) - - 5 N - - N N N - - - 1 2 - - - 59293 0
EEC 99 EEC_ENQCO3 C 5 0 Cod.Enq.4 Cod.Enc.4 Clas. Code 4 Codigo enquadramento 4 Codigo encuadramiento 4 Classification Code 4 @! VAZIO().OR.EXISTCPO('EED').AND.AE100CRIT('EEC_ENQCO3') x x x x xx x x xx x x x x x x x - EED 1 x x x - - - N - - - - - - - - lALTERA.AND.!Empty(M->EEC_ENQCOD).AND.Empty(M->EEC_ENQCOX) - - 5 N - - N N N - - - 1 2 - - - 59294 0
EEC A0 EEC_ENQCO4 C 5 0 Cod.Enq.5 Cod.Enc.5 Clas. Code 5 Codigo enquadramento 5 Codigo encuadramiento 5 Classification Code 5 @! - x x x x x x x x x x x x x x x - EED 1 x xx x - - - N - - - - - - - - - - - 5 N - - N N N - - - 1 2 - - - 59295 0
EEC A1 EEC_ENQCO5 C 5 0 Cod.Enq.6 Cod.Enc.6 Clas. Code 6 Codigo enquadramento 6 Codigo encuadramiento 6 Classification Code 6 @! - x x x x x x x x x x x x x x x - EED 1 x xx x - - - N - - - - - - - - - - - 5 N - - N N N - - - 1 2 - - - 59296 0
EEC A2 EEC_DSCGEN C 6 0 Desc.Gen.Pr. Desc.Gen.Pr. Prod.Gen.Des Desc.Gen.Pr. Desc.Gen.Pr. Product General Desc. @! - x x x x x xx x x xx x x x x x x x - - 1 x xx x - - - N - - - - - - - - lALTERA - - - N - - N N N - - - 1 2 - - - 59297 0
EEC A3 EEC_GENERI M 60 0 Desc.Gen.Pr. Desc.Gen.Pr. Prod.Gen.Des Desc.Gen.Pr. Desc.Gen.Pr. Product General Desc. - - x x x x x xx x x xx x x x x x x x E_MSMM(EEC->EEC_DSCGEN,60) - 1 x xx x - - - N - V - - - - - - lALTERA - - 1 N - - N N N - - - 1 2 - - - 59298 0
EEC A4 EEC_CODOBP C 6 0 Cod.Mem.Ped. Cod.Mem.Ped. Mem.Not.Code Memo Obs para Emissao Memo Obs para Emision Memo Notes to Issue - - x x x x x xx x x xx x x x x x x x - - 1 x xx x - - - N - - - - - - - - lALTERA - - - N - - N N N - - - 1 2 - - - 59299 0
EEC A5 EEC_OBSPED M 60 0 Obs.Doctos Obs. Docs. Doc. Notes Obs.Doctos Obs.Documentos Document Notes - - x x x x x xx x x xx x x x x x x x E_MSMM(EEC->EEC_CODOBP,60) - 1 x xx x - - - N - V - - - - - - lALTERA - - 6 N - - N N N - - - 1 2 - - - 59300 0
EEC A6 EEC_OBS M 60 0 Observacao Observacion Note Observacao Observacion Note - - x x x x x xx x x xx x x x x x x x E_MSMM(EEC->EEC_CODMEM,60) - 1 x xx x - - - N - V - - - - - - - - - 1 N - - N N N - - - 1 2 - - - 59301 0
EEC A7 EEC_CODMEM C 6 0 Codigo Memo Codigo Memo Memo Code Codigo do Campo Memo Codigo del Campo Memo Memo Field Code - - x x x x x xx x x xx x x x x x x x - - 1 x xx x - - - N - - - - - - - - - - - - N - - N N N - - - 1 2 - - - 59302 0
EEC A8 EEC_PESLIQ N 12 4 Peso Liquid. Peso Neto Net Weight Peso liquido total Peso neto total Total Net Weight @E 9,999,999.9999 - x x x x x xx x x xx x x x x x x x - - 1 xxxx x - - - N V - - - - - - - lALTERA - - - N - - N N N - - - 1 2 - - - 59303 0
EEC A9 EEC_PESBRU N 12 4 Peso Bruto Peso Bruto Gross Weight Peso bruto total Peso bruto total Total Gross Weight @E 9,999,999.9999 - x x x x x xx x x xx x x x x x x x - - 1 xxxx x - - - N V - - - - - - - lALTERA - - - N - - N N N - - - 1 2 - - - 59304 0
EEC B0 EEC_TOTPED N 16 2 Total Pedido Total Pedido Order Total Vlr. Total do pedido Vlr. Total del pedido Order's Total Amount @E 9,999,999,999,999.99 - x x x x x xxx x x xx x x x x x x x - - 1 xxxx x - - - N V - - - - - - - lALTERA - - - N - - N N N - - - 1 2 - - - 59305 0
EEC B1 EEC_TOTITE N 16 2 Total Itens Total Items Items Total Total de itens Total de itemes Items Totla @E 9,999,999,999,999.99 - x x x x x xx x x xx x x x x x x x - - 1 xxxx x - - - N V - - - - - - - lALTERA - - - N - - N N N - - - 1 2 - - - 59306 0
EEC B2 EEC_REGVEN C 9 0 Reg.Venda Reg.Venta Sales Reg. Reg.Venda Reg.Venta Sales Registration @! - x x x x xx x x xx x x x x x x x - - 1 x x x - - - N - - - - - - - - lALTERA - - 5 N - - N N N - - - 1 2 - - - 59307 0
EEC B3 EEC_OPCRED C 9 0 Op.Credito Op. Credito Credit Op. Op.Credito Op.Credito Credit Option @! - x x x x xx x x xx x x x x x x x - - 1 x x x - - - N - - - - - - - - lALTERA - - 5 N - - N N N - - - 1 2 - - - 59308 0
EEC B4 EEC_LIMOPE D 8 0 Limite Oper. Limite Oper. Oper. Limit Limite Operacao Limite Operacion Operational Limit - - x x x x xx x x xx x x x x x x x - - 1 xx x - - - N - - - - - - - - lALTERA - - 5 N - - N N N - - - 1 2 - - - 59309 0
EEC B5 EEC_GEDERE C 13 0 GE/DE/RE/Vn. GE/DE/RE/Vn. GE/DE/RE/Rl. GE/DE/RE/Vinculado GE/DE/RE/Vinculado Related GE/DE/RE @! - x x x x xx x x xx x x x x x x x - - 1 x x x - - - N - - - - - - - - lALTERA - - 5 N - - N N N - - - 1 2 - - - 59310 0
EEC B6 EEC_GDRPRO C 15 0 Num.Processo Num. Proceso Process Nr. Num.Processo GE/DE/RE/Vn. Num. Proceso GE/DE/RE/Vn. GE/DE/RE/Rl.Process Nr. @! - x x x x xx x x xx x x x x x x x - - 1 x x x - - - N - - - - - - - - lALTERA - - 5 N - - N N N - - - 1 2 - - - 59311 0
EEC B7 EEC_DIRIVN C 15 0 DI/RI/Vinc. DI/RI/Vinc. DI/RI/Relat. DI/RI/Vinculado DI/RI/Vinculado DI/RI/Related @! - x x x x xx x x xx x x x x x x x - - 1 x xx x - - - N - - - - - - - - lALTERA - - 5 N - - N N N - - - 1 2 - - - 59312 0
EEC B8 EEC_SECEX C 5 0 Ag. SECEX Ag. SECEX SECEX SECEX SECEX SECEX @! ExistCPO("SJ9",M->EEC_SECEX) x x x x xx x x xx x x x x x x x - SJ9 1 x xx x - - - N - - - - - - - - lALTERA - - 5 N - - N N N - - - 1 2 - - - 59313 0
EEC B9 EEC_MRGNSC N 15 7 % Marg.N.Sac % Marg.N.Ret %Marg.N.Draw % Margem Nao Sacada % Margen No Retirada % Margin not drawn @E 9,999,999.9999999 POSITIVO() x x x x x xx x x xx x x x x x x x - - 1 xxxx x - - - N - - - - - - - - lALTERA - - 5 N - - N N N - - - 1 2 - - - 59314 0
EEC C0 EEC_VLMNSC N 15 2 VL.M.N.Sac. VL.M.N.Sac. Not Drawn Am Valor da Margen Nao Sacad Valor de Margen No Sacada Margin Value Not Drawn @E 999,999,999,999.99 POSITIVO().AND.AE100CRIT("EEC_VLMNSC") x x x x x xx x x xx x x x x x x x - - 1 xxxx x - - - N - - - - - - - - AE100W("EEC_VLMNSC") - - 5 N - - N N N - - - 1 2 - - - 59315 0
EEC C1 EEC_ANTECI N 15 2 VL. Antecip. VL. Anticip. Am. in Adv. Valor Antecipado Valor Anticipado Amount in Advance @E 999,999,999,999.99 POSITIVO().AND.AE100CRIT("EEC_ANTECI") x x x x x xx x x xx x x x x x x x - - 1 xxxx x - - - N - - - - - - - - AE100W("EEC_ANTECI") - - 5 N - - N N N - - - 1 2 - - - 59316 0
EEC C2 EEC_VISTA N 15 2 VL. a Vista VL. Contado Dow.Pay.Am. Vl.A Vista Vl.Al Contado Down Payment Amount @E 999,999,999,999.99 POSITIVO() x x x x x xx x x xx x x x x x x x - - 1 xxxx x - - - N - - - - - - - - lALTERA - - 5 N - - N N N - - - 1 2 - - - 59317 0
EEC C3 EEC_NPARC N 3 0 Nr. Parcelas Nro. Cuotas Installm.No. Nr. Parcelas Numero Cuotas Installment Number 999 NAOVAZIO().AND.POSITIVO().AND.AE100CRIT("EEC_NPARC") x x x x x xx x x xx x x x x x x x 1 - 1 xxxx x - - - N - - - - - - - - lALTERA - - 5 N - - N N N - - - 1 2 - - - 59318 0
EEC C4 EEC_PARCEL N 15 2 VL. Parcela VL. Cuota Instal.Value Vl.Parcela Vl.Cuota Installment Value @E 999,999,999,999.99 POSITIVO().AND.AE100CRIT("EEC_PARCEL") x x x x x xx x x xx x x x x x x x - - 1 xxxx x - - - N - - - - - - - - AE100W("EEC_PARCEL") - - 5 N - - N N N - - - 1 2 - - - 59319 0
EEC C5 EEC_VLCONS N 15 2 VL. Consig. VL. Consig. Consignm.Vl. Valor em Consignacao Valor en Consignacion Value on Consignment @E 999,999,999,999.99 POSITIVO() x x x x x xx x x xx x x x x x x x - - 1 xxxx x - - - N - - - - - - - - lALTERA - - 5 N - - N N N - - - 1 2 - - - 59320 0
EEC C6 EEC_COBCAM C 1 0 Cob.Cambial +Cob.Cambia? Exchan.Cov. Cobertura Cambial Cobertura Cambiaria Exchange Coverage @! PERTENCE("12") x x x x xxx x x xx x x x x x x x "1" - 1 x x x - - - N - - - - 1=Sim;2=Nao 1=Si;2=No 1=Yes;2=No - lALTERA - - 5 N - - N N N - - - 1 2 - - - 59321 0
EEC C7 EEC_FINCIA N 15 2 Vl.Financ.RC Vl.Financ.RC Financ. Amt Vl.Financiamento RC Vl.Financiacion RC Finance Value @E 999,999,999,999.99 - x x x x x xx x x xx x x x x x x x - - 1 xxxx x - - - N - - - - - - - - lALTERA - - 5 N - - N N N - - - 1 2 - - - 59322 0
EEC C8 EEC_DECPES N 2 0 Dec.Peso Dec. Peso Weight Desc. Dec.Peso Dec.Peso Weight Description 99 - x x x x x xx x x xx x x x x x x x 2 - 1 xxxx x - - - N - - - - - - - - lALTERA - - 8 N - - N N N - - - 1 2 - - - 59323 0
EEC C9 EEC_DECQTD N 2 0 Dec.Qtde Dec.Ctd. Qtty Desc. Dec.Qtde Dec.Ctd. Quantity Description 99 - x x x x x xx x x xx x x x x x x x 2 - 1 xxxx x - - - N - - - - - - - - lALTERA - - 8 N - - N N N - - - 1 2 - - - 59324 0
EEC D0 EEC_DECPRC N 2 0 Dec.Preco Dec.Precio Price Desc. Dec.Preco Dec.Precio Price Description 99 - x x x x x xx x x xx x x x x x x x 2 - 1 xxxx x - - - N - - - - - - - - lALTERA - - 8 N - - N N N - - - 1 2 - - - 59325 0
EEC D1 EEC_BRUEMB C 1 0 Ps.Br.XEmb. Ps.Br.XEmb Pckng.Weight Usar peso embalagem Usar peso embalaje Use Packing Weight @! PERTENCE("12") x x x x xx x x xx x x x x x x x "1" - 1 x x x - - - N - - - - 1=Sim;2=Nao 1=Si;2=No 1=Yes;2=No - lALTERA - - 8 N - - N N N - - - 1 2 - - - 59326 0
EEC D2 EEC_CODAGT C 6 0 Tran.Interno Tran.Interno Int. Carrier Transportadora Interna Transportadora Interna Internal Carrier @! Vazio().And.ExistCpo("SY5") x x x x x xx x x xx x x x x x x x - Y5D 1 x xxx - S - N - - - - - - - - lALTERA - 001 - N - - N N N - - - 1 1 - - - 59327 0
EEC D3 EEC_DSCAGT C 40 0 Razao Social Razon Social Company Name Razao Social Transportad Razon Social Transportad. Carrier Trade Name @! - x x x x x xx x x xx x x x x x x x E_Field("EEC_CODAGT","Y5_NOME") - 1 x xxx - - - N V V - - - - - - - - - - N - - N N N - - - 1 1 - - - 59328 0
EEC D4 EEC_DTFCPR D 8 0 Fech.Praca Fech.Plaza Locat.Clos. Data Fech.Praca Fecha Cierre Plaza Location Closing Date - - x x x x xx x x xx x x x x x x x - - 1 xx x - - - N - - - - - - - - lALTERA - - 4 N - - N N N - - - 1 2 - - - 59329 0
EEC D5 EEC_ETA D 8 0 E.T.A. E.T.A. E.T.A. E.T.A. E.T.A. E.T.A. - - x x x x xx x x xx x x x x x x x - - 1 xx x - - - N - - - - - - - - lALTERA - - 4 N - - N N N - - - 1 2 - - - 59330 0
EEC D6 EEC_TRSTIM N 10 0 Transit Time Transit Time Transit Time Transit Time Transit Time Transit Time @e 9999999999 POSITIVO().AND.AE100CRIT("EEC_TRSTIM") x x x x xx x x xx x x x x x x x - - 1 xxxx x - - - N - - - - - - - - lALTERA - - 4 N - - N N N - - - 1 2 - - - 59331 0
EEC D7 EEC_ETD D 8 0 E.T.D. E.T.D. E.T.D. E.T.D. E.T.D. E.T.D. - AE100CRIT("EEC_ETD") x x x x xx x x xx x x x x x x x - - 1 xx x - - - N - - - - - - - - lALTERA - - 4 N - - N N N - - - 1 2 - - - 59332 0
EEC D8 EEC_ETADES D 8 0 E.T.A. Dest. E.T.A. Dest. Target E.T.A E.T.A. Destino E.T.A. Destino Target E.T.A - AE100CRIT("EEC_ETADES") x x x x xx x x xx x x x x x x x - - 1 xx x - - - N - - - - - - - - lALTERA - - 4 N - - N N N - - - 1 2 - - - 59333 0
EEC D9 EEC_EMBARC C 25 0 Embarcacao Embarcacion Vessel Codigo da Embarcacao Codigo de Embarcacion Vessel Code @! Vazio() .Or. Ae100Crit("EEC_EMBARC") x x x x x xx x x xx x x x x x x x - E6_ 1 x xx x - S - N - - - - - - - - lALTERA - - 4 N - - N N N - - - 1 2 - - - 59334 0
EEC E0 EEC_VIAGEM C 20 0 Nr.Voo/Viag. Nro.Vuel/Via Flig.No./Tr. Nr. Voo/Viagem Nro. Vuelo/Viaje Flight No./Trip @! Vazio().Or.Ae100Crit('EEC_VIAGEM') x x x x xx x x xx x x x x x x x - EE6001 1 x xx x - - - N - - - - - - - - lALTERA - - 4 N - - N N N - - - 1 2 - - - 59335 0
EEC E1 EEC_NRINVO C 20 0 Nr.Invoice Num. Invoice Invoice Nr. Nr.Invoice Num. Invoice Invoice Number @! AE100Crit("EEC_NRINVO") x x x x x xx x x xx x x x x x x x M->EEC_PREEMB - 1 x xx x - - - N - - - - - - - - lALTERA - - 9 N - - N N N - - - 1 2 - - - 59336 0
EEC E2 EEC_DTINVO D 8 0 Dt.Invoice Fch.Invoice Invoice Date Dt.Invoice Fecha Invoice Invoice Date - - x x x x x xx x x xx x x x x x x x dDATABASE - 1 xx x - - - N - - - - - - - - lALTERA - - 9 N - - N N N - - - 1 2 - - - 59337 0
EEC E3 EEC_DTSLNF D 8 0 Sol.N.F. Sol.Fact. Invoice Req. Solecitacao de N.F. Solicitud de Factura Invoice Request - - x x x x xx x x xx x x x x x x x - - 1 xx x - - - N - - - - - - - - lALTERA - - 9 N - - N N N - - - 1 2 - - - 59338 0
EEC E4 EEC_DTSDFB D 8 0 Saida Fabric Salid.Fabr. Fac.Outflow Saida Fabrica Salida Fabrica Factory Outflow Date - - x x x x xx x x xx x x x x x x x - - 1 xx x - - - N - - - - - - - - lALTERA - - 9 N - - N N N - - - 1 2 - - - 59339 0
EEC E5 EEC_VLNFC N 10 0 Seq.Ord. Sec. Ord. Ord.Seq. Sequencial para Ordenacao Secuencial de Ordenacion Sequence for Ordering @E 9,999,999,999 POSITIVO() x x x x x xx x x xx x x x x x x x - - 1 xxxx x - - - N - - - - - - - - lALTERA - - 9 N - - N N N - - - 1 2 - - - 59340 0
EEC E6 EEC_DECAM C 1 0 DECAM DECAM DECAM DECAM DECAM DECAM @! PERTENCE("12") x x x x xx x x xx x x x x x x x "2" - 1 x xx x - - - N - - - - 1=Sim;2=Nao 1=Si;2=No 1=Yes;2=No - LSLCAMB - - - N - - N N N - - - 1 2 - - - 59341 0
EEC E7 EEC_NRCTOR C 20 0 Cert. Origem Cert. Origen Sorc.Certf. Nr.Certificado Origem Nro. Certificado Origen Source Certificate No. @! - x x x x xx x x xx x x x x x x x - - 1 x xx x - - - N - - - - - - - - lALTERA - - 6 N - - N N N - - - 1 2 - - - 59342 0
EEC E8 EEC_NRCTFA C 20 0 Form A Form A Form A Nr.Certificado FORM A Num. Certificado FORM A FORM A Certificate No @! - x x x x xx x x xx x x x x x x x - - 1 x xx x - - - N - - - - - - - - lALTERA - - 6 N - - N N N - - - 1 2 - - - 59343 0
EEC E9 EEC_NRCONH C 20 0 Nr.Conhecim. Nr.Fact.Flet Freight Note Nr.Conhecimento Num. Factura de Flete Freight Note Number @! - x x x x xx x x xx x x x x x x x - - 1 x xx x - - - N - - - - - - - - lALTERA - - 6 N - - N N N - - - 1 2 - - - 59344 0
EEC F0 EEC_MAWB C 20 0 Master Master Master Master AWB Master AWB AWB Master @! - x x x x xx x x xx x x x x x x x - - 1 x xx x - - - N - - - - - - - - lALTERA - - 6 N - - N N N - - - 1 2 - - - 59345 0
EEC F1 EEC_DTCONH D 8 0 Dt.Conhec. Fch.Fac.Fle. Way.Date Data Conhecimento Fecha Fact. de Flete Waybill Date - AE100CRIT("EEC_DTCONH") x x x x xx x x xx x x x x x x x - - 1 xx x - - - N - - - - - - - - lALTERA - - 6 N - - N N N - - - 1 2 - - - 59346 0
EEC F2 EEC_DTEMBA D 8 0 Dt.Embarque Fch.Embarque Ship. Date Dt.Embarque Fecha Embarque Shipment Date - AE100CRIT("EEC_DTEMBA") x x x x x xxx x x xx x x x x x x x - - 1 xx x - S - N - - - - - - - - AE100W("EEC_DTEMBA") - - 4 N - - N N N - - - 1 2 - - - 59347 0
EEC F3 EEC_TOTVOL N 10 0 Qtde Volume Ctd.Bultos Vol. Qtty. Quantidade de Volumes Cantidad de Bultos Volume Quantity @E 9,999,999,999 - x x x x x x x x x x x x x x x - - 1 xxxx x - - - N - - - - - - - - - - - 6 N - - N N N - - - 1 2 - - - 59348 0
EEC F4 EEC_DTSLPL D 8 0 Sol.Paletiz. Sol. Paletiz Pallet. Req. Solecitacao de Paletiza Solicitud de Paletizacion Palletization Requisition - - x x x x xx x x xx x x x x x x x - - 1 xx x - - - N - - - - - - - - lALTERA - - 6 N - - N N N - - - 1 2 - - - 59349 0
EEC F5 EEC_DTSLIN D 8 0 Sol.Inspecao Sol.Inspecc. Inspec.Req. Solicitacao de Inspecao Solicitud de Inspeccion Inspection Requisiton - - x x x x xx x x xx x x x x x x x - - 1 xx x - - - N - - - - - - - - lALTERA - - 6 N - - N N N - - - 1 2 - - - 59350 0
EEC F6 EEC_TIPO C 1 0 Tipo Emb. Tipo Emb. ShipmentType Tipo do Embarque Tipo de Embarque Shipment type @! - x x x x xx x x x x x x x x x x - - 1 x - - - N A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 59351 0
EEC F7 EEC_DTREC D 8 0 Dt. Receb. Fch. Recep. Receipt Date Data de Recebimento Fecha de Recepcion Receipt Date - Ae100Crit("EEC_DTREC") x x x x xx x x x x x x x x x x if(TYpe('M->EEC_DTREC')=='D',M->EEC_DTREC,CTOD(' / / ')) - 1 x - S - N A V - - - - - - AE100W("EEC_DTEMBA") - - 4 N - - N N N - - - 1 2 - - - 59352 0
EEC F8 EEC_DTPALE D 8 0 Dt.Paletiz. Fch.Paletiz. Pallet. Date Dt.Paletiz. Fecha Paletizacion Palletization Date - - x x x x xx x x xx x x x x x x x - - 1 xx x - - - N - - - - - - - - lALTERA - - 6 N - - N N N - - - 1 2 - - - 59353 0
EEC F9 EEC_DTINSP D 8 0 Dt.Inspecao Fc.Inspecc. Inspec. Date Dt.Inspecao Fecha Inspeccion Inspection Date - - x x x x xx x x xx x x x x x x x - - 1 xx x - - - N - - - - - - - - lALTERA - - 6 N - - N N N - - - 1 2 - - - 59354 0
EEC G0 EEC_ARM C 6 0 Cod. Arm. Cod. Alm. Wareh. code Codigo do Armazem Codigo del Almacen Warehouse code @! Ae108VldConsig("EEC_ARM") x x x x x x x x x x x x x x x x - AVE001 1 x - S - N A R - - - - - - - - 001 4 N - - N N N - - - 1 2 - - - 59355 0
EEC G1 EEC_ARLOJA C 2 0 Loja Arm. Tda Almac Wareh. Store Loja do Armazem Tienda de Almacen Warehouse Store @! Ae108VldConsig("EEC_ARLOJA") x x x x x x x x x x x x x x x x - - 1 x - S - N A R - - - - - - - - 002 4 N - - N N N - - - 1 2 - - - 59356 0
EEC G2 EEC_ARMDES C 50 0 Armazem Almacen Warehouse Nome do Armazem Nombre del Almacen Warehouse name @! - x x x x x x x x x x x x x x x x - - 1 x x - - - N A R - - - - - - - - 175 4 N - - N N N - - - 1 2 - - - 59357 0
EEC G3 EEC_NRINSP C 20 0 Nr.Inspecao Nro.Inspecc. Inspect. No. Nr.Inspecao Nro. Inspeccion Inspection Number @! - x x x x xx x x xx x x x x x x x - - 1 x xx x - - - N - - - - - - - - lALTERA - - 6 N - - N N N - - - 1 2 - - - 59358 0
EEC G4 EEC_NRCTSG C 20 0 Cert. Seguro Cert. Seguro Insur. Cert. Nr.Certificado Seguro Nro. Certificado Seguro Insurance Certificate No @! AE100CRIT("EEC_NRCTSG") x x x x xx x x xx x x x x x x x - - 1 x xx x - - - N - - - - - - - - lALTERA - - 6 N - - N N N - - - 1 2 - - - 59359 0
EEC G5 EEC_NRAVSG C 20 0 Nr.Av.Seguro Nr.Av.Seguro Insur.Ann.No Nr.Averbacao Seguro Nro.Declarac.Regist.Segur Insurance Annotation No. @! AE100CRIT("EEC_NRAVSG") x x x x xx x x xx x x x x x x x - - 1 x xx x - - - N - - - - - - - - AE100W("EEC_NRAVSG") - - 6 N - - N N N - - - 1 2 - - - 59360 0
EEC G6 EEC_DTSEGU D 8 0 Data Seguro Fecha Seguro Insur. Date Data Seguro Fecha Seguro Insurance Date - - x x x x xx x x xx x x x x x x x - - 1 xx x - - - N - - - - - - - - lALTERA - - 6 N - - N N N - - - 1 2 - - - 59361 0
EEC G7 EEC_APLCSG C 15 0 Apolice Seg. Poliza Seg. Insur.Polic. Apolice Seg. Poliza Seg. Insurance Policy @! - x x x x xx x x xx x x x x x x x - - 1 x xx x - - - N - - - - - - - - lALTERA - - 6 N - - N N N - - - 1 2 - - - 59362 0
EEC G8 EEC_TRSDOC N 10 0 T.Time Doc. T.Time Doc. Tr.Time Doc. Transit Time Documentos Transit Time Documentos Transit Time Documents @e 9999999999 POSITIVO().AND.AE100CRIT("EEC_TRSDOC") x x x x xx x x xx x x x x x x x - - 1 xxxx x - - - N - - - - - - - - lALTERA - - 6 N - - N N N - - - 1 2 - - - 59363 0
EEC G9 EEC_DTLMDC D 8 0 Dt.Lim.Doc. Fch.Lim.Doc. Doc. Issue Dt.Limite Envio Document. Fch.Limite Envio Document Document Issue Deadline - AE100CRIT("EEC_DTLMDC") x x x x xx x x xx x x x x x x x - - 1 xx x - - - N - - - - - - - - lALTERA - - 6 N - - N N N - - - 1 2 - - - 59364 0
EEC H0 EEC_PEDFAT C 6 0 Ped.de Venda Ped.de Venta Sales Ord. Numero do Pedido SigaFat Numero Pedido SigaFat SigaFat Order Number @X - x x x x x xx x x xx x x x x x x x - - 1 x xx x - - - N V R - - - - - - - - - 1 N - - N N N - - - 1 2 - - - 59365 0
EEC H1 EEC_IN86 C 1 0 Flag IN86 Flag IN86 Flag IN86 Flag IN86 Flag IN86 Flag IN86 ! - x x x x x x x x x x x x x x x x - - 1 x xx x - - - - V - - - - - - - - - - - N - - N N N - - - 1 2 - - - 59366 0
EEC H2 EEC_DTDCIM D 8 0 Dt.Dct.Imp. Fch.Dct.Imp. Imp.Doc.Dt. Dt.Doctos p/Importador Fch.Doctos p/Importador Importer Documents Date - - x x x x xx x x xx x x x x x x x - - 1 xx x - - - N - - - - - - - - lALTERA - - - N - - N N N - - - 1 2 - - - 59367 0
EEC H3 EEC_DTENDC D 8 0 Dt.Envio Doc Fch.Envio Do Doc Issue Dt Dt.Envio documentos Fecha Envio documentos Documents Issue Date - - x x x x xx x x xx x x x x x x x - - 1 xx x - - - N - - - - - - - - lALTERA - - 6 N - - N N N - - - 1 2 - - - 59368 0
EEC H4 EEC_BCDCRF C 20 0 Ref.Bco.Doc. Ref.Bco.Doc. Ref.Doc.Bank Banco Documentos Refer. Banco Documentos Refer. Refer. Documents Bank @! - x x x x xx x x xx x x x x x x x - - 1 x xx x - - - N - - - - - - - - lALTERA - - - N - - N N N - - - 1 2 - - - 59369 0
EEC H5 EEC_BCEXRF C 20 0 Ref.Bco.Ext. Ref.Bco.Ext. Ref.Ext.Bank Banco Exterior Refer. Banco Exterior Refer. Refer. External Bank @! - x x x x xx x x xx x x x x x x x - - 1 x xx x - - - N - - - - - - - - lALTERA - - 6 N - - N N N - - - 1 2 - - - 59370 0
EEC H6 EEC_COURIE C 30 0 Courier Imp. Courier Imp. Imp. Courier Courier Imp. Courier Imp. Import Courier @! - x x x x xx x x xx x x x x x x x - - 1 x x x - - - N - - - - - - - - lALTERA - - 6 N - - N N N - - - 1 2 - - - 59371 0
EEC H7 EEC_COURI2 C 30 0 Courier Bco. Courier Bco. Bank Courier Courier Bco. Courier Bco. Bank Courier @! - x x x x xx x x xx x x x x x x x - - 1 x x x - - - N - - - - - - - - lALTERA - - 6 N - - N N N - - - 1 2 - - - 59372 0
EEC H8 EEC_FATURA D 8 0 Dt.Faturam. Fch.Facturac Invoic. Date Data de Faturamento Fecha de Facturacion Invoicing Date - - x x x x xx x x xx x x x x x x x - - 1 xx x - - - N - - - - - - - - - - - - N - - N N N - - - 1 2 - - - 59373 0
EEC H9 EEC_LIBSIS D 8 0 Dt.Lib.Sis. Fch.Aprob.Si Siscomex Dt. Dt de Liberacao SISCOMEX Fch Aprobacion SISCOMEX SISCOMEX Release Date - AE100CRIT("EEC_LIBSIS") x x x x xx x x xx x x x x x x x - - 1 xx x - S - N - - - - - - - - lALTERA - - 5 N - - N N N - - - 1 2 - - - 59374 0
EEC I0 EEC_DSCCOM C 100 0 Comissao Comision Commission Resumo da Comissao Resumen de Comision Commission Summary - - x x x x x x x x x x x x x x x x EECResCom() - 1 x xx x - - - N V V - - - - - - - - - 2 N - - N N N - - - 1 2 - - - 59375 0
EEC I1 EEC_STASIS C 1 0 Status Sis. Estat. Sis. SISCOMEX St. Status SISCOMEX Estatus SISCOMEX SISCOMEX Status @! - x x x x xx x x xx x x x x x x x - - 1 x x x - - - N - - - - - - - - lALTERA - - - N - - N N N - - - 1 2 - - - 59376 0
EEC I2 EEC_PEDDES C 6 0 Ped.NF.Desp. Ped.Fac.Gast Exp.Inv.Ord. Ped.NF.Despesas Pedido Factura Gastos Expenses Inv.Order @X - x x x x x x x x x x x x x x x x - - 1 x xx x - - - N V - - - - - - - - - - - N - - N N N - - - 1 2 - - - 59377 0
EEC I3 EEC_PTINT C 3 0 Porto Interm Puerto Inter Midway Port Porto Interm. Puerto Intermed. Midway Port @! Vazio() .OR. ExistCpo("SY9",M->EEC_PTINT,2) x x x x x x x x x x x x x x x - - 1 - - - - - - - - - - - - - - - - 4 N - - N N N - - - 1 2 - - - 59378 0
EEC I4 EEC_PEDEMB C 6 0 Ped.NF.Emb. Ped.Fac.Emb. Shp.Inv.Ord. Ped.NF.Embarque Pedido Factura Embarque Shipment Inv.Order @X - x x x x x x x x x x x x x x x x - - 1 x xx x - - - N V - - - - - - - - - - - N - - N N N - - - 1 2 - - - 59379 0
EEC I5 EEC_DTESTU D 8 0 Dt.Estufagem Fch.Estufado Wareh. date Data Estufagem Fecha Estufado Warehousing date - - x x x x xx x x x x x x x x x x - - 1 x - - - N A R - - - - - - LALTERA - - 4 N - - N N N - - - 1 2 - - - 59380 0
EEC I6 EEC_TSISC C 1 0 Tp.Siscomex Tp.Siscomex Siscomex Tp. Tipo Siscomex Tipo Siscomex Siscomex Type - AE100CRIT("EEC_TSISC") x x x x x x x x x x x x x x x - - 1 - - - - N A R - - - - - - lAltera - - 5 N - - N N N - - - 1 2 - - - 59381 0
EEC I7 EEC_DTEFE D 8 0 Dt. Efetiv. Fch. Concr. Confirm.Date Data de efetivação Fecha de concrecion Confirmation date - Ae109Valid() x x x x x x x x x x x x x x x M->EEC_DTEMBA - 1 - - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 59382 0
EEC I8 EEC_MODEST C 1 0 Mod. Estuf. Mod. Estuf. Wareh. mod. Modal. Estuf. Modal. Estuf. Warehousing modal. @! Vazio() .or. Pertence("12") x x x x xx x x x x x x x x x x - - 1 x - - - N A R - - 1=FCL-Responsabilidade do Exportador; 2=LCL-Responsabilidade do Armador 1=FCL-Responsabilidad del Exportador; 2=LCL-Responsabilidad del Armador 1=FCL-Exporter's liability; 2=LCL-Shipyard's liability - LALTERA - - 4 N - - N N N - - - 1 2 - - - 59383 0
EEC I9 EEC_PERC N 5 2 %OffShore %OffShore %OffShore % OffShore Precio Negociado % OffShore @E 99.99 Positivo() x x x x x x x x x x x x x x x x - - 1 xxxx x - - - N - - - - - - - - M->EEC_INTERM="1" - - 7 N - - N N N - - - 1 2 - - - 59384 0
EEC J0 EEC_UNIDAD C 2 0 Unid.Medida Unid. Medida Unit Measure Unidade de Medida Unidad de Medida Unit of Measure - ExistCpo("SAH") x x x x x x x x x x x x x x x x - SAH 1 x xx x - S - N - - - - - - - - lALTERA - 122 8 N - - N N N - - - 1 2 - - - 59385 0
EEC J1 EEC_TIPEST C 1 0 Tipo Estuf. Tipo Estuf. Wareh. type Tipo Estufagem Tipo Estufado Warehousing type ! Vazio() .or. Pertence("12") x x x x xx x x x x x x x x x x - - 1 x - - - N A R - - 1=Granel; 2=Sacaria 1=A Granel; 2=En Sacos 1=Bulk; 2=Sack - LALTERA - - 4 N - - N N N - - - 1 2 - - - 59386 0
EEC J2 EEC_OICMCC C 6 0 Cod.Mrc. OIC Cod.Reg. OIC OIC mrk code Código da Marcação OIC Codigo de Registro OIC OIC mark code - - x x x x xx x x x x x x x x x x - - 1 x - - - N A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 59387 0
EEC J3 EEC_MRCOIC M 60 0 Marc. Oic Reg. Oic OIC mark Marcação Oic Registro Oic OIC mark - - x x x x xx x x x x x x x x x x MSMM(M->EEC_OICMCC,AVSX3("EEC_MRCOIC",3)) - 1 x - - - N A V - - - - - - - - - 3 N - - N N N - - - 1 2 - - - 59388 0
EEC J4 EEC_SPOT C 1 0 Venda Spot? ¿Venta Spot? Spot sale Venda Spot? ¿Venta Spot? Sale spot - NaoVazio() .or. Pertence("12") x x x x xx x x x x x x x x x x - - 1 x - - - N A R - - 1=Sim; 2=Nao 1=Si; 2=No 1=Yes; 2=No - - - - - N - - N N N - - - 1 2 - - - 59389 0
EEC J5 EEC_CODUSU C 15 0 Cod.Usuario Cod.Usuario User Code Codigo do usuario Codigo del Usuario User code - - x x x x x x x x x x x x x x x If(nSelecao = 3, __cUserid,) - 1 x - - - N V R - - - - - - - - - 1 N - - N N N - - - 1 2 - - - 59390 0
EEC J6 EEC_USUDIG C 40 0 Usuario Usuario User Usuario Usuario User - - x x x x x x x x x x x x x x x x EECIniPad('EEC_USUDIG') - 1 x - - - N V V - - - - - - - - - 1 N - - N N N - - - 1 2 - - - 59391 0
EEC J7 EEC_EMAIL C 40 0 E-Mail E-Mail e-mail E-Mail E-Mail E-Mail - - x x x x x x x x x x x x x x x x EECIniPad('EEC_EMAIL') - 1 x - - - N V V - - - - - - - - - 1 N - - N N N - - - 1 2 - - - 59392 0
EEC J8 EEC_VLFOB N 16 2 Total FOB Total FOB FOB Total Vl. Total FOB do Embarque Vl. Total FOB de Embarque Shipment FOB Total Value @E 9,999,999,999,999.99 - x x x x x x x x x x x x x x x - - 1 xxxx x - - - N A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 59393 0
EEC J9 EEC_NIOFFS C 2 0 Niv.OffShore Niv.OffShore OffShore Lev Nivel Off-Shore Nivel Off-Shore Off-Shore Level - - x x x x x x x x x x x x x x x - - 1 xx x - - - N A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 59394 0
EEC K0 EEC_EXL C 1 0 Folder Folleto Folder Dados Complementares Datos Complementarios Supplementary info @! - x x x x x x x x x x x x x x x x - - 1 x - - - N A R - - - - - - - - - A S - - N N N - - - 1 2 - - - 59395 0
EEC K1 EEC_PTCROM C 1 0 CCPTC/CCROM CCPTC/CCROM CCPTC/CCROM ME. Amparada CCPTC/CCROM ME. Amparada CCPTC/CCROM ME. Based on CCPTC/CCROM @! Pertence("12") x x x x x xx x x xx x x x x x x x "2" - 1 x xx x - - - - A R - - 1=Sim; 2=Nao 1=Si; 2=No 1=Yes;2=No - lAltera - - 5 S - - N N N - - - 1 2 - - - 59396 0
EEC K2 EEC_ID_LC C 10 0 ID WF LC ID WF LC ID WF LC ID WF LC ID WF LC ID WF LC @! - x x x x x x x x x x x x x x x - - 1 - - - - S A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 59397 0
EEC K3 EEC_ID_EMB C 10 0 ID WF EMB ID WF EMB ID WF EMB ID WF EMB ID WF EMB ID WF EMB @! - x x x x x x x x x x x x x x x - - 1 - - - - S A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 59398 0
EEC K4 EEC_ID_LB C 10 0 ID WF LB ID WF LB ID WF LB ID WF LB ID WF LB ID WF LB @! - x x x x x x x x x x x x x x x - - 1 - - - - S A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 59399 0
EEC K5 EEC_CODERP C 10 0 Cod. ERP Cod. ERP ERP Code Codigo ERP Codigo ERP ERP Code @! - x x x x x x x x x x x x x x x x - - 1 xxx - - - - - - - - - - - - - - - 1 S - - N - N - - - 1 2 - - - 59400 0
EEC K6 EEC_TITCAM C 9 0 Tit.Cam Tit.Cam Exch. Bill Num. Tit. Cambio Num. Tit. Cambio Exchange Bill Nr - - x x x x x x x x x x x x x x x x - - 1 xxx - - - N V R - - - - - - - - - 2 S - - N - N - - - 1 2 - - - 59401 0
EEC K7 EEC_ETAHR C 5 0 Hora ETA Hora ETA ETA Time Horário ETA Horario ETA ETA Time 99:99 - x x x x x x x x x x x x x x x x - - 1 xx x - - - N - - - - - - - - laltera - - 4 N - - N - N - - - 1 2 - - - 59402 0
EEC K8 EEC_ETB D 8 0 ETB ETB ETB ETB ETB ETB - - x x x x x x x x x x x x x x x x - - 1 xx x - - - N - - - - - - - - laltera - - 4 N - - N - N - - - 1 2 - - - 59403 0
EEC K9 EEC_ETBHR C 5 0 Hora ETB Hora ETB ETB Time Hora ETB Hora ETB ETB Time 99:99 - x x x x x x x x x x x x x x x x - - 1 xx x - - - N - - - - - - - - lAltera - - 4 N - - N - N - - - 1 2 - - - 59404 0
EEC L0 EEC_ETDHR C 5 0 Hora ETD Hora ETD ETD Time Hora ETD Hora ETD ETD Time 99:99 - x x x x x x x x x x x x x x x x - - 1 xx x - - - N - - - - - - - - lAltera - - 4 N - - N - N - - - 1 2 - - - 59405 0
EEC L1 EEC_DLDRAF D 8 0 D.L. Draft D.L. Draft Draft DL Dead Line entrega Draft Dead Line entrega Draft Draft delivery Dead Line - - x x x x x x x x x x x x x x x x - - 1 xx x - - - N - - - - - - - - lAltera - - 4 N - - N - N - - - 1 2 - - - 59406 0
EEC L2 EEC_DLDRHR C 5 0 Hora Draft Hora Draft Draft Time Hora D.L. entrega Draft Hora D.L. entrega Draft Draft delivery DL Time 99:99 - x x x x x x x x x x x x x x x x - - 1 xx x - - - N - - - - - - - - lAltera - - 4 N - - N - N - - - 1 2 - - - 59407 0
EEC L3 EEC_DLCARG D 8 0 D.L. Carga D.L. Carga Cargo DL Dead Line entrega Carga Dead Line entrega Carga Cargo delivery Dead Line - - x x x x x x x x x x x x x x x x - - 1 xx x - - - N - - - - - - - - lAltera - - 4 N - - N - N - - - 1 2 - - - 59408 0
EEC L4 EEC_DLCAHR C 5 0 Hora Carga Hora Carga Cargo Time Hora D.L. entrega Carga Hora D.L. entrega Carga Cargo Del. DL Time 99:99 - x x x x x x x x x x x x x x x x - - 1 xx x - - - N - - - - - - - - lAltera - - 4 N - - N - N - - - 1 2 - - - 59409 0
EEC L5 EEC_TPDESC C 1 0 Tp. Desconto Tp. Descuent Discount Tp. Tipo de Desconto Tipo de descuento Discount Type @! AE100CRIT('EEC_TPDESC') x x x x x x x x x x x x x x x x '1' - 1 x x - - - S A R - - 1=Subtrai; 2=Soma 1=Resta; 2=Suma 1=Add; 2=Subtract - lAltera '1' - 2 S - - N - N - - - 1 1 - - - 59410 0
EEC L6 EEC_TOTFOB N 15 2 Total FOB Total FOB FOB Total Total FOB Total FOB FOB Total @E 999,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x - - - N V - - - - - - - - - - - S - - N - N - - - 1 2 - - - 59411 0
EEC L7 EEC_QTDEMB N 7 2 Qtd.Embalag Cant. Embal. Package Qtty Quantidade Embalagem Cantidad Embalaje Package Quantity @E 9,999.99 - x x x x x x x x x x x x x x x x - - 1 xxx - - - N - - - - - - - - - - - 3 S - - N - N - - - 1 2 - - - 59412 0
EEC L8 EEC_TOTLIQ N 15 2 Total Liquid Total Neto Net Total Total Liquid Total Neto Net Total @E 999,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x - - - N V - - - - - - - - - - - S - - N - N - - - 1 2 - - - 59413 0
EEC L9 EEC_INFGER C 6 0 Inf. Gerais Inf. General General Info Informações Gerais Informaciones Generales General Info - - x x x x x x x x x x x x x x x x - - 1 x - - - N V R - - - - - - - - - 5 S - - N - N - - - 1 2 - - - 59414 0
EEC M0 EEC_VMINGE M 200 0 Inf. Gerais Inf. General General Info Informações Gerais Informaciones Generales General Info - - x x x x x x x x x x x x x x x x - - 1 x - - - N V V - - - - - - - - - 5 S - - N - N - - - 1 2 - - - 59415 0
EEC M1 EEC_INFCOF C 6 0 Inf.Adc.COF Inf.Adc.COF COF Add.Info Inf.Adc.Cert.FIERGS Inf.Adc.Cert.FIERGS FIERGS Cert. Addit. Info. - - x x x x x x x x x x x x x x x x - - 1 x - - - N V R - - - - - - - - - 6 S - - N - N - - - 1 2 - - - 59416 0
EEC M2 EEC_DESSEG C 1 0 Desc. Seg. Desc. Seg. Ins Disc Desconto no Seguro Descuento en el seguro Insurance Discount @! AE100CRIT("EEC_DESSEG") x x x x x x x x x x x x x x x x "2" - 1 x - - - S A R - - 1=Sim;2=Nao 1=Sí;2=No 1=Yes;2=No - M->EEC_PRECOA == "1" - - 2 S - - N - N - - - 1 2 - - - 59417 0
EEC M3 EEC_VMDCOF M 200 0 Inf.Adc.COF Inf.Adc.COF COF Add.Info Inf.Adc.Cert.FIERGS Inf.Adc.Cert.FIERGS FIERGS Cert. Addit. Info. - - x x x x x x x x x x x x x x x x - - 1 x - - - N A V - - - - - - lALTERA - - 6 S - - N - N - - - 1 2 - - - 59418 0
EEC M4 EEC_VLRIE N 15 2 Vlr Rec IE Val Pag IE IE Vl Coll Valor a Recolher I.E. Valor por pagar I.E. IE Value Collectible @E 999,999,999,999.99 POSITIVO() x x x x x x x x x x x x x x x x - - 1 xxxx x - - - N V R - - - - - - - - - 5 S - - N - N - - - 1 2 - - - 59419 0
EEC M5 EEC_VVLIE C 20 0 Vlr Rec IE Val Pag IE IE Vl Coll Valor a Recolher I.E. Valor por pagar I.E. IE Value Collectible - - x x x x x x x x x x x x x x x x - - 1 xxx - - - N V V - - - - - - - - - 5 S - - N - N - - - 1 2 - - - 59420 0
EEC M6 EEC_EMFRRC C 3 0 Tipo Despach Tipo Despach Dispatch Tp Tipo do Despacho Export. Tipo de despacho Export. Export Dispatch Type - - x x x x x x x x x x x x x x x x - - 1 x x - - - S A R - - 19=Fora de Recinto Alfandegado-Domiciliar;22=Fora de Recinto Alfandegado-Não Domiciliar;281=Despacho em recinto alfandegado 19=Fuera de recinto aduanero-domiciliar;22=Fuera de recinto aduanero-No domiciliar;281=Despacho en recinto aduanero 19 = Out of Bonded Warehouse-Domiciliary; 22 = Out of Bonded Warehouse-Non-Domiciliary; 281 = Bonded Warehouse Customs Clearance - - - - 5 S - - N - N - - - 1 2 - - - 59421 0
EEC M7 EEC_RECALF C 7 0 Recinto Alf. Dep. Aduan. Cust Room Recinto Alfandegado Depósito aduanero Customs Room - vazio() .or. ExistCpo("SJA") x x x x x x x x x x x x x x x x - SJA 1 xxxx x - - - S A R - - - - - - - - - 5 S - - N - N - - - 1 2 - - - 59422 0
EEC M8 EEC_RECEMB C 7 0 Rec.Alf.Emb. Rec.Aduan.Em Cust War Sh Recinto Alfandegado Emb. Recinto Aduanero Emb. Customs Warehouse Shipm - vazio() .or. ExistCpo("SJA") x x x x x x x x x x x x x x x x - SJA 1 xxxx x - - - S A R - - - - - - - - - 5 S - - N - N - - - 1 2 - - - 59423 0
EEC M9 EEC_STTDUE C 1 0 Status DU-E Estatus DU-E DU-E status Status de integração DU-E Estatus Integ DU-E DU-E integration status - - x x x x xx x x x x x x x x x x DU400Relacao("EEC_STTDUE") - 1 x xx x - - - S V R - - #DU400StDue() #DU400StDue() #DU400StDue() - - - - 5 S - - N - N - - - 1 2 - - - 59424 0
EEC N0 EEC_FOREXP C 4 0 Forma Export Forma Export Export form Forma Exportação Forma de exportación Export form @! Vazio() .Or. ExistCPO("EVN",M->EEC_FOREXP+"CUS",1) x x x x x x x x x x x x x x x x - EVN01 1 x - S - - A - - - - - - - - - - 5 S - - N - N - - - 1 2 - - - 59425 0
EEC N1 EEC_DESFOR C 30 0 Desc F. Expo Desc F. Expo Exp form des Descrição Forma Exportaçã Descripción Forma Exporta Export form description @! - x x x x x x x x x x x x x x x x If(INCLUI,'',Posicione('EVN',1,xFilial('EVN')+EEC->EEC_FOREXP+'CUS','EVN_DESCRI')) - 1 x - - - - V V - - - - - - - - - 5 S - - N - N - - - 1 2 - - - 59426 0
EEC N2 EEC_OBSFOR M 80 0 Obs.Forma Obs. Forma Note form Obs.Forma Obs.Forma Note form @! - x x x x x x x x x x x x x x x x - - 1 x - - - - A R - - - - - - - - - 5 S - - N - N - - - 1 2 - - - 59427 0
EEC N3 EEC_SITESP C 4 0 Situação Esp Situación Es Sp sit Situação Especial Situación especial Special situation @! Vazio() .Or. ExistCPO("EVN",M->EEC_SITESP+"AHZ",1) x x x x x x x x x x x x x x x x - EVN02 1 x - S - - A R - - - - - - - - - 5 S - - N - N - - - 1 2 - - - 59428 0
EEC N4 EEC_DESSIT C 30 0 Desc Sit esp Desc Sit Esp Sp sit desc Descrição Situacao Especi Descripción Situac. Espec Special situation descrip @! - x x x x x x x x x x x x x x x x If(INCLUI,'',Posicione('EVN',1,xFilial('EVN')+EEC->EEC_SITESP+'AHZ','EVN_DESCRI')) - 1 x - - - - V V - - - - - - - - - 5 S - - N - N - - - 1 2 - - - 59429 0
EEC N5 EEC_OBSSIT M 80 0 Obs.Sit.Esp Obs.Sit.Esp Note sp sit Obs.Sit.Esp Obs.Sit.Esp Note spec sit @! - x x x x x x x x x x x x x x x x - - 1 x - - - - A R - - - - - - - - - 5 S - - N - N - - - 1 2 - - - 59430 0
EEC N6 EEC_ESPTRA C 4 0 Caso Especia Caso Especia Spec case Caso Especial Transporte Caso especial transporte Transport special case @! Vazio() .Or. ExistCPO("EVN",M->EEC_ESPTRA+"TRA",1) x x x x x x x x x x x x x x x x - EVN03 1 x - S - - A R - - - - - - - - - 5 S - - N - N - - - 1 2 - - - 59431 0
EEC N7 EEC_DESTRA C 30 0 Desc Caso Tr Desc Caso Tr Tr case desc Desc. Caso Esp. Transport Desc. Caso Espe. Transpor Transport spec case desc @! - x x x x x x x x x x x x x x x x If(INCLUI,'',Posicione('EVN',1,xFilial('EVN')+EEC->EEC_ESPTRA+'TRA','EVN_DESCRI')) - 1 x - - - - V V - - - - - - - - - 5 S - - N - N - - - 1 2 - - - 59432 0
EEC N8 EEC_OBSTRA M 80 0 Obs.CasoTr. Obs. CasoTr. Note case.tr Obs.CasoTr. Obs.Caso Tr. Note case.tr @! - x x x x x x x x x x x x x x x x - - 1 x - - - - A R - - - - - - - - - 5 S - - N - N - - - 1 2 - - - 59433 0
EEC N9 EEC_MOTDIS C 4 0 Motivo Dispe Motivo Dispe Leav reas Motivo Dispensa NF Motivo dispensa Fact Inv leave reason @! Vazio() .Or. ExistCPO("EVN",M->EEC_MOTDIS+"ACG",1) x x x x x x x x x x x x x x x x - EVN04 1 x - S - - A R - - - - - - - - - 5 S - - N - N - - - 1 2 - - - 59434 0
EEC O0 EEC_DESDIS C 30 0 Desc Disp NF Desc Disp Fa Inv reas des Desc. Motivo Dispensa NF Desc. Motivo Dispensa Fct Inv leave reason desc @! - x x x x x x x x x x x x x x x x If(INCLUI,'',Posicione('EVN',1,xFilial('EVN')+EEC->EEC_MOTDIS+'ACG','EVN_DESCRI')) - 1 x - - - N V V - - - - - - - - - 5 S - - N - N - - - 1 2 - - - 59435 0
EEC O1 EEC_OBSDIS M 80 0 Obs.Mot.NF Obs.Mot.Fact Not inv reas Obs.Mot.NF Obs.Mot.Fact Note inv reas @! - x x x x x x x x x x x x x x x x - - 1 x - - - - A R - - - - - - - - - 5 S - - N - N - - - 1 2 - - - 59436 0
EEC O2 EEC_NRODUE C 14 0 Nro. da DUE Nº de DUE DUE no. Nro. da DUE Nº de la DUE DUE number @! - x x x x x x x x x x x x x x x x - - 1 x - - - - A R - - - - - - - - - 5 S - - N - N - - - 1 2 - - - 59437 0
EEC O3 EEC_NRORUC C 35 0 Nro. RUC Nº RUC RUC no. Número RUC Número RUC RUC number @! - x x x x x x x x x x x x x x x x - - 1 x - - - - A R - - - - - - AE100W("EEC_NRORUC") - - 5 S - - N - N - - - 1 2 - - - 59438 0
EEC O4 EEC_DTDUE D 8 0 Dt. DUE Fch. DUE DUE Dt. Data Transmissão DUE Fecha de transmisión DUE DUE Transmission Date - - x x x x x x x x x x x x x x x x - - 1 xx x - - - N A R - - - - - - AE100W("EEC_DTDUE") - - 5 S - - N - N - - - 1 2 - - - 59439 0
EEC O5 EEC_CHVDUE C 30 0 Chave DUE Clave DUE DUE Key Chave de Acesso DUE Clave de acceso DUE DUE Access Key - - x x x x x x x x x x x x x x x x - - 1 x - - - - A R - - - - - - - - - 5 S - - N - N - - - 1 2 - - - 59440 0
EEC O6 EEC_RESPDE C 14 0 CNPJ Res Des RCPJ Res Env CNPJ Disp CNPJ Responsável Despacho RCPJ Responsable envío CNPJ Dispatch Responsible @!R NN.NNN.NNN/NNNN-99 CGC(M->EEC_RESPDE) x x x x x x x x x x x x x x x x - - 1 xx - - - - - - - - - - - - M->EEC_EMFRRC <> "281" - - 5 S - - N - N - - - 1 2 - - - 59441 0
EEC O7 EEC_LATDES N 11 7 Lat. Desp. Lat. Desp. Cust Lat Latitude do Local de Desp Latitud del local de Desp Cust Location Latitude @E 999.9999999 - x x x x x x x x x x x x x x x x - - 1 xx - - - - - - - - - - - - M->EEC_EMFRRC <> "281" - - 5 S - - N - N - - - 1 2 - - - 59442 0
EEC O8 EEC_LONDES N 11 7 Long. Desp. Long. Desp. Cust Long Longitude do Local de Des Longitud del local del De Cust Location Longitude @E 999.9999999 - x x x x x x x x x x x x x x x x - - 1 xx - - - - - - - - - - - - M->EEC_EMFRRC <> "281" - - 5 S - - N - N - - - 1 2 - - - 59443 0
EEC O9 EEC_ENDDES C 240 0 End. Desp Direcc. Desp Cust Addr Endereço do Local de Desp Dirección del local de De Cust Location Address - - x x x x x x x x x x x x x x x x - - 1 xx - - - - - - - - - - - - M->EEC_EMFRRC <> "281" - - 5 S - - N - N - - - 1 2 - - - 59444 0
EEC P0 EEC_DUEAVR D 8 0 Dt Averb DUE Fch Decl DUE DUE Reg Dt Data da Averbação DUE Fecha de la declaración D DUE Registration Date - AE100CRIT("EEC_DUEAVR") x x x x x x x x x x x x x x x x - - 1 xx - - - - A - - - - - - - - - - 5 S - - N - N - - - 1 2 - - - 59445 0
EEC P1 EEC_JUSRET M 80 0 Just.Retific Just.Rectif. Reason Recti Justificativa Retificação Justificación Rectificac. Reason of Rectification - - x x x x x x x x x x x x x x x x - - 1 xx - - - - A R - - - - - - !Empty(M->EEC_NRODUE) - - 5 S - - N - N - - - 1 2 - - - 59446 0
EEC P2 EEC_DTADTE D 8 0 Lib.Pend.Ad Lib.Pend.Ad Ad Pend Rel Liberação Financeira Liberación financiera Financial Release - - x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - 2 S - - N - N - - - 1 2 - - - 59447 0
EEC P3 EEC_STADTO C 200 0 Status ADTO Estatus ADTO Prepaym St Status dos Adiantamentos Estatus de los anticipos Prepayment Status - IIF(!INCLUI,AE102ADTVLD(.T.),"") x x x x x x x x x x x x x x x x - - 1 x - - - N V V - - - - - - - - - 2 S - - N - N - - - 1 2 - - - 59448 0
EEC P4 EEC_DUEMAN C 14 0 DUE Manual DUE Manual DUE Manual DUE Manual DUE Manual DUE Manual @! - x x x x x x x x x x x x x x x x - - 1 x xx - S - N A R - - - - - - AE100W("EEC_DUEMAN") - - 5 S - - N - N - - - 1 2 - - - 59449 0
EEC P5 EEC_STPTUN C 60 0 Portal Único Portal único Single Porta Status Portal Único Estatus Portal único Single Portal Status - - x x x x x x x x x x x x x x x x - - 1 x - - - S V R - - - - - - - - - - S - - N - N - - - 1 2 - - - 59450 0
EEC P6 EEC_ALRDUE C 1 0 Alerta DUE Avis. Alert DUE Warning Ciente Alertas Sistema? ¿Enterado Avis. Alerta si System Warnings Aware? @! Pertence('12') x x x x x x x x x x x x x x x x '2' - 1 x xx - - - N A R - - 1=Sim;2=Não 1=Sí;2=No 1=Yes;2=No - AE100W("EEC_ALRDUE") - - 5 S - - N - N - - - 1 2 - - - 59451 0

Índices da Tabela EEC (16 índices)

INDICE ORDEM CHAVE DESCRICAO DESCSPA DESCENG PROPRI F3 NICKNAME SHOWPESQ IX_VIRTUAL IX_VIRCUST D_E_L_E_T_ R_E_C_N_O_ R_E_C_D_E_L_
EEC 1 EEC_FILIAL+EEC_PREEMB Processo Proceso Process S - - S 2 3 - 8996 0
EEC 2 EEC_FILIAL+DTOS(EEC_DTPROC) Dt.Processo Fch.Proceso Process Date S - - S 2 3 - 8997 0
EEC 3 EEC_FILIAL+EEC_LC_NUM No. L/C Num. L/C License Nr. S - - S 2 3 - 8998 0
EEC 4 EEC_FILIAL+DTOS(EEC_FATURA) Dt.Faturam. Fch.Facturac Invoic. Date S - - S 2 3 - 8999 0
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 - 9000 0
EEC 6 EEC_FILIAL+EEC_IMPORT+EEC_IMLOJA Cod. Import. + Loja Import. Cod. Import. + Tienda Impor Import. Code + Imp. Store S - - S 2 3 - 9001 0
EEC 7 EEC_FILIAL+EEC_CLIENT+EEC_CLLOJA Cod.Cliente + Loja Cliente Cod.Cliente + Tienda Clte Cust. Code + Client Store S - - S 2 3 - 9002 0
EEC 8 EEC_FILIAL+EEC_FORN+EEC_FOLOJA Cod.Fornec. + Loja Fornec. Cod.Proveed. + Tienda Prov Sup. Code + Sup. Store S - - S 2 3 - 9003 0
EEC 9 EEC_FILIAL+EEC_EXPORT+EEC_EXLOJA Cod.Export. + Loja Export. Cod.Export. + Tienda Expo Export. Code + Exp. Store S - - S 2 3 - 9004 0
EEC A EEC_FILIAL+EEC_CONSIG+EEC_COLOJA Cod.Consign. + Loja Consig. Cod.Consign. + Tienda Consi Consign.Code + Cons. Store S - - S 2 3 - 9005 0
EEC B EEC_FILIAL+EEC_BENEF+EEC_BELOJA Cod.Benef. + Loja Benef. Cod.Benef. + Tienda Benef Benef. Code + Ben. Store S - - S 2 3 - 9006 0
EEC C EEC_FILIAL+DTOS(EEC_DTEMBA) Dt.Embarque Fch.Embarque Ship. Date S - - S 2 3 - 9007 0
EEC D EEC_FILIAL+STR(EEC_VLNFC,10,0) Seq.Ord. Sec. Ord. Ord.Seq. S - - S 2 3 - 9008 0
EEC E EEC_FILIAL+EEC_PEDREF Processo Ref Proceso Ref Ref. Process S - - S 2 3 - 9009 0
EEC F EEC_FILIAL+EEC_NRINVO Nr.Invoice Num. Invoice Invoice Nr. S - - S 2 3 - 9010 0
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 - 9011 0

Perguntas frequentes

Para que serve a tabela EEC no Protheus?

Ela é utilizada para embarque dentro do sistema ERP Protheus.

Como consultar os campos da tabela EEC?

Nesta página você pode visualizar todos os campos, incluindo tipo, tamanho e validações.

O que são os índices da tabela EEC?

Os índices são estruturas que melhoram a performance de busca e acesso aos dados dentro do Protheus.

Exemplo de consulta SQL da tabela EEC

Modelo de query gerado automaticamente com base na estrutura da tabela.

SELECT
    EEC_FILIAL,
    EEC_PREEMB,
    EEC_PEDREF,
    EEC_DTPROC,
    EEC_FIM_PE,
    EEC_VM_AMO,
    EEC_ENVAMO,
    EEC_AMOSTR,
    EEC_STATUS,
    EEC_IMPORT,
    EEC_IMLOJA,
    EEC_IMPODE,
    EEC_STTDES,
    EEC_MOTSIT,
    EEC_DSCMTS,
    EEC_ENDIMP,
    EEC_END2IM,
    EEC_REFIMP,
    EEC_EXLIMP,
    EEC_LICIMP,
    EEC_INTERM,
    EEC_DTLIMP,
    EEC_CLIENT,
    EEC_CLLOJA,
    EEC_CLIEDE,
    EEC_FORN,
    EEC_FOLOJA,
    EEC_FORNDE,
    EEC_INCO2,
    EEC_EXPORT,
    EEC_EXLOJA,
    EEC_EXPODE,
    EEC_COND2,
    EEC_DIAS2,
    EEC_CONSIG,
    EEC_COLOJA,
    EEC_CONSDE,
    EEC_RESPON,
    EEC_BENEF,
    EEC_BELOJA,
    EEC_BENEDE,
    EEC_ENDBEN,
    EEC_END2BE,
    EEC_CONDPA,
    EEC_CLIENF,
    EEC_CLOJAF,
    EEC_DIASPA,
    EEC_DESCPA,
    EEC_MPGEXP,
    EEC_DSCMPE,
    EEC_INCOTE,
    EEC_VIA,
    EEC_VIA_DE,
    EEC_ORIGEM,
    EEC_DSCORI,
    EEC_DEST,
    EEC_DSCDES,
    EEC_TIPTRA,
    EEC_URFDSP,
    EEC_URFENT,
    EEC_PAISDT,
    EEC_PAISET,
    EEC_MARCAC,
    EEC_CODMAR,
    EEC_MOEDA,
    EEC_FRPPCC,
    EEC_FRPREV,
    EEC_FREEMB,
    EEC_FRPCOM,
    EEC_SEGURO,
    EEC_SEGPRE,
    EEC_DESPIN,
    EEC_DESCON,
    EEC_PRECOA,
    EEC_EMBAFI,
    EEC_CALCEM,
    EEC_CUBAGE,
    EEC_PACKAG,
    EEC_CONFEC,
    EEC_ONTHEP,
    EEC_QUANTI,
    EEC_UNIT,
    EEC_NETWGT,
    EEC_GROSSW,
    EEC_IDIOMA,
    EEC_LC_NUM,
    EEC_SL_LC,
    EEC_SL_EME,
    EEC_PGTANT,
    EEC_TIPCOM,
    EEC_TIPCVL,
    EEC_VALCOM,
    EEC_REFAGE,
    EEC_INSCOD,
    EEC_ENQCOX,
    EEC_ENQCOD,
    EEC_ENQCO1,
    EEC_ENQCO2,
    EEC_ENQCO3,
    EEC_ENQCO4,
    EEC_ENQCO5,
    EEC_DSCGEN,
    EEC_GENERI,
    EEC_CODOBP,
    EEC_OBSPED,
    EEC_OBS,
    EEC_CODMEM,
    EEC_PESLIQ,
    EEC_PESBRU,
    EEC_TOTPED,
    EEC_TOTITE,
    EEC_REGVEN,
    EEC_OPCRED,
    EEC_LIMOPE,
    EEC_GEDERE,
    EEC_GDRPRO,
    EEC_DIRIVN,
    EEC_SECEX,
    EEC_MRGNSC,
    EEC_VLMNSC,
    EEC_ANTECI,
    EEC_VISTA,
    EEC_NPARC,
    EEC_PARCEL,
    EEC_VLCONS,
    EEC_COBCAM,
    EEC_FINCIA,
    EEC_DECPES,
    EEC_DECQTD,
    EEC_DECPRC,
    EEC_BRUEMB,
    EEC_CODAGT,
    EEC_DSCAGT,
    EEC_DTFCPR,
    EEC_ETA,
    EEC_TRSTIM,
    EEC_ETD,
    EEC_ETADES,
    EEC_EMBARC,
    EEC_VIAGEM,
    EEC_NRINVO,
    EEC_DTINVO,
    EEC_DTSLNF,
    EEC_DTSDFB,
    EEC_VLNFC,
    EEC_DECAM,
    EEC_NRCTOR,
    EEC_NRCTFA,
    EEC_NRCONH,
    EEC_MAWB,
    EEC_DTCONH,
    EEC_DTEMBA,
    EEC_TOTVOL,
    EEC_DTSLPL,
    EEC_DTSLIN,
    EEC_TIPO,
    EEC_DTREC,
    EEC_DTPALE,
    EEC_DTINSP,
    EEC_ARM,
    EEC_ARLOJA,
    EEC_ARMDES,
    EEC_NRINSP,
    EEC_NRCTSG,
    EEC_NRAVSG,
    EEC_DTSEGU,
    EEC_APLCSG,
    EEC_TRSDOC,
    EEC_DTLMDC,
    EEC_PEDFAT,
    EEC_IN86,
    EEC_DTDCIM,
    EEC_DTENDC,
    EEC_BCDCRF,
    EEC_BCEXRF,
    EEC_COURIE,
    EEC_COURI2,
    EEC_FATURA,
    EEC_LIBSIS,
    EEC_DSCCOM,
    EEC_STASIS,
    EEC_PEDDES,
    EEC_PTINT,
    EEC_PEDEMB,
    EEC_DTESTU,
    EEC_TSISC,
    EEC_DTEFE,
    EEC_MODEST,
    EEC_PERC,
    EEC_UNIDAD,
    EEC_TIPEST,
    EEC_OICMCC,
    EEC_MRCOIC,
    EEC_SPOT,
    EEC_CODUSU,
    EEC_USUDIG,
    EEC_EMAIL,
    EEC_VLFOB,
    EEC_NIOFFS,
    EEC_EXL,
    EEC_PTCROM,
    EEC_ID_LC,
    EEC_ID_EMB,
    EEC_ID_LB,
    EEC_CODERP,
    EEC_TITCAM,
    EEC_ETAHR,
    EEC_ETB,
    EEC_ETBHR,
    EEC_ETDHR,
    EEC_DLDRAF,
    EEC_DLDRHR,
    EEC_DLCARG,
    EEC_DLCAHR,
    EEC_TPDESC,
    EEC_TOTFOB,
    EEC_QTDEMB,
    EEC_TOTLIQ,
    EEC_INFGER,
    EEC_VMINGE,
    EEC_INFCOF,
    EEC_DESSEG,
    EEC_VMDCOF,
    EEC_VLRIE,
    EEC_VVLIE,
    EEC_EMFRRC,
    EEC_RECALF,
    EEC_RECEMB,
    EEC_STTDUE,
    EEC_FOREXP,
    EEC_DESFOR,
    EEC_OBSFOR,
    EEC_SITESP,
    EEC_DESSIT,
    EEC_OBSSIT,
    EEC_ESPTRA,
    EEC_DESTRA,
    EEC_OBSTRA,
    EEC_MOTDIS,
    EEC_DESDIS,
    EEC_OBSDIS,
    EEC_NRODUE,
    EEC_NRORUC,
    EEC_DTDUE,
    EEC_CHVDUE,
    EEC_RESPDE,
    EEC_LATDES,
    EEC_LONDES,
    EEC_ENDDES,
    EEC_DUEAVR,
    EEC_JUSRET,
    EEC_DTADTE,
    EEC_STADTO,
    EEC_DUEMAN,
    EEC_STPTUN,
    EEC_ALRDUE
FROM EEC
WHERE
    D_E_L_E_T_ = ' '
    AND EEC_FILIAL = 'VALOR'
    AND EEC_PREEMB = 'VALOR'
    AND EEC_PEDREF = 'VALOR'
    AND EEC_DTPROC BETWEEN '20261001' AND '20261031'
    AND EEC_FIM_PE BETWEEN '20261001' AND '20261031'
    AND EEC_VM_AMO = 'VALOR'
    AND EEC_ENVAMO = 'VALOR'
    AND EEC_AMOSTR = 'VALOR'
    AND EEC_STATUS = 'VALOR'
    AND EEC_IMPORT = 'VALOR'
    AND EEC_IMLOJA = 'VALOR'
    AND EEC_IMPODE = 'VALOR'
    AND EEC_STTDES = 'VALOR'
    AND EEC_MOTSIT = 'VALOR'
    AND EEC_DSCMTS = 'VALOR'
    AND EEC_ENDIMP = 'VALOR'
    AND EEC_END2IM = 'VALOR'
    AND EEC_REFIMP = 'VALOR'
    AND EEC_EXLIMP = 'VALOR'
    AND EEC_LICIMP = 'VALOR'
    AND EEC_INTERM = 'VALOR'
    AND EEC_DTLIMP BETWEEN '20261001' AND '20261031'
    AND EEC_CLIENT = 'VALOR'
    AND EEC_CLLOJA = 'VALOR'
    AND EEC_CLIEDE = 'VALOR'
    AND EEC_FORN = 'VALOR'
    AND EEC_FOLOJA = 'VALOR'
    AND EEC_FORNDE = 'VALOR'
    AND EEC_INCO2 = 'VALOR'
    AND EEC_EXPORT = 'VALOR'
    AND EEC_EXLOJA = 'VALOR'
    AND EEC_EXPODE = 'VALOR'
    AND EEC_COND2 = 'VALOR'
    AND EEC_DIAS2 = 0
    AND EEC_CONSIG = 'VALOR'
    AND EEC_COLOJA = 'VALOR'
    AND EEC_CONSDE = 'VALOR'
    AND EEC_RESPON = 'VALOR'
    AND EEC_BENEF = 'VALOR'
    AND EEC_BELOJA = 'VALOR'
    AND EEC_BENEDE = 'VALOR'
    AND EEC_ENDBEN = 'VALOR'
    AND EEC_END2BE = 'VALOR'
    AND EEC_CONDPA = 'VALOR'
    AND EEC_CLIENF = 'VALOR'
    AND EEC_CLOJAF = 'VALOR'
    AND EEC_DIASPA = 0
    AND EEC_DESCPA = 'VALOR'
    AND EEC_MPGEXP = 'VALOR'
    AND EEC_DSCMPE = 'VALOR'
    AND EEC_INCOTE = 'VALOR'
    AND EEC_VIA = 'VALOR'
    AND EEC_VIA_DE = 'VALOR'
    AND EEC_ORIGEM = 'VALOR'
    AND EEC_DSCORI = 'VALOR'
    AND EEC_DEST = 'VALOR'
    AND EEC_DSCDES = 'VALOR'
    AND EEC_TIPTRA = 'VALOR'
    AND EEC_URFDSP = 'VALOR'
    AND EEC_URFENT = 'VALOR'
    AND EEC_PAISDT = 'VALOR'
    AND EEC_PAISET = 'VALOR'
    AND EEC_CODMAR = 'VALOR'
    AND EEC_MOEDA = 'VALOR'
    AND EEC_FRPPCC = 'VALOR'
    AND EEC_FRPREV = 0
    AND EEC_FREEMB = 0
    AND EEC_FRPCOM = 0
    AND EEC_SEGURO = 0
    AND EEC_SEGPRE = 0
    AND EEC_DESPIN = 0
    AND EEC_DESCON = 0
    AND EEC_PRECOA = 'VALOR'
    AND EEC_EMBAFI = 'VALOR'
    AND EEC_CALCEM = 'VALOR'
    AND EEC_CUBAGE = 0
    AND EEC_PACKAG = 'VALOR'
    AND EEC_CONFEC = 'VALOR'
    AND EEC_ONTHEP = 'VALOR'
    AND EEC_QUANTI = 'VALOR'
    AND EEC_UNIT = 'VALOR'
    AND EEC_NETWGT = 'VALOR'
    AND EEC_GROSSW = 'VALOR'
    AND EEC_IDIOMA = 'VALOR'
    AND EEC_LC_NUM = 'VALOR'
    AND EEC_SL_LC BETWEEN '20261001' AND '20261031'
    AND EEC_SL_EME BETWEEN '20261001' AND '20261031'
    AND EEC_PGTANT = 'VALOR'
    AND EEC_TIPCOM = 'VALOR'
    AND EEC_TIPCVL = 'VALOR'
    AND EEC_VALCOM = 0
    AND EEC_REFAGE = 'VALOR'
    AND EEC_INSCOD = 'VALOR'
    AND EEC_ENQCOX = 'VALOR'
    AND EEC_ENQCOD = 'VALOR'
    AND EEC_ENQCO1 = 'VALOR'
    AND EEC_ENQCO2 = 'VALOR'
    AND EEC_ENQCO3 = 'VALOR'
    AND EEC_ENQCO4 = 'VALOR'
    AND EEC_ENQCO5 = 'VALOR'
    AND EEC_DSCGEN = 'VALOR'
    AND EEC_CODOBP = 'VALOR'
    AND EEC_CODMEM = 'VALOR'
    AND EEC_PESLIQ = 0
    AND EEC_PESBRU = 0
    AND EEC_TOTPED = 0
    AND EEC_TOTITE = 0
    AND EEC_REGVEN = 'VALOR'
    AND EEC_OPCRED = 'VALOR'
    AND EEC_LIMOPE BETWEEN '20261001' AND '20261031'
    AND EEC_GEDERE = 'VALOR'
    AND EEC_GDRPRO = 'VALOR'
    AND EEC_DIRIVN = 'VALOR'
    AND EEC_SECEX = 'VALOR'
    AND EEC_MRGNSC = 0
    AND EEC_VLMNSC = 0
    AND EEC_ANTECI = 0
    AND EEC_VISTA = 0
    AND EEC_NPARC = 0
    AND EEC_PARCEL = 0
    AND EEC_VLCONS = 0
    AND EEC_COBCAM = 'VALOR'
    AND EEC_FINCIA = 0
    AND EEC_DECPES = 0
    AND EEC_DECQTD = 0
    AND EEC_DECPRC = 0
    AND EEC_BRUEMB = 'VALOR'
    AND EEC_CODAGT = 'VALOR'
    AND EEC_DSCAGT = 'VALOR'
    AND EEC_DTFCPR BETWEEN '20261001' AND '20261031'
    AND EEC_ETA BETWEEN '20261001' AND '20261031'
    AND EEC_TRSTIM = 0
    AND EEC_ETD BETWEEN '20261001' AND '20261031'
    AND EEC_ETADES BETWEEN '20261001' AND '20261031'
    AND EEC_EMBARC = 'VALOR'
    AND EEC_VIAGEM = 'VALOR'
    AND EEC_NRINVO = 'VALOR'
    AND EEC_DTINVO BETWEEN '20261001' AND '20261031'
    AND EEC_DTSLNF BETWEEN '20261001' AND '20261031'
    AND EEC_DTSDFB BETWEEN '20261001' AND '20261031'
    AND EEC_VLNFC = 0
    AND EEC_DECAM = 'VALOR'
    AND EEC_NRCTOR = 'VALOR'
    AND EEC_NRCTFA = 'VALOR'
    AND EEC_NRCONH = 'VALOR'
    AND EEC_MAWB = 'VALOR'
    AND EEC_DTCONH BETWEEN '20261001' AND '20261031'
    AND EEC_DTEMBA BETWEEN '20261001' AND '20261031'
    AND EEC_TOTVOL = 0
    AND EEC_DTSLPL BETWEEN '20261001' AND '20261031'
    AND EEC_DTSLIN BETWEEN '20261001' AND '20261031'
    AND EEC_TIPO = 'VALOR'
    AND EEC_DTREC BETWEEN '20261001' AND '20261031'
    AND EEC_DTPALE BETWEEN '20261001' AND '20261031'
    AND EEC_DTINSP BETWEEN '20261001' AND '20261031'
    AND EEC_ARM = 'VALOR'
    AND EEC_ARLOJA = 'VALOR'
    AND EEC_ARMDES = 'VALOR'
    AND EEC_NRINSP = 'VALOR'
    AND EEC_NRCTSG = 'VALOR'
    AND EEC_NRAVSG = 'VALOR'
    AND EEC_DTSEGU BETWEEN '20261001' AND '20261031'
    AND EEC_APLCSG = 'VALOR'
    AND EEC_TRSDOC = 0
    AND EEC_DTLMDC BETWEEN '20261001' AND '20261031'
    AND EEC_PEDFAT = 'VALOR'
    AND EEC_IN86 = 'VALOR'
    AND EEC_DTDCIM BETWEEN '20261001' AND '20261031'
    AND EEC_DTENDC BETWEEN '20261001' AND '20261031'
    AND EEC_BCDCRF = 'VALOR'
    AND EEC_BCEXRF = 'VALOR'
    AND EEC_COURIE = 'VALOR'
    AND EEC_COURI2 = 'VALOR'
    AND EEC_FATURA BETWEEN '20261001' AND '20261031'
    AND EEC_LIBSIS BETWEEN '20261001' AND '20261031'
    AND EEC_DSCCOM = 'VALOR'
    AND EEC_STASIS = 'VALOR'
    AND EEC_PEDDES = 'VALOR'
    AND EEC_PTINT = 'VALOR'
    AND EEC_PEDEMB = 'VALOR'
    AND EEC_DTESTU BETWEEN '20261001' AND '20261031'
    AND EEC_TSISC = 'VALOR'
    AND EEC_DTEFE BETWEEN '20261001' AND '20261031'
    AND EEC_MODEST = 'VALOR'
    AND EEC_PERC = 0
    AND EEC_UNIDAD = 'VALOR'
    AND EEC_TIPEST = 'VALOR'
    AND EEC_OICMCC = 'VALOR'
    AND EEC_SPOT = 'VALOR'
    AND EEC_CODUSU = 'VALOR'
    AND EEC_USUDIG = 'VALOR'
    AND EEC_EMAIL = 'VALOR'
    AND EEC_VLFOB = 0
    AND EEC_NIOFFS = 'VALOR'
    AND EEC_EXL = 'VALOR'
    AND EEC_PTCROM = 'VALOR'
    AND EEC_ID_LC = 'VALOR'
    AND EEC_ID_EMB = 'VALOR'
    AND EEC_ID_LB = 'VALOR'
    AND EEC_CODERP = 'VALOR'
    AND EEC_TITCAM = 'VALOR'
    AND EEC_ETAHR = 'VALOR'
    AND EEC_ETB BETWEEN '20261001' AND '20261031'
    AND EEC_ETBHR = 'VALOR'
    AND EEC_ETDHR = 'VALOR'
    AND EEC_DLDRAF BETWEEN '20261001' AND '20261031'
    AND EEC_DLDRHR = 'VALOR'
    AND EEC_DLCARG BETWEEN '20261001' AND '20261031'
    AND EEC_DLCAHR = 'VALOR'
    AND EEC_TPDESC = 'VALOR'
    AND EEC_TOTFOB = 0
    AND EEC_QTDEMB = 0
    AND EEC_TOTLIQ = 0
    AND EEC_INFGER = 'VALOR'
    AND EEC_INFCOF = 'VALOR'
    AND EEC_DESSEG = 'VALOR'
    AND EEC_VLRIE = 0
    AND EEC_VVLIE = 'VALOR'
    AND EEC_EMFRRC = 'VALOR'
    AND EEC_RECALF = 'VALOR'
    AND EEC_RECEMB = 'VALOR'
    AND EEC_STTDUE = 'VALOR'
    AND EEC_FOREXP = 'VALOR'
    AND EEC_DESFOR = 'VALOR'
    AND EEC_SITESP = 'VALOR'
    AND EEC_DESSIT = 'VALOR'
    AND EEC_ESPTRA = 'VALOR'
    AND EEC_DESTRA = 'VALOR'
    AND EEC_MOTDIS = 'VALOR'
    AND EEC_DESDIS = 'VALOR'
    AND EEC_NRODUE = 'VALOR'
    AND EEC_NRORUC = 'VALOR'
    AND EEC_DTDUE BETWEEN '20261001' AND '20261031'
    AND EEC_CHVDUE = 'VALOR'
    AND EEC_RESPDE = 'VALOR'
    AND EEC_LATDES = 0
    AND EEC_LONDES = 0
    AND EEC_ENDDES = 'VALOR'
    AND EEC_DUEAVR BETWEEN '20261001' AND '20261031'
    AND EEC_DTADTE BETWEEN '20261001' AND '20261031'
    AND EEC_STADTO = 'VALOR'
    AND EEC_DUEMAN = 'VALOR'
    AND EEC_STPTUN = 'VALOR'
    AND EEC_ALRDUE = 'VALOR'