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