LnAcctHist
Operational Data Integration (ODI)
>
ODI Extracts
>
Silverlake
>
LnAcctHist
Extract to provide loan account history information (shows rows that have been deleted since the last extract was created)
Silverlake
Dlt
Delete Record Flag
1
SrcKey
Unique Record Key
31
FornKey
Account Detail
17
AcctId
Account Number
LNHIST
LHACCT
9
16
AcctType
Account Type
LHATYP
TrnStat
Transaction Status
LHSTAT
TrnCodeCode
Tran Code
LHTRAN
3
5
TrnCodeDesc
Tran Code Description
LNPAR3
L3TCDS
40
PostDt
Posting Date
LHPSTD
4
7
Amt
Transaction Amount
LHAMT
6
11
2
BatchNum
Batch Number
LHBAT#
SeqNum
Sequence Number
LHSEQ#
10
SrcCodeDesc
Source Description
25
TrnType
Dr/Cr Code
LHDORC
AffCode
Affects Code
LHAFFT
ImgNum
Image Item #
IMAGE#
8
15
EffDt
Effective Date
LHEFDT
ChkNum
Serial number
LHSERL
PmtDueDt
Payment Due Date
LHDUDT
PostSeq
Posted Sequence
LHPSQ#
SplitPostSeq
CQ tran Sequence
LHCQSQ
OldRate
Old Rate
LHORAT
NewRate
New Rate
LHNRAT
TrnUsrId
User ID
LHMUID
ACHStdEntryClass
ACH Standard Entry Class
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