DW_BC_SUPPLEMENTAL_RULE_D (Preview)

This table requires activation of Budgetary Control functional area. This table stores the implemented control budget supplementary rules.

Details

Module: Budgetary Control

Key Columns

RULE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
RULE_ID NUMBER 38 0 True Supplemental Rule Unique Identifier    
SOURCE_RECORD_ID VARCHAR2 128     Source record identifier.    
CONTROL_BUDGET_ID NUMBER 38 0   Control Budget Identifier    
RULE_NAME VARCHAR2 128     The name of the supplemental budgetary control rule    
DESCRIPTION VARCHAR2 256     The description of the supplemental budgetary control rule    
CONTROL_LEVEL_CODE VARCHAR2 32     Control level code that will be used when determining funds available for distribution that fall into this supplemental budgetary control or default rule    
TOLERANCE_PERCENT NUMBER       The % of the budgeted amount that will be used as tolerance    
TOLERANCE_AMOUNT NUMBER       The fixed amount that will be used as tolerance    
BUSINESS_UNIT_ID NUMBER 38 0   Business unit internal identifier    
ENABLED_FLAG VARCHAR2 16     Indicates whether this supplemental rule is enabled or not    
ALLOW_UPDATE_FLAG VARCHAR2 16     Indicates whether this rule can be updated.    
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.