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. |
Indexes
Index | Uniqueness | Columns |
---|---|---|
TM_ADJ_ATTRIB_VAL_COL_OBJ_ID |
UNIQUE |
OBJECT_ID |