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