# DW_INV_SECONDARY_LOCATORS_MAP_G

Holds the PAR setup at item-locator level

## Details

Module: Inventory Management

## Key Columns

ORGANIZATION_ID, LOCATOR_ID, 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. |  |
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. |  |

## Notes

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