Holds the PAR setup at item-locator level
Module: Inventory Management
ORGANIZATION_ID, LOCATOR_ID, INVENTORY_ITEM_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| INVENTORY_ITEM_ID | NUMBER | 38 | 0 | True | This identifies the inventory item. | ||
| LOCATOR_ID | NUMBER | 38 | 0 | True | This identifies the secondary locator. | ||
| ORGANIZATION_ID | NUMBER | 38 | 0 | True | This identifies the inventory organization. | ||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. Source Record identifier | ||||
| SUBINVENTORY_CODE | VARCHAR2 | 16 | #1 This is name of the subinventory. | DW_INV_SUBINVENTORY_D | SECONDARY_INVENTORY_NAME | ||
| PAR_UOM_CODE | VARCHAR2 | 16 | Indicates the PAR level unit of measure associated with the item. This value will automatically default based on the item entered. | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE | ||
| PAR_LEVEL | NUMBER | Level at with the quantity should be stocked. If the count falls below this quantity, it is used to calculate the re-order quantity(if the PAR Maximum Quantity is not specified). | |||||
| PAR_MAX_QTY | NUMBER | If the count falls below the PAR level, this value is used to calculate the re-order quantity. If not specified, the PAR level will be used. | |||||
| DEFAULT_COUNT_TYPE_CODE | VARCHAR2 | 32 | Indicates the replenishment count type. Values include Order PAR, On-Hand Quantity, and Order Quantity. If this field is not specified, the Default Replenishment Count Type specified for the subinventory will be used. | DW_INV_DEFAULT_REPLEN_COUNT_TYPE_LKP_TL | INV_DEFAULT_REPLEN_COUNT_TYPE_CODE | ||
| COUNT_REQUIRED_CODE | VARCHAR2 | 16 | Indicates the item in the PAR location must be counted. | DW_INV_YES_NO_NUMERIC_LKP_TL | INV_YES_NO_NUMERIC_CODE | ||
| FULL_LPN_FLAG | VARCHAR2 | 16 | Flag indicating if full LPN transaction should be enforced for the item and locator. | ||||
| QTY_COUNT_TOLERANCE | NUMBER | Use this field to define the allowed count tolerance to be used before the system will not allow the count.This prevents data entry mistakes when counting and over-ordering on replenishment requests. |
#1 In these cases in addition to SUBINVENTORY_CODE column, the ORGANIZATION_ID column should be used for join with DW_INV_SUBINVENTORY_D
Copyright © 2019, 2026, Oracle and/or its affiliates.