DepAcctHist
Operational Data Integration (ODI)
>
ODI Extracts
>
Silverlake
>
DepAcctHist
Extract to provide deposit account history information (shows rows that have been deleted since the last extract was created)
Silverlake
Dlt
Delete Record Flag
1
FornKey
Account Detail
17
AcctId
Account number
DDHIST
TRACCT
9
16
SrcKey
Unique Record Key
69
AcctType
Account type
TRATYP
TrnStat
Status
TRSTAT
TrnCodeDesc
Tran Code Description
DDPAR3
DESC
30
PostDt
Transaction date
TRDATE
4
7
BatchNum
Batch number
BATCH
3
SeqNum
Sequence number
SEQ
6
10
SrcCodeDesc
Source Description
25
TrnType
Debit/Credit Code
DORC
AffCode
Affects Balance/Interest
BORI
TrnCodeCode
Transaction code
5
ImgNum
Image Item #
IMAGE#
8
15
EffDt
Effective date
TREFFD
ChkNum
Check number
SERIAL
Amt
Transaction amount
13
2
StmtPasCode
No book flag
NOBOOK
OldRate
Old rate
TRRATE
PayeeName
Check Payee
CKPAYEE
50
TrnUsrId
User ID
DDUSRID
PostOrderId
Posted Sequence
PSTSQ#
ACHCompName
ACH Company Name
ACHCON
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