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 This column is for Oracle Internal use only. 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.