TM_TRANS_TYPE_OPTION

This table stores adjustment posting options for each data source used in the transaction type.

Details

Object type: TABLE

Primary Key

Name	Columns
TM_TRANS_TYPE_OPTION_PK	TRANS_TYPE_OPTION_ID

Columns

Name	Data Type	Length	Precision	Scale	Null Allowed	Comments
TRANS_TYPE_ID	NUMBER		18	0	No	Foreign key to TM_TRANS_TYPE
DATA_SOURCE_ID	NUMBER		18	0	No	Foreign Key to TM_DATA_SOURCE.
TRANS_TYPE_OPTION_ID	NUMBER		18	0	No	Primary key
ALLOW_POST_OF_ADJS_TO	NUMBER		1	0	No	Allow to post adjustment
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.

Indexes

Index	Uniqueness	Columns
TM_TRANS_TYPE_OPTION_PK	UNIQUE	TRANS_TYPE_OPTION_ID

Foreign Keys

Name	Foreign Table	Foreign Key Column
TM_TRANS_TYPE_OPTION	TM_DATA_SOURCE	DATA_SOURCE_ID
TM_TRANS_TYPE_OPTION	TM_TRANS_TYPE	TRANS_TYPE_ID