DW_INV_LOCATOR_D

Master table for Stock Locators

Details

Module: Inventory Management

Key Columns

INVENTORY_LOCATION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
INVENTORY_LOCATION_ID NUMBER 38 0 True This identifies the inventory locator.
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. Source Record Identifier
ORGANIZATION_ID NUMBER 38 0 This identifies the inventory organization.
INVENTORY_ITEM_ID NUMBER 38 0 This identifies the inventory item.
LOCATOR_NAME VARCHAR2 999 Concatenated segment values.
DESCRIPTION VARCHAR2 64 Locator Key Flex Field
INVENTORY_LOCATION_TYPE VARCHAR2 32 This is the type of inventory locator. DW_INV_LOCATOR_TYPE_LKP_TL INV_LOCATOR_TYPE_CODE
DISABLE_DATE DATE Date when this locator is disabled