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.