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