CE_RECON_EXCEPTIONS_GT

This global temporary table is used in Auto Reconciliation program to temporarily store the auto reconciliation exceptions (e.g. ambiguous exceptions, amount exceptions, date exceptions).

Details

• Schema: FUSION

• Object owner: CE

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Not-null	Comments
STATEMENT_LINE_ID	NUMBER		18	Yes	Oracle internal use only.
TRANSACTION_SOURCE	VARCHAR2	30		Yes	Oracle internal use only.
TRANSACTION_ID	NUMBER		18	Yes	Oracle internal use only.
RECON_MATCHING_RULE_ID	NUMBER		18	Yes	Oracle internal use only.
RECON_TOLERANCE_RULE_ID	NUMBER		18		Oracle internal use only.
EXCEPTION_TYPE	VARCHAR2	10		Yes	Oracle internal use only.
MATCHING_RULE_ORDER	NUMBER		9		Oracle internal use only.
TRX_LINE_ID	NUMBER		18		Oracle internal use only.

Indexes

Index	Uniqueness	Columns
CE_RECON_EXCEPTIONS_GT_N1	Non Unique	STATEMENT_LINE_ID