TM_ADJ_ATTRIB_VAL

TM_ADJ_ATTRIB_VAL_COL

This table stores the attribute values for all attributes associated with an adjustment. It provides a dashboard style view of the attributes for each adjustment.

Details

Object type: TABLE

Columns

Name	Data Type	Length	Precision	Scale	Null Allowed	Comments
OBJECT_ID	NUMBER		18	0	No	Unique ID of the adjustment.
C_<ATTRIBUTE_ID>						These are the user-defined adjustment and support attributes in the application. The ATTRIBUTE_ID is used to form the name of the column. Column name follows the format C_<ATTRIBUTE_ID>. For example, if the attribute ID is 1001, the column name will be C_1001.

Name

Data Type

Length

Precision

Scale

Null Allowed

Comments

OBJECT_ID

NUMBER

Unique ID of the adjustment.

C_<ATTRIBUTE_ID>

These are the user-defined adjustment and support attributes in the application.

The ATTRIBUTE_ID is used to form the name of the column. Column name follows the format C_<ATTRIBUTE_ID>. For example, if the attribute ID is 1001, the column name will be C_1001.

Indexes

Index	Uniqueness	Columns
TM_ADJ_ATTRIB_VAL_COL_OBJ_ID	UNIQUE	OBJECT_ID