AcctReconItemDetail

ODI Extracts > Silverlake > AcctReconItemDetail

Extract to provide details regarding records in the ARITEM file for account reconciliation.

Provider	Element	Element Description	Reference File	Reference Field	Field Type	Length	Digits	Decimal Places
Silverlake	Dlt	Delete Record Flag			String	1	0	0
Silverlake	SrcKey	Unique Record Key			String	20	0	0
Silverlake	FornKey	Account Item Detail ARIACCOUNT/ARIACCTYP			String	20	0	0
Silverlake	AcctId	Account Number	ARITEM	ARIACCOUNT	Integer	9	16	0
Silverlake	AcctType	Account Type	ARITEM	ARIACCTYP	String	1	0	0
Silverlake	ChkNum	Serial Number	ARITEM	ARISERIAL	Integer	6	11	0
Silverlake	IssAmt	Issued Amount	ARITEM	ARIISSUAMT	Integer	8	15	2
Silverlake	ChkDt	Date Issued	ARITEM	ARIISSUED7	Integer	4	7	0
Silverlake	ChkVoidDt	Void Date	ARITEM	ARIVOIDD7	Integer	4	7	0
Silverlake	TrnType	Debit/Credit	ARITEM	ARIDORC	String	1	0	0
Silverlake	PayeeName	Payee	ARITEM	ARIPAYEE	String	80	0	0
Silverlake	PayeeAddr1	Payee Address Line 1	ARITEM	ARIPAYEAD1	String	35	0	0
Silverlake	PayeeAddr2	Payee Address Line 2	ARITEM	ARIPAYEAD2	String	35	0	0
Silverlake	PayeeAddr3	Payee Address Line 3	ARITEM	ARIPAYEAD3	String	35	0	0
Silverlake	PayeeAddr4	Payee Address Line 4	ARITEM	ARIPAYEAD4	String	35	0	0
Silverlake	PayeeAddr5	Payee Address Line 5	ARITEM	ARIPAYEAD5	String	35	0	0
Silverlake	AcctReconViolRmk	Violation Message	ARITEM	ARIVIOLMSG	String	30	0	0
Silverlake	IssItemCrtDt	System Date	ARITEM	ARISYSDTE7	Integer	4	7	0
Silverlake	BatchNum	Batch Number	ARITEM	ARIBATCH#	Integer	4	7	0
Silverlake	SeqNum	Sequence Number	ARITEM	ARISEQNC#	Integer	6	10	0
Silverlake	TrnAmt	Paid Amount	ARITEM	ARIPAIDAMT	Integer	8	15	2
Silverlake	EffDt	Effective Date	ARITEM	ARIENTDTE7	Integer	4	7	0
Silverlake	StaleDt	Stale Date	ARITEM	ARISTALED7	Integer	4	7	0
Silverlake	PostDt	Date Paid	ARITEM	ARIPAIDD7	Integer	4	7	0
Silverlake	DormantDt	Dormant Date	ARITEM	ARIDORMD7	Integer	4	7	0
Silverlake	TrnCodeCode	Tran Code	ARITEM	ARITRANCD	Integer	2	3	0
Silverlake	TrnCodeDesc	Tran Code Description	DDPAR3_T	DESC	String	30	0	0
Silverlake	StopChkPlaceDt	Stop Payment Date	ARITEM	ARISTOPD7	Integer	4	7	0
Silverlake	StopChkExpDt	Stop Payment Expiration Date	ARITEM	ARISTEXPD7	Integer	4	7	0
Silverlake	AcctReconViolType	Violation Code	ARITEM	ARIVIOLCDE	String	3	0	0
Silverlake	ExcResolveType	Exception Resolved	ARITEM	ARIRESOLVD	String	1	0	0
Silverlake	RetTrnCnt	Number of Times Returned	ARITEM	ARIRETRND#	Integer	4	7	0
Silverlake	ItemRetDt	Returned Date	ARITEM	ARIRETRND7	Integer	4	7	0
Silverlake	AcctReconAdjType	Adjustment	ARITEM	ARIADJTRNS	String	1	0	0
Silverlake	AcctReconPurgeCode	Purge Reason	ARITEM	ARIPURGECD	String	3	0	0
Silverlake	AcctReconPurgeDesc	Purge Description	ARITEM	ARIPURGDES	String	10	0	0
Silverlake	AcctReconPurgeDt	Date Purged	ARITEM	ARIPURGED7	Integer	4	7	0
Silverlake	AcctReconItemStat	Item Status	ARITEM	ARISTAT	String	16	0	0
Silverlake	LastMainDt	Last Maintenance Date	ARITEM	ARIMAINTD7	Integer	4	7	0
Silverlake	SrcFundsCode	Check Cleared Source	ARITEM	ARIPAIDSRC	String	2	0	0
Silverlake	SrcFundsDesc	Check Cleared Source Description	ARITEM	ARIPDSRCDS	String	30	0	0
Silverlake	StaleExpDt	Stale Date Expired	ARITEM	ARISTLEXD7	Integer	4	7	0
Silverlake	PostExpDt	Paid/Cleared Date Expired	ARITEM	ARICLREXD7	Integer	4	7	0
Silverlake	DormantExpDt	Dormant Date Expired	ARITEM	ARIDOREXD7	Integer	4	7	0
Silverlake	ChkVoidExpDt	Void Date Expired	ARITEM	ARIVDEXPD7	Integer	4	7	0
Silverlake	TrnBatchNum	DDA Batch Number	ARITEM	ARIDDBATCH	Integer	3	4	0
Silverlake	TrnSeqNum	DDA Sequence Number	ARITEM	ARIDDSEQ	Integer	6	10	0
Silverlake	SrcCode	Input Source	ARITEM	ARIINPTSRC	String	1	0	0
Silverlake	DltDt	Purge Delete Date	ARITEM	ARIDELETD7	Integer	4	7	0
Silverlake	PrevStopChkPlaceDt	Stop Payment	ARITEM	ARIPRVSTD7	Integer	4	7	0
Silverlake	PrevStopChkExpDt	Stop Payment Expiration	ARITEM	ARIPRSTXD7	Integer	4	7	0
Silverlake	StopChkPurgeDt	Stop Check Purge Date	ARITEM	ARIDDSTDR7	Integer	4	7	0
Silverlake	ImgNum	Image Number	ARITEM	ARIIMAGE#	Integer	8	15	0

Have a Question?

Have a how-to question? Seeing a weird error? Get help on StackOverflow.

Register for the Developer Office Hours where we answer technical Q&A from the audience.

Please ignore this field

Did this page help you?

Last updated Mon Oct 27 2025