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

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