DepAcct

ODI Extracts > Silverlake > DepAcct

Extract to provide the Deposit Account master file details

Provider	Element	Element Description	Reference File	Reference Field	Field Type	Length	Digits	Decimal Places
Silverlake	Dlt	Delete Record Flag			String	1	0	0
Silverlake	SrcKey	Unique Record Key			String	17	0	0
Silverlake	FornKey	Customer Key			String	7	0	0
Silverlake	AcctId	Account number	DDMAST	ACCTNO	Integer	9	16	0
Silverlake	AcctType	Account type	DDMAST	ACTYPE	String	1	0	0
Silverlake	AcctStat	Status	DDMAST	STATUS	Integer	1	1	0
Silverlake	AcctStatDesc	Status Decription			String	25	0	0
Silverlake	CurBal	Current balance	DDMAST	CBAL	Integer	7	13	2
Silverlake	CustId	Customer Id			String	8	0	0
Silverlake	AvlBal	Available balance	DDMAST	ABAL	Integer	7	13	2
Silverlake	ColBal	Collected balance	DDMAST	COLECT	Integer	7	13	2
Silverlake	HldAmt	Hold amount	DDMAST	HOLD	Integer	7	13	2
Silverlake	FltAmt	Total Accrual Float	DDMAST	TTFLOT	Integer	7	13	2
Silverlake	RegCCAmt	Tot Availibility Float	DDMAST	TTFLAV	Integer	7	13	2
Silverlake	ODProtAmt	Protection Amount	DDMAST	CBAL	Integer	7	13	2
Silverlake	AvlSweepAmt	Current balance	DDMAST	CBAL	Integer	7	13	2
Silverlake	NetMemoPostAmt	Current balance	DDMEMO	CBAL	Integer	7	13	2
Silverlake	ODLmt	OD limit	DDPAR6	LIMIT	Integer	6	11	2
Silverlake	ODPrvlgAmt	Privledge Amount	DDMAST	CBAL	Integer	7	13	2
Silverlake	LastStmtDt	Last Statement	DDMAST	DLSTM7	Integer	4	7	0
Silverlake	LastDepDt	Last Deposit	DDMAST	DTLDP7	Integer	4	7	0
Silverlake	LastConDt	Last Contact	DDMAST	DLC7	Integer	4	7	0
Silverlake	HldMailCode	Hold mail	DDMAST	MALHLD	String	1	0	0
Silverlake	HldMailDesc	Hold mail description	JHMAIL	JHMDES	String	35	0	0
Silverlake	LastActDt	Last Active	DDMAST	DLA7	Integer	4	7	0
Silverlake	BrCode	Branch number	DDMAST	BRANCH	Integer	2	3	0
Silverlake	BrDesc	Bank/branch name	JHDATA	JDNAME	String	30	0	0
Silverlake	ProdCode	Service charge code	DDMAST	SCCODE	String	2	0	0
Silverlake	ProdDesc	S/C description	DDPAR2	PSCDES	String	20	0	0
Silverlake	AcctClsfCode	Class	DDMAST	CLASS	String	1	0	0
Silverlake	AcctClsfDesc	Class description	JHCLAS	JHCDES	String	15	0	0
Silverlake	IntBearAcct	Accrue Int?	DDPAR2	ACCODE	String	1	0	0
Silverlake	TellerSICCode	Special instruction code	DDMAST	TLRINQ	String	1	0	0
Silverlake	TellerSICDesc	Teller Special Inst Desc			String	25	0	0
Silverlake	SigVerifyCode	Signature verify	DDMAST	SGCODE	String	1	0	0
Silverlake	SigVerifyDesc	Verify Sig Desc			String	25	0	0
Silverlake	OffCode	Officer	DDMAST	OFFICR	String	6	0	0
Silverlake	OffDesc	Officer name	JHOFFR	JHONAM	String	30	0	0
Silverlake	SerChgWav	Service charge type	DDMAST	SCTYPE	String	1	0	0
Silverlake	SalesPerson	Sales Associate	DDMAST	SALESAC	String	15	0	0
Silverlake	SerChgWavRsnCode	Waive Reason Code	DDMAST	WRWVCODE	String	2	0	0
Silverlake	SerChgWavRsnDesc	Waive Reason Description	DDPARWR	WRWVRESN	String	30	0	0
Silverlake	TINCode	TIN status	CFMAST	CFTINS	String	1	0	0
Silverlake	TINDesc	Description	CFPART	TXDESC	String	20	0	0
Silverlake	TaxId	Tax ID number	CFMAST	CFSSNO	Integer	5	9	0
Silverlake	DormantChgWav	Dormant Waive Code	DDMAST	SCTYPE	String	1	0	0
Silverlake	OpenDt	Date Opened	DDMAST	DATOP7	Integer	4	7	0
Silverlake	ClsDt	Date Closed	DDMAST	DTCLS7	Integer	4	7	0
Silverlake	ElecStmtType	Only Statement Type			String	1	0	0
Silverlake	LangType	Language Code	DDMAST	DDLANG	String	3	0	0
Silverlake	MinBal	Minimum balance	DDMAST	MINBAL	Integer	6	11	0
Silverlake	HighStmtBal	Maximum balance	DDMAST	HGHBAL	Integer	6	11	0
Silverlake	AvgStmtColBal	Agr Col Bal This Qtr	DDMAST	QAGCOL	Integer	8	15	2
Silverlake	AvgStmtLdgrBal	Agr Led Bal This Qtr	DDMAST	QAGBAL	Integer	8	15	2
Silverlake	AbbName	Short name	DDMAST	SNAME	String	20	0	0
Silverlake	IntRate	Interest Rate	DDMAST	RATE	Integer	5	9	8
Silverlake	AccrInt	Accrued interest	DDMAST	ACCRUE	Integer	7	13	5
Silverlake	PrevYTDIntPaid	Previous YTD int	DDMAST	LYTDIN	Integer	7	13	2
Silverlake	YTDInt	YTD interest	DDMAST	YTDINT	Integer	7	13	2
Silverlake	CallRptCode	Call report code	DDMAST	CALLREP	String	8	0	0
Silverlake	ClubPln	Club plan	DDMAST	XMASPL	Integer	1	1	0
Silverlake	MTDODFee	OD charge MTD	DDMAST	ODCHGM	Integer	6	11	2
Silverlake	MTDSerChgFee	M-T-D Fees	DDMAST	FEEMTD	Integer	5	9	2
Silverlake	MTDRetChkFee	Returned ck chg MTD	DDMAST	RTCKCM	Integer	6	11	2
Silverlake	MTDOthFee	Month to date fees charged	DDMAST	DDMTDFEECG	Integer	6	11	2
Silverlake	MTDWavSerChgFee	M-T-D Service chg waived	DDMAST	MTDSCW	Integer	5	9	2
Silverlake	MTDWavODFee	OD charge waived MTD	DDMAST	ODWVEM	Integer	6	11	2
Silverlake	MTDWavRetChkFee	Returned ck wve MTD	DDMAST	RTCKWM	Integer	6	11	2
Silverlake	MTDWavOthFee	Month to date Waived	DDMAST	DDMTDWAIVE	Integer	6	11	2
Silverlake	AnlysAcct	A/A code	DDMAST	AACODE	String	1	0	0
Silverlake	AccrMeth	Acc Method	DDPAR2	ACMETH	String	1	0	0
Silverlake	AccrMethDesc	Accrued Method Desc			String	25	0	0
Silverlake	ClsOnZeroBal	Close on zero balance	DDMAST	NOCLOS	String	1	0	0
Silverlake	FedWithCode	Fed W/H code	DDMAST	WHCODE	Integer	1	1	0
Silverlake	StateWithCode	State W/H code	DDMAST	WHSCOD	Integer	1	1	0
Silverlake	ChgdOffAmt	Charged-off amount	DDMAST	CGOAMT	Integer	7	13	2
Silverlake	ClsRsnCode	Closed reason Code	DDMAST	DDCLOSEDRS	String	2	0	0
Silverlake	ClsRsnDesc	Closed Description	DDPAR5	P5CLOSEDDS	String	40	0	0
Silverlake	AggCurBalCycleAmt	Aggregate ledg this stmt	DDMAST	AGGAMS	Integer	8	15	2
Silverlake	AggCycleDay	Aggregate days this stmt	DDMAST	AGGDAS	Integer	2	3	0
Silverlake	LastODDt	Last Overdrawn	DDMAST	DTOD7	Integer	4	7	0
Silverlake	ConsDaysNSF	Consec days NSF	DDMAST	CDYNSF	Integer	3	5	0
Silverlake	ConsDaysOD	Consec days OD	DDMAST	CDYOD	Integer	3	5	0
Silverlake	ODTimesMTD	Times OD MTD	DDMAST	TIMODM	Integer	3	5	0
Silverlake	ODTimesQTD	Times OD this qtr	DDMAST	TIMOD1	Integer	2	3	0
Silverlake	ODTimesPrevQtr	Times OD 2nd qtr	DDMAST	TIMOD2	Integer	2	3	0
Silverlake	EscheatDt	Date Last Escheat	DDMAST	DTESC7	Integer	4	7	0
Silverlake	GLCostCtr	GL Cost Center	DDMAST	GLCOST	Integer	3	4	0
Silverlake	DormantDt	Date Last Dormant	DDMAST	DTDOR7	Integer	4	7	0
Silverlake	AggCurBalIntCycleAmt	Aggr ledger bal Int cyc	DDMAST	AGGAMI	Integer	8	15	2
Silverlake	AggIntCycleDay	Aggregate days Int cycle	DDMAST	AGGDAI	Integer	3	5	0
Silverlake	IntCycle	Interest Cr cycle	DDMAST	INTCYC	Integer	2	2	0
Silverlake	LastDepAmt	Amt of last deposit	DDMAST	AMTDP	Integer	7	13	2
Silverlake	LastWthdwlAmt	Amt of last withdrawal	DDMAST	AMTLWD	Integer	7	13	2
Silverlake	LastSerChgDt	Date Last Service Charge	DDMAST	DLSVCHG7	Integer	4	7	0
Silverlake	LmtTrnAcctType	Track Excess Drs?	DDPAR2	TRKEDR	String	1	0	0
Silverlake	ACHCrCycleAmt	ACH credits s/c cycle	DDMAST	ACHCR$	Integer	7	13	2
Silverlake	ACHDrCycleAmt	ACH debits s/c cycle	DDMAST	ACHDR$	Integer	7	13	2
Silverlake	ACHCrCycleCnt	ACH credits s/c cycle	DDMAST	ACHCR#	Integer	3	5	0
Silverlake	ACHDrCycleCnt	ACH debits s/c cycle	DDMAST	ACHDR#	Integer	3	5	0
Silverlake	ATMOnUsCrMTDAmt	Amt of Onus ATM credits	DDMAST	ATCRAO	Integer	6	11	2
Silverlake	ATMOnUsDrMTDAmt	Amt of Onus ATM dedits	DDMAST	ATDRAO	Integer	6	11	2
Silverlake	ATMOnUsMTDCnt	No. of Onus ATM credits	DDMAST	ATCRNO	Integer	3	5	0
Silverlake	ATMOnUsDrMTDCnt	No. of Onus ATM debits	DDMAST	ATDRNO	Integer	3	5	0
Silverlake	MTDIntPaid	M-T-D Interest paid	DDMAST	MTDINT	Integer	7	13	2
Silverlake	NSFItemsMTD	Items NSF This cyc	DDMAST	ITMNSF	Integer	4	7	0
Silverlake	NSFTimesMTD	Times NSF MTD	DDMAST	TIMNFM	Integer	3	5	0
Silverlake	AggODCycleAmt	Agg Led balance negative	DDMAST	AGGCON	Integer	8	15	2
Silverlake	ODDaysMTD	Days OD This cyc	DDMAST	DYSOD	Integer	2	3	0
Silverlake	ODItemsMTD	Items OD This cyc	DDMAST	ITMOD	Integer	4	7	0
Silverlake	SerChgCrItemsCnt	Number S/C credits	DDMAST	SCCRC	Integer	4	7	0
Silverlake	SerChgDrItemsCnt	Number S/C debits	DDMAST	SCDRC	Integer	4	7	0
Silverlake	NSFAmt	Amount NSF	DDMAST	AMTNSF	Integer	7	13	2
Silverlake	ODLmtCode	Overdraft limit code	DDMAST	ODLMT	Integer	1	1	0
Silverlake	NSFItemsRet	Items Returns This cyc	DDMAST	ITMRT	Integer	4	7	0
Silverlake	CRASMSACode	SMSA Number	DDMAST	SMSA	Integer	3	5	0
Silverlake	CRASMSADesc	Description	LNPAR503	L5DESC	String	40	0	0
Silverlake	AutoNSFFee	Automatic NSF charge	DDMAST	AUTNSF	String	1	0	0
Silverlake	RateRevDt	Rate review date	DDMAST	REVDT7	Integer	4	7	0
Silverlake	AmtCrMTD	Amt of credits	DDMAST	AMTCRM	Integer	8	15	2
Silverlake	AmtDrMTD	Amt of debits	DDMAST	AMTDRM	Integer	8	15	2
Silverlake	ChkGuar	Check guaranty card	DDMAST	CHKGTY	String	1	0	0
Silverlake	ChgdOffDt	Date Last Charged Off	DDMAST	DTCHO7	Integer	4	7	0
Silverlake	NumCrMTD	Number of credits	DDMAST	NOCRM	Integer	4	7	0
Silverlake	NumDrMTD	Number of debits	DDMAST	NODRM	Integer	4	7	0
Silverlake	NumRetChkMTD	No.returned check MTD	DDMAST	RETCKM	Integer	3	5	0
Silverlake	StmtCycle	Statement cycle	DDMAST	STCYC	Integer	2	2	0
Silverlake	StmtBal	Previous stmt bal	DDMAST	STMBAL	Integer	7	13	2
Silverlake	ODTimes3Qtr	Times OD 3rd qtr	DDMAST	TIMOD3	Integer	2	3	0
Silverlake	ODTimes4Qtr	Times OD 4th qtr	DDMAST	TIMOD4	Integer	2	3	0
Silverlake	NSFTimesQTD	Times NSF This Qtr	DDMAST	TMNFQ1	Integer	2	3	0
Silverlake	NSFTimesPrevQtr	Times NSF 2nd Qtr	DDMAST	TMNFQ2	Integer	2	3	0
Silverlake	NSFTimes3Qtr	Times NSF 3rd Qtr	DDMAST	TMNFQ3	Integer	2	3	0
Silverlake	NSFTimes4Qtr	Times NSF 4th Qtr	DDMAST	TMNFQ4	Integer	2	3	0
Silverlake	YestBal	Yesterday balance	DDMAST	YBAL	Integer	7	13	2
Silverlake	YestColBal	Collected balance	DDMAST	YESCOL	Integer	7	13	2
Silverlake	NSFFeesYTD	YTD NSF Fees	DDMAST	YTDNSF	Integer	5	9	2
Silverlake	ODFeesYTD	YTD OD Fees	DDMAST	YTDODF	Integer	5	9	2
Silverlake	SerChgFeesYTD	YTD S/C	DDMAST	YTDSC	Integer	5	9	2
Silverlake	SerChgFeesWavYTD	Y-T-D Service chg waived	DDMAST	YTDSCW	Integer	5	9	2
Silverlake	OneDayFlt	Day 1 Float	DDMAST	AGGAMT	Integer	8	15	2
Silverlake	TwoDayFlt	Day 2 Float	DDMAST	AGGAMT	Integer	8	15	2
Silverlake	ThreeDayFlt	Day 3 Float	DDMAST	AGGAMT	Integer	8	15	2
Silverlake	FourDayFlt	Day 4 Float	DDMAST	AGGAMT	Integer	8	15	2
Silverlake	FiveDayFlt	Day 5 Float	DDMAST	AGGAMT	Integer	8	15	2
Silverlake	ChgBackItemsQTD	Chg Back Itm qtr	DDMAST	CGIBK1	Integer	4	7	0
Silverlake	LastPayDt	Last Interest Paid	DDMAST	DLINP7	Integer	4	7	0
Silverlake	AmtLastIntPd	Amt of last int Pd	DDMAST	LINTPD	Integer	7	13	2
Silverlake	OrigAcctId	Original Account Id			Integer	9	16	0
Silverlake	ATMCard	ATM Card			String	6	0	0
Silverlake	StdIndustCode	Standard Industrial Classification Code			Integer	3	4	0
Silverlake	StdIndustDesc	Standard Industrial Classification Desc			String	30	0	0
Silverlake	CurQtrMinBal	Quarter minimum balance			Integer	7	13	2
Silverlake	CurQtrMaxBal	Quarter maximum balance			Integer	7	13	2
Silverlake	TrnAmtCurDayDr	Trn Debit CurDay Amt			Integer	7	13	2
Silverlake	TrnAmtPrevDayDr	Trn Debit PrevDay Amt			Integer	7	13	2
Silverlake	TrnCntCurDayDr	Trn Debit CurDay Cnt			Integer	4	7	0
Silverlake	TrnCntPrevDayDr	Trn Debit PrevDay Cnt			Integer	4	7	0
Silverlake	TrnAmtCurDayCr	Trn Credit CurDay Amt			Integer	7	13	2
Silverlake	TrnAmtPrevDayCr	Trn Credit PrevDay Amt			Integer	7	13	2
Silverlake	TrnCntCurDayCr	Trn Credit CurDay Cnt			Integer	4	7	0
Silverlake	TrnCntPrevDayCr	Trn Credit PrevDay Cnt			Integer	4	7	0
Silverlake	MonthAvgBalAmt	M-T-D Average Available Balance			Integer	8	15	2
Silverlake	GroupCode	GL Group Code			Integer	2	3	0
Silverlake	GLProdCode	GL Product Code			Integer	2	3	0
Silverlake	MTDAvgColBal	M-T-D Average Collected Balance			Integer	8	15	2
Silverlake	RateVar	Rate Variance	DDMAST	PVAR	Integer	5	9	8
Silverlake	RateVarCode	Rate Variance Code	DDMAST	PVAR1	String	8	0	0
Silverlake	PrimeRateIdx	Rate Number	DDMAST	RATE#	Integer	4	7	0
Silverlake	EstbPersonName	Name of person opening account	CFFOPI	CFFACNAME	String	40	0	0
Silverlake	EstbPersonTitle	Title of person opening account	CFFOPI	CFFACTITLE	String	70	0	0
Silverlake	BrandCode	Brand Code	JHBRAND	MBCODE	String	10	0	0
Silverlake	BrandDesc	Brand Description	JHBRAND	MBNAME	String	50	0	0
Silverlake	NSFItemsYTD	NSF Year to Date Items	CALCULATED	CALCULATED	Integer	5	8	0
Silverlake	NSFTimesYTD	NSF Year to Date Times	CALCULATED	CALCULATED	Integer	5	8	0
Silverlake	StopCondNotfType	Stop code	DDMAST	SPCODE	String	1	0	0
Silverlake	HldCondNotfType	Hold Exists	DDMAST	HDCODE	String	1	0	0
Silverlake	AlrtCondNotfType	Alert Exists	DDMAST	ATCODE	String	1	0	0
Silverlake	SpecInstrCondNotfType	Special Instructions Exists	DDMAST	SICODE	String	1	0	0
Silverlake	CurBalDailyClsAmt	Current Balance Daily Close Amount	DDMAST	CBAL	Integer	7	13	2
Silverlake	AvlBalDailyClsAmt	Available Balance Daily Close Amount	DDMAST	ABAL	Integer	7	13	2
Silverlake	ColBalDailyClsAmt	Collected Balance Daily Close Amount	DDMAST	COLECT	Integer	7	13	2

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.

Please ignore this field

Did this page help you?

Last updated Mon Oct 27 2025