DW_BC_COMPILED_RULE_D (Preview)

This table requires activation of Budgetary Control functional area. This table contains the control budget supplemental rules.

Details

Module: Budgetary Control

Key Columns

RULE_ID, FILTER_CONDITION_CODE, CONTROL_BUDGET_ID, FILTER_CONDITION_VALUE, FILTER_CONDITION_TYPE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CONTROL_BUDGET_ID NUMBER 38 0 True Control Budget Identifier    
FILTER_CONDITION_TYPE VARCHAR2 32   True Indicates whether this condition is associated with a budget segment, a chart of accounts segment, a project segment, a project planning element, or a transaction attribute.    
FILTER_CONDITION_CODE VARCHAR2 32   True Indicates the budget segment, chart of accounts segment, project segment, project planning element, or transaction attribute that the condition applies to.    
FILTER_CONDITION_VALUE VARCHAR2 128   True Value that the condition applies to. A single space is stored if this condition applies to all values.    
RULE_ID NUMBER 38 0 True Control Budget Supplemental Rule Identifier, references XCC_CB_RULES.RULE_ID    
SOURCE_RECORD_ID VARCHAR2 128     Source record identifier.    
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.