# 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.