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
Module: Purchasing
TRANSACTION_ID, SERIAL_NUMBER, LOT_NUMBER
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. | |||
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, 2022, Oracle and/or its affiliates.