DW_INV_SUBINVENTORY_D

Master Table for SubInventories

Details

Module: Inventory Management

Key Columns

ORGANIZATION_ID, SECONDARY_INVENTORY_NAME

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SECONDARY_INVENTORY_NAME VARCHAR2 16   True This is the name of the subinventory.    
ORGANIZATION_ID NUMBER 38 0 True This identifies the inventory organization.    
SOURCE_RECORD_ID VARCHAR2 64     Source Record identifier    
DESCRIPTION VARCHAR2 64     This is description of the subinventory.    
SUBINVENTORY_TYPE VARCHAR2 32     Type of subinventory. A value 1 means storage and 2 means receiving. DW_INV_SUB_TYPE_LKP_TL INV_SUB_TYPE_CODE
LOCATOR_TYPE VARCHAR2 32     Subinventory-level stock locator control type DW_INV_LOCATOR_CONTROL_LKP_TL INV_LOCATOR_CONTROL_CODE
ASSET_INVENTORY NUMBER 38 0   Items contained within the subinventory regarded as assets DW_INV_YES_NO_NUMERIC_LKP_TL INV_YES_NO_NUMERIC_CODE
DISABLE_DATE DATE       Date this subinventory is disabled.    
LOCATION_ID NUMBER 38 0   This identifies the item locator. DW_WORKER_LOCATION_D LOCATION_ID
RESERVABLE_TYPE NUMBER 38 0   Indicates hard reservation eligibility in a Subinventory.    

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