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

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