Enterprise Solutions

DepAcctHist

Operational Data Integration (ODI) > ODI Extracts > CIF2020 > DepAcctHist

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

CIF2020 Dlt Delete Record Flag 1 SrcKey Unique Record Key 69 FornKey Account Detail 17 AcctId Account number DDHIST TRACCT 9 16 AcctType Account type TRATYP TrnStat Status TRSTAT TrnCodeCode Transaction code TRANCD 2 3 TrnCodeDesc Tran Code Description DDPAR3 DESC 30 PostDt Transaction date TRDATE 4 7 Amt Transaction amount AMT 6 11 BatchNum Batch number BATCH SeqNum Sequence number SEQ 10 SrcCodeDesc Source Description 25 TrnType Debit/Credit Code DORC AffCode Affects Balance/Interest BORI ImgNum Image Item # IMAGE# 8 15 EffDt Effective date TREFFD ChkNum Check number SERIAL StmtPasCode No book flag NOBOOK PayeeName Check Payee CKPAYEE 50 TrnUsrId User ID DDUSRID PostOrderId Posted Sequence PSTSQ# ACHStdEntryClass ACH Standard Entry Class ACHSEC ACHRecId ACH Record Id 35 HistRecId History Record Id 38

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