This table contains Inventory Replenishment Details
Module: Inventory Management
REPLENISHMENT_ID
| 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. |
#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.