CE_EXTERNAL_RECON_INT

This table is an interface table used to load grouping of bank statement lines and system transactions for bank statement reconciliation in the application.

Details

• Schema: FUSION

• Object owner: CE

• Object type: TABLE

• Tablespace: INTERFACE

Primary Key

Name	Columns
CE_EXTERNAL_RECON_INT_PK	RECON_SOURCE_CODE, SOURCE_ID, SOURCE_LINE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
EXTERNAL_RECON_REFERENCE	VARCHAR2	50			Stores the external reconciliation reference stamped by user.
BANK_ACCOUNT_ID	NUMBER		18	Yes	Identifier of bank account associated with the record.
RECON_SOURCE_CODE	VARCHAR2	30		Yes	Source of the item. For example, bank statement lines, payable transactions, and receivable transactions.
SOURCE_ID	NUMBER		18	Yes	Identifier of the bank statement line or system transaction.
SOURCE_LINE_ID	NUMBER		18	Yes	Supplementary identifier of the record from a source like Oracle Fusion General Ledger that uses composite keys.
PROCESS_STATUS_CODE	VARCHAR2	30			Indicates the current processing status of the record.
PROCESS_ERROR_MESSAGE	VARCHAR2	1000			Error message associated with the processing error.
LOAD_REQUEST_ID	NUMBER		18	Yes	Request ID of the interface load job that created the row.
CREATED_BY	VARCHAR2	64			Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP				Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64			Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP				Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index	Uniqueness	Tablespace	Columns
CE_EXTERNAL_RECON_INT_N1	Non Unique	Default	LOAD_REQUEST_ID, RECON_SOURCE_CODE
CE_EXTERNAL_RECON_INT_U1	Unique	Default	RECON_SOURCE_CODE, SOURCE_ID, SOURCE_LINE_ID