Enterprise Solutions

DepAcctHist

Operational Data Integration (ODI) > ODI Extracts > Core Director > DepAcctHist

Extract to provide deposit account history information (shows rows that have been deleted since the last extract was created)

Core Director Dlt Delete record flag String 1 SrcKey Unique record key HISTRY.ISM HIST_FULL_KEY 32 FornKey Account key HIST_KEY 18 AcctId Account Number HIST_ACCT 16 AcctType Account Type HIST_ACCT_TYPE 2 TrnCodeCode Tran Code HIST_TRAN_CODE Int32 3 TrnCodeDesc Tran Code Description TDESCR.DDF TCDESC 25 PostDt Tran Date HIST_TRAN_DATE DateTime 8 Amt Tran Amount HIST_TRAN_AMT Decimal 12 SeqNum Sequence Number HIST_PROOF_SEQ 6 SrcCodeDesc Source Code Description Calculated based on HIST_TRAN_SOURCE 60 TrnType Transaction Type TCDRCR (if TCDRCR blank, determined from TCADD) AffCode Rate Change Calculated base on Rate Change Tran Codes 15 ImgNum Image number HIST_DSI_ITEM_SEQ Int64 EffDt Posted Date HIST_POSTED_DATE ChkNum Check Number HIST_CHECK_NUMBER 10 ACHStdEntryClass Secondary Source of Transaction HIST_TRAN_SECONDARY_SOURCE StmtPasCode Passbook flag Calculated based on 282 (SAV) 4 OldRate Old Interest Rate 7 NewRate New Interest Rate TellerNum Teller Number HIST_TELLER_NO PayeeName Payee Calculated based on HIST_EXTEND_DESCRIPTION_1, _2, _3 105 TrnStat Do Not Show Transaction Calculated based on HIST_NOSHOW

Have a Question?
Have a how-to question? Seeing a weird error? Get help on StackOverflow.
Register for the Digital Toolkit Meetup where we answer technical Q&A from the audience.
Last updated Tue Apr 16 2024