Developer Programs

Learn

Docs
Important notification about upcoming changes to the DMZ environment. Please read.

DepAcct

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

Extract to provide the Deposit Account master file details

Silverlake 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 AcctStat Status STATUS AcctStatDesc Status Decription 25 CurBal Current balance CBAL 13 2 CustId Customer Id 8 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 NetMemoPostAmt 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 TellerSICCode Special instruction code TLRINQ TellerSICDesc Teller Special Inst Desc 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 DormantChgWav Dormant Waive Code OpenDt Date Opened DATOP7 ClsDt Date Closed DTCLS7 ElecStmtType Only Statement Type LangType Language Code DDLANG MinBal Minimum balance MINBAL HighStmtBal Maximum balance HGHBAL AvgStmtColBal Agr Col Bal This Qtr QAGCOL 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 CallRptCode Call report code CALLREP ClubPln Club plan XMASPL MTDODFee OD charge MTD ODCHGM MTDSerChgFee M-T-D Fees FEEMTD MTDRetChkFee Returned ck chg MTD RTCKCM MTDOthFee Month to date fees charged DDMTDFEECG MTDWavSerChgFee M-T-D Service chg waived MTDSCW MTDWavODFee OD charge waived MTD ODWVEM MTDWavRetChkFee Returned ck wve MTD RTCKWM MTDWavOthFee Month to date Waived DDMTDWAIVE AnlysAcct A/A code AACODE AccrMeth Acc Method ACMETH AccrMethDesc Accrued Method Desc ClsOnZeroBal Close on zero balance NOCLOS FedWithCode Fed W/H code WHCODE StateWithCode State W/H code WHSCOD ChgdOffAmt Charged-off amount CGOAMT ClsRsnCode Closed reason Code DDCLOSEDRS ClsRsnDesc Closed Description DDPAR5 P5CLOSEDDS 40 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 EscheatDt Date Last Escheat DTESC7 GLCostCtr GL Cost Center GLCOST DormantDt Date Last Dormant DTDOR7 AggCurBalIntCycleAmt Aggr ledger bal Int cyc AGGAMI AggIntCycleDay Aggregate days Int cycle AGGDAI IntCycle Interest Cr cycle INTCYC LastDepAmt Amt of last deposit AMTDP LastWthdwlAmt Amt of last withdrawal AMTLWD 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# ATMOnUsCrMTDAmt Amt of Onus ATM credits ATCRAO ATMOnUsDrMTDAmt Amt of Onus ATM dedits ATDRAO ATMOnUsMTDCnt No. of Onus ATM credits ATCRNO ATMOnUsDrMTDCnt No. of Onus ATM debits ATDRNO MTDIntPaid M-T-D Interest paid MTDINT NSFItemsMTD Items NSF This cyc ITMNSF NSFTimesMTD Times NSF MTD TIMNFM AggODCycleAmt Agg Led balance negative AGGCON ODDaysMTD Days OD This cyc DYSOD ODItemsMTD Items OD This cyc ITMOD SerChgCrItemsCnt Number S/C credits SCCRC SerChgDrItemsCnt Number S/C debits SCDRC NSFAmt Amount NSF AMTNSF ODLmtCode Overdraft limit code ODLMT NSFItemsRet Items Returns This cyc ITMRT CRASMSACode SMSA Number SMSA CRASMSADesc LNPAR503 L5DESC 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 YestColBal YESCOL NSFFeesYTD YTD NSF Fees YTDNSF 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 ChgBackItemsQTD Chg Back Itm qtr CGIBK1 LastPayDt Last Interest Paid DLINP7 AmtLastIntPd Amt of last int Pd LINTPD OrigAcctId Original Account Id ATMCard ATM Card StdIndustCode Standard Industrial Classification Code StdIndustDesc Standard Industrial Classification Desc CurQtrMinBal Quarter minimum balance CurQtrMaxBal Quarter maximum balance 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 MonthAvgBalAmt M-T-D Average Available Balance GroupCode GL Group Code GLProdCode GL Product Code MTDAvgColBal 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 BrandCode Brand Code 10 BrandDesc Brand Description 50 NSFItemsYTD NSF Year to Date Items NSFTimesYTD NSF Year to Date Times StopCondNotfType Stop code HldCondNotfType Hold Exists AlrtCondNotfType Alert Exists SpecInstrCondNotfType Special Instructions Exists 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