# DW_RECEIVING_CF

This table stores information about items that have been shipped and/or received from a specific receipt source.

## Details

Module: Receiving

## 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_HEADER_CREATION_DATE | DATE |  |  |  | Indicates the date of the creation of the header row. | DW_DAY_D | CALENDAR_DATE
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. |  |
EXPECTED_RECEIPT_DATE | DATE |  |  |  | This column stores the Expected arrival date of the shipment. | DW_DAY_D | CALENDAR_DATE
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. | DW_DAY_D | CALENDAR_DATE
ASN_TYPE | VARCHAR2 | 32 |  |  | ASN (Advanced Shipment Notification) type of the shipment. Valid values are ASN, ASBN and STD for a receipt. | DW_RCV_ASN_TYPE_D_TL | CODE
SHIP_TO_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Inventory organization unique identifier where the receipt and shipment are created. | DW_INV_ORGANIZATION_D | INV_ORGANIZATION_ID
BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Inventory organization business unit identifier | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_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. | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
LEDGER_ID | NUMBER | 38 | 0 |  | Business unit primary ledger identifier. | DW_LEDGER_D | LEDGER_ID
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | Accounting calendar name based on primary ledger of requisition org. #2 | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | Accounting period type based on primary ledger of requisition org. #2 | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
FISCAL_PERIOD_NAME | VARCHAR2 | 64 |  |  | Accounting period name. |  |
SHIPMENT_LINE_NUM | NUMBER | 38 | 0 |  | This column stores the number corresponding to the shipment line. |  |
DOCUMENT_TYPE | VARCHAR2 | 32 |  |  | Source document code for the receiving transactions. Values are PO,RMA, INVENTORY and TRANSFER ORDER. | DW_RCV_SOURCE_DOCUMENT_TYPE_D_TL | CODE
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
CONSIGNED_FLAG | VARCHAR2 | 16 |  |  | This column if the receipt line is created for consigned material. Values are Y/N/NO VALUE | DW_Y_N_D_TL | CODE
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
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. | DW_WORKER_LOCATION_D | LOCATION_ID
CREATED_BY | VARCHAR2 | 128 |  |  | Indicates the user who created the header row. | DW_USER_D | USERNAME
DELIVER_TO_PERSON_ID | NUMBER | 38 | 0 |  | This column stores the deliver to person, or requester, unique identifier. | DW_PERSON_NAME_CURRENT_D | PERSON_ID
SHIPMENT_LINE_CREATION_TIMESTAMP | TIMESTAMP |  |  |  | Indicates the timestamp of the creation of the receipt line |  |
SHIPMENT_LINE_CREATION_DATE | DATE |  |  |  | Indicates the date of the creation of the receipt line. #2 | DW_DAY_D | CALENDAR_DATE
SOURCE_ORGANIZATION_ID | NUMBER | 38 | 0 |  | From organization unique identifier for in-transit shipment lines. | DW_INV_ORGANIZATION_D | INV_ORGANIZATION_ID
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). |  |
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. #1 | 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
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 > . Values are Y,N. | DW_Y_N_D_TL | CODE
RECEIPT_RETURNED_FLAG | VARCHAR2 | 32 |  |  | Indicates if shipment line has Returned Quantity > . Values are Y,N. | DW_Y_N_D_TL | CODE
RECEIPT_ACCEPTED_FLAG | VARCHAR2 | 32 |  |  | Indicates if shipment line has Accepted Quantity = Received Quantity. Values are Y,N. | DW_Y_N_D_TL | CODE
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. |  |
QUANTITY_CONSUMED | NUMBER |  |  |  | Supplier consigned Inventory consumed quantity. |  |
PUOM_CODE | VARCHAR2 | 16 |  |  | This column stores the primary unit of measure code for the receiving shipment receipt line. | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
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. |  |
PUOM_QUANTITY_CONSUMED | NUMBER |  |  |  | Supplier consigned Inventory consumed quantity in PUOM. |  |
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
SECONDARY_QTY_RECEIVED | NUMBER |  |  |  | This column stores the net quantity received for the receiving shipment receipt line in the item's secondary unit of measure. |  |
SECONDARY_QTY_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. |  |
RECEIVED_AMOUNT_NON_QTY | NUMBER |  |  |  | Amount received for a fixed price service receipt line in Purchase Order currency. |  |
PO_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Purchase Order currency code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Global currency code which is valide for Purchase Order documents. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
GLOBAL_CURRENCY_EXCH_RATE | NUMBER |  |  |  | Global Exchange Rate from Purchase order Currency to Global Currency code. |  |
GLOBAL_RECEIVED_AMOUNT_NON_QTY | NUMBER |  |  |  | Amount received for a fixed price service receipt line in Global Currency. |  |
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. | DW_DAY_D | CALENDAR_DATE
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. | DW_DAY_D | CALENDAR_DATE
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. | DW_DAY_D | CALENDAR_DATE
SUBSTITUTE_ITEM_FLAG | VARCHAR2 | 32 |  |  | Indicates if receipt line is a substitute item for Purchase Order Documents. Values are Y,N. | DW_Y_N_D_TL | CODE
DOCUMENT_NUMBER | VARCHAR2 | 128 |  |  | Based on document type relevant document number are populated. |  |
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
PROCESSING_TIME | NUMBER |  |  |  | Indicates no. of days to receive goods after Purchase Order Approved or Transfer Order Created or RMA Submitted Date or Shipment creation for Interorg . Value will be NULL if any one of the date attributes are NULL. In cases of Back dated receipts values will be clapped to 0 . |  |
TRANSPORTATION_TIME | NUMBER |  |  |  | Indicates no. of days to received goods after it is shipped. Applicable only for ASN based shipments. RECEIPT HEADER CREATION DATE - SHIPPED DATE Value will be NULL if any one of the date attributes are NULL. |  |
POST_PROCESSING_TIME | NUMBER |  |  |  | Indicates no. of days to deliver goods to requester after receiving the goods. DELIVER DATE - RECEIPT DATE Value will be NULL if any one of the date attributes are NULL. Value will change in cases where line is not fully delivered. |  |
PO_HEADER_ID | NUMBER | 38 | 0 |  | This column stores the purchase order header unique identifier. |  |
PURCHASE_ORDER_NUMBER | VARCHAR2 | 128 |  |  | Purchase Order Number for PO Document. |  |
PO_APPROVED_DATE | DATE |  |  |  | Date on which first version of purchase order was approved. | DW_DAY_D | CALENDAR_DATE
SUPPLIER_ID | NUMBER | 38 | 0 |  | Supplier unique identifier. | DW_PARTY_D | SUPPLIER_ID
SUPPLIER_SITE_ID | NUMBER | 38 | 0 |  | Supplier site unique identifier. | DW_SUPPLIER_SITE_D | SUPPLIER_SITE_ID
BUYER_ID | NUMBER | 38 | 0 |  | Buyer unique identifier. | DW_PERSON_NAME_CURRENT_D | PERSON_ID
PO_LINE_ID | NUMBER | 38 | 0 |  | This column stores the purchase order line unique identifier. |  |
PO_LINE_NUMBER | NUMBER |  |  |  | Purchase order line number. |  |
PO_LINE_LOCATION_ID | NUMBER | 38 | 0 |  | This column stores the purchase order schedule unique identifier. |  |
PO_LINE_LOCATION_NUMBER | NUMBER |  |  |  | Purchase order line location (schedule) number. |  |
PO_SCHEDULE_UOM_CODE | VARCHAR2 | 16 |  |  | Unit of measure code for the purchase order line. | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
PO_SCHEDULE_QTY | NUMBER |  |  |  | Purchase order line location quantity ordered. |  |
PO_NEED_BY_DATE | DATE |  |  |  | Date that the buying company requests the ordered item or service to be delivered. | DW_DAY_D | CALENDAR_DATE
PO_PROMISED_DELIVERY_DATE | DATE |  |  |  | Date that the supplier has promised to deliver the ordered item or service. | DW_DAY_D | CALENDAR_DATE
ASN_BASED_FLAG | VARCHAR2 | 32 |  |  | Indicates if receipt line is ASN or ASBN based. Values are Y,N. | DW_Y_N_D_TL | CODE
PO_MANUFACTURER | VARCHAR2 | 999 |  |  | Name of the company that manufactures the item being purchased. |  |
PO_WORK_ORDER_ID | NUMBER | 38 | 0 |  | Unique identifier for the work order |  |
PO_WORK_ORDER_OPERATION_ID | NUMBER | 38 | 0 |  | The unique identifier of a work order operation |  |
PO_WORK_ORDER_NUMBER | VARCHAR2 | 128 |  |  | Number of the manufacturing work order. |  |
PO_WORK_ORDER_OPERATION_SEQ | NUMBER |  |  |  | Indicates execution sequence of the work order operation. |  |
SALES_BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | This column stores the unique identifier of the business unit in which the RMA was created. | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
CUSTOMER_ID | NUMBER | 38 | 0 |  | Customer unique identifier. Applicable for RMA transactions. | DW_PARTY_D | PARTY_ID
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 |  |
RMA_ORDER_STATUS | VARCHAR2 | 32 |  |  | Status of the orchestration order | DW_OM_STATUS_D | STATUS_CODE
RMA_ORDER_TYPE_CODE | VARCHAR2 | 32 |  |  | Name of the type of order that was placed. | DW_ORDER_TYPE_LKP_TL | ORDER_TYPE_CODE
RMA_ORDERED_DATE | DATE |  |  |  | Date when the items where ordered | DW_DAY_D | CALENDAR_DATE
RMA_SUBMITTED_DATE | DATE |  |  |  | Date when the RMA is submitted. | DW_DAY_D | CALENDAR_DATE
RMA_FULFILL_LINE_NUMBER_UNSPLIT | VARCHAR2 | 128 |  |  | Unsplit Fulfillment line number reference in Distributed Order Orchestration corresponding to the RMA. |  |
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_OM_STATUS_D | STATUS_CODE
RMA_FULFILL_LINE_ID_UNSPLIT | NUMBER | 38 | 0 |  | Unsplit Fulfillment line id reference in Distributed Order Orchestration corresponding to the RMA. |  |
RETURN_LINE_TYPE_CODE | VARCHAR2 | 32 |  |  | Defines the system behavior for the order line transaction, in terms of values required, defaulted, and displayed. | DW_ORDER_RETURN_TYPE_LKP_TL | ORDER_RETURN_TYPE_CODE
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_LINE_ID | NUMBER | 38 | 0 |  | This field will store the Orignal Sales Order Line Id |  |
RMA_EXPECTED_RECEIPT_DATE | DATE |  |  |  | Expected arrival date for Receipt advice line. Applicable to RMA and flexible supply source documents. | DW_DAY_D | CALENDAR_DATE
RMA_UOM_CODE | VARCHAR2 | 16 |  |  | This column stores the unit of measure code for the RMA Expected QTY. | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
RMA_EXPECTED_RETURN_QTY | NUMBER |  |  |  | Expected Quantity to be received for the receipt advice line. |  |
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_RETURN_REASON_LKP_TL | RETURN_REASON_CODE
TRANSFER_ORDER_HEADER_ID | NUMBER | 38 | 0 |  | Transfer Order Header Id |  |
TRANSFER_ORDER_NUMBER | VARCHAR2 | 128 |  |  | Transfer Order Number for transfer order documents. |  |
TRANSFER_ORDER_ORIGIN_TYPE | VARCHAR2 | 32 |  |  | Source from where this order was requested. Eg. SSP/Planning/Return/Min-Max | DW_INV_TO_ORIGIN_TYPE_TL | CODE
TRANSFER_ORDER_CREATION_DATE | DATE |  |  |  | Transfer Order Creation date. | DW_DAY_D | CALENDAR_DATE
TRANSFER_ORDER_LINE_ID | NUMBER | 38 | 0 |  | Transfer Order Line Id |  |
TRANSFER_ORDER_LINE_NUMBER | NUMBER | 38 | 0 |  | Transfer Order Line Number |  |
TRANSFER_ORDER_LINE_STATUS | VARCHAR2 | 32 |  |  | Indicates whether line is OPEN/CLOSED/CANCELLED | DW_INV_TO_LINE_STATUS_TL | CODE
TRANSFER_ORDER_FULFILL_STATUS | VARCHAR2 | 128 |  |  | Transfer Order Line fulfilment Status | DW_INV_TO_FULFILL_STATUS_TL | CODE
TRANSFER_ORDER_NEED_BY_DATE | DATE |  |  |  | Date this transfer order line is requested for arrival | DW_DAY_D | CALENDAR_DATE
TRANSFER_ORDER_SCHEDULE_SHIP_DATE | DATE |  |  |  | Date this transfer order is scheduled to ship | DW_DAY_D | CALENDAR_DATE
TRANSFER_ORDER_REQ_BU_ID | NUMBER | 38 | 0 |  | Business Unit for requesting organization | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
TRANSFER_ORDER_REQ_NUMBER | VARCHAR2 | 64 |  |  | Reference to requisition number from which this Transfer Order was created |  |
TRANSFER_ORDER_REQ_ID | NUMBER | 38 | 0 |  | Transfer Order Requisition header identifier |  |
TRANSFER_ORDER_REQ_LINE_NUMBER | NUMBER |  |  |  | Reference to requisition line number from which this Transfer order line was created |  |
TRANSFER_ORDER_REQ_LINE_ID | NUMBER | 38 | 0 |  | Transfer Order Requisition Line identifier |  |
SUPPLY_ORDER_REFERENCE_NUMBER | VARCHAR2 | 256 |  |  | Reference number of the requesting system |  |
TRANSFER_ORDER_UOM_CODE | VARCHAR2 | 16 |  |  | This column stores the unit of measure code at transfer Order | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
TRANSFER_ORDER_REQUESTED_QTY | NUMBER |  |  |  | This is the quantity requested in Transfer Order |  |
TRANSFER_ORDER_SHIPPED_QTY | NUMBER |  |  |  | This column stores the quantity shipped in Transfer Order |  |

## 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 to join with DW_FISCAL_DAY_D apart from FISCAL_PERIOD_TYPE and FISCAL_PERIOD_SET_NAME the relationship should be based on SHIPMENT_LINE_CREATION_DATE column.

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