# DW_BC_BALANCE_CF (Preview)

This table requires activation of Budgetary Control functional area. This fact table stores the budget balances and consumption of budget for each control budget, budget account and period.

## Details

Module: Budgetary Control

## Key Columns

PERIOD_NAME, BUDGET_CODE_COMBINATION_ID, CONTROL_BUDGET_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
CONTROL_BUDGET_ID | NUMBER | 38 | 0 | True | Identifies the impacted control budget. | DW_BC_CONTROL_BUDGET_D | CONTROL_BUDGET_ID
BUDGET_CODE_COMBINATION_ID | NUMBER | 38 | 0 | True | Identifier of the budget account for which this balance is being tracked. | DW_BC_BUDGET_ACCOUNT_D | BUDGET_CODE_COMBINATION_ID
PERIOD_NAME | VARCHAR2 | 32 |  | True | Corresponds to the budget period of this balance. |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. Source record identifier. Value is derived from a combination of Asset adjustment identifiers. |  |
PERIOD_SET_NAME | VARCHAR2 | 32 |  |  | Budget calendar period set name |  |
PERIOD_TYPE | VARCHAR2 | 32 |  |  | Control budget calendar period type |  |
LEDGER_ID | NUMBER | 38 | 0 |  | Primary ledgers defined in GL and enabled for budgetary control. Default value is -98. | DW_LEDGER_D | LEDGER_ID
LEDGER_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Ledger Currency Code |  |
CHART_OF_ACCOUNTS_ID | NUMBER | 38 | 0 |  | Key flexfield structure defining column for the associated ledger's chart of accounts |  |
BUDGET_CHART_OF_ACCOUNTS_ID | NUMBER | 38 | 0 |  | Key flexfield structure defining column for the control budget accounts |  |
XCC_SEGMENT1 | VARCHAR2 | 512 |  |  | Accounting segment 1. | DW_XCC_SEGMENT1_D | XCC_SEGMENT_CODE
XCC_SEGMENT1_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 1 value set code. | DW_XCC_SEGMENT1_D | XCC_SEGMENT_VALUESET_CODE
XCC_SEGMENT2 | VARCHAR2 | 512 |  |  | Accounting segment 2. | DW_XCC_SEGMENT2_D | XCC_SEGMENT_CODE
XCC_SEGMENT2_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 2 value set code. | DW_XCC_SEGMENT2_D | XCC_SEGMENT_VALUESET_CODE
XCC_SEGMENT3 | VARCHAR2 | 512 |  |  | Accounting segment 3. | DW_XCC_SEGMENT3_D | XCC_SEGMENT_CODE
XCC_SEGMENT3_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 3 value set code. | DW_XCC_SEGMENT3_D | XCC_SEGMENT_VALUESET_CODE
XCC_SEGMENT4 | VARCHAR2 | 512 |  |  | Accounting segment 4. | DW_XCC_SEGMENT4_D | XCC_SEGMENT_CODE
XCC_SEGMENT4_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 4 value set code. | DW_XCC_SEGMENT4_D | XCC_SEGMENT_VALUESET_CODE
XCC_SEGMENT5 | VARCHAR2 | 512 |  |  | Accounting segment 5. | DW_XCC_SEGMENT5_D | XCC_SEGMENT_CODE
XCC_SEGMENT5_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 5 value set code. | DW_XCC_SEGMENT5_D | XCC_SEGMENT_VALUESET_CODE
XCC_SEGMENT6 | VARCHAR2 | 512 |  |  | Accounting segment 6. | DW_XCC_SEGMENT6_D | XCC_SEGMENT_CODE
XCC_SEGMENT6_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 6 value set code. | DW_XCC_SEGMENT6_D | XCC_SEGMENT_VALUESET_CODE
XCC_SEGMENT7 | VARCHAR2 | 512 |  |  | Accounting segment 7. | DW_XCC_SEGMENT7_D | XCC_SEGMENT_CODE
XCC_SEGMENT7_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 7 value set code. | DW_XCC_SEGMENT7_D | XCC_SEGMENT_VALUESET_CODE
XCC_SEGMENT8 | VARCHAR2 | 512 |  |  | Accounting segment 8. | DW_XCC_SEGMENT8_D | XCC_SEGMENT_CODE
XCC_SEGMENT8_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 8 value set code. | DW_XCC_SEGMENT8_D | XCC_SEGMENT_VALUESET_CODE
XCC_SEGMENT9 | VARCHAR2 | 512 |  |  | Accounting segment 9. | DW_XCC_SEGMENT9_D | XCC_SEGMENT_CODE
XCC_SEGMENT9_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 9 value set code. | DW_XCC_SEGMENT9_D | XCC_SEGMENT_VALUESET_CODE
XCC_SEGMENT10 | VARCHAR2 | 512 |  |  | Accounting segment 10. | DW_XCC_SEGMENT10_D | XCC_SEGMENT_CODE
XCC_SEGMENT10_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 10 value set code. | DW_XCC_SEGMENT10_D | XCC_SEGMENT_VALUESET_CODE
PROJECT_ID | NUMBER | 38 | 0 |  | Project accounting project unique identifier. Default value is -98. | DW_PROJECT_D | PROJECT_ID
PROJECT_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Project Organization identifier | DW_INTERNAL_ORG_D | ORGANIZATION_ID
PJC_CONTRACT_ID | NUMBER | 38 | 0 |  | Project accounting contract unique identifier for the award associated with the budget amount. Default value is -98. | DW_AWARD_D | AWARD_ID
BUDGET_CURRENCY_CODE | VARCHAR2 | 32 |  |  | Currency assigned to the control budget |  |
BC_BUDGET_AMOUNT | NUMBER |  |  |  | Initial budget amount. Add to budget adjustment amount to get current budget. |  |
BC_BUDGET_ADJUSTMENT_AMOUNT | NUMBER |  |  |  | Amount by which the budget has been adjusted. |  |
BC_COMMITMENT_AMOUNT | NUMBER |  |  |  | Budget consumption classified as commitments, typically requisitions |  |
BC_OBLIGATION_AMOUNT | NUMBER |  |  |  | Budget consumption classified as obligations, typically purchase orders |  |
BC_OTHER_AMOUNT | NUMBER |  |  |  | Other types of budget consumption, e.g. project expenditures |  |
BC_ACTUAL_AMOUNT | NUMBER |  |  |  | Budget consumption classified as actual expenditures, typically receipts or invoices |  |
BC_FUNDS_AVAILABLE_AMOUNT | NUMBER |  |  |  | Amount available for this budget. |  |
BC_APPROVED_COMMITMENT_AMOUNT | NUMBER |  |  |  | Amount in approved commitments, a lower level bucket. |  |
BC_APPROVED_AUTHORIZATION_AMOUNT | NUMBER |  |  |  | Approved spending authorization commitment amount. |  |
BC_APPROVED_OBLIGATION_AMOUNT | NUMBER |  |  |  | Amount in approved obligations a lower level bucket. |  |
BC_DETAIL_OTHER_AMOUNT | NUMBER |  |  |  | Amount in other encumbrances, a lower level bucket. |  |
BC_UNRELEASED_BUDGET_AMOUNT | NUMBER |  |  |  | Amount that has been budgeted to this period but has not yet been released for expenditure. |  |
BC_ACCOUNTED_PAYABLES_AMOUNT | NUMBER |  |  |  | Amount in accounted payables, a lower level bucket. |  |
BC_ACCOUNTED_RECEIPTS_AMOUNT | NUMBER |  |  |  | Amount in accounted receipts, a lower level bucket. |  |
BC_ACCOUNTED_PROJECT_AMOUNT | NUMBER |  |  |  | Amount in accounted projects, a lower level bucket. |  |
BC_MISC_EXPENDITURES_AMOUNT | NUMBER |  |  |  | Amount in miscellaneous expenditures, a lower level bucket. |  |
CREATED_BY_USER_ID | VARCHAR2 | 64 |  |  | Who column: indicates the user who created the row. | DW_USER_D | USERNAME
UPDATED_BY_USER_ID | VARCHAR2 | 64 |  |  | Who column: indicates the user who last updated the row. | DW_USER_D | USERNAME
CREATION_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the row. |  |
LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the last update of the row. |  |

Copyright © 2019, 2026, Oracle and/or its affiliates.