TM_MATCH_PROC

This table stores match processes.

Details

Object type: TABLE

Primary Key

Name	Columns
MATCHPROC_PK	MATCH_PROC_ID

Columns

Name	Data Type	Length	Precision	Scale	Null Allowed	Comments
RECON_TYPE_ID	NUMBER		18	0	No	Foreign Key to TM_RECON_TYPE
MATCH_PROC_ID	NUMBER		18	0	No	Foreign Key to TM_MATCH_PROC
TEXT_ID	NVARCHAR2	100			No	Text ID of the match process
NAME	NVARCHAR2	100			No	Name of the match process
FROM_DATA_SOURCE_ID	NUMBER		18	0	Yes	Source System data source
TO_DATA_SOURCE_ID	NUMBER		18	0	Yes	Sub system data source
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.
ADJ_ACCOUNTING_DATE_TYPE	NUMBER		1	0	Yes	0=Match Date, 1=Latest Accounting Date in the Match Group
POSITION	NUMBER		4	0	Yes	Order of auto match execution
MATCH_WITHOUT_REVIEW	NUMBER				Yes	Indicates whether this match process has config setting for manual match without review. 1=Enabled, 0=Not Enabled.
SOURCE_TO_ADJUST	NUMBER		18		Yes	Indicates whether this match process has default source to adjust for manual match without review.
DEFAULT_TRANS_TYPE	NUMBER		18		Yes	Indicates whether this match process has default transaction type for manual match without review.

Indexes

Index	Uniqueness	Columns
MATCHPROC_PK	UNIQUE	MATCH_PROC_ID
UNIQUE_MATCHPROC_IDX001	UNIQUE	RECON_TYPE_ID, SYS_NC00012$

Foreign Keys

Name	Foreign Table	Foreign Key Column
TM_MATCH_PROC	TM_RECON_TYPE	RECON_TYPE_ID