LnAcctHist
ODI Extracts
>
CIF2020
>
LnAcctHist
Extract to provide loan account history information (shows rows that have been deleted since the last extract was created)
| Provider | Element | Element Description | Reference File | Reference Field | Field Type | Length | Digits | Decimal Places |
|---|---|---|---|---|---|---|---|---|
| CIF2020 | Dlt | Delete Record Flag | String | 1 | 0 | 0 | ||
| CIF2020 | SrcKey | Unique Record Key | String | 50 | 0 | 0 | ||
| CIF2020 | FornKey | Account Detail | String | 17 | 0 | 0 | ||
| CIF2020 | AcctId | Account Number | Integer | 9 | 16 | 0 | ||
| CIF2020 | AcctType | Account Type | String | 1 | 0 | 0 | ||
| CIF2020 | TrnCodeCode | Tran Code | Integer | 3 | 5 | 0 | ||
| CIF2020 | TrnCodeDesc | Tran Code Description | String | 40 | 0 | 0 | ||
| CIF2020 | PostDt | Posting Date | Integer | 4 | 7 | 0 | ||
| CIF2020 | Amt | Transaction Amount | Integer | 6 | 11 | 2 | ||
| CIF2020 | BatchNum | Batch Number | Integer | 3 | 4 | 0 | ||
| CIF2020 | SeqNum | Sequence Number | Integer | 6 | 10 | 0 | ||
| CIF2020 | SrcCodeDesc | Source Description | String | 25 | 0 | 0 | ||
| CIF2020 | TrnType | Dr/Cr Code | String | 1 | 0 | 0 | ||
| CIF2020 | AffCode | Affects Code | String | 2 | 0 | 0 | ||
| CIF2020 | ImgNum | Image Item # | Integer | 8 | 15 | 0 | ||
| CIF2020 | EffDt | Effective Date | Integer | 4 | 7 | 0 | ||
| CIF2020 | ChkNum | Serial number | Integer | 6 | 10 | 0 | ||
| CIF2020 | PmtDueDt | Payment Due Date | Integer | 4 | 7 | 0 | ||
| CIF2020 | PostSeq | Posted Sequence | Integer | 4 | 7 | 0 | ||
| CIF2020 | OldRate | Old Rate | Integer | 5 | 9 | 8 | ||
| CIF2020 | NewRate | New Rate | Integer | 5 | 9 | 8 | ||
| CIF2020 | TrnUsrId | User ID | String | 10 | 0 | 0 | ||
| CIF2020 | HistRecId | History Record Id | String | 50 | 0 | 0 |
Have a Question?
Have a how-to question? Seeing a weird error? Get help on
StackOverflow.
Register for the Developer Office Hours
where we answer technical Q&A from the audience.
Did this page help you?
Last updated Fri Feb 21 2025