# DW_INVENTORY_RECEIPT_CF

Inventory Receipts

## Details

Module: Inventory Management

## Key Columns

SHIPMENT_LINE_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
SHIPMENT_LINE_ID | NUMBER | 38 | 0 | True | Receiving shipment receipt line unique identifier. |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. Source record identifier. |  |
SHIPMENT_HEADER_ID | NUMBER | 38 | 0 |  | Receiving shipment receipt header unique identifier. |  |
SHIPMENT_NUMBER | VARCHAR2 | 32 |  |  | Shipment number assigned by the shipment source. Corresponds to the ASN number, Intransit number and Transfer order number. |  |
RECEIPT_NUMBER | VARCHAR2 | 32 |  |  | Receipt number for the receiving shipment receipt header. |  |
PACKING_SLIP | VARCHAR2 | 32 |  |  | This column stores the Packing slip number. |  |
FREIGHT_CARRIER_ID | NUMBER | 38 | 0 |  | This column stores the Freight Carrier unique identifier. | DW_PARTY_D | PARTY_ID
NUM_OF_CONTAINERS | NUMBER | 38 | 0 |  | This column stores the number of containers in the shipment. |  |
BILL_OF_LADING | VARCHAR2 | 32 |  |  | This column stores the Bill of lading number. |  |
WAYBILL_AIRBILL_NUM | VARCHAR2 | 32 |  |  | This column stores the waybill or air bill number. |  |
COMMENTS | VARCHAR2 | 999 |  |  | This column stores the note created by the receiver. |  |
SHIPPED_DATE | DATE |  |  |  | This column stores the date when the shipment was created. |  |
EXPECTED_RECEIPT_DATE | DATE |  |  |  | This column stores the Expected arrival date of the shipment. |  |
RCV_INV_ORG_ID | NUMBER | 38 | 0 |  | Inventory organization unique identifier where the receipt and shipment are created. | DW_INV_ORGANIZATION_D | INV_ORGANIZATION_ID
PROFIT_CENTER_BU_ID | NUMBER | 38 | 0 |  | Business unit that serves as the profit center.This may or may not be the same as the Management Business Unit. |  |
BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Inventory organization business unit identifier |  |
LEDGER_ID | NUMBER | 38 | 0 |  | Business unit primary ledger identifier. |  |
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | Accounting calendar name based on primary ledger of requisition org. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | Accounting period type based on primary ledger of requisition org. | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
FISCAL_PERIOD_NAME | VARCHAR2 | 64 |  |  | Accounting period name. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME
SHIPMENT_LINE_NUM | NUMBER | 38 | 0 |  | This column stores the number corresponding to the shipment line. |  |
SHIPMENT_LINE_STATUS_CODE | VARCHAR2 | 32 |  |  | Shipment status of receipt line. Values are EXPECTED, PARTIALLY RECEIVED, FULLY RECEIVED, CANCELLED. | DW_RCV_SHIPMENT_STATUS_D_TL | CODE
DOCUMENT_TYPE | VARCHAR2 | 32 |  |  | Source document code for the receiving transactions. Values are RMA and TRANSFER ORDER. | DW_RCV_SOURCE_DOCUMENT_TYPE_D_TL | CODE
DOCUMENT_NUMBER | VARCHAR2 | 128 |  |  | If document code is Transfer Orders then it is shipment num . If RMA then RMA Order number |  |
SALES_BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | This column stores the unique identifier of the business unit in which the RMA was created. |  |
CUSTOMER_ID | NUMBER | 38 | 0 |  | Customer unique identifier. Applicable for RMA transactions. |  |
SOURCE_ORGANIZATION_ID | NUMBER | 38 | 0 |  | From organization unique identifier for in-transit shipment lines. |  |
DESTINATION_ORGANIZATION_ID | NUMBER | 38 | 0 |  | This column stores Receiving organization unique identifier where the receiving shipment receipt line is created. |  |
DESTINATION_TYPE_CODE | VARCHAR2 | 32 |  |  | Destination type code for the shipment line. Values are RECEIVING, DROP SHIP, EXPENSE, INVENTORY, MANUFACTURING | DW_RCV_DESTINATION_TYPE_D_TL | CODE
ROUTING_HEADER_ID | NUMBER | 38 | 0 |  | This column stores the receiving routing unique identifier. Values: 1 (Standard receipt), 2 (Inspection required) and 3 (Direct delivery). |  |
SHIP_TO_LOCATION_ID | NUMBER | 38 | 0 |  | Receiving location unique identifier. | DW_WORKER_LOCATION_D | LOCATION_ID
DELIVER_TO_LOCATION_ID | NUMBER | 38 | 0 |  | This column stores the deliver to location unique identifier. |  |
DELIVER_TO_PERSON_ID | NUMBER | 38 | 0 |  | This column stores the deliver to person, or requester, unique identifier. |  |
ITEM_ID | NUMBER | 38 | 0 |  | This column stores the inventory item unique identifier of the document for which the receiving shipment receipt line is created. Columns (INVENTORY_ITEM_ID, SHIP_TO_ORG_ID) joins DW_INVENTORY_ITEM_D (INVENTORY_ITEM_ID, ORGANIZATION_ID) | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID ,ORGANIZATION_ID
ITEM_DESCRIPTION | VARCHAR2 | 256 |  |  | This column stores the purchase order line item description for PO receipts. For other documents, it stores the inventory item description. |  |
CATEGORY_ID | NUMBER | 38 | 0 |  | This column stores the Item category unique identifier. | DW_ITEM_CATEGORIES_D | CATEGORY_ID
UOM_CODE | VARCHAR2 | 16 |  |  | This column stores the unit of measure code for the receiving shipment receipt line. | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
QUANTITY_SHIPPED | NUMBER |  |  |  | This column stores the net quantity shipped for the receiving shipment receipt line. |  |
QUANTITY_RECEIVED | NUMBER |  |  |  | This column stores the net quantity received for the receiving shipment receipt line. |  |
QUANTITY_ACCEPTED | NUMBER |  |  |  | This column stores the net quantity accepted for the receiving shipment receipt line. |  |
QUANTITY_REJECTED | NUMBER |  |  |  | This column stores the net quantity rejected for the receiving shipment receipt line. |  |
QUANTITY_DELIVERED | NUMBER |  |  |  | This column stores the net quantity delivered for the receiving shipment receipt line. |  |
QUANTITY_RETURNED | NUMBER |  |  |  | This column stores the net quantity returned for the receiving shipment receipt line. |  |
PUOM_CODE | VARCHAR2 | 16 |  |  | This column stores the primary unit of measure code for the receiving shipment receipt line. |  |
PUOM_CONVERSION_FACTOR | NUMBER |  |  |  | Conversion factor based on the Transation UOM and Primary UOM. |  |
PUOM_QUANTITY_SHIPPED | NUMBER |  |  |  | This column stores the net quantity shipped for the receiving shipment receipt line in PUOM. |  |
PUOM_QUANTITY_RECEIVED | NUMBER |  |  |  | This column stores the net quantity received for the receiving shipment receipt line in PUOM. |  |
PUOM_QUANTITY_ACCEPTED | NUMBER |  |  |  | This column stores the net quantity accepted for the receiving shipment receipt line in PUOM. |  |
PUOM_QUANTITY_REJECTED | NUMBER |  |  |  | This column stores the net quantity rejected for the receiving shipment receipt line in PUOM. |  |
PUOM_QUANTITY_DELIVERED | NUMBER |  |  |  | This column stores the net quantity delivered for the receiving shipment receipt line in PUOM. |  |
PUOM_QUANTITY_RETURNED | NUMBER |  |  |  | This column stores the net quantity returned for the receiving shipment receipt line in PUOM. |  |
SECONDARY_UOM_CODE | VARCHAR2 | 16 |  |  | This column stores the secondary unit of measure code of the inventory item in the receiving organization. |  |
SECONDARY_QUANTITY_RECEIVED | NUMBER |  |  |  | This column stores the net quantity received for the receiving shipment receipt line in the item's secondary unit of measure. |  |
SECONDARY_QUANTITY_SHIPPED | NUMBER |  |  |  | This column stores the net quantity shipped for the receiving shipment receipt line in the item's secondary unit of measure. |  |
SECONDARY_QTY_DELIVERED | NUMBER |  |  |  | This column stores the net quantity delivered for the receiving shipment receipt line in the item's secondary unit of measure. |  |
SECONDARY_QTY_RETURNED | NUMBER |  |  |  | This column stores the net quantity returned for the receiving shipment receipt line in the item's secondary unit of measure. |  |
SECONDARY_QTY_ACCEPTED | NUMBER |  |  |  | This column stores the net quantity accepted for the receiving shipment receipt line in the item's secondary unit of measure. |  |
SECONDARY_QTY_REJECTED | NUMBER |  |  |  | This column stores the net quantity rejected for the receiving shipment receipt line in the item's secondary unit of measure. |  |
RECEIPT_ADVICE_HEADER_ID | NUMBER | 38 | 0 |  | This column stores the Receipt advice header unique identifier for receiving transactions against RMA and flexible supply source documents. |  |
RECEIPT_ADVICE_LINE_ID | NUMBER | 38 | 0 |  | This column stores the Receipt advice line unique identifier for receiving transactions against RMA and flexible supply source documents. |  |
RMA_ORDER_NUMBER | VARCHAR2 | 128 |  |  | Source document number for the receipt advice. Applicable to RMA and flexible supply source documents. |  |
RMA_ORDER_HEADER_ID | NUMBER | 38 | 0 |  | This field will store the Orignal Sales Order header_id | DW_DOO_FULFILL_LINES_EN | HEADER_ID
RMA_ORDER_LINE_ID | NUMBER | 38 | 0 |  | This field will store the Orignal Sales Order Line Id |  |
RMA_ORDER_LINE_NUMBER | VARCHAR2 | 128 |  |  | Source document line number for the receipt advice line. Applicable to RMA and flexible supply source documents. |  |
RMA_FULFILL_LINE_NUMBER_UNSPLIT | VARCHAR2 | 128 |  |  | Unsplit Fulfillment line number reference in Distributed Order Orchestration corresponding to the RMA. |  |
RMA_FULFILL_LINE_ID_UNSPLIT | NUMBER | 38 | 0 |  | Unsplit Fulfillment line id reference in Distributed Order Orchestration corresponding to the RMA. |  |
RMA_DOC_LINE_CREATION_DATE | TIMESTAMP |  |  |  | Source document line creation date for Receipt advice line. Applicable to RMA and flexible supply source documents. |  |
RMA_EXPECTED_RECEIPT_DATE | DATE |  |  |  | Expected arrival date for Receipt advice line. Applicable to RMA and flexible supply source documents. |  |
RMA_EXPECTED_RETURN_QTY | NUMBER |  |  |  | Expected Quantity to be received for the receipt advice line. |  |
ORIG_SALES_ORDER_NUMBER | VARCHAR2 | 128 |  |  | Original Sales order number reference corresponding to the RMA. |  |
ORIG_SALES_ORDER_LINE_NUMBER | VARCHAR2 | 128 |  |  | Original Sales order line number reference corresponding to the RMA. |  |
ORIG_SOURCE_ORDER_NUMBER | VARCHAR2 | 128 |  |  | Reference to the number of the originating sales order |  |
ORIG_SOURCE_LINE_NUMBER | VARCHAR2 | 128 |  |  | Reference to the number of the originating sales order line |  |
RMA_ORDER_STATUS | VARCHAR2 | 32 |  |  | Status of the orchestration order for Original Sales Order | DW_DOO_FULFILL_LINES_EN | H_STATUS_CODE
RMA_ORDER_TYPE_CODE | VARCHAR2 | 32 |  |  | Type of original Sales order that was placed. | DW_DOO_FULFILL_LINES_EN | H_ORDER_TYPE_CODE
RMA_ORDERED_DATE | DATE |  |  |  | Date when the items where ordered | DW_DOO_FULFILL_LINES_EN | H_ORDERED_DATE
RMA_DISPLAY_LINE_NUMBER | VARCHAR2 | 128 |  |  | Line number for display purposes | DW_DOO_FULFILL_LINES_EN | L_DISPLAY_LINE_NUMBER
RMA_DISPLAY_FULFILL_LINE_NUM_UNSPLIT | VARCHAR2 | 256 |  |  | Unsplit Fulfill Line number for display purposes. Corresponds to the Fulfill line number on UI |  |
RMA_FULFILL_LINE_STATUS_UNSPLIT | VARCHAR2 | 32 |  |  | Current fulfillment status of the unsplit fulfillment line. | DW_DOO_FULFILL_LINES_EN | STATUS_CODE
RETURN_LINE_TYPE_CODE | VARCHAR2 | 32 |  |  | Defines the system behavior for the order line transaction, in terms of values required, defaulted, and displayed. | DW_DOO_FULFILL_LINES_EN | LINE_TYPE_CODE
RETURN_REASON_CODE | VARCHAR2 | 32 |  |  | Justification for a return of a specific product. Many companies have standard reasons that are assigned to returns to be used to analyze the quantity and types of returns. | DW_DOO_FULFILL_LINES_EN | RETURN_REASON_CODE
TRANSFER_ORDER_HEADER_ID | NUMBER | 38 | 0 |  | Transfer Order Header Id |  |
TRANSFER_ORDER_NUMBER | VARCHAR2 | 64 |  |  | Transfer Order Number |  |
TRANSFER_ORDER_LINE_ID | NUMBER | 38 | 0 |  | Transfer Order Line Id |  |
TRANSFER_ORDER_LINE_NUMBER | NUMBER | 38 | 0 |  | Transfer Order Line Number |  |
TRANSFER_ORDER_ORIGIN_TYPE | VARCHAR2 | 32 |  |  | Source from where this order was requested. Eg. SSP/Planning/Return/Min-Max | DW_INV_TRANSFER_ORDER_LINES_EN | H_SOURCE_TYPE_LOOKUP
TRANSFER_ORDER_CREATION_DATE | DATE |  |  |  | Who column: indicates the date and time of the creation of the transfer order row | DW_INV_TRANSFER_ORDER_LINES_EN | H_CREATION_DATE
TRANSFER_ORDER_LINE_STATUS | VARCHAR2 | 32 |  |  | Indicates whether line is OPEN/CLOSED/CANCELLED | DW_INV_TRANSFER_ORDER_LINES_EN | STATUS_LOOKUP
TRANSFER_ORDER_FULFILL_STATUS | VARCHAR2 | 128 |  |  | Transfer Order Line fulfilment Status |  |
TRANSFER_ORDER_DESTINATION_TYPE | VARCHAR2 | 32 |  |  | Destination type, whether Inventory or Expense | DW_INV_TRANSFER_ORDER_LINES_EN | DESTINATION_TYPE_LOOKUP
TRANSFER_ORDER_REQ_BU_ID | NUMBER | 38 | 0 |  | Business Unit for requesting organization | DW_INV_TRANSFER_ORDER_LINES_EN | REQ_BU_ID
TRANSFER_ORDER_REQ_ID | NUMBER | 38 | 0 |  | Reference to unique identifier of requisition number from which this Transfer Order was created | DW_INV_TRANSFER_ORDER_LINES_EN | REQUISITION_ID
TRANSFER_ORDER_REQ_LINE_ID | NUMBER | 38 | 0 |  | Reference to unique identifier of the requisition line number from which this Transfer order line was created | DW_INV_TRANSFER_ORDER_LINES_EN | REQUISITION_LINE_ID
TRANSFER_ORDER_REQ_NUMBER | VARCHAR2 | 64 |  |  | Reference to requisition number from which this Transfer Order was created | DW_INV_TRANSFER_ORDER_LINES_EN | REQUISITION_NUMBER
TRANSFER_ORDER_REQ_LINE_NUMBER | NUMBER |  |  |  | Reference to requisition line number from which this Transfer order line was created | DW_INV_TRANSFER_ORDER_LINES_EN | REQUISITION_LINE_NUMBER
SUPPLY_ORDER_REFERENCE_NUMBER | VARCHAR2 | 256 |  |  | Reference number of the requesting system | DW_INV_TRANSFER_ORDER_LINES_EN | SUPPLY_ORDER_REFERENCE_NUMBER
TRANSFER_ORDER_NEED_BY_DATE | DATE |  |  |  | Date this transfer order line is requested for arrival |  |
TRANSFER_ORDER_SCH_SHIP_DATE | DATE |  |  |  | Date this transfer order is scheduled to ship |  |
TRANSFER_ORDER_REQUESTED_QTY | NUMBER |  |  |  | This is the quantity requested in Transfer Order | DW_INV_TRANSFER_ORDER_LINES_EN | REQUESTED_QTY
TRANSFER_ORDER_SHIPPED_QTY | NUMBER |  |  |  | This column stores the quantity shipped in Transfer Order | DW_INV_TRANSFER_ORDER_LINES_EN | SHIPPED_QTY
DEFAULT_DEST_SUBINVENTORY | VARCHAR2 | 16 |  |  | This column stores the default destination subinventory in the receiving organization. |  |
DEFAULT_LOCATOR_ID | NUMBER | 38 | 0 |  | This column stores the default destination locator unique identifier in the receiving organization. |  |
TRANSACTION_DATE | DATE |  |  |  | Receiving date of goods/services. In case of multiple receive transactions for the shipment line, this column will hold the latest transaction date for RECEIVE or UNORDERED transactions. This is used for receving cycle time calculations. |  |
RECEIVED_DATE | DATE |  |  |  | This column stores the latest transaction date for a receipt. This field can be seen as Received Date attribute in the transfer orders view receipt details fusion UI. |  |
DELIVER_DATE | DATE |  |  |  | Delivery date of goods/services. In case of multiple deliver transactions for the shipment line, this column will hold the latest transaction date for DELIVER transactions. |  |
RECEIPT_CORRECTION_FLAG | VARCHAR2 | 32 |  |  | Indicates if the shipment line contains any correction transaction. Values are YES, NO. | DW_Y_N_D_TL | CODE
RECEIPT_REJECTED_FLAG | VARCHAR2 | 32 |  |  | Indicates if shipment line has Rejected Quantity > 0 Values are Y,N. | DW_Y_N_D_TL | CODE
RECEIPT_RETURNED_FLAG | VARCHAR2 | 32 |  |  | Indicates if shipment line has Returned Quantity > 0 Values are Y,N. | DW_Y_N_D_TL | CODE
RECEIPT_ACCEPTED_FLAG | VARCHAR2 | 32 |  |  | Indicates if shipment line has Accepted Quantity > 0 Values are Y,N. | DW_Y_N_D_TL | CODE
EARLY_DELIVERY_FLAG | VARCHAR2 | 32 |  |  | Indicates if shipment was received early. RECEIPT DATE < PROMISED DELIVEY DATE, if null NEED BY DATE. Value will be N if any one of the date attributes are NULL. | DW_Y_N_D_TL | CODE
ONTIME_DELIVERY_FLAG | VARCHAR2 | 32 |  |  | Indicates if shipment was received on-time. RECEIPT DATE = PROMISED DELIVEY DATE, if null NEED BY DATE. Value will be N if any one of the date attributes are NULL. | DW_Y_N_D_TL | CODE
LATE_DELIVERY_FLAG | VARCHAR2 | 32 |  |  | Indicates if shipment was received late. RECEIPT DATE > PROMISED DELIVEY DATE, if null NEED BY DATE. Value will be N if any one of the date attributes are NULL. | DW_Y_N_D_TL | CODE
RCV_HDR_CREATION_DATE | DATE |  |  |  | Indicates the date of the creation of the header row. |  |
RCV_LINE_CREATION_DATE | DATE |  |  |  | Indicates the date of the creation of the receipt line. |  |
RCV_LINE_CREATION_TIMESTAMP | TIMESTAMP |  |  |  | Indicates the date and time of the creation of the receipt line. |  |
RCV_HDR_CREATED_BY | VARCHAR2 | 128 |  |  | Indicates the user who created the header row. |  |
RCV_LINE_CREATED_BY | VARCHAR2 | 128 |  |  | Indicates the user who created the row. |  |

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