Controle Aplicação/Emprestimo
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.
| 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 |
| 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 |
| 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 |
Ela é utilizada para controle aplicação/emprestimo dentro do sistema ERP Protheus.
Nesta página você pode visualizar todos os campos, incluindo tipo, tamanho e validações.
Os índices são estruturas que melhoram a performance de busca e acesso aos dados dentro do Protheus.
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'