DW_RCV_TXN_LOT_SERIALNUMBER_CF

This is table stores the Lot & Serial number information associated with RCV transations. This will contain only those transactions which have been assigned to lot and/or serial numbers

Details

Module: Purchasing

Key Columns

TRANSACTION_ID, SERIAL_NUMBER, LOT_NUMBER

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
TRANSACTION_ID NUMBER 38 0 True This column stores the unique identifier for the current receiving transaction row.    
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 256     Source record identifier.    
SHIPMENT_HEADER_ID NUMBER 38 0   This column stores the receiving shipment receiving receipt header unique identifier    
RECEIPT_NUMBER VARCHAR2 32     This column stores the receipt number for the receiving shipment receipt header row.    
SHIPMENT_LINE_ID NUMBER 38 0   This column stores the receiving shipment receiving receipt line unique identifier    
LINE_NUM NUMBER 38 0   This column stores the number corresponding to the shipment line.    
SOURCE_DOCUMENT_CODE VARCHAR2 32     This column stores the source document code for the receiving transactions. Maps to lookup_type is RCV_SOURCE_DOCUMENT_TYPE.    
TRANSACTION_TYPE VARCHAR2 32     Receiving transaction type.Maps to lookup_type is RCV_TRANSACTION_TYPE.    
TRANSACTION_DATE DATE       This column stores the transaction date for the receiving transactions.    
ORGANIZATION_ID NUMBER 38 0   This column stores Receiving organization unique identifier where the receiving transaction is created. DW_INV_ORGANIZATION_D INV_ORGANIZATION_ID
SUBINVENTORY VARCHAR2 16     This column stores the destination subinventory name for the receiving transaction.    
LOCATOR_ID NUMBER 38 0   This column stores the destination locator unique identifier for the receiving transaction.    
CREATION_DATE TIMESTAMP       Who column: indicates the date and time of the creation of the row.    
CREATED_BY VARCHAR2 128     Who column: indicates the user who created the row.    
DESTINATION_TYPE_CODE VARCHAR2 32     This column stores the destination type code when the receiving transaction is created.    
LOCATION_ID NUMBER 38 0   This column stores the deliver or receive to location unique identifier.    
DELIVER_TO_PERSON_ID NUMBER 38 0   This column stores the deliver to person, or requester, unique identifier.    
EMPLOYEE_ID NUMBER 38 0   This column stores the Unique identifier for the person who created the receiving transaction. DW_PERSON_NAME_CURRENT_D PERSON_ID
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.    
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.    
ITEM_REVISION VARCHAR2 32     This column stores the revision number of the inventory item.    
QUANTITY NUMBER       This column stores the destination subinventory name for deliver transaction type.    
UOM_CODE VARCHAR2 16     This column stores the unit of measure code for the receiving transaction.    
PRIMARY_QUANTITY NUMBER       Receiving Transaction quantity in terms of the item's primary unit of measure.    
PRIMARY_UOM_CODE VARCHAR2 16     This column stores the primary unit of measure code of the item in the receiving organization.    
SECONDARY_QUANTITY NUMBER       This column stores the receiving transaction quantity in the item's secondary unit of measure.    
SECONDARY_UOM_CODE VARCHAR2 16     This column stores the secondary unit of measure code of the inventory item.    
LOT_TRANSACTION_QUANTITY NUMBER       Transaction quantity, in the user's current unit of measure    
LOT_PRIMARY_QUANTITY NUMBER       Transacted Quantity, in the item's primary unit of measure    
LOT_SECONDARY_QUANTITY NUMBER       This is the secondary transaction quantity.    
DETAILED_PRIMARY_QTY NUMBER       This is a derived quantities based on Serial Number and Lot numbers association.    
PARENT_TRANSACTION_ID NUMBER 38 0   This column stores the unique identifier of the parent receiving transaction.    
DELIVER_TO_LOCATION_ID NUMBER 38 0   This column stores the deliver to location unique identifier.    
PROJECT_ID NUMBER 38 0   Identifier of the project corresponding to the source document and is propagated to the inventory transactions.    
TASK_ID NUMBER 38 0   Identifier of the task corresponding to the source document and is propagated to the inventory transactions.    
SUBINVENTORY_LOCATION_ID NUMBER 38 0   This identifies the item locator.    
INSPECTION_STATUS_CODE VARCHAR2 32     This column stores the inspection status code. Valid Values are NOT INSPECTED, ACCEPTED, REJECTED.    
REASON_ID NUMBER 38 0   This column stores the inventory transaction reason unique identifier.    
COUNTRY_OF_ORIGIN_CODE VARCHAR2 16     This column stores the code for the country of manufacture.    

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