AcctReconItemDetail
Operational Data Integration (ODI)
>
ODI Extracts
>
Silverlake
>
AcctReconItemDetail
Extract to provide details regarding records in the ARITEM file for account reconciliation.
Silverlake
Dlt
Delete Record Flag
1
SrcKey
Unique Record Key
20
FornKey
Account Item Detail ARIACCOUNT/ARIACCTYP
AcctId
Account Number
9
16
AcctType
Account Type
ChkNum
Serial Number
6
11
IssAmt
Issued Amount
8
15
2
ChkDt
Date Issued
4
7
ChkVoidDt
Void Date
TrnType
Debit/Credit
PayeeName
Payee
80
PayeeAddr1
Payee Address Line 1
35
PayeeAddr2
Payee Address Line 2
PayeeAddr3
Payee Address Line 3
PayeeAddr4
Payee Address Line 4
PayeeAddr5
Payee Address Line 5
AcctReconViolRmk
Violation Message
30
IssItemCrtDt
System Date
BatchNum
Batch Number
SeqNum
Sequence Number
10
TrnAmt
Paid Amount
EffDt
Effective Date
StaleDt
Stale Date
PostDt
Date Paid
DormantDt
Dormant Date
TrnCodeCode
Tran Code
3
TrnCodeDesc
Tran Code Description
StopChkPlaceDt
Stop Payment Date
StopChkExpDt
Stop Payment Expiration Date
AcctReconViolType
Violation Code
ExcResolveType
Exception Resolved
RetTrnCnt
Number of Times Returned
ItemRetDt
Returned Date
AcctReconAdjType
Adjustment
AcctReconPurgeCode
Purge Reason
AcctReconPurgeDesc
Purge Description
AcctReconPurgeDt
Date Purged
AcctReconItemStat
Item Status
LastMainDt
Last Maintenance Date
SrcFundsCode
Check Cleared Source
SrcFundsDesc
Check Cleared Source Description
StaleExpDt
Stale Date Expired
PostExpDt
Paid/Cleared Date Expired
DormantExpDt
Dormant Date Expired
ChkVoidExpDt
Void Date Expired
TrnBatchNum
DDA Batch Number
TrnSeqNum
DDA Sequence Number
SrcCode
Input Source
DltDt
Purge Delete Date
PrevStopChkPlaceDt
Stop Payment
PrevStopChkExpDt
Stop Payment Expiration
StopChkPurgeDt
Stop Check Purge Date
ImgNum
Image Number
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