DepNSFHist
Operational Data Integration (ODI)
>
ODI Extracts
>
Core Director
>
DepNSFHist
Extract to provide Non-sufficient funds history activity
Core Director
Dlt
Delete record flag
String
1
SrcKey
Unique record key
HISTRY.ISM/DDANSF.ISM
HIST_FULL_KEY, NSF_KEY
32
FornKey
Account key
MASTER.ISM
MASTER_PRIMARY_KEY
18
NSFStat
Status
Calculated
4
TrnCodeCode
Tran code
HIST_TRAN_CODE, NSF_TRAN_CODE
Int32
3
TrnCodeDesc
Tran description
TRNDES.ISM
TCDESC
25
PostDt
Post Date
HIST_TRAN_DATE, NSF_TRAN_DATE
DateTime
8
Amt
Amount
HIST_TRAN_AMT, NSF_TRAN_AMT
Decimal
11
2
ImgNum
Image Number
HIST_DSI_ITEM_SEQ, NSF_IMAGE_SEQUENCE
Int64
16
ChkNum
Check Number
HIST_CHECK_NUMBER, NSF_CHECK_NUMBER
10
NSFFeeAmt
NSF Fee Amount
DDANSF.ISM
NSF_ORG_SRV_CHRG_AMT
6
OffCode
Officer code
NSF_OFFICER_INIT
RetRsnDesc
Return reason
30
EftDescSrcKey
Key to Description Record
ODI_MEMOPOSTDESCRIPTION.SRCKEY
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