# DW_INV_ITEM_SUB_INVENTORIES_MAP_G

Holds the PAR/min-max setup/configuration details at item-subinventory level

## Details

Module: Inventory Management

## Key Columns

ORGANIZATION_ID, SECONDARY_INVENTORY_NAME, INVENTORY_ITEM_ID

## Columns

Columns
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. |  |

## Notes

This table maintains a listing of subinventories assigned to an inventory or engineering item

Copyright © 2019, 2026, Oracle and/or its affiliates.