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.