This table stores the Business Units information
Module:
BUSINESS_UNIT_ID
| 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_CODE_VALUES_LKP_TL with CODE_TYPE='ACTIVE_INACTIVE' | ||||
| BUSINESS_UNIT_MANAGER_NAME | VARCHAR2 | 999 | Business unit manager name. | ||||
| CURRENCY_CODE | VARCHAR2 | 256 | Business unit default currency code. |
Copyright © 2019, 2024, Oracle and/or its affiliates.