| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| SEH | Controle Aplicacao/Emprestimo | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| EH_FILIAL | C | 2 | 0 | Filial | S | ||||||
| EH_NUMERO | C | 6 | 0 | Numero | @9 | ExistChav("SEH") .AND. FreeForUse("SEH",M->EH_NUMERO) | INCLUI | S | |||
| EH_REVISAO | C | 2 | 0 | Revisao | @9 | INCLUI | S | ||||
| EH_APLEMP | C | 3 | 0 | Modelo | @! | Pertence("APL|EMP") .And. Fa171Nat() | APL=Aplicacao;EMP=Emprestimo | INCLUI | S | ||
| EH_TIPO | C | 3 | 0 | Operacao | @! | Fa171Opera() | 11 | INCLUI | S | ||
| EH_BANCO | C | 3 | 0 | Banco | @! | ExistCpo('SA6',,,,,.F.) | SA6 | INCLUI | S | ||
| EH_AGENCIA | C | 5 | 0 | Agencia | @! | INCLUI | S | ||||
| EH_CONTA | C | 10 | 0 | Conta Banco | @! | existcpo("SA6",M->EH_BANCO+M->EH_AGENCIA+M->EH_CONTA) .AND. !CCBLOCKED(M->EH_BANCO,M->EH_AGENCIA,M->EH_CONTA) | INCLUI | S | |||
| EH_NBANCO | C | 20 | 0 | Inst.Financ. | @S15! | S | |||||
| EH_NATUREZ | C | 10 | 0 | Natureza | @! | FinVldNat(.F.,M->EH_NATUREZ) | SED | INCLUI | S | ||
| EH_DATA | D | 8 | 0 | DT Operacao | M->EH_DATA==ddatabase | INCLUI | S | ||||
| EH_TAXA | N | 9 | 5 | Taxa Nominal | @E 999.99999 | positivo() | S | ||||
| EH_QUOTAS | N | 16 | 8 | Qtd.Cota/Tit | @E 9,999,999.99999999 | Fa171Apl() | S | ||||
| EH_CONTRAT | C | 15 | 0 | Numero Contr | @! | ExistCpo("SE9") .And. V181Contrat(m->eh_contrat) | SE9 | Fa171Apl() | S | ||
| EH_BCOCONT | C | 3 | 0 | Banco Contr. | @! | ExistCpo("SE9",M->EH_CONTRAT+M->EH_BCOCONT) | SA6 | Fa171Apl() | S | ||
| EH_AGECONT | C | 5 | 0 | Agencia Cont | @! | ExistCpo("SE9",M->EH_CONTRAT+M->EH_BCOCONT+M->EH_AGECONT) | Fa171Apl() | S | |||
| EH_CTACONT | C | 10 | 0 | Conta Contr. | @! | ExistCpo("SA6",M->EH_BCOCONT+M->EH_AGECONT+M->EH_CTACONT) | Fa171Apl() | S | |||
| EH_VALOR | N | 14 | 2 | Vlr.Operacao | @E 999,999,999.99 | INCLUI | S | ||||
| EH_MOEDA | N | 2 | 0 | Moeda | 99 | Positivo() .and. Fa171AtuVl(.T.) | INCLUI | S | |||
| EH_DATARES | D | 8 | 0 | DT Resg/Pgto | M->EH_DATARES>=M->EH_DATA.Or.Vazio() | S | |||||
| EH_IMPOSTO | N | 6 | 2 | %Outros Imp. | @E 999.99 | INCLUI | S | ||||
| EH_TAXAIRF | N | 5 | 2 | %Imposto IRF | @E 99.99 | INCLUI | S | ||||
| EH_TAXAIOF | N | 5 | 2 | %Imposto IOF | @E 99.99 | Fa171Cdi() | S | ||||
| EH_TXIRSWP | N | 5 | 2 | %IRF s/ SWAP | @E 99.99 | Fa171Apl() | S | ||||
| EH_VALIOF | N | 14 | 2 | Valor do IOF | @E 99,999,999,999.99 | Fa171Cdi() | S | ||||
| EH_VALREG | N | 14 | 2 | Vlr.Resgate | @E 999,999,999.99 | S | |||||
| EH_VALIRF | N | 14 | 2 | Valor IRF | @E 999,999,999.99 | S | |||||
| EH_VALSWAP | N | 14 | 2 | Valor Swap | @E 999,999,999.99 | S | |||||
| EH_VALISWP | N | 14 | 2 | Vlr Ir.Swap | @E 999,999,999.99 | S | |||||
| EH_VALJUR | N | 14 | 2 | Valor Juros | @E 999,999,999.99 | S | |||||
| EH_VALCORR | N | 14 | 2 | Vlr.Correcao | @E 999,999,999.99 | S | |||||
| EH_VALOUTR | N | 14 | 2 | Vlr.Outros | @E 999,999,999.99 | S | |||||
| EH_VALCRED | N | 14 | 2 | Vlr.Credito | @E 999,999,999.99 | S | |||||
| EH_LA | C | 2 | 0 | Lanc.Contab. | @! | S | |||||
| EH_SALDO | N | 16 | 6 | Saldo | @E 999,999,999.999999 | .F. | S | ||||
| EH_ULTAPR | D | 8 | 0 | Ult.Apropr. | S | ||||||
| EH_GARANTE | C | 1 | 0 | Apl.Garant. | @! | Pertence("SN") | S=Sim;N=Nao | M->EH_APLEMP=="APL" | S | ||
| EH_FORMULA | C | 3 | 0 | Formula | @! | Vazio().Or.ExistCpo("SM4") | SM4 | S | |||
| EH_STATUS | C | 1 | 0 | Status | @! | S | |||||
| EH_VLCRUZ | N | 14 | 2 | Valor R$ | @e 999,999,999.99 | .F. | S | ||||
| EH_ACUJUR | N | 14 | 2 | Acum. Juros | @e 999,999,999.99 | Fa171Emp() | S | ||||
| EH_ACUJUR2 | N | 14 | 2 | Acum.Juros 2 | @e 999,999,999.99 | Fa171Emp() | S | ||||
| EH_ACUVCCP | N | 14 | 2 | Acum. VC CP | @e 999,999,999.99 | Fa171Emp() | S | ||||
| EH_ACUVCLP | N | 14 | 2 | Acum. VC LP | @e 999,999,999.99 | Fa171Emp() | S | ||||
| EH_ACUVCJR | N | 14 | 2 | Acu.VC Juros | @e 999,999,999.99 | Fa171Emp() | S | ||||
| EH_PERCPLP | N | 6 | 2 | %Longo/Curto | @e 999.99 | Fa171Emp() | S | ||||
| EH_VALVCJR | N | 14 | 2 | Vlr VC Juros | @e 999,999,999.99 | Fa171Emp() | S | ||||
| EH_VALVCCP | N | 14 | 2 | Vlr VC C.Prz | @e 999,999,999.99 | Fa171Emp() | S | ||||
| EH_VALVCLP | N | 14 | 2 | Vlr VC L.Prz | @e 999,999,999.99 | Fa171Emp() | S | ||||
| EH_VALJUR2 | N | 14 | 2 | Vlr Juros 2 | @e 999,999,999.99 | Fa171Emp() | S | ||||
| EH_VALREG2 | N | 14 | 2 | Vlr Resgat.2 | @e 999,999,999.99 | S | |||||
| EH_VALGAP | N | 14 | 2 | Vlr Gap | @e 999,999,999.99 | S | |||||
| EH_CTRSWAP | C | 6 | 0 | Control.Swap | @! | S | |||||
| EH_IMPOSWP | N | 6 | 2 | %Outros Imp. | @E 999.99 | INCLUI | S | ||||
| EH_VIOFSWP | N | 14 | 2 | Valor do IOF | @E 99,999,999,999.99 | Fa171Cdi() | S | ||||
| EH_SLDCOTA | N | 16 | 8 | Saldo Cotas | @E 9,999,999.99999999 | .F. | S | ||||
| EH_IRACUM | N | 12 | 2 | IR Acumulado | @E 999,999,999.99 | S | |||||
| EH_VLRCOTA | N | 16 | 8 | Vlr. Cota | @E 9,999,999.99999999 | .F. | S | ||||
| EH_DTULTAT | D | 8 | 0 | Ult. Atualiz | .F. | S | |||||
| EH_TARIFA | N | 14 | 2 | Tarifa Contr | @E 999,999,999.99 | Fa171Emp() | S | ||||
| EH_IOFVIRT | N | 14 | 4 | IOF Virtual | @E 999,999,999.9999 | Fa171Cdi() | N | ||||
| EH_DEBITO | C | 20 | 0 | Cta Debito | @! | Vazio() .or. CTB105CTA() | CT1 | R | S | ||
| EH_CCD | C | 9 | 0 | C Custo Deb | @! | Vazio() .or. CTB105CC() | CTT | R | CtbMovSaldo("CTT") | S | |
| EH_ITEMD | C | 9 | 0 | Item Debito | @! | Vazio() .or. CTB105ITEM() | CTD | R | CtbMovSaldo("CTD") | S | |
| EH_CLVLDB | C | 9 | 0 | Cl Vlr Deb | @! | Vazio() .or. CTB105CLVL() | CTH | R | CtbMovSaldo("CTH") | S | |
| EH_CREDIT | C | 20 | 0 | Cta Credito | @! | Vazio() .or. CTB105CTA() | CT1 | R | S | ||
| EH_CCC | C | 9 | 0 | C Custo Crd | @! | Vazio() .or. CTB105CC() | CTT | R | CtbMovSaldo("CTT") | S | |
| EH_ITEMC | C | 9 | 0 | Item Credito | @! | Vazio() .or. CTB105ITEM() | CTD | R | CtbMovSaldo("CTD") | S | |
| EH_CLVLCR | C | 9 | 0 | Cl Vlr Cred | @! | Vazio() .or. CTB105CLVL() | CTH | R | CtbMovSaldo("CTH") | S | |
| EH_ULTPGIR | D | 8 | 0 | Dt.Ult.Pg IR | S | ||||||
| EH_VLMOED | N | 14 | 2 | Valor Moeda | S | ||||||
| EH_DIACTB | C | 2 | 0 | Cod. Diario | @! | VldCodSeq() | CVL | CtbWDia() | S | ||
| EH_NODIA | C | 10 | 0 | Seq. Diario | @! | S | |||||
| EH_CLSIOF | C | 1 | 0 | Cl CDI S/IOF | @! | R | 1=(CDCA / LCA / CRA);2=Outros | S | |||
| EH_CCUSTO | C | 9 | 0 | C. de Custo | @! | Vazio() .Or. ExistCpo('CTT') | CTT | R | S | ||
| EH_AMORTIZ | C | 1 | 0 | Amortizacao | @! | 1=Price;2=SAC | INCLUI .and. FCl171Emp() | S | |||
| EH_ENTRADA | N | 14 | 2 | V.Entrada | @E 99,999,999,999.99 | INCLUI .And. FC171VEnt() | S | ||||
| EH_DSPREAD | D | 8 | 0 | Data Spread | FCl171Emp() | S | |||||
| EH_DESPESA | N | 14 | 2 | Despesas | @E 99,999,999,999.99 | FCl171Emp() | S | ||||
| EH_SPREAD | N | 14 | 2 | V.Spread | @E 99,999,999,999.99 | FCl171Emp() | S | ||||
| EH_GERPARC | C | 1 | 0 | Gera Parcela | @! | M->EH_APLEMP == "EMP" .And. M->EH_TIPO == "EMP" | 1=Sim;2=Nao | M->EH_APLEMP == "EMP" .And. M->EH_TIPO == "EMP" | S | ||
| EH_FINANC | N | 14 | 2 | V.Financiado | @E 99,999,999,999.99 | .F. | S | ||||
| EH_PSPREAD | N | 9 | 5 | % Spread | @E 999.99999 | FCl171Emp() | S | ||||
| EH_VLAMORP | N | 14 | 2 | Vl.Amort Par | @E 99,999,999,999.99 | FC171VAm(M->EH_PRAZO) | INCLUI .and. FCl171Emp() | S | |||
| EH_TXEFETI | N | 9 | 5 | Taxa Efetiva | @E 999.99999 | INCLUI | S | ||||
| EH_CARENCI | N | 3 | 0 | Carencia | @E 999 | FCl171Emp() | S | ||||
| EH_JURCAR | C | 1 | 0 | Juros carenc | @! | 1=Sim;2=Nao | FCl171Emp() | S | |||
| EH_PRAZO | N | 3 | 0 | Prazo | @E 999 | FC171VPAR(M->EH_PRAZO) | INCLUI .and. FCl171Emp() | S | |||
| EH_TPCUSTD | C | 1 | 0 | Tipo Custd. | @! | R | 1=CETIP;2=SELIC;3=CBLC;4=Fundos Dedicados;5=Outros | S | |||
| EH_DATVENC | D | 8 | 0 | Data Venc. | M->EH_DATVENC > M->EH_DATA | R | S | ||||
| EH_TPOUTR | C | 50 | 0 | Tp. Outros | @! | Empty(M->EH_TPBEM) .Or. M->EH_TPCUSTD = "5" | R | S | |||
| EH_TPBEM | C | 4 | 0 | Tipo Bem | @! | Vazio() .Or. ExistCpo("SX5",If(Empty(M->EH_TPCUSTD),"GF","GE") + M->EH_TPBEM) | X5GEGF | R | S | ||
| EH_VINCANS | C | 1 | 0 | Vinculo ANS | @! | R | 1=Sim;2=Nao | S | |||
| EH_BASEDES | C | 1 | 0 | Desp. Base | R | 1=Sim;2=Nao | S | ||||