DW_BUSINESS_UNIT_D

This table stores the Business Units information

Details

Module:

Key Columns

BUSINESS_UNIT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
BUSINESS_UNIT_ID NUMBER 38 0 True Business Unit Id, Translation in DW_INTERNAL_ORG_D_TL table.    
SOURCE_RECORD_ID NUMBER 38 0   This column is for Oracle Internal use only. Uniquely identifies a Business Unit Id    
PRIMARY_LEDGER_ID NUMBER 38 0   Business unit primary ledger identifier.    
PRIMARY_LEDGER VARCHAR2 32     Business unit primary ledger name.    
STATUS_CODE VARCHAR2 32     Indicates if a business unit is active or inactive. For translation, refer table DW_ACTIVE_INACTIVE_LKP_TL with CODE_TYPE='ACTIVE_INACTIVE' DW_ACTIVE_INACTIVE_LKP_TL ACTIVE_INACTIVE_LKP_CODE
BUSINESS_UNIT_MANAGER_NAME VARCHAR2 999     Business unit manager name.    
CURRENCY_CODE VARCHAR2 256     Business unit default currency code.    

Copyright © 2019, 2025, Oracle and/or its affiliates.