Master table for Stock Locators
Module: Inventory Management
INVENTORY_LOCATION_ID
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 |
Copyright © 2019, 2024, Oracle and/or its affiliates.