DW_BC_BUDGET_ACCOUNT_D (Preview)

This table requires activation of Budgetary Control functional area. This table contains all combinations of budget chart of accounts associated to control budgets. The columns SEGMENT_VALUE1 to SEGMENT_VALUE30 contains segment values of the budget account combination in the order defined in the Control Budget Structure region of the Manage Control Budgets page. You can determine the control budget name by joining to XCC_CONTROL_BUDGETS using BUDGET_CHART_OF_ACCOUNTS_ID, which is the foreign key that represents a budget chart of account. The possible budget chart of account combinations for project based control budgets are Project, Project-Top Resource, Award-Project, Award-Project-Top Resource, Award-Project-Funding Source, and Award-Project-Top Resource-Funding Source. For example, a project based control budget defined with Award-Project-Funding Source, the award is stored in SEGMENT_VALUE1, Project in SEGMENT_VALUE2 and Funding Source in SEGMENT_VALUE3.

Details

Module: Budgetary Control

Key Columns

BUDGET_CODE_COMBINATION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
BUDGET_CODE_COMBINATION_ID NUMBER 38 0 True Primary Key, Represents a Budget Account    
SOURCE_RECORD_ID VARCHAR2 128     Source record identifier.    
BUDGET_CHART_OF_ACCOUNTS_ID NUMBER 38 0   Foreign Key, Represents a Budget Chart Of Account and refers to a Key Flexfield Structure Instance Number    
CONCAT_SEGMENTS VARCHAR2 999          
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.    
XCC_SEGMENT11 VARCHAR2 32     Accounting segment 11.    
XCC_SEGMENT11_VALUESET_CODE VARCHAR2 64     Accounting segment 11 value set code.    
XCC_SEGMENT12 VARCHAR2 32     Accounting segment 12.    
XCC_SEGMENT12_VALUESET_CODE VARCHAR2 64     Accounting segment 12 value set code.    
XCC_SEGMENT13 VARCHAR2 32     Accounting segment 13.    
XCC_SEGMENT13_VALUESET_CODE VARCHAR2 64     Accounting segment 13 value set code.    
XCC_SEGMENT14 VARCHAR2 32     Accounting segment 14.    
XCC_SEGMENT14_VALUESET_CODE VARCHAR2 64     Accounting segment 14 value set code.    
XCC_SEGMENT15 VARCHAR2 32     Accounting segment 15.    
XCC_SEGMENT15_VALUESET_CODE VARCHAR2 64     Accounting segment 15 value set code.    
XCC_SEGMENT16 VARCHAR2 32     Accounting segment 16.    
XCC_SEGMENT16_VALUESET_CODE VARCHAR2 64     Accounting segment 16 value set code.    
XCC_SEGMENT17 VARCHAR2 32     Accounting segment 17.    
XCC_SEGMENT17_VALUESET_CODE VARCHAR2 64     Accounting segment 17 value set code.    
XCC_SEGMENT18 VARCHAR2 32     Accounting segment 18.    
XCC_SEGMENT18_VALUESET_CODE VARCHAR2 64     Accounting segment 18 value set code.    
XCC_SEGMENT19 VARCHAR2 32     Accounting segment 19.    
XCC_SEGMENT19_VALUESET_CODE VARCHAR2 64     Accounting segment 19 value set code.    
XCC_SEGMENT20 VARCHAR2 32     Accounting segment 20.    
XCC_SEGMENT20_VALUESET_CODE VARCHAR2 64     Accounting segment 20 value set code.    
XCC_SEGMENT21 VARCHAR2 32     Accounting segment 21.    
XCC_SEGMENT21_VALUESET_CODE VARCHAR2 64     Accounting segment 21 value set code.    
XCC_SEGMENT22 VARCHAR2 32     Accounting segment 22.    
XCC_SEGMENT22_VALUESET_CODE VARCHAR2 64     Accounting segment 22 value set code.    
XCC_SEGMENT23 VARCHAR2 32     Accounting segment 23.    
XCC_SEGMENT23_VALUESET_CODE VARCHAR2 64     Accounting segment 23 value set code.    
XCC_SEGMENT24 VARCHAR2 32     Accounting segment 24.    
XCC_SEGMENT24_VALUESET_CODE VARCHAR2 64     Accounting segment 24 value set code.    
XCC_SEGMENT25 VARCHAR2 32     Accounting segment 25.    
XCC_SEGMENT25_VALUESET_CODE VARCHAR2 64     Accounting segment 25 value set code.    
XCC_SEGMENT26 VARCHAR2 32     Accounting segment 26.    
XCC_SEGMENT26_VALUESET_CODE VARCHAR2 64     Accounting segment 26 value set code.    
XCC_SEGMENT27 VARCHAR2 32     Accounting segment 27.    
XCC_SEGMENT27_VALUESET_CODE VARCHAR2 64     Accounting segment 27 value set code.    
XCC_SEGMENT28 VARCHAR2 32     Accounting segment 28.    
XCC_SEGMENT28_VALUESET_CODE VARCHAR2 64     Accounting segment 28 value set code.    
XCC_SEGMENT29 VARCHAR2 32     Accounting segment 29.    
XCC_SEGMENT29_VALUESET_CODE VARCHAR2 64     Accounting segment 29 value set code.    
XCC_SEGMENT30 VARCHAR2 32     Accounting segment 30.    
XCC_SEGMENT30_VALUESET_CODE VARCHAR2 64     Accounting segment 30 value set code.    
SUMMARY_FLAG VARCHAR2 16     Indicates if this account is a summary or detail account    
ENABLED_FLAG VARCHAR2 16     Indicates if this account is enabled or disabled    
START_DATE_ACTIVE DATE       Date on which this account is available for use    
END_DATE_ACTIVE DATE       Date on which this account is no longer available for use    
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, 2023, Oracle and/or its affiliates.