DW_BUSINESS_UNIT_D
This table stores the Business Units information
Details
Module:
Key Columns
BUSINESS_UNIT_ID
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. |