XCC_CB_OVERRIDE_JOURNALS
This table contains the journal sources and categories for which an override rule is applicable. It does not contain any rows for override rules that apply to all journal sources and categories.
Details
-
Schema: FUSION
-
Object owner: XCC
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
XCC_CB_OVERRIDE_JOURNALS_PK |
OVERRIDE_JOURNAL_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| OVERRIDE_JOURNAL_ID | NUMBER | 18 | Yes | Assignment of a journal source and category to an override rule for overriding General Legder transactions. | |
| OVERRIDE_RULE_ID | NUMBER | 18 | Yes | Override rule that is applied to this journal source and category. | |
| JE_SOURCE_CODE | VARCHAR2 | 25 | Yes | Journal source assigned to this override rule. | |
| JE_CATEGORY_CODE | VARCHAR2 | 25 | Yes | Journal category assigned to this override rule. Contains a single space if all journal categories apply. | |
| CONTROL_BUDGET_ID | NUMBER | 18 | Yes | Control budget for which this override rule is applicable. | |
| 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_JOURNALS_N1 | Non Unique | Default | CONTROL_BUDGET_ID, JE_SOURCE_CODE, JE_CATEGORY_CODE |
| XCC_CB_OVERRIDE_JOURNALS_U1 | Unique | Default | OVERRIDE_JOURNAL_ID |
| XCC_CB_OVERRIDE_JOURNALS_U2 | Unique | Default | OVERRIDE_RULE_ID, JE_SOURCE_CODE, JE_CATEGORY_CODE |