Developer Programs

Learn

Docs
Important notification about upcoming changes to the DMZ environment. Please read.

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