TM_MATCH

This table stores Transaction Matching matches and match status.

Details

Object type: TABLE

Primary Key

Name	Column
MATCH_PK	MATCH_ID

Columns

Name	Data Type	Length	Precision	Scale	Null Allowed	Comments
RECON_ID	NUMBER		18	0	No	Foreign Key to TM_RECON
MATCH_PROC_ID	NUMBER		18	0	No	Foreign Key to TM_MATCH_PROC
MATCH_RULE_ID	NUMBER		18	0	Yes	Foreign key to TM_MATCH_RULE
MATCH_ID	NUMBER		18	0	No	Primary key
MATCH_STATUS_ENUM	NUMBER		2	0	No	Match status: 1=SUGGESTED_MATCH, 2=CONFIRMED_MATCH, 3=CONFIRMED_ADJUST, 4=SUGGESTED_ADJUST, 6=SUPPORTED
ADJUSTMENT	NUMBER		2	0	No	Adjustment exists or not:1= NOTAPPLICABLE, 2=ADJUST, 3=SUPPORT
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.
AUTOMATCH_JOB_ID	NUMBER		18	0	0	The job ID of the Auto Match job that created this match.
ARCHIVE_JOB_ID	NUMBER		18	0	Yes	The job ID of the Archive Transactions job that included this matched transaction.
REVERSE_STATUS	NUMBER		2	0	No	Indicates if a reverse adjustment was created for this match ID. Options are: 0 = NO, 1 = YES.

Indexes

Index	Uniqueness	Columns
MATCH_PK	UNIQUE	MATCH_ID
TM_MATCH_RECON	NONUNIQUE	RECON_ID
TM_MATCH_STATUS	NONUNIQUE	MATCH_STATUS_ENUM
TM_MATCH_SUMMARIES_U1	NONUNIQUE	RECON_ID, MATCH_STATUS_ENUM

Foreign Keys

Name	Foreign Table	Foreign Key Column
TM_MATCH	TM_RECON	RECON_ID
TM_MATCH	TM_MATCH_RULE	MATCH_RULE_ID
TM_MATCH	TM_MATCH_PROC	MATCH_PROC_ID