CTO_CONFIG_REQ_TXN_ATTRS_GT
This table is used to temporarily store the input tia attributes which is used in matching pl/sql procedure
Details
-
Schema: FUSION
-
Object owner: CTO
-
Object type: TABLE
-
Tablespace: TEMP
Primary Key
| Name | Columns |
|---|---|
|
CTO_CONFIG_REQ_TXN_ATTRS_PK |
MATCH_TXN_ATTR_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| MATCH_TXN_ATTR_ID | NUMBER | 18 | Yes | Primary Key generated by system | |
| LINE_ID | VARCHAR2 | 50 | Yes | Foreign key to Line Id in CTO_CONFIG_REQ_LINES_GT table | |
| ATTRIBUTE_NAME | VARCHAR2 | 100 | Yes | TIA attribute name for CTO Config | |
| TIMESTAMP_ATTRIBUTE_VALUE | TIMESTAMP | Attribute to hold Timestamp value of TIA | |||
| NUMBER_ATTRIBUTE_VALUE | NUMBER | 18 | Attribute to hold Number value of TIA | ||
| CHARACTER_ATTRIBUTE_VALUE | VARCHAR2 | 4000 | Attribute to hold Character value of TIA | ||
| DATE_ATTRIBUTE_VALUE | DATE | Attribute to hold Date value of TIA | |||
| MATCH_ONLY_FLAG | VARCHAR2 | 1 | Indicates whether this TIA attribute should be used for Matching or not. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | 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 |
|---|---|---|
| CTO_CONFIG_REQ_TXN_ATTRS_GT_N1 | Non Unique | LINE_ID |
| CTO_CONFIG_TXN_ATTRS_GT_U1 | Unique | MATCH_TXN_ATTR_ID |