DW_INV_ORGANIZATION_D

This table stores the inventroy organization information

Details

Module:

Key Columns

INV_ORGANIZATION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
INV_ORGANIZATION_ID NUMBER 38 0 True Inventroy organization Id, Translation in DW_INTERNAL_ORG_D_TL table.
SOURCE_RECORD_ID NUMBER 38 0 This column is for Oracle Internal use only. Uniquely identifies a inventroy organization.
INV_ORGANIZATION_CODE VARCHAR2 32 Organization code.
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
LOCATION_ID NUMBER 38 0 Inventory organization location identifier.
PHONE_NUMBER VARCHAR2 256 Inventory organization location phone number.
FAX_NUMBER VARCHAR2 256 Inventory organization location fax number.
EMAIL_ADDRESS VARCHAR2 256 Inventory organization location email.
ADDRESS_LINE_1 VARCHAR2 256 Inventory organization location address line 1.
ADDRESS_LINE_2 VARCHAR2 256 Inventory organization location address line 2.
CITY_CODE VARCHAR2 128 Inventory organization location city or town.
POSTAL_CODE VARCHAR2 32 Inventory organization location postal code.
COUNTY_CODE VARCHAR2 128 Inventory organization location county.
STATE_PROV_CODE VARCHAR2 128 Inventory organization location state or province.
COUNTRY_CODE VARCHAR2 64 Inventory organization location country.
STATUS_CODE VARCHAR2 32 Indicates if an organization is active or inactive. DW_ACTIVE_INACTIVE_LKP_TL ACTIVE_INACTIVE_LKP_CODE
INV_INVENTORY_FLAG VARCHAR2 16 Indicates the usge of Organization. DW_INV_ORG_USAGE_LKP_TL INV_ORG_USAGE_CODE
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.
PRIMARY_LEDGER_ID NUMBER 38 0 Business unit primary ledger identifier.