Master Table for SubInventories
Module: Inventory Management
ORGANIZATION_ID, SECONDARY_INVENTORY_NAME
| 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. | |||
| STATUS_ID | NUMBER | 38 | 0 | Status Identifier | DW_INV_MATERIAL_STATUSES_TL | STATUS_ID | |
| QUANTITY_TRACKED_CODE | NUMBER | 38 | 0 | Flag indicating onhand item quantity is recorded | DW_INV_YES_NO_NUMERIC_LKP_TL | INV_YES_NO_NUMERIC_CODE | |
| DEPRECIABLE_FLAG | NUMBER | 38 | 0 | Flag indicating if the sub inventory is depreciable | DW_INV_YES_NO_NUMERIC_LKP_TL | INV_YES_NO_NUMERIC_CODE | |
| LPN_CONTROLLED_CODE | NUMBER | 38 | 0 | Flag indicates whether the subinventory is packing unit controlled. | DW_INV_YES_NO_NUMERIC_LKP_TL | INV_YES_NO_NUMERIC_CODE | |
| DEFAULT_LOC_STATUS_ID | NUMBER | 38 | 0 | Default status ID for locators | DW_INV_MATERIAL_STATUSES_TL | STATUS_ID | |
| PAR_ENABLED_CODE | NUMBER | 38 | 0 | This enables PAR level planning. | DW_INV_YES_NO_NUMERIC_LKP_TL | INV_YES_NO_NUMERIC_CODE | |
| COUNT_METHOD_CODE | VARCHAR2 | 32 | Indicates the PAR Replenishment Count Method.Count method Values:,Two-Bin,Request,Count | DW_ORA_REPLENISHMENT_COUNT_METHOD_LKP_TL | ORA_REPLENISHMENT_COUNT_METHOD_CODE | ||
| DEFAULT_COUNT_TYPE_CODE | VARCHAR2 | 32 | Default Replenishment Count Type. | DW_INV_DEFAULT_REPLEN_COUNT_TYPE_LKP_TL | INV_DEFAULT_REPLEN_COUNT_TYPE_CODE | ||
| SUBINVENTORY_GROUP | VARCHAR2 | 128 | Name of the Subinventory Group. | ||||
| SOURCE_TYPE_CODE | VARCHAR2 | 32 | Inventory or Supplier sourcing type | DW_INV_SOURCE_TYPES_LKP_TL | INV_SOURCE_TYPES_CODE | ||
| SOURCE_SUBINVENTORY | VARCHAR2 | 16 | Subinventory to source items from | ||||
| SOURCE_ORGANIZATION_ID | NUMBER | 38 | 0 | Organization to source items from | DW_INTERNAL_ORG_D | ORGANIZATION_ID | |
| PREPROCESSING_LEAD_TIME | NUMBER | This is the lead time for pre-processing. | |||||
| PROCESSING_LEAD_TIME | NUMBER | This is the lead time for processing. | |||||
| POSTPROCESSING_LEAD_TIME | NUMBER | This is the lead time for post-processing. |
Copyright © 2019, 2026, Oracle and/or its affiliates.