DepExcTrnDetail
ODI Extracts
>
CIF2020
>
DepExcTrnDetail
Extract to provide Exception Item Transaction details
| 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 | Deposit Exception Detail | String | 17 | 0 | 0 | ||
| CIF2020 | EFTDescSrcKey | ACH Code | Integer | 7 | 13 | 0 | ||
| CIF2020 | AcctId | Account number | Integer | 9 | 16 | 0 | ||
| CIF2020 | AcctType | Account type | String | 1 | 0 | 0 | ||
| CIF2020 | UpdAcctId | Account Number | Integer | 9 | 16 | 0 | ||
| CIF2020 | UpdAcctType | Account Type | String | 1 | 0 | 0 | ||
| CIF2020 | SeqNum | Sequence Number | Integer | 3 | 5 | 0 | ||
| CIF2020 | BatchNum | Batch Number | Integer | 3 | 4 | 0 | ||
| CIF2020 | ChkNum | Check number | Integer | 6 | 10 | 0 | ||
| CIF2020 | UpdChkNum | Check number | Integer | 6 | 10 | 0 | ||
| CIF2020 | Amt | Amount | Integer | 6 | 11 | 2 | ||
| CIF2020 | ExcRetSrcCode | Return Source Code | String | 2 | 0 | 0 | ||
| CIF2020 | ExcRetSrcDesc | Return Source Desc | String | 40 | 0 | 0 | ||
| CIF2020 | ExcUsrId | User Id | String | 24 | 0 | 0 | ||
| CIF2020 | ExcAuditWsId | Workstation Id | String | 24 | 0 | 0 | ||
| CIF2020 | TrnCodeCode | Tran Code | Integer | 3 | 5 | 0 | ||
| CIF2020 | TrnCodeDesc | Tran Code Desc | String | 40 | 0 | 0 | ||
| CIF2020 | UpdTrnCodeCode | New Tran Code | Integer | 3 | 5 | 0 | ||
| CIF2020 | UpdTrnCodeDesc | New Tran Code Desc | String | 40 | 0 | 0 | ||
| CIF2020 | PostDt | Tran Date | Integer | 4 | 7 | 0 | ||
| CIF2020 | EffDt | Effective Date | Integer | 4 | 7 | 0 | ||
| CIF2020 | ChngTime | Time Change Made | Integer | 4 | 6 | 0 | ||
| CIF2020 | ExcDispCode | Disposition Code | String | 2 | 0 | 0 | ||
| CIF2020 | ExcDispDesc | Disposition Code Desc | String | 40 | 0 | 0 | ||
| CIF2020 | ExcRetRsnCode | Return Reason | String | 2 | 0 | 0 | ||
| CIF2020 | ExcRetRsnDesc | Return Reason Desc | String | 40 | 0 | 0 | ||
| CIF2020 | ExcActnCode | Action Code | String | 2 | 0 | 0 | ||
| CIF2020 | ExcActnDesc | Action Code Desc | String | 40 | 0 | 0 | ||
| CIF2020 | ExcResolveType | Resolve Type | String | 1 | 0 | 0 | ||
| CIF2020 | ExcRsnCode1 | Reason Code | String | 2 | 0 | 0 | ||
| CIF2020 | ExcRsnDesc1 | Reason Desc | String | 35 | 0 | 0 | ||
| CIF2020 | ExcRsnCode2 | Reason Code 2 | String | 2 | 0 | 0 | ||
| CIF2020 | ExcRsnDesc2 | Reason Desc 2 | String | 35 | 0 | 0 | ||
| CIF2020 | ExcRsnCode3 | Reason Code 3 | String | 2 | 0 | 0 | ||
| CIF2020 | ExcRsnDesc3 | Reason Desc 3 | String | 35 | 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