TM_ADJUSTMENT

This table stores Transaction Matching adjustment information.

Details

Object type: TABLE

Primary Key

Name	Columns
ADJTRANSDETAILS_PK	ADJUSTMENT_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_ID	NUMBER		18	0	No	Foreign Key to TM_MATCH
ADJUSTMENT_ID	NUMBER		18	0	No	Primary key
STATUS	NUMBER		1	0	Yes	Adjustment Status - 1=OPEN, 2=CLOSE
TRANS_TYPE_ID	NUMBER		18	0	No	TM_TRANS_TYPE foreign key. The transaction type associated with the adjustment
CHANGED_DATA_SOURCE_ID	NUMBER		18	0	No	TM_DATA_SOURCE foreign key. The source to which the adjustment is posted
BAL_ATTRIB_VALUE_1	NUMBER		18	2	Yes	Adjustment amount
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.
ACCOUNTING_DATE	DATE				Yes	Accounting Date of the adjustment
EXPORT_JOURNAL_JOB_ID	NUMBER		18	0	Yes	Job ID associated with journal export
REVERSE_STATUS	NUMBER		2	0	No	Indicates the status of an adjustment. Options are: 0 = DEFAULT, 1 = ORIGINAL, or 2 = REVERSE.

Indexes

Index	Uniqueness	Columns
ADJTRANSDETAILS_PK	UNIQUE	ADJUSTMENT_ID
TM_ADJUSTMENT_MATCH	NONUNIQUE	MATCH_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
TM_ADJUSTMENT	TM_MATCH_PROC	MATCH_PROC_ID
TM_ADJUSTMENT	TM_RECON	RECON_ID
TM_ADJUSTMENT	TM_MATCH	MATCH_ID
TM_ADJUSTMENT	TM_TRANS_TYPE	TRANS_TYPE_ID