XCC_CB_RULE_FILTER_CONDITIONS
This table stores all the supplemental rule filters. These filters can be based on budget segments, COA segments that are not mapped to budget COA segments, Project segments and Project planning elements which are not mapped to budget COA segments and/or any transaction attributes.
Details
-
Schema: FUSION
-
Object owner: XCC
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
XCC_CB_RULE_FILTER_CONDIT_PK |
RULE_FILTER_CONDITION_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
RULE_FILTER_CONDITION_ID | NUMBER | 18 | Yes | Unique identifier for this transaction | |
RULE_ID | NUMBER | 18 | Yes | Foreign key to XCC_CB_RULES table | |
FILTER_CONDITION_CODE | VARCHAR2 | 30 | Yes | Either budget COA segment column name or GL COA segment column or project segment code specific to XCC or project planning element code specific to XCC or transaction attribute code specific to XCC | |
FILTER_CONDITION_TYPE | VARCHAR2 | 30 | Yes | Indicates whether this condition is associated with budget segment or GL COA or project segment or project planning element or transaction attribute | |
TREE_STRUCTURE_CODE | VARCHAR2 | 30 | Tree related other essential information | ||
TREE_CODE | VARCHAR2 | 30 | Tree that is used for specifying the segment values. This is relevant only when SEGMENT_VALUE rows are based on tree data | ||
TREE_VERSION_ID | VARCHAR2 | 32 | Tree version of the flexfield segment value. This is relevant only when SEGMENT_VALUE rows are based on tree data | ||
APPLICABLE_TO_ALL_VALUES_FLAG | VARCHAR2 | 1 | Yes | Indicates whether this control budget rule filter is applicable for all valus associated with this dimension or notr | |
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. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
XCC_CB_RULE_FILTER_CONDS_U1 | Unique | FUSION_TS_TX_DATA | RULE_FILTER_CONDITION_ID |
XCC_CB_RULE_FILTER_CONDS_U2 | Unique | FUSION_TS_TX_DATA | RULE_ID, FILTER_CONDITION_CODE, FILTER_CONDITION_TYPE |