TM_RECON

This table stores profiles used by Transaction Matching.

Details

Object type: TABLE

Primary Key

Name	Columns
RECON_PK	RECON_ID

Columns

Name	Data Type	Length	Precision	Scale	Null Allowed	Comments
RECON_ID	NUMBER		18	0	No	Primary Key
RECON_TYPE_ID	NUMBER		18	0	No	Foreign Key to TM_RECON_TYPE. Match Type ID.
OWNER	NVARCHAR2	255			Yes	Internal Use Only
PREPARER	NVARCHAR2	255			Yes	Internal Use Only
INSTRUCTIONS	NCLOB				Yes	Internal Use Only
OBJECT_VERSION_NUMBER	NUMBER		9	0	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATED_BY	NVARCHAR2	255			No	Who column. Stores the ID of the user who created this row.
UPDATED_BY	NVARCHAR2	255			Yes	Who column. Stores the ID of the user who last updated this row.
CREATE_DATE	TIMESTAMP(6)				No	Who column. Stores the date when this row was created in the database.
UPDATE_DATE	TIMESTAMP(6)				Yes	Who column. Stores the date when this row was last updated.
MAPPED_WITH_PROFILE_STATUS	NUMBER		2	0	Yes	Temporary column to check whether reconciliation is mapped with Profile. Probable values are 0=Not Mapped,1=Mapped Default value is 0. This column should be removed once all the TM Reconciliation are mapped with RC profile
TEXT_ID	VARCHAR2	4000			Yes	Account ID
DESCRIPTION	VARCHAR2	4000			Yes	Internal Use Only
NAME	VARCHAR2	765			Yes	Internal Use Only

Indexes

Index	Uniqueness	Columns
RECON_PK	UNIQUE	RECON_ID
UNIQUE_RECON_IDX001	UNIQUE	SYS_NC00015$

Foreign Keys

Name	Foreign Table	Foreign Key Column
TM_RECON	TM_RECON_TYPE	RECON_TYPE_ID