DW_INV_SUBINVENTORY_D

Master Table for SubInventories

Details

Module: Inventory Management

Key Columns

SECONDARY_INVENTORY_NAME, ORGANIZATION_ID

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 This column is for Oracle Internal use only. 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.