DW_INV_RECEIPT_LOT_SERIALNUMBER_CF

Inventory Receipt Lot and Serial Number Details

Details

Module: Inventory Management

Key Columns

SHIPMENT_LINE_ID, LOT_NUMBER, SERIAL_NUMBER

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SHIPMENT_LINE_ID NUMBER 38 0 True This column stores the receiving shipment receiving receipt line unique identifier    
LOT_NUMBER VARCHAR2 128   True This number identifies an inventory lot    
SERIAL_NUMBER VARCHAR2 128   True This stores the item unit number    
SOURCE_RECORD_ID VARCHAR2 512     This column is concat of Transaction_id , lot number and serial number    
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 4000     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.    
RECEIVED_BY NUMBER 38 0   This column stores the Unique identifier for the person who created the receiving transaction. DW_PERSON_NAME_CURRENT_D PERSON_ID
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   This column will store the unsplit fulfillment line id 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 64     Reference to the number of the originating sales order    
ORIG_SOURCE_LINE_NUMBER VARCHAR2 64     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_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.    
DELIVERED_LOT_PRIMARY_QTY NUMBER       Delivered Lot Transacted Quantity, in the item's primary unit of measure    
DELIVERED_DETAILED_PRIMARY_QTY NUMBER       Derived delivered quantity in the item's primary unit of measure for aggregation at lot/serial level    
DELIVERED_LOT_SECONDARY_QTY NUMBER       Delivered Lot secondary transaction quantity.    
RETURNED_LOT_PRIMARY_QTY NUMBER       Returned Lot Transacted Quantity, in the item's primary unit of measure    
RETURNED_DETAILED_PRIMARY_QTY NUMBER       Derived returned transaction quantity for aggregation at lot/serial level    
RETURNED_LOT_SECONDARY_QTY NUMBER       Returned Lot secondary transaction quantity.