ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF
Manages detailed serial number information via descriptive flexfields for serial-controlled items.
Columns
| Name | Type | Description |
| ReceivingReceiptTransactionRequestsInterfaceTransactionId [KEY] | Long | Unique identifier for the transaction in the ReceivingReceiptTransactionRequestsInterface table. This value represents the link between the transaction and its associated details in the lot and serial item record. |
| LotserialitemlotsLotNumber [KEY] | String | The number assigned to the lot within which items are stored or tracked. This identifier allows for the grouping and management of serial-controlled items within the warehouse or inventory system. |
| LotserialitemserialsFromSerialNumber [KEY] | String | The starting serial number for the serial-controlled items in the given lot. This value helps in identifying the range of serial numbers for items managed within a particular lot. |
| TransactionInterfaceId [KEY] | Long | A reference to the unique identifier used in the receiving transaction interface. This value connects to the overall transaction data recorded for processing and tracking within Oracle SCM. |
| FromSerialNumber [KEY] | String | The serial number of the item being processed, starting from this number for serial-controlled items. This number is used to track the individual items through the receiving process. |
| _FLEX_Context | String | The context of the descriptive flexfield (DFF) for serials, used to capture additional custom attributes or metadata related to serial-controlled items. This attribute is relevant when the warehouse uses both lot and serial control for items. |
| _FLEX_Context_DisplayValue | String | The display value for the descriptive flexfield context. This is used to provide a human-readable reference for the context applied to the serial-controlled items under lot and serial control. |
| DocumentNumber | String | The document number associated with the receiving transaction, helping to track the original document that initiated the transaction for the lot and serial-controlled items. |
| ExternalSystemTransactionReference | String | A reference number used to link this receiving transaction to an external system. This is typically used for integration between Oracle SCM and external enterprise resource planning (ERP) or warehouse management systems. |
| Finder | String | The identifier used to locate or find specific records within the receiving transaction system for lot and serial-controlled items. This could refer to a search term or index used during transaction processing. |
| FromDate | Datetime | The date when the receiving transaction starts or is initiated for serial-controlled items. This helps define the timeframe for the processing of items under lot and serial control. |
| GroupId | Long | An identifier used to group related receiving transactions, allowing for batch processing or association of multiple items under a single transaction or event. |
| InterfaceTransactionId | Long | A unique identifier for the transaction in the interface system, used to track and reconcile transactions between Oracle SCM and external systems. |
| ItemId | String | The identifier for the item being received. This links to the specific item in the inventory, with associated attributes like item number, descriptions, and classifications. |
| ItemNumber | String | The unique number assigned to the item being processed in the transaction. This value is used for inventory management and traceability of items throughout the supply chain. |
| OrganizationCode | String | The code representing the organization or business unit that is responsible for the receiving transaction. This helps identify where the transaction originates within the enterprise structure. |
| OrganizationId | String | The unique identifier for the organization handling the receiving transaction. It links the transaction to the specific business unit or division managing the inventory. |
| POHeaderId | Long | The purchase order header ID associated with this receiving transaction. This reference connects the receiving details to the original purchase order from which the items were procured. |
| ProcessingStatusCode | String | The code indicating the current processing status of the transaction. This could be 'Pending,' 'Completed,' or other status codes that help identify where the transaction is in the process flow. |
| ReceiptAdviceHeaderId | Long | The identifier for the receipt advice header, used to document the receipt of goods or services in the system. This is important for verifying the receipt of items against purchase orders or other transactions. |
| RMANumber | String | The return material authorization (RMA) number linked to the receiving transaction. This reference indicates that the items being processed are part of a return or exchange transaction. |
| ShipmentHeaderId | Long | The unique identifier for the shipment associated with this receiving transaction. It allows the transaction to be linked to a specific shipment event, facilitating tracking and auditing of items as they move through the supply chain. |
| ShipmentNumber | String | The shipment number that references the specific shipment event from which the items are being received. This helps in tracking the movement of goods from the sender to the receiving location. |
| SourceDocumentCode | String | The code used to reference the original document or transaction that initiated the receipt of items. This can be used for tracking the origins of the items being processed. |
| ToDate | Datetime | The date when the receiving transaction is completed or finalized. This marks the end of the period during which the items were processed and recorded in the receiving system. |
| TransactionStatusCode | String | The code indicating the status of the receiving transaction. This code helps track whether the transaction is 'Completed,' 'Failed,' 'Pending,' or in another status during processing. |
| TransactionType | String | The type of transaction being processed, such as 'Receiving,' 'Return,' or 'Transfer.' This helps define the nature of the transaction and the expected processing behavior. |
| TransferOrderHeaderId | Long | The identifier for the transfer order associated with the receiving transaction. This value connects the transaction to an internal movement or transfer of goods between locations. |