ARM_TRANS_ATTRIBUTES_1
This table stores the attribute value assignments of the transactions and action plans. The columns are dynamically created using the name C_<Attribute ID>.
Details
Object type: TABLE
Primary Key
| Name | Columns |
|---|---|
|
ARM_TRANS_ATTRIBUTES_1_PK |
OBJECT_ID |
Columns
| Name | Data Type | Length | Precision | Scale | Null Allowed | Comments |
|---|---|---|---|---|---|---|
|
OBJECT_ID |
NUMBER |
18 |
0 |
No |
The Transaction or Action Plan ID for the row. |
|
|
C_< Attribute ID> |
These are the user defined columns, FCM_ATTRIBUTES.ATTRIBUTE_ID is used to form the name of the column. Column name follows the format c_<ATTRIBUTE_ID> ( For Example, C_ 100000000056159). |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
|
ARM_TRANS_ATTRIBUTES_1_PK |
UNIQUE |
OBJECT_ID |