Holds the PAR/min-max setup/configuration details at item-subinventory level
Module: Inventory Management
ORGANIZATION_ID, SECONDARY_INVENTORY_NAME, 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. | ||
| ORGANIZATION_ID | NUMBER | 38 | 0 | True | This identifies the inventory organization. | ||
| SECONDARY_INVENTORY_NAME | VARCHAR2 | 16 | True | This is the name of the subinventory. | |||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. Source Record identifier | ||||
| INVENTORY_PLANNING_CODE | NUMBER | 38 | 0 | This code indicates the item planning method. | DW_INV_MATERIAL_PLANNING_LKP_TL | INV_MATERIAL_PLANNING_CODE | |
| MINMAX_QUANTITY_UOM | VARCHAR2 | 16 | This indentifies the minmax quantity uom. | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE | ||
| MIN_MINMAX_QUANTITY | NUMBER | Subinventory-level minmax planning minimum quantity | |||||
| MAX_MINMAX_QUANTITY | NUMBER | Subinventory-level minmax planning maximum quantity | |||||
| FIXED_LOT_MULTIPLE | NUMBER | 38 | 0 | Subinventory-level fixed lot multiple | |||
| MINIMUM_ORDER_QUANTITY | NUMBER | Subinventory-level minimum order quantity | |||||
| MAXIMUM_ORDER_QUANTITY | NUMBER | Subinventory-level maximum order quantity | |||||
| 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 | ||
| 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. | |||||
| 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. | |||||
| FULL_LPN_FLAG | VARCHAR2 | 16 | Flag indicating if full LPN transaction should be enforced for the item and subinventory. | ||||
| SOURCE_TYPE_CODE | VARCHAR2 | 32 | Inventory or supplier source type | DW_INV_SOURCE_TYPES_LKP_TL | INV_SOURCE_TYPES_CODE | ||
| SOURCE_ORGANIZATION_ID | NUMBER | 38 | 0 | Organization to source items fromOrganization to source items from | DW_INTERNAL_ORG_D | ORGANIZATION_ID | |
| SOURCE_SUBINVENTORY | VARCHAR2 | 16 | Subinventory to source items from | DW_INV_SUBINVENTORY_D | SECONDARY_INVENTORY_NAME | ||
| 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. | |||||
| LAST_REPLENISHED_DATE | DATE | Date when the item is replenished during a PAR count. | DW_DAY_D | CALENDAR_DATE | |||
| LAST_REPLENISHED_TIMESTAMP | TIMESTAMP | Date when the item is replenished during a PAR count. |
This table maintains a listing of subinventories assigned to an inventory or engineering item
Copyright © 2019, 2026, Oracle and/or its affiliates.