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.
Module: Budgetary Control
BUDGET_CODE_COMBINATION_ID, CONTROL_BUDGET_ID, PERIOD_NAME
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.