# DW_INV_REPLENISHMENTS_CF

This table contains Inventory Replenishment Details

## Details

Module: Inventory Management

## Key Columns

REPLENISHMENT_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
REPLENISHMENT_ID | NUMBER | 38 | 0 | True | This column stores the unique identifier for the replenishment |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. Source Record identifier |  |
REPLENISH_REQUEST_ID | NUMBER | 38 | 0 |  | Group id of the replenish request |  |
INVENTORY_ITEM_ID | NUMBER | 38 | 0 |  | #2 Unique value for identifying the item of the Replenishment | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID
ORGANIZATION_ID | NUMBER | 38 | 0 |  | #2, #3 Unique value for identifying organization for replenishment | DW_INTERNAL_ORG_D | ORGANIZATION_ID
INVENTORY_ORG_PROFIT_CENTER_BU_ID | NUMBER | 38 | 0 |  | Business unit that serves as the profit center. | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Inventory organization business unit identifier | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Inventory organization legal entity identifier | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID
PRIMARY_LEDGER_ID | NUMBER | 38 | 0 |  | Business unit primary ledger identifier | DW_LEDGER_D | LEDGER_ID
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | #1 Name of the accounting calendar. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | #1 Accounting period type. Examples are Weekly, Monthly, Quarterly. | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
SUBINVENTORY_CODE | VARCHAR2 | 16 |  |  | #3 Subinventory of the replenishment request | DW_INV_SUBINVENTORY_D | SECONDARY_INVENTORY_NAME
SUBINVENTORY_LOCATION_ID | NUMBER | 38 | 0 |  | This identifies the item locator | DW_WORKER_LOCATION_D | LOCATION_ID
LOCATOR_ID | NUMBER | 38 | 0 |  | Unique value that identifies the locator of the Replenishment | DW_INV_LOCATOR_D | INVENTORY_LOCATION_ID
COUNT_TYPE_CODE | VARCHAR2 | 32 |  |  | This column stores the replenishmet counttype | DW_INV_DEFAULT_REPLEN_COUNT_TYPE_LKP_TL | INV_DEFAULT_REPLEN_COUNT_TYPE_CODE
COUNT_METHOD_CODE | VARCHAR2 | 128 |  |  | This column stores the count method | DW_ORA_REPLENISHMENT_COUNT_METHOD_LKP_TL | ORA_REPLENISHMENT_COUNT_METHOD_CODE
COUNTED_BY_EMPLOYEE_ID | NUMBER | 38 | 0 |  | This column stores the unique identifier for the employee that performed the par count. | DW_PERSON_NAME_CURRENT_D | PERSON_ID
REORDER_SOURCE_TYPE | VARCHAR2 | 32 |  |  | This column stores the sourcing type of the replenishment. |  |
REORDER_SOURCE_ORGANIZATION_ID | NUMBER | 38 | 0 |  | #4 This column stores the sourcing organization identofier. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
REORDER_SOURCE_SUBINVENTORY_CODE | VARCHAR2 | 16 |  |  | #4 This column stores the sourcing subinventory | DW_INV_SUBINVENTORY_D | SECONDARY_INVENTORY_NAME
REORDER_SOURCE_SUBINVENTORY_LOCATION_ID | NUMBER | 38 | 0 |  | This identifies the item locator | DW_WORKER_LOCATION_D | LOCATION_ID
SUPPLY_CUTOFF_DATE | DATE |  |  |  | This column stored the supply cutoff date. | DW_DAY_D | CALENDAR_DATE
CREATION_DATE | DATE |  |  |  | #1 Indicates the date and time of the creation of the row. | DW_DAY_D | CALENDAR_DATE
CREATION_TIMESTAMP | TIMESTAMP |  |  |  | Indicates the date and time of the creation of the row. |  |
LAST_UPDATE_TIMESTAMP | TIMESTAMP |  |  |  | Indicates the date and time of the last update of the row. |  |
REQUEST_UOM | VARCHAR2 | 16 |  |  | Unit of measure code of the Replenishment | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
REQUEST_QUANTITY | NUMBER |  |  |  | This column stores Quantity of the Replenishment |  |
PUOM_CODE | VARCHAR2 | 16 |  |  | The principal unit of measure in which the quantity of an item is managed | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
PUOM_REQUEST_QUANTITY | NUMBER |  |  |  | This column stores Quantity of the Replenishment |  |
TRANSACTION_REORDER_UOM | VARCHAR2 | 16 |  |  | Reorder uom code of the Replenishment | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
TRANSACTION_REORDER_QUANTITY | NUMBER |  |  |  | Reorder quantity of the Replenishment |  |
PUOM_REORDER_QUANTITY | NUMBER |  |  |  | Reorder quantity of the Replenishment |  |
SECONDARY_REORDER_UOM | VARCHAR2 | 16 |  |  | This column stores the secondary uom code. | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
SECONDARY_REORDER_QUANTITY | NUMBER |  |  |  | This column stores the secondary reotder quantity. |  |

## Notes

#1 In these cases to join with DW_FISCAL_DAY_D apart from FISCAL_PERIOD_TYPE and FISCAL_PERIOD_SET_NAME the relationship should be based on CREATION_DATE column. #2 In these cases in addition to the inventory item id column, ORGANIZATION_ID column should also be used for join with DW_INVENTORY_ITEM_D. #3 In these cases in addition to SUBINVENTORY_CODE column, the ORGANIZATION_ID column should be used for join with DW_INV_SUBINVENTORY_D. #4 In these cases in addition to REORDER_SOURCE_SUBINVENTORY_CODE column, the REORDER_SOURCE_ORGANIZATION_ID column should be used for join with DW_INV_SUBINVENTORY_D.

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