XCC_CB_OVERRIDE_RULES
This table contains the override rules for a control budget. It stores both insufficient funds overrides and closed period overrides.
Details
-
Schema: FUSION
-
Object owner: XCC
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
XCC_CB_OVERRIDE_RULES_PK |
OVERRIDE_RULE_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
OVERRIDE_RULE_ID | NUMBER | 18 | Yes | Unique identifier of the override rule. | |
CONTROL_BUDGET_ID | NUMBER | 18 | Yes | Control budget for which this override rule is applicable. | |
NAME | VARCHAR2 | 100 | Yes | Unique name of the override rule. | |
DESCRIPTION | VARCHAR2 | 240 | Description of the override rule. | ||
OVERRIDE_TYPE_CODE | VARCHAR2 | 30 | Yes | Type of override rule. Valid values are INSUFFICIENT_FUNDS for insufficient funds overrides and CLOSED_PERIOD for closed period overrides. | |
OVERRIDE_AMOUNT | NUMBER | Amount that an insufficent funds override can override by. This amount is in the budget currency. It is required for insufficient funds overrides. No amount can be supplied for closed period overrides. | |||
ENABLED_FLAG | VARCHAR2 | 1 | Yes | Indicates if this override rule is enabled. | |
ALL_TRANSACTION_TYPES_FLAG | VARCHAR2 | 1 | Yes | Indicates if this override rule applies for all transaction types. | |
ALL_JOURNAL_SOURCES_FLAG | VARCHAR2 | 1 | Yes | Indicates if this override rule applies for all General Ledger journal sources. The value is Y if this override rule does not apply to General Ledger transactions or if it applies to all transaction types. | |
ALL_JOURNAL_CATEGORIES_FLAG | VARCHAR2 | 1 | Yes | Indicates if this override rule applies for all General Ledger journal categories. The value is Y if this override rule does not apply to General Ledger transactions or if it applies to all transaction types. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
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_OVERRIDE_RULES_N1 | Non Unique | Default | CONTROL_BUDGET_ID, OVERRIDE_TYPE_CODE |
XCC_CB_OVERRIDE_RULES_U1 | Unique | Default | OVERRIDE_RULE_ID |
XCC_CB_OVERRIDE_RULES_U2 | Unique | Default | CONTROL_BUDGET_ID, NAME |