# DW_INV_RCV_SUPPLY_DETAILS_CF (Preview)

This table requires activation of Current Inventory Balances functional area. This table stores information about on-hand quantities in receiving/inspection

## Details

Module: Inventory Management

## Key Columns

SUPPLY_TYPE_CODE, SUPPLY_SOURCE_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
SUPPLY_TYPE_CODE | VARCHAR2 | 32 |  | True | This code indicates the supply type. |  |
SUPPLY_SOURCE_ID | NUMBER | 38 | 0 | True | Supply source unique identifier REQ_HEADER_ID, PO_DISTRIBUTION_ID, SHIPMENT_LINE_ID or RCV_TRANSACTION_ID depending on SUPPLY_TYPE_CODE |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. System |  |
EXTRACT_TIMESTAMP | TIMESTAMP |  |  |  | Extraction Datetime |  |
REQ_HEADER_ID | NUMBER | 38 | 0 |  | Identifies the requisition header. |  |
REQ_LINE_ID | NUMBER | 38 | 0 |  | Identifies the requisition line. |  |
PO_HEADER_ID | NUMBER | 38 | 0 |  | Purchase order header identifier |  |
PO_LINE_ID | NUMBER | 38 | 0 |  | This identifies a purchase order line. |  |
PO_LINE_LOCATION_ID | NUMBER | 38 | 0 |  | Purchase order line location identifier |  |
SHIPMENT_HEADER_ID | NUMBER | 38 | 0 |  | This column identifies the shipment. |  |
SHIPMENT_LINE_ID | NUMBER | 38 | 0 |  | This identifies the shipment line. |  |
RCV_TRANSACTION_ID | NUMBER | 38 | 0 |  | Receiving transaction identifier |  |
ITEM_ID | NUMBER | 38 | 0 |  | This identifies the inventory item. #1 | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID
ITEM_REVISION | VARCHAR2 | 32 |  |  | Revision of the inventory item. |  |
QUANTITY | NUMBER |  |  |  | This is the actual supply quantity. |  |
UOM_CODE | VARCHAR2 | 16 |  |  | Unit of measure code for actual supply quantity | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
TO_ORG_PRIMARY_QUANTITY | NUMBER |  |  |  | Supply quantity in terms of primary unit of measure of item in destination organization |  |
TO_ORG_PRIMARY_UOM_CODE | VARCHAR2 | 16 |  |  | Primary unit of measure code of the item in destination organization | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
RECEIPT_DATE | DATE |  |  |  | Expected or actual receipt date depending on supply type #3 | DW_DAY_D | CALENDAR_DATE
FROM_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Sending organization identifier for interorg shipment | DW_INTERNAL_ORG_D | ORGANIZATION_ID
FROM_SUBINVENTORY | VARCHAR2 | 16 |  |  | From subinventory code of the source organization for in-transit shipment. #2 | DW_INV_SUBINVENTORY_D | SECONDARY_INVENTORY_NAME
TO_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Destination organization identifier | DW_INTERNAL_ORG_D | ORGANIZATION_ID
TO_SUBINVENTORY | VARCHAR2 | 16 |  |  | This column stores the destination subinventory in the receiving organization. #2 | DW_INV_SUBINVENTORY_D | SECONDARY_INVENTORY_NAME
TO_LOCATOR_ID | NUMBER | 38 | 0 |  | Inventory locator unique identifier in the receiving organization. | DW_INV_LOCATOR_D | INVENTORY_LOCATION_ID
SECONDARY_QUANTITY | NUMBER |  |  |  | Supply quantity stored in the secondary unit of measure of the inventory item. |  |
SECONDARY_UOM_CODE | VARCHAR2 | 16 |  |  | This column stores the secondary unit of measure code of the inventory item in the receiving organization. | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
TRANSFER_ORDER_HEADER_ID | NUMBER | 38 | 0 |  | Transfer order header unique identifier |  |
TRANSFER_ORDER_LINE_ID | NUMBER | 38 | 0 |  | Transfer order line unique identifier |  |
PROJECT_ID | NUMBER | 38 | 0 |  | Identifier of the project corresponding to the source document. | DW_PROJECT_D | PROJECT_ID
TASK_ID | NUMBER | 38 | 0 |  | Identifier of the task corresponding to the source document. | DW_PROJECT_ELEMENT_D | PROJ_ELEMENT_ID
COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | 16 |  |  | This column stores the Code for the country of manufacture. | DW_INSERT_COUNTRY_LKP_TL | INSERT_COUNTRY_LKP_CODE
SUBINVENTORY_LOCATION_ID | NUMBER | 38 | 0 |  | This identifies the location of the subinventory | DW_WORKER_LOCATION_D | LOCATION_ID
BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | This identifies the business unit | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
INVENTORY_ORG_PROFIT_CENTER_BU_ID | NUMBER | 38 | 0 |  | Profit Center Business Unit Id of the Inventory Organization. | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
DATA_AS_OF_DATE | DATE |  |  |  | Date on which data load was started | DW_DAY_D | CALENDAR_DATE
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | Name of the accounting calendar. #3 | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | Accounting period type. Examples are Weekly, Monthly, Quarterly. #3 | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
PRIMARY_LEDGER_ID | NUMBER | 38 | 0 |  | Business unit primary ledger identifier. | DW_LEDGER_D | LEDGER_ID
LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Business unit legal entity identifier. | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID

## Notes

#1 In these cases in addition to the item columns ORGANIZATION_ID column should also be used for join with DW_INVENTORY_ITEM_D #2 In these cases in addition to the subinventory code column, ORGANIZATION_ID column should also be used for join with DW_INV_SUBINVENTORY_D #3 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 RECEIPT_DATE column

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