Enterprise Solutions

DepAcct

Operational Data Integration (ODI) > ODI Extracts > Core Director > DepAcct

Extract to provide the Deposit Account master file details

Core Director Dlt Delete record flag MASTER.ISM String 1 SrcKey Unique record key MASTER_PRIMARY_KEY 18 FornKey Account key AcctId Account Number 3 16 AcctType Account Type 2 CustId CIF Number 9 AcctStat Account status 20 AcctStatDesc Account status desc USRCOD.ISM USER_DESCRIPTION 40 CurBal Current Balance 126 (DDA,SAV) Decimal AvlBal Memo Balance 127 (DDA,SAV) ColBal Collected Balance 284 (DDA) 286 (SAV) HldAmt Total Hold Amount 388 (DDA) 283(SAV) FltAmt Float Amount 147 (DDA) 13 ODPrvlgAmt Avail Cr Safety Chk 285 (DDA) NetMemoPostAmt 126 (DDA, SAV) - 127 (DDA, SAV) LastStmtDt Last Statement Date 133 (DDA, SAV) DateTime 8 LastDepDt Last Deposit Date 132 (DDA, SAV) LastConDt Date Last Contact 28 HldMailCode Mail Code 15 HldMailDesc Mail Code Description LastActDt Last Activity Date Newest of 131 (DDA, SAV), 132(DDA, SAV) BrCode Branch Number BrDesc Branch Description ProdCode Product Code 38 6 ProdDesc Product Description WDSTRG.ISM DSDSC AcctClsfCode Call Class 23 AcctClsfDesc Call Class Description IntBearAcct Int bearing account Calculated based on 138 (DDA, SAV) 5 TellerSICCode SIC Code 53 StdIndustCode StdIndustDesc SIC Code Description OffCode Officer Initials 14 OffDesc Officer Description SerChgWav Service Charge Waive Code 366 (DDA) TINCode Tax ID Code 92 TINDesc Tax ID Description TaxId SSN/EIN 10 OpenDt Date Opened 17 ClsDt Closing Date 48 ElecStmtType ESI Statements 927 POSCardIssuedNum Num ATM Cards Iss 57 Int32 ATMCardIssuedNum ATMCard ATMCard true/false Calculated StopCondNotfType Stop's Exist true/false HldCondNotfType Hold's Exist true/false AlrtCondNotfType Alert's Exist true/false MinBal Low Balance Amount 202 (DDA) 164 (SAV) AvgStmtColBal AvgStmtLdgrBal AbbName Short Name 36 IntRate Interest Rate 138 (DDA, SAV) 7 4 AccrInt Interest Earned 156 (DDA) 144 (SAV) PrevYTDIntPaid PYr Interest Paid 64 12 YTDInt YTD Interest Paid 157 (DDA) 146 (SAV) ClubPln Club Chg Type Code 228 (DDA) AnlysAcct Service Charge Code Calculated based on DDA 139 AccrMeth Accrual Method Calculated based on DDA 135, SAV 154 AccrMethDesc Accrual Method Description ClsOnZeroBal Auto-Close? 239 (DDA) 198 (SAV) FedWithCode Interest W/H Code 93 ChgdOffAmt Charged Off Amount LastODDt Date Last Overdraft 143 (DDA) ConsDaysOD Consecutive Days OD 142 (DDA) 310 SAV AggCurBalIntCycleAmt AggIntCycleDay LastDepAmt Last Deposit Amount 153 (DDA) 148 (SAV) LastWthdwlAmt Last Withdrawal Amount 152 (DDA) 147 (SAV) LastSerChgDt Date Last Service Charge 181 (SAV) LmtTrnAcctType Limited Transaction Account 60 ACHCrCycleCnt CTD ACH Credits 427 (DDA) ACHDrCycleCnt CTD ACH Debits 426 (DDA) ATMOnUsCrMTDCnt Total ATM on us credits 335 - 336 (DDA) 257 - 258 (SAV) ATMOnUsDRMTDCnt Total ATM on us debits 297 - 298 (DDA) 249 - 250 (SAV) AggODCycleAmt Reg E Agg OD Bal 488 (DDA) ODDaysMTD Days O/D this month 219 (DDA) SerChgCrItemsCnt CTD Ser Chg Credits 252 (DDA) 180 (SAV) SerChgDrItemsCnt CTD Ser Chg Debits 251 (DDA) 179 (SAV) NSFAmt NSF Today 173 (DDA) 153 (SAV) CRASMSACode MSA Code 50 AutoNSFFee NSF Item Fee Calculated based on bank and account settings RateRevDt Rate Revision Date ChgdOffDt Date Charged Off 287 (DDA) 313 (SAV) StmtCycle Statement cycle code 150 (DDA) StmtBal Last Stmt Bal 130 (DDA, SAV) NSFTimesQTD BNC NSF Items QTD 442 (DDA) NSFTimesPrevQtr BNC NSF Items Last QTR 446 (DDA) YestBal Yesterday's Balance 95 YestColBal Yesterday's Collected Balance 95-332 (DDA) 95-264 (SAV) NSFFeesYTD Return Item Chgs YTD 414 (DDA) 304 (SAV) ODFeesYTD O/D Chgs YTD 413 (DDA) 303 (SAV) SerChgFeesYTD YTD Service Charge 159 (DDA) 151 (SAV) 11 SerChgFeesWavYTD Ser Chgs Waived YTD 368 (DDA) 278 (SAV) OneDayFlt 1-Day Float 144 (DDA) 156 (SAV) TwoDayFlt 2-Day Float 145 (DDA) 157 (SAV) ThreeDayFlt 3-Day Float 146 (DDA) 158 (SAV) FourDayFlt 4-Day Float 215 (DDA) 184 (SAV) FiveDayFlt 5-Day Float 216 (DDA) 185 (SAV) LastPayDt Date Int Last Paid 172 (SAV) AmtLastIntPd Interest Last Paid 145 (SAV) DormantDt Dormant Date 46 AggCurBalCycleAmt CTD Aggregate Balance 128 (DDA, SAV) ODLmt Overdraft Limit 162 (DDA) MonthAvgBalAmt GroupCode G/L Code 25 Custom.ACCOUNT_CHARGED_OFF Charged Off 238 (DDA) EstbPersonName CDD Person Opening 944 30 EstbPersonTitle CDD Person Title 945 NSFItemsYTD YTD NSF Presented 290 NSFTimesYTD YTD Overdrawn Days 140

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