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.