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

BUDGET_CODE_COMBINATION_ID, CONTROL_BUDGET_ID, PERIOD_NAME

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.    
BUDGET_CODE_COMBINATION_ID NUMBER 38 0 True Identifier of the budget account for which this balance is being tracked.    
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.    
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 32     Accounting segment 1.    
XCC_SEGMENT1_VALUESET_CODE VARCHAR2 64     Accounting segment 1 value set code.    
XCC_SEGMENT2 VARCHAR2 32     Accounting segment 2.    
XCC_SEGMENT2_VALUESET_CODE VARCHAR2 64     Accounting segment 2 value set code.    
XCC_SEGMENT3 VARCHAR2 32     Accounting segment 3.    
XCC_SEGMENT3_VALUESET_CODE VARCHAR2 64     Accounting segment 3 value set code.    
XCC_SEGMENT4 VARCHAR2 32     Accounting segment 4.    
XCC_SEGMENT4_VALUESET_CODE VARCHAR2 64     Accounting segment 4 value set code.    
XCC_SEGMENT5 VARCHAR2 32     Accounting segment 5.    
XCC_SEGMENT5_VALUESET_CODE VARCHAR2 64     Accounting segment 5 value set code.    
XCC_SEGMENT6 VARCHAR2 32     Accounting segment 6.    
XCC_SEGMENT6_VALUESET_CODE VARCHAR2 64     Accounting segment 6 value set code.    
XCC_SEGMENT7 VARCHAR2 32     Accounting segment 7.    
XCC_SEGMENT7_VALUESET_CODE VARCHAR2 64     Accounting segment 7 value set code.    
XCC_SEGMENT8 VARCHAR2 32     Accounting segment 8.    
XCC_SEGMENT8_VALUESET_CODE VARCHAR2 64     Accounting segment 8 value set code.    
XCC_SEGMENT9 VARCHAR2 32     Accounting segment 9.    
XCC_SEGMENT9_VALUESET_CODE VARCHAR2 64     Accounting segment 9 value set code.    
XCC_SEGMENT10 VARCHAR2 32     Accounting segment 10.    
XCC_SEGMENT10_VALUESET_CODE VARCHAR2 64     Accounting segment 10 value set code.    
PROJECT_ID NUMBER 38 0   Project accounting project unique identifier. Default value is -98.    
PROJECT_ORGANIZATION_ID NUMBER 38 0   Project Organization identifier    
PJC_CONTRACT_ID NUMBER 38 0   Project accounting contract unique identifier for the award associated with the budget amount. Default value is -98.    
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_VALIDATED_PAYABLES_AMOUNT NUMBER       Amount in validated payables, a lower level bucket.    
BC_APPROVED_PROJECT_AMOUNT NUMBER       Amount in approved project, 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.    
UPDATED_BY_USER_ID VARCHAR2 64     Who column: indicates the user who last updated the row.    
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, 2024, Oracle and/or its affiliates.