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