Dicionário Protheus
Início

Tabela SEH no Protheus

Controle Aplicação/Emprestimo

O que é a tabela SEH no Protheus?

A tabela SEH faz parte do sistema ERP Protheus da TOTVS e é utilizada para controle aplicação/emprestimo.

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 SEH 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 SEH, incluindo todos os campos e índices relacionados.

Propriedades da Tabela

Propriedade Valor
X2_CHAVE SEH
X2_PATH \DATA\
X2_ARQUIVO SEH990
X2_NOME Controle Aplicação/Emprestimo
X2_NOMESPA Control Inversión/Préstamo
X2_NOMEENG Investment/Loan Control
X2_ROTINA -
X2_MODO E
X2_MODOUN E
X2_MODOEMP E
X2_DELET 0
X2_TTS -
X2_UNICO EH_FILIAL+EH_NUMERO+EH_REVISAO
X2_PYME N
X2_MODULO 6
X2_DISPLAY -
X2_SYSOBJ -
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_ 8192
R_E_C_D_E_L_ 0

Campos da Tabela SEH (102 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_
SEH 01 EH_FILIAL C 2 0 Filial Sucursal Branch Filial do Sistema Sucursal del Sistema System Branch - - x x x x x x x x x x x x x x x - - 1 - - - - N - - - - - - - - - - 033 - S - - N N N - - - 1 2 - - - 132969 0
SEH 02 EH_NUMERO C 6 0 Numero Numero Number Numero da Operacao Numero de la Operacion Operation Number @9 ExistChav("SEH") .AND. FreeForUse("SEH",M->EH_NUMERO) x x x x x x x x x x x x x x x x GetSx8Num("SEH","EH_NUMERO") - 1 x xxx - - - S - - - - - - - - INCLUI - - - S - - N N N - - 001 1 1 - - - 132970 0
SEH 03 EH_REVISAO C 2 0 Revisao Revision Revision Numero da Revisao Numero de la Revision Revision Number @! - x x x x x x x x x x x x x x x x "01" - 1 xx - - - S V - - - - - - - INCLUI - - - S - - N N N - - 001 1 2 - - - 132971 0
SEH 04 EH_APLEMP C 3 0 Modelo Modelo Model Modelo da Operacao Modelo de la Operacion Operation Model @! Pertence("APL|EMP") .And. Fa171Nat() x x x x x x x x x x x x x x x x - - 1 xx - - - S - - - - APL=Aplicacao;EMP=Emprestimo APL=Inversion;EMP=Prestamo APL=Application;EMP=Loan - INCLUI - - - S - - N N N - - 001 1 1 - - - 132972 0
SEH 05 EH_TIPO C 3 0 Operacao Operacion Operation Tipo da Operacao Tipo de la Operaci¾n Operation Type @! Fa171Opera() x x x x x x x x x x x x x x x x - 11 1 xx - - - S - - - - - - - - INCLUI - - - S - - N N N - - 001 1 1 - - - 132973 0
SEH 06 EH_BANCO C 3 0 Banco Banco Bank Codigo do banco Codigo del banco Bank Code @! ExistCpo('SA6',,,,,.F.) .AND. A171Banco() x x x x x x x x x x x x x x x x - SA6 1 xx - S - S - - - - - - - - INCLUI - 007 - S - - N N N - - 001 1 1 - - - 132974 0
SEH 07 EH_AGENCIA C 5 0 Agencia Agencia Branch Agencia do banco Agencia del banco Bank Branch @! existcpo("SA6",M->EH_BANCO+M->EH_AGENCIA) .AND. A171Banco() x x x x x x x x x x x x x x x x - - 1 xx - S - S - - - - - - - - INCLUI - 008 - S - - N N N - - 001 1 1 - - - 132975 0
SEH 08 EH_CONTA C 10 0 Conta Banco Cuenta Banco Bank C. Acc. Conta corrente no banco Cta corriente en el banco Bank Current Account @! existcpo("SA6",M->EH_BANCO+M->EH_AGENCIA+M->EH_CONTA) .AND. !CCBLOCKED(M->EH_BANCO,M->EH_AGENCIA,M->EH_CONTA) .AND. A171Banco() x x x x x x x x x x x x x x x x - - 1 xx - S - S - - - - - - - - INCLUI - 009 - S - - N N N - - 001 1 1 - - - 132976 0
SEH 09 EH_NBANCO C 20 0 Inst.Financ. Inst.Financ. Fin.Institut Instituicao Financeira Institucion Financiera Financial Institution @S15! - x x x x x x x x x x x x x x x x - - 1 x x x - - - S - - - - - - - - - - - - S - - N N N - - 001 1 2 - - - 132977 0
SEH 10 EH_NATUREZ C 10 0 Natureza Modalidad Class Codigo da Natureza Codigo de la Modalidad Class Code @! FinVldNat(.F.,M->EH_NATUREZ) x x x x x x x x x x x x x x x x - SED 1 x x - - - N - - - - - - - - INCLUI - - - S - - N N N - - 001 1 2 - - - 132978 0
SEH 11 EH_DATA D 8 0 DT Operacao Fch Operac. Operation Dt Data da operacao Fecha de la Operaci¾n Operation Date - M->EH_DATA==ddatabase x x x x x x x x x x x x x x x x ddatabase - 1 xx - - - S - - - - - - - - INCLUI - - - S - - N N N - - 001 1 1 - - - 132979 0
SEH 12 EH_TAXA N 9 5 Taxa Nominal Tasa Nominal Nominal Rt. Taxa nominal da Operacao Tasa Nominal de Operacion Operation Nominal Rate @E 999.99999 positivo() x x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - - - - - S - - N N N - - 001 1 2 - - - 132980 0
SEH 13 EH_QUOTAS N 16 8 Qtd.Cota/Tit Ct Cuota/Tit Qty.Install. Qtd. de Cotas/Titulos Ctd. de Cuotas/Titulos Number of Installm./Bills @E 9,999,999.99999999 - x x x x x x x x x x x x x x x x - - 1 xx x x - S - N - - - - - - - - Fa171Apl() - - - S - - N N N - - 001 1 2 - - - 132981 0
SEH 14 EH_CONTRAT C 15 0 Numero Contr Nro.Contrato Contract Nr. Numero do Contrato Numero del Contrato Contract Number @! ExistCpo("SE9") .And. V181Contrat(m->eh_contrat) x x x x x x x x x x x x x x x x - SE9 1 x x - S - N - - - - - - - - Fa171Apl() - - - S - - N N N - - 001 1 2 - - - 132982 0
SEH 15 EH_BCOCONT C 3 0 Banco Contr. Banco Contr. Contr. Bank Banco do Contrato Banco del Contrato Contract Bank @! ExistCpo("SE9",M->EH_CONTRAT+M->EH_BCOCONT) x x x x x x x x x x x x x x x x - SA6 1 x x - - - N - - - - - - - - Fa171Apl() - 007 - S - - N N N - - 001 1 2 - - - 132983 0
SEH 16 EH_AGECONT C 5 0 Agencia Cont Agencia Cont Cont. B.Off. Agencia do Contrato Agencia del Contrato Contract Bank Office @! ExistCpo("SE9",M->EH_CONTRAT+M->EH_BCOCONT+M->EH_AGECONT) x x x x x x x x x x x x x x x x - - 1 x x - - - N - - - - - - - - Fa171Apl() - 008 - S - - N N N - - 001 1 2 - - - 132984 0
SEH 17 EH_CTACONT C 10 0 Conta Contr. Cuenta Contr Cont. C.Acc. Conta do Contrato Cuenta del Contrato Contract Current Account @! ExistCpo("SA6",M->EH_BCOCONT+M->EH_AGECONT+M->EH_CTACONT) x x x x x x x x x x x x x x x x - - 1 x x - - - N - - - - - - - - Fa171Apl() - 009 - S - - N N N - - 001 1 2 - - - 132985 0
SEH 18 EH_VALOR N 14 2 Vlr.Operacao Vl.Operacion Operation Vl Valor da Operacao Valor de la Operaci¾n Operation Value @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 xx xx - S - S - - - positivo() - - - - INCLUI - - - S - - N N N - - 001 1 1 - - - 132986 0
SEH 19 EH_MOEDA N 2 0 Moeda Moneda Currency Moeda da Operacao Moneda de la Operaci¾n Currency of Operation 99 Positivo() .and. Fa171AtuVl(.T.) x x x x x x x x x x x x x x x x 01 - 1 xx - S - N - - - - - - - - INCLUI - - - S - - N N N - - 001 1 1 - - - 132987 0
SEH 20 EH_DATARES D 8 0 DT Resg/Pgto Fc Ret./Pago Red/Paym Dt. Dt Resgate/Pagamento Fecha Rescate/Pago Redemption/Payment Date - M->EH_DATARES>=M->EH_DATA.Or.Vazio() x x x x x x x x x x x x x x x x - - 1 x x - - - S - - - - - - - - - - - - S - - N N N - - 001 1 2 - - - 132988 0
SEH 21 EH_IMPOSTO N 6 2 %Outros Imp. % Otros Imp. %Other Taxes % Outros Impostos % Otros Impuestos % Other Taxes @E 999.99 - x x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - positivo() - - - - INCLUI - - - S - - N N N - - 002 1 2 - - - 132989 0
SEH 22 EH_TAXAIRF N 5 2 %Imposto IRF %Imp.Gananc. % Income Tax % IRRF % Impuesto a Ganancias IRRF Percentage @E 99.99 - x x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - INCLUI - - - S - - N N N - - 002 1 2 - - - 132990 0
SEH 23 EH_TAXAIOF N 5 2 %Imposto IOF %Imp.Op.Fin. % Tx.Fin.Op. %Imposto IOF %Impuesto Op.Financieras % Tax on Fin.Operations @E 99.99 - x x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - Fa171Cdi() - - - S - - N N N - - 002 1 2 - - - 132991 0
SEH 24 EH_TXIRSWP N 5 2 %IRF s/ SWAP %IGA sinSWAP In.Tx.s/SWAP %Imposto de Renda s/ SWAP %Imp.Ganancias sin SWAP %Income Tax over SWAP @E 99.99 - x x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - Fa171Apl() - - - S - - N N N - - 002 1 2 - - - 132992 0
SEH 25 EH_VALIOF N 14 2 Valor do IOF Valor de IOF IOF Value Valor do IOF Valor Imp Op. Financieras Financial Oper.Tax Value @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - Fa171Cdi() - - - S - - N N N - - 002 1 2 - - - 132993 0
SEH 26 EH_VALREG N 14 2 Vlr.Resgate Vlr Retirada Redemp.Val. Valor Resgate/Pagamento Valor Retirada/Pago Redemption/Payment Value @E 999,999,999.99 - x x x x x x x x x x x x x x x - - 1 xx x x - - - N V - - - - - - - - - - - S - - N N N - - - 1 2 - - - 132994 0
SEH 27 EH_VALIRF N 14 2 Valor IRF Valor Im.Gan IRF Value Valor do IRF Valor Impuesto Ganancias Income Tax Value @E 999,999,999.99 - x x x x x x x x x x x x x x x - - 1 xx x x - - - N V - - - - - - - - - - - S - - N N N - - - 1 2 - - - 132995 0
SEH 28 EH_VALSWAP N 14 2 Valor Swap Valor Swap Swap Value Valor Swap Valor SWAP Swap Value @E 999,999,999.99 - x x x x x x x x x x x x x x x - - 1 xx x x - - - N V - - - - - - - - - - - S - - N N N - - - 1 2 - - - 132996 0
SEH 29 EH_VALISWP N 14 2 Vlr Ir.Swap Vlr.Ir. Swap With.Tx.SWAP Vlr Ir. Swap Vlr. Ir. SWAP Income Tax over SWAP @E 999,999,999.99 - x x x x x x x x x x x x x x x - - 1 xx x x - - - N V - - - - - - - - - - - S - - N N N - - - 1 2 - - - 132997 0
SEH 30 EH_VALJUR N 14 2 Valor Juros Intereses Inter.Rate Valor do Juros Vlr Intereses Interest Rate @E 999,999,999.99 - x x x x x x x x x x x x x x x - - 1 xx x x - - - N V - - - - - - - - - - - S - - N N N - - - 1 2 - - - 132998 0
SEH 31 EH_VALCORR N 14 2 Vlr.Correcao Correccion Index. Val. Vlr da Correcao Monetaria Vlr Correccion Monetaria Indexation Value @E 999,999,999.99 - x x x x x x x x x x x x x x x - - 1 xx x x - - - N V - - - - - - - - - - - S - - N N N - - - 1 2 - - - 132999 0
SEH 32 EH_VALOUTR N 14 2 Vlr.Outros Vlr. Otros Other Taxes Valor de Outros Impostos Vlr. Otros Impuestos Other Taxes Value @E 999,999,999.99 - x x x x x x x x x x x x x x x - - 1 xx x - - - N V - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133000 0
SEH 33 EH_VALCRED N 14 2 Vlr.Credito Vlr. Credito Credit Value Valor do Credito Valor de Credito Credit Value @E 999,999,999.99 - x x x x x x x x x x x x x x x - - 1 xx x x - - - N V - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133001 0
SEH 34 EH_LA C 2 0 Lanc.Contab. Asiento Acct. Entry Lancamento Contabil Asiento Accounting Entry @! - x x x x x x x x x x x x x x x - - 1 x x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133002 0
SEH 35 EH_SALDO N 16 6 Saldo Saldo Balance Saldo da Operacao Saldo de la Operaci¾n Balance of Operation @E 999,999,999.999999 - x x x x x x x x x x x x x x x x - - 1 xx xx - - - S V - - - - - - - .F. - - - S - - N N N - - 001 1 1 - - - 133003 0
SEH 36 EH_ULTAPR D 8 0 Ult.Apropr. Ult.Apropia. Last Approp. Ultima Apropriacao Ultima Apropiacion Last Appropriation - - x x x x x x x x x x x x x x x - - 1 x x - - - N V - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133004 0
SEH 37 EH_GARANTE C 1 0 Apl.Garant. Apl.Garantia Applic.Guar. Aplicacao Garantida Inversion Garantizada Guaranteed Application @! Pertence("SN") x x x x x x x x x x x x x x x x "S" - 1 x x - - - N - - - - S=Sim;N=Nao S=Si;N=No S=Yes;N=No - M->EH_APLEMP=="APL" - - - S - - N N N - - 001 1 2 - - - 133005 0
SEH 38 EH_FORMULA C 3 0 Formula Formula Formula Formula de Calculo Formula del Calculo Calculation Formula @! Vazio().Or.ExistCpo("SM4") x x x x x x x x x x x x x x x x - SM4 1 x x - - - N - - - - - - - - - - - - S - - N N N - - 001 1 2 - - - 133006 0
SEH 39 EH_STATUS C 1 0 Status Estatus Status Status Estatus Status @! - x x x x x x x x x x x x x x x "A" - 1 x x - - - N V - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133007 0
SEH 40 EH_VLCRUZ N 14 2 Valor R$ Valor $ Value R$ Valor em Reais Valor en Moneda Corriente Value in Reais @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 xx x x - - - N V - - - - - - - .F. - - - S - - N N N - - 001 1 2 - - - 133008 0
SEH 41 EH_ACUJUR N 14 2 Acum. Juros Acum.Interes Inter.Accum. Valor Acumulado do Juros Vlr Acumulado del Interes Interest Acum. Value @e 999,999,999.99 - x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - Fa171Emp() - - - S - - N N N - - - 1 2 - - - 133009 0
SEH 42 EH_ACUJUR2 N 14 2 Acum.Juros 2 Acum.Inter.2 Inter.Accum2 Valor Acumulado do Juros2 Vlr Acumulado Interes 2 Interest Acum. Value 2 @e 999,999,999.99 - x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - Fa171Emp() - - - S - - N N N - - - 1 2 - - - 133010 0
SEH 43 EH_ACUVCCP N 14 2 Acum. VC CP Acum. VC CP Accum. VE CP Acumulado da V.Cambial CP Acumul. V.Cambial CP Acum.of Exch. Variat. CP @e 999,999,999.99 - x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - Fa171Emp() - - - S - - N N N - - - 1 2 - - - 133011 0
SEH 44 EH_ACUVCLP N 14 2 Acum. VC LP Acum. VC LP Accum. VE LP Acumulado da V.Cambial LP Acumul. V.Cambial LP Acum.of Exch. Variat. LP @e 999,999,999.99 - x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - Fa171Emp() - - - S - - N N N - - - 1 2 - - - 133012 0
SEH 45 EH_ACUVCJR N 14 2 Acu.VC Juros Acum.VC Int. Ac.Exch.Vl.I Acumulado V.Cambial Juros Acumul. V.Cambial Interes Acum. Exch. Variat.Inter. @e 999,999,999.99 - x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - Fa171Emp() - - - S - - N N N - - - 1 2 - - - 133013 0
SEH 46 EH_PERCPLP N 6 2 %Longo/Curto %Largo;Corto %Long/Short %Longo Prazo/Curto Prazo %Largo Plazo;Corto Plazo % Long Term/Short Term @e 999.99 - x x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - M->EH_PERCPLP<=100 - - - - Fa171Emp() - - - S - - N N N - - 001 1 2 - - - 133014 0
SEH 47 EH_VALVCJR N 14 2 Vlr VC Juros Vlr VC Inter Inter. Exch. Valor Var.Cambial Juros Valor Var. Cambio Interes Value Exchange Variance @e 999,999,999.99 - x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - Fa171Emp() - - - S - - N N N - - - 1 2 - - - 133015 0
SEH 48 EH_VALVCCP N 14 2 Vlr VC C.Prz Vlr VC C.Plz Val.EV STerm Vlr Var.Cambial Curto Prz Vlr Var.Camb.Corto Plazo Value Exch.Var.ShortTerm @e 999,999,999.99 - x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - Fa171Emp() - - - S - - N N N - - - 1 2 - - - 133016 0
SEH 49 EH_VALVCLP N 14 2 Vlr VC L.Prz Vlr VC L.Plz Val.EV LTerm Vlr Var.Cambial Longo Prz Vlr Var.Cambio Longo Plz Value Exch.Var.Long Term @e 999,999,999.99 - x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - Fa171Emp() - - - S - - N N N - - - 1 2 - - - 133017 0
SEH 50 EH_VALJUR2 N 14 2 Vlr Juros 2 Vlr Interes2 Interest 2C Valor do Juros na 2.moeda Vlr Interes en la 2a Mon. Interest Rate 2nd Curr. @e 999,999,999.99 - x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - Fa171Emp() - - - S - - N N N - - - 1 2 - - - 133018 0
SEH 51 EH_VALREG2 N 14 2 Vlr Resgat.2 Vlr Resg.2 Redempt. 2C Valor Resgate na 2.moeda Valor Retirada en 2a. Mon Redemption value 2nd Curr @e 999,999,999.99 - x x x x x x x x x x x x x x x - - 1 xx x x - - - N V - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133019 0
SEH 52 EH_VALGAP N 14 2 Vlr Gap Vlr GAP Gap Value Valor do Gap Valor del GAP Gap Value @e 999,999,999.99 - x x x x x x x x x x x x x x x - - 1 xx x x - - - N V - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133020 0
SEH 53 EH_CTRSWAP C 6 0 Control.Swap Control Swap Swap Control Controle Swap Control de Swap Swap Control @! - x x x x x x x x x x x x x x x x x x x x x x x - - 1 x x x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133021 0
SEH 54 EH_IMPOSWP N 6 2 %Impos swap. %Imp swap. % taxes swap % Outros Impostos no swap % Otros Imp en el swap % Other taxes in swap @E 999.99 - x x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - positivo() - - - - INCLUI - - - S - - N N N - - 002 1 2 - - - 133022 0
SEH 55 EH_VIOFSWP N 14 2 Valor do IOF Valor de IOF IOF Val. Valor do IOF Valor Imp Op. Financieras Financial Oper.Tax Value @E 99,999,999,999.99 - x x x x x x x x x x x x x x x - - 1 xx x x - - - N V - - - - - - - Fa171Cdi() - - - S - - N N N - - - 1 2 - - - 133023 0
SEH 56 EH_SLDCOTA N 16 8 Saldo Cotas Saldo Cotas Quota Bal. Saldo das cotas Saldo de cotas Quotas Balance @E 9,999,999.99999999 - x x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - .F. - - - S - - N N N - - 001 1 2 - - - 133024 0
SEH 57 EH_IRACUM N 12 2 IR Acumulado IR Acumulado Acc.Inc.Tax Controle de IR Acumulado Control de IR Acumulado Accum. Inc. Tax Control @E 999,999,999.99 - x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133025 0
SEH 58 EH_VLRCOTA N 16 8 Vlr. Cota Vlr. Cota Quota Value Valor da cota na aplic. Valor de cuota en invers. Quota Value in Applicat. @E 9,999,999.99999999 - x x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - .F. - - - S - - N N N - - 001 1 2 - - - 133026 0
SEH 59 EH_DTULTAT D 8 0 Ult. Atualiz Ult.Actualiz Last Update Data Ultima atualizacao Fecha Ultima actualizac. Last Updating Date - - x x x x x x x x x x x x x x x x x ddatabase - 1 x x - - - N V - - - - - - - .F. - - - S - - N N N - - - 1 2 - - - 133027 0
SEH 60 EH_TARIFA N 14 2 Tarifa Contr Tarifa Contr Hir. fee Tarifa de contratacao Tarifa de contratacion Hiring fee @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - Fa171Emp() - - - S - - N N N - - 004 1 2 - - - 133028 0
SEH 61 EH_IOFVIRT N 14 4 IOF Virtual IOF Virtual Virtual IOF Valor do IOF Virtual Valor de IOF Virtual Virtual IOF Value @E 999,999,999.9999 - x x x x x x x x x x x x x x x - - 1 xxxx - - - - - - - - - - - - Fa171Cdi() - - - N - - N N N - - - 1 2 - - - 133029 0
SEH 62 EH_DEBITO C 20 0 Cta Debito Cta. Debito Deb.Account Conta Debito Cuenta Debito Debit Account @! Vazio() .or. CTB105CTA() x x x x x x x x x x x x x x x - CT1 1 x x xx x - - - N A R - - - - - - - - 003 - S - - N N N - - 003 1 2 - - - 133030 0
SEH 63 EH_CCD C 9 0 C Custo Deb C.Costo Deb. C.Center Deb Centro de Custo Debito Centro Costo Debito Debit Cost Center @! Vazio() .or. CTB105CC() x x x x x x x x x x x x x x x - CTT 1 x x xx x - - - N A R - - - - - - CtbMovSaldo("CTT") - 004 - S - - N N N - - 003 1 2 - - - 133031 0
SEH 64 EH_ITEMD C 9 0 Item Debito Item Debito Deb.Item Item Contabil Debito Item Contable Debito Debit Accounting Item @! Vazio() .or. CTB105ITEM() x x x x x x x x x x x x x x x - CTD 1 x x xx x - - - N A R - - - - - - CtbMovSaldo("CTD") - 005 - S - - N N N - - 003 1 2 - - - 133032 0
SEH 65 EH_CLVLDB C 9 0 Cl Vlr Deb Clase Vlr.D. Deb.Vl.Cat. Classe Valor Debito Clase Valor Debito Debit Value Category @! Vazio() .or. CTB105CLVL() x x x x x x x x x x x x x x x - CTH 1 x x xx x - - - N A R - - - - - - CtbMovSaldo("CTH") - 006 - S - - N N N - - 003 1 2 - - - 133033 0
SEH 66 EH_CREDIT C 20 0 Cta Credito Cta Credito Crd.Account Conta Credito Cuenta Credito Credit Account @! Vazio() .or. CTB105CTA() x x x x x x x x x x x x x x x - CT1 1 x x xx x - - - N A R - - - - - - - - 003 - S - - N N N - - 003 1 2 - - - 133034 0
SEH 67 EH_CCC C 9 0 C Custo Crd C.Costo Crd. C.Center Crd Centro de Custo Credito Centro Costo Credito Credit Cost Center @! Vazio() .or. CTB105CC() x x x x x x x x x x x x x x x - CTT 1 x x xx x - - - N A R - - - - - - CtbMovSaldo("CTT") - 004 - S - - N N N - - 003 1 2 - - - 133035 0
SEH 68 EH_ITEMC C 9 0 Item Credito Item Credito Cred.Item Item Contabil Credito Item Contable Credito Credit Accounting Item @! Vazio() .or. CTB105ITEM() x x x x x x x x x x x x x x x - CTD 1 x x xx x - - - N A R - - - - - - CtbMovSaldo("CTD") - 005 - S - - N N N - - 003 1 2 - - - 133036 0
SEH 69 EH_CLVLCR C 9 0 Cl Vlr Cred Clase Vlr.C. Crd.Vl.Cat. Classe Valor Credito Clase Valor Credito Credit Value Category @! Vazio() .or. CTB105CLVL() x x x x x x x x x x x x x x x - CTH 1 x x xx x - - - N A R - - - - - - CtbMovSaldo("CTH") - 006 - S - - N N N - - 003 1 2 - - - 133037 0
SEH 70 EH_ULTPGIR D 8 0 Dt.Ult.Pg IR F.Ult.Pg IR Lst IR Pd Dt Data Ult. Pgto IRRF Fecha Ult. Pago IRRF Last IRRF Payt Date - - x x x x x x x x x x x x x x x - - 1 xx - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133038 0
SEH 71 EH_VLMOED N 14 2 Valor Moeda Valor Moneda Curr. Amount Valor Moeda Empréstimo Valor Moneda Prestamo Loan currency amount - - x x x x x x x x x x x x x x x - - 1 xxxx - - - - - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133039 0
SEH 72 EH_DIACTB C 2 0 Cod. Diario Cod. Diario Tax Rec. Cd. Cod. Diario da Contabilid Cod. Diario de la Contab. Accounting Tax Rec. Code @! VldCodSeq() x x x x x x x x x x x x x x x x CtbRDia() CVL 1 xx - - - - - - - - - - - - CtbWDia() - - - S - - N N N - - 003 1 2 - - - 133040 0
SEH 73 EH_NODIA C 10 0 Seq. Diario Sec. Diario Tax Rec. Seq Seq. Diario Contabilidade Sec. diario Contabilidad Acc. Tax Rec. Sequence @! - x x x x x x x x x x x x x x x x - - 1 xx - - - S V - - - - - - - - - - - S - - N N N - - 003 1 2 - - - 133041 0
SEH 74 EH_CLSIOF C 1 0 Cl CDI S/IOF Cl CDI S/IOF CDI S/IOF Cl Classif CDI Clasif CDI CDI Classif. @! Pertence("12") x x x x x x x x x x x x x x x x x - - 1 xx x - - - N A R - - 1=(CDCA / LCA / CRA);2=Outros 1=(CDCA / LCA / CRA);2=Otros 1=(CDCA / LCA / CRA);2=Others - - - - - S - - N - N - - 001 1 2 - - - 133042 0
SEH 75 EH_TPCUSTD C 1 0 Tipo Custd. Tipo Custd. Cust.Type Tipo de Custodia Tipo de custodia Custody Type @! - x x x x x x x x x x x x x x x x - - 1 xx - - - N A R - - 1=CETIP;2=SELIC;3=CBLC;4=Fundos Dedicados;5=Outros 1=CETIP;2=SELIC;3=CBLC;4=Fondos dedicados;5=Otros 1=CETIP;2=SELIC;3=CBLC;4=Dedicated Funds;5=Others - - - - - S - - N - N - - - 1 2 - - - 133043 0
SEH 76 EH_DATVENC D 8 0 Data Venc. Fch. Venc. Due Date Data de Vencimento Fecha de vencimiento Due Date - M->EH_DATVENC > M->EH_DATA x x x x x x x x x x x x x x x x - - 1 xx - - - N A R - - - - - - - - - - S - - N - N - - 001 1 2 - - - 133044 0
SEH 77 EH_TPOUTR C 50 0 Tp. Outros Tp. Otros Others Type Tipo Outros Tipo otros Others Type @! Empty(M->EH_TPBEM) .Or. M->EH_TPCUSTD = "5" x x x x x x x x x x x x x x x x - - 1 xx - - - N A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 133045 0
SEH 78 EH_TPBEM C 4 0 Tipo Bem Tipo bien Asset Type Tipo Bem Tipo bien Asset Type @! Vazio() .Or. ExistCpo("SX5",If(Empty(M->EH_TPCUSTD),"GF","GE") + M->EH_TPBEM) x x x x x x x x x x x x x x x x - X5GEGF 1 xx - - - N A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 133046 0
SEH 79 EH_VINCANS C 1 0 Vinculo ANS Vínculo ANS ANS Link Vinculo ANS Vínculo ANS ANS Link @! - x x x x x x x x x x x x x x x x - - 1 xx - - - N A R - - 1=Sim;2=Nao         1=Sí;2=No         1=Yes,2=No - - - - - S - - N - N - - - 1 2 - - - 133047 0
SEH 80 EH_CCUSTO C 9 0 C. de Custo C. de Costo Cost C. Centro de Custo Centro de Costo Cost Center @! Vazio() .Or. ExistCpo('CTT') x x x x x x x x x x x x x x x x - CTT 1 xx - - - N A R - - - - - - - - 004 - S - - N - N - - 003 1 2 - - - 133048 0
SEH 81 EH_GERPARC C 1 0 Gera Parcela Gen. Cuota Gen Install Gera Parcelas Genera cuotas Generate Installments @! M->EH_APLEMP == "EMP" .And. M->EH_TIPO $ "EMP|TEM" x x x x x x x x x x x x x x x x - - 1 xxx x - - - S - - - - 1=Sim;2=Nao 1=Sí;2=No 1=Yes;2=No - M->EH_APLEMP == "EMP" .And. M->EH_TIPO $ "EMP|TEM" - - - S - - N - N - - 004 1 2 - - - 133049 0
SEH 82 EH_ENTRADA N 14 2 V.Entrada V.Entrada Dwn Paym Vl Valor da Entrada Valor de entrada Down Payment Value @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 xxx x - S - S - - - - - - - - INCLUI .And. FC171VEnt() - - - S - - N - N - - 004 2 2 - - - 133050 0
SEH 83 EH_FINANC N 14 2 V.Financiado V.Financiado Financed Vl Valor Financiado Valor financiado Financed Value @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 xxx x - - - S - - - - - - - - .F. - - - S - - N - N - - 004 2 2 - - - 133051 0
SEH 84 EH_PRAZO N 3 0 Prazo Plazo Term Prazo Emprestimo Plazo préstamo Loan Term @E 999 FC171VPAR(M->EH_PRAZO) x x x x x x x x x x x x x x x x - - 1 xxx x - - - S - - - - - - - - INCLUI .and. FCl171Emp() - - - S - - N - N - - 004 2 2 - - - 133052 0
SEH 85 EH_CARENCI N 3 0 Carencia Carencia Grc Prd Tempo de Carencia Tiempo de carencia Grace Period @E 999 - x x x x x x x x x x x x x x x x - - 1 xxx x - - - S - - - - - - - - FCl171Emp() - - - S - - N - N - - 004 2 2 - - - 133053 0
SEH 86 EH_TXEFETI N 9 5 Taxa Efetiva Tasa Efectiv Effec Rate Taxa Efetiva Contrato Tasa efectiva contrato Contract Effective Rate @E 999.99999 - x x x x x x x x x x x x x x x x - - 1 xxx x - - - S - - - - - - - - INCLUI - - - S - - N - N - - 004 2 2 - - - 133054 0
SEH 87 EH_SPREAD N 14 2 V.Spread V.Spread Spread Vl Spread Bancario Spread bancario Bank Spread @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 xxx x - - - S - - - - - - - - FCl171Emp() - - - S - - N - N - - 004 2 2 - - - 133055 0
SEH 88 EH_PSPREAD N 9 5 % Spread % Spread % Spread % Spread bancario % Spread bancario % Spread bank @E 999.99999 - x x x x x x x x x x x x x x x x - - 1 xxx x - - - N - - - - - - - - FCl171Emp() - - - S - - N - N - - 004 1 2 - - - 133056 0
SEH 89 EH_DESPESA N 14 2 Despesas Gastos Expenses Despesas contrato Gastos contrato Contract Expenses @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 xxx x - - - - - - - - - - - - FCl171Emp() - - - S - - N - N - - 004 2 2 - - - 133057 0
SEH 90 EH_DSPREAD D 8 0 Data Spread Fecha Spread Spread Date Data do Spread Fecha del Spread Spread Date - - x x x x x x x x x x x x x x x x DDATABASE - 1 xxx x - - - - - - - - - - - - FCl171Emp() - - - S - - N - N - - 004 2 2 - - - 133058 0
SEH 91 EH_JURCAR C 1 0 Juros carenc Inter Carenc Grc per Int Parcela juros na carencia Cta Inter. Carenc. Interest Installm grace p @! Pertence("12") x x x x x x x x x x x x x x x x - - 1 xxx x - - - - - - - - 1=Sim;2=Nao 1=Sí;2=No 1=Yes;2=No - FCl171Emp() - - - S - - N - N - - 004 1 2 - - - 133059 0
SEH 92 EH_AMORTIZ C 1 0 Amortização Amortización Amortization Tipo de amortização Tipo de amortización Amortization type @! Pertence("12") x x x x x x x x x x x x x x x x - - 1 xxx x - - - S - - - - 1=Price;2=SAC 1=Price;2=SAC 1=Price;2=SAC - INCLUI .and. FCl171Emp() - - - S - - N - N - - 004 2 2 - - - 133060 0
SEH 93 EH_VLAMORP N 14 2 Vl.Amort Par Vl.Amort Cta Ins Amort Vl Valor amortização Parcela Valor amortización cuota Installm Amortiz Value @E 99,999,999,999.99 FC171VAm(M->EH_PRAZO) x x x x x x x x x x x x x x x x - - 1 xxx x - - - - - - - - - - - - INCLUI .and. FCl171Emp() - - - S - - N - N - - 004 1 2 - - - 133061 0
SEH 94 EH_BASEDES C 1 0 Desp. Base Gast. Base Exp Base Considera Despesa na base Consid. Gastos en la base Consider Expense in base - Pertence("12") x x x x x x x x x x x x x x x x "2" - 1 x xx x - - - N A R - - 1=Sim;2=Não 1=Sí;2=No 1=Yes;2=No - - - - - S - - N - N - - 004 1 2 - - - 133062 0
SEH 95 EH_TEMPLT M 10 0 Template Template Template Template de calculo Template de cálculo Calculation template - - x x x x x x x x x x x x x x x x - - 1 x - - - N A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 133063 0
SEH 96 EH_DATALIB D 8 0 DT Liberação Fch Liberaci Release DT Data Liberação Movimento Fecha Liberación Movimien Transaction Release Date - - x x x x x x x x x x x x x x x x - - 1 xx - - - N A R - - - - - - - - - - S - - N - N - - 001 1 2 - - - 133064 0
SEH 97 EH_FILORIG C 2 0 Filial Orig. Suc. Orig Orig. Branch Filial de origem Sucursal de origen Branch of Origin - VldFilOrig(M->EH_FILORIG) x x x x x x x x x x x x x x x - - 1 xx x - - - N A R - - - - - - - - 033 - S - - N - N - - - 1 1 - - - 133065 0
SEH 98 EH_CALCUSR C 1 0 Calc.User Cálc.User User Calc Calculo do Usuario Cálculo usuario User Calculation - Pertence("12 ") x x x x x x x x x x x x x x x x - - 1 xx - - - N A R - - 1=Sim;2=Nao 1=Sí;2=No 1=Yes;2=No - INCLUI .AND. M->EH_APLEMP == "EMP" - - - S - - N - N - - - 2 2 - - - 133066 0
SEH 99 EH_EC05DB C 16 0 Ent.Deb. 05 Ent.Deb. 05 Ent.Deb. 05 Ent. Contábil Debito 05 Ent. Contable Debito 05 Acc. Entity Debit 05 @! CTB105EntC(,M->EH_EC05DB,,'05') x x x x x x x x x x x x x x x x - CV0 0 xxxx x - - - S A R - - - - - - - - 040 - - - - - - - - - - - - - - - 177655 0
SEH 9A EH_EC05CR C 16 0 Ent.Cred. 05 Ent.Cred. 05 Cred.Ent. 05 Ent. Contábil Credito 05 Ent. Contable Credito 05 Acc. Entity Credit 05 @! CTB105EntC(,M->EH_EC05CR,,'05') x x x x x x x x x x x x x x x x - CV0 0 xxxx x - - - S A R - - - - - - - - 040 - - - - - - - - - - - - - - - 177656 0
SEH 9B EH_EC06DB C 16 0 Ent.Deb. 06 Ent.Deb. 06 Ent.Deb. 06 Ent. Contábil Debito 06 Ent. Contable Debito 06 Acc. Entity Debit 06 @! CTB105EntC(,M->EH_EC06DB,,'06') x x x x x x x x x x x x x x x x - CV0 0 xxxx x - - - S A R - - - - - - - - 042 - - - - - - - - - - - - - - - 177657 0
SEH 9C EH_EC06CR C 16 0 Ent.Cred. 06 Ent.Cred. 06 Cred.Ent. 06 Ent. Contábil Credito 06 Ent. Contable Credito 06 Acc. Entity Credit 06 @! CTB105EntC(,M->EH_EC06CR,,'06') x x x x x x x x x x x x x x x x - CV0 0 xxxx x - - - S A R - - - - - - - - 042 - - - - - - - - - - - - - - - 177658 0

Índices da Tabela SEH (5 í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_
SEH 1 EH_FILIAL+EH_NUMERO+EH_REVISAO Numero + Revisao Numero + Revision Number + Revision S - - S 2 3 - 19187 0
SEH 2 EH_FILIAL+EH_STATUS+EH_APLEMP Status + Modelo Estatus + Modelo Status + Model S - - S 2 3 - 19188 0
SEH 3 EH_FILIAL+EH_CONTRAT+EH_NUMERO Numero Contr + Numero Nro.Contrato + Numero Contract Nr. + Number S - - S 2 3 - 19189 0
SEH 4 EH_FILIAL+EH_BCOCONT+EH_AGECONT+EH_CTACONT+EH_CONTRAT Banco Contr. + Agencia Cont + Conta Contr. + Numero Contr Banco Contr. + Agencia Cont + Cuenta Contr + Nro.Contrato Contr. Bank + Cont. B.Off. + Cont. C.Acc. + Contract Nr. S - - N 2 3 - 19190 0
SEH 5 EH_FILIAL+EH_NODIA Seq. Diario Sec. Diario Tax Rec. Seq S - - S 2 3 - 19191 0

Perguntas frequentes

Para que serve a tabela SEH no Protheus?

Ela é utilizada para controle aplicação/emprestimo dentro do sistema ERP Protheus.

Como consultar os campos da tabela SEH?

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

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

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

Exemplo de consulta SQL da tabela SEH

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

SELECT
    EH_FILIAL,
    EH_NUMERO,
    EH_REVISAO,
    EH_APLEMP,
    EH_TIPO,
    EH_BANCO,
    EH_AGENCIA,
    EH_CONTA,
    EH_NBANCO,
    EH_NATUREZ,
    EH_DATA,
    EH_TAXA,
    EH_QUOTAS,
    EH_CONTRAT,
    EH_BCOCONT,
    EH_AGECONT,
    EH_CTACONT,
    EH_VALOR,
    EH_MOEDA,
    EH_DATARES,
    EH_IMPOSTO,
    EH_TAXAIRF,
    EH_TAXAIOF,
    EH_TXIRSWP,
    EH_VALIOF,
    EH_VALREG,
    EH_VALIRF,
    EH_VALSWAP,
    EH_VALISWP,
    EH_VALJUR,
    EH_VALCORR,
    EH_VALOUTR,
    EH_VALCRED,
    EH_LA,
    EH_SALDO,
    EH_ULTAPR,
    EH_GARANTE,
    EH_FORMULA,
    EH_STATUS,
    EH_VLCRUZ,
    EH_ACUJUR,
    EH_ACUJUR2,
    EH_ACUVCCP,
    EH_ACUVCLP,
    EH_ACUVCJR,
    EH_PERCPLP,
    EH_VALVCJR,
    EH_VALVCCP,
    EH_VALVCLP,
    EH_VALJUR2,
    EH_VALREG2,
    EH_VALGAP,
    EH_CTRSWAP,
    EH_IMPOSWP,
    EH_VIOFSWP,
    EH_SLDCOTA,
    EH_IRACUM,
    EH_VLRCOTA,
    EH_DTULTAT,
    EH_TARIFA,
    EH_IOFVIRT,
    EH_DEBITO,
    EH_CCD,
    EH_ITEMD,
    EH_CLVLDB,
    EH_CREDIT,
    EH_CCC,
    EH_ITEMC,
    EH_CLVLCR,
    EH_ULTPGIR,
    EH_VLMOED,
    EH_DIACTB,
    EH_NODIA,
    EH_CLSIOF,
    EH_TPCUSTD,
    EH_DATVENC,
    EH_TPOUTR,
    EH_TPBEM,
    EH_VINCANS,
    EH_CCUSTO,
    EH_GERPARC,
    EH_ENTRADA,
    EH_FINANC,
    EH_PRAZO,
    EH_CARENCI,
    EH_TXEFETI,
    EH_SPREAD,
    EH_PSPREAD,
    EH_DESPESA,
    EH_DSPREAD,
    EH_JURCAR,
    EH_AMORTIZ,
    EH_VLAMORP,
    EH_BASEDES,
    EH_TEMPLT,
    EH_DATALIB,
    EH_FILORIG,
    EH_CALCUSR,
    EH_EC05DB,
    EH_EC05CR,
    EH_EC06DB,
    EH_EC06CR
FROM SEH
WHERE
    D_E_L_E_T_ = ' '
    AND EH_FILIAL = 'VALOR'
    AND EH_NUMERO = 'VALOR'
    AND EH_REVISAO = 'VALOR'
    AND EH_APLEMP = 'VALOR'
    AND EH_TIPO = 'VALOR'
    AND EH_BANCO = 'VALOR'
    AND EH_AGENCIA = 'VALOR'
    AND EH_CONTA = 'VALOR'
    AND EH_NBANCO = 'VALOR'
    AND EH_NATUREZ = 'VALOR'
    AND EH_DATA BETWEEN '20260501' AND '20260531'
    AND EH_TAXA = 0
    AND EH_QUOTAS = 0
    AND EH_CONTRAT = 'VALOR'
    AND EH_BCOCONT = 'VALOR'
    AND EH_AGECONT = 'VALOR'
    AND EH_CTACONT = 'VALOR'
    AND EH_VALOR = 0
    AND EH_MOEDA = 0
    AND EH_DATARES BETWEEN '20260501' AND '20260531'
    AND EH_IMPOSTO = 0
    AND EH_TAXAIRF = 0
    AND EH_TAXAIOF = 0
    AND EH_TXIRSWP = 0
    AND EH_VALIOF = 0
    AND EH_VALREG = 0
    AND EH_VALIRF = 0
    AND EH_VALSWAP = 0
    AND EH_VALISWP = 0
    AND EH_VALJUR = 0
    AND EH_VALCORR = 0
    AND EH_VALOUTR = 0
    AND EH_VALCRED = 0
    AND EH_LA = 'VALOR'
    AND EH_SALDO = 0
    AND EH_ULTAPR BETWEEN '20260501' AND '20260531'
    AND EH_GARANTE = 'VALOR'
    AND EH_FORMULA = 'VALOR'
    AND EH_STATUS = 'VALOR'
    AND EH_VLCRUZ = 0
    AND EH_ACUJUR = 0
    AND EH_ACUJUR2 = 0
    AND EH_ACUVCCP = 0
    AND EH_ACUVCLP = 0
    AND EH_ACUVCJR = 0
    AND EH_PERCPLP = 0
    AND EH_VALVCJR = 0
    AND EH_VALVCCP = 0
    AND EH_VALVCLP = 0
    AND EH_VALJUR2 = 0
    AND EH_VALREG2 = 0
    AND EH_VALGAP = 0
    AND EH_CTRSWAP = 'VALOR'
    AND EH_IMPOSWP = 0
    AND EH_VIOFSWP = 0
    AND EH_SLDCOTA = 0
    AND EH_IRACUM = 0
    AND EH_VLRCOTA = 0
    AND EH_DTULTAT BETWEEN '20260501' AND '20260531'
    AND EH_TARIFA = 0
    AND EH_IOFVIRT = 0
    AND EH_DEBITO = 'VALOR'
    AND EH_CCD = 'VALOR'
    AND EH_ITEMD = 'VALOR'
    AND EH_CLVLDB = 'VALOR'
    AND EH_CREDIT = 'VALOR'
    AND EH_CCC = 'VALOR'
    AND EH_ITEMC = 'VALOR'
    AND EH_CLVLCR = 'VALOR'
    AND EH_ULTPGIR BETWEEN '20260501' AND '20260531'
    AND EH_VLMOED = 0
    AND EH_DIACTB = 'VALOR'
    AND EH_NODIA = 'VALOR'
    AND EH_CLSIOF = 'VALOR'
    AND EH_TPCUSTD = 'VALOR'
    AND EH_DATVENC BETWEEN '20260501' AND '20260531'
    AND EH_TPOUTR = 'VALOR'
    AND EH_TPBEM = 'VALOR'
    AND EH_VINCANS = 'VALOR'
    AND EH_CCUSTO = 'VALOR'
    AND EH_GERPARC = 'VALOR'
    AND EH_ENTRADA = 0
    AND EH_FINANC = 0
    AND EH_PRAZO = 0
    AND EH_CARENCI = 0
    AND EH_TXEFETI = 0
    AND EH_SPREAD = 0
    AND EH_PSPREAD = 0
    AND EH_DESPESA = 0
    AND EH_DSPREAD BETWEEN '20260501' AND '20260531'
    AND EH_JURCAR = 'VALOR'
    AND EH_AMORTIZ = 'VALOR'
    AND EH_VLAMORP = 0
    AND EH_BASEDES = 'VALOR'
    AND EH_DATALIB BETWEEN '20260501' AND '20260531'
    AND EH_FILORIG = 'VALOR'
    AND EH_CALCUSR = 'VALOR'
    AND EH_EC05DB = 'VALOR'
    AND EH_EC05CR = 'VALOR'
    AND EH_EC06DB = 'VALOR'
    AND EH_EC06CR = 'VALOR'