XCC_BALANCE_RECALC_GT
This is a temporary table that contains the budget entries and activities to rollup the tree details and update balances.
Details
-
Schema: FUSION
-
Object owner: XCC
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| HEADER_ID | NUMBER | 18 | Yes | Budgetary control transaction identifier. | Obsolete | |
| HEADER_NUM | VARCHAR2 | 100 | Yes | Unique identifier for a transaction or budget distribution. | ||
| LINE_NUMBER | NUMBER | 18 | Yes | Line number to uniquely identify the transaction line within the transaction. | ||
| BALANCE_LINE_ORDER | VARCHAR2 | 100 | Balance line number. Uniquely identifies the activity within the transaction line. | |||
| SUMMARY_CONTROL_BUDGET_ID | NUMBER | 18 | Yes | Control budget for which this transaction line is applicable. | ||
| SUMMARY_PERIOD_NAME | VARCHAR2 | 15 | Yes | Period in which funds must be consumed. | ||
| MASTER_CONTROL_BUDGET_ID | VARCHAR2 | 18 | Identifier for the master control budget. | |||
| MASTER_PERIOD_NAME | VARCHAR2 | 15 | Period name for the master control budget. | |||
| CURRENCY_CODE | VARCHAR2 | 15 | Currency code of the summary control budget. | |||
| AMOUNT | NUMBER | Yes | Amount of funds to consume, in the budget currency. | |||
| DATA_SET_ID | NUMBER | 18 | Unique identifier for a group of transaction. | |||
| BUDGET_CHART_OF_ACCOUNTS_ID | NUMBER | 18 | Identifier for the budget chart of accounts. | |||
| OLD_BUDGET_CCID | NUMBER | 18 | Identifier for the previous budget account. | |||
| BUDGET_CCID | NUMBER | 18 | Identifier for the new budget account. | |||
| SEGMENT_VALUE1 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT_VALUE2 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT_VALUE3 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT_VALUE4 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT_VALUE5 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT_VALUE6 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT_VALUE7 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT_VALUE8 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT_VALUE9 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT_VALUE10 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT_VALUE11 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT_VALUE12 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT_VALUE13 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT_VALUE14 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT_VALUE15 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT_VALUE16 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT_VALUE17 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT_VALUE18 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT_VALUE19 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT_VALUE20 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT_VALUE21 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT_VALUE22 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT_VALUE23 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT_VALUE24 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT_VALUE25 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT_VALUE26 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT_VALUE27 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT_VALUE28 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT_VALUE29 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT_VALUE30 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
| CONCATENATED_SEGMENTS | VARCHAR2 | 1000 | Concatenated value of the segments in the budget account. | |||
| ERROR_TYPE | VARCHAR2 | 30 | Indicates the type of error.Valid values are Warning and Error. | |||
| ERROR_MESSAGE | VARCHAR2 | 1000 | Error or Warning message displayed when recalculation has failed for this row. Otherwise, the value is null. | |||
| BALANCE_TYPE_CODE | VARCHAR2 | 30 | Identifies the type of balance. Valid values are Obligation, Commitment, Other, Actual and Budget. | |||
| SUB_BALANCE_TYPE_CODE | VARCHAR2 | 30 | Indicates the type of balance impacted by this row, tracked at a more detailed level. Some examples are Approved Commitment, Approved Obligation, Accounted Payables and Accounted Receipts. | |||
| BUDGET_ACTION | VARCHAR2 | 30 | Budget initialization or adjustment entries. | |||
| CONTROL_LEVEL_CODE | VARCHAR2 | 30 | Control level that must be applied to this row. Valid values are ABSOLUTE, ADVISORY, TRACKING and NONE. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| XCC_BALANCE_RECALC_GT_N1 | Non Unique | SUMMARY_CONTROL_BUDGET_ID |