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