DW_INTERNAL_ORG_D
This table contains information about organizations and business units.
Details
Module:
Key Columns
ORGANIZATION_ID
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. |