This table requires activation of Receiving functional area. This table stores information about items that have been shipped and/or received from a specific receipt source.
Module: Receiving
SHIPMENT_LINE_ID
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. Value is derived from a combination of code type and code. | ||||
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 |
#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, 2024, Oracle and/or its affiliates.