DepExcTrnDetail

ODI Extracts > Core Director > DepExcTrnDetail

Extract to provide Exception Item Transaction details

Provider	Element	Element Description	Reference File	Reference Field	Field Type	Length	Decimal Places
Core Director	Dlt	Delete record flag			String	1
Core Director	SrcKey	Unique record key	COMREJ.ISM	COM_REJ_KEY	String	32
Core Director	FornKey	Account key	MASTER.ISM	MASTER_PRIMARY_KEY	String	18
Core Director	EftDescSrcKey	Key to Description Record	COMREJ.ISM	COM_REJ_KEY	String	32
Core Director	AcctId	Account Number	COMREJ.ISM	COM_REJ_ACCOUNT_NUMBER	String	16
Core Director	AcctType	Account Type		Calculated	String	2
Core Director	SeqNum	Sequence Number	COMREJ.ISM	COM_REJ_SEQUENCE_NUMBER	Int32	6
Core Director	ChkNum	Check Number	COMREJ.ISM	COM_REJ_CHECK_NUMBER	Int64	10
Core Director	Amt	Amount	COMREJ.ISM	COM_REJ_TRANSACTION_AMOUNT	Decimal	11	2
Core Director	TrnCodeCode	Tran code	COMREJ.ISM	COM_REJ_TRANSACTION_CODE	Int32	3
Core Director	TrnCodeDesc	Tran description	TRNDES.ISM	TCDESC	String	25
Core Director	PostDt	Post Date	COMREJ.ISM	COM_REJ_TRANSACTION_DATE	DateTime	8
Core Director	ExcDispCode	Disposition Code	COMREJ.ISM	COM_REJ_DISPOSITION_CODE	String	1
Core Director	ExcDispDesc	Disposition Code Desc		Calculated	String	25
Core Director	ExcRetRsnCode	Return Reason Code	COMREJ.ISM	COM_REJ_RETURN_REASON	String	3
Core Director	ExcRetRsnDesc	Return Reason Code Desc		Calculated	String	50

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 Fri Feb 21 2025