Enterprise Solutions

DepAcct

Operational Data Integration (ODI) > ODI Extracts > CIF2020 > DepAcct

Extract to provide the Deposit Account master file details

CIF2020 Dlt Delete Record Flag 1 SrcKey Unique Record Key 17 FornKey Customer Key 7 AcctId Account number DDMAST ACCTNO 9 16 AcctType Account type ACTYPE CustId CIF number AcctStat Status STATUS AcctStatDesc Status Decription 25 CurBal Current balance CBAL 13 2 AvlBal Available balance ABAL ColBal Collected balance COLECT HldAmt Hold amount HOLD FltAmt Total Accrual Float TTFLOT RegCCAmt Tot Availibility Float TTFLAV ODProtAmt Protection Amount AvlSweepAmt Sweep Amount NetMemoPostAmt Memo Amount DDMEMO ODLmt OD limit DDPAR6 LIMIT 6 11 ODPrvlgAmt Privledge Amount LastStmtDt Last Statement DLSTM7 4 LastDepDt Last Deposit DTLDP7 LastConDt Last Contact DLC7 HldMailCode Hold mail MALHLD HldMailDesc Hold mail description JHMAIL JHMDES 35 LastActDt Last Active DLA7 BrCode Branch number BRANCH 3 BrDesc Bank/branch name JHDATA JDNAME 30 ProdCode Service charge code SCCODE ProdDesc S/C description DDPAR2 PSCDES 20 AcctClsfCode Class CLASS AcctClsfDesc Class description JHCLAS JHCDES 15 IntBearAcct Accrue Int? ACCODE SigVerifyCode Signature verify SGCODE SigVerifyDesc Verify Sig Desc OffCode Officer OFFICR OffDesc Officer name JHOFFR JHONAM SerChgWav Service charge type SCTYPE SalesPerson Sales Associate SALESAC SerChgWavRsnCode Waive Reason Code WRWVCODE SerChgWavRsnDesc Waive Reason Description DDPARWR WRWVRESN TINCode TIN status CFMAST CFTINS TINDesc Description CFPART TXDESC TaxId Tax ID number CFSSNO 5 OpenDt Date Opened DATOP7 ClsDt Date Closed DTCLS7 MinBal Minimum balance MINBAL HighStmtBal Maximum balance HGHBAL AvgStmtColBal Agr Col Bal This Qtr QAGCOL 8 AvgStmtLdgrBal Agr Led Bal This Qtr QAGBAL AbbName Short name SNAME IntRate Interest Rate RATE AccrInt Accrued interest ACCRUE PrevYTDIntPaid Previous YTD int LYTDIN YTDInt YTD interest YTDINT ClubPln Club plan XMASPL MTDODFee OD charge MTD ODCHGM MTDRetChkFee Returned ck chg MTD RTCKCM MTDWavSerChgFee M-T-D Service chg waived MTDSCW MTDWavODFee OD charge waived MTD ODWVEM MTDWavRetChkFee Returned ck wve MTD RTCKWM AnlysAcct A/A code AACODE AccrMeth Acc Method ACMETH AccrMethDesc Accrued Method Desc FedWithCode Fed W/H code WHCODE ChgdOffAmt Charged-off amount CGOAMT AggCurBalCycleAmt Aggregate ledg this stmt AGGAMS AggCycleDay Aggregate days this stmt AGGDAS LastODDt Last Overdrawn DTOD7 ConsDaysNSF Consec days NSF CDYNSF ConsDaysOD Consec days OD CDYOD ODTimesMTD Times OD MTD TIMODM ODTimesQTD Times OD this qtr TIMOD1 ODTimesPrevQtr Times OD 2nd qtr TIMOD2 DormantDt Date Last Dormant DTDOR7 IntCycle Interest Cr cycle INTCYC LastDepAmt Amt of last deposit AMTDP LastSerChgDt Date Last Service Charge DLSVCHG7 LmtTrnAcctType Track Excess Drs? TRKEDR ACHCrCycleAmt ACH credits s/c cycle ACHCR$ ACHDrCycleAmt ACH debits s/c cycle ACHDR$ ACHCrCycleCnt ACHCR# ACHDrCycleCnt ACHDR# MTDIntPaid M-T-D Interest paid MTDINT NSFItemsMTD Items NSF This cyc ITMNSF ODDaysMTD Days OD This cyc DYSOD ODItemsMTD Items OD This cyc ITMOD SerChgCrItemsCnt Number S/C credits SCCR SCCRC SerChgDrItemsCnt Number S/C debits SCDR SCDRC ODLmtCode Overdraft limit code ODLMT NSFItemsRet Items Returns This cyc ITMRT CRASMSACode SMSA Number SMSA CRASMSADesc LNPAR503 L5DESC 40 AutoNSFFee Automatic NSF charge AUTNSF RateRevDt Rate review date REVDT7 AmtCrMTD Amt of credits AMTCRM AmtDrMTD Amt of debits AMTDRM ChkGuar Check guaranty card CHKGTY ChgdOffDt Date Last Charged Off DTCHO7 NumCrMTD Number of credits NOCRM NumDrMTD Number of debits NODRM NumRetChkMTD No.returned check MTD RETCKM StmtCycle Statement cycle STCYC StmtBal Previous stmt bal STMBAL ODTimes3Qtr Times OD 3rd qtr TIMOD3 ODTimes4Qtr Times OD 4th qtr TIMOD4 NSFTimesQTD Times NSF This Qtr TMNFQ1 NSFTimesPrevQtr Times NSF 2nd Qtr TMNFQ2 NSFTimes3Qtr Times NSF 3rd Qtr TMNFQ3 NSFTimes4Qtr Times NSF 4th Qtr TMNFQ4 YestBal Yesterday balance YBAL ODFeesYTD YTD OD Fees YTDODF SerChgFeesYTD YTD S/C YTDSC SerChgFeesWavYTD Y-T-D Service chg waived YTDSCW OneDayFlt Day 1 Float AGGAMT TwoDayFlt Day 2 Float ThreeDayFlt Day 3 Float FourDayFlt Day 4 Float FiveDayFlt Day 5 Float LastPayDt Last Interest Paid DLINP7 AmtLastIntPd Amt of last int Pd LINTPD ATMCard ATM Card StdIndustCode Standard Industrial Classification Code StdIndustDesc Standard Industrial Classification Desc CurQtrMinBal Quarter minimum balance CurQtrMaxBal Quarter maximum balance EFTODPrvlgOptVal Card Opt in/out TrnAmtCurDayDr Trn Debit CurDay Amt TrnAmtPrevDayDr Trn Debit PrevDay Amt TrnCntCurDayDr Trn Debit CurDay Cnt TrnCntPrevDayDr Trn Debit PrevDay Cnt TrnAmtCurDayCr Trn Credit CurDay Amt TrnAmtPrevDayCr Trn Credit PrevDay Amt TrnCntCurDayCr Trn Credit CurDay Cnt TrnCntPrevDayCr Trn Credit PrevDay Cnt GroupCode GL Group Code GLProdCode GL Product Code MTDAvgColBal M-T-D Average Available Balance M-T-D Average Collected Balance PrimeRateIdx Rate Number RateVar Rate Variance RateVarCode Rate Variance Code EstbPersonName Name of person opening account EstbPersonTitle Title of person opening account 70 NSFItemsYTD NSF Year to Date Items NSFTimesYTD NSF Year to Date Times StopCondNotfType Stop code HldCondNotfType Hold code AlrtCondNotfType Alert code SpecInstrCondNotfType Special inst code CurBalDailyClsAmt Current Balance Daily Close Amount AvlBalDailyClsAmt Available Balance Daily Close Amount ColBalDailyClsAmt Collected Balance Daily Close Amount

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