# DW_INTERNAL_ORG_D

This table contains information about organizations and business units.

## Details

Module:

## Key Columns

ORGANIZATION_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
ORGANIZATION_ID | NUMBER | 38 | 0 | True | Business unit or organization identifier. Value is derived from the table DW_INTERNAL_ORG_D_TL. |  |
SOURCE_RECORD_ID | NUMBER | 38 | 0 |  | This column is for Oracle Internal use only. Source record identifier of the usiness unit or organization. |  |
EFFECTIVE_START_DATE | DATE |  |  |  | Organization effective start date, date range within which the row is effective. |  |
EFFECTIVE_END_DATE | DATE |  |  |  | Organization effective end date, date range within which the row is effective. |  |
ORGANIZATION_MANAGER_NAME | VARCHAR2 | 999 |  |  | Organization manager name. |  |
ORG_MANAGER_PERSON_NUMBER | VARCHAR2 | 32 |  |  | Organization manager person number. |  |
ORG_LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Organization legal entity identifier. |  |
BUSINESS_UNIT_MANAGER_NAME | VARCHAR2 | 999 |  |  | Business unit manager name. |  |
ORGANIZATION_LOCATION_ID | NUMBER | 38 | 0 |  | Organization location identifier. |  |
CURRENCY_CODE | VARCHAR2 | 256 |  |  | Business unit default currency code. |  |
LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Business unit legal entity identifier. |  |
BUSINESS_UNIT_DATE_TO | DATE |  |  |  | Business unit end date. |  |
BUSINESS_UNIT_START_FROM | DATE |  |  |  | Business unit start date. |  |
ORGANIZATION_STATUS_CODE | VARCHAR2 | 32 |  |  | Business unit status. |  |
ORGANIZATION_CODE | VARCHAR2 | 32 |  |  | Organization code. |  |
ORGANIZATION_TYPE | VARCHAR2 | 32 |  |  | Organization type. This is a user defined type for differentiating between organizations. For example you many want to differentiate between different kinds of Departments, say as Health and Safety , Service Departments, Training. |  |
PRIMARY_LEDGER_ID | NUMBER | 38 | 0 |  | Business unit primary ledger identifier. |  |
PRIMARY_LEDGER | VARCHAR2 | 32 |  |  | Business unit primary ledger name. |  |
SET_ID | NUMBER | 38 | 0 |  | Business unit set identifier. |  |
PHONE_NUMBER | VARCHAR2 | 256 |  |  | Organization location phone number. |  |
FAX_NUMBER | VARCHAR2 | 256 |  |  | Organization location fax number. |  |
EMAIL_ADDRESS | VARCHAR2 | 256 |  |  | Organization location email. |  |
ADDRESS_LINE_1 | VARCHAR2 | 256 |  |  | Organization location address line 1. |  |
ADDRESS_LINE_2 | VARCHAR2 | 256 |  |  | Organization location address line 2. |  |
CITY_CODE | VARCHAR2 | 128 |  |  | Organization location city or town. |  |
POSTAL_CODE | VARCHAR2 | 32 |  |  | Organization location postal code. |  |
COUNTY_CODE | VARCHAR2 | 128 |  |  | Organization location county. |  |
STATE_PROV_CODE | VARCHAR2 | 128 |  |  | Organization location state or province. |  |
COUNTRY_CODE | VARCHAR2 | 64 |  |  | Organization location country. |  |
INV_LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Inventory organization legal entity identifier |  |
INV_BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Inventory organization business unit identifier |  |
INV_SUPPLIER_ID | NUMBER | 38 | 0 |  | Inventory organization supplier identifier |  |
INV_SUPPLIER_SITE_ID | NUMBER | 38 | 0 |  | Inventory organization supplier site identifier |  |
INV_MASTER_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Inventory organization master organization identifier |  |
BUSINESS_UNIT_FLAG | VARCHAR2 | 16 |  |  | Indicates whether organization is a business unit. |  |
BILLING_REVENUE_MNG_BU_FLAG | VARCHAR2 | 16 |  |  | Indicates whether business unit performs billing and revenue management business function. |  |
COLLECTIONS_MNGMNT_BU_FLAG | VARCHAR2 | 16 |  |  | Indicates whether business unit performs collections management business function. |  |
CUST_CONTRACT_MNGMNT_BU_FLAG | VARCHAR2 | 16 |  |  | Indicates whether business unit performs customer contract management business function. |  |
CUSTOMER_PAYMENTS_BU_FLAG | VARCHAR2 | 16 |  |  | Indicates whether business unit performs customer payments business function. |  |
EXPENSE_MNGMNT_BU_FLAG | VARCHAR2 | 16 |  |  | Indicates whether business unit performs expense management business function. |  |
FINANCIAL_BU_FLAG | VARCHAR2 | 16 |  |  | Indicates a financial BU. Includes business units that perform collections management, customer payments, expense management, payables invoicing, payables payment, or billing and revenue management business function. |  |
MATERIALS_MNGMNT_BU_FLAG | VARCHAR2 | 16 |  |  | Indicates whether business unit performs materials management business function. |  |
PAYABLES_INVOICING_BU_FLAG | VARCHAR2 | 16 |  |  | Indicates whether business unit performs payables invoicing business function. |  |
PAYABLES_PAYMENT_BU_FLAG | VARCHAR2 | 16 |  |  | Indicates whether business unit performs payables payment business function. |  |
PRC_CONTRACT_MNGMNT_BU_FLAG | VARCHAR2 | 16 |  |  | Indicates whether business unit performs procurement contract management business function. |  |
PROCUREMENT_BU_FLAG | VARCHAR2 | 16 |  |  | Indicates whether business unit performs procurement business function. |  |
PROJECT_ACCOUNTING_BU_FLAG | VARCHAR2 | 16 |  |  | Indicates whether business unit performs project accounting business function. |  |
RECEIVING_BU_FLAG | VARCHAR2 | 16 |  |  | Indicates whether business unit performs receiving business function. |  |
REQUISITION_BU_FLAG | VARCHAR2 | 16 |  |  | Indicates whether business unit performs requisitioning business function. |  |
COST_ORGANIZATION_FLAG | VARCHAR2 | 16 |  |  | Indicates a cost organization. |  |
DEPARTMENT_FLAG | VARCHAR2 | 16 |  |  | Indicates a department or human resource organization. |  |
ENTERPRISE_FLAG | VARCHAR2 | 16 |  |  | Indicates an enterprise. |  |
EXPENDITURE_ORGANIZATION_FLAG | VARCHAR2 | 16 |  |  | Indicates an expenditure organization. |  |
INTERNAL_FLAG | VARCHAR2 | 16 |  |  | Indicates an internal organization. |  |
INV_ORGANIZATION_FLAG | VARCHAR2 | 16 |  |  | Indicates an inventory organization. |  |
PAYROLL_STATUTORY_UNIT_FLAG | VARCHAR2 | 16 |  |  | Indicates a payroll statutory unit. |  |
PROJECT_ORGANIZATION_FLAG | VARCHAR2 | 16 |  |  | Indicates a project organization. |  |
PROJECT_UNIT_FLAG | VARCHAR2 | 16 |  |  | Indicates a project unit. |  |
REPORTING_EST_FLAG | VARCHAR2 | 16 |  |  | Indicates a reporting establishment. |  |
SALES_GROUP_FLAG | VARCHAR2 | 16 |  |  | Indicates a marketing resource, sales resource, partner resource, or resource organization. |  |
LEGAL_EMPLOYER_FLAG | VARCHAR2 | 16 |  |  | Indicates a legal employer. |  |
DISABILITY_ORGANIZATION_FLG | VARCHAR2 | 16 |  |  | Indicates a disability organization. |  |
INV_INVENTORY_FLAG | VARCHAR2 | 16 |  |  | Indicates the usge of Organization. | DW_INV_ORG_USAGE_LKP_TL | INV_ORG_USAGE_CODE
TAX_REPORTING_UNIT_FLAG | VARCHAR2 | 16 |  |  | Indicates whether organization is a tax reporting unit organization. |  |
INV_PROFIT_CENTER_BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Business unit that serves as the profit center.This may or may not be the same as the Management Business Unit. |  |
MFG_PLANT_FLAG | VARCHAR2 | 16 |  |  | Indicates whether Organization is Manufacturing plant or not. |  |
LEASE_ACCOUNTING_BU_FLAG | VARCHAR2 | 16 |  |  | Indicates whether business unit performs Lease Accounting business function. |  |
UNION_FLAG | VARCHAR2 | 16 |  |  | Indicates whether organization is a Union. |  |

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