Inventory Receipts
Module: Inventory Management
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 | 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, 2023, Oracle and/or its affiliates.